APPS.FTE_BULKLOAD_PKG dependencies on UTL_FILE

Line 541: x_chart_file UTL_FILE.file_type;

537:
538: l_tokens STRINGARRAY;
539: l_debug_on BOOLEAN;
540: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.READ_BLOCK_FROM_DIR';
541: x_chart_file UTL_FILE.file_type;
542: l_src_file_dir VARCHAR2(500);
543: l_line VARCHAR2(1000);
544: l_block_type VARCHAR2(100) := NULL;
545: l_section_line BOOLEAN := TRUE;

Line 563: x_chart_file := utl_file.fopen(l_src_file_dir, p_file_name, 'R');

559: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Load ID', p_load_id);
560: END IF;
561:
562: l_src_file_dir := Fte_Bulkload_Pkg.Get_Upload_Dir;
563: x_chart_file := utl_file.fopen(l_src_file_dir, p_file_name, 'R');
564:
565: LOOP
566: utl_file.get_line(x_chart_file, l_line);
567: l_line := replace(l_line, g_carriage_return, ''); --dos2unix conversion

Line 566: utl_file.get_line(x_chart_file, l_line);

562: l_src_file_dir := Fte_Bulkload_Pkg.Get_Upload_Dir;
563: x_chart_file := utl_file.fopen(l_src_file_dir, p_file_name, 'R');
564:
565: LOOP
566: utl_file.get_line(x_chart_file, l_line);
567: l_line := replace(l_line, g_carriage_return, ''); --dos2unix conversion
568: l_line := TRIM(' ' FROM l_line);
569:
570: IF l_section_line THEN

Line 663: utl_file.fclose(x_chart_file);

659:
660: FTE_UTIL_PKG.Exit_Debug(l_module_name);
661: EXCEPTION
662: WHEN NO_DATA_FOUND THEN
663: utl_file.fclose(x_chart_file);
664:
665: IF (NOT l_last_line_null) THEN
666: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'l_block_type', l_block_type);
667: PROCESS_BLOCK(p_block_type => l_block_type,

Line 693: WHEN UTL_FILE.INVALID_PATH THEN

689: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Number of lines processed', l_processed_lines);
690: END IF;
691:
692: FTE_UTIL_PKG.Exit_Debug(l_module_name);
693: WHEN UTL_FILE.INVALID_PATH THEN
694: -- x_error_msg := 'File ' || l_src_file_dir || '/' || p_file_name || ' Not Accessible' ||
695: -- fnd_global.newline || 'Please make sure that the directory is accessible to UTL_FILE.';
696:
697: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 695: -- fnd_global.newline || 'Please make sure that the directory is accessible to UTL_FILE.';

691:
692: FTE_UTIL_PKG.Exit_Debug(l_module_name);
693: WHEN UTL_FILE.INVALID_PATH THEN
694: -- x_error_msg := 'File ' || l_src_file_dir || '/' || p_file_name || ' Not Accessible' ||
695: -- fnd_global.newline || 'Please make sure that the directory is accessible to UTL_FILE.';
696:
697: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
698: p_msg => 'FTE_FILE_NOT_ACCESSIBLE',
699: p_category => 'E');

Line 703: WHEN UTL_FILE.INVALID_OPERATION THEN

699: p_category => 'E');
700:
701: x_status := 2;
702: FTE_UTIL_PKG.Exit_Debug(l_module_name);
703: WHEN UTL_FILE.INVALID_OPERATION THEN
704: -- x_error_msg := 'ERROR: The file does not exist, or file or directory access was denied by the operating system.'
705: -- || fnd_global.newline || 'Please verify file and directory access privileges on the file system.';
706:
707: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 1338: --we read the contents of the file directly using UTL_FILE.

1334: FROM fte_bulkload_data
1335: WHERE load_id = p_LoadId;
1336:
1337: --For LTL pricelists, we don't upload the file into the database, but rather
1338: --we read the contents of the file directly using UTL_FILE.
1339: IF (p_loadType <> 'LTL_PRICELIST') THEN
1340: fnd_profile.get('FTE_BULKLOAD_SOURCE_TYPE',l_source_type);
1341:
1342: IF (upper(l_source_type) = 'SERVER') THEN