DBA Data[Home] [Help]

APPS.AMS_METRIC_TEMPLATE_PVT dependencies on FND_MSG_PUB

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

21:
22: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Metric_Template_PVT';
23: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvmthb.pls';
24:
25: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
26: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
27: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
28:
29: PROCEDURE Complete_metric_tpl_header_Rec (

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

22: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Metric_Template_PVT';
23: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvmthb.pls';
24:
25: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
26: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
27: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
28:
29: PROCEDURE Complete_metric_tpl_header_Rec (
30: p_ref_metric_tpl_header_rec IN metric_tpl_header_rec_type,

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

23: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvmthb.pls';
24:
25: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
26: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
27: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
28:
29: PROCEDURE Complete_metric_tpl_header_Rec (
30: p_ref_metric_tpl_header_rec IN metric_tpl_header_rec_type,
31: x_tar_metric_tpl_header_rec IN OUT NOCOPY metric_tpl_header_rec_type);

Line 82: FND_MSG_PUB.initialize;

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

Line 197: FND_MSG_PUB.Count_And_Get

193: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
194: END IF;
195:
196: -- Standard call to get message count and if count is 1, get message info.
197: FND_MSG_PUB.Count_And_Get
198: (p_count => x_msg_count,
199: p_data => x_msg_data
200: );
201: EXCEPTION

Line 211: FND_MSG_PUB.Count_And_Get (

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

Line 221: FND_MSG_PUB.Count_And_Get (

217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: ROLLBACK TO CREATE_Metric_Template_PVT;
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: -- Standard call to get message count and if count=1, get the message
221: FND_MSG_PUB.Count_And_Get (
222: p_encoded => FND_API.G_FALSE,
223: p_count => x_msg_count,
224: p_data => x_msg_data
225: );

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

226:
227: WHEN OTHERS THEN
228: ROLLBACK TO CREATE_Metric_Template_PVT;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
231: THEN
232: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
233: END IF;
234: -- Standard call to get message count and if count=1, get the message

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

228: ROLLBACK TO CREATE_Metric_Template_PVT;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
231: THEN
232: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
233: END IF;
234: -- Standard call to get message count and if count=1, get the message
235: FND_MSG_PUB.Count_And_Get (
236: p_encoded => FND_API.G_FALSE,

Line 235: FND_MSG_PUB.Count_And_Get (

231: THEN
232: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
233: END IF;
234: -- Standard call to get message count and if count=1, get the message
235: FND_MSG_PUB.Count_And_Get (
236: p_encoded => FND_API.G_FALSE,
237: p_count => x_msg_count,
238: p_data => x_msg_data
239: );

Line 303: FND_MSG_PUB.initialize;

299:
300: -- Initialize message list if p_init_msg_list is set to TRUE.
301: IF FND_API.to_Boolean( p_init_msg_list )
302: THEN
303: FND_MSG_PUB.initialize;
304: END IF;
305:
306: -- Debug Message
307: IF (AMS_DEBUG_HIGH_ON) THEN

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

370: OR (l_tar_metric_tpl_header_rec.description <>
371: l_ref_metric_tpl_header_rec.description ))
372: AND (l_tar_metric_tpl_header_rec.enabled_flag =
373: l_ref_metric_tpl_header_rec.enabled_flag)) THEN
374: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
375: THEN
376: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED_MOD');
377: END IF;
378:

Line 454: FND_MSG_PUB.Count_And_Get

450: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': END');
451: END IF;
452:
453: -- Standard call to get message count and if count is 1, get message info.
454: FND_MSG_PUB.Count_And_Get
455: (p_count => x_msg_count,
456: p_data => x_msg_data
457: );
458: EXCEPTION

Line 468: FND_MSG_PUB.Count_And_Get (

464: WHEN FND_API.G_EXC_ERROR THEN
465: ROLLBACK TO UPDATE_Metric_Template_PVT;
466: x_return_status := FND_API.G_RET_STS_ERROR;
467: -- Standard call to get message count and if count=1, get the message
468: FND_MSG_PUB.Count_And_Get (
469: p_encoded => FND_API.G_FALSE,
470: p_count => x_msg_count,
471: p_data => x_msg_data
472: );

Line 478: FND_MSG_PUB.Count_And_Get (

474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
475: ROLLBACK TO UPDATE_Metric_Template_PVT;
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: -- Standard call to get message count and if count=1, get the message
478: FND_MSG_PUB.Count_And_Get (
479: p_encoded => FND_API.G_FALSE,
480: p_count => x_msg_count,
481: p_data => x_msg_data
482: );

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

483:
484: WHEN OTHERS THEN
485: ROLLBACK TO UPDATE_Metric_Template_PVT;
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
487: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
488: THEN
489: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
490: END IF;
491: -- Standard call to get message count and if count=1, get the message

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

485: ROLLBACK TO UPDATE_Metric_Template_PVT;
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
487: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
488: THEN
489: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
490: END IF;
491: -- Standard call to get message count and if count=1, get the message
492: FND_MSG_PUB.Count_And_Get (
493: p_encoded => FND_API.G_FALSE,

Line 492: FND_MSG_PUB.Count_And_Get (

488: THEN
489: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
490: END IF;
491: -- Standard call to get message count and if count=1, get the message
492: FND_MSG_PUB.Count_And_Get (
493: p_encoded => FND_API.G_FALSE,
494: p_count => x_msg_count,
495: p_data => x_msg_data
496: );

Line 532: FND_MSG_PUB.initialize;

528:
529: -- Initialize message list if p_init_msg_list is set to TRUE.
530: IF FND_API.to_Boolean( p_init_msg_list )
531: THEN
532: FND_MSG_PUB.initialize;
533: END IF;
534:
535: -- Debug Message
536: IF (AMS_DEBUG_HIGH_ON) THEN

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

540:
541:
542: --11/26/02 sunil : check if the template is a seeded one
543: IF p_metric_tpl_header_id < 10000 THEN
544: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
545: THEN
546: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED');
547: END IF;
548:

Line 613: FND_MSG_PUB.Count_And_Get

609: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'END');
610: END IF;
611:
612: -- Standard call to get message count and if count is 1, get message info.
613: FND_MSG_PUB.Count_And_Get
614: (p_count => x_msg_count,
615: p_data => x_msg_data
616: );
617: EXCEPTION

Line 627: FND_MSG_PUB.Count_And_Get (

623: WHEN FND_API.G_EXC_ERROR THEN
624: ROLLBACK TO DELETE_Metric_Template_PVT;
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: -- Standard call to get message count and if count=1, get the message
627: FND_MSG_PUB.Count_And_Get (
628: p_encoded => FND_API.G_FALSE,
629: p_count => x_msg_count,
630: p_data => x_msg_data
631: );

Line 637: FND_MSG_PUB.Count_And_Get (

633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: ROLLBACK TO DELETE_Metric_Template_PVT;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: -- Standard call to get message count and if count=1, get the message
637: FND_MSG_PUB.Count_And_Get (
638: p_encoded => FND_API.G_FALSE,
639: p_count => x_msg_count,
640: p_data => x_msg_data
641: );

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

642:
643: WHEN OTHERS THEN
644: ROLLBACK TO DELETE_Metric_Template_PVT;
645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
646: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
647: THEN
648: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
649: END IF;
650: -- Standard call to get message count and if count=1, get the message

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

644: ROLLBACK TO DELETE_Metric_Template_PVT;
645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
646: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
647: THEN
648: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
649: END IF;
650: -- Standard call to get message count and if count=1, get the message
651: FND_MSG_PUB.Count_And_Get (
652: p_encoded => FND_API.G_FALSE,

Line 651: FND_MSG_PUB.Count_And_Get (

647: THEN
648: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
649: END IF;
650: -- Standard call to get message count and if count=1, get the message
651: FND_MSG_PUB.Count_And_Get (
652: p_encoded => FND_API.G_FALSE,
653: p_count => x_msg_count,
654: p_data => x_msg_data
655: );

Line 695: FND_MSG_PUB.initialize;

691:
692: -- Initialize message list if p_init_msg_list is set to TRUE.
693: IF FND_API.to_Boolean( p_init_msg_list )
694: THEN
695: FND_MSG_PUB.initialize;
696: END IF;
697:
698: -- Standard call to check for call compatibility.
699: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

723: FETCH c_Metric_Template INTO l_METRIC_TPL_HEADER_ID;
724:
725: IF (c_Metric_Template%NOTFOUND) THEN
726: CLOSE c_Metric_Template;
727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
728: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
729: FND_MSG_PUB.ADD;
730: END IF;
731: RAISE FND_API.g_exc_error;

Line 729: FND_MSG_PUB.ADD;

725: IF (c_Metric_Template%NOTFOUND) THEN
726: CLOSE c_Metric_Template;
727: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
728: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
729: FND_MSG_PUB.ADD;
730: END IF;
731: RAISE FND_API.g_exc_error;
732: END IF;
733:

Line 737: FND_MSG_PUB.count_and_get(

733:
734: CLOSE c_Metric_Template;
735:
736: -------------------- finish --------------------------
737: FND_MSG_PUB.count_and_get(
738: p_encoded => FND_API.g_false,
739: p_count => x_msg_count,
740: p_data => x_msg_data);
741: IF (AMS_DEBUG_HIGH_ON) THEN

Line 755: FND_MSG_PUB.Count_And_Get (

751: WHEN FND_API.G_EXC_ERROR THEN
752: ROLLBACK TO LOCK_Metric_Template_PVT;
753: x_return_status := FND_API.G_RET_STS_ERROR;
754: -- Standard call to get message count and if count=1, get the message
755: FND_MSG_PUB.Count_And_Get (
756: p_encoded => FND_API.G_FALSE,
757: p_count => x_msg_count,
758: p_data => x_msg_data
759: );

Line 765: FND_MSG_PUB.Count_And_Get (

761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
762: ROLLBACK TO LOCK_Metric_Template_PVT;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: -- Standard call to get message count and if count=1, get the message
765: FND_MSG_PUB.Count_And_Get (
766: p_encoded => FND_API.G_FALSE,
767: p_count => x_msg_count,
768: p_data => x_msg_data
769: );

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

770:
771: WHEN OTHERS THEN
772: ROLLBACK TO LOCK_Metric_Template_PVT;
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
777: END IF;
778: -- Standard call to get message count and if count=1, get the message

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

772: ROLLBACK TO LOCK_Metric_Template_PVT;
773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
777: END IF;
778: -- Standard call to get message count and if count=1, get the message
779: FND_MSG_PUB.Count_And_Get (
780: p_encoded => FND_API.G_FALSE,

Line 779: FND_MSG_PUB.Count_And_Get (

775: THEN
776: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
777: END IF;
778: -- Standard call to get message count and if count=1, get the message
779: FND_MSG_PUB.Count_And_Get (
780: p_encoded => FND_API.G_FALSE,
781: p_count => x_msg_count,
782: p_data => x_msg_data
783: );

Line 1321: FND_MSG_PUB.initialize;

1317:
1318: -- Initialize message list if p_init_msg_list is set to TRUE.
1319: IF FND_API.to_Boolean( p_init_msg_list )
1320: THEN
1321: FND_MSG_PUB.initialize;
1322: END IF;
1323:
1324: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1325: -- Debug Message

Line 1373: FND_MSG_PUB.Count_And_Get

1369: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': END');
1370: END IF;
1371:
1372: -- Standard call to get message count and if count is 1, get message info.
1373: FND_MSG_PUB.Count_And_Get
1374: (p_count => x_msg_count,
1375: p_data => x_msg_data
1376: );
1377: EXCEPTION

Line 1387: FND_MSG_PUB.Count_And_Get (

1383: WHEN FND_API.G_EXC_ERROR THEN
1384: ROLLBACK TO VALIDATE_Metric_Template_;
1385: x_return_status := FND_API.G_RET_STS_ERROR;
1386: -- Standard call to get message count and if count=1, get the message
1387: FND_MSG_PUB.Count_And_Get (
1388: p_encoded => FND_API.G_FALSE,
1389: p_count => x_msg_count,
1390: p_data => x_msg_data
1391: );

Line 1397: FND_MSG_PUB.Count_And_Get (

1393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1394: ROLLBACK TO VALIDATE_Metric_Template_;
1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1396: -- Standard call to get message count and if count=1, get the message
1397: FND_MSG_PUB.Count_And_Get (
1398: p_encoded => FND_API.G_FALSE,
1399: p_count => x_msg_count,
1400: p_data => x_msg_data
1401: );

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

1402:
1403: WHEN OTHERS THEN
1404: ROLLBACK TO VALIDATE_Metric_Template_;
1405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1406: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1407: THEN
1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1409: END IF;
1410: -- Standard call to get message count and if count=1, get the message

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

1404: ROLLBACK TO VALIDATE_Metric_Template_;
1405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1406: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1407: THEN
1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1409: END IF;
1410: -- Standard call to get message count and if count=1, get the message
1411: FND_MSG_PUB.Count_And_Get (
1412: p_encoded => FND_API.G_FALSE,

Line 1411: FND_MSG_PUB.Count_And_Get (

1407: THEN
1408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1409: END IF;
1410: -- Standard call to get message count and if count=1, get the message
1411: FND_MSG_PUB.Count_And_Get (
1412: p_encoded => FND_API.G_FALSE,
1413: p_count => x_msg_count,
1414: p_data => x_msg_data
1415: );

Line 1432: FND_MSG_PUB.initialize;

1428: BEGIN
1429: -- Initialize message list if p_init_msg_list is set to TRUE.
1430: IF FND_API.to_Boolean( p_init_msg_list )
1431: THEN
1432: FND_MSG_PUB.initialize;
1433: END IF;
1434:
1435: -- Initialize API return status to SUCCESS
1436: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1449: FND_MSG_PUB.Count_And_Get

1445:
1446: Ams_Utility_Pvt.debug_message('PRIVATE API: Validate_met_tpl_hdr_rec');
1447: END IF;
1448: -- Standard call to get message count and if count is 1, get message info.
1449: FND_MSG_PUB.Count_And_Get
1450: (p_count => x_msg_count,
1451: p_data => x_msg_data
1452: );
1453: END Validate_met_tpl_hdr_Rec;