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_LOG_UNIQUE_EXCEPTIONS

Line 12: TYPE UExcIdListTyp IS TABLE OF FND_LOG_UNIQUE_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE INDEX BY BINARY_INTEGER;

8: /******************************************************************************/
9: /***Constants for Changes due to system Log ***********************************/
10: TYPE GenCursor IS REF CURSOR;
11: TYPE TransxCurTyp IS REF CURSOR RETURN FND_LOG_TRANSACTION_CONTEXT%ROWTYPE;
12: TYPE UExcIdListTyp IS TABLE OF FND_LOG_UNIQUE_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE INDEX BY BINARY_INTEGER;
13: TYPE LogSeqListTyp IS TABLE OF FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;
14: TYPE TrnCtxIdListTyp IS TABLE OF FND_LOG_TRANSACTION_CONTEXT.TRANSACTION_CONTEXT_ID%TYPE INDEX BY BINARY_INTEGER;
15: TYPE VARCAHRListTyp IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
16: TYPE VARCAHRSmallListTyp IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;

Line 32: s_rows_deleted_flue NUMBER := 0; --FND_LOG_UNIQUE_EXCEPTIONS

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
34: s_rows_deleted_fltc NUMBER := 0; --FND_LOG_TRANSACTION_CONTEXT
35:
36:

Line 353: s_rows_deleted_flue := 0; --FND_LOG_UNIQUE_EXCEPTIONS

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
355: s_rows_deleted_fltc := 0; --FND_LOG_TRANSACTION_CONTEXT
356: END init;
357:

Line 373: select count(*) into l_count from FND_LOG_UNIQUE_EXCEPTIONS;

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

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 671: (select null from FND_LOG_EXCEPTIONS fle, FND_LOG_UNIQUE_EXCEPTIONS flue where

667: l_table := 'FND_LOG_EXCEPTIONS';
668: FORALL ii IN l_start..l_end
669: delete from FND_LOG_EXCEPTIONS flem where flem.LOG_SEQUENCE=p_logSeqList(ii)
670: and NOT EXISTS
671: (select null from FND_LOG_EXCEPTIONS fle, FND_LOG_UNIQUE_EXCEPTIONS flue where
672: fle.LOG_SEQUENCE = flem.LOG_SEQUENCE
673: and flue.UNIQUE_EXCEPTION_ID = fle.UNIQUE_EXCEPTION_ID
674: and flue.STATUS <> 'C');
675:

Line 769: fdebug('Start Del FND_LOG_UNIQUE_EXCEPTIONS');

765: );
766: s_rows_deleted_fobsn := s_rows_deleted_fobsn + sql%rowcount; --FND_OAM_BIZEX_SENT_NOTIF
767: doCommit;
768:
769: fdebug('Start Del FND_LOG_UNIQUE_EXCEPTIONS');
770: l_table := 'FND_LOG_UNIQUE_EXCEPTIONS';
771: FORALL ii IN l_start..l_end
772: DELETE FROM FND_LOG_UNIQUE_EXCEPTIONS flue
773: WHERE flue.UNIQUE_EXCEPTION_ID = p_UEXList(ii)

Line 770: l_table := 'FND_LOG_UNIQUE_EXCEPTIONS';

766: s_rows_deleted_fobsn := s_rows_deleted_fobsn + sql%rowcount; --FND_OAM_BIZEX_SENT_NOTIF
767: doCommit;
768:
769: fdebug('Start Del FND_LOG_UNIQUE_EXCEPTIONS');
770: l_table := 'FND_LOG_UNIQUE_EXCEPTIONS';
771: FORALL ii IN l_start..l_end
772: DELETE FROM FND_LOG_UNIQUE_EXCEPTIONS flue
773: WHERE flue.UNIQUE_EXCEPTION_ID = p_UEXList(ii)
774: and NOT EXISTS

Line 772: DELETE FROM FND_LOG_UNIQUE_EXCEPTIONS flue

768:
769: fdebug('Start Del FND_LOG_UNIQUE_EXCEPTIONS');
770: l_table := 'FND_LOG_UNIQUE_EXCEPTIONS';
771: FORALL ii IN l_start..l_end
772: DELETE FROM FND_LOG_UNIQUE_EXCEPTIONS flue
773: WHERE flue.UNIQUE_EXCEPTION_ID = p_UEXList(ii)
774: and NOT EXISTS
775: (SELECT null from FND_LOG_EXCEPTIONS fle
776: where fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID

Line 778: s_rows_deleted_flue := s_rows_deleted_flue + sql%rowcount; --FND_LOG_UNIQUE_EXCEPTIONS

774: and NOT EXISTS
775: (SELECT null from FND_LOG_EXCEPTIONS fle
776: where fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID
777: );
778: s_rows_deleted_flue := s_rows_deleted_flue + sql%rowcount; --FND_LOG_UNIQUE_EXCEPTIONS
779: doCommit;
780:
781: EXCEPTION
782: when others then

Line 813: FND_LOG_UNIQUE_EXCEPTIONS flue

809:
810: --Check input parameters
811: select flue.UNIQUE_EXCEPTION_ID BULK COLLECT into l_UEXList
812: from
813: FND_LOG_UNIQUE_EXCEPTIONS flue
814: where
815: NOT EXISTS
816: (SELECT null from FND_LOG_EXCEPTIONS fle
817: where fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID

Line 842: ,FND_LOG_UNIQUE_EXCEPTIONS flue

838: --Check input parameters
839: select fle.LOG_SEQUENCE BULK COLLECT into l_EXList
840: from
841: FND_LOG_EXCEPTIONS fle
842: ,FND_LOG_UNIQUE_EXCEPTIONS flue
843: where
844: fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID
845: and fle.TRANSACTION_CONTEXT_ID is null
846: and flue.STATUS = 'C'

Line 1067: , FND_LOG_UNIQUE_EXCEPTIONS flue

1063: l_UEXList1 := l_UEXListNull;
1064: select distinct flue.UNIQUE_EXCEPTION_ID BULK COLLECT into l_UEXList1
1065: from
1066: FND_LOG_EXCEPTIONS fle
1067: , FND_LOG_UNIQUE_EXCEPTIONS flue
1068: where
1069: fle.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)
1070: and flue.UNIQUE_EXCEPTION_ID = fle.UNIQUE_EXCEPTION_ID ---
1071: and flue.STATUS = 'C';