811: itemkey => l_item_key,
812: userkey => l_item_key);
813: wf_engine.SetItemOwner (itemtype => l_item_type,
814: itemkey => l_item_key,
815: owner => fnd_global.user_name);
816: -- Set global attributes
817: wf_engine.SetItemAttrNumber (itemtype => l_item_type,
818: itemkey => l_item_key,
819: aname => 'OKCDELID',
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',
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));
984: FND_FILE.PUT_LINE(FND_FILE.LOG,'Notifier returning status: '||x_return_status);
985:
1217: l_new_status,
1218: sysdate,
1219: l_notes,
1220: 1,
1221: fnd_global.user_id,
1222: sysdate,
1223: fnd_global.user_id,
1224: sysdate,
1225: fnd_global.login_id,
1219: l_notes,
1220: 1,
1221: fnd_global.user_id,
1222: sysdate,
1223: fnd_global.user_id,
1224: sysdate,
1225: fnd_global.login_id,
1226: fnd_global.user_id);
1227: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1221: fnd_global.user_id,
1222: sysdate,
1223: fnd_global.user_id,
1224: sysdate,
1225: fnd_global.login_id,
1226: fnd_global.user_id);
1227: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1228: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module,'200: Deliverable updated and row inserted into status history');
1229: end if;
1222: sysdate,
1223: fnd_global.user_id,
1224: sysdate,
1225: fnd_global.login_id,
1226: fnd_global.user_id);
1227: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1228: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module,'200: Deliverable updated and row inserted into status history');
1229: end if;
1230: