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_DIRECT_SHIP_PVT dependencies on WMS_DIRECT_SHIP_PVT

Line 1: PACKAGE BODY WMS_DIRECT_SHIP_PVT AS

1: PACKAGE BODY WMS_DIRECT_SHIP_PVT AS
2: /* $Header: WMSDSPVB.pls 120.21.12010000.2 2008/08/25 06:50:16 anviswan ship $ */
3:
4: -- standard global constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_DIRECT_SHIP_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_DIRECT_SHIP_PVT';

1: PACKAGE BODY WMS_DIRECT_SHIP_PVT AS
2: /* $Header: WMSDSPVB.pls 120.21.12010000.2 2008/08/25 06:50:16 anviswan ship $ */
3:
4: -- standard global constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_DIRECT_SHIP_PVT';
6: p_message_type CONSTANT VARCHAR2(1) := 'E';
7:
8: --Inline branching
9: G_WMS_CURRENT_RELEASE_LEVEL NUMBER := wms_control.g_current_release_level;

Line 178: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP

174: ,msi.concatenated_segments
175: ,wt.vehicle_num_prefix
176: ,wt.vehicle_number
177: ,wts.departure_seal_code
178: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
179: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wt.ship_method_code)
180: ,wt.ship_method_code
181: FROM wsh_trips_ob_grp_v wt
182: ,wsh_trip_stops_ob_grp_v wts

Line 179: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wt.ship_method_code)

175: ,wt.vehicle_num_prefix
176: ,wt.vehicle_number
177: ,wts.departure_seal_code
178: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
179: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wt.ship_method_code)
180: ,wt.ship_method_code
181: FROM wsh_trips_ob_grp_v wt
182: ,wsh_trip_stops_ob_grp_v wts
183: ,mtl_system_items_kfv msi

Line 204: ,WMS_DIRECT_SHIP_PVT.GET_DELIVERY_LPN(wnd.delivery_id)

200: BEGIN
201: open x_delivery_info for
202: SELECT wnd.delivery_id
203: ,wnd.name
204: ,WMS_DIRECT_SHIP_PVT.GET_DELIVERY_LPN(wnd.delivery_id)
205: ,nvl(wnd.net_weight, 0)
206: ,nvl(wnd.gross_weight, 0)
207: ,wnd.weight_uom_code
208: ,wnd.waybill

Line 209: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)

205: ,nvl(wnd.net_weight, 0)
206: ,nvl(wnd.gross_weight, 0)
207: ,wnd.weight_uom_code
208: ,wnd.waybill
209: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
210: ,wnd.ship_method_code
211: ,WMS_DIRECT_SHIP_PVT.GET_FOBLOC_CODE_MEANING(wnd.fob_code)
212: ,wnd.fob_location_id
213: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.fob_location_id)

Line 211: ,WMS_DIRECT_SHIP_PVT.GET_FOBLOC_CODE_MEANING(wnd.fob_code)

207: ,wnd.weight_uom_code
208: ,wnd.waybill
209: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
210: ,wnd.ship_method_code
211: ,WMS_DIRECT_SHIP_PVT.GET_FOBLOC_CODE_MEANING(wnd.fob_code)
212: ,wnd.fob_location_id
213: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.fob_location_id)
214: ,wnd.freight_terms_code
215: ,WMS_DIRECT_SHIP_PVT.GET_FREIGHT_TERM(wnd.freight_terms_code)

Line 213: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.fob_location_id)

209: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
210: ,wnd.ship_method_code
211: ,WMS_DIRECT_SHIP_PVT.GET_FOBLOC_CODE_MEANING(wnd.fob_code)
212: ,wnd.fob_location_id
213: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.fob_location_id)
214: ,wnd.freight_terms_code
215: ,WMS_DIRECT_SHIP_PVT.GET_FREIGHT_TERM(wnd.freight_terms_code)
216: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.INTMED_SHIP_TO_LOCATION_ID)
217: ,WMS_DIRECT_SHIP_PVT.GET_BOL(wnd.delivery_id)

Line 215: ,WMS_DIRECT_SHIP_PVT.GET_FREIGHT_TERM(wnd.freight_terms_code)

211: ,WMS_DIRECT_SHIP_PVT.GET_FOBLOC_CODE_MEANING(wnd.fob_code)
212: ,wnd.fob_location_id
213: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.fob_location_id)
214: ,wnd.freight_terms_code
215: ,WMS_DIRECT_SHIP_PVT.GET_FREIGHT_TERM(wnd.freight_terms_code)
216: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.INTMED_SHIP_TO_LOCATION_ID)
217: ,WMS_DIRECT_SHIP_PVT.GET_BOL(wnd.delivery_id)
218: ,nvl(wnd.status_code,'OP')
219: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP

Line 216: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.INTMED_SHIP_TO_LOCATION_ID)

212: ,wnd.fob_location_id
213: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.fob_location_id)
214: ,wnd.freight_terms_code
215: ,WMS_DIRECT_SHIP_PVT.GET_FREIGHT_TERM(wnd.freight_terms_code)
216: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.INTMED_SHIP_TO_LOCATION_ID)
217: ,WMS_DIRECT_SHIP_PVT.GET_BOL(wnd.delivery_id)
218: ,nvl(wnd.status_code,'OP')
219: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
220: ,wts1.trip_id --2767767

Line 217: ,WMS_DIRECT_SHIP_PVT.GET_BOL(wnd.delivery_id)

213: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.fob_location_id)
214: ,wnd.freight_terms_code
215: ,WMS_DIRECT_SHIP_PVT.GET_FREIGHT_TERM(wnd.freight_terms_code)
216: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.INTMED_SHIP_TO_LOCATION_ID)
217: ,WMS_DIRECT_SHIP_PVT.GET_BOL(wnd.delivery_id)
218: ,nvl(wnd.status_code,'OP')
219: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
220: ,wts1.trip_id --2767767
221: FROM wsh_new_deliveries_ob_grp_v wnd,

Line 219: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP

215: ,WMS_DIRECT_SHIP_PVT.GET_FREIGHT_TERM(wnd.freight_terms_code)
216: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.INTMED_SHIP_TO_LOCATION_ID)
217: ,WMS_DIRECT_SHIP_PVT.GET_BOL(wnd.delivery_id)
218: ,nvl(wnd.status_code,'OP')
219: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
220: ,wts1.trip_id --2767767
221: FROM wsh_new_deliveries_ob_grp_v wnd,
222: -- 2767767
223: (SELECT wdl.delivery_id,wts.trip_id

Line 530: wms_direct_ship_pvt.CHECK_MISSING_ITEM_CUR(

526: /* INV_SHIPPING_TRANSACTION_PUB.CHECK_ENTIRE_EZ_DELIVERY(
527: p_delivery_id => p_delivery_id,
528: x_return_Status => l_return_status,
529: x_error_msg => l_error_msg);*/
530: wms_direct_ship_pvt.CHECK_MISSING_ITEM_CUR(
531: p_delivery_id => p_delivery_id
532: ,p_dock_door_id => p_dock_door_id
533: ,p_organization_id => p_org_id
534: ,x_return_Status => l_return_status

Line 556: debug('Call to Iwms_direct_ship_pvt.CHECK_MISSING_ITEM_CUR successful ','Check_Delivery');

552: return;
553: END IF;
554:
555: IF (l_debug = 1) THEN
556: debug('Call to Iwms_direct_ship_pvt.CHECK_MISSING_ITEM_CUR successful ','Check_Delivery');
557: END IF;
558: -- Check Delivery Status (Material Status
559: INV_SHIPPING_TRANSACTION_PUB.CHECK_DELIVERY_STATUS
560: (p_delivery_id => p_delivery_id

Line 656: wms_direct_ship_pvt.chk_del_for_direct_ship(x_return_status =>l_return_status

652: END;
653: END IF;
654: CLOSE lpn_in_other_dock;
655:
656: wms_direct_ship_pvt.chk_del_for_direct_ship(x_return_status =>l_return_status
657: ,x_msg_count => l_msg_count
658: ,x_msg_data => l_msg_data
659: ,p_delivery_id => p_delivery_id
660: );

Line 1210: WMS_DIRECT_SHIP_PVT.UPDATE_DELIVERY(

1206: p_freight_term_code IS NOT NULL OR
1207: p_freight_term_name IS NOT NULL OR
1208: p_intmed_shipto_loc_id IS NOT NULL
1209: ) THEN
1210: WMS_DIRECT_SHIP_PVT.UPDATE_DELIVERY(
1211: x_return_status => l_return_status
1212: ,x_msg_count => l_msg_count
1213: ,x_msg_data => l_msg_data
1214: ,p_delivery_id => p_delivery_id

Line 1241: debug('WMS_DIRECT_SHIP_PVT.SHIP_CONFIRM. Check the delivery for the correctness ' || ' before Confirming it','Ship_confirm');

1237: END IF;
1238:
1239: -- Check for material status, shipset and missing item
1240: IF (l_debug = 1) THEN
1241: debug('WMS_DIRECT_SHIP_PVT.SHIP_CONFIRM. Check the delivery for the correctness ' || ' before Confirming it','Ship_confirm');
1242: END IF;
1243: WMS_DIRECT_SHIP_PVT.CHECK_DELIVERY(
1244: x_return_status => l_return_status
1245: ,x_msg_count => l_msg_count

Line 1243: WMS_DIRECT_SHIP_PVT.CHECK_DELIVERY(

1239: -- Check for material status, shipset and missing item
1240: IF (l_debug = 1) THEN
1241: debug('WMS_DIRECT_SHIP_PVT.SHIP_CONFIRM. Check the delivery for the correctness ' || ' before Confirming it','Ship_confirm');
1242: END IF;
1243: WMS_DIRECT_SHIP_PVT.CHECK_DELIVERY(
1244: x_return_status => l_return_status
1245: ,x_msg_count => l_msg_count
1246: ,x_msg_data => l_msg_data
1247: ,x_error_code => l_error_code

Line 1257: WMS_DIRECT_SHIP_PVT.MISSING_ITEM_CUR(

1253: IF l_error_code = 1 THEN -- Case of Missing Item, Call Missing Item Cursor
1254: IF (l_debug = 1) THEN
1255: debug(' Ship_Confirm. Missing Item Error','Ship_Confirm');
1256: END IF;
1257: WMS_DIRECT_SHIP_PVT.MISSING_ITEM_CUR(
1258: x_missing_item_cur => x_missing_item_cur
1259: ,p_delivery_id => p_delivery_id
1260: ,p_organization_id => p_org_id
1261: ,p_dock_door_id => p_dock_door_id);

Line 1333: WMS_DIRECT_SHIP_PVT.CREATE_TRIP(

1329: debug(' Ship_Confirm. Calling CREATE_TRIP','Ship_Confirm');
1330: debug('p_org_id '||p_org_id);
1331: debug('p_dock_door_id '||p_dock_door_id);
1332: END IF;
1333: WMS_DIRECT_SHIP_PVT.CREATE_TRIP(
1334: x_return_status => l_return_status
1335: ,p_organization_id => p_org_id
1336: ,p_dock_door_id => p_dock_door_id
1337: ,p_delivery_id =>p_delivery_id /* bug 2741857 */

Line 1593: WMS_DIRECT_SHIP_PVT.UPDATE_DELIVERY(

1589: p_freight_term_code IS NOT NULL OR
1590: p_freight_term_name IS NOT NULL OR
1591: p_intmed_shipto_loc_id IS NOT NULL
1592: ) THEN
1593: WMS_DIRECT_SHIP_PVT.UPDATE_DELIVERY(
1594: x_return_status => l_return_status
1595: ,x_msg_count => l_msg_count
1596: ,x_msg_data => l_msg_data
1597: ,p_delivery_id => p_delivery_id

Line 1660: WMS_DIRECT_SHIP_PVT.SHIP_CONFIRM(

1656: IF (p_delivery_id IS NOT NULL) THEN
1657: IF (l_debug = 1) THEN
1658: debug('P_Delivery_Id is not null ','Confirm_All_Deliveries');
1659: END IF;
1660: WMS_DIRECT_SHIP_PVT.SHIP_CONFIRM(
1661: x_return_status =>l_return_status
1662: ,x_msg_count =>l_msg_count
1663: ,x_msg_data =>l_msg_data
1664: ,x_missing_item_cur=>l_t_genref

Line 1701: WMS_DIRECT_SHIP_PVT.SHIP_CONFIRM(

1697: EXIT WHEN loaded_deliveries%NOTFOUND;
1698: IF (l_debug = 1) THEN
1699: debug('Confirm All Deliveries: Delivery Id '||to_char(l_delivery_id),'Confirm_All_Deliveries');
1700: END IF;
1701: WMS_DIRECT_SHIP_PVT.SHIP_CONFIRM(
1702: x_return_status =>l_return_status
1703: ,x_msg_count =>l_msg_count
1704: ,x_msg_data =>l_msg_data
1705: ,x_missing_item_cur=>l_t_genref

Line 1880: 'WMS_DIRECT_SHIP_PVT.Create_Trip');

1876: l_auto_trip_index := l_auto_trip_index +1;
1877: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1878: IF (l_debug = 1) THEN
1879: debug('Return unexpected error from WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP',
1880: 'WMS_DIRECT_SHIP_PVT.Create_Trip');
1881: END IF;
1882: RAISE fnd_api.g_exc_unexpected_error;
1883: END IF;
1884: END LOOP;

Line 1904: debug('Return error from WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP','WMS_DIRECT_SHIP_PVT.Create_Trip');

1900: WHERE delivery_id = l_del_tab(k);
1901: END LOOP;
1902: ELSIF l_return_status IN (fnd_api.g_ret_sts_error) THEN
1903: IF (l_debug = 1) THEN
1904: debug('Return error from WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP','WMS_DIRECT_SHIP_PVT.Create_Trip');
1905: END IF;
1906: RAISE fnd_api.g_exc_error;
1907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1908: IF (l_debug = 1) THEN

Line 1910: 'WMS_DIRECT_SHIP_PVT.Create_Trip');

1906: RAISE fnd_api.g_exc_error;
1907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1908: IF (l_debug = 1) THEN
1909: debug('Return unexpected error from WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP',
1910: 'WMS_DIRECT_SHIP_PVT.Create_Trip');
1911: END IF;
1912: RAISE fnd_api.g_exc_unexpected_error;
1913: END IF;
1914: END IF;

Line 1938: debug('The API WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP returned status E ','WMS_DIRECT_SHIP_PVT.Create_Trip');

1934: END LOOP;
1935:
1936: ELSIF l_return_status IN (fnd_api.g_ret_sts_error) THEN
1937: IF (l_debug = 1) THEN
1938: debug('The API WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP returned status E ','WMS_DIRECT_SHIP_PVT.Create_Trip');
1939: END IF;
1940: RAISE fnd_api.g_exc_error;
1941: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1942: IF (l_debug = 1) THEN

Line 1943: debug('The API WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP returned status U ','WMS_DIRECT_SHIP_PVT.Create_Trip');

1939: END IF;
1940: RAISE fnd_api.g_exc_error;
1941: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1942: IF (l_debug = 1) THEN
1943: debug('The API WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP returned status U ','WMS_DIRECT_SHIP_PVT.Create_Trip');
1944: END IF;
1945: RAISE fnd_api.g_exc_unexpected_error;
1946: END IF;
1947: END IF;

Line 2355: wms_direct_ship_pvt.update_tripstop(

2351: debug('p_dock_door_id : ' || p_dock_door_id , 'print_shipping_document');
2352: debug('p_ship_method_code : ' || p_ship_method_code , 'print_shipping_document');
2353: END IF;
2354:
2355: wms_direct_ship_pvt.update_tripstop(
2356: x_return_status => l_return_status
2357: , x_msg_count => l_msg_count
2358: , x_msg_data => l_msg_data
2359: , p_trip_id => p_trip_id

Line 2644: wms_direct_ship_pvt.print_shipping_document(

2640: AND p_ship_method_code IS NULL THEN
2641: RAISE no_ship_method_code;
2642: END IF;
2643:
2644: wms_direct_ship_pvt.print_shipping_document(
2645: x_return_status => l_return_status
2646: , x_msg_count => l_msg_count
2647: , x_msg_data => l_msg_data
2648: , p_trip_id => p_trip_id

Line 2794: wms_direct_ship_pvt.cleanup_temp_recs(

2790:
2791: LOOP
2792: FETCH closed_trips INTO l_trip_id;
2793: EXIT WHEN closed_trips%NOTFOUND;
2794: wms_direct_ship_pvt.cleanup_temp_recs(
2795: x_msg_data => x_msg_data
2796: , x_msg_count => x_msg_count
2797: , x_return_status => x_return_status
2798: , p_org_id => p_org_id

Line 3289: wms_direct_ship_pvt.cleanup_temp_recs(

3285: END IF;
3286: -- End of Release 12 change
3287:
3288: --Now, clean up the direct ship records from WSTT, WFCT, MSNT and WDST
3289: wms_direct_ship_pvt.cleanup_temp_recs(
3290: x_msg_data => x_msg_data
3291: , x_msg_count => x_msg_count
3292: , x_return_status => l_return_status
3293: , p_org_id => p_org_id

Line 3349: fnd_msg_pub.add_exc_msg('WMS_DIRECT_SHIP_PVT', 'UNLOAD_TRUCK');

3345: x_return_status := fnd_api.g_ret_sts_unexp_error;
3346: ROLLBACK;
3347:
3348: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3349: fnd_msg_pub.add_exc_msg('WMS_DIRECT_SHIP_PVT', 'UNLOAD_TRUCK');
3350: END IF;
3351:
3352: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3353:

Line 3465: fnd_msg_pub.add_exc_msg('WMS_DIRECT_SHIP_PVT', 'CLEANUP_TEMP');

3461: x_return_status := fnd_api.g_ret_sts_unexp_error;
3462: ROLLBACK;
3463:
3464: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3465: fnd_msg_pub.add_exc_msg('WMS_DIRECT_SHIP_PVT', 'CLEANUP_TEMP');
3466: END IF;
3467:
3468: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3469:

Line 3495: DEBUG('Error in WMS_DIRECT_SHIP_PVT.get_global_values: ' || x_progress);

3491: x_current_date := SYSDATE;
3492: EXCEPTION
3493: WHEN OTHERS THEN
3494: IF (l_debug = 1) THEN
3495: DEBUG('Error in WMS_DIRECT_SHIP_PVT.get_global_values: ' || x_progress);
3496: END IF;
3497: END get_global_values;
3498:
3499: PROCEDURE create_resv(

Line 3588: fnd_msg_pub.add_exc_msg('WMS_DIRECT_SHIP_PVT', 'validate_status_lpn_contents');

3584: WHEN OTHERS THEN
3585: x_return_status := fnd_api.g_ret_sts_unexp_error;
3586:
3587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3588: fnd_msg_pub.add_exc_msg('WMS_DIRECT_SHIP_PVT', 'validate_status_lpn_contents');
3589: END IF;
3590:
3591: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3592: END validate_status_lpn_contents;

Line 3738: fnd_msg_pub.add_exc_msg('WMS_DIRECT_SHIP_PVT', 'update_freight_cost');

3734:
3735: ROLLBACK TO freight_cost;
3736:
3737: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3738: fnd_msg_pub.add_exc_msg('WMS_DIRECT_SHIP_PVT', 'update_freight_cost');
3739: END IF;
3740:
3741: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3742: END update_freight_cost;

Line 5119: wms_direct_ship_pvt.create_update_containers(

5115:
5116: LOOP
5117: FETCH outer_lpn INTO l_outer_lpn;
5118: EXIT WHEN outer_lpn%NOTFOUND;
5119: wms_direct_ship_pvt.create_update_containers(
5120: x_return_status => l_return_status
5121: , x_msg_count => l_msg_count
5122: , x_msg_data => l_msg_data
5123: , p_org_id => p_organization_id

Line 5162: wms_direct_ship_pvt.container_nesting(

5158: DEBUG('The delivery_detail_id for the lpn_Id is ' || l_cont_instance_id, 'STAGE_LPN');
5159: DEBUG('The delivery_detail_id for the first line is ' || l_delivery_detail_id, 'STAGE_LPN');
5160: END IF;
5161:
5162: wms_direct_ship_pvt.container_nesting(
5163: x_return_status => l_return_status
5164: , x_msg_count => l_msg_count
5165: , x_msg_data => l_msg_data
5166: , p_organization_id => p_organization_id

Line 6530: wms_direct_ship_pvt.confirm_all_deliveries(

6526: IF (l_debug = 1) THEN
6527: DEBUG('Before call to Confirm All deliveries API close_truck');
6528: END IF;
6529:
6530: wms_direct_ship_pvt.confirm_all_deliveries(
6531: x_return_status => l_return_status
6532: , x_msg_count => l_msg_count
6533: , x_msg_data => l_msg_data
6534: , x_missing_item_cur => x_missing_item_cur

Line 6633: wms_direct_ship_pvt.close_trip(

6629: WHEN NO_DATA_FOUND THEN
6630: l_vehicle_item_id := NULL;
6631: END;
6632:
6633: wms_direct_ship_pvt.close_trip(
6634: x_return_status => l_return_status
6635: , x_msg_count => l_msg_count
6636: , x_msg_data => l_msg_data
6637: , p_trip_id => l_trip_cursor.trip_id

Line 7134: fnd_msg_pub.add_exc_msg('WMS_DIRECT_SHIP_PVT', 'create_update_containers');

7130: x_return_status := fnd_api.g_ret_sts_unexp_error;
7131: ROLLBACK;
7132:
7133: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
7134: fnd_msg_pub.add_exc_msg('WMS_DIRECT_SHIP_PVT', 'create_update_containers');
7135: END IF;
7136:
7137: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
7138: END create_update_containers;

Line 8321: wms_direct_ship_pvt.cleanup_orphan_rec(p_org_id);

8317: g_last_updated_by := g_created_by;
8318: g_last_update_login := fnd_global.login_id;
8319: g_last_update_date := g_creation_date;
8320: -- cleaning temp data if the delivery was backordered for this lpn somethimes in past
8321: wms_direct_ship_pvt.cleanup_orphan_rec(p_org_id);
8322:
8323: IF (l_debug = 1) THEN
8324: DEBUG('Corrupted temp data cleaned ', 'Process_LPN');
8325: END IF;

Line 8534: wms_direct_ship_pvt.validate_status_lpn_contents(x_return_status => l_return_status, x_msg_count => l_msg_count

8530: IF (l_debug = 1) THEN
8531: DEBUG('Before call to material status check', 'Process_LPN');
8532: END IF;
8533:
8534: wms_direct_ship_pvt.validate_status_lpn_contents(x_return_status => l_return_status, x_msg_count => l_msg_count
8535: , x_msg_data => l_msg_data, p_lpn_id => p_lpn_id, p_org_id => p_org_id);
8536:
8537: IF l_return_status = fnd_api.g_ret_sts_error THEN
8538: IF (l_debug = 1) THEN

Line 8842: IF NOT wms_direct_ship_pvt.validate_end_unit_num_at(c_index, l_order_line_rec.end_item_unit_number) THEN

8838: IF (l_debug = 1) THEN
8839: DEBUG('validate_end_unit_num_at ' ,'Process_LPN');
8840: END IF;
8841: -- check end_item_unit_num
8842: IF NOT wms_direct_ship_pvt.validate_end_unit_num_at(c_index, l_order_line_rec.end_item_unit_number) THEN
8843: l_skipped_line_tab(l_order_line_rec.line_id) := 1;
8844:
8845: IF (l_debug = 1) THEN
8846: DEBUG('line ' || l_order_line_rec.line_id || ' put into skipped line', 'Process_LPN');

Line 8873: IF NOT wms_direct_ship_pvt.validate_del_grp_rules(l_num_line_processed, l_order_line_rec.header_id, l_order_line_rec.line_id) THEN

8869: END IF;
8870: END IF;
8871:
8872: -- validate delivery grouping rules
8873: IF NOT wms_direct_ship_pvt.validate_del_grp_rules(l_num_line_processed, l_order_line_rec.header_id, l_order_line_rec.line_id) THEN
8874: IF (l_debug = 1) THEN
8875: DEBUG('Delivery grouping failed', 'Process_LPN');
8876: END IF;
8877:

Line 8885: IF NOT wms_direct_ship_pvt.validate_del_for_ds(p_lpn_id, p_org_id, p_dock_door_id, l_order_line_rec.header_id

8881: RETURN;
8882: END IF;
8883:
8884: -- check delivery for direct ship
8885: IF NOT wms_direct_ship_pvt.validate_del_for_ds(p_lpn_id, p_org_id, p_dock_door_id, l_order_line_rec.header_id
8886: , l_order_line_rec.line_id) THEN
8887: IF (l_debug = 1) THEN
8888: DEBUG('Checl del for direct ship failed', 'Process_LPN');
8889: END IF;

Line 8958: l_qty_to_pick := WMS_DIRECT_SHIP_PVT.Get_qty_to_pick(

8954: DEBUG('l_oe_order_line_id = ' || l_mtl_reservation_tab(resv_index).demand_source_line_id, 'Process_LPN');
8955: END IF;
8956:
8957: --Bug5262108. Begin. Check qty to pick considering overship tolerance.
8958: l_qty_to_pick := WMS_DIRECT_SHIP_PVT.Get_qty_to_pick(
8959: l_oe_order_header_id,
8960: l_mtl_reservation_tab(resv_index).demand_source_line_id ,
8961: p_org_id);
8962: IF (l_debug = 1) THEN

Line 9337: IF NOT wms_direct_ship_pvt.validate_end_unit_num(p_inventory_item_id, p_end_item_unit_number) THEN

9333: END IF;
9334:
9335: --ACTION
9336: -- validate end unit
9337: IF NOT wms_direct_ship_pvt.validate_end_unit_num(p_inventory_item_id, p_end_item_unit_number) THEN
9338: IF (l_debug = 1) THEN
9339: DEBUG('End item unit validation failed', 'Process_Line');
9340: END IF;
9341:

Line 9349: IF NOT wms_direct_ship_pvt.validate_del_for_ds(p_lpn_id, p_org_id, p_dock_door_id, p_order_line_id, p_order_header_id) THEN

9345: RETURN;
9346: END IF;
9347:
9348: -- checkk delivery for irect ship
9349: IF NOT wms_direct_ship_pvt.validate_del_for_ds(p_lpn_id, p_org_id, p_dock_door_id, p_order_line_id, p_order_header_id) THEN
9350: IF (l_debug = 1) THEN
9351: DEBUG('Checl del for direct ship failed', 'Process_Line');
9352: END IF;
9353:

Line 9563: AND wms_direct_ship_pvt.validate_end_unit_num_at(lpnc_rec, p_end_item_unit_number)

9559: AND(l_resv_rec.revision = l_lpn_cont_rec.revision
9560: OR l_resv_rec.revision IS NULL)
9561: AND(l_resv_rec.lot_number = l_lpn_cont_rec.lot_number
9562: OR l_resv_rec.lot_number IS NULL)
9563: AND wms_direct_ship_pvt.validate_end_unit_num_at(lpnc_rec, p_end_item_unit_number)
9564: ) THEN
9565: -- clear quantity tree cache
9566: inv_quantity_tree_pub.clear_quantity_cache;
9567:

Line 9763: l_qty_to_pick := WMS_DIRECT_SHIP_PVT.Get_qty_to_pick( p_order_header_id,p_order_line_id,p_org_id);

9759: --Bug#5262108.Begin.
9760: --This is to handle overship case. Once the requested qty for the line is satisfied,
9761: --we will try to overship against the line.
9762: IF l_overship_case = 'Y' THEN
9763: l_qty_to_pick := WMS_DIRECT_SHIP_PVT.Get_qty_to_pick( p_order_header_id,p_order_line_id,p_org_id);
9764:
9765: IF (l_debug = 1) THEN
9766: DEBUG('l_qty_to_pick '||l_qty_to_pick ,'Process_Line');
9767: END IF;

Line 9793: AND wms_direct_ship_pvt.validate_end_unit_num_at(lpnc_rec, p_end_item_unit_number)

9789: IF (
9790: (l_lpn_cont_rec.quantity > 0)
9791: AND(p_revision = l_lpn_cont_rec.revision
9792: OR p_revision IS NULL)
9793: AND wms_direct_ship_pvt.validate_end_unit_num_at(lpnc_rec, p_end_item_unit_number)
9794: ) THEN
9795: -- clear quantity tree cache
9796: inv_quantity_tree_pub.clear_quantity_cache;
9797:

Line 10403: wms_direct_ship_pvt.chk_del_for_direct_ship(

10399: -- first checjk cache table
10400: IF g_checked_deliveries.EXISTS(l_del_cur_rec.delivery_id) THEN
10401: l_result := TRUE;
10402: ELSE -- not already validated go throug normal procedure
10403: wms_direct_ship_pvt.chk_del_for_direct_ship(
10404: x_return_status => l_return_status
10405: , x_msg_count => l_msg_count
10406: , x_msg_data => l_msg_data
10407: , p_delivery_id => l_del_cur_rec.delivery_id

Line 10612: wms_direct_ship_pvt.stage_lpns(

10608: IF (l_debug = 1) THEN
10609: DEBUG('Staging LPNs ', 'Load_LPN');
10610: END IF;
10611:
10612: wms_direct_ship_pvt.stage_lpns(
10613: x_return_status => l_return_status
10614: , x_msg_count => l_msg_count
10615: , x_msg_data => l_msg_data
10616: , p_group_id => g_group_id

Line 10646: wms_direct_ship_pvt.update_freight_cost(x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_msg_data

10642: IF (l_debug = 1) THEN
10643: DEBUG('Updating freight cost', 'Load_LPN');
10644: END IF;
10645:
10646: wms_direct_ship_pvt.update_freight_cost(x_return_status => l_return_status, x_msg_count => l_msg_count, x_msg_data => l_msg_data
10647: , p_lpn_id => p_lpn_id);
10648:
10649: IF l_return_status = fnd_api.g_ret_sts_error THEN
10650: IF (l_debug = 1) THEN

Line 10867: IF NOT wms_direct_ship_pvt.validate_end_unit_num_at(l_index, l_end_item_unit_number) THEN

10863: IF (l_debug = 1) THEN
10864: DEBUG('l_end_item_unit_number=' || l_end_item_unit_number, 'Perform_Overship_Distribution');
10865: END IF;
10866:
10867: IF NOT wms_direct_ship_pvt.validate_end_unit_num_at(l_index, l_end_item_unit_number) THEN
10868: IF (l_debug = 1) THEN
10869: DEBUG('End unit not matching, skipping line', 'Perform_Overship_Distribution');
10870: END IF;
10871:

Line 11184: IF NOT wms_direct_ship_pvt.validate_end_unit_num_at(l_index, l_loaded_lines_rec.end_item_unit_number) THEN

11180: DEBUG('Inside create reservation part', 'Perform_Overship_Distribution');
11181: END IF;
11182:
11183: --validate end unit
11184: IF NOT wms_direct_ship_pvt.validate_end_unit_num_at(l_index, l_loaded_lines_rec.end_item_unit_number) THEN
11185: IF (l_debug = 1) THEN
11186: DEBUG('End unit not matching, skipping line', 'Perform_Overship_Distribution');
11187: END IF;
11188:

Line 11889: END WMS_DIRECT_SHIP_PVT;

11885: END IF;
11886: RETURN RET_VAL;
11887: END GET_CATCH_WEIGHT;
11888:
11889: END WMS_DIRECT_SHIP_PVT;