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_HL_PARAM_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_Hl_Param');

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

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_Hl_Param_Pkg.Insert_Row)
198: Pv_Ge_Hl_Param_Pkg.Insert_Row(

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

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

Line 242: WHEN PVX_UTILITY_PVT.resource_locked THEN

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

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

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

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

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

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

379:
380: -- Debug Message
381: IF (PV_DEBUG_HIGH_ON) THEN
382:
383: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
384: END IF;
385:
386: OPEN c_get_Ge_Hl_Param( l_tar_ge_hl_param_rec.history_log_param_id);
387:

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

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

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

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

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

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

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

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

Line 425: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Hl_Param');

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

Line 448: PVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

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

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

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

Line 489: WHEN PVX_UTILITY_PVT.resource_locked THEN

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

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

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

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

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

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

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

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

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

Line 651: WHEN PVX_UTILITY_PVT.resource_locked THEN

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

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

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

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

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

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

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

Line 791: WHEN PVX_UTILITY_PVT.resource_locked THEN

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

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

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

Line 845: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

841: x_return_status := FND_API.g_ret_sts_success;
842: IF p_validation_mode = JTF_PLSQL_API.g_create
843: AND p_ge_hl_param_rec.history_log_param_id IS NOT NULL
844: THEN
845: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
846: 'pv_ge_history_log_params',
847: 'history_log_param_id = ''' || p_ge_hl_param_rec.history_log_param_id ||''''
848: );
849: END IF;

Line 852: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_history_log_param_id_DUPLICATE');

848: );
849: END IF;
850:
851: IF l_valid_flag = FND_API.g_false THEN
852: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_history_log_param_id_DUPLICATE');
853: x_return_status := FND_API.g_ret_sts_error;
854: END IF;
855:
856: END check_Ge_Hl_Param_Uk_Items;

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

869: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
870:
871:
872: IF p_ge_hl_param_rec.history_log_param_id = FND_API.G_MISS_NUM OR p_ge_hl_param_rec.history_log_param_id IS NULL THEN
873: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'HISTORY_LOG_PARAM_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', 'ENTITY_HISTORY_LOG_ID' );

875: END IF;
876:
877:
878: IF p_ge_hl_param_rec.entity_history_log_id = FND_API.G_MISS_NUM OR p_ge_hl_param_rec.entity_history_log_id IS NULL THEN
879: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENTITY_HISTORY_LOG_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', 'PARAM_NAME' );

881: END IF;
882:
883:
884: IF p_ge_hl_param_rec.param_name = FND_API.g_miss_char OR p_ge_hl_param_rec.param_name IS NULL THEN
885: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PARAM_NAME' );
886: x_return_status := FND_API.g_ret_sts_error;
887: END IF;
888:
889:

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

887: END IF;
888:
889:
890: IF p_ge_hl_param_rec.object_version_number = FND_API.G_MISS_NUM OR p_ge_hl_param_rec.object_version_number IS NULL THEN
891: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
892: x_return_status := FND_API.g_ret_sts_error;
893: END IF;
894:
895:

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

896: ELSE
897:
898:
899: IF p_ge_hl_param_rec.history_log_param_id = FND_API.G_MISS_NUM THEN
900: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'HISTORY_LOG_PARAM_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', 'ENTITY_HISTORY_LOG_ID' );

902: END IF;
903:
904:
905: IF p_ge_hl_param_rec.entity_history_log_id = FND_API.G_MISS_NUM THEN
906: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENTITY_HISTORY_LOG_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', 'PARAM_NAME' );

908: END IF;
909:
910:
911: IF p_ge_hl_param_rec.param_name = FND_API.g_miss_char THEN
912: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PARAM_NAME' );
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915:
916:

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

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

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

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

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

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

Line 1206: WHEN PVX_UTILITY_PVT.resource_locked THEN

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

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

1204: EXCEPTION
1205:
1206: WHEN PVX_UTILITY_PVT.resource_locked THEN
1207: x_return_status := FND_API.g_ret_sts_error;
1208: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1209:
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: ROLLBACK TO VALIDATE_Ge_Hl_Param_;
1212: x_return_status := FND_API.G_RET_STS_ERROR;

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

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