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 WSH_TRIPS

Line 222: FROM wsh_trips_ob_grp_v wt

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
225: WHERE wt.trip_id = p_trip_id
226: AND wt.trip_id = wts.trip_id

Line 239: l_trip_name wsh_trips.name%TYPE;

235: p_org_id IN NUMBER) IS
236:
237: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
238: l_trip_id NUMBER;
239: l_trip_name wsh_trips.name%TYPE;
240:
241: BEGIN
242: open x_delivery_info for
243: SELECT wnd.delivery_id

Line 282: wsh_trips_ob_grp_v wt

278: SELECT wts.trip_id,wt.name
279: INTO l_trip_id,l_trip_name
280: FROM wsh_delivery_legs_ob_grp_v wdl,
281: wsh_trip_stops_ob_grp_v wts,
282: wsh_trips_ob_grp_v wt
283: WHERE wdl.delivery_id=p_delivery_id
284: AND wdl.pick_up_stop_id=wts.stop_id
285: AND wt.trip_id=wts.trip_id
286: AND ROWNUM=1;

Line 1215: l_otm_trip_id wsh_trips.trip_id%type;

1211: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1212:
1213: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%type;
1214: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;
1215: l_otm_trip_id wsh_trips.trip_id%type;
1216: l_otm_carrier_id wsh_trips.carrier_id%type;
1217: l_otm_ship_method_code wsh_trips.ship_method_code%type;
1218: l_otm_mode wsh_trips.mode_of_transport%type;
1219: l_otm_plan_name wsh_trips.tp_plan_name%type;

Line 1216: l_otm_carrier_id wsh_trips.carrier_id%type;

1212:
1213: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%type;
1214: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;
1215: l_otm_trip_id wsh_trips.trip_id%type;
1216: l_otm_carrier_id wsh_trips.carrier_id%type;
1217: l_otm_ship_method_code wsh_trips.ship_method_code%type;
1218: l_otm_mode wsh_trips.mode_of_transport%type;
1219: l_otm_plan_name wsh_trips.tp_plan_name%type;
1220:

Line 1217: l_otm_ship_method_code wsh_trips.ship_method_code%type;

1213: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%type;
1214: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;
1215: l_otm_trip_id wsh_trips.trip_id%type;
1216: l_otm_carrier_id wsh_trips.carrier_id%type;
1217: l_otm_ship_method_code wsh_trips.ship_method_code%type;
1218: l_otm_mode wsh_trips.mode_of_transport%type;
1219: l_otm_plan_name wsh_trips.tp_plan_name%type;
1220:
1221: l_severity WSH_EXCEPTIONS.SEVERITY%TYPE;

Line 1218: l_otm_mode wsh_trips.mode_of_transport%type;

1214: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;
1215: l_otm_trip_id wsh_trips.trip_id%type;
1216: l_otm_carrier_id wsh_trips.carrier_id%type;
1217: l_otm_ship_method_code wsh_trips.ship_method_code%type;
1218: l_otm_mode wsh_trips.mode_of_transport%type;
1219: l_otm_plan_name wsh_trips.tp_plan_name%type;
1220:
1221: l_severity WSH_EXCEPTIONS.SEVERITY%TYPE;
1222: l_exception_name WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE;

Line 1219: l_otm_plan_name wsh_trips.tp_plan_name%type;

1215: l_otm_trip_id wsh_trips.trip_id%type;
1216: l_otm_carrier_id wsh_trips.carrier_id%type;
1217: l_otm_ship_method_code wsh_trips.ship_method_code%type;
1218: l_otm_mode wsh_trips.mode_of_transport%type;
1219: l_otm_plan_name wsh_trips.tp_plan_name%type;
1220:
1221: l_severity WSH_EXCEPTIONS.SEVERITY%TYPE;
1222: l_exception_name WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE;
1223: l_exception_text WSH_EXCEPTIONS.MESSAGE%TYPE;

Line 1235: from wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt

1231:
1232: CURSOR c_Get_Trip(v_del_id NUMBER) IS
1233: select wt.trip_id , wt.carrier_id, wt.ship_method_code, wt.mode_of_transport,
1234: wt.tp_plan_name -- glog proj
1235: from wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt
1236: where wdl.pick_up_stop_id=wts.stop_id
1237: and wdl.delivery_id=v_del_id
1238: and wts.trip_id=wt.trip_id;
1239:

Line 1730: wsh_trips_ob_grp_v wt

1726: SELECT wts.trip_id,wt.name
1727: INTO l_trip_id,l_trip_name
1728: FROM wsh_delivery_legs_ob_grp_v wdl,
1729: wsh_trip_stops_ob_grp_v wts,
1730: wsh_trips_ob_grp_v wt
1731: WHERE wdl.delivery_id=l_deliveries.delivery_id
1732: AND wdl.pick_up_stop_id=wts.stop_id
1733: AND wt.trip_id=wts.trip_id
1734: AND ROWNUM=1;

Line 1932: ,WSH_TRIPS_OB_GRP_V wt

1928: BEGIN
1929: SELECT wt.trip_id
1930: INTO l_chk_trip_id
1931: FROM WMS_SHIPPING_TRANSACTION_TEMP wstt
1932: ,WSH_TRIPS_OB_GRP_V wt
1933: WHERE
1934: wt.trip_id = wstt.trip_id
1935: AND organization_id = p_organization_id
1936: AND status_code = 'OP'

Line 1975: debug('Return unexpected error from WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP',

1971: l_auto_trip_del(l_auto_trip_index) := l_del_tab(i);
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;

Line 1985: WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP(p_del_rows => l_del_tab,

1981: ELSIF l_del_tab.COUNT >0 THEN
1982: IF (l_debug = 1) THEN
1983: debug('No open trip exists.Hence auto creating trip ','create_trip');
1984: END IF;
1985: WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP(p_del_rows => l_del_tab,
1986: x_trip_id => l_trip_id,
1987: x_trip_name => l_trip_name,
1988: x_return_status => l_return_status);
1989: IF l_return_status IN (fnd_api.g_ret_sts_success) THEN

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 2005: debug('Return unexpected error from WSH_TRIPS_ACTIONS.AUTOCREATE_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
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;

Line 2017: WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP(p_del_rows => l_auto_trip_del,

2013: IF (l_debug = 1) THEN
2014: debug('Assignment of delivery failed.Hence auto creating trip for the failed deliveries ',
2015: 'create_trip');
2016: END IF;
2017: WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP(p_del_rows => l_auto_trip_del,
2018: x_trip_id => l_trip_id,
2019: x_trip_name => l_trip_name,
2020: x_return_status => l_return_status);
2021: IF l_return_status IN (fnd_api.g_ret_sts_success) THEN

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 2096: p_trip_info WSH_TRIPS_PUB.Trip_Pub_Rec_Type;

2092: l_msg_data VARCHAR2(20000);
2093:
2094: l_freight_cost_rec WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
2095: l_stop_info WSH_TRIP_STOPS_PUB.Trip_Stop_Pub_Rec_Type;
2096: p_trip_info WSH_TRIPS_PUB.Trip_Pub_Rec_Type;
2097: l_freight_cost_id NUMBER;
2098: l_stop_id NUMBER;
2099: l_trip_id NUMBER;
2100: l_trip_name VARCHAR2(30);

Line 2127: FROM wsh_trips_ob_grp_v

2123: FOR UPDATE NOWAIT;
2124:
2125: CURSOR trips IS
2126: SELECT 'x'
2127: FROM wsh_trips_ob_grp_v
2128: WHERE trip_id = p_trip_id
2129: FOR UPDATE NOWAIT;
2130:
2131: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 2183: FROM wsh_trips_ob_grp_v

2179: ELSE
2180: BEGIN
2181: SELECT name
2182: INTO l_name
2183: FROM wsh_trips_ob_grp_v
2184: WHERE trip_id=l_trip_id;
2185: EXCEPTION
2186: WHEN no_data_found THEN
2187: RETURN;

Line 2320: WSH_TRIPS_PUB.Create_Update_Trip (

2316: IF (l_debug = 1) THEN
2317: debug('Call to Create_update_Trip','Update_Trip_Stop');
2318: END IF;
2319:
2320: WSH_TRIPS_PUB.Create_Update_Trip (
2321: p_api_version_number => 1.0
2322: ,p_init_msg_list => l_init_msg_list
2323: ,x_return_status => l_return_status
2324: ,x_msg_count => l_msg_count

Line 2666: FROM wms_shipping_transaction_temp wstt, wsh_trips_ob_grp_v wt

2662: AND milk.inventory_location_id = wstt.dock_door_id;
2663:
2664: CURSOR closed_trips IS
2665: SELECT DISTINCT wstt.trip_id
2666: FROM wms_shipping_transaction_temp wstt, wsh_trips_ob_grp_v wt
2667: WHERE wstt.organization_id = p_org_id
2668: AND wstt.dock_door_id = p_dock_door_id
2669: AND wt.trip_id = wstt.trip_id
2670: AND wt.status_code IN('CL', 'IT');

Line 2716: FROM wsh_trips_ob_grp_v

2712: ELSE
2713: BEGIN
2714: SELECT NAME
2715: INTO l_name
2716: FROM wsh_trips_ob_grp_v
2717: WHERE trip_id = p_trip_id;
2718: EXCEPTION
2719: WHEN NO_DATA_FOUND THEN
2720: NULL;

Line 2788: FROM wsh_trips_ob_grp_v

2784:
2785: IF lpn_in_other_dock%FOUND THEN
2786: SELECT NAME
2787: INTO l_trip_name
2788: FROM wsh_trips_ob_grp_v
2789: WHERE trip_id = p_trip_id;
2790:
2791: -- Raise error and set the message to be shown in Mobile
2792: fnd_message.set_name('WMS', 'WMS_CLOSE_TRIP_FAIL');

Line 7617: l_ship_method_code wsh_trips.ship_method_code%TYPE;

7613: l_msg_data VARCHAR2(20000);
7614: l_trip_cursor trip_cursor%ROWTYPE;
7615: l_vehicle_item_id NUMBER; --Bug#6878013
7616: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7617: l_ship_method_code wsh_trips.ship_method_code%TYPE;
7618: l_enforce_ship_method VARCHAR2(1);
7619: l_trip_name wsh_trips.NAME%TYPE;
7620: no_ship_method_code EXCEPTION;
7621:

Line 7619: l_trip_name wsh_trips.NAME%TYPE;

7615: l_vehicle_item_id NUMBER; --Bug#6878013
7616: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
7617: l_ship_method_code wsh_trips.ship_method_code%TYPE;
7618: l_enforce_ship_method VARCHAR2(1);
7619: l_trip_name wsh_trips.NAME%TYPE;
7620: no_ship_method_code EXCEPTION;
7621:
7622: BEGIN
7623: --SAVEPOINT closetruck;

Line 7717: FROM wsh_trips_ob_grp_v

7713: SELECT ship_method_code
7714: , NAME
7715: INTO l_ship_method_code
7716: , l_trip_name
7717: FROM wsh_trips_ob_grp_v
7718: WHERE trip_id = l_trip_cursor.trip_id;
7719: EXCEPTION
7720: WHEN NO_DATA_FOUND THEN
7721: l_ship_method_code := NULL;

Line 7733: FROM wsh_trips_ob_grp_v

7729: /*Bug6878013 If the Vehicle Item Id is not null, pass its value else pass NULL*/
7730: BEGIN
7731: SELECT vehicle_item_id
7732: INTO l_vehicle_item_id
7733: FROM wsh_trips_ob_grp_v
7734: WHERE trip_id = l_trip_cursor.trip_id;
7735: EXCEPTION
7736: WHEN NO_DATA_FOUND THEN
7737: l_vehicle_item_id := NULL;