49: END IF;
50:
51: -- Initialize message list if p_init_msg_list is set to TRUE.
52: IF FND_API.To_Boolean( p_init_msg_list ) THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:
56: -- Initialize API return status to success
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
120: COMMIT WORK;
121: END IF;
122:
123: -- Standard call to get message count and if count is 1, get message info.
124: FND_MSG_PUB.Count_And_Get(
125: p_count => x_msg_count,
126: p_data => x_msg_data );
127:
128: EXCEPTION
129: WHEN FND_API.G_EXC_ERROR THEN
130: ROLLBACK TO INSERT_FILTER;
131: x_return_status := FND_API.G_RET_STS_ERROR ;
132:
133: FND_MSG_PUB.Count_And_Get(
134: p_count => x_msg_count,
135: p_data => x_msg_data );
136:
137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
138: ROLLBACK TO INSERT_FILTER;
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
140:
141: FND_MSG_PUB.Count_And_Get(
142: p_count => x_msg_count,
143: p_data => x_msg_data );
144:
145: WHEN OTHERS THEN
145: WHEN OTHERS THEN
146: ROLLBACK TO INSERT_FILTER;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
148:
149: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
151: END IF;
152:
153: FND_MSG_PUB.Count_And_Get(
146: ROLLBACK TO INSERT_FILTER;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
148:
149: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
151: END IF;
152:
153: FND_MSG_PUB.Count_And_Get(
154: p_count => x_msg_count,
149: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
151: END IF;
152:
153: FND_MSG_PUB.Count_And_Get(
154: p_count => x_msg_count,
155: p_data => x_msg_data );
156:
157: END INSERT_FILTER;
194: END IF;
195:
196: -- Initialize message list if p_init_msg_list is set to TRUE.
197: IF FND_API.To_Boolean( p_init_msg_list ) THEN
198: FND_MSG_PUB.initialize;
199: END IF;
200:
201: -- Initialize API return status to success
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
241: COMMIT WORK;
242: END IF;
243:
244: -- Standard call to get message count and if count is 1, get message info.
245: FND_MSG_PUB.Count_And_Get(
246: p_count => x_msg_count,
247: p_data => x_msg_data );
248:
249: EXCEPTION
250: WHEN FND_API.G_EXC_ERROR THEN
251: ROLLBACK TO UPDATE_FILTER;
252: x_return_status := FND_API.G_RET_STS_ERROR ;
253:
254: FND_MSG_PUB.Count_And_Get(
255: p_count => x_msg_count,
256: p_data => x_msg_data );
257:
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259: ROLLBACK TO UPDATE_FILTER;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
261:
262: FND_MSG_PUB.Count_And_Get(
263: p_count => x_msg_count,
264: p_data => x_msg_data );
265:
266: WHEN OTHERS THEN
266: WHEN OTHERS THEN
267: ROLLBACK TO UPDATE_FILTER;
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
269:
270: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
272: END IF;
273:
274: FND_MSG_PUB.Count_And_Get(
267: ROLLBACK TO UPDATE_FILTER;
268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
269:
270: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
272: END IF;
273:
274: FND_MSG_PUB.Count_And_Get(
275: p_count => x_msg_count,
270: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
272: END IF;
273:
274: FND_MSG_PUB.Count_And_Get(
275: p_count => x_msg_count,
276: p_data => x_msg_data );
277:
278: END UPDATE_FILTER;
309: END IF;
310:
311: -- Initialize message list if p_init_msg_list is set to TRUE.
312: IF FND_API.To_Boolean( p_init_msg_list ) THEN
313: FND_MSG_PUB.initialize;
314: END IF;
315:
316: -- Initialize API return status to success
317: x_return_status := FND_API.G_RET_STS_SUCCESS;
334: COMMIT WORK;
335: END IF;
336:
337: -- Standard call to get message count and if count is 1, get message info.
338: FND_MSG_PUB.Count_And_Get(
339: p_count => x_msg_count,
340: p_data => x_msg_data );
341:
342: EXCEPTION
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO DELETE_FILTER;
345: x_return_status := FND_API.G_RET_STS_ERROR ;
346:
347: FND_MSG_PUB.Count_And_Get(
348: p_count => x_msg_count,
349: p_data => x_msg_data );
350:
351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
352: ROLLBACK TO DELETE_FILTER;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
354:
355: FND_MSG_PUB.Count_And_Get(
356: p_count => x_msg_count,
357: p_data => x_msg_data );
358:
359: WHEN OTHERS THEN
359: WHEN OTHERS THEN
360: ROLLBACK TO DELETE_FILTER;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
362:
363: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
364: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
365: END IF;
366:
367: FND_MSG_PUB.Count_And_Get(
360: ROLLBACK TO DELETE_FILTER;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
362:
363: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
364: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
365: END IF;
366:
367: FND_MSG_PUB.Count_And_Get(
368: p_count => x_msg_count,
363: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
364: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );
365: END IF;
366:
367: FND_MSG_PUB.Count_And_Get(
368: p_count => x_msg_count,
369: p_data => x_msg_data );
370:
371: END DELETE_FILTER;