270: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
271: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
272: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After clear_globals ');
273: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_clear_globals_fl');
274: raise FND_API.G_EXC_ERROR;
275: END IF;
276: END IF;
277:
278: -- g_effectivity dates is the global variable which stores the dates passed to QP
294: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
295: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
296: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
297: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_eng_inp_failed');
298: raise FND_API.G_EXC_ERROR;
299: END IF;
300: END IF;
301:
302: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_implicit_non_dummy_cnt = '||l_implicit_non_dummy_cnt);
316: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
317: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
318: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After call_qp_api ');
319: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_call_qp_api_failed');
320: raise FND_API.G_EXC_ERROR;
321: END IF;
322: END IF;
323:
324: -- fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
327: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
328: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
329: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After check_qp_output_errors ');
330: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_chk_qp_output_failed');
331: raise FND_API.G_EXC_ERROR;
332: END IF;
333: END IF;
334:
335:
340: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
341: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
342: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After check_qp_ipl ');
343: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_check_qp_ipl_failed');
344: raise FND_API.G_EXC_ERROR;
345: END IF;
346: END IF;
347:
348:
364: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
365: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
366: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After retrieve_qp_output ');
367: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_ret_qp_out_failed');
368: raise FND_API.G_EXC_ERROR;
369: END IF;
370: END IF;
371:
372: print_output( p_trip_charges_rec => x_trip_charges_rec,
376:
377: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
378:
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
382: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
383:
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: WHEN FND_API.G_EXC_ERROR THEN
381: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
382: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
383:
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
386: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
387:
388: WHEN OTHERS THEN
446:
447: IF l_uom_ea is null THEN
448: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After get_uom_for_each ');
449: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_get_uom_for_each_failed');
450: raise FND_API.G_EXC_ERROR;
451: END IF;
452:
453: -- VVP: 09/18/03
454: -- Made a few changes to account for 'DIRECT_ROUTE' vs 'FULL_ROUTE'
501: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
502: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
503: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
504: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_inp_line_failed');
505: raise FND_API.G_EXC_ERROR;
506: END IF;
507: END IF;
508:
509: END IF;
599: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
600: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
601: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
602: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_inp_line_failed');
603: raise FND_API.G_EXC_ERROR;
604: END IF;
605: END IF;
606:
607: END IF;
651: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
652: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
653: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
654: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_inp_line_failed');
655: raise FND_API.G_EXC_ERROR;
656: END IF;
657: END IF;
658:
659: END IF;
709: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
710: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
711: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
712: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_inp_line_failed');
713: raise FND_API.G_EXC_ERROR;
714: END IF;
715: END IF;
716: ELSE
717: -- bug 3610889
780: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
781: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
782: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
783: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_inp_line_failed');
784: raise FND_API.G_EXC_ERROR;
785: END IF;
786: END IF;
787:
788: END IF;
819: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
820: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
821: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
822: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_inp_line_failed');
823: raise FND_API.G_EXC_ERROR;
824: END IF;
825: END IF;
826: END IF;
827:
855: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
856: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
857: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
858: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_inp_line_failed');
859: raise FND_API.G_EXC_ERROR;
860: END IF;
861: END IF;
862:
863: -- LOAD CHARGE LINE
890: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
891: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
892: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
893: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_inp_line_failed');
894: raise FND_API.G_EXC_ERROR;
895: END IF;
896: END IF;
897:
898: -- create qp control record
901: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
902: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
903: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
904: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_ctrl_rec_failed');
905: raise FND_API.G_EXC_ERROR;
906: END IF;
907: END IF;
908:
909: -- STOP CHARGE LINES
953: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
954: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
955: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
956: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_inp_line_failed');
957: raise FND_API.G_EXC_ERROR;
958: END IF;
959: END IF;
960:
961: EXIT WHEN i = p_stop_tab.LAST ;
1010: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1011: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1012: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
1013: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_inp_line_failed');
1014: raise FND_API.G_EXC_ERROR;
1015: END IF;
1016: END IF;
1017:
1018: END IF;
1029:
1030: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
1031:
1032: EXCEPTION
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1035: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1036:
1037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1035: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1036:
1037: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1039: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1040:
1041: WHEN OTHERS THEN
1091: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1092: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1093: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
1094: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_line_rec_failed');
1095: raise FND_API.G_EXC_ERROR;
1096: END IF;
1097: END IF;
1098:
1099: create_line_attributes (
1106: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1107: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1108: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
1109: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_line_attr_failed');
1110: raise FND_API.G_EXC_ERROR;
1111: END IF;
1112: END IF;
1113:
1114: create_line_qualifiers (
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: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
1124: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_line_qual_failed');
1125: raise FND_API.G_EXC_ERROR;
1126: END IF;
1127: END IF;
1128:
1129: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
1128:
1129: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
1130:
1131: EXCEPTION
1132: WHEN FND_API.G_EXC_ERROR THEN
1133: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1134: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1135:
1136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1132: WHEN FND_API.G_EXC_ERROR THEN
1133: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1134: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1135:
1136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1138: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1139:
1140: WHEN OTHERS THEN
1359: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1360: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1361: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
1362: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_chrg_line_attr_failed');
1363: raise FND_API.G_EXC_ERROR;
1364: END IF;
1365: END IF;
1366:
1367: l_attr_idx := l_pricing_attr_tab.COUNT;
1405: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1406: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1407: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
1408: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_prep_qp_line_attr_failed');
1409: raise FND_API.G_EXC_ERROR;
1410: END IF;
1411: END IF;
1412:
1413: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
1412:
1413: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
1414:
1415: EXCEPTION
1416: WHEN FND_API.G_EXC_ERROR THEN
1417: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1418: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1419:
1420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1416: WHEN FND_API.G_EXC_ERROR THEN
1417: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1418: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1419:
1420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1421: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1422: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1423:
1424: WHEN OTHERS THEN
1960:
1961: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
1962:
1963: EXCEPTION
1964: WHEN FND_API.G_EXC_ERROR THEN
1965: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1966: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1967:
1968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1964: WHEN FND_API.G_EXC_ERROR THEN
1965: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1966: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1967:
1968: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1969: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1970: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1971:
1972: WHEN OTHERS THEN
2019: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2020: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2021: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_qual_record ');
2022: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_qual_rec_failed');
2023: raise FND_API.G_EXC_ERROR;
2024: END IF;
2025: END IF;
2026:
2027: l_qual_idx := l_qual_idx + 1;
2049: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2050: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2051: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_qual_record ');
2052: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_qual_rec_failed');
2053: raise FND_API.G_EXC_ERROR;
2054: END IF;
2055: END IF;
2056:
2057: l_qual_idx := l_qual_idx + 1;
2068: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2069: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2070: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_qual_record ');
2071: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_qual_rec_failed');
2072: raise FND_API.G_EXC_ERROR;
2073: END IF;
2074: END IF;
2075:
2076: ELSE
2091: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2092: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2093: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_qual_record ');
2094: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_qual_rec_failed');
2095: raise FND_API.G_EXC_ERROR;
2096: END IF;
2097: END IF;
2098:
2099: END IF;
2100:
2101: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2102:
2103: EXCEPTION
2104: WHEN FND_API.G_EXC_ERROR THEN
2105: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2106: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
2107:
2108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2104: WHEN FND_API.G_EXC_ERROR THEN
2105: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2106: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
2107:
2108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2109: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2110: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
2111:
2112: WHEN OTHERS THEN
2134: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2135: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2136: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_qual_record ');
2137: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_control_rec_failed');
2138: raise FND_API.G_EXC_ERROR;
2139: END IF;
2140: END IF;
2141:
2142: x_return_status := l_return_status;
2143:
2144: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2145:
2146: EXCEPTION
2147: WHEN FND_API.G_EXC_ERROR THEN
2148: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2149: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
2150:
2151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2147: WHEN FND_API.G_EXC_ERROR THEN
2148: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2149: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
2150:
2151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2152: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2153: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
2154:
2155: WHEN OTHERS THEN
3099:
3100: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
3101:
3102: EXCEPTION
3103: WHEN FND_API.G_EXC_ERROR THEN
3104: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3105: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
3106:
3107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3103: WHEN FND_API.G_EXC_ERROR THEN
3104: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3105: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
3106:
3107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3108: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3109: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
3110:
3111: WHEN OTHERS THEN
4460:
4461: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4462:
4463: EXCEPTION
4464: WHEN FND_API.G_EXC_ERROR THEN
4465: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4466: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
4467:
4468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4464: WHEN FND_API.G_EXC_ERROR THEN
4465: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4466: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
4467:
4468: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4469: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4470: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
4471:
4472: WHEN OTHERS THEN
4969: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4970: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4971: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After clear_globals ');
4972: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_clear_globals_fl');
4973: raise FND_API.G_EXC_ERROR;
4974: END IF;
4975: END IF;
4976:
4977: --initialize exception counts
5029: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
5030: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5031: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After create_engine_inputs ');
5032: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_cr_eng_inp_failed');
5033: raise FND_API.G_EXC_ERROR;
5034: END IF;
5035: END IF;
5036:
5037: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_implicit_non_dummy_cnt = '||x_exceptions_tab(i).implicit_non_dummy_cnt);
5061: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
5062: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5063: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After call_qp_api ');
5064: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_call_qp_api_failed');
5065: raise FND_API.G_EXC_ERROR;
5066: END IF;
5067: END IF;
5068:
5069:
5081: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
5082: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5083: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After check_tl_qp_output_errors ');
5084: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_chk_qp_output_failed');
5085: raise FND_API.G_EXC_ERROR;
5086: END IF;
5087: END IF;
5088:
5089:
5100: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
5101: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5102: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After check_qp_ipl_mulitple ');
5103: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_check_qp_ipl_failed');
5104: raise FND_API.G_EXC_ERROR;
5105: END IF;
5106: END IF;
5107:
5108:
5127: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
5128: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5129: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'After retrieve_qp_output_multiple ');
5130: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_tl_ret_qp_out_failed');
5131: raise FND_API.G_EXC_ERROR;
5132: END IF;
5133: END IF;
5134:
5135: Copy_Same_Rates(
5151:
5152: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5153:
5154: EXCEPTION
5155: WHEN FND_API.G_EXC_ERROR THEN
5156: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5157: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
5158:
5159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5155: WHEN FND_API.G_EXC_ERROR THEN
5156: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5157: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
5158:
5159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5160: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5161: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
5162:
5163: WHEN OTHERS THEN