APPS.MSD_SSWA dependencies on UTL_FILE

Line 138: input_file utl_file.file_type;

134: * This procedure will access the batch log for the given
135: * demand plan, and display it through htp.p calls.
136: */
137: procedure show_batch_log (p_path varchar2, p_id number) is
138: input_file utl_file.file_type;
139: input_buffer varchar2(4000);
140: v_filename varchar2(4000);
141:
142: begin

Line 144: input_file := utl_file.fopen(p_path,v_filename, 'R');

140: v_filename varchar2(4000);
141:
142: begin
143: v_filename := 'MSD' || p_id || '_dpbatch.html';
144: input_file := utl_file.fopen(p_path,v_filename, 'R');
145:
146: loop
147: utl_file.get_line (input_file, input_buffer);
148: htp.p(input_buffer);

Line 147: utl_file.get_line (input_file, input_buffer);

143: v_filename := 'MSD' || p_id || '_dpbatch.html';
144: input_file := utl_file.fopen(p_path,v_filename, 'R');
145:
146: loop
147: utl_file.get_line (input_file, input_buffer);
148: htp.p(input_buffer);
149: end loop;
150:
151: EXCEPTION

Line 153: utl_file.fclose_all;

149: end loop;
150:
151: EXCEPTION
152: WHEN OTHERS then
153: utl_file.fclose_all;
154:
155: end show_batch_log;
156:
157:

Line 163: input_file utl_file.file_type;

159: * This procedure will access the batch log for the given
160: * demand plan, and display it through htp.p calls.
161: */
162: function get_batch_log (p_id number) return clob is
163: input_file utl_file.file_type;
164: input_buffer varchar2(4000);
165: v_filename varchar2(4000);
166: v_clob clob;
167:

Line 171: input_file := utl_file.fopen(fnd_profile.value('MSD_DIR_ALIAS'),v_filename, 'R');

167:
168: begin
169: dbms_lob.createtemporary(v_clob,TRUE);
170: v_filename := 'MSD' || p_id || '_dpbatch.html';
171: input_file := utl_file.fopen(fnd_profile.value('MSD_DIR_ALIAS'),v_filename, 'R');
172:
173: loop
174: utl_file.get_line(input_file, input_buffer);
175: if (length(input_buffer) > 0) then

Line 174: utl_file.get_line(input_file, input_buffer);

170: v_filename := 'MSD' || p_id || '_dpbatch.html';
171: input_file := utl_file.fopen(fnd_profile.value('MSD_DIR_ALIAS'),v_filename, 'R');
172:
173: loop
174: utl_file.get_line(input_file, input_buffer);
175: if (length(input_buffer) > 0) then
176: dbms_lob.writeappend(v_clob,length(input_buffer),input_buffer);
177: --dbms_output.put_line(substr(input_buffer,1,100));
178: end if;

Line 184: utl_file.fclose_all;

180: return v_clob;
181:
182: EXCEPTION
183: WHEN OTHERS then
184: utl_file.fclose_all;
185: --dbms_output.put_line(substr(sqlerrm,1,250));
186: return v_clob;
187:
188: end get_batch_log;