311: end if;
312:
313: if (px_max_asset_id = 0) then
314:
315: FND_FILE.put(FND_FILE.output,'');
316: FND_FILE.new_line(FND_FILE.output,1);
317:
318: -- dump out the headings
319: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
312:
313: if (px_max_asset_id = 0) then
314:
315: FND_FILE.put(FND_FILE.output,'');
316: FND_FILE.new_line(FND_FILE.output,1);
317:
318: -- dump out the headings
319: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
320: l_string := fnd_message.get;
318: -- dump out the headings
319: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
320: l_string := fnd_message.get;
321:
322: FND_FILE.put(FND_FILE.output,l_string);
323: FND_FILE.new_line(FND_FILE.output,1);
324:
325: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
326: l_string := fnd_message.get;
319: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
320: l_string := fnd_message.get;
321:
322: FND_FILE.put(FND_FILE.output,l_string);
323: FND_FILE.new_line(FND_FILE.output,1);
324:
325: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
326: l_string := fnd_message.get;
327:
324:
325: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
326: l_string := fnd_message.get;
327:
328: FND_FILE.put(FND_FILE.output,l_string);
329: FND_FILE.new_line(FND_FILE.output,1);
330:
331: end if;
332:
325: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
326: l_string := fnd_message.get;
327:
328: FND_FILE.put(FND_FILE.output,l_string);
329: FND_FILE.new_line(FND_FILE.output,1);
330:
331: end if;
332:
333:
929: l_mesg := substrb(fnd_message.get, 1, 100);
930:
931: l_string := rpad(p_asset_number, 15) || ' ' || l_mesg;
932:
933: FND_FILE.put(FND_FILE.output,l_string);
934: FND_FILE.new_line(FND_FILE.output,1);
935:
936: -- now process the messages for the log file
937: fa_srvr_msg.add_message
930:
931: l_string := rpad(p_asset_number, 15) || ' ' || l_mesg;
932:
933: FND_FILE.put(FND_FILE.output,l_string);
934: FND_FILE.new_line(FND_FILE.output,1);
935:
936: -- now process the messages for the log file
937: fa_srvr_msg.add_message
938: (calling_fn => l_calling_fn,