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.

[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on PO_LOG

Line 6600: IF (PO_LOG.d_proc) THEN

6596: d_progress NUMBER;
6597: d_module VARCHAR2(70) := 'PO_COMMUNICATION_PVT.getZIPFileName';
6598: BEGIN
6599: d_progress := 0;
6600: IF (PO_LOG.d_proc) THEN
6601: PO_LOG.proc_begin(d_module);
6602: END IF;
6603:
6604: select nvl(psp.email_attachment_filename,'Attachments.zip')

Line 6601: PO_LOG.proc_begin(d_module);

6597: d_module VARCHAR2(70) := 'PO_COMMUNICATION_PVT.getZIPFileName';
6598: BEGIN
6599: d_progress := 0;
6600: IF (PO_LOG.d_proc) THEN
6601: PO_LOG.proc_begin(d_module);
6602: END IF;
6603:
6604: select nvl(psp.email_attachment_filename,'Attachments.zip')
6605: into l_email_attachment_filename

Line 6610: IF (PO_LOG.d_proc) THEN

6606: from po_system_parameters_all psp
6607: where org_id = p_org_id;
6608:
6609: d_progress := 10;
6610: IF (PO_LOG.d_proc) THEN
6611: PO_LOG.proc_begin(d_module, 'Email Attachment Filename', l_email_attachment_filename);
6612: PO_LOG.proc_end(d_module);
6613: END IF;
6614: return l_email_attachment_filename;

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

6607: where org_id = p_org_id;
6608:
6609: d_progress := 10;
6610: IF (PO_LOG.d_proc) THEN
6611: PO_LOG.proc_begin(d_module, 'Email Attachment Filename', l_email_attachment_filename);
6612: PO_LOG.proc_end(d_module);
6613: END IF;
6614: return l_email_attachment_filename;
6615: Exception

Line 6612: PO_LOG.proc_end(d_module);

6608:
6609: d_progress := 10;
6610: IF (PO_LOG.d_proc) THEN
6611: PO_LOG.proc_begin(d_module, 'Email Attachment Filename', l_email_attachment_filename);
6612: PO_LOG.proc_end(d_module);
6613: END IF;
6614: return l_email_attachment_filename;
6615: Exception
6616: when others then

Line 6617: IF (PO_LOG.d_exc) THEN

6613: END IF;
6614: return l_email_attachment_filename;
6615: Exception
6616: when others then
6617: IF (PO_LOG.d_exc) THEN
6618: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
6619: END IF;
6620: END getZIPFileName;
6621:

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

6614: return l_email_attachment_filename;
6615: Exception
6616: when others then
6617: IF (PO_LOG.d_exc) THEN
6618: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
6619: END IF;
6620: END getZIPFileName;
6621:
6622: --bug:346361

Line 6973: IF (PO_LOG.d_proc) THEN

6969: BEGIN
6970:
6971: d_progress := 0;
6972:
6973: IF (PO_LOG.d_proc) THEN
6974: PO_LOG.proc_begin(d_module);
6975: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
6976: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);
6977: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);

Line 6974: PO_LOG.proc_begin(d_module);

6970:
6971: d_progress := 0;
6972:
6973: IF (PO_LOG.d_proc) THEN
6974: PO_LOG.proc_begin(d_module);
6975: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
6976: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);
6977: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);
6978: END IF;

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

6971: d_progress := 0;
6972:
6973: IF (PO_LOG.d_proc) THEN
6974: PO_LOG.proc_begin(d_module);
6975: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
6976: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);
6977: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);
6978: END IF;
6979:

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

6972:
6973: IF (PO_LOG.d_proc) THEN
6974: PO_LOG.proc_begin(d_module);
6975: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
6976: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);
6977: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);
6978: END IF;
6979:
6980:

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

6973: IF (PO_LOG.d_proc) THEN
6974: PO_LOG.proc_begin(d_module);
6975: PO_LOG.proc_begin(d_module, 'p_document_id', p_document_id);
6976: PO_LOG.proc_begin(d_module, 'p_revision_num', p_revision_num);
6977: PO_LOG.proc_begin(d_module, 'p_which_tables', p_which_tables);
6978: END IF;
6979:
6980:
6981: IF (p_which_tables = 'MAIN') THEN

Line 7011: IF (PO_LOG.d_stmt) THEN

7007: d_progress := 30;
7008:
7009: END IF;
7010:
7011: IF (PO_LOG.d_stmt) THEN
7012: PO_LOG.stmt(d_module, d_progress, 'l_is_complex', l_is_complex);
7013: END IF;
7014:
7015: IF (l_is_complex) THEN

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

7008:
7009: END IF;
7010:
7011: IF (PO_LOG.d_stmt) THEN
7012: PO_LOG.stmt(d_module, d_progress, 'l_is_complex', l_is_complex);
7013: END IF;
7014:
7015: IF (l_is_complex) THEN
7016: g_is_complex_work_po := 'Y';

Line 7023: IF (PO_LOG.d_proc) THEN

7019: END IF;
7020:
7021: d_progress := 50;
7022:
7023: IF (PO_LOG.d_proc) THEN
7024: PO_LOG.stmt(d_module, d_progress, 'g_is_complex_work_po', g_is_complex_work_po);
7025: PO_LOG.proc_end(d_module);
7026: END IF;
7027:

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

7020:
7021: d_progress := 50;
7022:
7023: IF (PO_LOG.d_proc) THEN
7024: PO_LOG.stmt(d_module, d_progress, 'g_is_complex_work_po', g_is_complex_work_po);
7025: PO_LOG.proc_end(d_module);
7026: END IF;
7027:
7028: EXCEPTION

Line 7025: PO_LOG.proc_end(d_module);

7021: d_progress := 50;
7022:
7023: IF (PO_LOG.d_proc) THEN
7024: PO_LOG.stmt(d_module, d_progress, 'g_is_complex_work_po', g_is_complex_work_po);
7025: PO_LOG.proc_end(d_module);
7026: END IF;
7027:
7028: EXCEPTION
7029: WHEN OTHERS THEN

Line 7030: IF (PO_LOG.d_exc) THEN

7026: END IF;
7027:
7028: EXCEPTION
7029: WHEN OTHERS THEN
7030: IF (PO_LOG.d_exc) THEN
7031: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
7032: END IF;
7033: g_is_complex_work_po := 'N';
7034: END setIsComplexWorkPO;

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

7027:
7028: EXCEPTION
7029: WHEN OTHERS THEN
7030: IF (PO_LOG.d_exc) THEN
7031: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
7032: END IF;
7033: g_is_complex_work_po := 'N';
7034: END setIsComplexWorkPO;
7035:

Line 7061: IF (PO_LOG.d_exc) THEN

7057: INTO l_inventory_org_id
7058: FROM FINANCIALS_SYSTEM_PARAMETERS;
7059: EXCEPTION
7060: WHEN OTHERS THEN
7061: IF (PO_LOG.d_exc) THEN
7062: PO_LOG.exc('PO_COMMUNICATION_PVT.getInventoryOrgId', 0, SQLCODE || SQLERRM);
7063: END IF;
7064: l_inventory_org_id := null;
7065: END;

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

7058: FROM FINANCIALS_SYSTEM_PARAMETERS;
7059: EXCEPTION
7060: WHEN OTHERS THEN
7061: IF (PO_LOG.d_exc) THEN
7062: PO_LOG.exc('PO_COMMUNICATION_PVT.getInventoryOrgId', 0, SQLCODE || SQLERRM);
7063: END IF;
7064: l_inventory_org_id := null;
7065: END;
7066: return l_inventory_org_id;