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_ADV_FILTER_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: -- Initialize API return status to SUCCESS
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:

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

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

Line 130: AMS_UTILITY_PVT.debug_message('Private API: Validate_Filter_Row');

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

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

146: END IF;
147:
148:
149: -- Debug Message
150: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
151:
152:
153: AMS_ADV_FILTER_PKG.Insert_Row
154: (

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

206: END IF;
207:
208:
209: -- Debug Message
210: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
211:
212: -- Standard call to get message count and if count is 1, get message info.
213: FND_MSG_PUB.Count_And_Get
214: (p_count => x_msg_count,

Line 220: WHEN AMS_Utility_PVT.resource_locked THEN

216: );
217:
218: EXCEPTION
219:
220: WHEN AMS_Utility_PVT.resource_locked THEN
221: x_return_status := FND_API.g_ret_sts_error;
222: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
223:
224: WHEN FND_API.G_EXC_ERROR THEN

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

218: EXCEPTION
219:
220: WHEN AMS_Utility_PVT.resource_locked THEN
221: x_return_status := FND_API.g_ret_sts_error;
222: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
223:
224: WHEN FND_API.G_EXC_ERROR THEN
225: ROLLBACK TO CREATE_Filter_Row_PVT;
226: x_return_status := FND_API.G_RET_STS_ERROR;

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

308: FND_MSG_PUB.initialize;
309: END IF;
310:
311: -- Debug Message
312: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
313:
314:
315: -- Initialize API return status to SUCCESS
316: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

319:
320: OPEN c_get_Filter_row(l_tar_filter_rec.query_param_id);
321: FETCH c_get_filter_row INTO l_ref_filter_rec ;
322: IF ( c_get_Filter_row%NOTFOUND) THEN
323: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
324: p_token_name => 'INFO',
325: p_token_value => 'Filter_Row'
326: ) ;
327: RAISE FND_API.G_EXC_ERROR;

Line 333: AMS_UTILITY_PVT.debug_message('Private API: Validate_Filter_Rec');

329: CLOSE c_get_filter_row;
330:
331: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
332: -- Debug message
333: AMS_UTILITY_PVT.debug_message('Private API: Validate_Filter_Rec');
334:
335: -- Invoke validation procedures
336: Validate_Filter_Row( p_api_version_number => 1.0,
337: p_init_msg_list => FND_API.G_FALSE,

Line 360: AMS_UTILITY_PVT.debug_message('Private API: Before Calling Table Update Row');

356: -- Added by nyostos on Oct 14, 2002
357: -- Check if the record has any changes
358: check_filter_changes(p_filter_rec, l_rec_changed);
359:
360: AMS_UTILITY_PVT.debug_message('Private API: Before Calling Table Update Row');
361:
362: AMS_ADV_FILTER_PKG.Update_Row(
363: px_query_param_id => p_filter_rec.query_param_id,
364: p_query_id => p_filter_rec.query_id,

Line 376: AMS_UTILITY_PVT.debug_message('Private API: After Update Row');

372: p_last_update_login => G_LOGIN_ID,
373: p_security_group_id => p_filter_rec.security_group_id
374: );
375:
376: AMS_UTILITY_PVT.debug_message('Private API: After Update Row');
377:
378: -- Added by nyostos on Oct 14, 2002
379: -- Adding a Filter record to a Model/Scoring Run data sets
380: -- may INVALIDATE the Model if it has already been built or the Scoring

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

406: THEN
407: COMMIT WORK;
408: END IF;
409:
410: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
411:
412: -- Standard call to get message count and if count is 1, get message info.
413: FND_MSG_PUB.Count_And_Get
414: (p_count => x_msg_count,

Line 419: WHEN AMS_Utility_PVT.resource_locked THEN

415: p_data => x_msg_data
416: );
417: EXCEPTION
418:
419: WHEN AMS_Utility_PVT.resource_locked THEN
420: x_return_status := FND_API.g_ret_sts_error;
421: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
422:
423: WHEN FND_API.G_EXC_ERROR THEN

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

417: EXCEPTION
418:
419: WHEN AMS_Utility_PVT.resource_locked THEN
420: x_return_status := FND_API.g_ret_sts_error;
421: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
422:
423: WHEN FND_API.G_EXC_ERROR THEN
424: ROLLBACK TO UPDATE_Filter_Row_PVT;
425: x_return_status := FND_API.G_RET_STS_ERROR;

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

502: FND_MSG_PUB.initialize;
503: END IF;
504:
505: -- Debug Message
506: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
507:
508:
509: -- Initialize API return status to SUCCESS
510: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

517: --
518: -- Api body
519: --
520: -- Debug Message
521: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
522:
523: AMS_ADV_FILTER_PKG.Delete_Row(
524: p_query_param_id => p_query_param_id);
525:

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

555: END IF;
556:
557:
558: -- Debug Message
559: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
560:
561: -- Standard call to get message count and if count is 1, get message info.
562: FND_MSG_PUB.Count_And_Get
563: (p_count => x_msg_count,

Line 568: WHEN AMS_Utility_PVT.resource_locked THEN

564: p_data => x_msg_data
565: );
566: EXCEPTION
567:
568: WHEN AMS_Utility_PVT.resource_locked THEN
569: x_return_status := FND_API.g_ret_sts_error;
570: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
571:
572: WHEN FND_API.G_EXC_ERROR THEN

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

566: EXCEPTION
567:
568: WHEN AMS_Utility_PVT.resource_locked THEN
569: x_return_status := FND_API.g_ret_sts_error;
570: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
571:
572: WHEN FND_API.G_EXC_ERROR THEN
573: ROLLBACK TO DELETE_Filter_Row_PVT;
574: x_return_status := FND_API.G_RET_STS_ERROR;

Line 626: -- AMS_Utility_PVT.check_uniqueness(

622: BEGIN
623: x_return_status := FND_API.g_ret_sts_success;
624: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
625: l_valid_flag := 'T';
626: -- AMS_Utility_PVT.check_uniqueness(
627: -- 'JTF_PERZ_QUERY_PARAM',
628: -- 'query_param_id = 0'
629: -- || p_filter_rec.query_param_id ||''''
630: -- );

Line 632: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

628: -- 'query_param_id = 0'
629: -- || p_filter_rec.query_param_id ||''''
630: -- );
631: ELSE
632: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
633: 'JTF_PERZ_QUERY_PARAM',
634: 'query_param_id= ''' || p_filter_rec.query_param_id ||
635: ''' AND query_param_id <> ' || p_filter_rec.query_param_id
636: );

Line 640: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_QUERY_PARAM_ID_DUPLICATE');

636: );
637: END IF;
638:
639: IF l_valid_flag = FND_API.g_false THEN
640: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_QUERY_PARAM_ID_DUPLICATE');
641: x_return_status := FND_API.g_ret_sts_error;
642: RETURN;
643: END IF;
644:

Line 661: AMS_UTILITY_PVT.debug_message('Private API: Inside check_filter_row_req_items');

657: x_return_status := FND_API.g_ret_sts_success;
658:
659: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
660:
661: AMS_UTILITY_PVT.debug_message('Private API: Inside check_filter_row_req_items');
662:
663: IF p_filter_rec.query_id = FND_API.g_miss_num OR p_filter_rec.query_id IS NULL THEN
664: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
665: FND_MESSAGE.set_token('MISS_FIELD','QUERY_ID');

Line 721: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_Filter_row_no_query_param_id');

717: END IF;
718: ELSE
719:
720: IF p_filter_rec.query_param_id IS NULL THEN
721: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_Filter_row_no_query_param_id');
722: x_return_status := FND_API.g_ret_sts_error;
723: RETURN;
724: END IF;
725:

Line 727: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_Filter_row_no_query_id');

723: RETURN;
724: END IF;
725:
726: IF p_filter_rec.query_id IS NULL THEN
727: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_Filter_row_no_query_id');
728: x_return_status := FND_API.g_ret_sts_error;
729: RETURN;
730: END IF;
731:

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

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

Line 739: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_Filter_row_no_parameter_type');

735: RETURN;
736: END IF;
737:
738: IF p_filter_rec.parameter_type IS NULL THEN
739: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_Filter_row_no_parameter_type');
740: x_return_status := FND_API.g_ret_sts_error;
741: RETURN;
742: END IF;
743:

Line 745: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_Filter_row_no_parameter_value');

741: RETURN;
742: END IF;
743:
744: IF p_filter_rec.parameter_value IS NULL THEN
745: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_Filter_row_no_parameter_value');
746: x_return_status := FND_API.g_ret_sts_error;
747: RETURN;
748: END IF;
749:

Line 751: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_Filter_row_no_parameter_condition');

747: RETURN;
748: END IF;
749:
750: IF p_filter_rec.parameter_condition IS NULL THEN
751: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_Filter_row_no_parameter_condition');
752: x_return_status := FND_API.g_ret_sts_error;
753: RETURN;
754: END IF;
755: END IF;

Line 769: AMS_UTILITY_PVT.debug_message('Private API: Inside Check Filter Items. Calling UK Items');

765: IS
766: BEGIN
767:
768: -- Check Items Uniqueness API calls
769: AMS_UTILITY_PVT.debug_message('Private API: Inside Check Filter Items. Calling UK Items');
770: check_filter_row_uk_items(
771: p_filter_rec => p_filter_rec,
772: p_validation_mode => p_validation_mode,
773: x_return_status => x_return_status);

Line 891: AMS_UTILITY_PVT.debug_message('Private API: Inside' || l_api_name );

887: BEGIN
888: -- Standard Start of API savepoint
889: SAVEPOINT VALIDATE_Filter_Row;
890:
891: AMS_UTILITY_PVT.debug_message('Private API: Inside' || l_api_name );
892:
893: -- Standard call to check for call compatibility.
894: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
895: p_api_version_number,

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

943: END IF;
944:
945:
946: -- Debug Message
947: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
948:
949:
950: -- Initialize API return status to SUCCESS
951: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

951: x_return_status := FND_API.G_RET_STS_SUCCESS;
952:
953:
954: -- Debug Message
955: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
956:
957: -- Standard call to get message count and if count is 1, get message info.
958: FND_MSG_PUB.Count_And_Get
959: (p_count => x_msg_count,

Line 964: WHEN AMS_Utility_PVT.resource_locked THEN

960: p_data => x_msg_data
961: );
962: EXCEPTION
963:
964: WHEN AMS_Utility_PVT.resource_locked THEN
965: x_return_status := FND_API.g_ret_sts_error;
966: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
967:
968: WHEN FND_API.G_EXC_ERROR THEN

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

962: EXCEPTION
963:
964: WHEN AMS_Utility_PVT.resource_locked THEN
965: x_return_status := FND_API.g_ret_sts_error;
966: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
967:
968: WHEN FND_API.G_EXC_ERROR THEN
969: ROLLBACK TO VALIDATE_Filter_Row;
970: x_return_status := FND_API.G_RET_STS_ERROR;

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

1027: -- THEN
1028: -- x_return_status := FND_API.G_RET_STS_ERROR;
1029:
1030: -- Debug Message
1031: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1032: -- Standard call to get message count and if count is 1, get message info.
1033: FND_MSG_PUB.Count_And_Get
1034: (p_count => x_msg_count,
1035: p_data => x_msg_data

Line 1133: AMS_UTILITY_PVT.debug_message('Private API: ' || 'Get_filter_date ' || 'Parameter Name is:: ' || l_parameterType);

1129: END IF;
1130:
1131: l_parameterType := p_objType||';'||to_char(p_objectId)||';'||to_char(p_dataSourceId);
1132:
1133: AMS_UTILITY_PVT.debug_message('Private API: ' || 'Get_filter_date ' || 'Parameter Name is:: ' || l_parameterType);
1134:
1135: l_iIndex := 0;
1136:
1137: OPEN c_filterRec(l_nQueryId,l_parameterType);

Line 1147: AMS_UTILITY_PVT.debug_message('Disabled attribute/Disabled Data Source/Disabled Data Source Association....raising exception');

1143: OPEN c_fieldName(to_number(l_curfilterRec.parameter_name) , p_dataSourceId);
1144: FETCH c_fieldName INTO l_fieldName;
1145: IF c_fieldName%NOTFOUND THEN
1146: CLOSE c_fieldName;
1147: AMS_UTILITY_PVT.debug_message('Disabled attribute/Disabled Data Source/Disabled Data Source Association....raising exception');
1148: AMS_Utility_PVT.error_message('AMS_FILTER_ATTRIBUTE_DISABLED');
1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END IF;
1151: CLOSE c_fieldName;

Line 1148: AMS_Utility_PVT.error_message('AMS_FILTER_ATTRIBUTE_DISABLED');

1144: FETCH c_fieldName INTO l_fieldName;
1145: IF c_fieldName%NOTFOUND THEN
1146: CLOSE c_fieldName;
1147: AMS_UTILITY_PVT.debug_message('Disabled attribute/Disabled Data Source/Disabled Data Source Association....raising exception');
1148: AMS_Utility_PVT.error_message('AMS_FILTER_ATTRIBUTE_DISABLED');
1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END IF;
1151: CLOSE c_fieldName;
1152:

Line 1153: AMS_UTILITY_PVT.debug_message('Private API: ' || 'Get_filter_data ' || 'field Name is:: ' || l_fieldName);

1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END IF;
1151: CLOSE c_fieldName;
1152:
1153: AMS_UTILITY_PVT.debug_message('Private API: ' || 'Get_filter_data ' || 'field Name is:: ' || l_fieldName);
1154:
1155: l_filterRec.query_param_id := l_curfilterRec.query_param_id;
1156: l_filterRec.query_id := l_nQueryId;
1157: l_filterRec.parameter_name := l_fieldName;

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

1335: IF FND_API.to_Boolean( p_init_msg_list )THEN
1336: FND_MSG_PUB.initialize;
1337: END IF;
1338:
1339: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
1340:
1341: -- Initialize API return status to SUCCESS
1342: x_return_status := FND_API.G_RET_STS_SUCCESS;
1343:

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

1416: END IF;
1417:
1418:
1419: -- Debug Message
1420: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1421:
1422: -- Standard call to get message count and if count is 1, get message info.
1423: FND_MSG_PUB.Count_And_Get (
1424: p_count => x_msg_count,