Question: when others then null exception?
Answer: As Prakhar at comment#1 points out, WHEN OTHERS THEN NULL suppresses any error that might occur in the procedure. If the exception handler were not there, then in case something goes wrong with the code – say, a duplicate record is inserted which violates a unique constraint – an error will be raised.