DBA Data[Home] [Help]

APPS.AMS_ADHOC_PARAM_PVT dependencies on AMS_UTILITY_PVT

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

72: FND_MSG_PUB.initialize;
73: END IF;
74:
75: -- Debug Message
76: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
77:
78:
79: -- Initialize API return status to SUCCESS
80: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

100: -- =========================================================================
101:
102: IF FND_GLOBAL.User_Id IS NULL
103: THEN
104: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107:
108: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 111: AMS_UTILITY_PVT.debug_message('Private API: Validate_Adhoc_Param');

107:
108: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
109: THEN
110: -- Debug message
111: AMS_UTILITY_PVT.debug_message('Private API: Validate_Adhoc_Param');
112:
113: -- Invoke validation procedures
114: Validate_adhoc_param(
115: p_api_version_number => 1.0,

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

126: END IF;
127:
128:
129: -- Debug Message
130: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
131:
132: -- Invoke table handler(AMS_CTD_ADHOC_PARAM_VALUES_PKG.Insert_Row)
133: AMS_CTD_ADHOC_PARAM_VALUES_PKG.Insert_Row(
134: px_adhoc_param_id => l_adhoc_param_id,

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

156: END IF;
157:
158:
159: -- Debug Message
160: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
161:
162: -- Standard call to get message count and if count is 1, get message info.
163: FND_MSG_PUB.Count_And_Get
164: (p_count => x_msg_count,

Line 169: WHEN AMS_Utility_PVT.resource_locked THEN

165: p_data => x_msg_data
166: );
167: EXCEPTION
168:
169: WHEN AMS_Utility_PVT.resource_locked THEN
170: x_return_status := FND_API.g_ret_sts_error;
171: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
172:
173: WHEN FND_API.G_EXC_ERROR THEN

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

167: EXCEPTION
168:
169: WHEN AMS_Utility_PVT.resource_locked THEN
170: x_return_status := FND_API.g_ret_sts_error;
171: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
172:
173: WHEN FND_API.G_EXC_ERROR THEN
174: ROLLBACK TO CREATE_Adhoc_Param_PVT;
175: x_return_status := FND_API.G_RET_STS_ERROR;

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

253: FND_MSG_PUB.initialize;
254: END IF;
255:
256: -- Debug Message
257: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
258:
259:
260: -- Initialize API return status to SUCCESS
261: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

260: -- Initialize API return status to SUCCESS
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262:
263: -- Debug Message
264: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
265:
266: /*
267: OPEN c_get_Adhoc_Param( l_tar_adhoc_param_rec.adhoc_param_id);
268:

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

268:
269: FETCH c_get_Adhoc_Param INTO l_ref_adhoc_param_rec ;
270:
271: If ( c_get_Adhoc_Param%NOTFOUND) THEN
272: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
273: p_token_name => 'INFO',
274: p_token_value => 'Adhoc_Param') ;
275: RAISE FND_API.G_EXC_ERROR;
276: END IF;

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

274: p_token_value => 'Adhoc_Param') ;
275: RAISE FND_API.G_EXC_ERROR;
276: END IF;
277: -- Debug Message
278: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
279: CLOSE c_get_Adhoc_Param;
280: */
281:
282:

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

281:
282:
283: If (l_tar_adhoc_param_rec.object_version_number is NULL or
284: l_tar_adhoc_param_rec.object_version_number = FND_API.G_MISS_NUM ) Then
285: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
286: p_token_name => 'COLUMN',
287: p_token_value => 'Last_Update_Date') ;
288: raise FND_API.G_EXC_ERROR;
289: End if;

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

288: raise FND_API.G_EXC_ERROR;
289: End if;
290: -- Check Whether record has been changed by someone else
291: If (l_tar_adhoc_param_rec.object_version_number <> l_ref_adhoc_param_rec.object_version_number) Then
292: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
293: p_token_name => 'INFO',
294: p_token_value => 'Adhoc_Param') ;
295: raise FND_API.G_EXC_ERROR;
296: End if;

Line 300: AMS_UTILITY_PVT.debug_message('Private API: Validate_Adhoc_Param');

296: End if;
297: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
298: THEN
299: -- Debug message
300: AMS_UTILITY_PVT.debug_message('Private API: Validate_Adhoc_Param');
301:
302: -- Invoke validation procedures
303: Validate_adhoc_param(
304: p_api_version_number => 1.0,

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

315: END IF;
316:
317:
318: -- Debug Message
319: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
320:
321: -- Invoke table handler(AMS_CTD_ADHOC_PARAM_VALUES_PKG.Update_Row)
322: AMS_CTD_ADHOC_PARAM_VALUES_PKG.Update_Row(
323: p_adhoc_param_id => p_adhoc_param_rec.adhoc_param_id,

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

342: END IF;
343:
344:
345: -- Debug Message
346: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
347:
348: -- Standard call to get message count and if count is 1, get message info.
349: FND_MSG_PUB.Count_And_Get
350: (p_count => x_msg_count,

Line 355: WHEN AMS_Utility_PVT.resource_locked THEN

351: p_data => x_msg_data
352: );
353: EXCEPTION
354:
355: WHEN AMS_Utility_PVT.resource_locked THEN
356: x_return_status := FND_API.g_ret_sts_error;
357: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
358:
359: WHEN FND_API.G_EXC_ERROR THEN

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

353: EXCEPTION
354:
355: WHEN AMS_Utility_PVT.resource_locked THEN
356: x_return_status := FND_API.g_ret_sts_error;
357: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
358:
359: WHEN FND_API.G_EXC_ERROR THEN
360: ROLLBACK TO UPDATE_Adhoc_Param_PVT;
361: x_return_status := FND_API.G_RET_STS_ERROR;

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

428: FND_MSG_PUB.initialize;
429: END IF;
430:
431: -- Debug Message
432: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
433:
434:
435: -- Initialize API return status to SUCCESS
436: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

438: --
439: -- Api body
440: --
441: -- Debug Message
442: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
443:
444: -- Invoke table handler(AMS_CTD_ADHOC_PARAM_VALUES_PKG.Delete_Row)
445: AMS_CTD_ADHOC_PARAM_VALUES_PKG.Delete_Row(
446: p_ADHOC_PARAM_ID => p_ADHOC_PARAM_ID);

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

455: END IF;
456:
457:
458: -- Debug Message
459: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
460:
461: -- Standard call to get message count and if count is 1, get message info.
462: FND_MSG_PUB.Count_And_Get
463: (p_count => x_msg_count,

Line 468: WHEN AMS_Utility_PVT.resource_locked THEN

464: p_data => x_msg_data
465: );
466: EXCEPTION
467:
468: WHEN AMS_Utility_PVT.resource_locked THEN
469: x_return_status := FND_API.g_ret_sts_error;
470: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
471:
472: WHEN FND_API.G_EXC_ERROR THEN

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

466: EXCEPTION
467:
468: WHEN AMS_Utility_PVT.resource_locked THEN
469: x_return_status := FND_API.g_ret_sts_error;
470: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
471:
472: WHEN FND_API.G_EXC_ERROR THEN
473: ROLLBACK TO DELETE_Adhoc_Param_PVT;
474: x_return_status := FND_API.G_RET_STS_ERROR;

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

534:
535: BEGIN
536:
537: -- Debug Message
538: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
539:
540: -- Initialize message list if p_init_msg_list is set to TRUE.
541: IF FND_API.to_Boolean( p_init_msg_list )
542: THEN

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

558:
559:
560: ------------------------ lock -------------------------
561:
562: AMS_Utility_PVT.debug_message(l_full_name||': start');
563: OPEN c_Adhoc_Param;
564:
565: FETCH c_Adhoc_Param INTO l_ADHOC_PARAM_ID;
566:

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

579: FND_MSG_PUB.count_and_get(
580: p_encoded => FND_API.g_false,
581: p_count => x_msg_count,
582: p_data => x_msg_data);
583: AMS_Utility_PVT.debug_message(l_full_name ||': end');
584: EXCEPTION
585:
586: WHEN AMS_Utility_PVT.resource_locked THEN
587: x_return_status := FND_API.g_ret_sts_error;

Line 586: WHEN AMS_Utility_PVT.resource_locked THEN

582: p_data => x_msg_data);
583: AMS_Utility_PVT.debug_message(l_full_name ||': end');
584: EXCEPTION
585:
586: WHEN AMS_Utility_PVT.resource_locked THEN
587: x_return_status := FND_API.g_ret_sts_error;
588: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
589:
590: WHEN FND_API.G_EXC_ERROR THEN

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

584: EXCEPTION
585:
586: WHEN AMS_Utility_PVT.resource_locked THEN
587: x_return_status := FND_API.g_ret_sts_error;
588: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
589:
590: WHEN FND_API.G_EXC_ERROR THEN
591: ROLLBACK TO LOCK_Adhoc_Param_PVT;
592: x_return_status := FND_API.G_RET_STS_ERROR;

Line 636: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

632:
633: BEGIN
634: x_return_status := FND_API.g_ret_sts_success;
635: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
636: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
637: 'AMS_CTD_ADHOC_PARAM_VALUES',
638: 'ADHOC_PARAM_ID = ''' || p_adhoc_param_rec.ADHOC_PARAM_ID ||''''
639: );
640: ELSE

Line 641: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

637: 'AMS_CTD_ADHOC_PARAM_VALUES',
638: 'ADHOC_PARAM_ID = ''' || p_adhoc_param_rec.ADHOC_PARAM_ID ||''''
639: );
640: ELSE
641: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
642: 'AMS_CTD_ADHOC_PARAM_VALUES',
643: 'ADHOC_PARAM_ID = ''' || p_adhoc_param_rec.ADHOC_PARAM_ID ||
644: ''' AND ADHOC_PARAM_ID <> ' || p_adhoc_param_rec.ADHOC_PARAM_ID
645: );

Line 649: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ADHOC_PARAM_ID_DUPLICATE');

645: );
646: END IF;
647:
648: IF l_valid_flag = FND_API.g_false THEN
649: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ADHOC_PARAM_ID_DUPLICATE');
650: x_return_status := FND_API.g_ret_sts_error;
651: RETURN;
652: END IF;
653:

Line 669: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_adhoc_param_id');

665: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
666:
667:
668: IF p_adhoc_param_rec.adhoc_param_id = FND_API.g_miss_num OR p_adhoc_param_rec.adhoc_param_id IS NULL THEN
669: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_adhoc_param_id');
670: x_return_status := FND_API.g_ret_sts_error;
671: RETURN;
672: END IF;
673:

Line 676: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_adhoc_param_code');

672: END IF;
673:
674:
675: IF p_adhoc_param_rec.adhoc_param_code = FND_API.g_miss_char OR p_adhoc_param_rec.adhoc_param_code IS NULL THEN
676: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_adhoc_param_code');
677: x_return_status := FND_API.g_ret_sts_error;
678: RETURN;
679: END IF;
680:

Line 683: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_adhoc_param_value');

679: END IF;
680:
681:
682: IF p_adhoc_param_rec.adhoc_param_value = FND_API.g_miss_char OR p_adhoc_param_rec.adhoc_param_value IS NULL THEN
683: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_adhoc_param_value');
684: x_return_status := FND_API.g_ret_sts_error;
685: RETURN;
686: END IF;
687:

Line 690: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_ctd_id');

686: END IF;
687:
688:
689: IF p_adhoc_param_rec.ctd_id = FND_API.g_miss_num OR p_adhoc_param_rec.ctd_id IS NULL THEN
690: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_ctd_id');
691: x_return_status := FND_API.g_ret_sts_error;
692: RETURN;
693: END IF;
694:

Line 697: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_last_update_date');

693: END IF;
694:
695:
696: IF p_adhoc_param_rec.last_update_date = FND_API.g_miss_date OR p_adhoc_param_rec.last_update_date IS NULL THEN
697: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_last_update_date');
698: x_return_status := FND_API.g_ret_sts_error;
699: RETURN;
700: END IF;
701:

Line 704: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_last_updated_by');

700: END IF;
701:
702:
703: IF p_adhoc_param_rec.last_updated_by = FND_API.g_miss_num OR p_adhoc_param_rec.last_updated_by IS NULL THEN
704: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_last_updated_by');
705: x_return_status := FND_API.g_ret_sts_error;
706: RETURN;
707: END IF;
708:

Line 711: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_creation_date');

707: END IF;
708:
709:
710: IF p_adhoc_param_rec.creation_date = FND_API.g_miss_date OR p_adhoc_param_rec.creation_date IS NULL THEN
711: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_creation_date');
712: x_return_status := FND_API.g_ret_sts_error;
713: RETURN;
714: END IF;
715:

Line 718: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_created_by');

714: END IF;
715:
716:
717: IF p_adhoc_param_rec.created_by = FND_API.g_miss_num OR p_adhoc_param_rec.created_by IS NULL THEN
718: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_created_by');
719: x_return_status := FND_API.g_ret_sts_error;
720: RETURN;
721: END IF;
722: ELSE

Line 726: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_adhoc_param_id');

722: ELSE
723:
724:
725: IF p_adhoc_param_rec.adhoc_param_id IS NULL THEN
726: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_adhoc_param_id');
727: x_return_status := FND_API.g_ret_sts_error;
728: RETURN;
729: END IF;
730:

Line 733: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_adhoc_param_code');

729: END IF;
730:
731:
732: IF p_adhoc_param_rec.adhoc_param_code IS NULL THEN
733: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_adhoc_param_code');
734: x_return_status := FND_API.g_ret_sts_error;
735: RETURN;
736: END IF;
737:

Line 740: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_adhoc_param_value');

736: END IF;
737:
738:
739: IF p_adhoc_param_rec.adhoc_param_value IS NULL THEN
740: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_adhoc_param_value');
741: x_return_status := FND_API.g_ret_sts_error;
742: RETURN;
743: END IF;
744:

Line 747: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_ctd_id');

743: END IF;
744:
745:
746: IF p_adhoc_param_rec.ctd_id IS NULL THEN
747: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_ctd_id');
748: x_return_status := FND_API.g_ret_sts_error;
749: RETURN;
750: END IF;
751:

Line 754: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_last_update_date');

750: END IF;
751:
752:
753: IF p_adhoc_param_rec.last_update_date IS NULL THEN
754: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_last_update_date');
755: x_return_status := FND_API.g_ret_sts_error;
756: RETURN;
757: END IF;
758:

Line 761: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_last_updated_by');

757: END IF;
758:
759:
760: IF p_adhoc_param_rec.last_updated_by IS NULL THEN
761: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_last_updated_by');
762: x_return_status := FND_API.g_ret_sts_error;
763: RETURN;
764: END IF;
765:

Line 768: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_creation_date');

764: END IF;
765:
766:
767: IF p_adhoc_param_rec.creation_date IS NULL THEN
768: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_creation_date');
769: x_return_status := FND_API.g_ret_sts_error;
770: RETURN;
771: END IF;
772:

Line 775: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_created_by');

771: END IF;
772:
773:
774: IF p_adhoc_param_rec.created_by IS NULL THEN
775: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_adhoc_param_NO_created_by');
776: x_return_status := FND_API.g_ret_sts_error;
777: RETURN;
778: END IF;
779: END IF;

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

995: END IF;
996:
997:
998: -- Debug Message
999: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1000:
1001:
1002: -- Initialize API return status to SUCCESS
1003: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1003: x_return_status := FND_API.G_RET_STS_SUCCESS;
1004:
1005:
1006: -- Debug Message
1007: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1008:
1009: -- Standard call to get message count and if count is 1, get message info.
1010: FND_MSG_PUB.Count_And_Get
1011: (p_count => x_msg_count,

Line 1016: WHEN AMS_Utility_PVT.resource_locked THEN

1012: p_data => x_msg_data
1013: );
1014: EXCEPTION
1015:
1016: WHEN AMS_Utility_PVT.resource_locked THEN
1017: x_return_status := FND_API.g_ret_sts_error;
1018: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1019:
1020: WHEN FND_API.G_EXC_ERROR THEN

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

1014: EXCEPTION
1015:
1016: WHEN AMS_Utility_PVT.resource_locked THEN
1017: x_return_status := FND_API.g_ret_sts_error;
1018: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1019:
1020: WHEN FND_API.G_EXC_ERROR THEN
1021: ROLLBACK TO VALIDATE_Adhoc_Param_;
1022: x_return_status := FND_API.G_RET_STS_ERROR;

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

1077: -- THEN
1078: -- x_return_status := FND_API.G_RET_STS_ERROR;
1079:
1080: -- Debug Message
1081: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1082: -- Standard call to get message count and if count is 1, get message info.
1083: FND_MSG_PUB.Count_And_Get
1084: (p_count => x_msg_count,
1085: p_data => x_msg_data