DBA Data[Home] [Help]

APPS.JTF_PREFAB_FILTER_PUB dependencies on FND_MSG_PUB

Line 53: FND_MSG_PUB.initialize;

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;

Line 124: FND_MSG_PUB.Count_And_Get(

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

Line 133: FND_MSG_PUB.Count_And_Get(

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

Line 141: FND_MSG_PUB.Count_And_Get(

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

Line 149: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) 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(

Line 150: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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,

Line 153: FND_MSG_PUB.Count_And_Get(

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;

Line 198: FND_MSG_PUB.initialize;

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;

Line 245: FND_MSG_PUB.Count_And_Get(

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

Line 254: FND_MSG_PUB.Count_And_Get(

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

Line 262: FND_MSG_PUB.Count_And_Get(

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

Line 270: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) 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(

Line 271: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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,

Line 274: FND_MSG_PUB.Count_And_Get(

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;

Line 313: FND_MSG_PUB.initialize;

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;

Line 338: FND_MSG_PUB.Count_And_Get(

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

Line 347: FND_MSG_PUB.Count_And_Get(

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

Line 355: FND_MSG_PUB.Count_And_Get(

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

Line 363: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) 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(

Line 364: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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,

Line 367: FND_MSG_PUB.Count_And_Get(

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;