126: if (fa_cache_pkg.fazcbc_record.copy_additions_flag <> 'YES') then
127: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
128: fnd_message.set_token('TYPE','ADDITIONS',FALSE);
129: l_string := fnd_message.get;
130: FND_FILE.put(FND_FILE.output,l_string);
131: FND_FILE.new_line(FND_FILE.output,1);
132: end if;
133:
134: if (fa_cache_pkg.fazcbc_record.copy_adjustments_flag <> 'YES') then
127: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
128: fnd_message.set_token('TYPE','ADDITIONS',FALSE);
129: l_string := fnd_message.get;
130: FND_FILE.put(FND_FILE.output,l_string);
131: FND_FILE.new_line(FND_FILE.output,1);
132: end if;
133:
134: if (fa_cache_pkg.fazcbc_record.copy_adjustments_flag <> 'YES') then
135: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
134: if (fa_cache_pkg.fazcbc_record.copy_adjustments_flag <> 'YES') then
135: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
136: fnd_message.set_token('TYPE','ADJUSTMENTS',FALSE);
137: l_string := fnd_message.get;
138: FND_FILE.put(FND_FILE.output,l_string);
139: FND_FILE.new_line(FND_FILE.output,1);
140: end if;
141:
142: if (fa_cache_pkg.fazcbc_record.copy_retirements_flag <> 'YES') then
135: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
136: fnd_message.set_token('TYPE','ADJUSTMENTS',FALSE);
137: l_string := fnd_message.get;
138: FND_FILE.put(FND_FILE.output,l_string);
139: FND_FILE.new_line(FND_FILE.output,1);
140: end if;
141:
142: if (fa_cache_pkg.fazcbc_record.copy_retirements_flag <> 'YES') then
143: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
142: if (fa_cache_pkg.fazcbc_record.copy_retirements_flag <> 'YES') then
143: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
144: fnd_message.set_token('TYPE','RETIREMENTS',FALSE);
145: l_string := fnd_message.get;
146: FND_FILE.put(FND_FILE.output,l_string);
147: FND_FILE.new_line(FND_FILE.output,1);
148: end if;
149:
150: if (nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' and
143: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
144: fnd_message.set_token('TYPE','RETIREMENTS',FALSE);
145: l_string := fnd_message.get;
146: FND_FILE.put(FND_FILE.output,l_string);
147: FND_FILE.new_line(FND_FILE.output,1);
148: end if;
149:
150: if (nvl(fa_cache_pkg.fazcbc_record.allow_group_deprn_flag, 'N') = 'Y' and
151: nvl(fa_cache_pkg.fazcbc_record.copy_group_addition_flag, 'N') <> 'Y') then
151: nvl(fa_cache_pkg.fazcbc_record.copy_group_addition_flag, 'N') <> 'Y') then
152: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
153: fnd_message.set_token('TYPE','GROUP ADDITIONS',FALSE);
154: l_string := fnd_message.get;
155: FND_FILE.put(FND_FILE.output,l_string);
156: FND_FILE.new_line(FND_FILE.output,1);
157: end if;
158:
159:
152: fnd_message.set_name('OFA', 'FA_MCP_SHARED_NO_COPY');
153: fnd_message.set_token('TYPE','GROUP ADDITIONS',FALSE);
154: l_string := fnd_message.get;
155: FND_FILE.put(FND_FILE.output,l_string);
156: FND_FILE.new_line(FND_FILE.output,1);
157: end if;
158:
159:
160: FND_FILE.put(FND_FILE.output,'');
156: FND_FILE.new_line(FND_FILE.output,1);
157: end if;
158:
159:
160: FND_FILE.put(FND_FILE.output,'');
161: FND_FILE.new_line(FND_FILE.output,1);
162:
163: -- dump out the headings
164: fnd_message.set_name('OFA', 'FA_MCP_REPORT_COLUMN');
157: end if;
158:
159:
160: FND_FILE.put(FND_FILE.output,'');
161: FND_FILE.new_line(FND_FILE.output,1);
162:
163: -- dump out the headings
164: fnd_message.set_name('OFA', 'FA_MCP_REPORT_COLUMN');
165: l_string := fnd_message.get;
163: -- dump out the headings
164: fnd_message.set_name('OFA', 'FA_MCP_REPORT_COLUMN');
165: l_string := fnd_message.get;
166:
167: FND_FILE.put(FND_FILE.output,l_string);
168: FND_FILE.new_line(FND_FILE.output,1);
169:
170: fnd_message.set_name('OFA', 'FA_MCP_REPORT_LINES');
171: l_string := fnd_message.get;
164: fnd_message.set_name('OFA', 'FA_MCP_REPORT_COLUMN');
165: l_string := fnd_message.get;
166:
167: FND_FILE.put(FND_FILE.output,l_string);
168: FND_FILE.new_line(FND_FILE.output,1);
169:
170: fnd_message.set_name('OFA', 'FA_MCP_REPORT_LINES');
171: l_string := fnd_message.get;
172:
169:
170: fnd_message.set_name('OFA', 'FA_MCP_REPORT_LINES');
171: l_string := fnd_message.get;
172:
173: FND_FILE.put(FND_FILE.output,l_string);
174: FND_FILE.new_line(FND_FILE.output,1);
175:
176: end if;
177:
170: fnd_message.set_name('OFA', 'FA_MCP_REPORT_LINES');
171: l_string := fnd_message.get;
172:
173: FND_FILE.put(FND_FILE.output,l_string);
174: FND_FILE.new_line(FND_FILE.output,1);
175:
176: end if;
177:
178: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
2312: l_asset_number := rpad(p_asset_number, 15);
2313: l_thid := rpad(to_char(p_thid), 20);
2314: l_string := l_asset_number || ' ' || l_thid || ' ' || l_mesg;
2315:
2316: FND_FILE.put(FND_FILE.output,l_string);
2317: FND_FILE.new_line(FND_FILE.output,1);
2318:
2319: -- now process the message for the log file
2320: fa_srvr_msg.add_message
2313: l_thid := rpad(to_char(p_thid), 20);
2314: l_string := l_asset_number || ' ' || l_thid || ' ' || l_mesg;
2315:
2316: FND_FILE.put(FND_FILE.output,l_string);
2317: FND_FILE.new_line(FND_FILE.output,1);
2318:
2319: -- now process the message for the log file
2320: fa_srvr_msg.add_message
2321: (calling_fn => l_calling_fn,