DBA Data[Home] [Help]

APPS.IEM_KB_RESULTS_PVT dependencies on FND_MSG_PUB

Line 63: FND_MSG_PUB.initialize;

59: END IF;
60: -- Initialize message list if p_init_msg_list is set to TRUE.
61: IF FND_API.to_Boolean( p_init_msg_list )
62: THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65: -- Initialize API return status to SUCCESS
66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: SELECT IEM_KB_RESULTS_s1.nextval

Line 155: FND_MSG_PUB.Count_And_Get

151: IF FND_API.To_Boolean(p_commit) THEN
152: COMMIT WORK;
153: END IF;
154: -- Standard callto get message count and if count is 1, get message info.
155: FND_MSG_PUB.Count_And_Get
156: ( p_count => x_msg_count,
157: p_data => x_msg_data
158: );
159: EXCEPTION

Line 163: FND_MSG_PUB.Count_And_Get

159: EXCEPTION
160: WHEN FND_API.G_EXC_ERROR THEN
161: ROLLBACK TO create_item_PVT;
162: x_return_status := FND_API.G_RET_STS_ERROR ;
163: FND_MSG_PUB.Count_And_Get
164: ( p_count => x_msg_count,
165: p_data => x_msg_data
166: );
167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 170: FND_MSG_PUB.Count_And_Get

166: );
167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
168: ROLLBACK TO create_item_PVT;
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
170: FND_MSG_PUB.Count_And_Get
171: ( p_count => x_msg_count,
172: p_data => x_msg_data
173: );
174: WHEN OTHERS THEN

Line 177: IF FND_MSG_PUB.Check_Msg_Level

173: );
174: WHEN OTHERS THEN
175: ROLLBACK TO create_item_PVT;
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: IF FND_MSG_PUB.Check_Msg_Level
178: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
179: THEN
180: FND_MSG_PUB.Add_Exc_Msg
181: ( G_PKG_NAME ,

Line 178: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

174: WHEN OTHERS THEN
175: ROLLBACK TO create_item_PVT;
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: IF FND_MSG_PUB.Check_Msg_Level
178: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
179: THEN
180: FND_MSG_PUB.Add_Exc_Msg
181: ( G_PKG_NAME ,
182: l_api_name

Line 180: FND_MSG_PUB.Add_Exc_Msg

176: x_return_status := FND_API.G_RET_STS_ERROR;
177: IF FND_MSG_PUB.Check_Msg_Level
178: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
179: THEN
180: FND_MSG_PUB.Add_Exc_Msg
181: ( G_PKG_NAME ,
182: l_api_name
183: );
184: END IF;

Line 185: FND_MSG_PUB.Count_And_Get

181: ( G_PKG_NAME ,
182: l_api_name
183: );
184: END IF;
185: FND_MSG_PUB.Count_And_Get
186: ( p_count => x_msg_count ,
187: p_data => x_msg_data
188: );
189:

Line 216: FND_MSG_PUB.initialize;

212: END IF;
213: -- Initialize message list if p_init_msg_list is set to TRUE.
214: IF FND_API.to_Boolean( p_init_msg_list )
215: THEN
216: FND_MSG_PUB.initialize;
217: END IF;
218: -- Initialize API return status to SUCCESS
219: x_return_status := FND_API.G_RET_STS_SUCCESS;
220:

Line 229: FND_MSG_PUB.Count_And_Get

225: IF FND_API.To_Boolean(p_commit) THEN
226: COMMIT WORK;
227: END IF;
228: -- Standard callto get message count and if count is 1, get message info.
229: FND_MSG_PUB.Count_And_Get
230: ( p_count => x_msg_count,
231: p_data => x_msg_data
232: );
233: EXCEPTION

Line 237: FND_MSG_PUB.Count_And_Get

233: EXCEPTION
234: WHEN FND_API.G_EXC_ERROR THEN
235: ROLLBACK TO delete_item_PVT;
236: x_return_status := FND_API.G_RET_STS_ERROR ;
237: FND_MSG_PUB.Count_And_Get
238: ( p_count => x_msg_count,
239: p_data => x_msg_data
240: );
241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 244: FND_MSG_PUB.Count_And_Get

240: );
241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
242: ROLLBACK TO delete_item_PVT;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
244: FND_MSG_PUB.Count_And_Get
245: ( p_count => x_msg_count,
246: p_data => x_msg_data
247: );
248: WHEN OTHERS THEN

Line 251: IF FND_MSG_PUB.Check_Msg_Level

247: );
248: WHEN OTHERS THEN
249: ROLLBACK TO delete_item_PVT;
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: IF FND_MSG_PUB.Check_Msg_Level
252: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: FND_MSG_PUB.Add_Exc_Msg
255: ( G_PKG_NAME ,

Line 252: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

248: WHEN OTHERS THEN
249: ROLLBACK TO delete_item_PVT;
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: IF FND_MSG_PUB.Check_Msg_Level
252: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: FND_MSG_PUB.Add_Exc_Msg
255: ( G_PKG_NAME ,
256: l_api_name

Line 254: FND_MSG_PUB.Add_Exc_Msg

250: x_return_status := FND_API.G_RET_STS_ERROR;
251: IF FND_MSG_PUB.Check_Msg_Level
252: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: FND_MSG_PUB.Add_Exc_Msg
255: ( G_PKG_NAME ,
256: l_api_name
257: );
258: END IF;

Line 259: FND_MSG_PUB.Count_And_Get

255: ( G_PKG_NAME ,
256: l_api_name
257: );
258: END IF;
259: FND_MSG_PUB.Count_And_Get
260: ( p_count => x_msg_count ,
261: p_data => x_msg_data
262: );
263:

Line 315: FND_MSG_PUB.initialize;

311: END IF;
312: -- Initialize message list if p_init_msg_list is set to TRUE.
313: IF FND_API.to_Boolean( p_init_msg_list )
314: THEN
315: FND_MSG_PUB.initialize;
316: END IF;
317: -- Initialize API return status to SUCCESS
318: x_return_status := FND_API.G_RET_STS_SUCCESS;
319: UPDATE IEM_KB_RESULTS

Line 328: FND_MSG_PUB.Count_And_Get

324: IF FND_API.To_Boolean(p_commit) THEN
325: COMMIT WORK;
326: END IF;
327: -- Standard callto get message count and if count is 1, get message info.
328: FND_MSG_PUB.Count_And_Get
329: ( p_count => x_msg_count,
330: p_data => x_msg_data
331: );
332: EXCEPTION

Line 336: FND_MSG_PUB.Count_And_Get

332: EXCEPTION
333: WHEN FND_API.G_EXC_ERROR THEN
334: ROLLBACK TO update_item_PVT;
335: x_return_status := FND_API.G_RET_STS_ERROR ;
336: FND_MSG_PUB.Count_And_Get
337: ( p_count => x_msg_count,
338: p_data => x_msg_data
339: );
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 343: FND_MSG_PUB.Count_And_Get

339: );
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: ROLLBACK TO update_item_PVT;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
343: FND_MSG_PUB.Count_And_Get
344: ( p_count => x_msg_count,
345: p_data => x_msg_data
346: );
347: WHEN OTHERS THEN

Line 350: IF FND_MSG_PUB.Check_Msg_Level

346: );
347: WHEN OTHERS THEN
348: ROLLBACK TO update_item_PVT;
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: IF FND_MSG_PUB.Check_Msg_Level
351: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
352: THEN
353: FND_MSG_PUB.Add_Exc_Msg
354: ( G_PKG_NAME ,

Line 351: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

347: WHEN OTHERS THEN
348: ROLLBACK TO update_item_PVT;
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: IF FND_MSG_PUB.Check_Msg_Level
351: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
352: THEN
353: FND_MSG_PUB.Add_Exc_Msg
354: ( G_PKG_NAME ,
355: l_api_name

Line 353: FND_MSG_PUB.Add_Exc_Msg

349: x_return_status := FND_API.G_RET_STS_ERROR;
350: IF FND_MSG_PUB.Check_Msg_Level
351: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
352: THEN
353: FND_MSG_PUB.Add_Exc_Msg
354: ( G_PKG_NAME ,
355: l_api_name
356: );
357: END IF;

Line 358: FND_MSG_PUB.Count_And_Get

354: ( G_PKG_NAME ,
355: l_api_name
356: );
357: END IF;
358: FND_MSG_PUB.Count_And_Get
359: ( p_count => x_msg_count ,
360: p_data => x_msg_data
361: );
362: