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

Line 51: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

47: l_api_name VARCHAR2(255):='create_pp_queue';
48: l_api_version_number NUMBER:=1.0;
49: l_seq_id NUMBER;
50:
51: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
52: l_msg_count NUMBER := 0;
53: l_msg_data VARCHAR2(2000);
54: i INTEGER;
55: l_action number :=1;

Line 64: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

60: SAVEPOINT create_item_tag_PVT;
61:
62: -- Standard call to check for call compatibility.
63:
64: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
65: p_api_version_number,
66: l_api_name,
67: G_PKG_NAME)
68: THEN

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: p_api_version_number,
66: l_api_name,
67: G_PKG_NAME)
68: THEN
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
70: END IF;
71:
72:
73: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 74: IF FND_API.to_Boolean( p_init_msg_list )

70: END IF;
71:
72:
73: -- Initialize message list if p_init_msg_list is set to TRUE.
74: IF FND_API.to_Boolean( p_init_msg_list )
75: THEN
76: FND_MSG_PUB.initialize;
77: END IF;
78:

Line 80: x_return_status := FND_API.G_RET_STS_SUCCESS;

76: FND_MSG_PUB.initialize;
77: END IF;
78:
79: -- Initialize API return status to SUCCESS
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: --begins here
83:
84: --get next sequential number for msg_meta_id

Line 164: IF FND_API.To_Boolean(p_commit) THEN

160:
161: end if; -- FIRST is not null
162:
163: -- Standard Check Of p_commit.
164: IF FND_API.To_Boolean(p_commit) THEN
165: COMMIT WORK;
166: END IF;
167:
168:

Line 177: WHEN FND_API.G_EXC_ERROR THEN

173: );
174:
175: EXCEPTION
176:
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO create_item_tag_PVT;
179: x_return_status := FND_API.G_RET_STS_ERROR ;
180: FND_MSG_PUB.Count_And_Get
181:

Line 179: x_return_status := FND_API.G_RET_STS_ERROR ;

175: EXCEPTION
176:
177: WHEN FND_API.G_EXC_ERROR THEN
178: ROLLBACK TO create_item_tag_PVT;
179: x_return_status := FND_API.G_RET_STS_ERROR ;
180: FND_MSG_PUB.Count_And_Get
181:
182: ( p_count => x_msg_count,
183: p_data => x_msg_data

Line 186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

182: ( p_count => x_msg_count,
183: p_data => x_msg_data
184: );
185:
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: ROLLBACK TO create_item_tag_PVT;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
189: FND_MSG_PUB.Count_And_Get
190: ( p_count => x_msg_count,

Line 188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

184: );
185:
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: ROLLBACK TO create_item_tag_PVT;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
189: FND_MSG_PUB.Count_And_Get
190: ( p_count => x_msg_count,
191: p_data => x_msg_data
192: );

Line 196: x_return_status := FND_API.G_RET_STS_ERROR;

192: );
193:
194: WHEN OTHERS THEN
195: ROLLBACK TO create_item_tag_PVT;
196: x_return_status := FND_API.G_RET_STS_ERROR;
197: IF FND_MSG_PUB.Check_Msg_Level
198: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
199: THEN
200: FND_MSG_PUB.Add_Exc_Msg

Line 233: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

229: l_api_name VARCHAR2(255):='create_item_tag';
230: l_api_version_number NUMBER:=1.0;
231: l_seq_id NUMBER;
232:
233: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
234: l_msg_count NUMBER := 0;
235: l_msg_data VARCHAR2(2000);
236:
237: l_queue_rec iem_rt_pp_queues%rowtype;

Line 247: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

243: SAVEPOINT get_queue_rec_PVT;
244:
245: -- Standard call to check for call compatibility.
246:
247: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
248: p_api_version_number,
249: l_api_name,
250: G_PKG_NAME)
251: THEN

Line 252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

248: p_api_version_number,
249: l_api_name,
250: G_PKG_NAME)
251: THEN
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: END IF;
254:
255:
256: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 257: IF FND_API.to_Boolean( p_init_msg_list )

253: END IF;
254:
255:
256: -- Initialize message list if p_init_msg_list is set to TRUE.
257: IF FND_API.to_Boolean( p_init_msg_list )
258: THEN
259: FND_MSG_PUB.initialize;
260: END IF;
261:

Line 263: x_return_status := FND_API.G_RET_STS_SUCCESS;

259: FND_MSG_PUB.initialize;
260: END IF;
261:
262: -- Initialize API return status to SUCCESS
263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264:
265: for x in ( select email_id
266: from IEM_RT_PP_QUEUES
267: where flag = 'N' and retry_count < 5

Line 295: IF FND_API.To_Boolean(p_commit) THEN

291: x_action := l_queue_rec.action;
292: END IF;
293:
294: -- Standard Check Of p_commit.
295: IF FND_API.To_Boolean(p_commit) THEN
296: COMMIT WORK;
297: END IF;
298:
299: -- Standard callto get message count and if count is 1, get message info.

Line 305: WHEN FND_API.G_EXC_ERROR THEN

301: ( p_count => x_msg_count,
302: p_data => x_msg_data
303: );
304: EXCEPTION
305: WHEN FND_API.G_EXC_ERROR THEN
306: ROLLBACK TO get_queue_rec_PVT;
307: x_return_status := FND_API.G_RET_STS_ERROR ;
308: FND_MSG_PUB.Count_And_Get
309:

Line 307: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

310: ( p_count => x_msg_count,
311: p_data => x_msg_data
312: );
313:
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: ROLLBACK TO get_queue_rec_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: );
313:
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: ROLLBACK TO get_queue_rec_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 324: x_return_status := FND_API.G_RET_STS_ERROR;

320: );
321:
322: WHEN OTHERS THEN
323: ROLLBACK TO get_queue_rec_PVT;
324: x_return_status := FND_API.G_RET_STS_ERROR;
325: IF FND_MSG_PUB.Check_Msg_Level
326: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
327: THEN
328: FND_MSG_PUB.Add_Exc_Msg

Line 354: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

350: l_api_name VARCHAR2(255):='expunge_queue';
351: l_api_version_number NUMBER:=1.0;
352: l_seq_id NUMBER;
353:
354: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
355: l_msg_count NUMBER := 0;
356: l_msg_data VARCHAR2(2000);
357:
358: BEGIN

Line 364: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

360: SAVEPOINT create_item_tag_PVT;
361:
362: -- Standard call to check for call compatibility.
363:
364: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
365: p_api_version_number,
366: l_api_name,
367: G_PKG_NAME)
368: THEN

Line 369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

365: p_api_version_number,
366: l_api_name,
367: G_PKG_NAME)
368: THEN
369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
370: END IF;
371:
372:
373: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 374: IF FND_API.to_Boolean( p_init_msg_list )

370: END IF;
371:
372:
373: -- Initialize message list if p_init_msg_list is set to TRUE.
374: IF FND_API.to_Boolean( p_init_msg_list )
375: THEN
376: FND_MSG_PUB.initialize;
377: END IF;
378:

Line 380: x_return_status := FND_API.G_RET_STS_SUCCESS;

376: FND_MSG_PUB.initialize;
377: END IF;
378:
379: -- Initialize API return status to SUCCESS
380: x_return_status := FND_API.G_RET_STS_SUCCESS;
381:
382: --begins here
383:
384: -- Changed the Query to delete all records with 'Q' status as well( to clean up iem_rt_pp_queues table)

Line 393: IF FND_API.To_Boolean(p_commit) THEN

389: and email_account_id=p_acct_id );
390: delete IEM_RT_PP_QUEUES where flag in ('S','Q','X') and email_account_id=p_acct_id ;
391:
392: -- Standard Check Of p_commit.
393: IF FND_API.To_Boolean(p_commit) THEN
394: COMMIT WORK;
395: END IF;
396:
397:

Line 406: WHEN FND_API.G_EXC_ERROR THEN

402: );
403:
404: EXCEPTION
405:
406: WHEN FND_API.G_EXC_ERROR THEN
407: ROLLBACK TO create_item_tag_PVT;
408: x_return_status := FND_API.G_RET_STS_ERROR ;
409: FND_MSG_PUB.Count_And_Get
410:

Line 408: x_return_status := FND_API.G_RET_STS_ERROR ;

404: EXCEPTION
405:
406: WHEN FND_API.G_EXC_ERROR THEN
407: ROLLBACK TO create_item_tag_PVT;
408: x_return_status := FND_API.G_RET_STS_ERROR ;
409: FND_MSG_PUB.Count_And_Get
410:
411: ( p_count => x_msg_count,
412: p_data => x_msg_data

Line 415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

411: ( p_count => x_msg_count,
412: p_data => x_msg_data
413: );
414:
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO create_item_tag_PVT;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418: FND_MSG_PUB.Count_And_Get
419: ( p_count => x_msg_count,

Line 417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

413: );
414:
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO create_item_tag_PVT;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418: FND_MSG_PUB.Count_And_Get
419: ( p_count => x_msg_count,
420: p_data => x_msg_data
421: );

Line 425: x_return_status := FND_API.G_RET_STS_ERROR;

421: );
422:
423: WHEN OTHERS THEN
424: ROLLBACK TO create_item_tag_PVT;
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: IF FND_MSG_PUB.Check_Msg_Level
427: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
428: THEN
429: FND_MSG_PUB.Add_Exc_Msg

Line 464: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

460: l_api_name VARCHAR2(255):='get_queue_recs';
461: l_api_version_number NUMBER:=1.0;
462: l_seq_id NUMBER;
463:
464: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
465: l_msg_count NUMBER := 0;
466: l_msg_data VARCHAR2(2000);
467:
468: l_queue_rec iem_rt_pp_queues%rowtype;

Line 487: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

483: SAVEPOINT get_queue_rec_PVT;
484:
485: -- Standard call to check for call compatibility.
486:
487: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
488: p_api_version_number,
489: l_api_name,
490: G_PKG_NAME)
491: THEN

Line 492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

488: p_api_version_number,
489: l_api_name,
490: G_PKG_NAME)
491: THEN
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493: END IF;
494:
495:
496: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 497: IF FND_API.to_Boolean( p_init_msg_list )

493: END IF;
494:
495:
496: -- Initialize message list if p_init_msg_list is set to TRUE.
497: IF FND_API.to_Boolean( p_init_msg_list )
498: THEN
499: FND_MSG_PUB.initialize;
500: END IF;
501:

Line 503: x_return_status := FND_API.G_RET_STS_SUCCESS;

499: FND_MSG_PUB.initialize;
500: END IF;
501:
502: -- Initialize API return status to SUCCESS
503: x_return_status := FND_API.G_RET_STS_SUCCESS;
504:
505:
506: i := 1;
507: for y in ( select email_account_id, count(*) total,

Line 569: IF FND_API.To_Boolean(p_commit) THEN

565: x_actions := l_actions;
566: x_rfc_msgids := l_rfc_msgids;
567:
568: -- Standard Check Of p_commit.
569: IF FND_API.To_Boolean(p_commit) THEN
570: COMMIT WORK;
571: END IF;
572:
573: -- Standard callto get message count and if count is 1, get message info.

Line 579: WHEN FND_API.G_EXC_ERROR THEN

575: ( p_count => x_msg_count,
576: p_data => x_msg_data
577: );
578: EXCEPTION
579: WHEN FND_API.G_EXC_ERROR THEN
580: ROLLBACK TO get_queue_rec_PVT;
581: x_return_status := FND_API.G_RET_STS_ERROR ;
582: FND_MSG_PUB.Count_And_Get
583:

Line 581: x_return_status := FND_API.G_RET_STS_ERROR ;

577: );
578: EXCEPTION
579: WHEN FND_API.G_EXC_ERROR THEN
580: ROLLBACK TO get_queue_rec_PVT;
581: x_return_status := FND_API.G_RET_STS_ERROR ;
582: FND_MSG_PUB.Count_And_Get
583:
584: ( p_count => x_msg_count,
585: p_data => x_msg_data

Line 588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

584: ( p_count => x_msg_count,
585: p_data => x_msg_data
586: );
587:
588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
589: ROLLBACK TO get_queue_rec_PVT;
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
591: FND_MSG_PUB.Count_And_Get
592: ( p_count => x_msg_count,

Line 590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

586: );
587:
588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
589: ROLLBACK TO get_queue_rec_PVT;
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
591: FND_MSG_PUB.Count_And_Get
592: ( p_count => x_msg_count,
593: p_data => x_msg_data
594: );

Line 598: x_return_status := FND_API.G_RET_STS_ERROR;

594: );
595:
596: WHEN OTHERS THEN
597: ROLLBACK TO get_queue_rec_PVT;
598: x_return_status := FND_API.G_RET_STS_ERROR;
599: IF FND_MSG_PUB.Check_Msg_Level
600: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
601: THEN
602: FND_MSG_PUB.Add_Exc_Msg

Line 631: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

627: l_api_version_number NUMBER:=1.0;
628: l_seq_id NUMBER;
629: l_count NUMBER;
630:
631: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
632: l_msg_count NUMBER := 0;
633: l_msg_data VARCHAR2(2000);
634:
635: BEGIN

Line 641: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

637: SAVEPOINT create_item_tag_PVT;
638:
639: -- Standard call to check for call compatibility.
640:
641: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
642: p_api_version_number,
643: l_api_name,
644: G_PKG_NAME)
645: THEN

Line 646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

642: p_api_version_number,
643: l_api_name,
644: G_PKG_NAME)
645: THEN
646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
647: END IF;
648:
649:
650: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 651: IF FND_API.to_Boolean( p_init_msg_list )

647: END IF;
648:
649:
650: -- Initialize message list if p_init_msg_list is set to TRUE.
651: IF FND_API.to_Boolean( p_init_msg_list )
652: THEN
653: FND_MSG_PUB.initialize;
654: END IF;
655:

Line 657: x_return_status := FND_API.G_RET_STS_SUCCESS;

653: FND_MSG_PUB.initialize;
654: END IF;
655:
656: -- Initialize API return status to SUCCESS
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658:
659: --begins here
660: For j in 1..p_queue_ids.count loop
661:

Line 681: WHEN FND_API.G_EXC_ERROR THEN

677: );
678:
679: EXCEPTION
680:
681: WHEN FND_API.G_EXC_ERROR THEN
682: ROLLBACK TO create_item_tag_PVT;
683: x_return_status := FND_API.G_RET_STS_ERROR ;
684: FND_MSG_PUB.Count_And_Get
685:

Line 683: x_return_status := FND_API.G_RET_STS_ERROR ;

679: EXCEPTION
680:
681: WHEN FND_API.G_EXC_ERROR THEN
682: ROLLBACK TO create_item_tag_PVT;
683: x_return_status := FND_API.G_RET_STS_ERROR ;
684: FND_MSG_PUB.Count_And_Get
685:
686: ( p_count => x_msg_count,
687: p_data => x_msg_data

Line 690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

686: ( p_count => x_msg_count,
687: p_data => x_msg_data
688: );
689:
690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
691: ROLLBACK TO create_item_tag_PVT;
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
693: FND_MSG_PUB.Count_And_Get
694: ( p_count => x_msg_count,

Line 692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

688: );
689:
690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
691: ROLLBACK TO create_item_tag_PVT;
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
693: FND_MSG_PUB.Count_And_Get
694: ( p_count => x_msg_count,
695: p_data => x_msg_data
696: );

Line 700: x_return_status := FND_API.G_RET_STS_ERROR;

696: );
697:
698: WHEN OTHERS THEN
699: ROLLBACK TO create_item_tag_PVT;
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: IF FND_MSG_PUB.Check_Msg_Level
702: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
703: THEN
704: FND_MSG_PUB.Add_Exc_Msg

Line 731: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

727: l_api_version_number NUMBER:=1.0;
728: l_seq_id NUMBER;
729: l_count NUMBER;
730:
731: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
732: l_msg_count NUMBER := 0;
733: l_msg_data VARCHAR2(2000);
734:
735: BEGIN

Line 741: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

737: SAVEPOINT reset_data_PVT;
738:
739: -- Standard call to check for call compatibility.
740:
741: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
742: p_api_version_number,
743: l_api_name,
744: G_PKG_NAME)
745: THEN

Line 746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

742: p_api_version_number,
743: l_api_name,
744: G_PKG_NAME)
745: THEN
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;
748:
749:
750: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 751: IF FND_API.to_Boolean( p_init_msg_list )

747: END IF;
748:
749:
750: -- Initialize message list if p_init_msg_list is set to TRUE.
751: IF FND_API.to_Boolean( p_init_msg_list )
752: THEN
753: FND_MSG_PUB.initialize;
754: END IF;
755:

Line 757: x_return_status := FND_API.G_RET_STS_SUCCESS;

753: FND_MSG_PUB.initialize;
754: END IF;
755:
756: -- Initialize API return status to SUCCESS
757: x_return_status := FND_API.G_RET_STS_SUCCESS;
758:
759: --begins here
760: update iem_rt_pp_queues set flag='N' where flag='A' and retry_count<=4;
761:

Line 770: WHEN FND_API.G_EXC_ERROR THEN

766: );
767:
768: EXCEPTION
769:
770: WHEN FND_API.G_EXC_ERROR THEN
771: ROLLBACK TO create_item_tag_PVT;
772: x_return_status := FND_API.G_RET_STS_ERROR ;
773: FND_MSG_PUB.Count_And_Get
774:

Line 772: x_return_status := FND_API.G_RET_STS_ERROR ;

768: EXCEPTION
769:
770: WHEN FND_API.G_EXC_ERROR THEN
771: ROLLBACK TO create_item_tag_PVT;
772: x_return_status := FND_API.G_RET_STS_ERROR ;
773: FND_MSG_PUB.Count_And_Get
774:
775: ( p_count => x_msg_count,
776: p_data => x_msg_data

Line 779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

775: ( p_count => x_msg_count,
776: p_data => x_msg_data
777: );
778:
779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
780: ROLLBACK TO create_item_tag_PVT;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
782: FND_MSG_PUB.Count_And_Get
783: ( p_count => x_msg_count,

Line 781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

777: );
778:
779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
780: ROLLBACK TO create_item_tag_PVT;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
782: FND_MSG_PUB.Count_And_Get
783: ( p_count => x_msg_count,
784: p_data => x_msg_data
785: );

Line 789: x_return_status := FND_API.G_RET_STS_ERROR;

785: );
786:
787: WHEN OTHERS THEN
788: ROLLBACK TO create_item_tag_PVT;
789: x_return_status := FND_API.G_RET_STS_ERROR;
790: IF FND_MSG_PUB.Check_Msg_Level
791: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
792: THEN
793: FND_MSG_PUB.Add_Exc_Msg