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 4060: -- defined in FA_TRACK_MEMBER_PVT.

4056: -- setup and user specified reclassification date (amort date) is
4057: -- in the current open period, system don't need to recalculate from
4058: -- DPIS of the member asset to reclassify but jut get stored reserve,
4059: -- YTD Depreciation and EOFY Reserve from table using populate_member_reserve function
4060: -- defined in FA_TRACK_MEMBER_PVT.
4061: --
4062: -- Initialize global variables
4063: g_mem_asset_id := nvl(p_reclassed_asset_id, 0);
4064: g_mem_ytd_deprn := 0;

Line 4166: if not FA_TRACK_MEMBER_PVT.populate_member_reserve

4162: if nvl(px_asset_fin_rec_new.tracking_method,'NULL') = 'CALCULATE' and
4163: l_trx_period_rec.period_counter = l_current_period_counter then
4164:
4165: -- Call populate_member_reserve
4166: if not FA_TRACK_MEMBER_PVT.populate_member_reserve
4167: (p_trans_rec => p_trans_rec,
4168: p_asset_hdr_rec => p_asset_hdr_rec,
4169: p_asset_fin_rec_new => px_asset_fin_rec_new,
4170: p_mrc_sob_type_code => p_mrc_sob_type_code,

Line 5689: if not FA_TRACK_MEMBER_PVT.get_member_at_start(

5685: l_raf_processed_flag := TRUE;
5686: l_dpr_in.tracking_method := NULL;
5687:
5688: /*
5689: if not FA_TRACK_MEMBER_PVT.get_member_at_start(
5690: p_period_rec => l_period_rec,
5691: p_trans_rec => p_trans_rec,
5692: p_asset_hdr_rec => p_asset_hdr_rec,
5693: p_asset_fin_rec => px_asset_fin_rec_new,

Line 5697: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'FA_TRACK_MEMBER_PVT.get_member_at_start', p_log_level_rec => p_log_level_rec);

5693: p_asset_fin_rec => px_asset_fin_rec_new,
5694: p_dpr_in => l_dpr_in,
5695: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
5696: if (p_log_level_rec.statement_level) then
5697: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'FA_TRACK_MEMBER_PVT.get_member_at_start', p_log_level_rec => p_log_level_rec);
5698: end if;
5699:
5700: raise calc_failed;
5701:

Line 5762: fa_track_member_pvt.p_track_member_table.delete;

5758: end if;
5759:
5760: if nvl(l_dpr_in.tracking_method,'OTHER') = 'ALLOCATE' then
5761:
5762: fa_track_member_pvt.p_track_member_table.delete;
5763: fa_track_member_pvt.p_track_mem_index_table.delete;
5764:
5765: if (p_log_level_rec.statement_level) then
5766: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_table',

Line 5763: fa_track_member_pvt.p_track_mem_index_table.delete;

5759:
5760: if nvl(l_dpr_in.tracking_method,'OTHER') = 'ALLOCATE' then
5761:
5762: fa_track_member_pvt.p_track_member_table.delete;
5763: fa_track_member_pvt.p_track_mem_index_table.delete;
5764:
5765: if (p_log_level_rec.statement_level) then
5766: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_table',
5767: 'deleted', p_log_level_rec => p_log_level_rec);

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

5762: fa_track_member_pvt.p_track_member_table.delete;
5763: fa_track_member_pvt.p_track_mem_index_table.delete;
5764:
5765: if (p_log_level_rec.statement_level) then
5766: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_table',
5767: 'deleted', p_log_level_rec => p_log_level_rec);
5768: end if;
5769: end if;
5770: end if;

Line 5821: fa_debug_pkg.add(l_calling_fn, '++++ Call ++++', 'FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE', p_log_level_rec => p_log_level_rec);

5817: l_recalc_start_period_num := fa_amort_pvt.t_period_num(i) - 1;
5818: end if;
5819:
5820: if (p_log_level_rec.statement_level) then
5821: fa_debug_pkg.add(l_calling_fn, '++++ Call ++++', 'FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE', p_log_level_rec => p_log_level_rec);
5822: fa_debug_pkg.add(l_calling_fn, 'fa_amort_pvt.t_reset_adjusted_cost_flag(i)',
5823: fa_amort_pvt.t_reset_adjusted_cost_flag(i));
5824: fa_debug_pkg.add(l_calling_fn, 'l_recalc_start_fy', l_recalc_start_fy, p_log_level_rec => p_log_level_rec);
5825: fa_debug_pkg.add(l_calling_fn, 'l_recalc_start_period_num', l_recalc_start_period_num, p_log_level_rec => p_log_level_rec);

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

5840: l_recalc_start_fy := fa_amort_pvt.t_fiscal_year(i);
5841: l_recalc_start_period_num := fa_amort_pvt.t_period_num(i);
5842:
5843: l_processed_flag := TRUE;
5844: fa_track_member_pvt.l_process_deprn_for_member := 'NO';
5845: /*
5846: l_asset_fin_rec_new.tracking_method := NULL;
5847: l_asset_fin_rec_old.tracking_method := NULL;
5848: */

Line 5851: fa_debug_pkg.add(l_calling_fn, '++++ Call ++++', 'FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE', p_log_level_rec => p_log_level_rec);

5847: l_asset_fin_rec_old.tracking_method := NULL;
5848: */
5849:
5850: if (p_log_level_rec.statement_level) then
5851: fa_debug_pkg.add(l_calling_fn, '++++ Call ++++', 'FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE', p_log_level_rec => p_log_level_rec);
5852: fa_debug_pkg.add(l_calling_fn, 'fa_amort_pvt.t_reset_adjusted_cost_flag(i)',
5853: fa_amort_pvt.t_reset_adjusted_cost_flag(i));
5854: fa_debug_pkg.add(l_calling_fn, 'l_recalc_start_fy', l_recalc_start_fy, p_log_level_rec => p_log_level_rec);
5855: fa_debug_pkg.add(l_calling_fn, 'l_recalc_start_period_num', l_recalc_start_period_num, p_log_level_rec => p_log_level_rec);

Line 5885: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE

5881: if p_mrc_sob_type_code <> 'R' then
5882: open c_chk_bs_row_exists;
5883: fetch c_chk_bs_row_exists into l_chk_bs_row_exists;
5884: if c_chk_bs_row_exists%FOUND then
5885: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE
5886: (p_trans_rec=>p_trans_rec,
5887: p_asset_hdr_rec => p_asset_hdr_rec,
5888: p_asset_fin_rec_new => px_asset_fin_rec_new,
5889: p_populate_for_recalc_period => 'T',

Line 5901: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE

5897: end if;
5898: raise calc_failed;
5899: end if;
5900: else
5901: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE
5902: (p_trans_rec=>p_trans_rec,
5903: p_asset_hdr_rec => p_asset_hdr_rec,
5904: p_asset_fin_rec_new => px_asset_fin_rec_new,
5905: p_amort_start_date => l_transaction_date_entered,

Line 5923: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE

5919:
5920: open c_chk_bs_row_exists_mrc;
5921: fetch c_chk_bs_row_exists_mrc into l_chk_bs_row_exists;
5922: if c_chk_bs_row_exists_mrc%FOUND then
5923: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE
5924: (p_trans_rec=>p_trans_rec,
5925: p_asset_hdr_rec => p_asset_hdr_rec,
5926: p_asset_fin_rec_new => px_asset_fin_rec_new,
5927: p_populate_for_recalc_period => 'T',

Line 5939: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE

5935: end if;
5936: raise calc_failed;
5937: end if;
5938: else
5939: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE
5940: (p_trans_rec=>p_trans_rec,
5941: p_asset_hdr_rec => p_asset_hdr_rec,
5942: p_asset_fin_rec_new => px_asset_fin_rec_new,
5943: p_amort_start_date => l_transaction_date_entered,

Line 5965: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE

5961: l_old_recalc_start_fy := l_recalc_start_fy;
5962: l_old_recalc_start_period_num := l_recalc_start_period_num;
5963:
5964: if not (l_backup_processed_flag) then
5965: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE
5966: (p_trans_rec=>p_trans_rec,
5967: p_asset_hdr_rec => p_asset_hdr_rec,
5968: p_asset_fin_rec_new => px_asset_fin_rec_new,
5969: p_amort_start_date => l_transaction_date_entered,

Line 5984: fa_track_member_pvt.p_track_member_table_for_deprn.COUNT, p_log_level_rec => p_log_level_rec);

5980: else
5981:
5982: if (p_log_level_rec.statement_level) then
5983: fa_debug_pkg.add(l_calling_fn, '##### bakcup table counter #####',
5984: fa_track_member_pvt.p_track_member_table_for_deprn.COUNT, p_log_level_rec => p_log_level_rec);
5985: end if;
5986:
5987: if not FA_TRACK_MEMBER_PVT.copy_member_table(p_backup_restore => 'RESTORE', p_log_level_rec => p_log_level_rec) then
5988: if (p_log_level_rec.statement_level) then

Line 5987: if not FA_TRACK_MEMBER_PVT.copy_member_table(p_backup_restore => 'RESTORE', p_log_level_rec => p_log_level_rec) then

5983: fa_debug_pkg.add(l_calling_fn, '##### bakcup table counter #####',
5984: fa_track_member_pvt.p_track_member_table_for_deprn.COUNT, p_log_level_rec => p_log_level_rec);
5985: end if;
5986:
5987: if not FA_TRACK_MEMBER_PVT.copy_member_table(p_backup_restore => 'RESTORE', p_log_level_rec => p_log_level_rec) then
5988: if (p_log_level_rec.statement_level) then
5989: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'COPY_MEMBER_TABLE', p_log_level_rec => p_log_level_rec);
5990: end if;
5991: raise calc_failed;

Line 5995: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE

5991: raise calc_failed;
5992: end if;
5993:
5994: --* Calculate only for this period
5995: if not FA_TRACK_MEMBER_PVT.POPULATE_MEMBER_ASSETS_TABLE
5996: (p_trans_rec=>p_trans_rec,
5997: p_asset_hdr_rec => p_asset_hdr_rec,
5998: p_asset_fin_rec_new => px_asset_fin_rec_new,
5999: p_populate_for_recalc_period => 'Y',

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

6008: raise calc_failed;
6009: end if;
6010:
6011: l_processed_flag := TRUE;
6012: fa_track_member_pvt.l_process_deprn_for_member := 'NO';
6013:
6014: end if; -- IF not (l_backup_processed_flag)
6015:
6016: end if; -- l_first_process_flag

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

6125:
6126: --* HHIRAGA - Tracking Test
6127:
6128: if (l_processed_flag) then
6129: fa_track_member_pvt.l_process_deprn_for_member := 'YES';
6130: l_processed_flag := FALSE;
6131: end if;
6132:
6133: --

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

6353: -- HHIRAGA
6354: --+++++++++ Call member level maintenance for tracking +++++++
6355: if nvl(px_asset_fin_rec_new.tracking_method,'OTHER') = 'ALLOCATE' then
6356:
6357: if not FA_TRACK_MEMBER_PVT.member_eofy_rsv(p_asset_hdr_rec => p_asset_hdr_rec,
6358: p_dpr_in => l_dpr_in,
6359: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
6360: if (p_log_level_rec.statement_level) then
6361: fa_debug_pkg.add(l_calling_fn, 'Error calling',

Line 6362: 'FA_TRACK_MEMBER_PVT.member_eofy_rsv', p_log_level_rec => p_log_level_rec);

6358: p_dpr_in => l_dpr_in,
6359: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
6360: if (p_log_level_rec.statement_level) then
6361: fa_debug_pkg.add(l_calling_fn, 'Error calling',
6362: 'FA_TRACK_MEMBER_PVT.member_eofy_rsv', p_log_level_rec => p_log_level_rec);
6363: end if;
6364:
6365: raise calc_failed;
6366:

Line 6371: fa_track_member_pvt.p_track_member_table.COUNT, p_log_level_rec => p_log_level_rec);

6367: end if;
6368:
6369: if (p_log_level_rec.statement_level) then
6370: fa_debug_pkg.add(l_calling_fn, '###### Copy to backup #######',
6371: fa_track_member_pvt.p_track_member_table.COUNT, p_log_level_rec => p_log_level_rec);
6372: end if;
6373:
6374: if (p_log_level_rec.statement_level) then
6375: fa_debug_pkg.add(l_calling_fn, '##### bakcup table counter #####',

Line 6376: fa_track_member_pvt.p_track_member_table_for_deprn.COUNT, p_log_level_rec => p_log_level_rec);

6372: end if;
6373:
6374: if (p_log_level_rec.statement_level) then
6375: fa_debug_pkg.add(l_calling_fn, '##### bakcup table counter #####',
6376: fa_track_member_pvt.p_track_member_table_for_deprn.COUNT, p_log_level_rec => p_log_level_rec);
6377: end if;
6378:
6379: if not FA_TRACK_MEMBER_PVT.copy_member_table(p_backup_restore => 'BACKUP',
6380: p_current_fiscal_year => l_dpr_in.y_begin,

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

6375: fa_debug_pkg.add(l_calling_fn, '##### bakcup table counter #####',
6376: fa_track_member_pvt.p_track_member_table_for_deprn.COUNT, p_log_level_rec => p_log_level_rec);
6377: end if;
6378:
6379: if not FA_TRACK_MEMBER_PVT.copy_member_table(p_backup_restore => 'BACKUP',
6380: p_current_fiscal_year => l_dpr_in.y_begin,
6381: p_current_period_num => l_dpr_in.p_cl_begin, p_log_level_rec => p_log_level_rec) then
6382: if (p_log_level_rec.statement_level) then
6383: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'COPY_MEMBER_TABLE', p_log_level_rec => p_log_level_rec);

Line 6390: fa_debug_pkg.add(l_calling_fn, '++++ FA_TRACK_MEMBER_PVT.MEMBER_EOFY_RSV +++', '++++', p_log_level_rec => p_log_level_rec);

6386: end if;
6387: l_backup_processed_flag := TRUE;
6388:
6389: if (p_log_level_rec.statement_level) then
6390: fa_debug_pkg.add(l_calling_fn, '++++ FA_TRACK_MEMBER_PVT.MEMBER_EOFY_RSV +++', '++++', p_log_level_rec => p_log_level_rec);
6391: fa_debug_pkg.add(l_calling_fn, 'Copied p_track_member_table to bakcup area', '++++', p_log_level_rec => p_log_level_rec);
6392: end if;
6393:
6394: end if; -- nvl(px_asset_fin_rec_new.tracking_method,'OTHER') = 'ALLOCATE'

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

6610: -- HHIRAGA
6611: --+++++++++ Call member level maintenance for tracking +++++++
6612: if nvl(px_asset_fin_rec_new.tracking_method,'OTHER') = 'ALLOCATE' then
6613:
6614: if not FA_TRACK_MEMBER_PVT.update_member_books(p_trans_rec=> p_trans_rec,
6615: p_asset_hdr_rec => p_asset_hdr_rec,
6616: p_dpr_in => l_dpr_in,
6617: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
6618: if (p_log_level_rec.statement_level) then

Line 6620: 'FA_TRACK_MEMBER_PVT.update_member_books', p_log_level_rec => p_log_level_rec);

6616: p_dpr_in => l_dpr_in,
6617: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
6618: if (p_log_level_rec.statement_level) then
6619: fa_debug_pkg.add(l_calling_fn, 'Error calling',
6620: 'FA_TRACK_MEMBER_PVT.update_member_books', p_log_level_rec => p_log_level_rec);
6621: end if;
6622:
6623: raise calc_failed;
6624: end if;

Line 6626: fa_track_member_pvt.p_track_member_eofy_table.delete;

6622:
6623: raise calc_failed;
6624: end if;
6625:
6626: fa_track_member_pvt.p_track_member_eofy_table.delete;
6627:
6628: if (p_log_level_rec.statement_level) then
6629: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table',
6630: 'deleted', p_log_level_rec => p_log_level_rec);

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

6625:
6626: fa_track_member_pvt.p_track_member_eofy_table.delete;
6627:
6628: if (p_log_level_rec.statement_level) then
6629: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table',
6630: 'deleted', p_log_level_rec => p_log_level_rec);
6631: end if;
6632:
6633: if (p_log_level_rec.statement_level) then

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

6630: 'deleted', p_log_level_rec => p_log_level_rec);
6631: end if;
6632:
6633: if (p_log_level_rec.statement_level) then
6634: for i in 1.. fa_track_member_pvt.p_track_member_table.count loop
6635: fa_debug_pkg.add('HH DEBUG**', 'all records in p_track_member_table', i);
6636: if not fa_track_member_pvt.display_debug_message2(i, 'HH DEBUG**', p_log_leveL_rec) then
6637: null;
6638: end if;

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

6632:
6633: if (p_log_level_rec.statement_level) then
6634: for i in 1.. fa_track_member_pvt.p_track_member_table.count loop
6635: fa_debug_pkg.add('HH DEBUG**', 'all records in p_track_member_table', i);
6636: if not fa_track_member_pvt.display_debug_message2(i, 'HH DEBUG**', p_log_leveL_rec) then
6637: null;
6638: end if;
6639: end loop;
6640: end if;

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

6644: -- HHIRAGA
6645: --+++++++++ Call member level maintenance for tracking +++++++
6646: if nvl(px_asset_fin_rec_new.tracking_method,'OTHER') = 'ALLOCATE' then
6647:
6648: if not FA_TRACK_MEMBER_PVT.create_update_bs_table(p_trans_rec => p_trans_rec,
6649: p_book_type_code => p_asset_hdr_rec.book_type_code,
6650: p_group_asset_id => p_asset_hdr_rec.asset_id,
6651: p_mrc_sob_type_code => p_mrc_sob_type_code, --Bug 8941132
6652: p_sob_id => p_asset_hdr_rec.set_of_books_id, --Bug 8941132

Line 6656: 'FA_TRACK_MEMBER_PVT.create_update_bs_table', p_log_level_rec => p_log_level_rec);

6652: p_sob_id => p_asset_hdr_rec.set_of_books_id, --Bug 8941132
6653: p_calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec) then
6654: if (p_log_level_rec.statement_level) then
6655: fa_debug_pkg.add(l_calling_fn, 'Error calling',
6656: 'FA_TRACK_MEMBER_PVT.create_update_bs_table', p_log_level_rec => p_log_level_rec);
6657: end if;
6658:
6659: raise calc_failed;
6660: end if;

Line 14262: if not FA_TRACK_MEMBER_PVT.get_member_at_start(

14258:
14259: --+++++++ Call Tracking Function to populate Member in case ALLOCATE ++++++
14260: if nvl(l_dpr_in.tracking_method,'OTHER') = 'ALLOCATE' then
14261: /*
14262: if not FA_TRACK_MEMBER_PVT.get_member_at_start(
14263: p_trans_rec => l_trans_rec,
14264: p_asset_hdr_rec => p_asset_hdr_rec,
14265: p_dpr_in => l_dpr_in,
14266: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then

Line 14269: 'FA_TRACK_MEMBER_PVT.get_member_at_start', p_log_level_rec => p_log_level_rec);

14265: p_dpr_in => l_dpr_in,
14266: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
14267: if (p_log_level_rec.statement_level) then
14268: fa_debug_pkg.add(l_calling_fn, 'Error calling',
14269: 'FA_TRACK_MEMBER_PVT.get_member_at_start', p_log_level_rec => p_log_level_rec);
14270: end if;
14271:
14272: raise calc_failed;
14273:

Line 14363: fa_track_member_pvt.p_track_member_table.delete;

14359:
14360: --++++++++ Tracking=ALLOCATE case ++++++++++++++
14361: if nvl(l_dpr_in.tracking_method,'OTHER') = 'ALLOCATE' then
14362:
14363: fa_track_member_pvt.p_track_member_table.delete;
14364: fa_track_member_pvt.p_track_mem_index_table.delete;
14365:
14366: if (p_log_level_rec.statement_level) then
14367: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_table',

Line 14364: fa_track_member_pvt.p_track_mem_index_table.delete;

14360: --++++++++ Tracking=ALLOCATE case ++++++++++++++
14361: if nvl(l_dpr_in.tracking_method,'OTHER') = 'ALLOCATE' then
14362:
14363: fa_track_member_pvt.p_track_member_table.delete;
14364: fa_track_member_pvt.p_track_mem_index_table.delete;
14365:
14366: if (p_log_level_rec.statement_level) then
14367: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_table',
14368: 'deleted', p_log_level_rec => p_log_level_rec);

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

14363: fa_track_member_pvt.p_track_member_table.delete;
14364: fa_track_member_pvt.p_track_mem_index_table.delete;
14365:
14366: if (p_log_level_rec.statement_level) then
14367: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_table',
14368: 'deleted', p_log_level_rec => p_log_level_rec);
14369: end if;
14370: end if;
14371:

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

15016:
15017: --+++++++++ Call member level maintenance for tracking +++++++
15018: if nvl(px_asset_fin_rec_new.tracking_method,'OTHER') = 'ALLOCATE' then
15019:
15020: if not FA_TRACK_MEMBER_PVT.member_eofy_rsv(p_asset_hdr_rec => p_asset_hdr_rec,
15021: p_dpr_in => l_dpr_in,
15022: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
15023: if (p_log_level_rec.statement_level) then
15024: fa_debug_pkg.add(l_calling_fn, 'Error calling',

Line 15025: 'FA_TRACK_MEMBER_PVT.member_eofy_rsv', p_log_level_rec => p_log_level_rec);

15021: p_dpr_in => l_dpr_in,
15022: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
15023: if (p_log_level_rec.statement_level) then
15024: fa_debug_pkg.add(l_calling_fn, 'Error calling',
15025: 'FA_TRACK_MEMBER_PVT.member_eofy_rsv', p_log_level_rec => p_log_level_rec);
15026: end if;
15027:
15028: raise calc_failed;
15029:

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

15353:
15354: --+++++++++ Call member level maintenance for tracking +++++++
15355: if nvl(px_asset_fin_rec_new.tracking_method,'OTHER') = 'ALLOCATE' then
15356:
15357: if not FA_TRACK_MEMBER_PVT.update_member_books(p_trans_rec=> p_trans_rec,
15358: p_asset_hdr_rec => p_asset_hdr_rec,
15359: p_dpr_in => l_dpr_in,
15360: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
15361: if (p_log_level_rec.statement_level) then

Line 15363: 'FA_TRACK_MEMBER_PVT.update_member_books', p_log_level_rec => p_log_level_rec);

15359: p_dpr_in => l_dpr_in,
15360: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
15361: if (p_log_level_rec.statement_level) then
15362: fa_debug_pkg.add(l_calling_fn, 'Error calling',
15363: 'FA_TRACK_MEMBER_PVT.update_member_books', p_log_level_rec => p_log_level_rec);
15364: end if;
15365:
15366: raise calc_failed;
15367: end if;

Line 15369: fa_track_member_pvt.p_track_member_eofy_table.delete;

15365:
15366: raise calc_failed;
15367: end if;
15368:
15369: fa_track_member_pvt.p_track_member_eofy_table.delete;
15370:
15371: if (p_log_level_rec.statement_level) then
15372: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table',
15373: 'deleted', p_log_level_rec => p_log_level_rec);

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

15368:
15369: fa_track_member_pvt.p_track_member_eofy_table.delete;
15370:
15371: if (p_log_level_rec.statement_level) then
15372: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table',
15373: 'deleted', p_log_level_rec => p_log_level_rec);
15374: end if;
15375:
15376: end if; -- nvl(px_asset_fin_rec_new.tracking_method,'OTHER') = 'ALLOCATE'

Line 17036: if not FA_TRACK_MEMBER_PVT.get_member_at_start(

17032: l_raf_processed_flag := TRUE;
17033: l_dpr_in.tracking_method := NULL;
17034:
17035: /*
17036: if not FA_TRACK_MEMBER_PVT.get_member_at_start(
17037: p_period_rec => l_period_rec,
17038: p_trans_rec => p_trans_rec,
17039: p_asset_hdr_rec => p_asset_hdr_rec,
17040: p_asset_fin_rec => px_asset_fin_rec_new,

Line 17044: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'FA_TRACK_MEMBER_PVT.get_member_at_start', p_log_level_rec => p_log_level_rec);

17040: p_asset_fin_rec => px_asset_fin_rec_new,
17041: p_dpr_in => l_dpr_in,
17042: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
17043: if (p_log_level_rec.statement_level) then
17044: fa_debug_pkg.add(l_calling_fn, 'Error calling', 'FA_TRACK_MEMBER_PVT.get_member_at_start', p_log_level_rec => p_log_level_rec);
17045: end if;
17046:
17047: raise calc_failed;
17048:

Line 17163: fa_track_member_pvt.p_track_member_table.delete;

17159:
17160: -- HHIRAGA
17161: --+++++++ Call Populate_member_assets_table function
17162: if nvl(l_dpr_in.tracking_method,'OTHER') = 'ALLOCATE' then
17163: fa_track_member_pvt.p_track_member_table.delete;
17164: fa_track_member_pvt.p_track_mem_index_table.delete;
17165: if (p_log_level_rec.statement_level) then
17166: fa_debug_pkg.add(l_calling_fn, 'Delete p_track_member_table', '+++', p_log_level_rec => p_log_level_rec);
17167: end if;

Line 17164: fa_track_member_pvt.p_track_mem_index_table.delete;

17160: -- HHIRAGA
17161: --+++++++ Call Populate_member_assets_table function
17162: if nvl(l_dpr_in.tracking_method,'OTHER') = 'ALLOCATE' then
17163: fa_track_member_pvt.p_track_member_table.delete;
17164: fa_track_member_pvt.p_track_mem_index_table.delete;
17165: if (p_log_level_rec.statement_level) then
17166: fa_debug_pkg.add(l_calling_fn, 'Delete p_track_member_table', '+++', p_log_level_rec => p_log_level_rec);
17167: end if;
17168: end if;

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

17264: --++ HHIRAGA
17265: --++++++++ tracking is allocate case, create bs table
17266: if nvl(px_asset_fin_rec_new.tracking_method,'OTHER') = 'ALLOCATE' then
17267:
17268: if not FA_TRACK_MEMBER_PVT.update_member_books(p_trans_rec => p_trans_rec,
17269: p_asset_hdr_rec => p_asset_hdr_rec,
17270: p_dpr_in => l_dpr_in,
17271: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
17272: if (p_log_level_rec.statement_level) then

Line 17274: 'FA_TRACK_MEMBER_PVT.update_member_books', p_log_level_rec => p_log_level_rec);

17270: p_dpr_in => l_dpr_in,
17271: p_mrc_sob_type_code => p_mrc_sob_type_code, p_log_level_rec => p_log_level_rec) then
17272: if (p_log_level_rec.statement_level) then
17273: fa_debug_pkg.add(l_calling_fn, 'Error calling',
17274: 'FA_TRACK_MEMBER_PVT.update_member_books', p_log_level_rec => p_log_level_rec);
17275: end if;
17276:
17277: raise calc_err;
17278: end if;

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

17277: raise calc_err;
17278: end if;
17279:
17280: if (p_log_level_rec.statement_level) then
17281: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.create_update_bs_table',
17282: 'called', p_log_level_rec => p_log_level_rec);
17283: end if;
17284:
17285: if not FA_TRACK_MEMBER_PVT.create_update_bs_table(p_trans_rec => p_trans_rec,

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

17281: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.create_update_bs_table',
17282: 'called', p_log_level_rec => p_log_level_rec);
17283: end if;
17284:
17285: if not FA_TRACK_MEMBER_PVT.create_update_bs_table(p_trans_rec => p_trans_rec,
17286: p_book_type_code => p_asset_hdr_rec.book_type_code,
17287: p_group_asset_id => p_asset_hdr_rec.asset_id,
17288: p_mrc_sob_type_code => p_mrc_sob_type_code, --Bug 8941132
17289: p_sob_id => p_asset_hdr_rec.set_of_books_id, --Bug 8941132

Line 17293: 'FA_TRACK_MEMBER_PVT.create_update_bs_table', p_log_level_rec => p_log_level_rec);

17289: p_sob_id => p_asset_hdr_rec.set_of_books_id, --Bug 8941132
17290: p_calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec) then
17291: if (p_log_level_rec.statement_level) then
17292: fa_debug_pkg.add(l_calling_fn, 'Error calling',
17293: 'FA_TRACK_MEMBER_PVT.create_update_bs_table', p_log_level_rec => p_log_level_rec);
17294: end if;
17295:
17296: raise calc_err;
17297: end if;

Line 17299: fa_track_member_pvt.p_track_member_eofy_table.delete;

17295:
17296: raise calc_err;
17297: end if;
17298:
17299: fa_track_member_pvt.p_track_member_eofy_table.delete;
17300: fa_track_member_pvt.p_track_member_table.delete;
17301: fa_track_member_pvt.p_track_mem_index_table.delete;
17302:
17303: if (p_log_level_rec.statement_level) then

Line 17300: fa_track_member_pvt.p_track_member_table.delete;

17296: raise calc_err;
17297: end if;
17298:
17299: fa_track_member_pvt.p_track_member_eofy_table.delete;
17300: fa_track_member_pvt.p_track_member_table.delete;
17301: fa_track_member_pvt.p_track_mem_index_table.delete;
17302:
17303: if (p_log_level_rec.statement_level) then
17304: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table/member_table',

Line 17301: fa_track_member_pvt.p_track_mem_index_table.delete;

17297: end if;
17298:
17299: fa_track_member_pvt.p_track_member_eofy_table.delete;
17300: fa_track_member_pvt.p_track_member_table.delete;
17301: fa_track_member_pvt.p_track_mem_index_table.delete;
17302:
17303: if (p_log_level_rec.statement_level) then
17304: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table/member_table',
17305: 'deleted', p_log_level_rec => p_log_level_rec);

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

17300: fa_track_member_pvt.p_track_member_table.delete;
17301: fa_track_member_pvt.p_track_mem_index_table.delete;
17302:
17303: if (p_log_level_rec.statement_level) then
17304: fa_debug_pkg.add(l_calling_fn, 'fa_track_member_pvt.p_track_member_eofy_table/member_table',
17305: 'deleted', p_log_level_rec => p_log_level_rec);
17306: end if;
17307:
17308: end if; -- nvl(px_asset_fin_rec_new.tracking_method,'OTHER') = 'ALLOCATE'