384: p_encoded => 'F');
385:
386: WHEN OTHERS THEN
387: ROLLBACK TO CREATE_EMAIL_IH_PVT;
388: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
389: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
390: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
391: FND_MESSAGE.Set_Token('REASON', SQLERRM);
392: FND_MSG_PUB.Add;
385:
386: WHEN OTHERS THEN
387: ROLLBACK TO CREATE_EMAIL_IH_PVT;
388: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
389: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
390: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
391: FND_MESSAGE.Set_Token('REASON', SQLERRM);
392: FND_MSG_PUB.Add;
393:
386: WHEN OTHERS THEN
387: ROLLBACK TO CREATE_EMAIL_IH_PVT;
388: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
389: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
390: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
391: FND_MESSAGE.Set_Token('REASON', SQLERRM);
392: FND_MSG_PUB.Add;
393:
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: ROLLBACK TO CREATE_EMAIL_IH_PVT;
388: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
389: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
390: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
391: FND_MESSAGE.Set_Token('REASON', SQLERRM);
392: FND_MSG_PUB.Add;
393:
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395: