[Home] [Help]
326:
327: -- validate new group info
328: if (px_asset_fin_rec_new.group_asset_id is not null) then
329: -- verify the asset exist in the book already
330: if not FA_ASSET_VAL_PVT.validate_group_asset
331: (p_group_asset_id => px_asset_fin_rec_new.group_asset_id,
332: p_book_type_code => p_asset_hdr_rec.book_type_code,
333: p_asset_type => p_asset_type_rec.asset_type,
334: p_log_level_rec => p_log_level_rec
387: else
388: l_old_dpis := p_asset_fin_rec_old.date_placed_in_service;
389: end if;
390:
391: if not fa_asset_val_pvt.validate_dpis
392: (p_transaction_type_code => px_trans_rec.transaction_type_code,
393: p_book_type_code => p_asset_hdr_rec.book_type_code,
394: p_date_placed_in_service =>
395: px_asset_fin_rec_new.date_placed_in_service,
407: raise calc_err;
408: end if;
409:
410: if (px_asset_fin_rec_new.group_asset_id is not null) then
411: if not fa_asset_val_pvt.validate_member_dpis
412: (p_book_type_code => p_asset_hdr_rec.book_type_code,
413: p_date_placed_in_service =>
414: px_asset_fin_rec_new.date_placed_in_service,
415: p_group_asset_Id =>
419: raise calc_err;
420: end if;
421: end if;
422:
423: if not fa_asset_val_pvt.validate_depreciate_flag
424: (p_depreciate_flag => px_asset_fin_rec_new.depreciate_flag,
425: p_calling_fn => l_calling_fn ,
426: p_log_level_rec => p_log_level_rec
427: ) then
512: end if; -- (px_asset_fin_rec_new.group_asset_id is not null)
513:
514: else -- Asset type is Group
515: --HH Validate disabled_flag
516: if not FA_ASSET_VAL_PVT.validate_disabled_flag
517: (p_group_asset_id => px_asset_fin_rec_new.group_asset_id,
518: p_book_type_code => p_asset_hdr_rec.book_type_code,
519: p_old_flag => p_asset_fin_rec_old.disabled_flag,
520: p_new_flag => px_asset_fin_rec_new.disabled_flag,
538: 'p_asset_fin_rec_adj.over_depreciate_option',
539: p_asset_fin_rec_adj.over_depreciate_option);
540: end if;
541:
542: if not FA_ASSET_VAL_PVT.validate_super_group (
543: p_book_type_code => p_asset_hdr_rec.book_type_code,
544: p_old_super_group_id => p_asset_fin_rec_old.super_group_id,
545: p_new_super_group_id => px_asset_fin_rec_new.super_group_id,
546: p_calling_fn => l_calling_fn,
546: p_calling_fn => l_calling_fn,
547: p_log_level_rec => p_log_level_rec) then
548:
549: if (p_log_level_rec.statement_level) then
550: fa_debug_pkg.add(l_calling_fn, 'Error calling function', 'FA_ASSET_VAL_PVT.validate_super_group');
551: end if;
552:
553: raise calc_err;
554: end if;
572: else
573: l_temp_deprn_reserve := to_number(null);
574: end if;
575:
576: if not fa_asset_val_pvt.validate_over_depreciate
577: (p_asset_hdr_rec => p_asset_hdr_rec,
578: p_asset_type => p_asset_type_rec.asset_type,
579: p_over_depreciate_option => px_asset_fin_rec_new.over_depreciate_option,
580: p_adjusted_recoverable_cost => px_asset_fin_rec_new.adjusted_recoverable_cost,
591:
592: end if; --p_asset_type_rec.asset_type
593:
594: -- Check to prevent prior period trx with Energy UOP
595: if not FA_ASSET_VAL_PVT.validate_egy_prod_date (
596: p_calendar_period_start_date => p_period_rec.calendar_period_open_date,
597: p_transaction_date => nvl(px_trans_rec.amortization_start_date,
598: px_trans_rec.transaction_date_entered),
599: p_transaction_key => px_trans_rec.transaction_key,
602: p_calling_fn => l_calling_fn,
603: p_log_level_rec => p_log_level_rec) then
604: if (p_log_level_rec.statement_level) then
605: fa_debug_pkg.add(l_calling_fn, 'Failed calling',
606: 'FA_ASSET_VAL_PVT.validate_egy_prod_date');
607: end if;
608: raise calc_err;
609: end if;
610:
617: -- Check adjustment (since old rec is null for regular addition)
618: -- For adjustment, this is to prevent a method change out of a
619: -- polish rule as well as a regular adjustment.
620: if (p_asset_fin_rec_old.deprn_method_code is not null) then
621: if not FA_ASSET_VAL_PVT.validate_polish (
622: p_transaction_type_code => 'ADJUSTMENT',
623: p_method_code => p_asset_fin_rec_old.deprn_method_code,
624: p_life_in_months => p_asset_fin_rec_old.life_in_months,
625: p_asset_type => p_asset_type_rec.asset_type,
634: end if;
635:
636: -- For adjustment, this is to prevent a method change into a
637: -- polish rule as well as a regular adjustment.
638: if not FA_ASSET_VAL_PVT.validate_polish (
639: p_transaction_type_code => 'ADJUSTMENT',
640: p_method_code =>
641: px_asset_fin_rec_new.deprn_method_code,
642: p_life_in_months => px_asset_fin_rec_new.life_in_months,
650: raise calc_err;
651: end if;
652: else
653: -- Validate addition since old rec is null.
654: if not FA_ASSET_VAL_PVT.validate_polish (
655: p_transaction_type_code => 'ADDITION',
656: p_method_code =>
657: px_asset_fin_rec_new.deprn_method_code,
658: p_life_in_months => px_asset_fin_rec_new.life_in_months,
701: -- no longer calling validate_rec_cost_reserve here
702: -- as it is handled by the following check for non-deprn-basis
703: -- assets... also changed passed value to be adj_rec_cost - BMR
704:
705: if not fa_asset_val_pvt.validate_adj_rec_cost
706: (p_adjusted_recoverable_cost => px_asset_fin_rec_new.adjusted_recoverable_cost,
707: p_deprn_reserve => px_asset_deprn_rec_new.deprn_reserve,
708: p_calling_fn => l_calling_fn,
709: p_log_level_rec => p_log_level_rec
710: ) then
711: raise calc_err;
712: end if;
713:
714: if not fa_asset_val_pvt.validate_ytd_reserve
715: (p_book => p_asset_hdr_rec.book_type_code,
716: p_date_placed_in_service => px_asset_fin_rec_new.date_placed_in_service,
717: p_asset_type => p_asset_type_rec.asset_type,
718: p_ytd_deprn => px_asset_deprn_rec_new.ytd_deprn,
837: -- NOCOPY and IN parameters for amort start date;
838: l_old_amortization_start_date := l_amortization_start_date;
839:
840:
841: if not FA_ASSET_VAL_PVT.validate_amort_start_date
842: (p_transaction_type_code => px_trans_rec.transaction_type_code,
843: p_asset_id => p_asset_hdr_rec.asset_id,
844: p_book_type_code => p_asset_hdr_rec.book_type_code,
845: p_date_placed_in_service => px_asset_fin_rec_new.date_placed_in_service,
869: if (px_trans_rec.transaction_subtype = 'AMORTIZED') and
870: (px_trans_rec.transaction_type_code = 'ADJUSTMENT' or
871: px_trans_rec.transaction_type_code = 'CIP ADJUSTMENT') then
872:
873: if not FA_ASSET_VAL_PVT.validate_cost_change (
874: p_asset_id => p_asset_hdr_rec.asset_id,
875: p_group_asset_id => px_asset_fin_rec_new.group_asset_id, --hh
876: p_book_type_code => p_asset_hdr_rec.book_type_code,
877: p_asset_type => p_asset_type_rec.asset_type,
2038:
2039: if (p_asset_hdr_rec.period_of_addition = 'Y') then
2040:
2041: -- Bug:5154035
2042: if FA_ASSET_VAL_PVT.validate_reval_exists (p_asset_hdr_rec.book_type_code,
2043: p_asset_hdr_rec.asset_id,
2044: 'FA_ASSET_CALC_PVT.calc_new_amounts') then
2045: if (nvl(p_asset_deprn_rec_adj.bonus_ytd_deprn, 0) <> 0 or
2046: nvl(p_asset_deprn_rec_adj.bonus_deprn_reserve, 0) <> 0 or
3403: fa_debug_pkg.add(l_calling_fn, 'l_lim', l_lim);
3404: fa_debug_pkg.add(l_calling_fn, 'l_new_life', l_new_life);
3405: end if;
3406:
3407: if not fa_asset_val_pvt.validate_life
3408: (p_deprn_method => px_asset_fin_rec.deprn_method_code,
3409: p_rate_source_rule => l_rate_source_rule,
3410: p_life_in_months => l_cat_bk_lim,
3411: p_lim => l_lim,
3815: p_trans_rec.transaction_type_code <> 'CIP ADDITION' and
3816: p_trans_rec.transaction_type_code <> 'GROUP ADDITION' and
3817: (p_asset_fin_rec_old.deprn_method_code <>
3818: p_asset_fin_rec_adj.deprn_method_code)) then
3819: if fa_asset_val_pvt.validate_unplanned_exists
3820: (p_book => p_asset_hdr_rec.book_type_code,
3821: p_asset_id => p_asset_hdr_rec.asset_id,
3822: p_log_level_rec => p_log_level_rec) then
3823: fa_srvr_msg.add_message(
3986: end if;
3987: end if;
3988:
3989: -- verify STY information is valid
3990: if not fa_asset_val_pvt.validate_short_tax_year
3991: (p_book_type_code => p_asset_hdr_rec.book_type_code,
3992: p_transaction_type_code => p_trans_rec.transaction_type_code,
3993: p_asset_type => p_asset_type_rec.asset_type,
3994: p_short_fiscal_year_flag => px_asset_fin_rec_new.short_fiscal_year_flag,
4132:
4133: end if;
4134:
4135: -- +++++ Over Depreciate +++++
4136: -- Validation moved to fa_asset_val_pvt.validate_over_depreciate
4137:
4138: -- +++++ Reduction Flags +++++
4139: if (px_asset_fin_rec_new.reduction_rate is null) then
4140: px_asset_fin_rec_new.reduce_addition_flag := null;