1: PACKAGE BODY FA_DEPRN_SUMMARY_PKG as
2: /* $Header: faxidsb.pls 120.4 2005/07/25 10:01:27 yyoon ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Book_Type_Code VARCHAR2,
156:
157: exception
158: when others then
159: FA_STANDARD_PKG.RAISE_ERROR(
160: CALLED_FN => 'fa_deprn_summary_pkg.insert_row',
161: CALLING_FN => X_Calling_Fn
162: ,p_log_level_rec => p_log_level_rec);
163:
164: END Insert_Row;
674:
675: exception
676: when others then
677: fa_srvr_msg.add_sql_error(
678: calling_fn => 'fa_deprn_summary_pkg.update_row'
679: ,p_log_level_rec => p_log_level_rec);
680: raise;
681:
682: END Update_Row;
722:
723: exception
724: when others then
725: FA_STANDARD_PKG.RAISE_ERROR(
726: CALLED_FN => 'fa_deprn_summary_pkg.delete_row',
727: CALLING_FN => X_Calling_Fn
728: ,p_log_level_rec => p_log_level_rec);
729:
730: END Delete_Row;
931: CLOSE C_DeprnSummary;
932: EXCEPTION
933: when app_exception.record_lock_exception then
934: FA_STANDARD_PKG.RAISE_ERROR(
935: CALLED_FN => 'fa_deprn_summary_pkg.lock_b_row',
936: CALLING_FN => X_Calling_Fn,
937: NAME => 'FA_SHARED_ASSETS_LOCKED'
938: ,p_log_level_rec => p_log_level_rec);
939: when others then
937: NAME => 'FA_SHARED_ASSETS_LOCKED'
938: ,p_log_level_rec => p_log_level_rec);
939: when others then
940: FA_STANDARD_PKG.RAISE_ERROR(
941: CALLED_FN => 'fa_deprn_summary_pkg.lock_b_row',
942: CALLING_FN => X_Calling_Fn
943: ,p_log_level_rec => p_log_level_rec);
944: END Lock_B_Row;
945:
952:
953: EXCEPTION
954: when others then
955: FA_STANDARD_PKG.RAISE_ERROR(
956: CALLED_FN => 'fa_deprn_summary_pkg.unlock_b_row',
957: CALLING_FN => X_Calling_Fn
958: ,p_log_level_rec => p_log_level_rec);
959: END UnLock_B_Row;
960:
957: CALLING_FN => X_Calling_Fn
958: ,p_log_level_rec => p_log_level_rec);
959: END UnLock_B_Row;
960:
961: END FA_DEPRN_SUMMARY_PKG;