APPS.WSH_INBOUND_UTIL_PKG dependencies on WSH_TRIPS

Line 1829: FROM wsh_trips wt,

1825: CURSOR trips_csr (p_delivery_id IN NUMBER)
1826: IS
1827: SELECT wt.trip_id, wt.name, wt.lane_id,
1828: NVL(wdl.reprice_Required,'N') reprice_required
1829: FROM wsh_trips wt,
1830: wsh_trip_stops wts,
1831: wsh_delivery_legs wdl
1832: WHERE wdl.delivery_id = p_delivery_id
1833: AND wdl.pick_up_stop_id = wts.stop_id

Line 3032: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_index));

3028: END IF;
3029:
3030: IF (l_stop_count > 0) THEN
3031: FND_MESSAGE.SET_NAME('WSH', 'WSH_IB_TRIP_NOT_CLOSE');
3032: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_index));
3033: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3034:
3035: l_num_warnings := l_num_warnings + 1;
3036: l_stop_count := 0;

Line 3050: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_index));

3046: OPEN stop_csr(l_index);
3047: FETCH stop_csr INTO l_stop_count;
3048: IF (l_stop_count > 0) THEN
3049: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_NOT_CLOSE');
3050: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(l_index));
3051: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3052: l_num_warnings := l_num_warnings + 1;
3053: l_stop_count := 0;
3054: END IF;