APPS.WSH_DELIVERY_DETAILS_UTILITIES dependencies on WSH_DELIVERY_VALIDATIONS

Line 146: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

142: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
143: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
144: l_tms_update VARCHAR2(1);
145: l_trip_not_found VARCHAR2(1);
146: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
147: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;
148: l_ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
149: l_otm_return_status VARCHAR2(1); -- not to overwrite l_return_status
150: l_gc3_is_installed VARCHAR2(1);

Line 451: WSH_DELIVERY_VALIDATIONS.get_trip_information

447: l_otm_return_status := NULL;
448: l_trip_not_found := 'N';
449:
450: --get trip information for delivery, no update when trip not OPEN
451: WSH_DELIVERY_VALIDATIONS.get_trip_information
452: (p_delivery_id => l_delivery_id,
453: x_trip_info_rec => l_trip_info_rec,
454: x_return_status => l_otm_return_status);
455:

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

455:
456: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
457: x_return_status := l_otm_return_status;
458: IF l_debug_on THEN
459: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
460: WSH_DEBUG_SV.pop(l_module_name);
461: END IF;
462: RETURN;
463: END IF;

Line 473: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

469: -- only do changes when there's no trip or trip status is OPEN
470: IF (l_trip_info_rec.status_code = 'OP' OR
471: l_trip_not_found = 'Y') THEN
472:
473: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
474: p_delivery_id => l_delivery_id,
475: x_delivery_rec => l_delivery_info,
476: x_return_status => l_otm_return_status);
477:

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

477:
478: IF (l_otm_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
479: x_return_status := l_otm_return_status;
480: IF l_debug_on THEN
481: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
482: WSH_DEBUG_SV.pop(l_module_name);
483: END IF;
484: RETURN;
485: END IF;