53: FROM AMS_CTD_PARAM_VALUES
54: WHERE ACTION_PARAM_VALUE_ID = l_id;
55:
56: BEGIN
57: -- Standard Start of API savepoint
58: SAVEPOINT CREATE_Ctd_Prm_Val_PVT;
59:
60: -- Standard call to check for call compatibility.
61: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
56: BEGIN
57: -- Standard Start of API savepoint
58: SAVEPOINT CREATE_Ctd_Prm_Val_PVT;
59:
60: -- Standard call to check for call compatibility.
61: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
62: p_api_version_number,
63: l_api_name,
64: G_PKG_NAME)
148: --
149: -- End of API body
150: --
151:
152: -- Standard check for p_commit
153: IF FND_API.to_Boolean( p_commit )
154: THEN
155: COMMIT WORK;
156: END IF;
158:
159: -- Debug Message
160: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
161:
162: -- Standard call to get message count and if count is 1, get message info.
163: FND_MSG_PUB.Count_And_Get
164: (p_count => x_msg_count,
165: p_data => x_msg_data
166: );
172:
173: WHEN FND_API.G_EXC_ERROR THEN
174: ROLLBACK TO CREATE_Ctd_Prm_Val_PVT;
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: -- Standard call to get message count and if count=1, get the message
177: FND_MSG_PUB.Count_And_Get (
178: p_encoded => FND_API.G_FALSE,
179: p_count => x_msg_count,
180: p_data => x_msg_data
182:
183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
184: ROLLBACK TO CREATE_Ctd_Prm_Val_PVT;
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186: -- Standard call to get message count and if count=1, get the message
187: FND_MSG_PUB.Count_And_Get (
188: p_encoded => FND_API.G_FALSE,
189: p_count => x_msg_count,
190: p_data => x_msg_data
196: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
197: THEN
198: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
199: END IF;
200: -- Standard call to get message count and if count=1, get the message
201: FND_MSG_PUB.Count_And_Get (
202: p_encoded => FND_API.G_FALSE,
203: p_count => x_msg_count,
204: p_data => x_msg_data
234: l_tar_ctd_prm_val_rec AMS_Ctd_Prm_Val_PVT.ctd_prm_val_rec_type := P_ctd_prm_val_rec;
235: l_rowid ROWID;
236:
237: BEGIN
238: -- Standard Start of API savepoint
239: SAVEPOINT UPDATE_Ctd_Prm_Val_PVT;
240:
241: -- Standard call to check for call compatibility.
242: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
237: BEGIN
238: -- Standard Start of API savepoint
239: SAVEPOINT UPDATE_Ctd_Prm_Val_PVT;
240:
241: -- Standard call to check for call compatibility.
242: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
243: p_api_version_number,
244: l_api_name,
245: G_PKG_NAME)
334: --
335: -- End of API body.
336: --
337:
338: -- Standard check for p_commit
339: IF FND_API.to_Boolean( p_commit )
340: THEN
341: COMMIT WORK;
342: END IF;
344:
345: -- Debug Message
346: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
347:
348: -- Standard call to get message count and if count is 1, get message info.
349: FND_MSG_PUB.Count_And_Get
350: (p_count => x_msg_count,
351: p_data => x_msg_data
352: );
358:
359: WHEN FND_API.G_EXC_ERROR THEN
360: ROLLBACK TO UPDATE_Ctd_Prm_Val_PVT;
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: -- Standard call to get message count and if count=1, get the message
363: FND_MSG_PUB.Count_And_Get (
364: p_encoded => FND_API.G_FALSE,
365: p_count => x_msg_count,
366: p_data => x_msg_data
368:
369: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
370: ROLLBACK TO UPDATE_Ctd_Prm_Val_PVT;
371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
372: -- Standard call to get message count and if count=1, get the message
373: FND_MSG_PUB.Count_And_Get (
374: p_encoded => FND_API.G_FALSE,
375: p_count => x_msg_count,
376: p_data => x_msg_data
382: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
383: THEN
384: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
385: END IF;
386: -- Standard call to get message count and if count=1, get the message
387: FND_MSG_PUB.Count_And_Get (
388: p_encoded => FND_API.G_FALSE,
389: p_count => x_msg_count,
390: p_data => x_msg_data
409: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
410: l_object_version_number NUMBER;
411:
412: BEGIN
413: -- Standard Start of API savepoint
414: SAVEPOINT DELETE_Ctd_Prm_Val_PVT;
415:
416: -- Standard call to check for call compatibility.
417: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
412: BEGIN
413: -- Standard Start of API savepoint
414: SAVEPOINT DELETE_Ctd_Prm_Val_PVT;
415:
416: -- Standard call to check for call compatibility.
417: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
418: p_api_version_number,
419: l_api_name,
420: G_PKG_NAME)
447: --
448: -- End of API body
449: --
450:
451: -- Standard check for p_commit
452: IF FND_API.to_Boolean( p_commit )
453: THEN
454: COMMIT WORK;
455: END IF;
457:
458: -- Debug Message
459: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
460:
461: -- Standard call to get message count and if count is 1, get message info.
462: FND_MSG_PUB.Count_And_Get
463: (p_count => x_msg_count,
464: p_data => x_msg_data
465: );
471:
472: WHEN FND_API.G_EXC_ERROR THEN
473: ROLLBACK TO DELETE_Ctd_Prm_Val_PVT;
474: x_return_status := FND_API.G_RET_STS_ERROR;
475: -- Standard call to get message count and if count=1, get the message
476: FND_MSG_PUB.Count_And_Get (
477: p_encoded => FND_API.G_FALSE,
478: p_count => x_msg_count,
479: p_data => x_msg_data
481:
482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
483: ROLLBACK TO DELETE_Ctd_Prm_Val_PVT;
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: -- Standard call to get message count and if count=1, get the message
486: FND_MSG_PUB.Count_And_Get (
487: p_encoded => FND_API.G_FALSE,
488: p_count => x_msg_count,
489: p_data => x_msg_data
495: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
496: THEN
497: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
498: END IF;
499: -- Standard call to get message count and if count=1, get the message
500: FND_MSG_PUB.Count_And_Get (
501: p_encoded => FND_API.G_FALSE,
502: p_count => x_msg_count,
503: p_data => x_msg_data
542: THEN
543: FND_MSG_PUB.initialize;
544: END IF;
545:
546: -- Standard call to check for call compatibility.
547: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
548: p_api_version_number,
549: l_api_name,
550: G_PKG_NAME)
589:
590: WHEN FND_API.G_EXC_ERROR THEN
591: ROLLBACK TO LOCK_Ctd_Prm_Val_PVT;
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: -- Standard call to get message count and if count=1, get the message
594: FND_MSG_PUB.Count_And_Get (
595: p_encoded => FND_API.G_FALSE,
596: p_count => x_msg_count,
597: p_data => x_msg_data
599:
600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
601: ROLLBACK TO LOCK_Ctd_Prm_Val_PVT;
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: -- Standard call to get message count and if count=1, get the message
604: FND_MSG_PUB.Count_And_Get (
605: p_encoded => FND_API.G_FALSE,
606: p_count => x_msg_count,
607: p_data => x_msg_data
613: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
614: THEN
615: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
616: END IF;
617: -- Standard call to get message count and if count=1, get the message
618: FND_MSG_PUB.Count_And_Get (
619: p_encoded => FND_API.G_FALSE,
620: p_count => x_msg_count,
621: p_data => x_msg_data
956: l_object_version_number NUMBER;
957: l_ctd_prm_val_rec AMS_Ctd_Prm_Val_PVT.ctd_prm_val_rec_type;
958:
959: BEGIN
960: -- Standard Start of API savepoint
961: SAVEPOINT VALIDATE_Ctd_Prm_Val_;
962:
963: -- Standard call to check for call compatibility.
964: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
959: BEGIN
960: -- Standard Start of API savepoint
961: SAVEPOINT VALIDATE_Ctd_Prm_Val_;
962:
963: -- Standard call to check for call compatibility.
964: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
965: p_api_version_number,
966: l_api_name,
967: G_PKG_NAME)
1020:
1021: -- Debug Message
1022: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1023:
1024: -- Standard call to get message count and if count is 1, get message info.
1025: FND_MSG_PUB.Count_And_Get
1026: (p_count => x_msg_count,
1027: p_data => x_msg_data
1028: );
1034:
1035: WHEN FND_API.G_EXC_ERROR THEN
1036: ROLLBACK TO VALIDATE_Ctd_Prm_Val_;
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: -- Standard call to get message count and if count=1, get the message
1039: FND_MSG_PUB.Count_And_Get (
1040: p_encoded => FND_API.G_FALSE,
1041: p_count => x_msg_count,
1042: p_data => x_msg_data
1044:
1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046: ROLLBACK TO VALIDATE_Ctd_Prm_Val_;
1047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1048: -- Standard call to get message count and if count=1, get the message
1049: FND_MSG_PUB.Count_And_Get (
1050: p_encoded => FND_API.G_FALSE,
1051: p_count => x_msg_count,
1052: p_data => x_msg_data
1058: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1059: THEN
1060: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1061: END IF;
1062: -- Standard call to get message count and if count=1, get the message
1063: FND_MSG_PUB.Count_And_Get (
1064: p_encoded => FND_API.G_FALSE,
1065: p_count => x_msg_count,
1066: p_data => x_msg_data
1093: -- x_return_status := FND_API.G_RET_STS_ERROR;
1094:
1095: -- Debug Message
1096: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1097: -- Standard call to get message count and if count is 1, get message info.
1098: FND_MSG_PUB.Count_And_Get
1099: (p_count => x_msg_count,
1100: p_data => x_msg_data
1101: );