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_SEEKER_VAC_MATCHING_PKG dependencies on FND_MESSAGE

Line 378: l_job_html := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRODUCTION')

374: --commented in bug fix 6004149.
375: --l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
376:
377: -- Loop through the suitable jobs and and list them.
378: l_job_html := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRODUCTION')
379: || '
';
380: l_job_html_end := '
' ||
381: fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_CONCLUSION');
382: --

Line 381: fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_CONCLUSION');

377: -- Loop through the suitable jobs and and list them.
378: l_job_html := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRODUCTION')
379: || '
';
380: l_job_html_end := '
' ||
381: fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_CONCLUSION');
382: --
383: FOR counter IN 1 .. p_posting_details_tab.count LOOP
384: -- Need to select the CLOB now as it couldn't be used with a distinct
385: -- in the main cursor.

Line 473: l_job_text := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRO_TEXT')

469: end if;
470: --commented in bug fix 6004149.
471: --l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
472: -- Loop through the suitable jobs and and list them.
473: l_job_text := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRO_TEXT')
474: || '\n';
475: l_job_text_end := '\n' ||
476: fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_CONCLUSION');
477: --

Line 476: fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_CONCLUSION');

472: -- Loop through the suitable jobs and and list them.
473: l_job_text := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRO_TEXT')
474: || '\n';
475: l_job_text_end := '\n' ||
476: fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_CONCLUSION');
477: --
478: FOR counter IN 1 .. p_posting_details_tab.count LOOP
479: -- Need to select the CLOB now as it couldn't be used with a distinct
480: -- in the main cursor.

Line 551: l_seeker_html := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')

547: end if;
548: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')
549: ||fnd_global.local_chr(38)||'addBreadCrumb=Y'||fnd_global.local_chr(38)||'retainAM=Y'||fnd_global.local_chr(38)||'p_sprty=';
550: -- Loop through the suitable jobs and and list them.
551: l_seeker_html := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
552: || '
';
553: --
554: l_max_length:=30000-(length(l_seeker_html)+4+length(fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION')));
555: FOR counter IN 1 .. p_seeker_details_tab.count LOOP

Line 554: l_max_length:=30000-(length(l_seeker_html)+4+length(fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION')));

550: -- Loop through the suitable jobs and and list them.
551: l_seeker_html := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
552: || '
';
553: --
554: l_max_length:=30000-(length(l_seeker_html)+4+length(fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION')));
555: FOR counter IN 1 .. p_seeker_details_tab.count LOOP
556: l_new_html:= '
'
557: || replace(ltrim(p_seeker_details_tab(counter).full_name,chr(0)),'<',fnd_global.local_chr(38)||'lt;')
558: || ''

Line 568: fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION');

564: end if;
565: END LOOP;
566: --
567: l_seeker_html := l_seeker_html || '
' ||
568: fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION');
569: RETURN l_seeker_html;
570: END get_recruiter_html_msg_body;
571: --
572: --

Line 599: l_seeker_text := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')

595: end if;
596: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')
597: ||fnd_global.local_chr(38)||'addBreadCrumb=Y'||fnd_global.local_chr(38)||'retainAM=Y'||fnd_global.local_chr(38)||'p_sprty=';
598: -- Loop through the suitable jobs and and list them.
599: l_seeker_text := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
600: || '\n';
601: --
602: l_max_length:=30000-(length(l_seeker_text)+4+length(fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION')));
603: FOR counter IN 1 .. p_seeker_details_tab.count LOOP

Line 602: l_max_length:=30000-(length(l_seeker_text)+4+length(fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION')));

598: -- Loop through the suitable jobs and and list them.
599: l_seeker_text := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
600: || '\n';
601: --
602: l_max_length:=30000-(length(l_seeker_text)+4+length(fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION')));
603: FOR counter IN 1 .. p_seeker_details_tab.count LOOP
604: l_new_text := '\n'||ltrim(p_seeker_details_tab(counter).full_name,chr(0))
605: || '\n'||l_url||p_seeker_details_tab(counter).person_id
606: || '\n';

Line 615: fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION');

611: end if;
612: END LOOP;
613: --
614: l_seeker_text := l_seeker_text || '\n' ||
615: fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION');
616: RETURN l_seeker_text;
617: END get_recruiter_text_msg_body;
618: --
619: --

Line 791: DEFAULT fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_SUBJECT');

787: matching_values_tbl dbms_sql.varchar2_table;
788:
789: l_posting_details_tab g_posting_details_tab_type;
790: l_message_subject VARCHAR2(240)
791: DEFAULT fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_SUBJECT');
792: l_base_url VARCHAR2(250);
793: --
794: l_counter NUMBER DEFAULT 0;
795: l_amount NUMBER;

Line 811: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');

807: --
808: l_base_url := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
809: IF l_base_url IS NULL THEN
810: hr_utility.set_location('base_url is null', 20);
811: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
812: RAISE e_no_base_url;
813: END IF;
814:
815: l_matching_flex := fnd_profile.value('IRC_SEARCH_CRITERIA_SM');

Line 1331: ERRBUF := SQLERRM||' '||fnd_message.get;

1327: --
1328: hr_utility.set_location('Leaving'||l_proc, 80);
1329: EXCEPTION
1330: WHEN others THEN
1331: ERRBUF := SQLERRM||' '||fnd_message.get;
1332: RETCODE := 2;
1333: END email_suitable_vacs_to_seekers;
1334:
1335: --

Line 1572: fnd_message.set_name('PER','IRC_412064_NO_EMAIL_VAC_URL');

1568:
1569: l_base_url := fnd_profile.value('IRC_SUITABLE_SEEKERS_URL');
1570: IF l_base_url IS NULL THEN
1571: hr_utility.set_location(l_proc, 20);
1572: fnd_message.set_name('PER','IRC_412064_NO_EMAIL_VAC_URL');
1573: RAISE e_no_base_url;
1574: END IF;
1575: --
1576: -- ************************************************************--

Line 1806: fnd_message.set_name('PER','IRC_EMAIL_RECRUITER_SUBJECT');

1802: hr_utility.set_location('stuff to send ', 50);
1803: --
1804: l_message_subject := null;
1805:
1806: fnd_message.set_name('PER','IRC_EMAIL_RECRUITER_SUBJECT');
1807: fnd_message.set_token('VACNAME',available_vacancy.name);
1808: l_message_subject := fnd_message.get;
1809:
1810:

Line 1807: fnd_message.set_token('VACNAME',available_vacancy.name);

1803: --
1804: l_message_subject := null;
1805:
1806: fnd_message.set_name('PER','IRC_EMAIL_RECRUITER_SUBJECT');
1807: fnd_message.set_token('VACNAME',available_vacancy.name);
1808: l_message_subject := fnd_message.get;
1809:
1810:
1811: --

Line 1808: l_message_subject := fnd_message.get;

1804: l_message_subject := null;
1805:
1806: fnd_message.set_name('PER','IRC_EMAIL_RECRUITER_SUBJECT');
1807: fnd_message.set_token('VACNAME',available_vacancy.name);
1808: l_message_subject := fnd_message.get;
1809:
1810:
1811: --
1812: l_id := irc_notification_helper_pkg.send_notification

Line 1832: l_recruiter_problem_tab(l_index).message := fnd_message.get;

1828: l_recruiter_problem_tab(l_index).vacancy_id
1829: := available_vacancy.vacancy_id;
1830: l_recruiter_problem_tab(l_index).vacancy_name:=available_vacancy.name;
1831: l_recruiter_problem_tab(l_index).sqlerrm := sqlerrm;
1832: l_recruiter_problem_tab(l_index).message := fnd_message.get;
1833: --
1834: END;
1835: --
1836: END LOOP;

Line 1838: fnd_message.set_name ('PER','IRC_412069_NUMBER_MSG_SENT');

1834: END;
1835: --
1836: END LOOP;
1837: --
1838: fnd_message.set_name ('PER','IRC_412069_NUMBER_MSG_SENT');
1839: fnd_message.set_token ('NOMSG',l_msg_sent);
1840: log_message(fnd_message.get);
1841: --
1842: IF ( l_index > 0 ) THEN

Line 1839: fnd_message.set_token ('NOMSG',l_msg_sent);

1835: --
1836: END LOOP;
1837: --
1838: fnd_message.set_name ('PER','IRC_412069_NUMBER_MSG_SENT');
1839: fnd_message.set_token ('NOMSG',l_msg_sent);
1840: log_message(fnd_message.get);
1841: --
1842: IF ( l_index > 0 ) THEN
1843: -- Maybe have an out parameter that handles these, or put them into

Line 1840: log_message(fnd_message.get);

1836: END LOOP;
1837: --
1838: fnd_message.set_name ('PER','IRC_412069_NUMBER_MSG_SENT');
1839: fnd_message.set_token ('NOMSG',l_msg_sent);
1840: log_message(fnd_message.get);
1841: --
1842: IF ( l_index > 0 ) THEN
1843: -- Maybe have an out parameter that handles these, or put them into
1844: -- the ERRBUF for concurrent processes.

Line 1846: fnd_message.set_name ('PER','IRC_412070_VACS_NO_OWNERS');

1842: IF ( l_index > 0 ) THEN
1843: -- Maybe have an out parameter that handles these, or put them into
1844: -- the ERRBUF for concurrent processes.
1845: hr_utility.set_location('No recruiter_id ',59);
1846: fnd_message.set_name ('PER','IRC_412070_VACS_NO_OWNERS');
1847: log_message(fnd_message.get);
1848: for i in l_recruiter_problem_tab.first .. l_recruiter_problem_tab.last loop
1849: log_message(l_recruiter_problem_tab(i).vacancy_name);
1850: hr_utility.set_location('Exception ('||i||')', 60);

Line 1847: log_message(fnd_message.get);

1843: -- Maybe have an out parameter that handles these, or put them into
1844: -- the ERRBUF for concurrent processes.
1845: hr_utility.set_location('No recruiter_id ',59);
1846: fnd_message.set_name ('PER','IRC_412070_VACS_NO_OWNERS');
1847: log_message(fnd_message.get);
1848: for i in l_recruiter_problem_tab.first .. l_recruiter_problem_tab.last loop
1849: log_message(l_recruiter_problem_tab(i).vacancy_name);
1850: hr_utility.set_location('Exception ('||i||')', 60);
1851: hr_utility.set_location(' > vacancy_id:' || l_recruiter_problem_tab(i).vacancy_id, 62);

Line 1857: ERRBUF := SQLERRM||' '||fnd_message.get;

1853: END IF;
1854: hr_utility.set_location('Leaving'||l_proc, 80);
1855: EXCEPTION
1856: WHEN others THEN
1857: ERRBUF := SQLERRM||' '||fnd_message.get;
1858: RETCODE := 2;
1859: END get_suitable_seekers_for_vac;
1860: --
1861: --

Line 1874: DEFAULT fnd_message.get_string('PER','IRC_SEEKER_INFO_NOTE_SUBJECT');

1870: IS
1871: --
1872: l_id NUMBER;
1873: l_message_subject VARCHAR2(240)
1874: DEFAULT fnd_message.get_string('PER','IRC_SEEKER_INFO_NOTE_SUBJECT');
1875: l_general_body_html VARCHAR2(32000);
1876: l_general_body_text VARCHAR2(32000);
1877: l_proc VARCHAR2(30) default '.email_general_notifications';
1878: BEGIN

Line 1886: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_HTML');

1882: FOR parties_wanting_it IN csr_seekers_for_notes LOOP
1883: --
1884: -- Build the body of the email both in text and html
1885: --
1886: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_HTML');
1887: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
1888: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
1889: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
1890: l_general_body_html := fnd_message.get;

Line 1887: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);

1883: --
1884: -- Build the body of the email both in text and html
1885: --
1886: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_HTML');
1887: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
1888: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
1889: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
1890: l_general_body_html := fnd_message.get;
1891: --

Line 1888: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);

1884: -- Build the body of the email both in text and html
1885: --
1886: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_HTML');
1887: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
1888: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
1889: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
1890: l_general_body_html := fnd_message.get;
1891: --
1892: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_TEXT');

Line 1889: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);

1885: --
1886: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_HTML');
1887: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
1888: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
1889: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
1890: l_general_body_html := fnd_message.get;
1891: --
1892: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_TEXT');
1893: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);

Line 1890: l_general_body_html := fnd_message.get;

1886: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_HTML');
1887: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
1888: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
1889: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
1890: l_general_body_html := fnd_message.get;
1891: --
1892: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_TEXT');
1893: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
1894: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);

Line 1892: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_TEXT');

1888: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
1889: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
1890: l_general_body_html := fnd_message.get;
1891: --
1892: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_TEXT');
1893: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
1894: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
1895: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
1896: l_general_body_text := fnd_message.get;

Line 1893: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);

1889: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
1890: l_general_body_html := fnd_message.get;
1891: --
1892: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_TEXT');
1893: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
1894: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
1895: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
1896: l_general_body_text := fnd_message.get;
1897: --

Line 1894: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);

1890: l_general_body_html := fnd_message.get;
1891: --
1892: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_TEXT');
1893: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
1894: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
1895: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
1896: l_general_body_text := fnd_message.get;
1897: --
1898: begin

Line 1895: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);

1891: --
1892: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_TEXT');
1893: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
1894: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
1895: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
1896: l_general_body_text := fnd_message.get;
1897: --
1898: begin
1899: l_id :=

Line 1896: l_general_body_text := fnd_message.get;

1892: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_TEXT');
1893: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
1894: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
1895: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
1896: l_general_body_text := fnd_message.get;
1897: --
1898: begin
1899: l_id :=
1900: irc_notification_helper_pkg.send_notification