APPS.POR_HISTORY_FEED_PKG dependencies on UTL_FILE

Line 26: g_outfile UTL_FILE.FILE_TYPE;

22: g_inv_org_id NUMBER := 0; -- Inventory Organization
23: g_delimiter VARCHAR2(1) := NULL; -- Account structure delimiter character
24: -- that needs to be replaced by
25: -- ; (AMEX character)
26: g_outfile UTL_FILE.FILE_TYPE;
27:
28: --***NOTE: Format_id is a defaulted for this release to identify different...
29: g_format_id NUMBER := 1;
30: --...file formats. When other card issuers are supported in the future, a format

Line 252: UTL_FILE.PUT_LINE(g_outfile,l_detail_record);

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:
254: l_progress := '040';
255:
256: EXCEPTION

Line 607: UTL_FILE.PUT_LINE(g_outfile,l_header_record);

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:
609: IF RTRIM(l_order_status) <> 'CN' THEN --if PO header is not canceled
610: Write_Detail_Record (rec_header.po_header_id,rec_header.po_release_id);
611: END IF;

Line 885: UTL_FILE.PUT_LINE(g_outfile,l_control_record);

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:
887: l_progress := '070';
888:
889: EXCEPTION

Line 1957: g_outfile := UTL_FILE.FOPEN(

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(
1958: l_outdir,
1959: g_output_filename,
1960: 'w',
1961: 32767);

Line 1973: UTL_FILE.FCLOSE(g_outfile);

1969: Write_Header_Record;
1970:
1971: l_progress := '1100';
1972:
1973: UTL_FILE.FCLOSE(g_outfile);
1974:
1975: DELETE FROM por_feed_records
1976: WHERE concurrent_request_id = g_conc_req_id;
1977:

Line 2042: UTL_FILE.FCLOSE(g_outfile);

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;
2044: END Main;
2045:
2046: END POR_History_Feed_Pkg; --package