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.WSH_DELIVERY_VALIDATIONS dependencies on WSH_TRIPS

Line 1901: FROM wsh_trips

1897:
1898: CURSOR trip_status IS
1899: SELECT status_code,ship_method_code, planned_flag,
1900: nvl(ignore_for_planning, 'N') ignore_for_planning
1901: FROM wsh_trips
1902: WHERE trip_id = p_trip_id;
1903:
1904: /*
1905: CURSOR org_ship_method (l_organization_id NUMBER,l_ship_method_code VARCHAR2) IS

Line 2293: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

2289: --
2290: -- Debug Statements
2291: --
2292: IF l_debug_on THEN
2293: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2294: END IF;
2295: --
2296: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2297: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2296: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

2292: IF l_debug_on THEN
2293: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2294: END IF;
2295: --
2296: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2297: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2298: wsh_util_core.add_message(x_return_status);
2299:
2300: --

Line 2322: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

2318: --
2319: -- Debug Statements
2320: --
2321: IF l_debug_on THEN
2322: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2323: END IF;
2324: --
2325: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2326: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2325: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

2321: IF l_debug_on THEN
2322: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2323: END IF;
2324: --
2325: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2326: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2327: wsh_util_core.add_message(x_return_status);
2328:
2329: --

Line 2351: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

2347: --
2348: -- Debug Statements
2349: --
2350: IF l_debug_on THEN
2351: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2352: END IF;
2353: --
2354: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2355: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2354: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

2350: IF l_debug_on THEN
2351: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2352: END IF;
2353: --
2354: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2355: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2356: wsh_util_core.add_message(x_return_status);
2357:
2358: --

Line 2374: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

2370: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2371: END IF;
2372: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2373: IF l_debug_on THEN
2374: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2375: END IF;
2376: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2378: wsh_util_core.add_message(x_return_status);

Line 2376: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

2372: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2373: IF l_debug_on THEN
2374: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2375: END IF;
2376: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2377: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2378: wsh_util_core.add_message(x_return_status);
2379: IF l_debug_on THEN
2380: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP_FIRM exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2390: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

2386: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2387: END IF;
2388: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2389: IF l_debug_on THEN
2390: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2391: END IF;
2392: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2393: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2394: wsh_util_core.add_message(x_return_status);

Line 2392: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

2388: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2389: IF l_debug_on THEN
2390: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2391: END IF;
2392: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2393: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2394: wsh_util_core.add_message(x_return_status);
2395: IF l_debug_on THEN
2396: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP_DIFFIGNORE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2440: FROM wsh_trips

2436: WHERE delivery_id = p_delivery_id;
2437:
2438: CURSOR trip_status IS
2439: SELECT status_code
2440: FROM wsh_trips
2441: WHERE trip_id = p_trip_id;
2442:
2443: l_del_status VARCHAR2(2);
2444: l_trip_status VARCHAR2(2);

Line 6436: FROM wsh_trips wt

6432: and wda.delivery_id = p_delivery_id;
6433:
6434: CURSOR c_istripfirm(p_tripid IN NUMBER) IS
6435: SELECT 'Y'
6436: FROM wsh_trips wt
6437: WHERE wt.trip_id=p_tripid
6438: AND wt.planned_flag='F';
6439:
6440: CURSOR c_isvalidtptrip(p_delid IN NUMBER, p_tripid IN NUMBER) IS

Line 6442: FROM wsh_trips wt

6438: AND wt.planned_flag='F';
6439:
6440: CURSOR c_isvalidtptrip(p_delid IN NUMBER, p_tripid IN NUMBER) IS
6441: SELECT 'Y'
6442: FROM wsh_trips wt
6443: WHERE wt.trip_id=p_tripid
6444: AND (nvl(wt.ignore_for_planning,'N') <> (select nvl(ignore_for_planning,'N') from wsh_new_deliveries where delivery_id=p_delid)
6445: );
6446:

Line 7190: FND_MESSAGE.Set_Token('TRIP_NAME',wsh_trips_pvt.get_name(p_tripid));

7186: IF p_caller = 'WSH_PUB' or p_caller like 'FTE%' OR
7187: p_caller = 'WSH_TRCON' THEN
7188: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_FIRMTRIP_ERROR');
7189: FND_MESSAGE.Set_Token('DEL_NAME',wsh_new_deliveries_pvt.get_name(x_error_ids(x_error_ids.count)));
7190: FND_MESSAGE.Set_Token('TRIP_NAME',wsh_trips_pvt.get_name(p_tripid));
7191: wsh_util_core.add_message('E',l_module_name);
7192: END IF;
7193: WHEN e_scpod_wf_inprogress THEN --/== Workflow Changes
7194: x_error_ids(x_error_ids.count +1) := p_dlvy_rec_tab(j).delivery_id;

Line 10856: wsh_trips wt

10852: select wt.name, wnd.name
10853: from wsh_new_deliveries wnd,
10854: wsh_delivery_legs wdl,
10855: wsh_trip_stops wts,
10856: wsh_trips wt
10857: where wnd.delivery_id = p_del_id
10858: and wnd.delivery_id = wdl.delivery_id
10859: and wdl.pick_up_stop_id = wts.stop_id
10860: and wts.stop_location_id = p_pickup_locn_id

Line 10873: wsh_trips wt

10869: select wt.name, wnd.name
10870: from wsh_new_deliveries wnd,
10871: wsh_delivery_legs wdl,
10872: wsh_trip_stops wts,
10873: wsh_trips wt
10874: where wnd.delivery_id = p_del_id
10875: and wnd.delivery_id = wdl.delivery_id
10876: and wdl.drop_off_stop_id = wts.stop_id
10877: and wts.stop_location_id = p_dropoff_locn_id

Line 12954: wsh_trips wt,

12950: wt.name,
12951: wt.status_code
12952: FROM wsh_trip_stops wts,
12953: wsh_delivery_legs wdl,
12954: wsh_trips wt,
12955: wsh_new_deliveries wnd
12956: WHERE wnd.delivery_id = p_del_id
12957: AND wdl.delivery_id = wnd.delivery_id
12958: AND wdl.pick_up_stop_id = wts.stop_id