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 1775: IF (PO_LOG.d_proc) THEN

1771: l_is_price_updateable BOOLEAN;
1772:
1773: BEGIN
1774: d_progress := 0;
1775: IF (PO_LOG.d_proc) THEN
1776: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
1777: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1778: PO_LOG.proc_begin(d_module, 'p_add_reasons_to_msg_list', p_add_reasons_to_msg_list);
1779: END IF;

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

1772:
1773: BEGIN
1774: d_progress := 0;
1775: IF (PO_LOG.d_proc) THEN
1776: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
1777: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1778: PO_LOG.proc_begin(d_module, 'p_add_reasons_to_msg_list', p_add_reasons_to_msg_list);
1779: END IF;
1780:

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

1773: BEGIN
1774: d_progress := 0;
1775: IF (PO_LOG.d_proc) THEN
1776: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
1777: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1778: PO_LOG.proc_begin(d_module, 'p_add_reasons_to_msg_list', p_add_reasons_to_msg_list);
1779: END IF;
1780:
1781: d_progress := 10;

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

1774: d_progress := 0;
1775: IF (PO_LOG.d_proc) THEN
1776: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
1777: PO_LOG.proc_begin(d_module, 'p_line_location_id', p_line_location_id);
1778: PO_LOG.proc_begin(d_module, 'p_add_reasons_to_msg_list', p_add_reasons_to_msg_list);
1779: END IF;
1780:
1781: d_progress := 10;
1782:

Line 1799: IF (PO_LOG.d_proc) THEN

1795: END IF;
1796:
1797: d_progress := 30;
1798:
1799: IF (PO_LOG.d_proc) THEN
1800: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1801: PO_LOG.proc_end(d_module, 'x_price_updateable', x_price_updateable);
1802: PO_LOG.proc_end(d_module);
1803: END IF;

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

1796:
1797: d_progress := 30;
1798:
1799: IF (PO_LOG.d_proc) THEN
1800: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1801: PO_LOG.proc_end(d_module, 'x_price_updateable', x_price_updateable);
1802: PO_LOG.proc_end(d_module);
1803: END IF;
1804:

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

1797: d_progress := 30;
1798:
1799: IF (PO_LOG.d_proc) THEN
1800: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1801: PO_LOG.proc_end(d_module, 'x_price_updateable', x_price_updateable);
1802: PO_LOG.proc_end(d_module);
1803: END IF;
1804:
1805: EXCEPTION

Line 1802: PO_LOG.proc_end(d_module);

1798:
1799: IF (PO_LOG.d_proc) THEN
1800: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1801: PO_LOG.proc_end(d_module, 'x_price_updateable', x_price_updateable);
1802: PO_LOG.proc_end(d_module);
1803: END IF;
1804:
1805: EXCEPTION
1806: WHEN OTHERS THEN

Line 1807: IF (PO_LOG.d_exc) THEN

1803: END IF;
1804:
1805: EXCEPTION
1806: WHEN OTHERS THEN
1807: IF (PO_LOG.d_exc) THEN
1808: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1809: PO_LOG.proc_end(d_module);
1810: END IF;
1811: x_return_status := FND_API.g_ret_sts_unexp_error;

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

1804:
1805: EXCEPTION
1806: WHEN OTHERS THEN
1807: IF (PO_LOG.d_exc) THEN
1808: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1809: PO_LOG.proc_end(d_module);
1810: END IF;
1811: x_return_status := FND_API.g_ret_sts_unexp_error;
1812: x_price_updateable := PO_CORE_S.g_parameter_no;

Line 1809: PO_LOG.proc_end(d_module);

1805: EXCEPTION
1806: WHEN OTHERS THEN
1807: IF (PO_LOG.d_exc) THEN
1808: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1809: PO_LOG.proc_end(d_module);
1810: END IF;
1811: x_return_status := FND_API.g_ret_sts_unexp_error;
1812: x_price_updateable := PO_CORE_S.g_parameter_no;
1813: END;

Line 1840: IF (PO_LOG.d_proc) THEN

1836: l_id2_seq_list PO_TBL_NUMBER; -- list for all sequence numbers of report 2
1837:
1838: BEGIN
1839: d_progress := 0;
1840: IF (PO_LOG.d_proc) THEN
1841: PO_LOG.proc_begin(d_module, 'p_report_id1', p_report_id1);
1842: PO_LOG.proc_begin(d_module, 'p_report_id2', p_report_id2);
1843: END IF;
1844:

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

1837:
1838: BEGIN
1839: d_progress := 0;
1840: IF (PO_LOG.d_proc) THEN
1841: PO_LOG.proc_begin(d_module, 'p_report_id1', p_report_id1);
1842: PO_LOG.proc_begin(d_module, 'p_report_id2', p_report_id2);
1843: END IF;
1844:
1845: d_progress := 10;

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

1838: BEGIN
1839: d_progress := 0;
1840: IF (PO_LOG.d_proc) THEN
1841: PO_LOG.proc_begin(d_module, 'p_report_id1', p_report_id1);
1842: PO_LOG.proc_begin(d_module, 'p_report_id2', p_report_id2);
1843: END IF;
1844:
1845: d_progress := 10;
1846:

Line 1853: IF (PO_LOG.d_stmt) THEN

1849: SELECT po_online_report_text_s.nextval
1850: INTO x_new_report_id
1851: FROM sys.dual;
1852:
1853: IF (PO_LOG.d_stmt) THEN
1854: PO_LOG.stmt(d_module,d_progress,'After got the new id for combined online report');
1855: END IF;
1856:
1857: d_progress := 20;

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

1850: INTO x_new_report_id
1851: FROM sys.dual;
1852:
1853: IF (PO_LOG.d_stmt) THEN
1854: PO_LOG.stmt(d_module,d_progress,'After got the new id for combined online report');
1855: END IF;
1856:
1857: d_progress := 20;
1858:

Line 1922: IF (PO_LOG.d_stmt) THEN

1918: FROM PO_ONLINE_REPORT_TEXT
1919: WHERE online_report_id = p_report_id1
1920: ORDER BY sequence ASC;
1921:
1922: IF (PO_LOG.d_stmt) THEN
1923: PO_LOG.stmt(d_module,d_progress,'After inserted data of report 1 to the combined report, #rows='||SQL%ROWCOUNT);
1924: END IF;
1925:
1926: d_progress := 30;

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

1919: WHERE online_report_id = p_report_id1
1920: ORDER BY sequence ASC;
1921:
1922: IF (PO_LOG.d_stmt) THEN
1923: PO_LOG.stmt(d_module,d_progress,'After inserted data of report 1 to the combined report, #rows='||SQL%ROWCOUNT);
1924: END IF;
1925:
1926: d_progress := 30;
1927:

Line 1935: IF (PO_LOG.d_stmt) THEN

1931: INTO l_id1_max_seq
1932: FROM PO_ONLINE_REPORT_TEXT
1933: WHERE online_report_id = p_report_id1;
1934:
1935: IF (PO_LOG.d_stmt) THEN
1936: PO_LOG.stmt(d_module,d_progress,'After got the max sequence for online report 1 rows as: '||l_id1_max_seq);
1937: END IF;
1938:
1939: d_progress := 40;

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

1932: FROM PO_ONLINE_REPORT_TEXT
1933: WHERE online_report_id = p_report_id1;
1934:
1935: IF (PO_LOG.d_stmt) THEN
1936: PO_LOG.stmt(d_module,d_progress,'After got the max sequence for online report 1 rows as: '||l_id1_max_seq);
1937: END IF;
1938:
1939: d_progress := 40;
1940:

Line 1949: IF (PO_LOG.d_stmt) THEN

1945: FROM PO_ONLINE_REPORT_TEXT
1946: WHERE online_report_id = p_report_id2
1947: ORDER BY sequence ASC;
1948:
1949: IF (PO_LOG.d_stmt) THEN
1950: PO_LOG.stmt(d_module,d_progress,'After got the sequence list for online report 2');
1951: END IF;
1952:
1953: d_progress := 50;

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

1946: WHERE online_report_id = p_report_id2
1947: ORDER BY sequence ASC;
1948:
1949: IF (PO_LOG.d_stmt) THEN
1950: PO_LOG.stmt(d_module,d_progress,'After got the sequence list for online report 2');
1951: END IF;
1952:
1953: d_progress := 50;
1954:

Line 2021: IF (PO_LOG.d_stmt) THEN

2017: FROM PO_ONLINE_REPORT_TEXT
2018: WHERE online_report_id = p_report_id2 and sequence = l_id2_seq_list(i);
2019: END LOOP;
2020:
2021: IF (PO_LOG.d_stmt) THEN
2022: PO_LOG.stmt(d_module,d_progress,'After inserted data of report 2 to the combined report');
2023: END IF;
2024:
2025: d_progress := 100;

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

2018: WHERE online_report_id = p_report_id2 and sequence = l_id2_seq_list(i);
2019: END LOOP;
2020:
2021: IF (PO_LOG.d_stmt) THEN
2022: PO_LOG.stmt(d_module,d_progress,'After inserted data of report 2 to the combined report');
2023: END IF;
2024:
2025: d_progress := 100;
2026:

Line 2027: IF (PO_LOG.d_proc) THEN

2023: END IF;
2024:
2025: d_progress := 100;
2026:
2027: IF (PO_LOG.d_proc) THEN
2028: PO_LOG.proc_end(d_module, 'x_new_report_id', x_new_report_id);
2029: END IF;
2030:
2031: EXCEPTION

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

2024:
2025: d_progress := 100;
2026:
2027: IF (PO_LOG.d_proc) THEN
2028: PO_LOG.proc_end(d_module, 'x_new_report_id', x_new_report_id);
2029: END IF;
2030:
2031: EXCEPTION
2032: WHEN OTHERS THEN

Line 2033: IF (PO_LOG.d_exc) THEN

2029: END IF;
2030:
2031: EXCEPTION
2032: WHEN OTHERS THEN
2033: IF (PO_LOG.d_exc) THEN
2034: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2035: PO_LOG.proc_end(d_module);
2036: END IF;
2037: END merge_online_report_id;

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

2030:
2031: EXCEPTION
2032: WHEN OTHERS THEN
2033: IF (PO_LOG.d_exc) THEN
2034: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2035: PO_LOG.proc_end(d_module);
2036: END IF;
2037: END merge_online_report_id;
2038:

Line 2035: PO_LOG.proc_end(d_module);

2031: EXCEPTION
2032: WHEN OTHERS THEN
2033: IF (PO_LOG.d_exc) THEN
2034: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2035: PO_LOG.proc_end(d_module);
2036: END IF;
2037: END merge_online_report_id;
2038:
2039: -------------------------------------------------------------------------------

Line 2162: IF (PO_LOG.d_proc) THEN

2158: l_inv_org_id NUMBER; --bug 6713929
2159:
2160: BEGIN
2161: d_progress := 0;
2162: IF (PO_LOG.d_proc) THEN
2163: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
2164: PO_LOG.proc_begin(d_module, 'p_action_requested', p_action_requested);
2165: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2166: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);

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

2159:
2160: BEGIN
2161: d_progress := 0;
2162: IF (PO_LOG.d_proc) THEN
2163: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
2164: PO_LOG.proc_begin(d_module, 'p_action_requested', p_action_requested);
2165: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2166: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2167: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);

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

2160: BEGIN
2161: d_progress := 0;
2162: IF (PO_LOG.d_proc) THEN
2163: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
2164: PO_LOG.proc_begin(d_module, 'p_action_requested', p_action_requested);
2165: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2166: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2167: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2168: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);

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

2161: d_progress := 0;
2162: IF (PO_LOG.d_proc) THEN
2163: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
2164: PO_LOG.proc_begin(d_module, 'p_action_requested', p_action_requested);
2165: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2166: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2167: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2168: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2169: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);

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

2162: IF (PO_LOG.d_proc) THEN
2163: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
2164: PO_LOG.proc_begin(d_module, 'p_action_requested', p_action_requested);
2165: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2166: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2167: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2168: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2169: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2170: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);

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

2163: PO_LOG.proc_begin(d_module, 'p_api_version', p_api_version);
2164: PO_LOG.proc_begin(d_module, 'p_action_requested', p_action_requested);
2165: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2166: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2167: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2168: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2169: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2170: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2171: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);

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

2164: PO_LOG.proc_begin(d_module, 'p_action_requested', p_action_requested);
2165: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2166: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2167: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2168: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2169: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2170: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2171: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2172: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);

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

2165: PO_LOG.proc_begin(d_module, 'p_document_type', p_document_type);
2166: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2167: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2168: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2169: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2170: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2171: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2172: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);
2173: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);

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

2166: PO_LOG.proc_begin(d_module, 'p_document_subtype', p_document_subtype);
2167: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2168: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2169: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2170: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2171: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2172: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);
2173: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
2174: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);

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

2167: PO_LOG.proc_begin(d_module, 'p_document_level', p_document_level);
2168: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2169: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2170: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2171: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2172: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);
2173: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
2174: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);
2175: PO_LOG.proc_begin(d_module, 'p_sob_id', p_sob_id);

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

2168: PO_LOG.proc_begin(d_module, 'p_document_level_id', p_document_level_id);
2169: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2170: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2171: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2172: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);
2173: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
2174: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);
2175: PO_LOG.proc_begin(d_module, 'p_sob_id', p_sob_id);
2176: END IF;

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

2169: PO_LOG.proc_begin(d_module, 'p_org_id', p_org_id);
2170: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2171: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2172: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);
2173: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
2174: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);
2175: PO_LOG.proc_begin(d_module, 'p_sob_id', p_sob_id);
2176: END IF;
2177:

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

2170: PO_LOG.proc_begin(d_module, 'p_check_asl', p_check_asl);
2171: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2172: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);
2173: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
2174: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);
2175: PO_LOG.proc_begin(d_module, 'p_sob_id', p_sob_id);
2176: END IF;
2177:
2178: d_progress := 10;

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

2171: PO_LOG.proc_begin(d_module, 'p_from_header_id', p_from_header_id);
2172: PO_LOG.proc_begin(d_module, 'p_from_type_lookup_code', p_from_type_lookup_code);
2173: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
2174: PO_LOG.proc_begin(d_module, 'p_online_report_id', p_online_report_id);
2175: PO_LOG.proc_begin(d_module, 'p_sob_id', p_sob_id);
2176: END IF;
2177:
2178: d_progress := 10;
2179:

Line 2210: IF (PO_LOG.d_stmt) THEN

2206: ,x_inv_org_id => l_inv_org_id --bug 6713929
2207: );
2208: END IF;
2209:
2210: IF (PO_LOG.d_stmt) THEN
2211: PO_LOG.stmt(d_module,d_progress,'After called SUBMISSION_CHECK_COPYDOC()');
2212: END IF;
2213:
2214: d_progress := 20;

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

2207: );
2208: END IF;
2209:
2210: IF (PO_LOG.d_stmt) THEN
2211: PO_LOG.stmt(d_module,d_progress,'After called SUBMISSION_CHECK_COPYDOC()');
2212: END IF;
2213:
2214: d_progress := 20;
2215:

Line 2238: IF (PO_LOG.d_stmt) THEN

2234: , x_online_report_id => l_report_id2
2235: , x_doc_check_error_record => x_doc_check_error_record
2236: );
2237:
2238: IF (PO_LOG.d_stmt) THEN
2239: PO_LOG.stmt(d_module,d_progress,'After called po_submission_check()');
2240: END IF;
2241:
2242: d_progress := 30;

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

