APPS.OKC_CDRL_PVT dependencies on FND_MSG_PUB

Line 273: FND_MSG_PUB.initialize;

269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271: -- Initialize message list if p_init_msg_list is set to TRUE.
272: IF FND_API.to_Boolean( p_init_msg_list ) THEN
273: FND_MSG_PUB.initialize;
274: END IF;
275:
276: -- Initialize API return status to success
277: x_return_status := G_RET_STS_SUCCESS;

Line 735: FND_MSG_PUB.initialize;

731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733: -- Initialize message list if p_init_msg_list is set to TRUE.
734: IF FND_API.to_Boolean( p_init_msg_list ) THEN
735: FND_MSG_PUB.initialize;
736: END IF;
737: -- Initialize API return status to success
738: x_return_status := G_RET_STS_SUCCESS;
739:

Line 838: FND_MSG_PUB.Count_And_Get(

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

Line 851: FND_MSG_PUB.Count_And_Get(

847: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving create_exhibit_for_cdrl with G_EXC_UNEXPECTED_ERROR ');
848: END IF;
849:
850: x_return_status := 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:

Line 864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

860: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving create_exhibit_for_cdrl with OTHERS EXCEPTION '||SQLERRM);
861: END IF;
862:
863: x_return_status := G_RET_STS_UNEXP_ERROR;
864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
865: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
866: END IF;
867: FND_MSG_PUB.Count_And_Get(
868: p_count => x_msg_count,

Line 865: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

861: END IF;
862:
863: x_return_status := G_RET_STS_UNEXP_ERROR;
864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
865: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
866: END IF;
867: FND_MSG_PUB.Count_And_Get(
868: p_count => x_msg_count,
869: p_data => x_msg_data

Line 867: FND_MSG_PUB.Count_And_Get(

863: x_return_status := G_RET_STS_UNEXP_ERROR;
864: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
865: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
866: END IF;
867: FND_MSG_PUB.Count_And_Get(
868: p_count => x_msg_count,
869: p_data => x_msg_data
870: );
871: END create_exhibit_for_cdrl;

Line 940: FND_MSG_PUB.initialize;

936: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
937: END IF;
938: -- Initialize message list if p_init_msg_list is set to TRUE.
939: IF FND_API.to_Boolean( p_init_msg_list ) THEN
940: FND_MSG_PUB.initialize;
941: END IF;
942: -- Initialize API return status to success
943: x_return_status := G_RET_STS_SUCCESS;
944:

Line 1040: FND_MSG_PUB.Count_And_Get(

1036: END IF;
1037:
1038:
1039: x_return_status := G_RET_STS_ERROR;
1040: FND_MSG_PUB.Count_And_Get(
1041: p_count => x_msg_count,
1042: p_data => x_msg_data
1043: );
1044:

Line 1053: FND_MSG_PUB.Count_And_Get(

1049: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving delete_exhibit_for_cdrl with G_EXC_UNEXPECTED_ERROR ');
1050: END IF;
1051:
1052: x_return_status := G_RET_STS_UNEXP_ERROR;
1053: FND_MSG_PUB.Count_And_Get(
1054: p_count => x_msg_count,
1055: p_data => x_msg_data
1056: );
1057:

Line 1066: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1062: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'100: leaving delete_exhibit_for_cdrl with OTHERS EXCEPTION '||SQLERRM);
1063: END IF;
1064:
1065: x_return_status := G_RET_STS_UNEXP_ERROR;
1066: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1067: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1068: END IF;
1069: FND_MSG_PUB.Count_And_Get(
1070: p_count => x_msg_count,

Line 1067: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

1063: END IF;
1064:
1065: x_return_status := G_RET_STS_UNEXP_ERROR;
1066: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1067: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1068: END IF;
1069: FND_MSG_PUB.Count_And_Get(
1070: p_count => x_msg_count,
1071: p_data => x_msg_data

Line 1069: FND_MSG_PUB.Count_And_Get(

1065: x_return_status := G_RET_STS_UNEXP_ERROR;
1066: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1067: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1068: END IF;
1069: FND_MSG_PUB.Count_And_Get(
1070: p_count => x_msg_count,
1071: p_data => x_msg_data
1072: );
1073: END delete_exhibit_for_cdrl;

Line 1313: FND_MSG_PUB.initialize;

1309: END IF;
1310:
1311: -- Initialize message list if p_init_msg_list is set to TRUE.
1312: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1313: FND_MSG_PUB.initialize;
1314: END IF;
1315:
1316: -- Initialize API return status to success
1317: x_return_status := G_RET_STS_SUCCESS;

Line 1455: FND_MSG_PUB.initialize;

1451: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1452: END IF;
1453: -- Initialize message list if p_init_msg_list is set to TRUE.
1454: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1455: FND_MSG_PUB.initialize;
1456: END IF;
1457:
1458: -- Initialize API return status to success
1459: x_return_status := G_RET_STS_SUCCESS;

Line 1665: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1661: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving SPECIFY_EXHIBITS_FOR_CDRLS:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1662: END IF;
1663: x_return_status := G_RET_STS_UNEXP_ERROR ;
1664:
1665: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1666: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1667: END IF;
1668:
1669: WHEN OTHERS THEN

Line 1666: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1662: END IF;
1663: x_return_status := G_RET_STS_UNEXP_ERROR ;
1664:
1665: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1666: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1667: END IF;
1668:
1669: WHEN OTHERS THEN
1670: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1674: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

1670: x_return_status := G_RET_STS_UNEXP_ERROR;
1671: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1672: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving SPECIFY_EXHIBITS_FOR_CDRLS: Exception '|| SQLERRM); END IF;
1673:
1674: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1675: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1676: END IF;
1677: ROLLBACK TO g_specify_exhibit;
1678: END specify_exhibits_for_cdrls;

Line 1675: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

1671: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1672: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving SPECIFY_EXHIBITS_FOR_CDRLS: Exception '|| SQLERRM); END IF;
1673:
1674: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1675: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
1676: END IF;
1677: ROLLBACK TO g_specify_exhibit;
1678: END specify_exhibits_for_cdrls;
1679:

Line 1768: FND_MSG_PUB.initialize;

1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765: END IF;
1766: -- Initialize message list if p_init_msg_list is set to TRUE.
1767: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1768: FND_MSG_PUB.initialize;
1769: END IF;
1770:
1771: -- Initialize API return status to success
1772: x_return_status := G_RET_STS_SUCCESS;

Line 1945: FND_MSG_PUB.initialize;

1941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1942: END IF;
1943: -- Initialize message list if p_init_msg_list is set to TRUE.
1944: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1945: FND_MSG_PUB.initialize;
1946: END IF;
1947:
1948: -- Initialize API return status to success
1949: x_return_status := G_RET_STS_SUCCESS;