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

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

542: l_current_set_lang := l_apl_lang;
543: end if;
544:
545: -- build subject message
546: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_SUBJECT');
547: fnd_message.set_token('VACANCY_NAME',l_job_posting_title, false);
548: fnd_message.set_token('JOB_TITLE',l_ipc_job_title, false);
549: l_subject := fnd_message.get;
550:

Line 547: fnd_message.set_token('VACANCY_NAME',l_job_posting_title, false);

543: end if;
544:
545: -- build subject message
546: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_SUBJECT');
547: fnd_message.set_token('VACANCY_NAME',l_job_posting_title, false);
548: fnd_message.set_token('JOB_TITLE',l_ipc_job_title, false);
549: l_subject := fnd_message.get;
550:
551: hr_utility.set_location(l_proc, 60);

Line 548: fnd_message.set_token('JOB_TITLE',l_ipc_job_title, false);

544:
545: -- build subject message
546: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_SUBJECT');
547: fnd_message.set_token('VACANCY_NAME',l_job_posting_title, false);
548: fnd_message.set_token('JOB_TITLE',l_ipc_job_title, false);
549: l_subject := fnd_message.get;
550:
551: hr_utility.set_location(l_proc, 60);
552:

Line 549: l_subject := fnd_message.get;

545: -- build subject message
546: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_SUBJECT');
547: fnd_message.set_token('VACANCY_NAME',l_job_posting_title, false);
548: fnd_message.set_token('JOB_TITLE',l_ipc_job_title, false);
549: l_subject := fnd_message.get;
550:
551: hr_utility.set_location(l_proc, 60);
552:
553: -- build html body

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

550:
551: hr_utility.set_location(l_proc, 60);
552:
553: -- build html body
554: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_HTML');
555: fnd_message.set_token('VACANCY_NAME',l_job_posting_title, false);
556: fnd_message.set_token('JOB_TITLE',l_ipc_job_title, false);
557: l_html_body := fnd_message.get;
558:

Line 555: fnd_message.set_token('VACANCY_NAME',l_job_posting_title, false);

551: hr_utility.set_location(l_proc, 60);
552:
553: -- build html body
554: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_HTML');
555: fnd_message.set_token('VACANCY_NAME',l_job_posting_title, false);
556: fnd_message.set_token('JOB_TITLE',l_ipc_job_title, false);
557: l_html_body := fnd_message.get;
558:
559: --

Line 556: fnd_message.set_token('JOB_TITLE',l_ipc_job_title, false);

552:
553: -- build html body
554: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_HTML');
555: fnd_message.set_token('VACANCY_NAME',l_job_posting_title, false);
556: fnd_message.set_token('JOB_TITLE',l_ipc_job_title, false);
557: l_html_body := fnd_message.get;
558:
559: --
560:

Line 557: l_html_body := fnd_message.get;

553: -- build html body
554: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_HTML');
555: fnd_message.set_token('VACANCY_NAME',l_job_posting_title, false);
556: fnd_message.set_token('JOB_TITLE',l_ipc_job_title, false);
557: l_html_body := fnd_message.get;
558:
559: --
560:
561: l_html_body := l_html_body

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

573: hr_utility.set_location(l_proc, 70);
574:
575: -- build text body
576: --
577: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_TEXT');
578: fnd_message.set_token('VACANCY_NAME',l_job_posting_title, false);
579: fnd_message.set_token('JOB_TITLE',l_ipc_job_title, false);
580: l_text_body := fnd_message.get;
581:

Line 578: fnd_message.set_token('VACANCY_NAME',l_job_posting_title, false);

574:
575: -- build text body
576: --
577: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_TEXT');
578: fnd_message.set_token('VACANCY_NAME',l_job_posting_title, false);
579: fnd_message.set_token('JOB_TITLE',l_ipc_job_title, false);
580: l_text_body := fnd_message.get;
581:
582: --

Line 579: fnd_message.set_token('JOB_TITLE',l_ipc_job_title, false);

575: -- build text body
576: --
577: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_TEXT');
578: fnd_message.set_token('VACANCY_NAME',l_job_posting_title, false);
579: fnd_message.set_token('JOB_TITLE',l_ipc_job_title, false);
580: l_text_body := fnd_message.get;
581:
582: --
583: l_text_body := l_text_body

Line 580: l_text_body := fnd_message.get;

576: --
577: fnd_message.set_name('PER','IRC_OFFER_RECEIVED_APL_TEXT');
578: fnd_message.set_token('VACANCY_NAME',l_job_posting_title, false);
579: fnd_message.set_token('JOB_TITLE',l_ipc_job_title, false);
580: l_text_body := fnd_message.get;
581:
582: --
583: l_text_body := l_text_body
584: || '\n' || l_note_text;

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

632: l_current_set_lang := l_mgr_lang;
633: end if;
634:
635: -- build subject message
636: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_SUBJECT');
637: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
638: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
639: l_subject := fnd_message.get;
640:

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

633: end if;
634:
635: -- build subject message
636: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_SUBJECT');
637: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
638: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
639: l_subject := fnd_message.get;
640:
641: hr_utility.set_location(l_proc, 110);

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

634:
635: -- build subject message
636: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_SUBJECT');
637: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
638: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
639: l_subject := fnd_message.get;
640:
641: hr_utility.set_location(l_proc, 110);
642:

Line 639: l_subject := fnd_message.get;

635: -- build subject message
636: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_SUBJECT');
637: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
638: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
639: l_subject := fnd_message.get;
640:
641: hr_utility.set_location(l_proc, 110);
642:
643:

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

641: hr_utility.set_location(l_proc, 110);
642:
643:
644: -- build html body
645: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_HTML');
646: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
647: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
648: l_html_body := fnd_message.get || '
' || l_note_text;
649:

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

642:
643:
644: -- build html body
645: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_HTML');
646: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
647: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
648: l_html_body := fnd_message.get || '
' || l_note_text;
649:
650: --

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

643:
644: -- build html body
645: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_HTML');
646: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
647: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
648: l_html_body := fnd_message.get || '
' || l_note_text;
649:
650: --
651: hr_utility.set_location(l_proc, 120);

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

644: -- build html body
645: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_HTML');
646: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
647: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
648: l_html_body := fnd_message.get || '
' || l_note_text;
649:
650: --
651: hr_utility.set_location(l_proc, 120);
652:

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

651: hr_utility.set_location(l_proc, 120);
652:
653: -- build text body
654: --
655: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_TEXT');
656: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
657: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
658: l_text_body := fnd_message.get || '\n' || l_note_text;
659:

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

652:
653: -- build text body
654: --
655: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_TEXT');
656: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
657: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
658: l_text_body := fnd_message.get || '\n' || l_note_text;
659:
660: --

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

653: -- build text body
654: --
655: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_TEXT');
656: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
657: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
658: l_text_body := fnd_message.get || '\n' || l_note_text;
659:
660: --
661: hr_utility.set_location(l_proc, 130);

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

654: --
655: fnd_message.set_name('PER','IRC_OFFER_SENT_MGR_TEXT');
656: fnd_message.set_token('APPLICANT_NAME',l_applicant_name, false);
657: fnd_message.set_token('VACANCY_NAME',l_vacancy_name, false);
658: l_text_body := fnd_message.get || '\n' || l_note_text;
659:
660: --
661: hr_utility.set_location(l_proc, 130);
662:

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

802: l_current_set_lang := l_apl_lang;
803: end if;
804:
805: -- build subject message
806: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_SUBJECT');
807: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
808: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.job_posting_title, false);
809: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.ipc_job_title, false);
810: l_subject := fnd_message.get;

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

803: end if;
804:
805: -- build subject message
806: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_SUBJECT');
807: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
808: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.job_posting_title, false);
809: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.ipc_job_title, false);
810: l_subject := fnd_message.get;
811:

Line 808: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.job_posting_title, false);

804:
805: -- build subject message
806: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_SUBJECT');
807: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
808: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.job_posting_title, false);
809: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.ipc_job_title, false);
810: l_subject := fnd_message.get;
811:
812: hr_utility.set_location(l_proc,30);

Line 809: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.ipc_job_title, false);

805: -- build subject message
806: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_SUBJECT');
807: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
808: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.job_posting_title, false);
809: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.ipc_job_title, false);
810: l_subject := fnd_message.get;
811:
812: hr_utility.set_location(l_proc,30);
813:

Line 810: l_subject := fnd_message.get;

806: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_SUBJECT');
807: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
808: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.job_posting_title, false);
809: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.ipc_job_title, false);
810: l_subject := fnd_message.get;
811:
812: hr_utility.set_location(l_proc,30);
813:
814: --

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

815: -- Build the body of the message both in text and html
816: --
817:
818: -- build html body
819: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_HTML');
820: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
821: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
822: l_html_body := fnd_message.get;
823:

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

816: --
817:
818: -- build html body
819: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_HTML');
820: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
821: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
822: l_html_body := fnd_message.get;
823:
824: --

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

817:
818: -- build html body
819: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_HTML');
820: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
821: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
822: l_html_body := fnd_message.get;
823:
824: --
825: l_extend_method := offer_expiry_rec.extended_method;

Line 822: l_html_body := fnd_message.get;

818: -- build html body
819: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_HTML');
820: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
821: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
822: l_html_body := fnd_message.get;
823:
824: --
825: l_extend_method := offer_expiry_rec.extended_method;
826: if (l_extend_method='SYSTEM') then

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

835: hr_utility.set_location(l_proc,40);
836:
837: -- build text body
838:
839: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_TEXT');
840: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
841: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
842: l_text_body := fnd_message.get;
843:

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

836:
837: -- build text body
838:
839: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_TEXT');
840: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
841: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
842: l_text_body := fnd_message.get;
843:
844: --

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

837: -- build text body
838:
839: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_TEXT');
840: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
841: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
842: l_text_body := fnd_message.get;
843:
844: --
845: if (l_extend_method='SYSTEM') then

Line 842: l_text_body := fnd_message.get;

838:
839: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_APL_TEXT');
840: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
841: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
842: l_text_body := fnd_message.get;
843:
844: --
845: if (l_extend_method='SYSTEM') then
846: l_text_body := l_text_body

Line 881: ,buff => 'Failure Reason: '|| fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')

877: );
878:
879: fnd_file.put_line
880: ( which => fnd_file.log
881: ,buff => 'Failure Reason: '|| fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
882: );
883: END;
884:
885: hr_utility.set_location(l_proc,60);

Line 919: fnd_message.set_name('PER','IRC_412671_OFFER_EXPY_MGR_SUB');

915: l_current_set_lang := l_mgr_lang;
916: end if;
917:
918: -- build subject message
919: fnd_message.set_name('PER','IRC_412671_OFFER_EXPY_MGR_SUB');
920: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
921: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
922: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.job_title, false);
923: l_subject := fnd_message.get;

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

916: end if;
917:
918: -- build subject message
919: fnd_message.set_name('PER','IRC_412671_OFFER_EXPY_MGR_SUB');
920: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
921: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
922: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.job_title, false);
923: l_subject := fnd_message.get;
924:

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

917:
918: -- build subject message
919: fnd_message.set_name('PER','IRC_412671_OFFER_EXPY_MGR_SUB');
920: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
921: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
922: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.job_title, false);
923: l_subject := fnd_message.get;
924:
925: --

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

918: -- build subject message
919: fnd_message.set_name('PER','IRC_412671_OFFER_EXPY_MGR_SUB');
920: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
921: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
922: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.job_title, false);
923: l_subject := fnd_message.get;
924:
925: --
926: -- Build the body of the message both in text and html

Line 923: l_subject := fnd_message.get;

919: fnd_message.set_name('PER','IRC_412671_OFFER_EXPY_MGR_SUB');
920: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
921: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
922: fnd_message.set_token('JOB_TITLE',offer_expiry_rec.job_title, false);
923: l_subject := fnd_message.get;
924:
925: --
926: -- Build the body of the message both in text and html
927: --

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

926: -- Build the body of the message both in text and html
927: --
928: if send_notitfication_status = 'success' then
929: -- build html body
930: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_HTML');
931: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
932: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
933: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
934: l_html_body := fnd_message.get;

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

927: --
928: if send_notitfication_status = 'success' then
929: -- build html body
930: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_HTML');
931: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
932: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
933: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
934: l_html_body := fnd_message.get;
935: --

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

928: if send_notitfication_status = 'success' then
929: -- build html body
930: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_HTML');
931: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
932: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
933: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
934: l_html_body := fnd_message.get;
935: --
936: l_html_body := l_html_body

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

929: -- build html body
930: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_HTML');
931: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
932: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
933: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
934: l_html_body := fnd_message.get;
935: --
936: l_html_body := l_html_body
937: || '
938: || '">'

Line 947: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_TEXT');

943: hr_utility.set_location(l_proc,100);
944:
945: -- build text body
946:
947: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_TEXT');
948: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
949: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
950: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
951: l_text_body := fnd_message.get;

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

944:
945: -- build text body
946:
947: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_TEXT');
948: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
949: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
950: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
951: l_text_body := fnd_message.get;
952:

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

945: -- build text body
946:
947: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_TEXT');
948: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
949: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
950: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
951: l_text_body := fnd_message.get;
952:
953: --

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

946:
947: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_TEXT');
948: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
949: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
950: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
951: l_text_body := fnd_message.get;
952:
953: --
954: l_text_body := l_text_body

Line 951: l_text_body := fnd_message.get;

947: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_TEXT');
948: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
949: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
950: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
951: l_text_body := fnd_message.get;
952:
953: --
954: l_text_body := l_text_body
955: || '\n'||'Extend Duration'

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

959: hr_utility.set_location(l_proc,110);
960:
961: else --- send_notitfication_status is failure
962: -- build html body
963: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_HTML');
964: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
965: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
966: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
967: l_html_body := fnd_message.get;

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

960:
961: else --- send_notitfication_status is failure
962: -- build html body
963: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_HTML');
964: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
965: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
966: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
967: l_html_body := fnd_message.get;
968: l_html_body := l_html_body

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

961: else --- send_notitfication_status is failure
962: -- build html body
963: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_HTML');
964: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
965: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
966: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
967: l_html_body := fnd_message.get;
968: l_html_body := l_html_body
969: ||'However,
'||fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')

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

962: -- build html body
963: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_HTML');
964: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
965: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
966: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
967: l_html_body := fnd_message.get;
968: l_html_body := l_html_body
969: ||'However,
'||fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
970: ||'
Please Take Appropriate Action.';

Line 967: l_html_body := fnd_message.get;

963: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_HTML');
964: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
965: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
966: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
967: l_html_body := fnd_message.get;
968: l_html_body := l_html_body
969: ||'However,
'||fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
970: ||'
Please Take Appropriate Action.';
971: -- build text body

Line 969: ||'However,
'||fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')

965: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
966: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
967: l_html_body := fnd_message.get;
968: l_html_body := l_html_body
969: ||'However,
'||fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
970: ||'
Please Take Appropriate Action.';
971: -- build text body
972: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_TEXT');
973: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);

Line 972: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_TEXT');

968: l_html_body := l_html_body
969: ||'However,
'||fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
970: ||'
Please Take Appropriate Action.';
971: -- build text body
972: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_TEXT');
973: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
974: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
975: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
976: l_text_body := fnd_message.get;

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

969: ||'However,
'||fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
970: ||'
Please Take Appropriate Action.';
971: -- build text body
972: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_TEXT');
973: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
974: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
975: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
976: l_text_body := fnd_message.get;
977: l_text_body := l_text_body

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

970: ||'
Please Take Appropriate Action.';
971: -- build text body
972: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_TEXT');
973: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
974: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
975: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
976: l_text_body := fnd_message.get;
977: l_text_body := l_text_body
978: ||'However,
'||fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')

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

971: -- build text body
972: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_TEXT');
973: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
974: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
975: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
976: l_text_body := fnd_message.get;
977: l_text_body := l_text_body
978: ||'However,
'||fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
979: ||'
Please Take Appropriate Action.';

Line 976: l_text_body := fnd_message.get;

972: fnd_message.set_name('PER','IRC_OFFER_EXPIRY_MGR_TEXT');
973: fnd_message.set_token('APPLICANT_NAME',offer_expiry_rec.applicant_name, false);
974: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
975: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
976: l_text_body := fnd_message.get;
977: l_text_body := l_text_body
978: ||'However,
'||fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
979: ||'
Please Take Appropriate Action.';
980:

Line 978: ||'However,
'||fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')

974: fnd_message.set_token('VACANCY_NAME',offer_expiry_rec.vacancy_name, false);
975: fnd_message.set_token('DAY_OF_EXPIRY',offer_expiry_rec.expiry_date, false);
976: l_text_body := fnd_message.get;
977: l_text_body := l_text_body
978: ||'However,
'||fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
979: ||'
Please Take Appropriate Action.';
980:
981: End if;
982: ---- sending notification to the manager

Line 1003: ,buff => ' Failure Reason: '|| fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')

999: );
1000:
1001: fnd_file.put_line
1002: ( which => fnd_file.log
1003: ,buff => ' Failure Reason: '|| fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
1004: );
1005: END;
1006: END IF;
1007: if send_notitfication_status = 'success' then

Line 1135: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_SUBJECT');

1131: l_current_set_lang := l_apl_lang;
1132: end if;
1133:
1134: -- build subject message
1135: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_SUBJECT');
1136: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.job_posting_title, false);
1137: fnd_message.set_token('JOB_TITLE',offer_expired_rec.ipc_job_title, false);
1138: l_subject := fnd_message.get;
1139:

Line 1136: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.job_posting_title, false);

1132: end if;
1133:
1134: -- build subject message
1135: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_SUBJECT');
1136: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.job_posting_title, false);
1137: fnd_message.set_token('JOB_TITLE',offer_expired_rec.ipc_job_title, false);
1138: l_subject := fnd_message.get;
1139:
1140: hr_utility.set_location(l_proc,30);

Line 1137: fnd_message.set_token('JOB_TITLE',offer_expired_rec.ipc_job_title, false);

1133:
1134: -- build subject message
1135: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_SUBJECT');
1136: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.job_posting_title, false);
1137: fnd_message.set_token('JOB_TITLE',offer_expired_rec.ipc_job_title, false);
1138: l_subject := fnd_message.get;
1139:
1140: hr_utility.set_location(l_proc,30);
1141:

Line 1138: l_subject := fnd_message.get;

1134: -- build subject message
1135: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_SUBJECT');
1136: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.job_posting_title, false);
1137: fnd_message.set_token('JOB_TITLE',offer_expired_rec.ipc_job_title, false);
1138: l_subject := fnd_message.get;
1139:
1140: hr_utility.set_location(l_proc,30);
1141:
1142: --

Line 1147: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_APL_HTML');

1143: -- Build the body of the message both in text and html
1144: --
1145:
1146: -- build html body
1147: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_APL_HTML');
1148: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
1149: l_html_body := fnd_message.get;
1150:
1151: --

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

1144: --
1145:
1146: -- build html body
1147: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_APL_HTML');
1148: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
1149: l_html_body := fnd_message.get;
1150:
1151: --
1152: hr_utility.set_location(l_proc,40);

Line 1149: l_html_body := fnd_message.get;

1145:
1146: -- build html body
1147: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_APL_HTML');
1148: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
1149: l_html_body := fnd_message.get;
1150:
1151: --
1152: hr_utility.set_location(l_proc,40);
1153:

Line 1155: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_APL_TEXT');

1151: --
1152: hr_utility.set_location(l_proc,40);
1153:
1154: -- build text body
1155: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_APL_TEXT');
1156: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
1157: l_text_body := fnd_message.get;
1158:
1159: --

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

1152: hr_utility.set_location(l_proc,40);
1153:
1154: -- build text body
1155: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_APL_TEXT');
1156: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
1157: l_text_body := fnd_message.get;
1158:
1159: --
1160: hr_utility.set_location(l_proc,50);

Line 1157: l_text_body := fnd_message.get;

1153:
1154: -- build text body
1155: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_APL_TEXT');
1156: fnd_message.set_token('SENT_DATE',l_offer_sent_date, false);
1157: l_text_body := fnd_message.get;
1158:
1159: --
1160: hr_utility.set_location(l_proc,50);
1161:

Line 1191: ,buff => 'Failure Reason: '|| fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')

1187: );
1188:
1189: fnd_file.put_line
1190: ( which => fnd_file.log
1191: ,buff => 'Failure Reason: '|| fnd_message.get_string('PER','IRC_412059_NO_ROLE_4_PARTY')
1192: );
1193: END;
1194:
1195: hr_utility.set_location(l_proc,60);

Line 1220: fnd_message.set_name('PER','IRC_412670_OFFER_EXPD_MGR_SUB');

1216: l_current_set_lang := l_mgr_lang;
1217: end if;
1218:
1219: -- build subject message
1220: fnd_message.set_name('PER','IRC_412670_OFFER_EXPD_MGR_SUB');
1221: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.vacancy_name, false);
1222: fnd_message.set_token('JOB_TITLE',offer_expired_rec.job_title, false);
1223: l_subject := fnd_message.get;
1224:

Line 1221: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.vacancy_name, false);

1217: end if;
1218:
1219: -- build subject message
1220: fnd_message.set_name('PER','IRC_412670_OFFER_EXPD_MGR_SUB');
1221: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.vacancy_name, false);
1222: fnd_message.set_token('JOB_TITLE',offer_expired_rec.job_title, false);
1223: l_subject := fnd_message.get;
1224:
1225: -- Build the body of the message both in text and html

Line 1222: fnd_message.set_token('JOB_TITLE',offer_expired_rec.job_title, false);

1218:
1219: -- build subject message
1220: fnd_message.set_name('PER','IRC_412670_OFFER_EXPD_MGR_SUB');
1221: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.vacancy_name, false);
1222: fnd_message.set_token('JOB_TITLE',offer_expired_rec.job_title, false);
1223: l_subject := fnd_message.get;
1224:
1225: -- Build the body of the message both in text and html
1226: if send_notitfication_status = 'success' then

Line 1223: l_subject := fnd_message.get;

1219: -- build subject message
1220: fnd_message.set_name('PER','IRC_412670_OFFER_EXPD_MGR_SUB');
1221: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.vacancy_name, false);
1222: fnd_message.set_token('JOB_TITLE',offer_expired_rec.job_title, false);
1223: l_subject := fnd_message.get;
1224:
1225: -- Build the body of the message both in text and html
1226: if send_notitfication_status = 'success' then
1227: -- get extend offer duration url

Line 1234: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_MGR_HTML');

1230: ,p_offer_id => offer_expired_rec.offer_id);
1231:
1232:
1233: -- build html body
1234: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_MGR_HTML');
1235: fnd_message.set_token('APPLICANT_NAME',offer_expired_rec.applicant_name, false);
1236: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.vacancy_name, false);
1237: l_html_body := fnd_message.get;
1238:

Line 1235: fnd_message.set_token('APPLICANT_NAME',offer_expired_rec.applicant_name, false);

1231:
1232:
1233: -- build html body
1234: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_MGR_HTML');
1235: fnd_message.set_token('APPLICANT_NAME',offer_expired_rec.applicant_name, false);
1236: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.vacancy_name, false);
1237: l_html_body := fnd_message.get;
1238:
1239: --

Line 1236: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.vacancy_name, false);

1232:
1233: -- build html body
1234: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_MGR_HTML');
1235: fnd_message.set_token('APPLICANT_NAME',offer_expired_rec.applicant_name, false);
1236: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.vacancy_name, false);
1237: l_html_body := fnd_message.get;
1238:
1239: --
1240: l_html_body := l_html_body

Line 1237: l_html_body := fnd_message.get;

1233: -- build html body
1234: fnd_message.set_name('PER','IRC_OFFER_EXPIRED_MGR_HTML');
1235: fnd_message.set_token('APPLICANT_NAME',offer_expired_rec.applicant_name, false);
1236: fnd_message.set_token('VACANCY_NAME',offer_expired_rec.vacancy_name, false);
1237: l_html_body := fnd_message.get;
1238:
1239: --
1240: l_html_body := l_html_body
1241: || '