230: ** Initialize message list if p_init_msg_list is set to TRUE
231: *****************************************************************************/
232: IF FND_API.To_Boolean(p_init_msg_list)
233: THEN
234: FND_MSG_PUB.Initialize;
235: END IF;
236:
237: /*****************************************************************************
238: ** Initialize API return status to success
381:
382: /*****************************************************************************
383: ** Standard call to get message count and if count is > 1, get message info
384: *****************************************************************************/
385: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
386: , p_data => x_msg_data
387: );
388:
389: EXCEPTION
389: EXCEPTION
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
391: THEN
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
394: , p_data => x_msg_data
395: );
396: WHEN OTHERS
397: THEN
395: );
396: WHEN OTHERS
397: THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
400: THEN
401: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
402: , l_api_name
403: );
397: THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
400: THEN
401: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
402: , l_api_name
403: );
404: END IF;
405: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
401: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
402: , l_api_name
403: );
404: END IF;
405: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
406: , p_data => x_msg_data
407: );
408:
409: END Availability;