[Home] [Help]
356:
357: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
358: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Clear_Bulk_Arrays','start');
359:
360: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
361:
362:
363: G_B_delivery_detail_id.delete;
364: G_B_delivery_id.delete;
496: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Clear_Bulk_Arrays');
497:
498: IF (l_warning_count > 0)
499: THEN
500: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
501: END IF;
502:
503: EXCEPTION
504:
503: EXCEPTION
504:
505:
506: WHEN others THEN
507: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
508: FTE_FREIGHT_PRICING_UTIL.set_exception('Clear_Bulk_Arrays',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
509: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
510: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Clear_Bulk_Arrays');
511:
525:
526: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
527: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Insert_Into_Bulk_Array','start');
528:
529: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
530:
531:
532: G_B_index:=G_B_index+1;
533:
609: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Into_Bulk_Array');
610:
611: IF (l_warning_count > 0)
612: THEN
613: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
614: END IF;
615:
616: EXCEPTION
617:
616: EXCEPTION
617:
618:
619: WHEN others THEN
620: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
621: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Into_Bulk_Array',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
622: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
623: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Into_Bulk_Array');
624:
644:
645: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
646: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Insert_Into_Temp_Bulk_Array','start');
647:
648: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
649:
650: G_B_T_index:=G_B_T_index+1;
651:
652: OPEN C_Next_Freight_Cost_Id;
722: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Into_Temp_Bulk_Array');
723:
724: IF (l_warning_count > 0)
725: THEN
726: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
727: END IF;
728:
729: EXCEPTION
730:
729: EXCEPTION
730:
731:
732: WHEN others THEN
733: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
734: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Into_Temp_Bulk_Array',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
735: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
736: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Into_Temp_Bulk_Array');
737:
751:
752: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
753: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Bulk_Insert_Temp','start');
754:
755: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
756:
757: SAVEPOINT Bulk_Insert_Temp;
758:
759: IF (G_B_T_FREIGHT_COST_ID.first IS NOT NULL)
886: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Bulk_Insert_Temp');
887:
888: IF (l_warning_count > 0)
889: THEN
890: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
891: END IF;
892:
893: EXCEPTION
894:
893: EXCEPTION
894:
895:
896: WHEN others THEN
897: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
898: ROLLBACK TO Bulk_Insert_Temp;
899: FTE_FREIGHT_PRICING_UTIL.set_exception('Bulk_Insert_Temp',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
900: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
901: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Bulk_Insert_Temp');
916:
917: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
918: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Bulk_Insert','start');
919:
920: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
921:
922:
923:
924:
926: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Bulk_Insert');
927:
928: IF (l_warning_count > 0)
929: THEN
930: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
931: END IF;
932:
933: EXCEPTION
934:
933: EXCEPTION
934:
935:
936: WHEN others THEN
937: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
938: FTE_FREIGHT_PRICING_UTIL.set_exception('Bulk_Insert',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
939: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
940: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Bulk_Insert');
941:
957: BEGIN
958:
959: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
960: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Get_Cost_Allocation_Parameters','start');
961: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
962:
963:
964: OPEN get_cost_alloc_params;
965: FETCH get_cost_alloc_params
1011: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Cost_Allocation_Parameters');
1012:
1013: IF (l_warning_count > 0)
1014: THEN
1015: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1016: END IF;
1017: EXCEPTION
1018:
1019: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_fetch_alloc_param_fail THEN
1016: END IF;
1017: EXCEPTION
1018:
1019: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_fetch_alloc_param_fail THEN
1020: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1021: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Cost_Allocation_Parameters',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fetch_alloc_param_fail');
1022: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Cost_Allocation_Parameters');
1023:
1024: WHEN others THEN
1021: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Cost_Allocation_Parameters',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fetch_alloc_param_fail');
1022: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Cost_Allocation_Parameters');
1023:
1024: WHEN others THEN
1025: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1026: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Cost_Allocation_Parameters',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,'Get_Cost_Allocation_Parameters');
1029:
1108: BEGIN
1109:
1110: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
1111: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Initialize_Freight_Codes','start');
1112: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1113:
1114: g_tl_freight_codes(C_LOADED_DISTANCE_RT):=
1115: l_freight_code_rec;
1116: g_tl_freight_codes(C_LOADED_DISTANCE_RT).name:=
1334: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Initialize_Freight_Codes');
1335:
1336: IF (l_warning_count > 0)
1337: THEN
1338: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1339: END IF;
1340: EXCEPTION
1341: WHEN others THEN
1342: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1338: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1339: END IF;
1340: EXCEPTION
1341: WHEN others THEN
1342: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1343: FTE_FREIGHT_PRICING_UTIL.set_exception('Initialize_Freight_Codes',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
1344: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1345: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Initialize_Freight_Codes');
1346:
1365:
1366: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
1367: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Scale_Trip_Charges','start');
1368:
1369: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1370:
1371:
1372: x_trip_charges_rec.base_dist_load_chrg:=x_trip_charges_rec.base_dist_load_chrg *p_discount;
1373: x_trip_charges_rec.base_dist_load_unit_chrg:=x_trip_charges_rec.base_dist_load_unit_chrg *p_discount;
1388: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Scale_Trip_Charges');
1389:
1390: IF (l_warning_count > 0)
1391: THEN
1392: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1393: END IF;
1394: EXCEPTION
1395: WHEN others THEN
1396: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1392: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1393: END IF;
1394: EXCEPTION
1395: WHEN others THEN
1396: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1397: FTE_FREIGHT_PRICING_UTIL.set_exception('Scale_Trip_Charges',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
1398: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1399: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Scale_Trip_Charges');
1400:
1418:
1419: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
1420: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Scale_Stop_Charges','start');
1421:
1422: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1423:
1424:
1425: x_stop_charges_rec.weekday_layover_chrg :=x_stop_charges_rec.weekday_layover_chrg *p_discount;
1426: x_stop_charges_rec.weekend_layover_chrg :=x_stop_charges_rec.weekend_layover_chrg *p_discount;
1439: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Scale_Stop_Charges');
1440:
1441: IF (l_warning_count > 0)
1442: THEN
1443: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1444: END IF;
1445: EXCEPTION
1446: WHEN others THEN
1447: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1443: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1444: END IF;
1445: EXCEPTION
1446: WHEN others THEN
1447: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1448: FTE_FREIGHT_PRICING_UTIL.set_exception('Scale_Stop_Charges',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
1449: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1450: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Scale_Stop_Charges');
1451:
1476:
1477: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
1478: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Get_Loading_Fraction','start');
1479:
1480: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1481: x_fraction:=0;
1482:
1483: IF ((p_basis = FTE_RTG_GLOBALS.G_WEIGHT_BASIS) AND
1484: (p_stop_rec.pickup_weight>0))
1531: END IF;
1532: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Loading_Fraction');
1533: IF (l_warning_count > 0)
1534: THEN
1535: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1536: END IF;
1537: EXCEPTION
1538: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_invalid_basis THEN
1539: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1535: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1536: END IF;
1537: EXCEPTION
1538: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_invalid_basis THEN
1539: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1540: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Loading_Fraction',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_invalid_basis');
1541: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Loading_Fraction');
1542:
1543:
1541: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Loading_Fraction');
1542:
1543:
1544: WHEN others THEN
1545: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1546: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Loading_Fraction',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
1547: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1548: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Loading_Fraction');
1549:
1572:
1573: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
1574: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Get_Unloading_Fraction','start');
1575:
1576: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1577:
1578: x_fraction:=0;
1579: IF ((p_basis = FTE_RTG_GLOBALS.G_WEIGHT_BASIS)
1580: AND(p_stop_rec.dropoff_weight>0))
1626: END IF;
1627: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Unloading_Fraction');
1628: IF (l_warning_count > 0)
1629: THEN
1630: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1631: END IF;
1632: EXCEPTION
1633:
1634: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_invalid_basis THEN
1631: END IF;
1632: EXCEPTION
1633:
1634: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_invalid_basis THEN
1635: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1636: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Unloading_Fraction',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_invalid_basis');
1637: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Unloading_Fraction');
1638:
1639:
1637: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Unloading_Fraction');
1638:
1639:
1640: WHEN others THEN
1641: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1642: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Unloading_Fraction',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
1643: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1644: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Unloading_Fraction');
1645:
1671:
1672: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
1673: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Get_Total_Stop_Fraction','start');
1674:
1675: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1676:
1677: x_fraction:=0;
1678: IF ((p_basis = FTE_RTG_GLOBALS.G_WEIGHT_BASIS)
1679: AND((p_stop_rec.dropoff_weight+p_stop_rec.pickup_weight)>0))
1725: END IF;
1726: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Stop_Fraction');
1727: IF (l_warning_count > 0)
1728: THEN
1729: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1730: END IF;
1731: EXCEPTION
1732:
1733: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_invalid_basis THEN
1730: END IF;
1731: EXCEPTION
1732:
1733: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_invalid_basis THEN
1734: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1735: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Total_Stop_Fraction',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_invalid_basis');
1736: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Stop_Fraction');
1737:
1738:
1736: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Stop_Fraction');
1737:
1738:
1739: WHEN others THEN
1740: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1741: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Total_Stop_Fraction',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
1742: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1743: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Stop_Fraction');
1744:
1771:
1772: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
1773: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Create_Stop_Hashes','start');
1774:
1775: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1776:
1777: --Create hash to look up stop charges from stop id
1778: l_stop_index_first:=
1779: FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).stop_reference;
1814: END LOOP;
1815: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Hashes');
1816: IF (l_warning_count > 0)
1817: THEN
1818: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1819: END IF;
1820: EXCEPTION
1821: WHEN others THEN
1822: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1818: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1819: END IF;
1820: EXCEPTION
1821: WHEN others THEN
1822: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1823: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Hashes',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
1824: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1825: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Hashes');
1826:
1848:
1849: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
1850: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Assign_StopOff_Charge','start');
1851:
1852: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1853: x_dleg_alloc_rec.stop_off_chrg:=0;
1854:
1855: IF ((p_alloc_params.tl_stop_alloc_method=FTE_RTG_GLOBALS.G_CA_PICKUP_STOP) AND
1856: (p_pickup_stop_rec.pickup_weight>0))
1891: END IF;
1892: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Assign_StopOff_Charge');
1893: IF (l_warning_count > 0)
1894: THEN
1895: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1896: END IF;
1897: EXCEPTION
1898: WHEN others THEN
1899: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1895: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1896: END IF;
1897: EXCEPTION
1898: WHEN others THEN
1899: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1900: FTE_FREIGHT_PRICING_UTIL.set_exception('Assign_StopOff_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
1901: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1902: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Assign_StopOff_Charge');
1903:
1931:
1932: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
1933: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Get_StopOff_Chrg_Per_Stop','start');
1934:
1935: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1936:
1937: i:=p_stop_charges_tab.FIRST;
1938: l_stop_count:=0;
1939: WHILE(i IS NOT NULL )
1975: END IF;
1976: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_StopOff_Chrg_Per_Stop');
1977: IF (l_warning_count > 0)
1978: THEN
1979: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1980: END IF;
1981: EXCEPTION
1982: WHEN others THEN
1983: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1979: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
1980: END IF;
1981: EXCEPTION
1982: WHEN others THEN
1983: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1984: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_StopOff_Chrg_Per_Stop',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
1985: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
1986: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_StopOff_Chrg_Per_Stop');
1987:
2010:
2011: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
2012: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Allocate_Handling_Charges','start');
2013:
2014: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2015:
2016: l_factor:=0;
2017:
2018: IF ((p_trip_rec_charges.handling_chrg_basis =
2074: x_handling_chrg:=p_trip_rec_charges.handling_chrg*l_factor;
2075: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Allocate_Handling_Charges');
2076: IF (l_warning_count > 0)
2077: THEN
2078: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
2079: END IF;
2080: EXCEPTION
2081: WHEN others THEN
2082: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2078: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
2079: END IF;
2080: EXCEPTION
2081: WHEN others THEN
2082: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2083: FTE_FREIGHT_PRICING_UTIL.set_exception('Allocate_Handling_Charges',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
2084: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2085: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Allocate_Handling_Charges');
2086:
2154: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
2155: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs','start');
2156:
2157:
2158: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2159:
2160:
2161:
2162: Get_StopOff_Chrg_Per_Stop(
2167: p_stop_output_hash=> p_stop_output_hash,
2168: x_stopoff_charge=> l_stopoff_charge,
2169: x_return_status=> l_return_status);
2170:
2171: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2172: THEN
2173: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2174: THEN
2175: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_stpff_per_stop_fail;
2169: x_return_status=> l_return_status);
2170:
2171: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2172: THEN
2173: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2174: THEN
2175: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_stpff_per_stop_fail;
2176: END IF;
2177: END IF;
2248: p_alloc_params=> p_cost_allocation_parameters,
2249: x_fraction=> l_fraction,
2250: x_return_status => l_return_status);
2251:
2252: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2253: THEN
2254: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2255: THEN
2256: raise FTE_FREIGHT_PRICING_UTIL.g_tl_loading_chrg_fr_fail;
2250: x_return_status => l_return_status);
2251:
2252: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2253: THEN
2254: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2255: THEN
2256: raise FTE_FREIGHT_PRICING_UTIL.g_tl_loading_chrg_fr_fail;
2257: END IF;
2258: END IF;
2277: p_alloc_params=> p_cost_allocation_parameters,
2278: x_fraction=> l_fraction,
2279: x_return_status => l_return_status);
2280:
2281: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2282: THEN
2283: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2284: THEN
2285: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ast_ld_chrg_fr_fail;
2279: x_return_status => l_return_status);
2280:
2281: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2282: THEN
2283: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2284: THEN
2285: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ast_ld_chrg_fr_fail;
2286: END IF;
2287: END IF;
2303: p_alloc_params=> p_cost_allocation_parameters,
2304: x_fraction=> l_fraction,
2305: x_return_status => l_return_status);
2306:
2307: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2308: THEN
2309: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2310: THEN
2311: raise FTE_FREIGHT_PRICING_UTIL.g_tl_fac_ld_chrg_fr_fail;
2305: x_return_status => l_return_status);
2306:
2307: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2308: THEN
2309: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2310: THEN
2311: raise FTE_FREIGHT_PRICING_UTIL.g_tl_fac_ld_chrg_fr_fail;
2312: END IF;
2313: END IF;
2334: p_alloc_params=> p_cost_allocation_parameters,
2335: x_fraction=> l_fraction,
2336: x_return_status => l_return_status);
2337:
2338: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2339: THEN
2340: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2341: THEN
2342: raise FTE_FREIGHT_PRICING_UTIL.g_tl_fac_ast_ld_chrg_fr_fail;
2336: x_return_status => l_return_status);
2337:
2338: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2339: THEN
2340: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2341: THEN
2342: raise FTE_FREIGHT_PRICING_UTIL.g_tl_fac_ast_ld_chrg_fr_fail;
2343: END IF;
2344: END IF;
2365: p_alloc_params=> p_cost_allocation_parameters,
2366: x_fraction=> l_fraction,
2367: x_return_status => l_return_status);
2368:
2369: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2370: THEN
2371: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2372: THEN
2373: raise FTE_FREIGHT_PRICING_UTIL.g_tl_unld_chrg_fr_fail;
2367: x_return_status => l_return_status);
2368:
2369: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2370: THEN
2371: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2372: THEN
2373: raise FTE_FREIGHT_PRICING_UTIL.g_tl_unld_chrg_fr_fail;
2374: END IF;
2375: END IF;
2393: p_alloc_params=> p_cost_allocation_parameters,
2394: x_fraction=> l_fraction,
2395: x_return_status => l_return_status);
2396:
2397: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2398: THEN
2399: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2400: THEN
2401: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ast_unld_chrg_fr_fail;
2395: x_return_status => l_return_status);
2396:
2397: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2398: THEN
2399: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2400: THEN
2401: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ast_unld_chrg_fr_fail;
2402: END IF;
2403: END IF;
2420: p_alloc_params=> p_cost_allocation_parameters,
2421: x_fraction=> l_fraction,
2422: x_return_status => l_return_status);
2423:
2424: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2425: THEN
2426: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2427: THEN
2428: raise FTE_FREIGHT_PRICING_UTIL.g_tl_fac_unld_chrg_fr_fail;
2422: x_return_status => l_return_status);
2423:
2424: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2425: THEN
2426: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2427: THEN
2428: raise FTE_FREIGHT_PRICING_UTIL.g_tl_fac_unld_chrg_fr_fail;
2429: END IF;
2430: END IF;
2451: x_fraction=> l_fraction,
2452: x_return_status => l_return_status);
2453:
2454:
2455: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2456: THEN
2457: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2458: THEN
2459: raise FTE_FREIGHT_PRICING_UTIL.g_tl_fac_ast_unld_chrg_fr_fail;
2453:
2454:
2455: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2456: THEN
2457: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2458: THEN
2459: raise FTE_FREIGHT_PRICING_UTIL.g_tl_fac_ast_unld_chrg_fr_fail;
2460: END IF;
2461: END IF;
2478: p_dleg_rec=> FTE_TL_CACHE.g_tl_delivery_leg_rows(i),
2479: x_dleg_alloc_rec=> l_dleg_alloc_rec,
2480: x_return_status => l_return_status);
2481:
2482: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2483: THEN
2484: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2485: THEN
2486: raise FTE_FREIGHT_PRICING_UTIL.g_tl_assgn_stpff_chrg_fail;
2480: x_return_status => l_return_status);
2481:
2482: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2483: THEN
2484: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2485: THEN
2486: raise FTE_FREIGHT_PRICING_UTIL.g_tl_assgn_stpff_chrg_fail;
2487: END IF;
2488: END IF;
2519: x_fraction=> l_fraction,
2520: x_return_status => l_return_status);
2521:
2522:
2523: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2524: THEN
2525: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2526: THEN
2527: raise FTE_FREIGHT_PRICING_UTIL.g_tl_fac_hnd_chrg_pu_fr_fail;
2521:
2522:
2523: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2524: THEN
2525: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2526: THEN
2527: raise FTE_FREIGHT_PRICING_UTIL.g_tl_fac_hnd_chrg_pu_fr_fail;
2528: END IF;
2529: END IF;
2558: p_alloc_params=> p_cost_allocation_parameters,
2559: x_fraction=> l_fraction,
2560: x_return_status => l_return_status);
2561:
2562: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2563: THEN
2564: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2565: THEN
2566: raise FTE_FREIGHT_PRICING_UTIL.g_tl_fac_hnd_chrg_do_fr_fail;
2560: x_return_status => l_return_status);
2561:
2562: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2563: THEN
2564: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2565: THEN
2566: raise FTE_FREIGHT_PRICING_UTIL.g_tl_fac_hnd_chrg_do_fr_fail;
2567: END IF;
2568: END IF;
2615: p_cost_allocation_parameters=> p_cost_allocation_parameters,
2616: x_handling_chrg=> l_dleg_alloc_rec.handling_chrg,
2617: x_return_status => l_return_status);
2618:
2619: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2620: THEN
2621: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2622: THEN
2623: raise FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_hndl_chrg_fail;
2617: x_return_status => l_return_status);
2618:
2619: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2620: THEN
2621: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2622: THEN
2623: raise FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_hndl_chrg_fail;
2624: END IF;
2625: END IF;
2639: p_alloc_params=> p_cost_allocation_parameters,
2640: x_fraction=> l_fraction,
2641: x_return_status => l_return_status);
2642:
2643: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2644: THEN
2645: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2646: THEN
2647: raise FTE_FREIGHT_PRICING_UTIL.g_tl_org_chrg_fr_fail;
2641: x_return_status => l_return_status);
2642:
2643: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2644: THEN
2645: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2646: THEN
2647: raise FTE_FREIGHT_PRICING_UTIL.g_tl_org_chrg_fr_fail;
2648: END IF;
2649: END IF;
2668: p_alloc_params=> p_cost_allocation_parameters,
2669: x_fraction=> l_fraction,
2670: x_return_status => l_return_status);
2671:
2672: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2673: THEN
2674: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2675: THEN
2676: raise FTE_FREIGHT_PRICING_UTIL.g_tl_dst_chrg_fr_fail;
2670: x_return_status => l_return_status);
2671:
2672: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
2673: THEN
2674: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
2675: THEN
2676: raise FTE_FREIGHT_PRICING_UTIL.g_tl_dst_chrg_fr_fail;
2677: END IF;
2678: END IF;
2696: END LOOP;
2697: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2698: IF (l_warning_count > 0)
2699: THEN
2700: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
2701: END IF;
2702: EXCEPTION
2703:
2704:
2702: EXCEPTION
2703:
2704:
2705: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_conv_currency_fail THEN
2706: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2707: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
2708: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2709:
2710:
2708: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2709:
2710:
2711: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_stpff_per_stop_fail THEN
2712: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2713: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_stpff_per_stop_fail');
2714: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2715:
2716: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_loading_chrg_fr_fail THEN
2713: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_stpff_per_stop_fail');
2714: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2715:
2716: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_loading_chrg_fr_fail THEN
2717: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2718: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_loading_chrg_fr_fail');
2719: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2720:
2721: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ast_ld_chrg_fr_fail THEN
2718: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_loading_chrg_fr_fail');
2719: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2720:
2721: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ast_ld_chrg_fr_fail THEN
2722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2723: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ast_ld_chrg_fr_fail');
2724: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2725:
2726: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_fac_ld_chrg_fr_fail THEN
2723: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ast_ld_chrg_fr_fail');
2724: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2725:
2726: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_fac_ld_chrg_fr_fail THEN
2727: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2728: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fac_ld_chrg_fr_fail');
2729: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2730:
2731: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_fac_ast_ld_chrg_fr_fail THEN
2728: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fac_ld_chrg_fr_fail');
2729: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2730:
2731: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_fac_ast_ld_chrg_fr_fail THEN
2732: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2733: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fac_ast_ld_chrg_fr_fail');
2734: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2735:
2736: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_unld_chrg_fr_fail THEN
2733: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fac_ast_ld_chrg_fr_fail');
2734: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2735:
2736: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_unld_chrg_fr_fail THEN
2737: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2738: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_unld_chrg_fr_fail');
2739: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2740:
2741: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ast_unld_chrg_fr_fail THEN
2738: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_unld_chrg_fr_fail');
2739: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2740:
2741: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ast_unld_chrg_fr_fail THEN
2742: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2743: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ast_unld_chrg_fr_fail');
2744: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2745:
2746: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_fac_unld_chrg_fr_fail THEN
2743: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ast_unld_chrg_fr_fail');
2744: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2745:
2746: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_fac_unld_chrg_fr_fail THEN
2747: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2748: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fac_unld_chrg_fr_fail');
2749: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2750:
2751: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_fac_ast_unld_chrg_fr_fail THEN
2748: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fac_unld_chrg_fr_fail');
2749: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2750:
2751: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_fac_ast_unld_chrg_fr_fail THEN
2752: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2753: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fac_ast_unld_chrg_fr_fail');
2754: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2755:
2756: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_assgn_stpff_chrg_fail THEN
2753: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fac_ast_unld_chrg_fr_fail');
2754: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2755:
2756: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_assgn_stpff_chrg_fail THEN
2757: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2758: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_assgn_stpff_chrg_fail');
2759: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2760:
2761: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_fac_hnd_chrg_pu_fr_fail THEN
2758: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_assgn_stpff_chrg_fail');
2759: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2760:
2761: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_fac_hnd_chrg_pu_fr_fail THEN
2762: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2763: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fac_hnd_chrg_pu_fr_fail');
2764: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2765:
2766: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_fac_hnd_chrg_do_fr_fail THEN
2763: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fac_hnd_chrg_pu_fr_fail');
2764: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2765:
2766: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_fac_hnd_chrg_do_fr_fail THEN
2767: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2768: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fac_hnd_chrg_do_fr_fail');
2769: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2770:
2771: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_hndl_chrg_fail THEN
2768: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fac_hnd_chrg_do_fr_fail');
2769: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2770:
2771: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_hndl_chrg_fail THEN
2772: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2773: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_alloc_hndl_chrg_fail');
2774: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2775:
2776: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_org_chrg_fr_fail THEN
2773: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_alloc_hndl_chrg_fail');
2774: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2775:
2776: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_org_chrg_fr_fail THEN
2777: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2778: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_org_chrg_fr_fail');
2779: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2780:
2781: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_dst_chrg_fr_fail THEN
2778: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_org_chrg_fr_fail');
2779: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2780:
2781: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_dst_chrg_fr_fail THEN
2782: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2783: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_dst_chrg_fr_fail');
2784: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2785:
2786:
2784: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2785:
2786:
2787: WHEN others THEN
2788: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2789: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Loading_Stopoff_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
2790: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2791: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Loading_Stopoff_To_Dlegs');
2792:
2816: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
2817: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Get_Top_Most_Dleg','start');
2818:
2819:
2820: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2821:
2822: x_top_dleg_id:=NULL;
2823:
2824: -- top most child dleg
2849:
2850: EXCEPTION
2851:
2852: WHEN others THEN
2853: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2854: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Top_Most_Dleg',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
2855: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
2856: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Top_Most_Dleg');
2857:
2879:
2880: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
2881: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Get_Total_Dleg_Cost','start');
2882:
2883: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2884:
2885: l_currency:=FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).currency;
2886: x_charge:=0;
2887: x_charge:=x_charge+ NVL(p_dleg_alloc_rec.base_dist_load_chrg,0);
3009: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Dleg_Cost');
3010:
3011: IF (l_warning_count > 0)
3012: THEN
3013: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
3014: END IF;
3015: EXCEPTION
3016: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_conv_currency_fail THEN
3017: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3013: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
3014: END IF;
3015: EXCEPTION
3016: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_conv_currency_fail THEN
3017: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3018: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Total_Dleg_Cost',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
3019: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Dleg_Cost');
3020:
3021: WHEN others THEN
3018: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Total_Dleg_Cost',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
3019: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Dleg_Cost');
3020:
3021: WHEN others THEN
3022: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3023: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Total_Dleg_Cost',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
3024: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3025: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Dleg_Cost');
3026:
3057:
3058: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
3059: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Alloc_Charges_To_Chld_Dlegs','start');
3060:
3061: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3062:
3063:
3064: l_child_dleg_index_first:=
3065: FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).child_dleg_reference;
3134: p_dleg_alloc_tab=>x_dleg_alloc_tab,
3135: x_top_dleg_id=>l_top_dleg_id,
3136: x_return_status=>l_return_status);
3137:
3138: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3139: THEN
3140: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3141: THEN
3142: raise FTE_FREIGHT_PRICING_UTIL.g_tl_mdc_top_dleg_fail;
3136: x_return_status=>l_return_status);
3137:
3138: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3139: THEN
3140: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3141: THEN
3142: raise FTE_FREIGHT_PRICING_UTIL.g_tl_mdc_top_dleg_fail;
3143: END IF;
3144: END IF;
3292: p_dleg_alloc_rec=>l_child_dleg_alloc_rec,
3293: x_charge=>l_child_dleg_alloc_rec.total_dleg_charge,
3294: x_return_status=>l_return_status);
3295:
3296: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3297: THEN
3298: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3299: THEN
3300: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_to_dleg_cost_fail;
3294: x_return_status=>l_return_status);
3295:
3296: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3297: THEN
3298: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3299: THEN
3300: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_to_dleg_cost_fail;
3301: END IF;
3302: END IF;
3317:
3318: EXCEPTION
3319:
3320: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_mdc_top_dleg_fail THEN
3321: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3322: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Charges_To_Chld_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_mdc_top_dleg_fail');
3323: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Charges_To_Chld_Dlegs');
3324:
3325:
3323: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Charges_To_Chld_Dlegs');
3324:
3325:
3326: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_to_dleg_cost_fail THEN
3327: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3328: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Charges_To_Chld_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_to_dleg_cost_fail');
3329: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Charges_To_Chld_Dlegs');
3330:
3331:
3329: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Charges_To_Chld_Dlegs');
3330:
3331:
3332: WHEN others THEN
3333: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3334: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Charges_To_Chld_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
3335: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3336: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Charges_To_Chld_Dlegs');
3337:
3384: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
3385: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Alloc_Charges_To_Dlegs','start');
3386:
3387:
3388: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3389:
3390: l_weekday_layover:=0;
3391: l_weekend_layover:=0;
3392:
3563: p_dleg_alloc_rec=>x_dleg_alloc_tab(l_dleg_id),
3564: x_charge=>x_dleg_alloc_tab(l_dleg_id).total_dleg_charge,
3565: x_return_status=>l_return_status);
3566:
3567: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3568: THEN
3569: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3570: THEN
3571: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_to_dleg_cost_fail;
3565: x_return_status=>l_return_status);
3566:
3567: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3568: THEN
3569: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3570: THEN
3571: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_to_dleg_cost_fail;
3572: END IF;
3573: END IF;
3582: p_cost_allocation_parameters=>p_cost_allocation_parameters,
3583: x_dleg_alloc_tab=>x_dleg_alloc_tab,
3584: x_return_status=>l_return_status);
3585:
3586: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3587: THEN
3588: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3589: THEN
3590: raise FTE_FREIGHT_PRICING_UTIL.g_tl_mdc_alloc_chld_dleg_fail;
3584: x_return_status=>l_return_status);
3585:
3586: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3587: THEN
3588: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3589: THEN
3590: raise FTE_FREIGHT_PRICING_UTIL.g_tl_mdc_alloc_chld_dleg_fail;
3591: END IF;
3592: END IF;
3599:
3600: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Charges_To_Dlegs');
3601: IF (l_warning_count > 0)
3602: THEN
3603: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
3604: END IF;
3605: EXCEPTION
3606:
3607:
3606:
3607:
3608:
3609: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_mdc_alloc_chld_dleg_fail THEN
3610: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3611: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Charges_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_mdc_alloc_chld_dleg_fail');
3612: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Charges_To_Dlegs');
3613:
3614:
3612: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Charges_To_Dlegs');
3613:
3614:
3615: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_to_dleg_cost_fail THEN
3616: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3617: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Charges_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_to_dleg_cost_fail');
3618: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Charges_To_Dlegs');
3619:
3620:
3618: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Charges_To_Dlegs');
3619:
3620:
3621: WHEN others THEN
3622: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3623: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Charges_To_Dlegs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
3624: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3625: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Charges_To_Dlegs');
3626:
3644:
3645: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
3646: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Copy_Freight_Rec_Temp_To_Main','start');
3647:
3648: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3649:
3650: x_freight_rec.freight_cost_id:=p_freight_rec.freight_cost_id;
3651: x_freight_rec.freight_cost_type_id:=p_freight_rec.freight_cost_type_id;
3652: x_freight_rec.unit_amount:=p_freight_rec.unit_amount;
3693:
3694: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Copy_Freight_Rec_Temp_To_Main');
3695: IF (l_warning_count > 0)
3696: THEN
3697: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
3698: END IF;
3699: EXCEPTION
3700: WHEN others THEN
3701: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3697: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
3698: END IF;
3699: EXCEPTION
3700: WHEN others THEN
3701: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3702: FTE_FREIGHT_PRICING_UTIL.set_exception('Copy_Freight_Rec_Temp_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
3703: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3704: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Copy_Freight_Rec_Temp_To_Main');
3705:
3732: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
3733: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Insert_Charge_Rec','start');
3734:
3735:
3736: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3737:
3738: SAVEPOINT Insert_Charge_Rec;
3739:
3740: IF (p_cost_allocation_parameters.output_type='T')
3748: Insert_Into_Temp_Bulk_Array(
3749: p_freight_cost_rec =>l_freight_rec,
3750: x_return_status=>x_return_status);
3751:
3752: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3753: THEN
3754: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3755: THEN
3756: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_tmp_bulk_arr_fail;
3750: x_return_status=>x_return_status);
3751:
3752: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3753: THEN
3754: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3755: THEN
3756: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_tmp_bulk_arr_fail;
3757: END IF;
3758: END IF;
3763: l_freight_rec,
3764: x_freight_cost_id,
3765: x_return_status);
3766:
3767: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3768: THEN
3769: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3770: THEN
3771: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_fr_cost_temp_fail;
3765: x_return_status);
3766:
3767: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3768: THEN
3769: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3770: THEN
3771: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_fr_cost_temp_fail;
3772: END IF;
3773: END IF;
3781: p_freight_rec=> p_freight_rec,
3782: x_freight_rec=> l_freight_rec_main,
3783: x_return_status => l_return_status);
3784:
3785: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3786: THEN
3787: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3788: THEN
3789: raise FTE_FREIGHT_PRICING_UTIL.g_tl_copy_fr_rec_fail;
3783: x_return_status => l_return_status);
3784:
3785: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3786: THEN
3787: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3788: THEN
3789: raise FTE_FREIGHT_PRICING_UTIL.g_tl_copy_fr_rec_fail;
3790: END IF;
3791: END IF;
3796: AND(l_freight_rec_main.delivery_detail_id IS NULL)
3797: AND (l_freight_rec_main.line_type_code='SUMMARY'))
3798: THEN
3799: l_freight_rec_main.freight_cost_id:=FTE_FREIGHT_PRICING.get_fc_id_from_dleg(l_freight_rec_main.delivery_leg_id);
3800: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3801: THEN
3802: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3803: THEN
3804: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_fc_id_fail;
3798: THEN
3799: l_freight_rec_main.freight_cost_id:=FTE_FREIGHT_PRICING.get_fc_id_from_dleg(l_freight_rec_main.delivery_leg_id);
3800: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3801: THEN
3802: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3803: THEN
3804: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_fc_id_fail;
3805: END IF;
3806: END IF;
3810: p_rowid => l_rowid,
3811: p_freight_cost_info => l_freight_rec_main,
3812: x_return_status => l_return_status);
3813:
3814: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3815: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3816: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'Update_Freight_Cost');
3817: raise FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed;
3818: ELSE
3811: p_freight_cost_info => l_freight_rec_main,
3812: x_return_status => l_return_status);
3813:
3814: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3815: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3816: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'Update_Freight_Cost');
3817: raise FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed;
3818: ELSE
3819: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,'Update_Freight_Cost returned warning ');
3827: x_rowid => l_rowid,
3828: x_freight_cost_id => x_freight_cost_id,
3829: x_return_status => l_return_status);
3830:
3831: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3832: THEN
3833: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3834: THEN
3835: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_fr_cost_fail;
3829: x_return_status => l_return_status);
3830:
3831: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3832: THEN
3833: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3834: THEN
3835: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_fr_cost_fail;
3836: END IF;
3837: END IF;
3848: END IF;
3849: x_output_cost_tab(x_freight_cost_id):=p_freight_rec;
3850: x_output_cost_tab(x_freight_cost_id).freight_cost_id:=
3851: x_freight_cost_id;
3852: x_return_status:=WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3853: ELSE
3854: --throw an exception
3855: raise FTE_FREIGHT_PRICING_UTIL.g_tl_invalid_output_type;
3856:
3859: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');
3860:
3861: IF (l_warning_count > 0)
3862: THEN
3863: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
3864: END IF;
3865: EXCEPTION
3866:
3867: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_tmp_bulk_arr_fail THEN
3865: EXCEPTION
3866:
3867: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_tmp_bulk_arr_fail THEN
3868: ROLLBACK TO Insert_Charge_Rec;
3869: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3870: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_tmp_bulk_arr_fail');
3871: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');
3872:
3873:
3872:
3873:
3874: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_fc_id_fail THEN
3875: ROLLBACK TO Insert_Charge_Rec;
3876: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3877: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_fc_id_fail');
3878: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');
3879:
3880: WHEN FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed THEN
3878: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');
3879:
3880: WHEN FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed THEN
3881: ROLLBACK TO Insert_Charge_Rec;
3882: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3883: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_update_freight_cost_failed');
3884: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');
3885:
3886: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_fr_cost_temp_fail THEN
3884: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');
3885:
3886: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_fr_cost_temp_fail THEN
3887: ROLLBACK TO Insert_Charge_Rec;
3888: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3889: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_fr_cost_temp_fail');
3890: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');
3891:
3892: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_copy_fr_rec_fail THEN
3890: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');
3891:
3892: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_copy_fr_rec_fail THEN
3893: ROLLBACK TO Insert_Charge_Rec;
3894: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3895: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_copy_fr_rec_fail');
3896: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');
3897:
3898: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_fr_cost_fail THEN
3896: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');
3897:
3898: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_fr_cost_fail THEN
3899: ROLLBACK TO Insert_Charge_Rec;
3900: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3901: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_fr_cost_fail');
3902: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');
3903:
3904: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_invalid_output_type THEN
3902: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');
3903:
3904: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_invalid_output_type THEN
3905: ROLLBACK TO Insert_Charge_Rec;
3906: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3907: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_invalid_output_type');
3908: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');
3909:
3910: WHEN others THEN
3908: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');
3909:
3910: WHEN others THEN
3911: ROLLBACK TO Insert_Charge_Rec;
3912: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3913: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Charge_Rec',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
3914: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3915: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Charge_Rec');
3916:
3944:
3945: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
3946: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Insert_Dlv_Dtl_Level_Charge','start');
3947:
3948: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3949:
3950: l_freight_rec:=p_freight_rec;
3951: l_freight_rec.freight_cost_type_id:=p_charge_type;
3952: l_freight_rec.unit_amount:=p_charge;
3960: x_output_cost_tab=> x_output_cost_tab ,
3961: x_freight_cost_id=> l_freight_cost_id,
3962: x_return_status=> l_return_status);
3963:
3964: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3965: THEN
3966: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3967: THEN
3968: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail;
3962: x_return_status=> l_return_status);
3963:
3964: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3965: THEN
3966: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3967: THEN
3968: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail;
3969: END IF;
3970: END IF;
3973: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Dlv_Dtl_Level_Charge');
3974:
3975: IF (l_warning_count > 0)
3976: THEN
3977: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
3978: END IF;
3979: EXCEPTION
3980: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail THEN
3981: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3977: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
3978: END IF;
3979: EXCEPTION
3980: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail THEN
3981: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3982: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Dlv_Dtl_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_charge_rec_fail');
3983: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Dlv_Dtl_Level_Charge');
3984:
3985:
3983: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Dlv_Dtl_Level_Charge');
3984:
3985:
3986: WHEN others THEN
3987: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3988: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Dlv_Dtl_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
3989: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
3990: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Dlv_Dtl_Level_Charge');
3991:
4020: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
4021: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Insert_Trip_Level_Charge','start');
4022:
4023:
4024: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4025:
4026: l_freight_rec:=p_freight_rec;
4027: l_freight_rec.freight_cost_type_id:=p_charge_type;
4028: l_freight_rec.unit_amount:=p_charge;
4036: x_output_cost_tab=> x_output_cost_tab ,
4037: x_freight_cost_id=> l_freight_cost_id,
4038: x_return_status=> l_return_status);
4039:
4040: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4041: THEN
4042: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4043: THEN
4044: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail;
4038: x_return_status=> l_return_status);
4039:
4040: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4041: THEN
4042: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4043: THEN
4044: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail;
4045: END IF;
4046: END IF;
4048: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Trip_Level_Charge');
4049:
4050: IF (l_warning_count > 0)
4051: THEN
4052: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4053: END IF;
4054: EXCEPTION
4055: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail THEN
4056: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4052: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4053: END IF;
4054: EXCEPTION
4055: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail THEN
4056: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4057: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Trip_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_charge_rec_fail');
4058: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Trip_Level_Charge');
4059:
4060:
4058: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Trip_Level_Charge');
4059:
4060:
4061: WHEN others THEN
4062: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4063: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Trip_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
4064: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4065: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Trip_Level_Charge');
4066:
4109: x_output_cost_tab=> x_output_cost_tab ,
4110: x_freight_cost_id=> l_freight_cost_id,
4111: x_return_status=> l_return_status);
4112:
4113: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4114: THEN
4115: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4116: THEN
4117: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail;
4111: x_return_status=> l_return_status);
4112:
4113: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4114: THEN
4115: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4116: THEN
4117: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail;
4118: END IF;
4119: END IF;
4121: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Stop_Level_Charge');
4122:
4123: IF (l_warning_count > 0)
4124: THEN
4125: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4126: END IF;
4127: EXCEPTION
4128: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail THEN
4129: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4125: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4126: END IF;
4127: EXCEPTION
4128: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail THEN
4129: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4130: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Stop_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_charge_rec_fail');
4131: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Stop_Level_Charge');
4132:
4133: WHEN others THEN
4130: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Stop_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_charge_rec_fail');
4131: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Stop_Level_Charge');
4132:
4133: WHEN others THEN
4134: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4135: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Stop_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
4136: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4137: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Stop_Level_Charge');
4138:
4167: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
4168: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Insert_Dleg_Level_Charge','start');
4169:
4170:
4171: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4172:
4173: l_freight_rec:=p_freight_rec;
4174: l_freight_rec.freight_cost_type_id:=p_charge_type;
4175: l_freight_rec.unit_amount:=p_charge;
4183: x_output_cost_tab=> x_output_cost_tab ,
4184: x_freight_cost_id=> l_freight_cost_id,
4185: x_return_status=> l_return_status);
4186:
4187: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4188: THEN
4189: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4190: THEN
4191: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail;
4185: x_return_status=> l_return_status);
4186:
4187: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4188: THEN
4189: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4190: THEN
4191: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail;
4192: END IF;
4193: END IF;
4195: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Dleg_Level_Charge');
4196:
4197: IF (l_warning_count > 0)
4198: THEN
4199: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4200: END IF;
4201: EXCEPTION
4202: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail THEN
4203: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4199: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4200: END IF;
4201: EXCEPTION
4202: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_charge_rec_fail THEN
4203: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4204: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Dleg_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_charge_rec_fail');
4205: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Dleg_Level_Charge');
4206:
4207:
4205: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Dleg_Level_Charge');
4206:
4207:
4208: WHEN others THEN
4209: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4210: FTE_FREIGHT_PRICING_UTIL.set_exception('Insert_Dleg_Level_Charge',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
4211: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4212: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Insert_Dleg_Level_Charge');
4213:
4234: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
4235: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Get_Total_Stop_Cost','start');
4236:
4237:
4238: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4239:
4240: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'DBG-1');
4241: x_charge:=0;
4242: x_charge:=x_charge+
4368: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Stop_Cost');
4369:
4370: IF (l_warning_count > 0)
4371: THEN
4372: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4373: END IF;
4374: EXCEPTION
4375: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_conv_currency_fail THEN
4376: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4372: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4373: END IF;
4374: EXCEPTION
4375: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_conv_currency_fail THEN
4376: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4377: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Total_Stop_Cost',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
4378: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Stop_Cost');
4379:
4380:
4378: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Stop_Cost');
4379:
4380:
4381: WHEN others THEN
4382: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4383: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Total_Stop_Cost',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
4384: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4385: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Stop_Cost');
4386:
4411: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
4412: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Get_Total_Trip_Cost','start');
4413:
4414:
4415: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4416:
4417: l_currency:=FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).currency;
4418:
4419: x_charge:=0;
4441: x_charge=> l_stop_charge,
4442: x_return_status=> l_return_status);
4443:
4444:
4445: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4446: THEN
4447: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4448: THEN
4449: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_stop_cost_fail;
4443:
4444:
4445: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4446: THEN
4447: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4448: THEN
4449: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_stop_cost_fail;
4450: END IF;
4451: END IF;
4458: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Trip_Cost');
4459:
4460: IF (l_warning_count > 0)
4461: THEN
4462: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4463: END IF;
4464: EXCEPTION
4465: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_stop_cost_fail THEN
4466: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4462: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4463: END IF;
4464: EXCEPTION
4465: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_stop_cost_fail THEN
4466: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4467: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Total_Trip_Cost',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_tot_stop_cost_fail');
4468: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Trip_Cost');
4469:
4470:
4468: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Trip_Cost');
4469:
4470:
4471: WHEN others THEN
4472: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4473: FTE_FREIGHT_PRICING_UTIL.set_exception('Get_Total_Trip_Cost',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
4474: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4475: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Get_Total_Trip_Cost');
4476:
4504: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
4505: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Create_Trip_Level_Price_Recs','start');
4506:
4507:
4508: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4509: IF (p_trip_charges_rec.total_trip_rate IS NOT NULL)
4510: THEN
4511:
4512: Get_Total_Trip_Cost(
4515: p_stop_charges_tab=> p_stop_charges_tab,
4516: x_charge=> l_total_trip_charge,
4517: x_return_status=> l_return_status);
4518:
4519: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4520: THEN
4521: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4522: THEN
4523: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_trp_cost_fail;
4517: x_return_status=> l_return_status);
4518:
4519: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4520: THEN
4521: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4522: THEN
4523: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_trp_cost_fail;
4524: END IF;
4525: END IF;
4569: p_cost_allocation_parameters=> p_cost_allocation_parameters,
4570: x_output_cost_tab=> x_output_cost_tab,
4571: x_return_status=> l_return_status);
4572:
4573: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4574: THEN
4575: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4576: THEN
4577: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_tot_trp_chrg_fail;
4571: x_return_status=> l_return_status);
4572:
4573: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4574: THEN
4575: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4576: THEN
4577: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_tot_trp_chrg_fail;
4578: END IF;
4579: END IF;
4591: p_cost_allocation_parameters=> p_cost_allocation_parameters,
4592: x_output_cost_tab=> x_output_cost_tab,
4593: x_return_status=> x_return_status);
4594:
4595: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4596: THEN
4597: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4598: THEN
4599: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ld_trp_chrg_fail;
4593: x_return_status=> x_return_status);
4594:
4595: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4596: THEN
4597: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4598: THEN
4599: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ld_trp_chrg_fail;
4600: END IF;
4601: END IF;
4614: p_cost_allocation_parameters=> p_cost_allocation_parameters,
4615: x_output_cost_tab=> x_output_cost_tab,
4616: x_return_status=> l_return_status);
4617:
4618: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4619: THEN
4620: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4621: THEN
4622: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ud_trp_chrg_fail;
4616: x_return_status=> l_return_status);
4617:
4618: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4619: THEN
4620: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4621: THEN
4622: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ud_trp_chrg_fail;
4623: END IF;
4624: END IF;
4672: x_return_status=> l_return_status
4673: );
4674:
4675:
4676: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4677: THEN
4678: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4679: THEN
4680: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_unit_trp_chrg_fail;
4674:
4675:
4676: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4677: THEN
4678: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4679: THEN
4680: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_unit_trp_chrg_fail;
4681: END IF;
4682: END IF;
4692: p_cost_allocation_parameters=> p_cost_allocation_parameters,
4693: x_output_cost_tab=> x_output_cost_tab,
4694: x_return_status=> l_return_status);
4695:
4696: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4697: THEN
4698: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4699: THEN
4700: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_time_trp_chrg_fail;
4694: x_return_status=> l_return_status);
4695:
4696: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4697: THEN
4698: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4699: THEN
4700: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_time_trp_chrg_fail;
4701: END IF;
4702: END IF;
4714: p_cost_allocation_parameters=> p_cost_allocation_parameters,
4715: x_output_cost_tab=> x_output_cost_tab,
4716: x_return_status=> l_return_status);
4717:
4718: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4719: THEN
4720: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4721: THEN
4722: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_flat_trp_chrg_fail;
4716: x_return_status=> l_return_status);
4717:
4718: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4719: THEN
4720: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4721: THEN
4722: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_flat_trp_chrg_fail;
4723: END IF;
4724: END IF;
4734: p_cost_allocation_parameters=> p_cost_allocation_parameters,
4735: x_output_cost_tab=> x_output_cost_tab,
4736: x_return_status=> l_return_status);
4737:
4738: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4739: THEN
4740: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4741: THEN
4742: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_stpoff_trp_chrg_fail;
4736: x_return_status=> l_return_status);
4737:
4738: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4739: THEN
4740: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4741: THEN
4742: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_stpoff_trp_chrg_fail;
4743: END IF;
4744: END IF;
4759: p_cost_allocation_parameters=> p_cost_allocation_parameters,
4760: x_output_cost_tab=> x_output_cost_tab,
4761: x_return_status=> l_return_status);
4762:
4763: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4764: THEN
4765: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4766: THEN
4767: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_outrt_trp_chrg_fail;
4761: x_return_status=> l_return_status);
4762:
4763: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4764: THEN
4765: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4766: THEN
4767: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_outrt_trp_chrg_fail;
4768: END IF;
4769: END IF;
4794: p_cost_allocation_parameters=> p_cost_allocation_parameters,
4795: x_output_cost_tab=> x_output_cost_tab,
4796: x_return_status=> l_return_status);
4797:
4798: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4799: THEN
4800: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4801: THEN
4802: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_hndl_trp_chrg_fail;
4796: x_return_status=> l_return_status);
4797:
4798: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4799: THEN
4800: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4801: THEN
4802: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_hndl_trp_chrg_fail;
4803: END IF;
4804: END IF;
4814: p_cost_allocation_parameters=> p_cost_allocation_parameters,
4815: x_output_cost_tab=> x_output_cost_tab,
4816: x_return_status=> l_return_status);
4817:
4818: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4819: THEN
4820: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4821: THEN
4822: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_fuel_trp_chrg_fail;
4816: x_return_status=> l_return_status);
4817:
4818: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4819: THEN
4820: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4821: THEN
4822: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_fuel_trp_chrg_fail;
4823: END IF;
4824: END IF;
4839: p_cost_allocation_parameters=> p_cost_allocation_parameters,
4840: x_output_cost_tab=> x_output_cost_tab,
4841: x_return_status=> l_return_status);
4842:
4843: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4844: THEN
4845: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4846: THEN
4847: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_cmdisc_trp_chrg_fail;
4841: x_return_status=> l_return_status);
4842:
4843: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4844: THEN
4845: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4846: THEN
4847: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_cmdisc_trp_chrg_fail;
4848: END IF;
4849: END IF;
4851: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4852:
4853: IF (l_warning_count > 0)
4854: THEN
4855: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4856: END IF;
4857: EXCEPTION
4858: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_trp_cost_fail THEN
4859: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4855: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
4856: END IF;
4857: EXCEPTION
4858: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_trp_cost_fail THEN
4859: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4860: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_tot_trp_cost_fail');
4861: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4862:
4863: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_fuel_trp_chrg_fail THEN
4860: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_tot_trp_cost_fail');
4861: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4862:
4863: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_fuel_trp_chrg_fail THEN
4864: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4865: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_fuel_trp_chrg_fail');
4866: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4867:
4868:
4867:
4868:
4869:
4870: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_tot_trp_chrg_fail THEN
4871: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4872: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_tot_trp_chrg_fail');
4873: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4874:
4875: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ld_trp_chrg_fail THEN
4872: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_tot_trp_chrg_fail');
4873: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4874:
4875: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ld_trp_chrg_fail THEN
4876: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4877: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dist_ld_trp_chrg_fail');
4878: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4879:
4880: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ud_trp_chrg_fail THEN
4877: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dist_ld_trp_chrg_fail');
4878: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4879:
4880: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ud_trp_chrg_fail THEN
4881: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4882: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dist_ud_trp_chrg_fail');
4883: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4884:
4885: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_no_carr_unit_basis THEN
4882: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dist_ud_trp_chrg_fail');
4883: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4884:
4885: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_no_carr_unit_basis THEN
4886: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4887: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_no_carr_unit_basis');
4888: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4889:
4890: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_unit_trp_chrg_fail THEN
4887: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_no_carr_unit_basis');
4888: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4889:
4890: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_unit_trp_chrg_fail THEN
4891: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4892: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_unit_trp_chrg_fail');
4893: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4894:
4895: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_time_trp_chrg_fail THEN
4892: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_unit_trp_chrg_fail');
4893: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4894:
4895: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_time_trp_chrg_fail THEN
4896: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4897: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_time_trp_chrg_fail');
4898: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4899:
4900: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_flat_trp_chrg_fail THEN
4897: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_time_trp_chrg_fail');
4898: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4899:
4900: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_flat_trp_chrg_fail THEN
4901: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4902: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_flat_trp_chrg_fail');
4903: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4904:
4905: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_stpoff_trp_chrg_fail THEN
4902: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_flat_trp_chrg_fail');
4903: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4904:
4905: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_stpoff_trp_chrg_fail THEN
4906: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4907: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_stpoff_trp_chrg_fail');
4908: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4909:
4910: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_outrt_trp_chrg_fail THEN
4907: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_stpoff_trp_chrg_fail');
4908: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4909:
4910: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_outrt_trp_chrg_fail THEN
4911: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4912: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_outrt_trp_chrg_fail');
4913: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4914:
4915:
4913: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4914:
4915:
4916: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_hndl_trp_chrg_fail THEN
4917: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4918: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_hndl_trp_chrg_fail');
4919: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4920:
4921: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_cmdisc_trp_chrg_fail THEN
4918: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_hndl_trp_chrg_fail');
4919: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4920:
4921: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_cmdisc_trp_chrg_fail THEN
4922: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4923: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_cmdisc_trp_chrg_fail');
4924: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4925:
4926: WHEN others THEN
4923: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_cmdisc_trp_chrg_fail');
4924: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4925:
4926: WHEN others THEN
4927: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4928: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Trip_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
4929: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
4930: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Trip_Level_Price_Recs');
4931:
4956: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
4957: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Create_Stop_Level_Price_Recs','start');
4958:
4959:
4960: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4961:
4962: l_currency:=FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).currency;
4963:
4964: --Populate values that are common for all pricing records
4996: p_currency=> l_currency,
4997: x_charge=> l_total_stop_charge,
4998: x_return_status=> l_return_status);
4999:
5000: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5001: THEN
5002: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5003: THEN
5004: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_stop_cost_fail;
4998: x_return_status=> l_return_status);
4999:
5000: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5001: THEN
5002: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5003: THEN
5004: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_stop_cost_fail;
5005: END IF;
5006: END IF;
5014: p_cost_allocation_parameters=> p_cost_allocation_parameters,
5015: x_output_cost_tab=> x_output_cost_tab,
5016: x_return_status=> l_return_status);
5017:
5018: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5019: THEN
5020: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5021: THEN
5022: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_tot_stp_chrg_fail;
5016: x_return_status=> l_return_status);
5017:
5018: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5019: THEN
5020: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5021: THEN
5022: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_tot_stp_chrg_fail;
5023: END IF;
5024: END IF;
5035: p_cost_allocation_parameters=> p_cost_allocation_parameters,
5036: x_output_cost_tab=> x_output_cost_tab,
5037: x_return_status=> l_return_status);
5038:
5039: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5040: THEN
5041: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5042: THEN
5043: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkdayl_stp_chrg_fail;
5037: x_return_status=> l_return_status);
5038:
5039: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5040: THEN
5041: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5042: THEN
5043: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkdayl_stp_chrg_fail;
5044: END IF;
5045: END IF;
5057: p_cost_allocation_parameters=> p_cost_allocation_parameters,
5058: x_output_cost_tab=> x_output_cost_tab,
5059: x_return_status=> l_return_status);
5060:
5061: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5062: THEN
5063: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5064: THEN
5065: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkendl_stp_chrg_fail;
5059: x_return_status=> l_return_status);
5060:
5061: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5062: THEN
5063: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5064: THEN
5065: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkendl_stp_chrg_fail;
5066: END IF;
5067: END IF;
5081: p_cost_allocation_parameters=> p_cost_allocation_parameters ,
5082: x_output_cost_tab=> x_output_cost_tab,
5083: x_return_status=> l_return_status);
5084:
5085: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5086: THEN
5087: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5088: THEN
5089: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ld_stp_chrg_fail;
5083: x_return_status=> l_return_status);
5084:
5085: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5086: THEN
5087: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5088: THEN
5089: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ld_stp_chrg_fail;
5090: END IF;
5091: END IF;
5102: p_cost_allocation_parameters=> p_cost_allocation_parameters ,
5103: x_output_cost_tab=> x_output_cost_tab,
5104: x_return_status=> l_return_status);
5105:
5106: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5107: THEN
5108: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5109: THEN
5110: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ast_ld_stp_chrg_fail;
5104: x_return_status=> l_return_status);
5105:
5106: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5107: THEN
5108: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5109: THEN
5110: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ast_ld_stp_chrg_fail;
5111: END IF;
5112: END IF;
5127: p_cost_allocation_parameters=> p_cost_allocation_parameters,
5128: x_output_cost_tab=> x_output_cost_tab,
5129: x_return_status=> l_return_status);
5130:
5131: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5132: THEN
5133: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5134: THEN
5135: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ud_stp_chrg_fail;
5129: x_return_status=> l_return_status);
5130:
5131: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5132: THEN
5133: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5134: THEN
5135: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ud_stp_chrg_fail;
5136: END IF;
5137: END IF;
5148: p_cost_allocation_parameters=> p_cost_allocation_parameters,
5149: x_output_cost_tab=> x_output_cost_tab,
5150: x_return_status=> l_return_status);
5151:
5152: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5153: THEN
5154: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5155: THEN
5156: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ast_ud_stp_chrg_fail;
5150: x_return_status=> l_return_status);
5151:
5152: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5153: THEN
5154: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5155: THEN
5156: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ast_ud_stp_chrg_fail;
5157: END IF;
5158: END IF;
5171: p_cost_allocation_parameters=> p_cost_allocation_parameters,
5172: x_output_cost_tab=> x_output_cost_tab,
5173: x_return_status=> l_return_status);
5174:
5175: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5176: THEN
5177: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5178: THEN
5179: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_org_stp_chrg_fail;
5173: x_return_status=> l_return_status);
5174:
5175: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5176: THEN
5177: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5178: THEN
5179: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_org_stp_chrg_fail;
5180: END IF;
5181: END IF;
5194: p_cost_allocation_parameters=> p_cost_allocation_parameters,
5195: x_output_cost_tab=> x_output_cost_tab,
5196: x_return_status=> l_return_status);
5197:
5198: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5199: THEN
5200: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5201: THEN
5202: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dst_stp_chrg_fail;
5196: x_return_status=> l_return_status);
5197:
5198: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5199: THEN
5200: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5201: THEN
5202: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dst_stp_chrg_fail;
5203: END IF;
5204: END IF;
5236: x_output_cost_tab=>x_output_cost_tab,
5237: x_return_status=> l_return_status);
5238:
5239:
5240: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5241: THEN
5242: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5243: THEN
5244: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ld_stp_chrg_fail;
5238:
5239:
5240: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5241: THEN
5242: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5243: THEN
5244: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ld_stp_chrg_fail;
5245: END IF;
5246: END IF;
5274: p_cost_allocation_parameters=>p_cost_allocation_parameters ,
5275: x_output_cost_tab=>x_output_cost_tab,
5276: x_return_status=> l_return_status);
5277:
5278: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5279: THEN
5280: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5281: THEN
5282: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ld_stp_chrg_fail;
5276: x_return_status=> l_return_status);
5277:
5278: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5279: THEN
5280: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5281: THEN
5282: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ld_stp_chrg_fail;
5283: END IF;
5284: END IF;
5312: p_cost_allocation_parameters=>p_cost_allocation_parameters ,
5313: x_output_cost_tab=>x_output_cost_tab,
5314: x_return_status=> l_return_status);
5315:
5316: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5317: THEN
5318: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5319: THEN
5320: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ud_stp_chrg_fail;
5314: x_return_status=> l_return_status);
5315:
5316: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5317: THEN
5318: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5319: THEN
5320: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ud_stp_chrg_fail;
5321: END IF;
5322: END IF;
5349: p_cost_allocation_parameters=>p_cost_allocation_parameters ,
5350: x_output_cost_tab=>x_output_cost_tab,
5351: x_return_status=> l_return_status);
5352:
5353: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5354: THEN
5355: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5356: THEN
5357: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ud_stp_chrg_fail;
5351: x_return_status=> l_return_status);
5352:
5353: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5354: THEN
5355: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5356: THEN
5357: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ud_stp_chrg_fail;
5358: END IF;
5359: END IF;
5386: p_cost_allocation_parameters=>p_cost_allocation_parameters ,
5387: x_output_cost_tab=>x_output_cost_tab,
5388: x_return_status=> l_return_status);
5389:
5390: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5391: THEN
5392: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5393: THEN
5394: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_hndl_stp_chrg_fail;
5388: x_return_status=> l_return_status);
5389:
5390: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5391: THEN
5392: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5393: THEN
5394: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_hndl_stp_chrg_fail;
5395: END IF;
5396: END IF;
5398:
5399: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5400: IF (l_warning_count > 0)
5401: THEN
5402: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
5403: END IF;
5404: EXCEPTION
5405: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_stop_cost_fail THEN
5406: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5402: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
5403: END IF;
5404: EXCEPTION
5405: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_tot_stop_cost_fail THEN
5406: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5407: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_tot_stop_cost_fail');
5408: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5409:
5410: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_tot_stp_chrg_fail THEN
5407: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_tot_stop_cost_fail');
5408: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5409:
5410: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_tot_stp_chrg_fail THEN
5411: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5412: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_tot_stp_chrg_fail');
5413: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5414:
5415: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkdayl_stp_chrg_fail THEN
5412: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_tot_stp_chrg_fail');
5413: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5414:
5415: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkdayl_stp_chrg_fail THEN
5416: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5417: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_wkdayl_stp_chrg_fail');
5418: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5419:
5420: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkendl_stp_chrg_fail THEN
5417: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_wkdayl_stp_chrg_fail');
5418: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5419:
5420: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkendl_stp_chrg_fail THEN
5421: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5422: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_wkendl_stp_chrg_fail');
5423: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5424:
5425: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ld_stp_chrg_fail THEN
5422: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_wkendl_stp_chrg_fail');
5423: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5424:
5425: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ld_stp_chrg_fail THEN
5426: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5427: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ld_stp_chrg_fail');
5428: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5429:
5430: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ast_ld_stp_chrg_fail THEN
5427: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ld_stp_chrg_fail');
5428: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5429:
5430: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ast_ld_stp_chrg_fail THEN
5431: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5432: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ast_ld_stp_chrg_fail');
5433: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5434:
5435: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ud_stp_chrg_fail THEN
5432: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ast_ld_stp_chrg_fail');
5433: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5434:
5435: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ud_stp_chrg_fail THEN
5436: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5437: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ud_stp_chrg_fail');
5438: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5439:
5440: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ast_ud_stp_chrg_fail THEN
5437: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ud_stp_chrg_fail');
5438: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5439:
5440: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ast_ud_stp_chrg_fail THEN
5441: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5442: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ast_ud_stp_chrg_fail');
5443: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5444:
5445: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_org_stp_chrg_fail THEN
5442: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ast_ud_stp_chrg_fail');
5443: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5444:
5445: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_org_stp_chrg_fail THEN
5446: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5447: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_org_stp_chrg_fail');
5448: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5449:
5450: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dst_stp_chrg_fail THEN
5447: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_org_stp_chrg_fail');
5448: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5449:
5450: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dst_stp_chrg_fail THEN
5451: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5452: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dst_stp_chrg_fail');
5453: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5454:
5455: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_conv_currency_fail THEN
5452: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dst_stp_chrg_fail');
5453: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5454:
5455: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_conv_currency_fail THEN
5456: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5457: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
5458: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5459:
5460: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ld_stp_chrg_fail THEN
5457: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
5458: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5459:
5460: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ld_stp_chrg_fail THEN
5461: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5462: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_ld_stp_chrg_fail');
5463: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5464:
5465:
5463: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5464:
5465:
5466: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ld_stp_chrg_fail THEN
5467: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5468: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_as_ld_stp_chrg_fail');
5469: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5470:
5471: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ud_stp_chrg_fail THEN
5468: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_as_ld_stp_chrg_fail');
5469: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5470:
5471: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ud_stp_chrg_fail THEN
5472: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5473: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_ud_stp_chrg_fail');
5474: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5475:
5476: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ud_stp_chrg_fail THEN
5473: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_ud_stp_chrg_fail');
5474: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5475:
5476: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ud_stp_chrg_fail THEN
5477: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5478: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_as_ud_stp_chrg_fail');
5479: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5480:
5481: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_hndl_stp_chrg_fail THEN
5478: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_as_ud_stp_chrg_fail');
5479: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5480:
5481: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_hndl_stp_chrg_fail THEN
5482: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5483: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_hndl_stp_chrg_fail');
5484: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5485:
5486:
5486:
5487:
5488:
5489: WHEN others THEN
5490: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5491: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Stop_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
5492: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
5493: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Stop_Level_Price_Recs');
5494:
5522: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
5523: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Create_Dleg_Level_Price_Recs','start');
5524:
5525:
5526: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5527:
5528: --Populate values that are common for all pricing records
5529: l_currency:=FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index).currency;
5530:
5562: p_dleg_alloc_rec=> p_dleg_alloc_rec ,
5563: x_charge=> l_total_dleg_charge,
5564: x_return_status=> l_return_status);
5565:
5566: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5567: THEN
5568: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5569: THEN
5570: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_to_dleg_cost_fail;
5564: x_return_status=> l_return_status);
5565:
5566: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5567: THEN
5568: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5569: THEN
5570: raise FTE_FREIGHT_PRICING_UTIL.g_tl_get_to_dleg_cost_fail;
5571: END IF;
5572: END IF;
5580: p_cost_allocation_parameters=> p_cost_allocation_parameters ,
5581: x_output_cost_tab=> x_output_cost_tab,
5582: x_return_status=> l_return_status);
5583:
5584: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5585: THEN
5586: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5587: THEN
5588: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_tot_dlg_chrg_fail;
5582: x_return_status=> l_return_status);
5583:
5584: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5585: THEN
5586: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5587: THEN
5588: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_tot_dlg_chrg_fail;
5589: END IF;
5590: END IF;
5602: x_output_cost_tab=> x_output_cost_tab,
5603: x_return_status=> l_return_status);
5604:
5605:
5606: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5607: THEN
5608: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5609: THEN
5610: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ld_dlg_chrg_fail;
5604:
5605:
5606: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5607: THEN
5608: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5609: THEN
5610: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ld_dlg_chrg_fail;
5611: END IF;
5612: END IF;
5625: p_cost_allocation_parameters=> p_cost_allocation_parameters ,
5626: x_output_cost_tab=> x_output_cost_tab,
5627: x_return_status=> l_return_status);
5628:
5629: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5630: THEN
5631: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5632: THEN
5633: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ld_dlg_chrg_fail;
5627: x_return_status=> l_return_status);
5628:
5629: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5630: THEN
5631: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5632: THEN
5633: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ld_dlg_chrg_fail;
5634: END IF;
5635: END IF;
5683: x_output_cost_tab=> x_output_cost_tab,
5684: x_return_status=> l_return_status);
5685:
5686:
5687: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5688: THEN
5689: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5690: THEN
5691: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_unit_dlg_chrg_fail;
5685:
5686:
5687: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5688: THEN
5689: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5690: THEN
5691: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_unit_dlg_chrg_fail;
5692: END IF;
5693: END IF;
5705: p_cost_allocation_parameters=> p_cost_allocation_parameters ,
5706: x_output_cost_tab=> x_output_cost_tab,
5707: x_return_status=> l_return_status);
5708:
5709: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5710: THEN
5711: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5712: THEN
5713: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_time_dlg_chrg_fail;
5707: x_return_status=> l_return_status);
5708:
5709: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5710: THEN
5711: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5712: THEN
5713: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_time_dlg_chrg_fail;
5714: END IF;
5715:
5728: p_cost_allocation_parameters=> p_cost_allocation_parameters ,
5729: x_output_cost_tab=> x_output_cost_tab,
5730: x_return_status=> l_return_status);
5731:
5732: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5733: THEN
5734: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5735: THEN
5736: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_flat_dlg_chrg_fail;
5730: x_return_status=> l_return_status);
5731:
5732: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5733: THEN
5734: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5735: THEN
5736: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_flat_dlg_chrg_fail;
5737: END IF;
5738:
5751: p_cost_allocation_parameters=> p_cost_allocation_parameters ,
5752: x_output_cost_tab=> x_output_cost_tab,
5753: x_return_status=> l_return_status);
5754:
5755: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5756: THEN
5757: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5758: THEN
5759: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_stpoff_dlg_chrg_fail;
5753: x_return_status=> l_return_status);
5754:
5755: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5756: THEN
5757: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5758: THEN
5759: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_stpoff_dlg_chrg_fail;
5760: END IF;
5761:
5773: p_cost_allocation_parameters=> p_cost_allocation_parameters ,
5774: x_output_cost_tab=> x_output_cost_tab,
5775: x_return_status=> l_return_status);
5776:
5777: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5778: THEN
5779: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5780: THEN
5781: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_outrt_dlg_chrg_fail;
5775: x_return_status=> l_return_status);
5776:
5777: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5778: THEN
5779: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5780: THEN
5781: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_outrt_dlg_chrg_fail;
5782: END IF;
5783:
5809: x_output_cost_tab=> x_output_cost_tab,
5810: x_return_status=> l_return_status);
5811:
5812:
5813: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5814: THEN
5815: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5816: THEN
5817: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_hndl_dlg_chrg_fail;
5811:
5812:
5813: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5814: THEN
5815: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5816: THEN
5817: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_hndl_dlg_chrg_fail;
5818: END IF;
5819:
5832: x_output_cost_tab=> x_output_cost_tab,
5833: x_return_status=> l_return_status);
5834:
5835:
5836: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5837: THEN
5838: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5839: THEN
5840: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_fuel_dlg_chrg_fail;
5834:
5835:
5836: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5837: THEN
5838: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5839: THEN
5840: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_fuel_dlg_chrg_fail;
5841: END IF;
5842:
5856: p_cost_allocation_parameters=> p_cost_allocation_parameters ,
5857: x_output_cost_tab=> x_output_cost_tab,
5858: x_return_status=> l_return_status);
5859:
5860: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5861: THEN
5862: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5863: THEN
5864: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkdayl_dlg_chrg_fail;
5858: x_return_status=> l_return_status);
5859:
5860: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5861: THEN
5862: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5863: THEN
5864: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkdayl_dlg_chrg_fail;
5865: END IF;
5866:
5878: p_cost_allocation_parameters=> p_cost_allocation_parameters ,
5879: x_output_cost_tab=> x_output_cost_tab,
5880: x_return_status=> l_return_status);
5881:
5882: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5883: THEN
5884: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5885: THEN
5886: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkendl_dlg_chrg_fail;
5880: x_return_status=> l_return_status);
5881:
5882: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5883: THEN
5884: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5885: THEN
5886: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkendl_dlg_chrg_fail;
5887: END IF;
5888:
5901: p_cost_allocation_parameters=> p_cost_allocation_parameters ,
5902: x_output_cost_tab=> x_output_cost_tab,
5903: x_return_status=> l_return_status);
5904:
5905: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5906: THEN
5907: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5908: THEN
5909: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ld_dlg_chrg_fail;
5903: x_return_status=> l_return_status);
5904:
5905: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5906: THEN
5907: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5908: THEN
5909: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ld_dlg_chrg_fail;
5910: END IF;
5911:
5923: x_output_cost_tab=> x_output_cost_tab,
5924: x_return_status=> l_return_status);
5925:
5926:
5927: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5928: THEN
5929: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5930: THEN
5931: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ld_dlg_chrg_fail;
5925:
5926:
5927: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5928: THEN
5929: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5930: THEN
5931: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ld_dlg_chrg_fail;
5932: END IF;
5933:
5945: p_cost_allocation_parameters=> p_cost_allocation_parameters ,
5946: x_output_cost_tab=> x_output_cost_tab,
5947: x_return_status=> l_return_status);
5948:
5949: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5950: THEN
5951: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5952: THEN
5953: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ud_dlg_chrg_fail;
5947: x_return_status=> l_return_status);
5948:
5949: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5950: THEN
5951: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5952: THEN
5953: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ud_dlg_chrg_fail;
5954: END IF;
5955:
5967: p_cost_allocation_parameters=> p_cost_allocation_parameters ,
5968: x_output_cost_tab=> x_output_cost_tab,
5969: x_return_status=> l_return_status);
5970:
5971: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5972: THEN
5973: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5974: THEN
5975: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ud_dlg_chrg_fail;
5969: x_return_status=> l_return_status);
5970:
5971: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5972: THEN
5973: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5974: THEN
5975: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ud_dlg_chrg_fail;
5976: END IF;
5977:
5990: x_output_cost_tab=> x_output_cost_tab,
5991: x_return_status=> l_return_status);
5992:
5993:
5994: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5995: THEN
5996: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5997: THEN
5998: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_org_dlg_chrg_fail;
5992:
5993:
5994: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5995: THEN
5996: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5997: THEN
5998: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_org_dlg_chrg_fail;
5999: END IF;
6000:
6012: p_cost_allocation_parameters=> p_cost_allocation_parameters ,
6013: x_output_cost_tab=> x_output_cost_tab,
6014: x_return_status=> l_return_status);
6015:
6016: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6017: THEN
6018: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6019: THEN
6020: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dst_dlg_chrg_fail;
6014: x_return_status=> l_return_status);
6015:
6016: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6017: THEN
6018: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6019: THEN
6020: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dst_dlg_chrg_fail;
6021: END IF;
6022:
6051: x_output_cost_tab=> x_output_cost_tab,
6052: x_return_status=> l_return_status);
6053:
6054:
6055: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6056: THEN
6057: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6058: THEN
6059: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ld_dlg_chrg_fail;
6053:
6054:
6055: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6056: THEN
6057: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6058: THEN
6059: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ld_dlg_chrg_fail;
6060: END IF;
6061:
6090: x_output_cost_tab=> x_output_cost_tab,
6091: x_return_status=> l_return_status);
6092:
6093:
6094: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6095: THEN
6096: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6097: THEN
6098: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ld_dlg_chrg_fail;
6092:
6093:
6094: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6095: THEN
6096: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6097: THEN
6098: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ld_dlg_chrg_fail;
6099: END IF;
6100:
6130: x_output_cost_tab=> x_output_cost_tab,
6131: x_return_status=> l_return_status);
6132:
6133:
6134: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6135: THEN
6136: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6137: THEN
6138: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ud_dlg_chrg_fail;
6132:
6133:
6134: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6135: THEN
6136: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6137: THEN
6138: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ud_dlg_chrg_fail;
6139: END IF;
6140:
6171: x_output_cost_tab=> x_output_cost_tab,
6172: x_return_status=> l_return_status);
6173:
6174:
6175: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6176: THEN
6177: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6178: THEN
6179: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ud_dlg_chrg_fail;
6173:
6174:
6175: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6176: THEN
6177: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6178: THEN
6179: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ud_dlg_chrg_fail;
6180: END IF;
6181:
6209: p_cost_allocation_parameters=> p_cost_allocation_parameters ,
6210: x_output_cost_tab=> x_output_cost_tab,
6211: x_return_status=> l_return_status);
6212:
6213: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6214: THEN
6215: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6216: THEN
6217: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_hndl_dlg_chrg_fail;
6211: x_return_status=> l_return_status);
6212:
6213: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6214: THEN
6215: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6216: THEN
6217: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_hndl_dlg_chrg_fail;
6218: END IF;
6219:
6222:
6223: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6224: IF (l_warning_count > 0)
6225: THEN
6226: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
6227: END IF;
6228: EXCEPTION
6229: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_to_dleg_cost_fail THEN
6230: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6226: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
6227: END IF;
6228: EXCEPTION
6229: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_get_to_dleg_cost_fail THEN
6230: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6231: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_to_dleg_cost_fail');
6232: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6233:
6234: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_fuel_dlg_chrg_fail THEN
6231: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_get_to_dleg_cost_fail');
6232: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6233:
6234: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_fuel_dlg_chrg_fail THEN
6235: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6236: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_fuel_dlg_chrg_fail');
6237: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6238:
6239:
6237: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6238:
6239:
6240: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_tot_dlg_chrg_fail THEN
6241: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6242: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_tot_dlg_chrg_fail');
6243: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6244:
6245: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ld_dlg_chrg_fail THEN
6242: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_tot_dlg_chrg_fail');
6243: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6244:
6245: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ld_dlg_chrg_fail THEN
6246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6247: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dist_ld_dlg_chrg_fail');
6248: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6249:
6250: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_no_carr_unit_basis THEN
6247: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dist_ld_dlg_chrg_fail');
6248: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6249:
6250: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_no_carr_unit_basis THEN
6251: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6252: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_no_carr_unit_basis');
6253: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6254:
6255: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_unit_dlg_chrg_fail THEN
6252: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_no_carr_unit_basis');
6253: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6254:
6255: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_unit_dlg_chrg_fail THEN
6256: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6257: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_unit_dlg_chrg_fail');
6258: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6259:
6260: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_time_dlg_chrg_fail THEN
6257: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_unit_dlg_chrg_fail');
6258: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6259:
6260: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_time_dlg_chrg_fail THEN
6261: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6262: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_time_dlg_chrg_fail');
6263: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6264:
6265: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_flat_dlg_chrg_fail THEN
6262: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_time_dlg_chrg_fail');
6263: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6264:
6265: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_flat_dlg_chrg_fail THEN
6266: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6267: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_flat_dlg_chrg_fail');
6268: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6269:
6270: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_stpoff_dlg_chrg_fail THEN
6267: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_flat_dlg_chrg_fail');
6268: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6269:
6270: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_stpoff_dlg_chrg_fail THEN
6271: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6272: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_stpoff_dlg_chrg_fail');
6273: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6274:
6275: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_outrt_dlg_chrg_fail THEN
6272: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_stpoff_dlg_chrg_fail');
6273: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6274:
6275: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_outrt_dlg_chrg_fail THEN
6276: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6277: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_outrt_dlg_chrg_fail');
6278: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6279:
6280: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_hndl_dlg_chrg_fail THEN
6277: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_outrt_dlg_chrg_fail');
6278: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6279:
6280: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_hndl_dlg_chrg_fail THEN
6281: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6282: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_hndl_dlg_chrg_fail');
6283: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6284:
6285: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkdayl_dlg_chrg_fail THEN
6282: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_hndl_dlg_chrg_fail');
6283: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6284:
6285: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkdayl_dlg_chrg_fail THEN
6286: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6287: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_wkdayl_dlg_chrg_fail');
6288: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6289:
6290: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkendl_dlg_chrg_fail THEN
6287: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_wkdayl_dlg_chrg_fail');
6288: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6289:
6290: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkendl_dlg_chrg_fail THEN
6291: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6292: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_wkendl_dlg_chrg_fail');
6293: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6294:
6295: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ld_dlg_chrg_fail THEN
6292: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_wkendl_dlg_chrg_fail');
6293: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6294:
6295: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ld_dlg_chrg_fail THEN
6296: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6297: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ld_dlg_chrg_fail');
6298: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6299:
6300: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ld_dlg_chrg_fail THEN
6297: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ld_dlg_chrg_fail');
6298: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6299:
6300: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ld_dlg_chrg_fail THEN
6301: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6302: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_as_ld_dlg_chrg_fail');
6303: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6304:
6305: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ud_dlg_chrg_fail THEN
6302: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_as_ld_dlg_chrg_fail');
6303: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6304:
6305: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ud_dlg_chrg_fail THEN
6306: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6307: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ud_dlg_chrg_fail');
6308: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6309:
6310: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ud_dlg_chrg_fail THEN
6307: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ud_dlg_chrg_fail');
6308: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6309:
6310: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ud_dlg_chrg_fail THEN
6311: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6312: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_as_ud_dlg_chrg_fail');
6313: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6314:
6315: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_org_dlg_chrg_fail THEN
6312: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_as_ud_dlg_chrg_fail');
6313: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6314:
6315: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_org_dlg_chrg_fail THEN
6316: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6317: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_org_dlg_chrg_fail');
6318: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6319:
6320: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dst_dlg_chrg_fail THEN
6317: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_org_dlg_chrg_fail');
6318: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6319:
6320: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dst_dlg_chrg_fail THEN
6321: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6322: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dst_dlg_chrg_fail');
6323: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6324:
6325: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_conv_currency_fail THEN
6322: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dst_dlg_chrg_fail');
6323: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6324:
6325: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_conv_currency_fail THEN
6326: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6327: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
6328: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6329:
6330: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ld_dlg_chrg_fail THEN
6327: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
6328: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6329:
6330: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ld_dlg_chrg_fail THEN
6331: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6332: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_ld_dlg_chrg_fail');
6333: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6334:
6335: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ld_dlg_chrg_fail THEN
6332: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_ld_dlg_chrg_fail');
6333: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6334:
6335: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ld_dlg_chrg_fail THEN
6336: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6337: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_as_ld_dlg_chrg_fail');
6338: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6339:
6340: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ud_dlg_chrg_fail THEN
6337: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_as_ld_dlg_chrg_fail');
6338: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6339:
6340: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ud_dlg_chrg_fail THEN
6341: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6342: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_ud_dlg_chrg_fail');
6343: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6344:
6345: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ud_dlg_chrg_fail THEN
6342: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_ud_dlg_chrg_fail');
6343: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6344:
6345: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ud_dlg_chrg_fail THEN
6346: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6347: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_as_ud_dlg_chrg_fail');
6348: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6349:
6350: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_hndl_dlg_chrg_fail THEN
6347: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_as_ud_dlg_chrg_fail');
6348: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6349:
6350: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_hndl_dlg_chrg_fail THEN
6351: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6352: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_hndl_dlg_chrg_fail');
6353: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6354:
6355:
6354:
6355:
6356:
6357: WHEN others THEN
6358: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6359: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dleg_Level_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
6360: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
6361: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dleg_Level_Price_Recs');
6362:
6397:
6398: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
6399: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Create_Dlv_Dtl_Price_Recs','start');
6400:
6401: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6402:
6403:
6404: l_billable_basis:=NULL;
6405: l_billable_quantity:=NULL;
6509: p_cost_allocation_parameters=> p_cost_allocation_parameters,
6510: x_output_cost_tab=> x_output_cost_tab,
6511: x_return_status=> l_return_status);
6512:
6513: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6514: THEN
6515: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6516: THEN
6517: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_unit_dtl_chrg_fail;
6511: x_return_status=> l_return_status);
6512:
6513: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6514: THEN
6515: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6516: THEN
6517: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_unit_dtl_chrg_fail;
6518: END IF;
6519: END IF;
6536: p_cost_allocation_parameters=> p_cost_allocation_parameters,
6537: x_output_cost_tab=> x_output_cost_tab,
6538: x_return_status=> l_return_status);
6539:
6540: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6541: THEN
6542: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6543: THEN
6544: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_cm_dist_dtl_chrg_fail;
6538: x_return_status=> l_return_status);
6539:
6540: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6541: THEN
6542: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6543: THEN
6544: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_cm_dist_dtl_chrg_fail;
6545: END IF;
6546: END IF;
6559: x_output_cost_tab=> x_output_cost_tab,
6560: x_return_status=> l_return_status);
6561:
6562:
6563: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6564: THEN
6565: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6566: THEN
6567: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ld_dtl_chrg_fail;
6561:
6562:
6563: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6564: THEN
6565: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6566: THEN
6567: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ld_dtl_chrg_fail;
6568: END IF;
6569: END IF;
6584: p_cost_allocation_parameters=> p_cost_allocation_parameters,
6585: x_output_cost_tab=> x_output_cost_tab,
6586: x_return_status=> l_return_status);
6587:
6588: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6589: THEN
6590: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6591: THEN
6592: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ud_dtl_chrg_fail;
6586: x_return_status=> l_return_status);
6587:
6588: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6589: THEN
6590: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6591: THEN
6592: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ud_dtl_chrg_fail;
6593: END IF;
6594: END IF;
6609: p_cost_allocation_parameters=> p_cost_allocation_parameters,
6610: x_output_cost_tab=> x_output_cost_tab,
6611: x_return_status=> l_return_status);
6612:
6613: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6614: THEN
6615: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6616: THEN
6617: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_time_dtl_chrg_fail;
6611: x_return_status=> l_return_status);
6612:
6613: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6614: THEN
6615: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6616: THEN
6617: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_time_dtl_chrg_fail;
6618: END IF;
6619: END IF;
6632: p_cost_allocation_parameters=> p_cost_allocation_parameters,
6633: x_output_cost_tab=> x_output_cost_tab,
6634: x_return_status=> l_return_status);
6635:
6636: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6637: THEN
6638: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6639: THEN
6640: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_flat_dtl_chrg_fail;
6634: x_return_status=> l_return_status);
6635:
6636: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6637: THEN
6638: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6639: THEN
6640: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_flat_dtl_chrg_fail;
6641: END IF;
6642: END IF;
6656: x_output_cost_tab=> x_output_cost_tab,
6657: x_return_status=> l_return_status);
6658:
6659:
6660: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6661: THEN
6662: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6663: THEN
6664: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_stpoff_dtl_chrg_fail;
6658:
6659:
6660: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6661: THEN
6662: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6663: THEN
6664: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_stpoff_dtl_chrg_fail;
6665: END IF;
6666: END IF;
6679: p_cost_allocation_parameters=> p_cost_allocation_parameters,
6680: x_output_cost_tab=> x_output_cost_tab,
6681: x_return_status=> l_return_status);
6682:
6683: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6684: THEN
6685: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6686: THEN
6687: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_outrt_dtl_chrg_fail;
6681: x_return_status=> l_return_status);
6682:
6683: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6684: THEN
6685: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6686: THEN
6687: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_outrt_dtl_chrg_fail;
6688: END IF;
6689: END IF;
6703: x_output_cost_tab=> x_output_cost_tab,
6704: x_return_status=> l_return_status);
6705:
6706:
6707: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6708: THEN
6709: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6710: THEN
6711: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_hndl_dtl_chrg_fail;
6705:
6706:
6707: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6708: THEN
6709: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6710: THEN
6711: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_hndl_dtl_chrg_fail;
6712: END IF;
6713: END IF;
6727: x_output_cost_tab=> x_output_cost_tab,
6728: x_return_status=> l_return_status);
6729:
6730:
6731: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6732: THEN
6733: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6734: THEN
6735: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_fuel_dtl_chrg_fail;
6729:
6730:
6731: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6732: THEN
6733: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6734: THEN
6735: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_fuel_dtl_chrg_fail;
6736: END IF;
6737: END IF;
6750: p_cost_allocation_parameters=> p_cost_allocation_parameters,
6751: x_output_cost_tab=> x_output_cost_tab,
6752: x_return_status=> l_return_status);
6753:
6754: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6755: THEN
6756: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6757: THEN
6758: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkday_dtl_chrg_fail;
6752: x_return_status=> l_return_status);
6753:
6754: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6755: THEN
6756: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6757: THEN
6758: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkday_dtl_chrg_fail;
6759: END IF;
6760: END IF;
6775: x_output_cost_tab=> x_output_cost_tab,
6776: x_return_status=> l_return_status);
6777:
6778:
6779: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6780: THEN
6781: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6782: THEN
6783: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkend_dtl_chrg_fail;
6777:
6778:
6779: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6780: THEN
6781: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6782: THEN
6783: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkend_dtl_chrg_fail;
6784: END IF;
6785: END IF;
6802: p_cost_allocation_parameters=> p_cost_allocation_parameters,
6803: x_output_cost_tab=> x_output_cost_tab,
6804: x_return_status=> l_return_status);
6805:
6806: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6807: THEN
6808: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6809: THEN
6810: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ld_dtl_chrg_fail;
6804: x_return_status=> l_return_status);
6805:
6806: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6807: THEN
6808: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6809: THEN
6810: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ld_dtl_chrg_fail;
6811: END IF;
6812: END IF;
6828: p_cost_allocation_parameters=> p_cost_allocation_parameters,
6829: x_output_cost_tab=> x_output_cost_tab,
6830: x_return_status=> l_return_status);
6831:
6832: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6833: THEN
6834: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6835: THEN
6836: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ld_dtl_chrg_fail;
6830: x_return_status=> l_return_status);
6831:
6832: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6833: THEN
6834: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6835: THEN
6836: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ld_dtl_chrg_fail;
6837: END IF;
6838: END IF;
6852: x_output_cost_tab=> x_output_cost_tab,
6853: x_return_status=> l_return_status);
6854:
6855:
6856: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6857: THEN
6858: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6859: THEN
6860: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ud_dtl_chrg_fail;
6854:
6855:
6856: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6857: THEN
6858: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6859: THEN
6860: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ud_dtl_chrg_fail;
6861: END IF;
6862: END IF;
6876: x_output_cost_tab=> x_output_cost_tab,
6877: x_return_status=> l_return_status);
6878:
6879:
6880: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6881: THEN
6882: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6883: THEN
6884: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ud_dtl_chrg_fail;
6878:
6879:
6880: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6881: THEN
6882: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6883: THEN
6884: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ud_dtl_chrg_fail;
6885: END IF;
6886: END IF;
6901: x_output_cost_tab=> x_output_cost_tab,
6902: x_return_status=> l_return_status);
6903:
6904:
6905: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6906: THEN
6907: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6908: THEN
6909: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_org_dtl_chrg_fail;
6903:
6904:
6905: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6906: THEN
6907: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6908: THEN
6909: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_org_dtl_chrg_fail;
6910: END IF;
6911: END IF;
6925: x_output_cost_tab=> x_output_cost_tab,
6926: x_return_status=> l_return_status);
6927:
6928:
6929: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6930: THEN
6931: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6932: THEN
6933: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dst_dtl_chrg_fail;
6927:
6928:
6929: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6930: THEN
6931: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6932: THEN
6933: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dst_dtl_chrg_fail;
6934: END IF;
6935: END IF;
6969: p_cost_allocation_parameters=> p_cost_allocation_parameters,
6970: x_output_cost_tab=> x_output_cost_tab,
6971: x_return_status=> l_return_status);
6972:
6973: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6974: THEN
6975: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6976: THEN
6977: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ld_dtl_chrg_fail;
6971: x_return_status=> l_return_status);
6972:
6973: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
6974: THEN
6975: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
6976: THEN
6977: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ld_dtl_chrg_fail;
6978: END IF;
6979: END IF;
7009: p_cost_allocation_parameters=> p_cost_allocation_parameters,
7010: x_output_cost_tab=> x_output_cost_tab,
7011: x_return_status=> l_return_status);
7012:
7013: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7014: THEN
7015: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7016: THEN
7017: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ld_dtl_chrg_fail;
7011: x_return_status=> l_return_status);
7012:
7013: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7014: THEN
7015: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7016: THEN
7017: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ld_dtl_chrg_fail;
7018: END IF;
7019: END IF;
7050: p_cost_allocation_parameters=> p_cost_allocation_parameters,
7051: x_output_cost_tab=> x_output_cost_tab,
7052: x_return_status=> l_return_status);
7053:
7054: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7055: THEN
7056: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7057: THEN
7058: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ud_dtl_chrg_fail;
7052: x_return_status=> l_return_status);
7053:
7054: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7055: THEN
7056: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7057: THEN
7058: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ud_dtl_chrg_fail;
7059: END IF;
7060: END IF;
7090: p_cost_allocation_parameters=> p_cost_allocation_parameters,
7091: x_output_cost_tab=> x_output_cost_tab,
7092: x_return_status=> l_return_status);
7093:
7094: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7095: THEN
7096: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7097: THEN
7098: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ud_dtl_chrg_fail;
7092: x_return_status=> l_return_status);
7093:
7094: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7095: THEN
7096: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7097: THEN
7098: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ud_dtl_chrg_fail;
7099: END IF;
7100: END IF;
7134: p_cost_allocation_parameters=> p_cost_allocation_parameters,
7135: x_output_cost_tab=> x_output_cost_tab,
7136: x_return_status=> l_return_status);
7137:
7138: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7139: THEN
7140: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7141: THEN
7142: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_hndl_dtl_chrg_fail;
7136: x_return_status=> l_return_status);
7137:
7138: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7139: THEN
7140: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7141: THEN
7142: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_hndl_dtl_chrg_fail;
7143: END IF;
7144: END IF;
7158: p_cost_allocation_parameters=> p_cost_allocation_parameters,
7159: x_output_cost_tab=> x_output_cost_tab,
7160: x_return_status=> l_return_status);
7161:
7162: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7163: THEN
7164: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7165: THEN
7166: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_sum_dtl_chrg_fail;
7160: x_return_status=> l_return_status);
7161:
7162: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7163: THEN
7164: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7165: THEN
7166: raise FTE_FREIGHT_PRICING_UTIL.g_tl_ins_sum_dtl_chrg_fail;
7167: END IF;
7168: END IF;
7172: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7173:
7174: IF (l_warning_count > 0)
7175: THEN
7176: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
7177: END IF;
7178: EXCEPTION
7179:
7180: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_sum_dtl_chrg_fail THEN
7177: END IF;
7178: EXCEPTION
7179:
7180: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_sum_dtl_chrg_fail THEN
7181: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7182: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_sum_dtl_chrg_fail');
7183: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7184:
7185: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_fuel_dtl_chrg_fail THEN
7182: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_sum_dtl_chrg_fail');
7183: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7184:
7185: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_fuel_dtl_chrg_fail THEN
7186: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7187: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_cm_dist_dtl_chrg_fail');
7188: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7189:
7190:
7188: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7189:
7190:
7191: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_cm_dist_dtl_chrg_fail THEN
7192: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7193: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_cm_dist_dtl_chrg_fail');
7194: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7195:
7196: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ld_dtl_chrg_fail THEN
7193: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_cm_dist_dtl_chrg_fail');
7194: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7195:
7196: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ld_dtl_chrg_fail THEN
7197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7198: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dist_ld_dtl_chrg_fail');
7199: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7200:
7201: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ud_dtl_chrg_fail THEN
7198: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dist_ld_dtl_chrg_fail');
7199: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7200:
7201: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dist_ud_dtl_chrg_fail THEN
7202: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7203: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dist_ud_dtl_chrg_fail');
7204: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7205:
7206: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_no_carr_unit_basis THEN
7203: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dist_ud_dtl_chrg_fail');
7204: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7205:
7206: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_no_carr_unit_basis THEN
7207: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7208: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_no_carr_unit_basis');
7209: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7210:
7211: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_unit_dtl_chrg_fail THEN
7208: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_no_carr_unit_basis');
7209: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7210:
7211: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_unit_dtl_chrg_fail THEN
7212: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7213: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_unit_dtl_chrg_fail');
7214: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7215:
7216: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_time_dtl_chrg_fail THEN
7213: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_unit_dtl_chrg_fail');
7214: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7215:
7216: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_time_dtl_chrg_fail THEN
7217: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7218: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_time_dtl_chrg_fail');
7219: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7220:
7221: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_flat_dtl_chrg_fail THEN
7218: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_time_dtl_chrg_fail');
7219: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7220:
7221: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_flat_dtl_chrg_fail THEN
7222: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7223: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_flat_dtl_chrg_fail');
7224: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7225:
7226: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_stpoff_dtl_chrg_fail THEN
7223: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_flat_dtl_chrg_fail');
7224: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7225:
7226: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_stpoff_dtl_chrg_fail THEN
7227: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7228: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_stpoff_dtl_chrg_fail');
7229: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7230:
7231: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_outrt_dtl_chrg_fail THEN
7228: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_stpoff_dtl_chrg_fail');
7229: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7230:
7231: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_outrt_dtl_chrg_fail THEN
7232: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7233: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_outrt_dtl_chrg_fail');
7234: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7235:
7236: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_hndl_dtl_chrg_fail THEN
7233: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_outrt_dtl_chrg_fail');
7234: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7235:
7236: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_hndl_dtl_chrg_fail THEN
7237: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7238: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_hndl_dtl_chrg_fail');
7239: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7240:
7241: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkday_dtl_chrg_fail THEN
7238: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_hndl_dtl_chrg_fail');
7239: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7240:
7241: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkday_dtl_chrg_fail THEN
7242: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7243: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_wkday_dtl_chrg_fail');
7244: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7245:
7246: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkend_dtl_chrg_fail THEN
7243: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_wkday_dtl_chrg_fail');
7244: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7245:
7246: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_wkend_dtl_chrg_fail THEN
7247: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7248: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_wkend_dtl_chrg_fail');
7249: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7250:
7251: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ld_dtl_chrg_fail THEN
7248: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_wkend_dtl_chrg_fail');
7249: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7250:
7251: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ld_dtl_chrg_fail THEN
7252: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7253: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ld_dtl_chrg_fail');
7254: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7255:
7256: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ld_dtl_chrg_fail THEN
7253: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ld_dtl_chrg_fail');
7254: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7255:
7256: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ld_dtl_chrg_fail THEN
7257: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7258: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_as_ld_dtl_chrg_fail');
7259: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7260:
7261: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ud_dtl_chrg_fail THEN
7258: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_as_ld_dtl_chrg_fail');
7259: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7260:
7261: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_ud_dtl_chrg_fail THEN
7262: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7263: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ud_dtl_chrg_fail');
7264: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7265:
7266: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ud_dtl_chrg_fail THEN
7263: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_ud_dtl_chrg_fail');
7264: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7265:
7266: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_as_ud_dtl_chrg_fail THEN
7267: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7268: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_as_ud_dtl_chrg_fail');
7269: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7270:
7271: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_org_dtl_chrg_fail THEN
7268: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_as_ud_dtl_chrg_fail');
7269: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7270:
7271: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_org_dtl_chrg_fail THEN
7272: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7273: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_org_dtl_chrg_fail');
7274: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7275:
7276: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dst_dtl_chrg_fail THEN
7273: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_org_dtl_chrg_fail');
7274: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7275:
7276: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_dst_dtl_chrg_fail THEN
7277: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7278: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dst_dtl_chrg_fail');
7279: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7280:
7281: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ld_dtl_chrg_fail THEN
7278: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_dst_dtl_chrg_fail');
7279: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7280:
7281: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ld_dtl_chrg_fail THEN
7282: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7283: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_ld_dtl_chrg_fail');
7284: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7285:
7286: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_conv_currency_fail THEN
7283: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_ld_dtl_chrg_fail');
7284: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7285:
7286: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_conv_currency_fail THEN
7287: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7288: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
7289: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7290:
7291: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ld_dtl_chrg_fail THEN
7288: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
7289: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7290:
7291: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ld_dtl_chrg_fail THEN
7292: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7293: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_as_ld_dtl_chrg_fail');
7294: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7295:
7296: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ud_dtl_chrg_fail THEN
7293: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_as_ld_dtl_chrg_fail');
7294: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7295:
7296: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_ud_dtl_chrg_fail THEN
7297: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7298: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_ud_dtl_chrg_fail');
7299: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7300:
7301: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ud_dtl_chrg_fail THEN
7298: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_ud_dtl_chrg_fail');
7299: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7300:
7301: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_as_ud_dtl_chrg_fail THEN
7302: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7303: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_as_ud_dtl_chrg_fail');
7304: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7305:
7306: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_hndl_dtl_chrg_fail THEN
7303: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_as_ud_dtl_chrg_fail');
7304: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7305:
7306: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_ins_f_hndl_dtl_chrg_fail THEN
7307: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7308: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_hndl_dtl_chrg_fail');
7309: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7310:
7311: WHEN others THEN
7308: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_ins_f_hndl_dtl_chrg_fail');
7309: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7310:
7311: WHEN others THEN
7312: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7313: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Dlv_Dtl_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
7314: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
7315: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Dlv_Dtl_Price_Recs');
7316:
7339: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
7340: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Alloc_Charges_To_Int_Details','start');
7341:
7342:
7343: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7344:
7345:
7346: i:=p_detail_alloc_tab.FIRST;
7347: WHILE( i IS NOT NULL)
7359: p_only_summary_flag=>'Y',
7360: x_output_cost_tab=>x_output_cost_tab,
7361: x_return_status=>l_return_status);
7362:
7363: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7364: THEN
7365: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7366: THEN
7367: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_dlv_dtl_fail;
7361: x_return_status=>l_return_status);
7362:
7363: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7364: THEN
7365: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7366: THEN
7367: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_dlv_dtl_fail;
7368: END IF;
7369: END IF;
7376:
7377: EXCEPTION
7378:
7379: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_dlv_dtl_fail THEN
7380: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7381: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Charges_To_Int_Details',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_dlv_dtl_fail');
7382: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Charges_To_Int_Details');
7383:
7384:
7382: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Charges_To_Int_Details');
7383:
7384:
7385: WHEN others THEN
7386: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7387: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_Charges_To_Int_Details',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
7388: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
7389: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_Charges_To_Int_Details');
7390:
7436: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
7437: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Alloc_To_Details','start');
7438:
7439:
7440: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7441:
7442: l_dleg_index_first:=
7443: FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).delivery_leg_reference;
7444: l_carrier_weight_uom:=
7555: p_volume=>l_volume,
7556: x_dim_weight=>l_dim_weight,
7557: x_return_status=>l_return_status);
7558:
7559: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7560: THEN
7561: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7562: THEN
7563: raise FTE_FREIGHT_PRICING_UTIL.g_tl_calc_dim_weight_fail;
7557: x_return_status=>l_return_status);
7558:
7559: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7560: THEN
7561: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7562: THEN
7563: raise FTE_FREIGHT_PRICING_UTIL.g_tl_calc_dim_weight_fail;
7564: END IF;
7565: END IF;
7626: p_only_summary_flag=>l_dtl_summary_only_flag,
7627: x_output_cost_tab=> x_output_cost_tab,
7628: x_return_status=> l_return_status);
7629:
7630: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7631: THEN
7632: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7633: THEN
7634: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_dlv_dtl_fail;
7628: x_return_status=> l_return_status);
7629:
7630: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7631: THEN
7632: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7633: THEN
7634: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_dlv_dtl_fail;
7635: END IF;
7636: END IF;
7786: p_volume=>l_volume,
7787: x_dim_weight=>l_dim_weight,
7788: x_return_status=>l_return_status);
7789:
7790: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7791: THEN
7792: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7793: THEN
7794: raise FTE_FREIGHT_PRICING_UTIL.g_tl_calc_dim_weight_fail;
7788: x_return_status=>l_return_status);
7789:
7790: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7791: THEN
7792: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7793: THEN
7794: raise FTE_FREIGHT_PRICING_UTIL.g_tl_calc_dim_weight_fail;
7795: END IF;
7796: END IF;
7857: p_only_summary_flag=>l_dtl_summary_only_flag,
7858: x_output_cost_tab=> x_output_cost_tab,
7859: x_return_status=> l_return_status);
7860:
7861: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7862: THEN
7863: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7864: THEN
7865: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_dlv_dtl_fail;
7859: x_return_status=> l_return_status);
7860:
7861: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7862: THEN
7863: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7864: THEN
7865: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_dlv_dtl_fail;
7866: END IF;
7867: END IF;
7908: p_detail_alloc_tab=>l_detail_alloc_tab,
7909: x_output_cost_tab=>x_output_cost_tab,
7910: x_return_status=>l_return_status);
7911:
7912: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7913: THEN
7914: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7915: THEN
7916: raise FTE_FREIGHT_PRICING_UTIL.g_tl_mdc_alloc_int_dtl_fail;
7910: x_return_status=>l_return_status);
7911:
7912: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7913: THEN
7914: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
7915: THEN
7916: raise FTE_FREIGHT_PRICING_UTIL.g_tl_mdc_alloc_int_dtl_fail;
7917: END IF;
7918: END IF;
7920:
7921: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_To_Details');
7922: IF (l_warning_count > 0)
7923: THEN
7924: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
7925: END IF;
7926: EXCEPTION
7927:
7928: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_mdc_alloc_int_dtl_fail THEN
7925: END IF;
7926: EXCEPTION
7927:
7928: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_mdc_alloc_int_dtl_fail THEN
7929: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7930: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_To_Details',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_mdc_alloc_int_dtl_fail');
7931: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_To_Details');
7932:
7933:
7931: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_To_Details');
7932:
7933:
7934: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_no_dtl_on_dleg THEN
7935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7936: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_To_Details',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_no_dtl_on_dleg');
7937: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_To_Details');
7938:
7939:
7937: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_To_Details');
7938:
7939:
7940: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_conv_currency_fail THEN
7941: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7942: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_To_Details',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
7943: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_To_Details');
7944:
7945: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_dlv_dtl_fail THEN
7942: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_To_Details',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_conv_currency_fail');
7943: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_To_Details');
7944:
7945: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_dlv_dtl_fail THEN
7946: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
7947: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_To_Details',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_dlv_dtl_fail');
7948: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_To_Details');
7949:
7950:
7948: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_To_Details');
7949:
7950:
7951: WHEN others THEN
7952: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7953: FTE_FREIGHT_PRICING_UTIL.set_exception('Alloc_To_Details',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
7954: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
7955: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Alloc_To_Details');
7956:
7983: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
7984: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Create_Summary_Price_Recs','start');
7985:
7986:
7987: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
7988:
7989:
7990: Create_Trip_Level_Price_Recs(
7991: p_trip_index=> p_trip_index,
7994: p_cost_allocation_parameters=> p_cost_allocation_parameters,
7995: x_output_cost_tab=> x_output_cost_tab,
7996: x_return_status=> l_return_status);
7997:
7998: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7999: THEN
8000: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8001: THEN
8002: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_trp_price_recs_fail;
7996: x_return_status=> l_return_status);
7997:
7998: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
7999: THEN
8000: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8001: THEN
8002: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_trp_price_recs_fail;
8003: END IF;
8004: END IF;
8020: p_cost_allocation_parameters=> p_cost_allocation_parameters,
8021: x_output_cost_tab=> x_output_cost_tab,
8022: x_return_status=> l_return_status);
8023:
8024: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8025: THEN
8026: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8027: THEN
8028: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_stp_price_recs_fail;
8022: x_return_status=> l_return_status);
8023:
8024: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8025: THEN
8026: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8027: THEN
8028: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_stp_price_recs_fail;
8029: END IF;
8030: END IF;
8045: p_cost_allocation_parameters=>p_cost_allocation_parameters,
8046: x_output_cost_tab=> x_output_cost_tab,
8047: x_return_status=> l_return_status);
8048:
8049: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8050: THEN
8051: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8052: THEN
8053: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_dlg_price_recs_fail;
8047: x_return_status=> l_return_status);
8048:
8049: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8050: THEN
8051: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8052: THEN
8053: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_dlg_price_recs_fail;
8054: END IF;
8055: END IF;
8061:
8062: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Summary_Price_Recs');
8063: IF (l_warning_count > 0)
8064: THEN
8065: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
8066: END IF;
8067: EXCEPTION
8068:
8069: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_trp_price_recs_fail THEN
8066: END IF;
8067: EXCEPTION
8068:
8069: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_trp_price_recs_fail THEN
8070: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8071: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Summary_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_trp_price_recs_fail');
8072: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Summary_Price_Recs');
8073:
8074: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_stp_price_recs_fail THEN
8071: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Summary_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_trp_price_recs_fail');
8072: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Summary_Price_Recs');
8073:
8074: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_stp_price_recs_fail THEN
8075: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8076: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Summary_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_stp_price_recs_fail');
8077: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Summary_Price_Recs');
8078:
8079: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_dlg_price_recs_fail THEN
8076: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Summary_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_stp_price_recs_fail');
8077: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Summary_Price_Recs');
8078:
8079: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_dlg_price_recs_fail THEN
8080: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8081: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Summary_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_dlg_price_recs_fail');
8082: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Summary_Price_Recs');
8083:
8084:
8082: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Summary_Price_Recs');
8083:
8084:
8085: WHEN others THEN
8086: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
8087: FTE_FREIGHT_PRICING_UTIL.set_exception('Create_Summary_Price_Recs',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
8088: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
8089: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Create_Summary_Price_Recs');
8090:
8129: FTE_FREIGHT_PRICING_UTIL.reset_dbg_vars;
8130: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'TL_COST_ALLOCATION','start');
8131:
8132:
8133: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
8134:
8135: Initialize_Freight_Codes(
8136: x_return_status=> l_return_status);
8137:
8135: Initialize_Freight_Codes(
8136: x_return_status=> l_return_status);
8137:
8138:
8139: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8140: THEN
8141: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8142: THEN
8143: raise FTE_FREIGHT_PRICING_UTIL.g_tl_init_fr_codes_fail;
8137:
8138:
8139: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8140: THEN
8141: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8142: THEN
8143: raise FTE_FREIGHT_PRICING_UTIL.g_tl_init_fr_codes_fail;
8144: END IF;
8145: END IF;
8148: --Clear bulk arrays
8149: IF (p_cost_allocation_parameters.output_type='T')
8150: THEN
8151: Clear_Bulk_Arrays(x_return_status=>x_return_status);
8152: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8153: THEN
8154: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8155: THEN
8156: raise FTE_FREIGHT_PRICING_UTIL.g_tl_clr_bulk_arr_fail;
8150: THEN
8151: Clear_Bulk_Arrays(x_return_status=>x_return_status);
8152: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8153: THEN
8154: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8155: THEN
8156: raise FTE_FREIGHT_PRICING_UTIL.g_tl_clr_bulk_arr_fail;
8157: END IF;
8158: END IF;
8167: x_stop_input_hash=> l_stop_input_hash,
8168: x_stop_output_hash=> l_stop_output_hash,
8169: x_return_status=> l_return_status);
8170:
8171: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8172: THEN
8173: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8174: THEN
8175: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_stp_hash_fail;
8169: x_return_status=> l_return_status);
8170:
8171: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8172: THEN
8173: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8174: THEN
8175: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_stp_hash_fail;
8176: END IF;
8177: END IF;
8189: p_cost_allocation_parameters=> p_cost_allocation_parameters,
8190: x_dleg_alloc_tab=> l_dleg_alloc_tab,
8191: x_return_status=> l_return_status);
8192:
8193: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8194: THEN
8195: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8196: THEN
8197: raise FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_ld_stpoff_dleg_fail;
8191: x_return_status=> l_return_status);
8192:
8193: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8194: THEN
8195: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8196: THEN
8197: raise FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_ld_stpoff_dleg_fail;
8198: END IF;
8199: END IF;
8209: p_cost_allocation_parameters=> p_cost_allocation_parameters,
8210: x_dleg_alloc_tab=> l_dleg_alloc_tab,
8211: x_return_status=> l_return_status);
8212:
8213: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8214: THEN
8215: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8216: THEN
8217: raise FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_chrges_dleg_fail;
8211: x_return_status=> l_return_status);
8212:
8213: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8214: THEN
8215: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8216: THEN
8217: raise FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_chrges_dleg_fail;
8218: END IF;
8219: END IF;
8225: p_cost_allocation_parameters=> p_cost_allocation_parameters,
8226: x_output_cost_tab=> x_output_cost_tab,
8227: x_return_status=> l_return_status);
8228:
8229: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8230: THEN
8231: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8232: THEN
8233: raise FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_to_dtls_fail;
8227: x_return_status=> l_return_status);
8228:
8229: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8230: THEN
8231: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8232: THEN
8233: raise FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_to_dtls_fail;
8234: END IF;
8235: END IF;
8243: p_cost_allocation_parameters=> p_cost_allocation_parameters,
8244: x_output_cost_tab=> x_output_cost_tab,
8245: x_return_status=> l_return_status);
8246:
8247: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8248: THEN
8249: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8250: THEN
8251: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_summry_price_recs_fail;
8245: x_return_status=> l_return_status);
8246:
8247: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8248: THEN
8249: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8250: THEN
8251: raise FTE_FREIGHT_PRICING_UTIL.g_tl_cr_summry_price_recs_fail;
8252: END IF;
8253: END IF;
8257: --Clear bulk arrays
8258: IF (p_cost_allocation_parameters.output_type='T')
8259: THEN
8260: Bulk_Insert_Temp(x_return_status=>x_return_status);
8261: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8262: THEN
8263: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8264: THEN
8265: raise FTE_FREIGHT_PRICING_UTIL.g_tl_bulk_ins_tmp_fail;
8259: THEN
8260: Bulk_Insert_Temp(x_return_status=>x_return_status);
8261: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8262: THEN
8263: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8264: THEN
8265: raise FTE_FREIGHT_PRICING_UTIL.g_tl_bulk_ins_tmp_fail;
8266: END IF;
8267: END IF;
8267: END IF;
8268:
8269:
8270: Clear_Bulk_Arrays(x_return_status=>x_return_status);
8271: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8272: THEN
8273: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8274: THEN
8275: raise FTE_FREIGHT_PRICING_UTIL.g_tl_clr_bulk_arr_fail;
8269:
8270: Clear_Bulk_Arrays(x_return_status=>x_return_status);
8271: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
8272: THEN
8273: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
8274: THEN
8275: raise FTE_FREIGHT_PRICING_UTIL.g_tl_clr_bulk_arr_fail;
8276: END IF;
8277: END IF;
8342: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8343:
8344: IF (l_warning_count > 0)
8345: THEN
8346: x_return_status:=WSH_UTIL_CORE.G_RET_STS_WARNING;
8347: END IF;
8348: EXCEPTION
8349:
8350: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_bulk_ins_tmp_fail THEN
8347: END IF;
8348: EXCEPTION
8349:
8350: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_bulk_ins_tmp_fail THEN
8351: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8352: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_COST_ALLOCATION',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_bulk_ins_tmp_fail');
8353: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8354:
8355:
8353: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8354:
8355:
8356: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_clr_bulk_arr_fail THEN
8357: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8358: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_COST_ALLOCATION',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_clr_bulk_arr_fail');
8359: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8360:
8361:
8359: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8360:
8361:
8362: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_stp_hash_fail THEN
8363: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8364: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_COST_ALLOCATION',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_stp_hash_fail');
8365: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8366:
8367: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_ld_stpoff_dleg_fail THEN
8364: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_COST_ALLOCATION',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_stp_hash_fail');
8365: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8366:
8367: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_ld_stpoff_dleg_fail THEN
8368: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8369: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_COST_ALLOCATION',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_alloc_ld_stpoff_dleg_fail');
8370: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8371:
8372: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_chrges_dleg_fail THEN
8369: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_COST_ALLOCATION',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_alloc_ld_stpoff_dleg_fail');
8370: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8371:
8372: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_chrges_dleg_fail THEN
8373: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8374: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_COST_ALLOCATION',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_alloc_chrges_dleg_fail');
8375: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8376:
8377: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_to_dtls_fail THEN
8374: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_COST_ALLOCATION',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_alloc_chrges_dleg_fail');
8375: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8376:
8377: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_alloc_to_dtls_fail THEN
8378: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8379: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_COST_ALLOCATION',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_alloc_to_dtls_fail');
8380: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8381:
8382: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_summry_price_recs_fail THEN
8379: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_COST_ALLOCATION',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_alloc_to_dtls_fail');
8380: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8381:
8382: WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_cr_summry_price_recs_fail THEN
8383: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
8384: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_COST_ALLOCATION',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_cr_summry_price_recs_fail');
8385: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8386:
8387:
8385: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8386:
8387:
8388: WHEN others THEN
8389: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
8390: FTE_FREIGHT_PRICING_UTIL.set_exception('TL_COST_ALLOCATION',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
8391: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Unexpected Error : '||SQLCODE||' : '||SQLERRM);
8392: FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'TL_COST_ALLOCATION');
8393: