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

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:
1280: l_user_name := fnd_global.user_name;
1281:
1282: --clear the temporary table

Line 1295: IF l_return_status = FND_API.G_RET_STS_SUCCESS then

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

Line 1306: x_return_status := FND_API.G_RET_STS_ERROR;

1302: -- x_granted_groups(i).dss_group_code);
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;

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

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

Line 1396: RAISE FND_API.G_EXC_ERROR;

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
1400: IF HZ_DSS_VALIDATE_PKG.exist_in_dss_entities(p_entity_id) = 'N' THEN

Line 1403: RAISE FND_API.G_EXC_ERROR;

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;
1407: FETCH c_find_objects INTO l_object_name, l_string;

Line 1435: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1439: WHEN FND_API.G_EXC_ERROR THEN

1435: x_return_status := FND_API.G_RET_STS_SUCCESS;
1436: x_predicate := l_sql ;
1437:
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,

Line 1440: x_return_status := FND_API.G_RET_STS_ERROR;

1436: x_predicate := l_sql ;
1437:
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,

Line 1443: p_encoded => fnd_api.g_false,

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

Line 1449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1445: p_data => x_msg_data
1446: );
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;

Line 1456: p_encoded => fnd_api.g_false,

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