44: BEGIN
45:
46: IF (X_init_message_flag = 'YES') THEN
47: FA_SRVR_MSG.INIT_SERVER_MESSAGE; /* init server msg stack */
48: fa_debug_pkg.initialize; /* init debug msg stack */
49: END IF;
50:
51: IF (X_book_type_code IS NULL) OR (X_asset_id IS NULL) THEN
52: FA_SRVR_MSG.add_message(
139: end if; -- end sob_id
140:
141: h_msg_name := NULL;
142: if (g_print_debug) then
143: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_summary values:',''
144: ,p_log_level_rec => p_log_level_rec);
145: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd
146: ,p_log_level_rec => p_log_level_rec);
147: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve
141: h_msg_name := NULL;
142: if (g_print_debug) then
143: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_summary values:',''
144: ,p_log_level_rec => p_log_level_rec);
145: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd
146: ,p_log_level_rec => p_log_level_rec);
147: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve
148: ,p_log_level_rec => p_log_level_rec);
149: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve
143: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_summary values:',''
144: ,p_log_level_rec => p_log_level_rec);
145: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd
146: ,p_log_level_rec => p_log_level_rec);
147: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve
148: ,p_log_level_rec => p_log_level_rec);
149: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve
150: ,p_log_level_rec => p_log_level_rec);
151: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp
145: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_ytd
146: ,p_log_level_rec => p_log_level_rec);
147: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve
148: ,p_log_level_rec => p_log_level_rec);
149: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve
150: ,p_log_level_rec => p_log_level_rec);
151: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp
152: ,p_log_level_rec => p_log_level_rec);
153: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_period_counter
147: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_deprn_reserve
148: ,p_log_level_rec => p_log_level_rec);
149: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve
150: ,p_log_level_rec => p_log_level_rec);
151: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp
152: ,p_log_level_rec => p_log_level_rec);
153: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_period_counter
154: ,p_log_level_rec => p_log_level_rec);
155: end if;
149: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_reval_reserve
150: ,p_log_level_rec => p_log_level_rec);
151: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_ytd_reval_dep_exp
152: ,p_log_level_rec => p_log_level_rec);
153: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_period_counter
154: ,p_log_level_rec => p_log_level_rec);
155: end if;
156:
157: END IF;
249:
250: h_dpr_dtl.period_counter := h_period_counter;
251:
252: if (g_print_debug) then
253: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','values before call to fadpdtl',''
254: ,p_log_level_rec => p_log_level_rec);
255: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost
256: ,p_log_level_rec => p_log_level_rec);
257: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd
251:
252: if (g_print_debug) then
253: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','values before call to fadpdtl',''
254: ,p_log_level_rec => p_log_level_rec);
255: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost
256: ,p_log_level_rec => p_log_level_rec);
257: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd
258: ,p_log_level_rec => p_log_level_rec);
259: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve
253: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','values before call to fadpdtl',''
254: ,p_log_level_rec => p_log_level_rec);
255: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost
256: ,p_log_level_rec => p_log_level_rec);
257: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd
258: ,p_log_level_rec => p_log_level_rec);
259: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve
260: ,p_log_level_rec => p_log_level_rec);
261: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve
255: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','cost',h_dpr_dtl.cost
256: ,p_log_level_rec => p_log_level_rec);
257: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd
258: ,p_log_level_rec => p_log_level_rec);
259: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve
260: ,p_log_level_rec => p_log_level_rec);
261: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve
262: ,p_log_level_rec => p_log_level_rec);
263: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp
257: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_dpr_dtl.ytd
258: ,p_log_level_rec => p_log_level_rec);
259: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve
260: ,p_log_level_rec => p_log_level_rec);
261: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve
262: ,p_log_level_rec => p_log_level_rec);
263: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp
264: ,p_log_level_rec => p_log_level_rec);
265: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_dpr_dtl.period_counter
259: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_dpr_dtl.deprn_reserve
260: ,p_log_level_rec => p_log_level_rec);
261: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve
262: ,p_log_level_rec => p_log_level_rec);
263: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp
264: ,p_log_level_rec => p_log_level_rec);
265: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_dpr_dtl.period_counter
266: ,p_log_level_rec => p_log_level_rec);
267: end if;
261: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_dpr_dtl.reval_reserve
262: ,p_log_level_rec => p_log_level_rec);
263: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_dpr_dtl.ytd_reval_dep_exp
264: ,p_log_level_rec => p_log_level_rec);
265: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','period_counter',h_dpr_dtl.period_counter
266: ,p_log_level_rec => p_log_level_rec);
267: end if;
268:
269: IF (NOT fadpdtl(X_dpr_dtl => h_dpr_dtl,
438: FETCH C1 INTO h_dist_id,
439: h_units_assigned;
440: EXIT WHEN C1%NOTFOUND;
441: if (g_print_debug) then
442: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after the fetch',''
443: ,p_log_level_rec => p_log_level_rec);
444: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id
445: ,p_log_level_rec => p_log_level_rec);
446: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned
440: EXIT WHEN C1%NOTFOUND;
441: if (g_print_debug) then
442: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after the fetch',''
443: ,p_log_level_rec => p_log_level_rec);
444: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id
445: ,p_log_level_rec => p_log_level_rec);
446: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned
447: ,p_log_level_rec => p_log_level_rec);
448: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','total_units',h_total_units
442: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values after the fetch',''
443: ,p_log_level_rec => p_log_level_rec);
444: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id
445: ,p_log_level_rec => p_log_level_rec);
446: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned
447: ,p_log_level_rec => p_log_level_rec);
448: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','total_units',h_total_units
449: ,p_log_level_rec => p_log_level_rec);
450: end if;
444: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id
445: ,p_log_level_rec => p_log_level_rec);
446: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','units_assigned',h_units_assigned
447: ,p_log_level_rec => p_log_level_rec);
448: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','total_units',h_total_units
449: ,p_log_level_rec => p_log_level_rec);
450: end if;
451:
452: h_rec_count := h_rec_count + 1;
559:
560: END IF;
561:
562: if (g_print_debug) then
563: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values before the insert to deprn_detail',''
564: ,p_log_level_rec => p_log_level_rec);
565: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code
566: ,p_log_level_rec => p_log_level_rec);
567: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id
561:
562: if (g_print_debug) then
563: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values before the insert to deprn_detail',''
564: ,p_log_level_rec => p_log_level_rec);
565: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code
566: ,p_log_level_rec => p_log_level_rec);
567: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id
568: ,p_log_level_rec => p_log_level_rec);
569: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id
563: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','values before the insert to deprn_detail',''
564: ,p_log_level_rec => p_log_level_rec);
565: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code
566: ,p_log_level_rec => p_log_level_rec);
567: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id
568: ,p_log_level_rec => p_log_level_rec);
569: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id
570: ,p_log_level_rec => p_log_level_rec);
571: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code
565: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','book',h_book_type_code
566: ,p_log_level_rec => p_log_level_rec);
567: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id
568: ,p_log_level_rec => p_log_level_rec);
569: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id
570: ,p_log_level_rec => p_log_level_rec);
571: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code
572: ,p_log_level_rec => p_log_level_rec);
573: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter
567: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','asset_id',h_asset_id
568: ,p_log_level_rec => p_log_level_rec);
569: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id
570: ,p_log_level_rec => p_log_level_rec);
571: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code
572: ,p_log_level_rec => p_log_level_rec);
573: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter
574: ,p_log_level_rec => p_log_level_rec);
575: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd
569: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','dist_id',h_dist_id
570: ,p_log_level_rec => p_log_level_rec);
571: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code
572: ,p_log_level_rec => p_log_level_rec);
573: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter
574: ,p_log_level_rec => p_log_level_rec);
575: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd
576: ,p_log_level_rec => p_log_level_rec);
577: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve
571: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','source_code',h_source_code
572: ,p_log_level_rec => p_log_level_rec);
573: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter
574: ,p_log_level_rec => p_log_level_rec);
575: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd
576: ,p_log_level_rec => p_log_level_rec);
577: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve
578: ,p_log_level_rec => p_log_level_rec);
579: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve
573: fa_debug_pkg.add('FA_INS_DETAIL_PKG.fadpdtl','period_counter',h_period_counter
574: ,p_log_level_rec => p_log_level_rec);
575: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd
576: ,p_log_level_rec => p_log_level_rec);
577: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve
578: ,p_log_level_rec => p_log_level_rec);
579: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve
580: ,p_log_level_rec => p_log_level_rec);
581: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_part_ytd_reval_dep_exp
575: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_deprn',h_part_ytd
576: ,p_log_level_rec => p_log_level_rec);
577: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve
578: ,p_log_level_rec => p_log_level_rec);
579: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve
580: ,p_log_level_rec => p_log_level_rec);
581: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_part_ytd_reval_dep_exp
582: ,p_log_level_rec => p_log_level_rec);
583: end if;
577: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','deprn_reserve',h_part_deprn_reserve
578: ,p_log_level_rec => p_log_level_rec);
579: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','reval_reserve',h_part_reval_reserve
580: ,p_log_level_rec => p_log_level_rec);
581: fa_debug_pkg.add('FA_INS_DETAIL_PKG.faxindd','ytd_reval_deprn_expense',h_part_ytd_reval_dep_exp
582: ,p_log_level_rec => p_log_level_rec);
583: end if;
584:
585: if (X_mrc_sob_type_code = 'R') then