eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_SORP_REVALUATION_PKG dependencies on FA_DEBUG_PKG

Line 106: fa_debug_pkg.ADD (l_calling_fn,'BEGINS','1', p_log_level_rec => p_log_level_rec);

102:
103: begin
104:
105: if (p_log_level_rec.statement_level) then
106: fa_debug_pkg.ADD (l_calling_fn,'BEGINS','1', p_log_level_rec => p_log_level_rec);
107: fa_debug_pkg.ADD (l_calling_fn,'p_mass_reval_id',p_mass_reval_id, p_log_level_rec => p_log_level_rec);
108: fa_debug_pkg.ADD (l_calling_fn,'p_asset_id',p_asset_id, p_log_level_rec => p_log_level_rec);
109: fa_debug_pkg.ADD (l_calling_fn,'p_book_type_code',p_book_type_code, p_log_level_rec => p_log_level_rec);
110: fa_debug_pkg.ADD (l_calling_fn,'p_impairment_id',p_impairment_id, p_log_level_rec => p_log_level_rec);

Line 107: fa_debug_pkg.ADD (l_calling_fn,'p_mass_reval_id',p_mass_reval_id, p_log_level_rec => p_log_level_rec);

103: begin
104:
105: if (p_log_level_rec.statement_level) then
106: fa_debug_pkg.ADD (l_calling_fn,'BEGINS','1', p_log_level_rec => p_log_level_rec);
107: fa_debug_pkg.ADD (l_calling_fn,'p_mass_reval_id',p_mass_reval_id, p_log_level_rec => p_log_level_rec);
108: fa_debug_pkg.ADD (l_calling_fn,'p_asset_id',p_asset_id, p_log_level_rec => p_log_level_rec);
109: fa_debug_pkg.ADD (l_calling_fn,'p_book_type_code',p_book_type_code, p_log_level_rec => p_log_level_rec);
110: fa_debug_pkg.ADD (l_calling_fn,'p_impairment_id',p_impairment_id, p_log_level_rec => p_log_level_rec);
111: fa_debug_pkg.ADD (l_calling_fn,'p_unused_imp_amount',p_unused_imp_amount, p_log_level_rec => p_log_level_rec);

Line 108: fa_debug_pkg.ADD (l_calling_fn,'p_asset_id',p_asset_id, p_log_level_rec => p_log_level_rec);

104:
105: if (p_log_level_rec.statement_level) then
106: fa_debug_pkg.ADD (l_calling_fn,'BEGINS','1', p_log_level_rec => p_log_level_rec);
107: fa_debug_pkg.ADD (l_calling_fn,'p_mass_reval_id',p_mass_reval_id, p_log_level_rec => p_log_level_rec);
108: fa_debug_pkg.ADD (l_calling_fn,'p_asset_id',p_asset_id, p_log_level_rec => p_log_level_rec);
109: fa_debug_pkg.ADD (l_calling_fn,'p_book_type_code',p_book_type_code, p_log_level_rec => p_log_level_rec);
110: fa_debug_pkg.ADD (l_calling_fn,'p_impairment_id',p_impairment_id, p_log_level_rec => p_log_level_rec);
111: fa_debug_pkg.ADD (l_calling_fn,'p_unused_imp_amount',p_unused_imp_amount, p_log_level_rec => p_log_level_rec);
112: end if;

Line 109: fa_debug_pkg.ADD (l_calling_fn,'p_book_type_code',p_book_type_code, p_log_level_rec => p_log_level_rec);

105: if (p_log_level_rec.statement_level) then
106: fa_debug_pkg.ADD (l_calling_fn,'BEGINS','1', p_log_level_rec => p_log_level_rec);
107: fa_debug_pkg.ADD (l_calling_fn,'p_mass_reval_id',p_mass_reval_id, p_log_level_rec => p_log_level_rec);
108: fa_debug_pkg.ADD (l_calling_fn,'p_asset_id',p_asset_id, p_log_level_rec => p_log_level_rec);
109: fa_debug_pkg.ADD (l_calling_fn,'p_book_type_code',p_book_type_code, p_log_level_rec => p_log_level_rec);
110: fa_debug_pkg.ADD (l_calling_fn,'p_impairment_id',p_impairment_id, p_log_level_rec => p_log_level_rec);
111: fa_debug_pkg.ADD (l_calling_fn,'p_unused_imp_amount',p_unused_imp_amount, p_log_level_rec => p_log_level_rec);
112: end if;
113:

Line 110: fa_debug_pkg.ADD (l_calling_fn,'p_impairment_id',p_impairment_id, p_log_level_rec => p_log_level_rec);

106: fa_debug_pkg.ADD (l_calling_fn,'BEGINS','1', p_log_level_rec => p_log_level_rec);
107: fa_debug_pkg.ADD (l_calling_fn,'p_mass_reval_id',p_mass_reval_id, p_log_level_rec => p_log_level_rec);
108: fa_debug_pkg.ADD (l_calling_fn,'p_asset_id',p_asset_id, p_log_level_rec => p_log_level_rec);
109: fa_debug_pkg.ADD (l_calling_fn,'p_book_type_code',p_book_type_code, p_log_level_rec => p_log_level_rec);
110: fa_debug_pkg.ADD (l_calling_fn,'p_impairment_id',p_impairment_id, p_log_level_rec => p_log_level_rec);
111: fa_debug_pkg.ADD (l_calling_fn,'p_unused_imp_amount',p_unused_imp_amount, p_log_level_rec => p_log_level_rec);
112: end if;
113:
114: open c_impair_period_counter;

Line 111: fa_debug_pkg.ADD (l_calling_fn,'p_unused_imp_amount',p_unused_imp_amount, p_log_level_rec => p_log_level_rec);

107: fa_debug_pkg.ADD (l_calling_fn,'p_mass_reval_id',p_mass_reval_id, p_log_level_rec => p_log_level_rec);
108: fa_debug_pkg.ADD (l_calling_fn,'p_asset_id',p_asset_id, p_log_level_rec => p_log_level_rec);
109: fa_debug_pkg.ADD (l_calling_fn,'p_book_type_code',p_book_type_code, p_log_level_rec => p_log_level_rec);
110: fa_debug_pkg.ADD (l_calling_fn,'p_impairment_id',p_impairment_id, p_log_level_rec => p_log_level_rec);
111: fa_debug_pkg.ADD (l_calling_fn,'p_unused_imp_amount',p_unused_imp_amount, p_log_level_rec => p_log_level_rec);
112: end if;
113:
114: open c_impair_period_counter;
115: fetch c_impair_period_counter into l_period_counter_impaired,

Line 123: fa_debug_pkg.ADD (l_calling_fn,'period_counter_impaired',l_period_counter_impaired, p_log_level_rec => p_log_level_rec);

119: l_split_impair_amt;
120: close c_impair_period_counter;
121:
122: if (p_log_level_rec.statement_level) then
123: fa_debug_pkg.ADD (l_calling_fn,'period_counter_impaired',l_period_counter_impaired, p_log_level_rec => p_log_level_rec);
124: fa_debug_pkg.ADD (l_calling_fn,'l_impairment_date',l_impairment_date, p_log_level_rec => p_log_level_rec);
125: fa_debug_pkg.ADD (l_calling_fn,'l_split_impair_flag',l_split_impair_flag, p_log_level_rec => p_log_level_rec);
126: fa_debug_pkg.ADD (l_calling_fn,'l_impairment_amount',l_impairment_amount, p_log_level_rec => p_log_level_rec);
127: end if;

Line 124: fa_debug_pkg.ADD (l_calling_fn,'l_impairment_date',l_impairment_date, p_log_level_rec => p_log_level_rec);

120: close c_impair_period_counter;
121:
122: if (p_log_level_rec.statement_level) then
123: fa_debug_pkg.ADD (l_calling_fn,'period_counter_impaired',l_period_counter_impaired, p_log_level_rec => p_log_level_rec);
124: fa_debug_pkg.ADD (l_calling_fn,'l_impairment_date',l_impairment_date, p_log_level_rec => p_log_level_rec);
125: fa_debug_pkg.ADD (l_calling_fn,'l_split_impair_flag',l_split_impair_flag, p_log_level_rec => p_log_level_rec);
126: fa_debug_pkg.ADD (l_calling_fn,'l_impairment_amount',l_impairment_amount, p_log_level_rec => p_log_level_rec);
127: end if;
128: x_impair_split_flag := l_split_impair_flag;

Line 125: fa_debug_pkg.ADD (l_calling_fn,'l_split_impair_flag',l_split_impair_flag, p_log_level_rec => p_log_level_rec);

121:
122: if (p_log_level_rec.statement_level) then
123: fa_debug_pkg.ADD (l_calling_fn,'period_counter_impaired',l_period_counter_impaired, p_log_level_rec => p_log_level_rec);
124: fa_debug_pkg.ADD (l_calling_fn,'l_impairment_date',l_impairment_date, p_log_level_rec => p_log_level_rec);
125: fa_debug_pkg.ADD (l_calling_fn,'l_split_impair_flag',l_split_impair_flag, p_log_level_rec => p_log_level_rec);
126: fa_debug_pkg.ADD (l_calling_fn,'l_impairment_amount',l_impairment_amount, p_log_level_rec => p_log_level_rec);
127: end if;
128: x_impair_split_flag := l_split_impair_flag;
129: /*+++++++ Populating l_dpr_in to call faxcde ++++++++++*/

Line 126: fa_debug_pkg.ADD (l_calling_fn,'l_impairment_amount',l_impairment_amount, p_log_level_rec => p_log_level_rec);

122: if (p_log_level_rec.statement_level) then
123: fa_debug_pkg.ADD (l_calling_fn,'period_counter_impaired',l_period_counter_impaired, p_log_level_rec => p_log_level_rec);
124: fa_debug_pkg.ADD (l_calling_fn,'l_impairment_date',l_impairment_date, p_log_level_rec => p_log_level_rec);
125: fa_debug_pkg.ADD (l_calling_fn,'l_split_impair_flag',l_split_impair_flag, p_log_level_rec => p_log_level_rec);
126: fa_debug_pkg.ADD (l_calling_fn,'l_impairment_amount',l_impairment_amount, p_log_level_rec => p_log_level_rec);
127: end if;
128: x_impair_split_flag := l_split_impair_flag;
129: /*+++++++ Populating l_dpr_in to call faxcde ++++++++++*/
130: l_dpr_in.calendar_type := fa_cache_pkg.fazcbc_record.deprn_calendar;

Line 141: fa_debug_pkg.add(l_calling_fn, 'Calling', 'query_balances_int', p_log_level_rec => p_log_level_rec);

137: l_dpr_row.dist_id := 0;
138: l_dpr_row.mrc_sob_type_code := 'P';
139:
140: if (p_log_level_rec.statement_level) then
141: fa_debug_pkg.add(l_calling_fn, 'Calling', 'query_balances_int', p_log_level_rec => p_log_level_rec);
142: end if;
143: l_running_mode := 'STANDARD';
144: fa_query_balances_pkg.query_balances_int(
145: X_DPR_ROW => l_dpr_row,

Line 155: fa_debug_pkg.add(l_calling_fn, 'ERROR',

151:
152: if (NOT l_status) then
153:
154: if (p_log_level_rec.statement_level) then
155: fa_debug_pkg.add(l_calling_fn, 'ERROR',
156: 'Calling fa_query_balances_pkg.query_balances_int', p_log_level_rec => p_log_level_rec);
157: end if;
158:
159: --raise dpr_err;

Line 163: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_adjust_exp', l_dpr_row.deprn_adjust_exp, p_log_level_rec => p_log_level_rec);

159: --raise dpr_err;
160: end if;
161:
162: if (p_log_level_rec.statement_level) then
163: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_adjust_exp', l_dpr_row.deprn_adjust_exp, p_log_level_rec => p_log_level_rec);
164: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_exp', l_dpr_row.deprn_exp, p_log_level_rec => p_log_level_rec);
165: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_rsv', l_dpr_row.deprn_rsv, p_log_level_rec => p_log_level_rec);
166: end if;
167:

Line 164: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_exp', l_dpr_row.deprn_exp, p_log_level_rec => p_log_level_rec);

160: end if;
161:
162: if (p_log_level_rec.statement_level) then
163: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_adjust_exp', l_dpr_row.deprn_adjust_exp, p_log_level_rec => p_log_level_rec);
164: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_exp', l_dpr_row.deprn_exp, p_log_level_rec => p_log_level_rec);
165: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_rsv', l_dpr_row.deprn_rsv, p_log_level_rec => p_log_level_rec);
166: end if;
167:
168: open c_get_old_fin_rec;

Line 165: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_rsv', l_dpr_row.deprn_rsv, p_log_level_rec => p_log_level_rec);

161:
162: if (p_log_level_rec.statement_level) then
163: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_adjust_exp', l_dpr_row.deprn_adjust_exp, p_log_level_rec => p_log_level_rec);
164: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_exp', l_dpr_row.deprn_exp, p_log_level_rec => p_log_level_rec);
165: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_rsv', l_dpr_row.deprn_rsv, p_log_level_rec => p_log_level_rec);
166: end if;
167:
168: open c_get_old_fin_rec;
169: fetch c_get_old_fin_rec into l_c_get_old_fin_rec;

Line 220: fa_debug_pkg.add(l_calling_fn, 'Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);

216: l_dpr_in.set_of_books_id := p_set_of_books_id;
217: l_running_mode := fa_std_types.FA_DPR_NORMAL;
218:
219: if (p_log_level_rec.statement_level) then
220: fa_debug_pkg.add(l_calling_fn, 'Calling', 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
221: end if;
222:
223: if not fa_cache_pkg.fazccp(fa_cache_pkg.fazcbc_record.prorate_calendar,
224: fa_cache_pkg.fazcbc_record.fiscal_year_name,

Line 230: fa_debug_pkg.add(l_calling_fn, 'Error calling',

226: g_temp_number,
227: l_dpr_in.y_begin,
228: g_temp_integer, p_log_level_rec => p_log_level_rec) then
229: if (p_log_level_rec.statement_level) then
230: fa_debug_pkg.add(l_calling_fn, 'Error calling',
231: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
232: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
233: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
234: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',

Line 232: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',

228: g_temp_integer, p_log_level_rec => p_log_level_rec) then
229: if (p_log_level_rec.statement_level) then
230: fa_debug_pkg.add(l_calling_fn, 'Error calling',
231: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
232: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
233: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
234: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
235: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
236:

Line 234: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',

230: fa_debug_pkg.add(l_calling_fn, 'Error calling',
231: 'fa_cache_pkg.fazccp', p_log_level_rec => p_log_level_rec);
232: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.prorate_calendar',
233: fa_cache_pkg.fazcbc_record.prorate_calendar, p_log_level_rec => p_log_level_rec);
234: fa_debug_pkg.add(l_calling_fn, 'fa_cache_pkg.fazcbc_record.fiscal_year_name',
235: fa_cache_pkg.fazcbc_record.fiscal_year_name, p_log_level_rec => p_log_level_rec);
236:
237: end if;
238:

Line 258: fa_debug_pkg.ADD (l_calling_fn,'before calling faxcde','1', p_log_level_rec => p_log_level_rec);

254: l_dpr_in.p_cl_end := l_dpr_in.p_cl_end - 1;
255: end if;
256:
257: if (p_log_level_rec.statement_level) then
258: fa_debug_pkg.ADD (l_calling_fn,'before calling faxcde','1', p_log_level_rec => p_log_level_rec);
259: end if;
260: if not FA_CDE_PKG.faxcde(l_dpr_in,
261: l_dpr_arr,
262: l_dpr_out,

Line 264: fa_debug_pkg.ADD (l_calling_fn,'failled running','FA_CDE_PKG.faxcde', p_log_level_rec => p_log_level_rec);

260: if not FA_CDE_PKG.faxcde(l_dpr_in,
261: l_dpr_arr,
262: l_dpr_out,
263: l_running_mode, p_log_level_rec => p_log_level_rec) then
264: fa_debug_pkg.ADD (l_calling_fn,'failled running','FA_CDE_PKG.faxcde', p_log_level_rec => p_log_level_rec);
265: end if;
266:
267: x_deprn_rsv := l_dpr_out.new_deprn_rsv - l_dpr_row.deprn_exp;
268: if (p_log_level_rec.statement_level) then

Line 269: fa_debug_pkg.add(l_calling_fn, 'x_deprn_rsv calculated by faxcde call', x_deprn_rsv, p_log_level_rec => p_log_level_rec);

265: end if;
266:
267: x_deprn_rsv := l_dpr_out.new_deprn_rsv - l_dpr_row.deprn_exp;
268: if (p_log_level_rec.statement_level) then
269: fa_debug_pkg.add(l_calling_fn, 'x_deprn_rsv calculated by faxcde call', x_deprn_rsv, p_log_level_rec => p_log_level_rec);
270: fa_debug_pkg.add(l_calling_fn, 'Calling again to get current reserve', 'query_balances_int', p_log_level_rec => p_log_level_rec);
271: end if;
272:
273: l_running_mode := 'STANDARD';

Line 270: fa_debug_pkg.add(l_calling_fn, 'Calling again to get current reserve', 'query_balances_int', p_log_level_rec => p_log_level_rec);

266:
267: x_deprn_rsv := l_dpr_out.new_deprn_rsv - l_dpr_row.deprn_exp;
268: if (p_log_level_rec.statement_level) then
269: fa_debug_pkg.add(l_calling_fn, 'x_deprn_rsv calculated by faxcde call', x_deprn_rsv, p_log_level_rec => p_log_level_rec);
270: fa_debug_pkg.add(l_calling_fn, 'Calling again to get current reserve', 'query_balances_int', p_log_level_rec => p_log_level_rec);
271: end if;
272:
273: l_running_mode := 'STANDARD';
274: fa_query_balances_pkg.query_balances_int(

Line 285: fa_debug_pkg.add(l_calling_fn, 'ERROR',

281:
282: if (NOT l_status) then
283:
284: if (p_log_level_rec.statement_level) then
285: fa_debug_pkg.add(l_calling_fn, 'ERROR',
286: 'Calling fa_query_balances_pkg.query_balances_int', p_log_level_rec => p_log_level_rec);
287: end if;
288: --raise dpr_err;
289: end if;

Line 291: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_adjust_exp', l_dpr_row.deprn_adjust_exp, p_log_level_rec => p_log_level_rec);

287: end if;
288: --raise dpr_err;
289: end if;
290: if (p_log_level_rec.statement_level) then
291: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_adjust_exp', l_dpr_row.deprn_adjust_exp, p_log_level_rec => p_log_level_rec);
292: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_exp', l_dpr_row.deprn_exp, p_log_level_rec => p_log_level_rec);
293: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_rsv', l_dpr_row.deprn_rsv, p_log_level_rec => p_log_level_rec);
294: end if;
295:

Line 292: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_exp', l_dpr_row.deprn_exp, p_log_level_rec => p_log_level_rec);

288: --raise dpr_err;
289: end if;
290: if (p_log_level_rec.statement_level) then
291: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_adjust_exp', l_dpr_row.deprn_adjust_exp, p_log_level_rec => p_log_level_rec);
292: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_exp', l_dpr_row.deprn_exp, p_log_level_rec => p_log_level_rec);
293: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_rsv', l_dpr_row.deprn_rsv, p_log_level_rec => p_log_level_rec);
294: end if;
295:
296: /* Complex logic to calculated the deper effect */

Line 293: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_rsv', l_dpr_row.deprn_rsv, p_log_level_rec => p_log_level_rec);

289: end if;
290: if (p_log_level_rec.statement_level) then
291: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_adjust_exp', l_dpr_row.deprn_adjust_exp, p_log_level_rec => p_log_level_rec);
292: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_exp', l_dpr_row.deprn_exp, p_log_level_rec => p_log_level_rec);
293: fa_debug_pkg.add(l_calling_fn, 'l_dpr_row.deprn_rsv', l_dpr_row.deprn_rsv, p_log_level_rec => p_log_level_rec);
294: end if;
295:
296: /* Complex logic to calculated the deper effect */
297: /* first take difference of calculated deprn and current deprn*/

Line 300: fa_debug_pkg.add(l_calling_fn, 'deprn effect before perious partial linked reval impact (if any) :', x_deprn_rsv);

296: /* Complex logic to calculated the deper effect */
297: /* first take difference of calculated deprn and current deprn*/
298: x_deprn_rsv := (x_deprn_rsv - l_dpr_row.deprn_rsv);
299: if (p_log_level_rec.statement_level) then
300: fa_debug_pkg.add(l_calling_fn, 'deprn effect before perious partial linked reval impact (if any) :', x_deprn_rsv);
301: end if;
302:
303: /* check if any partial linking has happened,if so consider deprn reserve at that point in time to
304: as it will reversed by revaluation.*/

Line 312: fa_debug_pkg.add(l_calling_fn, 'deprn rsv moved out because of period revaluation if any:',l_deprn_rsv_out, p_log_level_rec => p_log_level_rec);

308: l_period_counter_revalued;
309: close c_get_deprn_rsv_out;
310: x_deprn_rsv := x_deprn_rsv - nvl(l_deprn_rsv_out,0);
311: if (p_log_level_rec.statement_level) then
312: fa_debug_pkg.add(l_calling_fn, 'deprn rsv moved out because of period revaluation if any:',l_deprn_rsv_out, p_log_level_rec => p_log_level_rec);
313: fa_debug_pkg.add(l_calling_fn, 'already linked amount l_reval_expense:', l_reval_expense, p_log_level_rec => p_log_level_rec);
314: fa_debug_pkg.add(l_calling_fn, 'already linked amount l_period_counter_revalued:', l_period_counter_revalued, p_log_level_rec => p_log_level_rec);
315: fa_debug_pkg.add(l_calling_fn, 'deprn effect reverse NOT FINAL######:', x_deprn_rsv, p_log_level_rec => p_log_level_rec);
316: end if;

Line 313: fa_debug_pkg.add(l_calling_fn, 'already linked amount l_reval_expense:', l_reval_expense, p_log_level_rec => p_log_level_rec);

309: close c_get_deprn_rsv_out;
310: x_deprn_rsv := x_deprn_rsv - nvl(l_deprn_rsv_out,0);
311: if (p_log_level_rec.statement_level) then
312: fa_debug_pkg.add(l_calling_fn, 'deprn rsv moved out because of period revaluation if any:',l_deprn_rsv_out, p_log_level_rec => p_log_level_rec);
313: fa_debug_pkg.add(l_calling_fn, 'already linked amount l_reval_expense:', l_reval_expense, p_log_level_rec => p_log_level_rec);
314: fa_debug_pkg.add(l_calling_fn, 'already linked amount l_period_counter_revalued:', l_period_counter_revalued, p_log_level_rec => p_log_level_rec);
315: fa_debug_pkg.add(l_calling_fn, 'deprn effect reverse NOT FINAL######:', x_deprn_rsv, p_log_level_rec => p_log_level_rec);
316: end if;
317:

Line 314: fa_debug_pkg.add(l_calling_fn, 'already linked amount l_period_counter_revalued:', l_period_counter_revalued, p_log_level_rec => p_log_level_rec);

310: x_deprn_rsv := x_deprn_rsv - nvl(l_deprn_rsv_out,0);
311: if (p_log_level_rec.statement_level) then
312: fa_debug_pkg.add(l_calling_fn, 'deprn rsv moved out because of period revaluation if any:',l_deprn_rsv_out, p_log_level_rec => p_log_level_rec);
313: fa_debug_pkg.add(l_calling_fn, 'already linked amount l_reval_expense:', l_reval_expense, p_log_level_rec => p_log_level_rec);
314: fa_debug_pkg.add(l_calling_fn, 'already linked amount l_period_counter_revalued:', l_period_counter_revalued, p_log_level_rec => p_log_level_rec);
315: fa_debug_pkg.add(l_calling_fn, 'deprn effect reverse NOT FINAL######:', x_deprn_rsv, p_log_level_rec => p_log_level_rec);
316: end if;
317:
318: /*Logic to prorate deprn effect if partial linking has happened earlier */

Line 315: fa_debug_pkg.add(l_calling_fn, 'deprn effect reverse NOT FINAL######:', x_deprn_rsv, p_log_level_rec => p_log_level_rec);

311: if (p_log_level_rec.statement_level) then
312: fa_debug_pkg.add(l_calling_fn, 'deprn rsv moved out because of period revaluation if any:',l_deprn_rsv_out, p_log_level_rec => p_log_level_rec);
313: fa_debug_pkg.add(l_calling_fn, 'already linked amount l_reval_expense:', l_reval_expense, p_log_level_rec => p_log_level_rec);
314: fa_debug_pkg.add(l_calling_fn, 'already linked amount l_period_counter_revalued:', l_period_counter_revalued, p_log_level_rec => p_log_level_rec);
315: fa_debug_pkg.add(l_calling_fn, 'deprn effect reverse NOT FINAL######:', x_deprn_rsv, p_log_level_rec => p_log_level_rec);
316: end if;
317:
318: /*Logic to prorate deprn effect if partial linking has happened earlier */
319:

Line 330: fa_debug_pkg.add(l_calling_fn, 'sum of reval amortization amount after partial link', l_reval_amort_deprn_exp, p_log_level_rec => p_log_level_rec);

326: l_count;
327: close c_get_reval_expenses;
328: x_deprn_rsv := x_deprn_rsv + nvl(l_reval_expense,0)*l_count;
329: if (p_log_level_rec.statement_level) then
330: fa_debug_pkg.add(l_calling_fn, 'sum of reval amortization amount after partial link', l_reval_amort_deprn_exp, p_log_level_rec => p_log_level_rec);
331: fa_debug_pkg.add(l_calling_fn, 'count no of period l_count:', l_count, p_log_level_rec => p_log_level_rec);
332: fa_debug_pkg.add(l_calling_fn, 'deprn effect reverse NOT FINAL 3######:', x_deprn_rsv, p_log_level_rec => p_log_level_rec);
333: end if;
334: /* set x_impairment_amt which will be used in calling function for calculation*/

Line 331: fa_debug_pkg.add(l_calling_fn, 'count no of period l_count:', l_count, p_log_level_rec => p_log_level_rec);

327: close c_get_reval_expenses;
328: x_deprn_rsv := x_deprn_rsv + nvl(l_reval_expense,0)*l_count;
329: if (p_log_level_rec.statement_level) then
330: fa_debug_pkg.add(l_calling_fn, 'sum of reval amortization amount after partial link', l_reval_amort_deprn_exp, p_log_level_rec => p_log_level_rec);
331: fa_debug_pkg.add(l_calling_fn, 'count no of period l_count:', l_count, p_log_level_rec => p_log_level_rec);
332: fa_debug_pkg.add(l_calling_fn, 'deprn effect reverse NOT FINAL 3######:', x_deprn_rsv, p_log_level_rec => p_log_level_rec);
333: end if;
334: /* set x_impairment_amt which will be used in calling function for calculation*/
335: x_impairment_amt := l_impairment_amount;

Line 332: fa_debug_pkg.add(l_calling_fn, 'deprn effect reverse NOT FINAL 3######:', x_deprn_rsv, p_log_level_rec => p_log_level_rec);

328: x_deprn_rsv := x_deprn_rsv + nvl(l_reval_expense,0)*l_count;
329: if (p_log_level_rec.statement_level) then
330: fa_debug_pkg.add(l_calling_fn, 'sum of reval amortization amount after partial link', l_reval_amort_deprn_exp, p_log_level_rec => p_log_level_rec);
331: fa_debug_pkg.add(l_calling_fn, 'count no of period l_count:', l_count, p_log_level_rec => p_log_level_rec);
332: fa_debug_pkg.add(l_calling_fn, 'deprn effect reverse NOT FINAL 3######:', x_deprn_rsv, p_log_level_rec => p_log_level_rec);
333: end if;
334: /* set x_impairment_amt which will be used in calling function for calculation*/
335: x_impairment_amt := l_impairment_amount;
336: end if;

Line 345: fa_debug_pkg.add(l_calling_fn, 'sum of reval amortization amount after partial link', l_reval_amort_deprn_exp, p_log_level_rec => p_log_level_rec);

341: close c_get_reval_expenses;
342: x_deprn_rsv := nvl(l_reval_expense,0)*l_count + x_deprn_rsv + l_reval_amort_deprn_exp;
343: x_deprn_rsv := (x_deprn_rsv * p_unused_imp_amount)/l_impairment_amount;
344: if (p_log_level_rec.statement_level) then
345: fa_debug_pkg.add(l_calling_fn, 'sum of reval amortization amount after partial link', l_reval_amort_deprn_exp, p_log_level_rec => p_log_level_rec);
346: fa_debug_pkg.add(l_calling_fn, 'count no of period l_count:', l_count, p_log_level_rec => p_log_level_rec);
347: fa_debug_pkg.add(l_calling_fn, 'deprn effect reverse NOT FINAL 3######:', x_deprn_rsv, p_log_level_rec => p_log_level_rec);
348: end if;
349: x_impairment_amt := l_split_impair_amt ;

Line 346: fa_debug_pkg.add(l_calling_fn, 'count no of period l_count:', l_count, p_log_level_rec => p_log_level_rec);

342: x_deprn_rsv := nvl(l_reval_expense,0)*l_count + x_deprn_rsv + l_reval_amort_deprn_exp;
343: x_deprn_rsv := (x_deprn_rsv * p_unused_imp_amount)/l_impairment_amount;
344: if (p_log_level_rec.statement_level) then
345: fa_debug_pkg.add(l_calling_fn, 'sum of reval amortization amount after partial link', l_reval_amort_deprn_exp, p_log_level_rec => p_log_level_rec);
346: fa_debug_pkg.add(l_calling_fn, 'count no of period l_count:', l_count, p_log_level_rec => p_log_level_rec);
347: fa_debug_pkg.add(l_calling_fn, 'deprn effect reverse NOT FINAL 3######:', x_deprn_rsv, p_log_level_rec => p_log_level_rec);
348: end if;
349: x_impairment_amt := l_split_impair_amt ;
350: /* set x_impairment_amt which will be used in calling function for calculation*/

Line 347: fa_debug_pkg.add(l_calling_fn, 'deprn effect reverse NOT FINAL 3######:', x_deprn_rsv, p_log_level_rec => p_log_level_rec);

343: x_deprn_rsv := (x_deprn_rsv * p_unused_imp_amount)/l_impairment_amount;
344: if (p_log_level_rec.statement_level) then
345: fa_debug_pkg.add(l_calling_fn, 'sum of reval amortization amount after partial link', l_reval_amort_deprn_exp, p_log_level_rec => p_log_level_rec);
346: fa_debug_pkg.add(l_calling_fn, 'count no of period l_count:', l_count, p_log_level_rec => p_log_level_rec);
347: fa_debug_pkg.add(l_calling_fn, 'deprn effect reverse NOT FINAL 3######:', x_deprn_rsv, p_log_level_rec => p_log_level_rec);
348: end if;
349: x_impairment_amt := l_split_impair_amt ;
350: /* set x_impairment_amt which will be used in calling function for calculation*/
351: end if;

Line 355: fa_debug_pkg.add(l_calling_fn, 'deprn effect reverse FINAL######:', x_deprn_rsv, p_log_level_rec => p_log_level_rec);

351: end if;
352: /*round before return */
353: x_deprn_rsv := round(x_deprn_rsv,2);
354: if (p_log_level_rec.statement_level) then
355: fa_debug_pkg.add(l_calling_fn, 'deprn effect reverse FINAL######:', x_deprn_rsv, p_log_level_rec => p_log_level_rec);
356: end if;
357: return true;
358: end fa_sorp_link_reval_dd;
359:

Line 410: fa_debug_pkg.ADD ('fa_sorp_process_imp_id_fn',

406: WHEN OTHERS
407: THEN
408: IF p_log_level_rec.statement_level
409: THEN
410: fa_debug_pkg.ADD ('fa_sorp_process_imp_id_fn',
411: 'Error Occured',
412: 'YES'
413: , p_log_level_rec => p_log_level_rec);
414: END IF;

Line 779: fa_debug_pkg.ADD ('fa_imp_deprn_eff_fn',

775: END IF;
776:
777: IF p_log_level_rec.statement_level
778: THEN
779: fa_debug_pkg.ADD ('fa_imp_deprn_eff_fn',
780: 'Impairment Impact on deprn',
781: l_imp_effect
782: , p_log_level_rec => p_log_level_rec);
783: END IF;

Line 789: fa_debug_pkg.ADD ('fa_imp_deprn_eff_fn', 'Error Occured', 'YES', p_log_level_rec => p_log_level_rec);

785: WHEN OTHERS
786: THEN
787: IF p_log_level_rec.statement_level
788: THEN
789: fa_debug_pkg.ADD ('fa_imp_deprn_eff_fn', 'Error Occured', 'YES', p_log_level_rec => p_log_level_rec);
790: END IF;
791:
792: RETURN (0);
793: END fa_imp_deprn_eff_fn;

Line 833: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'START', 'START', p_log_level_rec => p_log_level_rec);

829: AND run_mode = 'RUN';
830:
831: v_tmp_amt NUMBER;
832: BEGIN
833: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'START', 'START', p_log_level_rec => p_log_level_rec);
834: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);
835: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'p_request_id', p_request_id, p_log_level_rec => p_log_level_rec);
836:
837: OPEN c_sorp_link_itf_cur;

Line 834: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);

830:
831: v_tmp_amt NUMBER;
832: BEGIN
833: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'START', 'START', p_log_level_rec => p_log_level_rec);
834: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);
835: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'p_request_id', p_request_id, p_log_level_rec => p_log_level_rec);
836:
837: OPEN c_sorp_link_itf_cur;
838:

Line 835: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'p_request_id', p_request_id, p_log_level_rec => p_log_level_rec);

831: v_tmp_amt NUMBER;
832: BEGIN
833: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'START', 'START', p_log_level_rec => p_log_level_rec);
834: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);
835: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'p_request_id', p_request_id, p_log_level_rec => p_log_level_rec);
836:
837: OPEN c_sorp_link_itf_cur;
838:
839: FETCH c_sorp_link_itf_cur

Line 850: fa_debug_pkg.ADD ('SORP_ACCOUNTING',

846: THEN
847: v_impair_loss_acct := fa_cache_pkg.fazccb_record.impair_expense_acct;
848: END IF;
849:
850: fa_debug_pkg.ADD ('SORP_ACCOUNTING',
851: 'v_impair_loss_acct',
852: v_impair_loss_acct
853: , p_log_level_rec => p_log_level_rec);
854: fa_debug_pkg.ADD ('SORP_ACCOUNTING',

Line 854: fa_debug_pkg.ADD ('SORP_ACCOUNTING',

850: fa_debug_pkg.ADD ('SORP_ACCOUNTING',
851: 'v_impair_loss_acct',
852: v_impair_loss_acct
853: , p_log_level_rec => p_log_level_rec);
854: fa_debug_pkg.ADD ('SORP_ACCOUNTING',
855: 'v_REVAL_RESERVE_IMPACT_FLAG',
856: v_reval_reserve_impact_flag
857: , p_log_level_rec => p_log_level_rec);
858: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'v_imapirment_id', v_imapirment_id, p_log_level_rec => p_log_level_rec);

Line 858: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'v_imapirment_id', v_imapirment_id, p_log_level_rec => p_log_level_rec);

854: fa_debug_pkg.ADD ('SORP_ACCOUNTING',
855: 'v_REVAL_RESERVE_IMPACT_FLAG',
856: v_reval_reserve_impact_flag
857: , p_log_level_rec => p_log_level_rec);
858: fa_debug_pkg.ADD ('SORP_ACCOUNTING', 'v_imapirment_id', v_imapirment_id, p_log_level_rec => p_log_level_rec);
859:
860: IF NVL (v_calc_imp_reverse_amt, 0) <> 0
861: THEN
862: px_adj.adjustment_amount := ROUND ((v_calc_imp_reverse_amt), 2);

Line 1001: fa_debug_pkg.ADD (l_calling_fn,

997: RETURN TRUE;
998: EXCEPTION
999: WHEN pos_err
1000: THEN
1001: fa_debug_pkg.ADD (l_calling_fn,
1002: 'exception at sorp accounting',
1003: 'pos_err'
1004: , p_log_level_rec => p_log_level_rec);
1005: fa_debug_pkg.ADD (l_calling_fn, 'sqlerrm', SUBSTRB (SQLERRM, 1, 200));

Line 1005: fa_debug_pkg.ADD (l_calling_fn, 'sqlerrm', SUBSTRB (SQLERRM, 1, 200));

1001: fa_debug_pkg.ADD (l_calling_fn,
1002: 'exception at sorp accounting',
1003: 'pos_err'
1004: , p_log_level_rec => p_log_level_rec);
1005: fa_debug_pkg.ADD (l_calling_fn, 'sqlerrm', SUBSTRB (SQLERRM, 1, 200));
1006: RETURN FALSE;
1007: WHEN OTHERS
1008: THEN
1009: fa_debug_pkg.ADD (l_calling_fn,

Line 1009: fa_debug_pkg.ADD (l_calling_fn,

1005: fa_debug_pkg.ADD (l_calling_fn, 'sqlerrm', SUBSTRB (SQLERRM, 1, 200));
1006: RETURN FALSE;
1007: WHEN OTHERS
1008: THEN
1009: fa_debug_pkg.ADD (l_calling_fn,
1010: 'exception at sorp accounting',
1011: 'OTHERS'
1012: , p_log_level_rec => p_log_level_rec);
1013: fa_debug_pkg.ADD (l_calling_fn, 'sqlerrm', SUBSTRB (SQLERRM, 1, 200));

Line 1013: fa_debug_pkg.ADD (l_calling_fn, 'sqlerrm', SUBSTRB (SQLERRM, 1, 200));

1009: fa_debug_pkg.ADD (l_calling_fn,
1010: 'exception at sorp accounting',
1011: 'OTHERS'
1012: , p_log_level_rec => p_log_level_rec);
1013: fa_debug_pkg.ADD (l_calling_fn, 'sqlerrm', SUBSTRB (SQLERRM, 1, 200));
1014: RETURN FALSE;
1015: END fa_sorp_accounting;
1016:
1017: /* Procedure has logic for linking revaluations with prior impairments.

Line 1185: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'Start', 'Start', p_log_level_rec => p_log_level_rec);

1181: x_impairment_amt NUMBER;
1182: x_override_flag varchar2(3);
1183: x_impair_split_flag varchar2(3);
1184: BEGIN
1185: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'Start', 'Start', p_log_level_rec => p_log_level_rec);
1186: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_adj_amt', p_adj_amt, p_log_level_rec => p_log_level_rec);
1187: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1188: 'p_mass_reval_id',
1189: p_mass_reval_id

Line 1186: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_adj_amt', p_adj_amt, p_log_level_rec => p_log_level_rec);

1182: x_override_flag varchar2(3);
1183: x_impair_split_flag varchar2(3);
1184: BEGIN
1185: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'Start', 'Start', p_log_level_rec => p_log_level_rec);
1186: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_adj_amt', p_adj_amt, p_log_level_rec => p_log_level_rec);
1187: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1188: 'p_mass_reval_id',
1189: p_mass_reval_id
1190: , p_log_level_rec => p_log_level_rec);

Line 1187: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1183: x_impair_split_flag varchar2(3);
1184: BEGIN
1185: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'Start', 'Start', p_log_level_rec => p_log_level_rec);
1186: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_adj_amt', p_adj_amt, p_log_level_rec => p_log_level_rec);
1187: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1188: 'p_mass_reval_id',
1189: p_mass_reval_id
1190: , p_log_level_rec => p_log_level_rec);
1191: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);

Line 1191: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);

1187: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1188: 'p_mass_reval_id',
1189: p_mass_reval_id
1190: , p_log_level_rec => p_log_level_rec);
1191: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);
1192: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1193: 'p_book_type_code',
1194: p_book_type_code
1195: , p_log_level_rec => p_log_level_rec);

Line 1192: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1188: 'p_mass_reval_id',
1189: p_mass_reval_id
1190: , p_log_level_rec => p_log_level_rec);
1191: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_asset_id', p_asset_id, p_log_level_rec => p_log_level_rec);
1192: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1193: 'p_book_type_code',
1194: p_book_type_code
1195: , p_log_level_rec => p_log_level_rec);
1196: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_run_mode', p_run_mode, p_log_level_rec => p_log_level_rec);

Line 1196: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_run_mode', p_run_mode, p_log_level_rec => p_log_level_rec);

1192: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1193: 'p_book_type_code',
1194: p_book_type_code
1195: , p_log_level_rec => p_log_level_rec);
1196: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_run_mode', p_run_mode, p_log_level_rec => p_log_level_rec);
1197: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_request_id', p_request_id, p_log_level_rec => p_log_level_rec);
1198: -- Adjustment Amount is the amount that can be adjusted based on amount entered for revaluation by the user and on revaluation method
1199: -- Calculation for getting adj amount in available in Reval Private package
1200: l_adj_amt := p_adj_amt;

Line 1197: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_request_id', p_request_id, p_log_level_rec => p_log_level_rec);

1193: 'p_book_type_code',
1194: p_book_type_code
1195: , p_log_level_rec => p_log_level_rec);
1196: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_run_mode', p_run_mode, p_log_level_rec => p_log_level_rec);
1197: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_request_id', p_request_id, p_log_level_rec => p_log_level_rec);
1198: -- Adjustment Amount is the amount that can be adjusted based on amount entered for revaluation by the user and on revaluation method
1199: -- Calculation for getting adj amount in available in Reval Private package
1200: l_adj_amt := p_adj_amt;
1201: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_reval_type', p_reval_type, p_log_level_rec => p_log_level_rec);

Line 1201: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_reval_type', p_reval_type, p_log_level_rec => p_log_level_rec);

1197: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_request_id', p_request_id, p_log_level_rec => p_log_level_rec);
1198: -- Adjustment Amount is the amount that can be adjusted based on amount entered for revaluation by the user and on revaluation method
1199: -- Calculation for getting adj amount in available in Reval Private package
1200: l_adj_amt := p_adj_amt;
1201: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_reval_type', p_reval_type, p_log_level_rec => p_log_level_rec);
1202: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'l_adj_amt', l_adj_amt, p_log_level_rec => p_log_level_rec);
1203:
1204: IF p_reval_type = 'A'
1205: THEN

Line 1202: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'l_adj_amt', l_adj_amt, p_log_level_rec => p_log_level_rec);

1198: -- Adjustment Amount is the amount that can be adjusted based on amount entered for revaluation by the user and on revaluation method
1199: -- Calculation for getting adj amount in available in Reval Private package
1200: l_adj_amt := p_adj_amt;
1201: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'p_reval_type', p_reval_type, p_log_level_rec => p_log_level_rec);
1202: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'l_adj_amt', l_adj_amt, p_log_level_rec => p_log_level_rec);
1203:
1204: IF p_reval_type = 'A'
1205: THEN
1206: OPEN c_asset_cur; -- Start Asset cursor

Line 1226: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'before calling ', 'fa_sorp_link_reval_dd', p_log_level_rec => p_log_level_rec);

1222: -- v_calc_imp_deprn_effect = depreciation impact on the I/E
1223: -- v_calc_imp_impact = (v_calc_imp_loss_amount - v_calc_imp_deprn_effect)
1224: /*Bug#7392015 - Call to calculate deprn effect for double dd depreciation nmehtod */
1225: if (p_log_level_rec.statement_level) then
1226: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'before calling ', 'fa_sorp_link_reval_dd', p_log_level_rec => p_log_level_rec);
1227: end if;
1228: if NOT fa_sorp_link_reval_dd(p_mass_reval_id,
1229: v_asset_id,
1230: v_book_type_code,

Line 1239: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'failed calling ', 'fa_sorp_link_reval_dd', p_log_level_rec => p_log_level_rec);

1235: x_deprn_rsv,
1236: x_impairment_amt,
1237: x_impair_split_flag,
1238: x_override_flag) THEN
1239: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'failed calling ', 'fa_sorp_link_reval_dd', p_log_level_rec => p_log_level_rec);
1240: END IF;
1241: if (p_log_level_rec.statement_level) then
1242: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'deprn reserve from fa_sorp_link_reval_dd :',x_deprn_rsv, p_log_level_rec => p_log_level_rec);
1243: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impairment_amt from fa_sorp_link_reval_dd :',x_impairment_amt, p_log_level_rec => p_log_level_rec);

Line 1242: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'deprn reserve from fa_sorp_link_reval_dd :',x_deprn_rsv, p_log_level_rec => p_log_level_rec);

1238: x_override_flag) THEN
1239: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'failed calling ', 'fa_sorp_link_reval_dd', p_log_level_rec => p_log_level_rec);
1240: END IF;
1241: if (p_log_level_rec.statement_level) then
1242: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'deprn reserve from fa_sorp_link_reval_dd :',x_deprn_rsv, p_log_level_rec => p_log_level_rec);
1243: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impairment_amt from fa_sorp_link_reval_dd :',x_impairment_amt, p_log_level_rec => p_log_level_rec);
1244: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impair_split_flag from fa_sorp_link_reval_dd :',x_impair_split_flag, p_log_level_rec => p_log_level_rec);
1245: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_override_flag from fa_sorp_link_reval_dd :',x_override_flag, p_log_level_rec => p_log_level_rec);
1246: end if;

Line 1243: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impairment_amt from fa_sorp_link_reval_dd :',x_impairment_amt, p_log_level_rec => p_log_level_rec);

1239: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'failed calling ', 'fa_sorp_link_reval_dd', p_log_level_rec => p_log_level_rec);
1240: END IF;
1241: if (p_log_level_rec.statement_level) then
1242: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'deprn reserve from fa_sorp_link_reval_dd :',x_deprn_rsv, p_log_level_rec => p_log_level_rec);
1243: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impairment_amt from fa_sorp_link_reval_dd :',x_impairment_amt, p_log_level_rec => p_log_level_rec);
1244: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impair_split_flag from fa_sorp_link_reval_dd :',x_impair_split_flag, p_log_level_rec => p_log_level_rec);
1245: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_override_flag from fa_sorp_link_reval_dd :',x_override_flag, p_log_level_rec => p_log_level_rec);
1246: end if;
1247:

Line 1244: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impair_split_flag from fa_sorp_link_reval_dd :',x_impair_split_flag, p_log_level_rec => p_log_level_rec);

1240: END IF;
1241: if (p_log_level_rec.statement_level) then
1242: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'deprn reserve from fa_sorp_link_reval_dd :',x_deprn_rsv, p_log_level_rec => p_log_level_rec);
1243: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impairment_amt from fa_sorp_link_reval_dd :',x_impairment_amt, p_log_level_rec => p_log_level_rec);
1244: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impair_split_flag from fa_sorp_link_reval_dd :',x_impair_split_flag, p_log_level_rec => p_log_level_rec);
1245: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_override_flag from fa_sorp_link_reval_dd :',x_override_flag, p_log_level_rec => p_log_level_rec);
1246: end if;
1247:
1248: /* if x_override_flag is 'YES' reset values calculated by existing cursor*/

Line 1245: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_override_flag from fa_sorp_link_reval_dd :',x_override_flag, p_log_level_rec => p_log_level_rec);

1241: if (p_log_level_rec.statement_level) then
1242: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'deprn reserve from fa_sorp_link_reval_dd :',x_deprn_rsv, p_log_level_rec => p_log_level_rec);
1243: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impairment_amt from fa_sorp_link_reval_dd :',x_impairment_amt, p_log_level_rec => p_log_level_rec);
1244: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impair_split_flag from fa_sorp_link_reval_dd :',x_impair_split_flag, p_log_level_rec => p_log_level_rec);
1245: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_override_flag from fa_sorp_link_reval_dd :',x_override_flag, p_log_level_rec => p_log_level_rec);
1246: end if;
1247:
1248: /* if x_override_flag is 'YES' reset values calculated by existing cursor*/
1249: if nvl(x_override_flag,'NO')='YES' then

Line 1277: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1273: end if;
1274:
1275: IF v_reverse_imp_amt < l_adj_amt -- Start v_reverse_imp_amt < l_adj_amt
1276: THEN
1277: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1278: 'v_reverse_imp_amt < l_adj_amt',
1279: v_reverse_imp_amt < l_adj_amt
1280: , p_log_level_rec => p_log_level_rec);
1281: v_temp_imp_impact := NVL (v_temp_imp_impact, 0) + v_imp_impact;

Line 1283: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1279: v_reverse_imp_amt < l_adj_amt
1280: , p_log_level_rec => p_log_level_rec);
1281: v_temp_imp_impact := NVL (v_temp_imp_impact, 0) + v_imp_impact;
1282: v_temp_imp_deprn_effect := v_imp_deprn_effect;
1283: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1284: 'v_temp_imp_impact',
1285: v_temp_imp_impact
1286: , p_log_level_rec => p_log_level_rec);
1287: fa_debug_pkg.ADD ('fa_sorp_link_reval',

Line 1287: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1283: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1284: 'v_temp_imp_impact',
1285: v_temp_imp_impact
1286: , p_log_level_rec => p_log_level_rec);
1287: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1288: 'v_temp_imp_deprn_effect',
1289: v_temp_imp_deprn_effect
1290: , p_log_level_rec => p_log_level_rec);
1291: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'l_adj_amt', l_adj_amt, p_log_level_rec => p_log_level_rec);

Line 1291: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'l_adj_amt', l_adj_amt, p_log_level_rec => p_log_level_rec);

1287: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1288: 'v_temp_imp_deprn_effect',
1289: v_temp_imp_deprn_effect
1290: , p_log_level_rec => p_log_level_rec);
1291: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'l_adj_amt', l_adj_amt, p_log_level_rec => p_log_level_rec);
1292: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1293: 'v_calc_imp_impact',
1294: v_calc_imp_impact
1295: , p_log_level_rec => p_log_level_rec);

Line 1292: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1288: 'v_temp_imp_deprn_effect',
1289: v_temp_imp_deprn_effect
1290: , p_log_level_rec => p_log_level_rec);
1291: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'l_adj_amt', l_adj_amt, p_log_level_rec => p_log_level_rec);
1292: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1293: 'v_calc_imp_impact',
1294: v_calc_imp_impact
1295: , p_log_level_rec => p_log_level_rec);
1296: l_reval_gain := l_adj_amt - v_calc_imp_impact;

Line 1297: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1293: 'v_calc_imp_impact',
1294: v_calc_imp_impact
1295: , p_log_level_rec => p_log_level_rec);
1296: l_reval_gain := l_adj_amt - v_calc_imp_impact;
1297: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1298: 'v_reverse_imp_amt < l_adj_amt',
1299: v_reverse_imp_amt < l_adj_amt
1300: , p_log_level_rec => p_log_level_rec);
1301: x_reval_rsv_deprn_effect := 0;

Line 1380: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1376: '-1',
1377: SYSDATE
1378: );
1379:
1380: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1381: 'Adjustment(Delta) Amount(A)',
1382: p_adj_amt
1383: );
1384: fa_debug_pkg.ADD ('fa_sorp_link_reval',

Line 1384: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1380: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1381: 'Adjustment(Delta) Amount(A)',
1382: p_adj_amt
1383: );
1384: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1385: 'Impairment Loss Impact(B)',
1386: v_temp_imp_impact
1387: );
1388: fa_debug_pkg.ADD ('fa_sorp_link_reval',

Line 1388: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1384: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1385: 'Impairment Loss Impact(B)',
1386: v_temp_imp_impact
1387: );
1388: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1389: 'Reval Gain(C)',
1390: l_reval_gain
1391: );
1392: -- If v_sum is greater than or equal to adjustment amount

Line 1395: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1391: );
1392: -- If v_sum is greater than or equal to adjustment amount
1393: ELSIF v_reverse_imp_amt >= l_adj_amt
1394: THEN
1395: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1396: 'v_reverse_imp_amt >= l_adj_amt',
1397: 'v_reverse_imp_amt >= l_adj_amt'
1398: , p_log_level_rec => p_log_level_rec);
1399: -- Bug#7524125

Line 1402: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1398: , p_log_level_rec => p_log_level_rec);
1399: -- Bug#7524125
1400: IF l_adj_amt < v_calc_imp_impact
1401: THEN
1402: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1403: 'l_adj_amt < v_calc_imp_impact',
1404: 'l_adj_amt < v_calc_imp_impact'
1405: , p_log_level_rec => p_log_level_rec);
1406:

Line 1416: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1412: l_reval_gain :=0;
1413: l_reval_gain_temp := 0;
1414: ELSIF l_adj_amt >= v_calc_imp_impact
1415: THEN
1416: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1417: 'l_adj_amt >= v_calc_imp_impact',
1418: 'l_adj_amt >= v_calc_imp_impact'
1419: , p_log_level_rec => p_log_level_rec);
1420: l_new_reverse_amt :=

Line 1444: fa_debug_pkg.ADD ('fa_sorp_link_reval','first time l_temp_reverse_rsv_amount',l_temp_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);

1440: ELSIF l_reval_gain >= v_reval_rsv_adj_amount
1441: THEN */
1442: l_temp_reverse_rsv_amount :=v_reval_rsv_adj_amount;
1443:
1444: fa_debug_pkg.ADD ('fa_sorp_link_reval','first time l_temp_reverse_rsv_amount',l_temp_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);
1445:
1446: l_temp_reval_rsv_deprn_effect :=
1447: fa_imp_deprn_eff_fn (v_impairment_id,
1448: v_book_type_code,

Line 1454: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_temp_reval_rsv_deprn_effect',l_temp_reval_rsv_deprn_effect, p_log_level_rec => p_log_level_rec);

1450: 'R',
1451: l_temp_reverse_rsv_amount
1452: );
1453:
1454: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_temp_reval_rsv_deprn_effect',l_temp_reval_rsv_deprn_effect, p_log_level_rec => p_log_level_rec);
1455:
1456: l_temp_reverse_rsv_amount := nvl(l_temp_reverse_rsv_amount,0) - nvl(l_temp_reval_rsv_deprn_effect,0);
1457:
1458: fa_debug_pkg.ADD ('fa_sorp_link_reval','second time l_temp_reverse_rsv_amount',l_temp_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);

Line 1458: fa_debug_pkg.ADD ('fa_sorp_link_reval','second time l_temp_reverse_rsv_amount',l_temp_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);

1454: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_temp_reval_rsv_deprn_effect',l_temp_reval_rsv_deprn_effect, p_log_level_rec => p_log_level_rec);
1455:
1456: l_temp_reverse_rsv_amount := nvl(l_temp_reverse_rsv_amount,0) - nvl(l_temp_reval_rsv_deprn_effect,0);
1457:
1458: fa_debug_pkg.ADD ('fa_sorp_link_reval','second time l_temp_reverse_rsv_amount',l_temp_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);
1459:
1460: if l_temp_reverse_rsv_amount > l_adj_amt - v_calc_imp_impact then
1461:
1462: l_reverse_rsv_amount := l_adj_amt-v_calc_imp_impact;

Line 1464: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_reverse_rsv_amount',l_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);

1460: if l_temp_reverse_rsv_amount > l_adj_amt - v_calc_imp_impact then
1461:
1462: l_reverse_rsv_amount := l_adj_amt-v_calc_imp_impact;
1463:
1464: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_reverse_rsv_amount',l_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);
1465:
1466: l_reval_rsv_deprn_effect := round((l_reverse_rsv_amount*nvl(l_temp_reval_rsv_deprn_effect,0))/l_temp_reverse_rsv_amount,2);
1467:
1468: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_reval_rsv_deprn_effect',l_reval_rsv_deprn_effect, p_log_level_rec => p_log_level_rec);

Line 1468: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_reval_rsv_deprn_effect',l_reval_rsv_deprn_effect, p_log_level_rec => p_log_level_rec);

1464: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_reverse_rsv_amount',l_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);
1465:
1466: l_reval_rsv_deprn_effect := round((l_reverse_rsv_amount*nvl(l_temp_reval_rsv_deprn_effect,0))/l_temp_reverse_rsv_amount,2);
1467:
1468: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_reval_rsv_deprn_effect',l_reval_rsv_deprn_effect, p_log_level_rec => p_log_level_rec);
1469: else
1470: l_reverse_rsv_amount := l_temp_reverse_rsv_amount;
1471: l_reval_rsv_deprn_effect := l_temp_reval_rsv_deprn_effect;
1472:

Line 1540: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1536: END IF; -- End v_reverse_imp_amt < l_adj_amt
1537:
1538: CLOSE c_asset_cur; -- End Asset cur
1539:
1540: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1541: 'Adjustment(Delta) Amount(A)',
1542: p_adj_amt
1543: );
1544: fa_debug_pkg.ADD ('fa_sorp_link_reval',

Line 1544: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1540: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1541: 'Adjustment(Delta) Amount(A)',
1542: p_adj_amt
1543: );
1544: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1545: 'Impairment Loss Impact(B)',
1546: l_new_reverse_amt
1547: );
1548: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'Reval Gain(C)',

Line 1548: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'Reval Gain(C)',

1544: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1545: 'Impairment Loss Impact(B)',
1546: l_new_reverse_amt
1547: );
1548: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'Reval Gain(C)',
1549: l_reval_gain);
1550: END IF;
1551:
1552: IF p_reval_type = 'C'

Line 1567: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'before calling ', 'fa_sorp_link_reval_dd', p_log_level_rec => p_log_level_rec);

1563:
1564: /*Bug#7392015 - Call to calculate deprn effect for double dd depreciation nmehtod */
1565: if v_impairment_id is not null then
1566: if (p_log_level_rec.statement_level) then
1567: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'before calling ', 'fa_sorp_link_reval_dd', p_log_level_rec => p_log_level_rec);
1568: end if;
1569: if NOT fa_sorp_link_reval_dd(p_mass_reval_id,
1570: v_asset_id,
1571: v_book_type_code,

Line 1580: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'failed calling ', 'fa_sorp_link_reval_dd', p_log_level_rec => p_log_level_rec);

1576: x_deprn_rsv,
1577: x_impairment_amt,
1578: x_impair_split_flag,
1579: x_override_flag) THEN
1580: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'failed calling ', 'fa_sorp_link_reval_dd', p_log_level_rec => p_log_level_rec);
1581: END IF;
1582: if (p_log_level_rec.statement_level) then
1583: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'deprn reserve from fa_sorp_link_reval_dd :',x_deprn_rsv, p_log_level_rec => p_log_level_rec);
1584: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impairment_amt from fa_sorp_link_reval_dd :',x_impairment_amt, p_log_level_rec => p_log_level_rec);

Line 1583: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'deprn reserve from fa_sorp_link_reval_dd :',x_deprn_rsv, p_log_level_rec => p_log_level_rec);

1579: x_override_flag) THEN
1580: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'failed calling ', 'fa_sorp_link_reval_dd', p_log_level_rec => p_log_level_rec);
1581: END IF;
1582: if (p_log_level_rec.statement_level) then
1583: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'deprn reserve from fa_sorp_link_reval_dd :',x_deprn_rsv, p_log_level_rec => p_log_level_rec);
1584: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impairment_amt from fa_sorp_link_reval_dd :',x_impairment_amt, p_log_level_rec => p_log_level_rec);
1585: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impair_split_flag from fa_sorp_link_reval_dd :',x_impair_split_flag, p_log_level_rec => p_log_level_rec);
1586: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_override_flag from fa_sorp_link_reval_dd :',x_override_flag, p_log_level_rec => p_log_level_rec);
1587: end if;

Line 1584: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impairment_amt from fa_sorp_link_reval_dd :',x_impairment_amt, p_log_level_rec => p_log_level_rec);

1580: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'failed calling ', 'fa_sorp_link_reval_dd', p_log_level_rec => p_log_level_rec);
1581: END IF;
1582: if (p_log_level_rec.statement_level) then
1583: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'deprn reserve from fa_sorp_link_reval_dd :',x_deprn_rsv, p_log_level_rec => p_log_level_rec);
1584: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impairment_amt from fa_sorp_link_reval_dd :',x_impairment_amt, p_log_level_rec => p_log_level_rec);
1585: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impair_split_flag from fa_sorp_link_reval_dd :',x_impair_split_flag, p_log_level_rec => p_log_level_rec);
1586: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_override_flag from fa_sorp_link_reval_dd :',x_override_flag, p_log_level_rec => p_log_level_rec);
1587: end if;
1588: if nvl(x_override_flag,'NO')='YES' then

Line 1585: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impair_split_flag from fa_sorp_link_reval_dd :',x_impair_split_flag, p_log_level_rec => p_log_level_rec);

1581: END IF;
1582: if (p_log_level_rec.statement_level) then
1583: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'deprn reserve from fa_sorp_link_reval_dd :',x_deprn_rsv, p_log_level_rec => p_log_level_rec);
1584: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impairment_amt from fa_sorp_link_reval_dd :',x_impairment_amt, p_log_level_rec => p_log_level_rec);
1585: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impair_split_flag from fa_sorp_link_reval_dd :',x_impair_split_flag, p_log_level_rec => p_log_level_rec);
1586: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_override_flag from fa_sorp_link_reval_dd :',x_override_flag, p_log_level_rec => p_log_level_rec);
1587: end if;
1588: if nvl(x_override_flag,'NO')='YES' then
1589: if nvl(x_impair_split_flag,'NO') = 'NO' then

Line 1586: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_override_flag from fa_sorp_link_reval_dd :',x_override_flag, p_log_level_rec => p_log_level_rec);

1582: if (p_log_level_rec.statement_level) then
1583: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'deprn reserve from fa_sorp_link_reval_dd :',x_deprn_rsv, p_log_level_rec => p_log_level_rec);
1584: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impairment_amt from fa_sorp_link_reval_dd :',x_impairment_amt, p_log_level_rec => p_log_level_rec);
1585: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_impair_split_flag from fa_sorp_link_reval_dd :',x_impair_split_flag, p_log_level_rec => p_log_level_rec);
1586: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'x_override_flag from fa_sorp_link_reval_dd :',x_override_flag, p_log_level_rec => p_log_level_rec);
1587: end if;
1588: if nvl(x_override_flag,'NO')='YES' then
1589: if nvl(x_impair_split_flag,'NO') = 'NO' then
1590: v_imp_deprn_effect := x_deprn_rsv;

Line 1595: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'v_calc_imp_deprn_effect from fa_sorp_link_reval_dd :',v_calc_imp_deprn_effect, p_log_level_rec => p_log_level_rec);

1591: v_imp_impact := v_reverse_imp_amt - v_imp_deprn_effect;
1592: v_calc_imp_deprn_effect := x_deprn_rsv;
1593: if (x_impairment_amt <> 0) then
1594: v_calc_imp_deprn_effect := round((x_deprn_rsv * v_reverse_imp_amt)/x_impairment_amt,2);
1595: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'v_calc_imp_deprn_effect from fa_sorp_link_reval_dd :',v_calc_imp_deprn_effect, p_log_level_rec => p_log_level_rec);
1596: end if;
1597: v_calc_imp_impact := v_calc_imp_loss_amount - v_calc_imp_deprn_effect;
1598: elsif x_impair_split_flag = 'YES' then
1599: v_calc_imp_deprn_effect := x_deprn_rsv;

Line 1604: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'v_imp_deprn_effect from fa_sorp_link_reval_dd :',v_imp_deprn_effect, p_log_level_rec => p_log_level_rec);

1600: v_calc_imp_impact := v_calc_imp_loss_amount - v_calc_imp_deprn_effect;
1601: v_imp_deprn_effect := x_deprn_rsv;
1602: if (x_impairment_amt <> 0) then
1603: v_imp_deprn_effect := round((x_deprn_rsv * x_impairment_amt)/v_reverse_imp_amt,2);
1604: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'v_imp_deprn_effect from fa_sorp_link_reval_dd :',v_imp_deprn_effect, p_log_level_rec => p_log_level_rec);
1605: end if;
1606: v_imp_impact := v_reverse_imp_amt - v_imp_deprn_effect;
1607: end if;
1608: end if; --nvl(x_override_flag,'NO')='YES'

Line 1695: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1691: '-1',
1692: SYSDATE
1693: );
1694:
1695: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1696: 'Adjustment(Delta) Amount(A)',
1697: p_adj_amt
1698: );
1699: fa_debug_pkg.ADD ('fa_sorp_link_reval',

Line 1699: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1695: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1696: 'Adjustment(Delta) Amount(A)',
1697: p_adj_amt
1698: );
1699: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1700: 'Impairment Loss Impact(B)',
1701: v_calc_imp_impact
1702: );
1703: fa_debug_pkg.ADD ('fa_sorp_link_reval',

Line 1703: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1699: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1700: 'Impairment Loss Impact(B)',
1701: v_calc_imp_impact
1702: );
1703: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1704: 'Reval Gain(C)',
1705: l_reval_gain
1706: );
1707: ELSIF v_reverse_imp_amt >= l_adj_amt

Line 1709: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1705: l_reval_gain
1706: );
1707: ELSIF v_reverse_imp_amt >= l_adj_amt
1708: THEN
1709: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1710: 'v_reverse_imp_amt >= l_adj_amt',
1711: 'v_reverse_imp_amt >= l_adj_amt'
1712: , p_log_level_rec => p_log_level_rec);
1713: -- Bug#7524125

Line 1716: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1712: , p_log_level_rec => p_log_level_rec);
1713: -- Bug#7524125
1714: IF l_adj_amt < v_calc_imp_impact
1715: THEN
1716: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1717: 'l_adj_amt < v_calc_imp_impact',
1718: 'l_adj_amt < v_calc_imp_impact'
1719: , p_log_level_rec => p_log_level_rec);
1720:

Line 1730: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1726: l_reval_gain :=0;
1727: l_reval_gain_temp := 0;
1728: ELSIF l_adj_amt >= v_calc_imp_impact
1729: THEN
1730: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1731: 'l_adj_amt >= v_calc_imp_impact',
1732: 'l_adj_amt >= v_calc_imp_impact'
1733: , p_log_level_rec => p_log_level_rec);
1734: l_new_reverse_amt :=

Line 1759: fa_debug_pkg.ADD ('fa_sorp_link_reval','first time l_temp_reverse_rsv_amount',l_temp_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);

1755: ELSIF l_reval_gain >= v_reval_rsv_adj_amount
1756: THEN */
1757: l_temp_reverse_rsv_amount :=v_reval_rsv_adj_amount;
1758:
1759: fa_debug_pkg.ADD ('fa_sorp_link_reval','first time l_temp_reverse_rsv_amount',l_temp_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);
1760:
1761: l_temp_reval_rsv_deprn_effect :=
1762: fa_imp_deprn_eff_fn (v_impairment_id,
1763: v_book_type_code,

Line 1769: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_temp_reval_rsv_deprn_effect',l_temp_reval_rsv_deprn_effect, p_log_level_rec => p_log_level_rec);

1765: 'R',
1766: l_temp_reverse_rsv_amount
1767: );
1768:
1769: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_temp_reval_rsv_deprn_effect',l_temp_reval_rsv_deprn_effect, p_log_level_rec => p_log_level_rec);
1770:
1771: l_temp_reverse_rsv_amount := nvl(l_temp_reverse_rsv_amount,0) - nvl(l_temp_reval_rsv_deprn_effect,0);
1772:
1773: fa_debug_pkg.ADD ('fa_sorp_link_reval','second time l_temp_reverse_rsv_amount',l_temp_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);

Line 1773: fa_debug_pkg.ADD ('fa_sorp_link_reval','second time l_temp_reverse_rsv_amount',l_temp_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);

1769: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_temp_reval_rsv_deprn_effect',l_temp_reval_rsv_deprn_effect, p_log_level_rec => p_log_level_rec);
1770:
1771: l_temp_reverse_rsv_amount := nvl(l_temp_reverse_rsv_amount,0) - nvl(l_temp_reval_rsv_deprn_effect,0);
1772:
1773: fa_debug_pkg.ADD ('fa_sorp_link_reval','second time l_temp_reverse_rsv_amount',l_temp_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);
1774:
1775: if l_temp_reverse_rsv_amount > l_adj_amt - v_calc_imp_impact then
1776:
1777: l_reverse_rsv_amount := l_adj_amt-v_calc_imp_impact;

Line 1779: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_reverse_rsv_amount',l_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);

1775: if l_temp_reverse_rsv_amount > l_adj_amt - v_calc_imp_impact then
1776:
1777: l_reverse_rsv_amount := l_adj_amt-v_calc_imp_impact;
1778:
1779: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_reverse_rsv_amount',l_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);
1780:
1781: l_reval_rsv_deprn_effect := round((l_reverse_rsv_amount*nvl(l_temp_reval_rsv_deprn_effect,0))/l_temp_reverse_rsv_amount,2);
1782:
1783: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_reval_rsv_deprn_effect',l_reval_rsv_deprn_effect, p_log_level_rec => p_log_level_rec);

Line 1783: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_reval_rsv_deprn_effect',l_reval_rsv_deprn_effect, p_log_level_rec => p_log_level_rec);

1779: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_reverse_rsv_amount',l_reverse_rsv_amount, p_log_level_rec => p_log_level_rec);
1780:
1781: l_reval_rsv_deprn_effect := round((l_reverse_rsv_amount*nvl(l_temp_reval_rsv_deprn_effect,0))/l_temp_reverse_rsv_amount,2);
1782:
1783: fa_debug_pkg.ADD ('fa_sorp_link_reval','l_reval_rsv_deprn_effect',l_reval_rsv_deprn_effect, p_log_level_rec => p_log_level_rec);
1784: else
1785: l_reverse_rsv_amount := l_temp_reverse_rsv_amount;
1786: l_reval_rsv_deprn_effect := l_temp_reval_rsv_deprn_effect;
1787:

Line 1855: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1851: END IF;
1852:
1853: CLOSE c_cat_cur;
1854:
1855: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1856: 'Adjustment(Delta) Amount(A)',
1857: p_adj_amt
1858: );
1859: fa_debug_pkg.ADD ('fa_sorp_link_reval',

Line 1859: fa_debug_pkg.ADD ('fa_sorp_link_reval',

1855: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1856: 'Adjustment(Delta) Amount(A)',
1857: p_adj_amt
1858: );
1859: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1860: 'Impairment Loss Impact(B)',
1861: l_new_reverse_amt
1862: );
1863: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'Reval Gain(C)',

Line 1863: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'Reval Gain(C)',

1859: fa_debug_pkg.ADD ('fa_sorp_link_reval',
1860: 'Impairment Loss Impact(B)',
1861: l_new_reverse_amt
1862: );
1863: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'Reval Gain(C)',
1864: l_reval_gain);
1865: END IF;
1866:
1867: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'End', 'End', p_log_level_rec => p_log_level_rec);

Line 1867: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'End', 'End', p_log_level_rec => p_log_level_rec);

1863: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'Reval Gain(C)',
1864: l_reval_gain);
1865: END IF;
1866:
1867: fa_debug_pkg.ADD ('fa_sorp_link_reval', 'End', 'End', p_log_level_rec => p_log_level_rec);
1868: END fa_sorp_link_reval;
1869:
1870: /* Procedure updates FA_ITF_IMPAIRMENTS with reversed amounts
1871:

Line 2185: fa_debug_pkg.ADD (l_calling_fn,'Transaction _header_id :: ',c_th_id, p_log_level_rec => p_log_level_rec);

2181: close c_mc_get_sum_reval_losses;
2182: end if;
2183:
2184: IF (p_log_level_rec.statement_level) THEN
2185: fa_debug_pkg.ADD (l_calling_fn,'Transaction _header_id :: ',c_th_id, p_log_level_rec => p_log_level_rec);
2186: fa_debug_pkg.ADD (l_calling_fn,'REVAL LOSS amount :: ',c_reval_loss_amount, p_log_level_rec => p_log_level_rec);
2187: fa_debug_pkg.ADD (l_calling_fn,'period counter :: ',c_loss_period_counter, p_log_level_rec => p_log_level_rec);
2188: fa_debug_pkg.ADD (l_calling_fn,'Un reversed reval loss amount :: ',c_unreversed_loss_amt, p_log_level_rec => p_log_level_rec);
2189: fa_debug_pkg.ADD (l_calling_fn,'Reval loss reversed so far for current period counter :: ',l_loss_cpc, p_log_level_rec => p_log_level_rec);

Line 2186: fa_debug_pkg.ADD (l_calling_fn,'REVAL LOSS amount :: ',c_reval_loss_amount, p_log_level_rec => p_log_level_rec);

2182: end if;
2183:
2184: IF (p_log_level_rec.statement_level) THEN
2185: fa_debug_pkg.ADD (l_calling_fn,'Transaction _header_id :: ',c_th_id, p_log_level_rec => p_log_level_rec);
2186: fa_debug_pkg.ADD (l_calling_fn,'REVAL LOSS amount :: ',c_reval_loss_amount, p_log_level_rec => p_log_level_rec);
2187: fa_debug_pkg.ADD (l_calling_fn,'period counter :: ',c_loss_period_counter, p_log_level_rec => p_log_level_rec);
2188: fa_debug_pkg.ADD (l_calling_fn,'Un reversed reval loss amount :: ',c_unreversed_loss_amt, p_log_level_rec => p_log_level_rec);
2189: fa_debug_pkg.ADD (l_calling_fn,'Reval loss reversed so far for current period counter :: ',l_loss_cpc, p_log_level_rec => p_log_level_rec);
2190: fa_debug_pkg.ADD (l_calling_fn,'Sum of losses(if any) after current :: ',c_reval_loss_sum, p_log_level_rec => p_log_level_rec);

Line 2187: fa_debug_pkg.ADD (l_calling_fn,'period counter :: ',c_loss_period_counter, p_log_level_rec => p_log_level_rec);

2183:
2184: IF (p_log_level_rec.statement_level) THEN
2185: fa_debug_pkg.ADD (l_calling_fn,'Transaction _header_id :: ',c_th_id, p_log_level_rec => p_log_level_rec);
2186: fa_debug_pkg.ADD (l_calling_fn,'REVAL LOSS amount :: ',c_reval_loss_amount, p_log_level_rec => p_log_level_rec);
2187: fa_debug_pkg.ADD (l_calling_fn,'period counter :: ',c_loss_period_counter, p_log_level_rec => p_log_level_rec);
2188: fa_debug_pkg.ADD (l_calling_fn,'Un reversed reval loss amount :: ',c_unreversed_loss_amt, p_log_level_rec => p_log_level_rec);
2189: fa_debug_pkg.ADD (l_calling_fn,'Reval loss reversed so far for current period counter :: ',l_loss_cpc, p_log_level_rec => p_log_level_rec);
2190: fa_debug_pkg.ADD (l_calling_fn,'Sum of losses(if any) after current :: ',c_reval_loss_sum, p_log_level_rec => p_log_level_rec);
2191: END IF;

Line 2188: fa_debug_pkg.ADD (l_calling_fn,'Un reversed reval loss amount :: ',c_unreversed_loss_amt, p_log_level_rec => p_log_level_rec);

2184: IF (p_log_level_rec.statement_level) THEN
2185: fa_debug_pkg.ADD (l_calling_fn,'Transaction _header_id :: ',c_th_id, p_log_level_rec => p_log_level_rec);
2186: fa_debug_pkg.ADD (l_calling_fn,'REVAL LOSS amount :: ',c_reval_loss_amount, p_log_level_rec => p_log_level_rec);
2187: fa_debug_pkg.ADD (l_calling_fn,'period counter :: ',c_loss_period_counter, p_log_level_rec => p_log_level_rec);
2188: fa_debug_pkg.ADD (l_calling_fn,'Un reversed reval loss amount :: ',c_unreversed_loss_amt, p_log_level_rec => p_log_level_rec);
2189: fa_debug_pkg.ADD (l_calling_fn,'Reval loss reversed so far for current period counter :: ',l_loss_cpc, p_log_level_rec => p_log_level_rec);
2190: fa_debug_pkg.ADD (l_calling_fn,'Sum of losses(if any) after current :: ',c_reval_loss_sum, p_log_level_rec => p_log_level_rec);
2191: END IF;
2192:

Line 2189: fa_debug_pkg.ADD (l_calling_fn,'Reval loss reversed so far for current period counter :: ',l_loss_cpc, p_log_level_rec => p_log_level_rec);

2185: fa_debug_pkg.ADD (l_calling_fn,'Transaction _header_id :: ',c_th_id, p_log_level_rec => p_log_level_rec);
2186: fa_debug_pkg.ADD (l_calling_fn,'REVAL LOSS amount :: ',c_reval_loss_amount, p_log_level_rec => p_log_level_rec);
2187: fa_debug_pkg.ADD (l_calling_fn,'period counter :: ',c_loss_period_counter, p_log_level_rec => p_log_level_rec);
2188: fa_debug_pkg.ADD (l_calling_fn,'Un reversed reval loss amount :: ',c_unreversed_loss_amt, p_log_level_rec => p_log_level_rec);
2189: fa_debug_pkg.ADD (l_calling_fn,'Reval loss reversed so far for current period counter :: ',l_loss_cpc, p_log_level_rec => p_log_level_rec);
2190: fa_debug_pkg.ADD (l_calling_fn,'Sum of losses(if any) after current :: ',c_reval_loss_sum, p_log_level_rec => p_log_level_rec);
2191: END IF;
2192:
2193: c_unreversed_loss_amt := c_unreversed_loss_amt - nvl(c_reval_loss_sum,0) - l_loss_cpc;

Line 2190: fa_debug_pkg.ADD (l_calling_fn,'Sum of losses(if any) after current :: ',c_reval_loss_sum, p_log_level_rec => p_log_level_rec);

2186: fa_debug_pkg.ADD (l_calling_fn,'REVAL LOSS amount :: ',c_reval_loss_amount, p_log_level_rec => p_log_level_rec);
2187: fa_debug_pkg.ADD (l_calling_fn,'period counter :: ',c_loss_period_counter, p_log_level_rec => p_log_level_rec);
2188: fa_debug_pkg.ADD (l_calling_fn,'Un reversed reval loss amount :: ',c_unreversed_loss_amt, p_log_level_rec => p_log_level_rec);
2189: fa_debug_pkg.ADD (l_calling_fn,'Reval loss reversed so far for current period counter :: ',l_loss_cpc, p_log_level_rec => p_log_level_rec);
2190: fa_debug_pkg.ADD (l_calling_fn,'Sum of losses(if any) after current :: ',c_reval_loss_sum, p_log_level_rec => p_log_level_rec);
2191: END IF;
2192:
2193: c_unreversed_loss_amt := c_unreversed_loss_amt - nvl(c_reval_loss_sum,0) - l_loss_cpc;
2194: IF (p_log_level_rec.statement_level) THEN

Line 2195: fa_debug_pkg.ADD (l_calling_fn,'Un reversed reval loss amount for current loss:: ',c_unreversed_loss_amt, p_log_level_rec => p_log_level_rec);

2191: END IF;
2192:
2193: c_unreversed_loss_amt := c_unreversed_loss_amt - nvl(c_reval_loss_sum,0) - l_loss_cpc;
2194: IF (p_log_level_rec.statement_level) THEN
2195: fa_debug_pkg.ADD (l_calling_fn,'Un reversed reval loss amount for current loss:: ',c_unreversed_loss_amt, p_log_level_rec => p_log_level_rec);
2196: END IF;
2197: l_reval_loss := c_reval_loss_amount ;
2198:
2199: /*Need to calculated deprn effect only when some reval loss is pending for current loss row */

Line 2219: fa_debug_pkg.ADD (l_calling_fn,'Deprn effect :: ',l_deprn_exp, p_log_level_rec => p_log_level_rec);

2215: else
2216: goto skip_row; --This loss is already reversed goto next loss
2217: end if;
2218: IF (p_log_level_rec.statement_level) THEN
2219: fa_debug_pkg.ADD (l_calling_fn,'Deprn effect :: ',l_deprn_exp, p_log_level_rec => p_log_level_rec);
2220: END IF;
2221:
2222: /* if partial reversal of reval loss has happened earlier then prorate expenses accordingly.*/
2223: IF c_unreversed_loss_amt < c_reval_loss_amount THEN

Line 2237: fa_debug_pkg.ADD (l_calling_fn,'Deprn effect at 1 :: ',l_deprn_exp, p_log_level_rec => p_log_level_rec);

2233: END if;
2234:
2235: l_net_reval_loss := l_reval_loss - l_deprn_exp; /*Calculate net revaluation loss */
2236: IF (p_log_level_rec.statement_level) THEN
2237: fa_debug_pkg.ADD (l_calling_fn,'Deprn effect at 1 :: ',l_deprn_exp, p_log_level_rec => p_log_level_rec);
2238: fa_debug_pkg.ADD (l_calling_fn,'Reval loss amount at 1 :: ',l_reval_loss, p_log_level_rec => p_log_level_rec);
2239: fa_debug_pkg.ADD (l_calling_fn,'Net revaluation loss amount at 1 :: ',l_net_reval_loss, p_log_level_rec => p_log_level_rec);
2240: fa_debug_pkg.ADD (l_calling_fn,'Revaluation gain amount at 1 :: ',px_gain_amt, p_log_level_rec => p_log_level_rec);
2241: END IF;

Line 2238: fa_debug_pkg.ADD (l_calling_fn,'Reval loss amount at 1 :: ',l_reval_loss, p_log_level_rec => p_log_level_rec);

2234:
2235: l_net_reval_loss := l_reval_loss - l_deprn_exp; /*Calculate net revaluation loss */
2236: IF (p_log_level_rec.statement_level) THEN
2237: fa_debug_pkg.ADD (l_calling_fn,'Deprn effect at 1 :: ',l_deprn_exp, p_log_level_rec => p_log_level_rec);
2238: fa_debug_pkg.ADD (l_calling_fn,'Reval loss amount at 1 :: ',l_reval_loss, p_log_level_rec => p_log_level_rec);
2239: fa_debug_pkg.ADD (l_calling_fn,'Net revaluation loss amount at 1 :: ',l_net_reval_loss, p_log_level_rec => p_log_level_rec);
2240: fa_debug_pkg.ADD (l_calling_fn,'Revaluation gain amount at 1 :: ',px_gain_amt, p_log_level_rec => p_log_level_rec);
2241: END IF;
2242:

Line 2239: fa_debug_pkg.ADD (l_calling_fn,'Net revaluation loss amount at 1 :: ',l_net_reval_loss, p_log_level_rec => p_log_level_rec);

2235: l_net_reval_loss := l_reval_loss - l_deprn_exp; /*Calculate net revaluation loss */
2236: IF (p_log_level_rec.statement_level) THEN
2237: fa_debug_pkg.ADD (l_calling_fn,'Deprn effect at 1 :: ',l_deprn_exp, p_log_level_rec => p_log_level_rec);
2238: fa_debug_pkg.ADD (l_calling_fn,'Reval loss amount at 1 :: ',l_reval_loss, p_log_level_rec => p_log_level_rec);
2239: fa_debug_pkg.ADD (l_calling_fn,'Net revaluation loss amount at 1 :: ',l_net_reval_loss, p_log_level_rec => p_log_level_rec);
2240: fa_debug_pkg.ADD (l_calling_fn,'Revaluation gain amount at 1 :: ',px_gain_amt, p_log_level_rec => p_log_level_rec);
2241: END IF;
2242:
2243: /*if gain is less then net revaluation loss then prorate net revaluation loss and depreciation expense accordingly*/

Line 2240: fa_debug_pkg.ADD (l_calling_fn,'Revaluation gain amount at 1 :: ',px_gain_amt, p_log_level_rec => p_log_level_rec);

2236: IF (p_log_level_rec.statement_level) THEN
2237: fa_debug_pkg.ADD (l_calling_fn,'Deprn effect at 1 :: ',l_deprn_exp, p_log_level_rec => p_log_level_rec);
2238: fa_debug_pkg.ADD (l_calling_fn,'Reval loss amount at 1 :: ',l_reval_loss, p_log_level_rec => p_log_level_rec);
2239: fa_debug_pkg.ADD (l_calling_fn,'Net revaluation loss amount at 1 :: ',l_net_reval_loss, p_log_level_rec => p_log_level_rec);
2240: fa_debug_pkg.ADD (l_calling_fn,'Revaluation gain amount at 1 :: ',px_gain_amt, p_log_level_rec => p_log_level_rec);
2241: END IF;
2242:
2243: /*if gain is less then net revaluation loss then prorate net revaluation loss and depreciation expense accordingly*/
2244: if px_gain_amt < l_net_reval_loss then

Line 2263: fa_debug_pkg.ADD (l_calling_fn,'Deprn effect at 2:: ',l_deprn_exp, p_log_level_rec => p_log_level_rec);

2259:
2260: px_gain_amt := px_gain_amt - l_net_reval_loss ;
2261: l_loss_cpc := l_loss_cpc + (l_net_reval_loss + l_deprn_exp);
2262: IF (p_log_level_rec.statement_level) THEN
2263: fa_debug_pkg.ADD (l_calling_fn,'Deprn effect at 2:: ',l_deprn_exp, p_log_level_rec => p_log_level_rec);
2264: fa_debug_pkg.ADD (l_calling_fn,'Net revaluation loss amount at 2 :: ',l_net_reval_loss, p_log_level_rec => p_log_level_rec);
2265: fa_debug_pkg.ADD (l_calling_fn,'total Deprn effect :: ',l_tot_deprn_exp, p_log_level_rec => p_log_level_rec);
2266: fa_debug_pkg.ADD (l_calling_fn,'total revaluation loss expense amount :: ',l_tot_reval_loss_exp, p_log_level_rec => p_log_level_rec);
2267: fa_debug_pkg.ADD (l_calling_fn,'New revaluation gain amount :: ',px_gain_amt, p_log_level_rec => p_log_level_rec);

Line 2264: fa_debug_pkg.ADD (l_calling_fn,'Net revaluation loss amount at 2 :: ',l_net_reval_loss, p_log_level_rec => p_log_level_rec);

2260: px_gain_amt := px_gain_amt - l_net_reval_loss ;
2261: l_loss_cpc := l_loss_cpc + (l_net_reval_loss + l_deprn_exp);
2262: IF (p_log_level_rec.statement_level) THEN
2263: fa_debug_pkg.ADD (l_calling_fn,'Deprn effect at 2:: ',l_deprn_exp, p_log_level_rec => p_log_level_rec);
2264: fa_debug_pkg.ADD (l_calling_fn,'Net revaluation loss amount at 2 :: ',l_net_reval_loss, p_log_level_rec => p_log_level_rec);
2265: fa_debug_pkg.ADD (l_calling_fn,'total Deprn effect :: ',l_tot_deprn_exp, p_log_level_rec => p_log_level_rec);
2266: fa_debug_pkg.ADD (l_calling_fn,'total revaluation loss expense amount :: ',l_tot_reval_loss_exp, p_log_level_rec => p_log_level_rec);
2267: fa_debug_pkg.ADD (l_calling_fn,'New revaluation gain amount :: ',px_gain_amt, p_log_level_rec => p_log_level_rec);
2268: fa_debug_pkg.ADD (l_calling_fn,'Remaining reval loss amount :: ',(l_reval_loss -(l_net_reval_loss + l_deprn_exp)), p_log_level_rec => p_log_level_rec);

Line 2265: fa_debug_pkg.ADD (l_calling_fn,'total Deprn effect :: ',l_tot_deprn_exp, p_log_level_rec => p_log_level_rec);

2261: l_loss_cpc := l_loss_cpc + (l_net_reval_loss + l_deprn_exp);
2262: IF (p_log_level_rec.statement_level) THEN
2263: fa_debug_pkg.ADD (l_calling_fn,'Deprn effect at 2:: ',l_deprn_exp, p_log_level_rec => p_log_level_rec);
2264: fa_debug_pkg.ADD (l_calling_fn,'Net revaluation loss amount at 2 :: ',l_net_reval_loss, p_log_level_rec => p_log_level_rec);
2265: fa_debug_pkg.ADD (l_calling_fn,'total Deprn effect :: ',l_tot_deprn_exp, p_log_level_rec => p_log_level_rec);
2266: fa_debug_pkg.ADD (l_calling_fn,'total revaluation loss expense amount :: ',l_tot_reval_loss_exp, p_log_level_rec => p_log_level_rec);
2267: fa_debug_pkg.ADD (l_calling_fn,'New revaluation gain amount :: ',px_gain_amt, p_log_level_rec => p_log_level_rec);
2268: fa_debug_pkg.ADD (l_calling_fn,'Remaining reval loss amount :: ',(l_reval_loss -(l_net_reval_loss + l_deprn_exp)), p_log_level_rec => p_log_level_rec);
2269: fa_debug_pkg.ADD (l_calling_fn,'Reval loss reversed so far for current period counter at end:: ',l_loss_cpc, p_log_level_rec => p_log_level_rec);

Line 2266: fa_debug_pkg.ADD (l_calling_fn,'total revaluation loss expense amount :: ',l_tot_reval_loss_exp, p_log_level_rec => p_log_level_rec);

2262: IF (p_log_level_rec.statement_level) THEN
2263: fa_debug_pkg.ADD (l_calling_fn,'Deprn effect at 2:: ',l_deprn_exp, p_log_level_rec => p_log_level_rec);
2264: fa_debug_pkg.ADD (l_calling_fn,'Net revaluation loss amount at 2 :: ',l_net_reval_loss, p_log_level_rec => p_log_level_rec);
2265: fa_debug_pkg.ADD (l_calling_fn,'total Deprn effect :: ',l_tot_deprn_exp, p_log_level_rec => p_log_level_rec);
2266: fa_debug_pkg.ADD (l_calling_fn,'total revaluation loss expense amount :: ',l_tot_reval_loss_exp, p_log_level_rec => p_log_level_rec);
2267: fa_debug_pkg.ADD (l_calling_fn,'New revaluation gain amount :: ',px_gain_amt, p_log_level_rec => p_log_level_rec);
2268: fa_debug_pkg.ADD (l_calling_fn,'Remaining reval loss amount :: ',(l_reval_loss -(l_net_reval_loss + l_deprn_exp)), p_log_level_rec => p_log_level_rec);
2269: fa_debug_pkg.ADD (l_calling_fn,'Reval loss reversed so far for current period counter at end:: ',l_loss_cpc, p_log_level_rec => p_log_level_rec);
2270: END IF;

Line 2267: fa_debug_pkg.ADD (l_calling_fn,'New revaluation gain amount :: ',px_gain_amt, p_log_level_rec => p_log_level_rec);

2263: fa_debug_pkg.ADD (l_calling_fn,'Deprn effect at 2:: ',l_deprn_exp, p_log_level_rec => p_log_level_rec);
2264: fa_debug_pkg.ADD (l_calling_fn,'Net revaluation loss amount at 2 :: ',l_net_reval_loss, p_log_level_rec => p_log_level_rec);
2265: fa_debug_pkg.ADD (l_calling_fn,'total Deprn effect :: ',l_tot_deprn_exp, p_log_level_rec => p_log_level_rec);
2266: fa_debug_pkg.ADD (l_calling_fn,'total revaluation loss expense amount :: ',l_tot_reval_loss_exp, p_log_level_rec => p_log_level_rec);
2267: fa_debug_pkg.ADD (l_calling_fn,'New revaluation gain amount :: ',px_gain_amt, p_log_level_rec => p_log_level_rec);
2268: fa_debug_pkg.ADD (l_calling_fn,'Remaining reval loss amount :: ',(l_reval_loss -(l_net_reval_loss + l_deprn_exp)), p_log_level_rec => p_log_level_rec);
2269: fa_debug_pkg.ADD (l_calling_fn,'Reval loss reversed so far for current period counter at end:: ',l_loss_cpc, p_log_level_rec => p_log_level_rec);
2270: END IF;
2271:

Line 2268: fa_debug_pkg.ADD (l_calling_fn,'Remaining reval loss amount :: ',(l_reval_loss -(l_net_reval_loss + l_deprn_exp)), p_log_level_rec => p_log_level_rec);

2264: fa_debug_pkg.ADD (l_calling_fn,'Net revaluation loss amount at 2 :: ',l_net_reval_loss, p_log_level_rec => p_log_level_rec);
2265: fa_debug_pkg.ADD (l_calling_fn,'total Deprn effect :: ',l_tot_deprn_exp, p_log_level_rec => p_log_level_rec);
2266: fa_debug_pkg.ADD (l_calling_fn,'total revaluation loss expense amount :: ',l_tot_reval_loss_exp, p_log_level_rec => p_log_level_rec);
2267: fa_debug_pkg.ADD (l_calling_fn,'New revaluation gain amount :: ',px_gain_amt, p_log_level_rec => p_log_level_rec);
2268: fa_debug_pkg.ADD (l_calling_fn,'Remaining reval loss amount :: ',(l_reval_loss -(l_net_reval_loss + l_deprn_exp)), p_log_level_rec => p_log_level_rec);
2269: fa_debug_pkg.ADD (l_calling_fn,'Reval loss reversed so far for current period counter at end:: ',l_loss_cpc, p_log_level_rec => p_log_level_rec);
2270: END IF;
2271:
2272: IF (p_reval_options_rec.run_mode = 'RUN') THEN

Line 2269: fa_debug_pkg.ADD (l_calling_fn,'Reval loss reversed so far for current period counter at end:: ',l_loss_cpc, p_log_level_rec => p_log_level_rec);

2265: fa_debug_pkg.ADD (l_calling_fn,'total Deprn effect :: ',l_tot_deprn_exp, p_log_level_rec => p_log_level_rec);
2266: fa_debug_pkg.ADD (l_calling_fn,'total revaluation loss expense amount :: ',l_tot_reval_loss_exp, p_log_level_rec => p_log_level_rec);
2267: fa_debug_pkg.ADD (l_calling_fn,'New revaluation gain amount :: ',px_gain_amt, p_log_level_rec => p_log_level_rec);
2268: fa_debug_pkg.ADD (l_calling_fn,'Remaining reval loss amount :: ',(l_reval_loss -(l_net_reval_loss + l_deprn_exp)), p_log_level_rec => p_log_level_rec);
2269: fa_debug_pkg.ADD (l_calling_fn,'Reval loss reversed so far for current period counter at end:: ',l_loss_cpc, p_log_level_rec => p_log_level_rec);
2270: END IF;
2271:
2272: IF (p_reval_options_rec.run_mode = 'RUN') THEN
2273: IF p_mrc_sob_type_code = 'P' THEN

Line 2302: fa_debug_pkg.ADD (l_calling_fn,'Inside exception','calc_error', p_log_level_rec => p_log_level_rec);

2298: return true;
2299: EXCEPTION
2300: WHEN calc_error THEN
2301: IF (p_log_level_rec.statement_level) THEN
2302: fa_debug_pkg.ADD (l_calling_fn,'Inside exception','calc_error', p_log_level_rec => p_log_level_rec);
2303: END IF;
2304: RETURN FALSE;
2305: WHEN OTHERS THEN
2306: IF (p_log_level_rec.statement_level) THEN

Line 2307: fa_debug_pkg.ADD (l_calling_fn,'Inside exception','OTHERS', p_log_level_rec => p_log_level_rec);

2303: END IF;
2304: RETURN FALSE;
2305: WHEN OTHERS THEN
2306: IF (p_log_level_rec.statement_level) THEN
2307: fa_debug_pkg.ADD (l_calling_fn,'Inside exception','OTHERS', p_log_level_rec => p_log_level_rec);
2308: END IF;
2309: RETURN FALSE;
2310: end process_loss_reversal;
2311:

Line 2395: fa_debug_pkg.add(l_calling_fn, 'Starting fiscal year',l_beg_fiscal_yr, p_log_level_rec => p_log_level_rec);

2391: fetch c_get_fiscal_name into l_beg_fiscal_yr,l_beg_per_num;
2392: close c_get_fiscal_name;
2393:
2394: IF (p_log_level_rec.statement_level) THEN
2395: fa_debug_pkg.add(l_calling_fn, 'Starting fiscal year',l_beg_fiscal_yr, p_log_level_rec => p_log_level_rec);
2396: fa_debug_pkg.add(l_calling_fn, 'Starting l_beg_per_num',l_beg_per_num, p_log_level_rec => p_log_level_rec);
2397: fa_debug_pkg.add(l_calling_fn, 'Current period counter',p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);
2398: fa_debug_pkg.add(l_calling_fn, 'fetching','prior row', p_log_level_rec => p_log_level_rec);
2399: END IF;

Line 2396: fa_debug_pkg.add(l_calling_fn, 'Starting l_beg_per_num',l_beg_per_num, p_log_level_rec => p_log_level_rec);

2392: close c_get_fiscal_name;
2393:
2394: IF (p_log_level_rec.statement_level) THEN
2395: fa_debug_pkg.add(l_calling_fn, 'Starting fiscal year',l_beg_fiscal_yr, p_log_level_rec => p_log_level_rec);
2396: fa_debug_pkg.add(l_calling_fn, 'Starting l_beg_per_num',l_beg_per_num, p_log_level_rec => p_log_level_rec);
2397: fa_debug_pkg.add(l_calling_fn, 'Current period counter',p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);
2398: fa_debug_pkg.add(l_calling_fn, 'fetching','prior row', p_log_level_rec => p_log_level_rec);
2399: END IF;
2400:

Line 2397: fa_debug_pkg.add(l_calling_fn, 'Current period counter',p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);

2393:
2394: IF (p_log_level_rec.statement_level) THEN
2395: fa_debug_pkg.add(l_calling_fn, 'Starting fiscal year',l_beg_fiscal_yr, p_log_level_rec => p_log_level_rec);
2396: fa_debug_pkg.add(l_calling_fn, 'Starting l_beg_per_num',l_beg_per_num, p_log_level_rec => p_log_level_rec);
2397: fa_debug_pkg.add(l_calling_fn, 'Current period counter',p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);
2398: fa_debug_pkg.add(l_calling_fn, 'fetching','prior row', p_log_level_rec => p_log_level_rec);
2399: END IF;
2400:
2401: IF p_loss_pc = p_period_rec.period_counter then

Line 2398: fa_debug_pkg.add(l_calling_fn, 'fetching','prior row', p_log_level_rec => p_log_level_rec);

2394: IF (p_log_level_rec.statement_level) THEN
2395: fa_debug_pkg.add(l_calling_fn, 'Starting fiscal year',l_beg_fiscal_yr, p_log_level_rec => p_log_level_rec);
2396: fa_debug_pkg.add(l_calling_fn, 'Starting l_beg_per_num',l_beg_per_num, p_log_level_rec => p_log_level_rec);
2397: fa_debug_pkg.add(l_calling_fn, 'Current period counter',p_period_rec.period_counter, p_log_level_rec => p_log_level_rec);
2398: fa_debug_pkg.add(l_calling_fn, 'fetching','prior row', p_log_level_rec => p_log_level_rec);
2399: END IF;
2400:
2401: IF p_loss_pc = p_period_rec.period_counter then
2402: x_deprn_exp := 0;

Line 2477: fa_debug_pkg.add(l_calling_fn, 'ending fiscal year',l_dpr_in.y_end, p_log_level_rec => p_log_level_rec);

2473: l_dpr_in.p_cl_end := l_dpr_in.p_cl_end - 1;
2474: end if;
2475:
2476: IF (p_log_level_rec.statement_level) THEN
2477: fa_debug_pkg.add(l_calling_fn, 'ending fiscal year',l_dpr_in.y_end, p_log_level_rec => p_log_level_rec);
2478: fa_debug_pkg.add(l_calling_fn, 'ending l_beg_per_num',l_dpr_in.p_cl_end, p_log_level_rec => p_log_level_rec);
2479: fa_debug_pkg.add(l_calling_fn, 'Before calling ','faxcde at 1', p_log_level_rec => p_log_level_rec);
2480: END IF;
2481:

Line 2478: fa_debug_pkg.add(l_calling_fn, 'ending l_beg_per_num',l_dpr_in.p_cl_end, p_log_level_rec => p_log_level_rec);

2474: end if;
2475:
2476: IF (p_log_level_rec.statement_level) THEN
2477: fa_debug_pkg.add(l_calling_fn, 'ending fiscal year',l_dpr_in.y_end, p_log_level_rec => p_log_level_rec);
2478: fa_debug_pkg.add(l_calling_fn, 'ending l_beg_per_num',l_dpr_in.p_cl_end, p_log_level_rec => p_log_level_rec);
2479: fa_debug_pkg.add(l_calling_fn, 'Before calling ','faxcde at 1', p_log_level_rec => p_log_level_rec);
2480: END IF;
2481:
2482: if not FA_CDE_PKG.faxcde(l_dpr_in,

Line 2479: fa_debug_pkg.add(l_calling_fn, 'Before calling ','faxcde at 1', p_log_level_rec => p_log_level_rec);

2475:
2476: IF (p_log_level_rec.statement_level) THEN
2477: fa_debug_pkg.add(l_calling_fn, 'ending fiscal year',l_dpr_in.y_end, p_log_level_rec => p_log_level_rec);
2478: fa_debug_pkg.add(l_calling_fn, 'ending l_beg_per_num',l_dpr_in.p_cl_end, p_log_level_rec => p_log_level_rec);
2479: fa_debug_pkg.add(l_calling_fn, 'Before calling ','faxcde at 1', p_log_level_rec => p_log_level_rec);
2480: END IF;
2481:
2482: if not FA_CDE_PKG.faxcde(l_dpr_in,
2483: l_dpr_arr,

Line 2488: fa_debug_pkg.add(l_calling_fn, 'Error calling','FA_CDE_PKG.faxcde', p_log_level_rec => p_log_level_rec);

2484: l_dpr_out,
2485: l_running_mode,
2486: p_log_level_rec => p_log_level_rec) then
2487: if (p_log_level_rec.statement_level) then
2488: fa_debug_pkg.add(l_calling_fn, 'Error calling','FA_CDE_PKG.faxcde', p_log_level_rec => p_log_level_rec);
2489: end if;
2490: raise dpr_err;
2491: end if;
2492:

Line 2503: fa_debug_pkg.add(l_calling_fn, 'Deprn rsv without considering reval loss at 1',l_hyp_deprn_exp, p_log_level_rec => p_log_level_rec);

2499: RAISE dpr_err;
2500: END IF;
2501:
2502: if (p_log_level_rec.statement_level) then
2503: fa_debug_pkg.add(l_calling_fn, 'Deprn rsv without considering reval loss at 1',l_hyp_deprn_exp, p_log_level_rec => p_log_level_rec);
2504: fa_debug_pkg.add(l_calling_fn, 'fetching','reval loss row', p_log_level_rec => p_log_level_rec);
2505: end if;
2506:
2507: if p_mrc_sob_type_code = 'P' then

Line 2504: fa_debug_pkg.add(l_calling_fn, 'fetching','reval loss row', p_log_level_rec => p_log_level_rec);

2500: END IF;
2501:
2502: if (p_log_level_rec.statement_level) then
2503: fa_debug_pkg.add(l_calling_fn, 'Deprn rsv without considering reval loss at 1',l_hyp_deprn_exp, p_log_level_rec => p_log_level_rec);
2504: fa_debug_pkg.add(l_calling_fn, 'fetching','reval loss row', p_log_level_rec => p_log_level_rec);
2505: end if;
2506:
2507: if p_mrc_sob_type_code = 'P' then
2508: open c_get_asset_rec;

Line 2577: fa_debug_pkg.add(l_calling_fn, 'Before calling ','faxcde at 2', p_log_level_rec => p_log_level_rec);

2573: l_dpr_in.p_cl_end := l_dpr_in.p_cl_end - 1;
2574: end if;
2575:
2576: if (p_log_level_rec.statement_level) then
2577: fa_debug_pkg.add(l_calling_fn, 'Before calling ','faxcde at 2', p_log_level_rec => p_log_level_rec);
2578: end if;
2579:
2580: if not FA_CDE_PKG.faxcde(l_dpr_in,
2581: l_dpr_arr,

Line 2586: fa_debug_pkg.add(l_calling_fn, 'Error calling','FA_CDE_PKG.faxcde', p_log_level_rec => p_log_level_rec);

2582: l_dpr_out,
2583: l_running_mode,
2584: p_log_level_rec => p_log_level_rec) then
2585: if (p_log_level_rec.statement_level) then
2586: fa_debug_pkg.add(l_calling_fn, 'Error calling','FA_CDE_PKG.faxcde', p_log_level_rec => p_log_level_rec);
2587: end if;
2588:
2589: raise dpr_err;
2590: end if;

Line 2603: fa_debug_pkg.add(l_calling_fn, 'Deprn rsv with reval loss at 2',l_hyp_deprn_exp, p_log_level_rec => p_log_level_rec);

2599: END IF;
2600:
2601: x_deprn_exp := l_hyp_deprn_exp - l_act_deprn_exp;
2602: if (p_log_level_rec.statement_level) then
2603: fa_debug_pkg.add(l_calling_fn, 'Deprn rsv with reval loss at 2',l_hyp_deprn_exp, p_log_level_rec => p_log_level_rec);
2604: fa_debug_pkg.add(l_calling_fn, 'Deprn effect because of reval loss',x_deprn_exp, p_log_level_rec => p_log_level_rec);
2605: end if;
2606: return true;
2607: EXCEPTION

Line 2604: fa_debug_pkg.add(l_calling_fn, 'Deprn effect because of reval loss',x_deprn_exp, p_log_level_rec => p_log_level_rec);

2600:
2601: x_deprn_exp := l_hyp_deprn_exp - l_act_deprn_exp;
2602: if (p_log_level_rec.statement_level) then
2603: fa_debug_pkg.add(l_calling_fn, 'Deprn rsv with reval loss at 2',l_hyp_deprn_exp, p_log_level_rec => p_log_level_rec);
2604: fa_debug_pkg.add(l_calling_fn, 'Deprn effect because of reval loss',x_deprn_exp, p_log_level_rec => p_log_level_rec);
2605: end if;
2606: return true;
2607: EXCEPTION
2608: WHEN dpr_err THEN

Line 2610: fa_debug_pkg.ADD (l_calling_fn,'Inside exception','depr_err', p_log_level_rec => p_log_level_rec);

2606: return true;
2607: EXCEPTION
2608: WHEN dpr_err THEN
2609: IF (p_log_level_rec.statement_level) THEN
2610: fa_debug_pkg.ADD (l_calling_fn,'Inside exception','depr_err', p_log_level_rec => p_log_level_rec);
2611: END IF;
2612: RETURN FALSE;
2613: WHEN OTHERS THEN
2614: IF (p_log_level_rec.statement_level) THEN

Line 2615: fa_debug_pkg.ADD (l_calling_fn,'Inside exception','OTHERS', p_log_level_rec => p_log_level_rec);

2611: END IF;
2612: RETURN FALSE;
2613: WHEN OTHERS THEN
2614: IF (p_log_level_rec.statement_level) THEN
2615: fa_debug_pkg.ADD (l_calling_fn,'Inside exception','OTHERS', p_log_level_rec => p_log_level_rec);
2616: END IF;
2617: RETURN FALSE;
2618: END calculate_deprn_exp;
2619: