157: end;
158:
159:
160:
161: ln_notification_id := wf_notification.send(role => lv_role_name,
162: msg_type => 'HRVERF' ,
163: msg_name => 'HR_ACCESS_KEY_MSG',
164: callback => null,
165: context => null,
170: fnd_message.set_token('EMPL_NAME',emp_name,false);
171: lv_subject := fnd_message.get;
172:
173:
174: wf_notification.setattrtext(ln_notification_id,'EXT_URL',access_url);
175: wf_notification.setattrtext(ln_notification_id,'EXP_DAYS',access_days);
176: wf_notification.setattrtext(ln_notification_id,'ACCESS_TIMES',access_limit);
177: wf_notification.setattrtext(ln_notification_id,'#FROM_ROLE',login_user_name);
178: wf_notification.setattrtext(ln_notification_id,'EMP_NAME',lv_subject);
171: lv_subject := fnd_message.get;
172:
173:
174: wf_notification.setattrtext(ln_notification_id,'EXT_URL',access_url);
175: wf_notification.setattrtext(ln_notification_id,'EXP_DAYS',access_days);
176: wf_notification.setattrtext(ln_notification_id,'ACCESS_TIMES',access_limit);
177: wf_notification.setattrtext(ln_notification_id,'#FROM_ROLE',login_user_name);
178: wf_notification.setattrtext(ln_notification_id,'EMP_NAME',lv_subject);
179: wf_notification.setattrtext(ln_notification_id,'REPLY_TO','mailto:' ||reply_to_address);
172:
173:
174: wf_notification.setattrtext(ln_notification_id,'EXT_URL',access_url);
175: wf_notification.setattrtext(ln_notification_id,'EXP_DAYS',access_days);
176: wf_notification.setattrtext(ln_notification_id,'ACCESS_TIMES',access_limit);
177: wf_notification.setattrtext(ln_notification_id,'#FROM_ROLE',login_user_name);
178: wf_notification.setattrtext(ln_notification_id,'EMP_NAME',lv_subject);
179: wf_notification.setattrtext(ln_notification_id,'REPLY_TO','mailto:' ||reply_to_address);
180: wf_notification.setattrtext(ln_notification_id,'#WFM_FROM', emp_name);
173:
174: wf_notification.setattrtext(ln_notification_id,'EXT_URL',access_url);
175: wf_notification.setattrtext(ln_notification_id,'EXP_DAYS',access_days);
176: wf_notification.setattrtext(ln_notification_id,'ACCESS_TIMES',access_limit);
177: wf_notification.setattrtext(ln_notification_id,'#FROM_ROLE',login_user_name);
178: wf_notification.setattrtext(ln_notification_id,'EMP_NAME',lv_subject);
179: wf_notification.setattrtext(ln_notification_id,'REPLY_TO','mailto:' ||reply_to_address);
180: wf_notification.setattrtext(ln_notification_id,'#WFM_FROM', emp_name);
181: wf_notification.setattrtext(ln_notification_id,'#WFM_REPLYTO',reply_to_address);
174: wf_notification.setattrtext(ln_notification_id,'EXT_URL',access_url);
175: wf_notification.setattrtext(ln_notification_id,'EXP_DAYS',access_days);
176: wf_notification.setattrtext(ln_notification_id,'ACCESS_TIMES',access_limit);
177: wf_notification.setattrtext(ln_notification_id,'#FROM_ROLE',login_user_name);
178: wf_notification.setattrtext(ln_notification_id,'EMP_NAME',lv_subject);
179: wf_notification.setattrtext(ln_notification_id,'REPLY_TO','mailto:' ||reply_to_address);
180: wf_notification.setattrtext(ln_notification_id,'#WFM_FROM', emp_name);
181: wf_notification.setattrtext(ln_notification_id,'#WFM_REPLYTO',reply_to_address);
182: wf_notification.setattrtext(ln_notification_id,'COMMENTS',comments);
175: wf_notification.setattrtext(ln_notification_id,'EXP_DAYS',access_days);
176: wf_notification.setattrtext(ln_notification_id,'ACCESS_TIMES',access_limit);
177: wf_notification.setattrtext(ln_notification_id,'#FROM_ROLE',login_user_name);
178: wf_notification.setattrtext(ln_notification_id,'EMP_NAME',lv_subject);
179: wf_notification.setattrtext(ln_notification_id,'REPLY_TO','mailto:' ||reply_to_address);
180: wf_notification.setattrtext(ln_notification_id,'#WFM_FROM', emp_name);
181: wf_notification.setattrtext(ln_notification_id,'#WFM_REPLYTO',reply_to_address);
182: wf_notification.setattrtext(ln_notification_id,'COMMENTS',comments);
183:
176: wf_notification.setattrtext(ln_notification_id,'ACCESS_TIMES',access_limit);
177: wf_notification.setattrtext(ln_notification_id,'#FROM_ROLE',login_user_name);
178: wf_notification.setattrtext(ln_notification_id,'EMP_NAME',lv_subject);
179: wf_notification.setattrtext(ln_notification_id,'REPLY_TO','mailto:' ||reply_to_address);
180: wf_notification.setattrtext(ln_notification_id,'#WFM_FROM', emp_name);
181: wf_notification.setattrtext(ln_notification_id,'#WFM_REPLYTO',reply_to_address);
182: wf_notification.setattrtext(ln_notification_id,'COMMENTS',comments);
183:
184:
177: wf_notification.setattrtext(ln_notification_id,'#FROM_ROLE',login_user_name);
178: wf_notification.setattrtext(ln_notification_id,'EMP_NAME',lv_subject);
179: wf_notification.setattrtext(ln_notification_id,'REPLY_TO','mailto:' ||reply_to_address);
180: wf_notification.setattrtext(ln_notification_id,'#WFM_FROM', emp_name);
181: wf_notification.setattrtext(ln_notification_id,'#WFM_REPLYTO',reply_to_address);
182: wf_notification.setattrtext(ln_notification_id,'COMMENTS',comments);
183:
184:
185:
178: wf_notification.setattrtext(ln_notification_id,'EMP_NAME',lv_subject);
179: wf_notification.setattrtext(ln_notification_id,'REPLY_TO','mailto:' ||reply_to_address);
180: wf_notification.setattrtext(ln_notification_id,'#WFM_FROM', emp_name);
181: wf_notification.setattrtext(ln_notification_id,'#WFM_REPLYTO',reply_to_address);
182: wf_notification.setattrtext(ln_notification_id,'COMMENTS',comments);
183:
184:
185:
186: EXCEPTION WHEN OTHERS THEN