DBA Data[Home] [Help]

APPS.WSH_DELIVERY_SPLITTER_PKG dependencies on WSH_DELIVERY_VALIDATIONS

Line 428: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);

424: --so adding this first query to bypass all the DELETE_REQUIRED deliveries
425:
426: --get delivery information
427: IF l_debug_on THEN
428: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);
429: END IF;
430:
431: WSH_DELIVERY_VALIDATIONS.get_delivery_information(p_delivery_id => p_delivery_tab(i).entity_id,
432: x_delivery_rec => l_delivery_info,

Line 431: WSH_DELIVERY_VALIDATIONS.get_delivery_information(p_delivery_id => p_delivery_tab(i).entity_id,

427: IF l_debug_on THEN
428: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);
429: END IF;
430:
431: WSH_DELIVERY_VALIDATIONS.get_delivery_information(p_delivery_id => p_delivery_tab(i).entity_id,
432: x_delivery_rec => l_delivery_info,
433: x_return_status => l_return_status);
434:
435: IF l_debug_on THEN

Line 436: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_VALIDATIONS.get_delivery_information: ' || l_return_status);

432: x_delivery_rec => l_delivery_info,
433: x_return_status => l_return_status);
434:
435: IF l_debug_on THEN
436: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_VALIDATIONS.get_delivery_information: ' || l_return_status);
437: END IF;
438:
439: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
440: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

Line 525: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);

521: END IF;
522:
523: --get delivery information again to ensure it's latest
524: IF l_debug_on THEN
525: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);
526: END IF;
527:
528: WSH_DELIVERY_VALIDATIONS.get_delivery_information(p_delivery_id => p_delivery_tab(i).entity_id,
529: x_delivery_rec => l_delivery_info,

Line 528: WSH_DELIVERY_VALIDATIONS.get_delivery_information(p_delivery_id => p_delivery_tab(i).entity_id,

524: IF l_debug_on THEN
525: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);
526: END IF;
527:
528: WSH_DELIVERY_VALIDATIONS.get_delivery_information(p_delivery_id => p_delivery_tab(i).entity_id,
529: x_delivery_rec => l_delivery_info,
530: x_return_status => l_return_status);
531:
532: IF l_debug_on THEN

Line 533: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_VALIDATIONS.get_delivery_information: ' || l_return_status);

529: x_delivery_rec => l_delivery_info,
530: x_return_status => l_return_status);
531:
532: IF l_debug_on THEN
533: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_VALIDATIONS.get_delivery_information: ' || l_return_status);
534: END IF;
535:
536: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
537: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN