APPS.WSH_TRIPS_ACTIONS dependencies on WSH_TRIP_STOPS_VALIDATIONS

Line 2568: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;

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

Line 4001: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;

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

Line 4806: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;

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

Line 5101: 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);

5097: p_caller => p_caller
5098: );
5099:
5100: IF l_debug_on THEN
5101: 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);
5102: END IF;
5103:
5104: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
5105: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 7579: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;

7575: l_update_flag BOOLEAN;
7576: l_push_date_allowed BOOLEAN;
7577: l_push_ssn_allowed BOOLEAN;
7578: l_return_status VARCHAR2(1);
7579: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;
7580: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Handle_Internal_Stops';
7581: stop_locked EXCEPTION;
7582: get_physical_loc_err EXCEPTION;
7583: reset_stop_seq_number_error EXCEPTION;

Line 7964: 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);

7960: p_trip_id => p_trip_ids(i),
7961: x_return_status => l_return_status);
7962:
7963: IF l_debug_on THEN
7964: 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);
7965: END IF;
7966:
7967: IF l_return_status in ( WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
7968: raise validate_stop_date_error;