963: l_error_msg := x_msg_data;
964:
965: -- send notification to the logged in user that workflow notification
966: -- could not be sent
967: x_notification_id := WF_NOTIFICATION.Send(role => fnd_global.user_name,
968: msg_type => 'OKCDELWF',
969: msg_name => 'OKCDELFAILEDTOSENDMSG');
970: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
971: aname=>'DELIVERABLENAME',
966: -- could not be sent
967: x_notification_id := WF_NOTIFICATION.Send(role => fnd_global.user_name,
968: msg_type => 'OKCDELWF',
969: msg_name => 'OKCDELFAILEDTOSENDMSG');
970: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
971: aname=>'DELIVERABLENAME',
972: avalue=>p_deliverable_name);
973: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
974: aname=>'SUBJECT',
969: msg_name => 'OKCDELFAILEDTOSENDMSG');
970: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
971: aname=>'DELIVERABLENAME',
972: avalue=>p_deliverable_name);
973: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
974: aname=>'SUBJECT',
975: avalue=>l_subject_text);
976: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
977: aname=>'ERRORMSG',
972: avalue=>p_deliverable_name);
973: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
974: aname=>'SUBJECT',
975: avalue=>l_subject_text);
976: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
977: aname=>'ERRORMSG',
978: avalue=>l_error_msg);
979: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
980: aname=>'#FROM_ROLE',
975: avalue=>l_subject_text);
976: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
977: aname=>'ERRORMSG',
978: avalue=>l_error_msg);
979: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
980: aname=>'#FROM_ROLE',
981: avalue=> fnd_global.user_name);
982:
983: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error notification Id: '||to_char(x_notification_id));