DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_WF_PVT dependencies on WF_ENGINE

Line 802: wf_engine.CreateProcess(itemtype => l_item_type,

798: l_process_name := 'OKCDELNOTIFYFYI';
799: end if;
800:
801: --Create the process
802: wf_engine.CreateProcess(itemtype => l_item_type,
803: itemkey => l_item_key,
804: process => l_process_name);
805: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
806: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'140: Creating process:'||l_item_type||':'

Line 810: wf_engine.SetItemUserKey (itemtype => l_item_type,

806: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'140: Creating process:'||l_item_type||':'
807: ||l_item_key||':'||l_process_name);
808: END IF;
809:
810: wf_engine.SetItemUserKey (itemtype => l_item_type,
811: itemkey => l_item_key,
812: userkey => l_item_key);
813: wf_engine.SetItemOwner (itemtype => l_item_type,
814: itemkey => l_item_key,

Line 813: wf_engine.SetItemOwner (itemtype => l_item_type,

809:
810: wf_engine.SetItemUserKey (itemtype => l_item_type,
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,

Line 817: wf_engine.SetItemAttrNumber (itemtype => l_item_type,

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',
820: avalue => p_deliverable_id);
821:

Line 822: wf_engine.SetItemAttrText (itemtype => l_item_type,

818: itemkey => l_item_key,
819: aname => 'OKCDELID',
820: avalue => p_deliverable_id);
821:
822: wf_engine.SetItemAttrText (itemtype => l_item_type,
823: itemkey => l_item_key,
824: aname => 'OKCDELINTUSERROLE',
825: avalue => l_internal_role_name);
826:

Line 827: wf_engine.SetItemAttrText (itemtype => l_item_type,

823: itemkey => l_item_key,
824: aname => 'OKCDELINTUSERROLE',
825: avalue => l_internal_role_name);
826:
827: wf_engine.SetItemAttrText (itemtype => l_item_type,
828: itemkey => l_item_key,
829: aname => 'OKCDELSUBJECT',
830: avalue => p_msg_code||':'||p_deliverable_id);
831:

Line 833: wf_engine.SetItemAttrText (itemtype => l_item_type,

829: aname => 'OKCDELSUBJECT',
830: avalue => p_msg_code||':'||p_deliverable_id);
831:
832: IF l_requester_role_name IS NOT NULL THEN
833: wf_engine.SetItemAttrText (itemtype => l_item_type,
834: itemkey => l_item_key,
835: aname => 'OKCDELREQUESTOR',
836: avalue => l_requester_role_name);
837:

Line 838: wf_engine.SetItemAttrText (itemtype => l_item_type,

834: itemkey => l_item_key,
835: aname => 'OKCDELREQUESTOR',
836: avalue => l_requester_role_name);
837:
838: wf_engine.SetItemAttrText (itemtype => l_item_type,
839: itemkey => l_item_key,
840: aname => 'OKCDELREQUESTEREXISTS',
841: avalue => 'Y');
842: END IF;

Line 844: wf_engine.SetItemAttrText (itemtype => l_item_type,

840: aname => 'OKCDELREQUESTEREXISTS',
841: avalue => 'Y');
842: END IF;
843:
844: wf_engine.SetItemAttrText (itemtype => l_item_type,
845: itemkey => l_item_key,
846: aname => 'OKCDELEXTUSERROLE',
847: avalue => l_external_role_name);
848:

Line 854: wf_engine.SetItemAttrText (itemtype => l_item_type,

850: ||l_header_function_name||'&documentHeaderId='
851: ||p_business_document_id||'&OKC_DOCUMENT_TYPE='||p_business_document_type
852: ||'&OKC_DOC_VER_NUM='||p_business_document_version
853: ||'&_MANAGE_MODE=Y&_UPDATE_STATUS_MODE=N&_HIDE_NTF=Y&OKC_DEL_HIDE_ATTACHMENTS=Y&OKC_DEL_HIDE_STATUS_DISC=Y&_FLEX_DISPLAY=N&_DELIVERABLE_ID='||p_deliverable_id||'&OKC_DEL_NO_ENCRYPT=Y';
854: wf_engine.SetItemAttrText (itemtype => l_item_type,
855: itemkey => l_item_key,
856: aname => 'OKCDELBUSDOCDETAILSRN',
857: avalue => l_ui_region);
858:

Line 863: wf_engine.SetItemAttrText (itemtype => l_item_type,

859: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
860: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'141: Setting workflow attributes.');
861: END IF;
862:
863: wf_engine.SetItemAttrText (itemtype => l_item_type,
864: itemkey => l_item_key,
865: aname => 'FROMROLE',
866: avalue => l_internal_role_name);
867:

Line 868: wf_engine.SetItemAttrText (itemtype => l_item_type,

864: itemkey => l_item_key,
865: aname => 'FROMROLE',
866: avalue => l_internal_role_name);
867:
868: wf_engine.SetItemAttrText (itemtype => l_item_type,
869: itemkey => l_item_key,
870: aname => 'OKCDELRESPPARTY',
871: avalue => l_resp_party_code);
872:

Line 873: wf_engine.StartProcess(itemtype => l_item_type,

869: itemkey => l_item_key,
870: aname => 'OKCDELRESPPARTY',
871: avalue => l_resp_party_code);
872:
873: wf_engine.StartProcess(itemtype => l_item_type,
874: itemkey => l_item_key);
875:
876: --Even though we've sent notifications already, if there was an error with the external contact, we want to send an error notification.
877: IF l_ext_contact_error = 'Y' THEN

Line 887: x_notification_id:=wf_engine.GetItemAttrNumber (itemtype => l_item_type,

883: END IF;
884:
885: --logic to get the notification id for the OUT parameter
886: IF l_internal_only = 'Y' THEN
887: x_notification_id:=wf_engine.GetItemAttrNumber (itemtype => l_item_type,
888: itemkey => l_item_key,
889: aname =>'OKCDELINTNOTIFID');
890: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
891: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'143: Notification ID is for internal user:'||x_notification_id);

Line 896: x_notification_id:=wf_engine.GetItemAttrNumber (itemtype => l_item_type,

892: END IF;
893:
894: ELSE
895: IF l_external_is_fyi = 'Y' THEN
896: x_notification_id:=wf_engine.GetItemAttrNumber (itemtype => l_item_type,
897: itemkey => l_item_key,
898: aname => 'OKCDELEXTNOTIFID');
899: ELSE
900: select notification_id into x_notification_id from wf_item_activity_statuses

Line 1025: wf_engine.SetItemAttrNumber (itemtype => itemtype,

1021:
1022: if ( funcmode = 'RUN' ) then
1023:
1024: --Store the internal users nid in case we need to return it
1025: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1026: itemkey => itemkey,
1027: aname => 'OKCDELINTNOTIFID',
1028: avalue => wf_Engine.g_nid);
1029:

Line 1028: avalue => wf_Engine.g_nid);

1024: --Store the internal users nid in case we need to return it
1025: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1026: itemkey => itemkey,
1027: aname => 'OKCDELINTNOTIFID',
1028: avalue => wf_Engine.g_nid);
1029:
1030: resultout:='COMPLETE';
1031: return;
1032: end if;

Line 1055: resultout := wf_engine.eng_timedout;

1051: end if;
1052: if ( funcmode = 'TIMEOUT' ) then
1053: resultout := 'COMPLETE';
1054: else
1055: resultout := wf_engine.eng_timedout;
1056: return;
1057: end if;
1058:
1059: exception

Line 1092: wf_engine.SetItemAttrNumber (itemtype => itemtype,

1088:
1089: if ( funcmode = 'RUN' ) then
1090:
1091: --Store the internal users nid in case we need to return it
1092: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1093: itemkey => itemkey,
1094: aname => 'OKCDELEXTNOTIFID',
1095: avalue => wf_Engine.g_nid);
1096:

Line 1095: avalue => wf_Engine.g_nid);

1091: --Store the internal users nid in case we need to return it
1092: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1093: itemkey => itemkey,
1094: aname => 'OKCDELEXTNOTIFID',
1095: avalue => wf_Engine.g_nid);
1096:
1097: resultout:='COMPLETE';
1098: return;
1099: end if;

Line 1122: resultout := wf_engine.eng_timedout;

1118: end if;
1119: if ( funcmode = 'TIMEOUT' ) then
1120: resultout := 'COMPLETE';
1121: else
1122: resultout := wf_engine.eng_timedout;
1123: return;
1124: end if;
1125:
1126: exception

Line 1173: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,

1169: d.manage_yn = 'Y'; --from bug 3696869
1170:
1171: BEGIN
1172:
1173: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,
1174: itemkey => itemkey,
1175: aname => 'NOTES2',ignore_notfound=>true);
1176:
1177: l_deliverable_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 1177: l_deliverable_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

1173: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,
1174: itemkey => itemkey,
1175: aname => 'NOTES2',ignore_notfound=>true);
1176:
1177: l_deliverable_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1178: itemkey => itemkey,
1179: aname => 'OKCDELID');
1180:
1181: l_new_status := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'RESULT');

Line 1181: l_new_status := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'RESULT');

1177: l_deliverable_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1178: itemkey => itemkey,
1179: aname => 'OKCDELID');
1180:
1181: l_new_status := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'RESULT');
1182:
1183: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1184: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module,'100: Entering update status for deliverable id:'||l_deliverable_id);
1185: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module,'100: New status will be:'||l_new_status);

Line 1265: resultout := wf_engine.eng_timedout;

1261: end if;
1262: if ( funcmode = 'TIMEOUT' ) then
1263: resultout := 'COMPLETE';
1264: else
1265: resultout := wf_engine.eng_timedout;
1266: return;
1267: end if;
1268:
1269: exception