[Home] [Help]
5967: l_fulfillment_base VARCHAR2(1) := 'P';
5968:
5969: BEGIN
5970:
5971: l_fulfillment_base := wms_direct_ship_pvt.get_fulfillment_base;
5972:
5973: open x_order_lov FOR
5974: select distinct wdd.source_header_number
5975: , wdd.source_header_id
6028: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6029: END IF;
6030: l_debug := g_debug;
6031:
6032: l_fulfillment_base := wms_direct_ship_pvt.get_fulfillment_base;
6033:
6034: IF (l_debug = 1) THEN
6035: DEBUG('Get orderline lov 1','GET_ORDERLINE_LOV');
6036: DEBUG('p_org_id= '||p_org_id,'GET_ORDERLINE_LOV');
6742: )
6743: IS
6744:
6745: --for LPNs loaded through Normal method only
6746: --for LPNs loaded through direct method, it is handled inside wms_direct_ship_pvt.close_truck
6747: -- check for missing LPN is done for the delivery
6748:
6749: cursor normal_lpns_for_dock is
6750: select DISTINCT outermost_lpn_id,Nvl(trip_id,0)
6903: IF p_shipping_mode = 'DIRECT' OR p_shipping_mode IS NULL THEN
6904:
6905:
6906: IF (l_debug = 1) THEN
6907: debug(' Before calling wms_direct_ship_pvt.close_truck : DIRECT', 'CLOSE_TRUCK');
6908: END IF;
6909:
6910: --handles dircet ship with dock appointment and without dock
6911: --appointment, inside it does all required validations for LPNs
6910: --handles dircet ship with dock appointment and without dock
6911: --appointment, inside it does all required validations for LPNs
6912: --loaded TO the dock door via direct method
6913:
6914: wms_direct_ship_pvt.close_truck(
6915: x_return_status => l_return_status
6916: , x_msg_data => l_msg_data
6917: , x_msg_count => l_msg_count
6918: , x_error_code => l_error_code