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.

[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_DEBUG_PKG

Line 1257: fa_debug_pkg.add('fa_asset_val_pvt.validate_dpis', 'Error', p_date_placed_in_service, p_log_level_rec => p_log_level_rec);

1253: if (p_date_placed_in_service <> nvl(p_old_date_placed_in_service, p_date_placed_in_service) ) and
1254: (p_date_placed_in_service < l_period_rec.calendar_period_open_date) then
1255:
1256: if (p_log_level_rec.statement_level) then
1257: fa_debug_pkg.add('fa_asset_val_pvt.validate_dpis', 'Error', p_date_placed_in_service, p_log_level_rec => p_log_level_rec);
1258: end if;
1259:
1260: fa_srvr_msg.add_message(
1261: calling_fn => 'fa_asset_val_pvt.validate_dpis',

Line 1814: fa_debug_pkg.add(l_calling_fn, 'Error', p_date_placed_in_service, p_log_level_rec => p_log_level_rec);

1810: p_transaction_key <> 'MS') then
1811:
1812: if (p_amortization_start_date < p_period_rec.calendar_period_open_date) then
1813: if (p_log_level_rec.statement_level) then
1814: fa_debug_pkg.add(l_calling_fn, 'Error', p_date_placed_in_service, p_log_level_rec => p_log_level_rec);
1815: end if;
1816: fa_srvr_msg.add_message(
1817: calling_fn => 'fa_asset_val_pvt.validate_dpis',
1818: name => 'FA_CURRENT_DATE_ONLY', p_log_level_rec => p_log_level_rec);

Line 1964: fa_debug_pkg.add(l_calling_fn, 'calling', 'fazccmt', p_log_level_rec => p_log_level_rec);

1960:
1961: BEGIN
1962:
1963: if (p_log_level_rec.statement_level) then
1964: fa_debug_pkg.add(l_calling_fn, 'calling', 'fazccmt', p_log_level_rec => p_log_level_rec);
1965: end if;
1966:
1967: if not fa_cache_pkg.fazccmt
1968: (X_method => p_deprn_method,

Line 1972: fa_debug_pkg.add(l_calling_fn, 'after fazccmt', 'method not found', p_log_level_rec => p_log_level_rec);

1968: (X_method => p_deprn_method,
1969: X_life => p_lim, p_log_level_rec => p_log_level_rec) then -- method not found
1970:
1971: if (p_log_level_rec.statement_level) then
1972: fa_debug_pkg.add(l_calling_fn, 'after fazccmt', 'method not found', p_log_level_rec => p_log_level_rec);
1973: end if;
1974:
1975: if (p_rate_source_rule = 'TABLE') then
1976:

Line 2024: fa_debug_pkg.add(l_calling_fn, 'inserting', 'new method', p_log_level_rec => p_log_level_rec);

2020: CLOSE METHOD_DEF;
2021: end if;
2022:
2023: if (p_log_level_rec.statement_level) then
2024: fa_debug_pkg.add(l_calling_fn, 'inserting', 'new method', p_log_level_rec => p_log_level_rec);
2025: end if;
2026:
2027: FA_METHODS_PKG.Insert_Row(
2028: X_Rowid => l_rowid,

Line 2112: fa_debug_pkg.add(l_calling_fn, 'after fazccmt', 'method found', p_log_level_rec => p_log_level_rec);

2108: end if;
2109:
2110: else
2111: if (p_log_level_rec.statement_level) then
2112: fa_debug_pkg.add(l_calling_fn, 'after fazccmt', 'method found', p_log_level_rec => p_log_level_rec);
2113: end if;
2114: end if;
2115:
2116: return true;

Line 3171: fa_debug_pkg.add('val api', 'group', p_group_asset_id, p_log_level_rec => p_log_level_rec);

3167:
3168: BEGIN
3169:
3170: if (p_log_level_rec.statement_level) then
3171: fa_debug_pkg.add('val api', 'group', p_group_asset_id, p_log_level_rec => p_log_level_rec);
3172: fa_debug_pkg.add('val api', 'book', p_book_type_code, p_log_level_rec => p_log_level_rec);
3173: end if;
3174:
3175: --

Line 3172: fa_debug_pkg.add('val api', 'book', p_book_type_code, p_log_level_rec => p_log_level_rec);

3168: BEGIN
3169:
3170: if (p_log_level_rec.statement_level) then
3171: fa_debug_pkg.add('val api', 'group', p_group_asset_id, p_log_level_rec => p_log_level_rec);
3172: fa_debug_pkg.add('val api', 'book', p_book_type_code, p_log_level_rec => p_log_level_rec);
3173: end if;
3174:
3175: --
3176: -- Following sql is too expensive

Line 3623: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.rate_source_rule',

3619: --called from calc now. Should this change, we may need to consider
3620: --changing the params passed in to this proc.
3621:
3622: if (p_log_level_rec.statement_level) then
3623: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.rate_source_rule',
3624: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);
3625: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',
3626: fa_cache_pkg.fazcdrd_record.rule_name, p_log_level_rec => p_log_level_rec);
3627: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG',

Line 3625: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',

3621:
3622: if (p_log_level_rec.statement_level) then
3623: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.rate_source_rule',
3624: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);
3625: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',
3626: fa_cache_pkg.fazcdrd_record.rule_name, p_log_level_rec => p_log_level_rec);
3627: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG',
3628: fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG, p_log_level_rec => p_log_level_rec);
3629: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.deprn_basis_rule',

Line 3627: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG',

3623: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.rate_source_rule',
3624: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec => p_log_level_rec);
3625: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',
3626: fa_cache_pkg.fazcdrd_record.rule_name, p_log_level_rec => p_log_level_rec);
3627: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG',
3628: fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG, p_log_level_rec => p_log_level_rec);
3629: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.deprn_basis_rule',
3630: fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
3631: fa_debug_pkg.add(l_calling_fn, 'p_cost_adj',

Line 3629: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.deprn_basis_rule',

3625: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',
3626: fa_cache_pkg.fazcdrd_record.rule_name, p_log_level_rec => p_log_level_rec);
3627: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG',
3628: fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG, p_log_level_rec => p_log_level_rec);
3629: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.deprn_basis_rule',
3630: fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
3631: fa_debug_pkg.add(l_calling_fn, 'p_cost_adj',
3632: p_cost_adj, p_log_level_rec => p_log_level_rec);
3633: fa_debug_pkg.add(l_calling_fn, 'p_cost',

Line 3631: fa_debug_pkg.add(l_calling_fn, 'p_cost_adj',

3627: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG',
3628: fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG, p_log_level_rec => p_log_level_rec);
3629: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.deprn_basis_rule',
3630: fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
3631: fa_debug_pkg.add(l_calling_fn, 'p_cost_adj',
3632: p_cost_adj, p_log_level_rec => p_log_level_rec);
3633: fa_debug_pkg.add(l_calling_fn, 'p_cost',
3634: p_cost, p_log_level_rec => p_log_level_rec);
3635: end if;

Line 3633: fa_debug_pkg.add(l_calling_fn, 'p_cost',

3629: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.deprn_basis_rule',
3630: fa_cache_pkg.fazccmt_record.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
3631: fa_debug_pkg.add(l_calling_fn, 'p_cost_adj',
3632: p_cost_adj, p_log_level_rec => p_log_level_rec);
3633: fa_debug_pkg.add(l_calling_fn, 'p_cost',
3634: p_cost, p_log_level_rec => p_log_level_rec);
3635: end if;
3636:
3637: if (fa_cache_pkg.fazccmt_record.rate_source_rule NOT IN ('CALCULATED','FLAT','TABLE')

Line 3652: fa_debug_pkg.add(l_calling_fn, 'Member cost sign','can be changed', p_log_level_rec => p_log_level_rec);

3648: (nvl(p_over_depreciate_option, fa_std_types.FA_OVER_DEPR_NO) =
3649: fa_std_types.FA_OVER_DEPR_DEPRN) and
3650: (NVL(fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,'N') = 'Y')) then
3651: if (p_log_level_rec.statement_level) then
3652: fa_debug_pkg.add(l_calling_fn, 'Member cost sign','can be changed', p_log_level_rec => p_log_level_rec);
3653: fa_debug_pkg.add(l_calling_fn, 'over depreciate option',p_over_depreciate_option, p_log_level_rec => p_log_level_rec);
3654: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id, p_log_level_rec => p_log_level_rec);
3655: end if;
3656: else

Line 3653: fa_debug_pkg.add(l_calling_fn, 'over depreciate option',p_over_depreciate_option, p_log_level_rec => p_log_level_rec);

3649: fa_std_types.FA_OVER_DEPR_DEPRN) and
3650: (NVL(fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,'N') = 'Y')) then
3651: if (p_log_level_rec.statement_level) then
3652: fa_debug_pkg.add(l_calling_fn, 'Member cost sign','can be changed', p_log_level_rec => p_log_level_rec);
3653: fa_debug_pkg.add(l_calling_fn, 'over depreciate option',p_over_depreciate_option, p_log_level_rec => p_log_level_rec);
3654: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id, p_log_level_rec => p_log_level_rec);
3655: end if;
3656: else
3657: if (p_log_level_rec.statement_level) then

Line 3654: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id, p_log_level_rec => p_log_level_rec);

3650: (NVL(fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,'N') = 'Y')) then
3651: if (p_log_level_rec.statement_level) then
3652: fa_debug_pkg.add(l_calling_fn, 'Member cost sign','can be changed', p_log_level_rec => p_log_level_rec);
3653: fa_debug_pkg.add(l_calling_fn, 'over depreciate option',p_over_depreciate_option, p_log_level_rec => p_log_level_rec);
3654: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id, p_log_level_rec => p_log_level_rec);
3655: end if;
3656: else
3657: if (p_log_level_rec.statement_level) then
3658: fa_debug_pkg.add(l_calling_fn, 'validating cost and salvage','', p_log_level_rec => p_log_level_rec);

Line 3658: fa_debug_pkg.add(l_calling_fn, 'validating cost and salvage','', p_log_level_rec => p_log_level_rec);

3654: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id, p_log_level_rec => p_log_level_rec);
3655: end if;
3656: else
3657: if (p_log_level_rec.statement_level) then
3658: fa_debug_pkg.add(l_calling_fn, 'validating cost and salvage','', p_log_level_rec => p_log_level_rec);
3659: fa_debug_pkg.add(l_calling_fn, 'sign change flag',
3660: fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG, p_log_level_rec => p_log_level_rec);
3661: fa_debug_pkg.add(l_calling_fn, 'over depr option',p_over_depreciate_option, p_log_level_rec => p_log_level_rec);
3662: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id, p_log_level_rec => p_log_level_rec);

Line 3659: fa_debug_pkg.add(l_calling_fn, 'sign change flag',

3655: end if;
3656: else
3657: if (p_log_level_rec.statement_level) then
3658: fa_debug_pkg.add(l_calling_fn, 'validating cost and salvage','', p_log_level_rec => p_log_level_rec);
3659: fa_debug_pkg.add(l_calling_fn, 'sign change flag',
3660: fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG, p_log_level_rec => p_log_level_rec);
3661: fa_debug_pkg.add(l_calling_fn, 'over depr option',p_over_depreciate_option, p_log_level_rec => p_log_level_rec);
3662: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id, p_log_level_rec => p_log_level_rec);
3663: end if;

Line 3661: fa_debug_pkg.add(l_calling_fn, 'over depr option',p_over_depreciate_option, p_log_level_rec => p_log_level_rec);

3657: if (p_log_level_rec.statement_level) then
3658: fa_debug_pkg.add(l_calling_fn, 'validating cost and salvage','', p_log_level_rec => p_log_level_rec);
3659: fa_debug_pkg.add(l_calling_fn, 'sign change flag',
3660: fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG, p_log_level_rec => p_log_level_rec);
3661: fa_debug_pkg.add(l_calling_fn, 'over depr option',p_over_depreciate_option, p_log_level_rec => p_log_level_rec);
3662: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id, p_log_level_rec => p_log_level_rec);
3663: end if;
3664:
3665: -- Added following if condition for bugfix# 5131759

Line 3662: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id, p_log_level_rec => p_log_level_rec);

3658: fa_debug_pkg.add(l_calling_fn, 'validating cost and salvage','', p_log_level_rec => p_log_level_rec);
3659: fa_debug_pkg.add(l_calling_fn, 'sign change flag',
3660: fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG, p_log_level_rec => p_log_level_rec);
3661: fa_debug_pkg.add(l_calling_fn, 'over depr option',p_over_depreciate_option, p_log_level_rec => p_log_level_rec);
3662: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id, p_log_level_rec => p_log_level_rec);
3663: end if;
3664:
3665: -- Added following if condition for bugfix# 5131759
3666: if (p_mrc_sob_type_code = 'R') then

Line 3680: fa_debug_pkg.add(l_calling_fn, 'Delta Cost', 'Invalid', p_log_level_rec => p_log_level_rec);

3676: if (p_cost_adj <> 0) and
3677: (sign(nvl(l_cost, 0) + p_cost_adj) <> 0) and
3678: (sign(nvl(l_cost, 0) + p_cost_adj) <> sign(p_cost)) then
3679: if (p_log_level_rec.statement_level) then
3680: fa_debug_pkg.add(l_calling_fn, 'Delta Cost', 'Invalid', p_log_level_rec => p_log_level_rec);
3681: end if;
3682: raise val_err;
3683: end if;
3684:

Line 3691: fa_debug_pkg.add(l_calling_fn, 'Delta Salvage Value', 'Invalid', p_log_level_rec => p_log_level_rec);

3687: (sign(nvl(l_salvage_value, 0) + p_salvage_value_adj) <>
3688: sign(p_salvage_value)) and
3689: (p_salvage_value <> 0) then -- Bug#6618908
3690: if (p_log_level_rec.statement_level) then
3691: fa_debug_pkg.add(l_calling_fn, 'Delta Salvage Value', 'Invalid', p_log_level_rec => p_log_level_rec);
3692: end if;
3693: raise val_err;
3694: end if;
3695: end if; --group_asset_id not null...

Line 3718: fa_debug_pkg.add(l_calling_fn, 'Delta Deprn Limit Amount', 'Invalid', p_log_level_rec => p_log_level_rec);

3714: IF (sign(nvl(l_deprn_limit_amount, 0) + p_deprn_limit_amount_adj) <> 0) and
3715: (sign(nvl(l_deprn_limit_amount, 0) + p_deprn_limit_amount_adj) <>
3716: sign(p_deprn_limit_amount)) then
3717: if (p_log_level_rec.statement_level) then
3718: fa_debug_pkg.add(l_calling_fn, 'Delta Deprn Limit Amount', 'Invalid', p_log_level_rec => p_log_level_rec);
3719: end if;
3720: raise val_err;
3721: end if;
3722: end if;

Line 4098: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);

4094:
4095: CLOSE c_check_used;
4096:
4097: if (p_log_level_rec.statement_level) then
4098: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);
4099: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id, p_log_level_rec => p_log_level_rec);
4100: fa_debug_pkg.add(l_calling_fn, 'This Super group is used', 'TRUE', p_log_level_rec => p_log_level_rec);
4101: end if;
4102:

Line 4099: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id, p_log_level_rec => p_log_level_rec);

4095: CLOSE c_check_used;
4096:
4097: if (p_log_level_rec.statement_level) then
4098: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);
4099: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id, p_log_level_rec => p_log_level_rec);
4100: fa_debug_pkg.add(l_calling_fn, 'This Super group is used', 'TRUE', p_log_level_rec => p_log_level_rec);
4101: end if;
4102:
4103: fa_srvr_msg.add_message(calling_fn => l_calling_fn,

Line 4100: fa_debug_pkg.add(l_calling_fn, 'This Super group is used', 'TRUE', p_log_level_rec => p_log_level_rec);

4096:
4097: if (p_log_level_rec.statement_level) then
4098: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);
4099: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id, p_log_level_rec => p_log_level_rec);
4100: fa_debug_pkg.add(l_calling_fn, 'This Super group is used', 'TRUE', p_log_level_rec => p_log_level_rec);
4101: end if;
4102:
4103: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
4104: name => 'FA_SUPER_GROUP_USED', p_log_level_rec => p_log_level_rec);

Line 4120: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);

4116:
4117: EXCEPTION
4118: WHEN OTHERS THEN
4119: if (p_log_level_rec.statement_level) then
4120: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);
4121: fa_debug_pkg.add(l_calling_fn, 'p_old_super_group_id', p_old_super_group_id, p_log_level_rec => p_log_level_rec);
4122: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id, p_log_level_rec => p_log_level_rec);
4123: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
4124: end if;

Line 4121: fa_debug_pkg.add(l_calling_fn, 'p_old_super_group_id', p_old_super_group_id, p_log_level_rec => p_log_level_rec);

4117: EXCEPTION
4118: WHEN OTHERS THEN
4119: if (p_log_level_rec.statement_level) then
4120: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);
4121: fa_debug_pkg.add(l_calling_fn, 'p_old_super_group_id', p_old_super_group_id, p_log_level_rec => p_log_level_rec);
4122: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id, p_log_level_rec => p_log_level_rec);
4123: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
4124: end if;
4125:

Line 4122: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id, p_log_level_rec => p_log_level_rec);

4118: WHEN OTHERS THEN
4119: if (p_log_level_rec.statement_level) then
4120: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);
4121: fa_debug_pkg.add(l_calling_fn, 'p_old_super_group_id', p_old_super_group_id, p_log_level_rec => p_log_level_rec);
4122: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id, p_log_level_rec => p_log_level_rec);
4123: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
4124: end if;
4125:
4126: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn , p_log_level_rec => p_log_level_rec);

Line 4123: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);

4119: if (p_log_level_rec.statement_level) then
4120: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);
4121: fa_debug_pkg.add(l_calling_fn, 'p_old_super_group_id', p_old_super_group_id, p_log_level_rec => p_log_level_rec);
4122: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id, p_log_level_rec => p_log_level_rec);
4123: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
4124: end if;
4125:
4126: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn , p_log_level_rec => p_log_level_rec);
4127:

Line 4187: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', 'p_transaction_date', p_log_level_rec => p_log_level_rec);

4183:
4184: BEGIN
4185:
4186: if (p_log_level_rec.statement_level) then
4187: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', 'p_transaction_date', p_log_level_rec => p_log_level_rec);
4188: end if;
4189:
4190: if (p_calendar_period_start_date > p_transaction_date) and
4191: (p_rate_source_rule = 'PRODUCTION') and

Line 4202: fa_debug_pkg.add(l_calling_fn, 'End', ' ', p_log_level_rec => p_log_level_rec);

4198: return FALSE;
4199: end if;
4200:
4201: if (p_log_level_rec.statement_level) then
4202: fa_debug_pkg.add(l_calling_fn, 'End', ' ', p_log_level_rec => p_log_level_rec);
4203: end if;
4204:
4205: return true;
4206:

Line 4210: fa_debug_pkg.add(l_calling_fn, 'p_calendar_period_start_date', p_calendar_period_start_date, p_log_level_rec => p_log_level_rec);

4206:
4207: EXCEPTION
4208: WHEN OTHERS THEN
4209: if (p_log_level_rec.statement_level) then
4210: fa_debug_pkg.add(l_calling_fn, 'p_calendar_period_start_date', p_calendar_period_start_date, p_log_level_rec => p_log_level_rec);
4211: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', p_transaction_date, p_log_level_rec => p_log_level_rec);
4212: fa_debug_pkg.add(l_calling_fn, 'p_rate_source_rule', p_rate_source_rule, p_log_level_rec => p_log_level_rec);
4213: fa_debug_pkg.add(l_calling_fn, 'p_rule_name', p_rule_name, p_log_level_rec => p_log_level_rec);
4214: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);

Line 4211: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', p_transaction_date, p_log_level_rec => p_log_level_rec);

4207: EXCEPTION
4208: WHEN OTHERS THEN
4209: if (p_log_level_rec.statement_level) then
4210: fa_debug_pkg.add(l_calling_fn, 'p_calendar_period_start_date', p_calendar_period_start_date, p_log_level_rec => p_log_level_rec);
4211: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', p_transaction_date, p_log_level_rec => p_log_level_rec);
4212: fa_debug_pkg.add(l_calling_fn, 'p_rate_source_rule', p_rate_source_rule, p_log_level_rec => p_log_level_rec);
4213: fa_debug_pkg.add(l_calling_fn, 'p_rule_name', p_rule_name, p_log_level_rec => p_log_level_rec);
4214: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
4215: end if;

Line 4212: fa_debug_pkg.add(l_calling_fn, 'p_rate_source_rule', p_rate_source_rule, p_log_level_rec => p_log_level_rec);

4208: WHEN OTHERS THEN
4209: if (p_log_level_rec.statement_level) then
4210: fa_debug_pkg.add(l_calling_fn, 'p_calendar_period_start_date', p_calendar_period_start_date, p_log_level_rec => p_log_level_rec);
4211: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', p_transaction_date, p_log_level_rec => p_log_level_rec);
4212: fa_debug_pkg.add(l_calling_fn, 'p_rate_source_rule', p_rate_source_rule, p_log_level_rec => p_log_level_rec);
4213: fa_debug_pkg.add(l_calling_fn, 'p_rule_name', p_rule_name, p_log_level_rec => p_log_level_rec);
4214: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
4215: end if;
4216:

Line 4213: fa_debug_pkg.add(l_calling_fn, 'p_rule_name', p_rule_name, p_log_level_rec => p_log_level_rec);

4209: if (p_log_level_rec.statement_level) then
4210: fa_debug_pkg.add(l_calling_fn, 'p_calendar_period_start_date', p_calendar_period_start_date, p_log_level_rec => p_log_level_rec);
4211: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', p_transaction_date, p_log_level_rec => p_log_level_rec);
4212: fa_debug_pkg.add(l_calling_fn, 'p_rate_source_rule', p_rate_source_rule, p_log_level_rec => p_log_level_rec);
4213: fa_debug_pkg.add(l_calling_fn, 'p_rule_name', p_rule_name, p_log_level_rec => p_log_level_rec);
4214: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
4215: end if;
4216:
4217: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn , p_log_level_rec => p_log_level_rec);

Line 4214: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);

4210: fa_debug_pkg.add(l_calling_fn, 'p_calendar_period_start_date', p_calendar_period_start_date, p_log_level_rec => p_log_level_rec);
4211: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', p_transaction_date, p_log_level_rec => p_log_level_rec);
4212: fa_debug_pkg.add(l_calling_fn, 'p_rate_source_rule', p_rate_source_rule, p_log_level_rec => p_log_level_rec);
4213: fa_debug_pkg.add(l_calling_fn, 'p_rule_name', p_rule_name, p_log_level_rec => p_log_level_rec);
4214: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
4215: end if;
4216:
4217: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn , p_log_level_rec => p_log_level_rec);
4218:

Line 4257: fa_debug_pkg.add(l_calling_fn, 'p_asset_id', p_asset_id);

4253:
4254: EXCEPTION
4255: WHEN OTHERS THEN
4256: if (p_log_level_rec.statement_level) then
4257: fa_debug_pkg.add(l_calling_fn, 'p_asset_id', p_asset_id);
4258: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code);
4259: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
4260: end if;
4261:

Line 4258: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code);

4254: EXCEPTION
4255: WHEN OTHERS THEN
4256: if (p_log_level_rec.statement_level) then
4257: fa_debug_pkg.add(l_calling_fn, 'p_asset_id', p_asset_id);
4258: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code);
4259: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
4260: end if;
4261:
4262: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn);

Line 4259: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);

4255: WHEN OTHERS THEN
4256: if (p_log_level_rec.statement_level) then
4257: fa_debug_pkg.add(l_calling_fn, 'p_asset_id', p_asset_id);
4258: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code);
4259: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
4260: end if;
4261:
4262: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn);
4263:

Line 4282: fa_debug_pkg.add(l_calling_fn, 'Enter ', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);

4278:
4279: BEGIN
4280:
4281: if (p_log_level_rec.statement_level) then
4282: fa_debug_pkg.add(l_calling_fn, 'Enter ', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
4283: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost, p_log_level_rec => p_log_level_rec);
4284: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.life_in_months', p_asset_fin_rec_adj.life_in_months, p_log_level_rec => p_log_level_rec);
4285: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
4286: p_asset_fin_rec_adj.deprn_method_code, p_log_level_rec => p_log_level_rec);

Line 4283: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost, p_log_level_rec => p_log_level_rec);

4279: BEGIN
4280:
4281: if (p_log_level_rec.statement_level) then
4282: fa_debug_pkg.add(l_calling_fn, 'Enter ', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
4283: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost, p_log_level_rec => p_log_level_rec);
4284: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.life_in_months', p_asset_fin_rec_adj.life_in_months, p_log_level_rec => p_log_level_rec);
4285: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
4286: p_asset_fin_rec_adj.deprn_method_code, p_log_level_rec => p_log_level_rec);
4287: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.date_placed_in_service',

Line 4284: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.life_in_months', p_asset_fin_rec_adj.life_in_months, p_log_level_rec => p_log_level_rec);

4280:
4281: if (p_log_level_rec.statement_level) then
4282: fa_debug_pkg.add(l_calling_fn, 'Enter ', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
4283: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost, p_log_level_rec => p_log_level_rec);
4284: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.life_in_months', p_asset_fin_rec_adj.life_in_months, p_log_level_rec => p_log_level_rec);
4285: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
4286: p_asset_fin_rec_adj.deprn_method_code, p_log_level_rec => p_log_level_rec);
4287: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.date_placed_in_service',
4288: p_asset_fin_rec_adj.date_placed_in_service, p_log_level_rec => p_log_level_rec);

Line 4285: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',

4281: if (p_log_level_rec.statement_level) then
4282: fa_debug_pkg.add(l_calling_fn, 'Enter ', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
4283: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost, p_log_level_rec => p_log_level_rec);
4284: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.life_in_months', p_asset_fin_rec_adj.life_in_months, p_log_level_rec => p_log_level_rec);
4285: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
4286: p_asset_fin_rec_adj.deprn_method_code, p_log_level_rec => p_log_level_rec);
4287: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.date_placed_in_service',
4288: p_asset_fin_rec_adj.date_placed_in_service, p_log_level_rec => p_log_level_rec);
4289: end if;

Line 4287: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.date_placed_in_service',

4283: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost, p_log_level_rec => p_log_level_rec);
4284: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.life_in_months', p_asset_fin_rec_adj.life_in_months, p_log_level_rec => p_log_level_rec);
4285: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
4286: p_asset_fin_rec_adj.deprn_method_code, p_log_level_rec => p_log_level_rec);
4287: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.date_placed_in_service',
4288: p_asset_fin_rec_adj.date_placed_in_service, p_log_level_rec => p_log_level_rec);
4289: end if;
4290:
4291: if (nvl(p_asset_fin_rec_adj.cost,0) <> 0) then

Line 4350: fa_debug_pkg.add(l_calling_fn, 'End', ' ', p_log_level_rec => p_log_level_rec);

4346: return FALSE;
4347: end if;
4348:
4349: if (p_log_level_rec.statement_level) then
4350: fa_debug_pkg.add(l_calling_fn, 'End', ' ', p_log_level_rec => p_log_level_rec);
4351: end if;
4352:
4353: return true;
4354:

Line 4358: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);

4354:
4355: EXCEPTION
4356: WHEN OTHERS THEN
4357: if (p_log_level_rec.statement_level) then
4358: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
4359: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost, p_log_level_rec => p_log_level_rec);
4360: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
4361: p_asset_fin_rec_adj.deprn_method_code, p_log_level_rec => p_log_level_rec);
4362: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);

Line 4359: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost, p_log_level_rec => p_log_level_rec);

4355: EXCEPTION
4356: WHEN OTHERS THEN
4357: if (p_log_level_rec.statement_level) then
4358: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
4359: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost, p_log_level_rec => p_log_level_rec);
4360: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
4361: p_asset_fin_rec_adj.deprn_method_code, p_log_level_rec => p_log_level_rec);
4362: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
4363: end if;

Line 4360: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',

4356: WHEN OTHERS THEN
4357: if (p_log_level_rec.statement_level) then
4358: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
4359: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost, p_log_level_rec => p_log_level_rec);
4360: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
4361: p_asset_fin_rec_adj.deprn_method_code, p_log_level_rec => p_log_level_rec);
4362: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
4363: end if;
4364:

Line 4362: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);

4358: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
4359: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost, p_log_level_rec => p_log_level_rec);
4360: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
4361: p_asset_fin_rec_adj.deprn_method_code, p_log_level_rec => p_log_level_rec);
4362: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
4363: end if;
4364:
4365: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn , p_log_level_rec => p_log_level_rec);
4366:

Line 4410: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);

4406:
4407: EXCEPTION
4408: WHEN OTHERS THEN
4409: if (p_log_level_rec.statement_level) then
4410: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
4411: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
4412: end if;
4413:
4414: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn , p_log_level_rec => p_log_level_rec);

Line 4411: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);

4407: EXCEPTION
4408: WHEN OTHERS THEN
4409: if (p_log_level_rec.statement_level) then
4410: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
4411: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
4412: end if;
4413:
4414: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn , p_log_level_rec => p_log_level_rec);
4415:

Line 4478: fa_debug_pkg.add(p_calling_fn,

4474:
4475: l_exception_code := null;
4476:
4477: if (p_log_level_rec.statement_level) then
4478: fa_debug_pkg.add(p_calling_fn,
4479: 'performing','JP-STL-EXTND method validation', p_log_level_rec => p_log_level_rec);
4480:
4481: end if;
4482:

Line 4574: fa_debug_pkg.add(p_calling_fn,

4570: l_exception_code := null;
4571:
4572:
4573: if (p_log_level_rec.statement_level) then
4574: fa_debug_pkg.add(p_calling_fn,
4575: 'performing','Earlier depreciable limit Validation', p_log_level_rec => p_log_level_rec);
4576: end if;
4577:
4578: if p_prior_deprn_limit_type in ('AMT','PCT') then

Line 4663: fa_debug_pkg.add(p_calling_fn,

4659: close lcu_curr_open_period;
4660:
4661:
4662: if (p_log_level_rec.statement_level) then
4663: fa_debug_pkg.add(p_calling_fn,
4664: 'performing','Period when fully reserved validation', p_log_level_rec => p_log_level_rec);
4665: end if;
4666:
4667: if p_pc_fully_reserved is null then

Line 4758: fa_debug_pkg.add(p_calling_fn,

4754:
4755: l_exception_code := null;
4756:
4757: if (p_log_level_rec.statement_level) then
4758: fa_debug_pkg.add(p_calling_fn,
4759: 'performing','First period of extended depreciation validation', p_log_level_rec => p_log_level_rec);
4760: end if;
4761:
4762: l_period_end_dt := null;

Line 4859: fa_debug_pkg.add(p_calling_fn,

4855:
4856: l_exception_code := null;
4857:
4858: if (p_log_level_rec.statement_level) then
4859: fa_debug_pkg.add(p_calling_fn,
4860: 'performing','NOT-JP-STL_EXTND validation', p_log_level_rec => p_log_level_rec);
4861: end if;
4862:
4863: open lcu_curr_open_period(p_book_type_code

Line 4878: fa_debug_pkg.add(p_calling_fn,

4874: if NVL(p_cost,0) <> 0 AND NVL(p_cost,0) - NVL(l_amt,0) - NVL(p_deprn_reserve,0) = 0 then --- BUG# 7368126 "NVL(p_cost,0) > 0 AND" is added to avoid the erroring out of Mass Additions post program, if the Asset cost = 0
4875: --check with the nbv <= 0 then period full resrve is mandatory
4876: if p_asset_type NOT IN ( 'GROUP','CIP') then --- BUG# 7368126 "p_asset_type NOT IN ( 'GROUP','CIP')" is added to avoid the erroring out of Mass Additions post program, if the Asset_type is GROUP, CIP
4877: if (p_log_level_rec.statement_level) then
4878: fa_debug_pkg.add(p_calling_fn,
4879: 'performing','First period of extended depreciation validation', p_log_level_rec => p_log_level_rec);
4880: end if;
4881: --Bug7114834 Changed the condition that checks for null p_pc_fully_reserved
4882: if p_pc_fully_reserved is not null then

Line 4954: fa_debug_pkg.add(p_calling_fn,

4950:
4951: l_exception_code := null;
4952:
4953: if (p_log_level_rec.statement_level) then
4954: fa_debug_pkg.add(p_calling_fn,
4955: 'performing','JP 250 DB validation', p_log_level_rec => p_log_level_rec);
4956: end if;
4957:
4958: -- bug7668308:Added ytd, in order to calculate correct NBV.

Line 5052: fa_debug_pkg.add(p_calling_fn, 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);

5048:
5049: EXCEPTION
5050: WHEN OTHERS THEN
5051: if (p_log_level_rec.statement_level) then
5052: fa_debug_pkg.add(p_calling_fn, 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);
5053: fa_debug_pkg.add(p_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);
5054: fa_debug_pkg.add(p_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
5055: end if;
5056:

Line 5053: fa_debug_pkg.add(p_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);

5049: EXCEPTION
5050: WHEN OTHERS THEN
5051: if (p_log_level_rec.statement_level) then
5052: fa_debug_pkg.add(p_calling_fn, 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);
5053: fa_debug_pkg.add(p_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);
5054: fa_debug_pkg.add(p_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
5055: end if;
5056:
5057: fa_srvr_msg.add_sql_error(calling_fn => p_calling_fn, p_log_level_rec => p_log_level_rec);

Line 5054: fa_debug_pkg.add(p_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);

5050: WHEN OTHERS THEN
5051: if (p_log_level_rec.statement_level) then
5052: fa_debug_pkg.add(p_calling_fn, 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);
5053: fa_debug_pkg.add(p_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);
5054: fa_debug_pkg.add(p_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
5055: end if;
5056:
5057: fa_srvr_msg.add_sql_error(calling_fn => p_calling_fn, p_log_level_rec => p_log_level_rec);
5058: return FALSE;

Line 5128: fa_debug_pkg.add(l_calling_fn, 'End', ' ');

5124: end if;
5125: end if; -- End of SUM loop
5126:
5127: if (p_log_level_rec.statement_level) then
5128: fa_debug_pkg.add(l_calling_fn, 'End', ' ');
5129: end if;
5130:
5131: return TRUE;
5132:

Line 5136: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id);

5132:
5133: EXCEPTION
5134: WHEN OTHERS THEN
5135: if (p_log_level_rec.statement_level) then
5136: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id);
5137: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.salvage_type', p_asset_fin_rec_adj.salvage_type);
5138: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_limit_type',
5139: p_asset_fin_rec_adj.deprn_limit_type);
5140: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);

Line 5137: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.salvage_type', p_asset_fin_rec_adj.salvage_type);

5133: EXCEPTION
5134: WHEN OTHERS THEN
5135: if (p_log_level_rec.statement_level) then
5136: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id);
5137: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.salvage_type', p_asset_fin_rec_adj.salvage_type);
5138: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_limit_type',
5139: p_asset_fin_rec_adj.deprn_limit_type);
5140: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
5141: end if;

Line 5138: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_limit_type',

5134: WHEN OTHERS THEN
5135: if (p_log_level_rec.statement_level) then
5136: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id);
5137: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.salvage_type', p_asset_fin_rec_adj.salvage_type);
5138: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_limit_type',
5139: p_asset_fin_rec_adj.deprn_limit_type);
5140: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
5141: end if;
5142: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn );

Line 5140: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);

5136: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id);
5137: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.salvage_type', p_asset_fin_rec_adj.salvage_type);
5138: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_limit_type',
5139: p_asset_fin_rec_adj.deprn_limit_type);
5140: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
5141: end if;
5142: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn );
5143: return FALSE;
5144:

Line 5279: fa_debug_pkg.add(l_calling_fn, 'validate_over_depreciation', 'BEGINS', p_log_level_rec);

5275: l_currency_code varchar2(15) := '';
5276:
5277: BEGIN
5278: if p_log_level_rec.statement_level then
5279: fa_debug_pkg.add(l_calling_fn, 'validate_over_depreciation', 'BEGINS', p_log_level_rec);
5280: fa_debug_pkg.add(l_calling_fn, 'p_validation_type', p_validation_type, p_log_level_rec);
5281: fa_debug_pkg.add(l_calling_fn, 'p_cost_adj', p_cost_adj, p_log_level_rec);
5282: fa_debug_pkg.add(l_calling_fn, 'p_rsv_adj', p_rsv_adj, p_log_level_rec);
5283: end if;

Line 5280: fa_debug_pkg.add(l_calling_fn, 'p_validation_type', p_validation_type, p_log_level_rec);

5276:
5277: BEGIN
5278: if p_log_level_rec.statement_level then
5279: fa_debug_pkg.add(l_calling_fn, 'validate_over_depreciation', 'BEGINS', p_log_level_rec);
5280: fa_debug_pkg.add(l_calling_fn, 'p_validation_type', p_validation_type, p_log_level_rec);
5281: fa_debug_pkg.add(l_calling_fn, 'p_cost_adj', p_cost_adj, p_log_level_rec);
5282: fa_debug_pkg.add(l_calling_fn, 'p_rsv_adj', p_rsv_adj, p_log_level_rec);
5283: end if;
5284:

Line 5281: fa_debug_pkg.add(l_calling_fn, 'p_cost_adj', p_cost_adj, p_log_level_rec);

5277: BEGIN
5278: if p_log_level_rec.statement_level then
5279: fa_debug_pkg.add(l_calling_fn, 'validate_over_depreciation', 'BEGINS', p_log_level_rec);
5280: fa_debug_pkg.add(l_calling_fn, 'p_validation_type', p_validation_type, p_log_level_rec);
5281: fa_debug_pkg.add(l_calling_fn, 'p_cost_adj', p_cost_adj, p_log_level_rec);
5282: fa_debug_pkg.add(l_calling_fn, 'p_rsv_adj', p_rsv_adj, p_log_level_rec);
5283: end if;
5284:
5285: l_asset_hdr_rec := p_asset_hdr_rec;

Line 5282: fa_debug_pkg.add(l_calling_fn, 'p_rsv_adj', p_rsv_adj, p_log_level_rec);

5278: if p_log_level_rec.statement_level then
5279: fa_debug_pkg.add(l_calling_fn, 'validate_over_depreciation', 'BEGINS', p_log_level_rec);
5280: fa_debug_pkg.add(l_calling_fn, 'p_validation_type', p_validation_type, p_log_level_rec);
5281: fa_debug_pkg.add(l_calling_fn, 'p_cost_adj', p_cost_adj, p_log_level_rec);
5282: fa_debug_pkg.add(l_calling_fn, 'p_rsv_adj', p_rsv_adj, p_log_level_rec);
5283: end if;
5284:
5285: l_asset_hdr_rec := p_asset_hdr_rec;
5286: l_asset_hdr_rec_mem := p_asset_hdr_rec;

Line 5300: fa_debug_pkg.add(l_calling_fn, 'ERROR', 'Calling get_asset_fin_rec',

5296: p_transaction_header_id => NULL,
5297: p_mrc_sob_type_code => p_mrc_sob_type_code,
5298: p_log_level_rec => p_log_level_rec) then
5299: if (p_log_level_rec.statement_level) then
5300: fa_debug_pkg.add(l_calling_fn, 'ERROR', 'Calling get_asset_fin_rec',
5301: p_log_level_rec => p_log_level_rec);
5302: end if;
5303: raise add_err1;
5304: end if;

Line 5311: fa_debug_pkg.add(l_calling_fn, 'ERROR', 'Calling fazccmt',

5307: if not fa_cache_pkg.fazccmt
5308: (X_method => l_asset_fin_rec_grp.deprn_method_code,
5309: X_life => l_asset_fin_rec_grp.life_in_months) then
5310: if (p_log_level_rec.statement_level) then
5311: fa_debug_pkg.add(l_calling_fn, 'ERROR', 'Calling fazccmt',
5312: p_log_level_rec => p_log_level_rec);
5313: end if;
5314: raise add_err1;
5315: end if;

Line 5331: fa_debug_pkg.add(l_calling_fn, 'Inside IF', 'Need to validate', p_log_level_rec);

5327: nvl(l_asset_fin_rec_grp.member_rollup_flag, 'N') = 'N')) and
5328: (l_asset_fin_rec_grp.over_depreciate_option = fa_std_types.FA_OVER_DEPR_NO ) then
5329:
5330: if p_log_level_rec.statement_level then
5331: fa_debug_pkg.add(l_calling_fn, 'Inside IF', 'Need to validate', p_log_level_rec);
5332: end if;
5333:
5334: if not FA_UTIL_PVT.get_asset_deprn_rec
5335: (p_asset_hdr_rec => l_asset_hdr_rec,

Line 5342: fa_debug_pkg.add(l_calling_fn, 'ERROR', 'Calling get_asset_deprn_rec',

5338: p_mrc_sob_type_code => p_mrc_sob_type_code,
5339: p_log_level_rec => p_log_level_rec
5340: ) then
5341: if (p_log_level_rec.statement_level) then
5342: fa_debug_pkg.add(l_calling_fn, 'ERROR', 'Calling get_asset_deprn_rec',
5343: p_log_level_rec => p_log_level_rec);
5344: end if;
5345: raise add_err1;
5346: end if;

Line 5349: fa_debug_pkg.add(l_calling_fn, 'group id:reserve:', l_asset_hdr_rec.asset_id || ' : ' || l_grp_asset_deprn_rec.deprn_reserve, p_log_level_rec);

5345: raise add_err1;
5346: end if;
5347:
5348: if p_log_level_rec.statement_level then
5349: fa_debug_pkg.add(l_calling_fn, 'group id:reserve:', l_asset_hdr_rec.asset_id || ' : ' || l_grp_asset_deprn_rec.deprn_reserve, p_log_level_rec);
5350: end if;
5351: if p_validation_type = 'RETIREMENT' then
5352: l_new_group_cost := nvl(l_asset_fin_rec_grp.cost,0) - nvl(p_cost_adj,0);
5353: /*if last member reserve will be cleared by terminal gain/loss */

Line 5371: fa_debug_pkg.add(l_calling_fn, 'ERROR', 'Calling get_asset_fin_rec',

5367: p_transaction_header_id => NULL,
5368: p_mrc_sob_type_code => p_mrc_sob_type_code,
5369: p_log_level_rec => p_log_level_rec) then
5370: if (p_log_level_rec.statement_level) then
5371: fa_debug_pkg.add(l_calling_fn, 'ERROR', 'Calling get_asset_fin_rec',
5372: p_log_level_rec => p_log_level_rec);
5373: end if;
5374: raise add_err1;
5375: end if;

Line 5385: fa_debug_pkg.add(l_calling_fn, 'ERROR', 'Calling get_asset_deprn_rec',

5381: p_mrc_sob_type_code => p_mrc_sob_type_code,
5382: p_log_level_rec => p_log_level_rec
5383: ) then
5384: if (p_log_level_rec.statement_level) then
5385: fa_debug_pkg.add(l_calling_fn, 'ERROR', 'Calling get_asset_deprn_rec',
5386: p_log_level_rec => p_log_level_rec);
5387: end if;
5388: raise add_err1;
5389: end if;

Line 5391: fa_debug_pkg.add(l_calling_fn, 'Member asset id:cost:reserve:', l_asset_hdr_rec_mem.asset_id || ' : ' || l_asset_fin_rec_mem.cost || ' : ' || l_mem_asset_deprn_rec.deprn_reserve, p_log_level_rec);

5387: end if;
5388: raise add_err1;
5389: end if;
5390: if p_log_level_rec.statement_level then
5391: fa_debug_pkg.add(l_calling_fn, 'Member asset id:cost:reserve:', l_asset_hdr_rec_mem.asset_id || ' : ' || l_asset_fin_rec_mem.cost || ' : ' || l_mem_asset_deprn_rec.deprn_reserve, p_log_level_rec);
5392: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec);
5393: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.group_asset_id', p_asset_fin_rec.group_asset_id, p_log_level_rec);
5394: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_mem.group_asset_id', l_asset_fin_rec_mem.group_asset_id, p_log_level_rec);
5395: end if;

Line 5392: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec);

5388: raise add_err1;
5389: end if;
5390: if p_log_level_rec.statement_level then
5391: fa_debug_pkg.add(l_calling_fn, 'Member asset id:cost:reserve:', l_asset_hdr_rec_mem.asset_id || ' : ' || l_asset_fin_rec_mem.cost || ' : ' || l_mem_asset_deprn_rec.deprn_reserve, p_log_level_rec);
5392: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec);
5393: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.group_asset_id', p_asset_fin_rec.group_asset_id, p_log_level_rec);
5394: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_mem.group_asset_id', l_asset_fin_rec_mem.group_asset_id, p_log_level_rec);
5395: end if;
5396: /*Bug 8754829 -start*/

Line 5393: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.group_asset_id', p_asset_fin_rec.group_asset_id, p_log_level_rec);

5389: end if;
5390: if p_log_level_rec.statement_level then
5391: fa_debug_pkg.add(l_calling_fn, 'Member asset id:cost:reserve:', l_asset_hdr_rec_mem.asset_id || ' : ' || l_asset_fin_rec_mem.cost || ' : ' || l_mem_asset_deprn_rec.deprn_reserve, p_log_level_rec);
5392: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec);
5393: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.group_asset_id', p_asset_fin_rec.group_asset_id, p_log_level_rec);
5394: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_mem.group_asset_id', l_asset_fin_rec_mem.group_asset_id, p_log_level_rec);
5395: end if;
5396: /*Bug 8754829 -start*/
5397: if (p_cost_adj = 0 AND

Line 5394: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_mem.group_asset_id', l_asset_fin_rec_mem.group_asset_id, p_log_level_rec);

5390: if p_log_level_rec.statement_level then
5391: fa_debug_pkg.add(l_calling_fn, 'Member asset id:cost:reserve:', l_asset_hdr_rec_mem.asset_id || ' : ' || l_asset_fin_rec_mem.cost || ' : ' || l_mem_asset_deprn_rec.deprn_reserve, p_log_level_rec);
5392: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec);
5393: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.group_asset_id', p_asset_fin_rec.group_asset_id, p_log_level_rec);
5394: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_mem.group_asset_id', l_asset_fin_rec_mem.group_asset_id, p_log_level_rec);
5395: end if;
5396: /*Bug 8754829 -start*/
5397: if (p_cost_adj = 0 AND
5398: nvl(p_asset_fin_rec.group_asset_id,-99) <> nvl(l_asset_fin_rec_mem.group_asset_id,-99)

Line 5420: fa_debug_pkg.add(l_calling_fn, 'Before member over deprn', ' ', p_log_level_rec);

5416: end if;
5417: end if;
5418: l_new_mem_cost := l_new_mem_cost - nvl(l_mem_salvage_val,0);
5419: if p_log_level_rec.statement_level then
5420: fa_debug_pkg.add(l_calling_fn, 'Before member over deprn', ' ', p_log_level_rec);
5421: fa_debug_pkg.add(l_calling_fn, 'l_new_mem_cost', l_new_mem_cost, p_log_level_rec);
5422: fa_debug_pkg.add(l_calling_fn, 'l_mem_salvage_val', l_mem_salvage_val, p_log_level_rec);
5423: fa_debug_pkg.add(l_calling_fn, 'l_new_mem_reserve', l_new_mem_reserve, p_log_level_rec);
5424: end if;

Line 5421: fa_debug_pkg.add(l_calling_fn, 'l_new_mem_cost', l_new_mem_cost, p_log_level_rec);

5417: end if;
5418: l_new_mem_cost := l_new_mem_cost - nvl(l_mem_salvage_val,0);
5419: if p_log_level_rec.statement_level then
5420: fa_debug_pkg.add(l_calling_fn, 'Before member over deprn', ' ', p_log_level_rec);
5421: fa_debug_pkg.add(l_calling_fn, 'l_new_mem_cost', l_new_mem_cost, p_log_level_rec);
5422: fa_debug_pkg.add(l_calling_fn, 'l_mem_salvage_val', l_mem_salvage_val, p_log_level_rec);
5423: fa_debug_pkg.add(l_calling_fn, 'l_new_mem_reserve', l_new_mem_reserve, p_log_level_rec);
5424: end if;
5425:

Line 5422: fa_debug_pkg.add(l_calling_fn, 'l_mem_salvage_val', l_mem_salvage_val, p_log_level_rec);

5418: l_new_mem_cost := l_new_mem_cost - nvl(l_mem_salvage_val,0);
5419: if p_log_level_rec.statement_level then
5420: fa_debug_pkg.add(l_calling_fn, 'Before member over deprn', ' ', p_log_level_rec);
5421: fa_debug_pkg.add(l_calling_fn, 'l_new_mem_cost', l_new_mem_cost, p_log_level_rec);
5422: fa_debug_pkg.add(l_calling_fn, 'l_mem_salvage_val', l_mem_salvage_val, p_log_level_rec);
5423: fa_debug_pkg.add(l_calling_fn, 'l_new_mem_reserve', l_new_mem_reserve, p_log_level_rec);
5424: end if;
5425:
5426:

Line 5423: fa_debug_pkg.add(l_calling_fn, 'l_new_mem_reserve', l_new_mem_reserve, p_log_level_rec);

5419: if p_log_level_rec.statement_level then
5420: fa_debug_pkg.add(l_calling_fn, 'Before member over deprn', ' ', p_log_level_rec);
5421: fa_debug_pkg.add(l_calling_fn, 'l_new_mem_cost', l_new_mem_cost, p_log_level_rec);
5422: fa_debug_pkg.add(l_calling_fn, 'l_mem_salvage_val', l_mem_salvage_val, p_log_level_rec);
5423: fa_debug_pkg.add(l_calling_fn, 'l_new_mem_reserve', l_new_mem_reserve, p_log_level_rec);
5424: end if;
5425:
5426:
5427: if (l_new_mem_cost = 0 and l_new_mem_reserve <> 0) OR

Line 5465: fa_debug_pkg.add(l_calling_fn, 'validate_over_depreciation l_new_group_cost', l_new_group_cost, p_log_level_rec);

5461: l_new_group_reserve := nvl(l_grp_asset_deprn_rec.deprn_reserve,0) + nvl(p_rsv_adj,0);
5462: end if;
5463:
5464: if p_log_level_rec.statement_level then
5465: fa_debug_pkg.add(l_calling_fn, 'validate_over_depreciation l_new_group_cost', l_new_group_cost, p_log_level_rec);
5466: fa_debug_pkg.add(l_calling_fn, 'validate_over_depreciation l_new_group_reserve', l_new_group_reserve, p_log_level_rec);
5467: end if;
5468:
5469: if (l_new_group_cost = 0 and l_new_group_reserve <> 0) OR

Line 5466: fa_debug_pkg.add(l_calling_fn, 'validate_over_depreciation l_new_group_reserve', l_new_group_reserve, p_log_level_rec);

5462: end if;
5463:
5464: if p_log_level_rec.statement_level then
5465: fa_debug_pkg.add(l_calling_fn, 'validate_over_depreciation l_new_group_cost', l_new_group_cost, p_log_level_rec);
5466: fa_debug_pkg.add(l_calling_fn, 'validate_over_depreciation l_new_group_reserve', l_new_group_reserve, p_log_level_rec);
5467: end if;
5468:
5469: if (l_new_group_cost = 0 and l_new_group_reserve <> 0) OR
5470: (l_new_group_cost > l_new_group_reserve and l_new_group_cost < 0 ) OR

Line 5490: fa_debug_pkg.add(l_calling_fn, 'ERROR executing ',l_calling_fn,p_log_level_rec);

5486:
5487: EXCEPTION
5488: WHEN add_err1 then
5489: if (p_log_level_rec.statement_level) then
5490: fa_debug_pkg.add(l_calling_fn, 'ERROR executing ',l_calling_fn,p_log_level_rec);
5491: fa_debug_pkg.add(l_calling_fn, 'Asset id :',l_asset_hdr_rec_mem.asset_id,p_log_level_rec);
5492: fa_debug_pkg.add(l_calling_fn, 'Book type code :',p_asset_hdr_rec.book_type_Code,p_log_level_rec);
5493: end if;
5494: return false;

Line 5491: fa_debug_pkg.add(l_calling_fn, 'Asset id :',l_asset_hdr_rec_mem.asset_id,p_log_level_rec);

5487: EXCEPTION
5488: WHEN add_err1 then
5489: if (p_log_level_rec.statement_level) then
5490: fa_debug_pkg.add(l_calling_fn, 'ERROR executing ',l_calling_fn,p_log_level_rec);
5491: fa_debug_pkg.add(l_calling_fn, 'Asset id :',l_asset_hdr_rec_mem.asset_id,p_log_level_rec);
5492: fa_debug_pkg.add(l_calling_fn, 'Book type code :',p_asset_hdr_rec.book_type_Code,p_log_level_rec);
5493: end if;
5494: return false;
5495: WHEN OTHERS THEN

Line 5492: fa_debug_pkg.add(l_calling_fn, 'Book type code :',p_asset_hdr_rec.book_type_Code,p_log_level_rec);

5488: WHEN add_err1 then
5489: if (p_log_level_rec.statement_level) then
5490: fa_debug_pkg.add(l_calling_fn, 'ERROR executing ',l_calling_fn,p_log_level_rec);
5491: fa_debug_pkg.add(l_calling_fn, 'Asset id :',l_asset_hdr_rec_mem.asset_id,p_log_level_rec);
5492: fa_debug_pkg.add(l_calling_fn, 'Book type code :',p_asset_hdr_rec.book_type_Code,p_log_level_rec);
5493: end if;
5494: return false;
5495: WHEN OTHERS THEN
5496: if (p_log_level_rec.statement_level) then

Line 5497: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);

5493: end if;
5494: return false;
5495: WHEN OTHERS THEN
5496: if (p_log_level_rec.statement_level) then
5497: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
5498: end if;
5499: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn );
5500: return FALSE;
5501: END validate_over_depreciation;

Line 5571: fa_debug_pkg.add(l_calling_fn, 'begin', '', p_log_level_rec);

5567: val_err exception;
5568:
5569: BEGIN
5570: if (p_log_level_rec.statement_level) then
5571: fa_debug_pkg.add(l_calling_fn, 'begin', '', p_log_level_rec);
5572: end if;
5573:
5574: l_asset_fin_rec := p_asset_fin_rec_old;
5575: l_asset_type_rec := p_asset_type_rec;

Line 5587: fa_debug_pkg.add(l_calling_fn, 'loaded asset type cache', '', p_log_level_rec);

5583: raise val_err;
5584: end if;
5585:
5586: IF (p_log_level_rec.statement_level) then
5587: fa_debug_pkg.add(l_calling_fn, 'loaded asset type cache', '', p_log_level_rec);
5588: END IF;
5589: END IF;
5590:
5591: -- Next load finrec in case of it is null

Line 5594: fa_debug_pkg.add(l_calling_fn, 'asset_fin_rec is NULL', '', p_log_level_rec);

5590:
5591: -- Next load finrec in case of it is null
5592: IF l_asset_fin_rec.cost is NULL Then
5593: if p_log_level_rec.statement_level then
5594: fa_debug_pkg.add(l_calling_fn, 'asset_fin_rec is NULL', '', p_log_level_rec);
5595: end if;
5596:
5597: IF not FA_UTIL_PVT.get_asset_fin_rec(p_asset_hdr_rec => p_asset_hdr_rec,
5598: px_asset_fin_rec => l_asset_fin_rec,

Line 5606: fa_debug_pkg.add(l_calling_fn, 'loaded finreec cache', '', p_log_level_rec);

5602: raise val_err;
5603: END IF;
5604:
5605: IF (p_log_level_rec.statement_level) then
5606: fa_debug_pkg.add(l_calling_fn, 'loaded finreec cache', '', p_log_level_rec);
5607: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.cost', l_asset_fin_rec.cost, p_log_level_rec);
5608: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.group_asset_id',
5609: nvl(l_asset_fin_rec.group_asset_id,-100), p_log_level_rec);
5610: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.depreciate_flag',

Line 5607: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.cost', l_asset_fin_rec.cost, p_log_level_rec);

5603: END IF;
5604:
5605: IF (p_log_level_rec.statement_level) then
5606: fa_debug_pkg.add(l_calling_fn, 'loaded finreec cache', '', p_log_level_rec);
5607: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.cost', l_asset_fin_rec.cost, p_log_level_rec);
5608: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.group_asset_id',
5609: nvl(l_asset_fin_rec.group_asset_id,-100), p_log_level_rec);
5610: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.depreciate_flag',
5611: l_asset_fin_rec.depreciate_flag, p_log_level_rec);

Line 5608: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.group_asset_id',

5604:
5605: IF (p_log_level_rec.statement_level) then
5606: fa_debug_pkg.add(l_calling_fn, 'loaded finreec cache', '', p_log_level_rec);
5607: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.cost', l_asset_fin_rec.cost, p_log_level_rec);
5608: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.group_asset_id',
5609: nvl(l_asset_fin_rec.group_asset_id,-100), p_log_level_rec);
5610: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.depreciate_flag',
5611: l_asset_fin_rec.depreciate_flag, p_log_level_rec);
5612: fa_debug_pkg.add(l_calling_fn, 'complete finreec cache', '', p_log_level_rec);

Line 5610: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.depreciate_flag',

5606: fa_debug_pkg.add(l_calling_fn, 'loaded finreec cache', '', p_log_level_rec);
5607: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.cost', l_asset_fin_rec.cost, p_log_level_rec);
5608: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.group_asset_id',
5609: nvl(l_asset_fin_rec.group_asset_id,-100), p_log_level_rec);
5610: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.depreciate_flag',
5611: l_asset_fin_rec.depreciate_flag, p_log_level_rec);
5612: fa_debug_pkg.add(l_calling_fn, 'complete finreec cache', '', p_log_level_rec);
5613: END IF;
5614: END IF;

Line 5612: fa_debug_pkg.add(l_calling_fn, 'complete finreec cache', '', p_log_level_rec);

5608: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.group_asset_id',
5609: nvl(l_asset_fin_rec.group_asset_id,-100), p_log_level_rec);
5610: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec.depreciate_flag',
5611: l_asset_fin_rec.depreciate_flag, p_log_level_rec);
5612: fa_debug_pkg.add(l_calling_fn, 'complete finreec cache', '', p_log_level_rec);
5613: END IF;
5614: END IF;
5615:
5616: --Load method cache

Line 5621: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt', p_log_level_rec);

5617: if (not fa_cache_pkg.fazccmt(l_asset_fin_rec.deprn_method_code,
5618: l_asset_fin_rec.life_in_months,
5619: p_log_level_rec => p_log_level_rec)) then
5620: if (p_log_level_rec.statement_level) then
5621: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt', p_log_level_rec);
5622: end if;
5623:
5624: raise val_err;
5625: end if;

Line 5628: fa_debug_pkg.add(l_calling_fn, 'loaded method cache : source_rule',

5624: raise val_err;
5625: end if;
5626:
5627: IF (p_log_level_rec.statement_level) then
5628: fa_debug_pkg.add(l_calling_fn, 'loaded method cache : source_rule',
5629: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec);
5630: END IF;
5631:
5632: IF fa_cache_pkg.fazccmt_record.rate_source_rule = 'PRODUCTION' THEN

Line 5861: fa_debug_pkg.add(l_calling_fn, 'bein', ' ', p_log_level_rec);

5857:
5858:
5859: BEGIN
5860: IF (p_log_level_rec.statement_level) THEN
5861: fa_debug_pkg.add(l_calling_fn, 'bein', ' ', p_log_level_rec);
5862: fa_debug_pkg.add(l_calling_fn, 'retirement_id : recognize_gain_loss',
5863: p_asset_retire_rec.retirement_id ||':'|| p_asset_retire_rec.recognize_gain_loss,
5864: p_log_level_rec);
5865: END IF;

Line 5862: fa_debug_pkg.add(l_calling_fn, 'retirement_id : recognize_gain_loss',

5858:
5859: BEGIN
5860: IF (p_log_level_rec.statement_level) THEN
5861: fa_debug_pkg.add(l_calling_fn, 'bein', ' ', p_log_level_rec);
5862: fa_debug_pkg.add(l_calling_fn, 'retirement_id : recognize_gain_loss',
5863: p_asset_retire_rec.retirement_id ||':'|| p_asset_retire_rec.recognize_gain_loss,
5864: p_log_level_rec);
5865: END IF;
5866:

Line 5876: fa_debug_pkg.add(l_calling_fn, 'l_ret_adj_amount', l_ret_adj_amount, p_log_level_rec);

5872: fetch c_ret_adj_amount into l_ret_adj_amount;
5873: close c_ret_adj_amount;
5874:
5875: IF (p_log_level_rec.statement_level) THEN
5876: fa_debug_pkg.add(l_calling_fn, 'l_ret_adj_amount', l_ret_adj_amount, p_log_level_rec);
5877: END IF;
5878:
5879: if l_ret_adj_amount = 0 THEN
5880: return TRUE;

Line 5889: fa_debug_pkg.add(l_calling_fn, 'l_grp_cost', l_grp_cost, p_log_level_rec);

5885: open c_grp_cost;
5886: fetch c_grp_cost into l_grp_cost;
5887: close c_grp_cost;
5888: IF (p_log_level_rec.statement_level) THEN
5889: fa_debug_pkg.add(l_calling_fn, 'l_grp_cost', l_grp_cost, p_log_level_rec);
5890: END IF;
5891: if (l_grp_cost = 0) then
5892: open c_last_ret_mem_details;
5893: fetch c_last_ret_mem_details into l_last_asset_id,l_last_asset_num,l_max_ret_trx_id;

Line 5896: fa_debug_pkg.add(l_calling_fn, 'l_last_asset_id', l_last_asset_id, p_log_level_rec);

5892: open c_last_ret_mem_details;
5893: fetch c_last_ret_mem_details into l_last_asset_id,l_last_asset_num,l_max_ret_trx_id;
5894: close c_last_ret_mem_details;
5895: IF (p_log_level_rec.statement_level) THEN
5896: fa_debug_pkg.add(l_calling_fn, 'l_last_asset_id', l_last_asset_id, p_log_level_rec);
5897: fa_debug_pkg.add(l_calling_fn, 'l_last_asset_num', l_last_asset_num, p_log_level_rec);
5898: fa_debug_pkg.add(l_calling_fn, 'l_max_ret_trx_id', l_max_ret_trx_id, p_log_level_rec);
5899: fa_debug_pkg.add(l_calling_fn, 'detail_info.transaction_header_id_in', p_asset_retire_rec.detail_info.transaction_header_id_in,
5900: p_log_level_rec);

Line 5897: fa_debug_pkg.add(l_calling_fn, 'l_last_asset_num', l_last_asset_num, p_log_level_rec);

5893: fetch c_last_ret_mem_details into l_last_asset_id,l_last_asset_num,l_max_ret_trx_id;
5894: close c_last_ret_mem_details;
5895: IF (p_log_level_rec.statement_level) THEN
5896: fa_debug_pkg.add(l_calling_fn, 'l_last_asset_id', l_last_asset_id, p_log_level_rec);
5897: fa_debug_pkg.add(l_calling_fn, 'l_last_asset_num', l_last_asset_num, p_log_level_rec);
5898: fa_debug_pkg.add(l_calling_fn, 'l_max_ret_trx_id', l_max_ret_trx_id, p_log_level_rec);
5899: fa_debug_pkg.add(l_calling_fn, 'detail_info.transaction_header_id_in', p_asset_retire_rec.detail_info.transaction_header_id_in,
5900: p_log_level_rec);
5901: END IF;

Line 5898: fa_debug_pkg.add(l_calling_fn, 'l_max_ret_trx_id', l_max_ret_trx_id, p_log_level_rec);

5894: close c_last_ret_mem_details;
5895: IF (p_log_level_rec.statement_level) THEN
5896: fa_debug_pkg.add(l_calling_fn, 'l_last_asset_id', l_last_asset_id, p_log_level_rec);
5897: fa_debug_pkg.add(l_calling_fn, 'l_last_asset_num', l_last_asset_num, p_log_level_rec);
5898: fa_debug_pkg.add(l_calling_fn, 'l_max_ret_trx_id', l_max_ret_trx_id, p_log_level_rec);
5899: fa_debug_pkg.add(l_calling_fn, 'detail_info.transaction_header_id_in', p_asset_retire_rec.detail_info.transaction_header_id_in,
5900: p_log_level_rec);
5901: END IF;
5902:

Line 5899: fa_debug_pkg.add(l_calling_fn, 'detail_info.transaction_header_id_in', p_asset_retire_rec.detail_info.transaction_header_id_in,

5895: IF (p_log_level_rec.statement_level) THEN
5896: fa_debug_pkg.add(l_calling_fn, 'l_last_asset_id', l_last_asset_id, p_log_level_rec);
5897: fa_debug_pkg.add(l_calling_fn, 'l_last_asset_num', l_last_asset_num, p_log_level_rec);
5898: fa_debug_pkg.add(l_calling_fn, 'l_max_ret_trx_id', l_max_ret_trx_id, p_log_level_rec);
5899: fa_debug_pkg.add(l_calling_fn, 'detail_info.transaction_header_id_in', p_asset_retire_rec.detail_info.transaction_header_id_in,
5900: p_log_level_rec);
5901: END IF;
5902:
5903: if nvl(l_max_ret_trx_id,-99) <> p_asset_retire_rec.detail_info.transaction_header_id_in then

Line 5920: fa_debug_pkg.add(l_calling_fn, 'l_mbr_adjusted_cost', l_mbr_sum_adj_cost,p_log_level_rec);

5916: fetch c_mbr_adjusted_cost into l_mbr_sum_adj_cost;
5917: close c_mbr_adjusted_cost;
5918:
5919: IF (p_log_level_rec.statement_level) THEN
5920: fa_debug_pkg.add(l_calling_fn, 'l_mbr_adjusted_cost', l_mbr_sum_adj_cost,p_log_level_rec);
5921: END IF;
5922:
5923: open c_ret_mem_details;
5924: fetch c_ret_mem_details into l_ret_cost, l_ret_salvage_value;

Line 5928: fa_debug_pkg.add(l_calling_fn, 'p_asset_retire_rec.cost_retired', p_asset_retire_rec.cost_retired,p_log_level_rec);

5924: fetch c_ret_mem_details into l_ret_cost, l_ret_salvage_value;
5925: close c_ret_mem_details;
5926:
5927: IF (p_log_level_rec.statement_level) THEN
5928: fa_debug_pkg.add(l_calling_fn, 'p_asset_retire_rec.cost_retired', p_asset_retire_rec.cost_retired,p_log_level_rec);
5929: fa_debug_pkg.add(l_calling_fn, 'p_asset_retire_rec.reserve_retired', p_asset_retire_rec.reserve_retired,p_log_level_rec);
5930: fa_debug_pkg.add(l_calling_fn, 'l_ret_salvage_value', l_ret_salvage_value,p_log_level_rec);
5931: END IF;
5932:

Line 5929: fa_debug_pkg.add(l_calling_fn, 'p_asset_retire_rec.reserve_retired', p_asset_retire_rec.reserve_retired,p_log_level_rec);

5925: close c_ret_mem_details;
5926:
5927: IF (p_log_level_rec.statement_level) THEN
5928: fa_debug_pkg.add(l_calling_fn, 'p_asset_retire_rec.cost_retired', p_asset_retire_rec.cost_retired,p_log_level_rec);
5929: fa_debug_pkg.add(l_calling_fn, 'p_asset_retire_rec.reserve_retired', p_asset_retire_rec.reserve_retired,p_log_level_rec);
5930: fa_debug_pkg.add(l_calling_fn, 'l_ret_salvage_value', l_ret_salvage_value,p_log_level_rec);
5931: END IF;
5932:
5933:

Line 5930: fa_debug_pkg.add(l_calling_fn, 'l_ret_salvage_value', l_ret_salvage_value,p_log_level_rec);

5926:
5927: IF (p_log_level_rec.statement_level) THEN
5928: fa_debug_pkg.add(l_calling_fn, 'p_asset_retire_rec.cost_retired', p_asset_retire_rec.cost_retired,p_log_level_rec);
5929: fa_debug_pkg.add(l_calling_fn, 'p_asset_retire_rec.reserve_retired', p_asset_retire_rec.reserve_retired,p_log_level_rec);
5930: fa_debug_pkg.add(l_calling_fn, 'l_ret_salvage_value', l_ret_salvage_value,p_log_level_rec);
5931: END IF;
5932:
5933:
5934: l_max_ret_adj_reverse := nvl(l_mbr_sum_adj_cost,0) + p_asset_retire_rec.cost_retired -

Line 5938: fa_debug_pkg.add(l_calling_fn, 'l_max_ret_adj_reverse', l_max_ret_adj_reverse,p_log_level_rec);

5934: l_max_ret_adj_reverse := nvl(l_mbr_sum_adj_cost,0) + p_asset_retire_rec.cost_retired -
5935: nvl(p_asset_retire_rec.reserve_retired,0) - nvl(l_ret_salvage_value,0);
5936:
5937: IF (p_log_level_rec.statement_level) THEN
5938: fa_debug_pkg.add(l_calling_fn, 'l_max_ret_adj_reverse', l_max_ret_adj_reverse,p_log_level_rec);
5939: END IF;
5940:
5941: if l_ret_adj_amount*sign(l_ret_adj_amount) > l_max_ret_adj_reverse*sign(l_max_ret_adj_reverse) then
5942: fa_srvr_msg.add_message(

Line 6291: fa_debug_pkg.add(p_calling_fn, 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);

6287:
6288: EXCEPTION
6289: WHEN OTHERS THEN
6290: if (p_log_level_rec.statement_level) then
6291: fa_debug_pkg.add(p_calling_fn, 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);
6292: fa_debug_pkg.add(p_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);
6293: fa_debug_pkg.add(p_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
6294: end if;
6295:

Line 6292: fa_debug_pkg.add(p_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);

6288: EXCEPTION
6289: WHEN OTHERS THEN
6290: if (p_log_level_rec.statement_level) then
6291: fa_debug_pkg.add(p_calling_fn, 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);
6292: fa_debug_pkg.add(p_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);
6293: fa_debug_pkg.add(p_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
6294: end if;
6295:
6296: fa_srvr_msg.add_sql_error(calling_fn => p_calling_fn, p_log_level_rec => p_log_level_rec);

Line 6293: fa_debug_pkg.add(p_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);

6289: WHEN OTHERS THEN
6290: if (p_log_level_rec.statement_level) then
6291: fa_debug_pkg.add(p_calling_fn, 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);
6292: fa_debug_pkg.add(p_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => p_log_level_rec);
6293: fa_debug_pkg.add(p_calling_fn, 'EXCEPTION: OTHERS', sqlerrm, p_log_level_rec => p_log_level_rec);
6294: end if;
6295:
6296: fa_srvr_msg.add_sql_error(calling_fn => p_calling_fn, p_log_level_rec => p_log_level_rec);
6297:

Line 6317: fa_debug_pkg.add(l_calling_fn, 'begin', '', p_log_level_rec);

6313: l_fiscal_year varchar2 (30);
6314: l_cal_period_open_date date;
6315: BEGIN
6316: if (p_log_level_rec.statement_level) then
6317: fa_debug_pkg.add(l_calling_fn, 'begin', '', p_log_level_rec);
6318: fa_debug_pkg.add(l_calling_fn, 'Marcos rate_source_rule ', fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec);
6319: fa_debug_pkg.add(l_calling_fn, 'Marcos method_code ', fa_cache_pkg.fazccmt_record.method_code, p_log_level_rec);
6320: end if;
6321:

Line 6318: fa_debug_pkg.add(l_calling_fn, 'Marcos rate_source_rule ', fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec);

6314: l_cal_period_open_date date;
6315: BEGIN
6316: if (p_log_level_rec.statement_level) then
6317: fa_debug_pkg.add(l_calling_fn, 'begin', '', p_log_level_rec);
6318: fa_debug_pkg.add(l_calling_fn, 'Marcos rate_source_rule ', fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec);
6319: fa_debug_pkg.add(l_calling_fn, 'Marcos method_code ', fa_cache_pkg.fazccmt_record.method_code, p_log_level_rec);
6320: end if;
6321:
6322: if (nvl(fa_cache_pkg.fazcbc_record.book_type_code, '-NULL') <>

Line 6319: fa_debug_pkg.add(l_calling_fn, 'Marcos method_code ', fa_cache_pkg.fazccmt_record.method_code, p_log_level_rec);

6315: BEGIN
6316: if (p_log_level_rec.statement_level) then
6317: fa_debug_pkg.add(l_calling_fn, 'begin', '', p_log_level_rec);
6318: fa_debug_pkg.add(l_calling_fn, 'Marcos rate_source_rule ', fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec);
6319: fa_debug_pkg.add(l_calling_fn, 'Marcos method_code ', fa_cache_pkg.fazccmt_record.method_code, p_log_level_rec);
6320: end if;
6321:
6322: if (nvl(fa_cache_pkg.fazcbc_record.book_type_code, '-NULL') <>
6323: p_asset_hdr_rec.BOOK_TYPE_CODE) then

Line 6372: fa_debug_pkg.add(l_calling_fn, 'Current Transaction is overlapped to previously done Impairment', '', p_log_level_rec);

6368: END;
6369:
6370: IF l_imp_exists > 0 then
6371: IF (p_log_level_rec.statement_level) then
6372: fa_debug_pkg.add(l_calling_fn, 'Current Transaction is overlapped to previously done Impairment', '', p_log_level_rec);
6373: fa_debug_pkg.add(l_calling_fn, 'OR Amort start date/trx date is backdated ', 'to same Fiscal year in which an impairment already exists', p_log_level_rec);
6374: END IF;
6375: Return FALSE;
6376: ELSE

Line 6373: fa_debug_pkg.add(l_calling_fn, 'OR Amort start date/trx date is backdated ', 'to same Fiscal year in which an impairment already exists', p_log_level_rec);

6369:
6370: IF l_imp_exists > 0 then
6371: IF (p_log_level_rec.statement_level) then
6372: fa_debug_pkg.add(l_calling_fn, 'Current Transaction is overlapped to previously done Impairment', '', p_log_level_rec);
6373: fa_debug_pkg.add(l_calling_fn, 'OR Amort start date/trx date is backdated ', 'to same Fiscal year in which an impairment already exists', p_log_level_rec);
6374: END IF;
6375: Return FALSE;
6376: ELSE
6377: Return TRUE;

Line 6393: fa_debug_pkg.add(l_calling_fn, 'begin', 'l_calling_fn', p_log_level_rec);

6389: l_calling_fn varchar2(100) := 'FA_ASSET_VAL_PVT.check_non_depreciating_asset';
6390:
6391: BEGIN
6392: if (p_log_level_rec.statement_level) then
6393: fa_debug_pkg.add(l_calling_fn, 'begin', 'l_calling_fn', p_log_level_rec);
6394: end if;
6395: BEGIN
6396: SELECT 'Y'
6397: INTO l_restrict_trx

Line 6419: fa_debug_pkg.add(l_calling_fn, 'This asset is added with Deprecition flag NO and without Reserve', '', p_log_level_rec);

6415:
6416:
6417: IF (l_restrict_trx = 'Y') then
6418: IF (p_log_level_rec.statement_level) then
6419: fa_debug_pkg.add(l_calling_fn, 'This asset is added with Deprecition flag NO and without Reserve', '', p_log_level_rec);
6420: END IF;
6421: Return FALSE;
6422: ELSE
6423: Return TRUE;

Line 6439: fa_debug_pkg.add(l_calling_fn, 'p_asset_type_rec.asset_type', p_asset_type_rec.asset_type, p_log_level_rec);

6435: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN IS
6436: l_calling_fn varchar2(100) := 'FA_ASSET_VAL_PVT.validate_bonus_rule_resv';
6437: Begin
6438: IF (p_log_level_rec.statement_level) then
6439: fa_debug_pkg.add(l_calling_fn, 'p_asset_type_rec.asset_type', p_asset_type_rec.asset_type, p_log_level_rec);
6440: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.bonus_rule', p_asset_fin_rec.bonus_rule, p_log_level_rec);
6441: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.group_asset_id', p_asset_fin_rec.group_asset_id, p_log_level_rec);
6442: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec);
6443: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec.bonus_deprn_reserve', p_asset_deprn_rec.bonus_deprn_reserve, p_log_level_rec);

Line 6440: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.bonus_rule', p_asset_fin_rec.bonus_rule, p_log_level_rec);

6436: l_calling_fn varchar2(100) := 'FA_ASSET_VAL_PVT.validate_bonus_rule_resv';
6437: Begin
6438: IF (p_log_level_rec.statement_level) then
6439: fa_debug_pkg.add(l_calling_fn, 'p_asset_type_rec.asset_type', p_asset_type_rec.asset_type, p_log_level_rec);
6440: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.bonus_rule', p_asset_fin_rec.bonus_rule, p_log_level_rec);
6441: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.group_asset_id', p_asset_fin_rec.group_asset_id, p_log_level_rec);
6442: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec);
6443: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec.bonus_deprn_reserve', p_asset_deprn_rec.bonus_deprn_reserve, p_log_level_rec);
6444: END IF;

Line 6441: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.group_asset_id', p_asset_fin_rec.group_asset_id, p_log_level_rec);

6437: Begin
6438: IF (p_log_level_rec.statement_level) then
6439: fa_debug_pkg.add(l_calling_fn, 'p_asset_type_rec.asset_type', p_asset_type_rec.asset_type, p_log_level_rec);
6440: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.bonus_rule', p_asset_fin_rec.bonus_rule, p_log_level_rec);
6441: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.group_asset_id', p_asset_fin_rec.group_asset_id, p_log_level_rec);
6442: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec);
6443: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec.bonus_deprn_reserve', p_asset_deprn_rec.bonus_deprn_reserve, p_log_level_rec);
6444: END IF;
6445:

Line 6442: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec);

6438: IF (p_log_level_rec.statement_level) then
6439: fa_debug_pkg.add(l_calling_fn, 'p_asset_type_rec.asset_type', p_asset_type_rec.asset_type, p_log_level_rec);
6440: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.bonus_rule', p_asset_fin_rec.bonus_rule, p_log_level_rec);
6441: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.group_asset_id', p_asset_fin_rec.group_asset_id, p_log_level_rec);
6442: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec);
6443: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec.bonus_deprn_reserve', p_asset_deprn_rec.bonus_deprn_reserve, p_log_level_rec);
6444: END IF;
6445:
6446: -- No bonus rule for group asset

Line 6443: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec.bonus_deprn_reserve', p_asset_deprn_rec.bonus_deprn_reserve, p_log_level_rec);

6439: fa_debug_pkg.add(l_calling_fn, 'p_asset_type_rec.asset_type', p_asset_type_rec.asset_type, p_log_level_rec);
6440: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.bonus_rule', p_asset_fin_rec.bonus_rule, p_log_level_rec);
6441: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.group_asset_id', p_asset_fin_rec.group_asset_id, p_log_level_rec);
6442: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec);
6443: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec.bonus_deprn_reserve', p_asset_deprn_rec.bonus_deprn_reserve, p_log_level_rec);
6444: END IF;
6445:
6446: -- No bonus rule for group asset
6447: if (nvl(p_asset_fin_rec.bonus_rule,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR ) then

Line 6579: fa_debug_pkg.add(l_calling_fn, 'p_asset_type_rec.asset_type', p_asset_type_rec.asset_type, p_log_level_rec);

6575: l_deprn_resv number ;
6576: Begin
6577:
6578: IF (p_log_level_rec.statement_level) then
6579: fa_debug_pkg.add(l_calling_fn, 'p_asset_type_rec.asset_type', p_asset_type_rec.asset_type, p_log_level_rec);
6580: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.deprn_method_code',
6581: p_asset_fin_rec_old.deprn_method_code, p_log_level_rec);
6582: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.group_asset_id',
6583: p_asset_fin_rec_old.group_asset_id, p_log_level_rec);

Line 6580: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.deprn_method_code',

6576: Begin
6577:
6578: IF (p_log_level_rec.statement_level) then
6579: fa_debug_pkg.add(l_calling_fn, 'p_asset_type_rec.asset_type', p_asset_type_rec.asset_type, p_log_level_rec);
6580: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.deprn_method_code',
6581: p_asset_fin_rec_old.deprn_method_code, p_log_level_rec);
6582: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.group_asset_id',
6583: p_asset_fin_rec_old.group_asset_id, p_log_level_rec);
6584: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code',

Line 6582: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.group_asset_id',

6578: IF (p_log_level_rec.statement_level) then
6579: fa_debug_pkg.add(l_calling_fn, 'p_asset_type_rec.asset_type', p_asset_type_rec.asset_type, p_log_level_rec);
6580: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.deprn_method_code',
6581: p_asset_fin_rec_old.deprn_method_code, p_log_level_rec);
6582: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.group_asset_id',
6583: p_asset_fin_rec_old.group_asset_id, p_log_level_rec);
6584: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code',
6585: p_asset_fin_rec.deprn_method_code, p_log_level_rec);
6586: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.book_class',

Line 6584: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code',

6580: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.deprn_method_code',
6581: p_asset_fin_rec_old.deprn_method_code, p_log_level_rec);
6582: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.group_asset_id',
6583: p_asset_fin_rec_old.group_asset_id, p_log_level_rec);
6584: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code',
6585: p_asset_fin_rec.deprn_method_code, p_log_level_rec);
6586: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.book_class',
6587: fa_cache_pkg.fazcbc_record.book_class, p_log_level_rec);
6588: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.period_of_addition',

Line 6586: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.book_class',

6582: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.group_asset_id',
6583: p_asset_fin_rec_old.group_asset_id, p_log_level_rec);
6584: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code',
6585: p_asset_fin_rec.deprn_method_code, p_log_level_rec);
6586: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.book_class',
6587: fa_cache_pkg.fazcbc_record.book_class, p_log_level_rec);
6588: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.period_of_addition',
6589: p_asset_hdr_rec.period_of_addition, p_log_level_rec);
6590: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',

Line 6588: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.period_of_addition',

6584: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code',
6585: p_asset_fin_rec.deprn_method_code, p_log_level_rec);
6586: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.book_class',
6587: fa_cache_pkg.fazcbc_record.book_class, p_log_level_rec);
6588: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.period_of_addition',
6589: p_asset_hdr_rec.period_of_addition, p_log_level_rec);
6590: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',
6591: fa_cache_pkg.fazcdrd_record.rule_name, p_log_level_rec);
6592: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.rate_source_rule',

Line 6590: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',

6586: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.book_class',
6587: fa_cache_pkg.fazcbc_record.book_class, p_log_level_rec);
6588: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.period_of_addition',
6589: p_asset_hdr_rec.period_of_addition, p_log_level_rec);
6590: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',
6591: fa_cache_pkg.fazcdrd_record.rule_name, p_log_level_rec);
6592: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.rate_source_rule',
6593: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec);
6594: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.deprn_basis_rule',

Line 6592: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.rate_source_rule',

6588: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.period_of_addition',
6589: p_asset_hdr_rec.period_of_addition, p_log_level_rec);
6590: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',
6591: fa_cache_pkg.fazcdrd_record.rule_name, p_log_level_rec);
6592: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.rate_source_rule',
6593: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec);
6594: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.deprn_basis_rule',
6595: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec);
6596: END IF;

Line 6594: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.deprn_basis_rule',

6590: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcdrd_record.rule_name',
6591: fa_cache_pkg.fazcdrd_record.rule_name, p_log_level_rec);
6592: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.rate_source_rule',
6593: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec);
6594: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazccmt_record.deprn_basis_rule',
6595: fa_cache_pkg.fazccmt_record.rate_source_rule, p_log_level_rec);
6596: END IF;
6597:
6598: if p_asset_fin_rec_old.deprn_method_code is not null then

Line 6628: fa_debug_pkg.add(l_calling_fn, 'l_old_rate_source_rule', l_old_rate_source_rule, p_log_level_rec);

6624: close group_method_details;
6625: end if;
6626:
6627: IF (p_log_level_rec.statement_level) then
6628: fa_debug_pkg.add(l_calling_fn, 'l_old_rate_source_rule', l_old_rate_source_rule, p_log_level_rec);
6629: fa_debug_pkg.add(l_calling_fn, 'l_old_deprn_basis_rule', l_old_deprn_basis_rule, p_log_level_rec);
6630: fa_debug_pkg.add(l_calling_fn, 'l_rate_source_rule', l_rate_source_rule, p_log_level_rec);
6631: fa_debug_pkg.add(l_calling_fn, 'l_deprn_basis_rule', l_deprn_basis_rule, p_log_level_rec);
6632: fa_debug_pkg.add(l_calling_fn, 'l_corp_rate_source_rule', l_corp_rate_source_rule, p_log_level_rec);

Line 6629: fa_debug_pkg.add(l_calling_fn, 'l_old_deprn_basis_rule', l_old_deprn_basis_rule, p_log_level_rec);

6625: end if;
6626:
6627: IF (p_log_level_rec.statement_level) then
6628: fa_debug_pkg.add(l_calling_fn, 'l_old_rate_source_rule', l_old_rate_source_rule, p_log_level_rec);
6629: fa_debug_pkg.add(l_calling_fn, 'l_old_deprn_basis_rule', l_old_deprn_basis_rule, p_log_level_rec);
6630: fa_debug_pkg.add(l_calling_fn, 'l_rate_source_rule', l_rate_source_rule, p_log_level_rec);
6631: fa_debug_pkg.add(l_calling_fn, 'l_deprn_basis_rule', l_deprn_basis_rule, p_log_level_rec);
6632: fa_debug_pkg.add(l_calling_fn, 'l_corp_rate_source_rule', l_corp_rate_source_rule, p_log_level_rec);
6633: fa_debug_pkg.add(l_calling_fn, 'l_corp_deprn_basis_rule', l_corp_deprn_basis_rule, p_log_level_rec);

Line 6630: fa_debug_pkg.add(l_calling_fn, 'l_rate_source_rule', l_rate_source_rule, p_log_level_rec);

6626:
6627: IF (p_log_level_rec.statement_level) then
6628: fa_debug_pkg.add(l_calling_fn, 'l_old_rate_source_rule', l_old_rate_source_rule, p_log_level_rec);
6629: fa_debug_pkg.add(l_calling_fn, 'l_old_deprn_basis_rule', l_old_deprn_basis_rule, p_log_level_rec);
6630: fa_debug_pkg.add(l_calling_fn, 'l_rate_source_rule', l_rate_source_rule, p_log_level_rec);
6631: fa_debug_pkg.add(l_calling_fn, 'l_deprn_basis_rule', l_deprn_basis_rule, p_log_level_rec);
6632: fa_debug_pkg.add(l_calling_fn, 'l_corp_rate_source_rule', l_corp_rate_source_rule, p_log_level_rec);
6633: fa_debug_pkg.add(l_calling_fn, 'l_corp_deprn_basis_rule', l_corp_deprn_basis_rule, p_log_level_rec);
6634: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_rate_source_rule', l_old_grp_rate_source_rule, p_log_level_rec);

Line 6631: fa_debug_pkg.add(l_calling_fn, 'l_deprn_basis_rule', l_deprn_basis_rule, p_log_level_rec);

6627: IF (p_log_level_rec.statement_level) then
6628: fa_debug_pkg.add(l_calling_fn, 'l_old_rate_source_rule', l_old_rate_source_rule, p_log_level_rec);
6629: fa_debug_pkg.add(l_calling_fn, 'l_old_deprn_basis_rule', l_old_deprn_basis_rule, p_log_level_rec);
6630: fa_debug_pkg.add(l_calling_fn, 'l_rate_source_rule', l_rate_source_rule, p_log_level_rec);
6631: fa_debug_pkg.add(l_calling_fn, 'l_deprn_basis_rule', l_deprn_basis_rule, p_log_level_rec);
6632: fa_debug_pkg.add(l_calling_fn, 'l_corp_rate_source_rule', l_corp_rate_source_rule, p_log_level_rec);
6633: fa_debug_pkg.add(l_calling_fn, 'l_corp_deprn_basis_rule', l_corp_deprn_basis_rule, p_log_level_rec);
6634: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_rate_source_rule', l_old_grp_rate_source_rule, p_log_level_rec);
6635: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_deprn_basis_rule', l_old_grp_deprn_basis_rule, p_log_level_rec);

Line 6632: fa_debug_pkg.add(l_calling_fn, 'l_corp_rate_source_rule', l_corp_rate_source_rule, p_log_level_rec);

6628: fa_debug_pkg.add(l_calling_fn, 'l_old_rate_source_rule', l_old_rate_source_rule, p_log_level_rec);
6629: fa_debug_pkg.add(l_calling_fn, 'l_old_deprn_basis_rule', l_old_deprn_basis_rule, p_log_level_rec);
6630: fa_debug_pkg.add(l_calling_fn, 'l_rate_source_rule', l_rate_source_rule, p_log_level_rec);
6631: fa_debug_pkg.add(l_calling_fn, 'l_deprn_basis_rule', l_deprn_basis_rule, p_log_level_rec);
6632: fa_debug_pkg.add(l_calling_fn, 'l_corp_rate_source_rule', l_corp_rate_source_rule, p_log_level_rec);
6633: fa_debug_pkg.add(l_calling_fn, 'l_corp_deprn_basis_rule', l_corp_deprn_basis_rule, p_log_level_rec);
6634: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_rate_source_rule', l_old_grp_rate_source_rule, p_log_level_rec);
6635: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_deprn_basis_rule', l_old_grp_deprn_basis_rule, p_log_level_rec);
6636: fa_debug_pkg.add(l_calling_fn, 'l_grp_rate_source_rule', l_grp_rate_source_rule, p_log_level_rec);

Line 6633: fa_debug_pkg.add(l_calling_fn, 'l_corp_deprn_basis_rule', l_corp_deprn_basis_rule, p_log_level_rec);

6629: fa_debug_pkg.add(l_calling_fn, 'l_old_deprn_basis_rule', l_old_deprn_basis_rule, p_log_level_rec);
6630: fa_debug_pkg.add(l_calling_fn, 'l_rate_source_rule', l_rate_source_rule, p_log_level_rec);
6631: fa_debug_pkg.add(l_calling_fn, 'l_deprn_basis_rule', l_deprn_basis_rule, p_log_level_rec);
6632: fa_debug_pkg.add(l_calling_fn, 'l_corp_rate_source_rule', l_corp_rate_source_rule, p_log_level_rec);
6633: fa_debug_pkg.add(l_calling_fn, 'l_corp_deprn_basis_rule', l_corp_deprn_basis_rule, p_log_level_rec);
6634: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_rate_source_rule', l_old_grp_rate_source_rule, p_log_level_rec);
6635: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_deprn_basis_rule', l_old_grp_deprn_basis_rule, p_log_level_rec);
6636: fa_debug_pkg.add(l_calling_fn, 'l_grp_rate_source_rule', l_grp_rate_source_rule, p_log_level_rec);
6637: fa_debug_pkg.add(l_calling_fn, 'l_grp_deprn_basis_rule', l_grp_deprn_basis_rule, p_log_level_rec);

Line 6634: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_rate_source_rule', l_old_grp_rate_source_rule, p_log_level_rec);

6630: fa_debug_pkg.add(l_calling_fn, 'l_rate_source_rule', l_rate_source_rule, p_log_level_rec);
6631: fa_debug_pkg.add(l_calling_fn, 'l_deprn_basis_rule', l_deprn_basis_rule, p_log_level_rec);
6632: fa_debug_pkg.add(l_calling_fn, 'l_corp_rate_source_rule', l_corp_rate_source_rule, p_log_level_rec);
6633: fa_debug_pkg.add(l_calling_fn, 'l_corp_deprn_basis_rule', l_corp_deprn_basis_rule, p_log_level_rec);
6634: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_rate_source_rule', l_old_grp_rate_source_rule, p_log_level_rec);
6635: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_deprn_basis_rule', l_old_grp_deprn_basis_rule, p_log_level_rec);
6636: fa_debug_pkg.add(l_calling_fn, 'l_grp_rate_source_rule', l_grp_rate_source_rule, p_log_level_rec);
6637: fa_debug_pkg.add(l_calling_fn, 'l_grp_deprn_basis_rule', l_grp_deprn_basis_rule, p_log_level_rec);
6638: END IF;

Line 6635: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_deprn_basis_rule', l_old_grp_deprn_basis_rule, p_log_level_rec);

6631: fa_debug_pkg.add(l_calling_fn, 'l_deprn_basis_rule', l_deprn_basis_rule, p_log_level_rec);
6632: fa_debug_pkg.add(l_calling_fn, 'l_corp_rate_source_rule', l_corp_rate_source_rule, p_log_level_rec);
6633: fa_debug_pkg.add(l_calling_fn, 'l_corp_deprn_basis_rule', l_corp_deprn_basis_rule, p_log_level_rec);
6634: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_rate_source_rule', l_old_grp_rate_source_rule, p_log_level_rec);
6635: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_deprn_basis_rule', l_old_grp_deprn_basis_rule, p_log_level_rec);
6636: fa_debug_pkg.add(l_calling_fn, 'l_grp_rate_source_rule', l_grp_rate_source_rule, p_log_level_rec);
6637: fa_debug_pkg.add(l_calling_fn, 'l_grp_deprn_basis_rule', l_grp_deprn_basis_rule, p_log_level_rec);
6638: END IF;
6639:

Line 6636: fa_debug_pkg.add(l_calling_fn, 'l_grp_rate_source_rule', l_grp_rate_source_rule, p_log_level_rec);

6632: fa_debug_pkg.add(l_calling_fn, 'l_corp_rate_source_rule', l_corp_rate_source_rule, p_log_level_rec);
6633: fa_debug_pkg.add(l_calling_fn, 'l_corp_deprn_basis_rule', l_corp_deprn_basis_rule, p_log_level_rec);
6634: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_rate_source_rule', l_old_grp_rate_source_rule, p_log_level_rec);
6635: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_deprn_basis_rule', l_old_grp_deprn_basis_rule, p_log_level_rec);
6636: fa_debug_pkg.add(l_calling_fn, 'l_grp_rate_source_rule', l_grp_rate_source_rule, p_log_level_rec);
6637: fa_debug_pkg.add(l_calling_fn, 'l_grp_deprn_basis_rule', l_grp_deprn_basis_rule, p_log_level_rec);
6638: END IF;
6639:
6640: -- Do not allow group or member with UOP method (other than ENERGY)

Line 6637: fa_debug_pkg.add(l_calling_fn, 'l_grp_deprn_basis_rule', l_grp_deprn_basis_rule, p_log_level_rec);

6633: fa_debug_pkg.add(l_calling_fn, 'l_corp_deprn_basis_rule', l_corp_deprn_basis_rule, p_log_level_rec);
6634: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_rate_source_rule', l_old_grp_rate_source_rule, p_log_level_rec);
6635: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_deprn_basis_rule', l_old_grp_deprn_basis_rule, p_log_level_rec);
6636: fa_debug_pkg.add(l_calling_fn, 'l_grp_rate_source_rule', l_grp_rate_source_rule, p_log_level_rec);
6637: fa_debug_pkg.add(l_calling_fn, 'l_grp_deprn_basis_rule', l_grp_deprn_basis_rule, p_log_level_rec);
6638: END IF;
6639:
6640: -- Do not allow group or member with UOP method (other than ENERGY)
6641: if (l_rate_source_rule = 'PRODUCTION'

Line 7101: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);

7097: l_group_asset_id := p_asset_fin_rec.group_asset_id;
7098: l_old_group_asset_id := p_asset_fin_rec_old.group_asset_id;
7099:
7100: if (p_log_level_rec.statement_level) then
7101: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
7102: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.group_asset_id', p_asset_fin_rec.group_asset_id, p_log_level_rec => p_log_level_rec);
7103: end if;
7104:
7105: open c_method_details(nvl(p_asset_fin_rec.deprn_method_code,p_asset_fin_rec_old.deprn_method_code));

Line 7102: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.group_asset_id', p_asset_fin_rec.group_asset_id, p_log_level_rec => p_log_level_rec);

7098: l_old_group_asset_id := p_asset_fin_rec_old.group_asset_id;
7099:
7100: if (p_log_level_rec.statement_level) then
7101: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
7102: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.group_asset_id', p_asset_fin_rec.group_asset_id, p_log_level_rec => p_log_level_rec);
7103: end if;
7104:
7105: open c_method_details(nvl(p_asset_fin_rec.deprn_method_code,p_asset_fin_rec_old.deprn_method_code));
7106: fetch c_method_details into l_method_det;

Line 7129: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);

7125: fetch c_grp_details into l_old_grp_fin_det;
7126: close c_grp_details;
7127: end if;
7128: if (p_log_level_rec.statement_level) then
7129: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
7130: fa_debug_pkg.add(l_calling_fn, 'p_trans_rec.transaction_type_code', p_trans_rec.transaction_type_code, p_log_level_rec => p_log_level_rec);
7131: fa_debug_pkg.add(l_calling_fn, 'l_cost', l_cost, p_log_level_rec => p_log_level_rec);
7132: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve', l_deprn_reserve, p_log_level_rec => p_log_level_rec);
7133: fa_debug_pkg.add(l_calling_fn, 'l_adjusted_cost', l_adjusted_cost, p_log_level_rec => p_log_level_rec);

Line 7130: fa_debug_pkg.add(l_calling_fn, 'p_trans_rec.transaction_type_code', p_trans_rec.transaction_type_code, p_log_level_rec => p_log_level_rec);

7126: close c_grp_details;
7127: end if;
7128: if (p_log_level_rec.statement_level) then
7129: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
7130: fa_debug_pkg.add(l_calling_fn, 'p_trans_rec.transaction_type_code', p_trans_rec.transaction_type_code, p_log_level_rec => p_log_level_rec);
7131: fa_debug_pkg.add(l_calling_fn, 'l_cost', l_cost, p_log_level_rec => p_log_level_rec);
7132: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve', l_deprn_reserve, p_log_level_rec => p_log_level_rec);
7133: fa_debug_pkg.add(l_calling_fn, 'l_adjusted_cost', l_adjusted_cost, p_log_level_rec => p_log_level_rec);
7134: fa_debug_pkg.add(l_calling_fn, 'l_group_asset_id', l_group_asset_id, p_log_level_rec => p_log_level_rec);

Line 7131: fa_debug_pkg.add(l_calling_fn, 'l_cost', l_cost, p_log_level_rec => p_log_level_rec);

7127: end if;
7128: if (p_log_level_rec.statement_level) then
7129: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
7130: fa_debug_pkg.add(l_calling_fn, 'p_trans_rec.transaction_type_code', p_trans_rec.transaction_type_code, p_log_level_rec => p_log_level_rec);
7131: fa_debug_pkg.add(l_calling_fn, 'l_cost', l_cost, p_log_level_rec => p_log_level_rec);
7132: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve', l_deprn_reserve, p_log_level_rec => p_log_level_rec);
7133: fa_debug_pkg.add(l_calling_fn, 'l_adjusted_cost', l_adjusted_cost, p_log_level_rec => p_log_level_rec);
7134: fa_debug_pkg.add(l_calling_fn, 'l_group_asset_id', l_group_asset_id, p_log_level_rec => p_log_level_rec);
7135: fa_debug_pkg.add(l_calling_fn, 'l_old_group_asset_id', l_old_group_asset_id, p_log_level_rec => p_log_level_rec);

Line 7132: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve', l_deprn_reserve, p_log_level_rec => p_log_level_rec);

7128: if (p_log_level_rec.statement_level) then
7129: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
7130: fa_debug_pkg.add(l_calling_fn, 'p_trans_rec.transaction_type_code', p_trans_rec.transaction_type_code, p_log_level_rec => p_log_level_rec);
7131: fa_debug_pkg.add(l_calling_fn, 'l_cost', l_cost, p_log_level_rec => p_log_level_rec);
7132: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve', l_deprn_reserve, p_log_level_rec => p_log_level_rec);
7133: fa_debug_pkg.add(l_calling_fn, 'l_adjusted_cost', l_adjusted_cost, p_log_level_rec => p_log_level_rec);
7134: fa_debug_pkg.add(l_calling_fn, 'l_group_asset_id', l_group_asset_id, p_log_level_rec => p_log_level_rec);
7135: fa_debug_pkg.add(l_calling_fn, 'l_old_group_asset_id', l_old_group_asset_id, p_log_level_rec => p_log_level_rec);
7136: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.tracking_method', p_asset_fin_rec.tracking_method, p_log_level_rec => p_log_level_rec);

Line 7133: fa_debug_pkg.add(l_calling_fn, 'l_adjusted_cost', l_adjusted_cost, p_log_level_rec => p_log_level_rec);

7129: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec);
7130: fa_debug_pkg.add(l_calling_fn, 'p_trans_rec.transaction_type_code', p_trans_rec.transaction_type_code, p_log_level_rec => p_log_level_rec);
7131: fa_debug_pkg.add(l_calling_fn, 'l_cost', l_cost, p_log_level_rec => p_log_level_rec);
7132: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve', l_deprn_reserve, p_log_level_rec => p_log_level_rec);
7133: fa_debug_pkg.add(l_calling_fn, 'l_adjusted_cost', l_adjusted_cost, p_log_level_rec => p_log_level_rec);
7134: fa_debug_pkg.add(l_calling_fn, 'l_group_asset_id', l_group_asset_id, p_log_level_rec => p_log_level_rec);
7135: fa_debug_pkg.add(l_calling_fn, 'l_old_group_asset_id', l_old_group_asset_id, p_log_level_rec => p_log_level_rec);
7136: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.tracking_method', p_asset_fin_rec.tracking_method, p_log_level_rec => p_log_level_rec);
7137: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec => p_log_level_rec);

Line 7134: fa_debug_pkg.add(l_calling_fn, 'l_group_asset_id', l_group_asset_id, p_log_level_rec => p_log_level_rec);

7130: fa_debug_pkg.add(l_calling_fn, 'p_trans_rec.transaction_type_code', p_trans_rec.transaction_type_code, p_log_level_rec => p_log_level_rec);
7131: fa_debug_pkg.add(l_calling_fn, 'l_cost', l_cost, p_log_level_rec => p_log_level_rec);
7132: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve', l_deprn_reserve, p_log_level_rec => p_log_level_rec);
7133: fa_debug_pkg.add(l_calling_fn, 'l_adjusted_cost', l_adjusted_cost, p_log_level_rec => p_log_level_rec);
7134: fa_debug_pkg.add(l_calling_fn, 'l_group_asset_id', l_group_asset_id, p_log_level_rec => p_log_level_rec);
7135: fa_debug_pkg.add(l_calling_fn, 'l_old_group_asset_id', l_old_group_asset_id, p_log_level_rec => p_log_level_rec);
7136: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.tracking_method', p_asset_fin_rec.tracking_method, p_log_level_rec => p_log_level_rec);
7137: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7138: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code', p_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);

Line 7135: fa_debug_pkg.add(l_calling_fn, 'l_old_group_asset_id', l_old_group_asset_id, p_log_level_rec => p_log_level_rec);

7131: fa_debug_pkg.add(l_calling_fn, 'l_cost', l_cost, p_log_level_rec => p_log_level_rec);
7132: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve', l_deprn_reserve, p_log_level_rec => p_log_level_rec);
7133: fa_debug_pkg.add(l_calling_fn, 'l_adjusted_cost', l_adjusted_cost, p_log_level_rec => p_log_level_rec);
7134: fa_debug_pkg.add(l_calling_fn, 'l_group_asset_id', l_group_asset_id, p_log_level_rec => p_log_level_rec);
7135: fa_debug_pkg.add(l_calling_fn, 'l_old_group_asset_id', l_old_group_asset_id, p_log_level_rec => p_log_level_rec);
7136: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.tracking_method', p_asset_fin_rec.tracking_method, p_log_level_rec => p_log_level_rec);
7137: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7138: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code', p_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);
7139: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.deprn_method_code', p_asset_fin_rec_old.deprn_method_code, p_log_level_rec => p_log_level_rec);

Line 7136: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.tracking_method', p_asset_fin_rec.tracking_method, p_log_level_rec => p_log_level_rec);

7132: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve', l_deprn_reserve, p_log_level_rec => p_log_level_rec);
7133: fa_debug_pkg.add(l_calling_fn, 'l_adjusted_cost', l_adjusted_cost, p_log_level_rec => p_log_level_rec);
7134: fa_debug_pkg.add(l_calling_fn, 'l_group_asset_id', l_group_asset_id, p_log_level_rec => p_log_level_rec);
7135: fa_debug_pkg.add(l_calling_fn, 'l_old_group_asset_id', l_old_group_asset_id, p_log_level_rec => p_log_level_rec);
7136: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.tracking_method', p_asset_fin_rec.tracking_method, p_log_level_rec => p_log_level_rec);
7137: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7138: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code', p_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);
7139: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.deprn_method_code', p_asset_fin_rec_old.deprn_method_code, p_log_level_rec => p_log_level_rec);
7140: fa_debug_pkg.add(l_calling_fn, 'l_method_det.rule_name', l_method_det.rule_name, p_log_level_rec => p_log_level_rec);

Line 7137: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec => p_log_level_rec);

7133: fa_debug_pkg.add(l_calling_fn, 'l_adjusted_cost', l_adjusted_cost, p_log_level_rec => p_log_level_rec);
7134: fa_debug_pkg.add(l_calling_fn, 'l_group_asset_id', l_group_asset_id, p_log_level_rec => p_log_level_rec);
7135: fa_debug_pkg.add(l_calling_fn, 'l_old_group_asset_id', l_old_group_asset_id, p_log_level_rec => p_log_level_rec);
7136: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.tracking_method', p_asset_fin_rec.tracking_method, p_log_level_rec => p_log_level_rec);
7137: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7138: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code', p_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);
7139: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.deprn_method_code', p_asset_fin_rec_old.deprn_method_code, p_log_level_rec => p_log_level_rec);
7140: fa_debug_pkg.add(l_calling_fn, 'l_method_det.rule_name', l_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7141: fa_debug_pkg.add(l_calling_fn, 'l_method_det.deprn_basis_rule', l_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);

Line 7138: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code', p_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);

7134: fa_debug_pkg.add(l_calling_fn, 'l_group_asset_id', l_group_asset_id, p_log_level_rec => p_log_level_rec);
7135: fa_debug_pkg.add(l_calling_fn, 'l_old_group_asset_id', l_old_group_asset_id, p_log_level_rec => p_log_level_rec);
7136: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.tracking_method', p_asset_fin_rec.tracking_method, p_log_level_rec => p_log_level_rec);
7137: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7138: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code', p_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);
7139: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.deprn_method_code', p_asset_fin_rec_old.deprn_method_code, p_log_level_rec => p_log_level_rec);
7140: fa_debug_pkg.add(l_calling_fn, 'l_method_det.rule_name', l_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7141: fa_debug_pkg.add(l_calling_fn, 'l_method_det.deprn_basis_rule', l_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7142: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.rule_name', l_old_method_det.rule_name, p_log_level_rec => p_log_level_rec);

Line 7139: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.deprn_method_code', p_asset_fin_rec_old.deprn_method_code, p_log_level_rec => p_log_level_rec);

7135: fa_debug_pkg.add(l_calling_fn, 'l_old_group_asset_id', l_old_group_asset_id, p_log_level_rec => p_log_level_rec);
7136: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.tracking_method', p_asset_fin_rec.tracking_method, p_log_level_rec => p_log_level_rec);
7137: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7138: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code', p_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);
7139: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.deprn_method_code', p_asset_fin_rec_old.deprn_method_code, p_log_level_rec => p_log_level_rec);
7140: fa_debug_pkg.add(l_calling_fn, 'l_method_det.rule_name', l_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7141: fa_debug_pkg.add(l_calling_fn, 'l_method_det.deprn_basis_rule', l_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7142: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.rule_name', l_old_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7143: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.deprn_basis_rule', l_old_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);

Line 7140: fa_debug_pkg.add(l_calling_fn, 'l_method_det.rule_name', l_method_det.rule_name, p_log_level_rec => p_log_level_rec);

7136: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.tracking_method', p_asset_fin_rec.tracking_method, p_log_level_rec => p_log_level_rec);
7137: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7138: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code', p_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);
7139: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.deprn_method_code', p_asset_fin_rec_old.deprn_method_code, p_log_level_rec => p_log_level_rec);
7140: fa_debug_pkg.add(l_calling_fn, 'l_method_det.rule_name', l_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7141: fa_debug_pkg.add(l_calling_fn, 'l_method_det.deprn_basis_rule', l_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7142: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.rule_name', l_old_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7143: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.deprn_basis_rule', l_old_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7144: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.rule_name', l_grp_method_det.rule_name, p_log_level_rec => p_log_level_rec);

Line 7141: fa_debug_pkg.add(l_calling_fn, 'l_method_det.deprn_basis_rule', l_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);

7137: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.member_rollup_flag', p_asset_fin_rec.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7138: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code', p_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);
7139: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.deprn_method_code', p_asset_fin_rec_old.deprn_method_code, p_log_level_rec => p_log_level_rec);
7140: fa_debug_pkg.add(l_calling_fn, 'l_method_det.rule_name', l_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7141: fa_debug_pkg.add(l_calling_fn, 'l_method_det.deprn_basis_rule', l_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7142: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.rule_name', l_old_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7143: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.deprn_basis_rule', l_old_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7144: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.rule_name', l_grp_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7145: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.deprn_basis_rule', l_grp_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);

Line 7142: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.rule_name', l_old_method_det.rule_name, p_log_level_rec => p_log_level_rec);

7138: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec.deprn_method_code', p_asset_fin_rec.deprn_method_code, p_log_level_rec => p_log_level_rec);
7139: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.deprn_method_code', p_asset_fin_rec_old.deprn_method_code, p_log_level_rec => p_log_level_rec);
7140: fa_debug_pkg.add(l_calling_fn, 'l_method_det.rule_name', l_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7141: fa_debug_pkg.add(l_calling_fn, 'l_method_det.deprn_basis_rule', l_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7142: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.rule_name', l_old_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7143: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.deprn_basis_rule', l_old_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7144: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.rule_name', l_grp_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7145: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.deprn_basis_rule', l_grp_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7146: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.tracking_method', l_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);

Line 7143: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.deprn_basis_rule', l_old_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);

7139: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.deprn_method_code', p_asset_fin_rec_old.deprn_method_code, p_log_level_rec => p_log_level_rec);
7140: fa_debug_pkg.add(l_calling_fn, 'l_method_det.rule_name', l_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7141: fa_debug_pkg.add(l_calling_fn, 'l_method_det.deprn_basis_rule', l_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7142: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.rule_name', l_old_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7143: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.deprn_basis_rule', l_old_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7144: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.rule_name', l_grp_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7145: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.deprn_basis_rule', l_grp_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7146: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.tracking_method', l_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);
7147: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.member_rollup_flag', l_grp_fin_det.member_rollup_flag, p_log_level_rec => p_log_level_rec);

Line 7144: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.rule_name', l_grp_method_det.rule_name, p_log_level_rec => p_log_level_rec);

7140: fa_debug_pkg.add(l_calling_fn, 'l_method_det.rule_name', l_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7141: fa_debug_pkg.add(l_calling_fn, 'l_method_det.deprn_basis_rule', l_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7142: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.rule_name', l_old_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7143: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.deprn_basis_rule', l_old_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7144: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.rule_name', l_grp_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7145: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.deprn_basis_rule', l_grp_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7146: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.tracking_method', l_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);
7147: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.member_rollup_flag', l_grp_fin_det.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7148: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_fin_det.tracking_metho', l_old_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);

Line 7145: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.deprn_basis_rule', l_grp_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);

7141: fa_debug_pkg.add(l_calling_fn, 'l_method_det.deprn_basis_rule', l_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7142: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.rule_name', l_old_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7143: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.deprn_basis_rule', l_old_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7144: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.rule_name', l_grp_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7145: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.deprn_basis_rule', l_grp_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7146: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.tracking_method', l_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);
7147: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.member_rollup_flag', l_grp_fin_det.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7148: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_fin_det.tracking_metho', l_old_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);
7149: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_fin_det.member_rollup_flag', l_old_grp_fin_det.member_rollup_flag, p_log_level_rec => p_log_level_rec);

Line 7146: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.tracking_method', l_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);

7142: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.rule_name', l_old_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7143: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.deprn_basis_rule', l_old_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7144: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.rule_name', l_grp_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7145: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.deprn_basis_rule', l_grp_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7146: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.tracking_method', l_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);
7147: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.member_rollup_flag', l_grp_fin_det.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7148: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_fin_det.tracking_metho', l_old_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);
7149: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_fin_det.member_rollup_flag', l_old_grp_fin_det.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7150: end if;

Line 7147: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.member_rollup_flag', l_grp_fin_det.member_rollup_flag, p_log_level_rec => p_log_level_rec);

7143: fa_debug_pkg.add(l_calling_fn, 'l_old_method_det.deprn_basis_rule', l_old_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7144: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.rule_name', l_grp_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7145: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.deprn_basis_rule', l_grp_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7146: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.tracking_method', l_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);
7147: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.member_rollup_flag', l_grp_fin_det.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7148: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_fin_det.tracking_metho', l_old_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);
7149: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_fin_det.member_rollup_flag', l_old_grp_fin_det.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7150: end if;
7151:

Line 7148: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_fin_det.tracking_metho', l_old_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);

7144: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.rule_name', l_grp_method_det.rule_name, p_log_level_rec => p_log_level_rec);
7145: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.deprn_basis_rule', l_grp_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7146: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.tracking_method', l_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);
7147: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.member_rollup_flag', l_grp_fin_det.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7148: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_fin_det.tracking_metho', l_old_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);
7149: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_fin_det.member_rollup_flag', l_old_grp_fin_det.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7150: end if;
7151:
7152: /* Adjusted_cost related */

Line 7149: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_fin_det.member_rollup_flag', l_old_grp_fin_det.member_rollup_flag, p_log_level_rec => p_log_level_rec);

7145: fa_debug_pkg.add(l_calling_fn, 'l_grp_method_det.deprn_basis_rule', l_grp_method_det.deprn_basis_rule, p_log_level_rec => p_log_level_rec);
7146: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.tracking_method', l_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);
7147: fa_debug_pkg.add(l_calling_fn, 'l_grp_fin_det.member_rollup_flag', l_grp_fin_det.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7148: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_fin_det.tracking_metho', l_old_grp_fin_det.tracking_method, p_log_level_rec => p_log_level_rec);
7149: fa_debug_pkg.add(l_calling_fn, 'l_old_grp_fin_det.member_rollup_flag', l_old_grp_fin_det.member_rollup_flag, p_log_level_rec => p_log_level_rec);
7150: end if;
7151:
7152: /* Adjusted_cost related */
7153: if(nvl(l_adjusted_cost,0) <> 0) and (p_trans_rec.transaction_key = 'BA') then