[Home] [Help]
53: FROM AMS_SYSTEM_PRETTY_URL
54: WHERE SYSTEM_URL_ID = l_id;
55:
56: BEGIN
57: -- Standard Start of API savepoint
58: SAVEPOINT CREATE_System_Pretty_Url_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_System_Pretty_Url_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)
151: --
152: -- End of API body
153: --
154:
155: -- Standard check for p_commit
156: IF FND_API.to_Boolean( p_commit )
157: THEN
158: COMMIT WORK;
159: END IF;
161:
162: -- Debug Message
163: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
164:
165: -- Standard call to get message count and if count is 1, get message info.
166: FND_MSG_PUB.Count_And_Get
167: (p_count => x_msg_count,
168: p_data => x_msg_data
169: );
175:
176: WHEN FND_API.G_EXC_ERROR THEN
177: ROLLBACK TO CREATE_System_Pretty_Url_PVT;
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: -- Standard call to get message count and if count=1, get the message
180: FND_MSG_PUB.Count_And_Get (
181: p_encoded => FND_API.G_FALSE,
182: p_count => x_msg_count,
183: p_data => x_msg_data
185:
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: ROLLBACK TO CREATE_System_Pretty_Url_PVT;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: -- Standard call to get message count and if count=1, get the message
190: FND_MSG_PUB.Count_And_Get (
191: p_encoded => FND_API.G_FALSE,
192: p_count => x_msg_count,
193: p_data => x_msg_data
199: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
200: THEN
201: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
202: END IF;
203: -- Standard call to get message count and if count=1, get the message
204: FND_MSG_PUB.Count_And_Get (
205: p_encoded => FND_API.G_FALSE,
206: p_count => x_msg_count,
207: p_data => x_msg_data
237: l_tar_system_pretty_url_rec AMS_System_Pretty_Url_PVT.system_pretty_url_rec_type := P_system_pretty_url_rec;
238: l_rowid ROWID;
239:
240: BEGIN
241: -- Standard Start of API savepoint
242: SAVEPOINT UPDATE_System_Pretty_Url_PVT;
243:
244: -- Standard call to check for call compatibility.
245: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
240: BEGIN
241: -- Standard Start of API savepoint
242: SAVEPOINT UPDATE_System_Pretty_Url_PVT;
243:
244: -- Standard call to check for call compatibility.
245: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
246: p_api_version_number,
247: l_api_name,
248: G_PKG_NAME)
338: --
339: -- End of API body.
340: --
341:
342: -- Standard check for p_commit
343: IF FND_API.to_Boolean( p_commit )
344: THEN
345: COMMIT WORK;
346: END IF;
348:
349: -- Debug Message
350: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
351:
352: -- Standard call to get message count and if count is 1, get message info.
353: FND_MSG_PUB.Count_And_Get
354: (p_count => x_msg_count,
355: p_data => x_msg_data
356: );
362:
363: WHEN FND_API.G_EXC_ERROR THEN
364: ROLLBACK TO UPDATE_System_Pretty_Url_PVT;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: -- Standard call to get message count and if count=1, get the message
367: FND_MSG_PUB.Count_And_Get (
368: p_encoded => FND_API.G_FALSE,
369: p_count => x_msg_count,
370: p_data => x_msg_data
372:
373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
374: ROLLBACK TO UPDATE_System_Pretty_Url_PVT;
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: -- Standard call to get message count and if count=1, get the message
377: FND_MSG_PUB.Count_And_Get (
378: p_encoded => FND_API.G_FALSE,
379: p_count => x_msg_count,
380: p_data => x_msg_data
386: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
387: THEN
388: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
389: END IF;
390: -- Standard call to get message count and if count=1, get the message
391: FND_MSG_PUB.Count_And_Get (
392: p_encoded => FND_API.G_FALSE,
393: p_count => x_msg_count,
394: p_data => x_msg_data
413: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
414: l_object_version_number NUMBER;
415:
416: BEGIN
417: -- Standard Start of API savepoint
418: SAVEPOINT DELETE_System_Pretty_Url_PVT;
419:
420: -- Standard call to check for call compatibility.
421: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
416: BEGIN
417: -- Standard Start of API savepoint
418: SAVEPOINT DELETE_System_Pretty_Url_PVT;
419:
420: -- Standard call to check for call compatibility.
421: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
422: p_api_version_number,
423: l_api_name,
424: G_PKG_NAME)
451: --
452: -- End of API body
453: --
454:
455: -- Standard check for p_commit
456: IF FND_API.to_Boolean( p_commit )
457: THEN
458: COMMIT WORK;
459: END IF;
461:
462: -- Debug Message
463: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
464:
465: -- Standard call to get message count and if count is 1, get message info.
466: FND_MSG_PUB.Count_And_Get
467: (p_count => x_msg_count,
468: p_data => x_msg_data
469: );
475:
476: WHEN FND_API.G_EXC_ERROR THEN
477: ROLLBACK TO DELETE_System_Pretty_Url_PVT;
478: x_return_status := FND_API.G_RET_STS_ERROR;
479: -- Standard call to get message count and if count=1, get the message
480: FND_MSG_PUB.Count_And_Get (
481: p_encoded => FND_API.G_FALSE,
482: p_count => x_msg_count,
483: p_data => x_msg_data
485:
486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
487: ROLLBACK TO DELETE_System_Pretty_Url_PVT;
488: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
489: -- Standard call to get message count and if count=1, get the message
490: FND_MSG_PUB.Count_And_Get (
491: p_encoded => FND_API.G_FALSE,
492: p_count => x_msg_count,
493: p_data => x_msg_data
499: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
502: END IF;
503: -- Standard call to get message count and if count=1, get the message
504: FND_MSG_PUB.Count_And_Get (
505: p_encoded => FND_API.G_FALSE,
506: p_count => x_msg_count,
507: p_data => x_msg_data
546: THEN
547: FND_MSG_PUB.initialize;
548: END IF;
549:
550: -- Standard call to check for call compatibility.
551: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
552: p_api_version_number,
553: l_api_name,
554: G_PKG_NAME)
593:
594: WHEN FND_API.G_EXC_ERROR THEN
595: ROLLBACK TO LOCK_System_Pretty_Url_PVT;
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: -- Standard call to get message count and if count=1, get the message
598: FND_MSG_PUB.Count_And_Get (
599: p_encoded => FND_API.G_FALSE,
600: p_count => x_msg_count,
601: p_data => x_msg_data
603:
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: ROLLBACK TO LOCK_System_Pretty_Url_PVT;
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
607: -- Standard call to get message count and if count=1, get the message
608: FND_MSG_PUB.Count_And_Get (
609: p_encoded => FND_API.G_FALSE,
610: p_count => x_msg_count,
611: p_data => x_msg_data
617: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
618: THEN
619: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
620: END IF;
621: -- Standard call to get message count and if count=1, get the message
622: FND_MSG_PUB.Count_And_Get (
623: p_encoded => FND_API.G_FALSE,
624: p_count => x_msg_count,
625: p_data => x_msg_data
937: l_object_version_number NUMBER;
938: l_system_pretty_url_rec AMS_System_Pretty_Url_PVT.system_pretty_url_rec_type;
939:
940: BEGIN
941: -- Standard Start of API savepoint
942: SAVEPOINT VALIDATE_System_Pretty_Url_;
943:
944: -- Standard call to check for call compatibility.
945: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
940: BEGIN
941: -- Standard Start of API savepoint
942: SAVEPOINT VALIDATE_System_Pretty_Url_;
943:
944: -- Standard call to check for call compatibility.
945: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
946: p_api_version_number,
947: l_api_name,
948: G_PKG_NAME)
1001:
1002: -- Debug Message
1003: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1004:
1005: -- Standard call to get message count and if count is 1, get message info.
1006: FND_MSG_PUB.Count_And_Get
1007: (p_count => x_msg_count,
1008: p_data => x_msg_data
1009: );
1015:
1016: WHEN FND_API.G_EXC_ERROR THEN
1017: ROLLBACK TO VALIDATE_System_Pretty_Url_;
1018: x_return_status := FND_API.G_RET_STS_ERROR;
1019: -- Standard call to get message count and if count=1, get the message
1020: FND_MSG_PUB.Count_And_Get (
1021: p_encoded => FND_API.G_FALSE,
1022: p_count => x_msg_count,
1023: p_data => x_msg_data
1025:
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027: ROLLBACK TO VALIDATE_System_Pretty_Url_;
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: -- Standard call to get message count and if count=1, get the message
1030: FND_MSG_PUB.Count_And_Get (
1031: p_encoded => FND_API.G_FALSE,
1032: p_count => x_msg_count,
1033: p_data => x_msg_data
1039: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1040: THEN
1041: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1042: END IF;
1043: -- Standard call to get message count and if count=1, get the message
1044: FND_MSG_PUB.Count_And_Get (
1045: p_encoded => FND_API.G_FALSE,
1046: p_count => x_msg_count,
1047: p_data => x_msg_data
1074: -- x_return_status := FND_API.G_RET_STS_ERROR;
1075:
1076: -- Debug Message
1077: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
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: );