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_UPD_PKG dependencies on FA_CACHE_PKG

Line 1091: if not fa_cache_pkg.fazccb

1087: end if;
1088:
1089: if (bk.group_asset_id is not null) and
1090: (nvl(bk.member_rollup_flag, 'N') = 'N') then
1091: if not fa_cache_pkg.fazccb
1092: (X_book => ret.book,
1093: X_cat_id => l_asset_cat_rec_m.category_id, p_log_level_rec => p_log_level_rec) then
1094: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1095: return(FALSE);

Line 1557: if fa_cache_pkg.fazcbc_record.sorp_enabled_flag = 'Y' then

1553: end if;
1554:
1555: --Bug 6666666 If SORP is enabled create additional accounting entries
1556: -- to clear capital adjustment and general fund
1557: if fa_cache_pkg.fazcbc_record.sorp_enabled_flag = 'Y' then
1558:
1559: l_prev_leveling_flag := adj_row.leveling_flag;
1560: adj_row.leveling_flag := FALSE;
1561:

Line 1567: adj_row.account := fa_cache_pkg.fazccb_record.capital_adj_acct;

1563: -- Capital Adjustment
1564: --******************************************************
1565: adj_row.adjustment_type := 'CAPITAL ADJ';
1566: adj_row.account_type := 'CAPITAL_ADJ_ACCT';
1567: adj_row.account := fa_cache_pkg.fazccb_record.capital_adj_acct;
1568: adj_row.debit_credit_flag := 'DR';
1569:
1570: if (p_log_level_rec.statement_level) then
1571: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Retirement

Line 1588: adj_row.account := fa_cache_pkg.fazccb_record.general_fund_acct;

1584: -- General Fund
1585: --******************************************************
1586: adj_row.adjustment_type := 'GENERAL FUND';
1587: adj_row.account_type := 'GENERAL_FUND_ACCT';
1588: adj_row.account := fa_cache_pkg.fazccb_record.general_fund_acct;
1589: adj_row.debit_credit_flag := 'CR';
1590:
1591: if (p_log_level_rec.statement_level) then
1592: fa_debug_pkg.add(l_calling_fn,'Calling faxinaj for ', 'Retirement

Line 1638: if not fa_cache_pkg.fazccb(

1634: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1635: return(FALSE);
1636: end if;
1637:
1638: if not fa_cache_pkg.fazccb(
1639: X_book => ret.book,
1640: X_cat_id => l_asset_cat_rec_g.category_id, p_log_level_rec => p_log_level_rec) then
1641: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
1642: return(FALSE);

Line 1721: (ret.wip_asset > 0 and nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'N'))) then

1717: /* End of fix for bug 2444408 */
1718: /*Bug#12768930 - allow creation of reval rsv ret entry for CIP assets and non sorp book */
1719: if ((h_retire_reval_flag = 1) and
1720: ((ret.wip_asset is null or ret.wip_asset <= 0) or
1721: (ret.wip_asset > 0 and nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') = 'N'))) then
1722:
1723: if ret.reval_rsv_retired <> 0 then
1724: -- Bug 6666666 : For SORP, the reveal gain/loss should go into
1725: -- the capital adjustment account

Line 1726: if fa_cache_pkg.fazcbc_record.sorp_enabled_flag = 'Y' then

1722:
1723: if ret.reval_rsv_retired <> 0 then
1724: -- Bug 6666666 : For SORP, the reveal gain/loss should go into
1725: -- the capital adjustment account
1726: if fa_cache_pkg.fazcbc_record.sorp_enabled_flag = 'Y' then
1727: adj_row.adjustment_type := 'CAPITAL ADJ';
1728: l_prev_leveling_flag := adj_row.leveling_flag;
1729: adj_row.leveling_flag := FALSE;
1730: else

Line 1774: if fa_cache_pkg.fazcbc_record.sorp_enabled_flag = 'Y' then

1770:
1771: end if;
1772:
1773: -- Bug 6666666 : Reset the leveling flag to the original
1774: if fa_cache_pkg.fazcbc_record.sorp_enabled_flag = 'Y' then
1775: adj_row.leveling_flag := l_prev_leveling_flag;
1776: end if;
1777:
1778: if p_log_level_rec.statement_level then

Line 2878: if not fa_cache_pkg.fazcct(p_cal, p_log_level_rec => p_log_level_rec) then

2874: h_transaction_header_id;
2875:
2876: --Bug6503327
2877: -- Get the number of periods per year in the rate calendar
2878: if not fa_cache_pkg.fazcct(p_cal, p_log_level_rec => p_log_level_rec) then
2879: fa_srvr_msg.add_message(calling_fn => 'fa_gainloss_upd_pkg.farboe', p_log_level_rec => p_log_level_rec);
2880: raise farboe_err;
2881: end if;
2882:

Line 2883: p_pers_per_yr := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

2879: fa_srvr_msg.add_message(calling_fn => 'fa_gainloss_upd_pkg.farboe', p_log_level_rec => p_log_level_rec);
2880: raise farboe_err;
2881: end if;
2882:
2883: p_pers_per_yr := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
2884:
2885: if p_pers_per_yr = 365 then
2886: if h_i = h_start_pdnum then
2887:

Line 2967: if not fa_cache_pkg.fazccp(p_cal, fiscal_year_name,

2963: exception
2964: when others then
2965: l_same_year := 'N';
2966: end;
2967: if not fa_cache_pkg.fazccp(p_cal, fiscal_year_name,
2968: bk.deprn_start_jdate,
2969: deprn_start_pnum, deprn_start_fy, dummy_num, p_log_level_rec => p_log_level_rec) then
2970: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
2971: raise farboe_err;

Line 2973: if not fa_cache_pkg.fazccp(d_cal, fiscal_year_name,

2969: deprn_start_pnum, deprn_start_fy, dummy_num, p_log_level_rec => p_log_level_rec) then
2970: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
2971: raise farboe_err;
2972: end if;
2973: if not fa_cache_pkg.fazccp(d_cal, fiscal_year_name,
2974: bk.deprn_start_jdate,
2975: deprn_start_dp_num, deprn_start_fy, dummy_num, p_log_level_rec => p_log_level_rec) then
2976: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
2977: raise farboe_err;

Line 3114: if not fa_cache_pkg.fazcct(p_cal) then

3110: h_pc,
3111: h_transaction_header_id;
3112:
3113: -- Bug#11698717: Added fixes done for bugs 6503327,8892905, -- 9487137 and 9230184 for mrc.
3114: if not fa_cache_pkg.fazcct(p_cal) then
3115: fa_srvr_msg.add_message(calling_fn => 'fa_gainloss_upd_pkg.farboe');
3116: raise farboe_err;
3117: end if;
3118:

Line 3119: p_pers_per_yr := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

3115: fa_srvr_msg.add_message(calling_fn => 'fa_gainloss_upd_pkg.farboe');
3116: raise farboe_err;
3117: end if;
3118:
3119: p_pers_per_yr := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
3120: if p_pers_per_yr = 365 then
3121: if h_i = h_start_pdnum then
3122: select fcp2.period_num + 1 - fcp1.period_num, fcp3.end_date + 1 - fcp3.start_date
3123: into h_ret_pd_nums, h_tot_days_in_mon

Line 3194: if not fa_cache_pkg.fazccp(p_cal, fiscal_year_name,

3190: when others then
3191: l_same_year := 'N';
3192: end;
3193:
3194: if not fa_cache_pkg.fazccp(p_cal, fiscal_year_name,
3195: bk.deprn_start_jdate,
3196: deprn_start_pnum, deprn_start_fy, dummy_num) then
3197: fa_srvr_msg.add_message(calling_fn => l_calling_fn);
3198: raise farboe_err;

Line 3200: if not fa_cache_pkg.fazccp(d_cal, fiscal_year_name,

3196: deprn_start_pnum, deprn_start_fy, dummy_num) then
3197: fa_srvr_msg.add_message(calling_fn => l_calling_fn);
3198: raise farboe_err;
3199: end if;
3200: if not fa_cache_pkg.fazccp(d_cal, fiscal_year_name,
3201: bk.deprn_start_jdate,
3202: deprn_start_dp_num, deprn_start_fy, dummy_num) then
3203: fa_srvr_msg.add_message(calling_fn => l_calling_fn);
3204: raise farboe_err;

Line 3885: if not fa_cache_pkg.fazcff (d_cal, book,

3881: fa_debug_pkg.add('farboe','J in reverse',3, p_log_level_rec => p_log_level_rec);
3882: fa_debug_pkg.add('farboe','d_cal',d_cal, p_log_level_rec => p_log_level_rec);
3883: end if;
3884:
3885: if not fa_cache_pkg.fazcff (d_cal, book,
3886: current_fiscal_yr, period_fracs, p_log_level_rec => p_log_level_rec) then
3887: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3888: return(FALSE);
3889: end if;

Line 4337: if not fa_cache_pkg.fazcct(p_cal, p_log_level_rec => p_log_level_rec) then

4333:
4334: temp_start_pp := 0;
4335:
4336: -- Get the number of periods per year in the rate calendar
4337: if not fa_cache_pkg.fazcct(p_cal, p_log_level_rec => p_log_level_rec) then
4338: fa_srvr_msg.add_message(calling_fn => 'fa_gainloss_ret_pkg.fagfpc', p_log_level_rec => p_log_level_rec);
4339: raise farboe_err;
4340: end if;
4341:

Line 4342: p_pers_per_yr := fa_cache_pkg.fazcct_record.number_per_fiscal_year;

4338: fa_srvr_msg.add_message(calling_fn => 'fa_gainloss_ret_pkg.fagfpc', p_log_level_rec => p_log_level_rec);
4339: raise farboe_err;
4340: end if;
4341:
4342: p_pers_per_yr := fa_cache_pkg.fazcct_record.number_per_fiscal_year;
4343:
4344: if p_log_level_rec.statement_level then
4345: fa_debug_pkg.add('farboe(1.4)','p_pers_per_yr',p_pers_per_yr);
4346: fa_debug_pkg.add('farboe(1.4)','depreciate_lastyr',depreciate_lastyr);

Line 4368: if not fa_cache_pkg.fazcbc(book, p_log_level_rec => p_log_level_rec) then

4364: (h_same_fy = 1 and (not (h_depr_first_year_ret = 1)))) then
4365: if (h_same_fy = 1) then
4366:
4367: -- Get the Fiscal Year Name from FA_BOOK_CONTROLS cache
4368: if not fa_cache_pkg.fazcbc(book, p_log_level_rec => p_log_level_rec) then
4369: raise farboe_err;
4370:
4371: end if;
4372:

Line 4373: fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;

4369: raise farboe_err;
4370:
4371: end if;
4372:
4373: fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
4374:
4375: -- Get the prorate period, and the corresponding fiscal year
4376: if not fa_cache_pkg.fazccp(p_cal, fy_name, dpr.prorate_jdate,
4377: pp_begin, y_begin, dummy_num, p_log_level_rec => p_log_level_rec) then

Line 4376: if not fa_cache_pkg.fazccp(p_cal, fy_name, dpr.prorate_jdate,

4372:
4373: fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
4374:
4375: -- Get the prorate period, and the corresponding fiscal year
4376: if not fa_cache_pkg.fazccp(p_cal, fy_name, dpr.prorate_jdate,
4377: pp_begin, y_begin, dummy_num, p_log_level_rec => p_log_level_rec) then
4378: raise farboe_err;
4379:
4380: end if;

Line 4387: if not fa_cache_pkg.fazccp(p_cal, fy_name, dpr.deprn_start_jdate,

4383: Changed dpr.prorate_jdate to dpr.deprn_start_jdate in call fazccp
4384: to make it in sinc with the pro*c code
4385: */
4386: -- Get the depreciation start prorate period
4387: if not fa_cache_pkg.fazccp(p_cal, fy_name, dpr.deprn_start_jdate,
4388: dpp_begin, dpy_begin, dummy_num, p_log_level_rec => p_log_level_rec) then
4389: raise farboe_err;
4390:
4391: end if;

Line 4532: if not fa_cache_pkg.fazccp(p_cal, fiscal_year_name,

4528: or (( h_start_pd_pc > nvl(h_asset_addition_pc,0)) and l_same_fy = 1 )
4529: OR (l_adj_overlap > 0) then
4530:
4531: -- Bug# 5018194
4532: if not fa_cache_pkg.fazccp(p_cal, fiscal_year_name,
4533: bk.deprn_start_jdate,
4534: deprn_start_pnum, deprn_start_fy, dummy_num, p_log_level_rec => p_log_level_rec) then
4535: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4536: raise farboe_err;

Line 4701: if not fa_cache_pkg.fazccp(p_cal, fiscal_year_name,

4697: end if;
4698:
4699: if h_Brow_deprn_reserve = 0 or h_daily_annual_adj_check <> 0 then
4700: -- Bug# 5018194
4701: if not fa_cache_pkg.fazccp(p_cal, fiscal_year_name,
4702: bk.deprn_start_jdate,
4703: deprn_start_pnum, deprn_start_fy, dummy_num, p_log_level_rec => p_log_level_rec) then
4704: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
4705: raise farboe_err;

Line 4720: if not fa_cache_pkg.fazccp(p_cal, fiscal_year_name, h_ret_pjdate,

4716: fa_debug_pkg.add('farboe','h_ret_pjdate',h_ret_pjdate, p_log_level_rec => p_log_level_rec);
4717: end if;
4718:
4719: -- Get the depreciation start prorate period
4720: if not fa_cache_pkg.fazccp(p_cal, fiscal_year_name, h_ret_pjdate,
4721: h_ret_pp, dummy_num2, dummy_num, p_log_level_rec => p_log_level_rec) then
4722: raise farboe_err;
4723: end if;
4724:

Line 4966: if not fa_cache_pkg.fazccp(p_cal, fiscal_year_name, h_ret_pjdate,

4962: fa_debug_pkg.add('farboe','h_ret_pjdate',h_ret_pjdate, p_log_level_rec => p_log_level_rec);
4963: end if;
4964:
4965: -- Get the depreciation start prorate period
4966: if not fa_cache_pkg.fazccp(p_cal, fiscal_year_name, h_ret_pjdate,
4967: h_ret_pp, dummy_num2, dummy_num, p_log_level_rec => p_log_level_rec) then
4968: raise farboe_err;
4969: end if;
4970:

Line 5117: if FA_CACHE_PKG.fazcbc_record.sorp_enabled_flag = 'Y'

5113:
5114: end if;
5115:
5116: /* Bug 6666666 : Neutralizing entries for SORP */
5117: if FA_CACHE_PKG.fazcbc_record.sorp_enabled_flag = 'Y'
5118: and adj_row.adjustment_type = 'EXPENSE' then
5119: if not FA_SORP_UTIL_PVT.create_sorp_neutral_acct (
5120: p_amount => adj_row.adjustment_amount,
5121: p_reversal => 'N',

Line 5295: if not fa_cache_pkg.fazcbc(ret.book, p_log_level_rec => p_log_level_rec) then

5291: h_stop_pdnum := cpdnum;
5292:
5293: /* Determine the period number to start marching forward */
5294:
5295: if not fa_cache_pkg.fazcbc(ret.book, p_log_level_rec => p_log_level_rec) then
5296: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
5297: raise fagpdp_err;
5298: end if;
5299:

Line 5300: fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;

5296: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
5297: raise fagpdp_err;
5298: end if;
5299:
5300: fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
5301:
5302: if not fa_cache_pkg.fazccp(bk.d_cal, fy_name,
5303: bk.deprn_start_jdate,
5304: deprn_start_pnum, deprn_start_fy, dummy, p_log_level_rec => p_log_level_rec) then

Line 5302: if not fa_cache_pkg.fazccp(bk.d_cal, fy_name,

5298: end if;
5299:
5300: fy_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
5301:
5302: if not fa_cache_pkg.fazccp(bk.d_cal, fy_name,
5303: bk.deprn_start_jdate,
5304: deprn_start_pnum, deprn_start_fy, dummy, p_log_level_rec => p_log_level_rec) then
5305: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
5306: raise fagpdp_err;

Line 5717: if FA_CACHE_PKG.fazcbc_record.sorp_enabled_flag = 'Y' then

5713:
5714: end if; -- end of - if not FA_INS_ADJUST_PKG.faxinaj
5715:
5716: /* Bug 6666666 : Neutralizing entries for SORP */
5717: if FA_CACHE_PKG.fazcbc_record.sorp_enabled_flag = 'Y' then
5718: if not FA_SORP_UTIL_PVT.create_sorp_neutral_acct (
5719: p_amount => deprn_amt,
5720: p_reversal => 'N',
5721: p_adj => adj_row,

Line 5867: if FA_CACHE_PKG.fazcbc_record.sorp_enabled_flag = 'Y' then

5863:
5864: end if;
5865:
5866: /* Bug 6666666 : Neutralizing entries for SORP */
5867: if FA_CACHE_PKG.fazcbc_record.sorp_enabled_flag = 'Y' then
5868: if not FA_SORP_UTIL_PVT.create_sorp_neutral_acct (
5869: p_amount => deprn_amt,
5870: p_reversal => 'N',
5871: p_adj => adj_row,

Line 7387: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

7383: CLOSE c_get_unit;
7384:
7385: l_asset_hdr_rec.asset_id := bk.group_asset_id;
7386: l_asset_hdr_rec.book_type_code := ret.book;
7387: l_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
7388:
7389: if not FA_UTIL_PVT.get_asset_cat_rec (
7390: p_asset_hdr_rec => l_asset_hdr_rec,
7391: px_asset_cat_rec => l_asset_cat_rec,

Line 7398: if not fa_cache_pkg.fazccb(

7394: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
7395: return(FALSE);
7396: end if;
7397:
7398: if not fa_cache_pkg.fazccb(
7399: X_book => ret.book,
7400: X_cat_id => l_asset_cat_rec.category_id,
7401: p_log_level_rec => p_log_level_rec) then
7402: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

Line 7435: adj_row.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;

7431: --Bug7394159: Populate fa_ret_types.ret_struct with reserve(/rsv)_retired
7432: ret.rsv_retired := adj_row.adjustment_amount;
7433: ret.reserve_retired := adj_row.adjustment_amount;
7434:
7435: adj_row.account := fa_cache_pkg.fazccb_record.deprn_reserve_acct;
7436: adj_row.account_type := 'DEPRN_RESERVE_ACCT';
7437: adj_row.adjustment_type := 'RESERVE';
7438: adj_row.selection_thid := 0;
7439: adj_row.debit_credit_flag := 'DR';

Line 7493: adj_row.account := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;

7489: --Bug11886090: include g_bonus_deprn_amt
7490: adj_row.adjustment_amount := ret.bonus_rsv_retired + nvl(g_bonus_deprn_amt, 0);
7491: end if;
7492:
7493: adj_row.account := fa_cache_pkg.fazccb_record.bonus_deprn_expense_acct;
7494: adj_row.account_type := 'BONUS_DEPRN_RESERVE_ACCT';
7495: adj_row.adjustment_type := 'BONUS RESERVE';
7496: adj_row.selection_thid := 0;
7497: adj_row.debit_credit_flag := 'DR';

Line 7568: adj_row.account := fa_cache_pkg.fazccb_record.impair_expense_acct;

7564: else
7565: adj_row.adjustment_amount := ret.impair_rsv_retired;
7566: end if;
7567:
7568: adj_row.account := fa_cache_pkg.fazccb_record.impair_expense_acct;
7569: adj_row.account_type := 'IMPAIR_RESERVE_ACCT';
7570: adj_row.adjustment_type := 'IMPAIR RESERVE';
7571: adj_row.selection_thid := 0;
7572: adj_row.debit_credit_flag := 'DR';