DBA Data[Home] [Help]

APPS.AMS_LIST_SRC_FIELD_PVT dependencies on STANDARD

Line 75: -- Standard Start of API savepoint

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,

Line 78: -- Standard call to check for call compatibility.

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)

Line 227: -- Standard check for p_commit

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;

Line 237: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 251: -- Standard call to get message count and if count=1, get the message

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

Line 261: -- Standard call to get message count and if count=1, get the message

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

Line 275: -- Standard call to get message count and if count=1, get the message

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

Line 337: -- Standard Start of API savepoint

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,

Line 340: -- Standard call to check for call compatibility.

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)

Line 509: -- Standard check for p_commit

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;

Line 519: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 533: -- Standard call to get message count and if count=1, get the message

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

Line 543: -- Standard call to get message count and if count=1, get the message

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

Line 557: -- Standard call to get message count and if count=1, get the message

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

Line 584: -- Standard Start of API savepoint

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,

Line 587: -- Standard call to check for call compatibility.

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)

Line 633: -- Standard check for p_commit

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;

Line 643: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 657: -- Standard call to get message count and if count=1, get the message

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

Line 667: -- Standard call to get message count and if count=1, get the message

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

Line 681: -- Standard call to get message count and if count=1, get the message

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

Line 728: -- Standard call to check for call compatibility.

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)

Line 775: -- Standard call to get message count and if count=1, get the message

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

Line 785: -- Standard call to get message count and if count=1, get the message

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

Line 799: -- Standard call to get message count and if count=1, get the message

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

Line 1287: -- Standard Start of API savepoint

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,

Line 1290: -- Standard call to check for call compatibility.

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)

Line 1354: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 1368: -- Standard call to get message count and if count=1, get the message

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

Line 1378: -- Standard call to get message count and if count=1, get the message

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

Line 1392: -- Standard call to get message count and if count=1, get the message

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

Line 1427: -- Standard call to get message count and if count is 1, get message info.

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: );