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_TRIP_STOPS_VALIDATIONS dependencies on WSH_TRIPS

Line 35: FROM wsh_trips

31: IS
32:
33: CURSOR c_lock_trip IS
34: SELECT trip_id
35: FROM wsh_trips
36: WHERE trip_id = p_trip_id
37: FOR UPDATE NOWAIT;
38:
39:

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

637: --
638: -- Debug Statements
639: --
640: IF l_debug_on THEN
641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
642: END IF;
643: --
644: FND_MESSAGE.SET_TOKEN('TRIP_NAME',
645: WSH_TRIPS_PVT.get_name(p_trip_id));

Line 645: WSH_TRIPS_PVT.get_name(p_trip_id));

641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
642: END IF;
643: --
644: FND_MESSAGE.SET_TOKEN('TRIP_NAME',
645: WSH_TRIPS_PVT.get_name(p_trip_id));
646: l_num_warn := l_num_warn + 1;
647: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
648: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
649:

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

672: --
673: -- Debug Statements
674: --
675: IF l_debug_on THEN
676: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
677: END IF;
678: --
679: FND_MESSAGE.SET_TOKEN('TRIP_NAME',
680: WSH_TRIPS_PVT.get_name(p_trip_id));

Line 680: WSH_TRIPS_PVT.get_name(p_trip_id));

676: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
677: END IF;
678: --
679: FND_MESSAGE.SET_TOKEN('TRIP_NAME',
680: WSH_TRIPS_PVT.get_name(p_trip_id));
681: l_num_warn := l_num_warn + 1;
682: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
683: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
684:

Line 696: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.UNASSIGN_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);

692: --
693: -- Debug Statements
694: --
695: IF l_debug_on THEN
696: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.UNASSIGN_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
697: END IF;
698: --
699: WSH_TRIPS_ACTIONS.unassign_trip
700: (p_del_rows => l_del_to_unassign,

Line 699: WSH_TRIPS_ACTIONS.unassign_trip

695: IF l_debug_on THEN
696: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.UNASSIGN_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
697: END IF;
698: --
699: WSH_TRIPS_ACTIONS.unassign_trip
700: (p_del_rows => l_del_to_unassign,
701: p_trip_id => p_trip_id,
702: x_return_status => l_return_status);
703: END IF;

Line 1320: (WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD))

1316: -- SSN change
1317: -- For mode=PAD, Stop_sequence_number would be null when user tries to create a stop
1318: IF ((p_in_rec.action_code = 'CREATE')
1319: AND
1320: (WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD))
1321: THEN
1322: -- csun stop sequence enhancement for 11.5.10, the stop sequence number for a
1323: -- trip stop is set to -99 initially since it is a required filed in the table,
1324: -- it will be re-sequenced in WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP right after

Line 2816: wsh_trips wt

2812: wts.departure_gross_weight,
2813: wts.departure_volume,
2814: wts.physical_location_id
2815: FROM wsh_trip_stops wts,
2816: wsh_trips wt
2817: WHERE stop_id = p_stop_id
2818: AND wts.trip_id = wt.trip_id;
2819: --
2820: --

Line 2988: wsh_trips wt

2984: wsh_trip_stops curr_leg_pu_stop,
2985: wsh_delivery_legs prev_leg,
2986: wsh_delivery_legs curr_leg,
2987: wsh_new_deliveries wnd,
2988: wsh_trips wt
2989: WHERE prev_leg.drop_off_stop_id = prev_leg_do_stop.stop_id
2990: --AND st1.status_code = 'OP'
2991: AND prev_leg.pick_up_stop_id = prev_leg_pu_stop.stop_id
2992: AND prev_leg_do_stop.stop_location_id = curr_leg_pu_stop.stop_location_id

Line 3046: wsh_trips wt

3042: wsh_trip_stops curr_leg_pu_stop,
3043: wsh_delivery_legs prev_leg,
3044: wsh_delivery_legs curr_leg,
3045: wsh_new_deliveries wnd,
3046: wsh_trips wt
3047: WHERE prev_leg.drop_off_stop_id = prev_leg_do_stop.stop_id
3048: --AND st1.status_code = 'OP'
3049: AND prev_leg.pick_up_stop_id = prev_leg_pu_stop.stop_id
3050: AND prev_leg_do_stop.stop_location_id = curr_leg_pu_stop.stop_location_id