DBA Data[Home] [Help]

APPS.CSC_PROFILE_VARIABLE_PVT dependencies on FND_MSG_PUB

Line 531: FND_MSG_PUB.Initialize;

527:
528: -- Initialize message list if p_init_msg_list is set to TRUE
529: IF FND_API.To_Boolean(p_init_msg_list)
530: THEN
531: FND_MSG_PUB.Initialize;
532: END IF;
533:
534:
535: -- Initialize API return status to success

Line 648: FND_MSG_PUB.Count_And_Get(

644: END IF;
645:
646: -- Standard call to get message count and if count is 1, get message info
647:
648: FND_MSG_PUB.Count_And_Get(
649: p_encoded => FND_API.G_FALSE,
650: p_count => x_msg_count,
651: p_data => x_msg_data );
652:

Line 658: /* FND_MSG_PUB.Count_And_Get

654: EXCEPTION
655: WHEN FND_API.G_EXC_ERROR THEN
656: ROLLBACK TO Create_Profile_Variable_PVT;
657: x_return_status := FND_API.G_RET_STS_ERROR;
658: /* FND_MSG_PUB.Count_And_Get
659: ( p_encoded => FND_API.G_FALSE,
660: p_count => x_msg_count,
661: p_data => x_msg_data
662: ); */

Line 667: /* FND_MSG_PUB.Count_And_Get

663: APP_EXCEPTION.RAISE_EXCEPTION;
664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
665: ROLLBACK TO Create_Profile_Variable_PVT;
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: /* FND_MSG_PUB.Count_And_Get
668: ( p_encoded => FND_API.G_FALSE,
669: p_count => x_msg_count,
670: p_data => x_msg_data
671: ); */

Line 676: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

672: APP_EXCEPTION.RAISE_EXCEPTION;
673: WHEN OTHERS THEN
674: ROLLBACK TO Create_Profile_Variable_PVT;
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
677: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
678: -- END IF;
679: FND_MSG_PUB.Build_Exc_Msg;
680: /* FND_MSG_PUB.Count_And_Get

Line 677: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

673: WHEN OTHERS THEN
674: ROLLBACK TO Create_Profile_Variable_PVT;
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
677: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
678: -- END IF;
679: FND_MSG_PUB.Build_Exc_Msg;
680: /* FND_MSG_PUB.Count_And_Get
681: ( p_encoded => FND_API.G_FALSE,

Line 679: FND_MSG_PUB.Build_Exc_Msg;

675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
677: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
678: -- END IF;
679: FND_MSG_PUB.Build_Exc_Msg;
680: /* FND_MSG_PUB.Count_And_Get
681: ( p_encoded => FND_API.G_FALSE,
682: p_count => x_msg_count,
683: p_data => x_msg_data

Line 680: /* FND_MSG_PUB.Count_And_Get

676: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
677: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
678: -- END IF;
679: FND_MSG_PUB.Build_Exc_Msg;
680: /* FND_MSG_PUB.Count_And_Get
681: ( p_encoded => FND_API.G_FALSE,
682: p_count => x_msg_count,
683: p_data => x_msg_data
684: ); */

Line 786: FND_MSG_PUB.initialize;

782:
783: -- Initialize message list if p_init_msg_list is set to TRUE.
784: IF FND_API.to_Boolean( p_init_msg_list )
785: THEN
786: FND_MSG_PUB.initialize;
787: END IF;
788:
789: -- Initialize API return status to SUCCESS
790: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 856: FND_MSG_PUB.Count_And_Get(

852: END IF;
853:
854:
855: -- Standard call to get message count and if count is 1, get message info.
856: FND_MSG_PUB.Count_And_Get(
857: p_count => x_msg_count,
858: p_data => x_msg_data);
859:
860: EXCEPTION

Line 864: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

860: EXCEPTION
861: WHEN FND_API.G_EXC_ERROR THEN
862: ROLLBACK TO CREATE_Table_Column_PVT;
863: x_return_status := FND_API.G_RET_STS_ERROR ;
864: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
865: p_data => x_msg_data) ;
866: APP_EXCEPTION.RAISE_EXCEPTION;
867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
868: ROLLBACK TO CREATE_Table_Column_PVT;

Line 870: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

866: APP_EXCEPTION.RAISE_EXCEPTION;
867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
868: ROLLBACK TO CREATE_Table_Column_PVT;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
870: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
871: p_data => x_msg_data) ;
872: APP_EXCEPTION.RAISE_EXCEPTION;
873: WHEN OTHERS THEN
874: ROLLBACK TO CREATE_Table_Column_PVT;

Line 876: --IF FND_MSG_PUB.Check_Msg_Level

872: APP_EXCEPTION.RAISE_EXCEPTION;
873: WHEN OTHERS THEN
874: ROLLBACK TO CREATE_Table_Column_PVT;
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
876: --IF FND_MSG_PUB.Check_Msg_Level
877: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
878: --THEN
879: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
880: --END IF ;

Line 877: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

873: WHEN OTHERS THEN
874: ROLLBACK TO CREATE_Table_Column_PVT;
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
876: --IF FND_MSG_PUB.Check_Msg_Level
877: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
878: --THEN
879: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
880: --END IF ;
881: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

Line 879: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
876: --IF FND_MSG_PUB.Check_Msg_Level
877: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
878: --THEN
879: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
880: --END IF ;
881: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
882: p_data => x_msg_data) ;
883: APP_EXCEPTION.RAISE_EXCEPTION;

Line 881: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

877: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
878: --THEN
879: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
880: --END IF ;
881: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
882: p_data => x_msg_data) ;
883: APP_EXCEPTION.RAISE_EXCEPTION;
884: End Create_table_column;
885:

Line 1030: FND_MSG_PUB.initialize ;

1026:
1027:
1028: -- Initialize the message list if p_msg_list is set to TRUE
1029: IF FND_API.To_Boolean(p_init_msg_list) THEN
1030: FND_MSG_PUB.initialize ;
1031: END IF ;
1032:
1033:
1034: -- Initialize the API Return Success to True

Line 1173: FND_MSG_PUB.Count_And_Get(

1169: COMMIT WORK;
1170: END IF;
1171:
1172: -- Standard call to get message count and if count is 1, get message info
1173: FND_MSG_PUB.Count_And_Get(
1174: p_count => x_msg_count,
1175: p_data => x_msg_data );
1176: EXCEPTION
1177: WHEN FND_API.G_EXC_ERROR THEN

Line 1180: --FND_MSG_PUB.Count_And_Get

1176: EXCEPTION
1177: WHEN FND_API.G_EXC_ERROR THEN
1178: ROLLBACK TO Update_Profile_Variable_Pvt;
1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180: --FND_MSG_PUB.Count_And_Get
1181: -- ( p_count => x_msg_count,
1182: -- p_data => x_msg_data );
1183: APP_EXCEPTION.RAISE_EXCEPTION;
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1187: --FND_MSG_PUB.Count_And_Get

1183: APP_EXCEPTION.RAISE_EXCEPTION;
1184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1185: ROLLBACK TO Update_Profile_Variable_Pvt;
1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1187: --FND_MSG_PUB.Count_And_Get
1188: -- ( p_count => x_msg_count,
1189: -- p_data => x_msg_data );
1190: APP_EXCEPTION.RAISE_EXCEPTION;
1191: WHEN OTHERS THEN

Line 1194: -- FND_MSG_PUB.Count_And_Get

1190: APP_EXCEPTION.RAISE_EXCEPTION;
1191: WHEN OTHERS THEN
1192: ROLLBACK TO Update_Profile_Variable_Pvt;
1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1194: -- FND_MSG_PUB.Count_And_Get
1195: -- ( p_count => x_msg_count,
1196: -- p_data => x_msg_data );
1197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1198: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);

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

1193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1194: -- FND_MSG_PUB.Count_And_Get
1195: -- ( p_count => x_msg_count,
1196: -- p_data => x_msg_data );
1197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1198: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
1199: END IF;
1200: APP_EXCEPTION.RAISE_EXCEPTION;
1201: END Update_Profile_Variable;

Line 1198: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);

1194: -- FND_MSG_PUB.Count_And_Get
1195: -- ( p_count => x_msg_count,
1196: -- p_data => x_msg_data );
1197: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1198: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
1199: END IF;
1200: APP_EXCEPTION.RAISE_EXCEPTION;
1201: END Update_Profile_Variable;
1202:

Line 1241: FND_MSG_PUB.initialize;

1237:
1238: -- Initialize message list if p_init_msg_list is set to TRUE.
1239: IF FND_API.to_Boolean( p_init_msg_list )
1240: THEN
1241: FND_MSG_PUB.initialize;
1242: END IF;
1243:
1244:
1245: -- Initialize API return status to SUCCESS

Line 1305: FND_MSG_PUB.Count_And_Get

1301: END IF;
1302:
1303:
1304: -- Standard call to get message count and if count is 1, get message info.
1305: FND_MSG_PUB.Count_And_Get
1306: ( p_count => x_msg_count,
1307: p_data => x_msg_data
1308: );
1309:

Line 1315: FND_MSG_PUB.Count_And_Get(

1311:
1312: WHEN FND_API.G_EXC_ERROR THEN
1313: ROLLBACK TO UPDATE_Table_Column_PVT;
1314: x_return_status := FND_API.G_RET_STS_ERROR ;
1315: FND_MSG_PUB.Count_And_Get(
1316: p_count =>x_msg_count,
1317: p_data => x_msg_data
1318: );
1319: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1323: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

1319: APP_EXCEPTION.RAISE_EXCEPTION;
1320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1321: ROLLBACK TO UPDATE_Table_Column_PVT ;
1322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1323: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1324: p_data => x_msg_data) ;
1325: APP_EXCEPTION.RAISE_EXCEPTION;
1326: WHEN OTHERS THEN
1327: ROLLBACK TO UPDATE_Table_Column_PVT ;

Line 1329: IF FND_MSG_PUB.Check_Msg_Level

1325: APP_EXCEPTION.RAISE_EXCEPTION;
1326: WHEN OTHERS THEN
1327: ROLLBACK TO UPDATE_Table_Column_PVT ;
1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1329: IF FND_MSG_PUB.Check_Msg_Level
1330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1331: THEN
1332: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1333: END IF ;

Line 1330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1326: WHEN OTHERS THEN
1327: ROLLBACK TO UPDATE_Table_Column_PVT ;
1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1329: IF FND_MSG_PUB.Check_Msg_Level
1330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1331: THEN
1332: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1333: END IF ;
1334: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

Line 1332: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);

1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1329: IF FND_MSG_PUB.Check_Msg_Level
1330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1331: THEN
1332: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1333: END IF ;
1334: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1335: -- p_data => x_msg_data) ;
1336: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1334: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

1330: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1331: THEN
1332: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1333: END IF ;
1334: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1335: -- p_data => x_msg_data) ;
1336: APP_EXCEPTION.RAISE_EXCEPTION;
1337: End Update_table_column;
1338:

Line 1371: FND_MSG_PUB.initialize;

1367:
1368: -- Initialize message list if p_init_msg_list is set to TRUE.
1369: IF FND_API.to_Boolean( p_init_msg_list )
1370: THEN
1371: FND_MSG_PUB.initialize;
1372: END IF;
1373:
1374:
1375: -- Initialize API return status to SUCCESS

Line 1398: FND_MSG_PUB.Count_And_Get

1394: END IF;
1395:
1396:
1397: -- Standard call to get message count and if count is 1, get message info.
1398: FND_MSG_PUB.Count_And_Get
1399: ( p_count => x_msg_count,
1400: p_data => x_msg_data
1401: );
1402:

Line 1407: FND_MSG_PUB.Count_And_Get(

1403: EXCEPTION
1404: WHEN FND_API.G_EXC_ERROR THEN
1405: ROLLBACK TO DELETE_Table_Column_PVT;
1406: x_return_status := FND_API.G_RET_STS_ERROR ;
1407: FND_MSG_PUB.Count_And_Get(
1408: p_count =>x_msg_count,
1409: p_data => x_msg_data
1410: );
1411: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1415: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

1411: APP_EXCEPTION.RAISE_EXCEPTION;
1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1413: ROLLBACK TO DELETE_Table_Column_PVT ;
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1415: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1416: p_data => x_msg_data) ;
1417: APP_EXCEPTION.RAISE_EXCEPTION;
1418: WHEN OTHERS THEN
1419: ROLLBACK TO DELETE_Table_Column_PVT ;

Line 1421: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1417: APP_EXCEPTION.RAISE_EXCEPTION;
1418: WHEN OTHERS THEN
1419: ROLLBACK TO DELETE_Table_Column_PVT ;
1420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1421: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1422: THEN
1423: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1424: END IF ;
1425: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

Line 1423: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);

1419: ROLLBACK TO DELETE_Table_Column_PVT ;
1420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1421: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1422: THEN
1423: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1424: END IF ;
1425: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1426: -- p_data => x_msg_data) ;
1427: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1425: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

1421: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1422: THEN
1423: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1424: END IF ;
1425: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1426: -- p_data => x_msg_data) ;
1427: APP_EXCEPTION.RAISE_EXCEPTION;
1428: End Delete_profile_variables;
1429:

Line 1466: FND_MSG_PUB.initialize;

1462:
1463: -- Initialize message list if p_init_msg_list is set to TRUE.
1464: IF FND_API.to_Boolean( p_init_msg_list )
1465: THEN
1466: FND_MSG_PUB.initialize;
1467: END IF;
1468:
1469:
1470: -- Initialize API return status to SUCCESS

Line 1505: FND_MSG_PUB.Count_And_Get

1501: COMMIT WORK;
1502: END IF;
1503:
1504: -- Standard call to get message count and if count is 1, get message info.
1505: FND_MSG_PUB.Count_And_Get
1506: ( p_count => x_msg_count,
1507: p_data => x_msg_data
1508: );
1509:

Line 1514: FND_MSG_PUB.Count_And_Get(

1510: EXCEPTION
1511: WHEN FND_API.G_EXC_ERROR THEN
1512: ROLLBACK TO DELETE_Table_Columns_PVT;
1513: x_return_status := FND_API.G_RET_STS_ERROR ;
1514: FND_MSG_PUB.Count_And_Get(
1515: p_count =>x_msg_count,
1516: p_data => x_msg_data
1517: );
1518: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1522: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

1518: APP_EXCEPTION.RAISE_EXCEPTION;
1519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1520: ROLLBACK TO DELETE_Table_Columns_PVT ;
1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1522: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1523: p_data => x_msg_data) ;
1524: APP_EXCEPTION.RAISE_EXCEPTION;
1525: WHEN OTHERS THEN
1526: ROLLBACK TO DELETE_Table_Columns_PVT ;

Line 1528: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1524: APP_EXCEPTION.RAISE_EXCEPTION;
1525: WHEN OTHERS THEN
1526: ROLLBACK TO DELETE_Table_Columns_PVT ;
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1528: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1529: THEN
1530: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1531: END IF ;
1532: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

Line 1530: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);

1526: ROLLBACK TO DELETE_Table_Columns_PVT ;
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1528: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1529: THEN
1530: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1531: END IF ;
1532: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1533: -- p_data => x_msg_data) ;
1534: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1532: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

1528: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1529: THEN
1530: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1531: END IF ;
1532: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1533: -- p_data => x_msg_data) ;
1534: APP_EXCEPTION.RAISE_EXCEPTION;
1535: End Delete_Table_Columns;
1536:

Line 2091: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2087: OPEN C_get_prof_rec;
2088: FETCH C_get_prof_rec INTO X_PROF_BLOCKS_REC;
2089: IF C_get_prof_rec%NOTFOUND THEN
2090: CLOSE C_Get_prof_Rec;
2091: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2092: THEN
2093: CSC_CORE_UTILS_PVT.Record_IS_LOCKED_MSG(p_API_NAME=> 'CSC_PROF_BLOCKS');
2094: x_return_status := FND_API.G_RET_STS_ERROR;
2095: END IF;

Line 2149: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2145: OPEN C_get_table_column_rec;
2146: FETCH C_get_table_column_rec INTO X_TABLE_COLUMN_REC;
2147: IF C_get_table_column_rec%NOTFOUND THEN
2148: CLOSE C_Get_Table_Column_rec;
2149: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2150: THEN
2151: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_API_NAME=>'CSC_PROF_TABLE_COLUMNS');
2152: x_return_status := FND_API.G_RET_STS_ERROR;
2153: END IF;