DBA Data[Home] [Help]

APPS.WSH_TRIPS_ACTIONS dependencies on WSH_TRIP_STOPS_PVT

Line 917: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;

913: x_return_status OUT NOCOPY VARCHAR2) IS
914:
915: i BINARY_INTEGER;
916: /* H integration for Multi Leg */
917: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
918: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
919: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
920: l_pub_trip_rec WSH_TRIPS_PUB.TRIP_PUB_REC_TYPE;
921: l_return_status VARCHAR2(30);

Line 1204: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;

1200: wts.trip_id=p_in_rec.trip_id;
1201:
1202:
1203: /* H integration for Multi Leg */
1204: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
1205: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
1206: --
1207: --
1208: l_num_warnings NUMBER;

Line 2557: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;

2553: l_good_dels WSH_UTIL_CORE.ID_TAB_TYPE;
2554:
2555: /* H integration for Multi Leg */
2556: l_num_warn NUMBER := 0;
2557: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
2558: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
2559: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
2560: l_pub_trip_rec WSH_TRIPS_PUB.TRIP_PUB_REC_TYPE;
2561: l_grp_trip_rec WSH_TRIPS_GRP.TRIP_PUB_REC_TYPE;

Line 3154: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

3150: --dummy tables for calling validate_constraint_mainper
3151: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
3152: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
3153: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
3154: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3155: l_cc_in_ids wsh_util_core.id_tab_type;
3156: l_cc_fail_ids wsh_util_core.id_tab_type;
3157:
3158: CURSOR del_cur(p_dlvy_id NUMBER) IS

Line 4792: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;

4788:
4789: stop_not_found EXCEPTION;
4790: others EXCEPTION;
4791: /* H integration for Multi Leg */
4792: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
4793: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
4794: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
4795: l_pub_trip_rec WSH_TRIPS_PUB.TRIP_PUB_REC_TYPE;
4796: l_num_warn NUMBER := 0;

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

5716: --
5717: -- Debug Statements
5718: --
5719: IF l_debug_on THEN
5720: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5721: END IF;
5722: --
5723: FND_MESSAGE.SET_TOKEN('stop_name',wsh_trip_stops_pvt.get_name(l_start_stop_id,p_caller));
5724: -- bug 2732503 , need a warning message only when FTE is installed

Line 5723: FND_MESSAGE.SET_TOKEN('stop_name',wsh_trip_stops_pvt.get_name(l_start_stop_id,p_caller));

5719: IF l_debug_on THEN
5720: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5721: END IF;
5722: --
5723: FND_MESSAGE.SET_TOKEN('stop_name',wsh_trip_stops_pvt.get_name(l_start_stop_id,p_caller));
5724: -- bug 2732503 , need a warning message only when FTE is installed
5725: -- still will go to wt_vol_error
5726: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5727: wsh_util_core.add_message(x_return_status);

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

5785: --
5786: -- Debug Statements
5787: --
5788: IF l_debug_on THEN
5789: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5790: END IF;
5791: --
5792: FND_MESSAGE.SET_TOKEN('stop_name',wsh_trip_stops_pvt.get_name(l_stop_id,p_caller));
5793: -- bug 2732503 , need a warning message only when FTE is installed

Line 5792: FND_MESSAGE.SET_TOKEN('stop_name',wsh_trip_stops_pvt.get_name(l_stop_id,p_caller));

5788: IF l_debug_on THEN
5789: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5790: END IF;
5791: --
5792: FND_MESSAGE.SET_TOKEN('stop_name',wsh_trip_stops_pvt.get_name(l_stop_id,p_caller));
5793: -- bug 2732503 , need a warning message only when FTE is installed
5794: -- still will go to wt_vol_error
5795: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5796: wsh_util_core.add_message(x_return_status);

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

6075: --
6076: -- Debug Statements
6077: --
6078: IF l_debug_on THEN
6079: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6080: END IF;
6081: --
6082: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id,p_caller));
6083: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 6082: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id,p_caller));

6078: IF l_debug_on THEN
6079: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6080: END IF;
6081: --
6082: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id,p_caller));
6083: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6084: wsh_util_core.add_message(x_return_status);
6085: l_stop_num_warn := l_stop_num_warn + 1;
6086: END IF;

Line 6799: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;

6795: p_volume IN NUMBER,
6796: p_fill_percent IN NUMBER,
6797: x_return_status OUT NOCOPY VARCHAR2) IS
6798:
6799: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
6800: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
6801: l_return_status VARCHAR2(1);
6802:
6803: l_debug_on BOOLEAN;