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

Line 7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

3:
4:
5: PROCEDURE Insert_Relation
6: ( p_api_version_number IN NUMBER ,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
8: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
11: p_return_status OUT VARCHAR2 ,

Line 8: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,

4:
5: PROCEDURE Insert_Relation
6: ( p_api_version_number IN NUMBER ,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
8: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
11: p_return_status OUT VARCHAR2 ,
12: p_msg_count OUT NUMBER ,

Line 9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

5: PROCEDURE Insert_Relation
6: ( p_api_version_number IN NUMBER ,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
8: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
11: p_return_status OUT VARCHAR2 ,
12: p_msg_count OUT NUMBER ,
13: p_msg_data OUT VARCHAR2 ,

Line 10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

6: ( p_api_version_number IN NUMBER ,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
8: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
11: p_return_status OUT VARCHAR2 ,
12: p_msg_count OUT NUMBER ,
13: p_msg_data OUT VARCHAR2 ,
14: p_category_set_id IN NUMBER DEFAULT NULL ,

Line 64: IF NOT FND_API.Compatible_API_Call(l_api_version_number,

60:
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: 'Insert_Relation',
67: G_PKG_NAME)
68: THEN

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

65: p_api_version_number,
66: 'Insert_Relation',
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 75: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 81: p_return_status := FND_API.G_RET_STS_SUCCESS;

77: END IF;
78:
79:
80: -- Initialize p_return_status
81: p_return_status := FND_API.G_RET_STS_SUCCESS;
82:
83:
84: -- Get prompts table for translation of messages
85: icx_util.getPrompts(601,'ICX_RELATED_CATEGORIES_R',l_title,l_prompts);

Line 103: RAISE FND_API.G_EXC_ERROR;

99: -- add message: Required API parameters are missing
100: FND_MESSAGE.SET_NAME('ICX','ICX_API_MISS_PARAM');
101: FND_MSG_PUB.Add;
102: end if;
103: RAISE FND_API.G_EXC_ERROR;
104: end if;
105:
106:
107:

Line 184: RAISE FND_API.G_EXC_ERROR;

180:
181:
182: -- If any id resolution failed, raise error
183: IF l_id_resolve_error THEN
184: RAISE FND_API.G_EXC_ERROR;
185: END IF;
186:
187:
188:

Line 190: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN

186:
187:
188:
189: -- Perform validation
190: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN
191:
192: -- check category set id if it was not looked up previously
193: if p_category_set_id is not null then
194: select count(*) into l_count

Line 342: RAISE FND_API.G_EXC_ERROR;

338:
339:
340: -- If any validation failed, raise error
341: IF l_validation_error THEN
342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344:
345:
346:

Line 374: IF FND_API.To_Boolean(p_simulate) THEN

370:
371:
372: -- Standard check of p_simulate and p_commit parameter
373:
374: IF FND_API.To_Boolean(p_simulate) THEN
375:
376: ROLLBACK TO Insert_Relation_PUB;
377:
378: ELSIF FND_API.To_Boolean(p_commit) THEN

Line 378: ELSIF FND_API.To_Boolean(p_commit) THEN

374: IF FND_API.To_Boolean(p_simulate) THEN
375:
376: ROLLBACK TO Insert_Relation_PUB;
377:
378: ELSIF FND_API.To_Boolean(p_commit) THEN
379:
380: COMMIT WORK;
381:
382: END IF;

Line 395: WHEN FND_API.G_EXC_ERROR THEN

391:
392:
393: EXCEPTION
394:
395: WHEN FND_API.G_EXC_ERROR THEN
396:
397: p_return_status := FND_API.G_RET_STS_ERROR;
398:
399: -- Get message count and if 1, return message data

Line 397: p_return_status := FND_API.G_RET_STS_ERROR;

393: EXCEPTION
394:
395: WHEN FND_API.G_EXC_ERROR THEN
396:
397: p_return_status := FND_API.G_RET_STS_ERROR;
398:
399: -- Get message count and if 1, return message data
400:
401: FND_MSG_PUB.Count_And_Get

Line 406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

402: (p_count => p_msg_count,
403: p_data => p_msg_data
404: );
405:
406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
407:
408: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
409:
410: -- Get message count and if 1, return message data

Line 408: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

404: );
405:
406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
407:
408: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
409:
410: -- Get message count and if 1, return message data
411:
412: FND_MSG_PUB.Count_And_Get

Line 419: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

415: );
416:
417: WHEN OTHERS THEN
418:
419: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
420:
421: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
422: FND_MSG_PUB.Build_Exc_Msg
423: ( G_PKG_NAME ,

Line 443: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

439:
440:
441: PROCEDURE Delete_Relation
442: ( p_api_version_number IN NUMBER ,
443: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
444: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
445: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
446: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
447: p_return_status OUT VARCHAR2 ,

Line 444: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,

440:
441: PROCEDURE Delete_Relation
442: ( p_api_version_number IN NUMBER ,
443: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
444: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
445: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
446: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
447: p_return_status OUT VARCHAR2 ,
448: p_msg_count OUT NUMBER ,

Line 445: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

441: PROCEDURE Delete_Relation
442: ( p_api_version_number IN NUMBER ,
443: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
444: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
445: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
446: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
447: p_return_status OUT VARCHAR2 ,
448: p_msg_count OUT NUMBER ,
449: p_msg_data OUT VARCHAR2 ,

Line 446: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

442: ( p_api_version_number IN NUMBER ,
443: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
444: p_simulate IN VARCHAR2 := FND_API.G_FALSE ,
445: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
446: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
447: p_return_status OUT VARCHAR2 ,
448: p_msg_count OUT NUMBER ,
449: p_msg_data OUT VARCHAR2 ,
450: p_category_set_id IN NUMBER DEFAULT NULL ,

Line 497: IF NOT FND_API.Compatible_API_Call(l_api_version_number,

493:
494:
495: -- Standard call to check for call compatibility
496:
497: IF NOT FND_API.Compatible_API_Call(l_api_version_number,
498: p_api_version_number,
499: 'Delete Relation',
500: G_PKG_NAME)
501: THEN

Line 502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

498: p_api_version_number,
499: 'Delete Relation',
500: G_PKG_NAME)
501: THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504:
505:
506: -- Initialize message list if p_init_msg_list is set to TRUE

Line 508: IF FND_API.to_Boolean(p_init_msg_list) THEN

504:
505:
506: -- Initialize message list if p_init_msg_list is set to TRUE
507:
508: IF FND_API.to_Boolean(p_init_msg_list) THEN
509: FND_MSG_PUB.initialize;
510: END IF;
511:
512:

Line 515: p_return_status := FND_API.G_RET_STS_SUCCESS;

511:
512:
513: -- Initialize p_return_status
514:
515: p_return_status := FND_API.G_RET_STS_SUCCESS;
516:
517:
518: -- Get prompts table for translation of messages
519:

Line 538: RAISE FND_API.G_EXC_ERROR;

534: -- add message: Required API parameters are missing
535: FND_MESSAGE.SET_NAME('ICX','ICX_API_MISS_PARAM');
536: FND_MSG_PUB.Add;
537: end if;
538: RAISE FND_API.G_EXC_ERROR;
539: end if;
540:
541:
542:

Line 619: RAISE FND_API.G_EXC_ERROR;

615:
616:
617: -- If any id resolution failed, raise error
618: IF l_id_resolve_error THEN
619: RAISE FND_API.G_EXC_ERROR;
620: END IF;
621:
622:
623:

Line 637: IF FND_API.To_Boolean(p_simulate) THEN

633:
634:
635: -- Standard check of p_simulate and p_commit parameter
636:
637: IF FND_API.To_Boolean(p_simulate) THEN
638:
639: ROLLBACK TO Insert_Relation_PUB;
640:
641: ELSIF FND_API.To_Boolean(p_commit) THEN

Line 641: ELSIF FND_API.To_Boolean(p_commit) THEN

637: IF FND_API.To_Boolean(p_simulate) THEN
638:
639: ROLLBACK TO Insert_Relation_PUB;
640:
641: ELSIF FND_API.To_Boolean(p_commit) THEN
642:
643: COMMIT WORK;
644:
645: END IF;

Line 660: p_return_status := FND_API.G_RET_STS_ERROR;

656: EXCEPTION
657:
658: WHEN NO_DATA_FOUND THEN
659:
660: p_return_status := FND_API.G_RET_STS_ERROR;
661:
662: if FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) then
663: -- add message: Relation to delete does not exist
664: FND_MESSAGE.SET_NAME('ICX','ICX_CAT_DELETE');

Line 675: WHEN FND_API.G_EXC_ERROR THEN

671: (p_count => p_msg_count,
672: p_data => p_msg_data
673: );
674:
675: WHEN FND_API.G_EXC_ERROR THEN
676:
677: p_return_status := FND_API.G_RET_STS_ERROR;
678:
679: -- Get message count and if 1, return message data

Line 677: p_return_status := FND_API.G_RET_STS_ERROR;

673: );
674:
675: WHEN FND_API.G_EXC_ERROR THEN
676:
677: p_return_status := FND_API.G_RET_STS_ERROR;
678:
679: -- Get message count and if 1, return message data
680:
681: FND_MSG_PUB.Count_And_Get

Line 686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

682: (p_count => p_msg_count,
683: p_data => p_msg_data
684: );
685:
686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
687:
688: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
689:
690: -- Get message count and if 1, return message data

Line 688: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

684: );
685:
686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
687:
688: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
689:
690: -- Get message count and if 1, return message data
691:
692: FND_MSG_PUB.Count_And_Get

Line 699: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

695: );
696:
697: WHEN OTHERS THEN
698:
699: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
700:
701: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
702: FND_MSG_PUB.Build_Exc_Msg
703: ( G_PKG_NAME ,