[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_Distance_To_Next_Stop(
p_trip_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2)
IS
CURSOR get_trip_stops(c_trip_id IN NUMBER) IS
SELECT s.stop_id
FROM WSH_TRIP_STOPS s
WHERE s.trip_id=c_trip_id
ORDER BY s.stop_sequence_number;
FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Update_Distance_To_Next_Stop','start');
UPDATE wsh_trip_stops
SET distance_to_next_stop = l_distances(i),
distance_uom = l_distance_uom
WHERE stop_id = l_stop_ids(i);
FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Update_Distance_To_Next_Stop:'||p_trip_id||' has more than 2 stops');
FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Update_Distance_To_Next_Stop');
FTE_FREIGHT_PRICING_UTIL.set_exception('Update_Distance_To_Next_Stop',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_fpa_get_trip_inf_fail');
FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Update_Distance_To_Next_Stop');
FTE_FREIGHT_PRICING_UTIL.set_exception('Update_Distance_To_Next_Stop',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Update_Distance_To_Next_Stop');
END Update_Distance_To_Next_Stop;
SELECT c.default_vehicle_type_id
FROM WSH_CARRIER_SERVICES c ,
FTE_LANES l
WHERE c.carrier_id=l.carrier_id and
c.service_level=l.service_type_code and
l.lane_id=c_lane_id;
SELECT c.default_vehicle_type_id
FROM WSH_CARRIER_SERVICES c ,
FTE_LANES l,
FTE_SCHEDULES s
WHERE c.carrier_id=l.carrier_id and
c.service_level=l.service_type_code and
s.schedules_id=c_schedule_id and
s.lane_id=l.lane_id;
SELECT wcvt.vehicle_type_id,
l.carrier_id
FROM wsh_carrier_vehicle_types wcvt,
fte_lanes l
WHERE l.lane_id=c_lane_id
and l.carrier_id=wcvt.carrier_id
and wcvt.assigned_flag='Y';
SELECT wcvt.vehicle_type_id,
l.carrier_id
FROM wsh_carrier_vehicle_types wcvt,
fte_lanes l ,
fte_schedules s
WHERE s.schedules_id=c_schedule_id
and l.lane_id=s.lane_id
and l.carrier_id=wcvt.carrier_id
and wcvt.assigned_flag='Y';
PROCEDURE Update_Pricing_Required_Flag(
p_trip_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2) IS
CURSOR lock_dlegs( c_trip_id IN NUMBER ) IS
SELECT dl.reprice_required
FROM wsh_delivery_legs dl ,
wsh_trip_stops s
WHERE dl.pick_up_stop_id = s.stop_id
and s.trip_id=c_trip_id
FOR UPDATE NOWAIT;
FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Update_Pricing_Required_Flag','start');
SAVEPOINT Update_Pricing_Required_Flag;
UPDATE wsh_delivery_legs dl
SET dl.reprice_required='N'
WHERE dl.pick_up_stop_id IN
(select s.stop_id FROM wsh_trip_stops s where
s.trip_id=p_trip_id );
FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Update_Pricing_Required_Flag');
ROLLBACK TO Update_Pricing_Required_Flag;
FTE_FREIGHT_PRICING_UTIL.set_exception('Update_Pricing_Required_Flag',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Update_Pricing_Required_Flag');
END Update_Pricing_Required_Flag;
SELECT count(wd.delivery_id)
FROM wsh_new_deliveries wd, wsh_global_parameters wgp
WHERE (
((wd.shipment_direction in ('I'))
and (wgp.rate_ib_dels_fgt_term is not null)
and (wd.freight_terms_code is not null)
and (wgp.rate_ib_dels_fgt_term <> wd.freight_terms_code)
)
OR
((wd.shipment_direction in ('D'))
and (wgp.rate_ds_dels_fgt_term_id is not null)
and (wd.freight_terms_code is not null)
and (wgp.rate_ds_dels_fgt_term_id <> wd.freight_terms_code)
)
OR
((nvl(wd.shipment_direction,'O') in ('O','IO'))
and (wgp.skip_rate_ob_dels_fgt_term is not null)
and (wd.freight_terms_code is not null)
and (wgp.skip_rate_ob_dels_fgt_term = wd.freight_terms_code)
)
)
AND wd.delivery_id in
(SELECT wdl.delivery_id
FROM wsh_delivery_legs wdl,
wsh_trip_stops wts1,
wsh_trip_stops wts2
WHERE wts1.trip_id = c_trip_id
AND wts2.trip_id = c_trip_id
AND wts1.stop_id = wdl.pick_up_stop_id
AND wts2.stop_id = wdl.drop_off_stop_id
);
SELECT count(a.delivery_id)
FROM wsh_new_deliveries a,
mtl_parameters b,
wsh_carriers c
WHERE a.organization_id = b.organization_id
AND a.carrier_id = c.carrier_id
AND c.manifesting_enabled_flag = 'Y'
AND b.carrier_manifesting_flag = 'Y'
AND a.delivery_id in
(SELECT wdl.delivery_id
FROM wsh_delivery_legs wdl,
wsh_trip_stops wts1,
wsh_trip_stops wts2
WHERE wts1.trip_id = c_trip_id
AND wts2.trip_id = c_trip_id
AND wts1.stop_id = wdl.pick_up_stop_id
AND wts2.stop_id = wdl.drop_off_stop_id
);
SELECT count(wd.delivery_id)
FROM wsh_new_deliveries wd, wsh_global_parameters wgp
WHERE (
((wd.shipment_direction in ('I'))
and (wgp.rate_ib_dels_fgt_term is not null)
and (wd.freight_terms_code is not null)
and (wgp.rate_ib_dels_fgt_term <> wd.freight_terms_code)
)
OR
((wd.shipment_direction in ('D'))
and (wgp.rate_ds_dels_fgt_term_id is not null)
and (wd.freight_terms_code is not null)
and (wgp.rate_ds_dels_fgt_term_id <> wd.freight_terms_code)
)
OR
((nvl(wd.shipment_direction,'O') in ('O','IO'))
and (wgp.skip_rate_ob_dels_fgt_term is not null)
and (wd.freight_terms_code is not null)
and (wgp.skip_rate_ob_dels_fgt_term = wd.freight_terms_code)
)
)
AND wd.delivery_id in
(SELECT wdl.delivery_id
FROM wsh_delivery_legs wdl,
wsh_trip_stops wts1,
wsh_trip_stops wts2
WHERE wts1.trip_id IN (SELECT m.trip_id from fte_trip_moves m where m.move_id= c_move_id)
AND wts2.trip_id = wts1.trip_id
AND wts1.stop_id = wdl.pick_up_stop_id
AND wts2.stop_id = wdl.drop_off_stop_id
);
SELECT count(a.delivery_id)
FROM wsh_new_deliveries a,
mtl_parameters b,
wsh_carriers c
WHERE a.organization_id = b.organization_id
AND a.carrier_id = c.carrier_id
AND c.manifesting_enabled_flag = 'Y'
AND b.carrier_manifesting_flag = 'Y'
AND a.delivery_id in
(SELECT wdl.delivery_id
FROM wsh_delivery_legs wdl,
wsh_trip_stops wts1,
wsh_trip_stops wts2
WHERE wts1.trip_id IN (SELECT m.trip_id from fte_trip_moves m where m.move_id=c_move_id)
AND wts2.trip_id = wts1.trip_id
AND wts1.stop_id = wdl.pick_up_stop_id
AND wts2.stop_id = wdl.drop_off_stop_id
);
SELECT *
FROM FTE_FREIGHT_COSTS_TEMP fct
WHERE ( fct.comparison_request_id = c_request_id)
AND ((fct.lane_id = c_lane_id) OR (fct.schedule_id= c_schedule_id))
AND (fct.vehicle_type_id = c_vehicle_type_id)
AND(fct.CHARGE_SOURCE_CODE='PRICING_ENGINE')
FOR UPDATE NOWAIT;
l_freight_rec.last_update_date:= l_temp_rec.last_update_date;
l_freight_rec.last_updated_by:=l_temp_rec.last_updated_by;
l_freight_rec.last_update_login:= l_temp_rec.last_update_login;
l_freight_rec.program_update_date:= l_temp_rec.program_update_date;
WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
p_rowid => l_rowid,
p_freight_cost_info => l_freight_rec,
x_return_status => l_return_status);
FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'Update_Freight_Cost');
raise FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed;
FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,'Update_Freight_Cost returned warning ');
Update_Pricing_Required_Flag(
p_trip_id=>p_trip_id,
x_return_status =>l_return_status);
DELETE
FROM FTE_FREIGHT_COSTS_TEMP fct
WHERE ( fct.comparison_request_id = p_comparison_request_id)
AND ((fct.lane_id = p_lane_id) OR (fct.schedule_id= p_schedule_id))
AND(fct.CHARGE_SOURCE_CODE='PRICING_ENGINE');
WHEN FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed THEN
ROLLBACK TO Move_Records_To_Main;
FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_update_freight_cost_failed');
SELECT fct.trip_id
FROM FTE_FREIGHT_COSTS_TEMP fct
WHERE ( fct.comparison_request_id = c_request_id)
AND ((fct.lane_id = c_lane_id) OR (fct.schedule_id= c_schedule_id))
AND (fct.vehicle_type_id = c_vehicle_type_id)
AND(fct.CHARGE_SOURCE_CODE='PRICING_ENGINE')
AND (fct.trip_id IS NOT NULL)
AND ( fct.trip_id = c_fake_trip_id)
AND ROWNUM=1;
SELECT dl.delivery_id,
s.trip_id,
dl.pick_up_stop_id,
dl.drop_off_stop_id
FROM wsh_delivery_legs dl,
wsh_trip_stops s
WHERE dl.drop_off_stop_id = s.stop_id and
dl.delivery_leg_id=c_dleg_id;
SELECT *
FROM FTE_FREIGHT_COSTS_TEMP fct
WHERE ( fct.comparison_request_id = c_request_id)
AND ((fct.lane_id = c_lane_id) OR (fct.schedule_id= c_schedule_id))
AND (fct.vehicle_type_id = c_vehicle_type_id)
AND(fct.CHARGE_SOURCE_CODE='PRICING_ENGINE')
FOR UPDATE NOWAIT;
l_freight_rec.last_update_date:= l_temp_rec.last_update_date;
l_freight_rec.last_updated_by:=l_temp_rec.last_updated_by;
l_freight_rec.last_update_login:= l_temp_rec.last_update_login;
l_freight_rec.program_update_date:= l_temp_rec.program_update_date;
WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
p_rowid => l_rowid,
p_freight_cost_info => l_freight_rec,
x_return_status => l_return_status);
FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'Update_Freight_Cost');
raise FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed;
FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_WRN,'Update_Freight_Cost returned warning ');
Update_Pricing_Required_Flag(
p_trip_id=>l_trip_id,
x_return_status =>l_return_status);
---Delete fc temp record
FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'>>7');
DELETE
FROM FTE_FREIGHT_COSTS_TEMP fct
WHERE ( fct.comparison_request_id = p_comparison_request_id)
AND ((fct.lane_id = p_lane_id) OR (fct.schedule_id= p_schedule_id))
AND(fct.CHARGE_SOURCE_CODE='PRICING_ENGINE');
Update_Distance_To_Next_Stop(
p_trip_id =>l_trip_id,
x_return_status=>l_return_status);
'Failied to update stop distances for :'||l_trip_id);
raise FTE_FREIGHT_PRICING_UTIL.g_tl_update_dist_stop_fail;
WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_update_dist_stop_fail THEN
ROLLBACK TO Move_Dlv_Records_To_Main;
FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Dlv_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_update_dist_stop_fail');
WHEN FTE_FREIGHT_PRICING_UTIL.g_update_freight_cost_failed THEN
ROLLBACK TO Move_Dlv_Records_To_Main;
FTE_FREIGHT_PRICING_UTIL.set_exception('Move_Dlv_Records_To_Main',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_update_freight_cost_failed');
PROCEDURE Delete_Main_Records(
p_trip_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2) IS
CURSOR lock_trip_recs(c_trip_id IN NUMBER ) IS
SELECT wfc.freight_cost_id
FROM wsh_freight_costs wfc
WHERE wfc.trip_id = c_trip_id
and wfc.charge_source_code='PRICING_ENGINE'
FOR UPDATE NOWAIT;
SELECT s.stop_id
FROM wsh_trip_stops s
WHERE s.trip_id= c_trip_id;
SELECT wfc.freight_cost_id
FROM wsh_freight_costs wfc
WHERE wfc.stop_id =c_stop_id
and wfc.charge_source_code='PRICING_ENGINE'
FOR UPDATE OF wfc.freight_cost_id NOWAIT;
SELECT dl.delivery_leg_id FROM wsh_delivery_legs dl , wsh_trip_stops s
WHERE dl.pick_up_stop_id=s.stop_id and s.trip_id=p_trip_id;
SELECT wfc.freight_cost_id
FROM wsh_freight_costs wfc,
wsh_delivery_legs dl ,
wsh_trip_stops s
WHERE wfc.delivery_leg_id = dl.delivery_leg_id
and dl.pick_up_stop_id=s.stop_id
and s.trip_id=c_trip_id
and wfc.charge_source_code='PRICING_ENGINE'
-- and wfc.delivery_detail_id is not null
FOR UPDATE OF wfc.freight_cost_id NOWAIT;
FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Delete_Main_Records','start');
SAVEPOINT Delete_Main_Records;
--Delete trip level records
IF (l_wfc_trip_ids.FIRST IS NOT NULL)
THEN
FORALL i IN l_wfc_trip_ids.FIRST..l_wfc_trip_ids.LAST
DELETE
FROM wsh_freight_costs wfc
WHERE wfc.freight_cost_id = l_wfc_trip_ids(i);
l_wfc_stop_ids.delete;
l_wfc_temp_stop_ids.delete;
DELETE
FROM wsh_freight_costs wfc
WHERE wfc.freight_cost_id = l_wfc_stop_ids(i) ;
--Delete detail level records
FORALL i IN l_wfc_detail_ids.FIRST..l_wfc_detail_ids.LAST
DELETE
FROM wsh_freight_costs wfc
WHERE wfc.freight_cost_id = l_wfc_detail_ids(i)
and wfc.delivery_detail_id is not null;
UPDATE wsh_freight_costs wfc
set wfc.unit_amount=null,
wfc.total_amount=null,
wfc.currency_code=null
WHERE wfc.freight_cost_id = l_wfc_detail_ids(i)
and wfc.line_type_code='SUMMARY'
and wfc.delivery_detail_id is null;
FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Delete_Main_Records');
ROLLBACK TO Delete_Main_Records;
FTE_FREIGHT_PRICING_UTIL.set_exception('Delete_Main_Records',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Delete_Main_Records');
END Delete_Main_Records;
SELECT dl.delivery_leg_id
FROM wsh_delivery_legs dl ,
wsh_trip_stops s
WHERE dl.pick_up_stop_id = s.stop_id
and s.trip_id=c_trip_id
and ( NVL(dl.reprice_required,'Y') = 'Y');
SELECT dl.delivery_leg_id
FROM wsh_delivery_legs dl ,
wsh_trip_stops s
WHERE
s.trip_id IN (
SELECT m.trip_id from fte_trip_moves m where m.move_id=c_move_id
)
and dl.pick_up_stop_id = s.stop_id
and ( NVL(dl.reprice_required,'Y') = 'Y');
l_stop_charges_tab.DELETE;
Delete_Main_Records(
p_trip_id=>l_trip_charges_rec.trip_id,
x_return_status=>l_return_status);
raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail;
Update_Pricing_Required_Flag(
p_trip_id=>l_trip_charges_rec.trip_id,
x_return_status =>l_return_status);
l_stop_charges_tab.DELETE;
WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail THEN
x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Discount_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_main_rec_fail');
l_stop_charges_tab.DELETE;
Delete_Main_Records(
p_trip_id=>l_trip_charges_rec.trip_id,
x_return_status=>l_return_status);
raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail;
Update_Pricing_Required_Flag(
p_trip_id=>l_trip_charges_rec.trip_id,
x_return_status =>l_return_status);
l_stop_charges_tab.DELETE;
WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail THEN
x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
FTE_FREIGHT_PRICING_UTIL.set_exception('Handle_CM_Rate_Variant',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_main_rec_fail');
l_exceptions_tab.delete;
l_stop_charges_one_trip_tab.delete;
SELECT tm.move_id
FROM FTE_TRIP_MOVES tm
WHERE tm.trip_id=c_trip_id;
FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
Delete_Main_Records(
p_trip_id => p_trip_id,
x_return_status =>l_return_status);
raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail;
Update_Pricing_Required_Flag(
p_trip_id=>p_trip_id,
x_return_status =>l_return_status);
WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail THEN
ROLLBACK TO TL_Rate_Trip;
FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail THEN
ROLLBACK TO TL_Rate_Trip;
FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Rate_Trip',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_main_rec_fail');
x_lane_sched_sum_rows.DELETE;
x_lane_sched_curr_rows.DELETE;
SELECT fte_pricing_comp_request_s.nextval
FROM sys.dual;
SELECT ffct.total_amount, ffct.currency_code
FROM fte_freight_costs_temp ffct, wsh_freight_cost_types wfct
WHERE ffct.freight_cost_type_id = wfct.freight_cost_type_id
AND wfct.name='SUMMARY'
AND ffct.trip_id = c_trip_id
AND ffct.comparison_request_id = c_request_id
AND nvl(lane_id,-1) = nvl(c_lane_id,-1)
AND nvl(schedule_id, -1) = nvl(c_schedule_id,-1);
FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail THEN
x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Trip_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
SELECT fte_pricing_comp_request_s.nextval
FROM sys.dual;
SELECT ffct.total_amount, ffct.currency_code
FROM fte_freight_costs_temp ffct, wsh_freight_cost_types wfct
WHERE ffct.freight_cost_type_id = wfct.freight_cost_type_id
AND wfct.name='SUMMARY'
AND ffct.trip_id = c_trip_id
AND ffct.comparison_request_id = c_request_id
AND nvl(lane_id,-1) = nvl(c_lane_id,-1)
AND nvl(schedule_id, -1) = nvl(c_schedule_id,-1);
FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail THEN
x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
FTE_FREIGHT_PRICING_UTIL.set_exception('TL_Delivery_Price_Compare',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail THEN
x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
FTE_FREIGHT_PRICING_UTIL.set_exception('TL_FREIGHT_ESTIMATE',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
l_detail_records.DELETE;
l_detail_price.DELETE;
FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
l_vehicle_rows.delete;
WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail THEN
x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
FTE_FREIGHT_PRICING_UTIL.set_exception('TL_OM_Rating',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
x_stop_charges_tab.delete;
Update_Pricing_Required_Flag(
p_trip_id=>FTE_TL_CACHE.g_tl_trip_rows(p_trip_index).trip_id,
x_return_status =>l_return_status);
FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail THEN
x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
FTE_FREIGHT_PRICING_UTIL.set_exception('END_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');
FTE_TL_CACHE.Delete_Cache(x_return_status=>l_return_status);
raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail;
WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_cache_fail THEN
x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
FTE_FREIGHT_PRICING_UTIL.set_exception('ABORT_LCSS',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_cache_fail');