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 1240: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;

1236: l_transfer_lpn_id NUMBER := p_transfer_lpn_id;
1237: l_container_item_id NUMBER := p_container_item_id;
1238: l_lpn_match_lpn_id NUMBER := p_lpn_match_lpn_id;
1239:
1240: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
1241: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
1242: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
1243: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
1244:

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

1237: l_container_item_id NUMBER := p_container_item_id;
1238: l_lpn_match_lpn_id NUMBER := p_lpn_match_lpn_id;
1239:
1240: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
1241: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
1242: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
1243: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
1244:
1245: CURSOR cur_split_mmtts

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

1238: l_lpn_match_lpn_id NUMBER := p_lpn_match_lpn_id;
1239:
1240: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
1241: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
1242: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
1243: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
1244:
1245: CURSOR cur_split_mmtts
1246: IS

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

1239:
1240: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
1241: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
1242: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
1243: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
1244:
1245: CURSOR cur_split_mmtts
1246: IS
1247: SELECT transaction_temp_id

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

6705: IS
6706: l_proc_name VARCHAR2(30) := 'PROC_RESET_LPN_CONTEXT';
6707: l_progress VARCHAR2(30) := '100';
6708: l_other_tasks NUMBER := 0;
6709: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
6710: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
6711: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
6712: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
6713:

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

6706: l_proc_name VARCHAR2(30) := 'PROC_RESET_LPN_CONTEXT';
6707: l_progress VARCHAR2(30) := '100';
6708: l_other_tasks NUMBER := 0;
6709: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
6710: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
6711: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
6712: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
6713:
6714: CURSOR cur_from_lpns IS

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

6707: l_progress VARCHAR2(30) := '100';
6708: l_other_tasks NUMBER := 0;
6709: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
6710: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
6711: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
6712: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
6713:
6714: CURSOR cur_from_lpns IS
6715: SELECT DISTINCT lpn_id

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

6708: l_other_tasks NUMBER := 0;
6709: l_lpn_context_pregenerated CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
6710: l_lpn_context_inv CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_INV;
6711: l_lpn_context_picked CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PICKED;
6712: l_lpn_context_packing CONSTANT NUMBER := WMS_Container_PUB.LPN_CONTEXT_PACKING ;
6713:
6714: CURSOR cur_from_lpns IS
6715: SELECT DISTINCT lpn_id
6716: FROM mtl_material_transactions_temp

Line 8669: OR l_lpn_context <> wms_container_pub.lpn_context_inv THEN

8665: END;
8666:
8667: IF l_lpn_exists = 0
8668: OR p_fromlpn_id = 0
8669: OR l_lpn_context <> wms_container_pub.lpn_context_inv THEN
8670: IF (l_debug = 1) THEN
8671: mydebug('LPN does not exist in org');
8672: END IF;
8673:

Line 12725: lpn_cont = wms_container_pub.lpn_context_wip

12721:
12722: IF (create_lpn = 'N') THEN
12723: IF (wms_control.g_current_release_level >= 120001 AND honor_case_pick_count > 0) THEN
12724: IF (
12725: lpn_cont = wms_container_pub.lpn_context_wip
12726: OR lpn_cont = wms_container_pub.lpn_context_rcv
12727: OR lpn_cont = wms_container_pub.lpn_context_stores
12728: OR lpn_cont = wms_container_pub.lpn_context_intransit
12729: OR lpn_cont = wms_container_pub.lpn_context_vendor

Line 12726: OR lpn_cont = wms_container_pub.lpn_context_rcv

12722: IF (create_lpn = 'N') THEN
12723: IF (wms_control.g_current_release_level >= 120001 AND honor_case_pick_count > 0) THEN
12724: IF (
12725: lpn_cont = wms_container_pub.lpn_context_wip
12726: OR lpn_cont = wms_container_pub.lpn_context_rcv
12727: OR lpn_cont = wms_container_pub.lpn_context_stores
12728: OR lpn_cont = wms_container_pub.lpn_context_intransit
12729: OR lpn_cont = wms_container_pub.lpn_context_vendor
12730: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment

Line 12727: OR lpn_cont = wms_container_pub.lpn_context_stores

12723: IF (wms_control.g_current_release_level >= 120001 AND honor_case_pick_count > 0) THEN
12724: IF (
12725: lpn_cont = wms_container_pub.lpn_context_wip
12726: OR lpn_cont = wms_container_pub.lpn_context_rcv
12727: OR lpn_cont = wms_container_pub.lpn_context_stores
12728: OR lpn_cont = wms_container_pub.lpn_context_intransit
12729: OR lpn_cont = wms_container_pub.lpn_context_vendor
12730: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
12731: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip

Line 12728: OR lpn_cont = wms_container_pub.lpn_context_intransit

12724: IF (
12725: lpn_cont = wms_container_pub.lpn_context_wip
12726: OR lpn_cont = wms_container_pub.lpn_context_rcv
12727: OR lpn_cont = wms_container_pub.lpn_context_stores
12728: OR lpn_cont = wms_container_pub.lpn_context_intransit
12729: OR lpn_cont = wms_container_pub.lpn_context_vendor
12730: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
12731: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
12732: OR lpn_cont = wms_container_pub.lpn_context_picked

Line 12729: OR lpn_cont = wms_container_pub.lpn_context_vendor

12725: lpn_cont = wms_container_pub.lpn_context_wip
12726: OR lpn_cont = wms_container_pub.lpn_context_rcv
12727: OR lpn_cont = wms_container_pub.lpn_context_stores
12728: OR lpn_cont = wms_container_pub.lpn_context_intransit
12729: OR lpn_cont = wms_container_pub.lpn_context_vendor
12730: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
12731: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
12732: OR lpn_cont = wms_container_pub.lpn_context_picked
12733: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV

Line 12730: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment

12726: OR lpn_cont = wms_container_pub.lpn_context_rcv
12727: OR lpn_cont = wms_container_pub.lpn_context_stores
12728: OR lpn_cont = wms_container_pub.lpn_context_intransit
12729: OR lpn_cont = wms_container_pub.lpn_context_vendor
12730: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
12731: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
12732: OR lpn_cont = wms_container_pub.lpn_context_picked
12733: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
12734: OR lpn_cont = wms_container_pub.LPN_CONTEXT_PACKING

Line 12731: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip

12727: OR lpn_cont = wms_container_pub.lpn_context_stores
12728: OR lpn_cont = wms_container_pub.lpn_context_intransit
12729: OR lpn_cont = wms_container_pub.lpn_context_vendor
12730: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
12731: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
12732: OR lpn_cont = wms_container_pub.lpn_context_picked
12733: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
12734: OR lpn_cont = wms_container_pub.LPN_CONTEXT_PACKING
12735: ) THEN

Line 12732: OR lpn_cont = wms_container_pub.lpn_context_picked

12728: OR lpn_cont = wms_container_pub.lpn_context_intransit
12729: OR lpn_cont = wms_container_pub.lpn_context_vendor
12730: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
12731: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
12732: OR lpn_cont = wms_container_pub.lpn_context_picked
12733: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
12734: OR lpn_cont = wms_container_pub.LPN_CONTEXT_PACKING
12735: ) THEN
12736: --OR (l_org_id is not null and l_org_id <> p_org_id)

Line 12733: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV

12729: OR lpn_cont = wms_container_pub.lpn_context_vendor
12730: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
12731: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
12732: OR lpn_cont = wms_container_pub.lpn_context_picked
12733: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
12734: OR lpn_cont = wms_container_pub.LPN_CONTEXT_PACKING
12735: ) THEN
12736: --OR (l_org_id is not null and l_org_id <> p_org_id)
12737:

Line 12734: OR lpn_cont = wms_container_pub.LPN_CONTEXT_PACKING

12730: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
12731: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
12732: OR lpn_cont = wms_container_pub.lpn_context_picked
12733: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
12734: OR lpn_cont = wms_container_pub.LPN_CONTEXT_PACKING
12735: ) THEN
12736: --OR (l_org_id is not null and l_org_id <> p_org_id)
12737:
12738: IF (l_debug = 1) THEN

Line 12751: lpn_cont = wms_container_pub.lpn_context_wip

12747: END IF;
12748:
12749: ELSE -- Not Honor Case Pick
12750: IF (
12751: lpn_cont = wms_container_pub.lpn_context_wip
12752: OR lpn_cont = wms_container_pub.lpn_context_rcv
12753: OR lpn_cont = wms_container_pub.lpn_context_stores
12754: OR lpn_cont = wms_container_pub.lpn_context_intransit
12755: OR lpn_cont = wms_container_pub.lpn_context_vendor

Line 12752: OR lpn_cont = wms_container_pub.lpn_context_rcv

12748:
12749: ELSE -- Not Honor Case Pick
12750: IF (
12751: lpn_cont = wms_container_pub.lpn_context_wip
12752: OR lpn_cont = wms_container_pub.lpn_context_rcv
12753: OR lpn_cont = wms_container_pub.lpn_context_stores
12754: OR lpn_cont = wms_container_pub.lpn_context_intransit
12755: OR lpn_cont = wms_container_pub.lpn_context_vendor
12756: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment

Line 12753: OR lpn_cont = wms_container_pub.lpn_context_stores

12749: ELSE -- Not Honor Case Pick
12750: IF (
12751: lpn_cont = wms_container_pub.lpn_context_wip
12752: OR lpn_cont = wms_container_pub.lpn_context_rcv
12753: OR lpn_cont = wms_container_pub.lpn_context_stores
12754: OR lpn_cont = wms_container_pub.lpn_context_intransit
12755: OR lpn_cont = wms_container_pub.lpn_context_vendor
12756: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
12757: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip

Line 12754: OR lpn_cont = wms_container_pub.lpn_context_intransit

12750: IF (
12751: lpn_cont = wms_container_pub.lpn_context_wip
12752: OR lpn_cont = wms_container_pub.lpn_context_rcv
12753: OR lpn_cont = wms_container_pub.lpn_context_stores
12754: OR lpn_cont = wms_container_pub.lpn_context_intransit
12755: OR lpn_cont = wms_container_pub.lpn_context_vendor
12756: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
12757: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
12758: OR lpn_cont = wms_container_pub.lpn_context_picked

Line 12755: OR lpn_cont = wms_container_pub.lpn_context_vendor

12751: lpn_cont = wms_container_pub.lpn_context_wip
12752: OR lpn_cont = wms_container_pub.lpn_context_rcv
12753: OR lpn_cont = wms_container_pub.lpn_context_stores
12754: OR lpn_cont = wms_container_pub.lpn_context_intransit
12755: OR lpn_cont = wms_container_pub.lpn_context_vendor
12756: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
12757: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
12758: OR lpn_cont = wms_container_pub.lpn_context_picked
12759: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV

Line 12756: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment

12752: OR lpn_cont = wms_container_pub.lpn_context_rcv
12753: OR lpn_cont = wms_container_pub.lpn_context_stores
12754: OR lpn_cont = wms_container_pub.lpn_context_intransit
12755: OR lpn_cont = wms_container_pub.lpn_context_vendor
12756: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
12757: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
12758: OR lpn_cont = wms_container_pub.lpn_context_picked
12759: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
12760: ) THEN

Line 12757: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip

12753: OR lpn_cont = wms_container_pub.lpn_context_stores
12754: OR lpn_cont = wms_container_pub.lpn_context_intransit
12755: OR lpn_cont = wms_container_pub.lpn_context_vendor
12756: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
12757: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
12758: OR lpn_cont = wms_container_pub.lpn_context_picked
12759: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
12760: ) THEN
12761:

Line 12758: OR lpn_cont = wms_container_pub.lpn_context_picked

12754: OR lpn_cont = wms_container_pub.lpn_context_intransit
12755: OR lpn_cont = wms_container_pub.lpn_context_vendor
12756: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
12757: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
12758: OR lpn_cont = wms_container_pub.lpn_context_picked
12759: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
12760: ) THEN
12761:
12762: IF (l_debug = 1) THEN

Line 12759: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV

12755: OR lpn_cont = wms_container_pub.lpn_context_vendor
12756: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
12757: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
12758: OR lpn_cont = wms_container_pub.lpn_context_picked
12759: OR lpn_cont = wms_container_pub.LPN_CONTEXT_INV
12760: ) THEN
12761:
12762: IF (l_debug = 1) THEN
12763: mydebug('check_pack_lpn: LPN already exists but with different context or Org');

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

12773: END IF; --Bug7120019
12774:
12775: IF create_lpn = 'Y' THEN
12776: IF (l_debug = 1) THEN
12777: mydebug('check_pack_lpn: calling wms_container_pub.create_lpn');
12778: END IF;
12779:
12780: wms_container_pub.create_lpn
12781: ( p_api_version => 1.0

Line 12780: wms_container_pub.create_lpn

12776: IF (l_debug = 1) THEN
12777: mydebug('check_pack_lpn: calling wms_container_pub.create_lpn');
12778: END IF;
12779:
12780: wms_container_pub.create_lpn
12781: ( p_api_version => 1.0
12782: , x_return_status => l_return_status
12783: , x_msg_count => l_msg_count
12784: , x_msg_data => x_msg_data

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

13124: mydebug('validate_pick_to_lpn: Drop LPN is a new LPN, no checking required.');
13125: END IF;
13126: RETURN;
13127: --Bug 6168477 -start : Added the following ELSIF condition.
13128: ELSIF pick_to_lpn_rec.lpn_context = wms_container_pub.lpn_context_pregenerated THEN
13129: IF (l_debug = 1) THEN
13130: mydebug('validate_pick_to_lpn: Drop LPN is in context 5,check if associated records are presetn in WDD.');
13131: END IF;
13132: OPEN c_wdd_exists(pick_to_lpn_rec.lpn_id,p_organization_id);

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

13217: INTO l_container_item_id
13218: FROM wms_license_plate_numbers
13219: WHERE license_plate_number = p_pick_to_lpn
13220: AND organization_id = p_organization_id
13221: AND lpn_context IN (wms_container_pub.lpn_context_packing, wms_container_pub.LPN_CONTEXT_PREGENERATED);
13222: EXCEPTION
13223: WHEN no_data_found THEN
13224: -- error out and assuming it should exist
13225: -- tolpn doesn't existing or if existing, but has wrong context