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

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

110:
111: -- Debug Message
112: IF (AMS_DEBUG_HIGH_ON) THEN
113:
114: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
115: END IF;
116:
117: -- Initialize API return status to SUCCESS
118: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

127: -- Validate Environment
128: -- =========================================================================
129:
130: IF FND_GLOBAL.USER_ID IS NULL THEN
131: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
132: RAISE FND_API.G_EXC_ERROR;
133: END IF;
134:
135: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 139: AMS_UTILITY_PVT.debug_message('Private API: Validate_Imp_Attribute');

135: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
136: -- Debug message
137: IF (AMS_DEBUG_HIGH_ON) THEN
138:
139: AMS_UTILITY_PVT.debug_message('Private API: Validate_Imp_Attribute');
140: END IF;
141:
142: -- Invoke validation procedures
143: Validate_imp_attribute(

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

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

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

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

Line 205: WHEN AMS_Utility_PVT.resource_locked THEN

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

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

203: EXCEPTION
204:
205: WHEN AMS_Utility_PVT.resource_locked THEN
206: x_return_status := FND_API.g_ret_sts_error;
207: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
208:
209: WHEN FND_API.G_EXC_ERROR THEN
210: ROLLBACK TO CREATE_Dm_Imp_Attribute_PVT;
211: x_return_status := FND_API.G_RET_STS_ERROR;

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

325:
326: -- Debug Message
327: IF (AMS_DEBUG_HIGH_ON) THEN
328:
329: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
330: END IF;
331:
332: -- Initialize API return status to SUCCESS
333: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

334:
335: -- Debug Message
336: IF (AMS_DEBUG_HIGH_ON) THEN
337:
338: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
339: END IF;
340:
341: OPEN c_get_Imp_Attribute( l_tar_imp_attribute_rec.imp_attribute_id);
342: FETCH c_get_Imp_Attribute INTO l_ref_imp_attribute_rec ;

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

340:
341: OPEN c_get_Imp_Attribute( l_tar_imp_attribute_rec.imp_attribute_id);
342: FETCH c_get_Imp_Attribute INTO l_ref_imp_attribute_rec ;
343: If ( c_get_Imp_Attribute%NOTFOUND) THEN
344: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
345: p_token_name => 'INFO',
346: p_token_value => 'Imp_Attribute') ;
347: RAISE FND_API.G_EXC_ERROR;
348: END IF;

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

348: END IF;
349: -- Debug Message
350: IF (AMS_DEBUG_HIGH_ON) THEN
351:
352: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
353: END IF;
354: CLOSE c_get_Imp_Attribute;
355:
356:

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

355:
356:
357: If (l_tar_imp_attribute_rec.object_version_number is NULL or
358: l_tar_imp_attribute_rec.object_version_number = FND_API.G_MISS_NUM ) Then
359: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
360: p_token_name => 'COLUMN',
361: p_token_value => 'Last_Update_Date') ;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;

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

362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364: -- Check Whether record has been changed by someone else
365: If (l_tar_imp_attribute_rec.object_version_number <> l_ref_imp_attribute_rec.object_version_number) Then
366: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
367: p_token_name => 'INFO',
368: p_token_value => 'Imp_Attribute') ;
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;

Line 376: AMS_UTILITY_PVT.debug_message('Private API: Validate_Imp_Attribute');

372: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
373: -- Debug message
374: IF (AMS_DEBUG_HIGH_ON) THEN
375:
376: AMS_UTILITY_PVT.debug_message('Private API: Validate_Imp_Attribute');
377: END IF;
378:
379: -- Invoke validation procedures
380: Validate_imp_attribute(

Line 397: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');

393:
394: -- Debug Message
395: IF (AMS_DEBUG_HIGH_ON) THEN
396:
397: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler');
398: END IF;
399:
400: -- Invoke table handler(Ams_Dm_Imp_Attribute_Pkg.Update_Row)
401: Ams_Dm_Imp_Attribute_Pkg.Update_Row(

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

423:
424: -- Debug Message
425: IF (AMS_DEBUG_HIGH_ON) THEN
426:
427: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
428: END IF;
429:
430: -- Standard call to get message count and if count is 1, get message info.
431: FND_MSG_PUB.Count_And_Get

Line 437: WHEN AMS_Utility_PVT.resource_locked THEN

433: p_data => x_msg_data
434: );
435: EXCEPTION
436:
437: WHEN AMS_Utility_PVT.resource_locked THEN
438: x_return_status := FND_API.g_ret_sts_error;
439: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
440:
441: WHEN FND_API.G_EXC_ERROR THEN

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

435: EXCEPTION
436:
437: WHEN AMS_Utility_PVT.resource_locked THEN
438: x_return_status := FND_API.g_ret_sts_error;
439: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
440:
441: WHEN FND_API.G_EXC_ERROR THEN
442: ROLLBACK TO UPDATE_Dm_Imp_Attribute_PVT;
443: x_return_status := FND_API.G_RET_STS_ERROR;

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

547:
548: -- Debug Message
549: IF (AMS_DEBUG_HIGH_ON) THEN
550:
551: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
552: END IF;
553:
554:
555:

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

561: --
562: -- Debug Message
563: IF (AMS_DEBUG_HIGH_ON) THEN
564:
565: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
566: END IF;
567:
568: -- Invoke table handler(Ams_Dm_Imp_Attribute_Pkg.Delete_Row)
569: Ams_Dm_Imp_Attribute_Pkg.Delete_Row(

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

582:
583: -- Debug Message
584: IF (AMS_DEBUG_HIGH_ON) THEN
585:
586: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
587: END IF;
588:
589:
590: -- Standard call to get message count and if count is 1, get message info.

Line 597: WHEN AMS_Utility_PVT.resource_locked THEN

593: p_data => x_msg_data
594: );
595: EXCEPTION
596:
597: WHEN AMS_Utility_PVT.resource_locked THEN
598: x_return_status := FND_API.g_ret_sts_error;
599: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
600:
601: WHEN FND_API.G_EXC_ERROR THEN

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

595: EXCEPTION
596:
597: WHEN AMS_Utility_PVT.resource_locked THEN
598: x_return_status := FND_API.g_ret_sts_error;
599: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
600:
601: WHEN FND_API.G_EXC_ERROR THEN
602: ROLLBACK TO DELETE_Dm_Imp_Attribute_PVT;
603: x_return_status := FND_API.G_RET_STS_ERROR;

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

696:
697: -- Debug Message
698: IF (AMS_DEBUG_HIGH_ON) THEN
699:
700: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
701: END IF;
702:
703: -- Initialize message list if p_init_msg_list is set to TRUE.
704: IF FND_API.to_Boolean( p_init_msg_list )

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

723: IF (AMS_DEBUG_HIGH_ON) THEN
724:
725:
726:
727: AMS_Utility_PVT.debug_message(l_full_name||': start');
728:
729: END IF;
730: OPEN c_imp_attribute;
731: FETCH c_imp_attribute INTO l_Dm_Imp_Attribute_id;

Line 734: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');

730: OPEN c_imp_attribute;
731: FETCH c_imp_attribute INTO l_Dm_Imp_Attribute_id;
732: IF (c_imp_attribute%NOTFOUND) THEN
733: CLOSE c_imp_attribute;
734: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
735: RAISE FND_API.g_exc_error;
736: END IF;
737: CLOSE c_imp_attribute;
738:

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

742: p_count => x_msg_count,
743: p_data => x_msg_data);
744: IF (AMS_DEBUG_HIGH_ON) THEN
745:
746: AMS_Utility_PVT.debug_message(l_full_name ||': end');
747: END IF;
748: EXCEPTION
749:
750: WHEN AMS_Utility_PVT.resource_locked THEN

Line 750: WHEN AMS_Utility_PVT.resource_locked THEN

746: AMS_Utility_PVT.debug_message(l_full_name ||': end');
747: END IF;
748: EXCEPTION
749:
750: WHEN AMS_Utility_PVT.resource_locked THEN
751: x_return_status := FND_API.g_ret_sts_error;
752: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
753:
754: WHEN FND_API.G_EXC_ERROR THEN

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

748: EXCEPTION
749:
750: WHEN AMS_Utility_PVT.resource_locked THEN
751: x_return_status := FND_API.g_ret_sts_error;
752: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
753:
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO LOCK_Dm_Imp_Attribute_PVT;
756: x_return_status := FND_API.G_RET_STS_ERROR;

Line 800: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

796: BEGIN
797: x_return_status := FND_API.g_ret_sts_success;
798:
799: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
800: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
801: 'ams_dm_imp_attributes',
802: 'model_id = ' || p_imp_attribute_rec.model_id ||
803: ' AND source_field_id = ' || p_imp_attribute_rec.source_field_id
804: );

Line 806: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_DM_MODEL_FIELD_DUP');

802: 'model_id = ' || p_imp_attribute_rec.model_id ||
803: ' AND source_field_id = ' || p_imp_attribute_rec.source_field_id
804: );
805: IF l_valid_flag = FND_API.g_false THEN
806: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_DM_MODEL_FIELD_DUP');
807: x_return_status := FND_API.g_ret_sts_error;
808: END IF;
809: ELSE
810: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 810: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

806: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_DM_MODEL_FIELD_DUP');
807: x_return_status := FND_API.g_ret_sts_error;
808: END IF;
809: ELSE
810: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
811: 'ams_dm_imp_attributes',
812: 'imp_attribute_id = ' || p_imp_attribute_rec.imp_attribute_id ||
813: ' AND imp_attribute_id <> ' || p_imp_attribute_rec.imp_attribute_id
814: );

Line 816: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','IMP_ATTRIBUTE_ID');

812: 'imp_attribute_id = ' || p_imp_attribute_rec.imp_attribute_id ||
813: ' AND imp_attribute_id <> ' || p_imp_attribute_rec.imp_attribute_id
814: );
815: IF l_valid_flag = FND_API.g_false THEN
816: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','IMP_ATTRIBUTE_ID');
817: x_return_status := FND_API.g_ret_sts_error;
818: END IF;
819: END IF;
820: END check_Imp_Attribute_UK_Items;

Line 834: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_ID');

830: x_return_status := FND_API.g_ret_sts_success;
831:
832: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
833: IF p_imp_attribute_rec.model_id = FND_API.G_MISS_NUM OR p_imp_attribute_rec.model_id IS NULL THEN
834: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_ID');
835: x_return_status := FND_API.g_ret_sts_error;
836: END IF;
837:
838: IF p_imp_attribute_rec.source_field_id = FND_API.G_MISS_NUM OR p_imp_attribute_rec.source_field_id IS NULL THEN

Line 839: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_FIELD_ID');

835: x_return_status := FND_API.g_ret_sts_error;
836: END IF;
837:
838: IF p_imp_attribute_rec.source_field_id = FND_API.G_MISS_NUM OR p_imp_attribute_rec.source_field_id IS NULL THEN
839: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_FIELD_ID');
840: x_return_status := FND_API.g_ret_sts_error;
841: END IF;
842:
843: IF p_imp_attribute_rec.value = FND_API.G_MISS_NUM OR p_imp_attribute_rec.value IS NULL THEN

Line 844: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'VALUE');

840: x_return_status := FND_API.g_ret_sts_error;
841: END IF;
842:
843: IF p_imp_attribute_rec.value = FND_API.G_MISS_NUM OR p_imp_attribute_rec.value IS NULL THEN
844: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'VALUE');
845: x_return_status := FND_API.g_ret_sts_error;
846: END IF;
847: ELSE
848: IF p_imp_attribute_rec.model_id = FND_API.G_MISS_NUM THEN

Line 849: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_ID');

845: x_return_status := FND_API.g_ret_sts_error;
846: END IF;
847: ELSE
848: IF p_imp_attribute_rec.model_id = FND_API.G_MISS_NUM THEN
849: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'MODEL_ID');
850: x_return_status := FND_API.g_ret_sts_error;
851: END IF;
852:
853: IF p_imp_attribute_rec.source_field_id = FND_API.G_MISS_NUM THEN

Line 854: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_FIELD_ID');

850: x_return_status := FND_API.g_ret_sts_error;
851: END IF;
852:
853: IF p_imp_attribute_rec.source_field_id = FND_API.G_MISS_NUM THEN
854: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SOURCE_FIELD_ID');
855: x_return_status := FND_API.g_ret_sts_error;
856: END IF;
857:
858: IF p_imp_attribute_rec.value = FND_API.G_MISS_NUM THEN

Line 859: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'VALUE');

855: x_return_status := FND_API.g_ret_sts_error;
856: END IF;
857:
858: IF p_imp_attribute_rec.value = FND_API.G_MISS_NUM THEN
859: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'VALUE');
860: x_return_status := FND_API.g_ret_sts_error;
861: END IF;
862: END IF;
863: END check_Imp_Attribute_Req_Items;

Line 888: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_MODEL_REF');

884:
885: OPEN c_model (p_imp_attribute_rec.model_id);
886: FETCH c_model INTO l_dummy;
887: IF c_model%NOTFOUND THEN
888: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_MODEL_REF');
889: x_return_status := FND_API.g_ret_sts_error;
890: END IF;
891: CLOSE c_model;
892:

Line 896: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_SOURCE_FIELD');

892:
893: OPEN c_field (p_imp_attribute_rec.source_field_id);
894: FETCH c_field INTO l_dummy;
895: IF c_field%NOTFOUND THEN
896: AMS_Utility_PVT.error_message ('AMS_DM_INVALID_SOURCE_FIELD');
897: x_return_status := FND_API.g_ret_sts_error;
898: END IF;
899: CLOSE c_field;
900: END Check_Imp_Attribute_FK_Items;

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

1187:
1188: -- Debug Message
1189: IF (AMS_DEBUG_HIGH_ON) THEN
1190:
1191: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1192: END IF;
1193:
1194: -- Initialize API return status to SUCCESS
1195: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1196:
1197: -- Debug Message
1198: IF (AMS_DEBUG_HIGH_ON) THEN
1199:
1200: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1201: END IF;
1202:
1203: -- Standard call to get message count and if count is 1, get message info.
1204: FND_MSG_PUB.Count_And_Get

Line 1210: WHEN AMS_Utility_PVT.resource_locked THEN

1206: p_data => x_msg_data
1207: );
1208: EXCEPTION
1209:
1210: WHEN AMS_Utility_PVT.resource_locked THEN
1211: x_return_status := FND_API.g_ret_sts_error;
1212: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1213:
1214: WHEN FND_API.G_EXC_ERROR THEN

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

1208: EXCEPTION
1209:
1210: WHEN AMS_Utility_PVT.resource_locked THEN
1211: x_return_status := FND_API.g_ret_sts_error;
1212: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1213:
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: ROLLBACK TO VALIDATE_Dm_Imp_Attribute_;
1216: x_return_status := FND_API.G_RET_STS_ERROR;

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

1273:
1274: -- Debug Message
1275: IF (AMS_DEBUG_HIGH_ON) THEN
1276:
1277: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1278: END IF;
1279:
1280: END Validate_Imp_Attribute_Rec;
1281: