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_ENRQ_INIT_SOURCES_PVT dependencies on PVX_UTILITY_PVT

Line 129: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');

125:
126: -- Debug Message
127: IF (PV_DEBUG_HIGH_ON) THEN
128:
129: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
130: END IF;
131:
132:
133:

Line 143: Pvx_Utility_Pvt.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

139: -- =========================================================================
140:
141: IF Fnd_Global.USER_ID IS NULL
142: THEN
143: Pvx_Utility_Pvt.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
144: RAISE Fnd_Api.G_EXC_ERROR;
145: END IF;
146:
147:

Line 154: Pvx_Utility_Pvt.debug_message('Private API: Validate_Pg_Init_Src');

150: THEN
151: -- Debug message
152: IF (PV_DEBUG_HIGH_ON) THEN
153:
154: Pvx_Utility_Pvt.debug_message('Private API: Validate_Pg_Init_Src');
155: END IF;
156:
157: -- Invoke validation procedures
158: Validate_Pg_Init_Src(

Line 194: Pvx_Utility_Pvt.debug_message( 'Private API: Calling create table handler');

190:
191: -- Debug Message
192: IF (PV_DEBUG_HIGH_ON) THEN
193:
194: Pvx_Utility_Pvt.debug_message( 'Private API: Calling create table handler');
195: END IF;
196:
197: -- Invoke table handler(Pv_Pg_Enrq_Init_Sources_Pkg.Insert_Row)
198: Pv_Pg_Enrq_Init_Sources_Pkg.Insert_Row(

Line 229: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');

225:
226: -- Debug Message
227: IF (PV_DEBUG_HIGH_ON) THEN
228:
229: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
230: END IF;
231:
232:
233: -- Standard call to get message count and if count is 1, get message info.

Line 240: WHEN Pvx_Utility_Pvt.resource_locked THEN

236: p_data => x_msg_data
237: );
238: EXCEPTION
239:
240: WHEN Pvx_Utility_Pvt.resource_locked THEN
241: x_return_status := Fnd_Api.g_ret_sts_error;
242: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
243:
244: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 242: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

238: EXCEPTION
239:
240: WHEN Pvx_Utility_Pvt.resource_locked THEN
241: x_return_status := Fnd_Api.g_ret_sts_error;
242: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
243:
244: WHEN Fnd_Api.G_EXC_ERROR THEN
245: ROLLBACK TO CREATE_Pg_Init_Src_PVT;
246: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 370: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');

366:
367: -- Debug Message
368: IF (PV_DEBUG_HIGH_ON) THEN
369:
370: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
371: END IF;
372:
373:
374:

Line 381: Pvx_Utility_Pvt.debug_message('Private API: - Open Cursor to Select');

377:
378: -- Debug Message
379: IF (PV_DEBUG_HIGH_ON) THEN
380:
381: Pvx_Utility_Pvt.debug_message('Private API: - Open Cursor to Select');
382: END IF;
383:
384: OPEN c_get_Pg_Enrq_Init_Sources( l_tar_enrq_init_sources_rec.initiation_source_id);
385:

Line 389: Pvx_Utility_Pvt.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

385:
386: FETCH c_get_Pg_Enrq_Init_Sources INTO l_ref_enrq_init_sources_rec ;
387:
388: IF ( c_get_Pg_Enrq_Init_Sources%NOTFOUND) THEN
389: Pvx_Utility_Pvt.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
390: p_token_name => 'INFO',
391: p_token_value => 'Pg_Enrq_Init_Sources') ;
392: RAISE Fnd_Api.G_EXC_ERROR;
393: END IF;

Line 397: Pvx_Utility_Pvt.debug_message('Private API: - Close Cursor');

393: END IF;
394: -- Debug Message
395: IF (PV_DEBUG_HIGH_ON) THEN
396:
397: Pvx_Utility_Pvt.debug_message('Private API: - Close Cursor');
398: END IF;
399: CLOSE c_get_Pg_Enrq_Init_Sources;
400:
401:

Line 404: Pvx_Utility_Pvt.Error_Message(p_message_name => 'API_VERSION_MISSING',

400:
401:
402: IF (l_tar_enrq_init_sources_rec.object_version_number IS NULL OR
403: l_tar_enrq_init_sources_rec.object_version_number = Fnd_Api.G_MISS_NUM ) THEN
404: Pvx_Utility_Pvt.Error_Message(p_message_name => 'API_VERSION_MISSING',
405: p_token_name => 'COLUMN',
406: p_token_value => 'Last_Update_Date') ;
407: RAISE Fnd_Api.G_EXC_ERROR;
408: END IF;

Line 411: Pvx_Utility_Pvt.Error_Message(p_message_name => 'API_RECORD_CHANGED',

407: RAISE Fnd_Api.G_EXC_ERROR;
408: END IF;
409: -- Check Whether record has been changed by someone else
410: IF (l_tar_enrq_init_sources_rec.object_version_number <> l_ref_enrq_init_sources_rec.object_version_number) THEN
411: Pvx_Utility_Pvt.Error_Message(p_message_name => 'API_RECORD_CHANGED',
412: p_token_name => 'INFO',
413: p_token_value => 'Pg_Enrq_Init_Sources') ;
414: RAISE Fnd_Api.G_EXC_ERROR;
415: END IF;

Line 423: Pvx_Utility_Pvt.debug_message('Private API: Validate_Pg_Init_Src');

419: THEN
420: -- Debug message
421: IF (PV_DEBUG_HIGH_ON) THEN
422:
423: Pvx_Utility_Pvt.debug_message('Private API: Validate_Pg_Init_Src');
424: END IF;
425:
426: -- Invoke validation procedures
427: Validate_Pg_Init_Src(

Line 446: Pvx_Utility_Pvt.debug_message('Private API: Calling update table handler');

442:
443: -- Debug Message
444: IF (PV_DEBUG_HIGH_ON) THEN
445:
446: Pvx_Utility_Pvt.debug_message('Private API: Calling update table handler');
447: END IF;
448:
449: -- Invoke table handler(Pv_Pg_Enrq_Init_Sources_Pkg.Update_Row)
450: Pv_Pg_Enrq_Init_Sources_Pkg.Update_Row(

Line 474: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');

470:
471: -- Debug Message
472: IF (PV_DEBUG_HIGH_ON) THEN
473:
474: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
475: END IF;
476:
477:
478: -- Standard call to get message count and if count is 1, get message info.

Line 485: WHEN Pvx_Utility_Pvt.resource_locked THEN

481: p_data => x_msg_data
482: );
483: EXCEPTION
484:
485: WHEN Pvx_Utility_Pvt.resource_locked THEN
486: x_return_status := Fnd_Api.g_ret_sts_error;
487: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
488:
489: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 487: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

483: EXCEPTION
484:
485: WHEN Pvx_Utility_Pvt.resource_locked THEN
486: x_return_status := Fnd_Api.g_ret_sts_error;
487: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
488:
489: WHEN Fnd_Api.G_EXC_ERROR THEN
490: ROLLBACK TO UPDATE_Pg_Init_Src_PVT;
491: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 601: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');

597:
598: -- Debug Message
599: IF (PV_DEBUG_HIGH_ON) THEN
600:
601: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
602: END IF;
603:
604:
605:

Line 615: Pvx_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');

611: --
612: -- Debug Message
613: IF (PV_DEBUG_HIGH_ON) THEN
614:
615: Pvx_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');
616: END IF;
617:
618: -- Invoke table handler(Pv_Pg_Enrq_Init_Sources_Pkg.Delete_Row)
619: Pv_Pg_Enrq_Init_Sources_Pkg.Delete_Row(

Line 636: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');

632:
633: -- Debug Message
634: IF (PV_DEBUG_HIGH_ON) THEN
635:
636: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
637: END IF;
638:
639:
640: -- Standard call to get message count and if count is 1, get message info.

Line 647: WHEN Pvx_Utility_Pvt.resource_locked THEN

643: p_data => x_msg_data
644: );
645: EXCEPTION
646:
647: WHEN Pvx_Utility_Pvt.resource_locked THEN
648: x_return_status := Fnd_Api.g_ret_sts_error;
649: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
650:
651: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 649: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

645: EXCEPTION
646:
647: WHEN Pvx_Utility_Pvt.resource_locked THEN
648: x_return_status := Fnd_Api.g_ret_sts_error;
649: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
650:
651: WHEN Fnd_Api.G_EXC_ERROR THEN
652: ROLLBACK TO DELETE_Pg_Init_Src_PVT;
653: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 745: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');

741:
742: -- Debug Message
743: IF (PV_DEBUG_HIGH_ON) THEN
744:
745: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
746: END IF;
747:
748:
749: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 783: Pvx_Utility_Pvt.debug_message(l_full_name ||': end');

779: p_count => x_msg_count,
780: p_data => x_msg_data);
781: IF (PV_DEBUG_HIGH_ON) THEN
782:
783: Pvx_Utility_Pvt.debug_message(l_full_name ||': end');
784: END IF;
785: EXCEPTION
786:
787: WHEN Pvx_Utility_Pvt.resource_locked THEN

Line 787: WHEN Pvx_Utility_Pvt.resource_locked THEN

783: Pvx_Utility_Pvt.debug_message(l_full_name ||': end');
784: END IF;
785: EXCEPTION
786:
787: WHEN Pvx_Utility_Pvt.resource_locked THEN
788: x_return_status := Fnd_Api.g_ret_sts_error;
789: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
790:
791: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 789: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

785: EXCEPTION
786:
787: WHEN Pvx_Utility_Pvt.resource_locked THEN
788: x_return_status := Fnd_Api.g_ret_sts_error;
789: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
790:
791: WHEN Fnd_Api.G_EXC_ERROR THEN
792: ROLLBACK TO LOCK_Pg_Enrq_Init_Sources_PVT;
793: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 841: l_valid_flag := Pvx_Utility_Pvt.check_uniqueness(

837: x_return_status := Fnd_Api.g_ret_sts_success;
838: IF p_validation_mode = Jtf_Plsql_Api.g_create
839: AND p_enrq_init_sources_rec.initiation_source_id IS NOT NULL
840: THEN
841: l_valid_flag := Pvx_Utility_Pvt.check_uniqueness(
842: 'pv_pg_enrq_init_sources',
843: 'initiation_source_id = ''' || p_enrq_init_sources_rec.initiation_source_id ||''''
844: );
845: END IF;

Line 848: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_initiation_source_id_DUPLICATE');

844: );
845: END IF;
846:
847: IF l_valid_flag = Fnd_Api.g_false THEN
848: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_initiation_source_id_DUPLICATE');
849: x_return_status := Fnd_Api.g_ret_sts_error;
850: END IF;
851:
852: END check_Init_Src_Uk_Items;

Line 869: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'INITIATION_SOURCE_ID' );

865: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
866:
867: /*
868: IF p_enrq_init_sources_rec.initiation_source_id = FND_API.G_MISS_NUM OR p_enrq_init_sources_rec.initiation_source_id IS NULL THEN
869: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'INITIATION_SOURCE_ID' );
870: x_return_status := FND_API.g_ret_sts_error;
871: END IF;
872:
873:

Line 875: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

871: END IF;
872:
873:
874: IF p_enrq_init_sources_rec.object_version_number = FND_API.G_MISS_NUM OR p_enrq_init_sources_rec.object_version_number IS NULL THEN
875: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
876: x_return_status := FND_API.g_ret_sts_error;
877: END IF;
878: */
879:

Line 881: Pvx_Utility_Pvt.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENRL_REQUEST_ID' );

877: END IF;
878: */
879:
880: IF p_enrq_init_sources_rec.enrl_request_id = Fnd_Api.G_MISS_NUM OR p_enrq_init_sources_rec.enrl_request_id IS NULL THEN
881: Pvx_Utility_Pvt.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENRL_REQUEST_ID' );
882: x_return_status := Fnd_Api.g_ret_sts_error;
883: END IF;
884:
885:

Line 887: Pvx_Utility_Pvt.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PREV_MEMBERSHIP_ID' );

883: END IF;
884:
885:
886: IF p_enrq_init_sources_rec.prev_membership_id = Fnd_Api.G_MISS_NUM OR p_enrq_init_sources_rec.prev_membership_id IS NULL THEN
887: Pvx_Utility_Pvt.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PREV_MEMBERSHIP_ID' );
888: x_return_status := Fnd_Api.g_ret_sts_error;
889: END IF;
890:
891:

Line 896: Pvx_Utility_Pvt.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'INITIATION_SOURCE_ID' );

892: ELSE
893:
894:
895: IF p_enrq_init_sources_rec.initiation_source_id = Fnd_Api.G_MISS_NUM THEN
896: Pvx_Utility_Pvt.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'INITIATION_SOURCE_ID' );
897: x_return_status := Fnd_Api.g_ret_sts_error;
898: END IF;
899:
900:

Line 902: Pvx_Utility_Pvt.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

898: END IF;
899:
900:
901: IF p_enrq_init_sources_rec.object_version_number = Fnd_Api.G_MISS_NUM THEN
902: Pvx_Utility_Pvt.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
903: x_return_status := Fnd_Api.g_ret_sts_error;
904: END IF;
905:
906:

Line 908: Pvx_Utility_Pvt.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENRL_REQUEST_ID' );

904: END IF;
905:
906:
907: IF p_enrq_init_sources_rec.enrl_request_id = Fnd_Api.G_MISS_NUM THEN
908: Pvx_Utility_Pvt.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENRL_REQUEST_ID' );
909: x_return_status := Fnd_Api.g_ret_sts_error;
910: END IF;
911:
912:

Line 914: Pvx_Utility_Pvt.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PREV_MEMBERSHIP_ID' );

910: END IF;
911:
912:
913: IF p_enrq_init_sources_rec.prev_membership_id = Fnd_Api.G_MISS_NUM THEN
914: Pvx_Utility_Pvt.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PREV_MEMBERSHIP_ID' );
915: x_return_status := Fnd_Api.g_ret_sts_error;
916: END IF;
917: END IF;
918:

Line 1182: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');

1178:
1179: -- Debug Message
1180: IF (PV_DEBUG_HIGH_ON) THEN
1181:
1182: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
1183: END IF;
1184:
1185:
1186:

Line 1194: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');

1190:
1191: -- Debug Message
1192: IF (PV_DEBUG_HIGH_ON) THEN
1193:
1194: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
1195: END IF;
1196:
1197:
1198: -- Standard call to get message count and if count is 1, get message info.

Line 1205: WHEN Pvx_Utility_Pvt.resource_locked THEN

1201: p_data => x_msg_data
1202: );
1203: EXCEPTION
1204:
1205: WHEN Pvx_Utility_Pvt.resource_locked THEN
1206: x_return_status := Fnd_Api.g_ret_sts_error;
1207: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1208:
1209: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1207: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1203: EXCEPTION
1204:
1205: WHEN Pvx_Utility_Pvt.resource_locked THEN
1206: x_return_status := Fnd_Api.g_ret_sts_error;
1207: Pvx_Utility_Pvt.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1208:
1209: WHEN Fnd_Api.G_EXC_ERROR THEN
1210: ROLLBACK TO Validate_Pg_Init_Src_;
1211: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1274: Pvx_Utility_Pvt.debug_message('Private API: Validate_dm_model_rec');

1270:
1271: -- Debug Message
1272: IF (PV_DEBUG_HIGH_ON) THEN
1273:
1274: Pvx_Utility_Pvt.debug_message('Private API: Validate_dm_model_rec');
1275: END IF;
1276: -- Standard call to get message count and if count is 1, get message info.
1277: Fnd_Msg_Pub.Count_And_Get
1278: (p_count => x_msg_count,