APPS.FA_ASSET_VAL_PVT dependencies on FA_DEBUG_PKG

Line 1079: fa_debug_pkg.add('fa_asset_val_pvt.validate_dpis', 'Error', p_date_placed_in_service, p_log_level_rec);

1075: --Bug# 7198185 - Removed modified condition to allow backdated addition for energy
1076: if (p_date_placed_in_service <> nvl(p_old_date_placed_in_service, p_date_placed_in_service) ) then
1077:
1078: if (p_log_level_rec.statement_level) then
1079: fa_debug_pkg.add('fa_asset_val_pvt.validate_dpis', 'Error', p_date_placed_in_service, p_log_level_rec);
1080: end if;
1081:
1082: fa_srvr_msg.add_message(
1083: calling_fn => 'fa_asset_val_pvt.validate_dpis',

Line 1629: fa_debug_pkg.add(l_calling_fn, 'Error', p_date_placed_in_service);

1625: p_transaction_key <> 'MS') then
1626:
1627: if (p_amortization_start_date < p_period_rec.calendar_period_open_date) then
1628: if (p_log_level_rec.statement_level) then
1629: fa_debug_pkg.add(l_calling_fn, 'Error', p_date_placed_in_service);
1630: end if;
1631: fa_srvr_msg.add_message(
1632: calling_fn => 'fa_asset_val_pvt.validate_dpis',
1633: name => 'FA_CURRENT_DATE_ONLY');

Line 1771: fa_debug_pkg.add(l_calling_fn, 'calling', 'fazccmt');

1767:
1768: BEGIN
1769:
1770: if (p_log_level_rec.statement_level) then
1771: fa_debug_pkg.add(l_calling_fn, 'calling', 'fazccmt');
1772: end if;
1773:
1774: if not fa_cache_pkg.fazccmt
1775: (X_method => p_deprn_method,

Line 1780: fa_debug_pkg.add(l_calling_fn, 'after fazccmt', 'method not found');

1776: X_life => p_lim,
1777: p_log_level_rec => p_log_level_rec) then -- method not found
1778:
1779: if (p_log_level_rec.statement_level) then
1780: fa_debug_pkg.add(l_calling_fn, 'after fazccmt', 'method not found');
1781: end if;
1782:
1783: if (p_rate_source_rule = 'TABLE') then
1784:

Line 1830: fa_debug_pkg.add(l_calling_fn, 'inserting', 'new method');

1826: CLOSE METHOD_DEF;
1827: end if;
1828:
1829: if (p_log_level_rec.statement_level) then
1830: fa_debug_pkg.add(l_calling_fn, 'inserting', 'new method');
1831: end if;
1832:
1833: FA_METHODS_PKG.Insert_Row(
1834: X_Rowid => l_rowid,

Line 1910: fa_debug_pkg.add(l_calling_fn, 'after fazccmt', 'method found');

1906: end if;
1907:
1908: else
1909: if (p_log_level_rec.statement_level) then
1910: fa_debug_pkg.add(l_calling_fn, 'after fazccmt', 'method found');
1911: end if;
1912: end if;
1913:
1914: return true;

Line 2965: fa_debug_pkg.add('val api', 'group', p_group_asset_id);

2961:
2962: BEGIN
2963:
2964: if (p_log_level_rec.statement_level) then
2965: fa_debug_pkg.add('val api', 'group', p_group_asset_id);
2966: fa_debug_pkg.add('val api', 'book', p_book_type_code);
2967: end if;
2968:
2969: --

Line 2966: fa_debug_pkg.add('val api', 'book', p_book_type_code);

2962: BEGIN
2963:
2964: if (p_log_level_rec.statement_level) then
2965: fa_debug_pkg.add('val api', 'group', p_group_asset_id);
2966: fa_debug_pkg.add('val api', 'book', p_book_type_code);
2967: end if;
2968:
2969: --
2970: -- Following sql is too expensive

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

3359: (nvl(p_over_depreciate_option, fa_std_types.FA_OVER_DEPR_NO) =
3360: fa_std_types.FA_OVER_DEPR_DEPRN) and
3361: (NVL(fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,'N') = 'Y')) then
3362: if (p_log_level_rec.statement_level) then
3363: fa_debug_pkg.add(l_calling_fn, 'Member cost sign','can be changed',p_log_level_rec);
3364: fa_debug_pkg.add(l_calling_fn, 'over depreciate option',p_over_depreciate_option,p_log_level_rec);
3365: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id,p_log_level_rec);
3366: end if;
3367: else

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

3360: fa_std_types.FA_OVER_DEPR_DEPRN) and
3361: (NVL(fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,'N') = 'Y')) then
3362: if (p_log_level_rec.statement_level) then
3363: fa_debug_pkg.add(l_calling_fn, 'Member cost sign','can be changed',p_log_level_rec);
3364: fa_debug_pkg.add(l_calling_fn, 'over depreciate option',p_over_depreciate_option,p_log_level_rec);
3365: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id,p_log_level_rec);
3366: end if;
3367: else
3368: if (p_log_level_rec.statement_level) then

Line 3365: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id,p_log_level_rec);

3361: (NVL(fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,'N') = 'Y')) then
3362: if (p_log_level_rec.statement_level) then
3363: fa_debug_pkg.add(l_calling_fn, 'Member cost sign','can be changed',p_log_level_rec);
3364: fa_debug_pkg.add(l_calling_fn, 'over depreciate option',p_over_depreciate_option,p_log_level_rec);
3365: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id,p_log_level_rec);
3366: end if;
3367: else
3368: if (p_log_level_rec.statement_level) then
3369: fa_debug_pkg.add(l_calling_fn, 'validating cost and salvage','',p_log_level_rec);

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

3365: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id,p_log_level_rec);
3366: end if;
3367: else
3368: if (p_log_level_rec.statement_level) then
3369: fa_debug_pkg.add(l_calling_fn, 'validating cost and salvage','',p_log_level_rec);
3370: fa_debug_pkg.add(l_calling_fn, 'sign change flag',
3371: fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,p_log_level_rec);
3372: fa_debug_pkg.add(l_calling_fn, 'over depr option',p_over_depreciate_option,p_log_level_rec);
3373: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id,p_log_level_rec);

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

3366: end if;
3367: else
3368: if (p_log_level_rec.statement_level) then
3369: fa_debug_pkg.add(l_calling_fn, 'validating cost and salvage','',p_log_level_rec);
3370: fa_debug_pkg.add(l_calling_fn, 'sign change flag',
3371: fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,p_log_level_rec);
3372: fa_debug_pkg.add(l_calling_fn, 'over depr option',p_over_depreciate_option,p_log_level_rec);
3373: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id,p_log_level_rec);
3374: end if;

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

3368: if (p_log_level_rec.statement_level) then
3369: fa_debug_pkg.add(l_calling_fn, 'validating cost and salvage','',p_log_level_rec);
3370: fa_debug_pkg.add(l_calling_fn, 'sign change flag',
3371: fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,p_log_level_rec);
3372: fa_debug_pkg.add(l_calling_fn, 'over depr option',p_over_depreciate_option,p_log_level_rec);
3373: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id,p_log_level_rec);
3374: end if;
3375:
3376: -- Added following if condition for bugfix# 5131759

Line 3373: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id,p_log_level_rec);

3369: fa_debug_pkg.add(l_calling_fn, 'validating cost and salvage','',p_log_level_rec);
3370: fa_debug_pkg.add(l_calling_fn, 'sign change flag',
3371: fa_cache_pkg.fazcbc_record.ALLOW_COST_SIGN_CHANGE_FLAG,p_log_level_rec);
3372: fa_debug_pkg.add(l_calling_fn, 'over depr option',p_over_depreciate_option,p_log_level_rec);
3373: fa_debug_pkg.add(l_calling_fn, 'group_asset_id',p_group_asset_id,p_log_level_rec);
3374: end if;
3375:
3376: -- Added following if condition for bugfix# 5131759
3377: if (p_mrc_sob_type_code = 'R') then

Line 3391: fa_debug_pkg.add(l_calling_fn, 'Delta Cost', 'Invalid',p_log_level_rec);

3387: if (p_cost_adj <> 0) and
3388: (sign(nvl(l_cost, 0) + p_cost_adj) <> 0) and
3389: (sign(nvl(l_cost, 0) + p_cost_adj) <> sign(p_cost)) then
3390: if (p_log_level_rec.statement_level) then
3391: fa_debug_pkg.add(l_calling_fn, 'Delta Cost', 'Invalid',p_log_level_rec);
3392: end if;
3393: raise val_err;
3394: end if;
3395:

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

3397: (sign(nvl(l_salvage_value, 0) + p_salvage_value_adj) <> 0) and
3398: (sign(nvl(l_salvage_value, 0) + p_salvage_value_adj) <>
3399: sign(p_salvage_value)) then
3400: if (p_log_level_rec.statement_level) then
3401: fa_debug_pkg.add(l_calling_fn, 'Delta Salvage Value', 'Invalid',p_log_level_rec);
3402: end if;
3403: raise val_err;
3404: end if;
3405: end if; --group_asset_id not null...

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

3410: (sign(nvl(l_deprn_limit_amount, 0) + p_deprn_limit_amount_adj) <> 0) and
3411: (sign(nvl(l_deprn_limit_amount, 0) + p_deprn_limit_amount_adj) <>
3412: sign(p_deprn_limit_amount)) then
3413: if (p_log_level_rec.statement_level) then
3414: fa_debug_pkg.add(l_calling_fn, 'Delta Deprn Limit Amount', 'Invalid',p_log_level_rec);
3415: end if;
3416: raise val_err;
3417: end if;
3418:

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

3690:
3691: CLOSE c_check_used;
3692:
3693: if (p_log_level_rec.statement_level) then
3694: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code);
3695: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id);
3696: fa_debug_pkg.add(l_calling_fn, 'This Super group is used', 'TRUE');
3697: end if;
3698:

Line 3695: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id);

3691: CLOSE c_check_used;
3692:
3693: if (p_log_level_rec.statement_level) then
3694: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code);
3695: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id);
3696: fa_debug_pkg.add(l_calling_fn, 'This Super group is used', 'TRUE');
3697: end if;
3698:
3699: fa_srvr_msg.add_message(calling_fn => l_calling_fn,

Line 3696: fa_debug_pkg.add(l_calling_fn, 'This Super group is used', 'TRUE');

3692:
3693: if (p_log_level_rec.statement_level) then
3694: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code);
3695: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id);
3696: fa_debug_pkg.add(l_calling_fn, 'This Super group is used', 'TRUE');
3697: end if;
3698:
3699: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
3700: name => 'FA_SUPER_GROUP_USED');

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

3712:
3713: EXCEPTION
3714: WHEN OTHERS THEN
3715: if (p_log_level_rec.statement_level) then
3716: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code);
3717: fa_debug_pkg.add(l_calling_fn, 'p_old_super_group_id', p_old_super_group_id);
3718: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id);
3719: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
3720: end if;

Line 3717: fa_debug_pkg.add(l_calling_fn, 'p_old_super_group_id', p_old_super_group_id);

3713: EXCEPTION
3714: WHEN OTHERS THEN
3715: if (p_log_level_rec.statement_level) then
3716: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code);
3717: fa_debug_pkg.add(l_calling_fn, 'p_old_super_group_id', p_old_super_group_id);
3718: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id);
3719: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
3720: end if;
3721:

Line 3718: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id);

3714: WHEN OTHERS THEN
3715: if (p_log_level_rec.statement_level) then
3716: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code);
3717: fa_debug_pkg.add(l_calling_fn, 'p_old_super_group_id', p_old_super_group_id);
3718: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id);
3719: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
3720: end if;
3721:
3722: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn );

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

3715: if (p_log_level_rec.statement_level) then
3716: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code);
3717: fa_debug_pkg.add(l_calling_fn, 'p_old_super_group_id', p_old_super_group_id);
3718: fa_debug_pkg.add(l_calling_fn, 'p_new_super_group_id', p_new_super_group_id);
3719: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
3720: end if;
3721:
3722: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn );
3723:

Line 3784: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', 'p_transaction_date');

3780:
3781: BEGIN
3782:
3783: if (p_log_level_rec.statement_level) then
3784: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', 'p_transaction_date');
3785: end if;
3786:
3787: --Bug# 7198185 - deleted condition to allow backdated addition for energy
3788:

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

3786:
3787: --Bug# 7198185 - deleted condition to allow backdated addition for energy
3788:
3789: if (p_log_level_rec.statement_level) then
3790: fa_debug_pkg.add(l_calling_fn, 'End', ' ');
3791: end if;
3792:
3793: return true;
3794:

Line 3798: fa_debug_pkg.add(l_calling_fn, 'p_calendar_period_start_date', p_calendar_period_start_date);

3794:
3795: EXCEPTION
3796: WHEN OTHERS THEN
3797: if (p_log_level_rec.statement_level) then
3798: fa_debug_pkg.add(l_calling_fn, 'p_calendar_period_start_date', p_calendar_period_start_date);
3799: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', p_transaction_date);
3800: fa_debug_pkg.add(l_calling_fn, 'p_rate_source_rule', p_rate_source_rule);
3801: fa_debug_pkg.add(l_calling_fn, 'p_rule_name', p_rule_name);
3802: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);

Line 3799: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', p_transaction_date);

3795: EXCEPTION
3796: WHEN OTHERS THEN
3797: if (p_log_level_rec.statement_level) then
3798: fa_debug_pkg.add(l_calling_fn, 'p_calendar_period_start_date', p_calendar_period_start_date);
3799: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', p_transaction_date);
3800: fa_debug_pkg.add(l_calling_fn, 'p_rate_source_rule', p_rate_source_rule);
3801: fa_debug_pkg.add(l_calling_fn, 'p_rule_name', p_rule_name);
3802: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
3803: end if;

Line 3800: fa_debug_pkg.add(l_calling_fn, 'p_rate_source_rule', p_rate_source_rule);

3796: WHEN OTHERS THEN
3797: if (p_log_level_rec.statement_level) then
3798: fa_debug_pkg.add(l_calling_fn, 'p_calendar_period_start_date', p_calendar_period_start_date);
3799: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', p_transaction_date);
3800: fa_debug_pkg.add(l_calling_fn, 'p_rate_source_rule', p_rate_source_rule);
3801: fa_debug_pkg.add(l_calling_fn, 'p_rule_name', p_rule_name);
3802: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
3803: end if;
3804:

Line 3801: fa_debug_pkg.add(l_calling_fn, 'p_rule_name', p_rule_name);

3797: if (p_log_level_rec.statement_level) then
3798: fa_debug_pkg.add(l_calling_fn, 'p_calendar_period_start_date', p_calendar_period_start_date);
3799: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', p_transaction_date);
3800: fa_debug_pkg.add(l_calling_fn, 'p_rate_source_rule', p_rate_source_rule);
3801: fa_debug_pkg.add(l_calling_fn, 'p_rule_name', p_rule_name);
3802: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
3803: end if;
3804:
3805: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn );

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

3798: fa_debug_pkg.add(l_calling_fn, 'p_calendar_period_start_date', p_calendar_period_start_date);
3799: fa_debug_pkg.add(l_calling_fn, 'p_transaction_date', p_transaction_date);
3800: fa_debug_pkg.add(l_calling_fn, 'p_rate_source_rule', p_rate_source_rule);
3801: fa_debug_pkg.add(l_calling_fn, 'p_rule_name', p_rule_name);
3802: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
3803: end if;
3804:
3805: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn );
3806:

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

3842:
3843: EXCEPTION
3844: WHEN OTHERS THEN
3845: if (p_log_level_rec.statement_level) then
3846: fa_debug_pkg.add(l_calling_fn, 'p_asset_id', p_asset_id);
3847: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code);
3848: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
3849: end if;
3850:

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

3843: EXCEPTION
3844: WHEN OTHERS THEN
3845: if (p_log_level_rec.statement_level) then
3846: fa_debug_pkg.add(l_calling_fn, 'p_asset_id', p_asset_id);
3847: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code);
3848: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
3849: end if;
3850:
3851: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn);

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

3844: WHEN OTHERS THEN
3845: if (p_log_level_rec.statement_level) then
3846: fa_debug_pkg.add(l_calling_fn, 'p_asset_id', p_asset_id);
3847: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code);
3848: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
3849: end if;
3850:
3851: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn);
3852:

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

3866:
3867: BEGIN
3868:
3869: if (p_log_level_rec.statement_level) then
3870: fa_debug_pkg.add(l_calling_fn, 'Enter ', p_asset_hdr_rec.asset_id);
3871: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost);
3872: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.life_in_months', p_asset_fin_rec_adj.life_in_months);
3873: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
3874: p_asset_fin_rec_adj.deprn_method_code);

Line 3871: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost);

3867: BEGIN
3868:
3869: if (p_log_level_rec.statement_level) then
3870: fa_debug_pkg.add(l_calling_fn, 'Enter ', p_asset_hdr_rec.asset_id);
3871: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost);
3872: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.life_in_months', p_asset_fin_rec_adj.life_in_months);
3873: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
3874: p_asset_fin_rec_adj.deprn_method_code);
3875: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.date_placed_in_service',

Line 3872: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.life_in_months', p_asset_fin_rec_adj.life_in_months);

3868:
3869: if (p_log_level_rec.statement_level) then
3870: fa_debug_pkg.add(l_calling_fn, 'Enter ', p_asset_hdr_rec.asset_id);
3871: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost);
3872: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.life_in_months', p_asset_fin_rec_adj.life_in_months);
3873: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
3874: p_asset_fin_rec_adj.deprn_method_code);
3875: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.date_placed_in_service',
3876: p_asset_fin_rec_adj.date_placed_in_service);

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

3869: if (p_log_level_rec.statement_level) then
3870: fa_debug_pkg.add(l_calling_fn, 'Enter ', p_asset_hdr_rec.asset_id);
3871: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost);
3872: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.life_in_months', p_asset_fin_rec_adj.life_in_months);
3873: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
3874: p_asset_fin_rec_adj.deprn_method_code);
3875: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.date_placed_in_service',
3876: p_asset_fin_rec_adj.date_placed_in_service);
3877: end if;

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

3871: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost);
3872: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.life_in_months', p_asset_fin_rec_adj.life_in_months);
3873: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
3874: p_asset_fin_rec_adj.deprn_method_code);
3875: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.date_placed_in_service',
3876: p_asset_fin_rec_adj.date_placed_in_service);
3877: end if;
3878:
3879: if (nvl(p_asset_fin_rec_adj.cost,0) <> 0) then

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

3934: return FALSE;
3935: end if;
3936:
3937: if (p_log_level_rec.statement_level) then
3938: fa_debug_pkg.add(l_calling_fn, 'End', ' ');
3939: end if;
3940:
3941: return true;
3942:

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

3942:
3943: EXCEPTION
3944: WHEN OTHERS THEN
3945: if (p_log_level_rec.statement_level) then
3946: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id);
3947: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost);
3948: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
3949: p_asset_fin_rec_adj.deprn_method_code);
3950: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);

Line 3947: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost);

3943: EXCEPTION
3944: WHEN OTHERS THEN
3945: if (p_log_level_rec.statement_level) then
3946: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id);
3947: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost);
3948: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
3949: p_asset_fin_rec_adj.deprn_method_code);
3950: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
3951: end if;

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

3944: WHEN OTHERS THEN
3945: if (p_log_level_rec.statement_level) then
3946: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id);
3947: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost);
3948: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
3949: p_asset_fin_rec_adj.deprn_method_code);
3950: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
3951: end if;
3952:

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

3946: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id);
3947: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.cost', p_asset_fin_rec_adj.cost);
3948: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_method_code',
3949: p_asset_fin_rec_adj.deprn_method_code);
3950: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
3951: end if;
3952:
3953: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn );
3954:

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

4028:
4029: end if; -- End of SUM loop
4030:
4031: if (p_log_level_rec.statement_level) then
4032: fa_debug_pkg.add(l_calling_fn, 'End', ' ');
4033: end if;
4034:
4035: return TRUE;
4036:

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

4036:
4037: EXCEPTION
4038: WHEN OTHERS THEN
4039: if (p_log_level_rec.statement_level) then
4040: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id);
4041: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.salvage_type', p_asset_fin_rec_adj.salvage_type);
4042: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_limit_type',
4043: p_asset_fin_rec_adj.deprn_limit_type);
4044: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);

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

4037: EXCEPTION
4038: WHEN OTHERS THEN
4039: if (p_log_level_rec.statement_level) then
4040: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id);
4041: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.salvage_type', p_asset_fin_rec_adj.salvage_type);
4042: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_limit_type',
4043: p_asset_fin_rec_adj.deprn_limit_type);
4044: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
4045: end if;

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

4038: WHEN OTHERS THEN
4039: if (p_log_level_rec.statement_level) then
4040: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id);
4041: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.salvage_type', p_asset_fin_rec_adj.salvage_type);
4042: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_limit_type',
4043: p_asset_fin_rec_adj.deprn_limit_type);
4044: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
4045: end if;
4046:

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

4040: fa_debug_pkg.add(l_calling_fn, 'p_asset_hdr_rec.asset_id', p_asset_hdr_rec.asset_id);
4041: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.salvage_type', p_asset_fin_rec_adj.salvage_type);
4042: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.deprn_limit_type',
4043: p_asset_fin_rec_adj.deprn_limit_type);
4044: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION: OTHERS', sqlerrm);
4045: end if;
4046:
4047: fa_srvr_msg.add_sql_error( calling_fn => l_calling_fn );
4048: