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 8: g_release number := fa_cache_pkg.fazarel_release;

4: G_primary_new_cost NUMBER;
5: G_primary_salvage_value NUMBER;
6: G_primary_deprn_limit_amount NUMBER;
7:
8: g_release number := fa_cache_pkg.fazarel_release;
9:
10: FUNCTION calc_fin_info
11: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
12: p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type,

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

188: nvl(px_asset_fin_rec_new.date_placed_in_service,
189: nvl(p_asset_fin_rec_adj.date_placed_in_service,
190: p_asset_fin_rec_old.date_placed_in_service)), 'J'));
191:
192: if not fa_cache_pkg.fazccbd (X_book => p_asset_hdr_rec.book_type_code,
193: X_cat_id => p_asset_cat_rec.category_id,
194: X_jdpis => l_jdpis, p_log_level_rec => p_log_level_rec) then
195: raise calc_err;
196: end if;

Line 384: fa_cache_pkg.fazccbd_record.prorate_convention_code));

380:
381: px_asset_fin_rec_new.prorate_convention_code :=
382: nvl(p_asset_fin_rec_adj.prorate_convention_code,
383: nvl(p_asset_fin_rec_old.prorate_convention_code,
384: fa_cache_pkg.fazccbd_record.prorate_convention_code));
385: px_asset_fin_rec_new.depreciate_flag :=
386: nvl(p_asset_fin_rec_adj.depreciate_flag,
387: nvl(p_asset_fin_rec_old.depreciate_flag,
388: fa_cache_pkg.fazccbd_record.depreciate_flag));

Line 388: fa_cache_pkg.fazccbd_record.depreciate_flag));

384: fa_cache_pkg.fazccbd_record.prorate_convention_code));
385: px_asset_fin_rec_new.depreciate_flag :=
386: nvl(p_asset_fin_rec_adj.depreciate_flag,
387: nvl(p_asset_fin_rec_old.depreciate_flag,
388: fa_cache_pkg.fazccbd_record.depreciate_flag));
389:
390: --HH group ed.
391: px_asset_fin_rec_new.disabled_flag := p_asset_fin_rec_adj.disabled_flag;
392: --End HH

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

472: -- do not allow amortization if not allowed at book level
473:
474: if ((px_trans_rec.transaction_subtype = 'AMORTIZED' or
475: px_trans_rec.amortization_start_date is not null) and
476: fa_cache_pkg.fazcbc_record.amortize_flag = 'NO') then
477: fa_srvr_msg.add_message(
478: calling_fn => l_calling_fn,
479: name => 'FA_BOOK_AMORTIZED_NOT_ALLOW', p_log_level_rec => p_log_level_rec);
480: raise calc_err;

Line 696: nvl(fa_cache_pkg.fazcdbr_record.rule_name,'ZZ') <> 'ENERGY PERIOD END BALANCE' ) then

692: end if;
693:
694: -- SLA: ***REVISIT***
695: if ( p_asset_hdr_rec.period_of_addition = 'Y' and
696: nvl(fa_cache_pkg.fazcdbr_record.rule_name,'ZZ') <> 'ENERGY PERIOD END BALANCE' ) then
697: l_temp_deprn_reserve := px_asset_deprn_rec_new.deprn_reserve;
698: else
699: l_temp_deprn_reserve := to_number(null);
700: end if;

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

707: p_over_depreciate_option => px_asset_fin_rec_new.over_depreciate_option,
708: p_adjusted_recoverable_cost => px_asset_fin_rec_new.adjusted_recoverable_cost,
709: p_recoverable_cost => px_asset_fin_rec_new.recoverable_cost,
710: p_deprn_reserve_new => l_temp_deprn_reserve,
711: p_rate_source_rule => fa_cache_pkg.fazccmt_record.rate_source_rule,
712: p_deprn_basis_rule => fa_cache_pkg.fazccmt_record.deprn_basis_rule,
713: p_recapture_reserve_flag => px_asset_fin_rec_new.recapture_reserve_flag,
714: p_deprn_limit_type => px_asset_fin_rec_new.deprn_limit_type
715: , p_log_level_rec => p_log_level_rec) then

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

708: p_adjusted_recoverable_cost => px_asset_fin_rec_new.adjusted_recoverable_cost,
709: p_recoverable_cost => px_asset_fin_rec_new.recoverable_cost,
710: p_deprn_reserve_new => l_temp_deprn_reserve,
711: p_rate_source_rule => fa_cache_pkg.fazccmt_record.rate_source_rule,
712: p_deprn_basis_rule => fa_cache_pkg.fazccmt_record.deprn_basis_rule,
713: p_recapture_reserve_flag => px_asset_fin_rec_new.recapture_reserve_flag,
714: p_deprn_limit_type => px_asset_fin_rec_new.deprn_limit_type
715: , p_log_level_rec => p_log_level_rec) then
716: raise calc_err;

Line 722: if fa_cache_pkg.fazccmt_record.rate_source_rule = 'PRODUCTION' then

718: end if;
719: end if; --p_asset_type_rec.asset_type
720:
721: /* bug#10094653 - validating unit_of_measure */
722: if fa_cache_pkg.fazccmt_record.rate_source_rule = 'PRODUCTION' then
723: if not fa_asset_val_pvt.validate_unit_of_measure(p_unit_of_measure => px_asset_fin_rec_new.unit_of_measure,
724: p_calling_fn => l_calling_fn,
725: p_log_level_rec => p_log_level_rec) then
726: if (p_log_level_rec.statement_level) then

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

757: p_calendar_period_start_date => p_period_rec.calendar_period_open_date,
758: p_transaction_date => nvl(px_trans_rec.amortization_start_date,
759: px_trans_rec.transaction_date_entered),
760: p_transaction_key => px_trans_rec.transaction_key,
761: p_rate_source_rule => fa_cache_pkg.fazccmt_record.rate_source_rule,
762: p_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
763: p_calling_fn => l_calling_fn,
764: p_log_level_rec => p_log_level_rec) then
765: if (p_log_level_rec.statement_level) then

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

758: p_transaction_date => nvl(px_trans_rec.amortization_start_date,
759: px_trans_rec.transaction_date_entered),
760: p_transaction_key => px_trans_rec.transaction_key,
761: p_rate_source_rule => fa_cache_pkg.fazccmt_record.rate_source_rule,
762: p_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
763: p_calling_fn => l_calling_fn,
764: p_log_level_rec => p_log_level_rec) then
765: if (p_log_level_rec.statement_level) then
766: fa_debug_pkg.add(l_calling_fn, 'Failed calling',

Line 1024: if not fa_cache_pkg.fazccmt

1020: --
1021: -- Note: we can potentially enabled this at the time of addition
1022: -- as well instead of relying on CJE when desired.
1023:
1024: if not fa_cache_pkg.fazccmt
1025: (X_method => px_asset_fin_rec_new.Deprn_Method_Code,
1026: X_life => px_asset_fin_rec_new.Life_In_Months
1027: , p_log_level_rec => p_log_level_rec) then
1028: raise calc_err;

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

1027: , p_log_level_rec => p_log_level_rec) then
1028: raise calc_err;
1029: end if;
1030:
1031: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
1032: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
1033: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1034:
1035: ----------------------------------------------

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

1028: raise calc_err;
1029: end if;
1030:
1031: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
1032: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
1033: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1034:
1035: ----------------------------------------------
1036: -- Call Depreciable Basis Rule

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

1029: end if;
1030:
1031: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
1032: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
1033: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
1034:
1035: ----------------------------------------------
1036: -- Call Depreciable Basis Rule
1037: -- Event type: Initial Addition

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

1120: p_date_placed_in_service => px_asset_fin_rec_new.date_placed_in_service,
1121: p_conversion_date => px_asset_fin_rec_new.conversion_date,
1122: p_period_rec => p_period_rec,
1123: p_amortization_start_date => l_old_amortization_start_date,
1124: p_db_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
1125: p_rate_source_rule => fa_cache_pkg.fazccmt_record.rate_source_rule,
1126: p_transaction_key => px_trans_rec.transaction_key,
1127: x_amortization_start_date => l_amortization_start_date,
1128: x_trxs_exist => l_trxs_exist,

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

1121: p_conversion_date => px_asset_fin_rec_new.conversion_date,
1122: p_period_rec => p_period_rec,
1123: p_amortization_start_date => l_old_amortization_start_date,
1124: p_db_rule_name => fa_cache_pkg.fazcdrd_record.rule_name,
1125: p_rate_source_rule => fa_cache_pkg.fazccmt_record.rate_source_rule,
1126: p_transaction_key => px_trans_rec.transaction_key,
1127: x_amortization_start_date => l_amortization_start_date,
1128: x_trxs_exist => l_trxs_exist,
1129: p_calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec) then

Line 1407: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY

1403: l_call_faxama := FALSE;
1404: l_call_bs := FALSE;
1405: elsif (px_trans_rec.transaction_key in ('MR', 'MS')) and -- ENERGY
1406: (px_asset_fin_rec_new.tracking_method = 'ALLOCATE') and -- ENERGY
1407: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY
1408: (l_recognize_gain_loss = 'NO') then -- ENERGY
1409: -- Energy implementation requires FA_RETIREMENT_PVT.Do_Allocate to -- ENERGY
1410: -- be called from Process Group Adjsutment Conc program. -- ENERGY
1411: --8244128 Added the check for recognize gain and loss

Line 1415: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY

1411: --8244128 Added the check for recognize gain and loss
1412: px_asset_fin_rec_new.adjustment_required_status := 'GADJ'; -- ENERGY
1413: elsif (px_trans_rec.transaction_key in ('MR', 'MS')) and -- ENERGY
1414: (px_asset_fin_rec_new.tracking_method = 'ALLOCATE') and -- ENERGY
1415: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') and -- ENERGY
1416: (l_recognize_gain_loss = 'YES') then -- ENERGY
1417: --8244128 Added the condition to set adjustment_required_status
1418: -- for case with recognize_gain_loss as YES
1419: px_asset_fin_rec_new.adjustment_required_status := 'NONE'; -- ENERGY

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

2537: (P_book_type_code => p_asset_hdr_rec.book_type_code,
2538: P_group_asset_id => p_asset_hdr_rec.asset_id,
2539: P_period_counter => p_period_rec.period_num,
2540: P_fiscal_year => p_period_rec.fiscal_year,
2541: P_group_deprn_basis => fa_cache_pkg.fazccmt_record.deprn_basis_rule,
2542: P_group_exclude_salvage => fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,
2543: P_group_bonus_rule => px_asset_fin_rec_new.bonus_rule,
2544: P_group_deprn_amount => l_deprn_exp,
2545: P_group_bonus_amount => l_bonus_deprn_exp,

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

2538: P_group_asset_id => p_asset_hdr_rec.asset_id,
2539: P_period_counter => p_period_rec.period_num,
2540: P_fiscal_year => p_period_rec.fiscal_year,
2541: P_group_deprn_basis => fa_cache_pkg.fazccmt_record.deprn_basis_rule,
2542: P_group_exclude_salvage => fa_cache_pkg.fazccmt_record.exclude_salvage_value_flag,
2543: P_group_bonus_rule => px_asset_fin_rec_new.bonus_rule,
2544: P_group_deprn_amount => l_deprn_exp,
2545: P_group_bonus_amount => l_bonus_deprn_exp,
2546: P_tracking_method => px_asset_fin_rec_new.tracking_method,

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

2956: -- need to call calc_itc_info before calc_rec_cost
2957: -- in order to get the itc_basis otherwise the rec_cost
2958: -- would just be set to null
2959:
2960: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX' and
2961: px_asset_fin_rec_new.itc_amount_id is not null) then
2962: if not calc_itc_info
2963: (p_asset_hdr_rec => p_asset_hdr_rec,
2964: p_asset_fin_rec_adj => p_asset_fin_rec_adj,

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

3081: calc_err EXCEPTION;
3082:
3083: BEGIN
3084:
3085: l_prorate_calendar := fa_cache_pkg.fazcbc_record.prorate_calendar;
3086: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
3087:
3088: if (p_asset_type_rec.asset_type = 'GROUP') then
3089: px_asset_fin_rec_new.prorate_date := px_asset_fin_rec_new.date_placed_in_service;

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

3082:
3083: BEGIN
3084:
3085: l_prorate_calendar := fa_cache_pkg.fazcbc_record.prorate_calendar;
3086: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
3087:
3088: if (p_asset_type_rec.asset_type = 'GROUP') then
3089: px_asset_fin_rec_new.prorate_date := px_asset_fin_rec_new.date_placed_in_service;
3090: else

Line 3099: if not fa_cache_pkg.fazccvt

3095: name => 'FA_EXP_GET_PRORATE_INFO', p_log_level_rec => p_log_level_rec);
3096: raise calc_err;
3097: end if;
3098:
3099: if not fa_cache_pkg.fazccvt
3100: (x_prorate_convention_code => px_asset_fin_rec_new.prorate_convention_code,
3101: x_fiscal_year_name => l_fiscal_year_name, p_log_level_rec => p_log_level_rec) then
3102: raise calc_err;
3103: end if;

Line 3135: (fa_cache_pkg.fazccmt (

3131: -- For Polish, we need additional changes here.
3132: -- First find out if we have a polish mechanism here
3133: if (nvl(px_asset_fin_rec_new.deprn_method_code,
3134: p_asset_fin_rec_adj.deprn_method_code) is not null) and
3135: (fa_cache_pkg.fazccmt (
3136: X_method => nvl(px_asset_fin_rec_new.deprn_method_code,
3137: p_asset_fin_rec_adj.deprn_method_code),
3138: X_life => nvl(px_asset_fin_rec_new.life_in_months,
3139: p_asset_fin_rec_adj.life_in_months),

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

3138: X_life => nvl(px_asset_fin_rec_new.life_in_months,
3139: p_asset_fin_rec_adj.life_in_months),
3140: p_log_level_rec => p_log_level_rec
3141: )) then
3142: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then
3143: if (fa_cache_pkg.fazcdbr_record.polish_rule in (
3144: FA_STD_TYPES.FAD_DBR_POLISH_1,
3145: FA_STD_TYPES.FAD_DBR_POLISH_2)) then
3146: -- For Polish rules 1 and 2, set prorate_date based on dpis

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

3139: p_asset_fin_rec_adj.life_in_months),
3140: p_log_level_rec => p_log_level_rec
3141: )) then
3142: if (fa_cache_pkg.fazccmt_record.deprn_basis_rule_id is not null) then
3143: if (fa_cache_pkg.fazcdbr_record.polish_rule in (
3144: FA_STD_TYPES.FAD_DBR_POLISH_1,
3145: FA_STD_TYPES.FAD_DBR_POLISH_2)) then
3146: -- For Polish rules 1 and 2, set prorate_date based on dpis
3147: -- regardless of prorate convention.

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

3183: calc_err EXCEPTION;
3184:
3185: BEGIN
3186:
3187: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
3188:
3189: if not fa_cache_pkg.fazccvt
3190: (x_prorate_convention_code => px_asset_fin_rec_new.prorate_convention_code,
3191: x_fiscal_year_name => l_fiscal_year_name, p_log_level_rec => p_log_level_rec) then

Line 3189: if not fa_cache_pkg.fazccvt

3185: BEGIN
3186:
3187: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
3188:
3189: if not fa_cache_pkg.fazccvt
3190: (x_prorate_convention_code => px_asset_fin_rec_new.prorate_convention_code,
3191: x_fiscal_year_name => l_fiscal_year_name, p_log_level_rec => p_log_level_rec) then
3192: raise calc_err;
3193: end if;

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

3191: x_fiscal_year_name => l_fiscal_year_name, p_log_level_rec => p_log_level_rec) then
3192: raise calc_err;
3193: end if;
3194:
3195: l_dwaf := fa_cache_pkg.fazccvt_record.depr_when_acquired_flag;
3196:
3197: if (l_dwaf = 'YES') then
3198: px_asset_fin_rec_new.deprn_start_date := px_asset_fin_rec_new.date_placed_in_service;
3199: else

Line 4014: if not fa_cache_pkg.fazccbd

4010: NAME => 'FA_MTH_LFR_INCOMPAT', p_log_level_rec => p_log_level_rec);
4011: raise calc_err;
4012: end if;
4013:
4014: if not fa_cache_pkg.fazccbd
4015: (X_book => p_asset_hdr_rec.book_type_code,
4016: X_cat_id => p_asset_cat_rec.category_id,
4017: X_jdpis => to_number(to_char(px_asset_fin_rec.date_placed_in_service, 'J')),
4018: p_log_level_rec => p_log_level_rec

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

4018: p_log_level_rec => p_log_level_rec
4019: ) then
4020: raise calc_err;
4021: else
4022: l_cat_bk_lim := nvl(fa_cache_pkg.fazccbd_record.life_in_months, 0);
4023: l_min_life_in_months := nvl(fa_cache_pkg.fazccbd_record.minimum_life_in_months, 0);
4024: l_sub_life_rule := fa_cache_pkg.fazccbd_record.subcomponent_life_rule;
4025: end if;
4026:

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

4019: ) then
4020: raise calc_err;
4021: else
4022: l_cat_bk_lim := nvl(fa_cache_pkg.fazccbd_record.life_in_months, 0);
4023: l_min_life_in_months := nvl(fa_cache_pkg.fazccbd_record.minimum_life_in_months, 0);
4024: l_sub_life_rule := fa_cache_pkg.fazccbd_record.subcomponent_life_rule;
4025: end if;
4026:
4027: -- get the parents info

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

4020: raise calc_err;
4021: else
4022: l_cat_bk_lim := nvl(fa_cache_pkg.fazccbd_record.life_in_months, 0);
4023: l_min_life_in_months := nvl(fa_cache_pkg.fazccbd_record.minimum_life_in_months, 0);
4024: l_sub_life_rule := fa_cache_pkg.fazccbd_record.subcomponent_life_rule;
4025: end if;
4026:
4027: -- get the parents info
4028: OPEN LIFE1_DEF;

Line 4078: fa_cache_pkg.fazccbd_record.prorate_convention_code;

4074: -- return 0
4075:
4076: if (px_asset_fin_rec.prorate_convention_code is null) then
4077: px_asset_fin_rec.prorate_convention_code :=
4078: fa_cache_pkg.fazccbd_record.prorate_convention_code;
4079: end if;
4080:
4081: -- just needs to be <> GROUP
4082: l_asset_type_rec.asset_type := 'CAPITALIZED';

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

4229: BEGIN
4230:
4231: -- this logic needs verification - ref faxfa2b.pls
4232:
4233: l_current_fiscal_year := fa_cache_pkg.fazcbc_record.current_fiscal_year;
4234: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
4235:
4236: if not fa_cache_pkg.fazccmt
4237: ( X_method => px_asset_fin_rec_new.Deprn_Method_Code

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

4230:
4231: -- this logic needs verification - ref faxfa2b.pls
4232:
4233: l_current_fiscal_year := fa_cache_pkg.fazcbc_record.current_fiscal_year;
4234: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
4235:
4236: if not fa_cache_pkg.fazccmt
4237: ( X_method => px_asset_fin_rec_new.Deprn_Method_Code
4238: ,X_life => px_asset_fin_rec_new.Life_In_Months, p_log_level_rec => p_log_level_rec) then

Line 4236: if not fa_cache_pkg.fazccmt

4232:
4233: l_current_fiscal_year := fa_cache_pkg.fazcbc_record.current_fiscal_year;
4234: l_fiscal_year_name := fa_cache_pkg.fazcbc_record.fiscal_year_name;
4235:
4236: if not fa_cache_pkg.fazccmt
4237: ( X_method => px_asset_fin_rec_new.Deprn_Method_Code
4238: ,X_life => px_asset_fin_rec_new.Life_In_Months, p_log_level_rec => p_log_level_rec) then
4239: raise calc_err;
4240: end if;

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

4238: ,X_life => px_asset_fin_rec_new.Life_In_Months, p_log_level_rec => p_log_level_rec) then
4239: raise calc_err;
4240: end if;
4241:
4242: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
4243: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
4244:
4245:
4246: px_asset_fin_rec_new.cost_change_flag := 'NO';

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

4239: raise calc_err;
4240: end if;
4241:
4242: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
4243: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
4244:
4245:
4246: px_asset_fin_rec_new.cost_change_flag := 'NO';
4247: px_asset_fin_rec_new.retirement_pending_flag := 'NO';

Line 4526: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book

4522: CURSOR unit_of_measure IS
4523: select unit_of_measure
4524: from fa_books
4525: where asset_id = p_asset_hdr_rec.asset_id
4526: and book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
4527: and transaction_header_id_out is NULL;
4528:
4529: l_calling_fn VARCHAR2(40) := 'fa_asset_calc_pvt.calc_deprn_info';
4530: calc_err EXCEPTION;

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

4530: calc_err EXCEPTION;
4531:
4532: BEGIN
4533:
4534: l_last_period_counter := fa_cache_pkg.fazcbc_record.last_period_counter;
4535:
4536: -- NOTE: moved additions defaulting to the private additions apit's init procedure
4537: -- as part of group project...
4538:

Line 4595: if not FA_CACHE_PKG.fazccmt(

4591: -- cache function - modified from STYR to handle all types.
4592: -- FYI: we MUST call the cache even when there is no method change
4593: -- because of potential impact of the flags on the depreciable
4594: -- basis, deprn_start_date and on adjusted_cost for nbv methods
4595: if not FA_CACHE_PKG.fazccmt(
4596: X_method => px_asset_fin_rec_new.deprn_method_code,
4597: X_life => px_asset_fin_rec_new.life_in_months
4598: , p_log_level_rec => p_log_level_rec) then
4599: raise calc_err;

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

4599: raise calc_err;
4600: end if;
4601:
4602:
4603: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
4604: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
4605: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
4606:
4607: -- verify that basic rate and adj_rate are valid for flat

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

4600: end if;
4601:
4602:
4603: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
4604: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
4605: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
4606:
4607: -- verify that basic rate and adj_rate are valid for flat
4608: -- rate methods and that production info is correct

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

4601:
4602:
4603: l_method_id := fa_cache_pkg.fazccmt_record.method_id;
4604: l_rate_source_rule := fa_cache_pkg.fazccmt_record.rate_source_rule;
4605: l_deprn_basis_rule := fa_cache_pkg.fazccmt_record.deprn_basis_rule;
4606:
4607: -- verify that basic rate and adj_rate are valid for flat
4608: -- rate methods and that production info is correct
4609:

Line 4646: if ( /* (nvl(fa_cache_pkg.fazcdbr_record.rule_name,'ZZ') <> 'ENERGY PERIOD END BALANCE'

4642: end if;
4643:
4644: -- verify corp asset is UOP and get unit of measure
4645: -- Depreciate flag may not be 'NO'
4646: if ( /* (nvl(fa_cache_pkg.fazcdbr_record.rule_name,'ZZ') <> 'ENERGY PERIOD END BALANCE'
4647: OR p_asset_type_rec.asset_type = 'GROUP') and Commented for ENH 12600386 */
4648: px_asset_fin_rec_new.depreciate_flag <> 'YES') then -- Added for bug8584206
4649: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
4650: name => 'FA_BOOK_INVALID_DEPRN_FLAG',

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

4651: p_log_level_rec => p_log_level_rec);
4652: raise calc_err;
4653: end if;
4654:
4655: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX') then
4656:
4657: select count(1)
4658: into l_count
4659: from fa_books bk,

Line 4661: where bk.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book

4657: select count(1)
4658: into l_count
4659: from fa_books bk,
4660: fa_methods me
4661: where bk.book_type_code = fa_cache_pkg.fazcbc_record.distribution_source_book
4662: and bk.asset_id = p_asset_hdr_rec.asset_id
4663: and bk.transaction_header_id_out is null
4664: and me.method_code = bk.deprn_method_code
4665: and me.rate_source_rule = 'PRODUCTION';

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

4686: px_asset_fin_rec_new.adjusted_rate := NULL;
4687: px_asset_fin_rec_new.basic_rate := NULL;
4688:
4689: -- added this for bug 3245984
4690: h_prod_method := instr (fa_cache_pkg.fazcfor_record.formula_actual,'CAPACITY');
4691: -- if the formula has 'CAPACITY' in it, then it is a Production method
4692: -- otherwise, it is a Life method.
4693: if (h_prod_method = 0) then
4694: px_asset_fin_rec_new.production_capacity := NULL;

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

4706:
4707:
4708: -- BUG# 4676908
4709: -- make sure the proate period match the method
4710: if (fa_cache_pkg.fazccmt_record.prorate_periods_per_year is not null) then
4711: if not fa_cache_pkg.fazcct
4712: (X_calendar => fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec) then
4713: raise calc_err;
4714: end if;

Line 4711: if not fa_cache_pkg.fazcct

4707:
4708: -- BUG# 4676908
4709: -- make sure the proate period match the method
4710: if (fa_cache_pkg.fazccmt_record.prorate_periods_per_year is not null) then
4711: if not fa_cache_pkg.fazcct
4712: (X_calendar => fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec) then
4713: raise calc_err;
4714: end if;
4715:

Line 4712: (X_calendar => fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec) then

4708: -- BUG# 4676908
4709: -- make sure the proate period match the method
4710: if (fa_cache_pkg.fazccmt_record.prorate_periods_per_year is not null) then
4711: if not fa_cache_pkg.fazcct
4712: (X_calendar => fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec) then
4713: raise calc_err;
4714: end if;
4715:
4716: if (fa_cache_pkg.fazccmt_record.prorate_periods_per_year <>

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

4712: (X_calendar => fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec) then
4713: raise calc_err;
4714: end if;
4715:
4716: if (fa_cache_pkg.fazccmt_record.prorate_periods_per_year <>
4717: fa_cache_pkg.fazcct_record.number_per_fiscal_year) then
4718: fa_srvr_msg.add_message(
4719: calling_fn => l_calling_fn,
4720: name => 'FA_INVALID_DEPRN_METHOD', p_log_level_rec => p_log_level_rec);

Line 4717: fa_cache_pkg.fazcct_record.number_per_fiscal_year) then

4713: raise calc_err;
4714: end if;
4715:
4716: if (fa_cache_pkg.fazccmt_record.prorate_periods_per_year <>
4717: fa_cache_pkg.fazcct_record.number_per_fiscal_year) then
4718: fa_srvr_msg.add_message(
4719: calling_fn => l_calling_fn,
4720: name => 'FA_INVALID_DEPRN_METHOD', p_log_level_rec => p_log_level_rec);
4721: raise calc_err;

Line 4745: ((px_asset_fin_rec_new.depreciate_flag = 'YES' AND Nvl(fa_cache_pkg.fazcdbr_record.rule_name, 'ZZ') <> 'ENERGY PERIOD END BALANCE' ) OR

4741: if (l_rate_source_rule = 'PRODUCTION') and
4742: ( ((nvl(p_trans_rec.transaction_key, 'XX') not in ('MR', 'MS','GC')) and p_asset_type_rec.asset_type = 'GROUP')
4743: OR
4744: (p_asset_type_rec.asset_type = 'CAPITALIZED' and
4745: ((px_asset_fin_rec_new.depreciate_flag = 'YES' AND Nvl(fa_cache_pkg.fazcdbr_record.rule_name, 'ZZ') <> 'ENERGY PERIOD END BALANCE' ) OR
4746: nvl(px_asset_fin_rec_new.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM /* OR Commented and added above for ENH 12600386
4747: fa_cache_pkg.fazcdbr_record.rule_name <> 'ENERGY PERIOD END BALANCE' */ )) ) then
4748:
4749: if (nvl(p_asset_deprn_rec_adj.deprn_reserve,0) <> 0 OR

Line 4747: fa_cache_pkg.fazcdbr_record.rule_name <> 'ENERGY PERIOD END BALANCE' */ )) ) then

4743: OR
4744: (p_asset_type_rec.asset_type = 'CAPITALIZED' and
4745: ((px_asset_fin_rec_new.depreciate_flag = 'YES' AND Nvl(fa_cache_pkg.fazcdbr_record.rule_name, 'ZZ') <> 'ENERGY PERIOD END BALANCE' ) OR
4746: nvl(px_asset_fin_rec_new.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM /* OR Commented and added above for ENH 12600386
4747: fa_cache_pkg.fazcdbr_record.rule_name <> 'ENERGY PERIOD END BALANCE' */ )) ) then
4748:
4749: if (nvl(p_asset_deprn_rec_adj.deprn_reserve,0) <> 0 OR
4750: nvl(p_asset_deprn_rec_adj.ytd_deprn,0) <> 0) then
4751: fa_srvr_msg.add_message(

Line 4858: if not fa_cache_pkg.fazccmt

4854: -- is called from calc_derived_amounts.
4855: -- If calc_deprn_info is called before this function, then I can simply use
4856: -- new so don't need this much of the code.
4857: if (p_asset_fin_rec_adj.deprn_method_code is not null) then
4858: if not fa_cache_pkg.fazccmt
4859: (X_method => p_asset_fin_rec_adj.Deprn_Method_Code,
4860: X_life => p_asset_fin_rec_adj.Life_In_Months
4861: , p_log_level_rec => p_log_level_rec) then
4862: raise calc_err;

Line 4865: if not fa_cache_pkg.fazccmt

4861: , p_log_level_rec => p_log_level_rec) then
4862: raise calc_err;
4863: end if;
4864: else
4865: if not fa_cache_pkg.fazccmt
4866: (X_method => p_asset_fin_rec_old.Deprn_Method_Code,
4867: X_life => p_asset_fin_rec_old.Life_In_Months
4868: , p_log_level_rec => p_log_level_rec) then
4869: raise calc_err;

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

4869: raise calc_err;
4870: end if;
4871: end if;
4872:
4873: if (nvl(fa_cache_pkg.fazcdrd_record.allow_reduction_rate_flag, 'N') = 'N') then
4874: px_asset_fin_rec_new.reduction_rate := to_number(null);
4875: end if;
4876:
4877:

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

4885: -- Set Over Depreciate to 'NO'
4886: -- 1. If it is set to DEPRN and FLAT-NBV method
4887: -- 2. If it is not NO and there is some deprn limit
4888: --
4889: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX') then
4890:
4891: if (px_asset_fin_rec_new.over_depreciate_option =
4892: fa_std_types.FA_OVER_DEPR_DEPRN) and
4893: (fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' and

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

4889: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX') then
4890:
4891: if (px_asset_fin_rec_new.over_depreciate_option =
4892: fa_std_types.FA_OVER_DEPR_DEPRN) and
4893: (fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' and
4894: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV') then
4895: px_asset_fin_rec_new.over_depreciate_option :=
4896: fa_std_types.FA_OVER_DEPR_NO;
4897: end if;

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

4890:
4891: if (px_asset_fin_rec_new.over_depreciate_option =
4892: fa_std_types.FA_OVER_DEPR_DEPRN) and
4893: (fa_cache_pkg.fazccmt_record.rate_source_rule = 'FLAT' and
4894: fa_cache_pkg.fazccmt_record.deprn_basis_rule = 'NBV') then
4895: px_asset_fin_rec_new.over_depreciate_option :=
4896: fa_std_types.FA_OVER_DEPR_NO;
4897: end if;
4898:

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

5086: -- Tracking Option Validations
5087: --HH check allow_member_tracking_flag too.
5088: --
5089: if (px_asset_fin_rec_new.tracking_method is null) OR
5090: (nvl(fa_cache_pkg.fazcbc_record.allow_member_tracking_flag,'N') <> 'Y')then
5091:
5092: px_asset_fin_rec_new.allocate_to_fully_rsv_flag := null;
5093: px_asset_fin_rec_new.allocate_to_fully_ret_flag := null;
5094: px_asset_fin_rec_new.excess_allocation_option := null;

Line 5134: nvl(fa_cache_pkg.fazcdbr_record.rule_name,'ZZ') <> 'YEAR END BALANCE WITH POSITIVE REDUCTION AMOUNT')

5130: /*bug#15897249 modified the condition*/
5131: if ((px_asset_fin_rec_new.recognize_gain_loss = 'NO') or
5132: (px_asset_fin_rec_new.terminal_gain_loss <> 'YES')) and
5133: ((px_asset_fin_rec_new.member_rollup_flag = 'Y' and
5134: nvl(fa_cache_pkg.fazcdbr_record.rule_name,'ZZ') <> 'YEAR END BALANCE WITH POSITIVE REDUCTION AMOUNT')
5135: ) then
5136: fa_srvr_msg.add_message(
5137: calling_fn => 'fa_asset_calc_pvt.calc_group_info',
5138: name => 'FA_INVALID_PARAMETER',