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 1707: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV

1703: CLOSE c_get_lpn;
1704:
1705: -- Bug5659809: update last_update_date and last_update_by as well
1706: UPDATE wms_license_plate_numbers
1707: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
1708: , last_update_date = SYSDATE
1709: , last_updated_by = fnd_global.user_id
1710: WHERE lpn_id = c_mmtt_rec.lpn_id;
1711:

Line 2325: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV

2321:
2322:
2323: -- Bug5659809: update last_update_date and last_update_by as well
2324: UPDATE wms_license_plate_numbers
2325: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
2326: , last_update_date = SYSDATE
2327: , last_updated_by = fnd_global.user_id
2328: WHERE lpn_id IN
2329: ( SELECT mmtt.content_lpn_id

Line 2353: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV

2349: IF l_loose_exists = 'Y'
2350: THEN
2351: -- Bug5659809: update last_update_date and last_update_by as well
2352: UPDATE wms_license_plate_numbers
2353: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
2354: , last_update_date = SYSDATE
2355: , last_updated_by = fnd_global.user_id
2356: WHERE lpn_id IN
2357: ( SELECT mmtt.content_lpn_id

Line 4986: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING

4982: -- Start change for Bug 5620764
4983: -- Updates LPN context to "Packing Content" since entire LPN is consumed
4984: -- Bug5659809: update last_update_date and last_update_by as well
4985: UPDATE wms_license_plate_numbers
4986: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
4987: , last_update_date = SYSDATE
4988: , last_updated_by = fnd_global.user_id
4989: WHERE lpn_id = l_inner_lpn_id;
4990:

Line 7307: SET wlpn1.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING

7303: -- Start change for Bug 5620764
7304: -- Restore LPN context for bulk picked content LPNs back to "Packing Content" from "In Inventory"
7305: -- Bug5659809: update last_update_date and last_update_by as well
7306: UPDATE wms_license_plate_numbers wlpn1
7307: SET wlpn1.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
7308: , last_update_date = SYSDATE
7309: , last_updated_by = fnd_global.user_id
7310: WHERE wlpn1.lpn_id IN
7311: ( SELECT mmtt.content_lpn_id

Line 7319: AND wlpn2.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV

7315: AND mmtt.organization_id = p_organization_id
7316: AND mmtt.parent_line_id = mmtt.transaction_temp_id
7317: AND mmtt.content_lpn_id = wlpn2.lpn_id
7318: AND mmtt.organization_id = wlpn2.organization_id
7319: AND wlpn2.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
7320: );
7321:
7322: IF l_debug = 1 AND SQL%FOUND THEN
7323: print_debug ('Restored LPN context of bulk-picked content LPN', l_api_name);

Line 7508: wms_container_pub.create_lpn

7504: print_debug ('Xfer LPN is new.', l_api_name);
7505: END IF;
7506:
7507: l_api_return_status := fnd_api.g_ret_sts_success;
7508: wms_container_pub.create_lpn
7509: ( p_api_version => 1.0
7510: , x_return_status => l_api_return_status
7511: , x_msg_count => l_msg_count
7512: , x_msg_data => l_msg_data

Line 7516: , p_source => wms_container_pub.lpn_context_pregenerated

7512: , x_msg_data => l_msg_data
7513: , p_lpn => p_xfer_to_lpn
7514: , p_organization_id => p_organization_id
7515: , x_lpn_id => l_lpn_id
7516: , p_source => wms_container_pub.lpn_context_pregenerated
7517: );
7518:
7519: IF l_api_return_status <> fnd_api.g_ret_sts_success
7520: THEN

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

7519: IF l_api_return_status <> fnd_api.g_ret_sts_success
7520: THEN
7521: IF l_debug = 1 THEN
7522: print_debug
7523: ( 'Error from WMS_Container_PUB.create_lpn: ' || l_msg_data
7524: , l_api_name);
7525: END IF;
7526: RAISE FND_API.G_EXC_ERROR;
7527: ELSE

Line 7530: ( 'WMS_Container_PUB.create_lpn returned LPN '

7526: RAISE FND_API.G_EXC_ERROR;
7527: ELSE
7528: IF l_debug = 1 THEN
7529: print_debug
7530: ( 'WMS_Container_PUB.create_lpn returned LPN '
7531: || to_char(l_lpn_id)
7532: , l_api_name);
7533: END IF;
7534: END IF;

Line 7539: ELSIF to_lpn_rec.lpn_context = wms_container_pub.lpn_context_pregenerated

7535:
7536: --
7537: -- Check if pre-generated
7538: --
7539: ELSIF to_lpn_rec.lpn_context = wms_container_pub.lpn_context_pregenerated
7540: THEN
7541: IF (l_debug = 1) THEN
7542: print_debug ('Xfer LPN is pre-generated.', l_api_name);
7543: END IF;

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

7553: fnd_message.set_name('WMS', 'WMS_LPN_HAS_MORE_DROP_MTL');
7554: fnd_msg_pub.ADD;
7555: RAISE FND_API.G_EXC_ERROR;
7556:
7557: ELSIF to_lpn_rec.lpn_context <> wms_container_pub.lpn_context_picked
7558: THEN
7559: IF (l_debug = 1) THEN
7560: print_debug
7561: ( 'LPN has an invalid context: '

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

8682:
8683: -- Start change for Bug 5620764
8684: -- This is not required, since entire LPN is being consumed
8685: --UPDATE wms_license_plate_numbers wlpn
8686: -- SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
8687: -- WHERE wlpn.lpn_id = nested_lpn_rec.content_lpn_id
8688: -- AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
8689: -- AND wlpn.organization_id = p_orgn_id;
8690:

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

8684: -- This is not required, since entire LPN is being consumed
8685: --UPDATE wms_license_plate_numbers wlpn
8686: -- SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
8687: -- WHERE wlpn.lpn_id = nested_lpn_rec.content_lpn_id
8688: -- AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
8689: -- AND wlpn.organization_id = p_orgn_id;
8690:
8691: --IF l_debug = 1 AND SQL%FOUND
8692: --THEN

Line 9106: wms_container_pub.create_lpn

9102: /* mrana: Bug: 5049145 : If drop LPN is a user-keyed in value, we still
9103: * need to do MDC validations and for that we must create this LPN before
9104: * calling MDC API */
9105: -- Start of 5049145
9106: wms_container_pub.create_lpn
9107: ( p_api_version => 1.0
9108: , x_return_status => l_api_return_status
9109: , x_msg_count => l_msg_count
9110: , x_msg_data => l_msg_data

Line 9114: , p_source => wms_container_pub.lpn_context_pregenerated

9110: , x_msg_data => l_msg_data
9111: , p_lpn => p_drop_lpn
9112: , p_organization_id => p_organization_id
9113: , x_lpn_id => l_drop_lpn_id
9114: , p_source => wms_container_pub.lpn_context_pregenerated
9115: );
9116:
9117: IF l_api_return_status <> fnd_api.g_ret_sts_success
9118: THEN

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

9117: IF l_api_return_status <> fnd_api.g_ret_sts_success
9118: THEN
9119: IF l_debug = 1 THEN
9120: print_debug
9121: ( 'Error from WMS_Container_PUB.create_lpn: ' || l_msg_data
9122: , l_api_name);
9123: END IF;
9124: RAISE FND_API.G_EXC_ERROR;
9125: ELSE

Line 9128: ( 'WMS_Container_PUB.create_lpn returned LPN '

9124: RAISE FND_API.G_EXC_ERROR;
9125: ELSE
9126: IF l_debug = 1 THEN
9127: print_debug
9128: ( 'WMS_Container_PUB.create_lpn returned LPN '
9129: || to_char(l_drop_lpn_id)
9130: , l_api_name);
9131: END IF;
9132: END IF;

Line 9358: SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING

9354: -- Update LPN context if required
9355: --
9356: -- Bug5659809: update last_update_date and last_update_by as well
9357: UPDATE wms_license_plate_numbers wlpn
9358: SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
9359: , last_update_date = SYSDATE
9360: , last_updated_by = fnd_global.user_id
9361: WHERE wlpn.lpn_id = l_curr_xfer_lpn_id
9362: AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;

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

9358: SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
9359: , last_update_date = SYSDATE
9360: , last_updated_by = fnd_global.user_id
9361: WHERE wlpn.lpn_id = l_curr_xfer_lpn_id
9362: AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
9363:
9364: IF l_debug = 1 AND SQL%FOUND
9365: THEN
9366: print_debug

Line 9967: wms_container_pub.modify_lpn_wrapper

9963: (NOT l_xfer_lpn_used)
9964: )
9965: THEN
9966: l_api_return_status := fnd_api.g_ret_sts_success;
9967: wms_container_pub.modify_lpn_wrapper
9968: ( p_api_version => '1.0'
9969: , x_return_status => l_api_return_status
9970: , x_msg_count => l_msg_count
9971: , x_msg_data => l_msg_data

Line 9973: , p_lpn_context => WMS_Container_PUB.LPN_CONTEXT_PREGENERATED

9969: , x_return_status => l_api_return_status
9970: , x_msg_count => l_msg_count
9971: , x_msg_data => l_msg_data
9972: , p_lpn_id => p_transfer_lpn_id
9973: , p_lpn_context => WMS_Container_PUB.LPN_CONTEXT_PREGENERATED
9974: );
9975:
9976: IF l_api_return_status <> fnd_api.g_ret_sts_success
9977: THEN

Line 10531: WMS_Container_PUB.LPN_CONTEXT_PREGENERATED

10527: );
10528: END IF;
10529: RETURN;
10530: ELSIF drop_lpn_rec.lpn_context =
10531: WMS_Container_PUB.LPN_CONTEXT_PREGENERATED
10532: THEN
10533: CLOSE c_drop_lpn_cursor;
10534: IF l_debug = 1 THEN
10535: print_debug

Line 10587: WMS_Container_PUB.lpn_context_picked

10583: RETURN; -- multiple drops is TRUE and outer LPN done
10584: */
10585: -- End change for bug 5620764
10586: ELSIF drop_lpn_rec.lpn_context =
10587: WMS_Container_PUB.lpn_context_picked
10588: THEN
10589: IF drop_lpn_rec.subinventory_code <> p_drop_sub
10590: OR
10591: drop_lpn_rec.locator_id <> p_drop_loc_id

Line 10609: WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT

10605: fnd_msg_pub.ADD;
10606: RAISE FND_API.G_EXC_ERROR;
10607: END IF;
10608: ELSIF drop_lpn_rec.lpn_context =
10609: WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT
10610: THEN
10611: CLOSE c_drop_lpn_cursor;
10612: IF l_debug = 1 THEN
10613: print_debug

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

10725:
10726: l_temp_tbl.DELETE;
10727: END IF;
10728:
10729: IF drop_lpn_rec.lpn_context <> WMS_Container_PUB.lpn_context_picked
10730: THEN
10731: IF l_debug = 1 THEN
10732: print_debug
10733: ( 'Invalid LPN context: ' || to_char(drop_lpn_rec.lpn_context)