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

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

82:
83: -- Debug Message
84: IF (AMS_DEBUG_HIGH_ON) THEN
85:
86: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
87: END IF;
88:
89:
90: --sunkumar 30/01/2003

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

91: --check if we are trying to create associations for a seeded metric template
92: /*IF p_met_tpl_assoc_rec.metric_tpl_header_id < 10000 THEN
93: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
94: THEN
95: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED');
96: END IF;
97:
98: RAISE FND_API.G_EXC_ERROR;
99: END IF; */

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

125: -- =========================================================================
126:
127: IF FND_GLOBAL.User_Id IS NULL
128: THEN
129: Ams_Utility_Pvt.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
130: RAISE FND_API.G_EXC_ERROR;
131: END IF;
132:
133: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 138: Ams_Utility_Pvt.debug_message('Private API: Validate_Met_Tpl_Assoc');

134: THEN
135: -- Debug message
136: IF (AMS_DEBUG_HIGH_ON) THEN
137:
138: Ams_Utility_Pvt.debug_message('Private API: Validate_Met_Tpl_Assoc');
139: END IF;
140:
141: -- Invoke validation procedures
142: Validate_met_tpl_assoc(

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

157:
158: -- Debug Message
159: IF (AMS_DEBUG_HIGH_ON) THEN
160:
161: Ams_Utility_Pvt.debug_message( 'Private API: Calling create table handler');
162: END IF;
163:
164: -- Invoke table handler(AMS_MET_TPL_ASSOCS_PKG.Insert_Row)
165: Ams_Met_Tpl_Assocs_Pkg.Insert_Row(

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

194:
195: -- Debug Message
196: IF (AMS_DEBUG_HIGH_ON) THEN
197:
198: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
199: END IF;
200:
201: -- Standard call to get message count and if count is 1, get message info.
202: FND_MSG_PUB.Count_And_Get

Line 208: WHEN Ams_Utility_Pvt.resource_locked THEN

204: p_data => x_msg_data
205: );
206: EXCEPTION
207:
208: WHEN Ams_Utility_Pvt.resource_locked THEN
209: x_return_status := FND_API.g_ret_sts_error;
210: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
211:
212: WHEN FND_API.G_EXC_ERROR THEN

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

206: EXCEPTION
207:
208: WHEN Ams_Utility_Pvt.resource_locked THEN
209: x_return_status := FND_API.g_ret_sts_error;
210: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
211:
212: WHEN FND_API.G_EXC_ERROR THEN
213: ROLLBACK TO CREATE_Met_Tpl_Assoc_PVT;
214: x_return_status := FND_API.G_RET_STS_ERROR;

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

308:
309: -- Debug Message
310: IF (AMS_DEBUG_HIGH_ON) THEN
311:
312: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
313: END IF;
314:
315:
316:

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

319:
320: -- Debug Message
321: IF (AMS_DEBUG_HIGH_ON) THEN
322:
323: Ams_Utility_Pvt.debug_message('Private API: - Open Cursor to Select');
324: END IF;
325:
326: OPEN c_get_Met_Tpl_Assoc( l_tar_met_tpl_assoc_rec.metric_tpl_assoc_id);
327:

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

327:
328: FETCH c_get_Met_Tpl_Assoc INTO l_ref_met_tpl_assoc_rec ;
329:
330: IF ( c_get_Met_Tpl_Assoc%NOTFOUND) THEN
331: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
332: p_token_name => 'INFO',
333: p_token_value => 'Met_Tpl_Assoc') ;
334: RAISE FND_API.G_EXC_ERROR;
335: END IF;

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

335: END IF;
336: -- Debug Message
337: IF (AMS_DEBUG_HIGH_ON) THEN
338:
339: Ams_Utility_Pvt.debug_message('Private API: - Close Cursor');
340: END IF;
341: CLOSE c_get_Met_Tpl_Assoc;
342:
343: IF (l_tar_met_tpl_assoc_rec.object_version_number IS NULL OR

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

341: CLOSE c_get_Met_Tpl_Assoc;
342:
343: IF (l_tar_met_tpl_assoc_rec.object_version_number IS NULL OR
344: l_tar_met_tpl_assoc_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
345: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_VERSION_MISSING',
346: p_token_name => 'COLUMN',
347: p_token_value => 'Last_Update_Date') ;
348: RAISE FND_API.G_EXC_ERROR;
349: END IF;

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

350:
351: -- Check Whether record has been changed by someone else
352: IF (l_tar_met_tpl_assoc_rec.object_version_number <>
353: l_ref_met_tpl_assoc_rec.object_version_number) THEN
354: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_RECORD_CHANGED',
355: p_token_name => 'INFO',
356: p_token_value => 'Met_Tpl_Assoc') ;
357: RAISE FND_API.G_EXC_ERROR;
358: END IF;

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

368: OR (l_tar_met_tpl_assoc_rec.metric_tpl_header_id <>l_ref_met_tpl_assoc_rec.metric_tpl_header_id))
369: AND (l_tar_met_tpl_assoc_rec.enabled_flag=l_ref_met_tpl_assoc_rec.enabled_flag)) THEN
370: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
371: THEN
372: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED_MOD');
373: END IF;
374:
375:
376: RAISE FND_API.G_EXC_ERROR;

Line 386: Ams_Utility_Pvt.debug_message('Private API: Validate_Met_Tpl_Assoc');

382: THEN
383: -- Debug message
384: IF (AMS_DEBUG_HIGH_ON) THEN
385:
386: Ams_Utility_Pvt.debug_message('Private API: Validate_Met_Tpl_Assoc');
387: END IF;
388:
389: -- Invoke validation procedures
390: Validate_met_tpl_assoc(

Line 411: Ams_Utility_Pvt.debug_message('Private API: Calling update table handler');

407:
408: -- Debug Message
409: IF (AMS_DEBUG_HIGH_ON) THEN
410:
411: Ams_Utility_Pvt.debug_message('Private API: Calling update table handler');
412: END IF;
413:
414: -- Invoke table handler(AMS_MET_TPL_ASSOCS_PKG.Update_Row)
415: Ams_Met_Tpl_Assocs_Pkg.Update_Row(

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

436:
437: -- Debug Message
438: IF (AMS_DEBUG_HIGH_ON) THEN
439:
440: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');
441: END IF;
442:
443: -- Standard call to get message count and if count is 1, get message info.
444: FND_MSG_PUB.Count_And_Get

Line 450: WHEN Ams_Utility_Pvt.resource_locked THEN

446: p_data => x_msg_data
447: );
448: EXCEPTION
449:
450: WHEN Ams_Utility_Pvt.resource_locked THEN
451: x_return_status := FND_API.g_ret_sts_error;
452: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
453:
454: WHEN FND_API.G_EXC_ERROR THEN

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

448: EXCEPTION
449:
450: WHEN Ams_Utility_Pvt.resource_locked THEN
451: x_return_status := FND_API.g_ret_sts_error;
452: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
453:
454: WHEN FND_API.G_EXC_ERROR THEN
455: ROLLBACK TO UPDATE_Met_Tpl_Assoc_PVT;
456: x_return_status := FND_API.G_RET_STS_ERROR;

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

525:
526: -- Debug Message
527: IF (AMS_DEBUG_HIGH_ON) THEN
528:
529: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
530: END IF;
531:
532: --sunkumar 30/01/2003
533: --check if we are trying to delete associations for a seeded metric template

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

533: --check if we are trying to delete associations for a seeded metric template
534: IF p_METRIC_TPL_ASSOC_ID < 10000 THEN
535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
536: THEN
537: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED');
538: END IF;
539:
540: RAISE FND_API.G_EXC_ERROR;
541: END IF;

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

550: --
551: -- Debug Message
552: IF (AMS_DEBUG_HIGH_ON) THEN
553:
554: Ams_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');
555: END IF;
556:
557: -- Invoke table handler(AMS_MET_TPL_ASSOCS_PKG.Delete_Row)
558: Ams_Met_Tpl_Assocs_Pkg.Delete_Row(

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

570:
571: -- Debug Message
572: IF (AMS_DEBUG_HIGH_ON) THEN
573:
574: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
575: END IF;
576:
577: -- Standard call to get message count and if count is 1, get message info.
578: FND_MSG_PUB.Count_And_Get

Line 584: WHEN Ams_Utility_Pvt.resource_locked THEN

580: p_data => x_msg_data
581: );
582: EXCEPTION
583:
584: WHEN Ams_Utility_Pvt.resource_locked THEN
585: x_return_status := FND_API.g_ret_sts_error;
586: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
587:
588: WHEN FND_API.G_EXC_ERROR THEN

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

582: EXCEPTION
583:
584: WHEN Ams_Utility_Pvt.resource_locked THEN
585: x_return_status := FND_API.g_ret_sts_error;
586: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
587:
588: WHEN FND_API.G_EXC_ERROR THEN
589: ROLLBACK TO DELETE_Met_Tpl_Assoc_PVT;
590: x_return_status := FND_API.G_RET_STS_ERROR;

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

651:
652: -- Debug Message
653: IF (AMS_DEBUG_HIGH_ON) THEN
654:
655: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
656: END IF;
657:
658: -- Initialize message list if p_init_msg_list is set to TRUE.
659: IF FND_API.to_Boolean( p_init_msg_list )

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

680: IF (AMS_DEBUG_HIGH_ON) THEN
681:
682:
683:
684: Ams_Utility_Pvt.debug_message(l_full_name||': start');
685:
686: END IF;
687: OPEN c_Met_Tpl_Assoc;
688:

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

705: p_count => x_msg_count,
706: p_data => x_msg_data);
707: IF (AMS_DEBUG_HIGH_ON) THEN
708:
709: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
710: END IF;
711: EXCEPTION
712:
713: WHEN Ams_Utility_Pvt.resource_locked THEN

Line 713: WHEN Ams_Utility_Pvt.resource_locked THEN

709: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
710: END IF;
711: EXCEPTION
712:
713: WHEN Ams_Utility_Pvt.resource_locked THEN
714: x_return_status := FND_API.g_ret_sts_error;
715: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
716:
717: WHEN FND_API.G_EXC_ERROR THEN

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

711: EXCEPTION
712:
713: WHEN Ams_Utility_Pvt.resource_locked THEN
714: x_return_status := FND_API.g_ret_sts_error;
715: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
716:
717: WHEN FND_API.G_EXC_ERROR THEN
718: ROLLBACK TO LOCK_Met_Tpl_Assoc_PVT;
719: x_return_status := FND_API.G_RET_STS_ERROR;

Line 771: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(

767:
768: BEGIN
769: x_return_status := FND_API.g_ret_sts_success;
770: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
771: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
772: 'AMS_MET_TPL_ASSOCS',
773: 'METRIC_TPL_ASSOC_ID = ' || p_met_tpl_assoc_rec.METRIC_TPL_ASSOC_ID
774: );
775: -- ELSE

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

772: 'AMS_MET_TPL_ASSOCS',
773: 'METRIC_TPL_ASSOC_ID = ' || p_met_tpl_assoc_rec.METRIC_TPL_ASSOC_ID
774: );
775: -- ELSE
776: -- l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
777: -- 'AMS_MET_TPL_ASSOCS',
778: -- 'METRIC_TPL_ASSOC_ID = ' || p_met_tpl_assoc_rec.METRIC_TPL_ASSOC_ID ||
779: -- ' AND METRIC_TPL_ASSOC_ID <> ' || p_met_tpl_assoc_rec.METRIC_TPL_ASSOC_ID
780: -- );

Line 784: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METRIC_TPL_ASSOC_ID_DUPLICATE');

780: -- );
781: END IF;
782:
783: IF l_valid_flag = FND_API.g_false THEN
784: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METRIC_TPL_ASSOC_ID_DUPLICATE');
785: x_return_status := FND_API.g_ret_sts_error;
786: RETURN;
787: END IF;
788:

Line 797: Ams_Utility_Pvt.Error_Message(p_message_name =>

793: p_met_tpl_assoc_rec.used_by_code);
794: FETCH c_dup_assoc INTO l_valid_flag;
795: CLOSE c_dup_assoc;
796: IF l_valid_flag = FND_API.g_false THEN
797: Ams_Utility_Pvt.Error_Message(p_message_name =>
798: 'AMS_METRIC_TPL_ASSOC_VALUE_DUP');
799: x_return_status := FND_API.g_ret_sts_error;
800: RETURN;
801: END IF;

Line 876: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTA_NO_MTA_ID');

872: END IF;
873: ELSE
874:
875: IF p_met_tpl_assoc_rec.metric_tpl_assoc_id IS NULL THEN
876: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTA_NO_MTA_ID');
877: x_return_status := FND_API.g_ret_sts_error;
878: RETURN;
879: END IF;
880:

Line 882: -- Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_met_tpl_assoc_NO_last_update_date');

878: RETURN;
879: END IF;
880:
881: -- IF p_met_tpl_assoc_rec.last_update_date IS NULL THEN
882: -- Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_met_tpl_assoc_NO_last_update_date');
883: -- x_return_status := FND_API.g_ret_sts_error;
884: -- RETURN;
885: -- END IF;
886: --

Line 888: -- Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_met_tpl_assoc_NO_last_updated_by');

884: -- RETURN;
885: -- END IF;
886: --
887: -- IF p_met_tpl_assoc_rec.last_updated_by IS NULL THEN
888: -- Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_met_tpl_assoc_NO_last_updated_by');
889: -- x_return_status := FND_API.g_ret_sts_error;
890: -- RETURN;
891: -- END IF;
892: --

Line 894: -- Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_met_tpl_assoc_NO_creation_date');

890: -- RETURN;
891: -- END IF;
892: --
893: -- IF p_met_tpl_assoc_rec.creation_date IS NULL THEN
894: -- Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_met_tpl_assoc_NO_creation_date');
895: -- x_return_status := FND_API.g_ret_sts_error;
896: -- RETURN;
897: -- END IF;
898: --

Line 900: -- Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_met_tpl_assoc_NO_created_by');

896: -- RETURN;
897: -- END IF;
898: --
899: -- IF p_met_tpl_assoc_rec.created_by IS NULL THEN
900: -- Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_met_tpl_assoc_NO_created_by');
901: -- x_return_status := FND_API.g_ret_sts_error;
902: -- RETURN;
903: -- END IF;
904:

Line 906: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTA_NO_MTH_ID');

902: -- RETURN;
903: -- END IF;
904:
905: IF p_met_tpl_assoc_rec.metric_tpl_header_id IS NULL THEN
906: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTA_NO_MTH_ID');
907: x_return_status := FND_API.g_ret_sts_error;
908: RETURN;
909: END IF;
910:

Line 912: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTA_NO_ASSOCIATION_TYPE');

908: RETURN;
909: END IF;
910:
911: IF p_met_tpl_assoc_rec.association_type IS NULL THEN
912: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTA_NO_ASSOCIATION_TYPE');
913: x_return_status := FND_API.g_ret_sts_error;
914: RETURN;
915: END IF;
916:

Line 918: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTA_NO_ENABLED_FLAG');

914: RETURN;
915: END IF;
916:
917: IF p_met_tpl_assoc_rec.enabled_flag IS NULL THEN
918: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTA_NO_ENABLED_FLAG');
919: x_return_status := FND_API.g_ret_sts_error;
920: RETURN;
921: END IF;
922: END IF;

Line 954: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_HEADER_ID');

950: -- Validate metric_tpl_header_id exists.
951: OPEN c_check_header_id(p_met_tpl_assoc_rec.metric_tpl_header_id);
952: FETCH c_check_header_id INTO l_dummy;
953: IF c_check_header_id%NOTFOUND THEN
954: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_HEADER_ID');
955: x_return_status := FND_API.g_ret_sts_error;
956: END IF;
957: CLOSE c_check_header_id;
958:

Line 963: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_CUSTOM_SETUP');

959: IF p_met_tpl_assoc_rec.association_type = 'CUSTOM_SETUP' THEN
960: OPEN c_check_custom_setup(p_met_tpl_assoc_rec.used_by_id);
961: FETCH c_check_custom_setup INTO l_dummy;
962: IF c_check_custom_setup%NOTFOUND THEN
963: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_CUSTOM_SETUP');
964: x_return_status := FND_API.g_ret_sts_error;
965: END IF;
966: CLOSE c_check_custom_setup;
967: IF p_met_tpl_assoc_rec.used_by_code IS NOT NULL THEN

Line 968: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_USED_BY');

964: x_return_status := FND_API.g_ret_sts_error;
965: END IF;
966: CLOSE c_check_custom_setup;
967: IF p_met_tpl_assoc_rec.used_by_code IS NOT NULL THEN
968: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_USED_BY');
969: x_return_status := FND_API.g_ret_sts_error;
970: END IF;
971: ELSIF p_met_tpl_assoc_rec.association_type = 'OBJECT_TYPE' THEN
972: OPEN c_check_object_type(p_met_tpl_assoc_rec.used_by_code);

Line 975: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_OBJECT_TYPE');

971: ELSIF p_met_tpl_assoc_rec.association_type = 'OBJECT_TYPE' THEN
972: OPEN c_check_object_type(p_met_tpl_assoc_rec.used_by_code);
973: FETCH c_check_object_type INTO l_dummy;
974: IF c_check_object_type%NOTFOUND THEN
975: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_OBJECT_TYPE');
976: x_return_status := FND_API.g_ret_sts_error;
977: END IF;
978: CLOSE c_check_object_type;
979: IF p_met_tpl_assoc_rec.used_by_id IS NOT NULL THEN

Line 980: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_USED_BY');

976: x_return_status := FND_API.g_ret_sts_error;
977: END IF;
978: CLOSE c_check_object_type;
979: IF p_met_tpl_assoc_rec.used_by_id IS NOT NULL THEN
980: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_USED_BY');
981: x_return_status := FND_API.g_ret_sts_error;
982: END IF;
983: END IF;
984:

Line 998: IF Ams_Utility_Pvt.check_lookup_exists(p_lookup_type => 'AMS_METRIC_TPL_ASSOC_TYPES',

994:
995: -- Enter custom code here
996:
997: -- Validate association types.
998: IF Ams_Utility_Pvt.check_lookup_exists(p_lookup_type => 'AMS_METRIC_TPL_ASSOC_TYPES',
999: p_lookup_code => p_met_tpl_assoc_rec.association_type) = FND_API.G_FALSE THEN
1000: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_ASSOC_TYPE');
1001: x_return_status := FND_API.g_ret_sts_error;
1002: END IF;

Line 1000: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_ASSOC_TYPE');

996:
997: -- Validate association types.
998: IF Ams_Utility_Pvt.check_lookup_exists(p_lookup_type => 'AMS_METRIC_TPL_ASSOC_TYPES',
999: p_lookup_code => p_met_tpl_assoc_rec.association_type) = FND_API.G_FALSE THEN
1000: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_ASSOC_TYPE');
1001: x_return_status := FND_API.g_ret_sts_error;
1002: END IF;
1003:
1004: IF Ams_Utility_Pvt.is_y_or_n(p_met_tpl_assoc_rec.enabled_flag) = FND_API.G_FALSE THEN

Line 1004: IF Ams_Utility_Pvt.is_y_or_n(p_met_tpl_assoc_rec.enabled_flag) = FND_API.G_FALSE THEN

1000: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_ASSOC_TYPE');
1001: x_return_status := FND_API.g_ret_sts_error;
1002: END IF;
1003:
1004: IF Ams_Utility_Pvt.is_y_or_n(p_met_tpl_assoc_rec.enabled_flag) = FND_API.G_FALSE THEN
1005: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_ENABLED_FLAG');
1006: x_return_status := FND_API.g_ret_sts_error;
1007: END IF;
1008:

Line 1005: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_ENABLED_FLAG');

1001: x_return_status := FND_API.g_ret_sts_error;
1002: END IF;
1003:
1004: IF Ams_Utility_Pvt.is_y_or_n(p_met_tpl_assoc_rec.enabled_flag) = FND_API.G_FALSE THEN
1005: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTA_BAD_ENABLED_FLAG');
1006: x_return_status := FND_API.g_ret_sts_error;
1007: END IF;
1008:
1009: END check_met_tpl_assoc_lkp_items;

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

1211:
1212: -- Debug Message
1213: IF (AMS_DEBUG_HIGH_ON) THEN
1214:
1215: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'START');
1216: END IF;
1217:
1218: -- Initialize API return status to SUCCESS
1219: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1220:
1221: -- Debug Message
1222: IF (AMS_DEBUG_HIGH_ON) THEN
1223:
1224: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || 'END');
1225: END IF;
1226:
1227: -- Standard call to get message count and if count is 1, get message info.
1228: FND_MSG_PUB.Count_And_Get

Line 1234: WHEN Ams_Utility_Pvt.resource_locked THEN

1230: p_data => x_msg_data
1231: );
1232: EXCEPTION
1233:
1234: WHEN Ams_Utility_Pvt.resource_locked THEN
1235: x_return_status := FND_API.g_ret_sts_error;
1236: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1237:
1238: WHEN FND_API.G_EXC_ERROR THEN

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

1232: EXCEPTION
1233:
1234: WHEN Ams_Utility_Pvt.resource_locked THEN
1235: x_return_status := FND_API.g_ret_sts_error;
1236: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1237:
1238: WHEN FND_API.G_EXC_ERROR THEN
1239: ROLLBACK TO VALIDATE_Met_Tpl_Assoc_;
1240: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1301: Ams_Utility_Pvt.debug_message('PRIVATE API: Validate_met_tpl_assoc_rec');

1297:
1298: -- Debug Message
1299: IF (AMS_DEBUG_HIGH_ON) THEN
1300:
1301: Ams_Utility_Pvt.debug_message('PRIVATE API: Validate_met_tpl_assoc_rec');
1302: END IF;
1303: -- Standard call to get message count and if count is 1, get message info.
1304: FND_MSG_PUB.Count_And_Get
1305: (p_count => x_msg_count,