81:
82: l_get_service_attr c_get_service_attr%ROWTYPE;
83:
84: BEGIN
85: -- Standard Start of API savepoint
86: SAVEPOINT CREATE_Prod_Template_PVT;
87:
88: -- Standard call to check for call compatibility.
89: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
84: BEGIN
85: -- Standard Start of API savepoint
86: SAVEPOINT CREATE_Prod_Template_PVT;
87:
88: -- Standard call to check for call compatibility.
89: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
90: p_api_version_number,
91: l_api_name,
92: G_PKG_NAME)
328: --
329: -- End of API body
330: --
331:
332: -- Standard check for p_commit
333: IF FND_API.to_Boolean( p_commit )
334: THEN
335: COMMIT WORK;
336: END IF;
341:
342: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
343: END IF;
344:
345: -- Standard call to get message count and if count is 1, get message info.
346: FND_MSG_PUB.Count_And_Get
347: (p_count => x_msg_count,
348: p_data => x_msg_data
349: );
355:
356: WHEN FND_API.G_EXC_ERROR THEN
357: ROLLBACK TO CREATE_Prod_Template_PVT;
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: -- Standard call to get message count and if count=1, get the message
360: FND_MSG_PUB.Count_And_Get (
361: p_encoded => FND_API.G_FALSE,
362: p_count => x_msg_count,
363: p_data => x_msg_data
365:
366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
367: ROLLBACK TO CREATE_Prod_Template_PVT;
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: -- Standard call to get message count and if count=1, get the message
370: FND_MSG_PUB.Count_And_Get (
371: p_encoded => FND_API.G_FALSE,
372: p_count => x_msg_count,
373: p_data => x_msg_data
379: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
382: END IF;
383: -- Standard call to get message count and if count=1, get the message
384: FND_MSG_PUB.Count_And_Get (
385: p_encoded => FND_API.G_FALSE,
386: p_count => x_msg_count,
387: p_data => x_msg_data
419: l_tar_prod_template_rec AMS_Prod_Template_PVT.prod_template_rec_type := P_prod_template_rec;
420: l_rowid ROWID;
421:
422: BEGIN
423: -- Standard Start of API savepoint
424: SAVEPOINT UPDATE_Prod_Template_PVT;
425:
426: -- Standard call to check for call compatibility.
427: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
422: BEGIN
423: -- Standard Start of API savepoint
424: SAVEPOINT UPDATE_Prod_Template_PVT;
425:
426: -- Standard call to check for call compatibility.
427: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
428: p_api_version_number,
429: l_api_name,
430: G_PKG_NAME)
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: End If;
543:
544:
545: -- Standard check for p_commit
546: IF FND_API.to_Boolean( p_commit )
547: THEN
548: COMMIT WORK;
549: END IF;
554:
555: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
556: END IF;
557:
558: -- Standard call to get message count and if count is 1, get message info.
559: FND_MSG_PUB.Count_And_Get
560: (p_count => x_msg_count,
561: p_data => x_msg_data
562: );
568:
569: WHEN FND_API.G_EXC_ERROR THEN
570: ROLLBACK TO UPDATE_Prod_Template_PVT;
571: x_return_status := FND_API.G_RET_STS_ERROR;
572: -- Standard call to get message count and if count=1, get the message
573: FND_MSG_PUB.Count_And_Get (
574: p_encoded => FND_API.G_FALSE,
575: p_count => x_msg_count,
576: p_data => x_msg_data
578:
579: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
580: ROLLBACK TO UPDATE_Prod_Template_PVT;
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: -- Standard call to get message count and if count=1, get the message
583: FND_MSG_PUB.Count_And_Get (
584: p_encoded => FND_API.G_FALSE,
585: p_count => x_msg_count,
586: p_data => x_msg_data
592: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
593: THEN
594: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
595: END IF;
596: -- Standard call to get message count and if count=1, get the message
597: FND_MSG_PUB.Count_And_Get (
598: p_encoded => FND_API.G_FALSE,
599: p_count => x_msg_count,
600: p_data => x_msg_data
619: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
620: l_object_version_number NUMBER;
621:
622: BEGIN
623: -- Standard Start of API savepoint
624: SAVEPOINT DELETE_Prod_Template_PVT;
625:
626: -- Standard call to check for call compatibility.
627: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
622: BEGIN
623: -- Standard Start of API savepoint
624: SAVEPOINT DELETE_Prod_Template_PVT;
625:
626: -- Standard call to check for call compatibility.
627: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
628: p_api_version_number,
629: l_api_name,
630: G_PKG_NAME)
704: --
705: -- End of API body
706: --
707:
708: -- Standard check for p_commit
709: IF FND_API.to_Boolean( p_commit )
710: THEN
711: COMMIT WORK;
712: END IF;
717:
718: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
719: END IF;
720:
721: -- Standard call to get message count and if count is 1, get message info.
722: FND_MSG_PUB.Count_And_Get
723: (p_count => x_msg_count,
724: p_data => x_msg_data
725: );
731:
732: WHEN FND_API.G_EXC_ERROR THEN
733: ROLLBACK TO DELETE_Prod_Template_PVT;
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: -- Standard call to get message count and if count=1, get the message
736: FND_MSG_PUB.Count_And_Get (
737: p_encoded => FND_API.G_FALSE,
738: p_count => x_msg_count,
739: p_data => x_msg_data
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: ROLLBACK TO DELETE_Prod_Template_PVT;
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: -- Standard call to get message count and if count=1, get the message
746: FND_MSG_PUB.Count_And_Get (
747: p_encoded => FND_API.G_FALSE,
748: p_count => x_msg_count,
749: p_data => x_msg_data
755: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
756: THEN
757: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
758: END IF;
759: -- Standard call to get message count and if count=1, get the message
760: FND_MSG_PUB.Count_And_Get (
761: p_encoded => FND_API.G_FALSE,
762: p_count => x_msg_count,
763: p_data => x_msg_data
805: THEN
806: FND_MSG_PUB.initialize;
807: END IF;
808:
809: -- Standard call to check for call compatibility.
810: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
811: p_api_version_number,
812: l_api_name,
813: G_PKG_NAME)
861:
862: WHEN FND_API.G_EXC_ERROR THEN
863: ROLLBACK TO LOCK_Prod_Template_PVT;
864: x_return_status := FND_API.G_RET_STS_ERROR;
865: -- Standard call to get message count and if count=1, get the message
866: FND_MSG_PUB.Count_And_Get (
867: p_encoded => FND_API.G_FALSE,
868: p_count => x_msg_count,
869: p_data => x_msg_data
871:
872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
873: ROLLBACK TO LOCK_Prod_Template_PVT;
874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
875: -- Standard call to get message count and if count=1, get the message
876: FND_MSG_PUB.Count_And_Get (
877: p_encoded => FND_API.G_FALSE,
878: p_count => x_msg_count,
879: p_data => x_msg_data
885: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
886: THEN
887: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
888: END IF;
889: -- Standard call to get message count and if count=1, get the message
890: FND_MSG_PUB.Count_And_Get (
891: p_encoded => FND_API.G_FALSE,
892: p_count => x_msg_count,
893: p_data => x_msg_data
1168: l_object_version_number NUMBER;
1169: l_prod_template_rec AMS_Prod_Template_PVT.prod_template_rec_type;
1170:
1171: BEGIN
1172: -- Standard Start of API savepoint
1173: SAVEPOINT VALIDATE_Prod_Template_;
1174:
1175: -- Standard call to check for call compatibility.
1176: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1171: BEGIN
1172: -- Standard Start of API savepoint
1173: SAVEPOINT VALIDATE_Prod_Template_;
1174:
1175: -- Standard call to check for call compatibility.
1176: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1177: p_api_version_number,
1178: l_api_name,
1179: G_PKG_NAME)
1238:
1239: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1240: END IF;
1241:
1242: -- Standard call to get message count and if count is 1, get message info.
1243: FND_MSG_PUB.Count_And_Get
1244: (p_count => x_msg_count,
1245: p_data => x_msg_data
1246: );
1252:
1253: WHEN FND_API.G_EXC_ERROR THEN
1254: ROLLBACK TO VALIDATE_Prod_Template_;
1255: x_return_status := FND_API.G_RET_STS_ERROR;
1256: -- Standard call to get message count and if count=1, get the message
1257: FND_MSG_PUB.Count_And_Get (
1258: p_encoded => FND_API.G_FALSE,
1259: p_count => x_msg_count,
1260: p_data => x_msg_data
1262:
1263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1264: ROLLBACK TO VALIDATE_Prod_Template_;
1265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1266: -- Standard call to get message count and if count=1, get the message
1267: FND_MSG_PUB.Count_And_Get (
1268: p_encoded => FND_API.G_FALSE,
1269: p_count => x_msg_count,
1270: p_data => x_msg_data
1276: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1277: THEN
1278: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1279: END IF;
1280: -- Standard call to get message count and if count=1, get the message
1281: FND_MSG_PUB.Count_And_Get (
1282: p_encoded => FND_API.G_FALSE,
1283: p_count => x_msg_count,
1284: p_data => x_msg_data
1314: IF (AMS_DEBUG_HIGH_ON) THEN
1315:
1316: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1317: END IF;
1318: -- Standard call to get message count and if count is 1, get message info.
1319: FND_MSG_PUB.Count_And_Get
1320: (p_count => x_msg_count,
1321: p_data => x_msg_data
1322: );