2235: , x_doc_check_error_record => x_doc_check_error_record
2236: );
2237:
2238: IF (PO_LOG.d_stmt) THEN
2239: PO_LOG.stmt(d_module,d_progress,'After called po_submission_check()');
2240: END IF;
2241:
2242: d_progress := 30;
2243:

Line 2251: IF (PO_LOG.d_stmt) THEN

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

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

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

Line 2264: IF (PO_LOG.d_stmt) THEN

2260: INTO l_report_id2_rownum
2261: FROM PO_ONLINE_REPORT_TEXT
2262: WHERE online_report_id = l_report_id2;
2263:
2264: IF (PO_LOG.d_stmt) THEN
2265: PO_LOG.stmt(d_module,d_progress,'After counted the second report rows and get the count as: '|| TO_CHAR(l_report_id2_rownum));
2266: END IF;
2267:
2268: d_progress := 50;

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

2261: FROM PO_ONLINE_REPORT_TEXT
2262: WHERE online_report_id = l_report_id2;
2263:
2264: IF (PO_LOG.d_stmt) THEN
2265: PO_LOG.stmt(d_module,d_progress,'After counted the second report rows and get the count as: '|| TO_CHAR(l_report_id2_rownum));
2266: END IF;
2267:
2268: d_progress := 50;
2269:

Line 2287: IF (PO_LOG.d_stmt) THEN

2283: , p_report_id2 => l_report_id2
2284: , x_new_report_id => x_online_report_id
2285: );
2286:
2287: IF (PO_LOG.d_stmt) THEN
2288: PO_LOG.stmt(d_module,d_progress,'After called merge_online_report_id(), created the new report id');
2289: END IF;
2290: ELSE -- If only report 1 has msg rows, then return the id for report 1 directly.
2291: x_online_report_id := p_online_report_id;

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

2284: , x_new_report_id => x_online_report_id
2285: );
2286:
2287: IF (PO_LOG.d_stmt) THEN
2288: PO_LOG.stmt(d_module,d_progress,'After called merge_online_report_id(), created the new report id');
2289: END IF;
2290: ELSE -- If only report 1 has msg rows, then return the id for report 1 directly.
2291: x_online_report_id := p_online_report_id;
2292:

Line 2293: IF (PO_LOG.d_stmt) THEN

2289: END IF;
2290: ELSE -- If only report 1 has msg rows, then return the id for report 1 directly.
2291: x_online_report_id := p_online_report_id;
2292:
2293: IF (PO_LOG.d_stmt) THEN
2294: 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));
2295: END IF;
2296: END IF;
2297:

Line 2294: 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));

2290: ELSE -- If only report 1 has msg rows, then return the id for report 1 directly.
2291: x_online_report_id := p_online_report_id;
2292:
2293: IF (PO_LOG.d_stmt) THEN
2294: 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));
2295: END IF;
2296: END IF;
2297:
2298: d_progress := 60;

Line 2304: IF (PO_LOG.d_stmt) THEN

2300: -- If there is no data rows generated for report 1, return the id for report 2 directly.
2301: ELSE
2302: x_online_report_id := l_report_id2;
2303:
2304: IF (PO_LOG.d_stmt) THEN
2305: PO_LOG.stmt(d_module,d_progress,'Not called merge_online_report_id(), use the second report id as:' || TO_CHAR(l_report_id2));
2306: END IF;
2307: END IF;
2308:

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

2301: ELSE
2302: x_online_report_id := l_report_id2;
2303:
2304: IF (PO_LOG.d_stmt) THEN
2305: PO_LOG.stmt(d_module,d_progress,'Not called merge_online_report_id(), use the second report id as:' || TO_CHAR(l_report_id2));
2306: END IF;
2307: END IF;
2308:
2309: IF (PO_LOG.d_proc) THEN

Line 2309: IF (PO_LOG.d_proc) THEN

2305: PO_LOG.stmt(d_module,d_progress,'Not called merge_online_report_id(), use the second report id as:' || TO_CHAR(l_report_id2));
2306: END IF;
2307: END IF;
2308:
2309: IF (PO_LOG.d_proc) THEN
2310: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2311: PO_LOG.proc_end(d_module, 'x_sub_check_status', x_sub_check_status);
2312: PO_LOG.proc_end(d_module, 'x_has_warnings', x_has_warnings);
2313: PO_LOG.proc_end(d_module, 'x_msg_data', x_msg_data);

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

2306: END IF;
2307: END IF;
2308:
2309: IF (PO_LOG.d_proc) THEN
2310: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2311: PO_LOG.proc_end(d_module, 'x_sub_check_status', x_sub_check_status);
2312: PO_LOG.proc_end(d_module, 'x_has_warnings', x_has_warnings);
2313: PO_LOG.proc_end(d_module, 'x_msg_data', x_msg_data);
2314: PO_LOG.proc_end(d_module, 'x_online_report_id', x_online_report_id);

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

2307: END IF;
2308:
2309: IF (PO_LOG.d_proc) THEN
2310: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2311: PO_LOG.proc_end(d_module, 'x_sub_check_status', x_sub_check_status);
2312: PO_LOG.proc_end(d_module, 'x_has_warnings', x_has_warnings);
2313: PO_LOG.proc_end(d_module, 'x_msg_data', x_msg_data);
2314: PO_LOG.proc_end(d_module, 'x_online_report_id', x_online_report_id);
2315:

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

2308:
2309: IF (PO_LOG.d_proc) THEN
2310: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2311: PO_LOG.proc_end(d_module, 'x_sub_check_status', x_sub_check_status);
2312: PO_LOG.proc_end(d_module, 'x_has_warnings', x_has_warnings);
2313: PO_LOG.proc_end(d_module, 'x_msg_data', x_msg_data);
2314: PO_LOG.proc_end(d_module, 'x_online_report_id', x_online_report_id);
2315:
2316: END IF;

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

2309: IF (PO_LOG.d_proc) THEN
2310: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2311: PO_LOG.proc_end(d_module, 'x_sub_check_status', x_sub_check_status);
2312: PO_LOG.proc_end(d_module, 'x_has_warnings', x_has_warnings);
2313: PO_LOG.proc_end(d_module, 'x_msg_data', x_msg_data);
2314: PO_LOG.proc_end(d_module, 'x_online_report_id', x_online_report_id);
2315:
2316: END IF;
2317:

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

2310: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
2311: PO_LOG.proc_end(d_module, 'x_sub_check_status', x_sub_check_status);
2312: PO_LOG.proc_end(d_module, 'x_has_warnings', x_has_warnings);
2313: PO_LOG.proc_end(d_module, 'x_msg_data', x_msg_data);
2314: PO_LOG.proc_end(d_module, 'x_online_report_id', x_online_report_id);
2315:
2316: END IF;
2317:
2318: EXCEPTION

Line 2320: IF (PO_LOG.d_exc) THEN

2316: END IF;
2317:
2318: EXCEPTION
2319: WHEN OTHERS THEN
2320: IF (PO_LOG.d_exc) THEN
2321: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2322: PO_LOG.proc_end(d_module);
2323: END IF;
2324: END po_combined_submission_check;

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

2317:
2318: EXCEPTION
2319: WHEN OTHERS THEN
2320: IF (PO_LOG.d_exc) THEN
2321: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2322: PO_LOG.proc_end(d_module);
2323: END IF;
2324: END po_combined_submission_check;
2325:

Line 2322: PO_LOG.proc_end(d_module);

2318: EXCEPTION
2319: WHEN OTHERS THEN
2320: IF (PO_LOG.d_exc) THEN
2321: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2322: PO_LOG.proc_end(d_module);
2323: END IF;
2324: END po_combined_submission_check;
2325:
2326: -- Bug 5560980 END