i have an requirement to send mail from a stored procedure when there is an any error faced inside the stored procedure .
You cannot send mail from a SQL stored procedure, or from a macro.
You can send mail from a External Stored Procedure written in either C or Java. There is an example showing how to send mail listed in the Teradata Database Reference / SQL External Routine Programming / Appendix B: External Stored Procedure Code Examples.
You have another option provided you have a viewpoint server available and have configured it correctly to send mail which I would assume you do.
Here is the user guide:
Check the section "About Alerts in Teradata Database" for more interesting and useful examples.