335: p_message => substrb(l_exception_message,1,2000),
336: p_delivery_id => l_failed_entity_tab(itr).delivery_id);
337:
338: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
339: raise FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;
341:
342: EXIT WHEN itr = l_failed_entity_tab.LAST;
343: itr := l_failed_entity_tab.NEXT(itr);
369: p_message => substrb(l_exception_message,1,2000),
370: p_trip_id => l_failed_entity_tab(itr).trip_id);
371:
372: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
373: raise FND_API.G_EXC_UNEXPECTED_ERROR;
374: END IF;
375:
376: EXIT WHEN itr = l_failed_entity_tab.LAST;
377: itr := l_failed_entity_tab.NEXT(itr);
462: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
463:
464: IF l_debug_on THEN
465: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
466: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
467: END IF;
468: --
469: END LOG_EXCEPTIONS;
470:
596: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
597: END IF;
598:
599: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
600: raise FND_API.G_EXC_UNEXPECTED_ERROR;
601: END IF;
602:
603: --
604: -- Generate the result tab using it.
648: WSH_DEBUG_SV.log(l_module_name,'l_return Status ',l_return_status);
649: END IF;
650:
651: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
652: raise FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654:
655: x_cs_output_tab(l_cnt).freight_terms_code := l_result_tab(l_itr).freight_terms_code;
656: x_cs_output_tab(l_cnt).consignee_carrier_ac_no := l_result_tab(l_itr).consignee_carrier_ac_no;
768: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
769: --
770: IF l_debug_on THEN
771: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
772: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
773: END IF;
774: END GET_FORMAT_RESULTS;
775:
776:
846: END IF;
847:
848: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
849: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
850: raise FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;
852: END IF;
853:
854: l_entities_left := p_format_cs_tab.COUNT;
930: END IF;
931:
932: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
933: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
934: raise FND_API.G_EXC_UNEXPECTED_ERROR;
935: END IF;
936: END IF;
937:
938: l_single_entity := FALSE;
1004: END IF;
1005:
1006: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1007: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1008: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1009: END IF;
1010: END IF;
1011:
1012: itr := l_output_tab.FIRST;
1034: END IF;
1035:
1036: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1037: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1038: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1039: END IF;
1040: END IF;
1041:
1042: IF (l_rule_id <> FTE_ACS_CACHE_PKG.g_rule_not_found) THEN
1119: END IF;
1120:
1121: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1122: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1123: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1124: END IF;
1125: END IF;
1126: END IF;
1127:
1145: END IF;
1146:
1147: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1148: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1149: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END IF;
1151: END IF;
1152:
1153: ELSE
1169: END IF;
1170:
1171: EXCEPTION
1172:
1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1174: --
1175: WSH_UTIL_CORE.default_handler('FTE_ACS_PKG.get_routing_rules');
1176: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1177: --
1176: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1177: --
1178: IF l_debug_on THEN
1179: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1180: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1181: END IF;
1182:
1183: WHEN OTHERS THEN
1184: --
1186: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1187: --
1188: IF l_debug_on THEN
1189: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1190: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1191: END IF;
1192:
1193: END GET_ROUTING_RESULTS;
1194: