DBA Data[Home] [Help]

APPS.FTE_TL_CORE dependencies on FND_API

Line 274: raise FND_API.G_EXC_ERROR;

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

Line 298: raise FND_API.G_EXC_ERROR;

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);

Line 320: raise FND_API.G_EXC_ERROR;

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);

Line 331: raise FND_API.G_EXC_ERROR;

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:

Line 344: raise FND_API.G_EXC_ERROR;

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:

Line 368: raise FND_API.G_EXC_ERROR;

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,

Line 380: WHEN FND_API.G_EXC_ERROR THEN

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

Line 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

Line 450: raise FND_API.G_EXC_ERROR;

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'

Line 505: raise FND_API.G_EXC_ERROR;

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;

Line 603: raise FND_API.G_EXC_ERROR;

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;

Line 655: raise FND_API.G_EXC_ERROR;

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;

Line 713: raise FND_API.G_EXC_ERROR;

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

Line 784: raise FND_API.G_EXC_ERROR;

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;

Line 823: raise FND_API.G_EXC_ERROR;

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:

Line 859: raise FND_API.G_EXC_ERROR;

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

Line 894: raise FND_API.G_EXC_ERROR;

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

Line 905: raise FND_API.G_EXC_ERROR;

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

Line 957: raise FND_API.G_EXC_ERROR;

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 ;

Line 1014: raise FND_API.G_EXC_ERROR;

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;

Line 1033: WHEN FND_API.G_EXC_ERROR THEN

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

Line 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

Line 1095: raise FND_API.G_EXC_ERROR;

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 (

Line 1110: raise FND_API.G_EXC_ERROR;

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 (

Line 1125: raise FND_API.G_EXC_ERROR;

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);

Line 1132: WHEN FND_API.G_EXC_ERROR THEN

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

Line 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

Line 1363: raise FND_API.G_EXC_ERROR;

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;

Line 1409: raise FND_API.G_EXC_ERROR;

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);

Line 1416: WHEN FND_API.G_EXC_ERROR THEN

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

Line 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

Line 1964: WHEN FND_API.G_EXC_ERROR 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

Line 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

Line 2023: raise FND_API.G_EXC_ERROR;

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;

Line 2053: raise FND_API.G_EXC_ERROR;

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;

Line 2072: raise FND_API.G_EXC_ERROR;

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

Line 2095: raise FND_API.G_EXC_ERROR;

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;

Line 2104: WHEN FND_API.G_EXC_ERROR THEN

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

Line 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

Line 2138: raise FND_API.G_EXC_ERROR;

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;

Line 2147: WHEN FND_API.G_EXC_ERROR THEN

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

Line 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

Line 3103: WHEN FND_API.G_EXC_ERROR 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

Line 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

Line 4464: WHEN FND_API.G_EXC_ERROR 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

Line 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

Line 4973: raise FND_API.G_EXC_ERROR;

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

Line 5033: raise FND_API.G_EXC_ERROR;

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);

Line 5065: raise FND_API.G_EXC_ERROR;

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:

Line 5085: raise FND_API.G_EXC_ERROR;

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:

Line 5104: raise FND_API.G_EXC_ERROR;

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:

Line 5131: raise FND_API.G_EXC_ERROR;

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(

Line 5155: WHEN FND_API.G_EXC_ERROR THEN

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

Line 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