[Home] [Help]
193:
194: px_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
195:
196: -- verify the asset exist in the book already
197: if not FA_ASSET_VAL_PVT.validate_asset_book
198: (p_transaction_type_code => 'ADJUSTMENT',
199: p_book_type_code => px_asset_hdr_rec.book_type_code,
200: p_asset_id => px_asset_hdr_rec.asset_id,
201: p_calling_fn => l_calling_fn
225: raise adj_err;
226: END IF;
227:
228: --Verify if impairment has happened in same period
229: if not FA_ASSET_VAL_PVT.validate_impairment_exists
230: (p_asset_id => px_asset_hdr_rec.asset_id,
231: p_book => px_asset_hdr_rec.book_type_code,
232: p_mrc_sob_type_code => l_reporting_flag,
233: p_set_of_books_id => px_asset_hdr_rec.set_of_books_id,
235: raise adj_err;
236: end if;
237: -- end initial MRC validation
238: /*phase5 This function will validate if current transaction is overlapping to any previously done impairment*/
239: /* if not FA_ASSET_VAL_PVT.check_overlapping_impairment(
240: p_trans_rec => px_trans_rec,
241: p_asset_hdr_rec => px_asset_hdr_rec ,
242: p_log_level_rec => g_log_level_rec) then
243:
242: p_log_level_rec => g_log_level_rec) then
243:
244: fa_srvr_msg.add_message
245: (name => 'FA_OVERLAPPING_IMP_NOT_ALLOWED',
246: calling_fn => 'FA_ASSET_VAL_PVT.check_overlapping_impairment'
247: ,p_log_level_rec => g_log_level_rec);
248: raise adj_err;
249: end if;
250: */
367: end if; */
368:
369: -- also check if this is the period of addition - use absolute mode for adjustments
370: -- we will only clear cost outside period of addition
371: if not FA_ASSET_VAL_PVT.validate_period_of_addition
372: (p_asset_id => px_asset_hdr_rec.asset_id,
373: p_book => px_asset_hdr_rec.book_type_code,
374: p_mode => 'ABSOLUTE',
375: px_period_of_addition => px_asset_hdr_rec.period_of_addition, p_log_level_rec => g_log_level_rec) then
378:
379: -- Bug 12612333 : Moved the validation to FAVCALB.pls
380: -- Bug 8471701: Prevent reserve change if any 'B' row distribution is inactive
381: /* if (nvl(p_asset_deprn_rec_adj.deprn_reserve, 0) <> 0) or (nvl(p_asset_deprn_rec_adj.ytd_deprn, 0) <> 0) then
382: if not FA_ASSET_VAL_PVT.validate_ltd_deprn_change
383: (p_book_type_code => px_asset_hdr_rec.book_type_code,
384: p_asset_Id => px_asset_hdr_rec.asset_id,
385: p_calling_fn => l_calling_fn,
386: p_log_level_rec => g_log_level_rec) then
447:
448: -- verify that the asset exists in the tax book
449: -- if not just bypass it
450:
451: if not (FA_ASSET_VAL_PVT.validate_asset_book
452: (p_transaction_type_code => 'ADJUSTMENT',
453: p_book_type_code => l_tax_book_tbl(l_tax_index),
454: p_asset_id => px_asset_hdr_rec.asset_id,
455: p_calling_fn => l_calling_fn,
892:
893:
894: -- check if this is the period of addition - use absolute mode for adjustments
895:
896: if not FA_ASSET_VAL_PVT.validate_period_of_addition
897: (p_asset_id => px_asset_hdr_rec.asset_id,
898: p_book => px_asset_hdr_rec.book_type_code,
899: p_mode => 'ABSOLUTE',
900: px_period_of_addition => px_asset_hdr_rec.period_of_addition, p_log_level_rec => p_log_level_rec) then
910: raise adj_err;
911: end if;
912: -- bug 12830413 coorected the parameters passed
913: -- bug 12363687 called this validation to check amortization date
914: if not FA_ASSET_VAL_PVT.validate_amort_start_date
915: (p_transaction_type_code => px_trans_rec.transaction_type_code,
916: p_asset_id => px_asset_hdr_rec.asset_id,
917: p_book_type_code => px_asset_hdr_rec.book_type_code,
918: p_date_placed_in_service => l_asset_fin_rec_adj.date_placed_in_service,
930:
931: -- moving subtype/date logic into the mrc loop after getting fin_rec_old
932:
933: -- verify asset is not fully retired
934: if fa_asset_val_pvt.validate_fully_retired
935: (p_asset_id => px_asset_hdr_rec.asset_id,
936: p_book => px_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec) then
937: fa_srvr_msg.add_message
938: (name => 'FA_REC_RETIRED',
1008: name => 'FA_GROUP_NOT_AVAILABLE', p_log_level_rec => p_log_level_rec);
1009: raise adj_err;
1010: end if;
1011:
1012: if not FA_ASSET_VAL_PVT.check_overlapping_impairment(
1013: p_trans_rec => px_trans_rec,
1014: p_asset_hdr_rec => px_asset_hdr_rec ,
1015: p_log_level_rec => p_log_level_rec) then
1016:
1015: p_log_level_rec => p_log_level_rec) then
1016:
1017: fa_srvr_msg.add_message
1018: (name => 'FA_OVERLAPPING_IMP_NOT_ALLOWED',
1019: calling_fn => 'FA_ASSET_VAL_PVT.check_overlapping_impairment'
1020: ,p_log_level_rec => p_log_level_rec);
1021: raise adj_err;
1022: end if;
1023:
1063:
1064: -- Validate disabled_flag
1065: if (p_asset_type_rec.asset_type = 'GROUP') then
1066:
1067: if not FA_ASSET_VAL_PVT.validate_disabled_flag
1068: (p_group_asset_id => px_asset_hdr_rec.asset_id,
1069: p_book_type_code => px_asset_hdr_rec.book_type_code,
1070: p_old_flag => l_asset_fin_rec_old.disabled_flag,
1071: p_new_flag => l_asset_fin_rec_adj.disabled_flag
1072: , p_log_level_rec => p_log_level_rec) then
1073: raise adj_err;
1074: end if;
1075: /* Bug#8351285- Validate salvage_type or deprn_limit_type change of group */
1076: if not FA_ASSET_VAL_PVT.validate_sal_deprn_sum
1077: ( p_asset_hdr_rec => px_asset_hdr_rec,
1078: p_asset_fin_rec_old => l_asset_fin_rec_old,
1079: p_asset_fin_rec_adj => p_asset_fin_rec_adj ) then
1080:
1131: /*--Bug# 6974541 - Added l_reset_extend_flag
1132: Don't call validate_exp_after_amort while reseting extended depreciation
1133: i.e. while setting extended_deprn_flag from Yes to No */
1134: if (not (l_set_extend_flag or l_reset_extend_flag)) then
1135: if not FA_ASSET_VAL_PVT.validate_exp_after_amort
1136: (p_asset_id => px_asset_hdr_rec.asset_id,
1137: p_book => px_asset_hdr_rec.book_type_code,
1138: p_extended_flag => l_extended_flag
1139: , p_log_level_rec => p_log_level_rec) then raise adj_err;
1320:
1321: /* Japan Tax phase3 -- Do not allow cost adjustment
1322: and method change for assets in extended depreciation */
1323: if (l_extended_flag) then
1324: if not FA_ASSET_VAL_PVT.validate_extended_asset
1325: (p_asset_hdr_rec => px_asset_hdr_rec,
1326: p_asset_fin_rec_old => l_asset_fin_rec_old,
1327: p_asset_fin_rec_adj => l_asset_fin_rec_adj
1328: , p_log_level_rec => p_log_level_rec) then raise adj_err;
1331:
1332: -- Fix for Bug #6371789. Validate if Japan 250 DB asset.
1333: -- Passed deprn_method_code and life_in_months from l_asset_fin_rec_old
1334: -- to avoid "no data found" error
1335: if not FA_ASSET_VAL_PVT.validate_jp250db
1336: (p_transaction_type_code => 'ADJUSTMENT',
1337: p_book_type_code => px_asset_hdr_rec.book_type_code,
1338: p_asset_id => px_asset_hdr_rec.asset_id,
1339: p_method_code =>
1977:
1978: if nvl(l_asset_fin_rec_adj.group_asset_id,
1979: nvl(l_asset_fin_rec_old.group_asset_id,FND_API.G_MISS_NUM)) <> FND_API.G_MISS_NUM then
1980: l_asset_fin_rec_adj.group_asset_id := nvl(l_asset_fin_rec_adj.group_asset_id,l_asset_fin_rec_old.group_asset_id);
1981: if not FA_ASSET_VAL_PVT.validate_over_depreciation
1982: (p_asset_hdr_rec => l_asset_hdr_rec,
1983: p_asset_fin_rec => l_asset_fin_rec_adj,
1984: p_validation_type => 'ADJUSTMENT',
1985: p_cost_adj => l_asset_fin_rec_adj.cost,
2207: , p_log_level_rec => p_log_level_rec) then
2208: raise adj_err;
2209: end if;
2210:
2211: if not FA_ASSET_VAL_PVT.validate_period_of_addition
2212: (p_asset_id => l_src_asset_hdr_rec.asset_id,
2213: p_book => l_src_asset_hdr_rec.book_type_code,
2214: p_mode => 'ABSOLUTE',
2215: px_period_of_addition => l_src_asset_hdr_rec.period_of_addition, p_log_level_rec => p_log_level_rec) then
2260: , p_log_level_rec => p_log_level_rec) then
2261: raise adj_err;
2262: end if;
2263:
2264: if not FA_ASSET_VAL_PVT.validate_period_of_addition
2265: (p_asset_id => l_dest_asset_hdr_rec.asset_id,
2266: p_book => l_dest_asset_hdr_rec.book_type_code,
2267: p_mode => 'ABSOLUTE',
2268: px_period_of_addition => l_dest_asset_hdr_rec.period_of_addition, p_log_level_rec => p_log_level_rec) then
2375: fa_debug_pkg.add('do_all_books', 'entering', 'group reclass logic', p_log_level_rec => p_log_level_rec);
2376: end if;
2377:
2378: /*Bug 8975022 - Group Reclass on revalued assets can not be done*/
2379: IF fa_asset_val_pvt.validate_reval_exists
2380: (p_book_type_code => px_asset_hdr_rec.book_type_code,
2381: p_asset_Id => px_asset_hdr_rec.asset_id,
2382: p_calling_fn => l_calling_fn,
2383: p_log_level_rec => p_log_level_rec) then
2387: RAISE adj_err;
2388: END IF;
2389:
2390: --Added for 6990774
2391: IF NOT (fa_asset_val_pvt.validate_grp_track_method
2392: (l_asset_fin_rec_old,
2393: l_asset_fin_rec_new,
2394: p_group_reclass_options_rec,
2395: p_log_level_rec)