266: x_failure_count := 0;
267:
268: if (g_times_called = 1) then
269:
270: FND_FILE.put(FND_FILE.output,'');
271: FND_FILE.new_line(FND_FILE.output,1);
272:
273: -- dump out the headings
274: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
267:
268: if (g_times_called = 1) then
269:
270: FND_FILE.put(FND_FILE.output,'');
271: FND_FILE.new_line(FND_FILE.output,1);
272:
273: -- dump out the headings
274: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
275: l_string := fnd_message.get;
273: -- dump out the headings
274: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
275: l_string := fnd_message.get;
276:
277: FND_FILE.put(FND_FILE.output,l_string);
278: FND_FILE.new_line(FND_FILE.output,1);
279:
280: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
281: l_string := fnd_message.get;
274: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
275: l_string := fnd_message.get;
276:
277: FND_FILE.put(FND_FILE.output,l_string);
278: FND_FILE.new_line(FND_FILE.output,1);
279:
280: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
281: l_string := fnd_message.get;
282:
279:
280: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
281: l_string := fnd_message.get;
282:
283: FND_FILE.put(FND_FILE.output,l_string);
284: FND_FILE.new_line(FND_FILE.output,1);
285:
286: -- get mass reval info
287: if not get_mass_reval_info (p_mass_reval_id => p_mass_reval_id) then
280: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
281: l_string := fnd_message.get;
282:
283: FND_FILE.put(FND_FILE.output,l_string);
284: FND_FILE.new_line(FND_FILE.output,1);
285:
286: -- get mass reval info
287: if not get_mass_reval_info (p_mass_reval_id => p_mass_reval_id) then
288: raise massrvl_err;
627: l_mesg := substrb(fnd_message.get, 1, 100);
628:
629: l_string := rpad(p_asset_number, 15) || ' ' || l_mesg;
630:
631: FND_FILE.put(FND_FILE.output,l_string);
632: FND_FILE.new_line(FND_FILE.output,1);
633:
634: end if;
635:
628:
629: l_string := rpad(p_asset_number, 15) || ' ' || l_mesg;
630:
631: FND_FILE.put(FND_FILE.output,l_string);
632: FND_FILE.new_line(FND_FILE.output,1);
633:
634: end if;
635:
636: -- now process the messages for the log file