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

Line 143: if not fa_cache_pkg.fazccbd (X_book => p_asset_hdr_rec.book_type_code,

139: nvl(px_asset_fin_rec_new.date_placed_in_service,
140: nvl(p_asset_fin_rec_adj.date_placed_in_service,
141: p_asset_fin_rec_old.date_placed_in_service)), 'J'));
142:
143: if not fa_cache_pkg.fazccbd (X_book => p_asset_hdr_rec.book_type_code,
144: X_cat_id => p_asset_cat_rec.category_id,
145: X_jdpis => l_jdpis,
146: p_log_level_rec => p_log_level_rec) then
147: raise calc_err;

Line 274: fa_cache_pkg.fazccbd_record.prorate_convention_code));

270:
271: px_asset_fin_rec_new.prorate_convention_code :=
272: nvl(p_asset_fin_rec_adj.prorate_convention_code,
273: nvl(p_asset_fin_rec_old.prorate_convention_code,
274: fa_cache_pkg.fazccbd_record.prorate_convention_code));
275: px_asset_fin_rec_new.depreciate_flag :=
276: nvl(p_asset_fin_rec_adj.depreciate_flag,
277: nvl(p_asset_fin_rec_old.depreciate_flag,
278: fa_cache_pkg.fazccbd_record.depreciate_flag));

Line 278: fa_cache_pkg.fazccbd_record.depreciate_flag));

274: fa_cache_pkg.fazccbd_record.prorate_convention_code));
275: px_asset_fin_rec_new.depreciate_flag :=
276: nvl(p_asset_fin_rec_adj.depreciate_flag,
277: nvl(p_asset_fin_rec_old.depreciate_flag,
278: fa_cache_pkg.fazccbd_record.depreciate_flag));
279:
280: --HH group ed.
281: px_asset_fin_rec_new.disabled_flag := p_asset_fin_rec_adj.disabled_flag;
282: --End HH

Line 366: fa_cache_pkg.fazcbc_record.amortize_flag = 'NO') then

362: -- do not allow amortization if not allowed at book level
363:
364: if ((px_trans_rec.transaction_subtype = 'AMORTIZED' or
365: px_trans_rec.amortization_start_date is not null) and
366: fa_cache_pkg.fazcbc_record.amortize_flag = 'NO') then
367: fa_srvr_msg.add_message(
368: calling_fn => l_calling_fn,
369: name => 'FA_BOOK_AMORTIZED_NOT_ALLOW');
370: raise calc_err;

Line 583: p_rate_source_rule => fa_cache_pkg.fazccmt_record.rate_source_rule,

579: p_over_depreciate_option => px_asset_fin_rec_new.over_depreciate_option,
580: p_adjusted_recoverable_cost => px_asset_fin_rec_new.adjusted_recoverable_cost,
581: p_recoverable_cost => px_asset_fin_rec_new.recoverable_cost,
582: p_deprn_reserve_new => l_temp_deprn_reserve,
583: p_rate_source_rule => fa_cache_pkg.fazccmt_record.rate_source_rule,
584: p_deprn_basis_rule => fa_cache_pkg.fazccmt_record.deprn_basis_rule,
585: p_recapture_reserve_flag => px_asset_fin_rec_new.recapture_reserve_flag,
586: p_deprn_limit_type => px_asset_fin_rec_new.deprn_limit_type,
587: p_log_level_rec => p_log_level_rec

Line 584: p_deprn_basis_rule => fa_cache_pkg.fazccmt_record.deprn_basis_rule,

580: p_adjusted_recoverable_cost => px_asset_fin_rec_new.adjusted_recoverable_cost,
581: p_recoverable_cost => px_asset_fin_rec_new.recoverable_cost,
582: p_deprn_reserve_new => l_temp_deprn_reserve,
583: p_rate_source_rule => fa_cache_pkg.fazccmt_record.rate_source_rule,
584: p_deprn_basis_rule => fa_cache_pkg.fazccmt_record.deprn_basis_rule,
585: p_recapture_reserve_flag => px_asset_fin_rec_new.recapture_reserve_flag,
586: p_deprn_limit_type => px_asset_fin_rec_new.deprn_limit_type,
587: p_log_level_rec => p_log_level_rec
588: ) then

Line 600: p_rate_source_rule => fa_cache_pkg.fazccmt_record.rate_source_rule,

596: p_calendar_period_start_date => p_period_rec.calendar_period_open_date,
597: p_transaction_date => nvl(px_trans_rec.amortization_start_date,
598: px_trans_rec.transaction_date_entered),
599: p_transaction_key => px_trans_rec.transaction_key,
600: p_rate_source_rule => fa_cache_pkg.fazccmt_record.rate_source_rule,
601: p_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
602: p_calling_fn => l_calling_fn,
603: p_log_level_rec => p_log_level_rec) then
604: if (p_log_level_rec.statement_level) then

Line 601: p_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,

597: p_transaction_date => nvl(px_trans_rec.amortization_start_date,
598: px_trans_rec.transaction_date_entered),
599: p_transaction_key => px_trans_rec.transaction_key,
600: p_rate_source_rule => fa_cache_pkg.fazccmt_record.rate_source_rule,
601: p_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
602: p_calling_fn => l_calling_fn,
603: p_log_level_rec => p_log_level_rec) then
604: if (p_log_level_rec.statement_level) then
605: fa_debug_pkg.add(l_calling_fn, 'Failed calling',

Line 766: if not fa_cache_pkg.fazccmt

762: --
763: -- Note: we can potentially enabled this at the time of addition
764: -- as well instead of relying on CJE when desired.
765:
766: if not fa_cache_pkg.fazccmt
767: (X_method => px_asset_fin_rec_new.Deprn_Method_Code,
768: X_life => px_asset_fin_rec_new.Life_In_Months,
769: p_log_level_rec => p_log_level_rec
770: ) then

Line 774: l_method_id := fa_cache_pkg.fazccmt_record.method_id;

770: ) then
771: raise calc_err;
772: end if;
773:
774: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
775: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
776: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
777:
778: ----------------------------------------------

Line 775: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;

771: raise calc_err;
772: end if;
773:
774: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
775: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
776: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
777:
778: ----------------------------------------------
779: -- Call Depreciable Basis Rule

Line 776: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;

772: end if;
773:
774: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
775: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
776: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
777:
778: ----------------------------------------------
779: -- Call Depreciable Basis Rule
780: -- Event type: Initial Addition

Line 849: p_db_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,

845: p_date_placed_in_service => px_asset_fin_rec_new.date_placed_in_service,
846: p_conversion_date => px_asset_fin_rec_new.conversion_date,
847: p_period_rec => p_period_rec,
848: p_amortization_start_date => l_old_amortization_start_date,
849: p_db_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
850: p_rate_source_rule => fa_cache_pkg.fazccmt_record.rate_source_rule,
851: p_transaction_key => px_trans_rec.transaction_key,
852: x_amortization_start_date => l_amortization_start_date,
853: x_trxs_exist => l_trxs_exist,

Line 850: p_rate_source_rule => fa_cache_pkg.fazccmt_record.rate_source_rule,

846: p_conversion_date => px_asset_fin_rec_new.conversion_date,
847: p_period_rec => p_period_rec,
848: p_amortization_start_date => l_old_amortization_start_date,
849: p_db_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
850: p_rate_source_rule => fa_cache_pkg.fazccmt_record.rate_source_rule,
851: p_transaction_key => px_trans_rec.transaction_key,
852: x_amortization_start_date => l_amortization_start_date,
853: x_trxs_exist => l_trxs_exist,
854: p_calling_fn => l_calling_fn,

Line 1084: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') then -- ENERGY

1080: l_call_faxama := FALSE;
1081: l_call_bs := FALSE;
1082: elsif (px_trans_rec.transaction_key in ('MR', 'MS')) and -- ENERGY
1083: (px_asset_fin_rec_new.tracking_method = 'ALLOCATE') and -- ENERGY
1084: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') then -- ENERGY
1085: -- Energy implementation requires FA_RETIREMENT_PVT.Do_Allocate to -- ENERGY
1086: -- be called from Process Group Adjsutment Conc program. -- ENERGY
1087: px_asset_fin_rec_new.adjustment_required_status := 'GADJ'; -- ENERGY
1088: end if;

Line 1877: P_group_deprn_basis => fa_cache_pkg.fazccmt_record.deprn_basis_rule,

1873: (P_book_type_code => p_asset_hdr_rec.book_type_code,
1874: P_group_asset_id => p_asset_hdr_rec.asset_id,
1875: P_period_counter => p_period_rec.period_num,
1876: P_fiscal_year => p_period_rec.fiscal_year,
1877: P_group_deprn_basis => fa_cache_pkg.fazccmt_record.deprn_basis_rule,
1878: P_group_exclude_salvage => fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,
1879: P_group_bonus_rule => px_asset_fin_rec_new.bonus_rule,
1880: P_group_deprn_amount => l_deprn_exp,
1881: P_group_bonus_amount => l_bonus_deprn_exp,

Line 1878: P_group_exclude_salvage => fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,

1874: P_group_asset_id => p_asset_hdr_rec.asset_id,
1875: P_period_counter => p_period_rec.period_num,
1876: P_fiscal_year => p_period_rec.fiscal_year,
1877: P_group_deprn_basis => fa_cache_pkg.fazccmt_record.deprn_basis_rule,
1878: P_group_exclude_salvage => fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,
1879: P_group_bonus_rule => px_asset_fin_rec_new.bonus_rule,
1880: P_group_deprn_amount => l_deprn_exp,
1881: P_group_bonus_amount => l_bonus_deprn_exp,
1882: P_tracking_method => px_asset_fin_rec_new.tracking_method,

Line 2272: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX' and

2268: -- need to call calc_itc_info before calc_rec_cost
2269: -- in order to get the itc_basis otherwise the rec_cost
2270: -- would just be set to null
2271:
2272: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX' and
2273: px_asset_fin_rec_new.itc_amount_id is not null) then
2274: if not calc_itc_info
2275: (p_asset_hdr_rec => p_asset_hdr_rec,
2276: p_asset_fin_rec_adj => p_asset_fin_rec_adj,

Line 2392: l_prorate_calendar := fa_cache_pkg.fazcbc_record.prorate_calendar;

2388: calc_err EXCEPTION;
2389:
2390: BEGIN
2391:
2392: l_prorate_calendar := fa_cache_pkg.fazcbc_record.prorate_calendar;
2393: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
2394:
2395: if (p_asset_type_rec.asset_type = 'GROUP') then
2396: px_asset_fin_rec_new.prorate_date := px_asset_fin_rec_new.date_placed_in_service;

Line 2393: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;

2389:
2390: BEGIN
2391:
2392: l_prorate_calendar := fa_cache_pkg.fazcbc_record.prorate_calendar;
2393: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
2394:
2395: if (p_asset_type_rec.asset_type = 'GROUP') then
2396: px_asset_fin_rec_new.prorate_date := px_asset_fin_rec_new.date_placed_in_service;
2397: else

Line 2406: if not fa_cache_pkg.fazccvt

2402: name => 'FA_EXP_GET_PRORATE_INFO');
2403: raise calc_err;
2404: end if;
2405:
2406: if not fa_cache_pkg.fazccvt
2407: (x_prorate_convention_code => px_asset_fin_rec_new.prorate_convention_code,
2408: x_fiscal_year_name => l_fiscal_year_name,
2409: p_log_level_rec => p_log_level_rec) then
2410: raise calc_err;

Line 2443: (fa_cache_pkg.fazccmt (

2439: -- For Polish, we need additional changes here.
2440: -- First find out if we have a polish mechanism here
2441: if (nvl(px_asset_fin_rec_new.deprn_method_code,
2442: p_asset_fin_rec_adj.deprn_method_code) is not null) and
2443: (fa_cache_pkg.fazccmt (
2444: X_method => nvl(px_asset_fin_rec_new.deprn_method_code,
2445: p_asset_fin_rec_adj.deprn_method_code),
2446: X_life => nvl(px_asset_fin_rec_new.life_in_months,
2447: p_asset_fin_rec_adj.life_in_months),

Line 2450: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then

2446: X_life => nvl(px_asset_fin_rec_new.life_in_months,
2447: p_asset_fin_rec_adj.life_in_months),
2448: p_log_level_rec => p_log_level_rec
2449: )) then
2450: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then
2451: if (fa_cache_pkg.fazcdbr_record.polish_rule in (
2452: FA_STD_TYPES.FAD_DBR_POLISH_1,
2453: FA_STD_TYPES.FAD_DBR_POLISH_2)) then
2454: -- For Polish rules 1 and 2, set prorate_date based on dpis

Line 2451: if (fa_cache_pkg.fazcdbr_record.polish_rule in (

2447: p_asset_fin_rec_adj.life_in_months),
2448: p_log_level_rec => p_log_level_rec
2449: )) then
2450: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then
2451: if (fa_cache_pkg.fazcdbr_record.polish_rule in (
2452: FA_STD_TYPES.FAD_DBR_POLISH_1,
2453: FA_STD_TYPES.FAD_DBR_POLISH_2)) then
2454: -- For Polish rules 1 and 2, set prorate_date based on dpis
2455: -- regardless of prorate convention.

Line 2496: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;

2492: calc_err EXCEPTION;
2493:
2494: BEGIN
2495:
2496: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
2497:
2498: if not fa_cache_pkg.fazccvt
2499: (x_prorate_convention_code => px_asset_fin_rec_new.prorate_convention_code,
2500: x_fiscal_year_name => l_fiscal_year_name,

Line 2498: if not fa_cache_pkg.fazccvt

2494: BEGIN
2495:
2496: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
2497:
2498: if not fa_cache_pkg.fazccvt
2499: (x_prorate_convention_code => px_asset_fin_rec_new.prorate_convention_code,
2500: x_fiscal_year_name => l_fiscal_year_name,
2501: p_log_level_rec => p_log_level_rec) then
2502: raise calc_err;

Line 2505: l_dwaf := fa_cache_pkg.fazccvt_record.depr_when_acquired_flag;

2501: p_log_level_rec => p_log_level_rec) then
2502: raise calc_err;
2503: end if;
2504:
2505: l_dwaf := fa_cache_pkg.fazccvt_record.depr_when_acquired_flag;
2506:
2507: if (l_dwaf = 'YES') then
2508: px_asset_fin_rec_new.deprn_start_date := px_asset_fin_rec_new.date_placed_in_service;
2509: else

Line 3254: if not fa_cache_pkg.fazccbd

3250: NAME => 'FA_MTH_LFR_INCOMPAT');
3251: raise calc_err;
3252: end if;
3253:
3254: if not fa_cache_pkg.fazccbd
3255: (X_book => p_asset_hdr_rec.book_type_code,
3256: X_cat_id => p_asset_cat_rec.category_id,
3257: X_jdpis => to_number(to_char(px_asset_fin_rec.date_placed_in_service, 'J')),
3258: p_log_level_rec => p_log_level_rec

Line 3262: l_cat_bk_lim := nvl(fa_cache_pkg.fazccbd_record.life_in_months, 0);

3258: p_log_level_rec => p_log_level_rec
3259: ) then
3260: raise calc_err;
3261: else
3262: l_cat_bk_lim := nvl(fa_cache_pkg.fazccbd_record.life_in_months, 0);
3263: l_min_life_in_months := nvl(fa_cache_pkg.fazccbd_record.minimum_life_in_months, 0);
3264: l_sub_life_rule := fa_cache_pkg.fazccbd_record.subcomponent_life_rule;
3265: end if;
3266:

Line 3263: l_min_life_in_months := nvl(fa_cache_pkg.fazccbd_record.minimum_life_in_months, 0);

