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.IEX_BALI_FILTERS_PVT dependencies on FND_API

Line 35: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

31:
32:
33: PROCEDURE create_BALI_FILTERS(
34: P_Api_Version_Number IN NUMBER,
35: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
36: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
37: P_bali_filter_rec IN bali_filter_rec_type,
38: X_bali_filter_id OUT NOCOPY NUMBER
39: ,x_return_status OUT NOCOPY VARCHAR2

Line 36: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

32:
33: PROCEDURE create_BALI_FILTERS(
34: P_Api_Version_Number IN NUMBER,
35: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
36: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
37: P_bali_filter_rec IN bali_filter_rec_type,
38: X_bali_filter_id OUT NOCOPY NUMBER
39: ,x_return_status OUT NOCOPY VARCHAR2
40: ,x_msg_count OUT NOCOPY NUMBER

Line 63: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

59: -- Standard Start of API savepoint
60: SAVEPOINT CREATE_BALI_FILTERS_PVT;
61:
62: -- Standard call to check for call compatibility.
63: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
64: p_api_version_number,
65: l_api_name,
66: G_PKG_NAME)
67: THEN

Line 68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

64: p_api_version_number,
65: l_api_name,
66: G_PKG_NAME)
67: THEN
68: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
69: END IF;
70: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
71: IEX_DEBUG_PUB.LogMessage('After Compatibility Check');
72: END IF;

Line 75: IF FND_API.to_Boolean( p_init_msg_list )

71: IEX_DEBUG_PUB.LogMessage('After Compatibility Check');
72: END IF;
73:
74: -- Initialize message list if p_init_msg_list is set to TRUE.
75: IF FND_API.to_Boolean( p_init_msg_list )
76: THEN
77: FND_MSG_PUB.initialize;
78: END IF;
79:

Line 82: x_return_status := FND_API.G_RET_STS_SUCCESS;

78: END IF;
79:
80:
81: -- Initialize API return status to SUCCESS
82: x_return_status := FND_API.G_RET_STS_SUCCESS;
83: --
84: -- API body
85: --
86: -- ******************************************************************

Line 97: RAISE FND_API.G_EXC_ERROR;

93: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
94: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
95: FND_MSG_PUB.ADD;
96: END IF;
97: RAISE FND_API.G_EXC_ERROR;
98: END IF;
99: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
100: IEX_DEBUG_PUB.LogMessage('After Global user Check');
101: END IF;

Line 120: RAISE FND_API.G_EXC_ERROR;

116: IF (P_bali_filter_rec.bali_filter_name IS NULL) THEN
117: AddMissingArgMsg(
118: p_api_name => l_api_name_full,
119: p_param_name => 'bali_filter_name' );
120: RAISE FND_API.G_EXC_ERROR;
121: END IF;
122:
123: --bali_col_alias
124: IF (P_bali_filter_rec.bali_col_alias IS NULL) THEN

Line 128: RAISE FND_API.G_EXC_ERROR;

124: IF (P_bali_filter_rec.bali_col_alias IS NULL) THEN
125: AddMissingArgMsg(
126: p_api_name => l_api_name_full,
127: p_param_name => 'bali_col_alias' );
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130:
131: --bali_col_condition_value
132: IF (P_bali_filter_rec.bali_col_condition_value IS NULL) THEN

Line 136: RAISE FND_API.G_EXC_ERROR;

132: IF (P_bali_filter_rec.bali_col_condition_value IS NULL) THEN
133: AddMissingArgMsg(
134: p_api_name => l_api_name_full,
135: p_param_name => 'bali_col_condition_value' );
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
139: --bali_col_value
140: IF (P_bali_filter_rec.bali_col_value IS NULL) THEN

Line 144: RAISE FND_API.G_EXC_ERROR;

140: IF (P_bali_filter_rec.bali_col_value IS NULL) THEN
141: AddMissingArgMsg(
142: p_api_name => l_api_name_full,
143: p_param_name => 'bali_col_value' );
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
146:
147:
148: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 206: IF x_return_status = FND_API.G_RET_STS_ERROR then

202:
203:
204:
205: -- Check return status from the above procedure call
206: IF x_return_status = FND_API.G_RET_STS_ERROR then
207: raise FND_API.G_EXC_ERROR;
208: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
209: raise FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;

Line 207: raise FND_API.G_EXC_ERROR;

203:
204:
205: -- Check return status from the above procedure call
206: IF x_return_status = FND_API.G_RET_STS_ERROR then
207: raise FND_API.G_EXC_ERROR;
208: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
209: raise FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:

Line 208: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

204:
205: -- Check return status from the above procedure call
206: IF x_return_status = FND_API.G_RET_STS_ERROR then
207: raise FND_API.G_EXC_ERROR;
208: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
209: raise FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:
212: --

Line 209: raise FND_API.G_EXC_UNEXPECTED_ERROR;

205: -- Check return status from the above procedure call
206: IF x_return_status = FND_API.G_RET_STS_ERROR then
207: raise FND_API.G_EXC_ERROR;
208: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
209: raise FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:
212: --
213: -- End of API body.

Line 217: IF FND_API.to_Boolean( p_commit )

213: -- End of API body.
214: --
215:
216: -- Standard check for p_commit
217: IF FND_API.to_Boolean( p_commit )
218: THEN
219: COMMIT WORK;
220: END IF;
221:

Line 232: WHEN FND_API.G_EXC_ERROR THEN

228: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
229: IEX_DEBUG_PUB.LogMessage ('****** End of Procedure =>IEX_BALI_FILTERS_PVT.create_BALI_FILTERS ****** ');
230: END IF;
231: EXCEPTION
232: WHEN FND_API.G_EXC_ERROR THEN
233: ROLLBACK TO CREATE_BALI_FILTERS_PVT;
234: x_return_status := FND_API.G_RET_STS_ERROR ;
235: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
236: p_data => x_msg_data);

Line 234: x_return_status := FND_API.G_RET_STS_ERROR ;

230: END IF;
231: EXCEPTION
232: WHEN FND_API.G_EXC_ERROR THEN
233: ROLLBACK TO CREATE_BALI_FILTERS_PVT;
234: x_return_status := FND_API.G_RET_STS_ERROR ;
235: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
236: p_data => x_msg_data);
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK TO CREATE_BALI_FILTERS_PVT;

Line 237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

233: ROLLBACK TO CREATE_BALI_FILTERS_PVT;
234: x_return_status := FND_API.G_RET_STS_ERROR ;
235: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
236: p_data => x_msg_data);
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK TO CREATE_BALI_FILTERS_PVT;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
240: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
241: p_data => x_msg_data);

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

235: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
236: p_data => x_msg_data);
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK TO CREATE_BALI_FILTERS_PVT;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
240: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
241: p_data => x_msg_data);
242:
243: WHEN OTHERS THEN

Line 245: x_return_status := FND_API.G_RET_STS_ERROR ;

241: p_data => x_msg_data);
242:
243: WHEN OTHERS THEN
244: ROLLBACK TO CREATE_BALI_FILTERS_PVT;
245: x_return_status := FND_API.G_RET_STS_ERROR ;
246: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name);
247: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
248: p_data => x_msg_data);
249:

Line 256: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

252:
253:
254: PROCEDURE update_BALI_FILTERS(
255: P_Api_Version_Number IN NUMBER,
256: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
257: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
258: P_bali_filter_rec IN bali_filter_rec_type,
259: x_return_status OUT NOCOPY VARCHAR2
260: ,x_msg_count OUT NOCOPY NUMBER

Line 257: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

253:
254: PROCEDURE update_BALI_FILTERS(
255: P_Api_Version_Number IN NUMBER,
256: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
257: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
258: P_bali_filter_rec IN bali_filter_rec_type,
259: x_return_status OUT NOCOPY VARCHAR2
260: ,x_msg_count OUT NOCOPY NUMBER
261: ,x_msg_data OUT NOCOPY VARCHAR2

Line 280: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

276: -- Standard Start of API savepoint
277: SAVEPOINT UPDATE_BALI_FILTERS_PVT;
278:
279: -- Standard call to check for call compatibility.
280: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
281: p_api_version_number,
282: l_api_name,
283: G_PKG_NAME)
284: THEN

Line 285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

281: p_api_version_number,
282: l_api_name,
283: G_PKG_NAME)
284: THEN
285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287:
288:
289: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 290: IF FND_API.to_Boolean( p_init_msg_list )

286: END IF;
287:
288:
289: -- Initialize message list if p_init_msg_list is set to TRUE.
290: IF FND_API.to_Boolean( p_init_msg_list )
291: THEN
292: FND_MSG_PUB.initialize;
293: END IF;
294:

Line 296: x_return_status := FND_API.G_RET_STS_SUCCESS;

292: FND_MSG_PUB.initialize;
293: END IF;
294:
295: -- Initialize API return status to SUCCESS
296: x_return_status := FND_API.G_RET_STS_SUCCESS;
297:
298: --
299: -- API body
300: --

Line 361: IF x_return_status = FND_API.G_RET_STS_ERROR then

357:
358: --Return Version number
359: xo_object_version_number := v_object_version_number + 1;
360: -- Check return status from the above procedure call
361: IF x_return_status = FND_API.G_RET_STS_ERROR then
362: raise FND_API.G_EXC_ERROR;
363: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
364: raise FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;

Line 362: raise FND_API.G_EXC_ERROR;

358: --Return Version number
359: xo_object_version_number := v_object_version_number + 1;
360: -- Check return status from the above procedure call
361: IF x_return_status = FND_API.G_RET_STS_ERROR then
362: raise FND_API.G_EXC_ERROR;
363: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
364: raise FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:

Line 363: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

359: xo_object_version_number := v_object_version_number + 1;
360: -- Check return status from the above procedure call
361: IF x_return_status = FND_API.G_RET_STS_ERROR then
362: raise FND_API.G_EXC_ERROR;
363: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
364: raise FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:
367: --

Line 364: raise FND_API.G_EXC_UNEXPECTED_ERROR;

360: -- Check return status from the above procedure call
361: IF x_return_status = FND_API.G_RET_STS_ERROR then
362: raise FND_API.G_EXC_ERROR;
363: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
364: raise FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:
367: --
368: -- End of API body

Line 372: IF FND_API.to_Boolean( p_commit )

368: -- End of API body
369: --
370:
371: -- Standard check for p_commit
372: IF FND_API.to_Boolean( p_commit )
373: THEN
374: COMMIT WORK;
375: END IF;
376:

Line 388: WHEN FND_API.G_EXC_ERROR THEN

384: IEX_DEBUG_PUB.LogMessage ('**** End of Procedure =>'||
385: 'IEX_BALI_FILTERS_PVT.update_BALI_FILTERS ** ');
386: END IF;
387: EXCEPTION
388: WHEN FND_API.G_EXC_ERROR THEN
389: ROLLBACK TO UPDATE_BALI_FILTERS_PVT;
390: x_return_status := FND_API.G_RET_STS_ERROR ;
391: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
392: p_data => x_msg_data);

Line 390: x_return_status := FND_API.G_RET_STS_ERROR ;

386: END IF;
387: EXCEPTION
388: WHEN FND_API.G_EXC_ERROR THEN
389: ROLLBACK TO UPDATE_BALI_FILTERS_PVT;
390: x_return_status := FND_API.G_RET_STS_ERROR ;
391: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
392: p_data => x_msg_data);
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: ROLLBACK TO UPDATE_BALI_FILTERS_PVT;

Line 393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

389: ROLLBACK TO UPDATE_BALI_FILTERS_PVT;
390: x_return_status := FND_API.G_RET_STS_ERROR ;
391: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
392: p_data => x_msg_data);
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: ROLLBACK TO UPDATE_BALI_FILTERS_PVT;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
396: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
397: p_data => x_msg_data);

Line 395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

391: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
392: p_data => x_msg_data);
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: ROLLBACK TO UPDATE_BALI_FILTERS_PVT;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
396: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
397: p_data => x_msg_data);
398:
399: WHEN OTHERS THEN

Line 401: x_return_status := FND_API.G_RET_STS_ERROR ;

397: p_data => x_msg_data);
398:
399: WHEN OTHERS THEN
400: ROLLBACK TO UPDATE_BALI_FILTERS_PVT;
401: x_return_status := FND_API.G_RET_STS_ERROR ;
402: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name);
403: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
404: p_data => x_msg_data);
405:

Line 412: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

408:
409:
410: PROCEDURE delete_BALI_FILTERS(
411: P_Api_Version_Number IN NUMBER,
412: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
413: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
414: p_bali_filter_id IN NUMBER ,
415: x_return_status OUT NOCOPY VARCHAR2
416: ,x_msg_count OUT NOCOPY NUMBER

Line 413: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

409:
410: PROCEDURE delete_BALI_FILTERS(
411: P_Api_Version_Number IN NUMBER,
412: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
413: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
414: p_bali_filter_id IN NUMBER ,
415: x_return_status OUT NOCOPY VARCHAR2
416: ,x_msg_count OUT NOCOPY NUMBER
417: ,x_msg_data OUT NOCOPY VARCHAR2

Line 430: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

426: -- Standard Start of API savepoint
427: SAVEPOINT DELETE_BALI_FILTERS_PVT;
428:
429: -- Standard call to check for call compatibility.
430: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
431: p_api_version_number,
432: l_api_name,
433: G_PKG_NAME)
434: THEN

Line 435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

431: p_api_version_number,
432: l_api_name,
433: G_PKG_NAME)
434: THEN
435: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
436: END IF;
437:
438:
439: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 440: IF FND_API.to_Boolean( p_init_msg_list )

436: END IF;
437:
438:
439: -- Initialize message list if p_init_msg_list is set to TRUE.
440: IF FND_API.to_Boolean( p_init_msg_list )
441: THEN
442: FND_MSG_PUB.initialize;
443: END IF;
444:

Line 447: x_return_status := FND_API.G_RET_STS_SUCCESS;

443: END IF;
444:
445:
446: -- Initialize API return status to SUCCESS
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448: --
449: -- API body
450: --
451:

Line 456: IF x_return_status = FND_API.G_RET_STS_ERROR then

452: -- call table handler to insert into jtf_tasks_temp_groups
453: iex_BALI_FILTERS_pkg.delete_row (p_bali_filter_id);
454:
455: -- Check return status from the above procedure call
456: IF x_return_status = FND_API.G_RET_STS_ERROR then
457: raise FND_API.G_EXC_ERROR;
458: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
459: raise FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;

Line 457: raise FND_API.G_EXC_ERROR;

453: iex_BALI_FILTERS_pkg.delete_row (p_bali_filter_id);
454:
455: -- Check return status from the above procedure call
456: IF x_return_status = FND_API.G_RET_STS_ERROR then
457: raise FND_API.G_EXC_ERROR;
458: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
459: raise FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461:

Line 458: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

454:
455: -- Check return status from the above procedure call
456: IF x_return_status = FND_API.G_RET_STS_ERROR then
457: raise FND_API.G_EXC_ERROR;
458: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
459: raise FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461:
462: --

Line 459: raise FND_API.G_EXC_UNEXPECTED_ERROR;

455: -- Check return status from the above procedure call
456: IF x_return_status = FND_API.G_RET_STS_ERROR then
457: raise FND_API.G_EXC_ERROR;
458: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
459: raise FND_API.G_EXC_UNEXPECTED_ERROR;
460: END IF;
461:
462: --
463: -- End of API body

Line 467: IF FND_API.to_Boolean( p_commit )

463: -- End of API body
464: --
465:
466: -- Standard check for p_commit
467: IF FND_API.to_Boolean( p_commit )
468: THEN
469: COMMIT WORK;
470: END IF;
471:

Line 479: WHEN FND_API.G_EXC_ERROR THEN

475: ( p_count => x_msg_count,
476: p_data => x_msg_data
477: );
478: EXCEPTION
479: WHEN FND_API.G_EXC_ERROR THEN
480: ROLLBACK TO DELETE_BALI_FILTERS_PVT;
481: x_return_status := FND_API.G_RET_STS_ERROR ;
482: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
483: p_data => x_msg_data);

Line 481: x_return_status := FND_API.G_RET_STS_ERROR ;

477: );
478: EXCEPTION
479: WHEN FND_API.G_EXC_ERROR THEN
480: ROLLBACK TO DELETE_BALI_FILTERS_PVT;
481: x_return_status := FND_API.G_RET_STS_ERROR ;
482: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
483: p_data => x_msg_data);
484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
485: ROLLBACK TO DELETE_BALI_FILTERS_PVT;

Line 484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

480: ROLLBACK TO DELETE_BALI_FILTERS_PVT;
481: x_return_status := FND_API.G_RET_STS_ERROR ;
482: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
483: p_data => x_msg_data);
484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
485: ROLLBACK TO DELETE_BALI_FILTERS_PVT;
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
487: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
488: p_data => x_msg_data);

Line 486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

482: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
483: p_data => x_msg_data);
484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
485: ROLLBACK TO DELETE_BALI_FILTERS_PVT;
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
487: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
488: p_data => x_msg_data);
489:
490: WHEN OTHERS THEN

Line 492: x_return_status := FND_API.G_RET_STS_ERROR ;

488: p_data => x_msg_data);
489:
490: WHEN OTHERS THEN
491: ROLLBACK TO DELETE_BALI_FILTERS_PVT;
492: x_return_status := FND_API.G_RET_STS_ERROR ;
493: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name);
494: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
495: p_data => x_msg_data);
496: