Oracle Tips: select into …no data found error, and exception handling in PLSQL code

DECLARE
  L_Term_ID NUMBER;
BEGIN
  BEGIN
    SELECT NVL(Term_ID,-1)
    INTO L_Term_ID
    FROM blog_terms
    WHERE UPPER(slug) = UPPER('no data to query')
    AND rownum        = 1 ;
    DBMS_OUTPUT.PUT_LINE(L_Term_ID);
  END;

DECLARE
  L_Term_ID NUMBER;
BEGIN
  BEGIN
    SELECT NVL(Term_ID,-1)
    INTO L_Term_ID
    FROM blog_terms
    WHERE UPPER(slug) = UPPER('no data to query');
    EXCEPTION WHEN NO_DATA_FOUND THEN
    L_Term_ID:= -1;
    EXCEPTION WHEN  TOO_MANY_ROWS THEN
    L_Term_ID:= -1;
  END;
  DBMS_OUTPUT.PUT_LINE(L_Term_ID);
END;