597:
598: -- Delete from FA_BOOKS_SUMMARY
599:
600: if (p_log_level_rec.statement_level) then
601: fa_debug_pkg.add(l_calling_fn,
602: 'Deleting FA_BOOKS_SUMMARY rows, next period ctr',
603: p_period_rec.period_counter + 1
604: ,p_log_level_rec => p_log_level_rec);
605: end if;
661: -- rollback/reverse terminal gain loss
662: -- pending new api / logic
663:
664: if (p_log_level_rec.statement_level) then
665: fa_debug_pkg.add(l_calling_fn, 'BEGIN', 'Processing terminal gain loss'
666: ,p_log_level_rec => p_log_level_rec);
667: end if;
668:
669: open c_get_thid;
670: fetch c_get_thid into l_thid, l_event_id;
671: close c_get_thid;
672:
673: if (p_log_level_rec.statement_level) then
674: fa_debug_pkg.add(l_calling_fn, 'THID of TGL', l_thid
675: ,p_log_level_rec => p_log_level_rec);
676: end if;
677:
678: if (l_thid is not null) then
677:
678: if (l_thid is not null) then
679:
680: if (p_log_level_rec.statement_level) then
681: fa_debug_pkg.add(l_calling_fn, 'event id', l_event_id
682: ,p_log_level_rec => p_log_level_rec);
683: fa_debug_pkg.add(l_calling_fn, 'sob type code', p_mrc_sob_type_code
684: ,p_log_level_rec => p_log_level_rec);
685: end if;
679:
680: if (p_log_level_rec.statement_level) then
681: fa_debug_pkg.add(l_calling_fn, 'event id', l_event_id
682: ,p_log_level_rec => p_log_level_rec);
683: fa_debug_pkg.add(l_calling_fn, 'sob type code', p_mrc_sob_type_code
684: ,p_log_level_rec => p_log_level_rec);
685: end if;
686:
687: if (l_event_id is not null) then
685: end if;
686:
687: if (l_event_id is not null) then
688: if (p_log_level_rec.statement_level) then
689: fa_debug_pkg.add(l_calling_fn, 'calling get event status for event ', l_event_id
690: ,p_log_level_rec => p_log_level_rec);
691: end if;
692:
693: l_deprn_source_info.application_id := 140;
706: p_valuation_method => p_asset_hdr_rec.book_type_code,
707: p_security_context => l_security_context);
708:
709: if (p_log_level_rec.statement_level) then
710: fa_debug_pkg.add(l_calling_fn, 'event status ', l_event_status
711: ,p_log_level_rec => p_log_level_rec);
712: end if;
713:
714: end if;
740: px_trans_rec => l_trans_rec,
741: p_event_status => NULL,
742: p_calling_fn => l_calling_fn
743: ,p_log_level_rec => p_log_level_rec) then
744: fa_debug_pkg.add(l_calling_fn, 'ERROR', 'Calling create_transaction_event'
745: ,p_log_level_rec => p_log_level_rec);
746: raise rb_error;
747: end if;
748:
1146: X_Calling_Fn => l_calling_fn
1147: ,p_log_level_rec => p_log_level_rec);
1148:
1149: if not l_status then
1150: fa_debug_pkg.add(l_calling_fn, 'Failed to insert ', 'FA_BOOKS'
1151: ,p_log_level_rec => p_log_level_rec);
1152: raise rb_error;
1153: end if;
1154:
1154:
1155: elsif (l_event_status = XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED) then
1156:
1157: if (p_log_level_rec.statement_level) then
1158: fa_debug_pkg.add(l_calling_fn, 'deleting event', l_event_id
1159: ,p_log_level_rec => p_log_level_rec);
1160: end if;
1161:
1162: XLA_EVENTS_PUB_PKG.delete_event
1244: -- End of terminal gain loss
1245:
1246: -- Bug:6665510:Japan Tax Reform Project
1247: if (g_print_debug) then
1248: fa_debug_pkg.add('FAVDRBB', 'guarantee_flag', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag);
1249: fa_debug_pkg.add('FAVDRBB', 'period_num', p_period_rec.period_num);
1250: fa_debug_pkg.add('FAVDRBB', 'pers_per_yr', pers_per_yr);
1251: end if;
1252:
1245:
1246: -- Bug:6665510:Japan Tax Reform Project
1247: if (g_print_debug) then
1248: fa_debug_pkg.add('FAVDRBB', 'guarantee_flag', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag);
1249: fa_debug_pkg.add('FAVDRBB', 'period_num', p_period_rec.period_num);
1250: fa_debug_pkg.add('FAVDRBB', 'pers_per_yr', pers_per_yr);
1251: end if;
1252:
1253: if (p_period_rec.period_num - pers_per_yr) = 0 then
1246: -- Bug:6665510:Japan Tax Reform Project
1247: if (g_print_debug) then
1248: fa_debug_pkg.add('FAVDRBB', 'guarantee_flag', fa_cache_pkg.fazccmt_record.guarantee_rate_method_flag);
1249: fa_debug_pkg.add('FAVDRBB', 'period_num', p_period_rec.period_num);
1250: fa_debug_pkg.add('FAVDRBB', 'pers_per_yr', pers_per_yr);
1251: end if;
1252:
1253: if (p_period_rec.period_num - pers_per_yr) = 0 then
1254: fa_debug_pkg.add('Updating rate_in_use', 'EOFY', 'YES');
1250: fa_debug_pkg.add('FAVDRBB', 'pers_per_yr', pers_per_yr);
1251: end if;
1252:
1253: if (p_period_rec.period_num - pers_per_yr) = 0 then
1254: fa_debug_pkg.add('Updating rate_in_use', 'EOFY', 'YES');
1255:
1256: if (p_mrc_sob_type_code = 'R') then
1257: Null;
1258: else
1276: if l_rows_processed = 0 then
1277: exit;
1278: end if;
1279:
1280: fa_debug_pkg.add('FAVDRBB', 'l_bks_rowid_tbl2.count', l_bks_rowid_tbl2.count);
1281:
1282: for i in 1..l_bks_rowid_tbl2.count loop
1283: fa_debug_pkg.add('FAVDRBB', 'l_asset_id_tbl2(i)', l_asset_id_tbl2(i));
1284: fa_debug_pkg.add('FAVDRBB', 'l_method_code_tbl2(i)', l_method_code_tbl2(i));
1279:
1280: fa_debug_pkg.add('FAVDRBB', 'l_bks_rowid_tbl2.count', l_bks_rowid_tbl2.count);
1281:
1282: for i in 1..l_bks_rowid_tbl2.count loop
1283: fa_debug_pkg.add('FAVDRBB', 'l_asset_id_tbl2(i)', l_asset_id_tbl2(i));
1284: fa_debug_pkg.add('FAVDRBB', 'l_method_code_tbl2(i)', l_method_code_tbl2(i));
1285:
1286: FA_CDE_PKG.faxgfr (X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
1287: X_Asset_Id => l_asset_id_tbl2(i),
1280: fa_debug_pkg.add('FAVDRBB', 'l_bks_rowid_tbl2.count', l_bks_rowid_tbl2.count);
1281:
1282: for i in 1..l_bks_rowid_tbl2.count loop
1283: fa_debug_pkg.add('FAVDRBB', 'l_asset_id_tbl2(i)', l_asset_id_tbl2(i));
1284: fa_debug_pkg.add('FAVDRBB', 'l_method_code_tbl2(i)', l_method_code_tbl2(i));
1285:
1286: FA_CDE_PKG.faxgfr (X_Book_Type_Code => p_asset_hdr_rec.book_type_code,
1287: X_Asset_Id => l_asset_id_tbl2(i),
1288: X_Short_Fiscal_Year_Flag => NULL,
1306: raise rb_error;
1307: end if;
1308: end loop;
1309:
1310: fa_debug_pkg.add('FAVDRBB', 'update fa_books.rate_in_use', l_bks_rowid_tbl2.count);
1311:
1312: forall i IN 1..l_bks_rowid_tbl2.count
1313: update fa_books
1314: set rate_in_use = l_rate_in_use_tbl(i)