eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PG_ENRL_REQUESTS_PVT dependencies on FND_MSG_PUB

Line 84: PV_DEBUG_HIGH_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_HIGH);

80: --
81: -- End of Comments
82: -- ==============================================================================
83:
84: PV_DEBUG_HIGH_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_HIGH);
85: PV_DEBUG_LOW_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW);
86: PV_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_MEDIUM);
87:
88:

Line 85: PV_DEBUG_LOW_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW);

81: -- End of Comments
82: -- ==============================================================================
83:
84: PV_DEBUG_HIGH_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_HIGH);
85: PV_DEBUG_LOW_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW);
86: PV_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_MEDIUM);
87:
88:
89: FUNCTION Is_Payment_Exists(p_enrl_request_rec IN OUT NOCOPY enrl_request_rec_type)

Line 86: PV_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_MEDIUM);

82: -- ==============================================================================
83:
84: PV_DEBUG_HIGH_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_HIGH);
85: PV_DEBUG_LOW_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_LOW);
86: PV_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := Fnd_Msg_Pub.CHECK_MSG_LEVEL(Fnd_Msg_Pub.G_MSG_LVL_DEBUG_MEDIUM);
87:
88:
89: FUNCTION Is_Payment_Exists(p_enrl_request_rec IN OUT NOCOPY enrl_request_rec_type)
90: RETURN VARCHAR2 IS

Line 193: FND_MSG_PUB.Count_And_Get

189: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192:
193: FND_MSG_PUB.Count_And_Get
194: ( p_encoded => FND_API.G_FALSE,
195: p_count => x_msg_count,
196: p_data => x_msg_data
197: );

Line 211: Fnd_Msg_Pub.Count_And_Get (

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

Line 220: Fnd_Msg_Pub.Count_And_Get (

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

Line 228: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

224: );
225:
226: WHEN OTHERS THEN
227: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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

Line 230: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME, l_api_name);

226: WHEN OTHERS THEN
227: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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

Line 233: Fnd_Msg_Pub.Count_And_Get (

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

Line 335: Fnd_Msg_Pub.initialize;

331:
332: -- Initialize message list if p_init_msg_list is set to TRUE.
333: IF Fnd_Api.to_Boolean( p_init_msg_list )
334: THEN
335: Fnd_Msg_Pub.initialize;
336: END IF;
337:
338:
339:

Line 358: FND_MSG_PUB.Add;

354:
355: IF Fnd_Global.USER_ID IS NULL
356: THEN
357: FND_MESSAGE.Set_Name ('PV', 'USER_PROFILE_MISSING');
358: FND_MSG_PUB.Add;
359: RAISE Fnd_Api.G_EXC_ERROR;
360: END IF;
361:
362:

Line 507: Fnd_Msg_Pub.Count_And_Get

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

Line 516: FND_MSG_PUB.Add;

512:
513: WHEN Pvx_Utility_Pvt.resource_locked THEN
514: x_return_status := Fnd_Api.g_ret_sts_error;
515: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
516: FND_MSG_PUB.Add;
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;

Line 522: Fnd_Msg_Pub.Count_And_Get (

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

Line 532: Fnd_Msg_Pub.Count_And_Get (

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

Line 541: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

537:
538: WHEN OTHERS THEN
539: ROLLBACK TO CREATE_Pg_Enrl_Requests_PVT;
540: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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

Line 543: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

539: ROLLBACK TO CREATE_Pg_Enrl_Requests_PVT;
540: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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,

Line 546: Fnd_Msg_Pub.Count_And_Get (

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

Line 636: Fnd_Msg_Pub.initialize;

632:
633: -- Initialize message list if p_init_msg_list is set to TRUE.
634: IF Fnd_Api.to_Boolean( p_init_msg_list )
635: THEN
636: Fnd_Msg_Pub.initialize;
637: END IF;
638:
639:
640:

Line 665: FND_MSG_PUB.Add;

661:
662: IF ( c_get_Pg_Enrl_Requests%NOTFOUND) THEN
663: FND_MESSAGE.Set_Name ('PV', 'API_MISSING_UPDATE_TARGET');
664: FND_MESSAGE.Set_Token('INFO', 'Pg_Enrl_Requests');
665: FND_MSG_PUB.Add;
666: RAISE Fnd_Api.G_EXC_ERROR;
667: END IF;
668: -- Debug Message
669: IF (PV_DEBUG_HIGH_ON) THEN

Line 680: FND_MSG_PUB.Add;

676: IF (l_tar_enrl_request_rec.object_version_number IS NULL OR
677: l_tar_enrl_request_rec.object_version_number = Fnd_Api.G_MISS_NUM ) THEN
678: FND_MESSAGE.Set_Name ('PV', 'API_VERSION_MISSING');
679: FND_MESSAGE.Set_Token('INFO', 'Pg_Enrl_Requests');
680: FND_MSG_PUB.Add;
681: RAISE Fnd_Api.G_EXC_ERROR;
682: END IF;
683: -- Check Whether record has been changed by someone else
684: IF (l_tar_enrl_request_rec.object_version_number <> l_ref_enrl_request_rec.object_version_number) THEN

Line 687: FND_MSG_PUB.Add;

683: -- Check Whether record has been changed by someone else
684: IF (l_tar_enrl_request_rec.object_version_number <> l_ref_enrl_request_rec.object_version_number) THEN
685: FND_MESSAGE.Set_Name ('PV', 'API_RECORD_CHANGED');
686: FND_MESSAGE.Set_Token('INFO', 'Pg_Enrl_Requests');
687: FND_MSG_PUB.Add;
688: RAISE Fnd_Api.G_EXC_ERROR;
689: END IF;
690:
691:

Line 725: FND_MSG_PUB.add;

721: END IF;
722:
723: IF p_enrl_request_rec.tentative_end_date is not null and ( p_enrl_request_rec.tentative_start_date>p_enrl_request_rec.tentative_end_date ) THEN
724: FND_MESSAGE.set_name('PV', 'PV_END_DATE_SMALL_START_DATE');
725: FND_MSG_PUB.add;
726: RAISE FND_API.G_EXC_ERROR;
727: END IF;
728:
729: -- Invoke table handler(Pv_Pg_Enrl_Requests_Pkg.Update_Row)

Line 793: Fnd_Msg_Pub.Count_And_Get

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

Line 808: FND_MSG_PUB.Add;

804: FETCH c_get_Pg_Enrl_Requests INTO l_ref_enrl_request_rec;
805: IF ( c_get_Pg_Enrl_Requests%NOTFOUND) THEN
806: FND_MESSAGE.Set_Name ('PV', 'API_MISSING_UPDATE_TARGET');
807: FND_MESSAGE.Set_Token('INFO', 'Pg_Enrl_Requests');
808: FND_MSG_PUB.Add;
809: END IF;
810: -- Debug Message
811: IF (PV_DEBUG_HIGH_ON) THEN
812: Pvx_Utility_Pvt.debug_message('PRIVATE API: - CLOSE CURSOR');

Line 819: FND_MSG_PUB.Add;

815: IF (l_tar_enrl_request_rec.object_version_number <> l_ref_enrl_request_rec.object_version_number) THEN
816: x_return_status := Fnd_Api.G_RET_STS_ERROR;
817: FND_MESSAGE.Set_Name ('PV', 'API_RECORD_CHANGED');
818: FND_MESSAGE.Set_Token('INFO', 'Pv_Pg_Enrl_Requests');
819: FND_MSG_PUB.Add;
820: END IF;
821: Fnd_Msg_Pub.Count_And_Get (
822: p_encoded => Fnd_Api.G_FALSE,
823: p_count => x_msg_count,

Line 821: Fnd_Msg_Pub.Count_And_Get (

817: FND_MESSAGE.Set_Name ('PV', 'API_RECORD_CHANGED');
818: FND_MESSAGE.Set_Token('INFO', 'Pv_Pg_Enrl_Requests');
819: FND_MSG_PUB.Add;
820: END IF;
821: Fnd_Msg_Pub.Count_And_Get (
822: p_encoded => Fnd_Api.G_FALSE,
823: p_count => x_msg_count,
824: p_data => x_msg_data
825: );

Line 830: FND_MSG_PUB.Add;

826:
827: WHEN Pvx_Utility_Pvt.resource_locked THEN
828: x_return_status := Fnd_Api.g_ret_sts_error;
829: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
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

Line 835: Fnd_Msg_Pub.Count_And_Get (

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

Line 845: Fnd_Msg_Pub.Count_And_Get (

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

Line 854: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

850:
851: WHEN OTHERS THEN
852: ROLLBACK TO UPDATE_Pg_Enrl_Requests_PVT;
853: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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

Line 856: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

852: ROLLBACK TO UPDATE_Pg_Enrl_Requests_PVT;
853: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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,

Line 859: Fnd_Msg_Pub.Count_And_Get (

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

Line 935: Fnd_Msg_Pub.initialize;

931:
932: -- Initialize message list if p_init_msg_list is set to TRUE.
933: IF Fnd_Api.to_Boolean( p_init_msg_list )
934: THEN
935: Fnd_Msg_Pub.initialize;
936: END IF;
937:
938:
939:

Line 983: Fnd_Msg_Pub.Count_And_Get

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

Line 992: FND_MSG_PUB.Add;

988:
989: WHEN Pvx_Utility_Pvt.resource_locked THEN
990: x_return_status := Fnd_Api.g_ret_sts_error;
991: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
992: FND_MSG_PUB.Add;
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;

Line 998: Fnd_Msg_Pub.Count_And_Get (

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

Line 1008: Fnd_Msg_Pub.Count_And_Get (

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

Line 1017: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

1013:
1014: WHEN OTHERS THEN
1015: ROLLBACK TO DELETE_Pg_Enrl_Requests_PVT;
1016: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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

Line 1019: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1015: ROLLBACK TO DELETE_Pg_Enrl_Requests_PVT;
1016: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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,

Line 1022: Fnd_Msg_Pub.Count_And_Get (

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

Line 1095: Fnd_Msg_Pub.initialize;

1091:
1092: -- Initialize message list if p_init_msg_list is set to TRUE.
1093: IF Fnd_Api.to_Boolean( p_init_msg_list )
1094: THEN
1095: Fnd_Msg_Pub.initialize;
1096: END IF;
1097:
1098:
1099:

Line 1120: Fnd_Msg_Pub.count_and_get(

1116: Pv_Pg_Enrl_Requests_Pkg.Lock_Row(l_enrl_request_id,p_object_version);
1117:
1118:
1119: -------------------- finish --------------------------
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);
1124: IF (PV_DEBUG_HIGH_ON) THEN

Line 1133: FND_MSG_PUB.Add;

1129:
1130: WHEN Pvx_Utility_Pvt.resource_locked THEN
1131: x_return_status := Fnd_Api.g_ret_sts_error;
1132: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
1133: FND_MSG_PUB.Add;
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;

Line 1139: Fnd_Msg_Pub.Count_And_Get (

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

Line 1149: Fnd_Msg_Pub.Count_And_Get (

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

Line 1158: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

1154:
1155: WHEN OTHERS THEN
1156: ROLLBACK TO LOCK_Pg_Enrl_Requests_PVT;
1157: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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

Line 1160: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1156: ROLLBACK TO LOCK_Pg_Enrl_Requests_PVT;
1157: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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,

Line 1163: Fnd_Msg_Pub.Count_And_Get (

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

Line 1193: FND_MSG_PUB.Add;

1189: END IF;
1190:
1191: IF l_valid_flag = Fnd_Api.g_false THEN
1192: FND_MESSAGE.Set_Name ('PV', 'PV_enrl_request_id_DUPLICATE');
1193: FND_MSG_PUB.Add;
1194: END IF;
1195:
1196: END check_Enrl_Request_Uk_Items;
1197:

Line 1214: FND_MSG_PUB.Add;

1210:
1211: IF p_enrl_request_rec.program_id = Fnd_Api.G_MISS_NUM OR p_enrl_request_rec.program_id IS NULL THEN
1212: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1213: FND_MESSAGE.Set_Token('MISS_FIELD', 'PROGRAM_ID');
1214: FND_MSG_PUB.Add;
1215:
1216: x_return_status := Fnd_Api.g_ret_sts_error;
1217: END IF;
1218:

Line 1223: FND_MSG_PUB.Add;

1219:
1220: IF p_enrl_request_rec.partner_id = Fnd_Api.G_MISS_NUM OR p_enrl_request_rec.partner_id IS NULL THEN
1221: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1222: FND_MESSAGE.Set_Token('MISS_FIELD', 'PARTNER_ID');
1223: FND_MSG_PUB.Add;
1224: x_return_status := Fnd_Api.g_ret_sts_error;
1225: END IF;
1226:
1227: IF p_enrl_request_rec.requestor_resource_id = Fnd_Api.G_MISS_NUM OR p_enrl_request_rec.requestor_resource_id IS NULL THEN

Line 1230: FND_MSG_PUB.Add;

1226:
1227: IF p_enrl_request_rec.requestor_resource_id = Fnd_Api.G_MISS_NUM OR p_enrl_request_rec.requestor_resource_id IS NULL THEN
1228: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1229: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUESTOR_RESOURCE_ID');
1230: FND_MSG_PUB.Add;
1231: x_return_status := Fnd_Api.g_ret_sts_error;
1232: END IF;
1233:
1234:

Line 1238: FND_MSG_PUB.Add;

1234:
1235: IF p_enrl_request_rec.request_status_code = Fnd_Api.g_miss_char OR p_enrl_request_rec.request_status_code IS NULL THEN
1236: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1237: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUEST_STATUS_CODE');
1238: FND_MSG_PUB.Add;
1239: x_return_status := Fnd_Api.g_ret_sts_error;
1240: END IF;
1241:
1242:

Line 1246: FND_MSG_PUB.Add;

1242:
1243: IF p_enrl_request_rec.enrollment_type_code = Fnd_Api.g_miss_char OR p_enrl_request_rec.enrollment_type_code IS NULL THEN
1244: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1245: FND_MESSAGE.Set_Token('MISS_FIELD', 'ENROLLMENT_TYPE_CODE');
1246: FND_MSG_PUB.Add;
1247: x_return_status := Fnd_Api.g_ret_sts_error;
1248: END IF;
1249:
1250:

Line 1254: FND_MSG_PUB.Add;

1250:
1251: IF p_enrl_request_rec.request_initiated_by_code = Fnd_Api.g_miss_char OR p_enrl_request_rec.request_initiated_by_code IS NULL THEN
1252: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1253: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUEST_INITIATED_BY_CODE');
1254: FND_MSG_PUB.Add;
1255: x_return_status := Fnd_Api.g_ret_sts_error;
1256: END IF;
1257:
1258:

Line 1265: FND_MSG_PUB.Add;

1261:
1262: IF p_enrl_request_rec.enrl_request_id = Fnd_Api.G_MISS_NUM THEN
1263: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1264: FND_MESSAGE.Set_Token('MISS_FIELD', 'ENRL_REQUEST_ID');
1265: FND_MSG_PUB.Add;
1266: x_return_status := Fnd_Api.g_ret_sts_error;
1267: END IF;
1268:
1269:

Line 1273: FND_MSG_PUB.Add;

1269:
1270: IF p_enrl_request_rec.object_version_number = Fnd_Api.G_MISS_NUM THEN
1271: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1272: FND_MESSAGE.Set_Token('MISS_FIELD', 'OBJECT_VERSION_NUMBER');
1273: FND_MSG_PUB.Add;
1274: x_return_status := Fnd_Api.g_ret_sts_error;
1275: END IF;
1276:
1277:

Line 1281: FND_MSG_PUB.Add;

1277:
1278: IF p_enrl_request_rec.program_id = Fnd_Api.G_MISS_NUM THEN
1279: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1280: FND_MESSAGE.Set_Token('MISS_FIELD', 'PROGRAM_ID');
1281: FND_MSG_PUB.Add;
1282: x_return_status := Fnd_Api.g_ret_sts_error;
1283: END IF;
1284:
1285:

Line 1289: FND_MSG_PUB.Add;

1285:
1286: IF p_enrl_request_rec.partner_id = Fnd_Api.G_MISS_NUM THEN
1287: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1288: FND_MESSAGE.Set_Token('MISS_FIELD', 'PARTNER_ID');
1289: FND_MSG_PUB.Add;
1290: x_return_status := Fnd_Api.g_ret_sts_error;
1291: END IF;
1292:
1293:

Line 1297: FND_MSG_PUB.Add;

1293:
1294: IF p_enrl_request_rec.custom_setup_id = Fnd_Api.G_MISS_NUM THEN
1295: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1296: FND_MESSAGE.Set_Token('MISS_FIELD', 'CUSTOM_SETUP_ID');
1297: FND_MSG_PUB.Add;
1298: x_return_status := Fnd_Api.g_ret_sts_error;
1299: END IF;
1300:
1301:

Line 1305: FND_MSG_PUB.Add;

1301:
1302: IF p_enrl_request_rec.requestor_resource_id = Fnd_Api.G_MISS_NUM THEN
1303: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1304: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUESTOR_RESOURCE_ID');
1305: FND_MSG_PUB.Add;
1306: x_return_status := Fnd_Api.g_ret_sts_error;
1307: END IF;
1308:
1309:

Line 1313: FND_MSG_PUB.Add;

1309:
1310: IF p_enrl_request_rec.request_status_code = Fnd_Api.g_miss_char THEN
1311: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1312: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUEST_STATUS_CODE');
1313: FND_MSG_PUB.Add;
1314: x_return_status := Fnd_Api.g_ret_sts_error;
1315: END IF;
1316:
1317:

Line 1321: FND_MSG_PUB.Add;

1317:
1318: IF p_enrl_request_rec.enrollment_type_code = Fnd_Api.g_miss_char THEN
1319: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1320: FND_MESSAGE.Set_Token('MISS_FIELD', 'ENROLLMENT_TYPE_CODE');
1321: FND_MSG_PUB.Add;
1322: x_return_status := Fnd_Api.g_ret_sts_error;
1323: END IF;
1324:
1325:

Line 1329: FND_MSG_PUB.Add;

1325:
1326: IF p_enrl_request_rec.request_initiated_by_code = Fnd_Api.g_miss_char THEN
1327: FND_MESSAGE.Set_Name ('PV', 'AMS_API_MISSING_FIELD');
1328: FND_MESSAGE.Set_Token('MISS_FIELD', 'REQUEST_INITIATED_BY_CODE');
1329: FND_MSG_PUB.Add;
1330: x_return_status := Fnd_Api.g_ret_sts_error;
1331: END IF;
1332: END IF;
1333:

Line 1645: Fnd_Msg_Pub.initialize;

1641:
1642: -- Initialize message list if p_init_msg_list is set to TRUE.
1643: IF Fnd_Api.to_Boolean( p_init_msg_list )
1644: THEN
1645: Fnd_Msg_Pub.initialize;
1646: END IF;
1647:
1648:
1649: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

Line 1713: Fnd_Msg_Pub.Count_And_Get

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

Line 1722: FND_MSG_PUB.Add;

1718:
1719: WHEN Pvx_Utility_Pvt.resource_locked THEN
1720: x_return_status := Fnd_Api.g_ret_sts_error;
1721: FND_MESSAGE.Set_Name ('PV', 'PV_API_RESOURCE_LOCKED');
1722: FND_MSG_PUB.Add;
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;

Line 1728: Fnd_Msg_Pub.Count_And_Get (

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

Line 1738: Fnd_Msg_Pub.Count_And_Get (

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

Line 1747: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

1743:
1744: WHEN OTHERS THEN
1745: ROLLBACK TO VALIDATE_Pg_Enrl_Requests_;
1746: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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

Line 1749: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1745: ROLLBACK TO VALIDATE_Pg_Enrl_Requests_;
1746: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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,

Line 1752: Fnd_Msg_Pub.Count_And_Get (

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

Line 1773: Fnd_Msg_Pub.initialize;

1769: BEGIN
1770: -- Initialize message list if p_init_msg_list is set to TRUE.
1771: IF Fnd_Api.to_Boolean( p_init_msg_list )
1772: THEN
1773: Fnd_Msg_Pub.initialize;
1774: END IF;
1775:
1776:
1777:

Line 1792: Fnd_Msg_Pub.Count_And_Get

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: );
1796: END Validate_enrl_request_Rec;