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.AMS_REFRESHMETRIC_PVT dependencies on FND_MSG_PUB

Line 67: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

63: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AMS_REFRESHMETRIC_PVT'; -- Name of the current package.
64: G_DEBUG_FLAG VARCHAR2(1) := 'N';
65:
66: -- Forward Declarations Begin
67: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
68: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
69: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
70:
71: -- Forward Declaration for Calculate_Metric as it is removed from specs, SVEERAVE, 10/19/00

Line 68: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

64: G_DEBUG_FLAG VARCHAR2(1) := 'N';
65:
66: -- Forward Declarations Begin
67: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
68: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
69: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
70:
71: -- Forward Declaration for Calculate_Metric as it is removed from specs, SVEERAVE, 10/19/00
72: PROCEDURE Calculate_Metric (

Line 69: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

65:
66: -- Forward Declarations Begin
67: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
68: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
69: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
70:
71: -- Forward Declaration for Calculate_Metric as it is removed from specs, SVEERAVE, 10/19/00
72: PROCEDURE Calculate_Metric (
73: p_api_version IN NUMBER,

Line 507: l_msg_data := Fnd_Msg_Pub.get(i, Fnd_Api.g_false);

503: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
504: IF(l_msg_count > 0) THEN
505: FOR i IN 1 .. l_msg_count
506: LOOP
507: l_msg_data := Fnd_Msg_Pub.get(i, Fnd_Api.g_false);
508: END LOOP;
509: END IF;
510: RAISE Fnd_Api.G_EXC_ERROR;
511: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

Line 542: l_msg_data := Fnd_Msg_Pub.get(i, Fnd_Api.g_false);

538: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
539: IF l_msg_count > 0 THEN
540: FOR i IN 1 .. l_msg_count
541: LOOP
542: l_msg_data := Fnd_Msg_Pub.get(i, Fnd_Api.g_false);
543: END LOOP;
544: END IF;
545: RAISE Fnd_Api.G_EXC_ERROR;
546: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

Line 743: l_msg_data := Fnd_Msg_Pub.get(i, Fnd_Api.g_false);

739: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
740: IF l_msg_count > 0 THEN
741: FOR i IN 1 .. l_msg_count
742: LOOP
743: l_msg_data := Fnd_Msg_Pub.get(i, Fnd_Api.g_false);
744: END LOOP;
745: END IF;
746: --CLOSE c_get_metric_accrual;
747: CLOSE c_get_child_summary_metrics;

Line 1361: Fnd_Msg_Pub.Initialize;

1357: --
1358: -- Initialize message list if p_init_msg_list is set to TRUE.
1359: --
1360: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
1361: Fnd_Msg_Pub.Initialize;
1362: END IF;
1363: -- Standard check for API version compatibility.
1364: --
1365: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,

Line 1450: Fnd_Msg_Pub.Count_And_Get (

1446: --
1447: -- Standard API to get message count, and if 1,
1448: -- set the message data OUT variable.
1449: --
1450: Fnd_Msg_Pub.Count_And_Get (
1451: p_count => x_msg_count,
1452: p_data => x_msg_data,
1453: p_encoded => Fnd_Api.G_FALSE
1454: );

Line 1459: Fnd_Msg_Pub.Count_And_Get (

1455: --Ams_Utility_Pvt.debug_message(l_full_name ||': end');
1456: EXCEPTION
1457: WHEN Fnd_Api.G_EXC_ERROR THEN
1458: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1459: Fnd_Msg_Pub.Count_And_Get (
1460: p_count => x_msg_count,
1461: p_data => x_msg_data,
1462: p_encoded => FND_API.G_FALSE
1463: );

Line 1468: Fnd_Msg_Pub.Count_And_Get (

1464: RAISE Fnd_Api.G_EXC_ERROR;
1465:
1466: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1467: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1468: Fnd_Msg_Pub.Count_And_Get (
1469: p_count => x_msg_count,
1470: p_data => x_msg_data,
1471: p_encoded => FND_API.G_FALSE
1472: );

Line 1476: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

1472: );
1473: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
1474: WHEN OTHERS THEN
1475: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1476: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1477: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1478: END IF;
1479: Fnd_Msg_Pub.Count_And_Get (
1480: p_count => x_msg_count,

Line 1477: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

1473: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
1474: WHEN OTHERS THEN
1475: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1476: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1477: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1478: END IF;
1479: Fnd_Msg_Pub.Count_And_Get (
1480: p_count => x_msg_count,
1481: p_data => x_msg_data,

Line 1479: Fnd_Msg_Pub.Count_And_Get (

1475: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1476: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1477: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1478: END IF;
1479: Fnd_Msg_Pub.Count_And_Get (
1480: p_count => x_msg_count,
1481: p_data => x_msg_data,
1482: p_encoded => FND_API.G_FALSE
1483: );

Line 1558: Fnd_Msg_Pub.Initialize;

1554: --
1555: -- Initialize message list if p_init_msg_list is set to TRUE.
1556: --
1557: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
1558: Fnd_Msg_Pub.Initialize;
1559: END IF;
1560: -- Standard check for API version compatibility.
1561: --
1562: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,

Line 1635: Fnd_Msg_Pub.Count_And_Get (

1631: --
1632: -- Standard API to get message count, and if 1,
1633: -- set the message data OUT variable.
1634: --
1635: Fnd_Msg_Pub.Count_And_Get (
1636: p_count => x_msg_count,
1637: p_data => x_msg_data,
1638: p_encoded => Fnd_Api.G_FALSE
1639: );

Line 1646: Fnd_Msg_Pub.Count_And_Get (

1642: END IF;
1643: EXCEPTION
1644: WHEN Fnd_Api.G_EXC_ERROR THEN
1645: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1646: Fnd_Msg_Pub.Count_And_Get (
1647: p_count => x_msg_count,
1648: p_data => x_msg_data,
1649: p_encoded => FND_API.G_FALSE
1650: );

Line 1655: Fnd_Msg_Pub.Count_And_Get (

1651: RAISE Fnd_Api.G_EXC_ERROR;
1652:
1653: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1654: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1655: Fnd_Msg_Pub.Count_And_Get (
1656: p_count => x_msg_count,
1657: p_data => x_msg_data,
1658: p_encoded => FND_API.G_FALSE
1659: );

Line 1663: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

1659: );
1660: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
1661: WHEN OTHERS THEN
1662: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1663: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1664: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1665: END IF;
1666: Fnd_Msg_Pub.Count_And_Get (
1667: p_count => x_msg_count,

Line 1664: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

1660: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
1661: WHEN OTHERS THEN
1662: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1663: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1664: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1665: END IF;
1666: Fnd_Msg_Pub.Count_And_Get (
1667: p_count => x_msg_count,
1668: p_data => x_msg_data,

Line 1666: Fnd_Msg_Pub.Count_And_Get (

1662: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1663: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1664: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1665: END IF;
1666: Fnd_Msg_Pub.Count_And_Get (
1667: p_count => x_msg_count,
1668: p_data => x_msg_data,
1669: p_encoded => FND_API.G_FALSE
1670: );

Line 1833: Fnd_Msg_Pub.Initialize;

1829: --
1830: -- Initialize message list if p_init_msg_list is set to TRUE.
1831: --
1832: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
1833: Fnd_Msg_Pub.Initialize;
1834: END IF;
1835: --
1836: -- Standard check for API version compatibility.
1837: --

Line 2322: Fnd_Msg_Pub.Count_And_Get (

2318: --
2319: -- Standard API to get message count, and if 1,
2320: -- set the message data OUT variable.
2321: --
2322: Fnd_Msg_Pub.Count_And_Get (
2323: p_count => x_msg_count,
2324: p_data => x_msg_data,
2325: p_encoded => Fnd_Api.G_FALSE
2326: );

Line 2337: Fnd_Msg_Pub.Count_And_Get (

2333: EXCEPTION
2334: WHEN Fnd_Api.G_EXC_ERROR THEN
2335: -- ROLLBACK TO CALCULATE_METRIC_SAVEPOINT;
2336: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2337: Fnd_Msg_Pub.Count_And_Get (
2338: p_count => x_msg_count,
2339: p_data => x_msg_data,
2340: p_encoded => FND_API.G_FALSE
2341: );

Line 2346: Fnd_Msg_Pub.Count_And_Get (

2342: RAISE Fnd_Api.G_EXC_ERROR;
2343: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2344: -- ROLLBACK TO CALCULATE_METRIC_SAVEPOINT;
2345: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2346: Fnd_Msg_Pub.Count_And_Get (
2347: p_count => x_msg_count,
2348: p_data => x_msg_data,
2349: p_encoded => FND_API.G_FALSE
2350: );

Line 2354: Fnd_Msg_Pub.ADD;

2350: );
2351: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
2352: when ams_utility_pvt.resource_locked then
2353: Fnd_Message.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
2354: Fnd_Msg_Pub.ADD;
2355: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR ;
2356: WHEN OTHERS THEN
2357: -- ROLLBACK TO CALCULATE_METRIC_SAVEPOINT;
2358:

Line 2360: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

2356: WHEN OTHERS THEN
2357: -- ROLLBACK TO CALCULATE_METRIC_SAVEPOINT;
2358:
2359: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2360: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2361: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2362: END IF;
2363: Fnd_Msg_Pub.Count_And_Get (
2364: p_count => x_msg_count,

Line 2361: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

2357: -- ROLLBACK TO CALCULATE_METRIC_SAVEPOINT;
2358:
2359: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2360: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2361: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2362: END IF;
2363: Fnd_Msg_Pub.Count_And_Get (
2364: p_count => x_msg_count,
2365: p_data => x_msg_data,

Line 2363: Fnd_Msg_Pub.Count_And_Get (

2359: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2360: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2361: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2362: END IF;
2363: Fnd_Msg_Pub.Count_And_Get (
2364: p_count => x_msg_count,
2365: p_data => x_msg_data,
2366: p_encoded => FND_API.G_FALSE
2367: );

Line 2558: Fnd_Msg_Pub.Initialize;

2554: --
2555: -- Initialize message list if p_init_msg_list is set to TRUE.
2556: --
2557: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
2558: Fnd_Msg_Pub.Initialize;
2559: END IF;
2560: --
2561: -- Standard check for API version compatibility.
2562: --

Line 2672: Fnd_Msg_Pub.Count_And_Get (

2668: --
2669: -- Standard API to get message count, and if 1,
2670: -- set the message data OUT variable.
2671: --
2672: Fnd_Msg_Pub.Count_And_Get (
2673: p_count => x_msg_count,
2674: p_data => x_msg_data,
2675: p_encoded => Fnd_Api.G_FALSE
2676: );

Line 2687: Fnd_Msg_Pub.Count_And_Get (

2683: EXCEPTION
2684: WHEN Fnd_Api.G_EXC_ERROR THEN
2685: ROLLBACK TO Copy_Seeded_Metric_pvt;
2686: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2687: Fnd_Msg_Pub.Count_And_Get (
2688: p_count => x_msg_count,
2689: p_data => x_msg_data,
2690: p_encoded => FND_API.G_FALSE
2691: );

Line 2695: Fnd_Msg_Pub.Count_And_Get (

2691: );
2692: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2693: ROLLBACK TO Copy_Seeded_Metric_pvt;
2694: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2695: Fnd_Msg_Pub.Count_And_Get (
2696: p_count => x_msg_count,
2697: p_data => x_msg_data,
2698: p_encoded => FND_API.G_FALSE
2699: );

Line 2703: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

2699: );
2700: WHEN OTHERS THEN
2701: ROLLBACK TO Copy_Seeded_Metric_pvt;
2702: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2703: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2704: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2705: END IF;
2706: Fnd_Msg_Pub.Count_And_Get (
2707: p_count => x_msg_count,

Line 2704: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

2700: WHEN OTHERS THEN
2701: ROLLBACK TO Copy_Seeded_Metric_pvt;
2702: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2703: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2704: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2705: END IF;
2706: Fnd_Msg_Pub.Count_And_Get (
2707: p_count => x_msg_count,
2708: p_data => x_msg_data,

Line 2706: Fnd_Msg_Pub.Count_And_Get (

2702: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2703: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2704: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2705: END IF;
2706: Fnd_Msg_Pub.Count_And_Get (
2707: p_count => x_msg_count,
2708: p_data => x_msg_data,
2709: p_encoded => FND_API.G_FALSE
2710: );

Line 2791: Fnd_Msg_Pub.Initialize;

2787: --
2788: -- Initialize message list if p_init_msg_list is set to TRUE.
2789: --
2790: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
2791: Fnd_Msg_Pub.Initialize;
2792: END IF;
2793: --
2794: -- Standard check for API version compatibility.
2795: --

Line 2881: Fnd_Msg_Pub.Count_And_Get (

2877: --
2878: -- Standard API to get message count, and if 1,
2879: -- set the message data OUT variable.
2880: --
2881: Fnd_Msg_Pub.Count_And_Get (
2882: p_count => x_msg_count,
2883: p_data => x_msg_data,
2884: p_encoded => Fnd_Api.G_FALSE
2885: );

Line 2896: Fnd_Msg_Pub.Count_And_Get (

2892: EXCEPTION
2893: WHEN Fnd_Api.G_EXC_ERROR THEN
2894: ROLLBACK TO Create_App_Metric_pvt;
2895: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2896: Fnd_Msg_Pub.Count_And_Get (
2897: p_count => x_msg_count,
2898: p_data => x_msg_data,
2899: p_encoded => FND_API.G_FALSE
2900: );

Line 2904: Fnd_Msg_Pub.Count_And_Get (

2900: );
2901: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2902: ROLLBACK TO Create_App_Metric_pvt;
2903: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2904: Fnd_Msg_Pub.Count_And_Get (
2905: p_count => x_msg_count,
2906: p_data => x_msg_data,
2907: p_encoded => FND_API.G_FALSE
2908: );

Line 2912: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

2908: );
2909: WHEN OTHERS THEN
2910: ROLLBACK TO Create_App_Metric_pvt;
2911: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2912: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2913: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2914: END IF;
2915: Fnd_Msg_Pub.Count_And_Get (
2916: p_count => x_msg_count,

Line 2913: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

2909: WHEN OTHERS THEN
2910: ROLLBACK TO Create_App_Metric_pvt;
2911: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2912: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2913: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2914: END IF;
2915: Fnd_Msg_Pub.Count_And_Get (
2916: p_count => x_msg_count,
2917: p_data => x_msg_data,

Line 2915: Fnd_Msg_Pub.Count_And_Get (

2911: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2912: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2913: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2914: END IF;
2915: Fnd_Msg_Pub.Count_And_Get (
2916: p_count => x_msg_count,
2917: p_data => x_msg_data,
2918: p_encoded => FND_API.G_FALSE
2919: );

Line 3031: Fnd_Msg_Pub.Initialize;

3027: --
3028: -- Initialize message list if p_init_msg_list is set to TRUE.
3029: --
3030: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
3031: Fnd_Msg_Pub.Initialize;
3032: END IF;
3033: --
3034: -- Standard check for API version compatibility.
3035: --

Line 3057: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)

3053: OPEN c_act_metric(p_activity_metric_id);
3054: FETCH c_act_metric INTO l_act_metric_rec;
3055: IF c_act_metric%NOTFOUND THEN
3056: -- activity metric not found
3057: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3058: THEN -- MMSG
3059: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_ACT_METR');
3060: Fnd_Msg_Pub.ADD;
3061: END IF;

Line 3060: Fnd_Msg_Pub.ADD;

3056: -- activity metric not found
3057: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3058: THEN -- MMSG
3059: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_ACT_METR');
3060: Fnd_Msg_Pub.ADD;
3061: END IF;
3062: CLOSE c_act_metric;
3063: RAISE Fnd_Api.G_EXC_ERROR;
3064: END IF;

Line 3153: Fnd_Msg_Pub.Count_And_Get (

3149: --
3150: -- Standard API to get message count, and if 1,
3151: -- set the message data OUT variable.
3152: --
3153: Fnd_Msg_Pub.Count_And_Get (
3154: p_count => x_msg_count,
3155: p_data => x_msg_data,
3156: p_encoded => Fnd_Api.G_FALSE
3157: );

Line 3168: Fnd_Msg_Pub.Count_And_Get (

3164: EXCEPTION
3165: WHEN Fnd_Api.G_EXC_ERROR THEN
3166: ROLLBACK TO Refresh_Metric_SavePoint;
3167: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3168: Fnd_Msg_Pub.Count_And_Get (
3169: p_count => x_msg_count,
3170: p_data => x_msg_data,
3171: p_encoded => FND_API.G_FALSE
3172: );

Line 3176: Fnd_Msg_Pub.Count_And_Get (

3172: );
3173: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3174: ROLLBACK TO Refresh_Metric_SavePoint;
3175: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3176: Fnd_Msg_Pub.Count_And_Get (
3177: p_count => x_msg_count,
3178: p_data => x_msg_data,
3179: p_encoded => FND_API.G_FALSE
3180: );

Line 3184: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

3180: );
3181: WHEN OTHERS THEN
3182: ROLLBACK TO Refresh_Metric_SavePoint;
3183: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3184: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3185: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3186: END IF;
3187: Fnd_Msg_Pub.Count_And_Get (
3188: p_count => x_msg_count,

Line 3185: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

3181: WHEN OTHERS THEN
3182: ROLLBACK TO Refresh_Metric_SavePoint;
3183: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3184: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3185: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3186: END IF;
3187: Fnd_Msg_Pub.Count_And_Get (
3188: p_count => x_msg_count,
3189: p_data => x_msg_data,

Line 3187: Fnd_Msg_Pub.Count_And_Get (

3183: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3184: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3185: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3186: END IF;
3187: Fnd_Msg_Pub.Count_And_Get (
3188: p_count => x_msg_count,
3189: p_data => x_msg_data,
3190: p_encoded => FND_API.G_FALSE
3191: );

Line 3272: Fnd_Msg_Pub.Initialize;

3268: --
3269: -- Initialize message list if p_init_msg_list is set to TRUE.
3270: --
3271: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
3272: Fnd_Msg_Pub.Initialize;
3273: END IF;
3274: --
3275: -- Standard check for API version compatibility.
3276: --

Line 3393: Fnd_Msg_Pub.Count_And_Get (

3389: --
3390: -- Standard API to get message count, and if 1,
3391: -- set the message data OUT variable.
3392: --
3393: Fnd_Msg_Pub.Count_And_Get (
3394: p_count => x_msg_count,
3395: p_data => x_msg_data,
3396: p_encoded => Fnd_Api.G_FALSE
3397: );

Line 3408: Fnd_Msg_Pub.ADD;

3404: EXCEPTION
3405: when ams_utility_pvt.resource_locked then
3406: ROLLBACK TO Refresh_Metric_SavePoint2;
3407: Fnd_Message.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
3408: Fnd_Msg_Pub.ADD;
3409: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3410: Fnd_Msg_Pub.Count_And_Get (
3411: p_count => x_msg_count,
3412: p_data => x_msg_data,

Line 3410: Fnd_Msg_Pub.Count_And_Get (

3406: ROLLBACK TO Refresh_Metric_SavePoint2;
3407: Fnd_Message.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
3408: Fnd_Msg_Pub.ADD;
3409: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3410: Fnd_Msg_Pub.Count_And_Get (
3411: p_count => x_msg_count,
3412: p_data => x_msg_data,
3413: p_encoded => FND_API.G_FALSE
3414: );

Line 3420: Fnd_Msg_Pub.Count_And_Get (

3416: EXCEPTION
3417: WHEN Fnd_Api.G_EXC_ERROR THEN
3418: --ROLLBACK TO Refresh_Metric_SavePoint;
3419: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3420: Fnd_Msg_Pub.Count_And_Get (
3421: p_count => x_msg_count,
3422: p_data => x_msg_data,
3423: p_encoded => FND_API.G_FALSE
3424: );

Line 3428: Fnd_Msg_Pub.Count_And_Get (

3424: );
3425: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3426: --ROLLBACK TO Refresh_Metric_SavePoint;
3427: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3428: Fnd_Msg_Pub.Count_And_Get (
3429: p_count => x_msg_count,
3430: p_data => x_msg_data,
3431: p_encoded => FND_API.G_FALSE
3432: );

Line 3436: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

3432: );
3433: WHEN OTHERS THEN
3434: --ROLLBACK TO Refresh_Metric_SavePoint;
3435: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3436: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3437: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3438: END IF;
3439: Fnd_Msg_Pub.Count_And_Get (
3440: p_count => x_msg_count,

Line 3437: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

3433: WHEN OTHERS THEN
3434: --ROLLBACK TO Refresh_Metric_SavePoint;
3435: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3436: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3437: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3438: END IF;
3439: Fnd_Msg_Pub.Count_And_Get (
3440: p_count => x_msg_count,
3441: p_data => x_msg_data,

Line 3439: Fnd_Msg_Pub.Count_And_Get (

3435: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3436: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3437: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3438: END IF;
3439: Fnd_Msg_Pub.Count_And_Get (
3440: p_count => x_msg_count,
3441: p_data => x_msg_data,
3442: p_encoded => FND_API.G_FALSE
3443: );

Line 3591: Fnd_Msg_Pub.Initialize;

3587: --
3588: -- Initialize message list if p_init_msg_list is set to TRUE.
3589: --
3590: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
3591: Fnd_Msg_Pub.Initialize;
3592: END IF;
3593: --
3594: -- Standard check for API version compatibility.
3595: --

Line 3645: Fnd_Msg_Pub.Count_And_Get (

3641: --
3642: -- Standard API to get message count, and if 1,
3643: -- set the message data OUT variable.
3644: --
3645: Fnd_Msg_Pub.Count_And_Get (
3646: p_count => x_msg_count,
3647: p_data => x_msg_data,
3648: p_encoded => Fnd_Api.G_FALSE
3649: );

Line 3660: Fnd_Msg_Pub.Count_And_Get (

3656: EXCEPTION
3657: WHEN Fnd_Api.G_EXC_ERROR THEN
3658: ROLLBACK TO Refresh_Metric_SavePoint;
3659: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3660: Fnd_Msg_Pub.Count_And_Get (
3661: p_count => x_msg_count,
3662: p_data => x_msg_data,
3663: p_encoded => FND_API.G_FALSE
3664: );

Line 3668: Fnd_Msg_Pub.Count_And_Get (

3664: );
3665: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3666: ROLLBACK TO Refresh_Metric_SavePoint;
3667: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3668: Fnd_Msg_Pub.Count_And_Get (
3669: p_count => x_msg_count,
3670: p_data => x_msg_data,
3671: p_encoded => FND_API.G_FALSE
3672: );

Line 3676: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

3672: );
3673: WHEN OTHERS THEN
3674: ROLLBACK TO Refresh_Metric_SavePoint;
3675: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3676: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3677: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3678: END IF;
3679: Fnd_Msg_Pub.Count_And_Get (
3680: p_count => x_msg_count,

Line 3677: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

3673: WHEN OTHERS THEN
3674: ROLLBACK TO Refresh_Metric_SavePoint;
3675: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3676: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3677: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3678: END IF;
3679: Fnd_Msg_Pub.Count_And_Get (
3680: p_count => x_msg_count,
3681: p_data => x_msg_data,

Line 3679: Fnd_Msg_Pub.Count_And_Get (

3675: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3676: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3677: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3678: END IF;
3679: Fnd_Msg_Pub.Count_And_Get (
3680: p_count => x_msg_count,
3681: p_data => x_msg_data,
3682: p_encoded => FND_API.G_FALSE
3683: );