java.sql.SQLException: ORA-01008: not all variables bound

SELECT DATE_TRAITEMENT, DATE_DEB_PERIODE, DATE_FIN_PERIODE,user_cdg,canal,motif,SUJET_CRM,MODE_generation, TRAIT_STATUS,REMARK FROM  ACM.CDG_REQUEST_OnDEMAND where   CO_ID = :coId and (MODE_GENERATION= :mode or (MODE_GENERATION is null and :mode is null))  order by DATE_TRAITEMENT asc

Session session = HibernateUtil.currentSession();
    SQLQuery query = null;
    org.hibernate.Transaction tx = session.beginTransaction();
    String sql = cdg.getMessage("REQ001");
    query = session.createSQLQuery(sql);
    query.setLong("coId", coId);
    if(integer != null) {
    query.setInteger("mode", integer);
         }
    query.executeUpdate();