DBA Data[Home] [Help]

APPS.HZ_DSS_UTIL_PUB dependencies on FND_MSG_PUB

Line 172: FND_MSG_PUB.initialize;

168: --
169: IF p_init_msg_list IS NOT NULL AND
170: FND_API.to_Boolean(p_init_msg_list)
171: THEN
172: FND_MSG_PUB.initialize;
173: END IF;
174:
175: --- initialize API return status to success.
176: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 192: FND_MSG_PUB.ADD;

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;
196: */

Line 205: FND_MSG_PUB.ADD;

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

Line 217: FND_MSG_PUB.ADD;

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

Line 247: FND_MSG_PUB.ADD;

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;
251: CLOSE get_functions_for_op;

Line 264: FND_MSG_PUB.COUNT_AND_GET(

260: EXCEPTION
261: WHEN FND_API.G_EXC_ERROR THEN
262: x_return_status := FND_API.G_RET_STS_ERROR;
263:
264: FND_MSG_PUB.COUNT_AND_GET(
265: p_encoded => fnd_api.g_false,
266: p_count => x_msg_count,
267: p_data => x_msg_data
268: );

Line 277: FND_MSG_PUB.ADD;

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,
281: p_count => x_msg_count,

Line 279: FND_MSG_PUB.COUNT_AND_GET(

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,
281: p_count => x_msg_count,
282: p_data => x_msg_data
283: );

Line 371: FND_MSG_PUB.initialize;

367:
368: BEGIN
369:
370: ---initialize the message
371: FND_MSG_PUB.initialize;
372:
373: --- initialize API return status to success.
374: x_return_status := FND_API.G_RET_STS_SUCCESS;
375:

Line 390: FND_MSG_PUB.ADD;

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:
394: begin

Line 405: FND_MSG_PUB.ADD;

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:
409: i := 1;

Line 447: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

443:
444: EXCEPTION
445: WHEN fnd_api.g_exc_error THEN
446: x_return_status := FND_API.G_RET_STS_ERROR;
447: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
448: p_count => x_msg_count,
449: p_data => x_msg_data);
450:
451:

Line 1275: FND_MSG_PUB.initialize;

1271: l_msg_data VARCHAR2(2000);
1272:
1273: begin
1274: ---initialize the message
1275: FND_MSG_PUB.initialize;
1276:
1277: --- initialize API return status to success.
1278: x_return_status := FND_API.G_RET_STS_SUCCESS;
1279:

Line 1307: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

1303:
1304: end loop;
1305: ELSE
1306: x_return_status := FND_API.G_RET_STS_ERROR;
1307: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1308: p_count => x_msg_count,
1309: p_data => x_msg_data);
1310: END IF;
1311:

Line 1387: FND_MSG_PUB.initialize;

1383:
1384: BEGIN
1385:
1386: ---initialize the message
1387: FND_MSG_PUB.initialize;
1388:
1389: --- initialize API return status to success.
1390: x_return_status := FND_API.G_RET_STS_SUCCESS;
1391:

Line 1395: FND_MSG_PUB.ADD;

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:
1399: -- entity id validation

Line 1402: FND_MSG_PUB.ADD;

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:
1406: OPEN c_find_objects;

Line 1442: FND_MSG_PUB.COUNT_AND_GET(

1438: EXCEPTION
1439: WHEN FND_API.G_EXC_ERROR THEN
1440: x_return_status := FND_API.G_RET_STS_ERROR;
1441:
1442: FND_MSG_PUB.COUNT_AND_GET(
1443: p_encoded => fnd_api.g_false,
1444: p_count => x_msg_count,
1445: p_data => x_msg_data
1446: );

Line 1453: FND_MSG_PUB.ADD;

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,
1457: p_count => x_msg_count,

Line 1455: FND_MSG_PUB.COUNT_AND_GET(

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,
1457: p_count => x_msg_count,
1458: p_data => x_msg_data
1459: );