[Home] [Help]
119:
120:
121: BEGIN
122:
123: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
124: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec => p_log_level_rec);
125: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec => p_log_level_rec);
126: fa_debug_pkg.add(l_calling_fn, 'p_trans_rec.amort_start_date', p_trans_rec.amortization_start_date, p_log_level_rec => p_log_level_rec);
127:
120:
121: BEGIN
122:
123: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
124: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec => p_log_level_rec);
125: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec => p_log_level_rec);
126: fa_debug_pkg.add(l_calling_fn, 'p_trans_rec.amort_start_date', p_trans_rec.amortization_start_date, p_log_level_rec => p_log_level_rec);
127:
128: -- note that adjustments to both expense and reserve will be handled
121: BEGIN
122:
123: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
124: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec => p_log_level_rec);
125: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec => p_log_level_rec);
126: fa_debug_pkg.add(l_calling_fn, 'p_trans_rec.amort_start_date', p_trans_rec.amortization_start_date, p_log_level_rec => p_log_level_rec);
127:
128: -- note that adjustments to both expense and reserve will be handled
129: -- here in and not in the adjustment api/calc engine (via faadjust)
122:
123: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
124: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec => p_log_level_rec);
125: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec => p_log_level_rec);
126: fa_debug_pkg.add(l_calling_fn, 'p_trans_rec.amort_start_date', p_trans_rec.amortization_start_date, p_log_level_rec => p_log_level_rec);
127:
128: -- note that adjustments to both expense and reserve will be handled
129: -- here in and not in the adjustment api/calc engine (via faadjust)
130: -- note this code will be bypassed by a cominbation of the following:
153: -- verify a change in group is occurring / otherwise error out
154: -- store the "reclass code" for easy reference at various
155: -- points in the api
156: if (p_log_level_rec.statement_level) then
157: 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 => p_log_level_rec);
158: 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 => p_log_level_rec);
159: 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 => p_log_level_rec);
160: end if;
161:
154: -- store the "reclass code" for easy reference at various
155: -- points in the api
156: if (p_log_level_rec.statement_level) then
157: 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 => p_log_level_rec);
158: 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 => p_log_level_rec);
159: 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 => p_log_level_rec);
160: end if;
161:
162:
155: -- points in the api
156: if (p_log_level_rec.statement_level) then
157: 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 => p_log_level_rec);
158: 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 => p_log_level_rec);
159: 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 => p_log_level_rec);
160: end if;
161:
162:
163: if (nvl(p_asset_fin_rec_old.group_asset_id, -99) = nvl(p_asset_fin_rec_new.group_asset_id, -99)) then
172: l_group_reclass_code := 'NONE-GRP';
173: end if;
174:
175: if (p_log_level_rec.statement_level) then
176: fa_debug_pkg.add(l_calling_fn, 'reclass code', l_group_reclass_code, p_log_level_rec => p_log_level_rec);
177: end if;
178:
179: -- validate intercompany impacts before doing anything else
180: if (l_group_reclass_code <> 'GRP-NONE' and
255: -- Bug#3737670
256: -- get the old fin and deprn information of destination group
257:
258: if (p_log_level_rec.statement_level) then
259: fa_debug_pkg.add(l_calling_fn, 'px_dest_asset_hdr_rec.asset_id:book_type_code',px_dest_asset_hdr_rec.asset_id||':'||
260: px_dest_asset_hdr_rec.book_type_code, p_log_level_rec => p_log_level_rec);
261: end if;
262:
263: if l_group_reclass_code <> 'GRP-NONE' then
275: -- SOURCE --
276: ------------
277:
278: if (p_log_level_rec.statement_level) then
279: fa_debug_pkg.add(l_calling_fn, 'processing','source asset', p_log_level_rec => p_log_level_rec);
280: end if;
281:
282: -- For Source Group
283: -- Populate Subtract Ytd Flag
290: -- If the asset was moved out of a group, deduct the asset's cost from the old group
291: if p_asset_fin_rec_old.group_asset_id is not null then
292:
293: if (p_log_level_rec.statement_level) then
294: fa_debug_pkg.add(l_calling_fn, 'source is','group', p_log_level_rec => p_log_level_rec);
295: end if;
296:
297: l_src_asset_hdr_rec := px_src_asset_hdr_rec;
298: l_src_asset_desc_rec := p_src_asset_desc_rec;
371: l_src_asset_fin_rec_adj.eofy_reserve := (-1)*nvl(px_group_reclass_options_rec.source_eofy_reserve,0);
372: -- end if;
373:
374: if (p_log_level_rec.statement_level) then
375: fa_debug_pkg.add(l_calling_fn, 'l_src_asset_fin_rec_old.eofy_reserve',
376: l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
377: fa_debug_pkg.add(l_calling_fn, 'l_src_asset_fin_rec_adj.eofy_reserve',
378: l_src_asset_fin_rec_adj.eofy_reserve, p_log_level_rec => p_log_level_rec);
379: end if;
373:
374: if (p_log_level_rec.statement_level) then
375: fa_debug_pkg.add(l_calling_fn, 'l_src_asset_fin_rec_old.eofy_reserve',
376: l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
377: fa_debug_pkg.add(l_calling_fn, 'l_src_asset_fin_rec_adj.eofy_reserve',
378: l_src_asset_fin_rec_adj.eofy_reserve, p_log_level_rec => p_log_level_rec);
379: end if;
380:
381: -- now process the adjustment on the group
381: -- now process the adjustment on the group
382: -- raf / adjusted_cost to be updated later
383:
384: if (p_log_level_rec.statement_level) then
385: fa_debug_pkg.add(l_calling_fn, 'source is','group', p_log_level_rec => p_log_level_rec);
386: end if;
387:
388:
389: if (p_log_level_rec.statement_level) then
386: end if;
387:
388:
389: if (p_log_level_rec.statement_level) then
390: fa_debug_pkg.add(l_calling_fn, 'amort start date2',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
391: fa_debug_pkg.add(l_calling_fn, 'amort start date2a',px_src_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
392: end if;
393:
394: --
387:
388:
389: if (p_log_level_rec.statement_level) then
390: fa_debug_pkg.add(l_calling_fn, 'amort start date2',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
391: fa_debug_pkg.add(l_calling_fn, 'amort start date2a',px_src_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
392: end if;
393:
394: --
395: -- Initialize Member Tables
419:
420: l_src_asset_deprn_rec_adj.deprn_reserve := -1 * nvl(l_transfer_amount, 0);
421:
422: if (p_log_level_rec.statement_level) then
423: fa_debug_pkg.add(l_calling_fn, 'Getting previously transferred rsv', l_transfer_amount , p_log_level_rec => p_log_level_rec);
424: fa_debug_pkg.add(l_calling_fn, 'l_src_asset_deprn_rec_adj.deprn_reserve', l_src_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec => p_log_level_rec);
425: end if;
426: end if;
427: l_reserve_amt := p_asset_deprn_rec_old.deprn_reserve;
420: l_src_asset_deprn_rec_adj.deprn_reserve := -1 * nvl(l_transfer_amount, 0);
421:
422: if (p_log_level_rec.statement_level) then
423: fa_debug_pkg.add(l_calling_fn, 'Getting previously transferred rsv', l_transfer_amount , p_log_level_rec => p_log_level_rec);
424: fa_debug_pkg.add(l_calling_fn, 'l_src_asset_deprn_rec_adj.deprn_reserve', l_src_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec => p_log_level_rec);
425: end if;
426: end if;
427: l_reserve_amt := p_asset_deprn_rec_old.deprn_reserve;
428: end if;
491: end if;
492: end if;
493:
494: if (p_log_level_rec.statement_level) then
495: fa_debug_pkg.add(l_calling_fn, 'amort start date2.5',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
496: fa_debug_pkg.add(l_calling_fn, 'amort start date2.5a',px_src_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
497: 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 => p_log_level_rec);
498: end if;
499:
492: end if;
493:
494: if (p_log_level_rec.statement_level) then
495: fa_debug_pkg.add(l_calling_fn, 'amort start date2.5',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
496: fa_debug_pkg.add(l_calling_fn, 'amort start date2.5a',px_src_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
497: 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 => p_log_level_rec);
498: end if;
499:
500: l_src_asset_deprn_rec_new := l_src_asset_deprn_rec_old;
493:
494: if (p_log_level_rec.statement_level) then
495: fa_debug_pkg.add(l_calling_fn, 'amort start date2.5',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
496: fa_debug_pkg.add(l_calling_fn, 'amort start date2.5a',px_src_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
497: 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 => p_log_level_rec);
498: end if;
499:
500: l_src_asset_deprn_rec_new := l_src_asset_deprn_rec_old;
501:
501:
502: else -- asset was originally standalone
503:
504: if (p_log_level_rec.statement_level) then
505: fa_debug_pkg.add(l_calling_fn, 'source is','standalone', p_log_level_rec => p_log_level_rec);
506: end if;
507:
508:
509: -- whether expense or reserve transfer, amount must be set to
527:
528: px_src_trans_rec.amortization_start_date := p_trans_rec.amortization_start_date;
529:
530: if (p_log_level_rec.statement_level) then
531: 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 => p_log_level_rec);
532: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.eofy_reserve',l_src_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
533: fa_debug_pkg.add(l_calling_fn, 'fin_rec_old.eofy_reserve',l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
534: fa_debug_pkg.add(l_calling_fn, 'amort start date3',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
535: fa_debug_pkg.add(l_calling_fn, 'amort start date3a',px_src_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
528: px_src_trans_rec.amortization_start_date := p_trans_rec.amortization_start_date;
529:
530: if (p_log_level_rec.statement_level) then
531: 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 => p_log_level_rec);
532: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.eofy_reserve',l_src_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
533: fa_debug_pkg.add(l_calling_fn, 'fin_rec_old.eofy_reserve',l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
534: fa_debug_pkg.add(l_calling_fn, 'amort start date3',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
535: fa_debug_pkg.add(l_calling_fn, 'amort start date3a',px_src_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
536: fa_debug_pkg.add(l_calling_fn, 'destination tracking method',l_dest_asset_fin_rec_old.tracking_method, p_log_level_rec => p_log_level_rec);
529:
530: if (p_log_level_rec.statement_level) then
531: 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 => p_log_level_rec);
532: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.eofy_reserve',l_src_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
533: fa_debug_pkg.add(l_calling_fn, 'fin_rec_old.eofy_reserve',l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
534: fa_debug_pkg.add(l_calling_fn, 'amort start date3',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
535: fa_debug_pkg.add(l_calling_fn, 'amort start date3a',px_src_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
536: fa_debug_pkg.add(l_calling_fn, 'destination tracking method',l_dest_asset_fin_rec_old.tracking_method, p_log_level_rec => p_log_level_rec);
537: end if;
530: if (p_log_level_rec.statement_level) then
531: 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 => p_log_level_rec);
532: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.eofy_reserve',l_src_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
533: fa_debug_pkg.add(l_calling_fn, 'fin_rec_old.eofy_reserve',l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
534: fa_debug_pkg.add(l_calling_fn, 'amort start date3',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
535: fa_debug_pkg.add(l_calling_fn, 'amort start date3a',px_src_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
536: fa_debug_pkg.add(l_calling_fn, 'destination tracking method',l_dest_asset_fin_rec_old.tracking_method, p_log_level_rec => p_log_level_rec);
537: end if;
538:
531: 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 => p_log_level_rec);
532: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.eofy_reserve',l_src_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
533: fa_debug_pkg.add(l_calling_fn, 'fin_rec_old.eofy_reserve',l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
534: fa_debug_pkg.add(l_calling_fn, 'amort start date3',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
535: fa_debug_pkg.add(l_calling_fn, 'amort start date3a',px_src_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
536: fa_debug_pkg.add(l_calling_fn, 'destination tracking method',l_dest_asset_fin_rec_old.tracking_method, p_log_level_rec => p_log_level_rec);
537: end if;
538:
539: -- If the asset was moved out of a group, deduct the asset's cost from the old group
532: fa_debug_pkg.add(l_calling_fn, 'fin_rec_new.eofy_reserve',l_src_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
533: fa_debug_pkg.add(l_calling_fn, 'fin_rec_old.eofy_reserve',l_src_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
534: fa_debug_pkg.add(l_calling_fn, 'amort start date3',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
535: fa_debug_pkg.add(l_calling_fn, 'amort start date3a',px_src_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
536: fa_debug_pkg.add(l_calling_fn, 'destination tracking method',l_dest_asset_fin_rec_old.tracking_method, p_log_level_rec => p_log_level_rec);
537: end if;
538:
539: -- If the asset was moved out of a group, deduct the asset's cost from the old group
540: if (l_src_asset_type_rec.asset_type <> 'GROUP' and
563: raise grp_rec_err;
564: end if;
565:
566: if (p_log_level_rec.statement_level) then
567: fa_debug_pkg.add(l_calling_fn, 'amort start date4',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
568: fa_debug_pkg.add(l_calling_fn, 'amort start date4a',px_src_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
569: end if;
570: end if;
571:
564: end if;
565:
566: if (p_log_level_rec.statement_level) then
567: fa_debug_pkg.add(l_calling_fn, 'amort start date4',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
568: fa_debug_pkg.add(l_calling_fn, 'amort start date4a',px_src_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
569: end if;
570: end if;
571:
572: -----------------
573: -- DESTINATION --
574: -----------------
575:
576: if (p_log_level_rec.statement_level) then
577: fa_debug_pkg.add(l_calling_fn, 'processing','detination asset', p_log_level_rec => p_log_level_rec);
578: end if;
579:
580: -- For Source Group
581: -- Populate Subtract Ytd Flag
587: -- If the asset was moved into a group, add the asset's cost to the new group
588: if p_asset_fin_rec_new.group_asset_id is not null then
589:
590: if (p_log_level_rec.statement_level) then
591: fa_debug_pkg.add(l_calling_fn, 'processing dest as ','group', p_log_level_rec => p_log_level_rec);
592: end if;
593:
594: l_dest_asset_hdr_rec := px_dest_asset_hdr_rec;
595: l_dest_asset_desc_rec := p_dest_asset_desc_rec;
654: , p_log_level_rec => p_log_level_rec) then raise grp_rec_err;
655: end if;
656:
657: if (p_log_level_rec.statement_level) then
658: fa_debug_pkg.add(l_calling_fn, 'amort start date6', p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
659: fa_debug_pkg.add(l_calling_fn, 'amort start date6a',px_dest_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
660: end if;
661:
662: -- If the deprn basis rule is defined as Year End Balance type,
655: end if;
656:
657: if (p_log_level_rec.statement_level) then
658: fa_debug_pkg.add(l_calling_fn, 'amort start date6', p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
659: fa_debug_pkg.add(l_calling_fn, 'amort start date6a',px_dest_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
660: end if;
661:
662: -- If the deprn basis rule is defined as Year End Balance type,
663: -- new adjusted cost must be calculated based on the entered eofy_reserve
678: l_dest_asset_deprn_rec_adj.deprn_reserve := px_group_reclass_options_rec.reserve_amount;
679: end if;
680:
681: if (p_log_level_rec.statement_level) then
682: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_old.eofy_reserve',
683: l_dest_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
684: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_adj.eofy_reserve',
685: l_dest_asset_fin_rec_adj.eofy_reserve, p_log_level_rec => p_log_level_rec);
686: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_new.eofy_reserve',
680:
681: if (p_log_level_rec.statement_level) then
682: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_old.eofy_reserve',
683: l_dest_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
684: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_adj.eofy_reserve',
685: l_dest_asset_fin_rec_adj.eofy_reserve, p_log_level_rec => p_log_level_rec);
686: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_new.eofy_reserve',
687: l_dest_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
688: fa_debug_pkg.add(l_calling_fn, 'amort start date befor calling faxama',
682: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_old.eofy_reserve',
683: l_dest_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
684: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_adj.eofy_reserve',
685: l_dest_asset_fin_rec_adj.eofy_reserve, p_log_level_rec => p_log_level_rec);
686: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_new.eofy_reserve',
687: l_dest_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
688: fa_debug_pkg.add(l_calling_fn, 'amort start date befor calling faxama',
689: px_dest_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
690: end if;
684: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_adj.eofy_reserve',
685: l_dest_asset_fin_rec_adj.eofy_reserve, p_log_level_rec => p_log_level_rec);
686: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_new.eofy_reserve',
687: l_dest_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
688: fa_debug_pkg.add(l_calling_fn, 'amort start date befor calling faxama',
689: px_dest_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
690: end if;
691: /*Bug# 8527619 */
692: if p_mrc_sob_type_code <> 'R' then
753: end if;
754: end if;
755:
756: if (p_log_level_rec.statement_level) then
757: fa_debug_pkg.add(l_calling_fn, 'amort start date7', p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
758: fa_debug_pkg.add(l_calling_fn, 'amort start date7a',px_dest_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
759: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_new.eofy_reserve',
760: l_dest_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
761: end if;
754: end if;
755:
756: if (p_log_level_rec.statement_level) then
757: fa_debug_pkg.add(l_calling_fn, 'amort start date7', p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
758: fa_debug_pkg.add(l_calling_fn, 'amort start date7a',px_dest_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
759: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_new.eofy_reserve',
760: l_dest_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
761: end if;
762:
755:
756: if (p_log_level_rec.statement_level) then
757: fa_debug_pkg.add(l_calling_fn, 'amort start date7', p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
758: fa_debug_pkg.add(l_calling_fn, 'amort start date7a',px_dest_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
759: fa_debug_pkg.add(l_calling_fn, 'l_dest_asset_fin_rec_new.eofy_reserve',
760: l_dest_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
761: end if;
762:
763: l_dest_asset_deprn_rec_new := l_dest_asset_deprn_rec_old;
764:
765: else -- asset is now standalone
766:
767: if (p_log_level_rec.statement_level) then
768: fa_debug_pkg.add(l_calling_fn, 'processing dest as','standalone', p_log_level_rec => p_log_level_rec);
769: end if;
770:
771: -- set the main structs equal to member if asset is
772: -- now standalone
785:
786: px_dest_trans_rec.amortization_start_date := p_trans_rec.amortization_start_date;
787:
788: if (p_log_level_rec.statement_level) then
789: fa_debug_pkg.add(l_calling_fn, 'amort start date8',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
790: fa_debug_pkg.add(l_calling_fn, 'amort start date8a',px_dest_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
791: end if;
792:
793: -- If the asset was moved into a group, add the asset's cost to the new group
786: px_dest_trans_rec.amortization_start_date := p_trans_rec.amortization_start_date;
787:
788: if (p_log_level_rec.statement_level) then
789: fa_debug_pkg.add(l_calling_fn, 'amort start date8',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
790: fa_debug_pkg.add(l_calling_fn, 'amort start date8a',px_dest_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
791: end if;
792:
793: -- If the asset was moved into a group, add the asset's cost to the new group
794: if (l_dest_asset_type_rec.asset_type <> 'GROUP' and
819: end if;
820: end if;
821:
822: if (p_log_level_rec.statement_level) then
823: fa_debug_pkg.add(l_calling_fn, 'amort start date9',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
824: fa_debug_pkg.add(l_calling_fn, 'amort start date9a',px_dest_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
825: end if;
826:
827: --
820: end if;
821:
822: if (p_log_level_rec.statement_level) then
823: fa_debug_pkg.add(l_calling_fn, 'amort start date9',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
824: fa_debug_pkg.add(l_calling_fn, 'amort start date9a',px_dest_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
825: end if;
826:
827: --
828: -- Initialize Member Tables
898: p_period_rec => p_period_rec,
899: p_mrc_sob_type_code => p_mrc_sob_type_code,
900: p_calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec) then
901: if (p_log_level_rec.statement_level) then
902: fa_debug_pkg.add(l_calling_fn, 'Failed Calling',
903: ' FA_RETIREMENT_PVT.Check_Terminal_Gain_Loss', p_log_level_rec => p_log_level_rec);
904: end if;
905: raise grp_rec_err;
906:
1016:
1017: BEGIN
1018:
1019: if (p_log_level_rec.statement_level) then
1020: fa_debug_pkg.add(l_calling_fn, 'amort start date inside 1',px_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
1021: end if;
1022:
1023:
1024: l_asset_fin_rec_new := p_asset_fin_rec_new;
1197: -- regardless of the reclass type
1198: --
1199:
1200: if (p_log_level_rec.statement_level) then
1201: fa_debug_pkg.add(l_calling_fn, 'debug message','just before if-clause to switch logic by reclass type', p_log_level_rec => p_log_level_rec);
1202: fa_debug_pkg.add(l_calling_fn, 'group_reclass_type',px_group_reclass_options_rec.group_reclass_type, p_log_level_rec => p_log_level_rec);
1203: fa_debug_pkg.add(l_calling_fn, 'asset_type',p_asset_type_rec.asset_type, p_log_level_rec => p_log_level_rec);
1204: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec => p_log_level_rec);
1205: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec => p_log_level_rec);
1198: --
1199:
1200: if (p_log_level_rec.statement_level) then
1201: fa_debug_pkg.add(l_calling_fn, 'debug message','just before if-clause to switch logic by reclass type', p_log_level_rec => p_log_level_rec);
1202: fa_debug_pkg.add(l_calling_fn, 'group_reclass_type',px_group_reclass_options_rec.group_reclass_type, p_log_level_rec => p_log_level_rec);
1203: fa_debug_pkg.add(l_calling_fn, 'asset_type',p_asset_type_rec.asset_type, p_log_level_rec => p_log_level_rec);
1204: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec => p_log_level_rec);
1205: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec => p_log_level_rec);
1206: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
1199:
1200: if (p_log_level_rec.statement_level) then
1201: fa_debug_pkg.add(l_calling_fn, 'debug message','just before if-clause to switch logic by reclass type', p_log_level_rec => p_log_level_rec);
1202: fa_debug_pkg.add(l_calling_fn, 'group_reclass_type',px_group_reclass_options_rec.group_reclass_type, p_log_level_rec => p_log_level_rec);
1203: fa_debug_pkg.add(l_calling_fn, 'asset_type',p_asset_type_rec.asset_type, p_log_level_rec => p_log_level_rec);
1204: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec => p_log_level_rec);
1205: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec => p_log_level_rec);
1206: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
1207: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec => p_log_level_rec);
1200: if (p_log_level_rec.statement_level) then
1201: fa_debug_pkg.add(l_calling_fn, 'debug message','just before if-clause to switch logic by reclass type', p_log_level_rec => p_log_level_rec);
1202: fa_debug_pkg.add(l_calling_fn, 'group_reclass_type',px_group_reclass_options_rec.group_reclass_type, p_log_level_rec => p_log_level_rec);
1203: fa_debug_pkg.add(l_calling_fn, 'asset_type',p_asset_type_rec.asset_type, p_log_level_rec => p_log_level_rec);
1204: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec => p_log_level_rec);
1205: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec => p_log_level_rec);
1206: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
1207: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec => p_log_level_rec);
1208: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec => p_log_level_rec);
1201: fa_debug_pkg.add(l_calling_fn, 'debug message','just before if-clause to switch logic by reclass type', p_log_level_rec => p_log_level_rec);
1202: fa_debug_pkg.add(l_calling_fn, 'group_reclass_type',px_group_reclass_options_rec.group_reclass_type, p_log_level_rec => p_log_level_rec);
1203: fa_debug_pkg.add(l_calling_fn, 'asset_type',p_asset_type_rec.asset_type, p_log_level_rec => p_log_level_rec);
1204: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec => p_log_level_rec);
1205: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec => p_log_level_rec);
1206: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
1207: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec => p_log_level_rec);
1208: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec => p_log_level_rec);
1209: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amount', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec => p_log_level_rec);
1202: fa_debug_pkg.add(l_calling_fn, 'group_reclass_type',px_group_reclass_options_rec.group_reclass_type, p_log_level_rec => p_log_level_rec);
1203: fa_debug_pkg.add(l_calling_fn, 'asset_type',p_asset_type_rec.asset_type, p_log_level_rec => p_log_level_rec);
1204: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec => p_log_level_rec);
1205: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec => p_log_level_rec);
1206: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
1207: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec => p_log_level_rec);
1208: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec => p_log_level_rec);
1209: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amount', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec => p_log_level_rec);
1210: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amount', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec => p_log_level_rec);
1203: fa_debug_pkg.add(l_calling_fn, 'asset_type',p_asset_type_rec.asset_type, p_log_level_rec => p_log_level_rec);
1204: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec => p_log_level_rec);
1205: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec => p_log_level_rec);
1206: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
1207: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec => p_log_level_rec);
1208: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec => p_log_level_rec);
1209: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amount', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec => p_log_level_rec);
1210: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amount', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec => p_log_level_rec);
1211: 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 => p_log_level_rec);
1204: fa_debug_pkg.add(l_calling_fn, 'tracking_method',p_asset_fin_rec_new.tracking_method, p_log_level_rec => p_log_level_rec);
1205: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec => p_log_level_rec);
1206: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
1207: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec => p_log_level_rec);
1208: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec => p_log_level_rec);
1209: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amount', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec => p_log_level_rec);
1210: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amount', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec => p_log_level_rec);
1211: 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 => p_log_level_rec);
1212: 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 => p_log_level_rec);
1205: fa_debug_pkg.add(l_calling_fn, 'Source or Dest',p_src_dest, p_log_level_rec => p_log_level_rec);
1206: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
1207: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec => p_log_level_rec);
1208: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec => p_log_level_rec);
1209: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amount', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec => p_log_level_rec);
1210: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amount', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec => p_log_level_rec);
1211: 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 => p_log_level_rec);
1212: 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 => p_log_level_rec);
1213: 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 => p_log_level_rec);
1206: fa_debug_pkg.add(l_calling_fn, 'src exp amount', px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
1207: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec => p_log_level_rec);
1208: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec => p_log_level_rec);
1209: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amount', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec => p_log_level_rec);
1210: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amount', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec => p_log_level_rec);
1211: 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 => p_log_level_rec);
1212: 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 => p_log_level_rec);
1213: 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 => p_log_level_rec);
1214: end if;
1207: fa_debug_pkg.add(l_calling_fn, 'dest exp amount', px_group_reclass_options_rec.destination_exp_amount, p_log_level_rec => p_log_level_rec);
1208: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec => p_log_level_rec);
1209: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amount', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec => p_log_level_rec);
1210: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amount', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec => p_log_level_rec);
1211: 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 => p_log_level_rec);
1212: 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 => p_log_level_rec);
1213: 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 => p_log_level_rec);
1214: end if;
1215:
1208: fa_debug_pkg.add(l_calling_fn, 'reserve amount', px_group_reclass_options_rec.reserve_amount, p_log_level_rec => p_log_level_rec);
1209: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amount', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec => p_log_level_rec);
1210: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amount', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec => p_log_level_rec);
1211: 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 => p_log_level_rec);
1212: 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 => p_log_level_rec);
1213: 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 => p_log_level_rec);
1214: end if;
1215:
1216: if (px_group_reclass_options_rec.group_reclass_type = 'MANUAL') then
1209: fa_debug_pkg.add(l_calling_fn, 'src eofy reserve amount', px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec => p_log_level_rec);
1210: fa_debug_pkg.add(l_calling_fn, 'dest eofy_reserve amount', px_group_reclass_options_rec.destination_eofy_reserve, p_log_level_rec => p_log_level_rec);
1211: 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 => p_log_level_rec);
1212: 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 => p_log_level_rec);
1213: 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 => p_log_level_rec);
1214: end if;
1215:
1216: if (px_group_reclass_options_rec.group_reclass_type = 'MANUAL') then
1217:
1234: (p_asset_type_rec.asset_type = 'GROUP') and
1235: (p_asset_fin_rec_new.tracking_method is not null) then
1236:
1237: if (p_log_level_rec.statement_level) then
1238: fa_debug_pkg.add(l_calling_fn, 'entering','populate member amounts logic', p_log_level_rec => p_log_level_rec);
1239: end if;
1240:
1241: if not fa_group_reclass2_pvt.populate_member_amounts
1242: (p_trans_rec => px_trans_rec,
1288: raise grp_rec_err;
1289: end if;
1290:
1291: if (p_log_level_rec.statement_level) then
1292: fa_debug_pkg.add(l_calling_fn, 'deprn expense from faxama - in tracking logic',l_deprn_exp, p_log_level_rec => p_log_level_rec);
1293: end if;
1294: l_total_rsv_amount := nvl(px_group_reclass_options_rec.reserve_amount, 0);
1295: l_rsv_amount := nvl(px_group_reclass_options_rec.reserve_amount, 0);
1296: l_exp_amount := l_deprn_exp; -- l_rsv_amount;
1343: raise grp_rec_err;
1344: end if;
1345:
1346: if (p_log_level_rec.statement_level) then
1347: fa_debug_pkg.add(l_calling_fn, 'faxama from DPIS',l_deprn_exp, p_log_level_rec => p_log_level_rec);
1348: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
1349: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
1350: end if;
1351:
1344: end if;
1345:
1346: if (p_log_level_rec.statement_level) then
1347: fa_debug_pkg.add(l_calling_fn, 'faxama from DPIS',l_deprn_exp, p_log_level_rec => p_log_level_rec);
1348: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
1349: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
1350: end if;
1351:
1352: l_eofy_reserve := nvl(p_asset_fin_rec_old.eofy_reserve,0) - nvl(l_asset_fin_rec_new.eofy_reserve,0);
1345:
1346: if (p_log_level_rec.statement_level) then
1347: fa_debug_pkg.add(l_calling_fn, 'faxama from DPIS',l_deprn_exp, p_log_level_rec => p_log_level_rec);
1348: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
1349: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
1350: end if;
1351:
1352: l_eofy_reserve := nvl(p_asset_fin_rec_old.eofy_reserve,0) - nvl(l_asset_fin_rec_new.eofy_reserve,0);
1353: px_group_reclass_options_rec.source_eofy_reserve := l_eofy_reserve;
1361: -- Here, the total rsv amount is calculated as New.Eofy - Old.Eofy
1362: -- This may be negative amount.
1363: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
1364: if (p_log_level_rec.statement_level) then
1365: fa_debug_pkg.add(l_calling_fn, 'Source group method type', 'Year End Balance', p_log_level_rec => p_log_level_rec);
1366: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
1367: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
1368: end if;
1369: l_total_rsv_amount := nvl(p_asset_fin_rec_old.eofy_reserve,0) - nvl(l_asset_fin_rec_new.eofy_reserve,0);
1362: -- This may be negative amount.
1363: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
1364: if (p_log_level_rec.statement_level) then
1365: fa_debug_pkg.add(l_calling_fn, 'Source group method type', 'Year End Balance', p_log_level_rec => p_log_level_rec);
1366: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
1367: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
1368: end if;
1369: l_total_rsv_amount := nvl(p_asset_fin_rec_old.eofy_reserve,0) - nvl(l_asset_fin_rec_new.eofy_reserve,0);
1370: l_difference_eofy_reserve := l_total_rsv_amount;
1363: if nvl(fa_cache_pkg.fazcdrd_record.subtract_ytd_flag,'N') = 'Y' then
1364: if (p_log_level_rec.statement_level) then
1365: fa_debug_pkg.add(l_calling_fn, 'Source group method type', 'Year End Balance', p_log_level_rec => p_log_level_rec);
1366: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
1367: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
1368: end if;
1369: l_total_rsv_amount := nvl(p_asset_fin_rec_old.eofy_reserve,0) - nvl(l_asset_fin_rec_new.eofy_reserve,0);
1370: l_difference_eofy_reserve := l_total_rsv_amount;
1371: end if;
1415: end if;
1416: end if;
1417:
1418: if (p_log_level_rec.statement_level) then
1419: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(1)', l_exp_amount);
1420: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(1)', l_rsv_amount);
1421: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(1)', l_total_rsv_amount);
1422: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(1)', l_eofy_reserve);
1423: end if;
1416: end if;
1417:
1418: if (p_log_level_rec.statement_level) then
1419: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(1)', l_exp_amount);
1420: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(1)', l_rsv_amount);
1421: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(1)', l_total_rsv_amount);
1422: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(1)', l_eofy_reserve);
1423: end if;
1424:
1417:
1418: if (p_log_level_rec.statement_level) then
1419: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(1)', l_exp_amount);
1420: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(1)', l_rsv_amount);
1421: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(1)', l_total_rsv_amount);
1422: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(1)', l_eofy_reserve);
1423: end if;
1424:
1425: -- get the portion of expense which the member contributed
1418: if (p_log_level_rec.statement_level) then
1419: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(1)', l_exp_amount);
1420: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(1)', l_rsv_amount);
1421: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(1)', l_total_rsv_amount);
1422: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(1)', l_eofy_reserve);
1423: end if;
1424:
1425: -- get the portion of expense which the member contributed
1426: -- (starting from amort_start) for both source and desitnation
1430: -- we can use the reserve amount in full
1431: -- but for destination, we always need the amount
1432:
1433: if (p_log_level_rec.statement_level) then
1434: fa_debug_pkg.add(l_calling_fn, 'amort start date',px_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
1435: end if;
1436:
1437: if (px_trans_rec.amortization_start_date < p_period_rec.calendar_period_open_date) then
1438:
1436:
1437: if (px_trans_rec.amortization_start_date < p_period_rec.calendar_period_open_date) then
1438:
1439: if (p_log_level_rec.statement_level) then
1440: fa_debug_pkg.add(l_calling_fn, 'entering','catchup expense logic', p_log_level_rec => p_log_level_rec);
1441: fa_debug_pkg.add(l_calling_fn, 'subtract_ytd_flag', fa_cache_pkg.fazcdrd_record.subtract_ytd_flag, p_log_level_rec => p_log_level_rec);
1442: end if;
1443:
1444: if ((px_trans_rec.amortization_start_date <> p_mem_asset_fin_rec_new.date_placed_in_service OR
1437: if (px_trans_rec.amortization_start_date < p_period_rec.calendar_period_open_date) then
1438:
1439: if (p_log_level_rec.statement_level) then
1440: fa_debug_pkg.add(l_calling_fn, 'entering','catchup expense logic', p_log_level_rec => p_log_level_rec);
1441: fa_debug_pkg.add(l_calling_fn, 'subtract_ytd_flag', fa_cache_pkg.fazcdrd_record.subtract_ytd_flag, p_log_level_rec => p_log_level_rec);
1442: end if;
1443:
1444: if ((px_trans_rec.amortization_start_date <> p_mem_asset_fin_rec_new.date_placed_in_service OR
1445: p_src_dest = 'DESTINATION') and
1473: l_asset_fin_rec_adj.eofy_reserve := l_eofy_reserve;
1474: end if;
1475:
1476: if (p_log_level_rec.statement_level) then
1477: fa_debug_pkg.add(l_calling_fn, 'faxama from amort date','before calling', p_log_level_rec => p_log_level_rec);
1478: fa_debug_pkg.add(l_calling_fn, 'Adj eofy_reserve', l_asset_fin_rec_adj.eofy_reserve, p_log_level_rec => p_log_level_rec);
1479: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.deprn_reserve', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec => p_log_level_rec);
1480: fa_debug_pkg.add(l_calling_fn, 'l_backed_out_exp', l_backed_out_exp, p_log_level_rec => p_log_level_rec);
1481: end if;
1474: end if;
1475:
1476: if (p_log_level_rec.statement_level) then
1477: fa_debug_pkg.add(l_calling_fn, 'faxama from amort date','before calling', p_log_level_rec => p_log_level_rec);
1478: fa_debug_pkg.add(l_calling_fn, 'Adj eofy_reserve', l_asset_fin_rec_adj.eofy_reserve, p_log_level_rec => p_log_level_rec);
1479: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.deprn_reserve', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec => p_log_level_rec);
1480: fa_debug_pkg.add(l_calling_fn, 'l_backed_out_exp', l_backed_out_exp, p_log_level_rec => p_log_level_rec);
1481: end if;
1482:
1475:
1476: if (p_log_level_rec.statement_level) then
1477: fa_debug_pkg.add(l_calling_fn, 'faxama from amort date','before calling', p_log_level_rec => p_log_level_rec);
1478: fa_debug_pkg.add(l_calling_fn, 'Adj eofy_reserve', l_asset_fin_rec_adj.eofy_reserve, p_log_level_rec => p_log_level_rec);
1479: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.deprn_reserve', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec => p_log_level_rec);
1480: fa_debug_pkg.add(l_calling_fn, 'l_backed_out_exp', l_backed_out_exp, p_log_level_rec => p_log_level_rec);
1481: end if;
1482:
1483: --bug6983091: setting up-to-date reserve
1476: if (p_log_level_rec.statement_level) then
1477: fa_debug_pkg.add(l_calling_fn, 'faxama from amort date','before calling', p_log_level_rec => p_log_level_rec);
1478: fa_debug_pkg.add(l_calling_fn, 'Adj eofy_reserve', l_asset_fin_rec_adj.eofy_reserve, p_log_level_rec => p_log_level_rec);
1479: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.deprn_reserve', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec => p_log_level_rec);
1480: fa_debug_pkg.add(l_calling_fn, 'l_backed_out_exp', l_backed_out_exp, p_log_level_rec => p_log_level_rec);
1481: end if;
1482:
1483: --bug6983091: setting up-to-date reserve
1484: l_asset_deprn_rec_old := p_asset_deprn_rec_old;
1509: raise grp_rec_err;
1510: end if;
1511:
1512: if (p_log_level_rec.statement_level) then
1513: fa_debug_pkg.add(l_calling_fn, 'deprn expense from faxama',l_deprn_exp, p_log_level_rec => p_log_level_rec);
1514: fa_debug_pkg.add(l_calling_fn, 'Target group method type(expense)', 'Year End Balance');
1515: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
1516: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
1517: end if;
1510: end if;
1511:
1512: if (p_log_level_rec.statement_level) then
1513: fa_debug_pkg.add(l_calling_fn, 'deprn expense from faxama',l_deprn_exp, p_log_level_rec => p_log_level_rec);
1514: fa_debug_pkg.add(l_calling_fn, 'Target group method type(expense)', 'Year End Balance');
1515: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
1516: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
1517: end if;
1518:
1511:
1512: if (p_log_level_rec.statement_level) then
1513: fa_debug_pkg.add(l_calling_fn, 'deprn expense from faxama',l_deprn_exp, p_log_level_rec => p_log_level_rec);
1514: fa_debug_pkg.add(l_calling_fn, 'Target group method type(expense)', 'Year End Balance');
1515: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
1516: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
1517: end if;
1518:
1519: -- l_eofy_reserve := nvl(l_asset_fin_rec_new.eofy_reserve,0);
1512: if (p_log_level_rec.statement_level) then
1513: fa_debug_pkg.add(l_calling_fn, 'deprn expense from faxama',l_deprn_exp, p_log_level_rec => p_log_level_rec);
1514: fa_debug_pkg.add(l_calling_fn, 'Target group method type(expense)', 'Year End Balance');
1515: fa_debug_pkg.add(l_calling_fn, 'New eofy_reserve', l_asset_fin_rec_new.eofy_reserve, p_log_level_rec => p_log_level_rec);
1516: fa_debug_pkg.add(l_calling_fn, 'Old eofy_reserve', p_asset_fin_rec_old.eofy_reserve, p_log_level_rec => p_log_level_rec);
1517: end if;
1518:
1519: -- l_eofy_reserve := nvl(l_asset_fin_rec_new.eofy_reserve,0);
1520:
1555:
1556: end if;
1557:
1558: if (p_log_level_rec.statement_level) then
1559: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(2)', l_exp_amount);
1560: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(2)', l_rsv_amount);
1561: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(2)', l_total_rsv_amount);
1562: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(2)', l_eofy_reserve);
1563: end if;
1556: end if;
1557:
1558: if (p_log_level_rec.statement_level) then
1559: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(2)', l_exp_amount);
1560: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(2)', l_rsv_amount);
1561: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(2)', l_total_rsv_amount);
1562: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(2)', l_eofy_reserve);
1563: end if;
1564:
1557:
1558: if (p_log_level_rec.statement_level) then
1559: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(2)', l_exp_amount);
1560: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(2)', l_rsv_amount);
1561: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(2)', l_total_rsv_amount);
1562: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(2)', l_eofy_reserve);
1563: end if;
1564:
1565: -- load the amounts regardless of the type of reclass
1558: if (p_log_level_rec.statement_level) then
1559: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(2)', l_exp_amount);
1560: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(2)', l_rsv_amount);
1561: fa_debug_pkg.add(l_calling_fn, 'l_total_rsv_amount(2)', l_total_rsv_amount);
1562: fa_debug_pkg.add(l_calling_fn, 'l_eofy_reserve(2)', l_eofy_reserve);
1563: end if;
1564:
1565: -- load the amounts regardless of the type of reclass
1566: -- signs are assumed to all be the same (i.e. generally +ve)
1583: l_rsv_amount := l_total_rsv_amount - l_exp_amount;
1584: end if;
1585:
1586: if (p_log_level_rec.statement_level) then
1587: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(3)', l_exp_amount);
1588: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(3)', l_rsv_amount);
1589: end if;
1590:
1591: l_rsv_adj.adjustment_amount := l_rsv_amount;
1584: end if;
1585:
1586: if (p_log_level_rec.statement_level) then
1587: fa_debug_pkg.add(l_calling_fn, 'l_exp_amount(3)', l_exp_amount);
1588: fa_debug_pkg.add(l_calling_fn, 'l_rsv_amount(3)', l_rsv_amount);
1589: end if;
1590:
1591: l_rsv_adj.adjustment_amount := l_rsv_amount;
1592: l_exp_adj.adjustment_amount := l_exp_amount; -- l_deprn_exp; (need to use one with same sign as tot_rsv)
1617: (px_group_reclass_options_rec.group_reclass_type <> 'CALC' OR
1618: px_trans_rec.calling_interface = 'FAPGADJ')) then
1619:
1620: if (p_log_level_rec.statement_level) then
1621: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj','for rsv', p_log_level_rec => p_log_level_rec);
1622: end if;
1623:
1624: if not FA_INS_ADJUST_PKG.faxinaj
1625: (l_rsv_adj,
1634: (px_group_reclass_options_rec.group_reclass_type <> 'CALC' OR
1635: px_trans_rec.calling_interface = 'FAPGADJ')) then
1636:
1637: if (p_log_level_rec.statement_level) then
1638: fa_debug_pkg.add(l_calling_fn, 'calling faxinaj','for exp', p_log_level_rec => p_log_level_rec);
1639: end if;
1640:
1641: if not FA_INS_ADJUST_PKG.faxinaj
1642: (l_exp_adj,
1694: end if;
1695: end if;
1696:
1697: if (p_log_level_rec.statement_level) then
1698: fa_debug_pkg.add(l_calling_fn, 'just before last call to faxama-p_src_dest',p_src_dest, p_log_level_rec => p_log_level_rec);
1699: fa_debug_pkg.add(l_calling_fn, 'existing reserve before last call to faxama',l_asset_deprn_rec_new.deprn_reserve , p_log_level_rec => p_log_level_rec);
1700: fa_debug_pkg.add(l_calling_fn, 'new expense before last call to faxama',l_exp_amount , p_log_level_rec => p_log_level_rec);
1701: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec => p_log_level_rec);
1702: fa_debug_pkg.add(l_calling_fn, 'new total reserve before last call to faxama',l_total_rsv_amount, p_log_level_rec => p_log_level_rec);
1695: end if;
1696:
1697: if (p_log_level_rec.statement_level) then
1698: fa_debug_pkg.add(l_calling_fn, 'just before last call to faxama-p_src_dest',p_src_dest, p_log_level_rec => p_log_level_rec);
1699: fa_debug_pkg.add(l_calling_fn, 'existing reserve before last call to faxama',l_asset_deprn_rec_new.deprn_reserve , p_log_level_rec => p_log_level_rec);
1700: fa_debug_pkg.add(l_calling_fn, 'new expense before last call to faxama',l_exp_amount , p_log_level_rec => p_log_level_rec);
1701: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec => p_log_level_rec);
1702: fa_debug_pkg.add(l_calling_fn, 'new total reserve before last call to faxama',l_total_rsv_amount, p_log_level_rec => p_log_level_rec);
1703: fa_debug_pkg.add(l_calling_fn, 'total reserve before last call to faxama',l_asset_deprn_rec_new.deprn_reserve , p_log_level_rec => p_log_level_rec);
1696:
1697: if (p_log_level_rec.statement_level) then
1698: fa_debug_pkg.add(l_calling_fn, 'just before last call to faxama-p_src_dest',p_src_dest, p_log_level_rec => p_log_level_rec);
1699: fa_debug_pkg.add(l_calling_fn, 'existing reserve before last call to faxama',l_asset_deprn_rec_new.deprn_reserve , p_log_level_rec => p_log_level_rec);
1700: fa_debug_pkg.add(l_calling_fn, 'new expense before last call to faxama',l_exp_amount , p_log_level_rec => p_log_level_rec);
1701: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec => p_log_level_rec);
1702: fa_debug_pkg.add(l_calling_fn, 'new total reserve before last call to faxama',l_total_rsv_amount, p_log_level_rec => p_log_level_rec);
1703: fa_debug_pkg.add(l_calling_fn, 'total reserve before last call to faxama',l_asset_deprn_rec_new.deprn_reserve , p_log_level_rec => p_log_level_rec);
1704: fa_debug_pkg.add(l_calling_fn, 'old eofy reserve before last call to faxama',p_asset_fin_rec_new.eofy_reserve , p_log_level_rec => p_log_level_rec);
1697: if (p_log_level_rec.statement_level) then
1698: fa_debug_pkg.add(l_calling_fn, 'just before last call to faxama-p_src_dest',p_src_dest, p_log_level_rec => p_log_level_rec);
1699: fa_debug_pkg.add(l_calling_fn, 'existing reserve before last call to faxama',l_asset_deprn_rec_new.deprn_reserve , p_log_level_rec => p_log_level_rec);
1700: fa_debug_pkg.add(l_calling_fn, 'new expense before last call to faxama',l_exp_amount , p_log_level_rec => p_log_level_rec);
1701: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec => p_log_level_rec);
1702: fa_debug_pkg.add(l_calling_fn, 'new total reserve before last call to faxama',l_total_rsv_amount, p_log_level_rec => p_log_level_rec);
1703: fa_debug_pkg.add(l_calling_fn, 'total reserve before last call to faxama',l_asset_deprn_rec_new.deprn_reserve , p_log_level_rec => p_log_level_rec);
1704: fa_debug_pkg.add(l_calling_fn, 'old eofy reserve before last call to faxama',p_asset_fin_rec_new.eofy_reserve , p_log_level_rec => p_log_level_rec);
1705: fa_debug_pkg.add(l_calling_fn, 'new eofy reserve before last call to faxama',l_asset_fin_rec_new.eofy_reserve , p_log_level_rec => p_log_level_rec);
1698: fa_debug_pkg.add(l_calling_fn, 'just before last call to faxama-p_src_dest',p_src_dest, p_log_level_rec => p_log_level_rec);
1699: fa_debug_pkg.add(l_calling_fn, 'existing reserve before last call to faxama',l_asset_deprn_rec_new.deprn_reserve , p_log_level_rec => p_log_level_rec);
1700: fa_debug_pkg.add(l_calling_fn, 'new expense before last call to faxama',l_exp_amount , p_log_level_rec => p_log_level_rec);
1701: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec => p_log_level_rec);
1702: fa_debug_pkg.add(l_calling_fn, 'new total reserve before last call to faxama',l_total_rsv_amount, p_log_level_rec => p_log_level_rec);
1703: fa_debug_pkg.add(l_calling_fn, 'total reserve before last call to faxama',l_asset_deprn_rec_new.deprn_reserve , p_log_level_rec => p_log_level_rec);
1704: fa_debug_pkg.add(l_calling_fn, 'old eofy reserve before last call to faxama',p_asset_fin_rec_new.eofy_reserve , p_log_level_rec => p_log_level_rec);
1705: fa_debug_pkg.add(l_calling_fn, 'new eofy reserve before last call to faxama',l_asset_fin_rec_new.eofy_reserve , p_log_level_rec => p_log_level_rec);
1706: fa_debug_pkg.add(l_calling_fn, 'adj eofy reserve before last call to faxama',l_asset_fin_rec_adj.eofy_reserve , p_log_level_rec => p_log_level_rec);
1699: fa_debug_pkg.add(l_calling_fn, 'existing reserve before last call to faxama',l_asset_deprn_rec_new.deprn_reserve , p_log_level_rec => p_log_level_rec);
1700: fa_debug_pkg.add(l_calling_fn, 'new expense before last call to faxama',l_exp_amount , p_log_level_rec => p_log_level_rec);
1701: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec => p_log_level_rec);
1702: fa_debug_pkg.add(l_calling_fn, 'new total reserve before last call to faxama',l_total_rsv_amount, p_log_level_rec => p_log_level_rec);
1703: fa_debug_pkg.add(l_calling_fn, 'total reserve before last call to faxama',l_asset_deprn_rec_new.deprn_reserve , p_log_level_rec => p_log_level_rec);
1704: fa_debug_pkg.add(l_calling_fn, 'old eofy reserve before last call to faxama',p_asset_fin_rec_new.eofy_reserve , p_log_level_rec => p_log_level_rec);
1705: fa_debug_pkg.add(l_calling_fn, 'new eofy reserve before last call to faxama',l_asset_fin_rec_new.eofy_reserve , p_log_level_rec => p_log_level_rec);
1706: fa_debug_pkg.add(l_calling_fn, 'adj eofy reserve before last call to faxama',l_asset_fin_rec_adj.eofy_reserve , p_log_level_rec => p_log_level_rec);
1707: fa_debug_pkg.add(l_calling_fn, 'amort start date',px_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
1700: fa_debug_pkg.add(l_calling_fn, 'new expense before last call to faxama',l_exp_amount , p_log_level_rec => p_log_level_rec);
1701: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec => p_log_level_rec);
1702: fa_debug_pkg.add(l_calling_fn, 'new total reserve before last call to faxama',l_total_rsv_amount, p_log_level_rec => p_log_level_rec);
1703: fa_debug_pkg.add(l_calling_fn, 'total reserve before last call to faxama',l_asset_deprn_rec_new.deprn_reserve , p_log_level_rec => p_log_level_rec);
1704: fa_debug_pkg.add(l_calling_fn, 'old eofy reserve before last call to faxama',p_asset_fin_rec_new.eofy_reserve , p_log_level_rec => p_log_level_rec);
1705: fa_debug_pkg.add(l_calling_fn, 'new eofy reserve before last call to faxama',l_asset_fin_rec_new.eofy_reserve , p_log_level_rec => p_log_level_rec);
1706: fa_debug_pkg.add(l_calling_fn, 'adj eofy reserve before last call to faxama',l_asset_fin_rec_adj.eofy_reserve , p_log_level_rec => p_log_level_rec);
1707: fa_debug_pkg.add(l_calling_fn, 'amort start date',px_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
1708: end if;
1701: fa_debug_pkg.add(l_calling_fn, 'new reserve before last call to faxama',l_rsv_amount, p_log_level_rec => p_log_level_rec);
1702: fa_debug_pkg.add(l_calling_fn, 'new total reserve before last call to faxama',l_total_rsv_amount, p_log_level_rec => p_log_level_rec);
1703: fa_debug_pkg.add(l_calling_fn, 'total reserve before last call to faxama',l_asset_deprn_rec_new.deprn_reserve , p_log_level_rec => p_log_level_rec);
1704: fa_debug_pkg.add(l_calling_fn, 'old eofy reserve before last call to faxama',p_asset_fin_rec_new.eofy_reserve , p_log_level_rec => p_log_level_rec);
1705: fa_debug_pkg.add(l_calling_fn, 'new eofy reserve before last call to faxama',l_asset_fin_rec_new.eofy_reserve , p_log_level_rec => p_log_level_rec);
1706: fa_debug_pkg.add(l_calling_fn, 'adj eofy reserve before last call to faxama',l_asset_fin_rec_adj.eofy_reserve , p_log_level_rec => p_log_level_rec);
1707: fa_debug_pkg.add(l_calling_fn, 'amort start date',px_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
1708: end if;
1709:
1702: fa_debug_pkg.add(l_calling_fn, 'new total reserve before last call to faxama',l_total_rsv_amount, p_log_level_rec => p_log_level_rec);
1703: fa_debug_pkg.add(l_calling_fn, 'total reserve before last call to faxama',l_asset_deprn_rec_new.deprn_reserve , p_log_level_rec => p_log_level_rec);
1704: fa_debug_pkg.add(l_calling_fn, 'old eofy reserve before last call to faxama',p_asset_fin_rec_new.eofy_reserve , p_log_level_rec => p_log_level_rec);
1705: fa_debug_pkg.add(l_calling_fn, 'new eofy reserve before last call to faxama',l_asset_fin_rec_new.eofy_reserve , p_log_level_rec => p_log_level_rec);
1706: fa_debug_pkg.add(l_calling_fn, 'adj eofy reserve before last call to faxama',l_asset_fin_rec_adj.eofy_reserve , p_log_level_rec => p_log_level_rec);
1707: fa_debug_pkg.add(l_calling_fn, 'amort start date',px_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
1708: end if;
1709:
1710: -- +++ This won't be necessary
1703: fa_debug_pkg.add(l_calling_fn, 'total reserve before last call to faxama',l_asset_deprn_rec_new.deprn_reserve , p_log_level_rec => p_log_level_rec);
1704: fa_debug_pkg.add(l_calling_fn, 'old eofy reserve before last call to faxama',p_asset_fin_rec_new.eofy_reserve , p_log_level_rec => p_log_level_rec);
1705: fa_debug_pkg.add(l_calling_fn, 'new eofy reserve before last call to faxama',l_asset_fin_rec_new.eofy_reserve , p_log_level_rec => p_log_level_rec);
1706: fa_debug_pkg.add(l_calling_fn, 'adj eofy reserve before last call to faxama',l_asset_fin_rec_adj.eofy_reserve , p_log_level_rec => p_log_level_rec);
1707: fa_debug_pkg.add(l_calling_fn, 'amort start date',px_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
1708: end if;
1709:
1710: -- +++ This won't be necessary
1711: l_trans_rec := px_trans_rec;
1729: p_asset_type_rec.asset_type = 'CAPITALIZED')) then
1730:
1731:
1732: if (p_log_level_rec.statement_level) then
1733: fa_debug_pkg.add(l_calling_fn,
1734: 'LAST CALL TO FAXAMA',
1735: 'CALLING FAXAMA', p_log_level_rec => p_log_level_rec);
1736: end if;
1737:
1742: if (px_group_reclass_options_rec.group_reclass_type = 'MANUAL' or
1743: px_trans_rec.amortization_start_date >= p_period_rec.calendar_period_open_date) then
1744:
1745: if (p_log_level_rec.statement_level) then
1746: fa_debug_pkg.add(l_calling_fn, 'calling','calc_raf_adj_cost', p_log_level_rec => p_log_level_rec);
1747: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.rsv', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec => p_log_level_rec);
1748: 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 => p_log_level_rec);
1749: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.rsv', l_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec => p_log_level_rec);
1750: 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 => p_log_level_rec);
1743: px_trans_rec.amortization_start_date >= p_period_rec.calendar_period_open_date) then
1744:
1745: if (p_log_level_rec.statement_level) then
1746: fa_debug_pkg.add(l_calling_fn, 'calling','calc_raf_adj_cost', p_log_level_rec => p_log_level_rec);
1747: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.rsv', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec => p_log_level_rec);
1748: 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 => p_log_level_rec);
1749: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.rsv', l_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec => p_log_level_rec);
1750: 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 => p_log_level_rec);
1751: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.rsv', l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec => p_log_level_rec);
1744:
1745: if (p_log_level_rec.statement_level) then
1746: fa_debug_pkg.add(l_calling_fn, 'calling','calc_raf_adj_cost', p_log_level_rec => p_log_level_rec);
1747: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.rsv', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec => p_log_level_rec);
1748: 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 => p_log_level_rec);
1749: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.rsv', l_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec => p_log_level_rec);
1750: 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 => p_log_level_rec);
1751: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.rsv', l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec => p_log_level_rec);
1752: 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 => p_log_level_rec);
1745: if (p_log_level_rec.statement_level) then
1746: fa_debug_pkg.add(l_calling_fn, 'calling','calc_raf_adj_cost', p_log_level_rec => p_log_level_rec);
1747: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.rsv', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec => p_log_level_rec);
1748: 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 => p_log_level_rec);
1749: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.rsv', l_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec => p_log_level_rec);
1750: 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 => p_log_level_rec);
1751: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.rsv', l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec => p_log_level_rec);
1752: 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 => p_log_level_rec);
1753: end if;
1746: fa_debug_pkg.add(l_calling_fn, 'calling','calc_raf_adj_cost', p_log_level_rec => p_log_level_rec);
1747: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.rsv', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec => p_log_level_rec);
1748: 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 => p_log_level_rec);
1749: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.rsv', l_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec => p_log_level_rec);
1750: 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 => p_log_level_rec);
1751: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.rsv', l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec => p_log_level_rec);
1752: 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 => p_log_level_rec);
1753: end if;
1754:
1747: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec_old.rsv', p_asset_deprn_rec_old.deprn_reserve, p_log_level_rec => p_log_level_rec);
1748: 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 => p_log_level_rec);
1749: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.rsv', l_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec => p_log_level_rec);
1750: 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 => p_log_level_rec);
1751: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.rsv', l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec => p_log_level_rec);
1752: 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 => p_log_level_rec);
1753: end if;
1754:
1755: if not FA_AMORT_PVT.calc_raf_adj_cost
1748: 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 => p_log_level_rec);
1749: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_adj.rsv', l_asset_deprn_rec_adj.deprn_reserve, p_log_level_rec => p_log_level_rec);
1750: 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 => p_log_level_rec);
1751: fa_debug_pkg.add(l_calling_fn, 'l_asset_deprn_rec_new.rsv', l_asset_deprn_rec_new.deprn_reserve, p_log_level_rec => p_log_level_rec);
1752: 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 => p_log_level_rec);
1753: end if;
1754:
1755: if not FA_AMORT_PVT.calc_raf_adj_cost
1756: (p_trans_rec => px_trans_rec,
1796: end if;
1797: end if;
1798:
1799: if (p_log_level_rec.statement_level) then
1800: 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 => p_log_level_rec);
1801: 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 => p_log_level_rec);
1802: end if;
1803:
1804: -- if reclassing out of the group to standalone, then
1797: end if;
1798:
1799: if (p_log_level_rec.statement_level) then
1800: 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 => p_log_level_rec);
1801: 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 => p_log_level_rec);
1802: end if;
1803:
1804: -- if reclassing out of the group to standalone, then
1805: -- insure the amount doesn't exceed the recoverable_cost
2010:
2011: BEGIN
2012:
2013: if (p_log_level_rec.statement_level) then
2014: fa_debug_pkg.add(l_calling_fn, 'populate member amt',p_trans_rec.amortization_start_date , p_log_level_rec => p_log_level_rec);
2015: end if;
2016:
2017: l_asset_fin_rec_new := p_asset_fin_rec_new;
2018: h_book_type_code := p_asset_hdr_rec.book_type_code;
2082: -- calculate current eofy_reserve using amounts above
2083: h_eofy_reserve := p_mem_asset_fin_rec_new.eofy_reserve;
2084:
2085: if (p_log_level_rec.statement_level) then
2086: fa_debug_pkg.add(l_calling_fn,'h_eofy_reserve',h_eofy_reserve, p_log_level_rec => p_log_level_rec);
2087: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec => p_log_level_rec);
2088: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec => p_log_level_rec);
2089: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec => p_log_level_rec);
2090: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec => p_log_level_rec);
2083: h_eofy_reserve := p_mem_asset_fin_rec_new.eofy_reserve;
2084:
2085: if (p_log_level_rec.statement_level) then
2086: fa_debug_pkg.add(l_calling_fn,'h_eofy_reserve',h_eofy_reserve, p_log_level_rec => p_log_level_rec);
2087: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec => p_log_level_rec);
2088: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec => p_log_level_rec);
2089: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec => p_log_level_rec);
2090: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec => p_log_level_rec);
2091: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec => p_log_level_rec);
2084:
2085: if (p_log_level_rec.statement_level) then
2086: fa_debug_pkg.add(l_calling_fn,'h_eofy_reserve',h_eofy_reserve, p_log_level_rec => p_log_level_rec);
2087: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec => p_log_level_rec);
2088: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec => p_log_level_rec);
2089: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec => p_log_level_rec);
2090: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec => p_log_level_rec);
2091: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec => p_log_level_rec);
2092: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec => p_log_level_rec);
2085: if (p_log_level_rec.statement_level) then
2086: fa_debug_pkg.add(l_calling_fn,'h_eofy_reserve',h_eofy_reserve, p_log_level_rec => p_log_level_rec);
2087: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec => p_log_level_rec);
2088: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec => p_log_level_rec);
2089: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec => p_log_level_rec);
2090: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec => p_log_level_rec);
2091: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec => p_log_level_rec);
2092: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec => p_log_level_rec);
2093: end if;
2086: fa_debug_pkg.add(l_calling_fn,'h_eofy_reserve',h_eofy_reserve, p_log_level_rec => p_log_level_rec);
2087: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec => p_log_level_rec);
2088: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec => p_log_level_rec);
2089: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec => p_log_level_rec);
2090: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec => p_log_level_rec);
2091: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec => p_log_level_rec);
2092: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec => p_log_level_rec);
2093: end if;
2094:
2087: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec => p_log_level_rec);
2088: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec => p_log_level_rec);
2089: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec => p_log_level_rec);
2090: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec => p_log_level_rec);
2091: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec => p_log_level_rec);
2092: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec => p_log_level_rec);
2093: end if;
2094:
2095: if nvl(h_eofy_reserve,0) = 0 then
2088: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec => p_log_level_rec);
2089: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec => p_log_level_rec);
2090: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec => p_log_level_rec);
2091: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec => p_log_level_rec);
2092: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec => p_log_level_rec);
2093: end if;
2094:
2095: if nvl(h_eofy_reserve,0) = 0 then
2096: if h_cur_fiscal_year = h_ds_fiscal_year then
2108: px_group_reclass_options_rec.reserve_amount := h_reserve_dpis_current;
2109: end if;
2110:
2111: if (p_log_level_rec.statement_level) then
2112: fa_debug_pkg.add(l_calling_fn,'reserve_amount',px_group_reclass_options_rec.reserve_amount, p_log_level_rec => p_log_level_rec);
2113: end if;
2114:
2115: -- Get Period Counter of amortization start date
2116: if (p_trans_rec.amortization_start_date <> p_mem_asset_fin_rec_new.date_placed_in_service) then
2169:
2170: end if;
2171:
2172: if (p_log_level_rec.statement_level) then
2173: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec => p_log_level_rec);
2174: fa_debug_pkg.add(l_calling_fn,'h_amort_fiscal_year',h_amort_fiscal_year, p_log_level_rec => p_log_level_rec);
2175: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec => p_log_level_rec);
2176: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec => p_log_level_rec);
2177: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec => p_log_level_rec);
2170: end if;
2171:
2172: if (p_log_level_rec.statement_level) then
2173: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec => p_log_level_rec);
2174: fa_debug_pkg.add(l_calling_fn,'h_amort_fiscal_year',h_amort_fiscal_year, p_log_level_rec => p_log_level_rec);
2175: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec => p_log_level_rec);
2176: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec => p_log_level_rec);
2177: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec => p_log_level_rec);
2178: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec => p_log_level_rec);
2171:
2172: if (p_log_level_rec.statement_level) then
2173: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec => p_log_level_rec);
2174: fa_debug_pkg.add(l_calling_fn,'h_amort_fiscal_year',h_amort_fiscal_year, p_log_level_rec => p_log_level_rec);
2175: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec => p_log_level_rec);
2176: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec => p_log_level_rec);
2177: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec => p_log_level_rec);
2178: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec => p_log_level_rec);
2179: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec => p_log_level_rec);
2172: if (p_log_level_rec.statement_level) then
2173: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec => p_log_level_rec);
2174: fa_debug_pkg.add(l_calling_fn,'h_amort_fiscal_year',h_amort_fiscal_year, p_log_level_rec => p_log_level_rec);
2175: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec => p_log_level_rec);
2176: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec => p_log_level_rec);
2177: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec => p_log_level_rec);
2178: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec => p_log_level_rec);
2179: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec => p_log_level_rec);
2180: end if;
2173: fa_debug_pkg.add(l_calling_fn,'h_cur_fiscal_yesr',h_cur_fiscal_year, p_log_level_rec => p_log_level_rec);
2174: fa_debug_pkg.add(l_calling_fn,'h_amort_fiscal_year',h_amort_fiscal_year, p_log_level_rec => p_log_level_rec);
2175: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec => p_log_level_rec);
2176: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec => p_log_level_rec);
2177: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec => p_log_level_rec);
2178: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec => p_log_level_rec);
2179: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec => p_log_level_rec);
2180: end if;
2181:
2174: fa_debug_pkg.add(l_calling_fn,'h_amort_fiscal_year',h_amort_fiscal_year, p_log_level_rec => p_log_level_rec);
2175: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec => p_log_level_rec);
2176: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec => p_log_level_rec);
2177: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec => p_log_level_rec);
2178: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec => p_log_level_rec);
2179: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec => p_log_level_rec);
2180: end if;
2181:
2182: -- calculate current eofy_reserve using amounts above
2175: fa_debug_pkg.add(l_calling_fn,'h_ds_fiscal_year',h_ds_fiscal_year, p_log_level_rec => p_log_level_rec);
2176: fa_debug_pkg.add(l_calling_fn,'h_reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec => p_log_level_rec);
2177: fa_debug_pkg.add(l_calling_fn,'h_ytd_deprn',h_ytd_deprn, p_log_level_rec => p_log_level_rec);
2178: fa_debug_pkg.add(l_calling_fn,'h_adj_eofy_reserve',h_adj_eofy_reserve, p_log_level_rec => p_log_level_rec);
2179: fa_debug_pkg.add(l_calling_fn,'h_adj_reserve',h_adj_reserve, p_log_level_rec => p_log_level_rec);
2180: end if;
2181:
2182: -- calculate current eofy_reserve using amounts above
2183: if h_cur_fiscal_year <> h_amort_fiscal_year then
2200:
2201: px_group_reclass_options_rec.source_eofy_reserve := h_eofy_reserve;
2202:
2203: if (p_log_level_rec.statement_level) then
2204: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec => p_log_level_rec);
2205: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec => p_log_level_rec);
2206: fa_debug_pkg.add(l_calling_fn,'source_exp_amount',px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
2207: fa_debug_pkg.add(l_calling_fn,'eofy_reserve',px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec => p_log_level_rec);
2208: end if;
2201: px_group_reclass_options_rec.source_eofy_reserve := h_eofy_reserve;
2202:
2203: if (p_log_level_rec.statement_level) then
2204: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec => p_log_level_rec);
2205: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec => p_log_level_rec);
2206: fa_debug_pkg.add(l_calling_fn,'source_exp_amount',px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
2207: fa_debug_pkg.add(l_calling_fn,'eofy_reserve',px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec => p_log_level_rec);
2208: end if;
2209:
2202:
2203: if (p_log_level_rec.statement_level) then
2204: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec => p_log_level_rec);
2205: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec => p_log_level_rec);
2206: fa_debug_pkg.add(l_calling_fn,'source_exp_amount',px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
2207: fa_debug_pkg.add(l_calling_fn,'eofy_reserve',px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec => p_log_level_rec);
2208: end if;
2209:
2210: -- x_eofy_reserve := h_eofy_reserve;
2203: if (p_log_level_rec.statement_level) then
2204: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_current',h_reserve_dpis_current, p_log_level_rec => p_log_level_rec);
2205: fa_debug_pkg.add(l_calling_fn,'reserve_dpis_amort',h_reserve_dpis_amort, p_log_level_rec => p_log_level_rec);
2206: fa_debug_pkg.add(l_calling_fn,'source_exp_amount',px_group_reclass_options_rec.source_exp_amount, p_log_level_rec => p_log_level_rec);
2207: fa_debug_pkg.add(l_calling_fn,'eofy_reserve',px_group_reclass_options_rec.source_eofy_reserve, p_log_level_rec => p_log_level_rec);
2208: end if;
2209:
2210: -- x_eofy_reserve := h_eofy_reserve;
2211: