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

APPS.FTE_TL_RATING dependencies on FTE_TL_CACHE

Line 42: FTE_TL_CACHE.FPA_Get_Trip_Info(

38:
39: l_distances(1):=NULL;
40: l_distance_uom:=NULL;
41:
42: FTE_TL_CACHE.FPA_Get_Trip_Info(
43: p_trip_id=>p_trip_id,
44: x_distance=>l_distances(1),
45: x_distance_uom=>l_distance_uom,
46: x_weight=>l_weight,

Line 209: FTE_TL_CACHE.Get_Vehicle_Type(p_trip_id => p_trip_id,

205:
206: IF (p_trip_id IS NOT NULL)
207: THEN
208:
209: FTE_TL_CACHE.Get_Vehicle_Type(p_trip_id => p_trip_id,
210: p_vehicle_item_id =>NULL,
211: x_vehicle_type => l_trip_vehicle_type,
212: x_return_status => l_return_status);
213:

Line 812: FTE_TL_CACHE.Get_Vehicle_Type(p_trip_id => p_trip_id,

808: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,
809: 'p_comparison_request_id = '||p_comparison_request_id);
810:
811: l_trip_vehicle_type:=NULL;
812: FTE_TL_CACHE.Get_Vehicle_Type(p_trip_id => p_trip_id,
813: p_vehicle_item_id =>NULL,
814: x_vehicle_type => l_trip_vehicle_type,
815: x_return_status => l_return_status);
816: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

Line 1126: FTE_TL_CACHE.Get_Vehicle_Type(p_trip_id => l_trip_id,

1122: CLOSE c_get_dleg_info_from_dleg;
1123:
1124:
1125: l_trip_vehicle_type:=NULL;
1126: FTE_TL_CACHE.Get_Vehicle_Type(p_trip_id => l_trip_id,
1127: p_vehicle_item_id =>NULL,
1128: x_vehicle_type => l_trip_vehicle_type,
1129: x_return_status => l_return_status);
1130: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

Line 1151: OPEN c_check_fake(p_lane_id,p_schedule_id,l_trip_vehicle_type,p_comparison_request_id,FTE_TL_CACHE.FAKE_TRIP_ID);

1147: END IF;
1148:
1149: --Check for fake trip
1150:
1151: OPEN c_check_fake(p_lane_id,p_schedule_id,l_trip_vehicle_type,p_comparison_request_id,FTE_TL_CACHE.FAKE_TRIP_ID);
1152: FETCH c_check_fake INTO l_fake_trip;
1153: IF(c_check_fake%FOUND)
1154: THEN
1155: l_fake_trip:=FTE_TL_CACHE.FAKE_TRIP_ID;

Line 1155: l_fake_trip:=FTE_TL_CACHE.FAKE_TRIP_ID;

1151: OPEN c_check_fake(p_lane_id,p_schedule_id,l_trip_vehicle_type,p_comparison_request_id,FTE_TL_CACHE.FAKE_TRIP_ID);
1152: FETCH c_check_fake INTO l_fake_trip;
1153: IF(c_check_fake%FOUND)
1154: THEN
1155: l_fake_trip:=FTE_TL_CACHE.FAKE_TRIP_ID;
1156:
1157: ELSE
1158: l_fake_trip:=NULL;
1159:

Line 1203: IF ((l_temp_rec.stop_id IS NOT NULL) AND (l_temp_rec.stop_id = FTE_TL_CACHE.FAKE_STOP_ID_1))

1199: END IF;
1200:
1201:
1202: --Plug in real stop id
1203: IF ((l_temp_rec.stop_id IS NOT NULL) AND (l_temp_rec.stop_id = FTE_TL_CACHE.FAKE_STOP_ID_1))
1204: THEN
1205:
1206: l_freight_rec.stop_id:=l_pickup_stop_id;
1207:

Line 1208: ELSIF((l_temp_rec.stop_id IS NOT NULL) AND (l_temp_rec.stop_id = FTE_TL_CACHE.FAKE_STOP_ID_2))

1204: THEN
1205:
1206: l_freight_rec.stop_id:=l_pickup_stop_id;
1207:
1208: ELSIF((l_temp_rec.stop_id IS NOT NULL) AND (l_temp_rec.stop_id = FTE_TL_CACHE.FAKE_STOP_ID_2))
1209: THEN
1210: l_freight_rec.stop_id:=l_dropoff_stop_id;
1211:
1212: ELSE

Line 1224: IF((l_temp_rec.delivery_leg_id IS NOT NULL) AND (l_temp_rec.delivery_leg_id = FTE_TL_CACHE.FAKE_DLEG_ID))

1220: l_freight_rec.delivery_id:=l_temp_rec.delivery_id;
1221:
1222:
1223: --Plug in real dleg id
1224: IF((l_temp_rec.delivery_leg_id IS NOT NULL) AND (l_temp_rec.delivery_leg_id = FTE_TL_CACHE.FAKE_DLEG_ID))
1225: THEN
1226: l_freight_rec.delivery_leg_id:=p_dleg_id;
1227: ELSE
1228: l_freight_rec.delivery_leg_id:=l_temp_rec.delivery_leg_id;

Line 1784: l_store_trip_rows FTE_TL_CACHE.TL_trip_output_tab_type;

1780: x_output_cost_tab OUT NOCOPY FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type ,
1781: x_return_status OUT NOCOPY VARCHAR2) IS
1782:
1783: --All the trip charges in the move will be stored in this table
1784: l_store_trip_rows FTE_TL_CACHE.TL_trip_output_tab_type;
1785:
1786: --All the stops of the diff trips in the move will be stored here
1787: l_store_trip_stop_rows FTE_TL_CACHE.TL_trip_stop_output_tab_type;
1788:

Line 1787: l_store_trip_stop_rows FTE_TL_CACHE.TL_trip_stop_output_tab_type;

1783: --All the trip charges in the move will be stored in this table
1784: l_store_trip_rows FTE_TL_CACHE.TL_trip_output_tab_type;
1785:
1786: --All the stops of the diff trips in the move will be stored here
1787: l_store_trip_stop_rows FTE_TL_CACHE.TL_trip_stop_output_tab_type;
1788:
1789: --All the total charges for the trips are stored in this table, indexed by trip id
1790: l_trip_charges_tab dbms_utility.number_array;
1791:

Line 1805: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;

1801: l_effective_discount NUMBER;
1802: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;
1803: l_output_cost_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
1804:
1805: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
1806: l_empty_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
1807: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
1808:
1809:

Line 1806: l_empty_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;

1802: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;
1803: l_output_cost_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
1804:
1805: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
1806: l_empty_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
1807: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
1808:
1809:
1810: l_return_status VARCHAR2(1);

Line 1807: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;

1803: l_output_cost_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
1804:
1805: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
1806: l_empty_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
1807: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
1808:
1809:
1810: l_return_status VARCHAR2(1);
1811:

Line 1847: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),

1843: WHILE(i <= p_trip_index_end)
1844: LOOP
1845:
1846: FTE_TL_CORE.tl_core (
1847: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),
1848: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
1849: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(i),
1850: x_trip_charges_rec => l_trip_charges_rec,
1851: x_stop_charges_tab => l_stop_charges_tab,

Line 1848: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,

1844: LOOP
1845:
1846: FTE_TL_CORE.tl_core (
1847: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),
1848: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
1849: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(i),
1850: x_trip_charges_rec => l_trip_charges_rec,
1851: x_stop_charges_tab => l_stop_charges_tab,
1852: x_return_status => l_return_status );

Line 1849: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(i),

1845:
1846: FTE_TL_CORE.tl_core (
1847: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),
1848: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
1849: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(i),
1850: x_trip_charges_rec => l_trip_charges_rec,
1851: x_stop_charges_tab => l_stop_charges_tab,
1852: x_return_status => l_return_status );
1853:

Line 1861: p_trip_id=>FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);

1857: THEN
1858: FTE_FREIGHT_PRICING_UTIL.setmsg (
1859: p_api=>'Handle_CM_Discount_Variant',
1860: p_exc=>'g_tl_core_fail',
1861: p_trip_id=>FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);
1862:
1863: raise FTE_FREIGHT_PRICING_UTIL.g_tl_core_fail;
1864: END IF;
1865: END IF;

Line 1916: IF(FTE_TL_CACHE.g_tl_trip_rows(i).dead_head='N')

1912:
1913: k:=l_stop_charges_tab.NEXT(k);
1914: END LOOP;
1915:
1916: IF(FTE_TL_CACHE.g_tl_trip_rows(i).dead_head='N')
1917: THEN
1918: l_non_cm_charge:=l_non_cm_charge+
1919: l_trip_charges_tab(FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);
1920: END IF;

Line 1919: l_trip_charges_tab(FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);

1915:
1916: IF(FTE_TL_CACHE.g_tl_trip_rows(i).dead_head='N')
1917: THEN
1918: l_non_cm_charge:=l_non_cm_charge+
1919: l_trip_charges_tab(FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);
1920: END IF;
1921: l_cm_charge:=l_cm_charge
1922: +l_trip_charges_tab(FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);
1923:

Line 1922: +l_trip_charges_tab(FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);

1918: l_non_cm_charge:=l_non_cm_charge+
1919: l_trip_charges_tab(FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);
1920: END IF;
1921: l_cm_charge:=l_cm_charge
1922: +l_trip_charges_tab(FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);
1923:
1924: i:=i+1;
1925: END LOOP;
1926:

Line 1954: IF((FTE_TL_CACHE.g_tl_trip_rows(i).dead_head='N') AND

1950:
1951: i:=l_store_trip_rows.FIRST;
1952: WHILE(i IS NOT NULL)
1953: LOOP
1954: IF((FTE_TL_CACHE.g_tl_trip_rows(i).dead_head='N') AND
1955: NOT((FTE_TL_CACHE.g_tl_carrier_pref_rows(i).cm_first_load_discount_flag='N')AND (i= l_store_trip_rows.FIRST)))
1956: THEN
1957: FTE_TL_COST_ALLOCATION.Scale_Trip_Charges(
1958: p_discount=> l_effective_discount,

Line 1955: NOT((FTE_TL_CACHE.g_tl_carrier_pref_rows(i).cm_first_load_discount_flag='N')AND (i= l_store_trip_rows.FIRST)))

1951: i:=l_store_trip_rows.FIRST;
1952: WHILE(i IS NOT NULL)
1953: LOOP
1954: IF((FTE_TL_CACHE.g_tl_trip_rows(i).dead_head='N') AND
1955: NOT((FTE_TL_CACHE.g_tl_carrier_pref_rows(i).cm_first_load_discount_flag='N')AND (i= l_store_trip_rows.FIRST)))
1956: THEN
1957: FTE_TL_COST_ALLOCATION.Scale_Trip_Charges(
1958: p_discount=> l_effective_discount,
1959: x_trip_charges_rec=> l_store_trip_rows(i),

Line 2141: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;

2137: l_total_trip_charge NUMBER;
2138: l_factor NUMBER;
2139:
2140: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;
2141: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2142: l_empty_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2143: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2144:
2145: --All the trip charges in the move will be stored in this table

Line 2142: l_empty_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;

2138: l_factor NUMBER;
2139:
2140: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;
2141: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2142: l_empty_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2143: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2144:
2145: --All the trip charges in the move will be stored in this table
2146: l_store_trip_rows FTE_TL_CACHE.TL_trip_output_tab_type;

Line 2143: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;

2139:
2140: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;
2141: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2142: l_empty_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2143: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2144:
2145: --All the trip charges in the move will be stored in this table
2146: l_store_trip_rows FTE_TL_CACHE.TL_trip_output_tab_type;
2147:

Line 2146: l_store_trip_rows FTE_TL_CACHE.TL_trip_output_tab_type;

2142: l_empty_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2143: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2144:
2145: --All the trip charges in the move will be stored in this table
2146: l_store_trip_rows FTE_TL_CACHE.TL_trip_output_tab_type;
2147:
2148: --All the stops of the diff trips in the move will be stored here
2149: l_store_trip_stop_rows FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2150:

Line 2149: l_store_trip_stop_rows FTE_TL_CACHE.TL_trip_stop_output_tab_type;

2145: --All the trip charges in the move will be stored in this table
2146: l_store_trip_rows FTE_TL_CACHE.TL_trip_output_tab_type;
2147:
2148: --All the stops of the diff trips in the move will be stored here
2149: l_store_trip_stop_rows FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2150:
2151: --All the total charges for the trips are stored in this table, indexed by trip id
2152: l_trip_charges_tab dbms_utility.number_array;
2153:

Line 2195: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'trip index:'||i||'stop ref'||FTE_TL_CACHE.g_tl_trip_rows(i).stop_reference);

2191: i:=p_trip_index_start;
2192: WHILE(i <= p_trip_index_end)
2193: LOOP
2194:
2195: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'trip index:'||i||'stop ref'||FTE_TL_CACHE.g_tl_trip_rows(i).stop_reference);
2196:
2197: FTE_TL_CORE.tl_core (
2198: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),
2199: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,

Line 2198: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),

2194:
2195: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'trip index:'||i||'stop ref'||FTE_TL_CACHE.g_tl_trip_rows(i).stop_reference);
2196:
2197: FTE_TL_CORE.tl_core (
2198: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),
2199: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
2200: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(i),
2201: x_trip_charges_rec => l_trip_charges_rec,
2202: x_stop_charges_tab => l_stop_charges_tab,

Line 2199: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,

2195: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'trip index:'||i||'stop ref'||FTE_TL_CACHE.g_tl_trip_rows(i).stop_reference);
2196:
2197: FTE_TL_CORE.tl_core (
2198: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),
2199: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
2200: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(i),
2201: x_trip_charges_rec => l_trip_charges_rec,
2202: x_stop_charges_tab => l_stop_charges_tab,
2203: x_return_status => l_return_status );

Line 2200: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(i),

2196:
2197: FTE_TL_CORE.tl_core (
2198: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),
2199: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
2200: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(i),
2201: x_trip_charges_rec => l_trip_charges_rec,
2202: x_stop_charges_tab => l_stop_charges_tab,
2203: x_return_status => l_return_status );
2204:

Line 2213: p_trip_id=>FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);

2209:
2210: FTE_FREIGHT_PRICING_UTIL.setmsg (
2211: p_api=>'Handle_CM_Rate_Variant',
2212: p_exc=>'g_tl_core_fail',
2213: p_trip_id=>FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);
2214:
2215: raise FTE_FREIGHT_PRICING_UTIL.g_tl_core_fail;
2216: END IF;
2217: END IF;

Line 2259: IF(FTE_TL_CACHE.g_tl_trip_rows(i).dead_head='Y')

2255:
2256: k:=l_stop_charges_tab.NEXT(k);
2257: END LOOP;
2258:
2259: IF(FTE_TL_CACHE.g_tl_trip_rows(i).dead_head='Y')
2260: THEN
2261: l_dead_head_charge:=l_dead_head_charge+
2262: l_trip_charges_tab(FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);
2263: ELSE

Line 2262: l_trip_charges_tab(FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);

2258:
2259: IF(FTE_TL_CACHE.g_tl_trip_rows(i).dead_head='Y')
2260: THEN
2261: l_dead_head_charge:=l_dead_head_charge+
2262: l_trip_charges_tab(FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);
2263: ELSE
2264: l_load_charge:=l_load_charge
2265: +l_trip_charges_tab(FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);
2266:

Line 2265: +l_trip_charges_tab(FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);

2261: l_dead_head_charge:=l_dead_head_charge+
2262: l_trip_charges_tab(FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);
2263: ELSE
2264: l_load_charge:=l_load_charge
2265: +l_trip_charges_tab(FTE_TL_CACHE.g_tl_trip_rows(i).trip_id);
2266:
2267: END IF;
2268:
2269:

Line 2281: IF(FTE_TL_CACHE.g_tl_trip_rows(i).dead_head='N')

2277:
2278: i:=l_store_trip_rows.FIRST;
2279: WHILE(i IS NOT NULL)
2280: LOOP
2281: IF(FTE_TL_CACHE.g_tl_trip_rows(i).dead_head='N')
2282: THEN
2283: IF (l_load_charge <> 0)
2284: THEN
2285: l_factor:=1+l_dead_head_charge/l_load_charge;

Line 2292: FTE_TL_CACHE.g_tl_trip_rows(i).trip_id||' : '||l_factor);

2288: END IF;
2289:
2290:
2291: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Effective discount (Rate)trip: '||
2292: FTE_TL_CACHE.g_tl_trip_rows(i).trip_id||' : '||l_factor);
2293:
2294: FTE_TL_COST_ALLOCATION.Scale_Trip_Charges(
2295: p_discount=> l_factor,
2296: x_trip_charges_rec=> l_store_trip_rows(i),

Line 2484: IF (FTE_TL_CACHE.g_tl_trip_rows.LAST IS NULL)

2480:
2481: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2482:
2483:
2484: IF (FTE_TL_CACHE.g_tl_trip_rows.LAST IS NULL)
2485: THEN
2486: l_trip_index_start:=1;
2487: ELSE
2488: l_trip_index_start:=FTE_TL_CACHE.g_tl_trip_rows.LAST+1;

Line 2488: l_trip_index_start:=FTE_TL_CACHE.g_tl_trip_rows.LAST+1;

2484: IF (FTE_TL_CACHE.g_tl_trip_rows.LAST IS NULL)
2485: THEN
2486: l_trip_index_start:=1;
2487: ELSE
2488: l_trip_index_start:=FTE_TL_CACHE.g_tl_trip_rows.LAST+1;
2489: END IF;
2490:
2491: FTE_TL_CACHE.TL_Build_Cache_For_Move(
2492: p_fte_move_id=> p_fte_move_id,

Line 2491: FTE_TL_CACHE.TL_Build_Cache_For_Move(

2487: ELSE
2488: l_trip_index_start:=FTE_TL_CACHE.g_tl_trip_rows.LAST+1;
2489: END IF;
2490:
2491: FTE_TL_CACHE.TL_Build_Cache_For_Move(
2492: p_fte_move_id=> p_fte_move_id,
2493: x_return_status=> l_return_status);
2494:
2495:

Line 2512: l_trip_index_end:=FTE_TL_CACHE.g_tl_trip_rows.LAST;

2508: raise FTE_FREIGHT_PRICING_UTIL.g_tl_build_cache_move_fail;
2509: END IF;
2510: END IF;
2511:
2512: l_trip_index_end:=FTE_TL_CACHE.g_tl_trip_rows.LAST;
2513: FTE_TL_CACHE.Display_Cache;
2514:
2515: IF (FTE_TL_CACHE.g_tl_carrier_pref_rows(l_trip_index_start).cm_rate_variant='RATE')
2516: THEN

Line 2513: FTE_TL_CACHE.Display_Cache;

2509: END IF;
2510: END IF;
2511:
2512: l_trip_index_end:=FTE_TL_CACHE.g_tl_trip_rows.LAST;
2513: FTE_TL_CACHE.Display_Cache;
2514:
2515: IF (FTE_TL_CACHE.g_tl_carrier_pref_rows(l_trip_index_start).cm_rate_variant='RATE')
2516: THEN
2517: Handle_CM_Rate_Variant(

Line 2515: IF (FTE_TL_CACHE.g_tl_carrier_pref_rows(l_trip_index_start).cm_rate_variant='RATE')

2511:
2512: l_trip_index_end:=FTE_TL_CACHE.g_tl_trip_rows.LAST;
2513: FTE_TL_CACHE.Display_Cache;
2514:
2515: IF (FTE_TL_CACHE.g_tl_carrier_pref_rows(l_trip_index_start).cm_rate_variant='RATE')
2516: THEN
2517: Handle_CM_Rate_Variant(
2518: p_fte_move_id=> p_fte_move_id,
2519: p_trip_index_start=> l_trip_index_start,

Line 2534: ELSIF (FTE_TL_CACHE.g_tl_carrier_pref_rows(l_trip_index_start).cm_rate_variant='DISCOUNT')

2530: END IF;
2531: END IF;
2532:
2533:
2534: ELSIF (FTE_TL_CACHE.g_tl_carrier_pref_rows(l_trip_index_start).cm_rate_variant='DISCOUNT')
2535: THEN
2536: Handle_CM_Discount_Variant(
2537: p_fte_move_id=> p_fte_move_id,
2538: p_trip_index_start=> l_trip_index_start,

Line 2558: p_carrier_id=>FTE_TL_CACHE.g_tl_carrier_pref_rows(l_trip_index_start).carrier_id);

2554: ELSE
2555: FTE_FREIGHT_PRICING_UTIL.setmsg (
2556: p_api=>'TL_Rate_Move',
2557: p_exc=>'g_tl_car_no_cm_rate_variant',
2558: p_carrier_id=>FTE_TL_CACHE.g_tl_carrier_pref_rows(l_trip_index_start).carrier_id);
2559:
2560:
2561: raise FTE_FREIGHT_PRICING_UTIL.g_tl_car_no_cm_rate_variant;
2562:

Line 2615: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;

2611: x_output_cost_tab OUT NOCOPY FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type ,
2612: x_return_status OUT NOCOPY VARCHAR2) IS
2613:
2614:
2615: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2616: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2617: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;
2618: l_output_cost_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
2619:

Line 2616: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;

2612: x_return_status OUT NOCOPY VARCHAR2) IS
2613:
2614:
2615: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2616: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2617: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;
2618: l_output_cost_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
2619:
2620: l_return_status VARCHAR2(1);

Line 2634: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(p_trip_index),

2630: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2631:
2632:
2633: FTE_TL_CORE.tl_core (
2634: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(p_trip_index),
2635: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
2636: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index),
2637: x_trip_charges_rec => l_trip_charges_rec,
2638: x_stop_charges_tab => l_stop_charges_tab,

Line 2635: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,

2631:
2632:
2633: FTE_TL_CORE.tl_core (
2634: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(p_trip_index),
2635: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
2636: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index),
2637: x_trip_charges_rec => l_trip_charges_rec,
2638: x_stop_charges_tab => l_stop_charges_tab,
2639: x_return_status => l_return_status );

Line 2636: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index),

2632:
2633: FTE_TL_CORE.tl_core (
2634: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(p_trip_index),
2635: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
2636: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(p_trip_index),
2637: x_trip_charges_rec => l_trip_charges_rec,
2638: x_stop_charges_tab => l_stop_charges_tab,
2639: x_return_status => l_return_status );
2640:

Line 2649: -- p_trip_id=>FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id);

2645:
2646: --FTE_FREIGHT_PRICING_UTIL.setmsg (
2647: -- p_api=>'TL_Rate_Cached_Trip',
2648: -- p_exc=>'g_tl_core_fail',
2649: -- p_trip_id=>FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id);
2650:
2651: raise FTE_FREIGHT_PRICING_UTIL.g_tl_core_fail;
2652: END IF;
2653: END IF;

Line 2740: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_output_tab_type ,

2736: x_lane_sched_sum_rows OUT NOCOPY dbms_utility.number_array,
2737: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
2738: x_output_cost_tab OUT NOCOPY FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type ,
2739: x_exceptions_tab OUT NOCOPY FTE_TL_CORE.tl_exceptions_tab_type,
2740: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_output_tab_type ,
2741: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
2742: x_return_status OUT NOCOPY VARCHAR2) IS
2743:
2744:

Line 2741: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,

2737: x_lane_sched_curr_rows OUT NOCOPY dbms_utility.name_array,
2738: x_output_cost_tab OUT NOCOPY FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type ,
2739: x_exceptions_tab OUT NOCOPY FTE_TL_CORE.tl_exceptions_tab_type,
2740: x_trip_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_output_tab_type ,
2741: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
2742: x_return_status OUT NOCOPY VARCHAR2) IS
2743:
2744:
2745: i NUMBER;

Line 2749: l_trip_charges_tab FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE;

2745: i NUMBER;
2746: j NUMBER;
2747: k NUMBER;
2748: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
2749: l_trip_charges_tab FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE;
2750: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2751: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2752: l_stop_charges_one_trip_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2753: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;

Line 2750: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;

2746: j NUMBER;
2747: k NUMBER;
2748: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
2749: l_trip_charges_tab FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE;
2750: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2751: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2752: l_stop_charges_one_trip_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2753: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;
2754:

Line 2751: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;

2747: k NUMBER;
2748: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
2749: l_trip_charges_tab FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE;
2750: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2751: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2752: l_stop_charges_one_trip_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2753: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;
2754:
2755:

Line 2752: l_stop_charges_one_trip_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;

2748: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
2749: l_trip_charges_tab FTE_TL_CACHE.TL_TRIP_OUTPUT_TAB_TYPE;
2750: l_trip_charges_rec FTE_TL_CACHE.TL_trip_output_rec_type;
2751: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2752: l_stop_charges_one_trip_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
2753: l_cost_allocation_parameters FTE_TL_COST_ALLOCATION.TL_allocation_params_rec_type;
2754:
2755:
2756: l_return_status VARCHAR2(1);

Line 2774: p_trip_tab=>FTE_TL_CACHE.g_tl_trip_rows,

2770:
2771: FTE_TL_CORE.TL_Core_Multiple (
2772: p_start_trip_index=>p_start_trip_index,
2773: p_end_trip_index=>p_end_trip_index,
2774: p_trip_tab=>FTE_TL_CACHE.g_tl_trip_rows,
2775: p_stop_tab=>FTE_TL_CACHE.g_tl_trip_stop_rows,
2776: p_carrier_pref_tab=>FTE_TL_CACHE.g_tl_carrier_pref_rows,
2777: x_trip_charges_tab=>l_trip_charges_tab,
2778: x_stop_charges_tab=>l_stop_charges_tab,

Line 2775: p_stop_tab=>FTE_TL_CACHE.g_tl_trip_stop_rows,

2771: FTE_TL_CORE.TL_Core_Multiple (
2772: p_start_trip_index=>p_start_trip_index,
2773: p_end_trip_index=>p_end_trip_index,
2774: p_trip_tab=>FTE_TL_CACHE.g_tl_trip_rows,
2775: p_stop_tab=>FTE_TL_CACHE.g_tl_trip_stop_rows,
2776: p_carrier_pref_tab=>FTE_TL_CACHE.g_tl_carrier_pref_rows,
2777: x_trip_charges_tab=>l_trip_charges_tab,
2778: x_stop_charges_tab=>l_stop_charges_tab,
2779: x_exceptions_tab=>l_exceptions_tab,

Line 2776: p_carrier_pref_tab=>FTE_TL_CACHE.g_tl_carrier_pref_rows,

2772: p_start_trip_index=>p_start_trip_index,
2773: p_end_trip_index=>p_end_trip_index,
2774: p_trip_tab=>FTE_TL_CACHE.g_tl_trip_rows,
2775: p_stop_tab=>FTE_TL_CACHE.g_tl_trip_stop_rows,
2776: p_carrier_pref_tab=>FTE_TL_CACHE.g_tl_carrier_pref_rows,
2777: x_trip_charges_tab=>l_trip_charges_tab,
2778: x_stop_charges_tab=>l_stop_charges_tab,
2779: x_exceptions_tab=>l_exceptions_tab,
2780: x_return_status => l_return_status );

Line 2791: -- p_trip_id=>FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id);

2787:
2788: --FTE_FREIGHT_PRICING_UTIL.setmsg (
2789: -- p_api=>'TL_Rate_Cached_Trip',
2790: -- p_exc=>'g_tl_core_fail',
2791: -- p_trip_id=>FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id);
2792:
2793: raise FTE_FREIGHT_PRICING_UTIL.g_tl_core_fail;
2794: END IF;
2795: END IF;

Line 2834: WHILE((FTE_TL_CACHE.g_tl_trip_rows(i).number_of_stops > 0) AND

2830: THEN
2831:
2832: l_stop_charges_one_trip_tab.delete;
2833: j:=l_trip_charges_tab(i).stop_charge_reference;
2834: WHILE((FTE_TL_CACHE.g_tl_trip_rows(i).number_of_stops > 0) AND
2835: (j<(FTE_TL_CACHE.g_tl_trip_rows(i).number_of_stops+l_trip_charges_tab(i).stop_charge_reference)))
2836: LOOP
2837:
2838: l_stop_charges_one_trip_tab(j):=l_stop_charges_tab(j);

Line 2835: (j<(FTE_TL_CACHE.g_tl_trip_rows(i).number_of_stops+l_trip_charges_tab(i).stop_charge_reference)))

2831:
2832: l_stop_charges_one_trip_tab.delete;
2833: j:=l_trip_charges_tab(i).stop_charge_reference;
2834: WHILE((FTE_TL_CACHE.g_tl_trip_rows(i).number_of_stops > 0) AND
2835: (j<(FTE_TL_CACHE.g_tl_trip_rows(i).number_of_stops+l_trip_charges_tab(i).stop_charge_reference)))
2836: LOOP
2837:
2838: l_stop_charges_one_trip_tab(j):=l_stop_charges_tab(j);
2839: j:=j+1;

Line 2863: x_lane_sched_curr_rows(k):=FTE_TL_CACHE.g_tl_carrier_pref_rows(i).currency;

2859: END IF;
2860: END IF;
2861:
2862: l_trip_charges_tab(i).total_trip_rate:=x_lane_sched_sum_rows(k);
2863: x_lane_sched_curr_rows(k):=FTE_TL_CACHE.g_tl_carrier_pref_rows(i).currency;
2864:
2865:
2866: IF (p_allocate_flag = 'Y')
2867: THEN

Line 2999: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);

2995: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'TL_Rate_Trip','start');
2996:
2997: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2998:
2999: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
3000: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3001: THEN
3002: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3003: THEN

Line 3155: FTE_TL_CACHE.TL_Build_Cache_For_Trip(

3151: END IF;
3152: END IF;
3153:
3154:
3155: FTE_TL_CACHE.TL_Build_Cache_For_Trip(
3156: p_wsh_trip_id => p_trip_id,
3157: x_return_status => l_return_status);
3158:
3159: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS

Line 3172: FTE_TL_CACHE.Display_Cache;

3168: raise FTE_FREIGHT_PRICING_UTIL.g_tl_build_cache_trp_fail;
3169: END IF;
3170: END IF;
3171:
3172: FTE_TL_CACHE.Display_Cache;
3173:
3174: TL_Rate_Cached_Trip (
3175: p_trip_index=> FTE_TL_CACHE.g_tl_trip_rows.LAST,
3176: p_output_type=> p_output_type,

Line 3175: p_trip_index=> FTE_TL_CACHE.g_tl_trip_rows.LAST,

3171:
3172: FTE_TL_CACHE.Display_Cache;
3173:
3174: TL_Rate_Cached_Trip (
3175: p_trip_index=> FTE_TL_CACHE.g_tl_trip_rows.LAST,
3176: p_output_type=> p_output_type,
3177: x_output_cost_tab=> x_output_cost_tab,
3178: x_return_status=> l_return_status
3179: );

Line 3337: IF( (FTE_TL_CACHE.g_tl_trip_rows(j).schedule_id IS NOT NULL)

3333: l_lane_cached:='N';
3334:
3335: --Get rates only if that lane/schedule was cached
3336:
3337: IF( (FTE_TL_CACHE.g_tl_trip_rows(j).schedule_id IS NOT NULL)
3338: AND (FTE_TL_CACHE.g_tl_trip_rows(j).schedule_id= p_schedule_rows(i)) AND (p_vehicle_rows(i)=FTE_TL_CACHE.g_tl_trip_rows(j).vehicle_type ))
3339: THEN
3340: l_lane_cached:='Y';
3341:

Line 3338: AND (FTE_TL_CACHE.g_tl_trip_rows(j).schedule_id= p_schedule_rows(i)) AND (p_vehicle_rows(i)=FTE_TL_CACHE.g_tl_trip_rows(j).vehicle_type ))

3334:
3335: --Get rates only if that lane/schedule was cached
3336:
3337: IF( (FTE_TL_CACHE.g_tl_trip_rows(j).schedule_id IS NOT NULL)
3338: AND (FTE_TL_CACHE.g_tl_trip_rows(j).schedule_id= p_schedule_rows(i)) AND (p_vehicle_rows(i)=FTE_TL_CACHE.g_tl_trip_rows(j).vehicle_type ))
3339: THEN
3340: l_lane_cached:='Y';
3341:
3342: ELSIF ((FTE_TL_CACHE.g_tl_trip_rows(j).lane_id IS NOT NULL)

Line 3342: ELSIF ((FTE_TL_CACHE.g_tl_trip_rows(j).lane_id IS NOT NULL)

3338: AND (FTE_TL_CACHE.g_tl_trip_rows(j).schedule_id= p_schedule_rows(i)) AND (p_vehicle_rows(i)=FTE_TL_CACHE.g_tl_trip_rows(j).vehicle_type ))
3339: THEN
3340: l_lane_cached:='Y';
3341:
3342: ELSIF ((FTE_TL_CACHE.g_tl_trip_rows(j).lane_id IS NOT NULL)
3343: AND (FTE_TL_CACHE.g_tl_trip_rows(j).lane_id= p_lane_rows(i)) AND (p_vehicle_rows(i)=FTE_TL_CACHE.g_tl_trip_rows(j).vehicle_type ))
3344: THEN
3345: l_lane_cached:='Y';
3346:

Line 3343: AND (FTE_TL_CACHE.g_tl_trip_rows(j).lane_id= p_lane_rows(i)) AND (p_vehicle_rows(i)=FTE_TL_CACHE.g_tl_trip_rows(j).vehicle_type ))

3339: THEN
3340: l_lane_cached:='Y';
3341:
3342: ELSIF ((FTE_TL_CACHE.g_tl_trip_rows(j).lane_id IS NOT NULL)
3343: AND (FTE_TL_CACHE.g_tl_trip_rows(j).lane_id= p_lane_rows(i)) AND (p_vehicle_rows(i)=FTE_TL_CACHE.g_tl_trip_rows(j).vehicle_type ))
3344: THEN
3345: l_lane_cached:='Y';
3346:
3347: END IF;

Line 3421: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;

3417: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
3418: i NUMBER;
3419: l_request_id NUMBER;
3420: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
3421: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
3422: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
3423: l_summary_cache_ref dbms_utility.number_array;
3424:
3425: CURSOR c_get_req_id IS

Line 3422: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;

3418: i NUMBER;
3419: l_request_id NUMBER;
3420: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
3421: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
3422: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
3423: l_summary_cache_ref dbms_utility.number_array;
3424:
3425: CURSOR c_get_req_id IS
3426: SELECT fte_pricing_comp_request_s.nextval

Line 3494: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);

3490: ELSE
3491: --No freight term/manifesting issues
3492:
3493:
3494: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
3495:
3496: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3497: THEN
3498: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING

Line 3504: FTE_TL_CACHE.TL_BUILD_CACHE_FOR_TRP_COMPARE(

3500: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
3501: END IF;
3502: END IF;
3503:
3504: FTE_TL_CACHE.TL_BUILD_CACHE_FOR_TRP_COMPARE(
3505: p_wsh_trip_id => p_wsh_trip_id,
3506: p_lane_rows=> p_lane_rows,
3507: p_schedule_rows=> p_schedule_rows,
3508: p_vehicle_rows =>p_vehicle_rows,

Line 3526: FTE_TL_CACHE.Display_Cache;

3522: END IF;
3523: END IF;
3524:
3525:
3526: FTE_TL_CACHE.Display_Cache;
3527:
3528: IF (x_request_id IS NULL OR x_request_id = 0) THEN
3529:
3530: OPEN c_get_req_id;

Line 3544: IF(FTE_TL_CACHE.g_tl_trip_rows.FIRST IS NOT NULL)

3540:
3541: fte_freight_pricing_util.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'comp request_id='||l_request_id);
3542:
3543:
3544: IF(FTE_TL_CACHE.g_tl_trip_rows.FIRST IS NOT NULL)
3545: THEN
3546:
3547: TL_Rate_Cached_Trip_Multiple (
3548: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,

Line 3548: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,

3544: IF(FTE_TL_CACHE.g_tl_trip_rows.FIRST IS NOT NULL)
3545: THEN
3546:
3547: TL_Rate_Cached_Trip_Multiple (
3548: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
3549: p_end_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.LAST,
3550: p_output_type =>'T',
3551: p_request_id =>l_request_id,
3552: p_allocate_flag=>'Y',

Line 3549: p_end_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.LAST,

3545: THEN
3546:
3547: TL_Rate_Cached_Trip_Multiple (
3548: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
3549: p_end_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.LAST,
3550: p_output_type =>'T',
3551: p_request_id =>l_request_id,
3552: p_allocate_flag=>'Y',
3553: x_lane_sched_sum_rows=>x_lane_sched_sum_rows,

Line 3576: p_start_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.FIRST,

3572: Populate_Summary_Rates(
3573: p_lane_rows=>p_lane_rows,
3574: p_schedule_rows=>p_schedule_rows,
3575: p_vehicle_rows=>p_vehicle_rows,
3576: p_start_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
3577: p_end_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.LAST,
3578: p_exceptions_tab=>l_exceptions_tab,
3579: x_lane_sched_sum_rows=>x_lane_sched_sum_rows,
3580: x_lane_sched_curr_rows=>x_lane_sched_curr_rows,

Line 3577: p_end_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.LAST,

3573: p_lane_rows=>p_lane_rows,
3574: p_schedule_rows=>p_schedule_rows,
3575: p_vehicle_rows=>p_vehicle_rows,
3576: p_start_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
3577: p_end_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.LAST,
3578: p_exceptions_tab=>l_exceptions_tab,
3579: x_lane_sched_sum_rows=>x_lane_sched_sum_rows,
3580: x_lane_sched_curr_rows=>x_lane_sched_curr_rows,
3581: x_summary_cache_ref=>l_summary_cache_ref,

Line 3618: IF (FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id IS NOT NULL)

3614: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Rate cached trip failed for trip index:'||i);
3615: --Add warning message
3616: l_warning_count:=l_warning_count+1;
3617:
3618: IF (FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id IS NOT NULL)
3619: THEN
3620: --Show only generic message
3621: --FTE_FREIGHT_PRICING_UTIL.setmsg (
3622: --p_api=>'TL_Trip_Price_Compare',

Line 3626: --p_schedule_id=>FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id);

3622: --p_api=>'TL_Trip_Price_Compare',
3623: --p_exc=>'g_tl_trip_cmp_rate_schd_fail',
3624: --p_msg_type=>'W',
3625: --p_trip_id=> p_wsh_trip_id,
3626: --p_schedule_id=>FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id);
3627: NULL;
3628:
3629: ELSE
3630: --Show only generic message

Line 3636: -- p_lane_id=>FTE_TL_CACHE.g_tl_trip_rows(i).lane_id);

3632: -- p_api=>'TL_Trip_Price_Compare',
3633: -- p_exc=>'g_tl_trip_cmp_rate_lane_fail',
3634: -- p_msg_type=>'W',
3635: -- p_trip_id=> p_wsh_trip_id,
3636: -- p_lane_id=>FTE_TL_CACHE.g_tl_trip_rows(i).lane_id);
3637:
3638: NULL;
3639:
3640: END IF;

Line 3775: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;

3771: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
3772: i NUMBER;
3773: l_request_id NUMBER;
3774: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
3775: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
3776: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
3777: l_summary_cache_ref dbms_utility.number_array;
3778:
3779:

Line 3776: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;

3772: i NUMBER;
3773: l_request_id NUMBER;
3774: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
3775: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
3776: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
3777: l_summary_cache_ref dbms_utility.number_array;
3778:
3779:
3780: l_term_manifest_flag VARCHAR2(1);

Line 3797: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);

3793:
3794: --No freight term/manifesting issues
3795:
3796:
3797: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
3798:
3799: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3800: THEN
3801: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING

Line 3807: FTE_TL_CACHE.TL_BUILD_CACHE_FOR_DLV_COMPARE(

3803: raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
3804: END IF;
3805: END IF;
3806:
3807: FTE_TL_CACHE.TL_BUILD_CACHE_FOR_DLV_COMPARE(
3808: p_wsh_delivery_id => p_wsh_delivery_id,
3809: p_lane_rows=> p_lane_rows,
3810: p_schedule_rows=> p_schedule_rows,
3811: p_vehicle_rows =>p_vehicle_rows,

Line 3836: FTE_TL_CACHE.Display_Cache;

3832: END IF;
3833: END IF;
3834:
3835:
3836: FTE_TL_CACHE.Display_Cache;
3837:
3838: IF (x_request_id IS NULL OR x_request_id = 0) THEN
3839:
3840: OPEN c_get_req_id;

Line 3854: IF(FTE_TL_CACHE.g_tl_trip_rows.FIRST IS NOT NULL)

3850:
3851: fte_freight_pricing_util.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'comp request_id='||l_request_id);
3852:
3853:
3854: IF(FTE_TL_CACHE.g_tl_trip_rows.FIRST IS NOT NULL)
3855: THEN
3856:
3857: TL_Rate_Cached_Trip_Multiple (
3858: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,

Line 3858: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,

3854: IF(FTE_TL_CACHE.g_tl_trip_rows.FIRST IS NOT NULL)
3855: THEN
3856:
3857: TL_Rate_Cached_Trip_Multiple (
3858: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
3859: p_end_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.LAST,
3860: p_output_type =>'T',
3861: p_request_id =>l_request_id,
3862: p_allocate_flag=>'Y',

Line 3859: p_end_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.LAST,

3855: THEN
3856:
3857: TL_Rate_Cached_Trip_Multiple (
3858: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
3859: p_end_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.LAST,
3860: p_output_type =>'T',
3861: p_request_id =>l_request_id,
3862: p_allocate_flag=>'Y',
3863: x_lane_sched_sum_rows=>x_lane_sched_sum_rows,

Line 3884: p_start_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.FIRST,

3880: Populate_Summary_Rates(
3881: p_lane_rows=>p_lane_rows,
3882: p_schedule_rows=>p_schedule_rows,
3883: p_vehicle_rows=>p_vehicle_rows,
3884: p_start_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
3885: p_end_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.LAST,
3886: p_exceptions_tab=>l_exceptions_tab,
3887: x_lane_sched_sum_rows=>x_lane_sched_sum_rows,
3888: x_lane_sched_curr_rows=>x_lane_sched_curr_rows,

Line 3885: p_end_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.LAST,

3881: p_lane_rows=>p_lane_rows,
3882: p_schedule_rows=>p_schedule_rows,
3883: p_vehicle_rows=>p_vehicle_rows,
3884: p_start_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
3885: p_end_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.LAST,
3886: p_exceptions_tab=>l_exceptions_tab,
3887: x_lane_sched_sum_rows=>x_lane_sched_sum_rows,
3888: x_lane_sched_curr_rows=>x_lane_sched_curr_rows,
3889: x_summary_cache_ref=>l_summary_cache_ref,

Line 3925: --IF (FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id IS NOT NULL)

3921: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Rate cached trip failed for trip index:'||i);
3922: --Add warning message
3923: l_warning_count:=l_warning_count+1;
3924:
3925: --IF (FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id IS NOT NULL)
3926: --THEN
3927:
3928: -- FTE_FREIGHT_PRICING_UTIL.setmsg (
3929: -- p_api=>'TL_Delivery_Price_Compare',

Line 3933: -- p_schedule_id=>FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id);

3929: -- p_api=>'TL_Delivery_Price_Compare',
3930: -- p_exc=>'g_tl_trip_cmp_rate_schd_fail',
3931: -- p_msg_type=>'W',
3932: -- p_trip_id=> p_wsh_trip_id,
3933: -- p_schedule_id=>FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id);
3934:
3935:
3936: --ELSE
3937:

Line 3943: -- p_lane_id=>FTE_TL_CACHE.g_tl_trip_rows(i).lane_id);

3939: -- p_api=>'TL_Delivery_Price_Compare',
3940: -- p_exc=>'g_tl_trip_cmp_rate_lane_fail',
3941: -- p_msg_type=>'W',
3942: -- p_trip_id=> p_wsh_trip_id,
3943: -- p_lane_id=>FTE_TL_CACHE.g_tl_trip_rows(i).lane_id);
3944:
3945: --END IF;
3946:
3947:

Line 4045: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type ,

4041:
4042:
4043: PROCEDURE Get_Base_Accessory_Charges(
4044: p_trip_index IN NUMBER,
4045: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type ,
4046: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type,
4047: x_base_price IN OUT NOCOPY NUMBER,
4048: x_acc_charge IN OUT NOCOPY NUMBER,
4049: x_currency IN OUT NOCOPY VARCHAR2,

Line 4046: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type,

4042:
4043: PROCEDURE Get_Base_Accessory_Charges(
4044: p_trip_index IN NUMBER,
4045: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type ,
4046: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type,
4047: x_base_price IN OUT NOCOPY NUMBER,
4048: x_acc_charge IN OUT NOCOPY NUMBER,
4049: x_currency IN OUT NOCOPY VARCHAR2,
4050: x_return_status OUT NOCOPY Varchar2) IS

Line 4139: l_trip_charges_rec FTE_TL_CACHE.TL_TRIP_OUTPUT_REC_TYPE;

4135: p_origin_id IN NUMBER DEFAULT NULL,
4136: p_destination_id IN NUMBER DEFAULT NULL) IS
4137:
4138:
4139: l_trip_charges_rec FTE_TL_CACHE.TL_TRIP_OUTPUT_REC_TYPE;
4140: l_stop_charges_tab FTE_TL_CACHE.TL_TRIP_STOP_OUTPUT_TAB_TYPE;
4141: i NUMBER;
4142: j NUMBER;
4143: l_return_status VARCHAR2(1);

Line 4140: l_stop_charges_tab FTE_TL_CACHE.TL_TRIP_STOP_OUTPUT_TAB_TYPE;

4136: p_destination_id IN NUMBER DEFAULT NULL) IS
4137:
4138:
4139: l_trip_charges_rec FTE_TL_CACHE.TL_TRIP_OUTPUT_REC_TYPE;
4140: l_stop_charges_tab FTE_TL_CACHE.TL_TRIP_STOP_OUTPUT_TAB_TYPE;
4141: i NUMBER;
4142: j NUMBER;
4143: l_return_status VARCHAR2(1);
4144: l_rating_fail VARCHAR2(1);

Line 4159: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);

4155: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4156:
4157: l_cache_fail:='N';
4158:
4159: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
4160: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
4161: THEN
4162: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
4163: THEN

Line 4169: FTE_TL_CACHE.TL_BUILD_CACHE_FOR_ESTIMATE(

4165: END IF;
4166: END IF;
4167:
4168:
4169: FTE_TL_CACHE.TL_BUILD_CACHE_FOR_ESTIMATE(
4170: p_lane_rows=>p_lane_rows,
4171: p_schedule_rows=> p_schedule_rows,
4172: p_vehicle_rows=>p_vehicle_rows,
4173: p_pickup_location_id=>p_pickup_location_id,

Line 4199: FTE_TL_CACHE.Display_Cache;

4195: --raise FTE_FREIGHT_PRICING_UTIL.g_tl_cache_estimate_fail;
4196: END IF;
4197: END IF;
4198:
4199: FTE_TL_CACHE.Display_Cache;
4200:
4201: i:=FTE_TL_CACHE.g_tl_trip_rows.FIRST;
4202: j:=p_lane_rows.FIRST;
4203: WHILE( j IS NOT NULL)

Line 4201: i:=FTE_TL_CACHE.g_tl_trip_rows.FIRST;

4197: END IF;
4198:
4199: FTE_TL_CACHE.Display_Cache;
4200:
4201: i:=FTE_TL_CACHE.g_tl_trip_rows.FIRST;
4202: j:=p_lane_rows.FIRST;
4203: WHILE( j IS NOT NULL)
4204: LOOP
4205:

Line 4216: IF( (i IS NOT NULL) AND (FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id IS NOT NULL)

4212: l_lane_fail:='Y';
4213:
4214: --Get rates only if that lane/schedule was cached
4215:
4216: IF( (i IS NOT NULL) AND (FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id IS NOT NULL)
4217: AND (FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id= p_schedule_rows(j)) AND (p_vehicle_rows(j)=FTE_TL_CACHE.g_tl_trip_rows(i).vehicle_type ))
4218: THEN
4219: l_lane_fail:='N';
4220:

Line 4217: AND (FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id= p_schedule_rows(j)) AND (p_vehicle_rows(j)=FTE_TL_CACHE.g_tl_trip_rows(i).vehicle_type ))

4213:
4214: --Get rates only if that lane/schedule was cached
4215:
4216: IF( (i IS NOT NULL) AND (FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id IS NOT NULL)
4217: AND (FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id= p_schedule_rows(j)) AND (p_vehicle_rows(j)=FTE_TL_CACHE.g_tl_trip_rows(i).vehicle_type ))
4218: THEN
4219: l_lane_fail:='N';
4220:
4221: ELSIF ((i IS NOT NULL) AND (FTE_TL_CACHE.g_tl_trip_rows(i).lane_id IS NOT NULL)

Line 4221: ELSIF ((i IS NOT NULL) AND (FTE_TL_CACHE.g_tl_trip_rows(i).lane_id IS NOT NULL)

4217: AND (FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id= p_schedule_rows(j)) AND (p_vehicle_rows(j)=FTE_TL_CACHE.g_tl_trip_rows(i).vehicle_type ))
4218: THEN
4219: l_lane_fail:='N';
4220:
4221: ELSIF ((i IS NOT NULL) AND (FTE_TL_CACHE.g_tl_trip_rows(i).lane_id IS NOT NULL)
4222: AND (FTE_TL_CACHE.g_tl_trip_rows(i).lane_id= p_lane_rows(j)) AND (p_vehicle_rows(j)=FTE_TL_CACHE.g_tl_trip_rows(i).vehicle_type ))
4223: THEN
4224: l_lane_fail:='N';
4225:

Line 4222: AND (FTE_TL_CACHE.g_tl_trip_rows(i).lane_id= p_lane_rows(j)) AND (p_vehicle_rows(j)=FTE_TL_CACHE.g_tl_trip_rows(i).vehicle_type ))

4218: THEN
4219: l_lane_fail:='N';
4220:
4221: ELSIF ((i IS NOT NULL) AND (FTE_TL_CACHE.g_tl_trip_rows(i).lane_id IS NOT NULL)
4222: AND (FTE_TL_CACHE.g_tl_trip_rows(i).lane_id= p_lane_rows(j)) AND (p_vehicle_rows(j)=FTE_TL_CACHE.g_tl_trip_rows(i).vehicle_type ))
4223: THEN
4224: l_lane_fail:='N';
4225:
4226: END IF;

Line 4234: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Now Rating Lane'|| FTE_TL_CACHE.g_tl_trip_rows(i).lane_id||

4230: THEN
4231:
4232: l_rating_fail:='N';
4233:
4234: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Now Rating Lane'|| FTE_TL_CACHE.g_tl_trip_rows(i).lane_id||
4235: ' Schedule :'||FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id);
4236:
4237: FTE_TL_CORE.tl_core (
4238: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),

Line 4235: ' Schedule :'||FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id);

4231:
4232: l_rating_fail:='N';
4233:
4234: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Now Rating Lane'|| FTE_TL_CACHE.g_tl_trip_rows(i).lane_id||
4235: ' Schedule :'||FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id);
4236:
4237: FTE_TL_CORE.tl_core (
4238: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),
4239: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,

Line 4238: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),

4234: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Now Rating Lane'|| FTE_TL_CACHE.g_tl_trip_rows(i).lane_id||
4235: ' Schedule :'||FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id);
4236:
4237: FTE_TL_CORE.tl_core (
4238: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),
4239: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
4240: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(i),
4241: x_trip_charges_rec => l_trip_charges_rec,
4242: x_stop_charges_tab => l_stop_charges_tab,

Line 4239: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,

4235: ' Schedule :'||FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id);
4236:
4237: FTE_TL_CORE.tl_core (
4238: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),
4239: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
4240: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(i),
4241: x_trip_charges_rec => l_trip_charges_rec,
4242: x_stop_charges_tab => l_stop_charges_tab,
4243: x_return_status => l_return_status );

Line 4240: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(i),

4236:
4237: FTE_TL_CORE.tl_core (
4238: p_trip_rec => FTE_TL_CACHE.g_tl_trip_rows(i),
4239: p_stop_tab => FTE_TL_CACHE.g_tl_trip_stop_rows,
4240: p_carrier_pref => FTE_TL_CACHE.g_tl_carrier_pref_rows(i),
4241: x_trip_charges_rec => l_trip_charges_rec,
4242: x_stop_charges_tab => l_stop_charges_tab,
4243: x_return_status => l_return_status );
4244:

Line 4279: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'For Lane'|| FTE_TL_CACHE.g_tl_trip_rows(i).lane_id||

4275: END IF;
4276: END IF;
4277: END IF;
4278:
4279: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'For Lane'|| FTE_TL_CACHE.g_tl_trip_rows(i).lane_id||
4280: ' Schedule :'||FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id);
4281:
4282: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Estimate:'||x_lane_sched_base_rows(j)||
4283: ':'||x_lane_sched_acc_rows(j)||':'||x_lane_sched_curr_rows(j));

Line 4280: ' Schedule :'||FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id);

4276: END IF;
4277: END IF;
4278:
4279: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'For Lane'|| FTE_TL_CACHE.g_tl_trip_rows(i).lane_id||
4280: ' Schedule :'||FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id);
4281:
4282: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Estimate:'||x_lane_sched_base_rows(j)||
4283: ':'||x_lane_sched_acc_rows(j)||':'||x_lane_sched_curr_rows(j));
4284:

Line 4285: i:=FTE_TL_CACHE.g_tl_trip_rows.NEXT(i);

4281:
4282: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Estimate:'||x_lane_sched_base_rows(j)||
4283: ':'||x_lane_sched_acc_rows(j)||':'||x_lane_sched_curr_rows(j));
4284:
4285: i:=FTE_TL_CACHE.g_tl_trip_rows.NEXT(i);
4286: END IF;
4287: j:=p_lane_rows.NEXT(j);
4288: END LOOP;
4289:

Line 4450: x_source_header_rates_tab(m).consolidation_id := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).trip_id;

4446:
4447: l_converted_amount:=p_lane_sched_sum_rows(i);
4448: END IF;
4449:
4450: x_source_header_rates_tab(m).consolidation_id := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).trip_id;
4451:
4452: x_source_header_rates_tab(m).lane_id := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).lane_id;
4453: x_source_header_rates_tab(m).carrier_id := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).carrier_id;
4454: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-12');

Line 4452: x_source_header_rates_tab(m).lane_id := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).lane_id;

4448: END IF;
4449:
4450: x_source_header_rates_tab(m).consolidation_id := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).trip_id;
4451:
4452: x_source_header_rates_tab(m).lane_id := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).lane_id;
4453: x_source_header_rates_tab(m).carrier_id := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).carrier_id;
4454: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-12');
4455: x_source_header_rates_tab(m).carrier_freight_code := p_lane_info_tab(p_ref_rows(i)).carrier_freight_code;
4456: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-13');

Line 4453: x_source_header_rates_tab(m).carrier_id := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).carrier_id;

4449:
4450: x_source_header_rates_tab(m).consolidation_id := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).trip_id;
4451:
4452: x_source_header_rates_tab(m).lane_id := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).lane_id;
4453: x_source_header_rates_tab(m).carrier_id := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).carrier_id;
4454: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-12');
4455: x_source_header_rates_tab(m).carrier_freight_code := p_lane_info_tab(p_ref_rows(i)).carrier_freight_code;
4456: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-13');
4457: x_source_header_rates_tab(m).service_level := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).service_type;

Line 4457: x_source_header_rates_tab(m).service_level := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).service_type;

4453: x_source_header_rates_tab(m).carrier_id := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).carrier_id;
4454: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-12');
4455: x_source_header_rates_tab(m).carrier_freight_code := p_lane_info_tab(p_ref_rows(i)).carrier_freight_code;
4456: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-13');
4457: x_source_header_rates_tab(m).service_level := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).service_type;
4458: x_source_header_rates_tab(m).mode_of_transport := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).mode_of_transport;
4459: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-14');
4460: x_source_header_rates_tab(m).ship_method_code := p_lane_info_tab(p_ref_rows(i)).ship_method_code;
4461: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-15');

Line 4458: x_source_header_rates_tab(m).mode_of_transport := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).mode_of_transport;

4454: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-12');
4455: x_source_header_rates_tab(m).carrier_freight_code := p_lane_info_tab(p_ref_rows(i)).carrier_freight_code;
4456: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-13');
4457: x_source_header_rates_tab(m).service_level := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).service_type;
4458: x_source_header_rates_tab(m).mode_of_transport := FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).mode_of_transport;
4459: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-14');
4460: x_source_header_rates_tab(m).ship_method_code := p_lane_info_tab(p_ref_rows(i)).ship_method_code;
4461: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-15');
4462: x_source_header_rates_tab(m).cost_type_id := NULL;

Line 4471: x_source_header_rates_tab(m).vehicle_type_id:=FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).vehicle_type;

4467: x_source_header_rates_tab(m).transit_time := p_lane_info_tab(p_ref_rows(i)).transit_time;
4468: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-17');
4469: x_source_header_rates_tab(m).transit_time_uom := p_lane_info_tab(p_ref_rows(i)).transit_time_uom;
4470: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-18');
4471: x_source_header_rates_tab(m).vehicle_type_id:=FTE_TL_CACHE.g_tl_trip_rows(p_summary_cache_ref(i)).vehicle_type;
4472: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'DBG-19');
4473: x_source_header_rates_tab(m).first_line_index := j;
4474:
4475:

Line 5022: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;

5018: l_output_tab FTE_FREIGHT_PRICING.Freight_Cost_Temp_Tab_Type;
5019: i NUMBER;
5020: l_request_id NUMBER;
5021: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
5022: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
5023: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
5024:
5025: l_lane_sched_sum_rows dbms_utility.number_array;
5026: l_lane_sched_curr_rows dbms_utility.name_array;

Line 5023: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;

5019: i NUMBER;
5020: l_request_id NUMBER;
5021: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
5022: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
5023: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
5024:
5025: l_lane_sched_sum_rows dbms_utility.number_array;
5026: l_lane_sched_curr_rows dbms_utility.name_array;
5027: l_filtered_rows dbms_utility.number_array;

Line 5047: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);

5043:
5044: --No freight term/manifesting issues
5045:
5046:
5047: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
5048:
5049: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5050: THEN
5051: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING

Line 5087: FTE_TL_CACHE.TL_BUILD_CACHE_FOR_OM(

5083: END IF;
5084:
5085:
5086:
5087: FTE_TL_CACHE.TL_BUILD_CACHE_FOR_OM(
5088: p_source_header_rec=>p_source_header_rec,
5089: p_source_lines_tab=>p_source_lines_tab,
5090: p_lane_rows=>l_exploded_lane_rows,
5091: p_schedule_rows=>l_exploded_schedule_rows,

Line 5105: FTE_TL_CACHE.Display_Cache;

5101: raise FTE_FREIGHT_PRICING_UTIL.g_tl_bld_cache_om_fail;
5102: END IF;
5103: END IF;
5104:
5105: FTE_TL_CACHE.Display_Cache;
5106:
5107:
5108: IF(FTE_TL_CACHE.g_tl_trip_rows.FIRST IS NOT NULL)
5109: THEN

Line 5108: IF(FTE_TL_CACHE.g_tl_trip_rows.FIRST IS NOT NULL)

5104:
5105: FTE_TL_CACHE.Display_Cache;
5106:
5107:
5108: IF(FTE_TL_CACHE.g_tl_trip_rows.FIRST IS NOT NULL)
5109: THEN
5110:
5111: TL_Rate_Cached_Trip_Multiple (
5112: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,

Line 5112: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,

5108: IF(FTE_TL_CACHE.g_tl_trip_rows.FIRST IS NOT NULL)
5109: THEN
5110:
5111: TL_Rate_Cached_Trip_Multiple (
5112: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
5113: p_end_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.LAST,
5114: p_output_type =>'P',
5115: p_request_id =>1,
5116: p_allocate_flag=>'Y',

Line 5113: p_end_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.LAST,

5109: THEN
5110:
5111: TL_Rate_Cached_Trip_Multiple (
5112: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
5113: p_end_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.LAST,
5114: p_output_type =>'P',
5115: p_request_id =>1,
5116: p_allocate_flag=>'Y',
5117: x_lane_sched_sum_rows=>l_lane_sched_sum_rows,

Line 5139: p_start_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.FIRST,

5135: Populate_Summary_Rates(
5136: p_lane_rows=>l_exploded_lane_rows,
5137: p_schedule_rows=>l_exploded_schedule_rows,
5138: p_vehicle_rows=>l_exploded_vehicle_rows,
5139: p_start_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
5140: p_end_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.LAST,
5141: p_exceptions_tab=>l_exceptions_tab,
5142: x_lane_sched_sum_rows=>l_lane_sched_sum_rows,
5143: x_lane_sched_curr_rows=>l_lane_sched_curr_rows,

Line 5140: p_end_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.LAST,

5136: p_lane_rows=>l_exploded_lane_rows,
5137: p_schedule_rows=>l_exploded_schedule_rows,
5138: p_vehicle_rows=>l_exploded_vehicle_rows,
5139: p_start_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
5140: p_end_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.LAST,
5141: p_exceptions_tab=>l_exceptions_tab,
5142: x_lane_sched_sum_rows=>l_lane_sched_sum_rows,
5143: x_lane_sched_curr_rows=>l_lane_sched_curr_rows,
5144: x_summary_cache_ref=>l_summary_cache_ref,

Line 5180: --IF (FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id IS NOT NULL)

5176: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_ERR,'Rate cached trip failed for trip index:'||i);
5177: --Add warning message
5178: l_warning_count:=l_warning_count+1;
5179:
5180: --IF (FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id IS NOT NULL)
5181: --THEN
5182:
5183: -- FTE_FREIGHT_PRICING_UTIL.setmsg (
5184: -- p_api=>'TL_OM_Rating',

Line 5188: -- p_schedule_id=>FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id);

5184: -- p_api=>'TL_OM_Rating',
5185: -- p_exc=>'g_tl_trip_cmp_rate_schd_fail',
5186: -- p_msg_type=>'W',
5187: -- p_trip_id=> p_wsh_trip_id,
5188: -- p_schedule_id=>FTE_TL_CACHE.g_tl_trip_rows(i).schedule_id);
5189:
5190:
5191: --ELSE
5192:

Line 5198: -- p_lane_id=>FTE_TL_CACHE.g_tl_trip_rows(i).lane_id);

5194: -- p_api=>'TL_OM_Rating',
5195: -- p_exc=>'g_tl_trip_cmp_rate_lane_fail',
5196: -- p_msg_type=>'W',
5197: -- p_trip_id=> p_wsh_trip_id,
5198: -- p_lane_id=>FTE_TL_CACHE.g_tl_trip_rows(i).lane_id);
5199:
5200: --END IF;
5201:
5202:

Line 5249: p_start_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.FIRST,

5245:
5246: END LOOP;
5247:
5248: Populate_OM_Rates(
5249: p_start_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
5250: p_end_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.LAST,
5251: p_lane_info_tab=>p_lane_info_tab,
5252: p_output_cost_tab=>l_output_tab,
5253: p_source_header_rec=>p_source_header_rec,

Line 5250: p_end_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.LAST,

5246: END LOOP;
5247:
5248: Populate_OM_Rates(
5249: p_start_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
5250: p_end_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.LAST,
5251: p_lane_info_tab=>p_lane_info_tab,
5252: p_output_cost_tab=>l_output_tab,
5253: p_source_header_rec=>p_source_header_rec,
5254: p_source_lines_tab=>p_source_lines_tab,

Line 5340: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type ,

5336: PROCEDURE BEGIN_LCSS (
5337: p_trip_id IN NUMBER,
5338: p_lane_rows IN dbms_utility.number_array ,
5339: x_trip_index OUT NOCOPY NUMBER,
5340: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type ,
5341: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
5342: x_total_cost OUT NOCOPY NUMBER,
5343: x_currency OUT NOCOPY VARCHAR2,
5344: x_vehicle_type OUT NOCOPY NUMBER,

Line 5341: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,

5337: p_trip_id IN NUMBER,
5338: p_lane_rows IN dbms_utility.number_array ,
5339: x_trip_index OUT NOCOPY NUMBER,
5340: x_trip_charges_rec OUT NOCOPY FTE_TL_CACHE.TL_trip_output_rec_type ,
5341: x_stop_charges_tab OUT NOCOPY FTE_TL_CACHE.TL_trip_stop_output_tab_type,
5342: x_total_cost OUT NOCOPY NUMBER,
5343: x_currency OUT NOCOPY VARCHAR2,
5344: x_vehicle_type OUT NOCOPY NUMBER,
5345: x_lane_ref OUT NOCOPY NUMBER,

Line 5363: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;

5359: l_exceptions_tab FTE_TL_CORE.tl_exceptions_tab_type;
5360: l_lane_sched_sum_rows dbms_utility.number_array;
5361: l_lane_sched_curr_rows dbms_utility.name_array;
5362: l_filtered_rows dbms_utility.number_array;
5363: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
5364: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
5365: l_least_index NUMBER;
5366: l_summary_cache_ref dbms_utility.number_array;
5367: l_least_cache_index NUMBER;

Line 5364: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;

5360: l_lane_sched_sum_rows dbms_utility.number_array;
5361: l_lane_sched_curr_rows dbms_utility.name_array;
5362: l_filtered_rows dbms_utility.number_array;
5363: l_trip_charges_tab FTE_TL_CACHE.TL_trip_output_tab_type;
5364: l_stop_charges_tab FTE_TL_CACHE.TL_trip_stop_output_tab_type;
5365: l_least_index NUMBER;
5366: l_summary_cache_ref dbms_utility.number_array;
5367: l_least_cache_index NUMBER;
5368:

Line 5412: FTE_TL_CACHE.TL_BUILD_CACHE_FOR_LCS(

5408: END IF;
5409:
5410:
5411:
5412: FTE_TL_CACHE.TL_BUILD_CACHE_FOR_LCS(
5413: p_wsh_trip_id => p_trip_id,
5414: p_lane_rows => l_exploded_lane_rows,
5415: p_schedule_rows =>l_exploded_schedule_rows,
5416: p_vehicle_rows=>l_exploded_vehicle_rows,

Line 5431: FTE_TL_CACHE.DISPLAY_CACHE();

5427:
5428:
5429:
5430:
5431: FTE_TL_CACHE.DISPLAY_CACHE();
5432:
5433: IF (FTE_TL_CACHE.g_tl_trip_rows.FIRST IS NOT NULL)
5434: THEN
5435:

Line 5433: IF (FTE_TL_CACHE.g_tl_trip_rows.FIRST IS NOT NULL)

5429:
5430:
5431: FTE_TL_CACHE.DISPLAY_CACHE();
5432:
5433: IF (FTE_TL_CACHE.g_tl_trip_rows.FIRST IS NOT NULL)
5434: THEN
5435:
5436: TL_Rate_Cached_Trip_Multiple (
5437: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,

Line 5437: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,

5433: IF (FTE_TL_CACHE.g_tl_trip_rows.FIRST IS NOT NULL)
5434: THEN
5435:
5436: TL_Rate_Cached_Trip_Multiple (
5437: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
5438: p_end_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.LAST,
5439: p_output_type =>'P',
5440: p_request_id =>NULL,
5441: p_allocate_flag=>'N',

Line 5438: p_end_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.LAST,

5434: THEN
5435:
5436: TL_Rate_Cached_Trip_Multiple (
5437: p_start_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
5438: p_end_trip_index =>FTE_TL_CACHE.g_tl_trip_rows.LAST,
5439: p_output_type =>'P',
5440: p_request_id =>NULL,
5441: p_allocate_flag=>'N',
5442: x_lane_sched_sum_rows=>l_lane_sched_sum_rows,

Line 5463: p_start_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.FIRST,

5459: Populate_Summary_Rates(
5460: p_lane_rows=>l_exploded_lane_rows,
5461: p_schedule_rows=>l_exploded_schedule_rows,
5462: p_vehicle_rows=>l_exploded_vehicle_rows,
5463: p_start_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
5464: p_end_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.LAST,
5465: p_exceptions_tab=>l_exceptions_tab,
5466: x_lane_sched_sum_rows=>l_lane_sched_sum_rows,
5467: x_lane_sched_curr_rows=>l_lane_sched_curr_rows,

Line 5464: p_end_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.LAST,

5460: p_lane_rows=>l_exploded_lane_rows,
5461: p_schedule_rows=>l_exploded_schedule_rows,
5462: p_vehicle_rows=>l_exploded_vehicle_rows,
5463: p_start_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.FIRST,
5464: p_end_trip_index=>FTE_TL_CACHE.g_tl_trip_rows.LAST,
5465: p_exceptions_tab=>l_exceptions_tab,
5466: x_lane_sched_sum_rows=>l_lane_sched_sum_rows,
5467: x_lane_sched_curr_rows=>l_lane_sched_curr_rows,
5468: x_summary_cache_ref=>l_summary_cache_ref,

Line 5535: WHILE((FTE_TL_CACHE.g_tl_trip_rows(x_trip_index).number_of_stops > 0) AND

5531: x_stop_charges_tab.delete;
5532:
5533: i:=x_trip_charges_rec.stop_charge_reference;
5534: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'DBG-5');
5535: WHILE((FTE_TL_CACHE.g_tl_trip_rows(x_trip_index).number_of_stops > 0) AND
5536: (i<(FTE_TL_CACHE.g_tl_trip_rows(x_trip_index).number_of_stops+x_trip_charges_rec.stop_charge_reference)))
5537: LOOP
5538: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'DBG-6');
5539: x_stop_charges_tab(i):=l_stop_charges_tab(i);

Line 5536: (i<(FTE_TL_CACHE.g_tl_trip_rows(x_trip_index).number_of_stops+x_trip_charges_rec.stop_charge_reference)))

5532:
5533: i:=x_trip_charges_rec.stop_charge_reference;
5534: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'DBG-5');
5535: WHILE((FTE_TL_CACHE.g_tl_trip_rows(x_trip_index).number_of_stops > 0) AND
5536: (i<(FTE_TL_CACHE.g_tl_trip_rows(x_trip_index).number_of_stops+x_trip_charges_rec.stop_charge_reference)))
5537: LOOP
5538: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'DBG-6');
5539: x_stop_charges_tab(i):=l_stop_charges_tab(i);
5540: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'DBG-7');

Line 5599: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type ,

5595:
5596:
5597: PROCEDURE END_LCSS (
5598: p_trip_index IN NUMBER,
5599: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type ,
5600: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type,
5601: x_return_status OUT NOCOPY VARCHAR2)
5602: IS
5603:

Line 5600: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type,

5596:
5597: PROCEDURE END_LCSS (
5598: p_trip_index IN NUMBER,
5599: p_trip_charges_rec IN FTE_TL_CACHE.TL_trip_output_rec_type ,
5600: p_stop_charges_tab IN FTE_TL_CACHE.TL_trip_stop_output_tab_type,
5601: x_return_status OUT NOCOPY VARCHAR2)
5602: IS
5603:
5604:

Line 5658: p_trip_id=>FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id,

5654: END IF;
5655:
5656:
5657: Update_Pricing_Required_Flag(
5658: p_trip_id=>FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id,
5659: x_return_status =>l_return_status);
5660:
5661: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5662: THEN

Line 5666: 'Failied to set reprice required flag for TRIP ID:'||FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id);

5662: THEN
5663: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5664: THEN
5665: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,
5666: 'Failied to set reprice required flag for TRIP ID:'||FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id);
5667: END IF;
5668: END IF;
5669:
5670:

Line 5671: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);

5667: END IF;
5668: END IF;
5669:
5670:
5671: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
5672: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5673: THEN
5674: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
5675: THEN

Line 5732: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);

5728: FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'ABORT_LCSS','start');
5729:
5730: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5731:
5732: FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
5733:
5734: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
5735: THEN
5736: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING