DBA Data[Home] [Help]

APPS.XDPCORE_OM dependencies on WF_ENGINE

Line 277: l_org_id := wf_engine.GetItemAttrNumber( itemtype => update_om_line_status.itemtype,

273:
274: -- Update OM Line Flow Status to 'Provisioning Succeeded'
275:
276:
277: l_org_id := wf_engine.GetItemAttrNumber( itemtype => update_om_line_status.itemtype,
278: itemkey => update_om_line_status.itemkey,
279: aname => 'ORG_ID');
280:
281: -- Date: 15 FEB 2006. Author: DPUTHIYE BUG#: 5023342

Line 364: WF_ENGINE.CREATEPROCESS(itemtype => l_item_type,

360: WHERE l.line_id = to_number(l_line_id)
361: AND l.header_id = h.header_id ;
362:
363:
364: WF_ENGINE.CREATEPROCESS(itemtype => l_item_type,
365: itemkey => l_item_key ,
366: process => 'XDP_OM_INTERFACE');
367:
368: WF_ENGINE.SetItemAttrNumber(itemtype => l_item_type ,

Line 368: WF_ENGINE.SetItemAttrNumber(itemtype => l_item_type ,

364: WF_ENGINE.CREATEPROCESS(itemtype => l_item_type,
365: itemkey => l_item_key ,
366: process => 'XDP_OM_INTERFACE');
367:
368: WF_ENGINE.SetItemAttrNumber(itemtype => l_item_type ,
369: itemkey => l_item_key ,
370: aname => 'LINE_ID',
371: avalue => l_item_key );
372:

Line 373: WF_ENGINE.SetItemAttrNumber(itemtype => l_item_type ,

369: itemkey => l_item_key ,
370: aname => 'LINE_ID',
371: avalue => l_item_key );
372:
373: WF_ENGINE.SetItemAttrNumber(itemtype => l_item_type ,
374: itemkey => l_item_key ,
375: aname => 'ORG_ID',
376: avalue => l_org_id );
377:

Line 378: WF_ENGINE.SetItemAttrNumber(itemtype => l_item_type ,

374: itemkey => l_item_key ,
375: aname => 'ORG_ID',
376: avalue => l_org_id );
377:
378: WF_ENGINE.SetItemAttrNumber(itemtype => l_item_type ,
379: itemkey => l_item_key ,
380: aname => 'ORDER_NUMBER',
381: avalue => l_order_number );
382:

Line 383: WF_ENGINE.StartProcess(l_item_type, l_item_key);

379: itemkey => l_item_key ,
380: aname => 'ORDER_NUMBER',
381: avalue => l_order_number );
382:
383: WF_ENGINE.StartProcess(l_item_type, l_item_key);
384:
385: EXCEPTION
386: WHEN others THEN
387: x_progress := SQLCODE||' - ' ||SQLERRM ;

Line 762: l_org_id := wf_engine.GetItemAttrNumber( itemtype => WaitForFulfillment.itemtype,

758:
759:
760: -- Publish SFM Fulfillment Start Event to start an SFM - OM Interface WF Process.
761:
762: l_org_id := wf_engine.GetItemAttrNumber( itemtype => WaitForFulfillment.itemtype,
763: itemkey => WaitForFulfillment.itemkey,
764: aname => 'ORG_ID');
765:
766: -- Date: 15 FEB 2006. Author: DPUTHIYE BUG#: 5023342

Line 882: l_org_id := wf_engine.GetItemAttrNumber( itemtype => ProvisionLine.itemtype,

878: IF l_resultout = 'LINE_NOT_FOUND' THEN
879:
880: -- Update OM Line Flow Status to 'Provisioning Failed'
881:
882: l_org_id := wf_engine.GetItemAttrNumber( itemtype => ProvisionLine.itemtype,
883: itemkey => ProvisionLine.itemkey,
884: aname => 'ORG_ID');
885:
886: dbms_application_info.set_client_info(l_org_id);

Line 972: WF_ENGINE.SetItemAttrNumber(itemtype => IsFulfillmentCompleted.itemtype ,

968: END IF;
969:
970: IF l_line_item_id IS NOT NULL THEN
971:
972: WF_ENGINE.SetItemAttrNumber(itemtype => IsFulfillmentCompleted.itemtype ,
973: itemkey => IsFulfillmentCompleted.itemkey ,
974: aname => 'LINE_ITEM_ID',
975: avalue => l_line_item_id );
976: END IF ;

Line 980: WF_ENGINE.SetItemAttrNumber(itemtype => IsFulfillmentCompleted.itemtype ,

976: END IF ;
977:
978: IF l_order_id IS NOT NULL THEN
979:
980: WF_ENGINE.SetItemAttrNumber(itemtype => IsFulfillmentCompleted.itemtype ,
981: itemkey => IsFulfillmentCompleted.itemkey ,
982: aname => 'ORDER_ID',
983: avalue => l_order_id );
984: END IF ;

Line 1020: l_order_id := wf_engine.GetItemAttrNumber(itemtype => UpdateTxnDetails.itemtype,

1016: l_org_id NUMBER;
1017:
1018: BEGIN
1019:
1020: l_order_id := wf_engine.GetItemAttrNumber(itemtype => UpdateTxnDetails.itemtype,
1021: itemkey => UpdateTxnDetails.itemkey,
1022: aname => 'ORDER_ID');
1023:
1024: l_line_item_id := wf_engine.GetItemAttrNumber(itemtype => UpdateTxnDetails.itemtype,

Line 1024: l_line_item_id := wf_engine.GetItemAttrNumber(itemtype => UpdateTxnDetails.itemtype,

1020: l_order_id := wf_engine.GetItemAttrNumber(itemtype => UpdateTxnDetails.itemtype,
1021: itemkey => UpdateTxnDetails.itemkey,
1022: aname => 'ORDER_ID');
1023:
1024: l_line_item_id := wf_engine.GetItemAttrNumber(itemtype => UpdateTxnDetails.itemtype,
1025: itemkey => UpdateTxnDetails.itemkey,
1026: aname => 'LINE_ITEM_ID');
1027:
1028:

Line 1084: WF_ENGINE.SetItemAttrNumber(itemtype => UpdateTxnDetails.itemtype ,

1080: IF l_errCode <> 0 then
1081: x_progress := ' Error while updating TXN details for Item Attribute ( Line Item Id = '|| l_line_item_id ||')'||
1082: 'UpdateTxnDetails. Error: ' || substr(sqlerrm,1,1500);
1083:
1084: WF_ENGINE.SetItemAttrNumber(itemtype => UpdateTxnDetails.itemtype ,
1085: itemkey => UpdateTxnDetails.itemkey ,
1086: aname => 'NOTIF_ERROR_CODE',
1087: avalue => l_errcode );
1088: --Date: 05-JUL-2006, Author: DPUTHIYE, Bug#5370624/5222928

Line 1090: --WF_ENGINE.SetItemAttrNumber(itemtype => UpdateTxnDetails.itemtype ,

1086: aname => 'NOTIF_ERROR_CODE',
1087: avalue => l_errcode );
1088: --Date: 05-JUL-2006, Author: DPUTHIYE, Bug#5370624/5222928
1089: --Description: 'NOTIF_ERROR_MESSAGE' is a text attribute.
1090: --WF_ENGINE.SetItemAttrNumber(itemtype => UpdateTxnDetails.itemtype ,
1091: WF_ENGINE.SetItemAttrText(itemtype => UpdateTxnDetails.itemtype ,
1092: itemkey => UpdateTxnDetails.itemkey ,
1093: aname => 'NOTIF_ERROR_MESSAGE',
1094: avalue => l_error_description);

Line 1091: WF_ENGINE.SetItemAttrText(itemtype => UpdateTxnDetails.itemtype ,

1087: avalue => l_errcode );
1088: --Date: 05-JUL-2006, Author: DPUTHIYE, Bug#5370624/5222928
1089: --Description: 'NOTIF_ERROR_MESSAGE' is a text attribute.
1090: --WF_ENGINE.SetItemAttrNumber(itemtype => UpdateTxnDetails.itemtype ,
1091: WF_ENGINE.SetItemAttrText(itemtype => UpdateTxnDetails.itemtype ,
1092: itemkey => UpdateTxnDetails.itemkey ,
1093: aname => 'NOTIF_ERROR_MESSAGE',
1094: avalue => l_error_description);
1095:

Line 1099: l_org_id := wf_engine.GetItemAttrNumber( itemtype => UpdateTxnDetails.itemtype,

1095:
1096:
1097: -- Update OM Line Flow Status to 'Provisioning Failed'
1098:
1099: l_org_id := wf_engine.GetItemAttrNumber( itemtype => UpdateTxnDetails.itemtype,
1100: itemkey => UpdateTxnDetails.itemkey,
1101: aname => 'ORG_ID');
1102:
1103: dbms_application_info.set_client_info(l_org_id);

Line 1115: l_org_id := wf_engine.GetItemAttrNumber( itemtype => UpdateTxnDetails.itemtype,

1111: ELSE
1112:
1113: -- Update OM Line Flow Status to 'Provisioning Requested'
1114:
1115: l_org_id := wf_engine.GetItemAttrNumber( itemtype => UpdateTxnDetails.itemtype,
1116: itemkey => UpdateTxnDetails.itemkey,
1117: aname => 'ORG_ID');
1118:
1119: dbms_application_info.set_client_info(l_org_id);