DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERIES_PVT dependencies on WSH_XC_UTIL

Line 1030: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_OTM_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);

1026: --OTM R12
1027: IF (l_gc3_is_installed = 'Y' AND l_tms_update = 'Y') THEN
1028:
1029: IF l_debug_on THEN
1030: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_OTM_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1031: END IF;
1032:
1033: WSH_XC_UTIL.log_otm_exception(
1034: p_delivery_info_tab => l_delivery_info_tab,

Line 1033: WSH_XC_UTIL.log_otm_exception(

1029: IF l_debug_on THEN
1030: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_OTM_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1031: END IF;
1032:
1033: WSH_XC_UTIL.log_otm_exception(
1034: p_delivery_info_tab => l_delivery_info_tab,
1035: p_new_interface_flag_tab => l_new_interface_flag_tab,
1036: x_return_status => l_return_status);
1037:

Line 1039: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_XC_UTIL.LOG_OTM_EXCEPTION',l_return_status);

1035: p_new_interface_flag_tab => l_new_interface_flag_tab,
1036: x_return_status => l_return_status);
1037:
1038: IF l_debug_on THEN
1039: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_XC_UTIL.LOG_OTM_EXCEPTION',l_return_status);
1040: END IF;
1041:
1042: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1043: IF l_debug_on THEN

Line 1044: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');

1040: END IF;
1041:
1042: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1043: IF l_debug_on THEN
1044: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');
1045: END IF;
1046: RAISE api_return_fail;
1047: END IF;
1048: END IF;

Line 3748: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_OTM_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);

3744: WHERE DELIVERY_ID = l_delivery_id_tab(j);
3745:
3746: IF l_debug_on THEN
3747: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);
3748: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_OTM_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
3749: END IF;
3750:
3751: WSH_XC_UTIL.log_otm_exception(
3752: p_delivery_info_tab => l_delivery_info_tab,

Line 3751: WSH_XC_UTIL.log_otm_exception(

3747: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);
3748: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_OTM_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
3749: END IF;
3750:
3751: WSH_XC_UTIL.log_otm_exception(
3752: p_delivery_info_tab => l_delivery_info_tab,
3753: p_new_interface_flag_tab => l_new_tms_interface_flag_tab,
3754: x_return_status => l_return_status);
3755:

Line 3757: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_XC_UTIL.LOG_OTM_EXCEPTION',l_return_status);

3753: p_new_interface_flag_tab => l_new_tms_interface_flag_tab,
3754: x_return_status => l_return_status);
3755:
3756: IF l_debug_on THEN
3757: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_XC_UTIL.LOG_OTM_EXCEPTION',l_return_status);
3758: END IF;
3759:
3760: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3761: IF l_debug_on THEN

Line 3762: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: WSH_XC_UTIL.log_otm_exception failed');

3758: END IF;
3759:
3760: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3761: IF l_debug_on THEN
3762: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: WSH_XC_UTIL.log_otm_exception failed');
3763: END IF;
3764: RAISE FND_API.G_EXC_ERROR;
3765: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3766: IF l_debug_on THEN

Line 3767: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: WSH_XC_UTIL.log_otm_exception failed unexpectedly');

3763: END IF;
3764: RAISE FND_API.G_EXC_ERROR;
3765: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3766: IF l_debug_on THEN
3767: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: WSH_XC_UTIL.log_otm_exception failed unexpectedly');
3768: END IF;
3769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3770: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3771: --set return status to warning if l_return_status is warning