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_LOG

Line 104: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

100:
101: EXCEPTION
102: When others then
103:
104: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
105: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Others';
106: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.EVALUATEAND.OTHERS', errorMessage);
107: end if;
108:

Line 106: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.EVALUATEAND.OTHERS', errorMessage);

102: When others then
103:
104: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
105: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Others';
106: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.EVALUATEAND.OTHERS', errorMessage);
107: end if;
108:
109: End evaluateAnd;
110:

Line 175: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

171: end loop;
172:
173: EXCEPTION
174: When others then
175: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
176: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Others';
177: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.EVALUATEOR.OTHERS', errorMessage);
178: end if;
179: End evaluateOr;

Line 177: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.EVALUATEOR.OTHERS', errorMessage);

173: EXCEPTION
174: When others then
175: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
176: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Others';
177: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.EVALUATEOR.OTHERS', errorMessage);
178: end if;
179: End evaluateOr;
180:
181: PROCEDURE classify(

Line 278: FND_LOG_REPOSITORY.init(null,null);

274:
275: --=================--
276: -- Begining of API --
277: --=================--
278: FND_LOG_REPOSITORY.init(null,null);
279:
280:
281: l_log_enabled := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
282:

Line 281: l_log_enabled := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;

277: --=================--
278: FND_LOG_REPOSITORY.init(null,null);
279:
280:
281: l_log_enabled := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
282:
283: l_exception_log := FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
284:
285: if l_log_enabled then

Line 283: l_exception_log := FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;

279:
280:
281: l_log_enabled := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
282:
283: l_exception_log := FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
284:
285: if l_log_enabled then
286: logMessage := '[p_account_id=' || to_char(p_accountid) || ']';
287: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.START', logMessage);

Line 287: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.START', logMessage);

283: l_exception_log := FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ;
284:
285: if l_log_enabled then
286: logMessage := '[p_account_id=' || to_char(p_accountid) || ']';
287: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.START', logMessage);
288: end if;
289:
290:
291: --Initialize group to 0

Line 302: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.KEY_VALS_MORE_THAN_0', logMessage);

298: If p_keyVals_tbl.count > 0 then
299:
300: if l_log_enabled then
301: logMessage := '[p_keyValsCount=' || to_char(p_keyVals_tbl.count) || ']';
302: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.KEY_VALS_MORE_THAN_0', logMessage);
303: end if;
304:
305:
306: --Get all the active routes in the system

Line 320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.DYNAMIC_CLASS', logMessage);

316: -- Identify classification type
317: IF ( booleanTypeCode = 'DYNAMIC' ) THEN
318: if l_log_enabled then
319: logMessage := '[DYNAMIC procedure_name='||procedureName|| ']';
320: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.DYNAMIC_CLASS', logMessage);
321: end if;
322:
323: runTimekeyVals_tbl.delete;
324: runTimeSuccess := true;

Line 347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.DYNAMIC_CLASS', logMessage);

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;
349: runTimeSuccess := false;
350: else
351: -- Insert data in key-value pair table

Line 364: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.DYNAMIC_CLASS', logMessage);

360: end if;
361:
362: if l_log_enabled then
363: logMessage := '[DYNAMIC ROUTE RETURNED VALUE =' || l_result || ']';
364: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.DYNAMIC_CLASS', logMessage);
365: end if;
366: end if;
367: EXCEPTION
368: WHEN OTHERS THEN

Line 372: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.DYNAMIC_CLASS', logMessage);

368: WHEN OTHERS THEN
369: runTimeSuccess := false;
370: if l_log_enabled then
371: logMessage := '[ERROR (Others) when execute procedure for keyId: '||v_classifications.route_classification_id ||'. error:'||sqlerrm||']';
372: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.DYNAMIC_CLASS', logMessage);
373: end if;
374: END; -- end of PROCEDURE processing
375:
376: -- Exit when run procedure failed

Line 390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.DYNAMIC_CLASS', logMessage);

386: ruleHold(x).value := v_rules.value;
387:
388: if l_log_enabled then
389: logMessage := '[DYNAMIC ROUTE' || ruleHold(x).key || ruleHold(x).operator || ruleHold(x).value || ']';
390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.DYNAMIC_CLASS', logMessage);
391: end if;
392: else
393: exit;
394: end if;

Line 421: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.CLASSIFY.RULES', logMessage);

417: ruleHold(x).value := v_rules.value;
418:
419: if l_log_enabled then
420: logMessage := '[' || ruleHold(x).key || ruleHold(x).operator || ruleHold(x).value || ']';
421: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.CLASSIFY.RULES', logMessage);
422: end if;
423:
424:
425: x := x + 1;

Line 465: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.EXEC_ERROR', errorMessage);

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

Line 473: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.UNEXP_EXEC_ERROR', errorMessage);

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);
474: end if;
475: WHEN OTHERS THEN
476: Rollback to Classify_PUB;
477: x_return_status := FND_API.G_RET_STS_ERROR;

Line 485: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.OTHERS', errorMessage);

481: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
482:
483: if l_exception_log then
484: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Others';
485: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_CLASS_PUB.ROUTE.OTHERS', errorMessage);
486: end if;
487:
488:
489: