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

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

49: l_api_name VARCHAR2(255):='create_item_tag';
50: l_api_version_number NUMBER:=1.0;
51: l_seq_id NUMBER;
52:
53: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
54: l_msg_count NUMBER := 0;
55: l_msg_data VARCHAR2(2000);
56:
57: l_subject VARCHAR2(2000);

Line 81: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

77: SAVEPOINT create_item_tag_PVT;
78:
79: -- Standard call to check for call compatibility.
80:
81: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
82: p_api_version_number,
83: l_api_name,
84: G_PKG_NAME)
85: THEN

Line 86: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

82: p_api_version_number,
83: l_api_name,
84: G_PKG_NAME)
85: THEN
86: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
87: END IF;
88:
89:
90: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 91: IF FND_API.to_Boolean( p_init_msg_list )

87: END IF;
88:
89:
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91: IF FND_API.to_Boolean( p_init_msg_list )
92: THEN
93: FND_MSG_PUB.initialize;
94: END IF;
95:

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: -- Initialize API return status to SUCCESS
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: --begins here
100:
101: --get next sequential number for msg_meta_id

Line 177: IF FND_API.To_Boolean(p_commit) THEN

173: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
174: );
175:
176: -- Standard Check Of p_commit.
177: IF FND_API.To_Boolean(p_commit) THEN
178: COMMIT WORK;
179: END IF;
180: x_ref_key := l_seq_id;
181:

Line 190: WHEN FND_API.G_EXC_ERROR THEN

186: );
187:
188: EXCEPTION
189:
190: WHEN FND_API.G_EXC_ERROR THEN
191: ROLLBACK TO create_item_tag_PVT;
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: FND_MSG_PUB.Count_And_Get
194:

Line 192: x_return_status := FND_API.G_RET_STS_ERROR ;

188: EXCEPTION
189:
190: WHEN FND_API.G_EXC_ERROR THEN
191: ROLLBACK TO create_item_tag_PVT;
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: FND_MSG_PUB.Count_And_Get
194:
195: ( p_count => x_msg_count,
196: p_data => x_msg_data

Line 199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

195: ( p_count => x_msg_count,
196: p_data => x_msg_data
197: );
198:
199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
200: ROLLBACK TO create_item_tag_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: );
198:
199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
200: ROLLBACK TO create_item_tag_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 209: x_return_status := FND_API.G_RET_STS_ERROR;

205: );
206:
207: WHEN OTHERS THEN
208: ROLLBACK TO create_item_tag_PVT;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: IF FND_MSG_PUB.Check_Msg_Level
211: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
212: THEN
213: FND_MSG_PUB.Add_Exc_Msg

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

240: l_api_name VARCHAR2(255):= 'create_headers';
241: l_api_version_number NUMBER:=1.0;
242: l_seq_id NUMBER;
243:
244: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
245: l_msg_count NUMBER := 0;
246: l_msg_data VARCHAR2(2000);
247:
248: --l_seq_id number;

Line 262: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

258: SAVEPOINT create_sender_recipient_PVT;
259:
260: -- Standard call to check for call compatibility.
261:
262: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
263: p_api_version_number,
264: l_api_name,
265: G_PKG_NAME)
266: THEN

Line 267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

263: p_api_version_number,
264: l_api_name,
265: G_PKG_NAME)
266: THEN
267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
268: END IF;
269:
270:
271: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 272: IF FND_API.to_Boolean( p_init_msg_list )

268: END IF;
269:
270:
271: -- Initialize message list if p_init_msg_list is set to TRUE.
272: IF FND_API.to_Boolean( p_init_msg_list )
273: THEN
274: FND_MSG_PUB.initialize;
275: END IF;
276:

Line 278: x_return_status := FND_API.G_RET_STS_SUCCESS;

274: FND_MSG_PUB.initialize;
275: END IF;
276:
277: -- Initialize API return status to SUCCESS
278: x_return_status := FND_API.G_RET_STS_SUCCESS;
279:
280: --begins here
281: FOR i IN p_msg_meta_id.FIRST..p_msg_meta_id.LAST LOOP
282:

Line 318: IF FND_API.To_Boolean(p_commit) THEN

314: );
315: end loop;
316:
317: -- Standard Check Of p_commit.
318: IF FND_API.To_Boolean(p_commit) THEN
319: COMMIT WORK;
320: END IF;
321:
322: -- Standard callto get message count and if count is 1, get message info.

Line 330: WHEN FND_API.G_EXC_ERROR THEN

326: );
327:
328: EXCEPTION
329:
330: WHEN FND_API.G_EXC_ERROR THEN
331: ROLLBACK TO create_sender_recipient_PVT;
332: x_return_status := FND_API.G_RET_STS_ERROR ;
333: FND_MSG_PUB.Count_And_Get
334:

Line 332: x_return_status := FND_API.G_RET_STS_ERROR ;

328: EXCEPTION
329:
330: WHEN FND_API.G_EXC_ERROR THEN
331: ROLLBACK TO create_sender_recipient_PVT;
332: x_return_status := FND_API.G_RET_STS_ERROR ;
333: FND_MSG_PUB.Count_And_Get
334:
335: ( p_count => x_msg_count,
336: p_data => x_msg_data

Line 339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

335: ( p_count => x_msg_count,
336: p_data => x_msg_data
337: );
338:
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
340: ROLLBACK TO create_sender_recipient_PVT;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
342: FND_MSG_PUB.Count_And_Get
343: ( p_count => x_msg_count,

Line 341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

337: );
338:
339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
340: ROLLBACK TO create_sender_recipient_PVT;
341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
342: FND_MSG_PUB.Count_And_Get
343: ( p_count => x_msg_count,
344: p_data => x_msg_data
345: );

Line 349: x_return_status := FND_API.G_RET_STS_ERROR;

345: );
346:
347: WHEN OTHERS THEN
348: ROLLBACK TO create_sender_recipient_PVT;
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: IF FND_MSG_PUB.Check_Msg_Level
351: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
352: THEN
353: FND_MSG_PUB.Add_Exc_Msg

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

378: l_api_name VARCHAR2(255):= 'create_string_msg_body';
379: l_api_version_number NUMBER:=1.0;
380: l_seq_id NUMBER;
381:
382: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
383: l_msg_count NUMBER := 0;
384: l_msg_data VARCHAR2(2000);
385:
386: l_msg_meta_id NUMBER;

Line 398: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

394: SAVEPOINT create_sender_recipient_PVT;
395:
396: -- Standard call to check for call compatibility.
397:
398: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
399: p_api_version_number,
400: l_api_name,
401: G_PKG_NAME)
402: THEN

Line 403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

399: p_api_version_number,
400: l_api_name,
401: G_PKG_NAME)
402: THEN
403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
404: END IF;
405:
406:
407: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 408: IF FND_API.to_Boolean( p_init_msg_list )

404: END IF;
405:
406:
407: -- Initialize message list if p_init_msg_list is set to TRUE.
408: IF FND_API.to_Boolean( p_init_msg_list )
409: THEN
410: FND_MSG_PUB.initialize;
411: END IF;
412:

Line 414: x_return_status := FND_API.G_RET_STS_SUCCESS;

410: FND_MSG_PUB.initialize;
411: END IF;
412:
413: -- Initialize API return status to SUCCESS
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415:
416: --begins here
417:
418: FOR i IN p_msg_body.FIRST..p_msg_body.LAST LOOP

Line 450: IF FND_API.To_Boolean(p_commit) THEN

446: );
447: end loop;
448:
449: -- Standard Check Of p_commit.
450: IF FND_API.To_Boolean(p_commit) THEN
451: COMMIT WORK;
452: END IF;
453:
454: -- Standard callto get message count and if count is 1, get message info.

Line 462: WHEN FND_API.G_EXC_ERROR THEN

458: );
459:
460: EXCEPTION
461:
462: WHEN FND_API.G_EXC_ERROR THEN
463: ROLLBACK TO create_sender_recipient_PVT;
464: x_return_status := FND_API.G_RET_STS_ERROR ;
465: FND_MSG_PUB.Count_And_Get
466:

Line 464: x_return_status := FND_API.G_RET_STS_ERROR ;

460: EXCEPTION
461:
462: WHEN FND_API.G_EXC_ERROR THEN
463: ROLLBACK TO create_sender_recipient_PVT;
464: x_return_status := FND_API.G_RET_STS_ERROR ;
465: FND_MSG_PUB.Count_And_Get
466:
467: ( p_count => x_msg_count,
468: p_data => x_msg_data

Line 471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

467: ( p_count => x_msg_count,
468: p_data => x_msg_data
469: );
470:
471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
472: ROLLBACK TO create_sender_recipient_PVT;
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
474: FND_MSG_PUB.Count_And_Get
475: ( p_count => x_msg_count,

Line 473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

469: );
470:
471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
472: ROLLBACK TO create_sender_recipient_PVT;
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
474: FND_MSG_PUB.Count_And_Get
475: ( p_count => x_msg_count,
476: p_data => x_msg_data
477: );

Line 481: x_return_status := FND_API.G_RET_STS_ERROR;

477: );
478:
479: WHEN OTHERS THEN
480: ROLLBACK TO create_sender_recipient_PVT;
481: x_return_status := FND_API.G_RET_STS_ERROR;
482: IF FND_MSG_PUB.Check_Msg_Level
483: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
484: THEN
485: FND_MSG_PUB.Add_Exc_Msg

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

510: l_api_name VARCHAR2(255):='insert_preproc_wrapper';
511: l_api_version_number NUMBER:=1.0;
512: l_seq_id NUMBER;
513:
514: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
515: l_msg_count NUMBER := 0;
516: l_msg_data VARCHAR2(2000);
517:
518: l_received_date DATE := sysdate;

Line 526: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

522: SAVEPOINT insert_preproc_wrapper_PVT;
523:
524: -- Standard call to check for call compatibility.
525:
526: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
527: p_api_version_number,
528: l_api_name,
529: G_PKG_NAME)
530: THEN

Line 531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

527: p_api_version_number,
528: l_api_name,
529: G_PKG_NAME)
530: THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533:
534:
535: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 536: IF FND_API.to_Boolean( p_init_msg_list )

532: END IF;
533:
534:
535: -- Initialize message list if p_init_msg_list is set to TRUE.
536: IF FND_API.to_Boolean( p_init_msg_list )
537: THEN
538: FND_MSG_PUB.initialize;
539: END IF;
540:

Line 542: x_return_status := FND_API.G_RET_STS_SUCCESS;

538: FND_MSG_PUB.initialize;
539: END IF;
540:
541: -- Initialize API return status to SUCCESS
542: x_return_status := FND_API.G_RET_STS_SUCCESS;
543:
544: --begins here
545:
546: --get next sequential number for msg_meta_id

Line 563: IF FND_API.To_Boolean(p_commit) THEN

559: x_msg_count => l_msg_count,
560: x_msg_data => l_msg_data);
561:
562: -- Standard Check Of p_commit.
563: IF FND_API.To_Boolean(p_commit) THEN
564: COMMIT WORK;
565: END IF;
566:
567: -- Standard callto get message count and if count is 1, get message info.

Line 575: WHEN FND_API.G_EXC_ERROR THEN

571: );
572:
573: EXCEPTION
574:
575: WHEN FND_API.G_EXC_ERROR THEN
576: ROLLBACK TO insert_preproc_wrapper_PVT;
577: x_return_status := FND_API.G_RET_STS_ERROR ;
578: FND_MSG_PUB.Count_And_Get
579:

Line 577: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

580: ( p_count => x_msg_count,
581: p_data => x_msg_data
582: );
583:
584: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
585: ROLLBACK TO insert_preproc_wrapper_PVT;
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
587: FND_MSG_PUB.Count_And_Get
588: ( p_count => x_msg_count,

Line 586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 594: x_return_status := FND_API.G_RET_STS_ERROR;

590: );
591:
592: WHEN OTHERS THEN
593: ROLLBACK TO insert_preproc_wrapper_PVT;
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: IF FND_MSG_PUB.Check_Msg_Level
596: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg

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

627: l_api_name VARCHAR2(255):='insert_preproc_wrapper';
628: l_api_version_number NUMBER:=1.0;
629: l_seq_id 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: l_received_date DATE := sysdate;

Line 643: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

Line 648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 653: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 659: x_return_status := FND_API.G_RET_STS_SUCCESS;

655: FND_MSG_PUB.initialize;
656: END IF;
657:
658: -- Initialize API return status to SUCCESS
659: x_return_status := FND_API.G_RET_STS_SUCCESS;
660:
661: --begins here
662:
663: --get next sequential number for msg_meta_id

Line 682: IF FND_API.To_Boolean(p_commit) THEN

678: AND PART_NAME = p_part_name;
679:
680:
681: -- Standard Check Of p_commit.
682: IF FND_API.To_Boolean(p_commit) THEN
683: COMMIT WORK;
684: END IF;
685:
686: -- Standard callto get message count and if count is 1, get message info.

Line 694: WHEN FND_API.G_EXC_ERROR THEN

690: );
691:
692: EXCEPTION
693:
694: WHEN FND_API.G_EXC_ERROR THEN
695: ROLLBACK TO insert_preproc_wrapper_PVT;
696: x_return_status := FND_API.G_RET_STS_ERROR ;
697: FND_MSG_PUB.Count_And_Get
698:

Line 696: x_return_status := FND_API.G_RET_STS_ERROR ;

692: EXCEPTION
693:
694: WHEN FND_API.G_EXC_ERROR THEN
695: ROLLBACK TO insert_preproc_wrapper_PVT;
696: x_return_status := FND_API.G_RET_STS_ERROR ;
697: FND_MSG_PUB.Count_And_Get
698:
699: ( p_count => x_msg_count,
700: p_data => x_msg_data

Line 703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

699: ( p_count => x_msg_count,
700: p_data => x_msg_data
701: );
702:
703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
704: ROLLBACK TO insert_preproc_wrapper_PVT;
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
706: FND_MSG_PUB.Count_And_Get
707: ( p_count => x_msg_count,

Line 705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

701: );
702:
703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
704: ROLLBACK TO insert_preproc_wrapper_PVT;
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
706: FND_MSG_PUB.Count_And_Get
707: ( p_count => x_msg_count,
708: p_data => x_msg_data
709: );

Line 713: x_return_status := FND_API.G_RET_STS_ERROR;

709: );
710:
711: WHEN OTHERS THEN
712: ROLLBACK TO insert_preproc_wrapper_PVT;
713: x_return_status := FND_API.G_RET_STS_ERROR;
714: IF FND_MSG_PUB.Check_Msg_Level
715: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
716: THEN
717: FND_MSG_PUB.Add_Exc_Msg