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.EGO_GROUP_WF_PKG dependencies on FND_MESSAGE

Line 645: fnd_message.set_name('EGO', 'EGO_ADD_GROUP_MEMBER_SUBJECT');

641: IF (p_process_type = G_ADD_GROUP_MEMBER_TYPE) THEN
642:
643: --**Set the Message Subject for Owner Approval Request
644: ----------------------------------------------------------------------
645: fnd_message.set_name('EGO', 'EGO_ADD_GROUP_MEMBER_SUBJECT');
646: fnd_message.set_token('MEMBER_NAME', l_member_name);
647: fnd_message.set_token('GROUP_NAME', l_group_name);
648:
649: --set message subject as the item level attribute

Line 646: fnd_message.set_token('MEMBER_NAME', l_member_name);

642:
643: --**Set the Message Subject for Owner Approval Request
644: ----------------------------------------------------------------------
645: fnd_message.set_name('EGO', 'EGO_ADD_GROUP_MEMBER_SUBJECT');
646: fnd_message.set_token('MEMBER_NAME', l_member_name);
647: fnd_message.set_token('GROUP_NAME', l_group_name);
648:
649: --set message subject as the item level attribute
650: wf_engine.SetItemAttrText( itemtype => p_item_type,

Line 647: fnd_message.set_token('GROUP_NAME', l_group_name);

643: --**Set the Message Subject for Owner Approval Request
644: ----------------------------------------------------------------------
645: fnd_message.set_name('EGO', 'EGO_ADD_GROUP_MEMBER_SUBJECT');
646: fnd_message.set_token('MEMBER_NAME', l_member_name);
647: fnd_message.set_token('GROUP_NAME', l_group_name);
648:
649: --set message subject as the item level attribute
650: wf_engine.SetItemAttrText( itemtype => p_item_type,
651: itemkey => p_item_key,

Line 653: avalue => fnd_message.get);

649: --set message subject as the item level attribute
650: wf_engine.SetItemAttrText( itemtype => p_item_type,
651: itemkey => p_item_key,
652: aname =>'EGO_OWNER_APPROVAL_REQ_SUBJECT',
653: avalue => fnd_message.get);
654: ----------------------------------------------------------------------
655:
656: --This is a call for creating a PLSQL document.
657: --Add_GrpMem_Approval_Req_Doc gets the message from FND_NEW_MESSAGES

Line 672: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CONF_SUBJ');

668: --*******Set the subsequent notifications body texts**********
669: --**Set the Approval Message body
670: ----------------------------------------------------------------------
671:
672: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CONF_SUBJ');
673: fnd_message.set_token('GROUP_NAME', l_group_name);
674:
675: --set message subject as the item level attribute
676: wf_engine.SetItemAttrText( itemtype => p_item_type,

Line 673: fnd_message.set_token('GROUP_NAME', l_group_name);

669: --**Set the Approval Message body
670: ----------------------------------------------------------------------
671:
672: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CONF_SUBJ');
673: fnd_message.set_token('GROUP_NAME', l_group_name);
674:
675: --set message subject as the item level attribute
676: wf_engine.SetItemAttrText( itemtype => p_item_type,
677: itemkey => p_item_key,

Line 679: avalue => fnd_message.get);

675: --set message subject as the item level attribute
676: wf_engine.SetItemAttrText( itemtype => p_item_type,
677: itemkey => p_item_key,
678: aname =>'EGO_MEMBER_APPROVAL_SUBJECT',
679: avalue => fnd_message.get);
680:
681: -- fix for 3096076 removing the reference of setting the attribute
682: -- and calling the package to dynamically create the document
683: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Add_GrpMem_Approval_Msg_Doc/'

Line 694: -- fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CONF_BODY');

690: --
691: -- --get mail preference of the member bug : 1726010
692: -- l_mail_pref := get_mail_pref(l_member_id);
693: -- IF (l_mail_pref = 'MAILTEXT') THEN
694: -- fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CONF_BODY');
695: -- ELSE
696: -- fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CNF_HTM_BODY');
697: -- END IF;
698: --

Line 696: -- fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CNF_HTM_BODY');

692: -- l_mail_pref := get_mail_pref(l_member_id);
693: -- IF (l_mail_pref = 'MAILTEXT') THEN
694: -- fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CONF_BODY');
695: -- ELSE
696: -- fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CNF_HTM_BODY');
697: -- END IF;
698: --
699: -- fnd_message.set_token('GROUP_NAME', l_group_name);
700: -- --This method needs to be taken out, so that this 'NOTE' token is

Line 699: -- fnd_message.set_token('GROUP_NAME', l_group_name);

695: -- ELSE
696: -- fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CNF_HTM_BODY');
697: -- END IF;
698: --
699: -- fnd_message.set_token('GROUP_NAME', l_group_name);
700: -- --This method needs to be taken out, so that this 'NOTE' token is
701: -- --dynamically replaced with the Owner's Comments
702: ---- fnd_message.set_token('NOTE', '');
703: -- -- currently in workflow, the comments are not comming..

Line 702: ---- fnd_message.set_token('NOTE', '');

698: --
699: -- fnd_message.set_token('GROUP_NAME', l_group_name);
700: -- --This method needs to be taken out, so that this 'NOTE' token is
701: -- --dynamically replaced with the Owner's Comments
702: ---- fnd_message.set_token('NOTE', '');
703: -- -- currently in workflow, the comments are not comming..
704: -- fnd_message.set_token('GROUP_ADMIN_COMMENTS', NULL);
705: -- --set message body as the item level attribute
706: -- wf_engine.SetItemAttrText( itemtype => p_item_type,

Line 704: -- fnd_message.set_token('GROUP_ADMIN_COMMENTS', NULL);

700: -- --This method needs to be taken out, so that this 'NOTE' token is
701: -- --dynamically replaced with the Owner's Comments
702: ---- fnd_message.set_token('NOTE', '');
703: -- -- currently in workflow, the comments are not comming..
704: -- fnd_message.set_token('GROUP_ADMIN_COMMENTS', NULL);
705: -- --set message body as the item level attribute
706: -- wf_engine.SetItemAttrText( itemtype => p_item_type,
707: -- itemkey => p_item_key,
708: -- aname =>'EGO_MEMBER_APPROVAL_MSG_BODY',

Line 709: -- avalue => fnd_message.get);

705: -- --set message body as the item level attribute
706: -- wf_engine.SetItemAttrText( itemtype => p_item_type,
707: -- itemkey => p_item_key,
708: -- aname =>'EGO_MEMBER_APPROVAL_MSG_BODY',
709: -- avalue => fnd_message.get);
710: --
711: ----------------------------------------------------------------------
712:
713: --**Set the Rejection Message body

Line 715: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJECT_SUBJ');

711: ----------------------------------------------------------------------
712:
713: --**Set the Rejection Message body
714: ----------------------------------------------------------------------
715: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJECT_SUBJ');
716: fnd_message.set_token('GROUP_NAME', l_group_name);
717:
718: --set message subject as the item level attribute
719: wf_engine.SetItemAttrText( itemtype => p_item_type,

Line 716: fnd_message.set_token('GROUP_NAME', l_group_name);

712:
713: --**Set the Rejection Message body
714: ----------------------------------------------------------------------
715: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJECT_SUBJ');
716: fnd_message.set_token('GROUP_NAME', l_group_name);
717:
718: --set message subject as the item level attribute
719: wf_engine.SetItemAttrText( itemtype => p_item_type,
720: itemkey => p_item_key,

Line 722: avalue => fnd_message.get);

718: --set message subject as the item level attribute
719: wf_engine.SetItemAttrText( itemtype => p_item_type,
720: itemkey => p_item_key,
721: aname =>'EGO_MEMBER_REJECTION_SUBJECT',
722: avalue => fnd_message.get);
723:
724: -- fix for 3096076 removing the reference of setting the attribute
725: -- and calling the package to dynamically create the document
726: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Add_GrpMem_Reject_Msg_Doc/'

Line 739: -- fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJECT_BODY');

735: -- --get mail preference of the member bug : 1726010
736: --
737: -- l_mail_pref := get_mail_pref(l_member_id);
738: -- IF (l_mail_pref = 'MAILTEXT') THEN
739: -- fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJECT_BODY');
740: -- ELSE
741: -- fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJ_HTM_BODY');
742: -- END IF;
743: --

Line 741: -- fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJ_HTM_BODY');

737: -- l_mail_pref := get_mail_pref(l_member_id);
738: -- IF (l_mail_pref = 'MAILTEXT') THEN
739: -- fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJECT_BODY');
740: -- ELSE
741: -- fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJ_HTM_BODY');
742: -- END IF;
743: --
744: -- fnd_message.set_token('GROUP_NAME', l_group_name);
745: -- --This method needs to be taken out, so that this 'NOTE' token is

Line 744: -- fnd_message.set_token('GROUP_NAME', l_group_name);

740: -- ELSE
741: -- fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJ_HTM_BODY');
742: -- END IF;
743: --
744: -- fnd_message.set_token('GROUP_NAME', l_group_name);
745: -- --This method needs to be taken out, so that this 'NOTE' token is
746: -- --dynamically replaced with the Owner's Comments
747: ---- fnd_message.set_token('NOTE', '');
748: -- fnd_message.set_token('GROUP_ADMIN_COMMENTS', NULL);

Line 747: ---- fnd_message.set_token('NOTE', '');

743: --
744: -- fnd_message.set_token('GROUP_NAME', l_group_name);
745: -- --This method needs to be taken out, so that this 'NOTE' token is
746: -- --dynamically replaced with the Owner's Comments
747: ---- fnd_message.set_token('NOTE', '');
748: -- fnd_message.set_token('GROUP_ADMIN_COMMENTS', NULL);
749: --
750: -- --set message subject as the item level attribute
751: -- wf_engine.SetItemAttrText( itemtype => p_item_type,

Line 748: -- fnd_message.set_token('GROUP_ADMIN_COMMENTS', NULL);

744: -- fnd_message.set_token('GROUP_NAME', l_group_name);
745: -- --This method needs to be taken out, so that this 'NOTE' token is
746: -- --dynamically replaced with the Owner's Comments
747: ---- fnd_message.set_token('NOTE', '');
748: -- fnd_message.set_token('GROUP_ADMIN_COMMENTS', NULL);
749: --
750: -- --set message subject as the item level attribute
751: -- wf_engine.SetItemAttrText( itemtype => p_item_type,
752: -- itemkey => p_item_key,

Line 754: -- avalue => fnd_message.get);

750: -- --set message subject as the item level attribute
751: -- wf_engine.SetItemAttrText( itemtype => p_item_type,
752: -- itemkey => p_item_key,
753: -- aname =>'EGO_MEMBER_REJECTION_MSG_BODY',
754: -- avalue => fnd_message.get);
755: --
756:
757: ----------------------------------------------------------------------
758: --*****END: Set the subsequent notifications body texts*********

Line 767: fnd_message.set_name('EGO', 'EGO_UNSUBSCR_GROUP_MEMBER_SUBJ');

763: IF (p_process_type = G_REMOVE_GROUP_MEMBER_TYPE) THEN
764:
765: --**Set the Message Subject and Body for Owner Unsubscription Notf FYI
766: ----------------------------------------------------------------------
767: fnd_message.set_name('EGO', 'EGO_UNSUBSCR_GROUP_MEMBER_SUBJ');
768: fnd_message.set_token('MEMBER_NAME', l_member_name);
769: fnd_message.set_token('GROUP_NAME', l_group_name);
770:
771: --set message subject as the item level attribute

Line 768: fnd_message.set_token('MEMBER_NAME', l_member_name);

764:
765: --**Set the Message Subject and Body for Owner Unsubscription Notf FYI
766: ----------------------------------------------------------------------
767: fnd_message.set_name('EGO', 'EGO_UNSUBSCR_GROUP_MEMBER_SUBJ');
768: fnd_message.set_token('MEMBER_NAME', l_member_name);
769: fnd_message.set_token('GROUP_NAME', l_group_name);
770:
771: --set message subject as the item level attribute
772: wf_engine.SetItemAttrText( itemtype => p_item_type,

Line 769: fnd_message.set_token('GROUP_NAME', l_group_name);

765: --**Set the Message Subject and Body for Owner Unsubscription Notf FYI
766: ----------------------------------------------------------------------
767: fnd_message.set_name('EGO', 'EGO_UNSUBSCR_GROUP_MEMBER_SUBJ');
768: fnd_message.set_token('MEMBER_NAME', l_member_name);
769: fnd_message.set_token('GROUP_NAME', l_group_name);
770:
771: --set message subject as the item level attribute
772: wf_engine.SetItemAttrText( itemtype => p_item_type,
773: itemkey => p_item_key,

Line 775: avalue => fnd_message.get);

771: --set message subject as the item level attribute
772: wf_engine.SetItemAttrText( itemtype => p_item_type,
773: itemkey => p_item_key,
774: aname =>'EGO_OWNER_UNSUBSCR_FYI_SUBJECT',
775: avalue => fnd_message.get);
776:
777: -- fix for 3096076 removing the reference of setting the attribute
778: -- and calling the package to dynamically create the document
779: mdebug (' Remove Group Member Subject Set '|| fnd_message.get);

Line 779: mdebug (' Remove Group Member Subject Set '|| fnd_message.get);

775: avalue => fnd_message.get);
776:
777: -- fix for 3096076 removing the reference of setting the attribute
778: -- and calling the package to dynamically create the document
779: mdebug (' Remove Group Member Subject Set '|| fnd_message.get);
780: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Unsub_Member_Owner_FYI_Doc/'
781: ||p_item_type||':'||p_item_key;
782: --set Reject Notification body as the item level attribute
783: wf_engine.SetItemAttrText( itemtype => p_item_type,

Line 792: -- fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS');

788: -- l_mail_pref := get_mail_pref(l_member_id);
789: --
790: -- IF (l_mail_pref = 'MAILTEXT') THEN
791: -- IF l_member_note IS NOT NULL THEN
792: -- fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS');
793: -- fnd_message.set_token('MEMBER_NAME', l_member_name);
794: -- fnd_message.set_token('NOTE', l_member_note);
795: -- l_temp_message := fnd_message.get;
796: -- ELSE

Line 793: -- fnd_message.set_token('MEMBER_NAME', l_member_name);

789: --
790: -- IF (l_mail_pref = 'MAILTEXT') THEN
791: -- IF l_member_note IS NOT NULL THEN
792: -- fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS');
793: -- fnd_message.set_token('MEMBER_NAME', l_member_name);
794: -- fnd_message.set_token('NOTE', l_member_note);
795: -- l_temp_message := fnd_message.get;
796: -- ELSE
797: -- l_temp_message := NULL;

Line 794: -- fnd_message.set_token('NOTE', l_member_note);

790: -- IF (l_mail_pref = 'MAILTEXT') THEN
791: -- IF l_member_note IS NOT NULL THEN
792: -- fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS');
793: -- fnd_message.set_token('MEMBER_NAME', l_member_name);
794: -- fnd_message.set_token('NOTE', l_member_note);
795: -- l_temp_message := fnd_message.get;
796: -- ELSE
797: -- l_temp_message := NULL;
798: -- END IF;

Line 795: -- l_temp_message := fnd_message.get;

791: -- IF l_member_note IS NOT NULL THEN
792: -- fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS');
793: -- fnd_message.set_token('MEMBER_NAME', l_member_name);
794: -- fnd_message.set_token('NOTE', l_member_note);
795: -- l_temp_message := fnd_message.get;
796: -- ELSE
797: -- l_temp_message := NULL;
798: -- END IF;
799: -- fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_BODY');

Line 799: -- fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_BODY');

795: -- l_temp_message := fnd_message.get;
796: -- ELSE
797: -- l_temp_message := NULL;
798: -- END IF;
799: -- fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_BODY');
800: -- ELSE
801: -- IF l_member_note IS NOT NULL THEN
802: -- fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');
803: -- fnd_message.set_token('MEMBER_NAME', l_member_name);

Line 802: -- fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');

798: -- END IF;
799: -- fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_BODY');
800: -- ELSE
801: -- IF l_member_note IS NOT NULL THEN
802: -- fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');
803: -- fnd_message.set_token('MEMBER_NAME', l_member_name);
804: -- fnd_message.set_token('NOTE', l_member_note);
805: -- l_temp_message := fnd_message.get;
806: -- ELSE

Line 803: -- fnd_message.set_token('MEMBER_NAME', l_member_name);

799: -- fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_BODY');
800: -- ELSE
801: -- IF l_member_note IS NOT NULL THEN
802: -- fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');
803: -- fnd_message.set_token('MEMBER_NAME', l_member_name);
804: -- fnd_message.set_token('NOTE', l_member_note);
805: -- l_temp_message := fnd_message.get;
806: -- ELSE
807: -- l_temp_message := NULL;

Line 804: -- fnd_message.set_token('NOTE', l_member_note);

800: -- ELSE
801: -- IF l_member_note IS NOT NULL THEN
802: -- fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');
803: -- fnd_message.set_token('MEMBER_NAME', l_member_name);
804: -- fnd_message.set_token('NOTE', l_member_note);
805: -- l_temp_message := fnd_message.get;
806: -- ELSE
807: -- l_temp_message := NULL;
808: -- END IF;

Line 805: -- l_temp_message := fnd_message.get;

801: -- IF l_member_note IS NOT NULL THEN
802: -- fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');
803: -- fnd_message.set_token('MEMBER_NAME', l_member_name);
804: -- fnd_message.set_token('NOTE', l_member_note);
805: -- l_temp_message := fnd_message.get;
806: -- ELSE
807: -- l_temp_message := NULL;
808: -- END IF;
809: -- fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_HTM_BODY');

Line 809: -- fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_HTM_BODY');

805: -- l_temp_message := fnd_message.get;
806: -- ELSE
807: -- l_temp_message := NULL;
808: -- END IF;
809: -- fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_HTM_BODY');
810: -- END IF;
811: --
812: -- fnd_message.set_token('MEMBER_NAME', l_member_name);
813: -- fnd_message.set_token('GROUP_NAME', l_group_name);

Line 812: -- fnd_message.set_token('MEMBER_NAME', l_member_name);

808: -- END IF;
809: -- fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_HTM_BODY');
810: -- END IF;
811: --
812: -- fnd_message.set_token('MEMBER_NAME', l_member_name);
813: -- fnd_message.set_token('GROUP_NAME', l_group_name);
814: -- fnd_message.set_token('GROUP_MEM_COMMENTS', l_temp_message);
815: --
816: -- --set message subject as the item level attribute

Line 813: -- fnd_message.set_token('GROUP_NAME', l_group_name);

809: -- fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_HTM_BODY');
810: -- END IF;
811: --
812: -- fnd_message.set_token('MEMBER_NAME', l_member_name);
813: -- fnd_message.set_token('GROUP_NAME', l_group_name);
814: -- fnd_message.set_token('GROUP_MEM_COMMENTS', l_temp_message);
815: --
816: -- --set message subject as the item level attribute
817: -- wf_engine.SetItemAttrText( itemtype => p_item_type,

Line 814: -- fnd_message.set_token('GROUP_MEM_COMMENTS', l_temp_message);

810: -- END IF;
811: --
812: -- fnd_message.set_token('MEMBER_NAME', l_member_name);
813: -- fnd_message.set_token('GROUP_NAME', l_group_name);
814: -- fnd_message.set_token('GROUP_MEM_COMMENTS', l_temp_message);
815: --
816: -- --set message subject as the item level attribute
817: -- wf_engine.SetItemAttrText( itemtype => p_item_type,
818: -- itemkey => p_item_key,

Line 820: -- avalue => fnd_message.get);

816: -- --set message subject as the item level attribute
817: -- wf_engine.SetItemAttrText( itemtype => p_item_type,
818: -- itemkey => p_item_key,
819: -- aname =>'EGO_OWNER_UNSUBSCR_FYI_BODY',
820: -- avalue => fnd_message.get);
821: -- mdebug (' Remove Group Member Body Set '|| fnd_message.get);
822: --
823: ----------------------------------------------------------------------
824:

Line 821: -- mdebug (' Remove Group Member Body Set '|| fnd_message.get);

817: -- wf_engine.SetItemAttrText( itemtype => p_item_type,
818: -- itemkey => p_item_key,
819: -- aname =>'EGO_OWNER_UNSUBSCR_FYI_BODY',
820: -- avalue => fnd_message.get);
821: -- mdebug (' Remove Group Member Body Set '|| fnd_message.get);
822: --
823: ----------------------------------------------------------------------
824:
825: --*******Set the subsequent notifications body texts**********

Line 828: fnd_message.set_name('EGO', 'EGO_UNSUBSCR_GRPMEM_CONF_SUBJ');

824:
825: --*******Set the subsequent notifications body texts**********
826: --**Set the Member Unsubscription Confirmation Message Subject and Body
827: ----------------------------------------------------------------------
828: fnd_message.set_name('EGO', 'EGO_UNSUBSCR_GRPMEM_CONF_SUBJ');
829: fnd_message.set_token('GROUP_NAME', l_group_name);
830:
831: --set message subject as the item level attribute
832: wf_engine.SetItemAttrText( itemtype => p_item_type,

Line 829: fnd_message.set_token('GROUP_NAME', l_group_name);

825: --*******Set the subsequent notifications body texts**********
826: --**Set the Member Unsubscription Confirmation Message Subject and Body
827: ----------------------------------------------------------------------
828: fnd_message.set_name('EGO', 'EGO_UNSUBSCR_GRPMEM_CONF_SUBJ');
829: fnd_message.set_token('GROUP_NAME', l_group_name);
830:
831: --set message subject as the item level attribute
832: wf_engine.SetItemAttrText( itemtype => p_item_type,
833: itemkey => p_item_key,

Line 835: avalue => fnd_message.get);

831: --set message subject as the item level attribute
832: wf_engine.SetItemAttrText( itemtype => p_item_type,
833: itemkey => p_item_key,
834: aname =>'EGO_UNSUBSCR_GRPMEM_CONF_SUBJ',
835: avalue => fnd_message.get);
836:
837: -- fix for 3096076 removing the reference of setting the attribute
838: -- and calling the package to dynamically create the document
839: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Unsub_Member_Conf_Mem_Doc/'

Line 851: -- fnd_message.set_name('EGO', 'EGO_UNSUBSCR_GRPMEM_CONF_BODY');

847: -- --get mail preference of the member bug : 1726010
848: --
849: -- l_mail_pref := get_mail_pref(l_member_id);
850: -- IF (l_mail_pref = 'MAILTEXT') THEN
851: -- fnd_message.set_name('EGO', 'EGO_UNSUBSCR_GRPMEM_CONF_BODY');
852: -- ELSE
853: -- fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_CNF_HTM_BODY');
854: -- END IF;
855: --

Line 853: -- fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_CNF_HTM_BODY');

849: -- l_mail_pref := get_mail_pref(l_member_id);
850: -- IF (l_mail_pref = 'MAILTEXT') THEN
851: -- fnd_message.set_name('EGO', 'EGO_UNSUBSCR_GRPMEM_CONF_BODY');
852: -- ELSE
853: -- fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_CNF_HTM_BODY');
854: -- END IF;
855: --
856: -- fnd_message.set_token('GROUP_NAME', l_group_name);
857: --

Line 856: -- fnd_message.set_token('GROUP_NAME', l_group_name);

852: -- ELSE
853: -- fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_CNF_HTM_BODY');
854: -- END IF;
855: --
856: -- fnd_message.set_token('GROUP_NAME', l_group_name);
857: --
858: -- --set message body as the item level attribute
859: -- wf_engine.SetItemAttrText( itemtype => p_item_type,
860: -- itemkey => p_item_key,

Line 862: -- avalue => fnd_message.get);

858: -- --set message body as the item level attribute
859: -- wf_engine.SetItemAttrText( itemtype => p_item_type,
860: -- itemkey => p_item_key,
861: -- aname =>'EGO_UNSUBSCR_GRPMEM_CONF_BODY',
862: -- avalue => fnd_message.get);
863: --
864: ----------------------------------------------------------------------
865: --*****END: Set the subsequent notifications body texts*********
866:

Line 1697: fnd_message.set_name('EGO', 'EGO_GROUP_DEL_MEM_NOTF_SUBJ');

1693: -- --
1694: -- Set the subject outside the loop --
1695: -- --
1696: ------------------------------------------------
1697: fnd_message.set_name('EGO', 'EGO_GROUP_DEL_MEM_NOTF_SUBJ');
1698: fnd_message.set_token('GROUP_NAME', l_group_name);
1699: --set message subject as the item level attribute
1700: wf_engine.SetItemAttrText(itemtype => p_item_type,
1701: itemkey => p_item_key,

Line 1698: fnd_message.set_token('GROUP_NAME', l_group_name);

1694: -- Set the subject outside the loop --
1695: -- --
1696: ------------------------------------------------
1697: fnd_message.set_name('EGO', 'EGO_GROUP_DEL_MEM_NOTF_SUBJ');
1698: fnd_message.set_token('GROUP_NAME', l_group_name);
1699: --set message subject as the item level attribute
1700: wf_engine.SetItemAttrText(itemtype => p_item_type,
1701: itemkey => p_item_key,
1702: aname => 'EGO_GROUP_DEL_MEM_NOTF_SUBJ',

Line 1703: avalue => fnd_message.get);

1699: --set message subject as the item level attribute
1700: wf_engine.SetItemAttrText(itemtype => p_item_type,
1701: itemkey => p_item_key,
1702: aname => 'EGO_GROUP_DEL_MEM_NOTF_SUBJ',
1703: avalue => fnd_message.get);
1704:
1705: l_msg_document_plsql_proc:='PLSQL:EGO_GROUP_WF_PKG.Del_Grp_Admin_Notif_Doc/'
1706: ||p_item_type||':'||p_item_key;
1707:

Line 1870: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS');

1866: l_mail_pref := G_USER_MAIL_PREFERENCE;
1867:
1868: IF (l_mail_pref = 'MAILTEXT') THEN
1869: IF l_member_note IS NOT NULL THEN
1870: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS');
1871: fnd_message.set_token('MEMBER_NAME', l_member_name);
1872: fnd_message.set_token('NOTE', l_member_note);
1873: l_temp_message := fnd_message.get;
1874: ELSE

Line 1871: fnd_message.set_token('MEMBER_NAME', l_member_name);

1867:
1868: IF (l_mail_pref = 'MAILTEXT') THEN
1869: IF l_member_note IS NOT NULL THEN
1870: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS');
1871: fnd_message.set_token('MEMBER_NAME', l_member_name);
1872: fnd_message.set_token('NOTE', l_member_note);
1873: l_temp_message := fnd_message.get;
1874: ELSE
1875: l_temp_message := NULL;

Line 1872: fnd_message.set_token('NOTE', l_member_note);

1868: IF (l_mail_pref = 'MAILTEXT') THEN
1869: IF l_member_note IS NOT NULL THEN
1870: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS');
1871: fnd_message.set_token('MEMBER_NAME', l_member_name);
1872: fnd_message.set_token('NOTE', l_member_note);
1873: l_temp_message := fnd_message.get;
1874: ELSE
1875: l_temp_message := NULL;
1876: END IF;

Line 1873: l_temp_message := fnd_message.get;

1869: IF l_member_note IS NOT NULL THEN
1870: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS');
1871: fnd_message.set_token('MEMBER_NAME', l_member_name);
1872: fnd_message.set_token('NOTE', l_member_note);
1873: l_temp_message := fnd_message.get;
1874: ELSE
1875: l_temp_message := NULL;
1876: END IF;
1877: fnd_message.set_name('EGO', 'EGO_ADD_GROUP_MEMBER_BODY');

Line 1877: fnd_message.set_name('EGO', 'EGO_ADD_GROUP_MEMBER_BODY');

1873: l_temp_message := fnd_message.get;
1874: ELSE
1875: l_temp_message := NULL;
1876: END IF;
1877: fnd_message.set_name('EGO', 'EGO_ADD_GROUP_MEMBER_BODY');
1878: ELSE
1879: -- mail preference is MAILHTML
1880: IF l_member_note IS NOT NULL THEN
1881: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');

Line 1881: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');

1877: fnd_message.set_name('EGO', 'EGO_ADD_GROUP_MEMBER_BODY');
1878: ELSE
1879: -- mail preference is MAILHTML
1880: IF l_member_note IS NOT NULL THEN
1881: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');
1882: fnd_message.set_token('MEMBER_NAME', l_member_name);
1883: fnd_message.set_token('NOTE', l_member_note);
1884: l_temp_message := fnd_message.get;
1885: ELSE

Line 1882: fnd_message.set_token('MEMBER_NAME', l_member_name);

1878: ELSE
1879: -- mail preference is MAILHTML
1880: IF l_member_note IS NOT NULL THEN
1881: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');
1882: fnd_message.set_token('MEMBER_NAME', l_member_name);
1883: fnd_message.set_token('NOTE', l_member_note);
1884: l_temp_message := fnd_message.get;
1885: ELSE
1886: l_temp_message := NULL;

Line 1883: fnd_message.set_token('NOTE', l_member_note);

1879: -- mail preference is MAILHTML
1880: IF l_member_note IS NOT NULL THEN
1881: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');
1882: fnd_message.set_token('MEMBER_NAME', l_member_name);
1883: fnd_message.set_token('NOTE', l_member_note);
1884: l_temp_message := fnd_message.get;
1885: ELSE
1886: l_temp_message := NULL;
1887: END IF;

Line 1884: l_temp_message := fnd_message.get;

1880: IF l_member_note IS NOT NULL THEN
1881: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');
1882: fnd_message.set_token('MEMBER_NAME', l_member_name);
1883: fnd_message.set_token('NOTE', l_member_note);
1884: l_temp_message := fnd_message.get;
1885: ELSE
1886: l_temp_message := NULL;
1887: END IF;
1888: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_APPR_HTM_BODY');

Line 1888: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_APPR_HTM_BODY');

1884: l_temp_message := fnd_message.get;
1885: ELSE
1886: l_temp_message := NULL;
1887: END IF;
1888: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_APPR_HTM_BODY');
1889: END IF;
1890: fnd_message.set_token('MEMBER_NAME', l_member_name);
1891: fnd_message.set_token('GROUP_NAME', l_group_name);
1892: fnd_message.set_token('GROUP_MEM_COMMENTS',l_temp_message);

Line 1890: fnd_message.set_token('MEMBER_NAME', l_member_name);

1886: l_temp_message := NULL;
1887: END IF;
1888: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_APPR_HTM_BODY');
1889: END IF;
1890: fnd_message.set_token('MEMBER_NAME', l_member_name);
1891: fnd_message.set_token('GROUP_NAME', l_group_name);
1892: fnd_message.set_token('GROUP_MEM_COMMENTS',l_temp_message);
1893: document:=fnd_message.get;
1894:

Line 1891: fnd_message.set_token('GROUP_NAME', l_group_name);

1887: END IF;
1888: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_APPR_HTM_BODY');
1889: END IF;
1890: fnd_message.set_token('MEMBER_NAME', l_member_name);
1891: fnd_message.set_token('GROUP_NAME', l_group_name);
1892: fnd_message.set_token('GROUP_MEM_COMMENTS',l_temp_message);
1893: document:=fnd_message.get;
1894:
1895: document_type := display_type;

Line 1892: fnd_message.set_token('GROUP_MEM_COMMENTS',l_temp_message);

1888: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_APPR_HTM_BODY');
1889: END IF;
1890: fnd_message.set_token('MEMBER_NAME', l_member_name);
1891: fnd_message.set_token('GROUP_NAME', l_group_name);
1892: fnd_message.set_token('GROUP_MEM_COMMENTS',l_temp_message);
1893: document:=fnd_message.get;
1894:
1895: document_type := display_type;
1896:

Line 1893: document:=fnd_message.get;

1889: END IF;
1890: fnd_message.set_token('MEMBER_NAME', l_member_name);
1891: fnd_message.set_token('GROUP_NAME', l_group_name);
1892: fnd_message.set_token('GROUP_MEM_COMMENTS',l_temp_message);
1893: document:=fnd_message.get;
1894:
1895: document_type := display_type;
1896:
1897: EXCEPTION

Line 1969: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJECT_BODY');

1965: itemkey => l_item_key,
1966: aname => G_MEMBER_ID);
1967: l_mail_pref := get_mail_pref(l_member_id);
1968: IF (display_type = 'text/plain') THEN
1969: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJECT_BODY');
1970: ELSE
1971: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJ_HTM_BODY');
1972: END IF;
1973:

Line 1971: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJ_HTM_BODY');

1967: l_mail_pref := get_mail_pref(l_member_id);
1968: IF (display_type = 'text/plain') THEN
1969: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJECT_BODY');
1970: ELSE
1971: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJ_HTM_BODY');
1972: END IF;
1973:
1974: fnd_message.set_token('GROUP_NAME', l_group_name);
1975:

Line 1974: fnd_message.set_token('GROUP_NAME', l_group_name);

1970: ELSE
1971: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_REJ_HTM_BODY');
1972: END IF;
1973:
1974: fnd_message.set_token('GROUP_NAME', l_group_name);
1975:
1976: l_user_name := wf_engine.GetItemAttrText( itemtype => l_item_type,
1977: itemkey => l_item_key,
1978: aname => G_RESPONDER_NAME);

Line 1983: fnd_message.set_token('GROUP_ADMIN_REJECTOR',l_respondent);

1979: OPEN c_get_party_name (cp_user_name => l_user_name);
1980: FETCH c_get_party_name INTO l_respondent;
1981: CLOSE c_get_party_name;
1982:
1983: fnd_message.set_token('GROUP_ADMIN_REJECTOR',l_respondent);
1984: document:=fnd_message.get;
1985: document_type := display_type;
1986: EXCEPTION
1987: WHEN OTHERS THEN

Line 1984: document:=fnd_message.get;

1980: FETCH c_get_party_name INTO l_respondent;
1981: CLOSE c_get_party_name;
1982:
1983: fnd_message.set_token('GROUP_ADMIN_REJECTOR',l_respondent);
1984: document:=fnd_message.get;
1985: document_type := display_type;
1986: EXCEPTION
1987: WHEN OTHERS THEN
1988: wf_core.context(G_PACKAGE_NAME,'Add_GrpMem_Reject_Msg_Doc',l_item_type,l_item_key);

Line 2050: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CONF_BODY');

2046: itemkey => l_item_key,
2047: aname => G_MEMBER_ID);
2048: l_mail_pref := get_mail_pref(l_member_id);
2049: IF (l_mail_pref = 'MAILTEXT') THEN
2050: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CONF_BODY');
2051: ELSE
2052: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CNF_HTM_BODY');
2053: END IF;
2054:

Line 2052: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CNF_HTM_BODY');

2048: l_mail_pref := get_mail_pref(l_member_id);
2049: IF (l_mail_pref = 'MAILTEXT') THEN
2050: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CONF_BODY');
2051: ELSE
2052: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CNF_HTM_BODY');
2053: END IF;
2054:
2055:
2056: IF (display_type = 'text/plain') THEN

Line 2057: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CONF_BODY');

2053: END IF;
2054:
2055:
2056: IF (display_type = 'text/plain') THEN
2057: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CONF_BODY');
2058: ELSE
2059: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CNF_HTM_BODY');
2060: END IF;
2061:

Line 2059: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CNF_HTM_BODY');

2055:
2056: IF (display_type = 'text/plain') THEN
2057: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CONF_BODY');
2058: ELSE
2059: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CNF_HTM_BODY');
2060: END IF;
2061:
2062: fnd_message.set_token('GROUP_NAME', l_group_name);
2063: fnd_message.set_token('GROUP_ADMIN_COMMENTS', NULL);

Line 2062: fnd_message.set_token('GROUP_NAME', l_group_name);

2058: ELSE
2059: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CNF_HTM_BODY');
2060: END IF;
2061:
2062: fnd_message.set_token('GROUP_NAME', l_group_name);
2063: fnd_message.set_token('GROUP_ADMIN_COMMENTS', NULL);
2064:
2065: document:=fnd_message.get;
2066: document_type := display_type;

Line 2063: fnd_message.set_token('GROUP_ADMIN_COMMENTS', NULL);

2059: fnd_message.set_name('EGO', 'EGO_ADD_GROUPMEM_CNF_HTM_BODY');
2060: END IF;
2061:
2062: fnd_message.set_token('GROUP_NAME', l_group_name);
2063: fnd_message.set_token('GROUP_ADMIN_COMMENTS', NULL);
2064:
2065: document:=fnd_message.get;
2066: document_type := display_type;
2067:

Line 2065: document:=fnd_message.get;

2061:
2062: fnd_message.set_token('GROUP_NAME', l_group_name);
2063: fnd_message.set_token('GROUP_ADMIN_COMMENTS', NULL);
2064:
2065: document:=fnd_message.get;
2066: document_type := display_type;
2067:
2068: EXCEPTION
2069: WHEN OTHERS THEN

Line 2139: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS');

2135: aname => G_MEMBER_ID);
2136: l_mail_pref := get_mail_pref(l_member_id);
2137: IF (l_mail_pref = 'MAILTEXT') THEN
2138: IF l_member_note IS NOT NULL THEN
2139: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS');
2140: fnd_message.set_token('MEMBER_NAME', l_member_name);
2141: fnd_message.set_token('NOTE', l_member_note);
2142: l_temp_message := fnd_message.get;
2143: ELSE

Line 2140: fnd_message.set_token('MEMBER_NAME', l_member_name);

2136: l_mail_pref := get_mail_pref(l_member_id);
2137: IF (l_mail_pref = 'MAILTEXT') THEN
2138: IF l_member_note IS NOT NULL THEN
2139: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS');
2140: fnd_message.set_token('MEMBER_NAME', l_member_name);
2141: fnd_message.set_token('NOTE', l_member_note);
2142: l_temp_message := fnd_message.get;
2143: ELSE
2144: l_temp_message := NULL;

Line 2141: fnd_message.set_token('NOTE', l_member_note);

2137: IF (l_mail_pref = 'MAILTEXT') THEN
2138: IF l_member_note IS NOT NULL THEN
2139: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS');
2140: fnd_message.set_token('MEMBER_NAME', l_member_name);
2141: fnd_message.set_token('NOTE', l_member_note);
2142: l_temp_message := fnd_message.get;
2143: ELSE
2144: l_temp_message := NULL;
2145: END IF;

Line 2142: l_temp_message := fnd_message.get;

2138: IF l_member_note IS NOT NULL THEN
2139: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS');
2140: fnd_message.set_token('MEMBER_NAME', l_member_name);
2141: fnd_message.set_token('NOTE', l_member_note);
2142: l_temp_message := fnd_message.get;
2143: ELSE
2144: l_temp_message := NULL;
2145: END IF;
2146: fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_BODY');

Line 2146: fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_BODY');

2142: l_temp_message := fnd_message.get;
2143: ELSE
2144: l_temp_message := NULL;
2145: END IF;
2146: fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_BODY');
2147: ELSE
2148: IF l_member_note IS NOT NULL THEN
2149: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');
2150: fnd_message.set_token('MEMBER_NAME', l_member_name);

Line 2149: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');

2145: END IF;
2146: fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_BODY');
2147: ELSE
2148: IF l_member_note IS NOT NULL THEN
2149: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');
2150: fnd_message.set_token('MEMBER_NAME', l_member_name);
2151: fnd_message.set_token('NOTE', l_member_note);
2152: l_temp_message := fnd_message.get;
2153: ELSE

Line 2150: fnd_message.set_token('MEMBER_NAME', l_member_name);

2146: fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_BODY');
2147: ELSE
2148: IF l_member_note IS NOT NULL THEN
2149: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');
2150: fnd_message.set_token('MEMBER_NAME', l_member_name);
2151: fnd_message.set_token('NOTE', l_member_note);
2152: l_temp_message := fnd_message.get;
2153: ELSE
2154: l_temp_message := NULL;

Line 2151: fnd_message.set_token('NOTE', l_member_note);

2147: ELSE
2148: IF l_member_note IS NOT NULL THEN
2149: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');
2150: fnd_message.set_token('MEMBER_NAME', l_member_name);
2151: fnd_message.set_token('NOTE', l_member_note);
2152: l_temp_message := fnd_message.get;
2153: ELSE
2154: l_temp_message := NULL;
2155: END IF;

Line 2152: l_temp_message := fnd_message.get;

2148: IF l_member_note IS NOT NULL THEN
2149: fnd_message.set_name('EGO', 'EGO_GROUPMEM_COMMENTS_HTM');
2150: fnd_message.set_token('MEMBER_NAME', l_member_name);
2151: fnd_message.set_token('NOTE', l_member_note);
2152: l_temp_message := fnd_message.get;
2153: ELSE
2154: l_temp_message := NULL;
2155: END IF;
2156: fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_HTM_BODY');

Line 2156: fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_HTM_BODY');

2152: l_temp_message := fnd_message.get;
2153: ELSE
2154: l_temp_message := NULL;
2155: END IF;
2156: fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_HTM_BODY');
2157: END IF;
2158:
2159: fnd_message.set_token('MEMBER_NAME', l_member_name);
2160: fnd_message.set_token('GROUP_NAME', l_group_name);

Line 2159: fnd_message.set_token('MEMBER_NAME', l_member_name);

2155: END IF;
2156: fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_HTM_BODY');
2157: END IF;
2158:
2159: fnd_message.set_token('MEMBER_NAME', l_member_name);
2160: fnd_message.set_token('GROUP_NAME', l_group_name);
2161: fnd_message.set_token('GROUP_MEM_COMMENTS', l_temp_message);
2162:
2163: document:=fnd_message.get;

Line 2160: fnd_message.set_token('GROUP_NAME', l_group_name);

2156: fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_FYI_HTM_BODY');
2157: END IF;
2158:
2159: fnd_message.set_token('MEMBER_NAME', l_member_name);
2160: fnd_message.set_token('GROUP_NAME', l_group_name);
2161: fnd_message.set_token('GROUP_MEM_COMMENTS', l_temp_message);
2162:
2163: document:=fnd_message.get;
2164: document_type := display_type;

Line 2161: fnd_message.set_token('GROUP_MEM_COMMENTS', l_temp_message);

2157: END IF;
2158:
2159: fnd_message.set_token('MEMBER_NAME', l_member_name);
2160: fnd_message.set_token('GROUP_NAME', l_group_name);
2161: fnd_message.set_token('GROUP_MEM_COMMENTS', l_temp_message);
2162:
2163: document:=fnd_message.get;
2164: document_type := display_type;
2165:

Line 2163: document:=fnd_message.get;

2159: fnd_message.set_token('MEMBER_NAME', l_member_name);
2160: fnd_message.set_token('GROUP_NAME', l_group_name);
2161: fnd_message.set_token('GROUP_MEM_COMMENTS', l_temp_message);
2162:
2163: document:=fnd_message.get;
2164: document_type := display_type;
2165:
2166: EXCEPTION
2167: WHEN OTHERS THEN

Line 2226: fnd_message.set_name('EGO', 'EGO_UNSUBSCR_GRPMEM_CONF_BODY');

2222: itemkey => l_item_key,
2223: aname => G_MEMBER_ID);
2224: l_mail_pref := get_mail_pref(l_member_id);
2225: IF (l_mail_pref = 'MAILTEXT') THEN
2226: fnd_message.set_name('EGO', 'EGO_UNSUBSCR_GRPMEM_CONF_BODY');
2227: ELSE
2228: fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_CNF_HTM_BODY');
2229: END IF;
2230:

Line 2228: fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_CNF_HTM_BODY');

2224: l_mail_pref := get_mail_pref(l_member_id);
2225: IF (l_mail_pref = 'MAILTEXT') THEN
2226: fnd_message.set_name('EGO', 'EGO_UNSUBSCR_GRPMEM_CONF_BODY');
2227: ELSE
2228: fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_CNF_HTM_BODY');
2229: END IF;
2230:
2231: fnd_message.set_token('GROUP_NAME', l_group_name);
2232:

Line 2231: fnd_message.set_token('GROUP_NAME', l_group_name);

2227: ELSE
2228: fnd_message.set_name('EGO', 'EGO_UNSUB_GRPMEM_CNF_HTM_BODY');
2229: END IF;
2230:
2231: fnd_message.set_token('GROUP_NAME', l_group_name);
2232:
2233: document:=fnd_message.get;
2234: document_type := display_type;
2235:

Line 2233: document:=fnd_message.get;

2229: END IF;
2230:
2231: fnd_message.set_token('GROUP_NAME', l_group_name);
2232:
2233: document:=fnd_message.get;
2234: document_type := display_type;
2235:
2236: EXCEPTION
2237: WHEN OTHERS THEN

Line 2299: fnd_message.set_name('EGO', 'EGO_GROUP_ADMIN_COMMENTS');

2295: itemkey => l_item_key,
2296: aname => G_MEMBER_NOTE);
2297:
2298: IF l_deletion_note IS NOT NULL THEN
2299: fnd_message.set_name('EGO', 'EGO_GROUP_ADMIN_COMMENTS');
2300: fnd_message.set_token('NOTE', l_deletion_note);
2301: l_temp_message := fnd_message.get;
2302: ELSE
2303: l_temp_message := NULL;

Line 2300: fnd_message.set_token('NOTE', l_deletion_note);

2296: aname => G_MEMBER_NOTE);
2297:
2298: IF l_deletion_note IS NOT NULL THEN
2299: fnd_message.set_name('EGO', 'EGO_GROUP_ADMIN_COMMENTS');
2300: fnd_message.set_token('NOTE', l_deletion_note);
2301: l_temp_message := fnd_message.get;
2302: ELSE
2303: l_temp_message := NULL;
2304: END IF;

Line 2301: l_temp_message := fnd_message.get;

2297:
2298: IF l_deletion_note IS NOT NULL THEN
2299: fnd_message.set_name('EGO', 'EGO_GROUP_ADMIN_COMMENTS');
2300: fnd_message.set_token('NOTE', l_deletion_note);
2301: l_temp_message := fnd_message.get;
2302: ELSE
2303: l_temp_message := NULL;
2304: END IF;
2305:

Line 2311: fnd_message.set_name('EGO', 'EGO_GROUP_DEL_OWN_NOTF_BODY');

2307: itemkey => l_item_key,
2308: aname => G_MEMBER_ID);
2309: l_mail_pref := get_mail_pref(l_member_id);
2310: IF (l_mail_pref = 'MAILTEXT') THEN
2311: fnd_message.set_name('EGO', 'EGO_GROUP_DEL_OWN_NOTF_BODY');
2312: ELSE
2313: fnd_message.set_name('EGO', 'EGO_DEL_GROUPOWN_CNF_HTM_BODY');
2314: END IF;
2315: fnd_message.set_token('GROUP_NAME', l_group_name);

Line 2313: fnd_message.set_name('EGO', 'EGO_DEL_GROUPOWN_CNF_HTM_BODY');

2309: l_mail_pref := get_mail_pref(l_member_id);
2310: IF (l_mail_pref = 'MAILTEXT') THEN
2311: fnd_message.set_name('EGO', 'EGO_GROUP_DEL_OWN_NOTF_BODY');
2312: ELSE
2313: fnd_message.set_name('EGO', 'EGO_DEL_GROUPOWN_CNF_HTM_BODY');
2314: END IF;
2315: fnd_message.set_token('GROUP_NAME', l_group_name);
2316: fnd_message.set_token('GROUP_ADMIN_COMMENTS', l_temp_message);
2317:

Line 2315: fnd_message.set_token('GROUP_NAME', l_group_name);

2311: fnd_message.set_name('EGO', 'EGO_GROUP_DEL_OWN_NOTF_BODY');
2312: ELSE
2313: fnd_message.set_name('EGO', 'EGO_DEL_GROUPOWN_CNF_HTM_BODY');
2314: END IF;
2315: fnd_message.set_token('GROUP_NAME', l_group_name);
2316: fnd_message.set_token('GROUP_ADMIN_COMMENTS', l_temp_message);
2317:
2318: document:= fnd_message.get;
2319: document_type := display_type;

Line 2316: fnd_message.set_token('GROUP_ADMIN_COMMENTS', l_temp_message);

2312: ELSE
2313: fnd_message.set_name('EGO', 'EGO_DEL_GROUPOWN_CNF_HTM_BODY');
2314: END IF;
2315: fnd_message.set_token('GROUP_NAME', l_group_name);
2316: fnd_message.set_token('GROUP_ADMIN_COMMENTS', l_temp_message);
2317:
2318: document:= fnd_message.get;
2319: document_type := display_type;
2320:

Line 2318: document:= fnd_message.get;

2314: END IF;
2315: fnd_message.set_token('GROUP_NAME', l_group_name);
2316: fnd_message.set_token('GROUP_ADMIN_COMMENTS', l_temp_message);
2317:
2318: document:= fnd_message.get;
2319: document_type := display_type;
2320:
2321: EXCEPTION
2322: WHEN OTHERS THEN

Line 2384: fnd_message.set_name('EGO', 'EGO_GROUP_ADMIN_COMMENTS');

2380: itemkey => l_item_key,
2381: aname => G_MEMBER_NOTE);
2382:
2383: IF l_deletion_note IS NOT NULL THEN
2384: fnd_message.set_name('EGO', 'EGO_GROUP_ADMIN_COMMENTS');
2385: fnd_message.set_token('NOTE', l_deletion_note);
2386: l_temp_message := fnd_message.get;
2387: ELSE
2388: l_temp_message := NULL;

Line 2385: fnd_message.set_token('NOTE', l_deletion_note);

2381: aname => G_MEMBER_NOTE);
2382:
2383: IF l_deletion_note IS NOT NULL THEN
2384: fnd_message.set_name('EGO', 'EGO_GROUP_ADMIN_COMMENTS');
2385: fnd_message.set_token('NOTE', l_deletion_note);
2386: l_temp_message := fnd_message.get;
2387: ELSE
2388: l_temp_message := NULL;
2389: END IF;

Line 2386: l_temp_message := fnd_message.get;

2382:
2383: IF l_deletion_note IS NOT NULL THEN
2384: fnd_message.set_name('EGO', 'EGO_GROUP_ADMIN_COMMENTS');
2385: fnd_message.set_token('NOTE', l_deletion_note);
2386: l_temp_message := fnd_message.get;
2387: ELSE
2388: l_temp_message := NULL;
2389: END IF;
2390:

Line 2396: fnd_message.set_name('EGO', 'EGO_GROUP_DEL_MEM_NOTF_BODY');

2392: itemkey => l_item_key,
2393: aname => G_MEMBER_ID);
2394: l_mail_pref := get_mail_pref(l_member_id);
2395: IF (l_mail_pref = 'MAILTEXT') THEN
2396: fnd_message.set_name('EGO', 'EGO_GROUP_DEL_MEM_NOTF_BODY');
2397: ELSE
2398: fnd_message.set_name('EGO', 'EGO_DEL_GROUPMEM_CNF_HTM_BODY');
2399: END IF;
2400:

Line 2398: fnd_message.set_name('EGO', 'EGO_DEL_GROUPMEM_CNF_HTM_BODY');

2394: l_mail_pref := get_mail_pref(l_member_id);
2395: IF (l_mail_pref = 'MAILTEXT') THEN
2396: fnd_message.set_name('EGO', 'EGO_GROUP_DEL_MEM_NOTF_BODY');
2397: ELSE
2398: fnd_message.set_name('EGO', 'EGO_DEL_GROUPMEM_CNF_HTM_BODY');
2399: END IF;
2400:
2401: fnd_message.set_token('GROUP_NAME', l_group_name);
2402: fnd_message.set_token('GROUP_ADMIN_COMMENTS', l_temp_message);

Line 2401: fnd_message.set_token('GROUP_NAME', l_group_name);

2397: ELSE
2398: fnd_message.set_name('EGO', 'EGO_DEL_GROUPMEM_CNF_HTM_BODY');
2399: END IF;
2400:
2401: fnd_message.set_token('GROUP_NAME', l_group_name);
2402: fnd_message.set_token('GROUP_ADMIN_COMMENTS', l_temp_message);
2403:
2404: document:= fnd_message.get;
2405: document_type := display_type;

Line 2402: fnd_message.set_token('GROUP_ADMIN_COMMENTS', l_temp_message);

2398: fnd_message.set_name('EGO', 'EGO_DEL_GROUPMEM_CNF_HTM_BODY');
2399: END IF;
2400:
2401: fnd_message.set_token('GROUP_NAME', l_group_name);
2402: fnd_message.set_token('GROUP_ADMIN_COMMENTS', l_temp_message);
2403:
2404: document:= fnd_message.get;
2405: document_type := display_type;
2406:

Line 2404: document:= fnd_message.get;

2400:
2401: fnd_message.set_token('GROUP_NAME', l_group_name);
2402: fnd_message.set_token('GROUP_ADMIN_COMMENTS', l_temp_message);
2403:
2404: document:= fnd_message.get;
2405: document_type := display_type;
2406:
2407: EXCEPTION
2408: WHEN OTHERS THEN

Line 2565: fnd_message.set_name('EGO', 'EGO_GROUP_APPROVER_LIST_NAME');

2561: l_role_name := G_GROUP_OBJECT_NAME || itemkey ;
2562: l_group_name := wf_engine.GetItemAttrText( itemtype => itemtype,
2563: itemkey => itemkey,
2564: aname => G_GROUP_NAME);
2565: fnd_message.set_name('EGO', 'EGO_GROUP_APPROVER_LIST_NAME');
2566: fnd_message.set_token('GROUP_NAME', l_group_name);
2567: l_role_display_name := fnd_message.get;
2568: --
2569: -- set notification username

Line 2566: fnd_message.set_token('GROUP_NAME', l_group_name);

2562: l_group_name := wf_engine.GetItemAttrText( itemtype => itemtype,
2563: itemkey => itemkey,
2564: aname => G_GROUP_NAME);
2565: fnd_message.set_name('EGO', 'EGO_GROUP_APPROVER_LIST_NAME');
2566: fnd_message.set_token('GROUP_NAME', l_group_name);
2567: l_role_display_name := fnd_message.get;
2568: --
2569: -- set notification username
2570: --

Line 2567: l_role_display_name := fnd_message.get;

2563: itemkey => itemkey,
2564: aname => G_GROUP_NAME);
2565: fnd_message.set_name('EGO', 'EGO_GROUP_APPROVER_LIST_NAME');
2566: fnd_message.set_token('GROUP_NAME', l_group_name);
2567: l_role_display_name := fnd_message.get;
2568: --
2569: -- set notification username
2570: --
2571: wf_engine.SetItemAttrText (itemtype => itemtype,