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.AD_PA_SUBMIT_REQUEST dependencies on FND_FILE

Line 564: fnd_file.put_line(fnd_file.log, 'Status Tracker: This request set is the'||

560:
561: -- Set the default value to 0 (Normal)
562: RETCODE := 0;
563:
564: fnd_file.put_line(fnd_file.log, 'Status Tracker: This request set is the'||
565: ' dummy request to track the status of individual requests and assign the'||
566: ' right status to the request set');
567:
568: -- Get the request id for the current request, ie, StatusTracker

Line 571: fnd_file.put_line(fnd_file.log, 'Current request id : '|| l_request_id);

567:
568: -- Get the request id for the current request, ie, StatusTracker
569: SELECT fnd_global.conc_request_id INTO l_request_id from dual;
570:
571: fnd_file.put_line(fnd_file.log, 'Current request id : '|| l_request_id);
572:
573: -- Get the request set id for the current request, ie, StatusTracker
574: SELECT parent_request_id INTO l_request_set_id FROM fnd_concurrent_requests
575: WHERE request_id =

Line 580: fnd_file.put_line(fnd_file.log, 'Current request set id : '|| l_request_set_id);

576: ( SELECT parent_request_id
577: FROM fnd_concurrent_requests
578: WHERE request_id = l_request_id );
579:
580: fnd_file.put_line(fnd_file.log, 'Current request set id : '|| l_request_set_id);
581:
582: -- Get the data for all the requests in the current request set
583: l_sub_requests := fnd_concurrent.get_sub_requests(l_request_set_id);
584:

Line 588: fnd_file.put_line(fnd_file.log, l_sub_requests(l_cnt).request_id ||' '||l_sub_requests(l_cnt).status);

584:
585: -- Check the status of each request within the request set and assign the highest value to RETCODE
586: l_cnt := l_sub_requests.first;
587: WHILE l_cnt IS NOT NULL LOOP
588: fnd_file.put_line(fnd_file.log, l_sub_requests(l_cnt).request_id ||' '||l_sub_requests(l_cnt).status);
589: IF (RETCODE <> 2 AND l_sub_requests(l_cnt).status = 'Warning') THEN
590: RETCODE := 1;
591: ELSIF (RETCODE <> 2 AND l_sub_requests(l_cnt).status = 'Error') THEN
592: RETCODE := 2;

Line 598: fnd_file.put_line(fnd_file.log,'Overall request set Status is Normal');

594: l_cnt := l_sub_requests.next(l_cnt);
595: END LOOP;
596:
597: IF (RETCODE = 0 ) THEN
598: fnd_file.put_line(fnd_file.log,'Overall request set Status is Normal');
599: ELSIF (RETCODE = 2 ) THEN
600: fnd_file.put_line(fnd_file.log,'Overall request set Status is Warning');
601: ELSE
602: fnd_file.put_line(fnd_file.log,'Overall request set Status is Error');

Line 600: fnd_file.put_line(fnd_file.log,'Overall request set Status is Warning');

596:
597: IF (RETCODE = 0 ) THEN
598: fnd_file.put_line(fnd_file.log,'Overall request set Status is Normal');
599: ELSIF (RETCODE = 2 ) THEN
600: fnd_file.put_line(fnd_file.log,'Overall request set Status is Warning');
601: ELSE
602: fnd_file.put_line(fnd_file.log,'Overall request set Status is Error');
603: END IF;
604:

Line 602: fnd_file.put_line(fnd_file.log,'Overall request set Status is Error');

598: fnd_file.put_line(fnd_file.log,'Overall request set Status is Normal');
599: ELSIF (RETCODE = 2 ) THEN
600: fnd_file.put_line(fnd_file.log,'Overall request set Status is Warning');
601: ELSE
602: fnd_file.put_line(fnd_file.log,'Overall request set Status is Error');
603: END IF;
604:
605: EXCEPTION
606: WHEN OTHERS THEN

Line 609: fnd_file.put_line(fnd_file.log, 'StatusTracker failed ' || sqlcode||':'||sqlerrm);

605: EXCEPTION
606: WHEN OTHERS THEN
607: RETCODE := 2;
608: ERRBUF := sqlcode||':'||sqlerrm;
609: fnd_file.put_line(fnd_file.log, 'StatusTracker failed ' || sqlcode||':'||sqlerrm);
610:
611: END StatusTracker;
612: -- ababkuma bug#5488292 changed buglist type from t_rec_patch to t_recomm_patch_tab
613: -- Procedure to submit Aggregate Patch Impact Request.