3259: ) then
3260: raise calc_err;
3261: else
3262: l_cat_bk_lim := nvl(fa_cache_pkg.fazccbd_record.life_in_months, 0);
3263: l_min_life_in_months := nvl(fa_cache_pkg.fazccbd_record.minimum_life_in_months, 0);
3264: l_sub_life_rule := fa_cache_pkg.fazccbd_record.subcomponent_life_rule;
3265: end if;
3266:
3267: -- get the parents info

Line 3264: l_sub_life_rule := fa_cache_pkg.fazccbd_record.subcomponent_life_rule;

3260: raise calc_err;
3261: else
3262: l_cat_bk_lim := nvl(fa_cache_pkg.fazccbd_record.life_in_months, 0);
3263: l_min_life_in_months := nvl(fa_cache_pkg.fazccbd_record.minimum_life_in_months, 0);
3264: l_sub_life_rule := fa_cache_pkg.fazccbd_record.subcomponent_life_rule;
3265: end if;
3266:
3267: -- get the parents info
3268: OPEN LIFE1_DEF;

Line 3318: fa_cache_pkg.fazccbd_record.prorate_convention_code;

3314: -- return 0
3315:
3316: if (px_asset_fin_rec.prorate_convention_code is null) then
3317: px_asset_fin_rec.prorate_convention_code :=
3318: fa_cache_pkg.fazccbd_record.prorate_convention_code;
3319: end if;
3320:
3321: -- just needs to be <> GROUP
3322: l_asset_type_rec.asset_type := 'CAPITALIZED';

Line 3475: l_current_fiscal_year := fa_cache_pkg.fazcbc_record.current_fiscal_year;

3471: BEGIN
3472:
3473: -- this logic needs verification - ref faxfa2b.pls
3474:
3475: l_current_fiscal_year := fa_cache_pkg.fazcbc_record.current_fiscal_year;
3476: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
3477:
3478: if not fa_cache_pkg.fazccmt
3479: ( X_method => px_asset_fin_rec_new.Deprn_Method_Code

Line 3476: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;

3472:
3473: -- this logic needs verification - ref faxfa2b.pls
3474:
3475: l_current_fiscal_year := fa_cache_pkg.fazcbc_record.current_fiscal_year;
3476: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
3477:
3478: if not fa_cache_pkg.fazccmt
3479: ( X_method => px_asset_fin_rec_new.Deprn_Method_Code
3480: ,X_life => px_asset_fin_rec_new.Life_In_Months,

Line 3478: if not fa_cache_pkg.fazccmt

3474:
3475: l_current_fiscal_year := fa_cache_pkg.fazcbc_record.current_fiscal_year;
3476: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
3477:
3478: if not fa_cache_pkg.fazccmt
3479: ( X_method => px_asset_fin_rec_new.Deprn_Method_Code
3480: ,X_life => px_asset_fin_rec_new.Life_In_Months,
3481: p_log_level_rec => p_log_level_rec) then
3482: raise calc_err;

Line 3485: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;

3481: p_log_level_rec => p_log_level_rec) then
3482: raise calc_err;
3483: end if;
3484:
3485: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
3486: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
3487:
3488:
3489: px_asset_fin_rec_new.cost_change_flag := 'NO';

Line 3486: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;

3482: raise calc_err;
3483: end if;
3484:
3485: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
3486: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
3487:
3488:
3489: px_asset_fin_rec_new.cost_change_flag := 'NO';
3490: px_asset_fin_rec_new.retirement_pending_flag := 'NO';

Line 3764: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book

3760: CURSOR unit_of_measure IS
3761: select unit_of_measure
3762: from fa_books
3763: where asset_id = p_asset_hdr_rec.asset_id
3764: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
3765: and transaction_header_id_out is NULL
3766: and deprn_method_code = px_asset_fin_rec_new.deprn_method_code;
3767:
3768: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_deprn_info';

Line 3773: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;

3769: calc_err EXCEPTION;
3770:
3771: BEGIN
3772:
3773: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
3774:
3775: -- NOTE: moved additions defaulting to the private additions apit's init procedure
3776: -- as part of group project...
3777:

Line 3836: if not FA_CACHE_PKG.fazccmt(

3832: -- cache function - modified from STYR to handle all types.
3833: -- FYI: we MUST call the cache even when there is no method change
3834: -- because of potential impact of the flags on the depreciable
3835: -- basis, deprn_start_date and on adjusted_cost for nbv methods
3836: if not FA_CACHE_PKG.fazccmt(
3837: X_method => px_asset_fin_rec_new.deprn_method_code,
3838: X_life => px_asset_fin_rec_new.life_in_months,
3839: p_log_level_rec => p_log_level_rec
3840: ) then

Line 3845: l_method_id := fa_cache_pkg.fazccmt_record.method_id;

3841: raise calc_err;
3842: end if;
3843:
3844:
3845: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
3846: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
3847: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
3848:
3849: -- verify that basic rate and adj_rate are valid for flat

Line 3846: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;

3842: end if;
3843:
3844:
3845: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
3846: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
3847: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
3848:
3849: -- verify that basic rate and adj_rate are valid for flat
3850: -- rate methods and that production info is correct

Line 3847: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;

3843:
3844:
3845: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
3846: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
3847: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
3848:
3849: -- verify that basic rate and adj_rate are valid for flat
3850: -- rate methods and that production info is correct
3851:

Line 3896: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX') then

3892: name => 'FA_BOOK_INVALID_DEPRN_FLAG');
3893: raise calc_err;
3894: end if;
3895:
3896: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX') then
3897: OPEN unit_of_measure;
3898: FETCH unit_of_measure INTO px_asset_fin_rec_new.unit_of_measure;
3899:
3900: if (unit_of_measure%NOTFOUND) then

Line 3921: h_prod_method := instr (fa_cache_pkg.fazcfor_record.formula_actual,'CAPACITY');

3917: px_asset_fin_rec_new.adjusted_rate := NULL;
3918: px_asset_fin_rec_new.basic_rate := NULL;
3919:
3920: -- added this for bug 3245984
3921: h_prod_method := instr (fa_cache_pkg.fazcfor_record.formula_actual,'CAPACITY');
3922: -- if the formula has 'CAPACITY' in it, then it is a Production method
3923: -- otherwise, it is a Life method.
3924: if (h_prod_method = 0) then
3925: px_asset_fin_rec_new.production_capacity := NULL;

Line 3941: if (fa_cache_pkg.fazccmt_record.prorate_periods_per_year is not null) then

3937:
3938:
3939: -- BUG# 4676908
3940: -- make sure the proate period match the method
3941: if (fa_cache_pkg.fazccmt_record.prorate_periods_per_year is not null) then
3942: if not fa_cache_pkg.fazcct
3943: (X_calendar => fa_cache_pkg.fazcbc_record.prorate_calendar,
3944: p_log_level_rec => p_log_level_rec) then
3945: raise calc_err;

Line 3942: if not fa_cache_pkg.fazcct

3938:
3939: -- BUG# 4676908
3940: -- make sure the proate period match the method
3941: if (fa_cache_pkg.fazccmt_record.prorate_periods_per_year is not null) then
3942: if not fa_cache_pkg.fazcct
3943: (X_calendar => fa_cache_pkg.fazcbc_record.prorate_calendar,
3944: p_log_level_rec => p_log_level_rec) then
3945: raise calc_err;
3946: end if;

Line 3943: (X_calendar => fa_cache_pkg.fazcbc_record.prorate_calendar,

3939: -- BUG# 4676908
3940: -- make sure the proate period match the method
3941: if (fa_cache_pkg.fazccmt_record.prorate_periods_per_year is not null) then
3942: if not fa_cache_pkg.fazcct
3943: (X_calendar => fa_cache_pkg.fazcbc_record.prorate_calendar,
3944: p_log_level_rec => p_log_level_rec) then
3945: raise calc_err;
3946: end if;
3947:

Line 3948: if (fa_cache_pkg.fazccmt_record.prorate_periods_per_year <>

3944: p_log_level_rec => p_log_level_rec) then
3945: raise calc_err;
3946: end if;
3947:
3948: if (fa_cache_pkg.fazccmt_record.prorate_periods_per_year <>
3949: fa_cache_pkg.fazcct_record.number_per_fiscal_year) then
3950: fa_srvr_msg.add_message(
3951: calling_fn => l_calling_fn,
3952: name => 'FA_INVALID_DEPRN_METHOD');

Line 3949: fa_cache_pkg.fazcct_record.number_per_fiscal_year) then

3945: raise calc_err;
3946: end if;
3947:
3948: if (fa_cache_pkg.fazccmt_record.prorate_periods_per_year <>
3949: fa_cache_pkg.fazcct_record.number_per_fiscal_year) then
3950: fa_srvr_msg.add_message(
3951: calling_fn => l_calling_fn,
3952: name => 'FA_INVALID_DEPRN_METHOD');
3953: raise calc_err;

Line 4090: if not fa_cache_pkg.fazccmt

4086: -- is called from calc_derived_amounts.
4087: -- If calc_deprn_info is called before this function, then I can simply use
4088: -- new so don't need this much of the code.
4089: if (p_asset_fin_rec_adj.deprn_method_code is not null) then
4090: if not fa_cache_pkg.fazccmt
4091: (X_method => p_asset_fin_rec_adj.Deprn_Method_Code,
4092: X_life => p_asset_fin_rec_adj.Life_In_Months,
4093: p_log_level_rec => p_log_level_rec
4094: ) then

Line 4098: if not fa_cache_pkg.fazccmt

4094: ) then
4095: raise calc_err;
4096: end if;
4097: else
4098: if not fa_cache_pkg.fazccmt
4099: (X_method => p_asset_fin_rec_old.Deprn_Method_Code,
4100: X_life => p_asset_fin_rec_old.Life_In_Months,
4101: p_log_level_rec => p_log_level_rec
4102: ) then

Line 4107: if (nvl(fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, 'N') = 'N') then

4103: raise calc_err;
4104: end if;
4105: end if;
4106:
4107: if (nvl(fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, 'N') = 'N') then
4108: px_asset_fin_rec_new.reduction_rate := to_number(null);
4109: end if;
4110:
4111:

Line 4123: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX') then

4119: -- Set Over Depreciate to 'NO'
4120: -- 1. If it is set to DEPRN and FLAT-NBV method
4121: -- 2. If it is not NO and there is some deprn limit
4122: --
4123: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX') then
4124:
4125: if (px_asset_fin_rec_new.over_depreciate_option =
4126: fa_std_types.FA_OVER_DEPR_DEPRN) and
4127: (fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' and

Line 4127: (fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' and

4123: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX') then
4124:
4125: if (px_asset_fin_rec_new.over_depreciate_option =
4126: fa_std_types.FA_OVER_DEPR_DEPRN) and
4127: (fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' and
4128: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV') then
4129: px_asset_fin_rec_new.over_depreciate_option :=
4130: fa_std_types.FA_OVER_DEPR_NO;
4131: end if;

Line 4128: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV') then

4124:
4125: if (px_asset_fin_rec_new.over_depreciate_option =
4126: fa_std_types.FA_OVER_DEPR_DEPRN) and
4127: (fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' and
4128: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV') then
4129: px_asset_fin_rec_new.over_depreciate_option :=
4130: fa_std_types.FA_OVER_DEPR_NO;
4131: end if;
4132:

Line 4324: (nvl(fa_cache_pkg.fazcbc_record.allow_member_tracking_flag,'N') <> 'Y')then

4320: -- Tracking Option Validations
4321: --HH check allow_member_tracking_flag too.
4322: --
4323: if (px_asset_fin_rec_new.tracking_method is null) OR
4324: (nvl(fa_cache_pkg.fazcbc_record.allow_member_tracking_flag,'N') <> 'Y')then
4325:
4326: px_asset_fin_rec_new.allocate_to_fully_rsv_flag := null;
4327: px_asset_fin_rec_new.allocate_to_fully_ret_flag := null;
4328: px_asset_fin_rec_new.excess_allocation_option := null;