295: end if;
296:
297: if (G_times_called = 1) then
298:
299: FND_FILE.put(FND_FILE.output,'');
300: FND_FILE.new_line(FND_FILE.output,1);
301:
302: -- dump out the headings
303: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
296:
297: if (G_times_called = 1) then
298:
299: FND_FILE.put(FND_FILE.output,'');
300: FND_FILE.new_line(FND_FILE.output,1);
301:
302: -- dump out the headings
303: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
304: l_string := fnd_message.get;
302: -- dump out the headings
303: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
304: l_string := fnd_message.get;
305:
306: FND_FILE.put(FND_FILE.output,l_string);
307: FND_FILE.new_line(FND_FILE.output,1);
308:
309: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
310: l_string := fnd_message.get;
303: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
304: l_string := fnd_message.get;
305:
306: FND_FILE.put(FND_FILE.output,l_string);
307: FND_FILE.new_line(FND_FILE.output,1);
308:
309: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
310: l_string := fnd_message.get;
311:
308:
309: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
310: l_string := fnd_message.get;
311:
312: FND_FILE.put(FND_FILE.output,l_string);
313: FND_FILE.new_line(FND_FILE.output,1);
314:
315: -- get mass reval info
316: if not get_mass_reval_info (p_mass_reval_id => p_mass_reval_id) then
309: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
310: l_string := fnd_message.get;
311:
312: FND_FILE.put(FND_FILE.output,l_string);
313: FND_FILE.new_line(FND_FILE.output,1);
314:
315: -- get mass reval info
316: if not get_mass_reval_info (p_mass_reval_id => p_mass_reval_id) then
317: raise massrvl_err;
708: l_mesg := substrb(fnd_message.get, 1, 100);
709:
710: l_string := rpad(p_asset_number, 15) || ' ' || l_mesg;
711:
712: FND_FILE.put(FND_FILE.output,l_string);
713: FND_FILE.new_line(FND_FILE.output,1);
714:
715: end if;
716:
709:
710: l_string := rpad(p_asset_number, 15) || ' ' || l_mesg;
711:
712: FND_FILE.put(FND_FILE.output,l_string);
713: FND_FILE.new_line(FND_FILE.output,1);
714:
715: end if;
716:
717: -- now process the messages for the log file