DBA Data[Home] [Help]

APPS.IEM_EMAIL_ICNTR_MAPS_PVT dependencies on FND_MSG_PUB

Line 53: FND_MSG_PUB.initialize;

49: END IF;
50: -- Initialize message list if p_init_msg_list is set to TRUE.
51: IF FND_API.to_Boolean( p_init_msg_list )
52: THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55: -- Initialize API return status to SUCCESS
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:

Line 130: FND_MSG_PUB.Count_And_Get

126: IF FND_API.To_Boolean(p_commit) THEN
127: COMMIT WORK;
128: END IF;
129: -- Standard callto get message count and if count is 1, get message info.
130: FND_MSG_PUB.Count_And_Get
131: ( p_count => x_msg_count,
132: p_data => x_msg_data
133: );
134: EXCEPTION

Line 138: FND_MSG_PUB.Count_And_Get

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

Line 145: FND_MSG_PUB.Count_And_Get

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

Line 152: IF FND_MSG_PUB.Check_Msg_Level

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

Line 153: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 155: FND_MSG_PUB.Add_Exc_Msg

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

Line 160: FND_MSG_PUB.Count_And_Get

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

Line 193: FND_MSG_PUB.initialize;

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

Line 211: FND_MSG_PUB.Count_And_Get

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

Line 219: FND_MSG_PUB.Count_And_Get

215: EXCEPTION
216: WHEN FND_API.G_EXC_ERROR THEN
217: ROLLBACK TO delete_item_PVT;
218: x_return_status := FND_API.G_RET_STS_ERROR ;
219: FND_MSG_PUB.Count_And_Get
220: ( p_count => x_msg_count,
221: p_data => x_msg_data
222: );
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 226: FND_MSG_PUB.Count_And_Get

222: );
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO delete_item_PVT;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
226: FND_MSG_PUB.Count_And_Get
227: ( p_count => x_msg_count,
228: p_data => x_msg_data
229: );
230: WHEN OTHERS THEN

Line 233: IF FND_MSG_PUB.Check_Msg_Level

229: );
230: WHEN OTHERS THEN
231: ROLLBACK TO delete_item_PVT;
232: x_return_status := FND_API.G_RET_STS_ERROR;
233: IF FND_MSG_PUB.Check_Msg_Level
234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg
237: ( G_PKG_NAME ,

Line 234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 236: FND_MSG_PUB.Add_Exc_Msg

232: x_return_status := FND_API.G_RET_STS_ERROR;
233: IF FND_MSG_PUB.Check_Msg_Level
234: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg
237: ( G_PKG_NAME ,
238: l_api_name
239: );
240: END IF;

Line 241: FND_MSG_PUB.Count_And_Get

237: ( G_PKG_NAME ,
238: l_api_name
239: );
240: END IF;
241: FND_MSG_PUB.Count_And_Get
242: ( p_count => x_msg_count ,
243: p_data => x_msg_data
244: );
245:

Line 297: FND_MSG_PUB.initialize;

293: END IF;
294: -- Initialize message list if p_init_msg_list is set to TRUE.
295: IF FND_API.to_Boolean( p_init_msg_list )
296: THEN
297: FND_MSG_PUB.initialize;
298: END IF;
299: -- Initialize API return status to SUCCESS
300: x_return_status := FND_API.G_RET_STS_SUCCESS;
301:

Line 363: FND_MSG_PUB.Count_And_Get

359: IF FND_API.To_Boolean(p_commit) THEN
360: COMMIT WORK;
361: END IF;
362: -- Standard callto get message count and if count is 1, get message info.
363: FND_MSG_PUB.Count_And_Get
364: ( p_count => x_msg_count,
365: p_data => x_msg_data
366: );
367: EXCEPTION

Line 371: FND_MSG_PUB.Count_And_Get

367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369: ROLLBACK TO update_item_PVT;
370: x_return_status := FND_API.G_RET_STS_ERROR ;
371: FND_MSG_PUB.Count_And_Get
372: ( p_count => x_msg_count,
373: p_data => x_msg_data
374: );
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 378: FND_MSG_PUB.Count_And_Get

374: );
375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
376: ROLLBACK TO update_item_PVT;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
378: FND_MSG_PUB.Count_And_Get
379: ( p_count => x_msg_count,
380: p_data => x_msg_data
381: );
382: WHEN OTHERS THEN

Line 385: IF FND_MSG_PUB.Check_Msg_Level

381: );
382: WHEN OTHERS THEN
383: ROLLBACK TO update_item_PVT;
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: IF FND_MSG_PUB.Check_Msg_Level
386: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
387: THEN
388: FND_MSG_PUB.Add_Exc_Msg
389: ( G_PKG_NAME ,

Line 386: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

382: WHEN OTHERS THEN
383: ROLLBACK TO update_item_PVT;
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: IF FND_MSG_PUB.Check_Msg_Level
386: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
387: THEN
388: FND_MSG_PUB.Add_Exc_Msg
389: ( G_PKG_NAME ,
390: l_api_name

Line 388: FND_MSG_PUB.Add_Exc_Msg

384: x_return_status := FND_API.G_RET_STS_ERROR;
385: IF FND_MSG_PUB.Check_Msg_Level
386: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
387: THEN
388: FND_MSG_PUB.Add_Exc_Msg
389: ( G_PKG_NAME ,
390: l_api_name
391: );
392: END IF;

Line 393: FND_MSG_PUB.Count_And_Get

389: ( G_PKG_NAME ,
390: l_api_name
391: );
392: END IF;
393: FND_MSG_PUB.Count_And_Get
394: ( p_count => x_msg_count ,
395: p_data => x_msg_data
396: );
397: