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

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

22:
23: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_metric_formula_PVT';
24: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvmtdb.pls';
25:
26: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
27: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
28: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
29:
30: G_SEQUENCE_INCREMENT CONSTANT NUMBER := 10;

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

23: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_metric_formula_PVT';
24: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvmtdb.pls';
25:
26: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
27: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
28: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
29:
30: G_SEQUENCE_INCREMENT CONSTANT NUMBER := 10;
31:

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

24: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvmtdb.pls';
25:
26: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
27: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
28: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
29:
30: G_SEQUENCE_INCREMENT CONSTANT NUMBER := 10;
31:
32: TYPE stack_rec_type IS RECORD

Line 128: FND_MSG_PUB.initialize;

124:
125: -- Initialize message list if p_init_msg_list is set to TRUE.
126: IF FND_API.to_Boolean( p_init_msg_list )
127: THEN
128: FND_MSG_PUB.initialize;
129: END IF;
130:
131: -- Debug Message
132: IF (AMS_DEBUG_HIGH_ON) THEN

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

136:
137: --sunkumar 30/01/2003
138: --check if the template is a seeded one
139: /* IF p_metric_formula_rec.metric_tpl_header_id < 10000 THEN
140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
141: THEN
142: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED');
143: END IF;
144:

Line 271: FND_MSG_PUB.Count_And_Get

267: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');
268: END IF;
269:
270: -- Standard call to get message count and if count is 1, get message info.
271: FND_MSG_PUB.Count_And_Get
272: (p_count => x_msg_count,
273: p_data => x_msg_data
274: );
275: EXCEPTION

Line 285: FND_MSG_PUB.Count_And_Get (

281: WHEN FND_API.G_EXC_ERROR THEN
282: ROLLBACK TO CREATE_metric_formula_SP;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: -- Standard call to get message count and if count=1, get the message
285: FND_MSG_PUB.Count_And_Get (
286: p_encoded => FND_API.G_FALSE,
287: p_count => x_msg_count,
288: p_data => x_msg_data
289: );

Line 295: FND_MSG_PUB.Count_And_Get (

291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
292: ROLLBACK TO CREATE_metric_formula_SP;
293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
294: -- Standard call to get message count and if count=1, get the message
295: FND_MSG_PUB.Count_And_Get (
296: p_encoded => FND_API.G_FALSE,
297: p_count => x_msg_count,
298: p_data => x_msg_data
299: );

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

300:
301: WHEN OTHERS THEN
302: ROLLBACK TO CREATE_metric_formula_SP;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
305: THEN
306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
307: END IF;
308: -- Standard call to get message count and if count=1, get the message

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

302: ROLLBACK TO CREATE_metric_formula_SP;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
305: THEN
306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
307: END IF;
308: -- Standard call to get message count and if count=1, get the message
309: FND_MSG_PUB.Count_And_Get (
310: p_encoded => FND_API.G_FALSE,

Line 309: FND_MSG_PUB.Count_And_Get (

305: THEN
306: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
307: END IF;
308: -- Standard call to get message count and if count=1, get the message
309: FND_MSG_PUB.Count_And_Get (
310: p_encoded => FND_API.G_FALSE,
311: p_count => x_msg_count,
312: p_data => x_msg_data
313: );

Line 383: FND_MSG_PUB.initialize;

379:
380: -- Initialize message list if p_init_msg_list is set to TRUE.
381: IF FND_API.to_Boolean( p_init_msg_list )
382: THEN
383: FND_MSG_PUB.initialize;
384: END IF;
385:
386: -- Debug Message
387: IF (AMS_DEBUG_HIGH_ON) THEN

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

437: IF l_tar_metric_formula_rec.metric_id < 10000 THEN
438: IF ( (l_tar_metric_formula_rec.METRIC_FORMULA_ID <>l_ref_metric_formula_rec.METRIC_FORMULA_ID )
439: OR (l_tar_metric_formula_rec.metric_id <>l_ref_metric_formula_rec.metric_id)
440: ) THEN
441: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
442: THEN
443: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_SEEDED_METR');
444: END IF;
445: RAISE FND_API.G_EXC_ERROR;

Line 530: FND_MSG_PUB.Count_And_Get

526: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');
527: END IF;
528:
529: -- Standard call to get message count and if count is 1, get message info.
530: FND_MSG_PUB.Count_And_Get
531: (p_count => x_msg_count,
532: p_data => x_msg_data
533: );
534: EXCEPTION

Line 544: FND_MSG_PUB.Count_And_Get (

540: WHEN FND_API.G_EXC_ERROR THEN
541: ROLLBACK TO UPDATE_metric_formula_sp;
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: -- Standard call to get message count and if count=1, get the message
544: FND_MSG_PUB.Count_And_Get (
545: p_encoded => FND_API.G_FALSE,
546: p_count => x_msg_count,
547: p_data => x_msg_data
548: );

Line 554: FND_MSG_PUB.Count_And_Get (

550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
551: ROLLBACK TO UPDATE_metric_formula_sp;
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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 563: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

559:
560: WHEN OTHERS THEN
561: ROLLBACK TO UPDATE_metric_formula_sp;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
564: THEN
565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
566: END IF;
567: -- Standard call to get message count and if count=1, get the message

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

561: ROLLBACK TO UPDATE_metric_formula_sp;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
564: THEN
565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
566: END IF;
567: -- Standard call to get message count and if count=1, get the message
568: FND_MSG_PUB.Count_And_Get (
569: p_encoded => FND_API.G_FALSE,

Line 568: FND_MSG_PUB.Count_And_Get (

564: THEN
565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
566: END IF;
567: -- Standard call to get message count and if count=1, get the message
568: FND_MSG_PUB.Count_And_Get (
569: p_encoded => FND_API.G_FALSE,
570: p_count => x_msg_count,
571: p_data => x_msg_data
572: );

Line 609: FND_MSG_PUB.initialize;

605:
606: -- Initialize message list if p_init_msg_list is set to TRUE.
607: IF FND_API.to_Boolean( p_init_msg_list )
608: THEN
609: FND_MSG_PUB.initialize;
610: END IF;
611:
612: -- Debug Message
613: IF (AMS_DEBUG_HIGH_ON) THEN

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

616: END IF;
617:
618: --check if the formula is a seeded one
619: IF p_METRIC_FORMULA_ID < 10000 THEN
620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
621: THEN
622: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_SEEDED_METR');
623: END IF;
624:

Line 661: FND_MSG_PUB.Count_And_Get

657: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');
658: END IF;
659:
660: -- Standard call to get message count and if count is 1, get message info.
661: FND_MSG_PUB.Count_And_Get
662: (p_count => x_msg_count,
663: p_data => x_msg_data
664: );
665: EXCEPTION

Line 675: FND_MSG_PUB.Count_And_Get (

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

Line 685: FND_MSG_PUB.Count_And_Get (

681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
682: ROLLBACK TO DELETE_metric_formula_SP;
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (
686: p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data
689: );

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

690:
691: WHEN OTHERS THEN
692: ROLLBACK TO DELETE_metric_formula_SP;
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
694: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
695: THEN
696: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
697: END IF;
698: -- Standard call to get message count and if count=1, get the message

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

692: ROLLBACK TO DELETE_metric_formula_SP;
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
694: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
695: THEN
696: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
697: END IF;
698: -- Standard call to get message count and if count=1, get the message
699: FND_MSG_PUB.Count_And_Get (
700: p_encoded => FND_API.G_FALSE,

Line 699: FND_MSG_PUB.Count_And_Get (

695: THEN
696: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
697: END IF;
698: -- Standard call to get message count and if count=1, get the message
699: FND_MSG_PUB.Count_And_Get (
700: p_encoded => FND_API.G_FALSE,
701: p_count => x_msg_count,
702: p_data => x_msg_data
703: );

Line 746: FND_MSG_PUB.initialize;

742:
743: -- Initialize message list if p_init_msg_list is set to TRUE.
744: IF FND_API.to_Boolean( p_init_msg_list )
745: THEN
746: FND_MSG_PUB.initialize;
747: END IF;
748:
749: -- Standard call to check for call compatibility.
750: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

770: FETCH c_metric_formula INTO l_METRIC_FORMULA_ID;
771:
772: IF (c_metric_formula%NOTFOUND) THEN
773: CLOSE c_metric_formula;
774: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
775: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
776: FND_MSG_PUB.ADD;
777: END IF;
778: RAISE FND_API.g_exc_error;

Line 776: FND_MSG_PUB.ADD;

772: IF (c_metric_formula%NOTFOUND) THEN
773: CLOSE c_metric_formula;
774: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
775: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
776: FND_MSG_PUB.ADD;
777: END IF;
778: RAISE FND_API.g_exc_error;
779: END IF;
780:

Line 784: FND_MSG_PUB.count_and_get(

780:
781: CLOSE c_metric_formula;
782:
783: -------------------- finish --------------------------
784: FND_MSG_PUB.count_and_get(
785: p_encoded => FND_API.g_false,
786: p_count => x_msg_count,
787: p_data => x_msg_data);
788: IF (AMS_DEBUG_HIGH_ON) THEN

Line 801: FND_MSG_PUB.Count_And_Get (

797: WHEN FND_API.G_EXC_ERROR THEN
798: ROLLBACK TO LOCK_metric_formula_SP;
799: x_return_status := FND_API.G_RET_STS_ERROR;
800: -- Standard call to get message count and if count=1, get the message
801: FND_MSG_PUB.Count_And_Get (
802: p_encoded => FND_API.G_FALSE,
803: p_count => x_msg_count,
804: p_data => x_msg_data
805: );

Line 811: FND_MSG_PUB.Count_And_Get (

807: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
808: ROLLBACK TO LOCK_metric_formula_SP;
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
810: -- Standard call to get message count and if count=1, get the message
811: FND_MSG_PUB.Count_And_Get (
812: p_encoded => FND_API.G_FALSE,
813: p_count => x_msg_count,
814: p_data => x_msg_data
815: );

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

816:
817: WHEN OTHERS THEN
818: ROLLBACK TO LOCK_metric_formula_SP;
819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
820: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
821: THEN
822: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
823: END IF;
824: -- Standard call to get message count and if count=1, get the message

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

818: ROLLBACK TO LOCK_metric_formula_SP;
819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
820: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
821: THEN
822: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
823: END IF;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (
826: p_encoded => FND_API.G_FALSE,

Line 825: FND_MSG_PUB.Count_And_Get (

821: THEN
822: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
823: END IF;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (
826: p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,
828: p_data => x_msg_data
829: );

Line 1283: FND_MSG_PUB.initialize;

1279:
1280: -- Initialize message list if p_init_msg_list is set to TRUE.
1281: IF FND_API.to_Boolean( p_init_msg_list )
1282: THEN
1283: FND_MSG_PUB.initialize;
1284: END IF;
1285:
1286: -- Debug Message
1287: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1338: FND_MSG_PUB.Count_And_Get

1334: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': END');
1335: END IF;
1336:
1337: -- Standard call to get message count and if count is 1, get message info.
1338: FND_MSG_PUB.Count_And_Get
1339: (p_count => x_msg_count,
1340: p_data => x_msg_data
1341: );
1342: EXCEPTION

Line 1352: FND_MSG_PUB.Count_And_Get (

1348: WHEN FND_API.G_EXC_ERROR THEN
1349: -- ROLLBACK TO VALIDATE_metric_formula_sp;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: -- Standard call to get message count and if count=1, get the message
1352: FND_MSG_PUB.Count_And_Get (
1353: p_encoded => FND_API.G_FALSE,
1354: p_count => x_msg_count,
1355: p_data => x_msg_data
1356: );

Line 1362: FND_MSG_PUB.Count_And_Get (

1358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1359: -- ROLLBACK TO VALIDATE_metric_formula_sp;
1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1361: -- Standard call to get message count and if count=1, get the message
1362: FND_MSG_PUB.Count_And_Get (
1363: p_encoded => FND_API.G_FALSE,
1364: p_count => x_msg_count,
1365: p_data => x_msg_data
1366: );

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

1367:
1368: WHEN OTHERS THEN
1369: -- ROLLBACK TO VALIDATE_metric_formula_sp;
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1371: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1372: THEN
1373: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1374: END IF;
1375: -- Standard call to get message count and if count=1, get the message

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

1369: -- ROLLBACK TO VALIDATE_metric_formula_sp;
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1371: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1372: THEN
1373: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1374: END IF;
1375: -- Standard call to get message count and if count=1, get the message
1376: FND_MSG_PUB.Count_And_Get (
1377: p_encoded => FND_API.G_FALSE,

Line 1376: FND_MSG_PUB.Count_And_Get (

1372: THEN
1373: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1374: END IF;
1375: -- Standard call to get message count and if count=1, get the message
1376: FND_MSG_PUB.Count_And_Get (
1377: p_encoded => FND_API.G_FALSE,
1378: p_count => x_msg_count,
1379: p_data => x_msg_data
1380: );

Line 1397: FND_MSG_PUB.initialize;

1393: BEGIN
1394: -- Initialize message list if p_init_msg_list is set to TRUE.
1395: IF FND_API.to_Boolean( p_init_msg_list )
1396: THEN
1397: FND_MSG_PUB.initialize;
1398: END IF;
1399:
1400: -- Initialize API return status to SUCCESS
1401: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1413: FND_MSG_PUB.Count_And_Get

1409: IF (AMS_DEBUG_HIGH_ON) THEN
1410: Ams_Utility_Pvt.debug_message('PRIVATE API: Validate_metric_formula_rec');
1411: END IF;
1412: -- Standard call to get message count and if count is 1, get message info.
1413: FND_MSG_PUB.Count_And_Get
1414: (p_count => x_msg_count,
1415: p_data => x_msg_data
1416: );
1417: END Validate_metric_formula_Rec;

Line 1714: FND_MSG_PUB.initialize;

1710: END IF;
1711: -- Initialize message list if p_init_msg_list is set to TRUE.
1712: IF FND_API.to_Boolean( p_init_msg_list )
1713: THEN
1714: FND_MSG_PUB.initialize;
1715: END IF;
1716:
1717: -- Initialize API return status to SUCCESS
1718: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1735: end if;
1736:
1737: if not g_valid_formula then
1738:
1739: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1740: FND_MESSAGE.set_name('AMS', 'AMS_METR_INVALID_FORMULA_DEF');
1741: FND_MESSAGE.set_token('FORMULA', g_infix_formula);
1742: FND_MESSAGE.set_token('SEQUENCE', g_error_sequence);
1743: FND_MSG_PUB.add;

Line 1743: FND_MSG_PUB.add;

1739: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1740: FND_MESSAGE.set_name('AMS', 'AMS_METR_INVALID_FORMULA_DEF');
1741: FND_MESSAGE.set_token('FORMULA', g_infix_formula);
1742: FND_MESSAGE.set_token('SEQUENCE', g_error_sequence);
1743: FND_MSG_PUB.add;
1744: END IF;
1745:
1746: x_msg_data := g_infix_formula;
1747: x_return_status := FND_API.g_ret_sts_error;

Line 1825: FND_MSG_PUB.Count_And_Get

1821: END IF;
1822:
1823:
1824: -- Standard call to get message count and if count is 1, get message info.
1825: FND_MSG_PUB.Count_And_Get
1826: (p_count => x_msg_count,
1827: p_data => x_msg_data
1828: );
1829:

Line 1837: FND_MSG_PUB.Count_And_Get (

1833: WHEN FND_API.G_EXC_ERROR THEN
1834: -- ROLLBACK TO VALIDATE_metric_formula_sp;
1835: x_return_status := FND_API.G_RET_STS_ERROR;
1836: -- Standard call to get message count and if count=1, get the message
1837: FND_MSG_PUB.Count_And_Get (
1838: p_encoded => FND_API.G_FALSE,
1839: p_count => x_msg_count,
1840: p_data => x_msg_data
1841: );