[Home] [Help]
53: FROM AMS_CTD_ADHOC_PARAM_VALUES
54: WHERE ADHOC_PARAM_ID = l_id;
55:
56: BEGIN
57: -- Standard Start of API savepoint
58: SAVEPOINT CREATE_Adhoc_Param_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_Adhoc_Param_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_Adhoc_Param_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_Adhoc_Param_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_adhoc_param_rec AMS_Adhoc_Param_PVT.adhoc_param_rec_type := P_adhoc_param_rec;
235: l_rowid ROWID;
236:
237: BEGIN
238: -- Standard Start of API savepoint
239: SAVEPOINT UPDATE_Adhoc_Param_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_Adhoc_Param_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_Adhoc_Param_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_Adhoc_Param_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_Adhoc_Param_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_Adhoc_Param_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_Adhoc_Param_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_Adhoc_Param_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_Adhoc_Param_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_Adhoc_Param_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
941: l_object_version_number NUMBER;
942: l_adhoc_param_rec AMS_Adhoc_Param_PVT.adhoc_param_rec_type;
943:
944: BEGIN
945: -- Standard Start of API savepoint
946: SAVEPOINT VALIDATE_Adhoc_Param_;
947:
948: -- Standard call to check for call compatibility.
949: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
944: BEGIN
945: -- Standard Start of API savepoint
946: SAVEPOINT VALIDATE_Adhoc_Param_;
947:
948: -- Standard call to check for call compatibility.
949: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
950: p_api_version_number,
951: l_api_name,
952: G_PKG_NAME)
1005:
1006: -- Debug Message
1007: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1008:
1009: -- Standard call to get message count and if count is 1, get message info.
1010: FND_MSG_PUB.Count_And_Get
1011: (p_count => x_msg_count,
1012: p_data => x_msg_data
1013: );
1019:
1020: WHEN FND_API.G_EXC_ERROR THEN
1021: ROLLBACK TO VALIDATE_Adhoc_Param_;
1022: x_return_status := FND_API.G_RET_STS_ERROR;
1023: -- Standard call to get message count and if count=1, get the message
1024: FND_MSG_PUB.Count_And_Get (
1025: p_encoded => FND_API.G_FALSE,
1026: p_count => x_msg_count,
1027: p_data => x_msg_data
1029:
1030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1031: ROLLBACK TO VALIDATE_Adhoc_Param_;
1032: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1033: -- Standard call to get message count and if count=1, get the message
1034: FND_MSG_PUB.Count_And_Get (
1035: p_encoded => FND_API.G_FALSE,
1036: p_count => x_msg_count,
1037: p_data => x_msg_data
1043: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1044: THEN
1045: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1046: END IF;
1047: -- Standard call to get message count and if count=1, get the message
1048: FND_MSG_PUB.Count_And_Get (
1049: p_encoded => FND_API.G_FALSE,
1050: p_count => x_msg_count,
1051: p_data => x_msg_data
1078: -- x_return_status := FND_API.G_RET_STS_ERROR;
1079:
1080: -- Debug Message
1081: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1082: -- Standard call to get message count and if count is 1, get message info.
1083: FND_MSG_PUB.Count_And_Get
1084: (p_count => x_msg_count,
1085: p_data => x_msg_data
1086: );