1104: l_error_msg := x_msg_data;
1105:
1106: -- send notification to the logged in user that workflow notification
1107: -- could not be sent
1108: x_notification_id := WF_NOTIFICATION.Send(role => fnd_global.user_name,
1109: msg_type => 'OKCDELWF',
1110: msg_name => 'OKCDELFAILEDTOSENDMSG');
1111: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
1112: aname=>'DELIVERABLENAME',
1107: -- could not be sent
1108: x_notification_id := WF_NOTIFICATION.Send(role => fnd_global.user_name,
1109: msg_type => 'OKCDELWF',
1110: msg_name => 'OKCDELFAILEDTOSENDMSG');
1111: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
1112: aname=>'DELIVERABLENAME',
1113: avalue=>p_deliverable_name);
1114: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
1115: aname=>'SUBJECT',
1110: msg_name => 'OKCDELFAILEDTOSENDMSG');
1111: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
1112: aname=>'DELIVERABLENAME',
1113: avalue=>p_deliverable_name);
1114: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
1115: aname=>'SUBJECT',
1116: avalue=>l_subject_text);
1117: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
1118: aname=>'ERRORMSG',
1113: avalue=>p_deliverable_name);
1114: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
1115: aname=>'SUBJECT',
1116: avalue=>l_subject_text);
1117: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
1118: aname=>'ERRORMSG',
1119: avalue=>l_error_msg);
1120: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
1121: aname=>'#FROM_ROLE',
1116: avalue=>l_subject_text);
1117: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
1118: aname=>'ERRORMSG',
1119: avalue=>l_error_msg);
1120: WF_NOTIFICATION.SetAttrText(nid=>x_notification_id,
1121: aname=>'#FROM_ROLE',
1122: avalue=> fnd_global.user_name);
1123:
1124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error notification Id: '||to_char(x_notification_id));
1597:
1598:
1599: