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_PICK_DROP_PVT dependencies on WMS_CONTAINER_PUB

Line 1848: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV

1844: CLOSE c_get_lpn;
1845:
1846: -- Bug5659809: update last_update_date and last_update_by as well
1847: UPDATE wms_license_plate_numbers
1848: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
1849: , last_update_date = SYSDATE
1850: , last_updated_by = fnd_global.user_id
1851: WHERE lpn_id = c_mmtt_rec.lpn_id;
1852:

Line 2468: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV

2464:
2465:
2466: -- Bug5659809: update last_update_date and last_update_by as well
2467: UPDATE wms_license_plate_numbers
2468: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
2469: , last_update_date = SYSDATE
2470: , last_updated_by = fnd_global.user_id
2471: WHERE lpn_id IN
2472: ( SELECT mmtt.content_lpn_id

Line 2496: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV

2492: IF l_loose_exists = 'Y'
2493: THEN
2494: -- Bug5659809: update last_update_date and last_update_by as well
2495: UPDATE wms_license_plate_numbers
2496: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
2497: , last_update_date = SYSDATE
2498: , last_updated_by = fnd_global.user_id
2499: WHERE lpn_id IN
2500: ( SELECT mmtt.content_lpn_id

Line 5264: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING

5260: -- Start change for Bug 5620764
5261: -- Updates LPN context to "Packing Content" since entire LPN is consumed
5262: -- Bug5659809: update last_update_date and last_update_by as well
5263: UPDATE wms_license_plate_numbers
5264: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
5265: , last_update_date = SYSDATE
5266: , last_updated_by = fnd_global.user_id
5267: WHERE lpn_id = l_inner_lpn_id;
5268:

Line 7585: SET wlpn1.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING

7581: -- Start change for Bug 5620764
7582: -- Restore LPN context for bulk picked content LPNs back to "Packing Content" from "In Inventory"
7583: -- Bug5659809: update last_update_date and last_update_by as well
7584: UPDATE wms_license_plate_numbers wlpn1
7585: SET wlpn1.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
7586: , last_update_date = SYSDATE
7587: , last_updated_by = fnd_global.user_id
7588: WHERE wlpn1.lpn_id IN
7589: ( SELECT mmtt.content_lpn_id

Line 7597: AND wlpn2.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV

7593: AND mmtt.organization_id = p_organization_id
7594: AND mmtt.parent_line_id = mmtt.transaction_temp_id
7595: AND mmtt.content_lpn_id = wlpn2.lpn_id
7596: AND mmtt.organization_id = wlpn2.organization_id
7597: AND wlpn2.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
7598: );
7599:
7600: IF l_debug = 1 AND SQL%FOUND THEN
7601: print_debug ('Restored LPN context of bulk-picked content LPN', l_api_name);

Line 7786: wms_container_pub.create_lpn

7782: print_debug ('Xfer LPN is new.', l_api_name);
7783: END IF;
7784:
7785: l_api_return_status := fnd_api.g_ret_sts_success;
7786: wms_container_pub.create_lpn
7787: ( p_api_version => 1.0
7788: , x_return_status => l_api_return_status
7789: , x_msg_count => l_msg_count
7790: , x_msg_data => l_msg_data

Line 7794: , p_source => wms_container_pub.lpn_context_pregenerated

7790: , x_msg_data => l_msg_data
7791: , p_lpn => p_xfer_to_lpn
7792: , p_organization_id => p_organization_id
7793: , x_lpn_id => l_lpn_id
7794: , p_source => wms_container_pub.lpn_context_pregenerated
7795: );
7796:
7797: IF l_api_return_status <> fnd_api.g_ret_sts_success
7798: THEN

Line 7801: ( 'Error from WMS_Container_PUB.create_lpn: ' || l_msg_data

7797: IF l_api_return_status <> fnd_api.g_ret_sts_success
7798: THEN
7799: IF l_debug = 1 THEN
7800: print_debug
7801: ( 'Error from WMS_Container_PUB.create_lpn: ' || l_msg_data
7802: , l_api_name);
7803: END IF;
7804: RAISE FND_API.G_EXC_ERROR;
7805: ELSE

Line 7808: ( 'WMS_Container_PUB.create_lpn returned LPN '

7804: RAISE FND_API.G_EXC_ERROR;
7805: ELSE
7806: IF l_debug = 1 THEN
7807: print_debug
7808: ( 'WMS_Container_PUB.create_lpn returned LPN '
7809: || to_char(l_lpn_id)
7810: , l_api_name);
7811: END IF;
7812: END IF;

Line 7817: ELSIF to_lpn_rec.lpn_context = wms_container_pub.lpn_context_pregenerated

7813:
7814: --
7815: -- Check if pre-generated
7816: --
7817: ELSIF to_lpn_rec.lpn_context = wms_container_pub.lpn_context_pregenerated
7818: THEN
7819: IF (l_debug = 1) THEN
7820: print_debug ('Xfer LPN is pre-generated.', l_api_name);
7821: END IF;

Line 7835: ELSIF to_lpn_rec.lpn_context <> wms_container_pub.lpn_context_picked

7831: fnd_message.set_name('WMS', 'WMS_LPN_HAS_MORE_DROP_MTL');
7832: fnd_msg_pub.ADD;
7833: RAISE FND_API.G_EXC_ERROR;
7834:
7835: ELSIF to_lpn_rec.lpn_context <> wms_container_pub.lpn_context_picked
7836: THEN
7837: IF (l_debug = 1) THEN
7838: print_debug
7839: ( 'LPN has an invalid context: '

Line 8980: -- SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV

8976:
8977: -- Start change for Bug 5620764
8978: -- This is not required, since entire LPN is being consumed
8979: --UPDATE wms_license_plate_numbers wlpn
8980: -- SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
8981: -- WHERE wlpn.lpn_id = nested_lpn_rec.content_lpn_id
8982: -- AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
8983: -- AND wlpn.organization_id = p_orgn_id;
8984:

Line 8982: -- AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING

8978: -- This is not required, since entire LPN is being consumed
8979: --UPDATE wms_license_plate_numbers wlpn
8980: -- SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
8981: -- WHERE wlpn.lpn_id = nested_lpn_rec.content_lpn_id
8982: -- AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
8983: -- AND wlpn.organization_id = p_orgn_id;
8984:
8985: --IF l_debug = 1 AND SQL%FOUND
8986: --THEN

Line 9409: wms_container_pub.create_lpn

9405: /* mrana: Bug: 5049145 : If drop LPN is a user-keyed in value, we still
9406: * need to do MDC validations and for that we must create this LPN before
9407: * calling MDC API */
9408: -- Start of 5049145
9409: wms_container_pub.create_lpn
9410: ( p_api_version => 1.0
9411: , x_return_status => l_api_return_status
9412: , x_msg_count => l_msg_count
9413: , x_msg_data => l_msg_data

Line 9417: , p_source => wms_container_pub.lpn_context_pregenerated

9413: , x_msg_data => l_msg_data
9414: , p_lpn => p_drop_lpn
9415: , p_organization_id => p_organization_id
9416: , x_lpn_id => l_drop_lpn_id
9417: , p_source => wms_container_pub.lpn_context_pregenerated
9418: );
9419:
9420: IF l_api_return_status <> fnd_api.g_ret_sts_success
9421: THEN

Line 9424: ( 'Error from WMS_Container_PUB.create_lpn: ' || l_msg_data

9420: IF l_api_return_status <> fnd_api.g_ret_sts_success
9421: THEN
9422: IF l_debug = 1 THEN
9423: print_debug
9424: ( 'Error from WMS_Container_PUB.create_lpn: ' || l_msg_data
9425: , l_api_name);
9426: END IF;
9427: RAISE FND_API.G_EXC_ERROR;
9428: ELSE

Line 9431: ( 'WMS_Container_PUB.create_lpn returned LPN '

9427: RAISE FND_API.G_EXC_ERROR;
9428: ELSE
9429: IF l_debug = 1 THEN
9430: print_debug
9431: ( 'WMS_Container_PUB.create_lpn returned LPN '
9432: || to_char(l_drop_lpn_id)
9433: , l_api_name);
9434: END IF;
9435: END IF;

Line 9677: SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING

9673: -- Update LPN context if required
9674: --
9675: -- Bug5659809: update last_update_date and last_update_by as well
9676: UPDATE wms_license_plate_numbers wlpn
9677: SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
9678: , last_update_date = SYSDATE
9679: , last_updated_by = fnd_global.user_id
9680: WHERE wlpn.lpn_id = l_curr_xfer_lpn_id
9681: AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;

Line 9681: AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;

9677: SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
9678: , last_update_date = SYSDATE
9679: , last_updated_by = fnd_global.user_id
9680: WHERE wlpn.lpn_id = l_curr_xfer_lpn_id
9681: AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
9682:
9683: IF l_debug = 1 AND SQL%FOUND
9684: THEN
9685: print_debug

Line 10290: wms_container_pub.modify_lpn_wrapper

10286: (NOT l_xfer_lpn_used)
10287: )
10288: THEN
10289: l_api_return_status := fnd_api.g_ret_sts_success;
10290: wms_container_pub.modify_lpn_wrapper
10291: ( p_api_version => '1.0'
10292: , x_return_status => l_api_return_status
10293: , x_msg_count => l_msg_count
10294: , x_msg_data => l_msg_data

Line 10296: , p_lpn_context => WMS_Container_PUB.LPN_CONTEXT_PREGENERATED

10292: , x_return_status => l_api_return_status
10293: , x_msg_count => l_msg_count
10294: , x_msg_data => l_msg_data
10295: , p_lpn_id => p_transfer_lpn_id
10296: , p_lpn_context => WMS_Container_PUB.LPN_CONTEXT_PREGENERATED
10297: );
10298:
10299: IF l_api_return_status <> fnd_api.g_ret_sts_success
10300: THEN

Line 10854: WMS_Container_PUB.LPN_CONTEXT_PREGENERATED

10850: );
10851: END IF;
10852: RETURN;
10853: ELSIF drop_lpn_rec.lpn_context =
10854: WMS_Container_PUB.LPN_CONTEXT_PREGENERATED
10855: THEN
10856: CLOSE c_drop_lpn_cursor;
10857: IF l_debug = 1 THEN
10858: print_debug

Line 10910: WMS_Container_PUB.lpn_context_picked

10906: RETURN; -- multiple drops is TRUE and outer LPN done
10907: */
10908: -- End change for bug 5620764
10909: ELSIF drop_lpn_rec.lpn_context =
10910: WMS_Container_PUB.lpn_context_picked
10911: THEN
10912: IF drop_lpn_rec.subinventory_code <> p_drop_sub
10913: OR
10914: drop_lpn_rec.locator_id <> p_drop_loc_id

Line 10932: WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT

10928: fnd_msg_pub.ADD;
10929: RAISE FND_API.G_EXC_ERROR;
10930: END IF;
10931: ELSIF drop_lpn_rec.lpn_context =
10932: WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT
10933: THEN
10934: CLOSE c_drop_lpn_cursor;
10935: IF l_debug = 1 THEN
10936: print_debug

Line 11052: IF drop_lpn_rec.lpn_context <> WMS_Container_PUB.lpn_context_picked

11048:
11049: l_temp_tbl.DELETE;
11050: END IF;
11051:
11052: IF drop_lpn_rec.lpn_context <> WMS_Container_PUB.lpn_context_picked
11053: THEN
11054: IF l_debug = 1 THEN
11055: print_debug
11056: ( 'Invalid LPN context: ' || to_char(drop_lpn_rec.lpn_context)