[Home] [Help]
64: IF (AMS_DEBUG_HIGH_ON) THEN
65:
66: AMS_UTILITY_PVT.debug_message('Inside Procedure Create_cnt_point');
67: END IF;
68: -- Standard Start of API savepoint
69: SAVEPOINT CREATE_Cnt_Point_PVT;
70: IF (AMS_DEBUG_HIGH_ON) THEN
71:
72: AMS_UTILITY_PVT.debug_message('Save point : CREATE_Cnt_Point_PVT created');
75:
76: AMS_UTILITY_PVT.debug_message('Save point : CREATE_Cnt_Point_PVT created');
77: END IF;
78:
79: -- Standard call to check for call compatibility.
80: IF NOT FND_API.Compatible_API_Call ( L_API_VERSION_NUMBER,
81: p_api_version_number,
82: l_api_name,
83: G_PKG_NAME)
213: --
214: -- End of API body
215: --
216:
217: -- Standard check for p_commit
218: IF FND_API.to_Boolean( p_commit )
219: THEN
220: COMMIT WORK;
221: END IF;
226:
227: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
228: END IF;
229:
230: -- Standard call to get message count and if count is 1, get message info.
231: FND_MSG_PUB.Count_And_Get
232: (p_count => x_msg_count,
233: p_data => x_msg_data
234: );
240:
241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK TO CREATE_Cnt_Point_PVT;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: -- Standard call to get message count and if count=1, get the message
245: FND_MSG_PUB.Count_And_Get (
246: p_encoded => FND_API.G_FALSE,
247: p_count => x_msg_count,
248: p_data => x_msg_data
250:
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: ROLLBACK TO CREATE_Cnt_Point_PVT;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: -- Standard call to get message count and if count=1, get the message
255: FND_MSG_PUB.Count_And_Get (
256: p_encoded => FND_API.G_FALSE,
257: p_count => x_msg_count,
258: p_data => x_msg_data
264: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
265: THEN
266: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
267: END IF;
268: -- Standard call to get message count and if count=1, get the message
269: FND_MSG_PUB.Count_And_Get (
270: p_encoded => FND_API.G_FALSE,
271: p_count => x_msg_count,
272: p_data => x_msg_data
310: IF (AMS_DEBUG_HIGH_ON) THEN
311:
312: AMS_UTILITY_PVT.debug_message('Inside Update_cnt_point');
313: END IF;
314: -- Standard Start of API savepoint
315: SAVEPOINT UPDATE_Cnt_Point_PVT;
316:
317: -- Standard call to check for call compatibility.
318: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
313: END IF;
314: -- Standard Start of API savepoint
315: SAVEPOINT UPDATE_Cnt_Point_PVT;
316:
317: -- Standard call to check for call compatibility.
318: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
319: p_api_version_number,
320: l_api_name,
321: G_PKG_NAME)
445: --
446: -- End of API body.
447: --
448:
449: -- Standard check for p_commit
450: IF FND_API.to_Boolean( p_commit )
451: THEN
452: COMMIT WORK;
453: END IF;
458:
459: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
460: END IF;
461:
462: -- Standard call to get message count and if count is 1, get message info.
463: FND_MSG_PUB.Count_And_Get
464: (p_count => x_msg_count,
465: p_data => x_msg_data
466: );
472:
473: WHEN FND_API.G_EXC_ERROR THEN
474: ROLLBACK TO UPDATE_Cnt_Point_PVT;
475: x_return_status := FND_API.G_RET_STS_ERROR;
476: -- Standard call to get message count and if count=1, get the message
477: FND_MSG_PUB.Count_And_Get (
478: p_encoded => FND_API.G_FALSE,
479: p_count => x_msg_count,
480: p_data => x_msg_data
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO UPDATE_Cnt_Point_PVT;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: -- Standard call to get message count and if count=1, get the message
487: FND_MSG_PUB.Count_And_Get (
488: p_encoded => FND_API.G_FALSE,
489: p_count => x_msg_count,
490: p_data => x_msg_data
496: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
497: THEN
498: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
499: END IF;
500: -- Standard call to get message count and if count=1, get the message
501: FND_MSG_PUB.Count_And_Get (
502: p_encoded => FND_API.G_FALSE,
503: p_count => x_msg_count,
504: p_data => x_msg_data
535: IF (AMS_DEBUG_HIGH_ON) THEN
536:
537: AMS_UTILITY_PVT.debug_message('Inside Delete_cnt_point');
538: END IF;
539: -- Standard Start of API savepoint
540: SAVEPOINT DELETE_Cnt_Point_PVT;
541:
542: -- Standard call to check for call compatibility.
543: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
538: END IF;
539: -- Standard Start of API savepoint
540: SAVEPOINT DELETE_Cnt_Point_PVT;
541:
542: -- Standard call to check for call compatibility.
543: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
544: p_api_version_number,
545: l_api_name,
546: G_PKG_NAME)
591: --
592: -- End of API body
593: --
594:
595: -- Standard check for p_commit
596: IF FND_API.to_Boolean( p_commit )
597: THEN
598: COMMIT WORK;
599: END IF;
606:
607: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
608: END IF;
609:
610: -- Standard call to get message count and if count is 1, get message info.
611: FND_MSG_PUB.Count_And_Get
612: (p_count => x_msg_count,
613: p_data => x_msg_data
614: );
620:
621: WHEN FND_API.G_EXC_ERROR THEN
622: ROLLBACK TO DELETE_Cnt_Point_PVT;
623: x_return_status := FND_API.G_RET_STS_ERROR;
624: -- Standard call to get message count and if count=1, get the message
625: FND_MSG_PUB.Count_And_Get (
626: p_encoded => FND_API.G_FALSE,
627: p_count => x_msg_count,
628: p_data => x_msg_data
630:
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: ROLLBACK TO DELETE_Cnt_Point_PVT;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: -- Standard call to get message count and if count=1, get the message
635: FND_MSG_PUB.Count_And_Get (
636: p_encoded => FND_API.G_FALSE,
637: p_count => x_msg_count,
638: p_data => x_msg_data
644: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
645: THEN
646: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
647: END IF;
648: -- Standard call to get message count and if count=1, get the message
649: FND_MSG_PUB.Count_And_Get (
650: p_encoded => FND_API.G_FALSE,
651: p_count => x_msg_count,
652: p_data => x_msg_data
701: THEN
702: FND_MSG_PUB.initialize;
703: END IF;
704:
705: -- Standard call to check for call compatibility.
706: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
707: p_api_version_number,
708: l_api_name,
709: G_PKG_NAME)
757:
758: WHEN FND_API.G_EXC_ERROR THEN
759: ROLLBACK TO LOCK_Cnt_Point_PVT;
760: x_return_status := FND_API.G_RET_STS_ERROR;
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
767:
768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
769: ROLLBACK TO LOCK_Cnt_Point_PVT;
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: -- Standard call to get message count and if count=1, get the message
772: FND_MSG_PUB.Count_And_Get (
773: p_encoded => FND_API.G_FALSE,
774: p_count => x_msg_count,
775: p_data => x_msg_data
781: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
782: THEN
783: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
784: END IF;
785: -- Standard call to get message count and if count=1, get the message
786: FND_MSG_PUB.Count_And_Get (
787: p_encoded => FND_API.G_FALSE,
788: p_count => x_msg_count,
789: p_data => x_msg_data
1320:
1321: AMS_UTILITY_PVT.debug_message('Inside Validate_cnt_points');
1322: END IF;
1323:
1324: -- Standard Start of API savepoint
1325: SAVEPOINT VALIDATE_Cnt_Point_;
1326:
1327: -- Standard call to check for call compatibility.
1328: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1323:
1324: -- Standard Start of API savepoint
1325: SAVEPOINT VALIDATE_Cnt_Point_;
1326:
1327: -- Standard call to check for call compatibility.
1328: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1329: p_api_version_number,
1330: l_api_name,
1331: G_PKG_NAME)
1441:
1442: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end ' || x_return_status);
1443: END IF;
1444:
1445: -- Standard call to get message count and if count is 1, get message info.
1446: FND_MSG_PUB.Count_And_Get
1447: (p_encoded => FND_API.G_FALSE,
1448: p_count => x_msg_count,
1449: p_data => x_msg_data
1456:
1457: WHEN FND_API.G_EXC_ERROR THEN
1458: ROLLBACK TO VALIDATE_Cnt_Point_;
1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460: -- Standard call to get message count and if count=1, get the message
1461: FND_MSG_PUB.Count_And_Get (
1462: p_encoded => FND_API.G_FALSE,
1463: p_count => x_msg_count,
1464: p_data => x_msg_data
1466:
1467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1468: ROLLBACK TO VALIDATE_Cnt_Point_;
1469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1470: -- Standard call to get message count and if count=1, get the message
1471: FND_MSG_PUB.Count_And_Get (
1472: p_encoded => FND_API.G_FALSE,
1473: p_count => x_msg_count,
1474: p_data => x_msg_data
1480: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1481: THEN
1482: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1483: END IF;
1484: -- Standard call to get message count and if count=1, get the message
1485: FND_MSG_PUB.Count_And_Get (
1486: p_encoded => FND_API.G_FALSE,
1487: p_count => x_msg_count,
1488: p_data => x_msg_data