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 181: FROM wsh_trips_ob_grp_v wt

177: ,wts.departure_seal_code
178: ,WMS_DIRECT_SHIP_PVT.GET_ENFORCE_SHIP
179: ,WMS_DIRECT_SHIP_PVT.GET_SHIPMETHOD_MEANING(wt.ship_method_code)
180: ,wt.ship_method_code
181: FROM wsh_trips_ob_grp_v wt
182: ,wsh_trip_stops_ob_grp_v wts
183: ,mtl_system_items_kfv msi
184: WHERE wt.trip_id = p_trip_id
185: AND wt.trip_id = wts.trip_id

Line 198: l_trip_name wsh_trips.name%TYPE;

194: p_org_id IN NUMBER) IS
195:
196: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
197: l_trip_id NUMBER;
198: l_trip_name wsh_trips.name%TYPE;
199:
200: BEGIN
201: open x_delivery_info for
202: SELECT wnd.delivery_id

Line 240: wsh_trips_ob_grp_v wt

236: SELECT wts.trip_id,wt.name
237: INTO l_trip_id,l_trip_name
238: FROM wsh_delivery_legs_ob_grp_v wdl,
239: wsh_trip_stops_ob_grp_v wts,
240: wsh_trips_ob_grp_v wt
241: WHERE wdl.delivery_id=p_delivery_id
242: AND wdl.pick_up_stop_id=wts.stop_id
243: AND wt.trip_id=wts.trip_id
244: AND ROWNUM=1;

Line 1132: l_otm_trip_id wsh_trips.trip_id%type;

1128: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1129:
1130: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%type;
1131: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;
1132: l_otm_trip_id wsh_trips.trip_id%type;
1133: l_otm_carrier_id wsh_trips.carrier_id%type;
1134: l_otm_ship_method_code wsh_trips.ship_method_code%type;
1135: l_otm_mode wsh_trips.mode_of_transport%type;
1136: l_otm_plan_name wsh_trips.tp_plan_name%type;

Line 1133: l_otm_carrier_id wsh_trips.carrier_id%type;

1129:
1130: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%type;
1131: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;
1132: l_otm_trip_id wsh_trips.trip_id%type;
1133: l_otm_carrier_id wsh_trips.carrier_id%type;
1134: l_otm_ship_method_code wsh_trips.ship_method_code%type;
1135: l_otm_mode wsh_trips.mode_of_transport%type;
1136: l_otm_plan_name wsh_trips.tp_plan_name%type;
1137:

Line 1134: l_otm_ship_method_code wsh_trips.ship_method_code%type;

1130: l_ignore_for_planning wsh_delivery_details.ignore_for_planning%type;
1131: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;
1132: l_otm_trip_id wsh_trips.trip_id%type;
1133: l_otm_carrier_id wsh_trips.carrier_id%type;
1134: l_otm_ship_method_code wsh_trips.ship_method_code%type;
1135: l_otm_mode wsh_trips.mode_of_transport%type;
1136: l_otm_plan_name wsh_trips.tp_plan_name%type;
1137:
1138: l_severity WSH_EXCEPTIONS.SEVERITY%TYPE;

Line 1135: l_otm_mode wsh_trips.mode_of_transport%type;

1131: l_tms_interface_flag wsh_new_deliveries.TMS_INTERFACE_FLAG%type;
1132: l_otm_trip_id wsh_trips.trip_id%type;
1133: l_otm_carrier_id wsh_trips.carrier_id%type;
1134: l_otm_ship_method_code wsh_trips.ship_method_code%type;
1135: l_otm_mode wsh_trips.mode_of_transport%type;
1136: l_otm_plan_name wsh_trips.tp_plan_name%type;
1137:
1138: l_severity WSH_EXCEPTIONS.SEVERITY%TYPE;
1139: l_exception_name WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE;

Line 1136: l_otm_plan_name wsh_trips.tp_plan_name%type;

1132: l_otm_trip_id wsh_trips.trip_id%type;
1133: l_otm_carrier_id wsh_trips.carrier_id%type;
1134: l_otm_ship_method_code wsh_trips.ship_method_code%type;
1135: l_otm_mode wsh_trips.mode_of_transport%type;
1136: l_otm_plan_name wsh_trips.tp_plan_name%type;
1137:
1138: l_severity WSH_EXCEPTIONS.SEVERITY%TYPE;
1139: l_exception_name WSH_EXCEPTIONS.EXCEPTION_NAME%TYPE;
1140: l_exception_text WSH_EXCEPTIONS.MESSAGE%TYPE;

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

1147:
1148: CURSOR c_Get_Trip(v_del_id NUMBER) IS
1149: select wt.trip_id , wt.carrier_id, wt.ship_method_code, wt.mode_of_transport,
1150: wt.tp_plan_name -- glog proj
1151: from wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt
1152: where wdl.pick_up_stop_id=wts.stop_id
1153: and wdl.delivery_id=v_del_id
1154: and wts.trip_id=wt.trip_id;
1155:

Line 1635: wsh_trips_ob_grp_v wt

1631: SELECT wts.trip_id,wt.name
1632: INTO l_trip_id,l_trip_name
1633: FROM wsh_delivery_legs_ob_grp_v wdl,
1634: wsh_trip_stops_ob_grp_v wts,
1635: wsh_trips_ob_grp_v wt
1636: WHERE wdl.delivery_id=l_deliveries.delivery_id
1637: AND wdl.pick_up_stop_id=wts.stop_id
1638: AND wt.trip_id=wts.trip_id
1639: AND ROWNUM=1;

Line 1837: ,WSH_TRIPS_OB_GRP_V wt

1833: BEGIN
1834: SELECT wt.trip_id
1835: INTO l_chk_trip_id
1836: FROM WMS_SHIPPING_TRANSACTION_TEMP wstt
1837: ,WSH_TRIPS_OB_GRP_V wt
1838: WHERE
1839: wt.trip_id = wstt.trip_id
1840: AND organization_id = p_organization_id
1841: AND status_code = 'OP'

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

1875: l_auto_trip_del(l_auto_trip_index) := l_del_tab(i);
1876: l_auto_trip_index := l_auto_trip_index +1;
1877: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1878: IF (l_debug = 1) THEN
1879: debug('Return unexpected error from WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP',
1880: 'WMS_DIRECT_SHIP_PVT.Create_Trip');
1881: END IF;
1882: RAISE fnd_api.g_exc_unexpected_error;
1883: END IF;

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

1885: ELSIF l_del_tab.COUNT >0 THEN
1886: IF (l_debug = 1) THEN
1887: debug('No open trip exists.Hence auto creating trip ','create_trip');
1888: END IF;
1889: WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP(p_del_rows => l_del_tab,
1890: x_trip_id => l_trip_id,
1891: x_trip_name => l_trip_name,
1892: x_return_status => l_return_status);
1893: IF l_return_status IN (fnd_api.g_ret_sts_success) THEN

Line 1904: debug('Return error from WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP','WMS_DIRECT_SHIP_PVT.Create_Trip');

1900: WHERE delivery_id = l_del_tab(k);
1901: END LOOP;
1902: ELSIF l_return_status IN (fnd_api.g_ret_sts_error) THEN
1903: IF (l_debug = 1) THEN
1904: debug('Return error from WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP','WMS_DIRECT_SHIP_PVT.Create_Trip');
1905: END IF;
1906: RAISE fnd_api.g_exc_error;
1907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1908: IF (l_debug = 1) THEN

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

1905: END IF;
1906: RAISE fnd_api.g_exc_error;
1907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1908: IF (l_debug = 1) THEN
1909: debug('Return unexpected error from WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP',
1910: 'WMS_DIRECT_SHIP_PVT.Create_Trip');
1911: END IF;
1912: RAISE fnd_api.g_exc_unexpected_error;
1913: END IF;

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

1917: IF (l_debug = 1) THEN
1918: debug('Assignment of delivery failed.Hence auto creating trip for the failed deliveries ',
1919: 'create_trip');
1920: END IF;
1921: WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP(p_del_rows => l_auto_trip_del,
1922: x_trip_id => l_trip_id,
1923: x_trip_name => l_trip_name,
1924: x_return_status => l_return_status);
1925: IF l_return_status IN (fnd_api.g_ret_sts_success) THEN

Line 1938: debug('The API WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP returned status E ','WMS_DIRECT_SHIP_PVT.Create_Trip');

1934: END LOOP;
1935:
1936: ELSIF l_return_status IN (fnd_api.g_ret_sts_error) THEN
1937: IF (l_debug = 1) THEN
1938: debug('The API WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP returned status E ','WMS_DIRECT_SHIP_PVT.Create_Trip');
1939: END IF;
1940: RAISE fnd_api.g_exc_error;
1941: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1942: IF (l_debug = 1) THEN

Line 1943: debug('The API WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP returned status U ','WMS_DIRECT_SHIP_PVT.Create_Trip');

1939: END IF;
1940: RAISE fnd_api.g_exc_error;
1941: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1942: IF (l_debug = 1) THEN
1943: debug('The API WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP returned status U ','WMS_DIRECT_SHIP_PVT.Create_Trip');
1944: END IF;
1945: RAISE fnd_api.g_exc_unexpected_error;
1946: END IF;
1947: END IF;

Line 2000: p_trip_info WSH_TRIPS_PUB.Trip_Pub_Rec_Type;

1996: l_msg_data VARCHAR2(20000);
1997:
1998: l_freight_cost_rec WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType;
1999: l_stop_info WSH_TRIP_STOPS_PUB.Trip_Stop_Pub_Rec_Type;
2000: p_trip_info WSH_TRIPS_PUB.Trip_Pub_Rec_Type;
2001: l_freight_cost_id NUMBER;
2002: l_stop_id NUMBER;
2003: l_trip_id NUMBER;
2004: l_trip_name VARCHAR2(30);

Line 2031: FROM wsh_trips_ob_grp_v

2027: FOR UPDATE NOWAIT;
2028:
2029: CURSOR trips IS
2030: SELECT 'x'
2031: FROM wsh_trips_ob_grp_v
2032: WHERE trip_id = p_trip_id
2033: FOR UPDATE NOWAIT;
2034:
2035: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 2087: FROM wsh_trips_ob_grp_v

2083: ELSE
2084: BEGIN
2085: SELECT name
2086: INTO l_name
2087: FROM wsh_trips_ob_grp_v
2088: WHERE trip_id=l_trip_id;
2089: EXCEPTION
2090: WHEN no_data_found THEN
2091: RETURN;

Line 2224: WSH_TRIPS_PUB.Create_Update_Trip (

2220: IF (l_debug = 1) THEN
2221: debug('Call to Create_update_Trip','Update_Trip_Stop');
2222: END IF;
2223:
2224: WSH_TRIPS_PUB.Create_Update_Trip (
2225: p_api_version_number => 1.0
2226: ,p_init_msg_list => l_init_msg_list
2227: ,x_return_status => l_return_status
2228: ,x_msg_count => l_msg_count

Line 2564: FROM wms_shipping_transaction_temp wstt, wsh_trips_ob_grp_v wt

2560: AND milk.inventory_location_id = wstt.dock_door_id;
2561:
2562: CURSOR closed_trips IS
2563: SELECT DISTINCT wstt.trip_id
2564: FROM wms_shipping_transaction_temp wstt, wsh_trips_ob_grp_v wt
2565: WHERE wstt.organization_id = p_org_id
2566: AND wstt.dock_door_id = p_dock_door_id
2567: AND wt.trip_id = wstt.trip_id
2568: AND wt.status_code IN('CL', 'IT');

Line 2614: FROM wsh_trips_ob_grp_v

2610: ELSE
2611: BEGIN
2612: SELECT NAME
2613: INTO l_name
2614: FROM wsh_trips_ob_grp_v
2615: WHERE trip_id = p_trip_id;
2616: EXCEPTION
2617: WHEN NO_DATA_FOUND THEN
2618: NULL;

Line 2686: FROM wsh_trips_ob_grp_v

2682:
2683: IF lpn_in_other_dock%FOUND THEN
2684: SELECT NAME
2685: INTO l_trip_name
2686: FROM wsh_trips_ob_grp_v
2687: WHERE trip_id = p_trip_id;
2688:
2689: -- Raise error and set the message to be shown in Mobile
2690: fnd_message.set_name('WMS', 'WMS_CLOSE_TRIP_FAIL');

Line 6510: l_ship_method_code wsh_trips.ship_method_code%TYPE;

6506: l_msg_data VARCHAR2(20000);
6507: l_trip_cursor trip_cursor%ROWTYPE;
6508: l_vehicle_item_id NUMBER; --Bug#6878013
6509: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6510: l_ship_method_code wsh_trips.ship_method_code%TYPE;
6511: l_enforce_ship_method VARCHAR2(1);
6512: l_trip_name wsh_trips.NAME%TYPE;
6513: no_ship_method_code EXCEPTION;
6514:

Line 6512: l_trip_name wsh_trips.NAME%TYPE;

6508: l_vehicle_item_id NUMBER; --Bug#6878013
6509: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
6510: l_ship_method_code wsh_trips.ship_method_code%TYPE;
6511: l_enforce_ship_method VARCHAR2(1);
6512: l_trip_name wsh_trips.NAME%TYPE;
6513: no_ship_method_code EXCEPTION;
6514:
6515: BEGIN
6516: --SAVEPOINT closetruck;

Line 6610: FROM wsh_trips_ob_grp_v

6606: SELECT ship_method_code
6607: , NAME
6608: INTO l_ship_method_code
6609: , l_trip_name
6610: FROM wsh_trips_ob_grp_v
6611: WHERE trip_id = l_trip_cursor.trip_id;
6612: EXCEPTION
6613: WHEN NO_DATA_FOUND THEN
6614: l_ship_method_code := NULL;

Line 6626: FROM wsh_trips_ob_grp_v

6622: /*Bug6878013 If the Vehicle Item Id is not null, pass its value else pass NULL*/
6623: BEGIN
6624: SELECT vehicle_item_id
6625: INTO l_vehicle_item_id
6626: FROM wsh_trips_ob_grp_v
6627: WHERE trip_id = l_trip_cursor.trip_id;
6628: EXCEPTION
6629: WHEN NO_DATA_FOUND THEN
6630: l_vehicle_item_id := NULL;