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.31.12020000.28 2013/05/17 22:51:04 sahmahes 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.31.12020000.28 2013/05/17 22:51:04 sahmahes 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 219: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP

215: ,msi.concatenated_segments
216: ,wt.vehicle_num_prefix
217: ,wt.vehicle_number
218: ,wts.departure_seal_code
219: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
220: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wt.ship_method_code)
221: ,wt.ship_method_code
222: FROM wsh_trips_ob_grp_v wt
223: ,wsh_trip_stops_ob_grp_v wts

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

216: ,wt.vehicle_num_prefix
217: ,wt.vehicle_number
218: ,wts.departure_seal_code
219: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
220: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wt.ship_method_code)
221: ,wt.ship_method_code
222: FROM wsh_trips_ob_grp_v wt
223: ,wsh_trip_stops_ob_grp_v wts
224: ,mtl_system_items_kfv msi

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

241: BEGIN
242: open x_delivery_info for
243: SELECT wnd.delivery_id
244: ,wnd.name
245: ,WMS_DIRECT_SHIP_PVT.GET_DELIVERY_LPN(wnd.delivery_id)
246: ,nvl(wnd.net_weight, 0)
247: ,nvl(wnd.gross_weight, 0)
248: ,wnd.weight_uom_code
249: ,wnd.waybill

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

246: ,nvl(wnd.net_weight, 0)
247: ,nvl(wnd.gross_weight, 0)
248: ,wnd.weight_uom_code
249: ,wnd.waybill
250: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
251: ,wnd.ship_method_code
252: ,WMS_DIRECT_SHIP_PVT.GET_FOBLOC_CODE_MEANING(wnd.fob_code)
253: ,wnd.fob_location_id
254: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.fob_location_id)

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

248: ,wnd.weight_uom_code
249: ,wnd.waybill
250: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
251: ,wnd.ship_method_code
252: ,WMS_DIRECT_SHIP_PVT.GET_FOBLOC_CODE_MEANING(wnd.fob_code)
253: ,wnd.fob_location_id
254: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.fob_location_id)
255: ,wnd.freight_terms_code
256: ,WMS_DIRECT_SHIP_PVT.GET_FREIGHT_TERM(wnd.freight_terms_code)

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

250: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
251: ,wnd.ship_method_code
252: ,WMS_DIRECT_SHIP_PVT.GET_FOBLOC_CODE_MEANING(wnd.fob_code)
253: ,wnd.fob_location_id
254: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.fob_location_id)
255: ,wnd.freight_terms_code
256: ,WMS_DIRECT_SHIP_PVT.GET_FREIGHT_TERM(wnd.freight_terms_code)
257: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.INTMED_SHIP_TO_LOCATION_ID)
258: ,WMS_DIRECT_SHIP_PVT.GET_BOL(wnd.delivery_id)

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

252: ,WMS_DIRECT_SHIP_PVT.GET_FOBLOC_CODE_MEANING(wnd.fob_code)
253: ,wnd.fob_location_id
254: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.fob_location_id)
255: ,wnd.freight_terms_code
256: ,WMS_DIRECT_SHIP_PVT.GET_FREIGHT_TERM(wnd.freight_terms_code)
257: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.INTMED_SHIP_TO_LOCATION_ID)
258: ,WMS_DIRECT_SHIP_PVT.GET_BOL(wnd.delivery_id)
259: ,nvl(wnd.status_code,'OP')
260: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP

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

253: ,wnd.fob_location_id
254: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.fob_location_id)
255: ,wnd.freight_terms_code
256: ,WMS_DIRECT_SHIP_PVT.GET_FREIGHT_TERM(wnd.freight_terms_code)
257: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.INTMED_SHIP_TO_LOCATION_ID)
258: ,WMS_DIRECT_SHIP_PVT.GET_BOL(wnd.delivery_id)
259: ,nvl(wnd.status_code,'OP')
260: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
261: ,wts1.trip_id --2767767

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

254: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.fob_location_id)
255: ,wnd.freight_terms_code
256: ,WMS_DIRECT_SHIP_PVT.GET_FREIGHT_TERM(wnd.freight_terms_code)
257: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.INTMED_SHIP_TO_LOCATION_ID)
258: ,WMS_DIRECT_SHIP_PVT.GET_BOL(wnd.delivery_id)
259: ,nvl(wnd.status_code,'OP')
260: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
261: ,wts1.trip_id --2767767
262: ,wnd.fob_code --Bug#9668537,9668537 and 9399092

Line 260: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP

256: ,WMS_DIRECT_SHIP_PVT.GET_FREIGHT_TERM(wnd.freight_terms_code)
257: ,WMS_DIRECT_SHIP_PVT.GET_FOB_LOCATION(wnd.INTMED_SHIP_TO_LOCATION_ID)
258: ,WMS_DIRECT_SHIP_PVT.GET_BOL(wnd.delivery_id)
259: ,nvl(wnd.status_code,'OP')
260: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
261: ,wts1.trip_id --2767767
262: ,wnd.fob_code --Bug#9668537,9668537 and 9399092
263: FROM wsh_new_deliveries_ob_grp_v wnd,
264: -- 2767767

Line 613: wms_direct_ship_pvt.CHECK_MISSING_ITEM_CUR(

609: /* INV_SHIPPING_TRANSACTION_PUB.CHECK_ENTIRE_EZ_DELIVERY(
610: p_delivery_id => p_delivery_id,
611: x_return_Status => l_return_status,
612: x_error_msg => l_error_msg);*/
613: wms_direct_ship_pvt.CHECK_MISSING_ITEM_CUR(
614: p_delivery_id => p_delivery_id
615: ,p_dock_door_id => p_dock_door_id
616: ,p_organization_id => p_org_id
617: ,x_return_Status => l_return_status

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

635: return;
636: END IF;
637:
638: IF (l_debug = 1) THEN
639: debug('Call to Iwms_direct_ship_pvt.CHECK_MISSING_ITEM_CUR successful ','Check_Delivery');
640: END IF;
641: -- Check Delivery Status (Material Status
642: INV_SHIPPING_TRANSACTION_PUB.CHECK_DELIVERY_STATUS
643: (p_delivery_id => p_delivery_id

Line 739: wms_direct_ship_pvt.chk_del_for_direct_ship(x_return_status =>l_return_status

735: END;
736: END IF;
737: CLOSE lpn_in_other_dock;
738:
739: wms_direct_ship_pvt.chk_del_for_direct_ship(x_return_status =>l_return_status
740: ,x_msg_count => l_msg_count
741: ,x_msg_data => l_msg_data
742: ,p_delivery_id => p_delivery_id
743: );

Line 1294: WMS_DIRECT_SHIP_PVT.UPDATE_DELIVERY(

1290: p_freight_term_code IS NOT NULL OR
1291: p_freight_term_name IS NOT NULL OR
1292: p_intmed_shipto_loc_id IS NOT NULL
1293: ) THEN
1294: WMS_DIRECT_SHIP_PVT.UPDATE_DELIVERY(
1295: x_return_status => l_return_status
1296: ,x_msg_count => l_msg_count
1297: ,x_msg_data => l_msg_data
1298: ,p_delivery_id => p_delivery_id

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

1321: END IF;
1322:
1323: -- Check for material status, shipset and missing item
1324: IF (l_debug = 1) THEN
1325: debug('WMS_DIRECT_SHIP_PVT.SHIP_CONFIRM. Check the delivery for the correctness ' || ' before Confirming it','Ship_confirm');
1326: END IF;
1327: WMS_DIRECT_SHIP_PVT.CHECK_DELIVERY(
1328: x_return_status => l_return_status
1329: ,x_msg_count => l_msg_count

Line 1327: WMS_DIRECT_SHIP_PVT.CHECK_DELIVERY(

1323: -- Check for material status, shipset and missing item
1324: IF (l_debug = 1) THEN
1325: debug('WMS_DIRECT_SHIP_PVT.SHIP_CONFIRM. Check the delivery for the correctness ' || ' before Confirming it','Ship_confirm');
1326: END IF;
1327: WMS_DIRECT_SHIP_PVT.CHECK_DELIVERY(
1328: x_return_status => l_return_status
1329: ,x_msg_count => l_msg_count
1330: ,x_msg_data => l_msg_data
1331: ,x_error_code => l_error_code

Line 1341: WMS_DIRECT_SHIP_PVT.MISSING_ITEM_CUR(

1337: IF l_error_code = 1 THEN -- Case of Missing Item, Call Missing Item Cursor
1338: IF (l_debug = 1) THEN
1339: debug(' Ship_Confirm. Missing Item Error','Ship_Confirm');
1340: END IF;
1341: WMS_DIRECT_SHIP_PVT.MISSING_ITEM_CUR(
1342: x_missing_item_cur => x_missing_item_cur
1343: ,p_delivery_id => p_delivery_id
1344: ,p_organization_id => p_org_id
1345: ,p_dock_door_id => p_dock_door_id);

Line 1417: WMS_DIRECT_SHIP_PVT.CREATE_TRIP(

1413: debug(' Ship_Confirm. Calling CREATE_TRIP','Ship_Confirm');
1414: debug('p_org_id '||p_org_id);
1415: debug('p_dock_door_id '||p_dock_door_id);
1416: END IF;
1417: WMS_DIRECT_SHIP_PVT.CREATE_TRIP(
1418: x_return_status => l_return_status
1419: ,p_organization_id => p_org_id
1420: ,p_dock_door_id => p_dock_door_id
1421: ,p_delivery_id =>p_delivery_id /* bug 2741857 */

Line 1688: WMS_DIRECT_SHIP_PVT.UPDATE_DELIVERY(

1684: p_freight_term_code IS NOT NULL OR
1685: p_freight_term_name IS NOT NULL OR
1686: p_intmed_shipto_loc_id IS NOT NULL
1687: ) THEN
1688: WMS_DIRECT_SHIP_PVT.UPDATE_DELIVERY(
1689: x_return_status => l_return_status
1690: ,x_msg_count => l_msg_count
1691: ,x_msg_data => l_msg_data
1692: ,p_delivery_id => p_delivery_id

Line 1755: WMS_DIRECT_SHIP_PVT.SHIP_CONFIRM(

1751: IF (p_delivery_id IS NOT NULL) THEN
1752: IF (l_debug = 1) THEN
1753: debug('P_Delivery_Id is not null ','Confirm_All_Deliveries');
1754: END IF;
1755: WMS_DIRECT_SHIP_PVT.SHIP_CONFIRM(
1756: x_return_status =>l_return_status
1757: ,x_msg_count =>l_msg_count
1758: ,x_msg_data =>l_msg_data
1759: ,x_missing_item_cur=>l_t_genref

Line 1796: WMS_DIRECT_SHIP_PVT.SHIP_CONFIRM(

1792: EXIT WHEN loaded_deliveries%NOTFOUND;
1793: IF (l_debug = 1) THEN
1794: debug('Confirm All Deliveries: Delivery Id '||to_char(l_delivery_id),'Confirm_All_Deliveries');
1795: END IF;
1796: WMS_DIRECT_SHIP_PVT.SHIP_CONFIRM(
1797: x_return_status =>l_return_status
1798: ,x_msg_count =>l_msg_count
1799: ,x_msg_data =>l_msg_data
1800: ,x_missing_item_cur=>l_t_genref

Line 1976: 'WMS_DIRECT_SHIP_PVT.Create_Trip');

1972: l_auto_trip_index := l_auto_trip_index +1;
1973: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1974: IF (l_debug = 1) THEN
1975: debug('Return unexpected error from WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP',
1976: 'WMS_DIRECT_SHIP_PVT.Create_Trip');
1977: END IF;
1978: RAISE fnd_api.g_exc_unexpected_error;
1979: END IF;
1980: END LOOP;

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

1996: WHERE delivery_id = l_del_tab(k);
1997: END LOOP;
1998: ELSIF l_return_status IN (fnd_api.g_ret_sts_error) THEN
1999: IF (l_debug = 1) THEN
2000: debug('Return error from WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP','WMS_DIRECT_SHIP_PVT.Create_Trip');
2001: END IF;
2002: RAISE fnd_api.g_exc_error;
2003: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2004: IF (l_debug = 1) THEN

Line 2006: 'WMS_DIRECT_SHIP_PVT.Create_Trip');

2002: RAISE fnd_api.g_exc_error;
2003: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2004: IF (l_debug = 1) THEN
2005: debug('Return unexpected error from WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP',
2006: 'WMS_DIRECT_SHIP_PVT.Create_Trip');
2007: END IF;
2008: RAISE fnd_api.g_exc_unexpected_error;
2009: END IF;
2010: END IF;

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

2030: END LOOP;
2031:
2032: ELSIF l_return_status IN (fnd_api.g_ret_sts_error) THEN
2033: IF (l_debug = 1) THEN
2034: debug('The API WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP returned status E ','WMS_DIRECT_SHIP_PVT.Create_Trip');
2035: END IF;
2036: RAISE fnd_api.g_exc_error;
2037: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2038: IF (l_debug = 1) THEN

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

2035: END IF;
2036: RAISE fnd_api.g_exc_error;
2037: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2038: IF (l_debug = 1) THEN
2039: debug('The API WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP returned status U ','WMS_DIRECT_SHIP_PVT.Create_Trip');
2040: END IF;
2041: RAISE fnd_api.g_exc_unexpected_error;
2042: END IF;
2043: END IF;

Line 2451: wms_direct_ship_pvt.update_tripstop(

2447: debug('p_dock_door_id : ' || p_dock_door_id , 'print_shipping_document');
2448: debug('p_ship_method_code : ' || p_ship_method_code , 'print_shipping_document');
2449: END IF;
2450:
2451: wms_direct_ship_pvt.update_tripstop(
2452: x_return_status => l_return_status
2453: , x_msg_count => l_msg_count
2454: , x_msg_data => l_msg_data
2455: , p_trip_id => p_trip_id

Line 2746: wms_direct_ship_pvt.print_shipping_document(

2742: AND p_ship_method_code IS NULL THEN
2743: RAISE no_ship_method_code;
2744: END IF;
2745:
2746: wms_direct_ship_pvt.print_shipping_document(
2747: x_return_status => l_return_status
2748: , x_msg_count => l_msg_count
2749: , x_msg_data => l_msg_data
2750: , p_trip_id => p_trip_id

Line 2950: wms_direct_ship_pvt.cleanup_temp_recs(

2946:
2947: LOOP
2948: FETCH closed_trips INTO l_trip_id;
2949: EXIT WHEN closed_trips%NOTFOUND;
2950: wms_direct_ship_pvt.cleanup_temp_recs(
2951: x_msg_data => x_msg_data
2952: , x_msg_count => x_msg_count
2953: , x_return_status => x_return_status
2954: , p_org_id => p_org_id

Line 3479: wms_direct_ship_pvt.cleanup_temp_recs(

3475: END IF;
3476: -- End of Release 12 change
3477:
3478: --Now, clean up the direct ship records from WSTT, WFCT, MSNT and WDST
3479: wms_direct_ship_pvt.cleanup_temp_recs(
3480: x_msg_data => x_msg_data
3481: , x_msg_count => x_msg_count
3482: , x_return_status => l_return_status
3483: , p_org_id => p_org_id

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

3535: x_return_status := fnd_api.g_ret_sts_unexp_error;
3536: ROLLBACK;
3537:
3538: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3539: fnd_msg_pub.add_exc_msg('WMS_DIRECT_SHIP_PVT', 'UNLOAD_TRUCK');
3540: END IF;
3541:
3542: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3543:

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

3651: x_return_status := fnd_api.g_ret_sts_unexp_error;
3652: ROLLBACK;
3653:
3654: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3655: fnd_msg_pub.add_exc_msg('WMS_DIRECT_SHIP_PVT', 'CLEANUP_TEMP');
3656: END IF;
3657:
3658: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3659:

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

3681: x_current_date := SYSDATE;
3682: EXCEPTION
3683: WHEN OTHERS THEN
3684: IF (l_debug = 1) THEN
3685: DEBUG('Error in WMS_DIRECT_SHIP_PVT.get_global_values: ' || x_progress);
3686: END IF;
3687: END get_global_values;
3688:
3689: PROCEDURE create_resv(

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

3786: CLOSE lpn_contents;
3787: END IF;
3788:
3789: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3790: fnd_msg_pub.add_exc_msg('WMS_DIRECT_SHIP_PVT', 'validate_status_lpn_contents');
3791: END IF;
3792:
3793: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3794: END validate_status_lpn_contents;

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

3936:
3937: ROLLBACK TO freight_cost;
3938:
3939: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3940: fnd_msg_pub.add_exc_msg('WMS_DIRECT_SHIP_PVT', 'update_freight_cost');
3941: END IF;
3942:
3943: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3944: END update_freight_cost;

Line 5419: wms_direct_ship_pvt.create_update_containers(

5415:
5416: LOOP
5417: FETCH outer_lpn INTO l_outer_lpn;
5418: EXIT WHEN outer_lpn%NOTFOUND;
5419: wms_direct_ship_pvt.create_update_containers(
5420: x_return_status => l_return_status
5421: , x_msg_count => l_msg_count
5422: , x_msg_data => l_msg_data
5423: , p_org_id => p_organization_id

Line 5462: wms_direct_ship_pvt.container_nesting(

5458: DEBUG('The delivery_detail_id for the lpn_Id is ' || l_cont_instance_id, 'STAGE_LPN');
5459: DEBUG('The delivery_detail_id for the first line is ' || l_delivery_detail_id, 'STAGE_LPN');
5460: END IF;
5461:
5462: wms_direct_ship_pvt.container_nesting(
5463: x_return_status => l_return_status
5464: , x_msg_count => l_msg_count
5465: , x_msg_data => l_msg_data
5466: , p_organization_id => p_organization_id

Line 7637: wms_direct_ship_pvt.confirm_all_deliveries(

7633: IF (l_debug = 1) THEN
7634: DEBUG('Before call to Confirm All deliveries API close_truck');
7635: END IF;
7636:
7637: wms_direct_ship_pvt.confirm_all_deliveries(
7638: x_return_status => l_return_status
7639: , x_msg_count => l_msg_count
7640: , x_msg_data => l_msg_data
7641: , x_missing_item_cur => x_missing_item_cur

Line 7740: wms_direct_ship_pvt.close_trip(

7736: WHEN NO_DATA_FOUND THEN
7737: l_vehicle_item_id := NULL;
7738: END;
7739:
7740: wms_direct_ship_pvt.close_trip(
7741: x_return_status => l_return_status
7742: , x_msg_count => l_msg_count
7743: , x_msg_data => l_msg_data
7744: , p_trip_id => l_trip_cursor.trip_id

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

8227: x_return_status := fnd_api.g_ret_sts_unexp_error;
8228: ROLLBACK;
8229:
8230: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
8231: fnd_msg_pub.add_exc_msg('WMS_DIRECT_SHIP_PVT', 'create_update_containers');
8232: END IF;
8233:
8234: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
8235: END create_update_containers;

Line 9446: wms_direct_ship_pvt.cleanup_orphan_rec(p_org_id);

9442: g_last_updated_by := g_created_by;
9443: g_last_update_login := fnd_global.login_id;
9444: g_last_update_date := g_creation_date;
9445: -- cleaning temp data if the delivery was backordered for this lpn somethimes in past
9446: wms_direct_ship_pvt.cleanup_orphan_rec(p_org_id);
9447:
9448: IF (l_debug = 1) THEN
9449: DEBUG('After cleanup_orphan_rec', 'Process_LPN');
9450: DEBUG('g_fulfillment_base: ' || g_fulfillment_base, 'Process_LPN');

Line 10027: IF NOT wms_direct_ship_pvt.validate_end_unit_num_at(c_index, Trim(l_order_line_rec.end_item_unit_number)) THEN --bug11659908

10023: IF (l_debug = 1) THEN
10024: DEBUG('validate_end_unit_num_at ' ,'Process_LPN');
10025: END IF;
10026: -- check end_item_unit_num
10027: IF NOT wms_direct_ship_pvt.validate_end_unit_num_at(c_index, Trim(l_order_line_rec.end_item_unit_number)) THEN --bug11659908
10028: l_skipped_line_tab(l_order_line_rec.line_id) := 1;
10029:
10030: IF (l_debug = 1) THEN
10031: DEBUG('line ' || l_order_line_rec.line_id || ' put into skipped line', 'Process_LPN');

Line 10058: 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

10054: END IF;
10055: END IF;
10056:
10057: -- validate delivery grouping rules
10058: 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
10059: IF (l_debug = 1) THEN
10060: DEBUG('Delivery grouping failed', 'Process_LPN');
10061: END IF;
10062:

Line 10070: 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

10066: RETURN;
10067: END IF;
10068:
10069: -- check delivery for direct ship
10070: 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
10071: , l_order_line_rec.line_id) THEN
10072: IF (l_debug = 1) THEN
10073: DEBUG('Checl del for direct ship failed', 'Process_LPN');
10074: END IF;

Line 10156: WMS_DIRECT_SHIP_PVT.Get_qty_to_pick(

10152: END IF;
10153:
10154: --Bug5262108. Begin. Check qty to pick considering overship tolerance.
10155: l_return_status := fnd_api.g_ret_sts_success;
10156: WMS_DIRECT_SHIP_PVT.Get_qty_to_pick(
10157: p_order_header_id => l_oe_order_header_id,
10158: p_order_line_id => l_mtl_reservation_tab(resv_index).demand_source_line_id,
10159: p_org_id => p_org_id,
10160: x_return_status => l_return_status,

Line 10464: wms_direct_ship_pvt.validate_status_lpn_contents(

10460: IF NOT g_matl_stat_checked THEN
10461: l_demand_source_type_id := get_demand_src_type(l_processed_lines_tab(l_temp_index).header_id);
10462:
10463: IF l_demand_source_type_id = 2 THEN
10464: wms_direct_ship_pvt.validate_status_lpn_contents(
10465: x_return_status => l_return_status
10466: , x_msg_count => l_msg_count
10467: , x_msg_data => l_msg_data
10468: , p_lpn_id => p_lpn_id

Line 10473: wms_direct_ship_pvt.validate_status_lpn_contents(

10469: , p_org_id => p_org_id
10470: , p_trx_type_id => 52
10471: );
10472: ELSIF l_demand_source_type_id = 8 THEN
10473: wms_direct_ship_pvt.validate_status_lpn_contents(
10474: x_return_status => l_return_status
10475: , x_msg_count => l_msg_count
10476: , x_msg_data => l_msg_data
10477: , p_lpn_id => p_lpn_id

Line 10755: IF NOT wms_direct_ship_pvt.validate_end_unit_num(p_inventory_item_id, Trim(p_end_item_unit_number)) THEN --bug#11659908

10751: END IF;
10752:
10753: --ACTION
10754: -- validate end unit
10755: IF NOT wms_direct_ship_pvt.validate_end_unit_num(p_inventory_item_id, Trim(p_end_item_unit_number)) THEN --bug#11659908
10756: IF (l_debug = 1) THEN
10757: DEBUG('End item unit validation failed', 'Process_Line');
10758: END IF;
10759:

Line 10767: 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

10763: RETURN;
10764: END IF;
10765:
10766: -- checkk delivery for irect ship
10767: 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
10768: IF (l_debug = 1) THEN
10769: DEBUG('Checl del for direct ship failed', 'Process_Line');
10770: END IF;
10771:

Line 10864: wms_direct_ship_pvt.validate_status_lpn_contents(

10860:
10861: IF NOT g_matl_stat_checked THEN
10862: l_mtlstat_prev_unchk := TRUE;
10863: IF l_demand_source_type_id = 2 THEN
10864: wms_direct_ship_pvt.validate_status_lpn_contents(
10865: x_return_status => l_return_status
10866: , x_msg_count => l_msg_count
10867: , x_msg_data => l_msg_data
10868: , p_lpn_id => p_lpn_id

Line 10873: wms_direct_ship_pvt.validate_status_lpn_contents(

10869: , p_org_id => p_org_id
10870: , p_trx_type_id => 52
10871: );
10872: ELSIF l_demand_source_type_id = 8 THEN
10873: wms_direct_ship_pvt.validate_status_lpn_contents(
10874: x_return_status => l_return_status
10875: , x_msg_count => l_msg_count
10876: , x_msg_data => l_msg_data
10877: , p_lpn_id => p_lpn_id

Line 11093: AND wms_direct_ship_pvt.validate_end_unit_num_at(lpnc_rec, Trim(p_end_item_unit_number) ) --bug 11659908

11089: IF ( ( (g_fulfillment_base = 'P' AND l_lpn_cont_rec.quantity > 0)
11090: OR (g_fulfillment_base = 'S' AND l_lpn_cont_rec.secondary_quantity > 0) )
11091: AND (l_resv_rec.revision = l_lpn_cont_rec.revision OR l_resv_rec.revision IS NULL)
11092: AND (l_resv_rec.lot_number = l_lpn_cont_rec.lot_number OR l_resv_rec.lot_number IS NULL)
11093: AND wms_direct_ship_pvt.validate_end_unit_num_at(lpnc_rec, Trim(p_end_item_unit_number) ) --bug 11659908
11094: )
11095: THEN --{
11096: inv_quantity_tree_pub.clear_quantity_cache;
11097:

Line 11439: WMS_DIRECT_SHIP_PVT.Get_qty_to_pick(

11435: --This is to handle overship case. Once the requested qty for the line is satisfied,
11436: --we will try to overship against the line.
11437: IF l_overship_case = 'Y' THEN
11438: l_return_status := fnd_api.g_ret_sts_success;
11439: WMS_DIRECT_SHIP_PVT.Get_qty_to_pick(
11440: p_order_header_id => p_order_header_id,
11441: p_order_line_id => p_order_line_id,
11442: p_org_id => p_org_id,
11443: x_return_status => l_return_status,

Line 11514: AND wms_direct_ship_pvt.validate_end_unit_num_at(lpnc_rec, TRIM(p_end_item_unit_number)) --bug 11659908

11510:
11511: IF ( ( (g_fulfillment_base = 'P' AND l_lpn_cont_rec.quantity > 0)
11512: OR (g_fulfillment_base = 'S' AND l_lpn_cont_rec.secondary_quantity > 0) )
11513: AND (p_revision = l_lpn_cont_rec.revision OR p_revision IS NULL)
11514: AND wms_direct_ship_pvt.validate_end_unit_num_at(lpnc_rec, TRIM(p_end_item_unit_number)) --bug 11659908
11515: )
11516: THEN --{
11517: --inv_quantity_tree_pub.clear_quantity_cache;
11518:

Line 12165: wms_direct_ship_pvt.chk_del_for_direct_ship(

12161:
12162: IF g_checked_deliveries.EXISTS(l_del_cur_rec.delivery_id) THEN
12163: l_result := TRUE;
12164: ELSE -- not already validated go throug normal procedure
12165: wms_direct_ship_pvt.chk_del_for_direct_ship(
12166: x_return_status => l_return_status
12167: , x_msg_count => l_msg_count
12168: , x_msg_data => l_msg_data
12169: , p_delivery_id => l_del_cur_rec.delivery_id

Line 12209: DEBUG('Error status from wms_direct_ship_pvt.chk_del_for_direct_ship', 'Validate_Del_For_DS');

12205: RETURN l_result;
12206: EXCEPTION
12207: WHEN l_chk_del_exc THEN
12208: IF (l_debug = 1) THEN
12209: DEBUG('Error status from wms_direct_ship_pvt.chk_del_for_direct_ship', 'Validate_Del_For_DS');
12210: END IF;
12211:
12212: IF del_cur%ISOPEN THEN
12213: CLOSE del_cur;

Line 12394: wms_direct_ship_pvt.stage_lpns(

12390: IF (l_debug = 1) THEN
12391: DEBUG('Staging LPNs ', 'Load_LPN');
12392: END IF;
12393:
12394: wms_direct_ship_pvt.stage_lpns(
12395: x_return_status => l_return_status
12396: , x_msg_count => l_msg_count
12397: , x_msg_data => l_msg_data
12398: , p_group_id => g_group_id

Line 12428: 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

12424: IF (l_debug = 1) THEN
12425: DEBUG('Updating freight cost', 'Load_LPN');
12426: END IF;
12427:
12428: 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
12429: , p_lpn_id => p_lpn_id);
12430:
12431: IF l_return_status = fnd_api.g_ret_sts_error THEN
12432: IF (l_debug = 1) THEN

Line 12700: IF NOT wms_direct_ship_pvt.validate_end_unit_num_at(l_index, Trim(l_end_item_unit_number)) THEN --bug11659908

12696: IF (l_debug = 1) THEN
12697: DEBUG('l_end_item_unit_number=' || l_end_item_unit_number, 'Perform_Overship_Distribution');
12698: END IF;
12699:
12700: IF NOT wms_direct_ship_pvt.validate_end_unit_num_at(l_index, Trim(l_end_item_unit_number)) THEN --bug11659908
12701: IF (l_debug = 1) THEN
12702: DEBUG('End unit not matching, skipping line', 'Perform_Overship_Distribution');
12703: END IF;
12704: EXIT;

Line 13107: IF NOT wms_direct_ship_pvt.validate_end_unit_num_at(l_index, TRIM(l_loaded_lines_rec.end_item_unit_number)) THEN --bug11659908

13103: DEBUG('Inside create reservation part', 'Perform_Overship_Distribution');
13104: END IF;
13105:
13106: --validate end unit
13107: IF NOT wms_direct_ship_pvt.validate_end_unit_num_at(l_index, TRIM(l_loaded_lines_rec.end_item_unit_number)) THEN --bug11659908
13108: IF (l_debug = 1) THEN
13109: DEBUG('End unit not matching, skipping line', 'Perform_Overship_Distribution');
13110: END IF;
13111:

Line 13935: END WMS_DIRECT_SHIP_PVT;

13931: END IF;
13932: RETURN RET_VAL;
13933: END GET_CATCH_WEIGHT;
13934:
13935: END WMS_DIRECT_SHIP_PVT;