eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_QP_ENGINE dependencies on WSH_UTIL_CORE

Line 30: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

26: l_return_status VARCHAR2(1);
27: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
28: l_method_name VARCHAR2(50) := 'get_total_base_price';
29: BEGIN
30: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
31: fte_freight_pricing_util.reset_dbg_vars;
32: fte_freight_pricing_util.set_method(l_log_level,'get_total_base_price');
33:
34: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'p_set_num = '||p_set_num);

Line 62: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

58:
59: fte_freight_pricing_util.unset_method(l_log_level,'get_total_base_price');
60: EXCEPTION
61: WHEN others THEN
62: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
63: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
64: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
65: fte_freight_pricing_util.unset_method(l_log_level,'get_total_base_price');
66:

Line 85: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

81: l_return_status VARCHAR2(1);
82: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
83: l_method_name VARCHAR2(50) := 'apply_new_base_price';
84: BEGIN
85: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
86: fte_freight_pricing_util.reset_dbg_vars;
87: fte_freight_pricing_util.set_method(l_log_level,'apply_new_base_price');
88:
89: -- first get total base price for the ratio

Line 96: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

92: x_price => l_total_base_price,
93: x_return_status => l_return_status);
94:
95: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after get_total_base_price ');
96: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
97: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
98: raise FTE_FREIGHT_PRICING_UTIL.g_total_base_price_failed;
99: END IF;
100: ELSE

Line 97: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

93: x_return_status => l_return_status);
94:
95: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after get_total_base_price ');
96: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
97: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
98: raise FTE_FREIGHT_PRICING_UTIL.g_total_base_price_failed;
99: END IF;
100: ELSE
101: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_DBG,'l_total_base_price = '||l_total_base_price);

Line 123: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

119:
120: fte_freight_pricing_util.unset_method(l_log_level,'apply_new_base_price');
121: EXCEPTION
122: WHEN FTE_FREIGHT_PRICING_UTIL.g_total_base_price_failed THEN
123: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
124: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'total_base_price_failed');
125: fte_freight_pricing_util.unset_method(l_log_level,'apply_new_base_price');
126: WHEN others THEN
127: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 127: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

123: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
124: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'total_base_price_failed');
125: fte_freight_pricing_util.unset_method(l_log_level,'apply_new_base_price');
126: WHEN others THEN
127: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
128: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
129: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
130: fte_freight_pricing_util.unset_method(l_log_level,'apply_new_base_price');
131:

Line 176: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

172: l_curr_uom_unit_price NUMBER:=0;
173: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
174: l_method_name VARCHAR2(50) := 'analyse_output_for_deficit_wt';
175: BEGIN
176: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
177: fte_freight_pricing_util.reset_dbg_vars;
178: fte_freight_pricing_util.set_method(l_log_level,'analyse_output_for_deficit_wt');
179:
180: -- scan for commodities

Line 260: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

256:
257: fte_freight_pricing_util.unset_method(l_log_level,'analyse_output_for_deficit_wt');
258: EXCEPTION
259: WHEN others THEN
260: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
261: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
262: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
263: fte_freight_pricing_util.unset_method(l_log_level,'analyse_output_for_deficit_wt');
264:

Line 273: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

269: IS
270: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
271: l_method_name VARCHAR2(50) := 'clear_qp_input';
272: BEGIN
273: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
274: fte_freight_pricing_util.reset_dbg_vars;
275: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
276:
277: g_I_control_rec := null;

Line 348: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

344:
345: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
346: EXCEPTION
347: WHEN others THEN
348: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
349: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
350: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
351: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
352: END clear_qp_input;

Line 365: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

361: l_return_status VARCHAR2(1);
362: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
363: l_method_name VARCHAR2(50) := 'delete_line_from_qp_input';
364: BEGIN
365: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
366: fte_freight_pricing_util.reset_dbg_vars;
367: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
368:
369: fte_freight_pricing_util.print_msg(l_log_level,'p_line_index = '||p_line_index);

Line 455: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

451:
452: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
453: EXCEPTION
454: WHEN others THEN
455: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
456: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
457: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
458: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
459:

Line 472: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

468: l_return_status VARCHAR2(1);
469: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
470: l_method_name VARCHAR2(50) := 'delete_line_from_qp_output';
471: BEGIN
472: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
473: fte_freight_pricing_util.reset_dbg_vars;
474: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
475:
476: fte_freight_pricing_util.print_msg(l_log_level,'p_line_index = '||p_line_index);

Line 498: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

494:
495: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
496: EXCEPTION
497: WHEN others THEN
498: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
499: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
500: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
501: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
502: END delete_line_from_qp_output;

Line 513: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

509: l_return_status VARCHAR2(1);
510: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
511: l_method_name VARCHAR2(50) := 'delete_set_from_line_event';
512: BEGIN
513: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
514: fte_freight_pricing_util.reset_dbg_vars;
515: fte_freight_pricing_util.set_method(l_log_level,'delete_set_from_line_event');
516:
517: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_DBG,'p_set_num ='||p_set_num);

Line 531: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

527: delete_line_from_qp_input(
528: p_line_index => i,
529: x_return_status => l_return_status);
530:
531: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
532: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
533: raise FTE_FREIGHT_PRICING_UTIL.g_delete_set_failed;
534: END IF;
535:

Line 532: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

528: p_line_index => i,
529: x_return_status => l_return_status);
530:
531: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
532: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
533: raise FTE_FREIGHT_PRICING_UTIL.g_delete_set_failed;
534: END IF;
535:
536: delete_line_from_qp_output(

Line 540: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

536: delete_line_from_qp_output(
537: p_line_index => i,
538: x_return_status => l_return_status);
539:
540: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
541: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
542: raise FTE_FREIGHT_PRICING_UTIL.g_delete_set_failed;
543: END IF;
544:

Line 541: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

537: p_line_index => i,
538: x_return_status => l_return_status);
539:
540: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
541: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
542: raise FTE_FREIGHT_PRICING_UTIL.g_delete_set_failed;
543: END IF;
544:
545: END IF;

Line 554: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

550:
551: fte_freight_pricing_util.unset_method(l_log_level,'delete_set_from_line_event');
552: EXCEPTION
553: WHEN FTE_FREIGHT_PRICING_UTIL.g_delete_set_failed THEN
554: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
555: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'delete_set_failed');
556: fte_freight_pricing_util.unset_method(l_log_level,'delete_set_from_line_event');
557: WHEN others THEN
558: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 558: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

554: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
555: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'delete_set_failed');
556: fte_freight_pricing_util.unset_method(l_log_level,'delete_set_from_line_event');
557: WHEN others THEN
558: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
559: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
560: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
561: fte_freight_pricing_util.unset_method(l_log_level,'delete_set_from_line_event');
562: END delete_set_from_line_event;

Line 577: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

573: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
574: l_method_name VARCHAR2(50) := 'delete_lines';
575: BEGIN
576:
577: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
578: fte_freight_pricing_util.reset_dbg_vars;
579: fte_freight_pricing_util.set_method(l_log_level,'delete_lines');
580:
581: delete_line_from_qp_input(

Line 585: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

581: delete_line_from_qp_input(
582: p_line_index => p_line_index,
583: x_return_status => l_return_status);
584:
585: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
586: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
587: raise FTE_FREIGHT_PRICING_UTIL.g_delete_qpline_failed;
588: END IF;
589:

Line 586: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

582: p_line_index => p_line_index,
583: x_return_status => l_return_status);
584:
585: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
586: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
587: raise FTE_FREIGHT_PRICING_UTIL.g_delete_qpline_failed;
588: END IF;
589:
590: delete_line_from_qp_output(

Line 594: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

590: delete_line_from_qp_output(
591: p_line_index => p_line_index,
592: x_return_status => l_return_status);
593:
594: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
595: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
596: raise FTE_FREIGHT_PRICING_UTIL.g_delete_qpline_failed;
597: END IF;
598:

Line 595: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

591: p_line_index => p_line_index,
592: x_return_status => l_return_status);
593:
594: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
595: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
596: raise FTE_FREIGHT_PRICING_UTIL.g_delete_qpline_failed;
597: END IF;
598:
599: x_qp_output_line_rows := g_O_line_tbl;

Line 605: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

601:
602: fte_freight_pricing_util.unset_method(l_log_level,'delete_lines');
603: EXCEPTION
604: WHEN FTE_FREIGHT_PRICING_UTIL.g_delete_qpline_failed THEN
605: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
606: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'delete_qpline_failed');
607: fte_freight_pricing_util.unset_method(l_log_level,'delete_lines');
608: WHEN others THEN
609: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 609: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

605: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
606: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'delete_qpline_failed');
607: fte_freight_pricing_util.unset_method(l_log_level,'delete_lines');
608: WHEN others THEN
609: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
610: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
611: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
612: fte_freight_pricing_util.unset_method(l_log_level,'delete_lines');
613:

Line 717: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

713: l_old_last_index NUMBER;
714: i NUMBER;
715: l_current_index NUMBER;
716: BEGIN
717: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
718: fte_freight_pricing_util.reset_dbg_vars;
719: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
720:
721: -- work on the lines first

Line 788: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

784:
785: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
786: EXCEPTION
787: WHEN others THEN
788: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
789: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
790: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
791: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
792: END remove_gaps;

Line 805: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

801: l_return_status VARCHAR2(1);
802: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
803: l_method_name VARCHAR2(50) := 'prepare_next_event_request';
804: BEGIN
805: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
806: fte_freight_pricing_util.reset_dbg_vars;
807: fte_freight_pricing_util.set_method(l_log_level,'prepare_next_event_request');
808:
809: --modify event 1 input based on event 1 output to make it event 2 input

Line 832: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

828: END LOOP;
829: END IF;
830:
831: remove_gaps(x_return_status => l_return_status);
832: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
833: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
834: raise FTE_FREIGHT_PRICING_UTIL.g_remove_gaps_failed;
835: END IF;
836:

Line 833: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

829: END IF;
830:
831: remove_gaps(x_return_status => l_return_status);
832: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
833: and l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
834: raise FTE_FREIGHT_PRICING_UTIL.g_remove_gaps_failed;
835: END IF;
836:
837: fte_freight_pricing_util.unset_method(l_log_level,'prepare_next_event_request');

Line 840: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

836:
837: fte_freight_pricing_util.unset_method(l_log_level,'prepare_next_event_request');
838: EXCEPTION
839: WHEN FTE_FREIGHT_PRICING_UTIL.g_remove_gaps_failed THEN
840: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
841: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'remove_gaps_failed');
842: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
843: WHEN others THEN
844: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 844: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

840: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
841: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'remove_gaps_failed');
842: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
843: WHEN others THEN
844: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
845: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
846: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
847: fte_freight_pricing_util.unset_method(l_log_level,'prepare_next_event_request');
848:

Line 866: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

862: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
863: l_method_name VARCHAR2(50) := 'create_control_record';
864: BEGIN
865:
866: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
867: fte_freight_pricing_util.reset_dbg_vars;
868: fte_freight_pricing_util.set_method(l_log_level,'create_control_record');
869:
870: l_control_rec.pricing_event := g_engine_defaults_tab(p_event_num).pricing_event_code;

Line 883: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

879:
880: fte_freight_pricing_util.unset_method(l_log_level,'create_control_record');
881: EXCEPTION
882: WHEN others THEN
883: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
884: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
885: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
886: fte_freight_pricing_util.unset_method(l_log_level,'create_control_record');
887: END create_control_record;

Line 901: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

897: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
898: l_method_name VARCHAR2(50) := 'create_line_record';
899: BEGIN
900:
901: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
902: fte_freight_pricing_util.reset_dbg_vars;
903: fte_freight_pricing_util.set_method(l_log_level,'create_line_record');
904:
905: l_event_num := p_pricing_control_rec.pricing_event_num;

Line 954: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

950:
951: fte_freight_pricing_util.unset_method(l_log_level,'create_line_record');
952: EXCEPTION
953: WHEN others THEN
954: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
955: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
956: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
957: fte_freight_pricing_util.unset_method(l_log_level,'create_line_record');
958: END create_line_record;

Line 971: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

967: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
968: l_method_name VARCHAR2(50) := 'create_qual_record';
969: BEGIN
970:
971: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
972: fte_freight_pricing_util.reset_dbg_vars;
973: -- fte_freight_pricing_util.set_method(l_log_level,'create_qual_record');
974: -- fte_freight_pricing_util.print_msg(l_log_level,'p_qual_rec.input_index='||p_qual_rec.input_index);
975: -- fte_freight_pricing_util.print_msg(l_log_level,'p_qual_rec.qualifier_name='||p_qual_rec.qualifier_name);

Line 1048: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1044:
1045: -- fte_freight_pricing_util.unset_method(l_log_level,'create_qual_record');
1046: EXCEPTION
1047: WHEN others THEN
1048: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1049: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
1050: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1051: fte_freight_pricing_util.unset_method(l_log_level,'create_qual_record');
1052: END create_qual_record;

Line 1090: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1086: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
1087: l_method_name VARCHAR2(50) := 'create_attr_record';
1088: BEGIN
1089:
1090: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1091: fte_freight_pricing_util.reset_dbg_vars;
1092: -- fte_freight_pricing_util.set_method(l_log_level,'create_attr_record');
1093:
1094: j := g_I_A_LINE_INDEX.COUNT + 1;

Line 1396: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1392:
1393: -- fte_freight_pricing_util.unset_method(l_log_level,'create_attr_record');
1394: EXCEPTION
1395: WHEN others THEN
1396: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1397: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
1398: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1399: fte_freight_pricing_util.unset_method(l_log_level,'create_attr_record');
1400: END create_attr_record;

Line 1417: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1413: j NUMBER;
1414: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
1415: l_method_name VARCHAR2(50) := 'prepare_qp_line_attributes';
1416: BEGIN
1417: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1418: fte_freight_pricing_util.reset_dbg_vars;
1419: fte_freight_pricing_util.set_method(l_log_level,'prepare_qp_line_attributes');
1420:
1421: i := p_attr_rows.FIRST;

Line 1430: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1426: p_attr_rec => p_attr_rows(i),
1427: x_return_status => l_return_status);
1428:
1429: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after create_attr_record -1 ');
1430: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1431: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1432: raise FTE_FREIGHT_PRICING_UTIL.g_create_attribute_failed;
1433: END IF;
1434: END IF;

Line 1431: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1427: x_return_status => l_return_status);
1428:
1429: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after create_attr_record -1 ');
1430: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1431: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1432: raise FTE_FREIGHT_PRICING_UTIL.g_create_attribute_failed;
1433: END IF;
1434: END IF;
1435:

Line 1452: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1448: p_attr_rec => l_pricing_attr_rec,
1449: x_return_status => l_return_status);
1450:
1451: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after create_attr_record -2 ');
1452: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1453: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1454: raise FTE_FREIGHT_PRICING_UTIL.g_create_attribute_failed;
1455: END IF;
1456: END IF;

Line 1453: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1449: x_return_status => l_return_status);
1450:
1451: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after create_attr_record -2 ');
1452: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1453: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1454: raise FTE_FREIGHT_PRICING_UTIL.g_create_attribute_failed;
1455: END IF;
1456: END IF;
1457:

Line 1461: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1457:
1458: fte_freight_pricing_util.unset_method(l_log_level,'prepare_qp_line_attributes');
1459: EXCEPTION
1460: WHEN FTE_FREIGHT_PRICING_UTIL.g_create_attribute_failed THEN
1461: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1462: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'create_attribute_failed');
1463: fte_freight_pricing_util.unset_method(l_log_level,'prepare_qp_line_attributes');
1464: WHEN others THEN
1465: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1465: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1461: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1462: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'create_attribute_failed');
1463: fte_freight_pricing_util.unset_method(l_log_level,'prepare_qp_line_attributes');
1464: WHEN others THEN
1465: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1466: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
1467: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1468: fte_freight_pricing_util.unset_method(l_log_level,'prepare_qp_line_attributes');
1469:

Line 1482: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1478: l_return_status VARCHAR2(1);
1479: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
1480: l_method_name VARCHAR2(50) := 'prepare_qp_line_qualifiers';
1481: BEGIN
1482: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1483: fte_freight_pricing_util.reset_dbg_vars;
1484: fte_freight_pricing_util.set_method(l_log_level,'prepare_qp_line_qualifiers');
1485:
1486: l_qual_rec.qualifier_index := 1;

Line 1495: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1491: p_qual_rec => l_qual_rec,
1492: x_return_status => l_return_status);
1493:
1494: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after create_qual_record -1 ');
1495: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1496: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1497: raise FTE_FREIGHT_PRICING_UTIL.g_create_qual_record_failed;
1498: END IF;
1499: END IF;

Line 1496: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1492: x_return_status => l_return_status);
1493:
1494: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after create_qual_record -1 ');
1495: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1496: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1497: raise FTE_FREIGHT_PRICING_UTIL.g_create_qual_record_failed;
1498: END IF;
1499: END IF;
1500:

Line 1511: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1507: p_qual_rec => l_qual_rec,
1508: x_return_status => l_return_status);
1509:
1510: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after create_qual_record -2 ');
1511: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1512: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1513: raise FTE_FREIGHT_PRICING_UTIL.g_create_qual_record_failed;
1514: END IF;
1515: END IF;

Line 1512: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1508: x_return_status => l_return_status);
1509:
1510: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after create_qual_record -2 ');
1511: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1512: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1513: raise FTE_FREIGHT_PRICING_UTIL.g_create_qual_record_failed;
1514: END IF;
1515: END IF;
1516:

Line 1520: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1516:
1517: fte_freight_pricing_util.unset_method(l_log_level,'prepare_qp_line_qualifiers');
1518: EXCEPTION
1519: WHEN FTE_FREIGHT_PRICING_UTIL.g_create_qual_record_failed THEN
1520: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1521: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'create_qual_record_failed');
1522: fte_freight_pricing_util.unset_method(l_log_level,'prepare_qp_line_qualifiers');
1523: WHEN others THEN
1524: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1524: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1520: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1521: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'create_qual_record_failed');
1522: fte_freight_pricing_util.unset_method(l_log_level,'prepare_qp_line_qualifiers');
1523: WHEN others THEN
1524: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1525: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
1526: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1527: fte_freight_pricing_util.unset_method(l_log_level,'prepare_qp_line_qualifiers');
1528:

Line 1549: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1545: l_return_status VARCHAR2(1);
1546: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
1547: l_method_name VARCHAR2(50) := 'add_qp_output_detail';
1548: BEGIN
1549: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1550: fte_freight_pricing_util.reset_dbg_vars;
1551: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
1552:
1553: fte_freight_pricing_util.print_msg(l_log_level,'p_line_index:'||p_line_index);

Line 1575: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1571:
1572: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
1573: EXCEPTION
1574: WHEN others THEN
1575: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1576: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
1577: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1578: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
1579: END add_qp_output_detail;

Line 1589: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1585: l_category VARCHAR2(30);
1586: l_log_level NUMBER := fte_freight_pricing_util.G_LOG;
1587: l_method_name VARCHAR2(50) := 'check_qp_output_errors';
1588: BEGIN
1589: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1590: fte_freight_pricing_util.reset_dbg_vars;
1591: fte_freight_pricing_util.set_method(l_log_level,'check_output_errors');
1592:
1593: i := g_O_line_tbl.FIRST;

Line 1649: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1645:
1646: fte_freight_pricing_util.unset_method(l_log_level,'check_output_errors');
1647: EXCEPTION
1648: WHEN fte_freight_pricing_util.g_not_on_pricelist THEN
1649: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1650: -- can use tokens here
1651: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_not_on_pricelist');
1652: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Following item quantity not found on pricelist :');
1653: l_category := g_I_line_extras_tbl(i).category_id;

Line 1658: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1654: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,' Quantity = '||g_I_line_quantity(i)||' '||g_I_line_uom_code(i));
1655: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,' CategoryId = '||nvl(l_category,'Consolidated'));
1656: fte_freight_pricing_util.unset_method(l_log_level,'check_output_errors');
1657: WHEN fte_freight_pricing_util.g_qp_price_request_failed THEN
1658: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1659: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed');
1660: fte_freight_pricing_util.unset_method(l_log_level,'check_output_errors');
1661: WHEN others THEN
1662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1658: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1659: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed');
1660: fte_freight_pricing_util.unset_method(l_log_level,'check_output_errors');
1661: WHEN others THEN
1662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1663: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
1664: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1665: fte_freight_pricing_util.unset_method(l_log_level,'check_output_errors');
1666:

Line 1679: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1675: l_line_cnt NUMBER := 0;
1676: l_log_level NUMBER := fte_freight_pricing_util.G_LOG;
1677: l_method_name VARCHAR2(50) := 'check_tl_qp_output_errors';
1678: BEGIN
1679: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1680: fte_freight_pricing_util.reset_dbg_vars;
1681: fte_freight_pricing_util.set_method(l_log_level,'check_tl_qp_output_errors');
1682:
1683: i := g_O_line_tbl.FIRST;

Line 1755: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1751:
1752: fte_freight_pricing_util.unset_method(l_log_level,'check_tl_qp_output_errors');
1753: EXCEPTION
1754: WHEN fte_freight_pricing_util.g_not_on_pricelist THEN
1755: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1756: -- can use tokens here
1757: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_not_on_pricelist');
1758: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Following item quantity not found on pricelist :');
1759: l_category := g_I_line_extras_tbl(i).category_id;

Line 1764: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1760: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,' Quantity = '||g_I_line_quantity(i)||' '||g_I_line_uom_code(i));
1761: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,' CategoryId = '||nvl(l_category,'Consolidated'));
1762: fte_freight_pricing_util.unset_method(l_log_level,'check_tl_qp_output_errors');
1763: WHEN fte_freight_pricing_util.g_qp_price_request_failed THEN
1764: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1765: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed');
1766: fte_freight_pricing_util.unset_method(l_log_level,'check_tl_qp_output_errors');
1767: WHEN others THEN
1768: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1768: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1764: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1765: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed');
1766: fte_freight_pricing_util.unset_method(l_log_level,'check_tl_qp_output_errors');
1767: WHEN others THEN
1768: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1769: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
1770: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1771: fte_freight_pricing_util.unset_method(l_log_level,'check_tl_qp_output_errors');
1772:

Line 1828: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1824: -- x_return_status := ERROR;
1825: -- x_return_code := 0;
1826:
1827:
1828: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1829: x_return_code := 0;
1830: fte_freight_pricing_util.reset_dbg_vars;
1831: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
1832:

Line 1997: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1993:
1994: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
1995: EXCEPTION
1996: WHEN fte_freight_pricing_util.g_not_on_pricelist THEN
1997: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1998: -- can use tokens here
1999: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_not_on_pricelist');
2000: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Following item quantity not found on pricelist :');
2001: l_category := g_I_line_extras_tbl(i).category_id;

Line 2006: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2002: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,' Quantity = '||g_I_line_quantity(i)||' '||g_I_line_uom_code(i));
2003: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,' CategoryId = '||nvl(l_category,'Consolidated'));
2004: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2005: WHEN fte_freight_pricing_util.g_qp_price_request_failed THEN
2006: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2007: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed');
2008: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2009: WHEN others THEN
2010: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2010: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2006: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2007: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed');
2008: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2009: WHEN others THEN
2010: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2011: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
2012: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2013: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2014:

Line 2027: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2023: l_return_status VARCHAR2(1);
2024: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
2025: l_method_name VARCHAR2(50) := 'get_qp_output';
2026: BEGIN
2027: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2028: fte_freight_pricing_util.reset_dbg_vars;
2029: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
2030:
2031: x_qp_output_line_rows := g_O_line_tbl;

Line 2037: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2033:
2034: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2035: EXCEPTION
2036: WHEN others THEN
2037: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2038: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
2039: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2040: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2041: END get_qp_output;

Line 2144: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2140:
2141: i NUMBER;
2142:
2143: BEGIN
2144: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2145: fte_freight_pricing_util.reset_dbg_vars;
2146: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
2147:
2148: g_O_line_tbl.DELETE;

Line 2268: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2264:
2265: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2266: EXCEPTION
2267: WHEN others THEN
2268: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2269: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
2270: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2271: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2272:

Line 2640: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2636:
2637: l_log_level NUMBER := fte_freight_pricing_util.G_LOG;
2638: l_method_name VARCHAR2(50) := 'call_qp_api';
2639: BEGIN
2640: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2641: fte_freight_pricing_util.reset_dbg_vars;
2642: fte_freight_pricing_util.set_method(l_log_level,'call_qp_api');
2643:
2644: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,

Line 2763: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2759: x_qp_output_detail_rows => x_qp_output_detail_rows,
2760: x_return_status => l_return_status);
2761:
2762: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after populate qp output');
2763: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2764: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2765: raise FTE_FREIGHT_PRICING_UTIL.g_qp_price_request_failed;
2766: END IF;
2767: END IF;

Line 2764: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2760: x_return_status => l_return_status);
2761:
2762: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after populate qp output');
2763: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2764: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2765: raise FTE_FREIGHT_PRICING_UTIL.g_qp_price_request_failed;
2766: END IF;
2767: END IF;
2768:

Line 2778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2774: fte_freight_pricing_util.unset_method(l_log_level,'call_qp_api');
2775: EXCEPTION
2776: WHEN FTE_FREIGHT_PRICING_UTIL.g_qp_price_request_failed THEN
2777: --x_return_status := l_return_status;
2778: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2779: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'qp_price_request_failed');
2780: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Return status = '||l_return_status);
2781: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Return status text = '||l_return_status_text);
2782: fte_freight_pricing_util.unset_method(l_log_level,'call_qp_api');

Line 2784: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2780: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Return status = '||l_return_status);
2781: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Return status text = '||l_return_status_text);
2782: fte_freight_pricing_util.unset_method(l_log_level,'call_qp_api');
2783: WHEN FTE_FREIGHT_PRICING_UTIL.g_qp_insert_lines2_failed THEN
2784: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2785: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'qp_insert_lines2_failed');
2786: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Return status = '||l_return_status);
2787: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Return status text = '||l_return_status_text);
2788: fte_freight_pricing_util.unset_method(l_log_level,'call_qp_api');

Line 2790: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2786: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Return status = '||l_return_status);
2787: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Return status text = '||l_return_status_text);
2788: fte_freight_pricing_util.unset_method(l_log_level,'call_qp_api');
2789: WHEN FTE_FREIGHT_PRICING_UTIL.g_qp_insert_line_attrs2_failed THEN
2790: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2791: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'qp_insert_line_attrs2_failed');
2792: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Return status = '||l_return_status);
2793: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Return status text = '||l_return_status_text);
2794: fte_freight_pricing_util.unset_method(l_log_level,'call_qp_api');

Line 2796: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2792: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Return status = '||l_return_status);
2793: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Return status text = '||l_return_status_text);
2794: fte_freight_pricing_util.unset_method(l_log_level,'call_qp_api');
2795: WHEN others THEN
2796: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2797: print_qp_output();
2798: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
2799: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2800: fte_freight_pricing_util.unset_method(l_log_level,'call_qp_api');

Line 2971: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2967: l_return_status VARCHAR2(1);
2968: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
2969: l_method_name VARCHAR2(50) := 'CLEAR_GLOBALS';
2970: BEGIN
2971: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2972: fte_freight_pricing_util.reset_dbg_vars;
2973: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
2974:
2975: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'Before ->G_I_LINE_INDEX.COUNT = '||G_I_LINE_INDEX.COUNT);

Line 3057: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3053: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'After ->g_O_line_detail_tbl.COUNT = '||g_O_line_detail_tbl.COUNT);
3054: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
3055: EXCEPTION
3056: WHEN others THEN
3057: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3058: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
3059: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3060: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
3061: END clear_globals;

Line 3072: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3068: l_return_status VARCHAR2(1);
3069: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
3070: l_method_name VARCHAR2(50) := '';
3071: BEGIN
3072: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3073: fte_freight_pricing_util.reset_dbg_vars;
3074: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
3075:
3076:

Line 3080: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3076:
3077: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
3078: EXCEPTION
3079: WHEN others THEN
3080: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3081: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
3082: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3083: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
3084: END ;