[Home] [Help]
63: FROM AMS_MET_TPL_HEADERS_B
64: WHERE METRIC_TPL_HEADER_ID = l_id;
65:
66: BEGIN
67: -- Standard Start of API savepoint
68: SAVEPOINT CREATE_Metric_Template_PVT;
69:
70: -- Standard call to check for call compatibility.
71: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
66: BEGIN
67: -- Standard Start of API savepoint
68: SAVEPOINT CREATE_Metric_Template_PVT;
69:
70: -- Standard call to check for call compatibility.
71: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
72: p_api_version_number,
73: l_api_name,
74: G_PKG_NAME)
179: --
180: -- End of API body
181: --
182:
183: -- Standard check for p_commit
184: IF FND_API.to_Boolean( p_commit )
185: THEN
186: COMMIT WORK;
187: END IF;
192:
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: );
206:
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
216:
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
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,
237: p_count => x_msg_count,
238: p_data => x_msg_data
284: l_tar_metric_tpl_header_rec metric_tpl_header_rec_type;
285: l_rowid ROWID;
286:
287: BEGIN
288: -- Standard Start of API savepoint
289: SAVEPOINT UPDATE_Metric_Template_PVT;
290:
291: -- Standard call to check for call compatibility.
292: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
287: BEGIN
288: -- Standard Start of API savepoint
289: SAVEPOINT UPDATE_Metric_Template_PVT;
290:
291: -- Standard call to check for call compatibility.
292: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
293: p_api_version_number,
294: l_api_name,
295: G_PKG_NAME)
436: --
437: -- End of API body.
438: --
439:
440: -- Standard check for p_commit
441: IF FND_API.to_Boolean( p_commit )
442: THEN
443: COMMIT WORK;
444: END IF;
449:
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: );
463:
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
473:
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
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,
494: p_count => x_msg_count,
495: p_data => x_msg_data
513: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
514: l_object_version_number NUMBER;
515:
516: BEGIN
517: -- Standard Start of API savepoint
518: SAVEPOINT DELETE_Metric_Template_PVT;
519:
520: -- Standard call to check for call compatibility.
521: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
516: BEGIN
517: -- Standard Start of API savepoint
518: SAVEPOINT DELETE_Metric_Template_PVT;
519:
520: -- Standard call to check for call compatibility.
521: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
522: p_api_version_number,
523: l_api_name,
524: G_PKG_NAME)
595: --
596: -- End of API body
597: --
598:
599: -- Standard check for p_commit
600: IF FND_API.to_Boolean( p_commit )
601: THEN
602: COMMIT WORK;
603: END IF;
608:
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: );
622:
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
632:
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
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,
653: p_count => x_msg_count,
654: p_data => x_msg_data
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,
700: p_api_version_number,
701: l_api_name,
702: G_PKG_NAME)
750:
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
760:
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
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,
781: p_count => x_msg_count,
782: p_data => x_msg_data
1294: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1295: l_object_version_number NUMBER;
1296:
1297: BEGIN
1298: -- Standard Start of API savepoint
1299: SAVEPOINT VALIDATE_Metric_Template_;
1300:
1301: -- Standard call to check for call compatibility.
1302: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1297: BEGIN
1298: -- Standard Start of API savepoint
1299: SAVEPOINT VALIDATE_Metric_Template_;
1300:
1301: -- Standard call to check for call compatibility.
1302: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1303: p_api_version_number,
1304: l_api_name,
1305: G_PKG_NAME)
1368: IF AMS_DEBUG_HIGH_ON THEN
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: );
1382:
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
1392:
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
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,
1413: p_count => x_msg_count,
1414: p_data => x_msg_data
1444: IF (AMS_DEBUG_HIGH_ON) THEN
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: );