[Home] [Help]
117: --| |
118: --| Valid values for message levels are from 1-50. |
119: --| 1 being least severe and 50 highest. |
120: --| |
121: --| The pre-defined levels correspond to standard API |
122: --| return status. Debug levels are used to control the amount of |
123: --| debug information a program writes to the PL/SQL message table. |
124: --| |
125: --| G_MSG_LVL_UNEXP_ERROR CONSTANT NUMBER := 60; |
1217:
1218: BEGIN
1219:
1220: /**********************************
1221: * Standard Start of API savepoint *
1222: **********************************/
1223: SAVEPOINT CREATE_ITEM_COST_PUB ;
1224:
1225: /*************************************************************
1230: FND_MSG_PUB.initialize;
1231: END IF;
1232:
1233: /*************************************************
1234: * Standard call to check for call compatibility. *
1235: *************************************************/
1236: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1237: THEN
1238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1347: FND_MESSAGE.SET_NAME('GMF','GMF_API_NO_ROWS_INS');
1348: FND_MSG_PUB.Add;
1349: END IF ;
1350: /******************************
1351: * Standard check of p_commit. *
1352: ******************************/
1353: IF FND_API.To_Boolean( p_commit )
1354: THEN
1355: COMMIT WORK;
1355: COMMIT WORK;
1356: END IF;
1357:
1358: /**************************************************************************
1359: * Standard call to get message count and if count is 1, get message info. *
1360: **************************************************************************/
1361: FND_MSG_PUB.Count_And_Get
1362: (
1363: p_count => x_msg_count,
1457:
1458: BEGIN
1459:
1460: /**********************************
1461: * Standard Start of API savepoint *
1462: **********************************/
1463: SAVEPOINT UPDATE_ITEM_COST_PUB ;
1464:
1465: /*************************************************************
1470: FND_MSG_PUB.initialize;
1471: END IF;
1472:
1473: /*************************************************
1474: * Standard call to check for call compatibility. *
1475: *************************************************/
1476: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1477: THEN
1478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1585: FND_MSG_PUB.Add;
1586: END IF ;
1587:
1588: /******************************
1589: * Standard check of p_commit. *
1590: ******************************/
1591: IF FND_API.To_Boolean( p_commit )
1592: THEN
1593: COMMIT WORK;
1593: COMMIT WORK;
1594: END IF;
1595:
1596: /**************************************************************************
1597: * Standard call to get message count and if count is 1, get message info. *
1598: **************************************************************************/
1599: FND_MSG_PUB.Count_And_Get
1600: (
1601: p_count => x_msg_count,
1693: l_no_rows_del NUMBER(10) ;
1694: BEGIN
1695:
1696: /**********************************
1697: * Standard Start of API savepoint *
1698: **********************************/
1699: SAVEPOINT DELETE_ITEM_COST_PUB ;
1700:
1701: /*************************************************************
1706: FND_MSG_PUB.initialize;
1707: END IF;
1708:
1709: /*************************************************
1710: * Standard call to check for call compatibility. *
1711: *************************************************/
1712: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1713: THEN
1714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1825: FND_MSG_PUB.Add;
1826: END IF ;
1827:
1828: /******************************
1829: * Standard check of p_commit. *
1830: ******************************/
1831: IF FND_API.To_Boolean( p_commit )
1832: THEN
1833: COMMIT WORK;
1833: COMMIT WORK;
1834: END IF;
1835:
1836: /**************************************************************************
1837: * Standard call to get message count and if count is 1, get message info. *
1838: **************************************************************************/
1839: FND_MSG_PUB.Count_And_Get
1840: (
1841: p_count => x_msg_count,
1934:
1935: BEGIN
1936:
1937: /**********************************
1938: * Standard Start of API savepoint *
1939: **********************************/
1940: SAVEPOINT GET_ITEM_COST_PUB ;
1941:
1942: /*************************************************************
1947: FND_MSG_PUB.initialize;
1948: END IF;
1949:
1950: /*************************************************
1951: * Standard call to check for call compatibility. *
1952: *************************************************/
1953: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1954: THEN
1955: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2221: END IF;
2222:
2223: /**************************************************************************
2224: * Standard call to get message count and if count is 1, get message info. *
2225: **************************************************************************/
2226: FND_MSG_PUB.Count_And_Get
2227: (
2228: p_count => x_msg_count,