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_EXCEPTIONS

Line 13: TYPE LogSeqListTyp IS TABLE OF FND_LOG_EXCEPTIONS.LOG_SEQUENCE%TYPE INDEX BY BINARY_INTEGER;

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;
17:

Line 30: s_rows_deleted_fle NUMBER := 0; --FND_LOG_EXCEPTIONS

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

Line 351: s_rows_deleted_fle := 0; --FND_LOG_EXCEPTIONS

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
355: s_rows_deleted_fltc := 0; --FND_LOG_TRANSACTION_CONTEXT

Line 369: select count(*) into l_count from FND_LOG_EXCEPTIONS;

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

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

660: exit when l_start > p_logSeqList.count;
661:
662: begin
663:
664: fdebug('Start Del FND_LOG_EXCEPTIONS');
665: fdebug('l_start = ' || l_start || ' l_end = ' || l_end);
666:
667: l_table := 'FND_LOG_EXCEPTIONS';
668: FORALL ii IN l_start..l_end

Line 667: l_table := 'FND_LOG_EXCEPTIONS';

663:
664: fdebug('Start Del FND_LOG_EXCEPTIONS');
665: fdebug('l_start = ' || l_start || ' l_end = ' || l_end);
666:
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

Line 669: delete from FND_LOG_EXCEPTIONS flem where flem.LOG_SEQUENCE=p_logSeqList(ii)

665: fdebug('l_start = ' || l_start || ' l_end = ' || l_end);
666:
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

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 676: s_rows_deleted_fle := s_rows_deleted_fle + sql%rowcount; --FND_LOG_EXCEPTIONS

672: fle.LOG_SEQUENCE = flem.LOG_SEQUENCE
673: and flue.UNIQUE_EXCEPTION_ID = fle.UNIQUE_EXCEPTION_ID
674: and flue.STATUS <> 'C');
675:
676: s_rows_deleted_fle := s_rows_deleted_fle + sql%rowcount; --FND_LOG_EXCEPTIONS
677: doCommit;
678:
679: fdebug('Start Del FND_LOG_MESSAGES');
680: l_table := 'FND_LOG_MESSAGES';

Line 685: (select null from FND_LOG_EXCEPTIONS fle where

681:
682: FORALL ii IN l_start..l_end
683: delete from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE=p_logSeqList(ii)
684: and NOT EXISTS
685: (select null from FND_LOG_EXCEPTIONS fle where
686: fle.LOG_SEQUENCE = flm.LOG_SEQUENCE
687: );
688:
689: s_rows_deleted_flm := s_rows_deleted_flm + sql%rowcount; --FND_LOG_MESSAGES;

Line 697: (select null from FND_LOG_EXCEPTIONS fle where fle.LOG_SEQUENCE = p_logSeqList(ii))

693: l_table := 'FND_LOG_ATTACHMENTS';
694: FORALL ii IN l_start..l_end
695: delete from FND_LOG_ATTACHMENTS fla where fla.LOG_SEQUENCE=p_logSeqList(ii)
696: and NOT EXISTS
697: (select null from FND_LOG_EXCEPTIONS fle where fle.LOG_SEQUENCE = p_logSeqList(ii))
698: and NOT EXISTS
699: (select null from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE = p_logSeqList(ii));
700:
701:

Line 751: (SELECT null from FND_LOG_EXCEPTIONS fle

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
753: );
754: s_rows_deleted_fen := s_rows_deleted_fen + sql%rowcount; --FND_EXCEPTION_NOTES
755: doCommit;

Line 763: (SELECT null from FND_LOG_EXCEPTIONS fle

759: FORALL ii IN l_start..l_end
760: DELETE FROM FND_OAM_BIZEX_SENT_NOTIF fobsf
761: WHERE fobsf.UNIQUE_EXCEPTION_ID = p_UEXList(ii)
762: and NOT EXISTS
763: (SELECT null from FND_LOG_EXCEPTIONS fle
764: where fle.UNIQUE_EXCEPTION_ID = fobsf.UNIQUE_EXCEPTION_ID
765: );
766: s_rows_deleted_fobsn := s_rows_deleted_fobsn + sql%rowcount; --FND_OAM_BIZEX_SENT_NOTIF
767: doCommit;

Line 775: (SELECT null from FND_LOG_EXCEPTIONS fle

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
777: );
778: s_rows_deleted_flue := s_rows_deleted_flue + sql%rowcount; --FND_LOG_UNIQUE_EXCEPTIONS
779: doCommit;

Line 798: -- in fnd_log_exceptions

794: END DELETE_UNIQUE_EXCEPTIONS_INFO;
795:
796: --------------------------------------------------------------------------------
797: --This function deletes those unique exceptions for which there is no infor
798: -- in fnd_log_exceptions
799:
800: procedure DELETE_UNIQUEA_EXCEPTIONS_INFO(pRetCode out NOCOPY number)
801: IS
802: l_table VARCHAR2(25);

Line 816: (SELECT null from FND_LOG_EXCEPTIONS fle

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
818: );
819:
820: DELETE_UNIQUE_EXCEPTIONS_INFO(l_UEXList,pRetCode);

Line 841: FND_LOG_EXCEPTIONS fle

837:
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

Line 889: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=flm.TRANSACTION_CONTEXT_ID);

885:
886: FORALL ii IN l_start..l_end
887: delete from FND_LOG_METRICS flm where flm.TRANSACTION_CONTEXT_ID=p_TrList(ii)
888: and NOT EXISTS
889: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=flm.TRANSACTION_CONTEXT_ID);
890: s_rows_deleted_flmt := s_rows_deleted_flmt + sql%rowcount; --FND_LOG_METRICS
891: doCommit;
892:
893:

