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 426: l_job_html := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRODUCTION') || l_break;

422: --commented in bug fix 6004149.
423: --l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
424:
425: -- Loop through the suitable jobs and and list them.
426: l_job_html := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRODUCTION') || l_break;
427: l_job_html_end := l_break || l_break || '

' || get_conclusion_msg(
428: p_message_text => fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_CONCLUSION')
429: ,p_person_id => p_person_id
430: ,p_action => 'UJ')||'

Line 428: p_message_text => fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_CONCLUSION')

424:
425: -- Loop through the suitable jobs and and list them.
426: l_job_html := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRODUCTION') || l_break;
427: l_job_html_end := l_break || l_break || '

' || get_conclusion_msg(
428: p_message_text => fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_CONCLUSION')
429: ,p_person_id => p_person_id
430: ,p_action => 'UJ')||'

';
431: --
432: FOR counter IN 1 .. p_posting_details_tab.count LOOP

Line 481: l_job_html := l_job_html || l_break || fnd_message.get_string('PER','IRC_412602_MOREJOBS_EXIST_TXT') || l_break;

477: --
478: END IF;
479: --
480: IF (l_available_size = 0) THEN
481: l_job_html := l_job_html || l_break || fnd_message.get_string('PER','IRC_412602_MOREJOBS_EXIST_TXT') || l_break;
482: EXIT;
483: END IF;
484: --
485: END LOOP;

Line 535: l_job_text := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRO_TEXT') || l_new_line;

531: END IF;
532: --commented in bug fix 6004149.
533: --l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
534: -- Loop through the suitable jobs and and list them.
535: l_job_text := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRO_TEXT') || l_new_line;
536: l_job_text_end := l_new_line ||get_conclusion_msg(
537: p_message_text =>fnd_message.get_string('PER','IRC_412619_JOB_CONCL_TEXT')
538: ,p_person_id =>p_person_id
539: ,p_action =>'UJ');

Line 537: p_message_text =>fnd_message.get_string('PER','IRC_412619_JOB_CONCL_TEXT')

533: --l_function_name := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
534: -- Loop through the suitable jobs and and list them.
535: l_job_text := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_INTRO_TEXT') || l_new_line;
536: l_job_text_end := l_new_line ||get_conclusion_msg(
537: p_message_text =>fnd_message.get_string('PER','IRC_412619_JOB_CONCL_TEXT')
538: ,p_person_id =>p_person_id
539: ,p_action =>'UJ');
540: --
541: FOR counter IN 1 .. p_posting_details_tab.count LOOP

Line 579: l_job_text := l_job_text || l_new_line || fnd_message.get_string('PER','IRC_412602_MOREJOBS_EXIST_TXT') || l_new_line;

575: --
576: END IF;
577: --
578: IF (l_available_size = 0) THEN
579: l_job_text := l_job_text || l_new_line || fnd_message.get_string('PER','IRC_412602_MOREJOBS_EXIST_TXT') || l_new_line;
580: EXIT;
581: END IF;
582: --
583: END LOOP;

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

616: end if;
617: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')
618: ||fnd_global.local_chr(38)||'addBreadCrumb=Y'||fnd_global.local_chr(38)||'retainAM=Y'||fnd_global.local_chr(38)||'p_sprty=';
619: -- Loop through the suitable jobs and and list them.
620: l_seeker_html := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
621: || '
';
622: --
623: l_max_length:=30000-(length(l_seeker_html)+4+length(fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION')));
624: FOR counter IN 1 .. p_seeker_details_tab.count LOOP

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

619: -- Loop through the suitable jobs and and list them.
620: l_seeker_html := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
621: || '
';
622: --
623: l_max_length:=30000-(length(l_seeker_html)+4+length(fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION')));
624: FOR counter IN 1 .. p_seeker_details_tab.count LOOP
625: l_new_html:= '
'
626: || replace(ltrim(p_seeker_details_tab(counter).full_name,chr(0)),'<',fnd_global.local_chr(38)||'lt;')
627: || ''

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

633: end if;
634: END LOOP;
635: --
636: l_seeker_html := l_seeker_html || '
' ||
637: fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION');
638: RETURN l_seeker_html;
639: END get_recruiter_html_msg_body;
640: --
641: --

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

664: end if;
665: l_url:=l_url||'OA.jsp?OAFunc='||fnd_profile.value('IRC_SUITABLE_SEEKERS_URL')
666: ||fnd_global.local_chr(38)||'addBreadCrumb=Y'||fnd_global.local_chr(38)||'retainAM=Y'||fnd_global.local_chr(38)||'p_sprty=';
667: -- Loop through the suitable jobs and and list them.
668: l_seeker_text := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
669: || '\n';
670: --
671: l_max_length:=30000-(length(l_seeker_text)+4+length(fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION')));
672: FOR counter IN 1 .. p_seeker_details_tab.count LOOP

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

667: -- Loop through the suitable jobs and and list them.
668: l_seeker_text := fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_INTRO')
669: || '\n';
670: --
671: l_max_length:=30000-(length(l_seeker_text)+4+length(fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION')));
672: FOR counter IN 1 .. p_seeker_details_tab.count LOOP
673: l_new_text := '\n'||ltrim(p_seeker_details_tab(counter).full_name,chr(0))
674: || '\n'||l_url||p_seeker_details_tab(counter).person_id
675: || '\n';

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

680: end if;
681: END LOOP;
682: --
683: l_seeker_text := l_seeker_text || '\n' ||
684: fnd_message.get_string('PER','IRC_EMAIL_RECRUITER_CONCLUSION');
685: RETURN l_seeker_text;
686: END get_recruiter_text_msg_body;
687: --
688: --

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

882: --
883: l_base_url := fnd_profile.value('IRC_JOB_NOTIFICATION_URL');
884: IF l_base_url IS NULL THEN
885: hr_utility.set_location('base_url is null', 20);
886: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
887: RAISE e_no_base_url;
888: END IF;
889:
890: l_matching_flex := fnd_profile.value('IRC_SEARCH_CRITERIA_SM');

Line 1483: l_message_subject := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_SUBJECT');

1479: -- Send the notification if any suitable vacancies have been found
1480: hr_utility.set_location('sending notification:',50);
1481: --dbms_output.put_line(' Person:'||seeker_rec.person_id||' Has Matches');
1482: --
1483: l_message_subject := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_SUBJECT');
1484: l_id :=
1485: irc_notification_helper_pkg.send_notification
1486: ( p_person_id => seeker_rec.person_id
1487: , p_subject => l_message_subject

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

1509: hr_utility.set_location('Leaving'||l_proc, 80);
1510: EXCEPTION
1511: WHEN others THEN
1512: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);
1513: ERRBUF := SQLERRM||' '||fnd_message.get;
1514: RETCODE := 2;
1515: END email_suitable_vacs_to_seekers;
1516:
1517: --

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

1825:
1826: l_base_url := fnd_profile.value('IRC_SUITABLE_SEEKERS_URL');
1827: IF l_base_url IS NULL THEN
1828: hr_utility.set_location(l_proc, 20);
1829: fnd_message.set_name('PER','IRC_412064_NO_EMAIL_VAC_URL');
1830: RAISE e_no_base_url;
1831: END IF;
1832: --
1833: -- ************************************************************--

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

2061: hr_utility.set_location('stuff to send ', 50);
2062: --
2063: l_message_subject := null;
2064:
2065: fnd_message.set_name('PER','IRC_EMAIL_RECRUITER_SUBJECT');
2066: fnd_message.set_token('VACNAME',available_vacancy.name);
2067: l_message_subject := fnd_message.get;
2068:
2069:

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

2062: --
2063: l_message_subject := null;
2064:
2065: fnd_message.set_name('PER','IRC_EMAIL_RECRUITER_SUBJECT');
2066: fnd_message.set_token('VACNAME',available_vacancy.name);
2067: l_message_subject := fnd_message.get;
2068:
2069:
2070: --

Line 2067: l_message_subject := fnd_message.get;

2063: l_message_subject := null;
2064:
2065: fnd_message.set_name('PER','IRC_EMAIL_RECRUITER_SUBJECT');
2066: fnd_message.set_token('VACNAME',available_vacancy.name);
2067: l_message_subject := fnd_message.get;
2068:
2069:
2070: --
2071: l_id := irc_notification_helper_pkg.send_notification

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

2087: l_recruiter_problem_tab(l_index).vacancy_id
2088: := available_vacancy.vacancy_id;
2089: l_recruiter_problem_tab(l_index).vacancy_name:=available_vacancy.name;
2090: l_recruiter_problem_tab(l_index).sqlerrm := sqlerrm;
2091: l_recruiter_problem_tab(l_index).message := fnd_message.get;
2092: --
2093: END;
2094: --
2095: END LOOP;

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

2093: END;
2094: --
2095: END LOOP;
2096: --
2097: fnd_message.set_name ('PER','IRC_412069_NUMBER_MSG_SENT');
2098: fnd_message.set_token ('NOMSG',l_msg_sent);
2099: log_message(fnd_message.get);
2100: --
2101: IF ( l_index > 0 ) THEN

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

2094: --
2095: END LOOP;
2096: --
2097: fnd_message.set_name ('PER','IRC_412069_NUMBER_MSG_SENT');
2098: fnd_message.set_token ('NOMSG',l_msg_sent);
2099: log_message(fnd_message.get);
2100: --
2101: IF ( l_index > 0 ) THEN
2102: -- Maybe have an out parameter that handles these, or put them into

Line 2099: log_message(fnd_message.get);

2095: END LOOP;
2096: --
2097: fnd_message.set_name ('PER','IRC_412069_NUMBER_MSG_SENT');
2098: fnd_message.set_token ('NOMSG',l_msg_sent);
2099: log_message(fnd_message.get);
2100: --
2101: IF ( l_index > 0 ) THEN
2102: -- Maybe have an out parameter that handles these, or put them into
2103: -- the ERRBUF for concurrent processes.

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

2101: IF ( l_index > 0 ) THEN
2102: -- Maybe have an out parameter that handles these, or put them into
2103: -- the ERRBUF for concurrent processes.
2104: hr_utility.set_location('No recruiter_id ',59);
2105: fnd_message.set_name ('PER','IRC_412070_VACS_NO_OWNERS');
2106: log_message(fnd_message.get);
2107: for i in l_recruiter_problem_tab.first .. l_recruiter_problem_tab.last loop
2108: log_message(l_recruiter_problem_tab(i).vacancy_name);
2109: hr_utility.set_location('Exception ('||i||')', 60);

Line 2106: log_message(fnd_message.get);

2102: -- Maybe have an out parameter that handles these, or put them into
2103: -- the ERRBUF for concurrent processes.
2104: hr_utility.set_location('No recruiter_id ',59);
2105: fnd_message.set_name ('PER','IRC_412070_VACS_NO_OWNERS');
2106: log_message(fnd_message.get);
2107: for i in l_recruiter_problem_tab.first .. l_recruiter_problem_tab.last loop
2108: log_message(l_recruiter_problem_tab(i).vacancy_name);
2109: hr_utility.set_location('Exception ('||i||')', 60);
2110: hr_utility.set_location(' > vacancy_id:' || l_recruiter_problem_tab(i).vacancy_id, 62);

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

2112: END IF;
2113: hr_utility.set_location('Leaving'||l_proc, 80);
2114: EXCEPTION
2115: WHEN others THEN
2116: ERRBUF := SQLERRM||' '||fnd_message.get;
2117: RETCODE := 2;
2118: END get_suitable_seekers_for_vac;
2119: --
2120: --

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

2129: IS
2130: --
2131: l_id NUMBER;
2132: l_message_subject VARCHAR2(240)
2133: DEFAULT fnd_message.get_string('PER','IRC_SEEKER_INFO_NOTE_SUBJECT');
2134: l_general_body_html VARCHAR2(32000);
2135: l_general_body_text VARCHAR2(32000);
2136: l_proc VARCHAR2(30) default '.email_general_notifications';
2137: BEGIN

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

2141: FOR parties_wanting_it IN csr_seekers_for_notes LOOP
2142: --
2143: -- Build the body of the email both in text and html
2144: --
2145: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_HTML');
2146: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
2147: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
2148: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
2149: l_general_body_html := fnd_message.get;

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

2142: --
2143: -- Build the body of the email both in text and html
2144: --
2145: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_HTML');
2146: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
2147: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
2148: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
2149: l_general_body_html := fnd_message.get;
2150: l_general_body_html :='
'|| l_general_body_html ||'

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

2143: -- Build the body of the email both in text and html
2144: --
2145: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_HTML');
2146: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
2147: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
2148: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
2149: l_general_body_html := fnd_message.get;
2150: l_general_body_html :='
'|| l_general_body_html ||'

'
2151: || get_conclusion_msg(

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

2144: --
2145: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_HTML');
2146: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
2147: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
2148: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
2149: l_general_body_html := fnd_message.get;
2150: l_general_body_html :='
'|| l_general_body_html ||'

'
2151: || get_conclusion_msg(
2152: p_message_text =>fnd_message.get_string('PER','IRC_412617_GEN_CONCL_HTML')

Line 2149: l_general_body_html := fnd_message.get;

2145: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_HTML');
2146: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
2147: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
2148: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
2149: l_general_body_html := fnd_message.get;
2150: l_general_body_html :='
'|| l_general_body_html ||'

'
2151: || get_conclusion_msg(
2152: p_message_text =>fnd_message.get_string('PER','IRC_412617_GEN_CONCL_HTML')
2153: ,p_person_id =>parties_wanting_it.person_id

Line 2152: p_message_text =>fnd_message.get_string('PER','IRC_412617_GEN_CONCL_HTML')

2148: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
2149: l_general_body_html := fnd_message.get;
2150: l_general_body_html :='
'|| l_general_body_html ||'

'
2151: || get_conclusion_msg(
2152: p_message_text =>fnd_message.get_string('PER','IRC_412617_GEN_CONCL_HTML')
2153: ,p_person_id =>parties_wanting_it.person_id
2154: ,p_action =>'UG')||'

';
2155: --
2156: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_TEXT');

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

2152: p_message_text =>fnd_message.get_string('PER','IRC_412617_GEN_CONCL_HTML')
2153: ,p_person_id =>parties_wanting_it.person_id
2154: ,p_action =>'UG')||'

';
2155: --
2156: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_TEXT');
2157: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
2158: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
2159: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
2160: l_general_body_text := fnd_message.get;

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

2153: ,p_person_id =>parties_wanting_it.person_id
2154: ,p_action =>'UG')||'

';
2155: --
2156: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_TEXT');
2157: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
2158: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
2159: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
2160: l_general_body_text := fnd_message.get;
2161: l_general_body_text := l_general_body_text ||'\n'

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

2154: ,p_action =>'UG')||'

';
2155: --
2156: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_TEXT');
2157: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
2158: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
2159: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
2160: l_general_body_text := fnd_message.get;
2161: l_general_body_text := l_general_body_text ||'\n'
2162: || get_conclusion_msg(

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

2155: --
2156: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_TEXT');
2157: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
2158: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
2159: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
2160: l_general_body_text := fnd_message.get;
2161: l_general_body_text := l_general_body_text ||'\n'
2162: || get_conclusion_msg(
2163: p_message_text =>fnd_message.get_string('PER','IRC_412618_GEN_CONCL_TEXT')

Line 2160: l_general_body_text := fnd_message.get;

2156: fnd_message.set_name ('PER','IRC_SEEKER_INFO_NOTE_TEXT');
2157: fnd_message.set_token ('FIRST_NAME',parties_wanting_it.first_name);
2158: fnd_message.set_token ('LAST_NAME' ,parties_wanting_it.last_name);
2159: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
2160: l_general_body_text := fnd_message.get;
2161: l_general_body_text := l_general_body_text ||'\n'
2162: || get_conclusion_msg(
2163: p_message_text =>fnd_message.get_string('PER','IRC_412618_GEN_CONCL_TEXT')
2164: ,p_person_id =>parties_wanting_it.person_id

Line 2163: p_message_text =>fnd_message.get_string('PER','IRC_412618_GEN_CONCL_TEXT')

2159: fnd_message.set_token ('EMAIL_ADDRESS' ,parties_wanting_it.email_address);
2160: l_general_body_text := fnd_message.get;
2161: l_general_body_text := l_general_body_text ||'\n'
2162: || get_conclusion_msg(
2163: p_message_text =>fnd_message.get_string('PER','IRC_412618_GEN_CONCL_TEXT')
2164: ,p_person_id =>parties_wanting_it.person_id
2165: ,p_action =>'UG');
2166: --
2167: begin