130:
131: EXCEPTION
132: WHEN OTHERS THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
135: THEN
136: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
137: END IF;
138: -- Standard call to get message count and if count=1, get the message
132: WHEN OTHERS THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
135: THEN
136: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
137: END IF;
138: -- Standard call to get message count and if count=1, get the message
139: FND_MSG_PUB.Count_And_Get (
140: p_encoded => FND_API.G_FALSE,
135: THEN
136: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
137: END IF;
138: -- Standard call to get message count and if count=1, get the message
139: FND_MSG_PUB.Count_And_Get (
140: p_encoded => FND_API.G_FALSE,
141: p_count => x_msg_count,
142: p_data => x_msg_data
143: );
268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
273: THEN
274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
275: END IF;
276: -- Standard call to get message count and if count=1, get the message
270: WHEN OTHERS THEN
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
273: THEN
274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
275: END IF;
276: -- Standard call to get message count and if count=1, get the message
277: FND_MSG_PUB.Count_And_Get (
278: p_encoded => FND_API.G_FALSE,
273: THEN
274: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
275: END IF;
276: -- Standard call to get message count and if count=1, get the message
277: FND_MSG_PUB.Count_And_Get (
278: p_encoded => FND_API.G_FALSE,
279: p_count => x_msg_count,
280: p_data => x_msg_data
281: );
525:
526: EXCEPTION
527: WHEN OTHERS THEN
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
530: THEN
531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
532: END IF;
533: -- Standard call to get message count and if count=1, get the message
527: WHEN OTHERS THEN
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
530: THEN
531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
532: END IF;
533: -- Standard call to get message count and if count=1, get the message
534: FND_MSG_PUB.Count_And_Get (
535: p_encoded => FND_API.G_FALSE,
530: THEN
531: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
532: END IF;
533: -- Standard call to get message count and if count=1, get the message
534: FND_MSG_PUB.Count_And_Get (
535: p_encoded => FND_API.G_FALSE,
536: p_count => x_msg_count,
537: p_data => x_msg_data
538: );