DBA Data[Home] [Help]

APPS.WMS_DIRECT_SHIP_PVT dependencies on WMS_CONTAINER_PVT

Line 3435: Call wms_container_pvt.modify_lpn API

3431: CLOSE wdd_del_detail;
3432: END LOOP;
3433:
3434: /* Release 12 LPN Sync
3435: Call wms_container_pvt.modify_lpn API
3436: to update the context and remove the WDD records
3437: associated with those LPNs */
3438: l_lpn_tbl.delete;
3439: FOR l_lpn IN lpn_cur LOOP

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

3446: ||', lpn_id '||l_lpn_rec.lpn_id||', lpn_context '||l_lpn_rec.lpn_context, 'Unload_Truck');
3447: END IF;
3448: END LOOP;
3449: IF(l_debug = 1) THEN
3450: DEBUG('Calling WMS_CONTAINER_PVT.Modify_LPNs with caller WMS_DIRECTSHIP','Unload_Truck');
3451: END IF;
3452:
3453: WMS_CONTAINER_PVT.Modify_LPNs(
3454: p_api_version => 1.0

Line 3453: WMS_CONTAINER_PVT.Modify_LPNs(

3449: IF(l_debug = 1) THEN
3450: DEBUG('Calling WMS_CONTAINER_PVT.Modify_LPNs with caller WMS_DIRECTSHIP','Unload_Truck');
3451: END IF;
3452:
3453: WMS_CONTAINER_PVT.Modify_LPNs(
3454: p_api_version => 1.0
3455: , p_init_msg_list => fnd_api.g_true
3456: , p_commit => fnd_api.g_false
3457: , x_return_status => l_return_status

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

3461: , p_lpn_table => l_lpn_tbl
3462: );
3463: IF (l_return_status = fnd_api.g_ret_sts_error) THEN
3464: IF (l_debug = 1) THEN
3465: DEBUG('return error from WMS_CONTAINER_PVT.Modify_LPNs', 'Unload_Truck');
3466: END IF;
3467: RAISE fnd_api.g_exc_error;
3468: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3469: IF (l_debug = 1) THEN

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

3466: END IF;
3467: RAISE fnd_api.g_exc_error;
3468: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3469: IF (l_debug = 1) THEN
3470: DEBUG('return error from WMS_CONTAINER_PVT.Modify_LPNs', 'Unload_Truck');
3471: END IF;
3472: RAISE fnd_api.g_exc_unexpected_error;
3473: ELSIF l_return_status = fnd_api.g_ret_sts_success THEN
3474: null;

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

8150: The pre-R12 code was doing in two steps, create_container then update_container
8151: With the new API call, it replaces both previous API calls */
8152:
8153: /* Call function to create wsh delivery detail record */
8154: l_wsh_dd_rec := WMS_CONTAINER_PVT.To_DeliveryDetailsRecType(l_lpn_cur);
8155:
8156: /*Add l_wsh_dd_rec into record table */
8157:
8158: wsh_create_tbl(NVL(wsh_create_tbl.last, 0) + 1) := l_wsh_dd_rec;