Hi Guys,

I'hv one package PACK_SHIP_CONFIRM (it will do all the process like creating batches,releasing batches,pick release,shipment of an order line) and a procedure update_ship_id_proc (it is used for client's requirement that if ship_from_org_id of an booked order line is different from the one that is passed than we have to update the ship_from_org_id of the order line to the one that has been passed to the xx_tni_update_ship_id_proc )

Now, update_ship_id_proc is working fine when run from backend separately (by passing parameters directly to this procedure ).
But with package PACK_SHIP_CONFIRM there are two scenario's.

1)When an order has more than one line and only first line is passed to the package PACK_SHIP_CONFIRM for shipment and ship_from_org_id is passed different to the one that is there on orderline so it has to be updated through update_ship_id_proc procedure.Every thing works fine. line gets shipped and ship_from_org_id also gets updated.But when we pass remaining order lines one by one or all remaining lines in one go then ship_from_org_id do not gets updated and update_ship_id_proc gives an status of 'U' and error of "ORA-01403: no data found in Package oe_line_util Procedure Update_Row".

2) When an order has more than one line and all lines are passed in one go then also I'm facing the same error as explained above.

If Anyone has any suggestions regarding the above problem then do please reply as it is an high priority issue .