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

Line 133: PVX_UTILITY_PVT.debug_message('Inside Create Proc ');

129: IF (PV_DEBUG_HIGH_ON) THEN
130:
131:
132:
133: PVX_UTILITY_PVT.debug_message('Inside Create Proc ');
134:
135: END IF;
136:
137: -- Standard Start of API savepoint

Line 144: PVX_UTILITY_PVT.debug_message('Comparing compatibility ');

140: IF (PV_DEBUG_HIGH_ON) THEN
141:
142:
143:
144: PVX_UTILITY_PVT.debug_message('Comparing compatibility ');
145:
146: END IF;
147:
148:

Line 164: PVX_UTILITY_PVT.debug_message('After Comparing compatibility ');

160: IF (PV_DEBUG_HIGH_ON) THEN
161:
162:
163:
164: PVX_UTILITY_PVT.debug_message('After Comparing compatibility ');
165:
166: END IF;
167:
168: -- Initialize message list if p_init_msg_list is set to TRUE.

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

174:
175: -- Debug Message
176: IF (PV_DEBUG_HIGH_ON) THEN
177:
178: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
179: END IF;
180:
181:
182: -- Initialize API return status to SUCCESS

Line 265: PVX_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

261: -- =========================================================================
262:
263: IF FND_GLOBAL.USER_ID IS NULL
264: THEN
265: PVX_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
266: RAISE FND_API.G_EXC_ERROR;
267: END IF;
268:
269: IF (PV_DEBUG_HIGH_ON) THEN

Line 273: PVX_UTILITY_PVT.debug_message('Before Validating ');

269: IF (PV_DEBUG_HIGH_ON) THEN
270:
271:
272:
273: PVX_UTILITY_PVT.debug_message('Before Validating ');
274:
275: END IF;
276:
277: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 282: PVX_UTILITY_PVT.debug_message('Private API: Validate_Pec_Rules');

278: THEN
279: -- Debug message
280: IF (PV_DEBUG_HIGH_ON) THEN
281:
282: PVX_UTILITY_PVT.debug_message('Private API: Validate_Pec_Rules');
283: END IF;
284:
285: l_pec_rules_rec.last_update_date := SYSDATE;
286: l_pec_rules_rec.last_updated_by := FND_GLOBAL.user_id;

Line 311: PVX_UTILITY_PVT.debug_message('After Validating ');

307: IF (PV_DEBUG_HIGH_ON) THEN
308:
309:
310:
311: PVX_UTILITY_PVT.debug_message('After Validating ');
312:
313: END IF;
314:
315:

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

320:
321: -- Debug Message
322: IF (PV_DEBUG_HIGH_ON) THEN
323:
324: PVX_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
325: END IF;
326:
327:
328:

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

391:
392: -- Debug Message
393: IF (PV_DEBUG_HIGH_ON) THEN
394:
395: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
396: END IF;
397:
398:
399: -- Standard call to get message count and if count is 1, get message info.

Line 408: WHEN PVX_Utility_PVT.resource_locked THEN

404:
405:
406: EXCEPTION
407:
408: WHEN PVX_Utility_PVT.resource_locked THEN
409: x_return_status := FND_API.g_ret_sts_error;
410: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
411:
412: WHEN FND_API.G_EXC_ERROR THEN

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

406: EXCEPTION
407:
408: WHEN PVX_Utility_PVT.resource_locked THEN
409: x_return_status := FND_API.g_ret_sts_error;
410: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
411:
412: WHEN FND_API.G_EXC_ERROR THEN
413: ROLLBACK TO CREATE_Pec_Rules_PVT;
414: x_return_status := FND_API.G_RET_STS_ERROR;

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

548:
549: -- Debug Message
550: IF (PV_DEBUG_HIGH_ON) THEN
551:
552: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
553: END IF;
554:
555:
556:

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

559:
560: -- Debug Message
561: IF (PV_DEBUG_HIGH_ON) THEN
562:
563: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
564: END IF;
565:
566: OPEN c_get_Pec_Rules( l_tar_pec_rules_rec.enrl_change_rule_id);
567:

Line 571: PVX_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

567:
568: FETCH c_get_Pec_Rules INTO l_ref_pec_rules_rec ;
569:
570: If ( c_get_Pec_Rules%NOTFOUND) THEN
571: PVX_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
572: p_token_name => 'INFO',
573: p_token_value => 'Pec_Rules') ;
574: RAISE FND_API.G_EXC_ERROR;
575: END IF;

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

575: END IF;
576: -- Debug Message
577: IF (PV_DEBUG_HIGH_ON) THEN
578:
579: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');
580: END IF;
581: CLOSE c_get_Pec_Rules;
582:
583: -- l_tar_pec_rules_rec.object_version_number := l_object_version_number;

Line 588: PVX_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

584:
585:
586: If (l_tar_pec_rules_rec.object_version_number is NULL or
587: l_tar_pec_rules_rec.object_version_number = FND_API.G_MISS_NUM ) Then
588: PVX_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
589: p_token_name => 'COLUMN',
590: p_token_value => 'Last_Update_Date') ;
591: raise FND_API.G_EXC_ERROR;
592: End if;

Line 595: PVX_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

591: raise FND_API.G_EXC_ERROR;
592: End if;
593: -- Check Whether record has been changed by someone else
594: If (l_tar_pec_rules_rec.object_version_number <> l_ref_pec_rules_rec.object_version_number) Then
595: PVX_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
596: p_token_name => 'INFO',
597: p_token_value => 'Pec_Rules') ;
598: raise FND_API.G_EXC_ERROR;
599: End if;

Line 607: PVX_UTILITY_PVT.debug_message('Private API: Validate_Pec_Rules');

603: THEN
604: -- Debug message
605: IF (PV_DEBUG_HIGH_ON) THEN
606:
607: PVX_UTILITY_PVT.debug_message('Private API: Validate_Pec_Rules');
608: END IF;
609:
610: -- Invoke validation procedures
611: Validate_pec_rules(

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

624: END IF;
625:
626:
627: -- Debug Message
628: --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;
629:
630: l_object_version_number := p_pec_rules_rec.object_version_number;
631:
632: -- Invoke table handler(Pv_Pec_Rules_Pkg.Update_Row)

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

679:
680: -- Debug Message
681: IF (PV_DEBUG_HIGH_ON) THEN
682:
683: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
684: END IF;
685:
686:
687: -- Standard call to get message count and if count is 1, get message info.

Line 694: WHEN PVX_Utility_PVT.resource_locked THEN

690: p_data => x_msg_data
691: );
692: EXCEPTION
693:
694: WHEN PVX_Utility_PVT.resource_locked THEN
695: x_return_status := FND_API.g_ret_sts_error;
696: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
697:
698: WHEN FND_API.G_EXC_ERROR THEN

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

692: EXCEPTION
693:
694: WHEN PVX_Utility_PVT.resource_locked THEN
695: x_return_status := FND_API.g_ret_sts_error;
696: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
697:
698: WHEN FND_API.G_EXC_ERROR THEN
699: ROLLBACK TO UPDATE_Pec_Rules_PVT;
700: x_return_status := FND_API.G_RET_STS_ERROR;

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

825:
826: -- Debug Message
827: IF (PV_DEBUG_HIGH_ON) THEN
828:
829: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
830: END IF;
831:
832:
833:

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

839: --
840: -- Debug Message
841: IF (PV_DEBUG_HIGH_ON) THEN
842:
843: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
844: END IF;
845:
846: -- Invoke table handler(Pv_Pec_Rules_Pkg.Delete_Row)
847: --Pv_Pec_Rules_Pkg.Delete_Row(

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

856:
857: -- Debug Message
858: IF (PV_DEBUG_HIGH_ON) THEN
859:
860: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
861: END IF;
862:
863: OPEN c_get_pec_rec;
864:

Line 868: PVX_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

864:
865: FETCH c_get_pec_rec INTO l_ref_pec_rules_rec ;
866:
867: If ( c_get_pec_rec%NOTFOUND) THEN
868: PVX_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
869: p_token_name => 'INFO',
870: p_token_value => 'Pec_Rules') ;
871: RAISE FND_API.G_EXC_ERROR;
872: END IF;

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

872: END IF;
873: -- Debug Message
874: IF (PV_DEBUG_HIGH_ON) THEN
875:
876: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');
877: END IF;
878: CLOSE c_get_pec_rec;
879:
880: l_object_version_number := p_object_version_number;

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

906: to_id_rev := l_ref_pec_rules_rec.change_from_program_id ;
907: -- Debug Message
908: IF (PV_DEBUG_HIGH_ON) THEN
909:
910: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select DOWNGRADE rule');
911: END IF;
912:
913: OPEN c_get_pec_rec_down(from_id_rev, to_id_rev);
914:

Line 918: --PVX_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

914:
915: FETCH c_get_pec_rec_down INTO l_ref_pec_rules_rec_down ;
916:
917: If ( c_get_pec_rec_down%NOTFOUND) THEN
918: --PVX_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
919: --p_token_name => 'INFO',
920: --p_token_value => 'Pec_Rules') ;
921: FND_MESSAGE.set_name('PV', 'PV_MISC_ERROR_GROUP_CREATE');
922: FND_MESSAGE.set_token('ID',to_char(from_id_rev));

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

926: END IF;
927: -- Debug Message
928: IF (PV_DEBUG_HIGH_ON) THEN
929:
930: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');
931: END IF;
932: CLOSE c_get_pec_rec_down;
933:
934: for downg in c_get_pec_rec_down(from_id_rev, to_id_rev) LOOP

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

957:
958: -- Debug Message
959: IF (PV_DEBUG_HIGH_ON) THEN
960:
961: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
962: END IF;
963:
964:
965: -- Standard call to get message count and if count is 1, get message info.

Line 972: WHEN PVX_Utility_PVT.resource_locked THEN

968: p_data => x_msg_data
969: );
970: EXCEPTION
971:
972: WHEN PVX_Utility_PVT.resource_locked THEN
973: x_return_status := FND_API.g_ret_sts_error;
974: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
975:
976: WHEN FND_API.G_EXC_ERROR THEN

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

970: EXCEPTION
971:
972: WHEN PVX_Utility_PVT.resource_locked THEN
973: x_return_status := FND_API.g_ret_sts_error;
974: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
975:
976: WHEN FND_API.G_EXC_ERROR THEN
977: ROLLBACK TO DELETE_Pec_Rules_PVT;
978: x_return_status := FND_API.G_RET_STS_ERROR;

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

1066:
1067: -- Debug Message
1068: IF (PV_DEBUG_HIGH_ON) THEN
1069:
1070: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1071: END IF;
1072:
1073:
1074: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1108: PVX_UTIlity_PVT.debug_message(l_full_name ||': end');

1104: p_count => x_msg_count,
1105: p_data => x_msg_data);
1106: IF (PV_DEBUG_HIGH_ON) THEN
1107:
1108: PVX_UTIlity_PVT.debug_message(l_full_name ||': end');
1109: END IF;
1110: EXCEPTION
1111:
1112: WHEN PVX_UTIlity_PVT.resource_locked THEN

Line 1112: WHEN PVX_UTIlity_PVT.resource_locked THEN

1108: PVX_UTIlity_PVT.debug_message(l_full_name ||': end');
1109: END IF;
1110: EXCEPTION
1111:
1112: WHEN PVX_UTIlity_PVT.resource_locked THEN
1113: x_return_status := FND_API.g_ret_sts_error;
1114: PVX_UTIlity_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1115:
1116: WHEN FND_API.G_EXC_ERROR THEN

Line 1114: PVX_UTIlity_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1110: EXCEPTION
1111:
1112: WHEN PVX_UTIlity_PVT.resource_locked THEN
1113: x_return_status := FND_API.g_ret_sts_error;
1114: PVX_UTIlity_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1115:
1116: WHEN FND_API.G_EXC_ERROR THEN
1117: ROLLBACK TO LOCK_Pec_Rules_PVT;
1118: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1164: PVX_UTILITY_PVT.debug_message('Inside check uk 1');

1160:
1161: BEGIN
1162: IF (PV_DEBUG_HIGH_ON) THEN
1163:
1164: PVX_UTILITY_PVT.debug_message('Inside check uk 1');
1165: END IF;
1166:
1167: x_return_status := FND_API.g_ret_sts_success;
1168:

Line 1173: l_valid_flag := PVX_UTIlity_PVT.check_uniqueness(

1169:
1170: IF p_validation_mode = JTF_PLSQL_API.g_create
1171: AND p_pec_rules_rec.enrl_change_rule_id IS NOT NULL
1172: THEN
1173: l_valid_flag := PVX_UTIlity_PVT.check_uniqueness(
1174: 'PV_PG_ENRL_CHANGE_RULES',
1175: ' enrl_change_rule_id = ''' || p_pec_rules_rec.enrl_change_rule_id ||''''
1176: );
1177: END IF;

Line 1183: PVX_UTILITY_PVT.debug_message('Inside check uk 2' || l_valid_flag);

1179: IF (PV_DEBUG_HIGH_ON) THEN
1180:
1181:
1182:
1183: PVX_UTILITY_PVT.debug_message('Inside check uk 2' || l_valid_flag);
1184:
1185: END IF;
1186:
1187: IF l_valid_flag = FND_API.g_false THEN

Line 1188: --PVX_UTIlity_PVT.Error_Message(p_message_name => 'PV_enrl_change_rule_id_DUPLICATE');

1184:
1185: END IF;
1186:
1187: IF l_valid_flag = FND_API.g_false THEN
1188: --PVX_UTIlity_PVT.Error_Message(p_message_name => 'PV_enrl_change_rule_id_DUPLICATE');
1189: x_return_status := FND_API.g_ret_sts_error;
1190: -- x_return_status := FND_API.g_ret_sts_success;
1191: END IF;
1192:

Line 1197: PVX_UTILITY_PVT.debug_message('Inside check uk 3' || l_valid_flag);

1193: IF (PV_DEBUG_HIGH_ON) THEN
1194:
1195:
1196:
1197: PVX_UTILITY_PVT.debug_message('Inside check uk 3' || l_valid_flag);
1198:
1199: END IF;
1200:
1201:

Line 1219: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENRL_CHANGE_RULE_ID' );

1215: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1216:
1217:
1218: IF p_pec_rules_rec.enrl_change_rule_id = FND_API.G_MISS_NUM OR p_pec_rules_rec.enrl_change_rule_id IS NULL THEN
1219: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENRL_CHANGE_RULE_ID' );
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', 'OBJECT_VERSION_NUMBER' );

1221: END IF;
1222:
1223:
1224: IF p_pec_rules_rec.object_version_number = FND_API.G_MISS_NUM OR p_pec_rules_rec.object_version_number IS NULL THEN
1225: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
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', 'CHANGE_FROM_PROGRAM_ID' );

1227: END IF;
1228:
1229:
1230: IF p_pec_rules_rec.change_from_program_id = FND_API.G_MISS_NUM OR p_pec_rules_rec.change_from_program_id IS NULL THEN
1231: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHANGE_FROM_PROGRAM_ID' );
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', 'CHANGE_TO_PROGRAM_ID' );

1233: END IF;
1234:
1235:
1236: IF p_pec_rules_rec.change_to_program_id = FND_API.G_MISS_NUM OR p_pec_rules_rec.change_to_program_id IS NULL THEN
1237: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHANGE_TO_PROGRAM_ID' );
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', 'CHANGE_DIRECTION_CODE' );

1239: END IF;
1240:
1241:
1242: IF p_pec_rules_rec.change_direction_code = FND_API.g_miss_char OR p_pec_rules_rec.change_direction_code IS NULL THEN
1243: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHANGE_DIRECTION_CODE' );
1244: x_return_status := FND_API.g_ret_sts_error;
1245: END IF;
1246:
1247:

Line 1249: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'EFFECTIVE_FROM_DATE' );

1245: END IF;
1246:
1247:
1248: IF p_pec_rules_rec.effective_from_date = FND_API.G_MISS_DATE OR p_pec_rules_rec.effective_from_date IS NULL THEN
1249: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'EFFECTIVE_FROM_DATE' );
1250: x_return_status := FND_API.g_ret_sts_error;
1251: END IF;
1252:
1253:

Line 1255: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ACTIVE_FLAG' );

1251: END IF;
1252:
1253:
1254: IF p_pec_rules_rec.active_flag = FND_API.g_miss_char OR p_pec_rules_rec.active_flag IS NULL THEN
1255: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ACTIVE_FLAG' );
1256: x_return_status := FND_API.g_ret_sts_error;
1257: END IF;
1258:
1259:

Line 1264: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENRL_CHANGE_RULE_ID' );

1260: ELSE
1261:
1262:
1263: IF p_pec_rules_rec.enrl_change_rule_id = FND_API.G_MISS_NUM THEN
1264: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ENRL_CHANGE_RULE_ID' );
1265: x_return_status := FND_API.g_ret_sts_error;
1266: END IF;
1267:
1268:

Line 1270: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );

1266: END IF;
1267:
1268:
1269: IF p_pec_rules_rec.object_version_number = FND_API.G_MISS_NUM THEN
1270: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_VERSION_NUMBER' );
1271: x_return_status := FND_API.g_ret_sts_error;
1272: END IF;
1273:
1274:

Line 1276: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHANGE_FROM_PROGRAM_ID' );

1272: END IF;
1273:
1274:
1275: IF p_pec_rules_rec.change_from_program_id = FND_API.G_MISS_NUM THEN
1276: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHANGE_FROM_PROGRAM_ID' );
1277: x_return_status := FND_API.g_ret_sts_error;
1278: END IF;
1279:
1280:

Line 1282: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHANGE_TO_PROGRAM_ID' );

1278: END IF;
1279:
1280:
1281: IF p_pec_rules_rec.change_to_program_id = FND_API.G_MISS_NUM THEN
1282: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHANGE_TO_PROGRAM_ID' );
1283: x_return_status := FND_API.g_ret_sts_error;
1284: END IF;
1285:
1286:

Line 1288: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHANGE_DIRECTION_CODE' );

1284: END IF;
1285:
1286:
1287: IF p_pec_rules_rec.change_direction_code = FND_API.g_miss_char THEN
1288: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CHANGE_DIRECTION_CODE' );
1289: x_return_status := FND_API.g_ret_sts_error;
1290: END IF;
1291:
1292:

Line 1294: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'EFFECTIVE_FROM_DATE' );

1290: END IF;
1291:
1292:
1293: IF p_pec_rules_rec.effective_from_date = FND_API.G_MISS_DATE THEN
1294: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'EFFECTIVE_FROM_DATE' );
1295: x_return_status := FND_API.g_ret_sts_error;
1296: END IF;
1297:
1298:

Line 1300: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ACTIVE_FLAG' );

1296: END IF;
1297:
1298:
1299: IF p_pec_rules_rec.active_flag = FND_API.g_miss_char THEN
1300: PVX_UTIlity_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'ACTIVE_FLAG' );
1301: x_return_status := FND_API.g_ret_sts_error;
1302: END IF;
1303: END IF;
1304:

Line 1350: PVX_UTILITY_PVT.debug_message('Start ' );

1346: IF (PV_DEBUG_HIGH_ON) THEN
1347:
1348:
1349:
1350: PVX_UTILITY_PVT.debug_message('Start ' );
1351:
1352: END IF;
1353:
1354: l_return_status := FND_API.g_ret_sts_success;

Line 1368: PVX_UTILITY_PVT.debug_message('Middle 1 ' );

1364:
1365: -- Check Items Required/NOT NULL API calls
1366: IF (PV_DEBUG_HIGH_ON) THEN
1367:
1368: PVX_UTILITY_PVT.debug_message('Middle 1 ' );
1369: END IF;
1370:
1371: check_pec_rules_req_items(
1372: p_pec_rules_rec => p_pec_rules_rec,

Line 1384: PVX_UTILITY_PVT.debug_message('Middle 2 ' );

1380: IF (PV_DEBUG_HIGH_ON) THEN
1381:
1382:
1383:
1384: PVX_UTILITY_PVT.debug_message('Middle 2 ' );
1385:
1386: END IF;
1387:
1388: check_pec_rules_FK_items(

Line 1400: PVX_UTILITY_PVT.debug_message('Middle 3 ' );

1396: IF (PV_DEBUG_HIGH_ON) THEN
1397:
1398:
1399:
1400: PVX_UTILITY_PVT.debug_message('Middle 3 ' );
1401:
1402: END IF;
1403:
1404: check_pec_rules_Lookup_items(

Line 1417: PVX_UTILITY_PVT.debug_message('Error status is ' || x_return_status);

1413: IF (PV_DEBUG_HIGH_ON) THEN
1414:
1415:
1416:
1417: PVX_UTILITY_PVT.debug_message('Error status is ' || x_return_status);
1418:
1419: END IF;
1420:
1421: END Check_pec_rules_Items;

Line 1558: PVX_UTILITY_PVT.debug_message('Inside Validate ');

1554: IF (PV_DEBUG_HIGH_ON) THEN
1555:
1556:
1557:
1558: PVX_UTILITY_PVT.debug_message('Inside Validate ');
1559:
1560: END IF;
1561:
1562: -- Standard Start of API savepoint

Line 1585: PVX_UTILITY_PVT.debug_message('Before JTF comparison ');

1581: IF (PV_DEBUG_HIGH_ON) THEN
1582:
1583:
1584:
1585: PVX_UTILITY_PVT.debug_message('Before JTF comparison ');
1586:
1587: END IF;
1588:
1589: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1607: PVX_UTILITY_PVT.debug_message('Before JTF comparison : 1');

1603: IF (PV_DEBUG_HIGH_ON) THEN
1604:
1605:
1606:
1607: PVX_UTILITY_PVT.debug_message('Before JTF comparison : 1');
1608:
1609: END IF;
1610:
1611: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 1623: PVX_UTILITY_PVT.debug_message('Before JTF comparison : 2');

1619:
1620:
1621:
1622:
1623: PVX_UTILITY_PVT.debug_message('Before JTF comparison : 2');
1624:
1625:
1626: END IF;
1627:

Line 1637: PVX_UTILITY_PVT.debug_message('Before JTF comparison : 3');

1633: IF (PV_DEBUG_HIGH_ON) THEN
1634:
1635:
1636:
1637: PVX_UTILITY_PVT.debug_message('Before JTF comparison : 3');
1638:
1639: END IF;
1640:
1641: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1661: PVX_UTILITY_PVT.debug_message('Before JTF comparison : 4');

1657: IF (PV_DEBUG_HIGH_ON) THEN
1658:
1659:
1660:
1661: PVX_UTILITY_PVT.debug_message('Before JTF comparison : 4');
1662:
1663: END IF;
1664:
1665: IF (PV_DEBUG_HIGH_ON) THEN

Line 1669: PVX_UTILITY_PVT.debug_message('After jtf comparison ');

1665: IF (PV_DEBUG_HIGH_ON) THEN
1666:
1667:
1668:
1669: PVX_UTILITY_PVT.debug_message('After jtf comparison ');
1670:
1671: END IF;
1672: -- Debug Message
1673: IF (PV_DEBUG_HIGH_ON) THEN

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

1671: END IF;
1672: -- Debug Message
1673: IF (PV_DEBUG_HIGH_ON) THEN
1674:
1675: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1676: END IF;
1677:
1678:
1679:

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

1683:
1684: -- Debug Message
1685: IF (PV_DEBUG_HIGH_ON) THEN
1686:
1687: PVX_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1688: END IF;
1689:
1690:
1691: -- Standard call to get message count and if count is 1, get message info.

Line 1698: WHEN PVX_UTIlity_PVT.resource_locked THEN

1694: p_data => x_msg_data
1695: );
1696: EXCEPTION
1697:
1698: WHEN PVX_UTIlity_PVT.resource_locked THEN
1699: x_return_status := FND_API.g_ret_sts_error;
1700: PVX_UTIlity_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1701:
1702: WHEN FND_API.G_EXC_ERROR THEN

Line 1700: PVX_UTIlity_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');

1696: EXCEPTION
1697:
1698: WHEN PVX_UTIlity_PVT.resource_locked THEN
1699: x_return_status := FND_API.g_ret_sts_error;
1700: PVX_UTIlity_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
1701:
1702: WHEN FND_API.G_EXC_ERROR THEN
1703: ROLLBACK TO VALIDATE_Pec_Rules_;
1704: x_return_status := FND_API.G_RET_STS_ERROR;

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

1763:
1764: -- Debug Message
1765: IF (PV_DEBUG_HIGH_ON) THEN
1766:
1767: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1768: END IF;
1769: -- Standard call to get message count and if count is 1, get message info.
1770: FND_MSG_PUB.Count_And_Get
1771: (p_count => x_msg_count,