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

Line 183: RAISE FND_API.G_EXC_ERROR;

179: IF p_dss_grantee_type NOT IN ('GROUP','USER','GLOBAL') THEN
180: FND_MESSAGE.SET_NAME('FND','FND_GENERIC_MESSAGE');
181: FND_MESSAGE.SET_TOKEN('MESSAGE','Grantee type must be one of: GROUP, USER, GLOBAL');
182: FND_MSG_PUB.ADD;
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186: --
187: -- Translate the "DSS" Grantee information into appropriate value for FND

Line 213: RAISE FND_API.G_EXC_ERROR;

209: WHEN NO_DATA_FOUND THEN
210: FND_MESSAGE.SET_NAME('FND','FND_INVALID_USER');
211: FND_MESSAGE.SET_TOKEN('USER_NAME',p_dss_grantee_key);
212: FND_MSG_PUB.ADD;
213: RAISE FND_API.G_EXC_ERROR;
214: END;
215: ELSIF l_fnd_grantee_type = 'GROUP' THEN
216: -- validate against WF_ROLES
217: BEGIN

Line 230: RAISE FND_API.G_EXC_ERROR;

226: WHEN NO_DATA_FOUND THEN
227: FND_MESSAGE.SET_NAME('AR','HZ_DSS_INVALID_RESP');
228: FND_MESSAGE.SET_TOKEN('RESP',p_dss_grantee_key);
229: FND_MSG_PUB.ADD;
230: RAISE FND_API.G_EXC_ERROR;
231: END;
232:
233: END IF;
234: */

Line 260: IF l_fnd_success <> FND_API.G_TRUE THEN

256: x_success => l_fnd_success,
257: x_errorcode => l_fnd_errorcode
258: );
259:
260: IF l_fnd_success <> FND_API.G_TRUE THEN
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;
263:
264: --

Line 261: RAISE FND_API.G_EXC_ERROR;

257: x_errorcode => l_fnd_errorcode
258: );
259:
260: IF l_fnd_success <> FND_API.G_TRUE THEN
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;
263:
264: --
265: -- Replicate the same grant to any entities secured by this Data Sharing Group

Line 294: IF l_fnd_success <> FND_API.G_TRUE THEN

290: x_success => l_fnd_success,
291: x_errorcode => l_fnd_errorcode
292: );
293:
294: IF l_fnd_success <> FND_API.G_TRUE THEN
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297:
298: END LOOP;

Line 295: RAISE FND_API.G_EXC_ERROR;

291: x_errorcode => l_fnd_errorcode
292: );
293:
294: IF l_fnd_success <> FND_API.G_TRUE THEN
295: RAISE FND_API.G_EXC_ERROR;
296: END IF;
297:
298: END LOOP;
299:

Line 370: IF l_fnd_success <> FND_API.G_TRUE THEN

366: x_success => l_fnd_success,
367: x_errorcode => l_fnd_errorcode
368: );
369:
370: IF l_fnd_success <> FND_API.G_TRUE THEN
371: CLOSE c_fnd_grant;
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374: END LOOP;

Line 372: RAISE FND_API.G_EXC_ERROR;

368: );
369:
370: IF l_fnd_success <> FND_API.G_TRUE THEN
371: CLOSE c_fnd_grant;
372: RAISE FND_API.G_EXC_ERROR;
373: END IF;
374: END LOOP;
375: CLOSE c_fnd_grant;
376:

Line 433: FND_API.to_Boolean(p_init_msg_list)

429: BEGIN
430:
431: -- initialize message list if p_init_msg_list is set to TRUE.
432: IF p_init_msg_list IS NOT NULL AND
433: FND_API.to_Boolean(p_init_msg_list)
434: THEN
435: FND_MSG_PUB.initialize;
436: END IF;
437:

Line 439: x_return_status := FND_API.G_RET_STS_SUCCESS;

435: FND_MSG_PUB.initialize;
436: END IF;
437:
438: -- initialize API return status to success.
439: x_return_status := FND_API.G_RET_STS_SUCCESS;
440:
441: -- standard start of API savepoint
442: SAVEPOINT create_grant;
443:

Line 451: RAISE FND_API.G_EXC_ERROR;

447:
448: IF l_dsg_status IS NULL THEN
449: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
450: FND_MSG_PUB.ADD;
451: RAISE FND_API.G_EXC_ERROR;
452: END IF;
453:
454: IF l_dsg_status <> 'A' THEN
455: l_end_date := SYSDATE;

Line 504: p_encoded => FND_API.G_FALSE,

500: END IF;
501:
502: -- standard call to get message count and if count is 1, get message info.
503: FND_MSG_PUB.Count_And_Get(
504: p_encoded => FND_API.G_FALSE,
505: p_count => x_msg_count,
506: p_data => x_msg_data);
507:
508: EXCEPTION

Line 509: WHEN FND_API.G_EXC_ERROR THEN

505: p_count => x_msg_count,
506: p_data => x_msg_data);
507:
508: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: ROLLBACK TO create_grant ;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512:
513: FND_MSG_PUB.Count_And_Get(

Line 511: x_return_status := FND_API.G_RET_STS_ERROR;

507:
508: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: ROLLBACK TO create_grant ;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512:
513: FND_MSG_PUB.Count_And_Get(
514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,

Line 514: p_encoded => FND_API.G_FALSE,

510: ROLLBACK TO create_grant ;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512:
513: FND_MSG_PUB.Count_And_Get(
514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data);
517:
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

514: p_encoded => FND_API.G_FALSE,
515: p_count => x_msg_count,
516: p_data => x_msg_data);
517:
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519: ROLLBACK TO create_grant ;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521:
522: FND_MSG_PUB.Count_And_Get(

Line 520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

516: p_data => x_msg_data);
517:
518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
519: ROLLBACK TO create_grant ;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521:
522: FND_MSG_PUB.Count_And_Get(
523: p_encoded => FND_API.G_FALSE,
524: p_count => x_msg_count,

Line 523: p_encoded => FND_API.G_FALSE,

519: ROLLBACK TO create_grant ;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521:
522: FND_MSG_PUB.Count_And_Get(
523: p_encoded => FND_API.G_FALSE,
524: p_count => x_msg_count,
525: p_data => x_msg_data);
526:
527: WHEN OTHERS THEN

Line 529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

525: p_data => x_msg_data);
526:
527: WHEN OTHERS THEN
528: ROLLBACK TO create_grant ;
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530:
531: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
532: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
533: FND_MSG_PUB.ADD;

Line 536: p_encoded => FND_API.G_FALSE,

532: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
533: FND_MSG_PUB.ADD;
534:
535: FND_MSG_PUB.Count_And_Get(
536: p_encoded => FND_API.G_FALSE,
537: p_count => x_msg_count,
538: p_data => x_msg_data);
539:
540:

Line 606: FND_API.to_Boolean(p_init_msg_list)

602: BEGIN
603:
604: -- initialize message list if p_init_msg_list is set to TRUE.
605: IF p_init_msg_list IS NOT NULL AND
606: FND_API.to_Boolean(p_init_msg_list)
607: THEN
608: FND_MSG_PUB.initialize;
609: END IF;
610:

Line 612: x_return_status := FND_API.G_RET_STS_SUCCESS;

608: FND_MSG_PUB.initialize;
609: END IF;
610:
611: -- initialize API return status to success.
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613:
614: -- return when no grants exists for this dss group.
615: OPEN c_grant_exists;
616: FETCH c_grant_exists INTO l_dsg_status;

Line 634: RAISE FND_API.G_EXC_ERROR;

630: FETCH c_objects INTO l_obj_name;
631: CLOSE c_objects;
632:
633: IF l_obj_name IS NULL THEN
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;
636:
637: --
638: -- set the end date to null when the dss group and the secured

Line 688: IF l_fnd_success <> FND_API.G_TRUE THEN

684: x_success => l_fnd_success,
685: x_errorcode => l_fnd_errorcode
686: );
687:
688: IF l_fnd_success <> FND_API.G_TRUE THEN
689: RAISE FND_API.G_EXC_ERROR;
690: END IF;
691: END IF;
692:

Line 689: RAISE FND_API.G_EXC_ERROR;

685: x_errorcode => l_fnd_errorcode
686: );
687:
688: IF l_fnd_success <> FND_API.G_TRUE THEN
689: RAISE FND_API.G_EXC_ERROR;
690: END IF;
691: END IF;
692:
693: END LOOP;

Line 699: p_encoded => FND_API.G_FALSE,

695: END LOOP;
696:
697: -- standard call to get message count and if count is 1, get message info.
698: FND_MSG_PUB.Count_And_Get(
699: p_encoded => FND_API.G_FALSE,
700: p_count => x_msg_count,
701: p_data => x_msg_data);
702:
703: EXCEPTION

Line 704: WHEN FND_API.G_EXC_ERROR THEN

700: p_count => x_msg_count,
701: p_data => x_msg_data);
702:
703: EXCEPTION
704: WHEN FND_API.G_EXC_ERROR THEN
705: ROLLBACK TO create_grant ;
706: x_return_status := FND_API.G_RET_STS_ERROR;
707:
708: FND_MSG_PUB.Count_And_Get(

Line 706: x_return_status := FND_API.G_RET_STS_ERROR;

702:
703: EXCEPTION
704: WHEN FND_API.G_EXC_ERROR THEN
705: ROLLBACK TO create_grant ;
706: x_return_status := FND_API.G_RET_STS_ERROR;
707:
708: FND_MSG_PUB.Count_And_Get(
709: p_encoded => FND_API.G_FALSE,
710: p_count => x_msg_count,

Line 709: p_encoded => FND_API.G_FALSE,

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

Line 713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 718: p_encoded => FND_API.G_FALSE,

714: ROLLBACK TO create_grant ;
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716:
717: FND_MSG_PUB.Count_And_Get(
718: p_encoded => FND_API.G_FALSE,
719: p_count => x_msg_count,
720: p_data => x_msg_data);
721:
722: WHEN OTHERS THEN

Line 724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

720: p_data => x_msg_data);
721:
722: WHEN OTHERS THEN
723: ROLLBACK TO create_grant ;
724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
725:
726: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
727: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
728: FND_MSG_PUB.ADD;

Line 731: p_encoded => FND_API.G_FALSE,

727: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
728: FND_MSG_PUB.ADD;
729:
730: FND_MSG_PUB.Count_And_Get(
731: p_encoded => FND_API.G_FALSE,
732: p_count => x_msg_count,
733: p_data => x_msg_data);
734:
735: END create_grant;

Line 794: FND_API.to_Boolean(p_init_msg_list)

790: BEGIN
791:
792: -- initialize message list if p_init_msg_list is set to TRUE.
793: IF p_init_msg_list IS NOT NULL AND
794: FND_API.to_Boolean(p_init_msg_list)
795: THEN
796: FND_MSG_PUB.initialize;
797: END IF;
798:

Line 800: x_return_status := FND_API.G_RET_STS_SUCCESS;

796: FND_MSG_PUB.initialize;
797: END IF;
798:
799: -- initialize API return status to success.
800: x_return_status := FND_API.G_RET_STS_SUCCESS;
801:
802: -- standard start of API savepoint
803: SAVEPOINT update_grant;
804:

Line 940: p_encoded => FND_API.G_FALSE,

936: END IF;
937:
938: -- standard call to get message count and if count is 1, get message info.
939: FND_MSG_PUB.Count_And_Get(
940: p_encoded => FND_API.G_FALSE,
941: p_count => x_msg_count,
942: p_data => x_msg_data);
943:
944: EXCEPTION

Line 945: WHEN FND_API.G_EXC_ERROR THEN

941: p_count => x_msg_count,
942: p_data => x_msg_data);
943:
944: EXCEPTION
945: WHEN FND_API.G_EXC_ERROR THEN
946: ROLLBACK TO update_grant ;
947: x_return_status := FND_API.G_RET_STS_ERROR;
948:
949: FND_MSG_PUB.Count_And_Get(

Line 947: x_return_status := FND_API.G_RET_STS_ERROR;

943:
944: EXCEPTION
945: WHEN FND_API.G_EXC_ERROR THEN
946: ROLLBACK TO update_grant ;
947: x_return_status := FND_API.G_RET_STS_ERROR;
948:
949: FND_MSG_PUB.Count_And_Get(
950: p_encoded => FND_API.G_FALSE,
951: p_count => x_msg_count,

Line 950: p_encoded => FND_API.G_FALSE,

946: ROLLBACK TO update_grant ;
947: x_return_status := FND_API.G_RET_STS_ERROR;
948:
949: FND_MSG_PUB.Count_And_Get(
950: p_encoded => FND_API.G_FALSE,
951: p_count => x_msg_count,
952: p_data => x_msg_data);
953:
954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

950: p_encoded => FND_API.G_FALSE,
951: p_count => x_msg_count,
952: p_data => x_msg_data);
953:
954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
955: ROLLBACK TO update_grant ;
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957:
958: FND_MSG_PUB.Count_And_Get(

Line 956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

952: p_data => x_msg_data);
953:
954: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
955: ROLLBACK TO update_grant ;
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957:
958: FND_MSG_PUB.Count_And_Get(
959: p_encoded => FND_API.G_FALSE,
960: p_count => x_msg_count,

Line 959: p_encoded => FND_API.G_FALSE,

955: ROLLBACK TO update_grant ;
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957:
958: FND_MSG_PUB.Count_And_Get(
959: p_encoded => FND_API.G_FALSE,
960: p_count => x_msg_count,
961: p_data => x_msg_data);
962:
963: WHEN OTHERS THEN

Line 965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

961: p_data => x_msg_data);
962:
963: WHEN OTHERS THEN
964: ROLLBACK TO update_grant ;
965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
966:
967: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
969: FND_MSG_PUB.ADD;

Line 972: p_encoded => FND_API.G_FALSE,

968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
969: FND_MSG_PUB.ADD;
970:
971: FND_MSG_PUB.Count_And_Get(
972: p_encoded => FND_API.G_FALSE,
973: p_count => x_msg_count,
974: p_data => x_msg_data);
975:
976: END update_grant;

Line 1032: FND_API.to_Boolean(p_init_msg_list)

1028: BEGIN
1029:
1030: -- initialize message list if p_init_msg_list is set to TRUE.
1031: IF p_init_msg_list IS NOT NULL AND
1032: FND_API.to_Boolean(p_init_msg_list)
1033: THEN
1034: FND_MSG_PUB.initialize;
1035: END IF;
1036:

Line 1038: x_return_status := FND_API.G_RET_STS_SUCCESS;

1034: FND_MSG_PUB.initialize;
1035: END IF;
1036:
1037: -- initialize API return status to success.
1038: x_return_status := FND_API.G_RET_STS_SUCCESS;
1039:
1040: -- standard start of API savepoint
1041: SAVEPOINT update_grant;
1042:

Line 1073: IF l_fnd_success <> FND_API.G_TRUE THEN

1069: p_end_date => l_end_date,
1070: x_success => l_fnd_success
1071: );
1072:
1073: IF l_fnd_success <> FND_API.G_TRUE THEN
1074: CLOSE c_grants;
1075: RAISE FND_API.G_EXC_ERROR;
1076: END IF;
1077:

Line 1075: RAISE FND_API.G_EXC_ERROR;

1071: );
1072:
1073: IF l_fnd_success <> FND_API.G_TRUE THEN
1074: CLOSE c_grants;
1075: RAISE FND_API.G_EXC_ERROR;
1076: END IF;
1077:
1078: END LOOP;
1079: CLOSE c_grants;

Line 1083: p_encoded => FND_API.G_FALSE,

1079: CLOSE c_grants;
1080:
1081: -- standard call to get message count and if count is 1, get message info.
1082: FND_MSG_PUB.Count_And_Get(
1083: p_encoded => FND_API.G_FALSE,
1084: p_count => x_msg_count,
1085: p_data => x_msg_data);
1086:
1087: EXCEPTION

Line 1088: WHEN FND_API.G_EXC_ERROR THEN

1084: p_count => x_msg_count,
1085: p_data => x_msg_data);
1086:
1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: ROLLBACK TO update_grant ;
1090: x_return_status := FND_API.G_RET_STS_ERROR;
1091:
1092: FND_MSG_PUB.Count_And_Get(

Line 1090: x_return_status := FND_API.G_RET_STS_ERROR;

1086:
1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN
1089: ROLLBACK TO update_grant ;
1090: x_return_status := FND_API.G_RET_STS_ERROR;
1091:
1092: FND_MSG_PUB.Count_And_Get(
1093: p_encoded => FND_API.G_FALSE,
1094: p_count => x_msg_count,

Line 1093: p_encoded => FND_API.G_FALSE,

1089: ROLLBACK TO update_grant ;
1090: x_return_status := FND_API.G_RET_STS_ERROR;
1091:
1092: FND_MSG_PUB.Count_And_Get(
1093: p_encoded => FND_API.G_FALSE,
1094: p_count => x_msg_count,
1095: p_data => x_msg_data);
1096:
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1093: p_encoded => FND_API.G_FALSE,
1094: p_count => x_msg_count,
1095: p_data => x_msg_data);
1096:
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: ROLLBACK TO update_grant ;
1099:
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101: FND_MSG_PUB.Count_And_Get(

Line 1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1096:
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: ROLLBACK TO update_grant ;
1099:
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101: FND_MSG_PUB.Count_And_Get(
1102: p_encoded => FND_API.G_FALSE,
1103: p_count => x_msg_count,
1104: p_data => x_msg_data);

Line 1102: p_encoded => FND_API.G_FALSE,

1098: ROLLBACK TO update_grant ;
1099:
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101: FND_MSG_PUB.Count_And_Get(
1102: p_encoded => FND_API.G_FALSE,
1103: p_count => x_msg_count,
1104: p_data => x_msg_data);
1105:
1106: WHEN OTHERS THEN

Line 1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1104: p_data => x_msg_data);
1105:
1106: WHEN OTHERS THEN
1107: ROLLBACK TO update_grant ;
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109:
1110: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1112: FND_MSG_PUB.ADD;

Line 1115: p_encoded => FND_API.G_FALSE,

1111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1112: FND_MSG_PUB.ADD;
1113:
1114: FND_MSG_PUB.Count_And_Get(
1115: p_encoded => FND_API.G_FALSE,
1116: p_count => x_msg_count,
1117: p_data => x_msg_data);
1118:
1119: END update_grant;

Line 1176: FND_API.to_Boolean(p_init_msg_list)

1172: BEGIN
1173:
1174: -- initialize message list if p_init_msg_list is set to TRUE.
1175: IF p_init_msg_list IS NOT NULL AND
1176: FND_API.to_Boolean(p_init_msg_list)
1177: THEN
1178: FND_MSG_PUB.initialize;
1179: END IF;
1180:

Line 1182: x_return_status := FND_API.G_RET_STS_SUCCESS;

1178: FND_MSG_PUB.initialize;
1179: END IF;
1180:
1181: -- initialize API return status to success.
1182: x_return_status := FND_API.G_RET_STS_SUCCESS;
1183:
1184: -- standard start of API savepoint
1185: SAVEPOINT update_grant;
1186:

Line 1218: IF l_fnd_success <> FND_API.G_TRUE THEN

1214: p_end_date => l_end_date,
1215: x_success => l_fnd_success
1216: );
1217:
1218: IF l_fnd_success <> FND_API.G_TRUE THEN
1219: CLOSE c_grants;
1220: RAISE FND_API.G_EXC_ERROR;
1221: END IF;
1222:

Line 1220: RAISE FND_API.G_EXC_ERROR;

1216: );
1217:
1218: IF l_fnd_success <> FND_API.G_TRUE THEN
1219: CLOSE c_grants;
1220: RAISE FND_API.G_EXC_ERROR;
1221: END IF;
1222:
1223: END LOOP;
1224: CLOSE c_grants;

Line 1228: p_encoded => FND_API.G_FALSE,

1224: CLOSE c_grants;
1225:
1226: -- standard call to get message count and if count is 1, get message info.
1227: FND_MSG_PUB.Count_And_Get(
1228: p_encoded => FND_API.G_FALSE,
1229: p_count => x_msg_count,
1230: p_data => x_msg_data);
1231:
1232: EXCEPTION

Line 1233: WHEN FND_API.G_EXC_ERROR THEN

1229: p_count => x_msg_count,
1230: p_data => x_msg_data);
1231:
1232: EXCEPTION
1233: WHEN FND_API.G_EXC_ERROR THEN
1234: ROLLBACK TO update_grant ;
1235: x_return_status := FND_API.G_RET_STS_ERROR;
1236:
1237: FND_MSG_PUB.Count_And_Get(

Line 1235: x_return_status := FND_API.G_RET_STS_ERROR;

1231:
1232: EXCEPTION
1233: WHEN FND_API.G_EXC_ERROR THEN
1234: ROLLBACK TO update_grant ;
1235: x_return_status := FND_API.G_RET_STS_ERROR;
1236:
1237: FND_MSG_PUB.Count_And_Get(
1238: p_encoded => FND_API.G_FALSE,
1239: p_count => x_msg_count,

Line 1238: p_encoded => FND_API.G_FALSE,

1234: ROLLBACK TO update_grant ;
1235: x_return_status := FND_API.G_RET_STS_ERROR;
1236:
1237: FND_MSG_PUB.Count_And_Get(
1238: p_encoded => FND_API.G_FALSE,
1239: p_count => x_msg_count,
1240: p_data => x_msg_data);
1241:
1242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1238: p_encoded => FND_API.G_FALSE,
1239: p_count => x_msg_count,
1240: p_data => x_msg_data);
1241:
1242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1243: ROLLBACK TO update_grant ;
1244:
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: FND_MSG_PUB.Count_And_Get(

Line 1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1241:
1242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1243: ROLLBACK TO update_grant ;
1244:
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: FND_MSG_PUB.Count_And_Get(
1247: p_encoded => FND_API.G_FALSE,
1248: p_count => x_msg_count,
1249: p_data => x_msg_data);

Line 1247: p_encoded => FND_API.G_FALSE,

1243: ROLLBACK TO update_grant ;
1244:
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: FND_MSG_PUB.Count_And_Get(
1247: p_encoded => FND_API.G_FALSE,
1248: p_count => x_msg_count,
1249: p_data => x_msg_data);
1250:
1251: WHEN OTHERS THEN

Line 1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1249: p_data => x_msg_data);
1250:
1251: WHEN OTHERS THEN
1252: ROLLBACK TO update_grant ;
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254:
1255: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1256: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1257: FND_MSG_PUB.ADD;

Line 1260: p_encoded => FND_API.G_FALSE,

1256: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1257: FND_MSG_PUB.ADD;
1258:
1259: FND_MSG_PUB.Count_And_Get(
1260: p_encoded => FND_API.G_FALSE,
1261: p_count => x_msg_count,
1262: p_data => x_msg_data);
1263:
1264: END update_grant;

Line 1303: FND_API.to_Boolean(p_init_msg_list)

1299: BEGIN
1300:
1301: -- initialize message list if p_init_msg_list is set to TRUE.
1302: IF p_init_msg_list IS NOT NULL AND
1303: FND_API.to_Boolean(p_init_msg_list)
1304: THEN
1305: FND_MSG_PUB.initialize;
1306: END IF;
1307:

Line 1309: x_return_status := FND_API.G_RET_STS_SUCCESS;

1305: FND_MSG_PUB.initialize;
1306: END IF;
1307:
1308: -- initialize API return status to success and security answer to FALSE
1309: x_return_status := FND_API.G_RET_STS_SUCCESS;
1310: x_pass_fail_flag := FND_API.G_FALSE;
1311:
1312: --
1313: -- Validations

Line 1310: x_pass_fail_flag := FND_API.G_FALSE;

1306: END IF;
1307:
1308: -- initialize API return status to success and security answer to FALSE
1309: x_return_status := FND_API.G_RET_STS_SUCCESS;
1310: x_pass_fail_flag := FND_API.G_FALSE;
1311:
1312: --
1313: -- Validations
1314: --

Line 1325: RAISE FND_API.G_EXC_ERROR;

1321: 'MESSAGE','p_dss_admin_func_code must be one of: ' ||
1322: g_dss_admin_create ||', '|| g_dss_admin_update||', '||g_dss_admin_grant
1323: ); -- this is a developer error, not a user-facing error
1324: FND_MSG_PUB.ADD;
1325: RAISE FND_API.G_EXC_ERROR;
1326: END IF;
1327:
1328: --
1329: -- Check privilege

Line 1357: x_pass_fail_flag := FND_API.G_TRUE;

1353: AND rg.responsibility_application_id = 222
1354: AND (rg.end_date IS NULL OR rg.end_date > SYSDATE)
1355: AND (rg.start_date IS NULL OR rg.start_date < SYSDATE);
1356:
1357: x_pass_fail_flag := FND_API.G_TRUE;
1358:
1359: EXCEPTION
1360: WHEN NO_DATA_FOUND THEN
1361: NULL;

Line 1366: p_encoded => FND_API.G_FALSE,

1362: END;
1363:
1364: -- standard call to get message count and if count is 1, get message info.
1365: FND_MSG_PUB.Count_And_Get(
1366: p_encoded => FND_API.G_FALSE,
1367: p_count => x_msg_count,
1368: p_data => x_msg_data);
1369:
1370: EXCEPTION

Line 1371: WHEN FND_API.G_EXC_ERROR THEN

1367: p_count => x_msg_count,
1368: p_data => x_msg_data);
1369:
1370: EXCEPTION
1371: WHEN FND_API.G_EXC_ERROR THEN
1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373:
1374: FND_MSG_PUB.Count_And_Get(
1375: p_encoded => FND_API.G_FALSE,

Line 1372: x_return_status := FND_API.G_RET_STS_ERROR;

1368: p_data => x_msg_data);
1369:
1370: EXCEPTION
1371: WHEN FND_API.G_EXC_ERROR THEN
1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373:
1374: FND_MSG_PUB.Count_And_Get(
1375: p_encoded => FND_API.G_FALSE,
1376: p_count => x_msg_count,

Line 1375: p_encoded => FND_API.G_FALSE,

1371: WHEN FND_API.G_EXC_ERROR THEN
1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373:
1374: FND_MSG_PUB.Count_And_Get(
1375: p_encoded => FND_API.G_FALSE,
1376: p_count => x_msg_count,
1377: p_data => x_msg_data);
1378:
1379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1375: p_encoded => FND_API.G_FALSE,
1376: p_count => x_msg_count,
1377: p_data => x_msg_data);
1378:
1379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1381:
1382: FND_MSG_PUB.Count_And_Get(
1383: p_encoded => FND_API.G_FALSE,

Line 1380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1376: p_count => x_msg_count,
1377: p_data => x_msg_data);
1378:
1379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1381:
1382: FND_MSG_PUB.Count_And_Get(
1383: p_encoded => FND_API.G_FALSE,
1384: p_count => x_msg_count,

Line 1383: p_encoded => FND_API.G_FALSE,

1379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1381:
1382: FND_MSG_PUB.Count_And_Get(
1383: p_encoded => FND_API.G_FALSE,
1384: p_count => x_msg_count,
1385: p_data => x_msg_data);
1386:
1387: WHEN OTHERS THEN

Line 1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1384: p_count => x_msg_count,
1385: p_data => x_msg_data);
1386:
1387: WHEN OTHERS THEN
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1389:
1390: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1392: FND_MSG_PUB.ADD;

Line 1394: p_encoded => FND_API.G_FALSE,

1390: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
1391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1392: FND_MSG_PUB.ADD;
1393: FND_MSG_PUB.Count_And_Get(
1394: p_encoded => FND_API.G_FALSE,
1395: p_count => x_msg_count,
1396: p_data => x_msg_data);
1397: END check_admin_priv;
1398:

Line 1436: p_init_msg_list => FND_API.G_TRUE,

1432: --
1433: -- Call the PL/SQL version
1434: --
1435: check_admin_priv (
1436: p_init_msg_list => FND_API.G_TRUE,
1437: p_dss_group_code => p_dss_group_code,
1438: p_dss_admin_func_code => p_dss_admin_func_code,
1439: x_pass_fail_flag => l_pass_fail_flag,
1440: x_return_status => l_return_status,

Line 1450: RETURN FND_API.G_FALSE;

1446: RETURN l_pass_fail_flag;
1447:
1448: EXCEPTION
1449: WHEN OTHERS THEN
1450: RETURN FND_API.G_FALSE;
1451:
1452: END check_admin_priv;
1453:
1454: END HZ_DSS_GRANTS_PUB;