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.OE_ORDER_ADJ_PVT dependencies on FND_PROFILE

Line 7: := nvl(fnd_profile.value('ONT_11IG_PERFORMANCE'),'Y');

3:
4: G_DEBUG BOOLEAN;
5: G_Pricing_Phase_Id_Tbl Char_Tbl_Type;
6: G_11iG_PERFORMANCE varchar2(1)
7: := nvl(fnd_profile.value('ONT_11IG_PERFORMANCE'),'Y');
8: G_CHARGES_FOR_INCLUDED_ITEM Varchar2(1) := nvl(fnd_profile.value('ONT_CHARGES_FOR_INCLUDED_ITEM'),'N');
9: G_REQUEST_ID NUMBER:=NULL;
10: G_ORDER_CURRENCY VARCHAR2(30);
11: G_IPL_ERRORS_TBL Index_Tbl_Type;

Line 8: G_CHARGES_FOR_INCLUDED_ITEM Varchar2(1) := nvl(fnd_profile.value('ONT_CHARGES_FOR_INCLUDED_ITEM'),'N');

4: G_DEBUG BOOLEAN;
5: G_Pricing_Phase_Id_Tbl Char_Tbl_Type;
6: G_11iG_PERFORMANCE varchar2(1)
7: := nvl(fnd_profile.value('ONT_11IG_PERFORMANCE'),'Y');
8: G_CHARGES_FOR_INCLUDED_ITEM Varchar2(1) := nvl(fnd_profile.value('ONT_CHARGES_FOR_INCLUDED_ITEM'),'N');
9: G_REQUEST_ID NUMBER:=NULL;
10: G_ORDER_CURRENCY VARCHAR2(30);
11: G_IPL_ERRORS_TBL Index_Tbl_Type;
12:

Line 788: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;

784: IF l_debug_level > 0 THEN
785: oe_debug_pub.add( 'CALLING OE_DBI_UTIL FOR HEADER PRICE ADJUSTMENTS' , 1 ) ;
786: oe_debug_pub.add( 'CACHED VALUE' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
787: oe_debug_pub.add( 'RECURSION VALUE' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;
788: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;
789: END IF;
790:
791: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N') = 'Y' AND
792: oe_order_cache.g_header_rec.booked_flag = 'Y' AND

Line 791: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N') = 'Y' AND

787: oe_debug_pub.add( 'RECURSION VALUE' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;
788: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;
789: END IF;
790:
791: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N') = 'Y' AND
792: oe_order_cache.g_header_rec.booked_flag = 'Y' AND
793: oe_order_util.g_recursion_without_exception = 'N' AND
794: l_control_rec.write_to_db
795: THEN

Line 1510: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;

1506: IF l_debug_level > 0 THEN
1507: oe_debug_pub.add( 'CALLING OE_DBI_UTIL FOR ORDER LINE PRICE ADJUSTMENTS' , 1 ) ;
1508: oe_debug_pub.add( 'CACHED VALUE' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
1509: oe_debug_pub.add( 'RECURSION VALUE' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;
1510: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;
1511: END IF;
1512:
1513: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N') = 'Y' AND
1514: oe_order_cache.g_header_rec.booked_flag = 'Y' AND

Line 1513: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N') = 'Y' AND

1509: oe_debug_pub.add( 'RECURSION VALUE' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;
1510: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;
1511: END IF;
1512:
1513: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N') = 'Y' AND
1514: oe_order_cache.g_header_rec.booked_flag = 'Y' AND
1515: oe_order_util.g_recursion_without_exception = 'N' AND
1516: l_control_rec.write_to_db
1517: THEN

Line 4252: fnd_profile.get('ONT_DISCOUNTING_PRIVILEGE', v_discounting_privilege);

4248:
4249: -- Added by JAUTOMO on 20-DEC-00
4250:
4251: -- Get Discounting Privilege Profile Option value
4252: fnd_profile.get('ONT_DISCOUNTING_PRIVILEGE', v_discounting_privilege);
4253:
4254: -- If the profile is set to UNLIMITED, then even if the Order Type
4255: -- restrict price changes, the user can change the price
4256:

Line 5437: /l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');/

5433: ,p_req_line_detail_rec QP_PREQ_GRP.line_detail_rec_type
5434: )
5435: is
5436: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
5437: /*l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');*/
5438: l_org_id NUMBER := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5439: l_ordered_item varchar2(300);
5440:
5441: begin

Line 5484: /l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');/

5480: procedure Get_item_for_iue(px_line_rec in out nocopy OE_Order_PUB.line_rec_type)
5481: is
5482: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
5483: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5484: /*l_org_id NUMBER := FND_PROFILE.Value('OE_ORGANIZATION_ID');*/
5485: l_ordered_item varchar2(300);
5486: cursor adj_cur is
5487: select modified_from from oe_price_adjustments
5488: where line_id=px_line_rec.line_id

Line 5576: l_bypass_pricing varchar2(30) := nvl(FND_PROFILE.VALUE('QP_BYPASS_PRICING'),'N');

5572: Process_Service_Lines Boolean := FALSE;
5573: l_related_lines_Index pls_integer;
5574: line_tbl_index pls_integer;
5575: i pls_integer;
5576: l_bypass_pricing varchar2(30) := nvl(FND_PROFILE.VALUE('QP_BYPASS_PRICING'),'N');
5577: l_dummy Varchar2(1);
5578: l_header_id NUMBER;
5579: l_any_frozen_line BOOLEAN:=FALSE;
5580: l_calculate_price_flag varchar2(1);

Line 5602: G_INT_CHANGED_LINE_ON Varchar2(3):= nvl(FND_PROFILE.VALUE('ONT_INTERNAL_CHANGED_LINE'),'Y');

5598: l_pass_all_lines VARCHAR2(30);
5599: l_exists_phase VARCHAR2(1) := 'N';
5600: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
5601: j PLS_INTEGER :=1;
5602: G_INT_CHANGED_LINE_ON Varchar2(3):= nvl(FND_PROFILE.VALUE('ONT_INTERNAL_CHANGED_LINE'),'Y');
5603: l_header_id2 NUMBER;
5604: begin
5605:
5606:

Line 8174: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');

8170: l_Total_Quantity Number;
8171: l_sign Number;
8172: l_rounding_factor Number;
8173: l_gsa_violation_action Varchar2(30); --moac moving the initialization to the body
8174: l_GSA_Enabled_Flag Varchar2(30) := FND_PROFILE.VALUE('QP_VERIFY_GSA');
8175: l_Sorted_Adjustment_Tbl oe_order_Adj_pvt.Sorted_Adjustment_Tbl_Type;
8176: l_Sort_Index Pls_Integer;
8177: l_pricing_quantity Number;
8178: l_assoc_exist Boolean;

Line 8819: if fnd_profile.value('OE_UNIT_PRICE_PRECISION_TYPE') = 'STANDARD' then

8815: l_precision,
8816: l_ext_precision,
8817: l_min_acct_unit);
8818:
8819: if fnd_profile.value('OE_UNIT_PRICE_PRECISION_TYPE') = 'STANDARD' then
8820: return l_precision;
8821: else
8822: return l_ext_precision;
8823: end if;

Line 9048: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');

9044: l pls_Integer;
9045: l_line_term Boolean := FALSE;
9046: l_price_list Varchar2(240);
9047: l_price_adjustment_id number;
9048: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');
9049: l_return_status varchar2(30);
9050: l_index NUMBER;
9051: l_request_id NUMBER;
9052: --btea perf begin

Line 9065: l_preinsert_manual_adj VARCHAR2(1):= Nvl(Fnd_Profile.Value('ONT_PREINSERT_MANUAL_ADJ'),'N');

9061: v_order_enforce_list_price varchar2(1):=NULL;
9062: v_line_enforce_list_price varchar2(1);
9063: l_invalid_line Varchar2(1):= 'N';
9064: --Manual begin
9065: l_preinsert_manual_adj VARCHAR2(1):= Nvl(Fnd_Profile.Value('ONT_PREINSERT_MANUAL_ADJ'),'N');
9066: --Manual end
9067: l_dummy_line_rec Oe_Order_Pub.Line_Rec_Type;
9068: l_limit_hold_action varchar2(30):=NVL(fnd_profile.value('ONT_PROMOTION_LIMIT_VIOLATION_ACTION'), 'NO_HOLD'); -- PROMOTIONS SEP/01
9069:

Line 9068: l_limit_hold_action varchar2(30):=NVL(fnd_profile.value('ONT_PROMOTION_LIMIT_VIOLATION_ACTION'), 'NO_HOLD'); -- PROMOTIONS SEP/01

9064: --Manual begin
9065: l_preinsert_manual_adj VARCHAR2(1):= Nvl(Fnd_Profile.Value('ONT_PREINSERT_MANUAL_ADJ'),'N');
9066: --Manual end
9067: l_dummy_line_rec Oe_Order_Pub.Line_Rec_Type;
9068: l_limit_hold_action varchar2(30):=NVL(fnd_profile.value('ONT_PROMOTION_LIMIT_VIOLATION_ACTION'), 'NO_HOLD'); -- PROMOTIONS SEP/01
9069:
9070: /* Promotional modifier issues - Bug 1503357 */
9071: l_delete_prg_lines index_tbl_type;
9072: l_num_changed_lines PLS_INTEGER := 0;

Line 9621: fnd_profile.get('ONT_DISCOUNTING_PRIVILEGE', v_discounting_privilege);

9617:
9618: -- Changes by JAUTOMO on 20-DEC-00 (bug# 1303352)
9619:
9620: -- Get Discounting Privilege Profile Option value
9621: fnd_profile.get('ONT_DISCOUNTING_PRIVILEGE', v_discounting_privilege);
9622:
9623: IF (v_order_enforce_list_price = 'Y') THEN
9624: v_line_enforce_list_price := 'Y';
9625: ELSE

Line 10842: IF (nvl(fnd_profile.value('ONT_ALWAYS_PERF_PATH'), 'N') = 'Y') THEN

10838: adj_debug('aso not installed');
10839: RETURN FALSE;
10840: End If;
10841:
10842: IF (nvl(fnd_profile.value('ONT_ALWAYS_PERF_PATH'), 'N') = 'Y') THEN
10843: adj_debug('always use performance path');
10844: RETURN FALSE;
10845: END IF;
10846:

Line 11141: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');

11137: l_x_msg_count number;
11138: l_x_msg_data Varchar2(2000);
11139: i pls_integer;
11140: l_line_index pls_integer;
11141: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');
11142: --Manual Begin
11143: --Set calculate price flag to 'P' when manual adjustment is applied
11144: l_set_price_flag_on_manual Varchar2(30) := nvl(fnd_profile.value('ONT_SET_PRICE_FLAG_ON_MANUAL'),'N');
11145: --Manual End

Line 11144: l_set_price_flag_on_manual Varchar2(30) := nvl(fnd_profile.value('ONT_SET_PRICE_FLAG_ON_MANUAL'),'N');

11140: l_line_index pls_integer;
11141: l_allow_negative_price Varchar2(30) := nvl(fnd_profile.value('ONT_NEGATIVE_PRICING'),'N');
11142: --Manual Begin
11143: --Set calculate price flag to 'P' when manual adjustment is applied
11144: l_set_price_flag_on_manual Varchar2(30) := nvl(fnd_profile.value('ONT_SET_PRICE_FLAG_ON_MANUAL'),'N');
11145: --Manual End
11146: l_dummy key_tbl_type;
11147: l_updated_flag varchar2(1);
11148: l_dummy_line_rec Oe_Order_Pub.Line_Rec_Type;

Line 12520: l_profile_value Varchar2(1):= Nvl(Fnd_Profile.Value('ONT_MANUAL_LINEGROUP'),'Y');

12516:
12517: --if no header id passed in this procedure it will return header id based on line id passed in
12518: )
12519: As
12520: l_profile_value Varchar2(1):= Nvl(Fnd_Profile.Value('ONT_MANUAL_LINEGROUP'),'Y');
12521: l_line_tbl oe_Order_Pub.Line_tbl_Type;
12522: l_line_rec oe_order_pub.line_rec_type;
12523: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
12524: l_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 12549: l_ask_for_profile Varchar2(1):=NVL(Fnd_Profile.Value('ONT_ASK_FOR_PROMOTION'),'Y');

12545: k PLS_INTEGER;
12546: line_tbl_index PLS_INTEGER;
12547: QP_ATTR_MAPPING_ERRORS Exception;
12548:
12549: l_ask_for_profile Varchar2(1):=NVL(Fnd_Profile.Value('ONT_ASK_FOR_PROMOTION'),'Y');
12550: l_dummy Varchar2(1);
12551:
12552: l_header_id Number;
12553: --indicates whether line has already been written to DB

Line 12592: --l_profile_value := Fnd_Profile.Value('QP_MANUAL_LINEGROUP');

12588: else
12589: oe_debug_pub.add('freight flag is false');
12590: end if;
12591: x_return_status:=FND_API.G_RET_STS_SUCCESS;
12592: --l_profile_value := Fnd_Profile.Value('QP_MANUAL_LINEGROUP');
12593: oe_debug_pub.add('Entering Get Manual Adj');
12594: --bucket man
12595: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
12596: oe_order_price_pvt.reset_all_tbls;