24: BEGIN
25: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
26: fnd_message.set_token('API_NAME', p_api_name);
27: fnd_message.set_token('MISSING_PARAM', p_param_name);
28: fnd_msg_pub.add;
29:
30: END AddMissingArgMsg;
31:
32:
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:
80:
81: -- Initialize API return status to SUCCESS
87: -- Validate Environment
88: -- ******************************************************************
89: IF FND_GLOBAL.User_Id IS NULL
90: THEN
91: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
92: THEN
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;
91: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
92: THEN
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
219: COMMIT WORK;
220: END IF;
221:
222: -- Standard call to get message count and if count is 1, get message info.
223: FND_MSG_PUB.Count_And_Get
224: ( p_count => x_msg_count,
225: p_data => x_msg_data
226: );
227:
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;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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
244: ROLLBACK TO CREATE_BALI_FILTERS_PVT;
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:
250: End create_BALI_FILTERS;
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:
250: End create_BALI_FILTERS;
251:
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:
295: -- Initialize API return status to SUCCESS
296: x_return_status := FND_API.G_RET_STS_SUCCESS;
375: END IF;
376:
377:
378: -- Standard call to get message count and if count is 1, get message info.
379: FND_MSG_PUB.Count_And_Get
380: ( p_count => x_msg_count,
381: p_data => x_msg_data
382: );
383: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
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;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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
400: ROLLBACK TO UPDATE_BALI_FILTERS_PVT;
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:
406: End update_BALI_FILTERS;
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:
406: End update_BALI_FILTERS;
407:
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:
445:
446: -- Initialize API return status to SUCCESS
470: END IF;
471:
472:
473: -- Standard call to get message count and if count is 1, get message info.
474: FND_MSG_PUB.Count_And_Get
475: ( p_count => x_msg_count,
476: p_data => x_msg_data
477: );
478: EXCEPTION
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;
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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
491: ROLLBACK TO DELETE_BALI_FILTERS_PVT;
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:
497: End delete_BALI_FILTERS;
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:
497: End delete_BALI_FILTERS;
498: