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_TRACK_MEMBER_PVT dependencies on FA_TRACK_MEMBER_PVT

Line 1: PACKAGE BODY FA_TRACK_MEMBER_PVT as

1: PACKAGE BODY FA_TRACK_MEMBER_PVT as
2: /* $Header: FAVTRACKB.pls 120.55.12010000.3 2008/08/29 07:40:53 dvjoshi ship $ */
3:
4: primary_cost number; -- Used in override function
5:

Line 68: l_calling_fn varchar2(35) := 'fa_track_member_pvt.track_assets';

64:
65: -- Structure for track members
66: l_track_members track_member_type;
67:
68: l_calling_fn varchar2(35) := 'fa_track_member_pvt.track_assets';
69:
70: main_err exception;
71:
72: -- cursor to check data existing

Line 359: l_calling_fn varchar2(35) := 'fa_track_member_pvt.allocate';

355: l_temp_char varchar2(30); -- ENERGY
356: l_temp_bool boolean; -- ENERGY
357: l_group_reserve number; -- ENERGY
358:
359: l_calling_fn varchar2(35) := 'fa_track_member_pvt.allocate';
360: allocate_err exception;
361: allocate_override_err exception;
362:
363: ---- For regular mode

Line 2929: l_calling_fn varchar2(40) := 'fa_track_member_pvt.check_group_amount';

2925: nbv_absval number;
2926: adj_rec_cost_absval number;
2927: rsv_absval number;
2928:
2929: l_calling_fn varchar2(40) := 'fa_track_member_pvt.check_group_amount';
2930: chk_grp_amt_err exception;
2931:
2932: begin <>
2933:

Line 3083: l_calling_fn varchar2(35) := 'fa_track_member_pvt.allocation_main';

3079:
3080: h_deprn_expense number;
3081: h_bonus_expense number;
3082:
3083: l_calling_fn varchar2(35) := 'fa_track_member_pvt.allocation_main';
3084: allocation_main_err exception;
3085: allocation_main_override_err exception;
3086: allocation_main_update_err exception;
3087:

Line 3768: l_calling_fn varchar2(40) := 'fa_track_member_pvt.update_deprn_basis';

3764: h_exclude_fully_rsv_flag varchar2(1);
3765:
3766: h_check_row_existing varchar2(1);
3767:
3768: l_calling_fn varchar2(40) := 'fa_track_member_pvt.update_deprn_basis';
3769: upd_deprn_err exception;
3770:
3771: --* cursor to query members belonged to the specified group
3772: -- this is used to update deprn basis when group level is updated

Line 5055: fa_srvr_msg.add_message(calling_fn => 'fa_track_member_pvt.udpate_deprn_basis.get_eofy_eop',

5051: x_eop_recoverable_cost => h_new_eop_recoverable_cost,
5052: x_eop_salvage_value => h_new_eop_salvage_value,
5053: p_log_level_rec => p_log_level_rec) then
5054:
5055: fa_srvr_msg.add_message(calling_fn => 'fa_track_member_pvt.udpate_deprn_basis.get_eofy_eop',
5056: p_log_level_rec => p_log_level_rec);
5057: return(false);
5058:
5059: end if;

Line 5388: l_calling_fn varchar2(35) := 'fa_track_member_pvt.ins_dd_adj';

5384: l_transaction_key varchar2(2);
5385:
5386: l_status boolean;
5387:
5388: l_calling_fn varchar2(35) := 'fa_track_member_pvt.ins_dd_adj';
5389: ins_dd_adj_err exception;
5390: l_rowid rowid;
5391:
5392: l_debit_credit_flag varchar(2);

Line 5493: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj',

5489: X_Amortization_Start_Date => NULL,
5490: X_Calling_Interface => null,
5491: X_Mass_Transaction_ID => null,
5492: X_Return_Status => l_status,
5493: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj',
5494: p_log_level_rec => p_log_level_rec
5495: );
5496:
5497: if not l_status then

Line 5508: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj',

5504: X_book_type_code => p_asset_hdr_rec.book_type_code,
5505: X_transaction_header_id_out => p_transaction_header_id,
5506: X_date_ineffective => sysdate,
5507: X_mrc_sob_type_code => p_mrc_sob_type_code,
5508: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj',
5509: p_log_level_rec => p_log_level_rec
5510: );
5511:
5512: l_rowid := null;

Line 5636: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj',

5632: X_retirement_deprn_option => x_asset_fin_rec.retirement_deprn_option,
5633: X_terminal_gain_loss_flag => x_asset_fin_rec.terminal_gain_loss_flag,
5634: X_mrc_sob_type_code => p_mrc_sob_type_code,
5635: X_Return_Status => l_status,
5636: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj',
5637: p_log_level_rec => p_log_level_rec
5638: );
5639:
5640: if not l_status then

Line 5748: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj',

5744: X_Ytd_Deprn => l_asset_deprn_rec.ytd_deprn,
5745: X_Deprn_Reserve => l_asset_deprn_rec.deprn_reserve,
5746: X_Period_Counter => p_period_counter - 1,
5747: X_mrc_sob_type_code => p_mrc_sob_type_code,
5748: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj',
5749: p_log_level_rec => p_log_level_rec
5750: );
5751:
5752: if not FA_INS_DETAIL_PKG.FAXINDD

Line 5865: l_calling_fn varchar2(45) := 'fa_track_member_pvt.populate_previous_rows';

5861: i number;
5862: h_adj_asset_id number;
5863: h_adj_trans_type varchar2(20);
5864:
5865: l_calling_fn varchar2(45) := 'fa_track_member_pvt.populate_previous_rows';
5866: populate_previous_rows_err exception;
5867:
5868: l_member_asset_id number;
5869:

Line 6524: fa_debug_pkg.add('fa_track_member_pvt', '++ In case when member asset is queried ++ ', i);

6520: (nvl(p_allocate_to_fully_ret_flag,'N') = 'Y' and nvl(p_allocate_to_fully_rsv_flag,'N') = 'Y'))
6521:
6522: then
6523: if (p_log_level_rec.statement_level) then
6524: fa_debug_pkg.add('fa_track_member_pvt', '++ In case when member asset is queried ++ ', i);
6525: end if;
6526: if h_eop_fiscal_year = h_fiscal_year then
6527: h_eofy_reserve := nvl(h_eofy_reserve,0) + nvl(h_eofy_reserve_adjustment,0) + nvl(h_adj_reserve,0);
6528: end if;

Line 6786: fa_debug_pkg.add('fa_track_member_pvt', '++ In case when member asset is queried ++ ', i);

6782: (nvl(p_allocate_to_fully_ret_flag,'N') = 'Y' and nvl(p_allocate_to_fully_rsv_flag,'N') = 'Y'))
6783:
6784: then
6785: if (p_log_level_rec.statement_level) then
6786: fa_debug_pkg.add('fa_track_member_pvt', '++ In case when member asset is queried ++ ', i);
6787: end if;
6788: if h_eop_fiscal_year = h_fiscal_year then
6789: h_eofy_reserve := nvl(h_eofy_reserve,0) + nvl(h_eofy_reserve_adjustment,0) + nvl(h_adj_reserve,0);
6790: end if;

Line 6976: l_calling_fn varchar2(45) := 'fa_track_member_pvt.get_member_at_start';

6972: h_old_group_asset_id number;
6973: h_new_group_asset_id number;
6974: h_mem_trans_thid number;
6975:
6976: l_calling_fn varchar2(45) := 'fa_track_member_pvt.get_member_at_start';
6977: get_member_at_start_err exception;
6978:
6979: --* Structure to call Deprn Basis Rule
6980: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;

Line 7751: l_calling_fn varchar2(45) := 'fa_track_member_pvt.update_member_books';

7747:
7748: h_adjusted_cost number;
7749: h_eofy_reserve number;
7750:
7751: l_calling_fn varchar2(45) := 'fa_track_member_pvt.update_member_books';
7752: update_member_err exception;
7753:
7754:
7755: l_member_asset_id number;

Line 7803: fa_debug_pkg.add('fa_track_member_pvt', '* update_member_books Started', '*', p_log_level_rec);

7799:
7800: begin
7801:
7802: if (p_log_level_rec.statement_level) then
7803: fa_debug_pkg.add('fa_track_member_pvt', '*** update_member_books Started', '***', p_log_level_rec);
7804: fa_debug_pkg.add('fa_track_member_pvt', 'book_type_code:group_asset_id', p_asset_hdr_rec.book_type_code||':'||p_asset_hdr_rec.asset_id, p_log_level_rec);
7805: end if;
7806:
7807: h_book_type_code := p_asset_hdr_rec.book_type_code;

Line 7804: fa_debug_pkg.add('fa_track_member_pvt', 'book_type_code:group_asset_id', p_asset_hdr_rec.book_type_code||':'||p_asset_hdr_rec.asset_id, p_log_level_rec);

7800: begin
7801:
7802: if (p_log_level_rec.statement_level) then
7803: fa_debug_pkg.add('fa_track_member_pvt', '*** update_member_books Started', '***', p_log_level_rec);
7804: fa_debug_pkg.add('fa_track_member_pvt', 'book_type_code:group_asset_id', p_asset_hdr_rec.book_type_code||':'||p_asset_hdr_rec.asset_id, p_log_level_rec);
7805: end if;
7806:
7807: h_book_type_code := p_asset_hdr_rec.book_type_code;
7808: h_group_asset_id := p_asset_hdr_rec.asset_id;

Line 7888: fa_debug_pkg.add('fa_track_member_pvt', 'member asset id', h_member_asset_id, p_log_level_rec);

7884: h_adjusted_cost := nvl(p_track_member_table(i).adjusted_cost,0);
7885: h_eofy_reserve := p_track_member_table(i).eofy_reserve;
7886:
7887: if (p_log_level_rec.statement_level) then
7888: fa_debug_pkg.add('fa_track_member_pvt', 'member asset id', h_member_asset_id, p_log_level_rec);
7889: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec);
7890: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec);
7891: end if;
7892:

