77: END IF;
78: -- Initialize message list if p_init_msg_list is set to TRUE.
79: IF FND_API.to_Boolean( p_init_msg_list )
80: THEN
81: FND_MSG_PUB.initialize;
82: END IF;
83:
84: -- Initialize API return status to SUCCESS
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
286: IF FND_API.To_Boolean(p_commit) THEN
287: COMMIT WORK;
288: END IF;
289: -- Standard callto get message count and if count is 1, get message info.
290: FND_MSG_PUB.Count_And_Get
291: ( p_count => x_msg_count,
292: p_data => x_msg_data
293: );
294: EXCEPTION
295:
296: WHEN FND_API.G_EXC_ERROR THEN
297: ROLLBACK TO search_message_pvt;
298: x_return_status := FND_API.G_RET_STS_ERROR ;
299: FND_MSG_PUB.Count_And_Get
300: ( p_count => x_msg_count,
301: p_data => x_msg_data
302: );
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: );
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304: ROLLBACK TO search_message_pvt;
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
306: FND_MSG_PUB.Count_And_Get
307: ( p_count => x_msg_count,
308: p_data => x_msg_data
309: );
310: WHEN OTHERS THEN
309: );
310: WHEN OTHERS THEN
311: ROLLBACK TO search_message_pvt;
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: IF FND_MSG_PUB.Check_Msg_Level
314: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
315: THEN
316: FND_MSG_PUB.Add_Exc_Msg
317: ( G_PKG_NAME,
310: WHEN OTHERS THEN
311: ROLLBACK TO search_message_pvt;
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: IF FND_MSG_PUB.Check_Msg_Level
314: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
315: THEN
316: FND_MSG_PUB.Add_Exc_Msg
317: ( G_PKG_NAME,
318: l_api_name
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: IF FND_MSG_PUB.Check_Msg_Level
314: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
315: THEN
316: FND_MSG_PUB.Add_Exc_Msg
317: ( G_PKG_NAME,
318: l_api_name
319: );
320: END IF;
317: ( G_PKG_NAME,
318: l_api_name
319: );
320: END IF;
321: FND_MSG_PUB.Count_And_Get
322: (p_count => x_msg_count,
323: p_data => x_msg_data
324: );
325:
387: END IF;
388: -- Initialize message list if p_init_msg_list is set to TRUE.
389: IF FND_API.to_Boolean( p_init_msg_list )
390: THEN
391: FND_MSG_PUB.initialize;
392: END IF;
393:
394: -- Initialize API return status to SUCCESS
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
491: IF FND_API.To_Boolean(p_commit) THEN
492: COMMIT WORK;
493: END IF;
494: -- Standard callto get message count and if count is 1, get message info.
495: FND_MSG_PUB.Count_And_Get
496: ( p_count => x_msg_count,
497: p_data => x_msg_data
498: );
499: EXCEPTION
500:
501: WHEN FND_API.G_EXC_ERROR THEN
502: ROLLBACK TO search_message_pvt;
503: x_return_status := FND_API.G_RET_STS_ERROR ;
504: FND_MSG_PUB.Count_And_Get
505: ( p_count => x_msg_count,
506: p_data => x_msg_data
507: );
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
507: );
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509: ROLLBACK TO search_message_pvt;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
511: FND_MSG_PUB.Count_And_Get
512: ( p_count => x_msg_count,
513: p_data => x_msg_data
514: );
515: WHEN OTHERS THEN
514: );
515: WHEN OTHERS THEN
516: ROLLBACK TO search_message_pvt;
517: x_return_status := FND_API.G_RET_STS_ERROR;
518: IF FND_MSG_PUB.Check_Msg_Level
519: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
520: THEN
521: FND_MSG_PUB.Add_Exc_Msg
522: ( G_PKG_NAME,
515: WHEN OTHERS THEN
516: ROLLBACK TO search_message_pvt;
517: x_return_status := FND_API.G_RET_STS_ERROR;
518: IF FND_MSG_PUB.Check_Msg_Level
519: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
520: THEN
521: FND_MSG_PUB.Add_Exc_Msg
522: ( G_PKG_NAME,
523: l_api_name
517: x_return_status := FND_API.G_RET_STS_ERROR;
518: IF FND_MSG_PUB.Check_Msg_Level
519: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
520: THEN
521: FND_MSG_PUB.Add_Exc_Msg
522: ( G_PKG_NAME,
523: l_api_name
524: );
525: END IF;
522: ( G_PKG_NAME,
523: l_api_name
524: );
525: END IF;
526: FND_MSG_PUB.Count_And_Get
527: (p_count => x_msg_count,
528: p_data => x_msg_data
529: );
530:
581: END IF;
582: -- Initialize message list if p_init_msg_list is set to TRUE.
583: IF FND_API.to_Boolean( p_init_msg_list )
584: THEN
585: FND_MSG_PUB.initialize;
586: END IF;
587:
588: -- Initialize API return status to SUCCESS
589: x_return_status := FND_API.G_RET_STS_SUCCESS;
831: IF FND_API.To_Boolean(p_commit) THEN
832: COMMIT WORK;
833: END IF;
834: -- Standard callto get message count and if count is 1, get message info.
835: FND_MSG_PUB.Count_And_Get
836: ( p_count => x_msg_count,
837: p_data => x_msg_data
838: );
839: EXCEPTION
840:
841: WHEN FND_API.G_EXC_ERROR THEN
842: ROLLBACK TO show_agent_list_pvt;
843: x_return_status := FND_API.G_RET_STS_ERROR ;
844: FND_MSG_PUB.Count_And_Get
845: ( p_count => x_msg_count,
846: p_data => x_msg_data
847: );
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
847: );
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: ROLLBACK TO show_agent_list_pvt;
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
851: FND_MSG_PUB.Count_And_Get
852: ( p_count => x_msg_count,
853: p_data => x_msg_data
854: );
855: WHEN OTHERS THEN
854: );
855: WHEN OTHERS THEN
856: ROLLBACK TO show_agent_list_pvt;
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: IF FND_MSG_PUB.Check_Msg_Level
859: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
860: THEN
861: FND_MSG_PUB.Add_Exc_Msg
862: ( G_PKG_NAME,
855: WHEN OTHERS THEN
856: ROLLBACK TO show_agent_list_pvt;
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: IF FND_MSG_PUB.Check_Msg_Level
859: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
860: THEN
861: FND_MSG_PUB.Add_Exc_Msg
862: ( G_PKG_NAME,
863: l_api_name
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: IF FND_MSG_PUB.Check_Msg_Level
859: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
860: THEN
861: FND_MSG_PUB.Add_Exc_Msg
862: ( G_PKG_NAME,
863: l_api_name
864: );
865: END IF;
862: ( G_PKG_NAME,
863: l_api_name
864: );
865: END IF;
866: FND_MSG_PUB.Count_And_Get
867: (p_count => x_msg_count,
868: p_data => x_msg_data
869: );
870: