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_ACTMETRIC_PVT dependencies on FND_MSG_PUB

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

134: TYPE date_bucket_type IS TABLE OF DATE;
135: TYPE number_table IS TABLE OF NUMBER;
136:
137: -- Forward Declarations Begin
138: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
139: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
140: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
141:
142: PROCEDURE Record_History(

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

135: TYPE number_table IS TABLE OF NUMBER;
136:
137: -- Forward Declarations Begin
138: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
139: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
140: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
141:
142: PROCEDURE Record_History(
143: p_actmet_id IN NUMBER,

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

136:
137: -- Forward Declarations Begin
138: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
139: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
140: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
141:
142: PROCEDURE Record_History(
143: p_actmet_id IN NUMBER,
144: p_action IN VARCHAR2,

Line 250: Fnd_Msg_Pub.Count_And_Get (

246: --
247: -- Standard API to get message count, and if 1,
248: -- set the message data OUT NOCOPY variable.
249: --
250: Fnd_Msg_Pub.Count_And_Get (
251: p_count => x_msg_count,
252: p_data => x_msg_data,
253: p_encoded => Fnd_Api.G_FALSE
254: );

Line 260: Fnd_Msg_Pub.Count_And_Get (

256: EXCEPTION
257: WHEN Fnd_Api.G_EXC_ERROR THEN
258: ROLLBACK TO sp_create_actmetric;
259: x_return_status := Fnd_Api.G_RET_STS_ERROR;
260: Fnd_Msg_Pub.Count_And_Get (
261: p_count => x_msg_count,
262: p_data => x_msg_data,
263: p_encoded => FND_API.G_FALSE
264: );

Line 268: Fnd_Msg_Pub.Count_And_Get (

264: );
265: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO sp_create_actmetric;
267: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
268: Fnd_Msg_Pub.Count_And_Get (
269: p_count => x_msg_count,
270: p_data => x_msg_data,
271: p_encoded => FND_API.G_FALSE
272: );

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

272: );
273: WHEN OTHERS THEN
274: ROLLBACK TO sp_create_actmetric;
275: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
276: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
277: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
278: END IF;
279: Fnd_Msg_Pub.Count_And_Get (
280: p_count => x_msg_count,

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

273: WHEN OTHERS THEN
274: ROLLBACK TO sp_create_actmetric;
275: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
276: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
277: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
278: END IF;
279: Fnd_Msg_Pub.Count_And_Get (
280: p_count => x_msg_count,
281: p_data => x_msg_data,

Line 279: Fnd_Msg_Pub.Count_And_Get (

275: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
276: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
277: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
278: END IF;
279: Fnd_Msg_Pub.Count_And_Get (
280: p_count => x_msg_count,
281: p_data => x_msg_data,
282: p_encoded => FND_API.G_FALSE
283: );

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

965: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
966: IF(l_msg_count > 0) THEN
967: FOR i IN 1 .. l_msg_count
968: LOOP
969: l_msg_data := Fnd_Msg_Pub.get(i, Fnd_Api.g_false);
970: END LOOP;
971: END IF;
972: CLOSE c_get_rollup_metrics;
973: RAISE Fnd_Api.G_EXC_ERROR;

Line 1040: Fnd_Msg_Pub.Initialize;

1036: --
1037: -- Initialize message list if p_init_msg_list is set to TRUE.
1038: --
1039: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
1040: Fnd_Msg_Pub.Initialize;
1041: END IF;
1042:
1043: --
1044: -- Initialize API return status to success.

Line 1330: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1326: END IF; -- IF l_met_det_rec.metric_calculation_type = 'MANUAL'
1327:
1328: /*EXCEPTION
1329: WHEN GL_CURRENCY_API.NO_RATE THEN
1330: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1331: -- No rate exist for for given conversion date and type between
1332: -- transaction currency and functional currency
1333: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_NO_RATE');
1334: FND_MSG_PUB.Add;

Line 1334: FND_MSG_PUB.Add;

1330: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1331: -- No rate exist for for given conversion date and type between
1332: -- transaction currency and functional currency
1333: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_NO_RATE');
1334: FND_MSG_PUB.Add;
1335: END IF;
1336: x_return_status := FND_API.G_RET_STS_ERROR;
1337:
1338: -- If any error happens abort API.

Line 1341: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1337:
1338: -- If any error happens abort API.
1339: RETURN;
1340: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
1341: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1342: -- Atleast One of the two Currencies specified is invalid
1343: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_CURR');
1344: FND_MSG_PUB.Add;
1345: END IF;

Line 1344: FND_MSG_PUB.Add;

1340: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
1341: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1342: -- Atleast One of the two Currencies specified is invalid
1343: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_CURR');
1344: FND_MSG_PUB.Add;
1345: END IF;
1346: x_return_status := FND_API.G_RET_STS_ERROR;
1347:
1348: -- If any error happens abort API.

Line 1662: Fnd_Msg_Pub.Initialize;

1658: --
1659: -- Initialize message list if p_init_msg_list is set to TRUE.
1660: --
1661: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
1662: Fnd_Msg_Pub.Initialize;
1663: END IF;
1664:
1665: --
1666: -- Standard check for API version compatibility.

Line 1720: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

1716: l_return_status);
1717:
1718: IF (l_freeze_status = Fnd_Api.G_TRUE) THEN
1719: -- frozen to create the record
1720: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1721: Fnd_Message.Set_Name('AMS', 'AMS_METR_FROZEN');
1722: Fnd_Msg_Pub.ADD;
1723: END IF;
1724: l_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1722: Fnd_Msg_Pub.ADD;

1718: IF (l_freeze_status = Fnd_Api.G_TRUE) THEN
1719: -- frozen to create the record
1720: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
1721: Fnd_Message.Set_Name('AMS', 'AMS_METR_FROZEN');
1722: Fnd_Msg_Pub.ADD;
1723: END IF;
1724: l_return_status := Fnd_Api.G_RET_STS_ERROR;
1725: END IF;
1726: -- If it is frozen, or any errors happen abort API.

Line 2116: --Fnd_Msg_Pub.Count_And_Get (

2112: --
2113: -- Standard API to get message count, and if 1,
2114: -- set the message data OUT NOCOPY variable.
2115: --
2116: --Fnd_Msg_Pub.Count_And_Get (
2117: -- p_count => x_msg_count,
2118: -- p_data => x_msg_data,
2119: -- p_encoded => Fnd_Api.G_FALSE
2120: --);

Line 2135: Fnd_Msg_Pub.Count_And_Get (

2131: WHEN Fnd_Api.G_EXC_ERROR THEN
2132: ROLLBACK TO Create_ActMetric2_pvt;
2133: --ROLLBACK;
2134: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2135: Fnd_Msg_Pub.Count_And_Get (
2136: p_count => x_msg_count,
2137: p_data => x_msg_data,
2138: p_encoded => FND_API.G_FALSE
2139: );

Line 2144: Fnd_Msg_Pub.Count_And_Get (

2140: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2141: ROLLBACK TO Create_ActMetric2_pvt;
2142: --ROLLBACK;
2143: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2144: Fnd_Msg_Pub.Count_And_Get (
2145: p_count => x_msg_count,
2146: p_data => x_msg_data,
2147: p_encoded => FND_API.G_FALSE
2148: );

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

2149: WHEN OTHERS THEN
2150: ROLLBACK TO Create_ActMetric2_pvt;
2151: --ROLLBACK;
2152: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2153: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2154: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2155: END IF;
2156: Fnd_Msg_Pub.Count_And_Get (
2157: p_count => x_msg_count,

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

2150: ROLLBACK TO Create_ActMetric2_pvt;
2151: --ROLLBACK;
2152: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2153: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2154: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2155: END IF;
2156: Fnd_Msg_Pub.Count_And_Get (
2157: p_count => x_msg_count,
2158: p_data => x_msg_data,

Line 2156: Fnd_Msg_Pub.Count_And_Get (

2152: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2153: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2154: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2155: END IF;
2156: Fnd_Msg_Pub.Count_And_Get (
2157: p_count => x_msg_count,
2158: p_data => x_msg_data,
2159: p_encoded => FND_API.G_FALSE
2160: );

Line 2249: Fnd_Msg_Pub.Initialize;

2245: --
2246: -- Initialize message list if p_init_msg_list is set to TRUE.
2247: --
2248: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
2249: Fnd_Msg_Pub.Initialize;
2250: END IF;
2251:
2252: --
2253: -- Standard check for API version compatibility.

Line 2312: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

2308: END IF;
2309:
2310: -- DMVINCEN 06/05/2001: If value is posted to budget do not update.
2311: IF l_actmet_rec.published_flag = 'Y' THEN
2312: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2313: l_actmet_rec.trans_actual_value := Fnd_Api.G_MISS_NUM;
2314: l_actmet_rec.func_actual_value := Fnd_Api.G_MISS_NUM;
2315: l_reprocess_rec := Fnd_Api.G_TRUE;
2316: END IF;

Line 2391: -- Fnd_Msg_Pub.Initialize;

2387: x_msg_count => x_msg_count,
2388: x_msg_data => x_msg_data);
2389: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2390: -- BUG2486379: Display budget utilization errors.
2391: -- Fnd_Msg_Pub.Initialize;
2392: Fnd_Message.set_name('AMS', 'AMS_MET_NO_POST');
2393: Fnd_Msg_Pub.ADD;
2394: --IF (AMS_DEBUG_HIGH_ON) THEN
2395: -- Ams_Utility_Pvt.debug_message('You can not post this cost!');

Line 2393: Fnd_Msg_Pub.ADD;

2389: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2390: -- BUG2486379: Display budget utilization errors.
2391: -- Fnd_Msg_Pub.Initialize;
2392: Fnd_Message.set_name('AMS', 'AMS_MET_NO_POST');
2393: Fnd_Msg_Pub.ADD;
2394: --IF (AMS_DEBUG_HIGH_ON) THEN
2395: -- Ams_Utility_Pvt.debug_message('You can not post this cost!');
2396: --END IF;
2397: END IF;

Line 2491: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

2487: THEN
2488: --
2489: -- Add error message to API message list.
2490: --
2491: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2492: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2493: Fnd_Msg_Pub.ADD;
2494: END IF;
2495: RAISE Fnd_Api.g_exc_error;

Line 2493: Fnd_Msg_Pub.ADD;

2489: -- Add error message to API message list.
2490: --
2491: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2492: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2493: Fnd_Msg_Pub.ADD;
2494: END IF;
2495: RAISE Fnd_Api.g_exc_error;
2496: END IF;
2497:

Line 2510: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

2506: IF (SQL%NOTFOUND) THEN
2507: --
2508: -- Add error message to API message list.
2509: --
2510: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2511: Fnd_Message.set_name('AMS', 'AMS_API_VARREC_NOT_FOUND');
2512: Fnd_Msg_Pub.ADD;
2513: END IF;
2514: RAISE Fnd_Api.g_exc_error;

Line 2512: Fnd_Msg_Pub.ADD;

2508: -- Add error message to API message list.
2509: --
2510: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2511: Fnd_Message.set_name('AMS', 'AMS_API_VARREC_NOT_FOUND');
2512: Fnd_Msg_Pub.ADD;
2513: END IF;
2514: RAISE Fnd_Api.g_exc_error;
2515: END IF;
2516: END IF;

Line 2541: Fnd_Msg_Pub.Count_And_Get (

2537: --
2538: -- Standard API to get message count, and if 1,
2539: -- set the message data OUT variable.
2540: --
2541: Fnd_Msg_Pub.Count_And_Get (
2542: p_count => x_msg_count,
2543: p_data => x_msg_data,
2544: p_encoded => Fnd_Api.G_FALSE
2545: );

Line 2559: Fnd_Msg_Pub.Count_And_Get (

2555: EXCEPTION
2556: WHEN Fnd_Api.G_EXC_ERROR THEN
2557: ROLLBACK TO Update_ActMetric_pvt;
2558: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2559: Fnd_Msg_Pub.Count_And_Get (
2560: p_count => x_msg_count,
2561: p_data => x_msg_data,
2562: p_encoded => FND_API.G_FALSE
2563: );

Line 2567: Fnd_Msg_Pub.Count_And_Get (

2563: );
2564: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2565: ROLLBACK TO Update_ActMetric_pvt;
2566: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2567: Fnd_Msg_Pub.Count_And_Get (
2568: p_count => x_msg_count,
2569: p_data => x_msg_data,
2570: p_encoded => FND_API.G_FALSE
2571: );

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

2571: );
2572: WHEN OTHERS THEN
2573: ROLLBACK TO Update_ActMetric_pvt;
2574: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2575: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2576: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2577: END IF;
2578: Fnd_Msg_Pub.Count_And_Get (
2579: p_count => x_msg_count,

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

2572: WHEN OTHERS THEN
2573: ROLLBACK TO Update_ActMetric_pvt;
2574: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2575: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2576: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2577: END IF;
2578: Fnd_Msg_Pub.Count_And_Get (
2579: p_count => x_msg_count,
2580: p_data => x_msg_data,

Line 2578: Fnd_Msg_Pub.Count_And_Get (

2574: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2575: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2576: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2577: END IF;
2578: Fnd_Msg_Pub.Count_And_Get (
2579: p_count => x_msg_count,
2580: p_data => x_msg_data,
2581: p_encoded => FND_API.G_FALSE
2582: );

Line 2753: Fnd_Msg_Pub.Initialize;

2749: --
2750: -- Initialize message list if p_init_msg_list is set to TRUE.
2751: --
2752: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
2753: Fnd_Msg_Pub.Initialize;
2754: END IF;
2755:
2756: --
2757: -- Standard check for API version compatibility.

Line 2773: -- IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)

2769: -- Check if record is seeded.
2770: --
2771: -- DMVINCEN: There is no reason for this restriction.
2772: -- IF IsSeeded (p_activity_metric_id) THEN
2773: -- IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
2774: -- THEN
2775: -- Fnd_Message.set_name('AMS', 'AMS_METR_SEEDED_METR');
2776: -- Fnd_Msg_Pub.ADD;
2777: -- END IF;

Line 2776: -- Fnd_Msg_Pub.ADD;

2772: -- IF IsSeeded (p_activity_metric_id) THEN
2773: -- IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
2774: -- THEN
2775: -- Fnd_Message.set_name('AMS', 'AMS_METR_SEEDED_METR');
2776: -- Fnd_Msg_Pub.ADD;
2777: -- END IF;
2778: --
2779: -- RAISE Fnd_Api.G_EXC_ERROR;
2780: -- END IF;

Line 2810: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

2806: END LOOP;
2807: CLOSE c_check_child_exists;
2808:
2809: IF l_child_type = 'SUMMARY' THEN
2810: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2811: Fnd_Message.set_name('AMS', 'AMS_METR_CANT_DELETE_PARENT');
2812: Fnd_Msg_Pub.ADD;
2813: END IF;
2814: RAISE Fnd_Api.g_exc_error;

Line 2812: Fnd_Msg_Pub.ADD;

2808:
2809: IF l_child_type = 'SUMMARY' THEN
2810: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2811: Fnd_Message.set_name('AMS', 'AMS_METR_CANT_DELETE_PARENT');
2812: Fnd_Msg_Pub.ADD;
2813: END IF;
2814: RAISE Fnd_Api.g_exc_error;
2815: END IF;
2816: -- end for the bug fix, sveerave.

Line 2823: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

2819: -- freeze validation.
2820: OPEN c_actmet_details(p_activity_metric_id);
2821: FETCH c_actmet_details INTO l_act_metric_rec;
2822: IF (c_actmet_details%NOTFOUND) THEN
2823: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2824: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2825: Fnd_Msg_Pub.ADD;
2826: END IF;
2827: RAISE Fnd_Api.g_exc_error;

Line 2825: Fnd_Msg_Pub.ADD;

2821: FETCH c_actmet_details INTO l_act_metric_rec;
2822: IF (c_actmet_details%NOTFOUND) THEN
2823: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2824: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2825: Fnd_Msg_Pub.ADD;
2826: END IF;
2827: RAISE Fnd_Api.g_exc_error;
2828: END IF;
2829:

Line 2841: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2837: l_return_status);
2838:
2839: IF (l_freeze_status = Fnd_Api.G_TRUE) THEN
2840: -- frozen to create the record
2841: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2842: -- sunkumar 04/30/2003 added message for delete status of objects depending on status (ACTIVE, CANCELLED, COMPLETED)
2843: l_object_name := ams_utility_pvt.get_lookup_meaning(
2844: 'AMS_SYS_ARC_QUALIFIER',l_act_metric_rec.arc_act_metric_used_by);
2845: Fnd_Message.Set_Name('AMS', 'AMS_METR_DELETE');

Line 2847: Fnd_Msg_Pub.ADD;

2843: l_object_name := ams_utility_pvt.get_lookup_meaning(
2844: 'AMS_SYS_ARC_QUALIFIER',l_act_metric_rec.arc_act_metric_used_by);
2845: Fnd_Message.Set_Name('AMS', 'AMS_METR_DELETE');
2846: Fnd_Message.set_token('OBJECT', l_object_name);
2847: Fnd_Msg_Pub.ADD;
2848: END IF;
2849: l_return_status := Fnd_Api.G_RET_STS_ERROR;
2850: END IF;
2851:

Line 2863: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

2859:
2860:
2861: IF (l_freeze_status = Fnd_Api.G_TRUE) THEN
2862: -- frozen to create the record
2863: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2864: Fnd_Message.Set_Name('AMS', 'AMS_METR_FROZEN');
2865: Fnd_Msg_Pub.ADD;
2866: END IF;
2867: l_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 2865: Fnd_Msg_Pub.ADD;

2861: IF (l_freeze_status = Fnd_Api.G_TRUE) THEN
2862: -- frozen to create the record
2863: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2864: Fnd_Message.Set_Name('AMS', 'AMS_METR_FROZEN');
2865: Fnd_Msg_Pub.ADD;
2866: END IF;
2867: l_return_status := Fnd_Api.G_RET_STS_ERROR;
2868: END IF;
2869:

Line 2879: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

2875: END IF;
2876:
2877: -- If the actual value has been posted to the budget do not delete.
2878: IF l_act_metric_rec.published_flag = 'Y' THEN
2879: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2880: Fnd_Message.SET_NAME('AMS', 'AMS_METR_PUBLISHED');
2881: Fnd_Msg_Pub.ADD;
2882: END IF;
2883: RAISE Fnd_Api.g_exc_error;

Line 2881: Fnd_Msg_Pub.ADD;

2877: -- If the actual value has been posted to the budget do not delete.
2878: IF l_act_metric_rec.published_flag = 'Y' THEN
2879: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2880: Fnd_Message.SET_NAME('AMS', 'AMS_METR_PUBLISHED');
2881: Fnd_Msg_Pub.ADD;
2882: END IF;
2883: RAISE Fnd_Api.g_exc_error;
2884: END IF;
2885:

Line 2907: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

2903: WHERE activity_metric_id = p_activity_metric_id
2904: AND object_version_number = p_object_version_number;
2905:
2906: IF SQL%NOTFOUND THEN
2907: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2908: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2909: Fnd_Msg_Pub.ADD;
2910: END IF;
2911: RAISE Fnd_Api.g_exc_error;

Line 2909: Fnd_Msg_Pub.ADD;

2905:
2906: IF SQL%NOTFOUND THEN
2907: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2908: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2909: Fnd_Msg_Pub.ADD;
2910: END IF;
2911: RAISE Fnd_Api.g_exc_error;
2912: END IF;
2913:

Line 2962: Fnd_Msg_Pub.Count_And_Get (

2958: --
2959: -- Standard API to get message count, and if 1,
2960: -- set the message data OUT NOCOPY variable.
2961: --
2962: Fnd_Msg_Pub.Count_And_Get (
2963: p_count => x_msg_count,
2964: p_data => x_msg_data,
2965: p_encoded => Fnd_Api.G_FALSE
2966: );

Line 2972: Fnd_Msg_Pub.Count_And_Get (

2968: EXCEPTION
2969: WHEN Fnd_Api.G_EXC_ERROR THEN
2970: ROLLBACK TO Delete_ActMetric_pvt;
2971: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2972: Fnd_Msg_Pub.Count_And_Get (
2973: p_count => x_msg_count,
2974: p_data => x_msg_data,
2975: p_encoded => FND_API.G_FALSE
2976: );

Line 2980: Fnd_Msg_Pub.Count_And_Get (

2976: );
2977: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2978: ROLLBACK TO Delete_ActMetric_pvt;
2979: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2980: Fnd_Msg_Pub.Count_And_Get (
2981: p_count => x_msg_count,
2982: p_data => x_msg_data,
2983: p_encoded => FND_API.G_FALSE
2984: );

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

2984: );
2985: WHEN OTHERS THEN
2986: ROLLBACK TO Delete_ActMetric_pvt;
2987: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2988: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2989: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2990: END IF;
2991: Fnd_Msg_Pub.Count_And_Get (
2992: p_count => x_msg_count,

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

2985: WHEN OTHERS THEN
2986: ROLLBACK TO Delete_ActMetric_pvt;
2987: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2988: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2989: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2990: END IF;
2991: Fnd_Msg_Pub.Count_And_Get (
2992: p_count => x_msg_count,
2993: p_data => x_msg_data,

Line 2991: Fnd_Msg_Pub.Count_And_Get (

2987: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2988: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2989: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2990: END IF;
2991: Fnd_Msg_Pub.Count_And_Get (
2992: p_count => x_msg_count,
2993: p_data => x_msg_data,
2994: p_encoded => FND_API.G_FALSE
2995: );

Line 3079: Fnd_Msg_Pub.Initialize;

3075: --
3076: -- Initialize message list if p_init_msg_list is set to TRUE.
3077: --
3078: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
3079: Fnd_Msg_Pub.Initialize;
3080: END IF;
3081:
3082: --
3083: -- Standard check for API version compatibility.

Line 3212: Fnd_Msg_Pub.Count_And_Get (

3208: --
3209: -- Standard API to get message count, and if 1,
3210: -- set the message data OUT NOCOPY variable.
3211: --
3212: Fnd_Msg_Pub.Count_And_Get (
3213: p_count => x_msg_count,
3214: p_data => x_msg_data,
3215: p_encoded => Fnd_Api.G_FALSE
3216: );

Line 3222: Fnd_Msg_Pub.Count_And_Get (

3218: EXCEPTION
3219: WHEN Fnd_Api.G_EXC_ERROR THEN
3220: -- ROLLBACK TO Delete_ActMetric_By_Object_pvt;
3221: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3222: Fnd_Msg_Pub.Count_And_Get (
3223: p_count => x_msg_count,
3224: p_data => x_msg_data,
3225: p_encoded => FND_API.G_FALSE
3226: );

Line 3230: Fnd_Msg_Pub.Count_And_Get (

3226: );
3227: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3228: -- ROLLBACK TO Delete_ActMetric_By_Object_pvt;
3229: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3230: Fnd_Msg_Pub.Count_And_Get (
3231: p_count => x_msg_count,
3232: p_data => x_msg_data,
3233: p_encoded => FND_API.G_FALSE
3234: );

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

3234: );
3235: WHEN OTHERS THEN
3236: -- ROLLBACK TO Delete_ActMetric_By_Object_pvt;
3237: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3238: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3239: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3240: END IF;
3241: Fnd_Msg_Pub.Count_And_Get (
3242: p_count => x_msg_count,

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

3235: WHEN OTHERS THEN
3236: -- ROLLBACK TO Delete_ActMetric_By_Object_pvt;
3237: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3238: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3239: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3240: END IF;
3241: Fnd_Msg_Pub.Count_And_Get (
3242: p_count => x_msg_count,
3243: p_data => x_msg_data,

Line 3241: Fnd_Msg_Pub.Count_And_Get (

3237: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3238: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3239: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3240: END IF;
3241: Fnd_Msg_Pub.Count_And_Get (
3242: p_count => x_msg_count,
3243: p_data => x_msg_data,
3244: p_encoded => FND_API.G_FALSE
3245: );

Line 3307: Fnd_Msg_Pub.Initialize;

3303: --
3304: -- Initialize message list if p_init_msg_list is set to TRUE.
3305: --
3306: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
3307: Fnd_Msg_Pub.Initialize;
3308: END IF;
3309:
3310: --
3311: -- Standard check for API version compatibility.

Line 3341: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

3337: THEN
3338: CLOSE c_act_metrics_info;
3339: -- Error, check the msg level and added an error message to the
3340: -- API message list
3341: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3342: l_metrics_name := null;
3343: OPEN c_metric_info(p_activity_metric_id);
3344: FETCH c_metric_info INTO l_metrics_name;
3345: CLOSE c_metric_info;

Line 3349: Fnd_Msg_Pub.ADD;

3345: CLOSE c_metric_info;
3346: IF l_metrics_name is not null THEN
3347: Fnd_Message.set_name('AMS', 'AMS_METR_RECORD_NOT_FOUND');
3348: Fnd_Message.set_token('METRIC', l_metrics_name);
3349: Fnd_Msg_Pub.ADD;
3350: ELSE
3351: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3352: Fnd_Msg_Pub.ADD;
3353: END IF;

Line 3352: Fnd_Msg_Pub.ADD;

3348: Fnd_Message.set_token('METRIC', l_metrics_name);
3349: Fnd_Msg_Pub.ADD;
3350: ELSE
3351: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3352: Fnd_Msg_Pub.ADD;
3353: END IF;
3354: END IF;
3355: RAISE Fnd_Api.g_exc_error;
3356: END IF;

Line 3364: Fnd_Msg_Pub.Count_And_Get (

3360: --
3361: -- Standard API to get message count, and if 1,
3362: -- set the message data OUT NOCOPY variable.
3363: --
3364: Fnd_Msg_Pub.Count_And_Get (
3365: p_count => x_msg_count,
3366: p_data => x_msg_data,
3367: p_encoded => Fnd_Api.G_FALSE
3368: );

Line 3381: Fnd_Msg_Pub.Count_And_Get (

3377:
3378: EXCEPTION
3379: WHEN Fnd_Api.G_EXC_ERROR THEN
3380: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3381: Fnd_Msg_Pub.Count_And_Get (
3382: p_count => x_msg_count,
3383: p_data => x_msg_data,
3384: p_encoded => FND_API.G_FALSE
3385: );

Line 3388: Fnd_Msg_Pub.Count_And_Get (

3384: p_encoded => FND_API.G_FALSE
3385: );
3386: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3387: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3388: Fnd_Msg_Pub.Count_And_Get (
3389: p_count => x_msg_count,
3390: p_data => x_msg_data,
3391: p_encoded => FND_API.G_FALSE
3392: );

Line 3396: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

3392: );
3393: WHEN Ams_Utility_Pvt.RESOURCE_LOCKED THEN
3394: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
3395:
3396: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3397: Fnd_Message.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
3398: Fnd_Msg_Pub.ADD;
3399: END IF;
3400:

Line 3398: Fnd_Msg_Pub.ADD;

3394: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
3395:
3396: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3397: Fnd_Message.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
3398: Fnd_Msg_Pub.ADD;
3399: END IF;
3400:
3401: Fnd_Msg_Pub.Count_And_Get (
3402: p_count => x_msg_count,

Line 3401: Fnd_Msg_Pub.Count_And_Get (

3397: Fnd_Message.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
3398: Fnd_Msg_Pub.ADD;
3399: END IF;
3400:
3401: Fnd_Msg_Pub.Count_And_Get (
3402: p_count => x_msg_count,
3403: p_data => x_msg_data,
3404: p_encoded => Fnd_Api.G_FALSE
3405: );

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

3404: p_encoded => Fnd_Api.G_FALSE
3405: );
3406: WHEN OTHERS THEN
3407: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3408: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3409: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3410: END IF;
3411: Fnd_Msg_Pub.Count_And_Get (
3412: p_count => x_msg_count,

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

3405: );
3406: WHEN OTHERS THEN
3407: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3408: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3409: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3410: END IF;
3411: Fnd_Msg_Pub.Count_And_Get (
3412: p_count => x_msg_count,
3413: p_data => x_msg_data,

Line 3411: Fnd_Msg_Pub.Count_And_Get (

3407: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3408: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3409: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3410: END IF;
3411: Fnd_Msg_Pub.Count_And_Get (
3412: p_count => x_msg_count,
3413: p_data => x_msg_data,
3414: p_encoded => Fnd_Api.G_FALSE
3415: );

Line 3464: Fnd_Msg_Pub.Initialize;

3460: --
3461: -- Initialize message list if p_init_msg_list is set to TRUE.
3462: --
3463: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
3464: Fnd_Msg_Pub.Initialize;
3465: END IF;
3466:
3467: --
3468: -- Standard check for API version compatibility.

Line 3534: Fnd_Msg_Pub.Count_And_Get (

3530: --
3531: -- Standard API to get message count, and if 1,
3532: -- set the message data OUT NOCOPY variable.
3533: --
3534: Fnd_Msg_Pub.Count_And_Get (
3535: p_count => x_msg_count,
3536: p_data => x_msg_data,
3537: p_encoded => Fnd_Api.G_FALSE
3538: );

Line 3547: Fnd_Msg_Pub.Count_And_Get (

3543:
3544: EXCEPTION
3545: WHEN Fnd_Api.G_EXC_ERROR THEN
3546: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3547: Fnd_Msg_Pub.Count_And_Get (
3548: p_count => x_msg_count,
3549: p_data => x_msg_data,
3550: p_encoded => FND_API.G_FALSE
3551: );

Line 3554: Fnd_Msg_Pub.Count_And_Get (

3550: p_encoded => FND_API.G_FALSE
3551: );
3552: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3553: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3554: Fnd_Msg_Pub.Count_And_Get (
3555: p_count => x_msg_count,
3556: p_data => x_msg_data,
3557: p_encoded => FND_API.G_FALSE
3558: );

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

3557: p_encoded => FND_API.G_FALSE
3558: );
3559: WHEN OTHERS THEN
3560: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3561: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3562: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3563: END IF;
3564: Fnd_Msg_Pub.Count_And_Get (
3565: p_count => x_msg_count,

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

3558: );
3559: WHEN OTHERS THEN
3560: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3561: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3562: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3563: END IF;
3564: Fnd_Msg_Pub.Count_And_Get (
3565: p_count => x_msg_count,
3566: p_data => x_msg_data,

Line 3564: Fnd_Msg_Pub.Count_And_Get (

3560: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3561: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3562: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3563: END IF;
3564: Fnd_Msg_Pub.Count_And_Get (
3565: p_count => x_msg_count,
3566: p_data => x_msg_data,
3567: p_encoded => FND_API.G_FALSE
3568: );

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

3599:
3600: IF p_act_metric_rec.application_id IS NULL
3601: THEN
3602: -- missing required fields
3603: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3604: THEN -- MMSG
3605: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_APP_ID');
3606: Fnd_Msg_Pub.ADD;
3607: END IF;

Line 3606: Fnd_Msg_Pub.ADD;

3602: -- missing required fields
3603: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3604: THEN -- MMSG
3605: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_APP_ID');
3606: Fnd_Msg_Pub.ADD;
3607: END IF;
3608:
3609: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3610:

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

3616:
3617: IF p_act_metric_rec.arc_act_metric_used_by IS NULL
3618: THEN
3619: -- missing required fields
3620: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3621: THEN -- MMSG
3622: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_ARC_USED_FOR');
3623: Fnd_Msg_Pub.ADD;
3624: END IF;

Line 3623: Fnd_Msg_Pub.ADD;

3619: -- missing required fields
3620: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3621: THEN -- MMSG
3622: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_ARC_USED_FOR');
3623: Fnd_Msg_Pub.ADD;
3624: END IF;
3625:
3626: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3627:

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

3634:
3635: IF p_act_metric_rec.act_metric_used_by_id IS NULL
3636: THEN
3637: -- missing required fields
3638: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3639: THEN -- MMSG
3640: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_ARC_USED_FOR');
3641: Fnd_Msg_Pub.ADD;
3642: END IF;

Line 3641: Fnd_Msg_Pub.ADD;

3637: -- missing required fields
3638: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3639: THEN -- MMSG
3640: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_ARC_USED_FOR');
3641: Fnd_Msg_Pub.ADD;
3642: END IF;
3643:
3644: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3645:

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

3651:
3652: IF p_act_metric_rec.metric_id IS NULL
3653: THEN
3654: -- missing required fields
3655: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3656: THEN -- MMSG
3657: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_METRIC_ID');
3658: Fnd_Msg_Pub.ADD;
3659: END IF;

Line 3658: Fnd_Msg_Pub.ADD;

3654: -- missing required fields
3655: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3656: THEN -- MMSG
3657: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_METRIC_ID');
3658: Fnd_Msg_Pub.ADD;
3659: END IF;
3660:
3661: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3662:

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

3670:
3671: IF p_act_metric_rec.metric_uom_code IS NULL
3672: THEN
3673: -- missing required fields
3674: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3675: THEN -- MMSG
3676: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_UOM');
3677: FND_MSG_PUB.Add;
3678: END IF;

Line 3677: FND_MSG_PUB.Add;

3673: -- missing required fields
3674: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3675: THEN -- MMSG
3676: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_UOM');
3677: FND_MSG_PUB.Add;
3678: END IF;
3679:
3680: x_return_status := FND_API.G_RET_STS_ERROR;
3681:

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

3690:
3691: IF p_act_metric_rec.sensitive_data_flag IS NULL
3692: THEN
3693: -- missing required fields
3694: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3695: THEN -- MMSG
3696: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_SENSITIVE');
3697: Fnd_Msg_Pub.ADD;
3698: END IF;

Line 3697: Fnd_Msg_Pub.ADD;

3693: -- missing required fields
3694: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3695: THEN -- MMSG
3696: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_SENSITIVE');
3697: Fnd_Msg_Pub.ADD;
3698: END IF;
3699:
3700: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3701:

Line 3774: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)

3770: p_table_name => 'ams_act_metrics_all',
3771: p_where_clause => l_where_clause
3772: ) = Fnd_Api.g_false
3773: THEN
3774: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
3775: THEN
3776: Fnd_Message.set_name('AMS', 'AMS_METR_ACT_DUP_ID');
3777: Fnd_Msg_Pub.ADD;
3778: END IF;

Line 3777: Fnd_Msg_Pub.ADD;

3773: THEN
3774: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
3775: THEN
3776: Fnd_Message.set_name('AMS', 'AMS_METR_ACT_DUP_ID');
3777: Fnd_Msg_Pub.ADD;
3778: END IF;
3779: x_return_status := Fnd_Api.g_ret_sts_error;
3780: RETURN;
3781: END IF;

Line 3798: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

3794: FETCH c_check_function INTO l_test;
3795: CLOSE c_check_function;
3796:
3797: IF l_test IS NULL THEN
3798: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3799: Fnd_Message.set_name('AMS', 'AMS_ACT_MET_DUP_FUNCTION');
3800: Fnd_Msg_Pub.ADD;
3801: END IF;
3802: x_return_status := Fnd_Api.g_ret_sts_error;

Line 3800: Fnd_Msg_Pub.ADD;

3796:
3797: IF l_test IS NULL THEN
3798: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3799: Fnd_Message.set_name('AMS', 'AMS_ACT_MET_DUP_FUNCTION');
3800: Fnd_Msg_Pub.ADD;
3801: END IF;
3802: x_return_status := Fnd_Api.g_ret_sts_error;
3803: END IF;
3804:

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

3879:
3880: OPEN c_check_metric_id(l_act_metrics_rec.metric_id);
3881: IF c_check_metric_id%NOTFOUND
3882: THEN
3883: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3884: THEN
3885: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_MET');
3886: FND_MSG_PUB.ADD;
3887: END IF;

Line 3886: FND_MSG_PUB.ADD;

3882: THEN
3883: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3884: THEN
3885: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_MET');
3886: FND_MSG_PUB.ADD;
3887: END IF;
3888:
3889: x_return_status := FND_API.G_RET_STS_ERROR;
3890: CLOSE c_check_metric_id;

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

3898:
3899: OPEN c_check_currency(l_act_metrics_rec.transaction_currency_code,'Y');
3900: IF c_check_currency%NOTFOUND
3901: THEN
3902: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3903: THEN
3904: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_TRANS_CUR');
3905: FND_MSG_PUB.ADD;
3906: END IF;

Line 3905: FND_MSG_PUB.ADD;

3901: THEN
3902: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3903: THEN
3904: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_TRANS_CUR');
3905: FND_MSG_PUB.ADD;
3906: END IF;
3907:
3908: x_return_status := FND_API.G_RET_STS_ERROR;
3909: CLOSE c_check_currency;

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

3920:
3921: OPEN c_check_currency(l_act_metrics_rec.functional_currency_code,'Y');
3922: IF c_check_currency%NOTFOUND
3923: THEN
3924: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3925: THEN
3926: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_FUNC_CUR');
3927: FND_MSG_PUB.ADD;
3928: END IF;

Line 3927: FND_MSG_PUB.ADD;

3923: THEN
3924: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3925: THEN
3926: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_FUNC_CUR');
3927: FND_MSG_PUB.ADD;
3928: END IF;
3929:
3930: x_return_status := FND_API.G_RET_STS_ERROR;
3931: RETURN;

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

3948: ,p_pk_data_type => l_pk_data_type
3949: ,p_additional_where_clause => l_additional_where_clause
3950: ) = Fnd_Api.G_FALSE
3951: THEN
3952: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3953: THEN
3954: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_TRANS_CUR');
3955: Fnd_Msg_Pub.ADD;
3956: END IF;

Line 3955: Fnd_Msg_Pub.ADD;

3951: THEN
3952: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3953: THEN
3954: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_TRANS_CUR');
3955: Fnd_Msg_Pub.ADD;
3956: END IF;
3957:
3958: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3959: RETURN;

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

3974: ,p_pk_data_type => l_pk_data_type
3975: ,p_additional_where_clause => l_additional_where_clause
3976: ) = Fnd_Api.G_FALSE
3977: THEN
3978: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3979: THEN
3980: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_FUNC_CUR');
3981: Fnd_Msg_Pub.ADD;
3982: END IF;

Line 3981: Fnd_Msg_Pub.ADD;

3977: THEN
3978: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3979: THEN
3980: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_FUNC_CUR');
3981: Fnd_Msg_Pub.ADD;
3982: END IF;
3983:
3984: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3985: RETURN;

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

3999: IF l_act_metrics_rec.sensitive_data_flag <> Fnd_Api.G_MISS_CHAR THEN
4000: IF Ams_Utility_Pvt.Is_Y_Or_N (l_act_metrics_rec.sensitive_data_flag)
4001: = Fnd_Api.G_FALSE
4002: THEN
4003: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
4004: THEN
4005: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_SENS_FLAG');
4006: Fnd_Msg_Pub.ADD;
4007: END IF;

Line 4006: Fnd_Msg_Pub.ADD;

4002: THEN
4003: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
4004: THEN
4005: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_SENS_FLAG');
4006: Fnd_Msg_Pub.ADD;
4007: END IF;
4008:
4009: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4010: RETURN;

Line 4030: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4026: OPEN c_arc_metric_usage(l_act_metrics_rec.arc_act_metric_used_by);
4027: FETCH c_arc_metric_usage INTO l_dummy;
4028: CLOSE c_arc_metric_usage;
4029: IF l_dummy IS NULL THEN
4030: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4031: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_USED_BY');
4032: FND_MSG_PUB.add;
4033: END IF;
4034: x_return_status := FND_API.g_ret_sts_error;

Line 4032: FND_MSG_PUB.add;

4028: CLOSE c_arc_metric_usage;
4029: IF l_dummy IS NULL THEN
4030: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4031: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_USED_BY');
4032: FND_MSG_PUB.add;
4033: END IF;
4034: x_return_status := FND_API.g_ret_sts_error;
4035: END IF;
4036: END IF;

Line 4047: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4043: OPEN c_arc_metric_usage(l_act_metrics_rec.arc_activity_metric_origin);
4044: FETCH c_arc_metric_usage INTO l_dummy;
4045: CLOSE c_arc_metric_usage;
4046: IF l_dummy IS NULL THEN
4047: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4048: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_ORIGIN');
4049: FND_MSG_PUB.add;
4050: END IF;
4051: x_return_status := FND_API.g_ret_sts_error;

Line 4049: FND_MSG_PUB.add;

4045: CLOSE c_arc_metric_usage;
4046: IF l_dummy IS NULL THEN
4047: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4048: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_ORIGIN');
4049: FND_MSG_PUB.add;
4050: END IF;
4051: x_return_status := FND_API.g_ret_sts_error;
4052: END IF;
4053: END IF;

Line 4205: FND_MSG_PUB.add;

4201: FND_MESSAGE.set_token('OBJECT',
4202: AMS_Utility_PVT.get_object_name(l_act_metrics_rec.arc_act_metric_used_by,
4203: l_act_metrics_rec.act_metric_used_by_id)
4204: );
4205: FND_MSG_PUB.add;
4206: -- exit the program immediately after this
4207: -- validation fails because it defines the
4208: -- entry requirement for executing any other
4209: -- logic for activity metrics; this is as if

Line 4235: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

4231: -- this portion calls the Complete_ActMetric_Rec
4232: -- to set trans_forecasted_value back to
4233: -- its original value
4234:
4235: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4236: l_object_name := ams_utility_pvt.get_lookup_meaning(
4237: 'AMS_SYS_ARC_QUALIFIER',
4238: l_act_metrics_rec.arc_act_metric_used_by);
4239: Fnd_Message.set_name('AMS', 'AMS_UPDATE_FORECAST');

Line 4241: Fnd_Msg_Pub.ADD;

4237: 'AMS_SYS_ARC_QUALIFIER',
4238: l_act_metrics_rec.arc_act_metric_used_by);
4239: Fnd_Message.set_name('AMS', 'AMS_UPDATE_FORECAST');
4240: Fnd_Message.set_token('OBJECT', l_object_name);
4241: Fnd_Msg_Pub.ADD;
4242: END IF; --msg_pub if
4243: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4244: END IF;
4245:

Line 4268: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

4264: --added profile option to restrict updation of actuals
4265: IF (l_allow_actual_update = 'N') THEN
4266: --object is not active and profile is N hence do not allow update
4267: IF (l_freeze_status = Fnd_Api.G_FALSE) THEN
4268: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4269: Fnd_Message.set_name('AMS', 'AMS_METR_UPDATE_ACTUAL');
4270: Fnd_Msg_Pub.ADD;
4271: END IF; --msg_pub if
4272:

Line 4270: Fnd_Msg_Pub.ADD;

4266: --object is not active and profile is N hence do not allow update
4267: IF (l_freeze_status = Fnd_Api.G_FALSE) THEN
4268: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4269: Fnd_Message.set_name('AMS', 'AMS_METR_UPDATE_ACTUAL');
4270: Fnd_Msg_Pub.ADD;
4271: END IF; --msg_pub if
4272:
4273: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4274: END IF; --freeze status if

Line 4299: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

4295: -- Profile option to restrict updation of actuals.
4296: IF (l_allow_actual_update = 'N') THEN
4297: --object is not active and profile is N hence do not allow update
4298: IF (l_freeze_status = Fnd_Api.G_FALSE) THEN
4299: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4300: Fnd_Message.set_name('AMS', 'AMS_METR_UPDATE_ACTUAL');
4301: Fnd_Msg_Pub.ADD;
4302: END IF; --msg_pub if
4303:

Line 4301: Fnd_Msg_Pub.ADD;

4297: --object is not active and profile is N hence do not allow update
4298: IF (l_freeze_status = Fnd_Api.G_FALSE) THEN
4299: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4300: Fnd_Message.set_name('AMS', 'AMS_METR_UPDATE_ACTUAL');
4301: Fnd_Msg_Pub.ADD;
4302: END IF; --msg_pub if
4303:
4304: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4305: END IF; --freeze status if

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

4333: (l_metric_details_rec.metric_calculation_type IN ('MANUAL', 'FUNCTION') AND
4334: l_metric_details_rec.arc_metric_used_for_object <> l_act_metrics_rec.arc_act_metric_used_by)
4335: THEN
4336:
4337: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
4338: THEN
4339: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_ACT_USAGE');
4340: Fnd_Msg_Pub.ADD;
4341: END IF;

Line 4340: Fnd_Msg_Pub.ADD;

4336:
4337: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
4338: THEN
4339: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_ACT_USAGE');
4340: Fnd_Msg_Pub.ADD;
4341: END IF;
4342:
4343: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4344: END IF; -- Check_FK_Exists

Line 4353: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

4349: p_object_type => l_act_metrics_rec.arc_act_metric_used_by
4350: ,p_object_id => l_act_metrics_rec.act_metric_used_by_id
4351: ) = Fnd_Api.G_FALSE
4352: THEN
4353: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
4354: l_object_name := ams_utility_pvt.get_lookup_meaning(
4355: 'AMS_SYS_ARC_QUALIFIER',l_act_metrics_rec.arc_act_metric_used_by);
4356: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_OBJECT');
4357: Fnd_Message.Set_Token('OBJTYPE',l_object_name);

Line 4359: Fnd_Msg_Pub.ADD;

4355: 'AMS_SYS_ARC_QUALIFIER',l_act_metrics_rec.arc_act_metric_used_by);
4356: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_OBJECT');
4357: Fnd_Message.Set_Token('OBJTYPE',l_object_name);
4358: Fnd_Message.Set_Token('OBJID',l_pk_value);
4359: Fnd_Msg_Pub.ADD;
4360: END IF;
4361:
4362: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4363: END IF;

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

4372:
4373: OPEN c_check_uom(l_act_metrics_rec.metric_uom_code,l_metric_details_rec.uom_type);
4374: IF c_check_uom%NOTFOUND
4375: THEN
4376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4377: THEN
4378: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_UOM');
4379: FND_MSG_PUB.ADD;
4380: END IF;

Line 4379: FND_MSG_PUB.ADD;

4375: THEN
4376: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4377: THEN
4378: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_UOM');
4379: FND_MSG_PUB.ADD;
4380: END IF;
4381:
4382: x_return_status := FND_API.G_RET_STS_ERROR;
4383: CLOSE c_check_uom;

Line 4402: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

4398: p_object_type => l_act_metrics_rec.arc_act_metric_used_by
4399: ,p_object_id => l_act_metrics_rec.act_metric_used_by_id
4400: ) = Fnd_Api.G_FALSE
4401: THEN
4402: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
4403: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_ORIGIN');
4404: Fnd_Msg_Pub.ADD;
4405: END IF;
4406:

Line 4404: Fnd_Msg_Pub.ADD;

4400: ) = Fnd_Api.G_FALSE
4401: THEN
4402: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
4403: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_ORIGIN');
4404: Fnd_Msg_Pub.ADD;
4405: END IF;
4406:
4407: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4408: END IF;

Line 4506: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

4502: OPEN c_act_metric;
4503: FETCH c_act_metric INTO l_act_metric_rec;
4504: IF c_act_metric%NOTFOUND THEN
4505: CLOSE c_act_metric;
4506: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4507: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
4508: Fnd_Msg_Pub.ADD;
4509: END IF;
4510: RAISE Fnd_Api.g_exc_error;

Line 4508: Fnd_Msg_Pub.ADD;

4504: IF c_act_metric%NOTFOUND THEN
4505: CLOSE c_act_metric;
4506: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4507: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
4508: Fnd_Msg_Pub.ADD;
4509: END IF;
4510: RAISE Fnd_Api.g_exc_error;
4511: END IF;
4512: CLOSE c_act_metric;

Line 4873: Fnd_Msg_Pub.Initialize;

4869: --
4870: -- Initialize message list if p_init_msg_list is set to TRUE.
4871: --
4872: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
4873: Fnd_Msg_Pub.Initialize;
4874: END IF;
4875:
4876: --
4877: -- Standard check for API version compatibility.

Line 4931: Fnd_Msg_Pub.Count_And_Get (

4927: --
4928: -- Standard API to get message count, and if 1,
4929: -- set the message data OUT NOCOPY variable.
4930: --
4931: Fnd_Msg_Pub.Count_And_Get (
4932: p_count => x_msg_count,
4933: p_data => x_msg_data,
4934: p_encoded => Fnd_Api.G_FALSE
4935: );

Line 4949: Fnd_Msg_Pub.Count_And_Get (

4945: EXCEPTION
4946: WHEN Fnd_Api.G_EXC_ERROR THEN
4947: ROLLBACK TO SetCommittedVal_SavePoint;
4948: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4949: Fnd_Msg_Pub.Count_And_Get (
4950: p_count => x_msg_count,
4951: p_data => x_msg_data,
4952: p_encoded => FND_API.G_FALSE
4953: );

Line 4957: Fnd_Msg_Pub.Count_And_Get (

4953: );
4954: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
4955: ROLLBACK TO SetCommittedVal_SavePoint;
4956: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4957: Fnd_Msg_Pub.Count_And_Get (
4958: p_count => x_msg_count,
4959: p_data => x_msg_data,
4960: p_encoded => FND_API.G_FALSE
4961: );

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

4961: );
4962: WHEN OTHERS THEN
4963: ROLLBACK TO SetCommittedVal_SavePoint;
4964: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4965: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
4966: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
4967: END IF;
4968: Fnd_Msg_Pub.Count_And_Get (
4969: p_count => x_msg_count,

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

4962: WHEN OTHERS THEN
4963: ROLLBACK TO SetCommittedVal_SavePoint;
4964: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4965: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
4966: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
4967: END IF;
4968: Fnd_Msg_Pub.Count_And_Get (
4969: p_count => x_msg_count,
4970: p_data => x_msg_data,

Line 4968: Fnd_Msg_Pub.Count_And_Get (

4964: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4965: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
4966: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
4967: END IF;
4968: Fnd_Msg_Pub.Count_And_Get (
4969: p_count => x_msg_count,
4970: p_data => x_msg_data,
4971: p_encoded => FND_API.G_FALSE
4972: );

Line 5352: Fnd_Msg_Pub.Initialize;

5348: --
5349: -- Initialize message list if p_init_msg_list is set to TRUE.
5350: --
5351: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
5352: Fnd_Msg_Pub.Initialize;
5353: END IF;
5354:
5355: --
5356: -- Standard check for API version compatibility.

Line 5394: Fnd_Msg_Pub.Count_And_Get (

5390: --
5391: -- Standard API to get message count, and if 1,
5392: -- set the message data OUT NOCOPY variable.
5393: --
5394: Fnd_Msg_Pub.Count_And_Get (
5395: p_count => x_msg_count,
5396: p_data => x_msg_data,
5397: p_encoded => Fnd_Api.G_FALSE
5398: );

Line 5412: Fnd_Msg_Pub.Count_And_Get (

5408: EXCEPTION
5409: WHEN Fnd_Api.G_EXC_ERROR THEN
5410: ROLLBACK TO Invalidate_Rollup_pvt;
5411: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5412: Fnd_Msg_Pub.Count_And_Get (
5413: p_count => x_msg_count,
5414: p_data => x_msg_data,
5415: p_encoded => FND_API.G_FALSE
5416: );

Line 5420: Fnd_Msg_Pub.Count_And_Get (

5416: );
5417: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
5418: ROLLBACK TO Invalidate_Rollup_pvt;
5419: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5420: Fnd_Msg_Pub.Count_And_Get (
5421: p_count => x_msg_count,
5422: p_data => x_msg_data,
5423: p_encoded => FND_API.G_FALSE
5424: );

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

5424: );
5425: WHEN OTHERS THEN
5426: ROLLBACK TO Invalidate_Rollup_pvt;
5427: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5428: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5429: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
5430: END IF;
5431: Fnd_Msg_Pub.Count_And_Get (
5432: p_count => x_msg_count,

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

5425: WHEN OTHERS THEN
5426: ROLLBACK TO Invalidate_Rollup_pvt;
5427: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5428: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5429: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
5430: END IF;
5431: Fnd_Msg_Pub.Count_And_Get (
5432: p_count => x_msg_count,
5433: p_data => x_msg_data,

Line 5431: Fnd_Msg_Pub.Count_And_Get (

5427: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5428: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5429: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
5430: END IF;
5431: Fnd_Msg_Pub.Count_And_Get (
5432: p_count => x_msg_count,
5433: p_data => x_msg_data,
5434: p_encoded => FND_API.G_FALSE
5435: );

Line 5511: Fnd_Msg_Pub.Initialize;

5507: --
5508: -- Initialize message list if p_init_msg_list is set to TRUE.
5509: --
5510: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
5511: Fnd_Msg_Pub.Initialize;
5512: END IF;
5513:
5514: --
5515: -- Standard check for API version compatibility.

Line 5573: Fnd_Msg_Pub.Count_And_Get (

5569: --
5570: -- Standard API to get message count, and if 1,
5571: -- set the message data OUT NOCOPY variable.
5572: --
5573: Fnd_Msg_Pub.Count_And_Get (
5574: p_count => x_msg_count,
5575: p_data => x_msg_data,
5576: p_encoded => Fnd_Api.G_FALSE
5577: );

Line 5591: Fnd_Msg_Pub.Count_And_Get (

5587: EXCEPTION
5588: WHEN Fnd_Api.G_EXC_ERROR THEN
5589: ROLLBACK TO Post_ActMetric_pvt;
5590: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5591: Fnd_Msg_Pub.Count_And_Get (
5592: p_count => x_msg_count,
5593: p_data => x_msg_data,
5594: p_encoded => FND_API.G_FALSE
5595: );

Line 5599: Fnd_Msg_Pub.Count_And_Get (

5595: );
5596: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
5597: ROLLBACK TO Post_ActMetric_pvt;
5598: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5599: Fnd_Msg_Pub.Count_And_Get (
5600: p_count => x_msg_count,
5601: p_data => x_msg_data,
5602: p_encoded => FND_API.G_FALSE
5603: );

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

5603: );
5604: WHEN OTHERS THEN
5605: ROLLBACK TO Post_ActMetric_pvt;
5606: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5607: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5608: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
5609: END IF;
5610: Fnd_Msg_Pub.Count_And_Get (
5611: p_count => x_msg_count,

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

5604: WHEN OTHERS THEN
5605: ROLLBACK TO Post_ActMetric_pvt;
5606: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5607: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5608: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
5609: END IF;
5610: Fnd_Msg_Pub.Count_And_Get (
5611: p_count => x_msg_count,
5612: p_data => x_msg_data,

Line 5610: Fnd_Msg_Pub.Count_And_Get (

5606: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5607: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5608: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
5609: END IF;
5610: Fnd_Msg_Pub.Count_And_Get (
5611: p_count => x_msg_count,
5612: p_data => x_msg_data,
5613: p_encoded => FND_API.G_FALSE
5614: );

Line 5785: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

5781: END IF;
5782:
5783: EXCEPTION
5784: WHEN Gl_Currency_Api.NO_RATE THEN
5785: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5786: Fnd_Message.Set_Name ('AMS', 'AMS_NO_RATE');
5787: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5788: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5789: Fnd_Msg_Pub.ADD;

Line 5789: Fnd_Msg_Pub.ADD;

5785: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5786: Fnd_Message.Set_Name ('AMS', 'AMS_NO_RATE');
5787: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5788: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5789: Fnd_Msg_Pub.ADD;
5790: END IF;
5791: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5792: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5793: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

Line 5793: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

5789: Fnd_Msg_Pub.ADD;
5790: END IF;
5791: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5792: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5793: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5794: Fnd_Message.Set_Name ('AMS', 'AMS_INVALID_CURR');
5795: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5796: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5797: Fnd_Msg_Pub.ADD;

Line 5797: Fnd_Msg_Pub.ADD;

5793: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5794: Fnd_Message.Set_Name ('AMS', 'AMS_INVALID_CURR');
5795: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5796: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5797: Fnd_Msg_Pub.ADD;
5798: END IF;
5799: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5800: END Convert_Currency2;
5801:

Line 5877: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

5873: END LOOP;
5874:
5875: EXCEPTION
5876: WHEN Gl_Currency_Api.NO_RATE THEN
5877: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5878: Fnd_Message.Set_Name ('AMS', 'AMS_NO_RATE');
5879: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5880: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5881: Fnd_Msg_Pub.ADD;

Line 5881: Fnd_Msg_Pub.ADD;

5877: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5878: Fnd_Message.Set_Name ('AMS', 'AMS_NO_RATE');
5879: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5880: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5881: Fnd_Msg_Pub.ADD;
5882: END IF;
5883: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5884: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5885: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

Line 5885: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

5881: Fnd_Msg_Pub.ADD;
5882: END IF;
5883: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5884: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5885: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5886: Fnd_Message.Set_Name ('AMS', 'AMS_INVALID_CURR');
5887: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5888: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5889: Fnd_Msg_Pub.ADD;

Line 5889: Fnd_Msg_Pub.ADD;

5885: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5886: Fnd_Message.Set_Name ('AMS', 'AMS_INVALID_CURR');
5887: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5888: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5889: Fnd_Msg_Pub.ADD;
5890: END IF;
5891: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5892: END Convert_Currency_Vector;
5893:

Line 6475: Fnd_Msg_Pub.Count_And_Get (

6471:
6472: EXCEPTION
6473: WHEN Fnd_Api.G_EXC_ERROR THEN
6474: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6475: Fnd_Msg_Pub.Count_And_Get (
6476: p_count => x_msg_count,
6477: p_data => x_msg_data,
6478: p_encoded => FND_API.G_FALSE
6479: );

Line 6482: Fnd_Msg_Pub.Count_And_Get (

6478: p_encoded => FND_API.G_FALSE
6479: );
6480: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
6481: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6482: Fnd_Msg_Pub.Count_And_Get (
6483: p_count => x_msg_count,
6484: p_data => x_msg_data,
6485: p_encoded => FND_API.G_FALSE
6486: );

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

6486: );
6487: WHEN OTHERS THEN
6488: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6489: error_message := SQLERRM;
6490: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6491: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
6492: END IF;
6493: Fnd_Msg_Pub.Count_And_Get (
6494: p_count => x_msg_count,

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

6487: WHEN OTHERS THEN
6488: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6489: error_message := SQLERRM;
6490: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6491: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
6492: END IF;
6493: Fnd_Msg_Pub.Count_And_Get (
6494: p_count => x_msg_count,
6495: p_data => x_msg_data,

Line 6493: Fnd_Msg_Pub.Count_And_Get (

6489: error_message := SQLERRM;
6490: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6491: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
6492: END IF;
6493: Fnd_Msg_Pub.Count_And_Get (
6494: p_count => x_msg_count,
6495: p_data => x_msg_data,
6496: p_encoded => FND_API.G_FALSE
6497: );

Line 6707: Fnd_Msg_Pub.Initialize;

6703: --
6704: -- Initialize message list if p_init_msg_list is set to TRUE.
6705: --
6706: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
6707: Fnd_Msg_Pub.Initialize;
6708: END IF;
6709:
6710: --
6711: -- Standard check for API version compatibility.

Line 6899: Fnd_Msg_Pub.Count_And_Get (

6895: --
6896: -- Standard API to get message count, and if 1,
6897: -- set the message data OUT NOCOPY variable.
6898: --
6899: Fnd_Msg_Pub.Count_And_Get (
6900: p_count => x_msg_count,
6901: p_data => x_msg_data,
6902: p_encoded => Fnd_Api.G_FALSE
6903: );

Line 6915: Fnd_Msg_Pub.Count_And_Get (

6911:
6912: EXCEPTION
6913: WHEN Fnd_Api.G_EXC_ERROR THEN
6914: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6915: Fnd_Msg_Pub.Count_And_Get (
6916: p_count => x_msg_count,
6917: p_data => x_msg_data,
6918: p_encoded => FND_API.G_FALSE
6919: );

Line 6922: Fnd_Msg_Pub.Count_And_Get (

6918: p_encoded => FND_API.G_FALSE
6919: );
6920: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
6921: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6922: Fnd_Msg_Pub.Count_And_Get (
6923: p_count => x_msg_count,
6924: p_data => x_msg_data,
6925: p_encoded => FND_API.G_FALSE
6926: );

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

6925: p_encoded => FND_API.G_FALSE
6926: );
6927: WHEN OTHERS THEN
6928: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6929: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6930: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
6931: END IF;
6932: Fnd_Msg_Pub.Count_And_Get (
6933: p_count => x_msg_count,

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

6926: );
6927: WHEN OTHERS THEN
6928: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6929: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6930: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
6931: END IF;
6932: Fnd_Msg_Pub.Count_And_Get (
6933: p_count => x_msg_count,
6934: p_data => x_msg_data,

Line 6932: Fnd_Msg_Pub.Count_And_Get (

6928: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6929: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6930: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
6931: END IF;
6932: Fnd_Msg_Pub.Count_And_Get (
6933: p_count => x_msg_count,
6934: p_data => x_msg_data,
6935: p_encoded => FND_API.G_FALSE
6936: );

Line 7092: FND_MSG_PUB.Initialize;

7088: END IF;
7089:
7090: -- Initialize message list if p_init_msg_list is set to TRUE.
7091: IF FND_API.To_Boolean (p_init_msg_list) THEN
7092: FND_MSG_PUB.Initialize;
7093: END IF;
7094:
7095: -- Standard check for API version compatibility.
7096: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,

Line 7203: Fnd_Msg_Pub.Count_And_Get (

7199: IF FND_API.To_Boolean (p_commit) THEN
7200: COMMIT;
7201: END IF;
7202:
7203: Fnd_Msg_Pub.Count_And_Get (
7204: p_count => x_msg_count,
7205: p_data => x_msg_data,
7206: p_encoded => Fnd_Api.G_FALSE
7207: );

Line 7220: FND_MSG_PUB.Count_And_Get (

7216: EXCEPTION
7217: WHEN FND_API.G_EXC_ERROR THEN
7218: ROLLBACK TO Copy_Metric_pvt;
7219: x_return_status := FND_API.G_RET_STS_ERROR;
7220: FND_MSG_PUB.Count_And_Get (
7221: p_encoded => FND_API.g_false,
7222: p_count => x_msg_count,
7223: p_data => x_msg_data
7224: );

Line 7229: FND_MSG_PUB.Count_And_Get (

7225:
7226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7227: ROLLBACK TO Copy_Metric_pvt;
7228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7229: FND_MSG_PUB.Count_And_Get (
7230: p_encoded => FND_API.g_false,
7231: p_count => x_msg_count,
7232: p_data => x_msg_data
7233: );

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

7234:
7235: WHEN OTHERS THEN
7236: ROLLBACK TO Copy_Metric_pvt;
7237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7239: THEN
7240: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
7241: END IF;
7242:

Line 7240: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

7236: ROLLBACK TO Copy_Metric_pvt;
7237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7238: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7239: THEN
7240: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
7241: END IF;
7242:
7243: FND_MSG_PUB.Count_And_Get (
7244: p_encoded => FND_API.g_false,

Line 7243: FND_MSG_PUB.Count_And_Get (

7239: THEN
7240: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
7241: END IF;
7242:
7243: FND_MSG_PUB.Count_And_Get (
7244: p_encoded => FND_API.g_false,
7245: p_count => x_msg_count,
7246: p_data => x_msg_data
7247: );

Line 7324: Fnd_Msg_Pub.Initialize;

7320: END IF;
7321:
7322: -- Initialize message list if p_init_msg_list is set to TRUE.
7323: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
7324: Fnd_Msg_Pub.Initialize;
7325: END IF;
7326:
7327: -- Standard check for API version compatibility.
7328: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,

Line 7381: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

7377: l_object_name := ams_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER', l_source_object_type);
7378:
7379: --the object type passed is not a valid one for metrics.
7380: IF (l_valid_object = Fnd_Api.G_FALSE) THEN
7381: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7382: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_OBJECTS');
7383: Fnd_Msg_Pub.ADD;
7384: END IF;
7385: l_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 7383: Fnd_Msg_Pub.ADD;

7379: --the object type passed is not a valid one for metrics.
7380: IF (l_valid_object = Fnd_Api.G_FALSE) THEN
7381: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7382: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_OBJECTS');
7383: Fnd_Msg_Pub.ADD;
7384: END IF;
7385: l_return_status := Fnd_Api.G_RET_STS_ERROR;
7386:
7387: END IF;

Line 7391: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

7387: END IF;
7388:
7389: --check if source object was not found
7390: IF (l_source_object_exists = Fnd_Api.G_FALSE) THEN
7391: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7392: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_SOURCE');
7393: Fnd_Message.set_token('OBJECT', l_object_name);
7394: Fnd_Msg_Pub.ADD;
7395: END IF;

Line 7394: Fnd_Msg_Pub.ADD;

7390: IF (l_source_object_exists = Fnd_Api.G_FALSE) THEN
7391: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7392: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_SOURCE');
7393: Fnd_Message.set_token('OBJECT', l_object_name);
7394: Fnd_Msg_Pub.ADD;
7395: END IF;
7396: l_return_status := Fnd_Api.G_RET_STS_ERROR;
7397: END IF;
7398:

Line 7429: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

7425: END IF;
7426:
7427: --check if target object was not found
7428: IF (l_target_object_exists = Fnd_Api.G_FALSE) THEN
7429: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7430: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_TARGET');
7431: Fnd_Message.set_token('OBJECT', l_object_name);
7432: Fnd_Msg_Pub.ADD;
7433: END IF;

Line 7432: Fnd_Msg_Pub.ADD;

7428: IF (l_target_object_exists = Fnd_Api.G_FALSE) THEN
7429: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7430: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_TARGET');
7431: Fnd_Message.set_token('OBJECT', l_object_name);
7432: Fnd_Msg_Pub.ADD;
7433: END IF;
7434: l_return_status := Fnd_Api.G_RET_STS_ERROR;
7435:
7436: END IF;

Line 7442: FND_MSG_PUB.Count_And_Get (

7438: -- End API Body.
7439:
7440: -- Standard API to get message count, and if 1,
7441: -- set the message data OUT variable.
7442: FND_MSG_PUB.Count_And_Get (
7443: p_count => x_msg_count,
7444: p_data => x_msg_data,
7445: p_encoded => FND_API.G_FALSE
7446: );

Line 7492: Fnd_Msg_Pub.Initialize;

7488: --
7489: -- Initialize message list if p_init_msg_list is set to TRUE.
7490: --
7491: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
7492: Fnd_Msg_Pub.Initialize;
7493: END IF;
7494:
7495: --
7496: -- Standard check for API version compatibility.

Line 7611: Fnd_Msg_Pub.Initialize;

7607: --
7608: -- Initialize message list if p_init_msg_list is set to TRUE.
7609: --
7610: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
7611: Fnd_Msg_Pub.Initialize;
7612: END IF;
7613:
7614: --
7615: -- Standard check for API version compatibility.

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

7637: EXCEPTION
7638: WHEN OTHERS THEN
7639: ROLLBACK TO delete_actmetrics_assoc;
7640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7641: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7642: THEN
7643: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
7644: END IF;
7645:

Line 7643: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

7639: ROLLBACK TO delete_actmetrics_assoc;
7640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7641: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7642: THEN
7643: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
7644: END IF;
7645:
7646: FND_MSG_PUB.Count_And_Get (
7647: p_encoded => FND_API.g_false,

Line 7646: FND_MSG_PUB.Count_And_Get (

7642: THEN
7643: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
7644: END IF;
7645:
7646: FND_MSG_PUB.Count_And_Get (
7647: p_encoded => FND_API.g_false,
7648: p_count => x_msg_count,
7649: p_data => x_msg_data
7650: );