[Home] [Help]
437:
438: -- validate new group info
439: if (px_asset_fin_rec_new.group_asset_id is not null) then
440: -- verify the asset exist in the book already
441: if not FA_ASSET_VAL_PVT.validate_group_asset
442: (p_group_asset_id => px_asset_fin_rec_new.group_asset_id,
443: p_book_type_code => p_asset_hdr_rec.book_type_code,
444: p_asset_type => p_asset_type_rec.asset_type
445: , p_log_level_rec => p_log_level_rec) then
497: (g_release <> 11) and
498: ((p_asset_type_rec.asset_type <> 'GROUP') or
499: ((p_asset_type_rec.asset_type = 'GROUP') and (nvl(px_trans_rec.transaction_key, 'XX') = 'GJ'))) then
500:
501: if not FA_ASSET_VAL_PVT.validate_ltd_deprn_change
502: (p_book_type_code => p_asset_hdr_rec.book_type_code,
503: p_asset_Id => p_asset_hdr_rec.asset_id,
504: p_calling_fn => l_calling_fn,
505: p_log_level_rec => p_log_level_rec) then
526: else
527: l_old_dpis := p_asset_fin_rec_old.date_placed_in_service;
528: end if;
529:
530: if not fa_asset_val_pvt.validate_dpis
531: (p_transaction_type_code => px_trans_rec.transaction_type_code,
532: p_book_type_code => p_asset_hdr_rec.book_type_code,
533: p_date_placed_in_service =>
534: px_asset_fin_rec_new.date_placed_in_service,
545: raise calc_err;
546: end if;
547:
548: if (px_asset_fin_rec_new.group_asset_id is not null) then
549: if not fa_asset_val_pvt.validate_member_dpis
550: (p_book_type_code => p_asset_hdr_rec.book_type_code,
551: p_date_placed_in_service =>
552: px_asset_fin_rec_new.date_placed_in_service,
553: p_group_asset_Id =>
556: raise calc_err;
557: end if;
558: end if;
559:
560: if not fa_asset_val_pvt.validate_depreciate_flag
561: (p_depreciate_flag => px_asset_fin_rec_new.depreciate_flag,
562: p_calling_fn => l_calling_fn
563: , p_log_level_rec => p_log_level_rec) then
564: raise calc_err;
646: end if; -- (px_asset_fin_rec_new.group_asset_id is not null)
647:
648: else -- Asset type is Group
649: --HH Validate disabled_flag
650: if not FA_ASSET_VAL_PVT.validate_disabled_flag
651: (p_group_asset_id => px_asset_fin_rec_new.group_asset_id,
652: p_book_type_code => p_asset_hdr_rec.book_type_code,
653: p_old_flag => p_asset_fin_rec_old.disabled_flag,
654: p_new_flag => px_asset_fin_rec_new.disabled_flag
665: 'p_asset_fin_rec_adj.over_depreciate_option',
666: p_asset_fin_rec_adj.over_depreciate_option, p_log_level_rec => p_log_level_rec);
667: end if;
668:
669: if not FA_ASSET_VAL_PVT.validate_super_group (
670: p_book_type_code => p_asset_hdr_rec.book_type_code,
671: p_old_super_group_id => p_asset_fin_rec_old.super_group_id,
672: p_new_super_group_id => px_asset_fin_rec_new.super_group_id,
673: p_calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec) then
672: p_new_super_group_id => px_asset_fin_rec_new.super_group_id,
673: p_calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec) then
674:
675: if (p_log_level_rec.statement_level) then
676: fa_debug_pkg.add(l_calling_fn, 'Error calling function', 'FA_ASSET_VAL_PVT.validate_super_group', p_log_level_rec => p_log_level_rec);
677: end if;
678:
679: raise calc_err;
680: end if;
700: end if;
701: if not (nvl(p_group_reclass_options_rec.group_reclass_type,'XXX') = 'CALC' and
702: px_asset_fin_rec_new.tracking_method is null and
703: nvl(p_asset_fin_rec_old.group_asset_id, -99) = nvl(px_asset_fin_rec_new.group_asset_id, -99)) then
704: if not fa_asset_val_pvt.validate_over_depreciate
705: (p_asset_hdr_rec => p_asset_hdr_rec,
706: p_asset_type => p_asset_type_rec.asset_type,
707: p_over_depreciate_option => px_asset_fin_rec_new.over_depreciate_option,
708: p_adjusted_recoverable_cost => px_asset_fin_rec_new.adjusted_recoverable_cost,
719: end if; --p_asset_type_rec.asset_type
720:
721: /* bug#10094653 - validating unit_of_measure */
722: if fa_cache_pkg.fazccmt_record.rate_source_rule = 'PRODUCTION' then
723: if not fa_asset_val_pvt.validate_unit_of_measure(p_unit_of_measure => px_asset_fin_rec_new.unit_of_measure,
724: p_calling_fn => l_calling_fn,
725: p_log_level_rec => p_log_level_rec) then
726: if (p_log_level_rec.statement_level) then
727: fa_debug_pkg.add(l_calling_fn, 'Failed calling',
724: p_calling_fn => l_calling_fn,
725: p_log_level_rec => p_log_level_rec) then
726: if (p_log_level_rec.statement_level) then
727: fa_debug_pkg.add(l_calling_fn, 'Failed calling',
728: 'FA_ASSET_VAL_PVT.validate_unit_of_measure', p_log_level_rec => p_log_level_rec);
729: end if;
730: raise calc_err;
731: end if;
732: end if;
731: end if;
732: end if;
733:
734: -- Bug 9916378
735: if not FA_ASSET_VAL_PVT.validate_uop_method
736: (p_asset_hdr_rec => p_asset_hdr_rec,
737: p_asset_type_rec => p_asset_type_rec,
738: p_asset_fin_rec => px_asset_fin_rec_new,
739: p_asset_fin_rec_old => p_asset_fin_rec_old,
742: raise calc_err;
743: end if;
744:
745: -- Bug 9916378
746: if not FA_ASSET_VAL_PVT.validate_prev_period_amort
747: (p_asset_hdr_rec => p_asset_hdr_rec,
748: p_trans_rec => px_trans_rec,
749: p_period_rec => p_period_rec,
750: p_asset_retire_rec => null,
752: raise calc_err;
753: end if;
754:
755: -- Check to prevent prior period trx with Energy UOP
756: if not FA_ASSET_VAL_PVT.validate_egy_prod_date (
757: p_calendar_period_start_date => p_period_rec.calendar_period_open_date,
758: p_transaction_date => nvl(px_trans_rec.amortization_start_date,
759: px_trans_rec.transaction_date_entered),
760: p_transaction_key => px_trans_rec.transaction_key,
763: p_calling_fn => l_calling_fn,
764: p_log_level_rec => p_log_level_rec) then
765: if (p_log_level_rec.statement_level) then
766: fa_debug_pkg.add(l_calling_fn, 'Failed calling',
767: 'FA_ASSET_VAL_PVT.validate_egy_prod_date', p_log_level_rec => p_log_level_rec);
768: end if;
769: raise calc_err;
770: end if;
771:
768: end if;
769: raise calc_err;
770: end if;
771:
772: if not FA_ASSET_VAL_PVT.validate_bonus_rule_resv
773: (p_asset_hdr_rec => p_asset_hdr_rec,
774: p_asset_desc_rec => p_asset_desc_rec,
775: p_asset_type_rec => p_asset_type_rec,
776: p_asset_fin_rec => px_asset_fin_rec_new,
778: p_calling_fn => l_calling_fn,
779: p_log_level_rec => p_log_level_rec) then
780: if (p_log_level_rec.statement_level) then
781: fa_debug_pkg.add(l_calling_fn, 'Failed calling',
782: 'FA_ASSET_VAL_PVT.validate_bonus_rule_resv', p_log_level_rec => p_log_level_rec);
783: end if;
784: raise calc_err;
785: end if;
786:
793: -- Check adjustment (since old rec is null for regular addition)
794: -- For adjustment, this is to prevent a method change out of a
795: -- polish rule as well as a regular adjustment.
796: if (p_asset_fin_rec_old.deprn_method_code is not null) then
797: if not FA_ASSET_VAL_PVT.validate_polish (
798: p_transaction_type_code => 'ADJUSTMENT',
799: p_method_code => p_asset_fin_rec_old.deprn_method_code,
800: p_life_in_months => p_asset_fin_rec_old.life_in_months,
801: p_asset_type => p_asset_type_rec.asset_type,
809: end if;
810:
811: -- For adjustment, this is to prevent a method change into a
812: -- polish rule as well as a regular adjustment.
813: if not FA_ASSET_VAL_PVT.validate_polish (
814: p_transaction_type_code => 'ADJUSTMENT',
815: p_method_code =>
816: px_asset_fin_rec_new.deprn_method_code,
817: p_life_in_months => px_asset_fin_rec_new.life_in_months,
825: raise calc_err;
826: end if;
827: else
828: -- Validate addition since old rec is null.
829: if not FA_ASSET_VAL_PVT.validate_polish (
830: p_transaction_type_code => 'ADDITION',
831: p_method_code =>
832: px_asset_fin_rec_new.deprn_method_code,
833: p_life_in_months => px_asset_fin_rec_new.life_in_months,
855: -- Bug 12593804 : Do not allow extended asset addition which is fully reserved in current period
856: if ((nvl(px_asset_fin_rec_new.extended_deprn_flag,'N') = 'Y') and
857: (nvl(p_asset_fin_rec_old.extended_deprn_flag,'D') in ('D','N'))) then
858:
859: if not FA_ASSET_VAL_PVT.validate_extending_asset
860: (p_asset_hdr_rec => p_asset_hdr_rec,
861: p_asset_fin_rec_old => p_asset_fin_rec_old,
862: p_asset_fin_rec_adj => p_asset_fin_rec_adj,
863: p_asset_type_rec => p_asset_type_rec,
907: end if;
908:
909: IF NOT (l_reset_extend_flag) THEN
910:
911: if not fa_asset_val_pvt.validate_adj_rec_cost
912: (p_adjusted_recoverable_cost => px_asset_fin_rec_new.adjusted_recoverable_cost,
913: p_deprn_reserve => px_asset_deprn_rec_new.deprn_reserve,
914: p_calling_fn => l_calling_fn
915: , p_log_level_rec => p_log_level_rec) then
919:
920: ---------End OF Addition by Satish Byreddy As part of Reverse Catch up calculation Bug No. 6951549
921:
922: /*Bug#9682863 - Modified the parameters - instead of individual value passing records. */
923: if not fa_asset_val_pvt.validate_ytd_reserve
924: (p_asset_hdr_rec => p_asset_hdr_rec,
925: p_asset_type_rec => p_asset_type_rec,
926: p_asset_fin_rec_new => px_asset_fin_rec_new,
927: p_asset_deprn_rec_new => px_asset_deprn_rec_new,
977:
978: -- Bug 8722521 : Validation for Japan methods during Tax upload
979: if (nvl(px_trans_rec.calling_interface,'X') = 'FATAXUP') and
980: (nvl(fnd_profile.value('FA_JAPAN_TAX_REFORMS'),'N') = 'Y') then
981: if not FA_ASSET_VAL_PVT.validate_jp_taxupl (
982: p_trans_rec => px_trans_rec,
983: p_asset_type_rec => p_asset_type_rec,
984: p_asset_fin_rec => px_asset_fin_rec_new,
985: p_asset_hdr_rec => p_asset_hdr_rec,
1038: -- This event type calculates adjusted_cost
1039: -- at the period of DPIS.
1040: ----------------------------------------------
1041: /*13513616 --No need to call if CGU is changed ,set old values */
1042: l_financial_info_changed := FA_ASSET_VAL_PVT.is_financial_info_changed(p_asset_fin_rec_old => p_asset_fin_rec_old,
1043: p_asset_fin_rec_adj => p_asset_fin_rec_adj,
1044: px_asset_fin_rec_new => px_asset_fin_rec_new,
1045: p_log_level_rec => p_log_level_rec);
1046: /*bug#16426081 starts*/
1048: px_trans_rec.transaction_key := 'BA';
1049: px_asset_fin_rec_new.adjusted_cost := p_asset_fin_rec_adj.adjusted_cost;
1050: l_financial_info_changed := false;
1051: end if;
1052: if not FA_ASSET_VAL_PVT.validate_cca_rules
1053: (p_trans_rec => px_trans_rec,
1054: p_asset_hdr_rec => p_asset_hdr_rec,
1055: p_asset_type_rec => p_asset_type_rec,
1056: p_asset_fin_rec => px_asset_fin_rec_new,
1112: -- NOCOPY and IN parameters for amort start date;
1113: l_old_amortization_start_date := l_amortization_start_date;
1114:
1115:
1116: if not FA_ASSET_VAL_PVT.validate_amort_start_date
1117: (p_transaction_type_code => px_trans_rec.transaction_type_code,
1118: p_asset_id => p_asset_hdr_rec.asset_id,
1119: p_book_type_code => p_asset_hdr_rec.book_type_code,
1120: p_date_placed_in_service => px_asset_fin_rec_new.date_placed_in_service,
1145: if (px_trans_rec.transaction_subtype = 'AMORTIZED') and
1146: (px_trans_rec.transaction_type_code = 'ADJUSTMENT' or
1147: px_trans_rec.transaction_type_code = 'CIP ADJUSTMENT') then
1148:
1149: if not FA_ASSET_VAL_PVT.validate_cost_change (
1150: p_asset_id => p_asset_hdr_rec.asset_id,
1151: p_group_asset_id => px_asset_fin_rec_new.group_asset_id, --hh
1152: p_book_type_code => p_asset_hdr_rec.book_type_code,
1153: p_asset_type => p_asset_type_rec.asset_type,
2221: else
2222: l_nbv_for_sal := nvl(px_asset_fin_rec_new.cost,0);
2223: end if;
2224:
2225: if not FA_ASSET_VAL_PVT.validate_salvage_value
2226: ( p_salvage_value => px_asset_fin_rec_new.salvage_value,
2227: p_nbv => l_nbv_for_sal,
2228: p_calling_fn => l_calling_fn,
2229: p_log_level_rec => p_log_level_rec) then
2288: --bug 8765988/8649223 ( Adding this validation to prevent -ve NBV in POA via adjustement)
2289: if (p_asset_hdr_rec.period_of_addition = 'Y' and px_trans_rec.transaction_type_code = 'ADJUSTMENT' and
2290: nvl(px_asset_fin_rec_new.ALLOCATE_TO_FULLY_RSV_FLAG,'N') = 'N'
2291: ) then
2292: if not fa_asset_val_pvt.validate_adj_rec_cost
2293: (p_adjusted_recoverable_cost => px_asset_fin_rec_new.adjusted_recoverable_cost,
2294: p_deprn_reserve => px_asset_deprn_rec_new.deprn_reserve,
2295: p_calling_fn => l_calling_fn,
2296: p_log_level_rec => p_log_level_rec
2301: /*Bug#9488077/9130653 - added following condition */
2302: if (p_asset_deprn_rec_adj.deprn_reserve <> 0 OR p_asset_deprn_rec_adj.ytd_deprn <> 0) then
2303: --bug 8785230 Missing Validation for POA and +ve deprn reserve
2304: /*Bug#9682863 - Modified the parameters - instead of individual value passing records. */
2305: if not fa_asset_val_pvt.validate_ytd_reserve
2306: (p_asset_hdr_rec => p_asset_hdr_rec,
2307: p_asset_type_rec => p_asset_type_rec,
2308: p_asset_fin_rec_new => px_asset_fin_rec_new,
2309: p_asset_deprn_rec_new => px_asset_deprn_rec_new,
4163: fa_debug_pkg.add(l_calling_fn, 'l_lim', l_lim, p_log_level_rec => p_log_level_rec);
4164: fa_debug_pkg.add(l_calling_fn, 'l_new_life', l_new_life, p_log_level_rec => p_log_level_rec);
4165: end if;
4166:
4167: if not fa_asset_val_pvt.validate_life
4168: (p_deprn_method => px_asset_fin_rec.deprn_method_code,
4169: p_rate_source_rule => l_rate_source_rule,
4170: p_life_in_months => l_cat_bk_lim,
4171: p_lim => l_lim,
4575: p_trans_rec.transaction_type_code <> 'CIP ADDITION' and
4576: p_trans_rec.transaction_type_code <> 'GROUP ADDITION' and
4577: (p_asset_fin_rec_old.deprn_method_code <>
4578: p_asset_fin_rec_adj.deprn_method_code)) then
4579: if fa_asset_val_pvt.validate_unplanned_exists
4580: (p_book => p_asset_hdr_rec.book_type_code,
4581: p_asset_id => p_asset_hdr_rec.asset_id, p_log_level_rec => p_log_level_rec) then
4582: fa_srvr_msg.add_message(
4583: calling_fn => 'l_calling_fn',
4755: end if;
4756: end if;
4757:
4758: -- verify STY information is valid
4759: if not fa_asset_val_pvt.validate_short_tax_year
4760: (p_book_type_code => p_asset_hdr_rec.book_type_code,
4761: p_transaction_type_code => p_trans_rec.transaction_type_code,
4762: p_asset_type => p_asset_type_rec.asset_type,
4763: p_short_fiscal_year_flag => px_asset_fin_rec_new.short_fiscal_year_flag,
4898:
4899: end if;
4900:
4901: -- +++++ Over Depreciate +++++
4902: -- Validation moved to fa_asset_val_pvt.validate_over_depreciate
4903:
4904: -- +++++ Reduction Flags +++++
4905: if (px_asset_fin_rec_new.reduction_rate is null) then
4906: px_asset_fin_rec_new.reduce_addition_flag := null;