125: end if;
126:
127: if (px_max_asset_id = 0) then
128:
129: FND_FILE.put(FND_FILE.output,'');
130: FND_FILE.new_line(FND_FILE.output,1);
131:
132: -- dump out the headings
133: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
126:
127: if (px_max_asset_id = 0) then
128:
129: FND_FILE.put(FND_FILE.output,'');
130: FND_FILE.new_line(FND_FILE.output,1);
131:
132: -- dump out the headings
133: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
134: l_string := fnd_message.get;
132: -- dump out the headings
133: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
134: l_string := fnd_message.get;
135:
136: FND_FILE.put(FND_FILE.output,l_string);
137: FND_FILE.new_line(FND_FILE.output,1);
138:
139: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
140: l_string := fnd_message.get;
133: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
134: l_string := fnd_message.get;
135:
136: FND_FILE.put(FND_FILE.output,l_string);
137: FND_FILE.new_line(FND_FILE.output,1);
138:
139: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
140: l_string := fnd_message.get;
141:
138:
139: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
140: l_string := fnd_message.get;
141:
142: FND_FILE.put(FND_FILE.output,l_string);
143: FND_FILE.new_line(FND_FILE.output,1);
144:
145: end if;
146:
139: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
140: l_string := fnd_message.get;
141:
142: FND_FILE.put(FND_FILE.output,l_string);
143: FND_FILE.new_line(FND_FILE.output,1);
144:
145: end if;
146:
147: -- clear the debug stack for each asset
338: l_mesg := substrb(fnd_message.get, 1, 100);
339:
340: l_string := rpad(p_asset_number, 15) || ' ' || l_mesg;
341:
342: FND_FILE.put(FND_FILE.output,l_string);
343: FND_FILE.new_line(FND_FILE.output,1);
344:
345: -- now process the messages for the log file
346: fa_srvr_msg.add_message
339:
340: l_string := rpad(p_asset_number, 15) || ' ' || l_mesg;
341:
342: FND_FILE.put(FND_FILE.output,l_string);
343: FND_FILE.new_line(FND_FILE.output,1);
344:
345: -- now process the messages for the log file
346: fa_srvr_msg.add_message
347: (calling_fn => l_calling_fn,