APPS.PO_XML_UTILS_GRP dependencies on UTL_FILE

Line 133: v_filehandle UTL_FILE.file_type;

129:
130: l_filedir varchar2(256);
131: l_filename varchar2(256);
132: l_filename_lang varchar2 (600);
133: v_filehandle UTL_FILE.file_type;
134: l_terms varchar2(32000);
135: voffset integer := 1;
136: l_newline varchar2(10); -- bug#4278861: stores new line value
137:

Line 160: v_filehandle := UTL_FILE.FOPEN(l_filedir,l_filename_lang,'r',32000); --bug#4278861: Open the file handle with 32k buffer

156:
157: BEGIN
158: /* open the file */
159:
160: v_filehandle := UTL_FILE.FOPEN(l_filedir,l_filename_lang,'r',32000); --bug#4278861: Open the file handle with 32k buffer
161:
162: EXCEPTION WHEN OTHERS THEN
163:
164: BEGIN

Line 166: v_filehandle := UTL_FILE.FOPEN(l_filedir,l_filename_lang, 'r',32000); --bug#4278861: Open the file handle with 32k buffer

162: EXCEPTION WHEN OTHERS THEN
163:
164: BEGIN
165: l_filename_lang := l_filename || '_' || fnd_global.base_language;
166: v_filehandle := UTL_FILE.FOPEN(l_filedir,l_filename_lang, 'r',32000); --bug#4278861: Open the file handle with 32k buffer
167:
168: EXCEPTION WHEN OTHERS THEN
169: begin
170: v_filehandle := UTL_FILE.FOPEN(l_filedir,l_filename, 'r',32000); --bug#4278861: Open the file handle with 32k buffer

Line 170: v_filehandle := UTL_FILE.FOPEN(l_filedir,l_filename, 'r',32000); --bug#4278861: Open the file handle with 32k buffer

166: v_filehandle := UTL_FILE.FOPEN(l_filedir,l_filename_lang, 'r',32000); --bug#4278861: Open the file handle with 32k buffer
167:
168: EXCEPTION WHEN OTHERS THEN
169: begin
170: v_filehandle := UTL_FILE.FOPEN(l_filedir,l_filename, 'r',32000); --bug#4278861: Open the file handle with 32k buffer
171: exception when others then
172: return;
173: end;
174: END;

Line 180: if (UTL_FILE.is_open(v_filehandle) = true) then

176:
177: dbms_lob.createtemporary(x_TandCcontent,TRUE,DBMS_LOB.SESSION);
178:
179: /* Read the file line by line and append it to CLOB */
180: if (UTL_FILE.is_open(v_filehandle) = true) then
181: loop
182: begin
183: /* write the contents into the document */
184: UTL_FILE.GET_LINE(v_filehandle,l_terms);

Line 184: UTL_FILE.GET_LINE(v_filehandle,l_terms);

180: if (UTL_FILE.is_open(v_filehandle) = true) then
181: loop
182: begin
183: /* write the contents into the document */
184: UTL_FILE.GET_LINE(v_filehandle,l_terms);
185: if (l_terms is null) then
186: l_terms := ' ';
187: end if;
188: l_terms := l_terms||l_newline; --bug#4278861: Appended the new line to the line read from file

Line 202: UTL_FILE.fclose(v_filehandle);

198: exception when no_data_found then
199: exit;
200: end;
201: end loop;
202: UTL_FILE.fclose(v_filehandle);
203: end if;
204: end if;
205:
206: exception when others then