DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on WMS_CONTAINER_PUB

Line 6974: IF l_lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED THEN

6970: SELECT lpn_context INTO l_lpn_context
6971: FROM Wms_license_plate_numbers wlpn
6972: WHERE wlpn.lpn_id=p_lpn_id
6973: AND wlpn.organization_id=p_org_id;
6974: IF l_lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED THEN
6975: debug('There is no LPN content available for this transaction.');
6976: fnd_message.set_name('WMS', 'WMS_LPN_UNAVAIL');
6977: fnd_msg_pub.ADD;
6978: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 9386: wms_container_pub.modify_lpn_wrapper

9382:
9383: l_progress := '170';
9384:
9385: -- At the end, update the intoLPN context into 3 (RCV)
9386: wms_container_pub.modify_lpn_wrapper
9387: ( p_api_version => 1.0
9388: ,x_return_status => x_return_status
9389: ,x_msg_count => x_msg_count
9390: ,x_msg_data => x_msg_data

Line 9633: wms_container_pub.modify_lpn_wrapper

9629:
9630: l_progress := '220';
9631:
9632: -- At the end, update the intoLPN context into 2 (WIP
9633: wms_container_pub.modify_lpn_wrapper
9634: ( p_api_version => 1.0
9635: ,x_return_status => x_return_status
9636: ,x_msg_count => x_msg_count
9637: ,x_msg_data => x_msg_data

Line 12396: wms_container_pub.create_lpn

12392: debug('LPN does not exist so create new LPN','validate_into_lpn',9);
12393: END IF;
12394:
12395: -- Create the LPN
12396: wms_container_pub.create_lpn
12397: ( p_api_version => 1.0,
12398: p_init_msg_list => fnd_api.g_false,
12399: p_commit => fnd_api.g_false,
12400: x_return_status => x_return_status,

Line 12423: debug('Success returned from wms_container_pub.create_lpn API','validate_into_lpn',9);

12419:
12420: -- Check the return status from the API call
12421: IF (x_return_status = fnd_api.g_ret_sts_success) THEN
12422: IF (l_debug = 1) THEN
12423: debug('Success returned from wms_container_pub.create_lpn API','validate_into_lpn',9);
12424: END IF;
12425: ELSE
12426: IF (l_debug = 1) THEN
12427: debug('Failure returned from wms_container_pub.create_lpn API','validate_into_lpn',9);

Line 12427: debug('Failure returned from wms_container_pub.create_lpn API','validate_into_lpn',9);

12423: debug('Success returned from wms_container_pub.create_lpn API','validate_into_lpn',9);
12424: END IF;
12425: ELSE
12426: IF (l_debug = 1) THEN
12427: debug('Failure returned from wms_container_pub.create_lpn API','validate_into_lpn',9);
12428: END IF;
12429: FND_MESSAGE.SET_NAME('WMS', 'WMS_TD_CREATE_LPN_ERROR');
12430: FND_MSG_PUB.ADD;
12431: RAISE fnd_api.g_exc_error;

Line 12491: AND (wlpn.lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED

12487: FROM wms_license_plate_numbers wlpn
12488: WHERE wlpn.organization_id = p_organization_id
12489: AND wlpn.lpn_id <> p_lpn_id
12490: AND wlpn.lpn_id = l_into_lpn_id
12491: AND (wlpn.lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED
12492: OR (wlpn.lpn_context = l_lpn_context
12493: AND (
12494: ( l_lpn_has_material = 0
12495: --NOT EXISTS (SELECT 'LPN_HAS_MATERIAL'