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.IEX_WEBDIR_PKG dependencies on FND_API

Line 53: IF NOT FND_API.Compatible_API_Call (l_api_version,

49: -- Standard begin of API savepoint
50: SAVEPOINT Create_WebAssist_PVT;
51:
52: -- Standard call to check FOR call compatibility.
53: IF NOT FND_API.Compatible_API_Call (l_api_version,
54: p_api_version,
55: l_api_name,
56: G_PKG_NAME)
57: THEN

Line 58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

54: p_api_version,
55: l_api_name,
56: G_PKG_NAME)
57: THEN
58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60:
61: -- Check p_init_msg_list
62: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 62: IF FND_API.to_Boolean( p_init_msg_list ) THEN

58: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
59: END IF;
60:
61: -- Check p_init_msg_list
62: IF FND_API.to_Boolean( p_init_msg_list ) THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: -- Initialize API return status to success

Line 67: x_return_status := FND_API.G_RET_STS_SUCCESS;

63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: -- Initialize API return status to success
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: -- API body
70: IF p_web_assist_rec.web_assist_id IS NOT NULL
71: THEN

Line 282: IF FND_API.To_Boolean ( p_commit ) THEN

278: END IF;
279: END IF;
280:
281: -- Standard check of p_commit.
282: IF FND_API.To_Boolean ( p_commit ) THEN
283: COMMIT WORK;
284: END IF;
285:
286: -- Standard call to get message count AND IF count is 1, get message info.

Line 296: WHEN FND_API.G_EXC_ERROR THEN

292: -- Normal API Exception handling, IF exception occurs outside of phone processing loop
293: --
294: EXCEPTION
295:
296: WHEN FND_API.G_EXC_ERROR THEN
297: ROLLBACK TO Create_WebAssist_PVT;
298: x_return_status := FND_API.G_RET_STS_ERROR ;
299: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
300: p_data => x_msg_data );

Line 298: x_return_status := FND_API.G_RET_STS_ERROR ;

294: EXCEPTION
295:
296: WHEN FND_API.G_EXC_ERROR THEN
297: ROLLBACK TO Create_WebAssist_PVT;
298: x_return_status := FND_API.G_RET_STS_ERROR ;
299: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
300: p_data => x_msg_data );
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: ROLLBACK TO Create_WebAssist_PVT;

Line 301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

297: ROLLBACK TO Create_WebAssist_PVT;
298: x_return_status := FND_API.G_RET_STS_ERROR ;
299: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
300: p_data => x_msg_data );
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: ROLLBACK TO Create_WebAssist_PVT;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
304: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
305: p_data => x_msg_data );

Line 303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

299: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
300: p_data => x_msg_data );
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: ROLLBACK TO Create_WebAssist_PVT;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
304: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
305: p_data => x_msg_data );
306: WHEN OTHERS THEN
307: ROLLBACK TO Create_WebAssist_PVT;

Line 308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

304: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
305: p_data => x_msg_data );
306: WHEN OTHERS THEN
307: ROLLBACK TO Create_WebAssist_PVT;
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
309: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
310: THEN
311: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
312: END IF;

Line 347: IF NOT FND_API.Compatible_API_Call (l_api_version,

343: -- Standard begin of API savepoint
344: SAVEPOINT Lock_WebAssist_PVT;
345:
346: -- Standard call to check FOR call compatibility.
347: IF NOT FND_API.Compatible_API_Call (l_api_version,
348: p_api_version,
349: l_api_name,
350: G_PKG_NAME)
351: THEN

Line 352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

348: p_api_version,
349: l_api_name,
350: G_PKG_NAME)
351: THEN
352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: END IF;
354:
355: -- Check p_init_msg_list
356: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 356: IF FND_API.to_Boolean( p_init_msg_list ) THEN

352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
353: END IF;
354:
355: -- Check p_init_msg_list
356: IF FND_API.to_Boolean( p_init_msg_list ) THEN
357: FND_MSG_PUB.initialize;
358: END IF;
359:
360: -- Initialize API return status to success

Line 361: x_return_status := FND_API.G_RET_STS_SUCCESS;

357: FND_MSG_PUB.initialize;
358: END IF;
359:
360: -- Initialize API return status to success
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362:
363: -- API body
364: DECLARE
365: v_dummy char(1);

Line 404: IF FND_API.To_Boolean ( p_commit ) THEN

400:
401: -- ENDof API body
402:
403: -- Standard check of p_commit.
404: IF FND_API.To_Boolean ( p_commit ) THEN
405: COMMIT WORK;
406: END IF;
407:
408: -- Standard call to get message count AND IF count is 1, get message info.

Line 420: WHEN FND_API.G_EXC_ERROR THEN

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

Line 422: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

428: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
429: p_data => x_msg_data );
430: WHEN OTHERS THEN
431: ROLLBACK TO Lock_WebAssist_PVT;
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
433: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
434: THEN
435: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
436: END IF;

Line 469: IF NOT FND_API.Compatible_API_Call (l_api_version,

465: BEGIN
466: -- Standard begin of API savepoint
467: SAVEPOINT Update_WebAssist_PVT;
468: -- Standard call to check FOR call compatibility.
469: IF NOT FND_API.Compatible_API_Call (l_api_version,
470: p_api_version,
471: l_api_name,
472: G_PKG_NAME)
473: THEN

Line 474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

470: p_api_version,
471: l_api_name,
472: G_PKG_NAME)
473: THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476:
477: -- Check p_init_msg_list
478: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 478: IF FND_API.to_Boolean( p_init_msg_list ) THEN

474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476:
477: -- Check p_init_msg_list
478: IF FND_API.to_Boolean( p_init_msg_list ) THEN
479: FND_MSG_PUB.initialize;
480: END IF;
481:
482: -- Implementation of User Hooks

Line 491: x_return_status := FND_API.G_RET_STS_SUCCESS;

487: l_web_search_rec := p_web_search_rec;
488: l_query_string_rec := p_query_string_rec;
489:
490: -- Initialize API return status to success
491: x_return_status := FND_API.G_RET_STS_SUCCESS;
492:
493: -- API body
494: UPDATE IEX_WEB_assists
495: SET

Line 576: IF FND_API.To_Boolean ( p_commit ) THEN

572: attribute15 = p_query_string_rec.attribute15
573: WHERE query_string_id = p_query_string_rec.query_string_id;
574:
575: -- Standard check of p_commit.
576: IF FND_API.To_Boolean ( p_commit ) THEN
577: COMMIT WORK;
578: END IF;
579:
580: -- Standard call to get message count AND IF count is 1, get message info.

Line 590: WHEN FND_API.G_EXC_ERROR THEN

586: -- Normal API Exception handling, IF exception occurs outside of phone processing loop
587: --
588: EXCEPTION
589:
590: WHEN FND_API.G_EXC_ERROR THEN
591:
592: ROLLBACK TO Update_WebAssist_PVT;
593: x_return_status := FND_API.G_RET_STS_ERROR ;
594:

Line 593: x_return_status := FND_API.G_RET_STS_ERROR ;

589:
590: WHEN FND_API.G_EXC_ERROR THEN
591:
592: ROLLBACK TO Update_WebAssist_PVT;
593: x_return_status := FND_API.G_RET_STS_ERROR ;
594:
595: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
596: p_data => x_msg_data );
597:

Line 598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

594:
595: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
596: p_data => x_msg_data );
597:
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599:
600: ROLLBACK TO Update_WebAssist_PVT;
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
602:

Line 601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

597:
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599:
600: ROLLBACK TO Update_WebAssist_PVT;
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
602:
603: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
604: p_data => x_msg_data );
605:

Line 609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

605:
606: WHEN OTHERS THEN
607:
608: ROLLBACK TO Update_WebAssist_PVT;
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610:
611: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
612: THEN
613: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 650: IF NOT FND_API.Compatible_API_Call (l_api_version,

646: -- Standard begin of API savepoint
647: SAVEPOINT Delete_WebAssist_PVT;
648:
649: -- Standard call to check FOR call compatibility.
650: IF NOT FND_API.Compatible_API_Call (l_api_version,
651: p_api_version,
652: l_api_name,
653: G_PKG_NAME)
654: THEN

Line 655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

651: p_api_version,
652: l_api_name,
653: G_PKG_NAME)
654: THEN
655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: END IF;
657:
658: -- Check p_init_msg_list
659: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 659: IF FND_API.to_Boolean( p_init_msg_list ) THEN

655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: END IF;
657:
658: -- Check p_init_msg_list
659: IF FND_API.to_Boolean( p_init_msg_list ) THEN
660: FND_MSG_PUB.initialize;
661: END IF;
662:
663: -- Implementation of User Hooks

Line 672: x_return_status := FND_API.G_RET_STS_SUCCESS;

668: l_web_search_rec := p_web_search_rec;
669: l_query_string_rec := p_query_string_rec;
670:
671: -- Initialize API return status to success
672: x_return_status := FND_API.G_RET_STS_SUCCESS;
673:
674: -- API body
675: IF p_query_string_rec.query_string_id IS NOT NULL THEN
676: DELETE FROM ast_query_strings

Line 692: IF FND_API.To_Boolean ( p_commit ) THEN

688: END IF;
689:
690:
691: -- Standard check of p_commit.
692: IF FND_API.To_Boolean ( p_commit ) THEN
693: commit work;
694: END IF;
695: -- ENDof API body
696:

Line 707: WHEN FND_API.G_EXC_ERROR THEN

703: -- Normal API Exception handling, IF exception occurs outside of phone processing loop
704: --
705: EXCEPTION
706:
707: WHEN FND_API.G_EXC_ERROR THEN
708: ROLLBACK TO Delete_WebAssist_PVT;
709: x_return_status := FND_API.G_RET_STS_ERROR ;
710: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
711: p_data => x_msg_data );

Line 709: x_return_status := FND_API.G_RET_STS_ERROR ;

705: EXCEPTION
706:
707: WHEN FND_API.G_EXC_ERROR THEN
708: ROLLBACK TO Delete_WebAssist_PVT;
709: x_return_status := FND_API.G_RET_STS_ERROR ;
710: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
711: p_data => x_msg_data );
712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
713: ROLLBACK TO Delete_WebAssist_PVT;

Line 712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

708: ROLLBACK TO Delete_WebAssist_PVT;
709: x_return_status := FND_API.G_RET_STS_ERROR ;
710: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
711: p_data => x_msg_data );
712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
713: ROLLBACK TO Delete_WebAssist_PVT;
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
715: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
716: p_data => x_msg_data );

Line 714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

710: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
711: p_data => x_msg_data );
712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
713: ROLLBACK TO Delete_WebAssist_PVT;
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
715: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
716: p_data => x_msg_data );
717: WHEN OTHERS THEN
718: ROLLBACK TO Delete_WebAssist_PVT;

Line 719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

715: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
716: p_data => x_msg_data );
717: WHEN OTHERS THEN
718: ROLLBACK TO Delete_WebAssist_PVT;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
720: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
721: THEN
722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
723: END IF;