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_GE_PARTY_NOTIF_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_Ge_Party_Notif');

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

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_Ge_Party_Notif_Pkg.Insert_Row)
198: Pv_Ge_Party_Notif_Pkg.Insert_Row(

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

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

Line 243: WHEN PVX_UTILITY_PVT.resource_locked THEN

239: p_data => x_msg_data
240: );
241: EXCEPTION
242:
243: WHEN PVX_UTILITY_PVT.resource_locked THEN
244: x_return_status := FND_API.g_ret_sts_error;
245: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
246:
247: WHEN FND_API.G_EXC_ERROR THEN

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

241: EXCEPTION
242:
243: WHEN PVX_UTILITY_PVT.resource_locked THEN
244: x_return_status := FND_API.g_ret_sts_error;
245: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
246:
247: WHEN FND_API.G_EXC_ERROR THEN
248: ROLLBACK TO CREATE_Ge_Party_Notif_PVT;
249: x_return_status := FND_API.G_RET_STS_ERROR;

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

369:
370: -- Debug Message
371: IF (PV_DEBUG_HIGH_ON) THEN
372:
373: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
374: END IF;
375:
376:
377:

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

380:
381: -- Debug Message
382: IF (PV_DEBUG_HIGH_ON) THEN
383:
384: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
385: END IF;
386:
387: OPEN c_get_Ge_Party_Notif( l_tar_pgp_notif_rec.party_notification_id);
388:

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

388:
389: FETCH c_get_Ge_Party_Notif INTO l_ref_pgp_notif_rec ;
390:
391: If ( c_get_Ge_Party_Notif%NOTFOUND) THEN
392: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
393: p_token_name => 'INFO',
394: p_token_value => 'Ge_Party_Notif') ;
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;

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

396: END IF;
397: -- Debug Message
398: IF (PV_DEBUG_HIGH_ON) THEN
399:
400: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');
401: END IF;
402: CLOSE c_get_Ge_Party_Notif;
403:
404:

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

403:
404:
405: If (l_tar_pgp_notif_rec.object_version_number is NULL or
406: l_tar_pgp_notif_rec.object_version_number = FND_API.G_MISS_NUM ) Then
407: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
408: p_token_name => 'COLUMN',
409: p_token_value => 'Last_Update_Date') ;
410: raise FND_API.G_EXC_ERROR;
411: End if;

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

410: raise FND_API.G_EXC_ERROR;
411: End if;
412: -- Check Whether record has been changed by someone else
413: If (l_tar_pgp_notif_rec.object_version_number <> l_ref_pgp_notif_rec.object_version_number) Then
414: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
415: p_token_name => 'INFO',
416: p_token_value => 'Ge_Party_Notif') ;
417: raise FND_API.G_EXC_ERROR;
418: End if;

Line 426: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Party_Notif');

422: THEN
423: -- Debug message
424: IF (PV_DEBUG_HIGH_ON) THEN
425:
426: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Party_Notif');
427: END IF;
428:
429: -- Invoke validation procedures
430: Validate_ge_party_notif(

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

445:
446: -- Debug Message
447: IF (PV_DEBUG_HIGH_ON) THEN
448:
449: PVX_UTILITY_PVT.debug_message('Private API: Calling update table handler');
450: END IF;
451:
452: -- Invoke table handler(Pv_Ge_Party_Notif_Pkg.Update_Row)
453: Pv_Ge_Party_Notif_Pkg.Update_Row(

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

476:
477: -- Debug Message
478: IF (PV_DEBUG_HIGH_ON) THEN
479:
480: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
481: END IF;
482:
483:
484: -- Standard call to get message count and if count is 1, get message info.

Line 491: WHEN PVX_UTILITY_PVT.resource_locked THEN

487: p_data => x_msg_data
488: );
489: EXCEPTION
490:
491: WHEN PVX_UTILITY_PVT.resource_locked THEN
492: x_return_status := FND_API.g_ret_sts_error;
493: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
494:
495: WHEN FND_API.G_EXC_ERROR THEN

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

489: EXCEPTION
490:
491: WHEN PVX_UTILITY_PVT.resource_locked THEN
492: x_return_status := FND_API.g_ret_sts_error;
493: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
494:
495: WHEN FND_API.G_EXC_ERROR THEN
496: ROLLBACK TO UPDATE_Ge_Party_Notif_PVT;
497: x_return_status := FND_API.G_RET_STS_ERROR;

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

603:
604: -- Debug Message
605: IF (PV_DEBUG_HIGH_ON) THEN
606:
607: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
608: END IF;
609:
610:
611:

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

617: --
618: -- Debug Message
619: IF (PV_DEBUG_HIGH_ON) THEN
620:
621: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
622: END IF;
623:
624: -- Invoke table handler(Pv_Ge_Party_Notif_Pkg.Delete_Row)
625: Pv_Ge_Party_Notif_Pkg.Delete_Row(

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

638:
639: -- Debug Message
640: IF (PV_DEBUG_HIGH_ON) THEN
641:
642: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
643: END IF;
644:
645:
646: -- Standard call to get message count and if count is 1, get message info.

Line 653: WHEN PVX_UTILITY_PVT.resource_locked THEN

649: p_data => x_msg_data
650: );
651: EXCEPTION
652:
653: WHEN PVX_UTILITY_PVT.resource_locked THEN
654: x_return_status := FND_API.g_ret_sts_error;
655: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
656:
657: WHEN FND_API.G_EXC_ERROR THEN

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

651: EXCEPTION
652:
653: WHEN PVX_UTILITY_PVT.resource_locked THEN
654: x_return_status := FND_API.g_ret_sts_error;
655: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
656:
657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO DELETE_Ge_Party_Notif_PVT;
659: x_return_status := FND_API.G_RET_STS_ERROR;

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

747:
748: -- Debug Message
749: IF (PV_DEBUG_HIGH_ON) THEN
750:
751: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
752: END IF;
753:
754:
755: -- Initialize message list if p_init_msg_list is set to TRUE.

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

785: p_count => x_msg_count,
786: p_data => x_msg_data);
787: IF (PV_DEBUG_HIGH_ON) THEN
788:
789: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
790: END IF;
791: EXCEPTION
792:
793: WHEN PVX_UTILITY_PVT.resource_locked THEN

Line 793: WHEN PVX_UTILITY_PVT.resource_locked THEN

789: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
790: END IF;
791: EXCEPTION
792:
793: WHEN PVX_UTILITY_PVT.resource_locked THEN
794: x_return_status := FND_API.g_ret_sts_error;
795: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
796:
797: WHEN FND_API.G_EXC_ERROR THEN

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

791: EXCEPTION
792:
793: WHEN PVX_UTILITY_PVT.resource_locked THEN
794: x_return_status := FND_API.g_ret_sts_error;
795: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
796:
797: WHEN FND_API.G_EXC_ERROR THEN
798: ROLLBACK TO LOCK_Ge_Party_Notif_PVT;
799: x_return_status := FND_API.G_RET_STS_ERROR;

Line 847: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

843: x_return_status := FND_API.g_ret_sts_success;
844: IF p_validation_mode = JTF_PLSQL_API.g_create
845: AND p_pgp_notif_rec.party_notification_id IS NOT NULL
846: THEN
847: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
848: 'pv_ge_party_notifications',
849: 'party_notification_id = ''' || p_pgp_notif_rec.party_notification_id ||''''
850: );
851: END IF;

Line 854: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_party_notification_id_DUPLICATE');

850: );
851: END IF;
852:
853: IF l_valid_flag = FND_API.g_false THEN
854: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_party_notification_id_DUPLICATE');
855: x_return_status := FND_API.g_ret_sts_error;
856: END IF;
857:
858: END check_Pgp_Notif_Uk_Items;

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

871: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
872:
873: /*
874: IF p_pgp_notif_rec.party_notification_id = FND_API.G_MISS_NUM OR p_pgp_notif_rec.party_notification_id IS NULL THEN
875: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PARTY_NOTIFICATION_ID' );
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', 'NOTIFICATION_ID' );

877: END IF;
878: */
879:
880: IF p_pgp_notif_rec.notification_id = FND_API.G_MISS_NUM OR p_pgp_notif_rec.notification_id IS NULL THEN
881: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIFICATION_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', 'OBJECT_VERSION_NUMBER' );

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

Line 893: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RECIPIENT_USER_ID' );

889: END IF;
890: */
891:
892: IF p_pgp_notif_rec.recipient_user_id = FND_API.G_MISS_NUM OR p_pgp_notif_rec.recipient_user_id IS NULL THEN
893: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RECIPIENT_USER_ID' );
894: x_return_status := FND_API.g_ret_sts_error;
895: END IF;
896:
897:

Line 899: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_FOR_ENTITY_ID' );

895: END IF;
896:
897:
898: IF p_pgp_notif_rec.notif_for_entity_id = FND_API.G_MISS_NUM OR p_pgp_notif_rec.notif_for_entity_id IS NULL THEN
899: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_FOR_ENTITY_ID' );
900: x_return_status := FND_API.g_ret_sts_error;
901: END IF;
902:
903:

Line 908: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PARTY_NOTIFICATION_ID' );

904: ELSE
905:
906:
907: IF p_pgp_notif_rec.party_notification_id = FND_API.G_MISS_NUM THEN
908: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PARTY_NOTIFICATION_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', 'NOTIFICATION_ID' );

910: END IF;
911:
912:
913: IF p_pgp_notif_rec.notification_id = FND_API.G_MISS_NUM THEN
914: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIFICATION_ID' );
915: x_return_status := FND_API.g_ret_sts_error;
916: END IF;
917:
918:

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

916: END IF;
917:
918:
919: IF p_pgp_notif_rec.object_version_number = FND_API.G_MISS_NUM THEN
920: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
921: x_return_status := FND_API.g_ret_sts_error;
922: END IF;
923:
924:

Line 926: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RECIPIENT_USER_ID' );

922: END IF;
923:
924:
925: IF p_pgp_notif_rec.recipient_user_id = FND_API.G_MISS_NUM THEN
926: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RECIPIENT_USER_ID' );
927: x_return_status := FND_API.g_ret_sts_error;
928: END IF;
929:
930:

Line 932: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_FOR_ENTITY_ID' );

928: END IF;
929:
930:
931: IF p_pgp_notif_rec.notif_for_entity_id = FND_API.G_MISS_NUM THEN
932: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'NOTIF_FOR_ENTITY_ID' );
933: x_return_status := FND_API.g_ret_sts_error;
934: END IF;
935: END IF;
936:

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

1211:
1212: -- Debug Message
1213: IF (PV_DEBUG_HIGH_ON) THEN
1214:
1215: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1216: END IF;
1217:
1218:
1219:

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

1223:
1224: -- Debug Message
1225: IF (PV_DEBUG_HIGH_ON) THEN
1226:
1227: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1228: END IF;
1229:
1230:
1231: -- Standard call to get message count and if count is 1, get message info.

Line 1238: WHEN PVX_UTILITY_PVT.resource_locked THEN

1234: p_data => x_msg_data
1235: );
1236: EXCEPTION
1237:
1238: WHEN PVX_UTILITY_PVT.resource_locked THEN
1239: x_return_status := FND_API.g_ret_sts_error;
1240: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1241:
1242: WHEN FND_API.G_EXC_ERROR THEN

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

1236: EXCEPTION
1237:
1238: WHEN PVX_UTILITY_PVT.resource_locked THEN
1239: x_return_status := FND_API.g_ret_sts_error;
1240: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1241:
1242: WHEN FND_API.G_EXC_ERROR THEN
1243: ROLLBACK TO VALIDATE_Ge_Party_Notif_;
1244: x_return_status := FND_API.G_RET_STS_ERROR;

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

1303:
1304: -- Debug Message
1305: IF (PV_DEBUG_HIGH_ON) THEN
1306:
1307: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1308: END IF;
1309: -- Standard call to get message count and if count is 1, get message info.
1310: FND_MSG_PUB.Count_And_Get
1311: (p_count => x_msg_count,