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_FREIGHT_PRICING_SPECIAL dependencies on FTE_QP_ENGINE

Line 648: FTE_QP_ENGINE.clear_qp_input(x_return_status => l_return_status);

644: print_rules;
645:
646: x_lane_function := g_special_flags.lane_function;
647:
648: FTE_QP_ENGINE.clear_qp_input(x_return_status => l_return_status);
649: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
650: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
651: raise fte_freight_pricing_util.g_clear_qp_input_failed;
652: END IF;

Line 2123: fte_qp_engine.get_total_base_price(p_set_num => p_set_num, -- Have to pass set number as otherwise

2119: END IF;
2120:
2121: IF p_comp_with_price IS NULL THEN
2122: -- now calculate the total base price of the shipment (for the given set)
2123: fte_qp_engine.get_total_base_price(p_set_num => p_set_num, -- Have to pass set number as otherwise
2124: -- the correct remaining set
2125: -- would not be picked up eg. deficit wt.
2126: -- with min. charge or hundred wt
2127: -- with min. charge would not work

Line 2151: -- TODO : implement x_priced_currency in fte_qp_engine.get_total_base_price. the following lines

2147: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_base_price = '||l_total_base_price);
2148: -- call the local module
2149: get_min_charge_parameter (l_min_charge_amt, l_min_charge_curr);
2150:
2151: -- TODO : implement x_priced_currency in fte_qp_engine.get_total_base_price. the following lines
2152: -- are commented out for now
2153: --IF (l_min_charge_curr <> l_priced_curr ) THEN
2154: -- error
2155: -- RETURN;

Line 2166: fte_qp_engine.apply_new_base_price(--p_set_num => p_set_num,

2162: -- should apply min. charge
2163: -- prorate min. charge across all engine output lines by wt.
2164: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'min charge will be applied');
2165: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'min charge amount : '||l_min_charge_amt);
2166: fte_qp_engine.apply_new_base_price(--p_set_num => p_set_num,
2167: p_set_num => p_set_num, -- AG 5/10
2168: p_new_total_price => l_min_charge_amt,
2169: x_return_status => l_return_status);
2170:

Line 2246: l_comm_price_rec fte_qp_engine.commodity_price_rec_type;

2242: l_deficit_wt NUMBER:=0;
2243: l_converted_def_wt NUMBER:=0;
2244: l_deficit_wt_uom VARCHAR2(30);
2245:
2246: l_comm_price_rec fte_qp_engine.commodity_price_rec_type;
2247: l_comm_price_rows_set1 fte_qp_engine.commodity_price_tbl_type;
2248: l_comm_price_rows_set2 fte_qp_engine.commodity_price_tbl_type;
2249:
2250: x_price NUMBER;

Line 2247: l_comm_price_rows_set1 fte_qp_engine.commodity_price_tbl_type;

2243: l_converted_def_wt NUMBER:=0;
2244: l_deficit_wt_uom VARCHAR2(30);
2245:
2246: l_comm_price_rec fte_qp_engine.commodity_price_rec_type;
2247: l_comm_price_rows_set1 fte_qp_engine.commodity_price_tbl_type;
2248: l_comm_price_rows_set2 fte_qp_engine.commodity_price_tbl_type;
2249:
2250: x_price NUMBER;
2251: y_price NUMBER;

Line 2248: l_comm_price_rows_set2 fte_qp_engine.commodity_price_tbl_type;

2244: l_deficit_wt_uom VARCHAR2(30);
2245:
2246: l_comm_price_rec fte_qp_engine.commodity_price_rec_type;
2247: l_comm_price_rows_set1 fte_qp_engine.commodity_price_tbl_type;
2248: l_comm_price_rows_set2 fte_qp_engine.commodity_price_tbl_type;
2249:
2250: x_price NUMBER;
2251: y_price NUMBER;
2252: l_lowest_unit_price NUMBER;

Line 2299: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;

2295: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_wt = '||l_total_wt);
2296: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_wt_uom = '||l_total_wt_uom);
2297: END IF;
2298:
2299: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;
2300: fte_qp_engine.create_control_record(p_event_num => l_event_num,
2301: x_return_status => l_return_status );
2302:
2303: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');

Line 2300: fte_qp_engine.create_control_record(p_event_num => l_event_num,

2296: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_wt_uom = '||l_total_wt_uom);
2297: END IF;
2298:
2299: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;
2300: fte_qp_engine.create_control_record(p_event_num => l_event_num,
2301: x_return_status => l_return_status );
2302:
2303: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
2304: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

Line 2315: fte_qp_engine.create_line_record (p_pricing_control_rec => p_pricing_control_rec,

2311: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'In set = '||l_set_num);
2312: i := p_pricing_engine_rows.FIRST;
2313: IF (i IS NOT NULL) THEN
2314: LOOP
2315: fte_qp_engine.create_line_record (p_pricing_control_rec => p_pricing_control_rec,
2316: p_pricing_engine_input_rec => p_pricing_engine_rows(i),
2317: x_return_status => l_return_status);
2318:
2319: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);

Line 2325: fte_qp_engine.prepare_qp_line_qualifiers(

2321: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2322: raise fte_freight_pricing_util.g_create_line_record_failed;
2323: END IF;
2324:
2325: fte_qp_engine.prepare_qp_line_qualifiers(
2326: p_event_num => l_event_num,
2327: p_pricing_control_rec => p_pricing_control_rec,
2328: p_input_index => p_pricing_engine_rows(i).input_index,
2329: x_return_status => l_return_status);

Line 2337: fte_qp_engine.prepare_qp_line_attributes (

2333: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2334: raise fte_freight_pricing_util.g_create_qualifiers_failed;
2335: END IF;
2336:
2337: fte_qp_engine.prepare_qp_line_attributes (
2338: p_event_num => l_event_num,
2339: p_input_index => p_pricing_engine_rows(i).input_index,
2340: p_attr_rows => p_pricing_attribute_rows,
2341: x_return_status => l_return_status);

Line 2364: fte_qp_engine.create_attr_record (p_event_num => l_event_num,

2360: ELSE
2361: l_attr_rec.attribute_value := to_char(l_total_wt);
2362: END IF;
2363:
2364: fte_qp_engine.create_attr_record (p_event_num => l_event_num,
2365: p_attr_rec => l_attr_rec,
2366: x_return_status => l_return_status);
2367:
2368: fte_freight_pricing_util.set_location(p_loc=>'after create qp line attributes. i='||i);

Line 2430: --fte_qp_engine.get_max_input_index(p_event_num => fte_qp_engine.G_LINE_EVENT_NUM,

2426: l_deficit_wt_uom := l_next_weight_break_uom;
2427:
2428:
2429: --l_set_num := 2;
2430: --fte_qp_engine.get_max_input_index(p_event_num => fte_qp_engine.G_LINE_EVENT_NUM,
2431: -- p_set_num => 1,
2432: -- p_max_line_index => l_set_one_max_input_idx,
2433: -- x_return_status => l_return_status);
2434:

Line 2451: fte_qp_engine.create_line_record (p_pricing_control_rec => p_pricing_control_rec,

2447: p_pricing_engine_rows(l_new_index) := l_engine_input_rec;
2448:
2449:
2450: -- prepare line rec
2451: fte_qp_engine.create_line_record (p_pricing_control_rec => p_pricing_control_rec,
2452: p_pricing_engine_input_rec => l_engine_input_rec,
2453: x_return_status => l_return_status);
2454:
2455: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);

Line 2462: fte_qp_engine.prepare_qp_line_qualifiers(

2458: raise fte_freight_pricing_util.g_create_line_record_failed;
2459: END IF;
2460:
2461: --prepare qualifiers
2462: fte_qp_engine.prepare_qp_line_qualifiers(
2463: p_event_num => l_event_num,
2464: p_pricing_control_rec => p_pricing_control_rec,
2465: p_input_index => l_new_index,
2466: x_return_status => l_return_status);

Line 2485: fte_qp_engine.create_attr_record ( p_event_num => l_event_num,

2481: l_attr_rec.attribute_index := p_pricing_attribute_rows(p_pricing_attribute_rows.COUNT).attribute_index + 1;
2482:
2483: p_pricing_attribute_rows(p_pricing_attribute_rows.COUNT + 1) := l_attr_rec;
2484:
2485: fte_qp_engine.create_attr_record ( p_event_num => l_event_num,
2486: p_attr_rec => l_attr_rec,
2487: x_return_status => l_return_status);
2488:
2489: fte_freight_pricing_util.set_location(p_loc=>'after create attr record . i='||i);

Line 2506: fte_qp_engine.create_attr_record( p_event_num => l_event_num,

2502: l_attr_rec.input_index := l_new_index;
2503: l_attr_rec.attribute_name := 'ITEM_ALL';
2504: l_attr_rec.attribute_value := 'ALL';
2505:
2506: fte_qp_engine.create_attr_record( p_event_num => l_event_num,
2507: p_attr_rec => l_attr_rec,
2508: x_return_status => l_return_status);
2509:
2510: fte_freight_pricing_util.set_location(p_loc=>'after create attr record . i='||i);

Line 2531: fte_qp_engine.create_attr_record(p_event_num => l_event_num,

2527: ELSE
2528: l_attr_rec.attribute_value := to_char(l_next_weight_break);
2529: END IF;
2530:
2531: fte_qp_engine.create_attr_record(p_event_num => l_event_num,
2532: p_attr_rec => l_attr_rec,
2533: x_return_status => l_return_status);
2534: fte_freight_pricing_util.set_location(p_loc=>'after create attr record . i='||i);
2535: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

Line 2550: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => x_qp_output_line_rows,

2546: -- }
2547: END IF; --l_deficit_wt_enabled
2548:
2549: -- call qp api
2550: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => x_qp_output_line_rows,
2551: x_qp_output_detail_rows => x_qp_output_detail_rows,
2552: x_return_status => l_return_status);
2553:
2554: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');

Line 2562: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);

2558: END IF;
2559: END IF;
2560:
2561: --check for errors in the output
2562: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
2563: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
2564: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2565: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2566: raise fte_freight_pricing_util.g_qp_price_request_failed_2;

Line 2580: fte_qp_engine.analyse_output_for_deficit_wt (p_set_num => l_set_num,

2576: -- get me unit price for each individual commodity for each set
2577: -- get me total wt. for each individual commodity
2578: -- give me all weights in the deficit wt uom
2579: l_set_num := 1; -- set 1 uses original total weight
2580: fte_qp_engine.analyse_output_for_deficit_wt (p_set_num => l_set_num,
2581: p_wt_uom => l_deficit_wt_uom,
2582: x_commodity_price_rows => l_comm_price_rows_set1,
2583: x_return_status => l_return_status);
2584:

Line 2594: fte_qp_engine.analyse_output_for_deficit_wt (

2590:
2591: IF l_deficit_wt_enabled THEN
2592: -- {
2593: l_set_num := 2; -- set 2 uses next higher break weight
2594: fte_qp_engine.analyse_output_for_deficit_wt (
2595: p_set_num => l_set_num,
2596: p_wt_uom => l_deficit_wt_uom,
2597: x_commodity_price_rows => l_comm_price_rows_set2,
2598: x_return_status => l_return_status);

Line 2691: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,

2687: -- deficit wt got applied
2688: -- select set 2, delete set 1
2689: l_set_num :=1; --set to delete
2690: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'Deleting set ='||l_set_num);
2691: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
2692: x_return_status => l_return_status);
2693: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
2694: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2695: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

Line 2708: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,

2704: -- select set 1, delete set 2
2705: -- no deficit wt applied
2706: l_set_num :=2; --set to delete
2707: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'Deleting set ='||l_set_num);
2708: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
2709: x_return_status => l_return_status);
2710: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
2711: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2712: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

Line 2757: FTE_QP_ENGINE.add_qp_output_detail(

2753: END IF;
2754: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'def wt adjustment_amount : '||l_adjustment_amount);
2755:
2756:
2757: FTE_QP_ENGINE.add_qp_output_detail(
2758: p_line_index => l_lowest_up_line_index,
2759: p_list_line_type_code => 'SUR',
2760: p_charge_subtype_code => 'DEFICIT WEIGHT SURCHARGE',
2761: p_adjustment_amount => l_adjustment_amount,

Line 2771: FTE_QP_ENGINE.get_qp_output(

2767: END IF;
2768: END IF;
2769:
2770: -- TO DO : check that we are assigning x_ at the end everywhere
2771: FTE_QP_ENGINE.get_qp_output(
2772: x_qp_output_line_rows => x_qp_output_line_rows,
2773: x_qp_output_detail_rows => x_qp_output_detail_rows,
2774: x_return_status => l_return_status);
2775:

Line 2897: l_event_num := fte_qp_engine.G_CHARGE_EVENT_NUM;

2893: END IF;
2894:
2895: -- create request lines for the next event and call qp engine
2896: IF (l_charge_applied = 'Y') THEN
2897: l_event_num := fte_qp_engine.G_CHARGE_EVENT_NUM;
2898: fte_qp_engine.prepare_next_event_request ( x_return_status => l_return_status);
2899:
2900: fte_freight_pricing_util.set_location(p_loc=>'after prepare_next_event_request');
2901: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

Line 2898: fte_qp_engine.prepare_next_event_request ( x_return_status => l_return_status);

2894:
2895: -- create request lines for the next event and call qp engine
2896: IF (l_charge_applied = 'Y') THEN
2897: l_event_num := fte_qp_engine.G_CHARGE_EVENT_NUM;
2898: fte_qp_engine.prepare_next_event_request ( x_return_status => l_return_status);
2899:
2900: fte_freight_pricing_util.set_location(p_loc=>'after prepare_next_event_request');
2901: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
2902: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

Line 2906: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => x_qp_output_line_rows,

2902: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
2903: raise fte_freight_pricing_util.g_prepare_next_event_failed;
2904: END IF;
2905:
2906: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => x_qp_output_line_rows,
2907: x_qp_output_detail_rows => x_qp_output_detail_rows,
2908: x_return_status => l_return_status);
2909:
2910: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 2');

Line 2918: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);

2914: END IF;
2915: END IF;
2916:
2917: --check for errors in the output
2918: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
2919: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
2920: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2921: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2922: raise fte_freight_pricing_util.g_qp_price_request_failed_2;

Line 3048: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;

3044: -- call qp api
3045: -- (how does min charge mix with deficit wt.?)
3046: -- do deficit wt. calc and comparision
3047: -- delete unused set from engine rows and from qp input and output tables
3048: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;
3049: l_set_num := 1;
3050:
3051: process_LTL_with_deficit_wt(
3052: p_pricing_control_rec => p_pricing_control_rec,

Line 3098: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;

3094: -- standard LTL
3095: -- prepare engine input
3096: -- add Total_Item_Quantity attributes
3097: -- call qp
3098: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;
3099: l_set_num := 1;
3100: fte_qp_engine.create_control_record(p_event_num => l_event_num,
3101: x_return_status => l_return_status );
3102: i := p_pricing_engine_rows.FIRST;

Line 3100: fte_qp_engine.create_control_record(p_event_num => l_event_num,

3096: -- add Total_Item_Quantity attributes
3097: -- call qp
3098: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;
3099: l_set_num := 1;
3100: fte_qp_engine.create_control_record(p_event_num => l_event_num,
3101: x_return_status => l_return_status );
3102: i := p_pricing_engine_rows.FIRST;
3103: IF (i IS NOT NULL) THEN
3104: LOOP

Line 3106: fte_qp_engine.create_line_record (p_pricing_control_rec => p_pricing_control_rec,

3102: i := p_pricing_engine_rows.FIRST;
3103: IF (i IS NOT NULL) THEN
3104: LOOP
3105:
3106: fte_qp_engine.create_line_record (p_pricing_control_rec => p_pricing_control_rec,
3107: p_pricing_engine_input_rec => p_pricing_engine_rows(i),
3108: x_return_status => l_return_status);
3109:
3110: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');

Line 3117: fte_qp_engine.prepare_qp_line_qualifiers(

3113: raise fte_freight_pricing_util.g_create_control_record_failed;
3114: END IF;
3115:
3116:
3117: fte_qp_engine.prepare_qp_line_qualifiers(
3118: p_event_num => l_event_num,
3119: p_pricing_control_rec => p_pricing_control_rec,
3120: p_input_index => p_pricing_engine_rows(i).input_index,
3121: x_return_status => l_return_status);

Line 3129: fte_qp_engine.prepare_qp_line_attributes (

3125: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3126: raise fte_freight_pricing_util.g_create_qualifiers_failed;
3127: END IF;
3128:
3129: fte_qp_engine.prepare_qp_line_attributes (
3130: p_event_num => l_event_num,
3131: p_input_index => p_pricing_engine_rows(i).input_index,
3132: p_attr_rows => p_pricing_attribute_rows,
3133: x_return_status => l_return_status);

Line 3157: fte_qp_engine.create_attr_record(p_event_num => l_event_num,

3153: ELSE
3154: l_attr_rec.attribute_value := to_char(l_total_wt);
3155: END IF;
3156:
3157: fte_qp_engine.create_attr_record(p_event_num => l_event_num,
3158: p_attr_rec => l_attr_rec,
3159: x_return_status => l_return_status);
3160:
3161: fte_freight_pricing_util.set_location(p_loc=>'after create attr record i='||i);

Line 3177: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => x_qp_output_line_rows,

3173: END LOOP;
3174: END IF;
3175:
3176: -- call qp api
3177: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => x_qp_output_line_rows,
3178: x_qp_output_detail_rows => x_qp_output_detail_rows,
3179: x_return_status => l_return_status);
3180:
3181: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');

Line 3189: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);

3185: END IF;
3186: END IF;
3187:
3188: --check for errors in the output
3189: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
3190: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
3191: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
3192: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
3193: raise fte_freight_pricing_util.g_qp_price_request_failed_2;

Line 3642: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;

3638: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_wt = '||l_total_wt);
3639: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_wt_uom = '||l_total_wt_uom);
3640: END IF;
3641: */
3642: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;
3643: fte_qp_engine.create_control_record(p_event_num => l_event_num,
3644: x_return_status => l_return_status );
3645:
3646: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');

Line 3643: fte_qp_engine.create_control_record(p_event_num => l_event_num,

3639: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_total_wt_uom = '||l_total_wt_uom);
3640: END IF;
3641: */
3642: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;
3643: fte_qp_engine.create_control_record(p_event_num => l_event_num,
3644: x_return_status => l_return_status );
3645:
3646: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
3647: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

Line 3663: fte_qp_engine.create_line_record (p_pricing_control_rec => p_pricing_control_rec,

3659:
3660: --4720306
3661: --p_pricing_engine_rows(i).line_quantity := ceil(p_pricing_engine_rows(i).line_quantity);
3662:
3663: fte_qp_engine.create_line_record (p_pricing_control_rec => p_pricing_control_rec,
3664: p_pricing_engine_input_rec => p_pricing_engine_rows(i),
3665: x_return_status => l_return_status);
3666:
3667: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);

Line 3673: fte_qp_engine.prepare_qp_line_qualifiers(

3669: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3670: raise fte_freight_pricing_util.g_create_line_record_failed;
3671: END IF;
3672:
3673: fte_qp_engine.prepare_qp_line_qualifiers(
3674: p_event_num => l_event_num,
3675: p_pricing_control_rec => p_pricing_control_rec,
3676: p_input_index => p_pricing_engine_rows(i).input_index,
3677: x_return_status => l_return_status);

Line 3685: fte_qp_engine.prepare_qp_line_attributes (

3681: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
3682: raise fte_freight_pricing_util.g_create_qualifiers_failed;
3683: END IF;
3684:
3685: fte_qp_engine.prepare_qp_line_attributes (
3686: p_event_num => l_event_num,
3687: p_input_index => p_pricing_engine_rows(i).input_index,
3688: p_attr_rows => p_pricing_attribute_rows,
3689: x_return_status => l_return_status);

Line 3705: fte_qp_engine.create_attr_record( p_event_num => l_event_num,

3701: l_attr_rec.input_index := i;
3702: l_attr_rec.attribute_name := 'MULTIPIECE_FLAG';
3703: l_attr_rec.attribute_value := 'N';
3704:
3705: fte_qp_engine.create_attr_record( p_event_num => l_event_num,
3706: p_attr_rec => l_attr_rec,
3707: x_return_status => l_return_status);
3708:
3709: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');

Line 3817: fte_qp_engine.create_line_record (p_pricing_control_rec => p_pricing_control_rec,

3813:
3814: p_pricing_engine_rows(l_new_index) := l_engine_input_rec;
3815:
3816: -- prepare line rec
3817: fte_qp_engine.create_line_record (p_pricing_control_rec => p_pricing_control_rec,
3818: p_pricing_engine_input_rec => l_engine_input_rec,
3819: x_return_status => l_return_status);
3820:
3821: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);

Line 3828: fte_qp_engine.prepare_qp_line_qualifiers(

3824: raise fte_freight_pricing_util.g_create_line_record_failed;
3825: END IF;
3826:
3827: --prepare qualifiers
3828: fte_qp_engine.prepare_qp_line_qualifiers(
3829: p_event_num => l_event_num,
3830: p_pricing_control_rec => p_pricing_control_rec,
3831: p_input_index => l_new_index,
3832: x_return_status => l_return_status);

Line 3851: fte_qp_engine.create_attr_record ( p_event_num => l_event_num,

3847: l_attr_rec.attribute_index := p_pricing_attribute_rows(p_pricing_attribute_rows.COUNT).attribute_index + 1;
3848:
3849: p_pricing_attribute_rows(l_attr_rec.attribute_index) := l_attr_rec;
3850:
3851: fte_qp_engine.create_attr_record ( p_event_num => l_event_num,
3852: p_attr_rec => l_attr_rec,
3853: x_return_status => l_return_status);
3854:
3855: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record');

Line 3873: fte_qp_engine.create_attr_record( p_event_num => l_event_num,

3869: l_attr_rec.input_index := l_new_index;
3870: l_attr_rec.attribute_name := 'ITEM_ALL';
3871: l_attr_rec.attribute_value := 'ALL';
3872:
3873: fte_qp_engine.create_attr_record( p_event_num => l_event_num,
3874: p_attr_rec => l_attr_rec,
3875: x_return_status => l_return_status);
3876:
3877: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');

Line 3899: fte_qp_engine.create_attr_record(p_event_num => l_event_num,

3895: ELSE
3896: l_attr_rec.attribute_value := to_char(l_total_wt);
3897: END IF;
3898:
3899: fte_qp_engine.create_attr_record(p_event_num => l_event_num,
3900: p_attr_rec => l_attr_rec,
3901: x_return_status => l_return_status);
3902:
3903: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');

Line 3916: fte_qp_engine.create_attr_record( p_event_num => l_event_num,

3912: l_attr_rec.input_index := l_new_index;
3913: l_attr_rec.attribute_name := 'MULTIPIECE_FLAG';
3914: l_attr_rec.attribute_value := 'Y';
3915:
3916: fte_qp_engine.create_attr_record( p_event_num => l_event_num,
3917: p_attr_rec => l_attr_rec,
3918: x_return_status => l_return_status);
3919:
3920: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');

Line 3940: fte_qp_engine.create_attr_record(p_event_num => l_event_num,

3936: ELSE
3937: l_attr_rec.attribute_value := to_char(l_total_wt);
3938: END IF;
3939:
3940: fte_qp_engine.create_attr_record(p_event_num => l_event_num,
3941: p_attr_rec => l_attr_rec,
3942: x_return_status => l_return_status);
3943:
3944: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');

Line 3983: fte_qp_engine.create_attr_record(p_event_num => l_event_num,

3979: ELSE
3980: l_attr_rec.attribute_value := to_char(l_total_wt);
3981: END IF;
3982:
3983: fte_qp_engine.create_attr_record(p_event_num => l_event_num,
3984: p_attr_rec => l_attr_rec,
3985: x_return_status => l_return_status);
3986:
3987: fte_freight_pricing_util.set_location(p_loc=>'after create_attr_record ');

Line 4000: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => x_qp_output_line_rows,

3996: END IF;
3997:
3998: END IF; -- g_special_flags.parcel_hundredwt_flag
3999: -- call qp api
4000: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => x_qp_output_line_rows,
4001: x_qp_output_detail_rows => x_qp_output_detail_rows,
4002: x_return_status => l_return_status);
4003:
4004: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api');

Line 4012: --fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);

4008: END IF;
4009: END IF;
4010:
4011: --check for errors in the output
4012: --fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
4013:
4014: fte_qp_engine.check_parcel_output_errors (p_event_num => l_event_num,
4015: x_return_code => l_op_ret_code,
4016: x_return_status => l_return_status);

Line 4014: fte_qp_engine.check_parcel_output_errors (p_event_num => l_event_num,

4010:
4011: --check for errors in the output
4012: --fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
4013:
4014: fte_qp_engine.check_parcel_output_errors (p_event_num => l_event_num,
4015: x_return_code => l_op_ret_code,
4016: x_return_status => l_return_status);
4017:
4018: fte_freight_pricing_util.set_location(p_loc=>'after check_parcel_output_errors: Event '||l_event_num);

Line 4030: IF (l_op_ret_code = fte_qp_engine.G_PAR_NO_MP_PRICE) THEN

4026: END IF;
4027:
4028: IF g_special_flags.parcel_hundredwt_flag = 'Y' THEN
4029:
4030: IF (l_op_ret_code = fte_qp_engine.G_PAR_NO_MP_PRICE) THEN
4031: --multipiece prices not found.
4032: --standard rates apply
4033: --delete any set=2 lines that may exist
4034: l_set_num :=2; --set to delete

Line 4035: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,

4031: --multipiece prices not found.
4032: --standard rates apply
4033: --delete any set=2 lines that may exist
4034: l_set_num :=2; --set to delete
4035: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
4036: x_return_status => l_return_status);
4037:
4038: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
4039: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

Line 4048: ELSIF (l_op_ret_code = fte_qp_engine.G_PAR_NO_SP_PRICE) THEN

4044: --bug2803178
4045: g_bumped_rolledup_lines.DELETE;
4046:
4047: l_set_num :=1; -- remaining set apply_min_charge to be called with this
4048: ELSIF (l_op_ret_code = fte_qp_engine.G_PAR_NO_SP_PRICE) THEN
4049: --singlepiece prices not found.
4050: --use hundred wt rates
4051: --delete any set=1 lines that may exist
4052: l_set_num :=1; --set to delete

Line 4053: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,

4049: --singlepiece prices not found.
4050: --use hundred wt rates
4051: --delete any set=1 lines that may exist
4052: l_set_num :=1; --set to delete
4053: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
4054: x_return_status => l_return_status);
4055:
4056: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
4057: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

Line 4079: fte_qp_engine.get_total_base_price(p_set_num => l_set_num,

4075: ELSE -- l_op_ret_code = 0
4076: -- singlepiece and multipiece rates are both found
4077: -- compare the rates and use the lower rates
4078: l_set_num :=1;
4079: fte_qp_engine.get_total_base_price(p_set_num => l_set_num,
4080: x_price => l_standard_price ,
4081: x_return_status => l_return_status);
4082:
4083: fte_freight_pricing_util.set_location(p_loc=>'after get_total_base_price for set='||l_set_num);

Line 4093: fte_qp_engine.get_total_base_price(p_set_num => l_set_num,

4089: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_standard_price = '||l_standard_price);
4090: END IF;
4091:
4092: l_set_num :=2;
4093: fte_qp_engine.get_total_base_price(p_set_num => l_set_num,
4094: x_price => l_hundredwt_price,
4095: x_return_status => l_return_status);
4096:
4097: fte_freight_pricing_util.set_location(p_loc=>'after get_total_base_price for set='||l_set_num);

Line 4109: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,

4105:
4106: IF (l_standard_price <= l_hundredwt_price) THEN
4107: -- standard rates apply. delete set 2
4108: l_set_num :=2; --set to delete
4109: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
4110: x_return_status => l_return_status);
4111:
4112: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
4113: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

Line 4125: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,

4121: l_set_num :=1; -- remaining set apply_min_charge to be called with this
4122: ELSE
4123: -- hundredwt rates apply. delete set 1
4124: l_set_num :=1; --set to delete
4125: fte_qp_engine.delete_set_from_line_event( p_set_num => l_set_num,
4126: x_return_status => l_return_status);
4127:
4128: fte_freight_pricing_util.set_location(p_loc=>'after delete_set_from_line_event. set= '||l_set_num);
4129: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

Line 4157: FTE_QP_ENGINE.get_qp_output(

4153: p_rolledup_lines => fte_freight_pricing.g_rolledup_lines,
4154: x_return_status => l_return_status);
4155:
4156: --*** IMP ---
4157: FTE_QP_ENGINE.get_qp_output(
4158: x_qp_output_line_rows => x_qp_output_line_rows,
4159: x_qp_output_detail_rows => x_qp_output_detail_rows,
4160: x_return_status => l_return_status);
4161:

Line 4298: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;

4294: fte_freight_pricing_util.reset_dbg_vars;
4295: fte_freight_pricing_util.set_method(l_log_level,'process_others');
4296:
4297: -- create standard engine line and attributes (default stuff created by pattern matching)
4298: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;
4299: fte_qp_engine.create_control_record(p_event_num => l_event_num,
4300: x_return_status => l_return_status );
4301:
4302: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');

Line 4299: fte_qp_engine.create_control_record(p_event_num => l_event_num,

4295: fte_freight_pricing_util.set_method(l_log_level,'process_others');
4296:
4297: -- create standard engine line and attributes (default stuff created by pattern matching)
4298: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;
4299: fte_qp_engine.create_control_record(p_event_num => l_event_num,
4300: x_return_status => l_return_status );
4301:
4302: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
4303: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

Line 4312: fte_qp_engine.create_line_record (p_pricing_control_rec => p_pricing_control_rec,

4308: l_set_num := 1;
4309: i := p_pricing_engine_rows.FIRST;
4310: IF (i IS NOT NULL) THEN
4311: LOOP
4312: fte_qp_engine.create_line_record (p_pricing_control_rec => p_pricing_control_rec,
4313: p_pricing_engine_input_rec => p_pricing_engine_rows(i),
4314: x_return_status => l_return_status);
4315:
4316: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);

Line 4322: fte_qp_engine.prepare_qp_line_qualifiers(

4318: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4319: raise fte_freight_pricing_util.g_create_line_record_failed;
4320: END IF;
4321:
4322: fte_qp_engine.prepare_qp_line_qualifiers(
4323: p_event_num => l_event_num,
4324: p_pricing_control_rec => p_pricing_control_rec,
4325: p_input_index => p_pricing_engine_rows(i).input_index,
4326: x_return_status => l_return_status);

Line 4334: fte_qp_engine.prepare_qp_line_attributes (

4330: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4331: raise fte_freight_pricing_util.g_create_qualifiers_failed;
4332: END IF;
4333:
4334: fte_qp_engine.prepare_qp_line_attributes (
4335: p_event_num => l_event_num,
4336: p_input_index => p_pricing_engine_rows(i).input_index,
4337: p_attr_rows => p_pricing_attribute_rows,
4338: x_return_status => l_return_status);

Line 4352: -- fte_qp_engine.print_qp_input_lines(1);

4348: END LOOP;
4349: END IF;
4350:
4351:
4352: -- fte_qp_engine.print_qp_input_lines(1);
4353:
4354: -- call qp api
4355: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => x_qp_output_line_rows,
4356: x_qp_output_detail_rows => x_qp_output_detail_rows,

Line 4355: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => x_qp_output_line_rows,

4351:
4352: -- fte_qp_engine.print_qp_input_lines(1);
4353:
4354: -- call qp api
4355: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => x_qp_output_line_rows,
4356: x_qp_output_detail_rows => x_qp_output_detail_rows,
4357: x_return_status => l_return_status);
4358:
4359: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');

Line 4367: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);

4363: END IF;
4364: END IF;
4365:
4366: --check for errors in the output
4367: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
4368: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
4369: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4370: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4371: raise fte_freight_pricing_util.g_qp_price_request_failed_2;

Line 4375: fte_qp_engine.print_qp_output();

4371: raise fte_freight_pricing_util.g_qp_price_request_failed_2;
4372: END IF;
4373: END IF;
4374:
4375: fte_qp_engine.print_qp_output();
4376:
4377: post_process(
4378: p_event_num => l_event_num,
4379: p_set_num => l_set_num,

Line 4754: l_pricing_control_rec.pricing_event_num := fte_qp_engine.G_LINE_EVENT_NUM;

4750: -- set up data structure to call QP
4751: -- call QP
4752: -- check qp output for any errors
4753:
4754: l_pricing_control_rec.pricing_event_num := fte_qp_engine.G_LINE_EVENT_NUM;
4755: l_pricing_control_rec.currency_code := l_currency_code;
4756: l_pricing_control_rec.lane_id := p_lane_info.lane_id;
4757: l_pricing_control_rec.price_list_id := p_lane_info.pricelist_id;
4758: l_pricing_control_rec.party_id := p_lane_info.carrier_id;

Line 4797: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;

4793:
4794: END LOOP;
4795:
4796: -- create standard engine line and attributes (default stuff created by pattern matching)
4797: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;
4798: fte_qp_engine.create_control_record(p_event_num => l_event_num,
4799: x_return_status => l_return_status );
4800:
4801: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');

Line 4798: fte_qp_engine.create_control_record(p_event_num => l_event_num,

4794: END LOOP;
4795:
4796: -- create standard engine line and attributes (default stuff created by pattern matching)
4797: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;
4798: fte_qp_engine.create_control_record(p_event_num => l_event_num,
4799: x_return_status => l_return_status );
4800:
4801: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
4802: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

Line 4811: fte_qp_engine.create_line_record (p_pricing_control_rec => l_pricing_control_rec,

4807: --l_set_num := 1;
4808: i := l_pricing_engine_rows.FIRST;
4809: IF (i IS NOT NULL) THEN
4810: LOOP
4811: fte_qp_engine.create_line_record (p_pricing_control_rec => l_pricing_control_rec,
4812: p_pricing_engine_input_rec => l_pricing_engine_rows(i),
4813: x_return_status => l_return_status);
4814:
4815: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);

Line 4821: fte_qp_engine.prepare_qp_line_qualifiers(

4817: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4818: raise FND_API.G_EXC_ERROR;
4819: END IF;
4820:
4821: fte_qp_engine.prepare_qp_line_qualifiers(
4822: p_event_num => l_event_num,
4823: p_pricing_control_rec => l_pricing_control_rec,
4824: p_input_index => l_pricing_engine_rows(i).input_index,
4825: x_return_status => l_return_status);

Line 4833: fte_qp_engine.prepare_qp_line_attributes (

4829: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4830: raise FND_API.G_EXC_ERROR;
4831: END IF;
4832:
4833: fte_qp_engine.prepare_qp_line_attributes (
4834: p_event_num => l_event_num,
4835: p_input_index => l_pricing_engine_rows(i).input_index,
4836: p_attr_rows => l_pricing_attribute_rows,
4837: x_return_status => l_return_status);

Line 4851: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => l_qp_output_line_rows,

4847: END LOOP;
4848: END IF;
4849:
4850: -- call qp api
4851: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => l_qp_output_line_rows,
4852: x_qp_output_detail_rows => l_qp_output_detail_rows,
4853: x_return_status => l_return_status);
4854:
4855: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');

Line 4862: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);

4858: raise FND_API.G_EXC_ERROR;
4859: END IF;
4860:
4861: --check for errors in the output
4862: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
4863: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
4864: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4865: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4866: raise FND_API.G_EXC_ERROR;

Line 4869: fte_qp_engine.print_qp_output();

4865: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4866: raise FND_API.G_EXC_ERROR;
4867: END IF;
4868:
4869: fte_qp_engine.print_qp_output();
4870:
4871: IF (g_special_flags.minimum_charge_flag = 'Y') THEN
4872:
4873: apply_min_charge(

Line 4887: l_event_num := fte_qp_engine.G_CHARGE_EVENT_NUM;

4883: END IF;
4884:
4885: -- create request lines for the next event and call qp engine
4886: IF (l_charge_applied = 'Y') THEN
4887: l_event_num := fte_qp_engine.G_CHARGE_EVENT_NUM;
4888: fte_qp_engine.prepare_next_event_request ( x_return_status => l_return_status);
4889:
4890: fte_freight_pricing_util.set_location(p_loc=>'after prepare_next_event_request');
4891: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

Line 4888: fte_qp_engine.prepare_next_event_request ( x_return_status => l_return_status);

4884:
4885: -- create request lines for the next event and call qp engine
4886: IF (l_charge_applied = 'Y') THEN
4887: l_event_num := fte_qp_engine.G_CHARGE_EVENT_NUM;
4888: fte_qp_engine.prepare_next_event_request ( x_return_status => l_return_status);
4889:
4890: fte_freight_pricing_util.set_location(p_loc=>'after prepare_next_event_request');
4891: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4892: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

Line 4896: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => l_qp_output_line_rows,

4892: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
4893: raise FND_API.G_EXC_ERROR;
4894: END IF;
4895:
4896: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => l_qp_output_line_rows,
4897: x_qp_output_detail_rows => l_qp_output_detail_rows,
4898: x_return_status => l_return_status);
4899:
4900: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 2');

Line 4907: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);

4903: raise FND_API.G_EXC_ERROR;
4904: END IF;
4905:
4906: --check for errors in the output
4907: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
4908: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
4909: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
4910: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4911: raise FND_API.G_EXC_ERROR;

Line 4914: fte_qp_engine.print_qp_output();

4910: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
4911: raise FND_API.G_EXC_ERROR;
4912: END IF;
4913:
4914: fte_qp_engine.print_qp_output();
4915:
4916: END IF; -- l_charge_applied = 'Y'
4917:
4918: -- process qp output

Line 5697: l_pricing_control_rec.pricing_event_num := fte_qp_engine.G_LINE_EVENT_NUM;

5693: -- set up data structure to call QP
5694: -- call QP
5695: -- check qp output for any errors
5696:
5697: l_pricing_control_rec.pricing_event_num := fte_qp_engine.G_LINE_EVENT_NUM;
5698: l_pricing_control_rec.currency_code := l_currency_code;
5699: l_pricing_control_rec.lane_id := p_lane_info.lane_id;
5700: l_pricing_control_rec.price_list_id := p_lane_info.pricelist_id;
5701: l_pricing_control_rec.party_id := p_lane_info.carrier_id;

Line 5731: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;

5727:
5728:
5729:
5730: -- create standard engine line and attributes (default stuff created by pattern matching)
5731: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;
5732: fte_qp_engine.create_control_record(p_event_num => l_event_num,
5733: x_return_status => l_return_status );
5734:
5735: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');

Line 5732: fte_qp_engine.create_control_record(p_event_num => l_event_num,

5728:
5729:
5730: -- create standard engine line and attributes (default stuff created by pattern matching)
5731: l_event_num := fte_qp_engine.G_LINE_EVENT_NUM;
5732: fte_qp_engine.create_control_record(p_event_num => l_event_num,
5733: x_return_status => l_return_status );
5734:
5735: fte_freight_pricing_util.set_location(p_loc=>'after create_control_record ');
5736: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

Line 5745: fte_qp_engine.create_line_record (p_pricing_control_rec => l_pricing_control_rec,

5741: --l_set_num := 1;
5742: i := l_pricing_engine_rows.FIRST;
5743: IF (i IS NOT NULL) THEN
5744: LOOP
5745: fte_qp_engine.create_line_record (p_pricing_control_rec => l_pricing_control_rec,
5746: p_pricing_engine_input_rec => l_pricing_engine_rows(i),
5747: x_return_status => l_return_status);
5748:
5749: fte_freight_pricing_util.set_location(p_loc=>'after create_line_record. i='||i);

Line 5755: fte_qp_engine.prepare_qp_line_qualifiers(

5751: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5752: raise FND_API.G_EXC_ERROR;
5753: END IF;
5754:
5755: fte_qp_engine.prepare_qp_line_qualifiers(
5756: p_event_num => l_event_num,
5757: p_pricing_control_rec => l_pricing_control_rec,
5758: p_input_index => l_pricing_engine_rows(i).input_index,
5759: x_return_status => l_return_status);

Line 5767: fte_qp_engine.prepare_qp_line_attributes (

5763: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5764: raise FND_API.G_EXC_ERROR;
5765: END IF;
5766:
5767: fte_qp_engine.prepare_qp_line_attributes (
5768: p_event_num => l_event_num,
5769: p_input_index => l_pricing_engine_rows(i).input_index,
5770: p_attr_rows => l_pricing_attribute_rows,
5771: x_return_status => l_return_status);

Line 5785: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => l_qp_output_line_rows,

5781: END LOOP;
5782: END IF;
5783:
5784: -- call qp api
5785: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => l_qp_output_line_rows,
5786: x_qp_output_detail_rows => l_qp_output_detail_rows,
5787: x_return_status => l_return_status);
5788:
5789: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 1');

Line 5796: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);

5792: raise FND_API.G_EXC_ERROR;
5793: END IF;
5794:
5795: --check for errors in the output
5796: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
5797: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
5798: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5799: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5800: raise FND_API.G_EXC_ERROR;

Line 5803: fte_qp_engine.print_qp_output();

5799: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5800: raise FND_API.G_EXC_ERROR;
5801: END IF;
5802:
5803: fte_qp_engine.print_qp_output();
5804:
5805: IF (g_special_flags.minimum_charge_flag = 'Y') THEN
5806:
5807: apply_min_charge(

Line 5821: l_event_num := fte_qp_engine.G_CHARGE_EVENT_NUM;

5817: END IF;
5818:
5819: -- create request lines for the next event and call qp engine
5820: IF (l_charge_applied = 'Y') THEN
5821: l_event_num := fte_qp_engine.G_CHARGE_EVENT_NUM;
5822: fte_qp_engine.prepare_next_event_request ( x_return_status => l_return_status);
5823:
5824: fte_freight_pricing_util.set_location(p_loc=>'after prepare_next_event_request');
5825: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

Line 5822: fte_qp_engine.prepare_next_event_request ( x_return_status => l_return_status);

5818:
5819: -- create request lines for the next event and call qp engine
5820: IF (l_charge_applied = 'Y') THEN
5821: l_event_num := fte_qp_engine.G_CHARGE_EVENT_NUM;
5822: fte_qp_engine.prepare_next_event_request ( x_return_status => l_return_status);
5823:
5824: fte_freight_pricing_util.set_location(p_loc=>'after prepare_next_event_request');
5825: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5826: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN

Line 5830: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => l_qp_output_line_rows,

5826: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING ) THEN
5827: raise FND_API.G_EXC_ERROR;
5828: END IF;
5829:
5830: fte_qp_engine.call_qp_api ( x_qp_output_line_rows => l_qp_output_line_rows,
5831: x_qp_output_detail_rows => l_qp_output_detail_rows,
5832: x_return_status => l_return_status);
5833:
5834: fte_freight_pricing_util.set_location(p_loc=>'after call_qp_api: Event 2');

Line 5841: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);

5837: raise FND_API.G_EXC_ERROR;
5838: END IF;
5839:
5840: --check for errors in the output
5841: fte_qp_engine.check_qp_output_errors (x_return_status => l_return_status);
5842: fte_freight_pricing_util.set_location(p_loc=>'after check_qp_output_errors: Event '||l_event_num);
5843: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
5844: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5845: raise FND_API.G_EXC_ERROR;

Line 5848: fte_qp_engine.print_qp_output();

5844: l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
5845: raise FND_API.G_EXC_ERROR;
5846: END IF;
5847:
5848: fte_qp_engine.print_qp_output();
5849:
5850: END IF; -- l_charge_applied = 'Y'
5851:
5852: -- process qp output