APPS.IRC_OFFER_NOTIFICATIONS_PKG dependencies on FND_MESSAGE

Line 385: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_SUBJECT');

381:
382: hr_utility.set_location(l_proc, 50);
383:
384: -- build subject message
385: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_SUBJECT');
386: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
387: fnd_message.set_token('JOB_TITLE',l_job_title, false);
388: l_subject := fnd_message.get;
389:

Line 386: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);

382: hr_utility.set_location(l_proc, 50);
383:
384: -- build subject message
385: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_SUBJECT');
386: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
387: fnd_message.set_token('JOB_TITLE',l_job_title, false);
388: l_subject := fnd_message.get;
389:
390: hr_utility.set_location(l_proc, 60);

Line 387: fnd_message.set_token('JOB_TITLE',l_job_title, false);

383:
384: -- build subject message
385: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_SUBJECT');
386: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
387: fnd_message.set_token('JOB_TITLE',l_job_title, false);
388: l_subject := fnd_message.get;
389:
390: hr_utility.set_location(l_proc, 60);
391:

Line 388: l_subject := fnd_message.get;

384: -- build subject message
385: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_SUBJECT');
386: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
387: fnd_message.set_token('JOB_TITLE',l_job_title, false);
388: l_subject := fnd_message.get;
389:
390: hr_utility.set_location(l_proc, 60);
391:
392: -- build html body

Line 393: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_HTML');

389:
390: hr_utility.set_location(l_proc, 60);
391:
392: -- build html body
393: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_HTML');
394: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
395: fnd_message.set_token('JOB_TITLE',l_job_title, false);
396: l_html_body := fnd_message.get;
397:

Line 394: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);

390: hr_utility.set_location(l_proc, 60);
391:
392: -- build html body
393: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_HTML');
394: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
395: fnd_message.set_token('JOB_TITLE',l_job_title, false);
396: l_html_body := fnd_message.get;
397:
398: --

Line 395: fnd_message.set_token('JOB_TITLE',l_job_title, false);

391:
392: -- build html body
393: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_HTML');
394: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
395: fnd_message.set_token('JOB_TITLE',l_job_title, false);
396: l_html_body := fnd_message.get;
397:
398: --
399:

Line 396: l_html_body := fnd_message.get;

392: -- build html body
393: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_HTML');
394: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
395: fnd_message.set_token('JOB_TITLE',l_job_title, false);
396: l_html_body := fnd_message.get;
397:
398: --
399:
400: l_html_body := l_html_body

Line 416: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_TEXT');

412: hr_utility.set_location(l_proc, 70);
413:
414: -- build text body
415: --
416: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_TEXT');
417: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
418: fnd_message.set_token('JOB_TITLE',l_job_title, false);
419: l_text_body := fnd_message.get;
420:

Line 417: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);

413:
414: -- build text body
415: --
416: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_TEXT');
417: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
418: fnd_message.set_token('JOB_TITLE',l_job_title, false);
419: l_text_body := fnd_message.get;
420:
421: --

Line 418: fnd_message.set_token('JOB_TITLE',l_job_title, false);

414: -- build text body
415: --
416: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_TEXT');
417: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
418: fnd_message.set_token('JOB_TITLE',l_job_title, false);
419: l_text_body := fnd_message.get;
420:
421: --
422: l_text_body := l_text_body

Line 419: l_text_body := fnd_message.get;

415: --
416: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_TEXT');
417: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
418: fnd_message.set_token('JOB_TITLE',l_job_title, false);
419: l_text_body := fnd_message.get;
420:
421: --
422: l_text_body := l_text_body
423: || '\n' || l_note_text;

Line 457: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_SUBJECT');

453: fetch csr_get_employee_id into l_manager_id;
454: close csr_get_employee_id;
455:
456: -- build subject message
457: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_SUBJECT');
458: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
459: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
460: l_subject := fnd_message.get;
461:

Line 458: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);

454: close csr_get_employee_id;
455:
456: -- build subject message
457: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_SUBJECT');
458: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
459: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
460: l_subject := fnd_message.get;
461:
462: hr_utility.set_location(l_proc, 110);

Line 459: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);

455:
456: -- build subject message
457: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_SUBJECT');
458: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
459: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
460: l_subject := fnd_message.get;
461:
462: hr_utility.set_location(l_proc, 110);
463:

Line 460: l_subject := fnd_message.get;

456: -- build subject message
457: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_SUBJECT');
458: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
459: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
460: l_subject := fnd_message.get;
461:
462: hr_utility.set_location(l_proc, 110);
463:
464:

Line 466: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_HTML');

462: hr_utility.set_location(l_proc, 110);
463:
464:
465: -- build html body
466: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_HTML');
467: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
468: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
469: l_html_body := fnd_message.get || '
' || l_note_text;
470:

Line 467: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);

463:
464:
465: -- build html body
466: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_HTML');
467: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
468: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
469: l_html_body := fnd_message.get || '
' || l_note_text;
470:
471: --

Line 468: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);

464:
465: -- build html body
466: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_HTML');
467: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
468: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
469: l_html_body := fnd_message.get || '
' || l_note_text;
470:
471: --
472: hr_utility.set_location(l_proc, 120);

Line 469: l_html_body := fnd_message.get || '
' || l_note_text;

465: -- build html body
466: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_HTML');
467: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
468: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
469: l_html_body := fnd_message.get || '
' || l_note_text;
470:
471: --
472: hr_utility.set_location(l_proc, 120);
473:

Line 476: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_TEXT');

472: hr_utility.set_location(l_proc, 120);
473:
474: -- build text body
475: --
476: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_TEXT');
477: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
478: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
479: l_text_body := fnd_message.get || '\n' || l_note_text;
480:

Line 477: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);

473:
474: -- build text body
475: --
476: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_TEXT');
477: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
478: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
479: l_text_body := fnd_message.get || '\n' || l_note_text;
480:
481: --

Line 478: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);

474: -- build text body
475: --
476: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_TEXT');
477: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
478: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
479: l_text_body := fnd_message.get || '\n' || l_note_text;
480:
481: --
482: hr_utility.set_location(l_proc, 130);

Line 479: l_text_body := fnd_message.get || '\n' || l_note_text;

475: --
476: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_TEXT');
477: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
478: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
479: l_text_body := fnd_message.get || '\n' || l_note_text;
480:
481: --
482: hr_utility.set_location(l_proc, 130);
483:

Line 542: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_SUBJECT');

538: for offer_expiry_rec in csr_get_expiry_offer_rec
539: (p_number_of_days => p_number_of_days)loop
540: l_apl_asg_id := offer_expiry_rec.applicant_assignment_id;
541: -- build subject message
542: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_SUBJECT');
543: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
544: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
545: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.job_title, false);
546: l_subject := fnd_message.get;

Line 543: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);

539: (p_number_of_days => p_number_of_days)loop
540: l_apl_asg_id := offer_expiry_rec.applicant_assignment_id;
541: -- build subject message
542: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_SUBJECT');
543: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
544: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
545: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.job_title, false);
546: l_subject := fnd_message.get;
547:

Line 544: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);

540: l_apl_asg_id := offer_expiry_rec.applicant_assignment_id;
541: -- build subject message
542: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_SUBJECT');
543: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
544: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
545: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.job_title, false);
546: l_subject := fnd_message.get;
547:
548: --get offer sent date

Line 545: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.job_title, false);

541: -- build subject message
542: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_SUBJECT');
543: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
544: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
545: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.job_title, false);
546: l_subject := fnd_message.get;
547:
548: --get offer sent date
549: open csr_get_offer_sent_date(offer_expiry_rec.offer_id);

Line 546: l_subject := fnd_message.get;

542: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_SUBJECT');
543: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
544: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
545: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.job_title, false);
546: l_subject := fnd_message.get;
547:
548: --get offer sent date
549: open csr_get_offer_sent_date(offer_expiry_rec.offer_id);
550: fetch csr_get_offer_sent_date into l_offer_sent_date;

Line 580: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_HTML');

576: -- Build the body of the message both in text and html
577: --
578:
579: -- build html body
580: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_HTML');
581: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
582: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
583: l_html_body := fnd_message.get;
584:

Line 581: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);

577: --
578:
579: -- build html body
580: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_HTML');
581: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
582: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
583: l_html_body := fnd_message.get;
584:
585: --

Line 582: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);

578:
579: -- build html body
580: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_HTML');
581: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
582: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
583: l_html_body := fnd_message.get;
584:
585: --
586: l_extend_method := offer_expiry_rec.extended_method;

Line 583: l_html_body := fnd_message.get;

579: -- build html body
580: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_HTML');
581: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
582: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
583: l_html_body := fnd_message.get;
584:
585: --
586: l_extend_method := offer_expiry_rec.extended_method;
587: if (l_extend_method='SYSTEM') then

Line 600: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_TEXT');

596: hr_utility.set_location(l_proc,40);
597:
598: -- build text body
599:
600: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_TEXT');
601: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
602: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
603: l_text_body := fnd_message.get;
604:

Line 601: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);

597:
598: -- build text body
599:
600: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_TEXT');
601: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
602: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
603: l_text_body := fnd_message.get;
604:
605: --

Line 602: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);

598: -- build text body
599:
600: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_TEXT');
601: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
602: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
603: l_text_body := fnd_message.get;
604:
605: --
606: if (l_extend_method='SYSTEM') then

Line 603: l_text_body := fnd_message.get;

599:
600: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_TEXT');
601: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
602: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
603: l_text_body := fnd_message.get;
604:
605: --
606: if (l_extend_method='SYSTEM') then
607: l_text_body := l_text_body

Line 650: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_HTML');

646: -- Build the body of the message both in text and html
647: --
648:
649: -- build html body
650: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_HTML');
651: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
652: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
653: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
654: l_html_body := fnd_message.get;

Line 651: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);

647: --
648:
649: -- build html body
650: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_HTML');
651: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
652: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
653: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
654: l_html_body := fnd_message.get;
655: --

Line 652: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);

648:
649: -- build html body
650: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_HTML');
651: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
652: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
653: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
654: l_html_body := fnd_message.get;
655: --
656: l_html_body := l_html_body

Line 653: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);

649: -- build html body
650: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_HTML');
651: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
652: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
653: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
654: l_html_body := fnd_message.get;
655: --
656: l_html_body := l_html_body
657: || '
658: || '">'

806: -- build html body
807: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_MGR_HTML');
808: fnd_message.set_token('APPLICANT_NAME',offer_expired_rec.applicant_name, false);
809: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.vacancy_name, false);
810: l_html_body := fnd_message.get;
811:
812: --
813: l_html_body := l_html_body
814: || '