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.GCS_PURGE_PKG dependencies on FND_FILE

Line 42: fnd_file.put_line(fnd_file.log, 'Beginning Consolidation Purge Program');

38: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.PURGE_CONS_RUNS', 'Calendar Period : ' || p_cal_period_id);
39: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.PURGE_CONS_RUNS', 'Balance Type : ' || p_balance_type_code);
40: END IF;
41:
42: fnd_file.put_line(fnd_file.log, 'Beginning Consolidation Purge Program');
43: fnd_file.put_line(fnd_file.log, '<>');
44: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);
45: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);
46: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);

Line 43: fnd_file.put_line(fnd_file.log, '<>');

39: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.PURGE_CONS_RUNS', 'Balance Type : ' || p_balance_type_code);
40: END IF;
41:
42: fnd_file.put_line(fnd_file.log, 'Beginning Consolidation Purge Program');
43: fnd_file.put_line(fnd_file.log, '<>');
44: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);
45: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);
46: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);
47: fnd_file.put_line(fnd_file.log, 'Balance Type : ' || p_balance_type_code);

Line 44: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);

40: END IF;
41:
42: fnd_file.put_line(fnd_file.log, 'Beginning Consolidation Purge Program');
43: fnd_file.put_line(fnd_file.log, '<>');
44: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);
45: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);
46: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);
47: fnd_file.put_line(fnd_file.log, 'Balance Type : ' || p_balance_type_code);
48: fnd_file.put_line(fnd_file.log, '<>');

Line 45: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);

41:
42: fnd_file.put_line(fnd_file.log, 'Beginning Consolidation Purge Program');
43: fnd_file.put_line(fnd_file.log, '<>');
44: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);
45: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);
46: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);
47: fnd_file.put_line(fnd_file.log, 'Balance Type : ' || p_balance_type_code);
48: fnd_file.put_line(fnd_file.log, '<>');
49:

Line 46: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);

42: fnd_file.put_line(fnd_file.log, 'Beginning Consolidation Purge Program');
43: fnd_file.put_line(fnd_file.log, '<>');
44: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);
45: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);
46: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);
47: fnd_file.put_line(fnd_file.log, 'Balance Type : ' || p_balance_type_code);
48: fnd_file.put_line(fnd_file.log, '<>');
49:
50: BEGIN

Line 47: fnd_file.put_line(fnd_file.log, 'Balance Type : ' || p_balance_type_code);

43: fnd_file.put_line(fnd_file.log, '<>');
44: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);
45: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);
46: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);
47: fnd_file.put_line(fnd_file.log, 'Balance Type : ' || p_balance_type_code);
48: fnd_file.put_line(fnd_file.log, '<>');
49:
50: BEGIN
51: SELECT nvl(value,1)*2 no_of_workers

Line 48: fnd_file.put_line(fnd_file.log, '<>');

44: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);
45: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);
46: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);
47: fnd_file.put_line(fnd_file.log, 'Balance Type : ' || p_balance_type_code);
48: fnd_file.put_line(fnd_file.log, '<>');
49:
50: BEGIN
51: SELECT nvl(value,1)*2 no_of_workers
52: INTO v_Num_Workers

Line 61: fnd_file.put_line(fnd_file.log, SubStr('Getting number of workers-'||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));

57: WHEN OTHERS THEN
58: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
59: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.PURGE_CONS_RUNS_WORKER', SubStr('Getting number of workers-'||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
60: END IF;
61: fnd_file.put_line(fnd_file.log, SubStr('Getting number of workers-'||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
62: x_retcode :='2';
63: END;
64:
65: BEGIN

Line 79: fnd_file.put_line(fnd_file.log, SubStr('Getting the Unique Key(p_key)'||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));

75: WHEN OTHERS THEN
76: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
77: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.PURGE_CONS_RUNS_WORKER', SubStr('Getting the Unique Key(p_key)'||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
78: END IF;
79: fnd_file.put_line(fnd_file.log, SubStr('Getting the Unique Key(p_key)'||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
80: x_retcode :='2';
81: END;
82:
83: -- AD Parallel framework Manager processing

Line 115: fnd_file.put_line(fnd_file.log, SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));

111: END IF;
112: EXCEPTION
113: WHEN OTHERS THEN
114: ROLLBACK;
115: fnd_file.put_line(fnd_file.log, SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
116: x_retcode :='2';
117: END purge_cons_runs; -- end of procedure purge_cons_runs
118:
119: -- Procedure

Line 296: fnd_file.put_line(fnd_file.log, 'Beginning Consolidation Purge Program');

292: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.PURGE_CONS_RUNS_WORKER', 'Calendar Period : ' || p_cal_period_id);
293: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.PURGE_CONS_RUNS_WORKER', 'Balance Type : ' || p_balance_type_code);
294: END IF;
295:
296: fnd_file.put_line(fnd_file.log, 'Beginning Consolidation Purge Program');
297: fnd_file.put_line(fnd_file.log, '<>');
298: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);
299: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);
300: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);

Line 297: fnd_file.put_line(fnd_file.log, '<>');

293: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.PURGE_CONS_RUNS_WORKER', 'Balance Type : ' || p_balance_type_code);
294: END IF;
295:
296: fnd_file.put_line(fnd_file.log, 'Beginning Consolidation Purge Program');
297: fnd_file.put_line(fnd_file.log, '<>');
298: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);
299: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);
300: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);
301: fnd_file.put_line(fnd_file.log, 'Balance Type : ' || p_balance_type_code);

