DBA Data[Home] [Help]

APPS.AMS_DMPERFORMANCE_PVT dependencies on FND_MSG_PUB

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

26: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
27: ***/
28:
29: -- Hint: Primary key needs to be returned.
30: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
31: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
32: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
33:
34: PROCEDURE Create_Performance(

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

27: ***/
28:
29: -- Hint: Primary key needs to be returned.
30: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
31: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
32: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
33:
34: PROCEDURE Create_Performance(
35: p_api_version_number IN NUMBER,

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

28:
29: -- Hint: Primary key needs to be returned.
30: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
31: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
32: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
33:
34: PROCEDURE Create_Performance(
35: p_api_version_number IN NUMBER,
36: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 81: FND_MSG_PUB.initialize;

77:
78: -- Initialize message list if p_init_msg_list is set to TRUE.
79: IF FND_API.to_Boolean( p_init_msg_list )
80: THEN
81: FND_MSG_PUB.initialize;
82: END IF;
83:
84: -- Debug Message
85: IF (AMS_DEBUG_HIGH_ON) THEN

Line 182: FND_MSG_PUB.Count_And_Get

178: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
179: END IF;
180:
181: -- Standard call to get message count and if count is 1, get message info.
182: FND_MSG_PUB.Count_And_Get
183: (p_count => x_msg_count,
184: p_data => x_msg_data
185: );
186: EXCEPTION

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

186: EXCEPTION
187:
188: WHEN AMS_Utility_PVT.resource_locked THEN
189: x_return_status := FND_API.g_ret_sts_error;
190: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
191: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
192: FND_MSG_PUB.add;
193: END IF;
194:

Line 192: FND_MSG_PUB.add;

188: WHEN AMS_Utility_PVT.resource_locked THEN
189: x_return_status := FND_API.g_ret_sts_error;
190: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
191: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
192: FND_MSG_PUB.add;
193: END IF;
194:
195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO Create_Performance_PVT;

Line 199: FND_MSG_PUB.Count_And_Get (

195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO Create_Performance_PVT;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: -- Standard call to get message count and if count=1, get the message
199: FND_MSG_PUB.Count_And_Get (
200: p_encoded => FND_API.G_FALSE,
201: p_count => x_msg_count,
202: p_data => x_msg_data
203: );

Line 209: FND_MSG_PUB.Count_And_Get (

205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
206: ROLLBACK TO Create_Performance_PVT;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: -- Standard call to get message count and if count=1, get the message
209: FND_MSG_PUB.Count_And_Get (
210: p_encoded => FND_API.G_FALSE,
211: p_count => x_msg_count,
212: p_data => x_msg_data
213: );

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

214:
215: WHEN OTHERS THEN
216: ROLLBACK TO Create_Performance_PVT;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
219: THEN
220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
221: END IF;
222: -- Standard call to get message count and if count=1, get the message

Line 220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

216: ROLLBACK TO Create_Performance_PVT;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
219: THEN
220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
221: END IF;
222: -- Standard call to get message count and if count=1, get the message
223: FND_MSG_PUB.Count_And_Get (
224: p_encoded => FND_API.G_FALSE,

Line 223: FND_MSG_PUB.Count_And_Get (

219: THEN
220: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
221: END IF;
222: -- Standard call to get message count and if count=1, get the message
223: FND_MSG_PUB.Count_And_Get (
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,
226: p_data => x_msg_data
227: );

Line 274: FND_MSG_PUB.initialize;

270:
271: -- Initialize message list if p_init_msg_list is set to TRUE.
272: IF FND_API.to_Boolean( p_init_msg_list )
273: THEN
274: FND_MSG_PUB.initialize;
275: END IF;
276:
277: -- Debug Message
278: IF (AMS_DEBUG_HIGH_ON) THEN

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

294:
295: FETCH c_get_Dmperformance INTO l_ref_performance_rec ;
296:
297: If ( c_get_Dmperformance%NOTFOUND) THEN
298: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
299: THEN
300: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
301: FND_MESSAGE.Set_Token ('INFO', 'Dmperformance', FALSE);
302: FND_MSG_PUB.Add;

Line 302: FND_MSG_PUB.Add;

298: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
299: THEN
300: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
301: FND_MESSAGE.Set_Token ('INFO', 'Dmperformance', FALSE);
302: FND_MSG_PUB.Add;
303: END IF;
304: RAISE FND_API.G_EXC_ERROR;
305: END IF;
306: -- Debug Message

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

311: CLOSE c_get_Dmperformance;
312:
313: -- Check Whether record has been changed by someone else
314: If (l_tar_performance_rec.object_version_number <> l_ref_performance_rec.object_version_number) Then
315: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
316: THEN
317: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
318: FND_MESSAGE.Set_Token('INFO', 'Dmperformance', FALSE);
319: FND_MSG_PUB.ADD;

Line 319: FND_MSG_PUB.ADD;

315: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
316: THEN
317: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
318: FND_MESSAGE.Set_Token('INFO', 'Dmperformance', FALSE);
319: FND_MSG_PUB.ADD;
320: END IF;
321: raise FND_API.G_EXC_ERROR;
322: End if;
323: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 351: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

347:
348: -- Debug Message
349: IF (AMS_DEBUG_HIGH_ON) THEN
350:
351: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
352: END IF;
353:
354: -- Invoke table handler(AMS_DM_PERFORMANCE_PKG.Update_Row)
355: AMS_DM_PERFORMANCE_PKG.Update_Row(

Line 388: FND_MSG_PUB.Count_And_Get

384: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
385: END IF;
386:
387: -- Standard call to get message count and if count is 1, get message info.
388: FND_MSG_PUB.Count_And_Get
389: (p_count => x_msg_count,
390: p_data => x_msg_data
391: );
392: EXCEPTION

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

392: EXCEPTION
393:
394: WHEN AMS_Utility_PVT.resource_locked THEN
395: x_return_status := FND_API.g_ret_sts_error;
396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
397: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
398: FND_MSG_PUB.add;
399: END IF;
400:

Line 398: FND_MSG_PUB.add;

394: WHEN AMS_Utility_PVT.resource_locked THEN
395: x_return_status := FND_API.g_ret_sts_error;
396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
397: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
398: FND_MSG_PUB.add;
399: END IF;
400:
401: WHEN FND_API.G_EXC_ERROR THEN
402: ROLLBACK TO Update_Performance_PVT;

Line 405: FND_MSG_PUB.Count_And_Get (

401: WHEN FND_API.G_EXC_ERROR THEN
402: ROLLBACK TO Update_Performance_PVT;
403: x_return_status := FND_API.G_RET_STS_ERROR;
404: -- Standard call to get message count and if count=1, get the message
405: FND_MSG_PUB.Count_And_Get (
406: p_encoded => FND_API.G_FALSE,
407: p_count => x_msg_count,
408: p_data => x_msg_data
409: );

Line 415: FND_MSG_PUB.Count_And_Get (

411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
412: ROLLBACK TO Update_Performance_PVT;
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: -- Standard call to get message count and if count=1, get the message
415: FND_MSG_PUB.Count_And_Get (
416: p_encoded => FND_API.G_FALSE,
417: p_count => x_msg_count,
418: p_data => x_msg_data
419: );

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

420:
421: WHEN OTHERS THEN
422: ROLLBACK TO Update_Performance_PVT;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
427: END IF;
428: -- Standard call to get message count and if count=1, get the message

Line 426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

422: ROLLBACK TO Update_Performance_PVT;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
424: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
425: THEN
426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
427: END IF;
428: -- Standard call to get message count and if count=1, get the message
429: FND_MSG_PUB.Count_And_Get (
430: p_encoded => FND_API.G_FALSE,

Line 429: FND_MSG_PUB.Count_And_Get (

425: THEN
426: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
427: END IF;
428: -- Standard call to get message count and if count=1, get the message
429: FND_MSG_PUB.Count_And_Get (
430: p_encoded => FND_API.G_FALSE,
431: p_count => x_msg_count,
432: p_data => x_msg_data
433: );

Line 470: FND_MSG_PUB.initialize;

466:
467: -- Initialize message list if p_init_msg_list is set to TRUE.
468: IF FND_API.to_Boolean( p_init_msg_list )
469: THEN
470: FND_MSG_PUB.initialize;
471: END IF;
472:
473: -- Debug Message
474: IF (AMS_DEBUG_HIGH_ON) THEN

Line 513: FND_MSG_PUB.Count_And_Get

509: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
510: END IF;
511:
512: -- Standard call to get message count and if count is 1, get message info.
513: FND_MSG_PUB.Count_And_Get
514: (p_count => x_msg_count,
515: p_data => x_msg_data
516: );
517: EXCEPTION

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

517: EXCEPTION
518:
519: WHEN AMS_Utility_PVT.resource_locked THEN
520: x_return_status := FND_API.g_ret_sts_error;
521: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
522: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
523: FND_MSG_PUB.add;
524: END IF;
525:

Line 523: FND_MSG_PUB.add;

519: WHEN AMS_Utility_PVT.resource_locked THEN
520: x_return_status := FND_API.g_ret_sts_error;
521: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
522: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
523: FND_MSG_PUB.add;
524: END IF;
525:
526: WHEN FND_API.G_EXC_ERROR THEN
527: ROLLBACK TO Delete_Performance_PVT;

Line 530: FND_MSG_PUB.Count_And_Get (

526: WHEN FND_API.G_EXC_ERROR THEN
527: ROLLBACK TO Delete_Performance_PVT;
528: x_return_status := FND_API.G_RET_STS_ERROR;
529: -- Standard call to get message count and if count=1, get the message
530: FND_MSG_PUB.Count_And_Get (
531: p_encoded => FND_API.G_FALSE,
532: p_count => x_msg_count,
533: p_data => x_msg_data
534: );

Line 540: FND_MSG_PUB.Count_And_Get (

536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: ROLLBACK TO Delete_Performance_PVT;
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: -- Standard call to get message count and if count=1, get the message
540: FND_MSG_PUB.Count_And_Get (
541: p_encoded => FND_API.G_FALSE,
542: p_count => x_msg_count,
543: p_data => x_msg_data
544: );

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

545:
546: WHEN OTHERS THEN
547: ROLLBACK TO Delete_Performance_PVT;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
550: THEN
551: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
552: END IF;
553: -- Standard call to get message count and if count=1, get the message

Line 551: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

547: ROLLBACK TO Delete_Performance_PVT;
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
550: THEN
551: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
552: END IF;
553: -- Standard call to get message count and if count=1, get the message
554: FND_MSG_PUB.Count_And_Get (
555: p_encoded => FND_API.G_FALSE,

Line 554: FND_MSG_PUB.Count_And_Get (

550: THEN
551: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
552: END IF;
553: -- Standard call to get message count and if count=1, get the message
554: FND_MSG_PUB.Count_And_Get (
555: p_encoded => FND_API.G_FALSE,
556: p_count => x_msg_count,
557: p_data => x_msg_data
558: );

Line 600: FND_MSG_PUB.initialize;

596:
597: -- Initialize message list if p_init_msg_list is set to TRUE.
598: IF FND_API.to_Boolean( p_init_msg_list )
599: THEN
600: FND_MSG_PUB.initialize;
601: END IF;
602:
603: -- Standard call to check for call compatibility.
604: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

628: FETCH c_Dmperformance INTO l_PERFORMANCE_ID;
629:
630: IF (c_Dmperformance%NOTFOUND) THEN
631: CLOSE c_Dmperformance;
632: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
633: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
634: FND_MSG_PUB.add;
635: END IF;
636: RAISE FND_API.g_exc_error;

Line 634: FND_MSG_PUB.add;

630: IF (c_Dmperformance%NOTFOUND) THEN
631: CLOSE c_Dmperformance;
632: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
633: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
634: FND_MSG_PUB.add;
635: END IF;
636: RAISE FND_API.g_exc_error;
637: END IF;
638:

Line 642: FND_MSG_PUB.count_and_get(

638:
639: CLOSE c_Dmperformance;
640:
641: -------------------- finish --------------------------
642: FND_MSG_PUB.count_and_get(
643: p_encoded => FND_API.g_false,
644: p_count => x_msg_count,
645: p_data => x_msg_data);
646: IF (AMS_DEBUG_HIGH_ON) THEN

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

650: EXCEPTION
651:
652: WHEN AMS_Utility_PVT.resource_locked THEN
653: x_return_status := FND_API.g_ret_sts_error;
654: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
655: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
656: FND_MSG_PUB.add;
657: END IF;
658:

Line 656: FND_MSG_PUB.add;

652: WHEN AMS_Utility_PVT.resource_locked THEN
653: x_return_status := FND_API.g_ret_sts_error;
654: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
655: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
656: FND_MSG_PUB.add;
657: END IF;
658:
659: WHEN FND_API.G_EXC_ERROR THEN
660: ROLLBACK TO Lock_Performance_PVT;

Line 663: FND_MSG_PUB.Count_And_Get (

659: WHEN FND_API.G_EXC_ERROR THEN
660: ROLLBACK TO Lock_Performance_PVT;
661: x_return_status := FND_API.G_RET_STS_ERROR;
662: -- Standard call to get message count and if count=1, get the message
663: FND_MSG_PUB.Count_And_Get (
664: p_encoded => FND_API.G_FALSE,
665: p_count => x_msg_count,
666: p_data => x_msg_data
667: );

Line 673: FND_MSG_PUB.Count_And_Get (

669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
670: ROLLBACK TO Lock_Performance_PVT;
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
672: -- Standard call to get message count and if count=1, get the message
673: FND_MSG_PUB.Count_And_Get (
674: p_encoded => FND_API.G_FALSE,
675: p_count => x_msg_count,
676: p_data => x_msg_data
677: );

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

678:
679: WHEN OTHERS THEN
680: ROLLBACK TO Lock_Performance_PVT;
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
683: THEN
684: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
685: END IF;
686: -- Standard call to get message count and if count=1, get the message

Line 684: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

680: ROLLBACK TO Lock_Performance_PVT;
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
683: THEN
684: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
685: END IF;
686: -- Standard call to get message count and if count=1, get the message
687: FND_MSG_PUB.Count_And_Get (
688: p_encoded => FND_API.G_FALSE,

Line 687: FND_MSG_PUB.Count_And_Get (

683: THEN
684: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
685: END IF;
686: -- Standard call to get message count and if count=1, get the message
687: FND_MSG_PUB.Count_And_Get (
688: p_encoded => FND_API.G_FALSE,
689: p_count => x_msg_count,
690: p_data => x_msg_data
691: );

Line 718: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

714: );
715: END IF;
716:
717: IF l_valid_flag = FND_API.g_false THEN
718: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
719: THEN
720: FND_MESSAGE.set_name('AMS', 'AMS_PERFORMANCE_ID_DUPLICATE');
721: FND_MSG_PUB.add;
722: END IF;

Line 721: FND_MSG_PUB.add;

717: IF l_valid_flag = FND_API.g_false THEN
718: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
719: THEN
720: FND_MESSAGE.set_name('AMS', 'AMS_PERFORMANCE_ID_DUPLICATE');
721: FND_MSG_PUB.add;
722: END IF;
723: x_return_status := FND_API.g_ret_sts_error;
724: RETURN;
725: END IF;

Line 929: FND_MSG_PUB.initialize;

925:
926: -- Initialize message list if p_init_msg_list is set to TRUE.
927: IF FND_API.to_Boolean( p_init_msg_list )
928: THEN
929: FND_MSG_PUB.initialize;
930: END IF;
931: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
932: Check_performance_Items(
933: p_performance_rec => p_performance_rec,

Line 985: FND_MSG_PUB.Count_And_Get

981: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
982: END IF;
983:
984: -- Standard call to get message count and if count is 1, get message info.
985: FND_MSG_PUB.Count_And_Get
986: (p_count => x_msg_count,
987: p_data => x_msg_data
988: );
989: EXCEPTION

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

989: EXCEPTION
990:
991: WHEN AMS_Utility_PVT.resource_locked THEN
992: x_return_status := FND_API.g_ret_sts_error;
993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
994: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
995: FND_MSG_PUB.add;
996: END IF;
997:

Line 995: FND_MSG_PUB.add;

991: WHEN AMS_Utility_PVT.resource_locked THEN
992: x_return_status := FND_API.g_ret_sts_error;
993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
994: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
995: FND_MSG_PUB.add;
996: END IF;
997:
998: WHEN FND_API.G_EXC_ERROR THEN
999: ROLLBACK TO Validate_Performance_;

Line 1002: FND_MSG_PUB.Count_And_Get (

998: WHEN FND_API.G_EXC_ERROR THEN
999: ROLLBACK TO Validate_Performance_;
1000: x_return_status := FND_API.G_RET_STS_ERROR;
1001: -- Standard call to get message count and if count=1, get the message
1002: FND_MSG_PUB.Count_And_Get (
1003: p_encoded => FND_API.G_FALSE,
1004: p_count => x_msg_count,
1005: p_data => x_msg_data
1006: );

Line 1012: FND_MSG_PUB.Count_And_Get (

1008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1009: ROLLBACK TO Validate_Performance_;
1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1011: -- Standard call to get message count and if count=1, get the message
1012: FND_MSG_PUB.Count_And_Get (
1013: p_encoded => FND_API.G_FALSE,
1014: p_count => x_msg_count,
1015: p_data => x_msg_data
1016: );

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

1017:
1018: WHEN OTHERS THEN
1019: ROLLBACK TO Validate_Performance_;
1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1021: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1022: THEN
1023: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1024: END IF;
1025: -- Standard call to get message count and if count=1, get the message

Line 1023: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1019: ROLLBACK TO Validate_Performance_;
1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1021: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1022: THEN
1023: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1024: END IF;
1025: -- Standard call to get message count and if count=1, get the message
1026: FND_MSG_PUB.Count_And_Get (
1027: p_encoded => FND_API.G_FALSE,

Line 1026: FND_MSG_PUB.Count_And_Get (

1022: THEN
1023: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1024: END IF;
1025: -- Standard call to get message count and if count=1, get the message
1026: FND_MSG_PUB.Count_And_Get (
1027: p_encoded => FND_API.G_FALSE,
1028: p_count => x_msg_count,
1029: p_data => x_msg_data
1030: );

Line 1047: FND_MSG_PUB.initialize;

1043: BEGIN
1044: -- Initialize message list if p_init_msg_list is set to TRUE.
1045: IF FND_API.to_Boolean( p_init_msg_list )
1046: THEN
1047: FND_MSG_PUB.initialize;
1048: END IF;
1049:
1050: -- Initialize API return status to SUCCESS
1051: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1064: FND_MSG_PUB.Count_And_Get

1060:
1061: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1062: END IF;
1063: -- Standard call to get message count and if count is 1, get message info.
1064: FND_MSG_PUB.Count_And_Get
1065: (p_count => x_msg_count,
1066: p_data => x_msg_data
1067: );
1068: END Validate_performance_Rec;