eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on WMS_CONTAINER_PUB

Line 608: l_lpn_context <> wms_container_pub.lpn_context_inv THEN

604: END;
605:
606: IF l_lpn_exists = 0 OR
607: p_lpn = 0 OR
608: l_lpn_context <> wms_container_pub.lpn_context_inv THEN
609:
610: IF (l_debug = 1) THEN
611: trace('lpn_match: lpn does not exist in org');
612: END IF;

Line 2553: l_lpn WMS_CONTAINER_PUB.LPN;

2549: x_loc_id NUMBER;
2550: l_new_request_id NUMBER;
2551: l_mtlt_pr_qty NUMBER;
2552: l_xfer_lpn VARCHAR2(30);
2553: l_lpn WMS_CONTAINER_PUB.LPN;
2554: l_any_row_failed BOOLEAN := FALSE;
2555:
2556: l_per_res_id NUMBER;
2557: l_wms_task_type NUMBER;

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

2619: --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.
2620:
2621: CURSOR c_update_xfer_lpns_context IS
2622: SELECT wlpn.lpn_id,organization_id FROM wms_license_plate_numbers wlpn
2623: WHERE wlpn.lpn_context <> wms_container_pub.lpn_context_pregenerated
2624: --to avoid LPNS that have been unpacked by TM for non-LPN ctrld sub
2625: AND wlpn.lpn_id IN
2626: (SELECT wdr.xfer_lpn_id
2627: FROM wms_device_requests wdr,

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

2934: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
2935: GOTO continue_loop;
2936: END;
2937:
2938: IF l_pick_lpn_context NOT IN ( wms_container_pub.lpn_context_pregenerated,wms_container_pub.LPN_CONTEXT_INV) THEN
2939: IF (l_debug = 1) THEN
2940: trace('Invalid LPN context for picked LPN:'||l_rec.lpn_id||'::context::'||l_pick_lpn_context);
2941: END IF;
2942: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');

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

3040: update_wdr_for_error_rec(l_rec.task_id,l_rec.relation_id);
3041: GOTO continue_loop;
3042: END;
3043:
3044: IF l_lpn_context NOT IN (wms_container_pub.LPN_CONTEXT_PACKING,
3045: wms_container_pub.lpn_context_pregenerated,wms_container_pub.LPN_CONTEXT_INV) THEN
3046: IF (l_debug = 1) THEN
3047: trace('Invalid LPN context for xfer_LPN:'||l_rec.xfer_lpn_id||'::context::'||l_lpn_context);
3048: END IF;

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

3041: GOTO continue_loop;
3042: END;
3043:
3044: IF l_lpn_context NOT IN (wms_container_pub.LPN_CONTEXT_PACKING,
3045: wms_container_pub.lpn_context_pregenerated,wms_container_pub.LPN_CONTEXT_INV) THEN
3046: IF (l_debug = 1) THEN
3047: trace('Invalid LPN context for xfer_LPN:'||l_rec.xfer_lpn_id||'::context::'||l_lpn_context);
3048: END IF;
3049: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');

Line 4089: p_lpn_context => WMS_Container_PUB.LPN_CONTEXT_PACKING);

4085: x_return_status => x_return_status,
4086: x_msg_count => x_msg_count,
4087: x_msg_data => x_msg_data,
4088: p_lpn_id => l_rec.lpn_id,
4089: p_lpn_context => WMS_Container_PUB.LPN_CONTEXT_PACKING);
4090:
4091: IF ((x_return_status = FND_API.g_ret_sts_unexp_error) OR (x_return_status
4092: = FND_API.g_ret_sts_error)) THEN
4093:

Line 4122: p_lpn_context => WMS_Container_PUB.LPN_CONTEXT_PACKING);

4118: x_return_status => x_return_status,
4119: x_msg_count => x_msg_count,
4120: x_msg_data => x_msg_data,
4121: p_lpn_id => l_rec.xfer_lpn_id,
4122: p_lpn_context => WMS_Container_PUB.LPN_CONTEXT_PACKING);
4123:
4124: IF ((x_return_status = FND_API.g_ret_sts_unexp_error) OR (x_return_status
4125: = FND_API.g_ret_sts_error)) THEN
4126:

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

4309: END IF;
4310:
4311: --Step6 Update LPN Context apporpriately for processed LPNs
4312: --For droped LPN tasks ONLY:
4313: -- Replenishment task = (reside IN inv) wms_container_pub.lpn_context_inv
4314: -- so taks = Handled by TM (Do NOT do anything)
4315: -- All successful LPNs are already Loaded in the loop above for each call
4316:
4317:

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

4326: --In case LPN is getting transferred, both lpn_id and
4327: --xfer_lpn_id are same, so getting updated correctly
4328:
4329: --as part of the bug 4411819, replaced
4330: --wms_container_pub.modify_lpn_wrapper to wms_container_pvt.Modify_LPN
4331:
4332: l_lpn.lpn_id := l_update_xfer_lpns_context.lpn_id;
4333: l_lpn.organization_id := l_update_xfer_lpns_context.organization_id;
4334: l_lpn.lpn_context := wms_container_pub.lpn_context_picked;

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

4330: --wms_container_pub.modify_lpn_wrapper to wms_container_pvt.Modify_LPN
4331:
4332: l_lpn.lpn_id := l_update_xfer_lpns_context.lpn_id;
4333: l_lpn.organization_id := l_update_xfer_lpns_context.organization_id;
4334: l_lpn.lpn_context := wms_container_pub.lpn_context_picked;
4335:
4336: wms_container_pvt.Modify_LPN
4337: (
4338: p_api_version => 1.0