[Home] [Help]
81: FROM ams_list_src_types
82: WHERE list_source_type_id = p_list_source_type_id;
83:
84: BEGIN
85: -- Standard Start of API savepoint
86: SAVEPOINT CREATE_List_Src_Field_PVT;
87:
88: -- Standard call to check for call compatibility.
89: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
84: BEGIN
85: -- Standard Start of API savepoint
86: SAVEPOINT CREATE_List_Src_Field_PVT;
87:
88: -- Standard call to check for call compatibility.
89: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
90: p_api_version_number,
91: l_api_name,
92: G_PKG_NAME)
233: --
234: -- End of API body
235: --
236: x_list_source_field_id := l_list_source_field_id;
237: -- Standard check for p_commit
238: IF FND_API.to_Boolean( p_commit )
239: THEN
240: COMMIT WORK;
241: END IF;
243:
244: -- Debug Message
245: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
246:
247: -- Standard call to get message count and if count is 1, get message info.
248: FND_MSG_PUB.Count_And_Get
249: (p_count => x_msg_count,
250: p_data => x_msg_data
251: );
257:
258: WHEN FND_API.G_EXC_ERROR THEN
259: ROLLBACK TO CREATE_List_Src_Field_PVT;
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: -- Standard call to get message count and if count=1, get the message
262: FND_MSG_PUB.Count_And_Get (
263: p_encoded => FND_API.G_FALSE,
264: p_count => x_msg_count,
265: p_data => x_msg_data
267:
268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
269: ROLLBACK TO CREATE_List_Src_Field_PVT;
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271: -- Standard call to get message count and if count=1, get the message
272: FND_MSG_PUB.Count_And_Get (
273: p_encoded => FND_API.G_FALSE,
274: p_count => x_msg_count,
275: p_data => x_msg_data
281: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
282: THEN
283: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
284: END IF;
285: -- Standard call to get message count and if count=1, get the message
286: FND_MSG_PUB.Count_And_Get (
287: p_encoded => FND_API.G_FALSE,
288: p_count => x_msg_count,
289: p_data => x_msg_data
351: l_column_name VARCHAR2(30);
352: l_remote_flag VARCHAR2(1);
353: l_database_link VARCHAR2(1000);
354: BEGIN
355: -- Standard Start of API savepoint
356: SAVEPOINT UPDATE_List_Src_Field_PVT;
357:
358: -- Standard call to check for call compatibility.
359: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
354: BEGIN
355: -- Standard Start of API savepoint
356: SAVEPOINT UPDATE_List_Src_Field_PVT;
357:
358: -- Standard call to check for call compatibility.
359: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
360: p_api_version_number,
361: l_api_name,
362: G_PKG_NAME)
536: --
537: -- End of API body.
538: --
539:
540: -- Standard check for p_commit
541: IF FND_API.to_Boolean( p_commit )
542: THEN
543: COMMIT WORK;
544: END IF;
546:
547: -- Debug Message
548: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
549:
550: -- Standard call to get message count and if count is 1, get message info.
551: FND_MSG_PUB.Count_And_Get
552: (p_count => x_msg_count,
553: p_data => x_msg_data
554: );
560:
561: WHEN FND_API.G_EXC_ERROR THEN
562: ROLLBACK TO UPDATE_List_Src_Field_PVT;
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: -- Standard call to get message count and if count=1, get the message
565: FND_MSG_PUB.Count_And_Get (
566: p_encoded => FND_API.G_FALSE,
567: p_count => x_msg_count,
568: p_data => x_msg_data
570:
571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
572: ROLLBACK TO UPDATE_List_Src_Field_PVT;
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574: -- Standard call to get message count and if count=1, get the message
575: FND_MSG_PUB.Count_And_Get (
576: p_encoded => FND_API.G_FALSE,
577: p_count => x_msg_count,
578: p_data => x_msg_data
584: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
585: THEN
586: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
587: END IF;
588: -- Standard call to get message count and if count=1, get the message
589: FND_MSG_PUB.Count_And_Get (
590: p_encoded => FND_API.G_FALSE,
591: p_count => x_msg_count,
592: p_data => x_msg_data
611: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
612: l_object_version_number NUMBER;
613:
614: BEGIN
615: -- Standard Start of API savepoint
616: SAVEPOINT DELETE_List_Src_Field_PVT;
617:
618: -- Standard call to check for call compatibility.
619: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
614: BEGIN
615: -- Standard Start of API savepoint
616: SAVEPOINT DELETE_List_Src_Field_PVT;
617:
618: -- Standard call to check for call compatibility.
619: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
620: p_api_version_number,
621: l_api_name,
622: G_PKG_NAME)
660: --
661: -- End of API body
662: --
663:
664: -- Standard check for p_commit
665: IF FND_API.to_Boolean( p_commit )
666: THEN
667: COMMIT WORK;
668: END IF;
670:
671: -- Debug Message
672: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
673:
674: -- Standard call to get message count and if count is 1, get message info.
675: FND_MSG_PUB.Count_And_Get
676: (p_count => x_msg_count,
677: p_data => x_msg_data
678: );
684:
685: WHEN FND_API.G_EXC_ERROR THEN
686: ROLLBACK TO DELETE_List_Src_Field_PVT;
687: x_return_status := FND_API.G_RET_STS_ERROR;
688: -- Standard call to get message count and if count=1, get the message
689: FND_MSG_PUB.Count_And_Get (
690: p_encoded => FND_API.G_FALSE,
691: p_count => x_msg_count,
692: p_data => x_msg_data
694:
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
696: ROLLBACK TO DELETE_List_Src_Field_PVT;
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698: -- Standard call to get message count and if count=1, get the message
699: FND_MSG_PUB.Count_And_Get (
700: p_encoded => FND_API.G_FALSE,
701: p_count => x_msg_count,
702: p_data => x_msg_data
708: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
709: THEN
710: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
711: END IF;
712: -- Standard call to get message count and if count=1, get the message
713: FND_MSG_PUB.Count_And_Get (
714: p_encoded => FND_API.G_FALSE,
715: p_count => x_msg_count,
716: p_data => x_msg_data
755: THEN
756: FND_MSG_PUB.initialize;
757: END IF;
758:
759: -- Standard call to check for call compatibility.
760: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
761: p_api_version_number,
762: l_api_name,
763: G_PKG_NAME)
802:
803: WHEN FND_API.G_EXC_ERROR THEN
804: ROLLBACK TO LOCK_List_Src_Field_PVT;
805: x_return_status := FND_API.G_RET_STS_ERROR;
806: -- Standard call to get message count and if count=1, get the message
807: FND_MSG_PUB.Count_And_Get (
808: p_encoded => FND_API.G_FALSE,
809: p_count => x_msg_count,
810: p_data => x_msg_data
812:
813: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
814: ROLLBACK TO LOCK_List_Src_Field_PVT;
815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
816: -- Standard call to get message count and if count=1, get the message
817: FND_MSG_PUB.Count_And_Get (
818: p_encoded => FND_API.G_FALSE,
819: p_count => x_msg_count,
820: p_data => x_msg_data
826: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
827: THEN
828: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
829: END IF;
830: -- Standard call to get message count and if count=1, get the message
831: FND_MSG_PUB.Count_And_Get (
832: p_encoded => FND_API.G_FALSE,
833: p_count => x_msg_count,
834: p_data => x_msg_data
1314: l_object_version_number NUMBER;
1315: l_list_src_field_rec AMS_List_Src_Field_PVT.list_src_field_rec_type;
1316:
1317: BEGIN
1318: -- Standard Start of API savepoint
1319: SAVEPOINT VALIDATE_List_Src_Field_;
1320:
1321: -- Standard call to check for call compatibility.
1322: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1317: BEGIN
1318: -- Standard Start of API savepoint
1319: SAVEPOINT VALIDATE_List_Src_Field_;
1320:
1321: -- Standard call to check for call compatibility.
1322: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1323: p_api_version_number,
1324: l_api_name,
1325: G_PKG_NAME)
1381:
1382: -- Debug Message
1383: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1384:
1385: -- Standard call to get message count and if count is 1, get message info.
1386: FND_MSG_PUB.Count_And_Get
1387: (p_count => x_msg_count,
1388: p_data => x_msg_data
1389: );
1395:
1396: WHEN FND_API.G_EXC_ERROR THEN
1397: ROLLBACK TO VALIDATE_List_Src_Field_;
1398: x_return_status := FND_API.G_RET_STS_ERROR;
1399: -- Standard call to get message count and if count=1, get the message
1400: FND_MSG_PUB.Count_And_Get (
1401: p_encoded => FND_API.G_FALSE,
1402: p_count => x_msg_count,
1403: p_data => x_msg_data
1405:
1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1407: ROLLBACK TO VALIDATE_List_Src_Field_;
1408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1409: -- Standard call to get message count and if count=1, get the message
1410: FND_MSG_PUB.Count_And_Get (
1411: p_encoded => FND_API.G_FALSE,
1412: p_count => x_msg_count,
1413: p_data => x_msg_data
1419: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1420: THEN
1421: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1422: END IF;
1423: -- Standard call to get message count and if count=1, get the message
1424: FND_MSG_PUB.Count_And_Get (
1425: p_encoded => FND_API.G_FALSE,
1426: p_count => x_msg_count,
1427: p_data => x_msg_data
1454: -- x_return_status := FND_API.G_RET_STS_ERROR;
1455:
1456: -- Debug Message
1457: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1458: -- Standard call to get message count and if count is 1, get message info.
1459: FND_MSG_PUB.Count_And_Get
1460: (p_count => x_msg_count,
1461: p_data => x_msg_data
1462: );