DBA Data[Home] [Help]

APPS.IEM_QUEUE_MANAGEMENT_PVT dependencies on FND_MSG_PUB

Line 76: FND_MSG_PUB.initialize;

72: END IF;
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF FND_API.to_Boolean( p_init_msg_list )
75: THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78:
79: -- Initialize API return status to SUCCESS
80: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 308: FND_MSG_PUB.Count_And_Get

304: IF FND_API.To_Boolean(p_commit) THEN
305: COMMIT WORK;
306: END IF;
307: -- Standard callto get message count and if count is 1, get message info.
308: FND_MSG_PUB.Count_And_Get
309: ( p_count => x_msg_count,
310: p_data => x_msg_data
311: );
312: EXCEPTION

Line 317: FND_MSG_PUB.Count_And_Get

313:
314: WHEN FND_API.G_EXC_ERROR THEN
315: ROLLBACK TO search_message_pvt;
316: x_return_status := FND_API.G_RET_STS_ERROR ;
317: FND_MSG_PUB.Count_And_Get
318: ( p_count => x_msg_count,
319: p_data => x_msg_data
320: );
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 324: FND_MSG_PUB.Count_And_Get

320: );
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322: ROLLBACK TO search_message_pvt;
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
324: FND_MSG_PUB.Count_And_Get
325: ( p_count => x_msg_count,
326: p_data => x_msg_data
327: );
328: WHEN OTHERS THEN

Line 331: IF FND_MSG_PUB.Check_Msg_Level

327: );
328: WHEN OTHERS THEN
329: ROLLBACK TO search_message_pvt;
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: IF FND_MSG_PUB.Check_Msg_Level
332: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: FND_MSG_PUB.Add_Exc_Msg
335: ( G_PKG_NAME,

Line 332: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

328: WHEN OTHERS THEN
329: ROLLBACK TO search_message_pvt;
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: IF FND_MSG_PUB.Check_Msg_Level
332: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: FND_MSG_PUB.Add_Exc_Msg
335: ( G_PKG_NAME,
336: l_api_name

Line 334: FND_MSG_PUB.Add_Exc_Msg

330: x_return_status := FND_API.G_RET_STS_ERROR;
331: IF FND_MSG_PUB.Check_Msg_Level
332: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: FND_MSG_PUB.Add_Exc_Msg
335: ( G_PKG_NAME,
336: l_api_name
337: );
338: END IF;

Line 339: FND_MSG_PUB.Count_And_Get

335: ( G_PKG_NAME,
336: l_api_name
337: );
338: END IF;
339: FND_MSG_PUB.Count_And_Get
340: (p_count => x_msg_count,
341: p_data => x_msg_data
342: );
343:

Line 408: FND_MSG_PUB.initialize;

404: END IF;
405: -- Initialize message list if p_init_msg_list is set to TRUE.
406: IF FND_API.to_Boolean( p_init_msg_list )
407: THEN
408: FND_MSG_PUB.initialize;
409: END IF;
410:
411: -- Initialize API return status to SUCCESS
412: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 515: FND_MSG_PUB.Count_And_Get

511: IF FND_API.To_Boolean(p_commit) THEN
512: COMMIT WORK;
513: END IF;
514: -- Standard callto get message count and if count is 1, get message info.
515: FND_MSG_PUB.Count_And_Get
516: ( p_count => x_msg_count,
517: p_data => x_msg_data
518: );
519: EXCEPTION

Line 524: FND_MSG_PUB.Count_And_Get

520:
521: WHEN FND_API.G_EXC_ERROR THEN
522: ROLLBACK TO get_total_count_pvt;
523: x_return_status := FND_API.G_RET_STS_ERROR ;
524: FND_MSG_PUB.Count_And_Get
525: ( p_count => x_msg_count,
526: p_data => x_msg_data
527: );
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 531: FND_MSG_PUB.Count_And_Get

527: );
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: ROLLBACK TO get_total_count_pvt;
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
531: FND_MSG_PUB.Count_And_Get
532: ( p_count => x_msg_count,
533: p_data => x_msg_data
534: );
535: WHEN OTHERS THEN

Line 538: IF FND_MSG_PUB.Check_Msg_Level

534: );
535: WHEN OTHERS THEN
536: ROLLBACK TO get_total_count_pvt;
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: IF FND_MSG_PUB.Check_Msg_Level
539: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
540: THEN
541: FND_MSG_PUB.Add_Exc_Msg
542: ( G_PKG_NAME,

Line 539: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

535: WHEN OTHERS THEN
536: ROLLBACK TO get_total_count_pvt;
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: IF FND_MSG_PUB.Check_Msg_Level
539: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
540: THEN
541: FND_MSG_PUB.Add_Exc_Msg
542: ( G_PKG_NAME,
543: l_api_name

Line 541: FND_MSG_PUB.Add_Exc_Msg

537: x_return_status := FND_API.G_RET_STS_ERROR;
538: IF FND_MSG_PUB.Check_Msg_Level
539: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
540: THEN
541: FND_MSG_PUB.Add_Exc_Msg
542: ( G_PKG_NAME,
543: l_api_name
544: );
545: END IF;

Line 546: FND_MSG_PUB.Count_And_Get

542: ( G_PKG_NAME,
543: l_api_name
544: );
545: END IF;
546: FND_MSG_PUB.Count_And_Get
547: (p_count => x_msg_count,
548: p_data => x_msg_data
549: );
550:

Line 600: FND_MSG_PUB.initialize;

596: END IF;
597: -- Initialize message list if p_init_msg_list is set to TRUE.
598: IF FND_API.to_Boolean( p_init_msg_list )
599: THEN
600: FND_MSG_PUB.initialize;
601: END IF;
602:
603: -- Initialize API return status to SUCCESS
604: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 808: FND_MSG_PUB.Count_And_Get

804: IF FND_API.To_Boolean(p_commit) THEN
805: COMMIT WORK;
806: END IF;
807: -- Standard callto get message count and if count is 1, get message info.
808: FND_MSG_PUB.Count_And_Get
809: ( p_count => x_msg_count,
810: p_data => x_msg_data
811: );
812: EXCEPTION

Line 817: FND_MSG_PUB.Count_And_Get

813:
814: WHEN FND_API.G_EXC_ERROR THEN
815: ROLLBACK TO show_agent_list_pvt;
816: x_return_status := FND_API.G_RET_STS_ERROR ;
817: FND_MSG_PUB.Count_And_Get
818: ( p_count => x_msg_count,
819: p_data => x_msg_data
820: );
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 824: FND_MSG_PUB.Count_And_Get

820: );
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822: ROLLBACK TO show_agent_list_pvt;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824: FND_MSG_PUB.Count_And_Get
825: ( p_count => x_msg_count,
826: p_data => x_msg_data
827: );
828: WHEN OTHERS THEN

Line 831: IF FND_MSG_PUB.Check_Msg_Level

827: );
828: WHEN OTHERS THEN
829: ROLLBACK TO show_agent_list_pvt;
830: x_return_status := FND_API.G_RET_STS_ERROR;
831: IF FND_MSG_PUB.Check_Msg_Level
832: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
833: THEN
834: FND_MSG_PUB.Add_Exc_Msg
835: ( G_PKG_NAME,

Line 832: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

828: WHEN OTHERS THEN
829: ROLLBACK TO show_agent_list_pvt;
830: x_return_status := FND_API.G_RET_STS_ERROR;
831: IF FND_MSG_PUB.Check_Msg_Level
832: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
833: THEN
834: FND_MSG_PUB.Add_Exc_Msg
835: ( G_PKG_NAME,
836: l_api_name

Line 834: FND_MSG_PUB.Add_Exc_Msg

830: x_return_status := FND_API.G_RET_STS_ERROR;
831: IF FND_MSG_PUB.Check_Msg_Level
832: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
833: THEN
834: FND_MSG_PUB.Add_Exc_Msg
835: ( G_PKG_NAME,
836: l_api_name
837: );
838: END IF;

Line 839: FND_MSG_PUB.Count_And_Get

835: ( G_PKG_NAME,
836: l_api_name
837: );
838: END IF;
839: FND_MSG_PUB.Count_And_Get
840: (p_count => x_msg_count,
841: p_data => x_msg_data
842: );
843:

Line 890: FND_MSG_PUB.initialize;

886: END IF;
887: -- Initialize message list if p_init_msg_list is set to TRUE.
888: IF FND_API.to_Boolean( p_init_msg_list )
889: THEN
890: FND_MSG_PUB.initialize;
891: END IF;
892:
893: -- Initialize API return status to SUCCESS
894: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1082: FND_MSG_PUB.Count_And_Get

1078: IF FND_API.To_Boolean(p_commit) THEN
1079: COMMIT WORK;
1080: END IF;
1081: -- Standard callto get message count and if count is 1, get message info.
1082: FND_MSG_PUB.Count_And_Get
1083: ( p_count => x_msg_count,
1084: p_data => x_msg_data
1085: );
1086: EXCEPTION

Line 1091: FND_MSG_PUB.Count_And_Get

1087:
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: ROLLBACK TO show_resource_group_list_pvt;
1090: x_return_status := FND_API.G_RET_STS_ERROR ;
1091: FND_MSG_PUB.Count_And_Get
1092: ( p_count => x_msg_count,
1093: p_data => x_msg_data
1094: );
1095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1098: FND_MSG_PUB.Count_And_Get

1094: );
1095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1096: ROLLBACK TO show_resource_group_list_pvt;
1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1098: FND_MSG_PUB.Count_And_Get
1099: ( p_count => x_msg_count,
1100: p_data => x_msg_data
1101: );
1102: WHEN OTHERS THEN

Line 1105: IF FND_MSG_PUB.Check_Msg_Level

1101: );
1102: WHEN OTHERS THEN
1103: ROLLBACK TO show_resource_group_list_pvt;
1104: x_return_status := FND_API.G_RET_STS_ERROR;
1105: IF FND_MSG_PUB.Check_Msg_Level
1106: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1107: THEN
1108: FND_MSG_PUB.Add_Exc_Msg
1109: ( G_PKG_NAME,

Line 1106: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1102: WHEN OTHERS THEN
1103: ROLLBACK TO show_resource_group_list_pvt;
1104: x_return_status := FND_API.G_RET_STS_ERROR;
1105: IF FND_MSG_PUB.Check_Msg_Level
1106: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1107: THEN
1108: FND_MSG_PUB.Add_Exc_Msg
1109: ( G_PKG_NAME,
1110: l_api_name

Line 1108: FND_MSG_PUB.Add_Exc_Msg

1104: x_return_status := FND_API.G_RET_STS_ERROR;
1105: IF FND_MSG_PUB.Check_Msg_Level
1106: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1107: THEN
1108: FND_MSG_PUB.Add_Exc_Msg
1109: ( G_PKG_NAME,
1110: l_api_name
1111: );
1112: END IF;

Line 1113: FND_MSG_PUB.Count_And_Get

1109: ( G_PKG_NAME,
1110: l_api_name
1111: );
1112: END IF;
1113: FND_MSG_PUB.Count_And_Get
1114: (p_count => x_msg_count,
1115: p_data => x_msg_data
1116: );
1117: