DBA Data[Home] [Help]

APPS.HZ_DSS_UTIL_PUB dependencies on FND_MESSAGE

Line 190: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_INVALID_USER');

186: OPEN c_check_user;
187: FETCH c_check_user INTO l_exists;
188: IF c_check_user%NOTFOUND THEN
189: CLOSE c_check_user;
190: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_INVALID_USER');
191: FND_MESSAGE.SET_TOKEN('USER_NAME', p_user_name);
192: FND_MSG_PUB.ADD;
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;

Line 191: FND_MESSAGE.SET_TOKEN('USER_NAME', p_user_name);

187: FETCH c_check_user INTO l_exists;
188: IF c_check_user%NOTFOUND THEN
189: CLOSE c_check_user;
190: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_INVALID_USER');
191: FND_MESSAGE.SET_TOKEN('USER_NAME', p_user_name);
192: FND_MSG_PUB.ADD;
193: RAISE FND_API.G_EXC_ERROR;
194: END IF;
195: CLOSE c_check_user;

Line 203: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_INVALID_OBJECT');

199: OPEN c_check_table;
200: FETCH c_check_table INTO l_exists;
201: IF c_check_table%NOTFOUND THEN
202: CLOSE c_check_table;
203: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_INVALID_OBJECT');
204: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_db_object_name);
205: FND_MSG_PUB.ADD;
206: RAISE FND_API.G_EXC_ERROR;
207: END IF;

Line 204: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_db_object_name);

200: FETCH c_check_table INTO l_exists;
201: IF c_check_table%NOTFOUND THEN
202: CLOSE c_check_table;
203: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_INVALID_OBJECT');
204: FND_MESSAGE.SET_TOKEN('OBJECT_NAME',p_db_object_name);
205: FND_MSG_PUB.ADD;
206: RAISE FND_API.G_EXC_ERROR;
207: END IF;
208: CLOSE c_check_table;

Line 215: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_INVALID_OPER');

211: OPEN c_check_operation_code;
212: FETCH c_check_operation_code INTO l_exists;
213: IF c_check_operation_code%NOTFOUND THEN
214: CLOSE c_check_operation_code;
215: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_INVALID_OPER');
216: FND_MESSAGE.SET_TOKEN('OPER_NAME',p_operation_code);
217: FND_MSG_PUB.ADD;
218: RAISE FND_API.G_EXC_ERROR;
219: END IF;

Line 216: FND_MESSAGE.SET_TOKEN('OPER_NAME',p_operation_code);

212: FETCH c_check_operation_code INTO l_exists;
213: IF c_check_operation_code%NOTFOUND THEN
214: CLOSE c_check_operation_code;
215: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_INVALID_OPER');
216: FND_MESSAGE.SET_TOKEN('OPER_NAME',p_operation_code);
217: FND_MSG_PUB.ADD;
218: RAISE FND_API.G_EXC_ERROR;
219: END IF;
220: CLOSE c_check_operation_code;

Line 245: FND_MESSAGE.SET_NAME('AR', 'HZ_API_CALLING_ERROR');

241:
242: IF l_result = 'F' THEN
243: EXIT;
244: ELSIF l_result = 'U' THEN
245: FND_MESSAGE.SET_NAME('AR', 'HZ_API_CALLING_ERROR');
246: FND_MESSAGE.SET_TOKEN('PROC_NAME', 'FND_DATA_SECURITY.check_function');
247: FND_MSG_PUB.ADD;
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;

Line 246: FND_MESSAGE.SET_TOKEN('PROC_NAME', 'FND_DATA_SECURITY.check_function');

242: IF l_result = 'F' THEN
243: EXIT;
244: ELSIF l_result = 'U' THEN
245: FND_MESSAGE.SET_NAME('AR', 'HZ_API_CALLING_ERROR');
246: FND_MESSAGE.SET_TOKEN('PROC_NAME', 'FND_DATA_SECURITY.check_function');
247: FND_MSG_PUB.ADD;
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250: END LOOP;

Line 275: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

271:
272: WHEN OTHERS THEN
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274:
275: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
276: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
277: FND_MSG_PUB.ADD;
278:
279: FND_MSG_PUB.COUNT_AND_GET(

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

272: WHEN OTHERS THEN
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274:
275: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
276: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
277: FND_MSG_PUB.ADD;
278:
279: FND_MSG_PUB.COUNT_AND_GET(
280: p_encoded => fnd_api.g_false,

Line 389: FND_MESSAGE.SET_NAME('AR','HZ_DSS_INVALID_USER');

385: and ( start_date IS NULL OR start_date <= SYSDATE)
386: and ( end_date is null or end_date >= sysdate );
387:
388: exception when no_data_found then
389: FND_MESSAGE.SET_NAME('AR','HZ_DSS_INVALID_USER');
390: FND_MSG_PUB.ADD;
391: RAISE FND_API.G_EXC_ERROR;
392: end;
393:

Line 403: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_INVALID_OPER');

399: where lu.lookup_type = 'HZ_DATA_OPERATIONS'
400: and lu.lookup_code = p_operation_code;
401:
402: exception when no_data_found then
403: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_INVALID_OPER');
404: FND_MESSAGE.SET_TOKEN('OPER_NAME',p_operation_code);
405: FND_MSG_PUB.ADD;
406: RAISE FND_API.G_EXC_ERROR;
407: end;

Line 404: FND_MESSAGE.SET_TOKEN('OPER_NAME',p_operation_code);

400: and lu.lookup_code = p_operation_code;
401:
402: exception when no_data_found then
403: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_INVALID_OPER');
404: FND_MESSAGE.SET_TOKEN('OPER_NAME',p_operation_code);
405: FND_MSG_PUB.ADD;
406: RAISE FND_API.G_EXC_ERROR;
407: end;
408:

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

1390: x_return_status := FND_API.G_RET_STS_SUCCESS;
1391:
1392: --- validation passed in group code should be valid
1393: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b(p_dss_group_code)= 'N' THEN
1394: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');
1395: FND_MSG_PUB.ADD;
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398:

Line 1401: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ENT_ID_INVALID');

1397: END IF;
1398:
1399: -- entity id validation
1400: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_entities(p_entity_id) = 'N' THEN
1401: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_ENT_ID_INVALID');
1402: FND_MSG_PUB.ADD;
1403: RAISE FND_API.G_EXC_ERROR;
1404: END IF;
1405:

Line 1451: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

1447:
1448: WHEN OTHERS THEN
1449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1450:
1451: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1452: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1453: FND_MSG_PUB.ADD;
1454:
1455: FND_MSG_PUB.COUNT_AND_GET(

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

1448: WHEN OTHERS THEN
1449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1450:
1451: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1452: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1453: FND_MSG_PUB.ADD;
1454:
1455: FND_MSG_PUB.COUNT_AND_GET(
1456: p_encoded => fnd_api.g_false,