125: FND_FILE.put(FND_FILE.output,'');
126: FND_FILE.new_line(FND_FILE.output,1);
127:
128: -- dump out the headings
129: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
130: l_string := fnd_message.get;
131:
132: FND_FILE.put(FND_FILE.output,l_string);
133: FND_FILE.new_line(FND_FILE.output,1);
126: FND_FILE.new_line(FND_FILE.output,1);
127:
128: -- dump out the headings
129: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_COLUMN');
130: l_string := fnd_message.get;
131:
132: FND_FILE.put(FND_FILE.output,l_string);
133: FND_FILE.new_line(FND_FILE.output,1);
134:
131:
132: FND_FILE.put(FND_FILE.output,l_string);
133: FND_FILE.new_line(FND_FILE.output,1);
134:
135: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
136: l_string := fnd_message.get;
137:
138: FND_FILE.put(FND_FILE.output,l_string);
139: FND_FILE.new_line(FND_FILE.output,1);
132: FND_FILE.put(FND_FILE.output,l_string);
133: FND_FILE.new_line(FND_FILE.output,1);
134:
135: fnd_message.set_name('OFA', 'FA_MASSRET_REPORT_LINE');
136: l_string := fnd_message.get;
137:
138: FND_FILE.put(FND_FILE.output,l_string);
139: FND_FILE.new_line(FND_FILE.output,1);
140:
345: if (l_message <> 'FA_MCP_REINSTATE_SUCCESS') then
346: l_calling_fn := 'fa_mass_reins_pkg.mass_reins';
347: end if;
348:
349: fnd_message.set_name('OFA', p_message);
350: l_mesg := substrb(fnd_message.get, 1, 100);
351:
352: l_string := rpad(p_asset_number, 15) || ' ' || l_mesg;
353:
346: l_calling_fn := 'fa_mass_reins_pkg.mass_reins';
347: end if;
348:
349: fnd_message.set_name('OFA', p_message);
350: l_mesg := substrb(fnd_message.get, 1, 100);
351:
352: l_string := rpad(p_asset_number, 15) || ' ' || l_mesg;
353:
354: FND_FILE.put(FND_FILE.output,l_string);