APPS.FTE_LTL_LOADER dependencies on UTL_FILE

Line 4504: l_chart_file UTL_FILE.file_type;

4500: p_load_id IN VARCHAR2,
4501: x_error_msg OUT NOCOPY VARCHAR2,
4502: x_status OUT NOCOPY NUMBER) IS
4503:
4504: l_chart_file UTL_FILE.file_type;
4505: l_src_file_dir VARCHAR2(500);
4506: l_carriage_return VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(13);
4507: l_line VARCHAR2(1000);
4508: isFileEmpty VARCHAR2(1) := 'Y';

Line 4524: l_chart_file := UTL_FILE.FOPEN(l_src_file_dir, p_file_name, 'R');

4520: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'p_file_name ',p_file_name);
4521: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'G_BULK_INSERT_LIMIT', G_BULK_INSERT_LIMIT);
4522: END IF;
4523:
4524: l_chart_file := UTL_FILE.FOPEN(l_src_file_dir, p_file_name, 'R');
4525:
4526: LOOP
4527: UTL_FILE.GET_LINE(l_chart_file, l_line);
4528:

Line 4527: UTL_FILE.GET_LINE(l_chart_file, l_line);

4523:
4524: l_chart_file := UTL_FILE.FOPEN(l_src_file_dir, p_file_name, 'R');
4525:
4526: LOOP
4527: UTL_FILE.GET_LINE(l_chart_file, l_line);
4528:
4529: l_line := replace(l_line, l_carriage_return, ''); -- dos2unix conversion
4530:
4531: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

Line 4553: UTL_FILE.FCLOSE(l_chart_file);

4549: FTE_UTIL_PKG.Exit_Debug(l_module_name);
4550:
4551: EXCEPTION
4552: WHEN NO_DATA_FOUND THEN
4553: UTL_FILE.FCLOSE(l_chart_file);
4554: IF(isFileEmpty = 'N') THEN
4555: --
4556: -- Insert the last set of lines
4557: --

Line 4583: WHEN UTL_FILE.INVALID_PATH THEN

4579: p_line_number => 0);
4580: FTE_UTIL_PKG.Exit_Debug(l_module_name);
4581: END IF;
4582:
4583: WHEN UTL_FILE.INVALID_PATH THEN
4584:
4585: x_status := 2;
4586: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_INVALID_PATH');
4587: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,

Line 4593: WHEN UTL_FILE.INVALID_OPERATION THEN

4589: p_category => 'E',
4590: p_line_number => 0);
4591: FTE_UTIL_PKG.Exit_Debug(l_module_name);
4592:
4593: WHEN UTL_FILE.INVALID_OPERATION THEN
4594:
4595: x_status := 2;
4596: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_INVALID_FILE_OPERATION');
4597: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,