DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on WMS_CONTAINER_PUB

Line 8521: wms_container_pub.modify_lpn_wrapper

8517:
8518: l_progress := '170';
8519:
8520: -- At the end, update the intoLPN context into 3 (RCV)
8521: wms_container_pub.modify_lpn_wrapper
8522: ( p_api_version => 1.0
8523: ,x_return_status => x_return_status
8524: ,x_msg_count => x_msg_count
8525: ,x_msg_data => x_msg_data

Line 8768: wms_container_pub.modify_lpn_wrapper

8764:
8765: l_progress := '220';
8766:
8767: -- At the end, update the intoLPN context into 2 (WIP
8768: wms_container_pub.modify_lpn_wrapper
8769: ( p_api_version => 1.0
8770: ,x_return_status => x_return_status
8771: ,x_msg_count => x_msg_count
8772: ,x_msg_data => x_msg_data

Line 11417: wms_container_pub.create_lpn

11413: debug('LPN does not exist so create new LPN','validate_into_lpn',9);
11414: END IF;
11415:
11416: -- Create the LPN
11417: wms_container_pub.create_lpn
11418: ( p_api_version => 1.0,
11419: p_init_msg_list => fnd_api.g_false,
11420: p_commit => fnd_api.g_false,
11421: x_return_status => x_return_status,

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

11440:
11441: -- Check the return status from the API call
11442: IF (x_return_status = fnd_api.g_ret_sts_success) THEN
11443: IF (l_debug = 1) THEN
11444: debug('Success returned from wms_container_pub.create_lpn API','validate_into_lpn',9);
11445: END IF;
11446: ELSE
11447: IF (l_debug = 1) THEN
11448: debug('Failure returned from wms_container_pub.create_lpn API','validate_into_lpn',9);

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

11444: debug('Success returned from wms_container_pub.create_lpn API','validate_into_lpn',9);
11445: END IF;
11446: ELSE
11447: IF (l_debug = 1) THEN
11448: debug('Failure returned from wms_container_pub.create_lpn API','validate_into_lpn',9);
11449: END IF;
11450: FND_MESSAGE.SET_NAME('WMS', 'WMS_TD_CREATE_LPN_ERROR');
11451: FND_MSG_PUB.ADD;
11452: RAISE fnd_api.g_exc_error;

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

11508: FROM wms_license_plate_numbers wlpn
11509: WHERE wlpn.organization_id = p_organization_id
11510: AND wlpn.lpn_id <> p_lpn_id
11511: AND wlpn.lpn_id = l_into_lpn_id
11512: AND (wlpn.lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED
11513: OR (wlpn.lpn_context = l_lpn_context
11514: AND (
11515: ( l_lpn_has_material = 0
11516: --NOT EXISTS (SELECT 'LPN_HAS_MATERIAL'