[Home] [Help]
116:
117: BEGIN
118:
119: if (p_log_level_rec.statement_level) then
120: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
121: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec);
122: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec);
123: fa_debug_pkg.add(l_calling_fn, 'p_trans_rec.amort_start_date', p_trans_rec.amortization_start_date, p_log_level_rec);
124: end if;
117: BEGIN
118:
119: if (p_log_level_rec.statement_level) then
120: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
121: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec);
122: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec);
123: fa_debug_pkg.add(l_calling_fn, 'p_trans_rec.amort_start_date', p_trans_rec.amortization_start_date, p_log_level_rec);
124: end if;
125:
118:
119: if (p_log_level_rec.statement_level) then
120: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
121: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec);
122: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec);
123: fa_debug_pkg.add(l_calling_fn, 'p_trans_rec.amort_start_date', p_trans_rec.amortization_start_date, p_log_level_rec);
124: end if;
125:
126: -- note that adjustments to both expense and reserve will be handled
119: if (p_log_level_rec.statement_level) then
120: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
121: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec);
122: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec);
123: fa_debug_pkg.add(l_calling_fn, 'p_trans_rec.amort_start_date', p_trans_rec.amortization_start_date, p_log_level_rec);
124: end if;
125:
126: -- note that adjustments to both expense and reserve will be handled
127: -- here in and not in the adjustment api/calc engine (via faadjust)
151: -- verify a change in group is occurring / otherwise error out
152: -- store the "reclass code" for easy reference at various
153: -- points in the api
154: if (p_log_level_rec.statement_level) then
155: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.group_asset_id', p_asset_fin_rec_old.group_asset_id, p_log_level_rec);
156: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.group_asset_id', p_asset_fin_rec_adj.group_asset_id, p_log_level_rec);
157: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_new.group_asset_id', p_asset_fin_rec_new.group_asset_id, p_log_level_rec);
158: end if;
159:
152: -- store the "reclass code" for easy reference at various
153: -- points in the api
154: if (p_log_level_rec.statement_level) then
155: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.group_asset_id', p_asset_fin_rec_old.group_asset_id, p_log_level_rec);
156: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.group_asset_id', p_asset_fin_rec_adj.group_asset_id, p_log_level_rec);
157: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_new.group_asset_id', p_asset_fin_rec_new.group_asset_id, p_log_level_rec);
158: end if;
159:
160:
153: -- points in the api
154: if (p_log_level_rec.statement_level) then
155: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_old.group_asset_id', p_asset_fin_rec_old.group_asset_id, p_log_level_rec);
156: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_adj.group_asset_id', p_asset_fin_rec_adj.group_asset_id, p_log_level_rec);
157: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_new.group_asset_id', p_asset_fin_rec_new.group_asset_id, p_log_level_rec);
158: end if;
159:
160:
161: if (nvl(p_asset_fin_rec_old.group_asset_id, -99) = nvl(p_asset_fin_rec_new.group_asset_id, -99)) then
170: l_group_reclass_code := 'NONE-GRP';
171: end if;
172:
173: if (p_log_level_rec.statement_level) then
174: fa_debug_pkg.add(l_calling_fn, 'reclass code', l_group_reclass_code, p_log_level_rec);
175: end if;
176:
177: -- validate intercompany impacts before doing anything else
178: if (l_group_reclass_code <> 'GRP-NONE' and
253: -- Bug#3737670
254: -- get the old fin and deprn information of destination group
255:
256: if (p_log_level_rec.statement_level) then
257: fa_debug_pkg.add(l_calling_fn, 'px_dest_asset_hdr_rec.asset_id:book_type_code',
258: px_dest_asset_hdr_rec.asset_id||':'|| px_dest_asset_hdr_rec.book_type_code, p_log_level_rec);
259: end if;
260:
261: if l_group_reclass_code <> 'GRP-NONE' then
274: -- SOURCE --
275: ------------
276:
277: if (p_log_level_rec.statement_level) then
278: fa_debug_pkg.add(l_calling_fn, 'processing','source asset', p_log_level_rec);
279: end if;
280:
281: -- For Source Group
282: -- Populate Subtract Ytd Flag
289: -- If the asset was moved out of a group, deduct the asset's cost from the old group
290: if p_asset_fin_rec_old.group_asset_id is not null then
291:
292: if (p_log_level_rec.statement_level) then
293: fa_debug_pkg.add(l_calling_fn, 'source is','group', p_log_level_rec);
294: end if;
295:
296: l_src_asset_hdr_rec := px_src_asset_hdr_rec;
297: l_src_asset_desc_rec := p_src_asset_desc_rec;
364: l_src_asset_fin_rec_adj.eofy_reserve := (-1)*nvl(px_group_reclass_options_rec.source_eofy_reserve,0);
365: -- end if;
366:
367: if (p_log_level_rec.statement_level) then
368: fa_debug_pkg.add(l_calling_fn, 'l_src_asset_fin_rec_old.eofy_reserve',
369: l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
370: fa_debug_pkg.add(l_calling_fn, 'l_src_asset_fin_rec_adj.eofy_reserve',
371: l_src_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
372: end if;
366:
367: if (p_log_level_rec.statement_level) then
368: fa_debug_pkg.add(l_calling_fn, 'l_src_asset_fin_rec_old.eofy_reserve',
369: l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
370: fa_debug_pkg.add(l_calling_fn, 'l_src_asset_fin_rec_adj.eofy_reserve',
371: l_src_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
372: end if;
373:
374: -- now process the adjustment on the group
374: -- now process the adjustment on the group
375: -- raf / adjusted_cost to be updated later
376:
377: if (p_log_level_rec.statement_level) then
378: fa_debug_pkg.add(l_calling_fn, 'source is','group', p_log_level_rec);
379: end if;
380:
381:
382: if (p_log_level_rec.statement_level) then
379: end if;
380:
381:
382: if (p_log_level_rec.statement_level) then
383: fa_debug_pkg.add(l_calling_fn, 'amort start date2',p_trans_rec.amortization_start_date , p_log_level_rec);
384: fa_debug_pkg.add(l_calling_fn, 'amort start date2a',px_src_trans_rec.amortization_start_date , p_log_level_rec);
385: end if;
386:
387: --
380:
381:
382: if (p_log_level_rec.statement_level) then
383: fa_debug_pkg.add(l_calling_fn, 'amort start date2',p_trans_rec.amortization_start_date , p_log_level_rec);
384: fa_debug_pkg.add(l_calling_fn, 'amort start date2a',px_src_trans_rec.amortization_start_date , p_log_level_rec);
385: end if;
386:
387: --
388: -- Initialize Member Tables
408:
409: l_src_asset_deprn_rec_adj.deprn_reserve := -1 * nvl(l_transfer_amount, 0);
410:
411: if (p_log_level_rec.statement_level) then
412: fa_debug_pkg.add(l_calling_fn, 'Getting previously transferred rsv', l_transfer_amount, p_log_level_rec);
413: fa_debug_pkg.add(l_calling_fn, 'l_src_asset_deprn_rec_adj.deprn_reserve',
414: l_src_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec);
415: end if;
416: end if;
409: l_src_asset_deprn_rec_adj.deprn_reserve := -1 * nvl(l_transfer_amount, 0);
410:
411: if (p_log_level_rec.statement_level) then
412: fa_debug_pkg.add(l_calling_fn, 'Getting previously transferred rsv', l_transfer_amount, p_log_level_rec);
413: fa_debug_pkg.add(l_calling_fn, 'l_src_asset_deprn_rec_adj.deprn_reserve',
414: l_src_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec);
415: end if;
416: end if;
417:
467: end if;
468: end if;
469:
470: if (p_log_level_rec.statement_level) then
471: fa_debug_pkg.add(l_calling_fn, 'amort start date2.5',p_trans_rec.amortization_start_date , p_log_level_rec);
472: fa_debug_pkg.add(l_calling_fn, 'amort start date2.5a',px_src_trans_rec.amortization_start_date , p_log_level_rec);
473: fa_debug_pkg.add(l_calling_fn, 'l_src_asset_fin_rec_new.eofy_reserve',l_src_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
474: end if;
475:
468: end if;
469:
470: if (p_log_level_rec.statement_level) then
471: fa_debug_pkg.add(l_calling_fn, 'amort start date2.5',p_trans_rec.amortization_start_date , p_log_level_rec);
472: fa_debug_pkg.add(l_calling_fn, 'amort start date2.5a',px_src_trans_rec.amortization_start_date , p_log_level_rec);
473: fa_debug_pkg.add(l_calling_fn, 'l_src_asset_fin_rec_new.eofy_reserve',l_src_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
474: end if;
475:
476: l_src_asset_deprn_rec_new := l_src_asset_deprn_rec_old;
469:
470: if (p_log_level_rec.statement_level) then
471: fa_debug_pkg.add(l_calling_fn, 'amort start date2.5',p_trans_rec.amortization_start_date , p_log_level_rec);
472: fa_debug_pkg.add(l_calling_fn, 'amort start date2.5a',px_src_trans_rec.amortization_start_date , p_log_level_rec);
473: fa_debug_pkg.add(l_calling_fn, 'l_src_asset_fin_rec_new.eofy_reserve',l_src_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
474: end if;
475:
476: l_src_asset_deprn_rec_new := l_src_asset_deprn_rec_old;
477:
519:
520: l_rsv_adj.adjustment_amount := px_group_reclass_options_rec.reserve_amount;
521:
522: if (p_log_level_rec.statement_level) then
523: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj','for rsv source', p_log_level_rec);
524: end if;
525:
526: if not FA_INS_ADJUST_PKG.faxinaj
527: (l_rsv_adj,
555:
556: if (nvl(px_group_reclass_options_rec.reserve_amount, 0) <> 0) then
557:
558: if (p_log_level_rec.statement_level) then
559: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj','for rsv source track', p_log_level_rec);
560: end if;
561:
562: if not FA_INS_ADJUST_PKG.faxinaj
563: (l_rsv_adj,
575:
576: else -- asset was originally standalone
577:
578: if (p_log_level_rec.statement_level) then
579: fa_debug_pkg.add(l_calling_fn, 'source is','standalone', p_log_level_rec);
580: end if;
581:
582:
583: -- whether expense or reserve transfer, amount must be set to
601:
602: px_src_trans_rec.amortization_start_date := p_trans_rec.amortization_start_date;
603:
604: if (p_log_level_rec.statement_level) then
605: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.deprn_method',l_src_asset_fin_rec_new.deprn_method_code, p_log_level_rec);
606: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.eofy_reserve',l_src_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
607: fa_debug_pkg.add(l_calling_fn, 'fin_rec_old.eofy_reserve',l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
608: fa_debug_pkg.add(l_calling_fn, 'amort start date3',p_trans_rec.amortization_start_date , p_log_level_rec);
609: fa_debug_pkg.add(l_calling_fn, 'amort start date3a',px_src_trans_rec.amortization_start_date , p_log_level_rec);
602: px_src_trans_rec.amortization_start_date := p_trans_rec.amortization_start_date;
603:
604: if (p_log_level_rec.statement_level) then
605: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.deprn_method',l_src_asset_fin_rec_new.deprn_method_code, p_log_level_rec);
606: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.eofy_reserve',l_src_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
607: fa_debug_pkg.add(l_calling_fn, 'fin_rec_old.eofy_reserve',l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
608: fa_debug_pkg.add(l_calling_fn, 'amort start date3',p_trans_rec.amortization_start_date , p_log_level_rec);
609: fa_debug_pkg.add(l_calling_fn, 'amort start date3a',px_src_trans_rec.amortization_start_date , p_log_level_rec);
610: fa_debug_pkg.add(l_calling_fn, 'destination tracking method',l_dest_asset_fin_rec_old.tracking_method, p_log_level_rec);
603:
604: if (p_log_level_rec.statement_level) then
605: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.deprn_method',l_src_asset_fin_rec_new.deprn_method_code, p_log_level_rec);
606: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.eofy_reserve',l_src_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
607: fa_debug_pkg.add(l_calling_fn, 'fin_rec_old.eofy_reserve',l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
608: fa_debug_pkg.add(l_calling_fn, 'amort start date3',p_trans_rec.amortization_start_date , p_log_level_rec);
609: fa_debug_pkg.add(l_calling_fn, 'amort start date3a',px_src_trans_rec.amortization_start_date , p_log_level_rec);
610: fa_debug_pkg.add(l_calling_fn, 'destination tracking method',l_dest_asset_fin_rec_old.tracking_method, p_log_level_rec);
611: end if;
604: if (p_log_level_rec.statement_level) then
605: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.deprn_method',l_src_asset_fin_rec_new.deprn_method_code, p_log_level_rec);
606: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.eofy_reserve',l_src_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
607: fa_debug_pkg.add(l_calling_fn, 'fin_rec_old.eofy_reserve',l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
608: fa_debug_pkg.add(l_calling_fn, 'amort start date3',p_trans_rec.amortization_start_date , p_log_level_rec);
609: fa_debug_pkg.add(l_calling_fn, 'amort start date3a',px_src_trans_rec.amortization_start_date , p_log_level_rec);
610: fa_debug_pkg.add(l_calling_fn, 'destination tracking method',l_dest_asset_fin_rec_old.tracking_method, p_log_level_rec);
611: end if;
612:
605: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.deprn_method',l_src_asset_fin_rec_new.deprn_method_code, p_log_level_rec);
606: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.eofy_reserve',l_src_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
607: fa_debug_pkg.add(l_calling_fn, 'fin_rec_old.eofy_reserve',l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
608: fa_debug_pkg.add(l_calling_fn, 'amort start date3',p_trans_rec.amortization_start_date , p_log_level_rec);
609: fa_debug_pkg.add(l_calling_fn, 'amort start date3a',px_src_trans_rec.amortization_start_date , p_log_level_rec);
610: fa_debug_pkg.add(l_calling_fn, 'destination tracking method',l_dest_asset_fin_rec_old.tracking_method, p_log_level_rec);
611: end if;
612:
613: -- If the asset was moved out of a group, deduct the asset's cost from the old group
606: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.eofy_reserve',l_src_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
607: fa_debug_pkg.add(l_calling_fn, 'fin_rec_old.eofy_reserve',l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
608: fa_debug_pkg.add(l_calling_fn, 'amort start date3',p_trans_rec.amortization_start_date , p_log_level_rec);
609: fa_debug_pkg.add(l_calling_fn, 'amort start date3a',px_src_trans_rec.amortization_start_date , p_log_level_rec);
610: fa_debug_pkg.add(l_calling_fn, 'destination tracking method',l_dest_asset_fin_rec_old.tracking_method, p_log_level_rec);
611: end if;
612:
613: -- If the asset was moved out of a group, deduct the asset's cost from the old group
614: if (l_src_asset_type_rec.asset_type <> 'GROUP' and
637: raise grp_rec_err;
638: end if;
639:
640: if (p_log_level_rec.statement_level) then
641: fa_debug_pkg.add(l_calling_fn, 'amort start date4',p_trans_rec.amortization_start_date , p_log_level_rec);
642: fa_debug_pkg.add(l_calling_fn, 'amort start date4a',px_src_trans_rec.amortization_start_date , p_log_level_rec);
643: end if;
644: end if;
645:
638: end if;
639:
640: if (p_log_level_rec.statement_level) then
641: fa_debug_pkg.add(l_calling_fn, 'amort start date4',p_trans_rec.amortization_start_date , p_log_level_rec);
642: fa_debug_pkg.add(l_calling_fn, 'amort start date4a',px_src_trans_rec.amortization_start_date , p_log_level_rec);
643: end if;
644: end if;
645:
646: --------------------------
702: l_asset_dist_tbl(i+l_distribution_id.count).transaction_units := l_units_assigned(i);
703: end loop;
704:
705: if (p_log_level_rec.statement_level) then
706: fa_debug_pkg.add(l_calling_fn, 'calling' ,'transfer api for standalone asset', p_log_level_rec);
707: end if;
708:
709: FA_TRANSFER_PUB.do_transfer
710: (p_api_version => l_api_version,
755: -- DESTINATION --
756: -----------------
757:
758: if (p_log_level_rec.statement_level) then
759: fa_debug_pkg.add(l_calling_fn, 'processing','detination asset', p_log_level_rec);
760: end if;
761:
762: -- For Source Group
763: -- Populate Subtract Ytd Flag
769: -- If the asset was moved into a group, add the asset's cost to the new group
770: if p_asset_fin_rec_new.group_asset_id is not null then
771:
772: if (p_log_level_rec.statement_level) then
773: fa_debug_pkg.add(l_calling_fn, 'processing dest as ','group', p_log_level_rec);
774: end if;
775:
776: l_dest_asset_hdr_rec := px_dest_asset_hdr_rec;
777: l_dest_asset_desc_rec := p_dest_asset_desc_rec;
834: ) then raise grp_rec_err;
835: end if;
836:
837: if (p_log_level_rec.statement_level) then
838: fa_debug_pkg.add(l_calling_fn, 'amort start date6', p_trans_rec.amortization_start_date , p_log_level_rec);
839: fa_debug_pkg.add(l_calling_fn, 'amort start date6a',px_dest_trans_rec.amortization_start_date , p_log_level_rec);
840: end if;
841:
842: -- If the deprn basis rule is defined as Year End Balance type,
835: end if;
836:
837: if (p_log_level_rec.statement_level) then
838: fa_debug_pkg.add(l_calling_fn, 'amort start date6', p_trans_rec.amortization_start_date , p_log_level_rec);
839: fa_debug_pkg.add(l_calling_fn, 'amort start date6a',px_dest_trans_rec.amortization_start_date , p_log_level_rec);
840: end if;
841:
842: -- If the deprn basis rule is defined as Year End Balance type,
843: -- new adjusted cost must be calculated based on the entered eofy_reserve
858: l_dest_asset_deprn_rec_adj.deprn_reserve := px_group_reclass_options_rec.reserve_amount;
859: end if;
860:
861: if (p_log_level_rec.statement_level) then
862: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_old.eofy_reserve',
863: l_dest_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
864: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_adj.eofy_reserve',
865: l_dest_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
866: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_new.eofy_reserve',
860:
861: if (p_log_level_rec.statement_level) then
862: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_old.eofy_reserve',
863: l_dest_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
864: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_adj.eofy_reserve',
865: l_dest_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
866: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_new.eofy_reserve',
867: l_dest_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
868: fa_debug_pkg.add(l_calling_fn, 'amort start date befor calling faxama',
862: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_old.eofy_reserve',
863: l_dest_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
864: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_adj.eofy_reserve',
865: l_dest_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
866: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_new.eofy_reserve',
867: l_dest_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
868: fa_debug_pkg.add(l_calling_fn, 'amort start date befor calling faxama',
869: px_dest_trans_rec.amortization_start_date , p_log_level_rec);
870: end if;
864: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_adj.eofy_reserve',
865: l_dest_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
866: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_new.eofy_reserve',
867: l_dest_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
868: fa_debug_pkg.add(l_calling_fn, 'amort start date befor calling faxama',
869: px_dest_trans_rec.amortization_start_date , p_log_level_rec);
870: end if;
871:
872: -- now process the adjustment on the group
919: end if;
920: end if;
921:
922: if (p_log_level_rec.statement_level) then
923: fa_debug_pkg.add(l_calling_fn, 'amort start date7', p_trans_rec.amortization_start_date , p_log_level_rec);
924: fa_debug_pkg.add(l_calling_fn, 'amort start date7a',px_dest_trans_rec.amortization_start_date , p_log_level_rec);
925: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_new.eofy_reserve',
926: l_dest_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
927: end if;
920: end if;
921:
922: if (p_log_level_rec.statement_level) then
923: fa_debug_pkg.add(l_calling_fn, 'amort start date7', p_trans_rec.amortization_start_date , p_log_level_rec);
924: fa_debug_pkg.add(l_calling_fn, 'amort start date7a',px_dest_trans_rec.amortization_start_date , p_log_level_rec);
925: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_new.eofy_reserve',
926: l_dest_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
927: end if;
928:
921:
922: if (p_log_level_rec.statement_level) then
923: fa_debug_pkg.add(l_calling_fn, 'amort start date7', p_trans_rec.amortization_start_date , p_log_level_rec);
924: fa_debug_pkg.add(l_calling_fn, 'amort start date7a',px_dest_trans_rec.amortization_start_date , p_log_level_rec);
925: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_new.eofy_reserve',
926: l_dest_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
927: end if;
928:
929: l_dest_asset_deprn_rec_new := l_dest_asset_deprn_rec_old;
972:
973: l_rsv_adj.adjustment_amount := px_group_reclass_options_rec.reserve_amount;
974:
975: if (p_log_level_rec.statement_level) then
976: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj','for rsv dest', p_log_level_rec);
977: end if;
978:
979: if not FA_INS_ADJUST_PKG.faxinaj
980: (l_rsv_adj,
1005:
1006: if (nvl(px_group_reclass_options_rec.reserve_amount, 0) <> 0) then
1007:
1008: if (p_log_level_rec.statement_level) then
1009: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj','for rsv dest track', p_log_level_rec);
1010: end if;
1011:
1012: if not FA_INS_ADJUST_PKG.faxinaj
1013: (l_rsv_adj,
1023:
1024: else -- asset is now standalone
1025:
1026: if (p_log_level_rec.statement_level) then
1027: fa_debug_pkg.add(l_calling_fn, 'processing dest as','standalone', p_log_level_rec);
1028: end if;
1029:
1030: -- set the main structs equal to member if asset is
1031: -- now standalone
1044:
1045: px_dest_trans_rec.amortization_start_date := p_trans_rec.amortization_start_date;
1046:
1047: if (p_log_level_rec.statement_level) then
1048: fa_debug_pkg.add(l_calling_fn, 'amort start date8',p_trans_rec.amortization_start_date , p_log_level_rec);
1049: fa_debug_pkg.add(l_calling_fn, 'amort start date8a',px_dest_trans_rec.amortization_start_date , p_log_level_rec);
1050: end if;
1051:
1052: -- If the asset was moved into a group, add the asset's cost to the new group
1045: px_dest_trans_rec.amortization_start_date := p_trans_rec.amortization_start_date;
1046:
1047: if (p_log_level_rec.statement_level) then
1048: fa_debug_pkg.add(l_calling_fn, 'amort start date8',p_trans_rec.amortization_start_date , p_log_level_rec);
1049: fa_debug_pkg.add(l_calling_fn, 'amort start date8a',px_dest_trans_rec.amortization_start_date , p_log_level_rec);
1050: end if;
1051:
1052: -- If the asset was moved into a group, add the asset's cost to the new group
1053: if (l_dest_asset_type_rec.asset_type <> 'GROUP' and
1078: end if;
1079: end if;
1080:
1081: if (p_log_level_rec.statement_level) then
1082: fa_debug_pkg.add(l_calling_fn, 'amort start date9',p_trans_rec.amortization_start_date, p_log_level_rec);
1083: fa_debug_pkg.add(l_calling_fn, 'amort start date9a',px_dest_trans_rec.amortization_start_date, p_log_level_rec);
1084: end if;
1085:
1086: --
1079: end if;
1080:
1081: if (p_log_level_rec.statement_level) then
1082: fa_debug_pkg.add(l_calling_fn, 'amort start date9',p_trans_rec.amortization_start_date, p_log_level_rec);
1083: fa_debug_pkg.add(l_calling_fn, 'amort start date9a',px_dest_trans_rec.amortization_start_date, p_log_level_rec);
1084: end if;
1085:
1086: --
1087: -- Initialize Member Tables
1141: p_period_rec => p_period_rec,
1142: p_mrc_sob_type_code => p_mrc_sob_type_code,
1143: p_calling_fn => l_calling_fn) then
1144: if (p_log_level_rec.statement_level) then
1145: fa_debug_pkg.add(l_calling_fn, 'Failed Calling',
1146: ' FA_RETIREMENT_PVT.Check_Terminal_Gain_Loss', p_log_level_rec);
1147: end if;
1148: raise grp_rec_err;
1149:
1256:
1257: BEGIN
1258:
1259: if (p_log_level_rec.statement_level) then
1260: fa_debug_pkg.add(l_calling_fn, 'amort start date inside 1',px_trans_rec.amortization_start_date, p_log_level_rec);
1261: end if;
1262:
1263:
1264: l_asset_fin_rec_new := p_asset_fin_rec_new;
1376: -- Bug4335926:
1377: -- Set l_rsv_adj.track_member_flag accordingly.
1378: --
1379: if (p_log_level_rec.statement_level) then
1380: fa_debug_pkg.add(l_calling_fn, 'p_asset_fin_rec_new.tracking_method',p_asset_fin_rec_new.tracking_method
1381: , p_log_level_rec => p_log_level_rec);
1382: end if;
1383:
1384: -- Bug5736734: Modified so that it only set flag for member tracking
1442: -- regardless of the reclass type
1443: --
1444:
1445: if (p_log_level_rec.statement_level) then
1446: fa_debug_pkg.add(l_calling_fn, 'debug message','just before if-clause to switch logic by reclass type', p_log_level_rec);
1447: fa_debug_pkg.add(l_calling_fn, 'group_reclass_type',px_group_reclass_options_rec.group_reclass_type, p_log_level_rec);
1448: fa_debug_pkg.add(l_calling_fn, 'asset_type',p_asset_type_rec.asset_type, p_log_level_rec);
1449: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec);
1450: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec);
1443: --
1444:
1445: if (p_log_level_rec.statement_level) then
1446: fa_debug_pkg.add(l_calling_fn, 'debug message','just before if-clause to switch logic by reclass type', p_log_level_rec);
1447: fa_debug_pkg.add(l_calling_fn, 'group_reclass_type',px_group_reclass_options_rec.group_reclass_type, p_log_level_rec);
1448: fa_debug_pkg.add(l_calling_fn, 'asset_type',p_asset_type_rec.asset_type, p_log_level_rec);
1449: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec);
1450: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec);
1451: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
1444:
1445: if (p_log_level_rec.statement_level) then
1446: fa_debug_pkg.add(l_calling_fn, 'debug message','just before if-clause to switch logic by reclass type', p_log_level_rec);
1447: fa_debug_pkg.add(l_calling_fn, 'group_reclass_type',px_group_reclass_options_rec.group_reclass_type, p_log_level_rec);
1448: fa_debug_pkg.add(l_calling_fn, 'asset_type',p_asset_type_rec.asset_type, p_log_level_rec);
1449: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec);
1450: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec);
1451: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
1452: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec);
1445: if (p_log_level_rec.statement_level) then
1446: fa_debug_pkg.add(l_calling_fn, 'debug message','just before if-clause to switch logic by reclass type', p_log_level_rec);
1447: fa_debug_pkg.add(l_calling_fn, 'group_reclass_type',px_group_reclass_options_rec.group_reclass_type, p_log_level_rec);
1448: fa_debug_pkg.add(l_calling_fn, 'asset_type',p_asset_type_rec.asset_type, p_log_level_rec);
1449: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec);
1450: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec);
1451: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
1452: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec);
1453: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec);
1446: fa_debug_pkg.add(l_calling_fn, 'debug message','just before if-clause to switch logic by reclass type', p_log_level_rec);
1447: fa_debug_pkg.add(l_calling_fn, 'group_reclass_type',px_group_reclass_options_rec.group_reclass_type, p_log_level_rec);
1448: fa_debug_pkg.add(l_calling_fn, 'asset_type',p_asset_type_rec.asset_type, p_log_level_rec);
1449: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec);
1450: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec);
1451: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
1452: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec);
1453: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec);
1454: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amt', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec);
1447: fa_debug_pkg.add(l_calling_fn, 'group_reclass_type',px_group_reclass_options_rec.group_reclass_type, p_log_level_rec);
1448: fa_debug_pkg.add(l_calling_fn, 'asset_type',p_asset_type_rec.asset_type, p_log_level_rec);
1449: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec);
1450: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec);
1451: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
1452: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec);
1453: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec);
1454: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amt', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec);
1455: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amt', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec);
1448: fa_debug_pkg.add(l_calling_fn, 'asset_type',p_asset_type_rec.asset_type, p_log_level_rec);
1449: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec);
1450: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec);
1451: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
1452: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec);
1453: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec);
1454: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amt', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec);
1455: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amt', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec);
1456: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1449: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec);
1450: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec);
1451: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
1452: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec);
1453: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec);
1454: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amt', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec);
1455: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amt', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec);
1456: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1457: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.group_asset_id', l_asset_fin_rec_new.group_asset_id, p_log_level_rec);
1450: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec);
1451: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
1452: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec);
1453: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec);
1454: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amt', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec);
1455: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amt', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec);
1456: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1457: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.group_asset_id', l_asset_fin_rec_new.group_asset_id, p_log_level_rec);
1458: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.tracking_method', l_asset_fin_rec_new.tracking_method, p_log_level_rec);
1451: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
1452: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec);
1453: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec);
1454: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amt', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec);
1455: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amt', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec);
1456: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1457: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.group_asset_id', l_asset_fin_rec_new.group_asset_id, p_log_level_rec);
1458: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.tracking_method', l_asset_fin_rec_new.tracking_method, p_log_level_rec);
1459: end if;
1452: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec);
1453: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec);
1454: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amt', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec);
1455: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amt', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec);
1456: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1457: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.group_asset_id', l_asset_fin_rec_new.group_asset_id, p_log_level_rec);
1458: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.tracking_method', l_asset_fin_rec_new.tracking_method, p_log_level_rec);
1459: end if;
1460:
1453: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec);
1454: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amt', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec);
1455: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amt', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec);
1456: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1457: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.group_asset_id', l_asset_fin_rec_new.group_asset_id, p_log_level_rec);
1458: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.tracking_method', l_asset_fin_rec_new.tracking_method, p_log_level_rec);
1459: end if;
1460:
1461: if (px_group_reclass_options_rec.group_reclass_type = 'MANUAL') then
1454: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amt', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec);
1455: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amt', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec);
1456: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1457: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.group_asset_id', l_asset_fin_rec_new.group_asset_id, p_log_level_rec);
1458: fa_debug_pkg.add(l_calling_fn, 'l_asset_fin_rec_new.tracking_method', l_asset_fin_rec_new.tracking_method, p_log_level_rec);
1459: end if;
1460:
1461: if (px_group_reclass_options_rec.group_reclass_type = 'MANUAL') then
1462:
1479: (p_asset_type_rec.asset_type = 'GROUP') and
1480: (p_asset_fin_rec_new.tracking_method is not null) then
1481:
1482: if (p_log_level_rec.statement_level) then
1483: fa_debug_pkg.add(l_calling_fn, 'entering','populate member amounts logic', p_log_level_rec);
1484: end if;
1485:
1486: if not fa_group_reclass2_pvt.populate_member_amounts
1487: (p_trans_rec => px_trans_rec,
1534: raise grp_rec_err;
1535: end if;
1536:
1537: if (p_log_level_rec.statement_level) then
1538: fa_debug_pkg.add(l_calling_fn, 'deprn expense from faxama - in tracking logic',l_deprn_exp, p_log_level_rec);
1539: end if;
1540: l_total_rsv_amount := nvl(px_group_reclass_options_rec.reserve_amount, 0);
1541: l_rsv_amount := nvl(px_group_reclass_options_rec.reserve_amount, 0);
1542: l_exp_amount := l_deprn_exp; -- l_rsv_amount;
1589: raise grp_rec_err;
1590: end if;
1591:
1592: if (p_log_level_rec.statement_level) then
1593: fa_debug_pkg.add(l_calling_fn, 'faxama from DPIS',l_deprn_exp, p_log_level_rec);
1594: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1595: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
1596: end if;
1597:
1590: end if;
1591:
1592: if (p_log_level_rec.statement_level) then
1593: fa_debug_pkg.add(l_calling_fn, 'faxama from DPIS',l_deprn_exp, p_log_level_rec);
1594: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1595: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
1596: end if;
1597:
1598: l_eofy_reserve := nvl(p_asset_fin_rec_old.eofy_reserve,0) - nvl(l_asset_fin_rec_new.eofy_reserve,0);
1591:
1592: if (p_log_level_rec.statement_level) then
1593: fa_debug_pkg.add(l_calling_fn, 'faxama from DPIS',l_deprn_exp, p_log_level_rec);
1594: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1595: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
1596: end if;
1597:
1598: l_eofy_reserve := nvl(p_asset_fin_rec_old.eofy_reserve,0) - nvl(l_asset_fin_rec_new.eofy_reserve,0);
1599: px_group_reclass_options_rec.source_eofy_reserve := l_eofy_reserve;
1607: -- Here, the total rsv amount is calculated as New.Eofy - Old.Eofy
1608: -- This may be negative amount.
1609: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
1610: if (p_log_level_rec.statement_level) then
1611: fa_debug_pkg.add(l_calling_fn, 'Source group method type', 'Year End Balance', p_log_level_rec);
1612: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1613: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
1614: end if;
1615: l_total_rsv_amount := nvl(p_asset_fin_rec_old.eofy_reserve,0) - nvl(l_asset_fin_rec_new.eofy_reserve,0);
1608: -- This may be negative amount.
1609: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
1610: if (p_log_level_rec.statement_level) then
1611: fa_debug_pkg.add(l_calling_fn, 'Source group method type', 'Year End Balance', p_log_level_rec);
1612: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1613: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
1614: end if;
1615: l_total_rsv_amount := nvl(p_asset_fin_rec_old.eofy_reserve,0) - nvl(l_asset_fin_rec_new.eofy_reserve,0);
1616: l_difference_eofy_reserve := l_total_rsv_amount;
1609: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
1610: if (p_log_level_rec.statement_level) then
1611: fa_debug_pkg.add(l_calling_fn, 'Source group method type', 'Year End Balance', p_log_level_rec);
1612: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1613: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
1614: end if;
1615: l_total_rsv_amount := nvl(p_asset_fin_rec_old.eofy_reserve,0) - nvl(l_asset_fin_rec_new.eofy_reserve,0);
1616: l_difference_eofy_reserve := l_total_rsv_amount;
1617: end if;
1660: end if;
1661: end if;
1662:
1663: if (p_log_level_rec.statement_level) then
1664: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(1)', l_exp_amount, p_log_level_rec);
1665: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(1)', l_rsv_amount, p_log_level_rec);
1666: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(1)', l_total_rsv_amount, p_log_level_rec);
1667: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(1)', l_eofy_reserve, p_log_level_rec);
1668: end if;
1661: end if;
1662:
1663: if (p_log_level_rec.statement_level) then
1664: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(1)', l_exp_amount, p_log_level_rec);
1665: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(1)', l_rsv_amount, p_log_level_rec);
1666: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(1)', l_total_rsv_amount, p_log_level_rec);
1667: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(1)', l_eofy_reserve, p_log_level_rec);
1668: end if;
1669:
1662:
1663: if (p_log_level_rec.statement_level) then
1664: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(1)', l_exp_amount, p_log_level_rec);
1665: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(1)', l_rsv_amount, p_log_level_rec);
1666: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(1)', l_total_rsv_amount, p_log_level_rec);
1667: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(1)', l_eofy_reserve, p_log_level_rec);
1668: end if;
1669:
1670: -- get the portion of expense which the member contributed
1663: if (p_log_level_rec.statement_level) then
1664: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(1)', l_exp_amount, p_log_level_rec);
1665: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(1)', l_rsv_amount, p_log_level_rec);
1666: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(1)', l_total_rsv_amount, p_log_level_rec);
1667: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(1)', l_eofy_reserve, p_log_level_rec);
1668: end if;
1669:
1670: -- get the portion of expense which the member contributed
1671: -- (starting from amort_start) for both source and desitnation
1675: -- we can use the reserve amount in full
1676: -- but for destination, we always need the amount
1677:
1678: if (p_log_level_rec.statement_level) then
1679: fa_debug_pkg.add(l_calling_fn, 'amort start date',px_trans_rec.amortization_start_date, p_log_level_rec);
1680: end if;
1681:
1682: if (px_trans_rec.amortization_start_date < p_period_rec.calendar_period_open_date) then
1683:
1681:
1682: if (px_trans_rec.amortization_start_date < p_period_rec.calendar_period_open_date) then
1683:
1684: if (p_log_level_rec.statement_level) then
1685: fa_debug_pkg.add(l_calling_fn, 'entering','catchup expense logic', p_log_level_rec);
1686: fa_debug_pkg.add(l_calling_fn, 'subtract_ytd_flag', fa_cache_pkg.fazcdrd_record.subtract_ytd_flag, p_log_level_rec);
1687: end if;
1688:
1689: if ((px_trans_rec.amortization_start_date <>
1682: if (px_trans_rec.amortization_start_date < p_period_rec.calendar_period_open_date) then
1683:
1684: if (p_log_level_rec.statement_level) then
1685: fa_debug_pkg.add(l_calling_fn, 'entering','catchup expense logic', p_log_level_rec);
1686: fa_debug_pkg.add(l_calling_fn, 'subtract_ytd_flag', fa_cache_pkg.fazcdrd_record.subtract_ytd_flag, p_log_level_rec);
1687: end if;
1688:
1689: if ((px_trans_rec.amortization_start_date <>
1690: p_mem_asset_fin_rec_new.date_placed_in_service or
1725: l_asset_fin_rec_adj.eofy_reserve := l_eofy_reserve;
1726: end if;
1727:
1728: if (p_log_level_rec.statement_level) then
1729: fa_debug_pkg.add(l_calling_fn, 'faxama from amort date','before calling', p_log_level_rec);
1730: fa_debug_pkg.add(l_calling_fn, 'Adj eofy_reserve', l_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
1731: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.deprn_reserve', p_asset_deprn_rec_old.deprn_reserve);
1732: fa_debug_pkg.add(l_calling_fn, 'l_backed_out_exp', l_backed_out_exp);
1733: end if;
1726: end if;
1727:
1728: if (p_log_level_rec.statement_level) then
1729: fa_debug_pkg.add(l_calling_fn, 'faxama from amort date','before calling', p_log_level_rec);
1730: fa_debug_pkg.add(l_calling_fn, 'Adj eofy_reserve', l_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
1731: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.deprn_reserve', p_asset_deprn_rec_old.deprn_reserve);
1732: fa_debug_pkg.add(l_calling_fn, 'l_backed_out_exp', l_backed_out_exp);
1733: end if;
1734:
1727:
1728: if (p_log_level_rec.statement_level) then
1729: fa_debug_pkg.add(l_calling_fn, 'faxama from amort date','before calling', p_log_level_rec);
1730: fa_debug_pkg.add(l_calling_fn, 'Adj eofy_reserve', l_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
1731: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.deprn_reserve', p_asset_deprn_rec_old.deprn_reserve);
1732: fa_debug_pkg.add(l_calling_fn, 'l_backed_out_exp', l_backed_out_exp);
1733: end if;
1734:
1735: --bug6983091: setting up-to-date reserve
1728: if (p_log_level_rec.statement_level) then
1729: fa_debug_pkg.add(l_calling_fn, 'faxama from amort date','before calling', p_log_level_rec);
1730: fa_debug_pkg.add(l_calling_fn, 'Adj eofy_reserve', l_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
1731: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.deprn_reserve', p_asset_deprn_rec_old.deprn_reserve);
1732: fa_debug_pkg.add(l_calling_fn, 'l_backed_out_exp', l_backed_out_exp);
1733: end if;
1734:
1735: --bug6983091: setting up-to-date reserve
1736: l_asset_deprn_rec_old := p_asset_deprn_rec_old;
1760: raise grp_rec_err;
1761: end if;
1762:
1763: if (p_log_level_rec.statement_level) then
1764: fa_debug_pkg.add(l_calling_fn, 'deprn expense from faxama',l_deprn_exp, p_log_level_rec);
1765: fa_debug_pkg.add(l_calling_fn, 'Target group method type(expense)', 'Year End Balance', p_log_level_rec);
1766: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1767: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
1768: end if;
1761: end if;
1762:
1763: if (p_log_level_rec.statement_level) then
1764: fa_debug_pkg.add(l_calling_fn, 'deprn expense from faxama',l_deprn_exp, p_log_level_rec);
1765: fa_debug_pkg.add(l_calling_fn, 'Target group method type(expense)', 'Year End Balance', p_log_level_rec);
1766: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1767: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
1768: end if;
1769:
1762:
1763: if (p_log_level_rec.statement_level) then
1764: fa_debug_pkg.add(l_calling_fn, 'deprn expense from faxama',l_deprn_exp, p_log_level_rec);
1765: fa_debug_pkg.add(l_calling_fn, 'Target group method type(expense)', 'Year End Balance', p_log_level_rec);
1766: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1767: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
1768: end if;
1769:
1770: -- l_eofy_reserve := nvl(l_asset_fin_rec_new.eofy_reserve,0);
1763: if (p_log_level_rec.statement_level) then
1764: fa_debug_pkg.add(l_calling_fn, 'deprn expense from faxama',l_deprn_exp, p_log_level_rec);
1765: fa_debug_pkg.add(l_calling_fn, 'Target group method type(expense)', 'Year End Balance', p_log_level_rec);
1766: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1767: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec);
1768: end if;
1769:
1770: -- l_eofy_reserve := nvl(l_asset_fin_rec_new.eofy_reserve,0);
1771:
1806:
1807: end if;
1808:
1809: if (p_log_level_rec.statement_level) then
1810: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(2)', l_exp_amount, p_log_level_rec);
1811: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(2)', l_rsv_amount, p_log_level_rec);
1812: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(2)', l_total_rsv_amount, p_log_level_rec);
1813: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(2)', l_eofy_reserve, p_log_level_rec);
1814: end if;
1807: end if;
1808:
1809: if (p_log_level_rec.statement_level) then
1810: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(2)', l_exp_amount, p_log_level_rec);
1811: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(2)', l_rsv_amount, p_log_level_rec);
1812: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(2)', l_total_rsv_amount, p_log_level_rec);
1813: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(2)', l_eofy_reserve, p_log_level_rec);
1814: end if;
1815:
1808:
1809: if (p_log_level_rec.statement_level) then
1810: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(2)', l_exp_amount, p_log_level_rec);
1811: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(2)', l_rsv_amount, p_log_level_rec);
1812: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(2)', l_total_rsv_amount, p_log_level_rec);
1813: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(2)', l_eofy_reserve, p_log_level_rec);
1814: end if;
1815:
1816: -- load the amounts regardless of the type of reclass
1809: if (p_log_level_rec.statement_level) then
1810: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(2)', l_exp_amount, p_log_level_rec);
1811: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(2)', l_rsv_amount, p_log_level_rec);
1812: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(2)', l_total_rsv_amount, p_log_level_rec);
1813: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(2)', l_eofy_reserve, p_log_level_rec);
1814: end if;
1815:
1816: -- load the amounts regardless of the type of reclass
1817: -- signs are assumed to all be the same (i.e. generally +ve)
1834: l_rsv_amount := l_total_rsv_amount - l_exp_amount;
1835: end if;
1836:
1837: if (p_log_level_rec.statement_level) then
1838: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(3)', l_exp_amount, p_log_level_rec);
1839: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(3)', l_rsv_amount, p_log_level_rec);
1840: end if;
1841:
1842: l_rsv_adj.adjustment_amount := l_rsv_amount;
1835: end if;
1836:
1837: if (p_log_level_rec.statement_level) then
1838: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(3)', l_exp_amount, p_log_level_rec);
1839: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(3)', l_rsv_amount, p_log_level_rec);
1840: end if;
1841:
1842: l_rsv_adj.adjustment_amount := l_rsv_amount;
1843: l_exp_adj.adjustment_amount := l_exp_amount; -- l_deprn_exp; (need to use one with same sign as tot_rsv)
1869: and px_trans_rec.calling_interface = 'FAXASSET') -- COMMENT THIS LINE OUT FOR NON-CONC PROGRAM TESTING
1870: ) then
1871:
1872: if (p_log_level_rec.statement_level) then
1873: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj','for rsv', p_log_level_rec);
1874: end if;
1875:
1876: if not FA_INS_ADJUST_PKG.faxinaj
1877: (l_rsv_adj,
1887: and px_trans_rec.calling_interface = 'FAXASSET') -- COMMENT THIS LINE OUT FOR NON-CONC PROGRAM TESTING
1888: ) then
1889:
1890: if (p_log_level_rec.statement_level) then
1891: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj','for exp', p_log_level_rec);
1892: end if;
1893:
1894: if not FA_INS_ADJUST_PKG.faxinaj
1895: (l_exp_adj,
1936: end if;
1937: end if;
1938:
1939: if (p_log_level_rec.statement_level) then
1940: fa_debug_pkg.add(l_calling_fn, 'just before last call to faxama-p_src_dest',p_src_dest, p_log_level_rec);
1941: fa_debug_pkg.add(l_calling_fn, 'existing rsv before last call to faxama',l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1942: fa_debug_pkg.add(l_calling_fn, 'new expense before last call to faxama',l_exp_amount, p_log_level_rec);
1943: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec);
1944: fa_debug_pkg.add(l_calling_fn, 'new total rsv before last call to faxama',l_total_rsv_amount, p_log_level_rec);
1937: end if;
1938:
1939: if (p_log_level_rec.statement_level) then
1940: fa_debug_pkg.add(l_calling_fn, 'just before last call to faxama-p_src_dest',p_src_dest, p_log_level_rec);
1941: fa_debug_pkg.add(l_calling_fn, 'existing rsv before last call to faxama',l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1942: fa_debug_pkg.add(l_calling_fn, 'new expense before last call to faxama',l_exp_amount, p_log_level_rec);
1943: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec);
1944: fa_debug_pkg.add(l_calling_fn, 'new total rsv before last call to faxama',l_total_rsv_amount, p_log_level_rec);
1945: fa_debug_pkg.add(l_calling_fn, 'total reserv before last call to faxama',l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1938:
1939: if (p_log_level_rec.statement_level) then
1940: fa_debug_pkg.add(l_calling_fn, 'just before last call to faxama-p_src_dest',p_src_dest, p_log_level_rec);
1941: fa_debug_pkg.add(l_calling_fn, 'existing rsv before last call to faxama',l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1942: fa_debug_pkg.add(l_calling_fn, 'new expense before last call to faxama',l_exp_amount, p_log_level_rec);
1943: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec);
1944: fa_debug_pkg.add(l_calling_fn, 'new total rsv before last call to faxama',l_total_rsv_amount, p_log_level_rec);
1945: fa_debug_pkg.add(l_calling_fn, 'total reserv before last call to faxama',l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1946: fa_debug_pkg.add(l_calling_fn, 'old eofy rsv before last call to faxama',p_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1939: if (p_log_level_rec.statement_level) then
1940: fa_debug_pkg.add(l_calling_fn, 'just before last call to faxama-p_src_dest',p_src_dest, p_log_level_rec);
1941: fa_debug_pkg.add(l_calling_fn, 'existing rsv before last call to faxama',l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1942: fa_debug_pkg.add(l_calling_fn, 'new expense before last call to faxama',l_exp_amount, p_log_level_rec);
1943: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec);
1944: fa_debug_pkg.add(l_calling_fn, 'new total rsv before last call to faxama',l_total_rsv_amount, p_log_level_rec);
1945: fa_debug_pkg.add(l_calling_fn, 'total reserv before last call to faxama',l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1946: fa_debug_pkg.add(l_calling_fn, 'old eofy rsv before last call to faxama',p_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1947: fa_debug_pkg.add(l_calling_fn, 'new eofy rsv before last call to faxama',l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1940: fa_debug_pkg.add(l_calling_fn, 'just before last call to faxama-p_src_dest',p_src_dest, p_log_level_rec);
1941: fa_debug_pkg.add(l_calling_fn, 'existing rsv before last call to faxama',l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1942: fa_debug_pkg.add(l_calling_fn, 'new expense before last call to faxama',l_exp_amount, p_log_level_rec);
1943: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec);
1944: fa_debug_pkg.add(l_calling_fn, 'new total rsv before last call to faxama',l_total_rsv_amount, p_log_level_rec);
1945: fa_debug_pkg.add(l_calling_fn, 'total reserv before last call to faxama',l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1946: fa_debug_pkg.add(l_calling_fn, 'old eofy rsv before last call to faxama',p_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1947: fa_debug_pkg.add(l_calling_fn, 'new eofy rsv before last call to faxama',l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1948: fa_debug_pkg.add(l_calling_fn, 'adj eofy rsv before last call to faxama',l_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
1941: fa_debug_pkg.add(l_calling_fn, 'existing rsv before last call to faxama',l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1942: fa_debug_pkg.add(l_calling_fn, 'new expense before last call to faxama',l_exp_amount, p_log_level_rec);
1943: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec);
1944: fa_debug_pkg.add(l_calling_fn, 'new total rsv before last call to faxama',l_total_rsv_amount, p_log_level_rec);
1945: fa_debug_pkg.add(l_calling_fn, 'total reserv before last call to faxama',l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1946: fa_debug_pkg.add(l_calling_fn, 'old eofy rsv before last call to faxama',p_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1947: fa_debug_pkg.add(l_calling_fn, 'new eofy rsv before last call to faxama',l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1948: fa_debug_pkg.add(l_calling_fn, 'adj eofy rsv before last call to faxama',l_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
1949: fa_debug_pkg.add(l_calling_fn, 'amort start date',px_trans_rec.amortization_start_date, p_log_level_rec);
1942: fa_debug_pkg.add(l_calling_fn, 'new expense before last call to faxama',l_exp_amount, p_log_level_rec);
1943: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec);
1944: fa_debug_pkg.add(l_calling_fn, 'new total rsv before last call to faxama',l_total_rsv_amount, p_log_level_rec);
1945: fa_debug_pkg.add(l_calling_fn, 'total reserv before last call to faxama',l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1946: fa_debug_pkg.add(l_calling_fn, 'old eofy rsv before last call to faxama',p_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1947: fa_debug_pkg.add(l_calling_fn, 'new eofy rsv before last call to faxama',l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1948: fa_debug_pkg.add(l_calling_fn, 'adj eofy rsv before last call to faxama',l_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
1949: fa_debug_pkg.add(l_calling_fn, 'amort start date',px_trans_rec.amortization_start_date, p_log_level_rec);
1950: end if;
1943: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec);
1944: fa_debug_pkg.add(l_calling_fn, 'new total rsv before last call to faxama',l_total_rsv_amount, p_log_level_rec);
1945: fa_debug_pkg.add(l_calling_fn, 'total reserv before last call to faxama',l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1946: fa_debug_pkg.add(l_calling_fn, 'old eofy rsv before last call to faxama',p_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1947: fa_debug_pkg.add(l_calling_fn, 'new eofy rsv before last call to faxama',l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1948: fa_debug_pkg.add(l_calling_fn, 'adj eofy rsv before last call to faxama',l_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
1949: fa_debug_pkg.add(l_calling_fn, 'amort start date',px_trans_rec.amortization_start_date, p_log_level_rec);
1950: end if;
1951:
1944: fa_debug_pkg.add(l_calling_fn, 'new total rsv before last call to faxama',l_total_rsv_amount, p_log_level_rec);
1945: fa_debug_pkg.add(l_calling_fn, 'total reserv before last call to faxama',l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1946: fa_debug_pkg.add(l_calling_fn, 'old eofy rsv before last call to faxama',p_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1947: fa_debug_pkg.add(l_calling_fn, 'new eofy rsv before last call to faxama',l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1948: fa_debug_pkg.add(l_calling_fn, 'adj eofy rsv before last call to faxama',l_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
1949: fa_debug_pkg.add(l_calling_fn, 'amort start date',px_trans_rec.amortization_start_date, p_log_level_rec);
1950: end if;
1951:
1952: -- +++ This won't be necessary
1945: fa_debug_pkg.add(l_calling_fn, 'total reserv before last call to faxama',l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1946: fa_debug_pkg.add(l_calling_fn, 'old eofy rsv before last call to faxama',p_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1947: fa_debug_pkg.add(l_calling_fn, 'new eofy rsv before last call to faxama',l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
1948: fa_debug_pkg.add(l_calling_fn, 'adj eofy rsv before last call to faxama',l_asset_fin_rec_adj.eofy_reserve, p_log_level_rec);
1949: fa_debug_pkg.add(l_calling_fn, 'amort start date',px_trans_rec.amortization_start_date, p_log_level_rec);
1950: end if;
1951:
1952: -- +++ This won't be necessary
1953: l_trans_rec := px_trans_rec;
1971: p_asset_type_rec.asset_type = 'CAPITALIZED')) then
1972:
1973:
1974: if (p_log_level_rec.statement_level) then
1975: fa_debug_pkg.add(l_calling_fn, 'LAST CALL TO FAXAMA', 'CALLING FAXAMA', p_log_level_rec);
1976: end if;
1977:
1978:
1979: -- use calc_raf_adj_cost rather than faxama if trx is in current
1982: if (px_group_reclass_options_rec.group_reclass_type = 'MANUAL' or
1983: px_trans_rec.amortization_start_date >= p_period_rec.calendar_period_open_date) then
1984:
1985: if (p_log_level_rec.statement_level) then
1986: fa_debug_pkg.add(l_calling_fn, 'calling','calc_raf_adj_cost', p_log_level_rec);
1987: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.rsv', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec);
1988: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.bonus_rsv', p_asset_deprn_rec_old.bonus_deprn_reserve, p_log_level_rec);
1989: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.rsv', l_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec);
1990: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.bonus_rsv', l_asset_deprn_rec_adj.bonus_deprn_reserve, p_log_level_rec);
1983: px_trans_rec.amortization_start_date >= p_period_rec.calendar_period_open_date) then
1984:
1985: if (p_log_level_rec.statement_level) then
1986: fa_debug_pkg.add(l_calling_fn, 'calling','calc_raf_adj_cost', p_log_level_rec);
1987: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.rsv', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec);
1988: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.bonus_rsv', p_asset_deprn_rec_old.bonus_deprn_reserve, p_log_level_rec);
1989: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.rsv', l_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec);
1990: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.bonus_rsv', l_asset_deprn_rec_adj.bonus_deprn_reserve, p_log_level_rec);
1991: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.rsv', l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1984:
1985: if (p_log_level_rec.statement_level) then
1986: fa_debug_pkg.add(l_calling_fn, 'calling','calc_raf_adj_cost', p_log_level_rec);
1987: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.rsv', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec);
1988: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.bonus_rsv', p_asset_deprn_rec_old.bonus_deprn_reserve, p_log_level_rec);
1989: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.rsv', l_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec);
1990: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.bonus_rsv', l_asset_deprn_rec_adj.bonus_deprn_reserve, p_log_level_rec);
1991: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.rsv', l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1992: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.bonus_rsv', l_asset_deprn_rec_new.bonus_deprn_reserve, p_log_level_rec);
1985: if (p_log_level_rec.statement_level) then
1986: fa_debug_pkg.add(l_calling_fn, 'calling','calc_raf_adj_cost', p_log_level_rec);
1987: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.rsv', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec);
1988: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.bonus_rsv', p_asset_deprn_rec_old.bonus_deprn_reserve, p_log_level_rec);
1989: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.rsv', l_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec);
1990: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.bonus_rsv', l_asset_deprn_rec_adj.bonus_deprn_reserve, p_log_level_rec);
1991: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.rsv', l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1992: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.bonus_rsv', l_asset_deprn_rec_new.bonus_deprn_reserve, p_log_level_rec);
1993: end if;
1986: fa_debug_pkg.add(l_calling_fn, 'calling','calc_raf_adj_cost', p_log_level_rec);
1987: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.rsv', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec);
1988: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.bonus_rsv', p_asset_deprn_rec_old.bonus_deprn_reserve, p_log_level_rec);
1989: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.rsv', l_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec);
1990: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.bonus_rsv', l_asset_deprn_rec_adj.bonus_deprn_reserve, p_log_level_rec);
1991: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.rsv', l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1992: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.bonus_rsv', l_asset_deprn_rec_new.bonus_deprn_reserve, p_log_level_rec);
1993: end if;
1994:
1987: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.rsv', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec);
1988: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.bonus_rsv', p_asset_deprn_rec_old.bonus_deprn_reserve, p_log_level_rec);
1989: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.rsv', l_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec);
1990: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.bonus_rsv', l_asset_deprn_rec_adj.bonus_deprn_reserve, p_log_level_rec);
1991: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.rsv', l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1992: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.bonus_rsv', l_asset_deprn_rec_new.bonus_deprn_reserve, p_log_level_rec);
1993: end if;
1994:
1995: if not FA_AMORT_PVT.calc_raf_adj_cost
1988: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.bonus_rsv', p_asset_deprn_rec_old.bonus_deprn_reserve, p_log_level_rec);
1989: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.rsv', l_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec);
1990: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.bonus_rsv', l_asset_deprn_rec_adj.bonus_deprn_reserve, p_log_level_rec);
1991: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.rsv', l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec);
1992: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.bonus_rsv', l_asset_deprn_rec_new.bonus_deprn_reserve, p_log_level_rec);
1993: end if;
1994:
1995: if not FA_AMORT_PVT.calc_raf_adj_cost
1996: (p_trans_rec => px_trans_rec,
2033: end if;
2034: end if;
2035:
2036: if (p_log_level_rec.statement_level) then
2037: fa_debug_pkg.add(l_calling_fn, 'new adjusted_cost after last call to faxama',l_asset_fin_rec_new.adjusted_cost, p_log_level_rec);
2038: fa_debug_pkg.add(l_calling_fn, 'new eofy_reserve after last call to faxama',l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
2039: end if;
2040:
2041: -- if reclassing out of the group to standalone, then
2034: end if;
2035:
2036: if (p_log_level_rec.statement_level) then
2037: fa_debug_pkg.add(l_calling_fn, 'new adjusted_cost after last call to faxama',l_asset_fin_rec_new.adjusted_cost, p_log_level_rec);
2038: fa_debug_pkg.add(l_calling_fn, 'new eofy_reserve after last call to faxama',l_asset_fin_rec_new.eofy_reserve, p_log_level_rec);
2039: end if;
2040:
2041: -- if reclassing out of the group to standalone, then
2042: -- insure the amount doesn't exceed the recoverable_cost
2247:
2248: BEGIN
2249:
2250: if (p_log_level_rec.statement_level) then
2251: fa_debug_pkg.add(l_calling_fn, 'populate member amt',p_trans_rec.amortization_start_date, p_log_level_rec);
2252: end if;
2253:
2254: l_asset_fin_rec_new := p_asset_fin_rec_new;
2255: h_book_type_code := p_asset_hdr_rec.book_type_code;
2319: -- calculate current eofy_reserve using amounts above
2320: h_eofy_reserve := p_mem_asset_fin_rec_new.eofy_reserve;
2321:
2322: if (p_log_level_rec.statement_level) then
2323: fa_debug_pkg.add(l_calling_fn,'h_eofy_reserve',h_eofy_reserve, p_log_level_rec);
2324: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec);
2325: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec);
2326: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec);
2327: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec);
2320: h_eofy_reserve := p_mem_asset_fin_rec_new.eofy_reserve;
2321:
2322: if (p_log_level_rec.statement_level) then
2323: fa_debug_pkg.add(l_calling_fn,'h_eofy_reserve',h_eofy_reserve, p_log_level_rec);
2324: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec);
2325: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec);
2326: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec);
2327: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec);
2328: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec);
2321:
2322: if (p_log_level_rec.statement_level) then
2323: fa_debug_pkg.add(l_calling_fn,'h_eofy_reserve',h_eofy_reserve, p_log_level_rec);
2324: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec);
2325: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec);
2326: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec);
2327: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec);
2328: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec);
2329: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec);
2322: if (p_log_level_rec.statement_level) then
2323: fa_debug_pkg.add(l_calling_fn,'h_eofy_reserve',h_eofy_reserve, p_log_level_rec);
2324: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec);
2325: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec);
2326: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec);
2327: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec);
2328: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec);
2329: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec);
2330: end if;
2323: fa_debug_pkg.add(l_calling_fn,'h_eofy_reserve',h_eofy_reserve, p_log_level_rec);
2324: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec);
2325: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec);
2326: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec);
2327: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec);
2328: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec);
2329: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec);
2330: end if;
2331:
2324: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec);
2325: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec);
2326: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec);
2327: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec);
2328: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec);
2329: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec);
2330: end if;
2331:
2332: if nvl(h_eofy_reserve,0) = 0 then
2325: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec);
2326: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec);
2327: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec);
2328: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec);
2329: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec);
2330: end if;
2331:
2332: if nvl(h_eofy_reserve,0) = 0 then
2333: if h_cur_fiscal_year = h_ds_fiscal_year then
2345: px_group_reclass_options_rec.reserve_amount := h_reserve_dpis_current;
2346: end if;
2347:
2348: if (p_log_level_rec.statement_level) then
2349: fa_debug_pkg.add(l_calling_fn,'reserve_amount',px_group_reclass_options_rec.reserve_amount, p_log_level_rec);
2350: end if;
2351:
2352: -- Get Period Counter of amortization start date
2353: if (p_trans_rec.amortization_start_date <> p_mem_asset_fin_rec_new.date_placed_in_service) then
2408:
2409: end if;
2410:
2411: if (p_log_level_rec.statement_level) then
2412: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec);
2413: fa_debug_pkg.add(l_calling_fn,'h_amort_fiscal_year',h_amort_fiscal_year, p_log_level_rec);
2414: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec);
2415: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec);
2416: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec);
2409: end if;
2410:
2411: if (p_log_level_rec.statement_level) then
2412: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec);
2413: fa_debug_pkg.add(l_calling_fn,'h_amort_fiscal_year',h_amort_fiscal_year, p_log_level_rec);
2414: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec);
2415: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec);
2416: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec);
2417: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec);
2410:
2411: if (p_log_level_rec.statement_level) then
2412: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec);
2413: fa_debug_pkg.add(l_calling_fn,'h_amort_fiscal_year',h_amort_fiscal_year, p_log_level_rec);
2414: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec);
2415: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec);
2416: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec);
2417: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec);
2418: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec);
2411: if (p_log_level_rec.statement_level) then
2412: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec);
2413: fa_debug_pkg.add(l_calling_fn,'h_amort_fiscal_year',h_amort_fiscal_year, p_log_level_rec);
2414: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec);
2415: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec);
2416: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec);
2417: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec);
2418: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec);
2419: end if;
2412: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec);
2413: fa_debug_pkg.add(l_calling_fn,'h_amort_fiscal_year',h_amort_fiscal_year, p_log_level_rec);
2414: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec);
2415: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec);
2416: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec);
2417: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec);
2418: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec);
2419: end if;
2420:
2413: fa_debug_pkg.add(l_calling_fn,'h_amort_fiscal_year',h_amort_fiscal_year, p_log_level_rec);
2414: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec);
2415: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec);
2416: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec);
2417: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec);
2418: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec);
2419: end if;
2420:
2421: -- calculate current eofy_reserve using amounts above
2414: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec);
2415: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec);
2416: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec);
2417: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec);
2418: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec);
2419: end if;
2420:
2421: -- calculate current eofy_reserve using amounts above
2422: if h_cur_fiscal_year <> h_amort_fiscal_year then
2439:
2440: px_group_reclass_options_rec.source_eofy_reserve := h_eofy_reserve;
2441:
2442: if (p_log_level_rec.statement_level) then
2443: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec);
2444: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec);
2445: fa_debug_pkg.add(l_calling_fn,'source_exp_amount',px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
2446: fa_debug_pkg.add(l_calling_fn,'eofy_reserve',px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec);
2447: end if;
2440: px_group_reclass_options_rec.source_eofy_reserve := h_eofy_reserve;
2441:
2442: if (p_log_level_rec.statement_level) then
2443: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec);
2444: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec);
2445: fa_debug_pkg.add(l_calling_fn,'source_exp_amount',px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
2446: fa_debug_pkg.add(l_calling_fn,'eofy_reserve',px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec);
2447: end if;
2448:
2441:
2442: if (p_log_level_rec.statement_level) then
2443: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec);
2444: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec);
2445: fa_debug_pkg.add(l_calling_fn,'source_exp_amount',px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
2446: fa_debug_pkg.add(l_calling_fn,'eofy_reserve',px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec);
2447: end if;
2448:
2449: -- x_eofy_reserve := h_eofy_reserve;
2442: if (p_log_level_rec.statement_level) then
2443: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec);
2444: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec);
2445: fa_debug_pkg.add(l_calling_fn,'source_exp_amount',px_group_reclass_options_rec.source_exp_amount, p_log_level_rec);
2446: fa_debug_pkg.add(l_calling_fn,'eofy_reserve',px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec);
2447: end if;
2448:
2449: -- x_eofy_reserve := h_eofy_reserve;
2450: