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.POR_HISTORY_FEED_PKG dependencies on FND_LOG

Line 6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

2: /* $Header: PORHSFDB.pls 120.6 2006/08/25 23:08:57 tolick noship $ */
3:
4: --global variables
5: -- Logging Static Variables
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

3:
4: --global variables
5: -- Logging Static Variables
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

4: --global variables
5: -- Logging Static Variables
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'PO.PLSQL.POR_HISTORY_FEED_PKG';

Line 9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

5: -- Logging Static Variables
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'PO.PLSQL.POR_HISTORY_FEED_PKG';
13:

Line 10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'PO.PLSQL.POR_HISTORY_FEED_PKG';
13:
14: -- Concurrent Program Input Parameters

Line 11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'PO.PLSQL.POR_HISTORY_FEED_PKG';
13:
14: -- Concurrent Program Input Parameters
15: g_card_brand VARCHAR2(25) := NULL; -- Card brand Name

Line 145: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

141: l_field_length NUMBER := 0;
142: l_pad_char VARCHAR2(1) := NULL;
143:
144: e_do_not_send_distr EXCEPTION;
145: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
146: l_progress VARCHAR2(4) := '000';
147:
148: BEGIN
149:

Line 248: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

244: END LOOP;
245:
246: l_progress := '030';
247:
248: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
249: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Detail Record = ' || l_detail_record);
250: END IF;
251:
252: UTL_FILE.PUT_LINE(g_outfile,l_detail_record);

Line 249: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Detail Record = ' || l_detail_record);

245:
246: l_progress := '030';
247:
248: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
249: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Detail Record = ' || l_detail_record);
250: END IF;
251:
252: UTL_FILE.PUT_LINE(g_outfile,l_detail_record);
253:

Line 276: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

272: l_progress := '050';
273:
274: EXCEPTION
275: WHEN OTHERS THEN
276: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
277: l_log_msg := 'Error in Write_Detail_Record : SQLERRM= ' ||
278: SQLERRM || ' : Progress= ' || l_progress;
279: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Write_Detail_Record', l_log_msg);
280: END IF;

Line 279: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Write_Detail_Record', l_log_msg);

275: WHEN OTHERS THEN
276: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
277: l_log_msg := 'Error in Write_Detail_Record : SQLERRM= ' ||
278: SQLERRM || ' : Progress= ' || l_progress;
279: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Write_Detail_Record', l_log_msg);
280: END IF;
281:
282: RAISE;
283:

Line 348: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

344: l_default_value VARCHAR2(50) := NULL;
345: l_field_length NUMBER := 0;
346: l_pad_char VARCHAR2(1) := NULL;
347:
348: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
349: l_progress VARCHAR2(4) := '000';
350:
351: BEGIN
352:

Line 603: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

599: END LOOP;
600:
601: l_progress := '050';
602:
603: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
604: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Header Record = ' || l_header_record);
605: END IF;
606:
607: UTL_FILE.PUT_LINE(g_outfile,l_header_record);

Line 604: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Header Record = ' || l_header_record);

600:
601: l_progress := '050';
602:
603: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
604: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Header Record = ' || l_header_record);
605: END IF;
606:
607: UTL_FILE.PUT_LINE(g_outfile,l_header_record);
608:

Line 634: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

630: END LOOP; --rec_header
631:
632: EXCEPTION
633: WHEN OTHERS THEN
634: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
635: l_log_msg := 'Error in Write_Header_Record : SQLERRM= ' ||
636: SQLERRM || ' : Progress= ' || l_progress;
637: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Write_Header_Record', l_log_msg);
638: END IF;

Line 637: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Write_Header_Record', l_log_msg);

633: WHEN OTHERS THEN
634: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
635: l_log_msg := 'Error in Write_Header_Record : SQLERRM= ' ||
636: SQLERRM || ' : Progress= ' || l_progress;
637: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Write_Header_Record', l_log_msg);
638: END IF;
639:
640: RAISE;
641:

Line 695: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

691: l_field_length NUMBER := 0;
692: l_pad_char VARCHAR2(1) := NULL;
693: l_no_error BOOLEAN := TRUE;
694:
695: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
696: l_progress VARCHAR2(4) := '000';
697:
698: BEGIN
699:

Line 881: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

877: END LOOP;
878:
879: l_progress := '060';
880:
881: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
882: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Control Record = ' || l_control_record);
883: END IF;
884:
885: UTL_FILE.PUT_LINE(g_outfile,l_control_record);

Line 882: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Control Record = ' || l_control_record);

878:
879: l_progress := '060';
880:
881: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
882: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Control Record = ' || l_control_record);
883: END IF;
884:
885: UTL_FILE.PUT_LINE(g_outfile,l_control_record);
886:

Line 892: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

888:
889: EXCEPTION
890:
891: WHEN OTHERS THEN
892: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
893: l_log_msg := 'Error in Write_Control_Record : SQLERRM= ' ||
894: SQLERRM || ' : Progress= ' || l_progress;
895: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Write_Control_Record', l_log_msg);
896: END IF;

Line 895: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Write_Control_Record', l_log_msg);

891: WHEN OTHERS THEN
892: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
893: l_log_msg := 'Error in Write_Control_Record : SQLERRM= ' ||
894: SQLERRM || ' : Progress= ' || l_progress;
895: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Write_Control_Record', l_log_msg);
896: END IF;
897:
898: RAISE;
899:

Line 919: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

915: l_trim_card_number por_feed_records.card_number%TYPE;
916:
917: l_char VARCHAR2(1) := NULL;
918:
919: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
920: l_progress VARCHAR2(4) := '000';
921:
922: BEGIN
923:

Line 960: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

956:
957: EXCEPTION
958:
959: WHEN OTHERS THEN
960: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
961: l_log_msg := 'Error in Trim_Card_Numbers : SQLERRM= ' ||
962: SQLERRM || ' : Progress= ' || l_progress;
963: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Trim_Card_Numbers', l_log_msg);
964: END IF;

Line 963: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Trim_Card_Numbers', l_log_msg);

959: WHEN OTHERS THEN
960: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
961: l_log_msg := 'Error in Trim_Card_Numbers : SQLERRM= ' ||
962: SQLERRM || ' : Progress= ' || l_progress;
963: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Trim_Card_Numbers', l_log_msg);
964: END IF;
965:
966: RAISE;
967:

Line 985: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

981: l_object_type VARCHAR2(1) := NULL;
982: l_object_id NUMBER := 0;
983: l_po_amount NUMBER := 0;
984:
985: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
986: l_progress VARCHAR2(4) := '000';
987:
988: BEGIN
989: l_progress := '000';

Line 1047: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1043: l_progress := '030';
1044:
1045: EXCEPTION
1046: WHEN OTHERS THEN
1047: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1048: l_log_msg := 'Error in Get_Header_Amounts : SQLERRM= ' ||
1049: SQLERRM || ' : Progress= ' || l_progress;
1050: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Get_Header_Amounts', l_log_msg);
1051: END IF;

Line 1050: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Get_Header_Amounts', l_log_msg);

1046: WHEN OTHERS THEN
1047: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1048: l_log_msg := 'Error in Get_Header_Amounts : SQLERRM= ' ||
1049: SQLERRM || ' : Progress= ' || l_progress;
1050: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Get_Header_Amounts', l_log_msg);
1051: END IF;
1052:
1053: RAISE;
1054: END Get_Header_Amounts;

Line 1562: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1558: AND PR.LAST_UPDATE_DATE >= g_from_date_time
1559: AND PR.LAST_UPDATE_DATE < g_to_date_time
1560: AND ac.card_reference_id = ibycc.instrid;
1561:
1562: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1563: l_progress VARCHAR2(4) := '000';
1564:
1565: BEGIN
1566:

Line 1613: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1609: -- fnd_file.put_line(fnd_file.log, '# fetched : ' || to_char(cur_po_records%rowcount));
1610:
1611: l_progress := '010';
1612:
1613: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1614: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Get_PO_Distributions', '# of PO Records = ' || cur_PO_records%ROWCOUNT);
1615: END IF;
1616:
1617: FORALL i in 1 .. cur_PO_records%ROWCOUNT

Line 1614: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Get_PO_Distributions', '# of PO Records = ' || cur_PO_records%ROWCOUNT);

1610:
1611: l_progress := '010';
1612:
1613: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1614: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Get_PO_Distributions', '# of PO Records = ' || cur_PO_records%ROWCOUNT);
1615: END IF;
1616:
1617: FORALL i in 1 .. cur_PO_records%ROWCOUNT
1618:

Line 1732: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1728: -- fnd_file.put_line(fnd_file.log, '# canceled fetched : ' || to_char(cur_canceled_POs%rowcount));
1729:
1730: l_progress := '030';
1731:
1732: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1733: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Get_PO_Distributions', '# of Cancelled POs = ' || cur_canceled_POs%ROWCOUNT);
1734: END IF;
1735:
1736: FORALL i in 1 .. cur_canceled_POs%ROWCOUNT

Line 1733: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Get_PO_Distributions', '# of Cancelled POs = ' || cur_canceled_POs%ROWCOUNT);

1729:
1730: l_progress := '030';
1731:
1732: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1733: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Get_PO_Distributions', '# of Cancelled POs = ' || cur_canceled_POs%ROWCOUNT);
1734: END IF;
1735:
1736: FORALL i in 1 .. cur_canceled_POs%ROWCOUNT
1737:

Line 1798: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1794:
1795: EXCEPTION
1796:
1797: WHEN OTHERS THEN
1798: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1799: l_log_msg := 'Error in Get_PO_Distributions : SQLERRM= ' ||
1800: SQLERRM || ' : Progress= ' || l_progress;
1801: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Get_PO_Distributions', l_log_msg);
1802: END IF;

Line 1801: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Get_PO_Distributions', l_log_msg);

1797: WHEN OTHERS THEN
1798: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1799: l_log_msg := 'Error in Get_PO_Distributions : SQLERRM= ' ||
1800: SQLERRM || ' : Progress= ' || l_progress;
1801: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Get_PO_Distributions', l_log_msg);
1802: END IF;
1803:
1804: RAISE;
1805:

Line 1838: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1834: l_message VARCHAR2(2000) := NULL;
1835: l_org_chart_of_accounts_id NUMBER := 0;
1836: l_func_curr_code VARCHAR2(15) := NULL;
1837:
1838: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1839: l_progress VARCHAR2(4) := '000';
1840:
1841: BEGIN
1842: l_progress := '000';

Line 1845: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1841: BEGIN
1842: l_progress := '000';
1843:
1844: -- Logging Procedure level
1845: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1846: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||'Main.begin', '<-------------------->');
1847: END IF;
1848:
1849: g_card_brand := i_card_brand;

Line 1846: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||'Main.begin', '<-------------------->');

1842: l_progress := '000';
1843:
1844: -- Logging Procedure level
1845: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1846: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||'Main.begin', '<-------------------->');
1847: END IF;
1848:
1849: g_card_brand := i_card_brand;
1850: g_card_issuer_id := i_card_issuer_id;

Line 1861: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1857: 'DD-MON-YYYY HH24:MI:SS');
1858:
1859: l_progress := '100';
1860:
1861: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1862: l_log_msg := 'Input Params :: i_card_brand = ' || i_card_brand ||
1863: ' :: i_card_issuer_id = ' || to_char(i_card_issuer_id) ||
1864: ' :: i_card_issuer_site_id = ' || to_char(i_card_issuer_site_id) ||
1865: ' :: i_from_date_time = ' || i_from_date_time ||

Line 1868: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', l_log_msg);

1864: ' :: i_card_issuer_site_id = ' || to_char(i_card_issuer_site_id) ||
1865: ' :: i_from_date_time = ' || i_from_date_time ||
1866: ' :: i_to_date_time = ' || i_to_date_time ||
1867: ' :: i_output_filename = ' || i_output_filename;
1868: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', l_log_msg);
1869: END IF;
1870:
1871: -- fnd_file.put_line(fnd_file.log, 'reformatted from date/time: ' || to_char(g_from_date_time,'DD-MON-YYYY HH24:MI:SS'));
1872: -- fnd_file.put_line(fnd_file.log, 'reformatted to date/time: ' || to_char(g_to_date_time,'DD-MON-YYYY HH24:MI:SS'));

Line 1894: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1890: g_max_po_num_size := Get_Field_Size ('PO_NUMBER','H');
1891:
1892: l_progress := '400';
1893:
1894: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1895: l_log_msg := ' l_func_curr_code = ' || l_func_curr_code ||
1896: ' :: l_org_chart_of_accounts_id = ' || to_char(l_org_chart_of_accounts_id) ||
1897: ' :: g_inv_org_id = ' || to_char(g_inv_org_id);
1898: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', l_log_msg);

Line 1898: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', l_log_msg);

1894: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1895: l_log_msg := ' l_func_curr_code = ' || l_func_curr_code ||
1896: ' :: l_org_chart_of_accounts_id = ' || to_char(l_org_chart_of_accounts_id) ||
1897: ' :: g_inv_org_id = ' || to_char(g_inv_org_id);
1898: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', l_log_msg);
1899: END IF;
1900:
1901: --log run in por_feed_history
1902:

Line 1951: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1947: l_progress := '800';
1948:
1949: FND_PROFILE.GET('ECE_OUT_FILE_PATH',l_outdir);
1950:
1951: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1952: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Output Directory = ' || l_outdir);
1953: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Filename = ' || g_output_filename);
1954: END IF;
1955:

Line 1952: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Output Directory = ' || l_outdir);

1948:
1949: FND_PROFILE.GET('ECE_OUT_FILE_PATH',l_outdir);
1950:
1951: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1952: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Output Directory = ' || l_outdir);
1953: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Filename = ' || g_output_filename);
1954: END IF;
1955:
1956: -- Set the linesize to the maximum value of 32767 while opening the file

Line 1953: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Filename = ' || g_output_filename);

1949: FND_PROFILE.GET('ECE_OUT_FILE_PATH',l_outdir);
1950:
1951: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1952: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Output Directory = ' || l_outdir);
1953: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', 'Filename = ' || g_output_filename);
1954: END IF;
1955:
1956: -- Set the linesize to the maximum value of 32767 while opening the file
1957: g_outfile := UTL_FILE.FOPEN(

Line 1992: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1988: );
1989:
1990: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Output file has been created successfully.');
1991:
1992: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1993: l_log_msg := ' g_po_num_err = ' || g_po_num_err ||
1994: ' :: g_card_num_err = ' || g_card_num_err ||
1995: ' :: l_message = ' || l_message;
1996: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', l_log_msg);

Line 1996: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', l_log_msg);

1992: IF (G_LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1993: l_log_msg := ' g_po_num_err = ' || g_po_num_err ||
1994: ' :: g_card_num_err = ' || g_card_num_err ||
1995: ' :: l_message = ' || l_message;
1996: FND_LOG.STRING(G_LEVEL_STATEMENT, G_MODULE_NAME||'Main', l_log_msg);
1997: END IF;
1998:
1999: l_progress := '1200';
2000:

Line 2029: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2025:
2026: l_progress := '1300';
2027:
2028: -- Logging Procedure level
2029: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2030: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||'Main.end', '<-------------------->');
2031: END IF;
2032:
2033: EXCEPTION

Line 2030: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||'Main.end', '<-------------------->');

2026: l_progress := '1300';
2027:
2028: -- Logging Procedure level
2029: IF (G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2030: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||'Main.end', '<-------------------->');
2031: END IF;
2032:
2033: EXCEPTION
2034:

Line 2036: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

2032:
2033: EXCEPTION
2034:
2035: WHEN OTHERS THEN
2036: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2037: l_log_msg := 'Error in Concurrent request : SQLERRM= ' ||
2038: SQLERRM || ' : Progress= ' || l_progress;
2039: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Main', l_log_msg);
2040: END IF;

Line 2039: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Main', l_log_msg);

2035: WHEN OTHERS THEN
2036: IF (G_LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
2037: l_log_msg := 'Error in Concurrent request : SQLERRM= ' ||
2038: SQLERRM || ' : Progress= ' || l_progress;
2039: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||'Main', l_log_msg);
2040: END IF;
2041:
2042: UTL_FILE.FCLOSE(g_outfile);
2043: RAISE;