DBA Data[Home] [Help]

APPS.AMS_METRIC_FORMULA_PVT dependencies on STANDARD

Line 113: -- Standard Start of API savepoint

109: l_metric_formula_rec met_formula_rec_type := p_met_formula_rec;
110: l_max_sequence number := null;
111:
112: BEGIN
113: -- Standard Start of API savepoint
114: SAVEPOINT CREATE_metric_formula_SP;
115:
116: -- Standard call to check for call compatibility.
117: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 116: -- Standard call to check for call compatibility.

112: BEGIN
113: -- Standard Start of API savepoint
114: SAVEPOINT CREATE_metric_formula_SP;
115:
116: -- Standard call to check for call compatibility.
117: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
118: p_api_version_number,
119: l_api_name,
120: G_PKG_NAME)

Line 257: -- Standard check for p_commit

253: --
254: -- End of API body
255: --
256:
257: -- Standard check for p_commit
258: IF FND_API.to_Boolean( p_commit )
259: THEN
260: COMMIT WORK;
261: END IF;

Line 270: -- Standard call to get message count and if count is 1, get message info.

266:
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: );

Line 284: -- Standard call to get message count and if count=1, get the message

280:
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

Line 294: -- Standard call to get message count and if count=1, get the message

290:
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

Line 308: -- Standard call to get message count and if count=1, get the message

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,
311: p_count => x_msg_count,
312: p_data => x_msg_data

Line 368: -- Standard Start of API savepoint

364: l_rowid ROWID;
365: l_max_sequence NUMBER := null;
366:
367: BEGIN
368: -- Standard Start of API savepoint
369: SAVEPOINT UPDATE_metric_formula_sp;
370:
371: -- Standard call to check for call compatibility.
372: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 371: -- Standard call to check for call compatibility.

367: BEGIN
368: -- Standard Start of API savepoint
369: SAVEPOINT UPDATE_metric_formula_sp;
370:
371: -- Standard call to check for call compatibility.
372: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
373: p_api_version_number,
374: l_api_name,
375: G_PKG_NAME)

Line 516: -- Standard check for p_commit

512: --
513: -- End of API body.
514: --
515:
516: -- Standard check for p_commit
517: IF FND_API.to_Boolean( p_commit )
518: THEN
519: COMMIT WORK;
520: END IF;

Line 529: -- Standard call to get message count and if count is 1, get message info.

525:
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: );

Line 543: -- Standard call to get message count and if count=1, get the message

539:
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

Line 553: -- Standard call to get message count and if count=1, get the message

549:
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

Line 567: -- Standard call to get message count and if count=1, get the message

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,
570: p_count => x_msg_count,
571: p_data => x_msg_data

Line 594: -- Standard Start of API savepoint

590: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
591: l_object_version_number NUMBER;
592:
593: BEGIN
594: -- Standard Start of API savepoint
595: SAVEPOINT DELETE_metric_formula_SP;
596:
597: -- Standard call to check for call compatibility.
598: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 597: -- Standard call to check for call compatibility.

593: BEGIN
594: -- Standard Start of API savepoint
595: SAVEPOINT DELETE_metric_formula_SP;
596:
597: -- Standard call to check for call compatibility.
598: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
599: p_api_version_number,
600: l_api_name,
601: G_PKG_NAME)

Line 647: -- Standard check for p_commit

643: --
644: -- End of API body
645: --
646:
647: -- Standard check for p_commit
648: IF FND_API.to_Boolean( p_commit )
649: THEN
650: COMMIT WORK;
651: END IF;

Line 660: -- Standard call to get message count and if count is 1, get message info.

656:
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: );

Line 674: -- Standard call to get message count and if count=1, get the message

670:
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

Line 684: -- Standard call to get message count and if count=1, get the message

680:
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

Line 698: -- Standard call to get message count and if count=1, get the message

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,
701: p_count => x_msg_count,
702: p_data => x_msg_data

Line 749: -- Standard call to check for call compatibility.

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,
751: p_api_version_number,
752: l_api_name,
753: G_PKG_NAME)

Line 800: -- Standard call to get message count and if count=1, get the message

796:
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

Line 810: -- Standard call to get message count and if count=1, get the message

806:
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

Line 824: -- Standard call to get message count and if count=1, get the message

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,
827: p_count => x_msg_count,
828: p_data => x_msg_data

Line 1268: -- Standard Start of API savepoint

1264: l_object_version_number NUMBER;
1265: l_metric_formula_rec met_formula_rec_type;
1266:
1267: BEGIN
1268: -- Standard Start of API savepoint
1269: -- SAVEPOINT VALIDATE_metric_formula_SP;
1270:
1271: -- Standard call to check for call compatibility.
1272: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1271: -- Standard call to check for call compatibility.

1267: BEGIN
1268: -- Standard Start of API savepoint
1269: -- SAVEPOINT VALIDATE_metric_formula_SP;
1270:
1271: -- Standard call to check for call compatibility.
1272: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1273: p_api_version_number,
1274: l_api_name,
1275: G_PKG_NAME)

Line 1337: -- Standard call to get message count and if count is 1, get message info.

1333: IF (AMS_DEBUG_HIGH_ON) THEN
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: );

Line 1351: -- Standard call to get message count and if count=1, get the message

1347:
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

Line 1361: -- Standard call to get message count and if count=1, get the message

1357:
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

Line 1375: -- Standard call to get message count and if count=1, get the message

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,
1378: p_count => x_msg_count,
1379: p_data => x_msg_data

Line 1412: -- Standard call to get message count and if count is 1, get message info.

1408: -- Debug Message
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: );

Line 1812: -- Standard check for p_commit

1808: end if;
1809:
1810: end if;
1811:
1812: -- Standard check for p_commit
1813: IF FND_API.to_Boolean( p_commit )
1814: THEN
1815: COMMIT WORK;
1816: END IF;

Line 1824: -- Standard call to get message count and if count is 1, get message info.

1820: Ams_Utility_Pvt.debug_message('PRIVATE API: VALIDATE_FORMULA');
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: );

Line 1836: -- Standard call to get message count and if count=1, get the message

1832:
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