46: END IF;
47:
48: --Initialize the message list if p_init_msg_list is set to TRUE
49: If FND_API.to_Boolean(p_init_msg_list) THEN
50: FND_MSG_PUB.initialize;
51: END IF;
52:
53: --Initialize API status return
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
251: EXCEPTION
252: WHEN MOVE_MSG_FAIL THEN
253: ROLLBACK TO delete_queue_msg;
254: x_return_status := FND_API.G_RET_STS_ERROR ;
255: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
256:
257:
258:
259: WHEN FND_API.G_EXC_ERROR THEN
258:
259: WHEN FND_API.G_EXC_ERROR THEN
260: ROLLBACK TO delete_queue_msg;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
262: FND_MSG_PUB.Count_And_Get
263: ( p_count => x_msg_count,p_data => x_msg_data);
264:
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO delete_queue_msg;
264:
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO delete_queue_msg;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
268: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
269:
270: WHEN OTHERS THEN
271: ROLLBACK TO delete_queue_msg;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
269:
270: WHEN OTHERS THEN
271: ROLLBACK TO delete_queue_msg;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
274: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
275: END IF;
276:
277: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
270: WHEN OTHERS THEN
271: ROLLBACK TO delete_queue_msg;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
274: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
275: END IF;
276:
277: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
278:
273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
274: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
275: END IF;
276:
277: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
278:
279: END delete_queue_msg;
280:
281:
312: END IF;
313:
314: --Initialize the message list if p_init_msg_list is set to TRUE
315: If FND_API.to_Boolean(p_init_msg_list) THEN
316: FND_MSG_PUB.initialize;
317: END IF;
318:
319: --Initialize API status return
320: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
351: WHEN FND_API.G_EXC_ERROR THEN
352: ROLLBACK TO delete_queue_msg;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
354: FND_MSG_PUB.Count_And_Get
355: ( p_count => x_msg_count,p_data => x_msg_data);
356:
357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
358: ROLLBACK TO delete_queue_msg;
356:
357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
358: ROLLBACK TO delete_queue_msg;
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
360: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
361:
362: WHEN OTHERS THEN
363: ROLLBACK TO delete_queue_msg;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361:
362: WHEN OTHERS THEN
363: ROLLBACK TO delete_queue_msg;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
366: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
367: END IF;
368:
369: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
362: WHEN OTHERS THEN
363: ROLLBACK TO delete_queue_msg;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
366: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
367: END IF;
368:
369: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
370:
365: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
366: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
367: END IF;
368:
369: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
370:
371: END delete_queue_msg_batch;
372:
373: end IEM_SPV_ACTIONS_PVT ;