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_CONCURRENT

Line 66: FND_CONCURRENT.GET_MANAGER_STATUS (

62: if Caller = 'CONC' then
63: FND_FILE.put_line(FND_FILE.log, 'Checking if ICM is running');
64: END IF;
65:
66: FND_CONCURRENT.GET_MANAGER_STATUS (
67: applid => 0,
68: managerid => 1,
69: targetp => l_targetp,
70: activep => l_activep,

Line 77: 'FND_CONCURRENT.GET_MANAGER_STATUS failed while checking for ICM, callstat: '||l_callstat);

73:
74: if l_callstat <> 0 then
75: if Caller = 'CONC' then
76: FND_FILE.put_line(FND_FILE.log,
77: 'FND_CONCURRENT.GET_MANAGER_STATUS failed while checking for ICM, callstat: '||l_callstat);
78: END IF;
79: return false;
80: else
81: if Caller = 'CONC' then

Line 308: l_ServiceInstanceList FND_CONCURRENT.SERVICE_INSTANCE_TAB_TYPE;

304: -- * --------------------------------------------------------------------------------
305: Procedure Stop_Service_Instances (p_ServiceHandle in varchar2, StopOptions in varchar2)
306: is
307: l_ReqID number;
308: l_ServiceInstanceList FND_CONCURRENT.SERVICE_INSTANCE_TAB_TYPE;
309:
310: l_targetp number;
311: l_activep number;
312: l_pmon_method varchar2(80);

Line 321: l_ServiceInstanceList := FND_CONCURRENT.GET_SERVICE_INSTANCES

317: begin
318: l_ServiceInstanceList.delete;
319:
320: FND_FILE.put_line(FND_FILE.log, 'Retrieving services instances for '||p_ServiceHandle);
321: l_ServiceInstanceList := FND_CONCURRENT.GET_SERVICE_INSTANCES
322: (svc_handle => p_ServiceHandle);
323:
324: if (l_ServiceInstanceList.COUNT > 0) then
325:

Line 356: FND_CONCURRENT.GET_MANAGER_STATUS (

352: l_ServiceInstanceId := Fetch_ConcQ_ID
353: (ConcQName => l_ServiceInstanceList(i).INSTANCE_NAME);
354: if (l_ServiceInstanceId > 0) then
355:
356: FND_CONCURRENT.GET_MANAGER_STATUS (
357: applid => 535,
358: managerid => l_ServiceInstanceId,
359: targetp => l_targetp,
360: activep => l_activep,

Line 366: 'FND_CONCURRENT.GET_MANAGER_STATUS failed, callstat: '||l_callstat);

362: callstat => l_callstat);
363:
364: if l_callstat <> 0 then
365: FND_FILE.put_line(FND_FILE.log,
366: 'FND_CONCURRENT.GET_MANAGER_STATUS failed, callstat: '||l_callstat);
367: else
368: FND_FILE.put_line(FND_FILE.log,'Target processes: '||l_targetp||', active processes: '||l_activep);
369: -- if l_targetp > 0 then
370: if l_activep > 0 then

Line 665: l_CallStatus := FND_CONCURRENT.GET_REQUEST_STATUS

661:
662: -- Initialize out variables with NULL string
663: dev_phase := 'NULL';
664: dev_status := 'NULL';
665: l_CallStatus := FND_CONCURRENT.GET_REQUEST_STATUS
666: (l_ReqID, null, null, phase,
667: status, dev_phase, dev_status,
668: message);
669:

Line 672: 'FND_CONCURRENT.GET_REQUEST_STATUS failed, message: '||message);

