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 1316: (WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_PAD))

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

Line 2812: wsh_trips wt

2808: wts.departure_gross_weight,
2809: wts.departure_volume,
2810: wts.physical_location_id
2811: FROM wsh_trip_stops wts,
2812: wsh_trips wt
2813: WHERE stop_id = p_stop_id
2814: AND wts.trip_id = wt.trip_id;
2815: --
2816: --

Line 2984: wsh_trips wt

2980: wsh_trip_stops curr_leg_pu_stop,
2981: wsh_delivery_legs prev_leg,
2982: wsh_delivery_legs curr_leg,
2983: wsh_new_deliveries wnd,
2984: wsh_trips wt
2985: WHERE prev_leg.drop_off_stop_id = prev_leg_do_stop.stop_id
2986: --AND st1.status_code = 'OP'
2987: AND prev_leg.pick_up_stop_id = prev_leg_pu_stop.stop_id
2988: AND prev_leg_do_stop.stop_location_id = curr_leg_pu_stop.stop_location_id

Line 3042: wsh_trips wt

3038: wsh_trip_stops curr_leg_pu_stop,
3039: wsh_delivery_legs prev_leg,
3040: wsh_delivery_legs curr_leg,
3041: wsh_new_deliveries wnd,
3042: wsh_trips wt
3043: WHERE prev_leg.drop_off_stop_id = prev_leg_do_stop.stop_id
3044: --AND st1.status_code = 'OP'
3045: AND prev_leg.pick_up_stop_id = prev_leg_pu_stop.stop_id
3046: AND prev_leg_do_stop.stop_location_id = curr_leg_pu_stop.stop_location_id