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 1658: Fnd_Msg_Pub.Initialize;

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

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

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

Line 1718: Fnd_Msg_Pub.ADD;

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

Line 2108: --Fnd_Msg_Pub.Count_And_Get (

2104: --
2105: -- Standard API to get message count, and if 1,
2106: -- set the message data OUT NOCOPY variable.
2107: --
2108: --Fnd_Msg_Pub.Count_And_Get (
2109: -- p_count => x_msg_count,
2110: -- p_data => x_msg_data,
2111: -- p_encoded => Fnd_Api.G_FALSE
2112: --);

Line 2127: Fnd_Msg_Pub.Count_And_Get (

2123: WHEN Fnd_Api.G_EXC_ERROR THEN
2124: ROLLBACK TO Create_ActMetric2_pvt;
2125: --ROLLBACK;
2126: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2127: Fnd_Msg_Pub.Count_And_Get (
2128: p_count => x_msg_count,
2129: p_data => x_msg_data,
2130: p_encoded => FND_API.G_FALSE
2131: );

Line 2136: Fnd_Msg_Pub.Count_And_Get (

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

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

2141: WHEN OTHERS THEN
2142: ROLLBACK TO Create_ActMetric2_pvt;
2143: --ROLLBACK;
2144: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2145: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2146: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2147: END IF;
2148: Fnd_Msg_Pub.Count_And_Get (
2149: p_count => x_msg_count,

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

2142: ROLLBACK TO Create_ActMetric2_pvt;
2143: --ROLLBACK;
2144: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2145: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2146: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2147: END IF;
2148: Fnd_Msg_Pub.Count_And_Get (
2149: p_count => x_msg_count,
2150: p_data => x_msg_data,

Line 2148: Fnd_Msg_Pub.Count_And_Get (

2144: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2145: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2146: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2147: END IF;
2148: Fnd_Msg_Pub.Count_And_Get (
2149: p_count => x_msg_count,
2150: p_data => x_msg_data,
2151: p_encoded => FND_API.G_FALSE
2152: );

Line 2241: Fnd_Msg_Pub.Initialize;

2237: --
2238: -- Initialize message list if p_init_msg_list is set to TRUE.
2239: --
2240: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
2241: Fnd_Msg_Pub.Initialize;
2242: END IF;
2243:
2244: --
2245: -- Standard check for API version compatibility.

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

2300: END IF;
2301:
2302: -- DMVINCEN 06/05/2001: If value is posted to budget do not update.
2303: IF l_actmet_rec.published_flag = 'Y' THEN
2304: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2305: l_actmet_rec.trans_actual_value := Fnd_Api.G_MISS_NUM;
2306: l_actmet_rec.func_actual_value := Fnd_Api.G_MISS_NUM;
2307: l_reprocess_rec := Fnd_Api.G_TRUE;
2308: END IF;

Line 2383: -- Fnd_Msg_Pub.Initialize;

2379: x_msg_count => x_msg_count,
2380: x_msg_data => x_msg_data);
2381: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2382: -- BUG2486379: Display budget utilization errors.
2383: -- Fnd_Msg_Pub.Initialize;
2384: Fnd_Message.set_name('AMS', 'AMS_MET_NO_POST');
2385: Fnd_Msg_Pub.ADD;
2386: --IF (AMS_DEBUG_HIGH_ON) THEN
2387: -- Ams_Utility_Pvt.debug_message('You can not post this cost!');

Line 2385: Fnd_Msg_Pub.ADD;

2381: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2382: -- BUG2486379: Display budget utilization errors.
2383: -- Fnd_Msg_Pub.Initialize;
2384: Fnd_Message.set_name('AMS', 'AMS_MET_NO_POST');
2385: Fnd_Msg_Pub.ADD;
2386: --IF (AMS_DEBUG_HIGH_ON) THEN
2387: -- Ams_Utility_Pvt.debug_message('You can not post this cost!');
2388: --END IF;
2389: END IF;

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

2479: THEN
2480: --
2481: -- Add error message to API message list.
2482: --
2483: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2484: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2485: Fnd_Msg_Pub.ADD;
2486: END IF;
2487: RAISE Fnd_Api.g_exc_error;

Line 2485: Fnd_Msg_Pub.ADD;

2481: -- Add error message to API message list.
2482: --
2483: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2484: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2485: Fnd_Msg_Pub.ADD;
2486: END IF;
2487: RAISE Fnd_Api.g_exc_error;
2488: END IF;
2489:

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

2498: IF (SQL%NOTFOUND) THEN
2499: --
2500: -- Add error message to API message list.
2501: --
2502: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2503: Fnd_Message.set_name('AMS', 'AMS_API_VARREC_NOT_FOUND');
2504: Fnd_Msg_Pub.ADD;
2505: END IF;
2506: RAISE Fnd_Api.g_exc_error;

Line 2504: Fnd_Msg_Pub.ADD;

2500: -- Add error message to API message list.
2501: --
2502: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2503: Fnd_Message.set_name('AMS', 'AMS_API_VARREC_NOT_FOUND');
2504: Fnd_Msg_Pub.ADD;
2505: END IF;
2506: RAISE Fnd_Api.g_exc_error;
2507: END IF;
2508: END IF;

Line 2533: Fnd_Msg_Pub.Count_And_Get (

2529: --
2530: -- Standard API to get message count, and if 1,
2531: -- set the message data OUT variable.
2532: --
2533: Fnd_Msg_Pub.Count_And_Get (
2534: p_count => x_msg_count,
2535: p_data => x_msg_data,
2536: p_encoded => Fnd_Api.G_FALSE
2537: );

Line 2551: Fnd_Msg_Pub.Count_And_Get (

2547: EXCEPTION
2548: WHEN Fnd_Api.G_EXC_ERROR THEN
2549: ROLLBACK TO Update_ActMetric_pvt;
2550: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2551: Fnd_Msg_Pub.Count_And_Get (
2552: p_count => x_msg_count,
2553: p_data => x_msg_data,
2554: p_encoded => FND_API.G_FALSE
2555: );

Line 2559: Fnd_Msg_Pub.Count_And_Get (

2555: );
2556: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2557: ROLLBACK TO Update_ActMetric_pvt;
2558: x_return_status := Fnd_Api.G_RET_STS_UNEXP_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: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

2563: );
2564: WHEN OTHERS THEN
2565: ROLLBACK TO Update_ActMetric_pvt;
2566: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2567: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2568: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2569: END IF;
2570: Fnd_Msg_Pub.Count_And_Get (
2571: p_count => x_msg_count,

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

2564: WHEN OTHERS THEN
2565: ROLLBACK TO Update_ActMetric_pvt;
2566: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2567: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2568: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2569: END IF;
2570: Fnd_Msg_Pub.Count_And_Get (
2571: p_count => x_msg_count,
2572: p_data => x_msg_data,

Line 2570: Fnd_Msg_Pub.Count_And_Get (

2566: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2567: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2568: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2569: END IF;
2570: Fnd_Msg_Pub.Count_And_Get (
2571: p_count => x_msg_count,
2572: p_data => x_msg_data,
2573: p_encoded => FND_API.G_FALSE
2574: );

Line 2745: Fnd_Msg_Pub.Initialize;

2741: --
2742: -- Initialize message list if p_init_msg_list is set to TRUE.
2743: --
2744: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
2745: Fnd_Msg_Pub.Initialize;
2746: END IF;
2747:
2748: --
2749: -- Standard check for API version compatibility.

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

2761: -- Check if record is seeded.
2762: --
2763: -- DMVINCEN: There is no reason for this restriction.
2764: -- IF IsSeeded (p_activity_metric_id) THEN
2765: -- IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
2766: -- THEN
2767: -- Fnd_Message.set_name('AMS', 'AMS_METR_SEEDED_METR');
2768: -- Fnd_Msg_Pub.ADD;
2769: -- END IF;

Line 2768: -- Fnd_Msg_Pub.ADD;

2764: -- IF IsSeeded (p_activity_metric_id) THEN
2765: -- IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
2766: -- THEN
2767: -- Fnd_Message.set_name('AMS', 'AMS_METR_SEEDED_METR');
2768: -- Fnd_Msg_Pub.ADD;
2769: -- END IF;
2770: --
2771: -- RAISE Fnd_Api.G_EXC_ERROR;
2772: -- END IF;

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

2798: END LOOP;
2799: CLOSE c_check_child_exists;
2800:
2801: IF l_child_type = 'SUMMARY' THEN
2802: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2803: Fnd_Message.set_name('AMS', 'AMS_METR_CANT_DELETE_PARENT');
2804: Fnd_Msg_Pub.ADD;
2805: END IF;
2806: RAISE Fnd_Api.g_exc_error;

Line 2804: Fnd_Msg_Pub.ADD;

2800:
2801: IF l_child_type = 'SUMMARY' THEN
2802: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2803: Fnd_Message.set_name('AMS', 'AMS_METR_CANT_DELETE_PARENT');
2804: Fnd_Msg_Pub.ADD;
2805: END IF;
2806: RAISE Fnd_Api.g_exc_error;
2807: END IF;
2808: -- end for the bug fix, sveerave.

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

2811: -- freeze validation.
2812: OPEN c_actmet_details(p_activity_metric_id);
2813: FETCH c_actmet_details INTO l_act_metric_rec;
2814: IF (c_actmet_details%NOTFOUND) THEN
2815: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2816: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2817: Fnd_Msg_Pub.ADD;
2818: END IF;
2819: RAISE Fnd_Api.g_exc_error;

Line 2817: Fnd_Msg_Pub.ADD;

2813: FETCH c_actmet_details INTO l_act_metric_rec;
2814: IF (c_actmet_details%NOTFOUND) THEN
2815: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2816: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2817: Fnd_Msg_Pub.ADD;
2818: END IF;
2819: RAISE Fnd_Api.g_exc_error;
2820: END IF;
2821:

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

2829: l_return_status);
2830:
2831: IF (l_freeze_status = Fnd_Api.G_TRUE) THEN
2832: -- frozen to create the record
2833: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2834: -- sunkumar 04/30/2003 added message for delete status of objects depending on status (ACTIVE, CANCELLED, COMPLETED)
2835: l_object_name := ams_utility_pvt.get_lookup_meaning(
2836: 'AMS_SYS_ARC_QUALIFIER',l_act_metric_rec.arc_act_metric_used_by);
2837: Fnd_Message.Set_Name('AMS', 'AMS_METR_DELETE');

Line 2839: Fnd_Msg_Pub.ADD;

2835: l_object_name := ams_utility_pvt.get_lookup_meaning(
2836: 'AMS_SYS_ARC_QUALIFIER',l_act_metric_rec.arc_act_metric_used_by);
2837: Fnd_Message.Set_Name('AMS', 'AMS_METR_DELETE');
2838: Fnd_Message.set_token('OBJECT', l_object_name);
2839: Fnd_Msg_Pub.ADD;
2840: END IF;
2841: l_return_status := Fnd_Api.G_RET_STS_ERROR;
2842: END IF;
2843:

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

2851:
2852:
2853: IF (l_freeze_status = Fnd_Api.G_TRUE) THEN
2854: -- frozen to create the record
2855: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2856: Fnd_Message.Set_Name('AMS', 'AMS_METR_FROZEN');
2857: Fnd_Msg_Pub.ADD;
2858: END IF;
2859: l_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 2857: Fnd_Msg_Pub.ADD;

2853: IF (l_freeze_status = Fnd_Api.G_TRUE) THEN
2854: -- frozen to create the record
2855: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
2856: Fnd_Message.Set_Name('AMS', 'AMS_METR_FROZEN');
2857: Fnd_Msg_Pub.ADD;
2858: END IF;
2859: l_return_status := Fnd_Api.G_RET_STS_ERROR;
2860: END IF;
2861:

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

2867: END IF;
2868:
2869: -- If the actual value has been posted to the budget do not delete.
2870: IF l_act_metric_rec.published_flag = 'Y' THEN
2871: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2872: Fnd_Message.SET_NAME('AMS', 'AMS_METR_PUBLISHED');
2873: Fnd_Msg_Pub.ADD;
2874: END IF;
2875: RAISE Fnd_Api.g_exc_error;

Line 2873: Fnd_Msg_Pub.ADD;

2869: -- If the actual value has been posted to the budget do not delete.
2870: IF l_act_metric_rec.published_flag = 'Y' THEN
2871: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2872: Fnd_Message.SET_NAME('AMS', 'AMS_METR_PUBLISHED');
2873: Fnd_Msg_Pub.ADD;
2874: END IF;
2875: RAISE Fnd_Api.g_exc_error;
2876: END IF;
2877:

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

2895: WHERE activity_metric_id = p_activity_metric_id
2896: AND object_version_number = p_object_version_number;
2897:
2898: IF SQL%NOTFOUND THEN
2899: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2900: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2901: Fnd_Msg_Pub.ADD;
2902: END IF;
2903: RAISE Fnd_Api.g_exc_error;

Line 2901: Fnd_Msg_Pub.ADD;

2897:
2898: IF SQL%NOTFOUND THEN
2899: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
2900: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2901: Fnd_Msg_Pub.ADD;
2902: END IF;
2903: RAISE Fnd_Api.g_exc_error;
2904: END IF;
2905:

Line 2954: Fnd_Msg_Pub.Count_And_Get (

2950: --
2951: -- Standard API to get message count, and if 1,
2952: -- set the message data OUT NOCOPY variable.
2953: --
2954: Fnd_Msg_Pub.Count_And_Get (
2955: p_count => x_msg_count,
2956: p_data => x_msg_data,
2957: p_encoded => Fnd_Api.G_FALSE
2958: );

Line 2964: Fnd_Msg_Pub.Count_And_Get (

2960: EXCEPTION
2961: WHEN Fnd_Api.G_EXC_ERROR THEN
2962: ROLLBACK TO Delete_ActMetric_pvt;
2963: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2964: Fnd_Msg_Pub.Count_And_Get (
2965: p_count => x_msg_count,
2966: p_data => x_msg_data,
2967: p_encoded => FND_API.G_FALSE
2968: );

Line 2972: Fnd_Msg_Pub.Count_And_Get (

2968: );
2969: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2970: ROLLBACK TO Delete_ActMetric_pvt;
2971: x_return_status := Fnd_Api.G_RET_STS_UNEXP_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: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

2976: );
2977: WHEN OTHERS THEN
2978: ROLLBACK TO Delete_ActMetric_pvt;
2979: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2980: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2981: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2982: END IF;
2983: Fnd_Msg_Pub.Count_And_Get (
2984: p_count => x_msg_count,

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

2977: WHEN OTHERS THEN
2978: ROLLBACK TO Delete_ActMetric_pvt;
2979: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2980: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2981: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2982: END IF;
2983: Fnd_Msg_Pub.Count_And_Get (
2984: p_count => x_msg_count,
2985: p_data => x_msg_data,

Line 2983: Fnd_Msg_Pub.Count_And_Get (

2979: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2980: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
2981: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
2982: END IF;
2983: Fnd_Msg_Pub.Count_And_Get (
2984: p_count => x_msg_count,
2985: p_data => x_msg_data,
2986: p_encoded => FND_API.G_FALSE
2987: );

Line 3071: Fnd_Msg_Pub.Initialize;

3067: --
3068: -- Initialize message list if p_init_msg_list is set to TRUE.
3069: --
3070: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
3071: Fnd_Msg_Pub.Initialize;
3072: END IF;
3073:
3074: --
3075: -- Standard check for API version compatibility.

Line 3204: Fnd_Msg_Pub.Count_And_Get (

3200: --
3201: -- Standard API to get message count, and if 1,
3202: -- set the message data OUT NOCOPY variable.
3203: --
3204: Fnd_Msg_Pub.Count_And_Get (
3205: p_count => x_msg_count,
3206: p_data => x_msg_data,
3207: p_encoded => Fnd_Api.G_FALSE
3208: );

Line 3214: Fnd_Msg_Pub.Count_And_Get (

3210: EXCEPTION
3211: WHEN Fnd_Api.G_EXC_ERROR THEN
3212: -- ROLLBACK TO Delete_ActMetric_By_Object_pvt;
3213: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3214: Fnd_Msg_Pub.Count_And_Get (
3215: p_count => x_msg_count,
3216: p_data => x_msg_data,
3217: p_encoded => FND_API.G_FALSE
3218: );

Line 3222: Fnd_Msg_Pub.Count_And_Get (

3218: );
3219: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
3220: -- ROLLBACK TO Delete_ActMetric_By_Object_pvt;
3221: x_return_status := Fnd_Api.G_RET_STS_UNEXP_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: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

3226: );
3227: WHEN OTHERS THEN
3228: -- ROLLBACK TO Delete_ActMetric_By_Object_pvt;
3229: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3230: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3231: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3232: END IF;
3233: Fnd_Msg_Pub.Count_And_Get (
3234: p_count => x_msg_count,

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

3227: WHEN OTHERS THEN
3228: -- ROLLBACK TO Delete_ActMetric_By_Object_pvt;
3229: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3230: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3231: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3232: END IF;
3233: Fnd_Msg_Pub.Count_And_Get (
3234: p_count => x_msg_count,
3235: p_data => x_msg_data,

Line 3233: Fnd_Msg_Pub.Count_And_Get (

3229: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3230: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3231: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3232: END IF;
3233: Fnd_Msg_Pub.Count_And_Get (
3234: p_count => x_msg_count,
3235: p_data => x_msg_data,
3236: p_encoded => FND_API.G_FALSE
3237: );

Line 3299: Fnd_Msg_Pub.Initialize;

3295: --
3296: -- Initialize message list if p_init_msg_list is set to TRUE.
3297: --
3298: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
3299: Fnd_Msg_Pub.Initialize;
3300: END IF;
3301:
3302: --
3303: -- Standard check for API version compatibility.

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

3329: THEN
3330: CLOSE c_act_metrics_info;
3331: -- Error, check the msg level and added an error message to the
3332: -- API message list
3333: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3334: l_metrics_name := null;
3335: OPEN c_metric_info(p_activity_metric_id);
3336: FETCH c_metric_info INTO l_metrics_name;
3337: CLOSE c_metric_info;

Line 3341: Fnd_Msg_Pub.ADD;

3337: CLOSE c_metric_info;
3338: IF l_metrics_name is not null THEN
3339: Fnd_Message.set_name('AMS', 'AMS_METR_RECORD_NOT_FOUND');
3340: Fnd_Message.set_token('METRIC', l_metrics_name);
3341: Fnd_Msg_Pub.ADD;
3342: ELSE
3343: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3344: Fnd_Msg_Pub.ADD;
3345: END IF;

Line 3344: Fnd_Msg_Pub.ADD;

3340: Fnd_Message.set_token('METRIC', l_metrics_name);
3341: Fnd_Msg_Pub.ADD;
3342: ELSE
3343: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3344: Fnd_Msg_Pub.ADD;
3345: END IF;
3346: END IF;
3347: RAISE Fnd_Api.g_exc_error;
3348: END IF;

Line 3356: Fnd_Msg_Pub.Count_And_Get (

3352: --
3353: -- Standard API to get message count, and if 1,
3354: -- set the message data OUT NOCOPY variable.
3355: --
3356: Fnd_Msg_Pub.Count_And_Get (
3357: p_count => x_msg_count,
3358: p_data => x_msg_data,
3359: p_encoded => Fnd_Api.G_FALSE
3360: );

Line 3373: Fnd_Msg_Pub.Count_And_Get (

3369:
3370: EXCEPTION
3371: WHEN Fnd_Api.G_EXC_ERROR THEN
3372: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3373: Fnd_Msg_Pub.Count_And_Get (
3374: p_count => x_msg_count,
3375: p_data => x_msg_data,
3376: p_encoded => FND_API.G_FALSE
3377: );

Line 3380: Fnd_Msg_Pub.Count_And_Get (

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

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

3384: );
3385: WHEN Ams_Utility_Pvt.RESOURCE_LOCKED THEN
3386: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
3387:
3388: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3389: Fnd_Message.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
3390: Fnd_Msg_Pub.ADD;
3391: END IF;
3392:

Line 3390: Fnd_Msg_Pub.ADD;

3386: x_return_status := Fnd_Api.G_RET_STS_ERROR ;
3387:
3388: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3389: Fnd_Message.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
3390: Fnd_Msg_Pub.ADD;
3391: END IF;
3392:
3393: Fnd_Msg_Pub.Count_And_Get (
3394: p_count => x_msg_count,

Line 3393: Fnd_Msg_Pub.Count_And_Get (

3389: Fnd_Message.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
3390: Fnd_Msg_Pub.ADD;
3391: END IF;
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 3400: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

3396: p_encoded => Fnd_Api.G_FALSE
3397: );
3398: WHEN OTHERS THEN
3399: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3400: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3401: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3402: END IF;
3403: Fnd_Msg_Pub.Count_And_Get (
3404: p_count => x_msg_count,

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

3397: );
3398: WHEN OTHERS THEN
3399: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3400: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3401: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3402: END IF;
3403: Fnd_Msg_Pub.Count_And_Get (
3404: p_count => x_msg_count,
3405: p_data => x_msg_data,

Line 3403: Fnd_Msg_Pub.Count_And_Get (

3399: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3400: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3401: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3402: END IF;
3403: Fnd_Msg_Pub.Count_And_Get (
3404: p_count => x_msg_count,
3405: p_data => x_msg_data,
3406: p_encoded => Fnd_Api.G_FALSE
3407: );

Line 3456: Fnd_Msg_Pub.Initialize;

3452: --
3453: -- Initialize message list if p_init_msg_list is set to TRUE.
3454: --
3455: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
3456: Fnd_Msg_Pub.Initialize;
3457: END IF;
3458:
3459: --
3460: -- Standard check for API version compatibility.

Line 3526: Fnd_Msg_Pub.Count_And_Get (

3522: --
3523: -- Standard API to get message count, and if 1,
3524: -- set the message data OUT NOCOPY variable.
3525: --
3526: Fnd_Msg_Pub.Count_And_Get (
3527: p_count => x_msg_count,
3528: p_data => x_msg_data,
3529: p_encoded => Fnd_Api.G_FALSE
3530: );

Line 3539: Fnd_Msg_Pub.Count_And_Get (

3535:
3536: EXCEPTION
3537: WHEN Fnd_Api.G_EXC_ERROR THEN
3538: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3539: Fnd_Msg_Pub.Count_And_Get (
3540: p_count => x_msg_count,
3541: p_data => x_msg_data,
3542: p_encoded => FND_API.G_FALSE
3543: );

Line 3546: Fnd_Msg_Pub.Count_And_Get (

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

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

3549: p_encoded => FND_API.G_FALSE
3550: );
3551: WHEN OTHERS THEN
3552: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3553: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3554: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3555: END IF;
3556: Fnd_Msg_Pub.Count_And_Get (
3557: p_count => x_msg_count,

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

3550: );
3551: WHEN OTHERS THEN
3552: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3553: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3554: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3555: END IF;
3556: Fnd_Msg_Pub.Count_And_Get (
3557: p_count => x_msg_count,
3558: p_data => x_msg_data,

Line 3556: Fnd_Msg_Pub.Count_And_Get (

3552: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3553: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
3554: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3555: END IF;
3556: Fnd_Msg_Pub.Count_And_Get (
3557: p_count => x_msg_count,
3558: p_data => x_msg_data,
3559: p_encoded => FND_API.G_FALSE
3560: );

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

3591:
3592: IF p_act_metric_rec.application_id IS NULL
3593: THEN
3594: -- missing required fields
3595: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3596: THEN -- MMSG
3597: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_APP_ID');
3598: Fnd_Msg_Pub.ADD;
3599: END IF;

Line 3598: Fnd_Msg_Pub.ADD;

3594: -- missing required fields
3595: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3596: THEN -- MMSG
3597: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_APP_ID');
3598: Fnd_Msg_Pub.ADD;
3599: END IF;
3600:
3601: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3602:

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

3608:
3609: IF p_act_metric_rec.arc_act_metric_used_by IS NULL
3610: THEN
3611: -- missing required fields
3612: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3613: THEN -- MMSG
3614: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_ARC_USED_FOR');
3615: Fnd_Msg_Pub.ADD;
3616: END IF;

Line 3615: Fnd_Msg_Pub.ADD;

3611: -- missing required fields
3612: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3613: THEN -- MMSG
3614: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_ARC_USED_FOR');
3615: Fnd_Msg_Pub.ADD;
3616: END IF;
3617:
3618: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3619:

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

3626:
3627: IF p_act_metric_rec.act_metric_used_by_id IS NULL
3628: THEN
3629: -- missing required fields
3630: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3631: THEN -- MMSG
3632: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_ARC_USED_FOR');
3633: Fnd_Msg_Pub.ADD;
3634: END IF;

Line 3633: Fnd_Msg_Pub.ADD;

3629: -- missing required fields
3630: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3631: THEN -- MMSG
3632: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_ARC_USED_FOR');
3633: Fnd_Msg_Pub.ADD;
3634: END IF;
3635:
3636: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3637:

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

3643:
3644: IF p_act_metric_rec.metric_id IS NULL
3645: THEN
3646: -- missing required fields
3647: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3648: THEN -- MMSG
3649: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_METRIC_ID');
3650: Fnd_Msg_Pub.ADD;
3651: END IF;

Line 3650: Fnd_Msg_Pub.ADD;

3646: -- missing required fields
3647: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3648: THEN -- MMSG
3649: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_METRIC_ID');
3650: Fnd_Msg_Pub.ADD;
3651: END IF;
3652:
3653: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3654:

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

3662:
3663: IF p_act_metric_rec.metric_uom_code IS NULL
3664: THEN
3665: -- missing required fields
3666: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3667: THEN -- MMSG
3668: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_UOM');
3669: FND_MSG_PUB.Add;
3670: END IF;

Line 3669: FND_MSG_PUB.Add;

3665: -- missing required fields
3666: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3667: THEN -- MMSG
3668: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_MISSING_UOM');
3669: FND_MSG_PUB.Add;
3670: END IF;
3671:
3672: x_return_status := FND_API.G_RET_STS_ERROR;
3673:

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

3682:
3683: IF p_act_metric_rec.sensitive_data_flag IS NULL
3684: THEN
3685: -- missing required fields
3686: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3687: THEN -- MMSG
3688: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_SENSITIVE');
3689: Fnd_Msg_Pub.ADD;
3690: END IF;

Line 3689: Fnd_Msg_Pub.ADD;

3685: -- missing required fields
3686: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3687: THEN -- MMSG
3688: Fnd_Message.Set_Name('AMS', 'AMS_METR_MISSING_SENSITIVE');
3689: Fnd_Msg_Pub.ADD;
3690: END IF;
3691:
3692: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3693:

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

3762: p_table_name => 'ams_act_metrics_all',
3763: p_where_clause => l_where_clause
3764: ) = Fnd_Api.g_false
3765: THEN
3766: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
3767: THEN
3768: Fnd_Message.set_name('AMS', 'AMS_METR_ACT_DUP_ID');
3769: Fnd_Msg_Pub.ADD;
3770: END IF;

Line 3769: Fnd_Msg_Pub.ADD;

3765: THEN
3766: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error)
3767: THEN
3768: Fnd_Message.set_name('AMS', 'AMS_METR_ACT_DUP_ID');
3769: Fnd_Msg_Pub.ADD;
3770: END IF;
3771: x_return_status := Fnd_Api.g_ret_sts_error;
3772: RETURN;
3773: END IF;

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

3786: FETCH c_check_function INTO l_test;
3787: CLOSE c_check_function;
3788:
3789: IF l_test IS NULL THEN
3790: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3791: Fnd_Message.set_name('AMS', 'AMS_ACT_MET_DUP_FUNCTION');
3792: Fnd_Msg_Pub.ADD;
3793: END IF;
3794: x_return_status := Fnd_Api.g_ret_sts_error;

Line 3792: Fnd_Msg_Pub.ADD;

3788:
3789: IF l_test IS NULL THEN
3790: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
3791: Fnd_Message.set_name('AMS', 'AMS_ACT_MET_DUP_FUNCTION');
3792: Fnd_Msg_Pub.ADD;
3793: END IF;
3794: x_return_status := Fnd_Api.g_ret_sts_error;
3795: END IF;
3796:

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

3871:
3872: OPEN c_check_metric_id(l_act_metrics_rec.metric_id);
3873: IF c_check_metric_id%NOTFOUND
3874: THEN
3875: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3876: THEN
3877: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_MET');
3878: FND_MSG_PUB.ADD;
3879: END IF;

Line 3878: FND_MSG_PUB.ADD;

3874: THEN
3875: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3876: THEN
3877: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_MET');
3878: FND_MSG_PUB.ADD;
3879: END IF;
3880:
3881: x_return_status := FND_API.G_RET_STS_ERROR;
3882: CLOSE c_check_metric_id;

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

3890:
3891: OPEN c_check_currency(l_act_metrics_rec.transaction_currency_code,'Y');
3892: IF c_check_currency%NOTFOUND
3893: THEN
3894: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3895: THEN
3896: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_TRANS_CUR');
3897: FND_MSG_PUB.ADD;
3898: END IF;

Line 3897: FND_MSG_PUB.ADD;

3893: THEN
3894: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3895: THEN
3896: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_TRANS_CUR');
3897: FND_MSG_PUB.ADD;
3898: END IF;
3899:
3900: x_return_status := FND_API.G_RET_STS_ERROR;
3901: CLOSE c_check_currency;

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

3912:
3913: OPEN c_check_currency(l_act_metrics_rec.functional_currency_code,'Y');
3914: IF c_check_currency%NOTFOUND
3915: THEN
3916: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3917: THEN
3918: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_FUNC_CUR');
3919: FND_MSG_PUB.ADD;
3920: END IF;

Line 3919: FND_MSG_PUB.ADD;

3915: THEN
3916: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3917: THEN
3918: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_FUNC_CUR');
3919: FND_MSG_PUB.ADD;
3920: END IF;
3921:
3922: x_return_status := FND_API.G_RET_STS_ERROR;
3923: RETURN;

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

3940: ,p_pk_data_type => l_pk_data_type
3941: ,p_additional_where_clause => l_additional_where_clause
3942: ) = Fnd_Api.G_FALSE
3943: THEN
3944: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3945: THEN
3946: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_TRANS_CUR');
3947: Fnd_Msg_Pub.ADD;
3948: END IF;

Line 3947: Fnd_Msg_Pub.ADD;

3943: THEN
3944: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3945: THEN
3946: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_TRANS_CUR');
3947: Fnd_Msg_Pub.ADD;
3948: END IF;
3949:
3950: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3951: RETURN;

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

3966: ,p_pk_data_type => l_pk_data_type
3967: ,p_additional_where_clause => l_additional_where_clause
3968: ) = Fnd_Api.G_FALSE
3969: THEN
3970: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3971: THEN
3972: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_FUNC_CUR');
3973: Fnd_Msg_Pub.ADD;
3974: END IF;

Line 3973: Fnd_Msg_Pub.ADD;

3969: THEN
3970: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3971: THEN
3972: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_FUNC_CUR');
3973: Fnd_Msg_Pub.ADD;
3974: END IF;
3975:
3976: x_return_status := Fnd_Api.G_RET_STS_ERROR;
3977: RETURN;

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

3991: IF l_act_metrics_rec.sensitive_data_flag <> Fnd_Api.G_MISS_CHAR THEN
3992: IF Ams_Utility_Pvt.Is_Y_Or_N (l_act_metrics_rec.sensitive_data_flag)
3993: = Fnd_Api.G_FALSE
3994: THEN
3995: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3996: THEN
3997: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_SENS_FLAG');
3998: Fnd_Msg_Pub.ADD;
3999: END IF;

Line 3998: Fnd_Msg_Pub.ADD;

3994: THEN
3995: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
3996: THEN
3997: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_SENS_FLAG');
3998: Fnd_Msg_Pub.ADD;
3999: END IF;
4000:
4001: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4002: RETURN;

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

4018: OPEN c_arc_metric_usage(l_act_metrics_rec.arc_act_metric_used_by);
4019: FETCH c_arc_metric_usage INTO l_dummy;
4020: CLOSE c_arc_metric_usage;
4021: IF l_dummy IS NULL THEN
4022: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4023: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_USED_BY');
4024: FND_MSG_PUB.add;
4025: END IF;
4026: x_return_status := FND_API.g_ret_sts_error;

Line 4024: FND_MSG_PUB.add;

4020: CLOSE c_arc_metric_usage;
4021: IF l_dummy IS NULL THEN
4022: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4023: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_USED_BY');
4024: FND_MSG_PUB.add;
4025: END IF;
4026: x_return_status := FND_API.g_ret_sts_error;
4027: END IF;
4028: END IF;

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

4035: OPEN c_arc_metric_usage(l_act_metrics_rec.arc_activity_metric_origin);
4036: FETCH c_arc_metric_usage INTO l_dummy;
4037: CLOSE c_arc_metric_usage;
4038: IF l_dummy IS NULL THEN
4039: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4040: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_ORIGIN');
4041: FND_MSG_PUB.add;
4042: END IF;
4043: x_return_status := FND_API.g_ret_sts_error;

Line 4041: FND_MSG_PUB.add;

4037: CLOSE c_arc_metric_usage;
4038: IF l_dummy IS NULL THEN
4039: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4040: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_ORIGIN');
4041: FND_MSG_PUB.add;
4042: END IF;
4043: x_return_status := FND_API.g_ret_sts_error;
4044: END IF;
4045: END IF;

Line 4197: FND_MSG_PUB.add;

4193: FND_MESSAGE.set_token('OBJECT',
4194: AMS_Utility_PVT.get_object_name(l_act_metrics_rec.arc_act_metric_used_by,
4195: l_act_metrics_rec.act_metric_used_by_id)
4196: );
4197: FND_MSG_PUB.add;
4198: -- exit the program immediately after this
4199: -- validation fails because it defines the
4200: -- entry requirement for executing any other
4201: -- logic for activity metrics; this is as if

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

4223: -- this portion calls the Complete_ActMetric_Rec
4224: -- to set trans_forecasted_value back to
4225: -- its original value
4226:
4227: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4228: l_object_name := ams_utility_pvt.get_lookup_meaning(
4229: 'AMS_SYS_ARC_QUALIFIER',
4230: l_act_metrics_rec.arc_act_metric_used_by);
4231: Fnd_Message.set_name('AMS', 'AMS_UPDATE_FORECAST');

Line 4233: Fnd_Msg_Pub.ADD;

4229: 'AMS_SYS_ARC_QUALIFIER',
4230: l_act_metrics_rec.arc_act_metric_used_by);
4231: Fnd_Message.set_name('AMS', 'AMS_UPDATE_FORECAST');
4232: Fnd_Message.set_token('OBJECT', l_object_name);
4233: Fnd_Msg_Pub.ADD;
4234: END IF; --msg_pub if
4235: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4236: END IF;
4237:

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

4256: --added profile option to restrict updation of actuals
4257: IF (l_allow_actual_update = 'N') THEN
4258: --object is not active and profile is N hence do not allow update
4259: IF (l_freeze_status = Fnd_Api.G_FALSE) THEN
4260: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4261: Fnd_Message.set_name('AMS', 'AMS_METR_UPDATE_ACTUAL');
4262: Fnd_Msg_Pub.ADD;
4263: END IF; --msg_pub if
4264:

Line 4262: Fnd_Msg_Pub.ADD;

4258: --object is not active and profile is N hence do not allow update
4259: IF (l_freeze_status = Fnd_Api.G_FALSE) THEN
4260: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4261: Fnd_Message.set_name('AMS', 'AMS_METR_UPDATE_ACTUAL');
4262: Fnd_Msg_Pub.ADD;
4263: END IF; --msg_pub if
4264:
4265: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4266: END IF; --freeze status if

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

4287: -- Profile option to restrict updation of actuals.
4288: IF (l_allow_actual_update = 'N') THEN
4289: --object is not active and profile is N hence do not allow update
4290: IF (l_freeze_status = Fnd_Api.G_FALSE) THEN
4291: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4292: Fnd_Message.set_name('AMS', 'AMS_METR_UPDATE_ACTUAL');
4293: Fnd_Msg_Pub.ADD;
4294: END IF; --msg_pub if
4295:

Line 4293: Fnd_Msg_Pub.ADD;

4289: --object is not active and profile is N hence do not allow update
4290: IF (l_freeze_status = Fnd_Api.G_FALSE) THEN
4291: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4292: Fnd_Message.set_name('AMS', 'AMS_METR_UPDATE_ACTUAL');
4293: Fnd_Msg_Pub.ADD;
4294: END IF; --msg_pub if
4295:
4296: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4297: END IF; --freeze status if

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

4325: (l_metric_details_rec.metric_calculation_type IN ('MANUAL', 'FUNCTION') AND
4326: l_metric_details_rec.arc_metric_used_for_object <> l_act_metrics_rec.arc_act_metric_used_by)
4327: THEN
4328:
4329: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
4330: THEN
4331: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_ACT_USAGE');
4332: Fnd_Msg_Pub.ADD;
4333: END IF;

Line 4332: Fnd_Msg_Pub.ADD;

4328:
4329: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
4330: THEN
4331: Fnd_Message.Set_Name('AMS', 'AMS_METR_INVALID_ACT_USAGE');
4332: Fnd_Msg_Pub.ADD;
4333: END IF;
4334:
4335: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4336: END IF; -- Check_FK_Exists

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

4341: p_object_type => l_act_metrics_rec.arc_act_metric_used_by
4342: ,p_object_id => l_act_metrics_rec.act_metric_used_by_id
4343: ) = Fnd_Api.G_FALSE
4344: THEN
4345: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
4346: l_object_name := ams_utility_pvt.get_lookup_meaning(
4347: 'AMS_SYS_ARC_QUALIFIER',l_act_metrics_rec.arc_act_metric_used_by);
4348: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_OBJECT');
4349: Fnd_Message.Set_Token('OBJTYPE',l_object_name);

Line 4351: Fnd_Msg_Pub.ADD;

4347: 'AMS_SYS_ARC_QUALIFIER',l_act_metrics_rec.arc_act_metric_used_by);
4348: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_OBJECT');
4349: Fnd_Message.Set_Token('OBJTYPE',l_object_name);
4350: Fnd_Message.Set_Token('OBJID',l_pk_value);
4351: Fnd_Msg_Pub.ADD;
4352: END IF;
4353:
4354: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4355: END IF;

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

4364:
4365: OPEN c_check_uom(l_act_metrics_rec.metric_uom_code,l_metric_details_rec.uom_type);
4366: IF c_check_uom%NOTFOUND
4367: THEN
4368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4369: THEN
4370: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_UOM');
4371: FND_MSG_PUB.ADD;
4372: END IF;

Line 4371: FND_MSG_PUB.ADD;

4367: THEN
4368: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4369: THEN
4370: FND_MESSAGE.Set_Name('AMS', 'AMS_METR_INVALID_UOM');
4371: FND_MSG_PUB.ADD;
4372: END IF;
4373:
4374: x_return_status := FND_API.G_RET_STS_ERROR;
4375: CLOSE c_check_uom;

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

4390: p_object_type => l_act_metrics_rec.arc_act_metric_used_by
4391: ,p_object_id => l_act_metrics_rec.act_metric_used_by_id
4392: ) = Fnd_Api.G_FALSE
4393: THEN
4394: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
4395: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_ORIGIN');
4396: Fnd_Msg_Pub.ADD;
4397: END IF;
4398:

Line 4396: Fnd_Msg_Pub.ADD;

4392: ) = Fnd_Api.G_FALSE
4393: THEN
4394: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
4395: Fnd_Message.Set_Name ('AMS', 'AMS_METR_INVALID_ORIGIN');
4396: Fnd_Msg_Pub.ADD;
4397: END IF;
4398:
4399: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4400: END IF;

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

4494: OPEN c_act_metric;
4495: FETCH c_act_metric INTO l_act_metric_rec;
4496: IF c_act_metric%NOTFOUND THEN
4497: CLOSE c_act_metric;
4498: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4499: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
4500: Fnd_Msg_Pub.ADD;
4501: END IF;
4502: RAISE Fnd_Api.g_exc_error;

Line 4500: Fnd_Msg_Pub.ADD;

4496: IF c_act_metric%NOTFOUND THEN
4497: CLOSE c_act_metric;
4498: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4499: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
4500: Fnd_Msg_Pub.ADD;
4501: END IF;
4502: RAISE Fnd_Api.g_exc_error;
4503: END IF;
4504: CLOSE c_act_metric;

Line 4865: Fnd_Msg_Pub.Initialize;

4861: --
4862: -- Initialize message list if p_init_msg_list is set to TRUE.
4863: --
4864: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
4865: Fnd_Msg_Pub.Initialize;
4866: END IF;
4867:
4868: --
4869: -- Standard check for API version compatibility.

Line 4923: Fnd_Msg_Pub.Count_And_Get (

4919: --
4920: -- Standard API to get message count, and if 1,
4921: -- set the message data OUT NOCOPY variable.
4922: --
4923: Fnd_Msg_Pub.Count_And_Get (
4924: p_count => x_msg_count,
4925: p_data => x_msg_data,
4926: p_encoded => Fnd_Api.G_FALSE
4927: );

Line 4941: Fnd_Msg_Pub.Count_And_Get (

4937: EXCEPTION
4938: WHEN Fnd_Api.G_EXC_ERROR THEN
4939: ROLLBACK TO SetCommittedVal_SavePoint;
4940: x_return_status := Fnd_Api.G_RET_STS_ERROR;
4941: Fnd_Msg_Pub.Count_And_Get (
4942: p_count => x_msg_count,
4943: p_data => x_msg_data,
4944: p_encoded => FND_API.G_FALSE
4945: );

Line 4949: Fnd_Msg_Pub.Count_And_Get (

4945: );
4946: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
4947: ROLLBACK TO SetCommittedVal_SavePoint;
4948: x_return_status := Fnd_Api.G_RET_STS_UNEXP_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: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

4953: );
4954: WHEN OTHERS THEN
4955: ROLLBACK TO SetCommittedVal_SavePoint;
4956: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4957: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
4958: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
4959: END IF;
4960: Fnd_Msg_Pub.Count_And_Get (
4961: p_count => x_msg_count,

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

4954: WHEN OTHERS THEN
4955: ROLLBACK TO SetCommittedVal_SavePoint;
4956: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4957: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
4958: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
4959: END IF;
4960: Fnd_Msg_Pub.Count_And_Get (
4961: p_count => x_msg_count,
4962: p_data => x_msg_data,

Line 4960: Fnd_Msg_Pub.Count_And_Get (

4956: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
4957: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
4958: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
4959: END IF;
4960: Fnd_Msg_Pub.Count_And_Get (
4961: p_count => x_msg_count,
4962: p_data => x_msg_data,
4963: p_encoded => FND_API.G_FALSE
4964: );

Line 5344: Fnd_Msg_Pub.Initialize;

5340: --
5341: -- Initialize message list if p_init_msg_list is set to TRUE.
5342: --
5343: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
5344: Fnd_Msg_Pub.Initialize;
5345: END IF;
5346:
5347: --
5348: -- Standard check for API version compatibility.

Line 5386: Fnd_Msg_Pub.Count_And_Get (

5382: --
5383: -- Standard API to get message count, and if 1,
5384: -- set the message data OUT NOCOPY variable.
5385: --
5386: Fnd_Msg_Pub.Count_And_Get (
5387: p_count => x_msg_count,
5388: p_data => x_msg_data,
5389: p_encoded => Fnd_Api.G_FALSE
5390: );

Line 5404: Fnd_Msg_Pub.Count_And_Get (

5400: EXCEPTION
5401: WHEN Fnd_Api.G_EXC_ERROR THEN
5402: ROLLBACK TO Invalidate_Rollup_pvt;
5403: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5404: Fnd_Msg_Pub.Count_And_Get (
5405: p_count => x_msg_count,
5406: p_data => x_msg_data,
5407: p_encoded => FND_API.G_FALSE
5408: );

Line 5412: Fnd_Msg_Pub.Count_And_Get (

5408: );
5409: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
5410: ROLLBACK TO Invalidate_Rollup_pvt;
5411: x_return_status := Fnd_Api.G_RET_STS_UNEXP_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: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

5416: );
5417: WHEN OTHERS THEN
5418: ROLLBACK TO Invalidate_Rollup_pvt;
5419: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5420: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5421: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
5422: END IF;
5423: Fnd_Msg_Pub.Count_And_Get (
5424: p_count => x_msg_count,

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

5417: WHEN OTHERS THEN
5418: ROLLBACK TO Invalidate_Rollup_pvt;
5419: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5420: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5421: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
5422: END IF;
5423: Fnd_Msg_Pub.Count_And_Get (
5424: p_count => x_msg_count,
5425: p_data => x_msg_data,

Line 5423: Fnd_Msg_Pub.Count_And_Get (

5419: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5420: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5421: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
5422: END IF;
5423: Fnd_Msg_Pub.Count_And_Get (
5424: p_count => x_msg_count,
5425: p_data => x_msg_data,
5426: p_encoded => FND_API.G_FALSE
5427: );

Line 5503: Fnd_Msg_Pub.Initialize;

5499: --
5500: -- Initialize message list if p_init_msg_list is set to TRUE.
5501: --
5502: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
5503: Fnd_Msg_Pub.Initialize;
5504: END IF;
5505:
5506: --
5507: -- Standard check for API version compatibility.

Line 5565: Fnd_Msg_Pub.Count_And_Get (

5561: --
5562: -- Standard API to get message count, and if 1,
5563: -- set the message data OUT NOCOPY variable.
5564: --
5565: Fnd_Msg_Pub.Count_And_Get (
5566: p_count => x_msg_count,
5567: p_data => x_msg_data,
5568: p_encoded => Fnd_Api.G_FALSE
5569: );

Line 5583: Fnd_Msg_Pub.Count_And_Get (

5579: EXCEPTION
5580: WHEN Fnd_Api.G_EXC_ERROR THEN
5581: ROLLBACK TO Post_ActMetric_pvt;
5582: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5583: Fnd_Msg_Pub.Count_And_Get (
5584: p_count => x_msg_count,
5585: p_data => x_msg_data,
5586: p_encoded => FND_API.G_FALSE
5587: );

Line 5591: Fnd_Msg_Pub.Count_And_Get (

5587: );
5588: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
5589: ROLLBACK TO Post_ActMetric_pvt;
5590: x_return_status := Fnd_Api.G_RET_STS_UNEXP_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: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

5595: );
5596: WHEN OTHERS THEN
5597: ROLLBACK TO Post_ActMetric_pvt;
5598: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5599: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5600: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
5601: END IF;
5602: Fnd_Msg_Pub.Count_And_Get (
5603: p_count => x_msg_count,

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

5596: WHEN OTHERS THEN
5597: ROLLBACK TO Post_ActMetric_pvt;
5598: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5599: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5600: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
5601: END IF;
5602: Fnd_Msg_Pub.Count_And_Get (
5603: p_count => x_msg_count,
5604: p_data => x_msg_data,

Line 5602: Fnd_Msg_Pub.Count_And_Get (

5598: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
5599: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
5600: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
5601: END IF;
5602: Fnd_Msg_Pub.Count_And_Get (
5603: p_count => x_msg_count,
5604: p_data => x_msg_data,
5605: p_encoded => FND_API.G_FALSE
5606: );

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

5773: END IF;
5774:
5775: EXCEPTION
5776: WHEN Gl_Currency_Api.NO_RATE THEN
5777: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5778: Fnd_Message.Set_Name ('AMS', 'AMS_NO_RATE');
5779: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5780: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5781: Fnd_Msg_Pub.ADD;

Line 5781: Fnd_Msg_Pub.ADD;

5777: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5778: Fnd_Message.Set_Name ('AMS', 'AMS_NO_RATE');
5779: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5780: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5781: Fnd_Msg_Pub.ADD;
5782: END IF;
5783: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5784: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5785: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

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

5781: Fnd_Msg_Pub.ADD;
5782: END IF;
5783: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5784: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5785: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5786: Fnd_Message.Set_Name ('AMS', 'AMS_INVALID_CURR');
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_INVALID_CURR');
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: END Convert_Currency2;
5793:

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

5865: END LOOP;
5866:
5867: EXCEPTION
5868: WHEN Gl_Currency_Api.NO_RATE THEN
5869: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5870: Fnd_Message.Set_Name ('AMS', 'AMS_NO_RATE');
5871: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5872: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5873: Fnd_Msg_Pub.ADD;

Line 5873: Fnd_Msg_Pub.ADD;

5869: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5870: Fnd_Message.Set_Name ('AMS', 'AMS_NO_RATE');
5871: Fnd_Message.Set_Token ('CURRENCY_FROM', p_from_currency);
5872: Fnd_Message.Set_Token ('CURRENCY_TO', p_to_currency);
5873: Fnd_Msg_Pub.ADD;
5874: END IF;
5875: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5876: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5877: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN

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

5873: Fnd_Msg_Pub.ADD;
5874: END IF;
5875: x_return_status := Fnd_Api.G_RET_STS_ERROR;
5876: WHEN Gl_Currency_Api.INVALID_CURRENCY THEN
5877: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
5878: Fnd_Message.Set_Name ('AMS', 'AMS_INVALID_CURR');
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_INVALID_CURR');
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: END Convert_Currency_Vector;
5885:

Line 6467: Fnd_Msg_Pub.Count_And_Get (

6463:
6464: EXCEPTION
6465: WHEN Fnd_Api.G_EXC_ERROR THEN
6466: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6467: Fnd_Msg_Pub.Count_And_Get (
6468: p_count => x_msg_count,
6469: p_data => x_msg_data,
6470: p_encoded => FND_API.G_FALSE
6471: );

Line 6474: Fnd_Msg_Pub.Count_And_Get (

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

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

6478: );
6479: WHEN OTHERS THEN
6480: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6481: error_message := SQLERRM;
6482: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6483: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
6484: END IF;
6485: Fnd_Msg_Pub.Count_And_Get (
6486: p_count => x_msg_count,

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

6479: WHEN OTHERS THEN
6480: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6481: error_message := SQLERRM;
6482: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6483: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
6484: END IF;
6485: Fnd_Msg_Pub.Count_And_Get (
6486: p_count => x_msg_count,
6487: p_data => x_msg_data,

Line 6485: Fnd_Msg_Pub.Count_And_Get (

6481: error_message := SQLERRM;
6482: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6483: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
6484: END IF;
6485: Fnd_Msg_Pub.Count_And_Get (
6486: p_count => x_msg_count,
6487: p_data => x_msg_data,
6488: p_encoded => FND_API.G_FALSE
6489: );

Line 6699: Fnd_Msg_Pub.Initialize;

6695: --
6696: -- Initialize message list if p_init_msg_list is set to TRUE.
6697: --
6698: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
6699: Fnd_Msg_Pub.Initialize;
6700: END IF;
6701:
6702: --
6703: -- Standard check for API version compatibility.

Line 6891: Fnd_Msg_Pub.Count_And_Get (

6887: --
6888: -- Standard API to get message count, and if 1,
6889: -- set the message data OUT NOCOPY variable.
6890: --
6891: Fnd_Msg_Pub.Count_And_Get (
6892: p_count => x_msg_count,
6893: p_data => x_msg_data,
6894: p_encoded => Fnd_Api.G_FALSE
6895: );

Line 6907: Fnd_Msg_Pub.Count_And_Get (

6903:
6904: EXCEPTION
6905: WHEN Fnd_Api.G_EXC_ERROR THEN
6906: x_return_status := Fnd_Api.G_RET_STS_ERROR;
6907: Fnd_Msg_Pub.Count_And_Get (
6908: p_count => x_msg_count,
6909: p_data => x_msg_data,
6910: p_encoded => FND_API.G_FALSE
6911: );

Line 6914: Fnd_Msg_Pub.Count_And_Get (

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

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

6917: p_encoded => FND_API.G_FALSE
6918: );
6919: WHEN OTHERS THEN
6920: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6921: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6922: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
6923: END IF;
6924: Fnd_Msg_Pub.Count_And_Get (
6925: p_count => x_msg_count,

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

6918: );
6919: WHEN OTHERS THEN
6920: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6921: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6922: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
6923: END IF;
6924: Fnd_Msg_Pub.Count_And_Get (
6925: p_count => x_msg_count,
6926: p_data => x_msg_data,

Line 6924: Fnd_Msg_Pub.Count_And_Get (

6920: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
6921: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
6922: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
6923: END IF;
6924: Fnd_Msg_Pub.Count_And_Get (
6925: p_count => x_msg_count,
6926: p_data => x_msg_data,
6927: p_encoded => FND_API.G_FALSE
6928: );

Line 7084: FND_MSG_PUB.Initialize;

7080: END IF;
7081:
7082: -- Initialize message list if p_init_msg_list is set to TRUE.
7083: IF FND_API.To_Boolean (p_init_msg_list) THEN
7084: FND_MSG_PUB.Initialize;
7085: END IF;
7086:
7087: -- Standard check for API version compatibility.
7088: IF NOT FND_API.Compatible_API_Call (L_API_VERSION,

Line 7195: Fnd_Msg_Pub.Count_And_Get (

7191: IF FND_API.To_Boolean (p_commit) THEN
7192: COMMIT;
7193: END IF;
7194:
7195: Fnd_Msg_Pub.Count_And_Get (
7196: p_count => x_msg_count,
7197: p_data => x_msg_data,
7198: p_encoded => Fnd_Api.G_FALSE
7199: );

Line 7212: FND_MSG_PUB.Count_And_Get (

7208: EXCEPTION
7209: WHEN FND_API.G_EXC_ERROR THEN
7210: ROLLBACK TO Copy_Metric_pvt;
7211: x_return_status := FND_API.G_RET_STS_ERROR;
7212: FND_MSG_PUB.Count_And_Get (
7213: p_encoded => FND_API.g_false,
7214: p_count => x_msg_count,
7215: p_data => x_msg_data
7216: );

Line 7221: FND_MSG_PUB.Count_And_Get (

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

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

7226:
7227: WHEN OTHERS THEN
7228: ROLLBACK TO Copy_Metric_pvt;
7229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7231: THEN
7232: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
7233: END IF;
7234:

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

7228: ROLLBACK TO Copy_Metric_pvt;
7229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7230: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7231: THEN
7232: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
7233: END IF;
7234:
7235: FND_MSG_PUB.Count_And_Get (
7236: p_encoded => FND_API.g_false,

Line 7235: FND_MSG_PUB.Count_And_Get (

7231: THEN
7232: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
7233: END IF;
7234:
7235: FND_MSG_PUB.Count_And_Get (
7236: p_encoded => FND_API.g_false,
7237: p_count => x_msg_count,
7238: p_data => x_msg_data
7239: );

Line 7316: Fnd_Msg_Pub.Initialize;

7312: END IF;
7313:
7314: -- Initialize message list if p_init_msg_list is set to TRUE.
7315: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
7316: Fnd_Msg_Pub.Initialize;
7317: END IF;
7318:
7319: -- Standard check for API version compatibility.
7320: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,

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

7369: l_object_name := ams_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER', l_source_object_type);
7370:
7371: --the object type passed is not a valid one for metrics.
7372: IF (l_valid_object = Fnd_Api.G_FALSE) THEN
7373: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7374: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_OBJECTS');
7375: Fnd_Msg_Pub.ADD;
7376: END IF;
7377: l_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 7375: Fnd_Msg_Pub.ADD;

7371: --the object type passed is not a valid one for metrics.
7372: IF (l_valid_object = Fnd_Api.G_FALSE) THEN
7373: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7374: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_OBJECTS');
7375: Fnd_Msg_Pub.ADD;
7376: END IF;
7377: l_return_status := Fnd_Api.G_RET_STS_ERROR;
7378:
7379: END IF;

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

7379: END IF;
7380:
7381: --check if source object was not found
7382: IF (l_source_object_exists = Fnd_Api.G_FALSE) THEN
7383: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7384: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_SOURCE');
7385: Fnd_Message.set_token('OBJECT', l_object_name);
7386: Fnd_Msg_Pub.ADD;
7387: END IF;

Line 7386: Fnd_Msg_Pub.ADD;

7382: IF (l_source_object_exists = Fnd_Api.G_FALSE) THEN
7383: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7384: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_SOURCE');
7385: Fnd_Message.set_token('OBJECT', l_object_name);
7386: Fnd_Msg_Pub.ADD;
7387: END IF;
7388: l_return_status := Fnd_Api.G_RET_STS_ERROR;
7389: END IF;
7390:

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

7417: END IF;
7418:
7419: --check if target object was not found
7420: IF (l_target_object_exists = Fnd_Api.G_FALSE) THEN
7421: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7422: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_TARGET');
7423: Fnd_Message.set_token('OBJECT', l_object_name);
7424: Fnd_Msg_Pub.ADD;
7425: END IF;

Line 7424: Fnd_Msg_Pub.ADD;

7420: IF (l_target_object_exists = Fnd_Api.G_FALSE) THEN
7421: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR) THEN
7422: Fnd_Message.Set_Name('AMS', 'AMS_COPY_INVALID_TARGET');
7423: Fnd_Message.set_token('OBJECT', l_object_name);
7424: Fnd_Msg_Pub.ADD;
7425: END IF;
7426: l_return_status := Fnd_Api.G_RET_STS_ERROR;
7427:
7428: END IF;

Line 7434: FND_MSG_PUB.Count_And_Get (

7430: -- End API Body.
7431:
7432: -- Standard API to get message count, and if 1,
7433: -- set the message data OUT variable.
7434: FND_MSG_PUB.Count_And_Get (
7435: p_count => x_msg_count,
7436: p_data => x_msg_data,
7437: p_encoded => FND_API.G_FALSE
7438: );

Line 7484: Fnd_Msg_Pub.Initialize;

7480: --
7481: -- Initialize message list if p_init_msg_list is set to TRUE.
7482: --
7483: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
7484: Fnd_Msg_Pub.Initialize;
7485: END IF;
7486:
7487: --
7488: -- Standard check for API version compatibility.

Line 7603: Fnd_Msg_Pub.Initialize;

7599: --
7600: -- Initialize message list if p_init_msg_list is set to TRUE.
7601: --
7602: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
7603: Fnd_Msg_Pub.Initialize;
7604: END IF;
7605:
7606: --
7607: -- Standard check for API version compatibility.

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

7629: EXCEPTION
7630: WHEN OTHERS THEN
7631: ROLLBACK TO delete_actmetrics_assoc;
7632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7633: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7634: THEN
7635: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
7636: END IF;
7637:

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

7631: ROLLBACK TO delete_actmetrics_assoc;
7632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7633: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7634: THEN
7635: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
7636: END IF;
7637:
7638: FND_MSG_PUB.Count_And_Get (
7639: p_encoded => FND_API.g_false,

Line 7638: FND_MSG_PUB.Count_And_Get (

7634: THEN
7635: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
7636: END IF;
7637:
7638: FND_MSG_PUB.Count_And_Get (
7639: p_encoded => FND_API.g_false,
7640: p_count => x_msg_count,
7641: p_data => x_msg_data
7642: );