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

Line 217: FROM WSH_TRIP_STOPS WTS, WSH_DELIVERY_LEGS WDL

213:
214: CURSOR Get_Trip(c_delivery_id NUMBER)
215: IS
216: SELECT WTS.TRIP_ID
217: FROM WSH_TRIP_STOPS WTS, WSH_DELIVERY_LEGS WDL
218: WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID
219: AND WDL.DELIVERY_ID = c_delivery_id;
220:
221:

Line 2578: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;

2574: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
2575: l_trip_id NUMBER;
2576: l_del_id NUMBER;
2577: l_trip_name VARCHAR2(30);
2578: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
2579: l_pickup_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
2580: l_pickup_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2581: l_pickup_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2582: l_dropoff_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;

Line 2579: l_pickup_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;

2575: l_trip_id NUMBER;
2576: l_del_id NUMBER;
2577: l_trip_name VARCHAR2(30);
2578: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
2579: l_pickup_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
2580: l_pickup_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2581: l_pickup_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2582: l_dropoff_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
2583: l_dropoff_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

Line 2580: l_pickup_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

2576: l_del_id NUMBER;
2577: l_trip_name VARCHAR2(30);
2578: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
2579: l_pickup_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
2580: l_pickup_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2581: l_pickup_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2582: l_dropoff_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
2583: l_dropoff_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2584: l_dropoff_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;

Line 2581: l_pickup_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;

2577: l_trip_name VARCHAR2(30);
2578: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
2579: l_pickup_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
2580: l_pickup_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2581: l_pickup_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2582: l_dropoff_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
2583: l_dropoff_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2584: l_dropoff_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2585: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type;

Line 2582: l_dropoff_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;

2578: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
2579: l_pickup_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
2580: l_pickup_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2581: l_pickup_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2582: l_dropoff_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
2583: l_dropoff_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2584: l_dropoff_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2585: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type;
2586: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;

Line 2583: l_dropoff_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

2579: l_pickup_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
2580: l_pickup_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2581: l_pickup_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2582: l_dropoff_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
2583: l_dropoff_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2584: l_dropoff_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2585: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type;
2586: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
2587: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

Line 2584: l_dropoff_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;

2580: l_pickup_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2581: l_pickup_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2582: l_dropoff_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
2583: l_dropoff_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2584: l_dropoff_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2585: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type;
2586: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
2587: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2588: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;

Line 2585: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type;

2581: l_pickup_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2582: l_dropoff_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
2583: l_dropoff_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2584: l_dropoff_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
2585: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.Stop_Wt_Vol_tab_type;
2586: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
2587: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2588: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
2589: l_defaults_rec WSH_DELIVERIES_GRP.default_parameters_rectype;

Line 2604: FROM WSH_TRIP_STOPS

2600: l_message VARCHAR2(2000);
2601:
2602: CURSOR Get_Intermediate_Dropoff_Date(c_trip_id NUMBER) IS
2603: SELECT PLANNED_ARRIVAL_DATE
2604: FROM WSH_TRIP_STOPS
2605: WHERE TRIP_ID = c_trip_id
2606: ORDER BY STOP_SEQUENCE_NUMBER DESC;
2607:
2608: BEGIN

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

2861: l_stop_in_rec.phase := NULL;
2862: l_stop_in_rec.action_code := 'CREATE';
2863: IF l_debug_on THEN
2864: WSH_DEBUG_SV.logmsg(l_module_name,'Creating pickup stop');
2865: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);
2866: END IF;
2867:
2868: WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(
2869: p_api_version_number => l_api_version_number,

Line 2868: WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(

2864: WSH_DEBUG_SV.logmsg(l_module_name,'Creating pickup stop');
2865: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);
2866: END IF;
2867:
2868: WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(
2869: p_api_version_number => l_api_version_number,
2870: p_init_msg_list => l_init_msg_list,
2871: p_commit => l_commit,
2872: p_in_rec => l_stop_in_rec,

Line 2888: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

2884: END IF;
2885: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
2886: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2887: THEN
2888: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
2889: IF l_debug_on THEN
2890: FOR m in 1..l_msg_count
2891: LOOP
2892: l_message := fnd_msg_pub.get(m,'F');

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

2918: l_dropoff_stop_info.planned_departure_date := x_delivery_tab(i).ultimate_dropoff_date;
2919: l_dropoff_rec_attr_tab(1):=l_dropoff_stop_info;
2920: IF l_debug_on THEN
2921: WSH_DEBUG_SV.logmsg(l_module_name,'Creating dropoff stop');
2922: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);
2923: END IF;
2924:
2925:
2926: WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(

Line 2926: WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(

2922: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);
2923: END IF;
2924:
2925:
2926: WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(
2927: p_api_version_number => l_api_version_number,
2928: p_init_msg_list => l_init_msg_list,
2929: p_commit => l_commit,
2930: p_in_rec => l_stop_in_rec,

Line 2946: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

2942: END IF;
2943: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
2944: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
2945: THEN
2946: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
2947: IF l_debug_on THEN
2948: FOR m in 1..l_msg_count
2949: LOOP
2950: l_message := fnd_msg_pub.get(m,'F');