1: PACKAGE BODY PO_APPROVAL_ACTION AS
2: /* $Header: POXWPA9B.pls 120.1.12010000.2 2008/08/04 08:36:35 rramasam ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
7: | FILENAME
8: | POXWPA9S.pls
9: |
10: | DESCRIPTION
11: | PL/SQL body for package: PO_APPROVAL_ACTION
12: |
13: | NOTES
14: | CREATE
15: | MODIFIED
72:
73: EXCEPTION
74:
75: WHEN OTHERS THEN
76: wf_core.context('PO_APPROVAL_ACTION','req_state_check_approve',x_progress);
77: raise;
78:
79: end;
80:
214:
215: EXCEPTION
216:
217: WHEN OTHERS THEN
218: wf_core.context('PO_APPROVAL_ACTION','po_state_check_approve',x_progress);
219: raise;
220:
221: end;
222:
625: return('N');
626: EXCEPTION
627:
628: WHEN OTHERS THEN
629: wf_core.context('PO_APPROVAL_ACTION','req_complete_check',x_progress);
630: raise;
631:
632: end;
633:
680: itemkey => itemkey,
681: aname => 'ONLINE_REPORT_TEXT',
682: avalue => l_concat_report_text);
683:
684: x_progress := 'PO_APPROVAL_ACTION.get_online_report_text. ON_LINE_REPORT_ID= '
685: || to_char(p_online_report_id);
686: IF (g_po_wf_debug = 'Y') THEN
687: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
688: END IF;
689:
690: EXCEPTION
691:
692: WHEN OTHERS THEN
693: wf_core.context('PO_APPROVAL_ACTION','get_online_report_text',x_progress);
694: raise;
695:
696: END get_online_report_text;
697:
695:
696: END get_online_report_text;
697:
698:
699: end PO_APPROVAL_ACTION;