APPS.AHL_WF_NOTIFICATION_PVT dependencies on FND_MSG_PUB

Line 193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

189: WHERE resource_id = l_aprvr_resource_id;
190: EXCEPTION
191: WHEN OTHERS THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
194: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
195: p_procedure_name => l_api_name,
196: p_error_text => SUBSTR(SQLERRM,1,500));
197: END IF;

Line 194: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

190: EXCEPTION
191: WHEN OTHERS THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
194: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
195: p_procedure_name => l_api_name,
196: p_error_text => SUBSTR(SQLERRM,1,500));
197: END IF;
198: END;

Line 241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

237: WHERE user_id = FND_GLOBAL.USER_ID;
238: EXCEPTION
239: WHEN OTHERS THEN
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
242: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
243: p_procedure_name => l_api_name,
244: p_error_text => SUBSTR(SQLERRM,1,500));
245: END IF;

Line 242: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

238: EXCEPTION
239: WHEN OTHERS THEN
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
242: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
243: p_procedure_name => l_api_name,
244: p_error_text => SUBSTR(SQLERRM,1,500));
245: END IF;
246: END;