DBA Data[Home] [Help]

APPS.PV_PEC_RULES_PVT dependencies on STANDARD

Line 60: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

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

Line 137: -- Standard Start of API savepoint

133: PVX_UTILITY_PVT.debug_message('Inside Create Proc ');
134:
135: END IF;
136:
137: -- Standard Start of API savepoint
138: SAVEPOINT create_pec_rules_pvt;
139:
140: IF (PV_DEBUG_HIGH_ON) THEN
141:

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

147:
148:
149:
150:
151: -- Standard call to check for call compatibility.
152: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
153: p_api_version_number,
154: l_api_name,
155: G_PKG_NAME)

Line 384: -- Standard check for p_commit

380: --
381: -- End of API body
382: --
383:
384: -- Standard check for p_commit
385: IF FND_API.to_Boolean( p_commit )
386: THEN
387: COMMIT WORK;
388: END IF;

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

395: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
396: END IF;
397:
398:
399: -- Standard call to get message count and if count is 1, get message info.
400: FND_MSG_PUB.Count_And_Get
401: (p_count => x_msg_count,
402: p_data => x_msg_data
403: );

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

411:
412: WHEN FND_API.G_EXC_ERROR THEN
413: ROLLBACK TO CREATE_Pec_Rules_PVT;
414: x_return_status := FND_API.G_RET_STS_ERROR;
415: -- Standard call to get message count and if count=1, get the message
416: FND_MSG_PUB.Count_And_Get (
417: p_encoded => FND_API.G_FALSE,
418: p_count => x_msg_count,
419: p_data => x_msg_data

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

421:
422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
423: ROLLBACK TO CREATE_Pec_Rules_PVT;
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
425: -- Standard call to get message count and if count=1, get the message
426: FND_MSG_PUB.Count_And_Get (
427: p_encoded => FND_API.G_FALSE,
428: p_count => x_msg_count,
429: p_data => x_msg_data

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

435: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
436: THEN
437: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
438: END IF;
439: -- Standard call to get message count and if count=1, get the message
440: FND_MSG_PUB.Count_And_Get (
441: p_encoded => FND_API.G_FALSE,
442: p_count => x_msg_count,
443: p_data => x_msg_data

Line 471: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

467: -- x_return_status OUT VARCHAR2
468: -- x_msg_count OUT NUMBER
469: -- x_msg_data OUT VARCHAR2
470: -- Version : Current version 1.0
471: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
472: -- and basic operation, developer must manually add parameters and business logic as necessary.
473: --
474: -- History
475: --

Line 528: -- Standard Start of API savepoint

524:
525:
526:
527: BEGIN
528: -- Standard Start of API savepoint
529: SAVEPOINT update_pec_rules_pvt;
530:
531: -- Standard call to check for call compatibility.
532: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

527: BEGIN
528: -- Standard Start of API savepoint
529: SAVEPOINT update_pec_rules_pvt;
530:
531: -- Standard call to check for call compatibility.
532: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
533: p_api_version_number,
534: l_api_name,
535: G_PKG_NAME)

Line 673: -- Standard check for p_commit

669: END IF;
670: -- End of API body.
671: --
672:
673: -- Standard check for p_commit
674: IF FND_API.to_Boolean( p_commit )
675: THEN
676: COMMIT WORK;
677: END IF;

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

683: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
684: END IF;
685:
686:
687: -- Standard call to get message count and if count is 1, get message info.
688: FND_MSG_PUB.Count_And_Get
689: (p_count => x_msg_count,
690: p_data => x_msg_data
691: );

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

697:
698: WHEN FND_API.G_EXC_ERROR THEN
699: ROLLBACK TO UPDATE_Pec_Rules_PVT;
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: -- Standard call to get message count and if count=1, get the message
702: FND_MSG_PUB.Count_And_Get (
703: p_encoded => FND_API.G_FALSE,
704: p_count => x_msg_count,
705: p_data => x_msg_data

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

707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: ROLLBACK TO UPDATE_Pec_Rules_PVT;
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: -- Standard call to get message count and if count=1, get the message
712: FND_MSG_PUB.Count_And_Get (
713: p_encoded => FND_API.G_FALSE,
714: p_count => x_msg_count,
715: p_data => x_msg_data

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

721: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
722: THEN
723: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
724: END IF;
725: -- Standard call to get message count and if count=1, get the message
726: FND_MSG_PUB.Count_And_Get (
727: p_encoded => FND_API.G_FALSE,
728: p_count => x_msg_count,
729: p_data => x_msg_data

Line 758: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

754: -- x_return_status OUT VARCHAR2
755: -- x_msg_count OUT NUMBER
756: -- x_msg_data OUT VARCHAR2
757: -- Version : Current version 1.0
758: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
759: -- and basic operation, developer must manually add parameters and business logic as necessary.
760: --
761: -- History
762: --

Line 805: -- Standard Start of API savepoint

801: from_id_rev NUMBER;
802: to_id_rev NUMBER;
803:
804: BEGIN
805: -- Standard Start of API savepoint
806: SAVEPOINT delete_pec_rules_pvt;
807:
808: -- Standard call to check for call compatibility.
809: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

804: BEGIN
805: -- Standard Start of API savepoint
806: SAVEPOINT delete_pec_rules_pvt;
807:
808: -- Standard call to check for call compatibility.
809: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
810: p_api_version_number,
811: l_api_name,
812: G_PKG_NAME)

Line 951: -- Standard check for p_commit

947:
948: END LOOP;
949: END IF;
950:
951: -- Standard check for p_commit
952: IF FND_API.to_Boolean( p_commit )
953: THEN
954: COMMIT WORK;
955: END IF;

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

961: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
962: END IF;
963:
964:
965: -- Standard call to get message count and if count is 1, get message info.
966: FND_MSG_PUB.Count_And_Get
967: (p_count => x_msg_count,
968: p_data => x_msg_data
969: );

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

975:
976: WHEN FND_API.G_EXC_ERROR THEN
977: ROLLBACK TO DELETE_Pec_Rules_PVT;
978: x_return_status := FND_API.G_RET_STS_ERROR;
979: -- Standard call to get message count and if count=1, get the message
980: FND_MSG_PUB.Count_And_Get (
981: p_encoded => FND_API.G_FALSE,
982: p_count => x_msg_count,
983: p_data => x_msg_data

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

985:
986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
987: ROLLBACK TO DELETE_Pec_Rules_PVT;
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: -- Standard call to get message count and if count=1, get the message
990: FND_MSG_PUB.Count_And_Get (
991: p_encoded => FND_API.G_FALSE,
992: p_count => x_msg_count,
993: p_data => x_msg_data

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

999: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1000: THEN
1001: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1002: END IF;
1003: -- Standard call to get message count and if count=1, get the message
1004: FND_MSG_PUB.Count_And_Get (
1005: p_encoded => FND_API.G_FALSE,
1006: p_count => x_msg_count,
1007: p_data => x_msg_data

Line 1037: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

1033: -- x_return_status OUT VARCHAR2
1034: -- x_msg_count OUT NUMBER
1035: -- x_msg_data OUT VARCHAR2
1036: -- Version : Current version 1.0
1037: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
1038: -- and basic operation, developer must manually add parameters and business logic as necessary.
1039: --
1040: -- History
1041: --

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

1078: END IF;
1079:
1080:
1081:
1082: -- Standard call to check for call compatibility.
1083: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1084: p_api_version_number,
1085: l_api_name,
1086: G_PKG_NAME)

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

1115:
1116: WHEN FND_API.G_EXC_ERROR THEN
1117: ROLLBACK TO LOCK_Pec_Rules_PVT;
1118: x_return_status := FND_API.G_RET_STS_ERROR;
1119: -- Standard call to get message count and if count=1, get the message
1120: FND_MSG_PUB.Count_And_Get (
1121: p_encoded => FND_API.G_FALSE,
1122: p_count => x_msg_count,
1123: p_data => x_msg_data

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

1125:
1126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1127: ROLLBACK TO LOCK_Pec_Rules_PVT;
1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1129: -- Standard call to get message count and if count=1, get the message
1130: FND_MSG_PUB.Count_And_Get (
1131: p_encoded => FND_API.G_FALSE,
1132: p_count => x_msg_count,
1133: p_data => x_msg_data

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

1139: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1140: THEN
1141: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1142: END IF;
1143: -- Standard call to get message count and if count=1, get the message
1144: FND_MSG_PUB.Count_And_Get (
1145: p_encoded => FND_API.G_FALSE,
1146: p_count => x_msg_count,
1147: p_data => x_msg_data

Line 1562: -- Standard Start of API savepoint

1558: PVX_UTILITY_PVT.debug_message('Inside Validate ');
1559:
1560: END IF;
1561:
1562: -- Standard Start of API savepoint
1563: SAVEPOINT validate_pec_rules_;
1564:
1565: -- Standard call to check for call compatibility.
1566: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1561:
1562: -- Standard Start of API savepoint
1563: SAVEPOINT validate_pec_rules_;
1564:
1565: -- Standard call to check for call compatibility.
1566: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1567: p_api_version_number,
1568: l_api_name,
1569: G_PKG_NAME)

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

1687: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1688: END IF;
1689:
1690:
1691: -- Standard call to get message count and if count is 1, get message info.
1692: FND_MSG_PUB.Count_And_Get
1693: (p_count => x_msg_count,
1694: p_data => x_msg_data
1695: );

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

1701:
1702: WHEN FND_API.G_EXC_ERROR THEN
1703: ROLLBACK TO VALIDATE_Pec_Rules_;
1704: x_return_status := FND_API.G_RET_STS_ERROR;
1705: -- Standard call to get message count and if count=1, get the message
1706: FND_MSG_PUB.Count_And_Get (
1707: p_encoded => FND_API.G_FALSE,
1708: p_count => x_msg_count,
1709: p_data => x_msg_data

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

1711:
1712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1713: ROLLBACK TO VALIDATE_Pec_Rules_;
1714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1715: -- Standard call to get message count and if count=1, get the message
1716: FND_MSG_PUB.Count_And_Get (
1717: p_encoded => FND_API.G_FALSE,
1718: p_count => x_msg_count,
1719: p_data => x_msg_data

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

1725: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1726: THEN
1727: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1728: END IF;
1729: -- Standard call to get message count and if count=1, get the message
1730: FND_MSG_PUB.Count_And_Get (
1731: p_encoded => FND_API.G_FALSE,
1732: p_count => x_msg_count,
1733: p_data => x_msg_data

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

1765: IF (PV_DEBUG_HIGH_ON) THEN
1766:
1767: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1768: END IF;
1769: -- Standard call to get message count and if count is 1, get message info.
1770: FND_MSG_PUB.Count_And_Get
1771: (p_count => x_msg_count,
1772: p_data => x_msg_data
1773: );