69: EXCEPTION
70: WHEN FND_API.G_EXC_ERROR THEN
71: x_return_status := FND_API.G_RET_STS_ERROR;
72:
73: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE
74: ,p_count => x_msg_count
75: ,p_data => x_msg_data);
76:
77: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
76:
77: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
79:
80: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE
81: ,p_count => x_msg_count
82: ,p_data => x_msg_data);
83:
84: WHEN OTHERS THEN
82: ,p_data => x_msg_data);
83:
84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: fnd_msg_pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
87:
88: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE
89: ,p_count => x_msg_count
90: ,p_data => x_msg_data);
84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: fnd_msg_pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
87:
88: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE
89: ,p_count => x_msg_count
90: ,p_data => x_msg_data);
91:
92: end notify_user_by_email;