271: x_failure_count := 0;
272:
273: if (px_max_asset_id = 0) then
274:
275: FND_FILE.put(FND_FILE.output,'');
276: FND_FILE.new_line(FND_FILE.output,1);
277:
278: -- dump out the headings
279: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
272:
273: if (px_max_asset_id = 0) then
274:
275: FND_FILE.put(FND_FILE.output,'');
276: FND_FILE.new_line(FND_FILE.output,1);
277:
278: -- dump out the headings
279: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
280: l_string := fnd_message.get;
278: -- dump out the headings
279: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
280: l_string := fnd_message.get;
281:
282: FND_FILE.put(FND_FILE.output,l_string);
283: FND_FILE.new_line(FND_FILE.output,1);
284:
285: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
286: l_string := fnd_message.get;
279: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
280: l_string := fnd_message.get;
281:
282: FND_FILE.put(FND_FILE.output,l_string);
283: FND_FILE.new_line(FND_FILE.output,1);
284:
285: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
286: l_string := fnd_message.get;
287:
284:
285: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
286: l_string := fnd_message.get;
287:
288: FND_FILE.put(FND_FILE.output,l_string);
289: FND_FILE.new_line(FND_FILE.output,1);
290:
291: end if;
292:
285: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
286: l_string := fnd_message.get;
287:
288: FND_FILE.put(FND_FILE.output,l_string);
289: FND_FILE.new_line(FND_FILE.output,1);
290:
291: end if;
292:
293:
867: l_mesg := substrb(fnd_message.get, 1, 100);
868:
869: l_string := rpad(p_asset_number, 15) || ' ' || l_mesg;
870:
871: FND_FILE.put(FND_FILE.output,l_string);
872: FND_FILE.new_line(FND_FILE.output,1);
873:
874: -- now process the messages for the log file
875: fa_srvr_msg.add_message
868:
869: l_string := rpad(p_asset_number, 15) || ' ' || l_mesg;
870:
871: FND_FILE.put(FND_FILE.output,l_string);
872: FND_FILE.new_line(FND_FILE.output,1);
873:
874: -- now process the messages for the log file
875: fa_srvr_msg.add_message
876: (calling_fn => l_calling_fn,