DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_WF_PVT dependencies on WF_ENGINE

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

878: l_process_name := 'OKCDELNOTIFYFYI';
879: end if;
880:
881: --Create the process
882: wf_engine.CreateProcess(itemtype => l_item_type,
883: itemkey => l_item_key,
884: process => l_process_name);
885: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
886: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'140: Creating process:'||l_item_type||':'

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

886: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'140: Creating process:'||l_item_type||':'
887: ||l_item_key||':'||l_process_name);
888: END IF;
889:
890: wf_engine.SetItemUserKey (itemtype => l_item_type,
891: itemkey => l_item_key,
892: userkey => l_item_key);
893: wf_engine.SetItemOwner (itemtype => l_item_type,
894: itemkey => l_item_key,

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

889:
890: wf_engine.SetItemUserKey (itemtype => l_item_type,
891: itemkey => l_item_key,
892: userkey => l_item_key);
893: wf_engine.SetItemOwner (itemtype => l_item_type,
894: itemkey => l_item_key,
895: owner => fnd_global.user_name);
896: -- Set global attributes
897: wf_engine.SetItemAttrNumber (itemtype => l_item_type,

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

893: wf_engine.SetItemOwner (itemtype => l_item_type,
894: itemkey => l_item_key,
895: owner => fnd_global.user_name);
896: -- Set global attributes
897: wf_engine.SetItemAttrNumber (itemtype => l_item_type,
898: itemkey => l_item_key,
899: aname => 'OKCDELID',
900: avalue => p_deliverable_id);
901:

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

898: itemkey => l_item_key,
899: aname => 'OKCDELID',
900: avalue => p_deliverable_id);
901:
902: wf_engine.SetItemAttrText (itemtype => l_item_type,
903: itemkey => l_item_key,
904: aname => 'OKCDELINTUSERROLE',
905: avalue => l_internal_role_name);
906:

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

903: itemkey => l_item_key,
904: aname => 'OKCDELINTUSERROLE',
905: avalue => l_internal_role_name);
906:
907: wf_engine.SetItemAttrText (itemtype => l_item_type,
908: itemkey => l_item_key,
909: aname => 'OKCDELSUBJECT',
910: avalue => p_msg_code||':'||p_deliverable_id);
911:

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

909: aname => 'OKCDELSUBJECT',
910: avalue => p_msg_code||':'||p_deliverable_id);
911:
912: IF l_requester_role_name IS NOT NULL THEN
913: wf_engine.SetItemAttrText (itemtype => l_item_type,
914: itemkey => l_item_key,
915: aname => 'OKCDELREQUESTOR',
916: avalue => l_requester_role_name);
917:

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

914: itemkey => l_item_key,
915: aname => 'OKCDELREQUESTOR',
916: avalue => l_requester_role_name);
917:
918: wf_engine.SetItemAttrText (itemtype => l_item_type,
919: itemkey => l_item_key,
920: aname => 'OKCDELREQUESTEREXISTS',
921: avalue => 'Y');
922: END IF;

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

920: aname => 'OKCDELREQUESTEREXISTS',
921: avalue => 'Y');
922: END IF;
923:
924: wf_engine.SetItemAttrText (itemtype => l_item_type,
925: itemkey => l_item_key,
926: aname => 'OKCDELEXTUSERROLE',
927: avalue => l_external_role_name);
928: /*

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

930: ||l_header_function_name||'&documentHeaderId='
931: ||p_business_document_id||'&OKC_DOCUMENT_TYPE='||p_business_document_type
932: ||'&OKC_DOC_VER_NUM='||p_business_document_version
933: ||'&_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';
934: wf_engine.SetItemAttrText (itemtype => l_item_type,
935: itemkey => l_item_key,
936: aname => 'OKCDELBUSDOCDETAILSRN',
937: avalue => l_ui_region);
938: */

Line 971: wf_engine.setitemattrtext(itemtype => l_item_type,

967: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'l_ext_contact_name = '||l_ext_contact_name||' l_int_contact_name= '||l_int_contact_name);
968: END IF;
969:
970:
971: wf_engine.setitemattrtext(itemtype => l_item_type,
972: itemkey => l_item_key,
973: aname => 'OKCDELMSGBODY',
974: avalue => 'PLSQLCLOB:OKC_DELIVERABLE_WF_PVT.get_notfn_body/'||p_business_document_type||':'||p_deliverable_name||':'||l_del_type_name||':'||
975: l_resp_party_name||':'||l_int_contact_name||':'||l_ext_contact_name);

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

979: l_ui_region := 'JSP:/OA_HTML/OA.jsp?page=/oracle/apps/okc/deliverables/webui/NotificationDelRN&deliverableId='
980: ||p_deliverable_id||'&deliverableName='||p_deliverable_name||'&delBusDocNum='||p_business_document_number
981: ||'&delBusDocVersion='||p_business_document_version||'&delBusDocTypeCode='||p_business_document_type||'&busDocId='||p_business_document_id||'&docViewDetailsFunction='||l_header_function_name ||'&pmode='||l_mode||'&docClass='||l_doc_class;
982:
983: wf_engine.SetItemAttrText (itemtype => l_item_type,
984: itemkey => l_item_key,
985: aname => 'OKCDELDOCDTLSEDITRN',
986: avalue => l_ui_region);
987:

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

991: l_ui_region := 'JSP:/OA_HTML/OA.jsp?page=/oracle/apps/okc/deliverables/webui/NotificationDelRN&deliverableId='
992: ||p_deliverable_id||'&deliverableName='||p_deliverable_name||'&delBusDocNum='||p_business_document_number
993: ||'&delBusDocVersion='||p_business_document_version||'&delBusDocTypeCode='||p_business_document_type||'&busDocId='||p_business_document_id||'&docViewDetailsFunction='||l_header_function_name ||'&pmode='||l_mode||'&docClass='||l_doc_class;
994:
995: wf_engine.SetItemAttrText (itemtype => l_item_type,
996: itemkey => l_item_key,
997: aname => 'OKCDELDOCDTLSVIEWRN',
998: avalue => l_ui_region);
999:

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

1000: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1001: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'141: Setting workflow attributes.');
1002: END IF;
1003:
1004: wf_engine.SetItemAttrText (itemtype => l_item_type,
1005: itemkey => l_item_key,
1006: aname => 'FROMROLE',
1007: avalue => l_internal_role_name);
1008:

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

1005: itemkey => l_item_key,
1006: aname => 'FROMROLE',
1007: avalue => l_internal_role_name);
1008:
1009: wf_engine.SetItemAttrText (itemtype => l_item_type,
1010: itemkey => l_item_key,
1011: aname => 'OKCDELRESPPARTY',
1012: avalue => l_resp_party_code);
1013:

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

1010: itemkey => l_item_key,
1011: aname => 'OKCDELRESPPARTY',
1012: avalue => l_resp_party_code);
1013:
1014: wf_engine.StartProcess(itemtype => l_item_type,
1015: itemkey => l_item_key);
1016:
1017: --Even though we've sent notifications already, if there was an error with the external contact, we want to send an error notification.
1018: IF l_ext_contact_error = 'Y' THEN

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

1024: END IF;
1025:
1026: --logic to get the notification id for the OUT parameter
1027: IF l_internal_only = 'Y' THEN
1028: x_notification_id:=wf_engine.GetItemAttrNumber (itemtype => l_item_type,
1029: itemkey => l_item_key,
1030: aname =>'OKCDELINTNOTIFID');
1031: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1032: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'143: Notification ID is for internal user:'||x_notification_id);

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

1033: END IF;
1034:
1035: ELSE
1036: IF l_external_is_fyi = 'Y' THEN
1037: x_notification_id:=wf_engine.GetItemAttrNumber (itemtype => l_item_type,
1038: itemkey => l_item_key,
1039: aname => 'OKCDELEXTNOTIFID');
1040: ELSE
1041: select notification_id into x_notification_id from wf_item_activity_statuses

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

1162:
1163: if ( funcmode = 'RUN' ) then
1164:
1165: --Store the internal users nid in case we need to return it
1166: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1167: itemkey => itemkey,
1168: aname => 'OKCDELINTNOTIFID',
1169: avalue => wf_Engine.g_nid);
1170:

Line 1169: avalue => wf_Engine.g_nid);

1165: --Store the internal users nid in case we need to return it
1166: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1167: itemkey => itemkey,
1168: aname => 'OKCDELINTNOTIFID',
1169: avalue => wf_Engine.g_nid);
1170:
1171: resultout:='COMPLETE';
1172: return;
1173: end if;

Line 1196: resultout := wf_engine.eng_timedout;

1192: end if;
1193: if ( funcmode = 'TIMEOUT' ) then
1194: resultout := 'COMPLETE';
1195: else
1196: resultout := wf_engine.eng_timedout;
1197: return;
1198: end if;
1199:
1200: exception

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

1229:
1230: if ( funcmode = 'RUN' ) then
1231:
1232: --Store the internal users nid in case we need to return it
1233: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1234: itemkey => itemkey,
1235: aname => 'OKCDELEXTNOTIFID',
1236: avalue => wf_Engine.g_nid);
1237:

Line 1236: avalue => wf_Engine.g_nid);

1232: --Store the internal users nid in case we need to return it
1233: wf_engine.SetItemAttrNumber (itemtype => itemtype,
1234: itemkey => itemkey,
1235: aname => 'OKCDELEXTNOTIFID',
1236: avalue => wf_Engine.g_nid);
1237:
1238: resultout:='COMPLETE';
1239: return;
1240: end if;

Line 1263: resultout := wf_engine.eng_timedout;

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

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

1310: d.manage_yn = 'Y'; --from bug 3696869
1311:
1312: BEGIN
1313:
1314: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,
1315: itemkey => itemkey,
1316: aname => 'NOTES2',ignore_notfound=>true);
1317:
1318: l_deliverable_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

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

1314: l_notes := wf_engine.GetItemAttrText (itemtype => itemtype,
1315: itemkey => itemkey,
1316: aname => 'NOTES2',ignore_notfound=>true);
1317:
1318: l_deliverable_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1319: itemkey => itemkey,
1320: aname => 'OKCDELID');
1321:
1322: l_new_status := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'RESULT');

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

1318: l_deliverable_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
1319: itemkey => itemkey,
1320: aname => 'OKCDELID');
1321:
1322: l_new_status := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'RESULT');
1323:
1324: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1325: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module,'100: Entering update status for deliverable id:'||l_deliverable_id);
1326: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module,'100: New status will be:'||l_new_status);

Line 1406: resultout := wf_engine.eng_timedout;

1402: end if;
1403: if ( funcmode = 'TIMEOUT' ) then
1404: resultout := 'COMPLETE';
1405: else
1406: resultout := wf_engine.eng_timedout;
1407: return;
1408: end if;
1409:
1410: exception