DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on WSH_DELIVERIES_PUB

Line 2765: l_delivery_info wsh_deliveries_pub.delivery_pub_rec_type;

2761:
2762: --l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2763: l_debug number;
2764:
2765: l_delivery_info wsh_deliveries_pub.delivery_pub_rec_type;
2766: l_delivery_id NUMBER;
2767: l_delivery_name VARCHAR2(30);
2768:
2769: l_trip_id NUMBER := null;

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

2878:
2879: l_delivery_info.delivery_id := p_delivery_id;
2880:
2881: IF (l_debug=1) THEN
2882: debug('About to call wsh_deliveries_pub.create_update_delivery with'
2883: || ' gross_weight: ' || l_delivery_info.gross_weight
2884: || ' waybill : ' || l_delivery_info.waybill
2885: || ' ship method code: ' || l_delivery_info.ship_method_code
2886: || ' weight uom code: ' || l_delivery_info.weight_uom_code

Line 2890: wsh_deliveries_pub.create_update_delivery

2886: || ' weight uom code: ' || l_delivery_info.weight_uom_code
2887: || ' delivery ID: ' || l_delivery_info.delivery_id, 'UPDATE_DELIVERY');
2888: END IF;
2889:
2890: wsh_deliveries_pub.create_update_delivery
2891: (p_api_version_number => 1.0,
2892: p_init_msg_list => fnd_api.g_false,
2893: x_return_status => x_return_status,
2894: x_msg_count => l_msg_count,

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

2898: x_delivery_id => l_delivery_id,
2899: x_name => l_delivery_name);
2900:
2901: IF l_debug = 1 then
2902: debug('return_status from WSH_DELIVERIES_PUB.create_update_delivery: '
2903: || x_return_status,'UPDATE_DELIVERY');
2904: END IF;
2905:
2906:

Line 3612: l_delivery_info wsh_deliveries_pub.delivery_pub_rec_type;

3608: l_summary VARCHAR2(2000);
3609: l_msg_count NUMBER;
3610:
3611: --Variables added as part of shipping API cleanup project for patchset J
3612: l_delivery_info wsh_deliveries_pub.delivery_pub_rec_type;
3613: l_msg_data VARCHAR2(2000);
3614: l_delivery_id NUMBER;
3615: l_delivery_name VARCHAR2(30);
3616: l_trip_id VARCHAR2(30);

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

3693:
3694:
3695:
3696: IF (l_debug = 1) THEN
3697: debug('About to call wsh_deliveries_pub.delivery_action',
3698: 'SHIP_CONFIRM_ALL');
3699: debug('delivery_id : ' || p_delivery_id,'SHIP_CONFIRM_ALL');
3700: END IF;
3701: --patchset J. Shipping API cleanup

Line 3702: wsh_deliveries_pub.delivery_action

3698: 'SHIP_CONFIRM_ALL');
3699: debug('delivery_id : ' || p_delivery_id,'SHIP_CONFIRM_ALL');
3700: END IF;
3701: --patchset J. Shipping API cleanup
3702: wsh_deliveries_pub.delivery_action
3703: (p_api_version_number => 1.0,
3704: p_init_msg_list => G_TRUE,
3705: x_return_status => l_return_status,
3706: x_msg_count => l_msg_count,

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

3720: x_trip_name => l_trip_name);
3721: --\Shipping API cleanup
3722:
3723: IF l_debug = 1 THEN
3724: debug('wsh_deliveries_pub.delivery_action finished with status: '
3725: || l_return_status,'SHIP_CONFIRM_ALL');
3726: END IF;
3727:
3728: if( l_return_status not in ('S', 'W') ) then

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

4252:
4253: --patchset J. Shipping API cleanup
4254: FOR i IN 1..l_del_rows.COUNT LOOP
4255: IF l_debug = 1 THEN
4256: debug('About to call wsh_deliveries_pub.delivery_action'
4257: || ' with delivery_id : ' || l_del_rows(i) || ' ship_method_code: '
4258: || l_ship_method_tbl(i),'SHIP_CONFIRM_LPN_DELIVERIES');
4259: END IF;
4260:

Line 4298: wsh_deliveries_pub.delivery_action

4294: l_sc_close_trip_flag := 'Y';
4295: l_sc_defer_interface_flag := 'N';
4296: END IF;
4297:
4298: wsh_deliveries_pub.delivery_action
4299: (p_api_version_number => 1.0,
4300: p_init_msg_list => fnd_api.g_true,
4301: x_return_status => l_return_status,
4302: x_msg_count => l_msg_count,

Line 4320: debug('wsh_deliveries_pub.delivery_action failed '

4316: x_trip_name => l_trip_name);
4317:
4318: IF (l_return_status NOT IN ('S','W')) THEN
4319: IF l_debug = 1 THEN
4320: debug('wsh_deliveries_pub.delivery_action failed '
4321: || 'with status ' || l_return_status,'SHIP_CONFIRM_LPN_DELIVERIES');
4322: END IF;
4323:
4324: ROLLBACK;

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

4409: --patchset J. Shipping API cleanup
4410: FOR i IN 1..l_del_rows.COUNT LOOP
4411: IF l_debug = 1 THEN
4412: debug('Shipping out delivereis that have trip.','SHIP_CONFIRM_LPN_DELIVERIES');
4413: debug('About to call wsh_deliveries_pub.delivery_action'
4414: || ' with delivery_id : ' || l_del_rows(i) || ' and ship_method_code: '
4415: || l_ship_method_tbl(i),'SHIP_CONFIRM_LPN_DELIVERIES');
4416: END IF;
4417:

Line 4443: wsh_deliveries_pub.delivery_action

4439: 'SHIP_CONFIRM_LPN_DELIVERIES');
4440: END IF;
4441:
4442:
4443: wsh_deliveries_pub.delivery_action
4444: (p_api_version_number => 1.0,
4445: p_init_msg_list => fnd_api.g_false,
4446: x_return_status => l_return_status,
4447: x_msg_count => l_msg_count,

Line 4465: debug('wsh_deliveries_pub.delivery_action failed '

4461: x_trip_name => l_trip_name);
4462:
4463: IF (l_return_status NOT IN ('S','W')) THEN
4464: IF l_debug = 1 THEN
4465: debug('wsh_deliveries_pub.delivery_action failed '
4466: || 'with status ' || l_return_status,'SHIP_CONFIRM_LPN_DELIVERIES');
4467: END IF;
4468:
4469: ROLLBACK;

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

4622:
4623: FOR i IN 1..l_del_rows.COUNT LOOP
4624: IF l_debug = 1 THEN
4625: debug('p_trip_stop_id is : ' || p_trip_stop_id, 'SHIP_CONFIRM_LPN_DELIVEREIS');
4626: debug('About to call wsh_deliveries_pub.delivery_action'
4627: || ' with delivery_id : ' || l_del_rows(i) || ' and ship_method_code: '
4628: || l_ship_method_tbl(i),'SHIP_CONFIRM_LPN_DELIVERIES');
4629: END IF;
4630:

Line 4657: wsh_deliveries_pub.delivery_action

4653: 'SHIP_CONFIRM_LPN_DELIVERIES');
4654: END IF;
4655:
4656:
4657: wsh_deliveries_pub.delivery_action
4658: (p_api_version_number => 1.0,
4659: p_init_msg_list => fnd_api.g_false,
4660: x_return_status => l_return_status,
4661: x_msg_count => l_msg_count,

Line 4679: debug('wsh_deliveries_pub.delivery_action failed '

4675: x_trip_name => l_trip_name);
4676:
4677: IF (l_return_status NOT IN ('S','W')) THEN
4678: IF l_debug = 1 THEN
4679: debug('wsh_deliveries_pub.delivery_action failed '
4680: || 'with status ' || l_return_status,'SHIP_CONFIRM_LPN_DELIVERIES');
4681: END IF;
4682:
4683: ROLLBACK;