APPS.PO_XML_UTILS_GRP dependencies on UTL_FILE

Line 131: v_filehandle UTL_FILE.file_type;

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

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

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

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

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

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

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

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

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

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

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

Line 200: UTL_FILE.fclose(v_filehandle);

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