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 1861: FROM wsh_trips

1857:
1858: CURSOR trip_status IS
1859: SELECT status_code,ship_method_code, planned_flag,
1860: nvl(ignore_for_planning, 'N') ignore_for_planning
1861: FROM wsh_trips
1862: WHERE trip_id = p_trip_id;
1863:
1864: /*
1865: CURSOR org_ship_method (l_organization_id NUMBER,l_ship_method_code VARCHAR2) IS

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

2249: --
2250: -- Debug Statements
2251: --
2252: IF l_debug_on THEN
2253: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2254: END IF;
2255: --
2256: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2257: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

2252: IF l_debug_on THEN
2253: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2254: END IF;
2255: --
2256: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2257: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2258: wsh_util_core.add_message(x_return_status);
2259:
2260: --

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

2278: --
2279: -- Debug Statements
2280: --
2281: IF l_debug_on THEN
2282: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2283: END IF;
2284: --
2285: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2286: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

2281: IF l_debug_on THEN
2282: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2283: END IF;
2284: --
2285: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2286: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2287: wsh_util_core.add_message(x_return_status);
2288:
2289: --

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

2307: --
2308: -- Debug Statements
2309: --
2310: IF l_debug_on THEN
2311: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2312: END IF;
2313: --
2314: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2315: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

2310: IF l_debug_on THEN
2311: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2312: END IF;
2313: --
2314: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2315: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2316: wsh_util_core.add_message(x_return_status);
2317:
2318: --

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

2330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2331: END IF;
2332: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2333: IF l_debug_on THEN
2334: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2335: END IF;
2336: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2337: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2338: wsh_util_core.add_message(x_return_status);

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

2332: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2333: IF l_debug_on THEN
2334: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2335: END IF;
2336: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2337: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2338: wsh_util_core.add_message(x_return_status);
2339: IF l_debug_on THEN
2340: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP_FIRM exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

2346: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2347: END IF;
2348: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2349: IF l_debug_on THEN
2350: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2351: END IF;
2352: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2353: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2354: wsh_util_core.add_message(x_return_status);

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

2348: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_id));
2349: IF l_debug_on THEN
2350: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2351: END IF;
2352: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2353: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2354: wsh_util_core.add_message(x_return_status);
2355: IF l_debug_on THEN
2356: WSH_DEBUG_SV.logmsg(l_module_name,'TRIP_DIFFIGNORE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2400: FROM wsh_trips

2396: WHERE delivery_id = p_delivery_id;
2397:
2398: CURSOR trip_status IS
2399: SELECT status_code
2400: FROM wsh_trips
2401: WHERE trip_id = p_trip_id;
2402:
2403: l_del_status VARCHAR2(2);
2404: l_trip_status VARCHAR2(2);

Line 6277: FROM wsh_trips wt

6273: and wda.delivery_id = p_delivery_id;
6274:
6275: CURSOR c_istripfirm(p_tripid IN NUMBER) IS
6276: SELECT 'Y'
6277: FROM wsh_trips wt
6278: WHERE wt.trip_id=p_tripid
6279: AND wt.planned_flag='F';
6280:
6281: CURSOR c_isvalidtptrip(p_delid IN NUMBER, p_tripid IN NUMBER) IS

Line 6283: FROM wsh_trips wt

6279: AND wt.planned_flag='F';
6280:
6281: CURSOR c_isvalidtptrip(p_delid IN NUMBER, p_tripid IN NUMBER) IS
6282: SELECT 'Y'
6283: FROM wsh_trips wt
6284: WHERE wt.trip_id=p_tripid
6285: AND (nvl(wt.ignore_for_planning,'N') <> (select nvl(ignore_for_planning,'N') from wsh_new_deliveries where delivery_id=p_delid)
6286: );
6287:

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

6986: IF p_caller = 'WSH_PUB' or p_caller like 'FTE%' OR
6987: p_caller = 'WSH_TRCON' THEN
6988: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_FIRMTRIP_ERROR');
6989: FND_MESSAGE.Set_Token('DEL_NAME',wsh_new_deliveries_pvt.get_name(x_error_ids(x_error_ids.count)));
6990: FND_MESSAGE.Set_Token('TRIP_NAME',wsh_trips_pvt.get_name(p_tripid));
6991: wsh_util_core.add_message('E',l_module_name);
6992: END IF;
6993: WHEN e_scpod_wf_inprogress THEN --/== Workflow Changes
6994: x_error_ids(x_error_ids.count +1) := p_dlvy_rec_tab(j).delivery_id;

Line 10584: wsh_trips wt

10580: select wt.name, wnd.name
10581: from wsh_new_deliveries wnd,
10582: wsh_delivery_legs wdl,
10583: wsh_trip_stops wts,
10584: wsh_trips wt
10585: where wnd.delivery_id = p_del_id
10586: and wnd.delivery_id = wdl.delivery_id
10587: and wdl.pick_up_stop_id = wts.stop_id
10588: and wts.stop_location_id = p_pickup_locn_id

Line 10601: wsh_trips wt

10597: select wt.name, wnd.name
10598: from wsh_new_deliveries wnd,
10599: wsh_delivery_legs wdl,
10600: wsh_trip_stops wts,
10601: wsh_trips wt
10602: where wnd.delivery_id = p_del_id
10603: and wnd.delivery_id = wdl.delivery_id
10604: and wdl.drop_off_stop_id = wts.stop_id
10605: and wts.stop_location_id = p_dropoff_locn_id

Line 12675: wsh_trips wt,

12671: wt.name,
12672: wt.status_code
12673: FROM wsh_trip_stops wts,
12674: wsh_delivery_legs wdl,
12675: wsh_trips wt,
12676: wsh_new_deliveries wnd
12677: WHERE wnd.delivery_id = p_del_id
12678: AND wdl.delivery_id = wnd.delivery_id
12679: AND wdl.pick_up_stop_id = wts.stop_id