Line 298: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);

294: END IF;
295:
296: fnd_file.put_line(fnd_file.log, 'Beginning Consolidation Purge Program');
297: fnd_file.put_line(fnd_file.log, '<>');
298: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);
299: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);
300: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);
301: fnd_file.put_line(fnd_file.log, 'Balance Type : ' || p_balance_type_code);
302: fnd_file.put_line(fnd_file.log, '<>');

Line 299: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);

295:
296: fnd_file.put_line(fnd_file.log, 'Beginning Consolidation Purge Program');
297: fnd_file.put_line(fnd_file.log, '<>');
298: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);
299: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);
300: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);
301: fnd_file.put_line(fnd_file.log, 'Balance Type : ' || p_balance_type_code);
302: fnd_file.put_line(fnd_file.log, '<>');
303:

Line 300: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);

296: fnd_file.put_line(fnd_file.log, 'Beginning Consolidation Purge Program');
297: fnd_file.put_line(fnd_file.log, '<>');
298: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);
299: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);
300: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);
301: fnd_file.put_line(fnd_file.log, 'Balance Type : ' || p_balance_type_code);
302: fnd_file.put_line(fnd_file.log, '<>');
303:
304: --

Line 301: fnd_file.put_line(fnd_file.log, 'Balance Type : ' || p_balance_type_code);

297: fnd_file.put_line(fnd_file.log, '<>');
298: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);
299: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);
300: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);
301: fnd_file.put_line(fnd_file.log, 'Balance Type : ' || p_balance_type_code);
302: fnd_file.put_line(fnd_file.log, '<>');
303:
304: --
305: -- Get schema name of the table for ROWID range processing

Line 302: fnd_file.put_line(fnd_file.log, '<>');

298: fnd_file.put_line(fnd_file.log, 'Consolidation Hierarchy : ' || p_consolidation_hierarchy);
299: fnd_file.put_line(fnd_file.log, 'Consolidation Entity : ' || p_consolidation_entity);
300: fnd_file.put_line(fnd_file.log, 'Calendar Period : ' || p_cal_period_id);
301: fnd_file.put_line(fnd_file.log, 'Balance Type : ' || p_balance_type_code);
302: fnd_file.put_line(fnd_file.log, '<>');
303:
304: --
305: -- Get schema name of the table for ROWID range processing
306: --

Line 348: fnd_file.put_line(fnd_file.log, '<<------------------- No Rows to Process---------------------->>');

344:
345: -- v_any_rows_to_process = TRUE means there are some rows to process
346: -- v_any_rows_to_process = FALSE means there are no rows to process
347: IF (v_any_rows_to_process = FALSE) THEN
348: fnd_file.put_line(fnd_file.log, '<<------------------- No Rows to Process---------------------->>');
349: END IF;
350: -- This loop will be keep on repeated until all the rows allocated to a
351: -- worker are processed i.e until v_any_rows_to_process becomes FALSE
352: WHILE (v_any_rows_to_process = TRUE) LOOP

Line 380: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');

376: FETCH c_purge_entry BULK COLLECT INTO l_purge_entry_id_rec LIMIT 1000;
377: IF (l_purge_entry_id_rec.FIRST IS NOT NULL AND
378: l_purge_entry_id_rec.LAST IS NOT NULL) THEN
379: -- To print the header information like Run Name and Consolidation entity in log file
380: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
381: fnd_file.put_line(fnd_file.log, '| Run Name : '|| rpad(l_purge_cons_entity_list(i).run_name,117,' ')||'|');
382: fnd_file.put_line(fnd_file.log, '| Consolidation Entity ID : '|| rpad(l_purge_cons_entity_list(i).entity_name,117,' ')||'|');
383: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
384: fnd_file.put_line(fnd_file.log, '| Child Entity | Entry Name | Description |');

Line 381: fnd_file.put_line(fnd_file.log, '| Run Name : '|| rpad(l_purge_cons_entity_list(i).run_name,117,' ')||'|');

377: IF (l_purge_entry_id_rec.FIRST IS NOT NULL AND
378: l_purge_entry_id_rec.LAST IS NOT NULL) THEN
379: -- To print the header information like Run Name and Consolidation entity in log file
380: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
381: fnd_file.put_line(fnd_file.log, '| Run Name : '|| rpad(l_purge_cons_entity_list(i).run_name,117,' ')||'|');
382: fnd_file.put_line(fnd_file.log, '| Consolidation Entity ID : '|| rpad(l_purge_cons_entity_list(i).entity_name,117,' ')||'|');
383: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
384: fnd_file.put_line(fnd_file.log, '| Child Entity | Entry Name | Description |');
385: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');

Line 382: fnd_file.put_line(fnd_file.log, '| Consolidation Entity ID : '|| rpad(l_purge_cons_entity_list(i).entity_name,117,' ')||'|');

378: l_purge_entry_id_rec.LAST IS NOT NULL) THEN
379: -- To print the header information like Run Name and Consolidation entity in log file
380: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
381: fnd_file.put_line(fnd_file.log, '| Run Name : '|| rpad(l_purge_cons_entity_list(i).run_name,117,' ')||'|');
382: fnd_file.put_line(fnd_file.log, '| Consolidation Entity ID : '|| rpad(l_purge_cons_entity_list(i).entity_name,117,' ')||'|');
383: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
384: fnd_file.put_line(fnd_file.log, '| Child Entity | Entry Name | Description |');
385: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
386:

Line 383: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');

379: -- To print the header information like Run Name and Consolidation entity in log file
380: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
381: fnd_file.put_line(fnd_file.log, '| Run Name : '|| rpad(l_purge_cons_entity_list(i).run_name,117,' ')||'|');
382: fnd_file.put_line(fnd_file.log, '| Consolidation Entity ID : '|| rpad(l_purge_cons_entity_list(i).entity_name,117,' ')||'|');
383: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
384: fnd_file.put_line(fnd_file.log, '| Child Entity | Entry Name | Description |');
385: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
386:
387: FOR j IN l_purge_entry_id_rec.FIRST .. l_purge_entry_id_rec.LAST LOOP

Line 384: fnd_file.put_line(fnd_file.log, '| Child Entity | Entry Name | Description |');

380: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
381: fnd_file.put_line(fnd_file.log, '| Run Name : '|| rpad(l_purge_cons_entity_list(i).run_name,117,' ')||'|');
382: fnd_file.put_line(fnd_file.log, '| Consolidation Entity ID : '|| rpad(l_purge_cons_entity_list(i).entity_name,117,' ')||'|');
383: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
384: fnd_file.put_line(fnd_file.log, '| Child Entity | Entry Name | Description |');
385: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
386:
387: FOR j IN l_purge_entry_id_rec.FIRST .. l_purge_entry_id_rec.LAST LOOP
388: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 385: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');

381: fnd_file.put_line(fnd_file.log, '| Run Name : '|| rpad(l_purge_cons_entity_list(i).run_name,117,' ')||'|');
382: fnd_file.put_line(fnd_file.log, '| Consolidation Entity ID : '|| rpad(l_purge_cons_entity_list(i).entity_name,117,' ')||'|');
383: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
384: fnd_file.put_line(fnd_file.log, '| Child Entity | Entry Name | Description |');
385: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
386:
387: FOR j IN l_purge_entry_id_rec.FIRST .. l_purge_entry_id_rec.LAST LOOP
388: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
389: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_api || '.PURGE_CONS_RUNS_WORKER', 'Run Name : ' ||l_purge_cons_entity_list(i).run_name ||

Line 405: fnd_file.put_line(fnd_file.log,'| '||rpad(l_entity_name,35,' ')||'| '||

401: FROM fem_entities_tl fem
402: WHERE fem.entity_id = l_purge_entry_id_rec(j).child_entity_id
403: AND fem.language = userenv('lang');
404: -- To print purged informatin into log file
405: fnd_file.put_line(fnd_file.log,'| '||rpad(l_entity_name,35,' ')||'| '||
406: rpad(l_purge_entry_id_rec(j).entry_name,25,' ')||'| '||
407: rpad(l_purge_entry_id_rec(j).description,90,' ')||'|');
408: END LOOP; -- end of inner for loop
409: END IF;

Line 430: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');

426: END LOOP; -- end of outer cursor forloop
427: END IF;
428: EXIT WHEN c_purge_cons_entity%NOTFOUND;
429: END LOOP; -- enf of outer cursor(c_purge_cons_entity) loop
430: fnd_file.put_line(fnd_file.log, '+------------------------------------+--------------------------+-------------------------------------------------------------------------------------------+');
431: CLOSE c_purge_cons_entity;
432: --To update number rows processed so far
433: ad_parallel_updates_pkg.processed_rowid_range( v_rows_processed, v_end_rowid);
434: COMMIT;

Line 449: fnd_file.put_line(fnd_file.log, SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));

445: END IF;
446: EXCEPTION
447: WHEN OTHERS THEN
448: ROLLBACK;
449: fnd_file.put_line(fnd_file.log, SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
450: x_retcode :='2';
451: END purge_cons_runs_worker; -- end of procedure purge_cons_runs
452: END GCS_PURGE_PKG; -- end of package GCS_PURGE_PKG