109: --+
110: -- Initialize message list if p_init_msg_list is set to TRUE.
111: --+
112: IF FND_API.to_Boolean( p_init_msg_list ) THEN
113: FND_MSG_PUB.initialize;
114: END IF;
115:
116: --+
117: -- Initialize API return status to success
304:
305: EXCEPTION
306: WHEN FND_API.G_EXC_ERROR THEN
307: x_return_status := FND_API.G_RET_STS_ERROR ;
308: FND_MSG_PUB.Count_And_Get
309: (
310: p_count => x_msg_count ,
311: p_data => x_msg_data ,
312: p_encoded => FND_API.G_FALSE
313: );
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: x_loading_status := 'UNEXPECTED_ERR';
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
317: FND_MSG_PUB.Count_And_Get
318: (
319: p_count => x_msg_count ,
320: p_data => x_msg_data ,
321: p_encoded => FND_API.G_FALSE
322: );
323: WHEN OTHERS THEN
324: x_loading_status := 'UNEXPECTED_ERR';
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
326: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
327: THEN
328: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
329: END IF;
330: FND_MSG_PUB.Count_And_Get
324: x_loading_status := 'UNEXPECTED_ERR';
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
326: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
327: THEN
328: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
329: END IF;
330: FND_MSG_PUB.Count_And_Get
331: (
332: p_count => x_msg_count ,
326: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
327: THEN
328: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
329: END IF;
330: FND_MSG_PUB.Count_And_Get
331: (
332: p_count => x_msg_count ,
333: p_data => x_msg_data ,
334: p_encoded => FND_API.G_FALSE