DBA Data[Home] [Help]

APPS.IEM_EMAILACCOUNT_PUB dependencies on FND_MSG_PUB

Line 49: FND_MSG_PUB.initialize;

45: END IF;
46: -- Initialize message list if p_init_msg_list is set to TRUE.
47: IF FND_API.to_Boolean( p_init_msg_list )
48: THEN
49: FND_MSG_PUB.initialize;
50: END IF;
51: -- Initialize API return status to SUCCESS
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53: IF p_resource_id is not null then

Line 85: FND_MSG_PUB.Count_And_Get

81: IF FND_API.To_Boolean(p_commit) THEN
82: COMMIT WORK;
83: END IF;
84: -- Standard callto get message count and if count is 1, get message info.
85: FND_MSG_PUB.Count_And_Get
86: ( p_count => x_msg_count,
87: p_data => x_msg_data
88: );
89: EXCEPTION

Line 93: FND_MSG_PUB.Count_And_Get

89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN
91: ROLLBACK TO Get_EmailAccount_List_PUB;
92: x_return_status := FND_API.G_RET_STS_ERROR ;
93: FND_MSG_PUB.Count_And_Get
94: ( p_count => x_msg_count,
95: p_data => x_msg_data
96: );
97: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 100: FND_MSG_PUB.Count_And_Get

96: );
97: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
98: ROLLBACK TO Get_EmailAccount_List_PUB;
99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
100: FND_MSG_PUB.Count_And_Get
101: ( p_count => x_msg_count,
102: p_data => x_msg_data
103: );
104: WHEN OTHERS THEN

Line 107: IF FND_MSG_PUB.Check_Msg_Level

103: );
104: WHEN OTHERS THEN
105: ROLLBACK TO Get_EmailAccount_List_PUB;
106: x_return_status := FND_API.G_RET_STS_ERROR;
107: IF FND_MSG_PUB.Check_Msg_Level
108: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
109: THEN
110: FND_MSG_PUB.Add_Exc_Msg
111: ( G_PKG_NAME ,

Line 108: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

104: WHEN OTHERS THEN
105: ROLLBACK TO Get_EmailAccount_List_PUB;
106: x_return_status := FND_API.G_RET_STS_ERROR;
107: IF FND_MSG_PUB.Check_Msg_Level
108: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
109: THEN
110: FND_MSG_PUB.Add_Exc_Msg
111: ( G_PKG_NAME ,
112: l_api_name

Line 110: FND_MSG_PUB.Add_Exc_Msg

106: x_return_status := FND_API.G_RET_STS_ERROR;
107: IF FND_MSG_PUB.Check_Msg_Level
108: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
109: THEN
110: FND_MSG_PUB.Add_Exc_Msg
111: ( G_PKG_NAME ,
112: l_api_name
113: );
114: END IF;

Line 115: FND_MSG_PUB.Count_And_Get

111: ( G_PKG_NAME ,
112: l_api_name
113: );
114: END IF;
115: FND_MSG_PUB.Count_And_Get
116: ( p_count => x_msg_count ,
117: p_data => x_msg_data
118: );
119:

Line 176: FND_MSG_PUB.initialize;

172: END IF;
173: -- Initialize message list if p_init_msg_list is set to TRUE.
174: IF FND_API.to_Boolean( p_init_msg_list )
175: THEN
176: FND_MSG_PUB.initialize;
177: END IF;
178: -- Initialize API return status to SUCCESS
179: x_return_status := FND_API.G_RET_STS_SUCCESS;
180: IF p_resource_id is not null then

Line 212: FND_MSG_PUB.Count_And_Get

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

Line 220: FND_MSG_PUB.Count_And_Get

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

Line 227: FND_MSG_PUB.Count_And_Get

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

Line 234: IF FND_MSG_PUB.Check_Msg_Level

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

Line 235: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 237: FND_MSG_PUB.Add_Exc_Msg

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

Line 242: FND_MSG_PUB.Count_And_Get

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

Line 444: FND_MSG_PUB.Count_And_Get

440: IF FND_API.To_Boolean(p_commit) THEN
441: COMMIT WORK;
442: END IF;
443: -- Standard callto get message count and if count is 1, get message info.
444: FND_MSG_PUB.Count_And_Get
445: ( p_count => x_msg_count,
446: p_data => x_msg_data
447: );
448: EXCEPTION

Line 452: FND_MSG_PUB.Count_And_Get

448: EXCEPTION
449: WHEN FND_API.G_EXC_ERROR THEN
450: ROLLBACK TO ListAgentAccountDetails_PUB;
451: x_return_status := FND_API.G_RET_STS_ERROR ;
452: FND_MSG_PUB.Count_And_Get
453: ( p_count => x_msg_count,
454: p_data => x_msg_data
455: );
456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 459: FND_MSG_PUB.Count_And_Get

455: );
456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
457: ROLLBACK TO ListAgentAccountDetails_PUB;
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
459: FND_MSG_PUB.Count_And_Get
460: ( p_count => x_msg_count,
461: p_data => x_msg_data
462: );
463: WHEN OTHERS THEN

Line 466: IF FND_MSG_PUB.Check_Msg_Level

462: );
463: WHEN OTHERS THEN
464: ROLLBACK TO ListAgentAccountDetails_PUB;
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: IF FND_MSG_PUB.Check_Msg_Level
467: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
468: THEN
469: FND_MSG_PUB.Add_Exc_Msg
470: ( G_PKG_NAME,

Line 467: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

463: WHEN OTHERS THEN
464: ROLLBACK TO ListAgentAccountDetails_PUB;
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: IF FND_MSG_PUB.Check_Msg_Level
467: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
468: THEN
469: FND_MSG_PUB.Add_Exc_Msg
470: ( G_PKG_NAME,
471: l_api_name

Line 469: FND_MSG_PUB.Add_Exc_Msg

465: x_return_status := FND_API.G_RET_STS_ERROR;
466: IF FND_MSG_PUB.Check_Msg_Level
467: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
468: THEN
469: FND_MSG_PUB.Add_Exc_Msg
470: ( G_PKG_NAME,
471: l_api_name
472: );
473: END IF;

Line 474: FND_MSG_PUB.Count_And_Get

470: ( G_PKG_NAME,
471: l_api_name
472: );
473: END IF;
474: FND_MSG_PUB.Count_And_Get
475: ( p_count => x_msg_count,
476: p_data => x_msg_data
477: );
478:

Line 522: FND_MSG_PUB.initialize;

518: END IF;
519: -- Initialize message list if p_init_msg_list is set to TRUE.
520: IF FND_API.to_Boolean( p_init_msg_list )
521: THEN
522: FND_MSG_PUB.initialize;
523: END IF;
524: -- Initialize API return status to SUCCESS
525: x_return_status := FND_API.G_RET_STS_SUCCESS;
526: IF p_email_account_id is not null then

Line 547: FND_MSG_PUB.Count_And_Get

543: IF FND_API.To_Boolean(p_commit) THEN
544: COMMIT WORK;
545: END IF;
546: -- Standard callto get message count and if count is 1, get message info.
547: FND_MSG_PUB.Count_And_Get
548: ( p_count => x_msg_count,
549: p_data => x_msg_data
550: );
551: EXCEPTION

Line 555: FND_MSG_PUB.Count_And_Get

551: EXCEPTION
552: WHEN FND_API.G_EXC_ERROR THEN
553: ROLLBACK TO ListAccountDetails_PUB;
554: x_return_status := FND_API.G_RET_STS_ERROR ;
555: FND_MSG_PUB.Count_And_Get
556: ( p_count => x_msg_count,
557: p_data => x_msg_data
558: );
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 562: FND_MSG_PUB.Count_And_Get

558: );
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: ROLLBACK TO ListAccountDetails_PUB;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
562: FND_MSG_PUB.Count_And_Get
563: ( p_count => x_msg_count,
564: p_data => x_msg_data
565: );
566: WHEN OTHERS THEN

Line 569: IF FND_MSG_PUB.Check_Msg_Level

565: );
566: WHEN OTHERS THEN
567: ROLLBACK TO ListAccountDetails_PUB;
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: IF FND_MSG_PUB.Check_Msg_Level
570: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg
573: ( G_PKG_NAME,

Line 570: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

566: WHEN OTHERS THEN
567: ROLLBACK TO ListAccountDetails_PUB;
568: x_return_status := FND_API.G_RET_STS_ERROR;
569: IF FND_MSG_PUB.Check_Msg_Level
570: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg
573: ( G_PKG_NAME,
574: l_api_name

Line 572: FND_MSG_PUB.Add_Exc_Msg

568: x_return_status := FND_API.G_RET_STS_ERROR;
569: IF FND_MSG_PUB.Check_Msg_Level
570: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
571: THEN
572: FND_MSG_PUB.Add_Exc_Msg
573: ( G_PKG_NAME,
574: l_api_name
575: );
576: END IF;

Line 577: FND_MSG_PUB.Count_And_Get

573: ( G_PKG_NAME,
574: l_api_name
575: );
576: END IF;
577: FND_MSG_PUB.Count_And_Get
578: ( p_count => x_msg_count,
579: p_data => x_msg_data
580: );
581: