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

Line 31: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> reading patch list...');

27: --baseline VARCHAR2(150); --ang
28: patch_id NUMBER; --ang
29: i INTEGER;
30: BEGIN
31: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> reading patch list...');
32: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
33: --ad_patch_impact_api.get_recommend_patch_list(buglist);--ang
34: ad_patch_impact_api.get_recommend_patch_list(patchlist);--ang
35:

Line 36: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> master patch list = '||patchlist.COUNT||' patches');

32: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
33: --ad_patch_impact_api.get_recommend_patch_list(buglist);--ang
34: ad_patch_impact_api.get_recommend_patch_list(patchlist);--ang
35:
36: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> master patch list = '||patchlist.COUNT||' patches');
37: for i in 1..patchlist.COUNT
38: loop
39: bug_no := patchlist(i).bug_number;
40: --baseline := patchlist(i).baseline;

Line 50: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> reading prereq list...');

46: values(request_id__, snapshot_id__, 'S', bug_no,
47: patch_id, request_id__, null, request_id__, null, sysdate, sysdate, -1, -1); --ang
48: end loop;
49:
50: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> reading prereq list...');
51: -- ang entire for loop can be commented out as prereq analysis is, at the moment, not supported by AD
52: --for i in 1..patchlist.COUNT --ang
53: --loop
54: --bug_no := patchlist(i).bug_number; --ang

Line 59: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> continuing...');

55: --ang for now AD Folks are not doing prereq analysis
56: --makeprereqs(request_id__, bug_no);
57: --end loop;
58:
59: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> continuing...');
60: END makesingletons;
61:
62: --ang commenting out the below code as prereq analysis is, at the moment, not supported by AD
63: /*PROCEDURE makeprereqs(request_id__ INTEGER, bug_no__ INTEGER) IS

Line 72: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> '||bug_no__||' prereq list = '||buglist.COUNT||' patches');

68: BEGIN
69: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
70: ad_patch_impact_api.get_prereq_list(bug_no__, buglist);
71:
72: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> '||bug_no__||' prereq list = '||buglist.COUNT||' patches');
73: for patch_order in 1..buglist.COUNT
74: loop
75: prereq_bug_no := buglist(patch_order);
76: -- BUGSET: for every prereq for patches in the request, create a local prereq record ('m')

Line 88: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> running-refresh1M['||patch_id__||','||snapshot_id__||']...'); --ang

84: PROCEDURE refresh1M(request_id__ INTEGER, virtual_patch_id__ INTEGER, snapshot_id__ INTEGER) IS --ang
85: patch_id__ INTEGER; --ang
86: BEGIN
87: patch_id__ := virtual_patch_id__; --ang
88: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> running-refresh1M['||patch_id__||','||snapshot_id__||']...'); --ang
89: delete from fnd_imp_bugset_temp;
90: delete from FND_IMP_PSMaster2 where patch_id = patch_id__ and snapshot_id = snapshot_id__; --ang
91: -- delete from FND_IMP_AffectedFiles where bug_no = bug_no__ and snapshot_id = snapshot_id__;
92: -- delete from FND_IMP_DiagMap where bug_no = bug_no__ and snapshot_id = snapshot_id__;

Line 94: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> after delete');

90: delete from FND_IMP_PSMaster2 where patch_id = patch_id__ and snapshot_id = snapshot_id__; --ang
91: -- delete from FND_IMP_AffectedFiles where bug_no = bug_no__ and snapshot_id = snapshot_id__;
92: -- delete from FND_IMP_DiagMap where bug_no = bug_no__ and snapshot_id = snapshot_id__;
93: commit;
94: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> after delete');
95:
96: insert into fnd_imp_bugset_temp(patch_id)
97: (select q1.patch_id from fnd_imp_bugset q1
98: where q1.request_id = request_id__ and q1.snapshot_id = snapshot_id__

Line 100: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> after insert into fnd_imp_bugset_temp');

96: insert into fnd_imp_bugset_temp(patch_id)
97: (select q1.patch_id from fnd_imp_bugset q1
98: where q1.request_id = request_id__ and q1.snapshot_id = snapshot_id__
99: and q1.virtual_patch_id = virtual_patch_id__ and q1.set_type IN ('M','m','A'));
100: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> after insert into fnd_imp_bugset_temp');
101: --
102: -- Tuned Performance Fix from Performance Team
103: --
104: INSERT INTO FND_IMP_PSMASTER2(PATCH_ID, SNAPSHOT_ID, APP_SHORT_NAME,

Line 127: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> after insert into fnd_imp_psmaster2');

123: AND ( ( M.NEW_VERSION IS NULL)
124: or ( M.NEW_VERSION IS NOT NULL AND FND_IMP_CONV_PKG.COMPARE_RCSID(M.NEW_VERSION, X.NEW_VERSION) IN (1, 2)) ) )
125: GROUP BY APP_SHORT_NAME, DIRECTORY,FILENAME;
126:
127: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> after insert into fnd_imp_psmaster2');
128: commit;
129: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> completed-refresh1M['||patch_id__||','||snapshot_id__||']...');
130: END refresh1M;
131:

Line 129: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> completed-refresh1M['||patch_id__||','||snapshot_id__||']...');

125: GROUP BY APP_SHORT_NAME, DIRECTORY,FILENAME;
126:
127: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> after insert into fnd_imp_psmaster2');
128: commit;
129: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> completed-refresh1M['||patch_id__||','||snapshot_id__||']...');
130: END refresh1M;
131:
132: PROCEDURE logstats(request_id__ INTEGER, stage__ CHAR) IS
133: CURSOR stats1 IS

Line 152: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> Skipped stage1 for: '||tmp1.virtual_patch_id||' since it was already processed with request='||tmp1.r1_requestor); --ang

148: LOOP
149: FETCH stats1 into tmp1;
150: EXIT WHEN stats1%NOTFOUND;
151: -- dbms_output.put_line('Note: Skipped stage1 for: '||tmp1.virtual_bug_no||' since it was already processed with request='||tmp1.r1_requestor);
152: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> Skipped stage1 for: '||tmp1.virtual_patch_id||' since it was already processed with request='||tmp1.r1_requestor); --ang
153: commit;
154: END LOOP;
155: CLOSE stats1;
156: else

Line 163: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> Skipped stage2 for: '||tmp2.virtual_patch_id||' since it was already processed with request='||tmp2.r2_requestor); --ang

159: LOOP
160: FETCH stats2 into tmp2;
161: EXIT WHEN stats2%NOTFOUND;
162: -- dbms_output.put_line('Note: Skipped stage2 for: '||tmp2.virtual_bug_no||' since it was already processed with request='||tmp2.r2_requestor);
163: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> Skipped stage2 for: '||tmp2.virtual_patch_id||' since it was already processed with request='||tmp2.r2_requestor); --ang
164: commit;
165: END LOOP;
166: CLOSE stats2;
167: end if;

Line 274: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> No Patch Metadata found for patch: '||virtual_patch_id__);

270: where snapshot_id = snapshot_id__
271: and patch_id = virtual_patch_id__;
272:
273: if psmaster2_sz__ = 0 then
274: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> No Patch Metadata found for patch: '||virtual_patch_id__);
275: end if;
276:
277: if(SIGN(virtual_patch_id__) = 1) THEN
278: wipedata(0-virtual_patch_id__, snapshot_id__);

Line 301: --fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> Done with patch: '||virtual_bug_no__);

297: update fnd_imp_monitor set r1_sync_date = time__, last_update_date = time__, psmaster2_sz = psmaster2_sz__
298: where request_id = request_id__ and snapshot_id = snapshot_id__
299: and set_type = set_type__ and virtual_patch_id = virtual_patch_id__;
300: commit;
301: --fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> Done with patch: '||virtual_bug_no__);
302: END LOOP;
303: CLOSE bugsnaps1;
304: --fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> Done with rsync1');
305: END rsync1;

Line 304: --fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> Done with rsync1');

300: commit;
301: --fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> Done with patch: '||virtual_bug_no__);
302: END LOOP;
303: CLOSE bugsnaps1;
304: --fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> Done with rsync1');
305: END rsync1;
306:
307: PROCEDURE rsync2(request_id__ INTEGER) IS
308: CURSOR bugsnaps2 IS

Line 355: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> No Patch Metadata found for patch: '||virtual_patch_id__);

351: select sysdate into time__ from dual;
352: refresh2(virtual_patch_id__, snapshot_id__);
353:
354: if psmaster2_sz__ = 0 then
355: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> No Patch Metadata found for patch: '||virtual_patch_id__);
356: end if;
357:
358: -- update global record
359: update fnd_imp_monitor set r2_requestor = request_id__, r2_sync_date = time__, last_update_date = time__

Line 375: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> master running['||request_id||' stage='||stage||']...');

371: PROCEDURE refresh(request_id__ INTEGER, stage__ CHAR) IS
372: patchlist__ ad_patch_impact_api.t_recomm_patch_tab; --todo
373: BEGIN
374: -- dbms_output.put_line(to_char(sysdate,'HH24:MI:SS')||'> master running['||request_id__||' stage='||stage__||']...');
375: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> master running['||request_id__||' stage='||stage__||']...');
376:
377: if(stage__ = '1') then
378: rsync1(request_id__);
379: end if;

Line 393: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> master completed '||request_id||' stage='||stage);

389: aggregate_patches(request_id__);
390: end if;
391:
392: -- dbms_output.put_line(to_char(sysdate,'HH24:MI:SS')||'> master completed '||request_id__||' stage='||stage__);
393: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> master completed '||request_id__||' stage='||stage__);
394: END refresh;
395:
396: PROCEDURE aggregate_patches(request_id__ INTEGER) IS
397: snapshot_id__ NUMBER;

Line 551: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> running['||patch_id__||','||snapshot_id__||']...');

547:
548: PROCEDURE refresh1(patch_id__ INTEGER, snapshot_id__ INTEGER) IS
549: BEGIN
550: -- dbms_output.put_line(to_char(sysdate,'HH24:MI:SS')||'> running['||bug_no__||','||snapshot_id__||']...');
551: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> running['||patch_id__||','||snapshot_id__||']...');
552: delete from FND_IMP_PFileInfo where patch_id = patch_id__; commit; --ang
553: delete from FND_IMP_PFileInfo2 where patch_id = patch_id__; commit;
554: delete from FND_IMP_PSCommon where patch_id = patch_id__ and snapshot_id = snapshot_id__; commit;
555: delete from FND_IMP_PSNew where patch_id = patch_id__ and snapshot_id = snapshot_id__; commit;

Line 577: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> completed');

573: */
574: commit;
575: end;
576: -- dbms_output.put_line(to_char(sysdate,'HH24:MI:SS')||'> completed');
577: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> completed');
578: END refresh1;
579:
580: PROCEDURE refresh2(patch_id__ INTEGER, snapshot_id__ INTEGER) IS
581: BEGIN

Line 583: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> running['||patch_id__||','||snapshot_id__||']...');

579:
580: PROCEDURE refresh2(patch_id__ INTEGER, snapshot_id__ INTEGER) IS
581: BEGIN
582: -- dbms_output.put_line(to_char(sysdate,'HH24:MI:SS')||'> running['||bug_no__||','||snapshot_id__||']...');
583: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> running['||patch_id__||','||snapshot_id__||']...');
584:
585: begin
586: -- Adding this from refresh1/refresh1M
587: delete from FND_IMP_AffectedFiles where patch_id = patch_id__ and snapshot_id = snapshot_id__;

Line 686: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> completed');

682:
683: commit;
684: end;
685: -- dbms_output.put_line(to_char(sysdate,'HH24:MI:SS')||'> completed');
686: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> completed');
687: END refresh2;
688:
689: --
690: -- Procedure to compute language impact

Line 709: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> computing language impact['||request_id__||']...');

705: where set_type = 'M'
706: and request_id = v_req_id
707: and snapshot_id = v_snapshot_id;
708: BEGIN
709: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> computing language impact['||request_id__||']...');
710:
711: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
712:
713: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> snapshot_id['||snapshot_id__||']...');

Line 713: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> snapshot_id['||snapshot_id__||']...');

709: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> computing language impact['||request_id__||']...');
710:
711: ad_patch_impact_api.get_global_snapshot_id(snapshot_id__);
712:
713: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> snapshot_id['||snapshot_id__||']...');
714:
715: -- Cleanup any records associated with this request_id
716: delete from fnd_imp_lang_summary l
717: where l.snapshot_id = snapshot_id__

Line 727: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||' cleaned up fnd_imp_lang_summary');

723: and m.snapshot_id = l.snapshot_id
724: union
725: select 0-request_id__ from dual);
726:
727: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||' cleaned up fnd_imp_lang_summary');
728:
729:
730: -- 1) First record for each singletons (top level or pre-reqs)
731: -- whether translation patch is required with count as 1.

Line 754: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||' processed top levels and prerequisites (S,s)');

750: null;
751: end;
752: end loop;
753:
754: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||' processed top levels and prerequisites (S,s)');
755:
756: -- 2) Now aggregate for each Multi-set (M) the sum of singletons
757: -- for which translation patch is required.
758: for v_bug in M_bugs(request_id__,snapshot_id__) loop

Line 786: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||' processed top level and prerequisite aggregation (M)');

782: null;
783: end;
784: end loop;
785:
786: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||' processed top level and prerequisite aggregation (M)');
787:
788: -- 3) Now aggregate for ad-hoc aggregation (a) to be the sum of
789: -- all top-levels (S and M) - and of course avoiding double
790: -- counting. This step is only applicable if we're in

Line 812: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||' processed aggregation (M)');

808: null;
809: end;
810: commit;
811:
812: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||' processed aggregation (M)');
813:
814: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> Done computing language impact['||request_id__||','||snapshot_id__||']...');
815: END compute_language_impact;
816:

Line 814: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> Done computing language impact['||request_id__||','||snapshot_id__||']...');

810: commit;
811:
812: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||' processed aggregation (M)');
813:
814: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> Done computing language impact['||request_id__||','||snapshot_id__||']...');
815: END compute_language_impact;
816:
817: PROCEDURE refreshCP(
818: ERRBUF OUT NOCOPY VARCHAR2,

Line 824: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP: running');

820: ) IS
821: request_id INTEGER;
822: no_request_id_found EXCEPTION;
823: BEGIN
824: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP: running');
825: select fcr.request_id into request_id
826: from fnd_application fa, fnd_concurrent_requests fcr, fnd_concurrent_programs fcp
827: where fcr.priority_request_id = fnd_global.conc_priority_request
828: and fcr.program_application_id = fcp.application_id

Line 833: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP: request id = '||request_id);

829: and fcp.application_id = fa.application_id
830: and fcr.concurrent_program_id = fcp.concurrent_program_id
831: and fa.application_short_name = 'AD'
832: and fcp.concurrent_program_name IN ('PATCHANALYSIS', 'PAANALYSIS', 'PADOWNLOADPATCHES', 'PAANALYZEPATCHES', 'PARECOMMENDPATCHES');
833: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP: request id = '||request_id);
834: refresh(request_id, '1');
835:
836: EXCEPTION
837: WHEN OTHERS

Line 841: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP failed ' || sqlcode||':'||sqlerrm);

837: WHEN OTHERS
838: THEN
839: RETCODE := 2;
840: ERRBUF := sqlcode||':'||sqlerrm;
841: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP failed ' || sqlcode||':'||sqlerrm);
842: END refreshCP;
843:
844: PROCEDURE refreshCP2(
845: ERRBUF OUT NOCOPY VARCHAR2,

Line 851: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP2: running');

847: ) IS
848: request_id INTEGER;
849: no_request_id_found EXCEPTION;
850: BEGIN
851: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP2: running');
852: select fcr.request_id into request_id
853: from fnd_application fa, fnd_concurrent_requests fcr, fnd_concurrent_programs fcp
854: where fcr.priority_request_id = fnd_global.conc_priority_request
855: and fcr.program_application_id = fcp.application_id

Line 860: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP2: request id = '||request_id);

856: and fcp.application_id = fa.application_id
857: and fcr.concurrent_program_id = fcp.concurrent_program_id
858: and fa.application_short_name = 'AD'
859: and fcp.concurrent_program_name IN ('PATCHANALYSIS', 'PAANALYSIS', 'PADOWNLOADPATCHES', 'PAANALYZEPATCHES', 'PARECOMMENDPATCHES');
860: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP2: request id = '||request_id);
861: refresh(request_id, '2');
862: compute_language_impact(request_id);
863: EXCEPTION
864: WHEN OTHERS

Line 868: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP2 failed ' || sqlcode||':'||sqlerrm);

864: WHEN OTHERS
865: THEN
866: RETCODE := 2;
867: ERRBUF := sqlcode||':'||sqlerrm;
868: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCP2 failed ' || sqlcode||':'||sqlerrm);
869: END refreshCP2;
870:
871: PROCEDURE refreshCPAgg(
872: ERRBUF OUT NOCOPY VARCHAR2,

Line 879: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCPAgg: running');

875: ) IS
876: request_id INTEGER;
877: no_request_id_found EXCEPTION;
878: BEGIN
879: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCPAgg: running');
880: if (request_id__ is null) then
881: select fcr.request_id into request_id
882: from fnd_application fa, fnd_concurrent_requests fcr, fnd_concurrent_programs fcp
883: where fcr.priority_request_id = fnd_global.conc_priority_request

Line 889: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCPAgg: request id = '||request_id);

885: and fcp.application_id = fa.application_id
886: and fcr.concurrent_program_id = fcp.concurrent_program_id
887: and fa.application_short_name = 'AD'
888: and fcp.concurrent_program_name IN ('PATCHANALYSIS', 'PAANALYSIS', 'PADOWNLOADPATCHES', 'PAANALYZEPATCHES', 'PARECOMMENDPATCHES');
889: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCPAgg: request id = '||request_id);
890: refresh(request_id, '3');
891: compute_language_impact(request_id);
892: else
893: if (request_id__ >= 0) then

Line 904: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCPAgg failed ' || sqlcode||':'||sqlerrm);

900: WHEN OTHERS
901: THEN
902: RETCODE := 2;
903: ERRBUF := sqlcode||':'||sqlerrm;
904: fnd_file.put_line(fnd_file.log, 'FND_IMP_PKG.refreshCPAgg failed ' || sqlcode||':'||sqlerrm);
905: END refreshCPAgg;
906:
907: PROCEDURE sync(table_name VARCHAR2) IS
908: BEGIN

Line 959: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> FND_IMP_PKG.isFileTypeAffected IN');

955: where set_type in ('s','S')
956: and request_id = v_req_id
957: and snapshot_id = v_snapshot_id;
958: BEGIN
959: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> FND_IMP_PKG.isFileTypeAffected IN');
960:
961: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> computing file type affected for file type ' || filetype__ || '['||request_id__||']...');
962:
963: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> snapshot_id['||snapshot_id__||']...');

Line 961: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> computing file type affected for file type ' || filetype__ || '['||request_id__||']...');

957: and snapshot_id = v_snapshot_id;
958: BEGIN
959: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> FND_IMP_PKG.isFileTypeAffected IN');
960:
961: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> computing file type affected for file type ' || filetype__ || '['||request_id__||']...');
962:
963: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> snapshot_id['||snapshot_id__||']...');
964:
965: -- For each top level bug and pre-reqs, determine if the given

Line 963: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> snapshot_id['||snapshot_id__||']...');

959: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> FND_IMP_PKG.isFileTypeAffected IN');
960:
961: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> computing file type affected for file type ' || filetype__ || '['||request_id__||']...');
962:
963: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> snapshot_id['||snapshot_id__||']...');
964:
965: -- For each top level bug and pre-reqs, determine if the given
966: -- file type is affected.
967: for v_bug in c_bugs(request_id__,snapshot_id__) loop

Line 985: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> v_return:'||v_return);

981: null;
982: end;
983: end loop;
984:
985: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> v_return:'||v_return);
986:
987: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> FND_IMP_PKG.isFileTypeAffected OUT');
988: return v_return;
989: END isFileTypeAffected;

Line 987: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> FND_IMP_PKG.isFileTypeAffected OUT');

983: end loop;
984:
985: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> v_return:'||v_return);
986:
987: fnd_file.put_line(fnd_file.log, to_char(sysdate,'HH24:MI:SS')||'> FND_IMP_PKG.isFileTypeAffected OUT');
988: return v_return;
989: END isFileTypeAffected;
990:
991: END FND_IMP_PKG;