DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on WF_ENGINE

Line 846: WF_ENGINE_UTIL.CLEARCACHE;

842: V_accrual_success := bool_to_varchar(x_accrual_success);
843: V_variance_success := bool_to_varchar(x_variance_success);
844: V_new_combination := bool_to_varchar(x_new_combination);
845:
846: WF_ENGINE_UTIL.CLEARCACHE;
847: WF_ACTIVITY.CLEARCACHE;
848: WF_ITEM_ACTIVITY_STATUS.CLEARCACHE;
849: WF_ITEM.CLEARCACHE;
850: WF_PROCESS_ACTIVITY.CLEARCACHE;

Line 1461: wf_engine.CompleteActivity(X_WF_ITEM_TYPE, X_WF_ITEM_KEY, 'COMM_CONTR_SUPPLIER_BLOCK','NULL');

1457:
1458: IF X_AUTHORIZATION_STATUS = 'APPROVED' THEN
1459: -- REMOVE THE BLOCK
1460: BEGIN
1461: wf_engine.CompleteActivity(X_WF_ITEM_TYPE, X_WF_ITEM_KEY, 'COMM_CONTR_SUPPLIER_BLOCK','NULL');
1462: EXCEPTION
1463: WHEN OTHERS THEN
1464: PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,
1465: 'ERROR while running wf_engine.CompleteActivity:' || SQLERRM);

Line 1465: 'ERROR while running wf_engine.CompleteActivity:' || SQLERRM);

1461: wf_engine.CompleteActivity(X_WF_ITEM_TYPE, X_WF_ITEM_KEY, 'COMM_CONTR_SUPPLIER_BLOCK','NULL');
1462: EXCEPTION
1463: WHEN OTHERS THEN
1464: PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,
1465: 'ERROR while running wf_engine.CompleteActivity:' || SQLERRM);
1466: END;
1467: IF (g_po_wf_debug = 'Y') THEN
1468: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,
1469: 'AFTER wf_engine.CompleteActivity');

Line 1469: 'AFTER wf_engine.CompleteActivity');

1465: 'ERROR while running wf_engine.CompleteActivity:' || SQLERRM);
1466: END;
1467: IF (g_po_wf_debug = 'Y') THEN
1468: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,
1469: 'AFTER wf_engine.CompleteActivity');
1470: END IF;
1471: resume_contractor := 'Y';
1472: ELSE
1473: IF X_AUTHORIZATION_STATUS = 'IN PROCESS' THEN

Line 1479: WF_Engine.AbortProcess(X_WF_ITEM_TYPE, X_WF_ITEM_KEY);

1475: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,
1476: 'X_AUTHORIZATION_STATUS = IN PROCESS');
1477: END IF;
1478: --ABORT THE EXISTING WF
1479: WF_Engine.AbortProcess(X_WF_ITEM_TYPE, X_WF_ITEM_KEY);
1480: WF_PURGE.total (X_WF_ITEM_TYPE, X_WF_ITEM_KEY);
1481: update po_requisition_headers_all
1482: set WF_ITEM_TYPE = NULL, WF_ITEM_KEY = NULL
1483: where REQUISITION_HEADER_ID = req_Header_Id;

Line 2492: WF_Engine.AbortProcess(l_item_type, l_item_key);

2488: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
2489: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME || l_procedure_name, ' Aborting Parent Workflow: ' || l_item_key || ' : ' || l_item_type);
2490: END IF;
2491:
2492: WF_Engine.AbortProcess(l_item_type, l_item_key);
2493: END IF;
2494:
2495: l_progress := '080';
2496:

Line 2530: WF_Engine.AbortProcess(l_item_type, c1_rec.item_key);

2526: END IF;
2527:
2528: l_progress := '100';
2529:
2530: WF_Engine.AbortProcess(l_item_type, c1_rec.item_key);
2531: END IF;
2532:
2533: end LOOP;
2534:

Line 6014: wf_engine.CreateProcess(ItemType => l_itemtype,

6010:
6011: l_progress := 'POR_UTIL_PKG.Start_Email_WF_Process: at beginning of Start_Email_WF_Process';
6012: l_workflow_process := 'EMAIL_MIPR_DOC';
6013:
6014: wf_engine.CreateProcess(ItemType => l_itemtype,
6015: ItemKey => l_itemkey,
6016: process => l_workflow_process );
6017:
6018: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => l_itemtype,

Line 6063: wf_engine. StartProcess (itemtype => l_itemtype, itemkey => l_itemkey);

6059: IF (g_po_wf_debug = 'Y') THEN
6060: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey, l_progress);
6061: END IF;
6062:
6063: wf_engine. StartProcess (itemtype => l_itemtype, itemkey => l_itemkey);
6064:
6065: EXCEPTION
6066: WHEN OTHERS THEN
6067: l_progress := 'POR_UTIL_PKG.Start_WF_Process_Email: In Exception handler';

Line 6099: l_document_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,

6095: IF (g_po_wf_debug = 'Y') THEN
6096: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey, x_progress);
6097: END IF;
6098:
6099: l_document_id := wf_engine.GetItemAttrNumber (itemtype => l_itemtype,
6100: itemkey => l_itemkey,
6101: aname => 'DOCUMENT_ID');
6102:
6103: SELECT fl.file_data, fl.file_name into l_document, l_filename