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_MMBR_TRANSITIONS_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_Mmbr_Trans');

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

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_mmbr_transitions_Pkg.Insert_Row)
198: pv_pg_mmbr_transitions_Pkg.Insert_Row(

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

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

Line 239: WHEN PVX_UTILITY_PVT.resource_locked THEN

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

Line 241: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

237: EXCEPTION
238:
239: WHEN PVX_UTILITY_PVT.resource_locked THEN
240: x_return_status := FND_API.g_ret_sts_error;
241: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
242:
243: WHEN FND_API.G_EXC_ERROR THEN
244: ROLLBACK TO CREATE_Mmbr_Trans_PVT;
245: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 380: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

376:
377: -- Debug Message
378: IF (PV_DEBUG_HIGH_ON) THEN
379:
380: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
381: END IF;
382:
383: OPEN c_get_Mmbr_Trans( l_tar_mmbr_tran_rec.mmbr_transition_id);
384:

Line 388: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

384:
385: FETCH c_get_Mmbr_Trans INTO l_ref_mmbr_tran_rec ;
386:
387: If ( c_get_Mmbr_Trans%NOTFOUND) THEN
388: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
389: p_token_name => 'INFO',
390: p_token_value => 'Mmbr_Trans') ;
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;

Line 396: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');

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

Line 403: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

399:
400:
401: If (l_tar_mmbr_tran_rec.object_version_number is NULL or
402: l_tar_mmbr_tran_rec.object_version_number = FND_API.G_MISS_NUM ) Then
403: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
404: p_token_name => 'COLUMN',
405: p_token_value => 'Last_Update_Date') ;
406: raise FND_API.G_EXC_ERROR;
407: End if;

Line 410: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

406: raise FND_API.G_EXC_ERROR;
407: End if;
408: -- Check Whether record has been changed by someone else
409: If (l_tar_mmbr_tran_rec.object_version_number <> l_ref_mmbr_tran_rec.object_version_number) Then
410: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
411: p_token_name => 'INFO',
412: p_token_value => 'Mmbr_Trans') ;
413: raise FND_API.G_EXC_ERROR;
414: End if;

Line 422: PVX_UTILITY_PVT.debug_message('Private API: Validate_Mmbr_Trans');

418: THEN
419: -- Debug message
420: IF (PV_DEBUG_HIGH_ON) THEN
421:
422: PVX_UTILITY_PVT.debug_message('Private API: Validate_Mmbr_Trans');
423: END IF;
424:
425: -- Invoke validation procedures
426: Validate_mmbr_trans(

Line 445: PVX_UTILITY_PVT.debug_message( 'Private API: Calling update table handler');

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

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

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

Line 483: WHEN PVX_UTILITY_PVT.resource_locked THEN

479: p_data => x_msg_data
480: );
481: EXCEPTION
482:
483: WHEN PVX_UTILITY_PVT.resource_locked THEN
484: x_return_status := FND_API.g_ret_sts_error;
485: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
486:
487: WHEN FND_API.G_EXC_ERROR THEN

Line 485: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

481: EXCEPTION
482:
483: WHEN PVX_UTILITY_PVT.resource_locked THEN
484: x_return_status := FND_API.g_ret_sts_error;
485: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
486:
487: WHEN FND_API.G_EXC_ERROR THEN
488: ROLLBACK TO UPDATE_Mmbr_Trans_PVT;
489: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 613: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

609: --
610: -- Debug Message
611: IF (PV_DEBUG_HIGH_ON) THEN
612:
613: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
614: END IF;
615:
616: -- Invoke table handler(pv_pg_mmbr_transitions_Pkg.Delete_Row)
617: pv_pg_mmbr_transitions_Pkg.Delete_Row(

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

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

Line 645: WHEN PVX_UTILITY_PVT.resource_locked THEN

641: p_data => x_msg_data
642: );
643: EXCEPTION
644:
645: WHEN PVX_UTILITY_PVT.resource_locked THEN
646: x_return_status := FND_API.g_ret_sts_error;
647: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
648:
649: WHEN FND_API.G_EXC_ERROR THEN

Line 647: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

643: EXCEPTION
644:
645: WHEN PVX_UTILITY_PVT.resource_locked THEN
646: x_return_status := FND_API.g_ret_sts_error;
647: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
648:
649: WHEN FND_API.G_EXC_ERROR THEN
650: ROLLBACK TO DELETE_Mmbr_Trans_PVT;
651: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

Line 781: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');

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

Line 785: WHEN PVX_UTILITY_PVT.resource_locked THEN

781: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
782: END IF;
783: EXCEPTION
784:
785: WHEN PVX_UTILITY_PVT.resource_locked THEN
786: x_return_status := FND_API.g_ret_sts_error;
787: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
788:
789: WHEN FND_API.G_EXC_ERROR THEN

Line 787: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

783: EXCEPTION
784:
785: WHEN PVX_UTILITY_PVT.resource_locked THEN
786: x_return_status := FND_API.g_ret_sts_error;
787: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
788:
789: WHEN FND_API.G_EXC_ERROR THEN
790: ROLLBACK TO LOCK_Mmbr_Trans_PVT;
791: x_return_status := FND_API.G_RET_STS_ERROR;

Line 839: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

835: x_return_status := FND_API.g_ret_sts_success;
836: IF p_validation_mode = JTF_PLSQL_API.g_create
837: AND p_mmbr_tran_rec.mmbr_transition_id IS NOT NULL
838: THEN
839: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
840: 'pv_pg_mmbr_transitions',
841: 'mmbr_transition_id = ''' || p_mmbr_tran_rec.mmbr_transition_id ||''''
842: );
843: END IF;

Line 846: PVX_UTILITY_PVT.Error_Message(p_message_name => 'pv_pg_mmbr_transitionsition_id_DUPLICATE');

842: );
843: END IF;
844:
845: IF l_valid_flag = FND_API.g_false THEN
846: PVX_UTILITY_PVT.Error_Message(p_message_name => 'pv_pg_mmbr_transitionsition_id_DUPLICATE');
847: x_return_status := FND_API.g_ret_sts_error;
848: END IF;
849:
850: END check_Mmbr_Tran_Uk_Items;

Line 867: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MMBR_TRANSITION_ID' );

863: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
864:
865: /*
866: IF p_mmbr_tran_rec.mmbr_transition_id = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.mmbr_transition_id IS NULL THEN
867: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MMBR_TRANSITION_ID' );
868: x_return_status := FND_API.g_ret_sts_error;
869: END IF;
870: */
871:

Line 873: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'FROM_MEMBERSHIP_ID' );

869: END IF;
870: */
871:
872: IF p_mmbr_tran_rec.from_membership_id = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.from_membership_id IS NULL THEN
873: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'FROM_MEMBERSHIP_ID' );
874: x_return_status := FND_API.g_ret_sts_error;
875: END IF;
876:
877:

Line 879: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TO_MEMBERSHIP_ID' );

875: END IF;
876:
877:
878: IF p_mmbr_tran_rec.to_membership_id = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.to_membership_id IS NULL THEN
879: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TO_MEMBERSHIP_ID' );
880: x_return_status := FND_API.g_ret_sts_error;
881: END IF;
882:
883: /*

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

881: END IF;
882:
883: /*
884: IF p_mmbr_tran_rec.object_version_number = FND_API.G_MISS_NUM OR p_mmbr_tran_rec.object_version_number IS NULL THEN
885: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
886: x_return_status := FND_API.g_ret_sts_error;
887: END IF;
888:
889: */

Line 894: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MMBR_TRANSITION_ID' );

890: ELSE
891:
892:
893: IF p_mmbr_tran_rec.mmbr_transition_id = FND_API.G_MISS_NUM THEN
894: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MMBR_TRANSITION_ID' );
895: x_return_status := FND_API.g_ret_sts_error;
896: END IF;
897:
898:

Line 900: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'FROM_MEMBERSHIP_ID' );

896: END IF;
897:
898:
899: IF p_mmbr_tran_rec.from_membership_id = FND_API.G_MISS_NUM THEN
900: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'FROM_MEMBERSHIP_ID' );
901: x_return_status := FND_API.g_ret_sts_error;
902: END IF;
903:
904:

Line 906: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TO_MEMBERSHIP_ID' );

902: END IF;
903:
904:
905: IF p_mmbr_tran_rec.to_membership_id = FND_API.G_MISS_NUM THEN
906: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'TO_MEMBERSHIP_ID' );
907: x_return_status := FND_API.g_ret_sts_error;
908: END IF;
909:
910:

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

908: END IF;
909:
910:
911: IF p_mmbr_tran_rec.object_version_number = FND_API.G_MISS_NUM THEN
912: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915: END IF;
916:

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

1171:
1172: -- Debug Message
1173: IF (PV_DEBUG_HIGH_ON) THEN
1174:
1175: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1176: END IF;
1177:
1178:
1179:

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

1183:
1184: -- Debug Message
1185: IF (PV_DEBUG_HIGH_ON) THEN
1186:
1187: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1188: END IF;
1189:
1190:
1191: -- Standard call to get message count and if count is 1, get message info.

Line 1198: WHEN PVX_UTILITY_PVT.resource_locked THEN

1194: p_data => x_msg_data
1195: );
1196: EXCEPTION
1197:
1198: WHEN PVX_UTILITY_PVT.resource_locked THEN
1199: x_return_status := FND_API.g_ret_sts_error;
1200: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1201:
1202: WHEN FND_API.G_EXC_ERROR THEN

Line 1200: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1196: EXCEPTION
1197:
1198: WHEN PVX_UTILITY_PVT.resource_locked THEN
1199: x_return_status := FND_API.g_ret_sts_error;
1200: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1201:
1202: WHEN FND_API.G_EXC_ERROR THEN
1203: ROLLBACK TO VALIDATE_Mmbr_Trans_;
1204: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1267: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1263:
1264: -- Debug Message
1265: IF (PV_DEBUG_HIGH_ON) THEN
1266:
1267: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1268: END IF;
1269: -- Standard call to get message count and if count is 1, get message info.
1270: FND_MSG_PUB.Count_And_Get
1271: (p_count => x_msg_count,