DBA Data[Home] [Help]

APPS.IEM_SPV_MONITORING_PVT dependencies on FND_MSG_PUB

Line 54: FND_MSG_PUB.initialize;

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

Line 169: FND_MSG_PUB.Count_And_Get

165: IF FND_API.To_Boolean(p_commit) THEN
166: COMMIT WORK;
167: END IF;
168: -- Standard callto get message count and if count is 1, get message info.
169: FND_MSG_PUB.Count_And_Get
170: ( p_count => x_msg_count,
171: p_data => x_msg_data
172: );
173: EXCEPTION

Line 178: FND_MSG_PUB.Count_And_Get

174:
175: WHEN FND_API.G_EXC_ERROR THEN
176: ROLLBACK TO get_email_activity_pvt;
177: x_return_status := FND_API.G_RET_STS_ERROR ;
178: FND_MSG_PUB.Count_And_Get
179: ( p_count => x_msg_count,
180: p_data => x_msg_data
181: );
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 185: FND_MSG_PUB.Count_And_Get

181: );
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: ROLLBACK TO get_email_activity_pvt;
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
185: FND_MSG_PUB.Count_And_Get
186: ( p_count => x_msg_count,
187: p_data => x_msg_data
188: );
189: WHEN OTHERS THEN

Line 192: IF FND_MSG_PUB.Check_Msg_Level

188: );
189: WHEN OTHERS THEN
190: ROLLBACK TO get_email_activity_pvt;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: IF FND_MSG_PUB.Check_Msg_Level
193: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
194: THEN
195: FND_MSG_PUB.Add_Exc_Msg
196: ( G_PKG_NAME,

Line 193: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

189: WHEN OTHERS THEN
190: ROLLBACK TO get_email_activity_pvt;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: IF FND_MSG_PUB.Check_Msg_Level
193: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
194: THEN
195: FND_MSG_PUB.Add_Exc_Msg
196: ( G_PKG_NAME,
197: l_api_name

Line 195: FND_MSG_PUB.Add_Exc_Msg

191: x_return_status := FND_API.G_RET_STS_ERROR;
192: IF FND_MSG_PUB.Check_Msg_Level
193: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
194: THEN
195: FND_MSG_PUB.Add_Exc_Msg
196: ( G_PKG_NAME,
197: l_api_name
198: );
199: END IF;

Line 200: FND_MSG_PUB.Count_And_Get

196: ( G_PKG_NAME,
197: l_api_name
198: );
199: END IF;
200: FND_MSG_PUB.Count_And_Get
201: (p_count => x_msg_count,
202: p_data => x_msg_data
203: );
204: END get_email_activity;

Line 261: FND_MSG_PUB.initialize;

257: END IF;
258: -- Initialize message list if p_init_msg_list is set to TRUE.
259: IF FND_API.to_Boolean( p_init_msg_list )
260: THEN
261: FND_MSG_PUB.initialize;
262: END IF;
263:
264: -- Initialize API return status to SUCCESS
265: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 431: FND_MSG_PUB.Count_And_Get

427: IF FND_API.To_Boolean(p_commit) THEN
428: COMMIT WORK;
429: END IF;
430: -- Standard callto get message count and if count is 1, get message info.
431: FND_MSG_PUB.Count_And_Get
432: ( p_count => x_msg_count,
433: p_data => x_msg_data
434: );
435: EXCEPTION

Line 440: FND_MSG_PUB.Count_And_Get

436:
437: WHEN FND_API.G_EXC_ERROR THEN
438: ROLLBACK TO get_email_activity_pvt;
439: x_return_status := FND_API.G_RET_STS_ERROR ;
440: FND_MSG_PUB.Count_And_Get
441: ( p_count => x_msg_count,
442: p_data => x_msg_data
443: );
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 447: FND_MSG_PUB.Count_And_Get

443: );
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445: ROLLBACK TO get_email_activity_pvt;
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
447: FND_MSG_PUB.Count_And_Get
448: ( p_count => x_msg_count,
449: p_data => x_msg_data
450: );
451: WHEN OTHERS THEN

Line 454: IF FND_MSG_PUB.Check_Msg_Level

450: );
451: WHEN OTHERS THEN
452: ROLLBACK TO get_email_activity_pvt;
453: x_return_status := FND_API.G_RET_STS_ERROR;
454: IF FND_MSG_PUB.Check_Msg_Level
455: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
456: THEN
457: FND_MSG_PUB.Add_Exc_Msg
458: ( G_PKG_NAME,

Line 455: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

451: WHEN OTHERS THEN
452: ROLLBACK TO get_email_activity_pvt;
453: x_return_status := FND_API.G_RET_STS_ERROR;
454: IF FND_MSG_PUB.Check_Msg_Level
455: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
456: THEN
457: FND_MSG_PUB.Add_Exc_Msg
458: ( G_PKG_NAME,
459: l_api_name

Line 457: FND_MSG_PUB.Add_Exc_Msg

453: x_return_status := FND_API.G_RET_STS_ERROR;
454: IF FND_MSG_PUB.Check_Msg_Level
455: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
456: THEN
457: FND_MSG_PUB.Add_Exc_Msg
458: ( G_PKG_NAME,
459: l_api_name
460: );
461: END IF;

Line 462: FND_MSG_PUB.Count_And_Get

458: ( G_PKG_NAME,
459: l_api_name
460: );
461: END IF;
462: FND_MSG_PUB.Count_And_Get
463: (p_count => x_msg_count,
464: p_data => x_msg_data
465: );
466: END get_agent_activity;