DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_DELIVERIES_PUB

Line 2826: l_delivery_info wsh_deliveries_pub.delivery_pub_rec_type;

2822:
2823: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2824: l_debug number;
2825:
2826: l_delivery_info wsh_deliveries_pub.delivery_pub_rec_type;
2827: l_delivery_id NUMBER;
2828: l_delivery_name VARCHAR2(30);
2829:
2830: l_trip_id NUMBER := null;

Line 2943: debug('About to call wsh_deliveries_pub.create_update_delivery with'

2939:
2940: l_delivery_info.delivery_id := p_delivery_id;
2941:
2942: IF (l_debug=1) THEN
2943: debug('About to call wsh_deliveries_pub.create_update_delivery with'
2944: || ' gross_weight: ' || l_delivery_info.gross_weight
2945: || ' waybill : ' || l_delivery_info.waybill
2946: || ' ship method code: ' || l_delivery_info.ship_method_code
2947: || ' weight uom code: ' || l_delivery_info.weight_uom_code

Line 2951: wsh_deliveries_pub.create_update_delivery

2947: || ' weight uom code: ' || l_delivery_info.weight_uom_code
2948: || ' delivery ID: ' || l_delivery_info.delivery_id, 'UPDATE_DELIVERY');
2949: END IF;
2950:
2951: wsh_deliveries_pub.create_update_delivery
2952: (p_api_version_number => 1.0,
2953: p_init_msg_list => fnd_api.g_false,
2954: x_return_status => x_return_status,
2955: x_msg_count => l_msg_count,

Line 2963: debug('return_status from WSH_DELIVERIES_PUB.create_update_delivery: '

2959: x_delivery_id => l_delivery_id,
2960: x_name => l_delivery_name);
2961:
2962: IF l_debug = 1 then
2963: debug('return_status from WSH_DELIVERIES_PUB.create_update_delivery: '
2964: || x_return_status,'UPDATE_DELIVERY');
2965: END IF;
2966:
2967:

Line 3673: l_delivery_info wsh_deliveries_pub.delivery_pub_rec_type;

3669: l_summary VARCHAR2(2000);
3670: l_msg_count NUMBER;
3671:
3672: --Variables added as part of shipping API cleanup project for patchset J
3673: l_delivery_info wsh_deliveries_pub.delivery_pub_rec_type;
3674: l_msg_data VARCHAR2(2000);
3675: l_delivery_id NUMBER;
3676: l_delivery_name VARCHAR2(30);
3677: l_trip_id VARCHAR2(30);

Line 3817: debug('About to call wsh_deliveries_pub.delivery_action',

3813: debug('l_sc_defer_interface_flag: ' || l_sc_defer_interface_flag,'SHIP_CONFIRM_ALL');
3814: END IF;
3815:
3816: IF (l_debug = 1) THEN
3817: debug('About to call wsh_deliveries_pub.delivery_action',
3818: 'SHIP_CONFIRM_ALL');
3819: debug('delivery_id : ' || p_delivery_id,'SHIP_CONFIRM_ALL');
3820: END IF;
3821: --patchset J. Shipping API cleanup

Line 3832: wsh_deliveries_pub.delivery_action

3828: END IF;
3829: -- End of code added for bug#8596010
3830:
3831:
3832: wsh_deliveries_pub.delivery_action
3833: (p_api_version_number => 1.0,
3834: p_init_msg_list => G_TRUE,
3835: x_return_status => l_return_status,
3836: x_msg_count => l_msg_count,

Line 3854: debug('wsh_deliveries_pub.delivery_action finished with status: '

3850: x_trip_name => l_trip_name);
3851: --\Shipping API cleanup
3852:
3853: IF l_debug = 1 THEN
3854: debug('wsh_deliveries_pub.delivery_action finished with status: '
3855: || l_return_status,'SHIP_CONFIRM_ALL');
3856: END IF;
3857:
3858: if( l_return_status not in ('S', 'W') ) then

Line 4416: debug('About to call wsh_deliveries_pub.delivery_action'

4412:
4413: --patchset J. Shipping API cleanup
4414: FOR i IN 1..l_del_rows.COUNT LOOP
4415: IF l_debug = 1 THEN
4416: debug('About to call wsh_deliveries_pub.delivery_action'
4417: || ' with delivery_id : ' || l_del_rows(i) || ' ship_method_code: '
4418: || l_ship_method_tbl(i),'SHIP_CONFIRM_LPN_DELIVERIES');
4419: END IF;
4420:

Line 4458: wsh_deliveries_pub.delivery_action

4454: l_sc_close_trip_flag := 'Y';
4455: l_sc_defer_interface_flag := 'N';
4456: END IF;
4457:
4458: wsh_deliveries_pub.delivery_action
4459: (p_api_version_number => 1.0,
4460: p_init_msg_list => fnd_api.g_true,
4461: x_return_status => l_return_status,
4462: x_msg_count => l_msg_count,

Line 4480: debug('wsh_deliveries_pub.delivery_action failed '

4476: x_trip_name => l_trip_name);
4477:
4478: IF (l_return_status NOT IN ('S','W')) THEN
4479: IF l_debug = 1 THEN
4480: debug('wsh_deliveries_pub.delivery_action failed '
4481: || 'with status ' || l_return_status,'SHIP_CONFIRM_LPN_DELIVERIES');
4482: END IF;
4483:
4484: ROLLBACK;

Line 4573: debug('About to call wsh_deliveries_pub.delivery_action'

4569: --patchset J. Shipping API cleanup
4570: FOR i IN 1..l_del_rows.COUNT LOOP
4571: IF l_debug = 1 THEN
4572: debug('Shipping out delivereis that have trip.','SHIP_CONFIRM_LPN_DELIVERIES');
4573: debug('About to call wsh_deliveries_pub.delivery_action'
4574: || ' with delivery_id : ' || l_del_rows(i) || ' and ship_method_code: '
4575: || l_ship_method_tbl(i),'SHIP_CONFIRM_LPN_DELIVERIES');
4576: END IF;
4577:

Line 4603: wsh_deliveries_pub.delivery_action

4599: 'SHIP_CONFIRM_LPN_DELIVERIES');
4600: END IF;
4601:
4602:
4603: wsh_deliveries_pub.delivery_action
4604: (p_api_version_number => 1.0,
4605: p_init_msg_list => fnd_api.g_false,
4606: x_return_status => l_return_status,
4607: x_msg_count => l_msg_count,

Line 4625: debug('wsh_deliveries_pub.delivery_action failed '

4621: x_trip_name => l_trip_name);
4622:
4623: IF (l_return_status NOT IN ('S','W')) THEN
4624: IF l_debug = 1 THEN
4625: debug('wsh_deliveries_pub.delivery_action failed '
4626: || 'with status ' || l_return_status,'SHIP_CONFIRM_LPN_DELIVERIES');
4627: END IF;
4628:
4629: ROLLBACK;

Line 4786: debug('About to call wsh_deliveries_pub.delivery_action'

4782:
4783: FOR i IN 1..l_del_rows.COUNT LOOP
4784: IF l_debug = 1 THEN
4785: debug('p_trip_stop_id is : ' || p_trip_stop_id, 'SHIP_CONFIRM_LPN_DELIVEREIS');
4786: debug('About to call wsh_deliveries_pub.delivery_action'
4787: || ' with delivery_id : ' || l_del_rows(i) || ' and ship_method_code: '
4788: || l_ship_method_tbl(i),'SHIP_CONFIRM_LPN_DELIVERIES');
4789: END IF;
4790:

Line 4817: wsh_deliveries_pub.delivery_action

4813: 'SHIP_CONFIRM_LPN_DELIVERIES');
4814: END IF;
4815:
4816:
4817: wsh_deliveries_pub.delivery_action
4818: (p_api_version_number => 1.0,
4819: p_init_msg_list => fnd_api.g_false,
4820: x_return_status => l_return_status,
4821: x_msg_count => l_msg_count,

Line 4839: debug('wsh_deliveries_pub.delivery_action failed '

4835: x_trip_name => l_trip_name);
4836:
4837: IF (l_return_status NOT IN ('S','W')) THEN
4838: IF l_debug = 1 THEN
4839: debug('wsh_deliveries_pub.delivery_action failed '
4840: || 'with status ' || l_return_status,'SHIP_CONFIRM_LPN_DELIVERIES');
4841: END IF;
4842:
4843: ROLLBACK;