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

Line 1167: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;

1163: l_transfer_lpn_id NUMBER := p_transfer_lpn_id;
1164: l_container_item_id NUMBER := p_container_item_id;
1165: l_lpn_match_lpn_id NUMBER := p_lpn_match_lpn_id;
1166:
1167: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
1168: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
1169: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
1170: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
1171:

Line 1168: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;

1164: l_container_item_id NUMBER := p_container_item_id;
1165: l_lpn_match_lpn_id NUMBER := p_lpn_match_lpn_id;
1166:
1167: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
1168: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
1169: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
1170: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
1171:
1172: CURSOR cur_split_mmtts

Line 1169: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;

1165: l_lpn_match_lpn_id NUMBER := p_lpn_match_lpn_id;
1166:
1167: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
1168: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
1169: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
1170: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
1171:
1172: CURSOR cur_split_mmtts
1173: IS

Line 1170: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;

1166:
1167: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
1168: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
1169: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
1170: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
1171:
1172: CURSOR cur_split_mmtts
1173: IS
1174: SELECT transaction_temp_id

Line 5472: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;

5468: IS
5469: l_proc_name VARCHAR2(30) := 'PROC_RESET_LPN_CONTEXT';
5470: l_progress VARCHAR2(30) := '100';
5471: l_other_tasks NUMBER := 0;
5472: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
5473: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
5474: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
5475: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
5476:

Line 5473: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;

5469: l_proc_name VARCHAR2(30) := 'PROC_RESET_LPN_CONTEXT';
5470: l_progress VARCHAR2(30) := '100';
5471: l_other_tasks NUMBER := 0;
5472: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
5473: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
5474: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
5475: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
5476:
5477: CURSOR cur_from_lpns IS

Line 5474: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;

5470: l_progress VARCHAR2(30) := '100';
5471: l_other_tasks NUMBER := 0;
5472: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
5473: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
5474: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
5475: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
5476:
5477: CURSOR cur_from_lpns IS
5478: SELECT DISTINCT lpn_id

Line 5475: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;

5471: l_other_tasks NUMBER := 0;
5472: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
5473: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
5474: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
5475: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
5476:
5477: CURSOR cur_from_lpns IS
5478: SELECT DISTINCT lpn_id
5479: FROM mtl_material_transactions_temp

Line 7144: OR l_lpn_context <> wms_container_pub.lpn_context_inv THEN

7140: END;
7141:
7142: IF l_lpn_exists = 0
7143: OR p_fromlpn_id = 0
7144: OR l_lpn_context <> wms_container_pub.lpn_context_inv THEN
7145: IF (l_debug = 1) THEN
7146: mydebug('lpn does not exist in org');
7147: END IF;
7148:

Line 10433: lpn_cont = wms_container_pub.lpn_context_wip

10429:
10430: IF (create_lpn = 'N') THEN
10431: IF (wms_control.g_current_release_level >= 120001 AND honor_case_pick_count > 0) THEN
10432: IF (
10433: lpn_cont = wms_container_pub.lpn_context_wip
10434: OR lpn_cont = wms_container_pub.lpn_context_rcv
10435: OR lpn_cont = wms_container_pub.lpn_context_stores
10436: OR lpn_cont = wms_container_pub.lpn_context_intransit
10437: OR lpn_cont = wms_container_pub.lpn_context_vendor

Line 10434: OR lpn_cont = wms_container_pub.lpn_context_rcv

10430: IF (create_lpn = 'N') THEN
10431: IF (wms_control.g_current_release_level >= 120001 AND honor_case_pick_count > 0) THEN
10432: IF (
10433: lpn_cont = wms_container_pub.lpn_context_wip
10434: OR lpn_cont = wms_container_pub.lpn_context_rcv
10435: OR lpn_cont = wms_container_pub.lpn_context_stores
10436: OR lpn_cont = wms_container_pub.lpn_context_intransit
10437: OR lpn_cont = wms_container_pub.lpn_context_vendor
10438: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment

Line 10435: OR lpn_cont = wms_container_pub.lpn_context_stores

10431: IF (wms_control.g_current_release_level >= 120001 AND honor_case_pick_count > 0) THEN
10432: IF (
10433: lpn_cont = wms_container_pub.lpn_context_wip
10434: OR lpn_cont = wms_container_pub.lpn_context_rcv
10435: OR lpn_cont = wms_container_pub.lpn_context_stores
10436: OR lpn_cont = wms_container_pub.lpn_context_intransit
10437: OR lpn_cont = wms_container_pub.lpn_context_vendor
10438: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
10439: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip

Line 10436: OR lpn_cont = wms_container_pub.lpn_context_intransit

10432: IF (
10433: lpn_cont = wms_container_pub.lpn_context_wip
10434: OR lpn_cont = wms_container_pub.lpn_context_rcv
10435: OR lpn_cont = wms_container_pub.lpn_context_stores
10436: OR lpn_cont = wms_container_pub.lpn_context_intransit
10437: OR lpn_cont = wms_container_pub.lpn_context_vendor
10438: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
10439: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
10440: OR lpn_cont = wms_container_pub.lpn_context_picked

Line 10437: OR lpn_cont = wms_container_pub.lpn_context_vendor

10433: lpn_cont = wms_container_pub.lpn_context_wip
10434: OR lpn_cont = wms_container_pub.lpn_context_rcv
10435: OR lpn_cont = wms_container_pub.lpn_context_stores
10436: OR lpn_cont = wms_container_pub.lpn_context_intransit
10437: OR lpn_cont = wms_container_pub.lpn_context_vendor
10438: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
10439: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
10440: OR lpn_cont = wms_container_pub.lpn_context_picked
10441: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV

Line 10438: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment

10434: OR lpn_cont = wms_container_pub.lpn_context_rcv
10435: OR lpn_cont = wms_container_pub.lpn_context_stores
10436: OR lpn_cont = wms_container_pub.lpn_context_intransit
10437: OR lpn_cont = wms_container_pub.lpn_context_vendor
10438: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
10439: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
10440: OR lpn_cont = wms_container_pub.lpn_context_picked
10441: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
10442: OR lpn_cont = wms_container_pub.LPN_CONTEXT_PACKING

Line 10439: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip

10435: OR lpn_cont = wms_container_pub.lpn_context_stores
10436: OR lpn_cont = wms_container_pub.lpn_context_intransit
10437: OR lpn_cont = wms_container_pub.lpn_context_vendor
10438: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
10439: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
10440: OR lpn_cont = wms_container_pub.lpn_context_picked
10441: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
10442: OR lpn_cont = wms_container_pub.LPN_CONTEXT_PACKING
10443: ) THEN

Line 10440: OR lpn_cont = wms_container_pub.lpn_context_picked

10436: OR lpn_cont = wms_container_pub.lpn_context_intransit
10437: OR lpn_cont = wms_container_pub.lpn_context_vendor
10438: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
10439: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
10440: OR lpn_cont = wms_container_pub.lpn_context_picked
10441: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
10442: OR lpn_cont = wms_container_pub.LPN_CONTEXT_PACKING
10443: ) THEN
10444: --OR (l_org_id is not null and l_org_id <> p_org_id)

Line 10441: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV

10437: OR lpn_cont = wms_container_pub.lpn_context_vendor
10438: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
10439: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
10440: OR lpn_cont = wms_container_pub.lpn_context_picked
10441: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
10442: OR lpn_cont = wms_container_pub.LPN_CONTEXT_PACKING
10443: ) THEN
10444: --OR (l_org_id is not null and l_org_id <> p_org_id)
10445:

Line 10442: OR lpn_cont = wms_container_pub.LPN_CONTEXT_PACKING

10438: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
10439: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
10440: OR lpn_cont = wms_container_pub.lpn_context_picked
10441: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
10442: OR lpn_cont = wms_container_pub.LPN_CONTEXT_PACKING
10443: ) THEN
10444: --OR (l_org_id is not null and l_org_id <> p_org_id)
10445:
10446: IF (l_debug = 1) THEN

Line 10458: lpn_cont = wms_container_pub.lpn_context_wip

10454: END IF;
10455:
10456: ELSE -- Not Honor Case Pick
10457: IF (
10458: lpn_cont = wms_container_pub.lpn_context_wip
10459: OR lpn_cont = wms_container_pub.lpn_context_rcv
10460: OR lpn_cont = wms_container_pub.lpn_context_stores
10461: OR lpn_cont = wms_container_pub.lpn_context_intransit
10462: OR lpn_cont = wms_container_pub.lpn_context_vendor

Line 10459: OR lpn_cont = wms_container_pub.lpn_context_rcv

10455:
10456: ELSE -- Not Honor Case Pick
10457: IF (
10458: lpn_cont = wms_container_pub.lpn_context_wip
10459: OR lpn_cont = wms_container_pub.lpn_context_rcv
10460: OR lpn_cont = wms_container_pub.lpn_context_stores
10461: OR lpn_cont = wms_container_pub.lpn_context_intransit
10462: OR lpn_cont = wms_container_pub.lpn_context_vendor
10463: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment

Line 10460: OR lpn_cont = wms_container_pub.lpn_context_stores

10456: ELSE -- Not Honor Case Pick
10457: IF (
10458: lpn_cont = wms_container_pub.lpn_context_wip
10459: OR lpn_cont = wms_container_pub.lpn_context_rcv
10460: OR lpn_cont = wms_container_pub.lpn_context_stores
10461: OR lpn_cont = wms_container_pub.lpn_context_intransit
10462: OR lpn_cont = wms_container_pub.lpn_context_vendor
10463: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
10464: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip

Line 10461: OR lpn_cont = wms_container_pub.lpn_context_intransit

10457: IF (
10458: lpn_cont = wms_container_pub.lpn_context_wip
10459: OR lpn_cont = wms_container_pub.lpn_context_rcv
10460: OR lpn_cont = wms_container_pub.lpn_context_stores
10461: OR lpn_cont = wms_container_pub.lpn_context_intransit
10462: OR lpn_cont = wms_container_pub.lpn_context_vendor
10463: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
10464: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
10465: OR lpn_cont = wms_container_pub.lpn_context_picked

Line 10462: OR lpn_cont = wms_container_pub.lpn_context_vendor

10458: lpn_cont = wms_container_pub.lpn_context_wip
10459: OR lpn_cont = wms_container_pub.lpn_context_rcv
10460: OR lpn_cont = wms_container_pub.lpn_context_stores
10461: OR lpn_cont = wms_container_pub.lpn_context_intransit
10462: OR lpn_cont = wms_container_pub.lpn_context_vendor
10463: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
10464: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
10465: OR lpn_cont = wms_container_pub.lpn_context_picked
10466: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV

Line 10463: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment

10459: OR lpn_cont = wms_container_pub.lpn_context_rcv
10460: OR lpn_cont = wms_container_pub.lpn_context_stores
10461: OR lpn_cont = wms_container_pub.lpn_context_intransit
10462: OR lpn_cont = wms_container_pub.lpn_context_vendor
10463: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
10464: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
10465: OR lpn_cont = wms_container_pub.lpn_context_picked
10466: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
10467: ) THEN

Line 10464: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip

10460: OR lpn_cont = wms_container_pub.lpn_context_stores
10461: OR lpn_cont = wms_container_pub.lpn_context_intransit
10462: OR lpn_cont = wms_container_pub.lpn_context_vendor
10463: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
10464: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
10465: OR lpn_cont = wms_container_pub.lpn_context_picked
10466: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
10467: ) THEN
10468:

Line 10465: OR lpn_cont = wms_container_pub.lpn_context_picked

10461: OR lpn_cont = wms_container_pub.lpn_context_intransit
10462: OR lpn_cont = wms_container_pub.lpn_context_vendor
10463: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
10464: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
10465: OR lpn_cont = wms_container_pub.lpn_context_picked
10466: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
10467: ) THEN
10468:
10469: IF (l_debug = 1) THEN

Line 10466: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV

10462: OR lpn_cont = wms_container_pub.lpn_context_vendor
10463: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
10464: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
10465: OR lpn_cont = wms_container_pub.lpn_context_picked
10466: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
10467: ) THEN
10468:
10469: IF (l_debug = 1) THEN
10470: mydebug('check_pack_lpn: LPN already exists but with different context or Org');

Line 10483: mydebug('check_pack_lpn: calling wms_container_pub.create_lpn');

10479: END IF; --Bug7120019
10480:
10481: IF create_lpn = 'Y' THEN
10482: IF (l_debug = 1) THEN
10483: mydebug('check_pack_lpn: calling wms_container_pub.create_lpn');
10484: END IF;
10485:
10486: wms_container_pub.create_lpn
10487: ( p_api_version => 1.0

Line 10486: wms_container_pub.create_lpn

10482: IF (l_debug = 1) THEN
10483: mydebug('check_pack_lpn: calling wms_container_pub.create_lpn');
10484: END IF;
10485:
10486: wms_container_pub.create_lpn
10487: ( p_api_version => 1.0
10488: , x_return_status => l_return_status
10489: , x_msg_count => l_msg_count
10490: , x_msg_data => x_msg_data

Line 10832: ELSIF pick_to_lpn_rec.lpn_context = wms_container_pub.lpn_context_pregenerated THEN

10828: mydebug('validate_pick_to_lpn: Drop LPN is a new LPN, no checking required.');
10829: END IF;
10830: RETURN;
10831: --Bug 6168477 -start : Added the following ELSIF condition.
10832: ELSIF pick_to_lpn_rec.lpn_context = wms_container_pub.lpn_context_pregenerated THEN
10833: IF (l_debug = 1) THEN
10834: mydebug('validate_pick_to_lpn: Drop LPN is in context 5,check if associated records are presetn in WDD.');
10835: END IF;
10836: OPEN c_wdd_exists(pick_to_lpn_rec.lpn_id,p_organization_id);

Line 10925: AND lpn_context IN (wms_container_pub.lpn_context_packing, wms_container_pub.LPN_CONTEXT_PREGENERATED);

10921: INTO l_container_item_id
10922: FROM wms_license_plate_numbers
10923: WHERE license_plate_number = p_pick_to_lpn
10924: AND organization_id = p_organization_id
10925: AND lpn_context IN (wms_container_pub.lpn_context_packing, wms_container_pub.LPN_CONTEXT_PREGENERATED);
10926: EXCEPTION
10927: WHEN no_data_found THEN
10928: -- error out and assuming it should exist
10929: -- tolpn doesn't existing or if existing, but has wrong context

Line 11066: * IF pick_to_lpn_rec.lpn_context = wms_container_pub.lpn_context_pregenerated THEN

11062: -- Changed the context to be updated to 8 instead of 1 as done earlier
11063: --
11064: /* Mrana: 12/10/03: we need not change the context in this API. We will do it at LOAD
11065: * or Pick More . i.e. Task_load or Task_merge_split API RESP.
11066: * IF pick_to_lpn_rec.lpn_context = wms_container_pub.lpn_context_pregenerated THEN
11067: --
11068: -- Update the context to "Packing Context" (8)
11069: --
11070: UPDATE wms_license_plate_numbers

Line 11071: SET lpn_context = wms_container_pub.lpn_context_packing

11067: --
11068: -- Update the context to "Packing Context" (8)
11069: --
11070: UPDATE wms_license_plate_numbers
11071: SET lpn_context = wms_container_pub.lpn_context_packing
11072: WHERE lpn_id = pick_to_lpn_rec.lpn_id;
11073:
11074: IF (l_debug = 1) THEN
11075: mydebug('validate_pick_to_lpn: Drop LPN is pre-generated, no checking required.');