The following sql statement is used when writing another stored procedure

SELECT MAX(RE_DATE) INTO V_RE_DATE
FROM T_RECORDING
WHERE ID ='100010010102'

Supposedly, the result of the query based on this condition should be sqlcode=1403, but strangely, the following sql exception is not caught:

EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
ERR_CODE :=-2000;
ERR_MSG :=SQLERRM;
RETURN ;

No error is returned during the execution. When checking the value of V_RE_DATE through the execution, it is found that the value is null, so if the value is null, it should also report an exception of sqlcode=1405. But the oracle execution engine did not report any error.