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

Line 116: IF NOT FND_API.Compatible_API_Call(

112: l_module,'begin');
113: END IF;
114:
115: --Standard call to check for call compatibility.
116: IF NOT FND_API.Compatible_API_Call(
117: l_api_version,
118: p_api_version,
119: l_api_name,
120: G_PKG_NAME)

Line 122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

118: p_api_version,
119: l_api_name,
120: G_PKG_NAME)
121: THEN
122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
123: END IF;
124:
125: SAVEPOINT create_fun_grant;
126:

Line 129: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN

125: SAVEPOINT create_fun_grant;
126:
127:
128: -- initialize message list if p_init_msg_list is set to TRUE.
129: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
130: FND_MSG_PUB.initialize;
131: END IF;
132:
133:

Line 135: x_return_status := FND_API.G_RET_STS_SUCCESS;

131: END IF;
132:
133:
134: -- initialize API return status to success.
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136:
137:
138: IF nvl(p_enabled_flag,'Y')='N' THEN
139: l_end_date := SYSDATE-1;

Line 165: nvl(p_init_msg_list, FND_API.G_FALSE),

161: -- Grant has been disabled
162: -- Need to update grant
163: update_assign(
164: p_api_version,
165: nvl(p_init_msg_list, FND_API.G_FALSE),
166: p_commit,
167: x_return_status,
168: x_msg_count,
169: x_msg_data,

Line 237: p_init_msg_list => nvl(p_init_msg_list, FND_API.G_FALSE),

233: l_module,'calling HZ_PARTY_CONTACT_V2PUB.update_org_contact');
234: END IF;
235:
236: HZ_PARTY_CONTACT_V2PUB.update_org_contact(
237: p_init_msg_list => nvl(p_init_msg_list, FND_API.G_FALSE),
238: p_org_contact_rec => l_tca_contact_record,
239: p_cont_object_version_number => l_cont_object_version_number,
240: p_rel_object_version_number => l_rel_object_version_number,
241: p_party_object_version_number => l_party_object_version_number,

Line 257: RAISE FND_API.G_EXC_ERROR;

253: END IF;
254:
255: IF x_return_status <> 'S'
256: THEN
257: RAISE FND_API.G_EXC_ERROR;
258: END IF;
259:
260: SELECT hcr.org_contact_role_id, hcr.org_contact_id, hcr.primary_flag, hcr.status
261: INTO l_org_contact_role_id, l_org_contact_id, l_primary_flag, l_status

Line 286: p_init_msg_list => nvl(p_init_msg_list, FND_API.G_FALSE),

282: l_module,'calling HZ_PARTY_CONTACT_V2PUB.update_org_contact_role');
283: END IF;
284:
285: HZ_PARTY_CONTACT_V2PUB.update_org_contact_role(
286: p_init_msg_list => nvl(p_init_msg_list, FND_API.G_FALSE),
287: p_org_contact_role_rec => l_tca_contact_role_record,
288: p_object_version_number => l_object_version_number,
289: x_return_status => x_return_status,
290: x_msg_count => x_msg_count,

Line 304: RAISE FND_API.G_EXC_ERROR;

300: END IF;
301:
302: IF x_return_status <> 'S'
303: THEN
304: RAISE FND_API.G_EXC_ERROR;
305: END IF;
306:
307: END;
308: END IF; -- is_access_valid = 'N'

Line 342: RAISE FND_API.G_EXC_ERROR;

338: END IF;
339:
340: IF x_return_status <> 'T'
341: THEN
342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344:
345: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
346: THEN

Line 375: RAISE FND_API.G_EXC_ERROR;

371: END IF;
372:
373: IF x_return_status <> 'T'
374: THEN
375: RAISE FND_API.G_EXC_ERROR;
376: END IF;
377:
378: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
379: THEN

Line 409: RAISE FND_API.G_EXC_ERROR;

405: END IF;
406:
407: IF x_return_status <> 'T'
408: THEN
409: RAISE FND_API.G_EXC_ERROR;
410: END IF;
411:
412: --Creating the TCA relationship between the person and the organization
413: -- with the check for if TCA relationship reqd

Line 461: p_init_msg_list => nvl(p_init_msg_list, FND_API.G_FALSE),

457: l_module,'calling HZ_PARTY_CONTACT_V2PUB.create_org_contact');
458: END IF;
459:
460: HZ_PARTY_CONTACT_V2PUB.create_org_contact(
461: p_init_msg_list => nvl(p_init_msg_list, FND_API.G_FALSE),
462: p_org_contact_rec => l_tca_contact_record,
463: x_org_contact_id => l_org_contact_id,
464: x_party_rel_id => l_party_rel_id,
465: x_party_id => l_party_id,

Line 482: RAISE FND_API.G_EXC_ERROR;

478: END IF;
479:
480: IF x_return_status <> 'S'
481: THEN
482: RAISE FND_API.G_EXC_ERROR;
483: END IF;
484:
485: l_tca_contact_role_record.role_type := 'INTERCOMPANY_CONTACT_FOR';
486: l_tca_contact_role_record.status := 'A';

Line 497: p_init_msg_list => nvl(p_init_msg_list, FND_API.G_FALSE),

493: l_module,'calling HZ_PARTY_CONTACT_V2PUB.create_org_contact_role');
494: END IF;
495:
496: HZ_PARTY_CONTACT_V2PUB.create_org_contact_role(
497: p_init_msg_list => nvl(p_init_msg_list, FND_API.G_FALSE),
498: p_org_contact_role_rec => l_tca_contact_role_record,
499: x_org_contact_role_id => l_org_contact_role_id,
500: x_return_status => x_return_status,
501: x_msg_count => x_msg_count,

Line 515: RAISE FND_API.G_EXC_ERROR;

511: END IF;
512:
513: IF x_return_status <> 'S'
514: THEN
515: RAISE FND_API.G_EXC_ERROR;
516: END IF;
517:
518:
519: END;

Line 526: RAISE FND_API.G_EXC_ERROR;

522: END IF; -- is local
523: END LOOP;
524: ELSIF p_create_all = 'N' THEN
525: IF p_org_id IS NULL THEN
526: RAISE FND_API.G_EXC_ERROR;
527: ELSE
528: IF (is_access_allow(
529: p_person_id,
530: p_org_id) = 'Y') THEN

Line 538: nvl(p_init_msg_list, FND_API.G_FALSE),

534: -- Grant has been disabled
535: -- Need to update grant
536: update_assign(
537: p_api_version,
538: nvl(p_init_msg_list, FND_API.G_FALSE),
539: p_commit,
540: x_return_status,
541: x_msg_count,
542: x_msg_data,

Line 579: RAISE FND_API.G_EXC_ERROR;

575: END IF;
576:
577: IF x_return_status <> 'T'
578: THEN
579: RAISE FND_API.G_EXC_ERROR;
580: END IF;
581:
582: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
583: THEN

Line 614: RAISE FND_API.G_EXC_ERROR;

610: END IF;
611:
612: IF x_return_status <> 'T'
613: THEN
614: RAISE FND_API.G_EXC_ERROR;
615: END IF;
616:
617: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)
618: THEN

Line 649: RAISE FND_API.G_EXC_ERROR;

645: END IF;
646:
647: IF x_return_status <> 'T'
648: THEN
649: RAISE FND_API.G_EXC_ERROR;
650: END IF;
651:
652: --Creating the TCA relationship between the person and the organization
653: -- with the check for if TCA relationship reqd

Line 704: p_init_msg_list => nvl(p_init_msg_list, FND_API.G_FALSE),

700: l_module,'calling HZ_PARTY_CONTACT_V2PUB.create_org_contact');
701: END IF;
702:
703: HZ_PARTY_CONTACT_V2PUB.create_org_contact(
704: p_init_msg_list => nvl(p_init_msg_list, FND_API.G_FALSE),
705: p_org_contact_rec => l_tca_contact_record,
706: x_org_contact_id => l_org_contact_id,
707: x_party_rel_id => l_party_rel_id,
708: x_party_id => l_party_id,

Line 725: RAISE FND_API.G_EXC_ERROR;

721: END IF;
722:
723: IF x_return_status <> 'S'
724: THEN
725: RAISE FND_API.G_EXC_ERROR;
726: END IF;
727:
728: l_tca_contact_role_record.role_type := 'INTERCOMPANY_CONTACT_FOR';
729: l_tca_contact_role_record.status := 'A';

Line 741: p_init_msg_list => nvl(p_init_msg_list, FND_API.G_FALSE),

737: END IF;
738:
739:
740: HZ_PARTY_CONTACT_V2PUB.create_org_contact_role(
741: p_init_msg_list => nvl(p_init_msg_list, FND_API.G_FALSE),
742: p_org_contact_role_rec => l_tca_contact_role_record,
743: x_org_contact_role_id => l_org_contact_role_id,
744: x_return_status => x_return_status,
745: x_msg_count => x_msg_count,

Line 758: RAISE FND_API.G_EXC_ERROR;

754: END IF;
755:
756: IF x_return_status <> 'S'
757: THEN
758: RAISE FND_API.G_EXC_ERROR;
759: END IF;
760:
761:
762: END;

Line 769: IF FND_API.To_Boolean( p_commit )

765: END IF;-- p_org_id IS NULL
766:
767: END IF; --p_create_all='n'
768:
769: IF FND_API.To_Boolean( p_commit )
770: THEN
771: COMMIT WORK;
772: END IF;
773:

Line 782: p_encoded => FND_API.G_FALSE,

778: END IF;
779:
780: -- standard call to get message count and if count is 1, get message info.
781: FND_MSG_PUB.Count_And_Get(
782: p_encoded => FND_API.G_FALSE,
783: p_count => x_msg_count,
784: p_data => x_msg_data);
785:
786: EXCEPTION

Line 787: WHEN FND_API.G_EXC_ERROR THEN

783: p_count => x_msg_count,
784: p_data => x_msg_data);
785:
786: EXCEPTION
787: WHEN FND_API.G_EXC_ERROR THEN
788: ROLLBACK TO create_fun_grant;
789: x_return_status := FND_API.G_RET_STS_ERROR;
790: FND_MSG_PUB.Count_And_Get(
791: p_encoded => FND_API.G_FALSE,

Line 789: x_return_status := FND_API.G_RET_STS_ERROR;

785:
786: EXCEPTION
787: WHEN FND_API.G_EXC_ERROR THEN
788: ROLLBACK TO create_fun_grant;
789: x_return_status := FND_API.G_RET_STS_ERROR;
790: FND_MSG_PUB.Count_And_Get(
791: p_encoded => FND_API.G_FALSE,
792: p_count => x_msg_count,
793: p_data => x_msg_data);

Line 791: p_encoded => FND_API.G_FALSE,

787: WHEN FND_API.G_EXC_ERROR THEN
788: ROLLBACK TO create_fun_grant;
789: x_return_status := FND_API.G_RET_STS_ERROR;
790: FND_MSG_PUB.Count_And_Get(
791: p_encoded => FND_API.G_FALSE,
792: p_count => x_msg_count,
793: p_data => x_msg_data);
794:
795: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

Line 801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

797: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
798: l_module,'Execution exception raised');
799: END IF;
800:
801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
802: ROLLBACK TO create_fun_grant;
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: FND_MSG_PUB.Count_And_Get(
805: p_encoded => FND_API.G_FALSE,

Line 803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

799: END IF;
800:
801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
802: ROLLBACK TO create_fun_grant;
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: FND_MSG_PUB.Count_And_Get(
805: p_encoded => FND_API.G_FALSE,
806: p_count => x_msg_count,
807: p_data => x_msg_data);

Line 805: p_encoded => FND_API.G_FALSE,

801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
802: ROLLBACK TO create_fun_grant;
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: FND_MSG_PUB.Count_And_Get(
805: p_encoded => FND_API.G_FALSE,
806: p_count => x_msg_count,
807: p_data => x_msg_data);
808:
809: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)

Line 817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

813: END IF;
814:
815: WHEN OTHERS THEN
816: ROLLBACK TO create_fun_grant;
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818: FND_MSG_PUB.Count_And_Get(
819: p_encoded => FND_API.G_FALSE,
820: p_count => x_msg_count,
821: p_data => x_msg_data);

Line 819: p_encoded => FND_API.G_FALSE,

815: WHEN OTHERS THEN
816: ROLLBACK TO create_fun_grant;
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818: FND_MSG_PUB.Count_And_Get(
819: p_encoded => FND_API.G_FALSE,
820: p_count => x_msg_count,
821: p_data => x_msg_data);
822:
823: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)

Line 886: IF NOT FND_API.Compatible_API_Call(

882: l_module,'begin');
883: END IF;
884:
885: --Standard call to check for call compatibility.
886: IF NOT FND_API.Compatible_API_Call(
887: l_api_version,
888: p_api_version,
889: l_api_name,
890: G_PKG_NAME)

Line 892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

888: p_api_version,
889: l_api_name,
890: G_PKG_NAME)
891: THEN
892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: END IF;
894:
895: SAVEPOINT update_fun_grant;
896: --initialize message list if p_init_msg_list is set to TRUE.

Line 898: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN

894:
895: SAVEPOINT update_fun_grant;
896: --initialize message list if p_init_msg_list is set to TRUE.
897:
898: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
899: FND_MSG_PUB.initialize;
900: END IF;
901:
902:

Line 904: x_return_status := FND_API.G_RET_STS_SUCCESS;

900: END IF;
901:
902:
903: -- initialize API return status to success.
904: x_return_status := FND_API.G_RET_STS_SUCCESS;
905:
906: l_menu_name := 'FUN_DATA_ACCESS' ;
907:
908: get_instance_set_ids(

Line 920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

916: p_org_id,
917: l_instance_set_batches);
918:
919: IF c_grant_info%NOTFOUND THEN
920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: END IF;
922:
923: FETCH c_grant_info INTO l_grant_guid,l_start_date ;
924: CLOSE c_grant_info ;

