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.75.12020000.3 2012/07/23 12:45:24 rmandali ship $ */
3:
4: function populate_unplanned_exp(p_set_of_books_id IN NUMBER,
5: p_mrc_sob_type_code in VARCHAR2,

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

91:
92: -- Structure for track members
93: l_track_members track_member_type;
94:
95: l_calling_fn varchar2(35) := 'fa_track_member_pvt.track_assets';
96:
97: main_err exception;
98:
99: -- cursor to check data existing

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

376: l_temp_char varchar2(30); -- ENERGY
377: l_temp_bool boolean; -- ENERGY
378: l_group_reserve number; -- ENERGY
379:
380: l_calling_fn varchar2(35) := 'fa_track_member_pvt.allocate';
381: allocate_err exception;
382: allocate_override_err exception;
383: -- bug 8394833
384: type num_tbl_type is table of number index by binary_integer;

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

3080: nbv_absval number;
3081: adj_rec_cost_absval number;
3082: rsv_absval number;
3083:
3084: l_calling_fn varchar2(40) := 'fa_track_member_pvt.check_group_amount';
3085: chk_grp_amt_err exception;
3086:
3087: begin <>
3088:

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

3232:
3233: h_deprn_expense number;
3234: h_bonus_expense number;
3235:
3236: l_calling_fn varchar2(35) := 'fa_track_member_pvt.allocation_main';
3237: allocation_main_err exception;
3238: allocation_main_override_err exception;
3239: allocation_main_update_err exception;
3240:

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

3914: h_exclude_fully_rsv_flag varchar2(1);
3915:
3916: h_check_row_existing varchar2(1);
3917:
3918: l_calling_fn varchar2(40) := 'fa_track_member_pvt.update_deprn_basis';
3919: upd_deprn_err exception;
3920:
3921: --* cursor to query members belonged to the specified group
3922: -- this is used to update deprn basis when group level is updated

Line 5215: fa_srvr_msg.add_message(calling_fn => 'fa_track_member_pvt.udpate_deprn_basis.get_eofy_eop', p_log_level_rec => p_log_level_rec);

5211: x_eofy_recoverable_cost => h_new_eofy_recoverable_cost,
5212: x_eofy_salvage_value => h_new_eofy_salvage_value,
5213: x_eop_recoverable_cost => h_new_eop_recoverable_cost,
5214: x_eop_salvage_value => h_new_eop_salvage_value, p_log_level_rec => p_log_level_rec) then
5215: fa_srvr_msg.add_message(calling_fn => 'fa_track_member_pvt.udpate_deprn_basis.get_eofy_eop', p_log_level_rec => p_log_level_rec);
5216: return(false);
5217:
5218: end if;
5219:

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

5539: l_transaction_key varchar2(2);
5540:
5541: l_status boolean;
5542:
5543: l_calling_fn varchar2(35) := 'fa_track_member_pvt.ins_dd_adj';
5544: ins_dd_adj_err exception;
5545: l_rowid rowid;
5546:
5547: l_debit_credit_flag varchar(2);

Line 5649: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj'

5645: X_Amortization_Start_Date => NULL,
5646: X_Calling_Interface => null,
5647: X_Mass_Transaction_ID => null,
5648: X_Return_Status => l_status,
5649: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj'
5650: , p_log_level_rec => p_log_level_rec);
5651:
5652: if not l_status then
5653: raise ins_dd_adj_err;

Line 5671: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj'

5667: X_transaction_header_id_out => p_transaction_header_id,
5668: X_date_ineffective => sysdate,
5669: X_mrc_sob_type_code => p_mrc_sob_type_code,
5670: X_set_of_books_id => p_asset_hdr_rec.set_of_books_id,
5671: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj'
5672: , p_log_level_rec => p_log_level_rec);
5673:
5674: l_rowid := null;
5675:

Line 5799: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj'

5795: X_terminal_gain_loss_flag => x_asset_fin_rec.terminal_gain_loss_flag,
5796: X_mrc_sob_type_code => p_mrc_sob_type_code,
5797: X_set_of_books_id => p_asset_hdr_rec.set_of_books_id,
5798: X_Return_Status => l_status,
5799: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj'
5800: ,p_log_level_rec => p_log_level_rec);
5801:
5802: if not l_status then
5803: raise ins_dd_adj_err;

Line 5912: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj'

5908: X_Period_Counter => p_period_counter - 1,
5909: X_mrc_sob_type_code => p_mrc_sob_type_code,
5910: X_set_of_books_id => p_asset_hdr_rec.set_of_books_id,
5911:
5912: X_Calling_Fn => 'fa_track_member_pvt.ins_dd_adj'
5913: , p_log_level_rec => p_log_level_rec);
5914:
5915: if not FA_INS_DETAIL_PKG.FAXINDD
5916: (X_book_type_code => p_asset_hdr_rec.book_type_code,

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

6022: i number;
6023: h_adj_asset_id number;
6024: h_adj_trans_type varchar2(20);
6025:
6026: l_calling_fn varchar2(45) := 'fa_track_member_pvt.populate_previous_rows';
6027: populate_previous_rows_err exception;
6028:
6029: l_member_asset_id number;
6030:

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

6680: (nvl(p_allocate_to_fully_ret_flag,'N') = 'Y' and nvl(p_allocate_to_fully_rsv_flag,'N') = 'Y'))
6681:
6682: then
6683: if (p_log_level_rec.statement_level) then
6684: fa_debug_pkg.add('fa_track_member_pvt', '++ In case when member asset is queried ++ ', i, p_log_level_rec => p_log_level_rec);
6685: end if;
6686: if h_eop_fiscal_year = h_fiscal_year then
6687: h_eofy_reserve := nvl(h_eofy_reserve,0) + nvl(h_eofy_reserve_adjustment,0) + nvl(h_adj_reserve,0);
6688: end if;

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

6950: (nvl(p_allocate_to_fully_ret_flag,'N') = 'Y' and nvl(p_allocate_to_fully_rsv_flag,'N') = 'Y'))
6951:
6952: then
6953: if (p_log_level_rec.statement_level) then
6954: fa_debug_pkg.add('fa_track_member_pvt', '++ In case when member asset is queried ++ ', i, p_log_level_rec => p_log_level_rec);
6955: end if;
6956: if h_eop_fiscal_year = h_fiscal_year then
6957: h_eofy_reserve := nvl(h_eofy_reserve,0) + nvl(h_eofy_reserve_adjustment,0) + nvl(h_adj_reserve,0);
6958: end if;

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

7142: h_old_group_asset_id number;
7143: h_new_group_asset_id number;
7144: h_mem_trans_thid number;
7145:
7146: l_calling_fn varchar2(45) := 'fa_track_member_pvt.get_member_at_start';
7147: get_member_at_start_err exception;
7148:
7149: --* Structure to call Deprn Basis Rule
7150: fa_rule_in fa_std_types.fa_deprn_rule_in_struct;

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

7926:
7927: h_adjusted_cost number;
7928: h_eofy_reserve number;
7929:
7930: l_calling_fn varchar2(45) := 'fa_track_member_pvt.update_member_books';
7931: update_member_err exception;
7932:
7933:
7934: l_member_asset_id number;

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

7980:
7981: begin
7982:
7983: if (p_log_level_rec.statement_level) then
7984: fa_debug_pkg.add('fa_track_member_pvt', '*** update_member_books Started', '***');
7985: 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 => p_log_level_rec);
7986: end if;
7987:
7988: h_book_type_code := p_asset_hdr_rec.book_type_code;

Line 7985: 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 => p_log_level_rec);

7981: begin
7982:
7983: if (p_log_level_rec.statement_level) then
7984: fa_debug_pkg.add('fa_track_member_pvt', '*** update_member_books Started', '***');
7985: 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 => p_log_level_rec);
7986: end if;
7987:
7988: h_book_type_code := p_asset_hdr_rec.book_type_code;
7989: h_group_asset_id := p_asset_hdr_rec.asset_id;

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

8062: h_adjusted_cost := nvl(p_track_member_table(i).adjusted_cost,0);
8063: h_eofy_reserve := p_track_member_table(i).eofy_reserve;
8064:
8065: if (p_log_level_rec.statement_level) then
8066: fa_debug_pkg.add('fa_track_member_pvt', 'member asset id', h_member_asset_id, p_log_level_rec => p_log_level_rec);
8067: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec => p_log_level_rec);
8068: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec => p_log_level_rec);
8069: end if;
8070:

Line 8067: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec => p_log_level_rec);

8063: h_eofy_reserve := p_track_member_table(i).eofy_reserve;
8064:
8065: if (p_log_level_rec.statement_level) then
8066: fa_debug_pkg.add('fa_track_member_pvt', 'member asset id', h_member_asset_id, p_log_level_rec => p_log_level_rec);
8067: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec => p_log_level_rec);
8068: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec => p_log_level_rec);
8069: end if;
8070:
8071: -- Update FA_BOOKS table

Line 8068: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec => p_log_level_rec);

8064:
8065: if (p_log_level_rec.statement_level) then
8066: fa_debug_pkg.add('fa_track_member_pvt', 'member asset id', h_member_asset_id, p_log_level_rec => p_log_level_rec);
8067: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec => p_log_level_rec);
8068: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec => p_log_level_rec);
8069: end if;
8070:
8071: -- Update FA_BOOKS table
8072: Update FA_BOOKS set adjusted_cost = h_adjusted_cost,

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

8142: h_adjusted_cost := p_track_member_table(i).adjusted_cost;
8143: h_eofy_reserve := p_track_member_table(i).eofy_reserve;
8144:
8145: if (p_log_level_rec.statement_level) then
8146: fa_debug_pkg.add('fa_track_member_pvt', 'member asset id', h_member_asset_id, p_log_level_rec => p_log_level_rec);
8147: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec => p_log_level_rec);
8148: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec => p_log_level_rec);
8149: end if;
8150:

Line 8147: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec => p_log_level_rec);

8143: h_eofy_reserve := p_track_member_table(i).eofy_reserve;
8144:
8145: if (p_log_level_rec.statement_level) then
8146: fa_debug_pkg.add('fa_track_member_pvt', 'member asset id', h_member_asset_id, p_log_level_rec => p_log_level_rec);
8147: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec => p_log_level_rec);
8148: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec => p_log_level_rec);
8149: end if;
8150:
8151: -- Update FA_BOOKS table

Line 8148: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec => p_log_level_rec);

8144:
8145: if (p_log_level_rec.statement_level) then
8146: fa_debug_pkg.add('fa_track_member_pvt', 'member asset id', h_member_asset_id, p_log_level_rec => p_log_level_rec);
8147: fa_debug_pkg.add('fa_track_member_pvt', 'adjusted cost', h_adjusted_cost, p_log_level_rec => p_log_level_rec);
8148: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec => p_log_level_rec);
8149: end if;
8150:
8151: -- Update FA_BOOKS table
8152: Update FA_MC_BOOKS set adjusted_cost = h_adjusted_cost,

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

8237: h_adjusted_cost number;
8238: h_eofy_reserve number;
8239: j number;
8240:
8241: l_calling_fn varchar2(45) := 'fa_track_member_pvt.member_eofy_rsv';
8242: member_eofy_rsv_err exception;
8243:
8244: -- cursor to get period_counter
8245: cursor GET_PERIOD_COUNTER is

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

8541: h_skip_control boolean := false;
8542:
8543: --* Exception
8544: x_rtn_code number;
8545: l_calling_fn varchar2(50) := 'fa_track_member_pvt.populate_member_assets_table';
8546: pop_mem_table_err exception;
8547:
8548:
8549: --* Cursor to get period counter from date

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

10979: h_reduction_amount number;
10980: h_fy_begin_nbv number;
10981: h_check_amount number;
10982:
10983: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.CHECK_REDUCTION_APPLICATION';
10984: chk_reduction_err exception;
10985:
10986: begin
10987:

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

11188:
11189: --* local variables
11190: h_period_counter number;
11191: h_number_per_fy number;
11192: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.COPY_MEMBER_TABLE';
11193:
11194: begin
11195:
11196: if p_backup_restore = 'BACKUP' then

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

11326: p_calling_fn in varchar2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
11327: return boolean is
11328:
11329: --* Local variables
11330: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.create_update_bs_table';
11331:
11332: type t_type_num is table of number index by binary_integer;
11333: type t_type_varchar is table of varchar2(1000) index by binary_integer;
11334: type t_type_date is table of date index by binary_integer;

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

11607: report_cost number;
11608: l_avg_rate number;
11609:
11610: --* Exceptions
11611: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.OVERRIDE_MEMBER_AMOUNTS';
11612:
11613: --* Cursor to query FA_DEPRN_OVERRIDE with 'POSTED' and 'DEPRECIATION'
11614: cursor GET_OVERRIDE_AMOUNT is
11615: SELECT deprn_amount, bonus_deprn_amount, subtract_ytd_flag, deprn_override_id

Line 11809: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.POPULATE_UNPLANNED_EXP';

11805: group by th2.asset_id;
11806:
11807: type t_tbl_unpln_exp is TABLE of C_FA_ADJ_UNPLANNED%rowtype index by binary_integer;
11808: l_tbl_unpln_exp t_tbl_unpln_exp;
11809: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.POPULATE_UNPLANNED_EXP';
11810: begin
11811:
11812: if p_mrc_sob_type_code <> 'R' then
11813: open C_FA_ADJ_UNPLANNED;

Line 11850: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.SEARCH_INDEX_TABLE';

11846: p_member_asset_id IN number,
11847: p_group_asset_id IN number,
11848: p_sob_id IN number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
11849: return number is
11850: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.SEARCH_INDEX_TABLE';
11851: l_index_key varchar2(152);
11852: main_err exception;
11853: Begin
11854: l_index_key := lpad(p_period_counter,38,'0')||lpad(p_member_asset_id,38,'0')||lpad(p_group_asset_id,38,'0')||lpad(nvl(p_sob_id,-99),38,'0');

Line 11871: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.PUT_TRACK_INDEX';

11867: p_member_asset_id IN number,
11868: p_group_asset_id IN number,
11869: p_sob_id IN number,
11870: p_index_value IN number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
11871: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.PUT_TRACK_INDEX';
11872: l_index_key varchar2(152);
11873: main_err exception;
11874: begin
11875: l_index_key := lpad(p_period_counter,38,'0')||lpad(p_member_asset_id,38,'0')||lpad(p_group_asset_id,38,'0')||lpad(nvl(p_sob_id,-99),38,'0');

Line 11888: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.DELETE_TRACK_INDEX';

11884: procedure delete_track_index(p_period_counter IN number,
11885: p_member_asset_id IN number,
11886: p_group_asset_id IN number,
11887: p_sob_id IN number, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
11888: l_calling_fn varchar2(50) := 'FA_TRACK_MEMBER_PVT.DELETE_TRACK_INDEX';
11889: l_index_key varchar2(152);
11890: main_err exception;
11891: begin
11892: l_index_key := lpad(p_period_counter,38,'0')||lpad(p_member_asset_id,38,'0')||lpad(p_group_asset_id,38,'0')||lpad(nvl(p_sob_id,-99),38,'0');

Line 11903: END FA_TRACK_MEMBER_PVT;

11899: raise main_err;
11900: end;
11901:
11902:
11903: END FA_TRACK_MEMBER_PVT;