eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DOCUMENT_ACTION_AUTH dependencies on PO_LOG

Line 75: IF (PO_LOG.d_proc) THEN

71:
72: BEGIN
73:
74: d_progress := 0;
75: IF (PO_LOG.d_proc) THEN
76: PO_LOG.proc_begin(d_module);
77: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
78: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
79: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);

Line 76: PO_LOG.proc_begin(d_module);

72: BEGIN
73:
74: d_progress := 0;
75: IF (PO_LOG.d_proc) THEN
76: PO_LOG.proc_begin(d_module);
77: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
78: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
79: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
80: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);

Line 77: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);

73:
74: d_progress := 0;
75: IF (PO_LOG.d_proc) THEN
76: PO_LOG.proc_begin(d_module);
77: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
78: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
79: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
80: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
81: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.new_document_status', p_action_ctl_rec.new_document_status);

Line 78: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);

74: d_progress := 0;
75: IF (PO_LOG.d_proc) THEN
76: PO_LOG.proc_begin(d_module);
77: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
78: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
79: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
80: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
81: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.new_document_status', p_action_ctl_rec.new_document_status);
82: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.employee_id', p_action_ctl_rec.employee_id);

Line 79: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);

75: IF (PO_LOG.d_proc) THEN
76: PO_LOG.proc_begin(d_module);
77: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
78: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
79: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
80: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
81: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.new_document_status', p_action_ctl_rec.new_document_status);
82: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.employee_id', p_action_ctl_rec.employee_id);
83: END IF;

Line 80: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);

76: PO_LOG.proc_begin(d_module);
77: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
78: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
79: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
80: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
81: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.new_document_status', p_action_ctl_rec.new_document_status);
82: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.employee_id', p_action_ctl_rec.employee_id);
83: END IF;
84:

Line 81: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.new_document_status', p_action_ctl_rec.new_document_status);

77: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
78: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
79: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
80: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
81: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.new_document_status', p_action_ctl_rec.new_document_status);
82: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.employee_id', p_action_ctl_rec.employee_id);
83: END IF;
84:
85: d_progress := 10;

Line 82: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.employee_id', p_action_ctl_rec.employee_id);

78: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
79: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
80: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
81: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.new_document_status', p_action_ctl_rec.new_document_status);
82: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.employee_id', p_action_ctl_rec.employee_id);
83: END IF;
84:
85: d_progress := 10;
86:

Line 89: IF (PO_LOG.d_stmt) THEN

85: d_progress := 10;
86:
87: BEGIN
88:
89: IF (PO_LOG.d_stmt) THEN
90: PO_LOG.stmt(d_module, d_progress, 'Calling change_doc_auth_state');
91: END IF;
92:
93: PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state(

Line 90: PO_LOG.stmt(d_module, d_progress, 'Calling change_doc_auth_state');

86:
87: BEGIN
88:
89: IF (PO_LOG.d_stmt) THEN
90: PO_LOG.stmt(d_module, d_progress, 'Calling change_doc_auth_state');
91: END IF;
92:
93: PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state(
94: p_document_id => p_action_ctl_rec.document_id

Line 146: IF (PO_LOG.d_stmt) THEN

142: RAISE PO_CORE_S.g_early_return_exc;
143: END IF;
144:
145: d_progress := 50;
146: IF (PO_LOG.d_stmt) THEN
147: PO_LOG.stmt(d_module, d_progress, 'l_supply_action', l_supply_action);
148: END IF;
149:
150: l_bool_ret_sts :=

Line 147: PO_LOG.stmt(d_module, d_progress, 'l_supply_action', l_supply_action);

143: END IF;
144:
145: d_progress := 50;
146: IF (PO_LOG.d_stmt) THEN
147: PO_LOG.stmt(d_module, d_progress, 'l_supply_action', l_supply_action);
148: END IF;
149:
150: l_bool_ret_sts :=
151: PO_SUPPLY.po_req_supply(

Line 232: IF (PO_LOG.d_exc) THEN

228:
229: EXCEPTION
230: WHEN PO_CORE_S.g_early_return_exc THEN
231: p_action_ctl_rec.return_status := 'U';
232: IF (PO_LOG.d_exc) THEN
233: PO_LOG.exc(d_module, d_progress, l_err_msg);
234: END IF;
235: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
236:

Line 233: PO_LOG.exc(d_module, d_progress, l_err_msg);

229: EXCEPTION
230: WHEN PO_CORE_S.g_early_return_exc THEN
231: p_action_ctl_rec.return_status := 'U';
232: IF (PO_LOG.d_exc) THEN
233: PO_LOG.exc(d_module, d_progress, l_err_msg);
234: END IF;
235: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
236:
237: END;

Line 239: IF (PO_LOG.d_proc) THEN

235: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
236:
237: END;
238:
239: IF (PO_LOG.d_proc) THEN
240: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
241: PO_LOG.proc_end(d_module);
242: END IF;
243:

Line 240: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);

236:
237: END;
238:
239: IF (PO_LOG.d_proc) THEN
240: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
241: PO_LOG.proc_end(d_module);
242: END IF;
243:
244: RETURN;

Line 241: PO_LOG.proc_end(d_module);

237: END;
238:
239: IF (PO_LOG.d_proc) THEN
240: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
241: PO_LOG.proc_end(d_module);
242: END IF;
243:
244: RETURN;
245:

Line 251: IF (PO_LOG.d_exc) THEN

247: WHEN OTHERS THEN
248: p_action_ctl_rec.return_status := 'U';
249:
250: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
251: IF (PO_LOG.d_exc) THEN
252: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
253: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
254: PO_LOG.proc_end(d_module);
255: END IF;

Line 252: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

248: p_action_ctl_rec.return_status := 'U';
249:
250: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
251: IF (PO_LOG.d_exc) THEN
252: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
253: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
254: PO_LOG.proc_end(d_module);
255: END IF;
256:

Line 253: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);

249:
250: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
251: IF (PO_LOG.d_exc) THEN
252: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
253: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
254: PO_LOG.proc_end(d_module);
255: END IF;
256:
257: RETURN;

Line 254: PO_LOG.proc_end(d_module);

250: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
251: IF (PO_LOG.d_exc) THEN
252: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
253: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
254: PO_LOG.proc_end(d_module);
255: END IF;
256:
257: RETURN;
258:

Line 317: IF (PO_LOG.d_proc) THEN

313:
314: BEGIN
315:
316: d_progress := 0;
317: IF (PO_LOG.d_proc) THEN
318: PO_LOG.proc_begin(d_module);
319: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
320: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
321: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);

Line 318: PO_LOG.proc_begin(d_module);

314: BEGIN
315:
316: d_progress := 0;
317: IF (PO_LOG.d_proc) THEN
318: PO_LOG.proc_begin(d_module);
319: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
320: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
321: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
322: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.draft_id', p_action_ctl_rec.draft_id); --CLM Apprvl

Line 319: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);

315:
316: d_progress := 0;
317: IF (PO_LOG.d_proc) THEN
318: PO_LOG.proc_begin(d_module);
319: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
320: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
321: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
322: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.draft_id', p_action_ctl_rec.draft_id); --CLM Apprvl
323: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);

Line 320: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);

316: d_progress := 0;
317: IF (PO_LOG.d_proc) THEN
318: PO_LOG.proc_begin(d_module);
319: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
320: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
321: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
322: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.draft_id', p_action_ctl_rec.draft_id); --CLM Apprvl
323: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
324: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.forward_to_id', p_action_ctl_rec.forward_to_id);

Line 321: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);

317: IF (PO_LOG.d_proc) THEN
318: PO_LOG.proc_begin(d_module);
319: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
320: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
321: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
322: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.draft_id', p_action_ctl_rec.draft_id); --CLM Apprvl
323: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
324: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.forward_to_id', p_action_ctl_rec.forward_to_id);
325: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.approval_path_id', p_action_ctl_rec.approval_path_id);

Line 322: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.draft_id', p_action_ctl_rec.draft_id); --CLM Apprvl

318: PO_LOG.proc_begin(d_module);
319: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
320: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
321: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
322: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.draft_id', p_action_ctl_rec.draft_id); --CLM Apprvl
323: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
324: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.forward_to_id', p_action_ctl_rec.forward_to_id);
325: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.approval_path_id', p_action_ctl_rec.approval_path_id);
326: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.note', p_action_ctl_rec.note);

Line 323: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);

319: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
320: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
321: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
322: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.draft_id', p_action_ctl_rec.draft_id); --CLM Apprvl
323: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
324: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.forward_to_id', p_action_ctl_rec.forward_to_id);
325: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.approval_path_id', p_action_ctl_rec.approval_path_id);
326: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.note', p_action_ctl_rec.note);
327: END IF;

Line 324: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.forward_to_id', p_action_ctl_rec.forward_to_id);

320: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
321: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
322: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.draft_id', p_action_ctl_rec.draft_id); --CLM Apprvl
323: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
324: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.forward_to_id', p_action_ctl_rec.forward_to_id);
325: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.approval_path_id', p_action_ctl_rec.approval_path_id);
326: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.note', p_action_ctl_rec.note);
327: END IF;
328:

Line 325: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.approval_path_id', p_action_ctl_rec.approval_path_id);

321: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
322: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.draft_id', p_action_ctl_rec.draft_id); --CLM Apprvl
323: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
324: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.forward_to_id', p_action_ctl_rec.forward_to_id);
325: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.approval_path_id', p_action_ctl_rec.approval_path_id);
326: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.note', p_action_ctl_rec.note);
327: END IF;
328:
329: d_progress := 10;

Line 326: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.note', p_action_ctl_rec.note);

322: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.draft_id', p_action_ctl_rec.draft_id); --CLM Apprvl
323: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
324: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.forward_to_id', p_action_ctl_rec.forward_to_id);
325: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.approval_path_id', p_action_ctl_rec.approval_path_id);
326: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.note', p_action_ctl_rec.note);
327: END IF;
328:
329: d_progress := 10;
330:

Line 384: IF (PO_LOG.d_stmt) THEN

380: END IF;
381:
382: d_progress := 70;
383:
384: IF (PO_LOG.d_stmt) THEN
385: PO_LOG.stmt(d_module, d_progress, 'l_preparer_id', l_preparer_id);
386: END IF;
387:
388:

Line 385: PO_LOG.stmt(d_module, d_progress, 'l_preparer_id', l_preparer_id);

381:
382: d_progress := 70;
383:
384: IF (PO_LOG.d_stmt) THEN
385: PO_LOG.stmt(d_module, d_progress, 'l_preparer_id', l_preparer_id);
386: END IF;
387:
388:
389: IF ( PO_CORE_S.is_encumbrance_on(

Line 420: IF (PO_LOG.d_stmt) THEN

416: WHERE po_header_id = p_action_ctl_rec.document_id;
417:
418: END IF;
419:
420: IF (PO_LOG.d_stmt) THEN
421: PO_LOG.stmt(d_module, d_progress, 'l_enc_flag', l_enc_flag);
422: END IF;
423:
424:

Line 421: PO_LOG.stmt(d_module, d_progress, 'l_enc_flag', l_enc_flag);

417:
418: END IF;
419:
420: IF (PO_LOG.d_stmt) THEN
421: PO_LOG.stmt(d_module, d_progress, 'l_enc_flag', l_enc_flag);
422: END IF;
423:
424:
425: IF ((l_enc_flag = 'Y') AND (p_action_ctl_rec.document_subtype <> 'CONTRACT')) -- bug 8498264

Line 457: IF (PO_LOG.d_stmt) THEN

453: END IF;
454:
455: d_progress := 120;
456:
457: IF (PO_LOG.d_stmt) THEN
458: PO_LOG.stmt(d_module, d_progress, 'l_enc_ret_code', l_enc_ret_code);
459: PO_LOG.stmt(d_module, d_progress, 'l_enc_report_id', l_enc_report_id);
460: END IF;
461:

Line 458: PO_LOG.stmt(d_module, d_progress, 'l_enc_ret_code', l_enc_ret_code);

454:
455: d_progress := 120;
456:
457: IF (PO_LOG.d_stmt) THEN
458: PO_LOG.stmt(d_module, d_progress, 'l_enc_ret_code', l_enc_ret_code);
459: PO_LOG.stmt(d_module, d_progress, 'l_enc_report_id', l_enc_report_id);
460: END IF;
461:
462: p_action_ctl_rec.online_report_id := l_enc_report_id;

Line 459: PO_LOG.stmt(d_module, d_progress, 'l_enc_report_id', l_enc_report_id);

455: d_progress := 120;
456:
457: IF (PO_LOG.d_stmt) THEN
458: PO_LOG.stmt(d_module, d_progress, 'l_enc_ret_code', l_enc_ret_code);
459: PO_LOG.stmt(d_module, d_progress, 'l_enc_report_id', l_enc_report_id);
460: END IF;
461:
462: p_action_ctl_rec.online_report_id := l_enc_report_id;
463:

Line 511: IF (PO_LOG.d_stmt) THEN

507: END IF; -- if l_enc_flag = 'Y' ...
508:
509: d_progress := 170;
510:
511: IF (PO_LOG.d_stmt) THEN
512: PO_LOG.stmt(d_module, d_progress, 'Calling change_doc_auth_state');
513: END IF;
514:
515: PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state(

Line 512: PO_LOG.stmt(d_module, d_progress, 'Calling change_doc_auth_state');

508:
509: d_progress := 170;
510:
511: IF (PO_LOG.d_stmt) THEN
512: PO_LOG.stmt(d_module, d_progress, 'Calling change_doc_auth_state');
513: END IF;
514:
515: PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state(
516: p_document_id => p_action_ctl_rec.document_id

Line 563: -- IF (PO_LOG.d_stmt) THEN

559: -- RAISE PO_CORE_S.g_early_return_exc;
560: -- END IF;
561: --
562: -- d_progress := 200;
563: -- IF (PO_LOG.d_stmt) THEN
564: -- PO_LOG.stmt(d_module, d_progress, 'l_supply_action', l_supply_action);
565: -- END IF;
566: --
567: -- l_bool_ret_sts :=

Line 564: -- PO_LOG.stmt(d_module, d_progress, 'l_supply_action', l_supply_action);

560: -- END IF;
561: --
562: -- d_progress := 200;
563: -- IF (PO_LOG.d_stmt) THEN
564: -- PO_LOG.stmt(d_module, d_progress, 'l_supply_action', l_supply_action);
565: -- END IF;
566: --
567: -- l_bool_ret_sts :=
568: -- PO_SUPPLY.po_req_supply(

Line 594: IF (PO_LOG.d_exc) THEN

590: EXCEPTION
591: WHEN PO_CORE_S.g_early_return_exc THEN
592: IF (p_action_ctl_rec.return_status = 'U')
593: THEN
594: IF (PO_LOG.d_exc) THEN
595: PO_LOG.exc(d_module, d_progress, l_err_msg);
596: END IF;
597: END IF;
598:

Line 595: PO_LOG.exc(d_module, d_progress, l_err_msg);

591: WHEN PO_CORE_S.g_early_return_exc THEN
592: IF (p_action_ctl_rec.return_status = 'U')
593: THEN
594: IF (PO_LOG.d_exc) THEN
595: PO_LOG.exc(d_module, d_progress, l_err_msg);
596: END IF;
597: END IF;
598:
599: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);

Line 603: IF (PO_LOG.d_proc) THEN

599: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
600:
601: END;
602:
603: IF (PO_LOG.d_proc) THEN
604: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
605: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
606: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.online_report_id', p_action_ctl_rec.online_report_id);
607: PO_LOG.proc_end(d_module);

Line 604: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);

600:
601: END;
602:
603: IF (PO_LOG.d_proc) THEN
604: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
605: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
606: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.online_report_id', p_action_ctl_rec.online_report_id);
607: PO_LOG.proc_end(d_module);
608: END IF;

Line 605: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);

601: END;
602:
603: IF (PO_LOG.d_proc) THEN
604: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
605: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
606: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.online_report_id', p_action_ctl_rec.online_report_id);
607: PO_LOG.proc_end(d_module);
608: END IF;
609:

Line 606: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.online_report_id', p_action_ctl_rec.online_report_id);

602:
603: IF (PO_LOG.d_proc) THEN
604: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
605: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
606: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.online_report_id', p_action_ctl_rec.online_report_id);
607: PO_LOG.proc_end(d_module);
608: END IF;
609:
610: RETURN;

Line 607: PO_LOG.proc_end(d_module);

603: IF (PO_LOG.d_proc) THEN
604: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
605: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
606: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.online_report_id', p_action_ctl_rec.online_report_id);
607: PO_LOG.proc_end(d_module);
608: END IF;
609:
610: RETURN;
611:

Line 617: IF (PO_LOG.d_exc) THEN

613: WHEN OTHERS THEN
614: p_action_ctl_rec.return_status := 'U';
615:
616: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
617: IF (PO_LOG.d_exc) THEN
618: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
619: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
620: PO_LOG.proc_end(d_module);
621: END IF;

Line 618: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

614: p_action_ctl_rec.return_status := 'U';
615:
616: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
617: IF (PO_LOG.d_exc) THEN
618: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
619: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
620: PO_LOG.proc_end(d_module);
621: END IF;
622:

Line 619: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);

615:
616: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
617: IF (PO_LOG.d_exc) THEN
618: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
619: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
620: PO_LOG.proc_end(d_module);
621: END IF;
622:
623: RETURN;

Line 620: PO_LOG.proc_end(d_module);

616: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
617: IF (PO_LOG.d_exc) THEN
618: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
619: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
620: PO_LOG.proc_end(d_module);
621: END IF;
622:
623: RETURN;
624:

Line 670: IF (PO_LOG.d_proc) THEN

666:
667: BEGIN
668:
669: d_progress := 0;
670: IF (PO_LOG.d_proc) THEN
671: PO_LOG.proc_begin(d_module);
672: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
673: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
674: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);

Line 671: PO_LOG.proc_begin(d_module);

667: BEGIN
668:
669: d_progress := 0;
670: IF (PO_LOG.d_proc) THEN
671: PO_LOG.proc_begin(d_module);
672: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
673: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
674: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
675: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);

Line 672: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);

668:
669: d_progress := 0;
670: IF (PO_LOG.d_proc) THEN
671: PO_LOG.proc_begin(d_module);
672: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
673: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
674: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
675: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
676: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.forward_to_id', p_action_ctl_rec.forward_to_id);

Line 673: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);

669: d_progress := 0;
670: IF (PO_LOG.d_proc) THEN
671: PO_LOG.proc_begin(d_module);
672: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
673: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
674: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
675: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
676: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.forward_to_id', p_action_ctl_rec.forward_to_id);
677: END IF;

Line 674: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);

670: IF (PO_LOG.d_proc) THEN
671: PO_LOG.proc_begin(d_module);
672: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
673: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
674: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
675: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
676: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.forward_to_id', p_action_ctl_rec.forward_to_id);
677: END IF;
678:

Line 675: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);

671: PO_LOG.proc_begin(d_module);
672: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
673: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
674: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
675: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
676: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.forward_to_id', p_action_ctl_rec.forward_to_id);
677: END IF;
678:
679: d_progress := 10;

Line 676: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.forward_to_id', p_action_ctl_rec.forward_to_id);

672: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
673: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
674: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
675: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
676: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.forward_to_id', p_action_ctl_rec.forward_to_id);
677: END IF;
678:
679: d_progress := 10;
680:

Line 683: IF (PO_LOG.d_stmt) THEN

679: d_progress := 10;
680:
681: BEGIN
682:
683: IF (PO_LOG.d_stmt) THEN
684: PO_LOG.stmt(d_module, d_progress, 'Calling change_doc_auth_state');
685: END IF;
686:
687: PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state(

Line 684: PO_LOG.stmt(d_module, d_progress, 'Calling change_doc_auth_state');

680:
681: BEGIN
682:
683: IF (PO_LOG.d_stmt) THEN
684: PO_LOG.stmt(d_module, d_progress, 'Calling change_doc_auth_state');
685: END IF;
686:
687: PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state(
688: p_document_id => p_action_ctl_rec.document_id

Line 716: IF (PO_LOG.d_exc) THEN

712: l_ret_sts := 'S';
713:
714: EXCEPTION
715: WHEN PO_CORE_S.g_early_return_exc THEN
716: IF (PO_LOG.d_exc) THEN
717: PO_LOG.exc(d_module, d_progress, l_err_msg);
718: END IF;
719: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
720:

Line 717: PO_LOG.exc(d_module, d_progress, l_err_msg);

713:
714: EXCEPTION
715: WHEN PO_CORE_S.g_early_return_exc THEN
716: IF (PO_LOG.d_exc) THEN
717: PO_LOG.exc(d_module, d_progress, l_err_msg);
718: END IF;
719: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
720:
721: END;

Line 724: IF (PO_LOG.d_proc) THEN

720:
721: END;
722:
723: p_action_ctl_rec.return_status := l_ret_sts;
724: IF (PO_LOG.d_proc) THEN
725: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
726: PO_LOG.proc_end(d_module);
727: END IF;
728:

Line 725: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);

721: END;
722:
723: p_action_ctl_rec.return_status := l_ret_sts;
724: IF (PO_LOG.d_proc) THEN
725: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
726: PO_LOG.proc_end(d_module);
727: END IF;
728:
729: RETURN;

Line 726: PO_LOG.proc_end(d_module);

722:
723: p_action_ctl_rec.return_status := l_ret_sts;
724: IF (PO_LOG.d_proc) THEN
725: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
726: PO_LOG.proc_end(d_module);
727: END IF;
728:
729: RETURN;
730:

Line 736: IF (PO_LOG.d_exc) THEN

732: WHEN OTHERS THEN
733: p_action_ctl_rec.return_status := 'U';
734:
735: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
736: IF (PO_LOG.d_exc) THEN
737: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
738: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
739: PO_LOG.proc_end(d_module);
740: END IF;

Line 737: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

733: p_action_ctl_rec.return_status := 'U';
734:
735: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
736: IF (PO_LOG.d_exc) THEN
737: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
738: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
739: PO_LOG.proc_end(d_module);
740: END IF;
741:

Line 738: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);

734:
735: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
736: IF (PO_LOG.d_exc) THEN
737: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
738: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
739: PO_LOG.proc_end(d_module);
740: END IF;
741:
742: RETURN;

Line 739: PO_LOG.proc_end(d_module);

735: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
736: IF (PO_LOG.d_exc) THEN
737: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
738: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
739: PO_LOG.proc_end(d_module);
740: END IF;
741:
742: RETURN;
743:

Line 802: IF (PO_LOG.d_proc) THEN

798:
799: BEGIN
800:
801: d_progress := 0;
802: IF (PO_LOG.d_proc) THEN
803: PO_LOG.proc_begin(d_module);
804: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
805: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
806: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);

Line 803: PO_LOG.proc_begin(d_module);

