1: PACKAGE BODY FA_ITC_RATES_PKG as
2: /* $Header: faxiitcb.pls 120.6 2005/07/28 00:20:26 tkawamur ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,
102:
103: exception
104: when others then
105: fa_srvr_msg.add_sql_error(
106: calling_fn => 'fa_itc_rates_pkg.insert_row'
107: ,p_log_level_rec => p_log_level_rec);
108: raise;
109:
110: end INSERT_ROW;
292:
293: exception
294: when others then
295: fa_srvr_msg.add_sql_error(
296: calling_fn => 'fa_itc_rates_pkg.update_row'
297: ,p_log_level_rec => p_log_level_rec);
298: raise;
299:
300: end UPDATE_ROW;
314:
315: exception
316: when others then
317: fa_srvr_msg.add_sql_error(
318: calling_fn => 'fa_itc_rates_pkg.delete_row'
319: ,p_log_level_rec => p_log_level_rec);
320: raise;
321:
322: end DELETE_ROW;
375: if (fnd_load_util.upload_test(user_id, x_last_update_date,
376: db_last_updated_by, db_last_update_date,
377: X_CUSTOM_MODE)) then
378:
379: fa_itc_rates_pkg.update_row (
380: X_Itc_Amount_Id => X_Itc_Amount_Id,
381: X_Tax_Year => X_Tax_Year,
382: X_Life_In_Months => X_Life_In_Months,
383: X_Itc_Amount_Rate => X_Itc_Amount_Rate,
403: X_Last_Update_Login => 0
404: ,p_log_level_rec => p_log_level_rec);
405: end if;
406: else
407: fa_itc_rates_pkg.insert_row (
408: X_Rowid => row_id,
409: X_Itc_Amount_Id => X_Itc_Amount_Id,
410: X_Tax_Year => X_Tax_Year,
411: X_Life_In_Months => X_Life_In_Months,
437:
438: exception
439: when others then
440: FA_STANDARD_PKG.RAISE_ERROR(
441: CALLED_FN => 'fa_itc_rates_pkg.load_row',
442: CALLING_FN => 'upload fa_itc_rates'
443: ,p_log_level_rec => p_log_level_rec);
444:
445: end LOAD_ROW;
476:
477: if (x_upload_mode = 'NLS') then
478: null;
479: else
480: fa_itc_rates_pkg.LOAD_ROW (
481: x_custom_mode => x_custom_mode,
482: x_itc_amount_id => x_itc_amount_id,
483: x_owner => x_owner,
484: x_last_update_date => x_last_update_date,
505: end if;
506:
507: END LOAD_SEED_ROW;
508:
509: END FA_ITC_RATES_PKG;