APPS.POR_UTIL_PKG dependencies on PO_WF_DEBUG_PKG

Line 1464: PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,

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);
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,

Line 1468: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,

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');
1470: END IF;
1471: resume_contractor := 'Y';
1472: ELSE

Line 1475: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,

1471: resume_contractor := 'Y';
1472: ELSE
1473: IF X_AUTHORIZATION_STATUS = 'IN PROCESS' THEN
1474: IF (g_po_wf_debug = 'Y') THEN
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);

Line 1568: PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,

1564:
1565: IF (g_po_wf_debug = 'Y') THEN
1566:
1567: /* DEBUG */
1568: PO_WF_DEBUG_PKG.insert_debug(X_WF_ITEM_TYPE, X_WF_ITEM_KEY,
1569: 'X_AUTHORIZATION_STATUS, X_SUPPL_NOTIFIED_FLAG,
1570: X_CONTRACTOR_REQ_FLAG, X_WF_ITEM_KEY, X_WF_ITEM_TYPE:' ||
1571: X_AUTHORIZATION_STATUS || X_SUPPL_NOTIFIED_FLAG ||
1572: X_CONTRACTOR_REQ_FLAG || X_WF_ITEM_KEY || X_WF_ITEM_TYPE);

Line 5967: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey, l_progress);

5963:
5964: l_progress := 'POR_UTIL_PKG.Start_Email_WF_Process: Verify whether the role exists in wf_users';
5965:
5966: IF (g_po_wf_debug = 'Y') THEN
5967: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey, l_progress);
5968: END IF;
5969:
5970: select count(1) into l_user_exists
5971: from wf_users where ORIG_SYSTEM_ID = p_to_user_id;

Line 6060: PO_WF_DEBUG_PKG.insert_debug (l_itemtype, l_itemkey, l_progress);

6056:
6057: l_progress := 'POR_UTIL_PKG.Start_Email_WF_Process: Start the workflow process';
6058:
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:

Line 6069: PO_WF_DEBUG_PKG.insert_debug(l_itemtype, l_itemkey, l_progress);

6065: EXCEPTION
6066: WHEN OTHERS THEN
6067: l_progress := 'POR_UTIL_PKG.Start_WF_Process_Email: In Exception handler';
6068: IF (g_po_wf_debug = 'Y') THEN
6069: PO_WF_DEBUG_PKG.insert_debug(l_itemtype, l_itemkey, l_progress);
6070: END IF;
6071:
6072: RAISE;
6073: END Start_Email_WF_Process;

Line 6096: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey, x_progress);

6092: l_itemtype := substr(document_id, 1, instr(document_id, ':') - 1);
6093: l_itemkey := substr(document_id, instr(document_id, ':') + 1, length(document_id) - 2);
6094:
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,