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 88: l_debug := NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'),20);

84: ELSE
85: MO_GLOBAL.SET_POLICY_CONTEXT('S',P_ORG_ID);
86: END IF;
87:
88: l_debug := NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'),20);
89: FND_FILE.put_line(fnd_file.log,'Value of Profile IEX: Debug Level is : ' || l_debug);
90: FND_FILE.put_line(fnd_file.log,'Operating Unit is : ' || MO_GLOBAL.GET_CURRENT_ORG_ID );
91: --Start changes by gnramasa on 29/08/2006 for bug # 5487449
92: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');

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

88: l_debug := NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'),20);
89: FND_FILE.put_line(fnd_file.log,'Value of Profile IEX: Debug Level is : ' || l_debug);
90: FND_FILE.put_line(fnd_file.log,'Operating Unit is : ' || MO_GLOBAL.GET_CURRENT_ORG_ID );
91: --Start changes by gnramasa on 29/08/2006 for bug # 5487449
92: l_Assignlevel:= NVL(FND_PROFILE.VALUE('IEX_ACCESS_LEVEL'),'PARTY');
93: FND_FILE.PUT_LINE(FND_FILE.LOG,'Territory Assignment Level, IEX: Territory Access Level (IEX_ACCESS_LEVEL) := ' ||l_Assignlevel);
94:
95: IF (l_debug <10) THEN
96: P_debug_mode := 'Y';

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

145: Set_Up(l_acct_qual_tbl);
146:
147:
148:
149: g_request_id := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
150: g_debug_flag := p_debug_mode;
151: g_run_mode := 'TOTAL'; --Bug5043777
152: g_prev_request_id := p_prev_request_id;
153:

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

184:
185: IEX_DEBUG('user hook return: ' || l_return_status);
186: END IF;
187:
188: g_min_num_parallel_proc:=nvl(TO_NUMBER(fnd_profile.value('IEX_TERR_MIN_NUM_PARALLEL_PROC')),1);
189: IEX_DEBUG('Min records for Parallel Processing (IEX_TERR_MIN_NUM_PARALLEL_PROC)=' || g_min_num_parallel_proc);
190:
191: g_NumChildAccountWorker:=nvl(TO_NUMBER(fnd_profile.value('IEX_TAP_NUM_CHILD_ACCOUNT_WORKERS')),1);
192: if g_NumChildAccountWorker < 1 then

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

187:
188: g_min_num_parallel_proc:=nvl(TO_NUMBER(fnd_profile.value('IEX_TERR_MIN_NUM_PARALLEL_PROC')),1);
189: IEX_DEBUG('Min records for Parallel Processing (IEX_TERR_MIN_NUM_PARALLEL_PROC)=' || g_min_num_parallel_proc);
190:
191: g_NumChildAccountWorker:=nvl(TO_NUMBER(fnd_profile.value('IEX_TAP_NUM_CHILD_ACCOUNT_WORKERS')),1);
192: if g_NumChildAccountWorker < 1 then
193: g_NumChildAccountWorker:=1;
194: elsif g_NumChildAccountWorker > 10 then
195: g_NumChildAccountWorker:=10;

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

196: IEX_DEBUG('Max no. of Parallel Account Workers allowed is:' || g_NumChildAccountWorker);
197: end if;
198: IEX_DEBUG('Max Parallel Account Workers (IEX_TAP_NUM_CHILD_ACCOUNT_WORKERS)=' || g_NumChildAccountWorker);
199:
200: l_percent_analysed :=nvl(TO_NUMBER(fnd_profile.value('IEX_TAP_PERCENT_ANALYSED')),20);
201:
202:
203: l_target_type := 'TOTAL';
204:

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

315: Concurrent_Profile_Options;
316:
317: -- get profile option - AS_MC_MAX_ROLL_DAYS
318: /*
319: l_profile_value := fnd_profile.value('AS_MC_MAX_ROLL_DAYS');
320: IF RTRIM(l_profile_value) IS NULL THEN
321: g_num_rollup_days := 0;
322: ELSE
323: g_num_rollup_days := TO_NUMBER(l_profile_value);

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

323: g_num_rollup_days := TO_NUMBER(l_profile_value);
324: END IF;
325:
326: -- get profile option - AS_MC_DAILY_CONVERSION_TYPE
327: g_conversion_type := fnd_profile.value('AS_MC_DAILY_CONVERSION_TYPE');
328: */
329: -- get profile option - number of child process
330: g_num_child_processes :=
331: TO_NUMBER(fnd_profile.value('IEX_TERR_NUM_CHILD_PROCESSES'));

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

327: g_conversion_type := fnd_profile.value('AS_MC_DAILY_CONVERSION_TYPE');
328: */
329: -- get profile option - number of child process
330: g_num_child_processes :=
331: TO_NUMBER(fnd_profile.value('IEX_TERR_NUM_CHILD_PROCESSES'));
332: IEX_DEBUG('Mininum Child Process ' || g_num_child_processes);
333: -- get profile option - min number for parallel processing
334: g_min_num_parallel_proc :=
335: TO_NUMBER(NVL(fnd_profile.value('IEX_TERR_MIN_NUM_PARALLEL_PROC'), 3));

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

331: TO_NUMBER(fnd_profile.value('IEX_TERR_NUM_CHILD_PROCESSES'));
332: IEX_DEBUG('Mininum Child Process ' || g_num_child_processes);
333: -- get profile option - min number for parallel processing
334: g_min_num_parallel_proc :=
335: TO_NUMBER(NVL(fnd_profile.value('IEX_TERR_MIN_NUM_PARALLEL_PROC'), 3));
336: IEX_DEBUG('Minimum Number of Prallel Proc ' || g_min_num_parallel_proc);
337:
338: -- fill in Account Qualifier Array
339: --Bug4654733. Fix by LKKUMAR on 06-Sep-2005. Remove AS dependency. Start

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

372: BEGIN
373:
374:
375: -- get profile option - USER_ID
376: g_user_id := TO_NUMBER(fnd_profile.value('USER_ID'));
377:
378: -- get profile option -- CONC_PROGRAM_APPLICATION_ID
379: g_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
380:

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

378: -- get profile option -- CONC_PROGRAM_APPLICATION_ID
379: g_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
380:
381: -- get profile option -- CONC_PROGRAM_ID
382: g_prog_id := TO_NUMBER(fnd_profile.value('CONC_PROGRAM_ID'));
383:
384: -- get profile option -- CONC_LOGIN_ID
385: g_last_update_login := TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID'));
386:

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

381: -- get profile option -- CONC_PROGRAM_ID
382: g_prog_id := TO_NUMBER(fnd_profile.value('CONC_PROGRAM_ID'));
383:
384: -- get profile option -- CONC_LOGIN_ID
385: g_last_update_login := TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID'));
386:
387: -- get profile option -- CONC_REQUEST_ID
388: g_request_id := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
389:

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

384: -- get profile option -- CONC_LOGIN_ID
385: g_last_update_login := TO_NUMBER(fnd_profile.value('CONC_LOGIN_ID'));
386:
387: -- get profile option -- CONC_REQUEST_ID
388: g_request_id := TO_NUMBER(fnd_profile.value('CONC_REQUEST_ID'));
389:
390:
391: -- If g_request_id = 0, select directly from sequence
392: IF g_request_id = 0

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

476: s number;
477:
478: BEGIN
479: -- Alter session to set sort area size and hash area size
480: sort_size := fnd_profile.value('IEX_SORT_AREA_SIZE_FOR_TAP');
481: IF sort_size is not NULL and sort_size > 0 THEN
482: st := 'ALTER SESSION SET SORT_AREA_SIZE = ' || sort_size;
483: EXECUTE IMMEDIATE st;
484: select value into s from V$PARAMETER where name = 'sort_area_size';

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

484: select value into s from V$PARAMETER where name = 'sort_area_size';
485: END IF;
486: IEX_DEBUG('Sort Area Size ' || s );
487:
488: hash_size := fnd_profile.value('IEX_HASH_AREA_SIZE_FOR_TAP');
489: IF hash_size is not NULL and hash_size > 0 THEN
490: st := 'ALTER SESSION SET HASH_AREA_SIZE = ' || hash_size;
491: EXECUTE IMMEDIATE st;
492: select value into s from V$PARAMETER where name = 'hash_area_size';