DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERIES_PVT dependencies on WSH_XC_UTIL

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

1021: --OTM R12
1022: IF (l_gc3_is_installed = 'Y' AND l_tms_update = 'Y') THEN
1023:
1024: IF l_debug_on THEN
1025: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_OTM_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1026: END IF;
1027:
1028: WSH_XC_UTIL.log_otm_exception(
1029: p_delivery_info_tab => l_delivery_info_tab,

Line 1028: WSH_XC_UTIL.log_otm_exception(

1024: IF l_debug_on THEN
1025: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_OTM_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1026: END IF;
1027:
1028: WSH_XC_UTIL.log_otm_exception(
1029: p_delivery_info_tab => l_delivery_info_tab,
1030: p_new_interface_flag_tab => l_new_interface_flag_tab,
1031: x_return_status => l_return_status);
1032:

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

1030: p_new_interface_flag_tab => l_new_interface_flag_tab,
1031: x_return_status => l_return_status);
1032:
1033: IF l_debug_on THEN
1034: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_XC_UTIL.LOG_OTM_EXCEPTION',l_return_status);
1035: END IF;
1036:
1037: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1038: IF l_debug_on THEN

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

1035: END IF;
1036:
1037: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1038: IF l_debug_on THEN
1039: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');
1040: END IF;
1041: RAISE api_return_fail;
1042: END IF;
1043: END IF;

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

3720: WHERE DELIVERY_ID = l_delivery_id_tab(j);
3721:
3722: IF l_debug_on THEN
3723: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);
3724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_OTM_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
3725: END IF;
3726:
3727: WSH_XC_UTIL.log_otm_exception(
3728: p_delivery_info_tab => l_delivery_info_tab,

Line 3727: WSH_XC_UTIL.log_otm_exception(

3723: WSH_DEBUG_SV.log(l_module_name,'Rows updated',SQL%ROWCOUNT);
3724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.LOG_OTM_EXCEPTION',WSH_DEBUG_SV.C_PROC_LEVEL);
3725: END IF;
3726:
3727: WSH_XC_UTIL.log_otm_exception(
3728: p_delivery_info_tab => l_delivery_info_tab,
3729: p_new_interface_flag_tab => l_new_tms_interface_flag_tab,
3730: x_return_status => l_return_status);
3731:

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

3729: p_new_interface_flag_tab => l_new_tms_interface_flag_tab,
3730: x_return_status => l_return_status);
3731:
3732: IF l_debug_on THEN
3733: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_XC_UTIL.LOG_OTM_EXCEPTION',l_return_status);
3734: END IF;
3735:
3736: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3737: IF l_debug_on THEN

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

3734: END IF;
3735:
3736: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
3737: IF l_debug_on THEN
3738: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: WSH_XC_UTIL.log_otm_exception failed');
3739: END IF;
3740: RAISE FND_API.G_EXC_ERROR;
3741: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3742: IF l_debug_on THEN

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

3739: END IF;
3740: RAISE FND_API.G_EXC_ERROR;
3741: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3742: IF l_debug_on THEN
3743: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: WSH_XC_UTIL.log_otm_exception failed unexpectedly');
3744: END IF;
3745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3746: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
3747: --set return status to warning if l_return_status is warning