DBA Data[Home] [Help]

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 10460: IF l_to_lpn_context = wms_container_pub.lpn_context_pregenerated THEN

10456:
10457: -- If the pick-to LPN was pregenerated (context = 5),
10458: -- Changed the context to be updated to 8 instead of 1 as done earlier
10459:
10460: IF l_to_lpn_context = wms_container_pub.lpn_context_pregenerated THEN
10461: -- Bug5659809: update last_update_date and last_update_by as well
10462: UPDATE wms_license_plate_numbers
10463: SET lpn_context = wms_container_pub.lpn_context_packing
10464: , last_update_date = SYSDATE

Line 10463: SET lpn_context = wms_container_pub.lpn_context_packing

10459:
10460: IF l_to_lpn_context = wms_container_pub.lpn_context_pregenerated THEN
10461: -- Bug5659809: update last_update_date and last_update_by as well
10462: UPDATE wms_license_plate_numbers
10463: SET lpn_context = wms_container_pub.lpn_context_packing
10464: , last_update_date = SYSDATE
10465: , last_updated_by = fnd_global.user_id
10466: WHERE lpn_id = l_to_lpn_id;
10467: END IF;

Line 10505: l_lpn_rec wms_container_pub.lpn;

10501: , x_return_status OUT NOCOPY VARCHAR2
10502: , x_msg_count OUT NOCOPY NUMBER
10503: , x_msg_data OUT NOCOPY VARCHAR2
10504: ) IS
10505: l_lpn_rec wms_container_pub.lpn;
10506: l_return_status VARCHAR2(1);
10507: l_msg_count NUMBER;
10508: l_msg_data VARCHAR2(4000);
10509: l_exist NUMBER;

Line 10541: wms_container_pub.create_lpn(

10537: IF (l_debug = 1) THEN
10538: mydebug('LPN Does not exist..');
10539: END IF;
10540:
10541: wms_container_pub.create_lpn(
10542: p_api_version => 1.0
10543: , x_return_status => l_return_status
10544: , x_msg_count => l_msg_count
10545: , x_msg_data => x_msg_data

Line 11443: l_lpn_context := wms_container_pub.lpn_context_picked;

11439: ELSE
11440: l_xfrlpnid := p_from_lpn_id;
11441: END IF;
11442:
11443: l_lpn_context := wms_container_pub.lpn_context_picked;
11444:
11445:
11446: IF l_tran_type_id = 35 THEN -- WIP issue
11447: l_lpn_context := wms_container_pub.lpn_context_pregenerated;

Line 11447: l_lpn_context := wms_container_pub.lpn_context_pregenerated;

11443: l_lpn_context := wms_container_pub.lpn_context_picked;
11444:
11445:
11446: IF l_tran_type_id = 35 THEN -- WIP issue
11447: l_lpn_context := wms_container_pub.lpn_context_pregenerated;
11448:
11449: ELSIF l_tran_type_id = 51 AND l_tran_source_type_id = 13 THEN --Backflush
11450: -- Bug 3954141
11451: -- If destination subinventory is not lpn controlled

Line 11456: l_lpn_context := wms_container_pub.lpn_context_pregenerated;

11452: -- lpn context should be set to defined but not used
11453: --
11454: IF (l_is_transfer_sub_lpn = 2)
11455: THEN
11456: l_lpn_context := wms_container_pub.lpn_context_pregenerated;
11457: ELSE
11458: l_lpn_context := wms_container_pub.lpn_context_inv;
11459: END IF;
11460:

Line 11458: l_lpn_context := wms_container_pub.lpn_context_inv;

11454: IF (l_is_transfer_sub_lpn = 2)
11455: THEN
11456: l_lpn_context := wms_container_pub.lpn_context_pregenerated;
11457: ELSE
11458: l_lpn_context := wms_container_pub.lpn_context_inv;
11459: END IF;
11460:
11461: ELSIF l_tran_action_id = 2
11462: AND l_tran_source_type_id IN (13)

Line 11464: l_lpn_context := wms_container_pub.lpn_context_picked;

11460:
11461: ELSIF l_tran_action_id = 2
11462: AND l_tran_source_type_id IN (13)
11463: AND l_task_type IN (7) THEN --Staging move
11464: l_lpn_context := wms_container_pub.lpn_context_picked;
11465:
11466: ELSIF l_tran_action_id = 2
11467: AND l_tran_source_type_id IN(4, 13) THEN --Replenishment
11468: l_lpn_context := wms_container_pub.lpn_context_inv;

Line 11468: l_lpn_context := wms_container_pub.lpn_context_inv;

11464: l_lpn_context := wms_container_pub.lpn_context_picked;
11465:
11466: ELSIF l_tran_action_id = 2
11467: AND l_tran_source_type_id IN(4, 13) THEN --Replenishment
11468: l_lpn_context := wms_container_pub.lpn_context_inv;
11469:
11470: --
11471: -- Bug 3160462:
11472: -- If its a no lpn controlled transfer

Line 11496: l_lpn_context := wms_container_pub.LPN_CONTEXT_PREGENERATED;

11492: FROM mtl_material_transactions_temp mmtt
11493: WHERE transfer_lpn_id = l_transfer_lpn_id
11494: AND transaction_temp_id <> l_temp_id ;
11495: IF l_check_tasks = 0 THEN
11496: l_lpn_context := wms_container_pub.LPN_CONTEXT_PREGENERATED;
11497: ELSE
11498: l_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;
11499: END IF;
11500:

Line 11498: l_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;

11494: AND transaction_temp_id <> l_temp_id ;
11495: IF l_check_tasks = 0 THEN
11496: l_lpn_context := wms_container_pub.LPN_CONTEXT_PREGENERATED;
11497: ELSE
11498: l_lpn_context := wms_container_pub.LPN_CONTEXT_PACKING;
11499: END IF;
11500:
11501: --End of fix for Bug 5318552
11502:

Line 11506: l_lpn_context := wms_container_pub.lpn_context_inv;

11502:
11503: END IF;
11504: ELSIF wms_task_utils_pvt.can_drop(p_lpn_id => p_from_lpn_id) = 'W' THEN
11505: -- Sales order cancelled
11506: l_lpn_context := wms_container_pub.lpn_context_inv;
11507: END IF;
11508:
11509: --Bug # 2275770
11510: --Update mmtt.transaction_date to sysdate

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

12234: mydebug('pick_drop: call to modify_lpn_wrapper with lpn_context of ' || l_lpn_context);
12235: END IF;
12236:
12237: -- Bug 4238917 no longer update lpn_context to 11 outside of TM
12238: IF ( l_lpn_context <> wms_container_pub.lpn_context_picked ) THEN
12239: wms_container_pub.modify_lpn_wrapper
12240: ( p_api_version => 1.0
12241: , x_return_status => l_return_status
12242: , x_msg_count => l_msg_count

Line 12239: wms_container_pub.modify_lpn_wrapper

12235: END IF;
12236:
12237: -- Bug 4238917 no longer update lpn_context to 11 outside of TM
12238: IF ( l_lpn_context <> wms_container_pub.lpn_context_picked ) THEN
12239: wms_container_pub.modify_lpn_wrapper
12240: ( p_api_version => 1.0
12241: , x_return_status => l_return_status
12242: , x_msg_count => l_msg_count
12243: , x_msg_data => l_msg_data

Line 12269: IF l_lpn_context = wms_container_pub.lpn_context_picked THEN

12265: /*
12266: -- IF droplpngenerated and lpn_context = PICKED then update the
12267: -- lpn_context of the from_lpn also.
12268: IF l_isdroplpnentered = TRUE THEN
12269: IF l_lpn_context = wms_container_pub.lpn_context_picked THEN
12270: wms_container_pub.modify_lpn_wrapper(
12271: p_api_version => 1.0
12272: , x_return_status => l_return_status
12273: , x_msg_count => l_msg_count

Line 12270: wms_container_pub.modify_lpn_wrapper(

12266: -- IF droplpngenerated and lpn_context = PICKED then update the
12267: -- lpn_context of the from_lpn also.
12268: IF l_isdroplpnentered = TRUE THEN
12269: IF l_lpn_context = wms_container_pub.lpn_context_picked THEN
12270: wms_container_pub.modify_lpn_wrapper(
12271: p_api_version => 1.0
12272: , x_return_status => l_return_status
12273: , x_msg_count => l_msg_count
12274: , x_msg_data => l_msg_data

Line 13278: lpn_cont = wms_container_pub.lpn_context_wip

13274: IF (
13275: create_lpn = 'N'
13276: AND(
13277: (
13278: lpn_cont = wms_container_pub.lpn_context_wip
13279: OR lpn_cont = wms_container_pub.lpn_context_rcv
13280: OR lpn_cont = wms_container_pub.lpn_context_stores
13281: OR lpn_cont = wms_container_pub.lpn_context_intransit
13282: OR lpn_cont = wms_container_pub.lpn_context_vendor

Line 13279: OR lpn_cont = wms_container_pub.lpn_context_rcv

13275: create_lpn = 'N'
13276: AND(
13277: (
13278: lpn_cont = wms_container_pub.lpn_context_wip
13279: OR lpn_cont = wms_container_pub.lpn_context_rcv
13280: OR lpn_cont = wms_container_pub.lpn_context_stores
13281: OR lpn_cont = wms_container_pub.lpn_context_intransit
13282: OR lpn_cont = wms_container_pub.lpn_context_vendor
13283: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment

Line 13280: OR lpn_cont = wms_container_pub.lpn_context_stores

13276: AND(
13277: (
13278: lpn_cont = wms_container_pub.lpn_context_wip
13279: OR lpn_cont = wms_container_pub.lpn_context_rcv
13280: OR lpn_cont = wms_container_pub.lpn_context_stores
13281: OR lpn_cont = wms_container_pub.lpn_context_intransit
13282: OR lpn_cont = wms_container_pub.lpn_context_vendor
13283: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
13284: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip

Line 13281: OR lpn_cont = wms_container_pub.lpn_context_intransit

13277: (
13278: lpn_cont = wms_container_pub.lpn_context_wip
13279: OR lpn_cont = wms_container_pub.lpn_context_rcv
13280: OR lpn_cont = wms_container_pub.lpn_context_stores
13281: OR lpn_cont = wms_container_pub.lpn_context_intransit
13282: OR lpn_cont = wms_container_pub.lpn_context_vendor
13283: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
13284: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
13285: OR lpn_cont = wms_container_pub.lpn_context_picked

Line 13282: OR lpn_cont = wms_container_pub.lpn_context_vendor

13278: lpn_cont = wms_container_pub.lpn_context_wip
13279: OR lpn_cont = wms_container_pub.lpn_context_rcv
13280: OR lpn_cont = wms_container_pub.lpn_context_stores
13281: OR lpn_cont = wms_container_pub.lpn_context_intransit
13282: OR lpn_cont = wms_container_pub.lpn_context_vendor
13283: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
13284: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
13285: OR lpn_cont = wms_container_pub.lpn_context_picked
13286: OR lpn_cont = wms_container_pub.lpn_context_inv --Bug 5038228

Line 13283: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment

13279: OR lpn_cont = wms_container_pub.lpn_context_rcv
13280: OR lpn_cont = wms_container_pub.lpn_context_stores
13281: OR lpn_cont = wms_container_pub.lpn_context_intransit
13282: OR lpn_cont = wms_container_pub.lpn_context_vendor
13283: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
13284: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
13285: OR lpn_cont = wms_container_pub.lpn_context_picked
13286: OR lpn_cont = wms_container_pub.lpn_context_inv --Bug 5038228
13287: )

Line 13284: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip

13280: OR lpn_cont = wms_container_pub.lpn_context_stores
13281: OR lpn_cont = wms_container_pub.lpn_context_intransit
13282: OR lpn_cont = wms_container_pub.lpn_context_vendor
13283: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
13284: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
13285: OR lpn_cont = wms_container_pub.lpn_context_picked
13286: OR lpn_cont = wms_container_pub.lpn_context_inv --Bug 5038228
13287: )
13288: OR l_org_id <> p_org_id

Line 13285: OR lpn_cont = wms_container_pub.lpn_context_picked

13281: OR lpn_cont = wms_container_pub.lpn_context_intransit
13282: OR lpn_cont = wms_container_pub.lpn_context_vendor
13283: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
13284: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
13285: OR lpn_cont = wms_container_pub.lpn_context_picked
13286: OR lpn_cont = wms_container_pub.lpn_context_inv --Bug 5038228
13287: )
13288: OR l_org_id <> p_org_id
13289: )

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

13282: OR lpn_cont = wms_container_pub.lpn_context_vendor
13283: OR lpn_cont = wms_container_pub.lpn_loaded_for_shipment
13284: OR lpn_cont = wms_container_pub.lpn_prepack_for_wip
13285: OR lpn_cont = wms_container_pub.lpn_context_picked
13286: OR lpn_cont = wms_container_pub.lpn_context_inv --Bug 5038228
13287: )
13288: OR l_org_id <> p_org_id
13289: )
13290: ) THEN

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

13299: END IF;
13300:
13301: IF create_lpn = 'Y' THEN
13302: IF (l_debug = 1) THEN
13303: mydebug('check_pack_lpn: calling wms_container_pub.create_lpn');
13304: END IF;
13305:
13306: wms_container_pub.create_lpn
13307: ( p_api_version => 1.0

Line 13306: wms_container_pub.create_lpn

13302: IF (l_debug = 1) THEN
13303: mydebug('check_pack_lpn: calling wms_container_pub.create_lpn');
13304: END IF;
13305:
13306: wms_container_pub.create_lpn
13307: ( p_api_version => 1.0
13308: , x_return_status => l_return_status
13309: , x_msg_count => l_msg_count
13310: , x_msg_data => x_msg_data

Line 15344: WMS_Container_PUB.LPN_CONTEXT_PREGENERATED THEN

15340: -- If the drop lpn was pre-generated, no validations required
15341: --
15342:
15343: IF drop_lpn_rec.lpn_context =
15344: WMS_Container_PUB.LPN_CONTEXT_PREGENERATED THEN
15345: --
15346: -- Update the context to "Resides in Inventory" (1)
15347: --
15348: /* UPDATE wms_license_plate_numbers

Line 15349: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV

15345: --
15346: -- Update the context to "Resides in Inventory" (1)
15347: --
15348: /* UPDATE wms_license_plate_numbers
15349: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
15350: WHERE lpn_id = drop_lpn_rec.lpn_id;*/
15351:
15352: IF (l_debug = 1) THEN
15353: mydebug ('Drop LPN is pre-generated, no checking required.');

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

15353: mydebug ('Drop LPN is pre-generated, no checking required.');
15354: END IF;
15355: RETURN 1;
15356:
15357: ELSIF drop_lpn_rec.lpn_context = WMS_Container_PUB.lpn_context_picked THEN
15358: IF drop_lpn_rec.subinventory_code <> p_drop_sub or
15359: drop_lpn_rec.locator_id <> p_drop_loc THEN
15360: IF (l_debug = 1) THEN
15361: mydebug ('Drop LPN does not belong to the same sub and loc.');

Line 15368: WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT THEN

15364: END IF;
15365: END IF;
15366:
15367: IF drop_lpn_rec.lpn_context =
15368: WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT THEN
15369: IF (l_debug = 1) THEN
15370: mydebug ('Drop LPN is loaded to dock door already');
15371: END IF;
15372: RETURN 4; -- Drop LPN is loaded to dock door already