DBA Data[Home] [Help]

APPS.QP_PREQ_GRP dependencies on FND_PROFILE

Line 382: G_QP_DEBUG_PROFILE_VALUE := FND_PROFILE.VALUE(v_debug_switch);

378: l_routine VARCHAR2(30) := 'Set_QP_Debug';
379: v_debug_switch CONSTANT VARCHAR2(30) := 'QP_DEBUG';
380:
381: BEGIN
382: G_QP_DEBUG_PROFILE_VALUE := FND_PROFILE.VALUE(v_debug_switch);
383:
384: -- If Time Log is on then only Time Log messages should be printed.
385: -- Time Log will be on if Profiles QP:Debug is set to Time Log
386: -- and OM:Debug Level is set to 1.

Line 390: AND FND_PROFILE.VALUE('ONT_DEBUG_LEVEL') = 1 THEN

386: -- and OM:Debug Level is set to 1.
387: -- Internal Bug# 8459818
388:
389: IF G_QP_DEBUG_PROFILE_VALUE = G_TIME_LOG_DBG_LEVEL
390: AND FND_PROFILE.VALUE('ONT_DEBUG_LEVEL') = 1 THEN
391: oe_debug_pub.SetDebugLevel(1);
392: oe_debug_pub.Initialize;
393: oe_debug_pub.debug_on;
394:

Line 399: ELSIF FND_PROFILE.VALUE('ONT_DEBUG_LEVEL') = 5 THEN

395: l_output_file := oe_debug_pub.Set_Debug_Mode('FILE');
396: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
397: engine_debug ('The output file is : ' || l_output_file );
398: END IF;
399: ELSIF FND_PROFILE.VALUE('ONT_DEBUG_LEVEL') = 5 THEN
400: l_output_file := oe_debug_pub.Set_Debug_Mode('FILE');
401: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
402: engine_debug ('The output file is : ' || l_output_file );
403: END IF;

Line 7726: G_INV_DECIMAL_PRECISION := nvl(FND_PROFILE.Value('QP_INV_DECIMAL_PRECISION'),10);

7722: END IF;
7723:
7724: -- bug 3572594 - round the multiplied value to profile QP_INV_DECIMAL_PRECISION
7725: if G_INV_DECIMAL_PRECISION is null then
7726: G_INV_DECIMAL_PRECISION := nvl(FND_PROFILE.Value('QP_INV_DECIMAL_PRECISION'),10);
7727: end if;
7728: /*
7729: INDX,QP_PREQ_GRP.source_vol_contexts_attributes.source_vol_contexts_attributes_upd4,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
7730: INDX,QP_PREQ_GRP.source_vol_contexts_attributes.source_vol_contexts_attributes_upd4,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2

Line 8320: --l_cascade_ask_for_profile VARCHAR2(2):= nvl(FND_PROFILE.value ('QP_CASCADE_ASK_FOR_PROMOTION'), G_NO);

8316: --added by yangli for Java Engine project
8317:
8318: -- begin declare shu fix bug 1728757
8319: l_list_header_id qp_qualifiers.list_header_id%type := NULL;
8320: --l_cascade_ask_for_profile VARCHAR2(2):= nvl(FND_PROFILE.value ('QP_CASCADE_ASK_FOR_PROMOTION'), G_NO);
8321: l_cascade_ask_for_profile VARCHAR2(2):= G_NO;
8322: l_ask_for_flag qp_list_headers_b.ask_for_flag%type := NULL;
8323:
8324: CURSOR get_ask_for_flag_cur (l_list_header_id IN NUMBER) IS

Line 12044: l_max_decimal_digits PLS_INTEGER := nvl(FND_PROFILE.Value ('QP_INV_DECIMAL_PRECISION'),10); --shu

12040: --type refcur is ref cursor;
12041:
12042: --l_price_break_detail_cur refcur;
12043: l_total_item_quantity NUMBER; -- shu
12044: l_max_decimal_digits PLS_INTEGER := nvl(FND_PROFILE.Value ('QP_INV_DECIMAL_PRECISION'),10); --shu
12045:
12046: l_break_uom_code VARCHAR2(3); /* Proration */
12047: l_break_uom_context VARCHAR2(30); /* Proration */
12048: l_break_uom_attribute VARCHAR2(30); /* Proration */

Line 12067: G_BREAK_UOM_PRORATION := nvl(fnd_profile.value('QP_BREAK_UOM_PRORATION'), G_NULL_PROFILE_VALUE);

12063:
12064: --product uom code is different than order uom code
12065: --and attribute is quantity than we need to do uom conversion
12066: if G_BREAK_UOM_PRORATION is null then
12067: G_BREAK_UOM_PRORATION := nvl(fnd_profile.value('QP_BREAK_UOM_PRORATION'), G_NULL_PROFILE_VALUE);
12068: end if;
12069:
12070: N := 1;
12071:

Line 16302: -- G_QUALIFY_SECONDARY := NVL(FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS'),'N');--profile option

16298:
16299: E_ROUTINE_ERRORS EXCEPTION;
16300: BEGIN
16301: qp_debug_util.tstart('PERFORM_SECONDARY_SEARCH','Performing Secondary Price List Search');
16302: -- G_QUALIFY_SECONDARY := NVL(FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS'),'N');--profile option
16303: -- Update the price list id , validated flag , and primary_qualifiers_match flag for sec search
16304: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN --4033618
16305: engine_debug ('QP_QUALIFY_SECONDARY_PRICE_LISTS:' || G_QUALIFY_SECONDARY);
16306: END IF;

Line 22049: --G_CURRENT_USER_OP_UNIT := NVL(p_control_rec.PRICING_ORG_ID, FND_PROFILE.VALUE('ORG_ID')); -- security

22045:
22046:
22047: BEGIN
22048:
22049: --G_CURRENT_USER_OP_UNIT := NVL(p_control_rec.PRICING_ORG_ID, FND_PROFILE.VALUE('ORG_ID')); -- security
22050: x_status_code := fnd_api.g_ret_sts_success;
22051:
22052: qp_debug_util.tstart('PERFORM_SECONDARY_PAT_SEARCH','Performing Secondary Price List Pattern Search', false, true);
22053:

Line 27070: l_satis_quals_opt := nvl(fnd_profile.value('QP_SATIS_QUALS_OPT'), 'Y');

27066: engine_debug('Before Big Select');
27067:
27068: END IF;
27069: --hw
27070: l_satis_quals_opt := nvl(fnd_profile.value('QP_SATIS_QUALS_OPT'), 'Y');
27071: --[julin/pricebook]
27072: IF nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES THEN
27073: l_satis_quals_opt := 'N';
27074: END IF;

Line 35642: v_price_round_options VARCHAR2(30):= FND_PROFILE.Value('QP_SELLING_PRICE_ROUNDING_OPTIONS'); --shu, new rounding

35638: l_line_unit_price NUMBER:= NULL; -- shu, default to null, fix bug 2354422, avoid division zero
35639: l_line_adjusted_unit_price NUMBER:= NULL;
35640: l_conversion_rate NUMBER:= NULL; -- shu, to fix bug 2354422
35641: l_order_uom_selling_price NUMBER:= NULL; -- bug 2693700
35642: v_price_round_options VARCHAR2(30):= FND_PROFILE.Value('QP_SELLING_PRICE_ROUNDING_OPTIONS'); --shu, new rounding
35643:
35644: E_CAL_ENGINE_ERROR EXCEPTION;
35645:
35646: BEGIN

Line 35665: l_GSA_Enabled_Flag := FND_PROFILE.VALUE(G_GSA_Max_Discount_Enabled);

35661: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
35662: engine_debug( '-------------In call calculation engine-----------');
35663: END IF;
35664:
35665: l_GSA_Enabled_Flag := FND_PROFILE.VALUE(G_GSA_Max_Discount_Enabled);
35666:
35667: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
35668: engine_debug ('GSA Enabled Flag : ' || l_GSA_Enabled_Flag);
35669: engine_debug ('Freeze_override_flag: '||p_freeze_override_flag);

Line 36568: l_pass_qualifiers varchar2(10) := FND_PROFILE.VALUE('QP_PASS_QUALIFIERS_TO_GET_CUSTOM');

36564: l_msg_context VARCHAR2(240);
36565: l_rows NATURAL := 5000;
36566:
36567: -- Bug 2772214
36568: l_pass_qualifiers varchar2(10) := FND_PROFILE.VALUE('QP_PASS_QUALIFIERS_TO_GET_CUSTOM');
36569:
36570: -- added for formula messages
36571: E_ATTRIBUTE_NON_NUMERIC EXCEPTION;
36572: CURSOR am_attr_cols_cur

Line 37472: AND hn.HIERARCHY_TYPE = FND_PROFILE.VALUE('QP_PRICING_PARTY_HIERARCHY_TYPE')

37468: AND qs.PARTY_HIERARCHY_ENABLED_FLAG = 'Y'
37469: AND nvl(qs.user_format_type, qs.seeded_format_type) = G_NUMERIC
37470: AND hn.CHILD_ID = to_number(qnlat.VALUE_FROM)
37471: AND hn.child_table_name = 'HZ_PARTIES'
37472: AND hn.HIERARCHY_TYPE = FND_PROFILE.VALUE('QP_PRICING_PARTY_HIERARCHY_TYPE')
37473: AND trunc(nvl(hn.EFFECTIVE_START_DATE,sysdate)) <= trunc(sysdate)
37474: AND trunc(nvl(hn.EFFECTIVE_END_DATE,sysdate)) >= trunc(sysdate)
37475: AND hn.LEVEL_NUMBER > 0;
37476:

Line 37690: IF NVL(FND_PROFILE.VALUE(QP_PREQ_GRP.G_BLIND_DISCOUNT),'N') = 'Y'

37686: THEN
37687: engine_debug(l_routine || 'inseting pattern_id -2 and -3');
37688: END IF;
37689:
37690: IF NVL(FND_PROFILE.VALUE(QP_PREQ_GRP.G_BLIND_DISCOUNT),'N') = 'Y'
37691: THEN
37692: INSERT INTO qp_npreq_line_patrns_tmp(line_index, pattern_id, hash_key)
37693: SELECT line_index, -2, 'BLIND'
37694: FROM qp_npreq_lines_tmp;

Line 39771: l_satis_quals_opt := nvl(fnd_profile.value('QP_SATIS_QUALS_OPT'), G_NO);

39767: END LOOP;
39768:
39769: qp_debug_util.tstop('POPULATE_PAT_TEMP_TABLES_QR3');
39770:
39771: l_satis_quals_opt := nvl(fnd_profile.value('QP_SATIS_QUALS_OPT'), G_NO);
39772:
39773: --[julin/pricebook] -- pat impact
39774: IF nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES THEN
39775: l_satis_quals_opt := G_NO;

Line 40705: L_RETURN_MANUAL_DISCOUNT VARCHAR2(1) := nvl(FND_PROFILE.VALUE('QP_RETURN_MANUAL_DISCOUNTS'),'N');

40701: l_formula_processing VARCHAR2(1) := 'N'; --8892565
40702:
40703: -- Essilor Fix bug 2789138
40704: L_MANUAL_ADJUSTMENTS_CALL_FLAG VARCHAR2(1) := 'N';
40705: L_RETURN_MANUAL_DISCOUNT VARCHAR2(1) := nvl(FND_PROFILE.VALUE('QP_RETURN_MANUAL_DISCOUNTS'),'N');
40706:
40707: E_SEARCH_FLAG_IS_NULL EXCEPTION;
40708: E_INVALID_CONTROL_RECORD EXCEPTION;
40709: E_ROUTINE_ERRORS EXCEPTION;

Line 41192: l_limits_installed VARCHAR2(1) := FND_PROFILE.VALUE('QP_LIMITS_INSTALLED');

41188: -- end changes
41189:
41190: l_trans VARCHAR2(1);
41191: l_install_status VARCHAR2(1);
41192: l_limits_installed VARCHAR2(1) := FND_PROFILE.VALUE('QP_LIMITS_INSTALLED');
41193: --added by yangli for Java Engine 3086881
41194: l_begin_time number;
41195: l_end_time number;
41196: l_request_id number;

Line 41212: G_PAT_SEARCH_PATH := NVL(FND_PROFILE.VALUE('QP_PATTERN_SEARCH_PATH'),2);

41208:
41209: QP_PREQ_GRP.Set_QP_Debug;
41210:
41211: --KDURGASI changes for pattern based select modifiers
41212: G_PAT_SEARCH_PATH := NVL(FND_PROFILE.VALUE('QP_PATTERN_SEARCH_PATH'),2);
41213: G_QP_PATTERN_SEARCH := NVL(FND_PROFILE.VALUE('QP_PATTERN_SEARCH'),'N');
41214: G_LIN_QTY_ATTR_SRCD := 'N';
41215:
41216: SELECT DECODE(G_PAT_SEARCH_PATH,1,'Search Headers First','Search Lines First') INTO l_patrn_srch_path_desc FROM dual;

Line 41213: G_QP_PATTERN_SEARCH := NVL(FND_PROFILE.VALUE('QP_PATTERN_SEARCH'),'N');

41209: QP_PREQ_GRP.Set_QP_Debug;
41210:
41211: --KDURGASI changes for pattern based select modifiers
41212: G_PAT_SEARCH_PATH := NVL(FND_PROFILE.VALUE('QP_PATTERN_SEARCH_PATH'),2);
41213: G_QP_PATTERN_SEARCH := NVL(FND_PROFILE.VALUE('QP_PATTERN_SEARCH'),'N');
41214: G_LIN_QTY_ATTR_SRCD := 'N';
41215:
41216: SELECT DECODE(G_PAT_SEARCH_PATH,1,'Search Headers First','Search Lines First') INTO l_patrn_srch_path_desc FROM dual;
41217:

Line 41242: --G_QP_DEBUG_PROFILE_VALUE := FND_PROFILE.VALUE(v_debug_switch);

41238:
41239: qp_debug_util.tstart('ENGINE_CALL_QPXGPREB','QPXGPREB Price Engine Call (Lines - '||l_lines_cnt||')');
41240:
41241: --==========START: Debug Viewere needed by JAVA and PL/SQL engine=======
41242: --G_QP_DEBUG_PROFILE_VALUE := FND_PROFILE.VALUE(v_debug_switch);
41243: G_PUBLIC_API_CALL_FLAG := nvl(p_control_rec.public_api_call_flag,'N');
41244:
41245: -- Set the G_DEBUG_ENGINE if the call is not from public API
41246: IF (G_PUBLIC_API_CALL_FLAG = G_NO) THEN

Line 41339: G_MANUAL_DISCOUNT_FLAG := nvl(FND_PROFILE.VALUE(G_RETURN_MANUAL_DISCOUNTS),'Y'); --p_control_rec.manual_discount_flag;

41335:
41336: --dbms_output.put_line('Final Debug: ' || oe_debug_pub.g_debug);
41337: --G_DEBUG_ENGINE := FND_API.G_TRUE;
41338: --G_LINE_DETAIL_INDEX := 0;
41339: G_MANUAL_DISCOUNT_FLAG := nvl(FND_PROFILE.VALUE(G_RETURN_MANUAL_DISCOUNTS),'Y'); --p_control_rec.manual_discount_flag;
41340: G_GSA_CHECK_FLAG := p_control_rec.gsa_check_flag;
41341: G_GSA_DUP_CHECK_FLAG := nvl(p_control_rec.gsa_dup_check_flag,'N');
41342: --moved to top for both PL/SQL and Java Engine
41343: --G_TEMP_TABLE_INSERT_FLAG := nvl(p_control_rec.temp_table_insert_flag,'Y');

Line 41346: G_INSERT_FORMULA_STEP_VALUES := nvl(FND_PROFILE.VALUE('QP_INSERT_FORMULA_STEP_VALUES'),'Y');

41342: --moved to top for both PL/SQL and Java Engine
41343: --G_TEMP_TABLE_INSERT_FLAG := nvl(p_control_rec.temp_table_insert_flag,'Y');
41344: G_MANUAL_ADJUSTMENTS_CALL_FLAG := nvl(p_control_rec.manual_adjustments_call_flag,'N');
41345: G_INSERT_INTO_FORMULA_TMP := FALSE;
41346: G_INSERT_FORMULA_STEP_VALUES := nvl(FND_PROFILE.VALUE('QP_INSERT_FORMULA_STEP_VALUES'),'Y');
41347: G_BLIND_DISCOUNT_PROFILE := nvl(FND_PROFILE.VALUE(G_BLIND_DISCOUNT),'N');
41348: G_MULTI_CURRENCY_PROFILE := nvl(FND_PROFILE.VALUE(G_MULTI_CURRENCY),'N'); -- vivek
41349: G_QUALIFY_SECONDARY := NVL(FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS'),'N');--profile option
41350: --G_USE_MULTI_CURRENCY := p_control_rec.use_multi_currency; -- Vivek

Line 41347: G_BLIND_DISCOUNT_PROFILE := nvl(FND_PROFILE.VALUE(G_BLIND_DISCOUNT),'N');

41343: --G_TEMP_TABLE_INSERT_FLAG := nvl(p_control_rec.temp_table_insert_flag,'Y');
41344: G_MANUAL_ADJUSTMENTS_CALL_FLAG := nvl(p_control_rec.manual_adjustments_call_flag,'N');
41345: G_INSERT_INTO_FORMULA_TMP := FALSE;
41346: G_INSERT_FORMULA_STEP_VALUES := nvl(FND_PROFILE.VALUE('QP_INSERT_FORMULA_STEP_VALUES'),'Y');
41347: G_BLIND_DISCOUNT_PROFILE := nvl(FND_PROFILE.VALUE(G_BLIND_DISCOUNT),'N');
41348: G_MULTI_CURRENCY_PROFILE := nvl(FND_PROFILE.VALUE(G_MULTI_CURRENCY),'N'); -- vivek
41349: G_QUALIFY_SECONDARY := NVL(FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS'),'N');--profile option
41350: --G_USE_MULTI_CURRENCY := p_control_rec.use_multi_currency; -- Vivek
41351:

Line 41348: G_MULTI_CURRENCY_PROFILE := nvl(FND_PROFILE.VALUE(G_MULTI_CURRENCY),'N'); -- vivek

41344: G_MANUAL_ADJUSTMENTS_CALL_FLAG := nvl(p_control_rec.manual_adjustments_call_flag,'N');
41345: G_INSERT_INTO_FORMULA_TMP := FALSE;
41346: G_INSERT_FORMULA_STEP_VALUES := nvl(FND_PROFILE.VALUE('QP_INSERT_FORMULA_STEP_VALUES'),'Y');
41347: G_BLIND_DISCOUNT_PROFILE := nvl(FND_PROFILE.VALUE(G_BLIND_DISCOUNT),'N');
41348: G_MULTI_CURRENCY_PROFILE := nvl(FND_PROFILE.VALUE(G_MULTI_CURRENCY),'N'); -- vivek
41349: G_QUALIFY_SECONDARY := NVL(FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS'),'N');--profile option
41350: --G_USE_MULTI_CURRENCY := p_control_rec.use_multi_currency; -- Vivek
41351:
41352:

Line 41349: G_QUALIFY_SECONDARY := NVL(FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS'),'N');--profile option

41345: G_INSERT_INTO_FORMULA_TMP := FALSE;
41346: G_INSERT_FORMULA_STEP_VALUES := nvl(FND_PROFILE.VALUE('QP_INSERT_FORMULA_STEP_VALUES'),'Y');
41347: G_BLIND_DISCOUNT_PROFILE := nvl(FND_PROFILE.VALUE(G_BLIND_DISCOUNT),'N');
41348: G_MULTI_CURRENCY_PROFILE := nvl(FND_PROFILE.VALUE(G_MULTI_CURRENCY),'N'); -- vivek
41349: G_QUALIFY_SECONDARY := NVL(FND_PROFILE.VALUE('QP_QUALIFY_SECONDARY_PRICE_LISTS'),'N');--profile option
41350: --G_USE_MULTI_CURRENCY := p_control_rec.use_multi_currency; -- Vivek
41351:
41352:
41353: G_ORDER_ID := null; -- accum range break

Line 41360: G_USE_MULTI_CURRENCY := nvl(fnd_profile.value('QP_MULTI_CURRENCY_USAGE'), 'N');

41356: G_USE_MULTI_CURRENCY := p_control_rec.use_multi_currency;
41357: else
41358: -- Added new profile (QP_MULTI_CURRENCY_USAGE) with default value 'N' to maintain
41359: -- current behaviour,bug 2943033
41360: G_USE_MULTI_CURRENCY := nvl(fnd_profile.value('QP_MULTI_CURRENCY_USAGE'), 'N');
41361: end if;
41362:
41363: -- Essilor Fix bug 2789138
41364: L_MANUAL_ADJUSTMENTS_CALL_FLAG := nvl(p_control_rec.manual_adjustments_call_flag,NULL);

Line 41372: G_SECURITY_CONTROL := nvl(FND_PROFILE.VALUE('QP_SECURITY_CONTROL'), 'OFF'); --security

41368: G_MCURR_INSTALLED_USED := 'Y';
41369: ELSE
41370: G_MCURR_INSTALLED_USED := 'N';
41371: END IF;
41372: G_SECURITY_CONTROL := nvl(FND_PROFILE.VALUE('QP_SECURITY_CONTROL'), 'OFF'); --security
41373: G_CURRENT_USER_OP_UNIT := NVL(p_control_rec.org_id, QP_UTIL.GET_ORG_ID); --security
41374: -- [prarasto] changed to use get_org_id instead of profile for implementing MOAC
41375:
41376: --added for moac

Line 41535: l_bypass_pricing := FND_PROFILE.VALUE(G_BYPASS_PRICING);

41531:
41532: -- qp_number.canonical_mask := 'FM999999999999999999999.99999999999999999999999999999999999999';
41533:
41534:
41535: l_bypass_pricing := FND_PROFILE.VALUE(G_BYPASS_PRICING);
41536:
41537: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
41538: engine_debug ('Pricing Bypass : ' || l_bypass_pricing);
41539:

Line 41730: IF ( NVL(Fnd_Profile.value('QP_CUSTOM_IGNORE_PRICING'),'N') = 'Y') THEN

41726: -----------------END: Specific to PL/SQL Engine----------------------
41727: END IF;
41728:
41729: --ignore_pricing start 8203956
41730: IF ( NVL(Fnd_Profile.value('QP_CUSTOM_IGNORE_PRICING'),'N') = 'Y') THEN
41731: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
41732: QP_PREQ_GRP.engine_debug('ignore_pricing : Updating non-pricable lines 1');
41733: END IF;
41734: OPEN IGNORE_PRICE_LINES_CUR;

Line 41846: --G_AM_INSTALLED_PROFILE := nvl(FND_PROFILE.value('QP_ATTRIBUTE_MANAGER_INSTALLED'), G_YES); /* default is G_YES by yangli 03/12/2002*/

41842: INDX,QP_PREQ_GRP.price_request.price_request_sel1,FND_DESCR_FLEX_COL_USAGES_U1,APPLICATION_COLUMN_NAME,4
41843:
41844: INDX,QP_PREQ_GRP.price_request.price_request_sel1,FND_FLEX_VALUE_SETS_U1,FLEX_VALUE_SET_ID,1
41845: */
41846: --G_AM_INSTALLED_PROFILE := nvl(FND_PROFILE.value('QP_ATTRIBUTE_MANAGER_INSTALLED'), G_YES); /* default is G_YES by yangli 03/12/2002*/
41847: G_AM_INSTALLED_PROFILE := QP_UTIL.Attrmgr_Installed;
41848: /* by yangli 05/02/02*/
41849:
41850: IF G_AM_INSTALLED_PROFILE = G_YES THEN

Line 42584: IF(NVL(Fnd_Profile.value('QP_BEST_PRICE_FORMULA_EVALUATION'),'N')='Y') THEN

42580: engine_debug('list price after phase 1 :'||l_list_price);
42581: END IF;
42582:
42583: --best_price_formula evaluation project 8892565 begin
42584: IF(NVL(Fnd_Profile.value('QP_BEST_PRICE_FORMULA_EVALUATION'),'N')='Y') THEN
42585: IF (l_formula_processing = 'N') then
42586: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
42587: engine_debug ('Best price Formula Processing begin');
42588: END IF;

Line 42664: IF(NVL(Fnd_Profile.value('QP_BEST_PRICE_FORMULA_EVALUATION'),'N')='N') THEN

42660: END LOOP; --l_get_line_index_cur
42661:
42662: -- Formula Processing
42663: --best_price_formula evaluation project 8892565 begin
42664: IF(NVL(Fnd_Profile.value('QP_BEST_PRICE_FORMULA_EVALUATION'),'N')='N') THEN
42665: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
42666: engine_debug ('Normal flow Formula Processing begin');
42667: END IF;
42668: Formula_Processing(NULL, --J.LINE_INDEX,