DBA Data[Home] [Help]

APPS.IRC_VACANCY_CONSIDERATIONS_API dependencies on FND_MESSAGE

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

94: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('N');
95: end if;
96: --
97: if l_base_url is null then
98: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
99: fnd_message.raise_error;
100: end if;
101: --
102: open c_potential_applicant_details ;

Line 99: fnd_message.raise_error;

95: end if;
96: --
97: if l_base_url is null then
98: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
99: fnd_message.raise_error;
100: end if;
101: --
102: open c_potential_applicant_details ;
103: fetch c_potential_applicant_details into l_appl_first_name;

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

143: (p_person_id => p_person_id);
144:
145: -- Build the message up.
146:
147: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO');
148: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
149: fnd_message.set_token('VAC_JOB_TITLE', l_name);
150: l_message_intro := fnd_message.get;
151:

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

144:
145: -- Build the message up.
146:
147: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO');
148: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
149: fnd_message.set_token('VAC_JOB_TITLE', l_name);
150: l_message_intro := fnd_message.get;
151:
152: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');

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

145: -- Build the message up.
146:
147: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO');
148: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
149: fnd_message.set_token('VAC_JOB_TITLE', l_name);
150: l_message_intro := fnd_message.get;
151:
152: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');
153: fnd_message.set_token('URL', l_whole_url);

Line 150: l_message_intro := fnd_message.get;

146:
147: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO');
148: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
149: fnd_message.set_token('VAC_JOB_TITLE', l_name);
150: l_message_intro := fnd_message.get;
151:
152: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');
153: fnd_message.set_token('URL', l_whole_url);
154: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);

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

148: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
149: fnd_message.set_token('VAC_JOB_TITLE', l_name);
150: l_message_intro := fnd_message.get;
151:
152: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');
153: fnd_message.set_token('URL', l_whole_url);
154: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
155: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
156: l_message_conc := fnd_message.get;

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

149: fnd_message.set_token('VAC_JOB_TITLE', l_name);
150: l_message_intro := fnd_message.get;
151:
152: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');
153: fnd_message.set_token('URL', l_whole_url);
154: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
155: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
156: l_message_conc := fnd_message.get;
157:

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

150: l_message_intro := fnd_message.get;
151:
152: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');
153: fnd_message.set_token('URL', l_whole_url);
154: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
155: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
156: l_message_conc := fnd_message.get;
157:
158: l_whole_message := l_message_intro

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

151:
152: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');
153: fnd_message.set_token('URL', l_whole_url);
154: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
155: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
156: l_message_conc := fnd_message.get;
157:
158: l_whole_message := l_message_intro
159: || '
' || l_brief_description_v2||'
'

Line 156: l_message_conc := fnd_message.get;

152: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC');
153: fnd_message.set_token('URL', l_whole_url);
154: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
155: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
156: l_message_conc := fnd_message.get;
157:
158: l_whole_message := l_message_intro
159: || '
' || l_brief_description_v2||'
'
160: || l_message_conc ;

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

250: l_base_url := irc_seeker_vac_matching_pkg.get_job_notification_function('N');
251: end if;
252: --
253: if l_base_url is null then
254: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
255: fnd_message.raise_error;
256: end if;
257: --
258: open c_potential_applicant_details ;

Line 255: fnd_message.raise_error;

251: end if;
252: --
253: if l_base_url is null then
254: fnd_message.set_name('PER','IRC_412056_NO_EMAIL_JOB_URL');
255: fnd_message.raise_error;
256: end if;
257: --
258: open c_potential_applicant_details ;
259: fetch c_potential_applicant_details into l_appl_first_name;

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

295: (p_person_id => p_person_id);
296:
297: -- Build the message up.
298:
299: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO_TEXT');
300: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
301: fnd_message.set_token('VAC_JOB_TITLE', l_name);
302: l_message_intro := fnd_message.get;
303:

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

296:
297: -- Build the message up.
298:
299: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO_TEXT');
300: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
301: fnd_message.set_token('VAC_JOB_TITLE', l_name);
302: l_message_intro := fnd_message.get;
303:
304: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');

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

297: -- Build the message up.
298:
299: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO_TEXT');
300: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
301: fnd_message.set_token('VAC_JOB_TITLE', l_name);
302: l_message_intro := fnd_message.get;
303:
304: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');
305: fnd_message.set_token('URL', l_whole_url);

Line 302: l_message_intro := fnd_message.get;

298:
299: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_INTRO_TEXT');
300: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
301: fnd_message.set_token('VAC_JOB_TITLE', l_name);
302: l_message_intro := fnd_message.get;
303:
304: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');
305: fnd_message.set_token('URL', l_whole_url);
306: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);

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

300: fnd_message.set_token('SEEKER_FIRST_NAME',l_appl_first_name );
301: fnd_message.set_token('VAC_JOB_TITLE', l_name);
302: l_message_intro := fnd_message.get;
303:
304: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');
305: fnd_message.set_token('URL', l_whole_url);
306: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
307: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
308: l_message_conc := fnd_message.get;

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

301: fnd_message.set_token('VAC_JOB_TITLE', l_name);
302: l_message_intro := fnd_message.get;
303:
304: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');
305: fnd_message.set_token('URL', l_whole_url);
306: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
307: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
308: l_message_conc := fnd_message.get;
309:

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

302: l_message_intro := fnd_message.get;
303:
304: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');
305: fnd_message.set_token('URL', l_whole_url);
306: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
307: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
308: l_message_conc := fnd_message.get;
309:
310: l_whole_message := l_message_intro

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

303:
304: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');
305: fnd_message.set_token('URL', l_whole_url);
306: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
307: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
308: l_message_conc := fnd_message.get;
309:
310: l_whole_message := l_message_intro
311: || '\n' || l_brief_description_v2||'\n\n'

Line 308: l_message_conc := fnd_message.get;

304: fnd_message.set_name('PER','IRC_PURSUE_SEEKER_CONC_TEXT');
305: fnd_message.set_token('URL', l_whole_url);
306: fnd_message.set_token('SENDER_FULL_NAME', l_recr_full_name);
307: fnd_message.set_token('SENDER_JOB_TITLE', l_recr_job_name);
308: l_message_conc := fnd_message.get;
309:
310: l_whole_message := l_message_intro
311: || '\n' || l_brief_description_v2||'\n\n'
312: || l_message_conc ;

Line 337: DEFAULT fnd_message.get_string('PER','IRC_PURSUE_SEEKER_SUBJECT');

333: --
334: l_proc varchar2(72) := g_package||
335: 'notify_seeker_if_required';
336: l_message_subject VARCHAR2(240)
337: DEFAULT fnd_message.get_string('PER','IRC_PURSUE_SEEKER_SUBJECT');
338: --
339: l_id NUMBER;
340: l_rec_found varchar2(1);
341: --

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

360: fetch c_posting_details into l_rec_found;
361: if(c_posting_details%notfound)
362: then
363: close c_posting_details;
364: fnd_message.set_name('PER','IRC_412148_VAC_NO_POSTING');
365: fnd_message.raise_error;
366: end if;
367: close c_posting_details;
368: l_id := irc_notification_helper_pkg.send_notification

Line 365: fnd_message.raise_error;

361: if(c_posting_details%notfound)
362: then
363: close c_posting_details;
364: fnd_message.set_name('PER','IRC_412148_VAC_NO_POSTING');
365: fnd_message.raise_error;
366: end if;
367: close c_posting_details;
368: l_id := irc_notification_helper_pkg.send_notification
369: ( p_person_id => p_person_id