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.XDP_APPLICATION dependencies on FND_LOG

Line 1275: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1271: l_SIProcessList FND_CONCURRENT.SERVICE_PROCESS_TAB_TYPE;
1272: l_ConcQName varchar2(30);
1273:
1274: begin
1275: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1276: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_APPLICATION.FETCH_CPID', 'BEGIN:');
1277: end if;
1278: if Caller = 'CONC' then
1279: FND_FILE.put_line(FND_FILE.log, 'Checking if ServiceInstanceId '||ConcQID||' is running');

Line 1276: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_APPLICATION.FETCH_CPID', 'BEGIN:');

1272: l_ConcQName varchar2(30);
1273:
1274: begin
1275: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1276: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'XDP_APPLICATION.FETCH_CPID', 'BEGIN:');
1277: end if;
1278: if Caller = 'CONC' then
1279: FND_FILE.put_line(FND_FILE.log, 'Checking if ServiceInstanceId '||ConcQID||' is running');
1280: END IF;

Line 1293: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1289: pmon_method => l_pmon_method,
1290: callstat => l_callstat);
1291:
1292: if l_callstat = 0 then
1293: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1294: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_CPID',
1295: 'Target processes: '||l_targetp||', active processes: '||l_activep);
1296: end if;
1297:

Line 1294: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_CPID',

1290: callstat => l_callstat);
1291:
1292: if l_callstat = 0 then
1293: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1294: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_CPID',
1295: 'Target processes: '||l_targetp||', active processes: '||l_activep);
1296: end if;
1297:
1298: if Caller = 'CONC' then

Line 1305: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1301:
1302: if l_activep > 0 and l_targetp > 0 then
1303:
1304: l_ConcQName := Fetch_ConcQ_Name (ConcQID => ConcQID);
1305: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1306: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_CPID',
1307: 'Retrieving ACTIVE services processes for '||l_ConcQName);
1308: end if;
1309:

Line 1306: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_CPID',

1302: if l_activep > 0 and l_targetp > 0 then
1303:
1304: l_ConcQName := Fetch_ConcQ_Name (ConcQID => ConcQID);
1305: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1306: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_CPID',
1307: 'Retrieving ACTIVE services processes for '||l_ConcQName);
1308: end if;
1309:
1310: if Caller = 'CONC' then

Line 1320: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1316: svc_instance_name => l_ConcQName,
1317: proc_state => 'ACTIVE');
1318:
1319: if (l_SIProcessList.COUNT > 0) then
1320: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1321: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_CPID',
1322: 'ACTIVE processes for the instance found: '||l_SIProcessList.COUNT);
1323: end if;
1324:

Line 1321: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_CPID',

1317: proc_state => 'ACTIVE');
1318:
1319: if (l_SIProcessList.COUNT > 0) then
1320: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1321: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_CPID',
1322: 'ACTIVE processes for the instance found: '||l_SIProcessList.COUNT);
1323: end if;
1324:
1325: if Caller = 'CONC' then

Line 1334: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1330:
1331: if (l_SIProcessList.EXISTS(i)) then
1332:
1333: l_CPID := l_SIProcessList(i).CPID;
1334: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1335: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1336: 'XDP_APPLICATION.FETCH_CPID',
1337: 'ACTIVE process CPID: '||l_CPID);
1338: end if;

Line 1335: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1331: if (l_SIProcessList.EXISTS(i)) then
1332:
1333: l_CPID := l_SIProcessList(i).CPID;
1334: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1335: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1336: 'XDP_APPLICATION.FETCH_CPID',
1337: 'ACTIVE process CPID: '||l_CPID);
1338: end if;
1339:

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

1341:
1342: END IF;
1343: END LOOP;
1344: else
1345: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1346: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_CPID',
1347: 'No ACTIVE processes for Service found');
1348: end if;
1349: if Caller = 'CONC' then

Line 1346: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_CPID',

1342: END IF;
1343: END LOOP;
1344: else
1345: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1346: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_CPID',
1347: 'No ACTIVE processes for Service found');
1348: end if;
1349: if Caller = 'CONC' then
1350: FND_FILE.put_line(FND_FILE.log, 'No ACTIVE processes for Service found');

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

1351: END IF;
1352: END IF;
1353:
1354: else
1355: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1356: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_CPID',
1357: 'ACTIVE and TARGET processes not greater than 0');
1358: end if;
1359: if Caller = 'CONC' then

Line 1356: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_CPID',

1352: END IF;
1353:
1354: else
1355: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1356: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_CPID',
1357: 'ACTIVE and TARGET processes not greater than 0');
1358: end if;
1359: if Caller = 'CONC' then
1360: FND_FILE.put_line(FND_FILE.log, 'ACTIVE and TARGET processes not greater than 0, so service instance is not running');

Line 1364: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1360: FND_FILE.put_line(FND_FILE.log, 'ACTIVE and TARGET processes not greater than 0, so service instance is not running');
1361: END IF;
1362: end if;
1363: else
1364: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1365: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_APPLICATION.FETCH_CPID',
1366: 'FND_CONCURRENT.GET_MANAGER_STATUS failed, callstat: '||l_callstat);
1367: end if;
1368: if Caller = 'CONC' then

Line 1365: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_APPLICATION.FETCH_CPID',

1361: END IF;
1362: end if;
1363: else
1364: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1365: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, 'XDP_APPLICATION.FETCH_CPID',
1366: 'FND_CONCURRENT.GET_MANAGER_STATUS failed, callstat: '||l_callstat);
1367: end if;
1368: if Caller = 'CONC' then
1369: FND_FILE.put_line(FND_FILE.log, 'FND_CONCURRENT.GET_MANAGER_STATUS failed, callstat: '||l_callstat);

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

1450: l_ServiceInstanceList := FND_CONCURRENT.GET_SERVICE_INSTANCES(svc_handle);
1451:
1452: EXCEPTION
1453: WHEN OTHERS THEN
1454: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1455: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'FND_CONCURRENT.GET_SERVICE_INSTANCES returned exception: ' ||to_char(SQLCODE) ||SQLERRM);
1456: end if;
1457: num_of_threads := -1;
1458: END;

Line 1455: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'FND_CONCURRENT.GET_SERVICE_INSTANCES returned exception: ' ||to_char(SQLCODE) ||SQLERRM);

1451:
1452: EXCEPTION
1453: WHEN OTHERS THEN
1454: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1455: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'FND_CONCURRENT.GET_SERVICE_INSTANCES returned exception: ' ||to_char(SQLCODE) ||SQLERRM);
1456: end if;
1457: num_of_threads := -1;
1458: END;
1459:

Line 1462: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1458: END;
1459:
1460:
1461: IF (l_ServiceInstanceList.COUNT > 0) THEN
1462: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1463: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'No. of service_instances found: '||l_ServiceInstanceList.COUNT);
1464: end if;
1465:
1466: FOR i in 1..l_ServiceInstanceList.COUNT LOOP

Line 1463: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'No. of service_instances found: '||l_ServiceInstanceList.COUNT);

1459:
1460:
1461: IF (l_ServiceInstanceList.COUNT > 0) THEN
1462: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1463: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'No. of service_instances found: '||l_ServiceInstanceList.COUNT);
1464: end if;
1465:
1466: FOR i in 1..l_ServiceInstanceList.COUNT LOOP
1467:

Line 1480: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1476: svc_instance_name => l_InstanceName,
1477: proc_state => 'ACTIVE');
1478:
1479: IF (l_SIProcessList.COUNT > 0) THEN
1480: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1481: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'ACTIVE processes for the instance found: '||l_SIProcessList.COUNT);
1482: end if;
1483:
1484: FOR i IN 1..l_SIProcessList.COUNT LOOP

Line 1481: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'ACTIVE processes for the instance found: '||l_SIProcessList.COUNT);

1477: proc_state => 'ACTIVE');
1478:
1479: IF (l_SIProcessList.COUNT > 0) THEN
1480: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1481: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'ACTIVE processes for the instance found: '||l_SIProcessList.COUNT);
1482: end if;
1483:
1484: FOR i IN 1..l_SIProcessList.COUNT LOOP
1485:

Line 1494: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1490: END IF;
1491:
1492: END LOOP;
1493: num_of_threads := num_of_threads + (l_SIProcessList.COUNT * p_num_of_threads);
1494: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1495: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'Number or Threads running for a service: '||num_of_threads);
1496: end if;
1497:
1498: ELSE

Line 1495: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'Number or Threads running for a service: '||num_of_threads);

1491:
1492: END LOOP;
1493: num_of_threads := num_of_threads + (l_SIProcessList.COUNT * p_num_of_threads);
1494: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1495: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'Number or Threads running for a service: '||num_of_threads);
1496: end if;
1497:
1498: ELSE
1499: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

1495: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'Number or Threads running for a service: '||num_of_threads);
1496: end if;
1497:
1498: ELSE
1499: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1500: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'No ACTIVE processes for Service found');
1501: end if;
1502:
1503: END IF;

Line 1500: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'No ACTIVE processes for Service found');

1496: end if;
1497:
1498: ELSE
1499: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1500: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'No ACTIVE processes for Service found');
1501: end if;
1502:
1503: END IF;
1504:

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

1503: END IF;
1504:
1505: EXCEPTION
1506: WHEN OTHERS THEN
1507: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1508: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'FND_CONCURRENT.GET_SERVICE_PROCESS returned exception: ' ||to_char(SQLCODE) ||SQLERRM);
1509: end if;
1510: END;
1511: END IF;

Line 1508: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'FND_CONCURRENT.GET_SERVICE_PROCESS returned exception: ' ||to_char(SQLCODE) ||SQLERRM);

1504:
1505: EXCEPTION
1506: WHEN OTHERS THEN
1507: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1508: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'FND_CONCURRENT.GET_SERVICE_PROCESS returned exception: ' ||to_char(SQLCODE) ||SQLERRM);
1509: end if;
1510: END;
1511: END IF;
1512: END LOOP;

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

1511: END IF;
1512: END LOOP;
1513:
1514: ELSE
1515: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1516: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'No Service Instances found for service_handle: ' ||svc_handle );
1517: end if;
1518:
1519: END IF;

Line 1516: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'No Service Instances found for service_handle: ' ||svc_handle );

1512: END LOOP;
1513:
1514: ELSE
1515: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1516: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION, 'XDP_APPLICATION.FETCH_THREAD_CNT', 'No Service Instances found for service_handle: ' ||svc_handle );
1517: end if;
1518:
1519: END IF;
1520: