APPS.FTE_TL_CORE dependencies on WSH_UTIL_CORE

Line 123: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

119: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
120: l_method_name VARCHAR2(50) := 'check_qp_ipl';
121:
122: BEGIN
123: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
124: fte_freight_pricing_util.reset_dbg_vars;
125: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
126:
127: -- l_non_dummy_row_count:=0;

Line 187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

183: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
184:
185: EXCEPTION
186: WHEN fte_freight_pricing_util.g_not_on_pricelist THEN
187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
188: -- can use tokens here
189: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_not_on_pricelist');
190: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Item quantity not found on pricelist ');
191: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);

Line 194: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

190: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Item quantity not found on pricelist ');
191: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
192:
193: WHEN OTHERS THEN
194: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
195: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
196: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
197: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
198:

Line 252: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

248: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
249: l_method_name VARCHAR2(50) := 'tl_core';
250: BEGIN
251:
252: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
253: fte_freight_pricing_util.reset_dbg_vars;
254: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
255:
256: -- create request lines

Line 270: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

266: -- First clear all global tables ***
267: g_req_line_info_tab.DELETE;
268: FTE_QP_ENGINE.clear_globals(x_return_status => l_return_status);
269:
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;

Line 271: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

267: g_req_line_info_tab.DELETE;
268: FTE_QP_ENGINE.clear_globals(x_return_status => l_return_status);
269:
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;

Line 294: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

290: p_carrier_pref => p_carrier_pref,
291: x_implicit_non_dummy_cnt => l_implicit_non_dummy_cnt,
292: x_return_status => l_return_status );
293:
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;

Line 295: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

291: x_implicit_non_dummy_cnt => l_implicit_non_dummy_cnt,
292: x_return_status => l_return_status );
293:
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;

Line 316: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

312: x_qp_output_line_rows => l_qp_output_line_rows,
313: x_qp_output_detail_rows => l_qp_output_detail_rows,
314: x_return_status => l_return_status);
315:
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;

Line 317: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

313: x_qp_output_detail_rows => l_qp_output_detail_rows,
314: x_return_status => l_return_status);
315:
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;

Line 327: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

323:
324: -- fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
325: fte_qp_engine.check_tl_qp_output_errors (x_return_status => l_return_status);
326:
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;

Line 328: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

324: -- fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
325: fte_qp_engine.check_tl_qp_output_errors (x_return_status => l_return_status);
326:
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;

Line 340: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

336: check_qp_ipl(p_qp_output_line_rows=>l_qp_output_line_rows,
337: p_implicit_non_dummy_cnt => l_implicit_non_dummy_cnt,
338: x_return_status => l_return_status );
339:
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;

Line 341: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

337: p_implicit_non_dummy_cnt => l_implicit_non_dummy_cnt,
338: x_return_status => l_return_status );
339:
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;

Line 364: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

360: x_trip_charges_rec => x_trip_charges_rec,
361: x_stop_charges_tab => x_stop_charges_tab,
362: x_return_status => l_return_status);
363:
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;

Line 365: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

361: x_stop_charges_tab => x_stop_charges_tab,
362: x_return_status => l_return_status);
363:
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;

Line 381: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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
385: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 385: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
389: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 389: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
389: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
390: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
391: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
392: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
393: END tl_core;

Line 429: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

425: -- create load line
426: -- create stop lines
427: -- create control rec
428:
429: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
430: fte_freight_pricing_util.reset_dbg_vars;
431: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
432:
433: x_implicit_non_dummy_cnt := 0;

Line 501: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

497: p_stop_tab => p_stop_tab,
498: p_carrier_pref => p_carrier_pref,
499: x_return_status => l_return_status);
500:
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;

Line 502: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

498: p_carrier_pref => p_carrier_pref,
499: x_return_status => l_return_status);
500:
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;

Line 599: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

595: p_stop_tab => p_stop_tab,
596: p_carrier_pref => p_carrier_pref,
597: x_return_status => l_return_status);
598:
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;

Line 600: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

596: p_carrier_pref => p_carrier_pref,
597: x_return_status => l_return_status);
598:
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;

Line 651: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

647: p_stop_tab => p_stop_tab,
648: p_carrier_pref => p_carrier_pref,
649: x_return_status => l_return_status);
650:
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;

Line 652: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

648: p_carrier_pref => p_carrier_pref,
649: x_return_status => l_return_status);
650:
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;

Line 709: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

705: p_stop_tab => p_stop_tab,
706: p_carrier_pref => p_carrier_pref,
707: x_return_status => l_return_status);
708:
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;

Line 710: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

706: p_carrier_pref => p_carrier_pref,
707: x_return_status => l_return_status);
708:
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;

Line 780: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

776: p_stop_tab => p_stop_tab,
777: p_carrier_pref => p_carrier_pref,
778: x_return_status => l_return_status);
779:
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;

Line 781: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

777: p_carrier_pref => p_carrier_pref,
778: x_return_status => l_return_status);
779:
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;

Line 819: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

815: p_stop_tab => p_stop_tab,
816: p_carrier_pref => p_carrier_pref,
817: x_return_status => l_return_status);
818:
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;

Line 820: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

816: p_carrier_pref => p_carrier_pref,
817: x_return_status => l_return_status);
818:
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;

Line 855: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

851: p_stop_tab => p_stop_tab,
852: p_carrier_pref => p_carrier_pref,
853: x_return_status => l_return_status);
854:
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;

Line 856: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

852: p_carrier_pref => p_carrier_pref,
853: x_return_status => l_return_status);
854:
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;

Line 890: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

886: p_stop_tab => p_stop_tab,
887: p_carrier_pref => p_carrier_pref,
888: x_return_status => l_return_status);
889:
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;

Line 891: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

887: p_carrier_pref => p_carrier_pref,
888: x_return_status => l_return_status);
889:
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;

Line 901: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

897:
898: -- create qp control record
899: create_control_rec ( x_return_status => l_return_status);
900:
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;

Line 902: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

898: -- create qp control record
899: create_control_rec ( x_return_status => l_return_status);
900:
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;

Line 953: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

949: p_stop_tab => p_stop_tab,
950: p_carrier_pref => p_carrier_pref,
951: x_return_status => l_return_status);
952:
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;

Line 954: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

950: p_carrier_pref => p_carrier_pref,
951: x_return_status => l_return_status);
952:
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;

Line 1010: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1006: p_stop_tab => p_stop_tab,
1007: p_carrier_pref => p_carrier_pref,
1008: x_return_status => l_return_status);
1009:
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;

Line 1011: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1007: p_carrier_pref => p_carrier_pref,
1008: x_return_status => l_return_status);
1009:
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;

Line 1034: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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
1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1038: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
1042: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1042: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
1042: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1043: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
1044: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1045: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1046:

Line 1072: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1068: l_method_name VARCHAR2(50) := 'create_input_line';
1069:
1070: BEGIN
1071:
1072: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1073: fte_freight_pricing_util.reset_dbg_vars;
1074: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
1075:
1076: l_pricing_control_rec.pricing_event_num := fte_freight_pricing.G_LINE_EVENT_NUM;

Line 1091: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1087: p_pricing_control_rec => l_pricing_control_rec,
1088: p_pricing_engine_input_rec => l_pricing_engine_input_rec,
1089: x_return_status => l_return_status );
1090:
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;

Line 1092: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1088: p_pricing_engine_input_rec => l_pricing_engine_input_rec,
1089: x_return_status => l_return_status );
1090:
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;

Line 1106: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1102: p_stop_tab => p_stop_tab,
1103: p_carrier_pref => p_carrier_pref,
1104: x_return_status => l_return_status);
1105:
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;

Line 1107: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1103: p_carrier_pref => p_carrier_pref,
1104: x_return_status => l_return_status);
1105:
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;

Line 1121: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1117: p_stop_tab => p_stop_tab,
1118: p_carrier_pref => p_carrier_pref,
1119: x_return_status => l_return_status);
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: 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;

Line 1122: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1118: p_carrier_pref => p_carrier_pref,
1119: x_return_status => l_return_status);
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: 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;

Line 1133: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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
1137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
1141: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1141: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
1141: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1142: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
1143: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1144: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1145:

Line 1168: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1164: l_attr_idx NUMBER :=0;
1165: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
1166: l_method_name VARCHAR2(50) := 'create_line_attributes';
1167: BEGIN
1168: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1169: fte_freight_pricing_util.reset_dbg_vars;
1170: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
1171:
1172:

Line 1359: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1355: p_carrier_pref => p_carrier_pref,
1356: x_pricing_attr_tab => l_pricing_attr_tab,
1357: x_return_status => l_return_status );
1358:
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;

Line 1360: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1356: x_pricing_attr_tab => l_pricing_attr_tab,
1357: x_return_status => l_return_status );
1358:
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;

Line 1405: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1401: p_input_index => p_req_line_rec.line_index,
1402: p_attr_rows => l_pricing_attr_tab,
1403: x_return_status => l_return_status );
1404:
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;

Line 1406: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1402: p_attr_rows => l_pricing_attr_tab,
1403: x_return_status => l_return_status );
1404:
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;

Line 1417: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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
1421: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1421: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
1425: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1425: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
1425: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1426: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
1427: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1428: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1429:

Line 1457: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1453: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
1454: l_method_name VARCHAR2(50) := 'create_charge_line_attributes';
1455:
1456: BEGIN
1457: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1458: fte_freight_pricing_util.reset_dbg_vars;
1459: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
1460:
1461: -- note : validate attribute source values before using them

Line 1965: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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
1969: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1969: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
1973: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1973: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
1973: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1974: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
1975: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1976: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
1977:

Line 1999: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1995: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
1996: l_method_name VARCHAR2(50) := 'create_line_qualifiers';
1997: BEGIN
1998:
1999: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2000: fte_freight_pricing_util.reset_dbg_vars;
2001: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
2002:
2003:

Line 2019: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2015: fte_qp_engine.create_qual_record (p_event_num => fte_qp_engine.G_LINE_EVENT_NUM,
2016: p_qual_rec => l_qual_rec,
2017: x_return_status => l_return_status);
2018:
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;

Line 2020: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2016: p_qual_rec => l_qual_rec,
2017: x_return_status => l_return_status);
2018:
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;

Line 2049: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2045: fte_qp_engine.create_qual_record (p_event_num => fte_qp_engine.G_LINE_EVENT_NUM,
2046: p_qual_rec => l_qual_rec,
2047: x_return_status => l_return_status);
2048:
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;

Line 2050: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2046: p_qual_rec => l_qual_rec,
2047: x_return_status => l_return_status);
2048:
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;

Line 2068: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2064: fte_qp_engine.create_qual_record (p_event_num => fte_qp_engine.G_LINE_EVENT_NUM,
2065: p_qual_rec => l_qual_rec,
2066: x_return_status => l_return_status);
2067:
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;

Line 2069: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2065: p_qual_rec => l_qual_rec,
2066: x_return_status => l_return_status);
2067:
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;

Line 2091: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2087: fte_qp_engine.create_qual_record (p_event_num => fte_qp_engine.G_LINE_EVENT_NUM,
2088: p_qual_rec => l_qual_rec,
2089: x_return_status => l_return_status);
2090:
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;

Line 2092: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2088: p_qual_rec => l_qual_rec,
2089: x_return_status => l_return_status);
2090:
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;

Line 2105: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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
2109: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2109: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
2113: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2113: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
2113: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2114: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
2115: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2116: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
2117:

Line 2127: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2123: l_return_status VARCHAR2(1);
2124: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
2125: l_method_name VARCHAR2(50) := 'create_control_rec';
2126: BEGIN
2127: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2128: fte_freight_pricing_util.reset_dbg_vars;
2129: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
2130:
2131: fte_qp_engine.create_control_record (p_event_num => fte_qp_engine.G_LINE_EVENT_NUM,

Line 2134: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2130:
2131: fte_qp_engine.create_control_record (p_event_num => fte_qp_engine.G_LINE_EVENT_NUM,
2132: x_return_status => l_return_status);
2133:
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;

Line 2135: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2131: fte_qp_engine.create_control_record (p_event_num => fte_qp_engine.G_LINE_EVENT_NUM,
2132: x_return_status => l_return_status);
2133:
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;

Line 2148: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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
2152: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2152: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
2156: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2156: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
2156: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2157: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
2158: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2159: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
2160:

Line 2199: --x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2195: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2196:
2197: EXCEPTION
2198: WHEN OTHERS THEN
2199: --x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2200: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
2201: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2202: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
2203:

Line 2249: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2245: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
2246: l_method_name VARCHAR2(50) := 'retrieve_qp_output';
2247:
2248: BEGIN
2249: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2250: fte_freight_pricing_util.reset_dbg_vars;
2251: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
2252:
2253: -- Loop through the line table

Line 3104: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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
3108: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3108: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
3112: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3112: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
3112: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3113: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
3114: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3115: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
3116:

Line 3452: IF p_api_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

3448: )
3449: IS
3450: BEGIN
3451: x_return_status := p_api_return_status; -- default
3452: IF p_api_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3453: THEN
3454: IF p_api_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
3455: THEN
3456: x_number_of_warnings := x_number_of_warnings + 1;

Line 3454: IF p_api_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

3450: BEGIN
3451: x_return_status := p_api_return_status; -- default
3452: IF p_api_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3453: THEN
3454: IF p_api_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
3455: THEN
3456: x_number_of_warnings := x_number_of_warnings + 1;
3457: ELSE
3458: IF p_api_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

Line 3458: IF p_api_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

3454: IF p_api_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
3455: THEN
3456: x_number_of_warnings := x_number_of_warnings + 1;
3457: ELSE
3458: IF p_api_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
3459: OR p_api_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
3460: THEN
3461: FND_MESSAGE.SET_NAME('FTE', p_message_name );
3462: FND_MESSAGE.SET_TOKEN('PROGRAM_UNIT_NAME', p_api_name);

Line 3459: OR p_api_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

3455: THEN
3456: x_number_of_warnings := x_number_of_warnings + 1;
3457: ELSE
3458: IF p_api_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
3459: OR p_api_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
3460: THEN
3461: FND_MESSAGE.SET_NAME('FTE', p_message_name );
3462: FND_MESSAGE.SET_TOKEN('PROGRAM_UNIT_NAME', p_api_name);
3463: IF p_trip_id IS NOT NULL

Line 3475: IF (p_api_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

3471: IF p_delivery_leg_id IS NOT NULL
3472: THEN
3473: FND_MESSAGE.SET_TOKEN('DELIVERY_LEG_ID', p_delivery_leg_id);
3474: END IF;
3475: IF (p_api_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
3476: THEN
3477: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3478: x_return_status := p_api_return_status;
3479: ELSE

Line 3477: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

3473: FND_MESSAGE.SET_TOKEN('DELIVERY_LEG_ID', p_delivery_leg_id);
3474: END IF;
3475: IF (p_api_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
3476: THEN
3477: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3478: x_return_status := p_api_return_status;
3479: ELSE
3480: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);
3481: x_return_status := p_api_return_status;

Line 3480: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);

3476: THEN
3477: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3478: x_return_status := p_api_return_status;
3479: ELSE
3480: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);
3481: x_return_status := p_api_return_status;
3482: END IF;
3483: RETURN;
3484: ELSE

Line 3493: wsh_util_core.default_handler(G_PKG_NAME||'.API_POST_CALL');

3489: END IF;
3490:
3491: EXCEPTION
3492: WHEN OTHERS THEN
3493: wsh_util_core.default_handler(G_PKG_NAME||'.API_POST_CALL');
3494: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3495: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3496: END api_post_call;
3497:

Line 3494: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

3490:
3491: EXCEPTION
3492: WHEN OTHERS THEN
3493: wsh_util_core.default_handler(G_PKG_NAME||'.API_POST_CALL');
3494: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3495: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3496: END api_post_call;
3497:
3498:

Line 3495: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3491: EXCEPTION
3492: WHEN OTHERS THEN
3493: wsh_util_core.default_handler(G_PKG_NAME||'.API_POST_CALL');
3494: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3495: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3496: END api_post_call;
3497:
3498:
3499:

Line 3546: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3542: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
3543: l_method_name VARCHAR2(50) := 'retrieve_qp_output_multiple';
3544:
3545: BEGIN
3546: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3547: fte_freight_pricing_util.reset_dbg_vars;
3548: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
3549:
3550:

Line 4465: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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
4469: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4469: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
4473: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4473: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
4473: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4474: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
4475: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4476: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
4477:

Line 4513: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4509: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
4510: l_method_name VARCHAR2(50) := 'check_qp_ipl';
4511:
4512: BEGIN
4513: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4514: fte_freight_pricing_util.reset_dbg_vars;
4515: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
4516:
4517: -- l_non_dummy_row_count:=0;

Line 4597: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4593: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4594:
4595: EXCEPTION
4596: WHEN fte_freight_pricing_util.g_not_on_pricelist THEN
4597: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4598: -- can use tokens here
4599: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_not_on_pricelist');
4600: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Item quantity not found on pricelist ');
4601: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);

Line 4604: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4600: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Item quantity not found on pricelist ');
4601: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4602:
4603: WHEN OTHERS THEN
4604: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4605: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
4606: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4607: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
4608:

Line 4635: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4631:
4632: l_log_level NUMBER := fte_freight_pricing_util.G_LOG;
4633: l_method_name VARCHAR2(50) := 'check_tl_qp_op_err_multiple';
4634: BEGIN
4635: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4636: fte_freight_pricing_util.reset_dbg_vars;
4637: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
4638:
4639: --init tab variables

Line 4766: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4762:
4763: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4764: EXCEPTION
4765: WHEN fte_freight_pricing_util.g_not_on_pricelist THEN
4766: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4767: -- can use tokens here
4768: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_not_on_pricelist');
4769: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Following item quantity not found on pricelist :');
4770: l_category := FTE_QP_ENGINE.g_I_line_extras_tbl(i).category_id;

Line 4775: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4771: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,' Quantity = '||FTE_QP_ENGINE.g_I_line_quantity(i)||' '||FTE_QP_ENGINE.g_I_line_uom_code(i));
4772: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,' CategoryId = '||nvl(l_category,'Consolidated'));
4773: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4774: WHEN fte_freight_pricing_util.g_qp_price_request_failed THEN
4775: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4776: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed');
4777: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4778: WHEN others THEN
4779: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4779: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4775: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4776: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed');
4777: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4778: WHEN others THEN
4779: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4780: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
4781: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4782: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4783:

Line 4807: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4803: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
4804: l_method_name VARCHAR2(50) := 'Identify_Same_Rate_Inputs';
4805:
4806: BEGIN
4807: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4808: fte_freight_pricing_util.reset_dbg_vars;
4809: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
4810:
4811: x_same_rate_map.delete;

Line 4846: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4842:
4843: EXCEPTION
4844:
4845: WHEN OTHERS THEN
4846: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4847: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
4848: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4849: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
4850: END Identify_Same_Rate_Inputs;

Line 4873: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4869: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
4870: l_method_name VARCHAR2(50) := 'Copy_Same_Rates';
4871:
4872: BEGIN
4873: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4874: fte_freight_pricing_util.reset_dbg_vars;
4875: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
4876:
4877: i:=p_same_rate_map.FIRST;

Line 4911: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4907:
4908: EXCEPTION
4909:
4910: WHEN OTHERS THEN
4911: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4912: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
4913: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4914: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
4915:

Line 4951: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4947: l_method_name VARCHAR2(50) := 'TL_Core_Multiple';
4948:
4949: BEGIN
4950:
4951: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4952: fte_freight_pricing_util.reset_dbg_vars;
4953: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
4954:
4955: -- create request lines

Line 4969: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

4965: -- First clear all global tables ***
4966: g_req_line_info_tab.DELETE;
4967: FTE_QP_ENGINE.clear_globals(x_return_status => l_return_status);
4968:
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;

Line 4970: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4966: g_req_line_info_tab.DELETE;
4967: FTE_QP_ENGINE.clear_globals(x_return_status => l_return_status);
4968:
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;

Line 5029: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

5025: p_trip_index =>i,
5026: x_implicit_non_dummy_cnt => x_exceptions_tab(i).implicit_non_dummy_cnt,
5027: x_return_status => l_return_status );
5028:
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;

Line 5030: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

5026: x_implicit_non_dummy_cnt => x_exceptions_tab(i).implicit_non_dummy_cnt,
5027: x_return_status => l_return_status );
5028:
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;

Line 5061: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

5057: x_qp_output_line_rows => l_qp_output_line_rows,
5058: x_qp_output_detail_rows => l_qp_output_detail_rows,
5059: x_return_status => l_return_status);
5060:
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;

Line 5062: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

5058: x_qp_output_detail_rows => l_qp_output_detail_rows,
5059: x_return_status => l_return_status);
5060:
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;

Line 5081: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

5077: p_req_line_info_tab =>g_req_line_info_tab,
5078: x_exceptions=>x_exceptions_tab,
5079: x_return_status=>l_return_status);
5080:
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;

Line 5082: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

5078: x_exceptions=>x_exceptions_tab,
5079: x_return_status=>l_return_status);
5080:
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;

Line 5100: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

5096: p_qp_output_line_rows=>l_qp_output_line_rows,
5097: x_exceptions=>x_exceptions_tab,
5098: x_return_status=> l_return_status );
5099:
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;

Line 5101: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

5097: x_exceptions=>x_exceptions_tab,
5098: x_return_status=> l_return_status );
5099:
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;

Line 5127: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

5123: x_trip_charges_tab => x_trip_charges_tab,
5124: x_stop_charges_tab => x_stop_charges_tab,
5125: x_return_status => l_return_status);
5126:
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;

Line 5128: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

5124: x_stop_charges_tab => x_stop_charges_tab,
5125: x_return_status => l_return_status);
5126:
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;

Line 5156: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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
5160: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 5160: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
5164: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 5164: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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
5164: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5165: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
5166: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
5167: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
5168: END TL_Core_Multiple;