993: AND l_new_interface_flag_tab.COUNT > 0) THEN--{
994:
995: IF l_debug_on THEN
996: WSH_DEBUG_SV.logmsg(l_module_name,
997: 'Calling program unit WSH_XC_UTIL.LOG_OTM_EXCEPTION',
998: WSH_DEBUG_SV.C_PROC_LEVEL);
999: END IF;
1000:
1001: WSH_XC_UTIL.log_otm_exception(
997: 'Calling program unit WSH_XC_UTIL.LOG_OTM_EXCEPTION',
998: WSH_DEBUG_SV.C_PROC_LEVEL);
999: END IF;
1000:
1001: WSH_XC_UTIL.log_otm_exception(
1002: p_delivery_info_tab => l_delivery_info_tab,
1003: p_new_interface_flag_tab => l_new_interface_flag_tab,
1004: x_return_status => l_return_status);
1005:
2998:
2999: --OTM R12
3000: IF (l_gc3_is_installed = 'Y' AND l_tms_update = 'Y') THEN--{
3001:
3002: WSH_XC_UTIL.log_otm_exception(
3003: p_delivery_info_tab => l_delivery_info_tab,
3004: p_new_interface_flag_tab => l_new_interface_flag_tab,
3005: x_return_status => l_return_status);
3006:
3010:
3011: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
3012: x_return_status := l_return_status;
3013: IF l_debug_on THEN
3014: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_XC_UTIL.log_otm_exception');
3015: END IF;
3016: RAISE e_gc3_exception;
3017: END IF;
3018: END IF;--}
3471: OPEN c_del_location_id(p_entity_id);
3472: FETCH c_del_location_id INTO l_location_id;
3473: CLOSE c_del_location_id;
3474: IF l_location_id IS NOT NULL THEN
3475: WSH_XC_UTIL.log_exception(
3476: p_api_version => l_api_version,
3477: p_init_msg_list => FND_API.G_FALSE,
3478: p_commit => FND_API.G_FALSE,
3479: p_validation_level => l_validation_level,
3495: OPEN c_det_location_id(p_entity_id);
3496: FETCH c_det_location_id INTO l_location_id;
3497: CLOSE c_det_location_id;
3498: IF l_location_id IS NOT NULL THEN
3499: WSH_XC_UTIL.log_exception(
3500: p_api_version => l_api_version,
3501: p_init_msg_list => FND_API.G_FALSE,
3502: p_commit => FND_API.G_FALSE,
3503: p_validation_level => l_validation_level,
3598: IF l_location_id IS NOT NULL THEN
3599: FND_MESSAGE.SET_NAME('WSH','WSH_SHIPSET_IGNORE_FOR_PLANG');
3600: FND_MESSAGE.SET_TOKEN('ENTITY',l_delivery_detail_id);
3601: l_exception_message := FND_MESSAGE.GET;
3602: WSH_XC_UTIL.log_exception(
3603: p_api_version => l_api_version,
3604: p_init_msg_list => FND_API.G_FALSE,
3605: p_commit => FND_API.G_FALSE,
3606: p_validation_level => l_validation_level,