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_FILE

Line 63: FND_FILE.put_line(FND_FILE.log, 'Checking if ICM is running');

59:
60: begin
61:
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,

Line 76: FND_FILE.put_line(FND_FILE.log,

72: 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

Line 82: FND_FILE.put_line(FND_FILE.log,'ICM target processes: '||l_targetp||', active processes: '||l_activep);

78: END IF;
79: return false;
80: else
81: if Caller = 'CONC' then
82: FND_FILE.put_line(FND_FILE.log,'ICM target processes: '||l_targetp||', active processes: '||l_activep);
83: END IF;
84: if l_activep > 0 then
85: if Caller = 'CONC' then
86: FND_FILE.put_line(FND_FILE.log,'ICM is running');

Line 86: FND_FILE.put_line(FND_FILE.log,'ICM is running');

82: FND_FILE.put_line(FND_FILE.log,'ICM target processes: '||l_targetp||', active processes: '||l_activep);
83: END IF;
84: if l_activep > 0 then
85: if Caller = 'CONC' then
86: FND_FILE.put_line(FND_FILE.log,'ICM is running');
87: END IF;
88: return true;
89: else
90: if Caller = 'CONC' then

Line 91: FND_FILE.put_line(FND_FILE.log,'ICM is not running, services cannot be managed');

87: END IF;
88: return true;
89: else
90: if Caller = 'CONC' then
91: FND_FILE.put_line(FND_FILE.log,'ICM is not running, services cannot be managed');
92: END IF;
93: return false;
94: end if;
95: end if;

Line 163: FND_FILE.put_line(FND_FILE.log,'Stopping adapters for :'||

159: -- Remove leading, trailing blanks and upper case the FE names
160: l_temp_fe_name := UPPER (LTRIM (RTRIM (FeName)));
161:
162: if FeOptions = 'INCLUDE' then
163: FND_FILE.put_line(FND_FILE.log,'Stopping adapters for :'||
164: l_temp_fe_name||': only');
165: else
166: FND_FILE.put_line(FND_FILE.log,'Stopping adapters for FE(s) other than :'||
167: l_temp_fe_name||':');

Line 166: FND_FILE.put_line(FND_FILE.log,'Stopping adapters for FE(s) other than :'||

162: if FeOptions = 'INCLUDE' then
163: FND_FILE.put_line(FND_FILE.log,'Stopping adapters for :'||
164: l_temp_fe_name||': only');
165: else
166: FND_FILE.put_line(FND_FILE.log,'Stopping adapters for FE(s) other than :'||
167: l_temp_fe_name||':');
168: end if;
169:
170: -- Replace embedded commas by blanks and finally append a blank to the FE name

Line 181: FND_FILE.put_line(FND_FILE.log,'None of the adapters stoppped');

177:
178: -- if all adapters are required to be stoppped i.e. complete application stop
179: -- Controller stop will take care of its adapters
180:
181: FND_FILE.put_line(FND_FILE.log,'None of the adapters stoppped');
182: return true;
183:
184: END IF; -- End of if which checks the user request type
185:

Line 212: FND_FILE.put_line(FND_FILE.log,'Attempting to stop adapter '||

208: -- in XDP_ADAPTER_REG table accordingly
209: -- and will submit a admin request if required i.e. if the
210: -- Adapter cannot be locked
211:
212: FND_FILE.put_line(FND_FILE.log,'Attempting to stop adapter '||
213: v_AdapterData.adapter_display_name);
214:
215: XDP_ADAPTER.Stop_Adapter (
216: v_AdapterData.channel_name,

Line 223: FND_FILE.put_line(FND_FILE.log,

219: IF ((l_retcode <> 0) and
220: (l_retcode <> XDP_ADAPTER.pv_retAdapterInvalidState) and
221: (l_retcode <> XDP_ADAPTER.pv_retAdapterCannotLockReqSub)) THEN
222: l_SomeError := TRUE;
223: FND_FILE.put_line(FND_FILE.log,
224: 'Error in stopping adapter '||
225: v_AdapterData.adapter_display_name);
226: FND_FILE.put_line(FND_FILE.log,l_errbuf);
227: elsif (l_retcode = XDP_ADAPTER.pv_retAdapterCannotLockReqSub) then

Line 226: FND_FILE.put_line(FND_FILE.log,l_errbuf);

222: l_SomeError := TRUE;
223: FND_FILE.put_line(FND_FILE.log,
224: 'Error in stopping adapter '||
225: v_AdapterData.adapter_display_name);
226: FND_FILE.put_line(FND_FILE.log,l_errbuf);
227: elsif (l_retcode = XDP_ADAPTER.pv_retAdapterCannotLockReqSub) then
228: FND_FILE.put_line(FND_FILE.log,
229: 'Stop request for adapter '||v_AdapterData.adapter_display_name||
230: ' successfully submitted');

Line 228: FND_FILE.put_line(FND_FILE.log,

224: 'Error in stopping adapter '||
225: v_AdapterData.adapter_display_name);
226: FND_FILE.put_line(FND_FILE.log,l_errbuf);
227: elsif (l_retcode = XDP_ADAPTER.pv_retAdapterCannotLockReqSub) then
228: FND_FILE.put_line(FND_FILE.log,
229: 'Stop request for adapter '||v_AdapterData.adapter_display_name||
230: ' successfully submitted');
231: FND_FILE.put_line(FND_FILE.log,l_errbuf);
232: else

Line 231: FND_FILE.put_line(FND_FILE.log,l_errbuf);

227: elsif (l_retcode = XDP_ADAPTER.pv_retAdapterCannotLockReqSub) then
228: FND_FILE.put_line(FND_FILE.log,
229: 'Stop request for adapter '||v_AdapterData.adapter_display_name||
230: ' successfully submitted');
231: FND_FILE.put_line(FND_FILE.log,l_errbuf);
232: else
233: -- Success and InvalidState case
234: -- InvalidState means already stopped
235:

Line 236: FND_FILE.put_line(FND_FILE.log,

232: else
233: -- Success and InvalidState case
234: -- InvalidState means already stopped
235:
236: FND_FILE.put_line(FND_FILE.log,
237: 'Adapter '||v_AdapterData.adapter_display_name||
238: ' stopped successfully');
239: END IF;
240:

Line 247: FND_FILE.put_line(FND_FILE.log,'Attempting to stop adapter '||

243: -- Stop adapter instance in abbort mode
244: -- and also update the adapter instance entry
245: -- in XDP_ADAPTER_REG table accordingly
246:
247: FND_FILE.put_line(FND_FILE.log,'Attempting to stop adapter '||
248: v_AdapterData.adapter_display_name||
249: ' in abort mode');
250:
251: XDP_ADAPTER.Terminate_Adapter (

Line 257: FND_FILE.put_line(FND_FILE.log,

253: l_retcode, l_errbuf);
254:
255: IF l_retcode <> 0 THEN
256: l_SomeError := TRUE;
257: FND_FILE.put_line(FND_FILE.log,
258: 'Error in terminating adapter '||
259: v_AdapterData.adapter_display_name);
260: FND_FILE.put_line(FND_FILE.log,l_errbuf);
261: else

Line 260: FND_FILE.put_line(FND_FILE.log,l_errbuf);

256: l_SomeError := TRUE;
257: FND_FILE.put_line(FND_FILE.log,
258: 'Error in terminating adapter '||
259: v_AdapterData.adapter_display_name);
260: FND_FILE.put_line(FND_FILE.log,l_errbuf);
261: else
262: FND_FILE.put_line(FND_FILE.log,
263: 'Adapter '||
264: v_AdapterData.adapter_display_name||

Line 262: FND_FILE.put_line(FND_FILE.log,

258: 'Error in terminating adapter '||
259: v_AdapterData.adapter_display_name);
260: FND_FILE.put_line(FND_FILE.log,l_errbuf);
261: else
262: FND_FILE.put_line(FND_FILE.log,
263: 'Adapter '||
264: v_AdapterData.adapter_display_name||
265: ' Aborted successfully');
266:

Line 289: FND_FILE.put_line(FND_FILE.log,'SQL code: '||SQLCODE);

285: WHEN OTHERS THEN
286: IF c_getAdapterInfoAll%ISOPEN THEN
287: CLOSE c_getAdapterInfoAll;
288: END IF;
289: FND_FILE.put_line(FND_FILE.log,'SQL code: '||SQLCODE);
290: FND_FILE.put_line(FND_FILE.log,'SQL message string: '||SQLERRM);
291: return false;
292: END Stop_Adapters;
293:

Line 290: FND_FILE.put_line(FND_FILE.log,'SQL message string: '||SQLERRM);

286: IF c_getAdapterInfoAll%ISOPEN THEN
287: CLOSE c_getAdapterInfoAll;
288: END IF;
289: FND_FILE.put_line(FND_FILE.log,'SQL code: '||SQLCODE);
290: FND_FILE.put_line(FND_FILE.log,'SQL message string: '||SQLERRM);
291: return false;
292: END Stop_Adapters;
293:
294: -- ************************** STOP_SERVICE_INSTANCES *******************************

Line 320: FND_FILE.put_line(FND_FILE.log, 'Retrieving services instances for '||p_ServiceHandle);

316:
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

Line 326: FND_FILE.put_line(FND_FILE.log, 'Service instances found: '||

322: (svc_handle => p_ServiceHandle);
323:
324: if (l_ServiceInstanceList.COUNT > 0) then
325:
326: FND_FILE.put_line(FND_FILE.log, 'Service instances found: '||
327: l_ServiceInstanceList.COUNT);
328:
329: for i in 1..l_ServiceInstanceList.COUNT loop
330: if (l_ServiceInstanceList.EXISTS(i)) then

Line 365: FND_FILE.put_line(FND_FILE.log,

361: pmon_method => l_pmon_method,
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

Line 368: FND_FILE.put_line(FND_FILE.log,'Target processes: '||l_targetp||', active processes: '||l_activep);

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
371: l_ServiceToBeStopped := TRUE;
372: END IF;

Line 382: FND_FILE.put_line(FND_FILE.log,

378:
379: l_ReqID := 0;
380:
381: if StopOptions = 'NORMAL' then
382: FND_FILE.put_line(FND_FILE.log,
383: 'Submitting DEACTIVATE request for service instance: '||
384: l_ServiceInstanceList(i).INSTANCE_NAME);
385: l_ReqID := FND_REQUEST.SUBMIT_SVC_CTL_REQUEST (
386: command => 'DEACTIVATE',

Line 390: FND_FILE.put_line(FND_FILE.log,

386: command => 'DEACTIVATE',
387: service => l_ServiceInstanceList(i).INSTANCE_NAME,
388: service_app => 'XDP');
389: else
390: FND_FILE.put_line(FND_FILE.log,
391: 'Submitting TERMINATE request for service instance: '||
392: l_ServiceInstanceList(i).INSTANCE_NAME);
393: l_ReqID := FND_REQUEST.SUBMIT_SVC_CTL_REQUEST (
394: command => 'ABORT',

Line 400: FND_FILE.put_line(FND_FILE.log,

396: service_app => 'XDP');
397: END IF;
398:
399: if l_ReqID > 0 then
400: FND_FILE.put_line(FND_FILE.log,
401: 'Request : '||
402: l_ReqID||
403: ' successfully submitted');
404: else

Line 405: FND_FILE.put_line(FND_FILE.log,

401: 'Request : '||
402: l_ReqID||
403: ' successfully submitted');
404: else
405: FND_FILE.put_line(FND_FILE.log,
406: 'Error, request could not be successfully submitted');
407: END IF;
408: else
409: FND_FILE.put_line(FND_FILE.log,

Line 409: FND_FILE.put_line(FND_FILE.log,

405: FND_FILE.put_line(FND_FILE.log,
406: 'Error, request could not be successfully submitted');
407: END IF;
408: else
409: FND_FILE.put_line(FND_FILE.log,
410: 'Service instance: '||
411: l_ServiceInstanceList(i).INSTANCE_NAME||
412: ' ignored, has state: '||
413: l_ServiceInstanceList(i).STATE);

Line 418: FND_FILE.put_line(FND_FILE.log, 'No service instances found');

414: END IF;
415: END IF;
416: END LOOP;
417: else
418: FND_FILE.put_line(FND_FILE.log, 'No service instances found');
419: END IF;
420:
421: end Stop_Service_Instances;
422:

Line 464: FND_FILE.put_line(FND_FILE.log,'Application shutdown initiated');

460: errbuf := '';
461:
462: if FeName is NULL and FeOptions = 'ALL' then
463:
464: FND_FILE.put_line(FND_FILE.log,'Application shutdown initiated');
465:
466: -- ************************************************************
467: -- Check if ICM is running
468: -- ************************************************************

Line 473: FND_FILE.put_line(FND_FILE.log, errbuf);

469:
470: if (not Is_ICM_Running('CONC')) then
471: retCode := -1;
472: errbuf := 'Cannot stop application as ICM is not running';
473: FND_FILE.put_line(FND_FILE.log, errbuf);
474: COMMIT;
475: return;
476: end if;
477:

Line 483: FND_FILE.put_line(FND_FILE.log,'Stopping Controller services');

479: -- Stop all non DISABLED, non INACTIVE Controller services instances
480: -- Controller stop also stops all its Adapters
481: -- ************************************************************
482:
483: FND_FILE.put_line(FND_FILE.log,'Stopping Controller services');
484: begin
485: Stop_Service_Instances (p_ServiceHandle => 'XDPCTRLS',
486: StopOptions => StopOptions);
487: FND_FILE.put_line(FND_FILE.log,'Requests to stop Controller services submitted successfully');

Line 487: FND_FILE.put_line(FND_FILE.log,'Requests to stop Controller services submitted successfully');

483: FND_FILE.put_line(FND_FILE.log,'Stopping Controller services');
484: begin
485: Stop_Service_Instances (p_ServiceHandle => 'XDPCTRLS',
486: StopOptions => StopOptions);
487: FND_FILE.put_line(FND_FILE.log,'Requests to stop Controller services submitted successfully');
488: EXCEPTION
489: WHEN OTHERS THEN
490:
491: l_SomeError := TRUE;

Line 492: FND_FILE.put_line(FND_FILE.log,

488: EXCEPTION
489: WHEN OTHERS THEN
490:
491: l_SomeError := TRUE;
492: FND_FILE.put_line(FND_FILE.log,
493: 'Encountered error while stopping Controller services');
494: FND_FILE.put_line(FND_FILE.log, 'Error: ' || SUBSTR(errbuf,1,200));
495: FND_FILE.put_line (FND_FILE.log, 'SQLCODE: '||SQLCODE);
496: FND_FILE.put_line (FND_FILE.log, 'SQLERRM: '||SQLERRM);

Line 494: FND_FILE.put_line(FND_FILE.log, 'Error: ' || SUBSTR(errbuf,1,200));

490:
491: l_SomeError := TRUE;
492: FND_FILE.put_line(FND_FILE.log,
493: 'Encountered error while stopping Controller services');
494: FND_FILE.put_line(FND_FILE.log, 'Error: ' || SUBSTR(errbuf,1,200));
495: FND_FILE.put_line (FND_FILE.log, 'SQLCODE: '||SQLCODE);
496: FND_FILE.put_line (FND_FILE.log, 'SQLERRM: '||SQLERRM);
497: commit;
498: -- Continue, do as much as possible

Line 495: FND_FILE.put_line (FND_FILE.log, 'SQLCODE: '||SQLCODE);

491: l_SomeError := TRUE;
492: FND_FILE.put_line(FND_FILE.log,
493: 'Encountered error while stopping Controller services');
494: FND_FILE.put_line(FND_FILE.log, 'Error: ' || SUBSTR(errbuf,1,200));
495: FND_FILE.put_line (FND_FILE.log, 'SQLCODE: '||SQLCODE);
496: FND_FILE.put_line (FND_FILE.log, 'SQLERRM: '||SQLERRM);
497: commit;
498: -- Continue, do as much as possible
499: end;

Line 496: FND_FILE.put_line (FND_FILE.log, 'SQLERRM: '||SQLERRM);

492: FND_FILE.put_line(FND_FILE.log,
493: 'Encountered error while stopping Controller services');
494: FND_FILE.put_line(FND_FILE.log, 'Error: ' || SUBSTR(errbuf,1,200));
495: FND_FILE.put_line (FND_FILE.log, 'SQLCODE: '||SQLCODE);
496: FND_FILE.put_line (FND_FILE.log, 'SQLERRM: '||SQLERRM);
497: commit;
498: -- Continue, do as much as possible
499: end;
500:

Line 505: FND_FILE.put_line(FND_FILE.log,'Stopping Queue services');

501: -- ************************************************************
502: -- Stop all non DISABLED, non INACTIVE application queue service instances
503: -- ************************************************************
504:
505: FND_FILE.put_line(FND_FILE.log,'Stopping Queue services');
506:
507: for v_ServiceTypeData in c_getQServiceTypes loop
508: FND_FILE.put_line(FND_FILE.log,'Stopping '||v_ServiceTypeData.SERVICE_NAME);
509:

Line 508: FND_FILE.put_line(FND_FILE.log,'Stopping '||v_ServiceTypeData.SERVICE_NAME);

504:
505: FND_FILE.put_line(FND_FILE.log,'Stopping Queue services');
506:
507: for v_ServiceTypeData in c_getQServiceTypes loop
508: FND_FILE.put_line(FND_FILE.log,'Stopping '||v_ServiceTypeData.SERVICE_NAME);
509:
510: begin
511: Stop_Service_Instances (p_ServiceHandle =>
512: v_ServiceTypeData.SERVICE_HANDLE,

Line 514: FND_FILE.put_line(FND_FILE.log,

510: begin
511: Stop_Service_Instances (p_ServiceHandle =>
512: v_ServiceTypeData.SERVICE_HANDLE,
513: StopOptions => StopOptions);
514: FND_FILE.put_line(FND_FILE.log,
515: 'Requests to stop '||v_ServiceTypeData.SERVICE_NAME||
516: ' submitted successfully');
517: EXCEPTION
518: WHEN OTHERS THEN

Line 520: FND_FILE.put_line(FND_FILE.log,

516: ' submitted successfully');
517: EXCEPTION
518: WHEN OTHERS THEN
519: l_SomeError := TRUE;
520: FND_FILE.put_line(FND_FILE.log,
521: 'Encountered error when stopping services');
522: FND_FILE.put_line (FND_FILE.log, 'SQLCODE: '||SQLCODE);
523: FND_FILE.put_line (FND_FILE.log, 'SQLERRM: '||SQLERRM);
524: commit;

Line 522: FND_FILE.put_line (FND_FILE.log, 'SQLCODE: '||SQLCODE);

518: WHEN OTHERS THEN
519: l_SomeError := TRUE;
520: FND_FILE.put_line(FND_FILE.log,
521: 'Encountered error when stopping services');
522: FND_FILE.put_line (FND_FILE.log, 'SQLCODE: '||SQLCODE);
523: FND_FILE.put_line (FND_FILE.log, 'SQLERRM: '||SQLERRM);
524: commit;
525: -- Continue, do as much as possible
526: end;

Line 523: FND_FILE.put_line (FND_FILE.log, 'SQLERRM: '||SQLERRM);

519: l_SomeError := TRUE;
520: FND_FILE.put_line(FND_FILE.log,
521: 'Encountered error when stopping services');
522: FND_FILE.put_line (FND_FILE.log, 'SQLCODE: '||SQLCODE);
523: FND_FILE.put_line (FND_FILE.log, 'SQLERRM: '||SQLERRM);
524: commit;
525: -- Continue, do as much as possible
526: end;
527:

Line 538: FND_FILE.put_line(FND_FILE.log,

534: -- instances have been terminated. If ICM has not picked up the termination request
535: -- verify will still find adapters to be running, but there is nothing much we can do
536:
537: if (l_SomeError = FALSE) then
538: FND_FILE.put_line(FND_FILE.log,
539: 'Application stop request completed successfully');
540: else
541: retcode := -1;
542: errbuf := 'Application stop request completed with warnings or errors';

Line 543: FND_FILE.put_line(FND_FILE.log, errbuf);

539: 'Application stop request completed successfully');
540: else
541: retcode := -1;
542: errbuf := 'Application stop request completed with warnings or errors';
543: FND_FILE.put_line(FND_FILE.log, errbuf);
544: END IF;
545: else
546: l_SomeError := Stop_Adapters (
547: StopOptions => StopOptions,

Line 554: FND_FILE.put_line(FND_FILE.log, errbuf);

550:
551: if (l_SomeError = FALSE) then
552: retcode := -1;
553: errbuf := 'Adapters stopped with warnings or errors';
554: FND_FILE.put_line(FND_FILE.log, errbuf);
555: else
556: FND_FILE.put_line(FND_FILE.log,
557: 'Adapters stopped successfully');
558: END IF;

Line 556: FND_FILE.put_line(FND_FILE.log,

552: retcode := -1;
553: errbuf := 'Adapters stopped with warnings or errors';
554: FND_FILE.put_line(FND_FILE.log, errbuf);
555: else
556: FND_FILE.put_line(FND_FILE.log,
557: 'Adapters stopped successfully');
558: END IF;
559: end if;
560:

Line 569: FND_FILE.put_line(FND_FILE.log,'SQL code: '||SQLCODE);

565: WHEN OTHERS THEN
566: IF c_getQServiceTypes%ISOPEN THEN
567: CLOSE c_getQServiceTypes;
568: end if;
569: FND_FILE.put_line(FND_FILE.log,'SQL code: '||SQLCODE);
570: FND_FILE.put_line(FND_FILE.log,'SQL message string: '||SQLERRM);
571: retcode := SQLCODE;
572: errbuf := SUBSTR(SQLERRM,1,200);
573: COMMIT;

Line 570: FND_FILE.put_line(FND_FILE.log,'SQL message string: '||SQLERRM);

566: IF c_getQServiceTypes%ISOPEN THEN
567: CLOSE c_getQServiceTypes;
568: end if;
569: FND_FILE.put_line(FND_FILE.log,'SQL code: '||SQLCODE);
570: FND_FILE.put_line(FND_FILE.log,'SQL message string: '||SQLERRM);
571: retcode := SQLCODE;
572: errbuf := SUBSTR(SQLERRM,1,200);
573: COMMIT;
574:

Line 645: FND_FILE.put_line(FND_FILE.log,

641:
642: l_CPID number := 0;
643:
644: begin
645: FND_FILE.put_line(FND_FILE.log,
646: 'Checking the status of request: ' || to_char(ReqID));
647:
648: Get_Max_Tries(l_Interval, l_MaxTries);
649:

Line 650: FND_FILE.put_line(FND_FILE.log,

646: 'Checking the status of request: ' || to_char(ReqID));
647:
648: Get_Max_Tries(l_Interval, l_MaxTries);
649:
650: FND_FILE.put_line(FND_FILE.log,
651: 'Tries: '||l_MaxTries||', wait between retries: '||l_Interval);
652:
653: l_Tries := 1;
654:

Line 658: FND_FILE.put_line(FND_FILE.log, 'Try #: ' || to_char(l_Tries));

654:
655: while (l_Tries <= l_MaxTries) loop
656:
657: if (l_Tries > 1) then
658: FND_FILE.put_line(FND_FILE.log, 'Try #: ' || to_char(l_Tries));
659: DBMS_LOCK.SLEEP(l_Interval);
660: end if;
661:
662: -- Initialize out variables with NULL string

Line 671: FND_FILE.put_line(FND_FILE.log,

667: status, dev_phase, dev_status,
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:

Line 676: 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,
677: 'Request Dev. Phase: ' || dev_phase || 'Status: ' || dev_status);
678: FND_FILE.put_line(FND_FILE.log,
679: 'Request User Phase: ' || phase || 'Status: ' || status);
680:

Line 678: FND_FILE.put_line(FND_FILE.log,

674: end if;
675:
676: FND_FILE.put_line(FND_FILE.log,
677: 'Request Dev. Phase: ' || dev_phase || 'Status: ' || dev_status);
678: FND_FILE.put_line(FND_FILE.log,
679: 'Request User Phase: ' || phase || 'Status: ' || status);
680:
681: if upper(dev_phase) in ('COMPLETE') then
682:

Line 685: FND_FILE.put_line(FND_FILE.log,'Request has completed');

681: if upper(dev_phase) in ('COMPLETE') then
682:
683: if upper(dev_status) = 'NORMAL' then
684:
685: FND_FILE.put_line(FND_FILE.log,'Request has completed');
686:
687: exit;
688: else
689: FND_FILE.put_line(FND_FILE.log,

Line 689: FND_FILE.put_line(FND_FILE.log,

685: FND_FILE.put_line(FND_FILE.log,'Request has completed');
686:
687: exit;
688: else
689: FND_FILE.put_line(FND_FILE.log,
690: 'Request didnot complete successfully');
691: return false;
692: end if;
693:

Line 699: FND_FILE.put_line(FND_FILE.log,

695:
696: -- Irrespective of dev_status request
697: -- should NOT enter this phase
698:
699: FND_FILE.put_line(FND_FILE.log,
700: 'Request not started. Check the Internal Concurrent Manager process and try again');
701: return false;
702:
703: else

Line 704: FND_FILE.put_line(FND_FILE.log,'Request not yet completed');

700: 'Request not started. Check the Internal Concurrent Manager process and try again');
701: return false;
702:
703: else
704: FND_FILE.put_line(FND_FILE.log,'Request not yet completed');
705: l_Tries := l_Tries + 1;
706: end if;
707: end loop;
708:

Line 713: FND_FILE.put_line(FND_FILE.log,'Service has started. CPID: '||l_CPID);

709: while (l_Tries <= l_MaxTries) loop
710:
711: l_CPID := Fetch_CPID(ConcQID => ServiceInstanceId, Caller => 'CONC');
712: if l_CPID > 0 then
713: FND_FILE.put_line(FND_FILE.log,'Service has started. CPID: '||l_CPID);
714: return true;
715: else
716: FND_FILE.put_line(FND_FILE.log,'No active process for Service found');
717: end if;

Line 716: FND_FILE.put_line(FND_FILE.log,'No active process for Service found');

712: if l_CPID > 0 then
713: FND_FILE.put_line(FND_FILE.log,'Service has started. CPID: '||l_CPID);
714: return true;
715: else
716: FND_FILE.put_line(FND_FILE.log,'No active process for Service found');
717: end if;
718:
719: l_Tries := l_Tries + 1;
720:

Line 722: FND_FILE.put_line(FND_FILE.log, 'Try #: ' || to_char(l_Tries));

718:
719: l_Tries := l_Tries + 1;
720:
721: if (l_Tries < l_MaxTries) then
722: FND_FILE.put_line(FND_FILE.log, 'Try #: ' || to_char(l_Tries));
723: DBMS_LOCK.SLEEP(l_Interval);
724: end if;
725:
726: end loop;

Line 728: FND_FILE.put_line(FND_FILE.log,

724: end if;
725:
726: end loop;
727:
728: FND_FILE.put_line(FND_FILE.log,
729: 'Request has not completed yet. Check the Internal Concurrent Manager process and try again');
730: return false;
731:
732: end Check_Request_Status ;

Line 767: FND_FILE.put_line(FND_FILE.log,

763: UPPER(p_ServiceInstanceList(i).INSTANCE_NAME) then
764:
765: l_ControllerReqSubmitted := true;
766:
767: FND_FILE.put_line(FND_FILE.log,
768: 'Verifying Controller instance '||
769: p_ServiceInstanceList(i).INSTANCE_NAME||
770: ', conc. req.: '||p_ServiceInstanceList(i).Req_ID);
771:

Line 780: FND_FILE.put_line(FND_FILE.log,

776: if l_Flag = false then
777: -- Request did not COMPLETE after
778: -- retrys
779:
780: FND_FILE.put_line(FND_FILE.log,
781: 'Could not verify Controller instance '||
782: p_ServiceInstanceList(i).INSTANCE_NAME);
783: return false;
784: else

Line 785: FND_FILE.put_line(FND_FILE.log,

781: 'Could not verify Controller instance '||
782: p_ServiceInstanceList(i).INSTANCE_NAME);
783: return false;
784: else
785: FND_FILE.put_line(FND_FILE.log,
786: 'Successfully verified Controller instance '||
787: p_ServiceInstanceList(i).INSTANCE_NAME);
788: end if;
789: end if;

Line 794: FND_FILE.put_line(FND_FILE.log, 'Did not verify Controller instance '||

790: end if;
791: end loop;
792:
793: if l_ControllerReqSubmitted = false then
794: FND_FILE.put_line(FND_FILE.log, 'Did not verify Controller instance '||
795: v_GetSvcID.concurrent_queue_name||' as request to start not submitted');
796: end if;
797:
798: end loop;

Line 800: FND_FILE.put_line(FND_FILE.log, 'No Controller instances to verify');

796: end if;
797:
798: end loop;
799: else
800: FND_FILE.put_line(FND_FILE.log, 'No Controller instances to verify');
801: end if;
802:
803: return true;
804:

Line 836: FND_FILE.put_line(FND_FILE.log, 'Retrieving services instances for '||p_ServiceHandle);

832: begin
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

Line 842: FND_FILE.put_line(FND_FILE.log, 'Service instances found: '||

838: (svc_handle => p_ServiceHandle);
839:
840: if (l_ServiceInstanceList.COUNT > 0) then
841:
842: FND_FILE.put_line(FND_FILE.log, 'Service instances found: '||
843: l_ServiceInstanceList.COUNT);
844:
845: for i in 1..l_ServiceInstanceList.COUNT loop
846:

Line 881: FND_FILE.put_line(FND_FILE.log,

877: pmon_method => l_pmon_method,
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

Line 884: FND_FILE.put_line(FND_FILE.log,'Target processes: '||l_targetp||', active processes: '||l_activep);

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
887: l_ServiceToBeStarted := TRUE;
888: END IF;

Line 895: FND_FILE.put_line(FND_FILE.log,

891: END IF;
892:
893: if l_ServiceToBeStarted = TRUE then
894:
895: FND_FILE.put_line(FND_FILE.log,
896: 'Submitting ACTIVATE request for service instance: '||
897: l_ServiceInstanceList(i).INSTANCE_NAME);
898: l_ReqID := 0;
899: l_ReqID := FND_REQUEST.SUBMIT_SVC_CTL_REQUEST (

Line 909: FND_FILE.put_line(FND_FILE.log,

905: l_Count := l_Count + 1;
906: l_ServiceInstanceStarted(l_Count).INSTANCE_NAME :=
907: l_ServiceInstanceList(i).INSTANCE_NAME;
908: l_ServiceInstanceStarted(l_Count).Req_ID := l_ReqID;
909: FND_FILE.put_line(FND_FILE.log,
910: 'Request : '||
911: l_ReqID||
912: ' successfully submitted');
913: else

Line 914: FND_FILE.put_line(FND_FILE.log,

910: 'Request : '||
911: l_ReqID||
912: ' successfully submitted');
913: else
914: FND_FILE.put_line(FND_FILE.log,
915: 'Error, request could not be successfully submitted');
916: END IF;
917: else
918: FND_FILE.put_line(FND_FILE.log,

Line 918: FND_FILE.put_line(FND_FILE.log,

914: FND_FILE.put_line(FND_FILE.log,
915: 'Error, request could not be successfully submitted');
916: END IF;
917: else
918: FND_FILE.put_line(FND_FILE.log,
919: 'Service instance: '||
920: l_ServiceInstanceList(i).INSTANCE_NAME||
921: ' ignored, has state: '||
922: l_ServiceInstanceList(i).STATE);

Line 927: FND_FILE.put_line(FND_FILE.log, 'No service instances found');

923: END IF;
924: END IF;
925: END LOOP;
926: else
927: FND_FILE.put_line(FND_FILE.log, 'No service instances found');
928: END IF;
929:
930: return l_ServiceInstanceStarted;
931:

Line 993: FND_FILE.put_line(FND_FILE.log,'Application Start Initiated.');

989: l_retCode := TRUE;
990: retcode := 0;
991: errbuf := '';
992:
993: FND_FILE.put_line(FND_FILE.log,'Application Start Initiated.');
994:
995: -- ************************************************************
996: -- Check if ICM is running
997: -- ************************************************************

Line 1002: FND_FILE.put_line(FND_FILE.log, errbuf);

998:
999: if (not Is_ICM_Running('CONC')) then
1000: retCode := -1;
1001: errbuf := 'Cannot start application as ICM is not running';
1002: FND_FILE.put_line(FND_FILE.log, errbuf);
1003: COMMIT;
1004: return;
1005: end if;
1006:

Line 1011: FND_FILE.put_line(FND_FILE.log,'Starting Controller services');

1007: -- ************************************************************
1008: -- Start INACTIVE Controller services instances
1009: -- ************************************************************
1010:
1011: FND_FILE.put_line(FND_FILE.log,'Starting Controller services');
1012: begin
1013: l_ServiceInstanceStartedC := Start_Service_Instances (p_ServiceHandle => 'XDPCTRLS');
1014:
1015: EXCEPTION

Line 1019: FND_FILE.put_line(FND_FILE.log,

1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: retCode := SQLCODE;
1018: errbuf := SQLERRM;
1019: FND_FILE.put_line(FND_FILE.log,
1020: 'Encountered error when starting Controller services. Aborting Start Request');
1021: FND_FILE.put_line(FND_FILE.log, 'Error: ' || SUBSTR(errbuf,1,200));
1022: COMMIT;
1023: return;

Line 1021: FND_FILE.put_line(FND_FILE.log, 'Error: ' || SUBSTR(errbuf,1,200));

1017: retCode := SQLCODE;
1018: errbuf := SQLERRM;
1019: FND_FILE.put_line(FND_FILE.log,
1020: 'Encountered error when starting Controller services. Aborting Start Request');
1021: FND_FILE.put_line(FND_FILE.log, 'Error: ' || SUBSTR(errbuf,1,200));
1022: COMMIT;
1023: return;
1024: end;
1025: FND_FILE.put_line(FND_FILE.log,'Requests to start Controller services submitted successfully');

Line 1025: FND_FILE.put_line(FND_FILE.log,'Requests to start Controller services submitted successfully');

1021: FND_FILE.put_line(FND_FILE.log, 'Error: ' || SUBSTR(errbuf,1,200));
1022: COMMIT;
1023: return;
1024: end;
1025: FND_FILE.put_line(FND_FILE.log,'Requests to start Controller services submitted successfully');
1026:
1027: -- ************************************************************
1028: -- Start INACTIVE application queue service instances
1029: -- ************************************************************

Line 1032: FND_FILE.put_line(FND_FILE.log,'Starting '||v_ServiceTypeData.SERVICE_NAME);

1028: -- Start INACTIVE application queue service instances
1029: -- ************************************************************
1030:
1031: for v_ServiceTypeData in c_getQServiceTypes loop
1032: FND_FILE.put_line(FND_FILE.log,'Starting '||v_ServiceTypeData.SERVICE_NAME);
1033: -- Ignore the returned list
1034: begin
1035: l_ServiceInstanceStartedQ := Start_Service_Instances
1036: (p_ServiceHandle => v_ServiceTypeData.SERVICE_HANDLE);

Line 1041: FND_FILE.put_line(FND_FILE.log,

1037: EXCEPTION
1038: WHEN OTHERS THEN
1039: retCode := SQLCODE;
1040: errbuf := SQLERRM;
1041: FND_FILE.put_line(FND_FILE.log,
1042: 'Encountered error when starting services. Aborting Start Request');
1043: FND_FILE.put_line(FND_FILE.log, 'Error: ' || SUBSTR(errbuf,1,200));
1044: COMMIT;
1045: return;

Line 1043: FND_FILE.put_line(FND_FILE.log, 'Error: ' || SUBSTR(errbuf,1,200));

1039: retCode := SQLCODE;
1040: errbuf := SQLERRM;
1041: FND_FILE.put_line(FND_FILE.log,
1042: 'Encountered error when starting services. Aborting Start Request');
1043: FND_FILE.put_line(FND_FILE.log, 'Error: ' || SUBSTR(errbuf,1,200));
1044: COMMIT;
1045: return;
1046: end;
1047: END LOOP;

Line 1048: FND_FILE.put_line(FND_FILE.log,'Requests to start Queue services submitted successfully');

1044: COMMIT;
1045: return;
1046: end;
1047: END LOOP;
1048: FND_FILE.put_line(FND_FILE.log,'Requests to start Queue services submitted successfully');
1049:
1050: -- Check if Controller instances are really started
1051: FND_FILE.put_line(FND_FILE.log,'Verifying Controller processes');
1052: l_retCode := Verify_Controller_Instances (l_ServiceInstanceStartedC);

Line 1051: FND_FILE.put_line(FND_FILE.log,'Verifying Controller processes');

1047: END LOOP;
1048: FND_FILE.put_line(FND_FILE.log,'Requests to start Queue services submitted successfully');
1049:
1050: -- Check if Controller instances are really started
1051: FND_FILE.put_line(FND_FILE.log,'Verifying Controller processes');
1052: l_retCode := Verify_Controller_Instances (l_ServiceInstanceStartedC);
1053:
1054: if l_retCode = false then
1055: retCode := -1;

Line 1057: FND_FILE.put_line(FND_FILE.log, 'Error: ' || SUBSTR(errbuf,1,200));

1053:
1054: if l_retCode = false then
1055: retCode := -1;
1056: errbuf := 'Could not verify Controller processes';
1057: FND_FILE.put_line(FND_FILE.log, 'Error: ' || SUBSTR(errbuf,1,200));
1058: return;
1059: end if;
1060:
1061: -- ************************************************************

Line 1070: FND_FILE.put_line(FND_FILE.log,'Starting all adapters');

1066:
1067: if FeOptions = 'ALL' and FeName is NULL then
1068:
1069: -- Start all adapters
1070: FND_FILE.put_line(FND_FILE.log,'Starting all adapters');
1071: l_AdaptersRequiredTobeStarted := TRUE;
1072:
1073: elsif (((FeOptions = 'INCLUDE') or (FeOptions = 'EXCLUDE'))
1074: and (FeName IS NOT NULL)) then

Line 1082: FND_FILE.put_line(FND_FILE.log,

1078: -- Remove leading, trailing blanks and upper case the FE names
1079: l_temp_fe_name := UPPER (LTRIM (RTRIM (FeName)));
1080:
1081: if FeOptions = 'INCLUDE' then
1082: FND_FILE.put_line(FND_FILE.log,
1083: 'Starting adapters associated with FE(s) :'||l_temp_fe_name||': only');
1084: else
1085: FND_FILE.put_line(FND_FILE.log,
1086: 'Starting adapters for FE(s) other than :'||l_temp_fe_name||':');

Line 1085: FND_FILE.put_line(FND_FILE.log,

1081: if FeOptions = 'INCLUDE' then
1082: FND_FILE.put_line(FND_FILE.log,
1083: 'Starting adapters associated with FE(s) :'||l_temp_fe_name||': only');
1084: else
1085: FND_FILE.put_line(FND_FILE.log,
1086: 'Starting adapters for FE(s) other than :'||l_temp_fe_name||':');
1087: end if;
1088:
1089: -- Replace embedded commas by blanks and finally append a blank to the FE name

Line 1099: FND_FILE.put_line(FND_FILE.log,'No adapters started');

1095:
1096: else
1097: l_AdaptersRequiredTobeStarted := FALSE;
1098: -- Handles 'other' cases i.e. no adapters to be started
1099: FND_FILE.put_line(FND_FILE.log,'No adapters started');
1100: END IF;
1101:
1102: if l_AdaptersRequiredTobeStarted = TRUE then
1103:

Line 1135: FND_FILE.put_line(FND_FILE.log,

1131:
1132: -- Reset the error count and adapter status of the DeactivatedSystem StartOnDemand Adapter
1133: XDP_ADAPTER.Reset_SysDeactivated_Adapter (
1134: p_ChannelName => v_AdapterData.channel_name);
1135: FND_FILE.put_line(FND_FILE.log,
1136: 'Restart count and status of Start-on-demand Adapter '||
1137: v_AdapterData.adapter_display_name||
1138: ' successfully reinitialized');
1139:

Line 1146: FND_FILE.put_line(FND_FILE.log,

1142: XDP_ADAPTER.Reset_SysDeactivated_Adapter (
1143: p_ChannelName => v_AdapterData.channel_name,
1144: p_ResetStatusFlag => false);
1145:
1146: FND_FILE.put_line(FND_FILE.log,
1147: 'Restart count of Start-on-demand Adapter '||
1148: v_AdapterData.adapter_display_name||
1149: ' successfully reinitialized');
1150:

Line 1156: FND_FILE.put_line(FND_FILE.log,

1152: else
1153: -- For Automatic adapters START_ADAPTER will reset
1154: -- the restart count
1155:
1156: FND_FILE.put_line(FND_FILE.log,
1157: 'Attempting to start adapter :'||
1158: v_AdapterData.adapter_display_name||
1159: ': associated with FE :'||
1160: v_AdapterData.fulfillment_element_name||':');

Line 1168: FND_FILE.put_line(FND_FILE.log,

1164: p_retcode => retcode,
1165: p_errbuf => errbuf);
1166:
1167: IF retcode <> 0 THEN
1168: FND_FILE.put_line(FND_FILE.log,
1169: 'Error in starting adapter '||
1170: v_AdapterData.adapter_display_name);
1171: FND_FILE.put_line(FND_FILE.log,errbuf);
1172: l_retCode := FALSE;

Line 1171: FND_FILE.put_line(FND_FILE.log,errbuf);

1167: IF retcode <> 0 THEN
1168: FND_FILE.put_line(FND_FILE.log,
1169: 'Error in starting adapter '||
1170: v_AdapterData.adapter_display_name);
1171: FND_FILE.put_line(FND_FILE.log,errbuf);
1172: l_retCode := FALSE;
1173: else
1174: FND_FILE.put_line(FND_FILE.log,
1175: 'Adapter '||v_AdapterData.adapter_display_name||

Line 1174: FND_FILE.put_line(FND_FILE.log,

1170: v_AdapterData.adapter_display_name);
1171: FND_FILE.put_line(FND_FILE.log,errbuf);
1172: l_retCode := FALSE;
1173: else
1174: FND_FILE.put_line(FND_FILE.log,
1175: 'Adapter '||v_AdapterData.adapter_display_name||
1176: ' started successfully');
1177: END IF;
1178:

Line 1188: FND_FILE.put_line(FND_FILE.log, 'Application started successfully');

1184: END LOOP;
1185: end if;
1186:
1187: if (l_retCode = TRUE) then
1188: FND_FILE.put_line(FND_FILE.log, 'Application started successfully');
1189: else
1190: retcode := -1;
1191: errbuf := 'Application started with warnings or errors';
1192: FND_FILE.put_line(FND_FILE.log, errbuf);

Line 1192: FND_FILE.put_line(FND_FILE.log, errbuf);

1188: FND_FILE.put_line(FND_FILE.log, 'Application started successfully');
1189: else
1190: retcode := -1;
1191: errbuf := 'Application started with warnings or errors';
1192: FND_FILE.put_line(FND_FILE.log, errbuf);
1193: END IF;
1194:
1195: COMMIT;
1196:

Line 1206: FND_FILE.put_line(FND_FILE.log,'SQL code: '||SQLCODE);

1202: end if;
1203: IF c_getAdapterInfoAll%ISOPEN THEN
1204: CLOSE c_getAdapterInfoAll;
1205: end if;
1206: FND_FILE.put_line(FND_FILE.log,'SQL code: '||SQLCODE);
1207: FND_FILE.put_line(FND_FILE.log,'SQL message string: '||SQLERRM);
1208: retcode := SQLCODE;
1209: errbuf := SUBSTR(SQLERRM,1,200);
1210: COMMIT;

Line 1207: FND_FILE.put_line(FND_FILE.log,'SQL message string: '||SQLERRM);

1203: IF c_getAdapterInfoAll%ISOPEN THEN
1204: CLOSE c_getAdapterInfoAll;
1205: end if;
1206: FND_FILE.put_line(FND_FILE.log,'SQL code: '||SQLCODE);
1207: FND_FILE.put_line(FND_FILE.log,'SQL message string: '||SQLERRM);
1208: retcode := SQLCODE;
1209: errbuf := SUBSTR(SQLERRM,1,200);
1210: COMMIT;
1211:

Line 1279: FND_FILE.put_line(FND_FILE.log, 'Checking if ServiceInstanceId '||ConcQID||' is running');

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;
1281:
1282: l_SIProcessList.delete;
1283:

Line 1299: FND_FILE.put_line(FND_FILE.log, 'Target processes: '||l_targetp||', active processes: '||l_activep);

1295: 'Target processes: '||l_targetp||', active processes: '||l_activep);
1296: end if;
1297:
1298: if Caller = 'CONC' then
1299: FND_FILE.put_line(FND_FILE.log, 'Target processes: '||l_targetp||', active processes: '||l_activep);
1300: END IF;
1301:
1302: if l_activep > 0 and l_targetp > 0 then
1303:

Line 1311: FND_FILE.put_line(FND_FILE.log, 'Retrieving ACTIVE services processes for '||l_ConcQName);

1307: 'Retrieving ACTIVE services processes for '||l_ConcQName);
1308: end if;
1309:
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',

Line 1326: FND_FILE.put_line(FND_FILE.log, l_SIProcessList.COUNT||' ACTIVE processes for the instance found');

1322: 'ACTIVE processes for the instance found: '||l_SIProcessList.COUNT);
1323: end if;
1324:
1325: if Caller = 'CONC' then
1326: FND_FILE.put_line(FND_FILE.log, l_SIProcessList.COUNT||' ACTIVE processes for the instance found');
1327: END IF;
1328:
1329: for i in 1..l_SIProcessList.COUNT loop
1330:

Line 1350: FND_FILE.put_line(FND_FILE.log, 'No ACTIVE processes for Service found');

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');
1351: END IF;
1352: END IF;
1353:
1354: else

Line 1360: FND_FILE.put_line(FND_FILE.log, 'ACTIVE and TARGET processes not greater than 0, so service instance is not running');

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');
1361: END IF;
1362: end if;
1363: else
1364: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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