APPS.WSH_DELIVERY_DETAILS_UTILITIES dependencies on WSH_DELIVERY_VALIDATIONS

Line 140: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

136: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
137: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
138: l_tms_update VARCHAR2(1);
139: l_trip_not_found VARCHAR2(1);
140: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
141: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;
142: l_ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
143: l_otm_return_status VARCHAR2(1); -- not to overwrite l_return_status
144: l_gc3_is_installed VARCHAR2(1);

Line 445: WSH_DELIVERY_VALIDATIONS.get_trip_information

441: l_otm_return_status := NULL;
442: l_trip_not_found := 'N';
443:
444: --get trip information for delivery, no update when trip not OPEN
445: WSH_DELIVERY_VALIDATIONS.get_trip_information
446: (p_delivery_id => l_delivery_id,
447: x_trip_info_rec => l_trip_info_rec,
448: x_return_status => l_otm_return_status);
449:

Line 453: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');

449:
450: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
451: x_return_status := l_otm_return_status;
452: IF l_debug_on THEN
453: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
454: WSH_DEBUG_SV.pop(l_module_name);
455: END IF;
456: RETURN;
457: END IF;

Line 467: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

463: -- only do changes when there's no trip or trip status is OPEN
464: IF (l_trip_info_rec.status_code = 'OP' OR
465: l_trip_not_found = 'Y') THEN
466:
467: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
468: p_delivery_id => l_delivery_id,
469: x_delivery_rec => l_delivery_info,
470: x_return_status => l_otm_return_status);
471:

Line 475: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');

471:
472: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
473: x_return_status := l_otm_return_status;
474: IF l_debug_on THEN
475: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
476: WSH_DEBUG_SV.pop(l_module_name);
477: END IF;
478: RETURN;
479: END IF;