The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
decode(m.depreciate_lastyear_flag,'YES',1,0),
nvl(book_grp.life_in_months,0),
decode(book_grp.capitalize_flag, 'YES', 1, 0),
decode(book_grp.depreciate_flag, 'YES', 1, 0),
decode(book_grp.period_counter_fully_reserved, null, 0, 1),
nvl(book_grp.itc_amount_id, 0),
ah.units,
bc.current_fiscal_year,
bc.distribution_source_book,
book_grp.rate_adjustment_factor,
nvl(book_grp.adjusted_rate,0),
book_grp.adjusted_cost,
book_grp.cost,
book_grp.recoverable_cost,
book_grp.itc_amount,
nvl(book_grp.salvage_value,0),
trunc(book_grp.prorate_date),
to_number(to_char(book_grp.prorate_date, 'J')),
decode(instr(m.rate_source_rule, 'CALCULATED'), 0,
trunc(book_grp.deprn_start_date), trunc(book_grp.prorate_date)),
decode(instr(m.rate_source_rule, 'CALCULATED'), 0,
to_number(to_char(book_grp.deprn_start_date, 'J')),
to_number(to_char(book_grp.prorate_date, 'J'))),
trunc(book_grp.date_placed_in_service),
to_number(to_char(book_grp.date_placed_in_service, 'J')),
bc.prorate_calendar,
m.method_code,
decode(bc.DEPR_FIRST_YEAR_RET_FLAG, 'YES', 1, 0),
conv.prorate_date,
trunc(bc.initial_date),
bc.deprn_calendar,
nvl(book_grp.ceiling_name, null),
nvl(book_grp.bonus_rule, null),
decode(m.rate_source_rule, 'CALCULATED', 1, 'TABLE', 2,
'FLAT', 3),
decode(m.deprn_basis_rule, 'COST', 1, 'NBV', 2),
decode(bc.book_class, 'TAX', 1, 0),
decode(ah.asset_type, 'CIP', 1, 0),
decode(ctype.depr_when_acquired_flag,'YES',1,0),
nvl(book_grp.reval_amortization_basis,0),
book_grp.unrevalued_cost,
nvl(book_grp.adjusted_capacity,0),
nvl(book_grp.production_capacity,0),
bc.fiscal_year_name,
nvl (book_grp.adjusted_recoverable_cost, book_grp.recoverable_cost),
decode(book_grp.annual_deprn_rounding_flag, NULL, 0, 'ADD', 1,
'ADJ', 2, 'RET', 3, 'REV', 4, 'TFR', 5,'RES', 6, 'OVE', 7, -1),
nvl(book_grp.short_fiscal_year_flag, 'NO'),
book_grp.conversion_date,
book_grp.original_deprn_start_date,
nvl(book_grp.old_adjusted_cost, 1),
nvl(book_grp.formula_factor, 1),
book_grp.allowed_deprn_limit_amount,
book_grp.group_asset_id,
book_grp.recognize_gain_loss,
book_grp.recapture_reserve_flag,
book_grp.limit_proceeds_flag,
book_grp.terminal_gain_loss,
book_grp.tracking_method,
book_grp.exclude_fully_rsv_flag,
book_grp.excess_allocation_option,
book_grp.depreciation_option,
book_grp.member_rollup_flag,
book_grp.ltd_proceeds,
book_grp.allocate_to_fully_rsv_flag,
book_grp.allocate_to_fully_ret_flag,
book_grp.eofy_reserve,
book_grp.cip_cost,
book_grp.ltd_cost_of_removal,
book_grp.prior_eofy_reserve,
book_grp.eop_adj_cost,
book_grp.eop_formula_factor,
book_grp.exclude_proceeds_from_basis,
book_grp.retirement_deprn_option,
book_grp.terminal_gain_loss_amount,
book_grp.period_counter_fully_reserved,
--Bug# 6920756
--book_grp.EXTENDED_DEPRN_FLAG, -- bug 6913897
--decode(book_grp.PERIOD_COUNTER_FULLY_EXTENDED, null, 0, 1) -- bug 6913897
decode(book_grp.period_counter_fully_extended, null, 0, 1),
book_grp.period_counter_fully_extended,
decode(book_grp.extended_deprn_flag,'Y', 1, 0)
INTO
h_depreciate_lastyr,
h_lifemonths,
h_capitalize,
h_depreciate,
h_fully_reserved,
h_itc_used,
h_cur_units,
h_cpd_fiscal_year,
h_dis_book,
h_raf,
h_adj_rate,
h_adjusted_cost,
h_current_cost,
h_recoverable_cost,
h_itc_amount,
h_salvage_value,
h_prorate_date,
h_prorate_jdate,
h_deprn_start_date,
h_deprn_start_jdate,
h_date_in_srv,
h_jdis,
h_p_cal,
h_method_code,
h_depr_first_year_ret,
h_ret_prorate_date,
h_initial_date,
h_deprn_cal,
h_ceiling_name,
h_bonus_rule,
h_rate_source_rule,
h_deprn_basis_rule,
h_book_class,
h_wip_asset,
h_dwacq,
h_reval_amort_basis,
h_unrevalued_cost,
h_adj_capacity,
h_capacity,
h_fiscal_year_name,
h_adj_rec_cost,
h_annual_deprn_rounding_flag,
h_short_fiscal_year_flag,
h_conversion_date,
h_orig_deprn_start_date,
h_old_adj_cost,
h_formula_factor,
h_allowed_deprn_limit_amount,
h_group_asset_id,
h_recognize_gain_loss,
h_recapture_reserve_flag,
h_limit_proceeds_flag,
h_terminal_gain_loss,
h_tracking_method,
h_exclude_fully_rsv_flag,
h_excess_allocation_option,
h_depreciation_option,
h_member_rollup_flag,
h_ltd_proceeds,
h_allocate_to_fully_rsv_flag,
h_allocate_to_fully_ret_flag,
h_eofy_reserve,
h_cip_cost,
h_ltd_cost_of_removal,
h_prior_eofy_reserve,
h_eop_adj_cost,
h_eop_formula_factor,
h_exclude_proceeds_from_basis,
h_retirement_deprn_option,
h_terminal_gain_loss_amount,
h_pc_fully_reserved,
--Bug# 6920756
--h_extended_deprn_flag,
h_fully_extended,
h_pc_fully_extended,
h_extended_flag
FROM
fa_books book,
fa_books book_grp,
fa_methods m,
fa_conventions conv,
fa_convention_types ctype,
fa_book_controls bc,
fa_asset_history ah
WHERE
book.retirement_id = h_retirement_id
AND book.asset_id = h_asset_id
AND book.book_type_code = h_book
AND book_grp.transaction_header_id_out is null
AND book_grp.asset_id = book.group_asset_id
AND book_grp.book_type_code = h_book
AND book_grp.deprn_method_code = m.method_code
AND nvl(book_grp.life_in_months,1) = nvl(m.life_in_months,1)
AND
bc.book_type_code = h_book
AND
ah.asset_id = book_grp.asset_id
AND ah.transaction_header_id_out is null
AND trunc(h_date_retired) between
conv.start_date and conv.end_date
AND h_ret_p_conv = conv.prorate_convention_code
AND ctype.prorate_convention_code = h_ret_p_conv;
SELECT
decode(m.depreciate_lastyear_flag,'YES',1,0),
nvl(book_grp.life_in_months,0),
decode(book_grp.capitalize_flag, 'YES', 1, 0),
decode(book_grp.depreciate_flag, 'YES', 1, 0),
decode(book_grp.period_counter_fully_reserved, null, 0, 1),
nvl(book_grp.itc_amount_id, 0),
ah.units,
bc.current_fiscal_year,
bc_primary.distribution_source_book,
book_grp.rate_adjustment_factor,
nvl(book_grp.adjusted_rate,0),
book_grp.adjusted_cost,
book_grp.cost,
book_grp.recoverable_cost,
book_grp.itc_amount,
nvl(book_grp.salvage_value,0),
trunc(book_grp.prorate_date),
to_number(to_char(book_grp.prorate_date, 'J')),
decode(instr(m.rate_source_rule, 'CALCULATED'), 0,
trunc(book_grp.deprn_start_date), trunc(book_grp.prorate_date)),
decode(instr(m.rate_source_rule, 'CALCULATED'), 0,
to_number(to_char(book_grp.deprn_start_date, 'J')),
to_number(to_char(book_grp.prorate_date, 'J'))),
trunc(book_grp.date_placed_in_service),
to_number(to_char(book_grp.date_placed_in_service, 'J')),
bc_primary.prorate_calendar,
m.method_code,
decode(bc_primary.DEPR_FIRST_YEAR_RET_FLAG, 'YES', 1, 0),
conv.prorate_date,
trunc(bc_primary.initial_date),
bc_primary.deprn_calendar,
nvl(book_grp.ceiling_name, null),
nvl(book_grp.bonus_rule, null),
decode(m.rate_source_rule, 'CALCULATED', 1, 'TABLE', 2,
'FLAT', 3),
decode(m.deprn_basis_rule, 'COST', 1, 'NBV', 2),
decode(bc_primary.book_class, 'TAX', 1, 0),
decode(ah.asset_type, 'CIP', 1, 0),
decode(ctype.depr_when_acquired_flag,'YES',1,0),
nvl(book_grp.reval_amortization_basis,0),
book_grp.unrevalued_cost,
nvl(book_grp.adjusted_capacity,0),
nvl(book_grp.production_capacity,0),
bc_primary.fiscal_year_name,
nvl (book_grp.adjusted_recoverable_cost, book_grp.recoverable_cost),
decode(book_grp.annual_deprn_rounding_flag, NULL, 0, 'ADD', 1,
'ADJ', 2, 'RET', 3, 'REV', 4, 'TFR', 5,'RES', 6, 'OVE', 7, -1),
nvl(book_grp.short_fiscal_year_flag, 'NO'),
book_grp.conversion_date,
book_grp.original_deprn_start_date,
nvl(book_grp.old_adjusted_cost, 1),
nvl(book_grp.formula_factor, 1),
book_grp.allowed_deprn_limit_amount,
book_grp.group_asset_id,
book_grp.recognize_gain_loss,
book_grp.recapture_reserve_flag,
book_grp.limit_proceeds_flag,
book_grp.terminal_gain_loss,
book_grp.tracking_method,
book_grp.exclude_fully_rsv_flag,
book_grp.excess_allocation_option,
book_grp.depreciation_option,
book_grp.member_rollup_flag,
book_grp.ltd_proceeds,
book_grp.allocate_to_fully_rsv_flag,
book_grp.allocate_to_fully_ret_flag,
book_grp.eofy_reserve,
book_grp.cip_cost,
book_grp.ltd_cost_of_removal,
book_grp.prior_eofy_reserve,
book_grp.eop_adj_cost,
book_grp.eop_formula_factor,
book_grp.exclude_proceeds_from_basis,
book_grp.retirement_deprn_option,
book_grp.terminal_gain_loss_amount,
book_grp.period_counter_fully_reserved
INTO
h_depreciate_lastyr,
h_lifemonths,
h_capitalize,
h_depreciate,
h_fully_reserved,
h_itc_used,
h_cur_units,
h_cpd_fiscal_year,
h_dis_book,
h_raf,
h_adj_rate,
h_adjusted_cost,
h_current_cost,
h_recoverable_cost,
h_itc_amount,
h_salvage_value,
h_prorate_date,
h_prorate_jdate,
h_deprn_start_date,
h_deprn_start_jdate,
h_date_in_srv,
h_jdis,
h_p_cal,
h_method_code,
h_depr_first_year_ret,
h_ret_prorate_date,
h_initial_date,
h_deprn_cal,
h_ceiling_name,
h_bonus_rule,
h_rate_source_rule,
h_deprn_basis_rule,
h_book_class,
h_wip_asset,
h_dwacq,
h_reval_amort_basis,
h_unrevalued_cost,
h_adj_capacity,
h_capacity,
h_fiscal_year_name,
h_adj_rec_cost,
h_annual_deprn_rounding_flag,
h_short_fiscal_year_flag,
h_conversion_date,
h_orig_deprn_start_date,
h_old_adj_cost,
h_formula_factor,
h_allowed_deprn_limit_amount,
h_group_asset_id,
h_recognize_gain_loss,
h_recapture_reserve_flag,
h_limit_proceeds_flag,
h_terminal_gain_loss,
h_tracking_method,
h_exclude_fully_rsv_flag,
h_excess_allocation_option,
h_depreciation_option,
h_member_rollup_flag,
h_ltd_proceeds,
h_allocate_to_fully_rsv_flag,
h_allocate_to_fully_ret_flag,
h_eofy_reserve,
h_cip_cost,
h_ltd_cost_of_removal,
h_prior_eofy_reserve,
h_eop_adj_cost,
h_eop_formula_factor,
h_exclude_proceeds_from_basis,
h_retirement_deprn_option,
h_terminal_gain_loss_amount,
h_pc_fully_reserved
FROM
fa_mc_books book,
fa_mc_books book_grp,
fa_methods m,
fa_conventions conv,
fa_convention_types ctype,
fa_mc_book_controls bc,
fa_book_controls bc_primary, -- added this to get fiscal year name
fa_asset_history ah
WHERE
book.retirement_id = h_retirement_id
AND book.asset_id = h_asset_id
AND book.book_type_code = h_book
AND book_grp.transaction_header_id_out is null
AND book_grp.asset_id = book.group_asset_id
AND book_grp.book_type_code = h_book
AND book_grp.deprn_method_code = m.method_code
AND nvl(book_grp.life_in_months,1) = nvl(m.life_in_months,1)
AND
bc.book_type_code = h_book
AND
ah.asset_id = book_grp.asset_id
AND ah.transaction_header_id_out is null
AND trunc(h_date_retired) between
conv.start_date and conv.end_date
AND h_ret_p_conv = conv.prorate_convention_code
AND book.set_of_books_id = ret.set_of_books_id
AND book_grp.set_of_books_id = ret.set_of_books_id
AND bc.set_of_books_id = ret.set_of_books_id
AND bc_primary.book_type_code = bc.book_type_code
AND ctype.prorate_convention_code = h_ret_p_conv;
select decode(fy1.fiscal_year, fy2.fiscal_year,1,0)
INTO h_same_fy
FROM FA_FISCAL_YEAR FY1, FA_FISCAL_YEAR FY2
WHERE trunc(h_date_retired) between fy1.start_date and fy1.end_date
AND trunc(h_deprn_start_date)
between fy2.start_date and fy2.end_date
AND fy1.fiscal_year_name = h_fiscal_year_name
AND fy2.fiscal_year_name = h_fiscal_year_name;
SELECT FISCAL.FISCAL_YEAR
INTO h_ret_fiscalyr
FROM FA_FISCAL_YEAR FISCAL
WHERE trunc(h_ret_prorate_date)
between START_DATE and END_DATE
AND fiscal_year_name = h_fiscal_year_name;
select trunc(start_date)
into h_ret_prorate_date
from fa_fiscal_year
where fiscal_year = h_ret_fiscalyr
and fiscal_year_name = h_fiscal_year_name;
SELECT start_date
INTO h_ret_prorate_date
FROM fa_fiscal_year
where fiscal_year = h_cpd_fiscal_year
and fiscal_year_name = h_fiscal_year_name;
SELECT h_deprn_start_date
INTO h_ret_prorate_date
FROM dual;
SELECT h_deprn_start_date
INTO h_ret_prorate_date
FROM dual
where trunc(h_ret_prorate_date) < trunc(h_deprn_start_date);
SELECT h_prorate_date
INTO h_ret_prorate_date
FROM dual
WHERE trunc(h_ret_prorate_date) < trunc(h_prorate_date);
SELECT to_number (to_char (cp.start_date, 'J'))
INTO h_cpp_jstartdate
FROM fa_deprn_periods dp,
fa_calendar_periods cp,
fa_fiscal_year fy
WHERE cp.calendar_type = h_d_cal
AND fy.fiscal_year_name = h_fiscal_year_name
AND fy.fiscal_year = h_cpd_fy
AND dp.fiscal_year = fy.fiscal_year
AND dp.book_type_code = h_book
AND dp.period_num = h_cpdnum
AND dp.period_name = cp.period_name
AND dp.period_num = cp.period_num;
SELECT period_num
INTO h_startpp
FROM fa_calendar_periods
WHERE calendar_type = h_p_cal
AND to_date (h_cpp_jstartdate,'J')
between start_date and end_date;
SELECT period_num
INTO h_endpp
FROM fa_calendar_periods
WHERE calendar_type = h_p_cal
AND trunc(h_ret_p_date)
between start_date and end_date;
| 9/5/90 R Rumanang Updated for Tax Reserve |
| Adjustment |
| 04/11/91 M Chan Rewrite for MPL 9 to speed up the|
| retirement program. |
| 01/08/97 S Behura Rewrote into PL/SQL |
| 08/11/97 S Behura Rewrote into PL/SQL(10.7) |
|==========================================================================*/
FUNCTION faggrv(asset_id number, book in varchar2, cpd_ctr number,
adj_rsv in out nocopy number, reval_adj_rsv in out nocopy number,
prior_fy_exp in out nocopy number, ytd_deprn in out nocopy number,
bonus_rsv in out nocopy number,
bonus_ytd_deprn in out nocopy number,
prior_fy_bonus_exp in out nocopy number,
impairment_rsv in out nocopy number,
ytd_impairment in out nocopy number,
mrc_sob_type_code in varchar2,
set_of_books_id in number,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
faggrv_err exception;
select transaction_header_id
from fa_transaction_headers
where asset_id = p_ret.asset_id
and book_type_code = p_ret.book
and member_transaction_header_id = p_ret.th_id_in;
l_adj.selection_retid := 0;
l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;
l_adj.last_update_date := l_trans_rec.who_info.last_update_date;
l_trans_rec.who_info.last_update_date,
l_trans_rec.who_info.last_updated_by,
l_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
if p_log_level_rec.statement_level then
fa_debug_pkg.add(l_calling_fn, 'error calling', 'faxinaj', p_log_level_rec => p_log_level_rec);
l_trans_rec.who_info.last_update_date,
l_trans_rec.who_info.last_updated_by,
l_trans_rec.who_info.last_update_login, p_log_level_rec => p_log_level_rec) then
if p_log_level_rec.statement_level then
fa_debug_pkg.add(l_calling_fn, 'error calling', 'faxinaj', p_log_level_rec => p_log_level_rec);
FA_RETIREMENTS_PKG.Update_Row(
X_Rowid => l_rowid,
X_Retirement_Id => p_ret.retirement_id,
X_Recapture_Amount => l_g_rsv - nvl(p_bk.current_cost - p_ret.cost_retired, 0),
X_mrc_sob_type_code => p_ret.mrc_sob_type_code,
X_set_of_books_id => p_ret.set_of_books_id,
X_Calling_Fn => l_calling_fn,
p_log_level_rec => p_log_level_rec);
UPDATE FA_ADJUSTMENTS
SET TRANSACTION_HEADER_ID = g_grp_trx_hdr_id
WHERE TRANSACTION_HEADER_ID = p_ret.th_id_in
AND ASSET_ID = p_ret.asset_id
AND BOOK_TYPE_CODE = p_ret.book;
UPDATE FA_MC_ADJUSTMENTS
SET TRANSACTION_HEADER_ID = g_grp_trx_hdr_id
WHERE TRANSACTION_HEADER_ID = p_ret.th_id_in
AND ASSET_ID = p_ret.asset_id
AND BOOK_TYPE_CODE = p_ret.book
AND SET_OF_BOOKS_ID = p_ret.set_of_books_id;
select adjusted_cost
, salvage_value
, recoverable_cost
, adjusted_recoverable_cost
, reval_amortization_basis
, old_adjusted_cost
from fa_books
where asset_id = c_asset_id
and book_type_code = ret.book
and transaction_header_id_out is null;
select adjusted_cost
, salvage_value
, recoverable_cost
, adjusted_recoverable_cost
, reval_amortization_basis
, old_adjusted_cost
from fa_mc_books
where asset_id = c_asset_id
and book_type_code = ret.book
and set_of_books_id = ret.set_of_books_id
and transaction_header_id_out is null;
select 'Y'
from fa_calendar_periods fcp1,
fa_calendar_periods fcp2,
fa_book_controls fbc
where to_date (dpr.prorate_jdate,'J') BETWEEN fcp1.start_date and fcp1.end_date
and fbc.book_type_code = dpr.book
and fcp1.calendar_type = fbc.deprn_calendar
and to_date (decode( dpr.jdate_retired,0,null,dpr.jdate_retired),'J') BETWEEN fcp2.start_date and fcp2.end_date
and fcp2.calendar_type=fcp1.calendar_type
and fcp1.period_name=fcp2.period_name;
select do.rowid
from fa_deprn_override do
, fa_deprn_periods dp
where do.asset_id = c_asset_id
and do.book_type_code = ret.book
and dp.period_counter = cpd_ctr
and do.period_name = dp.period_name
and dp.book_type_code = do.book_type_code
and do.used_by = 'RETIREMENT'
and do.rowid = decode(c_status, 'POSTED', c_rowid, do.rowid)
and do.status = c_status;
SELECT facp.period_num
INTO h_cpdnum
FROM fa_calendar_periods facp
WHERE facp.calendar_type = bk.p_cal
AND ( facp.start_date = bk.prorate_date
OR facp.end_date = bk.prorate_date );
select asset_number
into ret_group.asset_number
from fa_additions_b
where asset_id = ret_group.asset_id;
name => 'FA_RET_INSERT_ERROR',
token1 => 'MODULE',
value1 => 'FAGPDP',
token2 => 'ACTION',
value2 => 'insert',
token3 => 'TYPE',
value3 => 'Depreciation',
token4 => 'ASSET',
value4 => ret.asset_number , p_log_level_rec => p_log_level_rec);
name => 'FA_RET_INSERT_ERROR',
token1 => 'MODULE',
value1 => 'FA_RETIREMENT_PVT.Do_Retirement_in_CGL',
token2 => 'ACTION',
value2 => 'make',
token3 => 'TYPE',
value3 => 'table',
token4 => 'ASSET',
value4 => ret.asset_number , p_log_level_rec => p_log_level_rec);
update fa_mc_retirements
set reserve_retired = reserve_retired + deprn_amt_group
where retirement_id = ret.retirement_id
and set_of_books_id = ret.set_of_books_id;
update fa_retirements
set reserve_retired = reserve_retired + deprn_amt_group
where retirement_id = ret.retirement_id;
name => 'FA_RET_INSERT_ERROR',
token1 => 'MODULE',
value1 => 'FAGPRV',
token2 => 'ACTION',
value2 => 'insert',
token3 => 'TYPE',
value3 => 'Depreciation Reserve',
token4 => 'ASSET',
value4 => ret.asset_number , p_log_level_rec => p_log_level_rec);
name => 'FA_RET_INSERT_ERROR',
token1 => 'MODULE',
value1 => 'FAGPCT',
token2 => 'ACTION',
value2 => 'insert',
token3 => 'TYPE',
value3 => 'Cost',
token4 => 'ASSET',
value4 => ret.asset_number , p_log_level_rec => p_log_level_rec);
name => 'FA_RET_INSERT_ERROR',
token1 => 'MODULE',
value1 => 'FAGURT',
token2 => 'ACTION',
value2 => 'make',
token3 => 'TYPE',
value3 => 'table',
token4 => 'ASSET',
value4 => ret.asset_number , p_log_level_rec => p_log_level_rec);
name => 'FA_RET_INSERT_ERROR',
token1 => 'MODULE',
value1 => 'FAGPDP',
token2 => 'ACTION',
value2 => 'insert',
token3 => 'TYPE',
value3 => 'Depreciation',
token4 => 'ASSET',
value4 => ret_group.asset_number , p_log_level_rec => p_log_level_rec);
name => 'FA_RET_INSERT_ERROR',
token1 => 'MODULE',
value1 => 'FAGPDP',
token2 => 'ACTION',
value2 => 'insert',
token3 => 'TYPE',
value3 => 'Depreciation',
token4 => 'ASSET',
value4 => ret_group.asset_number , p_log_level_rec => p_log_level_rec);
name => 'FA_RET_INSERT_ERROR',
token1 => 'MODULE',
value1 => 'FAGPDP',
token2 => 'ACTION',
value2 => 'insert',
token3 => 'TYPE',
value3 => 'Depreciation',
token4 => 'ASSET',
value4 => ret.asset_number , p_log_level_rec => p_log_level_rec);
name => 'FA_RET_INSERT_ERROR',
token1 => 'MODULE',
value1 => 'FAGPDP',
token2 => 'ACTION',
value2 => 'insert',
token3 => 'TYPE',
value3 => 'Depreciation',
token4 => 'ASSET',
value4 => ret_group.asset_number , p_log_level_rec => p_log_level_rec);
name => 'FA_RET_INSERT_ERROR',
token1 => 'MODULE',
value1 => 'FAGGRP',
token2 => 'ACTION',
value2 => 'insert',
token3 => 'TYPE',
value3 => 'Depreciation Reserve',
token4 => 'ASSET',
value4 => ret_group.asset_number , p_log_level_rec => p_log_level_rec);