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:

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

1181: from dual;
1182:
1183: -- Fix for bug 10417273 - sanjana rao,mandating to_date function to use English while
1184: -- converting the date, in order by and delect clause
1185: IF p_sort_by = FND_API.G_MISS_CHAR OR p_sort_by='D' THEN
1186: l_order_by:=' Order BY to_date(substr(a.sent_Date,1,20),''DD-MON-YYYY HH24:MI:SS'',''NLS_DATE_LANGUAGE=ENGLISH'') '||l_sort_order;
1187: ELSIF p_sort_by='S' THEN
1188: l_order_by:='ORDER BY a.subject '||l_sort_order||',to_date(substr(a.sent_Date,1,20),''DD-MON-YYYY HH24:MI:SS'',''NLS_DATE_LANGUAGE=ENGLISH'') '||l_sort_order;
1189: ELSIF p_sort_by='C' THEN

Line 1225: IF p_display_size=FND_API.G_MISS_NUM THEN

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

Line 1229: IF p_page_count<>FND_API.G_MISS_NUM THEN

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

Line 1232: ELSIF p_page_count=FND_API.G_MISS_NUM THEN

1228: ELSE
1229: IF p_page_count<>FND_API.G_MISS_NUM THEN
1230: l_first_index:=p_page_count*p_display_size - p_display_size+1;
1231: l_last_index:=p_page_count*p_display_size;
1232: ELSIF p_page_count=FND_API.G_MISS_NUM THEN
1233: l_first_index:=1;
1234: l_last_index:=p_display_size;
1235: END IF;
1236: IF l_last_index > x_total_message THEN

Line 1254: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1256: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1259: p_data => x_msg_data
1260: );
1261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1262: ROLLBACK TO getemailheaders_pvt;
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1264: FND_MSG_PUB.Count_And_Get
1265: ( p_count => x_msg_count,
1266: p_data => x_msg_data
1267: );

Line 1270: x_return_status := FND_API.G_RET_STS_ERROR;

1266: p_data => x_msg_data
1267: );
1268: WHEN OTHERS THEN
1269: ROLLBACK TO getemailheaders_pvt;
1270: x_return_status := FND_API.G_RET_STS_ERROR;
1271: IF FND_MSG_PUB.Check_Msg_Level
1272: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1273: THEN
1274: FND_MSG_PUB.Add_Exc_Msg

Line 1320: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1316: l_sr_id varchar2(40):='IEMNBZTSRVSRID';
1317:
1318: BEGIN
1319: -- Standard call to check for call compatibility.
1320: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1321: p_api_version_number,
1322: l_api_name,
1323: G_PKG_NAME)
1324: THEN

Line 1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1321: p_api_version_number,
1322: l_api_name,
1323: G_PKG_NAME)
1324: THEN
1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1326: END IF;
1327: SAVEPOINT getunreademailheaders_pvt;
1328: x_return_status := FND_API.G_RET_STS_SUCCESS;
1329:

Line 1328: x_return_status := FND_API.G_RET_STS_SUCCESS;

1324: THEN
1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1326: END IF;
1327: SAVEPOINT getunreademailheaders_pvt;
1328: x_return_status := FND_API.G_RET_STS_SUCCESS;
1329:
1330:
1331: select decode(p_sort_order,0,'ASC','DESC')
1332: into l_sort_order

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

1331: select decode(p_sort_order,0,'ASC','DESC')
1332: into l_sort_order
1333: from dual;
1334:
1335: IF p_sort_by = FND_API.G_MISS_CHAR OR p_sort_by='D' THEN
1336: l_order_by:=' Order BY to_date(substr(a.sent_Date,1,20),''DD-MON-YYYY HH24:MI:SS'',''NLS_DATE_LANGUAGE=ENGLISH'') '||l_sort_order;
1337: ELSIF p_sort_by='S' THEN
1338: l_order_by:='ORDER BY a.subject '||l_sort_order||',to_date(substr(a.sent_Date,1,20),''DD-MON-YYYY HH24:MI:SS'',''NLS_DATE_LANGUAGE=ENGLISH'') '||l_sort_order;
1339: ELSIF p_sort_by='CL' THEN

Line 1404: IF p_display_size=FND_API.G_MISS_NUM THEN

1400: END LOOP;
1401: CLOSE email_cur;
1402: IF l_temp_tbl.count>0 THEN -- Data Selected Now implement Display Logic
1403: x_total_message:=l_temp_tbl.count;
1404: IF p_display_size=FND_API.G_MISS_NUM THEN
1405:
1406: x_queue_email_data:=l_temp_tbl; -- Return all data
1407: --incase of null display size
1408: ELSE

Line 1410: IF p_page_count<>FND_API.G_MISS_NUM THEN

1406: x_queue_email_data:=l_temp_tbl; -- Return all data
1407: --incase of null display size
1408: ELSE
1409:
1410: IF p_page_count<>FND_API.G_MISS_NUM THEN
1411: l_first_index:=p_page_count*p_display_size - p_display_size+1;
1412: l_last_index:=p_page_count*p_display_size;
1413: ELSIF p_page_count=FND_API.G_MISS_NUM THEN
1414: l_first_index:=1;

Line 1413: ELSIF p_page_count=FND_API.G_MISS_NUM THEN

1409:
1410: IF p_page_count<>FND_API.G_MISS_NUM THEN
1411: l_first_index:=p_page_count*p_display_size - p_display_size+1;
1412: l_last_index:=p_page_count*p_display_size;
1413: ELSIF p_page_count=FND_API.G_MISS_NUM THEN
1414: l_first_index:=1;
1415: l_last_index:=p_display_size;
1416: END IF;
1417: IF l_last_index > x_total_message THEN

Line 1435: WHEN FND_API.G_EXC_ERROR THEN

1431: ( p_count => x_msg_count,
1432: p_data => x_msg_data
1433: );
1434: EXCEPTION
1435: WHEN FND_API.G_EXC_ERROR THEN
1436: ROLLBACK TO getunreademailheaders_pvt;
1437: x_return_status := FND_API.G_RET_STS_ERROR ;
1438: FND_MSG_PUB.Count_And_Get
1439: ( p_count => x_msg_count,

Line 1437: x_return_status := FND_API.G_RET_STS_ERROR ;

1433: );
1434: EXCEPTION
1435: WHEN FND_API.G_EXC_ERROR THEN
1436: ROLLBACK TO getunreademailheaders_pvt;
1437: x_return_status := FND_API.G_RET_STS_ERROR ;
1438: FND_MSG_PUB.Count_And_Get
1439: ( p_count => x_msg_count,
1440: p_data => x_msg_data
1441: );

Line 1442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1438: FND_MSG_PUB.Count_And_Get
1439: ( p_count => x_msg_count,
1440: p_data => x_msg_data
1441: );
1442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1443: ROLLBACK TO getunreademailheaders_pvt;
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1445: FND_MSG_PUB.Count_And_Get
1446: ( p_count => x_msg_count,

Line 1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1440: p_data => x_msg_data
1441: );
1442: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1443: ROLLBACK TO getunreademailheaders_pvt;
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1445: FND_MSG_PUB.Count_And_Get
1446: ( p_count => x_msg_count,
1447: p_data => x_msg_data
1448: );

Line 1451: x_return_status := FND_API.G_RET_STS_ERROR;

1447: p_data => x_msg_data
1448: );
1449: WHEN OTHERS THEN
1450: ROLLBACK TO getunreademailheaders_pvt;
1451: x_return_status := FND_API.G_RET_STS_ERROR;
1452: IF FND_MSG_PUB.Check_Msg_Level
1453: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1454: THEN
1455: FND_MSG_PUB.Add_Exc_Msg

Line 1489: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1485: l_encrypted_id varchar2(500);
1486: l_index number;
1487: BEGIN
1488: -- Standard call to check for call compatibility.
1489: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1490: p_api_version_number,
1491: l_api_name,
1492: G_PKG_NAME)
1493: THEN

Line 1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1490: p_api_version_number,
1491: l_api_name,
1492: G_PKG_NAME)
1493: THEN
1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1495: END IF;
1496: SAVEPOINT select_data_PVT;
1497: x_return_status := FND_API.G_RET_STS_SUCCESS;
1498: SELECT * INTO x_email_data

Line 1497: x_return_status := FND_API.G_RET_STS_SUCCESS;

1493: THEN
1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1495: END IF;
1496: SAVEPOINT select_data_PVT;
1497: x_return_status := FND_API.G_RET_STS_SUCCESS;
1498: SELECT * INTO x_email_data
1499: FROM iem_rt_proc_emails
1500: WHERE message_id=p_message_id
1501: AND resource_id=0 for update;

Line 1541: WHEN FND_API.G_EXC_ERROR THEN

1537: x_return_status := 'N';
1538: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
1539: FND_MSG_PUB.ADD;
1540: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1541: WHEN FND_API.G_EXC_ERROR THEN
1542: ROLLBACK TO select_data_PVT;
1543: x_return_status := FND_API.G_RET_STS_ERROR ;
1544: FND_MSG_PUB.Count_And_Get
1545: ( p_count => x_msg_count,

Line 1543: x_return_status := FND_API.G_RET_STS_ERROR ;

1539: FND_MSG_PUB.ADD;
1540: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1541: WHEN FND_API.G_EXC_ERROR THEN
1542: ROLLBACK TO select_data_PVT;
1543: x_return_status := FND_API.G_RET_STS_ERROR ;
1544: FND_MSG_PUB.Count_And_Get
1545: ( p_count => x_msg_count,
1546: p_data => x_msg_data
1547: );

Line 1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1544: FND_MSG_PUB.Count_And_Get
1545: ( p_count => x_msg_count,
1546: p_data => x_msg_data
1547: );
1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1549: ROLLBACK TO select_data_PVT;
1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1551: FND_MSG_PUB.Count_And_Get
1552: ( p_count => x_msg_count,

Line 1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1546: p_data => x_msg_data
1547: );
1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1549: ROLLBACK TO select_data_PVT;
1550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1551: FND_MSG_PUB.Count_And_Get
1552: ( p_count => x_msg_count,
1553: p_data => x_msg_data
1554: );

Line 1557: x_return_status := FND_API.G_RET_STS_ERROR;

1553: p_data => x_msg_data
1554: );
1555: WHEN OTHERS THEN
1556: ROLLBACK TO select_data_PVT;
1557: x_return_status := FND_API.G_RET_STS_ERROR;
1558: IF FND_MSG_PUB.Check_Msg_Level
1559: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1560: THEN
1561: FND_MSG_PUB.Add_Exc_Msg

Line 1627: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1623: l_media_data JTF_IH_MEDIA_ITEMS%ROWTYPE;
1624: ERROR_CLOSING_MEDIA EXCEPTION;
1625: BEGIN
1626: -- Standard call to check for call compatibility.
1627: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1628: p_api_version_number,
1629: l_api_name,
1630: G_PKG_NAME)
1631: THEN

Line 1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1628: p_api_version_number,
1629: l_api_name,
1630: G_PKG_NAME)
1631: THEN
1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1633: END IF;
1634: SAVEPOINT select_data_PVT;
1635: x_return_status := FND_API.G_RET_STS_SUCCESS;
1636: select * into l_msg_rec from iem_rt_proc_emails

Line 1635: x_return_status := FND_API.G_RET_STS_SUCCESS;

1631: THEN
1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1633: END IF;
1634: SAVEPOINT select_data_PVT;
1635: x_return_status := FND_API.G_RET_STS_SUCCESS;
1636: select * into l_msg_rec from iem_rt_proc_emails
1637: where message_id=p_message_id;
1638: -- Close The Media Item
1639: BEGIN

Line 1743: WHEN FND_API.G_EXC_ERROR THEN

1739: x_return_status := 'N';
1740: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
1741: FND_MSG_PUB.ADD;
1742: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1743: WHEN FND_API.G_EXC_ERROR THEN
1744: ROLLBACK TO resolve_data_pvt;
1745: x_return_status := FND_API.G_RET_STS_ERROR ;
1746: FND_MSG_PUB.Count_And_Get
1747: ( p_count => x_msg_count,

Line 1745: x_return_status := FND_API.G_RET_STS_ERROR ;

1741: FND_MSG_PUB.ADD;
1742: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1743: WHEN FND_API.G_EXC_ERROR THEN
1744: ROLLBACK TO resolve_data_pvt;
1745: x_return_status := FND_API.G_RET_STS_ERROR ;
1746: FND_MSG_PUB.Count_And_Get
1747: ( p_count => x_msg_count,
1748: p_data => x_msg_data
1749: );

Line 1750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1746: FND_MSG_PUB.Count_And_Get
1747: ( p_count => x_msg_count,
1748: p_data => x_msg_data
1749: );
1750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1751: ROLLBACK TO resolve_data_pvt;
1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1753: FND_MSG_PUB.Count_And_Get
1754: ( p_count => x_msg_count,

Line 1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1748: p_data => x_msg_data
1749: );
1750: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1751: ROLLBACK TO resolve_data_pvt;
1752: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1753: FND_MSG_PUB.Count_And_Get
1754: ( p_count => x_msg_count,
1755: p_data => x_msg_data
1756: );

Line 1759: x_return_status := FND_API.G_RET_STS_ERROR;

1755: p_data => x_msg_data
1756: );
1757: WHEN ERROR_CLOSING_MEDIA THEN
1758: ROLLBACK TO resolve_data_pvt;
1759: x_return_status := FND_API.G_RET_STS_ERROR;
1760: WHEN OTHERS THEN
1761: ROLLBACK TO resolve_data_pvt;
1762: x_return_status := FND_API.G_RET_STS_ERROR;
1763: IF FND_MSG_PUB.Check_Msg_Level

Line 1762: x_return_status := FND_API.G_RET_STS_ERROR;

1758: ROLLBACK TO resolve_data_pvt;
1759: x_return_status := FND_API.G_RET_STS_ERROR;
1760: WHEN OTHERS THEN
1761: ROLLBACK TO resolve_data_pvt;
1762: x_return_status := FND_API.G_RET_STS_ERROR;
1763: IF FND_MSG_PUB.Check_Msg_Level
1764: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1765: THEN
1766: FND_MSG_PUB.Add_Exc_Msg