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.IEM_ROUTE_CLASS_PUB dependencies on FND_API

Line 243: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

239: returnParamType iem_route_class_rules.key_type_code%type;
240: runTimeSuccess Boolean := true;
241:
242: l_result VARCHAR2(256);
243: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
244: l_msg_count NUMBER := 0;
245: l_msg_data VARCHAR2(2000);
246:
247: l_log_enabled BOOLEAN := false;

Line 258: IF NOT FND_API.Compatible_API_Call(

254: --Standard begin of API savepoint
255: SAVEPOINT Classify_PUB;
256:
257: -- Standard call to check for call compatibility.
258: IF NOT FND_API.Compatible_API_Call(
259: l_api_version_number,
260: p_api_version_number,
261: l_api_name,
262: G_PKG_NAME)

Line 264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

260: p_api_version_number,
261: l_api_name,
262: G_PKG_NAME)
263: THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266:
267: -- Initialize message list if p_init_msg_list is set to TRUE.
268: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 268: IF FND_API.to_Boolean( p_init_msg_list ) THEN

264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266:
267: -- Initialize message list if p_init_msg_list is set to TRUE.
268: IF FND_API.to_Boolean( p_init_msg_list ) THEN
269: FND_MSG_PUB.initialize;
270: END IF;
271:
272: -- Initialize API return status to SUCCESS

Line 273: x_return_status := FND_API.G_RET_STS_SUCCESS;

269: FND_MSG_PUB.initialize;
270: END IF;
271:
272: -- Initialize API return status to SUCCESS
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
275: --=================--
276: -- Begining of API --
277: --=================--

Line 334: p_init_msg_list => FND_API.G_FALSE,

330: -- begin PROCEDURE processing
331: BEGIN
332: IEM_ROUTE_RUN_PROC_PVT.run_Procedure(
333: p_api_version_number =>P_Api_Version_Number,
334: p_init_msg_list => FND_API.G_FALSE,
335: p_commit => FND_API.G_FALSE,--P_Commit,
336: p_procedure_name => procedureName,
337: p_key_value => p_keyVals_tbl,
338: p_param_type => returnParamType,

Line 335: p_commit => FND_API.G_FALSE,--P_Commit,

331: BEGIN
332: IEM_ROUTE_RUN_PROC_PVT.run_Procedure(
333: p_api_version_number =>P_Api_Version_Number,
334: p_init_msg_list => FND_API.G_FALSE,
335: p_commit => FND_API.G_FALSE,--P_Commit,
336: p_procedure_name => procedureName,
337: p_key_value => p_keyVals_tbl,
338: p_param_type => returnParamType,
339: x_result => l_result,

Line 344: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

340: x_return_status => l_return_status,
341: x_msg_count => l_msg_count,
342: x_msg_data => l_msg_data);
343:
344: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
345: if l_log_enabled then
346: logMessage := '[ERROR when execute procedure for RouteID: '||v_classifications.route_classification_id ||']';
347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.DYNAMIC_CLASS', logMessage);
348: end if;

Line 451: If FND_API.To_Boolean(p_commit) then

447: --End of API--
448: --==========--
449:
450: --Standard check of p_commit
451: If FND_API.To_Boolean(p_commit) then
452: COMMIT WORK;
453: End if;
454:
455: --Standard call to get message count and if count is 1 then get message info

Line 459: WHEN FND_API.G_EXC_ERROR THEN

455: --Standard call to get message count and if count is 1 then get message info
456: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
457:
458: EXCEPTION
459: WHEN FND_API.G_EXC_ERROR THEN
460: Rollback to Classify_PUB;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
463: if l_exception_log then

Line 461: x_return_status := FND_API.G_RET_STS_ERROR;

457:
458: EXCEPTION
459: WHEN FND_API.G_EXC_ERROR THEN
460: Rollback to Classify_PUB;
461: x_return_status := FND_API.G_RET_STS_ERROR;
462: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
463: if l_exception_log then
464: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Execution Error';
465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.EXEC_ERROR', errorMessage);

Line 467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

463: if l_exception_log then
464: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Execution Error';
465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.EXEC_ERROR', errorMessage);
466: end if;
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: Rollback to Classify_PUB;
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
471: if l_exception_log then

Line 469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.EXEC_ERROR', errorMessage);
466: end if;
467: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
468: Rollback to Classify_PUB;
469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
471: if l_exception_log then
472: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Unexpected Execution Error';
473: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.UNEXP_EXEC_ERROR', errorMessage);

Line 477: x_return_status := FND_API.G_RET_STS_ERROR;

473: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.UNEXP_EXEC_ERROR', errorMessage);
474: end if;
475: WHEN OTHERS THEN
476: Rollback to Classify_PUB;
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: IF fnd_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
479: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
480: END IF;
481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);