APPS.IEX_DUNNING_PUB dependencies on FND_PROFILE

Line 7: G_Batch_Size NUMBER := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));

3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_DUNNING_PUB';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpdunb.pls';
7: G_Batch_Size NUMBER := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));
8:
9: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
10: PG_DEBUG NUMBER ;
11:

Line 9: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

5: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_DUNNING_PUB';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpdunb.pls';
7: G_Batch_Size NUMBER := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '100000'));
8:
9: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
10: PG_DEBUG NUMBER ;
11:
12: Procedure WriteLog ( p_msg IN VARCHAR2)
13: IS

Line 1895: l_default_rs_id := fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE');

1891: END IF;
1892: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: '|| nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All'));
1893: --End MOAC
1894:
1895: l_default_rs_id := fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE');
1896: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Default Resource Id = '||l_default_rs_id);
1897: WriteLog('Send_Dunning: ' || G_PKG_NAME || ' ' || l_api_name || ' - default_rs_id='||l_default_rs_id);
1898:
1899: if (l_default_rs_id = 0 or l_default_rs_id is null) then

Line 2313: l_cust_prof_chk := fnd_profile.value('IEX_DUNNING_CUST_PROF_CHECK');

2309:
2310: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'running level='||l_running_level);
2311: WriteLog('Send_Dunning: ' || G_PKG_NAME || ' ' || l_api_name || ' - running level='||l_running_level);
2312: --start bug 15933013
2313: l_cust_prof_chk := fnd_profile.value('IEX_DUNNING_CUST_PROF_CHECK');
2314: if l_cust_prof_chk is NULL then
2315: if l_running_level = 'DELINQUENCY' then
2316: l_cust_prof_chk := 'BILL_TO';
2317: else

Line 2590: l_migrated_data := nvl(fnd_profile.value('AR_DUNNING_TO_IEXDUNNING_MIGRATED'), 'Y');

2586: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SEND_DUNNING_CONCUR p_migration_mode = ' || p_migration_mode);
2587: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' p_migration_mode : ' || p_migration_mode);
2588: l_migration_mode := nvl(p_migration_mode,'FINAL');
2589:
2590: l_migrated_data := nvl(fnd_profile.value('AR_DUNNING_TO_IEXDUNNING_MIGRATED'), 'Y');
2591:
2592: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SEND_DUNNING_CONCUR l_migrated_data = ' || l_migrated_data);
2593:
2594: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' l_migrated_data : ' || l_migrated_data);

Line 2858: l_return := fnd_profile.save(x_name => 'IEX_PRT_IPP_PRINTER_NAME',

2854: and aging_bucket_id is not null;
2855: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Updated dunning_type as DAYS_OVERDUE for existing records in IEX_DUNNING_PLANS_B table.');
2856:
2857: --Set the Profile 'IEX: IPP Printer Name' as 'NOPRINT'.
2858: l_return := fnd_profile.save(x_name => 'IEX_PRT_IPP_PRINTER_NAME',
2859: x_value => 'NOPRINT',
2860: x_level_name => 'SITE',
2861: x_level_value => null,
2862: x_level_value_app_id => '',

Line 2871: l_return := fnd_profile.save(x_name => 'AR_DUNNING_TO_IEXDUNNING_MIGRATED',

2867: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Profile IEX: IPP Printer Name updated failed ');
2868: end if;
2869:
2870: --Set the Profile IEX: AR Dunning to IEX Dunning Migrated? as 'Y' i.e Yes.
2871: l_return := fnd_profile.save(x_name => 'AR_DUNNING_TO_IEXDUNNING_MIGRATED',
2872: x_value => 'Y',
2873: x_level_name => 'SITE',
2874: x_level_value => null,
2875: x_level_value_app_id => '',