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

Line 542: Fnd_file.put_line(FND_FILE.LOG,l_print_element_info);

538: rpad(nvl(to_char(p_root_person_id),' '),10)||' '||
539: rpad(nvl(to_char(p_party_id),' '),10)||' '||
540: rpad(nvl('SUCCESS',' '),10);
541: --
542: Fnd_file.put_line(FND_FILE.LOG,l_print_element_info);
543: hr_utility.set_location('Leaving Notify or Purge:'||l_proc, 100);
544: exception
545: when others then
546: l_print_element_info := rpad(nvl(l_person_full_name,' '),60)||' '||

Line 550: Fnd_file.put_line(FND_FILE.LOG,l_print_element_info);

546: l_print_element_info := rpad(nvl(l_person_full_name,' '),60)||' '||
547: rpad(nvl(to_char(p_root_person_id),' '),10)||' '||
548: rpad(nvl(to_char(p_party_id),' '),10)||' '||
549: rpad(nvl('FAILURE',' '),10);
550: Fnd_file.put_line(FND_FILE.LOG,l_print_element_info);
551: Fnd_file.put_line(FND_FILE.LOG,' FAILURE REASON:'||sqlerrm);
552: hr_utility.set_location('Leaving Notify or Purge:'||l_proc, 100);
553: rollback;
554: end notify_or_purge;

Line 551: Fnd_file.put_line(FND_FILE.LOG,' FAILURE REASON:'||sqlerrm);

547: rpad(nvl(to_char(p_root_person_id),' '),10)||' '||
548: rpad(nvl(to_char(p_party_id),' '),10)||' '||
549: rpad(nvl('FAILURE',' '),10);
550: Fnd_file.put_line(FND_FILE.LOG,l_print_element_info);
551: Fnd_file.put_line(FND_FILE.LOG,' FAILURE REASON:'||sqlerrm);
552: hr_utility.set_location('Leaving Notify or Purge:'||l_proc, 100);
553: rollback;
554: end notify_or_purge;
555: --

Line 751: Fnd_file.put_line(FND_FILE.LOG,l_header);

747: rpad('-',10,'-')||' '||
748: rpad('-',10,'-')||' '||
749: rpad('-',10,'-');
750: --
751: Fnd_file.put_line(FND_FILE.LOG,l_header);
752: Fnd_file.put_line(FND_FILE.LOG,l_underline);
753: if(p_measure_type = 'LOGINDATE') then
754: --
755: hr_utility.set_location(l_proc, 20);

Line 752: Fnd_file.put_line(FND_FILE.LOG,l_underline);

748: rpad('-',10,'-')||' '||
749: rpad('-',10,'-');
750: --
751: Fnd_file.put_line(FND_FILE.LOG,l_header);
752: Fnd_file.put_line(FND_FILE.LOG,l_underline);
753: if(p_measure_type = 'LOGINDATE') then
754: --
755: hr_utility.set_location(l_proc, 20);
756: for rec_last_login_date in csr_last_login_date loop

Line 825: Fnd_file.put_line(FND_FILE.LOG,'This report shows the result of the candidates processed using following');

821: close getprstype;
822: open getmeasureType(p_measure_type);
823: fetch getmeasureType into l_measure_type;
824: close getmeasureType;
825: Fnd_file.put_line(FND_FILE.LOG,'This report shows the result of the candidates processed using following');
826: Fnd_file.put_line(FND_FILE.LOG,'parameter');
827: Fnd_file.put_line(FND_FILE.LOG,' ');
828: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
829: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);

Line 826: Fnd_file.put_line(FND_FILE.LOG,'parameter');

822: open getmeasureType(p_measure_type);
823: fetch getmeasureType into l_measure_type;
824: close getmeasureType;
825: Fnd_file.put_line(FND_FILE.LOG,'This report shows the result of the candidates processed using following');
826: Fnd_file.put_line(FND_FILE.LOG,'parameter');
827: Fnd_file.put_line(FND_FILE.LOG,' ');
828: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
829: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);
830: Fnd_file.put_line(FND_FILE.LOG,'Effective Date:'||p_effective_date);

Line 827: Fnd_file.put_line(FND_FILE.LOG,' ');

823: fetch getmeasureType into l_measure_type;
824: close getmeasureType;
825: Fnd_file.put_line(FND_FILE.LOG,'This report shows the result of the candidates processed using following');
826: Fnd_file.put_line(FND_FILE.LOG,'parameter');
827: Fnd_file.put_line(FND_FILE.LOG,' ');
828: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
829: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);
830: Fnd_file.put_line(FND_FILE.LOG,'Effective Date:'||p_effective_date);
831: Fnd_file.put_line(FND_FILE.LOG,'Months Since Activity:'||p_months);

Line 828: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);

824: close getmeasureType;
825: Fnd_file.put_line(FND_FILE.LOG,'This report shows the result of the candidates processed using following');
826: Fnd_file.put_line(FND_FILE.LOG,'parameter');
827: Fnd_file.put_line(FND_FILE.LOG,' ');
828: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
829: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);
830: Fnd_file.put_line(FND_FILE.LOG,'Effective Date:'||p_effective_date);
831: Fnd_file.put_line(FND_FILE.LOG,'Months Since Activity:'||p_months);
832: irc_purge_old_data_pkg.purge_records

Line 829: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);

825: Fnd_file.put_line(FND_FILE.LOG,'This report shows the result of the candidates processed using following');
826: Fnd_file.put_line(FND_FILE.LOG,'parameter');
827: Fnd_file.put_line(FND_FILE.LOG,' ');
828: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
829: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);
830: Fnd_file.put_line(FND_FILE.LOG,'Effective Date:'||p_effective_date);
831: Fnd_file.put_line(FND_FILE.LOG,'Months Since Activity:'||p_months);
832: irc_purge_old_data_pkg.purge_records
833: (p_effective_date => fnd_date.canonical_to_date(p_effective_date)

Line 830: Fnd_file.put_line(FND_FILE.LOG,'Effective Date:'||p_effective_date);

826: Fnd_file.put_line(FND_FILE.LOG,'parameter');
827: Fnd_file.put_line(FND_FILE.LOG,' ');
828: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
829: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);
830: Fnd_file.put_line(FND_FILE.LOG,'Effective Date:'||p_effective_date);
831: Fnd_file.put_line(FND_FILE.LOG,'Months Since Activity:'||p_months);
832: irc_purge_old_data_pkg.purge_records
833: (p_effective_date => fnd_date.canonical_to_date(p_effective_date)
834: ,p_process_type => p_process_type

Line 831: Fnd_file.put_line(FND_FILE.LOG,'Months Since Activity:'||p_months);

827: Fnd_file.put_line(FND_FILE.LOG,' ');
828: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
829: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);
830: Fnd_file.put_line(FND_FILE.LOG,'Effective Date:'||p_effective_date);
831: Fnd_file.put_line(FND_FILE.LOG,'Months Since Activity:'||p_months);
832: irc_purge_old_data_pkg.purge_records
833: (p_effective_date => fnd_date.canonical_to_date(p_effective_date)
834: ,p_process_type => p_process_type
835: ,p_months => p_months