193: end if;
194:
195: -- Clear the debug stack for each asset
196: fa_srvr_msg.init_server_message;
197: fa_debug_pkg.initialize;
198:
199: -- Get Print Debug profile option.
200: fnd_profile.get('PRINT_DEBUG', l_debug_flag);
201:
199: -- Get Print Debug profile option.
200: fnd_profile.get('PRINT_DEBUG', l_debug_flag);
201:
202: if (l_debug_flag = 'Y') then
203: fa_debug_pkg.set_debug_flag;
204: end if;
205:
206: -- load profiles for batch size
207: if not fa_cache_pkg.fazprof then
211: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
212:
213: if (px_max_mass_ext_transfer_id = 0) then
214: if (g_log_level_rec.statement_level) then
215: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_transfer_id',
216: px_max_mass_ext_transfer_id, p_log_level_rec => g_log_level_rec);
217: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code, p_log_level_rec => g_log_level_rec);
218: fa_debug_pkg.add(l_calling_fn, 'p_batch_name', p_batch_name, p_log_level_rec => g_log_level_rec);
219: end if;
213: if (px_max_mass_ext_transfer_id = 0) then
214: if (g_log_level_rec.statement_level) then
215: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_transfer_id',
216: px_max_mass_ext_transfer_id, p_log_level_rec => g_log_level_rec);
217: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code, p_log_level_rec => g_log_level_rec);
218: fa_debug_pkg.add(l_calling_fn, 'p_batch_name', p_batch_name, p_log_level_rec => g_log_level_rec);
219: end if;
220:
221: FND_FILE.put(FND_FILE.output,'');
214: if (g_log_level_rec.statement_level) then
215: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_transfer_id',
216: px_max_mass_ext_transfer_id, p_log_level_rec => g_log_level_rec);
217: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code, p_log_level_rec => g_log_level_rec);
218: fa_debug_pkg.add(l_calling_fn, 'p_batch_name', p_batch_name, p_log_level_rec => g_log_level_rec);
219: end if;
220:
221: FND_FILE.put(FND_FILE.output,'');
222: FND_FILE.new_line(FND_FILE.output,1);
340: -- Mark batch as failed but continue despite errors
341: ROLLBACK TO process_transfer;
342:
343: if (g_log_level_rec.statement_level) then
344: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
345: end if;
346:
347: l_transaction_status(i) := 'ERROR';
348: x_failure_count := x_failure_count + 1;
443: -- Mark batch as failed but continue despite errors
444: ROLLBACK TO process_transfer;
445:
446: if (g_log_level_rec.statement_level) then
447: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
448: end if;
449:
450: l_transaction_status(i) := 'ERROR';
451: x_failure_count := x_failure_count + 1;
492: l_mass_external_transfer_id(l_mass_external_transfer_id.count);
493: end if;
494:
495: if (g_log_level_rec.statement_level) then
496: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_transfer_id',
497: px_max_mass_ext_transfer_id, p_log_level_rec => g_log_level_rec);
498: fa_debug_pkg.add(l_calling_fn, 'End of Mass External Transfers session',
499: x_return_status, p_log_level_rec => g_log_level_rec);
500: end if;
494:
495: if (g_log_level_rec.statement_level) then
496: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_transfer_id',
497: px_max_mass_ext_transfer_id, p_log_level_rec => g_log_level_rec);
498: fa_debug_pkg.add(l_calling_fn, 'End of Mass External Transfers session',
499: x_return_status, p_log_level_rec => g_log_level_rec);
500: end if;
501:
502: EXCEPTION
511:
512: ROLLBACK TO process_transfer;
513:
514: if (g_log_level_rec.statement_level) then
515: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
516: end if;
517:
518: l_transaction_status(l_counter) := 'ERROR';
519: x_failure_count := x_failure_count + 1;
543: l_mass_external_transfer_id(l_counter);
544: end if;
545:
546: if (g_log_level_rec.statement_level) then
547: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_transfer_id',
548: px_max_mass_ext_transfer_id, p_log_level_rec => g_log_level_rec);
549: fa_debug_pkg.add(l_calling_fn,'End of Mass External Transfers session',
550: x_return_status, p_log_level_rec => g_log_level_rec);
551: end if;
545:
546: if (g_log_level_rec.statement_level) then
547: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_transfer_id',
548: px_max_mass_ext_transfer_id, p_log_level_rec => g_log_level_rec);
549: fa_debug_pkg.add(l_calling_fn,'End of Mass External Transfers session',
550: x_return_status, p_log_level_rec => g_log_level_rec);
551: end if;
552:
553: END do_mass_transfer;