declare _EX_TK_CARDSERIES_FSN_RANGE_OVERFLOW exception for sqlstate '20025';
raiserror _EX_TK_CARDSERIES_FSN_RANGE_OVERFLOW, 'TRG_CardSeriesFSNInsert';

BEGIN
        declare _PROC_NAME long varchar;
        set _PROC_NAME = '...'
begin
                declare _EX_INDEX_NOT_UNIQUE exception for sqlstate '23505';
                declare _EX_TK_CARDSERIES_FSN_RANGE_OVERFLOW exception for sqlstate '20025';
                INSERT INTO Table (...) VALUES (...) 
                exception
                        when _EX_TK_CARDSERIES_FSN_RANGE_OVERFLOW then
                                rollback;
                                ...
                                call EventLogger.PROC_MakeTrace( 6 , _PROC_NAME, errormsg());
                                commit;
                        when _EX_INDEX_NOT_UNIQUE then
                                rollback;
                                ...
                                ...
                                call EventLogger.PROC_MakeTrace( 6 , _PROC_NAME, errormsg());
                                commit;
        end
        exception
                when others then
                        rollback;
                        call EventLogger.PROC_MakeError (_PROC_NAME, errormsg());
                        commit;
                        resignal;
END

declare _EX_TK_CARDSERIES_FSN_RANGE_OVERFLOW exception for sqlstate '20025';
signal _EX_TK_CARDSERIES_FSN_RANGE_OVERFLOW;