295:
296: begin
297:
298: if ( requrl is not NULL ) then
299: wf_notification.setattrtext(nid, 'REQ_URL', requrl);
300: end if;
301:
302: wf_notification.setattrnumber(nid, 'REQID', req_id);
303: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
298: if ( requrl is not NULL ) then
299: wf_notification.setattrtext(nid, 'REQ_URL', requrl);
300: end if;
301:
302: wf_notification.setattrnumber(nid, 'REQID', req_id);
303: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
304: wf_notification.setattrtext(nid, 'PROGNAME', pname);
305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);
299: wf_notification.setattrtext(nid, 'REQ_URL', requrl);
300: end if;
301:
302: wf_notification.setattrnumber(nid, 'REQID', req_id);
303: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
304: wf_notification.setattrtext(nid, 'PROGNAME', pname);
305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);
300: end if;
301:
302: wf_notification.setattrnumber(nid, 'REQID', req_id);
303: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
304: wf_notification.setattrtext(nid, 'PROGNAME', pname);
305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);
308: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
301:
302: wf_notification.setattrnumber(nid, 'REQID', req_id);
303: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
304: wf_notification.setattrtext(nid, 'PROGNAME', pname);
305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);
308: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
309: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
302: wf_notification.setattrnumber(nid, 'REQID', req_id);
303: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
304: wf_notification.setattrtext(nid, 'PROGNAME', pname);
305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);
308: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
309: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
310: wf_notification.denormalize_notification(nid);
303: wf_notification.setattrtext(nid, 'STAT', RTRIM(stat));
304: wf_notification.setattrtext(nid, 'PROGNAME', pname);
305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);
308: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
309: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
310: wf_notification.denormalize_notification(nid);
311: exception
304: wf_notification.setattrtext(nid, 'PROGNAME', pname);
305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);
308: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
309: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
310: wf_notification.denormalize_notification(nid);
311: exception
312: when others then
305: wf_notification.setattrdate(nid, 'TIME', completion);
306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);
308: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
309: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
310: wf_notification.denormalize_notification(nid);
311: exception
312: when others then
313: raise wf_error;
306: wf_notification.setattrdate(nid, 'DATE', completion);
307: wf_notification.setattrtext(nid, 'SUBMITTER', user);
308: wf_notification.setattrtext(nid, '#FROM_ROLE', user);
309: wf_notification.setattrtext(nid, '#WFM_REPLYTO', e_addr);
310: wf_notification.denormalize_notification(nid);
311: exception
312: when others then
313: raise wf_error;
314: end;
344: notify_id number;
345:
346: cursor nids_cursor is
347: select notification_id
348: from wf_notifications
349: where group_id = nid;
350: -- code for bug 4172657 ends
351:
352: begin
403: fnd_profile.get('CONC_NOTIFY_GROUP', profbuf);
404:
405: begin
406: if profbuf = 'Y' then
407: nid := wf_notification.sendgroup(recip, msgtype, msgname);
408: open nids_cursor;
409: LOOP
410: fetch nids_cursor into notify_id;
411: -- Get a unique file name each time
420: end LOOP;
421:
422: close nids_cursor;
423: else
424: nid := wf_notification.send(recip, msgtype, msgname);
425:
426: -- Get a unique file name each time
427: if (send_url) then
428: requrl := fnd_webfile.get_url( fnd_webfile.request_out,