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

Line 1795: wms_container_pub.create_lpn(

1791: IF (l_debug = 1) THEN
1792: mydebug('complete_pick: Creating LPN');
1793: END IF;
1794:
1795: wms_container_pub.create_lpn(
1796: p_api_version => 1.0
1797: , p_init_msg_list => fnd_api.g_false
1798: , p_commit => fnd_api.g_false
1799: , x_return_status => l_return_status

Line 1810: , p_source => WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED --Bug#4864812.

1806: , p_revision => NULL
1807: , p_serial_number => NULL
1808: , p_subinventory => p_sub
1809: , p_locator_id => l_loc
1810: , p_source => WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED --Bug#4864812.
1811: , p_cost_group_id => NULL
1812: , x_lpn_id => l_lpn_id
1813: );
1814: fnd_msg_pub.count_and_get(p_count => l_msg_cnt, p_data => l_msg_data);

Line 2769: OR l_lpn_context <> wms_container_pub.lpn_context_inv THEN

2765: END;
2766:
2767: IF l_lpn_exists = 0
2768: OR p_lpn = 0
2769: OR l_lpn_context <> wms_container_pub.lpn_context_inv THEN
2770: IF (l_debug = 1) THEN
2771: mydebug('lpn_match: lpn does not exist in org');
2772: END IF;
2773:

Line 5032: SET lpn_context = wms_container_pub.lpn_context_packing

5028: END IF;
5029:
5030: -- Bug5659809: update last_update_date and last_update_by as well
5031: UPDATE wms_license_plate_numbers
5032: SET lpn_context = wms_container_pub.lpn_context_packing
5033: , last_update_date = SYSDATE
5034: , last_updated_by = fnd_global.user_id
5035: WHERE lpn_id = p_lpn;
5036: END IF;

Line 5176: l_to_lpn_context NUMBER := wms_container_pub.lpn_context_packing;

5172: l_mmtt2_primary_qty NUMBER;
5173: l_business_flow_code NUMBER;
5174: l_tran_type_id NUMBER;
5175: l_tran_source_type_id NUMBER;
5176: l_to_lpn_context NUMBER := wms_container_pub.lpn_context_packing;
5177: l_loaded NUMBER := 0;
5178:
5179: CURSOR mmtt_csr2(p_transaction_header_id NUMBER) IS
5180: SELECT mmtt.transaction_temp_id

Line 5238: wms_container_pub.create_lpn(

5234: IF (l_debug = 1) THEN
5235: mydebug('load_pick: Creating LPN. LPN does not exist');
5236: END IF;
5237:
5238: wms_container_pub.create_lpn(
5239: p_api_version => 1.0
5240: , p_init_msg_list => fnd_api.g_false
5241: , p_commit => fnd_api.g_false
5242: , x_return_status => l_return_status

Line 5343: -- IF l_to_lpn_context = wms_container_pub.lpn_context_pregenerated THEN

5339:
5340: x_out_lpn := l_to_lpn_id;
5341:
5342: -- Removed following check for bug 2769358
5343: -- IF l_to_lpn_context = wms_container_pub.lpn_context_pregenerated THEN
5344: --
5345: -- Update the context to "Packing context" (8)
5346: --
5347: -- Bug5659809: update last_update_date and last_update_by as well

Line 5349: SET lpn_context = wms_container_pub.lpn_context_packing

5345: -- Update the context to "Packing context" (8)
5346: --
5347: -- Bug5659809: update last_update_date and last_update_by as well
5348: UPDATE wms_license_plate_numbers
5349: SET lpn_context = wms_container_pub.lpn_context_packing
5350: , last_update_date = SYSDATE
5351: , last_updated_by = fnd_global.user_id
5352: WHERE lpn_id = l_to_lpn_id;
5353: -- END IF;

Line 5437: SET lpn_context = wms_container_pub.lpn_context_packing

5433: END IF;
5434:
5435: -- Bug5659809: update last_update_date and last_update_by as well
5436: UPDATE wms_license_plate_numbers
5437: SET lpn_context = wms_container_pub.lpn_context_packing
5438: , last_update_date = SYSDATE
5439: , last_updated_by = fnd_global.user_id
5440: WHERE lpn_id = l_content_lpn_id;
5441: END IF;

Line 6165: wms_container_pub.create_lpn(

6161: IF (l_debug = 1) THEN
6162: mydebug('insert_mmtt_pack: Creating LPN');
6163: END IF;
6164:
6165: wms_container_pub.create_lpn(
6166: p_api_version => 1.0
6167: , p_init_msg_list => fnd_api.g_false
6168: , p_commit => fnd_api.g_false
6169: , x_return_status => l_return_status

Line 6702: AND lpn_context<>wms_container_pub.lpn_context_packing;*/

6698: /* SELECT COUNT(*) INTO l_exist_lpn
6699: FROM WMS_LICENSE_PLATE_NUMBERS
6700: WHERE license_plate_number=l_lpn_name
6701: AND organization_id=l_org_id
6702: AND lpn_context<>wms_container_pub.lpn_context_packing;*/
6703: BEGIN
6704: SELECT 1
6705: INTO l_exist_lpn
6706: FROM DUAL

Line 6712: AND lpn_context <> wms_container_pub.lpn_context_packing);

6708: SELECT 1
6709: FROM wms_license_plate_numbers
6710: WHERE license_plate_number = l_lpn_name
6711: AND organization_id = l_org_id
6712: AND lpn_context <> wms_container_pub.lpn_context_packing);
6713: EXCEPTION
6714: WHEN NO_DATA_FOUND THEN
6715: l_exist_lpn := 0;
6716: END;

Line 6763: wms_container_pub.modify_lpn_wrapper(

6759: IF (l_debug = 1) THEN
6760: mydebug('Modifying LPN: b_can_modify = TRUE');
6761: END IF;
6762:
6763: wms_container_pub.modify_lpn_wrapper(
6764: p_api_version => 1.0
6765: , p_init_msg_list => fnd_api.g_false
6766: , p_commit => fnd_api.g_false
6767: , x_return_status => l_return_status

Line 6779: , p_lpn_context => wms_container_pub.lpn_context_packing

6775: , p_gross_weight => NULL
6776: , p_volume_uom_code => NULL
6777: , p_content_volume => NULL
6778: , p_status_id => NULL
6779: , p_lpn_context => wms_container_pub.lpn_context_packing
6780: , p_sealed_status => NULL
6781: , p_organization_id => l_org_id
6782: , p_subinventory => NULL
6783: , p_locator_id => NULL

Line 8131: IF pick_to_lpn_rec.lpn_context = wms_container_pub.lpn_context_pregenerated THEN

8127: --
8128: -- If the drop lpn was pre-generated, no validations required
8129: -- Changed the context to be updated to 8 instead of 1 as done earlier
8130: --
8131: IF pick_to_lpn_rec.lpn_context = wms_container_pub.lpn_context_pregenerated THEN
8132: --
8133: -- Update the context to "Packing Context" (8)
8134: --
8135: -- Bug5659809: update last_update_date and last_update_by as well

Line 8137: SET lpn_context = wms_container_pub.lpn_context_packing

8133: -- Update the context to "Packing Context" (8)
8134: --
8135: -- Bug5659809: update last_update_date and last_update_by as well
8136: UPDATE wms_license_plate_numbers
8137: SET lpn_context = wms_container_pub.lpn_context_packing
8138: , last_update_date = SYSDATE
8139: , last_updated_by = fnd_global.user_id
8140: WHERE lpn_id = pick_to_lpn_rec.lpn_id;
8141:

Line 9168: wms_container_pub.create_lpn(

9164: mydebug('multiple_pick: Creating LPN');
9165: mydebug('multiple_pick: LPN does not exist');
9166: END IF;
9167:
9168: wms_container_pub.create_lpn(
9169: p_api_version => 1.0
9170: , p_init_msg_list => fnd_api.g_false
9171: , p_commit => fnd_api.g_false
9172: , x_return_status => l_return_status

Line 10486: IF l_to_lpn_context = wms_container_pub.lpn_context_pregenerated THEN

10482:
10483: -- If the pick-to LPN was pregenerated (context = 5),
10484: -- Changed the context to be updated to 8 instead of 1 as done earlier
10485:
10486: IF l_to_lpn_context = wms_container_pub.lpn_context_pregenerated THEN
10487: -- Bug5659809: update last_update_date and last_update_by as well
10488: UPDATE wms_license_plate_numbers
10489: SET lpn_context = wms_container_pub.lpn_context_packing
10490: , last_update_date = SYSDATE

Line 10489: SET lpn_context = wms_container_pub.lpn_context_packing

10485:
10486: IF l_to_lpn_context = wms_container_pub.lpn_context_pregenerated THEN
10487: -- Bug5659809: update last_update_date and last_update_by as well
10488: UPDATE wms_license_plate_numbers
10489: SET lpn_context = wms_container_pub.lpn_context_packing
10490: , last_update_date = SYSDATE
10491: , last_updated_by = fnd_global.user_id
10492: WHERE lpn_id = l_to_lpn_id;
10493: END IF;

Line 10531: l_lpn_rec wms_container_pub.lpn;

10527: , x_return_status OUT NOCOPY VARCHAR2
10528: , x_msg_count OUT NOCOPY NUMBER
10529: , x_msg_data OUT NOCOPY VARCHAR2
10530: ) IS
10531: l_lpn_rec wms_container_pub.lpn;
10532: l_return_status VARCHAR2(1);
10533: l_msg_count NUMBER;
10534: l_msg_data VARCHAR2(4000);
10535: l_exist NUMBER;

Line 10567: wms_container_pub.create_lpn(

10563: IF (l_debug = 1) THEN
10564: mydebug('LPN Does not exist..');
10565: END IF;
10566:
10567: wms_container_pub.create_lpn(
10568: p_api_version => 1.0
10569: , x_return_status => l_return_status
10570: , x_msg_count => l_msg_count
10571: , x_msg_data => x_msg_data

Line 11514: l_lpn_context := wms_container_pub.lpn_context_picked;

11510: ELSE
11511: l_xfrlpnid := p_from_lpn_id;
11512: END IF;
11513:
11514: l_lpn_context := wms_container_pub.lpn_context_picked;
11515:
11516:
11517: IF l_tran_type_id = 35 THEN -- WIP issue
11518: l_lpn_context := wms_container_pub.lpn_context_pregenerated;

Line 11518: l_lpn_context := wms_container_pub.lpn_context_pregenerated;

11514: l_lpn_context := wms_container_pub.lpn_context_picked;
11515:
11516:
11517: IF l_tran_type_id = 35 THEN -- WIP issue
11518: l_lpn_context := wms_container_pub.lpn_context_pregenerated;
11519:
11520: ELSIF l_tran_type_id = 51 AND l_tran_source_type_id = 13 THEN --Backflush
11521: -- Bug 3954141
11522: -- If destination subinventory is not lpn controlled

Line 11527: l_lpn_context := wms_container_pub.lpn_context_pregenerated;

11523: -- lpn context should be set to defined but not used
11524: --
11525: IF (l_is_transfer_sub_lpn = 2)
11526: THEN
11527: l_lpn_context := wms_container_pub.lpn_context_pregenerated;
11528: ELSE
11529: l_lpn_context := wms_container_pub.lpn_context_inv;
11530: END IF;
11531:

Line 11529: l_lpn_context := wms_container_pub.lpn_context_inv;

11525: IF (l_is_transfer_sub_lpn = 2)
11526: THEN
11527: l_lpn_context := wms_container_pub.lpn_context_pregenerated;
11528: ELSE
11529: l_lpn_context := wms_container_pub.lpn_context_inv;
11530: END IF;
11531:
11532: ELSIF l_tran_action_id = 2
11533: AND l_tran_source_type_id IN (13)

Line 11535: l_lpn_context := wms_container_pub.lpn_context_picked;

11531:
11532: ELSIF l_tran_action_id = 2
11533: AND l_tran_source_type_id IN (13)
11534: AND l_task_type IN (7) THEN --Staging move
11535: l_lpn_context := wms_container_pub.lpn_context_picked;
11536:
11537: ELSIF l_tran_action_id = 2
11538: AND l_tran_source_type_id IN(4, 13) THEN --Replenishment
11539:

Line 11560: l_lpn_context := wms_container_pub.LPN_CONTEXT_PREGENERATED;

11556: mydebug('pick_drop: Values of l_transfer_loc:' || l_transfer_loc);
11557: END IF;
11558:
11559: IF l_check_tasks = 0 THEN
11560: l_lpn_context := wms_container_pub.LPN_CONTEXT_PREGENERATED;
11561: ELSE
11562: l_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;
11563: END IF;
11564:

Line 11562: l_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;

11558:
11559: IF l_check_tasks = 0 THEN
11560: l_lpn_context := wms_container_pub.LPN_CONTEXT_PREGENERATED;
11561: ELSE
11562: l_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;
11563: END IF;
11564:
11565: UPDATE mtl_material_transactions_temp
11566: SET transfer_lpn_id = NULL

Line 11573: l_lpn_context := wms_container_pub.lpn_context_inv;

11569: ELSE
11570:
11571: IF l_xfrlpnid<>l_transfer_lpn_id THEN
11572:
11573: l_lpn_context := wms_container_pub.lpn_context_inv;
11574:
11575: UPDATE mtl_material_transactions_temp
11576: SET transfer_lpn_id = l_xfrlpnid
11577: WHERE transaction_header_id = l_txn_header_id;

Line 11580: l_from_lpn_context := wms_container_pub.LPN_CONTEXT_PREGENERATED;

11576: SET transfer_lpn_id = l_xfrlpnid
11577: WHERE transaction_header_id = l_txn_header_id;
11578:
11579: IF (l_check_tasks=0) THEN
11580: l_from_lpn_context := wms_container_pub.LPN_CONTEXT_PREGENERATED;
11581: ELSE
11582: l_from_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;
11583: END IF;
11584:

Line 11582: l_from_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;

11578:
11579: IF (l_check_tasks=0) THEN
11580: l_from_lpn_context := wms_container_pub.LPN_CONTEXT_PREGENERATED;
11581: ELSE
11582: l_from_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;
11583: END IF;
11584:
11585: l_update_frm_lpn :=TRUE;
11586:

Line 11591: l_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;

11587: ELSE
11588:
11589: IF l_check_tasks>0 THEN
11590:
11591: l_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;
11592:
11593: UPDATE mtl_material_transactions_temp
11594: SET transfer_lpn_id = null
11595: WHERE transaction_header_id = l_txn_header_id;

Line 11598: l_lpn_context := wms_container_pub.lpn_context_inv;

11594: SET transfer_lpn_id = null
11595: WHERE transaction_header_id = l_txn_header_id;
11596:
11597: ELSE
11598: l_lpn_context := wms_container_pub.lpn_context_inv;
11599: END IF;
11600: END IF;
11601:
11602: END IF;

Line 11604: l_lpn_context := wms_container_pub.lpn_context_inv;

11600: END IF;
11601:
11602: END IF;
11603: /*
11604: l_lpn_context := wms_container_pub.lpn_context_inv;
11605:
11606: --
11607: -- Bug 3160462:
11608: -- If its a no lpn controlled transfer

Line 11632: l_lpn_context := wms_container_pub.LPN_CONTEXT_PREGENERATED;

11628: FROM mtl_material_transactions_temp mmtt
11629: WHERE transfer_lpn_id = l_transfer_lpn_id
11630: AND transaction_temp_id <> l_temp_id ;
11631: IF l_check_tasks = 0 THEN
11632: l_lpn_context := wms_container_pub.LPN_CONTEXT_PREGENERATED;
11633: ELSE
11634: l_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;
11635: END IF;
11636:

Line 11634: l_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;

11630: AND transaction_temp_id <> l_temp_id ;
11631: IF l_check_tasks = 0 THEN
11632: l_lpn_context := wms_container_pub.LPN_CONTEXT_PREGENERATED;
11633: ELSE
11634: l_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;
11635: END IF;
11636:
11637: --End of fix for Bug 5318552
11638:

Line 11642: l_lpn_context := wms_container_pub.lpn_context_inv;

11638:
11639: END IF; */
11640: ELSIF wms_task_utils_pvt.can_drop(p_lpn_id => p_from_lpn_id) = 'W' THEN
11641: -- Sales order cancelled
11642: l_lpn_context := wms_container_pub.lpn_context_inv;
11643: END IF;
11644:
11645: --Bug # 2275770
11646: --Update mmtt.transaction_date to sysdate

Line 12417: l_lpn_context := wms_container_pub.LPN_CONTEXT_PREGENERATED;

12413: FROM mtl_material_transactions_temp mmtt
12414: WHERE transfer_lpn_id = l_transfer_lpn_id
12415: AND transaction_temp_id <> l_temp_id ;
12416: IF l_check_tasks = 0 THEN
12417: l_lpn_context := wms_container_pub.LPN_CONTEXT_PREGENERATED;
12418: ELSE
12419: l_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;
12420: END IF;
12421: END IF;

Line 12419: l_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;

12415: AND transaction_temp_id <> l_temp_id ;
12416: IF l_check_tasks = 0 THEN
12417: l_lpn_context := wms_container_pub.LPN_CONTEXT_PREGENERATED;
12418: ELSE
12419: l_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;
12420: END IF;
12421: END IF;
12422: --12595055 End
12423:

Line 12432: IF ( l_lpn_context <> wms_container_pub.lpn_context_picked ) THEN

12428: mydebug('coming to my debug to print the value of l_transfer_lpn_id ' || l_transfer_lpn_id);
12429: END IF;
12430:
12431: -- Bug 4238917 no longer update lpn_context to 11 outside of TM
12432: IF ( l_lpn_context <> wms_container_pub.lpn_context_picked ) THEN
12433: wms_container_pub.modify_lpn_wrapper
12434: ( p_api_version => 1.0
12435: , x_return_status => l_return_status
12436: , x_msg_count => l_msg_count

Line 12433: wms_container_pub.modify_lpn_wrapper

12429: END IF;
12430:
12431: -- Bug 4238917 no longer update lpn_context to 11 outside of TM
12432: IF ( l_lpn_context <> wms_container_pub.lpn_context_picked ) THEN
12433: wms_container_pub.modify_lpn_wrapper
12434: ( p_api_version => 1.0
12435: , x_return_status => l_return_status
12436: , x_msg_count => l_msg_count
12437: , x_msg_data => l_msg_data

Line 12451: IF ( l_from_lpn_context <> wms_container_pub.lpn_context_picked ) THEN

12447:
12448: -- Added for bug 12853197
12449: IF l_update_frm_lpn=TRUE THEN
12450:
12451: IF ( l_from_lpn_context <> wms_container_pub.lpn_context_picked ) THEN
12452: wms_container_pub.modify_lpn_wrapper
12453: ( p_api_version => 1.0
12454: , x_return_status => l_return_status
12455: , x_msg_count => l_msg_count

Line 12452: wms_container_pub.modify_lpn_wrapper

12448: -- Added for bug 12853197
12449: IF l_update_frm_lpn=TRUE THEN
12450:
12451: IF ( l_from_lpn_context <> wms_container_pub.lpn_context_picked ) THEN
12452: wms_container_pub.modify_lpn_wrapper
12453: ( p_api_version => 1.0
12454: , x_return_status => l_return_status
12455: , x_msg_count => l_msg_count
12456: , x_msg_data => l_msg_data

Line 12472: wms_container_pub.modify_lpn_wrapper

12468:
12469: ELSE
12470: /*Bug#6677616. For picked LPN, we will call the below API inorder to update shipping
12471: about the weight, volume etc of LPN so that it gets reflected in shipping tables.*/
12472: wms_container_pub.modify_lpn_wrapper
12473: ( p_api_version => 1.0
12474: , x_return_status => l_return_status
12475: , x_msg_count => l_msg_count
12476: , x_msg_data => l_msg_data

Line 12485: wms_container_pub.modify_lpn_wrapper

12481: END IF;
12482: ELSE
12483: /*Bug#6712364. For picked LPN, we will call the below API(wihout hcnaging anything) inorder to
12484: update shipping about the weight, volume etc of LPN so that it gets reflected in shipping tables.*/
12485: wms_container_pub.modify_lpn_wrapper
12486: ( p_api_version => 1.0
12487: , x_return_status => l_return_status
12488: , x_msg_count => l_msg_count
12489: , x_msg_data => l_msg_data

Line 12515: IF l_lpn_context = wms_container_pub.lpn_context_picked THEN

12511: /*
12512: -- IF droplpngenerated and lpn_context = PICKED then update the
12513: -- lpn_context of the from_lpn also.
12514: IF l_isdroplpnentered = TRUE THEN
12515: IF l_lpn_context = wms_container_pub.lpn_context_picked THEN
12516: wms_container_pub.modify_lpn_wrapper(
12517: p_api_version => 1.0
12518: , x_return_status => l_return_status
12519: , x_msg_count => l_msg_count

Line 12516: wms_container_pub.modify_lpn_wrapper(

12512: -- IF droplpngenerated and lpn_context = PICKED then update the
12513: -- lpn_context of the from_lpn also.
12514: IF l_isdroplpnentered = TRUE THEN
12515: IF l_lpn_context = wms_container_pub.lpn_context_picked THEN
12516: wms_container_pub.modify_lpn_wrapper(
12517: p_api_version => 1.0
12518: , x_return_status => l_return_status
12519: , x_msg_count => l_msg_count
12520: , x_msg_data => l_msg_data

Line 13530: lpn_cont = wms_container_pub.lpn_context_wip

13526: IF (
13527: create_lpn = 'N'
13528: AND(
13529: (
13530: lpn_cont = wms_container_pub.lpn_context_wip
13531: OR lpn_cont = wms_container_pub.lpn_context_rcv
13532: OR lpn_cont = wms_container_pub.lpn_context_stores
13533: OR lpn_cont = wms_container_pub.lpn_context_intransit
13534: OR lpn_cont = wms_container_pub.lpn_context_vendor

Line 13531: OR lpn_cont = wms_container_pub.lpn_context_rcv

13527: create_lpn = 'N'
13528: AND(
13529: (
13530: lpn_cont = wms_container_pub.lpn_context_wip
13531: OR lpn_cont = wms_container_pub.lpn_context_rcv
13532: OR lpn_cont = wms_container_pub.lpn_context_stores
13533: OR lpn_cont = wms_container_pub.lpn_context_intransit
13534: OR lpn_cont = wms_container_pub.lpn_context_vendor
13535: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment

Line 13532: OR lpn_cont = wms_container_pub.lpn_context_stores

13528: AND(
13529: (
13530: lpn_cont = wms_container_pub.lpn_context_wip
13531: OR lpn_cont = wms_container_pub.lpn_context_rcv
13532: OR lpn_cont = wms_container_pub.lpn_context_stores
13533: OR lpn_cont = wms_container_pub.lpn_context_intransit
13534: OR lpn_cont = wms_container_pub.lpn_context_vendor
13535: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
13536: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip

Line 13533: OR lpn_cont = wms_container_pub.lpn_context_intransit

13529: (
13530: lpn_cont = wms_container_pub.lpn_context_wip
13531: OR lpn_cont = wms_container_pub.lpn_context_rcv
13532: OR lpn_cont = wms_container_pub.lpn_context_stores
13533: OR lpn_cont = wms_container_pub.lpn_context_intransit
13534: OR lpn_cont = wms_container_pub.lpn_context_vendor
13535: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
13536: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
13537: OR lpn_cont = wms_container_pub.lpn_context_picked

Line 13534: OR lpn_cont = wms_container_pub.lpn_context_vendor

13530: lpn_cont = wms_container_pub.lpn_context_wip
13531: OR lpn_cont = wms_container_pub.lpn_context_rcv
13532: OR lpn_cont = wms_container_pub.lpn_context_stores
13533: OR lpn_cont = wms_container_pub.lpn_context_intransit
13534: OR lpn_cont = wms_container_pub.lpn_context_vendor
13535: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
13536: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
13537: OR lpn_cont = wms_container_pub.lpn_context_picked
13538: OR lpn_cont = wms_container_pub.lpn_context_inv --Bug 5038228

Line 13535: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment

13531: OR lpn_cont = wms_container_pub.lpn_context_rcv
13532: OR lpn_cont = wms_container_pub.lpn_context_stores
13533: OR lpn_cont = wms_container_pub.lpn_context_intransit
13534: OR lpn_cont = wms_container_pub.lpn_context_vendor
13535: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
13536: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
13537: OR lpn_cont = wms_container_pub.lpn_context_picked
13538: OR lpn_cont = wms_container_pub.lpn_context_inv --Bug 5038228
13539: )

Line 13536: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip

13532: OR lpn_cont = wms_container_pub.lpn_context_stores
13533: OR lpn_cont = wms_container_pub.lpn_context_intransit
13534: OR lpn_cont = wms_container_pub.lpn_context_vendor
13535: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
13536: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
13537: OR lpn_cont = wms_container_pub.lpn_context_picked
13538: OR lpn_cont = wms_container_pub.lpn_context_inv --Bug 5038228
13539: )
13540: OR l_org_id <> p_org_id

Line 13537: OR lpn_cont = wms_container_pub.lpn_context_picked

13533: OR lpn_cont = wms_container_pub.lpn_context_intransit
13534: OR lpn_cont = wms_container_pub.lpn_context_vendor
13535: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
13536: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
13537: OR lpn_cont = wms_container_pub.lpn_context_picked
13538: OR lpn_cont = wms_container_pub.lpn_context_inv --Bug 5038228
13539: )
13540: OR l_org_id <> p_org_id
13541: )

Line 13538: OR lpn_cont = wms_container_pub.lpn_context_inv --Bug 5038228

13534: OR lpn_cont = wms_container_pub.lpn_context_vendor
13535: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
13536: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
13537: OR lpn_cont = wms_container_pub.lpn_context_picked
13538: OR lpn_cont = wms_container_pub.lpn_context_inv --Bug 5038228
13539: )
13540: OR l_org_id <> p_org_id
13541: )
13542: ) THEN

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

13552: END IF;
13553:
13554: IF create_lpn = 'Y' THEN
13555: IF (l_debug = 1) THEN
13556: mydebug('check_pack_lpn: calling wms_container_pub.create_lpn');
13557: END IF;
13558:
13559: wms_container_pub.create_lpn
13560: ( p_api_version => 1.0

Line 13559: wms_container_pub.create_lpn

13555: IF (l_debug = 1) THEN
13556: mydebug('check_pack_lpn: calling wms_container_pub.create_lpn');
13557: END IF;
13558:
13559: wms_container_pub.create_lpn
13560: ( p_api_version => 1.0
13561: , x_return_status => l_return_status
13562: , x_msg_count => l_msg_count
13563: , x_msg_data => x_msg_data

Line 15744: WMS_Container_PUB.LPN_CONTEXT_PREGENERATED THEN

15740: -- If the drop lpn was pre-generated, no validations required
15741: --
15742:
15743: IF drop_lpn_rec.lpn_context =
15744: WMS_Container_PUB.LPN_CONTEXT_PREGENERATED THEN
15745: --
15746: -- Update the context to "Resides in Inventory" (1)
15747: --
15748: /* UPDATE wms_license_plate_numbers

Line 15749: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV

15745: --
15746: -- Update the context to "Resides in Inventory" (1)
15747: --
15748: /* UPDATE wms_license_plate_numbers
15749: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
15750: WHERE lpn_id = drop_lpn_rec.lpn_id;*/
15751:
15752: IF (l_debug = 1) THEN
15753: mydebug ('Drop LPN is pre-generated, no checking required.');

Line 15757: ELSIF drop_lpn_rec.lpn_context = WMS_Container_PUB.lpn_context_picked THEN

15753: mydebug ('Drop LPN is pre-generated, no checking required.');
15754: END IF;
15755: RETURN 1;
15756:
15757: ELSIF drop_lpn_rec.lpn_context = WMS_Container_PUB.lpn_context_picked THEN
15758: IF drop_lpn_rec.subinventory_code <> p_drop_sub or
15759: drop_lpn_rec.locator_id <> p_drop_loc THEN
15760: IF (l_debug = 1) THEN
15761: mydebug ('Drop LPN does not belong to the same sub and loc.');

Line 15768: WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT THEN

15764: END IF;
15765: END IF;
15766:
15767: IF drop_lpn_rec.lpn_context =
15768: WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT THEN
15769: IF (l_debug = 1) THEN
15770: mydebug ('Drop LPN is loaded to dock door already');
15771: END IF;
15772: RETURN 4; -- Drop LPN is loaded to dock door already