674: msg_name := 'HR_APPRAISAL_FEEDBACK_MSG';
675: END IF;
676:
677: ln_notification_id :=
678: wf_notification.send (ROLE => to_role,
679: msg_type => 'HRSSA',
680: msg_name => msg_name,
681: callback => NULL,
682: CONTEXT => NULL,
683: send_comment => NULL,
684: priority => 50
685: );
686:
687: wf_notification.setattrtext (ln_notification_id, '#FROM_ROLE', from_role);
688: wf_notification.setattrtext (ln_notification_id, 'HRPROFNAME', from_name);
689: wf_notification.setattrtext (ln_notification_id, 'APPROVAL_COMMENT', p_comment);
690:
691: IF msg_name = 'HR_APPRAISAL_MACHANGE_MSG' THEN
684: priority => 50
685: );
686:
687: wf_notification.setattrtext (ln_notification_id, '#FROM_ROLE', from_role);
688: wf_notification.setattrtext (ln_notification_id, 'HRPROFNAME', from_name);
689: wf_notification.setattrtext (ln_notification_id, 'APPROVAL_COMMENT', p_comment);
690:
691: IF msg_name = 'HR_APPRAISAL_MACHANGE_MSG' THEN
692: msg_name := 'HR_APPRAISAL_MACHANGE_MGR_MSG';
685: );
686:
687: wf_notification.setattrtext (ln_notification_id, '#FROM_ROLE', from_role);
688: wf_notification.setattrtext (ln_notification_id, 'HRPROFNAME', from_name);
689: wf_notification.setattrtext (ln_notification_id, 'APPROVAL_COMMENT', p_comment);
690:
691: IF msg_name = 'HR_APPRAISAL_MACHANGE_MSG' THEN
692: msg_name := 'HR_APPRAISAL_MACHANGE_MGR_MSG';
693: ELSIF msg_name = 'HR_APPRAISAL_FEEDBACK_MSG' OR msg_name = 'HR_APPRAISAL_COMPLETE_MSG' THEN
706: CLOSE get_global_name;
707:
708:
709: ln_MAnotification_id :=
710: wf_notification.send (ROLE => to_role,
711: msg_type => 'HRSSA',
712: msg_name => msg_name,
713: callback => NULL,
714: CONTEXT => NULL,
715: send_comment => NULL,
716: priority => 50
717: );
718:
719: wf_notification.setattrtext (ln_MAnotification_id, '#FROM_ROLE', from_role);
720: wf_notification.setattrtext (ln_MAnotification_id, 'HRPROFNAME', from_name);
721: wf_notification.setattrtext (ln_MAnotification_id, 'APPROVAL_COMMENT', p_comment);
722: wf_notification.setattrtext (ln_MAnotification_id, 'APPRAISEE', appraisee_name);
723:
716: priority => 50
717: );
718:
719: wf_notification.setattrtext (ln_MAnotification_id, '#FROM_ROLE', from_role);
720: wf_notification.setattrtext (ln_MAnotification_id, 'HRPROFNAME', from_name);
721: wf_notification.setattrtext (ln_MAnotification_id, 'APPROVAL_COMMENT', p_comment);
722: wf_notification.setattrtext (ln_MAnotification_id, 'APPRAISEE', appraisee_name);
723:
724: wf_notification.denormalize_notification(ln_MAnotification_id);
717: );
718:
719: wf_notification.setattrtext (ln_MAnotification_id, '#FROM_ROLE', from_role);
720: wf_notification.setattrtext (ln_MAnotification_id, 'HRPROFNAME', from_name);
721: wf_notification.setattrtext (ln_MAnotification_id, 'APPROVAL_COMMENT', p_comment);
722: wf_notification.setattrtext (ln_MAnotification_id, 'APPRAISEE', appraisee_name);
723:
724: wf_notification.denormalize_notification(ln_MAnotification_id);
725:
718:
719: wf_notification.setattrtext (ln_MAnotification_id, '#FROM_ROLE', from_role);
720: wf_notification.setattrtext (ln_MAnotification_id, 'HRPROFNAME', from_name);
721: wf_notification.setattrtext (ln_MAnotification_id, 'APPROVAL_COMMENT', p_comment);
722: wf_notification.setattrtext (ln_MAnotification_id, 'APPRAISEE', appraisee_name);
723:
724: wf_notification.denormalize_notification(ln_MAnotification_id);
725:
726: Exception
720: wf_notification.setattrtext (ln_MAnotification_id, 'HRPROFNAME', from_name);
721: wf_notification.setattrtext (ln_MAnotification_id, 'APPROVAL_COMMENT', p_comment);
722: wf_notification.setattrtext (ln_MAnotification_id, 'APPRAISEE', appraisee_name);
723:
724: wf_notification.denormalize_notification(ln_MAnotification_id);
725:
726: Exception
727: when others then
728: raise;