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

Line 44: AMS_Utility_PVT.debug_message (

40: l_return_status VARCHAR2(1);
41: BEGIN
42: l_api_name := p_api_name;
43: l_log_mesg := p_log_message;
44: AMS_Utility_PVT.debug_message (
45: p_log_level => g_log_level,
46: p_module_name => 'ams.plsql.'||'.'|| g_pkg_name||'.'||l_api_name,
47: p_text => p_log_message
48: );

Line 50: AMS_Utility_PVT.Create_Log (

46: p_module_name => 'ams.plsql.'||'.'|| g_pkg_name||'.'||l_api_name,
47: p_text => p_log_message
48: );
49:
50: AMS_Utility_PVT.Create_Log (
51: x_return_status => l_return_status,
52: p_arc_log_used_by => 'PRETTY_URL',
53: p_log_used_by_id => 1,
54: p_msg_data => 'amsvpurb.pls: '||p_log_message,

Line 125: AMS_Utility_PVT.error_message('AMS_CSCH_NO_MEDIA_TYPE'); -- need to seed message here

121: IF c_is_prettyUrl_supported%NOTFOUND THEN
122: CLOSE c_is_prettyUrl_supported;
123: x_return_status := FND_API.g_ret_sts_error;
124: WRITE_LOG(l_api_name, 'No schedule found with id '||p_current_used_by_id);
125: AMS_Utility_PVT.error_message('AMS_CSCH_NO_MEDIA_TYPE'); -- need to seed message here
126: END IF;
127: CLOSE c_is_prettyUrl_supported;
128:
129: IF l_activity_type_code IS NULL THEN

Line 131: AMS_Utility_PVT.error_message('AMS_CSCH_NO_MEDIA_TYPE');

127: CLOSE c_is_prettyUrl_supported;
128:
129: IF l_activity_type_code IS NULL THEN
130: WRITE_LOG(l_api_name, 'Activity type code not found for schedule '||p_current_used_by_id);
131: AMS_Utility_PVT.error_message('AMS_CSCH_NO_MEDIA_TYPE');
132: x_return_status := FND_API.g_ret_sts_error;
133: RETURN;
134: END IF;
135:

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

219: FND_MSG_PUB.initialize;
220: END IF;
221:
222: -- Debug Message
223: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
224:
225:
226: -- Initialize API return status to SUCCESS
227: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 251: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

247: -- =========================================================================
248:
249: IF FND_GLOBAL.User_Id IS NULL
250: THEN
251: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254:
255: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 258: AMS_UTILITY_PVT.debug_message('Private API: Validate_Pretty_Url');

254:
255: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
256: THEN
257: -- Debug message
258: AMS_UTILITY_PVT.debug_message('Private API: Validate_Pretty_Url');
259:
260: -- Invoke validation procedures
261: Validate_pretty_url(
262: p_api_version_number => 1.0,

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

273: END IF;
274:
275:
276: -- Debug Message
277: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
278:
279: -- Invoke table handler(AMS_PRETTY_URL_PKG.Insert_Row)
280: AMS_PRETTY_URL_PKG.Insert_Row(
281: px_pretty_url_id => l_pretty_url_id,

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

302: END IF;
303:
304:
305: -- Debug Message
306: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
307:
308: -- Standard call to get message count and if count is 1, get message info.
309: FND_MSG_PUB.Count_And_Get
310: (p_count => x_msg_count,

Line 315: WHEN AMS_Utility_PVT.resource_locked THEN

311: p_data => x_msg_data
312: );
313: EXCEPTION
314:
315: WHEN AMS_Utility_PVT.resource_locked THEN
316: x_return_status := FND_API.g_ret_sts_error;
317: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
318:
319: WHEN FND_API.G_EXC_ERROR THEN

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

313: EXCEPTION
314:
315: WHEN AMS_Utility_PVT.resource_locked THEN
316: x_return_status := FND_API.g_ret_sts_error;
317: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
318:
319: WHEN FND_API.G_EXC_ERROR THEN
320: ROLLBACK TO CREATE_Pretty_Url_PVT;
321: x_return_status := FND_API.G_RET_STS_ERROR;

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

399: FND_MSG_PUB.initialize;
400: END IF;
401:
402: -- Debug Message
403: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
404:
405:
406: -- Initialize API return status to SUCCESS
407: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

406: -- Initialize API return status to SUCCESS
407: x_return_status := FND_API.G_RET_STS_SUCCESS;
408:
409: -- Debug Message
410: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
411:
412: /*
413: OPEN c_get_Pretty_Url( l_tar_pretty_url_rec.pretty_url_id);
414:

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

414:
415: FETCH c_get_Pretty_Url INTO l_ref_pretty_url_rec ;
416:
417: If ( c_get_Pretty_Url%NOTFOUND) THEN
418: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
419: p_token_name => 'INFO',
420: p_token_value => 'Pretty_Url') ;
421: RAISE FND_API.G_EXC_ERROR;
422: END IF;

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

420: p_token_value => 'Pretty_Url') ;
421: RAISE FND_API.G_EXC_ERROR;
422: END IF;
423: -- Debug Message
424: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
425: CLOSE c_get_Pretty_Url;
426: */
427:
428:

Line 431: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

427:
428:
429: If (l_tar_pretty_url_rec.object_version_number is NULL or
430: l_tar_pretty_url_rec.object_version_number = FND_API.G_MISS_NUM ) Then
431: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
432: p_token_name => 'COLUMN',
433: p_token_value => 'Last_Update_Date') ;
434: raise FND_API.G_EXC_ERROR;
435: End if;

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

434: raise FND_API.G_EXC_ERROR;
435: End if;
436: -- Check Whether record has been changed by someone else
437: If (l_tar_pretty_url_rec.object_version_number <> l_ref_pretty_url_rec.object_version_number) Then
438: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
439: p_token_name => 'INFO',
440: p_token_value => 'Pretty_Url') ;
441: raise FND_API.G_EXC_ERROR;
442: End if;

Line 446: AMS_UTILITY_PVT.debug_message('Private API: Validate_Pretty_Url');

442: End if;
443: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
444: THEN
445: -- Debug message
446: AMS_UTILITY_PVT.debug_message('Private API: Validate_Pretty_Url');
447:
448: -- Invoke validation procedures
449: Validate_pretty_url(
450: p_api_version_number => 1.0,

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

461: END IF;
462:
463:
464: -- Debug Message
465: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
466:
467: -- Invoke table handler(AMS_PRETTY_URL_PKG.Update_Row)
468: AMS_PRETTY_URL_PKG.Update_Row(
469: p_pretty_url_id => p_pretty_url_rec.pretty_url_id,

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

485: END IF;
486:
487:
488: -- Debug Message
489: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
490:
491: -- Standard call to get message count and if count is 1, get message info.
492: FND_MSG_PUB.Count_And_Get
493: (p_count => x_msg_count,

Line 498: WHEN AMS_Utility_PVT.resource_locked THEN

494: p_data => x_msg_data
495: );
496: EXCEPTION
497:
498: WHEN AMS_Utility_PVT.resource_locked THEN
499: x_return_status := FND_API.g_ret_sts_error;
500: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
501:
502: WHEN FND_API.G_EXC_ERROR THEN

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

496: EXCEPTION
497:
498: WHEN AMS_Utility_PVT.resource_locked THEN
499: x_return_status := FND_API.g_ret_sts_error;
500: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
501:
502: WHEN FND_API.G_EXC_ERROR THEN
503: ROLLBACK TO UPDATE_Pretty_Url_PVT;
504: x_return_status := FND_API.G_RET_STS_ERROR;

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

571: FND_MSG_PUB.initialize;
572: END IF;
573:
574: -- Debug Message
575: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
576:
577:
578: -- Initialize API return status to SUCCESS
579: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

581: --
582: -- Api body
583: --
584: -- Debug Message
585: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
586:
587: -- Invoke table handler(AMS_PRETTY_URL_PKG.Delete_Row)
588: AMS_PRETTY_URL_PKG.Delete_Row(
589: p_PRETTY_URL_ID => p_PRETTY_URL_ID);

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

598: END IF;
599:
600:
601: -- Debug Message
602: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
603:
604: -- Standard call to get message count and if count is 1, get message info.
605: FND_MSG_PUB.Count_And_Get
606: (p_count => x_msg_count,

Line 611: WHEN AMS_Utility_PVT.resource_locked THEN

607: p_data => x_msg_data
608: );
609: EXCEPTION
610:
611: WHEN AMS_Utility_PVT.resource_locked THEN
612: x_return_status := FND_API.g_ret_sts_error;
613: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
614:
615: WHEN FND_API.G_EXC_ERROR THEN

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

609: EXCEPTION
610:
611: WHEN AMS_Utility_PVT.resource_locked THEN
612: x_return_status := FND_API.g_ret_sts_error;
613: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
614:
615: WHEN FND_API.G_EXC_ERROR THEN
616: ROLLBACK TO DELETE_Pretty_Url_PVT;
617: x_return_status := FND_API.G_RET_STS_ERROR;

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

677:
678: BEGIN
679:
680: -- Debug Message
681: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
682:
683: -- Initialize message list if p_init_msg_list is set to TRUE.
684: IF FND_API.to_Boolean( p_init_msg_list )
685: THEN

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

701:
702:
703: ------------------------ lock -------------------------
704:
705: AMS_Utility_PVT.debug_message(l_full_name||': start');
706: OPEN c_Pretty_Url;
707:
708: FETCH c_Pretty_Url INTO l_PRETTY_URL_ID;
709:

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

722: FND_MSG_PUB.count_and_get(
723: p_encoded => FND_API.g_false,
724: p_count => x_msg_count,
725: p_data => x_msg_data);
726: AMS_Utility_PVT.debug_message(l_full_name ||': end');
727: EXCEPTION
728:
729: WHEN AMS_Utility_PVT.resource_locked THEN
730: x_return_status := FND_API.g_ret_sts_error;

Line 729: WHEN AMS_Utility_PVT.resource_locked THEN

725: p_data => x_msg_data);
726: AMS_Utility_PVT.debug_message(l_full_name ||': end');
727: EXCEPTION
728:
729: WHEN AMS_Utility_PVT.resource_locked THEN
730: x_return_status := FND_API.g_ret_sts_error;
731: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
732:
733: WHEN FND_API.G_EXC_ERROR THEN

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

727: EXCEPTION
728:
729: WHEN AMS_Utility_PVT.resource_locked THEN
730: x_return_status := FND_API.g_ret_sts_error;
731: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
732:
733: WHEN FND_API.G_EXC_ERROR THEN
734: ROLLBACK TO LOCK_Pretty_Url_PVT;
735: x_return_status := FND_API.G_RET_STS_ERROR;

Line 779: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

775:
776: BEGIN
777: x_return_status := FND_API.g_ret_sts_success;
778: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
779: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
780: 'AMS_PRETTY_URL',
781: 'PRETTY_URL_ID = ''' || p_pretty_url_rec.PRETTY_URL_ID ||''''
782: );
783: ELSE

Line 784: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

780: 'AMS_PRETTY_URL',
781: 'PRETTY_URL_ID = ''' || p_pretty_url_rec.PRETTY_URL_ID ||''''
782: );
783: ELSE
784: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
785: 'AMS_PRETTY_URL',
786: 'PRETTY_URL_ID = ''' || p_pretty_url_rec.PRETTY_URL_ID ||
787: ''' AND PRETTY_URL_ID <> ' || p_pretty_url_rec.PRETTY_URL_ID
788: );

Line 792: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_PRETTY_URL_ID_DUPLICATE');

788: );
789: END IF;
790:
791: IF l_valid_flag = FND_API.g_false THEN
792: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_PRETTY_URL_ID_DUPLICATE');
793: x_return_status := FND_API.g_ret_sts_error;
794: RETURN;
795: END IF;
796:

Line 812: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_pretty_url_id');

808: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
809:
810:
811: IF p_pretty_url_rec.pretty_url_id = FND_API.g_miss_num OR p_pretty_url_rec.pretty_url_id IS NULL THEN
812: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_pretty_url_id');
813: x_return_status := FND_API.g_ret_sts_error;
814: RETURN;
815: END IF;
816:

Line 819: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_creation_date');

815: END IF;
816:
817:
818: IF p_pretty_url_rec.creation_date = FND_API.g_miss_date OR p_pretty_url_rec.creation_date IS NULL THEN
819: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_creation_date');
820: x_return_status := FND_API.g_ret_sts_error;
821: RETURN;
822: END IF;
823:

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

822: END IF;
823:
824:
825: IF p_pretty_url_rec.created_by = FND_API.g_miss_num OR p_pretty_url_rec.created_by IS NULL THEN
826: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_created_by');
827: x_return_status := FND_API.g_ret_sts_error;
828: RETURN;
829: END IF;
830:

Line 833: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_update_date');

829: END IF;
830:
831:
832: IF p_pretty_url_rec.last_update_date = FND_API.g_miss_date OR p_pretty_url_rec.last_update_date IS NULL THEN
833: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_update_date');
834: x_return_status := FND_API.g_ret_sts_error;
835: RETURN;
836: END IF;
837:

Line 840: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_updated_by');

836: END IF;
837:
838:
839: IF p_pretty_url_rec.last_updated_by = FND_API.g_miss_num OR p_pretty_url_rec.last_updated_by IS NULL THEN
840: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_updated_by');
841: x_return_status := FND_API.g_ret_sts_error;
842: RETURN;
843: END IF;
844:

Line 847: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_landing_page_url');

843: END IF;
844:
845:
846: IF p_pretty_url_rec.landing_page_url = FND_API.g_miss_char OR p_pretty_url_rec.landing_page_url IS NULL THEN
847: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_landing_page_url');
848: x_return_status := FND_API.g_ret_sts_error;
849: RETURN;
850: END IF;
851: ELSE

Line 855: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_pretty_url_id');

851: ELSE
852:
853:
854: IF p_pretty_url_rec.pretty_url_id IS NULL THEN
855: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_pretty_url_id');
856: x_return_status := FND_API.g_ret_sts_error;
857: RETURN;
858: END IF;
859:

Line 862: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_creation_date');

858: END IF;
859:
860:
861: IF p_pretty_url_rec.creation_date IS NULL THEN
862: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_creation_date');
863: x_return_status := FND_API.g_ret_sts_error;
864: RETURN;
865: END IF;
866:

Line 869: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_created_by');

865: END IF;
866:
867:
868: IF p_pretty_url_rec.created_by IS NULL THEN
869: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_created_by');
870: x_return_status := FND_API.g_ret_sts_error;
871: RETURN;
872: END IF;
873:

Line 876: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_update_date');

872: END IF;
873:
874:
875: IF p_pretty_url_rec.last_update_date IS NULL THEN
876: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_update_date');
877: x_return_status := FND_API.g_ret_sts_error;
878: RETURN;
879: END IF;
880:

Line 883: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_updated_by');

879: END IF;
880:
881:
882: IF p_pretty_url_rec.last_updated_by IS NULL THEN
883: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_updated_by');
884: x_return_status := FND_API.g_ret_sts_error;
885: RETURN;
886: END IF;
887:

Line 890: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_landing_page_url');

886: END IF;
887:
888:
889: IF p_pretty_url_rec.landing_page_url IS NULL THEN
890: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_landing_page_url');
891: x_return_status := FND_API.g_ret_sts_error;
892: RETURN;
893: END IF;
894: END IF;

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

1096: END IF;
1097:
1098:
1099: -- Debug Message
1100: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1101:
1102:
1103: -- Initialize API return status to SUCCESS
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1104: x_return_status := FND_API.G_RET_STS_SUCCESS;
1105:
1106:
1107: -- Debug Message
1108: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1109:
1110: -- Standard call to get message count and if count is 1, get message info.
1111: FND_MSG_PUB.Count_And_Get
1112: (p_count => x_msg_count,

Line 1117: WHEN AMS_Utility_PVT.resource_locked THEN

1113: p_data => x_msg_data
1114: );
1115: EXCEPTION
1116:
1117: WHEN AMS_Utility_PVT.resource_locked THEN
1118: x_return_status := FND_API.g_ret_sts_error;
1119: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1120:
1121: WHEN FND_API.G_EXC_ERROR THEN

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

1115: EXCEPTION
1116:
1117: WHEN AMS_Utility_PVT.resource_locked THEN
1118: x_return_status := FND_API.g_ret_sts_error;
1119: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1120:
1121: WHEN FND_API.G_EXC_ERROR THEN
1122: ROLLBACK TO VALIDATE_Pretty_Url_;
1123: x_return_status := FND_API.G_RET_STS_ERROR;

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

1178: -- THEN
1179: -- x_return_status := FND_API.G_RET_STS_ERROR;
1180:
1181: -- Debug Message
1182: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1183: -- Standard call to get message count and if count is 1, get message info.
1184: FND_MSG_PUB.Count_And_Get
1185: (p_count => x_msg_count,
1186: p_data => x_msg_data

Line 1215: --AMS_Utility_PVT.error_message('AMS_pretty_url_NO_pretty_url_id'); -- need to seed message here

1211:
1212:
1213: IF p_pretty_url_rec.pretty_url_id = FND_API.g_miss_num OR p_pretty_url_rec.pretty_url_id IS NULL THEN
1214: WRITE_LOG(l_api_name, 'Pretty Url Id not found');
1215: --AMS_Utility_PVT.error_message('AMS_pretty_url_NO_pretty_url_id'); -- need to seed message here
1216: x_return_status := FND_API.g_ret_sts_error;
1217: FND_MESSAGE.set_name('AMS', 'AMS_pretty_url_NO_pretty_url_id');
1218: FND_MSG_PUB.add;
1219: RETURN;

Line 1224: --AMS_Utility_PVT.Error_Message('AMS_REQ_FIELDS_NOT_MAPPED');

1220: END IF;
1221:
1222: IF p_pretty_url_rec.landing_page_url = FND_API.g_miss_char OR p_pretty_url_rec.landing_page_url IS NULL THEN
1223: WRITE_LOG(l_api_name, 'Landing page Url not found');
1224: --AMS_Utility_PVT.Error_Message('AMS_REQ_FIELDS_NOT_MAPPED');
1225: x_return_status := FND_API.g_ret_sts_error;
1226: FND_MESSAGE.set_name('AMS', 'AMS_PU_REQ_FIELDS_NOT_MAPPED');
1227: FND_MSG_PUB.add;
1228: RETURN;