204: --+
205: -- Initialize message list if p_init_msg_list is set to TRUE.
206: -- +
207: IF FND_API.to_Boolean( p_init_msg_list ) THEN
208: FND_MSG_PUB.initialize;
209: END IF;
210: -- +
211: -- Initialize API return status to success
212: -- +
234:
235: -- +
236: -- Standard Call to get Message count if count > 1 get message
237: -- +
238: FND_MSG_PUB.count_and_get
239: (
240: p_count => x_msg_count ,
241: p_data => x_msg_data ,
242: p_encoded => FND_API.G_FALSE
245: EXCEPTION
246: WHEN FND_API.G_EXC_ERROR THEN
247: ROLLBACK TO cn_obj_tables ;
248: x_return_status := FND_API.G_RET_STS_ERROR ;
249: FND_MSG_PUB.Count_And_Get
250: (
251: p_count => x_msg_count ,
252: p_data => x_msg_data ,
253: p_encoded => FND_API.G_FALSE
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: ROLLBACK TO cn_obj_tables ;
257: x_loading_status := 'UNEXPECTED_ERR';
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
259: FND_MSG_PUB.Count_And_Get
260: (
261: p_count => x_msg_count ,
262: p_data => x_msg_data ,
263: p_encoded => FND_API.G_FALSE
265: WHEN OTHERS THEN
266: ROLLBACK TO cn_obj_tables ;
267: x_loading_status := 'UNEXPECTED_ERR';
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
269: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
270: THEN
271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
272: END IF;
273: FND_MSG_PUB.Count_And_Get
267: x_loading_status := 'UNEXPECTED_ERR';
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
269: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
270: THEN
271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
272: END IF;
273: FND_MSG_PUB.Count_And_Get
274: (
275: p_count => x_msg_count ,
269: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
270: THEN
271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
272: END IF;
273: FND_MSG_PUB.Count_And_Get
274: (
275: p_count => x_msg_count ,
276: p_data => x_msg_data ,
277: p_encoded => FND_API.G_FALSE