DBA Data[Home] [Help]

APPS.AMS_CTD_PVT dependencies on STANDARD

Line 455: -- Standard Start of API savepoint

451: FROM AMS_CTDS
452: WHERE CTD_ID = l_id;
453:
454: BEGIN
455: -- Standard Start of API savepoint
456: SAVEPOINT CREATE_Ctd_PVT;
457:
458: -- Standard call to check for call compatibility.
459: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

454: BEGIN
455: -- Standard Start of API savepoint
456: SAVEPOINT CREATE_Ctd_PVT;
457:
458: -- Standard call to check for call compatibility.
459: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
460: p_api_version_number,
461: l_api_name,
462: G_PKG_NAME)

Line 555: -- Standard check for p_commit

551: --
552: -- End of API body
553: --
554:
555: -- Standard check for p_commit
556: IF FND_API.to_Boolean( p_commit )
557: THEN
558: COMMIT WORK;
559: END IF;

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

561:
562: -- Debug Message
563: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
564:
565: -- Standard call to get message count and if count is 1, get message info.
566: FND_MSG_PUB.Count_And_Get
567: (p_count => x_msg_count,
568: p_data => x_msg_data
569: );

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

575:
576: WHEN FND_API.G_EXC_ERROR THEN
577: ROLLBACK TO CREATE_Ctd_PVT;
578: x_return_status := FND_API.G_RET_STS_ERROR;
579: -- Standard call to get message count and if count=1, get the message
580: FND_MSG_PUB.Count_And_Get (
581: p_encoded => FND_API.G_FALSE,
582: p_count => x_msg_count,
583: p_data => x_msg_data

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

585:
586: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
587: ROLLBACK TO CREATE_Ctd_PVT;
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: -- Standard call to get message count and if count=1, get the message
590: FND_MSG_PUB.Count_And_Get (
591: p_encoded => FND_API.G_FALSE,
592: p_count => x_msg_count,
593: p_data => x_msg_data

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

599: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
600: THEN
601: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
602: END IF;
603: -- Standard call to get message count and if count=1, get the message
604: FND_MSG_PUB.Count_And_Get (
605: p_encoded => FND_API.G_FALSE,
606: p_count => x_msg_count,
607: p_data => x_msg_data

Line 641: -- Standard Start of API savepoint

637: l_tar_ctd_rec AMS_Ctd_PVT.ctd_rec_type := P_ctd_rec;
638: l_rowid ROWID;
639:
640: BEGIN
641: -- Standard Start of API savepoint
642: SAVEPOINT UPDATE_Ctd_PVT;
643:
644: -- Standard call to check for call compatibility.
645: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

640: BEGIN
641: -- Standard Start of API savepoint
642: SAVEPOINT UPDATE_Ctd_PVT;
643:
644: -- Standard call to check for call compatibility.
645: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
646: p_api_version_number,
647: l_api_name,
648: G_PKG_NAME)

Line 743: -- Standard check for p_commit

739: --
740: -- End of API body.
741: --
742:
743: -- Standard check for p_commit
744: IF FND_API.to_Boolean( p_commit )
745: THEN
746: COMMIT WORK;
747: END IF;

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

749:
750: -- Debug Message
751: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
752:
753: -- Standard call to get message count and if count is 1, get message info.
754: FND_MSG_PUB.Count_And_Get
755: (p_count => x_msg_count,
756: p_data => x_msg_data
757: );

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

763:
764: WHEN FND_API.G_EXC_ERROR THEN
765: ROLLBACK TO UPDATE_Ctd_PVT;
766: x_return_status := FND_API.G_RET_STS_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

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

773:
774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
775: ROLLBACK TO UPDATE_Ctd_PVT;
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: -- Standard call to get message count and if count=1, get the message
778: FND_MSG_PUB.Count_And_Get (
779: p_encoded => FND_API.G_FALSE,
780: p_count => x_msg_count,
781: p_data => x_msg_data

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

787: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
788: THEN
789: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
790: END IF;
791: -- Standard call to get message count and if count=1, get the message
792: FND_MSG_PUB.Count_And_Get (
793: p_encoded => FND_API.G_FALSE,
794: p_count => x_msg_count,
795: p_data => x_msg_data

Line 818: -- Standard Start of API savepoint

814: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
815: l_object_version_number NUMBER;
816:
817: BEGIN
818: -- Standard Start of API savepoint
819: SAVEPOINT DELETE_Ctd_PVT;
820:
821: -- Standard call to check for call compatibility.
822: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

817: BEGIN
818: -- Standard Start of API savepoint
819: SAVEPOINT DELETE_Ctd_PVT;
820:
821: -- Standard call to check for call compatibility.
822: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
823: p_api_version_number,
824: l_api_name,
825: G_PKG_NAME)

Line 856: -- Standard check for p_commit

852: --
853: -- End of API body
854: --
855:
856: -- Standard check for p_commit
857: IF FND_API.to_Boolean( p_commit )
858: THEN
859: COMMIT WORK;
860: END IF;

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

862:
863: -- Debug Message
864: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
865:
866: -- Standard call to get message count and if count is 1, get message info.
867: FND_MSG_PUB.Count_And_Get
868: (p_count => x_msg_count,
869: p_data => x_msg_data
870: );

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

876:
877: WHEN FND_API.G_EXC_ERROR THEN
878: ROLLBACK TO DELETE_Ctd_PVT;
879: x_return_status := FND_API.G_RET_STS_ERROR;
880: -- Standard call to get message count and if count=1, get the message
881: FND_MSG_PUB.Count_And_Get (
882: p_encoded => FND_API.G_FALSE,
883: p_count => x_msg_count,
884: p_data => x_msg_data

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

886:
887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
888: ROLLBACK TO DELETE_Ctd_PVT;
889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
890: -- Standard call to get message count and if count=1, get the message
891: FND_MSG_PUB.Count_And_Get (
892: p_encoded => FND_API.G_FALSE,
893: p_count => x_msg_count,
894: p_data => x_msg_data

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

900: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
901: THEN
902: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
903: END IF;
904: -- Standard call to get message count and if count=1, get the message
905: FND_MSG_PUB.Count_And_Get (
906: p_encoded => FND_API.G_FALSE,
907: p_count => x_msg_count,
908: p_data => x_msg_data

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

947: THEN
948: FND_MSG_PUB.initialize;
949: END IF;
950:
951: -- Standard call to check for call compatibility.
952: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
953: p_api_version_number,
954: l_api_name,
955: G_PKG_NAME)

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

994:
995: WHEN FND_API.G_EXC_ERROR THEN
996: ROLLBACK TO LOCK_Ctd_PVT;
997: x_return_status := FND_API.G_RET_STS_ERROR;
998: -- Standard call to get message count and if count=1, get the message
999: FND_MSG_PUB.Count_And_Get (
1000: p_encoded => FND_API.G_FALSE,
1001: p_count => x_msg_count,
1002: p_data => x_msg_data

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

1004:
1005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1006: ROLLBACK TO LOCK_Ctd_PVT;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: -- Standard call to get message count and if count=1, get the message
1009: FND_MSG_PUB.Count_And_Get (
1010: p_encoded => FND_API.G_FALSE,
1011: p_count => x_msg_count,
1012: p_data => x_msg_data

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

1018: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1019: THEN
1020: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1021: END IF;
1022: -- Standard call to get message count and if count=1, get the message
1023: FND_MSG_PUB.Count_And_Get (
1024: p_encoded => FND_API.G_FALSE,
1025: p_count => x_msg_count,
1026: p_data => x_msg_data

Line 1347: -- Standard Start of API savepoint

1343: l_object_version_number NUMBER;
1344: l_ctd_rec AMS_Ctd_PVT.ctd_rec_type;
1345:
1346: BEGIN
1347: -- Standard Start of API savepoint
1348: SAVEPOINT VALIDATE_Ctd_;
1349:
1350: -- Standard call to check for call compatibility.
1351: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1346: BEGIN
1347: -- Standard Start of API savepoint
1348: SAVEPOINT VALIDATE_Ctd_;
1349:
1350: -- Standard call to check for call compatibility.
1351: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1352: p_api_version_number,
1353: l_api_name,
1354: G_PKG_NAME)

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

1407:
1408: -- Debug Message
1409: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1410:
1411: -- Standard call to get message count and if count is 1, get message info.
1412: FND_MSG_PUB.Count_And_Get
1413: (p_count => x_msg_count,
1414: p_data => x_msg_data
1415: );

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

1421:
1422: WHEN FND_API.G_EXC_ERROR THEN
1423: ROLLBACK TO VALIDATE_Ctd_;
1424: x_return_status := FND_API.G_RET_STS_ERROR;
1425: -- Standard call to get message count and if count=1, get the message
1426: FND_MSG_PUB.Count_And_Get (
1427: p_encoded => FND_API.G_FALSE,
1428: p_count => x_msg_count,
1429: p_data => x_msg_data

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

1431:
1432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1433: ROLLBACK TO VALIDATE_Ctd_;
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1435: -- Standard call to get message count and if count=1, get the message
1436: FND_MSG_PUB.Count_And_Get (
1437: p_encoded => FND_API.G_FALSE,
1438: p_count => x_msg_count,
1439: p_data => x_msg_data

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

1445: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1446: THEN
1447: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1448: END IF;
1449: -- Standard call to get message count and if count=1, get the message
1450: FND_MSG_PUB.Count_And_Get (
1451: p_encoded => FND_API.G_FALSE,
1452: p_count => x_msg_count,
1453: p_data => x_msg_data

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

1480: -- x_return_status := FND_API.G_RET_STS_ERROR;
1481:
1482: -- Debug Message
1483: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1484: -- Standard call to get message count and if count is 1, get message info.
1485: FND_MSG_PUB.Count_And_Get
1486: (p_count => x_msg_count,
1487: p_data => x_msg_data
1488: );