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_UTIL_PUB dependencies on FND_API

Line 170: FND_API.to_Boolean(p_init_msg_list)

166: -- Bug 3667238: initialize message stack based on the value
167: -- of the parameter
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:

Line 176: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
177:
178: --Check if security is on
179: IF NVL(FND_PROFILE.VALUE('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
180:

Line 181: /* in R12, the fnd api won't accept user name.

177:
178: --Check if security is on
179: IF NVL(FND_PROFILE.VALUE('HZ_DSS_ENABLED'), 'N') = 'Y' THEN
180:
181: /* in R12, the fnd api won't accept user name.
182: it will raise a runtime error user_name contains
183: anything other than null or fnd_global.user_name
184:
185: ---check if the passed user is valid

Line 193: RAISE FND_API.G_EXC_ERROR;

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: */
197:

Line 206: RAISE FND_API.G_EXC_ERROR;

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:
210: ---- Check if the passed operation code is valid ----

Line 218: RAISE FND_API.G_EXC_ERROR;

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:
222: ---- Get all the security functions for the operation passed ----

Line 248: RAISE FND_API.G_EXC_ERROR;

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

Line 257: RETURN FND_API.G_TRUE;

253: RETURN l_result;
254:
255: ELSE
256: --no security so return true
257: RETURN FND_API.G_TRUE;
258: END IF;
259:
260: EXCEPTION
261: WHEN FND_API.G_EXC_ERROR THEN

Line 261: WHEN FND_API.G_EXC_ERROR THEN

257: RETURN FND_API.G_TRUE;
258: END IF;
259:
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,

Line 262: x_return_status := FND_API.G_RET_STS_ERROR;

258: END IF;
259:
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,

Line 265: p_encoded => fnd_api.g_false,

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

Line 270: RETURN FND_API.G_FALSE;

266: p_count => x_msg_count,
267: p_data => x_msg_data
268: );
269:
270: RETURN FND_API.G_FALSE;
271:
272: WHEN OTHERS THEN
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274:

Line 273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

269:
270: RETURN FND_API.G_FALSE;
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;

Line 280: p_encoded => fnd_api.g_false,

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

Line 285: RETURN FND_API.G_FALSE;

281: p_count => x_msg_count,
282: p_data => x_msg_data
283: );
284:
285: RETURN FND_API.G_FALSE;
286:
287: END test_instance;
288:
289:

Line 374: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
376: ---Validate the input
377: ---check if the passed user is valid
378: ---Check if the passed operation code is valid

Line 391: RAISE FND_API.G_EXC_ERROR;

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

Line 406: RAISE FND_API.G_EXC_ERROR;

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

Line 445: WHEN fnd_api.g_exc_error THEN

441: end loop;
442: close c_fn_menu_op;
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);

Line 446: x_return_status := FND_API.G_RET_STS_ERROR;

442: close c_fn_menu_op;
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:

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 1277: x_return_status := FND_API.G_RET_STS_SUCCESS;

1273: ---initialize the message
1274: FND_MSG_PUB.initialize;
1275:
1276: --- initialize API return status to success.
1277: x_return_status := FND_API.G_RET_STS_SUCCESS;
1278:
1279: l_user_name := fnd_global.user_name;
1280:
1281: --clear the temporary table

Line 1294: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

1290: l_msg_count,
1291: l_msg_data);
1292:
1293:
1294: IF l_return_status = FND_API.G_RET_STS_SUCCESS then
1295:
1296: FOR I IN x_granted_groups.first..x_granted_groups.last
1297: loop
1298: null;

Line 1305: x_return_status := FND_API.G_RET_STS_ERROR;

1301: -- x_granted_groups(i).dss_group_code);
1302:
1303: end loop;
1304: ELSE
1305: x_return_status := FND_API.G_RET_STS_ERROR;
1306: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1307: p_count => x_msg_count,
1308: p_data => x_msg_data);
1309: END IF;

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

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

Line 1389: x_return_status := FND_API.G_RET_STS_SUCCESS;

1385: ---initialize the message
1386: FND_MSG_PUB.initialize;
1387:
1388: --- initialize API return status to success.
1389: x_return_status := FND_API.G_RET_STS_SUCCESS;
1390:
1391: --- validation passed in group code should be valid
1392: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_groups_b(p_dss_group_code)= 'N' THEN
1393: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_GR_CODE_INVALID');

Line 1395: RAISE FND_API.G_EXC_ERROR;

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

Line 1402: RAISE FND_API.G_EXC_ERROR;

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

Line 1434: x_return_status := FND_API.G_RET_STS_SUCCESS;

1430: -- l_sql_to_test := ' select 1 from ' ||l_object_name || ' where '|| l_sql ;
1431: -- c := dbms_sql.open_cursor;
1432: -- dbms_sql.parse(c, l_sql_to_test, dbms_sql.native);
1433:
1434: x_return_status := FND_API.G_RET_STS_SUCCESS;
1435: x_predicate := l_sql ;
1436:
1437: EXCEPTION
1438: WHEN FND_API.G_EXC_ERROR THEN

Line 1438: WHEN FND_API.G_EXC_ERROR THEN

1434: x_return_status := FND_API.G_RET_STS_SUCCESS;
1435: x_predicate := l_sql ;
1436:
1437: EXCEPTION
1438: WHEN FND_API.G_EXC_ERROR THEN
1439: x_return_status := FND_API.G_RET_STS_ERROR;
1440:
1441: FND_MSG_PUB.COUNT_AND_GET(
1442: p_encoded => fnd_api.g_false,

Line 1439: x_return_status := FND_API.G_RET_STS_ERROR;

1435: x_predicate := l_sql ;
1436:
1437: EXCEPTION
1438: WHEN FND_API.G_EXC_ERROR THEN
1439: x_return_status := FND_API.G_RET_STS_ERROR;
1440:
1441: FND_MSG_PUB.COUNT_AND_GET(
1442: p_encoded => fnd_api.g_false,
1443: p_count => x_msg_count,

Line 1442: p_encoded => fnd_api.g_false,

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

Line 1448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1444: p_data => x_msg_data
1445: );
1446:
1447: WHEN OTHERS THEN
1448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1449:
1450: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1451: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1452: FND_MSG_PUB.ADD;

Line 1455: p_encoded => fnd_api.g_false,

1451: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1452: FND_MSG_PUB.ADD;
1453:
1454: FND_MSG_PUB.COUNT_AND_GET(
1455: p_encoded => fnd_api.g_false,
1456: p_count => x_msg_count,
1457: p_data => x_msg_data
1458: );
1459: