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_CHECKS_GRP dependencies on PO_LOG

Line 1765: IF (PO_LOG.d_proc) THEN

1761: l_is_price_updateable BOOLEAN;
1762:
1763: BEGIN
1764: d_progress := 0;
1765: IF (PO_LOG.d_proc) THEN
1766: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
1767: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1768: PO_LOG.proc_begin(d_module, 'p_add_reasons_to_msg_list', p_add_reasons_to_msg_list);
1769: END IF;

Line 1766: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);

1762:
1763: BEGIN
1764: d_progress := 0;
1765: IF (PO_LOG.d_proc) THEN
1766: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
1767: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1768: PO_LOG.proc_begin(d_module, 'p_add_reasons_to_msg_list', p_add_reasons_to_msg_list);
1769: END IF;
1770:

Line 1767: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);

1763: BEGIN
1764: d_progress := 0;
1765: IF (PO_LOG.d_proc) THEN
1766: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
1767: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1768: PO_LOG.proc_begin(d_module, 'p_add_reasons_to_msg_list', p_add_reasons_to_msg_list);
1769: END IF;
1770:
1771: d_progress := 10;

Line 1768: PO_LOG.proc_begin(d_module, 'p_add_reasons_to_msg_list', p_add_reasons_to_msg_list);

1764: d_progress := 0;
1765: IF (PO_LOG.d_proc) THEN
1766: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
1767: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1768: PO_LOG.proc_begin(d_module, 'p_add_reasons_to_msg_list', p_add_reasons_to_msg_list);
1769: END IF;
1770:
1771: d_progress := 10;
1772:

Line 1789: IF (PO_LOG.d_proc) THEN

1785: END IF;
1786:
1787: d_progress := 30;
1788:
1789: IF (PO_LOG.d_proc) THEN
1790: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1791: PO_LOG.proc_end(d_module, 'x_price_updateable', x_price_updateable);
1792: PO_LOG.proc_end(d_module);
1793: END IF;

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

1786:
1787: d_progress := 30;
1788:
1789: IF (PO_LOG.d_proc) THEN
1790: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1791: PO_LOG.proc_end(d_module, 'x_price_updateable', x_price_updateable);
1792: PO_LOG.proc_end(d_module);
1793: END IF;
1794:

Line 1791: PO_LOG.proc_end(d_module, 'x_price_updateable', x_price_updateable);

1787: d_progress := 30;
1788:
1789: IF (PO_LOG.d_proc) THEN
1790: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1791: PO_LOG.proc_end(d_module, 'x_price_updateable', x_price_updateable);
1792: PO_LOG.proc_end(d_module);
1793: END IF;
1794:
1795: EXCEPTION

Line 1792: PO_LOG.proc_end(d_module);

1788:
1789: IF (PO_LOG.d_proc) THEN
1790: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1791: PO_LOG.proc_end(d_module, 'x_price_updateable', x_price_updateable);
1792: PO_LOG.proc_end(d_module);
1793: END IF;
1794:
1795: EXCEPTION
1796: WHEN OTHERS THEN

Line 1797: IF (PO_LOG.d_exc) THEN

1793: END IF;
1794:
1795: EXCEPTION
1796: WHEN OTHERS THEN
1797: IF (PO_LOG.d_exc) THEN
1798: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1799: PO_LOG.proc_end(d_module);
1800: END IF;
1801: x_return_status := FND_API.g_ret_sts_unexp_error;

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

1794:
1795: EXCEPTION
1796: WHEN OTHERS THEN
1797: IF (PO_LOG.d_exc) THEN
1798: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1799: PO_LOG.proc_end(d_module);
1800: END IF;
1801: x_return_status := FND_API.g_ret_sts_unexp_error;
1802: x_price_updateable := PO_CORE_S.g_parameter_no;

Line 1799: PO_LOG.proc_end(d_module);

1795: EXCEPTION
1796: WHEN OTHERS THEN
1797: IF (PO_LOG.d_exc) THEN
1798: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1799: PO_LOG.proc_end(d_module);
1800: END IF;
1801: x_return_status := FND_API.g_ret_sts_unexp_error;
1802: x_price_updateable := PO_CORE_S.g_parameter_no;
1803: END;

Line 1830: IF (PO_LOG.d_proc) THEN

1826: l_id2_seq_list PO_TBL_NUMBER; -- list for all sequence numbers of report 2
1827:
1828: BEGIN
1829: d_progress := 0;
1830: IF (PO_LOG.d_proc) THEN
1831: PO_LOG.proc_begin(d_module, 'p_report_id1', p_report_id1);
1832: PO_LOG.proc_begin(d_module, 'p_report_id2', p_report_id2);
1833: END IF;
1834:

Line 1831: PO_LOG.proc_begin(d_module, 'p_report_id1', p_report_id1);

1827:
1828: BEGIN
1829: d_progress := 0;
1830: IF (PO_LOG.d_proc) THEN
1831: PO_LOG.proc_begin(d_module, 'p_report_id1', p_report_id1);
1832: PO_LOG.proc_begin(d_module, 'p_report_id2', p_report_id2);
1833: END IF;
1834:
1835: d_progress := 10;

Line 1832: PO_LOG.proc_begin(d_module, 'p_report_id2', p_report_id2);

1828: BEGIN
1829: d_progress := 0;
1830: IF (PO_LOG.d_proc) THEN
1831: PO_LOG.proc_begin(d_module, 'p_report_id1', p_report_id1);
1832: PO_LOG.proc_begin(d_module, 'p_report_id2', p_report_id2);
1833: END IF;
1834:
1835: d_progress := 10;
1836:

Line 1843: IF (PO_LOG.d_stmt) THEN

1839: SELECT po_online_report_text_s.nextval
1840: INTO x_new_report_id
1841: FROM sys.dual;
1842:
1843: IF (PO_LOG.d_stmt) THEN
1844: PO_LOG.stmt(d_module,d_progress,'After got the new id for combined online report');
1845: END IF;
1846:
1847: d_progress := 20;

Line 1844: PO_LOG.stmt(d_module,d_progress,'After got the new id for combined online report');

1840: INTO x_new_report_id
1841: FROM sys.dual;
1842:
1843: IF (PO_LOG.d_stmt) THEN
1844: PO_LOG.stmt(d_module,d_progress,'After got the new id for combined online report');
1845: END IF;
1846:
1847: d_progress := 20;
1848:

Line 1912: IF (PO_LOG.d_stmt) THEN

1908: FROM PO_ONLINE_REPORT_TEXT
1909: WHERE online_report_id = p_report_id1
1910: ORDER BY sequence ASC;
1911:
1912: IF (PO_LOG.d_stmt) THEN
1913: PO_LOG.stmt(d_module,d_progress,'After inserted data of report 1 to the combined report, #rows='||SQL%ROWCOUNT);
1914: END IF;
1915:
1916: d_progress := 30;

Line 1913: PO_LOG.stmt(d_module,d_progress,'After inserted data of report 1 to the combined report, #rows='||SQL%ROWCOUNT);

1909: WHERE online_report_id = p_report_id1
1910: ORDER BY sequence ASC;
1911:
1912: IF (PO_LOG.d_stmt) THEN
1913: PO_LOG.stmt(d_module,d_progress,'After inserted data of report 1 to the combined report, #rows='||SQL%ROWCOUNT);
1914: END IF;
1915:
1916: d_progress := 30;
1917:

Line 1925: IF (PO_LOG.d_stmt) THEN

1921: INTO l_id1_max_seq
1922: FROM PO_ONLINE_REPORT_TEXT
1923: WHERE online_report_id = p_report_id1;
1924:
1925: IF (PO_LOG.d_stmt) THEN
1926: PO_LOG.stmt(d_module,d_progress,'After got the max sequence for online report 1 rows as: '||l_id1_max_seq);
1927: END IF;
1928:
1929: d_progress := 40;

Line 1926: PO_LOG.stmt(d_module,d_progress,'After got the max sequence for online report 1 rows as: '||l_id1_max_seq);

1922: FROM PO_ONLINE_REPORT_TEXT
1923: WHERE online_report_id = p_report_id1;
1924:
1925: IF (PO_LOG.d_stmt) THEN
1926: PO_LOG.stmt(d_module,d_progress,'After got the max sequence for online report 1 rows as: '||l_id1_max_seq);
1927: END IF;
1928:
1929: d_progress := 40;
1930:

Line 1939: IF (PO_LOG.d_stmt) THEN

1935: FROM PO_ONLINE_REPORT_TEXT
1936: WHERE online_report_id = p_report_id2
1937: ORDER BY sequence ASC;
1938:
1939: IF (PO_LOG.d_stmt) THEN
1940: PO_LOG.stmt(d_module,d_progress,'After got the sequence list for online report 2');
1941: END IF;
1942:
1943: d_progress := 50;

Line 1940: PO_LOG.stmt(d_module,d_progress,'After got the sequence list for online report 2');

1936: WHERE online_report_id = p_report_id2
1937: ORDER BY sequence ASC;
1938:
1939: IF (PO_LOG.d_stmt) THEN
1940: PO_LOG.stmt(d_module,d_progress,'After got the sequence list for online report 2');
1941: END IF;
1942:
1943: d_progress := 50;
1944:

Line 2011: IF (PO_LOG.d_stmt) THEN

2007: FROM PO_ONLINE_REPORT_TEXT
2008: WHERE online_report_id = p_report_id2 and sequence = l_id2_seq_list(i);
2009: END LOOP;
2010:
2011: IF (PO_LOG.d_stmt) THEN
2012: PO_LOG.stmt(d_module,d_progress,'After inserted data of report 2 to the combined report');
2013: END IF;
2014:
2015: d_progress := 100;

Line 2012: PO_LOG.stmt(d_module,d_progress,'After inserted data of report 2 to the combined report');

2008: WHERE online_report_id = p_report_id2 and sequence = l_id2_seq_list(i);
2009: END LOOP;
2010:
2011: IF (PO_LOG.d_stmt) THEN
2012: PO_LOG.stmt(d_module,d_progress,'After inserted data of report 2 to the combined report');
2013: END IF;
2014:
2015: d_progress := 100;
2016:

Line 2017: IF (PO_LOG.d_proc) THEN

2013: END IF;
2014:
2015: d_progress := 100;
2016:
2017: IF (PO_LOG.d_proc) THEN
2018: PO_LOG.proc_end(d_module, 'x_new_report_id', x_new_report_id);
2019: END IF;
2020:
2021: EXCEPTION

Line 2018: PO_LOG.proc_end(d_module, 'x_new_report_id', x_new_report_id);

2014:
2015: d_progress := 100;
2016:
2017: IF (PO_LOG.d_proc) THEN
2018: PO_LOG.proc_end(d_module, 'x_new_report_id', x_new_report_id);
2019: END IF;
2020:
2021: EXCEPTION
2022: WHEN OTHERS THEN

Line 2023: IF (PO_LOG.d_exc) THEN

2019: END IF;
2020:
2021: EXCEPTION
2022: WHEN OTHERS THEN
2023: IF (PO_LOG.d_exc) THEN
2024: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2025: PO_LOG.proc_end(d_module);
2026: END IF;
2027: END merge_online_report_id;

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

2020:
2021: EXCEPTION
2022: WHEN OTHERS THEN
2023: IF (PO_LOG.d_exc) THEN
2024: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2025: PO_LOG.proc_end(d_module);
2026: END IF;
2027: END merge_online_report_id;
2028:

Line 2025: PO_LOG.proc_end(d_module);

2021: EXCEPTION
2022: WHEN OTHERS THEN
2023: IF (PO_LOG.d_exc) THEN
2024: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2025: PO_LOG.proc_end(d_module);
2026: END IF;
2027: END merge_online_report_id;
2028:
2029: -------------------------------------------------------------------------------

Line 2151: IF (PO_LOG.d_proc) THEN

2147: l_inv_org_id NUMBER; --bug 6713929
2148:
2149: BEGIN
2150: d_progress := 0;
2151: IF (PO_LOG.d_proc) THEN
2152: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
2153: PO_LOG.proc_begin(d_module, 'p_action_requested', p_action_requested);
2154: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2155: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);

Line 2152: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);

2148:
2149: BEGIN
2150: d_progress := 0;
2151: IF (PO_LOG.d_proc) THEN
2152: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
2153: PO_LOG.proc_begin(d_module, 'p_action_requested', p_action_requested);
2154: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2155: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2156: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);

Line 2153: PO_LOG.proc_begin(d_module, 'p_action_requested', p_action_requested);

2149: BEGIN
2150: d_progress := 0;
2151: IF (PO_LOG.d_proc) THEN
2152: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
2153: PO_LOG.proc_begin(d_module, 'p_action_requested', p_action_requested);
2154: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2155: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2156: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2157: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);

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

2150: d_progress := 0;
2151: IF (PO_LOG.d_proc) THEN
2152: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
2153: PO_LOG.proc_begin(d_module, 'p_action_requested', p_action_requested);
2154: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2155: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2156: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2157: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2158: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);

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

2151: IF (PO_LOG.d_proc) THEN
2152: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
2153: PO_LOG.proc_begin(d_module, 'p_action_requested', p_action_requested);
2154: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2155: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2156: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2157: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2158: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2159: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);

Line 2156: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);

2152: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
2153: PO_LOG.proc_begin(d_module, 'p_action_requested', p_action_requested);
2154: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2155: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2156: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2157: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2158: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2159: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2160: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);

Line 2157: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);

2153: PO_LOG.proc_begin(d_module, 'p_action_requested', p_action_requested);
2154: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2155: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2156: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2157: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2158: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2159: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2160: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2161: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);

Line 2158: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);

2154: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2155: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2156: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2157: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2158: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2159: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2160: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2161: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);
2162: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);

Line 2159: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);

2155: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2156: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2157: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2158: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2159: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2160: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2161: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);
2162: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
2163: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);

Line 2160: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);

2156: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2157: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2158: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2159: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2160: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2161: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);
2162: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
2163: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);
2164: PO_LOG.proc_begin(d_module, 'p_sob_id', p_sob_id);

Line 2161: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);

2157: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2158: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2159: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2160: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2161: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);
2162: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
2163: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);
2164: PO_LOG.proc_begin(d_module, 'p_sob_id', p_sob_id);
2165: END IF;

Line 2162: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);

2158: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2159: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2160: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2161: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);
2162: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
2163: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);
2164: PO_LOG.proc_begin(d_module, 'p_sob_id', p_sob_id);
2165: END IF;
2166:

Line 2163: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);

2159: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2160: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2161: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);
2162: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
2163: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);
2164: PO_LOG.proc_begin(d_module, 'p_sob_id', p_sob_id);
2165: END IF;
2166:
2167: d_progress := 10;

Line 2164: PO_LOG.proc_begin(d_module, 'p_sob_id', p_sob_id);

2160: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2161: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);
2162: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
2163: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);
2164: PO_LOG.proc_begin(d_module, 'p_sob_id', p_sob_id);
2165: END IF;
2166:
2167: d_progress := 10;
2168:

Line 2199: IF (PO_LOG.d_stmt) THEN

2195: ,x_inv_org_id => l_inv_org_id --bug 6713929
2196: );
2197: END IF;
2198:
2199: IF (PO_LOG.d_stmt) THEN
2200: PO_LOG.stmt(d_module,d_progress,'After called SUBMISSION_CHECK_COPYDOC()');
2201: END IF;
2202:
2203: d_progress := 20;

Line 2200: PO_LOG.stmt(d_module,d_progress,'After called SUBMISSION_CHECK_COPYDOC()');

2196: );
2197: END IF;
2198:
2199: IF (PO_LOG.d_stmt) THEN
2200: PO_LOG.stmt(d_module,d_progress,'After called SUBMISSION_CHECK_COPYDOC()');
2201: END IF;
2202:
2203: d_progress := 20;
2204:

Line 2226: IF (PO_LOG.d_stmt) THEN

2222: , x_online_report_id => l_report_id2
2223: , x_doc_check_error_record => x_doc_check_error_record
2224: );
2225:
2226: IF (PO_LOG.d_stmt) THEN
2227: PO_LOG.stmt(d_module,d_progress,'After called po_submission_check()');
2228: END IF;
2229:
2230: d_progress := 30;

Line 2227: PO_LOG.stmt(d_module,d_progress,'After called po_submission_check()');

2223: , x_doc_check_error_record => x_doc_check_error_record
2224: );
2225:
2226: IF (PO_LOG.d_stmt) THEN
2227: PO_LOG.stmt(d_module,d_progress,'After called po_submission_check()');
2228: END IF;
2229:
2230: d_progress := 30;
2231:

Line 2239: IF (PO_LOG.d_stmt) THEN

2235: INTO l_report_id1_rownum
2236: FROM PO_ONLINE_REPORT_TEXT
2237: WHERE online_report_id = p_online_report_id;
2238:
2239: IF (PO_LOG.d_stmt) THEN
2240: PO_LOG.stmt(d_module,d_progress,'After counted the first report rows and get the count as: '|| TO_CHAR(l_report_id1_rownum));
2241: END IF;
2242:
2243: d_progress := 40;

Line 2240: PO_LOG.stmt(d_module,d_progress,'After counted the first report rows and get the count as: '|| TO_CHAR(l_report_id1_rownum));

2236: FROM PO_ONLINE_REPORT_TEXT
2237: WHERE online_report_id = p_online_report_id;
2238:
2239: IF (PO_LOG.d_stmt) THEN
2240: PO_LOG.stmt(d_module,d_progress,'After counted the first report rows and get the count as: '|| TO_CHAR(l_report_id1_rownum));
2241: END IF;
2242:
2243: d_progress := 40;
2244:

Line 2252: IF (PO_LOG.d_stmt) THEN

2248: INTO l_report_id2_rownum
2249: FROM PO_ONLINE_REPORT_TEXT
2250: WHERE online_report_id = l_report_id2;
2251:
2252: IF (PO_LOG.d_stmt) THEN
2253: PO_LOG.stmt(d_module,d_progress,'After counted the second report rows and get the count as: '|| TO_CHAR(l_report_id2_rownum));
2254: END IF;
2255:
2256: d_progress := 50;

Line 2253: PO_LOG.stmt(d_module,d_progress,'After counted the second report rows and get the count as: '|| TO_CHAR(l_report_id2_rownum));

2249: FROM PO_ONLINE_REPORT_TEXT
2250: WHERE online_report_id = l_report_id2;
2251:
2252: IF (PO_LOG.d_stmt) THEN
2253: PO_LOG.stmt(d_module,d_progress,'After counted the second report rows and get the count as: '|| TO_CHAR(l_report_id2_rownum));
2254: END IF;
2255:
2256: d_progress := 50;
2257:

Line 2275: IF (PO_LOG.d_stmt) THEN

2271: , p_report_id2 => l_report_id2
2272: , x_new_report_id => x_online_report_id
2273: );
2274:
2275: IF (PO_LOG.d_stmt) THEN
2276: PO_LOG.stmt(d_module,d_progress,'After called merge_online_report_id(), created the new report id');
2277: END IF;
2278: ELSE -- If only report 1 has msg rows, then return the id for report 1 directly.
2279: x_online_report_id := p_online_report_id;

Line 2276: PO_LOG.stmt(d_module,d_progress,'After called merge_online_report_id(), created the new report id');

2272: , x_new_report_id => x_online_report_id
2273: );
2274:
2275: IF (PO_LOG.d_stmt) THEN
2276: PO_LOG.stmt(d_module,d_progress,'After called merge_online_report_id(), created the new report id');
2277: END IF;
2278: ELSE -- If only report 1 has msg rows, then return the id for report 1 directly.
2279: x_online_report_id := p_online_report_id;
2280:

Line 2281: IF (PO_LOG.d_stmt) THEN

2277: END IF;
2278: ELSE -- If only report 1 has msg rows, then return the id for report 1 directly.
2279: x_online_report_id := p_online_report_id;
2280:
2281: IF (PO_LOG.d_stmt) THEN
2282: PO_LOG.stmt(d_module,d_progress,'Not called merge_online_report_id(), use the first report id as:' || TO_CHAR(p_online_report_id));
2283: END IF;
2284: END IF;
2285:

Line 2282: PO_LOG.stmt(d_module,d_progress,'Not called merge_online_report_id(), use the first report id as:' || TO_CHAR(p_online_report_id));

2278: ELSE -- If only report 1 has msg rows, then return the id for report 1 directly.
2279: x_online_report_id := p_online_report_id;
2280:
2281: IF (PO_LOG.d_stmt) THEN
2282: PO_LOG.stmt(d_module,d_progress,'Not called merge_online_report_id(), use the first report id as:' || TO_CHAR(p_online_report_id));
2283: END IF;
2284: END IF;
2285:
2286: d_progress := 60;

Line 2292: IF (PO_LOG.d_stmt) THEN

2288: -- If there is no data rows generated for report 1, return the id for report 2 directly.
2289: ELSE
2290: x_online_report_id := l_report_id2;
2291:
2292: IF (PO_LOG.d_stmt) THEN
2293: PO_LOG.stmt(d_module,d_progress,'Not called merge_online_report_id(), use the second report id as:' || TO_CHAR(l_report_id2));
2294: END IF;
2295: END IF;
2296:

Line 2293: PO_LOG.stmt(d_module,d_progress,'Not called merge_online_report_id(), use the second report id as:' || TO_CHAR(l_report_id2));

2289: ELSE
2290: x_online_report_id := l_report_id2;
2291:
2292: IF (PO_LOG.d_stmt) THEN
2293: PO_LOG.stmt(d_module,d_progress,'Not called merge_online_report_id(), use the second report id as:' || TO_CHAR(l_report_id2));
2294: END IF;
2295: END IF;
2296:
2297: IF (PO_LOG.d_proc) THEN

Line 2297: IF (PO_LOG.d_proc) THEN

2293: PO_LOG.stmt(d_module,d_progress,'Not called merge_online_report_id(), use the second report id as:' || TO_CHAR(l_report_id2));
2294: END IF;
2295: END IF;
2296:
2297: IF (PO_LOG.d_proc) THEN
2298: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2299: PO_LOG.proc_end(d_module, 'x_sub_check_status', x_sub_check_status);
2300: PO_LOG.proc_end(d_module, 'x_has_warnings', x_has_warnings);
2301: PO_LOG.proc_end(d_module, 'x_msg_data', x_msg_data);

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

2294: END IF;
2295: END IF;
2296:
2297: IF (PO_LOG.d_proc) THEN
2298: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2299: PO_LOG.proc_end(d_module, 'x_sub_check_status', x_sub_check_status);
2300: PO_LOG.proc_end(d_module, 'x_has_warnings', x_has_warnings);
2301: PO_LOG.proc_end(d_module, 'x_msg_data', x_msg_data);
2302: PO_LOG.proc_end(d_module, 'x_online_report_id', x_online_report_id);

Line 2299: PO_LOG.proc_end(d_module, 'x_sub_check_status', x_sub_check_status);

2295: END IF;
2296:
2297: IF (PO_LOG.d_proc) THEN
2298: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2299: PO_LOG.proc_end(d_module, 'x_sub_check_status', x_sub_check_status);
2300: PO_LOG.proc_end(d_module, 'x_has_warnings', x_has_warnings);
2301: PO_LOG.proc_end(d_module, 'x_msg_data', x_msg_data);
2302: PO_LOG.proc_end(d_module, 'x_online_report_id', x_online_report_id);
2303:

Line 2300: PO_LOG.proc_end(d_module, 'x_has_warnings', x_has_warnings);

2296:
2297: IF (PO_LOG.d_proc) THEN
2298: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2299: PO_LOG.proc_end(d_module, 'x_sub_check_status', x_sub_check_status);
2300: PO_LOG.proc_end(d_module, 'x_has_warnings', x_has_warnings);
2301: PO_LOG.proc_end(d_module, 'x_msg_data', x_msg_data);
2302: PO_LOG.proc_end(d_module, 'x_online_report_id', x_online_report_id);
2303:
2304: END IF;

Line 2301: PO_LOG.proc_end(d_module, 'x_msg_data', x_msg_data);

2297: IF (PO_LOG.d_proc) THEN
2298: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2299: PO_LOG.proc_end(d_module, 'x_sub_check_status', x_sub_check_status);
2300: PO_LOG.proc_end(d_module, 'x_has_warnings', x_has_warnings);
2301: PO_LOG.proc_end(d_module, 'x_msg_data', x_msg_data);
2302: PO_LOG.proc_end(d_module, 'x_online_report_id', x_online_report_id);
2303:
2304: END IF;
2305:

Line 2302: PO_LOG.proc_end(d_module, 'x_online_report_id', x_online_report_id);

2298: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2299: PO_LOG.proc_end(d_module, 'x_sub_check_status', x_sub_check_status);
2300: PO_LOG.proc_end(d_module, 'x_has_warnings', x_has_warnings);
2301: PO_LOG.proc_end(d_module, 'x_msg_data', x_msg_data);
2302: PO_LOG.proc_end(d_module, 'x_online_report_id', x_online_report_id);
2303:
2304: END IF;
2305:
2306: EXCEPTION

Line 2308: IF (PO_LOG.d_exc) THEN

2304: END IF;
2305:
2306: EXCEPTION
2307: WHEN OTHERS THEN
2308: IF (PO_LOG.d_exc) THEN
2309: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2310: PO_LOG.proc_end(d_module);
2311: END IF;
2312: END po_combined_submission_check;

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

2305:
2306: EXCEPTION
2307: WHEN OTHERS THEN
2308: IF (PO_LOG.d_exc) THEN
2309: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2310: PO_LOG.proc_end(d_module);
2311: END IF;
2312: END po_combined_submission_check;
2313:

Line 2310: PO_LOG.proc_end(d_module);

2306: EXCEPTION
2307: WHEN OTHERS THEN
2308: IF (PO_LOG.d_exc) THEN
2309: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2310: PO_LOG.proc_end(d_module);
2311: END IF;
2312: END po_combined_submission_check;
2313:
2314: -- Bug 5560980 END