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_MESSAGE

Line 188: fnd_message.set_name('PER','IRC_EMAIL_ALREADY_REGISTERED');

184: ,x_password_date => sysdate
185: );
186: hr_utility.set_location(l_proc,30);
187: else
188: fnd_message.set_name('PER','IRC_EMAIL_ALREADY_REGISTERED');
189: fnd_message.set_token('USER_NAME',p_email_address);
190: fnd_message.raise_error;
191: end if;
192: end if;

Line 189: fnd_message.set_token('USER_NAME',p_email_address);

185: );
186: hr_utility.set_location(l_proc,30);
187: else
188: fnd_message.set_name('PER','IRC_EMAIL_ALREADY_REGISTERED');
189: fnd_message.set_token('USER_NAME',p_email_address);
190: fnd_message.raise_error;
191: end if;
192: end if;
193: -- get the user details

Line 190: fnd_message.raise_error;

186: hr_utility.set_location(l_proc,30);
187: else
188: fnd_message.set_name('PER','IRC_EMAIL_ALREADY_REGISTERED');
189: fnd_message.set_token('USER_NAME',p_email_address);
190: fnd_message.raise_error;
191: end if;
192: end if;
193: -- get the user details
194: open csr_fnd_user_details;

Line 1443: fnd_message.set_name('PER', 'IRC_HA_NOTIF_NEW_USER_BODY');

1439: --
1440: open csr_is_new_user(l_curr_email);
1441: fetch csr_is_new_user into l_password;
1442: if csr_is_new_user%found then
1443: fnd_message.set_name('PER', 'IRC_HA_NOTIF_NEW_USER_BODY');
1444: fnd_message.set_token('NAME', upper(l_curr_email));
1445: l_new_user_text := fnd_message.get;
1446: l_msg_html := l_msg_html|| '
'||l_new_user_text || '
';
1447: l_msg_text := l_msg_text|| '\n'||l_new_user_text || '\n';

Line 1444: fnd_message.set_token('NAME', upper(l_curr_email));

1440: open csr_is_new_user(l_curr_email);
1441: fetch csr_is_new_user into l_password;
1442: if csr_is_new_user%found then
1443: fnd_message.set_name('PER', 'IRC_HA_NOTIF_NEW_USER_BODY');
1444: fnd_message.set_token('NAME', upper(l_curr_email));
1445: l_new_user_text := fnd_message.get;
1446: l_msg_html := l_msg_html|| '
'||l_new_user_text || '
';
1447: l_msg_text := l_msg_text|| '\n'||l_new_user_text || '\n';
1448: end if;

Line 1445: l_new_user_text := fnd_message.get;

1441: fetch csr_is_new_user into l_password;
1442: if csr_is_new_user%found then
1443: fnd_message.set_name('PER', 'IRC_HA_NOTIF_NEW_USER_BODY');
1444: fnd_message.set_token('NAME', upper(l_curr_email));
1445: l_new_user_text := fnd_message.get;
1446: l_msg_html := l_msg_html|| '
'||l_new_user_text || '
';
1447: l_msg_text := l_msg_text|| '\n'||l_new_user_text || '\n';
1448: end if;
1449: --

Line 1458: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_APPLD')

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')
1459: || '
';
1460: l_msg_text := l_msg_text|| '\n' ||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_APPLD')
1461: || '\n';
1462: --

Line 1460: l_msg_text := l_msg_text|| '\n' ||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_APPLD')

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')
1459: || '
';
1460: l_msg_text := l_msg_text|| '\n' ||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_APPLD')
1461: || '\n';
1462: --
1463: curr_row := 1;
1464: while (curr_row <> vac_rows) loop

Line 1465: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');

1461: || '\n';
1462: --
1463: curr_row := 1;
1464: while (curr_row <> vac_rows) loop
1465: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1466: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1467: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1468: l_display_name := fnd_message.get;
1469: l_msg_html := l_msg_html||l_display_name|| '
';

Line 1466: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));

1462: --
1463: curr_row := 1;
1464: while (curr_row <> vac_rows) loop
1465: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1466: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1467: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1468: l_display_name := fnd_message.get;
1469: l_msg_html := l_msg_html||l_display_name|| '
';
1470: curr_row := curr_row+1;

Line 1467: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));

1463: curr_row := 1;
1464: while (curr_row <> vac_rows) loop
1465: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1466: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1467: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1468: l_display_name := fnd_message.get;
1469: l_msg_html := l_msg_html||l_display_name|| '
';
1470: curr_row := curr_row+1;
1471: end loop;

Line 1468: l_display_name := fnd_message.get;

1464: while (curr_row <> vac_rows) loop
1465: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1466: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1467: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1468: l_display_name := fnd_message.get;
1469: l_msg_html := l_msg_html||l_display_name|| '
';
1470: curr_row := curr_row+1;
1471: end loop;
1472: --

Line 1477: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');

1473: -- Construct text list of successful jobs applied for
1474: --
1475: curr_row := 1;
1476: while (curr_row <> vac_rows) loop
1477: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1478: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1479: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1480: l_display_name := fnd_message.get;
1481: l_msg_text := l_msg_text||l_display_name|| '\n';

Line 1478: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));

1474: --
1475: curr_row := 1;
1476: while (curr_row <> vac_rows) loop
1477: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1478: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1479: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1480: l_display_name := fnd_message.get;
1481: l_msg_text := l_msg_text||l_display_name|| '\n';
1482: curr_row := curr_row+1;

Line 1479: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));

1475: curr_row := 1;
1476: while (curr_row <> vac_rows) loop
1477: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1478: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1479: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1480: l_display_name := fnd_message.get;
1481: l_msg_text := l_msg_text||l_display_name|| '\n';
1482: curr_row := curr_row+1;
1483: end loop;

Line 1480: l_display_name := fnd_message.get;

1476: while (curr_row <> vac_rows) loop
1477: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1478: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1479: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1480: l_display_name := fnd_message.get;
1481: l_msg_text := l_msg_text||l_display_name|| '\n';
1482: curr_row := curr_row+1;
1483: end loop;
1484: vac_rows := 1;

Line 1496: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_FAILED')

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')
1497: || '
';
1498: l_msg_text := l_msg_text|| '\n' ||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_FAILED')
1499: || '\n';
1500: --

Line 1498: l_msg_text := l_msg_text|| '\n' ||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_FAILED')

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')
1497: || '
';
1498: l_msg_text := l_msg_text|| '\n' ||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_FAILED')
1499: || '\n';
1500: --
1501: curr_row := 1;
1502: while (curr_row <> vac_rows1) loop

Line 1503: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');

1499: || '\n';
1500: --
1501: curr_row := 1;
1502: while (curr_row <> vac_rows1) loop
1503: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1504: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1505: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1506: l_display_name := fnd_message.get;
1507: l_msg_html := l_msg_html||l_display_name|| ' - ';

Line 1504: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));

1500: --
1501: curr_row := 1;
1502: while (curr_row <> vac_rows1) loop
1503: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1504: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1505: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1506: l_display_name := fnd_message.get;
1507: l_msg_html := l_msg_html||l_display_name|| ' - ';
1508: l_msg_html := l_msg_html||l_failed_vac_comments_list(curr_row)|| '
';

Line 1505: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));

1501: curr_row := 1;
1502: while (curr_row <> vac_rows1) loop
1503: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1504: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1505: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1506: l_display_name := fnd_message.get;
1507: l_msg_html := l_msg_html||l_display_name|| ' - ';
1508: l_msg_html := l_msg_html||l_failed_vac_comments_list(curr_row)|| '
';
1509: curr_row := curr_row+1;

Line 1506: l_display_name := fnd_message.get;

1502: while (curr_row <> vac_rows1) loop
1503: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1504: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1505: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1506: l_display_name := fnd_message.get;
1507: l_msg_html := l_msg_html||l_display_name|| ' - ';
1508: l_msg_html := l_msg_html||l_failed_vac_comments_list(curr_row)|| '
';
1509: curr_row := curr_row+1;
1510: end loop;

Line 1516: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');

1512: -- Construct text list of failed jobs applied for
1513: --
1514: curr_row := 1;
1515: while (curr_row <> vac_rows1) loop
1516: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1517: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1518: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1519: l_display_name := fnd_message.get;
1520: l_msg_text := l_msg_text||l_display_name|| ' - ';

Line 1517: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));

1513: --
1514: curr_row := 1;
1515: while (curr_row <> vac_rows1) loop
1516: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1517: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1518: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1519: l_display_name := fnd_message.get;
1520: l_msg_text := l_msg_text||l_display_name|| ' - ';
1521: l_msg_text := l_msg_text||l_failed_vac_comments_list(curr_row)|| '\n';

Line 1518: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));

1514: curr_row := 1;
1515: while (curr_row <> vac_rows1) loop
1516: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1517: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1518: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1519: l_display_name := fnd_message.get;
1520: l_msg_text := l_msg_text||l_display_name|| ' - ';
1521: l_msg_text := l_msg_text||l_failed_vac_comments_list(curr_row)|| '\n';
1522: curr_row := curr_row+1;

Line 1519: l_display_name := fnd_message.get;

1515: while (curr_row <> vac_rows1) loop
1516: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1517: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1518: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1519: l_display_name := fnd_message.get;
1520: l_msg_text := l_msg_text||l_display_name|| ' - ';
1521: l_msg_text := l_msg_text||l_failed_vac_comments_list(curr_row)|| '\n';
1522: curr_row := curr_row+1;
1523: end loop;

Line 1534: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_PASS')

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')
1535: || '
';
1536: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_PASS')
1537: || '\n';
1538: --

Line 1536: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_PASS')

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')
1535: || '
';
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');

Line 1544: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_FAILED')

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')
1545: || '
';
1546: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_FAILED')
1547: || '\n';
1548: end if;

Line 1546: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_FAILED')

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')
1545: || '
';
1546: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_FAILED')
1547: || '\n';
1548: end if;
1549: --
1550: -- Append a generic message

Line 1552: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_MISC_TEXT')

1548: end if;
1549: --
1550: -- Append a generic message
1551: --
1552: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_MISC_TEXT')
1553: || '
';
1554: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_MISC_TEXT')
1555: || '\n';
1556: --

Line 1554: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_MISC_TEXT')

1550: -- Append a generic message
1551: --
1552: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_MISC_TEXT')
1553: || '
';
1554: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_MISC_TEXT')
1555: || '\n';
1556: --
1557: hr_utility.set_location(l_proc, 30);
1558: --

Line 1566: ,p_subject => fnd_message.get_string('PER','IRC_HA_NOTIF_NEW_USER_SUBJ')

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
1568: ,p_text_body => l_msg_text
1569: ,p_from_role => 'SYSADMIN'
1570: );

Line 1576: ,p_subject => fnd_message.get_string('PER','IRC_APL_JOBAPPL_NOTIF_SUBJECT')

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
1578: ,p_text_body => l_msg_text
1579: ,p_from_role => 'SYSADMIN'
1580: );

Line 1605: l_success_vac_comments_list(com_rows-1) := fnd_message.get_string('PER','IRC_JOB_APPLY_NOTIF_SUCCESS');

1601: l_success_vacancies_list(vac_rows-1) := l_applied_data.name;
1602: open csr_posting_title(l_applied_data.posting_content_id);
1603: fetch csr_posting_title into l_success_postings_list(vac_rows-1);
1604: close csr_posting_title;
1605: l_success_vac_comments_list(com_rows-1) := fnd_message.get_string('PER','IRC_JOB_APPLY_NOTIF_SUCCESS');
1606: elsif l_applied_data.processed = 'A' then
1607: l_success_vacancies_list(vac_rows-1) := l_applied_data.name;
1608: open csr_posting_title(l_applied_data.posting_content_id);
1609: fetch csr_posting_title into l_success_postings_list(vac_rows-1);

Line 1611: l_success_vac_comments_list(com_rows-1) := fnd_message.get_string('PER','IRC_JOB_APPLY_NOTIF_SUCCESS');

1607: l_success_vacancies_list(vac_rows-1) := l_applied_data.name;
1608: open csr_posting_title(l_applied_data.posting_content_id);
1609: fetch csr_posting_title into l_success_postings_list(vac_rows-1);
1610: close csr_posting_title;
1611: l_success_vac_comments_list(com_rows-1) := fnd_message.get_string('PER','IRC_JOB_APPLY_NOTIF_SUCCESS');
1612: elsif l_applied_data.processed = 'F' then
1613: l_failed_vacancies_list(vac_rows1-1) := l_applied_data.name;
1614: open csr_posting_title(l_applied_data.posting_content_id);
1615: fetch csr_posting_title into l_failed_postings_list(vac_rows1-1);

Line 1624: l_success_vac_comments_list(com_rows-1) := fnd_message.get_string('PER','IRC_JOB_APPLY_NOTIF_SUCCESS');

1620: l_success_vacancies_list(vac_rows-1) := l_applied_data.name;
1621: open csr_posting_title(l_applied_data.posting_content_id);
1622: fetch csr_posting_title into l_success_postings_list(vac_rows-1);
1623: close csr_posting_title;
1624: l_success_vac_comments_list(com_rows-1) := fnd_message.get_string('PER','IRC_JOB_APPLY_NOTIF_SUCCESS');
1625: end if;
1626: l_curr_email := l_applied_data.email_address;
1627: --
1628: --update processed to S for the current row

Line 1643: fnd_message.set_name('PER', 'IRC_HA_NOTIF_NEW_USER_BODY');

1639: --
1640: open csr_is_new_user(l_curr_email);
1641: fetch csr_is_new_user into l_password;
1642: if csr_is_new_user%found then
1643: fnd_message.set_name('PER', 'IRC_HA_NOTIF_NEW_USER_BODY');
1644: fnd_message.set_token('NAME', upper(l_curr_email));
1645: l_new_user_text := fnd_message.get;
1646: l_msg_html := l_msg_html|| '
'||l_new_user_text || '
';
1647: l_msg_text := l_msg_text|| '\n'||l_new_user_text || '\n';

Line 1644: fnd_message.set_token('NAME', upper(l_curr_email));

1640: open csr_is_new_user(l_curr_email);
1641: fetch csr_is_new_user into l_password;
1642: if csr_is_new_user%found then
1643: fnd_message.set_name('PER', 'IRC_HA_NOTIF_NEW_USER_BODY');
1644: fnd_message.set_token('NAME', upper(l_curr_email));
1645: l_new_user_text := fnd_message.get;
1646: l_msg_html := l_msg_html|| '
'||l_new_user_text || '
';
1647: l_msg_text := l_msg_text|| '\n'||l_new_user_text || '\n';
1648: end if;

Line 1645: l_new_user_text := fnd_message.get;

1641: fetch csr_is_new_user into l_password;
1642: if csr_is_new_user%found then
1643: fnd_message.set_name('PER', 'IRC_HA_NOTIF_NEW_USER_BODY');
1644: fnd_message.set_token('NAME', upper(l_curr_email));
1645: l_new_user_text := fnd_message.get;
1646: l_msg_html := l_msg_html|| '
'||l_new_user_text || '
';
1647: l_msg_text := l_msg_text|| '\n'||l_new_user_text || '\n';
1648: end if;
1649: --

Line 1663: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_APPLD')

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')
1664: || '
';
1665: l_msg_text := l_msg_text|| '\n' ||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_APPLD')
1666: || '\n';
1667: --

Line 1665: l_msg_text := l_msg_text|| '\n' ||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_APPLD')

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')
1664: || '
';
1665: l_msg_text := l_msg_text|| '\n' ||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_APPLD')
1666: || '\n';
1667: --
1668: curr_row := 1;
1669: while (curr_row <> vac_rows) loop

Line 1670: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');

1666: || '\n';
1667: --
1668: curr_row := 1;
1669: while (curr_row <> vac_rows) loop
1670: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1671: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1672: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1673: l_display_name := fnd_message.get;
1674: l_msg_html := l_msg_html||l_display_name|| '
';

Line 1671: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));

1667: --
1668: curr_row := 1;
1669: while (curr_row <> vac_rows) loop
1670: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1671: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1672: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1673: l_display_name := fnd_message.get;
1674: l_msg_html := l_msg_html||l_display_name|| '
';
1675: curr_row := curr_row+1;

Line 1672: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));

1668: curr_row := 1;
1669: while (curr_row <> vac_rows) loop
1670: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1671: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1672: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1673: l_display_name := fnd_message.get;
1674: l_msg_html := l_msg_html||l_display_name|| '
';
1675: curr_row := curr_row+1;
1676: end loop;

Line 1673: l_display_name := fnd_message.get;

1669: while (curr_row <> vac_rows) loop
1670: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1671: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1672: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1673: l_display_name := fnd_message.get;
1674: l_msg_html := l_msg_html||l_display_name|| '
';
1675: curr_row := curr_row+1;
1676: end loop;
1677: --

Line 1682: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');

1678: -- Construct text list of successful jobs applied for
1679: --
1680: curr_row := 1;
1681: while (curr_row <> vac_rows) loop
1682: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1683: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1684: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1685: l_display_name := fnd_message.get;
1686: l_msg_text := l_msg_text||l_display_name|| '\n';

Line 1683: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));

1679: --
1680: curr_row := 1;
1681: while (curr_row <> vac_rows) loop
1682: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1683: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1684: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1685: l_display_name := fnd_message.get;
1686: l_msg_text := l_msg_text||l_display_name|| '\n';
1687: curr_row := curr_row+1;

Line 1684: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));

1680: curr_row := 1;
1681: while (curr_row <> vac_rows) loop
1682: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1683: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1684: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1685: l_display_name := fnd_message.get;
1686: l_msg_text := l_msg_text||l_display_name|| '\n';
1687: curr_row := curr_row+1;
1688: end loop;

Line 1685: l_display_name := fnd_message.get;

1681: while (curr_row <> vac_rows) loop
1682: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1683: fnd_message.set_token('VACNAME', l_success_vacancies_list(curr_row));
1684: fnd_message.set_token('POSTNAME',l_success_postings_list(curr_row));
1685: l_display_name := fnd_message.get;
1686: l_msg_text := l_msg_text||l_display_name|| '\n';
1687: curr_row := curr_row+1;
1688: end loop;
1689: end if;

Line 1700: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_FAILED')

1696: --
1697: --
1698: -- Construct html list of failed jobs applied for
1699: --
1700: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_FAILED')
1701: || '
';
1702: l_msg_text := l_msg_text|| '\n' ||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_FAILED')
1703: || '\n';
1704: --

Line 1702: l_msg_text := l_msg_text|| '\n' ||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_FAILED')

1698: -- Construct html list of failed jobs applied for
1699: --
1700: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_FAILED')
1701: || '
';
1702: l_msg_text := l_msg_text|| '\n' ||fnd_message.get_string('PER','IRC_HA_NOTIF_VAC_FAILED')
1703: || '\n';
1704: --
1705: curr_row := 1;
1706: while (curr_row <> vac_rows1) loop

Line 1707: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');

1703: || '\n';
1704: --
1705: curr_row := 1;
1706: while (curr_row <> vac_rows1) loop
1707: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1708: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1709: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1710: l_display_name := fnd_message.get;
1711: l_msg_html := l_msg_html||l_display_name|| ' - ';

Line 1708: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));

1704: --
1705: curr_row := 1;
1706: while (curr_row <> vac_rows1) loop
1707: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1708: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1709: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1710: l_display_name := fnd_message.get;
1711: l_msg_html := l_msg_html||l_display_name|| ' - ';
1712: l_msg_html := l_msg_html||l_failed_vac_comments_list(curr_row)|| '
';

Line 1709: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));

1705: curr_row := 1;
1706: while (curr_row <> vac_rows1) loop
1707: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1708: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1709: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1710: l_display_name := fnd_message.get;
1711: l_msg_html := l_msg_html||l_display_name|| ' - ';
1712: l_msg_html := l_msg_html||l_failed_vac_comments_list(curr_row)|| '
';
1713: curr_row := curr_row+1;

Line 1710: l_display_name := fnd_message.get;

1706: while (curr_row <> vac_rows1) loop
1707: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1708: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1709: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1710: l_display_name := fnd_message.get;
1711: l_msg_html := l_msg_html||l_display_name|| ' - ';
1712: l_msg_html := l_msg_html||l_failed_vac_comments_list(curr_row)|| '
';
1713: curr_row := curr_row+1;
1714: end loop;

Line 1720: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');

1716: -- Construct text list of failed jobs applied for
1717: --
1718: curr_row := 1;
1719: while (curr_row <> vac_rows1) loop
1720: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1721: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1722: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1723: l_display_name := fnd_message.get;
1724: l_msg_text := l_msg_text||l_display_name|| ' - ';

Line 1721: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));

1717: --
1718: curr_row := 1;
1719: while (curr_row <> vac_rows1) loop
1720: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1721: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1722: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1723: l_display_name := fnd_message.get;
1724: l_msg_text := l_msg_text||l_display_name|| ' - ';
1725: l_msg_text := l_msg_text||l_failed_vac_comments_list(curr_row)|| '\n';

Line 1722: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));

1718: curr_row := 1;
1719: while (curr_row <> vac_rows1) loop
1720: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1721: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1722: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1723: l_display_name := fnd_message.get;
1724: l_msg_text := l_msg_text||l_display_name|| ' - ';
1725: l_msg_text := l_msg_text||l_failed_vac_comments_list(curr_row)|| '\n';
1726: curr_row := curr_row+1;

Line 1723: l_display_name := fnd_message.get;

1719: while (curr_row <> vac_rows1) loop
1720: fnd_message.set_name('PER', 'IRC_HA_NOTIF_VAC_NAME');
1721: fnd_message.set_token('VACNAME', l_failed_vacancies_list(curr_row));
1722: fnd_message.set_token('POSTNAME',l_failed_postings_list(curr_row));
1723: l_display_name := fnd_message.get;
1724: l_msg_text := l_msg_text||l_display_name|| ' - ';
1725: l_msg_text := l_msg_text||l_failed_vac_comments_list(curr_row)|| '\n';
1726: curr_row := curr_row+1;
1727: end loop;

Line 1735: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_PASS')

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')
1736: || '
';
1737: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_PASS')
1738: || '\n';
1739: --

Line 1737: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_PASS')

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')
1736: || '
';
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');

Line 1745: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_FAILED')

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')
1746: || '
';
1747: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_FAILED')
1748: || '\n';
1749: end if;

Line 1747: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_FAILED')

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')
1746: || '
';
1747: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_RES_FAILED')
1748: || '\n';
1749: end if;
1750: --
1751: -- Append a generic message

Line 1753: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_MISC_TEXT')

1749: end if;
1750: --
1751: -- Append a generic message
1752: --
1753: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_MISC_TEXT')
1754: || '
';
1755: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_MISC_TEXT')
1756: || '\n';
1757: --

Line 1755: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_MISC_TEXT')

1751: -- Append a generic message
1752: --
1753: l_msg_html := l_msg_html|| '
'||fnd_message.get_string('PER','IRC_HA_NOTIF_MISC_TEXT')
1754: || '
';
1755: l_msg_text := l_msg_text|| '\n'||fnd_message.get_string('PER','IRC_HA_NOTIF_MISC_TEXT')
1756: || '\n';
1757: --
1758: if l_success_vacancies_list.exists(1) or
1759: l_failed_vacancies_list.exists(1) then

Line 1769: ,p_subject => fnd_message.get_string('PER','IRC_HA_NOTIF_NEW_USER_SUBJ')

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
1771: ,p_text_body => l_msg_text
1772: ,p_from_role => 'SYSADMIN'
1773: );

Line 1779: ,p_subject => fnd_message.get_string('PER','IRC_APL_JOBAPPL_NOTIF_SUBJECT')

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
1781: ,p_text_body => l_msg_text
1782: ,p_from_role => 'SYSADMIN'
1783: );