eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_GAINLOSS_RET_PKG dependencies on FA_DEBUG_PKG

Line 105: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in faggin 1', '', p_log_level_rec => p_log_level_rec); end if;

101: l_calling_fn varchar2(40) := 'fa_gainloss_ret_pkg.faggin';
102:
103: BEGIN <>
104:
105: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in faggin 1', '', p_log_level_rec => p_log_level_rec); end if;
106: h_adj_capacity := 0;
107: h_capacity := 0;
108: h_unrevalued_cost := 0;
109: h_reval_amort_basis := 0;

Line 504: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in faggin 2', '', p_log_level_rec => p_log_level_rec); end if;

500: AND ctype.prorate_convention_code = h_ret_p_conv;
501:
502: end if;
503:
504: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in faggin 2', '', p_log_level_rec => p_log_level_rec); end if;
505:
506: h_same_fy := 0;
507:
508: select decode(fy1.fiscal_year, fy2.fiscal_year,1,0)

Line 524: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in faggin 3', '', p_log_level_rec => p_log_level_rec); end if;

520: h_ret_prorate_date := h_prorate_date;
521:
522: end if;
523:
524: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in faggin 3', '', p_log_level_rec => p_log_level_rec); end if;
525:
526:
527: SELECT FISCAL.FISCAL_YEAR
528: INTO h_ret_fiscalyr

Line 534: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in faggin 4', '', p_log_level_rec => p_log_level_rec); end if;

530: WHERE trunc(h_ret_prorate_date)
531: between START_DATE and END_DATE
532: AND fiscal_year_name = h_fiscal_year_name;
533:
534: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in faggin 4', '', p_log_level_rec => p_log_level_rec); end if;
535:
536: if (h_ret_fiscalyr <> h_cpd_fiscal_year) then
537:
538: if h_ret_fiscalyr < h_cpd_fiscal_year then

Line 560: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in faggin 5', '', p_log_level_rec => p_log_level_rec); end if;

556: end if;
557:
558: end if; -- end of - if (h_ret_fiscalyr
559:
560: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in faggin 5', '', p_log_level_rec => p_log_level_rec); end if;
561:
562:
563: if h_rate_source_rule <> 1 then -- rate_source_rule <> 'CALCULATED'
564:

Line 565: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in faggin 6', '', p_log_level_rec => p_log_level_rec); end if;

561:
562:
563: if h_rate_source_rule <> 1 then -- rate_source_rule <> 'CALCULATED'
564:
565: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in faggin 6', '', p_log_level_rec => p_log_level_rec); end if;
566: if (h_same_fy > 0) and
567: (h_depr_first_year_ret is null or h_depr_first_year_ret <= 0) and
568: (h_dwacq > 0) then
569:

Line 591: fa_debug_pkg.add(l_calling_fn, 'in faggin 7', '', p_log_level_rec => p_log_level_rec);

587: end;
588: end if;
589: else
590: if p_log_level_rec.statement_level then
591: fa_debug_pkg.add(l_calling_fn, 'in faggin 7', '', p_log_level_rec => p_log_level_rec);
592: fa_debug_pkg.add(l_calling_fn, to_char(trunc(h_ret_prorate_date)), '');
593: fa_debug_pkg.add(l_calling_fn, to_char(trunc(h_prorate_date)), '');
594: end if;
595:

Line 592: fa_debug_pkg.add(l_calling_fn, to_char(trunc(h_ret_prorate_date)), '');

588: end if;
589: else
590: if p_log_level_rec.statement_level then
591: fa_debug_pkg.add(l_calling_fn, 'in faggin 7', '', p_log_level_rec => p_log_level_rec);
592: fa_debug_pkg.add(l_calling_fn, to_char(trunc(h_ret_prorate_date)), '');
593: fa_debug_pkg.add(l_calling_fn, to_char(trunc(h_prorate_date)), '');
594: end if;
595:
596: begin

Line 593: fa_debug_pkg.add(l_calling_fn, to_char(trunc(h_prorate_date)), '');

589: else
590: if p_log_level_rec.statement_level then
591: fa_debug_pkg.add(l_calling_fn, 'in faggin 7', '', p_log_level_rec => p_log_level_rec);
592: fa_debug_pkg.add(l_calling_fn, to_char(trunc(h_ret_prorate_date)), '');
593: fa_debug_pkg.add(l_calling_fn, to_char(trunc(h_prorate_date)), '');
594: end if;
595:
596: begin
597: SELECT h_prorate_date

Line 609: fa_debug_pkg.add(l_calling_fn, 'Final h_ret_prorate_date', to_char(h_ret_prorate_date));

605:
606: end if;
607:
608: if p_log_level_rec.statement_level then
609: fa_debug_pkg.add(l_calling_fn, 'Final h_ret_prorate_date', to_char(h_ret_prorate_date));
610: fa_debug_pkg.add(l_calling_fn, 'in faggin 8', '', p_log_level_rec => p_log_level_rec);
611: end if;
612: bk.prorate_date := h_prorate_date;
613: bk.deprn_start_date := h_deprn_start_date;

Line 610: fa_debug_pkg.add(l_calling_fn, 'in faggin 8', '', p_log_level_rec => p_log_level_rec);

606: end if;
607:
608: if p_log_level_rec.statement_level then
609: fa_debug_pkg.add(l_calling_fn, 'Final h_ret_prorate_date', to_char(h_ret_prorate_date));
610: fa_debug_pkg.add(l_calling_fn, 'in faggin 8', '', p_log_level_rec => p_log_level_rec);
611: end if;
612: bk.prorate_date := h_prorate_date;
613: bk.deprn_start_date := h_deprn_start_date;
614: bk.ret_prorate_date := h_ret_prorate_date;

Line 731: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in faggin 100', '', p_log_level_rec => p_log_level_rec); end if;

727: bk.terminal_gain_loss_amount := h_terminal_gain_loss_amount;
728: ret.wip_asset := h_wip_asset;
729: bk.pc_fully_reserved := h_pc_fully_reserved;
730:
731: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in faggin 100', '', p_log_level_rec => p_log_level_rec); end if;
732:
733: return(TRUE);
734:
735: EXCEPTION

Line 965: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'IN FAGGRV', '', p_log_level_rec => p_log_level_rec); end if;

961: l_calling_fn varchar2(80) := 'fa_gainloss_ret_pkg.faggrv';
962:
963: BEGIN <>
964:
965: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'IN FAGGRV', '', p_log_level_rec => p_log_level_rec); end if;
966:
967: if p_log_level_rec.statement_level then
968: fa_debug_pkg.add
969: (fname => l_calling_fn,

Line 968: fa_debug_pkg.add

964:
965: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'IN FAGGRV', '', p_log_level_rec => p_log_level_rec); end if;
966:
967: if p_log_level_rec.statement_level then
968: fa_debug_pkg.add
969: (fname => l_calling_fn,
970: element => 'Getting depreciation reserve adjustments',
971: value => '', p_log_level_rec => p_log_level_rec);
972: end if;

Line 1069: fa_debug_pkg.add(l_calling_fn, 'BEGIN', p_ret.asset_id, p_log_level_rec => p_log_level_rec);

1065: l_grp_err exception;
1066:
1067: begin
1068: if p_log_level_rec.statement_level then
1069: fa_debug_pkg.add(l_calling_fn, 'BEGIN', p_ret.asset_id, p_log_level_rec => p_log_level_rec);
1070: end if;
1071:
1072: if (nvl(p_bk.recapture_reserve_flag, 'N') = 'Y') then
1073: -- get reserve and cost

Line 1111: fa_debug_pkg.add(l_calling_fn, 'after', 'query balance', p_log_level_rec => p_log_level_rec);

1107: X_set_of_books_id => p_ret.set_of_books_id,
1108: p_log_level_rec => p_log_level_rec);
1109:
1110: if p_log_level_rec.statement_level then
1111: fa_debug_pkg.add(l_calling_fn, 'after', 'query balance', p_log_level_rec => p_log_level_rec);
1112: fa_debug_pkg.add(l_calling_fn, 'p_bk.current_cost', p_bk.current_cost, p_log_level_rec => p_log_level_rec);
1113: fa_debug_pkg.add(l_calling_fn, 'p_ret.cost_retired', p_ret.cost_retired, p_log_level_rec => p_log_level_rec);
1114: fa_debug_pkg.add(l_calling_fn, 'l_g_rsv', l_g_rsv, p_log_level_rec => p_log_level_rec);
1115: end if;

Line 1112: fa_debug_pkg.add(l_calling_fn, 'p_bk.current_cost', p_bk.current_cost, p_log_level_rec => p_log_level_rec);

1108: p_log_level_rec => p_log_level_rec);
1109:
1110: if p_log_level_rec.statement_level then
1111: fa_debug_pkg.add(l_calling_fn, 'after', 'query balance', p_log_level_rec => p_log_level_rec);
1112: fa_debug_pkg.add(l_calling_fn, 'p_bk.current_cost', p_bk.current_cost, p_log_level_rec => p_log_level_rec);
1113: fa_debug_pkg.add(l_calling_fn, 'p_ret.cost_retired', p_ret.cost_retired, p_log_level_rec => p_log_level_rec);
1114: fa_debug_pkg.add(l_calling_fn, 'l_g_rsv', l_g_rsv, p_log_level_rec => p_log_level_rec);
1115: end if;
1116:

Line 1113: fa_debug_pkg.add(l_calling_fn, 'p_ret.cost_retired', p_ret.cost_retired, p_log_level_rec => p_log_level_rec);

1109:
1110: if p_log_level_rec.statement_level then
1111: fa_debug_pkg.add(l_calling_fn, 'after', 'query balance', p_log_level_rec => p_log_level_rec);
1112: fa_debug_pkg.add(l_calling_fn, 'p_bk.current_cost', p_bk.current_cost, p_log_level_rec => p_log_level_rec);
1113: fa_debug_pkg.add(l_calling_fn, 'p_ret.cost_retired', p_ret.cost_retired, p_log_level_rec => p_log_level_rec);
1114: fa_debug_pkg.add(l_calling_fn, 'l_g_rsv', l_g_rsv, p_log_level_rec => p_log_level_rec);
1115: end if;
1116:
1117: -- compare the two amounts and find out recapture is necessary

Line 1114: fa_debug_pkg.add(l_calling_fn, 'l_g_rsv', l_g_rsv, p_log_level_rec => p_log_level_rec);

1110: if p_log_level_rec.statement_level then
1111: fa_debug_pkg.add(l_calling_fn, 'after', 'query balance', p_log_level_rec => p_log_level_rec);
1112: fa_debug_pkg.add(l_calling_fn, 'p_bk.current_cost', p_bk.current_cost, p_log_level_rec => p_log_level_rec);
1113: fa_debug_pkg.add(l_calling_fn, 'p_ret.cost_retired', p_ret.cost_retired, p_log_level_rec => p_log_level_rec);
1114: fa_debug_pkg.add(l_calling_fn, 'l_g_rsv', l_g_rsv, p_log_level_rec => p_log_level_rec);
1115: end if;
1116:
1117: -- compare the two amounts and find out recapture is necessary
1118: if (((nvl(p_bk.current_cost - p_ret.cost_retired, 0) - l_g_rsv) < 0) and sign(p_bk.current_cost- p_ret.cost_retired) >= 0) or

Line 1122: fa_debug_pkg.add(l_calling_fn, 'creating', 'recapture entry', p_log_level_rec => p_log_level_rec);

1118: if (((nvl(p_bk.current_cost - p_ret.cost_retired, 0) - l_g_rsv) < 0) and sign(p_bk.current_cost- p_ret.cost_retired) >= 0) or
1119: (((nvl(p_bk.current_cost - p_ret.cost_retired, 0) - l_g_rsv) > 0) and sign(p_bk.current_cost- p_ret.cost_retired) <= 0) then
1120: -- need to recapture excess reserve
1121: if p_log_level_rec.statement_level then
1122: fa_debug_pkg.add(l_calling_fn, 'creating', 'recapture entry', p_log_level_rec => p_log_level_rec);
1123: end if;
1124:
1125: l_adj.source_type_code := 'RETIREMENT';
1126:

Line 1155: fa_debug_pkg.add(l_calling_fn, 'error calling', 'FA_UTIL_PVT.get_asset_cat_rec', p_log_level_rec => p_log_level_rec);

1151: px_asset_cat_rec => l_asset_cat_rec,
1152: p_date_effective => null,
1153: p_log_level_rec => p_log_level_rec) then
1154: if p_log_level_rec.statement_level then
1155: fa_debug_pkg.add(l_calling_fn, 'error calling', 'FA_UTIL_PVT.get_asset_cat_rec', p_log_level_rec => p_log_level_rec);
1156: end if;
1157: raise l_grp_err;
1158: end if;
1159:

Line 1164: fa_debug_pkg.add(l_calling_fn, 'error calling', 'fazccb', p_log_level_rec => p_log_level_rec);

1160: if not fa_cache_pkg.fazccb(X_book => p_ret.book,
1161: X_cat_id => l_asset_cat_rec.category_id,
1162: p_log_level_rec => p_log_level_rec) then
1163: if p_log_level_rec.statement_level then
1164: fa_debug_pkg.add(l_calling_fn, 'error calling', 'fazccb', p_log_level_rec => p_log_level_rec);
1165: end if;
1166: raise l_grp_err;
1167: end if;
1168:

Line 1172: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj', 'for reserve', p_log_level_rec => p_log_level_rec);

1168:
1169: l_adj.account := fa_cache_pkg.fazccb_record.DEPRN_RESERVE_ACCT;
1170:
1171: if p_log_level_rec.statement_level then
1172: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj', 'for reserve', p_log_level_rec => p_log_level_rec);
1173: end if;
1174:
1175: if not FA_INS_ADJUST_PKG.faxinaj
1176: (l_adj,

Line 1181: fa_debug_pkg.add(l_calling_fn, 'error calling', 'faxinaj', p_log_level_rec => p_log_level_rec);

1177: l_trans_rec.who_info.last_update_date,
1178: l_trans_rec.who_info.last_updated_by,
1179: l_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
1180: if p_log_level_rec.statement_level then
1181: fa_debug_pkg.add(l_calling_fn, 'error calling', 'faxinaj', p_log_level_rec => p_log_level_rec);
1182: end if;
1183: raise l_grp_err;
1184: end if;
1185:

Line 1195: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj', 'for nbv retired', p_log_level_rec => p_log_level_rec);

1191: l_adj.account_type := 'NBV_RETIRED_GAIN_ACCT';
1192: l_adj.account := fa_cache_pkg.fazcbc_record.nbv_retired_gain_acct;
1193:
1194: if p_log_level_rec.statement_level then
1195: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj', 'for nbv retired', p_log_level_rec => p_log_level_rec);
1196: end if;
1197:
1198: if not FA_INS_ADJUST_PKG.faxinaj
1199: (l_adj,

Line 1204: fa_debug_pkg.add(l_calling_fn, 'error calling', 'faxinaj', p_log_level_rec => p_log_level_rec);

1200: l_trans_rec.who_info.last_update_date,
1201: l_trans_rec.who_info.last_updated_by,
1202: l_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
1203: if p_log_level_rec.statement_level then
1204: fa_debug_pkg.add(l_calling_fn, 'error calling', 'faxinaj', p_log_level_rec => p_log_level_rec);
1205: end if;
1206: raise l_grp_err;
1207: end if;
1208:

Line 1228: fa_debug_pkg.add(l_calling_fn, 'Updating FA_ADJUSTMENTS for thid of', p_ret.th_id_in, p_log_level_rec => p_log_level_rec);

1224: -- Prepare to call FA_ADJUSTMENT_PVT.do_adjustment to process group
1225: -- asset after member asset retirement.
1226: --
1227: if p_log_level_rec.statement_level then
1228: fa_debug_pkg.add(l_calling_fn, 'Updating FA_ADJUSTMENTS for thid of', p_ret.th_id_in, p_log_level_rec => p_log_level_rec);
1229: fa_debug_pkg.add(l_calling_fn, 'asset', p_ret.asset_id, p_log_level_rec => p_log_level_rec);
1230: fa_debug_pkg.add(l_calling_fn, 'book', p_ret.book, p_log_level_rec => p_log_level_rec);
1231: end if;
1232:

Line 1229: fa_debug_pkg.add(l_calling_fn, 'asset', p_ret.asset_id, p_log_level_rec => p_log_level_rec);

1225: -- asset after member asset retirement.
1226: --
1227: if p_log_level_rec.statement_level then
1228: fa_debug_pkg.add(l_calling_fn, 'Updating FA_ADJUSTMENTS for thid of', p_ret.th_id_in, p_log_level_rec => p_log_level_rec);
1229: fa_debug_pkg.add(l_calling_fn, 'asset', p_ret.asset_id, p_log_level_rec => p_log_level_rec);
1230: fa_debug_pkg.add(l_calling_fn, 'book', p_ret.book, p_log_level_rec => p_log_level_rec);
1231: end if;
1232:
1233: if (p_ret.mrc_sob_type_code <> 'R') then

Line 1230: fa_debug_pkg.add(l_calling_fn, 'book', p_ret.book, p_log_level_rec => p_log_level_rec);

1226: --
1227: if p_log_level_rec.statement_level then
1228: fa_debug_pkg.add(l_calling_fn, 'Updating FA_ADJUSTMENTS for thid of', p_ret.th_id_in, p_log_level_rec => p_log_level_rec);
1229: fa_debug_pkg.add(l_calling_fn, 'asset', p_ret.asset_id, p_log_level_rec => p_log_level_rec);
1230: fa_debug_pkg.add(l_calling_fn, 'book', p_ret.book, p_log_level_rec => p_log_level_rec);
1231: end if;
1232:
1233: if (p_ret.mrc_sob_type_code <> 'R') then
1234: OPEN c_get_thid;

Line 1239: fa_debug_pkg.add(l_calling_fn, 'Updating FA_ADJUSTMENTS with thid of', g_grp_trx_hdr_id, p_log_level_rec => p_log_level_rec);

1235: FETCH c_get_thid INTO g_grp_trx_hdr_id;
1236: CLOSE c_get_thid;
1237:
1238: if p_log_level_rec.statement_level then
1239: fa_debug_pkg.add(l_calling_fn, 'Updating FA_ADJUSTMENTS with thid of', g_grp_trx_hdr_id, p_log_level_rec => p_log_level_rec);
1240: end if;
1241:
1242: if (g_grp_trx_hdr_id is not null) then
1243: UPDATE FA_ADJUSTMENTS

Line 1251: fa_debug_pkg.add(l_calling_fn, 'Updating FA_MC_ADJUSTMENTS with thid of', g_grp_trx_hdr_id, p_log_level_rec => p_log_level_rec);

1247: AND BOOK_TYPE_CODE = p_ret.book;
1248: end if;
1249: else
1250: if p_log_level_rec.statement_level then
1251: fa_debug_pkg.add(l_calling_fn, 'Updating FA_MC_ADJUSTMENTS with thid of', g_grp_trx_hdr_id, p_log_level_rec => p_log_level_rec);
1252: end if;
1253: UPDATE FA_MC_ADJUSTMENTS
1254: SET TRANSACTION_HEADER_ID = g_grp_trx_hdr_id
1255: WHERE TRANSACTION_HEADER_ID = p_ret.th_id_in

Line 1262: fa_debug_pkg.add(l_calling_fn, 'END', 'SUCCESS', p_log_level_rec => p_log_level_rec);

1258: AND SET_OF_BOOKS_ID = p_ret.set_of_books_id;
1259: end if;
1260:
1261: if p_log_level_rec.statement_level then
1262: fa_debug_pkg.add(l_calling_fn, 'END', 'SUCCESS', p_log_level_rec => p_log_level_rec);
1263: end if;
1264:
1265: return TRUE;
1266:

Line 1270: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION',

1266:
1267: EXCEPTION
1268: when l_grp_err then
1269: if p_log_level_rec.statement_level then
1270: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION',
1271: 'l_grp_err', p_log_level_rec => p_log_level_rec);
1272: end if;
1273: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1274: return FALSE;

Line 1278: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION',

1274: return FALSE;
1275:
1276: when others then
1277: if p_log_level_rec.statement_level then
1278: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION',
1279: 'OTHERS', p_log_level_rec => p_log_level_rec);
1280: end if;
1281:
1282: if c_get_thid%ISOPEN then

Line 1517: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in fagret1 ', '', p_log_level_rec => p_log_level_rec); end if;

1513: return false;
1514: end if;
1515: end if;
1516:
1517: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in fagret1 ', '', p_log_level_rec => p_log_level_rec); end if;
1518:
1519: if not faggrv(ret.asset_id, ret.book, cpd_ctr, deprn_reserve,
1520: reval_reserve, prior_fy_exp, ytd_deprn,
1521: bonus_deprn_reserve, bonus_ytd_deprn,

Line 1542: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in fagret2', '', p_log_level_rec => p_log_level_rec); end if;

1538: return(FALSE);
1539:
1540: end if;
1541:
1542: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in fagret2', '', p_log_level_rec => p_log_level_rec); end if;
1543:
1544: dpr.deprn_rsv := deprn_reserve;
1545: dpr.reval_rsv := reval_reserve;
1546: dpr.prior_fy_exp := prior_fy_exp;

Line 1611: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in fagret3', '', p_log_level_rec => p_log_level_rec); end if;

1607: return(FALSE);
1608:
1609: end if;
1610:
1611: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in fagret3', '', p_log_level_rec => p_log_level_rec); end if;
1612:
1613: /* If it's capitalize and also depreciate, we will calculate
1614: depreciation; otherwise, we will skip it
1615: */

Line 1811: fa_debug_pkg.add (l_calling_fn, 'bk.depr_first_year_ret BEFORE if', bk.depr_first_year_ret, p_log_level_rec => p_log_level_rec);

1807: -- fagdpdp/farboe to calculate backout expense if prorate date falls in the
1808: -- past.
1809:
1810: if p_log_level_rec.statement_level then
1811: fa_debug_pkg.add (l_calling_fn, 'bk.depr_first_year_ret BEFORE if', bk.depr_first_year_ret, p_log_level_rec => p_log_level_rec);
1812: fa_debug_pkg.add (l_calling_fn, 'periods_catchup', periods_catchup, p_log_level_rec => p_log_level_rec);
1813: fa_debug_pkg.add (l_calling_fn, 'bk.depr_first_year_ret', bk.depr_first_year_ret, p_log_level_rec => p_log_level_rec);
1814: if (bk.fully_reserved = null) then
1815: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'NULL !!');

Line 1812: fa_debug_pkg.add (l_calling_fn, 'periods_catchup', periods_catchup, p_log_level_rec => p_log_level_rec);

1808: -- past.
1809:
1810: if p_log_level_rec.statement_level then
1811: fa_debug_pkg.add (l_calling_fn, 'bk.depr_first_year_ret BEFORE if', bk.depr_first_year_ret, p_log_level_rec => p_log_level_rec);
1812: fa_debug_pkg.add (l_calling_fn, 'periods_catchup', periods_catchup, p_log_level_rec => p_log_level_rec);
1813: fa_debug_pkg.add (l_calling_fn, 'bk.depr_first_year_ret', bk.depr_first_year_ret, p_log_level_rec => p_log_level_rec);
1814: if (bk.fully_reserved = null) then
1815: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'NULL !!');
1816: elsif (bk.fully_reserved) then

Line 1813: fa_debug_pkg.add (l_calling_fn, 'bk.depr_first_year_ret', bk.depr_first_year_ret, p_log_level_rec => p_log_level_rec);

1809:
1810: if p_log_level_rec.statement_level then
1811: fa_debug_pkg.add (l_calling_fn, 'bk.depr_first_year_ret BEFORE if', bk.depr_first_year_ret, p_log_level_rec => p_log_level_rec);
1812: fa_debug_pkg.add (l_calling_fn, 'periods_catchup', periods_catchup, p_log_level_rec => p_log_level_rec);
1813: fa_debug_pkg.add (l_calling_fn, 'bk.depr_first_year_ret', bk.depr_first_year_ret, p_log_level_rec => p_log_level_rec);
1814: if (bk.fully_reserved = null) then
1815: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'NULL !!');
1816: elsif (bk.fully_reserved) then
1817: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'TRUE', p_log_level_rec => p_log_level_rec);

Line 1815: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'NULL !!');

1811: fa_debug_pkg.add (l_calling_fn, 'bk.depr_first_year_ret BEFORE if', bk.depr_first_year_ret, p_log_level_rec => p_log_level_rec);
1812: fa_debug_pkg.add (l_calling_fn, 'periods_catchup', periods_catchup, p_log_level_rec => p_log_level_rec);
1813: fa_debug_pkg.add (l_calling_fn, 'bk.depr_first_year_ret', bk.depr_first_year_ret, p_log_level_rec => p_log_level_rec);
1814: if (bk.fully_reserved = null) then
1815: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'NULL !!');
1816: elsif (bk.fully_reserved) then
1817: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'TRUE', p_log_level_rec => p_log_level_rec);
1818: else
1819: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'FALSE', p_log_level_rec => p_log_level_rec);

Line 1817: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'TRUE', p_log_level_rec => p_log_level_rec);

1813: fa_debug_pkg.add (l_calling_fn, 'bk.depr_first_year_ret', bk.depr_first_year_ret, p_log_level_rec => p_log_level_rec);
1814: if (bk.fully_reserved = null) then
1815: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'NULL !!');
1816: elsif (bk.fully_reserved) then
1817: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'TRUE', p_log_level_rec => p_log_level_rec);
1818: else
1819: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'FALSE', p_log_level_rec => p_log_level_rec);
1820: end if;
1821: end if;

Line 1819: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'FALSE', p_log_level_rec => p_log_level_rec);

1815: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'NULL !!');
1816: elsif (bk.fully_reserved) then
1817: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'TRUE', p_log_level_rec => p_log_level_rec);
1818: else
1819: fa_debug_pkg.add (l_calling_fn, 'bk.fully_reserved', 'FALSE', p_log_level_rec => p_log_level_rec);
1820: end if;
1821: end if;
1822: --Bug#6920756, Using l_decision_flag to judge if the asset is fully reserved/fully extended.
1823: -- Bug 8211842 : Check if asset has started extended depreciation

Line 1839: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in fagret3.1', '', p_log_level_rec => p_log_level_rec); end if;

1835: if (periods_catchup > 0 or bk.depr_first_year_ret = 0) and bk.depreciate
1836: --and (not bk.fully_reserved) then
1837: and (not l_decision_flag) then --Bug#6920756, Using l_decision_flag instead of fully_reserved.
1838:
1839: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in fagret3.1', '', p_log_level_rec => p_log_level_rec); end if;
1840:
1841: --bug13014394: checking to see if override exists for retirement
1842: if fa_cache_pkg.fa_deprn_override_enabled then
1843: open c_override_exist(ret.asset_id, 'POST', l_rowid);

Line 1876: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in fagret3.2', '', p_log_level_rec => p_log_level_rec); end if;

1872: return(FALSE);
1873:
1874: end if;
1875:
1876: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in fagret3.2', '', p_log_level_rec => p_log_level_rec); end if;
1877:
1878: -- Bug4343087:
1879: -- In order to find correct catchup amount without rounding
1880: -- error we need to find expense before retirement(before) and

Line 1885: fa_debug_pkg.add (l_calling_fn, 'before deprn_amt', deprn_amt, p_log_level_rec => p_log_level_rec);

1881: -- after retirement(after) and then subtract after amount from before.
1882: -- Following portion of code finds after amounts and then subtract
1883: -- before amount that is found in previous fagcdp call.
1884: if p_log_level_rec.statement_level then
1885: fa_debug_pkg.add (l_calling_fn, 'before deprn_amt', deprn_amt, p_log_level_rec => p_log_level_rec);
1886: fa_debug_pkg.add (l_calling_fn, 'before bonus_deprn_amt', bonus_deprn_amt, p_log_level_rec => p_log_level_rec);
1887: fa_debug_pkg.add (l_calling_fn, 'before reval_deprn_amt', reval_deprn_amt, p_log_level_rec => p_log_level_rec);
1888: fa_debug_pkg.add (l_calling_fn, 'before reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);
1889: end if;

Line 1886: fa_debug_pkg.add (l_calling_fn, 'before bonus_deprn_amt', bonus_deprn_amt, p_log_level_rec => p_log_level_rec);

1882: -- Following portion of code finds after amounts and then subtract
1883: -- before amount that is found in previous fagcdp call.
1884: if p_log_level_rec.statement_level then
1885: fa_debug_pkg.add (l_calling_fn, 'before deprn_amt', deprn_amt, p_log_level_rec => p_log_level_rec);
1886: fa_debug_pkg.add (l_calling_fn, 'before bonus_deprn_amt', bonus_deprn_amt, p_log_level_rec => p_log_level_rec);
1887: fa_debug_pkg.add (l_calling_fn, 'before reval_deprn_amt', reval_deprn_amt, p_log_level_rec => p_log_level_rec);
1888: fa_debug_pkg.add (l_calling_fn, 'before reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);
1889: end if;
1890:

Line 1887: fa_debug_pkg.add (l_calling_fn, 'before reval_deprn_amt', reval_deprn_amt, p_log_level_rec => p_log_level_rec);

1883: -- before amount that is found in previous fagcdp call.
1884: if p_log_level_rec.statement_level then
1885: fa_debug_pkg.add (l_calling_fn, 'before deprn_amt', deprn_amt, p_log_level_rec => p_log_level_rec);
1886: fa_debug_pkg.add (l_calling_fn, 'before bonus_deprn_amt', bonus_deprn_amt, p_log_level_rec => p_log_level_rec);
1887: fa_debug_pkg.add (l_calling_fn, 'before reval_deprn_amt', reval_deprn_amt, p_log_level_rec => p_log_level_rec);
1888: fa_debug_pkg.add (l_calling_fn, 'before reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);
1889: end if;
1890:
1891: --bug13014394: checking back to see if override is used during previous fagcdp call

Line 1888: fa_debug_pkg.add (l_calling_fn, 'before reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);

1884: if p_log_level_rec.statement_level then
1885: fa_debug_pkg.add (l_calling_fn, 'before deprn_amt', deprn_amt, p_log_level_rec => p_log_level_rec);
1886: fa_debug_pkg.add (l_calling_fn, 'before bonus_deprn_amt', bonus_deprn_amt, p_log_level_rec => p_log_level_rec);
1887: fa_debug_pkg.add (l_calling_fn, 'before reval_deprn_amt', reval_deprn_amt, p_log_level_rec => p_log_level_rec);
1888: fa_debug_pkg.add (l_calling_fn, 'before reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);
1889: end if;
1890:
1891: --bug13014394: checking back to see if override is used during previous fagcdp call
1892: if fa_cache_pkg.fa_deprn_override_enabled and

Line 1946: fa_debug_pkg.add (l_calling_fn, 'calling function', 'FA_GAINLOSS_DPR_PKG.fagcdp', p_log_level_rec => p_log_level_rec);

1942: dpr.deprn_rsv := deprn_reserve - dpr.deprn_rsv;
1943: -- end fix for 4639408
1944:
1945: if p_log_level_rec.statement_level then
1946: fa_debug_pkg.add (l_calling_fn, 'calling function', 'FA_GAINLOSS_DPR_PKG.fagcdp', p_log_level_rec => p_log_level_rec);
1947: end if;
1948:
1949: -- Find new expense using after amounts
1950: if not FA_GAINLOSS_DPR_PKG.fagcdp(dpr, deprn_amt,

Line 1960: fa_debug_pkg.add (l_calling_fn, 'calling FA_GAINLOSS_DPR_PKG.fagcdp', 'FAILED', p_log_level_rec => p_log_level_rec);

1956: bk.prorate_fy, bk.dsd_fy, bk.prorate_jdate,
1957: bk.deprn_start_jdate, p_log_level_rec => p_log_level_rec) then
1958:
1959: if p_log_level_rec.statement_level then
1960: fa_debug_pkg.add (l_calling_fn, 'calling FA_GAINLOSS_DPR_PKG.fagcdp', 'FAILED', p_log_level_rec => p_log_level_rec);
1961: end if;
1962:
1963: fa_srvr_msg.add_message(
1964: calling_fn => l_calling_fn,

Line 1978: fa_debug_pkg.add (l_calling_fn, 'after deprn_amt', deprn_amt, p_log_level_rec => p_log_level_rec);

1974:
1975: end if;
1976:
1977: if p_log_level_rec.statement_level then
1978: fa_debug_pkg.add (l_calling_fn, 'after deprn_amt', deprn_amt, p_log_level_rec => p_log_level_rec);
1979: fa_debug_pkg.add (l_calling_fn, 'after bonus_deprn_amt', bonus_deprn_amt, p_log_level_rec => p_log_level_rec);
1980: fa_debug_pkg.add (l_calling_fn, 'after reval_deprn_amt', reval_deprn_amt, p_log_level_rec => p_log_level_rec);
1981: fa_debug_pkg.add (l_calling_fn, 'after reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);
1982: end if;

Line 1979: fa_debug_pkg.add (l_calling_fn, 'after bonus_deprn_amt', bonus_deprn_amt, p_log_level_rec => p_log_level_rec);

1975: end if;
1976:
1977: if p_log_level_rec.statement_level then
1978: fa_debug_pkg.add (l_calling_fn, 'after deprn_amt', deprn_amt, p_log_level_rec => p_log_level_rec);
1979: fa_debug_pkg.add (l_calling_fn, 'after bonus_deprn_amt', bonus_deprn_amt, p_log_level_rec => p_log_level_rec);
1980: fa_debug_pkg.add (l_calling_fn, 'after reval_deprn_amt', reval_deprn_amt, p_log_level_rec => p_log_level_rec);
1981: fa_debug_pkg.add (l_calling_fn, 'after reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);
1982: end if;
1983:

Line 1980: fa_debug_pkg.add (l_calling_fn, 'after reval_deprn_amt', reval_deprn_amt, p_log_level_rec => p_log_level_rec);

1976:
1977: if p_log_level_rec.statement_level then
1978: fa_debug_pkg.add (l_calling_fn, 'after deprn_amt', deprn_amt, p_log_level_rec => p_log_level_rec);
1979: fa_debug_pkg.add (l_calling_fn, 'after bonus_deprn_amt', bonus_deprn_amt, p_log_level_rec => p_log_level_rec);
1980: fa_debug_pkg.add (l_calling_fn, 'after reval_deprn_amt', reval_deprn_amt, p_log_level_rec => p_log_level_rec);
1981: fa_debug_pkg.add (l_calling_fn, 'after reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);
1982: end if;
1983:
1984: -- Find catchup amount by subtracting before from after amounts.

Line 1981: fa_debug_pkg.add (l_calling_fn, 'after reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);

1977: if p_log_level_rec.statement_level then
1978: fa_debug_pkg.add (l_calling_fn, 'after deprn_amt', deprn_amt, p_log_level_rec => p_log_level_rec);
1979: fa_debug_pkg.add (l_calling_fn, 'after bonus_deprn_amt', bonus_deprn_amt, p_log_level_rec => p_log_level_rec);
1980: fa_debug_pkg.add (l_calling_fn, 'after reval_deprn_amt', reval_deprn_amt, p_log_level_rec => p_log_level_rec);
1981: fa_debug_pkg.add (l_calling_fn, 'after reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);
1982: end if;
1983:
1984: -- Find catchup amount by subtracting before from after amounts.
1985: deprn_amt := l_temp_deprn_amt - deprn_amt;

Line 1992: fa_debug_pkg.add (l_calling_fn, '+ final deprn_amt', deprn_amt, p_log_level_rec => p_log_level_rec);

1988: reval_deprn_amt := l_temp_reval_deprn_amt - reval_deprn_amt;
1989: reval_amort := l_temp_reval_amort - reval_amort;
1990:
1991: if p_log_level_rec.statement_level then
1992: fa_debug_pkg.add (l_calling_fn, '+ final deprn_amt', deprn_amt, p_log_level_rec => p_log_level_rec);
1993: fa_debug_pkg.add (l_calling_fn, '+ final bonus_deprn_amt', bonus_deprn_amt, p_log_level_rec => p_log_level_rec);
1994: fa_debug_pkg.add (l_calling_fn, '+ final reval_deprn_amt', reval_deprn_amt, p_log_level_rec => p_log_level_rec);
1995: fa_debug_pkg.add (l_calling_fn, '+ final reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);
1996: end if;

Line 1993: fa_debug_pkg.add (l_calling_fn, '+ final bonus_deprn_amt', bonus_deprn_amt, p_log_level_rec => p_log_level_rec);

1989: reval_amort := l_temp_reval_amort - reval_amort;
1990:
1991: if p_log_level_rec.statement_level then
1992: fa_debug_pkg.add (l_calling_fn, '+ final deprn_amt', deprn_amt, p_log_level_rec => p_log_level_rec);
1993: fa_debug_pkg.add (l_calling_fn, '+ final bonus_deprn_amt', bonus_deprn_amt, p_log_level_rec => p_log_level_rec);
1994: fa_debug_pkg.add (l_calling_fn, '+ final reval_deprn_amt', reval_deprn_amt, p_log_level_rec => p_log_level_rec);
1995: fa_debug_pkg.add (l_calling_fn, '+ final reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);
1996: end if;
1997:

Line 1994: fa_debug_pkg.add (l_calling_fn, '+ final reval_deprn_amt', reval_deprn_amt, p_log_level_rec => p_log_level_rec);

1990:
1991: if p_log_level_rec.statement_level then
1992: fa_debug_pkg.add (l_calling_fn, '+ final deprn_amt', deprn_amt, p_log_level_rec => p_log_level_rec);
1993: fa_debug_pkg.add (l_calling_fn, '+ final bonus_deprn_amt', bonus_deprn_amt, p_log_level_rec => p_log_level_rec);
1994: fa_debug_pkg.add (l_calling_fn, '+ final reval_deprn_amt', reval_deprn_amt, p_log_level_rec => p_log_level_rec);
1995: fa_debug_pkg.add (l_calling_fn, '+ final reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);
1996: end if;
1997:
1998: -- Set original value back in case subsequent calls

Line 1995: fa_debug_pkg.add (l_calling_fn, '+ final reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);

1991: if p_log_level_rec.statement_level then
1992: fa_debug_pkg.add (l_calling_fn, '+ final deprn_amt', deprn_amt, p_log_level_rec => p_log_level_rec);
1993: fa_debug_pkg.add (l_calling_fn, '+ final bonus_deprn_amt', bonus_deprn_amt, p_log_level_rec => p_log_level_rec);
1994: fa_debug_pkg.add (l_calling_fn, '+ final reval_deprn_amt', reval_deprn_amt, p_log_level_rec => p_log_level_rec);
1995: fa_debug_pkg.add (l_calling_fn, '+ final reval_amort', reval_amort, p_log_level_rec => p_log_level_rec);
1996: end if;
1997:
1998: -- Set original value back in case subsequent calls
1999: -- are expecting before amounts

Line 2062: fa_debug_pkg.add (l_calling_fn, 'before calling fagpdp', '', p_log_level_rec => p_log_level_rec);

2058:
2059: end if; -- if (periods_catchup
2060:
2061: if p_log_level_rec.statement_level then
2062: fa_debug_pkg.add (l_calling_fn, 'before calling fagpdp', '', p_log_level_rec => p_log_level_rec);
2063: end if;
2064:
2065: -- Bug 5525968: called fagpdp only in case where expense row need to inserted for
2066: -- member with member info.

Line 2071: fa_debug_pkg.add (l_calling_fn, 'calling fagpdp 1', '', p_log_level_rec => p_log_level_rec);

2067: if bk.group_asset_id is null or
2068: (bk.group_asset_id is not null and bk.tracking_method = 'CALCULATE') then
2069:
2070: if p_log_level_rec.statement_level then
2071: fa_debug_pkg.add (l_calling_fn, 'calling fagpdp 1', '', p_log_level_rec => p_log_level_rec);
2072: end if;
2073: if not FA_GAINLOSS_UPD_PKG.fagpdp(ret, bk, dpr, today,
2074: periods_catchup, cpd_ctr,
2075: cpdnum, cost_frac, deprn_amt,

Line 2100: fa_debug_pkg.add (l_calling_fn, 'after calling fagpdp', '', p_log_level_rec => p_log_level_rec);

2096:
2097: end if; -- if (bk.group_asset_id
2098:
2099: if p_log_level_rec.statement_level then
2100: fa_debug_pkg.add (l_calling_fn, 'after calling fagpdp', '', p_log_level_rec => p_log_level_rec);
2101: end if;
2102:
2103: end if; -- end of - if bk.capitalize
2104:

Line 2175: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in fagret3.2.2', '', p_log_level_rec => p_log_level_rec); end if;

2171: return(FALSE);
2172:
2173: end if;
2174:
2175: if p_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'in fagret3.2.2', '', p_log_level_rec => p_log_level_rec); end if;
2176:
2177: -- Bug4343087:
2178: -- In order to find correct catchup amount without rounding
2179: -- error we need to find expense before retirement(before) and

Line 2184: fa_debug_pkg.add (l_calling_fn, 'before group_deprn_amt', deprn_amt_group, p_log_level_rec => p_log_level_rec);

2180: -- after retirement(after) and then subtract after amount from before.
2181: -- Following portion of code finds after amounts and then subtract
2182: -- before amount that is found in previous fagcdp call.
2183: if p_log_level_rec.statement_level then
2184: fa_debug_pkg.add (l_calling_fn, 'before group_deprn_amt', deprn_amt_group, p_log_level_rec => p_log_level_rec);
2185: fa_debug_pkg.add (l_calling_fn, 'before group_bonus_deprn_amt', bonus_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2186: fa_debug_pkg.add (l_calling_fn, 'before group_reval_deprn_amt', reval_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2187: fa_debug_pkg.add (l_calling_fn, 'before group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);
2188: end if;

Line 2185: fa_debug_pkg.add (l_calling_fn, 'before group_bonus_deprn_amt', bonus_deprn_amt_group, p_log_level_rec => p_log_level_rec);

2181: -- Following portion of code finds after amounts and then subtract
2182: -- before amount that is found in previous fagcdp call.
2183: if p_log_level_rec.statement_level then
2184: fa_debug_pkg.add (l_calling_fn, 'before group_deprn_amt', deprn_amt_group, p_log_level_rec => p_log_level_rec);
2185: fa_debug_pkg.add (l_calling_fn, 'before group_bonus_deprn_amt', bonus_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2186: fa_debug_pkg.add (l_calling_fn, 'before group_reval_deprn_amt', reval_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2187: fa_debug_pkg.add (l_calling_fn, 'before group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);
2188: end if;
2189:

Line 2186: fa_debug_pkg.add (l_calling_fn, 'before group_reval_deprn_amt', reval_deprn_amt_group, p_log_level_rec => p_log_level_rec);

2182: -- before amount that is found in previous fagcdp call.
2183: if p_log_level_rec.statement_level then
2184: fa_debug_pkg.add (l_calling_fn, 'before group_deprn_amt', deprn_amt_group, p_log_level_rec => p_log_level_rec);
2185: fa_debug_pkg.add (l_calling_fn, 'before group_bonus_deprn_amt', bonus_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2186: fa_debug_pkg.add (l_calling_fn, 'before group_reval_deprn_amt', reval_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2187: fa_debug_pkg.add (l_calling_fn, 'before group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);
2188: end if;
2189:
2190: --bug13014394: checking back to see if override is used during previous fagcdp call

Line 2187: fa_debug_pkg.add (l_calling_fn, 'before group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);

2183: if p_log_level_rec.statement_level then
2184: fa_debug_pkg.add (l_calling_fn, 'before group_deprn_amt', deprn_amt_group, p_log_level_rec => p_log_level_rec);
2185: fa_debug_pkg.add (l_calling_fn, 'before group_bonus_deprn_amt', bonus_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2186: fa_debug_pkg.add (l_calling_fn, 'before group_reval_deprn_amt', reval_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2187: fa_debug_pkg.add (l_calling_fn, 'before group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);
2188: end if;
2189:
2190: --bug13014394: checking back to see if override is used during previous fagcdp call
2191: if fa_cache_pkg.fa_deprn_override_enabled and

Line 2248: fa_debug_pkg.add (l_calling_fn, 'calling function', 'FA_GAINLOSS_DPR_PKG.fagcdp', p_log_level_rec => p_log_level_rec);

2244: dpr_group.deprn_rsv := deprn_reserve - dpr_group.deprn_rsv;
2245: -- end fix for 4639408
2246:
2247: if p_log_level_rec.statement_level then
2248: fa_debug_pkg.add (l_calling_fn, 'calling function', 'FA_GAINLOSS_DPR_PKG.fagcdp', p_log_level_rec => p_log_level_rec);
2249: end if;
2250:
2251: -- Find new expense using after amounts
2252: if not FA_GAINLOSS_DPR_PKG.fagcdp(dpr_group, deprn_amt_group,

Line 2262: fa_debug_pkg.add (l_calling_fn, 'calling FA_GAINLOSS_DPR_PKG.fagcdp', 'FAILED', p_log_level_rec => p_log_level_rec);

2258: bk_group.prorate_fy, bk_group.dsd_fy, bk_group.prorate_jdate,
2259: bk_group.deprn_start_jdate, p_log_level_rec => p_log_level_rec) then
2260:
2261: if p_log_level_rec.statement_level then
2262: fa_debug_pkg.add (l_calling_fn, 'calling FA_GAINLOSS_DPR_PKG.fagcdp', 'FAILED', p_log_level_rec => p_log_level_rec);
2263: end if;
2264:
2265: fa_srvr_msg.add_message(
2266: calling_fn => l_calling_fn,

Line 2280: fa_debug_pkg.add (l_calling_fn, 'after group_deprn_amt', deprn_amt_group, p_log_level_rec => p_log_level_rec);

2276:
2277: end if;
2278:
2279: if p_log_level_rec.statement_level then
2280: fa_debug_pkg.add (l_calling_fn, 'after group_deprn_amt', deprn_amt_group, p_log_level_rec => p_log_level_rec);
2281: fa_debug_pkg.add (l_calling_fn, 'after group_bonus_deprn_amt', bonus_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2282: fa_debug_pkg.add (l_calling_fn, 'after group_reval_deprn_amt', reval_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2283: fa_debug_pkg.add (l_calling_fn, 'after group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);
2284: end if;

Line 2281: fa_debug_pkg.add (l_calling_fn, 'after group_bonus_deprn_amt', bonus_deprn_amt_group, p_log_level_rec => p_log_level_rec);

2277: end if;
2278:
2279: if p_log_level_rec.statement_level then
2280: fa_debug_pkg.add (l_calling_fn, 'after group_deprn_amt', deprn_amt_group, p_log_level_rec => p_log_level_rec);
2281: fa_debug_pkg.add (l_calling_fn, 'after group_bonus_deprn_amt', bonus_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2282: fa_debug_pkg.add (l_calling_fn, 'after group_reval_deprn_amt', reval_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2283: fa_debug_pkg.add (l_calling_fn, 'after group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);
2284: end if;
2285:

Line 2282: fa_debug_pkg.add (l_calling_fn, 'after group_reval_deprn_amt', reval_deprn_amt_group, p_log_level_rec => p_log_level_rec);

2278:
2279: if p_log_level_rec.statement_level then
2280: fa_debug_pkg.add (l_calling_fn, 'after group_deprn_amt', deprn_amt_group, p_log_level_rec => p_log_level_rec);
2281: fa_debug_pkg.add (l_calling_fn, 'after group_bonus_deprn_amt', bonus_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2282: fa_debug_pkg.add (l_calling_fn, 'after group_reval_deprn_amt', reval_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2283: fa_debug_pkg.add (l_calling_fn, 'after group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);
2284: end if;
2285:
2286: -- Find catchup amount by subtracting before from after amounts.

Line 2283: fa_debug_pkg.add (l_calling_fn, 'after group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);

2279: if p_log_level_rec.statement_level then
2280: fa_debug_pkg.add (l_calling_fn, 'after group_deprn_amt', deprn_amt_group, p_log_level_rec => p_log_level_rec);
2281: fa_debug_pkg.add (l_calling_fn, 'after group_bonus_deprn_amt', bonus_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2282: fa_debug_pkg.add (l_calling_fn, 'after group_reval_deprn_amt', reval_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2283: fa_debug_pkg.add (l_calling_fn, 'after group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);
2284: end if;
2285:
2286: -- Find catchup amount by subtracting before from after amounts.
2287: deprn_amt_group := l_temp_deprn_amt - deprn_amt_group;

Line 2294: fa_debug_pkg.add (l_calling_fn, '+ final group_deprn_amt', deprn_amt_group, p_log_level_rec => p_log_level_rec);

2290: reval_deprn_amt_group := l_temp_reval_deprn_amt - reval_deprn_amt_group;
2291: reval_amort_group := l_temp_reval_amort - reval_amort_group;
2292:
2293: if p_log_level_rec.statement_level then
2294: fa_debug_pkg.add (l_calling_fn, '+ final group_deprn_amt', deprn_amt_group, p_log_level_rec => p_log_level_rec);
2295: fa_debug_pkg.add (l_calling_fn, '+ final group_bonus_deprn_amt', bonus_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2296: fa_debug_pkg.add (l_calling_fn, '+ final group_reval_deprn_amt', reval_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2297: fa_debug_pkg.add (l_calling_fn, '+ final group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);
2298: end if;

Line 2295: fa_debug_pkg.add (l_calling_fn, '+ final group_bonus_deprn_amt', bonus_deprn_amt_group, p_log_level_rec => p_log_level_rec);

2291: reval_amort_group := l_temp_reval_amort - reval_amort_group;
2292:
2293: if p_log_level_rec.statement_level then
2294: fa_debug_pkg.add (l_calling_fn, '+ final group_deprn_amt', deprn_amt_group, p_log_level_rec => p_log_level_rec);
2295: fa_debug_pkg.add (l_calling_fn, '+ final group_bonus_deprn_amt', bonus_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2296: fa_debug_pkg.add (l_calling_fn, '+ final group_reval_deprn_amt', reval_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2297: fa_debug_pkg.add (l_calling_fn, '+ final group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);
2298: end if;
2299:

Line 2296: fa_debug_pkg.add (l_calling_fn, '+ final group_reval_deprn_amt', reval_deprn_amt_group, p_log_level_rec => p_log_level_rec);

2292:
2293: if p_log_level_rec.statement_level then
2294: fa_debug_pkg.add (l_calling_fn, '+ final group_deprn_amt', deprn_amt_group, p_log_level_rec => p_log_level_rec);
2295: fa_debug_pkg.add (l_calling_fn, '+ final group_bonus_deprn_amt', bonus_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2296: fa_debug_pkg.add (l_calling_fn, '+ final group_reval_deprn_amt', reval_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2297: fa_debug_pkg.add (l_calling_fn, '+ final group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);
2298: end if;
2299:
2300: -- Set original value back in case subsequent calls

Line 2297: fa_debug_pkg.add (l_calling_fn, '+ final group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);

2293: if p_log_level_rec.statement_level then
2294: fa_debug_pkg.add (l_calling_fn, '+ final group_deprn_amt', deprn_amt_group, p_log_level_rec => p_log_level_rec);
2295: fa_debug_pkg.add (l_calling_fn, '+ final group_bonus_deprn_amt', bonus_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2296: fa_debug_pkg.add (l_calling_fn, '+ final group_reval_deprn_amt', reval_deprn_amt_group, p_log_level_rec => p_log_level_rec);
2297: fa_debug_pkg.add (l_calling_fn, '+ final group_reval_amort', reval_amort_group, p_log_level_rec => p_log_level_rec);
2298: end if;
2299:
2300: -- Set original value back in case subsequent calls
2301: -- are expecting before amounts

Line 2443: fa_debug_pkg.add (l_calling_fn, 'before calling fagurt', '', p_log_level_rec => p_log_level_rec);

2439:
2440: end if;
2441:
2442: if p_log_level_rec.statement_level then
2443: fa_debug_pkg.add (l_calling_fn, 'before calling fagurt', '', p_log_level_rec => p_log_level_rec);
2444: end if;
2445:
2446: if not FA_GAINLOSS_UPD_PKG.fagurt(ret, bk, cpd_ctr, dpr,
2447: cost_frac, retpdnum,

Line 2467: fa_debug_pkg.add (l_calling_fn, 'after calling fagurt', '', p_log_level_rec => p_log_level_rec);

2463:
2464: end if; -- end of - if not rupd.fagurt
2465:
2466: if p_log_level_rec.statement_level then
2467: fa_debug_pkg.add (l_calling_fn, 'after calling fagurt', '', p_log_level_rec => p_log_level_rec);
2468: end if;
2469:
2470:
2471: if (bk.group_asset_id is not null) then

Line 2478: fa_debug_pkg.add (l_calling_fn, 'calling fagpdp 2', '', p_log_level_rec => p_log_level_rec);

2474: -- Bug11886090: Code in this section has been moved up before fagprv call.
2475:
2476: if bk.tracking_method is null then
2477: if p_log_level_rec.statement_level then
2478: fa_debug_pkg.add (l_calling_fn, 'calling fagpdp 2', '', p_log_level_rec => p_log_level_rec);
2479: end if;
2480: if not FA_GAINLOSS_UPD_PKG.fagpdp(ret_group, bk_group, dpr_group, today,
2481: periods_catchup, cpd_ctr,
2482: cpdnum, cost_frac, deprn_amt_group,

Line 2505: fa_debug_pkg.add (l_calling_fn, 'calling fagpdp 3', '', p_log_level_rec => p_log_level_rec);

2501:
2502: end if;
2503: elsif bk.tracking_method = 'ALLOCATE' then
2504: if p_log_level_rec.statement_level then
2505: fa_debug_pkg.add (l_calling_fn, 'calling fagpdp 3', '', p_log_level_rec => p_log_level_rec);
2506: end if;
2507: if not FA_GAINLOSS_UPD_PKG.fagpdp(ret_group, bk_group, dpr_group, today,
2508: periods_catchup, cpd_ctr,
2509: cpdnum, cost_frac, deprn_amt_group,

Line 2531: fa_debug_pkg.add (l_calling_fn, 'calling fagpdp 4', '', p_log_level_rec => p_log_level_rec);

2527: return(FALSE);
2528: end if;
2529:
2530: if p_log_level_rec.statement_level then
2531: fa_debug_pkg.add (l_calling_fn, 'calling fagpdp 4', '', p_log_level_rec => p_log_level_rec);
2532: end if;
2533: if not FA_GAINLOSS_UPD_PKG.fagpdp(ret, bk, dpr_group, today,
2534: periods_catchup, cpd_ctr,
2535: cpdnum, cost_frac, deprn_amt_group,

Line 2559: fa_debug_pkg.add (l_calling_fn, 'calling fagpdp 6', '', p_log_level_rec => p_log_level_rec);

2555:
2556: elsif bk.tracking_method = 'CALCULATE' and bk.member_rollup_flag = 'N' then
2557:
2558: if p_log_level_rec.statement_level then
2559: fa_debug_pkg.add (l_calling_fn, 'calling fagpdp 6', '', p_log_level_rec => p_log_level_rec);
2560: end if;
2561: if not FA_GAINLOSS_UPD_PKG.fagpdp(ret_group, bk_group, dpr_group, today,
2562: periods_catchup, cpd_ctr,
2563: cpdnum, cost_frac, deprn_amt_group,