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

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

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

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

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

Line 180: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Chklst');

176: THEN
177: -- Debug message
178: IF (PV_DEBUG_HIGH_ON) THEN
179:
180: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Chklst');
181: END IF;
182:
183: -- Populate the default required items Anubhav
184: l_ge_chklst_rec.last_update_date := SYSDATE;

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

209:
210: -- Debug Message
211: IF (PV_DEBUG_HIGH_ON) THEN
212:
213: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
214: END IF;
215:
216: -- Adding the call to get the latest sequence number
217: FOR cur IN (SELECT MAX(sequence_num) temp_sequence_num from pv_ge_chklst_items_vl where (used_by_entity_id = p_ge_chklst_rec.used_by_entity_id ))

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

257:
258: -- Debug Message
259: IF (PV_DEBUG_HIGH_ON) THEN
260:
261: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
262: END IF;
263:
264:
265: -- Standard call to get message count and if count is 1, get message info.

Line 272: WHEN PVX_UTILITY_PVT.resource_locked THEN

268: p_data => x_msg_data
269: );
270: EXCEPTION
271:
272: WHEN PVX_UTILITY_PVT.resource_locked THEN
273: x_return_status := FND_API.g_ret_sts_error;
274: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
275:
276: WHEN FND_API.G_EXC_ERROR THEN

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

270: EXCEPTION
271:
272: WHEN PVX_UTILITY_PVT.resource_locked THEN
273: x_return_status := FND_API.g_ret_sts_error;
274: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
275:
276: WHEN FND_API.G_EXC_ERROR THEN
277: ROLLBACK TO CREATE_Ge_Chklst_PVT;
278: x_return_status := FND_API.G_RET_STS_ERROR;

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

396: END IF;
397:
398: -- Debug Message
399: IF (PV_DEBUG_HIGH_ON) THEN
400: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
401: END IF;
402:
403:
404: -- Initialize API return status to SUCCESS

Line 410: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' : inside loop');

406:
407:
408: OPEN c_get_chklst_rec (p_src_object_id);
409: LOOP
410: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' : inside loop');
411: FETCH c_get_chklst_rec bulk collect into
412: sequence_num_array, is_required_flag_array, enabled_flag_array
413: LIMIT 100;
414: PVX_UTILITY_PVT.debug_message(l_api_name || 'sequence_num_array.count =' || to_char(sequence_num_array.count));

Line 414: PVX_UTILITY_PVT.debug_message(l_api_name || 'sequence_num_array.count =' || to_char(sequence_num_array.count));

410: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' : inside loop');
411: FETCH c_get_chklst_rec bulk collect into
412: sequence_num_array, is_required_flag_array, enabled_flag_array
413: LIMIT 100;
414: PVX_UTILITY_PVT.debug_message(l_api_name || 'sequence_num_array.count =' || to_char(sequence_num_array.count));
415:
416: for i in 1..sequence_num_array.count LOOP
417: PVX_UTILITY_PVT.debug_message(l_api_name || 'testing1');
418:

Line 417: PVX_UTILITY_PVT.debug_message(l_api_name || 'testing1');

413: LIMIT 100;
414: PVX_UTILITY_PVT.debug_message(l_api_name || 'sequence_num_array.count =' || to_char(sequence_num_array.count));
415:
416: for i in 1..sequence_num_array.count LOOP
417: PVX_UTILITY_PVT.debug_message(l_api_name || 'testing1');
418:
419: l_dummy := NULL;
420: OPEN c_id;
421: LOOP

Line 422: PVX_UTILITY_PVT.debug_message(l_api_name || 'testing2');

418:
419: l_dummy := NULL;
420: OPEN c_id;
421: LOOP
422: PVX_UTILITY_PVT.debug_message(l_api_name || 'testing2');
423: FETCH c_id INTO checklist_item_id_array(i);
424: OPEN c_id_exists(checklist_item_id_array(i));
425: FETCH c_id_exists INTO l_dummy;
426: CLOSE c_id_exists;

Line 430: PVX_UTILITY_PVT.debug_message(l_api_name || 'checklist_item_id_array(i) =' || to_char(checklist_item_id_array(i)));

426: CLOSE c_id_exists;
427: EXIT WHEN l_dummy IS NULL;
428: END LOOP;
429: CLOSE c_id;
430: PVX_UTILITY_PVT.debug_message(l_api_name || 'checklist_item_id_array(i) =' || to_char(checklist_item_id_array(i)));
431:
432: END LOOP;
433:
434:

Line 435: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' : insert into b table');

431:
432: END LOOP;
433:
434:
435: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' : insert into b table');
436:
437: forall i in 1..checklist_item_id_array.count
438: INSERT INTO pv_ge_chklst_items_b(
439: checklist_item_id,

Line 484: PVX_UTILITY_PVT.debug_message(l_api_name || 'k = ' || to_char(k));

480: for k in 1..old_checklist_item_id_array.count loop
481: if ((k <> 1) and (old_checklist_item_id_array(k) <> old_checklist_item_id_array(k-1))) then
482: elmt_count := elmt_count + 1;
483: end if;
484: PVX_UTILITY_PVT.debug_message(l_api_name || 'k = ' || to_char(k));
485: PVX_UTILITY_PVT.debug_message(l_api_name || 'elmt_count = ' || to_char(elmt_count));
486: new_checklist_item_id_array(k) := checklist_item_id_array(elmt_count);
487:
488: end loop;

Line 485: PVX_UTILITY_PVT.debug_message(l_api_name || 'elmt_count = ' || to_char(elmt_count));

481: if ((k <> 1) and (old_checklist_item_id_array(k) <> old_checklist_item_id_array(k-1))) then
482: elmt_count := elmt_count + 1;
483: end if;
484: PVX_UTILITY_PVT.debug_message(l_api_name || 'k = ' || to_char(k));
485: PVX_UTILITY_PVT.debug_message(l_api_name || 'elmt_count = ' || to_char(elmt_count));
486: new_checklist_item_id_array(k) := checklist_item_id_array(elmt_count);
487:
488: end loop;
489:

Line 491: --PVX_UTILITY_PVT.debug_message(l_api_name || 'insert into pv_checklist_items_tl');

487:
488: end loop;
489:
490: Forall j in 1..old_checklist_item_id_array.count
491: --PVX_UTILITY_PVT.debug_message(l_api_name || 'insert into pv_checklist_items_tl');
492: INSERT INTO pv_ge_chklst_items_tl(
493: checklist_item_id,
494: language ,
495: last_update_date ,

Line 533: WHEN PVX_Utility_PVT.resource_locked THEN

529: );
530:
531: EXCEPTION
532:
533: WHEN PVX_Utility_PVT.resource_locked THEN
534: x_return_status := FND_API.g_ret_sts_error;
535: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
536:
537: WHEN FND_API.G_EXC_ERROR THEN

Line 535: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

531: EXCEPTION
532:
533: WHEN PVX_Utility_PVT.resource_locked THEN
534: x_return_status := FND_API.g_ret_sts_error;
535: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
536:
537: WHEN FND_API.G_EXC_ERROR THEN
538: ROLLBACK TO Copy_Row;
539: x_return_status := FND_API.G_RET_STS_ERROR;

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

659:
660: -- Debug Message
661: IF (PV_DEBUG_HIGH_ON) THEN
662:
663: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
664: END IF;
665:
666:
667:

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

670:
671: -- Debug Message
672: IF (PV_DEBUG_HIGH_ON) THEN
673:
674: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
675: END IF;
676:
677: OPEN c_get_Ge_Chklst( l_tar_ge_chklst_rec.checklist_item_id);
678:

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

678:
679: FETCH c_get_Ge_Chklst INTO l_ref_ge_chklst_rec ;
680:
681: If ( c_get_Ge_Chklst%NOTFOUND) THEN
682: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
683: p_token_name => 'INFO',
684: p_token_value => 'Ge_Chklst') ;
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;

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

686: END IF;
687: -- Debug Message
688: IF (PV_DEBUG_HIGH_ON) THEN
689:
690: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');
691: END IF;
692: CLOSE c_get_Ge_Chklst;
693:
694:

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

693:
694:
695: If (l_tar_ge_chklst_rec.object_version_number is NULL or
696: l_tar_ge_chklst_rec.object_version_number = FND_API.G_MISS_NUM ) Then
697: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
698: p_token_name => 'COLUMN',
699: p_token_value => 'Last_Update_Date') ;
700: raise FND_API.G_EXC_ERROR;
701: End if;

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

700: raise FND_API.G_EXC_ERROR;
701: End if;
702: -- Check Whether record has been changed by someone else
703: If (l_tar_ge_chklst_rec.object_version_number <> l_ref_ge_chklst_rec.object_version_number) Then
704: PVX_UTILITY_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
705: p_token_name => 'INFO',
706: p_token_value => 'Ge_Chklst') ;
707: raise FND_API.G_EXC_ERROR;
708: End if;

Line 716: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Chklst');

712: THEN
713: -- Debug message
714: IF (PV_DEBUG_HIGH_ON) THEN
715:
716: PVX_UTILITY_PVT.debug_message('Private API: Validate_Ge_Chklst');
717: END IF;
718:
719: -- Invoke validation procedures
720: Validate_ge_chklst(

Line 737: --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;

733: END IF;
734:
735:
736: -- Debug Message
737: --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;
738:
739: -- Invoke table handler(Pv_Ge_Chklst_Pkg.Update_Row)
740: Pv_Ge_Chklst_Pkg.Update_Row(
741: p_checklist_item_id => p_ge_chklst_rec.checklist_item_id,

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

763:
764: -- Debug Message
765: IF (PV_DEBUG_HIGH_ON) THEN
766:
767: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
768: END IF;
769:
770:
771: -- Standard call to get message count and if count is 1, get message info.

Line 778: WHEN PVX_UTILITY_PVT.resource_locked THEN

774: p_data => x_msg_data
775: );
776: EXCEPTION
777:
778: WHEN PVX_UTILITY_PVT.resource_locked THEN
779: x_return_status := FND_API.g_ret_sts_error;
780: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
781:
782: WHEN FND_API.G_EXC_ERROR THEN

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

776: EXCEPTION
777:
778: WHEN PVX_UTILITY_PVT.resource_locked THEN
779: x_return_status := FND_API.g_ret_sts_error;
780: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
781:
782: WHEN FND_API.G_EXC_ERROR THEN
783: ROLLBACK TO UPDATE_Ge_Chklst_PVT;
784: x_return_status := FND_API.G_RET_STS_ERROR;

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

890:
891: -- Debug Message
892: IF (PV_DEBUG_HIGH_ON) THEN
893:
894: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
895: END IF;
896:
897:
898:

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

904: --
905: -- Debug Message
906: IF (PV_DEBUG_HIGH_ON) THEN
907:
908: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
909: END IF;
910:
911: -- Invoke table handler(Pv_Ge_Chklst_Pkg.Delete_Row)
912: Pv_Ge_Chklst_Pkg.Delete_Row(

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

925:
926: -- Debug Message
927: IF (PV_DEBUG_HIGH_ON) THEN
928:
929: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
930: END IF;
931:
932:
933: -- Standard call to get message count and if count is 1, get message info.

Line 940: WHEN PVX_UTILITY_PVT.resource_locked THEN

936: p_data => x_msg_data
937: );
938: EXCEPTION
939:
940: WHEN PVX_UTILITY_PVT.resource_locked THEN
941: x_return_status := FND_API.g_ret_sts_error;
942: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
943:
944: WHEN FND_API.G_EXC_ERROR THEN

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

938: EXCEPTION
939:
940: WHEN PVX_UTILITY_PVT.resource_locked THEN
941: x_return_status := FND_API.g_ret_sts_error;
942: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
943:
944: WHEN FND_API.G_EXC_ERROR THEN
945: ROLLBACK TO DELETE_Ge_Chklst_PVT;
946: x_return_status := FND_API.G_RET_STS_ERROR;

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

1034:
1035: -- Debug Message
1036: IF (PV_DEBUG_HIGH_ON) THEN
1037:
1038: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1039: END IF;
1040:
1041:
1042: -- Initialize message list if p_init_msg_list is set to TRUE.

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

1072: p_count => x_msg_count,
1073: p_data => x_msg_data);
1074: IF (PV_DEBUG_HIGH_ON) THEN
1075:
1076: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
1077: END IF;
1078: EXCEPTION
1079:
1080: WHEN PVX_UTILITY_PVT.resource_locked THEN

Line 1080: WHEN PVX_UTILITY_PVT.resource_locked THEN

1076: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');
1077: END IF;
1078: EXCEPTION
1079:
1080: WHEN PVX_UTILITY_PVT.resource_locked THEN
1081: x_return_status := FND_API.g_ret_sts_error;
1082: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1083:
1084: WHEN FND_API.G_EXC_ERROR THEN

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

1078: EXCEPTION
1079:
1080: WHEN PVX_UTILITY_PVT.resource_locked THEN
1081: x_return_status := FND_API.g_ret_sts_error;
1082: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1083:
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: ROLLBACK TO LOCK_Ge_Chklst_PVT;
1086: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1134: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(

1130: x_return_status := FND_API.g_ret_sts_success;
1131: IF p_validation_mode = JTF_PLSQL_API.g_create
1132: AND p_ge_chklst_rec.checklist_item_id IS NOT NULL
1133: THEN
1134: l_valid_flag := PVX_UTILITY_PVT.check_uniqueness(
1135: 'pv_ge_chklst_items_b',
1136: 'checklist_item_id = ''' || p_ge_chklst_rec.checklist_item_id ||''''
1137: );
1138: END IF;

Line 1141: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_checklist_item_id_DUPLICATE');

1137: );
1138: END IF;
1139:
1140: IF l_valid_flag = FND_API.g_false THEN
1141: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_checklist_item_id_DUPLICATE');
1142: x_return_status := FND_API.g_ret_sts_error;
1143: END IF;
1144:
1145: END check_Ge_Chklst_Uk_Items;

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

1158: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1159:
1160:
1161: IF p_ge_chklst_rec.checklist_item_id = FND_API.G_MISS_NUM OR p_ge_chklst_rec.checklist_item_id IS NULL THEN
1162: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHECKLIST_ITEM_ID' );
1163: x_return_status := FND_API.g_ret_sts_error;
1164: END IF;
1165:
1166:

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

1164: END IF;
1165:
1166:
1167: IF p_ge_chklst_rec.object_version_number = FND_API.G_MISS_NUM OR p_ge_chklst_rec.object_version_number IS NULL THEN
1168: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
1169: x_return_status := FND_API.g_ret_sts_error;
1170: END IF;
1171:
1172:

Line 1174: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_USED_BY_ENTITY_CODE' );

1170: END IF;
1171:
1172:
1173: IF p_ge_chklst_rec.arc_used_by_entity_code = FND_API.g_miss_char OR p_ge_chklst_rec.arc_used_by_entity_code IS NULL THEN
1174: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_USED_BY_ENTITY_CODE' );
1175: x_return_status := FND_API.g_ret_sts_error;
1176: END IF;
1177:
1178:

Line 1180: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USED_BY_ENTITY_ID' );

1176: END IF;
1177:
1178:
1179: IF p_ge_chklst_rec.used_by_entity_id = FND_API.G_MISS_NUM OR p_ge_chklst_rec.used_by_entity_id IS NULL THEN
1180: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USED_BY_ENTITY_ID' );
1181: x_return_status := FND_API.g_ret_sts_error;
1182: END IF;
1183:
1184:

Line 1186: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );

1182: END IF;
1183:
1184:
1185: IF p_ge_chklst_rec.sequence_num = FND_API.G_MISS_NUM OR p_ge_chklst_rec.sequence_num IS NULL THEN
1186: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );
1187: x_return_status := FND_API.g_ret_sts_error;
1188: END IF;
1189:
1190:

Line 1192: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'IS_REQUIRED_FLAG' );

1188: END IF;
1189:
1190:
1191: IF p_ge_chklst_rec.is_required_flag = FND_API.g_miss_char OR p_ge_chklst_rec.is_required_flag IS NULL THEN
1192: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'IS_REQUIRED_FLAG' );
1193: x_return_status := FND_API.g_ret_sts_error;
1194: END IF;
1195:
1196:

Line 1198: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENABLED_FLAG' );

1194: END IF;
1195:
1196:
1197: IF p_ge_chklst_rec.enabled_flag = FND_API.g_miss_char OR p_ge_chklst_rec.enabled_flag IS NULL THEN
1198: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENABLED_FLAG' );
1199: x_return_status := FND_API.g_ret_sts_error;
1200: END IF;
1201:
1202:

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

1203: ELSE
1204:
1205:
1206: IF p_ge_chklst_rec.checklist_item_id = FND_API.G_MISS_NUM THEN
1207: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHECKLIST_ITEM_ID' );
1208: x_return_status := FND_API.g_ret_sts_error;
1209: END IF;
1210:
1211:

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

1209: END IF;
1210:
1211:
1212: IF p_ge_chklst_rec.object_version_number = FND_API.G_MISS_NUM THEN
1213: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
1214: x_return_status := FND_API.g_ret_sts_error;
1215: END IF;
1216:
1217:

Line 1219: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_USED_BY_ENTITY_CODE' );

1215: END IF;
1216:
1217:
1218: IF p_ge_chklst_rec.arc_used_by_entity_code = FND_API.g_miss_char THEN
1219: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ARC_USED_BY_ENTITY_CODE' );
1220: x_return_status := FND_API.g_ret_sts_error;
1221: END IF;
1222:
1223:

Line 1225: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USED_BY_ENTITY_ID' );

1221: END IF;
1222:
1223:
1224: IF p_ge_chklst_rec.used_by_entity_id = FND_API.G_MISS_NUM THEN
1225: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'USED_BY_ENTITY_ID' );
1226: x_return_status := FND_API.g_ret_sts_error;
1227: END IF;
1228:
1229:

Line 1231: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );

1227: END IF;
1228:
1229:
1230: IF p_ge_chklst_rec.sequence_num = FND_API.G_MISS_NUM THEN
1231: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SEQUENCE_NUM' );
1232: x_return_status := FND_API.g_ret_sts_error;
1233: END IF;
1234:
1235:

Line 1237: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'IS_REQUIRED_FLAG' );

1233: END IF;
1234:
1235:
1236: IF p_ge_chklst_rec.is_required_flag = FND_API.g_miss_char THEN
1237: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'IS_REQUIRED_FLAG' );
1238: x_return_status := FND_API.g_ret_sts_error;
1239: END IF;
1240:
1241:

Line 1243: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENABLED_FLAG' );

1239: END IF;
1240:
1241:
1242: IF p_ge_chklst_rec.enabled_flag = FND_API.g_miss_char THEN
1243: PVX_UTILITY_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENABLED_FLAG' );
1244: x_return_status := FND_API.g_ret_sts_error;
1245: END IF;
1246: END IF;
1247:

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

1517:
1518: -- Debug Message
1519: IF (PV_DEBUG_HIGH_ON) THEN
1520:
1521: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1522: END IF;
1523:
1524:
1525:

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

1529:
1530: -- Debug Message
1531: IF (PV_DEBUG_HIGH_ON) THEN
1532:
1533: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1534: END IF;
1535:
1536:
1537: -- Standard call to get message count and if count is 1, get message info.

Line 1544: WHEN PVX_UTILITY_PVT.resource_locked THEN

1540: p_data => x_msg_data
1541: );
1542: EXCEPTION
1543:
1544: WHEN PVX_UTILITY_PVT.resource_locked THEN
1545: x_return_status := FND_API.g_ret_sts_error;
1546: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1547:
1548: WHEN FND_API.G_EXC_ERROR THEN

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

1542: EXCEPTION
1543:
1544: WHEN PVX_UTILITY_PVT.resource_locked THEN
1545: x_return_status := FND_API.g_ret_sts_error;
1546: PVX_UTILITY_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1547:
1548: WHEN FND_API.G_EXC_ERROR THEN
1549: ROLLBACK TO VALIDATE_Ge_Chklst_;
1550: x_return_status := FND_API.G_RET_STS_ERROR;

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

1609:
1610: -- Debug Message
1611: IF (PV_DEBUG_HIGH_ON) THEN
1612:
1613: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1614: END IF;
1615: -- Standard call to get message count and if count is 1, get message info.
1616: FND_MSG_PUB.Count_And_Get
1617: (p_count => x_msg_count,