DBA Data[Home] [Help]

APPS.PO_CHORD_WF0 dependencies on PO_WF_DEBUG_PKG

Line 21: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** In procedure chord_setup ***');

17: x_doc_subtype VARCHAR2(25):=NULL;
18: e_invalid_doc_type EXCEPTION;
19: BEGIN
20: IF (g_po_wf_debug = 'Y') THEN
21: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** In procedure chord_setup ***');
22: END IF;
23:
24: x_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,
25: itemkey => itemkey,

Line 33: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'Document Type '|| x_doc_type);

29: itemkey => itemkey,
30: aname => 'DOCUMENT_SUBTYPE');
31:
32: IF (g_po_wf_debug = 'Y') THEN
33: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'Document Type '|| x_doc_type);
34: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'Document Subtype '|| x_doc_subtype);
35: END IF;
36:
37: IF x_doc_type = 'REQUISITION' THEN

Line 34: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'Document Subtype '|| x_doc_subtype);

30: aname => 'DOCUMENT_SUBTYPE');
31:
32: IF (g_po_wf_debug = 'Y') THEN
33: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'Document Type '|| x_doc_type);
34: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'Document Subtype '|| x_doc_subtype);
35: END IF;
36:
37: IF x_doc_type = 'REQUISITION' THEN
38: --Change order does not apply to Req

Line 84: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** FINISH: chord_setup ***');

80: aname => 'AUTHORIZATION_STATUS',
81: avalue => x_auth_status );
82:
83: IF (g_po_wf_debug = 'Y') THEN
84: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** FINISH: chord_setup ***');
85: END IF;
86:
87: result := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
88: return;

Line 94: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** exception chord_doc_type ***');

90:
91: EXCEPTION
92: WHEN e_invalid_doc_type THEN
93: IF (g_po_wf_debug = 'Y') THEN
94: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** exception chord_doc_type ***');
95: END IF;
96: wf_core.context('POAPPRV', 'chord_doc_type', 'e_invalid_doc_type');
97: RAISE;
98:

Line 116: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** In procedure chord_doc_type ***');

112: x_doc_subtype VARCHAR2(25);
113: e_invalid_doc_type EXCEPTION;
114: BEGIN
115: IF (g_po_wf_debug = 'Y') THEN
116: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** In procedure chord_doc_type ***');
117: END IF;
118:
119:
120: x_doc_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 129: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'doc_type '|| x_doc_type);

125: itemkey => itemkey,
126: aname => 'DOCUMENT_SUBTYPE');
127:
128: IF (g_po_wf_debug = 'Y') THEN
129: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'doc_type '|| x_doc_type);
130: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'doc_subtype '|| x_doc_subtype);
131: END IF;
132:
133:

Line 130: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'doc_subtype '|| x_doc_subtype);

126: aname => 'DOCUMENT_SUBTYPE');
127:
128: IF (g_po_wf_debug = 'Y') THEN
129: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'doc_type '|| x_doc_type);
130: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'doc_subtype '|| x_doc_subtype);
131: END IF;
132:
133:
134: IF x_doc_type = 'REQUISITION' THEN

Line 143: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: po_standard');

139:
140: IF x_doc_subtype = 'STANDARD' THEN
141: RESULT:='PO_STANDARD';
142: IF (g_po_wf_debug = 'Y') THEN
143: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: po_standard');
144: END IF;
145:
146: ELSIF x_doc_subtype = 'CONTRACT' THEN
147: RESULT:='PO_CONTRACT';

Line 149: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: po_contract');

145:
146: ELSIF x_doc_subtype = 'CONTRACT' THEN
147: RESULT:='PO_CONTRACT';
148: IF (g_po_wf_debug = 'Y') THEN
149: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: po_contract');
150: END IF;
151:
152: ELSIF x_doc_subtype = 'BLANKET' THEN
153: RESULT:='PO_BLANKET';

Line 155: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: po_blanket');

151:
152: ELSIF x_doc_subtype = 'BLANKET' THEN
153: RESULT:='PO_BLANKET';
154: IF (g_po_wf_debug = 'Y') THEN
155: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: po_blanket');
156: END IF;
157:
158: ELSIF x_doc_subtype = 'PLANNED' THEN
159: RESULT:='PO_PLANNED';

Line 161: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: po_planned');

157:
158: ELSIF x_doc_subtype = 'PLANNED' THEN
159: RESULT:='PO_PLANNED';
160: IF (g_po_wf_debug = 'Y') THEN
161: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: po_planned');
162: END IF;
163:
164: END IF;
165:

Line 170: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: blanket_release');

166: ELSIF x_doc_type = 'RELEASE' THEN
167: IF x_doc_subtype = 'BLANKET' THEN
168: RESULT:='BLANKET_RELEASE';
169: IF (g_po_wf_debug = 'Y') THEN
170: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: blanket_release');
171: END IF;
172: ELSE
173: RESULT:='SCHEDULED_RELEASE';
174: IF (g_po_wf_debug = 'Y') THEN

Line 175: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: scheduled_release');

171: END IF;
172: ELSE
173: RESULT:='SCHEDULED_RELEASE';
174: IF (g_po_wf_debug = 'Y') THEN
175: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, 'CO TYPE: scheduled_release');
176: END IF;
177: END IF;
178: ELSE
179: raise e_invalid_doc_type;

Line 186: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** Finish: chord_doc_type ***');

182:
183: return;
184:
185: IF (g_po_wf_debug = 'Y') THEN
186: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** Finish: chord_doc_type ***');
187: END IF;
188:
189:
190: EXCEPTION

Line 193: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** exception chord_doc_type ***');

189:
190: EXCEPTION
191: WHEN e_invalid_doc_type THEN
192: IF (g_po_wf_debug = 'Y') THEN
193: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, '*** exception chord_doc_type ***');
194: END IF;
195: wf_core.context('POAPPRV', 'chord_doc_type', 'e_invalid_doc_type');
196: RAISE;
197:

Line 348: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

344: x_result VARCHAR2(1):='N';
345: BEGIN
346:
347: IF (g_po_wf_debug = 'Y') THEN
348: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
349: '*** In Procedure: archive_on_approval ***');
350: END IF;
351:
352: x_org_id:= wf_engine.GetItemAttrNumber (itemtype => itemType,

Line 403: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

399: x_result:='N';
400: END IF;
401:
402: IF (g_po_wf_debug = 'Y') THEN
403: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
404: '*** Finished: archive_on_approval ***');
405: END IF;
406:
407: result := wf_engine.eng_completed || ':' || x_result;

Line 414: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

410: EXCEPTION
411:
412: WHEN OTHERS THEN
413: IF (g_po_wf_debug = 'Y') THEN
414: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
415: '*** execption archive_on_approval_set *** '||x_result);
416: END IF;
417: wf_core.context('POAPPRV', 'po_chord_wf0.archive_on_approval_set', 'result '||x_result);
418: RAISE;