Line 899: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=p_TrList(ii))

895: l_table := 'FND_LOG_TRANSACTION_CONTEXT';
896: FORALL ii IN l_start..l_end
897: delete from FND_LOG_TRANSACTION_CONTEXT where TRANSACTION_CONTEXT_ID=p_TrList(ii)
898: and NOT EXISTS
899: (select null from FND_LOG_EXCEPTIONS fle WHERE fle.TRANSACTION_CONTEXT_ID=p_TrList(ii))
900: and NOT EXISTS
901: (select null from FND_LOG_MESSAGES flm WHERE flm.TRANSACTION_CONTEXT_ID=p_TrList(ii));
902:
903: l_retu := sql%rowcount;

Line 987: FND_LOG_EXCEPTIONS fle

983: --Collect l_UEXList
984: l_UEXList1 := l_UEXListNull;
985: select distinct flue.UNIQUE_EXCEPTION_ID BULK COLLECT into l_UEXList1
986: from
987: FND_LOG_EXCEPTIONS fle
988: , FND_LOG_UNIQUE_EXCEPTIONS flue
989: where
990: fle.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)
991: and flue.UNIQUE_EXCEPTION_ID = fle.UNIQUE_EXCEPTION_ID ---

Line 1006: select LOG_SEQUENCE from FND_LOG_EXCEPTIONS fle

1002: (
1003: select LOG_SEQUENCE from FND_LOG_MESSAGES flm
1004: where flm.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)
1005: union
1006: select LOG_SEQUENCE from FND_LOG_EXCEPTIONS fle
1007: where fle.TRANSACTION_CONTEXT_ID = l_TrnCtxIdList(ii)
1008: and NOT EXISTS(select null from FND_LOG_MESSAGES flm1 where flm1.LOG_SEQUENCE=fle.LOG_SEQUENCE)
1009: );
1010: ---fdebug('l_LogSeqList1.count=' || l_LogSeqList1.count);

Line 1114: (select null from FND_LOG_EXCEPTIONS fle where fle.LOG_SEQUENCE = fla.LOG_SEQUENCE)

1110: commit;
1111:
1112: --Delete abondoned attachements
1113: delete from FND_LOG_ATTACHMENTS fla where NOT EXISTS
1114: (select null from FND_LOG_EXCEPTIONS fle where fle.LOG_SEQUENCE = fla.LOG_SEQUENCE)
1115: and NOT EXISTS (select null from FND_LOG_MESSAGES flm where flm.LOG_SEQUENCE = fla.LOG_SEQUENCE );
1116: commit;
1117:
1118: --delete the abondoned unque exceptions;