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

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

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

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

117: -- =========================================================================
118:
119: IF FND_GLOBAL.User_Id IS NULL
120: THEN
121: Ams_Utility_Pvt.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
122: RAISE FND_API.G_EXC_ERROR;
123: END IF;
124:
125: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 130: Ams_Utility_Pvt.debug_message('Private API: Validate_Metric_Template');

126: THEN
127: -- Debug message
128: IF (AMS_DEBUG_HIGH_ON) THEN
129:
130: Ams_Utility_Pvt.debug_message('Private API: Validate_Metric_Template');
131: END IF;
132:
133: -- Invoke validation procedures
134: Validate_metric_template(

Line 153: Ams_Utility_Pvt.debug_message( 'Private API: Calling create table handler');

149:
150: -- Debug Message
151: IF (AMS_DEBUG_HIGH_ON) THEN
152:
153: Ams_Utility_Pvt.debug_message( 'Private API: Calling create table handler');
154: END IF;
155:
156: -- Invoke table handler(AMS_MET_TPL_HEADERS_B_PKG.Insert_Row)
157: Ams_Met_Tpl_Headers_B_Pkg.Insert_Row(

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

189:
190: -- Debug Message
191: IF (AMS_DEBUG_HIGH_ON) THEN
192:
193: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
194: END IF;
195:
196: -- Standard call to get message count and if count is 1, get message info.
197: FND_MSG_PUB.Count_And_Get

Line 203: WHEN Ams_Utility_Pvt.resource_locked THEN

199: p_data => x_msg_data
200: );
201: EXCEPTION
202:
203: WHEN Ams_Utility_Pvt.resource_locked THEN
204: x_return_status := FND_API.g_ret_sts_error;
205: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
206:
207: WHEN FND_API.G_EXC_ERROR THEN

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

201: EXCEPTION
202:
203: WHEN Ams_Utility_Pvt.resource_locked THEN
204: x_return_status := FND_API.g_ret_sts_error;
205: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
206:
207: WHEN FND_API.G_EXC_ERROR THEN
208: ROLLBACK TO CREATE_Metric_Template_PVT;
209: x_return_status := FND_API.G_RET_STS_ERROR;

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

304: END IF;
305:
306: -- Debug Message
307: IF (AMS_DEBUG_HIGH_ON) THEN
308: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');
309: END IF;
310:
311: -- Initialize API return status to SUCCESS
312: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 318: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name ||

314: -- Initialize the tar record.
315: l_tar_metric_tpl_header_rec := P_metric_tpl_header_rec;
316:
317: IF (AMS_DEBUG_HIGH_ON) THEN
318: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name ||
319: ': ASSOCIATION_TYPE = '|| l_tar_metric_tpl_header_rec.association_type);
320: END IF;
321:
322: IF (l_tar_metric_tpl_header_rec.METRIC_TPL_HEADER_ID IS NULL OR

Line 325: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD',

321:
322: IF (l_tar_metric_tpl_header_rec.METRIC_TPL_HEADER_ID IS NULL OR
323: l_tar_metric_tpl_header_rec.METRIC_TPL_HEADER_ID = FND_API.G_MISS_NUM )
324: THEN
325: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_MISSING_FIELD',
326: p_token_name => 'COLUMN',
327: p_token_value => 'METRIC_TPL_HEADER_ID');
328: RAISE FND_API.G_EXC_ERROR;
329: END IF;

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

330:
331: IF (l_tar_metric_tpl_header_rec.object_version_number IS NULL OR
332: l_tar_metric_tpl_header_rec.object_version_number = FND_API.G_MISS_NUM)
333: THEN
334: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_VERSION_MISSING',
335: p_token_name => 'COLUMN',
336: p_token_value => 'object_version_number');
337: RAISE FND_API.G_EXC_ERROR;
338: END IF;

Line 345: Ams_Utility_Pvt.Error_Message(

341:
342: FETCH c_get_Metric_Template INTO l_ref_metric_tpl_header_rec;
343:
344: IF ( c_get_Metric_Template%NOTFOUND) THEN
345: Ams_Utility_Pvt.Error_Message(
346: p_message_name => 'API_MISSING_UPDATE_TARGET',
347: p_token_name => 'INFO',
348: p_token_value => 'Metric_Template');
349: CLOSE c_get_Metric_Template;

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

354:
355: -- Check Whether record has been changed by someone else
356: IF (l_tar_metric_tpl_header_rec.object_version_number <>
357: l_ref_metric_tpl_header_rec.object_version_number) THEN
358: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_RECORD_CHANGED',
359: p_token_name => 'INFO',
360: p_token_value => 'Metric_Template');
361: RAISE FND_API.G_EXC_ERROR;
362: END IF;

Line 376: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED_MOD');

372: AND (l_tar_metric_tpl_header_rec.enabled_flag =
373: l_ref_metric_tpl_header_rec.enabled_flag)) THEN
374: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
375: THEN
376: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED_MOD');
377: END IF;
378:
379: RAISE FND_API.G_EXC_ERROR;
380: END IF;

Line 394: Ams_Utility_Pvt.debug_message('Private API: Validate_Metric_Template');

390: THEN
391: -- Debug message
392: IF (AMS_DEBUG_HIGH_ON) THEN
393:
394: Ams_Utility_Pvt.debug_message('Private API: Validate_Metric_Template');
395: END IF;
396:
397: -- Invoke validation procedures
398: Validate_metric_template(

Line 416: Ams_Utility_Pvt.debug_message('Private API: Calling Ams_Met_Tpl_Headers_B_Pkg.Update_Row');

412:
413: -- Debug Message
414: IF (AMS_DEBUG_HIGH_ON) THEN
415:
416: Ams_Utility_Pvt.debug_message('Private API: Calling Ams_Met_Tpl_Headers_B_Pkg.Update_Row');
417: END IF;
418:
419: -- Invoke table handler(AMS_MET_TPL_HEADERS_B_PKG.Update_Row)
420: Ams_Met_Tpl_Headers_B_Pkg.Update_Row(

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

446:
447: -- Debug Message
448: IF (AMS_DEBUG_HIGH_ON) THEN
449:
450: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': END');
451: END IF;
452:
453: -- Standard call to get message count and if count is 1, get message info.
454: FND_MSG_PUB.Count_And_Get

Line 460: WHEN Ams_Utility_Pvt.resource_locked THEN

456: p_data => x_msg_data
457: );
458: EXCEPTION
459:
460: WHEN Ams_Utility_Pvt.resource_locked THEN
461: x_return_status := FND_API.g_ret_sts_error;
462: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
463:
464: WHEN FND_API.G_EXC_ERROR THEN

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

458: EXCEPTION
459:
460: WHEN Ams_Utility_Pvt.resource_locked THEN
461: x_return_status := FND_API.g_ret_sts_error;
462: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
463:
464: WHEN FND_API.G_EXC_ERROR THEN
465: ROLLBACK TO UPDATE_Metric_Template_PVT;
466: x_return_status := FND_API.G_RET_STS_ERROR;

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

534:
535: -- Debug Message
536: IF (AMS_DEBUG_HIGH_ON) THEN
537:
538: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': START');
539: END IF;
540:
541:
542: --11/26/02 sunil : check if the template is a seeded one

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

542: --11/26/02 sunil : check if the template is a seeded one
543: IF p_metric_tpl_header_id < 10000 THEN
544: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
545: THEN
546: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED');
547: END IF;
548:
549: RAISE FND_API.G_EXC_ERROR;
550: END IF;

Line 564: Ams_Utility_Pvt.debug_message(

560:
561: -- Debug Message
562: IF (AMS_DEBUG_HIGH_ON) THEN
563:
564: Ams_Utility_Pvt.debug_message(
565: 'PRIVATE API: DELETING metric template id='||p_metric_tpl_header_id);
566: END IF;
567:
568: -- Debug Message

Line 571: Ams_Utility_Pvt.debug_message( 'PRIVATE API: DELETING metric template details');

567:
568: -- Debug Message
569: IF (AMS_DEBUG_HIGH_ON) THEN
570:
571: Ams_Utility_Pvt.debug_message( 'PRIVATE API: DELETING metric template details');
572: END IF;
573:
574: DELETE FROM ams_met_tpl_details
575: WHERE metric_tpl_header_id = p_metric_tpl_header_id;

Line 580: Ams_Utility_Pvt.debug_message( 'PRIVATE API: DELETING metric template associations');

576:
577: -- Debug Message
578: IF (AMS_DEBUG_HIGH_ON) THEN
579:
580: Ams_Utility_Pvt.debug_message( 'PRIVATE API: DELETING metric template associations');
581: END IF;
582:
583: DELETE FROM ams_met_tpl_assocs
584: WHERE metric_tpl_header_id = p_metric_tpl_header_id;

Line 589: Ams_Utility_Pvt.debug_message( 'PRIVATE API: Calling DELETE TABLE handler');

585:
586: -- Debug Message
587: IF (AMS_DEBUG_HIGH_ON) THEN
588:
589: Ams_Utility_Pvt.debug_message( 'PRIVATE API: Calling DELETE TABLE handler');
590: END IF;
591:
592: -- Invoke table handler(AMS_MET_TPL_HEADERS_B_PKG.Delete_Row)
593: Ams_Met_Tpl_Headers_B_Pkg.Delete_Row(

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

605:
606: -- Debug Message
607: IF (AMS_DEBUG_HIGH_ON) THEN
608:
609: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'END');
610: END IF;
611:
612: -- Standard call to get message count and if count is 1, get message info.
613: FND_MSG_PUB.Count_And_Get

Line 619: WHEN Ams_Utility_Pvt.resource_locked THEN

615: p_data => x_msg_data
616: );
617: EXCEPTION
618:
619: WHEN Ams_Utility_Pvt.resource_locked THEN
620: x_return_status := FND_API.g_ret_sts_error;
621: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
622:
623: WHEN FND_API.G_EXC_ERROR THEN

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

617: EXCEPTION
618:
619: WHEN Ams_Utility_Pvt.resource_locked THEN
620: x_return_status := FND_API.g_ret_sts_error;
621: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
622:
623: WHEN FND_API.G_EXC_ERROR THEN
624: ROLLBACK TO DELETE_Metric_Template_PVT;
625: x_return_status := FND_API.G_RET_STS_ERROR;

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

685:
686: -- Debug Message
687: IF (AMS_DEBUG_HIGH_ON) THEN
688:
689: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'START');
690: END IF;
691:
692: -- Initialize message list if p_init_msg_list is set to TRUE.
693: IF FND_API.to_Boolean( p_init_msg_list )

Line 718: Ams_Utility_Pvt.debug_message(l_full_name||': START');

714: IF (AMS_DEBUG_HIGH_ON) THEN
715:
716:
717:
718: Ams_Utility_Pvt.debug_message(l_full_name||': START');
719:
720: END IF;
721: OPEN c_Metric_Template;
722:

Line 743: Ams_Utility_Pvt.debug_message(l_full_name ||': END');

739: p_count => x_msg_count,
740: p_data => x_msg_data);
741: IF (AMS_DEBUG_HIGH_ON) THEN
742:
743: Ams_Utility_Pvt.debug_message(l_full_name ||': END');
744: END IF;
745: EXCEPTION
746:
747: WHEN Ams_Utility_Pvt.resource_locked THEN

Line 747: WHEN Ams_Utility_Pvt.resource_locked THEN

743: Ams_Utility_Pvt.debug_message(l_full_name ||': END');
744: END IF;
745: EXCEPTION
746:
747: WHEN Ams_Utility_Pvt.resource_locked THEN
748: x_return_status := FND_API.g_ret_sts_error;
749: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
750:
751: WHEN FND_API.G_EXC_ERROR THEN

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

745: EXCEPTION
746:
747: WHEN Ams_Utility_Pvt.resource_locked THEN
748: x_return_status := FND_API.g_ret_sts_error;
749: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
750:
751: WHEN FND_API.G_EXC_ERROR THEN
752: ROLLBACK TO LOCK_Metric_Template_PVT;
753: x_return_status := FND_API.G_RET_STS_ERROR;

Line 825: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_UK_items:'

821: BEGIN
822: x_return_status := FND_API.g_ret_sts_success;
823:
824: IF AMS_DEBUG_HIGH_ON THEN
825: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_UK_items:'
826: || ' name/id=' || p_metric_tpl_header_rec.metric_tpl_header_name
827: || '/' || p_metric_tpl_header_rec.metric_tpl_header_id);
828: END IF;
829:

Line 832: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(

828: END IF;
829:
830: -- Validate the PK ID is unique.
831: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
832: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
833: 'AMS_MET_TPL_HEADERS_VL',
834: 'METRIC_TPL_HEADER_ID = ' || p_metric_tpl_header_rec.METRIC_TPL_HEADER_ID
835: );
836: IF l_valid_flag = FND_API.g_false THEN

Line 837: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTH_ID_DUPLICATE');

833: 'AMS_MET_TPL_HEADERS_VL',
834: 'METRIC_TPL_HEADER_ID = ' || p_metric_tpl_header_rec.METRIC_TPL_HEADER_ID
835: );
836: IF l_valid_flag = FND_API.g_false THEN
837: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTH_ID_DUPLICATE');
838: x_return_status := FND_API.g_ret_sts_error;
839: RETURN;
840: END IF;
841: -- ELSE

Line 842: -- l_valid_flag := Ams_Utility_Pvt.check_uniqueness(

838: x_return_status := FND_API.g_ret_sts_error;
839: RETURN;
840: END IF;
841: -- ELSE
842: -- l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
843: -- 'AMS_MET_TPL_HEADERS_VL',
844: -- 'METRIC_TPL_HEADER_ID = ' || p_metric_tpl_header_rec.METRIC_TPL_HEADER_ID ||
845: -- ' AND METRIC_TPL_HEADER_ID <> ' || p_metric_tpl_header_rec.METRIC_TPL_HEADER_ID
846: -- );

Line 880: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTH_NAME_DUPLICATE');

876:
877: /*End changes sunkumar */
878:
879: IF l_valid_flag = FND_API.g_false THEN
880: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTH_NAME_DUPLICATE');
881: x_return_status := FND_API.g_ret_sts_error;
882: RETURN;
883: END IF;
884:

Line 958: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTH_NO_MET_TPL_HDR_ID');

954: ELSE -- Update
955:
956: IF p_metric_tpl_header_rec.metric_tpl_header_id IS NULL OR
957: p_metric_tpl_header_rec.metric_tpl_header_id = FND_API.g_miss_num THEN
958: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTH_NO_MET_TPL_HDR_ID');
959: x_return_status := FND_API.g_ret_sts_error;
960: RETURN;
961: END IF;
962:

Line 965: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTH_NO_ENABLED_FLAG');

961: END IF;
962:
963: IF p_metric_tpl_header_rec.enabled_flag IS NULL OR
964: p_metric_tpl_header_rec.enabled_flag = FND_API.g_miss_char THEN
965: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTH_NO_ENABLED_FLAG');
966: x_return_status := FND_API.g_ret_sts_error;
967: RETURN;
968: END IF;
969:

Line 1038: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_FK'||

1034:
1035: IF p_metric_tpl_header_rec.ASSOCIATION_TYPE = 'OBJECT_TYPE' THEN
1036:
1037: IF AMS_DEBUG_HIGH_ON THEN
1038: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_FK'||
1039: ': object_type = '|| p_metric_tpl_header_rec.USED_BY_CODE);
1040: END IF;
1041:
1042: OPEN c_checkObjectType(p_metric_tpl_header_rec.USED_BY_CODE);

Line 1047: Ams_Utility_Pvt.error_message('AMS_MTH_INVALID_OBJECT_TYPE');

1043: FETCH c_checkObjectType INTO l_count;
1044: CLOSE c_checkObjectTYpe;
1045:
1046: IF l_count = 0 THEN
1047: Ams_Utility_Pvt.error_message('AMS_MTH_INVALID_OBJECT_TYPE');
1048: x_return_status := FND_API.g_ret_sts_error;
1049: END IF;
1050:
1051: ELSIF p_metric_tpl_header_rec.ASSOCIATION_TYPE = 'CUSTOM_SETUP' THEN

Line 1054: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_FK'||

1050:
1051: ELSIF p_metric_tpl_header_rec.ASSOCIATION_TYPE = 'CUSTOM_SETUP' THEN
1052:
1053: IF AMS_DEBUG_HIGH_ON THEN
1054: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_FK'||
1055: ': custom_setup_id = '|| p_metric_tpl_header_rec.USED_BY_ID);
1056: END IF;
1057:
1058: OPEN c_checkCustomSetup(p_metric_tpl_header_rec.USED_BY_ID);

Line 1063: Ams_Utility_Pvt.error_message('AMS_MTH_INVALID_CUSTOM_SETUP');

1059: FETCH c_checkCustomSetup INTO l_count;
1060: CLOSE c_checkCustomSetup;
1061:
1062: IF l_count = 0 THEN
1063: Ams_Utility_Pvt.error_message('AMS_MTH_INVALID_CUSTOM_SETUP');
1064: x_return_status := FND_API.g_ret_sts_error;
1065: END IF;
1066:
1067: END IF;

Line 1070: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_FK'||

1066:
1067: END IF;
1068:
1069: IF AMS_DEBUG_HIGH_ON THEN
1070: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_FK'||
1071: ': x_return_status = '|| x_return_status);
1072: END IF;
1073:
1074: END CHECK_met_tpl_hdr_FK_ITEMS;

Line 1085: IF Ams_Utility_Pvt.is_y_or_n(p_metric_tpl_header_rec.enabled_flag) =

1081: BEGIN
1082: x_return_status := FND_API.g_ret_sts_success;
1083:
1084: -- Enter custom code here
1085: IF Ams_Utility_Pvt.is_y_or_n(p_metric_tpl_header_rec.enabled_flag) =
1086: FND_API.G_FALSE THEN
1087: Ams_Utility_Pvt.error_message(
1088: p_message_name => 'AMS_MTH_BAD_ENABLED_FLAG');
1089: x_return_status := FND_API.g_ret_sts_error;

Line 1087: Ams_Utility_Pvt.error_message(

1083:
1084: -- Enter custom code here
1085: IF Ams_Utility_Pvt.is_y_or_n(p_metric_tpl_header_rec.enabled_flag) =
1086: FND_API.G_FALSE THEN
1087: Ams_Utility_Pvt.error_message(
1088: p_message_name => 'AMS_MTH_BAD_ENABLED_FLAG');
1089: x_return_status := FND_API.g_ret_sts_error;
1090: END IF;
1091:

Line 1093: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_LKP'||

1089: x_return_status := FND_API.g_ret_sts_error;
1090: END IF;
1091:
1092: IF AMS_DEBUG_HIGH_ON THEN
1093: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_LKP'||
1094: ': lookup_code = '|| p_metric_tpl_header_rec.ASSOCIATION_TYPE);
1095: END IF;
1096:
1097: IF AMS_UTILITY_PVT.Check_Lookup_Exists('ams_lookups',

Line 1097: IF AMS_UTILITY_PVT.Check_Lookup_Exists('ams_lookups',

1093: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_LKP'||
1094: ': lookup_code = '|| p_metric_tpl_header_rec.ASSOCIATION_TYPE);
1095: END IF;
1096:
1097: IF AMS_UTILITY_PVT.Check_Lookup_Exists('ams_lookups',
1098: 'AMS_METRIC_TPL_ASSOC_TYPES',
1099: p_metric_tpl_header_rec.ASSOCIATION_TYPE) = FND_API.G_FALSE THEN
1100: Ams_Utility_Pvt.error_message(
1101: p_message_name => 'AMS_MTH_INVALID_ASSOC_TYPE');

Line 1100: Ams_Utility_Pvt.error_message(

1096:
1097: IF AMS_UTILITY_PVT.Check_Lookup_Exists('ams_lookups',
1098: 'AMS_METRIC_TPL_ASSOC_TYPES',
1099: p_metric_tpl_header_rec.ASSOCIATION_TYPE) = FND_API.G_FALSE THEN
1100: Ams_Utility_Pvt.error_message(
1101: p_message_name => 'AMS_MTH_INVALID_ASSOC_TYPE');
1102: x_return_status := FND_API.g_ret_sts_error;
1103: END IF;
1104:

Line 1119: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_items: UK');

1115: -- Check Items Uniqueness API calls
1116:
1117: -- Debug Message
1118: IF AMS_DEBUG_HIGH_ON THEN
1119: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_items: UK');
1120: END IF;
1121:
1122: check_met_tpl_hdr_uk_items(
1123: p_metric_tpl_header_rec => p_metric_tpl_header_rec,

Line 1134: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_items: REQ');

1130: -- Check Items Required/NOT NULL API calls
1131:
1132: -- Debug Message
1133: IF AMS_DEBUG_HIGH_ON THEN
1134: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_items: REQ');
1135: END IF;
1136:
1137: CHECK_met_tpl_hdr_REQ_ITEMS(
1138: p_metric_tpl_header_rec => p_metric_tpl_header_rec,

Line 1149: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_items: LKP');

1145: -- Check Items Lookups
1146:
1147: -- Debug Message
1148: IF AMS_DEBUG_HIGH_ON THEN
1149: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_items: LKP');
1150: END IF;
1151:
1152: CHECK_met_tpl_hdr_LKP(
1153: p_metric_tpl_header_rec => p_metric_tpl_header_rec,

Line 1163: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_items: FK');

1159: -- Check Items Foreign Keys API calls
1160:
1161: -- Debug Message
1162: IF AMS_DEBUG_HIGH_ON THEN
1163: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_items: FK');
1164: END IF;
1165:
1166: CHECK_met_tpl_hdr_FK_ITEMS(
1167: p_metric_tpl_header_rec => p_metric_tpl_header_rec,

Line 1175: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_items: DONE');

1171: END IF;
1172:
1173: -- Debug Message
1174: IF AMS_DEBUG_HIGH_ON THEN
1175: Ams_Utility_Pvt.debug_message('PRIVATE API: Check_met_tpl_hdr_items: DONE');
1176: END IF;
1177:
1178: END Check_met_tpl_hdr_Items;
1179:

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

1308: END IF;
1309:
1310: -- Debug Message
1311: IF AMS_DEBUG_HIGH_ON THEN
1312: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': START');
1313: END IF;
1314:
1315: -- Initialize API return status to SUCCESS
1316: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1327: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': Checking header items');

1323:
1324: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1325: -- Debug Message
1326: IF AMS_DEBUG_HIGH_ON THEN
1327: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': Checking header items');
1328: END IF;
1329:
1330: Check_met_tpl_hdr_Items(
1331: p_metric_tpl_header_rec => p_metric_tpl_header_rec,

Line 1347: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': UPDATE MODE');

1343: IF p_validation_mode = JTF_PLSQL_API.g_update THEN
1344:
1345: -- Debug Message
1346: IF AMS_DEBUG_HIGH_ON THEN
1347: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': UPDATE MODE');
1348: END IF;
1349:
1350: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1351: Validate_met_tpl_hdr_Rec(

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

1365: END IF;
1366:
1367: -- Debug Message
1368: IF AMS_DEBUG_HIGH_ON THEN
1369: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': END');
1370: END IF;
1371:
1372: -- Standard call to get message count and if count is 1, get message info.
1373: FND_MSG_PUB.Count_And_Get

Line 1379: WHEN Ams_Utility_Pvt.resource_locked THEN

1375: p_data => x_msg_data
1376: );
1377: EXCEPTION
1378:
1379: WHEN Ams_Utility_Pvt.resource_locked THEN
1380: x_return_status := FND_API.g_ret_sts_error;
1381: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1382:
1383: WHEN FND_API.G_EXC_ERROR THEN

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

1377: EXCEPTION
1378:
1379: WHEN Ams_Utility_Pvt.resource_locked THEN
1380: x_return_status := FND_API.g_ret_sts_error;
1381: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1382:
1383: WHEN FND_API.G_EXC_ERROR THEN
1384: ROLLBACK TO VALIDATE_Metric_Template_;
1385: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1446: Ams_Utility_Pvt.debug_message('PRIVATE API: Validate_met_tpl_hdr_rec');

1442:
1443: -- Debug Message
1444: IF (AMS_DEBUG_HIGH_ON) THEN
1445:
1446: Ams_Utility_Pvt.debug_message('PRIVATE API: Validate_met_tpl_hdr_rec');
1447: END IF;
1448: -- Standard call to get message count and if count is 1, get message info.
1449: FND_MSG_PUB.Count_And_Get
1450: (p_count => x_msg_count,