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_FILE_UTIL dependencies on AD_FILE_UTIL

Line 1: package body ad_file_util as

1: package body ad_file_util as
2: /* $Header: adfilutb.pls 120.15 2007/12/14 13:07:57 diverma ship $ */
3:
4: procedure lock_infrastructure is
5: l_lockhandle varchar2(128);

Line 9: ad_file_util.error_buf := 'lock_infrastructure()';

5: l_lockhandle varchar2(128);
6: l_status number := 100;
7: l_exit_loop boolean := FALSE;
8: begin
9: ad_file_util.error_buf := 'lock_infrastructure()';
10:
11: dbms_lock.allocate_unique('ORA_APPS_AD_CHKFILTMP', l_lockhandle);
12:
13: l_exit_loop := FALSE;

Line 43: ad_file_util.error_buf := 'unlock_infrastructure()';

39: procedure unlock_infrastructure is
40: l_lockhandle varchar2(128);
41: l_status number := 100;
42: begin
43: ad_file_util.error_buf := 'unlock_infrastructure()';
44:
45: dbms_lock.allocate_unique('ORA_APPS_AD_CHKFILTMP', l_lockhandle);
46:
47: l_status := dbms_lock.release(l_lockhandle);

Line 100: ad_file_util.error_buf := 'truncate ad_check_file_temp';

96: (p_un_fnd varchar2) is
97: begin
98: lock_infrastructure;
99:
100: ad_file_util.error_buf := 'truncate ad_check_file_temp';
101:
102: execute immediate 'truncate table '||p_un_fnd||'.ad_check_file_temp';
103:
104: exception when others then

Line 105: ad_file_util.error_buf := 'lock_and_empty_temp_table('||

101:
102: execute immediate 'truncate table '||p_un_fnd||'.ad_check_file_temp';
103:
104: exception when others then
105: ad_file_util.error_buf := 'lock_and_empty_temp_table('||
106: ad_file_util.error_buf||
107: ')';
108:
109: raise;

Line 106: ad_file_util.error_buf||

102: execute immediate 'truncate table '||p_un_fnd||'.ad_check_file_temp';
103:
104: exception when others then
105: ad_file_util.error_buf := 'lock_and_empty_temp_table('||
106: ad_file_util.error_buf||
107: ')';
108:
109: raise;
110: end lock_and_empty_temp_table;

Line 153: ad_file_util.error_buf := 'load_file_info('||

149: -- get file_id from ad_files
150: --
151: -- set junk to null to free up space in row and avoid row chaining
152: --
153: ad_file_util.error_buf := 'load_file_info('||
154: ' update ad_check_file_temp t '||
155: 'set t.file_id = (select f.file_id '||
156: 'from ad_files f '||
157: 'where f.app_short_name = t.app_short_name '||

Line 175: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

171: where nvl(t.active_flag,'N') = 'Y';
172:
173: exception
174: when others then
175: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
176: raise;
177: end;
178: --
179: -- add new entries in ad_files

Line 181: ad_file_util.error_buf := 'load_file_info('||

177: end;
178: --
179: -- add new entries in ad_files
180: --
181: ad_file_util.error_buf := 'load_file_info('||
182: 'insert into ad_files '||
183: '(file_id, app_short_name, subdir, filename, '||
184: 'creation_date, created_by, last_update_date, '||
185: 'last_updated_by) select ad_files_s.nextval, '||

Line 212: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

208: where t.file_id is null
209: and nvl(t.active_flag,'N') = 'Y') temp;
210: exception
211: when others then
212: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
213: raise;
214: end;
215:
216: --

Line 219: ad_file_util.error_buf := 'load_file_info('||

215:
216: --
217: -- add file_id for new entries
218: --
219: ad_file_util.error_buf := 'load_file_info('||
220: 'update ad_check_file_temp t set t.file_id = '||
221: '(select f.file_id from ad_files f '||
222: 'where f.app_short_name = t.app_short_name '||
223: 'and f.subdir = t.subdir '||

Line 240: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

236: where t.file_id is null
237: and nvl(t.active_flag,'N') = 'Y';
238: exception
239: when others then
240: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
241: raise;
242: end;
243:
244: --

Line 254: ad_file_util.error_buf := 'load_file_info('||

250: --
251: -- get dest_file_id from ad_files
252: --
253:
254: ad_file_util.error_buf := 'load_file_info('||
255: ' update ad_check_file_temp t '||
256: 'set t.dest_file_id = (select f.file_id '||
257: 'from ad_files f '||
258: 'where f.app_short_name = t.dest_apps_short_name '||

Line 273: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

269: and f.filename = t.dest_filename)
270: where nvl(t.active_flag,'N') = 'Y';
271: exception
272: when others then
273: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
274: raise;
275: end;
276:
277: --

Line 281: ad_file_util.error_buf := 'load_file_info('||

277: --
278: -- add new entries in ad_files
279: --
280:
281: ad_file_util.error_buf := 'load_file_info('||
282: 'insert into ad_files '||
283: '(file_id, app_short_name, subdir, filename, '||
284: 'creation_date, created_by, last_update_date, '||
285: 'last_updated_by) select ad_files_s.nextval, '||

Line 315: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

311: and t.dest_filename <> 'none'
312: and nvl(t.active_flag,'N') = 'Y') temp;
313: exception
314: when others then
315: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
316: raise;
317: end;
318:
319: --

Line 323: ad_file_util.error_buf := 'load_file_info('||

319: --
320: -- add dest_file_id for new entries
321: --
322:
323: ad_file_util.error_buf := 'load_file_info('||
324: 'update ad_check_file_temp t set t.dest_file_id ='||
325: '(select f.file_id from ad_files f '||
326: 'where f.app_short_name = t.dest_apps_short_name'||
327: 'and f.subdir = t.dest_subdir '||

Line 347: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

343: and t.dest_filename <> 'none'
344: and nvl(t.active_flag,'N') = 'Y';
345: exception
346: when others then
347: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
348: raise;
349: end;
350:
351: --

Line 397: ad_file_util.load_file_info;

393: --
394: -- process ad_files
395: --
396: begin
397: ad_file_util.load_file_info;
398: exception
399: when others then
400: ad_file_util.error_buf := 'load_file_version_info('||
401: ad_file_util.error_buf||

Line 400: ad_file_util.error_buf := 'load_file_version_info('||

396: begin
397: ad_file_util.load_file_info;
398: exception
399: when others then
400: ad_file_util.error_buf := 'load_file_version_info('||
401: ad_file_util.error_buf||
402: ')';
403: raise;
404: end;

Line 401: ad_file_util.error_buf||

397: ad_file_util.load_file_info;
398: exception
399: when others then
400: ad_file_util.error_buf := 'load_file_version_info('||
401: ad_file_util.error_buf||
402: ')';
403: raise;
404: end;
405: --

Line 412: ad_file_util.error_buf := 'load_file_version_info('||

408:
409: --
410: -- get file_version_id from ad_file_versions
411: --
412: ad_file_util.error_buf := 'load_file_version_info('||
413: 'update ad_check_file_temp t '||
414: 'set t.file_version_id = '||
415: '(select fv.file_version_id '||
416: 'from ad_file_versions fv '||

Line 435: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

431: where nvl(t.active_flag,'N') = 'Y'
432: and lower(t.manifest_vers)<>'none';
433: exception
434: when others then
435: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
436: raise;
437: end;
438:
439: --

Line 442: ad_file_util.error_buf := 'load_file_version_info('||

438:
439: --
440: -- add new entries to ad_file_versions
441: --
442: ad_file_util.error_buf := 'load_file_version_info('||
443: 'insert into ad_file_versions '||
444: '(file_version_id, file_id, version, '||
445: 'translation_level, '||
446: 'version_segment1, version_segment2, '||

Line 537: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

533: and nvl(t.active_flag,'N') = 'Y'
534: ) temp;
535: exception
536: when others then
537: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
538: raise;
539: end;
540:
541:

Line 545: ad_file_util.error_buf :='load_file_version_info('||

541:
542: --
543: -- get file_version_id for new entries
544: --
545: ad_file_util.error_buf :='load_file_version_info('||
546: 'update ad_check_file_temp t '||
547: 'set t.file_version_id = '||
548: '(select fv.file_version_id '||
549: 'from ad_file_versions fv '||

Line 571: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

567: and nvl(t.active_flag,'N') = 'Y'
568: and lower(t.manifest_vers)<>'none';
569: exception
570: when others then
571: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
572: raise;
573: end;
574:
575: --

Line 626: ad_file_util.error_buf := 'load_checkfile_info(';

622: begin
623: --
624: -- process ad_files and ad_file_versions
625: --
626: ad_file_util.error_buf := 'load_checkfile_info(';
627: begin
628: ad_file_util.load_file_version_info;
629: exception
630: when others then

Line 628: ad_file_util.load_file_version_info;

624: -- process ad_files and ad_file_versions
625: --
626: ad_file_util.error_buf := 'load_checkfile_info(';
627: begin
628: ad_file_util.load_file_version_info;
629: exception
630: when others then
631: ad_file_util.error_buf := 'load_checkfile_info('||
632: ad_file_util.error_buf||sqlerrm||')';

Line 631: ad_file_util.error_buf := 'load_checkfile_info('||

627: begin
628: ad_file_util.load_file_version_info;
629: exception
630: when others then
631: ad_file_util.error_buf := 'load_checkfile_info('||
632: ad_file_util.error_buf||sqlerrm||')';
633: raise;
634: end;
635: --

Line 632: ad_file_util.error_buf||sqlerrm||')';

628: ad_file_util.load_file_version_info;
629: exception
630: when others then
631: ad_file_util.error_buf := 'load_checkfile_info('||
632: ad_file_util.error_buf||sqlerrm||')';
633: raise;
634: end;
635: --
636: -- process ad_check_files

Line 642: ad_file_util.error_buf := 'load_checkfile_info('||

638:
639: --
640: -- get check_file_id and manifest_vers_higher
641: --
642: ad_file_util.error_buf := 'load_checkfile_info('||
643: 'update ad_check_file_temp t '||
644: 'set t.check_file_id = '||
645: '(select cf.check_file_id '||
646: 'from ad_check_files cf '||

Line 694: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

690: and cf.file_version_id = fv2.file_version_id)
691: where nvl(t.active_flag,'N') = 'Y';
692: exception
693: when others then
694: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
695: raise;
696: end;
697: --
698: -- add new entries into ad_check_files

Line 700: ad_file_util.error_buf := 'load_checkfile_info('||

696: end;
697: --
698: -- add new entries into ad_check_files
699: --
700: ad_file_util.error_buf := 'load_checkfile_info('||
701: 'insert into ad_check_files '||
702: '(check_file_id, file_id, distinguisher, '||
703: 'file_version_id, creation_date) '||
704: 'select ad_check_files_s.nextval, '||

Line 731: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

727: where t.check_file_id is null
728: and nvl(t.active_flag,'N') = 'Y') temp;
729: exception
730: when others then
731: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
732: raise;
733: end;
734: --
735: --

Line 738: ad_file_util.error_buf := 'load_checkfile_info('||

734: --
735: --
736: -- delete from ad_check_files where versions lower than manifest
737: --
738: ad_file_util.error_buf := 'load_checkfile_info('||
739: 'delete from ad_check_files kf '||
740: 'where cf.check_file_id in '||
741: '(select t.check_file_id '||
742: 'from ad_check_file_temp t '||

Line 755: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

751: where t.manifest_vers_higher = 'Y'
752: and nvl(t.active_flag,'N') = 'Y');
753: exception
754: when others then
755: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
756: raise;
757: end;
758: --
759: -- insert into ad_check_files where versions lower than manifest

Line 761: ad_file_util.error_buf := 'load_checkfile_info('||

757: end;
758: --
759: -- insert into ad_check_files where versions lower than manifest
760: --
761: ad_file_util.error_buf := 'load_checkfile_info('||
762: ' insert into ad_check_files '||
763: '(check_file_id, file_id, distinguisher, '||
764: 'file_version_id, creation_date) '||
765: 'select temp.cf_id, '||

Line 795: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

791: where t.manifest_vers_higher = 'Y'
792: and nvl(t.active_flag,'N') = 'Y') temp;
793: exception
794: when others then
795: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
796: raise;
797: end;
798:
799: --

Line 835: ad_file_util.error_buf := 'update_timestamp(update ad_timestamps '||

831: begin
832: --
833: -- First try to update
834: --
835: ad_file_util.error_buf := 'update_timestamp(update ad_timestamps '||
836: 'set timestamp = '||in_timestamp||
837: 'where type = '||in_type||
838: 'and attribute = '||in_attribute||'):(';
839: begin

Line 846: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

842: where type = in_type
843: and attribute = in_attribute;
844: exception
845: when others then
846: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
847: raise;
848: end;
849:
850: if SQL%ROWCOUNT = 1 then

Line 856: ad_file_util.error_buf := 'update_timestamp('||

852: end if;
853: --
854: -- Insert if no rows updated
855: --
856: ad_file_util.error_buf := 'update_timestamp('||
857: 'insert into ad_timestamps'||
858: '(type, attribute, timestamp)'||
859: 'values ('||in_type||', '||in_attribute||
860: ', '||in_timestamp||'):(';

Line 868: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

864: (type, attribute, timestamp)
865: values (in_type, in_attribute, in_timestamp);
866: exception
867: when others then
868: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
869: raise;
870: end;
871:
872: end update_timestamp;

Line 933: ad_file_util.load_file_info;

929: --
930: -- process ad_files
931: --
932:
933: ad_file_util.load_file_info;
934:
935: --
936: -- process ad_file_versons
937: --

Line 938: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||

934:
935: --
936: -- process ad_file_versons
937: --
938: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||
939: 'update ad_check_file_temp t '||
940: 'set t.file_version_id = '||
941: '(select fv.file_version_id '||
942: 'from ad_file_versions fv '||

Line 961: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

957: where nvl(t.active_flag,'N') = 'Y'
958: and nvl(t.manifest_vers,'NA')<>'NA';
959: exception
960: when others then
961: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
962: raise;
963: end;
964: --
965: -- add new entries to ad_file_versions

Line 967: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||

963: end;
964: --
965: -- add new entries to ad_file_versions
966: --
967: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||
968: 'insert into ad_file_versions '||
969: '(file_version_id, file_id, version, '||
970: 'translation_level, version_segment1,'||
971: 'version_segment2, version_segment3, '||

Line 1052: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1048: and nvl(t.active_flag,'N') = 'Y'
1049: and nvl(t.manifest_vers,'NA')<>'NA') temp;
1050: exception
1051: when others then
1052: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1053: raise;
1054: end;
1055: --
1056: --

Line 1057: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||

1053: raise;
1054: end;
1055: --
1056: --
1057: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||
1058: 'update ad_check_file_temp t '||
1059: 'set t.file_version_id = '||
1060: '(select fv.file_version_id '||
1061: 'from ad_file_versions fv '||

Line 1081: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1077: where nvl(t.active_flag,'N') = 'Y'
1078: and nvl(t.manifest_vers,'NA')<>'NA';
1079: exception
1080: when others then
1081: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1082: raise;
1083: end;
1084: --
1085: -- get file_version_id_2 from ad_file_versions

Line 1087: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||

1083: end;
1084: --
1085: -- get file_version_id_2 from ad_file_versions
1086: --
1087: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||
1088: 'update ad_check_file_temp t '||
1089: 'set t.file_version_id_2 = '||
1090: '(select fv.file_version_id '||
1091: 'from ad_file_versions fv '||

Line 1109: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1105: where nvl(t.active_flag,'N') = 'Y' AND
1106: nvl(t.manifest_vers_2,'NA')<>'NA';
1107: exception
1108: when others then
1109: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1110: raise;
1111: end;
1112:
1113: --

Line 1116: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||

1112:
1113: --
1114: -- add new entries to ad_file_versions
1115: --
1116: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||
1117: 'insert into ad_file_versions '||
1118: '(file_version_id, file_id, version, '||
1119: 'translation_level, version_segment1,'||
1120: 'version_segment2, version_segment3, '||

Line 1202: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1198: and nvl(t.active_flag,'N') = 'Y'
1199: and nvl(t.manifest_vers_2,'NA')<>'NA') temp;
1200: exception
1201: when others then
1202: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1203: raise;
1204: end;
1205: --
1206: -- get file_version_id_2 from ad_file_versions

Line 1208: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||

1204: end;
1205: --
1206: -- get file_version_id_2 from ad_file_versions
1207: --
1208: ad_file_util.error_buf := 'load_patch_onsite_vers_info('||
1209: 'update ad_check_file_temp t '||
1210: 'set t.file_version_id_2 = '||
1211: '(select fv.file_version_id '||
1212: 'from ad_file_versions fv '||

Line 1228: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1224: where nvl(t.active_flag,'N') = 'Y' AND
1225: nvl(t.manifest_vers_2,'NA')<>'NA';
1226: exception
1227: when others then
1228: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1229: raise;
1230: end;
1231: --
1232: -- done processing ad_file_versions

Line 1308: ad_file_util.load_file_version_info;

1304: --
1305: -- process ad_files and ad_file_versions
1306: --
1307: begin
1308: ad_file_util.load_file_version_info;
1309: exception
1310: when others then
1311: ad_file_util.error_buf := 'load_snapshot_file_info('||snp_id||'):('||
1312: ad_file_util.error_buf||sqlerrm||')';

Line 1311: ad_file_util.error_buf := 'load_snapshot_file_info('||snp_id||'):('||

1307: begin
1308: ad_file_util.load_file_version_info;
1309: exception
1310: when others then
1311: ad_file_util.error_buf := 'load_snapshot_file_info('||snp_id||'):('||
1312: ad_file_util.error_buf||sqlerrm||')';
1313: raise;
1314: end;
1315: --

Line 1312: ad_file_util.error_buf||sqlerrm||')';

1308: ad_file_util.load_file_version_info;
1309: exception
1310: when others then
1311: ad_file_util.error_buf := 'load_snapshot_file_info('||snp_id||'):('||
1312: ad_file_util.error_buf||sqlerrm||')';
1313: raise;
1314: end;
1315: --
1316: -- get contain_file_id from ad_files

Line 1325: ad_file_util.error_buf := 'load_snapshot_file_info(cursor: '||

1321: --
1322: -- done processing ad_files
1323: --
1324: --
1325: ad_file_util.error_buf := 'load_snapshot_file_info(cursor: '||
1326: 'select file_version_id,check_sum,file_size, '||
1327: 'file_id,check_file_id,dest_file_id, '||
1328: 'file_type_flag from '||
1329: 'ad_check_file_temp):(';

Line 1335: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1331: begin
1332: OPEN c1;
1333: exception
1334: when others then
1335: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1336: raise;
1337: end;
1338: --
1339: --

Line 1401: ad_file_util.error_buf := 'load_snapshot_file_info(Close cursor):('||

1397: begin
1398: close c1;
1399: exception
1400: when others then
1401: ad_file_util.error_buf := 'load_snapshot_file_info(Close cursor):('||
1402: sqlerrm||')';
1403: end;
1404: --
1405: --

Line 1407: ad_file_util.error_buf := 'load_snapshot_file_info('||

1403: end;
1404: --
1405: --
1406: --
1407: ad_file_util.error_buf := 'load_snapshot_file_info('||
1408: 'INSERT INTO ad_snapshot_files '||
1409: '(snapshot_file_id,snapshot_id,file_id, '||
1410: 'containing_file_id,file_size,checksum,'||
1411: 'file_version_id, update_source_id, '||

Line 1455: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1451: and nvl(sf2.containing_file_id,-1) = nvl(t.check_file_id,-1)
1452: );
1453: exception
1454: when others then
1455: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1456: raise;
1457: end;
1458:
1459: update ad_snapshots set last_update_date = sysdate

Line 1492: ad_file_util.error_buf := 'load_preseeded_bugfixes('||

1488: --
1489: -- Get the bug_id from ad_bugs
1490: --
1491: -- Bug 5758908 - stangutu - 14 June, 2007
1492: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1493: 'SET t.file_id = (SELECT b.bug_id '||
1494: 'FROM ad_bugs b WHERE b.bug_number = t.filename '||
1495: 'AND b.aru_release_name = t.subdir '||
1496: 'AND b.trackable_entity_abbr=t.app_short_name '||

Line 1521: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1517: t.junk = NULL
1518: WHERE NVL(t.active_flag,'N') = 'Y';
1519: exception
1520: when others then
1521: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1522: raise;
1523: end;
1524: --
1525: -- add new entries in ad_bugs

Line 1528: ad_file_util.error_buf := 'load_preseeded_bugfixes('||

1524: --
1525: -- add new entries in ad_bugs
1526: --
1527: -- Bug 5758908 - stangutu - 14 Jun, 2007 */
1528: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1529: 'INSERT INTO ad_bugs '||
1530: '(bug_id, bug_number,aru_release_name, '||
1531: 'creation_date, created_by, last_update_date, '||
1532: 'last_updated_by, baseline_name, generic_patch, '||

Line 1578: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1574: WHERE t.file_id is null
1575: AND NVL(t.active_flag,'N') = 'Y') temp;
1576: exception
1577: when others then
1578: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1579: raise;
1580: end;
1581: --
1582: -- add bug_id for new entries

Line 1585: ad_file_util.error_buf := 'load_preseeded_bugfixes('||

1581: --
1582: -- add bug_id for new entries
1583: --
1584: -- Bug 5758908 - stangutu - 14 June, 2007
1585: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1586: 'UPDATE ad_check_file_temp t '||
1587: 'SET t.file_id = (SELECT b.bug_id '||
1588: 'FROM ad_bugs b WHERE b.bug_number = t.filename '||
1589: 'AND b.aru_release_name = t.subdir, '||

Line 1615: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1611: t.junk = NULL
1612: WHERE NVL(t.active_flag,'N') = 'Y';
1613: exception
1614: when others then
1615: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1616: raise;
1617: end;
1618: --
1619: -- store the pre-seed the list of bug fixes included

Line 1622: ad_file_util.error_buf := 'load_preseeded_bugfixes('||

1618: --
1619: -- store the pre-seed the list of bug fixes included
1620: -- in that Maintenance Pack.
1621: --
1622: ad_file_util.error_buf := 'load_preseeded_bugfixes('||
1623: 'INSERT into ad_snapshot_bugfixes( '||
1624: 'snapshot_bug_id,snapshot_id, '||
1625: 'bugfix_id,bug_status,success_flag, '||
1626: 'creation_date,last_update_date, '||

Line 1654: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

1650: where b.BUGFIX_ID=t.file_id and
1651: b.SNAPSHOT_ID=t.file_version_id_2);
1652: exception
1653: when others then
1654: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
1655: raise;
1656: end;
1657: end load_preseeded_bugfixes;
1658: --

Line 2988: ad_file_util.error_buf := 'load_snpst_file_server_info(cursor: '||

2984: --
2985: --
2986: begin
2987:
2988: ad_file_util.error_buf := 'load_snpst_file_server_info(cursor: '||
2989: 'select file_id,check_file_id,server_type_admin_flag, '||
2990: 'server_type_forms_flag, server_type_node_flag, '||
2991: 'server_type_web_flag from '||
2992: 'ad_check_file_temp):(';

Line 2998: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';

2994: begin
2995: OPEN c1;
2996: exception
2997: when others then
2998: ad_file_util.error_buf := ad_file_util.error_buf||sqlerrm||')';
2999: raise;
3000: end;
3001: --
3002: --

Line 3048: ad_file_util.error_buf := 'load_snpst_file_server_info(Close cursor):('||

3044: begin
3045: close c1;
3046: exception
3047: when others then
3048: ad_file_util.error_buf := 'load_snpst_file_server_info(Close cursor):('||
3049: sqlerrm||')';
3050: end;
3051:
3052: --

Line 3059: end ad_file_util;

3055: end load_snpst_file_server_info;
3056: --
3057: --
3058:
3059: end ad_file_util;