[Home] [Help]
65: FROM AMS_DM_BIN_VALUES
66: WHERE BIN_VALUE_ID = l_id;
67:
68: BEGIN
69: -- Standard Start of API savepoint
70: SAVEPOINT CREATE_Dm_Binvalues_PVT;
71:
72: -- Standard call to check for call compatibility.
73: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
68: BEGIN
69: -- Standard Start of API savepoint
70: SAVEPOINT CREATE_Dm_Binvalues_PVT;
71:
72: -- Standard call to check for call compatibility.
73: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
74: p_api_version_number,
75: l_api_name,
76: G_PKG_NAME)
184: --
185: -- End of API body
186: --
187:
188: -- Standard check for p_commit
189: IF FND_API.to_Boolean( p_commit ) THEN
190: COMMIT WORK;
191: END IF;
192:
195:
196: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
197: END IF;
198:
199: -- Standard call to get message count and if count is 1, get message info.
200: FND_MSG_PUB.Count_And_Get
201: (p_count => x_msg_count,
202: p_data => x_msg_data
203: );
210:
211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO CREATE_Dm_Binvalues_PVT;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: -- Standard call to get message count and if count=1, get the message
215: FND_MSG_PUB.Count_And_Get (
216: p_encoded => FND_API.G_FALSE,
217: p_count => x_msg_count,
218: p_data => x_msg_data
220:
221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
222: ROLLBACK TO CREATE_Dm_Binvalues_PVT;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: -- Standard call to get message count and if count=1, get the message
225: FND_MSG_PUB.Count_And_Get (
226: p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,
228: p_data => x_msg_data
234: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message
239: FND_MSG_PUB.Count_And_Get (
240: p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count,
242: p_data => x_msg_data
277: l_tar_dm_binvalues_rec AMS_Dm_Binvalues_PVT.dm_binvalues_rec_type := P_dm_binvalues_rec;
278: l_rowid ROWID;
279:
280: BEGIN
281: -- Standard Start of API savepoint
282: SAVEPOINT UPDATE_Dm_Binvalues_PVT;
283:
284: -- Standard call to check for call compatibility.
285: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
280: BEGIN
281: -- Standard Start of API savepoint
282: SAVEPOINT UPDATE_Dm_Binvalues_PVT;
283:
284: -- Standard call to check for call compatibility.
285: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
286: p_api_version_number,
287: l_api_name,
288: G_PKG_NAME)
457: --
458: -- End of API body.
459: --
460:
461: -- Standard check for p_commit
462: IF FND_API.to_Boolean( p_commit )
463: THEN
464: COMMIT WORK;
465: END IF;
470:
471: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
472: END IF;
473:
474: -- Standard call to get message count and if count is 1, get message info.
475: FND_MSG_PUB.Count_And_Get
476: (p_count => x_msg_count,
477: p_data => x_msg_data
478: );
484:
485: WHEN FND_API.G_EXC_ERROR THEN
486: ROLLBACK TO UPDATE_Dm_Binvalues_PVT;
487: x_return_status := FND_API.G_RET_STS_ERROR;
488: -- Standard call to get message count and if count=1, get the message
489: FND_MSG_PUB.Count_And_Get (
490: p_encoded => FND_API.G_FALSE,
491: p_count => x_msg_count,
492: p_data => x_msg_data
494:
495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
496: ROLLBACK TO UPDATE_Dm_Binvalues_PVT;
497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
508: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
509: THEN
510: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
511: END IF;
512: -- Standard call to get message count and if count=1, get the message
513: FND_MSG_PUB.Count_And_Get (
514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data
524: IS
525: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Dm_Binvalues_For_Field';
526:
527: BEGIN
528: -- Standard Start of API savepoint
529: SAVEPOINT Delete_Dm_Binvalues_For_Field;
530:
531: -- Debug Message
532: IF (AMS_DEBUG_HIGH_ON) THEN
584: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
585: l_object_version_number NUMBER;
586:
587: BEGIN
588: -- Standard Start of API savepoint
589: SAVEPOINT DELETE_Dm_Binvalues_PVT;
590:
591: -- Standard call to check for call compatibility.
592: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
587: BEGIN
588: -- Standard Start of API savepoint
589: SAVEPOINT DELETE_Dm_Binvalues_PVT;
590:
591: -- Standard call to check for call compatibility.
592: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
593: p_api_version_number,
594: l_api_name,
595: G_PKG_NAME)
628: --
629: -- End of API body
630: --
631:
632: -- Standard check for p_commit
633: IF FND_API.to_Boolean( p_commit )
634: THEN
635: COMMIT WORK;
636: END IF;
641:
642: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
643: END IF;
644:
645: -- Standard call to get message count and if count is 1, get message info.
646: FND_MSG_PUB.Count_And_Get
647: (p_count => x_msg_count,
648: p_data => x_msg_data
649: );
656:
657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO DELETE_Dm_Binvalues_PVT;
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: -- Standard call to get message count and if count=1, get the message
661: FND_MSG_PUB.Count_And_Get (
662: p_encoded => FND_API.G_FALSE,
663: p_count => x_msg_count,
664: p_data => x_msg_data
666:
667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO DELETE_Dm_Binvalues_PVT;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: -- Standard call to get message count and if count=1, get the message
671: FND_MSG_PUB.Count_And_Get (
672: p_encoded => FND_API.G_FALSE,
673: p_count => x_msg_count,
674: p_data => x_msg_data
680: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
681: THEN
682: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
683: END IF;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (
686: p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data
729: THEN
730: FND_MSG_PUB.initialize;
731: END IF;
732:
733: -- Standard call to check for call compatibility.
734: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
735: p_api_version_number,
736: l_api_name,
737: G_PKG_NAME)
786:
787: WHEN FND_API.G_EXC_ERROR THEN
788: ROLLBACK TO LOCK_Dm_Binvalues_PVT;
789: x_return_status := FND_API.G_RET_STS_ERROR;
790: -- Standard call to get message count and if count=1, get the message
791: FND_MSG_PUB.Count_And_Get (
792: p_encoded => FND_API.G_FALSE,
793: p_count => x_msg_count,
794: p_data => x_msg_data
796:
797: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
798: ROLLBACK TO LOCK_Dm_Binvalues_PVT;
799: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: -- Standard call to get message count and if count=1, get the message
801: FND_MSG_PUB.Count_And_Get (
802: p_encoded => FND_API.G_FALSE,
803: p_count => x_msg_count,
804: p_data => x_msg_data
810: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
811: THEN
812: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
813: END IF;
814: -- Standard call to get message count and if count=1, get the message
815: FND_MSG_PUB.Count_And_Get (
816: p_encoded => FND_API.G_FALSE,
817: p_count => x_msg_count,
818: p_data => x_msg_data
1104: l_object_version_number NUMBER;
1105: l_dm_binvalues_rec AMS_Dm_Binvalues_PVT.dm_binvalues_rec_type;
1106:
1107: BEGIN
1108: -- Standard Start of API savepoint
1109: SAVEPOINT VALIDATE_Dm_Binvalues_;
1110:
1111: -- Debug Message
1112: IF (AMS_DEBUG_HIGH_ON) THEN
1113:
1114: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1115: END IF;
1116:
1117: -- Standard call to check for call compatibility.
1118: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1119: p_api_version_number,
1120: l_api_name,
1121: G_PKG_NAME)
1183:
1184: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' return status = ' || x_return_status);
1185: END IF;
1186:
1187: -- Standard call to get message count and if count is 1, get message info.
1188: FND_MSG_PUB.Count_And_Get
1189: (p_count => x_msg_count,
1190: p_data => x_msg_data
1191: );
1197:
1198: WHEN FND_API.G_EXC_ERROR THEN
1199: ROLLBACK TO VALIDATE_Dm_Binvalues_;
1200: x_return_status := FND_API.G_RET_STS_ERROR;
1201: -- Standard call to get message count and if count=1, get the message
1202: FND_MSG_PUB.Count_And_Get (
1203: p_encoded => FND_API.G_FALSE,
1204: p_count => x_msg_count,
1205: p_data => x_msg_data
1207:
1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1209: ROLLBACK TO VALIDATE_Dm_Binvalues_;
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: -- Standard call to get message count and if count=1, get the message
1212: FND_MSG_PUB.Count_And_Get (
1213: p_encoded => FND_API.G_FALSE,
1214: p_count => x_msg_count,
1215: p_data => x_msg_data
1221: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1222: THEN
1223: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1224: END IF;
1225: -- Standard call to get message count and if count=1, get the message
1226: FND_MSG_PUB.Count_And_Get (
1227: p_encoded => FND_API.G_FALSE,
1228: p_count => x_msg_count,
1229: p_data => x_msg_data
1260: -- If data not valid
1261: -- THEN
1262: -- x_return_status := FND_API.G_RET_STS_ERROR;
1263:
1264: -- Standard call to get message count and if count is 1, get message info.
1265: FND_MSG_PUB.Count_And_Get
1266: (p_count => x_msg_count,
1267: p_data => x_msg_data
1268: );