APPS.WSH_TRIPS_ACTIONS dependencies on WSH_TRIP_STOPS_VALIDATIONS

Line 2570: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;

2566: --
2567: l_debug_on BOOLEAN;
2568: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'AUTOCREATE_TRIP';
2569: --
2570: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;
2571: l_stop_processed VARCHAR2(10);
2572: -- Bug 3413364, skip the delivery if it does not have both initial pickup date and ultimate dropoff date
2573: l_initial_pickup_date DATE;
2574: l_ultimate_dropoff_date DATE;

Line 4003: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;

3999: --
4000: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CHECK_ASSIGN_TRIP';
4001: --
4002: -- patchset J csun Stop Sequence Change
4003: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;
4004: l_return_status VARCHAR2(1);
4005:
4006: BEGIN
4007:

Line 4808: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;

4804: --
4805: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'ASSIGN_TRIP';
4806: --
4807: -- patchset J csun Stop Sequence Change
4808: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;
4809:
4810: l_del_rows wsh_util_core.id_tab_type;
4811: l_pickup_stop_id NUMBER;
4812: l_dropoff_stop_id NUMBER;

Line 5103: wsh_debug_sv.log(l_module_name,'Return Status From WSH_TRIP_STOPS_VALIDATIONS.Validate_Stop_Dates for trip '||p_trip_id ,l_return_status);

5099: p_caller => p_caller
5100: );
5101:
5102: IF l_debug_on THEN
5103: wsh_debug_sv.log(l_module_name,'Return Status From WSH_TRIP_STOPS_VALIDATIONS.Validate_Stop_Dates for trip '||p_trip_id ,l_return_status);
5104: END IF;
5105:
5106: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
5107: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 7590: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;

7586: l_update_flag BOOLEAN;
7587: l_push_date_allowed BOOLEAN;
7588: l_push_ssn_allowed BOOLEAN;
7589: l_return_status VARCHAR2(1);
7590: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;
7591: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Handle_Internal_Stops';
7592: stop_locked EXCEPTION;
7593: get_physical_loc_err EXCEPTION;
7594: reset_stop_seq_number_error EXCEPTION;

Line 7975: wsh_debug_sv.log(l_module_name,'Return Status From WSH_TRIP_STOPS_VALIDATIONS.Validate_Stop_Dates for trip '||p_trip_ids(i) ,l_return_status);

7971: p_trip_id => p_trip_ids(i),
7972: x_return_status => l_return_status);
7973:
7974: IF l_debug_on THEN
7975: wsh_debug_sv.log(l_module_name,'Return Status From WSH_TRIP_STOPS_VALIDATIONS.Validate_Stop_Dates for trip '||p_trip_ids(i) ,l_return_status);
7976: END IF;
7977:
7978: IF l_return_status in ( WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
7979: raise validate_stop_date_error;