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_EXCEPTION_NOTES

Line 29: s_rows_deleted_fen NUMBER := 0; --FND_EXCEPTION_NOTES

25: DELETE_BLOCK CONSTANT NUMBER := 1000;
26: MAX_LIST_COUNT CONSTANT NUMBER := 1000;
27:
28: s_rows_deleted_flm NUMBER := 0; --FND_LOG_MESSAGES;
29: s_rows_deleted_fen NUMBER := 0; --FND_EXCEPTION_NOTES
30: s_rows_deleted_fle NUMBER := 0; --FND_LOG_EXCEPTIONS
31: s_rows_deleted_flmt NUMBER := 0; --FND_LOG_METRICS
32: s_rows_deleted_flue NUMBER := 0; --FND_LOG_UNIQUE_EXCEPTIONS
33: s_rows_deleted_fobsn NUMBER := 0; --FND_OAM_BIZEX_SENT_NOTIF

Line 350: s_rows_deleted_fen := 0; --FND_EXCEPTION_NOTES

346: procedure init
347: IS
348: BEGIN
349: s_rows_deleted_flm := 0; --FND_LOG_MESSAGES;
350: s_rows_deleted_fen := 0; --FND_EXCEPTION_NOTES
351: s_rows_deleted_fle := 0; --FND_LOG_EXCEPTIONS
352: s_rows_deleted_flmt := 0; --FND_LOG_METRICS
353: s_rows_deleted_flue := 0; --FND_LOG_UNIQUE_EXCEPTIONS
354: s_rows_deleted_fobsn := 0; --FND_OAM_BIZEX_SENT_NOTIF

Line 367: select count(*) into l_count from FND_EXCEPTION_NOTES;

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);
371: select count(*) into l_count from FND_LOG_METRICS;

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 744: fdebug('Start Del FND_EXCEPTION_NOTES');

740: l_end := getDeleteBlock(l_end, p_UEXList.count);
741: exit when l_start > p_UEXList.count;
742:
743: begin
744: fdebug('Start Del FND_EXCEPTION_NOTES');
745: l_table := 'FND_LOG_MESSAGES';
746:
747: FORALL ii IN l_start..l_end
748: DELETE FROM FND_EXCEPTION_NOTES fen

Line 748: DELETE FROM FND_EXCEPTION_NOTES fen

744: fdebug('Start Del FND_EXCEPTION_NOTES');
745: l_table := 'FND_LOG_MESSAGES';
746:
747: FORALL ii IN l_start..l_end
748: DELETE FROM FND_EXCEPTION_NOTES fen
749: WHERE fen.UNIQUE_EXCEPTION_ID = p_UEXList(ii)
750: and NOT EXISTS
751: (SELECT null from FND_LOG_EXCEPTIONS fle
752: where fle.UNIQUE_EXCEPTION_ID = fen.UNIQUE_EXCEPTION_ID

Line 754: s_rows_deleted_fen := s_rows_deleted_fen + sql%rowcount; --FND_EXCEPTION_NOTES

750: and NOT EXISTS
751: (SELECT null from FND_LOG_EXCEPTIONS fle
752: where fle.UNIQUE_EXCEPTION_ID = fen.UNIQUE_EXCEPTION_ID
753: );
754: s_rows_deleted_fen := s_rows_deleted_fen + sql%rowcount; --FND_EXCEPTION_NOTES
755: doCommit;
756:
757: fdebug('Start Del FND_OAM_BIZEX_SENT_NOTIF');
758: l_table := 'FND_OAM_BIZEX_SENT_NOTIF';