186: mesg_name := hr_util_misc_web.return_msg_text(
187: p_message_name =>'HR_WPM_NTF_REQUEST_ACTION',
188: p_Application_id =>'PER');
189: end if;
190: fnd_message.set_name('PER','HR_WPM_GEN_MSG_MGR_TO_EMP');
191: fnd_message.set_token('MGR_NAME',from_name);
192: fnd_message.set_token('SCORECARD_NAME',l_sc_info.scorecard_name);
193: fnd_message.set_token('STATUS',mesg_name);
194:
187: p_message_name =>'HR_WPM_NTF_REQUEST_ACTION',
188: p_Application_id =>'PER');
189: end if;
190: fnd_message.set_name('PER','HR_WPM_GEN_MSG_MGR_TO_EMP');
191: fnd_message.set_token('MGR_NAME',from_name);
192: fnd_message.set_token('SCORECARD_NAME',l_sc_info.scorecard_name);
193: fnd_message.set_token('STATUS',mesg_name);
194:
195: tlnt_mgmt_rel_apps_fn := 'HR_WPM_MGR_REL_APPS_SS';
188: p_Application_id =>'PER');
189: end if;
190: fnd_message.set_name('PER','HR_WPM_GEN_MSG_MGR_TO_EMP');
191: fnd_message.set_token('MGR_NAME',from_name);
192: fnd_message.set_token('SCORECARD_NAME',l_sc_info.scorecard_name);
193: fnd_message.set_token('STATUS',mesg_name);
194:
195: tlnt_mgmt_rel_apps_fn := 'HR_WPM_MGR_REL_APPS_SS';
196: elsif ( to_or_from_mgr_ntf = 'EMP_TO_MGR' ) then
189: end if;
190: fnd_message.set_name('PER','HR_WPM_GEN_MSG_MGR_TO_EMP');
191: fnd_message.set_token('MGR_NAME',from_name);
192: fnd_message.set_token('SCORECARD_NAME',l_sc_info.scorecard_name);
193: fnd_message.set_token('STATUS',mesg_name);
194:
195: tlnt_mgmt_rel_apps_fn := 'HR_WPM_MGR_REL_APPS_SS';
196: elsif ( to_or_from_mgr_ntf = 'EMP_TO_MGR' ) then
197: fnd_message.set_name('PER','HR_WPM_GEN_MSF_EMP_TO_MGR');
193: fnd_message.set_token('STATUS',mesg_name);
194:
195: tlnt_mgmt_rel_apps_fn := 'HR_WPM_MGR_REL_APPS_SS';
196: elsif ( to_or_from_mgr_ntf = 'EMP_TO_MGR' ) then
197: fnd_message.set_name('PER','HR_WPM_GEN_MSF_EMP_TO_MGR');
198: fnd_message.set_token('EMP_NAME',from_name);
199: fnd_message.set_token('SCORECARD_NAME',l_sc_info.scorecard_name);
200: tlnt_mgmt_rel_apps_fn := 'HR_WPM_EMP_REL_APPS_SS';
201: end if;
194:
195: tlnt_mgmt_rel_apps_fn := 'HR_WPM_MGR_REL_APPS_SS';
196: elsif ( to_or_from_mgr_ntf = 'EMP_TO_MGR' ) then
197: fnd_message.set_name('PER','HR_WPM_GEN_MSF_EMP_TO_MGR');
198: fnd_message.set_token('EMP_NAME',from_name);
199: fnd_message.set_token('SCORECARD_NAME',l_sc_info.scorecard_name);
200: tlnt_mgmt_rel_apps_fn := 'HR_WPM_EMP_REL_APPS_SS';
201: end if;
202:
195: tlnt_mgmt_rel_apps_fn := 'HR_WPM_MGR_REL_APPS_SS';
196: elsif ( to_or_from_mgr_ntf = 'EMP_TO_MGR' ) then
197: fnd_message.set_name('PER','HR_WPM_GEN_MSF_EMP_TO_MGR');
198: fnd_message.set_token('EMP_NAME',from_name);
199: fnd_message.set_token('SCORECARD_NAME',l_sc_info.scorecard_name);
200: tlnt_mgmt_rel_apps_fn := 'HR_WPM_EMP_REL_APPS_SS';
201: end if;
202:
203: lv_subject := fnd_message.get;
199: fnd_message.set_token('SCORECARD_NAME',l_sc_info.scorecard_name);
200: tlnt_mgmt_rel_apps_fn := 'HR_WPM_EMP_REL_APPS_SS';
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);