DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on WMS_CONTAINER_PVT

Line 3245: Call wms_container_pvt.modify_lpn API

3241: CLOSE wdd_del_detail;
3242: END LOOP;
3243:
3244: /* Release 12 LPN Sync
3245: Call wms_container_pvt.modify_lpn API
3246: to update the context and remove the WDD records
3247: associated with those LPNs */
3248: l_lpn_tbl.delete;
3249: FOR l_lpn IN lpn_cur LOOP

Line 3260: DEBUG('Calling WMS_CONTAINER_PVT.Modify_LPNs with caller WMS_DIRECTSHIP','Unload_Truck');

3256: ||', lpn_id '||l_lpn_rec.lpn_id||', lpn_context '||l_lpn_rec.lpn_context, 'Unload_Truck');
3257: END IF;
3258: END LOOP;
3259: IF(l_debug = 1) THEN
3260: DEBUG('Calling WMS_CONTAINER_PVT.Modify_LPNs with caller WMS_DIRECTSHIP','Unload_Truck');
3261: END IF;
3262:
3263: WMS_CONTAINER_PVT.Modify_LPNs(
3264: p_api_version => 1.0

Line 3263: WMS_CONTAINER_PVT.Modify_LPNs(

3259: IF(l_debug = 1) THEN
3260: DEBUG('Calling WMS_CONTAINER_PVT.Modify_LPNs with caller WMS_DIRECTSHIP','Unload_Truck');
3261: END IF;
3262:
3263: WMS_CONTAINER_PVT.Modify_LPNs(
3264: p_api_version => 1.0
3265: , p_init_msg_list => fnd_api.g_true
3266: , p_commit => fnd_api.g_false
3267: , x_return_status => l_return_status

Line 3275: DEBUG('return error from WMS_CONTAINER_PVT.Modify_LPNs', 'Unload_Truck');

3271: , p_lpn_table => l_lpn_tbl
3272: );
3273: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
3274: IF (l_debug = 1) THEN
3275: DEBUG('return error from WMS_CONTAINER_PVT.Modify_LPNs', 'Unload_Truck');
3276: END IF;
3277: RAISE fnd_api.g_exc_error;
3278: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3279: IF (l_debug = 1) THEN

Line 3280: DEBUG('return error from WMS_CONTAINER_PVT.Modify_LPNs', 'Unload_Truck');

3276: END IF;
3277: RAISE fnd_api.g_exc_error;
3278: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3279: IF (l_debug = 1) THEN
3280: DEBUG('return error from WMS_CONTAINER_PVT.Modify_LPNs', 'Unload_Truck');
3281: END IF;
3282: RAISE fnd_api.g_exc_unexpected_error;
3283: ELSIF l_return_status = fnd_api.g_ret_sts_success THEN
3284: null;

Line 7057: l_wsh_dd_rec := WMS_CONTAINER_PVT.To_DeliveryDetailsRecType(l_lpn_cur);

7053: The pre-R12 code was doing in two steps, create_container then update_container
7054: With the new API call, it replaces both previous API calls */
7055:
7056: /* Call function to create wsh delivery detail record */
7057: l_wsh_dd_rec := WMS_CONTAINER_PVT.To_DeliveryDetailsRecType(l_lpn_cur);
7058:
7059: /*Add l_wsh_dd_rec into record table */
7060:
7061: wsh_create_tbl(NVL(wsh_create_tbl.last, 0) + 1) := l_wsh_dd_rec;