DBA Data[Home] [Help]

APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PO_LOG

Line 10: D_PACKAGE_BASE CONSTANT VARCHAR2(100) := PO_LOG.get_package_base(G_PKG_NAME);

6:
7: G_PKG_NAME CONSTANT varchar2(30) := 'PO_DOCUMENT_FUNDS_PVT';
8: g_log_head CONSTANT VARCHAR2(50) := 'po.plsql.'|| G_PKG_NAME || '.';
9: -- Logging global constants
10: D_PACKAGE_BASE CONSTANT VARCHAR2(100) := PO_LOG.get_package_base(G_PKG_NAME);
11:
12:
13: -- Debugging
14:

Line 5210: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,

5206: RETURN VARCHAR2 IS
5207: l_found VARCHAR2(1);
5208: d_progress NUMBER;
5209: l_module_name CONSTANT VARCHAR2(100) := 'is_req_enc_flipped';
5210: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,
5211: l_module_name);
5212: BEGIN
5213: IF (PO_LOG.d_proc) THEN
5214: PO_LOG.proc_begin(d_module_base);

Line 5213: IF (PO_LOG.d_proc) THEN

5209: l_module_name CONSTANT VARCHAR2(100) := 'is_req_enc_flipped';
5210: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,
5211: l_module_name);
5212: BEGIN
5213: IF (PO_LOG.d_proc) THEN
5214: PO_LOG.proc_begin(d_module_base);
5215: PO_LOG.proc_begin(d_module_base, 'p_req_dist_id', p_req_dist_id);
5216: PO_LOG.proc_begin(d_module_base, 'p_event_id', p_event_id);
5217: END IF;

Line 5214: PO_LOG.proc_begin(d_module_base);

5210: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,
5211: l_module_name);
5212: BEGIN
5213: IF (PO_LOG.d_proc) THEN
5214: PO_LOG.proc_begin(d_module_base);
5215: PO_LOG.proc_begin(d_module_base, 'p_req_dist_id', p_req_dist_id);
5216: PO_LOG.proc_begin(d_module_base, 'p_event_id', p_event_id);
5217: END IF;
5218:

Line 5215: PO_LOG.proc_begin(d_module_base, 'p_req_dist_id', p_req_dist_id);

5211: l_module_name);
5212: BEGIN
5213: IF (PO_LOG.d_proc) THEN
5214: PO_LOG.proc_begin(d_module_base);
5215: PO_LOG.proc_begin(d_module_base, 'p_req_dist_id', p_req_dist_id);
5216: PO_LOG.proc_begin(d_module_base, 'p_event_id', p_event_id);
5217: END IF;
5218:
5219: d_progress := 0;

Line 5216: PO_LOG.proc_begin(d_module_base, 'p_event_id', p_event_id);

5212: BEGIN
5213: IF (PO_LOG.d_proc) THEN
5214: PO_LOG.proc_begin(d_module_base);
5215: PO_LOG.proc_begin(d_module_base, 'p_req_dist_id', p_req_dist_id);
5216: PO_LOG.proc_begin(d_module_base, 'p_event_id', p_event_id);
5217: END IF;
5218:
5219: d_progress := 0;
5220:

Line 5234: IF (PO_LOG.d_exc) THEN

5230: and pod.po_header_id = prl.blanket_po_header_id
5231: and pod.distribution_type=g_dist_type_AGREEMENT;--bug#5468417
5232: exception
5233: when others then
5234: IF (PO_LOG.d_exc) THEN
5235: PO_LOG.exc(d_module_base, d_progress, SQLCODE || SQLERRM);
5236: END IF;
5237: l_found := 'N';
5238: end;

Line 5235: PO_LOG.exc(d_module_base, d_progress, SQLCODE || SQLERRM);

5231: and pod.distribution_type=g_dist_type_AGREEMENT;--bug#5468417
5232: exception
5233: when others then
5234: IF (PO_LOG.d_exc) THEN
5235: PO_LOG.exc(d_module_base, d_progress, SQLCODE || SQLERRM);
5236: END IF;
5237: l_found := 'N';
5238: end;
5239: d_progress := 1;

Line 5240: IF (PO_LOG.d_proc) THEN

5236: END IF;
5237: l_found := 'N';
5238: end;
5239: d_progress := 1;
5240: IF (PO_LOG.d_proc) THEN
5241: PO_LOG.proc_end(d_module_base);
5242: PO_LOG.proc_end(d_module_base, 'l_found', l_found);
5243: END IF;
5244: return l_found;

Line 5241: PO_LOG.proc_end(d_module_base);

5237: l_found := 'N';
5238: end;
5239: d_progress := 1;
5240: IF (PO_LOG.d_proc) THEN
5241: PO_LOG.proc_end(d_module_base);
5242: PO_LOG.proc_end(d_module_base, 'l_found', l_found);
5243: END IF;
5244: return l_found;
5245: END;

Line 5242: PO_LOG.proc_end(d_module_base, 'l_found', l_found);

5238: end;
5239: d_progress := 1;
5240: IF (PO_LOG.d_proc) THEN
5241: PO_LOG.proc_end(d_module_base);
5242: PO_LOG.proc_end(d_module_base, 'l_found', l_found);
5243: END IF;
5244: return l_found;
5245: END;
5246: --