DBA Data[Home] [Help]

APPS.IEM_ACT_CATG_PVT dependencies on FND_MSG_PUB

Line 115: FND_MSG_PUB.Count_And_Get

111: IF FND_API.To_Boolean(p_commit) THEN
112: COMMIT WORK;
113: END IF;
114: -- Standard callto get message count and if count is 1, get message info.
115: FND_MSG_PUB.Count_And_Get
116: ( p_count => x_msg_count,
117: p_data => x_msg_data
118: );
119: EXCEPTION

Line 122: FND_MSG_PUB.Count_And_Get

118: );
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: FND_MSG_PUB.Count_And_Get
123: ( p_count => x_msg_count,
124: p_data => x_msg_data
125: );
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 128: FND_MSG_PUB.Count_And_Get

124: p_data => x_msg_data
125: );
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: FND_MSG_PUB.Count_And_Get
129: ( p_count => x_msg_count,
130: p_data => x_msg_data
131: );
132: WHEN OTHERS THEN

Line 134: IF FND_MSG_PUB.Check_Msg_Level

130: p_data => x_msg_data
131: );
132: WHEN OTHERS THEN
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: IF FND_MSG_PUB.Check_Msg_Level
135: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: FND_MSG_PUB.Add_Exc_Msg
138: ( G_PKG_NAME ,

Line 135: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

131: );
132: WHEN OTHERS THEN
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: IF FND_MSG_PUB.Check_Msg_Level
135: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: FND_MSG_PUB.Add_Exc_Msg
138: ( G_PKG_NAME ,
139: l_api_name

Line 137: FND_MSG_PUB.Add_Exc_Msg

133: x_return_status := FND_API.G_RET_STS_ERROR;
134: IF FND_MSG_PUB.Check_Msg_Level
135: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: FND_MSG_PUB.Add_Exc_Msg
138: ( G_PKG_NAME ,
139: l_api_name
140: );
141: END IF;

Line 142: FND_MSG_PUB.Count_And_Get

138: ( G_PKG_NAME ,
139: l_api_name
140: );
141: END IF;
142: FND_MSG_PUB.Count_And_Get
143: ( p_count => x_msg_count ,
144: p_data => x_msg_data
145: );
146:

Line 182: FND_MSG_PUB.Count_And_Get

178: IF FND_API.To_Boolean(p_commit) THEN
179: COMMIT WORK;
180: END IF;
181: -- Standard callto get message count and if count is 1, get message info.
182: FND_MSG_PUB.Count_And_Get
183: ( p_count => x_msg_count,
184: p_data => x_msg_data
185: );
186: EXCEPTION

Line 190: FND_MSG_PUB.Count_And_Get

186: EXCEPTION
187: WHEN FND_API.G_EXC_ERROR THEN
188: ROLLBACK TO select_item_pvt;
189: x_return_status := FND_API.G_RET_STS_ERROR ;
190: FND_MSG_PUB.Count_And_Get
191: ( p_count => x_msg_count,
192: p_data => x_msg_data
193: );
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 197: FND_MSG_PUB.Count_And_Get

193: );
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: ROLLBACK TO select_item_pvt;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197: FND_MSG_PUB.Count_And_Get
198: ( p_count => x_msg_count,
199: p_data => x_msg_data
200: );
201: WHEN OTHERS THEN

Line 204: IF FND_MSG_PUB.Check_Msg_Level

200: );
201: WHEN OTHERS THEN
202: ROLLBACK TO select_item_pvt;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: IF FND_MSG_PUB.Check_Msg_Level
205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: FND_MSG_PUB.Add_Exc_Msg
208: ( G_PKG_NAME ,

Line 205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

201: WHEN OTHERS THEN
202: ROLLBACK TO select_item_pvt;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: IF FND_MSG_PUB.Check_Msg_Level
205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: FND_MSG_PUB.Add_Exc_Msg
208: ( G_PKG_NAME ,
209: l_api_name

Line 207: FND_MSG_PUB.Add_Exc_Msg

203: x_return_status := FND_API.G_RET_STS_ERROR;
204: IF FND_MSG_PUB.Check_Msg_Level
205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: FND_MSG_PUB.Add_Exc_Msg
208: ( G_PKG_NAME ,
209: l_api_name
210: );
211: END IF;

Line 212: FND_MSG_PUB.Count_And_Get

208: ( G_PKG_NAME ,
209: l_api_name
210: );
211: END IF;
212: FND_MSG_PUB.Count_And_Get
213: ( p_count => x_msg_count ,
214: p_data => x_msg_data
215: );
216:

Line 249: FND_MSG_PUB.initialize;

245:
246: -- Initialize message list if p_init_msg_list is set to TRUE.
247: IF FND_API.to_Boolean( p_init_msg_list )
248: THEN
249: FND_MSG_PUB.initialize;
250: END IF;
251:
252: -- Initialize API return status to SUCCESS
253: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

290: EXCEPTION
291: WHEN CREATE_ITEM_EXCP THEN
292: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
293: x_return_status := FND_API.G_RET_STS_ERROR ;
294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
297: x_return_status := FND_API.G_RET_STS_ERROR ;
298: FND_MSG_PUB.Count_And_Get

Line 298: FND_MSG_PUB.Count_And_Get

294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
297: x_return_status := FND_API.G_RET_STS_ERROR ;
298: FND_MSG_PUB.Count_And_Get
299: ( p_count => x_msg_count,
300: p_data => x_msg_data
301: );
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 305: FND_MSG_PUB.Count_And_Get

301: );
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
303: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
305: FND_MSG_PUB.Count_And_Get
306: ( p_count => x_msg_count,
307: p_data => x_msg_data
308: );
309: WHEN OTHERS THEN

Line 312: IF FND_MSG_PUB.Check_Msg_Level

308: );
309: WHEN OTHERS THEN
310: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: IF FND_MSG_PUB.Check_Msg_Level
313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
314: THEN
315: FND_MSG_PUB.Add_Exc_Msg
316: ( G_PKG_NAME ,

Line 313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

309: WHEN OTHERS THEN
310: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: IF FND_MSG_PUB.Check_Msg_Level
313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
314: THEN
315: FND_MSG_PUB.Add_Exc_Msg
316: ( G_PKG_NAME ,
317: l_api_name

Line 315: FND_MSG_PUB.Add_Exc_Msg

311: x_return_status := FND_API.G_RET_STS_ERROR;
312: IF FND_MSG_PUB.Check_Msg_Level
313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
314: THEN
315: FND_MSG_PUB.Add_Exc_Msg
316: ( G_PKG_NAME ,
317: l_api_name
318: );
319: END IF;

Line 320: FND_MSG_PUB.Count_And_Get

316: ( G_PKG_NAME ,
317: l_api_name
318: );
319: END IF;
320: FND_MSG_PUB.Count_And_Get
321: ( p_count => x_msg_count ,
322: p_data => x_msg_data
323: );
324: END create_item_wrap;