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 51: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

47: l_api_name VARCHAR2(255):='create_item_tag';
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:
55: l_subject VARCHAR2(2000);

Line 79: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

Line 84: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 89: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 95: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 175: IF FND_API.To_Boolean(p_commit) THEN

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

Line 188: WHEN FND_API.G_EXC_ERROR THEN

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

Line 190: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 207: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 260: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

Line 265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 270: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 276: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 316: IF FND_API.To_Boolean(p_commit) THEN

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

Line 328: WHEN FND_API.G_EXC_ERROR THEN

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

Line 330: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 347: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 396: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

Line 401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 406: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 412: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 448: IF FND_API.To_Boolean(p_commit) THEN

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

Line 460: WHEN FND_API.G_EXC_ERROR THEN

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

Line 462: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 479: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 524: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

Line 529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 534: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 540: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 561: IF FND_API.To_Boolean(p_commit) THEN

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

Line 573: WHEN FND_API.G_EXC_ERROR THEN

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

Line 575: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 582: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 592: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

625: l_api_name VARCHAR2(255):='insert_preproc_wrapper';
626: l_api_version_number NUMBER:=1.0;
627: l_seq_id NUMBER;
628:
629: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
630: l_msg_count NUMBER := 0;
631: l_msg_data VARCHAR2(2000);
632:
633: l_received_date DATE := sysdate;

Line 641: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

637: SAVEPOINT insert_preproc_wrapper_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:
661: --get next sequential number for msg_meta_id

Line 680: IF FND_API.To_Boolean(p_commit) THEN

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

Line 692: WHEN FND_API.G_EXC_ERROR THEN

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

Line 694: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 711: x_return_status := FND_API.G_RET_STS_ERROR;

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