[Home] [Help]
53: FROM AMS_PRETTY_URL_ASSOC
54: WHERE ASSOC_ID = l_id;
55:
56: BEGIN
57: -- Standard Start of API savepoint
58: SAVEPOINT CREATE_Prty_Url_Assoc_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_Prty_Url_Assoc_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_Prty_Url_Assoc_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_Prty_Url_Assoc_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_prty_url_assoc_rec AMS_Prty_Url_Assoc_PVT.prty_url_assoc_rec_type := P_prty_url_assoc_rec;
235: l_rowid ROWID;
236:
237: BEGIN
238: -- Standard Start of API savepoint
239: SAVEPOINT UPDATE_Prty_Url_Assoc_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_Prty_Url_Assoc_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)
333: --
334: -- End of API body.
335: --
336:
337: -- Standard check for p_commit
338: IF FND_API.to_Boolean( p_commit )
339: THEN
340: COMMIT WORK;
341: END IF;
343:
344: -- Debug Message
345: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
346:
347: -- Standard call to get message count and if count is 1, get message info.
348: FND_MSG_PUB.Count_And_Get
349: (p_count => x_msg_count,
350: p_data => x_msg_data
351: );
357:
358: WHEN FND_API.G_EXC_ERROR THEN
359: ROLLBACK TO UPDATE_Prty_Url_Assoc_PVT;
360: x_return_status := FND_API.G_RET_STS_ERROR;
361: -- Standard call to get message count and if count=1, get the message
362: FND_MSG_PUB.Count_And_Get (
363: p_encoded => FND_API.G_FALSE,
364: p_count => x_msg_count,
365: p_data => x_msg_data
367:
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369: ROLLBACK TO UPDATE_Prty_Url_Assoc_PVT;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
371: -- Standard call to get message count and if count=1, get the message
372: FND_MSG_PUB.Count_And_Get (
373: p_encoded => FND_API.G_FALSE,
374: p_count => x_msg_count,
375: p_data => x_msg_data
381: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
382: THEN
383: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
384: END IF;
385: -- Standard call to get message count and if count=1, get the message
386: FND_MSG_PUB.Count_And_Get (
387: p_encoded => FND_API.G_FALSE,
388: p_count => x_msg_count,
389: p_data => x_msg_data
408: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
409: l_object_version_number NUMBER;
410:
411: BEGIN
412: -- Standard Start of API savepoint
413: SAVEPOINT DELETE_Prty_Url_Assoc_PVT;
414:
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
411: BEGIN
412: -- Standard Start of API savepoint
413: SAVEPOINT DELETE_Prty_Url_Assoc_PVT;
414:
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
417: p_api_version_number,
418: l_api_name,
419: G_PKG_NAME)
446: --
447: -- End of API body
448: --
449:
450: -- Standard check for p_commit
451: IF FND_API.to_Boolean( p_commit )
452: THEN
453: COMMIT WORK;
454: END IF;
456:
457: -- Debug Message
458: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
459:
460: -- Standard call to get message count and if count is 1, get message info.
461: FND_MSG_PUB.Count_And_Get
462: (p_count => x_msg_count,
463: p_data => x_msg_data
464: );
470:
471: WHEN FND_API.G_EXC_ERROR THEN
472: ROLLBACK TO DELETE_Prty_Url_Assoc_PVT;
473: x_return_status := FND_API.G_RET_STS_ERROR;
474: -- Standard call to get message count and if count=1, get the message
475: FND_MSG_PUB.Count_And_Get (
476: p_encoded => FND_API.G_FALSE,
477: p_count => x_msg_count,
478: p_data => x_msg_data
480:
481: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
482: ROLLBACK TO DELETE_Prty_Url_Assoc_PVT;
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: -- Standard call to get message count and if count=1, get the message
485: FND_MSG_PUB.Count_And_Get (
486: p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data
494: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
495: THEN
496: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
497: END IF;
498: -- Standard call to get message count and if count=1, get the message
499: FND_MSG_PUB.Count_And_Get (
500: p_encoded => FND_API.G_FALSE,
501: p_count => x_msg_count,
502: p_data => x_msg_data
541: THEN
542: FND_MSG_PUB.initialize;
543: END IF;
544:
545: -- Standard call to check for call compatibility.
546: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
547: p_api_version_number,
548: l_api_name,
549: G_PKG_NAME)
588:
589: WHEN FND_API.G_EXC_ERROR THEN
590: ROLLBACK TO LOCK_Prty_Url_Assoc_PVT;
591: x_return_status := FND_API.G_RET_STS_ERROR;
592: -- Standard call to get message count and if count=1, get the message
593: FND_MSG_PUB.Count_And_Get (
594: p_encoded => FND_API.G_FALSE,
595: p_count => x_msg_count,
596: p_data => x_msg_data
598:
599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
600: ROLLBACK TO LOCK_Prty_Url_Assoc_PVT;
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: -- Standard call to get message count and if count=1, get the message
603: FND_MSG_PUB.Count_And_Get (
604: p_encoded => FND_API.G_FALSE,
605: p_count => x_msg_count,
606: p_data => x_msg_data
612: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
613: THEN
614: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
615: END IF;
616: -- Standard call to get message count and if count=1, get the message
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
620: p_data => x_msg_data
935: l_object_version_number NUMBER;
936: l_prty_url_assoc_rec AMS_Prty_Url_Assoc_PVT.prty_url_assoc_rec_type;
937:
938: BEGIN
939: -- Standard Start of API savepoint
940: SAVEPOINT VALIDATE_Prty_Url_Assoc_;
941:
942: -- Standard call to check for call compatibility.
943: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
938: BEGIN
939: -- Standard Start of API savepoint
940: SAVEPOINT VALIDATE_Prty_Url_Assoc_;
941:
942: -- Standard call to check for call compatibility.
943: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
944: p_api_version_number,
945: l_api_name,
946: G_PKG_NAME)
999:
1000: -- Debug Message
1001: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1002:
1003: -- Standard call to get message count and if count is 1, get message info.
1004: FND_MSG_PUB.Count_And_Get
1005: (p_count => x_msg_count,
1006: p_data => x_msg_data
1007: );
1013:
1014: WHEN FND_API.G_EXC_ERROR THEN
1015: ROLLBACK TO VALIDATE_Prty_Url_Assoc_;
1016: x_return_status := FND_API.G_RET_STS_ERROR;
1017: -- Standard call to get message count and if count=1, get the message
1018: FND_MSG_PUB.Count_And_Get (
1019: p_encoded => FND_API.G_FALSE,
1020: p_count => x_msg_count,
1021: p_data => x_msg_data
1023:
1024: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1025: ROLLBACK TO VALIDATE_Prty_Url_Assoc_;
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1027: -- Standard call to get message count and if count=1, get the message
1028: FND_MSG_PUB.Count_And_Get (
1029: p_encoded => FND_API.G_FALSE,
1030: p_count => x_msg_count,
1031: p_data => x_msg_data
1037: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1038: THEN
1039: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1040: END IF;
1041: -- Standard call to get message count and if count=1, get the message
1042: FND_MSG_PUB.Count_And_Get (
1043: p_encoded => FND_API.G_FALSE,
1044: p_count => x_msg_count,
1045: p_data => x_msg_data
1072: -- x_return_status := FND_API.G_RET_STS_ERROR;
1073:
1074: -- Debug Message
1075: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1076: -- Standard call to get message count and if count is 1, get message info.
1077: FND_MSG_PUB.Count_And_Get
1078: (p_count => x_msg_count,
1079: p_data => x_msg_data
1080: );