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_PENDING_DATA_API dependencies on FND_FILE

Line 1104: Fnd_file.put_line(FND_FILE.LOG,'Updated irc_pending_data with person_id:'||l_person_id);

1100: set person_id = l_person_id
1101: ,last_update_date = trunc(sysdate)
1102: where pending_data_id = l_data.pending_data_id;
1103: commit;
1104: Fnd_file.put_line(FND_FILE.LOG,'Updated irc_pending_data with person_id:'||l_person_id);
1105: --
1106: -- create/update documents for users who have uploaded their resumes
1107: --
1108: hr_utility.set_location(l_proc, 45);

Line 1139: Fnd_file.put_line(FND_FILE.LOG,'Updating resume document for the Candidate: '||l_resume_file_name||': document_id='||l_document_id);

1135: --
1136: if l_resume_file_name is not null then
1137: if l_document_id is not null then
1138: hr_utility.set_location(l_proc, 55);
1139: Fnd_file.put_line(FND_FILE.LOG,'Updating resume document for the Candidate: '||l_resume_file_name||': document_id='||l_document_id);
1140: irc_document_api.update_document_track
1141: (p_effective_date => l_data.creation_date
1142: ,p_document_id => l_document_id
1143: ,p_mime_type => l_resume_mime_type

Line 1154: Fnd_file.put_line(FND_FILE.LOG,'Updated Resume document for the Candidate:'||l_document_id);

1150: ,p_assignment_id => l_assignment_id
1151: ,p_object_version_number => l_doc_ovn
1152: ,p_new_doc_id => l_new_doc_id
1153: );
1154: Fnd_file.put_line(FND_FILE.LOG,'Updated Resume document for the Candidate:'||l_document_id);
1155: If l_document_id <> l_new_doc_id then
1156: Fnd_file.put_line(FND_FILE.LOG,'Created Resume document for the Candidate:'||l_new_doc_id);
1157: end if;
1158: else

Line 1156: Fnd_file.put_line(FND_FILE.LOG,'Created Resume document for the Candidate:'||l_new_doc_id);

1152: ,p_new_doc_id => l_new_doc_id
1153: );
1154: Fnd_file.put_line(FND_FILE.LOG,'Updated Resume document for the Candidate:'||l_document_id);
1155: If l_document_id <> l_new_doc_id then
1156: Fnd_file.put_line(FND_FILE.LOG,'Created Resume document for the Candidate:'||l_new_doc_id);
1157: end if;
1158: else
1159: hr_utility.set_location(l_proc, 60);
1160: Fnd_file.put_line(FND_FILE.LOG,'Creating resume document for the Candidate: '||l_resume_file_name);

Line 1160: Fnd_file.put_line(FND_FILE.LOG,'Creating resume document for the Candidate: '||l_resume_file_name);

1156: Fnd_file.put_line(FND_FILE.LOG,'Created Resume document for the Candidate:'||l_new_doc_id);
1157: end if;
1158: else
1159: hr_utility.set_location(l_proc, 60);
1160: Fnd_file.put_line(FND_FILE.LOG,'Creating resume document for the Candidate: '||l_resume_file_name);
1161: irc_document_api.create_document
1162: (p_effective_date => l_data.creation_date
1163: ,p_type => 'RESUME'
1164: ,p_person_id => l_person_id

Line 1171: Fnd_file.put_line(FND_FILE.LOG,'Created new Resume document for the Candidate:'||l_resume_file_name);

1167: ,p_description => l_resume_description
1168: ,p_document_id => l_new_doc_id
1169: ,p_object_version_number => l_doc_ovn
1170: );
1171: Fnd_file.put_line(FND_FILE.LOG,'Created new Resume document for the Candidate:'||l_resume_file_name);
1172: end if;
1173: end if;
1174: hr_utility.set_location(l_proc, 65);
1175: if l_new_doc_id is not null then

Line 1186: Fnd_file.put_line(FND_FILE.LOG,'Checking if this applicant is an employee and is applying for an internal vacancy only:');

1182: if l_data.vacancy_id is not null then
1183: -- fix for bug 4046889
1184: -- check if this Person is an Employee and if he is applying for an
1185: -- External vacancy
1186: Fnd_file.put_line(FND_FILE.LOG,'Checking if this applicant is an employee and is applying for an internal vacancy only:');
1187: l_person_type := irc_utilities_pkg.get_emp_spt_for_person(p_person_id=>l_person_id, p_eff_date=>trunc(l_data.creation_date));
1188: if (l_person_type = 'EMP') then
1189: open csr_is_internal_vacancy(l_data.vacancy_id, trunc(l_data.creation_date));
1190: fetch csr_is_internal_vacancy into l_num;

Line 1194: Fnd_file.put_line(FND_FILE.LOG,'Employee cannot apply for External Vacancy:'||l_data.vacancy_id);

1190: fetch csr_is_internal_vacancy into l_num;
1191: if csr_is_internal_vacancy%notfound then
1192: hr_utility.set_location(l_proc, 72);
1193: close csr_is_internal_vacancy;
1194: Fnd_file.put_line(FND_FILE.LOG,'Employee cannot apply for External Vacancy:'||l_data.vacancy_id);
1195: hr_utility.set_message(800,'IRC_412140_JOB_NOT_AVAILABLE');
1196: hr_utility.raise_error;
1197: else
1198: close csr_is_internal_vacancy;

Line 1202: Fnd_file.put_line(FND_FILE.LOG,'Checking if this person has already applied for a vacancy in this BG:');

1198: close csr_is_internal_vacancy;
1199: end if;
1200: end if;
1201: -- check if this person has already applied in the Vacancy BG
1202: Fnd_file.put_line(FND_FILE.LOG,'Checking if this person has already applied for a vacancy in this BG:');
1203: open csr_get_person_id_in_vac_bg(l_person_id,l_data.vacancy_id);
1204: fetch csr_get_person_id_in_vac_bg
1205: into l_applicant_person_id
1206: ,l_appl_ovn

Line 1241: Fnd_file.put_line(FND_FILE.LOG,'Already applied for job:'||l_data.vacancy_id);

1237: fetch csr_job_applied_for into l_num;
1238: if csr_job_applied_for%found then
1239: hr_utility.set_location(l_proc, 82);
1240: close csr_job_applied_for;
1241: Fnd_file.put_line(FND_FILE.LOG,'Already applied for job:'||l_data.vacancy_id);
1242: hr_utility.set_message(800,'IRC_APL_ALREADY_APPLIED');
1243: hr_utility.raise_error;
1244: else
1245: close csr_job_applied_for;

Line 1248: Fnd_file.put_line(FND_FILE.LOG,'Applying for Job Vacancy:'||l_data.vacancy_id);

1244: else
1245: close csr_job_applied_for;
1246: end if;
1247: end if;
1248: Fnd_file.put_line(FND_FILE.LOG,'Applying for Job Vacancy:'||l_data.vacancy_id);
1249: -- call the registered_user_application API to create the Job application
1250: irc_party_api.registered_user_application
1251: (p_effective_date => l_data.creation_date
1252: ,p_recruitment_person_id => l_person_id

Line 1262: Fnd_file.put_line(FND_FILE.LOG,'Applied successfully for vacancy:'||l_data.vacancy_id);

1258: ,p_per_object_version_number => l_per_ovn
1259: ,p_asg_object_version_number => l_asg_ovn
1260: ,p_applicant_number => l_applicant_number
1261: );
1262: Fnd_file.put_line(FND_FILE.LOG,'Applied successfully for vacancy:'||l_data.vacancy_id);
1263: --
1264: hr_utility.set_location(l_proc, 83);
1265: hr_person_api.update_person
1266: (p_effective_date => l_data.creation_date

Line 1315: Fnd_file.put_line(FND_FILE.LOG,'Updated person record with EEO information');

1311: ,p_name_combination_warning => l_name_combination_warning
1312: ,p_assign_payroll_warning => l_assign_payroll_warning
1313: ,p_orig_hire_warning => l_orig_hire_warning
1314: );
1315: Fnd_file.put_line(FND_FILE.LOG,'Updated person record with EEO information');
1316: close csr_get_person_id_in_vac_bg;
1317: end if;
1318: hr_utility.set_location(l_proc, 90);
1319: --

Line 1342: Fnd_file.put_line(FND_FILE.LOG,'An error occurred--'||l_err_msg);

1338: set ipd.processed='F'
1339: ,ipd.error_message=l_msg
1340: ,ipd.last_update_date=trunc(sysdate)
1341: where ipd.pending_data_id=l_data.pending_data_id;
1342: Fnd_file.put_line(FND_FILE.LOG,'An error occurred--'||l_err_msg);
1343: hr_utility.set_location('Leaving '||l_proc, 100);
1344: commit;
1345: end;
1346: end loop;

Line 1420: Fnd_file.put_line(FND_FILE.LOG,'Sending Notifications');

1416: vac_rows1 := 1;
1417: com_rows1 := 1;
1418: --
1419: hr_utility.set_location('Entering '||l_proc, 10);
1420: Fnd_file.put_line(FND_FILE.LOG,'Sending Notifications');
1421: --
1422: /* Process the pending data records having statuses 'A','R','E' or 'F'
1423: and having vacancy_id populated. For each of the records build the HTML
1424: test and send notifications to the user.

Line 1428: Fnd_file.put_line(FND_FILE.LOG,'Checking the row with email_address: '||l_applied_data.email_address||' and pending_data_id '||l_applied_data.pending_data_id);

1424: test and send notifications to the user.
1425: Successful completion would set the processed status to 'S' */
1426: for l_applied_data in csr_get_applied_vacancies loop
1427: --
1428: Fnd_file.put_line(FND_FILE.LOG,'Checking the row with email_address: '||l_applied_data.email_address||' and pending_data_id '||l_applied_data.pending_data_id);
1429: hr_utility.set_location(l_proc, 20);
1430: --
1431: if l_applied_data.email_address <> l_curr_email
1432: and (l_success_vacancies_list.exists(1)

Line 1436: Fnd_file.put_line(FND_FILE.LOG,'Building the notification text for '||l_curr_email);

1432: and (l_success_vacancies_list.exists(1)
1433: or l_failed_vacancies_list.exists(1) ) then
1434: --
1435: hr_utility.set_location(l_proc, 25);
1436: Fnd_file.put_line(FND_FILE.LOG,'Building the notification text for '||l_curr_email);
1437: --
1438: -- Registration confirmation message to be shown to new users only
1439: --
1440: open csr_is_new_user(l_curr_email);

Line 1454: Fnd_file.put_line(FND_FILE.LOG,'Building list of successfull applications');

1450: -- construct the HTML/text body containing the successful vacancies list
1451: -- append comments from each application
1452: --
1453: if l_success_vacancies_list.exists(1) then
1454: Fnd_file.put_line(FND_FILE.LOG,'Building list of successfull applications');
1455: --
1456: -- Construct html list of successful jobs applied for
1457: --
1458: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_APPLD')

Line 1492: Fnd_file.put_line(FND_FILE.LOG,'Building list of failed applications');

1488: -- construct the HTML/text body containing the failed vacancies list
1489: -- append comments from each application
1490: --
1491: if l_failed_vacancies_list.exists(1) then
1492: Fnd_file.put_line(FND_FILE.LOG,'Building list of failed applications');
1493: --
1494: -- Construct html list of failed jobs applied for
1495: --
1496: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_FAILED')

Line 1530: Fnd_file.put_line(FND_FILE.LOG,'Resume has been uploaded by the applicant and successfully parsed');

1526: end if;
1527: --
1528: --
1529: if l_resume = 'true' then
1530: Fnd_file.put_line(FND_FILE.LOG,'Resume has been uploaded by the applicant and successfully parsed');
1531: --
1532: -- add additional message to notify successful resume parsing
1533: --
1534: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_PASS')

Line 1540: Fnd_file.put_line(FND_FILE.LOG,'Resume has been uploaded by the applicant and parsing failed');

1536: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_PASS')
1537: || '\n';
1538: --
1539: elsif l_resume = 'false' then
1540: Fnd_file.put_line(FND_FILE.LOG,'Resume has been uploaded by the applicant and parsing failed');
1541: --
1542: -- add additional message to indicate failed resume parsing
1543: --
1544: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_FAILED')

Line 1563: Fnd_file.put_line(FND_FILE.LOG,'Notifying the user with subject line about registration and job application');

1559: -- Notify with different subjects for a new user and existing user
1560: --
1561: if csr_is_new_user%found then
1562: close csr_is_new_user;
1563: Fnd_file.put_line(FND_FILE.LOG,'Notifying the user with subject line about registration and job application');
1564: l_notif_id := irc_notification_helper_pkg.send_notification
1565: (p_user_name => l_curr_email
1566: ,p_subject => fnd_message.get_string('PER','IRC_HA_NOTIF_NEW_USER_SUBJ')
1567: ,p_html_body => l_msg_html

Line 1573: Fnd_file.put_line(FND_FILE.LOG,'Notifying the user with subject line about job application');

1569: ,p_from_role => 'SYSADMIN'
1570: );
1571: else
1572: close csr_is_new_user;
1573: Fnd_file.put_line(FND_FILE.LOG,'Notifying the user with subject line about job application');
1574: l_notif_id := irc_notification_helper_pkg.send_notification
1575: (p_user_name => l_curr_email
1576: ,p_subject => fnd_message.get_string('PER','IRC_APL_JOBAPPL_NOTIF_SUBJECT')
1577: ,p_html_body => l_msg_html

Line 1598: Fnd_file.put_line(FND_FILE.LOG,'Processing the row with status '||l_applied_data.processed);

1594: else
1595: vac_rows := vac_rows+1;
1596: com_rows := com_rows+1;
1597: end if;
1598: Fnd_file.put_line(FND_FILE.LOG,'Processing the row with status '||l_applied_data.processed);
1599: if l_applied_data.processed = 'R' then
1600: l_resume := 'true';
1601: l_success_vacancies_list(vac_rows-1) := l_applied_data.name;
1602: open csr_posting_title(l_applied_data.posting_content_id);

Line 1634: Fnd_file.put_line(FND_FILE.LOG,'Updated the processed flag to S');

1630: update irc_pending_data
1631: set processed='S'
1632: ,last_update_date=trunc(sysdate)
1633: where pending_data_id=l_applied_data.pending_data_id;
1634: Fnd_file.put_line(FND_FILE.LOG,'Updated the processed flag to S');
1635: end loop;
1636: Fnd_file.put_line(FND_FILE.LOG,'Building the message for the last user');
1637: --
1638: -- Registration confirmation message to be shown to new users only

Line 1636: Fnd_file.put_line(FND_FILE.LOG,'Building the message for the last user');

1632: ,last_update_date=trunc(sysdate)
1633: where pending_data_id=l_applied_data.pending_data_id;
1634: Fnd_file.put_line(FND_FILE.LOG,'Updated the processed flag to S');
1635: end loop;
1636: Fnd_file.put_line(FND_FILE.LOG,'Building the message for the last user');
1637: --
1638: -- Registration confirmation message to be shown to new users only
1639: --
1640: open csr_is_new_user(l_curr_email);

Line 1659: Fnd_file.put_line(FND_FILE.LOG,'Building list of successfull applications for last user');

1655: -- construct the HTML/text body containing the successful vacancies list
1656: -- append comments from each application
1657: --
1658: if vac_rows > 1 then
1659: Fnd_file.put_line(FND_FILE.LOG,'Building list of successfull applications for last user');
1660: --
1661: -- Construct html list of successful jobs applied for
1662: --
1663: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_APPLD')

Line 1692: Fnd_file.put_line(FND_FILE.LOG,'Building list of failed applications for last user');

1688: end loop;
1689: end if;
1690: --
1691: if vac_rows1 > 1 then
1692: Fnd_file.put_line(FND_FILE.LOG,'Building list of failed applications for last user');
1693: --
1694: -- construct the HTML/text body containing the failed vacancies list
1695: -- append comments from each application
1696: --

Line 1731: Fnd_file.put_line(FND_FILE.LOG,'Last user had a successfull resume parse');

1727: end loop;
1728: end if;
1729: --
1730: if l_resume = 'true' then
1731: Fnd_file.put_line(FND_FILE.LOG,'Last user had a successfull resume parse');
1732: --
1733: -- add additional message to notify successful resume parsing
1734: --
1735: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_PASS')

Line 1741: Fnd_file.put_line(FND_FILE.LOG,'Last user had a unsuccessfull resume parse');

1737: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_PASS')
1738: || '\n';
1739: --
1740: elsif l_resume = 'false' then
1741: Fnd_file.put_line(FND_FILE.LOG,'Last user had a unsuccessfull resume parse');
1742: --
1743: -- add additional message to indicate failed resume parsing
1744: --
1745: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_FAILED')

Line 1766: Fnd_file.put_line(FND_FILE.LOG,'Notifying last user with subject line about registration and job application');

1762: -- Notify with different subjects for a new user and existing user
1763: --
1764: if csr_is_new_user%found then
1765: close csr_is_new_user;
1766: Fnd_file.put_line(FND_FILE.LOG,'Notifying last user with subject line about registration and job application');
1767: l_notif_id := irc_notification_helper_pkg.send_notification
1768: (p_user_name => l_curr_email
1769: ,p_subject => fnd_message.get_string('PER','IRC_HA_NOTIF_NEW_USER_SUBJ')
1770: ,p_html_body => l_msg_html

Line 1776: Fnd_file.put_line(FND_FILE.LOG,'Notifying last user with subject line about job application');

1772: ,p_from_role => 'SYSADMIN'
1773: );
1774: else
1775: close csr_is_new_user;
1776: Fnd_file.put_line(FND_FILE.LOG,'Notifying last user with subject line about job application');
1777: l_notif_id := irc_notification_helper_pkg.send_notification
1778: (p_user_name => l_curr_email
1779: ,p_subject => fnd_message.get_string('PER','IRC_APL_JOBAPPL_NOTIF_SUBJECT')
1780: ,p_html_body => l_msg_html