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

Line 134: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');

130:
131: -- Debug Message
132: IF (AMS_DEBUG_HIGH_ON) THEN
133:
134: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');
135: END IF;
136:
137: --sunkumar 30/01/2003
138: --check if the template is a seeded one

Line 142: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED');

138: --check if the template is a seeded one
139: /* IF p_metric_formula_rec.metric_tpl_header_id < 10000 THEN
140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
141: THEN
142: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED');
143: END IF;
144:
145: RAISE FND_API.G_EXC_ERROR;
146: END IF; */

Line 171: Ams_Utility_Pvt.debug_message('Private API: New formula id='||l_metric_formula_id);

167: l_metric_formula_rec.METRIC_FORMULA_ID := l_METRIC_FORMULA_ID;
168: -- Debug message
169: IF (AMS_DEBUG_HIGH_ON) THEN
170:
171: Ams_Utility_Pvt.debug_message('Private API: New formula id='||l_metric_formula_id);
172: END IF;
173: END IF;
174:
175: -- =========================================================================

Line 181: Ams_Utility_Pvt.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

177: -- =========================================================================
178:
179: IF FND_GLOBAL.User_Id IS NULL
180: THEN
181: Ams_Utility_Pvt.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
182: RAISE FND_API.G_EXC_ERROR;
183: END IF;
184:
185: if l_metric_formula_rec.sequence is null then

Line 198: Ams_Utility_Pvt.debug_message('Private API: Validate_metric_formula');

194: THEN
195: -- Debug message
196: IF (AMS_DEBUG_HIGH_ON) THEN
197:
198: Ams_Utility_Pvt.debug_message('Private API: Validate_metric_formula');
199: END IF;
200:
201: -- Invoke validation procedures
202: Validate_metric_formula(

Line 220: Ams_Utility_Pvt.debug_message( 'Private API: Calling Ams_Metric_Formulas_Pkg.Insert_Row');

216:
217:
218: -- Debug Message
219: IF (AMS_DEBUG_HIGH_ON) THEN
220: Ams_Utility_Pvt.debug_message( 'Private API: Calling Ams_Metric_Formulas_Pkg.Insert_Row');
221: END IF;
222:
223: -- Invoke table handler(AMS_MET_TPL_DETAILS_PKG.Insert_Row)
224: Ams_Metric_Formulas_Pkg.Insert_Row(

Line 246: Ams_Utility_Pvt.debug_message( 'Private API: return_status='||x_return_status||', x_metric_formula_id='||x_metric_formula_id);

242: );
243:
244: -- Debug Message
245: IF (AMS_DEBUG_HIGH_ON) THEN
246: Ams_Utility_Pvt.debug_message( 'Private API: return_status='||x_return_status||', x_metric_formula_id='||x_metric_formula_id);
247: END IF;
248:
249: x_METRIC_FORMULA_ID := l_METRIC_FORMULA_ID;
250: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 267: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');

263:
264: -- Debug Message
265: IF (AMS_DEBUG_HIGH_ON) THEN
266:
267: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');
268: END IF;
269:
270: -- Standard call to get message count and if count is 1, get message info.
271: FND_MSG_PUB.Count_And_Get

Line 277: WHEN Ams_Utility_Pvt.resource_locked THEN

273: p_data => x_msg_data
274: );
275: EXCEPTION
276:
277: WHEN Ams_Utility_Pvt.resource_locked THEN
278: x_return_status := FND_API.g_ret_sts_error;
279: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
280:
281: WHEN FND_API.G_EXC_ERROR THEN

Line 279: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

275: EXCEPTION
276:
277: WHEN Ams_Utility_Pvt.resource_locked THEN
278: x_return_status := FND_API.g_ret_sts_error;
279: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
280:
281: WHEN FND_API.G_EXC_ERROR THEN
282: ROLLBACK TO CREATE_metric_formula_SP;
283: x_return_status := FND_API.G_RET_STS_ERROR;

Line 389: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');

385:
386: -- Debug Message
387: IF (AMS_DEBUG_HIGH_ON) THEN
388:
389: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');
390: END IF;
391:
392: -- Initialize API return status to SUCCESS
393: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 397: Ams_Utility_Pvt.debug_message('Private API: - Open Cursor to Select');

393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:
395: -- Debug Message
396: IF (AMS_DEBUG_HIGH_ON) THEN
397: Ams_Utility_Pvt.debug_message('Private API: - Open Cursor to Select');
398: END IF;
399:
400: OPEN c_get_metric_formula( l_tar_metric_formula_rec.METRIC_FORMULA_ID);
401:

Line 406: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

402: FETCH c_get_metric_formula INTO l_ref_metric_formula_rec;
403:
404: IF ( c_get_metric_formula%NOTFOUND) THEN
405: CLOSE c_get_metric_formula;
406: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
407: p_token_name => 'INFO',
408: p_token_value => 'metric_formula_id='||l_tar_metric_formula_rec.METRIC_FORMULA_ID);
409: RAISE FND_API.G_EXC_ERROR;
410: END IF;

Line 414: Ams_Utility_Pvt.debug_message('Private API: - Close Cursor');

410: END IF;
411:
412: -- Debug Message
413: IF (AMS_DEBUG_HIGH_ON) THEN
414: Ams_Utility_Pvt.debug_message('Private API: - Close Cursor');
415: END IF;
416: CLOSE c_get_metric_formula;
417:
418: Complete_metric_formula_rec(l_ref_metric_formula_rec, l_tar_metric_formula_rec);

Line 422: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_VERSION_MISSING',

418: Complete_metric_formula_rec(l_ref_metric_formula_rec, l_tar_metric_formula_rec);
419:
420: IF (l_tar_metric_formula_rec.object_version_number IS NULL OR
421: l_tar_metric_formula_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
422: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_VERSION_MISSING',
423: p_token_name => 'COLUMN',
424: p_token_value => 'OBJECT_VERSION_NUMBER');
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;

Line 430: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_RECORD_CHANGED',

426: END IF;
427:
428: -- Check Whether record has been changed by someone else
429: IF (l_tar_metric_formula_rec.object_version_number <> l_ref_metric_formula_rec.object_version_number) THEN
430: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_RECORD_CHANGED',
431: p_token_name => 'INFO',
432: p_token_value => 'metric_formula_id='||l_tar_metric_formula_rec.METRIC_FORMULA_ID);
433: RAISE FND_API.G_EXC_ERROR;
434: END IF;

Line 443: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_SEEDED_METR');

439: OR (l_tar_metric_formula_rec.metric_id <>l_ref_metric_formula_rec.metric_id)
440: ) THEN
441: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
442: THEN
443: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_SEEDED_METR');
444: END IF;
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447: END IF;

Line 464: Ams_Utility_Pvt.debug_message('Private API: Validate_metric_formula');

460: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL)
461: THEN
462: -- Debug message
463: IF (AMS_DEBUG_HIGH_ON) THEN
464: Ams_Utility_Pvt.debug_message('Private API: Validate_metric_formula');
465: END IF;
466:
467: -- Invoke validation procedures
468: Validate_metric_formula(

Line 479: Ams_Utility_Pvt.debug_message('Private API: Validate_metric_formula: return status='||x_return_status);

475: x_msg_count => x_msg_count,
476: x_msg_data => x_msg_data);
477: -- Debug message
478: IF (AMS_DEBUG_HIGH_ON) THEN
479: Ams_Utility_Pvt.debug_message('Private API: Validate_metric_formula: return status='||x_return_status);
480: END IF;
481: END IF;
482:
483: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

Line 492: Ams_Utility_Pvt.debug_message('Private API: Calling Ams_Metric_Formulas_Pkg.Update_Row, sequence='||l_tar_metric_formula_rec.sequence);

