56: BEGIN
57:
58: IF (X_init_message_flag = 'YES') THEN
59: FA_SRVR_MSG.INIT_SERVER_MESSAGE; /* init server msg stack */
60: fa_debug_pkg.initialize; /* init debug msg stack */
61: END IF;
62:
63: IF (X_book_type_code IS NULL) OR (X_asset_id IS NULL) THEN
64: FA_SRVR_MSG.add_message(
152: end if; -- end sob_id
153:
154: h_msg_name := NULL;
155: if (p_log_level_rec.statement_level) then
156: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_summary values:','', p_log_level_rec => p_log_level_rec);
157: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd, p_log_level_rec => p_log_level_rec);
158: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve, p_log_level_rec => p_log_level_rec);
159: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve, p_log_level_rec => p_log_level_rec);
160: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
153:
154: h_msg_name := NULL;
155: if (p_log_level_rec.statement_level) then
156: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_summary values:','', p_log_level_rec => p_log_level_rec);
157: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd, p_log_level_rec => p_log_level_rec);
158: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve, p_log_level_rec => p_log_level_rec);
159: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve, p_log_level_rec => p_log_level_rec);
160: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
161: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
154: h_msg_name := NULL;
155: if (p_log_level_rec.statement_level) then
156: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_summary values:','', p_log_level_rec => p_log_level_rec);
157: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd, p_log_level_rec => p_log_level_rec);
158: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve, p_log_level_rec => p_log_level_rec);
159: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve, p_log_level_rec => p_log_level_rec);
160: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
161: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
162: end if;
155: if (p_log_level_rec.statement_level) then
156: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_summary values:','', p_log_level_rec => p_log_level_rec);
157: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd, p_log_level_rec => p_log_level_rec);
158: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve, p_log_level_rec => p_log_level_rec);
159: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve, p_log_level_rec => p_log_level_rec);
160: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
161: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
162: end if;
163:
156: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_summary values:','', p_log_level_rec => p_log_level_rec);
157: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd, p_log_level_rec => p_log_level_rec);
158: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve, p_log_level_rec => p_log_level_rec);
159: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve, p_log_level_rec => p_log_level_rec);
160: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
161: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
162: end if;
163:
164: END IF;
157: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd, p_log_level_rec => p_log_level_rec);
158: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve, p_log_level_rec => p_log_level_rec);
159: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve, p_log_level_rec => p_log_level_rec);
160: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
161: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
162: end if;
163:
164: END IF;
165:
272: h_dpr_dtl.capital_adjustment := X_capital_adjustment;
273: h_dpr_dtl.general_fund := X_general_fund;
274:
275: if (p_log_level_rec.statement_level) then
276: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','values before call to fadpdtl','', p_log_level_rec => p_log_level_rec);
277: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost, p_log_level_rec => p_log_level_rec);
278: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd, p_log_level_rec => p_log_level_rec);
279: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve, p_log_level_rec => p_log_level_rec);
280: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve, p_log_level_rec => p_log_level_rec);
273: h_dpr_dtl.general_fund := X_general_fund;
274:
275: if (p_log_level_rec.statement_level) then
276: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','values before call to fadpdtl','', p_log_level_rec => p_log_level_rec);
277: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost, p_log_level_rec => p_log_level_rec);
278: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd, p_log_level_rec => p_log_level_rec);
279: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve, p_log_level_rec => p_log_level_rec);
280: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve, p_log_level_rec => p_log_level_rec);
281: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
274:
275: if (p_log_level_rec.statement_level) then
276: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','values before call to fadpdtl','', p_log_level_rec => p_log_level_rec);
277: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost, p_log_level_rec => p_log_level_rec);
278: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd, p_log_level_rec => p_log_level_rec);
279: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve, p_log_level_rec => p_log_level_rec);
280: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve, p_log_level_rec => p_log_level_rec);
281: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
282: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_dpr_dtl.period_counter, p_log_level_rec => p_log_level_rec);
275: if (p_log_level_rec.statement_level) then
276: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','values before call to fadpdtl','', p_log_level_rec => p_log_level_rec);
277: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost, p_log_level_rec => p_log_level_rec);
278: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd, p_log_level_rec => p_log_level_rec);
279: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve, p_log_level_rec => p_log_level_rec);
280: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve, p_log_level_rec => p_log_level_rec);
281: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
282: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_dpr_dtl.period_counter, p_log_level_rec => p_log_level_rec);
283: end if;
276: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','values before call to fadpdtl','', p_log_level_rec => p_log_level_rec);
277: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost, p_log_level_rec => p_log_level_rec);
278: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd, p_log_level_rec => p_log_level_rec);
279: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve, p_log_level_rec => p_log_level_rec);
280: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve, p_log_level_rec => p_log_level_rec);
281: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
282: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_dpr_dtl.period_counter, p_log_level_rec => p_log_level_rec);
283: end if;
284:
277: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost, p_log_level_rec => p_log_level_rec);
278: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd, p_log_level_rec => p_log_level_rec);
279: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve, p_log_level_rec => p_log_level_rec);
280: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve, p_log_level_rec => p_log_level_rec);
281: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
282: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_dpr_dtl.period_counter, p_log_level_rec => p_log_level_rec);
283: end if;
284:
285: IF (NOT fadpdtl(X_dpr_dtl => h_dpr_dtl,
278: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd, p_log_level_rec => p_log_level_rec);
279: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve, p_log_level_rec => p_log_level_rec);
280: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve, p_log_level_rec => p_log_level_rec);
281: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
282: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_dpr_dtl.period_counter, p_log_level_rec => p_log_level_rec);
283: end if;
284:
285: IF (NOT fadpdtl(X_dpr_dtl => h_dpr_dtl,
286: X_source_flag => X_b_row, -- TRUE, Modified for ias36
526:
527: EXCEPTION
528: WHEN OTHERS THEN
529: if (p_log_level_rec.statement_level) then
530: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Getting date added',SQLERRM, p_log_level_rec => p_log_level_rec);
531: end if;
532:
533: RAISE ERROR_FOUND;
534: END;
587: -- transfered out distributions
588: h_full_ytd := X_dpr_dtl.ytd;
589:
590: if (p_log_level_rec.statement_level) then
591: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','At Start Total Ytd',h_full_ytd, p_log_level_rec => p_log_level_rec);
592: end if;
593: if (X_source_flag = FALSE ) then
594: open c2;
595: loop
637:
638: h_full_ytd := h_full_ytd - h_part_ytd;
639:
640: if (p_log_level_rec.statement_level) then
641: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after C2 fetch','', p_log_level_rec => p_log_level_rec);
642: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
643: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
644: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','h_part_ytd',h_part_ytd, p_log_level_rec => p_log_level_rec);
645: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Total Ytd',h_full_ytd, p_log_level_rec => p_log_level_rec);
638: h_full_ytd := h_full_ytd - h_part_ytd;
639:
640: if (p_log_level_rec.statement_level) then
641: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after C2 fetch','', p_log_level_rec => p_log_level_rec);
642: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
643: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
644: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','h_part_ytd',h_part_ytd, p_log_level_rec => p_log_level_rec);
645: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Total Ytd',h_full_ytd, p_log_level_rec => p_log_level_rec);
646: end if;
639:
640: if (p_log_level_rec.statement_level) then
641: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after C2 fetch','', p_log_level_rec => p_log_level_rec);
642: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
643: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
644: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','h_part_ytd',h_part_ytd, p_log_level_rec => p_log_level_rec);
645: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Total Ytd',h_full_ytd, p_log_level_rec => p_log_level_rec);
646: end if;
647:
640: if (p_log_level_rec.statement_level) then
641: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after C2 fetch','', p_log_level_rec => p_log_level_rec);
642: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
643: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
644: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','h_part_ytd',h_part_ytd, p_log_level_rec => p_log_level_rec);
645: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Total Ytd',h_full_ytd, p_log_level_rec => p_log_level_rec);
646: end if;
647:
648: /*Bug#8421266 - Insert row in deprn table only when transferred out in current period.*/
641: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after C2 fetch','', p_log_level_rec => p_log_level_rec);
642: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
643: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
644: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','h_part_ytd',h_part_ytd, p_log_level_rec => p_log_level_rec);
645: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Total Ytd',h_full_ytd, p_log_level_rec => p_log_level_rec);
646: end if;
647:
648: /*Bug#8421266 - Insert row in deprn table only when transferred out in current period.*/
649: if h_pc_counter = h_period_counter then
774: EXIT WHEN C1%NOTFOUND;
775: end if;
776:
777: if (p_log_level_rec.statement_level) then
778: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after the fetch','', p_log_level_rec => p_log_level_rec);
779: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
780: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
781: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','total_units',h_total_units, p_log_level_rec => p_log_level_rec);
782: end if;
775: end if;
776:
777: if (p_log_level_rec.statement_level) then
778: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after the fetch','', p_log_level_rec => p_log_level_rec);
779: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
780: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
781: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','total_units',h_total_units, p_log_level_rec => p_log_level_rec);
782: end if;
783:
776:
777: if (p_log_level_rec.statement_level) then
778: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after the fetch','', p_log_level_rec => p_log_level_rec);
779: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
780: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
781: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','total_units',h_total_units, p_log_level_rec => p_log_level_rec);
782: end if;
783:
784: /*Bug 9142501 - Start:In POA Cost adjustment should not reflect in B row of fa_deprn_detail.
777: if (p_log_level_rec.statement_level) then
778: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after the fetch','', p_log_level_rec => p_log_level_rec);
779: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
780: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned, p_log_level_rec => p_log_level_rec);
781: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','total_units',h_total_units, p_log_level_rec => p_log_level_rec);
782: end if;
783:
784: /*Bug 9142501 - Start:In POA Cost adjustment should not reflect in B row of fa_deprn_detail.
785: ADDITION_COST_TO_CLEAR should contain old value only, which is addition time value. */
782: end if;
783:
784: /*Bug 9142501 - Start:In POA Cost adjustment should not reflect in B row of fa_deprn_detail.
785: ADDITION_COST_TO_CLEAR should contain old value only, which is addition time value. */
786: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','Brahma2 before Loop','BRAHMA',p_log_level_rec => p_log_level_rec);
787: IF h_count > 0 THEN
788: IF X_mrc_sob_type_code = 'R' THEN
789: OPEN C_MC_COST_TO_CLEAR;
790: FETCH C_MC_COST_TO_CLEAR INTO h_cost_to_clear;
1047:
1048: END IF;
1049:
1050: if (p_log_level_rec.statement_level) then
1051: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values before the insert to deprn_detail','', p_log_level_rec => p_log_level_rec);
1052: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code, p_log_level_rec => p_log_level_rec);
1053: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id, p_log_level_rec => p_log_level_rec);
1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1048: END IF;
1049:
1050: if (p_log_level_rec.statement_level) then
1051: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values before the insert to deprn_detail','', p_log_level_rec => p_log_level_rec);
1052: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code, p_log_level_rec => p_log_level_rec);
1053: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id, p_log_level_rec => p_log_level_rec);
1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1049:
1050: if (p_log_level_rec.statement_level) then
1051: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values before the insert to deprn_detail','', p_log_level_rec => p_log_level_rec);
1052: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code, p_log_level_rec => p_log_level_rec);
1053: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id, p_log_level_rec => p_log_level_rec);
1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);
1050: if (p_log_level_rec.statement_level) then
1051: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values before the insert to deprn_detail','', p_log_level_rec => p_log_level_rec);
1052: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code, p_log_level_rec => p_log_level_rec);
1053: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id, p_log_level_rec => p_log_level_rec);
1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve, p_log_level_rec => p_log_level_rec);
1051: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values before the insert to deprn_detail','', p_log_level_rec => p_log_level_rec);
1052: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code, p_log_level_rec => p_log_level_rec);
1053: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id, p_log_level_rec => p_log_level_rec);
1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve, p_log_level_rec => p_log_level_rec);
1059: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve, p_log_level_rec => p_log_level_rec);
1052: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code, p_log_level_rec => p_log_level_rec);
1053: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id, p_log_level_rec => p_log_level_rec);
1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve, p_log_level_rec => p_log_level_rec);
1059: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve, p_log_level_rec => p_log_level_rec);
1060: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_part_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
1053: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id, p_log_level_rec => p_log_level_rec);
1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve, p_log_level_rec => p_log_level_rec);
1059: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve, p_log_level_rec => p_log_level_rec);
1060: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_part_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
1061: end if;
1054: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id, p_log_level_rec => p_log_level_rec);
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve, p_log_level_rec => p_log_level_rec);
1059: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve, p_log_level_rec => p_log_level_rec);
1060: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_part_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
1061: end if;
1062:
1055: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code, p_log_level_rec => p_log_level_rec);
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve, p_log_level_rec => p_log_level_rec);
1059: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve, p_log_level_rec => p_log_level_rec);
1060: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_part_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
1061: end if;
1062:
1063: if (G_release = 11) then
1056: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter, p_log_level_rec => p_log_level_rec);
1057: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd, p_log_level_rec => p_log_level_rec);
1058: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve, p_log_level_rec => p_log_level_rec);
1059: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve, p_log_level_rec => p_log_level_rec);
1060: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_part_ytd_reval_dep_exp, p_log_level_rec => p_log_level_rec);
1061: end if;
1062:
1063: if (G_release = 11) then
1064: h_cost_to_clear := h_part_cost;