[Home] [Help]
58: WHERE EXISTS (SELECT 1 FROM AMS_CAT_ACTIVITIES
59: WHERE CAT_ACTIVITY_ID = l_id);
60:
61: BEGIN
62: -- Standard Start of API savepoint
63: SAVEPOINT CREATE_Cat_Activity_PVT;
64:
65: -- Standard call to check for call compatibility.
66: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
61: BEGIN
62: -- Standard Start of API savepoint
63: SAVEPOINT CREATE_Cat_Activity_PVT;
64:
65: -- Standard call to check for call compatibility.
66: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
67: p_api_version_number,
68: l_api_name,
69: G_PKG_NAME)
183: --
184: -- End of API body
185: --
186:
187: -- Standard check for p_commit
188: IF FND_API.to_Boolean( p_commit )
189: THEN
190: COMMIT WORK;
191: END IF;
196:
197: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
198: END IF;
199:
200: -- Standard call to get message count and if count is 1, get message info.
201: FND_MSG_PUB.Count_And_Get
202: (p_count => x_msg_count,
203: p_data => x_msg_data
204: );
210:
211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO CREATE_Cat_Activity_PVT;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: -- Standard call to get message count and if count=1, get the message
215: FND_MSG_PUB.Count_And_Get (
216: p_encoded => FND_API.G_FALSE,
217: p_count => x_msg_count,
218: p_data => x_msg_data
220:
221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
222: ROLLBACK TO CREATE_Cat_Activity_PVT;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: -- Standard call to get message count and if count=1, get the message
225: FND_MSG_PUB.Count_And_Get (
226: p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,
228: p_data => x_msg_data
234: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message
239: FND_MSG_PUB.Count_And_Get (
240: p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count,
242: p_data => x_msg_data
276: l_tar_cat_activity_rec AMS_Cat_Activity_PVT.cat_activity_rec_type := P_cat_activity_rec;
277: l_rowid ROWID;
278:
279: BEGIN
280: -- Standard Start of API savepoint
281: SAVEPOINT UPDATE_Cat_Activity_PVT;
282:
283: -- Standard call to check for call compatibility.
284: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
279: BEGIN
280: -- Standard Start of API savepoint
281: SAVEPOINT UPDATE_Cat_Activity_PVT;
282:
283: -- Standard call to check for call compatibility.
284: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
285: p_api_version_number,
286: l_api_name,
287: G_PKG_NAME)
396: --
397: -- End of API body.
398: --
399:
400: -- Standard check for p_commit
401: IF FND_API.to_Boolean( p_commit )
402: THEN
403: COMMIT WORK;
404: END IF;
409:
410: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
411: END IF;
412:
413: -- Standard call to get message count and if count is 1, get message info.
414: FND_MSG_PUB.Count_And_Get
415: (p_count => x_msg_count,
416: p_data => x_msg_data
417: );
423:
424: WHEN FND_API.G_EXC_ERROR THEN
425: ROLLBACK TO UPDATE_Cat_Activity_PVT;
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: -- Standard call to get message count and if count=1, get the message
428: FND_MSG_PUB.Count_And_Get (
429: p_encoded => FND_API.G_FALSE,
430: p_count => x_msg_count,
431: p_data => x_msg_data
433:
434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435: ROLLBACK TO UPDATE_Cat_Activity_PVT;
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437: -- Standard call to get message count and if count=1, get the message
438: FND_MSG_PUB.Count_And_Get (
439: p_encoded => FND_API.G_FALSE,
440: p_count => x_msg_count,
441: p_data => x_msg_data
447: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
448: THEN
449: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
450: END IF;
451: -- Standard call to get message count and if count=1, get the message
452: FND_MSG_PUB.Count_And_Get (
453: p_encoded => FND_API.G_FALSE,
454: p_count => x_msg_count,
455: p_data => x_msg_data
474: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
475: l_object_version_number NUMBER;
476:
477: BEGIN
478: -- Standard Start of API savepoint
479: SAVEPOINT DELETE_Cat_Activity_PVT;
480:
481: -- Standard call to check for call compatibility.
482: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
477: BEGIN
478: -- Standard Start of API savepoint
479: SAVEPOINT DELETE_Cat_Activity_PVT;
480:
481: -- Standard call to check for call compatibility.
482: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
483: p_api_version_number,
484: l_api_name,
485: G_PKG_NAME)
519: --
520: -- End of API body
521: --
522:
523: -- Standard check for p_commit
524: IF FND_API.to_Boolean( p_commit )
525: THEN
526: COMMIT WORK;
527: END IF;
532:
533: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
534: END IF;
535:
536: -- Standard call to get message count and if count is 1, get message info.
537: FND_MSG_PUB.Count_And_Get
538: (p_count => x_msg_count,
539: p_data => x_msg_data
540: );
546:
547: WHEN FND_API.G_EXC_ERROR THEN
548: ROLLBACK TO DELETE_Cat_Activity_PVT;
549: x_return_status := FND_API.G_RET_STS_ERROR;
550: -- Standard call to get message count and if count=1, get the message
551: FND_MSG_PUB.Count_And_Get (
552: p_encoded => FND_API.G_FALSE,
553: p_count => x_msg_count,
554: p_data => x_msg_data
556:
557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
558: ROLLBACK TO DELETE_Cat_Activity_PVT;
559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560: -- Standard call to get message count and if count=1, get the message
561: FND_MSG_PUB.Count_And_Get (
562: p_encoded => FND_API.G_FALSE,
563: p_count => x_msg_count,
564: p_data => x_msg_data
570: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
573: END IF;
574: -- Standard call to get message count and if count=1, get the message
575: FND_MSG_PUB.Count_And_Get (
576: p_encoded => FND_API.G_FALSE,
577: p_count => x_msg_count,
578: p_data => x_msg_data
620: THEN
621: FND_MSG_PUB.initialize;
622: END IF;
623:
624: -- Standard call to check for call compatibility.
625: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
626: p_api_version_number,
627: l_api_name,
628: G_PKG_NAME)
676:
677: WHEN FND_API.G_EXC_ERROR THEN
678: ROLLBACK TO LOCK_Cat_Activity_PVT;
679: x_return_status := FND_API.G_RET_STS_ERROR;
680: -- Standard call to get message count and if count=1, get the message
681: FND_MSG_PUB.Count_And_Get (
682: p_encoded => FND_API.G_FALSE,
683: p_count => x_msg_count,
684: p_data => x_msg_data
686:
687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
688: ROLLBACK TO LOCK_Cat_Activity_PVT;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: -- Standard call to get message count and if count=1, get the message
691: FND_MSG_PUB.Count_And_Get (
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data
700: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
701: THEN
702: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
703: END IF;
704: -- Standard call to get message count and if count=1, get the message
705: FND_MSG_PUB.Count_And_Get (
706: p_encoded => FND_API.G_FALSE,
707: p_count => x_msg_count,
708: p_data => x_msg_data
995: l_object_version_number NUMBER;
996: l_cat_activity_rec AMS_Cat_Activity_PVT.cat_activity_rec_type;
997:
998: BEGIN
999: -- Standard Start of API savepoint
1000: SAVEPOINT VALIDATE_Cat_Activity_;
1001:
1002: IF (AMS_DEBUG_HIGH_ON) THEN
1003:
1006: AMS_UTILITY_PVT.debug_message(' INside Validate API ');
1007:
1008: END IF;
1009:
1010: -- Standard call to check for call compatibility.
1011: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1012: p_api_version_number,
1013: l_api_name,
1014: G_PKG_NAME)
1074:
1075: AMS_UTILITY_PVT.debug_message('Private API: end of validate');
1076: END IF;
1077:
1078: -- Standard call to get message count and if count is 1, get message info.
1079: FND_MSG_PUB.Count_And_Get
1080: (p_count => x_msg_count,
1081: p_data => x_msg_data
1082: );
1088:
1089: WHEN FND_API.G_EXC_ERROR THEN
1090: ROLLBACK TO VALIDATE_Cat_Activity_;
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092: -- Standard call to get message count and if count=1, get the message
1093: FND_MSG_PUB.Count_And_Get (
1094: p_encoded => FND_API.G_FALSE,
1095: p_count => x_msg_count,
1096: p_data => x_msg_data
1098:
1099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1100: ROLLBACK TO VALIDATE_Cat_Activity_;
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1102: -- Standard call to get message count and if count=1, get the message
1103: FND_MSG_PUB.Count_And_Get (
1104: p_encoded => FND_API.G_FALSE,
1105: p_count => x_msg_count,
1106: p_data => x_msg_data
1112: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1113: THEN
1114: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1115: END IF;
1116: -- Standard call to get message count and if count=1, get the message
1117: FND_MSG_PUB.Count_And_Get (
1118: p_encoded => FND_API.G_FALSE,
1119: p_count => x_msg_count,
1120: p_data => x_msg_data
1150: IF (AMS_DEBUG_HIGH_ON) THEN
1151:
1152: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1153: END IF;
1154: -- Standard call to get message count and if count is 1, get message info.
1155: FND_MSG_PUB.Count_And_Get
1156: (p_count => x_msg_count,
1157: p_data => x_msg_data
1158: );