[Home] [Help]
78: FROM AMS_CONTENT_RULES_B
79: WHERE CONTENT_RULE_ID = l_id;
80:
81: BEGIN
82: -- Standard Start of API savepoint
83: SAVEPOINT CREATE_Ct_Rule_PVT;
84:
85: -- Standard call to check for call compatibility.
86: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
81: BEGIN
82: -- Standard Start of API savepoint
83: SAVEPOINT CREATE_Ct_Rule_PVT;
84:
85: -- Standard call to check for call compatibility.
86: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
87: p_api_version_number,
88: l_api_name,
89: G_PKG_NAME)
192: --
193: -- End of API body
194: --
195:
196: -- Standard check for p_commit
197: IF FND_API.to_Boolean( p_commit )
198: THEN
199: COMMIT WORK;
200: END IF;
205:
206: AMS_UTILITY_PVT.debug_message(G_PKG_NAME||' Private API: ' || l_api_name || 'end');
207: END IF;
208:
209: -- Standard call to get message count and if count is 1, get message info.
210: FND_MSG_PUB.Count_And_Get
211: (p_count => x_msg_count,
212: p_data => x_msg_data
213: );
219:
220: WHEN FND_API.G_EXC_ERROR THEN
221: ROLLBACK TO CREATE_Ct_Rule_PVT;
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: -- Standard call to get message count and if count=1, get the message
224: FND_MSG_PUB.Count_And_Get (
225: p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count,
227: p_data => x_msg_data
229:
230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
231: ROLLBACK TO CREATE_Ct_Rule_PVT;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: -- Standard call to get message count and if count=1, get the message
234: FND_MSG_PUB.Count_And_Get (
235: p_encoded => FND_API.G_FALSE,
236: p_count => x_msg_count,
237: p_data => x_msg_data
243: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
244: THEN
245: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
246: END IF;
247: -- Standard call to get message count and if count=1, get the message
248: FND_MSG_PUB.Count_And_Get (
249: p_encoded => FND_API.G_FALSE,
250: p_count => x_msg_count,
251: p_data => x_msg_data
298: l_tar_ct_rule_rec AMS_Ct_Rule_PVT.ct_rule_rec_type := P_ct_rule_rec;
299: l_rowid ROWID;
300:
301: BEGIN
302: -- Standard Start of API savepoint
303: SAVEPOINT UPDATE_Ct_Rule_PVT;
304:
305: -- Standard call to check for call compatibility.
306: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
301: BEGIN
302: -- Standard Start of API savepoint
303: SAVEPOINT UPDATE_Ct_Rule_PVT;
304:
305: -- Standard call to check for call compatibility.
306: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
307: p_api_version_number,
308: l_api_name,
309: G_PKG_NAME)
427: --
428: -- End of API body.
429: --
430:
431: -- Standard check for p_commit
432: IF FND_API.to_Boolean( p_commit )
433: THEN
434: COMMIT WORK;
435: END IF;
440:
441: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
442: END IF;
443:
444: -- Standard call to get message count and if count is 1, get message info.
445: FND_MSG_PUB.Count_And_Get
446: (p_count => x_msg_count,
447: p_data => x_msg_data
448: );
454:
455: WHEN FND_API.G_EXC_ERROR THEN
456: ROLLBACK TO UPDATE_Ct_Rule_PVT;
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: -- Standard call to get message count and if count=1, get the message
459: FND_MSG_PUB.Count_And_Get (
460: p_encoded => FND_API.G_FALSE,
461: p_count => x_msg_count,
462: p_data => x_msg_data
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: ROLLBACK TO UPDATE_Ct_Rule_PVT;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: -- Standard call to get message count and if count=1, get the message
469: FND_MSG_PUB.Count_And_Get (
470: p_encoded => FND_API.G_FALSE,
471: p_count => x_msg_count,
472: p_data => x_msg_data
478: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
479: THEN
480: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
481: END IF;
482: -- Standard call to get message count and if count=1, get the message
483: FND_MSG_PUB.Count_And_Get (
484: p_encoded => FND_API.G_FALSE,
485: p_count => x_msg_count,
486: p_data => x_msg_data
519: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
520: l_object_version_number NUMBER;
521:
522: BEGIN
523: -- Standard Start of API savepoint
524: SAVEPOINT DELETE_Ct_Rule_PVT;
525:
526: -- Standard call to check for call compatibility.
527: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
522: BEGIN
523: -- Standard Start of API savepoint
524: SAVEPOINT DELETE_Ct_Rule_PVT;
525:
526: -- Standard call to check for call compatibility.
527: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
528: p_api_version_number,
529: l_api_name,
530: G_PKG_NAME)
563: --
564: -- End of API body
565: --
566:
567: -- Standard check for p_commit
568: IF FND_API.to_Boolean( p_commit )
569: THEN
570: COMMIT WORK;
571: END IF;
576:
577: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
578: END IF;
579:
580: -- Standard call to get message count and if count is 1, get message info.
581: FND_MSG_PUB.Count_And_Get
582: (p_count => x_msg_count,
583: p_data => x_msg_data
584: );
590:
591: WHEN FND_API.G_EXC_ERROR THEN
592: ROLLBACK TO DELETE_Ct_Rule_PVT;
593: x_return_status := FND_API.G_RET_STS_ERROR;
594: -- Standard call to get message count and if count=1, get the message
595: FND_MSG_PUB.Count_And_Get (
596: p_encoded => FND_API.G_FALSE,
597: p_count => x_msg_count,
598: p_data => x_msg_data
600:
601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
602: ROLLBACK TO DELETE_Ct_Rule_PVT;
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: -- Standard call to get message count and if count=1, get the message
605: FND_MSG_PUB.Count_And_Get (
606: p_encoded => FND_API.G_FALSE,
607: p_count => x_msg_count,
608: p_data => x_msg_data
614: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
615: THEN
616: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
617: END IF;
618: -- Standard call to get message count and if count=1, get the message
619: FND_MSG_PUB.Count_And_Get (
620: p_encoded => FND_API.G_FALSE,
621: p_count => x_msg_count,
622: p_data => x_msg_data
677: THEN
678: FND_MSG_PUB.initialize;
679: END IF;
680:
681: -- Standard call to check for call compatibility.
682: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
683: p_api_version_number,
684: l_api_name,
685: G_PKG_NAME)
733:
734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO LOCK_Ct_Rule_PVT;
736: x_return_status := FND_API.G_RET_STS_ERROR;
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
743:
744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745: ROLLBACK TO LOCK_Ct_Rule_PVT;
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
747: -- Standard call to get message count and if count=1, get the message
748: FND_MSG_PUB.Count_And_Get (
749: p_encoded => FND_API.G_FALSE,
750: p_count => x_msg_count,
751: p_data => x_msg_data
757: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
758: THEN
759: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
760: END IF;
761: -- Standard call to get message count and if count=1, get the message
762: FND_MSG_PUB.Count_And_Get (
763: p_encoded => FND_API.G_FALSE,
764: p_count => x_msg_count,
765: p_data => x_msg_data
1281: l_object_version_number NUMBER;
1282: l_ct_rule_rec AMS_Ct_Rule_PVT.ct_rule_rec_type;
1283:
1284: BEGIN
1285: -- Standard Start of API savepoint
1286: SAVEPOINT VALIDATE_Ct_Rule_;
1287:
1288: -- Standard call to check for call compatibility.
1289: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1284: BEGIN
1285: -- Standard Start of API savepoint
1286: SAVEPOINT VALIDATE_Ct_Rule_;
1287:
1288: -- Standard call to check for call compatibility.
1289: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1290: p_api_version_number,
1291: l_api_name,
1292: G_PKG_NAME)
1351:
1352: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1353: END IF;
1354:
1355: -- Standard call to get message count and if count is 1, get message info.
1356: FND_MSG_PUB.Count_And_Get
1357: (p_count => x_msg_count,
1358: p_data => x_msg_data
1359: );
1365:
1366: WHEN FND_API.G_EXC_ERROR THEN
1367: ROLLBACK TO VALIDATE_Ct_Rule_;
1368: x_return_status := FND_API.G_RET_STS_ERROR;
1369: -- Standard call to get message count and if count=1, get the message
1370: FND_MSG_PUB.Count_And_Get (
1371: p_encoded => FND_API.G_FALSE,
1372: p_count => x_msg_count,
1373: p_data => x_msg_data
1375:
1376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1377: ROLLBACK TO VALIDATE_Ct_Rule_;
1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1379: -- Standard call to get message count and if count=1, get the message
1380: FND_MSG_PUB.Count_And_Get (
1381: p_encoded => FND_API.G_FALSE,
1382: p_count => x_msg_count,
1383: p_data => x_msg_data
1389: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1390: THEN
1391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1392: END IF;
1393: -- Standard call to get message count and if count=1, get the message
1394: FND_MSG_PUB.Count_And_Get (
1395: p_encoded => FND_API.G_FALSE,
1396: p_count => x_msg_count,
1397: p_data => x_msg_data
1440: IF (AMS_DEBUG_HIGH_ON) THEN
1441:
1442: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1443: END IF;
1444: -- Standard call to get message count and if count is 1, get message info.
1445: FND_MSG_PUB.Count_And_Get
1446: (p_count => x_msg_count,
1447: p_data => x_msg_data
1448: );