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

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

83:
84: -- Debug Message
85: IF (AMS_DEBUG_HIGH_ON) THEN
86:
87: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
88: END IF;
89: -- Initialize API return status to SUCCESS
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91:

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

110: -- =========================================================================
111:
112: IF FND_GLOBAL.User_Id IS NULL
113: THEN
114: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
115: RAISE FND_API.G_EXC_ERROR;
116: END IF;
117:
118: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 123: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Query');

119: THEN
120: -- Debug message
121: IF (AMS_DEBUG_HIGH_ON) THEN
122:
123: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Query');
124: END IF;
125:
126: -- Invoke validation procedures
127: Validate_list_query(

Line 151: AMS_UTILITY_PVT.debug_message( 'Private API: Call create table handler');

147: l_parent_list_query_id := p_list_query_rec.parent_list_query_id;
148: end if;
149: IF (AMS_DEBUG_HIGH_ON) THEN
150:
151: AMS_UTILITY_PVT.debug_message( 'Private API: Call create table handler');
152: END IF;
153: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Insert_Row)
154: AMS_LIST_QUERIES_PKG.Insert_Row(
155: px_list_query_id => l_list_query_id,

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

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

Line 206: WHEN AMS_Utility_PVT.resource_locked THEN

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

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

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

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

281:
282: -- Debug Message
283: IF (AMS_DEBUG_HIGH_ON) THEN
284:
285: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
286: END IF;
287: -- Initialize API return status to SUCCESS
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
289:

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

294: -- =========================================================================
295:
296: IF FND_GLOBAL.User_Id IS NULL
297: THEN
298: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
299: RAISE FND_API.G_EXC_ERROR;
300: END IF;
301:
302: for i in 1 .. p_sql_string_tbl.last

Line 330: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message( 'Private API: Call create Query - Child');END IF;

326: l_list_query_rec.SOURCE_OBJECT_NAME :=
327: p_list_query_rec_tbl.SOURCE_OBJECT_NAME;
328: l_list_query_rec.PARENT_LIST_QUERY_ID := x_parent_list_query_id ;
329: l_list_query_rec.SEQUENCE_ORDER := i;
330: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message( 'Private API: Call create Query - Child');END IF;
331: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Insert_Row)
332: Create_List_Query(
333: p_api_version_number => p_api_version_number,
334: p_init_msg_list => p_init_msg_list,

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

362:
363: -- Debug Message
364: IF (AMS_DEBUG_HIGH_ON) THEN
365:
366: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
367: END IF;
368:
369: -- Standard call to get message count and if count is 1, get message info.
370: FND_MSG_PUB.Count_And_Get

Line 376: WHEN AMS_Utility_PVT.resource_locked THEN

372: p_data => x_msg_data
373: );
374: EXCEPTION
375:
376: WHEN AMS_Utility_PVT.resource_locked THEN
377: x_return_status := FND_API.g_ret_sts_error;
378: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
379:
380: WHEN FND_API.G_EXC_ERROR THEN

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

374: EXCEPTION
375:
376: WHEN AMS_Utility_PVT.resource_locked THEN
377: x_return_status := FND_API.g_ret_sts_error;
378: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
379:
380: WHEN FND_API.G_EXC_ERROR THEN
381: ROLLBACK TO CREATE_List_Query_PVT_TBL;
382: x_return_status := FND_API.G_RET_STS_ERROR;

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

455:
456: -- Debug Message
457: IF (AMS_DEBUG_HIGH_ON) THEN
458:
459: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
460: END IF;
461: -- Initialize API return status to SUCCESS
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463:

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

468: -- =========================================================================
469:
470: IF FND_GLOBAL.User_Id IS NULL
471: THEN
472: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
473: RAISE FND_API.G_EXC_ERROR;
474: END IF;
475:
476: Create_List_Query(

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

537:
538: -- Debug Message
539: IF (AMS_DEBUG_HIGH_ON) THEN
540:
541: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
542: END IF;
543:
544: -- Standard call to get message count and if count is 1, get message info.
545: FND_MSG_PUB.Count_And_Get

Line 551: WHEN AMS_Utility_PVT.resource_locked THEN

547: p_data => x_msg_data
548: );
549: EXCEPTION
550:
551: WHEN AMS_Utility_PVT.resource_locked THEN
552: x_return_status := FND_API.g_ret_sts_error;
553: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
554:
555: WHEN FND_API.G_EXC_ERROR THEN

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

549: EXCEPTION
550:
551: WHEN AMS_Utility_PVT.resource_locked THEN
552: x_return_status := FND_API.g_ret_sts_error;
553: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
554:
555: WHEN FND_API.G_EXC_ERROR THEN
556: ROLLBACK TO CREATE_List_Query_PVT_TBL_;
557: x_return_status := FND_API.G_RET_STS_ERROR;

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

640:
641: -- Debug Message
642: IF (AMS_DEBUG_HIGH_ON) THEN
643:
644: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
645: END IF;
646:
647:
648: -- Initialize API return status to SUCCESS

Line 652: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');END IF;

648: -- Initialize API return status to SUCCESS
649: x_return_status := FND_API.G_RET_STS_SUCCESS;
650:
651: -- Debug Message
652: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');END IF;
653:
654:
655: OPEN c_get_List_Query( l_tar_list_query_rec.list_query_id);
656:

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

656:
657: FETCH c_get_List_Query INTO l_ref_list_query_rec ;
658:
659: IF ( c_get_List_Query%NOTFOUND) THEN
660: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
661: p_token_name => 'INFO',
662: p_token_value => 'List_Query') ;
663: RAISE FND_API.G_EXC_ERROR;
664: END IF;

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

664: END IF;
665: -- Debug Message
666: IF (AMS_DEBUG_HIGH_ON) THEN
667:
668: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
669: END IF;
670: CLOSE c_get_List_Query;
671:
672:

Line 675: AMS_Utility_PVT.Error_Message(p_message_name

671:
672:
673: IF (l_tar_list_query_rec.object_version_number is NULL or
674: l_tar_list_query_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
675: AMS_Utility_PVT.Error_Message(p_message_name
676: => 'API_VERSION_MISSING',
677: p_token_name => 'COLUMN',
678: p_token_value
679: => 'Object_version Number') ;

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

681: END IF;
682:
683: -- Check Whether record has been changed by someone else
684: IF (l_tar_list_query_rec.object_version_number <> l_ref_list_query_rec.object_version_number) THEN
685: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
686: p_token_name => 'INFO',
687: p_token_value => 'List_Query') ;
688: raise FND_API.G_EXC_ERROR;
689: END IF;

Line 700: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Query');

696: THEN
697: -- Debug message
698: IF (AMS_DEBUG_HIGH_ON) THEN
699:
700: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Query');
701: END IF;
702:
703: -- Invoke validation procedures
704: Validate_list_query(

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

716: END IF;
717:
718:
719: -- Debug Message
720: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;
721:
722:
723: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Update_Row)
724: AMS_LIST_QUERIES_PKG.Update_Row(

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

759:
760: -- Debug Message
761: IF (AMS_DEBUG_HIGH_ON) THEN
762:
763: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
764: END IF;
765:
766: -- Standard call to get message count and if count is 1, get message info.
767: FND_MSG_PUB.Count_And_Get

Line 773: WHEN AMS_Utility_PVT.resource_locked THEN

769: p_data => x_msg_data
770: );
771: EXCEPTION
772:
773: WHEN AMS_Utility_PVT.resource_locked THEN
774: x_return_status := FND_API.g_ret_sts_error;
775: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
776:
777: WHEN FND_API.G_EXC_ERROR THEN

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

771: EXCEPTION
772:
773: WHEN AMS_Utility_PVT.resource_locked THEN
774: x_return_status := FND_API.g_ret_sts_error;
775: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
776:
777: WHEN FND_API.G_EXC_ERROR THEN
778: ROLLBACK TO UPDATE_List_Query_PVT;
779: x_return_status := FND_API.G_RET_STS_ERROR;

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

880:
881: -- Debug Message
882: IF (AMS_DEBUG_HIGH_ON) THEN
883:
884: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
885: END IF;
886:
887:
888: -- Initialize API return status to SUCCESS

Line 892: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');END IF;

888: -- Initialize API return status to SUCCESS
889: x_return_status := FND_API.G_RET_STS_SUCCESS;
890:
891: -- Debug Message
892: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');END IF;
893:
894:
895: IF (AMS_DEBUG_HIGH_ON) THEN
896:

Line 901: AMS_UTILITY_PVT.debug_message('parent list header id'

897:
898:
899:
900:
901: AMS_UTILITY_PVT.debug_message('parent list header id'
902: || p_list_query_rec_tbl.PARENT_LIST_QUERY_ID );
903:
904:
905: END IF;

Line 911: AMS_UTILITY_PVT.debug_message('Please Provide parent list header id' );

907: or p_list_query_rec_tbl.PARENT_LIST_QUERY_ID = FND_API.G_MISS_NUM then
908: --gjoby Add proper message name
909: IF (AMS_DEBUG_HIGH_ON) THEN
910:
911: AMS_UTILITY_PVT.debug_message('Please Provide parent list header id' );
912: END IF;
913: x_return_status := FND_API.g_ret_sts_error;
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: end if;

Line 970: AMS_UTILITY_PVT.debug_message( 'Private API: Child->' || i || '<-'

966: l_list_query_rec.PARENT_LIST_QUERY_ID := l_list_query_rec_tbl.PARENT_LIST_QUERY_ID ;
967: l_list_query_rec.SEQUENCE_ORDER := i;
968: IF (AMS_DEBUG_HIGH_ON) THEN
969:
970: AMS_UTILITY_PVT.debug_message( 'Private API: Child->' || i || '<-'
971: || '->' || l_no_of_records|| '<-');
972: END IF;
973: if i > l_no_of_records then
974: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message( 'Private API: Create Child->' || i || '<-');END IF;

Line 974: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message( 'Private API: Create Child->' || i || '<-');END IF;

970: AMS_UTILITY_PVT.debug_message( 'Private API: Child->' || i || '<-'
971: || '->' || l_no_of_records|| '<-');
972: END IF;
973: if i > l_no_of_records then
974: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message( 'Private API: Create Child->' || i || '<-');END IF;
975: l_list_query_rec.LIST_QUERY_ID := '';
976: Create_List_Query(
977: p_api_version_number => p_api_version_number,
978: p_init_msg_list => p_init_msg_list,

Line 990: AMS_UTILITY_PVT.debug_message( '->' || l_list_query_rec.sequence_order || '<-');

986: );
987: else
988: IF (AMS_DEBUG_HIGH_ON) THEN
989:
990: AMS_UTILITY_PVT.debug_message( '->' || l_list_query_rec.sequence_order || '<-');
991: END IF;
992: open c_get_query_id (l_list_query_rec.parent_list_query_id,
993: l_list_query_rec.sequence_order);
994: fetch c_get_query_id into l_list_query_rec.list_query_id,

Line 998: AMS_UTILITY_PVT.debug_message( '->' || l_list_query_rec.list_query_id || '<-');

994: fetch c_get_query_id into l_list_query_rec.list_query_id,
995: l_list_query_rec.object_version_number;
996: IF (AMS_DEBUG_HIGH_ON) THEN
997:
998: AMS_UTILITY_PVT.debug_message( '->' || l_list_query_rec.list_query_id || '<-');
999: END IF;
1000:
1001: Update_List_Query(
1002: p_api_version_number => p_api_version_number,

Line 1014: AMS_UTILITY_PVT.debug_message( '->' || x_return_status || '<-');

1010: x_object_version_number => l_object_version_number
1011: );
1012: IF (AMS_DEBUG_HIGH_ON) THEN
1013:
1014: AMS_UTILITY_PVT.debug_message( '->' || x_return_status || '<-');
1015: END IF;
1016: close c_get_query_id ;
1017:
1018: end if;

Line 1030: AMS_UTILITY_PVT.debug_message( '->' || l_no_of_records_upd || '<-');

1026: END IF;
1027: end loop;
1028: IF (AMS_DEBUG_HIGH_ON) THEN
1029:
1030: AMS_UTILITY_PVT.debug_message( '->' || l_no_of_records_upd || '<-');
1031: END IF;
1032: IF (AMS_DEBUG_HIGH_ON) THEN
1033:
1034: AMS_UTILITY_PVT.debug_message( '->' || l_parent_list_query_id || '<-');

Line 1034: AMS_UTILITY_PVT.debug_message( '->' || l_parent_list_query_id || '<-');

1030: AMS_UTILITY_PVT.debug_message( '->' || l_no_of_records_upd || '<-');
1031: END IF;
1032: IF (AMS_DEBUG_HIGH_ON) THEN
1033:
1034: AMS_UTILITY_PVT.debug_message( '->' || l_parent_list_query_id || '<-');
1035: END IF;
1036: delete from ams_list_queries_all
1037: where parent_list_query_id = l_parent_list_query_id
1038: and sequence_order > l_no_of_records_upd ;

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

1049:
1050: -- Debug Message
1051: IF (AMS_DEBUG_HIGH_ON) THEN
1052:
1053: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1054: END IF;
1055:
1056: -- Standard call to get message count and if count is 1, get message info.
1057: FND_MSG_PUB.Count_And_Get

Line 1063: WHEN AMS_Utility_PVT.resource_locked THEN

1059: p_data => x_msg_data
1060: );
1061: EXCEPTION
1062:
1063: WHEN AMS_Utility_PVT.resource_locked THEN
1064: x_return_status := FND_API.g_ret_sts_error;
1065: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1066:
1067: WHEN FND_API.G_EXC_ERROR THEN

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

1061: EXCEPTION
1062:
1063: WHEN AMS_Utility_PVT.resource_locked THEN
1064: x_return_status := FND_API.g_ret_sts_error;
1065: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1066:
1067: WHEN FND_API.G_EXC_ERROR THEN
1068: ROLLBACK TO UPDATE_List_Query_PVT_tbl;
1069: x_return_status := FND_API.G_RET_STS_ERROR;

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

1139:
1140: -- Debug Message
1141: IF (AMS_DEBUG_HIGH_ON) THEN
1142:
1143: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1144: END IF;
1145:
1146:
1147: -- Initialize API return status to SUCCESS

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

1152: --
1153: -- Debug Message
1154: IF (AMS_DEBUG_HIGH_ON) THEN
1155:
1156: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1157: END IF;
1158:
1159: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Delete_Row)
1160: AMS_LIST_QUERIES_PKG.Delete_Row(

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

1172:
1173: -- Debug Message
1174: IF (AMS_DEBUG_HIGH_ON) THEN
1175:
1176: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1177: END IF;
1178:
1179: -- Standard call to get message count and if count is 1, get message info.
1180: FND_MSG_PUB.Count_And_Get

Line 1186: WHEN AMS_Utility_PVT.resource_locked THEN

1182: p_data => x_msg_data
1183: );
1184: EXCEPTION
1185:
1186: WHEN AMS_Utility_PVT.resource_locked THEN
1187: x_return_status := FND_API.g_ret_sts_error;
1188: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1189:
1190: WHEN FND_API.G_EXC_ERROR THEN

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

1184: EXCEPTION
1185:
1186: WHEN AMS_Utility_PVT.resource_locked THEN
1187: x_return_status := FND_API.g_ret_sts_error;
1188: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1189:
1190: WHEN FND_API.G_EXC_ERROR THEN
1191: ROLLBACK TO DELETE_List_Query_PVT;
1192: x_return_status := FND_API.G_RET_STS_ERROR;

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

1264:
1265: -- Debug Message
1266: IF (AMS_DEBUG_HIGH_ON) THEN
1267:
1268: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1269: END IF;
1270:
1271:
1272: -- Initialize API return status to SUCCESS

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

1277: --
1278: -- Debug Message
1279: IF (AMS_DEBUG_HIGH_ON) THEN
1280:
1281: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1282: END IF;
1283:
1284: open c_get_child_ids;
1285: loop

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

1302:
1303: -- Debug Message
1304: IF (AMS_DEBUG_HIGH_ON) THEN
1305:
1306: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1307: END IF;
1308:
1309: -- Standard call to get message count and if count is 1, get message info.
1310: FND_MSG_PUB.Count_And_Get

Line 1316: WHEN AMS_Utility_PVT.resource_locked THEN

1312: p_data => x_msg_data
1313: );
1314: EXCEPTION
1315:
1316: WHEN AMS_Utility_PVT.resource_locked THEN
1317: x_return_status := FND_API.g_ret_sts_error;
1318: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1319:
1320: WHEN FND_API.G_EXC_ERROR THEN

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

1314: EXCEPTION
1315:
1316: WHEN AMS_Utility_PVT.resource_locked THEN
1317: x_return_status := FND_API.g_ret_sts_error;
1318: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1319:
1320: WHEN FND_API.G_EXC_ERROR THEN
1321: ROLLBACK TO DELETE_List_Query_PVT_tbl;
1322: x_return_status := FND_API.G_RET_STS_ERROR;

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

1385:
1386: -- Debug Message
1387: IF (AMS_DEBUG_HIGH_ON) THEN
1388:
1389: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1390: END IF;
1391:
1392: -- Initialize message list if p_init_msg_list is set to TRUE.
1393: IF FND_API.to_Boolean( p_init_msg_list )

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

1414: IF (AMS_DEBUG_HIGH_ON) THEN
1415:
1416:
1417:
1418: AMS_Utility_PVT.debug_message(l_full_name||': start');
1419:
1420: END IF;
1421: OPEN c_List_Query;
1422:

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

1439: p_count => x_msg_count,
1440: p_data => x_msg_data);
1441: IF (AMS_DEBUG_HIGH_ON) THEN
1442:
1443: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1444: END IF;
1445: EXCEPTION
1446:
1447: WHEN AMS_Utility_PVT.resource_locked THEN

Line 1447: WHEN AMS_Utility_PVT.resource_locked THEN

1443: AMS_Utility_PVT.debug_message(l_full_name ||': end');
1444: END IF;
1445: EXCEPTION
1446:
1447: WHEN AMS_Utility_PVT.resource_locked THEN
1448: x_return_status := FND_API.g_ret_sts_error;
1449: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1450:
1451: WHEN FND_API.G_EXC_ERROR THEN

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

1445: EXCEPTION
1446:
1447: WHEN AMS_Utility_PVT.resource_locked THEN
1448: x_return_status := FND_API.g_ret_sts_error;
1449: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1450:
1451: WHEN FND_API.G_EXC_ERROR THEN
1452: ROLLBACK TO LOCK_List_Query_PVT;
1453: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1507: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

1503: x_return_status := FND_API.g_ret_sts_success;
1504:
1505: -- check for uniqueness of id
1506: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1507: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1508: 'AMS_LIST_QUERIES_ALL',
1509: 'LIST_QUERY_ID = ''' || p_list_query_rec.LIST_QUERY_ID ||''''
1510: );
1511: END IF;

Line 1514: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_LIST_QUERY_ID_DUPLICATE');

1510: );
1511: END IF;
1512:
1513: IF l_valid_flag = FND_API.g_false THEN
1514: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_LIST_QUERY_ID_DUPLICATE');
1515: x_return_status := FND_API.g_ret_sts_error;
1516: RETURN;
1517: END IF;
1518:

Line 1534: AMS_UTILITY_PVT.debug_message('parent id: ' || p_list_query_rec.parent_list_query_id );

1530: IF (AMS_DEBUG_HIGH_ON) THEN
1531:
1532:
1533:
1534: AMS_UTILITY_PVT.debug_message('parent id: ' || p_list_query_rec.parent_list_query_id );
1535:
1536: END IF;
1537: FND_MESSAGE.set_name('AMS', 'AMS_LIST_QUERY_DUPE_NAME');
1538: FND_MSG_PUB.add;

Line 1558: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_name');

1554:
1555: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1556:
1557: IF p_list_query_rec.name = FND_API.g_miss_char OR p_list_query_rec.name IS NULL THEN
1558: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_name');
1559: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1560: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_NAME');
1561: FND_MSG_PUB.Add;
1562: END IF;

Line 1570: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_act_list_query_used_by_id');

1566:
1567:
1568: /*
1569: IF p_list_query_rec.act_list_query_used_by_id = FND_API.g_miss_num OR p_list_query_rec.act_list_query_used_by_id IS NULL THEN
1570: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_act_list_query_used_by_id');
1571: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1572: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_USEDBY_ID');
1573: FND_MSG_PUB.Add;
1574: END IF;

Line 1582: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_arc_act_list_query_used_by');

1578:
1579:
1580:
1581: IF p_list_query_rec.arc_act_list_query_used_by = FND_API.g_miss_char OR p_list_query_rec.arc_act_list_query_used_by IS NULL THEN
1582: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_arc_act_list_query_used_by');
1583: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1584: FND_MESSAGE.Set_Name('AMS', 'AMS_LIST_QUERY_NO_USEDBY');
1585: FND_MSG_PUB.Add;
1586: END IF;

Line 1606: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_list_query_id');

1602: ELSE
1603:
1604:
1605: IF p_list_query_rec.list_query_id IS NULL THEN
1606: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_list_query_id');
1607: x_return_status := FND_API.g_ret_sts_error;
1608: RETURN;
1609: END IF;
1610:

Line 1613: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_name');

1609: END IF;
1610:
1611:
1612: IF p_list_query_rec.name IS NULL THEN
1613: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_name');
1614: x_return_status := FND_API.g_ret_sts_error;
1615: RETURN;
1616: END IF;
1617:

Line 1620: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_type');

1616: END IF;
1617:
1618:
1619: IF p_list_query_rec.type IS NULL THEN
1620: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_type');
1621: x_return_status := FND_API.g_ret_sts_error;
1622: RETURN;
1623: END IF;
1624:

Line 1627: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_enabled_flag');

1623: END IF;
1624:
1625:
1626: IF p_list_query_rec.enabled_flag IS NULL THEN
1627: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_enabled_flag');
1628: x_return_status := FND_API.g_ret_sts_error;
1629: RETURN;
1630: END IF;
1631:

Line 1634: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_primary_key');

1630: END IF;
1631:
1632:
1633: IF p_list_query_rec.primary_key IS NULL THEN
1634: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_primary_key');
1635: x_return_status := FND_API.g_ret_sts_error;
1636: RETURN;
1637: END IF;
1638:

Line 1641: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_public_flag');

1637: END IF;
1638:
1639:
1640: IF p_list_query_rec.public_flag IS NULL THEN
1641: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_query_NO_public_flag');
1642: x_return_status := FND_API.g_ret_sts_error;
1643: RETURN;
1644: END IF;
1645:

Line 1665: AMS_Utility_PVT.get_qual_table_name_and_pk(

1661: x_return_status := FND_API.g_ret_sts_success;
1662:
1663: IF p_list_query_rec.arc_act_list_query_used_by <> FND_API.g_miss_char THEN
1664:
1665: AMS_Utility_PVT.get_qual_table_name_and_pk(
1666: p_sys_qual => p_list_query_rec.arc_act_list_query_used_by,
1667: x_return_status => x_return_status,
1668: x_table_name => l_table_name,
1669: x_pk_name => l_pk_name

Line 1677: IF ( AMS_Utility_PVT.Check_FK_Exists(l_table_name

1673: RETURN;
1674: END IF;
1675:
1676: IF p_list_query_rec.act_list_query_used_by_id <> FND_API.g_miss_num THEN
1677: IF ( AMS_Utility_PVT.Check_FK_Exists(l_table_name
1678: , l_pk_name
1679: , p_list_query_rec.act_list_query_used_by_id)
1680: = FND_API.G_TRUE)
1681: THEN

Line 1692: END IF; -- end AMS_Utility_PVT.Check_FK_Exists

1688: FND_MSG_PUB.Add;
1689: END IF;
1690: x_return_status := FND_API.G_RET_STS_ERROR;
1691: RAISE FND_API.G_EXC_ERROR;
1692: END IF; -- end AMS_Utility_PVT.Check_FK_Exists
1693: END IF; -- end p_list_query_rec.act_list_query_used_by_id
1694: END IF; --end p_list_query_rec.arc_act_list_query_used_by <> FND_API.g_miss_char
1695:
1696: END check_list_query_FK_items;

Line 1708: IF AMS_Utility_PVT.check_lookup_exists(

1704: x_return_status := FND_API.g_ret_sts_success;
1705:
1706: ----------------------- arc_act_list_query_used_by ------------------------
1707: IF p_list_query_rec.arc_act_list_query_used_by <> FND_API.g_miss_char THEN
1708: IF AMS_Utility_PVT.check_lookup_exists(
1709: p_lookup_type => 'AMS_LIST_QUERY_TYPE',
1710: p_lookup_code => p_list_query_rec.arc_act_list_query_used_by
1711: ) = FND_API.g_false
1712: THEN

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

1949:
1950: -- Debug Message
1951: IF (AMS_DEBUG_HIGH_ON) THEN
1952:
1953: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1954: END IF;
1955:
1956:
1957: -- Initialize API return status to SUCCESS

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

1960:
1961: -- Debug Message
1962: IF (AMS_DEBUG_HIGH_ON) THEN
1963:
1964: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1965: END IF;
1966:
1967: -- Standard call to get message count and if count is 1, get message info.
1968: FND_MSG_PUB.Count_And_Get

Line 1974: WHEN AMS_Utility_PVT.resource_locked THEN

1970: p_data => x_msg_data
1971: );
1972: EXCEPTION
1973:
1974: WHEN AMS_Utility_PVT.resource_locked THEN
1975: x_return_status := FND_API.g_ret_sts_error;
1976: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1977:
1978: WHEN FND_API.G_EXC_ERROR THEN

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

1972: EXCEPTION
1973:
1974: WHEN AMS_Utility_PVT.resource_locked THEN
1975: x_return_status := FND_API.g_ret_sts_error;
1976: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1977:
1978: WHEN FND_API.G_EXC_ERROR THEN
1979: ROLLBACK TO VALIDATE_List_Query_;
1980: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2041: AMS_UTILITY_PVT.debug_message('Private API: Validate_query__rec->'

2037:
2038: -- Debug Message
2039: IF (AMS_DEBUG_HIGH_ON) THEN
2040:
2041: AMS_UTILITY_PVT.debug_message('Private API: Validate_query__rec->'
2042: || x_return_status);
2043: END IF;
2044: -- Standard call to get message count and if count is 1, get message info.
2045: FND_MSG_PUB.Count_And_Get