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

Line 75: from wsh_trips

71: cursor get_trip_status(c_trip_id in NUMBER) is
72: select status_code, planned_flag,
73: NVL(SHIPMENTS_TYPE_FLAG,'O') SHIPMENTS_TYPE_FLAG, -- J-IB-NPARIKH
74: mode_of_transport
75: from wsh_trips
76: where trip_id = c_trip_id
77: FOR UPDATE NOWAIT;
78:
79: l_plannedflag VARCHAR2(1);

Line 261: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

257:
258: /* H integration for Multi Leg */
259: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
260: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
261: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
262: l_pub_trip_rec WSH_TRIPS_PUB.TRIP_PUB_REC_TYPE;
263: l_return_status VARCHAR2(30);
264:
265: l_pickup_seq NUMBER;

Line 262: l_pub_trip_rec WSH_TRIPS_PUB.TRIP_PUB_REC_TYPE;

258: /* H integration for Multi Leg */
259: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
260: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
261: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
262: l_pub_trip_rec WSH_TRIPS_PUB.TRIP_PUB_REC_TYPE;
263: l_return_status VARCHAR2(30);
264:
265: l_pickup_seq NUMBER;
266: l_dropoff_seq NUMBER;

Line 366: l_stop_seq_mode := WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE;

362: WSH_DEBUG_SV.log(l_module_name,'p_sc_pickup_date',p_sc_pickup_date);
363: WSH_DEBUG_SV.log(l_module_name,'p_sc_dropoff_date',p_sc_dropoff_date);
364: END IF;
365: --
366: l_stop_seq_mode := WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE;
367: --
368: open get_trip_status(p_trip_id);
369: fetch get_trip_status into l_trip_status, l_plannedflag, l_trip_shipments_type_flag, l_trip_mode_of_transport;
370: close get_trip_status;

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

511: <>
512:
513: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_ERROR');
514: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_name);
515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
516: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
517: l_num_error := l_num_error + 1;
518:
519: <>

Line 970: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);

966: FETCH c_check_dummystops INTO l_check_dummystops;
967: IF c_check_dummystops%NOTFOUND THEN
968: CLOSE c_check_dummystops;
969: IF l_debug_on THEN
970: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
971: END IF;
972: FND_MESSAGE.SET_NAME('WSH','WSH_FIRMTRIP_NO_NEW_STOP');
973: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
974: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);

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

969: IF l_debug_on THEN
970: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
971: END IF;
972: FND_MESSAGE.SET_NAME('WSH','WSH_FIRMTRIP_NO_NEW_STOP');
973: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
974: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
975: RAISE e_InvalidDelExcep; -- Bug 5336308
976: END IF;
977: CLOSE c_check_dummystops;

Line 1138: WSH_TRIPS_ACTIONS.Handle_Internal_Stops

1134: -- End of Code for DBI Project
1135: --
1136: IF p_caller like '%ASSIGNTRIP%' THEN
1137: l_trip_ids(1):=p_trip_id;
1138: WSH_TRIPS_ACTIONS.Handle_Internal_Stops
1139: ( p_trip_ids => l_trip_ids,
1140: p_caller => p_caller,
1141: x_success_trip_ids => l_dummy_trip_ids,
1142: x_return_status => l_return_status);

Line 1263: l_trip_stop_info.planned_arrival_date := greatest(NVL(l_pickup_date, sysdate) + WSH_TRIPS_ACTIONS.C_TEN_MINUTES, NVL(l_dropoff_date, sysdate));

1259: --l_trip_stop_info.stop_sequence_number := -99;
1260: l_trip_stop_info.stop_sequence_number := l_dropoff_stop_seq;
1261: l_trip_stop_info.stop_location_id := l_dropoff_location_id;
1262: IF l_pregen_seq = 'N' THEN
1263: l_trip_stop_info.planned_arrival_date := greatest(NVL(l_pickup_date, sysdate) + WSH_TRIPS_ACTIONS.C_TEN_MINUTES, NVL(l_dropoff_date, sysdate));
1264: ELSE
1265: l_trip_stop_info.planned_arrival_date := l_tmp_date;
1266: END IF;
1267: -- bug 3349133, the planned arrival date of pickup stop and dropoff stop is 10 minutes apart

Line 1392: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);

1388: FETCH c_check_dummystops INTO l_check_dummystops;
1389: IF c_check_dummystops%NOTFOUND THEN
1390: CLOSE c_check_dummystops;
1391: IF l_debug_on THEN
1392: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
1393: END IF;
1394: FND_MESSAGE.SET_NAME('WSH','WSH_FIRMTRIP_NO_NEW_STOP');
1395: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
1396: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);

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

1391: IF l_debug_on THEN
1392: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
1393: END IF;
1394: FND_MESSAGE.SET_NAME('WSH','WSH_FIRMTRIP_NO_NEW_STOP');
1395: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
1396: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
1397: RAISE e_InvalidDelExcep; -- Bug 5336308
1398: END IF;
1399: CLOSE c_check_dummystops;

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

1974: END IF;
1975: --
1976: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_rows(i)));
1977: -- Bug 3439165
1978: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
1979: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
1980: l_num_error := l_num_error + 1;
1981: --
1982: WHEN e_CommonExcep THEN

Line 1992: WSH_TRIPS_ACTIONS.Handle_Internal_Stops

1988: END LOOP;
1989:
1990: IF p_caller like '%ASSIGNTRIP%' THEN
1991: l_trip_ids(1):=p_trip_id;
1992: WSH_TRIPS_ACTIONS.Handle_Internal_Stops
1993: ( p_trip_ids => l_trip_ids,
1994: p_caller => p_caller,
1995: x_success_trip_ids => l_dummy_trip_ids,
1996: x_return_status => l_return_status);

Line 2231: UPDATE WSH_TRIPS

2227: --
2228: --IF l_has_mixed_deliveries = 'Y'
2229: IF l_trip_shipments_type_flag_new <> l_trip_shipments_type_flag
2230: THEN
2231: UPDATE WSH_TRIPS
2232: SET shipments_type_flag = l_trip_shipments_type_flag_new, -- 'M',
2233: last_update_date = SYSDATE,
2234: last_updated_by = FND_GLOBAL.USER_ID,
2235: last_update_login = FND_GLOBAL.LOGIN_ID

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

2342:
2343: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_SUMMARY');
2344: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
2345: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_del_rows.count-l_num_error);
2346: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2347:
2348: IF (l_num_error = p_del_rows.count) THEN
2349: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2350: ELSE

Line 3018: wsh_trips wt

3014: SELECT 'Y'
3015: INTO l_del_for_update_load_seq
3016: FROM wsh_delivery_legs wdl,
3017: wsh_trip_stops wts,
3018: wsh_trips wt
3019: WHERE wdl.delivery_id = p_del_rows(i)
3020: AND wdl.drop_off_stop_id = wts.stop_id
3021: AND wts.trip_id = wt.trip_id
3022: AND wt.ignore_for_planning = 'N'

Line 3271: WSH_TRIPS_ACTIONS.Fte_Load_Tender(

3267: END IF;
3268: IF l_trip_empty THEN
3269:
3270: FOR rec IN c_trip_stops(p_trip_id) LOOP
3271: WSH_TRIPS_ACTIONS.Fte_Load_Tender(
3272: p_stop_id => rec.stop_id,
3273: p_gross_weight => null,
3274: p_net_weight => null,
3275: p_volume => null,

Line 3594: wsh_trips trip,

3590: SELECT dlg.delivery_leg_id, trip.trip_id, trip.consolidation_allowed,
3591: trip.lane_id, trip.mode_of_transport
3592: FROM wsh_delivery_legs dlg,
3593: wsh_delivery_assignments_v da,
3594: wsh_trips trip,
3595: wsh_trip_stops st
3596: WHERE da.delivery_detail_id = c_delivery_detail_id AND
3597: da.delivery_id = dlg.delivery_id AND
3598: dlg.pick_up_stop_id = st.stop_id AND

Line 3606: wsh_trips trip

3602: SELECT dlg.delivery_leg_id, trip.trip_id, trip.consolidation_allowed,
3603: trip.lane_id, trip.mode_of_transport
3604: FROM wsh_delivery_legs dlg,
3605: wsh_trip_stops stop,
3606: wsh_trips trip
3607: WHERE dlg.delivery_id = c_delivery_id and
3608: dlg.pick_up_stop_id = stop.stop_id and
3609: stop.trip_id = trip.trip_id;
3610:

Line 3616: wsh_trips trip

3612: SELECT dlg.delivery_leg_id, trip.trip_id, trip.consolidation_allowed,
3613: trip.lane_id, trip.mode_of_transport
3614: FROM wsh_delivery_legs dlg,
3615: wsh_trip_stops stop,
3616: wsh_trips trip
3617: WHERE dlg.delivery_leg_id = c_leg_id AND
3618: dlg.pick_up_stop_id = stop.stop_id AND
3619: stop.trip_id = trip.trip_id;
3620:

Line 3626: wsh_trips trip,

3622: cursor get_trip_from_stop(c_stop_id NUMBER) is
3623: SELECT dlg.delivery_leg_id, trip.trip_id, trip.consolidation_allowed,
3624: trip.lane_id, trip.mode_of_transport
3625: FROM wsh_trip_stops stop,
3626: wsh_trips trip,
3627: wsh_delivery_legs dlg,
3628: wsh_trip_stops ts
3629: WHERE stop.stop_id = c_stop_id AND
3630: stop.trip_id = trip.trip_id AND

Line 3639: wsh_trips trip

3635: SELECT dlg.delivery_leg_id, trip.trip_id, trip.consolidation_allowed,
3636: trip.lane_id, trip.mode_of_transport
3637: FROM wsh_trip_stops ts,
3638: wsh_delivery_legs dlg,
3639: wsh_trips trip
3640: WHERE ts.trip_id = c_trip_id AND
3641: dlg.pick_up_stop_id = ts.stop_id AND
3642: ts.trip_id = trip.trip_id;
3643:

Line 3674: FROM wsh_trips

3670: -- Bug 4451383
3671: cursor get_trip_details ( c_trip_id NUMBER) is
3672: SELECT mode_of_transport, lane_id
3673: --SELECT consolidation_allowed, lane_id
3674: FROM wsh_trips
3675: WHERE trip_id = c_trip_id;
3676:
3677: l_lock_delivery_leg_rec c_lock_delivery_leg%ROWTYPE;
3678:

Line 3695: l_consolidation_allowed wsh_trips.consolidation_allowed%type;

3691: l_at_least_one_leg_priced BOOLEAN;
3692: l_price NUMBER := 0;
3693:
3694: -- Bug 4451383
3695: l_consolidation_allowed wsh_trips.consolidation_allowed%type;
3696: l_mode_of_transport wsh_trips.mode_of_transport%type;
3697: l_lane_id wsh_trips.lane_id%type;
3698:
3699: delivery_leg_locked exception ;

Line 3696: l_mode_of_transport wsh_trips.mode_of_transport%type;

3692: l_price NUMBER := 0;
3693:
3694: -- Bug 4451383
3695: l_consolidation_allowed wsh_trips.consolidation_allowed%type;
3696: l_mode_of_transport wsh_trips.mode_of_transport%type;
3697: l_lane_id wsh_trips.lane_id%type;
3698:
3699: delivery_leg_locked exception ;
3700: -- PRAGMA EXCEPTION_INIT(delivery_leg_locked, -54);

Line 3697: l_lane_id wsh_trips.lane_id%type;

3693:
3694: -- Bug 4451383
3695: l_consolidation_allowed wsh_trips.consolidation_allowed%type;
3696: l_mode_of_transport wsh_trips.mode_of_transport%type;
3697: l_lane_id wsh_trips.lane_id%type;
3698:
3699: delivery_leg_locked exception ;
3700: -- PRAGMA EXCEPTION_INIT(delivery_leg_locked, -54);
3701: