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

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

90: FND_MSG_PUB.initialize;
91: END IF;
92:
93: -- Debug Message
94: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
95:
96:
97: -- Initialize API return status to SUCCESS
98: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

118: -- =========================================================================
119:
120: IF FND_GLOBAL.User_Id IS NULL
121: THEN
122: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
123: RAISE FND_API.G_EXC_ERROR;
124: END IF;
125:
126: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 129: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Src_Field');

125:
126: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
127: THEN
128: -- Debug message
129: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Src_Field');
130:
131: -- Invoke validation procedures
132: Validate_list_src_field(
133: p_api_version_number => 1.0,

Line 152: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','source_object_name');

148: FETCH c_get_table_name INTO l_table_name;
149: if (c_get_table_name%NOTFOUND)
150: THEN
151: close c_get_table_name;
152: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','source_object_name');
153: RAISE FND_API.G_EXC_ERROR;
154: END IF;
155: close c_get_table_name;
156:

Line 163: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','source_column_name');

159: FETCH c_get_column_name INTO l_column_name;
160: if (c_get_column_name%NOTFOUND)
161: THEN
162: close c_get_column_name;
163: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','source_column_name');
164: RAISE FND_API.G_EXC_ERROR;
165:
166: END IF;
167: close c_get_column_name;

Line 177: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','field_column_name');

173: FETCH c_get_column_name INTO l_column_name;
174: if (c_get_column_name%NOTFOUND)
175: THEN
176: close c_get_column_name;
177: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','field_column_name');
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180: close c_get_column_name;
181: */

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

180: close c_get_column_name;
181: */
182:
183: -- Debug Message
184: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
185:
186: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Insert_Row)
187: AMS_LIST_SRC_FIELDS_PKG.Insert_Row(
188: px_list_source_field_id => l_list_source_field_id,

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

231: END IF;
232:
233:
234: -- Debug Message
235: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
236:
237: -- Standard call to get message count and if count is 1, get message info.
238: FND_MSG_PUB.Count_And_Get
239: (p_count => x_msg_count,

Line 244: WHEN AMS_Utility_PVT.resource_locked THEN

240: p_data => x_msg_data
241: );
242: EXCEPTION
243:
244: WHEN AMS_Utility_PVT.resource_locked THEN
245: x_return_status := FND_API.g_ret_sts_error;
246: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
247:
248: WHEN FND_API.G_EXC_ERROR THEN

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

242: EXCEPTION
243:
244: WHEN AMS_Utility_PVT.resource_locked THEN
245: x_return_status := FND_API.g_ret_sts_error;
246: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
247:
248: WHEN FND_API.G_EXC_ERROR THEN
249: ROLLBACK TO CREATE_List_Src_Field_PVT;
250: x_return_status := FND_API.G_RET_STS_ERROR;

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

352: FND_MSG_PUB.initialize;
353: END IF;
354:
355: -- Debug Message
356: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
357:
358:
359: -- Initialize API return status to SUCCESS
360: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

359: -- Initialize API return status to SUCCESS
360: x_return_status := FND_API.G_RET_STS_SUCCESS;
361:
362: -- Debug Message
363: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
364:
365: -- check if source_column_name exist
366: OPEN c_get_table_name(p_list_src_field_rec.list_source_type_id);
367: FETCH c_get_table_name INTO l_table_name,l_remote_flag,l_database_link;

Line 371: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','source_object_name');

367: FETCH c_get_table_name INTO l_table_name,l_remote_flag,l_database_link;
368: if (c_get_table_name%NOTFOUND)
369: THEN
370: close c_get_table_name;
371: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','source_object_name');
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374: close c_get_table_name;
375:

Line 382: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','source_column_name');

378: FETCH c_get_column_name INTO l_column_name;
379: if (c_get_column_name%NOTFOUND)
380: THEN
381: close c_get_column_name;
382: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','source_column_name');
383: RAISE FND_API.G_EXC_ERROR;
384: END IF;
385: close c_get_column_name;
386: end if;

Line 403: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','source_column_name');

399: -- ' WHERE table_name = UPPER('||''''||l_table_name||''''||')'||
400: -- ' AND column_name = UPPER('|| ''''||p_list_src_field_rec.source_column_name||''''||'); END;' USING OUT l_column_name;
401: if l_column_name is NULL
402: THEN
403: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','source_column_name');
404: RAISE FND_API.G_EXC_ERROR;
405: END IF;
406: end if;
407:

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

407:
408:
409: If (l_tar_list_src_field_rec.object_version_number is NULL or
410: l_tar_list_src_field_rec.object_version_number = FND_API.G_MISS_NUM ) Then
411: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
412: p_token_name => 'COLUMN',
413: p_token_value => 'Last_Update_Date') ;
414: raise FND_API.G_EXC_ERROR;
415: End if;

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

414: raise FND_API.G_EXC_ERROR;
415: End if;
416: -- Check Whether record has been changed by someone else
417: If (l_tar_list_src_field_rec.object_version_number <> l_ref_list_src_field_rec.object_version_number) Then
418: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
419: p_token_name => 'INFO',
420: p_token_value => 'List_Src_Field') ;
421: raise FND_API.G_EXC_ERROR;
422: End if;

Line 426: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Src_Field');

422: End if;
423: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
424: THEN
425: -- Debug message
426: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Src_Field');
427:
428: -- Invoke validation procedures
429: Validate_list_src_field(
430: p_api_version_number => 1.0,

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

441: END IF;
442:
443:
444: -- Debug Message
445: -- AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
446:
447: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Update_Row)
448: AMS_LIST_SRC_FIELDS_PKG.Update_Row(
449: p_list_source_field_id => p_list_src_field_rec.list_source_field_id,

Line 485: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' AutoBinning Flag - Going to delete bin values for this field');

481: -- Beginning of Code for Analytics Data Source Fields
482: -- Added by nyostos - June 11, 2002
483: -- If the auto_binning_flag is set to 'Y', then remove all binning details for the field
484: IF p_list_src_field_rec.auto_binning_flag = 'Y' THEN
485: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' AutoBinning Flag - Going to delete bin values for this field');
486: AMS_Dm_Binvalues_PVT.Delete_Dm_Binvalues_For_Field (p_datasource_field_id => p_list_src_field_rec.list_source_field_id);
487: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' AutoBinning Flag - After delete of bin values for this field');
488: END IF;
489: -- End of Code for Analytics Data Source Fields

Line 487: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' AutoBinning Flag - After delete of bin values for this field');

483: -- If the auto_binning_flag is set to 'Y', then remove all binning details for the field
484: IF p_list_src_field_rec.auto_binning_flag = 'Y' THEN
485: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' AutoBinning Flag - Going to delete bin values for this field');
486: AMS_Dm_Binvalues_PVT.Delete_Dm_Binvalues_For_Field (p_datasource_field_id => p_list_src_field_rec.list_source_field_id);
487: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' AutoBinning Flag - After delete of bin values for this field');
488: END IF;
489: -- End of Code for Analytics Data Source Fields
490:
491: -- Added by nyostos - Oct 14, 2002

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

513: END IF;
514:
515:
516: -- Debug Message
517: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
518:
519: -- Standard call to get message count and if count is 1, get message info.
520: FND_MSG_PUB.Count_And_Get
521: (p_count => x_msg_count,

Line 526: WHEN AMS_Utility_PVT.resource_locked THEN

522: p_data => x_msg_data
523: );
524: EXCEPTION
525:
526: WHEN AMS_Utility_PVT.resource_locked THEN
527: x_return_status := FND_API.g_ret_sts_error;
528: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
529:
530: WHEN FND_API.G_EXC_ERROR THEN

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

524: EXCEPTION
525:
526: WHEN AMS_Utility_PVT.resource_locked THEN
527: x_return_status := FND_API.g_ret_sts_error;
528: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
529:
530: WHEN FND_API.G_EXC_ERROR THEN
531: ROLLBACK TO UPDATE_List_Src_Field_PVT;
532: x_return_status := FND_API.G_RET_STS_ERROR;

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

599: FND_MSG_PUB.initialize;
600: END IF;
601:
602: -- Debug Message
603: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
604:
605:
606: -- Initialize API return status to SUCCESS
607: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

609: --
610: -- Api body
611: --
612: -- Debug Message
613: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
614:
615: -- Invoke table handler(AMS_LIST_SRC_FIELDS_PKG.Delete_Row)
616: AMS_LIST_SRC_FIELDS_PKG.Delete_Row(
617: p_LIST_SOURCE_FIELD_ID => p_LIST_SOURCE_FIELD_ID);

Line 623: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Going to delete bin values for this field');

619:
620: -- Beginning of Code for Analytics Data Source Fields
621: -- Added by nyostos - June 11, 2002
622: -- Remove all binning details for the field
623: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Going to delete bin values for this field');
624: AMS_Dm_Binvalues_PVT.Delete_Dm_Binvalues_For_Field (p_datasource_field_id => p_list_source_field_id);
625: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' After delete of bin values for this field');
626: -- End of Code for Analytics Data Source Fields
627:

Line 625: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' After delete of bin values for this field');

621: -- Added by nyostos - June 11, 2002
622: -- Remove all binning details for the field
623: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' Going to delete bin values for this field');
624: AMS_Dm_Binvalues_PVT.Delete_Dm_Binvalues_For_Field (p_datasource_field_id => p_list_source_field_id);
625: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' After delete of bin values for this field');
626: -- End of Code for Analytics Data Source Fields
627:
628:
629: --

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

637: END IF;
638:
639:
640: -- Debug Message
641: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
642:
643: -- Standard call to get message count and if count is 1, get message info.
644: FND_MSG_PUB.Count_And_Get
645: (p_count => x_msg_count,

Line 650: WHEN AMS_Utility_PVT.resource_locked THEN

646: p_data => x_msg_data
647: );
648: EXCEPTION
649:
650: WHEN AMS_Utility_PVT.resource_locked THEN
651: x_return_status := FND_API.g_ret_sts_error;
652: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
653:
654: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

716:
717: BEGIN
718:
719: -- Debug Message
720: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
721:
722: -- Initialize message list if p_init_msg_list is set to TRUE.
723: IF FND_API.to_Boolean( p_init_msg_list )
724: THEN

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

740:
741:
742: ------------------------ lock -------------------------
743:
744: AMS_Utility_PVT.debug_message(l_full_name||': start');
745: OPEN c_List_Src_Field;
746:
747: FETCH c_List_Src_Field INTO l_LIST_SOURCE_FIELD_ID;
748:

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

761: FND_MSG_PUB.count_and_get(
762: p_encoded => FND_API.g_false,
763: p_count => x_msg_count,
764: p_data => x_msg_data);
765: AMS_Utility_PVT.debug_message(l_full_name ||': end');
766: EXCEPTION
767:
768: WHEN AMS_Utility_PVT.resource_locked THEN
769: x_return_status := FND_API.g_ret_sts_error;

Line 768: WHEN AMS_Utility_PVT.resource_locked THEN

764: p_data => x_msg_data);
765: AMS_Utility_PVT.debug_message(l_full_name ||': end');
766: EXCEPTION
767:
768: WHEN AMS_Utility_PVT.resource_locked THEN
769: x_return_status := FND_API.g_ret_sts_error;
770: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
771:
772: WHEN FND_API.G_EXC_ERROR THEN

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

766: EXCEPTION
767:
768: WHEN AMS_Utility_PVT.resource_locked THEN
769: x_return_status := FND_API.g_ret_sts_error;
770: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
771:
772: WHEN FND_API.G_EXC_ERROR THEN
773: ROLLBACK TO LOCK_List_Src_Field_PVT;
774: x_return_status := FND_API.G_RET_STS_ERROR;

Line 818: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

814:
815: BEGIN
816: x_return_status := FND_API.g_ret_sts_success;
817: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
818: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
819: 'AMS_LIST_SRC_FIELDS',
820: 'LIST_SOURCE_FIELD_ID = ''' || p_list_src_field_rec.LIST_SOURCE_FIELD_ID ||''''
821: );
822: ELSE

Line 823: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

819: 'AMS_LIST_SRC_FIELDS',
820: 'LIST_SOURCE_FIELD_ID = ''' || p_list_src_field_rec.LIST_SOURCE_FIELD_ID ||''''
821: );
822: ELSE
823: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
824: 'AMS_LIST_SRC_FIELDS',
825: 'LIST_SOURCE_FIELD_ID = ''' || p_list_src_field_rec.LIST_SOURCE_FIELD_ID ||
826: ''' AND LIST_SOURCE_FIELD_ID <> ' || p_list_src_field_rec.LIST_SOURCE_FIELD_ID
827: );

Line 831: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_LIST_SOURCE_FIELD_ID_DUPLICATE');

827: );
828: END IF;
829:
830: IF l_valid_flag = FND_API.g_false THEN
831: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_LIST_SOURCE_FIELD_ID_DUPLICATE');
832: x_return_status := FND_API.g_ret_sts_error;
833: RETURN;
834: END IF;
835:

Line 843: IF AMS_Utility_PVT.check_uniqueness(

839: AND p_list_src_field_rec.field_table_name IS NOT NULL
840: AND p_list_src_field_rec.list_source_type_id IS NOT NULL
841:
842: THEN
843: IF AMS_Utility_PVT.check_uniqueness(
844: 'ams_list_src_fields',
845: 'source_column_name = ' || p_list_src_field_rec.source_column_name||
846: ' and field_table_name = '||p_list_src_field_rec.field_table_name
847: ||' and field_column_name = '||p_list_src_field_rec.field_column_name

Line 877: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','LIST_SOURCE_FIELD_ID');

873: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
874:
875:
876: IF p_list_src_field_rec.list_source_field_id = FND_API.g_miss_num OR p_list_src_field_rec.list_source_field_id IS NULL THEN
877: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','LIST_SOURCE_FIELD_ID');
878: x_return_status := FND_API.g_ret_sts_error;
879: END IF;
880:
881:

Line 883: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','DE_LIST_SOURCE_TYPE_CODE' );

879: END IF;
880:
881:
882: IF p_list_src_field_rec.de_list_source_type_code = FND_API.g_miss_char OR p_list_src_field_rec.de_list_source_type_code IS NULL THEN
883: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','DE_LIST_SOURCE_TYPE_CODE' );
884: x_return_status := FND_API.g_ret_sts_error;
885: END IF;
886:
887:

Line 889: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','LIST_SOURCE_TYPE_ID' );

885: END IF;
886:
887:
888: IF p_list_src_field_rec.list_source_type_id = FND_API.g_miss_num OR p_list_src_field_rec.list_source_type_id IS NULL THEN
889: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','LIST_SOURCE_TYPE_ID' );
890: x_return_status := FND_API.g_ret_sts_error;
891: END IF;
892: /*
893: field_table_name and field_column_name are checked in check_lstsrcfld_business()

Line 895: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','FIELD_TABLE_NAME' );

891: END IF;
892: /*
893: field_table_name and field_column_name are checked in check_lstsrcfld_business()
894: IF p_list_src_field_rec.field_table_name = FND_API.g_miss_char OR p_list_src_field_rec.field_table_name IS NULL THEN
895: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','FIELD_TABLE_NAME' );
896: x_return_status := FND_API.g_ret_sts_error;
897: END IF;
898:
899:

Line 901: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','FIELD_COLUMN_NAME' );

897: END IF;
898:
899:
900: IF p_list_src_field_rec.field_column_name = FND_API.g_miss_char OR p_list_src_field_rec.field_column_name IS NULL THEN
901: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','FIELD_COLUMN_NAME' );
902: x_return_status := FND_API.g_ret_sts_error;
903: END IF;
904: */
905:

Line 907: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','SOURCE_COLUMN_NAME' );

903: END IF;
904: */
905:
906: IF p_list_src_field_rec.source_column_name = FND_API.g_miss_char OR p_list_src_field_rec.source_column_name IS NULL THEN
907: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','SOURCE_COLUMN_NAME' );
908: x_return_status := FND_API.g_ret_sts_error;
909: END IF;
910:
911: IF p_list_src_field_rec.enabled_flag = FND_API.g_miss_char OR p_list_src_field_rec.enabled_flag IS NULL THEN

Line 912: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','ENABLED_FLAG' );

908: x_return_status := FND_API.g_ret_sts_error;
909: END IF;
910:
911: IF p_list_src_field_rec.enabled_flag = FND_API.g_miss_char OR p_list_src_field_rec.enabled_flag IS NULL THEN
912: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','ENABLED_FLAG' );
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915:
916: END IF;

Line 1089: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','field_table_name' );

1085:
1086: /*
1087: IF p_list_src_field_rec.de_list_source_type_code <> 'ANALYTICS' THEN
1088: IF p_list_src_field_rec.field_table_name = FND_API.g_miss_char OR p_list_src_field_rec.field_table_name IS NULL THEN
1089: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','field_table_name' );
1090: x_return_status := FND_API.g_ret_sts_error;
1091: END IF;
1092:
1093: IF p_list_src_field_rec.field_column_name = FND_API.g_miss_char OR p_list_src_field_rec.field_column_name IS NULL THEN

Line 1094: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','field_column_name' );

1090: x_return_status := FND_API.g_ret_sts_error;
1091: END IF;
1092:
1093: IF p_list_src_field_rec.field_column_name = FND_API.g_miss_char OR p_list_src_field_rec.field_column_name IS NULL THEN
1094: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','field_column_name' );
1095: x_return_status := FND_API.g_ret_sts_error;
1096: END IF;
1097: END IF;
1098: */

Line 1101: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','field_table_name' );

1097: END IF;
1098: */
1099: IF p_list_src_field_rec.enabled_flag = 'Y' THEN
1100: IF p_list_src_field_rec.field_table_name = FND_API.g_miss_char OR p_list_src_field_rec.field_table_name IS NULL THEN
1101: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','field_table_name' );
1102: x_return_status := FND_API.g_ret_sts_error;
1103: END IF;
1104:
1105: IF p_list_src_field_rec.field_column_name = FND_API.g_miss_char OR p_list_src_field_rec.field_column_name IS NULL THEN

Line 1106: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','field_column_name' );

1102: x_return_status := FND_API.g_ret_sts_error;
1103: END IF;
1104:
1105: IF p_list_src_field_rec.field_column_name = FND_API.g_miss_char OR p_list_src_field_rec.field_column_name IS NULL THEN
1106: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD','MISS_FIELD','field_column_name' );
1107: x_return_status := FND_API.g_ret_sts_error;
1108: END IF;
1109: END IF;
1110:

Line 1157: AMS_UTILITY_PVT.debug_message('Private API: ' || 'before check_lstsrcfld_business');

1153: IF x_return_status <> FND_API.g_ret_sts_success THEN
1154: RETURN;
1155: END IF;
1156:
1157: AMS_UTILITY_PVT.debug_message('Private API: ' || 'before check_lstsrcfld_business');
1158: check_lstsrcfld_business(
1159: p_list_src_field_rec => p_list_src_field_rec,
1160: x_return_status => x_return_status);
1161: IF x_return_status <> FND_API.g_ret_sts_success THEN

Line 1164: AMS_UTILITY_PVT.debug_message('Private API: ' || 'after check_lstsrcfld_business');

1160: x_return_status => x_return_status);
1161: IF x_return_status <> FND_API.g_ret_sts_success THEN
1162: RETURN;
1163: END IF;
1164: AMS_UTILITY_PVT.debug_message('Private API: ' || 'after check_lstsrcfld_business');
1165:
1166: END Check_list_src_field_Items;
1167:
1168:

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

1340: END IF;
1341:
1342:
1343: -- Debug Message
1344: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1345:
1346:
1347: -- Initialize API return status to SUCCESS
1348: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1348: x_return_status := FND_API.G_RET_STS_SUCCESS;
1349:
1350:
1351: -- Debug Message
1352: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1353:
1354: -- Standard call to get message count and if count is 1, get message info.
1355: FND_MSG_PUB.Count_And_Get
1356: (p_count => x_msg_count,

Line 1361: WHEN AMS_Utility_PVT.resource_locked THEN

1357: p_data => x_msg_data
1358: );
1359: EXCEPTION
1360:
1361: WHEN AMS_Utility_PVT.resource_locked THEN
1362: x_return_status := FND_API.g_ret_sts_error;
1363: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1364:
1365: WHEN FND_API.G_EXC_ERROR THEN

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

1359: EXCEPTION
1360:
1361: WHEN AMS_Utility_PVT.resource_locked THEN
1362: x_return_status := FND_API.g_ret_sts_error;
1363: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1364:
1365: WHEN FND_API.G_EXC_ERROR THEN
1366: ROLLBACK TO VALIDATE_List_Src_Field_;
1367: x_return_status := FND_API.G_RET_STS_ERROR;

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

1422: -- THEN
1423: -- x_return_status := FND_API.G_RET_STS_ERROR;
1424:
1425: -- Debug Message
1426: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1427: -- Standard call to get message count and if count is 1, get message info.
1428: FND_MSG_PUB.Count_And_Get
1429: (p_count => x_msg_count,
1430: p_data => x_msg_data