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_MAILITEM_PUB dependencies on FND_API

Line 83: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

79: IEM_NO_DATA EXCEPTION;
80: NOT_A_VALID_AGENT EXCEPTION;
81: BEGIN
82: -- Standard call to check for call compatibility.
83: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
84: p_api_version_number,
85: l_api_name,
86: G_PKG_NAME)
87: THEN

Line 88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

84: p_api_version_number,
85: l_api_name,
86: G_PKG_NAME)
87: THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90: SAVEPOINT select_mail_count_pvt;
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:

Line 91: x_return_status := FND_API.G_RET_STS_SUCCESS;

87: THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90: SAVEPOINT select_mail_count_pvt;
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: select count(*) into l_count
94: from jtf_rs_group_members
95: where resource_id=p_resource_id

Line 182: x_return_status := FND_API.G_RET_STS_ERROR ;

178: EXCEPTION
179:
180: WHEN NOT_A_VALID_AGENT THEN
181: ROLLBACK TO select_mail_count_PVT;
182: x_return_status := FND_API.G_RET_STS_ERROR ;
183: FND_MESSAGE.SET_NAME('IEM', 'IEM_UNRECOGNIZED_AGENT');
184: FND_MSG_PUB.ADD;
185: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
186: WHEN IEM_NO_DATA THEN

Line 188: x_return_status := FND_API.G_RET_STS_ERROR ;

184: FND_MSG_PUB.ADD;
185: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
186: WHEN IEM_NO_DATA THEN
187: ROLLBACK TO select_mail_count_PVT;
188: x_return_status := FND_API.G_RET_STS_ERROR ;
189: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
190: FND_MSG_PUB.ADD;
191: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
192: WHEN FND_API.G_EXC_ERROR THEN

Line 192: WHEN FND_API.G_EXC_ERROR THEN

188: x_return_status := FND_API.G_RET_STS_ERROR ;
189: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
190: FND_MSG_PUB.ADD;
191: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
192: WHEN FND_API.G_EXC_ERROR THEN
193: ROLLBACK TO select_mail_count_PVT;
194: x_return_status := FND_API.G_RET_STS_ERROR ;
195: FND_MSG_PUB.Count_And_Get
196: ( p_count => x_msg_count,

Line 194: x_return_status := FND_API.G_RET_STS_ERROR ;

190: FND_MSG_PUB.ADD;
191: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
192: WHEN FND_API.G_EXC_ERROR THEN
193: ROLLBACK TO select_mail_count_PVT;
194: x_return_status := FND_API.G_RET_STS_ERROR ;
195: FND_MSG_PUB.Count_And_Get
196: ( p_count => x_msg_count,
197: p_data => x_msg_data
198: );

Line 199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

195: FND_MSG_PUB.Count_And_Get
196: ( p_count => x_msg_count,
197: p_data => x_msg_data
198: );
199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
200: ROLLBACK TO select_mail_count_PVT;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
202: FND_MSG_PUB.Count_And_Get
203: ( p_count => x_msg_count,

Line 201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

197: p_data => x_msg_data
198: );
199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
200: ROLLBACK TO select_mail_count_PVT;
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
202: FND_MSG_PUB.Count_And_Get
203: ( p_count => x_msg_count,
204: p_data => x_msg_data
205: );

Line 208: x_return_status := FND_API.G_RET_STS_ERROR;

204: p_data => x_msg_data
205: );
206: WHEN OTHERS THEN
207: ROLLBACK TO select_mail_count_PVT;
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: IF FND_MSG_PUB.Check_Msg_Level
210: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
211: THEN
212: FND_MSG_PUB.Add_Exc_Msg

Line 258: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

254: l_msg_data varchar2(500);
255: IEM_NO_DATA EXCEPTION;
256: begin
257: -- Standard call to check for call compatibility.
258: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
259: p_api_version_number,
260: l_api_name,
261: G_PKG_NAME)
262: THEN

Line 263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

259: p_api_version_number,
260: l_api_name,
261: G_PKG_NAME)
262: THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265: SAVEPOINT select_item_PVT;
266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267: BEGIN

Line 266: x_return_status := FND_API.G_RET_STS_SUCCESS;

262: THEN
263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
264: END IF;
265: SAVEPOINT select_item_PVT;
266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267: BEGIN
268: IF p_tbl.count=0 then
269: IEM_MAILITEM_PUB.getGroupDetails(p_api_version_number=>1.0,
270: p_init_msg_list=>'F',

Line 321: x_return_status := FND_API.G_RET_STS_ERROR ;

317: );
318: EXCEPTION
319: WHEN IEM_NO_DATA THEN
320: ROLLBACK TO select_item_PVT;
321: x_return_status := FND_API.G_RET_STS_ERROR ;
322: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
323: FND_MSG_PUB.ADD;
324: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
325: WHEN FND_API.G_EXC_ERROR THEN

Line 325: WHEN FND_API.G_EXC_ERROR THEN

321: x_return_status := FND_API.G_RET_STS_ERROR ;
322: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
323: FND_MSG_PUB.ADD;
324: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO select_item_PVT;
327: x_return_status := FND_API.G_RET_STS_ERROR ;
328: FND_MSG_PUB.Count_And_Get
329: ( p_count => x_msg_count,

Line 327: x_return_status := FND_API.G_RET_STS_ERROR ;

323: FND_MSG_PUB.ADD;
324: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO select_item_PVT;
327: x_return_status := FND_API.G_RET_STS_ERROR ;
328: FND_MSG_PUB.Count_And_Get
329: ( p_count => x_msg_count,
330: p_data => x_msg_data
331: );

Line 332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

328: FND_MSG_PUB.Count_And_Get
329: ( p_count => x_msg_count,
330: p_data => x_msg_data
331: );
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
333: ROLLBACK TO select_item_PVT;
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
335: FND_MSG_PUB.Count_And_Get
336: ( p_count => x_msg_count,

Line 334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

330: p_data => x_msg_data
331: );
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
333: ROLLBACK TO select_item_PVT;
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
335: FND_MSG_PUB.Count_And_Get
336: ( p_count => x_msg_count,
337: p_data => x_msg_data
338: );

Line 341: x_return_status := FND_API.G_RET_STS_ERROR;

337: p_data => x_msg_data
338: );
339: WHEN OTHERS THEN
340: ROLLBACK TO select_item_PVT;
341: x_return_status := FND_API.G_RET_STS_ERROR;
342: IF FND_MSG_PUB.Check_Msg_Level
343: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
344: THEN
345: FND_MSG_PUB.Add_Exc_Msg

Line 382: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

378: x_count t_number_table:=t_number_table() ;
379: IEM_NO_DATA EXCEPTION;
380: begin
381: -- Standard call to check for call compatibility.
382: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
383: p_api_version_number,
384: l_api_name,
385: G_PKG_NAME)
386: THEN

Line 387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

383: p_api_version_number,
384: l_api_name,
385: G_PKG_NAME)
386: THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: END IF;
389: SAVEPOINT select_item_PVT;
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391: open c2;

Line 390: x_return_status := FND_API.G_RET_STS_SUCCESS;

386: THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: END IF;
389: SAVEPOINT select_item_PVT;
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391: open c2;
392: fetch c2 bulk collect into x_rt_class_tbl,x_rt_class_name_Tbl,x_count;
393: close c2;
394: IF x_rt_class_tbl.count=0 THEN

Line 415: x_return_status := FND_API.G_RET_STS_ERROR ;

411: );
412: EXCEPTION
413: WHEN IEM_NO_DATA THEN
414: ROLLBACK TO select_item_PVT;
415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
417: FND_MSG_PUB.ADD;
418: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
419: WHEN FND_API.G_EXC_ERROR THEN

Line 419: WHEN FND_API.G_EXC_ERROR THEN

415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
417: FND_MSG_PUB.ADD;
418: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
419: WHEN FND_API.G_EXC_ERROR THEN
420: ROLLBACK TO select_item_PVT;
421: x_return_status := FND_API.G_RET_STS_ERROR ;
422: FND_MSG_PUB.Count_And_Get
423: ( p_count => x_msg_count,

Line 421: x_return_status := FND_API.G_RET_STS_ERROR ;

417: FND_MSG_PUB.ADD;
418: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
419: WHEN FND_API.G_EXC_ERROR THEN
420: ROLLBACK TO select_item_PVT;
421: x_return_status := FND_API.G_RET_STS_ERROR ;
422: FND_MSG_PUB.Count_And_Get
423: ( p_count => x_msg_count,
424: p_data => x_msg_data
425: );

Line 426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

422: FND_MSG_PUB.Count_And_Get
423: ( p_count => x_msg_count,
424: p_data => x_msg_data
425: );
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: ROLLBACK TO select_item_PVT;
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
429: FND_MSG_PUB.Count_And_Get
430: ( p_count => x_msg_count,

Line 428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

424: p_data => x_msg_data
425: );
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
427: ROLLBACK TO select_item_PVT;
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
429: FND_MSG_PUB.Count_And_Get
430: ( p_count => x_msg_count,
431: p_data => x_msg_data
432: );

Line 435: x_return_status := FND_API.G_RET_STS_ERROR;

431: p_data => x_msg_data
432: );
433: WHEN OTHERS THEN
434: ROLLBACK TO select_item_PVT;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: IF FND_MSG_PUB.Check_Msg_Level
437: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
438: THEN
439: FND_MSG_PUB.Add_Exc_Msg

Line 472: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

468: l_msg_data varchar2(500);
469: IEM_NO_DATA EXCEPTION;
470: begin
471: -- Standard call to check for call compatibility.
472: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
473: p_api_version_number,
474: l_api_name,
475: G_PKG_NAME)
476: THEN

Line 477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

473: p_api_version_number,
474: l_api_name,
475: G_PKG_NAME)
476: THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479: SAVEPOINT select_item_PVT;
480: x_return_status := FND_API.G_RET_STS_SUCCESS;
481: BEGIN

Line 480: x_return_status := FND_API.G_RET_STS_SUCCESS;

476: THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479: SAVEPOINT select_item_PVT;
480: x_return_status := FND_API.G_RET_STS_SUCCESS;
481: BEGIN
482: IF p_tbl.count=0 then
483: IEM_MAILITEM_PUB.getGroupDetails(p_api_version_number=>1.0,
484: p_init_msg_list=>'F',

Line 533: x_return_status := FND_API.G_RET_STS_ERROR ;

529: );
530: EXCEPTION
531: WHEN IEM_NO_DATA THEN
532: ROLLBACK TO select_item_PVT;
533: x_return_status := FND_API.G_RET_STS_ERROR ;
534: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
535: FND_MSG_PUB.ADD;
536: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
537: WHEN FND_API.G_EXC_ERROR THEN

Line 537: WHEN FND_API.G_EXC_ERROR THEN

533: x_return_status := FND_API.G_RET_STS_ERROR ;
534: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
535: FND_MSG_PUB.ADD;
536: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
537: WHEN FND_API.G_EXC_ERROR THEN
538: ROLLBACK TO select_item_PVT;
539: x_return_status := FND_API.G_RET_STS_ERROR ;
540: FND_MSG_PUB.Count_And_Get
541: ( p_count => x_msg_count,

Line 539: x_return_status := FND_API.G_RET_STS_ERROR ;

535: FND_MSG_PUB.ADD;
536: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
537: WHEN FND_API.G_EXC_ERROR THEN
538: ROLLBACK TO select_item_PVT;
539: x_return_status := FND_API.G_RET_STS_ERROR ;
540: FND_MSG_PUB.Count_And_Get
541: ( p_count => x_msg_count,
542: p_data => x_msg_data
543: );

Line 544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

540: FND_MSG_PUB.Count_And_Get
541: ( p_count => x_msg_count,
542: p_data => x_msg_data
543: );
544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
545: ROLLBACK TO select_item_PVT;
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
547: FND_MSG_PUB.Count_And_Get
548: ( p_count => x_msg_count,

Line 546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

542: p_data => x_msg_data
543: );
544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
545: ROLLBACK TO select_item_PVT;
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
547: FND_MSG_PUB.Count_And_Get
548: ( p_count => x_msg_count,
549: p_data => x_msg_data
550: );

Line 553: x_return_status := FND_API.G_RET_STS_ERROR;

549: p_data => x_msg_data
550: );
551: WHEN OTHERS THEN
552: ROLLBACK TO select_item_PVT;
553: x_return_status := FND_API.G_RET_STS_ERROR;
554: IF FND_MSG_PUB.Check_Msg_Level
555: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
556: THEN
557: FND_MSG_PUB.Add_Exc_Msg

Line 608: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

604: PRAGMA EXCEPTION_INIT(e_nowait, -54);
605: l_time number;
606: BEGIN
607: -- Standard call to check for call compatibility.
608: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
609: p_api_version_number,
610: l_api_name,
611: G_PKG_NAME)
612: THEN

Line 613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

609: p_api_version_number,
610: l_api_name,
611: G_PKG_NAME)
612: THEN
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END IF;
615: SAVEPOINT select_data_PVT;
616: x_return_status := FND_API.G_RET_STS_SUCCESS;
617: IF (p_tbl is null) and (nvl(p_account_id,FND_API.G_MISS_NUM)<> FND_API.G_MISS_NUM) and

Line 616: x_return_status := FND_API.G_RET_STS_SUCCESS;

612: THEN
613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END IF;
615: SAVEPOINT select_data_PVT;
616: x_return_status := FND_API.G_RET_STS_SUCCESS;
617: IF (p_tbl is null) and (nvl(p_account_id,FND_API.G_MISS_NUM)<> FND_API.G_MISS_NUM) and
618: (nvl(p_rt_classification,FND_API.G_MISS_NUM)<> FND_API.G_MISS_NUM) THEN
619: OPEN email_dtl_cur FOR
620: 'select /*FIRST_ROWS*/ * from iem_rt_proc_emails p where message_id not in (select message_id from iem_reroute_hists where resource_id=:res1 ) and email_account_id=:id

Line 617: IF (p_tbl is null) and (nvl(p_account_id,FND_API.G_MISS_NUM)<> FND_API.G_MISS_NUM) and

613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
614: END IF;
615: SAVEPOINT select_data_PVT;
616: x_return_status := FND_API.G_RET_STS_SUCCESS;
617: IF (p_tbl is null) and (nvl(p_account_id,FND_API.G_MISS_NUM)<> FND_API.G_MISS_NUM) and
618: (nvl(p_rt_classification,FND_API.G_MISS_NUM)<> FND_API.G_MISS_NUM) THEN
619: OPEN email_dtl_cur FOR
620: 'select /*FIRST_ROWS*/ * from iem_rt_proc_emails p where message_id not in (select message_id from iem_reroute_hists where resource_id=:res1 ) and email_account_id=:id
621: and rt_classification_id=:rt

Line 618: (nvl(p_rt_classification,FND_API.G_MISS_NUM)<> FND_API.G_MISS_NUM) THEN

614: END IF;
615: SAVEPOINT select_data_PVT;
616: x_return_status := FND_API.G_RET_STS_SUCCESS;
617: IF (p_tbl is null) and (nvl(p_account_id,FND_API.G_MISS_NUM)<> FND_API.G_MISS_NUM) and
618: (nvl(p_rt_classification,FND_API.G_MISS_NUM)<> FND_API.G_MISS_NUM) THEN
619: OPEN email_dtl_cur FOR
620: 'select /*FIRST_ROWS*/ * from iem_rt_proc_emails p where message_id not in (select message_id from iem_reroute_hists where resource_id=:res1 ) and email_account_id=:id
621: and rt_classification_id=:rt
622: and resource_id=0

Line 726: x_return_status := FND_API.G_RET_STS_ERROR ;

722: );
723: EXCEPTION
724: WHEN IEM_NO_DATA THEN
725: ROLLBACK TO select_data_PVT;
726: x_return_status := FND_API.G_RET_STS_ERROR ;
727: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
728: FND_MSG_PUB.ADD;
729: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
730: WHEN FND_API.G_EXC_ERROR THEN

Line 730: WHEN FND_API.G_EXC_ERROR THEN

726: x_return_status := FND_API.G_RET_STS_ERROR ;
727: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
728: FND_MSG_PUB.ADD;
729: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
730: WHEN FND_API.G_EXC_ERROR THEN
731: ROLLBACK TO select_data_PVT;
732: x_return_status := FND_API.G_RET_STS_ERROR ;
733: FND_MSG_PUB.Count_And_Get
734: ( p_count => x_msg_count,

Line 732: x_return_status := FND_API.G_RET_STS_ERROR ;

728: FND_MSG_PUB.ADD;
729: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
730: WHEN FND_API.G_EXC_ERROR THEN
731: ROLLBACK TO select_data_PVT;
732: x_return_status := FND_API.G_RET_STS_ERROR ;
733: FND_MSG_PUB.Count_And_Get
734: ( p_count => x_msg_count,
735: p_data => x_msg_data
736: );

Line 737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

733: FND_MSG_PUB.Count_And_Get
734: ( p_count => x_msg_count,
735: p_data => x_msg_data
736: );
737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
738: ROLLBACK TO select_data_PVT;
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
740: FND_MSG_PUB.Count_And_Get
741: ( p_count => x_msg_count,

Line 739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

735: p_data => x_msg_data
736: );
737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
738: ROLLBACK TO select_data_PVT;
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
740: FND_MSG_PUB.Count_And_Get
741: ( p_count => x_msg_count,
742: p_data => x_msg_data
743: );

Line 748: x_return_status := FND_API.G_RET_STS_ERROR;

744: WHEN NO_DATA_FOUND THEN
745: null;
746: WHEN OTHERS THEN
747: ROLLBACK TO select_data_PVT;
748: x_return_status := FND_API.G_RET_STS_ERROR;
749: IF FND_MSG_PUB.Check_Msg_Level
750: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
751: THEN
752: FND_MSG_PUB.Add_Exc_Msg

Line 781: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

777: l_media_id number;
778:
779: BEGIN
780: -- Standard call to check for call compatibility.
781: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
782: p_api_version_number,
783: l_api_name,
784: G_PKG_NAME)
785: THEN

Line 786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

782: p_api_version_number,
783: l_api_name,
784: G_PKG_NAME)
785: THEN
786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
787: END IF;
788: SAVEPOINT dispose_mail_item_PVT;
789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790: BEGIN -- Close the Media Item

Line 789: x_return_status := FND_API.G_RET_STS_SUCCESS;

785: THEN
786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
787: END IF;
788: SAVEPOINT dispose_mail_item_PVT;
789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790: BEGIN -- Close the Media Item
791: SELECT IH_MEDIA_ITEM_ID into l_media_id
792: FROM iem_rt_proc_emails
793: WHERE MESSAGE_ID=p_message_id;

Line 840: WHEN FND_API.G_EXC_ERROR THEN

836: ( p_count => x_msg_count,
837: p_data => x_msg_data
838: );
839: EXCEPTION
840: WHEN FND_API.G_EXC_ERROR THEN
841: ROLLBACK TO dispose_mail_item_PVT;
842: x_return_status := FND_API.G_RET_STS_ERROR ;
843: FND_MSG_PUB.Count_And_Get
844: ( p_count => x_msg_count,

Line 842: x_return_status := FND_API.G_RET_STS_ERROR ;

838: );
839: EXCEPTION
840: WHEN FND_API.G_EXC_ERROR THEN
841: ROLLBACK TO dispose_mail_item_PVT;
842: x_return_status := FND_API.G_RET_STS_ERROR ;
843: FND_MSG_PUB.Count_And_Get
844: ( p_count => x_msg_count,
845: p_data => x_msg_data
846: );

Line 847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

843: FND_MSG_PUB.Count_And_Get
844: ( p_count => x_msg_count,
845: p_data => x_msg_data
846: );
847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
848: ROLLBACK TO dispose_mail_item_PVT;
849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
850: FND_MSG_PUB.Count_And_Get
851: ( p_count => x_msg_count,

Line 849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

845: p_data => x_msg_data
846: );
847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
848: ROLLBACK TO dispose_mail_item_PVT;
849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
850: FND_MSG_PUB.Count_And_Get
851: ( p_count => x_msg_count,
852: p_data => x_msg_data
853: );

Line 856: x_return_status := FND_API.G_RET_STS_ERROR;

852: p_data => x_msg_data
853: );
854: WHEN OTHERS THEN
855: ROLLBACK TO dispose_mail_item_PVT;
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: IF FND_MSG_PUB.Check_Msg_Level
858: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
859: THEN
860: FND_MSG_PUB.Add_Exc_Msg

Line 886: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

882: l_api_version_number NUMBER:=1.0;
883: NOT_A_VALID_AGENT EXCEPTION;
884: BEGIN
885: -- Standard call to check for call compatibility.
886: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
887: p_api_version_number,
888: l_api_name,
889: G_PKG_NAME)
890: THEN

Line 891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

887: p_api_version_number,
888: l_api_name,
889: G_PKG_NAME)
890: THEN
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: END IF;
893: SAVEPOINT getgroupdetails_PVT;
894: x_return_status := FND_API.G_RET_STS_SUCCESS;
895: select group_id bulk collect into x_tbl

Line 894: x_return_status := FND_API.G_RET_STS_SUCCESS;

890: THEN
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892: END IF;
893: SAVEPOINT getgroupdetails_PVT;
894: x_return_status := FND_API.G_RET_STS_SUCCESS;
895: select group_id bulk collect into x_tbl
896: from jtf_rs_group_members
897: where resource_id=p_resource_id
898: and delete_flag<>'Y';

Line 916: x_return_status := FND_API.G_RET_STS_ERROR ;

912: );
913: EXCEPTION
914: WHEN NOT_A_VALID_AGENT THEN
915: ROLLBACK TO getgroupdetails_PVT;
916: x_return_status := FND_API.G_RET_STS_ERROR ;
917: FND_MESSAGE.SET_NAME('IEM', 'IEM_UNRECOGNIZED_AGENT');
918: FND_MSG_PUB.ADD;
919: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
920:

Line 921: WHEN FND_API.G_EXC_ERROR THEN

917: FND_MESSAGE.SET_NAME('IEM', 'IEM_UNRECOGNIZED_AGENT');
918: FND_MSG_PUB.ADD;
919: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
920:
921: WHEN FND_API.G_EXC_ERROR THEN
922: ROLLBACK TO getgroupdetails_PVT;
923: x_return_status := FND_API.G_RET_STS_ERROR ;
924: FND_MSG_PUB.Count_And_Get
925: ( p_count => x_msg_count,

Line 923: x_return_status := FND_API.G_RET_STS_ERROR ;

919: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
920:
921: WHEN FND_API.G_EXC_ERROR THEN
922: ROLLBACK TO getgroupdetails_PVT;
923: x_return_status := FND_API.G_RET_STS_ERROR ;
924: FND_MSG_PUB.Count_And_Get
925: ( p_count => x_msg_count,
926: p_data => x_msg_data
927: );

Line 928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

924: FND_MSG_PUB.Count_And_Get
925: ( p_count => x_msg_count,
926: p_data => x_msg_data
927: );
928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
929: ROLLBACK TO getgroupdetails_PVT;
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
931: FND_MSG_PUB.Count_And_Get
932: ( p_count => x_msg_count,

Line 930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

926: p_data => x_msg_data
927: );
928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
929: ROLLBACK TO getgroupdetails_PVT;
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
931: FND_MSG_PUB.Count_And_Get
932: ( p_count => x_msg_count,
933: p_data => x_msg_data
934: );

Line 937: x_return_status := FND_API.G_RET_STS_ERROR;

933: p_data => x_msg_data
934: );
935: WHEN OTHERS THEN
936: ROLLBACK TO getgroupdetails_PVT;
937: x_return_status := FND_API.G_RET_STS_ERROR;
938: IF FND_MSG_PUB.Check_Msg_Level
939: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
940: THEN
941: FND_MSG_PUB.Add_Exc_Msg

Line 968: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

964: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
965:
966: BEGIN
967: -- Standard call to check for call compatibility.
968: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
969: p_api_version_number,
970: l_api_name,
971: G_PKG_NAME)
972: THEN

Line 973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

969: p_api_version_number,
970: l_api_name,
971: G_PKG_NAME)
972: THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975: SAVEPOINT update_item_PVT;
976: x_return_status := FND_API.G_RET_STS_SUCCESS;
977: UPDATE iem_rt_proc_emails

Line 976: x_return_status := FND_API.G_RET_STS_SUCCESS;

972: THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975: SAVEPOINT update_item_PVT;
976: x_return_status := FND_API.G_RET_STS_SUCCESS;
977: UPDATE iem_rt_proc_emails
978: SET
979: resource_id =p_email_data.resource_id,
980: PRIORITY =p_email_data.priority,

Line 1019: WHEN FND_API.G_EXC_ERROR THEN

1015: ( p_count => x_msg_count,
1016: p_data => x_msg_data
1017: );
1018: EXCEPTION
1019: WHEN FND_API.G_EXC_ERROR THEN
1020: ROLLBACK TO update_item_PVT;
1021: x_return_status := FND_API.G_RET_STS_ERROR ;
1022: FND_MSG_PUB.Count_And_Get
1023: ( p_count => x_msg_count,

Line 1021: x_return_status := FND_API.G_RET_STS_ERROR ;

1017: );
1018: EXCEPTION
1019: WHEN FND_API.G_EXC_ERROR THEN
1020: ROLLBACK TO update_item_PVT;
1021: x_return_status := FND_API.G_RET_STS_ERROR ;
1022: FND_MSG_PUB.Count_And_Get
1023: ( p_count => x_msg_count,
1024: p_data => x_msg_data
1025: );

Line 1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1022: FND_MSG_PUB.Count_And_Get
1023: ( p_count => x_msg_count,
1024: p_data => x_msg_data
1025: );
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027: ROLLBACK TO update_item_PVT;
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029: FND_MSG_PUB.Count_And_Get
1030: ( p_count => x_msg_count,

Line 1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1024: p_data => x_msg_data
1025: );
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027: ROLLBACK TO update_item_PVT;
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029: FND_MSG_PUB.Count_And_Get
1030: ( p_count => x_msg_count,
1031: p_data => x_msg_data
1032: );

Line 1035: x_return_status := FND_API.G_RET_STS_ERROR;

1031: p_data => x_msg_data
1032: );
1033: WHEN OTHERS THEN
1034: ROLLBACK TO update_item_PVT;
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: IF FND_MSG_PUB.Check_Msg_Level
1037: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1038: THEN
1039: FND_MSG_PUB.Add_Exc_Msg

Line 1066: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1062: l_api_name VARCHAR2(255):='GetMailItemInfo';
1063: l_api_version_number NUMBER:=1.0;
1064: BEGIN
1065: -- Standard call to check for call compatibility.
1066: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1067: p_api_version_number,
1068: l_api_name,
1069: G_PKG_NAME)
1070: THEN

Line 1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1067: p_api_version_number,
1068: l_api_name,
1069: G_PKG_NAME)
1070: THEN
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: END IF;
1073: SAVEPOINT get_mail_iteminfo_pvt;
1074: x_return_status := FND_API.G_RET_STS_SUCCESS;
1075: IF p_agent_id<>0 THEN -- Not a supervisor mode

Line 1074: x_return_status := FND_API.G_RET_STS_SUCCESS;

1070: THEN
1071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1072: END IF;
1073: SAVEPOINT get_mail_iteminfo_pvt;
1074: x_return_status := FND_API.G_RET_STS_SUCCESS;
1075: IF p_agent_id<>0 THEN -- Not a supervisor mode
1076: BEGIN
1077: SELECT *
1078: INTO x_email_data

Line 1108: WHEN FND_API.G_EXC_ERROR THEN

1104: ( p_count => x_msg_count,
1105: p_data => x_msg_data
1106: );
1107: EXCEPTION
1108: WHEN FND_API.G_EXC_ERROR THEN
1109: ROLLBACK TO get_mail_iteminfo_pvt;
1110: x_return_status := FND_API.G_RET_STS_ERROR ;
1111: FND_MSG_PUB.Count_And_Get
1112: ( p_count => x_msg_count,

Line 1110: x_return_status := FND_API.G_RET_STS_ERROR ;

1106: );
1107: EXCEPTION
1108: WHEN FND_API.G_EXC_ERROR THEN
1109: ROLLBACK TO get_mail_iteminfo_pvt;
1110: x_return_status := FND_API.G_RET_STS_ERROR ;
1111: FND_MSG_PUB.Count_And_Get
1112: ( p_count => x_msg_count,
1113: p_data => x_msg_data
1114: );

Line 1115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1111: FND_MSG_PUB.Count_And_Get
1112: ( p_count => x_msg_count,
1113: p_data => x_msg_data
1114: );
1115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1116: ROLLBACK TO get_mail_iteminfo_pvt;
1117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1118: FND_MSG_PUB.Count_And_Get
1119: ( p_count => x_msg_count,

Line 1117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1113: p_data => x_msg_data
1114: );
1115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1116: ROLLBACK TO get_mail_iteminfo_pvt;
1117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1118: FND_MSG_PUB.Count_And_Get
1119: ( p_count => x_msg_count,
1120: p_data => x_msg_data
1121: );

Line 1124: x_return_status := FND_API.G_RET_STS_ERROR;

1120: p_data => x_msg_data
1121: );
1122: WHEN OTHERS THEN
1123: ROLLBACK TO get_mail_iteminfo_pvt;
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: IF FND_MSG_PUB.Check_Msg_Level
1126: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1127: THEN
1128: FND_MSG_PUB.Add_Exc_Msg

Line 1170: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1166: l_status_type varchar2(40):='IEM_MESSAGE_STATUS_TYPE';
1167:
1168: BEGIN
1169: -- Standard call to check for call compatibility.
1170: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1171: p_api_version_number,
1172: l_api_name,
1173: G_PKG_NAME)
1174: THEN

Line 1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1171: p_api_version_number,
1172: l_api_name,
1173: G_PKG_NAME)
1174: THEN
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: END IF;
1177: SAVEPOINT getemailheaders_pvt;
1178: x_return_status := FND_API.G_RET_STS_SUCCESS;
1179: select decode(p_sort_order,0,'ASC','DESC')

Line 1178: x_return_status := FND_API.G_RET_STS_SUCCESS;

1174: THEN
1175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1176: END IF;
1177: SAVEPOINT getemailheaders_pvt;
1178: x_return_status := FND_API.G_RET_STS_SUCCESS;
1179: select decode(p_sort_order,0,'ASC','DESC')
1180: into l_sort_order
1181: from dual;
1182: IF p_sort_by = FND_API.G_MISS_CHAR OR p_sort_by='D' THEN

Line 1182: IF p_sort_by = FND_API.G_MISS_CHAR OR p_sort_by='D' THEN

1178: x_return_status := FND_API.G_RET_STS_SUCCESS;
1179: select decode(p_sort_order,0,'ASC','DESC')
1180: into l_sort_order
1181: from dual;
1182: IF p_sort_by = FND_API.G_MISS_CHAR OR p_sort_by='D' THEN
1183: l_order_by:=' Order BY to_date(substr(a.sent_Date,1,20),''DD-MON-YYYY HH24:MI:SS'') '||l_sort_order;
1184: ELSIF p_sort_by='S' THEN
1185: l_order_by:='ORDER BY a.subject '||l_sort_order||',to_date(substr(a.sent_Date,1,20),''DD-MON-YYYY HH24:MI:SS'') '||l_sort_order;
1186: ELSIF p_sort_by='C' THEN

Line 1221: IF p_display_size=FND_API.G_MISS_NUM THEN

1217: END LOOP;
1218: CLOSE email_cur;
1219: IF l_temp_tbl.count>0 THEN -- Data Selected Now implement Display Logic
1220: x_total_message:=l_temp_tbl.count;
1221: IF p_display_size=FND_API.G_MISS_NUM THEN
1222: x_acq_email_data:=l_temp_tbl; -- Return all data
1223: --incase of null display size
1224: ELSE
1225: IF p_page_count<>FND_API.G_MISS_NUM THEN

Line 1225: IF p_page_count<>FND_API.G_MISS_NUM THEN

1221: IF p_display_size=FND_API.G_MISS_NUM THEN
1222: x_acq_email_data:=l_temp_tbl; -- Return all data
1223: --incase of null display size
1224: ELSE
1225: IF p_page_count<>FND_API.G_MISS_NUM THEN
1226: l_first_index:=p_page_count*p_display_size - p_display_size+1;
1227: l_last_index:=p_page_count*p_display_size;
1228: ELSIF p_page_count=FND_API.G_MISS_NUM THEN
1229: l_first_index:=1;

Line 1228: ELSIF p_page_count=FND_API.G_MISS_NUM THEN

1224: ELSE
1225: IF p_page_count<>FND_API.G_MISS_NUM THEN
1226: l_first_index:=p_page_count*p_display_size - p_display_size+1;
1227: l_last_index:=p_page_count*p_display_size;
1228: ELSIF p_page_count=FND_API.G_MISS_NUM THEN
1229: l_first_index:=1;
1230: l_last_index:=p_display_size;
1231: END IF;
1232: IF l_last_index > x_total_message THEN

Line 1250: WHEN FND_API.G_EXC_ERROR THEN

1246: ( p_count => x_msg_count,
1247: p_data => x_msg_data
1248: );
1249: EXCEPTION
1250: WHEN FND_API.G_EXC_ERROR THEN
1251: ROLLBACK TO getemailheaders_pvt;
1252: x_return_status := FND_API.G_RET_STS_ERROR ;
1253: FND_MSG_PUB.Count_And_Get
1254: ( p_count => x_msg_count,

Line 1252: x_return_status := FND_API.G_RET_STS_ERROR ;

1248: );
1249: EXCEPTION
1250: WHEN FND_API.G_EXC_ERROR THEN
1251: ROLLBACK TO getemailheaders_pvt;
1252: x_return_status := FND_API.G_RET_STS_ERROR ;
1253: FND_MSG_PUB.Count_And_Get
1254: ( p_count => x_msg_count,
1255: p_data => x_msg_data
1256: );

Line 1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1253: FND_MSG_PUB.Count_And_Get
1254: ( p_count => x_msg_count,
1255: p_data => x_msg_data
1256: );
1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1258: ROLLBACK TO getemailheaders_pvt;
1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1260: FND_MSG_PUB.Count_And_Get
1261: ( p_count => x_msg_count,

Line 1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1255: p_data => x_msg_data
1256: );
1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1258: ROLLBACK TO getemailheaders_pvt;
1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1260: FND_MSG_PUB.Count_And_Get
1261: ( p_count => x_msg_count,
1262: p_data => x_msg_data
1263: );

Line 1266: x_return_status := FND_API.G_RET_STS_ERROR;

1262: p_data => x_msg_data
1263: );
1264: WHEN OTHERS THEN
1265: ROLLBACK TO getemailheaders_pvt;
1266: x_return_status := FND_API.G_RET_STS_ERROR;
1267: IF FND_MSG_PUB.Check_Msg_Level
1268: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1269: THEN
1270: FND_MSG_PUB.Add_Exc_Msg

Line 1303: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1299: l_encrypted_id varchar2(500);
1300: l_index number;
1301: BEGIN
1302: -- Standard call to check for call compatibility.
1303: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1304: p_api_version_number,
1305: l_api_name,
1306: G_PKG_NAME)
1307: THEN

Line 1308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1304: p_api_version_number,
1305: l_api_name,
1306: G_PKG_NAME)
1307: THEN
1308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1309: END IF;
1310: SAVEPOINT select_data_PVT;
1311: x_return_status := FND_API.G_RET_STS_SUCCESS;
1312: SELECT * INTO x_email_data

Line 1311: x_return_status := FND_API.G_RET_STS_SUCCESS;

1307: THEN
1308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1309: END IF;
1310: SAVEPOINT select_data_PVT;
1311: x_return_status := FND_API.G_RET_STS_SUCCESS;
1312: SELECT * INTO x_email_data
1313: FROM iem_rt_proc_emails
1314: WHERE message_id=p_message_id
1315: AND resource_id=0 for update;

Line 1355: WHEN FND_API.G_EXC_ERROR THEN

1351: x_return_status := 'N';
1352: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
1353: FND_MSG_PUB.ADD;
1354: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1355: WHEN FND_API.G_EXC_ERROR THEN
1356: ROLLBACK TO select_data_PVT;
1357: x_return_status := FND_API.G_RET_STS_ERROR ;
1358: FND_MSG_PUB.Count_And_Get
1359: ( p_count => x_msg_count,

Line 1357: x_return_status := FND_API.G_RET_STS_ERROR ;

1353: FND_MSG_PUB.ADD;
1354: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1355: WHEN FND_API.G_EXC_ERROR THEN
1356: ROLLBACK TO select_data_PVT;
1357: x_return_status := FND_API.G_RET_STS_ERROR ;
1358: FND_MSG_PUB.Count_And_Get
1359: ( p_count => x_msg_count,
1360: p_data => x_msg_data
1361: );

Line 1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1358: FND_MSG_PUB.Count_And_Get
1359: ( p_count => x_msg_count,
1360: p_data => x_msg_data
1361: );
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1363: ROLLBACK TO select_data_PVT;
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1365: FND_MSG_PUB.Count_And_Get
1366: ( p_count => x_msg_count,

Line 1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1360: p_data => x_msg_data
1361: );
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1363: ROLLBACK TO select_data_PVT;
1364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1365: FND_MSG_PUB.Count_And_Get
1366: ( p_count => x_msg_count,
1367: p_data => x_msg_data
1368: );

Line 1371: x_return_status := FND_API.G_RET_STS_ERROR;

1367: p_data => x_msg_data
1368: );
1369: WHEN OTHERS THEN
1370: ROLLBACK TO select_data_PVT;
1371: x_return_status := FND_API.G_RET_STS_ERROR;
1372: IF FND_MSG_PUB.Check_Msg_Level
1373: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1374: THEN
1375: FND_MSG_PUB.Add_Exc_Msg

Line 1441: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1437: l_media_data JTF_IH_MEDIA_ITEMS%ROWTYPE;
1438: ERROR_CLOSING_MEDIA EXCEPTION;
1439: BEGIN
1440: -- Standard call to check for call compatibility.
1441: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1442: p_api_version_number,
1443: l_api_name,
1444: G_PKG_NAME)
1445: THEN

Line 1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1442: p_api_version_number,
1443: l_api_name,
1444: G_PKG_NAME)
1445: THEN
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1447: END IF;
1448: SAVEPOINT select_data_PVT;
1449: x_return_status := FND_API.G_RET_STS_SUCCESS;
1450: select * into l_msg_rec from iem_rt_proc_emails

Line 1449: x_return_status := FND_API.G_RET_STS_SUCCESS;

1445: THEN
1446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1447: END IF;
1448: SAVEPOINT select_data_PVT;
1449: x_return_status := FND_API.G_RET_STS_SUCCESS;
1450: select * into l_msg_rec from iem_rt_proc_emails
1451: where message_id=p_message_id;
1452: -- Close The Media Item
1453: BEGIN

Line 1557: WHEN FND_API.G_EXC_ERROR THEN

1553: x_return_status := 'N';
1554: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
1555: FND_MSG_PUB.ADD;
1556: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1557: WHEN FND_API.G_EXC_ERROR THEN
1558: ROLLBACK TO resolve_data_pvt;
1559: x_return_status := FND_API.G_RET_STS_ERROR ;
1560: FND_MSG_PUB.Count_And_Get
1561: ( p_count => x_msg_count,

Line 1559: x_return_status := FND_API.G_RET_STS_ERROR ;

1555: FND_MSG_PUB.ADD;
1556: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1557: WHEN FND_API.G_EXC_ERROR THEN
1558: ROLLBACK TO resolve_data_pvt;
1559: x_return_status := FND_API.G_RET_STS_ERROR ;
1560: FND_MSG_PUB.Count_And_Get
1561: ( p_count => x_msg_count,
1562: p_data => x_msg_data
1563: );

Line 1564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1560: FND_MSG_PUB.Count_And_Get
1561: ( p_count => x_msg_count,
1562: p_data => x_msg_data
1563: );
1564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1565: ROLLBACK TO resolve_data_pvt;
1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1567: FND_MSG_PUB.Count_And_Get
1568: ( p_count => x_msg_count,

Line 1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1562: p_data => x_msg_data
1563: );
1564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1565: ROLLBACK TO resolve_data_pvt;
1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1567: FND_MSG_PUB.Count_And_Get
1568: ( p_count => x_msg_count,
1569: p_data => x_msg_data
1570: );

Line 1573: x_return_status := FND_API.G_RET_STS_ERROR;

1569: p_data => x_msg_data
1570: );
1571: WHEN ERROR_CLOSING_MEDIA THEN
1572: ROLLBACK TO resolve_data_pvt;
1573: x_return_status := FND_API.G_RET_STS_ERROR;
1574: WHEN OTHERS THEN
1575: ROLLBACK TO resolve_data_pvt;
1576: x_return_status := FND_API.G_RET_STS_ERROR;
1577: IF FND_MSG_PUB.Check_Msg_Level

Line 1576: x_return_status := FND_API.G_RET_STS_ERROR;

1572: ROLLBACK TO resolve_data_pvt;
1573: x_return_status := FND_API.G_RET_STS_ERROR;
1574: WHEN OTHERS THEN
1575: ROLLBACK TO resolve_data_pvt;
1576: x_return_status := FND_API.G_RET_STS_ERROR;
1577: IF FND_MSG_PUB.Check_Msg_Level
1578: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1579: THEN
1580: FND_MSG_PUB.Add_Exc_Msg