APPS.FA_RETIREMENT_PVT dependencies on FA_DEBUG_PKG

Line 131: fa_debug_pkg.add(l_calling_fn, 'Begin',

127: ret_err EXCEPTION;
128:
129: BEGIN
130: if (p_log_level_rec.statement_level) then
131: fa_debug_pkg.add(l_calling_fn, 'Begin',
132: p_asset_hdr_rec.asset_id||':'||p_asset_fin_rec.group_asset_id
133: ,p_log_level_rec => p_log_level_rec);
134: end if;
135:

Line 281: fa_debug_pkg.add(l_calling_fn, 'ERROR',

277: p_mrc_sob_type_code => p_mrc_sob_type_code,
278: p_mode => l_cglfr_mode,
279: p_log_level_rec => p_log_level_rec) then
280: if (p_log_level_rec.statement_level) then
281: fa_debug_pkg.add(l_calling_fn, 'ERROR',
282: 'returned from CALC_GAIN_LOSS_FOR_RET',p_log_level_rec);
283: end if;
284:
285: raise ret_err;

Line 323: fa_debug_pkg.add(l_calling_fn, 'Recapture Excess Reserve',

319: if (l_new_rec_cost < l_new_reserve) then
320: l_adj.adjustment_amount := l_new_reserve - l_new_rec_cost;
321:
322: if (p_log_level_rec.statement_level) then
323: fa_debug_pkg.add(l_calling_fn, 'Recapture Excess Reserve',
324: l_adj.adjustment_amount,p_log_level_rec);
325: end if;
326:
327: if p_asset_type_rec.asset_type = 'CIP' then

Line 406: fa_debug_pkg.add(l_calling_fn, 'Calling FA_TRX_APPROVAL_PKG.faxcat', 'Failed',p_log_level_rec);

402: X_init_message_flag => 'NO',
403: p_log_level_rec => p_log_level_rec) then
404:
405: if (p_log_level_rec.statement_level) then
406: fa_debug_pkg.add(l_calling_fn, 'Calling FA_TRX_APPROVAL_PKG.faxcat', 'Failed',p_log_level_rec);
407: end if;
408:
409: raise ret_err;
410: end if;

Line 425: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt',p_log_level_rec);

421: if (not fa_cache_pkg.fazccmt(l_asset_fin_rec_old.deprn_method_code,
422: l_asset_fin_rec_old.life_in_months,
423: p_log_level_rec)) then
424: if (p_log_level_rec.statement_level) then
425: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt',p_log_level_rec);
426: end if;
427:
428: raise ret_err;
429: end if;

Line 443: fa_debug_pkg.add(l_calling_fn, 'Call FA_ADJUSTMENT_PVT.do_adjustment1',

439: end if;
440: -- ENERGY
441:
442: if (p_log_level_rec.statement_level) then
443: fa_debug_pkg.add(l_calling_fn, 'Call FA_ADJUSTMENT_PVT.do_adjustment1',
444: 'Begin',p_log_level_rec);
445: end if;
446:
447: if not FA_ADJUSTMENT_PVT.do_adjustment

Line 467: fa_debug_pkg.add(l_calling_fn, 'Calling FA_ADJUSTMENT_PVT.do_adjustment', 'Failed',p_log_level_rec);

463: p_calling_fn => l_calling_fn,
464: p_log_level_rec => p_log_level_rec) then
465:
466: if (p_log_level_rec.statement_level) then
467: fa_debug_pkg.add(l_calling_fn, 'Calling FA_ADJUSTMENT_PVT.do_adjustment', 'Failed',p_log_level_rec);
468: end if;
469:
470: raise ret_err;
471: end if;

Line 474: fa_debug_pkg.add(l_calling_fn, 'FA_ADJUSTMENT_PVT.do_adjustment', 'End',p_log_level_rec);

470: raise ret_err;
471: end if;
472:
473: if (p_log_level_rec.statement_level) then
474: fa_debug_pkg.add(l_calling_fn, 'FA_ADJUSTMENT_PVT.do_adjustment', 'End',p_log_level_rec);
475: end if;
476:
477: if (p_trans_rec.calling_interface <> 'FAXASSET') and
478: (nvl(l_asset_fin_rec_new.cost, 0) <> 0) and

Line 493: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', l_alloc_amount,p_log_level_rec);

489: (nvl(p_asset_retire_rec.proceeds_of_sale, 0) -
490: nvl(p_asset_retire_rec.cost_of_removal, 0)));
491:
492: if (p_log_level_rec.statement_level) then
493: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', l_alloc_amount,p_log_level_rec);
494: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.proceeds_of_sale,p_log_level_rec);
495: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.cost_of_removal,p_log_level_rec);
496: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.reserve_retired,p_log_level_rec);
497: end if;

Line 494: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.proceeds_of_sale,p_log_level_rec);

490: nvl(p_asset_retire_rec.cost_of_removal, 0)));
491:
492: if (p_log_level_rec.statement_level) then
493: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', l_alloc_amount,p_log_level_rec);
494: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.proceeds_of_sale,p_log_level_rec);
495: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.cost_of_removal,p_log_level_rec);
496: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.reserve_retired,p_log_level_rec);
497: end if;
498:

Line 495: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.cost_of_removal,p_log_level_rec);

491:
492: if (p_log_level_rec.statement_level) then
493: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', l_alloc_amount,p_log_level_rec);
494: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.proceeds_of_sale,p_log_level_rec);
495: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.cost_of_removal,p_log_level_rec);
496: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.reserve_retired,p_log_level_rec);
497: end if;
498:
499: if not FA_RETIREMENT_PVT.Do_Allocation(

Line 496: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.reserve_retired,p_log_level_rec);

492: if (p_log_level_rec.statement_level) then
493: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', l_alloc_amount,p_log_level_rec);
494: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.proceeds_of_sale,p_log_level_rec);
495: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.cost_of_removal,p_log_level_rec);
496: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', p_asset_retire_rec.reserve_retired,p_log_level_rec);
497: end if;
498:
499: if not FA_RETIREMENT_PVT.Do_Allocation(
500: p_trans_rec => l_trans_rec,

Line 510: fa_debug_pkg.add(l_calling_fn, 'Calling FA_ADJUSTMENT_PVT.do_adjustment', 'Failed',p_log_level_rec);

506: p_mrc_sob_type_code => p_mrc_sob_type_code,
507: p_calling_fn => l_calling_fn,
508: p_log_level_rec => p_log_level_rec) then
509: if (p_log_level_rec.statement_level) then
510: fa_debug_pkg.add(l_calling_fn, 'Calling FA_ADJUSTMENT_PVT.do_adjustment', 'Failed',p_log_level_rec);
511: end if;
512:
513: raise ret_err;
514: end if;

Line 524: fa_debug_pkg.add(l_calling_fn, 'Call FA_RETIREMENTS_PKG.Update_Row', 'Begin',p_log_level_rec);

520: -- Distribution API called after FA_RETIREMENT_PUB.do_sub_regular_retirement
521: -- is expecting the status to be PENDING.
522: --
523: if (p_log_level_rec.statement_level) then
524: fa_debug_pkg.add(l_calling_fn, 'Call FA_RETIREMENTS_PKG.Update_Row', 'Begin',p_log_level_rec);
525: end if;
526:
527: FA_RETIREMENTS_PKG.Update_Row(
528: X_Rowid => l_rowid,

Line 537: fa_debug_pkg.add(l_calling_fn, 'Call FA_RETIREMENTS_PKG.Update_Row', 'End',p_log_level_rec);

533: X_Calling_Fn => l_calling_fn,
534: p_log_level_rec => p_log_level_rec);
535:
536: if (p_log_level_rec.statement_level) then
537: fa_debug_pkg.add(l_calling_fn, 'Call FA_RETIREMENTS_PKG.Update_Row', 'End',p_log_level_rec);
538: end if;
539:
540: -- SLA: update the event status in SLA as well to unprocessed
541: -- as original api inserted as incomplete

Line 546: fa_debug_pkg.add

542:
543: if (p_mrc_sob_type_code <> 'R') then
544:
545: if p_log_level_rec.statement_level then
546: fa_debug_pkg.add
547: (fname => l_calling_fn,
548: element => 'calling fa_xla_events_pvt.update_transaction_event with thid: ',
549: value => p_trans_rec.transaction_header_id);
550: end if;

Line 581: fa_debug_pkg.add(l_calling_fn, 'Is there a member asset',

577: FETCH c_member_exists INTO l_member_exists;
578: CLOSE c_member_exists;
579:
580: if (p_log_level_rec.statement_level) then
581: fa_debug_pkg.add(l_calling_fn, 'Is there a member asset',
582: l_member_exists,p_log_level_rec);
583: end if;
584:
585: if (nvl(l_member_exists, 'N') <> 'Y') then

Line 601: fa_debug_pkg.add(l_calling_fn, 'End', 'Success',p_log_level_rec);

597: end if; -- (nvl(l_asset_fin_rec_old.terminal_gain_loss, 'NO') = 'YES')
598:
599: end if; -- p_calling_fn <> 'DO_RETIREMENT.CGLFR_CR_ONLY'
600: if (p_log_level_rec.statement_level) then
601: fa_debug_pkg.add(l_calling_fn, 'End', 'Success',p_log_level_rec);
602: end if;
603:
604: return true;
605: EXCEPTION

Line 608: fa_debug_pkg.add(l_calling_fn, 'End', 'Failed',p_log_level_rec);

604: return true;
605: EXCEPTION
606: when ret_err then
607: if (p_log_level_rec.statement_level) then
608: fa_debug_pkg.add(l_calling_fn, 'End', 'Failed',p_log_level_rec);
609: end if;
610:
611: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
612: p_log_level_rec => p_log_level_rec);

Line 617: fa_debug_pkg.add(l_calling_fn, 'End', 'Failed'||':'||sqlerrm,p_log_level_rec);

613: return false;
614:
615: when OTHERS then
616: if (p_log_level_rec.statement_level) then
617: fa_debug_pkg.add(l_calling_fn, 'End', 'Failed'||':'||sqlerrm,p_log_level_rec);
618: end if;
619:
620: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn
621: ,p_log_level_rec => p_log_level_rec);

Line 714: fa_debug_pkg.add(l_calling_fn, 'End', 'Success',p_log_level_rec);

710:
711: end if; -- (p_mrc_sob_type_code = 'R')
712:
713: if (p_log_level_rec.statement_level) then
714: fa_debug_pkg.add(l_calling_fn, 'End', 'Success',p_log_level_rec);
715: end if;
716:
717: return true;
718:

Line 851: fa_debug_pkg.add(l_calling_fn, 'Begin', p_asset_hdr_rec.asset_id||':'||p_asset_fin_rec.group_asset_id,p_log_level_rec);

847:
848: rein_err EXCEPTION;
849: BEGIN
850: if (p_log_level_rec.statement_level) then
851: fa_debug_pkg.add(l_calling_fn, 'Begin', p_asset_hdr_rec.asset_id||':'||p_asset_fin_rec.group_asset_id,p_log_level_rec);
852: end if;
853:
854: -- +++++ populate current period_rec info +++++
855: if not FA_UTIL_PVT.get_period_rec

Line 861: fa_debug_pkg.add(l_calling_fn, 'Calling FA_UTIL_PVT.get_period_rec', 'Failed',p_log_level_rec);

857: x_period_rec => l_period_rec,
858: p_log_level_rec => p_log_level_rec) then
859:
860: if (p_log_level_rec.statement_level) then
861: fa_debug_pkg.add(l_calling_fn, 'Calling FA_UTIL_PVT.get_period_rec', 'Failed',p_log_level_rec);
862: end if;
863:
864: raise rein_err;
865: end if;

Line 875: fa_debug_pkg.add(l_calling_fn, 'Calling FA_UTIL_PVT.get_asset_desc_rec', 'Failed',p_log_level_rec);

871: px_asset_desc_rec => l_asset_desc_rec_m,
872: p_log_level_rec => p_log_level_rec) then
873:
874: if (p_log_level_rec.statement_level) then
875: fa_debug_pkg.add(l_calling_fn, 'Calling FA_UTIL_PVT.get_asset_desc_rec', 'Failed',p_log_level_rec);
876: end if;
877:
878: raise rein_err;
879: end if;

Line 903: fa_debug_pkg.add(l_calling_fn, 'Getting distribution info', 'Failed',p_log_level_rec);

899:
900: if (t_distribution_id.COUNT = 0) then
901:
902: if (p_log_level_rec.statement_level) then
903: fa_debug_pkg.add(l_calling_fn, 'Getting distribution info', 'Failed',p_log_level_rec);
904: end if;
905:
906: raise rein_err;
907: end if;

Line 1283: fa_debug_pkg.add(l_calling_fn, 'transaction_date_entered',

1279: raise rein_err;
1280: end if;
1281:
1282: if (p_log_level_rec.statement_level) then
1283: fa_debug_pkg.add(l_calling_fn, 'transaction_date_entered',
1284: p_trans_rec.transaction_date_entered,p_log_level_rec);
1285: fa_debug_pkg.add(l_calling_fn, 'amortization_start_date',
1286: p_trans_rec.amortization_start_date,p_log_level_rec);
1287: fa_debug_pkg.add(l_calling_fn, 'new.cost', l_asset_fin_rec_new.cost,p_log_level_rec);

Line 1285: fa_debug_pkg.add(l_calling_fn, 'amortization_start_date',

1281:
1282: if (p_log_level_rec.statement_level) then
1283: fa_debug_pkg.add(l_calling_fn, 'transaction_date_entered',
1284: p_trans_rec.transaction_date_entered,p_log_level_rec);
1285: fa_debug_pkg.add(l_calling_fn, 'amortization_start_date',
1286: p_trans_rec.amortization_start_date,p_log_level_rec);
1287: fa_debug_pkg.add(l_calling_fn, 'new.cost', l_asset_fin_rec_new.cost,p_log_level_rec);
1288: fa_debug_pkg.add(l_calling_fn, 'tracking_method',l_asset_fin_rec_old.tracking_method,p_log_level_rec);
1289: fa_debug_pkg.add(l_calling_fn, 'rule_name',fa_cache_pkg.fazcdrd_record.rule_name,p_log_level_rec);

Line 1287: fa_debug_pkg.add(l_calling_fn, 'new.cost', l_asset_fin_rec_new.cost,p_log_level_rec);

1283: fa_debug_pkg.add(l_calling_fn, 'transaction_date_entered',
1284: p_trans_rec.transaction_date_entered,p_log_level_rec);
1285: fa_debug_pkg.add(l_calling_fn, 'amortization_start_date',
1286: p_trans_rec.amortization_start_date,p_log_level_rec);
1287: fa_debug_pkg.add(l_calling_fn, 'new.cost', l_asset_fin_rec_new.cost,p_log_level_rec);
1288: fa_debug_pkg.add(l_calling_fn, 'tracking_method',l_asset_fin_rec_old.tracking_method,p_log_level_rec);
1289: fa_debug_pkg.add(l_calling_fn, 'rule_name',fa_cache_pkg.fazcdrd_record.rule_name,p_log_level_rec);
1290: end if;
1291:

Line 1288: fa_debug_pkg.add(l_calling_fn, 'tracking_method',l_asset_fin_rec_old.tracking_method,p_log_level_rec);

1284: p_trans_rec.transaction_date_entered,p_log_level_rec);
1285: fa_debug_pkg.add(l_calling_fn, 'amortization_start_date',
1286: p_trans_rec.amortization_start_date,p_log_level_rec);
1287: fa_debug_pkg.add(l_calling_fn, 'new.cost', l_asset_fin_rec_new.cost,p_log_level_rec);
1288: fa_debug_pkg.add(l_calling_fn, 'tracking_method',l_asset_fin_rec_old.tracking_method,p_log_level_rec);
1289: fa_debug_pkg.add(l_calling_fn, 'rule_name',fa_cache_pkg.fazcdrd_record.rule_name,p_log_level_rec);
1290: end if;
1291:
1292:

Line 1289: fa_debug_pkg.add(l_calling_fn, 'rule_name',fa_cache_pkg.fazcdrd_record.rule_name,p_log_level_rec);

1285: fa_debug_pkg.add(l_calling_fn, 'amortization_start_date',
1286: p_trans_rec.amortization_start_date,p_log_level_rec);
1287: fa_debug_pkg.add(l_calling_fn, 'new.cost', l_asset_fin_rec_new.cost,p_log_level_rec);
1288: fa_debug_pkg.add(l_calling_fn, 'tracking_method',l_asset_fin_rec_old.tracking_method,p_log_level_rec);
1289: fa_debug_pkg.add(l_calling_fn, 'rule_name',fa_cache_pkg.fazcdrd_record.rule_name,p_log_level_rec);
1290: end if;
1291:
1292:
1293: if (nvl(l_asset_fin_rec_old.tracking_method, 'NO TRACK') = 'ALLOCATE') and

Line 1303: fa_debug_pkg.add(l_calling_fn, 'Call FA_ADJUSTMENT_PVT.do_adjustment2',

1299: l_trans_rec.amortization_start_date := p_asset_retire_rec.date_retired;
1300: end if;
1301:
1302: if (p_log_level_rec.statement_level) then
1303: fa_debug_pkg.add(l_calling_fn, 'Call FA_ADJUSTMENT_PVT.do_adjustment2',
1304: 'Begin',p_log_level_rec);
1305:
1306: end if;
1307:

Line 1335: fa_debug_pkg.add(l_calling_fn, 'Process Member Rollup Group',

1331: --
1332: -- This is Sum up member depreciation to group asset
1333: --
1334: if (p_log_level_rec.statement_level) then
1335: fa_debug_pkg.add(l_calling_fn, 'Process Member Rollup Group',
1336: l_asset_hdr_rec.asset_id,p_log_level_rec);
1337: end if;
1338: -- +++++ Remove group expense rows +++++
1339: DELETE FROM FA_ADJUSTMENTS

Line 1359: fa_debug_pkg.add(l_calling_fn, 'End', 'Success',p_log_level_rec);

1355: p_log_level_rec => p_log_level_rec);
1356:
1357:
1358: if (p_log_level_rec.statement_level) then
1359: fa_debug_pkg.add(l_calling_fn, 'End', 'Success',p_log_level_rec);
1360: end if;
1361:
1362: if (p_trans_rec.calling_interface <> 'FAXASSET') then
1363:

Line 1367: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', ' ',p_log_level_rec);

1363:
1364: if (nvl(l_asset_fin_rec_old.tracking_method, 'NO TRACK') = 'ALLOCATE') and
1365: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') then
1366: if (p_log_level_rec.statement_level) then
1367: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', ' ',p_log_level_rec);
1368: fa_debug_pkg.add(l_calling_fn, 'proceeds_of_sale', p_asset_retire_rec.proceeds_of_sale,p_log_level_rec);
1369: fa_debug_pkg.add(l_calling_fn, 'cost_of_removal', p_asset_retire_rec.cost_of_removal,p_log_level_rec);
1370: fa_debug_pkg.add(l_calling_fn, 'reserve_retired', p_asset_retire_rec.reserve_retired,p_log_level_rec);
1371: end if;

Line 1368: fa_debug_pkg.add(l_calling_fn, 'proceeds_of_sale', p_asset_retire_rec.proceeds_of_sale,p_log_level_rec);

1364: if (nvl(l_asset_fin_rec_old.tracking_method, 'NO TRACK') = 'ALLOCATE') and
1365: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') then
1366: if (p_log_level_rec.statement_level) then
1367: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', ' ',p_log_level_rec);
1368: fa_debug_pkg.add(l_calling_fn, 'proceeds_of_sale', p_asset_retire_rec.proceeds_of_sale,p_log_level_rec);
1369: fa_debug_pkg.add(l_calling_fn, 'cost_of_removal', p_asset_retire_rec.cost_of_removal,p_log_level_rec);
1370: fa_debug_pkg.add(l_calling_fn, 'reserve_retired', p_asset_retire_rec.reserve_retired,p_log_level_rec);
1371: end if;
1372:

Line 1369: fa_debug_pkg.add(l_calling_fn, 'cost_of_removal', p_asset_retire_rec.cost_of_removal,p_log_level_rec);

1365: (fa_cache_pkg.fazcdrd_record.rule_name = 'ENERGY PERIOD END BALANCE') then
1366: if (p_log_level_rec.statement_level) then
1367: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', ' ',p_log_level_rec);
1368: fa_debug_pkg.add(l_calling_fn, 'proceeds_of_sale', p_asset_retire_rec.proceeds_of_sale,p_log_level_rec);
1369: fa_debug_pkg.add(l_calling_fn, 'cost_of_removal', p_asset_retire_rec.cost_of_removal,p_log_level_rec);
1370: fa_debug_pkg.add(l_calling_fn, 'reserve_retired', p_asset_retire_rec.reserve_retired,p_log_level_rec);
1371: end if;
1372:
1373: l_reserve_allocated := p_asset_retire_rec.cost_retired -

Line 1370: fa_debug_pkg.add(l_calling_fn, 'reserve_retired', p_asset_retire_rec.reserve_retired,p_log_level_rec);

1366: if (p_log_level_rec.statement_level) then
1367: fa_debug_pkg.add(l_calling_fn, 'Calling Do_Allocation', ' ',p_log_level_rec);
1368: fa_debug_pkg.add(l_calling_fn, 'proceeds_of_sale', p_asset_retire_rec.proceeds_of_sale,p_log_level_rec);
1369: fa_debug_pkg.add(l_calling_fn, 'cost_of_removal', p_asset_retire_rec.cost_of_removal,p_log_level_rec);
1370: fa_debug_pkg.add(l_calling_fn, 'reserve_retired', p_asset_retire_rec.reserve_retired,p_log_level_rec);
1371: end if;
1372:
1373: l_reserve_allocated := p_asset_retire_rec.cost_retired -
1374: nvl(p_asset_retire_rec.proceeds_of_sale, 0) +

Line 1390: fa_debug_pkg.add(l_calling_fn, 'Calling FA_ADJUSTMENT_PVT.Do_Allocation', 'Failed',p_log_level_rec);

1386: p_mrc_sob_type_code => p_mrc_sob_type_code,
1387: p_calling_fn => l_calling_fn,
1388: p_log_level_rec => p_log_level_rec) then
1389: if (p_log_level_rec.statement_level) then
1390: fa_debug_pkg.add(l_calling_fn, 'Calling FA_ADJUSTMENT_PVT.Do_Allocation', 'Failed',p_log_level_rec);
1391: end if;
1392:
1393: raise rein_err;
1394: end if;

Line 1401: fa_debug_pkg.add(l_calling_fn, 'distribution_id', r_dist.distribution_id,p_log_level_rec);

1397: end if; -- (p_trans_rec.calling_interface <> 'FAXASSET')
1398:
1399: if (p_log_level_rec.statement_level) then
1400: for r_dist in c_dist loop
1401: fa_debug_pkg.add(l_calling_fn, 'distribution_id', r_dist.distribution_id,p_log_level_rec);
1402: fa_debug_pkg.add(l_calling_fn, 'transaction_header_id_in', r_dist.transaction_header_id_in,p_log_level_rec);
1403: fa_debug_pkg.add(l_calling_fn, 'transaction_header_id_out', r_dist.transaction_header_id_out,p_log_level_rec);
1404: fa_debug_pkg.add(l_calling_fn, 'units_assigned', r_dist.units_assigned,p_log_level_rec);
1405: fa_debug_pkg.add(l_calling_fn, 'transaction_units', r_dist.transaction_units,p_log_level_rec);

Line 1402: fa_debug_pkg.add(l_calling_fn, 'transaction_header_id_in', r_dist.transaction_header_id_in,p_log_level_rec);

1398:
1399: if (p_log_level_rec.statement_level) then
1400: for r_dist in c_dist loop
1401: fa_debug_pkg.add(l_calling_fn, 'distribution_id', r_dist.distribution_id,p_log_level_rec);
1402: fa_debug_pkg.add(l_calling_fn, 'transaction_header_id_in', r_dist.transaction_header_id_in,p_log_level_rec);
1403: fa_debug_pkg.add(l_calling_fn, 'transaction_header_id_out', r_dist.transaction_header_id_out,p_log_level_rec);
1404: fa_debug_pkg.add(l_calling_fn, 'units_assigned', r_dist.units_assigned,p_log_level_rec);
1405: fa_debug_pkg.add(l_calling_fn, 'transaction_units', r_dist.transaction_units,p_log_level_rec);
1406: end loop;

Line 1403: fa_debug_pkg.add(l_calling_fn, 'transaction_header_id_out', r_dist.transaction_header_id_out,p_log_level_rec);

1399: if (p_log_level_rec.statement_level) then
1400: for r_dist in c_dist loop
1401: fa_debug_pkg.add(l_calling_fn, 'distribution_id', r_dist.distribution_id,p_log_level_rec);
1402: fa_debug_pkg.add(l_calling_fn, 'transaction_header_id_in', r_dist.transaction_header_id_in,p_log_level_rec);
1403: fa_debug_pkg.add(l_calling_fn, 'transaction_header_id_out', r_dist.transaction_header_id_out,p_log_level_rec);
1404: fa_debug_pkg.add(l_calling_fn, 'units_assigned', r_dist.units_assigned,p_log_level_rec);
1405: fa_debug_pkg.add(l_calling_fn, 'transaction_units', r_dist.transaction_units,p_log_level_rec);
1406: end loop;
1407: end if;

Line 1404: fa_debug_pkg.add(l_calling_fn, 'units_assigned', r_dist.units_assigned,p_log_level_rec);

1400: for r_dist in c_dist loop
1401: fa_debug_pkg.add(l_calling_fn, 'distribution_id', r_dist.distribution_id,p_log_level_rec);
1402: fa_debug_pkg.add(l_calling_fn, 'transaction_header_id_in', r_dist.transaction_header_id_in,p_log_level_rec);
1403: fa_debug_pkg.add(l_calling_fn, 'transaction_header_id_out', r_dist.transaction_header_id_out,p_log_level_rec);
1404: fa_debug_pkg.add(l_calling_fn, 'units_assigned', r_dist.units_assigned,p_log_level_rec);
1405: fa_debug_pkg.add(l_calling_fn, 'transaction_units', r_dist.transaction_units,p_log_level_rec);
1406: end loop;
1407: end if;
1408:

Line 1405: fa_debug_pkg.add(l_calling_fn, 'transaction_units', r_dist.transaction_units,p_log_level_rec);

1401: fa_debug_pkg.add(l_calling_fn, 'distribution_id', r_dist.distribution_id,p_log_level_rec);
1402: fa_debug_pkg.add(l_calling_fn, 'transaction_header_id_in', r_dist.transaction_header_id_in,p_log_level_rec);
1403: fa_debug_pkg.add(l_calling_fn, 'transaction_header_id_out', r_dist.transaction_header_id_out,p_log_level_rec);
1404: fa_debug_pkg.add(l_calling_fn, 'units_assigned', r_dist.units_assigned,p_log_level_rec);
1405: fa_debug_pkg.add(l_calling_fn, 'transaction_units', r_dist.transaction_units,p_log_level_rec);
1406: end loop;
1407: end if;
1408:
1409: return true;

Line 1414: fa_debug_pkg.add(l_calling_fn, '(rein_err)Processing reinstatement', 'Failed',p_log_level_rec);

1410:
1411: EXCEPTION
1412: when rein_err then
1413: if (p_log_level_rec.statement_level) then
1414: fa_debug_pkg.add(l_calling_fn, '(rein_err)Processing reinstatement', 'Failed',p_log_level_rec);
1415: end if;
1416:
1417: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
1418: p_log_level_rec => p_log_level_rec);

Line 1424: fa_debug_pkg.add(l_calling_fn, '(others)Processing reinstatement', 'Failed',p_log_level_rec);

1420: return false;
1421:
1422: when OTHERS then
1423: if (p_log_level_rec.statement_level) then
1424: fa_debug_pkg.add(l_calling_fn, '(others)Processing reinstatement', 'Failed',p_log_level_rec);
1425: end if;
1426:
1427: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn,
1428: p_log_level_rec => p_log_level_rec);

Line 1503: fa_debug_pkg.add(l_calling_fn, 'Begin',

1499:
1500:
1501: BEGIN
1502: if (p_log_level_rec.statement_level) then
1503: fa_debug_pkg.add(l_calling_fn, 'Begin',
1504: p_asset_hdr_rec.asset_id||':'||p_asset_fin_rec.group_asset_id,p_log_level_rec);
1505: end if;
1506:
1507: -- BUG# 3641747

Line 1547: --fa_debug_pkg.add(l_calling_fn,'Before 1st check, book_class', fa_cache_pkg.fazcbc_record.book_class);

1543: l_adj.account := fa_cache_pkg.fazccb_record.asset_cost_acct;
1544: l_adj.account_type := 'ASSET_COST_ACCT';
1545: end if;
1546:
1547: --fa_debug_pkg.add(l_calling_fn,'Before 1st check, book_class', fa_cache_pkg.fazcbc_record.book_class);
1548:
1549: if ((nvl(p_asset_retire_rec.units_retired, 0) > 0) and
1550: (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') and
1551: (p_mode = 'CR')) then

Line 1560: fa_debug_pkg.add(l_calling_fn, 'Error', 'Getting selection_thid',p_log_level_rec);

1556:
1557: if (nvl(l_adj.selection_thid, 0) = 0) then
1558:
1559: if (p_log_level_rec.statement_level) then
1560: fa_debug_pkg.add(l_calling_fn, 'Error', 'Getting selection_thid',p_log_level_rec);
1561: end if;
1562:
1563: raise calc_err;
1564: end if; */

Line 1597: --fa_debug_pkg.add(l_calling_fn,'Before DR logic, book',p_asset_hdr_rec.book_type_code);

1593: raise calc_err;
1594: end if;
1595: end if;
1596:
1597: --fa_debug_pkg.add(l_calling_fn,'Before DR logic, book',p_asset_hdr_rec.book_type_code);
1598: -- Need to call cache again as this gets reset when the dist api gets called.
1599: if not fa_cache_pkg.fazcbc(x_book => p_asset_hdr_rec.book_type_code
1600: ,p_log_level_rec => p_log_level_rec) then
1601: raise calc_err;

Line 1607: --fa_debug_pkg.add(l_calling_fn,'In DR logic, units_retired',p_asset_retire_rec.units_retired);

1603:
1604: --Doing this check due to 3188851.
1605: if p_mode <> 'CR' then
1606:
1607: --fa_debug_pkg.add(l_calling_fn,'In DR logic, units_retired',p_asset_retire_rec.units_retired);
1608: --fa_debug_pkg.add(l_calling_fn,'In DR logic, book_class', fa_cache_pkg.fazcbc_record.book_class);
1609:
1610: if ((nvl(p_asset_retire_rec.units_retired, 0) > 0) and
1611: (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE')) then

Line 1608: --fa_debug_pkg.add(l_calling_fn,'In DR logic, book_class', fa_cache_pkg.fazcbc_record.book_class);

1604: --Doing this check due to 3188851.
1605: if p_mode <> 'CR' then
1606:
1607: --fa_debug_pkg.add(l_calling_fn,'In DR logic, units_retired',p_asset_retire_rec.units_retired);
1608: --fa_debug_pkg.add(l_calling_fn,'In DR logic, book_class', fa_cache_pkg.fazcbc_record.book_class);
1609:
1610: if ((nvl(p_asset_retire_rec.units_retired, 0) > 0) and
1611: (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE')) then
1612: --

Line 1704: fa_debug_pkg.add(l_calling_fn, 'Retired Reserve', l_adj.adjustment_amount,p_log_level_rec);

1700: end if;
1701:
1702: --tk_util.DumpAdjRec(l_adj, 'RSVm');
1703: if (p_log_level_rec.statement_level) then
1704: fa_debug_pkg.add(l_calling_fn, 'Retired Reserve', l_adj.adjustment_amount,p_log_level_rec);
1705: end if;
1706:
1707: if not FA_INS_ADJUST_PKG.faxinaj
1708: (l_adj,

Line 1728: fa_debug_pkg.add(l_calling_fn, 'Retired Reserve for Proceeds of Sale', l_adj.adjustment_amount,p_log_level_rec);

1724:
1725: --tk_util.DumpAdjRec(l_adj, 'RSVposm');
1726:
1727: if (p_log_level_rec.statement_level) then
1728: fa_debug_pkg.add(l_calling_fn, 'Retired Reserve for Proceeds of Sale', l_adj.adjustment_amount,p_log_level_rec);
1729: end if;
1730:
1731: if not FA_INS_ADJUST_PKG.faxinaj
1732: (l_adj,

Line 1751: fa_debug_pkg.add(l_calling_fn, 'Retired Reserve for Cost of Removal', l_adj.adjustment_amount,p_log_level_rec);

1747:
1748: --tk_util.DumpAdjRec(l_adj, 'RSVcorm');
1749:
1750: if (p_log_level_rec.statement_level) then
1751: fa_debug_pkg.add(l_calling_fn, 'Retired Reserve for Cost of Removal', l_adj.adjustment_amount,p_log_level_rec);
1752: end if;
1753:
1754: if not FA_INS_ADJUST_PKG.faxinaj
1755: (l_adj,

Line 1776: fa_debug_pkg.add(l_calling_fn, 'Cost of Removal for member asset', l_adj.adjustment_amount,

1772:
1773: --tk_util.DumpAdjRec(l_adj, 'Member COR');
1774:
1775: if (p_log_level_rec.statement_level) then
1776: fa_debug_pkg.add(l_calling_fn, 'Cost of Removal for member asset', l_adj.adjustment_amount,
1777: p_log_level_rec);
1778: end if;
1779:
1780: if not FA_INS_ADJUST_PKG.faxinaj

Line 1801: fa_debug_pkg.add(l_calling_fn, 'Proceeds of Sale for member asset', l_adj.adjustment_amount,p_log_level_rec);

1797:
1798: --tk_util.DumpAdjRec(l_adj, 'MemberPOS');
1799:
1800: if (p_log_level_rec.statement_level) then
1801: fa_debug_pkg.add(l_calling_fn, 'Proceeds of Sale for member asset', l_adj.adjustment_amount,p_log_level_rec);
1802: end if;
1803:
1804: if not FA_INS_ADJUST_PKG.faxinaj
1805: (l_adj,

Line 2153: fa_debug_pkg.add(l_calling_fn, 'End', 'Success',p_log_level_rec);

2149:
2150: end if; --p_mode <> 'CR'
2151:
2152: if (p_log_level_rec.statement_level) then
2153: fa_debug_pkg.add(l_calling_fn, 'End', 'Success',p_log_level_rec);
2154: end if;
2155:
2156: return true;
2157:

Line 2297: fa_debug_pkg.add(l_calling_fn, 'Begin', p_asset_hdr_rec.asset_id||':'||p_asset_fin_rec.group_asset_id,p_log_level_rec);

2293:
2294: BEGIN
2295:
2296: if (p_log_level_rec.statement_level) then
2297: fa_debug_pkg.add(l_calling_fn, 'Begin', p_asset_hdr_rec.asset_id||':'||p_asset_fin_rec.group_asset_id,p_log_level_rec);
2298: end if;
2299:
2300: -- BUG# 3641747
2301: -- call cache as it was not yet initialized

Line 2414: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt',p_log_level_rec);

2410: if (not fa_cache_pkg.fazccmt(p_asset_fin_rec.deprn_method_code,
2411: p_asset_fin_rec.life_in_months
2412: ,p_log_level_rec => p_log_level_rec)) then
2413: if (p_log_level_rec.statement_level) then
2414: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'fa_cache_pkg.fazccmt',p_log_level_rec);
2415: end if;
2416:
2417: raise calc_err;
2418: end if;

Line 2421: fa_debug_pkg.add(l_calling_fn, 'tracking_method',

2417: raise calc_err;
2418: end if;
2419:
2420: if (p_log_level_rec.statement_level) then
2421: fa_debug_pkg.add(l_calling_fn, 'tracking_method',
2422: p_asset_fin_rec.tracking_method,p_log_level_rec);
2423: fa_debug_pkg.add(l_calling_fn, 'rule_name',
2424: fa_cache_pkg.fazcdrd_record.rule_name,p_log_level_rec);
2425: end if;

Line 2423: fa_debug_pkg.add(l_calling_fn, 'rule_name',

2419:
2420: if (p_log_level_rec.statement_level) then
2421: fa_debug_pkg.add(l_calling_fn, 'tracking_method',
2422: p_asset_fin_rec.tracking_method,p_log_level_rec);
2423: fa_debug_pkg.add(l_calling_fn, 'rule_name',
2424: fa_cache_pkg.fazcdrd_record.rule_name,p_log_level_rec);
2425: end if;
2426: -- toru
2427: -- Energy: Need to reinstate member reserve entry cre

Line 2433: fa_debug_pkg.add(l_calling_fn, 'reserve retired',

2429: -- handle all allocate cases the same way rather than just energy
2430: -- (l_group_db_rule_name = 'ENERGY PERIOD END BALANCE')
2431: if (nvl(p_asset_fin_rec.tracking_method, 'NO TRACK') = 'ALLOCATE') then -- ENERGY
2432: if (p_log_level_rec.statement_level) then
2433: fa_debug_pkg.add(l_calling_fn, 'reserve retired',
2434: p_asset_retire_rec.reserve_retired,p_log_level_rec);
2435: end if;
2436:
2437: l_adj.selection_mode := FA_ADJUST_TYPE_PKG.FA_AJ_ACTIVE;

Line 2828: fa_debug_pkg.add(l_calling_fn, 'End', 'Success',p_log_level_rec);

2824:
2825: end if; -- (p_asset_fin_rec.tracking_method = 'CALCULATE')
2826:
2827: if (p_log_level_rec.statement_level) then
2828: fa_debug_pkg.add(l_calling_fn, 'End', 'Success',p_log_level_rec);
2829: end if;
2830:
2831: return true;
2832:

Line 2938: fa_debug_pkg.add(l_calling_fn, 'Begin',

2934: calc_err EXCEPTION;
2935:
2936: BEGIN
2937: if (p_log_level_rec.statement_level) then
2938: fa_debug_pkg.add(l_calling_fn, 'Begin',
2939: p_ret.asset_id||':'||p_bk.group_asset_id,p_log_level_rec);
2940: end if;
2941:
2942: --

Line 2976: fa_debug_pkg.add(l_calling_fn, 'Looking for retirement transaction', 'FAILED',p_log_level_rec);

2972: CLOSE c_get_thx;
2973:
2974: if (l_trans_rec.transaction_date_entered is null) then
2975: if (p_log_level_rec.statement_level) then
2976: fa_debug_pkg.add(l_calling_fn, 'Looking for retirement transaction', 'FAILED',p_log_level_rec);
2977:
2978: end if;
2979:
2980: raise calc_err;

Line 3090: fa_debug_pkg.add(l_calling_fn, 'Recapture Excess Reserve',

3086: if (l_new_rec_cost < l_new_reserve) then
3087: l_adj.adjustment_amount := l_new_reserve - l_new_rec_cost;
3088:
3089: if (p_log_level_rec.statement_level) then
3090: fa_debug_pkg.add(l_calling_fn, 'Recapture Excess Reserve',
3091: l_adj.adjustment_amount,p_log_level_rec);
3092: end if;
3093:
3094: if l_asset_type_rec.asset_type = 'CIP' then

Line 3175: fa_debug_pkg.add(l_calling_fn, 'Process Non Member Rollup Group',

3171: p_log_level_rec => p_log_level_rec);
3172:
3173:
3174: if (p_log_level_rec.statement_level) then
3175: fa_debug_pkg.add(l_calling_fn, 'Process Non Member Rollup Group',
3176: l_asset_hdr_rec.asset_id,p_log_level_rec);
3177: end if;
3178:
3179:

Line 3195: fa_debug_pkg.add(l_calling_fn, 'Call FA_ADJUSTMENT_PVT.do_adjustment3',

3191: AND BOOK_TYPE_CODE = l_asset_hdr_rec.book_type_code;
3192: end if;
3193:
3194: if (p_log_level_rec.statement_level) then
3195: fa_debug_pkg.add(l_calling_fn, 'Call FA_ADJUSTMENT_PVT.do_adjustment3',
3196: 'Begin',p_log_level_rec);
3197: end if;
3198:
3199: if not FA_ADJUSTMENT_PVT.do_adjustment

Line 3219: fa_debug_pkg.add(l_calling_fn, 'Call FA_ADJUSTMENT_PVT.do_adjustment',

3215: p_calling_fn => l_calling_fn,
3216: p_log_level_rec => p_log_level_rec)then
3217:
3218: if (p_log_level_rec.statement_level) then
3219: fa_debug_pkg.add(l_calling_fn, 'Call FA_ADJUSTMENT_PVT.do_adjustment',
3220: 'Failed',p_log_level_rec);
3221: end if;
3222:
3223: raise calc_err;

Line 3232: fa_debug_pkg.add(l_calling_fn, 'Process Member Rollup Group',

3228: --
3229: -- This is Sum up member depreciation to group asset
3230: --
3231: if (p_log_level_rec.statement_level) then
3232: fa_debug_pkg.add(l_calling_fn, 'Process Member Rollup Group',
3233: l_asset_hdr_rec.asset_id,p_log_level_rec);
3234: end if;
3235: end if; -- (nvl(l_asset_fin_rec_old.member_rollup_flag, 'N') = 'N')
3236:

Line 3245: fa_debug_pkg.add(l_calling_fn, 'Is there a member asset',

3241: FETCH c_member_exists INTO l_member_exists;
3242: CLOSE c_member_exists;
3243:
3244: if (p_log_level_rec.statement_level) then
3245: fa_debug_pkg.add(l_calling_fn, 'Is there a member asset',
3246: l_member_exists,p_log_level_rec);
3247: end if;
3248:
3249: if (nvl(l_member_exists, 'N') <> 'Y') then

Line 3264: fa_debug_pkg.add(l_calling_fn, 'Call',

3260:
3261: else
3262:
3263: if (p_log_level_rec.statement_level) then
3264: fa_debug_pkg.add(l_calling_fn, 'Call',
3265: 'fa_query_balances_pkg.query_balances',p_log_level_rec);
3266: end if;
3267:
3268: fa_query_balances_pkg.query_balances(

Line 3297: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve',

3293: X_bonus_deprn_amount => l_temp_num,
3294: p_log_level_rec => p_log_level_rec);
3295:
3296: if (p_log_level_rec.statement_level) then
3297: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve',
3298: l_deprn_reserve,p_log_level_rec);
3299: end if;
3300:
3301: -- If remaining resrve is not 0, insert NBV RETIRED GAIN/LOSS,

Line 3307: fa_debug_pkg.add(l_calling_fn, 'Create Terminal Gain/Loss entries',

3303: -- update terminal gain loss amount in fa_books
3304: if (nvl(l_deprn_reserve, 0) <> 0) then
3305:
3306: if (p_log_level_rec.statement_level) then
3307: fa_debug_pkg.add(l_calling_fn, 'Create Terminal Gain/Loss entries',
3308: 'Begin',p_log_level_rec);
3309: end if;
3310:
3311: l_adj.asset_id := l_asset_hdr_rec.asset_id;

Line 3376: fa_debug_pkg.add(l_calling_fn, 'Create Terminal Gain/Loss entries',

3372: raise calc_err;
3373: end if;
3374:
3375: if (p_log_level_rec.statement_level) then
3376: fa_debug_pkg.add(l_calling_fn, 'Create Terminal Gain/Loss entries',
3377: 'End',p_log_level_rec);
3378: end if;
3379:
3380: FA_BOOKS_PKG.Update_Row(

Line 3397: fa_debug_pkg.add(l_calling_fn, 'End', 'Success',p_log_level_rec);

3393:
3394: end if; -- (nvl(l_asset_fin_rec_old.terminal_gain_loss, 'NO') = 'YES') and
3395:
3396: if (p_log_level_rec.statement_level) then
3397: fa_debug_pkg.add(l_calling_fn, 'End', 'Success',p_log_level_rec);
3398: end if;
3399:
3400: return TRUE;
3401:

Line 3469: fa_debug_pkg.add(l_calling_fn, 'Begin',

3465: calc_err EXCEPTION;
3466:
3467: BEGIN
3468: if (p_log_level_rec.statement_level) then
3469: fa_debug_pkg.add(l_calling_fn, 'Begin',
3470: p_ret.asset_id||':'||p_bk.group_asset_id,p_log_level_rec);
3471: end if;
3472:
3473: --

Line 3501: fa_debug_pkg.add(l_calling_fn, 'Looking for retirement transaction', 'FAILED',p_log_level_rec);

3497: CLOSE c_get_thx;
3498:
3499: if (l_trans_rec.transaction_date_entered is null) then
3500: if (p_log_level_rec.statement_level) then
3501: fa_debug_pkg.add(l_calling_fn, 'Looking for retirement transaction', 'FAILED',p_log_level_rec);
3502:
3503: end if;
3504:
3505: raise calc_err;

Line 3602: fa_debug_pkg.add(l_calling_fn, 'Call FA_ADJUSTMENT_PVT.do_adjustment4',

3598: AND ASSET_ID = l_asset_hdr_rec.asset_id
3599: AND BOOK_TYPE_CODE = l_asset_hdr_rec.book_type_code;
3600:
3601: if (p_log_level_rec.statement_level) then
3602: fa_debug_pkg.add(l_calling_fn, 'Call FA_ADJUSTMENT_PVT.do_adjustment4',
3603: 'Begin',p_log_level_rec);
3604:
3605: end if;
3606:

Line 3633: fa_debug_pkg.add(l_calling_fn, 'Process Member Rollup Group',

3629: --
3630: -- This is Sum up member depreciation to group asset
3631: --
3632: if (p_log_level_rec.statement_level) then
3633: fa_debug_pkg.add(l_calling_fn, 'Process Member Rollup Group',
3634: l_asset_hdr_rec.asset_id,p_log_level_rec);
3635: end if;
3636:
3637: -- +++++ Remove group expense rows +++++

Line 3770: fa_debug_pkg.add(l_calling_fn, 'Call',

3766:
3767: if (nvl(l_member_exists, 'N') = 'N') then
3768:
3769: if (p_log_level_rec.statement_level) then
3770: fa_debug_pkg.add(l_calling_fn, 'Call',
3771: 'fa_query_balances_pkg.query_balances',p_log_level_rec);
3772: end if;
3773:
3774: fa_query_balances_pkg.query_balances(

Line 3803: fa_debug_pkg.add(l_calling_fn, 'Coming back from Query Balance',

3799: X_bonus_deprn_amount => l_temp_num,
3800: p_log_level_rec => p_log_level_rec);
3801:
3802: if (p_log_level_rec.statement_level) then
3803: fa_debug_pkg.add(l_calling_fn, 'Coming back from Query Balance',
3804: l_deprn_reserve,p_log_level_rec);
3805: end if;
3806:
3807: l_adj.asset_id := p_asset_id;

Line 3820: fa_debug_pkg.add(l_calling_fn, 'Transaction_Header_Id for Terminal GL',

3816: CLOSE c_max_ret_thid;
3817: end if;
3818:
3819: if (p_log_level_rec.statement_level) then
3820: fa_debug_pkg.add(l_calling_fn, 'Transaction_Header_Id for Terminal GL',
3821: l_adj.transaction_header_id,p_log_level_rec);
3822: end if;
3823:
3824: l_adj.book_type_code := p_book_type_code;

Line 3902: fa_debug_pkg.add(l_calling_fn, 'There is at least non retired member exists',

3898: p_log_level_rec => p_log_level_rec);
3899:
3900: else
3901: if (p_log_level_rec.statement_level) then
3902: fa_debug_pkg.add(l_calling_fn, 'There is at least non retired member exists',
3903: p_asset_id,p_log_level_rec);
3904: end if;
3905: --
3906: -- Must not calculate terminal gain loss as long as some

Line 3979: fa_debug_pkg.add(l_calling_fn, 'Begin', p_book_type_code,p_log_level_rec);

3975:
3976: BEGIN
3977:
3978: if (p_log_level_rec.statement_level) then
3979: fa_debug_pkg.add(l_calling_fn, 'Begin', p_book_type_code,p_log_level_rec);
3980: end if;
3981:
3982: --+++++ Get Current Period Info +++++
3983: if not FA_UTIL_PVT.get_period_rec(

Line 4018: fa_debug_pkg.add(l_calling_fn, 'Number of rows fetched',

4014: FETCH c_get_groups BULK COLLECT INTO t_asset_id;
4015: end if;
4016:
4017: if (p_log_level_rec.statement_level) then
4018: fa_debug_pkg.add(l_calling_fn, 'Number of rows fetched',
4019: to_char(t_asset_id.count),p_log_level_rec);
4020: end if;
4021:
4022: EXIT WHEN t_asset_id.count = 0;

Line 4048: fa_debug_pkg.add (l_calling_fn, 'Reporting book loop: Set_of_books_id',

4044:
4045: for l_sob_index in 1..l_sob_tbl.count loop
4046:
4047: if p_log_level_rec.statement_level then
4048: fa_debug_pkg.add (l_calling_fn, 'Reporting book loop: Set_of_books_id',
4049: l_sob_tbl(l_sob_index),p_log_level_rec);
4050: end if;
4051:
4052: -- set the sob_id and currency context for reporting book(sob)

Line 4086: fa_debug_pkg.add(l_calling_fn, 'End', p_book_type_code,p_log_level_rec);

4082: CLOSE c_get_groups;
4083: end if;
4084:
4085: if (p_log_level_rec.statement_level) then
4086: fa_debug_pkg.add(l_calling_fn, 'End', p_book_type_code,p_log_level_rec);
4087: end if;
4088:
4089: return true;
4090:

Line 4151: fa_debug_pkg.add(l_calling_fn, 'Begin', to_char(p_asset_hdr_rec.asset_id)||':'||

4147:
4148: tgl_err EXCEPTION;
4149: BEGIN
4150: if (p_log_level_rec.statement_level) then
4151: fa_debug_pkg.add(l_calling_fn, 'Begin', to_char(p_asset_hdr_rec.asset_id)||':'||
4152: p_asset_hdr_rec.book_type_code,p_log_level_rec);
4153: end if;
4154:
4155: --

Line 4179: fa_debug_pkg.add(l_calling_fn, 'Member exists', to_char(l_asset_id),p_log_level_rec);

4175:
4176: if (l_asset_id is not null) then
4177:
4178: if (p_log_level_rec.statement_level) then
4179: fa_debug_pkg.add(l_calling_fn, 'Member exists', to_char(l_asset_id),p_log_level_rec);
4180: fa_debug_pkg.add(l_calling_fn, 'End', 'No Terminal Gain Loss Calculated',p_log_level_rec);
4181: end if;
4182:
4183: return TRUE;

Line 4180: fa_debug_pkg.add(l_calling_fn, 'End', 'No Terminal Gain Loss Calculated',p_log_level_rec);

4176: if (l_asset_id is not null) then
4177:
4178: if (p_log_level_rec.statement_level) then
4179: fa_debug_pkg.add(l_calling_fn, 'Member exists', to_char(l_asset_id),p_log_level_rec);
4180: fa_debug_pkg.add(l_calling_fn, 'End', 'No Terminal Gain Loss Calculated',p_log_level_rec);
4181: end if;
4182:
4183: return TRUE;
4184:

Line 4188: fa_debug_pkg.add(l_calling_fn, 'Continue', 'Checking remaining reserve ',p_log_level_rec);

4184:
4185: end if;
4186:
4187: if (p_log_level_rec.statement_level) then
4188: fa_debug_pkg.add(l_calling_fn, 'Continue', 'Checking remaining reserve ',p_log_level_rec);
4189: end if;
4190:
4191: if (p_log_level_rec.statement_level) then
4192: fa_debug_pkg.add(l_calling_fn, 'Call',

Line 4192: fa_debug_pkg.add(l_calling_fn, 'Call',

4188: fa_debug_pkg.add(l_calling_fn, 'Continue', 'Checking remaining reserve ',p_log_level_rec);
4189: end if;
4190:
4191: if (p_log_level_rec.statement_level) then
4192: fa_debug_pkg.add(l_calling_fn, 'Call',
4193: 'fa_query_balances_pkg.query_balances',p_log_level_rec);
4194: end if;
4195:
4196: fa_query_balances_pkg.query_balances(

Line 4225: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve',

4221: X_bonus_deprn_amount => l_temp_num,
4222: p_log_level_rec => p_log_level_rec);
4223:
4224: if (p_log_level_rec.statement_level) then
4225: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve',
4226: l_deprn_reserve,p_log_level_rec);
4227: end if;
4228:
4229: if (nvl(l_deprn_reserve, 0) = 0) then

Line 4232: fa_debug_pkg.add(l_calling_fn, 'Reserve is 0', 'No Terminal Gain Loss Calculated',p_log_level_rec);

4228:
4229: if (nvl(l_deprn_reserve, 0) = 0) then
4230:
4231: if (p_log_level_rec.statement_level) then
4232: fa_debug_pkg.add(l_calling_fn, 'Reserve is 0', 'No Terminal Gain Loss Calculated',p_log_level_rec);
4233: end if;
4234:
4235: return TRUE;
4236:

Line 4240: fa_debug_pkg.add(l_calling_fn, 'Continue', 'Eligible for Terminal Gain Loss',p_log_level_rec);

4236:
4237: end if;
4238:
4239: if (p_log_level_rec.statement_level) then
4240: fa_debug_pkg.add(l_calling_fn, 'Continue', 'Eligible for Terminal Gain Loss',p_log_level_rec);
4241: end if;
4242:
4243: --
4244: -- Setting TERMINAL_GAIN_LOSS_FLAG so terminal gain loss will be

Line 4281: fa_debug_pkg.add(l_calling_fn, 'l_is_tgl_due', l_is_tgl_due

4277: end if; -- (p_asset_fin_rec.cost = 0) and
4278:
4279:
4280: if (p_log_level_rec.statement_level) then
4281: fa_debug_pkg.add(l_calling_fn, 'l_is_tgl_due', l_is_tgl_due
4282: ,p_log_level_rec => p_log_level_rec);
4283: fa_debug_pkg.add(l_calling_fn, 'End', 'SUCCESS',p_log_level_rec);
4284: end if;
4285:

Line 4283: fa_debug_pkg.add(l_calling_fn, 'End', 'SUCCESS',p_log_level_rec);

4279:
4280: if (p_log_level_rec.statement_level) then
4281: fa_debug_pkg.add(l_calling_fn, 'l_is_tgl_due', l_is_tgl_due
4282: ,p_log_level_rec => p_log_level_rec);
4283: fa_debug_pkg.add(l_calling_fn, 'End', 'SUCCESS',p_log_level_rec);
4284: end if;
4285:
4286: return TRUE;
4287:

Line 4291: fa_debug_pkg.add(l_calling_fn, 'End', FALSE,p_log_level_rec);

4287:
4288: EXCEPTION
4289: WHEN tgl_err THEN
4290: if (p_log_level_rec.statement_level) then
4291: fa_debug_pkg.add(l_calling_fn, 'End', FALSE,p_log_level_rec);
4292: end if;
4293:
4294: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
4295: p_log_level_rec => p_log_level_rec);

Line 4300: fa_debug_pkg.add(l_calling_fn, 'End', FALSE,p_log_level_rec);

4296: return FALSE;
4297:
4298: WHEN OTHERS THEN
4299: if (p_log_level_rec.statement_level) then
4300: fa_debug_pkg.add(l_calling_fn, 'End', FALSE,p_log_level_rec);
4301: end if;
4302:
4303: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
4304: p_log_level_rec => p_log_level_rec);

Line 4551: fa_debug_pkg.add(l_calling_fn, 'Begin', p_asset_hdr_rec.asset_id,p_log_level_rec);

4547:
4548: BEGIN
4549:
4550: if (p_log_level_rec.statement_level) then
4551: fa_debug_pkg.add(l_calling_fn, 'Begin', p_asset_hdr_rec.asset_id,p_log_level_rec);
4552: fa_debug_pkg.add(l_calling_fn, 'Transaction_key', p_trans_rec.transaction_key,p_log_level_rec);
4553: end if;
4554:
4555: -- Prepare common FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT parameters

Line 4552: fa_debug_pkg.add(l_calling_fn, 'Transaction_key', p_trans_rec.transaction_key,p_log_level_rec);

4548: BEGIN
4549:
4550: if (p_log_level_rec.statement_level) then
4551: fa_debug_pkg.add(l_calling_fn, 'Begin', p_asset_hdr_rec.asset_id,p_log_level_rec);
4552: fa_debug_pkg.add(l_calling_fn, 'Transaction_key', p_trans_rec.transaction_key,p_log_level_rec);
4553: end if;
4554:
4555: -- Prepare common FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT parameters
4556: l_adj.book_type_code := p_asset_hdr_rec.book_type_code;

Line 4623: fa_debug_pkg.add(l_calling_fn, 'group reserve', p_asset_deprn_rec_new.deprn_reserve,p_log_level_rec);

4619: l_sum_adj_cost := p_asset_fin_rec.recoverable_cost - p_asset_deprn_rec_new.deprn_reserve -
4620: p_reserve_amount;
4621:
4622: if (p_log_level_rec.statement_level) then
4623: fa_debug_pkg.add(l_calling_fn, 'group reserve', p_asset_deprn_rec_new.deprn_reserve,p_log_level_rec);
4624: fa_debug_pkg.add(l_calling_fn, 'sum rec_cost', p_asset_fin_rec.recoverable_cost,p_log_level_rec);
4625: fa_debug_pkg.add(l_calling_fn, 'p_reserve_amount', p_reserve_amount,p_log_level_rec);
4626: fa_debug_pkg.add(l_calling_fn, 'l_sum_adj_cost', l_sum_adj_cost,p_log_level_rec);
4627: end if;

Line 4624: fa_debug_pkg.add(l_calling_fn, 'sum rec_cost', p_asset_fin_rec.recoverable_cost,p_log_level_rec);

4620: p_reserve_amount;
4621:
4622: if (p_log_level_rec.statement_level) then
4623: fa_debug_pkg.add(l_calling_fn, 'group reserve', p_asset_deprn_rec_new.deprn_reserve,p_log_level_rec);
4624: fa_debug_pkg.add(l_calling_fn, 'sum rec_cost', p_asset_fin_rec.recoverable_cost,p_log_level_rec);
4625: fa_debug_pkg.add(l_calling_fn, 'p_reserve_amount', p_reserve_amount,p_log_level_rec);
4626: fa_debug_pkg.add(l_calling_fn, 'l_sum_adj_cost', l_sum_adj_cost,p_log_level_rec);
4627: end if;
4628:

Line 4625: fa_debug_pkg.add(l_calling_fn, 'p_reserve_amount', p_reserve_amount,p_log_level_rec);

4621:
4622: if (p_log_level_rec.statement_level) then
4623: fa_debug_pkg.add(l_calling_fn, 'group reserve', p_asset_deprn_rec_new.deprn_reserve,p_log_level_rec);
4624: fa_debug_pkg.add(l_calling_fn, 'sum rec_cost', p_asset_fin_rec.recoverable_cost,p_log_level_rec);
4625: fa_debug_pkg.add(l_calling_fn, 'p_reserve_amount', p_reserve_amount,p_log_level_rec);
4626: fa_debug_pkg.add(l_calling_fn, 'l_sum_adj_cost', l_sum_adj_cost,p_log_level_rec);
4627: end if;
4628:
4629:

Line 4626: fa_debug_pkg.add(l_calling_fn, 'l_sum_adj_cost', l_sum_adj_cost,p_log_level_rec);

4622: if (p_log_level_rec.statement_level) then
4623: fa_debug_pkg.add(l_calling_fn, 'group reserve', p_asset_deprn_rec_new.deprn_reserve,p_log_level_rec);
4624: fa_debug_pkg.add(l_calling_fn, 'sum rec_cost', p_asset_fin_rec.recoverable_cost,p_log_level_rec);
4625: fa_debug_pkg.add(l_calling_fn, 'p_reserve_amount', p_reserve_amount,p_log_level_rec);
4626: fa_debug_pkg.add(l_calling_fn, 'l_sum_adj_cost', l_sum_adj_cost,p_log_level_rec);
4627: end if;
4628:
4629:
4630: if (p_mrc_sob_type_code = 'R') then

Line 4682: fa_debug_pkg.add(l_calling_fn, 'In Main Cursor', t_asset_id.count,p_log_level_rec);

4678: , t_current_units LIMIT l_limit;
4679: end if;
4680:
4681: if (p_log_level_rec.statement_level) then
4682: fa_debug_pkg.add(l_calling_fn, 'In Main Cursor', t_asset_id.count,p_log_level_rec);
4683: end if;
4684:
4685: if t_asset_id.count = 0 then
4686:

Line 4759: fa_debug_pkg.add(l_calling_fn, 'Before ADJ LOOP', t_asset_id(1),p_log_level_rec);

4755: l_loc := 'Before ADJ LOOP';
4756: -- Prepare non-common FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT parameters and
4757: -- call faxinaj to create records in FA_ADJUSTMENTS table
4758: if (p_log_level_rec.statement_level) then
4759: fa_debug_pkg.add(l_calling_fn, 'Before ADJ LOOP', t_asset_id(1),p_log_level_rec);
4760: fa_debug_pkg.add(l_calling_fn, 't_asset_id.last', t_asset_id.last,p_log_level_rec);
4761: end if;
4762:
4763:

Line 4760: fa_debug_pkg.add(l_calling_fn, 't_asset_id.last', t_asset_id.last,p_log_level_rec);

4756: -- Prepare non-common FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT parameters and
4757: -- call faxinaj to create records in FA_ADJUSTMENTS table
4758: if (p_log_level_rec.statement_level) then
4759: fa_debug_pkg.add(l_calling_fn, 'Before ADJ LOOP', t_asset_id(1),p_log_level_rec);
4760: fa_debug_pkg.add(l_calling_fn, 't_asset_id.last', t_asset_id.last,p_log_level_rec);
4761: end if;
4762:
4763:
4764: FOR i in 1..t_asset_id.last LOOP

Line 4767: fa_debug_pkg.add(l_calling_fn, 'p_reserve_amount', p_reserve_amount,p_log_level_rec);

4763:
4764: FOR i in 1..t_asset_id.last LOOP
4765:
4766: if (p_log_level_rec.statement_level) then
4767: fa_debug_pkg.add(l_calling_fn, 'p_reserve_amount', p_reserve_amount,p_log_level_rec);
4768: fa_debug_pkg.add(l_calling_fn, 'l_sum_adj_cost', l_sum_adj_cost,p_log_level_rec);
4769: end if;
4770:
4771: if (p_trans_rec.transaction_key = 'MR') or

Line 4768: fa_debug_pkg.add(l_calling_fn, 'l_sum_adj_cost', l_sum_adj_cost,p_log_level_rec);

4764: FOR i in 1..t_asset_id.last LOOP
4765:
4766: if (p_log_level_rec.statement_level) then
4767: fa_debug_pkg.add(l_calling_fn, 'p_reserve_amount', p_reserve_amount,p_log_level_rec);
4768: fa_debug_pkg.add(l_calling_fn, 'l_sum_adj_cost', l_sum_adj_cost,p_log_level_rec);
4769: end if;
4770:
4771: if (p_trans_rec.transaction_key = 'MR') or
4772: (p_mode = 'RECURR') then

Line 4775: fa_debug_pkg.add(l_calling_fn, 'Call',

4771: if (p_trans_rec.transaction_key = 'MR') or
4772: (p_mode = 'RECURR') then
4773:
4774: if (p_log_level_rec.statement_level) then
4775: fa_debug_pkg.add(l_calling_fn, 'Call',
4776: 'fa_query_balances_pkg.query_balances',p_log_level_rec);
4777: end if;
4778:
4779: fa_query_balances_pkg.query_balances(

Line 4808: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve',

4804: X_bonus_deprn_amount => l_temp_num,
4805: p_log_level_rec => p_log_level_rec);
4806:
4807: if (p_log_level_rec.statement_level) then
4808: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve',
4809: l_deprn_reserve,p_log_level_rec);
4810: fa_debug_pkg.add(l_calling_fn, 't_adjusted_cost('||to_char(i)||')',
4811: t_adjusted_cost(i),p_log_level_rec);
4812: fa_debug_pkg.add(l_calling_fn, 't_recoverable_cost('||to_char(i)||')',

Line 4810: fa_debug_pkg.add(l_calling_fn, 't_adjusted_cost('||to_char(i)||')',

4806:
4807: if (p_log_level_rec.statement_level) then
4808: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve',
4809: l_deprn_reserve,p_log_level_rec);
4810: fa_debug_pkg.add(l_calling_fn, 't_adjusted_cost('||to_char(i)||')',
4811: t_adjusted_cost(i),p_log_level_rec);
4812: fa_debug_pkg.add(l_calling_fn, 't_recoverable_cost('||to_char(i)||')',
4813: t_recoverable_cost(i),p_log_level_rec);
4814: end if;

Line 4812: fa_debug_pkg.add(l_calling_fn, 't_recoverable_cost('||to_char(i)||')',

4808: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve',
4809: l_deprn_reserve,p_log_level_rec);
4810: fa_debug_pkg.add(l_calling_fn, 't_adjusted_cost('||to_char(i)||')',
4811: t_adjusted_cost(i),p_log_level_rec);
4812: fa_debug_pkg.add(l_calling_fn, 't_recoverable_cost('||to_char(i)||')',
4813: t_recoverable_cost(i),p_log_level_rec);
4814: end if;
4815:
4816: t_adjusted_cost(i) := t_recoverable_cost(i) - l_deprn_reserve;

Line 4819: fa_debug_pkg.add(l_calling_fn, 't_adjusted_cost('||to_char(i)||')', t_adjusted_cost(i),p_log_level_rec);

4815:
4816: t_adjusted_cost(i) := t_recoverable_cost(i) - l_deprn_reserve;
4817:
4818: if (p_log_level_rec.statement_level) then
4819: fa_debug_pkg.add(l_calling_fn, 't_adjusted_cost('||to_char(i)||')', t_adjusted_cost(i),p_log_level_rec);
4820: end if;
4821:
4822:
4823: l_adj.adjustment_amount := abs(p_reserve_amount) * (t_adjusted_cost(i)/l_sum_adj_cost);

Line 4880: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve',

4876: X_bonus_deprn_amount => l_temp_num,
4877: p_log_level_rec => p_log_level_rec);
4878:
4879: if (p_log_level_rec.statement_level) then
4880: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve',
4881: l_deprn_reserve,p_log_level_rec);
4882: fa_debug_pkg.add(l_calling_fn, 't_adjusted_recoverable_cost('||to_char(i)||')',
4883: t_adjusted_recoverable_cost(i),p_log_level_rec);
4884: end if;

Line 4882: fa_debug_pkg.add(l_calling_fn, 't_adjusted_recoverable_cost('||to_char(i)||')',

4878:
4879: if (p_log_level_rec.statement_level) then
4880: fa_debug_pkg.add(l_calling_fn, 'l_deprn_reserve',
4881: l_deprn_reserve,p_log_level_rec);
4882: fa_debug_pkg.add(l_calling_fn, 't_adjusted_recoverable_cost('||to_char(i)||')',
4883: t_adjusted_recoverable_cost(i),p_log_level_rec);
4884: end if;
4885:
4886: -- Check to see if the asset can take entire reserve reinstated or not.

Line 4907: fa_debug_pkg.add(l_calling_fn, 'Recapture Excess Reserve',

4903:
4904: end if;
4905:
4906: if (p_log_level_rec.statement_level) then
4907: fa_debug_pkg.add(l_calling_fn, 'Recapture Excess Reserve',
4908: l_adj.adjustment_amount,p_log_level_rec);
4909: end if;
4910:
4911: l_adj.asset_id := t_asset_id(i);

Line 5216: fa_debug_pkg.add(l_calling_fn, 'i', i,p_log_level_rec);

5212: BULK COLLECT INTO t_new_adj_cost, t_new_deprn_reserve;
5213:
5214: if (p_log_level_rec.statement_level) then
5215: for i in t_asset_id.first..t_asset_id.last loop
5216: fa_debug_pkg.add(l_calling_fn, 'i', i,p_log_level_rec);
5217: fa_debug_pkg.add(l_calling_fn, 't_new_adj_cost', t_new_adj_cost(i),p_log_level_rec);
5218: fa_debug_pkg.add(l_calling_fn, 't_new_deprn_reserve', t_new_deprn_reserve(i),p_log_level_rec);
5219: fa_debug_pkg.add(l_calling_fn, 't_transaction_header_id_in', t_transaction_header_id_in(i),p_log_level_rec);
5220: fa_debug_pkg.add(l_calling_fn, 't_asset_id', t_asset_id(i),p_log_level_rec);

Line 5217: fa_debug_pkg.add(l_calling_fn, 't_new_adj_cost', t_new_adj_cost(i),p_log_level_rec);

5213:
5214: if (p_log_level_rec.statement_level) then
5215: for i in t_asset_id.first..t_asset_id.last loop
5216: fa_debug_pkg.add(l_calling_fn, 'i', i,p_log_level_rec);
5217: fa_debug_pkg.add(l_calling_fn, 't_new_adj_cost', t_new_adj_cost(i),p_log_level_rec);
5218: fa_debug_pkg.add(l_calling_fn, 't_new_deprn_reserve', t_new_deprn_reserve(i),p_log_level_rec);
5219: fa_debug_pkg.add(l_calling_fn, 't_transaction_header_id_in', t_transaction_header_id_in(i),p_log_level_rec);
5220: fa_debug_pkg.add(l_calling_fn, 't_asset_id', t_asset_id(i),p_log_level_rec);
5221: fa_debug_pkg.add(l_calling_fn, 't_thid', t_thid(i),p_log_level_rec);

Line 5218: fa_debug_pkg.add(l_calling_fn, 't_new_deprn_reserve', t_new_deprn_reserve(i),p_log_level_rec);

5214: if (p_log_level_rec.statement_level) then
5215: for i in t_asset_id.first..t_asset_id.last loop
5216: fa_debug_pkg.add(l_calling_fn, 'i', i,p_log_level_rec);
5217: fa_debug_pkg.add(l_calling_fn, 't_new_adj_cost', t_new_adj_cost(i),p_log_level_rec);
5218: fa_debug_pkg.add(l_calling_fn, 't_new_deprn_reserve', t_new_deprn_reserve(i),p_log_level_rec);
5219: fa_debug_pkg.add(l_calling_fn, 't_transaction_header_id_in', t_transaction_header_id_in(i),p_log_level_rec);
5220: fa_debug_pkg.add(l_calling_fn, 't_asset_id', t_asset_id(i),p_log_level_rec);
5221: fa_debug_pkg.add(l_calling_fn, 't_thid', t_thid(i),p_log_level_rec);
5222: end loop;

Line 5219: fa_debug_pkg.add(l_calling_fn, 't_transaction_header_id_in', t_transaction_header_id_in(i),p_log_level_rec);

5215: for i in t_asset_id.first..t_asset_id.last loop
5216: fa_debug_pkg.add(l_calling_fn, 'i', i,p_log_level_rec);
5217: fa_debug_pkg.add(l_calling_fn, 't_new_adj_cost', t_new_adj_cost(i),p_log_level_rec);
5218: fa_debug_pkg.add(l_calling_fn, 't_new_deprn_reserve', t_new_deprn_reserve(i),p_log_level_rec);
5219: fa_debug_pkg.add(l_calling_fn, 't_transaction_header_id_in', t_transaction_header_id_in(i),p_log_level_rec);
5220: fa_debug_pkg.add(l_calling_fn, 't_asset_id', t_asset_id(i),p_log_level_rec);
5221: fa_debug_pkg.add(l_calling_fn, 't_thid', t_thid(i),p_log_level_rec);
5222: end loop;
5223: end if;

Line 5220: fa_debug_pkg.add(l_calling_fn, 't_asset_id', t_asset_id(i),p_log_level_rec);

5216: fa_debug_pkg.add(l_calling_fn, 'i', i,p_log_level_rec);
5217: fa_debug_pkg.add(l_calling_fn, 't_new_adj_cost', t_new_adj_cost(i),p_log_level_rec);
5218: fa_debug_pkg.add(l_calling_fn, 't_new_deprn_reserve', t_new_deprn_reserve(i),p_log_level_rec);
5219: fa_debug_pkg.add(l_calling_fn, 't_transaction_header_id_in', t_transaction_header_id_in(i),p_log_level_rec);
5220: fa_debug_pkg.add(l_calling_fn, 't_asset_id', t_asset_id(i),p_log_level_rec);
5221: fa_debug_pkg.add(l_calling_fn, 't_thid', t_thid(i),p_log_level_rec);
5222: end loop;
5223: end if;
5224:

Line 5221: fa_debug_pkg.add(l_calling_fn, 't_thid', t_thid(i),p_log_level_rec);

5217: fa_debug_pkg.add(l_calling_fn, 't_new_adj_cost', t_new_adj_cost(i),p_log_level_rec);
5218: fa_debug_pkg.add(l_calling_fn, 't_new_deprn_reserve', t_new_deprn_reserve(i),p_log_level_rec);
5219: fa_debug_pkg.add(l_calling_fn, 't_transaction_header_id_in', t_transaction_header_id_in(i),p_log_level_rec);
5220: fa_debug_pkg.add(l_calling_fn, 't_asset_id', t_asset_id(i),p_log_level_rec);
5221: fa_debug_pkg.add(l_calling_fn, 't_thid', t_thid(i),p_log_level_rec);
5222: end loop;
5223: end if;
5224:
5225: l_loc := 'Before Books';

Line 5491: fa_debug_pkg.add(l_calling_fn, 'End of Main Loop', p_reserve_amount - l_actual_rsv_total,p_log_level_rec);

5487: -- COMMIT;
5488: END LOOP; -- MAIN OUTER LOOP
5489:
5490: if (p_log_level_rec.statement_level) then
5491: fa_debug_pkg.add(l_calling_fn, 'End of Main Loop', p_reserve_amount - l_actual_rsv_total,p_log_level_rec);
5492: end if;
5493:
5494: if (l_actual_rsv_total = p_reserve_amount) then
5495: if (p_log_level_rec.statement_level) then

Line 5496: fa_debug_pkg.add(l_calling_fn, 'End of allocation', ' ',p_log_level_rec);

5492: end if;
5493:
5494: if (l_actual_rsv_total = p_reserve_amount) then
5495: if (p_log_level_rec.statement_level) then
5496: fa_debug_pkg.add(l_calling_fn, 'End of allocation', ' ',p_log_level_rec);
5497: end if;
5498:
5499: return TRUE;
5500:

Line 5513: fa_debug_pkg.add(l_calling_fn, 'Recurrsive Call Do_Allocation', 'Calling...',p_log_level_rec);

5509: if (p_trans_rec.transaction_key = 'MS') and
5510: (p_mode = 'NORMAL') then
5511: -- Call Do_Allocation again to distribute remaining amounts
5512: if (p_log_level_rec.statement_level) then
5513: fa_debug_pkg.add(l_calling_fn, 'Recurrsive Call Do_Allocation', 'Calling...',p_log_level_rec);
5514: end if;
5515: --toru
5516: if not Do_Allocation(
5517: p_trans_rec => p_trans_rec,

Line 5528: fa_debug_pkg.add(l_calling_fn, 'Recurrsive Call to Do_Allocation', 'Failed',p_log_level_rec);

5524: p_mrc_sob_type_code => p_mrc_sob_type_code,
5525: p_calling_fn => l_calling_fn,
5526: p_log_level_rec => p_log_level_rec) then
5527: if (p_log_level_rec.statement_level) then
5528: fa_debug_pkg.add(l_calling_fn, 'Recurrsive Call to Do_Allocation', 'Failed',p_log_level_rec);
5529: end if;
5530:
5531: raise allocate_err;
5532: end if;

Line 5921: fa_debug_pkg.add(l_calling_fn, 'End', p_reserve_amount,p_log_level_rec);

5917: end if; -- (p_reserve_amount <> l_actual_rsv_total)
5918:
5919:
5920: if (p_log_level_rec.statement_level) then
5921: fa_debug_pkg.add(l_calling_fn, 'End', p_reserve_amount,p_log_level_rec);
5922: end if;
5923:
5924: return true;
5925:

Line 5929: fa_debug_pkg.add(l_calling_fn, 'l_loc', l_loc,p_log_level_rec);

5925:
5926: EXCEPTION
5927: WHEN OTHERS THEN
5928: if (p_log_level_rec.statement_level) then
5929: fa_debug_pkg.add(l_calling_fn, 'l_loc', l_loc,p_log_level_rec);
5930: fa_debug_pkg.add(l_calling_fn, 'End', 'Failed'||':'||sqlerrm,p_log_level_rec);
5931: end if;
5932:
5933: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn

Line 5930: fa_debug_pkg.add(l_calling_fn, 'End', 'Failed'||':'||sqlerrm,p_log_level_rec);

5926: EXCEPTION
5927: WHEN OTHERS THEN
5928: if (p_log_level_rec.statement_level) then
5929: fa_debug_pkg.add(l_calling_fn, 'l_loc', l_loc,p_log_level_rec);
5930: fa_debug_pkg.add(l_calling_fn, 'End', 'Failed'||':'||sqlerrm,p_log_level_rec);
5931: end if;
5932:
5933: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn
5934: ,p_log_level_rec => p_log_level_rec);