159: EXCEPTION
160:
161: WHEN FND_API.G_EXC_ERROR THEN
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
164: p_data => x_msg_data );
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
163: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
164: p_data => x_msg_data );
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
167: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
168: p_data => x_msg_data );
169: WHEN OTHERS THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: IF FND_MSG_PUB.Check_Msg_Level
167: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
168: p_data => x_msg_data );
169: WHEN OTHERS THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: IF FND_MSG_PUB.Check_Msg_Level
172: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
173: THEN
174: FND_MSG_PUB.Add_Exc_Msg
175: (G_FILE_NAME,
168: p_data => x_msg_data );
169: WHEN OTHERS THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: IF FND_MSG_PUB.Check_Msg_Level
172: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
173: THEN
174: FND_MSG_PUB.Add_Exc_Msg
175: (G_FILE_NAME,
176: G_PKG_NAME,
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: IF FND_MSG_PUB.Check_Msg_Level
172: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
173: THEN
174: FND_MSG_PUB.Add_Exc_Msg
175: (G_FILE_NAME,
176: G_PKG_NAME,
177: l_api_name);
178: END IF;
176: G_PKG_NAME,
177: l_api_name);
178: END IF;
179:
180: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
181: p_data => x_msg_data );
182:
183: END;
184: END;