DBA Data[Home] [Help]

APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on WMS_CONTAINER_PUB

Line 1127: l_lpn_context <> wms_container_pub.lpn_context_inv THEN

1123: END;
1124:
1125: IF l_lpn_exists = 0 OR
1126: p_lpn = 0 OR
1127: l_lpn_context <> wms_container_pub.lpn_context_inv THEN
1128:
1129: IF (l_debug = 1) THEN
1130: trace('lpn_match: lpn does not exist in org');
1131: END IF;

Line 3078: l_lpn WMS_CONTAINER_PUB.LPN;

3074: x_loc_id NUMBER;
3075: l_new_request_id NUMBER;
3076: l_mtlt_pr_qty NUMBER;
3077: l_xfer_lpn VARCHAR2(30);
3078: l_lpn WMS_CONTAINER_PUB.LPN;
3079: l_any_row_failed BOOLEAN := FALSE;
3080:
3081: l_per_res_id NUMBER;
3082: l_wms_task_type NUMBER;

Line 3149: WHERE wlpn.lpn_context <> wms_container_pub.lpn_context_pregenerated

3145: --In case the LPN is going to the non-LPN controlled sub then TM would have already unpacked and updated the lpn context TO 'defined but not used'. Leave these LPN as it is.
3146:
3147: CURSOR c_update_xfer_lpns_context IS
3148: SELECT wlpn.lpn_id,organization_id FROM wms_license_plate_numbers wlpn
3149: WHERE wlpn.lpn_context <> wms_container_pub.lpn_context_pregenerated
3150: --to avoid LPNS that have been unpacked by TM for non-LPN ctrld sub
3151: AND wlpn.lpn_id IN
3152: (SELECT wdr.xfer_lpn_id
3153: FROM wms_device_requests wdr,

Line 3483: IF l_pick_lpn_context NOT IN ( wms_container_pub.lpn_context_pregenerated,wms_container_pub.LPN_CONTEXT_INV) THEN

3479: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3480: GOTO continue_loop;
3481: END;
3482:
3483: IF l_pick_lpn_context NOT IN ( wms_container_pub.lpn_context_pregenerated,wms_container_pub.LPN_CONTEXT_INV) THEN
3484: IF (l_debug = 1) THEN
3485: trace('Invalid LPN context for picked LPN:'||l_rec.lpn_id||'::context::'||l_pick_lpn_context);
3486: END IF;
3487: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');

Line 3589: IF l_lpn_context NOT IN (wms_container_pub.LPN_CONTEXT_PACKING,

3585: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3586: GOTO continue_loop;
3587: END;
3588:
3589: IF l_lpn_context NOT IN (wms_container_pub.LPN_CONTEXT_PACKING,
3590: wms_container_pub.lpn_context_pregenerated,wms_container_pub.LPN_CONTEXT_INV) THEN
3591: IF (l_debug = 1) THEN
3592: trace('Invalid LPN context for xfer_LPN:'||l_rec.xfer_lpn_id||'::context::'||l_lpn_context);
3593: END IF;

Line 3590: wms_container_pub.lpn_context_pregenerated,wms_container_pub.LPN_CONTEXT_INV) THEN

3586: GOTO continue_loop;
3587: END;
3588:
3589: IF l_lpn_context NOT IN (wms_container_pub.LPN_CONTEXT_PACKING,
3590: wms_container_pub.lpn_context_pregenerated,wms_container_pub.LPN_CONTEXT_INV) THEN
3591: IF (l_debug = 1) THEN
3592: trace('Invalid LPN context for xfer_LPN:'||l_rec.xfer_lpn_id||'::context::'||l_lpn_context);
3593: END IF;
3594: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');

Line 4814: p_lpn_context => WMS_Container_PUB.LPN_CONTEXT_PACKING);

4810: x_return_status => x_return_status,
4811: x_msg_count => x_msg_count,
4812: x_msg_data => x_msg_data,
4813: p_lpn_id => l_rec.lpn_id,
4814: p_lpn_context => WMS_Container_PUB.LPN_CONTEXT_PACKING);
4815:
4816: IF ((x_return_status = FND_API.g_ret_sts_unexp_error) OR (x_return_status
4817: = FND_API.g_ret_sts_error)) THEN
4818:

Line 4849: p_lpn_context => WMS_Container_PUB.LPN_CONTEXT_PACKING);

4845: x_return_status => x_return_status,
4846: x_msg_count => x_msg_count,
4847: x_msg_data => x_msg_data,
4848: p_lpn_id => l_rec.xfer_lpn_id,
4849: p_lpn_context => WMS_Container_PUB.LPN_CONTEXT_PACKING);
4850:
4851: IF ((x_return_status = FND_API.g_ret_sts_unexp_error) OR (x_return_status
4852: = FND_API.g_ret_sts_error)) THEN
4853:

Line 5042: -- Replenishment task = (reside IN inv) wms_container_pub.lpn_context_inv

5038: END IF;
5039:
5040: --Step6 Update LPN Context apporpriately for processed LPNs
5041: --For droped LPN tasks ONLY:
5042: -- Replenishment task = (reside IN inv) wms_container_pub.lpn_context_inv
5043: -- so taks = Handled by TM (Do NOT do anything)
5044: -- All successful LPNs are already Loaded in the loop above for each call
5045:
5046:

Line 5059: --wms_container_pub.modify_lpn_wrapper to wms_container_pvt.Modify_LPN

5055: --In case LPN is getting transferred, both lpn_id and
5056: --xfer_lpn_id are same, so getting updated correctly
5057:
5058: --as part of the bug 4411819, replaced
5059: --wms_container_pub.modify_lpn_wrapper to wms_container_pvt.Modify_LPN
5060:
5061: l_lpn.lpn_id := l_update_xfer_lpns_context.lpn_id;
5062: l_lpn.organization_id := l_update_xfer_lpns_context.organization_id;
5063: l_lpn.lpn_context := wms_container_pub.lpn_context_picked;

Line 5063: l_lpn.lpn_context := wms_container_pub.lpn_context_picked;

5059: --wms_container_pub.modify_lpn_wrapper to wms_container_pvt.Modify_LPN
5060:
5061: l_lpn.lpn_id := l_update_xfer_lpns_context.lpn_id;
5062: l_lpn.organization_id := l_update_xfer_lpns_context.organization_id;
5063: l_lpn.lpn_context := wms_container_pub.lpn_context_picked;
5064:
5065: wms_container_pvt.Modify_LPN
5066: (
5067: p_api_version => 1.0