63:
64: l_met_tpl_dtl_rec met_tpl_dtl_rec_type := p_met_tpl_dtl_rec;
65:
66: BEGIN
67: -- Standard Start of API savepoint
68: SAVEPOINT CREATE_Met_Tpl_Dtl_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_Met_Tpl_Dtl_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)
182: --
183: -- End of API body
184: --
185:
186: -- Standard check for p_commit
187: IF FND_API.to_Boolean( p_commit )
188: THEN
189: COMMIT WORK;
190: END IF;
195:
196: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');
197: END IF;
198:
199: -- Standard call to get message count and if count is 1, get message info.
200: FND_MSG_PUB.Count_And_Get
201: (p_count => x_msg_count,
202: p_data => x_msg_data
203: );
209:
210: WHEN FND_API.G_EXC_ERROR THEN
211: ROLLBACK TO CREATE_Met_Tpl_Dtl_PVT;
212: x_return_status := FND_API.G_RET_STS_ERROR;
213: -- Standard call to get message count and if count=1, get the message
214: FND_MSG_PUB.Count_And_Get (
215: p_encoded => FND_API.G_FALSE,
216: p_count => x_msg_count,
217: p_data => x_msg_data
219:
220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
221: ROLLBACK TO CREATE_Met_Tpl_Dtl_PVT;
222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
223: -- Standard call to get message count and if count=1, get the message
224: FND_MSG_PUB.Count_And_Get (
225: p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count,
227: p_data => x_msg_data
233: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
234: THEN
235: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
236: END IF;
237: -- Standard call to get message count and if count=1, get the message
238: FND_MSG_PUB.Count_And_Get (
239: p_encoded => FND_API.G_FALSE,
240: p_count => x_msg_count,
241: p_data => x_msg_data
281: l_tar_met_tpl_dtl_rec met_tpl_dtl_rec_type := p_met_tpl_dtl_rec;
282: l_rowid ROWID;
283:
284: BEGIN
285: -- Standard Start of API savepoint
286: SAVEPOINT UPDATE_Met_Tpl_Dtl_PVT;
287:
288: -- Standard call to check for call compatibility.
289: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
284: BEGIN
285: -- Standard Start of API savepoint
286: SAVEPOINT UPDATE_Met_Tpl_Dtl_PVT;
287:
288: -- Standard call to check for call compatibility.
289: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
290: p_api_version_number,
291: l_api_name,
292: G_PKG_NAME)
426: --
427: -- End of API body.
428: --
429:
430: -- Standard check for p_commit
431: IF FND_API.to_Boolean( p_commit )
432: THEN
433: COMMIT WORK;
434: END IF;
439:
440: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');
441: END IF;
442:
443: -- Standard call to get message count and if count is 1, get message info.
444: FND_MSG_PUB.Count_And_Get
445: (p_count => x_msg_count,
446: p_data => x_msg_data
447: );
453:
454: WHEN FND_API.G_EXC_ERROR THEN
455: ROLLBACK TO UPDATE_Met_Tpl_Dtl_PVT;
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: -- Standard call to get message count and if count=1, get the message
458: FND_MSG_PUB.Count_And_Get (
459: p_encoded => FND_API.G_FALSE,
460: p_count => x_msg_count,
461: p_data => x_msg_data
463:
464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
465: ROLLBACK TO UPDATE_Met_Tpl_Dtl_PVT;
466: x_return_status := FND_API.G_RET_STS_UNEXP_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
477: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
478: THEN
479: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
480: END IF;
481: -- Standard call to get message count and if count=1, get the message
482: FND_MSG_PUB.Count_And_Get (
483: p_encoded => FND_API.G_FALSE,
484: p_count => x_msg_count,
485: p_data => x_msg_data
504: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
505: l_object_version_number NUMBER;
506:
507: BEGIN
508: -- Standard Start of API savepoint
509: SAVEPOINT DELETE_Met_Tpl_Dtl_PVT;
510:
511: -- Standard call to check for call compatibility.
512: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
507: BEGIN
508: -- Standard Start of API savepoint
509: SAVEPOINT DELETE_Met_Tpl_Dtl_PVT;
510:
511: -- Standard call to check for call compatibility.
512: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
513: p_api_version_number,
514: l_api_name,
515: G_PKG_NAME)
558: --
559: -- End of API body
560: --
561:
562: -- Standard check for p_commit
563: IF FND_API.to_Boolean( p_commit )
564: THEN
565: COMMIT WORK;
566: END IF;
571:
572: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');
573: END IF;
574:
575: -- Standard call to get message count and if count is 1, get message info.
576: FND_MSG_PUB.Count_And_Get
577: (p_count => x_msg_count,
578: p_data => x_msg_data
579: );
585:
586: WHEN FND_API.G_EXC_ERROR THEN
587: ROLLBACK TO DELETE_Met_Tpl_Dtl_PVT;
588: x_return_status := FND_API.G_RET_STS_ERROR;
589: -- Standard call to get message count and if count=1, get the message
590: FND_MSG_PUB.Count_And_Get (
591: p_encoded => FND_API.G_FALSE,
592: p_count => x_msg_count,
593: p_data => x_msg_data
595:
596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
597: ROLLBACK TO DELETE_Met_Tpl_Dtl_PVT;
598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
599: -- Standard call to get message count and if count=1, get the message
600: FND_MSG_PUB.Count_And_Get (
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_msg_count,
603: p_data => x_msg_data
609: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
610: THEN
611: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
612: END IF;
613: -- Standard call to get message count and if count=1, get the message
614: FND_MSG_PUB.Count_And_Get (
615: p_encoded => FND_API.G_FALSE,
616: p_count => x_msg_count,
617: p_data => x_msg_data
659: THEN
660: FND_MSG_PUB.initialize;
661: END IF;
662:
663: -- Standard call to check for call compatibility.
664: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
665: p_api_version_number,
666: l_api_name,
667: G_PKG_NAME)
715:
716: WHEN FND_API.G_EXC_ERROR THEN
717: ROLLBACK TO LOCK_Met_Tpl_Dtl_PVT;
718: x_return_status := FND_API.G_RET_STS_ERROR;
719: -- Standard call to get message count and if count=1, get the message
720: FND_MSG_PUB.Count_And_Get (
721: p_encoded => FND_API.G_FALSE,
722: p_count => x_msg_count,
723: p_data => x_msg_data
725:
726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
727: ROLLBACK TO LOCK_Met_Tpl_Dtl_PVT;
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
729: -- Standard call to get message count and if count=1, get the message
730: FND_MSG_PUB.Count_And_Get (
731: p_encoded => FND_API.G_FALSE,
732: p_count => x_msg_count,
733: p_data => x_msg_data
739: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
740: THEN
741: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
742: END IF;
743: -- Standard call to get message count and if count=1, get the message
744: FND_MSG_PUB.Count_And_Get (
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_msg_count,
747: p_data => x_msg_data
1054: l_object_version_number NUMBER;
1055: l_met_tpl_dtl_rec Ams_Met_Tpl_Dtl_Pvt.met_tpl_dtl_rec_type;
1056:
1057: BEGIN
1058: -- Standard Start of API savepoint
1059: SAVEPOINT VALIDATE_Met_Tpl_Dtl_;
1060:
1061: -- Standard call to check for call compatibility.
1062: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1057: BEGIN
1058: -- Standard Start of API savepoint
1059: SAVEPOINT VALIDATE_Met_Tpl_Dtl_;
1060:
1061: -- Standard call to check for call compatibility.
1062: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1063: p_api_version_number,
1064: l_api_name,
1065: G_PKG_NAME)
1124:
1125: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': END');
1126: END IF;
1127:
1128: -- Standard call to get message count and if count is 1, get message info.
1129: FND_MSG_PUB.Count_And_Get
1130: (p_count => x_msg_count,
1131: p_data => x_msg_data
1132: );
1138:
1139: WHEN FND_API.G_EXC_ERROR THEN
1140: ROLLBACK TO VALIDATE_Met_Tpl_Dtl_;
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142: -- Standard call to get message count and if count=1, get the message
1143: FND_MSG_PUB.Count_And_Get (
1144: p_encoded => FND_API.G_FALSE,
1145: p_count => x_msg_count,
1146: p_data => x_msg_data
1148:
1149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1150: ROLLBACK TO VALIDATE_Met_Tpl_Dtl_;
1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1152: -- Standard call to get message count and if count=1, get the message
1153: FND_MSG_PUB.Count_And_Get (
1154: p_encoded => FND_API.G_FALSE,
1155: p_count => x_msg_count,
1156: p_data => x_msg_data
1162: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1163: THEN
1164: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1165: END IF;
1166: -- Standard call to get message count and if count=1, get the message
1167: FND_MSG_PUB.Count_And_Get (
1168: p_encoded => FND_API.G_FALSE,
1169: p_count => x_msg_count,
1170: p_data => x_msg_data
1200: IF (AMS_DEBUG_HIGH_ON) THEN
1201:
1202: Ams_Utility_Pvt.debug_message('PRIVATE API: Validate_met_tpl_dtl_rec');
1203: END IF;
1204: -- Standard call to get message count and if count is 1, get message info.
1205: FND_MSG_PUB.Count_And_Get
1206: (p_count => x_msg_count,
1207: p_data => x_msg_data
1208: );