71: FROM ams_list_src_types
72: WHERE list_source_type_id = p_list_source_type_id;
73:
74: BEGIN
75: -- Standard Start of API savepoint
76: SAVEPOINT CREATE_List_Src_Field_PVT;
77:
78: -- Standard call to check for call compatibility.
79: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
74: BEGIN
75: -- Standard Start of API savepoint
76: SAVEPOINT CREATE_List_Src_Field_PVT;
77:
78: -- Standard call to check for call compatibility.
79: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
80: p_api_version_number,
81: l_api_name,
82: G_PKG_NAME)
223: --
224: -- End of API body
225: --
226: x_list_source_field_id := l_list_source_field_id;
227: -- Standard check for p_commit
228: IF FND_API.to_Boolean( p_commit )
229: THEN
230: COMMIT WORK;
231: END IF;
233:
234: -- Debug Message
235: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
236:
237: -- Standard call to get message count and if count is 1, get message info.
238: FND_MSG_PUB.Count_And_Get
239: (p_count => x_msg_count,
240: p_data => x_msg_data
241: );
247:
248: WHEN FND_API.G_EXC_ERROR THEN
249: ROLLBACK TO CREATE_List_Src_Field_PVT;
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: -- Standard call to get message count and if count=1, get the message
252: FND_MSG_PUB.Count_And_Get (
253: p_encoded => FND_API.G_FALSE,
254: p_count => x_msg_count,
255: p_data => x_msg_data
257:
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259: ROLLBACK TO CREATE_List_Src_Field_PVT;
260: x_return_status := FND_API.G_RET_STS_UNEXP_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
271: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
272: THEN
273: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
274: END IF;
275: -- Standard call to get message count and if count=1, get the message
276: FND_MSG_PUB.Count_And_Get (
277: p_encoded => FND_API.G_FALSE,
278: p_count => x_msg_count,
279: p_data => x_msg_data
333: l_column_name VARCHAR2(30);
334: l_remote_flag VARCHAR2(1);
335: l_database_link VARCHAR2(1000);
336: BEGIN
337: -- Standard Start of API savepoint
338: SAVEPOINT UPDATE_List_Src_Field_PVT;
339:
340: -- Standard call to check for call compatibility.
341: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
336: BEGIN
337: -- Standard Start of API savepoint
338: SAVEPOINT UPDATE_List_Src_Field_PVT;
339:
340: -- Standard call to check for call compatibility.
341: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
342: p_api_version_number,
343: l_api_name,
344: G_PKG_NAME)
505: --
506: -- End of API body.
507: --
508:
509: -- Standard check for p_commit
510: IF FND_API.to_Boolean( p_commit )
511: THEN
512: COMMIT WORK;
513: END IF;
515:
516: -- Debug Message
517: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
518:
519: -- Standard call to get message count and if count is 1, get message info.
520: FND_MSG_PUB.Count_And_Get
521: (p_count => x_msg_count,
522: p_data => x_msg_data
523: );
529:
530: WHEN FND_API.G_EXC_ERROR THEN
531: ROLLBACK TO UPDATE_List_Src_Field_PVT;
532: x_return_status := FND_API.G_RET_STS_ERROR;
533: -- Standard call to get message count and if count=1, get the message
534: FND_MSG_PUB.Count_And_Get (
535: p_encoded => FND_API.G_FALSE,
536: p_count => x_msg_count,
537: p_data => x_msg_data
539:
540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
541: ROLLBACK TO UPDATE_List_Src_Field_PVT;
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: -- Standard call to get message count and if count=1, get the message
544: FND_MSG_PUB.Count_And_Get (
545: p_encoded => FND_API.G_FALSE,
546: p_count => x_msg_count,
547: p_data => x_msg_data
553: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
554: THEN
555: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
556: END IF;
557: -- Standard call to get message count and if count=1, get the message
558: FND_MSG_PUB.Count_And_Get (
559: p_encoded => FND_API.G_FALSE,
560: p_count => x_msg_count,
561: p_data => x_msg_data
580: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
581: l_object_version_number NUMBER;
582:
583: BEGIN
584: -- Standard Start of API savepoint
585: SAVEPOINT DELETE_List_Src_Field_PVT;
586:
587: -- Standard call to check for call compatibility.
588: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
583: BEGIN
584: -- Standard Start of API savepoint
585: SAVEPOINT DELETE_List_Src_Field_PVT;
586:
587: -- Standard call to check for call compatibility.
588: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
589: p_api_version_number,
590: l_api_name,
591: G_PKG_NAME)
629: --
630: -- End of API body
631: --
632:
633: -- Standard check for p_commit
634: IF FND_API.to_Boolean( p_commit )
635: THEN
636: COMMIT WORK;
637: END IF;
639:
640: -- Debug Message
641: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
642:
643: -- Standard call to get message count and if count is 1, get message info.
644: FND_MSG_PUB.Count_And_Get
645: (p_count => x_msg_count,
646: p_data => x_msg_data
647: );
653:
654: WHEN FND_API.G_EXC_ERROR THEN
655: ROLLBACK TO DELETE_List_Src_Field_PVT;
656: x_return_status := FND_API.G_RET_STS_ERROR;
657: -- Standard call to get message count and if count=1, get the message
658: FND_MSG_PUB.Count_And_Get (
659: p_encoded => FND_API.G_FALSE,
660: p_count => x_msg_count,
661: p_data => x_msg_data
663:
664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
665: ROLLBACK TO DELETE_List_Src_Field_PVT;
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: -- Standard call to get message count and if count=1, get the message
668: FND_MSG_PUB.Count_And_Get (
669: p_encoded => FND_API.G_FALSE,
670: p_count => x_msg_count,
671: p_data => x_msg_data
677: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
678: THEN
679: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
680: END IF;
681: -- Standard call to get message count and if count=1, get the message
682: FND_MSG_PUB.Count_And_Get (
683: p_encoded => FND_API.G_FALSE,
684: p_count => x_msg_count,
685: p_data => x_msg_data
724: THEN
725: FND_MSG_PUB.initialize;
726: END IF;
727:
728: -- Standard call to check for call compatibility.
729: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
730: p_api_version_number,
731: l_api_name,
732: G_PKG_NAME)
771:
772: WHEN FND_API.G_EXC_ERROR THEN
773: ROLLBACK TO LOCK_List_Src_Field_PVT;
774: x_return_status := FND_API.G_RET_STS_ERROR;
775: -- Standard call to get message count and if count=1, get the message
776: FND_MSG_PUB.Count_And_Get (
777: p_encoded => FND_API.G_FALSE,
778: p_count => x_msg_count,
779: p_data => x_msg_data
781:
782: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
783: ROLLBACK TO LOCK_List_Src_Field_PVT;
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
795: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
796: THEN
797: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
798: END IF;
799: -- Standard call to get message count and if count=1, get the message
800: FND_MSG_PUB.Count_And_Get (
801: p_encoded => FND_API.G_FALSE,
802: p_count => x_msg_count,
803: p_data => x_msg_data
1283: l_object_version_number NUMBER;
1284: l_list_src_field_rec AMS_List_Src_Field_PVT.list_src_field_rec_type;
1285:
1286: BEGIN
1287: -- Standard Start of API savepoint
1288: SAVEPOINT VALIDATE_List_Src_Field_;
1289:
1290: -- Standard call to check for call compatibility.
1291: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1286: BEGIN
1287: -- Standard Start of API savepoint
1288: SAVEPOINT VALIDATE_List_Src_Field_;
1289:
1290: -- Standard call to check for call compatibility.
1291: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1292: p_api_version_number,
1293: l_api_name,
1294: G_PKG_NAME)
1350:
1351: -- Debug Message
1352: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1353:
1354: -- Standard call to get message count and if count is 1, get message info.
1355: FND_MSG_PUB.Count_And_Get
1356: (p_count => x_msg_count,
1357: p_data => x_msg_data
1358: );
1364:
1365: WHEN FND_API.G_EXC_ERROR THEN
1366: ROLLBACK TO VALIDATE_List_Src_Field_;
1367: x_return_status := FND_API.G_RET_STS_ERROR;
1368: -- Standard call to get message count and if count=1, get the message
1369: FND_MSG_PUB.Count_And_Get (
1370: p_encoded => FND_API.G_FALSE,
1371: p_count => x_msg_count,
1372: p_data => x_msg_data
1374:
1375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1376: ROLLBACK TO VALIDATE_List_Src_Field_;
1377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1378: -- Standard call to get message count and if count=1, get the message
1379: FND_MSG_PUB.Count_And_Get (
1380: p_encoded => FND_API.G_FALSE,
1381: p_count => x_msg_count,
1382: p_data => x_msg_data
1388: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1389: THEN
1390: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1391: END IF;
1392: -- Standard call to get message count and if count=1, get the message
1393: FND_MSG_PUB.Count_And_Get (
1394: p_encoded => FND_API.G_FALSE,
1395: p_count => x_msg_count,
1396: p_data => x_msg_data
1423: -- x_return_status := FND_API.G_RET_STS_ERROR;
1424:
1425: -- Debug Message
1426: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1427: -- Standard call to get message count and if count is 1, get message info.
1428: FND_MSG_PUB.Count_And_Get
1429: (p_count => x_msg_count,
1430: p_data => x_msg_data
1431: );