DBA Data[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on PO_LOG

Line 7792: IF (PO_LOG.d_proc) THEN

7788: d_progress NUMBER;
7789: d_module VARCHAR2(70) := 'PO_COMMUNICATION_PVT.getZIPFileName';
7790: BEGIN
7791: d_progress := 0;
7792: IF (PO_LOG.d_proc) THEN
7793: PO_LOG.proc_begin(d_module);
7794: END IF;
7795:
7796: select nvl(psp.email_attachment_filename, 'Attachments.zip')

Line 7793: PO_LOG.proc_begin(d_module);

7789: d_module VARCHAR2(70) := 'PO_COMMUNICATION_PVT.getZIPFileName';
7790: BEGIN
7791: d_progress := 0;
7792: IF (PO_LOG.d_proc) THEN
7793: PO_LOG.proc_begin(d_module);
7794: END IF;
7795:
7796: select nvl(psp.email_attachment_filename, 'Attachments.zip')
7797: into l_email_attachment_filename

Line 7802: IF (PO_LOG.d_proc) THEN

7798: from po_system_parameters_all psp
7799: where org_id = p_org_id;
7800:
7801: d_progress := 10;
7802: IF (PO_LOG.d_proc) THEN
7803: PO_LOG.proc_begin(d_module, 'Email Attachment Filename', l_email_attachment_filename);
7804: PO_LOG.proc_end(d_module);
7805: END IF;
7806: return l_email_attachment_filename;

Line 7803: PO_LOG.proc_begin(d_module, 'Email Attachment Filename', l_email_attachment_filename);

7799: where org_id = p_org_id;
7800:
7801: d_progress := 10;
7802: IF (PO_LOG.d_proc) THEN
7803: PO_LOG.proc_begin(d_module, 'Email Attachment Filename', l_email_attachment_filename);
7804: PO_LOG.proc_end(d_module);
7805: END IF;
7806: return l_email_attachment_filename;
7807: Exception

Line 7804: PO_LOG.proc_end(d_module);

7800:
7801: d_progress := 10;
7802: IF (PO_LOG.d_proc) THEN
7803: PO_LOG.proc_begin(d_module, 'Email Attachment Filename', l_email_attachment_filename);
7804: PO_LOG.proc_end(d_module);
7805: END IF;
7806: return l_email_attachment_filename;
7807: Exception
7808: when others then

Line 7809: IF (PO_LOG.d_exc) THEN

7805: END IF;
7806: return l_email_attachment_filename;
7807: Exception
7808: when others then
7809: IF (PO_LOG.d_exc) THEN
7810: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
7811: END IF;
7812: END getZIPFileName;
7813:

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

7806: return l_email_attachment_filename;
7807: Exception
7808: when others then
7809: IF (PO_LOG.d_exc) THEN
7810: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
7811: END IF;
7812: END getZIPFileName;
7813:
7814: --bug:346361

Line 8168: IF (PO_LOG.d_proc) THEN

8164: BEGIN
8165:
8166: d_progress := 0;
8167:
8168: IF (PO_LOG.d_proc) THEN
8169: PO_LOG.proc_begin(d_module);
8170: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
8171: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);
8172: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);

Line 8169: PO_LOG.proc_begin(d_module);

8165:
8166: d_progress := 0;
8167:
8168: IF (PO_LOG.d_proc) THEN
8169: PO_LOG.proc_begin(d_module);
8170: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
8171: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);
8172: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);
8173: END IF;

Line 8170: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);

8166: d_progress := 0;
8167:
8168: IF (PO_LOG.d_proc) THEN
8169: PO_LOG.proc_begin(d_module);
8170: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
8171: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);
8172: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);
8173: END IF;
8174:

Line 8171: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);

8167:
8168: IF (PO_LOG.d_proc) THEN
8169: PO_LOG.proc_begin(d_module);
8170: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
8171: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);
8172: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);
8173: END IF;
8174:
8175:

Line 8172: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);

8168: IF (PO_LOG.d_proc) THEN
8169: PO_LOG.proc_begin(d_module);
8170: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
8171: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);
8172: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);
8173: END IF;
8174:
8175:
8176: IF (p_which_tables = 'MAIN') THEN

Line 8206: IF (PO_LOG.d_stmt) THEN

8202: d_progress := 30;
8203:
8204: END IF;
8205:
8206: IF (PO_LOG.d_stmt) THEN
8207: PO_LOG.stmt(d_module, d_progress, 'l_is_complex', l_is_complex);
8208: END IF;
8209:
8210: IF (l_is_complex) THEN

Line 8207: PO_LOG.stmt(d_module, d_progress, 'l_is_complex', l_is_complex);

8203:
8204: END IF;
8205:
8206: IF (PO_LOG.d_stmt) THEN
8207: PO_LOG.stmt(d_module, d_progress, 'l_is_complex', l_is_complex);
8208: END IF;
8209:
8210: IF (l_is_complex) THEN
8211: g_is_complex_work_po := 'Y';

Line 8218: IF (PO_LOG.d_proc) THEN

8214: END IF;
8215:
8216: d_progress := 50;
8217:
8218: IF (PO_LOG.d_proc) THEN
8219: PO_LOG.stmt(d_module, d_progress, 'g_is_complex_work_po', g_is_complex_work_po);
8220: PO_LOG.proc_end(d_module);
8221: END IF;
8222:

Line 8219: PO_LOG.stmt(d_module, d_progress, 'g_is_complex_work_po', g_is_complex_work_po);

8215:
8216: d_progress := 50;
8217:
8218: IF (PO_LOG.d_proc) THEN
8219: PO_LOG.stmt(d_module, d_progress, 'g_is_complex_work_po', g_is_complex_work_po);
8220: PO_LOG.proc_end(d_module);
8221: END IF;
8222:
8223: EXCEPTION

Line 8220: PO_LOG.proc_end(d_module);

8216: d_progress := 50;
8217:
8218: IF (PO_LOG.d_proc) THEN
8219: PO_LOG.stmt(d_module, d_progress, 'g_is_complex_work_po', g_is_complex_work_po);
8220: PO_LOG.proc_end(d_module);
8221: END IF;
8222:
8223: EXCEPTION
8224: WHEN OTHERS THEN

Line 8225: IF (PO_LOG.d_exc) THEN

8221: END IF;
8222:
8223: EXCEPTION
8224: WHEN OTHERS THEN
8225: IF (PO_LOG.d_exc) THEN
8226: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
8227: END IF;
8228: g_is_complex_work_po := 'N';
8229: END setIsComplexWorkPO;

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

8222:
8223: EXCEPTION
8224: WHEN OTHERS THEN
8225: IF (PO_LOG.d_exc) THEN
8226: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
8227: END IF;
8228: g_is_complex_work_po := 'N';
8229: END setIsComplexWorkPO;
8230:

Line 8256: IF (PO_LOG.d_exc) THEN

8252: INTO l_inventory_org_id
8253: FROM FINANCIALS_SYSTEM_PARAMETERS;
8254: EXCEPTION
8255: WHEN OTHERS THEN
8256: IF (PO_LOG.d_exc) THEN
8257: PO_LOG.exc('PO_COMMUNICATION_PVT.getInventoryOrgId', 0, SQLCODE || SQLERRM);
8258: END IF;
8259: l_inventory_org_id := null;
8260: END;

Line 8257: PO_LOG.exc('PO_COMMUNICATION_PVT.getInventoryOrgId', 0, SQLCODE || SQLERRM);

8253: FROM FINANCIALS_SYSTEM_PARAMETERS;
8254: EXCEPTION
8255: WHEN OTHERS THEN
8256: IF (PO_LOG.d_exc) THEN
8257: PO_LOG.exc('PO_COMMUNICATION_PVT.getInventoryOrgId', 0, SQLCODE || SQLERRM);
8258: END IF;
8259: l_inventory_org_id := null;
8260: END;
8261: return l_inventory_org_id;