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_PUB dependencies on FND_LOG

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

111:
112: EXCEPTION
113: When others then
114:
115: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
116: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Others';
117: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_PUB.EVALUATEAND.OTHERS', errorMessage);
118: end if;
119:

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

113: When others then
114:
115: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
116: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Others';
117: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_PUB.EVALUATEAND.OTHERS', errorMessage);
118: end if;
119:
120:
121: End evaluateAnd;

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

183:
184: EXCEPTION
185: When others then
186:
187: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
188: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Others';
189: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_PUB.EVALUATEOR.OTHERS', errorMessage);
190: end if;
191:

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

185: When others then
186:
187: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
188: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Others';
189: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_PUB.EVALUATEOR.OTHERS', errorMessage);
190: end if;
191:
192: End evaluateOr;
193:

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

296: return groupOK;
297:
298: When OTHERS then
299:
300: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
301: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Others';
302: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_PUB.VALIDGROUP.OTHERS', errorMessage);
303: end if;
304:

Line 302: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_PUB.VALIDGROUP.OTHERS', errorMessage);

298: When OTHERS then
299:
300: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
301: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Others';
302: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_PUB.VALIDGROUP.OTHERS', errorMessage);
303: end if;
304:
305: groupOK := false;
306: return groupOK;

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

409: --=================--
410: -- Begining of API --
411: --=================--
412:
413: l_log_enabled := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
414:
415:
416: l_exception_log := FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
417:

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

412:
413: l_log_enabled := FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
414:
415:
416: l_exception_log := FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL;
417:
418:
419: if l_log_enabled then
420: logMessage := '[p_account_id=' || to_char(p_accountid) || ']';

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

417:
418:
419: if l_log_enabled then
420: logMessage := '[p_account_id=' || to_char(p_accountid) || ']';
421: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.START', logMessage);
422: end if;
423:
424: --Initialize group to 0
425: x_groupId := 0;

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

431: If p_keyVals_tbl.count > 0 then
432:
433: if l_log_enabled then
434: logMessage := '[p_keyValsCount=' || to_char(p_keyVals_tbl.count) || ']';
435: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.KEY_VALS_MORE_THAN_0', logMessage);
436: end if;
437: --Get all the active routes in the system
438: For v_routes in c_routes (enabledFlag, p_accountId) Loop
439:

Line 456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.DYNAMIC_ROUTE', logMessage);

452: -- Identify route type
453: IF ( booleanTypeCode = 'DYNAMIC' ) THEN
454: if l_log_enabled then
455: logMessage := '[DYNAMIC procedure_name='||procedureName|| ']';
456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.DYNAMIC_ROUTE', logMessage);
457: end if;
458:
459: runTimekeyVals_tbl.delete;
460: runTimeSuccess := true;

Line 483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.DYNAMIC_ROUTE', logMessage);

479:
480: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
481: if l_log_enabled then
482: logMessage := '[ERROR when execute procedure for RouteID: '||v_routes.route_id ||']';
483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.DYNAMIC_ROUTE', logMessage);
484: end if;
485: runTimeSuccess := false;
486: else
487: -- Insert data in key-value pair table

Line 500: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.DYNAMIC_ROUTE', logMessage);

496: end if;
497:
498: if l_log_enabled then
499: logMessage := '[DYNAMIC ROUTE RETURNED VALUE =' || l_result || ']';
500: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.DYNAMIC_ROUTE', logMessage);
501: end if;
502: end if;
503: EXCEPTION
504: WHEN OTHERS THEN

Line 508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.DYNAMIC_ROUTE', logMessage);

504: WHEN OTHERS THEN
505: runTimeSuccess := false;
506: if l_log_enabled then
507: logMessage := '[ERROR (Others) when execute procedure for keyId: '||v_routes.route_id ||'. error:'||sqlerrm||']';
508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.DYNAMIC_ROUTE', logMessage);
509: end if;
510: END; -- end of PROCEDURE processing
511:
512: -- Exit when run procedure failed

Line 525: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.DYNAMIC_ROUTE', logMessage);

521: ruleHold(x).value := v_rules.value;
522:
523: if l_log_enabled then
524: logMessage := '[DYNAMIC ROUTE' || ruleHold(x).key || ruleHold(x).operator || ruleHold(x).value || ']';
525: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.DYNAMIC_ROUTE', logMessage);
526: end if;
527: else
528: exit;
529: end if;

Line 552: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.RULES', logMessage);

548: ruleHold(x).value := v_rules.value;
549:
550: if l_log_enabled then
551: logMessage := '[' || ruleHold(x).key || ruleHold(x).operator || ruleHold(x).value || ']';
552: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.RULES', logMessage);
553: end if;
554:
555: x := x + 1;
556: End Loop;

Line 582: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.RULES', logMessage);

578: p_key_name=>'IEMNAGENTID');
579:
580: if l_log_enabled then
581: logMessage := '[ROUTE to oringinating agent. IEMNAGENTID=' || l_agent_id|| ']';
582: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.RULES', logMessage);
583: end if;
584:
585:
586: if ( l_agent_id is null or l_agent_id='') then

Line 626: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.RULES', logMessage);

622: end if;
623:
624: if l_log_enabled then
625: logMessage := '[Route destination = ' || x_groupId|| ']';
626: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.RULES', logMessage);
627: end if;
628: EXIT;
629: end if;
630:

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

653: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
654:
655: if l_exception_log then
656: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Execution Error';
657: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.EXEC_ERROR', errorMessage);
658: end if;
659:
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661: Rollback to Route_PUB;

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

662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
664: if l_exception_log then
665: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Unexpected Execution Error';
666: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.UNEXP_EXEC_ERROR', errorMessage);
667: end if;
668:
669: WHEN OTHERS THEN
670: Rollback to Route_PUB;

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

675: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
676:
677: if l_exception_log then
678: errorMessage := '[' || sqlcode || sqlerrm || ']' || ' Others';
679: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, 'IEM.PLSQL.IEM_ROUTE_PUB.ROUTE.OTHERS', errorMessage);
680: end if;
681:
682: END route;
683: