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
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,
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,
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
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,
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,
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/'
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: --
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
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..
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,
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',
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
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,
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,
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/'
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: --
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
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);
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,
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,
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*********
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
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,
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,
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);
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,
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
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;
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;
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');
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);
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
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;
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;
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');
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);
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
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,
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,
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:
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**********
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,
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,
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/'
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: --
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: --
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,
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:
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,
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',
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:
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
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;
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;
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');
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');
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
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;
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;
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');
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);
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:
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;
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:
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
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:
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:
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);
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
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);
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:
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
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:
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);
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;
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:
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
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
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;
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;
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');
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);
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
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;
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;
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');
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);
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;
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;
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:
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
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:
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:
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:
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
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;
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;
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:
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);
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:
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;
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:
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
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;
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;
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:
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:
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);
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;
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:
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
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
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: --
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,