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

Line 105: l_debug := NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'),20);

101:
102: IEX_DEBUG('Program iextpinb.pls : *** IEX_ATA_PUB.Assign_Territory_Access starts ***');
103: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program iextpinb.pls : *** IEX_ATA_PUB.Asssign_Territory_Access starts ***');
104: FND_FILE.put_line(fnd_file.log, ' Strategy Level' || P_STR_LEVEL);
105: l_debug := NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'),20);
106: FND_FILE.put_line(fnd_file.log,'Value of Profile IEX: Debug Level(IEX_DEBUG_LEVEL) is : ' || l_debug);
107:
108: IF (MO_GLOBAL.GET_CURRENT_ORG_ID IS NULL) THEN
109: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || 'All');

Line 115: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

111: FND_FILE.PUT_LINE(FND_FILE.LOG,'Operating Unit Set : ' || MO_GLOBAL.GET_CURRENT_ORG_ID);
112: END IF;
113:
114: --Start changes by gnramasa on 29/08/2006 for bug # 5487449
115: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
116: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Level, Profile IEX: Territory Access Level(IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);
117:
118: -- Start for bug 8708291 pnaveenk
119: /* If iex_utilities.validate_running_level(l_Assignlevel) <> 'Y' then

Line 209: g_request_id := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));

205:
206: -- call SetUp() to verify parameters and set global variables and arrays
207: Set_Up(l_acct_qual_tbl);
208:
209: g_request_id := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
210: g_debug_flag := p_debug_mode;
211: g_run_mode := 'TOTAL'; --Bug5043777
212: g_prev_request_id := p_prev_request_id;
213:

Line 248: g_min_num_parallel_proc:=nvl(TO_NUMBER(fnd_profile.value('IEX_TERR_MIN_NUM_PARALLEL_PROC')),1);

244:
245: IEX_DEBUG('user hook return: ' || l_return_status);
246: END IF;
247:
248: g_min_num_parallel_proc:=nvl(TO_NUMBER(fnd_profile.value('IEX_TERR_MIN_NUM_PARALLEL_PROC')),1);
249: IEX_DEBUG('Min records for Parallel Processing (IEX_TERR_MIN_NUM_PARALLEL_PROC)=' || g_min_num_parallel_proc);
250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile IEX: Territory Minimum Number of Records for Parallel Processing : ' || g_min_num_parallel_proc);
251:
252: g_NumChildAccountWorker:=nvl(TO_NUMBER(fnd_profile.value('IEX_TAP_NUM_CHILD_ACCOUNT_WORKERS')),1);

Line 252: g_NumChildAccountWorker:=nvl(TO_NUMBER(fnd_profile.value('IEX_TAP_NUM_CHILD_ACCOUNT_WORKERS')),1);

248: g_min_num_parallel_proc:=nvl(TO_NUMBER(fnd_profile.value('IEX_TERR_MIN_NUM_PARALLEL_PROC')),1);
249: IEX_DEBUG('Min records for Parallel Processing (IEX_TERR_MIN_NUM_PARALLEL_PROC)=' || g_min_num_parallel_proc);
250: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Profile IEX: Territory Minimum Number of Records for Parallel Processing : ' || g_min_num_parallel_proc);
251:
252: g_NumChildAccountWorker:=nvl(TO_NUMBER(fnd_profile.value('IEX_TAP_NUM_CHILD_ACCOUNT_WORKERS')),1);
253: FND_FILE.PUT_LINE(FND_FILE.LOG,'Profile IEX: Number of Child Account Workers for TAP : ' || g_NumChildAccountWorker);
254: if g_NumChildAccountWorker < 1 then
255: g_NumChildAccountWorker:=1;
256: elsif g_NumChildAccountWorker > 10 then

Line 263: l_percent_analysed :=nvl(TO_NUMBER(fnd_profile.value('IEX_TAP_PERCENT_ANALYSED')),20);

259: FND_FILE.PUT_LINE(FND_FILE.LOG,'Max no. of Parallel Account Workers allowed for TAP is : ' || g_NumChildAccountWorker);
260: end if;
261: IEX_DEBUG('Max Parallel Account Workers (IEX_TAP_NUM_CHILD_ACCOUNT_WORKERS)=' || g_NumChildAccountWorker);
262:
263: l_percent_analysed :=nvl(TO_NUMBER(fnd_profile.value('IEX_TAP_PERCENT_ANALYSED')),20);
264: l_target_type := 'TOTAL';
265:
266: BEGIN
267: IEX_DEBUG('Starting JTY_ASSIGN_BULK_PUB.collect_trans_data...');

Line 434: l_profile_value := fnd_profile.value('AS_MC_MAX_ROLL_DAYS');

430: Concurrent_Profile_Options;
431:
432: -- get profile option - AS_MC_MAX_ROLL_DAYS
433: /*
434: l_profile_value := fnd_profile.value('AS_MC_MAX_ROLL_DAYS');
435: IF RTRIM(l_profile_value) IS NULL THEN
436: g_num_rollup_days := 0;
437: ELSE
438: g_num_rollup_days := TO_NUMBER(l_profile_value);

Line 442: g_conversion_type := fnd_profile.value('AS_MC_DAILY_CONVERSION_TYPE');

438: g_num_rollup_days := TO_NUMBER(l_profile_value);
439: END IF;
440:
441: -- get profile option - AS_MC_DAILY_CONVERSION_TYPE
442: g_conversion_type := fnd_profile.value('AS_MC_DAILY_CONVERSION_TYPE');
443: */
444: -- get profile option - number of child process
445: g_num_child_processes :=
446: TO_NUMBER(fnd_profile.value('IEX_TERR_NUM_CHILD_PROCESSES'));

Line 446: TO_NUMBER(fnd_profile.value('IEX_TERR_NUM_CHILD_PROCESSES'));

442: g_conversion_type := fnd_profile.value('AS_MC_DAILY_CONVERSION_TYPE');
443: */
444: -- get profile option - number of child process
445: g_num_child_processes :=
446: TO_NUMBER(fnd_profile.value('IEX_TERR_NUM_CHILD_PROCESSES'));
447: IEX_DEBUG('Mininum Child Process ' || g_num_child_processes);
448: -- get profile option - min number for parallel processing
449: g_min_num_parallel_proc :=
450: TO_NUMBER(NVL(fnd_profile.value('IEX_TERR_MIN_NUM_PARALLEL_PROC'), 3));

Line 450: TO_NUMBER(NVL(fnd_profile.value('IEX_TERR_MIN_NUM_PARALLEL_PROC'), 3));

446: TO_NUMBER(fnd_profile.value('IEX_TERR_NUM_CHILD_PROCESSES'));
447: IEX_DEBUG('Mininum Child Process ' || g_num_child_processes);
448: -- get profile option - min number for parallel processing
449: g_min_num_parallel_proc :=
450: TO_NUMBER(NVL(fnd_profile.value('IEX_TERR_MIN_NUM_PARALLEL_PROC'), 3));
451: IEX_DEBUG('Minimum Number of Prallel Proc ' || g_min_num_parallel_proc);
452:
453: -- fill in Account Qualifier Array
454: --Bug4654733. Fix by LKKUMAR on 06-Sep-2005. Remove AS dependency. Start

Line 491: g_user_id := TO_NUMBER(fnd_profile.value('USER_ID'));

487: BEGIN
488:
489:
490: -- get profile option - USER_ID
491: g_user_id := TO_NUMBER(fnd_profile.value('USER_ID'));
492:
493: -- get profile option -- CONC_PROGRAM_APPLICATION_ID
494: g_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
495:

Line 497: g_prog_id := TO_NUMBER(fnd_profile.value('CONC_PROGRAM_ID'));

493: -- get profile option -- CONC_PROGRAM_APPLICATION_ID
494: g_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
495:
496: -- get profile option -- CONC_PROGRAM_ID
497: g_prog_id := TO_NUMBER(fnd_profile.value('CONC_PROGRAM_ID'));
498:
499: -- get profile option -- CONC_LOGIN_ID
500: g_last_update_login := TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID'));
501:

Line 500: g_last_update_login := TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID'));

496: -- get profile option -- CONC_PROGRAM_ID
497: g_prog_id := TO_NUMBER(fnd_profile.value('CONC_PROGRAM_ID'));
498:
499: -- get profile option -- CONC_LOGIN_ID
500: g_last_update_login := TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID'));
501:
502: -- get profile option -- CONC_REQUEST_ID
503: g_request_id := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
504:

Line 503: g_request_id := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));

499: -- get profile option -- CONC_LOGIN_ID
500: g_last_update_login := TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID'));
501:
502: -- get profile option -- CONC_REQUEST_ID
503: g_request_id := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
504:
505:
506: -- If g_request_id = 0, select directly from sequence
507: IF g_request_id = 0

Line 595: sort_size := fnd_profile.value('IEX_SORT_AREA_SIZE_FOR_TAP');

591: s number;
592:
593: BEGIN
594: -- Alter session to set sort area size and hash area size
595: sort_size := fnd_profile.value('IEX_SORT_AREA_SIZE_FOR_TAP');
596: IF sort_size is not NULL and sort_size > 0 THEN
597: st := 'ALTER SESSION SET SORT_AREA_SIZE = ' || sort_size;
598: EXECUTE IMMEDIATE st;
599: select value into s from V$PARAMETER where name = 'sort_area_size';

Line 603: hash_size := fnd_profile.value('IEX_HASH_AREA_SIZE_FOR_TAP');

599: select value into s from V$PARAMETER where name = 'sort_area_size';
600: END IF;
601: IEX_DEBUG('Sort Area Size ' || s );
602:
603: hash_size := fnd_profile.value('IEX_HASH_AREA_SIZE_FOR_TAP');
604: IF hash_size is not NULL and hash_size > 0 THEN
605: st := 'ALTER SESSION SET HASH_AREA_SIZE = ' || hash_size;
606: EXECUTE IMMEDIATE st;
607: select value into s from V$PARAMETER where name = 'hash_area_size';