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.35.12010000.3 2008/09/30 09:21:36 shrmitra ship $ */
3: G_Debug NUMBER;
4:
5: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.g_ret_sts_success;

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

218: SELECT distinct wda.dock_id,
219: inv_project.get_locsegs(milk.inventory_location_id, milk.organization_id) milk_concatenated_segments,
220: wda.dock_appointment_id, wda.organization_id, wda.trip_stop, wts.trip_id,
221: milk1.subinventory_code, milk1.concatenated_segments ,
222: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
223: wt.name trip_name , ( SYSDATE - wda.end_time ) last_schedule_time_diff
224: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
225: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
226: WHERE wda.dock_id = milk.inventory_location_id (+)

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

247: SELECT distinct wda.dock_id,
248: inv_project.get_locsegs(milk.inventory_location_id, milk.organization_id) milk_concatenated_segments,
249: wda.dock_appointment_id, wda.organization_id, wda.trip_stop, wts.trip_id,
250: milk1.subinventory_code, milk1.concatenated_segments ,
251: WMS_SHIPPING_TRANSACTION_PUB.is_loaded(p_organization_id,wda.dock_id,'Y') is_loaded ,
252: wt.name trip_name , ( wda.start_time - SYSDATE) next_schedule_time_diff
253: FROM wms_dock_appointments_b wda, mtl_item_locations_kfv milk, wsh_delivery_legs_ob_grp_v wdl,
254: wsh_Trip_stops_ob_grp_v wts, mtl_item_locations_kfv milk1,wsh_trips wt
255: WHERE wda.dock_id = milk.inventory_location_id (+)

Line 3826: WMS_SHIPPING_TRANSACTION_PUB.ship_confirm_all

3822: END IF;
3823: l_debug := g_debug;
3824:
3825: -- call ship confirm
3826: WMS_SHIPPING_TRANSACTION_PUB.ship_confirm_all
3827: (p_delivery_id,
3828: p_organization_id,
3829: p_delivery_name,
3830: p_carrier_id,

Line 4045: wms_shipping_transaction_pub.g_allow_ship_set_break := p_allow_ship_set_break;

4041: debug('Parameter p_close_trip_flag: ' || p_close_trip_flag,'LPN_SHIP');
4042:
4043: debug('Parameter p_allow_ship_set_break: ' || p_allow_ship_set_break,'LPN_SHIP');
4044: END IF;
4045: wms_shipping_transaction_pub.g_allow_ship_set_break := p_allow_ship_set_break;
4046:
4047: IF p_close_trip_flag = 'N' THEN
4048: OPEN C_Ship_Confirm_Parameters;
4049: FETCH C_Ship_Confirm_Parameters INTO l_sc_rule_id, l_intransit_flag, l_close_trip_flag, l_defer_interface_flag;

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

5218: END IF;
5219: l_debug := g_debug;
5220:
5221: IF (l_debug = 1) THEN
5222: debug('update_wdd_loc_by_lpn 10 - p_lpn_id = '||p_lpn_id,'WMS_SHIPPING_TRANSACTION_PUB');
5223: debug('p_subinventory_code = ' || p_subinventory_code, 'WMS_SHIPPING_TRANSACTION_PUB');
5224: debug('p_locator_id = ' || p_locator_id, 'WMS_SHIPPING_TRANSACTION_PUB');
5225: END IF;
5226:

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

5219: l_debug := g_debug;
5220:
5221: IF (l_debug = 1) THEN
5222: debug('update_wdd_loc_by_lpn 10 - p_lpn_id = '||p_lpn_id,'WMS_SHIPPING_TRANSACTION_PUB');
5223: debug('p_subinventory_code = ' || p_subinventory_code, 'WMS_SHIPPING_TRANSACTION_PUB');
5224: debug('p_locator_id = ' || p_locator_id, 'WMS_SHIPPING_TRANSACTION_PUB');
5225: END IF;
5226:
5227: SAVEPOINT update_wdd_loc_sp;

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

5220:
5221: IF (l_debug = 1) THEN
5222: debug('update_wdd_loc_by_lpn 10 - p_lpn_id = '||p_lpn_id,'WMS_SHIPPING_TRANSACTION_PUB');
5223: debug('p_subinventory_code = ' || p_subinventory_code, 'WMS_SHIPPING_TRANSACTION_PUB');
5224: debug('p_locator_id = ' || p_locator_id, 'WMS_SHIPPING_TRANSACTION_PUB');
5225: END IF;
5226:
5227: SAVEPOINT update_wdd_loc_sp;
5228: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5244: l_progress := '30';
5245:
5246: IF (l_debug = 1) THEN
5247: debug('update_wdd_loc_by_lpn 15 - l_delivery_detail_id = '
5248: ||l_delivery_detail_id,'WMS_SHIPPING_TRANSACTION_PUB');
5249: debug('l_oe_order_header_id = '||l_oe_order_header_id,'WMS_SHIPPING_TRANSACTION_PUB');
5250: debug('l_oe_order_line_id = '||l_oe_order_line_id,'WMS_SHIPPING_TRANSACTION_PUB');
5251: debug('l_organization_id = '||l_organization_id,'WMS_SHIPPING_TRANSACTION_PUB');
5252: debug('l_released_status = '||l_released_status,'WMS_SHIPPING_TRANSACTION_PUB');

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

5245:
5246: IF (l_debug = 1) THEN
5247: debug('update_wdd_loc_by_lpn 15 - l_delivery_detail_id = '
5248: ||l_delivery_detail_id,'WMS_SHIPPING_TRANSACTION_PUB');
5249: debug('l_oe_order_header_id = '||l_oe_order_header_id,'WMS_SHIPPING_TRANSACTION_PUB');
5250: debug('l_oe_order_line_id = '||l_oe_order_line_id,'WMS_SHIPPING_TRANSACTION_PUB');
5251: debug('l_organization_id = '||l_organization_id,'WMS_SHIPPING_TRANSACTION_PUB');
5252: debug('l_released_status = '||l_released_status,'WMS_SHIPPING_TRANSACTION_PUB');
5253: END IF;

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

5246: IF (l_debug = 1) THEN
5247: debug('update_wdd_loc_by_lpn 15 - l_delivery_detail_id = '
5248: ||l_delivery_detail_id,'WMS_SHIPPING_TRANSACTION_PUB');
5249: debug('l_oe_order_header_id = '||l_oe_order_header_id,'WMS_SHIPPING_TRANSACTION_PUB');
5250: debug('l_oe_order_line_id = '||l_oe_order_line_id,'WMS_SHIPPING_TRANSACTION_PUB');
5251: debug('l_organization_id = '||l_organization_id,'WMS_SHIPPING_TRANSACTION_PUB');
5252: debug('l_released_status = '||l_released_status,'WMS_SHIPPING_TRANSACTION_PUB');
5253: END IF;
5254:

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

5247: debug('update_wdd_loc_by_lpn 15 - l_delivery_detail_id = '
5248: ||l_delivery_detail_id,'WMS_SHIPPING_TRANSACTION_PUB');
5249: debug('l_oe_order_header_id = '||l_oe_order_header_id,'WMS_SHIPPING_TRANSACTION_PUB');
5250: debug('l_oe_order_line_id = '||l_oe_order_line_id,'WMS_SHIPPING_TRANSACTION_PUB');
5251: debug('l_organization_id = '||l_organization_id,'WMS_SHIPPING_TRANSACTION_PUB');
5252: debug('l_released_status = '||l_released_status,'WMS_SHIPPING_TRANSACTION_PUB');
5253: END IF;
5254:
5255: l_shipping_attr_tab(l_wdd_counter).source_header_id := l_oe_order_header_id;

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

5248: ||l_delivery_detail_id,'WMS_SHIPPING_TRANSACTION_PUB');
5249: debug('l_oe_order_header_id = '||l_oe_order_header_id,'WMS_SHIPPING_TRANSACTION_PUB');
5250: debug('l_oe_order_line_id = '||l_oe_order_line_id,'WMS_SHIPPING_TRANSACTION_PUB');
5251: debug('l_organization_id = '||l_organization_id,'WMS_SHIPPING_TRANSACTION_PUB');
5252: debug('l_released_status = '||l_released_status,'WMS_SHIPPING_TRANSACTION_PUB');
5253: END IF;
5254:
5255: l_shipping_attr_tab(l_wdd_counter).source_header_id := l_oe_order_header_id;
5256: l_shipping_attr_tab(l_wdd_counter).source_line_id := l_oe_order_line_id;

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

5263: l_shipping_attr_tab(l_wdd_counter).transfer_lpn_id := p_lpn_id;
5264:
5265: IF (l_debug = 1) THEN
5266: debug('Disassociate delivery detail with the old lpn, delivery detail id = '
5267: ||l_shipping_attr_tab(l_wdd_counter).delivery_detail_id, 'WMS_SHIPPING_TRANSACTION_PUB');
5268: END IF;
5269:
5270: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Cont
5271: ( P_DETAIL_ID => l_shipping_attr_tab(l_wdd_counter).delivery_detail_id,

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

5271: ( P_DETAIL_ID => l_shipping_attr_tab(l_wdd_counter).delivery_detail_id,
5272: X_RETURN_STATUS => l_return_status );
5273: if (l_return_status <> fnd_api.g_ret_sts_success) then
5274: IF (l_debug = 1) THEN
5275: debug('Error Unassign_Detail_from_Cont'|| l_return_status, 'WMS_SHIPPING_TRANSACTION_PUB');
5276: END IF;
5277: FND_MESSAGE.SET_NAME('INV', 'INV_UNASSIGN_DEL_FAILURE');
5278: FND_MSG_PUB.ADD;
5279: RAISE FND_API.G_EXC_ERROR;

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

5287: CLOSE cur_delivery_details;
5288:
5289:
5290: IF (l_debug = 1) THEN
5291: debug('update_wdd_loc_by_lpn 20 - l_wdd_counter = ' || l_wdd_counter, 'WMS_SHIPPING_TRANSACTION_PUB');
5292: END IF;
5293:
5294: l_progress := '50';
5295:

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

5300: );
5301:
5302: IF (l_debug = 1) THEN
5303: debug('update_wdd_loc_by_lpn 25 - WSH_INTERFACE.Update_Shipping_Attributes returns : '
5304: ||l_return_status, 'WMS_SHIPPING_TRANSACTION_PUB');
5305: END IF;
5306:
5307: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5308: IF (l_debug = 1) THEN

Line 5310: 'WMS_SHIPPING_TRANSACTION_PUB');

5306:
5307: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5308: IF (l_debug = 1) THEN
5309: debug('update_wdd_loc_by_lpn 30 - return expected error from update_shipping_attributes',
5310: 'WMS_SHIPPING_TRANSACTION_PUB');
5311: END IF;
5312:
5313: RAISE FND_API.G_EXC_ERROR;
5314:

Line 5318: 'WMS_SHIPPING_TRANSACTION_PUB');

5314:
5315: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5316: IF (l_debug = 1) THEN
5317: debug('update_wdd_loc_by_lpn 40 - return unexpected error from update_shipping_attributes',
5318: 'WMS_SHIPPING_TRANSACTION_PUB');
5319: END IF;
5320:
5321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5322: END IF;

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

5323:
5324: l_progress := '60';
5325:
5326: IF (l_debug = 1) THEN
5327: debug('update_wdd_loc_by_lpn 50 - complete','WMS_SHIPPING_TRANSACTION_PUB');
5328: END IF;
5329:
5330: EXCEPTION
5331: WHEN fnd_api.g_exc_error THEN

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

5339: FND_MESSAGE.SET_NAME('WMS', 'WMS_UPDATE_WDD_LOC_FAIL');
5340: FND_MSG_PUB.ADD;
5341:
5342: IF (l_debug = 1) THEN
5343: debug('update_wdd_loc_by_lpn 60 - expected error', 'WMS_SHIPPING_TRANSACTION_PUB');
5344: END IF;
5345:
5346: WHEN fnd_api.g_exc_unexpected_error THEN
5347: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

5354: FND_MESSAGE.SET_NAME('WMS', 'WMS_UPDATE_WDD_LOC_FAIL');
5355: FND_MSG_PUB.ADD;
5356:
5357: IF (l_debug = 1) THEN
5358: debug('update_wdd_loc_by_lpn 65 - unexpected error', 'WMS_SHIPPING_TRANSACTION_PUB');
5359: END IF;
5360:
5361: WHEN OTHERS THEN
5362: ROLLBACK TO update_wdd_loc_sp;

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

5365: CLOSE cur_delivery_details;
5366: END IF;
5367:
5368: IF (l_debug = 1) THEN
5369: debug('update_wdd_loc_by_lpn 70 - other error', 'WMS_SHIPPING_TRANSACTION_PUB');
5370: END IF;
5371:
5372: FND_MESSAGE.SET_NAME('WMS', 'WMS_UPDATE_WDD_LOC_FAIL');
5373: FND_MSG_PUB.ADD;

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

5372: FND_MESSAGE.SET_NAME('WMS', 'WMS_UPDATE_WDD_LOC_FAIL');
5373: FND_MSG_PUB.ADD;
5374:
5375: IF SQLCODE IS NOT NULL THEN
5376: inv_mobile_helper_functions.sql_error('WMS_SHIPPING_TRANSACTION_PUB.update_wdd_loc_by_lpn',
5377: l_progress, SQLCODE);
5378: END IF;
5379:
5380: END update_wdd_loc_by_lpn;

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

6621: p_organization_id => p_organization_id,
6622: p_verify_only => 'N');
6623:
6624: IF (l_debug = 1) THEN
6625: debug(' AFTER calling wms_shipping_transaction_pub.ship_confirm_lpn_deliveries()', 'CLOSE_TRUCK');
6626: debug(' l_return_status::' ||l_return_status, 'CLOSE_TRUCK');
6627: debug(' l_msg_data::' ||l_msg_data, 'CLOSE_TRUCK');
6628: END IF;
6629:

Line 6790: END WMS_SHIPPING_TRANSACTION_PUB;

6786: END update_lpn_contents;
6787:
6788:
6789:
6790: END WMS_SHIPPING_TRANSACTION_PUB;