DBA Data[Home] [Help]

APPS.IEM_AGENT_INBOX_MGMT_PVT dependencies on FND_MSG_PUB

Line 81: FND_MSG_PUB.initialize;

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;

Line 290: FND_MSG_PUB.Count_And_Get

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

Line 299: FND_MSG_PUB.Count_And_Get

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

Line 306: FND_MSG_PUB.Count_And_Get

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

Line 313: IF FND_MSG_PUB.Check_Msg_Level

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,

Line 314: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 316: FND_MSG_PUB.Add_Exc_Msg

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;

Line 321: FND_MSG_PUB.Count_And_Get

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:

Line 391: FND_MSG_PUB.initialize;

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;

Line 495: FND_MSG_PUB.Count_And_Get

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

Line 504: FND_MSG_PUB.Count_And_Get

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

Line 511: FND_MSG_PUB.Count_And_Get

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

Line 518: IF FND_MSG_PUB.Check_Msg_Level

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,

Line 519: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 521: FND_MSG_PUB.Add_Exc_Msg

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;

Line 526: FND_MSG_PUB.Count_And_Get

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:

Line 585: FND_MSG_PUB.initialize;

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;

Line 835: FND_MSG_PUB.Count_And_Get

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

Line 844: FND_MSG_PUB.Count_And_Get

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

Line 851: FND_MSG_PUB.Count_And_Get

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

Line 858: IF FND_MSG_PUB.Check_Msg_Level

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,

Line 859: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 861: FND_MSG_PUB.Add_Exc_Msg

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;

Line 866: FND_MSG_PUB.Count_And_Get

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: