A SELECT INTO query that fires an exception still returns data, is that common?

Hello I have the below query. The original query selected several columns so I removed them to make it easier to read. One of the SELECT columns calls the TO_CHAR function to format a phone number '1234567890' into '123-456-7890'. I had an scenario where that field contained non-numeric characters so it raised the exception and wrote it to an error log. I understood that when an exception occurs, the query would not return anything into the variables. However I noticed that the columns preceding the TO_CHAR in the SELECT statement did return values but the ones after the function did