DBA Data[Home] [Help]

APPS.FA_TAX_UPLOAD_PKG dependencies on FND_CONCURRENT

Line 1039: -- FND_CONCURRENT.AF_COMMIT every batch and reset the large rollback segment

1035: where rowid = l_tax_rowid(l_loop_count);
1036:
1037: END; -- end taxupload_records block
1038:
1039: -- FND_CONCURRENT.AF_COMMIT every batch and reset the large rollback segment
1040: FND_CONCURRENT.AF_COMMIT;
1041:
1042: end loop; -- inner loop to loop through arrays
1043:

Line 1040: FND_CONCURRENT.AF_COMMIT;

1036:
1037: END; -- end taxupload_records block
1038:
1039: -- FND_CONCURRENT.AF_COMMIT every batch and reset the large rollback segment
1040: FND_CONCURRENT.AF_COMMIT;
1041:
1042: end loop; -- inner loop to loop through arrays
1043:
1044:

Line 1053: FND_CONCURRENT.AF_ROLLBACK;

1049: when done_exc then
1050: x_return_status := 0;
1051:
1052: when faxtaxup_err then
1053: FND_CONCURRENT.AF_ROLLBACK;
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

Line 1064: FND_CONCURRENT.AF_ROLLBACK;

1060:
1061: x_return_status := 2;
1062:
1063: when others then
1064: FND_CONCURRENT.AF_ROLLBACK;
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

Line 1255: FND_CONCURRENT.AF_COMMIT;

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:
1257: x_return_status := 0;
1258:
1259: EXCEPTION

Line 1261: FND_CONCURRENT.AF_ROLLBACK;

1257: x_return_status := 0;
1258:
1259: EXCEPTION
1260: WHEN taxup_err THEN
1261: FND_CONCURRENT.AF_ROLLBACK;
1262: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1263: X_return_status := 2;
1264:
1265: WHEN OTHERS THEN

Line 1266: FND_CONCURRENT.AF_ROLLBACK;

1262: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1263: X_return_status := 2;
1264:
1265: WHEN OTHERS THEN
1266: FND_CONCURRENT.AF_ROLLBACK;
1267: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1268: x_return_status := 2;
1269:
1270: END allocate_workers;