1: PACKAGE BODY FA_RATES_PKG as
2: /* $Header: faxiratb.pls 120.6 2005/07/28 00:19:56 tkawamur ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,
127:
128: exception
129: when others then
130: fa_srvr_msg.add_sql_error(
131: calling_fn => 'fa_rates_pkg.update_row'
132: ,p_log_level_rec => p_log_level_rec);
133: raise;
134:
135: end UPDATE_ROW;
153:
154: exception
155: when others then
156: fa_srvr_msg.add_sql_error(
157: calling_fn => 'fa_rates_pkg.delete_row'
158: ,p_log_level_rec => p_log_level_rec);
159: raise;
160:
161: end DELETE_ROW;
193: if (fnd_load_util.upload_test(user_id, x_last_update_date,
194: x_db_last_updated_by, x_db_last_update_date,
195: X_CUSTOM_MODE)) then
196:
197: fa_rates_pkg.update_row (
198: X_Method_ID => X_Method_ID,
199: X_Year => X_Year,
200: X_Period_Placed_In_Service => X_Period_Placed_In_Service,
201: X_Rate => X_Rate,
204: X_Last_Update_Login => 0
205: ,p_log_level_rec => p_log_level_rec);
206: end if;
207: else
208: fa_rates_pkg.insert_row (
209: X_Rowid => row_id,
210: X_Method_Id => X_Method_Id,
211: X_Year => X_Year,
212: X_Period_Placed_In_Service => X_Period_Placed_In_Service,
222: exception
223: when others then
224:
225: fa_srvr_msg.add_sql_error(
226: calling_fn => 'fa_rates_pkg.load_row'
227: ,p_log_level_rec => p_log_level_rec);
228:
229: FA_STANDARD_PKG.RAISE_ERROR(
230: CALLED_FN => 'fa_rates_pkg.load_row',
226: calling_fn => 'fa_rates_pkg.load_row'
227: ,p_log_level_rec => p_log_level_rec);
228:
229: FA_STANDARD_PKG.RAISE_ERROR(
230: CALLED_FN => 'fa_rates_pkg.load_row',
231: CALLING_FN => 'upload fa_rates'
232: ,p_log_level_rec => p_log_level_rec);
233:
234: end LOAD_ROW;
283: else
284: h_depr_last_year_flag := FALSE;
285: end if;
286:
287: fa_rates_pkg.LOAD_ROW (
288: x_custom_mode => x_custom_mode,
289: x_method_id => h_method_id,
290: x_db_last_update_date => h_last_update_date,
291: x_db_last_updated_by => h_last_updated_by,
302: calling_fn => 'update fa_flat_rates');
303:
304: fa_standard_pkg.raise_error(
305: called_fn => 'farat.lct',
306: calling_fn => 'fa_rates_pkg.load_seed_row');
307:
308: END LOAD_SEED_ROW;
309:
310: END FA_RATES_PKG;
306: calling_fn => 'fa_rates_pkg.load_seed_row');
307:
308: END LOAD_SEED_ROW;
309:
310: END FA_RATES_PKG;