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 FND_API

Line 41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

37:
38: PROCEDURE Create_Filter_Row
39: (
40: p_api_version_number IN NUMBER,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,

Line 42: p_commit IN VARCHAR2 := FND_API.G_FALSE,

38: PROCEDURE Create_Filter_Row
39: (
40: p_api_version_number IN NUMBER,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,

Line 43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

39: (
40: p_api_version_number IN NUMBER,
41: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
42: p_commit IN VARCHAR2 := FND_API.G_FALSE,
43: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_filter_rec IN filter_rec_type := g_miss_filter_rec,

Line 55: l_org_id NUMBER := FND_API.G_MISS_NUM;

51: IS
52: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Filter_Row';
53: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
54: l_return_status_full VARCHAR2(1);
55: l_org_id NUMBER := FND_API.G_MISS_NUM;
56: l_query_param_id NUMBER;
57: l_dummy NUMBER;
58:
59: l_filter_rec filter_rec_type := p_filter_rec;

Line 80: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

76: -- Standard Start of API savepoint
77: SAVEPOINT CREATE_Filter_Row_PVT;
78:
79: -- Standard call to check for call compatibility.
80: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
81: p_api_version_number,
82: l_api_name,
83: G_PKG_NAME)
84: THEN

Line 85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

81: p_api_version_number,
82: l_api_name,
83: G_PKG_NAME)
84: THEN
85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87:
88: -- Initialize message list if p_init_msg_list is set to TRUE.
89: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 89: IF FND_API.to_Boolean( p_init_msg_list ) THEN

85: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
86: END IF;
87:
88: -- Initialize message list if p_init_msg_list is set to TRUE.
89: IF FND_API.to_Boolean( p_init_msg_list ) THEN
90: FND_MSG_PUB.initialize;
91: END IF;
92:
93: -- Debug Message

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
99: -- Local variable initialization
100: IF l_filter_rec.query_param_id IS NULL OR l_filter_rec.query_param_id = FND_API.g_miss_num THEN
101: LOOP

Line 100: IF l_filter_rec.query_param_id IS NULL OR l_filter_rec.query_param_id = FND_API.g_miss_num THEN

96: -- Initialize API return status to SUCCESS
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: -- Local variable initialization
100: IF l_filter_rec.query_param_id IS NULL OR l_filter_rec.query_param_id = FND_API.g_miss_num THEN
101: LOOP
102: l_dummy := NULL;
103: OPEN c_id;
104: FETCH c_id INTO l_query_param_id;

Line 125: RAISE FND_API.G_EXC_ERROR;

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
129: -- Debug message

Line 128: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) 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
129: -- Debug message
130: AMS_UTILITY_PVT.debug_message('Private API: Validate_Filter_Row');
131:
132: -- Invoke validation procedures

Line 135: p_init_msg_list => FND_API.G_FALSE,

131:
132: -- Invoke validation procedures
133: Validate_Filter_Row(
134: p_api_version_number => 1.0,
135: p_init_msg_list => FND_API.G_FALSE,
136: p_validation_level => p_validation_level,
137: p_validation_mode => JTF_PLSQL_API.g_create,
138: p_filter_rec => l_filter_rec,
139: x_return_status => x_return_status,

Line 144: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

140: x_msg_count => x_msg_count,
141: x_msg_data => x_msg_data);
142: END IF;
143:
144: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147:
148:

Line 145: RAISE FND_API.G_EXC_ERROR;

141: x_msg_data => x_msg_data);
142: END IF;
143:
144: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147:
148:
149: -- Debug Message

Line 176: IF l_parameter_type IS NOT NULL AND l_parameter_type <> FND_API.g_miss_char THEN

172: -- Adding a Filter record to a Model/Scoring Run data sets
173: -- may INVALIDATE the Model if it has already been built or the Scoring
174: -- Run if it has already run. Call the appropriate procedure to check.
175: l_parameter_type := l_filter_rec.parameter_type;
176: IF l_parameter_type IS NOT NULL AND l_parameter_type <> FND_API.g_miss_char THEN
177:
178: l_obj_type := SUBSTR(l_parameter_type, 1, INSTR(l_parameter_type, ';') - 1);
179:
180: IF l_obj_type IN ('MODL', 'SCOR') THEN

Line 194: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

190: END IF;
191: END IF;
192: -- End of addition by nyostos.
193:
194: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;
197:
198: --

Line 195: RAISE FND_API.G_EXC_ERROR;

191: END IF;
192: -- End of addition by nyostos.
193:
194: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;
197:
198: --
199: -- End of API body

Line 203: IF FND_API.to_Boolean( p_commit )

199: -- End of API body
200: --
201:
202: -- Standard check for p_commit
203: IF FND_API.to_Boolean( p_commit )
204: THEN
205: COMMIT WORK;
206: END IF;
207:

Line 221: x_return_status := FND_API.g_ret_sts_error;

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
225: ROLLBACK TO CREATE_Filter_Row_PVT;

Line 224: WHEN FND_API.G_EXC_ERROR THEN

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;
227: -- Standard call to get message count and if count=1, get the message
228: FND_MSG_PUB.Count_And_Get (

Line 226: 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;
227: -- Standard call to get message count and if count=1, get the message
228: FND_MSG_PUB.Count_And_Get (
229: p_encoded => FND_API.G_FALSE,
230: p_count => x_msg_count,

Line 229: p_encoded => FND_API.G_FALSE,

225: ROLLBACK TO CREATE_Filter_Row_PVT;
226: x_return_status := FND_API.G_RET_STS_ERROR;
227: -- Standard call to get message count and if count=1, get the message
228: FND_MSG_PUB.Count_And_Get (
229: p_encoded => FND_API.G_FALSE,
230: p_count => x_msg_count,
231: p_data => x_msg_data
232: );
233:

Line 234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

230: p_count => x_msg_count,
231: p_data => x_msg_data
232: );
233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO CREATE_Filter_Row_PVT;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: -- Standard call to get message count and if count=1, get the message
238: FND_MSG_PUB.Count_And_Get (

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

232: );
233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO CREATE_Filter_Row_PVT;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: -- Standard call to get message count and if count=1, get the message
238: FND_MSG_PUB.Count_And_Get (
239: p_encoded => FND_API.G_FALSE,
240: p_count => x_msg_count,

Line 239: p_encoded => FND_API.G_FALSE,

235: ROLLBACK TO CREATE_Filter_Row_PVT;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: -- Standard call to get message count and if count=1, get the message
238: FND_MSG_PUB.Count_And_Get (
239: p_encoded => FND_API.G_FALSE,
240: p_count => x_msg_count,
241: p_data => x_msg_data
242: );
243:

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

242: );
243:
244: WHEN OTHERS THEN
245: ROLLBACK TO CREATE_Filter_Row_PVT;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
248: THEN
249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
250: END IF;

Line 253: p_encoded => FND_API.G_FALSE,

249: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
250: END IF;
251: -- Standard call to get message count and if count=1, get the message
252: FND_MSG_PUB.Count_And_Get (
253: p_encoded => FND_API.G_FALSE,
254: p_count => x_msg_count,
255: p_data => x_msg_data
256: );
257: End Create_Filter_Row;

Line 262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

258:
259:
260: PROCEDURE Update_Filter_Row(
261: p_api_version_number IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,

Line 263: p_commit IN VARCHAR2 := FND_API.G_FALSE,

259:
260: PROCEDURE Update_Filter_Row(
261: p_api_version_number IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2,

Line 264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

260: PROCEDURE Update_Filter_Row(
261: p_api_version_number IN NUMBER,
262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265: x_return_status OUT NOCOPY VARCHAR2,
266: x_msg_count OUT NOCOPY NUMBER,
267: x_msg_data OUT NOCOPY VARCHAR2,
268: p_filter_rec IN filter_rec_type

Line 297: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

293: -- Standard Start of API savepoint
294: SAVEPOINT UPDATE_Filter_Row_PVT;
295:
296: -- Standard call to check for call compatibility.
297: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
298: p_api_version_number,
299: l_api_name,
300: G_PKG_NAME)
301: THEN

Line 302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

298: p_api_version_number,
299: l_api_name,
300: G_PKG_NAME)
301: THEN
302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
303: END IF;
304:
305: -- Initialize message list if p_init_msg_list is set to TRUE.
306: IF FND_API.to_Boolean( p_init_msg_list )

Line 306: IF FND_API.to_Boolean( p_init_msg_list )

302: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
303: END IF;
304:
305: -- Initialize message list if p_init_msg_list is set to TRUE.
306: IF FND_API.to_Boolean( p_init_msg_list )
307: THEN
308: FND_MSG_PUB.initialize;
309: END IF;
310:

Line 316: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
317:
318: l_query_param_id := l_tar_filter_rec.query_param_id;
319:
320: OPEN c_get_Filter_row(l_tar_filter_rec.query_param_id);

Line 327: RAISE FND_API.G_EXC_ERROR;

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;
328: END IF;
329: CLOSE c_get_filter_row;
330:
331: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 331: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

327: RAISE FND_API.G_EXC_ERROR;
328: END IF;
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

Line 337: p_init_msg_list => FND_API.G_FALSE,

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,
338: p_validation_level => p_validation_level,
339: p_validation_mode => JTF_PLSQL_API.g_update,
340: p_filter_rec => l_filter_rec,
341: x_return_status => x_return_status,

Line 347: p_encoded => FND_API.G_FALSE,

343: x_msg_data => x_msg_data);
344: END IF;
345:
346: FND_MSG_PUB.Count_And_Get (
347: p_encoded => FND_API.G_FALSE,
348: p_count => x_msg_count,
349: p_data => x_msg_data
350: );
351:

Line 352: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

348: p_count => x_msg_count,
349: p_data => x_msg_data
350: );
351:
352: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
353: RAISE FND_API.G_EXC_ERROR;
354: END IF;
355:
356: -- Added by nyostos on Oct 14, 2002

Line 353: RAISE FND_API.G_EXC_ERROR;

349: p_data => x_msg_data
350: );
351:
352: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
353: RAISE FND_API.G_EXC_ERROR;
354: END IF;
355:
356: -- Added by nyostos on Oct 14, 2002
357: -- Check if the record has any changes

Line 385: IF l_parameter_type IS NOT NULL AND l_parameter_type <> FND_API.g_miss_char THEN

381: -- Run if it has already run. Call the appropriate procedure to check.
382: l_parameter_type := p_filter_rec.parameter_type;
383:
384: IF l_rec_changed = 'Y' THEN
385: IF l_parameter_type IS NOT NULL AND l_parameter_type <> FND_API.g_miss_char THEN
386:
387: l_obj_type := SUBSTR(l_parameter_type, 1, INSTR(l_parameter_type,';') - 1);
388:
389: IF l_obj_type IN ('MODL', 'SCOR') THEN

Line 405: IF FND_API.to_Boolean( p_commit )

401: END IF;
402: -- End of addition by nyostos.
403:
404: -- Standard check for p_commit
405: IF FND_API.to_Boolean( p_commit )
406: THEN
407: COMMIT WORK;
408: END IF;
409:

Line 420: x_return_status := FND_API.g_ret_sts_error;

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
424: ROLLBACK TO UPDATE_Filter_Row_PVT;

Line 423: WHEN FND_API.G_EXC_ERROR THEN

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;
426: -- Standard call to get message count and if count=1, get the message
427: FND_MSG_PUB.Count_And_Get (

Line 425: 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;
426: -- Standard call to get message count and if count=1, get the message
427: FND_MSG_PUB.Count_And_Get (
428: p_encoded => FND_API.G_FALSE,
429: p_count => x_msg_count,

Line 428: p_encoded => FND_API.G_FALSE,

424: ROLLBACK TO UPDATE_Filter_Row_PVT;
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: -- Standard call to get message count and if count=1, get the message
427: FND_MSG_PUB.Count_And_Get (
428: p_encoded => FND_API.G_FALSE,
429: p_count => x_msg_count,
430: p_data => x_msg_data
431: );
432:

Line 433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

429: p_count => x_msg_count,
430: p_data => x_msg_data
431: );
432:
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: ROLLBACK TO UPDATE_Filter_Row_PVT;
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
436: -- Standard call to get message count and if count=1, get the message
437: FND_MSG_PUB.Count_And_Get (

Line 435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

431: );
432:
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: ROLLBACK TO UPDATE_Filter_Row_PVT;
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
436: -- Standard call to get message count and if count=1, get the message
437: FND_MSG_PUB.Count_And_Get (
438: p_encoded => FND_API.G_FALSE,
439: p_count => x_msg_count,

Line 438: p_encoded => FND_API.G_FALSE,

434: ROLLBACK TO UPDATE_Filter_Row_PVT;
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
436: -- Standard call to get message count and if count=1, get the message
437: FND_MSG_PUB.Count_And_Get (
438: p_encoded => FND_API.G_FALSE,
439: p_count => x_msg_count,
440: p_data => x_msg_data
441: );
442:

Line 445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

441: );
442:
443: WHEN OTHERS THEN
444: ROLLBACK TO UPDATE_Filter_Row_PVT;
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
447: THEN
448: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
449: END IF;

Line 452: p_encoded => FND_API.G_FALSE,

448: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
449: END IF;
450: -- Standard call to get message count and if count=1, get the message
451: FND_MSG_PUB.Count_And_Get (
452: p_encoded => FND_API.G_FALSE,
453: p_count => x_msg_count,
454: p_data => x_msg_data
455: );
456: End Update_Filter_Row;

Line 462: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

458:
459: PROCEDURE Delete_Filter_Row
460: (
461: p_api_version_number IN NUMBER,
462: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
463: p_commit IN VARCHAR2 := FND_API.G_FALSE,
464: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
465: x_return_status OUT NOCOPY VARCHAR2,
466: x_msg_count OUT NOCOPY NUMBER,

Line 463: p_commit IN VARCHAR2 := FND_API.G_FALSE,

459: PROCEDURE Delete_Filter_Row
460: (
461: p_api_version_number IN NUMBER,
462: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
463: p_commit IN VARCHAR2 := FND_API.G_FALSE,
464: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
465: x_return_status OUT NOCOPY VARCHAR2,
466: x_msg_count OUT NOCOPY NUMBER,
467: x_msg_data OUT NOCOPY VARCHAR2,

Line 464: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

460: (
461: p_api_version_number IN NUMBER,
462: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
463: p_commit IN VARCHAR2 := FND_API.G_FALSE,
464: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
465: x_return_status OUT NOCOPY VARCHAR2,
466: x_msg_count OUT NOCOPY NUMBER,
467: x_msg_data OUT NOCOPY VARCHAR2,
468: p_query_param_id IN NUMBER

Line 491: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

487: -- Standard Start of API savepoint
488: SAVEPOINT DELETE_Filter_Row_PVT;
489:
490: -- Standard call to check for call compatibility.
491: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
492: p_api_version_number,
493: l_api_name,
494: G_PKG_NAME)
495: THEN

Line 496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

492: p_api_version_number,
493: l_api_name,
494: G_PKG_NAME)
495: THEN
496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498:
499: -- Initialize message list if p_init_msg_list is set to TRUE.
500: IF FND_API.to_Boolean( p_init_msg_list )

Line 500: IF FND_API.to_Boolean( p_init_msg_list )

496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
497: END IF;
498:
499: -- Initialize message list if p_init_msg_list is set to TRUE.
500: IF FND_API.to_Boolean( p_init_msg_list )
501: THEN
502: FND_MSG_PUB.initialize;
503: END IF;
504:

Line 510: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
511:
512: -- Get the parameter type
513: OPEN c_get_parameter_type(p_query_param_id);
514: FETCH c_get_parameter_type INTO l_parameter_type;

Line 530: IF l_parameter_type IS NOT NULL AND l_parameter_type <> FND_API.g_miss_char THEN

526: -- Added by nyostos on Oct 14, 2002
527: -- Adding a Filter record to a Model/Scoring Run data sets
528: -- may INVALIDATE the Model if it has already been built or the Scoring
529: -- Run if it has already run. Call the appropriate procedure to check.
530: IF l_parameter_type IS NOT NULL AND l_parameter_type <> FND_API.g_miss_char THEN
531:
532: l_obj_type := SUBSTR(l_parameter_type, 1, INSTR(l_parameter_type,';') - 1);
533:
534: IF l_obj_type IN ('MODL', 'SCOR') THEN

Line 552: IF FND_API.to_Boolean( p_commit )

548:
549: -- End of API body
550:
551: -- Standard check for p_commit
552: IF FND_API.to_Boolean( p_commit )
553: THEN
554: COMMIT WORK;
555: END IF;
556:

Line 569: x_return_status := FND_API.g_ret_sts_error;

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
573: ROLLBACK TO DELETE_Filter_Row_PVT;

Line 572: WHEN FND_API.G_EXC_ERROR THEN

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;
575: -- Standard call to get message count and if count=1, get the message
576: FND_MSG_PUB.Count_And_Get (

Line 574: 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;
575: -- Standard call to get message count and if count=1, get the message
576: FND_MSG_PUB.Count_And_Get (
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,

Line 577: p_encoded => FND_API.G_FALSE,

573: ROLLBACK TO DELETE_Filter_Row_PVT;
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: -- Standard call to get message count and if count=1, get the message
576: FND_MSG_PUB.Count_And_Get (
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,
579: p_data => x_msg_data
580: );
581:

Line 582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

578: p_count => x_msg_count,
579: p_data => x_msg_data
580: );
581:
582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
583: ROLLBACK TO DELETE_Filter_Row_PVT;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: -- Standard call to get message count and if count=1, get the message
586: FND_MSG_PUB.Count_And_Get (

Line 584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

580: );
581:
582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
583: ROLLBACK TO DELETE_Filter_Row_PVT;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: -- Standard call to get message count and if count=1, get the message
586: FND_MSG_PUB.Count_And_Get (
587: p_encoded => FND_API.G_FALSE,
588: p_count => x_msg_count,

Line 587: p_encoded => FND_API.G_FALSE,

583: ROLLBACK TO DELETE_Filter_Row_PVT;
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: -- Standard call to get message count and if count=1, get the message
586: FND_MSG_PUB.Count_And_Get (
587: p_encoded => FND_API.G_FALSE,
588: p_count => x_msg_count,
589: p_data => x_msg_data
590: );
591:

Line 594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

590: );
591:
592: WHEN OTHERS THEN
593: ROLLBACK TO DELETE_Filter_Row_PVT;
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
596: THEN
597: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
598: END IF;

Line 601: p_encoded => FND_API.G_FALSE,

597: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
598: END IF;
599: -- Standard call to get message count and if count=1, get the message
600: FND_MSG_PUB.Count_And_Get (
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_msg_count,
603: p_data => x_msg_data
604: );
605: End Delete_Filter_Row;

Line 623: x_return_status := FND_API.g_ret_sts_success;

619: l_valid_flag VARCHAR2(1);
620:
621:
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',

Line 639: IF l_valid_flag = FND_API.g_false THEN

635: ''' AND query_param_id <> ' || p_filter_rec.query_param_id
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;

Line 641: x_return_status := FND_API.g_ret_sts_error;

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:
645: END check_filter_row_uk_items;

Line 657: x_return_status := FND_API.g_ret_sts_success;

653:
654: IS
655:
656: BEGIN
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');

Line 663: IF p_filter_rec.query_id = FND_API.g_miss_num OR p_filter_rec.query_id IS NULL THEN

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');
666: x_return_status := FND_API.g_ret_sts_error;
667: RETURN;

Line 666: x_return_status := FND_API.g_ret_sts_error;

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');
666: x_return_status := FND_API.g_ret_sts_error;
667: RETURN;
668: END IF;
669:
670: IF p_filter_rec.parameter_name = FND_API.g_miss_char OR p_filter_rec.parameter_name IS NULL THEN

Line 670: IF p_filter_rec.parameter_name = FND_API.g_miss_char OR p_filter_rec.parameter_name IS NULL THEN

666: x_return_status := FND_API.g_ret_sts_error;
667: RETURN;
668: END IF;
669:
670: IF p_filter_rec.parameter_name = FND_API.g_miss_char OR p_filter_rec.parameter_name IS NULL THEN
671: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
672: FND_MESSAGE.set_token('MISS_FIELD','PAREMETER_NAME');
673: x_return_status := FND_API.g_ret_sts_error;
674: RETURN;

Line 673: x_return_status := FND_API.g_ret_sts_error;

669:
670: IF p_filter_rec.parameter_name = FND_API.g_miss_char OR p_filter_rec.parameter_name IS NULL THEN
671: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
672: FND_MESSAGE.set_token('MISS_FIELD','PAREMETER_NAME');
673: x_return_status := FND_API.g_ret_sts_error;
674: RETURN;
675: END IF;
676:
677: IF p_filter_rec.parameter_type = FND_API.g_miss_char OR p_filter_rec.parameter_type IS NULL THEN

Line 677: IF p_filter_rec.parameter_type = FND_API.g_miss_char OR p_filter_rec.parameter_type IS NULL THEN

673: x_return_status := FND_API.g_ret_sts_error;
674: RETURN;
675: END IF;
676:
677: IF p_filter_rec.parameter_type = FND_API.g_miss_char OR p_filter_rec.parameter_type IS NULL THEN
678: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
679: FND_MESSAGE.set_token('MISS_FIELD','PARAMETER_NAME');
680: x_return_status := FND_API.g_ret_sts_error;
681: RETURN;

Line 680: x_return_status := FND_API.g_ret_sts_error;

676:
677: IF p_filter_rec.parameter_type = FND_API.g_miss_char OR p_filter_rec.parameter_type IS NULL THEN
678: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
679: FND_MESSAGE.set_token('MISS_FIELD','PARAMETER_NAME');
680: x_return_status := FND_API.g_ret_sts_error;
681: RETURN;
682: END IF;
683:
684: IF p_filter_rec.parameter_value = FND_API.g_miss_char OR p_filter_rec.parameter_value IS NULL THEN

Line 684: IF p_filter_rec.parameter_value = FND_API.g_miss_char OR p_filter_rec.parameter_value IS NULL THEN

680: x_return_status := FND_API.g_ret_sts_error;
681: RETURN;
682: END IF;
683:
684: IF p_filter_rec.parameter_value = FND_API.g_miss_char OR p_filter_rec.parameter_value IS NULL THEN
685: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
686: FND_MESSAGE.set_token('MISS_FIELD','PAREMETER_VALUE');
687: x_return_status := FND_API.g_ret_sts_error;
688: RETURN;

Line 687: x_return_status := FND_API.g_ret_sts_error;

683:
684: IF p_filter_rec.parameter_value = FND_API.g_miss_char OR p_filter_rec.parameter_value IS NULL THEN
685: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
686: FND_MESSAGE.set_token('MISS_FIELD','PAREMETER_VALUE');
687: x_return_status := FND_API.g_ret_sts_error;
688: RETURN;
689: END IF;
690:
691: IF p_filter_rec.parameter_condition = FND_API.g_miss_char OR p_filter_rec.parameter_condition IS NULL THEN

Line 691: IF p_filter_rec.parameter_condition = FND_API.g_miss_char OR p_filter_rec.parameter_condition IS NULL THEN

687: x_return_status := FND_API.g_ret_sts_error;
688: RETURN;
689: END IF;
690:
691: IF p_filter_rec.parameter_condition = FND_API.g_miss_char OR p_filter_rec.parameter_condition IS NULL THEN
692: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
693: FND_MESSAGE.set_token('MISS_FIELD','PAREMETER_CONDITION');
694: x_return_status := FND_API.g_ret_sts_error;
695: RETURN;

Line 694: x_return_status := FND_API.g_ret_sts_error;

690:
691: IF p_filter_rec.parameter_condition = FND_API.g_miss_char OR p_filter_rec.parameter_condition IS NULL THEN
692: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
693: FND_MESSAGE.set_token('MISS_FIELD','PAREMETER_CONDITION');
694: x_return_status := FND_API.g_ret_sts_error;
695: RETURN;
696: END IF;
697:
698: IF p_filter_rec.created_by = FND_API.g_miss_num OR p_filter_rec.created_by IS NULL THEN

Line 698: IF p_filter_rec.created_by = FND_API.g_miss_num OR p_filter_rec.created_by IS NULL THEN

694: x_return_status := FND_API.g_ret_sts_error;
695: RETURN;
696: END IF;
697:
698: IF p_filter_rec.created_by = FND_API.g_miss_num OR p_filter_rec.created_by IS NULL THEN
699: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
700: FND_MESSAGE.set_token('MISS_FIELD','CREATED_BY');
701: x_return_status := FND_API.g_ret_sts_error;
702: RETURN;

Line 701: x_return_status := FND_API.g_ret_sts_error;

697:
698: IF p_filter_rec.created_by = FND_API.g_miss_num OR p_filter_rec.created_by IS NULL THEN
699: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
700: FND_MESSAGE.set_token('MISS_FIELD','CREATED_BY');
701: x_return_status := FND_API.g_ret_sts_error;
702: RETURN;
703: END IF;
704:
705: IF p_filter_rec.last_updated_by = FND_API.g_miss_num OR p_filter_rec.last_updated_by IS NULL THEN

Line 705: IF p_filter_rec.last_updated_by = FND_API.g_miss_num OR p_filter_rec.last_updated_by IS NULL THEN

701: x_return_status := FND_API.g_ret_sts_error;
702: RETURN;
703: END IF;
704:
705: IF p_filter_rec.last_updated_by = FND_API.g_miss_num OR p_filter_rec.last_updated_by IS NULL THEN
706: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
707: FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATED_BY');
708: x_return_status := FND_API.g_ret_sts_error;
709: RETURN;

Line 708: x_return_status := FND_API.g_ret_sts_error;

704:
705: IF p_filter_rec.last_updated_by = FND_API.g_miss_num OR p_filter_rec.last_updated_by IS NULL THEN
706: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
707: FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATED_BY');
708: x_return_status := FND_API.g_ret_sts_error;
709: RETURN;
710: END IF;
711:
712: IF p_filter_rec.last_update_date = FND_API.g_miss_date OR p_filter_rec.last_update_date IS NULL THEN

Line 712: IF p_filter_rec.last_update_date = FND_API.g_miss_date OR p_filter_rec.last_update_date IS NULL THEN

708: x_return_status := FND_API.g_ret_sts_error;
709: RETURN;
710: END IF;
711:
712: IF p_filter_rec.last_update_date = FND_API.g_miss_date OR p_filter_rec.last_update_date IS NULL THEN
713: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
714: FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATE_DATE');
715: x_return_status := FND_API.g_ret_sts_error;
716: RETURN;

Line 715: x_return_status := FND_API.g_ret_sts_error;

711:
712: IF p_filter_rec.last_update_date = FND_API.g_miss_date OR p_filter_rec.last_update_date IS NULL THEN
713: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_FIELD');
714: FND_MESSAGE.set_token('MISS_FIELD','LAST_UPDATE_DATE');
715: x_return_status := FND_API.g_ret_sts_error;
716: RETURN;
717: END IF;
718: ELSE
719:

Line 722: x_return_status := FND_API.g_ret_sts_error;

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:
726: IF p_filter_rec.query_id IS NULL THEN

Line 728: x_return_status := FND_API.g_ret_sts_error;

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:
732: IF p_filter_rec.parameter_name IS NULL THEN

Line 734: x_return_status := FND_API.g_ret_sts_error;

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:
738: IF p_filter_rec.parameter_type IS NULL THEN

Line 740: x_return_status := FND_API.g_ret_sts_error;

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:
744: IF p_filter_rec.parameter_value IS NULL THEN

Line 746: x_return_status := FND_API.g_ret_sts_error;

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:
750: IF p_filter_rec.parameter_condition IS NULL THEN

Line 752: x_return_status := FND_API.g_ret_sts_error;

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;
756:

Line 774: IF x_return_status <> FND_API.g_ret_sts_success THEN

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);
774: IF x_return_status <> FND_API.g_ret_sts_success THEN
775: RETURN;
776: END IF;
777:
778: -- Check Items Required/NOT NULL API calls

Line 784: IF x_return_status <> FND_API.g_ret_sts_success THEN

780: check_filter_row_req_items(
781: p_filter_rec => p_filter_rec,
782: p_validation_mode => p_validation_mode,
783: x_return_status => x_return_status);
784: IF x_return_status <> FND_API.g_ret_sts_success THEN
785: RETURN;
786: END IF;
787:
788: END Check_filter_Items;

Line 815: IF p_filter_rec.query_param_id = FND_API.g_miss_num THEN

811: FETCH c_complete INTO l_filter_rec;
812: CLOSE c_complete;
813:
814: -- query_param_id
815: IF p_filter_rec.query_param_id = FND_API.g_miss_num THEN
816: x_complete_rec.query_param_id := l_filter_rec.query_param_id;
817: END IF;
818:
819: -- parameter_name

Line 820: IF p_filter_rec.parameter_name = FND_API.g_miss_char THEN

816: x_complete_rec.query_param_id := l_filter_rec.query_param_id;
817: END IF;
818:
819: -- parameter_name
820: IF p_filter_rec.parameter_name = FND_API.g_miss_char THEN
821: x_complete_rec.parameter_name := l_filter_rec.parameter_name;
822: END IF;
823:
824: -- parameter_type

Line 825: IF p_filter_rec.parameter_type = FND_API.g_miss_char THEN

821: x_complete_rec.parameter_name := l_filter_rec.parameter_name;
822: END IF;
823:
824: -- parameter_type
825: IF p_filter_rec.parameter_type = FND_API.g_miss_char THEN
826: x_complete_rec.parameter_type := l_filter_rec.parameter_type;
827: END IF;
828:
829: -- parameter_value

Line 830: IF p_filter_rec.parameter_value = FND_API.g_miss_char THEN

826: x_complete_rec.parameter_type := l_filter_rec.parameter_type;
827: END IF;
828:
829: -- parameter_value
830: IF p_filter_rec.parameter_value = FND_API.g_miss_char THEN
831: x_complete_rec.parameter_value := l_filter_rec.parameter_value;
832: END IF;
833:
834: -- parameter_condition

Line 835: IF p_filter_rec.parameter_condition = FND_API.g_miss_char THEN

831: x_complete_rec.parameter_value := l_filter_rec.parameter_value;
832: END IF;
833:
834: -- parameter_condition
835: IF p_filter_rec.parameter_condition = FND_API.g_miss_char THEN
836: x_complete_rec.parameter_condition := l_filter_rec.parameter_condition;
837: END IF;
838:
839:

Line 841: IF p_filter_rec.created_by = FND_API.g_miss_num THEN

837: END IF;
838:
839:
840: -- created_by
841: IF p_filter_rec.created_by = FND_API.g_miss_num THEN
842: x_complete_rec.created_by := l_filter_rec.created_by;
843: END IF;
844:
845:

Line 847: IF p_filter_rec.last_updated_by = FND_API.g_miss_num THEN

843: END IF;
844:
845:
846: -- last_updated_by
847: IF p_filter_rec.last_updated_by = FND_API.g_miss_num THEN
848: x_complete_rec.last_updated_by := l_filter_rec.last_updated_by;
849: END IF;
850:
851: -- last_update_date

Line 852: IF p_filter_rec.last_update_date = FND_API.g_miss_date THEN

848: x_complete_rec.last_updated_by := l_filter_rec.last_updated_by;
849: END IF;
850:
851: -- last_update_date
852: IF p_filter_rec.last_update_date = FND_API.g_miss_date THEN
853: x_complete_rec.last_update_date := l_filter_rec.last_update_date;
854: END IF;
855:
856: -- last_update_login

Line 857: IF p_filter_rec.last_update_login = FND_API.g_miss_num THEN

853: x_complete_rec.last_update_date := l_filter_rec.last_update_date;
854: END IF;
855:
856: -- last_update_login
857: IF p_filter_rec.last_update_login = FND_API.g_miss_num THEN
858: x_complete_rec.last_update_login := l_filter_rec.last_update_login;
859: END IF;
860:
861: -- security_group_id

Line 862: IF p_filter_rec.security_group_id = FND_API.g_miss_num THEN

858: x_complete_rec.last_update_login := l_filter_rec.last_update_login;
859: END IF;
860:
861: -- security_group_id
862: IF p_filter_rec.security_group_id = FND_API.g_miss_num THEN
863: x_complete_rec.security_group_id := l_filter_rec.security_group_id;
864: END IF;
865:
866: END Complete_Filter_Rec;

Line 872: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

868:
869: PROCEDURE Validate_Filter_Row
870: (
871: p_api_version_number IN NUMBER,
872: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
873: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
874: p_filter_rec IN filter_rec_type,
875: p_validation_mode IN VARCHAR2,
876: x_return_status OUT NOCOPY VARCHAR2,

Line 873: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

869: PROCEDURE Validate_Filter_Row
870: (
871: p_api_version_number IN NUMBER,
872: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
873: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
874: p_filter_rec IN filter_rec_type,
875: p_validation_mode IN VARCHAR2,
876: x_return_status OUT NOCOPY VARCHAR2,
877: x_msg_count OUT NOCOPY NUMBER,

Line 894: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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,
896: l_api_name,
897: G_PKG_NAME)
898: THEN

Line 899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

895: p_api_version_number,
896: l_api_name,
897: G_PKG_NAME)
898: THEN
899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
900: END IF;
901:
902: -- Initialize message list if p_init_msg_list is set to TRUE.
903: IF FND_API.to_Boolean( p_init_msg_list )

Line 903: IF FND_API.to_Boolean( p_init_msg_list )

899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
900: END IF;
901:
902: -- Initialize message list if p_init_msg_list is set to TRUE.
903: IF FND_API.to_Boolean( p_init_msg_list )
904: THEN
905: FND_MSG_PUB.initialize;
906: END IF;
907:

Line 915: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

911: p_validation_mode => p_validation_mode,
912: x_return_status => x_return_status
913: );
914:
915: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
916: RAISE FND_API.G_EXC_ERROR;
917: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: END IF;

Line 916: RAISE FND_API.G_EXC_ERROR;

912: x_return_status => x_return_status
913: );
914:
915: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
916: RAISE FND_API.G_EXC_ERROR;
917: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: END IF;
920: END IF;

Line 917: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

913: );
914:
915: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
916: RAISE FND_API.G_EXC_ERROR;
917: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: END IF;
920: END IF;
921:

Line 918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

914:
915: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
916: RAISE FND_API.G_EXC_ERROR;
917: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: END IF;
920: END IF;
921:
922: Complete_Filter_Rec(

Line 931: p_init_msg_list => FND_API.G_FALSE,

927: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
928: Validate_Filter_Row_Rec
929: (
930: p_api_version_number => 1.0,
931: p_init_msg_list => FND_API.G_FALSE,
932: x_return_status => x_return_status,
933: x_msg_count => x_msg_count,
934: x_msg_data => x_msg_data,
935: p_filter_rec => l_filter_rec

Line 938: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

934: x_msg_data => x_msg_data,
935: p_filter_rec => l_filter_rec
936: );
937:
938: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
939: RAISE FND_API.G_EXC_ERROR;
940: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: END IF;

Line 939: RAISE FND_API.G_EXC_ERROR;

935: p_filter_rec => l_filter_rec
936: );
937:
938: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
939: RAISE FND_API.G_EXC_ERROR;
940: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: END IF;
943: END IF;

Line 940: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

936: );
937:
938: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
939: RAISE FND_API.G_EXC_ERROR;
940: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: END IF;
943: END IF;
944:

Line 941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

937:
938: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
939: RAISE FND_API.G_EXC_ERROR;
940: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
941: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
942: END IF;
943: END IF;
944:
945:

Line 951: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
952:
953:
954: -- Debug Message
955: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

Line 965: x_return_status := FND_API.g_ret_sts_error;

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
969: ROLLBACK TO VALIDATE_Filter_Row;

Line 968: WHEN FND_API.G_EXC_ERROR THEN

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;
971: -- Standard call to get message count and if count=1, get the message
972: FND_MSG_PUB.Count_And_Get (

Line 970: 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;
971: -- Standard call to get message count and if count=1, get the message
972: FND_MSG_PUB.Count_And_Get (
973: p_encoded => FND_API.G_FALSE,
974: p_count => x_msg_count,

Line 973: p_encoded => FND_API.G_FALSE,

969: ROLLBACK TO VALIDATE_Filter_Row;
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: -- Standard call to get message count and if count=1, get the message
972: FND_MSG_PUB.Count_And_Get (
973: p_encoded => FND_API.G_FALSE,
974: p_count => x_msg_count,
975: p_data => x_msg_data
976: );
977:

Line 978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

974: p_count => x_msg_count,
975: p_data => x_msg_data
976: );
977:
978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
979: ROLLBACK TO VALIDATE_Filter_Row;
980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
981: -- Standard call to get message count and if count=1, get the message
982: FND_MSG_PUB.Count_And_Get (

Line 980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

976: );
977:
978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
979: ROLLBACK TO VALIDATE_Filter_Row;
980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
981: -- Standard call to get message count and if count=1, get the message
982: FND_MSG_PUB.Count_And_Get (
983: p_encoded => FND_API.G_FALSE,
984: p_count => x_msg_count,

Line 983: p_encoded => FND_API.G_FALSE,

979: ROLLBACK TO VALIDATE_Filter_Row;
980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
981: -- Standard call to get message count and if count=1, get the message
982: FND_MSG_PUB.Count_And_Get (
983: p_encoded => FND_API.G_FALSE,
984: p_count => x_msg_count,
985: p_data => x_msg_data
986: );
987:

Line 990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

986: );
987:
988: WHEN OTHERS THEN
989: ROLLBACK TO VALIDATE_Filter_Row;
990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
991: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
992: THEN
993: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
994: END IF;

Line 997: p_encoded => FND_API.G_FALSE,

993: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
994: END IF;
995: -- Standard call to get message count and if count=1, get the message
996: FND_MSG_PUB.Count_And_Get (
997: p_encoded => FND_API.G_FALSE,
998: p_count => x_msg_count,
999: p_data => x_msg_data
1000: );
1001: End Validate_Filter_Row;

Line 1007: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1003:
1004: PROCEDURE Validate_Filter_Row_Rec
1005: (
1006: p_api_version_number IN NUMBER,
1007: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1008: x_return_status OUT NOCOPY VARCHAR2,
1009: x_msg_count OUT NOCOPY NUMBER,
1010: x_msg_data OUT NOCOPY VARCHAR2,
1011: p_filter_rec IN filter_rec_type

Line 1017: IF FND_API.to_Boolean( p_init_msg_list )

1013: IS
1014:
1015: BEGIN
1016: -- Initialize message list if p_init_msg_list is set to TRUE.
1017: IF FND_API.to_Boolean( p_init_msg_list )
1018: THEN
1019: FND_MSG_PUB.initialize;
1020: END IF;
1021:

Line 1023: x_return_status := FND_API.G_RET_STS_SUCCESS;

1019: FND_MSG_PUB.initialize;
1020: END IF;
1021:
1022: -- Initialize API return status to SUCCESS
1023: x_return_status := FND_API.G_RET_STS_SUCCESS;
1024:
1025: -- Hint: Validate data
1026: -- If data not valid
1027: -- THEN

Line 1028: -- x_return_status := FND_API.G_RET_STS_ERROR;

1024:
1025: -- Hint: Validate data
1026: -- If data not valid
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.

Line 1106: x_return_status := FND_API.G_RET_STS_SUCCESS;

1102:
1103: BEGIN
1104:
1105: -- Initialize API return status to SUCCESS
1106: x_return_status := FND_API.G_RET_STS_SUCCESS;
1107:
1108: OPEN c_queryId;
1109: FETCH c_queryId INTO l_nQueryId;
1110: CLOSE c_queryId;

Line 1112: IF p_objType = FND_API.g_miss_char OR p_objType IS NULL THEN

1108: OPEN c_queryId;
1109: FETCH c_queryId INTO l_nQueryId;
1110: CLOSE c_queryId;
1111:
1112: IF p_objType = FND_API.g_miss_char OR p_objType IS NULL THEN
1113: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_OBJ_TYPE');
1114: FND_MESSAGE.set_token('MISS_FIELD','OBJ_TYPE');
1115: x_return_status := FND_API.g_ret_sts_error;
1116: RETURN;

Line 1115: x_return_status := FND_API.g_ret_sts_error;

1111:
1112: IF p_objType = FND_API.g_miss_char OR p_objType IS NULL THEN
1113: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_OBJ_TYPE');
1114: FND_MESSAGE.set_token('MISS_FIELD','OBJ_TYPE');
1115: x_return_status := FND_API.g_ret_sts_error;
1116: RETURN;
1117: END IF;
1118: IF p_objectId = FND_API.g_miss_num OR p_objType IS NULL THEN
1119: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_OBJECT_ID');

Line 1118: IF p_objectId = FND_API.g_miss_num OR p_objType IS NULL THEN

1114: FND_MESSAGE.set_token('MISS_FIELD','OBJ_TYPE');
1115: x_return_status := FND_API.g_ret_sts_error;
1116: RETURN;
1117: END IF;
1118: IF p_objectId = FND_API.g_miss_num OR p_objType IS NULL THEN
1119: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_OBJECT_ID');
1120: FND_MESSAGE.set_token('MISS_FIELD','OBJECT_ID');
1121: x_return_status := FND_API.g_ret_sts_error;
1122: RETURN;

Line 1121: x_return_status := FND_API.g_ret_sts_error;

1117: END IF;
1118: IF p_objectId = FND_API.g_miss_num OR p_objType IS NULL THEN
1119: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_OBJECT_ID');
1120: FND_MESSAGE.set_token('MISS_FIELD','OBJECT_ID');
1121: x_return_status := FND_API.g_ret_sts_error;
1122: RETURN;
1123: END IF;
1124: IF p_dataSourceId = FND_API.g_miss_num OR p_dataSourceId IS NULL THEN
1125: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_DATASOURCE_ID');

Line 1124: IF p_dataSourceId = FND_API.g_miss_num OR p_dataSourceId IS NULL THEN

1120: FND_MESSAGE.set_token('MISS_FIELD','OBJECT_ID');
1121: x_return_status := FND_API.g_ret_sts_error;
1122: RETURN;
1123: END IF;
1124: IF p_dataSourceId = FND_API.g_miss_num OR p_dataSourceId IS NULL THEN
1125: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_DATASOURCE_ID');
1126: FND_MESSAGE.set_token('MISS_FIELD','DATASOURCE_ID');
1127: x_return_status := FND_API.g_ret_sts_error;
1128: RETURN;

Line 1127: x_return_status := FND_API.g_ret_sts_error;

1123: END IF;
1124: IF p_dataSourceId = FND_API.g_miss_num OR p_dataSourceId IS NULL THEN
1125: FND_MESSAGE.set_name('AMS', 'AMS_API_MISSING_DATASOURCE_ID');
1126: FND_MESSAGE.set_token('MISS_FIELD','DATASOURCE_ID');
1127: x_return_status := FND_API.g_ret_sts_error;
1128: RETURN;
1129: END IF;
1130:
1131: l_parameterType := p_objType||';'||to_char(p_objectId)||';'||to_char(p_dataSourceId);

Line 1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
1153: AMS_UTILITY_PVT.debug_message('Private API: ' || 'Get_filter_data ' || 'field Name is:: ' || l_fieldName);

Line 1185: WHEN FND_API.G_EXC_ERROR THEN

1181: );
1182:
1183: EXCEPTION
1184:
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: CLOSE c_filterRec;
1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: -- Standard call to get message count and if count=1, get the message
1189: FND_MSG_PUB.Count_And_Get

Line 1187: x_return_status := FND_API.G_RET_STS_ERROR;

1183: EXCEPTION
1184:
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: CLOSE c_filterRec;
1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: -- Standard call to get message count and if count=1, get the message
1189: FND_MSG_PUB.Count_And_Get
1190: (
1191: p_encoded => FND_API.G_FALSE,

Line 1191: p_encoded => FND_API.G_FALSE,

1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: -- Standard call to get message count and if count=1, get the message
1189: FND_MSG_PUB.Count_And_Get
1190: (
1191: p_encoded => FND_API.G_FALSE,
1192: p_count => x_msg_count,
1193: p_data => x_msg_data
1194: );
1195:

Line 1196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1192: p_count => x_msg_count,
1193: p_data => x_msg_data
1194: );
1195:
1196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1198: -- Standard call to get message count and if count=1, get the message
1199: FND_MSG_PUB.Count_And_Get
1200: (

Line 1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1193: p_data => x_msg_data
1194: );
1195:
1196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1198: -- Standard call to get message count and if count=1, get the message
1199: FND_MSG_PUB.Count_And_Get
1200: (
1201: p_encoded => FND_API.G_FALSE,

Line 1201: p_encoded => FND_API.G_FALSE,

1197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1198: -- Standard call to get message count and if count=1, get the message
1199: FND_MSG_PUB.Count_And_Get
1200: (
1201: p_encoded => FND_API.G_FALSE,
1202: p_count => x_msg_count,
1203: p_data => x_msg_data
1204: );
1205:

Line 1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1203: p_data => x_msg_data
1204: );
1205:
1206: WHEN OTHERS THEN
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1208: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1209: THEN
1210: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1211: END IF;

Line 1215: p_encoded => FND_API.G_FALSE,

1211: END IF;
1212: -- Standard call to get message count and if count=1, get the message
1213: FND_MSG_PUB.Count_And_Get
1214: (
1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1218: );
1219:

Line 1286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1282: END check_filter_changes;
1283:
1284: PROCEDURE copy_filter_data (
1285: p_api_version IN NUMBER,
1286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1287: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1289: p_objType IN VARCHAR2,
1290: p_old_objectId IN NUMBER,

Line 1287: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1283:
1284: PROCEDURE copy_filter_data (
1285: p_api_version IN NUMBER,
1286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1287: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1289: p_objType IN VARCHAR2,
1290: p_old_objectId IN NUMBER,
1291: p_new_objectId IN NUMBER,

Line 1288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1284: PROCEDURE copy_filter_data (
1285: p_api_version IN NUMBER,
1286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1287: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1289: p_objType IN VARCHAR2,
1290: p_old_objectId IN NUMBER,
1291: p_new_objectId IN NUMBER,
1292: p_dataSourceId IN NUMBER,

Line 1326: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1322: -- Standard Start of API savepoint
1323: SAVEPOINT ams_filter_pvt_copy_filter;
1324:
1325: -- Standard call to check for call compatibility.
1326: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1327: p_api_version,
1328: l_api_name,
1329: G_PKG_NAME)
1330: THEN

Line 1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1327: p_api_version,
1328: l_api_name,
1329: G_PKG_NAME)
1330: THEN
1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;
1333:
1334: -- Initialize message list if p_init_msg_list is set to TRUE.
1335: IF FND_API.to_Boolean( p_init_msg_list )THEN

Line 1335: IF FND_API.to_Boolean( p_init_msg_list )THEN

1331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1332: END IF;
1333:
1334: -- Initialize message list if p_init_msg_list is set to TRUE.
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');

Line 1342: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1344: --
1345: -- Start of API body.
1346: --

Line 1359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1355: x_msg_data => x_msg_data,
1356: x_filters => l_ref_filter_tbl
1357: );
1358:
1359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1361: END IF;
1362:
1363: IF l_ref_filter_tbl IS NULL THEN

Line 1360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1356: x_filters => l_ref_filter_tbl
1357: );
1358:
1359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1361: END IF;
1362:
1363: IF l_ref_filter_tbl IS NULL THEN
1364: RETURN;

Line 1395: p_init_msg_list => FND_API.G_FALSE,

1391: --create the filter row
1392: Create_Filter_Row
1393: (
1394: p_api_version_number => 1.0,
1395: p_init_msg_list => FND_API.G_FALSE,
1396: p_commit => FND_API.G_FALSE,
1397: p_validation_level => p_validation_level,
1398: x_return_status => x_return_status,
1399: x_msg_count => x_msg_count,

Line 1396: p_commit => FND_API.G_FALSE,

1392: Create_Filter_Row
1393: (
1394: p_api_version_number => 1.0,
1395: p_init_msg_list => FND_API.G_FALSE,
1396: p_commit => FND_API.G_FALSE,
1397: p_validation_level => p_validation_level,
1398: x_return_status => x_return_status,
1399: x_msg_count => x_msg_count,
1400: x_msg_data => x_msg_data,

Line 1406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1402: x_query_param_id => l_query_param_id
1403: );
1404: END LOOP;
1405:
1406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1408: END IF;
1409: --
1410: -- End of API body.

Line 1407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1403: );
1404: END LOOP;
1405:
1406: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1408: END IF;
1409: --
1410: -- End of API body.
1411: --

Line 1414: IF FND_API.to_Boolean( p_commit ) THEN

1410: -- End of API body.
1411: --
1412:
1413: -- Standard check for p_commit
1414: IF FND_API.to_Boolean( p_commit ) THEN
1415: COMMIT WORK;
1416: END IF;
1417:
1418:

Line 1428: WHEN FND_API.G_EXC_ERROR THEN

1424: p_count => x_msg_count,
1425: p_data => x_msg_data
1426: );
1427: EXCEPTION
1428: WHEN FND_API.G_EXC_ERROR THEN
1429: ROLLBACK TO ams_filter_pvt_copy_filter;
1430: x_return_status := FND_API.G_RET_STS_ERROR;
1431: -- Standard call to get message count and if count=1, get the message
1432: FND_MSG_PUB.Count_And_Get (

Line 1430: x_return_status := FND_API.G_RET_STS_ERROR;

1426: );
1427: EXCEPTION
1428: WHEN FND_API.G_EXC_ERROR THEN
1429: ROLLBACK TO ams_filter_pvt_copy_filter;
1430: x_return_status := FND_API.G_RET_STS_ERROR;
1431: -- Standard call to get message count and if count=1, get the message
1432: FND_MSG_PUB.Count_And_Get (
1433: p_encoded => FND_API.G_FALSE,
1434: p_count => x_msg_count,

Line 1433: p_encoded => FND_API.G_FALSE,

1429: ROLLBACK TO ams_filter_pvt_copy_filter;
1430: x_return_status := FND_API.G_RET_STS_ERROR;
1431: -- Standard call to get message count and if count=1, get the message
1432: FND_MSG_PUB.Count_And_Get (
1433: p_encoded => FND_API.G_FALSE,
1434: p_count => x_msg_count,
1435: p_data => x_msg_data
1436: );
1437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1433: p_encoded => FND_API.G_FALSE,
1434: p_count => x_msg_count,
1435: p_data => x_msg_data
1436: );
1437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1438: ROLLBACK TO ams_filter_pvt_copy_filter;
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1440: -- Standard call to get message count and if count=1, get the message
1441: FND_MSG_PUB.Count_And_Get (

Line 1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1435: p_data => x_msg_data
1436: );
1437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1438: ROLLBACK TO ams_filter_pvt_copy_filter;
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1440: -- Standard call to get message count and if count=1, get the message
1441: FND_MSG_PUB.Count_And_Get (
1442: p_encoded => FND_API.G_FALSE,
1443: p_count => x_msg_count,

Line 1442: p_encoded => FND_API.G_FALSE,

1438: ROLLBACK TO ams_filter_pvt_copy_filter;
1439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1440: -- Standard call to get message count and if count=1, get the message
1441: FND_MSG_PUB.Count_And_Get (
1442: p_encoded => FND_API.G_FALSE,
1443: p_count => x_msg_count,
1444: p_data => x_msg_data
1445: );
1446: WHEN OTHERS THEN

Line 1448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1444: p_data => x_msg_data
1445: );
1446: WHEN OTHERS THEN
1447: ROLLBACK TO ams_filter_pvt_copy_filter;
1448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1449: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1451: END IF;
1452: -- Standard call to get message count and if count=1, get the message

Line 1454: p_encoded => FND_API.G_FALSE,

1450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1451: END IF;
1452: -- Standard call to get message count and if count=1, get the message
1453: FND_MSG_PUB.Count_And_Get (
1454: p_encoded => FND_API.G_FALSE,
1455: p_count => x_msg_count,
1456: p_data => x_msg_data
1457: );
1458: END copy_filter_data;