DBA Data[Home] [Help]

APPS.IEM_EMAIL_SERVER_TYPES_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: -- Initialize API return status to SUCCESS
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58: SELECT iem_email_server_types_s1.nextval

Line 118: FND_MSG_PUB.Count_And_Get

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

Line 126: FND_MSG_PUB.Count_And_Get

122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: ROLLBACK TO create_item_PVT;
125: x_return_status := FND_API.G_RET_STS_ERROR ;
126: FND_MSG_PUB.Count_And_Get
127: ( p_count => x_msg_count,
128: p_data => x_msg_data
129: );
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 133: FND_MSG_PUB.Count_And_Get

129: );
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: ROLLBACK TO create_item_PVT;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
133: FND_MSG_PUB.Count_And_Get
134: ( p_count => x_msg_count,
135: p_data => x_msg_data
136: );
137: WHEN OTHERS THEN

Line 140: IF FND_MSG_PUB.Check_Msg_Level

136: );
137: WHEN OTHERS THEN
138: ROLLBACK TO create_item_PVT;
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: IF FND_MSG_PUB.Check_Msg_Level
141: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
142: THEN
143: FND_MSG_PUB.Add_Exc_Msg
144: ( G_PKG_NAME ,

Line 141: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

137: WHEN OTHERS THEN
138: ROLLBACK TO create_item_PVT;
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: IF FND_MSG_PUB.Check_Msg_Level
141: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
142: THEN
143: FND_MSG_PUB.Add_Exc_Msg
144: ( G_PKG_NAME ,
145: l_api_name

Line 143: FND_MSG_PUB.Add_Exc_Msg

139: x_return_status := FND_API.G_RET_STS_ERROR;
140: IF FND_MSG_PUB.Check_Msg_Level
141: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
142: THEN
143: FND_MSG_PUB.Add_Exc_Msg
144: ( G_PKG_NAME ,
145: l_api_name
146: );
147: END IF;

Line 148: FND_MSG_PUB.Count_And_Get

144: ( G_PKG_NAME ,
145: l_api_name
146: );
147: END IF;
148: FND_MSG_PUB.Count_And_Get
149: ( p_count => x_msg_count ,
150: p_data => x_msg_data
151: );
152:

Line 182: FND_MSG_PUB.initialize;

178: END IF;
179: -- Initialize message list if p_init_msg_list is set to TRUE.
180: IF FND_API.to_Boolean( p_init_msg_list )
181: THEN
182: FND_MSG_PUB.initialize;
183: END IF;
184: -- Initialize API return status to SUCCESS
185: x_return_status := FND_API.G_RET_STS_SUCCESS;
186: if p_server_type_id is null then

Line 206: FND_MSG_PUB.Count_And_Get

202: IF FND_API.To_Boolean(p_commit) THEN
203: COMMIT WORK;
204: END IF;
205: -- Standard callto get message count and if count is 1, get message info.
206: FND_MSG_PUB.Count_And_Get
207: ( p_count => x_msg_count,
208: p_data => x_msg_data
209: );
210: EXCEPTION

Line 214: FND_MSG_PUB.Count_And_Get

210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO delete_item_PVT;
213: x_return_status := FND_API.G_RET_STS_ERROR ;
214: FND_MSG_PUB.Count_And_Get
215: ( p_count => x_msg_count,
216: p_data => x_msg_data
217: );
218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 221: FND_MSG_PUB.Count_And_Get

217: );
218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
219: ROLLBACK TO delete_item_PVT;
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
221: FND_MSG_PUB.Count_And_Get
222: ( p_count => x_msg_count,
223: p_data => x_msg_data
224: );
225: WHEN OTHERS THEN

Line 228: IF FND_MSG_PUB.Check_Msg_Level

224: );
225: WHEN OTHERS THEN
226: ROLLBACK TO delete_item_PVT;
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: IF FND_MSG_PUB.Check_Msg_Level
229: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
230: THEN
231: FND_MSG_PUB.Add_Exc_Msg
232: ( G_PKG_NAME ,

Line 229: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

225: WHEN OTHERS THEN
226: ROLLBACK TO delete_item_PVT;
227: x_return_status := FND_API.G_RET_STS_ERROR;
228: IF FND_MSG_PUB.Check_Msg_Level
229: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
230: THEN
231: FND_MSG_PUB.Add_Exc_Msg
232: ( G_PKG_NAME ,
233: l_api_name

Line 231: FND_MSG_PUB.Add_Exc_Msg

227: x_return_status := FND_API.G_RET_STS_ERROR;
228: IF FND_MSG_PUB.Check_Msg_Level
229: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
230: THEN
231: FND_MSG_PUB.Add_Exc_Msg
232: ( G_PKG_NAME ,
233: l_api_name
234: );
235: END IF;

Line 236: FND_MSG_PUB.Count_And_Get

232: ( G_PKG_NAME ,
233: l_api_name
234: );
235: END IF;
236: FND_MSG_PUB.Count_And_Get
237: ( p_count => x_msg_count ,
238: p_data => x_msg_data
239: );
240:

Line 290: FND_MSG_PUB.initialize;

286: END IF;
287: -- Initialize message list if p_init_msg_list is set to TRUE.
288: IF FND_API.to_Boolean( p_init_msg_list )
289: THEN
290: FND_MSG_PUB.initialize;
291: END IF;
292: -- Initialize API return status to SUCCESS
293: x_return_status := FND_API.G_RET_STS_SUCCESS;
294: if p_server_type_id is null then

Line 350: FND_MSG_PUB.Count_And_Get

346: IF FND_API.To_Boolean(p_commit) THEN
347: COMMIT WORK;
348: END IF;
349: -- Standard callto get message count and if count is 1, get message info.
350: FND_MSG_PUB.Count_And_Get
351: ( p_count => x_msg_count,
352: p_data => x_msg_data
353: );
354: EXCEPTION

Line 358: FND_MSG_PUB.Count_And_Get

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

Line 365: FND_MSG_PUB.Count_And_Get

361: );
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363: ROLLBACK TO update_item_PVT;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
365: FND_MSG_PUB.Count_And_Get
366: ( p_count => x_msg_count,
367: p_data => x_msg_data
368: );
369: WHEN OTHERS THEN

Line 372: IF FND_MSG_PUB.Check_Msg_Level

368: );
369: WHEN OTHERS THEN
370: ROLLBACK TO update_item_PVT;
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: IF FND_MSG_PUB.Check_Msg_Level
373: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
374: THEN
375: FND_MSG_PUB.Add_Exc_Msg
376: ( G_PKG_NAME ,

Line 373: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

369: WHEN OTHERS THEN
370: ROLLBACK TO update_item_PVT;
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: IF FND_MSG_PUB.Check_Msg_Level
373: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
374: THEN
375: FND_MSG_PUB.Add_Exc_Msg
376: ( G_PKG_NAME ,
377: l_api_name

Line 375: FND_MSG_PUB.Add_Exc_Msg

371: x_return_status := FND_API.G_RET_STS_ERROR;
372: IF FND_MSG_PUB.Check_Msg_Level
373: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
374: THEN
375: FND_MSG_PUB.Add_Exc_Msg
376: ( G_PKG_NAME ,
377: l_api_name
378: );
379: END IF;

Line 380: FND_MSG_PUB.Count_And_Get

376: ( G_PKG_NAME ,
377: l_api_name
378: );
379: END IF;
380: FND_MSG_PUB.Count_And_Get
381: ( p_count => x_msg_count ,
382: p_data => x_msg_data
383: );
384: