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 PVX_UTILITY_PVT

Line 163: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

159: L_API_NAME CONSTANT VARCHAR2(30) := 'Is_Contract_Exists';
160:
161: BEGIN
162: IF (PV_DEBUG_HIGH_ON) THEN
163: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
164: PVX_UTILITY_PVT.debug_message('p_program_id = ' || p_program_id);
165: PVX_UTILITY_PVT.debug_message('p_partner_id = ' || p_partner_id);
166: PVX_UTILITY_PVT.debug_message('p_enrl_request_id = ' || p_enrl_request_id);
167: END IF;

Line 164: PVX_UTILITY_PVT.debug_message('p_program_id = ' || p_program_id);

160:
161: BEGIN
162: IF (PV_DEBUG_HIGH_ON) THEN
163: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
164: PVX_UTILITY_PVT.debug_message('p_program_id = ' || p_program_id);
165: PVX_UTILITY_PVT.debug_message('p_partner_id = ' || p_partner_id);
166: PVX_UTILITY_PVT.debug_message('p_enrl_request_id = ' || p_enrl_request_id);
167: END IF;
168:

Line 165: PVX_UTILITY_PVT.debug_message('p_partner_id = ' || p_partner_id);

161: BEGIN
162: IF (PV_DEBUG_HIGH_ON) THEN
163: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
164: PVX_UTILITY_PVT.debug_message('p_program_id = ' || p_program_id);
165: PVX_UTILITY_PVT.debug_message('p_partner_id = ' || p_partner_id);
166: PVX_UTILITY_PVT.debug_message('p_enrl_request_id = ' || p_enrl_request_id);
167: END IF;
168:
169: PV_Partner_Contracts_PVT.Is_Contract_Exist_Then_Create(

Line 166: PVX_UTILITY_PVT.debug_message('p_enrl_request_id = ' || p_enrl_request_id);

162: IF (PV_DEBUG_HIGH_ON) THEN
163: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
164: PVX_UTILITY_PVT.debug_message('p_program_id = ' || p_program_id);
165: PVX_UTILITY_PVT.debug_message('p_partner_id = ' || p_partner_id);
166: PVX_UTILITY_PVT.debug_message('p_enrl_request_id = ' || p_enrl_request_id);
167: END IF;
168:
169: PV_Partner_Contracts_PVT.Is_Contract_Exist_Then_Create(
170: p_api_version_number => 1.0

Line 183: PVX_UTILITY_PVT.debug_message('x_exist: ' || x_exist);

179: );
180:
181:
182: IF (PV_DEBUG_HIGH_ON) THEN
183: PVX_UTILITY_PVT.debug_message('x_exist: ' || x_exist);
184: PVX_UTILITY_PVT.debug_message('x_return_status: ' || x_return_status);
185: END IF;
186:
187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 184: PVX_UTILITY_PVT.debug_message('x_return_status: ' || x_return_status);

180:
181:
182: IF (PV_DEBUG_HIGH_ON) THEN
183: PVX_UTILITY_PVT.debug_message('x_exist: ' || x_exist);
184: PVX_UTILITY_PVT.debug_message('x_return_status: ' || x_return_status);
185: END IF;
186:
187: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
188: RAISE FND_API.G_EXC_ERROR;

Line 200: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');

196: p_data => x_msg_data
197: );
198:
199: IF (PV_DEBUG_HIGH_ON) THEN
200: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
201: END IF;
202:
203: RETURN x_exist;
204:

Line 343: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'START');

339:
340: -- Debug Message
341: IF (PV_DEBUG_HIGH_ON) THEN
342:
343: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'START');
344: END IF;
345:
346:
347:

Line 369: Pvx_Utility_Pvt.debug_message('PRIVATE API: Validate_Pg_Enrl_Requests');

365: THEN
366: -- Debug message
367: IF (PV_DEBUG_HIGH_ON) THEN
368:
369: Pvx_Utility_Pvt.debug_message('PRIVATE API: Validate_Pg_Enrl_Requests');
370: END IF;
371:
372: -- Invoke validation procedures
373: Validate_pg_enrl_requests(

Line 409: Pvx_Utility_Pvt.debug_message( 'PRIVATE API: Calling CREATE TABLE handler');

405:
406: -- Debug Message
407: IF (PV_DEBUG_HIGH_ON) THEN
408:
409: Pvx_Utility_Pvt.debug_message( 'PRIVATE API: Calling CREATE TABLE handler');
410: END IF;
411:
412: IF l_score_result_code IS NULL THEN
413: l_score_result_code := 'NOT_EVALUATED';

Line 502: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'END');

498:
499: -- Debug Message
500: IF (PV_DEBUG_HIGH_ON) THEN
501:
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.

Line 513: WHEN Pvx_Utility_Pvt.resource_locked THEN

509: p_data => x_msg_data
510: );
511: EXCEPTION
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:

Line 644: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'START');

640:
641: -- Debug Message
642: IF (PV_DEBUG_HIGH_ON) THEN
643:
644: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'START');
645: END IF;
646:
647:
648:

Line 655: Pvx_Utility_Pvt.debug_message('PRIVATE API: - OPEN CURSOR TO SELECT');

651:
652: -- Debug Message
653: IF (PV_DEBUG_HIGH_ON) THEN
654:
655: Pvx_Utility_Pvt.debug_message('PRIVATE API: - OPEN CURSOR TO SELECT');
656: END IF;
657:
658: OPEN c_get_Pg_Enrl_Requests( l_tar_enrl_request_rec.enrl_request_id);
659:

Line 671: Pvx_Utility_Pvt.debug_message('PRIVATE API: - CLOSE CURSOR');

667: END IF;
668: -- Debug Message
669: IF (PV_DEBUG_HIGH_ON) THEN
670:
671: Pvx_Utility_Pvt.debug_message('PRIVATE API: - CLOSE CURSOR');
672: END IF;
673: CLOSE c_get_Pg_Enrl_Requests;
674:
675:

Line 697: Pvx_Utility_Pvt.debug_message('PRIVATE API: Validate_Pg_Enrl_Requests');

693: THEN
694: -- Debug message
695: IF (PV_DEBUG_HIGH_ON) THEN
696:
697: Pvx_Utility_Pvt.debug_message('PRIVATE API: Validate_Pg_Enrl_Requests');
698: END IF;
699:
700: -- Invoke validation procedures
701: Validate_pg_enrl_requests(

Line 720: Pvx_Utility_Pvt.debug_message('PRIVATE API: Calling UPDATE TABLE handler');

716:
717: -- Debug Message
718: IF (PV_DEBUG_HIGH_ON) THEN
719:
720: Pvx_Utility_Pvt.debug_message('PRIVATE API: Calling UPDATE TABLE handler');
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');

Line 788: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'END');

784:
785: -- Debug Message
786: IF (PV_DEBUG_HIGH_ON) THEN
787:
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.

Line 798: WHEN PVX_Utility_PVT.API_RECORD_CHANGED THEN

794: (p_count => x_msg_count,
795: p_data => x_msg_data
796: );
797: EXCEPTION
798: WHEN PVX_Utility_PVT.API_RECORD_CHANGED THEN
799: x_return_status := Fnd_Api.G_RET_STS_ERROR;
800: IF (PV_DEBUG_HIGH_ON) THEN
801: Pvx_Utility_Pvt.debug_message('PRIVATE API: - OPEN CURSOR');
802: END IF;

Line 801: Pvx_Utility_Pvt.debug_message('PRIVATE API: - OPEN CURSOR');

797: EXCEPTION
798: WHEN PVX_Utility_PVT.API_RECORD_CHANGED THEN
799: x_return_status := Fnd_Api.G_RET_STS_ERROR;
800: IF (PV_DEBUG_HIGH_ON) THEN
801: Pvx_Utility_Pvt.debug_message('PRIVATE API: - OPEN CURSOR');
802: END IF;
803: OPEN c_get_Pg_Enrl_Requests( l_tar_enrl_request_rec.enrl_request_id);
804: FETCH c_get_Pg_Enrl_Requests INTO l_ref_enrl_request_rec;
805: IF ( c_get_Pg_Enrl_Requests%NOTFOUND) THEN

Line 812: Pvx_Utility_Pvt.debug_message('PRIVATE API: - CLOSE CURSOR');

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');
813: END IF;
814: CLOSE c_get_Pg_Enrl_Requests;
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;

Line 827: WHEN Pvx_Utility_Pvt.resource_locked THEN

823: p_count => x_msg_count,
824: p_data => x_msg_data
825: );
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

Line 943: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'START');

939:
940: -- Debug Message
941: IF (PV_DEBUG_HIGH_ON) THEN
942:
943: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'START');
944: END IF;
945:
946:
947:

Line 957: Pvx_Utility_Pvt.debug_message( 'PRIVATE API: Calling DELETE TABLE handler');

953: --
954: -- Debug Message
955: IF (PV_DEBUG_HIGH_ON) THEN
956:
957: Pvx_Utility_Pvt.debug_message( 'PRIVATE API: Calling DELETE TABLE handler');
958: END IF;
959:
960: -- Invoke table handler(Pv_Pg_Enrl_Requests_Pkg.Delete_Row)
961: Pv_Pg_Enrl_Requests_Pkg.Delete_Row(

Line 978: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'END');

974:
975: -- Debug Message
976: IF (PV_DEBUG_HIGH_ON) THEN
977:
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.

Line 989: WHEN Pvx_Utility_Pvt.resource_locked THEN

985: p_data => x_msg_data
986: );
987: EXCEPTION
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:

Line 1088: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'START');

1084:
1085: -- Debug Message
1086: IF (PV_DEBUG_HIGH_ON) THEN
1087:
1088: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'START');
1089: END IF;
1090:
1091:
1092: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1126: Pvx_Utility_Pvt.debug_message(l_full_name ||': END');

1122: p_count => x_msg_count,
1123: p_data => x_msg_data);
1124: IF (PV_DEBUG_HIGH_ON) THEN
1125:
1126: Pvx_Utility_Pvt.debug_message(l_full_name ||': END');
1127: END IF;
1128: EXCEPTION
1129:
1130: WHEN Pvx_Utility_Pvt.resource_locked THEN

Line 1130: WHEN Pvx_Utility_Pvt.resource_locked THEN

1126: Pvx_Utility_Pvt.debug_message(l_full_name ||': END');
1127: END IF;
1128: EXCEPTION
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:

Line 1185: l_valid_flag := Pvx_Utility_Pvt.check_uniqueness(

1181: x_return_status := Fnd_Api.g_ret_sts_success;
1182: IF p_validation_mode = Jtf_Plsql_Api.g_create
1183: AND p_enrl_request_rec.enrl_request_id IS NOT NULL
1184: THEN
1185: l_valid_flag := Pvx_Utility_Pvt.check_uniqueness(
1186: 'pv_pg_enrl_requests',
1187: 'enrl_request_id = ''' || p_enrl_request_rec.enrl_request_id ||''''
1188: );
1189: END IF;

Line 1696: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'START');

1692:
1693: -- Debug Message
1694: IF (PV_DEBUG_HIGH_ON) THEN
1695:
1696: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'START');
1697: END IF;
1698:
1699:
1700:

Line 1708: Pvx_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'END');

1704:
1705: -- Debug Message
1706: IF (PV_DEBUG_HIGH_ON) THEN
1707:
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.

Line 1719: WHEN Pvx_Utility_Pvt.resource_locked THEN

1715: p_data => x_msg_data
1716: );
1717: EXCEPTION
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:

Line 1789: Pvx_Utility_Pvt.debug_message('PRIVATE API: Validate_dm_model_rec');

1785:
1786: -- Debug Message
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,