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_PVT dependencies on WSH_TRIP_STOPS

Line 512: wsh_trip_stops wts1,

508: nvl(shipment_direction,'O') shipment_direction,
509: wt.name trip_name,
510: wdl.delivery_id --J-IB-HEALI
511: FROM wsh_delivery_legs wdl,
512: wsh_trip_stops wts1,
513: wsh_new_deliveries wnd,
514: wsh_trips wt
515: WHERE delivery_leg_id = p_delivery_leg_id
516: AND wdl.pick_up_stop_id = wts1.stop_id

Line 531: FROM wsh_trip_stops wts1,

527: SELECT NVL(wts1.shipments_type_flag,'O') pu_stop_shipments_type_flag,
528: NVL(wts2.shipments_type_flag,'O') do_stop_shipments_type_flag,
529: NVL(wt.shipments_type_flag,'O') trip_shipments_type_flag,
530: wt.status_Code trip_status_Code
531: FROM wsh_trip_stops wts1,
532: wsh_trip_stops wts2,
533: wsh_trips wt
534: WHERE wt.trip_id = p_trip_id
535: AND wts1.stop_id = p_pickup_stop_id

Line 532: wsh_trip_stops wts2,

528: NVL(wts2.shipments_type_flag,'O') do_stop_shipments_type_flag,
529: NVL(wt.shipments_type_flag,'O') trip_shipments_type_flag,
530: wt.status_Code trip_status_Code
531: FROM wsh_trip_stops wts1,
532: wsh_trip_stops wts2,
533: wsh_trips wt
534: WHERE wt.trip_id = p_trip_id
535: AND wts1.stop_id = p_pickup_stop_id
536: AND wts2.stop_id = p_dropoff_stop_id

Line 560: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;

556: --
557: l_num_warnings NUMBER := 0;
558: l_num_errors NUMBER := 0;
559: l_return_status VARCHAR2(10);
560: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
561: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
562: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
563: --
564: l_has_mixed_deliveries VARCHAR2(10);

Line 561: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;

557: l_num_warnings NUMBER := 0;
558: l_num_errors NUMBER := 0;
559: l_return_status VARCHAR2(10);
560: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
561: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
562: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
563: --
564: l_has_mixed_deliveries VARCHAR2(10);
565: l_stop_opened VARCHAR2(10);

Line 566: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;

562: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
563: --
564: l_has_mixed_deliveries VARCHAR2(10);
565: l_stop_opened VARCHAR2(10);
566: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;
567: l_leg_complete boolean;
568:
569: l_gc3_is_installed VARCHAR2(1); --OTM R12
570:

Line 773: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);

769: -- Recalculate value of shipments type flag for
770: -- pickup and dropoff stop
771: --
772: IF l_debug_on THEN
773: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);
774: END IF;
775: --
776: -- Recalculate value of shipments type flag for pickup stop
777: --

Line 778: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag

774: END IF;
775: --
776: -- Recalculate value of shipments type flag for pickup stop
777: --
778: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
779: (
780: p_trip_id => leg_rec.trip_id,
781: p_stop_id => leg_rec.pick_up_stop_id,
782: p_action => 'UNASSIGN',

Line 811: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.GET_STOP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);

807: --
808: -- Debug Statements
809: --
810: IF l_debug_on THEN
811: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.GET_STOP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
812: END IF;
813: --
814: wsh_trip_stops_grp.get_stop_details_pvt
815: (p_stop_id => leg_rec.pick_up_stop_id,

Line 814: wsh_trip_stops_grp.get_stop_details_pvt

810: IF l_debug_on THEN
811: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.GET_STOP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
812: END IF;
813: --
814: wsh_trip_stops_grp.get_stop_details_pvt
815: (p_stop_id => leg_rec.pick_up_stop_id,
816: x_stop_rec => l_stop_rec,
817: x_return_status => l_return_status);
818: --

Line 847: update wsh_trip_stops

843: --
844: END IF;
845:
846: /* End of H integration - call Multi Leg FTE */
847: update wsh_trip_stops
848: set shipments_type_flag = lock_trip_rec.pu_stop_shipments_type_flag, -- J-IB-NPARIKH
849: last_update_date = SYSDATE,
850: last_updated_by = FND_GLOBAL.USER_ID,
851: last_update_login = FND_GLOBAL.LOGIN_ID

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

858: -- Display a warning whenever stop changes from mixed to inbound
859: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CHANGE_WARNING');
860: --
861: IF l_debug_on THEN
862: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
863: END IF;
864: --
865: --tkt calling get_namewith caller as FTE as inbound is available only with FTE
866: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(leg_rec.pick_up_stop_id, 'FTE'));

Line 866: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(leg_rec.pick_up_stop_id, 'FTE'));

862: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
863: END IF;
864: --
865: --tkt calling get_namewith caller as FTE as inbound is available only with FTE
866: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(leg_rec.pick_up_stop_id, 'FTE'));
867: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
868: --
869: l_num_warnings := l_num_warnings + 1;
870: --}

Line 877: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);

873: END IF;
874: --
875: --
876: IF l_debug_on THEN
877: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);
878: END IF;
879: --
880: -- Recalculate value of shipments type flag for dropoff stop
881: --

Line 883: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag

879: --
880: -- Recalculate value of shipments type flag for dropoff stop
881: --
882: --
883: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
884: (
885: p_trip_id => leg_rec.trip_id,
886: p_stop_id => leg_rec.drop_off_stop_id,
887: p_action => 'UNASSIGN',

Line 920: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.GET_STOP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);

916: --
917: -- Debug Statements
918: --
919: IF l_debug_on THEN
920: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.GET_STOP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
921: END IF;
922: --
923: wsh_trip_stops_grp.get_stop_details_pvt
924: (p_stop_id => leg_rec.drop_off_stop_id,

Line 923: wsh_trip_stops_grp.get_stop_details_pvt

919: IF l_debug_on THEN
920: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.GET_STOP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
921: END IF;
922: --
923: wsh_trip_stops_grp.get_stop_details_pvt
924: (p_stop_id => leg_rec.drop_off_stop_id,
925: x_stop_rec => l_stop_rec,
926: x_return_status => l_return_status);
927: --

Line 956: update wsh_trip_stops

952: --
953: END IF;
954:
955: /* End of H integration - call Multi Leg FTE */
956: update wsh_trip_stops
957: set shipments_type_flag = lock_trip_rec.do_stop_shipments_type_flag, -- J-IB-NPARIKH
958: last_update_date = SYSDATE,
959: last_updated_by = FND_GLOBAL.USER_ID,
960: last_update_login = FND_GLOBAL.LOGIN_ID

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

967: -- Display a warning whenever stop changes from mixed to inbound
968: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CHANGE_WARNING');
969: --
970: IF l_debug_on THEN
971: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
972: END IF;
973: --
974: --tkt calling get_namewith caller as FTE as inbound is available only with FTE
975: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(leg_rec.drop_off_stop_id,'FTE'));

Line 975: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(leg_rec.drop_off_stop_id,'FTE'));

971: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
972: END IF;
973: --
974: --tkt calling get_namewith caller as FTE as inbound is available only with FTE
975: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(leg_rec.drop_off_stop_id,'FTE'));
976: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
977: --
978: l_num_warnings := l_num_warnings + 1;
979: --}

Line 1038: UPDATE WSH_TRIP_STOPS

1034: WHERE trip_id = leg_rec.trip_id;
1035:
1036: -- To keep the shipments_type_flag of all the
1037: -- stops in SYNC with the trip
1038: UPDATE WSH_TRIP_STOPS
1039: SET shipments_type_flag = lock_trip_rec.trip_shipments_type_flag,
1040: last_update_date = SYSDATE,
1041: last_updated_by = FND_GLOBAL.USER_ID,
1042: last_update_login = FND_GLOBAL.LOGIN_ID

Line 1591: FROM wsh_trip_stops

1587: WHERE delivery_leg_id = x_leg_id;
1588:
1589: CURSOR get_stop_status(x_stop_id NUMBER) IS
1590: SELECT status_code
1591: FROM wsh_trip_stops
1592: WHERE stop_id = x_stop_id;
1593:
1594: i NUMBER := 0;
1595: dummy_id NUMBER := 0;