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_FREIGHT_PRICING_SPECIAL dependencies on WSH_UTIL_CORE

Line 140: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

136:
137: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
138: l_method_name VARCHAR2(50) := 'load_rules';
139: BEGIN
140: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
141: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
142:
143: fte_freight_pricing_util.reset_dbg_vars;
144: fte_freight_pricing_util.set_method(l_log_level,'load_rules');

Line 141: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

137: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
138: l_method_name VARCHAR2(50) := 'load_rules';
139: BEGIN
140: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
141: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
142:
143: fte_freight_pricing_util.reset_dbg_vars;
144: fte_freight_pricing_util.set_method(l_log_level,'load_rules');
145:

Line 231: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

227:
228: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Invalid parttern for LTL');
229: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'grouping_level='||g_lane_rules_tab(k).grouping_level);
230: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'commodity_aggregation='||g_lane_rules_tab(k).commodity_aggregation);
231: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
232:
233: END IF;
234:
235: EXIT WHEN j = l_def_values.LAST;

Line 244: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

240: END IF;
241: END LOOP;
242: CLOSE c_patterns;
243:
244: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247:
248: fte_freight_pricing_util.unset_method(l_log_level,'load_rules');

Line 251: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

247:
248: fte_freight_pricing_util.unset_method(l_log_level,'load_rules');
249: EXCEPTION
250: WHEN FND_API.G_EXC_ERROR THEN
251: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
252: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
253: fte_freight_pricing_util.unset_method(l_log_level,'load_rules');
254: WHEN others THEN
255: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 255: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

251: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
252: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
253: fte_freight_pricing_util.unset_method(l_log_level,'load_rules');
254: WHEN others THEN
255: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
256: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
257: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
258: fte_freight_pricing_util.unset_method(l_log_level,'load_rules');
259: END load_rules;

Line 344: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

340: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
341: l_method_name VARCHAR2(50) := 'validate_parameters';
342: BEGIN
343: fte_freight_pricing_util.set_method(l_log_level,'validate_parameters');
344: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
345: /*
346: --validate deficit wt params
347: IF (g_special_flags.deficit_wt_flag = 'Y') THEN
348: --check if weight breaks have been defined.

Line 568: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

564:
565: fte_freight_pricing_util.unset_method(l_log_level,'validate_parameters');
566: EXCEPTION
567: WHEN fte_freight_pricing_util.g_invalid_uom_code THEN
568: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
569: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_invalid_uom_code');
570: fte_freight_pricing_util.unset_method(l_log_level,'validate_parameters');
571: WHEN fte_freight_pricing_util.g_weight_break_not_found THEN
572: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 572: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

568: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
569: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_invalid_uom_code');
570: fte_freight_pricing_util.unset_method(l_log_level,'validate_parameters');
571: WHEN fte_freight_pricing_util.g_weight_break_not_found THEN
572: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
573: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_weight_break_not_found');
574: fte_freight_pricing_util.unset_method(l_log_level,'validate_parameters');
575: WHEN fte_freight_pricing_util.g_invalid_wt_break THEN
576: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 576: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

572: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
573: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_weight_break_not_found');
574: fte_freight_pricing_util.unset_method(l_log_level,'validate_parameters');
575: WHEN fte_freight_pricing_util.g_invalid_wt_break THEN
576: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
577: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_invalid_wt_break');
578: fte_freight_pricing_util.unset_method(l_log_level,'validate_parameters');
579: WHEN others THEN
580: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 580: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

576: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
577: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_invalid_wt_break');
578: fte_freight_pricing_util.unset_method(l_log_level,'validate_parameters');
579: WHEN others THEN
580: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
581: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
582: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
583: fte_freight_pricing_util.unset_method(l_log_level,'validate_parameters');
584: END validate_parameters;

Line 589: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

585:
586: -- End local module --
587:
588: BEGIN
589: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
590: fte_freight_pricing_util.reset_dbg_vars;
591: fte_freight_pricing_util.set_method(l_log_level,'initialize');
592: fte_freight_pricing_util.print_msg(l_log_level,'p_lane_id: '||p_lane_id);
593:

Line 623: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

619: g_special_flags.deficit_wt_flag := 'N';
620:
621: validate_parameters(x_return_status => l_return_status);
622:
623: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
624: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
625: raise fte_freight_pricing_util.g_param_validation_failed;
626: END IF;
627:

Line 624: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

620:
621: validate_parameters(x_return_status => l_return_status);
622:
623: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
624: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
625: raise fte_freight_pricing_util.g_param_validation_failed;
626: END IF;
627:
628: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_INF,'parameters after validation');

Line 639: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

635: p_lane_id => p_lane_id,
636: p_lane_function => g_special_flags.lane_function,
637: x_return_status => l_return_status);
638:
639: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
640: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
641: raise fte_freight_pricing_util.g_load_rules_failed;
642: END IF;
643:

Line 640: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

636: p_lane_function => g_special_flags.lane_function,
637: x_return_status => l_return_status);
638:
639: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
640: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
641: raise fte_freight_pricing_util.g_load_rules_failed;
642: END IF;
643:
644: print_rules;

Line 649: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

645:
646: x_lane_function := g_special_flags.lane_function;
647:
648: FTE_QP_ENGINE.clear_qp_input(x_return_status => l_return_status);
649: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
650: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
651: raise fte_freight_pricing_util.g_clear_qp_input_failed;
652: END IF;
653:

Line 650: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

646: x_lane_function := g_special_flags.lane_function;
647:
648: FTE_QP_ENGINE.clear_qp_input(x_return_status => l_return_status);
649: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
650: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
651: raise fte_freight_pricing_util.g_clear_qp_input_failed;
652: END IF;
653:
654: fte_freight_pricing_util.unset_method(l_log_level,'initialize');

Line 657: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

653:
654: fte_freight_pricing_util.unset_method(l_log_level,'initialize');
655: EXCEPTION
656: WHEN fte_freight_pricing_util.g_clear_qp_input_failed THEN
657: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
658: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_clear_qp_input_failed');
659: fte_freight_pricing_util.unset_method(l_log_level,'initialize');
660: WHEN fte_freight_pricing_util.g_param_validation_failed THEN
661: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 661: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

657: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
658: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_clear_qp_input_failed');
659: fte_freight_pricing_util.unset_method(l_log_level,'initialize');
660: WHEN fte_freight_pricing_util.g_param_validation_failed THEN
661: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
662: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_param_validation_failed');
663: fte_freight_pricing_util.unset_method(l_log_level,'initialize');
664: WHEN fte_freight_pricing_util.g_load_rules_failed THEN
665: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 665: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

661: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
662: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_param_validation_failed');
663: fte_freight_pricing_util.unset_method(l_log_level,'initialize');
664: WHEN fte_freight_pricing_util.g_load_rules_failed THEN
665: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
666: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_load_rules_failed');
667: fte_freight_pricing_util.unset_method(l_log_level,'initialize');
668: WHEN others THEN
669: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 669: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

665: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
666: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_load_rules_failed');
667: fte_freight_pricing_util.unset_method(l_log_level,'initialize');
668: WHEN others THEN
669: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
670: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
671: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
672: fte_freight_pricing_util.unset_method(l_log_level,'initialize');
673:

Line 696: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

692: l_return_status VARCHAR2(1);
693: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
694: l_method_name VARCHAR2(50) := 'calc_gross_weight';
695: BEGIN
696: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
697: fte_freight_pricing_util.reset_dbg_vars;
698: fte_freight_pricing_util.set_method(l_log_level,'calc_gross_weight');
699:
700: l_target_uom := p_target_uom;

Line 802: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

798: fte_freight_pricing_util.unset_method(l_log_level,'calc_gross_weight');
799:
800: EXCEPTION
801: WHEN others THEN
802: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
803: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
804: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
805: fte_freight_pricing_util.unset_method(l_log_level,'calc_gross_weight');
806: END calc_gross_weight;

Line 874: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

870: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
871: l_return_status VARCHAR2(1);
872:
873: BEGIN
874: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
875: fte_freight_pricing_util.reset_dbg_vars;
876: fte_freight_pricing_util.set_method(l_log_level,'prorate_rolledup_weights');
877: i := x_rolledup_rows.FIRST;
878: IF (i IS NOT NULL) THEN

Line 909: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

905: fte_freight_pricing_util.unset_method(l_log_level,'prorate_rolledup_weights');
906:
907: EXCEPTION
908: WHEN others THEN
909: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
910: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
911: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
912: fte_freight_pricing_util.unset_method(l_log_level,'prorate_rolledup_weights');
913:

Line 919: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

915: -- end local module --
916:
917:
918: BEGIN
919: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
920: fte_freight_pricing_util.reset_dbg_vars;
921: fte_freight_pricing_util.set_method(l_log_level,'apply_dimensional_weight');
922:
923: --exception point : NO_PARAMS_FOUND

Line 999: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

995: p_service_code => p_service_code,
996: x_carrier_dim_weight_rec => l_carrier_dim_weight_rec ,
997: x_return_status => l_return_status
998: );
999: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
1000: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
1001: raise fte_freight_pricing_util.g_no_params_found;
1002: END IF;
1003:

Line 1000: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

996: x_carrier_dim_weight_rec => l_carrier_dim_weight_rec ,
997: x_return_status => l_return_status
998: );
999: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
1000: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
1001: raise fte_freight_pricing_util.g_no_params_found;
1002: END IF;
1003:
1004: IF ( (l_carrier_dim_weight_rec.dim_factor IS NOT NULL) AND

Line 1118: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

1114: x_uom => l_wt_uom,
1115: x_return_status => l_return_status);
1116:
1117: fte_freight_pricing_util.set_location(p_loc=>'after calc_gross_weight ');
1118: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
1119: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
1120: raise fte_freight_pricing_util.g_calc_gross_wt_failed;
1121: ELSE
1122: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_gross_wt = '||l_gross_wt);

Line 1119: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

1115: x_return_status => l_return_status);
1116:
1117: fte_freight_pricing_util.set_location(p_loc=>'after calc_gross_weight ');
1118: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
1119: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
1120: raise fte_freight_pricing_util.g_calc_gross_wt_failed;
1121: ELSE
1122: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_gross_wt = '||l_gross_wt);
1123: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_rolledup_wt = '||l_rolledup_wt);

Line 1225: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

1221: p_ratio_denom => l_gross_wt,
1222: x_rolledup_rows => p_rolledup_rows,
1223: x_return_status => l_return_status);
1224:
1225: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
1226: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
1227: raise fte_freight_pricing_util.g_prorate_failed;
1228: END IF;
1229:

Line 1226: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

1222: x_rolledup_rows => p_rolledup_rows,
1223: x_return_status => l_return_status);
1224:
1225: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
1226: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
1227: raise fte_freight_pricing_util.g_prorate_failed;
1228: END IF;
1229:
1230: ELSE

Line 1259: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

1255: --p_ratio => (dim_wt/l_cont_tare_wt),
1256: x_rolledup_rows => p_rolledup_rows,
1257: x_return_status => l_return_status);
1258:
1259: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
1260: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
1261: raise fte_freight_pricing_util.g_prorate_failed;
1262: END IF;
1263:

Line 1260: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

1256: x_rolledup_rows => p_rolledup_rows,
1257: x_return_status => l_return_status);
1258:
1259: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
1260: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
1261: raise fte_freight_pricing_util.g_prorate_failed;
1262: END IF;
1263:
1264: ELSE

Line 1278: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1274: fte_freight_pricing_util.unset_method(l_log_level,'apply_dimensional_weight');
1275:
1276: EXCEPTION
1277: WHEN fte_freight_pricing_util.g_no_params_found THEN
1278: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1279: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'no_parameters found');
1280: fte_freight_pricing_util.unset_method(l_log_level,'apply_dimensional_weight');
1281: WHEN fte_freight_pricing_util.g_no_weights_found THEN
1282: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1282: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1278: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1279: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'no_parameters found');
1280: fte_freight_pricing_util.unset_method(l_log_level,'apply_dimensional_weight');
1281: WHEN fte_freight_pricing_util.g_no_weights_found THEN
1282: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1283: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_no_weights_found ');
1284: fte_freight_pricing_util.unset_method(l_log_level,'apply_dimensional_weight');
1285: WHEN fte_freight_pricing_util.g_no_volume_found THEN
1286: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1286: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1282: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1283: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_no_weights_found ');
1284: fte_freight_pricing_util.unset_method(l_log_level,'apply_dimensional_weight');
1285: WHEN fte_freight_pricing_util.g_no_volume_found THEN
1286: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1287: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_no_volume_found ');
1288: fte_freight_pricing_util.unset_method(l_log_level,'apply_dimensional_weight');
1289: WHEN fte_freight_pricing_util.g_calc_gross_wt_failed THEN
1290: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1290: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1286: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1287: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_no_volume_found ');
1288: fte_freight_pricing_util.unset_method(l_log_level,'apply_dimensional_weight');
1289: WHEN fte_freight_pricing_util.g_calc_gross_wt_failed THEN
1290: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1291: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_calc_gross_wt_failed ');
1292: fte_freight_pricing_util.unset_method(l_log_level,'apply_dimensional_weight');
1293: WHEN fte_freight_pricing_util.g_prorate_failed THEN
1294: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1294: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1290: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1291: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_calc_gross_wt_failed ');
1292: fte_freight_pricing_util.unset_method(l_log_level,'apply_dimensional_weight');
1293: WHEN fte_freight_pricing_util.g_prorate_failed THEN
1294: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1295: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_no_volume_found ');
1296: fte_freight_pricing_util.unset_method(l_log_level,'apply_dimensional_weight');
1297: WHEN others THEN
1298: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1298: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1294: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1295: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_no_volume_found ');
1296: fte_freight_pricing_util.unset_method(l_log_level,'apply_dimensional_weight');
1297: WHEN others THEN
1298: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1299: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
1300: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1301: fte_freight_pricing_util.unset_method(l_log_level,'apply_dimensional_weight');
1302:

Line 1365: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1361: l_method_name VARCHAR2(50) := 'load_carrier_dim_weight_params';
1362: l_carrier_dim_factors carrier_dim_weight_rec_type;
1363:
1364: BEGIN
1365: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1366: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
1367:
1368: fte_freight_pricing_util.print_msg(l_log_level,'p_carrier_id='||p_carrier_id);
1369: fte_freight_pricing_util.print_msg(l_log_level,'p_service_code='||p_service_code);

Line 1405: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1401: fte_freight_pricing_util.unset_method(l_log_level,'load_carrier_dim_weight_params');
1402:
1403: EXCEPTION
1404: WHEN fte_freight_pricing_util.g_no_params_found THEN
1405: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1406: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'no_dim_parameters found');
1407: fte_freight_pricing_util.unset_method(l_log_level,'load_carrier_dim_weight_params');
1408:
1409: END load_carrier_dim_weight_params;

Line 1430: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1426: l_return_status VARCHAR2(1);
1427: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
1428: l_method_name VARCHAR2(50) := 'get_total_shipment_weight';
1429: BEGIN
1430: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1431: fte_freight_pricing_util.reset_dbg_vars;
1432: fte_freight_pricing_util.set_method(l_log_level,'get_total_shipment_weight');
1433:
1434: -- loop over all top level rows

Line 1524: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1520:
1521: fte_freight_pricing_util.unset_method(l_log_level,'get_total_shipment_weight');
1522: EXCEPTION
1523: WHEN fte_freight_pricing_util.g_weight_uom_not_found THEN
1524: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1525: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_weight_uom_not_found');
1526: fte_freight_pricing_util.unset_method(l_log_level,'get_total_shipment_weight');
1527: WHEN fte_freight_pricing_util.g_total_shipment_weight_failed THEN
1528: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1528: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1524: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1525: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_weight_uom_not_found');
1526: fte_freight_pricing_util.unset_method(l_log_level,'get_total_shipment_weight');
1527: WHEN fte_freight_pricing_util.g_total_shipment_weight_failed THEN
1528: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1529: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_total_shipment_weight_failed');
1530: fte_freight_pricing_util.unset_method(l_log_level,'get_total_shipment_weight');
1531: WHEN others THEN
1532: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1532: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1528: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1529: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_total_shipment_weight_failed');
1530: fte_freight_pricing_util.unset_method(l_log_level,'get_total_shipment_weight');
1531: WHEN others THEN
1532: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1533: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
1534: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1535: fte_freight_pricing_util.unset_method(l_log_level,'get_total_shipment_weight');
1536:

Line 1706: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1702: END get_rolledup_wts;
1703:
1704:
1705: BEGIN
1706: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1707: fte_freight_pricing_util.reset_dbg_vars;
1708: fte_freight_pricing_util.set_method(l_log_level,'get_total_shipment_weight-2');
1709:
1710: -- TODO : if this is a container -->

Line 1828: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1824:
1825: fte_freight_pricing_util.unset_method(l_log_level,'get_total_shipment_weight-2');
1826: EXCEPTION
1827: WHEN fte_freight_pricing_util.g_weight_uom_not_found THEN
1828: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1829: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_weight_uom_not_found');
1830: fte_freight_pricing_util.unset_method(l_log_level,'get_total_shipment_weight-2');
1831: WHEN fte_freight_pricing_util.g_total_shipment_weight_failed THEN
1832: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1832: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1828: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1829: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_weight_uom_not_found');
1830: fte_freight_pricing_util.unset_method(l_log_level,'get_total_shipment_weight-2');
1831: WHEN fte_freight_pricing_util.g_total_shipment_weight_failed THEN
1832: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1833: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_total_shipment_weight_failed');
1834: fte_freight_pricing_util.unset_method(l_log_level,'get_total_shipment_weight-2');
1835: WHEN others THEN
1836: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1836: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1832: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1833: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_total_shipment_weight_failed');
1834: fte_freight_pricing_util.unset_method(l_log_level,'get_total_shipment_weight-2');
1835: WHEN others THEN
1836: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1837: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
1838: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1839: fte_freight_pricing_util.unset_method(l_log_level,'get_total_shipment_weight-2');
1840: END get_total_shipment_weight;

Line 1860: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1856:
1857: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
1858: l_method_name VARCHAR2(50) := 'get_bumped_up_package_weight';
1859: BEGIN
1860: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1861: fte_freight_pricing_util.reset_dbg_vars;
1862: fte_freight_pricing_util.set_method(l_log_level,'get_bumped_up_package_weight');
1863:
1864: IF (p_min_wt_uom IS NULL OR p_wt_uom IS NULL) THEN

Line 1907: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1903:
1904: fte_freight_pricing_util.unset_method(l_log_level,'get_bumped_up_package_weight');
1905: EXCEPTION
1906: WHEN fte_freight_pricing_util.g_weight_uom_not_found THEN
1907: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1908: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_weight_uom_not_found');
1909: fte_freight_pricing_util.unset_method(l_log_level,'get_bumped_up_package_weight');
1910: WHEN others THEN
1911: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1911: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1907: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1908: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_weight_uom_not_found');
1909: fte_freight_pricing_util.unset_method(l_log_level,'get_bumped_up_package_weight');
1910: WHEN others THEN
1911: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1912: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
1913: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1914: fte_freight_pricing_util.unset_method(l_log_level,'get_bumped_up_package_weight');
1915: END get_bumped_up_package_weight;

Line 1934: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1930: l_return_status VARCHAR2(1);
1931: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
1932: l_method_name VARCHAR2(50) := 'get_next_weight_break';
1933: BEGIN
1934: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1935: fte_freight_pricing_util.reset_dbg_vars;
1936: fte_freight_pricing_util.set_method(l_log_level,'get_next_weight_break');
1937:
1938: -- in the loop the wt break points may not be in any particular order

Line 2017: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2013: EXCEPTION
2014: /*
2015: --WHEN fte_freight_pricing_util.g_weight_break_not_found THEN
2016: WHEN fte_freight_pricing_util.g_def_wt_break_not_found THEN
2017: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2018: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2019: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_def_wt_break_not_found');
2020: fte_freight_pricing_util.unset_method(l_log_level,'get_next_weight_break');
2021: */

Line 2018: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2014: /*
2015: --WHEN fte_freight_pricing_util.g_weight_break_not_found THEN
2016: WHEN fte_freight_pricing_util.g_def_wt_break_not_found THEN
2017: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2018: --x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2019: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_def_wt_break_not_found');
2020: fte_freight_pricing_util.unset_method(l_log_level,'get_next_weight_break');
2021: */
2022: WHEN fte_freight_pricing_util.g_invalid_uom_conversion THEN

Line 2023: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2019: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_def_wt_break_not_found');
2020: fte_freight_pricing_util.unset_method(l_log_level,'get_next_weight_break');
2021: */
2022: WHEN fte_freight_pricing_util.g_invalid_uom_conversion THEN
2023: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2024: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_invalid_uom_conversion');
2025: fte_freight_pricing_util.unset_method(l_log_level,'get_next_weight_break');
2026: /*
2027: WHEN fte_freight_pricing_util.g_total_shipment_weight_failed THEN

Line 2028: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2024: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_invalid_uom_conversion');
2025: fte_freight_pricing_util.unset_method(l_log_level,'get_next_weight_break');
2026: /*
2027: WHEN fte_freight_pricing_util.g_total_shipment_weight_failed THEN
2028: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2029: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_total_shipment_weight_failed');
2030: fte_freight_pricing_util.unset_method(l_log_level,'get_next_weight_break');
2031: */
2032: WHEN others THEN

Line 2033: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2029: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_total_shipment_weight_failed');
2030: fte_freight_pricing_util.unset_method(l_log_level,'get_next_weight_break');
2031: */
2032: WHEN others THEN
2033: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2034: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
2035: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2036: fte_freight_pricing_util.unset_method(l_log_level,'get_next_weight_break');
2037: END get_next_weight_break;

Line 2110: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2106: -- end local module --
2107:
2108: BEGIN
2109:
2110: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2111: fte_freight_pricing_util.reset_dbg_vars;
2112: fte_freight_pricing_util.set_method(l_log_level,'apply_min_charge');
2113: x_charge_applied := 'N';
2114:

Line 2135: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2131: x_price => l_total_base_price,
2132: x_return_status => l_return_status);
2133:
2134: fte_freight_pricing_util.set_location(p_loc=>'after get_total_base_price ');
2135: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2136: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2137: raise fte_freight_pricing_util.g_total_base_price_failed;
2138: /*
2139: ELSE

Line 2136: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2132: x_return_status => l_return_status);
2133:
2134: fte_freight_pricing_util.set_location(p_loc=>'after get_total_base_price ');
2135: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2136: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2137: raise fte_freight_pricing_util.g_total_base_price_failed;
2138: /*
2139: ELSE
2140: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_base_price = '||l_total_base_price);

Line 2172: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2168: p_new_total_price => l_min_charge_amt,
2169: x_return_status => l_return_status);
2170:
2171: fte_freight_pricing_util.set_location(p_loc=>'after apply_new_base_price ');
2172: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2173: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2174: raise fte_freight_pricing_util.g_apply_new_base_price_failed;
2175: ELSE
2176: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,'applied min charge amt = '||l_min_charge_amt);

Line 2173: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2169: x_return_status => l_return_status);
2170:
2171: fte_freight_pricing_util.set_location(p_loc=>'after apply_new_base_price ');
2172: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2173: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2174: raise fte_freight_pricing_util.g_apply_new_base_price_failed;
2175: ELSE
2176: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,'applied min charge amt = '||l_min_charge_amt);
2177: END IF;

Line 2191: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2187:
2188: fte_freight_pricing_util.unset_method(l_log_level,'apply_min_charge');
2189: EXCEPTION
2190: WHEN fte_freight_pricing_util.g_total_base_price_failed THEN
2191: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2192: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'total_base_price_failed');
2193: fte_freight_pricing_util.unset_method(l_log_level,'apply_min_charge');
2194: WHEN fte_freight_pricing_util.g_apply_new_base_price_failed THEN
2195: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2195: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2191: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2192: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'total_base_price_failed');
2193: fte_freight_pricing_util.unset_method(l_log_level,'apply_min_charge');
2194: WHEN fte_freight_pricing_util.g_apply_new_base_price_failed THEN
2195: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2196: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_apply_new_base_price_failed');
2197: fte_freight_pricing_util.unset_method(l_log_level,'apply_min_charge');
2198: WHEN others THEN
2199: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2199: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2195: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2196: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_apply_new_base_price_failed');
2197: fte_freight_pricing_util.unset_method(l_log_level,'apply_min_charge');
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,'apply_min_charge');
2203:

Line 2267: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2263: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
2264: l_method_name VARCHAR2(50) := 'process_LTL_with_deficit_wt';
2265: BEGIN
2266:
2267: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2268: x_deficit_wt_applied := 'N';
2269: x_min_charge_comp_price := 0; -- AG 5/10 required for minimum charge with deficit wt
2270:
2271: l_deficit_wt_enabled := false;

Line 2291: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2287: x_wt_uom => l_total_wt_uom,
2288: x_return_status => l_return_status);
2289:
2290: fte_freight_pricing_util.set_location(p_loc=>'after get_total_shipment_weight ');
2291: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2292: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2293: raise fte_freight_pricing_util.g_total_shipment_weight_failed;
2294: ELSE
2295: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_wt = '||l_total_wt);

Line 2292: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2288: x_return_status => l_return_status);
2289:
2290: fte_freight_pricing_util.set_location(p_loc=>'after get_total_shipment_weight ');
2291: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2292: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2293: raise fte_freight_pricing_util.g_total_shipment_weight_failed;
2294: ELSE
2295: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_wt = '||l_total_wt);
2296: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_wt_uom = '||l_total_wt_uom);

Line 2304: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2300: fte_qp_engine.create_control_record(p_event_num => l_event_num,
2301: x_return_status => l_return_status );
2302:
2303: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
2304: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2305: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2306: raise fte_freight_pricing_util.g_create_control_record_failed;
2307: END IF;
2308:

Line 2305: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2301: x_return_status => l_return_status );
2302:
2303: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
2304: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2305: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2306: raise fte_freight_pricing_util.g_create_control_record_failed;
2307: END IF;
2308:
2309: ---- set I : actual total wt. ----

Line 2320: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2316: p_pricing_engine_input_rec => p_pricing_engine_rows(i),
2317: x_return_status => l_return_status);
2318:
2319: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
2320: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2321: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2322: raise fte_freight_pricing_util.g_create_line_record_failed;
2323: END IF;
2324:

Line 2321: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2317: x_return_status => l_return_status);
2318:
2319: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
2320: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2321: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2322: raise fte_freight_pricing_util.g_create_line_record_failed;
2323: END IF;
2324:
2325: fte_qp_engine.prepare_qp_line_qualifiers(

Line 2332: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2328: p_input_index => p_pricing_engine_rows(i).input_index,
2329: x_return_status => l_return_status);
2330:
2331: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
2332: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2333: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2334: raise fte_freight_pricing_util.g_create_qualifiers_failed;
2335: END IF;
2336:

Line 2333: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2329: x_return_status => l_return_status);
2330:
2331: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
2332: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2333: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2334: raise fte_freight_pricing_util.g_create_qualifiers_failed;
2335: END IF;
2336:
2337: fte_qp_engine.prepare_qp_line_attributes (

Line 2344: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2340: p_attr_rows => p_pricing_attribute_rows,
2341: x_return_status => l_return_status);
2342:
2343: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
2344: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2345: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2346: raise fte_freight_pricing_util.g_create_attr_failed;
2347: END IF;
2348: -- Now create additional attributes

Line 2345: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2341: x_return_status => l_return_status);
2342:
2343: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
2344: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2345: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2346: raise fte_freight_pricing_util.g_create_attr_failed;
2347: END IF;
2348: -- Now create additional attributes
2349:

Line 2369: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2365: p_attr_rec => l_attr_rec,
2366: x_return_status => l_return_status);
2367:
2368: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
2369: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2370: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2371: raise fte_freight_pricing_util.g_create_attr_failed;
2372: END IF;
2373:

Line 2370: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2366: x_return_status => l_return_status);
2367:
2368: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
2369: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2370: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2371: raise fte_freight_pricing_util.g_create_attr_failed;
2372: END IF;
2373:
2374: -- Also add it to the original pricing attribute rows;

Line 2395: --IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2391: x_return_status => l_return_status);
2392:
2393: fte_freight_pricing_util.set_location(p_loc=>'after get_next_weight_break ');
2394:
2395: --IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2396: -- l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2397:
2398: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2399: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 2396: -- l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2392:
2393: fte_freight_pricing_util.set_location(p_loc=>'after get_next_weight_break ');
2394:
2395: --IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2396: -- l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2397:
2398: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2399: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2400: raise fte_freight_pricing_util.g_get_next_weight_break_failed;

Line 2398: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2394:
2395: --IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2396: -- l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2397:
2398: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2399: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2400: raise fte_freight_pricing_util.g_get_next_weight_break_failed;
2401: END IF;
2402: ELSE

Line 2399: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2395: --IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2396: -- l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2397:
2398: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2399: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2400: raise fte_freight_pricing_util.g_get_next_weight_break_failed;
2401: END IF;
2402: ELSE
2403: IF (l_next_weight_break is null OR l_next_weight_break <= 0) THEN

Line 2456: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2452: p_pricing_engine_input_rec => l_engine_input_rec,
2453: x_return_status => l_return_status);
2454:
2455: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
2456: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2457: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2458: raise fte_freight_pricing_util.g_create_line_record_failed;
2459: END IF;
2460:

Line 2457: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2453: x_return_status => l_return_status);
2454:
2455: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
2456: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2457: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2458: raise fte_freight_pricing_util.g_create_line_record_failed;
2459: END IF;
2460:
2461: --prepare qualifiers

Line 2469: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2465: p_input_index => l_new_index,
2466: x_return_status => l_return_status);
2467:
2468: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
2469: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2470: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2471: raise fte_freight_pricing_util.g_create_qualifiers_failed;
2472: END IF;
2473:

Line 2470: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2466: x_return_status => l_return_status);
2467:
2468: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
2469: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2470: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2471: raise fte_freight_pricing_util.g_create_qualifiers_failed;
2472: END IF;
2473:
2474: -- prepare attributes from the attr rows. line indexes need to be changed

Line 2490: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2486: p_attr_rec => l_attr_rec,
2487: x_return_status => l_return_status);
2488:
2489: fte_freight_pricing_util.set_location(p_loc=>'after create attr record . i='||i);
2490: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2491: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2492: raise fte_freight_pricing_util.g_create_attr_failed;
2493: END IF;
2494: END IF;

Line 2491: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2487: x_return_status => l_return_status);
2488:
2489: fte_freight_pricing_util.set_location(p_loc=>'after create attr record . i='||i);
2490: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2491: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2492: raise fte_freight_pricing_util.g_create_attr_failed;
2493: END IF;
2494: END IF;
2495: EXIT WHEN j = p_pricing_attribute_rows.LAST;

Line 2511: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2507: p_attr_rec => l_attr_rec,
2508: x_return_status => l_return_status);
2509:
2510: fte_freight_pricing_util.set_location(p_loc=>'after create attr record . i='||i);
2511: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2512: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2513: raise fte_freight_pricing_util.g_create_attr_failed;
2514: END IF;
2515:

Line 2512: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2508: x_return_status => l_return_status);
2509:
2510: fte_freight_pricing_util.set_location(p_loc=>'after create attr record . i='||i);
2511: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2512: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2513: raise fte_freight_pricing_util.g_create_attr_failed;
2514: END IF;
2515:
2516: -- add other new attributes

Line 2535: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2531: fte_qp_engine.create_attr_record(p_event_num => l_event_num,
2532: p_attr_rec => l_attr_rec,
2533: x_return_status => l_return_status);
2534: fte_freight_pricing_util.set_location(p_loc=>'after create attr record . i='||i);
2535: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2536: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2537: raise fte_freight_pricing_util.g_create_attr_failed;
2538: END IF;
2539:

Line 2536: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2532: p_attr_rec => l_attr_rec,
2533: x_return_status => l_return_status);
2534: fte_freight_pricing_util.set_location(p_loc=>'after create attr record . i='||i);
2535: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2536: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2537: raise fte_freight_pricing_util.g_create_attr_failed;
2538: END IF;
2539:
2540: EXIT WHEN i >= l_curr_last_idx;

Line 2555: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2551: x_qp_output_detail_rows => x_qp_output_detail_rows,
2552: x_return_status => l_return_status);
2553:
2554: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');
2555: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2556: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2557: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
2558: END IF;
2559: END IF;

Line 2556: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2552: x_return_status => l_return_status);
2553:
2554: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');
2555: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2556: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2557: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
2558: END IF;
2559: END IF;
2560:

Line 2564: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2560:
2561: --check for errors in the output
2562: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
2563: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
2564: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2565: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2566: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
2567: END IF;
2568: END IF;

Line 2565: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2561: --check for errors in the output
2562: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
2563: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
2564: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2565: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2566: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
2567: END IF;
2568: END IF;
2569:

Line 2586: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2582: x_commodity_price_rows => l_comm_price_rows_set1,
2583: x_return_status => l_return_status);
2584:
2585: fte_freight_pricing_util.set_location(p_loc=>'after analyse_output_for_deficit_wt. set= '||l_set_num);
2586: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2587: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2588: raise fte_freight_pricing_util.g_analyse_deficit_failed;
2589: END IF;
2590:

Line 2587: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2583: x_return_status => l_return_status);
2584:
2585: fte_freight_pricing_util.set_location(p_loc=>'after analyse_output_for_deficit_wt. set= '||l_set_num);
2586: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2587: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2588: raise fte_freight_pricing_util.g_analyse_deficit_failed;
2589: END IF;
2590:
2591: IF l_deficit_wt_enabled THEN

Line 2601: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2597: x_commodity_price_rows => l_comm_price_rows_set2,
2598: x_return_status => l_return_status);
2599:
2600: fte_freight_pricing_util.set_location(p_loc=>'after analyse_output_for_deficit_wt. set= '||l_set_num);
2601: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2602: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2603: raise fte_freight_pricing_util.g_analyse_deficit_failed;
2604: END IF;
2605: -- }

Line 2602: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2598: x_return_status => l_return_status);
2599:
2600: fte_freight_pricing_util.set_location(p_loc=>'after analyse_output_for_deficit_wt. set= '||l_set_num);
2601: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2602: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2603: raise fte_freight_pricing_util.g_analyse_deficit_failed;
2604: END IF;
2605: -- }
2606: END IF; --l_deficit_wt_enabled

Line 2694: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2690: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'Deleting set ='||l_set_num);
2691: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
2692: x_return_status => l_return_status);
2693: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
2694: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2695: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2696: raise fte_freight_pricing_util.g_delete_set_failed;
2697: END IF;
2698: ELSE

Line 2695: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2691: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
2692: x_return_status => l_return_status);
2693: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
2694: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2695: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2696: raise fte_freight_pricing_util.g_delete_set_failed;
2697: END IF;
2698: ELSE
2699: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,' deficit wt did not get applied ');

Line 2711: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2707: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'Deleting set ='||l_set_num);
2708: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
2709: x_return_status => l_return_status);
2710: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
2711: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2712: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2713: raise fte_freight_pricing_util.g_delete_set_failed;
2714: END IF;
2715:

Line 2712: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2708: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
2709: x_return_status => l_return_status);
2710: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
2711: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2712: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2713: raise fte_freight_pricing_util.g_delete_set_failed;
2714: END IF;
2715:
2716: -- }

Line 2764: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2760: p_charge_subtype_code => 'DEFICIT WEIGHT SURCHARGE',
2761: p_adjustment_amount => l_adjustment_amount,
2762: x_return_status => l_return_status);
2763:
2764: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2765: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2766: raise fte_freight_pricing_util.g_add_qp_output_detail_failed;
2767: END IF;
2768: END IF;

Line 2765: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2761: p_adjustment_amount => l_adjustment_amount,
2762: x_return_status => l_return_status);
2763:
2764: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2765: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2766: raise fte_freight_pricing_util.g_add_qp_output_detail_failed;
2767: END IF;
2768: END IF;
2769:

Line 2776: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2772: x_qp_output_line_rows => x_qp_output_line_rows,
2773: x_qp_output_detail_rows => x_qp_output_detail_rows,
2774: x_return_status => l_return_status);
2775:
2776: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2777: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2778: raise fte_freight_pricing_util.g_get_qp_output_failed;
2779: END IF;
2780:

Line 2777: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2773: x_qp_output_detail_rows => x_qp_output_detail_rows,
2774: x_return_status => l_return_status);
2775:
2776: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2777: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2778: raise fte_freight_pricing_util.g_get_qp_output_failed;
2779: END IF;
2780:
2781: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');

Line 2784: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2780:
2781: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2782: EXCEPTION
2783: WHEN fte_freight_pricing_util.g_add_qp_output_detail_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,'g_add_qp_output_detail_failed');
2786: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2787: WHEN fte_freight_pricing_util.g_get_qp_output_failed THEN
2788: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2788: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2784: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2785: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_add_qp_output_detail_failed');
2786: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2787: WHEN fte_freight_pricing_util.g_get_qp_output_failed THEN
2788: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2789: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_get_qp_output_failed');
2790: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2791: WHEN fte_freight_pricing_util.g_create_control_record_failed THEN
2792: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2792: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2788: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2789: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_get_qp_output_failed');
2790: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2791: WHEN fte_freight_pricing_util.g_create_control_record_failed THEN
2792: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2793: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_control_record_failed');
2794: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2795: WHEN fte_freight_pricing_util.g_create_line_record_failed THEN
2796: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2796: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2792: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2793: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_control_record_failed');
2794: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2795: WHEN fte_freight_pricing_util.g_create_line_record_failed THEN
2796: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2797: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_line_record_failed');
2798: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2799: WHEN fte_freight_pricing_util.g_create_qualifiers_failed THEN
2800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2796: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2797: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_line_record_failed');
2798: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2799: WHEN fte_freight_pricing_util.g_create_qualifiers_failed THEN
2800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2801: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_qualifiers_failed');
2802: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2803: WHEN fte_freight_pricing_util.g_create_attr_failed THEN
2804: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2804: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2800: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2801: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_qualifiers_failed');
2802: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2803: WHEN fte_freight_pricing_util.g_create_attr_failed THEN
2804: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2805: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_attr_failed');
2806: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2807: WHEN fte_freight_pricing_util.g_delete_set_failed THEN
2808: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2808: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2804: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2805: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_attr_failed');
2806: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2807: WHEN fte_freight_pricing_util.g_delete_set_failed THEN
2808: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2809: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_delete_set_failed');
2810: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2811: WHEN fte_freight_pricing_util.g_analyse_deficit_failed THEN
2812: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2812: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2808: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2809: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_delete_set_failed');
2810: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2811: WHEN fte_freight_pricing_util.g_analyse_deficit_failed THEN
2812: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2813: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_analyse_deficit_failed');
2814: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2815: WHEN fte_freight_pricing_util.g_weight_break_not_found THEN
2816: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2816: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2812: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2813: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_analyse_deficit_failed');
2814: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2815: WHEN fte_freight_pricing_util.g_weight_break_not_found THEN
2816: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2817: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_weight_break_not_found');
2818: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2819: WHEN fte_freight_pricing_util.g_total_shipment_weight_failed THEN
2820: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2820: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2816: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2817: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_weight_break_not_found');
2818: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2819: WHEN fte_freight_pricing_util.g_total_shipment_weight_failed THEN
2820: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2821: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_total_shipment_weight_failed');
2822: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2823: WHEN fte_freight_pricing_util.g_qp_price_request_failed_2 THEN
2824: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2824: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2820: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2821: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_total_shipment_weight_failed');
2822: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2823: WHEN fte_freight_pricing_util.g_qp_price_request_failed_2 THEN
2824: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2825: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed_2');
2826: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2827: WHEN others THEN
2828: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2828: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2824: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2825: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed_2');
2826: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2827: WHEN others THEN
2828: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2829: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
2830: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2831: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL_with_deficit_wt');
2832:

Line 2856: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2852: l_return_status VARCHAR2(1);
2853: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
2854: l_method_name VARCHAR2(50) := 'post_process';
2855: BEGIN
2856: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2857: fte_freight_pricing_util.reset_dbg_vars;
2858: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
2859:
2860: --call resolve pricing objective here --

Line 2869: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2865: x_qp_output_line_details =>x_qp_output_detail_rows,
2866: x_return_status =>l_return_status);
2867:
2868: fte_freight_pricing_util.set_location(p_loc=>'after resolve_pricing_objective');
2869: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2870: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2871: raise fte_freight_pricing_util.g_resolve_pricing_objective;
2872: END IF;
2873:

Line 2870: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2866: x_return_status =>l_return_status);
2867:
2868: fte_freight_pricing_util.set_location(p_loc=>'after resolve_pricing_objective');
2869: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2870: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2871: raise fte_freight_pricing_util.g_resolve_pricing_objective;
2872: END IF;
2873:
2874: -- apply min charge

Line 2889: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2885: x_charge_applied => l_charge_applied,
2886: x_return_status => l_return_status);
2887:
2888: fte_freight_pricing_util.set_location(p_loc=>'after apply_min_charge ');
2889: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2890: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2891: raise fte_freight_pricing_util.g_apply_min_charge;
2892: END IF;
2893: END IF;

Line 2890: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2886: x_return_status => l_return_status);
2887:
2888: fte_freight_pricing_util.set_location(p_loc=>'after apply_min_charge ');
2889: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2890: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2891: raise fte_freight_pricing_util.g_apply_min_charge;
2892: END IF;
2893: END IF;
2894:

Line 2901: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

2897: l_event_num := fte_qp_engine.G_CHARGE_EVENT_NUM;
2898: fte_qp_engine.prepare_next_event_request ( x_return_status => l_return_status);
2899:
2900: fte_freight_pricing_util.set_location(p_loc=>'after prepare_next_event_request');
2901: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2902: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2903: raise fte_freight_pricing_util.g_prepare_next_event_failed;
2904: END IF;
2905:

Line 2902: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

2898: fte_qp_engine.prepare_next_event_request ( x_return_status => l_return_status);
2899:
2900: fte_freight_pricing_util.set_location(p_loc=>'after prepare_next_event_request');
2901: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2902: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2903: raise fte_freight_pricing_util.g_prepare_next_event_failed;
2904: END IF;
2905:
2906: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => x_qp_output_line_rows,

Line 2911: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2907: x_qp_output_detail_rows => x_qp_output_detail_rows,
2908: x_return_status => l_return_status);
2909:
2910: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 2');
2911: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2912: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2913: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
2914: END IF;
2915: END IF;

Line 2912: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2908: x_return_status => l_return_status);
2909:
2910: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 2');
2911: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2912: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2913: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
2914: END IF;
2915: END IF;
2916:

Line 2920: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2916:
2917: --check for errors in the output
2918: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
2919: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
2920: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2921: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2922: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
2923: END IF;
2924: END IF;

Line 2921: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2917: --check for errors in the output
2918: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
2919: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
2920: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2921: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2922: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
2923: END IF;
2924: END IF;
2925:

Line 2931: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2927:
2928: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2929: EXCEPTION
2930: WHEN fte_freight_pricing_util.g_resolve_pricing_objective THEN
2931: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2932: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_resolve_pricing_objective');
2933: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2934: WHEN fte_freight_pricing_util.g_apply_min_charge THEN
2935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2931: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2932: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_resolve_pricing_objective');
2933: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2934: WHEN fte_freight_pricing_util.g_apply_min_charge THEN
2935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2936: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_apply_min_charge');
2937: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2938: WHEN fte_freight_pricing_util.g_prepare_next_event_failed THEN
2939: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2939: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2936: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_apply_min_charge');
2937: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2938: WHEN fte_freight_pricing_util.g_prepare_next_event_failed THEN
2939: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2940: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_prepare_next_event_failed');
2941: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2942: WHEN fte_freight_pricing_util.g_qp_price_request_failed_2 THEN
2943: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2943: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2939: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2940: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_prepare_next_event_failed');
2941: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2942: WHEN fte_freight_pricing_util.g_qp_price_request_failed_2 THEN
2943: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2944: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed_2');
2945: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2946: WHEN others THEN
2947: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2947: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2943: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2944: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed_2');
2945: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2946: WHEN others THEN
2947: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2948: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,l_log_level,'g_others');
2949: FTE_FREIGHT_PRICING_UTIL.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2950: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2951: END post_process;

Line 3026: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3022: -- prepare for second qp call
3023: -- call qp engine
3024: -- any post processing
3025: -- return control to main code
3026: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3027: fte_freight_pricing_util.reset_dbg_vars;
3028: fte_freight_pricing_util.set_method(l_log_level,'process_LTL');
3029:
3030: -- Its ok for loose items not to have pattern rows. And loose items should always be eligible for LTL

Line 3066: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3062: x_return_status => l_return_status);
3063:
3064:
3065: fte_freight_pricing_util.set_location(p_loc=>'after process_LTL_with_deficit_wt ');
3066: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3067: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3068: raise fte_freight_pricing_util.g_process_LTL_deficit_failed;
3069: END IF;
3070: IF nvl(l_deficit_wt_applied,'N') = 'Y' THEN

Line 3067: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3063:
3064:
3065: fte_freight_pricing_util.set_location(p_loc=>'after process_LTL_with_deficit_wt ');
3066: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3067: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3068: raise fte_freight_pricing_util.g_process_LTL_deficit_failed;
3069: END IF;
3070: IF nvl(l_deficit_wt_applied,'N') = 'Y' THEN
3071: l_set_num := 2;

Line 3085: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3081: x_wt_uom => l_total_wt_uom,
3082: x_return_status => l_return_status);
3083:
3084: fte_freight_pricing_util.set_location(p_loc=>'after get_total_shipment_weight ');
3085: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3086: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3087: raise fte_freight_pricing_util.g_total_shipment_weight_failed;
3088: ELSE
3089: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_wt = '||l_total_wt);

Line 3086: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3082: x_return_status => l_return_status);
3083:
3084: fte_freight_pricing_util.set_location(p_loc=>'after get_total_shipment_weight ');
3085: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3086: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3087: raise fte_freight_pricing_util.g_total_shipment_weight_failed;
3088: ELSE
3089: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_wt = '||l_total_wt);
3090: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_wt_uom = '||l_total_wt_uom);

Line 3111: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3107: p_pricing_engine_input_rec => p_pricing_engine_rows(i),
3108: x_return_status => l_return_status);
3109:
3110: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
3111: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3112: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3113: raise fte_freight_pricing_util.g_create_control_record_failed;
3114: END IF;
3115:

Line 3112: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3108: x_return_status => l_return_status);
3109:
3110: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
3111: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3112: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3113: raise fte_freight_pricing_util.g_create_control_record_failed;
3114: END IF;
3115:
3116:

Line 3124: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3120: p_input_index => p_pricing_engine_rows(i).input_index,
3121: x_return_status => l_return_status);
3122:
3123: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
3124: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3125: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3126: raise fte_freight_pricing_util.g_create_qualifiers_failed;
3127: END IF;
3128:

Line 3125: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3121: x_return_status => l_return_status);
3122:
3123: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
3124: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3125: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3126: raise fte_freight_pricing_util.g_create_qualifiers_failed;
3127: END IF;
3128:
3129: fte_qp_engine.prepare_qp_line_attributes (

Line 3136: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3132: p_attr_rows => p_pricing_attribute_rows,
3133: x_return_status => l_return_status);
3134:
3135: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
3136: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3137: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3138: raise fte_freight_pricing_util.g_create_attr_failed;
3139: END IF;
3140:

Line 3137: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3133: x_return_status => l_return_status);
3134:
3135: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
3136: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3137: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3138: raise fte_freight_pricing_util.g_create_attr_failed;
3139: END IF;
3140:
3141: -- Now create additional attributes

Line 3162: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3158: p_attr_rec => l_attr_rec,
3159: x_return_status => l_return_status);
3160:
3161: fte_freight_pricing_util.set_location(p_loc=>'after create attr record i='||i);
3162: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3163: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3164: raise fte_freight_pricing_util.g_create_attr_failed;
3165: END IF;
3166:

Line 3163: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3159: x_return_status => l_return_status);
3160:
3161: fte_freight_pricing_util.set_location(p_loc=>'after create attr record i='||i);
3162: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3163: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3164: raise fte_freight_pricing_util.g_create_attr_failed;
3165: END IF;
3166:
3167: -- Also add it to the original pricing attribute rows;

Line 3182: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3178: x_qp_output_detail_rows => x_qp_output_detail_rows,
3179: x_return_status => l_return_status);
3180:
3181: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');
3182: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3183: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3184: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
3185: END IF;
3186: END IF;

Line 3183: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3179: x_return_status => l_return_status);
3180:
3181: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');
3182: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3183: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3184: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
3185: END IF;
3186: END IF;
3187:

Line 3191: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

3187:
3188: --check for errors in the output
3189: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
3190: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
3191: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3192: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3193: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
3194: END IF;
3195: END IF;

Line 3192: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

3188: --check for errors in the output
3189: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
3190: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
3191: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3192: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3193: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
3194: END IF;
3195: END IF;
3196:

Line 3210: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3206: x_qp_output_detail_rows => x_qp_output_detail_rows,
3207: x_return_status => l_return_status);
3208:
3209: fte_freight_pricing_util.set_location(p_loc=>'after post_process');
3210: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3211: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3212: raise fte_freight_pricing_util.g_post_process_failed;
3213: END IF;
3214:

Line 3211: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3207: x_return_status => l_return_status);
3208:
3209: fte_freight_pricing_util.set_location(p_loc=>'after post_process');
3210: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3211: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3212: raise fte_freight_pricing_util.g_post_process_failed;
3213: END IF;
3214:
3215: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');

Line 3218: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3214:
3215: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3216: EXCEPTION
3217: WHEN fte_freight_pricing_util.g_post_process_failed THEN
3218: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3219: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_post_process_failed');
3220: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
3221: WHEN fte_freight_pricing_util.g_not_eligible_for_LTL THEN
3222: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3222: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3218: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3219: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_post_process_failed');
3220: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
3221: WHEN fte_freight_pricing_util.g_not_eligible_for_LTL THEN
3222: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3223: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_not_eligible_for_LTL') ;
3224: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3225: WHEN fte_freight_pricing_util.g_create_control_record_failed THEN
3226: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3226: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3222: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3223: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_not_eligible_for_LTL') ;
3224: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3225: WHEN fte_freight_pricing_util.g_create_control_record_failed THEN
3226: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3227: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_control_record_failed');
3228: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3229: WHEN fte_freight_pricing_util.g_create_line_record_failed THEN
3230: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3230: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3226: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3227: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_control_record_failed');
3228: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3229: WHEN fte_freight_pricing_util.g_create_line_record_failed THEN
3230: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3231: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_line_record_failed');
3232: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3233: WHEN fte_freight_pricing_util.g_create_qualifiers_failed THEN
3234: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3234: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3230: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3231: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_line_record_failed');
3232: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3233: WHEN fte_freight_pricing_util.g_create_qualifiers_failed THEN
3234: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3235: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_qualifiers_failed');
3236: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3237: WHEN fte_freight_pricing_util.g_create_attr_failed THEN
3238: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3238: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3234: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3235: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_qualifiers_failed');
3236: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3237: WHEN fte_freight_pricing_util.g_create_attr_failed THEN
3238: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3239: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_attr_failed');
3240: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3241: WHEN fte_freight_pricing_util.g_process_LTL_deficit_failed THEN
3242: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3242: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3238: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3239: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_attr_failed');
3240: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3241: WHEN fte_freight_pricing_util.g_process_LTL_deficit_failed THEN
3242: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3243: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_process_LTL_deficit_failed');
3244: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3245: WHEN fte_freight_pricing_util.g_resolve_pricing_objective THEN
3246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3242: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3243: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_process_LTL_deficit_failed');
3244: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3245: WHEN fte_freight_pricing_util.g_resolve_pricing_objective THEN
3246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3247: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_resolve_pricing_objective');
3248: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3249: WHEN fte_freight_pricing_util.g_apply_min_charge THEN
3250: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3250: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3247: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_resolve_pricing_objective');
3248: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3249: WHEN fte_freight_pricing_util.g_apply_min_charge THEN
3250: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3251: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_apply_min_charge');
3252: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3253: WHEN fte_freight_pricing_util.g_total_shipment_weight_failed THEN
3254: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3254: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3250: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3251: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_apply_min_charge');
3252: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3253: WHEN fte_freight_pricing_util.g_total_shipment_weight_failed THEN
3254: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3255: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_total_shipment_weight_failed');
3256: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3257: WHEN fte_freight_pricing_util.g_qp_price_request_failed_2 THEN
3258: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3258: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3254: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3255: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_total_shipment_weight_failed');
3256: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3257: WHEN fte_freight_pricing_util.g_qp_price_request_failed_2 THEN
3258: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3259: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed_2');
3260: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3261: WHEN fte_freight_pricing_util.g_prepare_next_event_failed THEN
3262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3258: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3259: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed_2');
3260: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3261: WHEN fte_freight_pricing_util.g_prepare_next_event_failed THEN
3262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3263: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_prepare_next_event_failed');
3264: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3265: WHEN others THEN
3266: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3266: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3263: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_prepare_next_event_failed');
3264: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3265: WHEN others THEN
3266: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3267: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
3268: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3269: fte_freight_pricing_util.unset_method(l_log_level,'process_LTL');
3270:

Line 3282: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3278: i NUMBER:=0;
3279:
3280: BEGIN
3281:
3282: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3283:
3284: IF p_rolledup_lines.COUNT > 0 THEN
3285: FTE_FREIGHT_PRICING_UTIL.print_tag(p_msg => '');
3286: i := p_rolledup_lines.FIRST;

Line 3314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3310: END IF;
3311:
3312: EXCEPTION
3313: WHEN others THEN
3314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3315: FTE_FREIGHT_PRICING_UTIL.set_exception('print_rolledup_lines',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
3316: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3317: END print_rolledup_lines;
3318:

Line 3344: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3340: l_engine_input_rec fte_freight_pricing.pricing_engine_input_rec_type;
3341: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
3342: l_method_name VARCHAR2(50) := 'bumpup_rolledup_lines';
3343: BEGIN
3344: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3345: fte_freight_pricing_util.reset_dbg_vars;
3346: -- find ratio of new qty to orig qty for pricing engine input row
3347: -- make sure we are dealing with loose item only
3348: -- get instance id from engine row

Line 3430: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3426: END IF;
3427:
3428: EXCEPTION
3429: WHEN others THEN
3430: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3431: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
3432: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3433: fte_freight_pricing_util.unset_method(l_log_level,'bumpup_rolledup_lines');
3434: END bumpup_rolledup_lines;

Line 3589: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3585: -- call qp engine
3586: -- any post processing
3587: -- return control to main code
3588:
3589: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3590: fte_freight_pricing_util.reset_dbg_vars;
3591: fte_freight_pricing_util.set_method(l_log_level,'process_Parcel');
3592:
3593: -- Its ok for loose items not to have pattern rows. And loose items should always be eligible for LTL

Line 3614: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3610: x_qp_output_line_rows => x_qp_output_line_rows,
3611: x_qp_output_detail_rows => x_qp_output_detail_rows,
3612: x_return_status => l_return_status );
3613: fte_freight_pricing_util.set_location(p_loc=>'after process_others ');
3614: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3615: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3616: raise fte_freight_pricing_util.g_process_others_failed;
3617: END IF;
3618: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');

Line 3615: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3611: x_qp_output_detail_rows => x_qp_output_detail_rows,
3612: x_return_status => l_return_status );
3613: fte_freight_pricing_util.set_location(p_loc=>'after process_others ');
3614: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3615: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3616: raise fte_freight_pricing_util.g_process_others_failed;
3617: END IF;
3618: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
3619: RETURN;

Line 3634: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3630: x_wt_uom => l_total_wt_uom,
3631: x_return_status => l_return_status);
3632:
3633: fte_freight_pricing_util.set_location(p_loc=>'after get_total_shipment_weight ');
3634: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3635: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3636: raise fte_freight_pricing_util.g_total_shipment_weight_failed;
3637: ELSE
3638: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_wt = '||l_total_wt);

Line 3635: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3631: x_return_status => l_return_status);
3632:
3633: fte_freight_pricing_util.set_location(p_loc=>'after get_total_shipment_weight ');
3634: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3635: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3636: raise fte_freight_pricing_util.g_total_shipment_weight_failed;
3637: ELSE
3638: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_wt = '||l_total_wt);
3639: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_wt_uom = '||l_total_wt_uom);

Line 3647: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3643: fte_qp_engine.create_control_record(p_event_num => l_event_num,
3644: x_return_status => l_return_status );
3645:
3646: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
3647: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3648: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3649: raise fte_freight_pricing_util.g_create_control_record_failed;
3650: END IF;
3651:

Line 3648: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3644: x_return_status => l_return_status );
3645:
3646: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
3647: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3648: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3649: raise fte_freight_pricing_util.g_create_control_record_failed;
3650: END IF;
3651:
3652: -- create set I ( for standard rate checking ) --

Line 3668: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3664: p_pricing_engine_input_rec => p_pricing_engine_rows(i),
3665: x_return_status => l_return_status);
3666:
3667: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
3668: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3669: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3670: raise fte_freight_pricing_util.g_create_line_record_failed;
3671: END IF;
3672:

Line 3669: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3665: x_return_status => l_return_status);
3666:
3667: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
3668: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3669: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3670: raise fte_freight_pricing_util.g_create_line_record_failed;
3671: END IF;
3672:
3673: fte_qp_engine.prepare_qp_line_qualifiers(

Line 3680: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3676: p_input_index => p_pricing_engine_rows(i).input_index,
3677: x_return_status => l_return_status);
3678:
3679: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
3680: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3681: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3682: raise fte_freight_pricing_util.g_create_qualifiers_failed;
3683: END IF;
3684:

Line 3681: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3677: x_return_status => l_return_status);
3678:
3679: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
3680: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3681: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3682: raise fte_freight_pricing_util.g_create_qualifiers_failed;
3683: END IF;
3684:
3685: fte_qp_engine.prepare_qp_line_attributes (

Line 3692: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3688: p_attr_rows => p_pricing_attribute_rows,
3689: x_return_status => l_return_status);
3690:
3691: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
3692: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3693: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3694: raise fte_freight_pricing_util.g_create_attr_failed;
3695: END IF;
3696:

Line 3693: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3689: x_return_status => l_return_status);
3690:
3691: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
3692: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3693: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3694: raise fte_freight_pricing_util.g_create_attr_failed;
3695: END IF;
3696:
3697:

Line 3710: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3706: p_attr_rec => l_attr_rec,
3707: x_return_status => l_return_status);
3708:
3709: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');
3710: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3711: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3712: raise fte_freight_pricing_util.g_create_attr_failed;
3713: END IF;
3714:

Line 3711: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3707: x_return_status => l_return_status);
3708:
3709: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');
3710: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3711: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3712: raise fte_freight_pricing_util.g_create_attr_failed;
3713: END IF;
3714:
3715: /* TEST MULTIPIECE FLAG --END*/

Line 3759: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3755: x_bump => l_bump,
3756: x_return_status => l_return_status);
3757:
3758: fte_freight_pricing_util.set_location(p_loc=>'after get_bumped_up_package_weight');
3759: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3760: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3761: raise fte_freight_pricing_util.g_get_bumped_up_wt_failed;
3762: END IF;
3763:

Line 3760: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3756: x_return_status => l_return_status);
3757:
3758: fte_freight_pricing_util.set_location(p_loc=>'after get_bumped_up_package_weight');
3759: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3760: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3761: raise fte_freight_pricing_util.g_get_bumped_up_wt_failed;
3762: END IF;
3763:
3764: -- calculate the total shipment weight

Line 3801: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3797: p_new_uom => l_bumped_up_wt_uom,
3798: x_return_status => l_return_status);
3799:
3800: fte_freight_pricing_util.set_location(p_loc=>'after bumpup_rolledup_lines');
3801: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3802: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3803: raise fte_freight_pricing_util.g_get_bumped_up_wt_failed;
3804: END IF;
3805:

Line 3802: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3798: x_return_status => l_return_status);
3799:
3800: fte_freight_pricing_util.set_location(p_loc=>'after bumpup_rolledup_lines');
3801: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3802: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3803: raise fte_freight_pricing_util.g_get_bumped_up_wt_failed;
3804: END IF;
3805:
3806: print_rolledup_lines(

Line 3822: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3818: p_pricing_engine_input_rec => l_engine_input_rec,
3819: x_return_status => l_return_status);
3820:
3821: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
3822: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3823: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3824: raise fte_freight_pricing_util.g_create_line_record_failed;
3825: END IF;
3826:

Line 3823: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3819: x_return_status => l_return_status);
3820:
3821: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
3822: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3823: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3824: raise fte_freight_pricing_util.g_create_line_record_failed;
3825: END IF;
3826:
3827: --prepare qualifiers

Line 3835: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3831: p_input_index => l_new_index,
3832: x_return_status => l_return_status);
3833:
3834: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
3835: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3836: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3837: raise fte_freight_pricing_util.g_create_qualifiers_failed;
3838: END IF;
3839:

Line 3836: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3832: x_return_status => l_return_status);
3833:
3834: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
3835: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3836: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3837: raise fte_freight_pricing_util.g_create_qualifiers_failed;
3838: END IF;
3839:
3840: -- prepare attributes from the attr rows. line indexes need to be changed

Line 3856: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3852: p_attr_rec => l_attr_rec,
3853: x_return_status => l_return_status);
3854:
3855: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record');
3856: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3857: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3858: raise fte_freight_pricing_util.g_create_attr_failed;
3859: END IF;
3860:

Line 3857: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3853: x_return_status => l_return_status);
3854:
3855: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record');
3856: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3857: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3858: raise fte_freight_pricing_util.g_create_attr_failed;
3859: END IF;
3860:
3861: END IF;

Line 3878: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3874: p_attr_rec => l_attr_rec,
3875: x_return_status => l_return_status);
3876:
3877: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');
3878: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3879: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3880: raise fte_freight_pricing_util.g_create_attr_failed;
3881: END IF;
3882: /*

Line 3879: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3875: x_return_status => l_return_status);
3876:
3877: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');
3878: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3879: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3880: raise fte_freight_pricing_util.g_create_attr_failed;
3881: END IF;
3882: /*
3883: -- add other new attributes --

Line 3904: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3900: p_attr_rec => l_attr_rec,
3901: x_return_status => l_return_status);
3902:
3903: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');
3904: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3905: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3906: raise fte_freight_pricing_util.g_create_attr_failed;
3907: END IF;
3908: */

Line 3905: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3901: x_return_status => l_return_status);
3902:
3903: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');
3904: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3905: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3906: raise fte_freight_pricing_util.g_create_attr_failed;
3907: END IF;
3908: */
3909: /* TEST MULTIPIECE FLAG --BEGIN*/

Line 3921: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3917: p_attr_rec => l_attr_rec,
3918: x_return_status => l_return_status);
3919:
3920: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');
3921: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3922: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3923: raise fte_freight_pricing_util.g_create_attr_failed;
3924: END IF;
3925:

Line 3922: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3918: x_return_status => l_return_status);
3919:
3920: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');
3921: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3922: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3923: raise fte_freight_pricing_util.g_create_attr_failed;
3924: END IF;
3925:
3926: /* TEST MULTIPIECE FLAG --END*/

Line 3945: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3941: p_attr_rec => l_attr_rec,
3942: x_return_status => l_return_status);
3943:
3944: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');
3945: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3946: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3947: raise fte_freight_pricing_util.g_create_attr_failed;
3948: END IF;
3949: */

Line 3946: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3942: x_return_status => l_return_status);
3943:
3944: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');
3945: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3946: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3947: raise fte_freight_pricing_util.g_create_attr_failed;
3948: END IF;
3949: */
3950:

Line 3988: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

3984: p_attr_rec => l_attr_rec,
3985: x_return_status => l_return_status);
3986:
3987: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');
3988: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3989: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3990: raise fte_freight_pricing_util.g_create_attr_failed;
3991: END IF;
3992:

Line 3989: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

3985: x_return_status => l_return_status);
3986:
3987: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');
3988: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
3989: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3990: raise fte_freight_pricing_util.g_create_attr_failed;
3991: END IF;
3992:
3993: EXIT WHEN i >= p_pricing_engine_rows.LAST;

Line 4005: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

4001: x_qp_output_detail_rows => x_qp_output_detail_rows,
4002: x_return_status => l_return_status);
4003:
4004: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api');
4005: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4006: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4007: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
4008: END IF;
4009: END IF;

Line 4006: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4002: x_return_status => l_return_status);
4003:
4004: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api');
4005: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4006: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4007: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
4008: END IF;
4009: END IF;
4010:

Line 4022: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

4018: fte_freight_pricing_util.set_location(p_loc=>'after check_parcel_output_errors: Event '||l_event_num);
4019: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_return_status = '||l_return_status);
4020: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_op_ret_code = '||l_op_ret_code);
4021:
4022: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4023: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4024: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
4025: END IF;
4026: END IF;

Line 4023: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4019: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_return_status = '||l_return_status);
4020: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_op_ret_code = '||l_op_ret_code);
4021:
4022: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4023: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4024: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
4025: END IF;
4026: END IF;
4027:

Line 4039: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4035: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
4036: x_return_status => l_return_status);
4037:
4038: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
4039: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4040: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4041: raise fte_freight_pricing_util.g_delete_set_failed;
4042: END IF;
4043:

Line 4040: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4036: x_return_status => l_return_status);
4037:
4038: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
4039: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4040: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4041: raise fte_freight_pricing_util.g_delete_set_failed;
4042: END IF;
4043:
4044: --bug2803178

Line 4057: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4053: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
4054: x_return_status => l_return_status);
4055:
4056: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
4057: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4058: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4059: raise fte_freight_pricing_util.g_delete_set_failed;
4060: END IF;
4061:

Line 4058: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4054: x_return_status => l_return_status);
4055:
4056: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
4057: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4058: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4059: raise fte_freight_pricing_util.g_delete_set_failed;
4060: END IF;
4061:
4062: --bug2803178

Line 4084: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

4080: x_price => l_standard_price ,
4081: x_return_status => l_return_status);
4082:
4083: fte_freight_pricing_util.set_location(p_loc=>'after get_total_base_price for set='||l_set_num);
4084: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4085: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4086: raise FTE_FREIGHT_PRICING_UTIL.g_total_base_price_failed;
4087: END IF;
4088: ELSE

Line 4085: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4081: x_return_status => l_return_status);
4082:
4083: fte_freight_pricing_util.set_location(p_loc=>'after get_total_base_price for set='||l_set_num);
4084: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4085: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4086: raise FTE_FREIGHT_PRICING_UTIL.g_total_base_price_failed;
4087: END IF;
4088: ELSE
4089: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_standard_price = '||l_standard_price);

Line 4098: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

4094: x_price => l_hundredwt_price,
4095: x_return_status => l_return_status);
4096:
4097: fte_freight_pricing_util.set_location(p_loc=>'after get_total_base_price for set='||l_set_num);
4098: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4099: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4100: raise fte_freight_pricing_util.g_total_base_price_failed;
4101: END IF;
4102: ELSE

Line 4099: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4095: x_return_status => l_return_status);
4096:
4097: fte_freight_pricing_util.set_location(p_loc=>'after get_total_base_price for set='||l_set_num);
4098: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4099: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4100: raise fte_freight_pricing_util.g_total_base_price_failed;
4101: END IF;
4102: ELSE
4103: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_hundredwt_price= '||l_hundredwt_price);

Line 4113: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4109: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
4110: x_return_status => l_return_status);
4111:
4112: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
4113: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4114: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4115: raise fte_freight_pricing_util.g_delete_set_failed;
4116: END IF;
4117:

Line 4114: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4110: x_return_status => l_return_status);
4111:
4112: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
4113: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4114: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4115: raise fte_freight_pricing_util.g_delete_set_failed;
4116: END IF;
4117:
4118: --bug2803178

Line 4129: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4125: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
4126: x_return_status => l_return_status);
4127:
4128: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
4129: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4130: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4131: raise fte_freight_pricing_util.g_delete_set_failed;
4132: END IF;
4133:

Line 4130: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4126: x_return_status => l_return_status);
4127:
4128: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
4129: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4130: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4131: raise fte_freight_pricing_util.g_delete_set_failed;
4132: END IF;
4133:
4134: --bug2803178

Line 4162: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4158: x_qp_output_line_rows => x_qp_output_line_rows,
4159: x_qp_output_detail_rows => x_qp_output_detail_rows,
4160: x_return_status => l_return_status);
4161:
4162: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4163: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4164: raise fte_freight_pricing_util.g_get_qp_output_failed;
4165: END IF;
4166:

Line 4163: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4159: x_qp_output_detail_rows => x_qp_output_detail_rows,
4160: x_return_status => l_return_status);
4161:
4162: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4163: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4164: raise fte_freight_pricing_util.g_get_qp_output_failed;
4165: END IF;
4166:
4167: post_process(

Line 4177: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4173: x_qp_output_detail_rows => x_qp_output_detail_rows,
4174: x_return_status => l_return_status);
4175:
4176: fte_freight_pricing_util.set_location(p_loc=>'after resolve_pricing_objective');
4177: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4178: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4179: raise fte_freight_pricing_util.g_post_process_failed;
4180: END IF;
4181:

Line 4178: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4174: x_return_status => l_return_status);
4175:
4176: fte_freight_pricing_util.set_location(p_loc=>'after resolve_pricing_objective');
4177: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4178: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4179: raise fte_freight_pricing_util.g_post_process_failed;
4180: END IF;
4181:
4182: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');

Line 4185: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4181:
4182: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4183: EXCEPTION
4184: WHEN fte_freight_pricing_util.g_post_process_failed THEN
4185: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4186: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_post_process_failed');
4187: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4188: WHEN fte_freight_pricing_util.g_get_qp_output_failed THEN
4189: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4189: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4185: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4186: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_post_process_failed');
4187: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4188: WHEN fte_freight_pricing_util.g_get_qp_output_failed THEN
4189: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4190: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_get_qp_output_failed');
4191: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4192: WHEN fte_freight_pricing_util.g_total_base_price_failed THEN
4193: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4193: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4189: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4190: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_get_qp_output_failed');
4191: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4192: WHEN fte_freight_pricing_util.g_total_base_price_failed THEN
4193: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4194: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'total_base_price_failed');
4195: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4196: WHEN fte_freight_pricing_util.g_apply_new_base_price_failed THEN
4197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4193: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4194: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'total_base_price_failed');
4195: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4196: WHEN fte_freight_pricing_util.g_apply_new_base_price_failed THEN
4197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4198: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_apply_new_base_price_failed');
4199: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4200: WHEN fte_freight_pricing_util.g_delete_set_failed THEN
4201: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4201: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4198: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_apply_new_base_price_failed');
4199: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4200: WHEN fte_freight_pricing_util.g_delete_set_failed THEN
4201: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4202: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_delete_set_failed');
4203: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4204: WHEN fte_freight_pricing_util.g_resolve_pricing_objective THEN
4205: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4205: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4201: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4202: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_delete_set_failed');
4203: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4204: WHEN fte_freight_pricing_util.g_resolve_pricing_objective THEN
4205: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4206: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_resolve_pricing_objective');
4207: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4208: WHEN fte_freight_pricing_util.g_apply_min_charge THEN
4209: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4209: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4205: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4206: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_resolve_pricing_objective');
4207: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4208: WHEN fte_freight_pricing_util.g_apply_min_charge THEN
4209: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4210: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_apply_min_charge');
4211: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4212: WHEN fte_freight_pricing_util.g_total_shipment_weight_failed THEN
4213: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4213: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4209: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4210: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_apply_min_charge');
4211: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4212: WHEN fte_freight_pricing_util.g_total_shipment_weight_failed THEN
4213: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4214: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_total_shipment_weight_failed');
4215: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4216: WHEN fte_freight_pricing_util.g_qp_price_request_failed_2 THEN
4217: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4217: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4213: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4214: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_total_shipment_weight_failed');
4215: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4216: WHEN fte_freight_pricing_util.g_qp_price_request_failed_2 THEN
4217: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4218: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed_2');
4219: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4220: WHEN fte_freight_pricing_util.g_prepare_next_event_failed THEN
4221: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4221: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4217: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4218: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed_2');
4219: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4220: WHEN fte_freight_pricing_util.g_prepare_next_event_failed THEN
4221: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4222: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_prepare_next_event_failed');
4223: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4224: WHEN fte_freight_pricing_util.g_get_bumped_up_wt_failed THEN
4225: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4225: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4221: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4222: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_prepare_next_event_failed');
4223: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4224: WHEN fte_freight_pricing_util.g_get_bumped_up_wt_failed THEN
4225: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4226: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_get_bumped_up_wt_failed');
4227: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4228: WHEN fte_freight_pricing_util.g_parcel_not_eligible THEN
4229: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4229: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4225: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4226: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_get_bumped_up_wt_failed');
4227: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4228: WHEN fte_freight_pricing_util.g_parcel_not_eligible THEN
4229: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4230: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_parcel_not_eligible');
4231: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4232: WHEN fte_freight_pricing_util.g_create_control_record_failed THEN
4233: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4233: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4229: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4230: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_parcel_not_eligible');
4231: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4232: WHEN fte_freight_pricing_util.g_create_control_record_failed THEN
4233: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4234: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_control_record_failed');
4235: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4236: WHEN fte_freight_pricing_util.g_create_line_record_failed THEN
4237: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4237: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4233: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4234: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_control_record_failed');
4235: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4236: WHEN fte_freight_pricing_util.g_create_line_record_failed THEN
4237: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4238: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_line_record_failed');
4239: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4240: WHEN fte_freight_pricing_util.g_create_qualifiers_failed THEN
4241: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4241: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4237: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4238: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_line_record_failed');
4239: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4240: WHEN fte_freight_pricing_util.g_create_qualifiers_failed THEN
4241: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4242: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_qualifiers_failed');
4243: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4244: WHEN fte_freight_pricing_util.g_create_attr_failed THEN
4245: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4245: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4241: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4242: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_qualifiers_failed');
4243: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4244: WHEN fte_freight_pricing_util.g_create_attr_failed THEN
4245: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4246: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_attr_failed');
4247: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4248: WHEN fte_freight_pricing_util.g_process_others_failed THEN
4249: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4249: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4245: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4246: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_attr_failed');
4247: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4248: WHEN fte_freight_pricing_util.g_process_others_failed THEN
4249: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4250: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_process_others_failed');
4251: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4252: WHEN others THEN
4253: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4253: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4249: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4250: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_process_others_failed');
4251: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4252: WHEN others THEN
4253: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4254: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
4255: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4256: fte_freight_pricing_util.unset_method(l_log_level,'process_Parcel');
4257:

Line 4293: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4289:
4290: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
4291: l_method_name VARCHAR2(50) := 'process_others';
4292: BEGIN
4293: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4294: fte_freight_pricing_util.reset_dbg_vars;
4295: fte_freight_pricing_util.set_method(l_log_level,'process_others');
4296:
4297: -- create standard engine line and attributes (default stuff created by pattern matching)

Line 4303: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4299: fte_qp_engine.create_control_record(p_event_num => l_event_num,
4300: x_return_status => l_return_status );
4301:
4302: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
4303: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4304: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4305: raise fte_freight_pricing_util.g_create_control_record_failed;
4306: END IF;
4307:

Line 4304: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4300: x_return_status => l_return_status );
4301:
4302: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
4303: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4304: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4305: raise fte_freight_pricing_util.g_create_control_record_failed;
4306: END IF;
4307:
4308: l_set_num := 1;

Line 4317: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4313: p_pricing_engine_input_rec => p_pricing_engine_rows(i),
4314: x_return_status => l_return_status);
4315:
4316: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
4317: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4318: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4319: raise fte_freight_pricing_util.g_create_line_record_failed;
4320: END IF;
4321:

Line 4318: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4314: x_return_status => l_return_status);
4315:
4316: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
4317: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4318: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4319: raise fte_freight_pricing_util.g_create_line_record_failed;
4320: END IF;
4321:
4322: fte_qp_engine.prepare_qp_line_qualifiers(

Line 4329: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4325: p_input_index => p_pricing_engine_rows(i).input_index,
4326: x_return_status => l_return_status);
4327:
4328: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
4329: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4330: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4331: raise fte_freight_pricing_util.g_create_qualifiers_failed;
4332: END IF;
4333:

Line 4330: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4326: x_return_status => l_return_status);
4327:
4328: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
4329: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4330: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4331: raise fte_freight_pricing_util.g_create_qualifiers_failed;
4332: END IF;
4333:
4334: fte_qp_engine.prepare_qp_line_attributes (

Line 4341: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4337: p_attr_rows => p_pricing_attribute_rows,
4338: x_return_status => l_return_status);
4339:
4340: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
4341: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4342: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4343: raise fte_freight_pricing_util.g_create_attr_failed;
4344: END IF;
4345:

Line 4342: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4338: x_return_status => l_return_status);
4339:
4340: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
4341: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4342: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4343: raise fte_freight_pricing_util.g_create_attr_failed;
4344: END IF;
4345:
4346: EXIT WHEN i >= p_pricing_engine_rows.LAST;

Line 4360: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

4356: x_qp_output_detail_rows => x_qp_output_detail_rows,
4357: x_return_status => l_return_status);
4358:
4359: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');
4360: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4361: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4362: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
4363: END IF;
4364: END IF;

Line 4361: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4357: x_return_status => l_return_status);
4358:
4359: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');
4360: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4361: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4362: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
4363: END IF;
4364: END IF;
4365:

Line 4369: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

4365:
4366: --check for errors in the output
4367: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
4368: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
4369: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4370: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4371: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
4372: END IF;
4373: END IF;

Line 4370: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4366: --check for errors in the output
4367: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
4368: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
4369: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4370: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4371: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
4372: END IF;
4373: END IF;
4374:

Line 4387: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4383: x_qp_output_detail_rows => x_qp_output_detail_rows,
4384: x_return_status => l_return_status);
4385:
4386: fte_freight_pricing_util.set_location(p_loc=>'after resolve_pricing_objective');
4387: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4388: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4389: raise fte_freight_pricing_util.g_post_process_failed;
4390: END IF;
4391:

Line 4388: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4384: x_return_status => l_return_status);
4385:
4386: fte_freight_pricing_util.set_location(p_loc=>'after resolve_pricing_objective');
4387: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4388: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4389: raise fte_freight_pricing_util.g_post_process_failed;
4390: END IF;
4391:
4392: fte_freight_pricing_util.unset_method(l_log_level,'process_others');

Line 4395: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4391:
4392: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4393: EXCEPTION
4394: WHEN fte_freight_pricing_util.g_post_process_failed THEN
4395: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4396: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_post_process_failed');
4397: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4398: WHEN fte_freight_pricing_util.g_create_control_record_failed THEN
4399: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4399: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4395: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4396: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_post_process_failed');
4397: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4398: WHEN fte_freight_pricing_util.g_create_control_record_failed THEN
4399: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4400: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_control_record_failed');
4401: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4402: WHEN fte_freight_pricing_util.g_create_line_record_failed THEN
4403: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4403: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4399: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4400: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_control_record_failed');
4401: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4402: WHEN fte_freight_pricing_util.g_create_line_record_failed THEN
4403: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4404: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_line_record_failed');
4405: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4406: WHEN fte_freight_pricing_util.g_create_qualifiers_failed THEN
4407: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4407: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4403: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4404: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_line_record_failed');
4405: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4406: WHEN fte_freight_pricing_util.g_create_qualifiers_failed THEN
4407: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4408: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_qualifiers_failed');
4409: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4410: WHEN fte_freight_pricing_util.g_create_attr_failed THEN
4411: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4411: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4407: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4408: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_qualifiers_failed');
4409: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4410: WHEN fte_freight_pricing_util.g_create_attr_failed THEN
4411: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4412: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_attr_failed');
4413: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4414: WHEN fte_freight_pricing_util.g_resolve_pricing_objective THEN
4415: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4415: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4411: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4412: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_attr_failed');
4413: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4414: WHEN fte_freight_pricing_util.g_resolve_pricing_objective THEN
4415: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4416: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_resolve_pricing_objective');
4417: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4418: WHEN fte_freight_pricing_util.g_apply_min_charge THEN
4419: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4419: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4415: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4416: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_resolve_pricing_objective');
4417: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4418: WHEN fte_freight_pricing_util.g_apply_min_charge THEN
4419: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4420: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_apply_min_charge');
4421: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4422: WHEN fte_freight_pricing_util.g_total_shipment_weight_failed THEN
4423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4419: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4420: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_apply_min_charge');
4421: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4422: WHEN fte_freight_pricing_util.g_total_shipment_weight_failed THEN
4423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4424: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_total_shipment_weight_failed');
4425: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4426: WHEN fte_freight_pricing_util.g_qp_price_request_failed_2 THEN
4427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4424: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_total_shipment_weight_failed');
4425: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4426: WHEN fte_freight_pricing_util.g_qp_price_request_failed_2 THEN
4427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4428: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed_2');
4429: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4430: WHEN fte_freight_pricing_util.g_prepare_next_event_failed THEN
4431: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4431: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4427: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4428: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_qp_price_request_failed_2');
4429: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4430: WHEN fte_freight_pricing_util.g_prepare_next_event_failed THEN
4431: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4432: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_prepare_next_event_failed');
4433: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4434: WHEN others THEN
4435: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4435: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4431: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4432: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_prepare_next_event_failed');
4433: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4434: WHEN others THEN
4435: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4436: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
4437: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4438: fte_freight_pricing_util.unset_method(l_log_level,'process_others');
4439:

Line 4468: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4464: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
4465: l_method_name VARCHAR2(50) := 'process_special_conditions';
4466: BEGIN
4467:
4468: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4469: fte_freight_pricing_util.reset_dbg_vars;
4470: fte_freight_pricing_util.set_method(l_log_level,l_method_name);
4471: -- check if lane function is LTL or PARCEL.
4472:

Line 4506: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4502: x_qp_output_detail_rows => x_qp_output_detail_rows,
4503: x_return_status => l_return_status );
4504:
4505: fte_freight_pricing_util.set_location(p_loc=>'after process_LTL ');
4506: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4507: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4508: raise fte_freight_pricing_util.g_process_LTL_failed;
4509: END IF;
4510:

Line 4507: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4503: x_return_status => l_return_status );
4504:
4505: fte_freight_pricing_util.set_location(p_loc=>'after process_LTL ');
4506: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4507: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4508: raise fte_freight_pricing_util.g_process_LTL_failed;
4509: END IF;
4510:
4511: ELSIF ( isParcel = 'Y') THEN

Line 4523: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4519: x_qp_output_detail_rows => x_qp_output_detail_rows,
4520: x_return_status => l_return_status );
4521:
4522: fte_freight_pricing_util.set_location(p_loc=>'after process_Parcel ');
4523: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4524: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4525: raise fte_freight_pricing_util.g_process_Parcel_failed;
4526: END IF;
4527: ELSE

Line 4524: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4520: x_return_status => l_return_status );
4521:
4522: fte_freight_pricing_util.set_location(p_loc=>'after process_Parcel ');
4523: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4524: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4525: raise fte_freight_pricing_util.g_process_Parcel_failed;
4526: END IF;
4527: ELSE
4528: --

Line 4541: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4537: x_qp_output_detail_rows => x_qp_output_detail_rows,
4538: x_return_status => l_return_status );
4539:
4540: fte_freight_pricing_util.set_location(p_loc=>'after process_others ');
4541: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4542: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4543: raise fte_freight_pricing_util.g_process_others_failed;
4544: END IF;
4545:

Line 4542: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4538: x_return_status => l_return_status );
4539:
4540: fte_freight_pricing_util.set_location(p_loc=>'after process_others ');
4541: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4542: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4543: raise fte_freight_pricing_util.g_process_others_failed;
4544: END IF;
4545:
4546: END IF;

Line 4551: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4547:
4548: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4549: EXCEPTION
4550: WHEN fte_freight_pricing_util.g_no_party_id_found THEN
4551: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4552: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_no_party_id_found');
4553: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4554: WHEN fte_freight_pricing_util.g_no_price_list_on_lane THEN
4555: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4555: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4551: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4552: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_no_party_id_found');
4553: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4554: WHEN fte_freight_pricing_util.g_no_price_list_on_lane THEN
4555: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4556: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_no_price_list_on_lane');
4557: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4558: WHEN fte_freight_pricing_util.g_no_lane_found THEN
4559: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4559: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4555: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4556: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_no_price_list_on_lane');
4557: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4558: WHEN fte_freight_pricing_util.g_no_lane_found THEN
4559: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4560: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_no_lane_found');
4561: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4562: WHEN fte_freight_pricing_util.g_no_currency_found THEN
4563: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4563: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4559: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4560: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_no_lane_found');
4561: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4562: WHEN fte_freight_pricing_util.g_no_currency_found THEN
4563: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4564: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_no_currency_found');
4565: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4566: WHEN fte_freight_pricing_util.g_process_LTL_failed THEN
4567: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4567: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4563: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4564: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_no_currency_found');
4565: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4566: WHEN fte_freight_pricing_util.g_process_LTL_failed THEN
4567: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4568: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_process_LTL_failed');
4569: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4570: WHEN fte_freight_pricing_util.g_process_Parcel_failed THEN
4571: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4571: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4567: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4568: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_process_LTL_failed');
4569: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4570: WHEN fte_freight_pricing_util.g_process_Parcel_failed THEN
4571: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4572: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_process_Parcel_failed');
4573: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4574: WHEN fte_freight_pricing_util.g_process_others_failed THEN
4575: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4575: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4571: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4572: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_process_Parcel_failed');
4573: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4574: WHEN fte_freight_pricing_util.g_process_others_failed THEN
4575: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4576: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_attr_failed');
4577: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4578: WHEN others THEN
4579: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4579: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4575: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4576: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_create_attr_failed');
4577: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4578: WHEN others THEN
4579: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4580: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'g_others');
4581: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4582: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
4583:

Line 4642: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4638:
4639: l_freight_cost_type_id NUMBER;
4640:
4641: BEGIN
4642: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4643:
4644: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
4645: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_method_name);
4646:

Line 4680: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS and

4676: x_currency_code => l_currency_code,
4677: x_return_status => l_return_status );
4678: END IF;
4679:
4680: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS and
4681: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4682: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'get currency code failed');
4683: raise FND_API.G_EXC_ERROR;
4684: END IF;

Line 4681: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4677: x_return_status => l_return_status );
4678: END IF;
4679:
4680: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS and
4681: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4682: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'get currency code failed');
4683: raise FND_API.G_EXC_ERROR;
4684: END IF;
4685:

Line 4745: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4741: p_lane_id => p_lane_info.lane_id,
4742: x_lane_function => l_lane_function,
4743: x_return_status => l_return_status);
4744:
4745: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4746: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4747: raise FND_API.G_EXC_ERROR;
4748: END IF;
4749:

Line 4746: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4742: x_lane_function => l_lane_function,
4743: x_return_status => l_return_status);
4744:
4745: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4746: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4747: raise FND_API.G_EXC_ERROR;
4748: END IF;
4749:
4750: -- set up data structure to call QP

Line 4802: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4798: fte_qp_engine.create_control_record(p_event_num => l_event_num,
4799: x_return_status => l_return_status );
4800:
4801: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
4802: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4803: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4804: raise FND_API.G_EXC_ERROR;
4805: END IF;
4806:

Line 4803: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4799: x_return_status => l_return_status );
4800:
4801: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
4802: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4803: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4804: raise FND_API.G_EXC_ERROR;
4805: END IF;
4806:
4807: --l_set_num := 1;

Line 4816: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4812: p_pricing_engine_input_rec => l_pricing_engine_rows(i),
4813: x_return_status => l_return_status);
4814:
4815: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
4816: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4817: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4818: raise FND_API.G_EXC_ERROR;
4819: END IF;
4820:

Line 4817: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4813: x_return_status => l_return_status);
4814:
4815: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
4816: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4817: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4818: raise FND_API.G_EXC_ERROR;
4819: END IF;
4820:
4821: fte_qp_engine.prepare_qp_line_qualifiers(

Line 4828: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4824: p_input_index => l_pricing_engine_rows(i).input_index,
4825: x_return_status => l_return_status);
4826:
4827: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
4828: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4829: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4830: raise FND_API.G_EXC_ERROR;
4831: END IF;
4832:

Line 4829: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4825: x_return_status => l_return_status);
4826:
4827: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
4828: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4829: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4830: raise FND_API.G_EXC_ERROR;
4831: END IF;
4832:
4833: fte_qp_engine.prepare_qp_line_attributes (

Line 4840: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4836: p_attr_rows => l_pricing_attribute_rows,
4837: x_return_status => l_return_status);
4838:
4839: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
4840: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4841: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4842: raise FND_API.G_EXC_ERROR;
4843: END IF;
4844:

Line 4841: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4837: x_return_status => l_return_status);
4838:
4839: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
4840: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4841: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4842: raise FND_API.G_EXC_ERROR;
4843: END IF;
4844:
4845: EXIT WHEN i >= l_pricing_engine_rows.LAST;

Line 4856: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4852: x_qp_output_detail_rows => l_qp_output_detail_rows,
4853: x_return_status => l_return_status);
4854:
4855: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');
4856: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4857: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4858: raise FND_API.G_EXC_ERROR;
4859: END IF;
4860:

Line 4857: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4853: x_return_status => l_return_status);
4854:
4855: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');
4856: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4857: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4858: raise FND_API.G_EXC_ERROR;
4859: END IF;
4860:
4861: --check for errors in the output

Line 4864: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4860:
4861: --check for errors in the output
4862: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
4863: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
4864: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4865: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4866: raise FND_API.G_EXC_ERROR;
4867: END IF;
4868:

Line 4865: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4861: --check for errors in the output
4862: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
4863: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
4864: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4865: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4866: raise FND_API.G_EXC_ERROR;
4867: END IF;
4868:
4869: fte_qp_engine.print_qp_output();

Line 4879: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4875: x_charge_applied => l_charge_applied,
4876: x_return_status => l_return_status);
4877:
4878: fte_freight_pricing_util.set_location(p_loc=>'after apply_min_charge ');
4879: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4880: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4881: raise FND_API.G_EXC_ERROR;
4882: END IF;
4883: END IF;

Line 4880: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4876: x_return_status => l_return_status);
4877:
4878: fte_freight_pricing_util.set_location(p_loc=>'after apply_min_charge ');
4879: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4880: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4881: raise FND_API.G_EXC_ERROR;
4882: END IF;
4883: END IF;
4884:

Line 4891: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4887: l_event_num := fte_qp_engine.G_CHARGE_EVENT_NUM;
4888: fte_qp_engine.prepare_next_event_request ( x_return_status => l_return_status);
4889:
4890: fte_freight_pricing_util.set_location(p_loc=>'after prepare_next_event_request');
4891: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4892: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4893: raise FND_API.G_EXC_ERROR;
4894: END IF;
4895:

Line 4892: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

4888: fte_qp_engine.prepare_next_event_request ( x_return_status => l_return_status);
4889:
4890: fte_freight_pricing_util.set_location(p_loc=>'after prepare_next_event_request');
4891: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4892: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4893: raise FND_API.G_EXC_ERROR;
4894: END IF;
4895:
4896: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => l_qp_output_line_rows,

Line 4901: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4897: x_qp_output_detail_rows => l_qp_output_detail_rows,
4898: x_return_status => l_return_status);
4899:
4900: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 2');
4901: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4902: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4903: raise FND_API.G_EXC_ERROR;
4904: END IF;
4905:

Line 4902: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4898: x_return_status => l_return_status);
4899:
4900: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 2');
4901: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4902: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4903: raise FND_API.G_EXC_ERROR;
4904: END IF;
4905:
4906: --check for errors in the output

Line 4909: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4905:
4906: --check for errors in the output
4907: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
4908: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
4909: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4910: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4911: raise FND_API.G_EXC_ERROR;
4912: END IF;
4913:

Line 4910: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4906: --check for errors in the output
4907: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
4908: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
4909: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4910: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4911: raise FND_API.G_EXC_ERROR;
4912: END IF;
4913:
4914: fte_qp_engine.print_qp_output();

Line 4960: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4956: p_line_type_code => 'FTECHARGE',
4957: p_charge_subtype_code => l_qp_output_detail_rows(j).charge_subtype_code,
4958: x_freight_cost_type_id => l_fc_charge_rec.freight_cost_type_id,
4959: x_return_status => l_return_status);
4960: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4961: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4962: raise FND_API.G_EXC_ERROR;
4963: END IF;
4964: ELSE -- l_qp_output_detail_rows(j).list_line_type_code = 'DIS'

Line 4961: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4957: p_charge_subtype_code => l_qp_output_detail_rows(j).charge_subtype_code,
4958: x_freight_cost_type_id => l_fc_charge_rec.freight_cost_type_id,
4959: x_return_status => l_return_status);
4960: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4961: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4962: raise FND_API.G_EXC_ERROR;
4963: END IF;
4964: ELSE -- l_qp_output_detail_rows(j).list_line_type_code = 'DIS'
4965: l_line_discount_amount := l_line_discount_amount + l_fc_charge_rec.total_amount;

Line 4974: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

4970: p_line_type_code => 'FTEDISCOUNT',
4971: p_charge_subtype_code => 'DISCOUNT',
4972: x_freight_cost_type_id => l_fc_charge_rec.freight_cost_type_id,
4973: x_return_status => l_return_status);
4974: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4975: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4976: raise FND_API.G_EXC_ERROR;
4977: END IF;
4978: END IF;

Line 4975: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

4971: p_charge_subtype_code => 'DISCOUNT',
4972: x_freight_cost_type_id => l_fc_charge_rec.freight_cost_type_id,
4973: x_return_status => l_return_status);
4974: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4975: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4976: raise FND_API.G_EXC_ERROR;
4977: END IF;
4978: END IF;
4979:

Line 5056: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

5052: p_line_type_code => 'FTEPRICE',
5053: p_charge_subtype_code => 'PRICE',
5054: x_freight_cost_type_id => l_fc_rec.freight_cost_type_id,
5055: x_return_status => l_return_status);
5056: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5057: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5058: raise FND_API.G_EXC_ERROR;
5059: END IF;
5060:

Line 5057: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

5053: p_charge_subtype_code => 'PRICE',
5054: x_freight_cost_type_id => l_fc_rec.freight_cost_type_id,
5055: x_return_status => l_return_status);
5056: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5057: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5058: raise FND_API.G_EXC_ERROR;
5059: END IF;
5060:
5061: l_summary_amount := l_summary_amount + l_fc_rec.total_amount;

Line 5150: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

5146: p_line_type_code => 'FTESUMMARY',
5147: p_charge_subtype_code => 'SUMMARY',
5148: x_freight_cost_type_id => l_freight_cost_type_id,
5149: x_return_status => l_return_status);
5150: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5151: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5152: raise FND_API.G_EXC_ERROR;
5153: END IF;
5154:

Line 5151: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

5147: p_charge_subtype_code => 'SUMMARY',
5148: x_freight_cost_type_id => l_freight_cost_type_id,
5149: x_return_status => l_return_status);
5150: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5151: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5152: raise FND_API.G_EXC_ERROR;
5153: END IF;
5154:
5155: IF p_save_flag = 'M' THEN

Line 5211: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5207:
5208: EXCEPTION
5209:
5210: WHEN FND_API.G_EXC_ERROR THEN
5211: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5212: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
5213: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5214: WHEN others THEN
5215: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 5215: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5211: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5212: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
5213: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5214: WHEN others THEN
5215: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5216: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
5217: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
5218: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5219: END;

Line 5236: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5232: l_return_status VARCHAR2(1);
5233: i NUMBER;
5234: l_tmp NUMBER;
5235: BEGIN
5236: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5237:
5238: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
5239: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_method_name);
5240:

Line 5287: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5283: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
5284:
5285: EXCEPTION
5286: WHEN FND_API.G_EXC_ERROR THEN
5287: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5288: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
5289: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5290: WHEN others THEN
5291: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 5291: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5287: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5288: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
5289: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5290: WHEN others THEN
5291: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5292: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
5293: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
5294: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5295: END;

Line 5329: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5325: FROM mtl_categories
5326: WHERE category_id = c_category_id;
5327:
5328: BEGIN
5329: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5330:
5331: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
5332: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_method_name);
5333:

Line 5351: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

5347:
5348: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_total_container_weight='||l_total_container_weight);
5349: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'l_container_weight_uom='||l_container_weight_uom);
5350:
5351: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
5352: raise FND_API.G_EXC_ERROR;
5353: END IF;
5354:
5355: IF l_total_container_weight <= 0 THEN

Line 5476: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5472: EXCEPTION
5473: WHEN g_finished_success THEN
5474: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5475: WHEN FND_API.G_EXC_ERROR THEN
5476: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5477: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
5478: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5479: WHEN others THEN
5480: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 5480: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5476: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5477: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
5478: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5479: WHEN others THEN
5480: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5481: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
5482: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
5483: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
5484: END;

Line 5548: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5544:
5545: l_main_update_count NUMBER;
5546:
5547: BEGIN
5548: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5549:
5550: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
5551: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,l_method_name);
5552:

Line 5577: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS and

5573: fte_freight_pricing.get_currency_code(
5574: p_carrier_id => p_lane_info.carrier_id,
5575: x_currency_code => l_currency_code,
5576: x_return_status => l_return_status );
5577: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS and
5578: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5579: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'get currency code failed');
5580: raise FND_API.G_EXC_ERROR;
5581: END IF;

Line 5578: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

5574: p_carrier_id => p_lane_info.carrier_id,
5575: x_currency_code => l_currency_code,
5576: x_return_status => l_return_status );
5577: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS and
5578: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5579: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'get currency code failed');
5580: raise FND_API.G_EXC_ERROR;
5581: END IF;
5582: END IF;

Line 5736: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

5732: fte_qp_engine.create_control_record(p_event_num => l_event_num,
5733: x_return_status => l_return_status );
5734:
5735: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
5736: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5737: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5738: raise FND_API.G_EXC_ERROR;
5739: END IF;
5740:

Line 5737: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

5733: x_return_status => l_return_status );
5734:
5735: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
5736: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5737: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5738: raise FND_API.G_EXC_ERROR;
5739: END IF;
5740:
5741: --l_set_num := 1;

Line 5750: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

5746: p_pricing_engine_input_rec => l_pricing_engine_rows(i),
5747: x_return_status => l_return_status);
5748:
5749: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
5750: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5751: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5752: raise FND_API.G_EXC_ERROR;
5753: END IF;
5754:

Line 5751: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

5747: x_return_status => l_return_status);
5748:
5749: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);
5750: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5751: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5752: raise FND_API.G_EXC_ERROR;
5753: END IF;
5754:
5755: fte_qp_engine.prepare_qp_line_qualifiers(

Line 5762: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

5758: p_input_index => l_pricing_engine_rows(i).input_index,
5759: x_return_status => l_return_status);
5760:
5761: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
5762: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5763: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5764: raise FND_API.G_EXC_ERROR;
5765: END IF;
5766:

Line 5763: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

5759: x_return_status => l_return_status);
5760:
5761: fte_freight_pricing_util.set_location(p_loc=>'after create qp line qualifiers. i='||i);
5762: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5763: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5764: raise FND_API.G_EXC_ERROR;
5765: END IF;
5766:
5767: fte_qp_engine.prepare_qp_line_attributes (

Line 5774: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

5770: p_attr_rows => l_pricing_attribute_rows,
5771: x_return_status => l_return_status);
5772:
5773: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
5774: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5775: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5776: raise FND_API.G_EXC_ERROR;
5777: END IF;
5778:

Line 5775: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

5771: x_return_status => l_return_status);
5772:
5773: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);
5774: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5775: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5776: raise FND_API.G_EXC_ERROR;
5777: END IF;
5778:
5779: EXIT WHEN i >= l_pricing_engine_rows.LAST;

Line 5790: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

5786: x_qp_output_detail_rows => l_qp_output_detail_rows,
5787: x_return_status => l_return_status);
5788:
5789: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');
5790: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5791: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5792: raise FND_API.G_EXC_ERROR;
5793: END IF;
5794:

Line 5791: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

5787: x_return_status => l_return_status);
5788:
5789: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');
5790: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5791: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5792: raise FND_API.G_EXC_ERROR;
5793: END IF;
5794:
5795: --check for errors in the output

Line 5798: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

5794:
5795: --check for errors in the output
5796: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
5797: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
5798: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5799: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5800: raise FND_API.G_EXC_ERROR;
5801: END IF;
5802:

Line 5799: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

5795: --check for errors in the output
5796: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
5797: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
5798: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5799: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5800: raise FND_API.G_EXC_ERROR;
5801: END IF;
5802:
5803: fte_qp_engine.print_qp_output();

Line 5813: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

5809: x_charge_applied => l_charge_applied,
5810: x_return_status => l_return_status);
5811:
5812: fte_freight_pricing_util.set_location(p_loc=>'after apply_min_charge ');
5813: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5814: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5815: raise FND_API.G_EXC_ERROR;
5816: END IF;
5817: END IF;

Line 5814: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

5810: x_return_status => l_return_status);
5811:
5812: fte_freight_pricing_util.set_location(p_loc=>'after apply_min_charge ');
5813: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5814: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5815: raise FND_API.G_EXC_ERROR;
5816: END IF;
5817: END IF;
5818:

Line 5825: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

5821: l_event_num := fte_qp_engine.G_CHARGE_EVENT_NUM;
5822: fte_qp_engine.prepare_next_event_request ( x_return_status => l_return_status);
5823:
5824: fte_freight_pricing_util.set_location(p_loc=>'after prepare_next_event_request');
5825: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5826: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5827: raise FND_API.G_EXC_ERROR;
5828: END IF;
5829:

Line 5826: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

5822: fte_qp_engine.prepare_next_event_request ( x_return_status => l_return_status);
5823:
5824: fte_freight_pricing_util.set_location(p_loc=>'after prepare_next_event_request');
5825: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5826: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5827: raise FND_API.G_EXC_ERROR;
5828: END IF;
5829:
5830: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => l_qp_output_line_rows,

Line 5835: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

5831: x_qp_output_detail_rows => l_qp_output_detail_rows,
5832: x_return_status => l_return_status);
5833:
5834: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 2');
5835: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5836: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5837: raise FND_API.G_EXC_ERROR;
5838: END IF;
5839:

Line 5836: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

5832: x_return_status => l_return_status);
5833:
5834: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 2');
5835: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5836: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5837: raise FND_API.G_EXC_ERROR;
5838: END IF;
5839:
5840: --check for errors in the output

Line 5843: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

5839:
5840: --check for errors in the output
5841: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
5842: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
5843: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5844: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5845: raise FND_API.G_EXC_ERROR;
5846: END IF;
5847:

Line 5844: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

5840: --check for errors in the output
5841: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
5842: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
5843: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5844: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5845: raise FND_API.G_EXC_ERROR;
5846: END IF;
5847:
5848: fte_qp_engine.print_qp_output();

Line 5892: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

5888: p_line_type_code => 'FTECHARGE',
5889: p_charge_subtype_code => l_qp_output_detail_rows(j).charge_subtype_code,
5890: x_freight_cost_type_id => l_fc_charge_rec.freight_cost_type_id,
5891: x_return_status => l_return_status);
5892: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5893: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5894: raise FND_API.G_EXC_ERROR;
5895: END IF;
5896: ELSE -- l_qp_output_detail_rows(j).list_line_type_code = 'DIS'

Line 5893: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

5889: p_charge_subtype_code => l_qp_output_detail_rows(j).charge_subtype_code,
5890: x_freight_cost_type_id => l_fc_charge_rec.freight_cost_type_id,
5891: x_return_status => l_return_status);
5892: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5893: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5894: raise FND_API.G_EXC_ERROR;
5895: END IF;
5896: ELSE -- l_qp_output_detail_rows(j).list_line_type_code = 'DIS'
5897: l_line_discount_amount := l_line_discount_amount + l_fc_charge_rec.total_amount;

Line 5906: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

5902: p_line_type_code => 'FTEDISCOUNT',
5903: p_charge_subtype_code => 'DISCOUNT',
5904: x_freight_cost_type_id => l_fc_charge_rec.freight_cost_type_id,
5905: x_return_status => l_return_status);
5906: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5907: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5908: raise FND_API.G_EXC_ERROR;
5909: END IF;
5910: END IF;

Line 5907: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

5903: p_charge_subtype_code => 'DISCOUNT',
5904: x_freight_cost_type_id => l_fc_charge_rec.freight_cost_type_id,
5905: x_return_status => l_return_status);
5906: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5907: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5908: raise FND_API.G_EXC_ERROR;
5909: END IF;
5910: END IF;
5911:

Line 5983: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

5979: p_line_type_code => 'FTEPRICE',
5980: p_charge_subtype_code => 'PRICE',
5981: x_freight_cost_type_id => l_fc_rec.freight_cost_type_id,
5982: x_return_status => l_return_status);
5983: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5984: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5985: raise FND_API.G_EXC_ERROR;
5986: END IF;
5987:

Line 5984: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

5980: p_charge_subtype_code => 'PRICE',
5981: x_freight_cost_type_id => l_fc_rec.freight_cost_type_id,
5982: x_return_status => l_return_status);
5983: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5984: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5985: raise FND_API.G_EXC_ERROR;
5986: END IF;
5987:
5988: l_summary_amount := l_summary_amount + l_fc_rec.total_amount;

Line 6075: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

6071: p_line_type_code => 'FTESUMMARY',
6072: p_charge_subtype_code => 'SUMMARY',
6073: x_freight_cost_type_id => l_freight_cost_type_id,
6074: x_return_status => l_return_status);
6075: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
6076: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
6077: raise FND_API.G_EXC_ERROR;
6078: END IF;
6079:

Line 6076: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

6072: p_charge_subtype_code => 'SUMMARY',
6073: x_freight_cost_type_id => l_freight_cost_type_id,
6074: x_return_status => l_return_status);
6075: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
6076: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
6077: raise FND_API.G_EXC_ERROR;
6078: END IF;
6079:
6080:

Line 6154: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6150: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,l_method_name);
6151:
6152: EXCEPTION
6153: WHEN FND_API.G_EXC_ERROR THEN
6154: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6155: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
6156: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
6157: WHEN others THEN
6158: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 6158: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

6154: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6155: fte_freight_pricing_util.set_exception(l_method_name,l_log_level,'FND_API.G_EXC_ERROR');
6156: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
6157: WHEN others THEN
6158: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6159: FTE_FREIGHT_PRICING_UTIL.set_exception(l_method_name,FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
6160: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
6161: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
6162: END;