[Home] [Help]
746: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'end calculation', '', g_log_level_rec); end if;
747:
748: -- Fix for Bug #3187975. Do Polish rule validations.
749: -- Need to do this after transaction_type_code is derived.
750: if not FA_ASSET_VAL_PVT.validate_polish (
751: p_transaction_type_code => l_trans_rec.transaction_type_code,
752: p_method_code => l_asset_fin_rec.deprn_method_code,
753: p_life_in_months => l_asset_fin_rec.life_in_months,
754: p_asset_type => l_asset_type_rec.asset_type,
842: fa_debug_pkg.add(l_calling_fn, 'entered loop for tax books', '', g_log_level_rec);
843: fa_debug_pkg.add(l_calling_fn, 'selected tax book: ', l_tax_book_tbl(l_tax_index), g_log_level_rec);
844: end if;
845:
846: if not FA_ASSET_VAL_PVT.validate_asset_book
847: (p_transaction_type_code => px_trans_rec.transaction_type_code
848: ,p_book_type_code => l_tax_book_tbl(l_tax_index)
849: ,p_asset_id => px_asset_hdr_rec.asset_id
850: ,p_calling_fn => l_calling_fn
1184:
1185: -- SLA Uptake
1186: -- allowing retirements in period of addition
1187:
1188: if FA_ASSET_VAL_PVT.validate_period_of_addition
1189: (p_asset_id => l_asset_hdr_rec.asset_id
1190: ,p_book => l_asset_hdr_rec.book_type_code
1191: ,p_mode => 'ABSOLUTE'
1192: ,px_period_of_addition => l_asset_hdr_rec.period_of_addition
1208:
1209: -- check if there is an add-to-asset transaction pending
1210: -- Users must post their mass additions before they can retire the asset
1211: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'check if there is an add-to-asset transaction pending', '', p_log_level_rec); end if;
1212: if FA_ASSET_VAL_PVT.validate_add_to_asset_pending
1213: (p_asset_id => l_asset_hdr_rec.asset_id
1214: ,p_book => l_asset_hdr_rec.book_type_code
1215: ,p_log_level_rec => p_log_level_rec) then
1216: -- Users must post their mass additions before they can retire the asset
1219: end if;
1220:
1221: -- check if another retirement/reinstatement already pending
1222: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'check if another retirement/reinstatement already pending', '', p_log_level_rec); end if;
1223: if FA_ASSET_VAL_PVT.validate_ret_rst_pending
1224: (p_asset_id => l_asset_hdr_rec.asset_id
1225: ,p_book => l_asset_hdr_rec.book_type_code
1226: ,p_log_level_rec => p_log_level_rec) then
1227: g_msg_name := 'FA_RET_PENDING_RETIREMENTS';
1229: end if;
1230:
1231: -- check if the asset has already been fully retired
1232: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'check if the asset is already fully retired', '', p_log_level_rec); end if;
1233: if FA_ASSET_VAL_PVT.validate_fully_retired
1234: (p_asset_id => l_asset_hdr_rec.asset_id
1235: ,p_book => l_asset_hdr_rec.book_type_code
1236: ,p_log_level_rec => p_log_level_rec) then
1237: g_msg_name := 'FA_REC_RETIRED';
2261: l_trans_rec.who_info.last_update_date := sysdate;
2262:
2263: -- Fix for Bug #3187975. Do Polish rule validations.
2264: -- Need to do this after transaction_type_code is derived.
2265: if not FA_ASSET_VAL_PVT.validate_polish (
2266: p_transaction_type_code => l_trans_rec.transaction_type_code,
2267: p_method_code => l_asset_fin_rec.deprn_method_code,
2268: p_life_in_months => l_asset_fin_rec.life_in_months,
2269: p_asset_type => l_asset_type_rec.asset_type,
3308: end if;
3309:
3310: for l_tax_index in 1..l_tax_book_tbl.count loop
3311:
3312: if not FA_ASSET_VAL_PVT.validate_asset_book
3313: (p_transaction_type_code => l_trans_rec.transaction_type_code
3314: ,p_book_type_code => l_tax_book_tbl(l_tax_index)
3315: ,p_asset_id => l_asset_hdr_rec.asset_id
3316: ,p_calling_fn => l_calling_fn) then
4479: fa_debug_pkg.add(l_calling_fn, 'entered loop for tax books', '', g_log_level_rec);
4480: fa_debug_pkg.add(l_calling_fn, 'selected tax book: ', l_tax_book_tbl(l_tax_index), g_log_level_rec);
4481: end if;
4482:
4483: if not FA_ASSET_VAL_PVT.validate_asset_book
4484: (p_transaction_type_code => l_trans_rec.transaction_type_code
4485: ,p_book_type_code => l_tax_book_tbl(l_tax_index)
4486: ,p_asset_id => l_asset_hdr_rec.asset_id
4487: ,p_calling_fn => l_calling_fn) then
4744:
4745: -- check if there is an add-to-asset transaction pending
4746: -- Users must post their mass additions before they can retire the asset
4747: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'check if there is an add-to-asset transaction pending', '', p_log_level_rec); end if;
4748: if FA_ASSET_VAL_PVT.validate_add_to_asset_pending
4749: (p_asset_id => l_asset_hdr_rec.asset_id
4750: ,p_book => l_asset_hdr_rec.book_type_code
4751: ,p_log_level_rec => p_log_level_rec) then
4752: -- Users must post their mass additions before they can retire the asset
4755: end if;
4756:
4757: -- check if another retirement/reinstatement already pending
4758: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'check if another retirement/reinstatement already pending', '', p_log_level_rec); end if;
4759: if FA_ASSET_VAL_PVT.validate_ret_rst_pending
4760: (p_asset_id => l_asset_hdr_rec.asset_id
4761: ,p_book => l_asset_hdr_rec.book_type_code
4762: ,p_log_level_rec => p_log_level_rec) then
4763: g_msg_name := 'FA_SHARED_PENDING_RETIREMENT';
5736: fa_debug_pkg.add(l_calling_fn, 'entered loop for tax books', '', g_log_level_rec);
5737: fa_debug_pkg.add(l_calling_fn, 'selected tax book: ', l_tax_book_tbl(l_tax_index), g_log_level_rec);
5738: end if;
5739:
5740: if not FA_ASSET_VAL_PVT.validate_asset_book
5741: (p_transaction_type_code => l_trans_rec.transaction_type_code
5742: ,p_book_type_code => l_tax_book_tbl(l_tax_index)
5743: ,p_asset_id => l_asset_hdr_rec.asset_id
5744: ,p_calling_fn => l_calling_fn) then
6431: -- check if retirement type exists in fa_lookups if it is provided
6432: if l_validation_type=g_retirement then
6433: if l_asset_retire_rec.retirement_type_code is not null then
6434: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'check if retirement type exists in fa_lookups', '', p_log_level_rec); end if;
6435: if not FA_ASSET_VAL_PVT.validate_fa_lookup_code
6436: (p_lookup_type => 'RETIREMENT'
6437: ,p_lookup_code => l_asset_retire_rec.retirement_type_code
6438: ,p_log_level_rec => p_log_level_rec) then
6439: g_msg_name := null;
6456: end if;
6457:
6458: -- check if the trade-in asset exists in Oracle Assets
6459: if g_log_level_rec.statement_level then fa_debug_pkg.add(l_calling_fn, 'check if trade_in_asset_id exists in Oracle Assets', '', p_log_level_rec); end if;
6460: if not FA_ASSET_VAL_PVT.validate_asset_id_exist
6461: (p_asset_id => l_asset_hdr_rec.asset_id
6462: ,p_log_level_rec => p_log_level_rec) then
6463: g_msg_name := 'FA_RET_TRADE_IN_NONEXISTENT';
6464: g_token1 := null;
6658:
6659: -- check if provided dist_id is valid
6660: if l_asset_dist_tbl(i).distribution_id is not null then
6661:
6662: if not FA_ASSET_VAL_PVT.validate_dist_id
6663: (p_asset_id => l_asset_hdr_rec.asset_id
6664: ,p_dist_id => l_asset_dist_tbl(i).distribution_id) then
6665: -- Error: Unable to get distribution information
6666: g_msg_name := 'FA_EXP_FETCH_DH';
6797: -- check if the asset has already been fully retired
6798: if g_log_level_rec.statement_level then
6799: fa_debug_pkg.add(l_calling_fn, 'check if the asset is already fully retired', '', p_log_level_rec);
6800: end if;
6801: if FA_ASSET_VAL_PVT.validate_fully_retired
6802: (p_asset_id => l_asset_hdr_rec.asset_id
6803: ,p_book => l_asset_hdr_rec.book_type_code
6804: ,p_log_level_rec => p_log_level_rec) then
6805: g_msg_name := 'FA_REC_RETIRED';
6852: | Instead, Gain/Loss must be run on the Corp book first |
6853: | and then you may reinstate the asset. |
6854: +---------------------------------------------------------------+*/
6855:
6856: if FA_ASSET_VAL_PVT.validate_corp_pending_ret
6857: (p_asset_id => l_asset_hdr_rec.asset_id
6858: ,p_book => l_asset_hdr_rec.book_type_code
6859: ,p_transaction_header_id_in => lv_asset_retire_rec.detail_info.transaction_header_id_in
6860: ,p_log_level_rec => p_log_level_rec) then