eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_PROFILE_VARIABLE_PVT dependencies on FND_MSG_PUB

Line 723: FND_MSG_PUB.Initialize;

719: END IF;
720: -- Initialize message list if p_init_msg_list is set to TRUE
721: IF FND_API.To_Boolean(p_init_msg_list)
722: THEN
723: FND_MSG_PUB.Initialize;
724: END IF;
725: -- Initialize API return status to success
726: x_return_status := FND_API.G_RET_STS_SUCCESS;
727: -- we have to build the sql statement in advance before

Line 837: FND_MSG_PUB.Count_And_Get(

833: END IF;
834:
835: -- Standard call to get message count and if count is 1, get message info
836:
837: FND_MSG_PUB.Count_And_Get(
838: p_encoded => FND_API.G_FALSE,
839: p_count => x_msg_count,
840: p_data => x_msg_data );
841:

Line 847: /* FND_MSG_PUB.Count_And_Get

843: EXCEPTION
844: WHEN FND_API.G_EXC_ERROR THEN
845: ROLLBACK TO Create_Profile_Variable_PVT;
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: /* FND_MSG_PUB.Count_And_Get
848: ( p_encoded => FND_API.G_FALSE,
849: p_count => x_msg_count,
850: p_data => x_msg_data
851: ); */

Line 856: /* FND_MSG_PUB.Count_And_Get

852: APP_EXCEPTION.RAISE_EXCEPTION;
853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
854: ROLLBACK TO Create_Profile_Variable_PVT;
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
856: /* FND_MSG_PUB.Count_And_Get
857: ( p_encoded => FND_API.G_FALSE,
858: p_count => x_msg_count,
859: p_data => x_msg_data
860: ); */

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

861: APP_EXCEPTION.RAISE_EXCEPTION;
862: WHEN OTHERS THEN
863: ROLLBACK TO Create_Profile_Variable_PVT;
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
866: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
867: -- END IF;
868: FND_MSG_PUB.Build_Exc_Msg;
869: /* FND_MSG_PUB.Count_And_Get

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

862: WHEN OTHERS THEN
863: ROLLBACK TO Create_Profile_Variable_PVT;
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
866: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
867: -- END IF;
868: FND_MSG_PUB.Build_Exc_Msg;
869: /* FND_MSG_PUB.Count_And_Get
870: ( p_encoded => FND_API.G_FALSE,

Line 868: FND_MSG_PUB.Build_Exc_Msg;

864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
866: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
867: -- END IF;
868: FND_MSG_PUB.Build_Exc_Msg;
869: /* FND_MSG_PUB.Count_And_Get
870: ( p_encoded => FND_API.G_FALSE,
871: p_count => x_msg_count,
872: p_data => x_msg_data

Line 869: /* FND_MSG_PUB.Count_And_Get

865: --IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
866: -- FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
867: -- END IF;
868: FND_MSG_PUB.Build_Exc_Msg;
869: /* FND_MSG_PUB.Count_And_Get
870: ( p_encoded => FND_API.G_FALSE,
871: p_count => x_msg_count,
872: p_data => x_msg_data
873: ); */

Line 975: FND_MSG_PUB.initialize;

971:
972: -- Initialize message list if p_init_msg_list is set to TRUE.
973: IF FND_API.to_Boolean( p_init_msg_list )
974: THEN
975: FND_MSG_PUB.initialize;
976: END IF;
977:
978: -- Initialize API return status to SUCCESS
979: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1045: FND_MSG_PUB.Count_And_Get(

1041: END IF;
1042:
1043:
1044: -- Standard call to get message count and if count is 1, get message info.
1045: FND_MSG_PUB.Count_And_Get(
1046: p_count => x_msg_count,
1047: p_data => x_msg_data);
1048:
1049: EXCEPTION

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

1049: EXCEPTION
1050: WHEN FND_API.G_EXC_ERROR THEN
1051: ROLLBACK TO CREATE_Table_Column_PVT;
1052: x_return_status := FND_API.G_RET_STS_ERROR ;
1053: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1054: p_data => x_msg_data) ;
1055: APP_EXCEPTION.RAISE_EXCEPTION;
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: ROLLBACK TO CREATE_Table_Column_PVT;

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

1055: APP_EXCEPTION.RAISE_EXCEPTION;
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: ROLLBACK TO CREATE_Table_Column_PVT;
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1059: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1060: p_data => x_msg_data) ;
1061: APP_EXCEPTION.RAISE_EXCEPTION;
1062: WHEN OTHERS THEN
1063: ROLLBACK TO CREATE_Table_Column_PVT;

Line 1065: --IF FND_MSG_PUB.Check_Msg_Level

1061: APP_EXCEPTION.RAISE_EXCEPTION;
1062: WHEN OTHERS THEN
1063: ROLLBACK TO CREATE_Table_Column_PVT;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1065: --IF FND_MSG_PUB.Check_Msg_Level
1066: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1067: --THEN
1068: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1069: --END IF ;

Line 1066: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1062: WHEN OTHERS THEN
1063: ROLLBACK TO CREATE_Table_Column_PVT;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1065: --IF FND_MSG_PUB.Check_Msg_Level
1066: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1067: --THEN
1068: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1069: --END IF ;
1070: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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

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

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

1066: -- (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1067: --THEN
1068: --FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
1069: --END IF ;
1070: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1071: p_data => x_msg_data) ;
1072: APP_EXCEPTION.RAISE_EXCEPTION;
1073: End Create_table_column;
1074:

Line 1219: FND_MSG_PUB.initialize ;

1215:
1216:
1217: -- Initialize the message list if p_msg_list is set to TRUE
1218: IF FND_API.To_Boolean(p_init_msg_list) THEN
1219: FND_MSG_PUB.initialize ;
1220: END IF ;
1221:
1222:
1223: -- Initialize the API Return Success to True

Line 1366: FND_MSG_PUB.Count_And_Get(

1362: COMMIT WORK;
1363: END IF;
1364:
1365: -- Standard call to get message count and if count is 1, get message info
1366: FND_MSG_PUB.Count_And_Get(
1367: p_count => x_msg_count,
1368: p_data => x_msg_data );
1369: EXCEPTION
1370: WHEN FND_API.G_EXC_ERROR THEN

Line 1373: --FND_MSG_PUB.Count_And_Get

1369: EXCEPTION
1370: WHEN FND_API.G_EXC_ERROR THEN
1371: ROLLBACK TO Update_Profile_Variable_Pvt;
1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373: --FND_MSG_PUB.Count_And_Get
1374: -- ( p_count => x_msg_count,
1375: -- p_data => x_msg_data );
1376: APP_EXCEPTION.RAISE_EXCEPTION;
1377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1380: --FND_MSG_PUB.Count_And_Get

1376: APP_EXCEPTION.RAISE_EXCEPTION;
1377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1378: ROLLBACK TO Update_Profile_Variable_Pvt;
1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1380: --FND_MSG_PUB.Count_And_Get
1381: -- ( p_count => x_msg_count,
1382: -- p_data => x_msg_data );
1383: APP_EXCEPTION.RAISE_EXCEPTION;
1384: WHEN OTHERS THEN

Line 1387: -- FND_MSG_PUB.Count_And_Get

1383: APP_EXCEPTION.RAISE_EXCEPTION;
1384: WHEN OTHERS THEN
1385: ROLLBACK TO Update_Profile_Variable_Pvt;
1386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1387: -- FND_MSG_PUB.Count_And_Get
1388: -- ( p_count => x_msg_count,
1389: -- p_data => x_msg_data );
1390: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1391: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);

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

1386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1387: -- FND_MSG_PUB.Count_And_Get
1388: -- ( p_count => x_msg_count,
1389: -- p_data => x_msg_data );
1390: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1391: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
1392: END IF;
1393: APP_EXCEPTION.RAISE_EXCEPTION;
1394: END Update_Profile_Variable;

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

1387: -- FND_MSG_PUB.Count_And_Get
1388: -- ( p_count => x_msg_count,
1389: -- p_data => x_msg_data );
1390: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1391: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME, l_api_name);
1392: END IF;
1393: APP_EXCEPTION.RAISE_EXCEPTION;
1394: END Update_Profile_Variable;
1395:

Line 1434: FND_MSG_PUB.initialize;

1430:
1431: -- Initialize message list if p_init_msg_list is set to TRUE.
1432: IF FND_API.to_Boolean( p_init_msg_list )
1433: THEN
1434: FND_MSG_PUB.initialize;
1435: END IF;
1436:
1437:
1438: -- Initialize API return status to SUCCESS

Line 1498: FND_MSG_PUB.Count_And_Get

1494: END IF;
1495:
1496:
1497: -- Standard call to get message count and if count is 1, get message info.
1498: FND_MSG_PUB.Count_And_Get
1499: ( p_count => x_msg_count,
1500: p_data => x_msg_data
1501: );
1502:

Line 1508: FND_MSG_PUB.Count_And_Get(

1504:
1505: WHEN FND_API.G_EXC_ERROR THEN
1506: ROLLBACK TO UPDATE_Table_Column_PVT;
1507: x_return_status := FND_API.G_RET_STS_ERROR ;
1508: FND_MSG_PUB.Count_And_Get(
1509: p_count =>x_msg_count,
1510: p_data => x_msg_data
1511: );
1512: APP_EXCEPTION.RAISE_EXCEPTION;

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

1512: APP_EXCEPTION.RAISE_EXCEPTION;
1513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1514: ROLLBACK TO UPDATE_Table_Column_PVT ;
1515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1516: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1517: p_data => x_msg_data) ;
1518: APP_EXCEPTION.RAISE_EXCEPTION;
1519: WHEN OTHERS THEN
1520: ROLLBACK TO UPDATE_Table_Column_PVT ;

Line 1522: IF FND_MSG_PUB.Check_Msg_Level

1518: APP_EXCEPTION.RAISE_EXCEPTION;
1519: WHEN OTHERS THEN
1520: ROLLBACK TO UPDATE_Table_Column_PVT ;
1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1522: IF FND_MSG_PUB.Check_Msg_Level
1523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1524: THEN
1525: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1526: END IF ;

Line 1523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1519: WHEN OTHERS THEN
1520: ROLLBACK TO UPDATE_Table_Column_PVT ;
1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1522: IF FND_MSG_PUB.Check_Msg_Level
1523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1524: THEN
1525: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1526: END IF ;
1527: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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

1521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1522: IF FND_MSG_PUB.Check_Msg_Level
1523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1524: THEN
1525: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1526: END IF ;
1527: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1528: -- p_data => x_msg_data) ;
1529: APP_EXCEPTION.RAISE_EXCEPTION;

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

1523: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1524: THEN
1525: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1526: END IF ;
1527: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1528: -- p_data => x_msg_data) ;
1529: APP_EXCEPTION.RAISE_EXCEPTION;
1530: End Update_table_column;
1531:

Line 1564: FND_MSG_PUB.initialize;

1560:
1561: -- Initialize message list if p_init_msg_list is set to TRUE.
1562: IF FND_API.to_Boolean( p_init_msg_list )
1563: THEN
1564: FND_MSG_PUB.initialize;
1565: END IF;
1566:
1567:
1568: -- Initialize API return status to SUCCESS

Line 1591: FND_MSG_PUB.Count_And_Get

1587: END IF;
1588:
1589:
1590: -- Standard call to get message count and if count is 1, get message info.
1591: FND_MSG_PUB.Count_And_Get
1592: ( p_count => x_msg_count,
1593: p_data => x_msg_data
1594: );
1595:

Line 1600: FND_MSG_PUB.Count_And_Get(

1596: EXCEPTION
1597: WHEN FND_API.G_EXC_ERROR THEN
1598: ROLLBACK TO DELETE_Table_Column_PVT;
1599: x_return_status := FND_API.G_RET_STS_ERROR ;
1600: FND_MSG_PUB.Count_And_Get(
1601: p_count =>x_msg_count,
1602: p_data => x_msg_data
1603: );
1604: APP_EXCEPTION.RAISE_EXCEPTION;

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

1604: APP_EXCEPTION.RAISE_EXCEPTION;
1605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1606: ROLLBACK TO DELETE_Table_Column_PVT ;
1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1608: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1609: p_data => x_msg_data) ;
1610: APP_EXCEPTION.RAISE_EXCEPTION;
1611: WHEN OTHERS THEN
1612: ROLLBACK TO DELETE_Table_Column_PVT ;

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

1610: APP_EXCEPTION.RAISE_EXCEPTION;
1611: WHEN OTHERS THEN
1612: ROLLBACK TO DELETE_Table_Column_PVT ;
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1615: THEN
1616: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1617: END IF ;
1618: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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

1612: ROLLBACK TO DELETE_Table_Column_PVT ;
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1615: THEN
1616: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1617: END IF ;
1618: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1619: -- p_data => x_msg_data) ;
1620: APP_EXCEPTION.RAISE_EXCEPTION;

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

1614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1615: THEN
1616: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1617: END IF ;
1618: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1619: -- p_data => x_msg_data) ;
1620: APP_EXCEPTION.RAISE_EXCEPTION;
1621: End Delete_profile_variables;
1622:

Line 1659: FND_MSG_PUB.initialize;

1655:
1656: -- Initialize message list if p_init_msg_list is set to TRUE.
1657: IF FND_API.to_Boolean( p_init_msg_list )
1658: THEN
1659: FND_MSG_PUB.initialize;
1660: END IF;
1661:
1662:
1663: -- Initialize API return status to SUCCESS

Line 1698: FND_MSG_PUB.Count_And_Get

1694: COMMIT WORK;
1695: END IF;
1696:
1697: -- Standard call to get message count and if count is 1, get message info.
1698: FND_MSG_PUB.Count_And_Get
1699: ( p_count => x_msg_count,
1700: p_data => x_msg_data
1701: );
1702:

Line 1707: FND_MSG_PUB.Count_And_Get(

1703: EXCEPTION
1704: WHEN FND_API.G_EXC_ERROR THEN
1705: ROLLBACK TO DELETE_Table_Columns_PVT;
1706: x_return_status := FND_API.G_RET_STS_ERROR ;
1707: FND_MSG_PUB.Count_And_Get(
1708: p_count =>x_msg_count,
1709: p_data => x_msg_data
1710: );
1711: APP_EXCEPTION.RAISE_EXCEPTION;

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

1711: APP_EXCEPTION.RAISE_EXCEPTION;
1712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1713: ROLLBACK TO DELETE_Table_Columns_PVT ;
1714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1715: FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1716: p_data => x_msg_data) ;
1717: APP_EXCEPTION.RAISE_EXCEPTION;
1718: WHEN OTHERS THEN
1719: ROLLBACK TO DELETE_Table_Columns_PVT ;

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

1717: APP_EXCEPTION.RAISE_EXCEPTION;
1718: WHEN OTHERS THEN
1719: ROLLBACK TO DELETE_Table_Columns_PVT ;
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1721: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1722: THEN
1723: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1724: END IF ;
1725: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,

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

1719: ROLLBACK TO DELETE_Table_Columns_PVT ;
1720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1721: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1722: THEN
1723: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1724: END IF ;
1725: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1726: -- p_data => x_msg_data) ;
1727: APP_EXCEPTION.RAISE_EXCEPTION;

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

1721: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1722: THEN
1723: FND_MSG_PUB.Build_Exc_Msg(G_PKG_NAME,l_api_name);
1724: END IF ;
1725: --FND_MSG_PUB.Count_And_Get(p_count =>x_msg_count,
1726: -- p_data => x_msg_data) ;
1727: APP_EXCEPTION.RAISE_EXCEPTION;
1728: End Delete_Table_Columns;
1729:

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

2269: OPEN C_get_prof_rec;
2270: FETCH C_get_prof_rec INTO X_PROF_BLOCKS_REC;
2271: IF C_get_prof_rec%NOTFOUND THEN
2272: CLOSE C_Get_prof_Rec;
2273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2274: THEN
2275: CSC_CORE_UTILS_PVT.Record_IS_LOCKED_MSG(p_API_NAME=> 'CSC_PROF_BLOCKS');
2276: x_return_status := FND_API.G_RET_STS_ERROR;
2277: END IF;

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

2327: OPEN C_get_table_column_rec;
2328: FETCH C_get_table_column_rec INTO X_TABLE_COLUMN_REC;
2329: IF C_get_table_column_rec%NOTFOUND THEN
2330: CLOSE C_Get_Table_Column_rec;
2331: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2332: THEN
2333: CSC_CORE_UTILS_PVT.RECORD_IS_LOCKED_MSG(p_API_NAME=>'CSC_PROF_TABLE_COLUMNS');
2334: x_return_status := FND_API.G_RET_STS_ERROR;
2335: END IF;