DBA Data[Home] [Help]

APPS.IEM_KB_CATEGORIES_PVT dependencies on FND_MSG_PUB

Line 62: FND_MSG_PUB.initialize;

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

Line 132: FND_MSG_PUB.Count_And_Get

128: p_ATTRIBUTE15
129: );
130:
131: -- Standard callto get message count and if count is 1, get message info.
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,
134: p_data => x_msg_data
135: );
136: EXCEPTION

Line 140: FND_MSG_PUB.Count_And_Get

136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
138: ROLLBACK TO create_item_PVT;
139: x_return_status := FND_API.G_RET_STS_ERROR ;
140: FND_MSG_PUB.Count_And_Get
141: ( p_count => x_msg_count,
142: p_data => x_msg_data
143: );
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 147: FND_MSG_PUB.Count_And_Get

143: );
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: ROLLBACK TO create_item_PVT;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
147: FND_MSG_PUB.Count_And_Get
148: ( p_count => x_msg_count,
149: p_data => x_msg_data
150: );
151: WHEN OTHERS THEN

Line 154: IF FND_MSG_PUB.Check_Msg_Level

150: );
151: WHEN OTHERS THEN
152: ROLLBACK TO create_item_PVT;
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: IF FND_MSG_PUB.Check_Msg_Level
155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
156: THEN
157: FND_MSG_PUB.Add_Exc_Msg
158: ( G_PKG_NAME ,

Line 155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

151: WHEN OTHERS THEN
152: ROLLBACK TO create_item_PVT;
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: IF FND_MSG_PUB.Check_Msg_Level
155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
156: THEN
157: FND_MSG_PUB.Add_Exc_Msg
158: ( G_PKG_NAME ,
159: l_api_name

Line 157: FND_MSG_PUB.Add_Exc_Msg

153: x_return_status := FND_API.G_RET_STS_ERROR;
154: IF FND_MSG_PUB.Check_Msg_Level
155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
156: THEN
157: FND_MSG_PUB.Add_Exc_Msg
158: ( G_PKG_NAME ,
159: l_api_name
160: );
161: END IF;

Line 162: FND_MSG_PUB.Count_And_Get

158: ( G_PKG_NAME ,
159: l_api_name
160: );
161: END IF;
162: FND_MSG_PUB.Count_And_Get
163: ( p_count => x_msg_count ,
164: p_data => x_msg_data
165: );
166:

Line 196: FND_MSG_PUB.initialize;

192: END IF;
193: -- Initialize message list if p_init_msg_list is set to TRUE.
194: IF FND_API.to_Boolean( p_init_msg_list )
195: THEN
196: FND_MSG_PUB.initialize;
197: END IF;
198: -- Initialize API return status to SUCCESS
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:

Line 215: FND_MSG_PUB.Count_And_Get

211: IF FND_API.To_Boolean(p_commit) THEN
212: COMMIT WORK;
213: END IF;
214: -- Standard callto get message count and if count is 1, get message info.
215: FND_MSG_PUB.Count_And_Get
216: ( p_count => x_msg_count,
217: p_data => x_msg_data
218: );
219: EXCEPTION

Line 223: FND_MSG_PUB.Count_And_Get

219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN
221: ROLLBACK TO delete_item_PVT;
222: x_return_status := FND_API.G_RET_STS_ERROR ;
223: FND_MSG_PUB.Count_And_Get
224: ( p_count => x_msg_count,
225: p_data => x_msg_data
226: );
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 230: FND_MSG_PUB.Count_And_Get

226: );
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO delete_item_PVT;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: FND_MSG_PUB.Count_And_Get
231: ( p_count => x_msg_count,
232: p_data => x_msg_data
233: );
234: WHEN OTHERS THEN

Line 237: IF FND_MSG_PUB.Check_Msg_Level

233: );
234: WHEN OTHERS THEN
235: ROLLBACK TO delete_item_PVT;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: IF FND_MSG_PUB.Check_Msg_Level
238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: FND_MSG_PUB.Add_Exc_Msg
241: ( G_PKG_NAME ,

Line 238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

234: WHEN OTHERS THEN
235: ROLLBACK TO delete_item_PVT;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: IF FND_MSG_PUB.Check_Msg_Level
238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: FND_MSG_PUB.Add_Exc_Msg
241: ( G_PKG_NAME ,
242: l_api_name

Line 240: FND_MSG_PUB.Add_Exc_Msg

236: x_return_status := FND_API.G_RET_STS_ERROR;
237: IF FND_MSG_PUB.Check_Msg_Level
238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: FND_MSG_PUB.Add_Exc_Msg
241: ( G_PKG_NAME ,
242: l_api_name
243: );
244: END IF;

Line 245: FND_MSG_PUB.Count_And_Get

241: ( G_PKG_NAME ,
242: l_api_name
243: );
244: END IF;
245: FND_MSG_PUB.Count_And_Get
246: ( p_count => x_msg_count ,
247: p_data => x_msg_data
248: );
249:

Line 305: FND_MSG_PUB.initialize;

301: END IF;
302: -- Initialize message list if p_init_msg_list is set to TRUE.
303: IF FND_API.to_Boolean( p_init_msg_list )
304: THEN
305: FND_MSG_PUB.initialize;
306: END IF;
307: -- Initialize API return status to SUCCESS
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309:

Line 342: FND_MSG_PUB.Count_And_Get

338: IF FND_API.To_Boolean(p_commit) THEN
339: COMMIT WORK;
340: END IF;
341: -- Standard callto get message count and if count is 1, get message info.
342: FND_MSG_PUB.Count_And_Get
343: ( p_count => x_msg_count,
344: p_data => x_msg_data
345: );
346: EXCEPTION

Line 350: FND_MSG_PUB.Count_And_Get

346: EXCEPTION
347: WHEN FND_API.G_EXC_ERROR THEN
348: ROLLBACK TO update_item_PVT;
349: x_return_status := FND_API.G_RET_STS_ERROR ;
350: FND_MSG_PUB.Count_And_Get
351: ( p_count => x_msg_count,
352: p_data => x_msg_data
353: );
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 357: FND_MSG_PUB.Count_And_Get

353: );
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: ROLLBACK TO update_item_PVT;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
357: FND_MSG_PUB.Count_And_Get
358: ( p_count => x_msg_count,
359: p_data => x_msg_data
360: );
361: WHEN OTHERS THEN

Line 364: IF FND_MSG_PUB.Check_Msg_Level

360: );
361: WHEN OTHERS THEN
362: ROLLBACK TO update_item_PVT;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: IF FND_MSG_PUB.Check_Msg_Level
365: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
366: THEN
367: FND_MSG_PUB.Add_Exc_Msg
368: ( G_PKG_NAME ,

Line 365: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

361: WHEN OTHERS THEN
362: ROLLBACK TO update_item_PVT;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: IF FND_MSG_PUB.Check_Msg_Level
365: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
366: THEN
367: FND_MSG_PUB.Add_Exc_Msg
368: ( G_PKG_NAME ,
369: l_api_name

Line 367: FND_MSG_PUB.Add_Exc_Msg

363: x_return_status := FND_API.G_RET_STS_ERROR;
364: IF FND_MSG_PUB.Check_Msg_Level
365: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
366: THEN
367: FND_MSG_PUB.Add_Exc_Msg
368: ( G_PKG_NAME ,
369: l_api_name
370: );
371: END IF;

Line 372: FND_MSG_PUB.Count_And_Get

368: ( G_PKG_NAME ,
369: l_api_name
370: );
371: END IF;
372: FND_MSG_PUB.Count_And_Get
373: ( p_count => x_msg_count ,
374: p_data => x_msg_data
375: );
376: