[Home] [Help]
382:
383: l_batch_size := nvl(fa_cache_pkg.fa_batch_size, 200);
384:
385: if (l_debug) then
386: fa_debug_pkg.add(l_calling_fn,
387: 'performing','fetching upload data', p_log_level_rec => g_log_level_rec);
388: end if;
389:
390: open c_assets;
473: limit l_batch_size;
474: close c_assets;
475:
476: if (l_debug) then
477: fa_debug_pkg.add(l_calling_fn,
478: 'performing','after fetching upload data', p_log_level_rec => g_log_level_rec);
479: end if;
480:
481: if l_tax_rowid.count = 0 then
487: -- set savepoint
488: savepoint taxup_savepoint;
489:
490: -- clear the debug stack for each asset
491: FA_DEBUG_PKG.Initialize;
492: -- reset the message level to prevent bogus errors
493: FA_SRVR_MSG.Set_Message_Level(message_level => 10, p_log_level_rec => g_log_level_rec);
494:
495: l_mesg_name := null;
576: -- counter for the number of assets
577: l_count := l_count + 1;
578:
579: if (l_debug) then
580: fa_debug_pkg.add(l_calling_fn,
581: 'asset_number',l_asset_number(l_loop_count));
582: fa_debug_pkg.add(l_calling_fn,
583: 'asset_id',l_asset_id(l_loop_count));
584: end if;
578:
579: if (l_debug) then
580: fa_debug_pkg.add(l_calling_fn,
581: 'asset_number',l_asset_number(l_loop_count));
582: fa_debug_pkg.add(l_calling_fn,
583: 'asset_id',l_asset_id(l_loop_count));
584: end if;
585: -- Retrieve additions_info, to retrieve asset id and shared info
586: -- across books for the asset
990: write_message(l_asset_number(l_loop_count),
991: 'FA_MCP_ADJUSTMENT_SUCCESS');
992:
993: if (l_debug) then
994: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
995: end if;
996:
997:
998: EXCEPTION -- exceptions for taxupload_records block
1003: write_message(l_asset_number(l_loop_count),
1004: l_mesg_name);
1005:
1006: if (l_debug) then
1007: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
1008: end if;
1009:
1010: rollback to savepoint taxup_savepoint;
1011:
1022: fa_srvr_msg.add_sql_error(
1023: calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1024:
1025: if (l_debug) then
1026: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
1027: end if;
1028:
1029: rollback to savepoint taxup_savepoint;
1030:
1054: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1055:
1056: -- Dump Debug messages when run in debug mode to log file
1057: if (l_debug) then
1058: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
1059: end if;
1060:
1061: x_return_status := 2;
1062:
1065: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1066:
1067: -- Dump Debug messages when run in debug mode to log file
1068: if (l_debug) then
1069: fa_debug_pkg.dump_debug_messages(max_mesgs => 0, p_log_level_rec => g_log_level_rec);
1070: end if;
1071:
1072: x_return_status := 2;
1073:
1175: end if;
1176: end if;
1177:
1178: if(g_log_level_rec.statement_level) then
1179: fa_debug_pkg.add(l_calling_fn, 'at beginning of', 'worker allocation', p_log_level_rec => g_log_level_rec);
1180: end if;
1181:
1182: x_return_status := 0;
1183:
1248:
1249: close c_tax_interface;
1250:
1251: if (g_log_level_rec.statement_level) then
1252: fa_debug_pkg.add(l_calling_fn, 'rows updated into fa_tax_interface', sql%rowcount);
1253: end if;
1254:
1255: FND_CONCURRENT.AF_COMMIT;
1256: