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_DMPERFORMANCE_PVT dependencies on AMS_UTILITY_PVT

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

83:
84: -- Debug Message
85: IF (AMS_DEBUG_HIGH_ON) THEN
86:
87: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
88: END IF;
89:
90:
91: -- Initialize API return status to SUCCESS

Line 119: AMS_UTILITY_PVT.debug_message('Private API: Validate_Performance');

115: THEN
116: -- Debug message
117: IF (AMS_DEBUG_HIGH_ON) THEN
118:
119: AMS_UTILITY_PVT.debug_message('Private API: Validate_Performance');
120: END IF;
121:
122: -- Invoke validation procedures
123: Validate_Performance(

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

138:
139: -- Debug Message
140: IF (AMS_DEBUG_HIGH_ON) THEN
141:
142: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
143: END IF;
144:
145: -- Invoke table handler(AMS_DM_PERFORMANCE_PKG.Insert_Row)
146: AMS_DM_PERFORMANCE_PKG.Insert_Row(

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

174:
175: -- Debug Message
176: IF (AMS_DEBUG_HIGH_ON) THEN
177:
178: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
179: END IF;
180:
181: -- Standard call to get message count and if count is 1, get message info.
182: FND_MSG_PUB.Count_And_Get

Line 188: WHEN AMS_Utility_PVT.resource_locked THEN

184: p_data => x_msg_data
185: );
186: EXCEPTION
187:
188: WHEN AMS_Utility_PVT.resource_locked THEN
189: x_return_status := FND_API.g_ret_sts_error;
190: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
191: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
192: FND_MSG_PUB.add;

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

276:
277: -- Debug Message
278: IF (AMS_DEBUG_HIGH_ON) THEN
279:
280: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
281: END IF;
282:
283:
284: -- Initialize API return status to SUCCESS

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

286:
287: -- Debug Message
288: IF (AMS_DEBUG_HIGH_ON) THEN
289:
290: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
291: END IF;
292:
293: OPEN c_get_Dmperformance( l_tar_performance_rec.performance_id);
294:

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

305: END IF;
306: -- Debug Message
307: IF (AMS_DEBUG_HIGH_ON) THEN
308:
309: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
310: END IF;
311: CLOSE c_get_Dmperformance;
312:
313: -- Check Whether record has been changed by someone else

Line 328: AMS_UTILITY_PVT.debug_message('Private API: Validate_Performance');

324: THEN
325: -- Debug message
326: IF (AMS_DEBUG_HIGH_ON) THEN
327:
328: AMS_UTILITY_PVT.debug_message('Private API: Validate_Performance');
329: END IF;
330:
331: -- Invoke validation procedures
332: Validate_Performance(

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

347:
348: -- Debug Message
349: IF (AMS_DEBUG_HIGH_ON) THEN
350:
351: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
352: END IF;
353:
354: -- Invoke table handler(AMS_DM_PERFORMANCE_PKG.Update_Row)
355: AMS_DM_PERFORMANCE_PKG.Update_Row(

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

380:
381: -- Debug Message
382: IF (AMS_DEBUG_HIGH_ON) THEN
383:
384: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
385: END IF;
386:
387: -- Standard call to get message count and if count is 1, get message info.
388: FND_MSG_PUB.Count_And_Get

Line 394: WHEN AMS_Utility_PVT.resource_locked THEN

390: p_data => x_msg_data
391: );
392: EXCEPTION
393:
394: WHEN AMS_Utility_PVT.resource_locked THEN
395: x_return_status := FND_API.g_ret_sts_error;
396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
397: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
398: FND_MSG_PUB.add;

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

472:
473: -- Debug Message
474: IF (AMS_DEBUG_HIGH_ON) THEN
475:
476: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
477: END IF;
478:
479:
480: -- Initialize API return status to SUCCESS

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

485: --
486: -- Debug Message
487: IF (AMS_DEBUG_HIGH_ON) THEN
488:
489: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
490: END IF;
491:
492: -- Invoke table handler(AMS_DM_PERFORMANCE_PKG.Delete_Row)
493: AMS_DM_PERFORMANCE_PKG.Delete_Row(

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

505:
506: -- Debug Message
507: IF (AMS_DEBUG_HIGH_ON) THEN
508:
509: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
510: END IF;
511:
512: -- Standard call to get message count and if count is 1, get message info.
513: FND_MSG_PUB.Count_And_Get

Line 519: WHEN AMS_Utility_PVT.resource_locked THEN

515: p_data => x_msg_data
516: );
517: EXCEPTION
518:
519: WHEN AMS_Utility_PVT.resource_locked THEN
520: x_return_status := FND_API.g_ret_sts_error;
521: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
522: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
523: FND_MSG_PUB.add;

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

590:
591: -- Debug Message
592: IF (AMS_DEBUG_HIGH_ON) THEN
593:
594: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
595: END IF;
596:
597: -- Initialize message list if p_init_msg_list is set to TRUE.
598: IF FND_API.to_Boolean( p_init_msg_list )

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

619: IF (AMS_DEBUG_HIGH_ON) THEN
620:
621:
622:
623: AMS_Utility_PVT.debug_message(l_full_name||': start');
624:
625: END IF;
626: OPEN c_Dmperformance;
627:

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

644: p_count => x_msg_count,
645: p_data => x_msg_data);
646: IF (AMS_DEBUG_HIGH_ON) THEN
647:
648: AMS_Utility_PVT.debug_message(l_full_name ||': end');
649: END IF;
650: EXCEPTION
651:
652: WHEN AMS_Utility_PVT.resource_locked THEN

Line 652: WHEN AMS_Utility_PVT.resource_locked THEN

648: AMS_Utility_PVT.debug_message(l_full_name ||': end');
649: END IF;
650: EXCEPTION
651:
652: WHEN AMS_Utility_PVT.resource_locked THEN
653: x_return_status := FND_API.g_ret_sts_error;
654: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
655: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
656: FND_MSG_PUB.add;

Line 705: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

701:
702: BEGIN
703: x_return_status := FND_API.g_ret_sts_success;
704: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
705: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
706: 'AMS_DM_PERFORMANCE',
707: 'PERFORMANCE_ID = ''' || p_performance_rec.PERFORMANCE_ID ||''''
708: );
709: ELSE

Line 710: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

706: 'AMS_DM_PERFORMANCE',
707: 'PERFORMANCE_ID = ''' || p_performance_rec.PERFORMANCE_ID ||''''
708: );
709: ELSE
710: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
711: 'AMS_DM_PERFORMANCE',
712: 'PERFORMANCE_ID = ''' || p_performance_rec.PERFORMANCE_ID ||
713: ''' AND PERFORMANCE_ID <> ' || p_performance_rec.PERFORMANCE_ID
714: );

Line 740: AMS_Utility_PVT.error_message ('AMS_PERF_NO_MODEL_ID');

736: x_return_status := FND_API.g_ret_sts_success;
737:
738: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
739: IF p_performance_rec.MODEL_ID = FND_API.g_miss_num OR p_performance_rec.MODEL_ID IS NULL THEN
740: AMS_Utility_PVT.error_message ('AMS_PERF_NO_MODEL_ID');
741: x_return_status := FND_API.g_ret_sts_error;
742: END IF;
743:
744: -- predicated value

Line 746: AMS_Utility_PVT.error_message ('AMS_PERF_NO_PREDICTED_VALUE');

742: END IF;
743:
744: -- predicated value
745: IF p_performance_rec.predicted_value = FND_API.g_miss_num OR p_performance_rec.predicted_value IS NULL THEN
746: AMS_Utility_PVT.error_message ('AMS_PERF_NO_PREDICTED_VALUE');
747: x_return_status := FND_API.g_ret_sts_error;
748: END IF;
749:
750: -- actual value

Line 752: AMS_Utility_PVT.error_message ('AMS_PERF_NO_ACTUAL_VALUE');

748: END IF;
749:
750: -- actual value
751: IF p_performance_rec.actual_value = FND_API.g_miss_num OR p_performance_rec.actual_value IS NULL THEN
752: AMS_Utility_PVT.error_message ('AMS_PERF_NO_ACTUAL_VALUE');
753: x_return_status := FND_API.g_ret_sts_error;
754: END IF;
755:
756: -- evaluated records

Line 758: AMS_Utility_PVT.error_message ('AMS_PERF_NO_EVAL_RECORDS');

754: END IF;
755:
756: -- evaluated records
757: IF p_performance_rec.evaluated_records = FND_API.g_miss_num OR p_performance_rec.evaluated_records IS NULL THEN
758: AMS_Utility_PVT.error_message ('AMS_PERF_NO_EVAL_RECORDS');
759: x_return_status := FND_API.g_ret_sts_error;
760: END IF;
761:
762: -- total records

Line 764: AMS_Utility_PVT.error_message ('AMS_PERF_NO_TOTAL_RECORDS');

760: END IF;
761:
762: -- total records
763: IF p_performance_rec.total_records_predicted = FND_API.g_miss_num OR p_performance_rec.total_records_predicted IS NULL THEN
764: AMS_Utility_PVT.error_message ('AMS_PERF_NO_TOTAL_RECORDS');
765: x_return_status := FND_API.g_ret_sts_error;
766: END IF;
767: ELSE -- need ID when updating
768: IF p_performance_rec.performance_id = FND_API.g_miss_num OR p_performance_rec.performance_id IS NULL THEN

Line 769: AMS_Utility_PVT.error_message ('AMS_PERF_NO_PERF_ID');

765: x_return_status := FND_API.g_ret_sts_error;
766: END IF;
767: ELSE -- need ID when updating
768: IF p_performance_rec.performance_id = FND_API.g_miss_num OR p_performance_rec.performance_id IS NULL THEN
769: AMS_Utility_PVT.error_message ('AMS_PERF_NO_PERF_ID');
770: x_return_status := FND_API.g_ret_sts_error;
771: END IF;
772:
773: IF p_performance_rec.MODEL_ID IS NULL THEN

Line 774: AMS_Utility_PVT.error_message ('AMS_PERF_NO_MODEL_ID');

770: x_return_status := FND_API.g_ret_sts_error;
771: END IF;
772:
773: IF p_performance_rec.MODEL_ID IS NULL THEN
774: AMS_Utility_PVT.error_message ('AMS_PERF_NO_MODEL_ID');
775: x_return_status := FND_API.g_ret_sts_error;
776: END IF;
777:
778: -- predicated value

Line 780: AMS_Utility_PVT.error_message ('AMS_PERF_NO_PREDICTED_VALUE');

776: END IF;
777:
778: -- predicated value
779: IF p_performance_rec.predicted_value IS NULL THEN
780: AMS_Utility_PVT.error_message ('AMS_PERF_NO_PREDICTED_VALUE');
781: x_return_status := FND_API.g_ret_sts_error;
782: END IF;
783:
784: -- actual value

Line 786: AMS_Utility_PVT.error_message ('AMS_PERF_NO_ACTUAL_VALUE');

782: END IF;
783:
784: -- actual value
785: IF p_performance_rec.actual_value IS NULL THEN
786: AMS_Utility_PVT.error_message ('AMS_PERF_NO_ACTUAL_VALUE');
787: x_return_status := FND_API.g_ret_sts_error;
788: END IF;
789:
790: -- evaluated records

Line 792: AMS_Utility_PVT.error_message ('AMS_PERF_NO_EVAL_RECORDS');

788: END IF;
789:
790: -- evaluated records
791: IF p_performance_rec.evaluated_records IS NULL THEN
792: AMS_Utility_PVT.error_message ('AMS_PERF_NO_EVAL_RECORDS');
793: x_return_status := FND_API.g_ret_sts_error;
794: END IF;
795:
796: -- total records

Line 798: AMS_Utility_PVT.error_message ('AMS_PERF_NO_TOTAL_RECORDS');

794: END IF;
795:
796: -- total records
797: IF p_performance_rec.total_records_predicted IS NULL THEN
798: AMS_Utility_PVT.error_message ('AMS_PERF_NO_TOTAL_RECORDS');
799: x_return_status := FND_API.g_ret_sts_error;
800: END IF;
801: END IF;
802:

Line 814: IF AMS_Utility_PVT.check_fk_exists (

810: BEGIN
811: x_return_status := FND_API.g_ret_sts_success;
812:
813: IF p_performance_rec.model_id <> FND_API.g_miss_num THEN
814: IF AMS_Utility_PVT.check_fk_exists (
815: 'AMS_DM_MODELS_ALL_B',
816: 'MODEL_ID',
817: p_performance_rec.model_id
818: ) = FND_API.g_false THEN

Line 819: AMS_Utility_PVT.error_message ('AMS_DM_PERF_BAD_MODEL_ID');

815: 'AMS_DM_MODELS_ALL_B',
816: 'MODEL_ID',
817: p_performance_rec.model_id
818: ) = FND_API.g_false THEN
819: AMS_Utility_PVT.error_message ('AMS_DM_PERF_BAD_MODEL_ID');
820: x_return_status := FND_API.g_ret_sts_error;
821: END IF;
822: END IF;
823: END check_performance_FK_items;

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

966:
967: -- Debug Message
968: IF (AMS_DEBUG_HIGH_ON) THEN
969:
970: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
971: END IF;
972:
973:
974: -- Initialize API return status to SUCCESS

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

977:
978: -- Debug Message
979: IF (AMS_DEBUG_HIGH_ON) THEN
980:
981: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
982: END IF;
983:
984: -- Standard call to get message count and if count is 1, get message info.
985: FND_MSG_PUB.Count_And_Get

Line 991: WHEN AMS_Utility_PVT.resource_locked THEN

987: p_data => x_msg_data
988: );
989: EXCEPTION
990:
991: WHEN AMS_Utility_PVT.resource_locked THEN
992: x_return_status := FND_API.g_ret_sts_error;
993: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
994: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
995: FND_MSG_PUB.add;

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

1057:
1058: -- Debug Message
1059: IF (AMS_DEBUG_HIGH_ON) THEN
1060:
1061: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1062: END IF;
1063: -- Standard call to get message count and if count is 1, get message info.
1064: FND_MSG_PUB.Count_And_Get
1065: (p_count => x_msg_count,