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

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

132:
133: -- Debug Message
134: IF (PV_DEBUG_HIGH_ON) THEN
135:
136: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
137: END IF;
138:
139:
140:

Line 171: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

167: -- =========================================================================
168:
169: IF FND_GLOBAL.USER_ID IS NULL
170: THEN
171: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
172: RAISE FND_API.G_EXC_ERROR;
173: END IF;
174:
175:

Line 182: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Chklst_Resp');

178: THEN
179: -- Debug message
180: IF (PV_DEBUG_HIGH_ON) THEN
181:
182: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Chklst_Resp');
183: END IF;
184:
185:
186: --Populate default values for not null columns

Line 217: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

213:
214: -- Debug Message
215: IF (PV_DEBUG_HIGH_ON) THEN
216:
217: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
218: END IF;
219:
220: -- Invoke table handler(Pv_Ge_Chklst_Resp_Pkg.Insert_Row)
221: Pv_Ge_Chklst_Resp_Pkg.Insert_Row(

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

250:
251: -- Debug Message
252: IF (PV_DEBUG_HIGH_ON) THEN
253:
254: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
255: END IF;
256:
257:
258: -- Standard call to get message count and if count is 1, get message info.

Line 265: WHEN PVX_UTILITY_PVT.resource_locked THEN

261: p_data => x_msg_data
262: );
263: EXCEPTION
264:
265: WHEN PVX_UTILITY_PVT.resource_locked THEN
266: x_return_status := FND_API.g_ret_sts_error;
267: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
268:
269: WHEN FND_API.G_EXC_ERROR THEN

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

263: EXCEPTION
264:
265: WHEN PVX_UTILITY_PVT.resource_locked THEN
266: x_return_status := FND_API.g_ret_sts_error;
267: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
268:
269: WHEN FND_API.G_EXC_ERROR THEN
270: ROLLBACK TO CREATE_Ge_Chklst_Resp_PVT;
271: x_return_status := FND_API.G_RET_STS_ERROR;

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

391:
392: -- Debug Message
393: IF (PV_DEBUG_HIGH_ON) THEN
394:
395: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
396: END IF;
397:
398:
399:

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

402:
403: -- Debug Message
404: IF (PV_DEBUG_HIGH_ON) THEN
405:
406: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
407: END IF;
408:
409: OPEN c_get_Ge_Chklst_Resp( l_tar_ge_chklst_resp_rec.chklst_response_id);
410:

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

410:
411: FETCH c_get_Ge_Chklst_Resp INTO l_ref_ge_chklst_resp_rec ;
412:
413: If ( c_get_Ge_Chklst_Resp%NOTFOUND) THEN
414: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
415: p_token_name => 'INFO',
416: p_token_value => 'Ge_Chklst_Resp') ;
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;

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

418: END IF;
419: -- Debug Message
420: IF (PV_DEBUG_HIGH_ON) THEN
421:
422: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');
423: END IF;
424: CLOSE c_get_Ge_Chklst_Resp;
425:
426:

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

425:
426:
427: If (l_tar_ge_chklst_resp_rec.object_version_number is NULL or
428: l_tar_ge_chklst_resp_rec.object_version_number = FND_API.G_MISS_NUM ) Then
429: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
430: p_token_name => 'COLUMN',
431: p_token_value => 'Last_Update_Date') ;
432: raise FND_API.G_EXC_ERROR;
433: End if;

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

432: raise FND_API.G_EXC_ERROR;
433: End if;
434: -- Check Whether record has been changed by someone else
435: If (l_tar_ge_chklst_resp_rec.object_version_number <> l_ref_ge_chklst_resp_rec.object_version_number) Then
436: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
437: p_token_name => 'INFO',
438: p_token_value => 'Ge_Chklst_Resp') ;
439: raise FND_API.G_EXC_ERROR;
440: End if;

Line 448: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Chklst_Resp');

444: THEN
445: -- Debug message
446: IF (PV_DEBUG_HIGH_ON) THEN
447:
448: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Chklst_Resp');
449: END IF;
450:
451: -- Invoke validation procedures
452: Validate_ge_chklst_resp(

Line 469: --IF (PV_DEBUG_HIGH_ON) THENPVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;

465: END IF;
466:
467:
468: -- Debug Message
469: --IF (PV_DEBUG_HIGH_ON) THENPVX_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;
470:
471: -- Invoke table handler(Pv_Ge_Chklst_Resp_Pkg.Update_Row)
472: Pv_Ge_Chklst_Resp_Pkg.Update_Row(
473: p_chklst_response_id => p_ge_chklst_resp_rec.chklst_response_id,

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

493:
494: -- Debug Message
495: IF (PV_DEBUG_HIGH_ON) THEN
496:
497: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
498: END IF;
499:
500:
501: -- Standard call to get message count and if count is 1, get message info.

Line 508: WHEN PVX_UTILITY_PVT.resource_locked THEN

504: p_data => x_msg_data
505: );
506: EXCEPTION
507:
508: WHEN PVX_UTILITY_PVT.resource_locked THEN
509: x_return_status := FND_API.g_ret_sts_error;
510: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
511:
512: WHEN FND_API.G_EXC_ERROR THEN

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

506: EXCEPTION
507:
508: WHEN PVX_UTILITY_PVT.resource_locked THEN
509: x_return_status := FND_API.g_ret_sts_error;
510: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
511:
512: WHEN FND_API.G_EXC_ERROR THEN
513: ROLLBACK TO UPDATE_Ge_Chklst_Resp_PVT;
514: x_return_status := FND_API.G_RET_STS_ERROR;

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

620:
621: -- Debug Message
622: IF (PV_DEBUG_HIGH_ON) THEN
623:
624: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
625: END IF;
626:
627:
628:

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

634: --
635: -- Debug Message
636: IF (PV_DEBUG_HIGH_ON) THEN
637:
638: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
639: END IF;
640:
641: -- Invoke table handler(Pv_Ge_Chklst_Resp_Pkg.Delete_Row)
642: Pv_Ge_Chklst_Resp_Pkg.Delete_Row(

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

655:
656: -- Debug Message
657: IF (PV_DEBUG_HIGH_ON) THEN
658:
659: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
660: END IF;
661:
662:
663: -- Standard call to get message count and if count is 1, get message info.

Line 670: WHEN PVX_UTILITY_PVT.resource_locked THEN

666: p_data => x_msg_data
667: );
668: EXCEPTION
669:
670: WHEN PVX_UTILITY_PVT.resource_locked THEN
671: x_return_status := FND_API.g_ret_sts_error;
672: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
673:
674: WHEN FND_API.G_EXC_ERROR THEN

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

668: EXCEPTION
669:
670: WHEN PVX_UTILITY_PVT.resource_locked THEN
671: x_return_status := FND_API.g_ret_sts_error;
672: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
673:
674: WHEN FND_API.G_EXC_ERROR THEN
675: ROLLBACK TO DELETE_Ge_Chklst_Resp_PVT;
676: x_return_status := FND_API.G_RET_STS_ERROR;

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

764:
765: -- Debug Message
766: IF (PV_DEBUG_HIGH_ON) THEN
767:
768: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
769: END IF;
770:
771:
772: -- Initialize message list if p_init_msg_list is set to TRUE.

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

802: p_count => x_msg_count,
803: p_data => x_msg_data);
804: IF (PV_DEBUG_HIGH_ON) THEN
805:
806: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
807: END IF;
808: EXCEPTION
809:
810: WHEN PVX_UTILITY_PVT.resource_locked THEN

Line 810: WHEN PVX_UTILITY_PVT.resource_locked THEN

806: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
807: END IF;
808: EXCEPTION
809:
810: WHEN PVX_UTILITY_PVT.resource_locked THEN
811: x_return_status := FND_API.g_ret_sts_error;
812: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
813:
814: WHEN FND_API.G_EXC_ERROR THEN

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

808: EXCEPTION
809:
810: WHEN PVX_UTILITY_PVT.resource_locked THEN
811: x_return_status := FND_API.g_ret_sts_error;
812: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
813:
814: WHEN FND_API.G_EXC_ERROR THEN
815: ROLLBACK TO LOCK_Ge_Chklst_Resp_PVT;
816: x_return_status := FND_API.G_RET_STS_ERROR;

Line 864: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

860: x_return_status := FND_API.g_ret_sts_success;
861: IF p_validation_mode = JTF_PLSQL_API.g_create
862: AND p_ge_chklst_resp_rec.chklst_response_id IS NOT NULL
863: THEN
864: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
865: 'pv_ge_chklst_responses',
866: 'chklst_response_id = ''' || p_ge_chklst_resp_rec.chklst_response_id ||''''
867: );
868: END IF;

Line 871: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_chklst_response_id_DUPLICATE');

867: );
868: END IF;
869:
870: IF l_valid_flag = FND_API.g_false THEN
871: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_chklst_response_id_DUPLICATE');
872: x_return_status := FND_API.g_ret_sts_error;
873: END IF;
874:
875: END check_Ge_Chklst_Resp_Uk_Items;

Line 892: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHKLST_RESPONSE_ID' );

888: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
889:
890:
891: IF p_ge_chklst_resp_rec.chklst_response_id = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.chklst_response_id IS NULL THEN
892: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHKLST_RESPONSE_ID' );
893: x_return_status := FND_API.g_ret_sts_error;
894: END IF;
895:
896:

Line 898: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHECKLIST_ITEM_ID' );

894: END IF;
895:
896:
897: IF p_ge_chklst_resp_rec.checklist_item_id = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.checklist_item_id IS NULL THEN
898: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHECKLIST_ITEM_ID' );
899: x_return_status := FND_API.g_ret_sts_error;
900: END IF;
901:
902:

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

900: END IF;
901:
902:
903: IF p_ge_chklst_resp_rec.object_version_number = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.object_version_number IS NULL THEN
904: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
905: x_return_status := FND_API.g_ret_sts_error;
906: END IF;
907:
908:

Line 910: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_RESPONSE_FOR_ENTITY_CODE' );

906: END IF;
907:
908:
909: IF p_ge_chklst_resp_rec.arc_response_for_entity_code = FND_API.g_miss_char OR p_ge_chklst_resp_rec.arc_response_for_entity_code IS NULL THEN
910: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_RESPONSE_FOR_ENTITY_CODE' );
911: x_return_status := FND_API.g_ret_sts_error;
912: END IF;
913:
914:

Line 916: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FLAG' );

912: END IF;
913:
914:
915: IF p_ge_chklst_resp_rec.response_flag = FND_API.g_miss_char OR p_ge_chklst_resp_rec.response_flag IS NULL THEN
916: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FLAG' );
917: x_return_status := FND_API.g_ret_sts_error;
918: END IF;
919:
920:

Line 922: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FOR_ENTITY_ID' );

918: END IF;
919:
920:
921: IF p_ge_chklst_resp_rec.response_for_entity_id = FND_API.G_MISS_NUM OR p_ge_chklst_resp_rec.response_for_entity_id IS NULL THEN
922: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FOR_ENTITY_ID' );
923: x_return_status := FND_API.g_ret_sts_error;
924: END IF;
925:
926:

Line 931: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHKLST_RESPONSE_ID' );

927: ELSE
928:
929:
930: IF p_ge_chklst_resp_rec.chklst_response_id = FND_API.G_MISS_NUM THEN
931: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHKLST_RESPONSE_ID' );
932: x_return_status := FND_API.g_ret_sts_error;
933: END IF;
934:
935:

Line 937: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHECKLIST_ITEM_ID' );

933: END IF;
934:
935:
936: IF p_ge_chklst_resp_rec.checklist_item_id = FND_API.G_MISS_NUM THEN
937: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHECKLIST_ITEM_ID' );
938: x_return_status := FND_API.g_ret_sts_error;
939: END IF;
940:
941:

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

939: END IF;
940:
941:
942: IF p_ge_chklst_resp_rec.object_version_number = FND_API.G_MISS_NUM THEN
943: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
944: x_return_status := FND_API.g_ret_sts_error;
945: END IF;
946:
947:

Line 949: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_RESPONSE_FOR_ENTITY_CODE' );

945: END IF;
946:
947:
948: IF p_ge_chklst_resp_rec.arc_response_for_entity_code = FND_API.g_miss_char THEN
949: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_RESPONSE_FOR_ENTITY_CODE' );
950: x_return_status := FND_API.g_ret_sts_error;
951: END IF;
952:
953:

Line 955: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FLAG' );

951: END IF;
952:
953:
954: IF p_ge_chklst_resp_rec.response_flag = FND_API.g_miss_char THEN
955: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FLAG' );
956: x_return_status := FND_API.g_ret_sts_error;
957: END IF;
958:
959:

Line 961: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FOR_ENTITY_ID' );

957: END IF;
958:
959:
960: IF p_ge_chklst_resp_rec.response_for_entity_id = FND_API.G_MISS_NUM THEN
961: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'RESPONSE_FOR_ENTITY_ID' );
962: x_return_status := FND_API.g_ret_sts_error;
963: END IF;
964: END IF;
965:

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

1230:
1231: -- Debug Message
1232: IF (PV_DEBUG_HIGH_ON) THEN
1233:
1234: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1235: END IF;
1236:
1237:
1238:

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

1242:
1243: -- Debug Message
1244: IF (PV_DEBUG_HIGH_ON) THEN
1245:
1246: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1247: END IF;
1248:
1249:
1250: -- Standard call to get message count and if count is 1, get message info.

Line 1257: WHEN PVX_UTILITY_PVT.resource_locked THEN

1253: p_data => x_msg_data
1254: );
1255: EXCEPTION
1256:
1257: WHEN PVX_UTILITY_PVT.resource_locked THEN
1258: x_return_status := FND_API.g_ret_sts_error;
1259: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1260:
1261: WHEN FND_API.G_EXC_ERROR THEN

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

1255: EXCEPTION
1256:
1257: WHEN PVX_UTILITY_PVT.resource_locked THEN
1258: x_return_status := FND_API.g_ret_sts_error;
1259: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1260:
1261: WHEN FND_API.G_EXC_ERROR THEN
1262: ROLLBACK TO VALIDATE_Ge_Chklst_Resp_;
1263: x_return_status := FND_API.G_RET_STS_ERROR;

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

1322:
1323: -- Debug Message
1324: IF (PV_DEBUG_HIGH_ON) THEN
1325:
1326: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1327: END IF;
1328: -- Standard call to get message count and if count is 1, get message info.
1329: FND_MSG_PUB.Count_And_Get
1330: (p_count => x_msg_count,