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_SHIPPING_TRANSACTION_PUB dependencies on WMS_SHIPPING_TRANSACTION_PUB

Line 1: PACKAGE BODY WMS_SHIPPING_TRANSACTION_PUB AS

1: PACKAGE BODY WMS_SHIPPING_TRANSACTION_PUB AS
2: /* $Header: WMSPSHPB.pls 120.50.12020000.6 2013/03/14 00:04:52 stdavid ship $ */
3: G_Debug NUMBER;
4:
5: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.g_ret_sts_success;

Line 273: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,

269: SELECT distinct wda.dock_id,
270: inv_project.get_locsegs(milk.inventory_location_id, milk.organization_id) milk_concatenated_segments,
271: wda.dock_appointment_id, wda.organization_id, wda.trip_stop, wts.trip_id,
272: milk1.subinventory_code, milk1.concatenated_segments ,
273: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
274: wt.name trip_name , ( SYSDATE - wda.end_time ) last_schedule_time_diff
275: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
276: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
277: WHERE wda.dock_id = milk.inventory_location_id (+)

Line 302: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,

298: SELECT distinct wda.dock_id,
299: inv_project.get_locsegs(milk.inventory_location_id, milk.organization_id) milk_concatenated_segments,
300: wda.dock_appointment_id, wda.organization_id, wda.trip_stop, wts.trip_id,
301: milk1.subinventory_code, milk1.concatenated_segments ,
302: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
303: wt.name trip_name , ( wda.start_time - SYSDATE) next_schedule_time_diff
304: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
305: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
306: WHERE wda.dock_id = milk.inventory_location_id (+)

Line 3825: wms_shipping_transaction_pub.g_allow_ship_set_break := l_allow_ship_set_break;

3821: --patchset J. Shipping API cleanup
3822:
3823:
3824: -- code added for bug#8596010
3825: wms_shipping_transaction_pub.g_allow_ship_set_break := l_allow_ship_set_break;
3826: IF l_debug = 1 THEN
3827: debug('l_allow_ship_set_break: ' || l_allow_ship_set_break,'SHIP_CONFIRM_ALL');
3828: END IF;
3829: -- End of code added for bug#8596010

Line 3962: WMS_SHIPPING_TRANSACTION_PUB.ship_confirm_all

3958: END IF;
3959: l_debug := g_debug;
3960:
3961: -- call ship confirm
3962: WMS_SHIPPING_TRANSACTION_PUB.ship_confirm_all
3963: (p_delivery_id,
3964: p_organization_id,
3965: p_delivery_name,
3966: p_carrier_id,

Line 4205: wms_shipping_transaction_pub.g_allow_ship_set_break := p_allow_ship_set_break;

4201: debug('Parameter p_close_trip_flag: ' || p_close_trip_flag,'LPN_SHIP');
4202:
4203: debug('Parameter p_allow_ship_set_break: ' || p_allow_ship_set_break,'LPN_SHIP');
4204: END IF;
4205: wms_shipping_transaction_pub.g_allow_ship_set_break := p_allow_ship_set_break;
4206:
4207: --IF p_close_trip_flag = 'N' THEN
4208: OPEN C_Ship_Confirm_Parameters;
4209: FETCH C_Ship_Confirm_Parameters INTO l_sc_rule_id, l_intransit_flag, l_close_trip_flag, l_defer_interface_flag;

Line 5382: debug('update_wdd_loc_by_lpn 10 - p_lpn_id = '||p_lpn_id,'WMS_SHIPPING_TRANSACTION_PUB');

5378: END IF;
5379: l_debug := g_debug;
5380:
5381: IF (l_debug = 1) THEN
5382: debug('update_wdd_loc_by_lpn 10 - p_lpn_id = '||p_lpn_id,'WMS_SHIPPING_TRANSACTION_PUB');
5383: debug('p_subinventory_code = ' || p_subinventory_code, 'WMS_SHIPPING_TRANSACTION_PUB');
5384: debug('p_locator_id = ' || p_locator_id, 'WMS_SHIPPING_TRANSACTION_PUB');
5385: END IF;
5386:

Line 5383: debug('p_subinventory_code = ' || p_subinventory_code, 'WMS_SHIPPING_TRANSACTION_PUB');

5379: l_debug := g_debug;
5380:
5381: IF (l_debug = 1) THEN
5382: debug('update_wdd_loc_by_lpn 10 - p_lpn_id = '||p_lpn_id,'WMS_SHIPPING_TRANSACTION_PUB');
5383: debug('p_subinventory_code = ' || p_subinventory_code, 'WMS_SHIPPING_TRANSACTION_PUB');
5384: debug('p_locator_id = ' || p_locator_id, 'WMS_SHIPPING_TRANSACTION_PUB');
5385: END IF;
5386:
5387: SAVEPOINT update_wdd_loc_sp;

Line 5384: debug('p_locator_id = ' || p_locator_id, 'WMS_SHIPPING_TRANSACTION_PUB');

5380:
5381: IF (l_debug = 1) THEN
5382: debug('update_wdd_loc_by_lpn 10 - p_lpn_id = '||p_lpn_id,'WMS_SHIPPING_TRANSACTION_PUB');
5383: debug('p_subinventory_code = ' || p_subinventory_code, 'WMS_SHIPPING_TRANSACTION_PUB');
5384: debug('p_locator_id = ' || p_locator_id, 'WMS_SHIPPING_TRANSACTION_PUB');
5385: END IF;
5386:
5387: SAVEPOINT update_wdd_loc_sp;
5388: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5408: ||l_delivery_detail_id,'WMS_SHIPPING_TRANSACTION_PUB');

5404: l_progress := '30';
5405:
5406: IF (l_debug = 1) THEN
5407: debug('update_wdd_loc_by_lpn 15 - l_delivery_detail_id = '
5408: ||l_delivery_detail_id,'WMS_SHIPPING_TRANSACTION_PUB');
5409: debug('l_oe_order_header_id = '||l_oe_order_header_id,'WMS_SHIPPING_TRANSACTION_PUB');
5410: debug('l_oe_order_line_id = '||l_oe_order_line_id,'WMS_SHIPPING_TRANSACTION_PUB');
5411: debug('l_organization_id = '||l_organization_id,'WMS_SHIPPING_TRANSACTION_PUB');
5412: debug('l_released_status = '||l_released_status,'WMS_SHIPPING_TRANSACTION_PUB');

Line 5409: debug('l_oe_order_header_id = '||l_oe_order_header_id,'WMS_SHIPPING_TRANSACTION_PUB');

5405:
5406: IF (l_debug = 1) THEN
5407: debug('update_wdd_loc_by_lpn 15 - l_delivery_detail_id = '
5408: ||l_delivery_detail_id,'WMS_SHIPPING_TRANSACTION_PUB');
5409: debug('l_oe_order_header_id = '||l_oe_order_header_id,'WMS_SHIPPING_TRANSACTION_PUB');
5410: debug('l_oe_order_line_id = '||l_oe_order_line_id,'WMS_SHIPPING_TRANSACTION_PUB');
5411: debug('l_organization_id = '||l_organization_id,'WMS_SHIPPING_TRANSACTION_PUB');
5412: debug('l_released_status = '||l_released_status,'WMS_SHIPPING_TRANSACTION_PUB');
5413: END IF;

Line 5410: debug('l_oe_order_line_id = '||l_oe_order_line_id,'WMS_SHIPPING_TRANSACTION_PUB');

5406: IF (l_debug = 1) THEN
5407: debug('update_wdd_loc_by_lpn 15 - l_delivery_detail_id = '
5408: ||l_delivery_detail_id,'WMS_SHIPPING_TRANSACTION_PUB');
5409: debug('l_oe_order_header_id = '||l_oe_order_header_id,'WMS_SHIPPING_TRANSACTION_PUB');
5410: debug('l_oe_order_line_id = '||l_oe_order_line_id,'WMS_SHIPPING_TRANSACTION_PUB');
5411: debug('l_organization_id = '||l_organization_id,'WMS_SHIPPING_TRANSACTION_PUB');
5412: debug('l_released_status = '||l_released_status,'WMS_SHIPPING_TRANSACTION_PUB');
5413: END IF;
5414:

Line 5411: debug('l_organization_id = '||l_organization_id,'WMS_SHIPPING_TRANSACTION_PUB');

