702:
703: -- Release 12: LPN SyncUP
704: -- In addition to the LPN context update
705: -- WDD records also need to be removed
706: -- This is done by calling wms_container_pvt.modify_lpn API
707: -- Remove the direct update here
708: -- Call modify_lpn API after backorder
709: /*open lpn_csr(l_delivery_details_id_table(l_table_index));
710: LOOP
790: -- Release 12: LPN SyncUP
791: -- Call modify_lpn API to update lpn context to 1
792: -- and remove associated WDD lines
793: IF(l_debug = 1) THEN
794: DEBUG('Calling WMS_CONTAINER_PVT.Modify_LPNs with caller WMS_SHIPPING','INV_RETURN_TO_STOCK');
795: END IF;
796:
797: WMS_CONTAINER_PVT.Modify_LPNs(
798: p_api_version => 1.0
793: IF(l_debug = 1) THEN
794: DEBUG('Calling WMS_CONTAINER_PVT.Modify_LPNs with caller WMS_SHIPPING','INV_RETURN_TO_STOCK');
795: END IF;
796:
797: WMS_CONTAINER_PVT.Modify_LPNs(
798: p_api_version => 1.0
799: , p_init_msg_list => fnd_api.g_true
800: , p_commit => fnd_api.g_false
801: , x_return_status => l_return_status
805: , p_lpn_table => l_lpn_tbl
806: );
807: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
808: IF (l_debug = 1) THEN
809: DEBUG('return error from WMS_CONTAINER_PVT.Modify_LPNs', 'INV_RETURN_TO_STOCK');
810: END IF;
811: RAISE fnd_api.g_exc_error;
812: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
813: IF (l_debug = 1) THEN
810: END IF;
811: RAISE fnd_api.g_exc_error;
812: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
813: IF (l_debug = 1) THEN
814: DEBUG('return error from WMS_CONTAINER_PVT.Modify_LPNs', 'INV_RETURN_TO_STOCK');
815: END IF;
816: RAISE fnd_api.g_exc_unexpected_error;
817: ELSIF l_return_status = fnd_api.g_ret_sts_success THEN
818: null;
1023:
1024: -- Release 12: LPN SyncUP
1025: -- In addition to the LPN context update
1026: -- WDD records also need to be removed
1027: -- This is done by calling wms_container_pvt.modify_lpn API
1028: -- in WMS_DIRECT_SHIP_PVT.UNLOAD_TRUCK
1029: -- Remove the direct update here
1030: /*OPEN lpn_csr(l_delivery_details_id_table(1));
1031: LOOP
1316:
1317: -- Release 12: LPN SyncUP
1318: -- In addition to the LPN context update
1319: -- WDD records also need to be removed
1320: -- This is done by calling wms_container_pvt.modify_lpn API
1321: -- in WMS_DIRECT_SHIP_PVT.UNLOAD_TRUCK
1322: -- Remove the direct update here
1323: /*OPEN lpn_csr(l_delivery_details_id_table(1));
1324: LOOP