eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_AMORT_PVT dependencies on FA_TRACK_MEMBER_PVT

Line 4005: -- defined in FA_TRACK_MEMBER_PVT.

4001: -- setup and user specified reclassification date (amort date) is
4002: -- in the current open period, system don't need to recalculate from
4003: -- DPIS of the member asset to reclassify but jut get stored reserve,
4004: -- YTD Depreciation and EOFY Reserve from table using populate_member_reserve function
4005: -- defined in FA_TRACK_MEMBER_PVT.
4006: --
4007: -- Initialize global variables
4008: g_mem_ytd_deprn := 0;
4009: g_mem_deprn_reserve := 0;

Line 4063: if not FA_TRACK_MEMBER_PVT.populate_member_reserve

4059: if nvl(px_asset_fin_rec_new.tracking_method,'NULL') = 'CALCULATE' and
4060: l_trx_period_rec.period_counter = l_current_period_counter then
4061:
4062: -- Call populate_member_reserve
4063: if not FA_TRACK_MEMBER_PVT.populate_member_reserve
4064: (p_trans_rec => p_trans_rec,
4065: p_asset_hdr_rec => p_asset_hdr_rec,
4066: p_asset_fin_rec_new => px_asset_fin_rec_new,
4067: p_mrc_sob_type_code => p_mrc_sob_type_code,

Line 5519: if not FA_TRACK_MEMBER_PVT.get_member_at_start(

5515: l_raf_processed_flag := TRUE;
5516: l_dpr_in.tracking_method := NULL;
5517:
5518: /*
5519: if not FA_TRACK_MEMBER_PVT.get_member_at_start(
5520: p_period_rec => l_period_rec,
5521: p_trans_rec => p_trans_rec,
5522: p_asset_hdr_rec => p_asset_hdr_rec,
5523: p_asset_fin_rec => px_asset_fin_rec_new,

Line 5528: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'FA_TRACK_MEMBER_PVT.get_member_at_start'

5524: p_dpr_in => l_dpr_in,
5525: p_mrc_sob_type_code => p_mrc_sob_type_code
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, 'Error calling', 'FA_TRACK_MEMBER_PVT.get_member_at_start'
5529: ,p_log_level_rec => p_log_level_rec);
5530: end if;
5531:
5532: raise calc_failed;

Line 5598: fa_track_member_pvt.p_track_member_table.delete;

5594: end if;
5595:
5596: if nvl(l_dpr_in.tracking_method,'OTHER') = 'ALLOCATE' then
5597:
5598: fa_track_member_pvt.p_track_member_table.delete;
5599:
5600: if (p_log_level_rec.statement_level) then
5601: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_table',
5602: 'deleted'

Line 5601: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_table',

5597:
5598: fa_track_member_pvt.p_track_member_table.delete;
5599:
5600: if (p_log_level_rec.statement_level) then
5601: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_table',
5602: 'deleted'
5603: ,p_log_level_rec => p_log_level_rec);
5604: end if;
5605: end if;

Line 5657: fa_debug_pkg.add(l_calling_fn, '++++ Call ++++', 'FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE'

5653: l_recalc_start_period_num := fa_amort_pvt.t_period_num(i) - 1;
5654: end if;
5655:
5656: if (p_log_level_rec.statement_level) then
5657: fa_debug_pkg.add(l_calling_fn, '++++ Call ++++', 'FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE'
5658: ,p_log_level_rec => p_log_level_rec);
5659: fa_debug_pkg.add(l_calling_fn, 'fa_amort_pvt.t_reset_adjusted_cost_flag(i)',
5660: fa_amort_pvt.t_reset_adjusted_cost_flag(i));
5661: fa_debug_pkg.add(l_calling_fn, 'l_recalc_start_fy', l_recalc_start_fy

Line 5685: fa_track_member_pvt.l_process_deprn_for_member := 'NO';

5681: l_recalc_start_fy := fa_amort_pvt.t_fiscal_year(i);
5682: l_recalc_start_period_num := fa_amort_pvt.t_period_num(i);
5683:
5684: l_processed_flag := TRUE;
5685: fa_track_member_pvt.l_process_deprn_for_member := 'NO';
5686: /*
5687: l_asset_fin_rec_new.tracking_method := NULL;
5688: l_asset_fin_rec_old.tracking_method := NULL;
5689: */

Line 5692: fa_debug_pkg.add(l_calling_fn, '++++ Call ++++', 'FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE'

5688: l_asset_fin_rec_old.tracking_method := NULL;
5689: */
5690:
5691: if (p_log_level_rec.statement_level) then
5692: fa_debug_pkg.add(l_calling_fn, '++++ Call ++++', 'FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE'
5693: ,p_log_level_rec => p_log_level_rec);
5694: fa_debug_pkg.add(l_calling_fn, 'fa_amort_pvt.t_reset_adjusted_cost_flag(i)',
5695: fa_amort_pvt.t_reset_adjusted_cost_flag(i));
5696: fa_debug_pkg.add(l_calling_fn, 'l_recalc_start_fy', l_recalc_start_fy

Line 5731: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE

5727: if p_mrc_sob_type_code <> 'R' then
5728: open c_chk_bs_row_exists;
5729: fetch c_chk_bs_row_exists into l_chk_bs_row_exists;
5730: if c_chk_bs_row_exists%FOUND then
5731: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE
5732: (p_asset_hdr_rec => p_asset_hdr_rec,
5733: p_asset_fin_rec_new => px_asset_fin_rec_new,
5734: p_populate_for_recalc_period => 'T',
5735: p_amort_start_date => l_transaction_date_entered,

Line 5748: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE

5744: end if;
5745: raise calc_failed;
5746: end if;
5747: else
5748: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE
5749: (p_asset_hdr_rec => p_asset_hdr_rec,
5750: p_asset_fin_rec_new => px_asset_fin_rec_new,
5751: p_amort_start_date => l_transaction_date_entered,
5752: p_recalc_start_fy => l_recalc_start_fy,

Line 5771: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE

5767:
5768: open c_chk_bs_row_exists_mrc;
5769: fetch c_chk_bs_row_exists_mrc into l_chk_bs_row_exists;
5770: if c_chk_bs_row_exists_mrc%FOUND then
5771: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE
5772: (p_asset_hdr_rec => p_asset_hdr_rec,
5773: p_asset_fin_rec_new => px_asset_fin_rec_new,
5774: p_populate_for_recalc_period => 'T',
5775: p_amort_start_date => l_transaction_date_entered,

Line 5788: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE

5784: end if;
5785: raise calc_failed;
5786: end if;
5787: else
5788: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE
5789: (p_asset_hdr_rec => p_asset_hdr_rec,
5790: p_asset_fin_rec_new => px_asset_fin_rec_new,
5791: p_amort_start_date => l_transaction_date_entered,
5792: p_recalc_start_fy => l_recalc_start_fy,

Line 5815: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE

5811: l_old_recalc_start_fy := l_recalc_start_fy;
5812: l_old_recalc_start_period_num := l_recalc_start_period_num;
5813:
5814: if not (l_backup_processed_flag) then
5815: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE
5816: (p_asset_hdr_rec => p_asset_hdr_rec,
5817: p_asset_fin_rec_new => px_asset_fin_rec_new,
5818: p_amort_start_date => l_transaction_date_entered,
5819: p_recalc_start_fy => l_recalc_start_fy,

Line 5834: fa_track_member_pvt.p_track_member_table_for_deprn.COUNT

5830:
5831: else
5832:
5833: fa_debug_pkg.add(l_calling_fn, '##### bakcup table counter #####',
5834: fa_track_member_pvt.p_track_member_table_for_deprn.COUNT
5835: ,p_log_level_rec => p_log_level_rec);
5836:
5837: if not FA_TRACK_MEMBER_PVT.copy_member_table(p_backup_restore => 'RESTORE'
5838: ,p_log_level_rec => p_log_level_rec) then

Line 5837: if not FA_TRACK_MEMBER_PVT.copy_member_table(p_backup_restore => 'RESTORE'

5833: fa_debug_pkg.add(l_calling_fn, '##### bakcup table counter #####',
5834: fa_track_member_pvt.p_track_member_table_for_deprn.COUNT
5835: ,p_log_level_rec => p_log_level_rec);
5836:
5837: if not FA_TRACK_MEMBER_PVT.copy_member_table(p_backup_restore => 'RESTORE'
5838: ,p_log_level_rec => p_log_level_rec) then
5839: if (p_log_level_rec.statement_level) then
5840: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'COPY_MEMBER_TABLE'
5841: ,p_log_level_rec => p_log_level_rec);

Line 5847: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE

5843: raise calc_failed;
5844: end if;
5845:
5846: --* Calculate only for this period
5847: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE
5848: (p_asset_hdr_rec => p_asset_hdr_rec,
5849: p_asset_fin_rec_new => px_asset_fin_rec_new,
5850: p_populate_for_recalc_period => 'Y',
5851: p_amort_start_date => l_transaction_date_entered,

Line 5865: fa_track_member_pvt.l_process_deprn_for_member := 'NO';

5861: raise calc_failed;
5862: end if;
5863:
5864: l_processed_flag := TRUE;
5865: fa_track_member_pvt.l_process_deprn_for_member := 'NO';
5866:
5867: end if; -- IF not (l_backup_processed_flag)
5868:
5869: end if; -- l_first_process_flag

Line 5986: fa_track_member_pvt.l_process_deprn_for_member := 'YES';

5982:
5983: --* HHIRAGA - Tracking Test
5984:
5985: if (l_processed_flag) then
5986: fa_track_member_pvt.l_process_deprn_for_member := 'YES';
5987: l_processed_flag := FALSE;
5988: end if;
5989:
5990: -- bug #5768759 changes start here

Line 6232: if not FA_TRACK_MEMBER_PVT.member_eofy_rsv(p_asset_hdr_rec => p_asset_hdr_rec,

6228: -- HHIRAGA
6229: --+++++++++ Call member level maintenance for tracking +++++++
6230: if nvl(px_asset_fin_rec_new.tracking_method,'OTHER') = 'ALLOCATE' then
6231:
6232: if not FA_TRACK_MEMBER_PVT.member_eofy_rsv(p_asset_hdr_rec => p_asset_hdr_rec,
6233: p_dpr_in => l_dpr_in,
6234: p_mrc_sob_type_code => p_mrc_sob_type_code
6235: ,p_log_level_rec => p_log_level_rec) then
6236: if (p_log_level_rec.statement_level) then

Line 6238: 'FA_TRACK_MEMBER_PVT.member_eofy_rsv'

6234: p_mrc_sob_type_code => p_mrc_sob_type_code
6235: ,p_log_level_rec => p_log_level_rec) then
6236: if (p_log_level_rec.statement_level) then
6237: fa_debug_pkg.add(l_calling_fn, 'Error calling',
6238: 'FA_TRACK_MEMBER_PVT.member_eofy_rsv'
6239: ,p_log_level_rec => p_log_level_rec);
6240: end if;
6241:
6242: raise calc_failed;

Line 6248: fa_track_member_pvt.p_track_member_table.COUNT

6244: end if;
6245:
6246: if (p_log_level_rec.statement_level) then
6247: fa_debug_pkg.add(l_calling_fn, '###### Copy to backup #######',
6248: fa_track_member_pvt.p_track_member_table.COUNT
6249: ,p_log_level_rec => p_log_level_rec);
6250: end if;
6251:
6252: fa_debug_pkg.add(l_calling_fn, '##### bakcup table counter #####',

Line 6253: fa_track_member_pvt.p_track_member_table_for_deprn.COUNT

6249: ,p_log_level_rec => p_log_level_rec);
6250: end if;
6251:
6252: fa_debug_pkg.add(l_calling_fn, '##### bakcup table counter #####',
6253: fa_track_member_pvt.p_track_member_table_for_deprn.COUNT
6254: ,p_log_level_rec => p_log_level_rec);
6255:
6256: if not FA_TRACK_MEMBER_PVT.copy_member_table(p_backup_restore => 'BACKUP',
6257: p_current_fiscal_year => l_dpr_in.y_begin,

Line 6256: if not FA_TRACK_MEMBER_PVT.copy_member_table(p_backup_restore => 'BACKUP',

6252: fa_debug_pkg.add(l_calling_fn, '##### bakcup table counter #####',
6253: fa_track_member_pvt.p_track_member_table_for_deprn.COUNT
6254: ,p_log_level_rec => p_log_level_rec);
6255:
6256: if not FA_TRACK_MEMBER_PVT.copy_member_table(p_backup_restore => 'BACKUP',
6257: p_current_fiscal_year => l_dpr_in.y_begin,
6258: p_current_period_num => l_dpr_in.p_cl_begin
6259: ,p_log_level_rec => p_log_level_rec) then
6260: if (p_log_level_rec.statement_level) then

Line 6269: fa_debug_pkg.add(l_calling_fn, '++++ FA_TRACK_MEMBER_PVT.MEMBER_EOFY_RSV +++', '++++'

6265: end if;
6266: l_backup_processed_flag := TRUE;
6267:
6268: if (p_log_level_rec.statement_level) then
6269: fa_debug_pkg.add(l_calling_fn, '++++ FA_TRACK_MEMBER_PVT.MEMBER_EOFY_RSV +++', '++++'
6270: ,p_log_level_rec => p_log_level_rec);
6271: fa_debug_pkg.add(l_calling_fn, 'Copied p_track_member_table to bakcup area', '++++'
6272: ,p_log_level_rec => p_log_level_rec);
6273: end if;

Line 6495: if not FA_TRACK_MEMBER_PVT.update_member_books(p_trans_rec=> p_trans_rec,

6491: -- HHIRAGA
6492: --+++++++++ Call member level maintenance for tracking +++++++
6493: if nvl(px_asset_fin_rec_new.tracking_method,'OTHER') = 'ALLOCATE' then
6494:
6495: if not FA_TRACK_MEMBER_PVT.update_member_books(p_trans_rec=> p_trans_rec,
6496: p_asset_hdr_rec => p_asset_hdr_rec,
6497: p_dpr_in => l_dpr_in,
6498: p_mrc_sob_type_code => p_mrc_sob_type_code
6499: ,p_log_level_rec => p_log_level_rec) then

Line 6502: 'FA_TRACK_MEMBER_PVT.update_member_books'

6498: p_mrc_sob_type_code => p_mrc_sob_type_code
6499: ,p_log_level_rec => p_log_level_rec) then
6500: if (p_log_level_rec.statement_level) then
6501: fa_debug_pkg.add(l_calling_fn, 'Error calling',
6502: 'FA_TRACK_MEMBER_PVT.update_member_books'
6503: ,p_log_level_rec => p_log_level_rec);
6504: end if;
6505:
6506: raise calc_failed;

Line 6509: fa_track_member_pvt.p_track_member_eofy_table.delete;

6505:
6506: raise calc_failed;
6507: end if;
6508:
6509: fa_track_member_pvt.p_track_member_eofy_table.delete;
6510:
6511: if (p_log_level_rec.statement_level) then
6512: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table',
6513: 'deleted'

Line 6512: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table',

6508:
6509: fa_track_member_pvt.p_track_member_eofy_table.delete;
6510:
6511: if (p_log_level_rec.statement_level) then
6512: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table',
6513: 'deleted'
6514: ,p_log_level_rec => p_log_level_rec);
6515: end if;
6516: -- HHIRAGA debug

Line 6517: for i in 1.. fa_track_member_pvt.p_track_member_table.count loop

6513: 'deleted'
6514: ,p_log_level_rec => p_log_level_rec);
6515: end if;
6516: -- HHIRAGA debug
6517: for i in 1.. fa_track_member_pvt.p_track_member_table.count loop
6518: fa_debug_pkg.add('HH DEBUG**', 'all records in p_track_member_table', i
6519: ,p_log_level_rec => p_log_level_rec);
6520: if not fa_track_member_pvt.display_debug_message2(i, 'HH DEBUG**') then
6521: null;

Line 6520: if not fa_track_member_pvt.display_debug_message2(i, 'HH DEBUG**') then

6516: -- HHIRAGA debug
6517: for i in 1.. fa_track_member_pvt.p_track_member_table.count loop
6518: fa_debug_pkg.add('HH DEBUG**', 'all records in p_track_member_table', i
6519: ,p_log_level_rec => p_log_level_rec);
6520: if not fa_track_member_pvt.display_debug_message2(i, 'HH DEBUG**') then
6521: null;
6522: end if;
6523: end loop;
6524:

Line 6531: if not FA_TRACK_MEMBER_PVT.create_update_bs_table(p_trans_rec => p_trans_rec,

6527: -- HHIRAGA
6528: --+++++++++ Call member level maintenance for tracking +++++++
6529: if nvl(px_asset_fin_rec_new.tracking_method,'OTHER') = 'ALLOCATE' then
6530:
6531: if not FA_TRACK_MEMBER_PVT.create_update_bs_table(p_trans_rec => p_trans_rec,
6532: p_book_type_code => p_asset_hdr_rec.book_type_code,
6533: p_group_asset_id => p_asset_hdr_rec.asset_id,
6534: p_calling_fn => l_calling_fn
6535: ,p_log_level_rec => p_log_level_rec) then

Line 6538: 'FA_TRACK_MEMBER_PVT.create_update_bs_table'

6534: p_calling_fn => l_calling_fn
6535: ,p_log_level_rec => p_log_level_rec) then
6536: if (p_log_level_rec.statement_level) then
6537: fa_debug_pkg.add(l_calling_fn, 'Error calling',
6538: 'FA_TRACK_MEMBER_PVT.create_update_bs_table'
6539: ,p_log_level_rec => p_log_level_rec);
6540: end if;
6541:
6542: raise calc_failed;

Line 13349: if not FA_TRACK_MEMBER_PVT.get_member_at_start(

13345:
13346: --+++++++ Call Tracking Function to populate Member in case ALLOCATE ++++++
13347: if nvl(l_dpr_in.tracking_method,'OTHER') = 'ALLOCATE' then
13348: /*
13349: if not FA_TRACK_MEMBER_PVT.get_member_at_start(
13350: p_trans_rec => l_trans_rec,
13351: p_asset_hdr_rec => p_asset_hdr_rec,
13352: p_dpr_in => l_dpr_in,
13353: p_mrc_sob_type_code => p_mrc_sob_type_code

Line 13357: 'FA_TRACK_MEMBER_PVT.get_member_at_start'

13353: p_mrc_sob_type_code => p_mrc_sob_type_code
13354: ,p_log_level_rec => p_log_level_rec) then
13355: if (p_log_level_rec.statement_level) then
13356: fa_debug_pkg.add(l_calling_fn, 'Error calling',
13357: 'FA_TRACK_MEMBER_PVT.get_member_at_start'
13358: ,p_log_level_rec => p_log_level_rec);
13359: end if;
13360:
13361: raise calc_failed;

Line 13423: fa_track_member_pvt.p_track_member_table.delete;

13419:
13420: --++++++++ Tracking=ALLOCATE case ++++++++++++++
13421: if nvl(l_dpr_in.tracking_method,'OTHER') = 'ALLOCATE' then
13422:
13423: fa_track_member_pvt.p_track_member_table.delete;
13424:
13425: if (p_log_level_rec.statement_level) then
13426: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_table',
13427: 'deleted'

Line 13426: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_table',

13422:
13423: fa_track_member_pvt.p_track_member_table.delete;
13424:
13425: if (p_log_level_rec.statement_level) then
13426: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_table',
13427: 'deleted'
13428: ,p_log_level_rec => p_log_level_rec);
13429: end if;
13430: end if;

Line 13951: if not FA_TRACK_MEMBER_PVT.member_eofy_rsv(p_asset_hdr_rec => p_asset_hdr_rec,

13947:
13948: --+++++++++ Call member level maintenance for tracking +++++++
13949: if nvl(px_asset_fin_rec_new.tracking_method,'OTHER') = 'ALLOCATE' then
13950:
13951: if not FA_TRACK_MEMBER_PVT.member_eofy_rsv(p_asset_hdr_rec => p_asset_hdr_rec,
13952: p_dpr_in => l_dpr_in,
13953: p_mrc_sob_type_code => p_mrc_sob_type_code
13954: ,p_log_level_rec => p_log_level_rec) then
13955: if (p_log_level_rec.statement_level) then

Line 13957: 'FA_TRACK_MEMBER_PVT.member_eofy_rsv'

13953: p_mrc_sob_type_code => p_mrc_sob_type_code
13954: ,p_log_level_rec => p_log_level_rec) then
13955: if (p_log_level_rec.statement_level) then
13956: fa_debug_pkg.add(l_calling_fn, 'Error calling',
13957: 'FA_TRACK_MEMBER_PVT.member_eofy_rsv'
13958: ,p_log_level_rec => p_log_level_rec);
13959: end if;
13960:
13961: raise calc_failed;

Line 14238: if not FA_TRACK_MEMBER_PVT.update_member_books(p_trans_rec=> p_trans_rec,

14234:
14235: --+++++++++ Call member level maintenance for tracking +++++++
14236: if nvl(px_asset_fin_rec_new.tracking_method,'OTHER') = 'ALLOCATE' then
14237:
14238: if not FA_TRACK_MEMBER_PVT.update_member_books(p_trans_rec=> p_trans_rec,
14239: p_asset_hdr_rec => p_asset_hdr_rec,
14240: p_dpr_in => l_dpr_in,
14241: p_mrc_sob_type_code => p_mrc_sob_type_code
14242: ,p_log_level_rec => p_log_level_rec) then

Line 14245: 'FA_TRACK_MEMBER_PVT.update_member_books'

14241: p_mrc_sob_type_code => p_mrc_sob_type_code
14242: ,p_log_level_rec => p_log_level_rec) then
14243: if (p_log_level_rec.statement_level) then
14244: fa_debug_pkg.add(l_calling_fn, 'Error calling',
14245: 'FA_TRACK_MEMBER_PVT.update_member_books'
14246: ,p_log_level_rec => p_log_level_rec);
14247: end if;
14248:
14249: raise calc_failed;

Line 14252: fa_track_member_pvt.p_track_member_eofy_table.delete;

14248:
14249: raise calc_failed;
14250: end if;
14251:
14252: fa_track_member_pvt.p_track_member_eofy_table.delete;
14253:
14254: if (p_log_level_rec.statement_level) then
14255: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table',
14256: 'deleted'

Line 14255: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table',

14251:
14252: fa_track_member_pvt.p_track_member_eofy_table.delete;
14253:
14254: if (p_log_level_rec.statement_level) then
14255: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table',
14256: 'deleted'
14257: ,p_log_level_rec => p_log_level_rec);
14258: end if;
14259:

Line 15900: if not FA_TRACK_MEMBER_PVT.get_member_at_start(

15896: l_raf_processed_flag := TRUE;
15897: l_dpr_in.tracking_method := NULL;
15898:
15899: /*
15900: if not FA_TRACK_MEMBER_PVT.get_member_at_start(
15901: p_period_rec => l_period_rec,
15902: p_trans_rec => p_trans_rec,
15903: p_asset_hdr_rec => p_asset_hdr_rec,
15904: p_asset_fin_rec => px_asset_fin_rec_new,

Line 15909: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'FA_TRACK_MEMBER_PVT.get_member_at_start'

15905: p_dpr_in => l_dpr_in,
15906: p_mrc_sob_type_code => p_mrc_sob_type_code
15907: ,p_log_level_rec => p_log_level_rec) then
15908: if (p_log_level_rec.statement_level) then
15909: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'FA_TRACK_MEMBER_PVT.get_member_at_start'
15910: ,p_log_level_rec => p_log_level_rec);
15911: end if;
15912:
15913: raise calc_failed;

Line 16013: fa_track_member_pvt.p_track_member_table.delete;

16009:
16010: -- HHIRAGA
16011: --+++++++ Call Populate_member_assets_table function
16012: if nvl(l_dpr_in.tracking_method,'OTHER') = 'ALLOCATE' then
16013: fa_track_member_pvt.p_track_member_table.delete;
16014: if (p_log_level_rec.statement_level) then
16015: fa_debug_pkg.add(l_calling_fn, 'Delete p_track_member_table', '+++'
16016: ,p_log_level_rec => p_log_level_rec);
16017: end if;

Line 16080: if not FA_TRACK_MEMBER_PVT.update_member_books(p_trans_rec => p_trans_rec,

16076: --++ HHIRAGA
16077: --++++++++ tracking is allocate case, create bs table
16078: if nvl(px_asset_fin_rec_new.tracking_method,'OTHER') = 'ALLOCATE' then
16079:
16080: if not FA_TRACK_MEMBER_PVT.update_member_books(p_trans_rec => p_trans_rec,
16081: p_asset_hdr_rec => p_asset_hdr_rec,
16082: p_dpr_in => l_dpr_in,
16083: p_mrc_sob_type_code => p_mrc_sob_type_code
16084: ,p_log_level_rec => p_log_level_rec) then

Line 16087: 'FA_TRACK_MEMBER_PVT.update_member_books'

16083: p_mrc_sob_type_code => p_mrc_sob_type_code
16084: ,p_log_level_rec => p_log_level_rec) then
16085: if (p_log_level_rec.statement_level) then
16086: fa_debug_pkg.add(l_calling_fn, 'Error calling',
16087: 'FA_TRACK_MEMBER_PVT.update_member_books'
16088: ,p_log_level_rec => p_log_level_rec);
16089: end if;
16090:
16091: raise calc_err;

Line 16095: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.create_update_bs_table',

16091: raise calc_err;
16092: end if;
16093:
16094: if (p_log_level_rec.statement_level) then
16095: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.create_update_bs_table',
16096: 'called'
16097: ,p_log_level_rec => p_log_level_rec);
16098: end if;
16099:

Line 16100: if not FA_TRACK_MEMBER_PVT.create_update_bs_table(p_trans_rec => p_trans_rec,

16096: 'called'
16097: ,p_log_level_rec => p_log_level_rec);
16098: end if;
16099:
16100: if not FA_TRACK_MEMBER_PVT.create_update_bs_table(p_trans_rec => p_trans_rec,
16101: p_book_type_code => p_asset_hdr_rec.book_type_code,
16102: p_group_asset_id => p_asset_hdr_rec.asset_id,
16103: p_calling_fn => l_calling_fn
16104: ,p_log_level_rec => p_log_level_rec) then

Line 16107: 'FA_TRACK_MEMBER_PVT.create_update_bs_table'

16103: p_calling_fn => l_calling_fn
16104: ,p_log_level_rec => p_log_level_rec) then
16105: if (p_log_level_rec.statement_level) then
16106: fa_debug_pkg.add(l_calling_fn, 'Error calling',
16107: 'FA_TRACK_MEMBER_PVT.create_update_bs_table'
16108: ,p_log_level_rec => p_log_level_rec);
16109: end if;
16110:
16111: raise calc_err;

Line 16114: fa_track_member_pvt.p_track_member_eofy_table.delete;

16110:
16111: raise calc_err;
16112: end if;
16113:
16114: fa_track_member_pvt.p_track_member_eofy_table.delete;
16115: fa_track_member_pvt.p_track_member_table.delete;
16116:
16117: if (p_log_level_rec.statement_level) then
16118: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table/member_table',

Line 16115: fa_track_member_pvt.p_track_member_table.delete;

16111: raise calc_err;
16112: end if;
16113:
16114: fa_track_member_pvt.p_track_member_eofy_table.delete;
16115: fa_track_member_pvt.p_track_member_table.delete;
16116:
16117: if (p_log_level_rec.statement_level) then
16118: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table/member_table',
16119: 'deleted'

Line 16118: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table/member_table',

16114: fa_track_member_pvt.p_track_member_eofy_table.delete;
16115: fa_track_member_pvt.p_track_member_table.delete;
16116:
16117: if (p_log_level_rec.statement_level) then
16118: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table/member_table',
16119: 'deleted'
16120: ,p_log_level_rec => p_log_level_rec);
16121: end if;
16122: