199:
200: /***************************************************************************
201: ** Standard call to get message count and if count is > 1, get message info
202: ***************************************************************************/
203: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
204: , p_data => x_msg_data
205: );
206:
207: EXCEPTION
207: EXCEPTION
208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
209: THEN
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
211: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
212: , p_data => x_msg_data
213: );
214: WHEN OTHERS
215: THEN
213: );
214: WHEN OTHERS
215: THEN
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
218: THEN
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
220: , l_api_name
221: );
215: THEN
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
218: THEN
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
220: , l_api_name
221: );
222: END IF;
223: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
219: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
220: , l_api_name
221: );
222: END IF;
223: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
224: , p_data => x_msg_data
225: );
226:
227: END CREATE_GRANTS;
335:
336: /***************************************************************************
337: ** Standard call to get message count and if count is > 1, get message info
338: ***************************************************************************/
339: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
340: , p_data => x_msg_data
341: );
342:
343: EXCEPTION
343: EXCEPTION
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
345: THEN
346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
348: , p_data => x_msg_data
349: );
350: WHEN OTHERS
351: THEN
349: );
350: WHEN OTHERS
351: THEN
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
354: THEN
355: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
356: , l_api_name
357: );
351: THEN
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
354: THEN
355: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
356: , l_api_name
357: );
358: END IF;
359: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
355: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME
356: , l_api_name
357: );
358: END IF;
359: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
360: , p_data => x_msg_data
361: );
362:
363: END UPDATE_GRANTS;