select max value of a column in table with no rows

SELECT COALESCE(MAX(ROUTE_ID),0) ...

This is not a safe way of creating an auto-increment field. You can use an Oracle sequence to achieve this goal.

As for the null, you can use NVL to give a default value (say, 0) in case the function returns null.