DBA Data[Home] [Help]

APPS.WSH_TRIPS_ACTIONS dependencies on WSH_TRIP_STOPS_PVT

Line 919: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;

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

Line 1206: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;

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

Line 2559: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;

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

Line 3156: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;

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

Line 4794: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;

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

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

5722: --
5723: -- Debug Statements
5724: --
5725: IF l_debug_on THEN
5726: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5727: END IF;
5728: --
5729: FND_MESSAGE.SET_TOKEN('stop_name',wsh_trip_stops_pvt.get_name(l_start_stop_id,p_caller));
5730: -- bug 2732503 , need a warning message only when FTE is installed

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

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

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

5791: --
5792: -- Debug Statements
5793: --
5794: IF l_debug_on THEN
5795: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
5796: END IF;
5797: --
5798: FND_MESSAGE.SET_TOKEN('stop_name',wsh_trip_stops_pvt.get_name(l_stop_id,p_caller));
5799: -- bug 2732503 , need a warning message only when FTE is installed

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

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

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

6086: --
6087: -- Debug Statements
6088: --
6089: IF l_debug_on THEN
6090: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6091: END IF;
6092: --
6093: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id,p_caller));
6094: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

6089: IF l_debug_on THEN
6090: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6091: END IF;
6092: --
6093: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id,p_caller));
6094: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6095: wsh_util_core.add_message(x_return_status);
6096: l_stop_num_warn := l_stop_num_warn + 1;
6097: END IF;

Line 6810: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;

6806: p_volume IN NUMBER,
6807: p_fill_percent IN NUMBER,
6808: x_return_status OUT NOCOPY VARCHAR2) IS
6809:
6810: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
6811: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
6812: l_return_status VARCHAR2(1);
6813:
6814: l_debug_on BOOLEAN;