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.AMS_SCORERESULT_PVT dependencies on AMS_UTILITY_PVT

Line 152: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

148:
149: -- Debug Message
150: IF (AMS_DEBUG_HIGH_ON) THEN
151:
152: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
153: END IF;
154:
155:
156: -- Initialize API return status to SUCCESS

Line 184: AMS_UTILITY_PVT.debug_message('Private API: Validate_Scoreresult');

180: THEN
181: -- Debug message
182: IF (AMS_DEBUG_HIGH_ON) THEN
183:
184: AMS_UTILITY_PVT.debug_message('Private API: Validate_Scoreresult');
185: END IF;
186:
187: -- Invoke validation procedures
188: Validate_scoreresult(

Line 205: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

201:
202: -- Debug Message
203: IF (AMS_DEBUG_HIGH_ON) THEN
204:
205: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
206: END IF;
207:
208: -- Invoke table handler(AMS_DM_SCORE_RESULTS_PKG.Insert_Row)
209: AMS_DM_SCORE_RESULTS_PKG.Insert_Row(

Line 243: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

239:
240: -- Debug Message
241: IF (AMS_DEBUG_HIGH_ON) THEN
242:
243: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
244: END IF;
245:
246: -- Standard call to get message count and if count is 1, get message info.
247: FND_MSG_PUB.Count_And_Get

Line 253: WHEN AMS_Utility_PVT.resource_locked THEN

249: p_data => x_msg_data
250: );
251: EXCEPTION
252:
253: WHEN AMS_Utility_PVT.resource_locked THEN
254: x_return_status := FND_API.g_ret_sts_error;
255: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
256:
257: WHEN FND_API.G_EXC_ERROR THEN

Line 255: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

251: EXCEPTION
252:
253: WHEN AMS_Utility_PVT.resource_locked THEN
254: x_return_status := FND_API.g_ret_sts_error;
255: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
256:
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO CREATE_Scoreresult_PVT;
259: x_return_status := FND_API.G_RET_STS_ERROR;

Line 341: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

337:
338: -- Debug Message
339: IF (AMS_DEBUG_HIGH_ON) THEN
340:
341: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
342: END IF;
343:
344:
345: -- Initialize API return status to SUCCESS

Line 351: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

347:
348: -- Debug Message
349: IF (AMS_DEBUG_HIGH_ON) THEN
350:
351: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
352: END IF;
353:
354: OPEN c_get_Scoreresult( l_tar_scoreresult_rec.score_result_id);
355:

Line 359: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

355:
356: FETCH c_get_Scoreresult INTO l_ref_scoreresult_rec ;
357:
358: IF ( c_get_Scoreresult%NOTFOUND) THEN
359: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
360: p_token_name => 'INFO',
361: p_token_value => 'Scoreresult') ;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;

Line 367: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');

363: END IF;
364: -- Debug Message
365: IF (AMS_DEBUG_HIGH_ON) THEN
366:
367: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
368: END IF;
369: CLOSE c_get_Scoreresult;
370:
371: -- Check Whether record has been changed by someone else

Line 373: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

369: CLOSE c_get_Scoreresult;
370:
371: -- Check Whether record has been changed by someone else
372: IF (l_tar_scoreresult_rec.object_version_number <> l_ref_scoreresult_rec.object_version_number) THEN
373: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
374: p_token_name => 'INFO',
375: p_token_value => 'Scoreresult') ;
376: RAISE FND_API.G_EXC_ERROR;
377: End if;

Line 382: AMS_UTILITY_PVT.debug_message('Private API: Validate_Scoreresult');

378: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
379: -- Debug message
380: IF (AMS_DEBUG_HIGH_ON) THEN
381:
382: AMS_UTILITY_PVT.debug_message('Private API: Validate_Scoreresult');
383: END IF;
384:
385: -- Invoke validation procedures
386: Validate_scoreresult(

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

399:
400: -- Debug Message
401: IF (AMS_DEBUG_HIGH_ON) THEN
402:
403: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
404: END IF;
405:
406: -- Invoke table handler(AMS_DM_SCORE_RESULTS_PKG.Update_Row)
407: AMS_DM_SCORE_RESULTS_PKG.Update_Row(

Line 435: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

431:
432: -- Debug Message
433: IF (AMS_DEBUG_HIGH_ON) THEN
434:
435: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
436: END IF;
437:
438: -- Standard call to get message count and if count is 1, get message info.
439: FND_MSG_PUB.Count_And_Get

Line 445: WHEN AMS_Utility_PVT.resource_locked THEN

441: p_data => x_msg_data
442: );
443: EXCEPTION
444:
445: WHEN AMS_Utility_PVT.resource_locked THEN
446: x_return_status := FND_API.g_ret_sts_error;
447: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
448:
449: WHEN FND_API.G_EXC_ERROR THEN

Line 447: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

443: EXCEPTION
444:
445: WHEN AMS_Utility_PVT.resource_locked THEN
446: x_return_status := FND_API.g_ret_sts_error;
447: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
448:
449: WHEN FND_API.G_EXC_ERROR THEN
450: ROLLBACK TO UPDATE_Scoreresult_PVT;
451: x_return_status := FND_API.G_RET_STS_ERROR;

Line 521: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

517:
518: -- Debug Message
519: IF (AMS_DEBUG_HIGH_ON) THEN
520:
521: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
522: END IF;
523:
524:
525: -- Initialize API return status to SUCCESS

Line 534: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

530: --
531: -- Debug Message
532: IF (AMS_DEBUG_HIGH_ON) THEN
533:
534: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
535: END IF;
536:
537: -- Invoke table handler(AMS_DM_SCORE_RESULTS_PKG.Delete_Row)
538: AMS_DM_SCORE_RESULTS_PKG.Delete_Row(

Line 554: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

550:
551: -- Debug Message
552: IF (AMS_DEBUG_HIGH_ON) THEN
553:
554: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
555: END IF;
556:
557: -- Standard call to get message count and if count is 1, get message info.
558: FND_MSG_PUB.Count_And_Get

Line 564: WHEN AMS_Utility_PVT.resource_locked THEN

560: p_data => x_msg_data
561: );
562: EXCEPTION
563:
564: WHEN AMS_Utility_PVT.resource_locked THEN
565: x_return_status := FND_API.g_ret_sts_error;
566: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
567:
568: WHEN FND_API.G_EXC_ERROR THEN

Line 566: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

562: EXCEPTION
563:
564: WHEN AMS_Utility_PVT.resource_locked THEN
565: x_return_status := FND_API.g_ret_sts_error;
566: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
567:
568: WHEN FND_API.G_EXC_ERROR THEN
569: ROLLBACK TO DELETE_Scoreresult_PVT;
570: x_return_status := FND_API.G_RET_STS_ERROR;

Line 635: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

631:
632: -- Debug Message
633: IF (AMS_DEBUG_HIGH_ON) THEN
634:
635: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
636: END IF;
637:
638: -- Initialize message list if p_init_msg_list is set to TRUE.
639: IF FND_API.to_Boolean( p_init_msg_list )

Line 664: AMS_Utility_PVT.debug_message(l_full_name||': start');

660: IF (AMS_DEBUG_HIGH_ON) THEN
661:
662:
663:
664: AMS_Utility_PVT.debug_message(l_full_name||': start');
665:
666: END IF;
667: OPEN c_Scoreresult;
668:

Line 689: AMS_Utility_PVT.debug_message(l_full_name ||': end');

685: p_count => x_msg_count,
686: p_data => x_msg_data);
687: IF (AMS_DEBUG_HIGH_ON) THEN
688:
689: AMS_Utility_PVT.debug_message(l_full_name ||': end');
690: END IF;
691: EXCEPTION
692:
693: WHEN AMS_Utility_PVT.resource_locked THEN

Line 693: WHEN AMS_Utility_PVT.resource_locked THEN

689: AMS_Utility_PVT.debug_message(l_full_name ||': end');
690: END IF;
691: EXCEPTION
692:
693: WHEN AMS_Utility_PVT.resource_locked THEN
694: x_return_status := FND_API.g_ret_sts_error;
695: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
696:
697: WHEN FND_API.G_EXC_ERROR THEN

Line 695: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

691: EXCEPTION
692:
693: WHEN AMS_Utility_PVT.resource_locked THEN
694: x_return_status := FND_API.g_ret_sts_error;
695: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
696:
697: WHEN FND_API.G_EXC_ERROR THEN
698: ROLLBACK TO LOCK_Scoreresult_PVT;
699: x_return_status := FND_API.G_RET_STS_ERROR;

Line 743: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

739:
740: BEGIN
741: x_return_status := FND_API.g_ret_sts_success;
742: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
743: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
744: 'AMS_DM_SCORE_RESULTS',
745: 'SCORE_RESULT_ID = ''' || p_scoreresult_rec.SCORE_RESULT_ID ||''''
746: );
747: ELSE

Line 748: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

744: 'AMS_DM_SCORE_RESULTS',
745: 'SCORE_RESULT_ID = ''' || p_scoreresult_rec.SCORE_RESULT_ID ||''''
746: );
747: ELSE
748: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
749: 'AMS_DM_SCORE_RESULTS',
750: 'SCORE_RESULT_ID = ''' || p_scoreresult_rec.SCORE_RESULT_ID ||
751: ''' AND SCORE_RESULT_ID <> ' || p_scoreresult_rec.SCORE_RESULT_ID
752: );

Line 756: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','SCORE_RESULT_ID');

752: );
753: END IF;
754:
755: IF l_valid_flag = FND_API.g_false THEN
756: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','SCORE_RESULT_ID');
757: x_return_status := FND_API.g_ret_sts_error;
758: END IF;
759:
760: END check_scoreresult_uk_items;

Line 773: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_SCORE_ID');

769: x_return_status := FND_API.g_ret_sts_success;
770:
771: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
772: IF p_scoreresult_rec.score_id = FND_API.g_miss_num OR p_scoreresult_rec.score_id IS NULL THEN
773: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_SCORE_ID');
774: x_return_status := FND_API.g_ret_sts_error;
775: END IF;
776:
777:

Line 779: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_DECILE');

775: END IF;
776:
777:
778: IF p_scoreresult_rec.decile = FND_API.g_miss_char OR p_scoreresult_rec.decile IS NULL THEN
779: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_DECILE');
780: x_return_status := FND_API.g_ret_sts_error;
781: END IF;
782:
783:

Line 785: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_NUM_RECORDS');

781: END IF;
782:
783:
784: IF p_scoreresult_rec.num_records = FND_API.g_miss_num OR p_scoreresult_rec.num_records IS NULL THEN
785: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_NUM_RECORDS');
786: x_return_status := FND_API.g_ret_sts_error;
787: END IF;
788:
789:

Line 791: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_SCORE');

787: END IF;
788:
789:
790: IF p_scoreresult_rec.score = FND_API.g_miss_char OR p_scoreresult_rec.score IS NULL THEN
791: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_SCORE');
792: x_return_status := FND_API.g_ret_sts_error;
793: END IF;
794:
795:

Line 797: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_CONFIDENCE');

793: END IF;
794:
795:
796: IF p_scoreresult_rec.confidence = FND_API.g_miss_num OR p_scoreresult_rec.confidence IS NULL THEN
797: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_CONFIDENCE');
798: x_return_status := FND_API.g_ret_sts_error;
799: END IF;
800: ELSE -- update mode
801: IF p_scoreresult_rec.score_result_id IS NULL THEN

Line 802: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_ID');

798: x_return_status := FND_API.g_ret_sts_error;
799: END IF;
800: ELSE -- update mode
801: IF p_scoreresult_rec.score_result_id IS NULL THEN
802: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_ID');
803: x_return_status := FND_API.g_ret_sts_error;
804: END IF;
805:
806:

Line 808: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_score_id');

804: END IF;
805:
806:
807: IF p_scoreresult_rec.score_id IS NULL THEN
808: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_score_id');
809: x_return_status := FND_API.g_ret_sts_error;
810: END IF;
811:
812:

Line 814: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_DECILE');

810: END IF;
811:
812:
813: IF p_scoreresult_rec.decile IS NULL THEN
814: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_DECILE');
815: x_return_status := FND_API.g_ret_sts_error;
816: END IF;
817:
818:

Line 820: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_NUM_RECORDS');

816: END IF;
817:
818:
819: IF p_scoreresult_rec.num_records IS NULL THEN
820: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_NUM_RECORDS');
821: x_return_status := FND_API.g_ret_sts_error;
822: END IF;
823:
824:

Line 826: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_SCORE');

822: END IF;
823:
824:
825: IF p_scoreresult_rec.score IS NULL THEN
826: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_SCORE');
827: x_return_status := FND_API.g_ret_sts_error;
828: END IF;
829:
830:

Line 832: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_CONFIDENCE');

828: END IF;
829:
830:
831: IF p_scoreresult_rec.confidence IS NULL THEN
832: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_CONFIDENCE');
833: x_return_status := FND_API.g_ret_sts_error;
834: END IF;
835: END IF;
836:

Line 848: IF AMS_Utility_PVT.check_fk_exists (

844: BEGIN
845: x_return_status := FND_API.g_ret_sts_success;
846:
847: IF p_scoreresult_rec.score_id <> FND_API.g_miss_num THEN
848: IF AMS_Utility_PVT.check_fk_exists (
849: 'ams_dm_scores_all_b',
850: 'score_id',
851: p_scoreresult_rec.score_id
852: ) = FND_API.g_false THEN

Line 853: AMS_Utility_PVT.error_message ('AMS_SCORRES_BAD_SCORE_ID');

849: 'ams_dm_scores_all_b',
850: 'score_id',
851: p_scoreresult_rec.score_id
852: ) = FND_API.g_false THEN
853: AMS_Utility_PVT.error_message ('AMS_SCORRES_BAD_SCORE_ID');
854: x_return_status := FND_API.g_ret_sts_error;
855: END IF;
856: END IF;
857:

Line 1004: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1000:
1001: -- Debug Message
1002: IF (AMS_DEBUG_HIGH_ON) THEN
1003:
1004: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1005: END IF;
1006:
1007:
1008: -- Initialize API return status to SUCCESS

Line 1014: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1010:
1011:
1012: -- Debug Message
1013: IF (AMS_DEBUG_HIGH_ON) THEN
1014: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1015: END IF;
1016:
1017: -- Standard call to get message count and if count is 1, get message info.
1018: FND_MSG_PUB.Count_And_Get

Line 1024: WHEN AMS_Utility_PVT.resource_locked THEN

1020: p_data => x_msg_data
1021: );
1022: EXCEPTION
1023:
1024: WHEN AMS_Utility_PVT.resource_locked THEN
1025: x_return_status := FND_API.g_ret_sts_error;
1026: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1027:
1028: WHEN FND_API.G_EXC_ERROR THEN

Line 1026: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1022: EXCEPTION
1023:
1024: WHEN AMS_Utility_PVT.resource_locked THEN
1025: x_return_status := FND_API.g_ret_sts_error;
1026: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1027:
1028: WHEN FND_API.G_EXC_ERROR THEN
1029: ROLLBACK TO VALIDATE_Scoreresult_;
1030: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1091: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1087:
1088: -- Debug Message
1089: IF (AMS_DEBUG_HIGH_ON) THEN
1090:
1091: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1092: END IF;
1093: -- Standard call to get message count and if count is 1, get message info.
1094: FND_MSG_PUB.Count_And_Get
1095: (p_count => x_msg_count,

Line 1155: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

1151: SAVEPOINT insert_percentile_results;
1152:
1153: -- Debug Message
1154: IF (AMS_DEBUG_HIGH_ON) THEN
1155: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1156: END IF;
1157:
1158: -- clear results from any previous execution
1159: DELETE FROM ams_dm_score_pct_results

Line 1170: AMS_UTILITY_PVT.debug_message('No score results found in AMS_DM_SOURCE. Exiting.' );

1166:
1167: -- If there are no records return
1168: IF l_total_records <= 0 THEN
1169: IF (AMS_DEBUG_HIGH_ON) THEN
1170: AMS_UTILITY_PVT.debug_message('No score results found in AMS_DM_SOURCE. Exiting.' );
1171: END IF;
1172: RETURN;
1173: END IF;
1174:

Line 1189: AMS_UTILITY_PVT.debug_message('Number of Parties in Scored Population : ' || l_total_records );

1185: END IF;
1186:
1187: -- Debug Message
1188: IF (AMS_DEBUG_HIGH_ON) THEN
1189: AMS_UTILITY_PVT.debug_message('Number of Parties in Scored Population : ' || l_total_records );
1190: AMS_UTILITY_PVT.debug_message('Number of Parties per Percentile : ' || l_records_per_pct );
1191: AMS_UTILITY_PVT.debug_message('Percentile Multiplier: ' || l_percentile_multiplier );
1192: END IF;
1193:

Line 1190: AMS_UTILITY_PVT.debug_message('Number of Parties per Percentile : ' || l_records_per_pct );

1186:
1187: -- Debug Message
1188: IF (AMS_DEBUG_HIGH_ON) THEN
1189: AMS_UTILITY_PVT.debug_message('Number of Parties in Scored Population : ' || l_total_records );
1190: AMS_UTILITY_PVT.debug_message('Number of Parties per Percentile : ' || l_records_per_pct );
1191: AMS_UTILITY_PVT.debug_message('Percentile Multiplier: ' || l_percentile_multiplier );
1192: END IF;
1193:
1194:

Line 1191: AMS_UTILITY_PVT.debug_message('Percentile Multiplier: ' || l_percentile_multiplier );

1187: -- Debug Message
1188: IF (AMS_DEBUG_HIGH_ON) THEN
1189: AMS_UTILITY_PVT.debug_message('Number of Parties in Scored Population : ' || l_total_records );
1190: AMS_UTILITY_PVT.debug_message('Number of Parties per Percentile : ' || l_records_per_pct );
1191: AMS_UTILITY_PVT.debug_message('Percentile Multiplier: ' || l_percentile_multiplier );
1192: END IF;
1193:
1194:
1195: --FOR l_result_rec IN c_results (l_score_id) LOOP

Line 1320: AMS_UTILITY_PVT.debug_message('Inserted: ' || l_total_records || ' Records');

1316:
1317:
1318: -- Debug Message
1319: IF (AMS_DEBUG_HIGH_ON) THEN
1320: AMS_UTILITY_PVT.debug_message('Inserted: ' || l_total_records || ' Records');
1321: END IF;
1322:
1323: -- If some records were inserted, then insert a record for the zero percentile
1324: -- to start the graph from the origin

Line 1397: AMS_UTILITY_PVT.debug_message('Inserted record for zeroth percentile: ');

1393: l_avg_conf_list.delete;
1394: l_avg_conf_cum_list.delete;
1395: l_ctr_2 := 0;
1396: IF (AMS_DEBUG_HIGH_ON) THEN
1397: AMS_UTILITY_PVT.debug_message('Inserted record for zeroth percentile: ');
1398: AMS_UTILITY_PVT.debug_message('Cumulative Average Confidence for 100th percentile: ' || l_avg_confidence_cum );
1399: END IF;
1400:
1401: UPDATE ams_dm_score_pct_results

Line 1398: AMS_UTILITY_PVT.debug_message('Cumulative Average Confidence for 100th percentile: ' || l_avg_confidence_cum );

1394: l_avg_conf_cum_list.delete;
1395: l_ctr_2 := 0;
1396: IF (AMS_DEBUG_HIGH_ON) THEN
1397: AMS_UTILITY_PVT.debug_message('Inserted record for zeroth percentile: ');
1398: AMS_UTILITY_PVT.debug_message('Cumulative Average Confidence for 100th percentile: ' || l_avg_confidence_cum );
1399: END IF;
1400:
1401: UPDATE ams_dm_score_pct_results
1402: SET RANDOM_RESULT = l_avg_confidence_cum

Line 1409: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');

1405: END IF;
1406:
1407: -- Debug Message
1408: IF (AMS_DEBUG_HIGH_ON) THEN
1409: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1410: END IF;
1411:
1412: EXCEPTION
1413: WHEN FND_API.G_EXC_ERROR THEN

Line 1415: AMS_UTILITY_PVT.debug_message(l_api_name || ': Error ');

1411:
1412: EXCEPTION
1413: WHEN FND_API.G_EXC_ERROR THEN
1414: ROLLBACK TO insert_percentile_results;
1415: AMS_UTILITY_PVT.debug_message(l_api_name || ': Error ');
1416: RAISE FND_API.G_EXC_ERROR;
1417:
1418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1419: ROLLBACK TO insert_percentile_results;

Line 1420: AMS_UTILITY_PVT.debug_message(l_api_name || ': Error ');

1416: RAISE FND_API.G_EXC_ERROR;
1417:
1418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1419: ROLLBACK TO insert_percentile_results;
1420: AMS_UTILITY_PVT.debug_message(l_api_name || ': Error ');
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422:
1423: WHEN OTHERS THEN
1424: ROLLBACK TO insert_percentile_results;

Line 1425: AMS_UTILITY_PVT.debug_message(l_api_name || ': Error ');

1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422:
1423: WHEN OTHERS THEN
1424: ROLLBACK TO insert_percentile_results;
1425: AMS_UTILITY_PVT.debug_message(l_api_name || ': Error ');
1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1427:
1428: END insert_percentile_results;
1429:

Line 1485: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');

1481: END IF;
1482:
1483: -- Debug Message
1484: IF (AMS_DEBUG_HIGH_ON) THEN
1485: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1486: END IF;
1487:
1488:
1489: -- Initialize API return status to SUCCESS

Line 1530: AMS_UTILITY_PVT.debug_message('Inserted Decile Records ');

1526: END LOOP;
1527:
1528: -- Debug Message
1529: IF (AMS_DEBUG_HIGH_ON) THEN
1530: AMS_UTILITY_PVT.debug_message('Inserted Decile Records ');
1531: END IF;
1532:
1533: --kbasavar 12/30/2003 Modified to Call insert_percentile_results only for models enabled for optimal targeting
1534: OPEN c_model_type(p_score_id);

Line 1555: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');

1551: END IF;
1552:
1553: -- Debug Message
1554: IF (AMS_DEBUG_HIGH_ON) THEN
1555: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1556: END IF;
1557:
1558: EXCEPTION
1559: WHEN FND_API.G_EXC_ERROR THEN

Line 1674: AMS_UTILITY_PVT.debug_message('Private API: generate_list start');

1670: BEGIN
1671: Fnd_Msg_Pub.initialize;
1672:
1673: IF (AMS_DEBUG_HIGH_ON) THEN
1674: AMS_UTILITY_PVT.debug_message('Private API: generate_list start');
1675: END IF;
1676:
1677: OPEN c_ListSourceTypeCode;
1678: FETCH c_ListSourceTypeCode INTO l_master_type, l_primary_key, l_target_id;

Line 1706: AMS_Utility_PVT.debug_message ('B2B');

1702: CLOSE c_model_type;
1703:
1704: IF (AMS_DEBUG_HIGH_ON) THEN
1705: IF l_is_b2b then
1706: AMS_Utility_PVT.debug_message ('B2B');
1707: else
1708: AMS_Utility_PVT.debug_message ('B2C');
1709: end if;
1710: AMS_Utility_PVT.debug_message ('Model Type: ' || l_model_type);

Line 1708: AMS_Utility_PVT.debug_message ('B2C');

1704: IF (AMS_DEBUG_HIGH_ON) THEN
1705: IF l_is_b2b then
1706: AMS_Utility_PVT.debug_message ('B2B');
1707: else
1708: AMS_Utility_PVT.debug_message ('B2C');
1709: end if;
1710: AMS_Utility_PVT.debug_message ('Model Type: ' || l_model_type);
1711: END IF;
1712:

Line 1710: AMS_Utility_PVT.debug_message ('Model Type: ' || l_model_type);

1706: AMS_Utility_PVT.debug_message ('B2B');
1707: else
1708: AMS_Utility_PVT.debug_message ('B2C');
1709: end if;
1710: AMS_Utility_PVT.debug_message ('Model Type: ' || l_model_type);
1711: END IF;
1712:
1713: -- start change rosharma 20-jan-2004 bug # 3380057
1714: -- IF l_is_b2b AND l_model_type = 'CUSTOMER_PROFITABILITY' THEN

Line 1747: AMS_Utility_PVT.debug_message ('generate_list SQL = ' || l_sql_str);

1743: l_sql_str := l_sql_str || ' AND decile IN (' || p_tree_node_str || ')';
1744: END IF;
1745:
1746: IF (AMS_DEBUG_HIGH_ON) THEN
1747: AMS_Utility_PVT.debug_message ('generate_list SQL = ' || l_sql_str);
1748: END IF;
1749:
1750: --
1751: -- choang - 03-apr-2003

Line 1783: AMS_Utility_PVT.debug_message ('SCORE LISTS SQL = ' || l_insertSql);

1779: l_insertSql := l_insertSql || ' VALUES(AMS_DM_SCORE_LISTS_S.NEXTVAL, SYSDATE, :1, SYSDATE, :2 ' ;
1780: l_insertSql := l_insertSql || ', :3 , 1, :4, :5)';
1781:
1782: IF (AMS_DEBUG_HIGH_ON) THEN
1783: AMS_Utility_PVT.debug_message ('SCORE LISTS SQL = ' || l_insertSql);
1784: END IF;
1785:
1786: EXECUTE Immediate l_insertSql USING FND_GLOBAL.USER_ID,FND_GLOBAL.USER_ID,FND_GLOBAL.CONC_LOGIN_ID,p_score_id, x_list_header_id ;
1787: