33:
34: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
35: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Update_Distance_To_Next_Stop','start');
36:
37: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
38:
39: l_distances(1):=NULL;
40: l_distance_uom:=NULL;
41:
46: x_weight=>l_weight,
47: x_weight_uom=>l_weight_uom,
48: x_return_status=>l_return_status);
49:
50: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
51: THEN
52: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
53: THEN
54:
48: x_return_status=>l_return_status);
49:
50: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
51: THEN
52: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
53: THEN
54:
55: raise FTE_FREIGHT_PRICING_UTIL.g_tl_fpa_get_trip_inf_fail;
56: END IF;
92: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Update_Distance_To_Next_Stop');
93:
94: IF (l_warning_count > 0)
95: THEN
96: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
97: END IF;
98:
99:
100: EXCEPTION
99:
100: EXCEPTION
101:
102: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_fpa_get_trip_inf_fail THEN
103: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
104: FTE_FREIGHT_PRICING_UTIL.set_exception('Update_Distance_To_Next_Stop',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fpa_get_trip_inf_fail');
105: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Update_Distance_To_Next_Stop');
106:
107:
105: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Update_Distance_To_Next_Stop');
106:
107:
108: WHEN others THEN
109: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
110: FTE_FREIGHT_PRICING_UTIL.set_exception('Update_Distance_To_Next_Stop',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
111: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
112: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Update_Distance_To_Next_Stop');
113:
197:
198: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
199: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Get_Vehicles_For_LaneSchedules','start');
200:
201: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
202:
203:
204: l_trip_vehicle_type:=NULL;
205:
210: p_vehicle_item_id =>NULL,
211: x_vehicle_type => l_trip_vehicle_type,
212: x_return_status => l_return_status);
213:
214: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
215: THEN
216: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
217: THEN
218:
212: x_return_status => l_return_status);
213:
214: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
215: THEN
216: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
217: THEN
218:
219: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_vehicle_type_fail;
220: END IF;
450: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Vehicles_For_LaneSchedules');
451:
452: IF (l_warning_count > 0)
453: THEN
454: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
455: END IF;
456:
457:
458: EXCEPTION
457:
458: EXCEPTION
459:
460: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_vehicle_type_fail THEN
461: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
462: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Vehicles_For_LaneSchedules',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_vehicle_type_fail');
463: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Vehicles_For_LaneSchedules');
464:
465:
463: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Vehicles_For_LaneSchedules');
464:
465:
466: WHEN others THEN
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
468: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Vehicles_For_LaneSchedules',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
469: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
470: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Vehicles_For_LaneSchedules');
471:
497:
498: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
499: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Update_Pricing_Required_Flag','start');
500:
501: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
502:
503: SAVEPOINT Update_Pricing_Required_Flag;
504:
505: OPEN lock_dlegs(p_trip_id);
515: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Update_Pricing_Required_Flag');
516:
517: IF (l_warning_count > 0)
518: THEN
519: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
520: END IF;
521: EXCEPTION
522: WHEN others THEN
523: ROLLBACK TO Update_Pricing_Required_Flag;
520: END IF;
521: EXCEPTION
522: WHEN others THEN
523: ROLLBACK TO Update_Pricing_Required_Flag;
524: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
525: FTE_FREIGHT_PRICING_UTIL.set_exception('Update_Pricing_Required_Flag',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
526: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
527: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Update_Pricing_Required_Flag');
528:
661:
662: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
663: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Check_Freight_Terms_Manifest','start');
664:
665: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
666:
667: x_term_manifest_flag:='N';
668: IF (p_move_id IS NULL)
669: THEN
749:
750: EXCEPTION
751: WHEN others THEN
752:
753: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
754: FTE_FREIGHT_PRICING_UTIL.set_exception('Check_Freight_Terms_Manifest',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
755: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
756: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Check_Freight_Terms_Manifest');
757:
795:
796: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
797: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Move_Records_To_Main','start');
798:
799: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
800:
801: SAVEPOINT Move_Records_To_Main;
802: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,
803: 'p_trip_id = '||p_trip_id);
812: FTE_TL_CACHE.Get_Vehicle_Type(p_trip_id => p_trip_id,
813: p_vehicle_item_id =>NULL,
814: x_vehicle_type => l_trip_vehicle_type,
815: x_return_status => l_return_status);
816: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
817: THEN
818: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
819: THEN
820:
814: x_vehicle_type => l_trip_vehicle_type,
815: x_return_status => l_return_status);
816: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
817: THEN
818: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
819: THEN
820:
821: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_vehicle_type_fail;
822: END IF;
914: p_rowid => l_rowid,
915: p_freight_cost_info => l_freight_rec,
916: x_return_status => l_return_status);
917:
918: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
919: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
920: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'Update_Freight_Cost');
921: raise FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed;
922: ELSE
915: p_freight_cost_info => l_freight_rec,
916: x_return_status => l_return_status);
917:
918: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
919: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
920: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'Update_Freight_Cost');
921: raise FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed;
922: ELSE
923: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,'Update_Freight_Cost returned warning ');
932: x_rowid => l_rowid,
933: x_freight_cost_id => l_freight_cost_id,
934: x_return_status => l_return_status);
935:
936: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
937: THEN
938: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
939: THEN
940: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_fr_cost_fail;
934: x_return_status => l_return_status);
935:
936: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
937: THEN
938: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
939: THEN
940: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_fr_cost_fail;
941: END IF;
942: END IF;
951: Update_Pricing_Required_Flag(
952: p_trip_id=>p_trip_id,
953: x_return_status =>l_return_status);
954:
955: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
956: THEN
957: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
958: THEN
959: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,
953: x_return_status =>l_return_status);
954:
955: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
956: THEN
957: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
958: THEN
959: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,
960: 'Failied to set reprice required flag for TRIP ID:'||p_trip_id);
961: END IF;
975: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Records_To_Main');
976:
977: IF (l_warning_count > 0)
978: THEN
979: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
980: END IF;
981:
982: EXCEPTION
983:
983:
984:
985: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_vehicle_type_fail THEN
986: ROLLBACK TO Move_Records_To_Main;
987: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
988: FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_vehicle_type_fail');
989: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Records_To_Main');
990:
991:
990:
991:
992: WHEN FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed THEN
993: ROLLBACK TO Move_Records_To_Main;
994: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
995: FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_update_freight_cost_failed');
996: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Records_To_Main');
997:
998:
998:
999:
1000: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_fc_id_fail THEN
1001: ROLLBACK TO Move_Records_To_Main;
1002: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1003: FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_fc_id_fail');
1004: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Records_To_Main');
1005:
1006:
1006:
1007:
1008: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_fr_cost_fail THEN
1009: ROLLBACK TO Move_Records_To_Main;
1010: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1011: FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_fr_cost_fail');
1012: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Records_To_Main');
1013:
1014:
1013:
1014:
1015: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_move_rec_lane_sched_null THEN
1016: ROLLBACK TO Move_Records_To_Main;
1017: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1018: FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_move_rec_lane_sched_null');
1019: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Records_To_Main');
1020:
1021:
1021:
1022:
1023: WHEN others THEN
1024: ROLLBACK TO Move_Records_To_Main;
1025: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1026: FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
1027: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1028: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Records_To_Main');
1029:
1102:
1103: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
1104: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Move_Dlv_Records_To_Main','start');
1105:
1106: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1107:
1108: SAVEPOINT Move_Dlv_Records_To_Main;
1109: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,
1110: 'p_dleg_id = '||p_dleg_id);
1126: FTE_TL_CACHE.Get_Vehicle_Type(p_trip_id => l_trip_id,
1127: p_vehicle_item_id =>NULL,
1128: x_vehicle_type => l_trip_vehicle_type,
1129: x_return_status => l_return_status);
1130: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1131: THEN
1132: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1133: THEN
1134:
1128: x_vehicle_type => l_trip_vehicle_type,
1129: x_return_status => l_return_status);
1130: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1131: THEN
1132: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1133: THEN
1134:
1135: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_vehicle_type_fail;
1136: END IF;
1282: p_rowid => l_rowid,
1283: p_freight_cost_info => l_freight_rec,
1284: x_return_status => l_return_status);
1285:
1286: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1287: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1288: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'Update_Freight_Cost');
1289: raise FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed;
1290: ELSE
1283: p_freight_cost_info => l_freight_rec,
1284: x_return_status => l_return_status);
1285:
1286: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1287: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1288: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'Update_Freight_Cost');
1289: raise FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed;
1290: ELSE
1291: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,'Update_Freight_Cost returned warning ');
1300: x_rowid => l_rowid,
1301: x_freight_cost_id => l_freight_cost_id,
1302: x_return_status => l_return_status);
1303:
1304: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1305: THEN
1306: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1307: THEN
1308: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_fr_cost_fail;
1302: x_return_status => l_return_status);
1303:
1304: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1305: THEN
1306: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1307: THEN
1308: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_fr_cost_fail;
1309: END IF;
1310: END IF;
1319: Update_Pricing_Required_Flag(
1320: p_trip_id=>l_trip_id,
1321: x_return_status =>l_return_status);
1322:
1323: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1324: THEN
1325: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1326: THEN
1327: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,
1321: x_return_status =>l_return_status);
1322:
1323: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1324: THEN
1325: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1326: THEN
1327: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,
1328: 'Failied to set reprice required flag for TRIP ID:'||l_trip_id);
1329: END IF;
1344: Update_Distance_To_Next_Stop(
1345: p_trip_id =>l_trip_id,
1346: x_return_status=>l_return_status);
1347:
1348: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1349: THEN
1350: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1351: THEN
1352: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,
1346: x_return_status=>l_return_status);
1347:
1348: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1349: THEN
1350: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1351: THEN
1352: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,
1353: 'Failied to update stop distances for :'||l_trip_id);
1354: raise FTE_FREIGHT_PRICING_UTIL.g_tl_update_dist_stop_fail;
1367: p_schedule_id =>p_schedule_id,
1368: p_comparison_request_id=>p_comparison_request_id,
1369: x_return_status=>l_return_status);
1370:
1371: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1372: THEN
1373: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1374: THEN
1375:
1369: x_return_status=>l_return_status);
1370:
1371: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1372: THEN
1373: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1374: THEN
1375:
1376: raise FTE_FREIGHT_PRICING_UTIL.g_tl_move_rec_to_main_fail;
1377: END IF;
1387: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Dlv_Records_To_Main');
1388:
1389: IF (l_warning_count > 0)
1390: THEN
1391: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1392: END IF;
1393:
1394: EXCEPTION
1395:
1395:
1396:
1397: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_update_dist_stop_fail THEN
1398: ROLLBACK TO Move_Dlv_Records_To_Main;
1399: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1400: FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Dlv_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_update_dist_stop_fail');
1401: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Dlv_Records_To_Main');
1402:
1403:
1403:
1404:
1405: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_move_rec_to_main_fail THEN
1406: ROLLBACK TO Move_Dlv_Records_To_Main;
1407: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1408: FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Dlv_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_move_rec_to_main_fail');
1409: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Dlv_Records_To_Main');
1410:
1411:
1410:
1411:
1412: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_vehicle_type_fail THEN
1413: ROLLBACK TO Move_Dlv_Records_To_Main;
1414: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1415: FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Dlv_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_vehicle_type_fail');
1416: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Dlv_Records_To_Main');
1417:
1418:
1417:
1418:
1419: WHEN FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed THEN
1420: ROLLBACK TO Move_Dlv_Records_To_Main;
1421: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1422: FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Dlv_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_update_freight_cost_failed');
1423: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Dlv_Records_To_Main');
1424:
1425:
1425:
1426:
1427: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_fc_id_fail THEN
1428: ROLLBACK TO Move_Dlv_Records_To_Main;
1429: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1430: FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Dlv_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_fc_id_fail');
1431: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Dlv_Records_To_Main');
1432:
1433:
1433:
1434:
1435: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_fr_cost_fail THEN
1436: ROLLBACK TO Move_Dlv_Records_To_Main;
1437: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1438: FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Dlv_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_fr_cost_fail');
1439: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Dlv_Records_To_Main');
1440:
1441:
1440:
1441:
1442: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_move_rec_lane_sched_null THEN
1443: ROLLBACK TO Move_Dlv_Records_To_Main;
1444: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1445: FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Dlv_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_move_rec_lane_sched_null');
1446: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Dlv_Records_To_Main');
1447:
1448:
1448:
1449:
1450: WHEN others THEN
1451: ROLLBACK TO Move_Dlv_Records_To_Main;
1452: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1453: FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Dlv_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
1454: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1455: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Move_Dlv_Records_To_Main');
1456:
1527:
1528: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
1529: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Delete_Main_Records','start');
1530:
1531: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1532:
1533: SAVEPOINT Delete_Main_Records;
1534:
1535:
1670:
1671: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Delete_Main_Records');
1672: IF (l_warning_count > 0)
1673: THEN
1674: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1675: END IF;
1676: EXCEPTION
1677: WHEN others THEN
1678: ROLLBACK TO Delete_Main_Records;
1675: END IF;
1676: EXCEPTION
1677: WHEN others THEN
1678: ROLLBACK TO Delete_Main_Records;
1679: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1680: FTE_FREIGHT_PRICING_UTIL.set_exception('Delete_Main_Records',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
1681: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1682: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Delete_Main_Records');
1683:
1724:
1725: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
1726: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Is_Pricing_Required','start');
1727:
1728: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1729:
1730:
1731: IF (p_move_id IS NOT NULL)
1732: THEN
1758: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Is_Pricing_Required');
1759:
1760: IF (l_warning_count > 0)
1761: THEN
1762: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1763: END IF;
1764: EXCEPTION
1765: WHEN others THEN
1766: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1762: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1763: END IF;
1764: EXCEPTION
1765: WHEN others THEN
1766: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1767: FTE_FREIGHT_PRICING_UTIL.set_exception('Is_Pricing_Required',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
1768: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1769: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Is_Pricing_Required');
1770:
1816:
1817: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
1818: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Handle_CM_Discount_Variant','start');
1819:
1820: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1821:
1822:
1823: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(
1824: x_cost_allocation_parameters=> l_cost_allocation_parameters,
1823: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(
1824: x_cost_allocation_parameters=> l_cost_allocation_parameters,
1825: x_return_status=> l_return_status);
1826:
1827: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1828: THEN
1829: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1830: THEN
1831: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail;
1825: x_return_status=> l_return_status);
1826:
1827: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1828: THEN
1829: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1830: THEN
1831: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail;
1832: END IF;
1833: END IF;
1850: x_trip_charges_rec => l_trip_charges_rec,
1851: x_stop_charges_tab => l_stop_charges_tab,
1852: x_return_status => l_return_status );
1853:
1854: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1855: THEN
1856: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1857: THEN
1858: FTE_FREIGHT_PRICING_UTIL.setmsg (
1852: x_return_status => l_return_status );
1853:
1854: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1855: THEN
1856: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1857: THEN
1858: FTE_FREIGHT_PRICING_UTIL.setmsg (
1859: p_api=>'Handle_CM_Discount_Variant',
1860: p_exc=>'g_tl_core_fail',
1882: p_stop_charges_tab=> l_stop_charges_tab,
1883: x_charge=>l_total_trip_charge,
1884: x_return_status=> l_return_status);
1885:
1886: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1887: THEN
1888: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1889: THEN
1890: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_trp_cost_fail;
1884: x_return_status=> l_return_status);
1885:
1886: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1887: THEN
1888: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1889: THEN
1890: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_trp_cost_fail;
1891: END IF;
1892: END IF;
1957: FTE_TL_COST_ALLOCATION.Scale_Trip_Charges(
1958: p_discount=> l_effective_discount,
1959: x_trip_charges_rec=> l_store_trip_rows(i),
1960: x_return_status=> l_return_status);
1961: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1962: THEN
1963: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1964: THEN
1965: raise FTE_FREIGHT_PRICING_UTIL.g_tl_scale_trip_charges_fail;
1959: x_trip_charges_rec=> l_store_trip_rows(i),
1960: x_return_status=> l_return_status);
1961: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1962: THEN
1963: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1964: THEN
1965: raise FTE_FREIGHT_PRICING_UTIL.g_tl_scale_trip_charges_fail;
1966: END IF;
1967: END IF;
1984: p_discount=> l_effective_discount,
1985: x_stop_charges_rec=> l_store_trip_stop_rows(j),
1986: x_return_status=> l_return_status);
1987:
1988: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1989: THEN
1990: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1991: THEN
1992: raise FTE_FREIGHT_PRICING_UTIL.g_tl_scale_stop_charges_fail;
1986: x_return_status=> l_return_status);
1987:
1988: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
1989: THEN
1990: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
1991: THEN
1992: raise FTE_FREIGHT_PRICING_UTIL.g_tl_scale_stop_charges_fail;
1993: END IF;
1994: END IF;
2002: THEN
2003: Delete_Main_Records(
2004: p_trip_id=>l_trip_charges_rec.trip_id,
2005: x_return_status=>l_return_status);
2006: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2007: THEN
2008: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2009: THEN
2010: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail;
2004: p_trip_id=>l_trip_charges_rec.trip_id,
2005: x_return_status=>l_return_status);
2006: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2007: THEN
2008: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2009: THEN
2010: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail;
2011: END IF;
2012: END IF;
2021: p_cost_allocation_parameters=> l_cost_allocation_parameters,
2022: x_output_cost_tab=> l_output_cost_tab,
2023: x_return_status=> l_return_status);
2024:
2025: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2026: THEN
2027: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2028: THEN
2029:
2023: x_return_status=> l_return_status);
2024:
2025: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2026: THEN
2027: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2028: THEN
2029:
2030: FTE_FREIGHT_PRICING_UTIL.setmsg (
2031: p_api=>'Handle_CM_Discount_Variant',
2042: Update_Pricing_Required_Flag(
2043: p_trip_id=>l_trip_charges_rec.trip_id,
2044: x_return_status =>l_return_status);
2045:
2046: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2047: THEN
2048: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2049: THEN
2050: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,
2044: x_return_status =>l_return_status);
2045:
2046: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2047: THEN
2048: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2049: THEN
2050: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,
2051: 'Failied to set reprice required flag for TRIP ID:'||l_trip_charges_rec.trip_id);
2052: END IF;
2066:
2067:
2068: IF (l_warning_count > 0)
2069: THEN
2070: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
2071: END IF;
2072: EXCEPTION
2073:
2074:
2072: EXCEPTION
2073:
2074:
2075: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail THEN
2076: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2077: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Discount_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_main_rec_fail');
2078: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Discount_Variant');
2079:
2080:
2078: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Discount_Variant');
2079:
2080:
2081: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail THEN
2082: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2083: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Discount_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_cost_alloc_param_fail');
2084: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Discount_Variant');
2085:
2086:
2084: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Discount_Variant');
2085:
2086:
2087: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cost_allocation_fail THEN
2088: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2089: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Discount_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cost_allocation_fail');
2090: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Discount_Variant');
2091:
2092:
2090: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Discount_Variant');
2091:
2092:
2093: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_scale_trip_charges_fail THEN
2094: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2095: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Discount_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_scale_trip_charges_fail');
2096: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Discount_Variant');
2097:
2098:
2096: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Discount_Variant');
2097:
2098:
2099: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_scale_stop_charges_fail THEN
2100: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2101: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Discount_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_scale_stop_charges_fail');
2102: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Discount_Variant');
2103:
2104:
2102: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Discount_Variant');
2103:
2104:
2105: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_trp_cost_fail THEN
2106: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2107: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Discount_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_tot_trp_cost_fail');
2108: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Discount_Variant');
2109:
2110:
2108: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Discount_Variant');
2109:
2110:
2111: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_core_fail THEN
2112: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2113: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Discount_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_core_fail');
2114: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Discount_Variant');
2115:
2116: WHEN others THEN
2113: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Discount_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_core_fail');
2114: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Discount_Variant');
2115:
2116: WHEN others THEN
2117: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2118: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Discount_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
2119: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2120: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Discount_Variant');
2121:
2166:
2167: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
2168: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Handle_CM_Rate_Variant','start');
2169:
2170: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2171:
2172:
2173: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(
2174: x_cost_allocation_parameters=> l_cost_allocation_parameters,
2173: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(
2174: x_cost_allocation_parameters=> l_cost_allocation_parameters,
2175: x_return_status=> l_return_status);
2176:
2177: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2178: THEN
2179: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2180: THEN
2181: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail;
2175: x_return_status=> l_return_status);
2176:
2177: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2178: THEN
2179: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2180: THEN
2181: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail;
2182: END IF;
2183: END IF;
2201: x_trip_charges_rec => l_trip_charges_rec,
2202: x_stop_charges_tab => l_stop_charges_tab,
2203: x_return_status => l_return_status );
2204:
2205: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2206: THEN
2207: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2208: THEN
2209:
2203: x_return_status => l_return_status );
2204:
2205: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2206: THEN
2207: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2208: THEN
2209:
2210: FTE_FREIGHT_PRICING_UTIL.setmsg (
2211: p_api=>'Handle_CM_Rate_Variant',
2224: p_stop_charges_tab=> l_stop_charges_tab,
2225: x_charge=>l_total_trip_charge,
2226: x_return_status=> l_return_status);
2227:
2228: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2229: THEN
2230: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2231: THEN
2232: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_trp_cost_fail;
2226: x_return_status=> l_return_status);
2227:
2228: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2229: THEN
2230: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2231: THEN
2232: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_trp_cost_fail;
2233: END IF;
2234: END IF;
2295: p_discount=> l_factor,
2296: x_trip_charges_rec=> l_store_trip_rows(i),
2297: x_return_status=> l_return_status);
2298:
2299: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2300: THEN
2301: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2302: THEN
2303: raise FTE_FREIGHT_PRICING_UTIL.g_tl_scale_trip_charges_fail;
2297: x_return_status=> l_return_status);
2298:
2299: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2300: THEN
2301: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2302: THEN
2303: raise FTE_FREIGHT_PRICING_UTIL.g_tl_scale_trip_charges_fail;
2304: END IF;
2305: END IF;
2320: p_discount=> l_factor,
2321: x_stop_charges_rec=> l_store_trip_stop_rows(j),
2322: x_return_status=> l_return_status);
2323:
2324: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2325: THEN
2326: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2327: THEN
2328: raise FTE_FREIGHT_PRICING_UTIL.g_tl_scale_stop_charges_fail;
2322: x_return_status=> l_return_status);
2323:
2324: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2325: THEN
2326: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2327: THEN
2328: raise FTE_FREIGHT_PRICING_UTIL.g_tl_scale_stop_charges_fail;
2329: END IF;
2330: END IF;
2338: THEN
2339: Delete_Main_Records(
2340: p_trip_id=>l_trip_charges_rec.trip_id,
2341: x_return_status=>l_return_status);
2342: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2343: THEN
2344: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2345: THEN
2346: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail;
2340: p_trip_id=>l_trip_charges_rec.trip_id,
2341: x_return_status=>l_return_status);
2342: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2343: THEN
2344: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2345: THEN
2346: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail;
2347: END IF;
2348: END IF;
2358: p_cost_allocation_parameters=> l_cost_allocation_parameters,
2359: x_output_cost_tab=> x_output_cost_tab,
2360: x_return_status=> l_return_status);
2361:
2362: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2363: THEN
2364: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2365: THEN
2366:
2360: x_return_status=> l_return_status);
2361:
2362: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2363: THEN
2364: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2365: THEN
2366:
2367: FTE_FREIGHT_PRICING_UTIL.setmsg (
2368: p_api=>'Handle_CM_Rate_Variant',
2379: Update_Pricing_Required_Flag(
2380: p_trip_id=>l_trip_charges_rec.trip_id,
2381: x_return_status =>l_return_status);
2382:
2383: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2384: THEN
2385: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2386: THEN
2387: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,
2381: x_return_status =>l_return_status);
2382:
2383: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2384: THEN
2385: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2386: THEN
2387: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,
2388: 'Failied to set reprice required flag for TRIP ID:'||l_trip_charges_rec.trip_id);
2389: END IF;
2403: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2404:
2405: IF (l_warning_count > 0)
2406: THEN
2407: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
2408: END IF;
2409: EXCEPTION
2410:
2411:
2409: EXCEPTION
2410:
2411:
2412: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_trp_cost_fail THEN
2413: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2414: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Rate_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_tot_trp_cost_fail');
2415: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2416:
2417: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_scale_trip_charges_fail THEN
2414: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Rate_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_tot_trp_cost_fail');
2415: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2416:
2417: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_scale_trip_charges_fail THEN
2418: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2419: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Rate_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_scale_trip_charges_fail');
2420: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2421:
2422: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_scale_stop_charges_fail THEN
2419: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Rate_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_scale_trip_charges_fail');
2420: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2421:
2422: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_scale_stop_charges_fail THEN
2423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2424: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Rate_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_scale_stop_charges_fail');
2425: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2426:
2427:
2425: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2426:
2427:
2428: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail THEN
2429: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2430: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Rate_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_main_rec_fail');
2431: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2432:
2433:
2431: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2432:
2433:
2434: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail THEN
2435: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2436: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Rate_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_cost_alloc_param_fail');
2437: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2438:
2439:
2437: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2438:
2439:
2440: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cost_allocation_fail THEN
2441: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2442: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Rate_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cost_allocation_fail');
2443: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2444:
2445:
2443: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2444:
2445:
2446: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_core_fail THEN
2447: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2448: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Rate_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_core_fail');
2449: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2450:
2451: WHEN others THEN
2448: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Rate_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_core_fail');
2449: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2450:
2451: WHEN others THEN
2452: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2453: FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Rate_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
2454: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2455: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Handle_CM_Rate_Variant');
2456:
2477:
2478: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
2479: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'TL_Rate_Move','start');
2480:
2481: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2482:
2483:
2484: IF (FTE_TL_CACHE.g_tl_trip_rows.LAST IS NULL)
2485: THEN
2493: x_return_status=> l_return_status);
2494:
2495:
2496:
2497: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2498: THEN
2499: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2500: THEN
2501:
2495:
2496:
2497: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2498: THEN
2499: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2500: THEN
2501:
2502:
2503: FTE_FREIGHT_PRICING_UTIL.setmsg (
2521: p_output_type=> p_output_type,
2522: x_output_cost_tab=> x_output_cost_tab,
2523: x_return_status=> l_return_status);
2524:
2525: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2526: THEN
2527: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2528: THEN
2529: raise FTE_FREIGHT_PRICING_UTIL.g_tl_handle_cm_rate_var_fail;
2523: x_return_status=> l_return_status);
2524:
2525: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2526: THEN
2527: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2528: THEN
2529: raise FTE_FREIGHT_PRICING_UTIL.g_tl_handle_cm_rate_var_fail;
2530: END IF;
2531: END IF;
2540: p_output_type=> p_output_type,
2541: x_output_cost_tab=> x_output_cost_tab,
2542: x_return_status=> l_return_status);
2543:
2544: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2545: THEN
2546: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2547: THEN
2548:
2542: x_return_status=> l_return_status);
2543:
2544: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2545: THEN
2546: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2547: THEN
2548:
2549: raise FTE_FREIGHT_PRICING_UTIL.g_tl_handle_cm_disc_var_fail;
2550: END IF;
2565: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Move');
2566:
2567: IF (l_warning_count > 0)
2568: THEN
2569: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
2570: END IF;
2571: EXCEPTION
2572:
2573:
2572:
2573:
2574:
2575: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_car_no_cm_rate_variant THEN
2576: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2577: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Move',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_car_no_cm_rate_variant');
2578: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Move');
2579:
2580:
2578: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Move');
2579:
2580:
2581: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_handle_cm_disc_var_fail THEN
2582: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2583: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Move',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_handle_cm_disc_var_fail');
2584: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Move');
2585:
2586: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_handle_cm_rate_var_fail THEN
2583: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Move',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_handle_cm_disc_var_fail');
2584: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Move');
2585:
2586: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_handle_cm_rate_var_fail THEN
2587: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2588: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Move',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_handle_cm_rate_var_fail');
2589: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Move');
2590:
2591: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_build_cache_move_fail THEN
2588: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Move',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_handle_cm_rate_var_fail');
2589: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Move');
2590:
2591: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_build_cache_move_fail THEN
2592: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2593: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Move',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_build_cache_move_fail');
2594: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Move');
2595:
2596: WHEN others THEN
2593: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Move',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_build_cache_move_fail');
2594: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Move');
2595:
2596: WHEN others THEN
2597: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2598: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Move',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
2599: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2600: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Move');
2601:
2626:
2627: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
2628: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'TL_Rate_Cached_Trip','start');
2629:
2630: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2631:
2632:
2633: FTE_TL_CORE.tl_core (
2634: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(p_trip_index),
2637: x_trip_charges_rec => l_trip_charges_rec,
2638: x_stop_charges_tab => l_stop_charges_tab,
2639: x_return_status => l_return_status );
2640:
2641: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2642: THEN
2643: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2644: THEN
2645:
2639: x_return_status => l_return_status );
2640:
2641: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2642: THEN
2643: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2644: THEN
2645:
2646: --FTE_FREIGHT_PRICING_UTIL.setmsg (
2647: -- p_api=>'TL_Rate_Cached_Trip',
2656: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(
2657: x_cost_allocation_parameters=> l_cost_allocation_parameters,
2658: x_return_status=> l_return_status);
2659:
2660: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2661: THEN
2662: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2663: THEN
2664: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail;
2658: x_return_status=> l_return_status);
2659:
2660: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2661: THEN
2662: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2663: THEN
2664: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail;
2665: END IF;
2666: END IF;
2675: p_cost_allocation_parameters=> l_cost_allocation_parameters,
2676: x_output_cost_tab=> l_output_cost_tab,
2677: x_return_status=> l_return_status);
2678:
2679: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2680: THEN
2681: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2682: THEN
2683:
2677: x_return_status=> l_return_status);
2678:
2679: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2680: THEN
2681: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2682: THEN
2683:
2684: FTE_FREIGHT_PRICING_UTIL.setmsg (
2685: p_api=>'TL_Rate_Cached_Trip',
2693: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip');
2694:
2695: IF (l_warning_count > 0)
2696: THEN
2697: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
2698: END IF;
2699: EXCEPTION
2700:
2701: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail THEN
2698: END IF;
2699: EXCEPTION
2700:
2701: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail THEN
2702: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2703: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Cached_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_cost_alloc_param_fail');
2704: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip');
2705:
2706:
2704: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip');
2705:
2706:
2707: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cost_allocation_fail THEN
2708: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2709: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Cached_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cost_allocation_fail');
2710: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip');
2711:
2712: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_core_fail THEN
2709: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Cached_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cost_allocation_fail');
2710: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip');
2711:
2712: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_core_fail THEN
2713: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2714: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Cached_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_core_fail');
2715: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip');
2716: WHEN others THEN
2717: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2713: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2714: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Cached_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_core_fail');
2715: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip');
2716: WHEN others THEN
2717: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2718: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Cached_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
2719: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2720: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip');
2721:
2762:
2763: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
2764: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'TL_Rate_Cached_Trip_Multiple','start');
2765:
2766: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2767:
2768:
2769: l_exceptions_tab.delete;
2770:
2779: x_exceptions_tab=>l_exceptions_tab,
2780: x_return_status => l_return_status );
2781:
2782:
2783: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2784: THEN
2785: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2786: THEN
2787:
2781:
2782:
2783: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2784: THEN
2785: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2786: THEN
2787:
2788: --FTE_FREIGHT_PRICING_UTIL.setmsg (
2789: -- p_api=>'TL_Rate_Cached_Trip',
2803: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(
2804: x_cost_allocation_parameters=> l_cost_allocation_parameters,
2805: x_return_status=> l_return_status);
2806:
2807: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2808: THEN
2809: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2810: THEN
2811: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail;
2805: x_return_status=> l_return_status);
2806:
2807: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2808: THEN
2809: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2810: THEN
2811: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail;
2812: END IF;
2813: END IF;
2850: p_stop_charges_tab=> l_stop_charges_one_trip_tab,
2851: x_charge=>x_lane_sched_sum_rows(k),
2852: x_return_status=> l_return_status);
2853:
2854: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2855: THEN
2856: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2857: THEN
2858: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_trp_cost_fail;
2852: x_return_status=> l_return_status);
2853:
2854: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2855: THEN
2856: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2857: THEN
2858: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_trp_cost_fail;
2859: END IF;
2860: END IF;
2874: p_cost_allocation_parameters=> l_cost_allocation_parameters,
2875: x_output_cost_tab=> x_output_cost_tab,
2876: x_return_status=> l_return_status);
2877:
2878: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2879: THEN
2880: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2881: THEN
2882:
2876: x_return_status=> l_return_status);
2877:
2878: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2879: THEN
2880: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2881: THEN
2882:
2883: --FTE_FREIGHT_PRICING_UTIL.setmsg (
2884: -- p_api=>'TL_Rate_Cached_Trip',
2925: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip_Multiple');
2926:
2927: IF (l_warning_count > 0)
2928: THEN
2929: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
2930: END IF;
2931: EXCEPTION
2932:
2933: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail THEN
2930: END IF;
2931: EXCEPTION
2932:
2933: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail THEN
2934: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2935: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Cached_Trip_Multiple',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_cost_alloc_param_fail');
2936: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip_Multiple');
2937:
2938:
2936: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip_Multiple');
2937:
2938:
2939: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cost_allocation_fail THEN
2940: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2941: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Cached_Trip_Multiple',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cost_allocation_fail');
2942: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip_Multiple');
2943:
2944: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_core_fail THEN
2941: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Cached_Trip_Multiple',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cost_allocation_fail');
2942: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip_Multiple');
2943:
2944: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_core_fail THEN
2945: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2946: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Cached_Trip_Multiple',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_core_fail');
2947: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip_Multiple');
2948: WHEN others THEN
2949: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2945: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2946: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Cached_Trip_Multiple',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_core_fail');
2947: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip_Multiple');
2948: WHEN others THEN
2949: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2950: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Cached_Trip_Multiple',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
2951: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2952: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Cached_Trip_Multiple');
2953:
2993:
2994: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
2995: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'TL_Rate_Trip','start');
2996:
2997: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2998:
2999: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
3000: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3001: THEN
2996:
2997: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2998:
2999: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
3000: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3001: THEN
3002: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3003: THEN
3004: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
2998:
2999: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
3000: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3001: THEN
3002: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3003: THEN
3004: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
3005: END IF;
3006: END IF;
3017: p_move_id=> l_move_id,
3018: x_term_manifest_flag=> l_term_manifest_flag,
3019: x_return_status => l_return_status);
3020:
3021: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3022: THEN
3023: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3024: THEN
3025: raise FTE_FREIGHT_PRICING_UTIL.g_tl_check_freight_term_fail;
3019: x_return_status => l_return_status);
3020:
3021: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3022: THEN
3023: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3024: THEN
3025: raise FTE_FREIGHT_PRICING_UTIL.g_tl_check_freight_term_fail;
3026: END IF;
3027: END IF;
3044: p_move_id => l_move_id,
3045: x_reprice_flag => l_reprice_flag,
3046: x_return_status => l_return_status);
3047:
3048: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3049: THEN
3050: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3051: THEN
3052: raise FTE_FREIGHT_PRICING_UTIL.g_tl_is_pricing_required_fail;
3046: x_return_status => l_return_status);
3047:
3048: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3049: THEN
3050: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3051: THEN
3052: raise FTE_FREIGHT_PRICING_UTIL.g_tl_is_pricing_required_fail;
3053: END IF;
3054: END IF;
3065: x_output_cost_tab=> l_output_cost_tab,
3066: x_return_status => l_return_status);
3067:
3068:
3069: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3070: THEN
3071: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3072: THEN
3073: raise FTE_FREIGHT_PRICING_UTIL.g_tl_rate_move_fail;
3067:
3068:
3069: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3070: THEN
3071: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3072: THEN
3073: raise FTE_FREIGHT_PRICING_UTIL.g_tl_rate_move_fail;
3074: END IF;
3075: END IF;
3094: p_move_id=> NULL,
3095: x_term_manifest_flag=> l_term_manifest_flag,
3096: x_return_status => l_return_status);
3097:
3098: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3099: THEN
3100: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3101: THEN
3102: raise FTE_FREIGHT_PRICING_UTIL.g_tl_check_freight_term_fail;
3096: x_return_status => l_return_status);
3097:
3098: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3099: THEN
3100: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3101: THEN
3102: raise FTE_FREIGHT_PRICING_UTIL.g_tl_check_freight_term_fail;
3103: END IF;
3104: END IF;
3121: p_move_id => NULL,
3122: x_reprice_flag => l_reprice_flag,
3123: x_return_status => l_return_status);
3124:
3125: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3126: THEN
3127: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3128: THEN
3129: raise FTE_FREIGHT_PRICING_UTIL.g_tl_is_pricing_required_fail;
3123: x_return_status => l_return_status);
3124:
3125: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3126: THEN
3127: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3128: THEN
3129: raise FTE_FREIGHT_PRICING_UTIL.g_tl_is_pricing_required_fail;
3130: END IF;
3131: END IF;
3141: Delete_Main_Records(
3142: p_trip_id => p_trip_id,
3143: x_return_status =>l_return_status);
3144:
3145: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3146: THEN
3147: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3148: THEN
3149: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail;
3143: x_return_status =>l_return_status);
3144:
3145: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3146: THEN
3147: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3148: THEN
3149: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail;
3150: END IF;
3151: END IF;
3155: FTE_TL_CACHE.TL_Build_Cache_For_Trip(
3156: p_wsh_trip_id => p_trip_id,
3157: x_return_status => l_return_status);
3158:
3159: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3160: THEN
3161: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3162: THEN
3163: FTE_FREIGHT_PRICING_UTIL.setmsg (
3157: x_return_status => l_return_status);
3158:
3159: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3160: THEN
3161: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3162: THEN
3163: FTE_FREIGHT_PRICING_UTIL.setmsg (
3164: p_api=>'TL_Rate_Trip',
3165: p_exc=>'g_tl_build_cache_trp_fail',
3177: x_output_cost_tab=> x_output_cost_tab,
3178: x_return_status=> l_return_status
3179: );
3180:
3181: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3182: THEN
3183: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3184: THEN
3185: raise FTE_FREIGHT_PRICING_UTIL.g_tl_rate_cached_trip_fail;
3179: );
3180:
3181: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3182: THEN
3183: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3184: THEN
3185: raise FTE_FREIGHT_PRICING_UTIL.g_tl_rate_cached_trip_fail;
3186: END IF;
3187: END IF;
3192: Update_Pricing_Required_Flag(
3193: p_trip_id=>p_trip_id,
3194: x_return_status =>l_return_status);
3195:
3196: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3197: THEN
3198: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3199: THEN
3200: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,
3194: x_return_status =>l_return_status);
3195:
3196: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3197: THEN
3198: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3199: THEN
3200: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,
3201: 'Failied to set reprice required flag for TRIP ID:'||p_trip_id);
3202: END IF;
3222: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Trip');
3223:
3224: IF (l_warning_count > 0)
3225: THEN
3226: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
3227: END IF;
3228: EXCEPTION
3229:
3230:
3230:
3231:
3232: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_check_freight_term_fail THEN
3233: ROLLBACK TO TL_Rate_Trip;
3234: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3235: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_check_freight_term_fail');
3236: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Trip');
3237:
3238:
3237:
3238:
3239: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail THEN
3240: ROLLBACK TO TL_Rate_Trip;
3241: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3242: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
3243: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Trip');
3244:
3245:
3244:
3245:
3246: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail THEN
3247: ROLLBACK TO TL_Rate_Trip;
3248: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3249: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_main_rec_fail');
3250: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Trip');
3251:
3252: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_is_pricing_required_fail THEN
3250: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Trip');
3251:
3252: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_is_pricing_required_fail THEN
3253: ROLLBACK TO TL_Rate_Trip;
3254: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3255: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_is_pricing_required_fail');
3256: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Trip');
3257:
3258: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_move_fail THEN
3256: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Trip');
3257:
3258: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_move_fail THEN
3259: ROLLBACK TO TL_Rate_Trip;
3260: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3261: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_rate_move_fail');
3262: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Trip');
3263:
3264: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_build_cache_trp_fail THEN
3262: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Trip');
3263:
3264: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_build_cache_trp_fail THEN
3265: ROLLBACK TO TL_Rate_Trip;
3266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3267: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_build_cache_trp_fail');
3268: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Trip');
3269:
3270: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_cached_trip_fail THEN
3268: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Trip');
3269:
3270: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_cached_trip_fail THEN
3271: ROLLBACK TO TL_Rate_Trip;
3272: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3273: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_rate_cached_trip_fail');
3274: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Trip');
3275:
3276: WHEN others THEN
3274: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Trip');
3275:
3276: WHEN others THEN
3277: ROLLBACK TO TL_Rate_Trip;
3278: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3279: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
3280: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3281: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Rate_Trip');
3282:
3313:
3314: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
3315: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Populate_Summary_Rates','start');
3316:
3317: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3318:
3319:
3320:
3321:
3386: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Populate_Summary_Rates');
3387:
3388: IF (l_warning_count > 0)
3389: THEN
3390: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
3391: END IF;
3392: EXCEPTION
3393:
3394:
3392: EXCEPTION
3393:
3394:
3395: WHEN others THEN
3396: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3397: FTE_FREIGHT_PRICING_UTIL.set_exception('Populate_Summary_Rates',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
3398: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3399: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Populate_Summary_Rates');
3400:
3449:
3450: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
3451: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'TL_Trip_Price_Compare','start');
3452:
3453: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3454:
3455:
3456: Check_Freight_Terms_Manifest(
3457: p_trip_id=> p_wsh_trip_id,
3458: p_move_id=> NULL,
3459: x_term_manifest_flag=> l_term_manifest_flag,
3460: x_return_status => l_return_status);
3461:
3462: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3463: THEN
3464: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3465: THEN
3466: raise FTE_FREIGHT_PRICING_UTIL.g_tl_check_freight_term_fail;
3460: x_return_status => l_return_status);
3461:
3462: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3463: THEN
3464: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3465: THEN
3466: raise FTE_FREIGHT_PRICING_UTIL.g_tl_check_freight_term_fail;
3467: END IF;
3468: END IF;
3492:
3493:
3494: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
3495:
3496: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3497: THEN
3498: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3499: THEN
3500: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
3494: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
3495:
3496: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3497: THEN
3498: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3499: THEN
3500: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
3501: END IF;
3502: END IF;
3507: p_schedule_rows=> p_schedule_rows,
3508: p_vehicle_rows =>p_vehicle_rows,
3509: x_return_status=> l_return_status);
3510:
3511: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3512: THEN
3513: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3514: THEN
3515: FTE_FREIGHT_PRICING_UTIL.setmsg (
3509: x_return_status=> l_return_status);
3510:
3511: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3512: THEN
3513: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3514: THEN
3515: FTE_FREIGHT_PRICING_UTIL.setmsg (
3516: p_api=>'TL_Trip_Price_Compare',
3517: p_msg_type=>'W',
3557: x_trip_charges_tab =>l_trip_charges_tab,
3558: x_stop_charges_tab =>l_stop_charges_tab,
3559: x_return_status =>l_return_status);
3560:
3561: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3562: THEN
3563: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3564: THEN
3565: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'TL_Rate_Cached_Trip_Multiple has failed');
3559: x_return_status =>l_return_status);
3560:
3561: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3562: THEN
3563: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3564: THEN
3565: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'TL_Rate_Cached_Trip_Multiple has failed');
3566: raise FTE_FREIGHT_PRICING_UTIL.g_tl_rate_cached_trip_fail;
3567: END IF;
3580: x_lane_sched_curr_rows=>x_lane_sched_curr_rows,
3581: x_summary_cache_ref=>l_summary_cache_ref,
3582: x_return_status=>l_return_status);
3583:
3584: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3585: THEN
3586: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3587: THEN
3588: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Populate_Summary_Rates has failed');
3582: x_return_status=>l_return_status);
3583:
3584: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3585: THEN
3586: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3587: THEN
3588: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Populate_Summary_Rates has failed');
3589: raise FTE_FREIGHT_PRICING_UTIL.g_tl_populate_summary_fail;
3590: END IF;
3675: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3676:
3677: IF (l_warning_count > 0)
3678: THEN
3679: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
3680: END IF;
3681: EXCEPTION
3682:
3683:
3682:
3683:
3684:
3685: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_populate_summary_fail THEN
3686: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3687: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Trip_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_populate_summary_fail');
3688: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3689:
3690:
3688: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3689:
3690:
3691: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_check_freight_term_fail THEN
3692: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3693: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Trip_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_check_freight_term_fail');
3694: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3695:
3696:
3694: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3695:
3696:
3697: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail THEN
3698: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3699: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Trip_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
3700: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3701:
3702: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_bld_cache_trp_cmp_fail THEN
3699: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Trip_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
3700: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3701:
3702: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_bld_cache_trp_cmp_fail THEN
3703: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3704: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Trip_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_bld_cache_trp_cmp_fail');
3705: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3706:
3707: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_cached_trip_fail THEN
3704: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Trip_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_bld_cache_trp_cmp_fail');
3705: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3706:
3707: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_cached_trip_fail THEN
3708: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3709: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Trip_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_rate_cached_trip_fail');
3710: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3711:
3712:
3710: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3711:
3712:
3713: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_move_fail THEN
3714: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3715: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Trip_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_rate_move_fail');
3716: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3717:
3718:
3716: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3717:
3718:
3719: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_build_cache_trp_fail THEN
3720: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3721: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Trip_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_build_cache_trp_fail');
3722: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3723:
3724:
3722: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3723:
3724:
3725: WHEN others THEN
3726: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3727: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Trip_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
3728: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3729: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Trip_Price_Compare');
3730:
3787:
3788: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
3789: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'TL_Delivery_Price_Compare','start');
3790:
3791: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3792:
3793:
3794: --No freight term/manifesting issues
3795:
3795:
3796:
3797: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
3798:
3799: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3800: THEN
3801: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3802: THEN
3803: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
3797: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
3798:
3799: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3800: THEN
3801: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3802: THEN
3803: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
3804: END IF;
3805: END IF;
3814: p_pickup_location_id=>p_pickup_location_id,
3815: p_dropoff_location_id=>p_dropoff_location_id,
3816: x_return_status=> l_return_status);
3817:
3818: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3819: THEN
3820: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3821: THEN
3822:
3816: x_return_status=> l_return_status);
3817:
3818: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3819: THEN
3820: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3821: THEN
3822:
3823: --l_warning_count:=l_warning_count+1;
3824:
3867: x_trip_charges_tab =>l_trip_charges_tab,
3868: x_stop_charges_tab =>l_stop_charges_tab,
3869: x_return_status =>l_return_status);
3870:
3871: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3872: THEN
3873: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3874: THEN
3875: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'TL_Rate_Cached_Trip_Multiple has failed');
3869: x_return_status =>l_return_status);
3870:
3871: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3872: THEN
3873: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3874: THEN
3875: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'TL_Rate_Cached_Trip_Multiple has failed');
3876: raise FTE_FREIGHT_PRICING_UTIL.g_tl_rate_cached_trip_fail;
3877: END IF;
3888: x_lane_sched_curr_rows=>x_lane_sched_curr_rows,
3889: x_summary_cache_ref=>l_summary_cache_ref,
3890: x_return_status=>l_return_status);
3891:
3892: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3893: THEN
3894: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3895: THEN
3896: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Populate_Summary_Rates has failed');
3890: x_return_status=>l_return_status);
3891:
3892: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3893: THEN
3894: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3895: THEN
3896: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Populate_Summary_Rates has failed');
3897: raise FTE_FREIGHT_PRICING_UTIL.g_tl_populate_summary_fail;
3898: END IF;
3978: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
3979:
3980: IF (l_warning_count > 0)
3981: THEN
3982: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
3983: END IF;
3984: EXCEPTION
3985:
3986:
3986:
3987:
3988:
3989: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_populate_summary_fail THEN
3990: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3991: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Delivery_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_populate_summary_fail');
3992: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
3993:
3994:
3992: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
3993:
3994:
3995: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_check_freight_term_fail THEN
3996: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3997: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Delivery_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_check_freight_term_fail');
3998: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
3999:
4000:
3998: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
3999:
4000:
4001: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail THEN
4002: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4003: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Delivery_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
4004: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
4005:
4006: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_bld_cache_trp_cmp_fail THEN
4003: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Delivery_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
4004: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
4005:
4006: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_bld_cache_trp_cmp_fail THEN
4007: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4008: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Delivery_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_bld_cache_trp_cmp_fail');
4009: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
4010:
4011: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_cached_trip_fail THEN
4008: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Delivery_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_bld_cache_trp_cmp_fail');
4009: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
4010:
4011: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_cached_trip_fail THEN
4012: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4013: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Delivery_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_rate_cached_trip_fail');
4014: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
4015:
4016:
4014: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
4015:
4016:
4017: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_move_fail THEN
4018: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4019: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Delivery_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_rate_move_fail');
4020: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
4021:
4022:
4020: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
4021:
4022:
4023: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_build_cache_trp_fail THEN
4024: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4025: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Delivery_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_build_cache_trp_fail');
4026: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
4027:
4028:
4026: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
4027:
4028:
4029: WHEN others THEN
4030: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4031: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Delivery_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
4032: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4033: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Delivery_Price_Compare');
4034:
4059:
4060: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
4061: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Get_Base_Accessory_Charges','start');
4062:
4063: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4064:
4065: FTE_TL_COST_ALLOCATION.Get_Total_Trip_Cost(
4066: p_trip_index=>p_trip_index,
4067: p_trip_charges_rec=>p_trip_charges_rec,
4068: p_stop_charges_tab=>p_stop_charges_tab,
4069: x_charge=> l_charge,
4070: x_return_status=>l_return_status);
4071:
4072: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4073: THEN
4074: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4075: THEN
4076: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_trp_cost_fail;
4070: x_return_status=>l_return_status);
4071:
4072: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4073: THEN
4074: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4075: THEN
4076: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_trp_cost_fail;
4077: END IF;
4078: END IF;
4092: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Base_Accessory_Charges');
4093:
4094: IF (l_warning_count > 0)
4095: THEN
4096: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4097: END IF;
4098:
4099: EXCEPTION
4100:
4098:
4099: EXCEPTION
4100:
4101: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_trp_cost_fail THEN
4102: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4103: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Base_Accessory_Charges',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_tot_trp_cost_fail');
4104: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Base_Accessory_Charges');
4105:
4106: WHEN others THEN
4103: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Base_Accessory_Charges',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_tot_trp_cost_fail');
4104: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Base_Accessory_Charges');
4105:
4106: WHEN others THEN
4107: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4108: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Base_Accessory_Charges',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
4109: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4110: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Base_Accessory_Charges');
4111:
4151:
4152: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
4153: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'TL_FREIGHT_ESTIMATE','start');
4154:
4155: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4156:
4157: l_cache_fail:='N';
4158:
4159: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
4156:
4157: l_cache_fail:='N';
4158:
4159: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
4160: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4161: THEN
4162: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4163: THEN
4164: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
4158:
4159: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
4160: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4161: THEN
4162: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4163: THEN
4164: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
4165: END IF;
4166: END IF;
4184: --Bug 6625274
4185: p_origin_id => p_origin_id,
4186: p_destination_id => p_destination_id);
4187:
4188: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4189: THEN
4190: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4191: THEN
4192: l_cache_fail:='Y';
4186: p_destination_id => p_destination_id);
4187:
4188: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4189: THEN
4190: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4191: THEN
4192: l_cache_fail:='Y';
4193: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Failed to build cache for estimate');
4194:
4241: x_trip_charges_rec => l_trip_charges_rec,
4242: x_stop_charges_tab => l_stop_charges_tab,
4243: x_return_status => l_return_status );
4244:
4245: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4246: THEN
4247: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4248: THEN
4249: l_rating_fail:='Y';
4243: x_return_status => l_return_status );
4244:
4245: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4246: THEN
4247: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4248: THEN
4249: l_rating_fail:='Y';
4250: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'TL Core failed for trip index :'||i);
4251: --raise FTE_FREIGHT_PRICING_UTIL.g_tl_core_fail;
4264: x_acc_charge=>x_lane_sched_acc_rows(j),
4265: x_currency=>x_lane_sched_curr_rows(j),
4266: x_return_status=>l_return_status);
4267:
4268: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4269: THEN
4270: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4271: THEN
4272:
4266: x_return_status=>l_return_status);
4267:
4268: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4269: THEN
4270: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4271: THEN
4272:
4273: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'TL base,acc charges failed for trip index :'||i);
4274: --raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_base_acc_chrg_fail;
4290: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_FREIGHT_ESTIMATE');
4291:
4292: IF (l_warning_count > 0)
4293: THEN
4294: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4295: END IF;
4296:
4297: EXCEPTION
4298:
4296:
4297: EXCEPTION
4298:
4299: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail THEN
4300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4301: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_FREIGHT_ESTIMATE',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
4302: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_FREIGHT_ESTIMATE');
4303:
4304: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cache_estimate_fail THEN
4301: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_FREIGHT_ESTIMATE',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
4302: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_FREIGHT_ESTIMATE');
4303:
4304: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cache_estimate_fail THEN
4305: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4306: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_FREIGHT_ESTIMATE',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cache_estimate_fail');
4307: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_FREIGHT_ESTIMATE');
4308:
4309: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_core_fail THEN
4306: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_FREIGHT_ESTIMATE',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cache_estimate_fail');
4307: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_FREIGHT_ESTIMATE');
4308:
4309: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_core_fail THEN
4310: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4311: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_FREIGHT_ESTIMATE',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_core_fail');
4312: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_FREIGHT_ESTIMATE');
4313:
4314:
4312: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_FREIGHT_ESTIMATE');
4313:
4314:
4315: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_base_acc_chrg_fail THEN
4316: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4317: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_FREIGHT_ESTIMATE',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_base_acc_chrg_fail');
4318: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_FREIGHT_ESTIMATE');
4319:
4320:
4318: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_FREIGHT_ESTIMATE');
4319:
4320:
4321: WHEN others THEN
4322: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4323: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_FREIGHT_ESTIMATE',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
4324: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4325: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_FREIGHT_ESTIMATE');
4326:
4372:
4373: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
4374: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Populate_OM_Rates','start');
4375:
4376: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4377:
4378:
4379: IF (p_source_header_rec.currency is NULL)
4380: THEN
4749:
4750: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Populate_OM_Rates');
4751: IF (l_warning_count > 0)
4752: THEN
4753: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4754: END IF;
4755:
4756: EXCEPTION
4757:
4755:
4756: EXCEPTION
4757:
4758: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_conv_currency_fail THEN
4759: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4760: FTE_FREIGHT_PRICING_UTIL.set_exception('Populate_OM_Rates',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
4761: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Populate_OM_Rates');
4762:
4763: WHEN others THEN
4760: FTE_FREIGHT_PRICING_UTIL.set_exception('Populate_OM_Rates',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
4761: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Populate_OM_Rates');
4762:
4763: WHEN others THEN
4764: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4765: FTE_FREIGHT_PRICING_UTIL.set_exception('Populate_OM_Rates',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
4766: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4767: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Populate_OM_Rates');
4768:
4811:
4812: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
4813: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'TL_Filter_For_Vehicle_Cost','start');
4814:
4815: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4816:
4817:
4818:
4819:
4974:
4975: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Filter_For_Vehicle_Cost');
4976: IF (l_warning_count > 0)
4977: THEN
4978: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4979: END IF;
4980:
4981:
4982:
4982:
4983: EXCEPTION
4984:
4985: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_conv_currency_fail THEN
4986: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4987: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Filter_For_Vehicle_Cost',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
4988: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Filter_For_Vehicle_Cost');
4989:
4990: WHEN others THEN
4987: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Filter_For_Vehicle_Cost',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
4988: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Filter_For_Vehicle_Cost');
4989:
4990: WHEN others THEN
4991: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4992: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Filter_For_Vehicle_Cost',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
4993: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4994: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_Filter_For_Vehicle_Cost');
4995:
5037:
5038: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
5039: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'TL_OM_Rating','start');
5040:
5041: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5042:
5043:
5044: --No freight term/manifesting issues
5045:
5045:
5046:
5047: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
5048:
5049: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5050: THEN
5051: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5052: THEN
5053: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
5047: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
5048:
5049: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5050: THEN
5051: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5052: THEN
5053: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
5054: END IF;
5055: END IF;
5073: x_lane_rows =>l_exploded_lane_rows,
5074: x_schedule_rows =>l_exploded_schedule_rows,
5075: x_ref_rows =>l_exploded_ref_rows,
5076: x_return_status =>l_return_status);
5077: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5078: THEN
5079: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
5080: THEN
5081: raise FTE_FREIGHT_PRICING_UTIL.g_tl_veh_for_lane_sched_fail;
5075: x_ref_rows =>l_exploded_ref_rows,
5076: x_return_status =>l_return_status);
5077: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5078: THEN
5079: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
5080: THEN
5081: raise FTE_FREIGHT_PRICING_UTIL.g_tl_veh_for_lane_sched_fail;
5082: END IF;
5083: END IF;
5093: x_return_status=>l_return_status);
5094:
5095:
5096:
5097: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5098: THEN
5099: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
5100: THEN
5101: raise FTE_FREIGHT_PRICING_UTIL.g_tl_bld_cache_om_fail;
5095:
5096:
5097: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5098: THEN
5099: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
5100: THEN
5101: raise FTE_FREIGHT_PRICING_UTIL.g_tl_bld_cache_om_fail;
5102: END IF;
5103: END IF;
5121: x_trip_charges_tab =>l_trip_charges_tab,
5122: x_stop_charges_tab =>l_stop_charges_tab,
5123: x_return_status =>l_return_status);
5124:
5125: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5126: THEN
5127: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5128: THEN
5129: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'TL_Rate_Cached_Trip_Multiple has failed');
5123: x_return_status =>l_return_status);
5124:
5125: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5126: THEN
5127: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5128: THEN
5129: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'TL_Rate_Cached_Trip_Multiple has failed');
5130: raise FTE_FREIGHT_PRICING_UTIL.g_tl_rate_cached_trip_fail;
5131: END IF;
5143: x_lane_sched_curr_rows=>l_lane_sched_curr_rows,
5144: x_summary_cache_ref=>l_summary_cache_ref,
5145: x_return_status=>l_return_status);
5146:
5147: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5148: THEN
5149: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5150: THEN
5151: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Populate_Summary_Rates has failed');
5145: x_return_status=>l_return_status);
5146:
5147: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5148: THEN
5149: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5150: THEN
5151: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Populate_Summary_Rates has failed');
5152: raise FTE_FREIGHT_PRICING_UTIL.g_tl_populate_summary_fail;
5153: END IF;
5216: x_filtered_list_flag=>l_filtered_rows,
5217: x_least_index=>l_least_index,
5218: x_return_status=>l_return_status);
5219:
5220: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5221: THEN
5222: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5223: THEN
5224:
5218: x_return_status=>l_return_status);
5219:
5220: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5221: THEN
5222: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5223: THEN
5224:
5225: raise FTE_FREIGHT_PRICING_UTIL.g_tl_om_filt_least_veh_fail;
5226: END IF;
5261: x_source_header_rates_tab=>x_source_header_rates_tab,
5262: x_source_line_rates_tab=>x_source_line_rates_tab,
5263: x_return_status=>l_return_status);
5264:
5265: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5266: THEN
5267: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5268: THEN
5269:
5263: x_return_status=>l_return_status);
5264:
5265: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5266: THEN
5267: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5268: THEN
5269:
5270: raise FTE_FREIGHT_PRICING_UTIL.g_tl_om_populate_rate_fail;
5271: END IF;
5275: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_OM_Rating');
5276:
5277: IF (l_warning_count > 0)
5278: THEN
5279: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
5280: END IF;
5281:
5282: EXCEPTION
5283:
5282: EXCEPTION
5283:
5284:
5285: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_populate_summary_fail THEN
5286: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5287: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_OM_Rating',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_populate_summary_fail');
5288: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_OM_Rating');
5289:
5290:
5288: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_OM_Rating');
5289:
5290:
5291: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_om_filt_least_veh_fail THEN
5292: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5293: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_OM_Rating',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_om_filt_least_veh_fail');
5294: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_OM_Rating');
5295:
5296: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_om_populate_rate_fail THEN
5293: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_OM_Rating',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_om_filt_least_veh_fail');
5294: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_OM_Rating');
5295:
5296: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_om_populate_rate_fail THEN
5297: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5298: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_OM_Rating',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_om_populate_rate_fail');
5299: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_OM_Rating');
5300:
5301:
5300:
5301:
5302:
5303: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail THEN
5304: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5305: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_OM_Rating',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
5306: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_OM_Rating');
5307:
5308: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_veh_for_lane_sched_fail THEN
5305: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_OM_Rating',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
5306: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_OM_Rating');
5307:
5308: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_veh_for_lane_sched_fail THEN
5309: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5310: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_OM_Rating',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_veh_for_lane_sched_fail');
5311: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_OM_Rating');
5312:
5313: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_cached_trip_fail THEN
5310: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_OM_Rating',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_veh_for_lane_sched_fail');
5311: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_OM_Rating');
5312:
5313: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_cached_trip_fail THEN
5314: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5315: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_OM_Rating',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_rate_cached_trip_fail');
5316: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_OM_Rating');
5317:
5318:
5317:
5318:
5319:
5320: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_bld_cache_om_fail THEN
5321: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5322: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_OM_Rating',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_bld_cache_om_fail');
5323: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_OM_Rating');
5324:
5325:
5323: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_OM_Rating');
5324:
5325:
5326: WHEN others THEN
5327: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5328: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_OM_Rating',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
5329: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
5330: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_OM_Rating');
5331:
5375:
5376: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
5377: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'BEGIN_LCSS','start');
5378:
5379: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5380:
5381:
5382: i:=p_lane_rows.FIRST;
5383: WHILE ( i IS NOT NULL)
5398: x_schedule_rows =>l_exploded_schedule_rows,
5399: x_ref_rows =>l_exploded_ref_rows,
5400: x_return_status =>l_return_status);
5401:
5402: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5403: THEN
5404: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
5405: THEN
5406: raise FTE_FREIGHT_PRICING_UTIL.g_tl_veh_for_lane_sched_fail;
5400: x_return_status =>l_return_status);
5401:
5402: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5403: THEN
5404: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
5405: THEN
5406: raise FTE_FREIGHT_PRICING_UTIL.g_tl_veh_for_lane_sched_fail;
5407: END IF;
5408: END IF;
5416: p_vehicle_rows=>l_exploded_vehicle_rows,
5417: x_return_status => l_return_status);
5418:
5419:
5420: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5421: THEN
5422: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
5423: THEN
5424: raise FTE_FREIGHT_PRICING_UTIL.g_tl_build_cache_lcss_fail;
5418:
5419:
5420: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5421: THEN
5422: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
5423: THEN
5424: raise FTE_FREIGHT_PRICING_UTIL.g_tl_build_cache_lcss_fail;
5425: END IF;
5426: END IF;
5446: x_trip_charges_tab =>l_trip_charges_tab,
5447: x_stop_charges_tab =>l_stop_charges_tab,
5448: x_return_status =>l_return_status);
5449:
5450: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5451: THEN
5452: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5453: THEN
5454: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'TL_Rate_Cached_Trip_Multiple has failed');
5448: x_return_status =>l_return_status);
5449:
5450: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5451: THEN
5452: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5453: THEN
5454: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'TL_Rate_Cached_Trip_Multiple has failed');
5455: raise FTE_FREIGHT_PRICING_UTIL.g_tl_rate_cached_trip_fail;
5456: END IF;
5467: x_lane_sched_curr_rows=>l_lane_sched_curr_rows,
5468: x_summary_cache_ref=>l_summary_cache_ref,
5469: x_return_status=>l_return_status);
5470:
5471: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5472: THEN
5473: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5474: THEN
5475: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Populate_Summary_Rates has failed');
5469: x_return_status=>l_return_status);
5470:
5471: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5472: THEN
5473: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5474: THEN
5475: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Populate_Summary_Rates has failed');
5476: raise FTE_FREIGHT_PRICING_UTIL.g_tl_populate_summary_fail;
5477: END IF;
5488: x_filtered_list_flag=>l_filtered_rows,
5489: x_least_index=>l_least_index,
5490: x_return_status=>l_return_status);
5491:
5492: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5493: THEN
5494: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5495: THEN
5496:
5490: x_return_status=>l_return_status);
5491:
5492: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5493: THEN
5494: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5495: THEN
5496:
5497: raise FTE_FREIGHT_PRICING_UTIL.g_tl_om_filt_least_veh_fail;
5498: END IF;
5548: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'BEGIN_LCSS');
5549:
5550: IF (l_warning_count > 0)
5551: THEN
5552: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
5553: END IF;
5554:
5555:
5556: EXCEPTION
5556: EXCEPTION
5557:
5558:
5559: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_populate_summary_fail THEN
5560: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5561: FTE_FREIGHT_PRICING_UTIL.set_exception('BEGIN_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_populate_summary_fail');
5562: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'BEGIN_LCSS');
5563:
5564:
5562: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'BEGIN_LCSS');
5563:
5564:
5565: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_veh_for_lane_sched_fail THEN
5566: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5567: FTE_FREIGHT_PRICING_UTIL.set_exception('BEGIN_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_veh_for_lane_sched_fail');
5568: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'BEGIN_LCSS');
5569:
5570: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_build_cache_lcss_fail THEN
5567: FTE_FREIGHT_PRICING_UTIL.set_exception('BEGIN_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_veh_for_lane_sched_fail');
5568: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'BEGIN_LCSS');
5569:
5570: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_build_cache_lcss_fail THEN
5571: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5572: FTE_FREIGHT_PRICING_UTIL.set_exception('BEGIN_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_build_cache_lcss_fail');
5573: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'BEGIN_LCSS');
5574:
5575:
5573: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'BEGIN_LCSS');
5574:
5575:
5576: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_rate_cached_trip_fail THEN
5577: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5578: FTE_FREIGHT_PRICING_UTIL.set_exception('BEGIN_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_rate_cached_trip_fail');
5579: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'BEGIN_LCSS');
5580:
5581: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_om_filt_least_veh_fail THEN
5578: FTE_FREIGHT_PRICING_UTIL.set_exception('BEGIN_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_rate_cached_trip_fail');
5579: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'BEGIN_LCSS');
5580:
5581: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_om_filt_least_veh_fail THEN
5582: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5583: FTE_FREIGHT_PRICING_UTIL.set_exception('BEGIN_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_om_filt_least_veh_fail');
5584: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'BEGIN_LCSS');
5585:
5586: WHEN others THEN
5583: FTE_FREIGHT_PRICING_UTIL.set_exception('BEGIN_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_om_filt_least_veh_fail');
5584: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'BEGIN_LCSS');
5585:
5586: WHEN others THEN
5587: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5588: FTE_FREIGHT_PRICING_UTIL.set_exception('BEGIN_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
5589: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
5590: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'BEGIN_LCSS');
5591:
5615:
5616: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
5617: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'END_LCSS','start');
5618:
5619: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5620:
5621:
5622:
5623: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(
5623: FTE_TL_COST_ALLOCATION.Get_Cost_Allocation_Parameters(
5624: x_cost_allocation_parameters => l_cost_allocation_parameters,
5625: x_return_status => l_return_status);
5626:
5627: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5628: THEN
5629: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5630: THEN
5631: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail;
5625: x_return_status => l_return_status);
5626:
5627: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5628: THEN
5629: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5630: THEN
5631: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail;
5632: END IF;
5633: END IF;
5643: x_output_cost_tab => l_output_cost_tab,
5644: x_return_status => l_return_status);
5645:
5646:
5647: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5648: THEN
5649: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5650: THEN
5651:
5645:
5646:
5647: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5648: THEN
5649: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5650: THEN
5651:
5652: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cost_allocation_fail;
5653: END IF;
5657: Update_Pricing_Required_Flag(
5658: p_trip_id=>FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id,
5659: x_return_status =>l_return_status);
5660:
5661: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5662: THEN
5663: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5664: THEN
5665: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,
5659: x_return_status =>l_return_status);
5660:
5661: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5662: THEN
5663: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5664: THEN
5665: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,
5666: 'Failied to set reprice required flag for TRIP ID:'||FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id);
5667: END IF;
5668: END IF;
5669:
5670:
5671: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
5672: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5673: THEN
5674: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5675: THEN
5676: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
5670:
5671: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
5672: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5673: THEN
5674: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5675: THEN
5676: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
5677: END IF;
5678: END IF;
5680: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'END_LCSS');
5681:
5682: IF (l_warning_count > 0)
5683: THEN
5684: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
5685: END IF;
5686:
5687:
5688: EXCEPTION
5687:
5688: EXCEPTION
5689:
5690: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail THEN
5691: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5692: FTE_FREIGHT_PRICING_UTIL.set_exception('END_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
5693: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'END_LCSS');
5694:
5695: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail THEN
5692: FTE_FREIGHT_PRICING_UTIL.set_exception('END_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
5693: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'END_LCSS');
5694:
5695: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_cost_alloc_param_fail THEN
5696: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5697: FTE_FREIGHT_PRICING_UTIL.set_exception('END_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_cost_alloc_param_fail');
5698: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'END_LCSS');
5699:
5700: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cost_allocation_fail THEN
5697: FTE_FREIGHT_PRICING_UTIL.set_exception('END_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_cost_alloc_param_fail');
5698: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'END_LCSS');
5699:
5700: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cost_allocation_fail THEN
5701: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5702: FTE_FREIGHT_PRICING_UTIL.set_exception('END_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cost_allocation_fail');
5703: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'END_LCSS');
5704:
5705:
5703: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'END_LCSS');
5704:
5705:
5706: WHEN others THEN
5707: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5708: FTE_FREIGHT_PRICING_UTIL.set_exception('END_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
5709: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
5710: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'END_LCSS');
5711:
5726:
5727: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
5728: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'ABORT_LCSS','start');
5729:
5730: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5731:
5732: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
5733:
5734: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5730: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5731:
5732: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
5733:
5734: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5735: THEN
5736: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5737: THEN
5738: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
5732: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
5733:
5734: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5735: THEN
5736: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5737: THEN
5738: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
5739: END IF;
5740: END IF;
5743:
5744:
5745: IF (l_warning_count > 0)
5746: THEN
5747: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
5748: END IF;
5749:
5750:
5751: EXCEPTION
5750:
5751: EXCEPTION
5752:
5753: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail THEN
5754: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5755: FTE_FREIGHT_PRICING_UTIL.set_exception('ABORT_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
5756: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'ABORT_LCSS');
5757:
5758: WHEN others THEN
5755: FTE_FREIGHT_PRICING_UTIL.set_exception('ABORT_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
5756: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'ABORT_LCSS');
5757:
5758: WHEN others THEN
5759: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5760: FTE_FREIGHT_PRICING_UTIL.set_exception('ABORT_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
5761: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
5762: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'ABORT_LCSS');
5763: