62: X_dpr_ptr.adj_rec_cost := px_asset_fin_rec_new.adjusted_recoverable_cost;
63: X_dpr_ptr.salvage_value := px_asset_fin_rec_new.salvage_value;
64:
65: if (p_log_level_rec.statement_level) then
66: fa_debug_pkg.add('faxbds','faamrt1 2nd user exit new adj cost',
67: px_asset_fin_rec_new.adjusted_recoverable_cost
68: ,p_log_level_rec => p_log_level_rec);
69: fa_debug_pkg.add('faxbds','faamrt1 3rd user exit salvage_value',
70: px_asset_fin_rec_new.salvage_value
65: if (p_log_level_rec.statement_level) then
66: fa_debug_pkg.add('faxbds','faamrt1 2nd user exit new adj cost',
67: px_asset_fin_rec_new.adjusted_recoverable_cost
68: ,p_log_level_rec => p_log_level_rec);
69: fa_debug_pkg.add('faxbds','faamrt1 3rd user exit salvage_value',
70: px_asset_fin_rec_new.salvage_value
71: ,p_log_level_rec => p_log_level_rec);
72: fa_debug_pkg.add('faxbds','Japan Tax p_extended_flag',
73: p_extended_flag
68: ,p_log_level_rec => p_log_level_rec);
69: fa_debug_pkg.add('faxbds','faamrt1 3rd user exit salvage_value',
70: px_asset_fin_rec_new.salvage_value
71: ,p_log_level_rec => p_log_level_rec);
72: fa_debug_pkg.add('faxbds','Japan Tax p_extended_flag',
73: p_extended_flag
74: ,p_log_level_rec => p_log_level_rec);
75: end if;
76:
368:
369: l_dpr.adj_cost := px_asset_fin_rec_new.adjusted_cost ;
370:
371: if (p_log_level_rec.statement_level) then
372: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 1st faxcde l_dpr.y_begin', l_dpr.y_begin
373: ,p_log_level_rec => p_log_level_rec);
374: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 1st faxcde l_dpr.y_end', l_dpr.y_end
375: ,p_log_level_rec => p_log_level_rec);
376: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 1st faxcde l_dpr.p_cl_begin', l_dpr.p_cl_begin
370:
371: if (p_log_level_rec.statement_level) then
372: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 1st faxcde l_dpr.y_begin', l_dpr.y_begin
373: ,p_log_level_rec => p_log_level_rec);
374: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 1st faxcde l_dpr.y_end', l_dpr.y_end
375: ,p_log_level_rec => p_log_level_rec);
376: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 1st faxcde l_dpr.p_cl_begin', l_dpr.p_cl_begin
377: ,p_log_level_rec => p_log_level_rec);
378: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 1st faxcde l_dpr.p_cl_end', l_dpr.p_cl_end
372: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 1st faxcde l_dpr.y_begin', l_dpr.y_begin
373: ,p_log_level_rec => p_log_level_rec);
374: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 1st faxcde l_dpr.y_end', l_dpr.y_end
375: ,p_log_level_rec => p_log_level_rec);
376: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 1st faxcde l_dpr.p_cl_begin', l_dpr.p_cl_begin
377: ,p_log_level_rec => p_log_level_rec);
378: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 1st faxcde l_dpr.p_cl_end', l_dpr.p_cl_end
379: ,p_log_level_rec => p_log_level_rec);
380: fa_debug_pkg.add('faxexp', 'Japan Tax:5 Calling 2nd faxcde ', 'here'
374: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 1st faxcde l_dpr.y_end', l_dpr.y_end
375: ,p_log_level_rec => p_log_level_rec);
376: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 1st faxcde l_dpr.p_cl_begin', l_dpr.p_cl_begin
377: ,p_log_level_rec => p_log_level_rec);
378: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 1st faxcde l_dpr.p_cl_end', l_dpr.p_cl_end
379: ,p_log_level_rec => p_log_level_rec);
380: fa_debug_pkg.add('faxexp', 'Japan Tax:5 Calling 2nd faxcde ', 'here'
381: ,p_log_level_rec => p_log_level_rec);
382: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 1st faxcde px_asset_fin_rec_new.adjusted_cost',
376: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 1st faxcde l_dpr.p_cl_begin', l_dpr.p_cl_begin
377: ,p_log_level_rec => p_log_level_rec);
378: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 1st faxcde l_dpr.p_cl_end', l_dpr.p_cl_end
379: ,p_log_level_rec => p_log_level_rec);
380: fa_debug_pkg.add('faxexp', 'Japan Tax:5 Calling 2nd faxcde ', 'here'
381: ,p_log_level_rec => p_log_level_rec);
382: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 1st faxcde px_asset_fin_rec_new.adjusted_cost',
383: px_asset_fin_rec_new.adjusted_cost, p_log_level_rec => p_log_level_rec);
384: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 1st faxcde p_asset_deprn_rec.deprn_reserve',
378: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 1st faxcde l_dpr.p_cl_end', l_dpr.p_cl_end
379: ,p_log_level_rec => p_log_level_rec);
380: fa_debug_pkg.add('faxexp', 'Japan Tax:5 Calling 2nd faxcde ', 'here'
381: ,p_log_level_rec => p_log_level_rec);
382: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 1st faxcde px_asset_fin_rec_new.adjusted_cost',
383: px_asset_fin_rec_new.adjusted_cost, p_log_level_rec => p_log_level_rec);
384: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 1st faxcde p_asset_deprn_rec.deprn_reserve',
385: p_asset_deprn_rec.deprn_reserve, p_log_level_rec => p_log_level_rec);
386: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 1st faxcde px_asset_fin_rec_new.cost ',
380: fa_debug_pkg.add('faxexp', 'Japan Tax:5 Calling 2nd faxcde ', 'here'
381: ,p_log_level_rec => p_log_level_rec);
382: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 1st faxcde px_asset_fin_rec_new.adjusted_cost',
383: px_asset_fin_rec_new.adjusted_cost, p_log_level_rec => p_log_level_rec);
384: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 1st faxcde p_asset_deprn_rec.deprn_reserve',
385: p_asset_deprn_rec.deprn_reserve, p_log_level_rec => p_log_level_rec);
386: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 1st faxcde px_asset_fin_rec_new.cost ',
387: px_asset_fin_rec_new.cost, p_log_level_rec => p_log_level_rec);
388: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 1st faxcde px_asset_fin_rec_new.allowed_deprn_limit_amount',
382: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 1st faxcde px_asset_fin_rec_new.adjusted_cost',
383: px_asset_fin_rec_new.adjusted_cost, p_log_level_rec => p_log_level_rec);
384: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 1st faxcde p_asset_deprn_rec.deprn_reserve',
385: p_asset_deprn_rec.deprn_reserve, p_log_level_rec => p_log_level_rec);
386: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 1st faxcde px_asset_fin_rec_new.cost ',
387: px_asset_fin_rec_new.cost, p_log_level_rec => p_log_level_rec);
388: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 1st faxcde px_asset_fin_rec_new.allowed_deprn_limit_amount',
389: px_asset_fin_rec_new.allowed_deprn_limit_amount, p_log_level_rec => p_log_level_rec);
390: fa_debug_pkg.add('faxexp', 'Japan Tax:6 Before 1st faxcde px_asset_fin_rec_new.adjusted_recoverable_cost ',
384: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 1st faxcde p_asset_deprn_rec.deprn_reserve',
385: p_asset_deprn_rec.deprn_reserve, p_log_level_rec => p_log_level_rec);
386: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 1st faxcde px_asset_fin_rec_new.cost ',
387: px_asset_fin_rec_new.cost, p_log_level_rec => p_log_level_rec);
388: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 1st faxcde px_asset_fin_rec_new.allowed_deprn_limit_amount',
389: px_asset_fin_rec_new.allowed_deprn_limit_amount, p_log_level_rec => p_log_level_rec);
390: fa_debug_pkg.add('faxexp', 'Japan Tax:6 Before 1st faxcde px_asset_fin_rec_new.adjusted_recoverable_cost ',
391: px_asset_fin_rec_new.adjusted_recoverable_cost, p_log_level_rec => p_log_level_rec);
392: end if;
386: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 1st faxcde px_asset_fin_rec_new.cost ',
387: px_asset_fin_rec_new.cost, p_log_level_rec => p_log_level_rec);
388: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 1st faxcde px_asset_fin_rec_new.allowed_deprn_limit_amount',
389: px_asset_fin_rec_new.allowed_deprn_limit_amount, p_log_level_rec => p_log_level_rec);
390: fa_debug_pkg.add('faxexp', 'Japan Tax:6 Before 1st faxcde px_asset_fin_rec_new.adjusted_recoverable_cost ',
391: px_asset_fin_rec_new.adjusted_recoverable_cost, p_log_level_rec => p_log_level_rec);
392: end if;
393:
394: if not fa_cde_pkg.faxcde
404: X_deprn_exp := l_dpr_out.new_deprn_rsv;
405: X_bonus_deprn_exp := l_dpr_out.new_bonus_deprn_rsv;
406:
407: if (p_log_level_rec.statement_level) then
408: fa_debug_pkg.add('faxexp', 'Japan Tax:6 After 1st faxcde l_dpr_out.new_deprn_rsv', l_dpr_out.new_deprn_rsv
409: ,p_log_level_rec => p_log_level_rec);
410: fa_debug_pkg.add('faxexp', 'Japan Tax:6 After 1st faxcde l_dpr_out.deprn_exp', l_dpr_out.deprn_exp
411: ,p_log_level_rec => p_log_level_rec);
412: end if;
406:
407: if (p_log_level_rec.statement_level) then
408: fa_debug_pkg.add('faxexp', 'Japan Tax:6 After 1st faxcde l_dpr_out.new_deprn_rsv', l_dpr_out.new_deprn_rsv
409: ,p_log_level_rec => p_log_level_rec);
410: fa_debug_pkg.add('faxexp', 'Japan Tax:6 After 1st faxcde l_dpr_out.deprn_exp', l_dpr_out.deprn_exp
411: ,p_log_level_rec => p_log_level_rec);
412: end if;
413:
414: end if;
413:
414: end if;
415: elsif (l_reset_extend_flag) then
416:
417: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Adjustment logic', 'Reset extnded asset'
418: ,p_log_level_rec => p_log_level_rec);
419: -- Bug 6624784 Reverse the catchup taken during extended depreciation.
420: if p_period_rec.period_counter > p_asset_fin_rec_old.extended_depreciation_period then
421: if (p_log_level_rec.statement_level) then
418: ,p_log_level_rec => p_log_level_rec);
419: -- Bug 6624784 Reverse the catchup taken during extended depreciation.
420: if p_period_rec.period_counter > p_asset_fin_rec_old.extended_depreciation_period then
421: if (p_log_level_rec.statement_level) then
422: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 2nd faxcde l_dpr.y_begin', l_dpr.y_begin
423: ,p_log_level_rec => p_log_level_rec);
424: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 2nd faxcde l_dpr.y_end', l_dpr.y_end
425: ,p_log_level_rec => p_log_level_rec);
426: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 2nd faxcde l_dpr.p_cl_begin', l_dpr.p_cl_begin
420: if p_period_rec.period_counter > p_asset_fin_rec_old.extended_depreciation_period then
421: if (p_log_level_rec.statement_level) then
422: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 2nd faxcde l_dpr.y_begin', l_dpr.y_begin
423: ,p_log_level_rec => p_log_level_rec);
424: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 2nd faxcde l_dpr.y_end', l_dpr.y_end
425: ,p_log_level_rec => p_log_level_rec);
426: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 2nd faxcde l_dpr.p_cl_begin', l_dpr.p_cl_begin
427: ,p_log_level_rec => p_log_level_rec);
428: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 2nd faxcde l_dpr.p_cl_end', l_dpr.p_cl_end
422: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 2nd faxcde l_dpr.y_begin', l_dpr.y_begin
423: ,p_log_level_rec => p_log_level_rec);
424: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 2nd faxcde l_dpr.y_end', l_dpr.y_end
425: ,p_log_level_rec => p_log_level_rec);
426: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 2nd faxcde l_dpr.p_cl_begin', l_dpr.p_cl_begin
427: ,p_log_level_rec => p_log_level_rec);
428: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 2nd faxcde l_dpr.p_cl_end', l_dpr.p_cl_end
429: ,p_log_level_rec => p_log_level_rec);
430: fa_debug_pkg.add('faxexp', 'Japan Tax:5 Calling 2nd faxcde ', 'here'
424: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 2nd faxcde l_dpr.y_end', l_dpr.y_end
425: ,p_log_level_rec => p_log_level_rec);
426: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 2nd faxcde l_dpr.p_cl_begin', l_dpr.p_cl_begin
427: ,p_log_level_rec => p_log_level_rec);
428: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 2nd faxcde l_dpr.p_cl_end', l_dpr.p_cl_end
429: ,p_log_level_rec => p_log_level_rec);
430: fa_debug_pkg.add('faxexp', 'Japan Tax:5 Calling 2nd faxcde ', 'here'
431: ,p_log_level_rec => p_log_level_rec);
432: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 2nd faxcde px_asset_fin_rec_new.adjusted_cost',
426: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 2nd faxcde l_dpr.p_cl_begin', l_dpr.p_cl_begin
427: ,p_log_level_rec => p_log_level_rec);
428: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 2nd faxcde l_dpr.p_cl_end', l_dpr.p_cl_end
429: ,p_log_level_rec => p_log_level_rec);
430: fa_debug_pkg.add('faxexp', 'Japan Tax:5 Calling 2nd faxcde ', 'here'
431: ,p_log_level_rec => p_log_level_rec);
432: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 2nd faxcde px_asset_fin_rec_new.adjusted_cost',
433: px_asset_fin_rec_new.adjusted_cost, p_log_level_rec => p_log_level_rec);
434: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 2nd faxcde p_asset_deprn_rec.deprn_reserve',
428: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 2nd faxcde l_dpr.p_cl_end', l_dpr.p_cl_end
429: ,p_log_level_rec => p_log_level_rec);
430: fa_debug_pkg.add('faxexp', 'Japan Tax:5 Calling 2nd faxcde ', 'here'
431: ,p_log_level_rec => p_log_level_rec);
432: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 2nd faxcde px_asset_fin_rec_new.adjusted_cost',
433: px_asset_fin_rec_new.adjusted_cost, p_log_level_rec => p_log_level_rec);
434: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 2nd faxcde p_asset_deprn_rec.deprn_reserve',
435: p_asset_deprn_rec.deprn_reserve, p_log_level_rec => p_log_level_rec);
436: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 2nd faxcde px_asset_fin_rec_new.cost ',
430: fa_debug_pkg.add('faxexp', 'Japan Tax:5 Calling 2nd faxcde ', 'here'
431: ,p_log_level_rec => p_log_level_rec);
432: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 2nd faxcde px_asset_fin_rec_new.adjusted_cost',
433: px_asset_fin_rec_new.adjusted_cost, p_log_level_rec => p_log_level_rec);
434: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 2nd faxcde p_asset_deprn_rec.deprn_reserve',
435: p_asset_deprn_rec.deprn_reserve, p_log_level_rec => p_log_level_rec);
436: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 2nd faxcde px_asset_fin_rec_new.cost ',
437: px_asset_fin_rec_new.cost, p_log_level_rec => p_log_level_rec);
438: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 2nd faxcde px_asset_fin_rec_new.allowed_deprn_limit_amount',
432: fa_debug_pkg.add('faxexp', 'Japan Tax:1 Before 2nd faxcde px_asset_fin_rec_new.adjusted_cost',
433: px_asset_fin_rec_new.adjusted_cost, p_log_level_rec => p_log_level_rec);
434: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 2nd faxcde p_asset_deprn_rec.deprn_reserve',
435: p_asset_deprn_rec.deprn_reserve, p_log_level_rec => p_log_level_rec);
436: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 2nd faxcde px_asset_fin_rec_new.cost ',
437: px_asset_fin_rec_new.cost, p_log_level_rec => p_log_level_rec);
438: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 2nd faxcde px_asset_fin_rec_new.allowed_deprn_limit_amount',
439: px_asset_fin_rec_new.allowed_deprn_limit_amount, p_log_level_rec => p_log_level_rec);
440: fa_debug_pkg.add('faxexp', 'Japan Tax:6 Before 2nd faxcde px_asset_fin_rec_new.adjusted_recoverable_cost ',
434: fa_debug_pkg.add('faxexp', 'Japan Tax:2 Before 2nd faxcde p_asset_deprn_rec.deprn_reserve',
435: p_asset_deprn_rec.deprn_reserve, p_log_level_rec => p_log_level_rec);
436: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 2nd faxcde px_asset_fin_rec_new.cost ',
437: px_asset_fin_rec_new.cost, p_log_level_rec => p_log_level_rec);
438: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 2nd faxcde px_asset_fin_rec_new.allowed_deprn_limit_amount',
439: px_asset_fin_rec_new.allowed_deprn_limit_amount, p_log_level_rec => p_log_level_rec);
440: fa_debug_pkg.add('faxexp', 'Japan Tax:6 Before 2nd faxcde px_asset_fin_rec_new.adjusted_recoverable_cost ',
441: px_asset_fin_rec_new.adjusted_recoverable_cost, p_log_level_rec => p_log_level_rec);
442: end if;
436: fa_debug_pkg.add('faxexp', 'Japan Tax:3 Before 2nd faxcde px_asset_fin_rec_new.cost ',
437: px_asset_fin_rec_new.cost, p_log_level_rec => p_log_level_rec);
438: fa_debug_pkg.add('faxexp', 'Japan Tax:4 Before 2nd faxcde px_asset_fin_rec_new.allowed_deprn_limit_amount',
439: px_asset_fin_rec_new.allowed_deprn_limit_amount, p_log_level_rec => p_log_level_rec);
440: fa_debug_pkg.add('faxexp', 'Japan Tax:6 Before 2nd faxcde px_asset_fin_rec_new.adjusted_recoverable_cost ',
441: px_asset_fin_rec_new.adjusted_recoverable_cost, p_log_level_rec => p_log_level_rec);
442: end if;
443:
444: if not fa_cde_pkg.faxcde
461: close c_extend_get_original_adjcost;
462: px_asset_fin_rec_new.adjusted_cost := l_adjusted_cost;
463:
464: if (p_log_level_rec.statement_level) then
465: fa_debug_pkg.add('faxexp', 'Japan Tax:6 After 2nd faxcde l_dpr_out.new_deprn_rsv', l_dpr_out.new_deprn_rsv
466: ,p_log_level_rec => p_log_level_rec);
467: fa_debug_pkg.add('faxexp', 'Japan Tax:6 After 2nd faxcde l_dpr_out.deprn_exp', l_dpr_out.deprn_exp
468: ,p_log_level_rec => p_log_level_rec);
469: end if;
463:
464: if (p_log_level_rec.statement_level) then
465: fa_debug_pkg.add('faxexp', 'Japan Tax:6 After 2nd faxcde l_dpr_out.new_deprn_rsv', l_dpr_out.new_deprn_rsv
466: ,p_log_level_rec => p_log_level_rec);
467: fa_debug_pkg.add('faxexp', 'Japan Tax:6 After 2nd faxcde l_dpr_out.deprn_exp', l_dpr_out.deprn_exp
468: ,p_log_level_rec => p_log_level_rec);
469: end if;
470: end if;
471: -- Japan Tax phase3 End
503: end if;
504:
505: -- Manual Override
506: if (p_log_level_rec.statement_level) then
507: fa_debug_pkg.add (
508: fname => 'faxexp',
509: element => 'deprn_override_flag',
510: value => l_dpr_out.deprn_override_flag
511: ,p_log_level_rec => p_log_level_rec);