eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_EML_CLASSIFICATIONS_PVT dependencies on FND_API

Line 13: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

9: -- Pre-reqs : None.
10: -- Parameters :
11: -- IN
12: -- p_api_version_number IN NUMBER Required
13: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
14: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
15: -- p_email_account_id IN NUMBER,
16: -- p_classification_id IN NUMBER,
17: -- p_score IN NUMBER,

Line 14: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

10: -- Parameters :
11: -- IN
12: -- p_api_version_number IN NUMBER Required
13: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
14: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
15: -- p_email_account_id IN NUMBER,
16: -- p_classification_id IN NUMBER,
17: -- p_score IN NUMBER,
18: -- p_message_id IN NUMBER,

Line 56: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

52: BEGIN
53: -- Standard Start of API savepoint
54: -- SAVEPOINT create_item_PVT;
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
57: p_api_version_number,
58: l_api_name,
59: G_PKG_NAME)
60: THEN

Line 61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

57: p_api_version_number,
58: l_api_name,
59: G_PKG_NAME)
60: THEN
61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
62: END IF;
63: -- Initialize message list if p_init_msg_list is set to TRUE.
64: IF FND_API.to_Boolean( p_init_msg_list )
65: THEN

Line 64: IF FND_API.to_Boolean( p_init_msg_list )

60: THEN
61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
62: END IF;
63: -- Initialize message list if p_init_msg_list is set to TRUE.
64: IF FND_API.to_Boolean( p_init_msg_list )
65: THEN
66: FND_MSG_PUB.initialize;
67: END IF;
68: -- Initialize API return status to SUCCESS

Line 69: x_return_status := FND_API.G_RET_STS_SUCCESS;

65: THEN
66: FND_MSG_PUB.initialize;
67: END IF;
68: -- Initialize API return status to SUCCESS
69: x_return_status := FND_API.G_RET_STS_SUCCESS;
70: select count(*) into l_count from iem_email_classifications
71: where message_id=p_message_id
72: and classification_id=p_classification_id;
73: IF l_count=0 then

Line 100: IF FND_API.To_Boolean(p_commit) THEN

96: DECODE(p_LAST_UPDATE_LOGIN,null,-1,p_last_update_login)
97: );
98: END IF;
99: -- Standard Check Of p_commit.
100: IF FND_API.To_Boolean(p_commit) THEN
101: COMMIT WORK;
102: END IF;
103: -- Standard callto get message count and if count is 1, get message info.
104: FND_MSG_PUB.Count_And_Get

Line 109: WHEN FND_API.G_EXC_ERROR THEN

105: ( p_count => x_msg_count,
106: p_data => x_msg_data
107: );
108: EXCEPTION
109: WHEN FND_API.G_EXC_ERROR THEN
110: -- ROLLBACK TO update_item_PVT;
111: x_return_status := FND_API.G_RET_STS_ERROR ;
112: FND_MSG_PUB.Count_And_Get
113: ( p_count => x_msg_count,

Line 111: x_return_status := FND_API.G_RET_STS_ERROR ;

107: );
108: EXCEPTION
109: WHEN FND_API.G_EXC_ERROR THEN
110: -- ROLLBACK TO update_item_PVT;
111: x_return_status := FND_API.G_RET_STS_ERROR ;
112: FND_MSG_PUB.Count_And_Get
113: ( p_count => x_msg_count,
114: p_data => x_msg_data
115: );

Line 116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

112: FND_MSG_PUB.Count_And_Get
113: ( p_count => x_msg_count,
114: p_data => x_msg_data
115: );
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117: -- ROLLBACK TO update_item_PVT;
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: FND_MSG_PUB.Count_And_Get
120: ( p_count => x_msg_count,

Line 118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

114: p_data => x_msg_data
115: );
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117: -- ROLLBACK TO update_item_PVT;
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: FND_MSG_PUB.Count_And_Get
120: ( p_count => x_msg_count,
121: p_data => x_msg_data
122: );

Line 125: x_return_status := FND_API.G_RET_STS_ERROR;

121: p_data => x_msg_data
122: );
123: WHEN OTHERS THEN
124: -- ROLLBACK TO update_item_PVT;
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: IF FND_MSG_PUB.Check_Msg_Level
127: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
128: THEN
129: FND_MSG_PUB.Add_Exc_Msg

Line 150: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

146: -- Pre-reqs : None.
147: -- Parameters :
148: -- IN
149: -- p_api_version_number IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- p_email_account_id in number:=FND_API.G_MISS_NUM,
153: -- p_classification_id IN NUMBER:=FND_API.G_MISS_NUM,
154:

Line 151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

147: -- Parameters :
148: -- IN
149: -- p_api_version_number IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- p_email_account_id in number:=FND_API.G_MISS_NUM,
153: -- p_classification_id IN NUMBER:=FND_API.G_MISS_NUM,
154:
155: -- OUT

Line 152: -- p_email_account_id in number:=FND_API.G_MISS_NUM,

148: -- IN
149: -- p_api_version_number IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- p_email_account_id in number:=FND_API.G_MISS_NUM,
153: -- p_classification_id IN NUMBER:=FND_API.G_MISS_NUM,
154:
155: -- OUT
156: -- x_return_status OUT VARCHAR2

Line 153: -- p_classification_id IN NUMBER:=FND_API.G_MISS_NUM,

149: -- p_api_version_number IN NUMBER Required
150: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
151: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
152: -- p_email_account_id in number:=FND_API.G_MISS_NUM,
153: -- p_classification_id IN NUMBER:=FND_API.G_MISS_NUM,
154:
155: -- OUT
156: -- x_return_status OUT VARCHAR2
157: -- x_msg_count OUT NUMBER

Line 184: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

180: BEGIN
181: -- Standard Start of API savepoint
182: --SAVEPOINT delete_item_PVT;
183: -- Standard call to check for call compatibility.
184: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
185: p_api_version_number,
186: l_api_name,
187: G_PKG_NAME)
188: THEN

Line 189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

185: p_api_version_number,
186: l_api_name,
187: G_PKG_NAME)
188: THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191: -- Initialize message list if p_init_msg_list is set to TRUE.
192: IF FND_API.to_Boolean( p_init_msg_list )
193: THEN

Line 192: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 197: x_return_status := FND_API.G_RET_STS_SUCCESS;

193: THEN
194: FND_MSG_PUB.initialize;
195: END IF;
196: -- Initialize API return status to SUCCESS
197: x_return_status := FND_API.G_RET_STS_SUCCESS;
198: DELETE FROM IEM_EMAIL_CLASSIFICATIONS
199: where message_id=p_message_id
200: and classification_id=p_classification_id
201: and email_account_id=p_email_account_id;

Line 203: IF FND_API.To_Boolean(p_commit) THEN

199: where message_id=p_message_id
200: and classification_id=p_classification_id
201: and email_account_id=p_email_account_id;
202: -- Standard Check Of p_commit.
203: IF FND_API.To_Boolean(p_commit) THEN
204: COMMIT WORK;
205: END IF;
206: -- Standard callto get message count and if count is 1, get message info.
207: FND_MSG_PUB.Count_And_Get

Line 212: WHEN FND_API.G_EXC_ERROR THEN

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

Line 214: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 228: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 269: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

265: BEGIN
266: -- Standard Start of API savepoint
267: --SAVEPOINT getClassification_pvt;
268: -- Standard call to check for call compatibility.
269: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
270: p_api_version_number,
271: l_api_name,
272: G_PKG_NAME)
273: THEN

Line 274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

270: p_api_version_number,
271: l_api_name,
272: G_PKG_NAME)
273: THEN
274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
275: END IF;
276: -- Initialize message list if p_init_msg_list is set to TRUE.
277: IF FND_API.to_Boolean( p_init_msg_list )
278: THEN

Line 277: IF FND_API.to_Boolean( p_init_msg_list )

273: THEN
274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
275: END IF;
276: -- Initialize message list if p_init_msg_list is set to TRUE.
277: IF FND_API.to_Boolean( p_init_msg_list )
278: THEN
279: FND_MSG_PUB.initialize;
280: END IF;
281: -- Initialize API return status to SUCCESS

Line 282: x_return_status := FND_API.G_RET_STS_SUCCESS;

278: THEN
279: FND_MSG_PUB.initialize;
280: END IF;
281: -- Initialize API return status to SUCCESS
282: x_return_status := FND_API.G_RET_STS_SUCCESS;
283:
284:
285: FOR class_rec in class_scr
286: LOOP

Line 296: IF FND_API.To_Boolean(p_commit) THEN

292:
293: END LOOP;
294:
295: -- Standard Check Of p_commit.
296: IF FND_API.To_Boolean(p_commit) THEN
297: COMMIT WORK;
298: END IF;
299: -- Standard callto get message count and if count is 1, get message info.
300: FND_MSG_PUB.Count_And_Get

Line 307: WHEN FND_API.G_EXC_ERROR THEN

303: );
304:
305:
306: EXCEPTION
307: WHEN FND_API.G_EXC_ERROR THEN
308: --ROLLBACK TO getclassification_pvt;
309: x_return_status := FND_API.G_RET_STS_ERROR ;
310: FND_MSG_PUB.Count_And_Get
311: ( p_count => x_msg_count,

Line 309: x_return_status := FND_API.G_RET_STS_ERROR ;

305:
306: EXCEPTION
307: WHEN FND_API.G_EXC_ERROR THEN
308: --ROLLBACK TO getclassification_pvt;
309: x_return_status := FND_API.G_RET_STS_ERROR ;
310: FND_MSG_PUB.Count_And_Get
311: ( p_count => x_msg_count,
312: p_data => x_msg_data
313: );

Line 314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

310: FND_MSG_PUB.Count_And_Get
311: ( p_count => x_msg_count,
312: p_data => x_msg_data
313: );
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: --ROLLBACK TO getclassification_pvt;
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
317: FND_MSG_PUB.Count_And_Get
318: ( p_count => x_msg_count,

Line 316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

312: p_data => x_msg_data
313: );
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: --ROLLBACK TO getclassification_pvt;
316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
317: FND_MSG_PUB.Count_And_Get
318: ( p_count => x_msg_count,
319: p_data => x_msg_data
320: );

Line 323: x_return_status := FND_API.G_RET_STS_ERROR;

319: p_data => x_msg_data
320: );
321: WHEN OTHERS THEN
322: --ROLLBACK TO getclassification_pvt;
323: x_return_status := FND_API.G_RET_STS_ERROR;
324: IF FND_MSG_PUB.Check_Msg_Level
325: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
326: THEN
327: FND_MSG_PUB.Add_Exc_Msg

Line 367: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

363: BEGIN
364: -- Standard Start of API savepoint
365: --SAVEPOINT getClassification_pvt;
366: -- Standard call to check for call compatibility.
367: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
368: p_api_version_number,
369: l_api_name,
370: G_PKG_NAME)
371: THEN

Line 372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

368: p_api_version_number,
369: l_api_name,
370: G_PKG_NAME)
371: THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374: -- Initialize message list if p_init_msg_list is set to TRUE.
375: IF FND_API.to_Boolean( p_init_msg_list )
376: THEN

Line 375: IF FND_API.to_Boolean( p_init_msg_list )

371: THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374: -- Initialize message list if p_init_msg_list is set to TRUE.
375: IF FND_API.to_Boolean( p_init_msg_list )
376: THEN
377: FND_MSG_PUB.initialize;
378: END IF;
379: -- Initialize API return status to SUCCESS

Line 380: x_return_status := FND_API.G_RET_STS_SUCCESS;

376: THEN
377: FND_MSG_PUB.initialize;
378: END IF;
379: -- Initialize API return status to SUCCESS
380: x_return_status := FND_API.G_RET_STS_SUCCESS;
381: BEGIN
382: select category_map_id into l_category_map_id
383: FROM IEM_RT_PROC_EMAILS
384: WHERE MESSAGE_ID=p_message_id;

Line 403: IF FND_API.To_Boolean(p_commit) THEN

399: END LOOP;
400: END IF;
401:
402: -- Standard Check Of p_commit.
403: IF FND_API.To_Boolean(p_commit) THEN
404: COMMIT WORK;
405: END IF;
406: -- Standard callto get message count and if count is 1, get message info.
407: FND_MSG_PUB.Count_And_Get

Line 414: WHEN FND_API.G_EXC_ERROR THEN

410: );
411:
412:
413: EXCEPTION
414: WHEN FND_API.G_EXC_ERROR THEN
415: --ROLLBACK TO getclassification_pvt;
416: x_return_status := FND_API.G_RET_STS_ERROR ;
417: FND_MSG_PUB.Count_And_Get
418: ( p_count => x_msg_count,

Line 416: x_return_status := FND_API.G_RET_STS_ERROR ;

412:
413: EXCEPTION
414: WHEN FND_API.G_EXC_ERROR THEN
415: --ROLLBACK TO getclassification_pvt;
416: x_return_status := FND_API.G_RET_STS_ERROR ;
417: FND_MSG_PUB.Count_And_Get
418: ( p_count => x_msg_count,
419: p_data => x_msg_data
420: );

Line 421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

417: FND_MSG_PUB.Count_And_Get
418: ( p_count => x_msg_count,
419: p_data => x_msg_data
420: );
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422: --ROLLBACK TO getclassification_pvt;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
424: FND_MSG_PUB.Count_And_Get
425: ( p_count => x_msg_count,

Line 423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

419: p_data => x_msg_data
420: );
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422: --ROLLBACK TO getclassification_pvt;
423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
424: FND_MSG_PUB.Count_And_Get
425: ( p_count => x_msg_count,
426: p_data => x_msg_data
427: );

Line 430: x_return_status := FND_API.G_RET_STS_ERROR;

426: p_data => x_msg_data
427: );
428: WHEN OTHERS THEN
429: --ROLLBACK TO getclassification_pvt;
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: IF FND_MSG_PUB.Check_Msg_Level
432: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
433: THEN
434: FND_MSG_PUB.Add_Exc_Msg

Line 454: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

450: -- Pre-reqs : None.
451: -- Parameters :
452: -- IN
453: -- p_api_version_number IN NUMBER Required
454: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
455: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
456: -- p_email_account_id IN NUMBER,
457: -- p_classification_id IN NUMBER,
458: -- p_score IN NUMBER,

Line 455: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

451: -- Parameters :
452: -- IN
453: -- p_api_version_number IN NUMBER Required
454: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
455: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
456: -- p_email_account_id IN NUMBER,
457: -- p_classification_id IN NUMBER,
458: -- p_score IN NUMBER,
459: -- p_message_id IN NUMBER,

Line 498: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

494: BEGIN
495: -- Standard Start of API savepoint
496: -- SAVEPOINT create_item_PVT;
497: -- Standard call to check for call compatibility.
498: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
499: p_api_version_number,
500: l_api_name,
501: G_PKG_NAME)
502: THEN

Line 503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

499: p_api_version_number,
500: l_api_name,
501: G_PKG_NAME)
502: THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504: END IF;
505: -- Initialize message list if p_init_msg_list is set to TRUE.
506: IF FND_API.to_Boolean( p_init_msg_list )
507: THEN

Line 506: IF FND_API.to_Boolean( p_init_msg_list )

502: THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504: END IF;
505: -- Initialize message list if p_init_msg_list is set to TRUE.
506: IF FND_API.to_Boolean( p_init_msg_list )
507: THEN
508: FND_MSG_PUB.initialize;
509: END IF;
510: -- Initialize API return status to SUCCESS

Line 511: x_return_status := FND_API.G_RET_STS_SUCCESS;

507: THEN
508: FND_MSG_PUB.initialize;
509: END IF;
510: -- Initialize API return status to SUCCESS
511: x_return_status := FND_API.G_RET_STS_SUCCESS;
512: select count(*) into l_count from iem_email_classifications
513: where message_id=p_message_id
514: and classification_id=p_classification_id;
515: If l_count=0 then

Line 544: IF FND_API.To_Boolean(p_commit) THEN

540: DECODE(p_LAST_UPDATE_LOGIN,null,-1,p_last_update_login)
541: );
542: END IF;
543: -- Standard Check Of p_commit.
544: IF FND_API.To_Boolean(p_commit) THEN
545: COMMIT WORK;
546: END IF;
547: -- Standard callto get message count and if count is 1, get message info.
548: FND_MSG_PUB.Count_And_Get

Line 553: WHEN FND_API.G_EXC_ERROR THEN

549: ( p_count => x_msg_count,
550: p_data => x_msg_data
551: );
552: EXCEPTION
553: WHEN FND_API.G_EXC_ERROR THEN
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

Line 554: x_return_status := FND_API.G_RET_STS_ERROR ;

550: p_data => x_msg_data
551: );
552: EXCEPTION
553: WHEN FND_API.G_EXC_ERROR THEN
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: );

Line 559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
561: FND_MSG_PUB.Count_And_Get
562: ( p_count => x_msg_count,
563: p_data => x_msg_data

Line 560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

556: ( p_count => x_msg_count,
557: p_data => x_msg_data
558: );
559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
561: FND_MSG_PUB.Count_And_Get
562: ( p_count => x_msg_count,
563: p_data => x_msg_data
564: );

Line 566: x_return_status := FND_API.G_RET_STS_ERROR;

562: ( p_count => x_msg_count,
563: p_data => x_msg_data
564: );
565: WHEN OTHERS THEN
566: x_return_status := FND_API.G_RET_STS_ERROR;
567: IF FND_MSG_PUB.Check_Msg_Level
568: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
569: THEN
570: FND_MSG_PUB.Add_Exc_Msg