[Home] [Help]
91: end if;
92:
93: px_asset_hdr_rec.set_of_books_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
94:
95: if not (FA_ASSET_VAL_PVT.validate_asset_book
96: (p_transaction_type_code => 'ADJUSTMENT',
97: p_book_type_code => px_asset_hdr_rec.book_type_code,
98: p_asset_id => px_asset_hdr_rec.asset_id,
99: p_calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec)) then
125:
126:
127: -- verify that the amortized type is populated and valid
128: if (p_unplanned_deprn_rec.unplanned_type is not null) then
129: if not FA_ASSET_VAL_PVT.validate_fa_lookup_code
130: (p_lookup_type => 'UNPLANNED DEPRN',
131: p_lookup_code => p_unplanned_deprn_rec.unplanned_type, p_log_level_rec => g_log_level_rec) then
132: raise unp_err;
133: end if;
133: end if;
134: end if;
135:
136: --Check if impairment has been posted in current period.
137: if not FA_ASSET_VAL_PVT.validate_impairment_exists
138: (p_asset_id => px_asset_hdr_rec.asset_id,
139: p_book => px_asset_hdr_rec.book_type_code,
140: p_mrc_sob_type_code => 'P',
141: p_set_of_books_id => px_asset_hdr_rec.set_of_books_id,
178: raise unp_err;
179: end if;
180:
181: -- Bug:4944700
182: if not FA_ASSET_VAL_PVT.validate_period_of_addition
183: (p_asset_id => px_asset_hdr_rec.asset_id,
184: p_book => px_asset_hdr_rec.book_type_code,
185: p_mode => 'ABSOLUTE',
186: px_period_of_addition => px_asset_hdr_rec.period_of_addition
228: px_trans_rec.transaction_key := 'UE';
229: end if;
230:
231: /* Added for bug 8584206 */
232: IF not FA_ASSET_VAL_PVT.validate_energy_transactions (
233: p_trans_rec => px_trans_rec,
234: p_asset_hdr_rec => px_asset_hdr_rec,
235: p_log_level_rec => g_log_level_rec) then
236: raise unp_err;
237: END IF;
238:
239: -- check for prior amortizations/retirements
240: if (px_trans_rec.transaction_subtype <> 'AMORTIZED') then
241: if not FA_ASSET_VAL_PVT.validate_exp_after_amort
242: (p_asset_id => px_asset_hdr_rec.asset_id,
243: p_book => px_asset_hdr_rec.book_type_code
244: , p_log_level_rec => g_log_level_rec) then
245: raise unp_err;
252: raise unp_err;
253: end if;
254: end if;
255:
256: if FA_ASSET_VAL_PVT.validate_fully_retired
257: (p_asset_id => px_asset_hdr_rec.asset_id,
258: p_book => px_asset_hdr_rec.book_type_code
259: , p_log_level_rec => g_log_level_rec) then
260: fa_srvr_msg.add_message
418:
419: -- Bug # 4882700
420: -- value for parameter "p_mode" is changed to ABSOLUTE from CAPITALIZED.
421: -- check period of addition
422: if not FA_ASSET_VAL_PVT.validate_period_of_addition
423: (p_asset_id => px_asset_hdr_rec.asset_id,
424: p_book => px_asset_hdr_rec.book_type_code,
425: p_mode => 'ABSOLUTE',
426: px_period_of_addition => px_asset_hdr_rec.period_of_addition
432: -- trx_date for all expensed transactions will be last date of open period
433: l_transaction_date := greatest(l_period_rec.calendar_period_open_date,
434: least(sysdate,l_period_rec.calendar_period_close_date));
435: /*Bug#13861504 - Validate ccid */
436: if not FA_ASSET_VAL_PVT.validate_ccid
437: (p_book_type_code => px_asset_hdr_rec.book_type_code,
438: p_ccid => p_unplanned_deprn_rec.code_combination_id,
439: p_gl_chart_id => fa_cache_pkg.fazcbc_record.accounting_flex_structure,
440: p_ledger_id => fa_cache_pkg.fazcbc_record.set_of_books_id,
445: raise unp_err;
446: end if;
447: if (px_trans_rec.transaction_subtype = 'EXPENSED') then
448:
449: if not FA_ASSET_VAL_PVT.validate_exp_after_amort
450: (p_asset_id => px_asset_hdr_rec.asset_id,
451: p_book => px_asset_hdr_rec.book_type_code
452: , p_log_level_rec => p_log_level_rec) then
453: raise unp_err;
482:
483: px_trans_rec.amortization_start_date :=
484: to_date(to_char(px_trans_rec.amortization_start_date,'DD/MM/YYYY'),'DD/MM/YYYY');
485:
486: if FA_ASSET_VAL_PVT.validate_fully_retired
487: (p_asset_id => px_asset_hdr_rec.asset_id,
488: p_book => px_asset_hdr_rec.book_type_code
489: , p_log_level_rec => p_log_level_rec) then
490: fa_srvr_msg.add_message
775: from dual;
776:
777: -- check period of addition for the group
778:
779: if not FA_ASSET_VAL_PVT.validate_period_of_addition
780: (p_asset_id => l_grp_asset_hdr_rec.asset_id,
781: p_book => l_grp_asset_hdr_rec.book_type_code,
782: p_mode => 'ABSOLUTE',
783: px_period_of_addition => l_grp_asset_hdr_rec.period_of_addition
831:
832: l_grp_trans_rec.transaction_subtype := 'AMORTIZED';
833: l_grp_trans_rec.transaction_key := 'UA';
834:
835: if FA_ASSET_VAL_PVT.validate_fully_retired
836: (p_asset_id => l_grp_asset_hdr_rec.asset_id,
837: p_book => l_grp_asset_hdr_rec.book_type_code
838: , p_log_level_rec => p_log_level_rec) then
839: fa_srvr_msg.add_message
875:
876: --HH validate disabled_flag
877: --Doing this just as a precaustion in case the api get called directly.
878: --The form, if used, won't allow the trx as the button is not shown.
879: if not FA_ASSET_VAL_PVT.validate_disabled_flag
880: (p_group_asset_id => l_grp_asset_hdr_rec.asset_id,
881: p_book_type_code => l_grp_asset_hdr_rec.book_type_code,
882: p_old_flag => l_grp_asset_fin_rec.disabled_flag,
883: p_new_flag => l_grp_asset_fin_rec.disabled_flag