Line 7889: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec);

7885: h_eofy_reserve := p_track_member_table(i).eofy_reserve;
7886:
7887: if (p_log_level_rec.statement_level) then
7888: fa_debug_pkg.add('fa_track_member_pvt', 'member asset id', h_member_asset_id, p_log_level_rec);
7889: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec);
7890: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec);
7891: end if;
7892:
7893: -- Update FA_BOOKS table

Line 7890: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec);

7886:
7887: if (p_log_level_rec.statement_level) then
7888: fa_debug_pkg.add('fa_track_member_pvt', 'member asset id', h_member_asset_id, p_log_level_rec);
7889: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec);
7890: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec);
7891: end if;
7892:
7893: -- Update FA_BOOKS table
7894: Update FA_BOOKS set adjusted_cost = h_adjusted_cost,

Line 7946: fa_debug_pkg.add('fa_track_member_pvt', 'member asset id', h_member_asset_id, p_log_level_rec);

7942: h_adjusted_cost := p_track_member_table(i).adjusted_cost;
7943: h_eofy_reserve := p_track_member_table(i).eofy_reserve;
7944:
7945: if (p_log_level_rec.statement_level) then
7946: fa_debug_pkg.add('fa_track_member_pvt', 'member asset id', h_member_asset_id, p_log_level_rec);
7947: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec);
7948: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec);
7949: end if;
7950:

Line 7947: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec);

7943: h_eofy_reserve := p_track_member_table(i).eofy_reserve;
7944:
7945: if (p_log_level_rec.statement_level) then
7946: fa_debug_pkg.add('fa_track_member_pvt', 'member asset id', h_member_asset_id, p_log_level_rec);
7947: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec);
7948: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec);
7949: end if;
7950:
7951: -- Update FA_BOOKS table

Line 7948: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec);

7944:
7945: if (p_log_level_rec.statement_level) then
7946: fa_debug_pkg.add('fa_track_member_pvt', 'member asset id', h_member_asset_id, p_log_level_rec);
7947: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec);
7948: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec);
7949: end if;
7950:
7951: -- Update FA_BOOKS table
7952: Update FA_BOOKS_MRC_V set adjusted_cost = h_adjusted_cost,

Line 8015: l_calling_fn varchar2(45) := 'fa_track_member_pvt.member_eofy_rsv';

8011: h_adjusted_cost number;
8012: h_eofy_reserve number;
8013: j number;
8014:
8015: l_calling_fn varchar2(45) := 'fa_track_member_pvt.member_eofy_rsv';
8016: member_eofy_rsv_err exception;
8017:
8018: -- cursor to get period_counter
8019: cursor GET_PERIOD_COUNTER is

Line 8320: l_calling_fn varchar2(50) := 'fa_track_member_pvt.populate_member_assets_table';

8316: h_skip_control boolean := false;
8317:
8318: --* Exception
8319: x_rtn_code number;
8320: l_calling_fn varchar2(50) := 'fa_track_member_pvt.populate_member_assets_table';
8321: pop_mem_table_err exception;
8322:
8323:
8324: --* Cursor to get period counter from date

Line 10646: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.CHECK_REDUCTION_APPLICATION';

10642: h_reduction_amount number;
10643: h_fy_begin_nbv number;
10644: h_check_amount number;
10645:
10646: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.CHECK_REDUCTION_APPLICATION';
10647: chk_reduction_err exception;
10648:
10649: begin
10650:

Line 10859: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.COPY_MEMBER_TABLE';

10855:
10856: --* local variables
10857: h_period_counter number;
10858: h_number_per_fy number;
10859: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.COPY_MEMBER_TABLE';
10860:
10861: begin
10862:
10863: if p_backup_restore = 'BACKUP' then

Line 11016: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.create_update_bs_table';

11012: and period_counter = h_period_counter;
11013: -- and nvl(set_of_books_id, -99) = nvl(h_set_of_books_id, -99);
11014:
11015: --*
11016: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.create_update_bs_table';
11017:
11018: begin
11019:
11020: if (p_log_level_rec.statement_level) then

Line 11272: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.OVERRIDE_MEMBER_AMOUNTS';

11268: report_cost number;
11269: l_avg_rate number;
11270:
11271: --* Exceptions
11272: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.OVERRIDE_MEMBER_AMOUNTS';
11273:
11274: --* Cursor to query FA_DEPRN_OVERRIDE with 'POSTED' and 'DEPRECIATION'
11275: cursor GET_OVERRIDE_AMOUNT is
11276: SELECT deprn_amount, bonus_deprn_amount, subtract_ytd_flag, deprn_override_id

Line 11404: END FA_TRACK_MEMBER_PVT;

11400: return(TRUE);
11401:
11402: end override_member_amount;
11403:
11404: END FA_TRACK_MEMBER_PVT;