[Home] [Help]
56: -- x_return_status OUT VARCHAR2
57: -- x_msg_count OUT NUMBER
58: -- x_msg_data OUT VARCHAR2
59: -- Version : Current version 1.0
60: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
61: -- and basic operation, developer must manually add parameters and business logic as necessary.
62: --
63: -- History
64: --
89: l_Dm_Imp_Attribute_id NUMBER;
90: l_dummy NUMBER;
91: l_imp_attribute_rec imp_attribute_rec_type;
92: BEGIN
93: -- Standard Start of API savepoint
94: SAVEPOINT create_Dm_Imp_Attribute_pvt;
95:
96: -- Standard call to check for call compatibility.
97: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
92: BEGIN
93: -- Standard Start of API savepoint
94: SAVEPOINT create_Dm_Imp_Attribute_pvt;
95:
96: -- Standard call to check for call compatibility.
97: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
98: p_api_version_number,
99: l_api_name,
100: G_PKG_NAME)
182: --
183:
184: x_Dm_Imp_Attribute_id := l_imp_attribute_rec.imp_attribute_id;
185:
186: -- Standard check for p_commit
187: IF FND_API.to_Boolean( p_commit )
188: THEN
189: COMMIT WORK;
190: END IF;
194:
195: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
196: END IF;
197:
198: -- Standard call to get message count and if count is 1, get message info.
199: FND_MSG_PUB.Count_And_Get
200: (p_count => x_msg_count,
201: p_data => x_msg_data
202: );
208:
209: WHEN FND_API.G_EXC_ERROR THEN
210: ROLLBACK TO CREATE_Dm_Imp_Attribute_PVT;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: -- Standard call to get message count and if count=1, get the message
213: FND_MSG_PUB.Count_And_Get (
214: p_encoded => FND_API.G_FALSE,
215: p_count => x_msg_count,
216: p_data => x_msg_data
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: ROLLBACK TO CREATE_Dm_Imp_Attribute_PVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: -- Standard call to get message count and if count=1, get the message
223: FND_MSG_PUB.Count_And_Get (
224: p_encoded => FND_API.G_FALSE,
225: p_count => x_msg_count,
226: p_data => x_msg_data
232: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
233: THEN
234: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
235: END IF;
236: -- Standard call to get message count and if count=1, get the message
237: FND_MSG_PUB.Count_And_Get (
238: p_encoded => FND_API.G_FALSE,
239: p_count => x_msg_count,
240: p_data => x_msg_data
264: -- x_return_status OUT VARCHAR2
265: -- x_msg_count OUT NUMBER
266: -- x_msg_data OUT VARCHAR2
267: -- Version : Current version 1.0
268: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
269: -- and basic operation, developer must manually add parameters and business logic as necessary.
270: --
271: -- History
272: --
304: l_ref_imp_attribute_rec c_get_Imp_Attribute%ROWTYPE ;
305: l_tar_imp_attribute_rec imp_attribute_rec_type := p_imp_attribute_rec;
306: l_rowid ROWID;
307: BEGIN
308: -- Standard Start of API savepoint
309: SAVEPOINT update_Dm_Imp_Attribute_pvt;
310:
311: -- Standard call to check for call compatibility.
312: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
307: BEGIN
308: -- Standard Start of API savepoint
309: SAVEPOINT update_Dm_Imp_Attribute_pvt;
310:
311: -- Standard call to check for call compatibility.
312: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
313: p_api_version_number,
314: l_api_name,
315: G_PKG_NAME)
414: --
415:
416: x_object_version_number := l_object_version_number;
417:
418: -- Standard check for p_commit
419: IF FND_API.to_Boolean( p_commit )
420: THEN
421: COMMIT WORK;
422: END IF;
426:
427: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
428: END IF;
429:
430: -- Standard call to get message count and if count is 1, get message info.
431: FND_MSG_PUB.Count_And_Get
432: (p_count => x_msg_count,
433: p_data => x_msg_data
434: );
440:
441: WHEN FND_API.G_EXC_ERROR THEN
442: ROLLBACK TO UPDATE_Dm_Imp_Attribute_PVT;
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: -- Standard call to get message count and if count=1, get the message
445: FND_MSG_PUB.Count_And_Get (
446: p_encoded => FND_API.G_FALSE,
447: p_count => x_msg_count,
448: p_data => x_msg_data
450:
451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
452: ROLLBACK TO UPDATE_Dm_Imp_Attribute_PVT;
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: -- Standard call to get message count and if count=1, get the message
455: FND_MSG_PUB.Count_And_Get (
456: p_encoded => FND_API.G_FALSE,
457: p_count => x_msg_count,
458: p_data => x_msg_data
464: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
465: THEN
466: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
467: END IF;
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
497: -- x_return_status OUT VARCHAR2
498: -- x_msg_count OUT NUMBER
499: -- x_msg_data OUT VARCHAR2
500: -- Version : Current version 1.0
501: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
502: -- and basic operation, developer must manually add parameters and business logic as necessary.
503: --
504: -- History
505: --
523: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Imp_Attribute';
524: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
525: l_object_version_number NUMBER;
526: BEGIN
527: -- Standard Start of API savepoint
528: SAVEPOINT delete_Dm_Imp_Attribute_pvt;
529:
530: -- Standard call to check for call compatibility.
531: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
526: BEGIN
527: -- Standard Start of API savepoint
528: SAVEPOINT delete_Dm_Imp_Attribute_pvt;
529:
530: -- Standard call to check for call compatibility.
531: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
532: p_api_version_number,
533: l_api_name,
534: G_PKG_NAME)
572: --
573: -- End of API body
574: --
575:
576: -- Standard check for p_commit
577: IF FND_API.to_Boolean( p_commit )
578: THEN
579: COMMIT WORK;
580: END IF;
586: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
587: END IF;
588:
589:
590: -- Standard call to get message count and if count is 1, get message info.
591: FND_MSG_PUB.Count_And_Get
592: (p_count => x_msg_count,
593: p_data => x_msg_data
594: );
600:
601: WHEN FND_API.G_EXC_ERROR THEN
602: ROLLBACK TO DELETE_Dm_Imp_Attribute_PVT;
603: x_return_status := FND_API.G_RET_STS_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
610:
611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
612: ROLLBACK TO DELETE_Dm_Imp_Attribute_PVT;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614: -- Standard call to get message count and if count=1, get the message
615: FND_MSG_PUB.Count_And_Get (
616: p_encoded => FND_API.G_FALSE,
617: p_count => x_msg_count,
618: p_data => x_msg_data
624: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
625: THEN
626: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
627: END IF;
628: -- Standard call to get message count and if count=1, get the message
629: FND_MSG_PUB.Count_And_Get (
630: p_encoded => FND_API.G_FALSE,
631: p_count => x_msg_count,
632: p_data => x_msg_data
658: -- x_return_status OUT VARCHAR2
659: -- x_msg_count OUT NUMBER
660: -- x_msg_data OUT VARCHAR2
661: -- Version : Current version 1.0
662: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
663: -- and basic operation, developer must manually add parameters and business logic as necessary.
664: --
665: -- History
666: --
705: THEN
706: FND_MSG_PUB.initialize;
707: END IF;
708:
709: -- Standard call to check for call compatibility.
710: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
711: p_api_version_number,
712: l_api_name,
713: G_PKG_NAME)
753:
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO LOCK_Dm_Imp_Attribute_PVT;
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: -- Standard call to get message count and if count=1, get the message
758: FND_MSG_PUB.Count_And_Get (
759: p_encoded => FND_API.G_FALSE,
760: p_count => x_msg_count,
761: p_data => x_msg_data
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO LOCK_Dm_Imp_Attribute_PVT;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: -- Standard call to get message count and if count=1, get the message
768: FND_MSG_PUB.Count_And_Get (
769: p_encoded => FND_API.G_FALSE,
770: p_count => x_msg_count,
771: p_data => x_msg_data
777: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
778: THEN
779: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
780: END IF;
781: -- Standard call to get message count and if count=1, get the message
782: FND_MSG_PUB.Count_And_Get (
783: p_encoded => FND_API.G_FALSE,
784: p_count => x_msg_count,
785: p_data => x_msg_data
1130: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1131: l_object_version_number NUMBER;
1132: l_imp_attribute_rec imp_attribute_rec_type;
1133: BEGIN
1134: -- Standard Start of API savepoint
1135: SAVEPOINT validate_Dm_Imp_Attribute_;
1136:
1137: -- Standard call to check for call compatibility.
1138: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1133: BEGIN
1134: -- Standard Start of API savepoint
1135: SAVEPOINT validate_Dm_Imp_Attribute_;
1136:
1137: -- Standard call to check for call compatibility.
1138: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1139: p_api_version_number,
1140: l_api_name,
1141: G_PKG_NAME)
1199:
1200: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1201: END IF;
1202:
1203: -- Standard call to get message count and if count is 1, get message info.
1204: FND_MSG_PUB.Count_And_Get
1205: (p_count => x_msg_count,
1206: p_data => x_msg_data
1207: );
1213:
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: ROLLBACK TO VALIDATE_Dm_Imp_Attribute_;
1216: x_return_status := FND_API.G_RET_STS_ERROR;
1217: -- Standard call to get message count and if count=1, get the message
1218: FND_MSG_PUB.Count_And_Get (
1219: p_encoded => FND_API.G_FALSE,
1220: p_count => x_msg_count,
1221: p_data => x_msg_data
1223:
1224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1225: ROLLBACK TO VALIDATE_Dm_Imp_Attribute_;
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227: -- Standard call to get message count and if count=1, get the message
1228: FND_MSG_PUB.Count_And_Get (
1229: p_encoded => FND_API.G_FALSE,
1230: p_count => x_msg_count,
1231: p_data => x_msg_data
1237: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1238: THEN
1239: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1240: END IF;
1241: -- Standard call to get message count and if count=1, get the message
1242: FND_MSG_PUB.Count_And_Get (
1243: p_encoded => FND_API.G_FALSE,
1244: p_count => x_msg_count,
1245: p_data => x_msg_data