43: return true;
44:
45: EXCEPTION
46: when calc_err then
47: fa_srvr_msg.add_message(calling_fn => 'fa_mc_util_pvt.get_existing_rate',
48: p_log_level_rec => p_log_level_rec);
49: return false;
50:
51: when others then
48: p_log_level_rec => p_log_level_rec);
49: return false;
50:
51: when others then
52: fa_srvr_msg.add_sql_error(calling_fn => 'fa_mc_util_pvt.get_existing_rate'
53: ,p_log_level_rec => p_log_level_rec);
54: return false;
55:
56: END get_existing_rate;
162: return true;
163:
164: EXCEPTION
165: when calc_err then
166: fa_srvr_msg.add_message(calling_fn => 'fa_mc_util_pvt.get_trx_rate',
167: p_log_level_rec => p_log_level_rec);
168: return false;
169:
170: when others then
167: p_log_level_rec => p_log_level_rec);
168: return false;
169:
170: when others then
171: fa_srvr_msg.add_sql_error(calling_fn => 'fa_mc_util_pvt.get_trx_rate'
172: ,p_log_level_rec => p_log_level_rec);
173: return false;
174:
175: END get_trx_rate;
205:
206: EXCEPTION
207:
208: when others then
209: fa_srvr_msg.add_sql_error(calling_fn => 'fa_mc_util_pvt.get_latest_rate'
210: ,p_log_level_rec => p_log_level_rec);
211: return false;
212:
213: END get_latest_rate;
279: -- this can happen when a reporting book is
280: -- associated to a FA book but not in AP
281: l_result_code := 'NOT_FOUND';
282: when OTHERS then
283: fa_srvr_msg.add_sql_error(
284: calling_fn => l_calling_fn,
285: p_log_level_rec => p_log_level_rec);
286: raise error_found;
287: END;
355:
356: EXCEPTION
357:
358: when error_found then
359: fa_srvr_msg.add_message(calling_fn => l_calling_fn
360: ,p_log_level_rec => p_log_level_rec);
361: return false;
362:
363: when others then
360: ,p_log_level_rec => p_log_level_rec);
361: return false;
362:
363: when others then
364: fa_srvr_msg.add_sql_error(calling_fn => l_calling_fn
365: ,p_log_level_rec => p_log_level_rec);
366: return false;
367:
368: