55: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
56: IEX_DEBUG_PUB.LogMessage ('** Start of Procedure =>'||
57: 'IEX_BALI_FILTERS_PVT.create_BALI_FILTERS *** ');
58: END IF;
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,
58: END IF;
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)
212: --
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;
218: 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: );
272: IEX_DEBUG_PUB.LogMessage ('** Start of Procedure =>'||
273: 'IEX_BALI_FILTERS_PVT.update_BALI_FILTERS *** ');
274: END IF;
275:
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,
275:
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)
367: --
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;
374: COMMIT WORK;
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: );
422: l_api_name CONSTANT VARCHAR2(50) := 'DELETE_BALI_FILTERS';
423: l_api_version_number CONSTANT NUMBER := 2.0;
424:
425: BEGIN
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,
425: BEGIN
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)
462: --
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;
469: COMMIT WORK;
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: );