488: l_ref_metric_formula_rec.object_version_number + 1;
489:
490: -- Debug Message
491: IF (AMS_DEBUG_HIGH_ON) THEN
492: Ams_Utility_Pvt.debug_message('Private API: Calling Ams_Metric_Formulas_Pkg.Update_Row, sequence='||l_tar_metric_formula_rec.sequence);
493: END IF;
494:
495: -- Invoke table handler(Ams_Metric_Formulas_Pkg.Update_Row)
496: Ams_Metric_Formulas_Pkg.Update_Row(

Line 526: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');

522:
523: -- Debug Message
524: IF (AMS_DEBUG_HIGH_ON) THEN
525:
526: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');
527: END IF;
528:
529: -- Standard call to get message count and if count is 1, get message info.
530: FND_MSG_PUB.Count_And_Get

Line 536: WHEN Ams_Utility_Pvt.resource_locked THEN

532: p_data => x_msg_data
533: );
534: EXCEPTION
535:
536: WHEN Ams_Utility_Pvt.resource_locked THEN
537: x_return_status := FND_API.g_ret_sts_error;
538: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
539:
540: WHEN FND_API.G_EXC_ERROR THEN

Line 538: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

534: EXCEPTION
535:
536: WHEN Ams_Utility_Pvt.resource_locked THEN
537: x_return_status := FND_API.g_ret_sts_error;
538: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
539:
540: WHEN FND_API.G_EXC_ERROR THEN
541: ROLLBACK TO UPDATE_metric_formula_sp;
542: x_return_status := FND_API.G_RET_STS_ERROR;

Line 615: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');

611:
612: -- Debug Message
613: IF (AMS_DEBUG_HIGH_ON) THEN
614:
615: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');
616: END IF;
617:
618: --check if the formula is a seeded one
619: IF p_METRIC_FORMULA_ID < 10000 THEN

Line 622: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_SEEDED_METR');

618: --check if the formula is a seeded one
619: IF p_METRIC_FORMULA_ID < 10000 THEN
620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
621: THEN
622: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_SEEDED_METR');
623: END IF;
624:
625: RAISE FND_API.G_EXC_ERROR;
626: END IF;

Line 637: Ams_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');

633: --
634: -- Debug Message
635: IF (AMS_DEBUG_HIGH_ON) THEN
636:
637: Ams_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');
638: END IF;
639:
640: -- Invoke table handler(AMS_MET_TPL_DETAILS_PKG.Delete_Row)
641: AMS_METRIC_FORMULAS_PKG.Delete_Row(

Line 657: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');

653:
654: -- Debug Message
655: IF (AMS_DEBUG_HIGH_ON) THEN
656:
657: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');
658: END IF;
659:
660: -- Standard call to get message count and if count is 1, get message info.
661: FND_MSG_PUB.Count_And_Get

Line 667: WHEN Ams_Utility_Pvt.resource_locked THEN

663: p_data => x_msg_data
664: );
665: EXCEPTION
666:
667: WHEN Ams_Utility_Pvt.resource_locked THEN
668: x_return_status := FND_API.g_ret_sts_error;
669: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
670:
671: WHEN FND_API.G_EXC_ERROR THEN

Line 669: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

665: EXCEPTION
666:
667: WHEN Ams_Utility_Pvt.resource_locked THEN
668: x_return_status := FND_API.g_ret_sts_error;
669: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
670:
671: WHEN FND_API.G_EXC_ERROR THEN
672: ROLLBACK TO DELETE_metric_formula_SP;
673: x_return_status := FND_API.G_RET_STS_ERROR;

Line 740: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');

736: savepoint LOCK_metric_formula_SP;
737: -- Debug Message
738: IF (AMS_DEBUG_HIGH_ON) THEN
739:
740: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');
741: END IF;
742:
743: -- Initialize message list if p_init_msg_list is set to TRUE.
744: IF FND_API.to_Boolean( p_init_msg_list )

Line 765: Ams_Utility_Pvt.debug_message(l_full_name||': start');

761:
762: ------------------------ lock -------------------------
763:
764: IF (AMS_DEBUG_HIGH_ON) THEN
765: Ams_Utility_Pvt.debug_message(l_full_name||': start');
766: END IF;
767:
768: OPEN c_metric_formula;
769:

Line 789: Ams_Utility_Pvt.debug_message(l_full_name ||': end');

785: p_encoded => FND_API.g_false,
786: p_count => x_msg_count,
787: p_data => x_msg_data);
788: IF (AMS_DEBUG_HIGH_ON) THEN
789: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
790: END IF;
791: EXCEPTION
792:
793: WHEN Ams_Utility_Pvt.resource_locked THEN

Line 793: WHEN Ams_Utility_Pvt.resource_locked THEN

789: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
790: END IF;
791: EXCEPTION
792:
793: WHEN Ams_Utility_Pvt.resource_locked THEN
794: x_return_status := FND_API.g_ret_sts_error;
795: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
796:
797: WHEN FND_API.G_EXC_ERROR THEN

Line 795: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

791: EXCEPTION
792:
793: WHEN Ams_Utility_Pvt.resource_locked THEN
794: x_return_status := FND_API.g_ret_sts_error;
795: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
796:
797: WHEN FND_API.G_EXC_ERROR THEN
798: ROLLBACK TO LOCK_metric_formula_SP;
799: x_return_status := FND_API.G_RET_STS_ERROR;

Line 858: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_uk_items : START');

854: */
855: BEGIN
856: -- Debug Message
857: IF (AMS_DEBUG_HIGH_ON) THEN
858: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_uk_items : START');
859: END IF;
860: x_return_status := FND_API.g_ret_sts_success;
861: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
862: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(

Line 862: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(

858: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_uk_items : START');
859: END IF;
860: x_return_status := FND_API.g_ret_sts_success;
861: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
862: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
863: 'AMS_METRIC_FORMULAS',
864: 'METRIC_FORMULA_ID = ' || p_metric_formula_rec.METRIC_FORMULA_ID
865: );
866: END IF;

Line 869: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_FORMULA_ID_DUP');

865: );
866: END IF;
867:
868: IF l_valid_flag = FND_API.g_false THEN
869: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_FORMULA_ID_DUP');
870: x_return_status := FND_API.g_ret_sts_error;
871: RETURN;
872: END IF;
873: /*

Line 888: AMS_UTILITY_PVT.ERROR_MESSAGE(p_message_name => 'AMS_METR_INVALID_SEQUENCE');

884: close c_check_sequence_update;
885: END IF;
886:
887: IF l_dummy > 0 THEN
888: AMS_UTILITY_PVT.ERROR_MESSAGE(p_message_name => 'AMS_METR_INVALID_SEQUENCE');
889: x_return_status := FND_API.g_ret_sts_error;
890: RETURN;
891: END IF;
892: */

Line 895: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_uk_items : END');

891: END IF;
892: */
893: -- Debug Message
894: IF (AMS_DEBUG_HIGH_ON) THEN
895: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_uk_items : END');
896: END IF;
897: END check_metric_formula_uk_items;
898:
899: PROCEDURE check_metric_formula_req_items(

Line 908: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : START');

904: IS
905: BEGIN
906: -- Debug Message
907: IF (AMS_DEBUG_HIGH_ON) THEN
908: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : START');
909: END IF;
910: x_return_status := FND_API.g_ret_sts_success;
911:
912: IF p_validation_mode = JTF_PLSQL_API.g_create THEN

Line 916: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : metric_id='||p_metric_formula_rec.metric_id);

912: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
913:
914: -- Debug Message
915: IF (AMS_DEBUG_HIGH_ON) THEN
916: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : metric_id='||p_metric_formula_rec.metric_id);
917: END IF;
918: IF p_metric_formula_rec.metric_id = FND_API.g_miss_num OR p_metric_formula_rec.metric_id IS NULL THEN
919: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
920: FND_MESSAGE.set_token('MISS_FIELD','METRIC_ID');

Line 927: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : source_type='||p_metric_formula_rec.source_type);

923: END IF;
924:
925: -- Debug Message
926: IF (AMS_DEBUG_HIGH_ON) THEN
927: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : source_type='||p_metric_formula_rec.source_type);
928: END IF;
929: IF p_metric_formula_rec.source_type = FND_API.G_MISS_CHAR OR p_metric_formula_rec.source_type IS NULL THEN
930: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
931: FND_MESSAGE.set_token('MISS_FIELD','SOURCE_TYPE');

Line 939: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : source_id='||p_metric_formula_rec.source_id);

935:
936: IF p_metric_formula_rec.source_type IN ('METRIC','CATEGORY') THEN
937: -- Debug Message
938: IF (AMS_DEBUG_HIGH_ON) THEN
939: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : source_id='||p_metric_formula_rec.source_id);
940: END IF;
941: IF p_metric_formula_rec.source_id IS NULL OR p_metric_formula_rec.source_id = FND_API.G_MISS_NUM THEN
942: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
943: FND_MESSAGE.set_token('MISS_FIELD','SOURCE_ID');

Line 949: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : use_sub_id_flag='||p_metric_formula_rec.use_sub_id_flag);

945: RETURN;
946: END IF;
947: -- Debug Message
948: IF (AMS_DEBUG_HIGH_ON) THEN
949: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : use_sub_id_flag='||p_metric_formula_rec.use_sub_id_flag);
950: END IF;
951: IF p_metric_formula_rec.source_type = 'CATEGORY' AND
952: (p_metric_formula_rec.use_sub_id_flag IS NULL OR p_metric_formula_rec.use_sub_id_flag = FND_API.G_MISS_CHAR) THEN
953: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');

Line 974: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : notation_type='||p_metric_formula_rec.notation_type);

970: END IF;
971:
972: -- Debug Message
973: IF (AMS_DEBUG_HIGH_ON) THEN
974: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : notation_type='||p_metric_formula_rec.notation_type);
975: END IF;
976: IF p_metric_formula_rec.notation_type = FND_API.g_miss_char OR p_metric_formula_rec.notation_type IS NULL THEN
977: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
978: FND_MESSAGE.set_token('MISS_FIELD','NOTATION_TYPE');

Line 1003: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : END');

999: END IF;
1000:
1001: -- Debug Message
1002: IF (AMS_DEBUG_HIGH_ON) THEN
1003: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_req_items : END');
1004: END IF;
1005: END check_metric_formula_req_items;
1006:
1007: PROCEDURE check_metric_formula_FK_items(

Line 1046: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_METRIC_ID',

1042: -- Validate metric_id exists.
1043: OPEN c_check_metric_parent(p_metric_formula_rec.metric_id);
1044: FETCH c_check_metric_parent INTO l_object_type, l_calculation_type;
1045: IF c_check_metric_parent%NOTFOUND THEN
1046: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_METRIC_ID',
1047: p_token_name => 'METRIC_ID',
1048: p_token_value => p_metric_formula_rec.metric_id);
1049: x_return_status := FND_API.g_ret_sts_error;
1050: elsif l_calculation_type <> 'FORMULA' THEN

Line 1051: Ams_Utility_pvt.error_message(p_message_name => 'AMS_METR_INVALID_FORMULA_TYPE');

1047: p_token_name => 'METRIC_ID',
1048: p_token_value => p_metric_formula_rec.metric_id);
1049: x_return_status := FND_API.g_ret_sts_error;
1050: elsif l_calculation_type <> 'FORMULA' THEN
1051: Ams_Utility_pvt.error_message(p_message_name => 'AMS_METR_INVALID_FORMULA_TYPE');
1052: x_return_status := FND_API.g_ret_sts_error;
1053: END IF;
1054: CLOSE c_check_metric_parent;
1055:

Line 1061: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_METRIC_SOURCE');

1057: IF p_metric_formula_rec.source_type = 'METRIC' THEN
1058: OPEN c_check_metric_source(p_metric_formula_rec.SOURCE_id);
1059: FETCH c_check_metric_source INTO l_source_object_type;
1060: IF c_check_metric_source%NOTFOUND THEN
1061: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_METRIC_SOURCE');
1062: x_return_status := FND_API.g_ret_sts_error;
1063: ELSIF l_object_type = 'ANY' and l_source_object_type <> 'ANY' then
1064: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_METRIC_SOURCE');
1065: x_return_status := FND_API.g_ret_sts_error;

Line 1064: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_METRIC_SOURCE');

1060: IF c_check_metric_source%NOTFOUND THEN
1061: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_METRIC_SOURCE');
1062: x_return_status := FND_API.g_ret_sts_error;
1063: ELSIF l_object_type = 'ANY' and l_source_object_type <> 'ANY' then
1064: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_METRIC_SOURCE');
1065: x_return_status := FND_API.g_ret_sts_error;
1066: ELSIF l_object_type <> 'ANY' and l_source_object_type NOT in ('ANY', l_object_type) THEN
1067: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_METRIC_SOURCE');
1068: x_return_status := FND_API.g_ret_sts_error;

Line 1067: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_METRIC_SOURCE');

1063: ELSIF l_object_type = 'ANY' and l_source_object_type <> 'ANY' then
1064: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_METRIC_SOURCE');
1065: x_return_status := FND_API.g_ret_sts_error;
1066: ELSIF l_object_type <> 'ANY' and l_source_object_type NOT in ('ANY', l_object_type) THEN
1067: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_METRIC_SOURCE');
1068: x_return_status := FND_API.g_ret_sts_error;
1069: END IF;
1070: CLOSE c_check_metric_source;
1071: ELSIF p_metric_formula_rec.source_type = 'CATEGORY' THEN

Line 1076: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_CATEGORY_SRC');

1072: OPEN c_check_category(p_metric_formula_rec.source_id);
1073: FETCH c_check_category INTO l_dummy;
1074: CLOSE c_check_category;
1075: IF l_dummy <> 1 then
1076: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_CATEGORY_SRC');
1077: x_return_status := FND_API.g_ret_sts_error;
1078: ELSE
1079: IF p_metric_formula_rec.use_sub_id_flag = 'Y' AND
1080: p_metric_formula_rec.source_sub_id is not null THEN

Line 1085: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_CATEGORY_SRC');

1081: open c_check_sub_category(p_metric_formula_rec.source_id, p_metric_formula_rec.source_sub_id);
1082: fetch c_check_sub_category into l_dummy;
1083: close c_check_sub_category;
1084: IF l_dummy <> 1 then
1085: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_CATEGORY_SRC');
1086: x_return_status := FND_API.g_ret_sts_error;
1087: END IF;
1088: end if;
1089: END IF;

Line 1104: Ams_Utility_Pvt.is_y_or_n(p_metric_formula_rec.use_sub_id_flag) = FND_API.G_FALSE THEN

1100: x_return_status := FND_API.g_ret_sts_success;
1101:
1102: -- Enter custom code here
1103: IF p_metric_formula_rec.use_sub_id_flag is not null and
1104: Ams_Utility_Pvt.is_y_or_n(p_metric_formula_rec.use_sub_id_flag) = FND_API.G_FALSE THEN
1105: Ams_Utility_Pvt.error_message(p_message_name=>'AMS_METR_INVALID_USE_SUB_ID',
1106: p_token_name => 'USE_SUB_ID_FLAG',
1107: p_token_value=>p_metric_formula_rec.use_sub_id_flag);
1108: x_return_status := FND_API.g_ret_sts_error;

Line 1105: Ams_Utility_Pvt.error_message(p_message_name=>'AMS_METR_INVALID_USE_SUB_ID',

1101:
1102: -- Enter custom code here
1103: IF p_metric_formula_rec.use_sub_id_flag is not null and
1104: Ams_Utility_Pvt.is_y_or_n(p_metric_formula_rec.use_sub_id_flag) = FND_API.G_FALSE THEN
1105: Ams_Utility_Pvt.error_message(p_message_name=>'AMS_METR_INVALID_USE_SUB_ID',
1106: p_token_name => 'USE_SUB_ID_FLAG',
1107: p_token_value=>p_metric_formula_rec.use_sub_id_flag);
1108: x_return_status := FND_API.g_ret_sts_error;
1109: END IF;

Line 1111: IF ams_utility_pvt.check_lookup_exists('AMS_LOOKUPS','AMS_METRIC_SOURCE_TYPE',p_metric_formula_rec.source_type) = FND_API.G_FALSE THEN

1107: p_token_value=>p_metric_formula_rec.use_sub_id_flag);
1108: x_return_status := FND_API.g_ret_sts_error;
1109: END IF;
1110:
1111: IF ams_utility_pvt.check_lookup_exists('AMS_LOOKUPS','AMS_METRIC_SOURCE_TYPE',p_metric_formula_rec.source_type) = FND_API.G_FALSE THEN
1112: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_SOURCE_TYPE',
1113: p_token_name => 'SOURCE_TYPE',
1114: p_token_value => p_metric_formula_rec.source_type);
1115: x_return_status := FND_API.g_ret_sts_error;

Line 1112: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_SOURCE_TYPE',

1108: x_return_status := FND_API.g_ret_sts_error;
1109: END IF;
1110:
1111: IF ams_utility_pvt.check_lookup_exists('AMS_LOOKUPS','AMS_METRIC_SOURCE_TYPE',p_metric_formula_rec.source_type) = FND_API.G_FALSE THEN
1112: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_SOURCE_TYPE',
1113: p_token_name => 'SOURCE_TYPE',
1114: p_token_value => p_metric_formula_rec.source_type);
1115: x_return_status := FND_API.g_ret_sts_error;
1116: END IF;

Line 1118: IF ams_utility_pvt.check_lookup_exists('AMS_LOOKUPS','AMS_METRIC_NOTATION_TYPE',p_metric_formula_rec.notation_type) = FND_API.G_FALSE THEN

1114: p_token_value => p_metric_formula_rec.source_type);
1115: x_return_status := FND_API.g_ret_sts_error;
1116: END IF;
1117:
1118: IF ams_utility_pvt.check_lookup_exists('AMS_LOOKUPS','AMS_METRIC_NOTATION_TYPE',p_metric_formula_rec.notation_type) = FND_API.G_FALSE THEN
1119: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_NOTATION_TYPE',
1120: p_token_name => 'NOTATION_TYPE',
1121: p_token_value => p_metric_formula_rec.notation_type);
1122: x_return_status := FND_API.g_ret_sts_error;

Line 1119: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_NOTATION_TYPE',

1115: x_return_status := FND_API.g_ret_sts_error;
1116: END IF;
1117:
1118: IF ams_utility_pvt.check_lookup_exists('AMS_LOOKUPS','AMS_METRIC_NOTATION_TYPE',p_metric_formula_rec.notation_type) = FND_API.G_FALSE THEN
1119: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_NOTATION_TYPE',
1120: p_token_name => 'NOTATION_TYPE',
1121: p_token_value => p_metric_formula_rec.notation_type);
1122: x_return_status := FND_API.g_ret_sts_error;
1123: END IF;

Line 1126: ams_utility_pvt.check_lookup_exists('AMS_LOOKUPS','AMS_METRIC_OPERAND_TYPE',p_metric_formula_rec.token) = FND_API.G_FALSE THEN

1122: x_return_status := FND_API.g_ret_sts_error;
1123: END IF;
1124:
1125: IF p_metric_formula_rec.source_type = 'OPERATOR' and p_metric_formula_rec.TOKEN is not null and
1126: ams_utility_pvt.check_lookup_exists('AMS_LOOKUPS','AMS_METRIC_OPERAND_TYPE',p_metric_formula_rec.token) = FND_API.G_FALSE THEN
1127: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_OPERATOR',
1128: p_token_name => 'OPERATOR',
1129: p_token_value => p_metric_formula_rec.token);
1130: x_return_status := FND_API.g_ret_sts_error;

Line 1127: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_OPERATOR',

1123: END IF;
1124:
1125: IF p_metric_formula_rec.source_type = 'OPERATOR' and p_metric_formula_rec.TOKEN is not null and
1126: ams_utility_pvt.check_lookup_exists('AMS_LOOKUPS','AMS_METRIC_OPERAND_TYPE',p_metric_formula_rec.token) = FND_API.G_FALSE THEN
1127: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_METR_INVALID_OPERATOR',
1128: p_token_name => 'OPERATOR',
1129: p_token_value => p_metric_formula_rec.token);
1130: x_return_status := FND_API.g_ret_sts_error;
1131: END IF;

Line 1145: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_items : START');

1141: BEGIN
1142:
1143: -- Debug Message
1144: IF (AMS_DEBUG_HIGH_ON) THEN
1145: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_items : START');
1146: END IF;
1147: -- Check Items Uniqueness API calls
1148:
1149: check_metric_formula_uk_items(

Line 1185: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_items : END');

1181: END IF;
1182:
1183: -- Debug Message
1184: IF (AMS_DEBUG_HIGH_ON) THEN
1185: Ams_Utility_Pvt.debug_message('PRIVATE API: check_metric_formula_items : END');
1186: END IF;
1187: END Check_metric_formula_Items;
1188:
1189: PROCEDURE Complete_metric_formula_Rec (

Line 1288: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': START');

1284: END IF;
1285:
1286: -- Debug Message
1287: IF (AMS_DEBUG_HIGH_ON) THEN
1288: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': START');
1289: END IF;
1290:
1291:
1292: -- Initialize API return status to SUCCESS

Line 1334: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': END');

1330:
1331:
1332: -- Debug Message
1333: IF (AMS_DEBUG_HIGH_ON) THEN
1334: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': END');
1335: END IF;
1336:
1337: -- Standard call to get message count and if count is 1, get message info.
1338: FND_MSG_PUB.Count_And_Get

Line 1344: WHEN Ams_Utility_Pvt.resource_locked THEN

1340: p_data => x_msg_data
1341: );
1342: EXCEPTION
1343:
1344: WHEN Ams_Utility_Pvt.resource_locked THEN
1345: x_return_status := FND_API.g_ret_sts_error;
1346: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1347:
1348: WHEN FND_API.G_EXC_ERROR THEN

Line 1346: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1342: EXCEPTION
1343:
1344: WHEN Ams_Utility_Pvt.resource_locked THEN
1345: x_return_status := FND_API.g_ret_sts_error;
1346: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1347:
1348: WHEN FND_API.G_EXC_ERROR THEN
1349: -- ROLLBACK TO VALIDATE_metric_formula_sp;
1350: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1410: Ams_Utility_Pvt.debug_message('PRIVATE API: Validate_metric_formula_rec');

1406: -- x_return_status := FND_API.G_RET_STS_ERROR;
1407:
1408: -- Debug Message
1409: IF (AMS_DEBUG_HIGH_ON) THEN
1410: Ams_Utility_Pvt.debug_message('PRIVATE API: Validate_metric_formula_rec');
1411: END IF;
1412: -- Standard call to get message count and if count is 1, get message info.
1413: FND_MSG_PUB.Count_And_Get
1414: (p_count => x_msg_count,

Line 1463: l_error_msg := ams_utility_pvt.get_lookup_meaning('AMS_METRIC_STRINGS','ERROR');

1459: procedure error_infix
1460: is
1461: l_error_msg VARCHAR2(150);
1462: begin
1463: l_error_msg := ams_utility_pvt.get_lookup_meaning('AMS_METRIC_STRINGS','ERROR');
1464: g_infix_formula := g_infix_formula || ' ' || l_error_msg;
1465: g_valid_formula := false;
1466: if g_error_sequence is null then
1467: g_error_sequence := g_current_sequence;

Line 1477: AMS_UTILITY_PVT.ERROR_MESSAGE(p_message_name => 'AMS_METR_INVALID_SEQUENCE');

1473: begin
1474: x_formula_rec := g_infix_tbl(g_infix_index);
1475: if g_current_sequence is not null AND
1476: g_current_sequence = x_formula_rec.sequence THEN
1477: AMS_UTILITY_PVT.ERROR_MESSAGE(p_message_name => 'AMS_METR_INVALID_SEQUENCE');
1478: error_infix;
1479: end if;
1480: g_current_sequence := x_formula_rec.sequence;
1481: g_infix_index := g_infix_tbl.next(g_infix_index);

Line 1709: Ams_Utility_Pvt.debug_message('PRIVATE API: VALIDATE_FORMULA');

1705: l_valid_msg varchar2(200);
1706: BEGIN
1707: -- Debug Message
1708: IF (AMS_DEBUG_HIGH_ON) THEN
1709: Ams_Utility_Pvt.debug_message('PRIVATE API: VALIDATE_FORMULA');
1710: END IF;
1711: -- Initialize message list if p_init_msg_list is set to TRUE.
1712: IF FND_API.to_Boolean( p_init_msg_list )
1713: THEN

Line 1820: Ams_Utility_Pvt.debug_message('PRIVATE API: VALIDATE_FORMULA');

1816: END IF;
1817:
1818: -- Debug Message
1819: IF (AMS_DEBUG_HIGH_ON) THEN
1820: Ams_Utility_Pvt.debug_message('PRIVATE API: VALIDATE_FORMULA');
1821: END IF;
1822:
1823:
1824: -- Standard call to get message count and if count is 1, get message info.