[Home] [Help]
83: FROM AMS_IBA_PL_STYLESHTS_B
84: WHERE STYLESHEET_ID = l_id;
85:
86: BEGIN
87: -- Standard Start of API savepoint
88: SAVEPOINT CREATE_Iba_Pl_Stylesheets_PVT;
89:
90: -- Standard call to check for call compatibility.
91: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
86: BEGIN
87: -- Standard Start of API savepoint
88: SAVEPOINT CREATE_Iba_Pl_Stylesheets_PVT;
89:
90: -- Standard call to check for call compatibility.
91: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
92: p_api_version_number,
93: l_api_name,
94: G_PKG_NAME)
194: --
195: -- End of API body
196: --
197:
198: -- Standard check for p_commit
199: IF FND_API.to_Boolean( p_commit )
200: THEN
201: COMMIT WORK;
202: END IF;
207:
208: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
209: END IF;
210:
211: -- Standard call to get message count and if count is 1, get message info.
212: FND_MSG_PUB.Count_And_Get
213: (p_count => x_msg_count,
214: p_data => x_msg_data
215: );
221:
222: WHEN FND_API.G_EXC_ERROR THEN
223: ROLLBACK TO CREATE_Iba_Pl_Stylesheets_PVT;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: -- Standard call to get message count and if count=1, get the message
226: FND_MSG_PUB.Count_And_Get (
227: p_encoded => FND_API.G_FALSE,
228: p_count => x_msg_count,
229: p_data => x_msg_data
235: AMS_UTILITY_PVT.debug_message( 'Private API: in unexpected error '|| x_return_status);
236: END IF;
237: ROLLBACK TO CREATE_Iba_Pl_Stylesheets_PVT;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: -- Standard call to get message count and if count=1, get the message
240: FND_MSG_PUB.Count_And_Get (
241: p_encoded => FND_API.G_FALSE,
242: p_count => x_msg_count,
243: p_data => x_msg_data
253: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
254: THEN
255: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
256: END IF;
257: -- Standard call to get message count and if count=1, get the message
258: FND_MSG_PUB.Count_And_Get (
259: p_encoded => FND_API.G_FALSE,
260: p_count => x_msg_count,
261: p_data => x_msg_data
293: l_tar_iba_pl_stylesheets_rec AMS_Iba_Pl_Stylesheets_PVT.iba_pl_stylesheets_rec_type := P_iba_pl_stylesheets_rec;
294: l_rowid ROWID;
295:
296: BEGIN
297: -- Standard Start of API savepoint
298: SAVEPOINT UPDATE_Iba_Pl_Stylesheets_PVT;
299:
300: -- Standard call to check for call compatibility.
301: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
296: BEGIN
297: -- Standard Start of API savepoint
298: SAVEPOINT UPDATE_Iba_Pl_Stylesheets_PVT;
299:
300: -- Standard call to check for call compatibility.
301: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
302: p_api_version_number,
303: l_api_name,
304: G_PKG_NAME)
411: --
412: -- End of API body.
413: --
414:
415: -- Standard check for p_commit
416: IF FND_API.to_Boolean( p_commit )
417: THEN
418: COMMIT WORK;
419: END IF;
424:
425: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
426: END IF;
427:
428: -- Standard call to get message count and if count is 1, get message info.
429: FND_MSG_PUB.Count_And_Get
430: (p_count => x_msg_count,
431: p_data => x_msg_data
432: );
438:
439: WHEN FND_API.G_EXC_ERROR THEN
440: ROLLBACK TO UPDATE_Iba_Pl_Stylesheets_PVT;
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: -- Standard call to get message count and if count=1, get the message
443: FND_MSG_PUB.Count_And_Get (
444: p_encoded => FND_API.G_FALSE,
445: p_count => x_msg_count,
446: p_data => x_msg_data
448:
449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
450: ROLLBACK TO UPDATE_Iba_Pl_Stylesheets_PVT;
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
452: -- Standard call to get message count and if count=1, get the message
453: FND_MSG_PUB.Count_And_Get (
454: p_encoded => FND_API.G_FALSE,
455: p_count => x_msg_count,
456: p_data => x_msg_data
462: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
463: THEN
464: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
465: END IF;
466: -- Standard call to get message count and if count=1, get the message
467: FND_MSG_PUB.Count_And_Get (
468: p_encoded => FND_API.G_FALSE,
469: p_count => x_msg_count,
470: p_data => x_msg_data
490: l_object_version_number NUMBER;
491: l_style_placements NUMBER;
492:
493: BEGIN
494: -- Standard Start of API savepoint
495: SAVEPOINT DELETE_Iba_Pl_Stylesheets_PVT;
496:
497: -- Standard call to check for call compatibility.
498: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
493: BEGIN
494: -- Standard Start of API savepoint
495: SAVEPOINT DELETE_Iba_Pl_Stylesheets_PVT;
496:
497: -- Standard call to check for call compatibility.
498: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
499: p_api_version_number,
500: l_api_name,
501: G_PKG_NAME)
552: -- End of API body
553: --
554: END IF;
555:
556: -- Standard check for p_commit
557: IF FND_API.to_Boolean( p_commit )
558: THEN
559: COMMIT WORK;
560: END IF;
565:
566: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
567: END IF;
568:
569: -- Standard call to get message count and if count is 1, get message info.
570: FND_MSG_PUB.Count_And_Get
571: (p_count => x_msg_count,
572: p_data => x_msg_data
573: );
579:
580: WHEN FND_API.G_EXC_ERROR THEN
581: ROLLBACK TO DELETE_Iba_Pl_Stylesheets_PVT;
582: x_return_status := FND_API.G_RET_STS_ERROR;
583: -- Standard call to get message count and if count=1, get the message
584: FND_MSG_PUB.Count_And_Get (
585: p_encoded => FND_API.G_FALSE,
586: p_count => x_msg_count,
587: p_data => x_msg_data
589:
590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
591: ROLLBACK TO DELETE_Iba_Pl_Stylesheets_PVT;
592: x_return_status := FND_API.G_RET_STS_UNEXP_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
603: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
604: THEN
605: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
606: END IF;
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
653: THEN
654: FND_MSG_PUB.initialize;
655: END IF;
656:
657: -- Standard call to check for call compatibility.
658: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
659: p_api_version_number,
660: l_api_name,
661: G_PKG_NAME)
709:
710: WHEN FND_API.G_EXC_ERROR THEN
711: ROLLBACK TO LOCK_Iba_Pl_Stylesheets_PVT;
712: x_return_status := FND_API.G_RET_STS_ERROR;
713: -- Standard call to get message count and if count=1, get the message
714: FND_MSG_PUB.Count_And_Get (
715: p_encoded => FND_API.G_FALSE,
716: p_count => x_msg_count,
717: p_data => x_msg_data
719:
720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
721: ROLLBACK TO LOCK_Iba_Pl_Stylesheets_PVT;
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: -- Standard call to get message count and if count=1, get the message
724: FND_MSG_PUB.Count_And_Get (
725: p_encoded => FND_API.G_FALSE,
726: p_count => x_msg_count,
727: p_data => x_msg_data
733: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
734: THEN
735: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
736: END IF;
737: -- Standard call to get message count and if count=1, get the message
738: FND_MSG_PUB.Count_And_Get (
739: p_encoded => FND_API.G_FALSE,
740: p_count => x_msg_count,
741: p_data => x_msg_data
1102: l_object_version_number NUMBER;
1103: l_iba_pl_stylesheets_rec AMS_Iba_Pl_Stylesheets_PVT.iba_pl_stylesheets_rec_type;
1104:
1105: BEGIN
1106: -- Standard Start of API savepoint
1107: SAVEPOINT VALIDATE_Iba_Pl_Stylesheets_;
1108:
1109: -- Standard call to check for call compatibility.
1110: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1105: BEGIN
1106: -- Standard Start of API savepoint
1107: SAVEPOINT VALIDATE_Iba_Pl_Stylesheets_;
1108:
1109: -- Standard call to check for call compatibility.
1110: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1111: p_api_version_number,
1112: l_api_name,
1113: G_PKG_NAME)
1172:
1173: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1174: END IF;
1175:
1176: -- Standard call to get message count and if count is 1, get message info.
1177: FND_MSG_PUB.Count_And_Get
1178: (p_count => x_msg_count,
1179: p_data => x_msg_data
1180: );
1186:
1187: WHEN FND_API.G_EXC_ERROR THEN
1188: ROLLBACK TO VALIDATE_Iba_Pl_Stylesheets_;
1189: x_return_status := FND_API.G_RET_STS_ERROR;
1190: -- Standard call to get message count and if count=1, get the message
1191: FND_MSG_PUB.Count_And_Get (
1192: p_encoded => FND_API.G_FALSE,
1193: p_count => x_msg_count,
1194: p_data => x_msg_data
1196:
1197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1198: ROLLBACK TO VALIDATE_Iba_Pl_Stylesheets_;
1199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1200: -- Standard call to get message count and if count=1, get the message
1201: FND_MSG_PUB.Count_And_Get (
1202: p_encoded => FND_API.G_FALSE,
1203: p_count => x_msg_count,
1204: p_data => x_msg_data
1210: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1211: THEN
1212: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1213: END IF;
1214: -- Standard call to get message count and if count=1, get the message
1215: FND_MSG_PUB.Count_And_Get (
1216: p_encoded => FND_API.G_FALSE,
1217: p_count => x_msg_count,
1218: p_data => x_msg_data
1248: IF (AMS_DEBUG_HIGH_ON) THEN
1249:
1250: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1251: END IF;
1252: -- Standard call to get message count and if count is 1, get message info.
1253: FND_MSG_PUB.Count_And_Get
1254: (p_count => x_msg_count,
1255: p_data => x_msg_data
1256: );