APPS.OE_ORDER_IMPORT_WF dependencies on FND_PROFILE

Line 352: -- to_number(nvl(fnd_profile.value('ONT_DEBUG_LEVEL'),'0'));

348: l_retcode NUMBER;
349: l_order_source VARCHAR2(240) := '20';
350: l_operation_code VARCHAR2(30);
351: -- l_debug_level NUMBER :=
352: -- to_number(nvl(fnd_profile.value('ONT_DEBUG_LEVEL'),'0'));
353: l_request_id NUMBER;
354: l_msg_count NUMBER;
355: l_msg_data VARCHAR2(2000);
356: l_return_status VARCHAR2(1);

Line 361: fnd_profile.value('ONT_TRANSACTION_PROCESSING');

357:
358: new_request_id NUMBER;
359:
360: l_sync VARCHAR2(30) :=
361: fnd_profile.value('ONT_TRANSACTION_PROCESSING');
362:
363: l_phase VARCHAR2(30);
364: l_status VARCHAR2(30);
365: l_dev_phase VARCHAR2(30);

Line 492: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);

488: );
489:
490:
491: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
492: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
493: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
494: IF l_debug_level > 0 THEN
495: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
496: END IF;

Line 1152: insert into alok values(fnd_profile.value('CONC_REQUEST_ID'));

1148:
1149: IF p_funcmode = 'RUN' THEN
1150: /*
1151: insert into alok values('222');
1152: insert into alok values(fnd_profile.value('CONC_REQUEST_ID'));
1153: oe_debug_pub.G_DEBUG_MODE := 'FILE';
1154: oe_debug_pub.Debug_ON;
1155: */
1156: IF l_debug_level > 0 THEN

Line 1161: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);

1157: oe_debug_pub.add( 'ENTERING IS_PARTNER_SETUP PROCEDURE' ) ;
1158: END IF;
1159:
1160: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
1161: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
1162: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
1163: IF l_debug_level > 0 THEN
1164: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
1165: END IF;

Line 2241: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);

2237: );
2238: -- end bug 3688227
2239:
2240: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
2241: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
2242: l_customer_key_profile := nvl(l_customer_key_profile, 'N');
2243: IF l_debug_level > 0 THEN
2244: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
2245: END IF;

Line 2783: l_debug_level_cln CONSTANT NUMBER := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));

2779: l_party_site_id Number;
2780: l_error_code Number;
2781: l_error_msg Varchar2(1000);
2782: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2783: l_debug_level_cln CONSTANT NUMBER := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
2784:
2785: Begin
2786:
2787: IF (l_debug_level > 0) THEN