DBA Data[Home] [Help]

APPS.AMS_ST_ASSOC_PVT dependencies on AMS_UTILITY_PVT

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

74:
75: -- Debug Message
76: IF (AMS_DEBUG_HIGH_ON) THEN
77:
78: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
79: END IF;
80:
81:
82: -- Initialize API return status to SUCCESS

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

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

Line 116: AMS_UTILITY_PVT.debug_message('Private API: Validate_St_Assoc');

112: THEN
113: -- Debug message
114: IF (AMS_DEBUG_HIGH_ON) THEN
115:
116: AMS_UTILITY_PVT.debug_message('Private API: Validate_St_Assoc');
117: END IF;
118:
119: -- Invoke validation procedures
120: Validate_st_assoc(

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

133:
134: -- Debug Message
135: IF (AMS_DEBUG_HIGH_ON) THEN
136:
137: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
138: END IF;
139:
140: -- Invoke table handler(AMS_LIST_SRC_TYPE_ASSOCS_PKG.Insert_Row)
141: AMS_LIST_SRC_TYPE_ASSOCS_PKG.Insert_Row(

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

170:
171: -- Debug Message
172: IF (AMS_DEBUG_HIGH_ON) THEN
173:
174: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
175: END IF;
176:
177: -- Standard call to get message count and if count is 1, get message info.
178: FND_MSG_PUB.Count_And_Get

Line 185: WHEN AMS_Utility_PVT.resource_locked THEN

181: );
182:
183: EXCEPTION
184:
185: WHEN AMS_Utility_PVT.resource_locked THEN
186: x_return_status := FND_API.g_ret_sts_error;
187: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
188:
189: WHEN FND_API.G_EXC_ERROR THEN

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

183: EXCEPTION
184:
185: WHEN AMS_Utility_PVT.resource_locked THEN
186: x_return_status := FND_API.g_ret_sts_error;
187: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
188:
189: WHEN FND_API.G_EXC_ERROR THEN
190: ROLLBACK TO CREATE_St_Assoc_PVT;
191: x_return_status := FND_API.G_RET_STS_ERROR;

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

274:
275: -- Debug Message
276: IF (AMS_DEBUG_HIGH_ON) THEN
277:
278: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
279: END IF;
280:
281:
282: -- Initialize API return status to SUCCESS

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

284:
285: -- Debug Message
286: IF (AMS_DEBUG_HIGH_ON) THEN
287:
288: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
289: END IF;
290:
291: /*
292: OPEN c_get_St_Assoc( l_tar_st_assoc_rec.list_source_type_assoc_id);

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

293:
294: FETCH c_get_St_Assoc INTO l_ref_st_assoc_rec ;
295:
296: If ( c_get_St_Assoc%NOTFOUND) THEN
297: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
298: p_token_name => 'INFO',
299: p_token_value => 'St_Assoc') ;
300: RAISE FND_API.G_EXC_ERROR;
301: END IF;

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

301: END IF;
302: -- Debug Message
303: IF (AMS_DEBUG_HIGH_ON) THEN
304:
305: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
306: END IF;
307: CLOSE c_get_St_Assoc;
308: */
309:

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

309:
310:
311: If (l_tar_st_assoc_rec.object_version_number is NULL or
312: l_tar_st_assoc_rec.object_version_number = FND_API.G_MISS_NUM ) Then
313: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
314: p_token_name => 'COLUMN',
315: p_token_value => 'Last_Update_Date') ;
316: raise FND_API.G_EXC_ERROR;
317: End if;

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

317: End if;
318:
319: -- Check Whether record has been changed by someone else
320: If (l_tar_st_assoc_rec.object_version_number <> l_ref_st_assoc_rec.object_version_number) Then
321: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
322: p_token_name => 'INFO',
323: p_token_value => 'St_Assoc') ;
324: raise FND_API.G_EXC_ERROR;
325: End if;

Line 332: AMS_UTILITY_PVT.debug_message('Private API: Validate_St_Assoc');

328: THEN
329: -- Debug message
330: IF (AMS_DEBUG_HIGH_ON) THEN
331:
332: AMS_UTILITY_PVT.debug_message('Private API: Validate_St_Assoc');
333: END IF;
334:
335: -- Invoke validation procedures
336: Validate_st_assoc(

Line 352: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;

348: END IF;
349:
350:
351: -- Debug Message
352: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');END IF;
353: --this above statement cause problem of char to number conversion error
354:
355: -- Invoke table handler(AMS_LIST_SRC_TYPE_ASSOCS_PKG.Update_Row)
356: AMS_LIST_SRC_TYPE_ASSOCS_PKG.Update_Row(

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

383:
384: -- Debug Message
385: IF (AMS_DEBUG_HIGH_ON) THEN
386:
387: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
388: END IF;
389:
390: -- Standard call to get message count and if count is 1, get message info.
391: FND_MSG_PUB.Count_And_Get

Line 397: WHEN AMS_Utility_PVT.resource_locked THEN

393: p_data => x_msg_data
394: );
395: EXCEPTION
396:
397: WHEN AMS_Utility_PVT.resource_locked THEN
398: x_return_status := FND_API.g_ret_sts_error;
399: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
400:
401: WHEN FND_API.G_EXC_ERROR THEN

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

395: EXCEPTION
396:
397: WHEN AMS_Utility_PVT.resource_locked THEN
398: x_return_status := FND_API.g_ret_sts_error;
399: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
400:
401: WHEN FND_API.G_EXC_ERROR THEN
402: ROLLBACK TO UPDATE_St_Assoc_PVT;
403: x_return_status := FND_API.G_RET_STS_ERROR;

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

472:
473: -- Debug Message
474: IF (AMS_DEBUG_HIGH_ON) THEN
475:
476: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
477: END IF;
478:
479:
480: -- Initialize API return status to SUCCESS

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

485: --
486: -- Debug Message
487: IF (AMS_DEBUG_HIGH_ON) THEN
488:
489: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
490: END IF;
491:
492: -- Invoke table handler(AMS_LIST_SRC_TYPE_ASSOCS_PKG.Delete_Row)
493: AMS_LIST_SRC_TYPE_ASSOCS_PKG.Delete_Row(

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

505:
506: -- Debug Message
507: IF (AMS_DEBUG_HIGH_ON) THEN
508:
509: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
510: END IF;
511:
512: -- Standard call to get message count and if count is 1, get message info.
513: FND_MSG_PUB.Count_And_Get

Line 519: WHEN AMS_Utility_PVT.resource_locked THEN

515: p_data => x_msg_data
516: );
517: EXCEPTION
518:
519: WHEN AMS_Utility_PVT.resource_locked THEN
520: x_return_status := FND_API.g_ret_sts_error;
521: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
522:
523: WHEN FND_API.G_EXC_ERROR THEN

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

517: EXCEPTION
518:
519: WHEN AMS_Utility_PVT.resource_locked THEN
520: x_return_status := FND_API.g_ret_sts_error;
521: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
522:
523: WHEN FND_API.G_EXC_ERROR THEN
524: ROLLBACK TO DELETE_St_Assoc_PVT;
525: x_return_status := FND_API.G_RET_STS_ERROR;

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

587:
588: -- Debug Message
589: IF (AMS_DEBUG_HIGH_ON) THEN
590:
591: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
592: END IF;
593:
594: -- Initialize message list if p_init_msg_list is set to TRUE.
595: IF FND_API.to_Boolean( p_init_msg_list )

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

616: IF (AMS_DEBUG_HIGH_ON) THEN
617:
618:
619:
620: AMS_Utility_PVT.debug_message(l_full_name||': start');
621:
622: END IF;
623: OPEN c_St_Assoc;
624:

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

641: p_count => x_msg_count,
642: p_data => x_msg_data);
643: IF (AMS_DEBUG_HIGH_ON) THEN
644:
645: AMS_Utility_PVT.debug_message(l_full_name ||': end');
646: END IF;
647: EXCEPTION
648:
649: WHEN AMS_Utility_PVT.resource_locked THEN

Line 649: WHEN AMS_Utility_PVT.resource_locked THEN

645: AMS_Utility_PVT.debug_message(l_full_name ||': end');
646: END IF;
647: EXCEPTION
648:
649: WHEN AMS_Utility_PVT.resource_locked THEN
650: x_return_status := FND_API.g_ret_sts_error;
651: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
652:
653: WHEN FND_API.G_EXC_ERROR THEN

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

647: EXCEPTION
648:
649: WHEN AMS_Utility_PVT.resource_locked THEN
650: x_return_status := FND_API.g_ret_sts_error;
651: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
652:
653: WHEN FND_API.G_EXC_ERROR THEN
654: ROLLBACK TO LOCK_St_Assoc_PVT;
655: x_return_status := FND_API.G_RET_STS_ERROR;

Line 699: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

695:
696: BEGIN
697: x_return_status := FND_API.g_ret_sts_success;
698: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
699: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
700: 'AMS_LIST_SRC_TYPE_ASSOCS',
701: 'LIST_SOURCE_TYPE_ASSOC_ID = ''' || p_st_assoc_rec.LIST_SOURCE_TYPE_ASSOC_ID ||''''
702: );
703: ELSE

Line 704: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

700: 'AMS_LIST_SRC_TYPE_ASSOCS',
701: 'LIST_SOURCE_TYPE_ASSOC_ID = ''' || p_st_assoc_rec.LIST_SOURCE_TYPE_ASSOC_ID ||''''
702: );
703: ELSE
704: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
705: 'AMS_LIST_SRC_TYPE_ASSOCS',
706: 'LIST_SOURCE_TYPE_ASSOC_ID = ''' || p_st_assoc_rec.LIST_SOURCE_TYPE_ASSOC_ID ||
707: ''' AND LIST_SOURCE_TYPE_ASSOC_ID <> ' || p_st_assoc_rec.LIST_SOURCE_TYPE_ASSOC_ID
708: );

Line 712: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_LIST_SOURCE_TYPE_ASSOC_ID_DUPLICATE');

708: );
709: END IF;
710:
711: IF l_valid_flag = FND_API.g_false THEN
712: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_LIST_SOURCE_TYPE_ASSOC_ID_DUPLICATE');
713: x_return_status := FND_API.g_ret_sts_error;
714: RETURN;
715: END IF;
716:

Line 736: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_list_source_type_assoc_id');

732: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
733:
734:
735: IF p_st_assoc_rec.list_source_type_assoc_id = FND_API.g_miss_num OR p_st_assoc_rec.list_source_type_assoc_id IS NULL THEN
736: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_list_source_type_assoc_id');
737: x_return_status := FND_API.g_ret_sts_error;
738: RETURN;
739: END IF;
740:

Line 742: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_last_update_date');

738: RETURN;
739: END IF;
740:
741: IF p_st_assoc_rec.last_update_date = FND_API.g_miss_date OR p_st_assoc_rec.last_update_date IS NULL THEN
742: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_last_update_date');
743: x_return_status := FND_API.g_ret_sts_error;
744: RETURN;
745: END IF;
746:

Line 748: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_last_updated_by');

744: RETURN;
745: END IF;
746:
747: IF p_st_assoc_rec.last_updated_by = FND_API.g_miss_num OR p_st_assoc_rec.last_updated_by IS NULL THEN
748: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_last_updated_by');
749: x_return_status := FND_API.g_ret_sts_error;
750: RETURN;
751: END IF;
752:

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

750: RETURN;
751: END IF;
752:
753: IF p_st_assoc_rec.creation_date = FND_API.g_miss_date OR p_st_assoc_rec.creation_date IS NULL THEN
754: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_creation_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_st_assoc_NO_created_by');

757: END IF;
758:
759:
760: IF p_st_assoc_rec.created_by = FND_API.g_miss_num OR p_st_assoc_rec.created_by IS NULL THEN
761: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_created_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_st_assoc_NO_master_source_type_id');

764: END IF;
765:
766:
767: IF p_st_assoc_rec.master_source_type_id = FND_API.g_miss_num OR p_st_assoc_rec.master_source_type_id IS NULL THEN
768: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_master_source_type_id');
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_st_assoc_NO_sub_source_type_id');

771: END IF;
772:
773:
774: IF p_st_assoc_rec.sub_source_type_id = FND_API.g_miss_num OR p_st_assoc_rec.sub_source_type_id IS NULL THEN
775: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_sub_source_type_id');
776: x_return_status := FND_API.g_ret_sts_error;
777: RETURN;
778: END IF;
779:

Line 781: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_sub_source_type_pk_column');

777: RETURN;
778: END IF;
779:
780: IF p_st_assoc_rec.sub_source_type_pk_column = FND_API.g_miss_char OR p_st_assoc_rec.sub_source_type_pk_column IS NULL THEN
781: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_sub_source_type_pk_column');
782: x_return_status := FND_API.g_ret_sts_error;
783: RETURN;
784: END IF;
785:

Line 788: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_enabled_flag');

784: END IF;
785:
786:
787: IF p_st_assoc_rec.enabled_flag = FND_API.g_miss_char OR p_st_assoc_rec.enabled_flag IS NULL THEN
788: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_enabled_flag');
789: x_return_status := FND_API.g_ret_sts_error;
790: RETURN;
791: END IF;
792: ELSE

Line 795: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_list_source_type_assoc_id');

791: END IF;
792: ELSE
793:
794: IF p_st_assoc_rec.list_source_type_assoc_id IS NULL THEN
795: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_list_source_type_assoc_id');
796: x_return_status := FND_API.g_ret_sts_error;
797: RETURN;
798: END IF;
799:

Line 802: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_last_update_date');

798: END IF;
799:
800:
801: IF p_st_assoc_rec.last_update_date IS NULL THEN
802: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_last_update_date');
803: x_return_status := FND_API.g_ret_sts_error;
804: RETURN;
805: END IF;
806:

Line 809: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_last_updated_by');

805: END IF;
806:
807:
808: IF p_st_assoc_rec.last_updated_by IS NULL THEN
809: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_last_updated_by');
810: x_return_status := FND_API.g_ret_sts_error;
811: RETURN;
812: END IF;
813:

Line 817: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_creation_date');

813:
814:
815:
816: IF p_st_assoc_rec.creation_date IS NULL THEN
817: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_creation_date');
818: x_return_status := FND_API.g_ret_sts_error;
819: RETURN;
820: END IF;
821:

Line 823: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_created_by');

819: RETURN;
820: END IF;
821:
822: IF p_st_assoc_rec.created_by IS NULL THEN
823: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_st_assoc_NO_created_by');
824: x_return_status := FND_API.g_ret_sts_error;
825: RETURN;
826: END IF;
827:

Line 842: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_NO_SUB_SOURCE_TYPE_ID');

838: IF p_st_assoc_rec.sub_source_type_id IS NULL THEN
839: --FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
840: --FND_MESSAGE.set_token('MISS_FIELD', 'SUB_SOURCE_TYPE_ID' );
841: --FND_MSG_PUB.add;
842: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_NO_SUB_SOURCE_TYPE_ID');
843: x_return_status := FND_API.g_ret_sts_error;
844: RETURN;
845: END IF;
846:

Line 853: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_NO_SUB_SOURCE_TYPE_PK_COL');

849: IF p_st_assoc_rec.sub_source_type_pk_column IS NULL THEN
850: --FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
851: --FND_MESSAGE.set_token('MISS_FIELD', 'SUB_SOURCE_TYPE_PK_COLUMN' );
852: --FND_MSG_PUB.add;
853: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_NO_SUB_SOURCE_TYPE_PK_COL');
854: x_return_status := FND_API.g_ret_sts_error;
855: RETURN;
856: END IF;
857:

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

1122:
1123: -- Debug Message
1124: IF (AMS_DEBUG_HIGH_ON) THEN
1125:
1126: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1127: END IF;
1128:
1129:
1130: -- Initialize API return status to SUCCESS

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

1133:
1134: -- Debug Message
1135: IF (AMS_DEBUG_HIGH_ON) THEN
1136:
1137: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1138: END IF;
1139:
1140: -- Standard call to get message count and if count is 1, get message info.
1141: FND_MSG_PUB.Count_And_Get

Line 1147: WHEN AMS_Utility_PVT.resource_locked THEN

1143: p_data => x_msg_data
1144: );
1145: EXCEPTION
1146:
1147: WHEN AMS_Utility_PVT.resource_locked THEN
1148: x_return_status := FND_API.g_ret_sts_error;
1149: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1150:
1151: WHEN FND_API.G_EXC_ERROR THEN

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

1145: EXCEPTION
1146:
1147: WHEN AMS_Utility_PVT.resource_locked THEN
1148: x_return_status := FND_API.g_ret_sts_error;
1149: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1150:
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: ROLLBACK TO VALIDATE_St_Assoc_;
1153: x_return_status := FND_API.G_RET_STS_ERROR;

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

1210:
1211: -- Debug Message
1212: IF (AMS_DEBUG_HIGH_ON) THEN
1213:
1214: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1215: END IF;
1216: -- Standard call to get message count and if count is 1, get message info.
1217: FND_MSG_PUB.Count_And_Get
1218: (p_count => x_msg_count,