5407: debug('update_wdd_loc_by_lpn 15 - l_delivery_detail_id = '
5408: ||l_delivery_detail_id,'WMS_SHIPPING_TRANSACTION_PUB');
5409: debug('l_oe_order_header_id = '||l_oe_order_header_id,'WMS_SHIPPING_TRANSACTION_PUB');
5410: debug('l_oe_order_line_id = '||l_oe_order_line_id,'WMS_SHIPPING_TRANSACTION_PUB');
5411: debug('l_organization_id = '||l_organization_id,'WMS_SHIPPING_TRANSACTION_PUB');
5412: debug('l_released_status = '||l_released_status,'WMS_SHIPPING_TRANSACTION_PUB');
5413: END IF;
5414:
5415: l_shipping_attr_tab(l_wdd_counter).source_header_id := l_oe_order_header_id;

Line 5412: debug('l_released_status = '||l_released_status,'WMS_SHIPPING_TRANSACTION_PUB');

5408: ||l_delivery_detail_id,'WMS_SHIPPING_TRANSACTION_PUB');
5409: debug('l_oe_order_header_id = '||l_oe_order_header_id,'WMS_SHIPPING_TRANSACTION_PUB');
5410: debug('l_oe_order_line_id = '||l_oe_order_line_id,'WMS_SHIPPING_TRANSACTION_PUB');
5411: debug('l_organization_id = '||l_organization_id,'WMS_SHIPPING_TRANSACTION_PUB');
5412: debug('l_released_status = '||l_released_status,'WMS_SHIPPING_TRANSACTION_PUB');
5413: END IF;
5414:
5415: l_shipping_attr_tab(l_wdd_counter).source_header_id := l_oe_order_header_id;
5416: l_shipping_attr_tab(l_wdd_counter).source_line_id := l_oe_order_line_id;

Line 5427: ||l_shipping_attr_tab(l_wdd_counter).delivery_detail_id, 'WMS_SHIPPING_TRANSACTION_PUB');

5423: l_shipping_attr_tab(l_wdd_counter).transfer_lpn_id := p_lpn_id;
5424:
5425: IF (l_debug = 1) THEN
5426: debug('Disassociate delivery detail with the old lpn, delivery detail id = '
5427: ||l_shipping_attr_tab(l_wdd_counter).delivery_detail_id, 'WMS_SHIPPING_TRANSACTION_PUB');
5428: END IF;
5429:
5430: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont
5431: ( P_DETAIL_ID => l_shipping_attr_tab(l_wdd_counter).delivery_detail_id,

Line 5435: debug('Error Unassign_Detail_from_Cont'|| l_return_status, 'WMS_SHIPPING_TRANSACTION_PUB');

5431: ( P_DETAIL_ID => l_shipping_attr_tab(l_wdd_counter).delivery_detail_id,
5432: X_RETURN_STATUS => l_return_status );
5433: if (l_return_status <> fnd_api.g_ret_sts_success) then
5434: IF (l_debug = 1) THEN
5435: debug('Error Unassign_Detail_from_Cont'|| l_return_status, 'WMS_SHIPPING_TRANSACTION_PUB');
5436: END IF;
5437: FND_MESSAGE.SET_NAME('INV', 'INV_UNASSIGN_DEL_FAILURE');
5438: FND_MSG_PUB.ADD;
5439: RAISE FND_API.G_EXC_ERROR;

Line 5451: debug('update_wdd_loc_by_lpn 20 - l_wdd_counter = ' || l_wdd_counter, 'WMS_SHIPPING_TRANSACTION_PUB');

5447: CLOSE cur_delivery_details;
5448:
5449:
5450: IF (l_debug = 1) THEN
5451: debug('update_wdd_loc_by_lpn 20 - l_wdd_counter = ' || l_wdd_counter, 'WMS_SHIPPING_TRANSACTION_PUB');
5452: END IF;
5453:
5454: l_progress := '50';
5455:

Line 5464: ||l_return_status, 'WMS_SHIPPING_TRANSACTION_PUB');

5460: );
5461:
5462: IF (l_debug = 1) THEN
5463: debug('update_wdd_loc_by_lpn 25 - WSH_INTERFACE.Update_Shipping_Attributes returns : '
5464: ||l_return_status, 'WMS_SHIPPING_TRANSACTION_PUB');
5465: END IF;
5466:
5467: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5468: IF (l_debug = 1) THEN

Line 5470: 'WMS_SHIPPING_TRANSACTION_PUB');

5466:
5467: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5468: IF (l_debug = 1) THEN
5469: debug('update_wdd_loc_by_lpn 30 - return expected error from update_shipping_attributes',
5470: 'WMS_SHIPPING_TRANSACTION_PUB');
5471: END IF;
5472:
5473: RAISE FND_API.G_EXC_ERROR;
5474:

Line 5478: 'WMS_SHIPPING_TRANSACTION_PUB');

5474:
5475: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5476: IF (l_debug = 1) THEN
5477: debug('update_wdd_loc_by_lpn 40 - return unexpected error from update_shipping_attributes',
5478: 'WMS_SHIPPING_TRANSACTION_PUB');
5479: END IF;
5480:
5481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5482: END IF;

Line 5487: debug('update_wdd_loc_by_lpn 50 - complete','WMS_SHIPPING_TRANSACTION_PUB');

5483:
5484: l_progress := '60';
5485:
5486: IF (l_debug = 1) THEN
5487: debug('update_wdd_loc_by_lpn 50 - complete','WMS_SHIPPING_TRANSACTION_PUB');
5488: END IF;
5489:
5490: EXCEPTION
5491: WHEN fnd_api.g_exc_error THEN

Line 5503: debug('update_wdd_loc_by_lpn 60 - expected error', 'WMS_SHIPPING_TRANSACTION_PUB');

5499: FND_MESSAGE.SET_NAME('WMS', 'WMS_UPDATE_WDD_LOC_FAIL');
5500: FND_MSG_PUB.ADD;
5501:
5502: IF (l_debug = 1) THEN
5503: debug('update_wdd_loc_by_lpn 60 - expected error', 'WMS_SHIPPING_TRANSACTION_PUB');
5504: END IF;
5505:
5506: WHEN fnd_api.g_exc_unexpected_error THEN
5507: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5518: debug('update_wdd_loc_by_lpn 65 - unexpected error', 'WMS_SHIPPING_TRANSACTION_PUB');

5514: FND_MESSAGE.SET_NAME('WMS', 'WMS_UPDATE_WDD_LOC_FAIL');
5515: FND_MSG_PUB.ADD;
5516:
5517: IF (l_debug = 1) THEN
5518: debug('update_wdd_loc_by_lpn 65 - unexpected error', 'WMS_SHIPPING_TRANSACTION_PUB');
5519: END IF;
5520:
5521: WHEN OTHERS THEN
5522: ROLLBACK TO update_wdd_loc_sp;

Line 5529: debug('update_wdd_loc_by_lpn 70 - other error', 'WMS_SHIPPING_TRANSACTION_PUB');

5525: CLOSE cur_delivery_details;
5526: END IF;
5527:
5528: IF (l_debug = 1) THEN
5529: debug('update_wdd_loc_by_lpn 70 - other error', 'WMS_SHIPPING_TRANSACTION_PUB');
5530: END IF;
5531:
5532: FND_MESSAGE.SET_NAME('WMS', 'WMS_UPDATE_WDD_LOC_FAIL');
5533: FND_MSG_PUB.ADD;

Line 5536: inv_mobile_helper_functions.sql_error('WMS_SHIPPING_TRANSACTION_PUB.update_wdd_loc_by_lpn',

5532: FND_MESSAGE.SET_NAME('WMS', 'WMS_UPDATE_WDD_LOC_FAIL');
5533: FND_MSG_PUB.ADD;
5534:
5535: IF SQLCODE IS NOT NULL THEN
5536: inv_mobile_helper_functions.sql_error('WMS_SHIPPING_TRANSACTION_PUB.update_wdd_loc_by_lpn',
5537: l_progress, SQLCODE);
5538: END IF;
5539:
5540: END update_wdd_loc_by_lpn;

Line 6872: debug(' AFTER calling wms_shipping_transaction_pub.ship_confirm_lpn_deliveries()', 'CLOSE_TRUCK');

6868: p_organization_id => p_organization_id,
6869: p_verify_only => 'N');
6870:
6871: IF (l_debug = 1) THEN
6872: debug(' AFTER calling wms_shipping_transaction_pub.ship_confirm_lpn_deliveries()', 'CLOSE_TRUCK');
6873: debug(' l_return_status::' ||l_return_status, 'CLOSE_TRUCK');
6874: debug(' l_msg_data::' ||l_msg_data, 'CLOSE_TRUCK');
6875: END IF;
6876:

Line 7037: END WMS_SHIPPING_TRANSACTION_PUB;

7033: END update_lpn_contents;
7034:
7035:
7036:
7037: END WMS_SHIPPING_TRANSACTION_PUB;