DBA Data[Home] [Help]

APPS.IEX_BALI_FILTERS_PVT dependencies on FND_MSG_PUB

Line 28: fnd_msg_pub.add;

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:

Line 77: FND_MSG_PUB.initialize;

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

Line 91: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

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;

Line 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

Line 223: FND_MSG_PUB.Count_And_Get

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:

Line 235: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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 ;

Line 240: 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
244: ROLLBACK TO CREATE_BALI_FILTERS_PVT;

Line 246: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name);

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;

Line 247: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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:

Line 292: FND_MSG_PUB.initialize;

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;

Line 379: FND_MSG_PUB.Count_And_Get

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

Line 391: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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 ;

Line 396: 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
400: ROLLBACK TO UPDATE_BALI_FILTERS_PVT;

Line 402: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name);

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;

Line 403: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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:

Line 442: FND_MSG_PUB.initialize;

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

Line 474: FND_MSG_PUB.Count_And_Get

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

Line 482: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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 ;

Line 487: 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
491: ROLLBACK TO DELETE_BALI_FILTERS_PVT;

Line 493: FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name);

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;

Line 494: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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: