[Home] [Help]
PACKAGE: APPS.FTE_FREIGHT_PRICING_UTIL
Source
1 PACKAGE FTE_FREIGHT_PRICING_UTIL AUTHID CURRENT_USER as
5
2 /* $Header: FTEFRUTS.pls 120.0 2005/05/26 17:44:32 appldev noship $ */
3
4 -- Global Variables
6 g_package_name CONSTANT VARCHAR2(100) := 'FTE_FREIGHT_PRICING_UTIL';
7
8 -- Global Exception ---
9 G_NO_PARAMS_FOUND EXCEPTION; -- if parameter table is empty or required param is not available
10 G_INVALID_PARAM_VAL EXCEPTION; -- parameter has an invalid value
11
12 g_total_base_price_failed EXCEPTION;
13 g_apply_new_base_price_failed EXCEPTION;
14 g_create_attribute_failed EXCEPTION;
15 g_create_qual_record_failed EXCEPTION;
16 g_qp_insert_lines2_failed EXCEPTION;
17 g_qp_insert_line_attrs2_failed EXCEPTION;
18 g_qp_price_request_failed EXCEPTION;
19 g_invalid_pricing_event EXCEPTION;
20 g_not_on_pricelist EXCEPTION;
21 g_add_qp_output_detail_failed EXCEPTION;
22 g_get_qp_output_failed EXCEPTION;
23 g_clear_qp_input_failed EXCEPTION;
24 g_post_process_failed EXCEPTION;
25 g_remove_gaps_failed EXCEPTION;
26
27
28 g_load_rules_failed EXCEPTION;
29 -- g_no_params_found EXCEPTION;
30 g_total_shipment_weight_failed EXCEPTION;
31 g_create_control_record_failed EXCEPTION;
32 g_create_line_record_failed EXCEPTION;
33 g_create_qualifiers_failed EXCEPTION;
34 g_create_attr_failed EXCEPTION;
35 g_get_next_weight_break_failed EXCEPTION;
36
37 g_no_volume_found EXCEPTION;
38 g_no_weights_found EXCEPTION;
39 g_weight_uom_not_found EXCEPTION;
40 g_weight_break_not_found EXCEPTION;
41 g_def_wt_break_not_found EXCEPTION;
42 g_invalid_uom_conversion EXCEPTION;
43 g_invalid_uom_code EXCEPTION;
44 g_invalid_wt_break EXCEPTION;
45 g_param_validation_failed EXCEPTION;
46 g_analyse_deficit_failed EXCEPTION;
47 g_delete_set_failed EXCEPTION;
48 g_not_eligible_for_LTL EXCEPTION;
49 g_process_LTL_deficit_failed EXCEPTION;
50 g_resolve_pricing_objective EXCEPTION;
51 g_apply_min_charge EXCEPTION;
52 g_prepare_next_event_failed EXCEPTION;
53 g_parcel_not_eligible EXCEPTION;
54 g_get_bumped_up_wt_failed EXCEPTION;
55 -- g_prepare_next_event_failed EXCEPTION;
56 -- g_prepare_next_event_failed EXCEPTION;
57 g_process_LTL_failed EXCEPTION;
58 g_process_Parcel_failed EXCEPTION;
59 g_process_others_failed EXCEPTION;
60 g_calc_gross_wt_failed EXCEPTION;
61 g_prorate_failed EXCEPTION;
62 g_qp_price_request_failed_2 EXCEPTION;
63
64 g_no_currency_found EXCEPTION;
65 g_invalid_fc_type EXCEPTION;
66 g_no_lane_found EXCEPTION;
67 g_no_price_list_on_lane EXCEPTION;
68 g_no_party_id_found EXCEPTION;
69
70 g_proration_failed EXCEPTION;
71 g_delete_qpline_failed EXCEPTION;
72 g_prepare_fc_rec_failed EXCEPTION;
73 g_get_fc_type_failed EXCEPTION;
74 g_other_cont_summ_failed EXCEPTION;
75 g_dleg_sum_not_created EXCEPTION;
76 g_rollup_container_failed EXCEPTION;
77 g_invalid_line_quantity EXCEPTION;
78 g_category_not_found EXCEPTION;
79 g_invalid_basis EXCEPTION;
80 g_loose_item_wrong_basis EXCEPTION;
81 g_no_enginerow_created EXCEPTION;
82 g_initialize_failed EXCEPTION;
83 g_dimensional_weight_failed EXCEPTION;
84 g_create_instance_failed EXCEPTION;
85 g_search_instance_failed EXCEPTION;
86 g_add_to_instance_failed EXCEPTION;
87 g_no_lanesched_seg EXCEPTION;
88 g_no_lane_info EXCEPTION;
89 g_no_segment_service_type EXCEPTION;
90 g_shipment_pattern_failed EXCEPTION;
91 g_currency_code_failed EXCEPTION;
92 g_special_conditions_failed EXCEPTION;
93 g_process_qp_output_failed EXCEPTION;
94 g_create_fc_temp_failed EXCEPTION;
95 g_update_freight_cost_failed EXCEPTION;
96 g_create_freight_cost_failed EXCEPTION;
97 g_no_temp_fc_to_move EXCEPTION;
98 g_delete_fc_temp_failed EXCEPTION;
99 g_noleg_segment EXCEPTION;
100 g_flatten_shipment_failed EXCEPTION;
101 g_empty_delivery EXCEPTION;
102 g_shipment_pricing_failed EXCEPTION;
103 g_unmark_reprice_req_failed EXCEPTION;
104 g_delete_invalid_fc_failed EXCEPTION;
105 g_missing_service_type EXCEPTION;
106 g_no_input EXCEPTION;
107 g_price_consolidate_failed EXCEPTION;
108 g_pricing_not_required EXCEPTION;
109 g_delivery_not_found EXCEPTION;
110
111 g_invalid_parameters EXCEPTION;
112 g_ship_prc_compare_fail EXCEPTION;
113 g_unexp_err EXCEPTION;
114
115 g_freight_costs_int_fail EXCEPTION;
116 g_ln_no_lane_found EXCEPTION;
117 g_ln_too_many_found EXCEPTION;
118 g_lane_search_failed EXCEPTION;
119 g_no_ship_method EXCEPTION;
120 g_invalid_ship_method EXCEPTION;
121 g_get_cost_type_failed EXCEPTION;
122 g_tl_get_schedule_info_fail EXCEPTION;
123 g_get_trip_mode_fail EXCEPTION;
124 g_rank_list_update_fail EXCEPTION;
125
126
127 g_MDC_get_chld_fract_fail EXCEPTION;
128 g_MDC_Get_LPN_cost_rec_fail EXCEPTION;
129 g_MDC_alloc_from_consol_LPN EXCEPTION;
130 g_MDC_cre_parent_dleg_summ EXCEPTION;
131 g_MDC_cre_child_dleg_summ EXCEPTION;
132 g_MDC_populate_dleg_id EXCEPTION;
136
133 g_MDC_cre_LPN_summ EXCEPTION;
134 g_MDC_check_rated EXCEPTION;
135 g_MDC_handle_MDC EXCEPTION;
137
138 --FTE_TL_CACHE exceptions
139
140 g_tl_no_dleg_id_in_dtl EXCEPTION;
141 g_tl_weight_uom_conv_fail EXCEPTION;
142 g_tl_vol_uom_conv_fail EXCEPTION;
143 g_tl_no_carrier_or_service EXCEPTION;
144 g_tl_get_carrier_pref_fail EXCEPTION;
145 g_tl_get_car_from_sched_fail EXCEPTION;
146 g_tl_get_carr_from_lane_fail EXCEPTION;
147 g_tl_get_lane_info_fail EXCEPTION;
148 g_tl_trip_id_from_dleg_fail EXCEPTION;
149 g_tl_dates_loc_from_dlv_fail EXCEPTION;
150 g_tl_lane_info_with_id_fail EXCEPTION;
151 g_tl_get_trip_info_fail EXCEPTION;
152
153
154 g_tl_dist_uom_conv_fail EXCEPTION;
155 g_tl_no_lane_sched_veh EXCEPTION;
156 g_tl_no_lane_sched EXCEPTION;
157 g_tl_combine_carrier_fail EXCEPTION;
158 g_tl_validate_carrier_fail EXCEPTION;
159 g_tl_validate_trip_fail EXCEPTION;
160 g_tl_validate_stop_fail EXCEPTION;
161 g_tl_validate_dlv_dtl_fail EXCEPTION;
162 g_tl_add_dropoff_qty_fail EXCEPTION;
163 g_tl_insert_dlv_dtl_fail EXCEPTION;
164 g_tl_add_pickup_qty_fail EXCEPTION;
165 g_tl_validate_dleg_fail EXCEPTION;
166 g_tl_add_ip_dist_fail EXCEPTION;
167 g_tl_updt_trip_with_stop_fail EXCEPTION;
168 g_tl_get_distances_fail EXCEPTION;
169 g_tl_get_facility_info_fail EXCEPTION;
170 g_tl_init_dummy_dleg_fail EXCEPTION;
171 g_tl_init_dummy_trip_fail EXCEPTION;
172 g_tl_init_dummy_pu_stop_fail EXCEPTION;
173 g_tl_init_dummy_do_stop_fail EXCEPTION;
174 g_tl_add_dlv_dtl_fail EXCEPTION;
175 g_tl_get_car_prf_for_lane_fail EXCEPTION;
176 g_tl_updt_dummy_recs_fail EXCEPTION;
177 g_tl_get_trp_inf_frm_schd_fail EXCEPTION;
178 g_tl_get_trp_inf_frm_lane_fail EXCEPTION;
179 g_tl_get_car_prf_for_schd_fail EXCEPTION;
180 g_tl_cache_trip_fail EXCEPTION;
181 g_tl_cache_first_trp_lane_fail EXCEPTION;
182 g_tl_convert_uom_for_trip_fail EXCEPTION;
183 g_tl_convert_uom_for_stop_fail EXCEPTION;
184 g_tl_convert_uom_for_dleg_fail EXCEPTION;
185 g_tl_build_cache_trp_fail EXCEPTION;
186 g_tl_lane_info_with_sched_fail EXCEPTION;
187 g_tl_get_reg_for_loc_fail EXCEPTION;
188 g_tl_get_fac_info_fail EXCEPTION;
189 g_tl_init_cache_indices_fail EXCEPTION;
190 g_tl_delete_cache_fail EXCEPTION;
191 g_tl_no_trips_cached EXCEPTION;
192 g_tl_get_vehicle_type_fail EXCEPTION;
193
194
195 g_tl_time_uom_conv_fail EXCEPTION;
196 g_tl_get_dist_time_fail EXCEPTION;
197 g_tl_no_car_time_dist_uom EXCEPTION;
198 g_tl_no_time_dist_uom EXCEPTION;
199 g_tl_no_time_dist EXCEPTION;
200 g_tl_no_time_dist_for_stop EXCEPTION;
201 g_tl_no_time_dist_for_dleg EXCEPTION;
202 g_tl_no_time_dist_for_trip EXCEPTION;
203 g_tl_call_mileage_if_fail EXCEPTION;
204 g_tl_get_pricelistid_fail EXCEPTION;
205 g_tl_no_pallet_item_type EXCEPTION;
206 g_tl_replace_dleg_fail EXCEPTION;
207 g_tl_get_int_loc_fail EXCEPTION;
208 g_tl_copy_src_dtl_fail EXCEPTION;
209 g_tl_add_src_as_dtl_fail EXCEPTION;
210 g_tl_cache_first_om_lane_fail EXCEPTION;
211 g_tl_build_cache_lcss_fail EXCEPTION;
212 g_tl_sync_dleg_fail EXCEPTION;
213 g_tl_cache_int_cont_fail EXCEPTION;
214 g_tl_classify_dtl_fail EXCEPTION;
215
216 g_tl_util_get_currency_fail EXCEPTION;
217 g_tl_get_currency_fail EXCEPTION;
218
219 --FTE_TL_CACHE validation exceptions
220
221 g_tl_trp_no_trip_id EXCEPTION;
222 g_tl_trp_no_lane_id EXCEPTION;
223 g_tl_trp_no_service_type EXCEPTION;
224 g_tl_trp_no_carrier_id EXCEPTION;
225 g_tl_trp_no_mode EXCEPTION;
226 g_tl_trp_no_vehicle_type EXCEPTION;
227 g_tl_trp_no_price_list_id EXCEPTION;
228 g_tl_trp_no_ld_distance EXCEPTION;
229 g_tl_trp_no_ud_distance EXCEPTION;
230 g_tl_trp_no_pallets EXCEPTION;
231 g_tl_trp_no_containers EXCEPTION;
232 g_tl_trp_no_weight EXCEPTION;
233 g_tl_trp_no_volume EXCEPTION;
234 g_tl_trp_no_time EXCEPTION;
235 g_tl_trp_no_number_of_stops EXCEPTION;
236 g_tl_trp_no_total_trp_distance EXCEPTION;
237 g_tl_trp_no_total_dir_distance EXCEPTION;
238 g_tl_trp_no_distance_method EXCEPTION;
239 g_tl_trp_no_continous_move EXCEPTION;
240 g_tl_trp_no_departure_date EXCEPTION;
241 g_tl_trp_no_arrival_date EXCEPTION;
242 g_tl_trp_no_dead_head EXCEPTION;
243 g_tl_trp_no_stop_reference EXCEPTION;
244 g_tl_trp_no_dleg_reference EXCEPTION;
245
246
247 g_tl_stp_no_stop_id EXCEPTION;
248 g_tl_stp_no_trip_id EXCEPTION;
249 g_tl_stp_no_location_id EXCEPTION;
250 g_tl_stp_no_weekday_layovers EXCEPTION;
251 g_tl_stp_no_weekend_layovers EXCEPTION;
252 g_tl_stp_no_distance EXCEPTION;
253 g_tl_stp_no_time EXCEPTION;
254 g_tl_stp_no_pickup_weight EXCEPTION;
255 g_tl_stp_no_pickup_volume EXCEPTION;
256 g_tl_stp_no_pickup_pallets EXCEPTION;
257 g_tl_stp_no_pickup_containers EXCEPTION;
258 g_tl_stp_no_loading_protocol EXCEPTION;
259 g_tl_stp_no_dropoff_weight EXCEPTION;
260 g_tl_stp_no_dropoff_volume EXCEPTION;
261 g_tl_stp_no_dropoff_pallets EXCEPTION;
262 g_tl_stp_no_dropoff_containers EXCEPTION;
263 g_tl_stp_no_stop_region EXCEPTION;
264 g_tl_stp_no_arrival_date EXCEPTION;
265 g_tl_stp_no_departure_date EXCEPTION;
266 g_tl_stp_no_fac_charge_basis EXCEPTION;
267 g_tl_stp_no_fac_currency EXCEPTION;
268 g_tl_stp_no_fac_modifier_id EXCEPTION;
269 g_tl_stp_no_fac_pricelist_id EXCEPTION;
270 g_tl_stp_no_fac_weight_uom EXCEPTION;
271 g_tl_stp_no_fac_volume_uom EXCEPTION;
272 g_tl_stp_no_fac_distance_uom EXCEPTION;
273 g_tl_stp_no_fac_time_uom EXCEPTION;
274
275
276 g_tl_dlg_no_delivery_leg_id EXCEPTION;
277 g_tl_dlg_no_trip_id EXCEPTION;
281 g_tl_dlg_no_dropoff_stop_id EXCEPTION;
278 g_tl_dlg_no_delivery_id EXCEPTION;
279 g_tl_dlg_no_pickup_stop_id EXCEPTION;
280 g_tl_dlg_no_pickup_loc_id EXCEPTION;
282 g_tl_dlg_no_dropoff_loc_id EXCEPTION;
283 g_tl_dlg_no_weight EXCEPTION;
284 g_tl_dlg_no_volume EXCEPTION;
285 g_tl_dlg_no_pallets EXCEPTION;
286 g_tl_dlg_no_containers EXCEPTION;
287 g_tl_dlg_no_distance EXCEPTION;
288 g_tl_dlg_no_direct_distance EXCEPTION;
289
290
291 g_tl_dtl_no_dlv_dtl_id EXCEPTION;
292 g_tl_dtl_no_dlv_id EXCEPTION;
293 g_tl_dtl_no_dlg_id EXCEPTION;
294 g_tl_dtl_no_gross_weight EXCEPTION;
295 g_tl_dtl_no_weight_uom EXCEPTION;
296 g_tl_dtl_no_volume EXCEPTION;
297 g_tl_dtl_no_volume_uom EXCEPTION;
298
299
300 g_tl_car_no_carrier_id EXCEPTION;
301 g_tl_car_no_max_out_of_route EXCEPTION;
302 g_tl_car_no_min_cm_distance EXCEPTION;
303 g_tl_car_no_min_cm_time EXCEPTION;
304 g_tl_car_no_cm_free_dh_mileage EXCEPTION;
305 g_tl_car_no_cm_frst_ld_dsc_flg EXCEPTION;
306 g_tl_car_no_currency EXCEPTION;
307 g_tl_car_no_cm_rate_variant EXCEPTION;
308 g_tl_car_no_unit_basis EXCEPTION;
309 g_tl_car_no_weight_uom EXCEPTION;
310 g_tl_car_no_volume_uom EXCEPTION;
311 g_tl_car_no_distance_uom EXCEPTION;
312 g_tl_car_no_time_uom EXCEPTION;
313 g_tl_get_apprx_dist_time_fail EXCEPTION;
314 g_tl_delete_main_rec_fail EXCEPTION;
315
316
317 g_tl_trip_index_invalid EXCEPTION;
318 g_tl_validate_trp_cache_fail EXCEPTION;
319
320 --FTE_TL_CACHE warnings
321
322 g_tl_stp_no_fac_wrn EXCEPTION;
323 g_tl_cmp_trip_sched_fail EXCEPTION;
324 g_tl_cmp_trip_lane_fail EXCEPTION;
325
326
327 --FTE_TL_COST_ALLOCATION
328
329 g_tl_invalid_basis EXCEPTION;
330 g_tl_invalid_output_type EXCEPTION;
331 g_tl_conv_currency_fail EXCEPTION;
332 g_tl_get_stpff_per_stop_fail EXCEPTION;
333 g_tl_loading_chrg_fr_fail EXCEPTION;
334 g_tl_ast_ld_chrg_fr_fail EXCEPTION;
335 g_tl_fac_ld_chrg_fr_fail EXCEPTION;
336 g_tl_fac_ast_ld_chrg_fr_fail EXCEPTION;
337 g_tl_unld_chrg_fr_fail EXCEPTION;
338 g_tl_ast_unld_chrg_fr_fail EXCEPTION;
339 g_tl_fac_unld_chrg_fr_fail EXCEPTION;
340 g_tl_fac_ast_unld_chrg_fr_fail EXCEPTION;
341 g_tl_assgn_stpff_chrg_fail EXCEPTION;
342 g_tl_fac_hnd_chrg_pu_fr_fail EXCEPTION;
343 g_tl_alloc_hndl_chrg_fail EXCEPTION;
344 g_tl_org_chrg_fr_fail EXCEPTION;
345 g_tl_dst_chrg_fr_fail EXCEPTION;
346 g_tl_cr_fr_cost_temp_fail EXCEPTION;
347 g_tl_cr_fr_cost_fail EXCEPTION;
348 g_tl_ins_charge_rec_fail EXCEPTION;
349 g_tl_get_tot_stop_cost_fail EXCEPTION;
350 g_tl_get_tot_trp_cost_fail EXCEPTION;
351 g_tl_ins_tot_trp_chrg_fail EXCEPTION;
352 g_tl_ins_dist_ld_trp_chrg_fail EXCEPTION;
353 g_tl_ins_dist_ud_trp_chrg_fail EXCEPTION;
354 g_tl_no_carr_unit_basis EXCEPTION;
355 g_tl_ins_unit_trp_chrg_fail EXCEPTION;
356 g_tl_ins_time_trp_chrg_fail EXCEPTION;
357 g_tl_ins_flat_trp_chrg_fail EXCEPTION;
358 g_tl_ins_stpoff_trp_chrg_fail EXCEPTION;
359 g_tl_ins_outrt_trp_chrg_fail EXCEPTION;
360 g_tl_ins_hndl_trp_chrg_fail EXCEPTION;
361 g_tl_ins_cmdisc_trp_chrg_fail EXCEPTION;
362 g_tl_ins_tot_stp_chrg_fail EXCEPTION;
363 g_tl_ins_wkdayl_stp_chrg_fail EXCEPTION;
364 g_tl_ins_wkendl_stp_chrg_fail EXCEPTION;
365 g_tl_ins_ld_stp_chrg_fail EXCEPTION;
366 g_tl_ins_ast_ld_stp_chrg_fail EXCEPTION;
367 g_tl_ins_ud_stp_chrg_fail EXCEPTION;
368 g_tl_ins_ast_ud_stp_chrg_fail EXCEPTION;
369 g_tl_ins_org_stp_chrg_fail EXCEPTION;
370 g_tl_ins_f_ld_stp_chrg_fail EXCEPTION;
371 g_tl_ins_f_as_ld_stp_chrg_fail EXCEPTION;
372 g_tl_ins_f_ud_stp_chrg_fail EXCEPTION;
373 g_tl_ins_f_as_ud_stp_chrg_fail EXCEPTION;
374 g_tl_ins_f_hndl_stp_chrg_fail EXCEPTION;
375 g_tl_get_to_dleg_cost_fail EXCEPTION;
376 g_tl_ins_tot_dlg_chrg_fail EXCEPTION;
377 g_tl_ins_dist_ld_dlg_chrg_fail EXCEPTION;
378 g_tl_ins_unit_dlg_chrg_fail EXCEPTION;
379 g_tl_ins_time_dlg_chrg_fail EXCEPTION;
380 g_tl_ins_flat_dlg_chrg_fail EXCEPTION;
381 g_tl_ins_stpoff_dlg_chrg_fail EXCEPTION;
382 g_tl_ins_outrt_dlg_chrg_fail EXCEPTION;
383 g_tl_ins_hndl_dlg_chrg_fail EXCEPTION;
384 g_tl_ins_wkdayl_dlg_chrg_fail EXCEPTION;
385 g_tl_ins_wkendl_dlg_chrg_fail EXCEPTION;
386 g_tl_ins_ld_dlg_chrg_fail EXCEPTION;
387 g_tl_ins_as_ld_dlg_chrg_fail EXCEPTION;
388 g_tl_ins_ud_dlg_chrg_fail EXCEPTION;
389 g_tl_ins_as_ud_dlg_chrg_fail EXCEPTION;
390 g_tl_ins_org_dlg_chrg_fail EXCEPTION;
391 g_tl_ins_dst_dlg_chrg_fail EXCEPTION;
392 g_tl_ins_f_ld_dlg_chrg_fail EXCEPTION;
393 g_tl_ins_f_as_ld_dlg_chrg_fail EXCEPTION;
394 g_tl_ins_f_ud_dlg_chrg_fail EXCEPTION;
395 g_tl_ins_f_as_ud_dlg_chrg_fail EXCEPTION;
396 g_tl_ins_f_hndl_dlg_chrg_fail EXCEPTION;
397 g_tl_ins_cm_dist_dtl_chrg_fail EXCEPTION;
398 g_tl_ins_dist_ld_dtl_chrg_fail EXCEPTION;
399 g_tl_ins_dist_ud_dtl_chrg_fail EXCEPTION;
400 g_tl_ins_unit_dtl_chrg_fail EXCEPTION;
401 g_tl_ins_time_dtl_chrg_fail EXCEPTION;
402 g_tl_ins_flat_dtl_chrg_fail EXCEPTION;
403 g_tl_ins_stpoff_dtl_chrg_fail EXCEPTION;
404 g_tl_ins_outrt_dtl_chrg_fail EXCEPTION;
405 g_tl_ins_hndl_dtl_chrg_fail EXCEPTION;
406 g_tl_ins_wkday_dtl_chrg_fail EXCEPTION;
407 g_tl_ins_ld_dtl_chrg_fail EXCEPTION;
408 g_tl_ins_as_ld_dtl_chrg_fail EXCEPTION;
409 g_tl_ins_ud_dtl_chrg_fail EXCEPTION;
410 g_tl_ins_as_ud_dtl_chrg_fail EXCEPTION;
411 g_tl_ins_org_dtl_chrg_fail EXCEPTION;
412 g_tl_ins_dst_dtl_chrg_fail EXCEPTION;
413 g_tl_ins_f_ld_dtl_chrg_fail EXCEPTION;
414 g_tl_ins_f_as_ld_dtl_chrg_fail EXCEPTION;
415 g_tl_ins_f_ud_dtl_chrg_fail EXCEPTION;
416 g_tl_ins_f_as_ud_dtl_chrg_fail EXCEPTION;
417 g_tl_ins_f_hndl_dtl_chrg_fail EXCEPTION;
418 g_tl_cr_dlv_dtl_fail EXCEPTION;
419 g_tl_cr_trp_price_recs_fail EXCEPTION;
420 g_tl_cr_stp_price_recs_fail EXCEPTION;
421 g_tl_cr_dlg_price_recs_fail EXCEPTION;
425 g_tl_alloc_chrges_dleg_fail EXCEPTION;
422 g_tl_init_fr_codes_fail EXCEPTION;
423 g_tl_cr_stp_hash_fail EXCEPTION;
424 g_tl_alloc_ld_stpoff_dleg_fail EXCEPTION;
426 g_tl_alloc_to_dtls_fail EXCEPTION;
427 g_tl_cr_summry_price_recs_fail EXCEPTION;
428 g_tl_copy_fr_rec_fail EXCEPTION;
429 g_tl_fac_hnd_chrg_do_fr_fail EXCEPTION;
430 g_tl_ins_dst_stp_chrg_fail EXCEPTION;
431
432 g_tl_ins_wkend_dtl_chrg_fail EXCEPTION;
433 g_tl_is_dtl_pallet_fail EXCEPTION;
434 g_tl_get_cost_alloc_param_fail EXCEPTION;
435 g_tl_no_dtl_on_dleg EXCEPTION;
436 g_tl_ins_sum_dtl_chrg_fail EXCEPTION;
437 g_tl_fetch_alloc_param_fail EXCEPTION;
438 g_tl_ins_fuel_trp_chrg_fail EXCEPTION;
439 g_tl_ins_fuel_dlg_chrg_fail EXCEPTION;
440 g_tl_ins_fuel_dtl_chrg_fail EXCEPTION;
441 g_tl_mdc_top_dleg_fail EXCEPTION;
442 g_tl_mdc_alloc_chld_dleg_fail EXCEPTION;
443 g_tl_mdc_alloc_int_dtl_fail EXCEPTION;
444
445 --3756411
446 g_tl_ins_tmp_bulk_arr_fail EXCEPTION;
447 g_tl_clr_bulk_arr_fail EXCEPTION;
448 g_tl_bulk_ins_tmp_fail EXCEPTION;
449
450 --FTE_TL_RATING Exceptions
451
452 g_tl_build_cache_move_fail EXCEPTION;
453 g_tl_core_fail EXCEPTION;
454 g_tl_scale_trip_charges_fail EXCEPTION;
455 g_tl_scale_stop_charges_fail EXCEPTION;
456 g_tl_cost_allocation_fail EXCEPTION;
457 g_tl_rate_move_fail EXCEPTION;
458 g_tl_rate_trip_fail EXCEPTION;
459
460 g_tl_rate_cached_trip_fail EXCEPTION;
461 g_tl_bld_cache_trp_cmp_fail EXCEPTION;
462 g_tl_handle_cm_disc_var_fail EXCEPTION;
463 g_tl_handle_cm_rate_var_fail EXCEPTION;
464 g_tl_is_pricing_required_fail EXCEPTION;
465 g_tl_move_rec_lane_sched_null EXCEPTION;
466 g_tl_get_fc_id_fail EXCEPTION;
467 g_tl_check_freight_term_fail EXCEPTION;
468 g_tl_cache_estimate_fail EXCEPTION;
469 g_tl_get_base_acc_chrg_fail EXCEPTION;
470 g_tl_fpa_get_trip_inf_fail EXCEPTION;
471 g_tl_update_dist_stop_fail EXCEPTION;
472 g_tl_veh_for_lane_sched_fail EXCEPTION;
473 g_tl_calc_dim_weight_fail EXCEPTION;
474 g_tl_bld_cache_om_fail EXCEPTION;
475 g_tl_om_filt_least_veh_fail EXCEPTION;
476 g_tl_om_populate_rate_fail EXCEPTION;
477 g_tl_om_rating_fail EXCEPTION;
478 g_tl_populate_summary_fail EXCEPTION;
479 g_tl_move_dlv_rec_fail EXCEPTION;
480
481 --Warnings
482 g_tl_trip_cmp_rate_schd_fail EXCEPTION;
483 g_tl_trip_cmp_rate_lane_fail EXCEPTION;
484
485 -- FTE_TRIP_RATING Exceptions
486 g_unsupported_action EXCEPTION;
487 g_nontl_move_rec_to_main_fail EXCEPTION;
488 g_tl_move_rec_to_main_fail EXCEPTION;
489 g_quicksort_partition_fail EXCEPTION;
490 g_quicksort_fail EXCEPTION;
491 g_seq_tender_sort_fail EXCEPTION;
492 g_sort_fail EXCEPTION;
493 g_quicksort_compare_fail EXCEPTION;
494 g_lane_matches_rank_fail EXCEPTION;
495 g_copy_lane_rank_fail EXCEPTION;
496 g_get_veh_item_org_fail EXCEPTION;
497 g_elim_dup_rank_fail EXCEPTION;
498
499 --- Debugging Utils ---
500 -- code locators
501 g_method VARCHAR2(240);
502 g_location VARCHAR2(240);
503 g_exception VARCHAR2(240);
504
505 -- This variable holds the state of the debug flag for the session
506 g_debug boolean := false; --false by default
507 g_oe_debug boolean := false;
508 g_debug_level NUMBER :=1; --currently we support only one debug level.
509 g_debug_mode VARCHAR2(30) := 'FILE' ; --only 'FILE' supported right now
510 --g_debug_mode VARCHAR2(30) := NULL ; --only 'FILE' supported right now
511
512 -- If this variable is true, debugging will be enabled for the Advanced Pricing engine
513 --g_qp_debug boolean := false;
514
515 -- Log levels
516 G_LOG NUMBER :=0;
517 G_ERR NUMBER :=1;
518 G_WRN NUMBER :=2;
519 G_INF NUMBER :=3;
520 G_DBG NUMBER :=4;
521
522 -- resets the method variables (code locators)
523 PROCEDURE reset_dbg_vars;
524
525 -- Sets the debug flag on for the session
526 PROCEDURE set_debug_on;
527
528 -- Sets the debug flag off for the session
529 PROCEDURE set_debug_off;
530
531 /*
532 -- Sets debug on for the qp engine
533 PROCEDURE set_qp_debug_on;
534
535 -- Sets debug off for the qp engine
536 PROCEDURE set_qp_debug_off;
537 */
538
539 --prints the message along with the debug information
540 --to the log destination
541
542 /*
543 PROCEDURE print_debug( p_msg IN VARCHAR2 DEFAULT NULL);
544
545 --prints the message only without the debug information
546 PROCEDURE print_msg( p_msg_old IN VARCHAR2 );
547 */
548
549 --prints the message wrapping the line in <L> </L> tags
550 PROCEDURE print_msg( p_log_level IN NUMBER DEFAULT G_LOG, p_msg IN VARCHAR2 ) ;
551
552 --prints the message without wrapping the line in <L> </L> tags
553 --to be used when p_msg itself contains tags
554 PROCEDURE print_tag( p_log_level IN NUMBER DEFAULT G_LOG, p_msg IN VARCHAR2 ) ;
555
556 -- flushes the log buffers
557 PROCEDURE flush_logs;
558
559 -- flushes the log files. Should be called at all exit points
560 PROCEDURE close_logs;
561
562 -- used to set the current method name
563 PROCEDURE set_method(p_log_level IN NUMBER DEFAULT G_LOG, p_met IN VARCHAR2,
564 p_loc IN VARCHAR2 DEFAULT NULL);
565
566 PROCEDURE unset_method(p_log_level IN NUMBER DEFAULT G_LOG, p_met IN VARCHAR2);
567
568 -- used to set the current location
569 PROCEDURE set_location(p_log_level IN NUMBER DEFAULT G_DBG, p_loc IN VARCHAR2);
570
574
571 -- Called in case of errors/warnings for outermost procedures to set the current exception
572 -- and to set the log file name on the stack
573 PROCEDURE set_exit_exception(p_met IN VARCHAR2, p_exc IN VARCHAR2);
575 -- used to set the current exception (in case of exception handlers )
576 PROCEDURE set_exception(p_met IN VARCHAR2,
577 p_log_level IN NUMBER DEFAULT G_LOG,
578 p_exc IN VARCHAR2);
579
580
581 -- This procedure checks the profile options to:
582 -- check if debuging is turned on for the user
583 -- check if qp debugging is on for the user
584 -- get the location of the debug trace directory
585 -- It initializes the debug trace file if debug is on
586 -- It should be called at the beginning of each entry point
587
588 PROCEDURE initialize_logging (p_debug_mode IN VARCHAR2 DEFAULT NULL,
589 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
590 x_return_status OUT NOCOPY VARCHAR2);
591
592 FUNCTION get_log_file_name RETURN VARCHAR2;
593
594 FUNCTION get_lookup_meaning (p_lookup_type IN VARCHAR2,
595 p_lookup_code IN VARCHAR2)
596 RETURN VARCHAR2;
597
598 PROCEDURE comma_to_table (
599 p_list IN VARCHAR2,
600 x_tab OUT NOCOPY dbms_utility.uncl_array );
601
602 PROCEDURE comma_to_number_table (
603 p_list IN VARCHAR2,
604 x_num_tab OUT NOCOPY WSH_UTIL_CORE.id_tab_type );
605
606 PROCEDURE table_to_comma (
607 p_tab IN dbms_utility.uncl_array,
608 x_list OUT NOCOPY VARCHAR2 );
609
610 PROCEDURE number_table_to_comma (
611 p_num_tab IN wsh_util_core.id_tab_type,
612 x_list OUT NOCOPY VARCHAR2 );
613
614 FUNCTION get_msg_count RETURN NUMBER;
615
616 -- bug 2762257
617 PROCEDURE set_price_comp_exit_warn;
618 PROCEDURE set_trip_prc_comp_exit_warn;
619
620
621 --
622 -- Procedure setmsg
623 -- Used to add a message to the message stack
624 -- p_api -> calling program name
625 -- p_exc -> exception name (form g_... )
626 -- p_msg_type -> 'E' - Error (default), 'W'-Warning, 'U'- unexpected
627 --error
628 -- p_trip_id, ... -> tokens
629 --
630
631 PROCEDURE setmsg (p_api IN VARCHAR2,
632 p_exc IN VARCHAR2,
633 p_msg_name IN VARCHAR2 DEFAULT NULL,
634 p_msg_type IN VARCHAR2 DEFAULT 'E',
635 p_trip_id IN NUMBER DEFAULT NULL,
636 p_stop_id IN NUMBER DEFAULT NULL,
637 p_delivery_id IN NUMBER DEFAULT NULL,
638 p_delivery_leg_id IN NUMBER DEFAULT NULL,
639 p_delivery_detail_id IN NUMBER DEFAULT NULL,
640 p_carrier_id IN NUMBER DEFAULT NULL,
641 p_location_id IN NUMBER DEFAULT NULL,
642 p_list_header_id IN NUMBER DEFAULT NULL,
643 p_lane_id IN NUMBER DEFAULT NULL,
644 p_schedule_id IN NUMBER DEFAULT NULL,
645 p_move_id IN NUMBER DEFAULT NULL);
646
647 -- This is added for R12 to get currency code for rating.
648 -- Added to support Multiple currency for international shippings.
649 PROCEDURE get_currency_code (p_delivery_id IN NUMBER DEFAULT NULL,
650 p_trip_id IN NUMBER DEFAULT NULL,
651 p_location_id IN NUMBER DEFAULT NULL,
652 p_carrier_id IN NUMBER DEFAULT NULL,
653 x_currency_code OUT NOCOPY VARCHAR2 ,
654 x_return_status OUT NOCOPY VARCHAR2 );
655
656
657
658 --Internally calls WSH_WV_UTILS.convert_uom
659 -- returns NULL if conversion fails
660 FUNCTION convert_uom(from_uom IN VARCHAR2,
661 to_uom IN VARCHAR2,
662 quantity IN NUMBER,
663 item_id IN NUMBER DEFAULT NULL) RETURN NUMBER;
664
665 END FTE_FREIGHT_PRICING_UTIL;