DBA Data[Home] [Help]

APPS.IRC_VACANCY_CONSIDERATIONS_API dependencies on FND_MESSAGE

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

132: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('N');
133: end if;
134: --
135: if l_base_url is null then
136: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
137: fnd_message.raise_error;
138: end if;
139: --
140: open c_potential_applicant_details ;

Line 137: fnd_message.raise_error;

133: end if;
134: --
135: if l_base_url is null then
136: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
137: fnd_message.raise_error;
138: end if;
139: --
140: open c_potential_applicant_details ;
141: fetch c_potential_applicant_details into l_appl_first_name;

Line 184: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO');

180: l_user_name := irc_notification_helper_pkg.get_job_seekers_role(p_person_id => p_person_id);
181: --
182: -- Build the message up.
183: --
184: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO');
185: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
186: fnd_message.set_token('VAC_JOB_TITLE', l_name);
187: l_message_intro := fnd_message.get;
188: --

Line 185: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );

181: --
182: -- Build the message up.
183: --
184: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO');
185: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
186: fnd_message.set_token('VAC_JOB_TITLE', l_name);
187: l_message_intro := fnd_message.get;
188: --
189: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');

Line 186: fnd_message.set_token('VAC_JOB_TITLE', l_name);

182: -- Build the message up.
183: --
184: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO');
185: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
186: fnd_message.set_token('VAC_JOB_TITLE', l_name);
187: l_message_intro := fnd_message.get;
188: --
189: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');
190: fnd_message.set_token('URL', l_whole_url);

Line 187: l_message_intro := fnd_message.get;

183: --
184: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO');
185: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
186: fnd_message.set_token('VAC_JOB_TITLE', l_name);
187: l_message_intro := fnd_message.get;
188: --
189: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');
190: fnd_message.set_token('URL', l_whole_url);
191: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);

Line 189: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');

185: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
186: fnd_message.set_token('VAC_JOB_TITLE', l_name);
187: l_message_intro := fnd_message.get;
188: --
189: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');
190: fnd_message.set_token('URL', l_whole_url);
191: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
192: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
193: l_message_conc := fnd_message.get;

Line 190: fnd_message.set_token('URL', l_whole_url);

186: fnd_message.set_token('VAC_JOB_TITLE', l_name);
187: l_message_intro := fnd_message.get;
188: --
189: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');
190: fnd_message.set_token('URL', l_whole_url);
191: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
192: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
193: l_message_conc := fnd_message.get;
194: --

Line 191: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);

187: l_message_intro := fnd_message.get;
188: --
189: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');
190: fnd_message.set_token('URL', l_whole_url);
191: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
192: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
193: l_message_conc := fnd_message.get;
194: --
195: l_whole_message := l_message_intro

Line 192: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);

188: --
189: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');
190: fnd_message.set_token('URL', l_whole_url);
191: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
192: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
193: l_message_conc := fnd_message.get;
194: --
195: l_whole_message := l_message_intro
196: || '
' || l_brief_description_v||'
'

Line 193: l_message_conc := fnd_message.get;

189: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');
190: fnd_message.set_token('URL', l_whole_url);
191: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
192: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
193: l_message_conc := fnd_message.get;
194: --
195: l_whole_message := l_message_intro
196: || '
' || l_brief_description_v||'
'
197: || l_message_conc ;

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

285: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('N');
286: end if;
287: --
288: if l_base_url is null then
289: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
290: fnd_message.raise_error;
291: end if;
292: --
293: open c_potential_applicant_details ;

Line 290: fnd_message.raise_error;

286: end if;
287: --
288: if l_base_url is null then
289: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
290: fnd_message.raise_error;
291: end if;
292: --
293: open c_potential_applicant_details ;
294: fetch c_potential_applicant_details into l_appl_first_name;

Line 331: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO_TEXT');

327: l_user_name := irc_notification_helper_pkg.get_job_seekers_role(p_person_id => p_person_id);
328: --
329: -- Build the message up.
330: --
331: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO_TEXT');
332: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
333: fnd_message.set_token('VAC_JOB_TITLE', l_name);
334: l_message_intro := fnd_message.get;
335: --

Line 332: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );

328: --
329: -- Build the message up.
330: --
331: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO_TEXT');
332: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
333: fnd_message.set_token('VAC_JOB_TITLE', l_name);
334: l_message_intro := fnd_message.get;
335: --
336: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');

Line 333: fnd_message.set_token('VAC_JOB_TITLE', l_name);

329: -- Build the message up.
330: --
331: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO_TEXT');
332: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
333: fnd_message.set_token('VAC_JOB_TITLE', l_name);
334: l_message_intro := fnd_message.get;
335: --
336: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');
337: fnd_message.set_token('URL', l_whole_url);

Line 334: l_message_intro := fnd_message.get;

330: --
331: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO_TEXT');
332: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
333: fnd_message.set_token('VAC_JOB_TITLE', l_name);
334: l_message_intro := fnd_message.get;
335: --
336: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');
337: fnd_message.set_token('URL', l_whole_url);
338: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);

Line 336: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');

332: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
333: fnd_message.set_token('VAC_JOB_TITLE', l_name);
334: l_message_intro := fnd_message.get;
335: --
336: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');
337: fnd_message.set_token('URL', l_whole_url);
338: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
339: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
340: l_message_conc := fnd_message.get;

Line 337: fnd_message.set_token('URL', l_whole_url);

333: fnd_message.set_token('VAC_JOB_TITLE', l_name);
334: l_message_intro := fnd_message.get;
335: --
336: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');
337: fnd_message.set_token('URL', l_whole_url);
338: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
339: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
340: l_message_conc := fnd_message.get;
341: --

Line 338: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);

334: l_message_intro := fnd_message.get;
335: --
336: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');
337: fnd_message.set_token('URL', l_whole_url);
338: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
339: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
340: l_message_conc := fnd_message.get;
341: --
342: l_whole_message := l_message_intro

Line 339: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);

335: --
336: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');
337: fnd_message.set_token('URL', l_whole_url);
338: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
339: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
340: l_message_conc := fnd_message.get;
341: --
342: l_whole_message := l_message_intro
343: || '\n' || l_brief_description_v||'\n\n'

Line 340: l_message_conc := fnd_message.get;

336: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');
337: fnd_message.set_token('URL', l_whole_url);
338: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
339: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
340: l_message_conc := fnd_message.get;
341: --
342: l_whole_message := l_message_intro
343: || '\n' || l_brief_description_v||'\n\n'
344: || l_message_conc ;

Line 413: fnd_message.set_name('PER','IRC_412148_VAC_NO_POSTING');

409: fetch c_posting_details into l_rec_found;
410: if(c_posting_details%notfound)
411: then
412: close c_posting_details;
413: fnd_message.set_name('PER','IRC_412148_VAC_NO_POSTING');
414: fnd_message.raise_error;
415: end if;
416: close c_posting_details;
417: l_user_role := irc_notification_helper_pkg.get_job_seekers_role(p_person_id => p_person_id);

Line 414: fnd_message.raise_error;

410: if(c_posting_details%notfound)
411: then
412: close c_posting_details;
413: fnd_message.set_name('PER','IRC_412148_VAC_NO_POSTING');
414: fnd_message.raise_error;
415: end if;
416: close c_posting_details;
417: l_user_role := irc_notification_helper_pkg.get_job_seekers_role(p_person_id => p_person_id);
418:

Line 437: l_message_subject := fnd_message.get_string('PER','IRC_PURSUE_SEEKER_SUBJECT');

433: -- Starting Added for 14500909
434: if l_dft_lang <> l_user_lang then
435: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_user_lang||'''');
436: end if;
437: l_message_subject := fnd_message.get_string('PER','IRC_PURSUE_SEEKER_SUBJECT');
438: --- End Added for 14500909
439:
440: l_id := irc_notification_helper_pkg.send_notification
441: ( p_person_id => p_person_id