668: message);
669:
670: if (not l_CallStatus) then
671: FND_FILE.put_line(FND_FILE.log,
672: 'FND_CONCURRENT.GET_REQUEST_STATUS failed, message: '||message);
673: return false;
674: end if;
675:
676: FND_FILE.put_line(FND_FILE.log,

Line 821: l_ServiceInstanceList FND_CONCURRENT.SERVICE_INSTANCE_TAB_TYPE;

817: -- * --------------------------------------------------------------------------------
818: Function Start_Service_Instances (p_ServiceHandle in varchar2) return SERVICE_INSTANCE_REQS_TAB
819: is
820: l_ReqID number;
821: l_ServiceInstanceList FND_CONCURRENT.SERVICE_INSTANCE_TAB_TYPE;
822: l_ServiceInstanceStarted SERVICE_INSTANCE_REQS_TAB;
823: l_Count number := 0;
824:
825: l_targetp number;

Line 837: l_ServiceInstanceList := FND_CONCURRENT.GET_SERVICE_INSTANCES

833: l_ServiceInstanceStarted.delete;
834: l_ServiceInstanceList.delete;
835:
836: FND_FILE.put_line(FND_FILE.log, 'Retrieving services instances for '||p_ServiceHandle);
837: l_ServiceInstanceList := FND_CONCURRENT.GET_SERVICE_INSTANCES
838: (svc_handle => p_ServiceHandle);
839:
840: if (l_ServiceInstanceList.COUNT > 0) then
841:

Line 872: FND_CONCURRENT.GET_MANAGER_STATUS (

868: l_ServiceInstanceId := Fetch_ConcQ_ID
869: (ConcQName => l_ServiceInstanceList(i).INSTANCE_NAME);
870: if (l_ServiceInstanceId > 0) then
871:
872: FND_CONCURRENT.GET_MANAGER_STATUS (
873: applid => 535,
874: managerid => l_ServiceInstanceId,
875: targetp => l_targetp,
876: activep => l_activep,

Line 882: 'FND_CONCURRENT.GET_MANAGER_STATUS failed, callstat: '||l_callstat);

878: callstat => l_callstat);
879:
880: if l_callstat <> 0 then
881: FND_FILE.put_line(FND_FILE.log,
882: 'FND_CONCURRENT.GET_MANAGER_STATUS failed, callstat: '||l_callstat);
883: else
884: FND_FILE.put_line(FND_FILE.log,'Target processes: '||l_targetp||', active processes: '||l_activep);
885: -- if l_targetp = 0 then
886: if l_activep = 0 then

Line 1271: l_SIProcessList FND_CONCURRENT.SERVICE_PROCESS_TAB_TYPE;

1267: l_targetp number := 0;
1268: l_activep number := 0;
1269: l_pmon_method varchar2(80);
1270: l_callstat number;
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

Line 1284: FND_CONCURRENT.GET_MANAGER_STATUS (

1280: END IF;
1281:
1282: l_SIProcessList.delete;
1283:
1284: FND_CONCURRENT.GET_MANAGER_STATUS (
1285: applid => 535,
1286: managerid => ConcQID,
1287: targetp => l_targetp,
1288: activep => l_activep,

Line 1314: l_SIProcessList := FND_CONCURRENT.GET_SERVICE_PROCESSES

1310: if Caller = 'CONC' then
1311: FND_FILE.put_line(FND_FILE.log, 'Retrieving ACTIVE services processes for '||l_ConcQName);
1312: END IF;
1313:
1314: l_SIProcessList := FND_CONCURRENT.GET_SERVICE_PROCESSES
1315: (appl_short_name => 'XDP',
1316: svc_instance_name => l_ConcQName,
1317: proc_state => 'ACTIVE');
1318:

Line 1366: 'FND_CONCURRENT.GET_MANAGER_STATUS failed, callstat: '||l_callstat);

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);
1370: END IF;

Line 1369: FND_FILE.put_line(FND_FILE.log, 'FND_CONCURRENT.GET_MANAGER_STATUS failed, callstat: '||l_callstat);

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);
1370: END IF;
1371: end if;
1372:
1373: -- dbms_output.put_line('CPID: ' || l_CPID);

Line 1398: from fnd_concurrent_processes a, fnd_concurrent_queues b

1394: is
1395:
1396: cursor c_GetConcQID is
1397: select a.concurrent_queue_id, b.concurrent_queue_name
1398: from fnd_concurrent_processes a, fnd_concurrent_queues b
1399: where a.concurrent_process_id = CPID and
1400: a.concurrent_queue_id = b.concurrent_queue_id and
1401: a.queue_application_id = b.application_id;
1402:

Line 1437: l_ServiceInstanceList FND_CONCURRENT.SERVICE_INSTANCE_TAB_TYPE;

1433:
1434: PROCEDURE FETCH_THREAD_CNT (svc_handle IN VARCHAR2,
1435: num_of_threads OUT NOCOPY NUMBER)
1436: IS
1437: l_ServiceInstanceList FND_CONCURRENT.SERVICE_INSTANCE_TAB_TYPE;
1438: l_SIProcessList FND_CONCURRENT.SERVICE_PROCESS_TAB_TYPE;
1439: l_ServiceInstanceId number := 0;
1440: p_num_of_threads number;
1441: l_InstanceName varchar2(30);

Line 1438: l_SIProcessList FND_CONCURRENT.SERVICE_PROCESS_TAB_TYPE;

1434: PROCEDURE FETCH_THREAD_CNT (svc_handle IN VARCHAR2,
1435: num_of_threads OUT NOCOPY NUMBER)
1436: IS
1437: l_ServiceInstanceList FND_CONCURRENT.SERVICE_INSTANCE_TAB_TYPE;
1438: l_SIProcessList FND_CONCURRENT.SERVICE_PROCESS_TAB_TYPE;
1439: l_ServiceInstanceId number := 0;
1440: p_num_of_threads number;
1441: l_InstanceName varchar2(30);
1442: l_Parameters varchar2(2000);

Line 1450: l_ServiceInstanceList := FND_CONCURRENT.GET_SERVICE_INSTANCES(svc_handle);

1446: num_of_threads := 0;
1447:
1448: BEGIN
1449:
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

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 1474: l_SIProcessList := FND_CONCURRENT.GET_SERVICE_PROCESSES

1470: l_InstanceName := l_ServiceInstanceList(i).INSTANCE_NAME;
1471:
1472: BEGIN
1473:
1474: l_SIProcessList := FND_CONCURRENT.GET_SERVICE_PROCESSES
1475: (appl_short_name => 'XDP',
1476: svc_instance_name => l_InstanceName,
1477: proc_state => 'ACTIVE');
1478:

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 1615: from fnd_concurrent_queues a

1611: is
1612:
1613: cursor c_GetConcQName is
1614: select a.concurrent_queue_name
1615: from fnd_concurrent_queues a
1616: where a.concurrent_queue_id = ConcQID and
1617: a.application_id = 535;
1618:
1619: l_ConcQName varchar2(30) := '';

Line 1648: from fnd_concurrent_queues a

1644: is
1645:
1646: cursor c_GetConcQID is
1647: select a.concurrent_queue_id
1648: from fnd_concurrent_queues a
1649: where upper(a.concurrent_queue_name) = upper(ConcQName);
1650:
1651: l_ConcQID number := -1;
1652: begin