APPS.FA_TRACK_MEMBER_PVT dependencies on FA_SRVR_MSG

Line 151: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

147: select deprn_calendar into h_deprn_calendar
148: from fa_book_controls
149: where book_type_code=P_Book_Type_code;
150: if not fa_cache_pkg.fazcct(X_calendar=>h_deprn_calendar, p_log_level_rec => p_log_level_rec) then
151: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
152: raise main_err;
153: end if;
154: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
155: h_period_counter := P_fiscal_Year * h_perds_per_yr + P_Period_Counter;

Line 167: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

163: select deprn_calendar into h_deprn_calendar
164: from fa_book_controls
165: where book_type_code=P_Book_Type_code;
166: if not fa_cache_pkg.fazcct(X_Calendar=>h_deprn_calendar, p_log_level_rec => p_log_level_rec) then
167: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
168: raise main_err;
169: end if;
170: h_perds_per_yr := fa_cache_pkg.fazcct_record.NUMBER_PER_FISCAL_YEAR;
171: h_period_counter := P_fiscal_Year * h_perds_per_yr + P_Period_Counter;

Line 237: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

233:
234: exception
235: when main_err then
236: delete fa_track_members;
237: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
238: return 1;
239:
240: when others then
241: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

Line 241: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

237: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
238: return 1;
239:
240: when others then
241: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
242: return 1;
243: end TRACK_ASSETS;
244:
245: --------------------------------------------------------------------------

Line 2885: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

2881: p_book_type_code => h_book_type_code,
2882: p_period_counter => p_period_counter,
2883: p_group_asset_id => P_group_asset_id,
2884: p_log_level_rec => p_log_level_rec) then
2885: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
2886: raise main_err;
2887: end if;
2888:
2889: For j IN 1 .. p_track_member_table.count loop

Line 3036: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

3032: return(true);
3033:
3034: exception
3035: when allocate_err then
3036: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3037: return (FALSE);
3038:
3039: when allocate_override_err then
3040: fa_srvr_msg.add_message (calling_fn => l_calling_fn,

Line 3040: fa_srvr_msg.add_message (calling_fn => l_calling_fn,

3036: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3037: return (FALSE);
3038:
3039: when allocate_override_err then
3040: fa_srvr_msg.add_message (calling_fn => l_calling_fn,
3041: name => 'FA_NO_MEMBER_OVERRIDE', p_log_level_rec => p_log_level_rec);
3042: return (FALSE);
3043:
3044: when others then

Line 3045: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

3041: name => 'FA_NO_MEMBER_OVERRIDE', p_log_level_rec => p_log_level_rec);
3042: return (FALSE);
3043:
3044: when others then
3045: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3046: return (FALSE);
3047: end allocate;
3048:
3049: ---------------------------------------------------------------------------

Line 3131: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

3127: return 0;
3128:
3129: exception
3130: when chk_grp_amt_err then
3131: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3132: return 1;
3133:
3134: when others then
3135: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

Line 3135: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

3131: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3132: return 1;
3133:
3134: when others then
3135: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3136: return 1;
3137:
3138: end check_group_amounts;
3139:

Line 3779: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

3775:
3776: exception
3777: when allocation_main_err then
3778: rollback to member_override;
3779: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3780: return(false);
3781:
3782: when allocation_main_override_err then
3783: rollback to member_override;

Line 3784: fa_srvr_msg.add_message (calling_fn => l_calling_fn,

3780: return(false);
3781:
3782: when allocation_main_override_err then
3783: rollback to member_override;
3784: fa_srvr_msg.add_message (calling_fn => l_calling_fn,
3785: name => 'FA_NO_MEMBER_OVERRIDE', p_log_level_rec => p_log_level_rec);
3786: return(false);
3787:
3788: when allocation_main_update_err then

Line 3790: fa_srvr_msg.add_message (calling_fn => l_calling_fn,

3786: return(false);
3787:
3788: when allocation_main_update_err then
3789: rollback to member_override;
3790: fa_srvr_msg.add_message (calling_fn => l_calling_fn,
3791: name => 'FA_CANNOT_UPDATE_OVERRIDE', p_log_level_rec => p_log_level_rec);
3792: return(false);
3793:
3794: when others then

Line 3796: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

3792: return(false);
3793:
3794: when others then
3795: rollback to member_override;
3796: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
3797: return(false);
3798:
3799: end allocation_main;
3800:

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 5498: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

5494: return(true);
5495:
5496: exception
5497: when upd_deprn_err then
5498: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
5499: return(false);
5500:
5501: when others then
5502: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

Line 5502: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

5498: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
5499: return(false);
5500:
5501: when others then
5502: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
5503: return(false);
5504:
5505: end update_deprn_basis;
5506:

Line 5937: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

5933: return true;
5934:
5935: EXCEPTION
5936: when ins_dd_adj_err then
5937: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
5938: return false;
5939:
5940: when others then
5941: fa_srvr_msg.add_sql_error

Line 5941: fa_srvr_msg.add_sql_error

5937: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
5938: return false;
5939:
5940: when others then
5941: fa_srvr_msg.add_sql_error
5942: (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
5943: return false;
5944:
5945: end ins_dd_adj;

Line 7048: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

7044: return(true);
7045:
7046: exception
7047: when populate_previous_rows_err then
7048: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
7049: return(false);
7050:
7051: when others then
7052: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

Line 7052: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

7048: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
7049: return(false);
7050:
7051: when others then
7052: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
7053: return(false);
7054:
7055: end populate_previous_rows;
7056:

Line 7892: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

7888: return(true);
7889:
7890: exception
7891: when get_member_at_start_err then
7892: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
7893: return(false);
7894:
7895: when others then
7896: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

Line 7896: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

7892: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
7893: return(false);
7894:
7895: when others then
7896: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
7897: return(false);
7898:
7899: end get_member_at_start;
7900:

Line 8200: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

8196: return(true);
8197:
8198: exception
8199: when update_member_err then
8200: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
8201: return(false);
8202:
8203: when others then
8204: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

Line 8204: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

8200: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
8201: return(false);
8202:
8203: when others then
8204: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
8205: return(false);
8206:
8207: end update_member_books;
8208:

Line 8342: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

8338: return(true);
8339:
8340: exception
8341: when member_eofy_rsv_err then
8342: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
8343: return(false);
8344:
8345: when others then
8346: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

Line 8346: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

8342: fa_srvr_msg.add_message (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
8343: return(false);
8344:
8345: when others then
8346: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
8347: return(false);
8348:
8349: end member_eofy_rsv;
8350:

Line 10595: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

10591: return(true);
10592:
10593: EXCEPTION
10594: when pop_mem_table_err then
10595: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
10596: return false;
10597:
10598: when others then
10599: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

Line 10599: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

10595: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
10596: return false;
10597:
10598: when others then
10599: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
10600: return false;
10601:
10602:
10603: end populate_member_assets_table;

Line 10933: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

10929: return true;
10930:
10931: EXCEPTION
10932: when pop_mem_amt_err then
10933: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
10934: return false;
10935:
10936: when others then
10937: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

Line 10937: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

10933: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
10934: return false;
10935:
10936: when others then
10937: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
10938: return false;
10939:
10940:
10941: end populate_member_reserve;

Line 11076: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

11072: return (true);
11073:
11074: EXCEPTION
11075: when chk_reduction_err then
11076: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
11077: return false;
11078:
11079: when others then
11080: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

Line 11080: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

11076: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
11077: return false;
11078:
11079: when others then
11080: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
11081: return false;
11082:
11083:
11084: end check_reduction_application;

Line 11567: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

11563: return (true);
11564:
11565: exception
11566: when others then
11567: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
11568: return false;
11569:
11570: end create_update_bs_table;
11571:

Line 11734: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

11730:
11731: exception
11732: when others then
11733: x_deprn_override_flag:= fa_std_types.FA_NO_OVERRIDE;
11734: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
11735: return(TRUE);
11736:
11737: end override_member_amount;
11738:

Line 11841: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

11837: end loop;
11838: return (TRUE);
11839: exception
11840: when others then
11841: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
11842: return false;
11843: end populate_unplanned_exp;
11844:
11845: function search_index_table(p_period_counter IN number,

Line 11862: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

11858: return -1;
11859: end if;
11860: Exception
11861: when others then
11862: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
11863: raise main_err;
11864: end search_index_table;
11865:
11866: procedure put_track_index(p_period_counter IN number,

Line 11879: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

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');
11876: p_track_mem_index_table(l_index_key) := p_index_value;
11877: Exception
11878: when others then
11879: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
11880: raise main_err;
11881: end put_track_index;
11882:
11883:

Line 11898: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);

11894: p_track_mem_index_table.delete(l_index_key);
11895: end if;
11896: Exception
11897: when others then
11898: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
11899: raise main_err;
11900: end;
11901:
11902: