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

Line 248: fnd_file.put_line(fnd_file.log, dbms_utility.get_time || ' delete_by_date_range_pre1159: ' ||

244: raise;
245: end if;
246: end;
247: end loop;
248: fnd_file.put_line(fnd_file.log, dbms_utility.get_time || ' delete_by_date_range_pre1159: ' ||
249: 'Deleted rows from fnd_log_messages ' || rowcount);
250: return rowcount;
251: end;
252:

Line 341: fnd_file.put_line( fnd_file.log, dbms_utility.get_time || ' ' || msg);

337: l_msg VARCHAR2(1);
338: BEGIN
339: if (C_DEBUG) then
340: --- xdbms_xoutput.xput_line(dbms_utility.get_time || ' ' || msg);
341: fnd_file.put_line( fnd_file.log, dbms_utility.get_time || ' ' || msg);
342: l_msg := 'm';
343: end if;
344: END fdebug;
345:

Line 366: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_MESSAGES=' || l_count);

362: l_count := 0;
363:
364: /*
365: select count(*) into l_count from FND_LOG_MESSAGES;
366: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_MESSAGES=' || l_count);
367: select count(*) into l_count from FND_EXCEPTION_NOTES;
368: fnd_file.put_line( fnd_file.log,'Rows in FND_EXCEPTION_NOTES=' || l_count);
369: select count(*) into l_count from FND_LOG_EXCEPTIONS;
370: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_EXCEPTIONS=' || l_count);

Line 368: fnd_file.put_line( fnd_file.log,'Rows in FND_EXCEPTION_NOTES=' || l_count);

364: /*
365: select count(*) into l_count from FND_LOG_MESSAGES;
366: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_MESSAGES=' || l_count);
367: select count(*) into l_count from FND_EXCEPTION_NOTES;
368: fnd_file.put_line( fnd_file.log,'Rows in FND_EXCEPTION_NOTES=' || l_count);
369: select count(*) into l_count from FND_LOG_EXCEPTIONS;
370: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_EXCEPTIONS=' || l_count);
371: select count(*) into l_count from FND_LOG_METRICS;
372: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_METRICS=' || l_count);

Line 370: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_EXCEPTIONS=' || l_count);

366: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_MESSAGES=' || l_count);
367: select count(*) into l_count from FND_EXCEPTION_NOTES;
368: fnd_file.put_line( fnd_file.log,'Rows in FND_EXCEPTION_NOTES=' || l_count);
369: select count(*) into l_count from FND_LOG_EXCEPTIONS;
370: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_EXCEPTIONS=' || l_count);
371: select count(*) into l_count from FND_LOG_METRICS;
372: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_METRICS=' || l_count);
373: select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;
374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);

Line 372: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_METRICS=' || l_count);

368: fnd_file.put_line( fnd_file.log,'Rows in FND_EXCEPTION_NOTES=' || l_count);
369: select count(*) into l_count from FND_LOG_EXCEPTIONS;
370: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_EXCEPTIONS=' || l_count);
371: select count(*) into l_count from FND_LOG_METRICS;
372: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_METRICS=' || l_count);
373: select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;
374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);
375: select count(*) into l_count from FND_OAM_BIZEX_SENT_NOTIF;
376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);

Line 374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);

370: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_EXCEPTIONS=' || l_count);
371: select count(*) into l_count from FND_LOG_METRICS;
372: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_METRICS=' || l_count);
373: select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;
374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);
375: select count(*) into l_count from FND_OAM_BIZEX_SENT_NOTIF;
376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);
377: select count(*) into l_count from FND_LOG_TRANSACTION_CONTEXT;
378: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_TRANSACTION_CONTEXT=' || l_count);

Line 376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);

372: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_METRICS=' || l_count);
373: select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;
374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);
375: select count(*) into l_count from FND_OAM_BIZEX_SENT_NOTIF;
376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);
377: select count(*) into l_count from FND_LOG_TRANSACTION_CONTEXT;
378: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_TRANSACTION_CONTEXT=' || l_count);
379: select count(*) into l_count from FND_LOG_ATTACHMENTS;
380: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_ATTACHMENTS=' || l_count);

Line 378: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_TRANSACTION_CONTEXT=' || l_count);

374: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_UNIQUE_EXCEPTIONS=' || l_count);
375: select count(*) into l_count from FND_OAM_BIZEX_SENT_NOTIF;
376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);
377: select count(*) into l_count from FND_LOG_TRANSACTION_CONTEXT;
378: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_TRANSACTION_CONTEXT=' || l_count);
379: select count(*) into l_count from FND_LOG_ATTACHMENTS;
380: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_ATTACHMENTS=' || l_count);
381: */
382: end printCount;

Line 380: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_ATTACHMENTS=' || l_count);

376: fnd_file.put_line( fnd_file.log,'Rows in FND_OAM_BIZEX_SENT_NOTIF=' || l_count);
377: select count(*) into l_count from FND_LOG_TRANSACTION_CONTEXT;
378: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_TRANSACTION_CONTEXT=' || l_count);
379: select count(*) into l_count from FND_LOG_ATTACHMENTS;
380: fnd_file.put_line( fnd_file.log,'Rows in FND_LOG_ATTACHMENTS=' || l_count);
381: */
382: end printCount;
383:
384:

Line 1353: FND_FILE.put_line(FND_FILE.log,errbuf);

1349: if(last_dt is NULL) then
1350: errbuf := 'Unexpected error converting character string to date:'
1351: ||last_date;
1352: retcode := '2';
1353: FND_FILE.put_line(FND_FILE.log,errbuf);
1354: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1355: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1356: c_log_head || l_api_name || '.end_exception',
1357: 'returning from delete_by_date with date exception. last_date='

Line 1372: FND_FILE.put_line(FND_FILE.log, msgbuf);

1368: else
1369: fnd_message.set_token('DATE', last_date);
1370: end if;
1371: msgbuf := fnd_message.get;
1372: FND_FILE.put_line(FND_FILE.log, msgbuf);
1373:
1374: /* Delete from the date back in time */
1375: numrows := delete_by_date_range(NULL, last_dt);
1376:

Line 1380: FND_FILE.put_line(FND_FILE.log, msgbuf);

1376:
1377: fnd_message.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1378: fnd_message.set_token('ROWS', numrows);
1379: msgbuf := fnd_message.get;
1380: FND_FILE.put_line(FND_FILE.log, msgbuf);
1381:
1382: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1383: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1384: c_log_head || l_api_name || '.end',

Line 1391: FND_FILE.put_line(FND_FILE.log,errbuf);

1387: exception
1388: when others then
1389: errbuf := sqlerrm;
1390: retcode := '2';
1391: FND_FILE.put_line(FND_FILE.log,errbuf);
1392: if ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1393: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1394: c_log_head || l_api_name || '.end_exception',
1395: 'returning from delete_by_date with exception. numrows='||numrows);