DBA Data[Home] [Help]

APPS.HZ_DSS_GRANTS_PUB dependencies on FND_MSG_PUB

Line 182: FND_MSG_PUB.ADD;

178:
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: --

Line 212: FND_MSG_PUB.ADD;

208: EXCEPTION
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

Line 229: FND_MSG_PUB.ADD;

225: EXCEPTION
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;

Line 435: FND_MSG_PUB.initialize;

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:
438: -- initialize API return status to success.
439: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 450: FND_MSG_PUB.ADD;

446: CLOSE c_dss_groups;
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

Line 503: FND_MSG_PUB.Count_And_Get(

499: );
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:

Line 513: FND_MSG_PUB.Count_And_Get(

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,
516: p_data => x_msg_data);
517:

Line 522: FND_MSG_PUB.Count_And_Get(

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,
525: p_data => x_msg_data);
526:

Line 533: FND_MSG_PUB.ADD;

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;
534:
535: FND_MSG_PUB.Count_And_Get(
536: p_encoded => FND_API.G_FALSE,
537: p_count => x_msg_count,

Line 535: FND_MSG_PUB.Count_And_Get(

531: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
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:

Line 608: FND_MSG_PUB.initialize;

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:
611: -- initialize API return status to success.
612: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 698: FND_MSG_PUB.Count_And_Get(

694:
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:

Line 708: FND_MSG_PUB.Count_And_Get(

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,
711: p_data => x_msg_data);
712:

Line 717: FND_MSG_PUB.Count_And_Get(

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,
720: p_data => x_msg_data);
721:

Line 728: FND_MSG_PUB.ADD;

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;
729:
730: FND_MSG_PUB.Count_And_Get(
731: p_encoded => FND_API.G_FALSE,
732: p_count => x_msg_count,

Line 730: FND_MSG_PUB.Count_And_Get(

726: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
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:

Line 796: FND_MSG_PUB.initialize;

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:
799: -- initialize API return status to success.
800: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 939: FND_MSG_PUB.Count_And_Get(

935: );
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:

Line 949: FND_MSG_PUB.Count_And_Get(

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,
952: p_data => x_msg_data);
953:

Line 958: FND_MSG_PUB.Count_And_Get(

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,
961: p_data => x_msg_data);
962:

Line 969: FND_MSG_PUB.ADD;

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;
970:
971: FND_MSG_PUB.Count_And_Get(
972: p_encoded => FND_API.G_FALSE,
973: p_count => x_msg_count,

Line 971: FND_MSG_PUB.Count_And_Get(

967: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
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:

Line 1034: FND_MSG_PUB.initialize;

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:
1037: -- initialize API return status to success.
1038: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1082: FND_MSG_PUB.Count_And_Get(

1078: END LOOP;
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:

Line 1092: FND_MSG_PUB.Count_And_Get(

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,
1095: p_data => x_msg_data);
1096:

Line 1101: FND_MSG_PUB.Count_And_Get(

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);
1105:

Line 1112: FND_MSG_PUB.ADD;

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;
1113:
1114: FND_MSG_PUB.Count_And_Get(
1115: p_encoded => FND_API.G_FALSE,
1116: p_count => x_msg_count,

Line 1114: FND_MSG_PUB.Count_And_Get(

1110: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
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:

Line 1178: FND_MSG_PUB.initialize;

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:
1181: -- initialize API return status to success.
1182: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1227: FND_MSG_PUB.Count_And_Get(

1223: END LOOP;
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:

Line 1237: FND_MSG_PUB.Count_And_Get(

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,
1240: p_data => x_msg_data);
1241:

Line 1246: FND_MSG_PUB.Count_And_Get(

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);
1250:

Line 1257: FND_MSG_PUB.ADD;

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;
1258:
1259: FND_MSG_PUB.Count_And_Get(
1260: p_encoded => FND_API.G_FALSE,
1261: p_count => x_msg_count,

Line 1259: FND_MSG_PUB.Count_And_Get(

1255: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');
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:

Line 1305: FND_MSG_PUB.initialize;

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:
1308: -- initialize API return status to success and security answer to FALSE
1309: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1324: FND_MSG_PUB.ADD;

1320: FND_MESSAGE.SET_TOKEN(
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: --

Line 1365: FND_MSG_PUB.Count_And_Get(

1361: NULL;
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:

Line 1374: FND_MSG_PUB.Count_And_Get(

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,
1377: p_data => x_msg_data);
1378:

Line 1382: FND_MSG_PUB.Count_And_Get(

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,
1385: p_data => x_msg_data);
1386:

Line 1392: FND_MSG_PUB.ADD;

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;
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);

Line 1393: FND_MSG_PUB.Count_And_Get(

1389:
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;