Problems with Oracle Max function usage

When writing another stored procedure, the following SQL statement is used:
Copy codeThe Code is as follows:
Select max (RE_DATE) INTO V_RE_DATE
FROM T_RECORDING
Where id = '000000'

It is reasonable to say that the query result based on this condition should be sqlcode = 1403, But the strange thing is that the following SQL exception is not captured:
Copy codeThe Code is as follows:
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
ERR_CODE: =-2000;
ERR_MSG: = SQLERRM;
RETURN;

No error is returned during execution. If the V_RE_DATE value is found to be null by running the command, the sqlcode = 1405 exception should also be reported since the value is null, however, the oracle execution engine has not reported any error. What is the problem? Write down the problem today and study it later.