799: BEGIN
800:
801: d_progress := 0;
802: IF (PO_LOG.d_proc) THEN
803: PO_LOG.proc_begin(d_module);
804: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
805: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
806: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
807: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);

Line 804: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);

800:
801: d_progress := 0;
802: IF (PO_LOG.d_proc) THEN
803: PO_LOG.proc_begin(d_module);
804: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
805: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
806: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
807: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
808: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.note', p_action_ctl_rec.note);

Line 805: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);

801: d_progress := 0;
802: IF (PO_LOG.d_proc) THEN
803: PO_LOG.proc_begin(d_module);
804: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
805: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
806: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
807: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
808: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.note', p_action_ctl_rec.note);
809: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.approval_path_id', p_action_ctl_rec.approval_path_id);

Line 806: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);

802: IF (PO_LOG.d_proc) THEN
803: PO_LOG.proc_begin(d_module);
804: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
805: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
806: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
807: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
808: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.note', p_action_ctl_rec.note);
809: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.approval_path_id', p_action_ctl_rec.approval_path_id);
810: END IF;

Line 807: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);

803: PO_LOG.proc_begin(d_module);
804: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
805: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
806: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
807: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
808: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.note', p_action_ctl_rec.note);
809: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.approval_path_id', p_action_ctl_rec.approval_path_id);
810: END IF;
811:

Line 808: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.note', p_action_ctl_rec.note);

804: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_id', p_action_ctl_rec.document_id);
805: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
806: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
807: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
808: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.note', p_action_ctl_rec.note);
809: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.approval_path_id', p_action_ctl_rec.approval_path_id);
810: END IF;
811:
812: d_progress := 10;

Line 809: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.approval_path_id', p_action_ctl_rec.approval_path_id);

805: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_type', p_action_ctl_rec.document_type);
806: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.document_subtype', p_action_ctl_rec.document_subtype);
807: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.action', p_action_ctl_rec.action);
808: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.note', p_action_ctl_rec.note);
809: PO_LOG.proc_begin(d_module, 'p_action_ctl_rec.approval_path_id', p_action_ctl_rec.approval_path_id);
810: END IF;
811:
812: d_progress := 10;
813:

Line 870: IF (PO_LOG.d_stmt) THEN

866: , p_org_id => NULL
867: );
868:
869: d_progress := 60;
870: IF (PO_LOG.d_stmt) THEN
871: PO_LOG.stmt(d_module, d_progress, 'l_req_enc_on', l_req_enc_on);
872: END IF;
873:
874: IF (l_req_enc_on)

Line 871: PO_LOG.stmt(d_module, d_progress, 'l_req_enc_on', l_req_enc_on);

867: );
868:
869: d_progress := 60;
870: IF (PO_LOG.d_stmt) THEN
871: PO_LOG.stmt(d_module, d_progress, 'l_req_enc_on', l_req_enc_on);
872: END IF;
873:
874: IF (l_req_enc_on)
875: ---Bug#14332568 : Added below condition so that The Requistion is not be un-reserved during Return action.

Line 908: IF (PO_LOG.d_stmt) THEN

904: END IF;
905:
906: d_progress := 90;
907:
908: IF (PO_LOG.d_stmt) THEN
909: PO_LOG.stmt(d_module, d_progress, 'l_enc_ret_code', l_enc_ret_code);
910: PO_LOG.stmt(d_module, d_progress, 'l_enc_report_id', l_enc_report_id);
911: END IF;
912:

Line 909: PO_LOG.stmt(d_module, d_progress, 'l_enc_ret_code', l_enc_ret_code);

905:
906: d_progress := 90;
907:
908: IF (PO_LOG.d_stmt) THEN
909: PO_LOG.stmt(d_module, d_progress, 'l_enc_ret_code', l_enc_ret_code);
910: PO_LOG.stmt(d_module, d_progress, 'l_enc_report_id', l_enc_report_id);
911: END IF;
912:
913: p_action_ctl_rec.online_report_id := l_enc_report_id;

Line 910: PO_LOG.stmt(d_module, d_progress, 'l_enc_report_id', l_enc_report_id);

906: d_progress := 90;
907:
908: IF (PO_LOG.d_stmt) THEN
909: PO_LOG.stmt(d_module, d_progress, 'l_enc_ret_code', l_enc_ret_code);
910: PO_LOG.stmt(d_module, d_progress, 'l_enc_report_id', l_enc_report_id);
911: END IF;
912:
913: p_action_ctl_rec.online_report_id := l_enc_report_id;
914:

Line 982: IF (PO_LOG.d_stmt) THEN

978: END IF;
979:
980: d_progress := 170;
981:
982: IF (PO_LOG.d_stmt) THEN
983: PO_LOG.stmt(d_module, d_progress, 'Calling change_doc_auth_state');
984: END IF;
985:
986: PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state(

Line 983: PO_LOG.stmt(d_module, d_progress, 'Calling change_doc_auth_state');

979:
980: d_progress := 170;
981:
982: IF (PO_LOG.d_stmt) THEN
983: PO_LOG.stmt(d_module, d_progress, 'Calling change_doc_auth_state');
984: END IF;
985:
986: PO_DOCUMENT_ACTION_UTIL.change_doc_auth_state(
987: p_document_id => p_action_ctl_rec.document_id

Line 1031: IF (PO_LOG.d_stmt) THEN

1027: RAISE PO_CORE_S.g_early_return_exc;
1028: END IF;
1029:
1030: d_progress := 200;
1031: IF (PO_LOG.d_stmt) THEN
1032: PO_LOG.stmt(d_module, d_progress, 'l_supply_action', l_supply_action);
1033: END IF;
1034:
1035: l_bool_ret_sts :=

Line 1032: PO_LOG.stmt(d_module, d_progress, 'l_supply_action', l_supply_action);

1028: END IF;
1029:
1030: d_progress := 200;
1031: IF (PO_LOG.d_stmt) THEN
1032: PO_LOG.stmt(d_module, d_progress, 'l_supply_action', l_supply_action);
1033: END IF;
1034:
1035: l_bool_ret_sts :=
1036: PO_SUPPLY.po_req_supply(

Line 1061: IF (PO_LOG.d_exc) THEN

1057:
1058: EXCEPTION
1059: WHEN PO_CORE_S.g_early_return_exc THEN
1060: IF (l_ret_sts = 'U') THEN
1061: IF (PO_LOG.d_exc) THEN
1062: PO_LOG.exc(d_module, d_progress, l_err_msg);
1063: END IF;
1064: END IF;
1065:

Line 1062: PO_LOG.exc(d_module, d_progress, l_err_msg);

1058: EXCEPTION
1059: WHEN PO_CORE_S.g_early_return_exc THEN
1060: IF (l_ret_sts = 'U') THEN
1061: IF (PO_LOG.d_exc) THEN
1062: PO_LOG.exc(d_module, d_progress, l_err_msg);
1063: END IF;
1064: END IF;
1065:
1066: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);

Line 1070: IF (PO_LOG.d_proc) THEN

1066: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, l_err_msg);
1067: END;
1068:
1069: p_action_ctl_rec.return_status := l_ret_sts;
1070: IF (PO_LOG.d_proc) THEN
1071: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
1072: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
1073: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.online_report_id', p_action_ctl_rec.online_report_id);
1074: PO_LOG.proc_end(d_module);

Line 1071: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);

1067: END;
1068:
1069: p_action_ctl_rec.return_status := l_ret_sts;
1070: IF (PO_LOG.d_proc) THEN
1071: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
1072: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
1073: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.online_report_id', p_action_ctl_rec.online_report_id);
1074: PO_LOG.proc_end(d_module);
1075: END IF;

Line 1072: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);

1068:
1069: p_action_ctl_rec.return_status := l_ret_sts;
1070: IF (PO_LOG.d_proc) THEN
1071: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
1072: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
1073: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.online_report_id', p_action_ctl_rec.online_report_id);
1074: PO_LOG.proc_end(d_module);
1075: END IF;
1076:

Line 1073: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.online_report_id', p_action_ctl_rec.online_report_id);

1069: p_action_ctl_rec.return_status := l_ret_sts;
1070: IF (PO_LOG.d_proc) THEN
1071: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
1072: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
1073: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.online_report_id', p_action_ctl_rec.online_report_id);
1074: PO_LOG.proc_end(d_module);
1075: END IF;
1076:
1077: RETURN;

Line 1074: PO_LOG.proc_end(d_module);

1070: IF (PO_LOG.d_proc) THEN
1071: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
1072: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_code', p_action_ctl_rec.return_code);
1073: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.online_report_id', p_action_ctl_rec.online_report_id);
1074: PO_LOG.proc_end(d_module);
1075: END IF;
1076:
1077: RETURN;
1078:

Line 1084: IF (PO_LOG.d_exc) THEN

1080: WHEN OTHERS THEN
1081: p_action_ctl_rec.return_status := 'U';
1082:
1083: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1084: IF (PO_LOG.d_exc) THEN
1085: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1086: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
1087: PO_LOG.proc_end(d_module);
1088: END IF;

Line 1085: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

1081: p_action_ctl_rec.return_status := 'U';
1082:
1083: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1084: IF (PO_LOG.d_exc) THEN
1085: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1086: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
1087: PO_LOG.proc_end(d_module);
1088: END IF;
1089:

Line 1086: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);

1082:
1083: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1084: IF (PO_LOG.d_exc) THEN
1085: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1086: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
1087: PO_LOG.proc_end(d_module);
1088: END IF;
1089:
1090: RETURN;

Line 1087: PO_LOG.proc_end(d_module);

1083: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1084: IF (PO_LOG.d_exc) THEN
1085: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1086: PO_LOG.proc_end(d_module, 'p_action_ctl_rec.return_status', p_action_ctl_rec.return_status);
1087: PO_LOG.proc_end(d_module);
1088: END IF;
1089:
1090: RETURN;
1091:

Line 1144: IF (PO_LOG.d_proc) THEN

1140:
1141: BEGIN
1142:
1143: d_progress := 0;
1144: IF (PO_LOG.d_proc) THEN
1145: PO_LOG.proc_begin(d_module);
1146: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);
1147: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);
1148: END IF;

Line 1145: PO_LOG.proc_begin(d_module);

1141: BEGIN
1142:
1143: d_progress := 0;
1144: IF (PO_LOG.d_proc) THEN
1145: PO_LOG.proc_begin(d_module);
1146: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);
1147: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);
1148: END IF;
1149:

Line 1146: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);

1142:
1143: d_progress := 0;
1144: IF (PO_LOG.d_proc) THEN
1145: PO_LOG.proc_begin(d_module);
1146: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);
1147: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);
1148: END IF;
1149:
1150: IF (p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE,

Line 1147: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);

1143: d_progress := 0;
1144: IF (PO_LOG.d_proc) THEN
1145: PO_LOG.proc_begin(d_module);
1146: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);
1147: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_subtype);
1148: END IF;
1149:
1150: IF (p_action IN (PO_DOCUMENT_ACTION_PVT.g_doc_action_APPROVE,
1151: PO_DOCUMENT_ACTION_PVT.g_doc_action_REJECT))

Line 1196: IF (PO_LOG.d_proc) THEN

1192:
1193: x_supply_action := l_supply_action;
1194: x_return_status := 'S';
1195:
1196: IF (PO_LOG.d_proc) THEN
1197: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1198: PO_LOG.proc_end(d_module, 'x_supply_action', x_supply_action);
1199: PO_LOG.proc_end(d_module);
1200: END IF;

Line 1197: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

1193: x_supply_action := l_supply_action;
1194: x_return_status := 'S';
1195:
1196: IF (PO_LOG.d_proc) THEN
1197: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1198: PO_LOG.proc_end(d_module, 'x_supply_action', x_supply_action);
1199: PO_LOG.proc_end(d_module);
1200: END IF;
1201:

Line 1198: PO_LOG.proc_end(d_module, 'x_supply_action', x_supply_action);

1194: x_return_status := 'S';
1195:
1196: IF (PO_LOG.d_proc) THEN
1197: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1198: PO_LOG.proc_end(d_module, 'x_supply_action', x_supply_action);
1199: PO_LOG.proc_end(d_module);
1200: END IF;
1201:
1202: EXCEPTION

Line 1199: PO_LOG.proc_end(d_module);

1195:
1196: IF (PO_LOG.d_proc) THEN
1197: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1198: PO_LOG.proc_end(d_module, 'x_supply_action', x_supply_action);
1199: PO_LOG.proc_end(d_module);
1200: END IF;
1201:
1202: EXCEPTION
1203: WHEN OTHERS THEN

Line 1206: IF (PO_LOG.d_exc) THEN

1202: EXCEPTION
1203: WHEN OTHERS THEN
1204: x_return_status := 'U';
1205: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1206: IF (PO_LOG.d_exc) THEN
1207: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1208: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1209: PO_LOG.proc_end(d_module);
1210: END IF;

Line 1207: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

1203: WHEN OTHERS THEN
1204: x_return_status := 'U';
1205: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1206: IF (PO_LOG.d_exc) THEN
1207: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1208: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1209: PO_LOG.proc_end(d_module);
1210: END IF;
1211:

Line 1208: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);

1204: x_return_status := 'U';
1205: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1206: IF (PO_LOG.d_exc) THEN
1207: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1208: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1209: PO_LOG.proc_end(d_module);
1210: END IF;
1211:
1212: RETURN;

Line 1209: PO_LOG.proc_end(d_module);

1205: PO_DOCUMENT_ACTION_PVT.error_msg_append(d_module, d_progress, SQLCODE, SQLERRM);
1206: IF (PO_LOG.d_exc) THEN
1207: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1208: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1209: PO_LOG.proc_end(d_module);
1210: END IF;
1211:
1212: RETURN;
1213: END get_supply_action_name;