DBA Data[Home] [Help]

APPS.HZ_DSS_GRANTS_PUB dependencies on FND_MESSAGE

Line 180: FND_MESSAGE.SET_NAME('FND','FND_GENERIC_MESSAGE');

176: -- Validate the grantee information
177: --
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;

Line 181: FND_MESSAGE.SET_TOKEN('MESSAGE','Grantee type must be one of: GROUP, USER, GLOBAL');

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

Line 210: FND_MESSAGE.SET_NAME('FND','FND_INVALID_USER');

206: AND ROWNUM = 1;
207:
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;

Line 211: FND_MESSAGE.SET_TOKEN('USER_NAME',p_dss_grantee_key);

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

Line 227: FND_MESSAGE.SET_NAME('AR','HZ_DSS_INVALID_RESP');

223: AND ROWNUM = 1;
224:
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;

Line 228: FND_MESSAGE.SET_TOKEN('RESP',p_dss_grantee_key);

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

Line 449: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');

445: FETCH c_dss_groups INTO l_dsg_status;
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:

Line 531: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

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;
534:
535: FND_MSG_PUB.Count_And_Get(

Line 532: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 726: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

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;
729:
730: FND_MSG_PUB.Count_And_Get(

Line 727: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 967: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

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;
970:
971: FND_MSG_PUB.Count_And_Get(

Line 968: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 1110: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

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;
1113:
1114: FND_MSG_PUB.Count_And_Get(

Line 1111: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 1255: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

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;
1258:
1259: FND_MSG_PUB.Count_And_Get(

Line 1256: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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

Line 1319: FND_MESSAGE.SET_NAME('FND','FND_GENERIC_MESSAGE');

1315:
1316: IF p_dss_admin_func_code NOT IN
1317: (g_dss_admin_create, g_dss_admin_update, g_dss_admin_grant)
1318: THEN
1319: FND_MESSAGE.SET_NAME('FND','FND_GENERIC_MESSAGE');
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

Line 1320: FND_MESSAGE.SET_TOKEN(

1316: IF p_dss_admin_func_code NOT IN
1317: (g_dss_admin_create, g_dss_admin_update, g_dss_admin_grant)
1318: THEN
1319: FND_MESSAGE.SET_NAME('FND','FND_GENERIC_MESSAGE');
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;

Line 1390: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_OTHERS_EXCEP');

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;
1393: FND_MSG_PUB.Count_And_Get(
1394: p_encoded => FND_API.G_FALSE,

Line 1391: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;
1393: FND_MSG_PUB.Count_And_Get(
1394: p_encoded => FND_API.G_FALSE,
1395: p_count => x_msg_count,