Line 959: RAISE FND_API.G_EXC_ERROR;

955: END IF;
956:
957: IF x_return_status <> 'T'
958: THEN
959: RAISE FND_API.G_EXC_ERROR;
960: END IF;
961:
962: OPEN c_grant_info(
963: p_person_id,

Line 1002: RAISE FND_API.G_EXC_ERROR;

998: END IF;
999:
1000: IF x_return_status <> 'T'
1001: THEN
1002: RAISE FND_API.G_EXC_ERROR;
1003: END IF;
1004:
1005: OPEN c_grant_info(
1006: p_person_id,

Line 1045: RAISE FND_API.G_EXC_ERROR;

1041: END IF;
1042:
1043: IF x_return_status <> 'T'
1044: THEN
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;
1047:
1048: IF FND_API.To_Boolean( p_commit )
1049: THEN

Line 1048: IF FND_API.To_Boolean( p_commit )

1044: THEN
1045: RAISE FND_API.G_EXC_ERROR;
1046: END IF;
1047:
1048: IF FND_API.To_Boolean( p_commit )
1049: THEN
1050: COMMIT WORK;
1051: END IF;
1052:

Line 1055: p_encoded => FND_API.G_FALSE,

1051: END IF;
1052:
1053: -- standard call to get message count and if count is 1, get message info.
1054: FND_MSG_PUB.Count_And_Get(
1055: p_encoded => FND_API.G_FALSE,
1056: p_count => x_msg_count,
1057: p_data => x_msg_data);
1058:
1059: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

Line 1066: WHEN FND_API.G_EXC_ERROR THEN

1062: l_module,'end');
1063: END IF;
1064:
1065: EXCEPTION
1066: WHEN FND_API.G_EXC_ERROR THEN
1067: ROLLBACK TO update_fun_grant;
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: FND_MSG_PUB.Count_And_Get(
1070: p_encoded => FND_API.G_FALSE,

Line 1068: x_return_status := FND_API.G_RET_STS_ERROR;

1064:
1065: EXCEPTION
1066: WHEN FND_API.G_EXC_ERROR THEN
1067: ROLLBACK TO update_fun_grant;
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: FND_MSG_PUB.Count_And_Get(
1070: p_encoded => FND_API.G_FALSE,
1071: p_count => x_msg_count,
1072: p_data => x_msg_data);

Line 1070: p_encoded => FND_API.G_FALSE,

1066: WHEN FND_API.G_EXC_ERROR THEN
1067: ROLLBACK TO update_fun_grant;
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: FND_MSG_PUB.Count_And_Get(
1070: p_encoded => FND_API.G_FALSE,
1071: p_count => x_msg_count,
1072: p_data => x_msg_data);
1073:
1074: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_level)

Line 1080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1076: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1077: l_module,'Execution exception raised');
1078: END IF;
1079:
1080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1081: ROLLBACK TO update_fun_grant;
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1083: FND_MSG_PUB.Count_And_Get(
1084: p_encoded => FND_API.G_FALSE,

Line 1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1078: END IF;
1079:
1080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1081: ROLLBACK TO update_fun_grant;
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1083: FND_MSG_PUB.Count_And_Get(
1084: p_encoded => FND_API.G_FALSE,
1085: p_count => x_msg_count,
1086: p_data => x_msg_data);

Line 1084: p_encoded => FND_API.G_FALSE,

1080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1081: ROLLBACK TO update_fun_grant;
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1083: FND_MSG_PUB.Count_And_Get(
1084: p_encoded => FND_API.G_FALSE,
1085: p_count => x_msg_count,
1086: p_data => x_msg_data);
1087:
1088: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)

Line 1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1092: END IF;
1093:
1094: WHEN OTHERS THEN
1095: ROLLBACK TO update_fun_grant;
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1097: FND_MSG_PUB.Count_And_Get(
1098: p_encoded => FND_API.G_FALSE,
1099: p_count => x_msg_count,
1100: p_data => x_msg_data);

Line 1098: p_encoded => FND_API.G_FALSE,

1094: WHEN OTHERS THEN
1095: ROLLBACK TO update_fun_grant;
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1097: FND_MSG_PUB.Count_And_Get(
1098: p_encoded => FND_API.G_FALSE,
1099: p_count => x_msg_count,
1100: p_data => x_msg_data);
1101:
1102: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level)