161: --from_name := 'Chhabra, Deepjot';
162: --to_role := 'SATISH';
163: --to_name := 'Ramasamy, Satish';
164:
165: ln_notification_id := wf_notification.send(role => to_role,
166: msg_type => 'HRWPM' ,
167: msg_name => 'HR_WPM_GENERIC_NTF_MSG',
168: callback => null,
169: context => null,
201: end if;
202:
203: lv_subject := fnd_message.get;
204:
205: wf_notification.setattrtext(ln_notification_id,'#FROM_ROLE',from_role);
206: wf_notification.setattrtext(ln_notification_id,'HR_WPM_GENERIC_SUBJECT',lv_subject);
207: wf_notification.setattrtext(ln_notification_id,'#WFM_FROM', from_name);
208: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_ID', score_card_id);
209: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_REASON', reason);
202:
203: lv_subject := fnd_message.get;
204:
205: wf_notification.setattrtext(ln_notification_id,'#FROM_ROLE',from_role);
206: wf_notification.setattrtext(ln_notification_id,'HR_WPM_GENERIC_SUBJECT',lv_subject);
207: wf_notification.setattrtext(ln_notification_id,'#WFM_FROM', from_name);
208: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_ID', score_card_id);
209: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_REASON', reason);
210: wf_notification.setattrtext(ln_notification_id,'WHICH_NTF', to_or_from_mgr_ntf);
203: lv_subject := fnd_message.get;
204:
205: wf_notification.setattrtext(ln_notification_id,'#FROM_ROLE',from_role);
206: wf_notification.setattrtext(ln_notification_id,'HR_WPM_GENERIC_SUBJECT',lv_subject);
207: wf_notification.setattrtext(ln_notification_id,'#WFM_FROM', from_name);
208: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_ID', score_card_id);
209: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_REASON', reason);
210: wf_notification.setattrtext(ln_notification_id,'WHICH_NTF', to_or_from_mgr_ntf);
211: wf_notification.setattrtext(ln_notification_id,'HR_FROM_WF', 'WF');
204:
205: wf_notification.setattrtext(ln_notification_id,'#FROM_ROLE',from_role);
206: wf_notification.setattrtext(ln_notification_id,'HR_WPM_GENERIC_SUBJECT',lv_subject);
207: wf_notification.setattrtext(ln_notification_id,'#WFM_FROM', from_name);
208: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_ID', score_card_id);
209: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_REASON', reason);
210: wf_notification.setattrtext(ln_notification_id,'WHICH_NTF', to_or_from_mgr_ntf);
211: wf_notification.setattrtext(ln_notification_id,'HR_FROM_WF', 'WF');
212: wf_notification.setattrtext(ln_notification_id,'HR_PLAN_ID', l_sc_info.plan_id);
205: wf_notification.setattrtext(ln_notification_id,'#FROM_ROLE',from_role);
206: wf_notification.setattrtext(ln_notification_id,'HR_WPM_GENERIC_SUBJECT',lv_subject);
207: wf_notification.setattrtext(ln_notification_id,'#WFM_FROM', from_name);
208: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_ID', score_card_id);
209: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_REASON', reason);
210: wf_notification.setattrtext(ln_notification_id,'WHICH_NTF', to_or_from_mgr_ntf);
211: wf_notification.setattrtext(ln_notification_id,'HR_FROM_WF', 'WF');
212: wf_notification.setattrtext(ln_notification_id,'HR_PLAN_ID', l_sc_info.plan_id);
213: wf_notification.setattrtext(ln_notification_id,'HR_ACTION_TYPE', to_or_from_mgr_ntf);
206: wf_notification.setattrtext(ln_notification_id,'HR_WPM_GENERIC_SUBJECT',lv_subject);
207: wf_notification.setattrtext(ln_notification_id,'#WFM_FROM', from_name);
208: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_ID', score_card_id);
209: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_REASON', reason);
210: wf_notification.setattrtext(ln_notification_id,'WHICH_NTF', to_or_from_mgr_ntf);
211: wf_notification.setattrtext(ln_notification_id,'HR_FROM_WF', 'WF');
212: wf_notification.setattrtext(ln_notification_id,'HR_PLAN_ID', l_sc_info.plan_id);
213: wf_notification.setattrtext(ln_notification_id,'HR_ACTION_TYPE', to_or_from_mgr_ntf);
214:
207: wf_notification.setattrtext(ln_notification_id,'#WFM_FROM', from_name);
208: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_ID', score_card_id);
209: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_REASON', reason);
210: wf_notification.setattrtext(ln_notification_id,'WHICH_NTF', to_or_from_mgr_ntf);
211: wf_notification.setattrtext(ln_notification_id,'HR_FROM_WF', 'WF');
212: wf_notification.setattrtext(ln_notification_id,'HR_PLAN_ID', l_sc_info.plan_id);
213: wf_notification.setattrtext(ln_notification_id,'HR_ACTION_TYPE', to_or_from_mgr_ntf);
214:
215:
208: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_ID', score_card_id);
209: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_REASON', reason);
210: wf_notification.setattrtext(ln_notification_id,'WHICH_NTF', to_or_from_mgr_ntf);
211: wf_notification.setattrtext(ln_notification_id,'HR_FROM_WF', 'WF');
212: wf_notification.setattrtext(ln_notification_id,'HR_PLAN_ID', l_sc_info.plan_id);
213: wf_notification.setattrtext(ln_notification_id,'HR_ACTION_TYPE', to_or_from_mgr_ntf);
214:
215:
216: return SUCCESS;
209: wf_notification.setattrtext(ln_notification_id,'HR_WPM_SC_REASON', reason);
210: wf_notification.setattrtext(ln_notification_id,'WHICH_NTF', to_or_from_mgr_ntf);
211: wf_notification.setattrtext(ln_notification_id,'HR_FROM_WF', 'WF');
212: wf_notification.setattrtext(ln_notification_id,'HR_PLAN_ID', l_sc_info.plan_id);
213: wf_notification.setattrtext(ln_notification_id,'HR_ACTION_TYPE', to_or_from_mgr_ntf);
214:
215:
216: return SUCCESS;
217: