DBA Data[Home] [Help]

APPS.OZF_ACTMETRIC_PVT dependencies on FND_MESSAGE

Line 247: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_NO_RATE');

243: WHEN GL_CURRENCY_API.NO_RATE THEN
244: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
245: -- No rate exist for for given conversion date and type between
246: -- transaction currency and functional currency
247: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_NO_RATE');
248: FND_MSG_PUB.Add;
249: END IF;
250: x_return_status := FND_API.G_RET_STS_ERROR;
251:

Line 257: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_CURR');

253: RETURN;
254: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
255: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
256: -- Atleast One of the two Currencies specified is invalid
257: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_CURR');
258: FND_MSG_PUB.Add;
259: END IF;
260: x_return_status := FND_API.G_RET_STS_ERROR;
261:

Line 926: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

922: --
923: -- Add error message to API message list.
924: --
925: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
926: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
927: Fnd_Msg_Pub.ADD;
928: END IF;
929: RAISE Fnd_Api.g_exc_error;
930: END IF;

Line 1172: Fnd_Message.Set_Name('OZF', 'OZF_METR_MISSING_APP_ID');

1168: THEN
1169: -- missing required fields
1170: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1171: THEN -- MMSG
1172: Fnd_Message.Set_Name('OZF', 'OZF_METR_MISSING_APP_ID');
1173: Fnd_Msg_Pub.ADD;
1174: END IF;
1175:
1176: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1189: Fnd_Message.Set_Name('OZF', 'OZF_METR_MISSING_ARC_USED_FOR');

1185: THEN
1186: -- missing required fields
1187: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1188: THEN -- MMSG
1189: Fnd_Message.Set_Name('OZF', 'OZF_METR_MISSING_ARC_USED_FOR');
1190: Fnd_Msg_Pub.ADD;
1191: END IF;
1192:
1193: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1207: Fnd_Message.Set_Name('OZF', 'OZF_METR_MISSING_ARC_USED_FOR');

1203: THEN
1204: -- missing required fields
1205: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1206: THEN -- MMSG
1207: Fnd_Message.Set_Name('OZF', 'OZF_METR_MISSING_ARC_USED_FOR');
1208: Fnd_Msg_Pub.ADD;
1209: END IF;
1210:
1211: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1224: Fnd_Message.Set_Name('OZF', 'OZF_METR_MISSING_METRIC_ID');

1220: THEN
1221: -- missing required fields
1222: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1223: THEN -- MMSG
1224: Fnd_Message.Set_Name('OZF', 'OZF_METR_MISSING_METRIC_ID');
1225: Fnd_Msg_Pub.ADD;
1226: END IF;
1227:
1228: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1243: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_UOM');

1239: THEN
1240: -- missing required fields
1241: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1242: THEN -- MMSG
1243: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_UOM');
1244: FND_MSG_PUB.Add;
1245: END IF;
1246:
1247: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1263: Fnd_Message.Set_Name('OZF', 'OZF_METR_MISSING_SENSITIVE');

1259: THEN
1260: -- missing required fields
1261: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1262: THEN -- MMSG
1263: Fnd_Message.Set_Name('OZF', 'OZF_METR_MISSING_SENSITIVE');
1264: Fnd_Msg_Pub.ADD;
1265: END IF;
1266:
1267: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1341: Fnd_Message.set_name('OZF', 'OZF_METR_ACT_DUP_ID');

1337: ) = Fnd_Api.g_false
1338: THEN
1339: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
1340: THEN
1341: Fnd_Message.set_name('OZF', 'OZF_METR_ACT_DUP_ID');
1342: Fnd_Msg_Pub.ADD;
1343: END IF;
1344: x_return_status := Fnd_Api.g_ret_sts_error;
1345: RETURN;

Line 1364: Fnd_Message.set_name('OZF', 'OZF_ACT_MET_DUP_FUNCTION');

1360: CLOSE c_check_function;
1361:
1362: IF l_test IS NULL THEN
1363: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1364: Fnd_Message.set_name('OZF', 'OZF_ACT_MET_DUP_FUNCTION');
1365: Fnd_Msg_Pub.ADD;
1366: END IF;
1367: x_return_status := Fnd_Api.g_ret_sts_error;
1368: END IF;

Line 1448: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_MET');

1444: ) = Fnd_Api.G_FALSE
1445: THEN
1446: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1447: THEN
1448: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_MET');
1449: Fnd_Msg_Pub.ADD;
1450: END IF;
1451:
1452: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1477: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_TRANS_CUR');

1473: ) = Fnd_Api.G_FALSE
1474: THEN
1475: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1476: THEN
1477: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_TRANS_CUR');
1478: Fnd_Msg_Pub.ADD;
1479: END IF;
1480:
1481: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1505: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_FUNC_CUR');

1501: ) = Fnd_Api.G_FALSE
1502: THEN
1503: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1504: THEN
1505: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_FUNC_CUR');
1506: Fnd_Msg_Pub.ADD;
1507: END IF;
1508:
1509: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1530: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_SENS_FLAG');

1526: = Fnd_Api.G_FALSE
1527: THEN
1528: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1529: THEN
1530: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_SENS_FLAG');
1531: Fnd_Msg_Pub.ADD;
1532: END IF;
1533:
1534: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1561: Fnd_Message.Set_Name ('OZF', 'OZF_METR_INVALID_USED_BY');

1557: ('CAMP','CSCH','EVEH','EVEO','DELV','FUND','FCST','RCAM','EONE')
1558: --'DILG','AMS_COMP_START','AMS_COMP_SHOW_WEB_PAGE','AMS_COMP_END')
1559: THEN
1560: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1561: Fnd_Message.Set_Name ('OZF', 'OZF_METR_INVALID_USED_BY');
1562: Fnd_Msg_Pub.ADD;
1563: END IF;
1564:
1565: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1579: Fnd_Message.Set_Name ('OZF', 'OZF_METR_INVALID_ORIGIN');

1575: ('CAMP','CSCH','EVEH','EVEO','DELV','FUND','FCST','RCAM','EONE')
1576: --'DILG','AMS_COMP_START','AMS_COMP_SHOW_WEB_PAGE','AMS_COMP_END')
1577: THEN
1578: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1579: Fnd_Message.Set_Name ('OZF', 'OZF_METR_INVALID_ORIGIN');
1580: Fnd_Msg_Pub.ADD;
1581: END IF;
1582:
1583: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1671: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCNOAVAIL_ERROR');

1667: /* Can not allocate if available budget amount is 0 */
1668: IF (l_available_budget = 0) THEN
1669: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1670: IF l_fund_type = 'QUOTA' THEN
1671: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCNOAVAIL_ERROR');
1672: ELSE
1673: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCNOAVAIL_ERROR');
1674: END IF;
1675: Fnd_Msg_Pub.ADD;

Line 1673: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCNOAVAIL_ERROR');

1669: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1670: IF l_fund_type = 'QUOTA' THEN
1671: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCNOAVAIL_ERROR');
1672: ELSE
1673: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCNOAVAIL_ERROR');
1674: END IF;
1675: Fnd_Msg_Pub.ADD;
1676: END IF;
1677:

Line 1682: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCAMOUNT_ERROR');

1678: /* allocation amount can not exceed available amount */
1679: IF (p_act_metric_rec.func_actual_value > l_available_budget) THEN
1680: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1681: IF l_fund_type = 'QUOTA' THEN
1682: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCAMOUNT_ERROR');
1683: ELSE
1684: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCAMOUNT_ERROR');
1685: END IF;
1686: Fnd_Message.set_token('ALLOCAMT', p_act_metric_rec.func_actual_value);

Line 1684: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCAMOUNT_ERROR');

1680: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1681: IF l_fund_type = 'QUOTA' THEN
1682: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCAMOUNT_ERROR');
1683: ELSE
1684: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCAMOUNT_ERROR');
1685: END IF;
1686: Fnd_Message.set_token('ALLOCAMT', p_act_metric_rec.func_actual_value);
1687: Fnd_Message.set_token('BUDAMT', l_available_budget);
1688: Fnd_Msg_Pub.ADD;

Line 1686: Fnd_Message.set_token('ALLOCAMT', p_act_metric_rec.func_actual_value);

1682: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCAMOUNT_ERROR');
1683: ELSE
1684: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCAMOUNT_ERROR');
1685: END IF;
1686: Fnd_Message.set_token('ALLOCAMT', p_act_metric_rec.func_actual_value);
1687: Fnd_Message.set_token('BUDAMT', l_available_budget);
1688: Fnd_Msg_Pub.ADD;
1689: END IF;
1690:

Line 1687: Fnd_Message.set_token('BUDAMT', l_available_budget);

1683: ELSE
1684: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCAMOUNT_ERROR');
1685: END IF;
1686: Fnd_Message.set_token('ALLOCAMT', p_act_metric_rec.func_actual_value);
1687: Fnd_Message.set_token('BUDAMT', l_available_budget);
1688: Fnd_Msg_Pub.ADD;
1689: END IF;
1690:
1691: /* check start level <= end level */

Line 1696: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCLEVEL_ERROR');

1692: IF (p_act_metric_rec.from_level <> Fnd_Api.g_miss_num AND
1693: p_act_metric_rec.to_level <> Fnd_Api.g_miss_num) THEN
1694: IF (NVL(p_act_metric_rec.from_level, 0) > NVL(p_act_metric_rec.to_level, 1000)) THEN
1695: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1696: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCLEVEL_ERROR');
1697: Fnd_Msg_Pub.ADD;
1698: END IF;
1699:
1700: /* 11.5.9: can not set 'ex-start-node' if start level = end level */

Line 1704: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCEXSTNODE_ERROR');

1700: /* 11.5.9: can not set 'ex-start-node' if start level = end level */
1701: IF (p_act_metric_rec.ex_start_node = 'Y' AND
1702: p_act_metric_rec.from_level = p_act_metric_rec.to_level) THEN
1703: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1704: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCEXSTNODE_ERROR');
1705: Fnd_Msg_Pub.ADD;
1706: END IF;
1707: END IF;
1708:

Line 1721: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCSTARTDATE_ERROR');

1717: /* check start date >= budget start date */
1718: IF (l_alloc_start_date < l_budget_start_date) THEN
1719: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1720: IF l_fund_type = 'QUOTA' THEN
1721: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCSTARTDATE_ERROR');
1722: ELSE
1723: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCSTARTDATE_ERROR');
1724: END IF;
1725: Fnd_Msg_Pub.ADD;

Line 1723: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCSTARTDATE_ERROR');

1719: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1720: IF l_fund_type = 'QUOTA' THEN
1721: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCSTARTDATE_ERROR');
1722: ELSE
1723: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCSTARTDATE_ERROR');
1724: END IF;
1725: Fnd_Msg_Pub.ADD;
1726: END IF;
1727:

Line 1732: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCENDDATE_ERROR');

1728: /* check end date <= budget end date */
1729: IF (l_alloc_end_date > l_budget_end_date) THEN
1730: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1731: IF l_fund_type = 'QUOTA' THEN
1732: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCENDDATE_ERROR');
1733: ELSE
1734: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCENDDATE_ERROR');
1735: END IF;
1736: Fnd_Msg_Pub.ADD;

Line 1734: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCENDDATE_ERROR');

1730: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1731: IF l_fund_type = 'QUOTA' THEN
1732: Fnd_Message.set_name('OZF', 'OZF_TP_ALLOCENDDATE_ERROR');
1733: ELSE
1734: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCENDDATE_ERROR');
1735: END IF;
1736: Fnd_Msg_Pub.ADD;
1737: END IF;
1738:

Line 1742: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCDATE_ERROR');

1738:
1739: /* check start date <= end date */
1740: IF (l_alloc_start_date > l_alloc_end_date) THEN
1741: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1742: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCDATE_ERROR');
1743: Fnd_Msg_Pub.ADD;
1744: END IF;
1745:
1746: /* check start node falls in the start level */

Line 1752: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCSTARTNODE_ERROR');

1748: OPEN c_check_start_node_terr;
1749: FETCH c_check_start_node_terr INTO l_start_node;
1750: IF c_check_start_node_terr%NOTFOUND THEN
1751: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1752: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCSTARTNODE_ERROR');
1753: Fnd_Msg_Pub.ADD;
1754: END IF;
1755: CLOSE c_check_start_node_terr;
1756: /* for future release

Line 1765: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCPRISALE_ERROR');

1761: /* 11.5.9: method 'PRIOR_YEARS_SALE' can only be used by 'TERRITORY' hierarchy and must have year set */
1762: IF (p_act_metric_rec.method_code = 'PRIOR_SALES_TOTAL') THEN
1763: IF (p_act_metric_rec.hierarchy_type <> 'TERRITORY') THEN
1764: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1765: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCPRISALE_ERROR');
1766: Fnd_Msg_Pub.ADD;
1767: END IF;
1768: IF (p_act_metric_rec.basis_year is null) THEN
1769: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1770: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCBASISYEAR_ERROR');

1766: Fnd_Msg_Pub.ADD;
1767: END IF;
1768: IF (p_act_metric_rec.basis_year is null) THEN
1769: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1770: Fnd_Message.set_name('OZF', 'OZF_FUND_ALLOCBASISYEAR_ERROR');
1771: Fnd_Msg_Pub.ADD;
1772: END IF;
1773: END IF;
1774:

Line 1908: Fnd_Message.Set_Name ('OZF', 'OZF_METR_INVALID_OBJECT');

1904: THEN
1905: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1906: l_object_name := ozf_utility_pvt.get_lookup_meaning(
1907: 'AMS_SYS_ARC_QUALIFIER',l_act_metrics_rec.arc_act_metric_used_by);
1908: Fnd_Message.Set_Name ('OZF', 'OZF_METR_INVALID_OBJECT');
1909: Fnd_Message.Set_Token('OBJTYPE',l_object_name);
1910: Fnd_Message.Set_Token('OBJID',l_pk_value);
1911: Fnd_Msg_Pub.ADD;
1912: END IF;

Line 1909: Fnd_Message.Set_Token('OBJTYPE',l_object_name);

1905: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1906: l_object_name := ozf_utility_pvt.get_lookup_meaning(
1907: 'AMS_SYS_ARC_QUALIFIER',l_act_metrics_rec.arc_act_metric_used_by);
1908: Fnd_Message.Set_Name ('OZF', 'OZF_METR_INVALID_OBJECT');
1909: Fnd_Message.Set_Token('OBJTYPE',l_object_name);
1910: Fnd_Message.Set_Token('OBJID',l_pk_value);
1911: Fnd_Msg_Pub.ADD;
1912: END IF;
1913:

Line 1910: Fnd_Message.Set_Token('OBJID',l_pk_value);

1906: l_object_name := ozf_utility_pvt.get_lookup_meaning(
1907: 'AMS_SYS_ARC_QUALIFIER',l_act_metrics_rec.arc_act_metric_used_by);
1908: Fnd_Message.Set_Name ('OZF', 'OZF_METR_INVALID_OBJECT');
1909: Fnd_Message.Set_Token('OBJTYPE',l_object_name);
1910: Fnd_Message.Set_Token('OBJID',l_pk_value);
1911: Fnd_Msg_Pub.ADD;
1912: END IF;
1913:
1914: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1953: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_UOM');

1949: ) = Fnd_Api.G_FALSE
1950: THEN
1951: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1952: THEN
1953: Fnd_Message.Set_Name('OZF', 'OZF_METR_INVALID_UOM');
1954: Fnd_Msg_Pub.ADD;
1955: END IF;
1956:
1957: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1989: Fnd_Message.Set_Name ('OZF', 'OZF_METR_INVALID_ORIGIN');

1985: ,p_additional_where_clause => l_additional_where_clause
1986: ) = Fnd_Api.G_FALSE
1987: THEN
1988: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1989: Fnd_Message.Set_Name ('OZF', 'OZF_METR_INVALID_ORIGIN');
1990: Fnd_Msg_Pub.ADD;
1991: END IF;
1992:
1993: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 2098: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

2094: FETCH c_act_metric INTO l_act_metric_rec;
2095: IF c_act_metric%NOTFOUND THEN
2096: CLOSE c_act_metric;
2097: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2098: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2099: Fnd_Msg_Pub.ADD;
2100: END IF;
2101: RAISE Fnd_Api.g_exc_error;
2102: END IF;