[Home] [Help]
70: -- x_return_status OUT VARCHAR2
71: -- x_msg_count OUT NUMBER
72: -- x_msg_data OUT VARCHAR2
73: -- Version : Current version 1.0
74: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
75: -- and basic operation, developer must manually add parameters and business logic as necessary.
76: --
77: -- History
78: --
206:
207: WHEN Fnd_Api.G_EXC_ERROR THEN
208: x_return_status := Fnd_Api.G_RET_STS_ERROR;
209:
210: -- Standard call to get message count and if count=1, get the message
211: Fnd_Msg_Pub.Count_And_Get (
212: p_encoded => Fnd_Api.G_FALSE
213: ,p_count => x_msg_count
214: ,p_data => x_msg_data
215: );
216:
217: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
218: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
219: -- Standard call to get message count and if count=1, get the message
220: Fnd_Msg_Pub.Count_And_Get (
221: p_encoded => Fnd_Api.G_FALSE
222: ,p_count => x_msg_count
223: ,p_data => x_msg_data
228: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
229: THEN
230: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME, l_api_name);
231: END IF;
232: -- Standard call to get message count and if count=1, get the message
233: Fnd_Msg_Pub.Count_And_Get (
234: p_encoded => Fnd_Api.G_FALSE
235: ,p_count => x_msg_count
236: ,p_data => x_msg_data
315: SELECT 1
316: FROM PV_PG_ENRL_REQUESTS
317: WHERE enrl_request_id = l_id;
318: BEGIN
319: -- Standard Start of API savepoint
320: SAVEPOINT create_pg_enrl_requests_pvt;
321:
322: -- Standard call to check for call compatibility.
323: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
318: BEGIN
319: -- Standard Start of API savepoint
320: SAVEPOINT create_pg_enrl_requests_pvt;
321:
322: -- Standard call to check for call compatibility.
323: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
324: p_api_version_number,
325: l_api_name,
326: G_PKG_NAME)
488: --
489: -- End of API body
490: --
491:
492: -- Standard check for p_commit
493: IF Fnd_Api.to_Boolean( p_commit )
494: THEN
495: COMMIT WORK;
496: END IF;
502: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'END');
503: END IF;
504:
505:
506: -- Standard call to get message count and if count is 1, get message info.
507: Fnd_Msg_Pub.Count_And_Get
508: (p_count => x_msg_count,
509: p_data => x_msg_data
510: );
517:
518: WHEN Fnd_Api.G_EXC_ERROR THEN
519: ROLLBACK TO CREATE_Pg_Enrl_Requests_PVT;
520: x_return_status := Fnd_Api.G_RET_STS_ERROR;
521: -- Standard call to get message count and if count=1, get the message
522: Fnd_Msg_Pub.Count_And_Get (
523: p_encoded => Fnd_Api.G_FALSE,
524: p_count => x_msg_count,
525: p_data => x_msg_data
527:
528: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
529: ROLLBACK TO CREATE_Pg_Enrl_Requests_PVT;
530: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
531: -- Standard call to get message count and if count=1, get the message
532: Fnd_Msg_Pub.Count_And_Get (
533: p_encoded => Fnd_Api.G_FALSE,
534: p_count => x_msg_count,
535: p_data => x_msg_data
541: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
542: THEN
543: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
544: END IF;
545: -- Standard call to get message count and if count=1, get the message
546: Fnd_Msg_Pub.Count_And_Get (
547: p_encoded => Fnd_Api.G_FALSE,
548: p_count => x_msg_count,
549: p_data => x_msg_data
573: -- x_return_status OUT VARCHAR2
574: -- x_msg_count OUT NUMBER
575: -- x_msg_data OUT VARCHAR2
576: -- Version : Current version 1.0
577: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
578: -- and basic operation, developer must manually add parameters and business logic as necessary.
579: --
580: -- History
581: --
616: l_tar_enrl_request_rec enrl_request_rec_type := P_enrl_request_rec;
617: l_rowid ROWID;
618:
619: BEGIN
620: -- Standard Start of API savepoint
621: SAVEPOINT update_pg_enrl_requests_pvt;
622:
623: -- Standard call to check for call compatibility.
624: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
619: BEGIN
620: -- Standard Start of API savepoint
621: SAVEPOINT update_pg_enrl_requests_pvt;
622:
623: -- Standard call to check for call compatibility.
624: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
625: p_api_version_number,
626: l_api_name,
627: G_PKG_NAME)
774: --
775: -- End of API body.
776: --
777:
778: -- Standard check for p_commit
779: IF Fnd_Api.to_Boolean( p_commit )
780: THEN
781: COMMIT WORK;
782: END IF;
788: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'END');
789: END IF;
790:
791:
792: -- Standard call to get message count and if count is 1, get message info.
793: Fnd_Msg_Pub.Count_And_Get
794: (p_count => x_msg_count,
795: p_data => x_msg_data
796: );
830: FND_MSG_PUB.Add;
831: WHEN Fnd_Api.G_EXC_ERROR THEN
832: ROLLBACK TO UPDATE_Pg_Enrl_Requests_PVT;
833: x_return_status := Fnd_Api.G_RET_STS_ERROR;
834: -- Standard call to get message count and if count=1, get the message
835: Fnd_Msg_Pub.Count_And_Get (
836: p_encoded => Fnd_Api.G_FALSE,
837: p_count => x_msg_count,
838: p_data => x_msg_data
840:
841: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
842: ROLLBACK TO UPDATE_Pg_Enrl_Requests_PVT;
843: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
844: -- Standard call to get message count and if count=1, get the message
845: Fnd_Msg_Pub.Count_And_Get (
846: p_encoded => Fnd_Api.G_FALSE,
847: p_count => x_msg_count,
848: p_data => x_msg_data
854: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
855: THEN
856: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
857: END IF;
858: -- Standard call to get message count and if count=1, get the message
859: Fnd_Msg_Pub.Count_And_Get (
860: p_encoded => Fnd_Api.G_FALSE,
861: p_count => x_msg_count,
862: p_data => x_msg_data
887: -- x_return_status OUT VARCHAR2
888: -- x_msg_count OUT NUMBER
889: -- x_msg_data OUT VARCHAR2
890: -- Version : Current version 1.0
891: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
892: -- and basic operation, developer must manually add parameters and business logic as necessary.
893: --
894: -- History
895: --
915: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
916: l_object_version_number NUMBER;
917:
918: BEGIN
919: -- Standard Start of API savepoint
920: SAVEPOINT delete_pg_enrl_requests_pvt;
921:
922: -- Standard call to check for call compatibility.
923: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
918: BEGIN
919: -- Standard Start of API savepoint
920: SAVEPOINT delete_pg_enrl_requests_pvt;
921:
922: -- Standard call to check for call compatibility.
923: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
924: p_api_version_number,
925: l_api_name,
926: G_PKG_NAME)
964: --
965: -- End of API body
966: --
967:
968: -- Standard check for p_commit
969: IF Fnd_Api.to_Boolean( p_commit )
970: THEN
971: COMMIT WORK;
972: END IF;
978: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'END');
979: END IF;
980:
981:
982: -- Standard call to get message count and if count is 1, get message info.
983: Fnd_Msg_Pub.Count_And_Get
984: (p_count => x_msg_count,
985: p_data => x_msg_data
986: );
993:
994: WHEN Fnd_Api.G_EXC_ERROR THEN
995: ROLLBACK TO DELETE_Pg_Enrl_Requests_PVT;
996: x_return_status := Fnd_Api.G_RET_STS_ERROR;
997: -- Standard call to get message count and if count=1, get the message
998: Fnd_Msg_Pub.Count_And_Get (
999: p_encoded => Fnd_Api.G_FALSE,
1000: p_count => x_msg_count,
1001: p_data => x_msg_data
1003:
1004: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1005: ROLLBACK TO DELETE_Pg_Enrl_Requests_PVT;
1006: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1007: -- Standard call to get message count and if count=1, get the message
1008: Fnd_Msg_Pub.Count_And_Get (
1009: p_encoded => Fnd_Api.G_FALSE,
1010: p_count => x_msg_count,
1011: p_data => x_msg_data
1017: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1018: THEN
1019: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1020: END IF;
1021: -- Standard call to get message count and if count=1, get the message
1022: Fnd_Msg_Pub.Count_And_Get (
1023: p_encoded => Fnd_Api.G_FALSE,
1024: p_count => x_msg_count,
1025: p_data => x_msg_data
1051: -- x_return_status OUT VARCHAR2
1052: -- x_msg_count OUT NUMBER
1053: -- x_msg_data OUT VARCHAR2
1054: -- Version : Current version 1.0
1055: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
1056: -- and basic operation, developer must manually add parameters and business logic as necessary.
1057: --
1058: -- History
1059: --
1096: END IF;
1097:
1098:
1099:
1100: -- Standard call to check for call compatibility.
1101: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
1102: p_api_version_number,
1103: l_api_name,
1104: G_PKG_NAME)
1134:
1135: WHEN Fnd_Api.G_EXC_ERROR THEN
1136: ROLLBACK TO LOCK_Pg_Enrl_Requests_PVT;
1137: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1138: -- Standard call to get message count and if count=1, get the message
1139: Fnd_Msg_Pub.Count_And_Get (
1140: p_encoded => Fnd_Api.G_FALSE,
1141: p_count => x_msg_count,
1142: p_data => x_msg_data
1144:
1145: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1146: ROLLBACK TO LOCK_Pg_Enrl_Requests_PVT;
1147: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1148: -- Standard call to get message count and if count=1, get the message
1149: Fnd_Msg_Pub.Count_And_Get (
1150: p_encoded => Fnd_Api.G_FALSE,
1151: p_count => x_msg_count,
1152: p_data => x_msg_data
1158: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1159: THEN
1160: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1161: END IF;
1162: -- Standard call to get message count and if count=1, get the message
1163: Fnd_Msg_Pub.Count_And_Get (
1164: p_encoded => Fnd_Api.G_FALSE,
1165: p_count => x_msg_count,
1166: p_data => x_msg_data
1625: l_enrl_request_rec enrl_request_rec_type;
1626: l_enrl_request_rec_out enrl_request_rec_type;
1627:
1628: BEGIN
1629: -- Standard Start of API savepoint
1630: SAVEPOINT validate_pg_enrl_requests_;
1631:
1632: -- Standard call to check for call compatibility.
1633: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
1628: BEGIN
1629: -- Standard Start of API savepoint
1630: SAVEPOINT validate_pg_enrl_requests_;
1631:
1632: -- Standard call to check for call compatibility.
1633: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
1634: p_api_version_number,
1635: l_api_name,
1636: G_PKG_NAME)
1708: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'END');
1709: END IF;
1710:
1711:
1712: -- Standard call to get message count and if count is 1, get message info.
1713: Fnd_Msg_Pub.Count_And_Get
1714: (p_count => x_msg_count,
1715: p_data => x_msg_data
1716: );
1723:
1724: WHEN Fnd_Api.G_EXC_ERROR THEN
1725: ROLLBACK TO VALIDATE_Pg_Enrl_Requests_;
1726: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1727: -- Standard call to get message count and if count=1, get the message
1728: Fnd_Msg_Pub.Count_And_Get (
1729: p_encoded => Fnd_Api.G_FALSE,
1730: p_count => x_msg_count,
1731: p_data => x_msg_data
1733:
1734: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1735: ROLLBACK TO VALIDATE_Pg_Enrl_Requests_;
1736: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1737: -- Standard call to get message count and if count=1, get the message
1738: Fnd_Msg_Pub.Count_And_Get (
1739: p_encoded => Fnd_Api.G_FALSE,
1740: p_count => x_msg_count,
1741: p_data => x_msg_data
1747: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1748: THEN
1749: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1750: END IF;
1751: -- Standard call to get message count and if count=1, get the message
1752: Fnd_Msg_Pub.Count_And_Get (
1753: p_encoded => Fnd_Api.G_FALSE,
1754: p_count => x_msg_count,
1755: p_data => x_msg_data
1787: IF (PV_DEBUG_HIGH_ON) THEN
1788:
1789: Pvx_Utility_Pvt.debug_message('PRIVATE API: Validate_dm_model_rec');
1790: END IF;
1791: -- Standard call to get message count and if count is 1, get message info.
1792: Fnd_Msg_Pub.Count_And_Get
1793: (p_count => x_msg_count,
1794: p_data => x_msg_data
1795: );