30: begin
31:
32: x_progress := 'PO_WF_PO_ACCRUAL_ACC.destination_type: 01';
33: IF (g_po_wf_debug = 'Y') THEN
34: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
35: END IF;
36:
37:
38: -- Do nothing in cancel or timeout mode
94: begin
95:
96: x_progress := 'PO_WF_PO_ACCRUAL_ACC.AA_from_org : 01';
97: IF (g_po_wf_debug = 'Y') THEN
98: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
99: END IF;
100:
101:
102: -- Do nothing in cancel or timeout mode
212: begin
213:
214: x_progress := 'PO_WF_PO_ACCRUAL_ACC.AA_for_expense_item: 01';
215: IF (g_po_wf_debug = 'Y') THEN
216: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
217: END IF;
218:
219:
220: -- Do nothing in cancel or timeout mode
364: itemkey => itemkey,
365: aname => 'PURCHASING_OU_ID');
366:
367: IF (g_po_wf_debug = 'Y') THEN
368: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
369: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account ' ||
370: 'l_purchasing_ou_id='||l_purchasing_ou_id);
371: END IF;
372:
397:
398: l_progress := '040';
399:
400: IF (g_po_wf_debug = 'Y') THEN
401: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
402: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account result='||result);
403: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
404: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account l_account_id='||
405: l_account_id);
399:
400: IF (g_po_wf_debug = 'Y') THEN
401: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
402: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account result='||result);
403: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
404: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account l_account_id='||
405: l_account_id);
406: END IF;
407: EXCEPTION
406: END IF;
407: EXCEPTION
408: WHEN OTHERS THEN
409: IF (g_po_wf_debug = 'Y') THEN
410: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
411: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account EXCEPTION at '||
412: l_progress);
413: END IF;
414: WF_CORE.context('PO_WF_PO_ACCRUAL_ACC', 'get_SPS_accrual_account',