223: x_return_status := 0;
224:
225: -- Clear the debug stack for each asset
226: fa_srvr_msg.init_server_message;
227: fa_debug_pkg.initialize;
228:
229: -- Get Print Debug profile option.
230: fnd_profile.get('PRINT_DEBUG', l_debug_flag);
231:
229: -- Get Print Debug profile option.
230: fnd_profile.get('PRINT_DEBUG', l_debug_flag);
231:
232: if (l_debug_flag = 'Y') then
233: fa_debug_pkg.set_debug_flag;
234: end if;
235:
236: -- load profiles for batch size
237: if not fa_cache_pkg.fazprof then
241: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
242:
243: if (px_max_mass_ext_transfer_id = 0) then
244: if (g_log_level_rec.statement_level) then
245: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_transfer_id',
246: px_max_mass_ext_transfer_id
247: ,p_log_level_rec => g_log_level_rec);
248: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code
249: ,p_log_level_rec => g_log_level_rec);
244: if (g_log_level_rec.statement_level) then
245: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_transfer_id',
246: px_max_mass_ext_transfer_id
247: ,p_log_level_rec => g_log_level_rec);
248: fa_debug_pkg.add(l_calling_fn, 'p_book', p_book_type_code
249: ,p_log_level_rec => g_log_level_rec);
250: end if;
251:
252: if (g_log_level_rec.statement_level) then
249: ,p_log_level_rec => g_log_level_rec);
250: end if;
251:
252: if (g_log_level_rec.statement_level) then
253: fa_debug_pkg.add('FAMPSLTFRB.pls',
254: 'FND_FILE init: BOOK ', P_BOOK_TYPE_CODE
255: ,p_log_level_rec => g_log_level_rec);
256: end if;
257:
508: x_return_status := 1;
509:
510: -- Commented for bugfix 4672237
511: -- if (g_log_level_rec.statement_level) then
512: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
513: -- end if;
514:
515: fa_srvr_msg.add_message(
516: calling_fn => l_calling_fn,
528: x_return_status := 1;
529:
530: -- Commented for bugfix 4672237
531: -- if (g_log_level_rec.statement_level) then
532: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
533: -- end if;
534:
535: fa_srvr_msg.add_message(
536: calling_fn => l_calling_fn,
563: l_mass_external_transfer_id(l_mass_external_transfer_id.count);
564: end if;
565:
566: if (g_log_level_rec.statement_level) then
567: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_transfer_id',
568: px_max_mass_ext_transfer_id, p_log_level_rec => g_log_level_rec);
569: fa_debug_pkg.add(l_calling_fn, 'End of Mass External Transfers session',
570: x_return_status, p_log_level_rec => g_log_level_rec);
571: end if;
565:
566: if (g_log_level_rec.statement_level) then
567: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_transfer_id',
568: px_max_mass_ext_transfer_id, p_log_level_rec => g_log_level_rec);
569: fa_debug_pkg.add(l_calling_fn, 'End of Mass External Transfers session',
570: x_return_status, p_log_level_rec => g_log_level_rec);
571: end if;
572:
573: EXCEPTION
575: ROLLBACK TO process_transfer;
576:
577: -- Commented for bugfix 4672237
578: -- if (g_log_level_rec.statement_level) then
579: -- fa_debug_pkg.dump_debug_messages(max_mesgs => 0);
580: -- end if;
581:
582: l_transaction_status(l_counter) := 'ERROR';
583: x_failure_count := x_failure_count + 1;
610: l_mass_external_transfer_id(l_counter);
611: end if;
612:
613: if (g_log_level_rec.statement_level) then
614: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_transfer_id',
615: px_max_mass_ext_transfer_id, p_log_level_rec => g_log_level_rec);
616: fa_debug_pkg.add(l_calling_fn,'End of Mass External Transfers session',
617: x_return_status
618: ,p_log_level_rec => g_log_level_rec);
612:
613: if (g_log_level_rec.statement_level) then
614: fa_debug_pkg.add(l_calling_fn, 'px_max_mass_ext_transfer_id',
615: px_max_mass_ext_transfer_id, p_log_level_rec => g_log_level_rec);
616: fa_debug_pkg.add(l_calling_fn,'End of Mass External Transfers session',
617: x_return_status
618: ,p_log_level_rec => g_log_level_rec);
619: end if;
620: