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 669: Fnd_file.put_line(FND_FILE.LOG,l_print_element_info);

665: rpad(nvl(to_char(p_root_person_id),' '),10)||' '||
666: rpad(nvl(to_char(p_party_id),' '),10)||' '||
667: rpad(nvl('SUCCESS',' '),10);
668: --
669: Fnd_file.put_line(FND_FILE.LOG,l_print_element_info);
670: hr_utility.set_location('Leaving Notify or Purge:'||l_proc, 100);
671: exception
672: when others then
673: l_print_element_info := rpad(nvl(l_person_full_name,' '),60)||' '||

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

673: l_print_element_info := rpad(nvl(l_person_full_name,' '),60)||' '||
674: rpad(nvl(to_char(p_root_person_id),' '),10)||' '||
675: rpad(nvl(to_char(p_party_id),' '),10)||' '||
676: rpad(nvl('FAILURE',' '),10);
677: Fnd_file.put_line(FND_FILE.LOG,l_print_element_info);
678: Fnd_file.put_line(FND_FILE.LOG,' FAILURE REASON:'||sqlerrm);
679: hr_utility.set_location('Leaving Notify or Purge:'||l_proc, 100);
680: rollback;
681: end notify_or_purge;

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

674: rpad(nvl(to_char(p_root_person_id),' '),10)||' '||
675: rpad(nvl(to_char(p_party_id),' '),10)||' '||
676: rpad(nvl('FAILURE',' '),10);
677: Fnd_file.put_line(FND_FILE.LOG,l_print_element_info);
678: Fnd_file.put_line(FND_FILE.LOG,' FAILURE REASON:'||sqlerrm);
679: hr_utility.set_location('Leaving Notify or Purge:'||l_proc, 100);
680: rollback;
681: end notify_or_purge;
682: --

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

874: rpad('-',10,'-')||' '||
875: rpad('-',10,'-')||' '||
876: rpad('-',10,'-');
877: --
878: Fnd_file.put_line(FND_FILE.LOG,l_header);
879: Fnd_file.put_line(FND_FILE.LOG,l_underline);
880: if(p_measure_type = 'LOGINDATE') then
881: --
882: hr_utility.set_location(l_proc, 20);

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

875: rpad('-',10,'-')||' '||
876: rpad('-',10,'-');
877: --
878: Fnd_file.put_line(FND_FILE.LOG,l_header);
879: Fnd_file.put_line(FND_FILE.LOG,l_underline);
880: if(p_measure_type = 'LOGINDATE') then
881: --
882: hr_utility.set_location(l_proc, 20);
883: for rec_last_login_date in csr_last_login_date loop

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

948: close getprstype;
949: open getmeasureType(p_measure_type);
950: fetch getmeasureType into l_measure_type;
951: close getmeasureType;
952: Fnd_file.put_line(FND_FILE.LOG,'This report shows the result of the candidates processed using following');
953: Fnd_file.put_line(FND_FILE.LOG,'parameter');
954: Fnd_file.put_line(FND_FILE.LOG,' ');
955: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
956: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);

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

949: open getmeasureType(p_measure_type);
950: fetch getmeasureType into l_measure_type;
951: close getmeasureType;
952: Fnd_file.put_line(FND_FILE.LOG,'This report shows the result of the candidates processed using following');
953: Fnd_file.put_line(FND_FILE.LOG,'parameter');
954: Fnd_file.put_line(FND_FILE.LOG,' ');
955: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
956: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);
957: Fnd_file.put_line(FND_FILE.LOG,'Effective Date:'||p_effective_date);

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

950: fetch getmeasureType into l_measure_type;
951: close getmeasureType;
952: Fnd_file.put_line(FND_FILE.LOG,'This report shows the result of the candidates processed using following');
953: Fnd_file.put_line(FND_FILE.LOG,'parameter');
954: Fnd_file.put_line(FND_FILE.LOG,' ');
955: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
956: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);
957: Fnd_file.put_line(FND_FILE.LOG,'Effective Date:'||p_effective_date);
958: Fnd_file.put_line(FND_FILE.LOG,'Months Since Activity:'||p_months);

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

951: close getmeasureType;
952: Fnd_file.put_line(FND_FILE.LOG,'This report shows the result of the candidates processed using following');
953: Fnd_file.put_line(FND_FILE.LOG,'parameter');
954: Fnd_file.put_line(FND_FILE.LOG,' ');
955: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
956: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);
957: Fnd_file.put_line(FND_FILE.LOG,'Effective Date:'||p_effective_date);
958: Fnd_file.put_line(FND_FILE.LOG,'Months Since Activity:'||p_months);
959: irc_purge_old_data_pkg.purge_records

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

952: Fnd_file.put_line(FND_FILE.LOG,'This report shows the result of the candidates processed using following');
953: Fnd_file.put_line(FND_FILE.LOG,'parameter');
954: Fnd_file.put_line(FND_FILE.LOG,' ');
955: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
956: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);
957: Fnd_file.put_line(FND_FILE.LOG,'Effective Date:'||p_effective_date);
958: Fnd_file.put_line(FND_FILE.LOG,'Months Since Activity:'||p_months);
959: irc_purge_old_data_pkg.purge_records
960: (p_effective_date => fnd_date.canonical_to_date(p_effective_date)

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

953: Fnd_file.put_line(FND_FILE.LOG,'parameter');
954: Fnd_file.put_line(FND_FILE.LOG,' ');
955: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
956: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);
957: Fnd_file.put_line(FND_FILE.LOG,'Effective Date:'||p_effective_date);
958: Fnd_file.put_line(FND_FILE.LOG,'Months Since Activity:'||p_months);
959: irc_purge_old_data_pkg.purge_records
960: (p_effective_date => fnd_date.canonical_to_date(p_effective_date)
961: ,p_process_type => p_process_type

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

954: Fnd_file.put_line(FND_FILE.LOG,' ');
955: Fnd_file.put_line(FND_FILE.LOG,'Purge Type:'||l_measure_type);
956: Fnd_file.put_line(FND_FILE.LOG,'Activity Criteria:'||l_process_type);
957: Fnd_file.put_line(FND_FILE.LOG,'Effective Date:'||p_effective_date);
958: Fnd_file.put_line(FND_FILE.LOG,'Months Since Activity:'||p_months);
959: irc_purge_old_data_pkg.purge_records
960: (p_effective_date => fnd_date.canonical_to_date(p_effective_date)
961: ,p_process_type => p_process_type
962: ,p_months => p_months