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.

SYSTEM.AD_APPS_PRIVATE dependencies on AD_APPS_PRIVATE

Line 1: package body AD_APPS_PRIVATE as

1: package body AD_APPS_PRIVATE as
2: /* $Header: adaprb.pls 120.23.12020000.5 2013/05/22 16:08:32 rraam ship $ */
3:
4: --
5: -- PRIVATE GLOBAL VARIABLES

Line 187: ad_apps_private.error_buf := 'do_apps_ddl('||schema_name||

183: exception
184: when others then
185:
186: if abbrev_stmt = 'FALSE' then
187: ad_apps_private.error_buf := 'do_apps_ddl('||schema_name||
188: ','||ddl_text|| '): '||ad_apps_private.error_buf;
189: else
190: ad_apps_private.error_buf := 'do_apps_ddl('||schema_name||
191: ', $statement$): '||ad_apps_private.error_buf;

Line 188: ','||ddl_text|| '): '||ad_apps_private.error_buf;

184: when others then
185:
186: if abbrev_stmt = 'FALSE' then
187: ad_apps_private.error_buf := 'do_apps_ddl('||schema_name||
188: ','||ddl_text|| '): '||ad_apps_private.error_buf;
189: else
190: ad_apps_private.error_buf := 'do_apps_ddl('||schema_name||
191: ', $statement$): '||ad_apps_private.error_buf;
192: end if;

Line 190: ad_apps_private.error_buf := 'do_apps_ddl('||schema_name||

186: if abbrev_stmt = 'FALSE' then
187: ad_apps_private.error_buf := 'do_apps_ddl('||schema_name||
188: ','||ddl_text|| '): '||ad_apps_private.error_buf;
189: else
190: ad_apps_private.error_buf := 'do_apps_ddl('||schema_name||
191: ', $statement$): '||ad_apps_private.error_buf;
192: end if;
193:
194: raise;

Line 191: ', $statement$): '||ad_apps_private.error_buf;

187: ad_apps_private.error_buf := 'do_apps_ddl('||schema_name||
188: ','||ddl_text|| '): '||ad_apps_private.error_buf;
189: else
190: ad_apps_private.error_buf := 'do_apps_ddl('||schema_name||
191: ', $statement$): '||ad_apps_private.error_buf;
192: end if;
193:
194: raise;
195: end do_apps_ddl;

Line 228: ad_apps_private.error_buf := 'do_apps_array_ddl('||schema_name||', '||

224: using lb, ub, add_newline;
225:
226: exception
227: when others then
228: ad_apps_private.error_buf := 'do_apps_array_ddl('||schema_name||', '||
229: lb||', '||ub||', '||add_newline||'): '||
230: ad_apps_private.error_buf;
231: raise;
232: end do_apps_array_ddl;

Line 230: ad_apps_private.error_buf;

226: exception
227: when others then
228: ad_apps_private.error_buf := 'do_apps_array_ddl('||schema_name||', '||
229: lb||', '||ub||', '||add_newline||'): '||
230: ad_apps_private.error_buf;
231: raise;
232: end do_apps_array_ddl;
233:
234: procedure do_apps_array_ddl

Line 264: ad_apps_private.error_buf := 'do_array_assignment('||schema_name||','||

260: using rowcount, ddl_text;
261:
262: exception
263: when others then
264: ad_apps_private.error_buf := 'do_array_assignment('||schema_name||','||
265: ddl_text||','||rowcount||'): '||ad_apps_private.error_buf;
266: raise;
267: end do_array_assignment;
268:

Line 265: ddl_text||','||rowcount||'): '||ad_apps_private.error_buf;

261:
262: exception
263: when others then
264: ad_apps_private.error_buf := 'do_array_assignment('||schema_name||','||
265: ddl_text||','||rowcount||'): '||ad_apps_private.error_buf;
266: raise;
267: end do_array_assignment;
268:
269:

Line 307: ad_apps_private.error_buf := 'do_array_assignment_patch_edn('||schema_name||','||

303: dbms_sql.close_cursor(l_cur);
304:
305: exception
306: when others then
307: ad_apps_private.error_buf := 'do_array_assignment_patch_edn('||schema_name||','||
308: ddl_text||','||rowcount||'): '||ad_apps_private.error_buf;
309: raise;
310: end do_array_assignment_patch_edn;
311:

Line 308: ddl_text||','||rowcount||'): '||ad_apps_private.error_buf;

304:
305: exception
306: when others then
307: ad_apps_private.error_buf := 'do_array_assignment_patch_edn('||schema_name||','||
308: ddl_text||','||rowcount||'): '||ad_apps_private.error_buf;
309: raise;
310: end do_array_assignment_patch_edn;
311:
312: procedure check_for_apps_ddl

Line 364: ad_apps_private.error_buf := 'check_for_apps_ddl('||schema_name||

360: end if;
361: end if;
362: exception
363: when others then
364: ad_apps_private.error_buf := 'check_for_apps_ddl('||schema_name||
365: '): '||ad_apps_private.error_buf;
366: raise;
367: end check_for_apps_ddl;
368:

Line 365: '): '||ad_apps_private.error_buf;

361: end if;
362: exception
363: when others then
364: ad_apps_private.error_buf := 'check_for_apps_ddl('||schema_name||
365: '): '||ad_apps_private.error_buf;
366: raise;
367: end check_for_apps_ddl;
368:
369: --

Line 387: ad_apps_private.error_buf := 'check_if_schema_exists('||schema_name||

383: -- no rows returned then return false
384: return FALSE;
385: exception
386: when others then
387: ad_apps_private.error_buf := 'check_if_schema_exists('||schema_name||
388: '): '||ad_apps_private.error_buf;
389: raise;
390: end check_if_schema_exists;
391:

Line 388: '): '||ad_apps_private.error_buf;

384: return FALSE;
385: exception
386: when others then
387: ad_apps_private.error_buf := 'check_if_schema_exists('||schema_name||
388: '): '||ad_apps_private.error_buf;
389: raise;
390: end check_if_schema_exists;
391:
392: --

Line 423: ad_apps_private.do_apps_ddl(p_grantor_schema_name, l_statement);

419: p_object_name || '" TO ' || p_grantee_schema_name);
420: IF (p_with_grant_option) THEN
421: l_statement := l_statement || ' WITH GRANT OPTION';
422: END IF;
423: ad_apps_private.do_apps_ddl(p_grantor_schema_name, l_statement);
424: EXCEPTION
425: WHEN no_privileges_to_grant THEN
426: --
427: -- In case of APPS1 to APPS2 granting this can happen

Line 441: ad_apps_private.error_buf :=

437: WHERE owner = p_grantor_schema_name
438: AND object_name = p_object_name;
439: EXCEPTION
440: WHEN OTHERS THEN
441: ad_apps_private.error_buf :=
442: p_object_name || ' does not exist in ' ||
443: p_grantor_schema_name || ad_apps_private.error_buf;
444: RAISE;
445: END;

Line 443: p_grantor_schema_name || ad_apps_private.error_buf;

439: EXCEPTION
440: WHEN OTHERS THEN
441: ad_apps_private.error_buf :=
442: p_object_name || ' does not exist in ' ||
443: p_grantor_schema_name || ad_apps_private.error_buf;
444: RAISE;
445: END;
446: IF (l_object_type = 'SYNONYM') THEN
447: BEGIN

Line 455: ad_apps_private.error_buf :=

451: WHERE owner = p_grantor_schema_name
452: AND synonym_name = p_object_name;
453: EXCEPTION
454: WHEN OTHERS THEN
455: ad_apps_private.error_buf :=
456: 'Synonym ' || p_object_name || ' does not exist in ' ||
457: p_grantor_schema_name || ad_apps_private.error_buf;
458: RAISE;
459: END;

Line 457: p_grantor_schema_name || ad_apps_private.error_buf;

453: EXCEPTION
454: WHEN OTHERS THEN
455: ad_apps_private.error_buf :=
456: 'Synonym ' || p_object_name || ' does not exist in ' ||
457: p_grantor_schema_name || ad_apps_private.error_buf;
458: RAISE;
459: END;
460: --
461: -- Check to recursion depth in case of circular synonyms.

Line 466: ad_apps_private.error_buf :=

462: --
463: l_recursion_depth := Nvl(p_recursion_depth, 0) + 1;
464: IF (l_recursion_depth < 0 OR
465: l_recursion_depth > 20) THEN
466: ad_apps_private.error_buf :=
467: 'Recursion depth exceeded the limit (0-20) : ' ||
468: l_recursion_depth || ad_apps_private.error_buf;
469: RAISE;
470: END IF;

Line 468: l_recursion_depth || ad_apps_private.error_buf;

464: IF (l_recursion_depth < 0 OR
465: l_recursion_depth > 20) THEN
466: ad_apps_private.error_buf :=
467: 'Recursion depth exceeded the limit (0-20) : ' ||
468: l_recursion_depth || ad_apps_private.error_buf;
469: RAISE;
470: END IF;
471: --
472: -- Recursively call to get grantable grant.

Line 483: ad_apps_private.do_apps_ddl(p_grantor_schema_name, l_statement);

479: p_recursion_depth => l_recursion_depth);
480: --
481: -- Now we have the grant from previous owner schema.
482: --
483: ad_apps_private.do_apps_ddl(p_grantor_schema_name, l_statement);
484: ELSE
485: ad_apps_private.error_buf :=
486: 'No priv to grant for a non-synonym object. ' ||
487: ad_apps_private.error_buf;

Line 485: ad_apps_private.error_buf :=

481: -- Now we have the grant from previous owner schema.
482: --
483: ad_apps_private.do_apps_ddl(p_grantor_schema_name, l_statement);
484: ELSE
485: ad_apps_private.error_buf :=
486: 'No priv to grant for a non-synonym object. ' ||
487: ad_apps_private.error_buf;
488: RAISE;
489: END IF;

Line 487: ad_apps_private.error_buf;

483: ad_apps_private.do_apps_ddl(p_grantor_schema_name, l_statement);
484: ELSE
485: ad_apps_private.error_buf :=
486: 'No priv to grant for a non-synonym object. ' ||
487: ad_apps_private.error_buf;
488: RAISE;
489: END IF;
490: END;
491:

Line 504: ad_apps_private.error_buf := 'create_grant('||

500: FROM dba_queues where name = p_object_name;
501:
502: EXCEPTION
503: WHEN OTHERS THEN
504: ad_apps_private.error_buf := 'create_grant('||
505: p_object_name || ' does not exist in ' ||
506: l_queue_owner ||'): ' || ad_apps_private.error_buf;
507: RAISE;
508: END;

Line 506: l_queue_owner ||'): ' || ad_apps_private.error_buf;

502: EXCEPTION
503: WHEN OTHERS THEN
504: ad_apps_private.error_buf := 'create_grant('||
505: p_object_name || ' does not exist in ' ||
506: l_queue_owner ||'): ' || ad_apps_private.error_buf;
507: RAISE;
508: END;
509:
510: IF l_exists = 1 THEN

Line 517: ad_apps_private.error_buf := null;

513: grantee =>p_grantee_schema_name,grant_option=>TRUE);
514: END IF;
515:
516: WHEN no_privileges_to_grant THEN
517: ad_apps_private.error_buf := null;
518:
519: WHEN OTHERS THEN
520: DECLARE
521: l_with_grant_option_text VARCHAR2(10) := 'FALSE';

Line 526: ad_apps_private.error_buf := 'create_grant('||

522: BEGIN
523: IF (p_with_grant_option) THEN
524: l_with_grant_option_text := 'TRUE';
525: END IF;
526: ad_apps_private.error_buf := 'create_grant('||
527: p_grantor_schema_name || ',' || p_grantee_schema_name || ',' ||
528: p_object_name || ',' || p_privileges || ',' ||
529: l_with_grant_option_text || ',' || p_recursion_depth || '): ' ||
530: ad_apps_private.error_buf;

Line 530: ad_apps_private.error_buf;

526: ad_apps_private.error_buf := 'create_grant('||
527: p_grantor_schema_name || ',' || p_grantee_schema_name || ',' ||
528: p_object_name || ',' || p_privileges || ',' ||
529: l_with_grant_option_text || ',' || p_recursion_depth || '): ' ||
530: ad_apps_private.error_buf;
531: END;
532: RAISE;
533: END create_grant;
534:

Line 551: ad_apps_private.do_apps_ddl(p_to_schema_name, l_statement);

547: BEGIN
548: l_statement := ('CREATE SYNONYM "' || p_to_object_name || '" FOR ' ||
549: p_from_schema_name || '."' ||
550: p_from_object_name || '"');
551: ad_apps_private.do_apps_ddl(p_to_schema_name, l_statement);
552: EXCEPTION
553: WHEN name_is_already_used THEN
554:
555: if (p_replace_existing = TRUE) then

Line 564: ad_apps_private.error_buf :=

560: WHERE owner = p_to_schema_name
561: AND object_name = p_to_object_name;
562: EXCEPTION
563: WHEN OTHERS THEN
564: ad_apps_private.error_buf :=
565: p_to_object_name || ' does not exist in ' ||
566: p_to_schema_name || ad_apps_private.error_buf;
567: RAISE;
568: END;

Line 566: p_to_schema_name || ad_apps_private.error_buf;

562: EXCEPTION
563: WHEN OTHERS THEN
564: ad_apps_private.error_buf :=
565: p_to_object_name || ' does not exist in ' ||
566: p_to_schema_name || ad_apps_private.error_buf;
567: RAISE;
568: END;
569: IF (l_object_type = 'SYNONYM') THEN
570: --

Line 573: ad_apps_private.drop_object(p_to_schema_name, p_to_object_name,

569: IF (l_object_type = 'SYNONYM') THEN
570: --
571: -- Drop the synonym and then re-create.
572: --
573: ad_apps_private.drop_object(p_to_schema_name, p_to_object_name,
574: 'SYNONYM');
575: ad_apps_private.do_apps_ddl(p_to_schema_name, l_statement);
576: ELSE
577: RAISE;

Line 575: ad_apps_private.do_apps_ddl(p_to_schema_name, l_statement);

571: -- Drop the synonym and then re-create.
572: --
573: ad_apps_private.drop_object(p_to_schema_name, p_to_object_name,
574: 'SYNONYM');
575: ad_apps_private.do_apps_ddl(p_to_schema_name, l_statement);
576: ELSE
577: RAISE;
578: END IF;
579: ELSE

Line 585: ad_apps_private.error_buf := 'create_synonym('||

581: END IF;
582: END;
583: EXCEPTION
584: WHEN OTHERS THEN
585: ad_apps_private.error_buf := 'create_synonym('||
586: p_from_schema_name || ',' || p_from_object_name || ',' ||
587: p_to_schema_name || ',' || p_to_object_name || '): ' ||
588: ad_apps_private.error_buf;
589: RAISE;

Line 588: ad_apps_private.error_buf;

584: WHEN OTHERS THEN
585: ad_apps_private.error_buf := 'create_synonym('||
586: p_from_schema_name || ',' || p_from_object_name || ',' ||
587: p_to_schema_name || ',' || p_to_object_name || '): ' ||
588: ad_apps_private.error_buf;
589: RAISE;
590:
591: END create_synonym;
592:

Line 603: ad_apps_private.error_buf := null;

599: is
600: begin
601: -- initialize variables; call init functions
602:
603: ad_apps_private.error_buf := null;
604:
605: ad_apps_private.initialize(aol_schema);
606:
607: ad_apps_private.load_exception_list;

Line 605: ad_apps_private.initialize(aol_schema);

601: -- initialize variables; call init functions
602:
603: ad_apps_private.error_buf := null;
604:
605: ad_apps_private.initialize(aol_schema);
606:
607: ad_apps_private.load_exception_list;
608:
609: -- first make sure that the apps_ddl packages exist

Line 607: ad_apps_private.load_exception_list;

603: ad_apps_private.error_buf := null;
604:
605: ad_apps_private.initialize(aol_schema);
606:
607: ad_apps_private.load_exception_list;
608:
609: -- first make sure that the apps_ddl packages exist
610: -- in all relevent schemas
611:

Line 612: ad_apps_private.check_for_apps_ddl(from_schema);

608:
609: -- first make sure that the apps_ddl packages exist
610: -- in all relevent schemas
611:
612: ad_apps_private.check_for_apps_ddl(from_schema);
613: ad_apps_private.check_for_apps_ddl(apps_schema);
614:
615: -- create grants and synonyms from base to apps
616: --

Line 613: ad_apps_private.check_for_apps_ddl(apps_schema);

609: -- first make sure that the apps_ddl packages exist
610: -- in all relevent schemas
611:
612: ad_apps_private.check_for_apps_ddl(from_schema);
613: ad_apps_private.check_for_apps_ddl(apps_schema);
614:
615: -- create grants and synonyms from base to apps
616: --
617: -- if force=TRUE, will drop all synonyms in apps schema corresponding

Line 631: ad_apps_private.error_buf := 'create_grants_and_synonyms('||

627: create_base_gs(from_schema, apps_schema, force);
628:
629: exception
630: when others then
631: ad_apps_private.error_buf := 'create_grants_and_synonyms('||
632: install_group_num||','||from_schema||','||aol_schema||','||
633: apps_schema||'): '||ad_apps_private.error_buf;
634: raise;
635:

Line 633: apps_schema||'): '||ad_apps_private.error_buf;

629: exception
630: when others then
631: ad_apps_private.error_buf := 'create_grants_and_synonyms('||
632: install_group_num||','||from_schema||','||aol_schema||','||
633: apps_schema||'): '||ad_apps_private.error_buf;
634: raise;
635:
636: end create_grants_and_synonyms;
637:

Line 700: ad_apps_private.error_buf := 'c_statement='||c_statement||': '||

696: g_Un_Cache_Tbl(ign||'_aol') := l_apps_schema;
697: EXCEPTION
698: when others then
699: dbms_sql.close_cursor(c);
700: ad_apps_private.error_buf := 'c_statement='||c_statement||': '||
701: ad_apps_private.error_buf;
702: raise;
703: END ; -- Block 1
704: END IF ; -- Cache check

Line 701: ad_apps_private.error_buf;

697: EXCEPTION
698: when others then
699: dbms_sql.close_cursor(c);
700: ad_apps_private.error_buf := 'c_statement='||c_statement||': '||
701: ad_apps_private.error_buf;
702: raise;
703: END ; -- Block 1
704: END IF ; -- Cache check
705:

Line 709: if ad_apps_private.is_mls is null then

705:
706:
707: -- from the IGN get the MLS_APPS schema if it exists, otherwise default it
708: -- Only do this if MLS is enabled.
709: if ad_apps_private.is_mls is null then
710: ad_apps_private.initialize(aol_or_apps_schema);
711: end if;
712:
713: if is_mls then

Line 710: ad_apps_private.initialize(aol_or_apps_schema);

706:
707: -- from the IGN get the MLS_APPS schema if it exists, otherwise default it
708: -- Only do this if MLS is enabled.
709: if ad_apps_private.is_mls is null then
710: ad_apps_private.initialize(aol_or_apps_schema);
711: end if;
712:
713: if is_mls then
714: IF ( g_Un_Cache_Tbl.COUNT <> 0 AND g_Un_Cache_Tbl.EXISTS (ign||'_mls') ) THEN

Line 742: ad_apps_private.error_buf := 'c_statement='||c_statement||': '||

738: g_Un_Cache_Tbl(ign||'_mls') := l_mls_apps_schema ;
739: EXCEPTION
740: when others then
741: dbms_sql.close_cursor(c);
742: ad_apps_private.error_buf := 'c_statement='||c_statement||': '||
743: ad_apps_private.error_buf;
744: raise;
745: END ; -- Block 2
746: END IF ; -- if cache check 2

Line 743: ad_apps_private.error_buf;

739: EXCEPTION
740: when others then
741: dbms_sql.close_cursor(c);
742: ad_apps_private.error_buf := 'c_statement='||c_statement||': '||
743: ad_apps_private.error_buf;
744: raise;
745: END ; -- Block 2
746: END IF ; -- if cache check 2
747: END IF ;

Line 754: ad_apps_private.error_buf := 'get_apps_schema_name('||ign||

750: apps_mls_schema := l_mls_apps_schema;
751:
752: exception
753: when others then
754: ad_apps_private.error_buf := 'get_apps_schema_name('||ign||
755: ','||aol_or_apps_schema||'): '||ad_apps_private.error_buf;
756: raise;
757: END get_apps_schema_name;
758:

Line 755: ','||aol_or_apps_schema||'): '||ad_apps_private.error_buf;

751:
752: exception
753: when others then
754: ad_apps_private.error_buf := 'get_apps_schema_name('||ign||
755: ','||aol_or_apps_schema||'): '||ad_apps_private.error_buf;
756: raise;
757: END get_apps_schema_name;
758:
759: procedure drop_object

Line 817: ad_apps_private.do_apps_ddl_on_patch_edn(target_schema,object_name,object_type,statement,'TRUE'); ---- added by vpalakur for ZD

813: upper(object_type) = 'FUNCTION' or
814: upper(object_type) = 'VIEW' or
815: upper(object_type) = 'TRIGGER' or
816: upper(object_type) = 'SYNONYM') then
817: ad_apps_private.do_apps_ddl_on_patch_edn(target_schema,object_name,object_type,statement,'TRUE'); ---- added by vpalakur for ZD
818: end if;
819:
820: exception
821: -- trap ora -4043 (Object xxx does not exist)

Line 832: ad_apps_private.error_buf := 'drop_object('||target_schema||','||

828: upper(object_type) = 'PACKAGE' or
829: upper(object_type) = 'PACKAGE BODY' then
830: null;
831: else
832: ad_apps_private.error_buf := 'drop_object('||target_schema||','||
833: object_name||
834: ','||object_type||'): '||ad_apps_private.error_buf;
835: raise;
836: end if;

Line 834: ','||object_type||'): '||ad_apps_private.error_buf;

830: null;
831: else
832: ad_apps_private.error_buf := 'drop_object('||target_schema||','||
833: object_name||
834: ','||object_type||'): '||ad_apps_private.error_buf;
835: raise;
836: end if;
837: -- trap ora -942 (Table or view xxx does not exist)
838: when table_view_not_exist then

Line 853: ad_apps_private.error_buf := 'drop_object('||target_schema||','||

849: end if;
850: if upper(object_type) = 'TRIGGER' then
851: null;
852: else
853: ad_apps_private.error_buf := 'drop_object('||target_schema||','||
854: object_name||
855: ','||object_type||'): '||ad_apps_private.error_buf;
856: raise;
857: end if;

Line 855: ','||object_type||'): '||ad_apps_private.error_buf;

851: null;
852: else
853: ad_apps_private.error_buf := 'drop_object('||target_schema||','||
854: object_name||
855: ','||object_type||'): '||ad_apps_private.error_buf;
856: raise;
857: end if;
858: -- trap ora -1434 (Synonym does not exist)
859: when synonym_not_exist then

Line 867: ad_apps_private.error_buf := 'drop_object('||target_schema||','||

863: end if;
864: if upper(object_type) = 'SYNONYM' then
865: null;
866: else
867: ad_apps_private.error_buf := 'drop_object('||target_schema||','||
868: object_name||','||object_type||'): '||
869: ad_apps_private.error_buf;
870: raise;
871: end if;

Line 869: ad_apps_private.error_buf;

865: null;
866: else
867: ad_apps_private.error_buf := 'drop_object('||target_schema||','||
868: object_name||','||object_type||'): '||
869: ad_apps_private.error_buf;
870: raise;
871: end if;
872: -- trap ora -2289 (Sequence does not exist)
873: when sequence_not_exist then

Line 881: ad_apps_private.error_buf := 'drop_object('||target_schema||','||

877: end if;
878: if upper(object_type) = 'SEQUENCE' then
879: null;
880: else
881: ad_apps_private.error_buf := 'drop_object('||target_schema||','||
882: object_name||','||object_type||'): '||
883: ad_apps_private.error_buf;
884: raise;
885: end if;

Line 883: ad_apps_private.error_buf;

879: null;
880: else
881: ad_apps_private.error_buf := 'drop_object('||target_schema||','||
882: object_name||','||object_type||'): '||
883: ad_apps_private.error_buf;
884: raise;
885: end if;
886: when others then
887: -- Bug 13940203

Line 891: ad_apps_private.error_buf := 'drop_object('||target_schema||','||

887: -- Bug 13940203
888: if (dbms_sql.is_open(c)) then
889: dbms_sql.close_cursor(c);
890: end if;
891: ad_apps_private.error_buf := 'drop_object('||target_schema||','||
892: object_name||
893: ','||object_type||'): '||ad_apps_private.error_buf;
894: raise;
895: end drop_object;

Line 893: ','||object_type||'): '||ad_apps_private.error_buf;

889: dbms_sql.close_cursor(c);
890: end if;
891: ad_apps_private.error_buf := 'drop_object('||target_schema||','||
892: object_name||
893: ','||object_type||'): '||ad_apps_private.error_buf;
894: raise;
895: end drop_object;
896:
897:

Line 914: ad_apps_private.copy_view_internal(view_name, from_schema, to_schema);

910: -- the exception. Only try to remedy the exception once, then call
911: -- copy_view_internal again. If the second call fails, just fail.
912: --
913: begin
914: ad_apps_private.copy_view_internal(view_name, from_schema, to_schema);
915: exception
916: when others then
917: --
918: --

Line 936: extra_buf := ' +++(ad_apps_private.recomp_referenced_objs('||view_name||

932:
933: -- try to recompile dependent objects
934: -- Put the "Stack Trace" info in the extra_buf string
935:
936: extra_buf := ' +++(ad_apps_private.recomp_referenced_objs('||view_name||
937: ',VIEW,'||from_schema||','||to_schema||'))+++ ';
938:
939: begin
940: ad_apps_private.recomp_referenced_objs(view_name, 'VIEW',

Line 940: ad_apps_private.recomp_referenced_objs(view_name, 'VIEW',

936: extra_buf := ' +++(ad_apps_private.recomp_referenced_objs('||view_name||
937: ',VIEW,'||from_schema||','||to_schema||'))+++ ';
938:
939: begin
940: ad_apps_private.recomp_referenced_objs(view_name, 'VIEW',
941: from_schema, to_schema);
942:
943: extra_buf := '+++(ad_apps_private.copy_view_internal('||
944: view_name||','||from_schema||','||to_schema||')+++';

Line 943: extra_buf := '+++(ad_apps_private.copy_view_internal('||

939: begin
940: ad_apps_private.recomp_referenced_objs(view_name, 'VIEW',
941: from_schema, to_schema);
942:
943: extra_buf := '+++(ad_apps_private.copy_view_internal('||
944: view_name||','||from_schema||','||to_schema||')+++';
945:
946: -- try creating the view again
947: ad_apps_private.copy_view_internal(view_name, from_schema, to_schema);

Line 947: ad_apps_private.copy_view_internal(view_name, from_schema, to_schema);

943: extra_buf := '+++(ad_apps_private.copy_view_internal('||
944: view_name||','||from_schema||','||to_schema||')+++';
945:
946: -- try creating the view again
947: ad_apps_private.copy_view_internal(view_name, from_schema, to_schema);
948:
949: exception
950: when others then
951: -- Ignore any compilation errors. If a dependent view is invalid,

Line 964: ad_apps_private.error_buf := 'ad_apps_private.copy_view('||view_name||','

960:
961: end; -- end of first attempt at copying views.
962: exception
963: when others then
964: ad_apps_private.error_buf := 'ad_apps_private.copy_view('||view_name||','
965: ||from_schema||','||to_schema||'): '|| extra_buf ||
966: ad_apps_private.error_buf;
967: raise;
968: end copy_view;

Line 966: ad_apps_private.error_buf;

962: exception
963: when others then
964: ad_apps_private.error_buf := 'ad_apps_private.copy_view('||view_name||','
965: ||from_schema||','||to_schema||'): '|| extra_buf ||
966: ad_apps_private.error_buf;
967: raise;
968: end copy_view;
969:
970:

Line 1002: ad_apps_private.build_view_columns(copy_view_internal.from_schema,

998: if view_text is null then
999: raise numeric_or_value_error;
1000: end if;
1001:
1002: ad_apps_private.build_view_columns(copy_view_internal.from_schema,
1003: copy_view_internal.view_name, view_columns);
1004:
1005: temp_len := length(view_columns) + length(view_text)
1006: + length(copy_view_internal.view_name) + 36;

Line 1026: ad_apps_private.do_apps_ddl(copy_view_internal.to_schema,statement);

1022: name_already_used exception;
1023: pragma exception_init(name_already_used, -955);
1024: begin
1025:
1026: ad_apps_private.do_apps_ddl(copy_view_internal.to_schema,statement);
1027:
1028: exception
1029: when invalid_num_columns then
1030: -- trap the error ora-1730 invalid number of columns

Line 1045: ad_apps_private.error_buf := null;

1041: -- Oracle7 will convert the select * into the column list.
1042: null;
1043: when name_already_used then
1044: -- first reset error buf
1045: ad_apps_private.error_buf := null;
1046: -- drop any synonym that may exist by the same name
1047: ad_apps_private.drop_object(copy_view_internal.to_schema,
1048: view_name, 'SYNONYM');
1049: ad_apps_private.do_apps_ddl(copy_view_internal.to_schema,statement);

Line 1047: ad_apps_private.drop_object(copy_view_internal.to_schema,

1043: when name_already_used then
1044: -- first reset error buf
1045: ad_apps_private.error_buf := null;
1046: -- drop any synonym that may exist by the same name
1047: ad_apps_private.drop_object(copy_view_internal.to_schema,
1048: view_name, 'SYNONYM');
1049: ad_apps_private.do_apps_ddl(copy_view_internal.to_schema,statement);
1050: when others then
1051: raise;

Line 1049: ad_apps_private.do_apps_ddl(copy_view_internal.to_schema,statement);

1045: ad_apps_private.error_buf := null;
1046: -- drop any synonym that may exist by the same name
1047: ad_apps_private.drop_object(copy_view_internal.to_schema,
1048: view_name, 'SYNONYM');
1049: ad_apps_private.do_apps_ddl(copy_view_internal.to_schema,statement);
1050: when others then
1051: raise;
1052: end;
1053: --

Line 1060: ad_apps_private.error_buf := null;

1056: exception
1057: when numeric_or_value_error then
1058: if temp_len > 30000 then
1059: -- reset main error buffer
1060: ad_apps_private.error_buf := null;
1061:
1062: -- Call copy_huge_view
1063:
1064: ad_apps_private.copy_huge_view(copy_view_internal.view_name,

Line 1064: ad_apps_private.copy_huge_view(copy_view_internal.view_name,

1060: ad_apps_private.error_buf := null;
1061:
1062: -- Call copy_huge_view
1063:
1064: ad_apps_private.copy_huge_view(copy_view_internal.view_name,
1065: copy_view_internal.from_schema, copy_view_internal.to_schema);
1066: else
1067: --
1068: -- handle case where view text > 32 K

Line 1083: ad_apps_private.error_buf := null;

1079: if view_size < 24000 then
1080: raise;
1081: else
1082: -- reset main error buffer
1083: ad_apps_private.error_buf := null;
1084:
1085: -- Call copy_huge_view
1086:
1087: ad_apps_private.copy_huge_view(copy_view_internal.view_name,

Line 1087: ad_apps_private.copy_huge_view(copy_view_internal.view_name,

1083: ad_apps_private.error_buf := null;
1084:
1085: -- Call copy_huge_view
1086:
1087: ad_apps_private.copy_huge_view(copy_view_internal.view_name,
1088: copy_view_internal.from_schema, copy_view_internal.to_schema);
1089:
1090: end if;
1091: end if;

Line 1105: ad_apps_private.error_buf := null;

1101: -- Trap and ignore ORA-24344: success with compilation error
1102: -- This only happens on ORACLE 8
1103: --
1104: -- reset main error buffer
1105: ad_apps_private.error_buf := null;
1106: when others then
1107: ad_apps_private.error_buf := 'ad_apps_private.copy_view_internal('||
1108: view_name||','||from_schema||','||to_schema||'): '||
1109: ad_apps_private.error_buf;

Line 1107: ad_apps_private.error_buf := 'ad_apps_private.copy_view_internal('||

1103: --
1104: -- reset main error buffer
1105: ad_apps_private.error_buf := null;
1106: when others then
1107: ad_apps_private.error_buf := 'ad_apps_private.copy_view_internal('||
1108: view_name||','||from_schema||','||to_schema||'): '||
1109: ad_apps_private.error_buf;
1110: raise;
1111:

Line 1109: ad_apps_private.error_buf;

1105: ad_apps_private.error_buf := null;
1106: when others then
1107: ad_apps_private.error_buf := 'ad_apps_private.copy_view_internal('||
1108: view_name||','||from_schema||','||to_schema||'): '||
1109: ad_apps_private.error_buf;
1110: raise;
1111:
1112: end copy_view_internal;
1113:

Line 1154: ad_apps_private.do_array_assignment(copy_huge_view.toschema,

1150:
1151: statement := 'create or replace force view "'||
1152: copy_huge_view.view_name||'" ';
1153:
1154: ad_apps_private.do_array_assignment(copy_huge_view.toschema,
1155: statement, row_count);
1156:
1157: --
1158: -- Add in view columns

Line 1161: ad_apps_private.build_view_columns(copy_huge_view.fromschema,

1157: --
1158: -- Add in view columns
1159: --
1160:
1161: ad_apps_private.build_view_columns(copy_huge_view.fromschema,
1162: copy_huge_view.view_name, view_columns);
1163:
1164: -- for substr, position 1 is first character
1165:

Line 1175: ad_apps_private.do_array_assignment(copy_huge_view.toschema,

1171: val_length := length(curr_value);
1172:
1173: row_count := row_count + 1;
1174:
1175: ad_apps_private.do_array_assignment(copy_huge_view.toschema,
1176: curr_value, row_count);
1177:
1178: position := position + val_length;
1179: end loop;

Line 1188: ad_apps_private.do_array_assignment(copy_huge_view.toschema,

1184:
1185: statement := ' as ';
1186: row_count := row_count + 1;
1187:
1188: ad_apps_private.do_array_assignment(copy_huge_view.toschema,
1189: statement, row_count);
1190:
1191: --
1192: -- Add in view select text

Line 1218: ad_apps_private.do_array_assignment(copy_huge_view.toschema,

1214: curr_value,val_length);
1215:
1216: row_count := row_count + 1;
1217:
1218: ad_apps_private.do_array_assignment(copy_huge_view.toschema,
1219: curr_value, row_count);
1220:
1221: position := position + val_length;
1222: end loop;

Line 1225: ad_apps_private.error_buf := 'statement='||statement||

1221: position := position + val_length;
1222: end loop;
1223: else
1224: sys.dbms_sys_sql.close_cursor(c);
1225: ad_apps_private.error_buf := 'statement='||statement||
1226: ':'||ad_apps_private.error_buf;
1227: raise no_data_found;
1228: end if;
1229:

Line 1226: ':'||ad_apps_private.error_buf;

1222: end loop;
1223: else
1224: sys.dbms_sys_sql.close_cursor(c);
1225: ad_apps_private.error_buf := 'statement='||statement||
1226: ':'||ad_apps_private.error_buf;
1227: raise no_data_found;
1228: end if;
1229:
1230: sys.dbms_sys_sql.close_cursor(c);

Line 1243: ad_apps_private.do_apps_array_ddl(copy_huge_view.toschema, 1, row_count);

1239: name_already_used exception;
1240: pragma exception_init(name_already_used, -955);
1241: begin
1242: -- execute the array of statement.
1243: ad_apps_private.do_apps_array_ddl(copy_huge_view.toschema, 1, row_count);
1244: exception
1245: when invalid_num_columns then
1246: -- trap the error ora-1730 invalid number of columns
1247: -- this happens when trying to copy an invalid view that

Line 1261: ad_apps_private.error_buf := null;

1257: -- Oracle7 will convert the select * into the column list.
1258: null;
1259: when name_already_used then
1260: -- first reset error buf
1261: ad_apps_private.error_buf := null;
1262: -- drop any synonym that may exist by the same name
1263: ad_apps_private.drop_object(copy_huge_view.toschema,
1264: view_name, 'SYNONYM');
1265: ad_apps_private.do_apps_array_ddl(copy_huge_view.toschema, 1, row_count);

Line 1263: ad_apps_private.drop_object(copy_huge_view.toschema,

1259: when name_already_used then
1260: -- first reset error buf
1261: ad_apps_private.error_buf := null;
1262: -- drop any synonym that may exist by the same name
1263: ad_apps_private.drop_object(copy_huge_view.toschema,
1264: view_name, 'SYNONYM');
1265: ad_apps_private.do_apps_array_ddl(copy_huge_view.toschema, 1, row_count);
1266: when others then
1267: raise;

Line 1265: ad_apps_private.do_apps_array_ddl(copy_huge_view.toschema, 1, row_count);

1261: ad_apps_private.error_buf := null;
1262: -- drop any synonym that may exist by the same name
1263: ad_apps_private.drop_object(copy_huge_view.toschema,
1264: view_name, 'SYNONYM');
1265: ad_apps_private.do_apps_array_ddl(copy_huge_view.toschema, 1, row_count);
1266: when others then
1267: raise;
1268: end;
1269:

Line 1277: ad_apps_private.error_buf := null;

1273: -- Trap and ignore ORA-24344: success with compilation error
1274: -- This only happens on ORACLE 8
1275: --
1276: -- reset main error buffer
1277: ad_apps_private.error_buf := null;
1278: when others then
1279: ad_apps_private.error_buf := 'copy_huge_view('||
1280: view_name||','||fromschema||','||toschema||'): '||
1281: ad_apps_private.error_buf;

Line 1279: ad_apps_private.error_buf := 'copy_huge_view('||

1275: --
1276: -- reset main error buffer
1277: ad_apps_private.error_buf := null;
1278: when others then
1279: ad_apps_private.error_buf := 'copy_huge_view('||
1280: view_name||','||fromschema||','||toschema||'): '||
1281: ad_apps_private.error_buf;
1282: raise;
1283:

Line 1281: ad_apps_private.error_buf;

1277: ad_apps_private.error_buf := null;
1278: when others then
1279: ad_apps_private.error_buf := 'copy_huge_view('||
1280: view_name||','||fromschema||','||toschema||'): '||
1281: ad_apps_private.error_buf;
1282: raise;
1283:
1284: end copy_huge_view;
1285:

Line 1416: ad_apps_private.error_buf := 'compare_view_text('||

1412: return;
1413:
1414: exception
1415: when others then
1416: ad_apps_private.error_buf := 'compare_view_text('||
1417: view_name||','||fromschema||','||toschema||
1418: ','||from_len||','||to_len||','||local_equal||')'||
1419: extra_err_info||': '||
1420: ad_apps_private.error_buf;

Line 1420: ad_apps_private.error_buf;

1416: ad_apps_private.error_buf := 'compare_view_text('||
1417: view_name||','||fromschema||','||toschema||
1418: ','||from_len||','||to_len||','||local_equal||')'||
1419: extra_err_info||': '||
1420: ad_apps_private.error_buf;
1421: raise;
1422:
1423: end compare_view_text;
1424:

Line 1502: ad_apps_private.do_array_assignment(copy_code.to_schema,

1498:
1499: -- build one line of sql statement in the global variable in
1500: -- the global array variable in to schema.
1501:
1502: ad_apps_private.do_array_assignment(copy_code.to_schema,
1503: c1rec.text, row_count);
1504: end loop;
1505: -- once we have fetched all source
1506: -- then create the object

Line 1514: ad_apps_private.do_array_assignment(copy_code.to_schema, statement, 1);

1510: pragma exception_init(name_already_used, -955);
1511: begin
1512: statement := 'create or replace ';
1513: -- build the first line of the array of sql statement
1514: ad_apps_private.do_array_assignment(copy_code.to_schema, statement, 1);
1515: -- execute the array of statement.
1516: ad_apps_private.do_apps_array_ddl(copy_code.to_schema, 1, row_count);
1517: exception
1518: when name_already_used then

Line 1516: ad_apps_private.do_apps_array_ddl(copy_code.to_schema, 1, row_count);

1512: statement := 'create or replace ';
1513: -- build the first line of the array of sql statement
1514: ad_apps_private.do_array_assignment(copy_code.to_schema, statement, 1);
1515: -- execute the array of statement.
1516: ad_apps_private.do_apps_array_ddl(copy_code.to_schema, 1, row_count);
1517: exception
1518: when name_already_used then
1519: -- first reset error buf
1520: ad_apps_private.error_buf := null;

Line 1520: ad_apps_private.error_buf := null;

1516: ad_apps_private.do_apps_array_ddl(copy_code.to_schema, 1, row_count);
1517: exception
1518: when name_already_used then
1519: -- first reset error buf
1520: ad_apps_private.error_buf := null;
1521: -- drop any synonym by such name and retry
1522: ad_apps_private.drop_object(copy_code.to_schema,
1523: copy_code.object_name, 'SYNONYM');
1524: ad_apps_private.do_apps_array_ddl(copy_code.to_schema, 1, row_count);

Line 1522: ad_apps_private.drop_object(copy_code.to_schema,

1518: when name_already_used then
1519: -- first reset error buf
1520: ad_apps_private.error_buf := null;
1521: -- drop any synonym by such name and retry
1522: ad_apps_private.drop_object(copy_code.to_schema,
1523: copy_code.object_name, 'SYNONYM');
1524: ad_apps_private.do_apps_array_ddl(copy_code.to_schema, 1, row_count);
1525: end;
1526: exception

Line 1524: ad_apps_private.do_apps_array_ddl(copy_code.to_schema, 1, row_count);

1520: ad_apps_private.error_buf := null;
1521: -- drop any synonym by such name and retry
1522: ad_apps_private.drop_object(copy_code.to_schema,
1523: copy_code.object_name, 'SYNONYM');
1524: ad_apps_private.do_apps_array_ddl(copy_code.to_schema, 1, row_count);
1525: end;
1526: exception
1527: when success_with_comp_error then
1528: --

Line 1533: ad_apps_private.error_buf := null;

1529: -- Trap and ignore ORA-24344: success with compilation error
1530: -- This only happens on ORACLE 8
1531: --
1532: -- reset main error buffer
1533: ad_apps_private.error_buf := null;
1534: when others then
1535: ad_apps_private.error_buf := 'ad_apps_private.copy_code('||object_name||','
1536: ||object_type||','||from_schema||','||to_schema||'): '
1537: || ad_apps_private.error_buf;

Line 1535: ad_apps_private.error_buf := 'ad_apps_private.copy_code('||object_name||','

1531: --
1532: -- reset main error buffer
1533: ad_apps_private.error_buf := null;
1534: when others then
1535: ad_apps_private.error_buf := 'ad_apps_private.copy_code('||object_name||','
1536: ||object_type||','||from_schema||','||to_schema||'): '
1537: || ad_apps_private.error_buf;
1538: raise;
1539:

Line 1537: || ad_apps_private.error_buf;

1533: ad_apps_private.error_buf := null;
1534: when others then
1535: ad_apps_private.error_buf := 'ad_apps_private.copy_code('||object_name||','
1536: ||object_type||','||from_schema||','||to_schema||'): '
1537: || ad_apps_private.error_buf;
1538: raise;
1539:
1540: end copy_code;
1541:

Line 1753: ad_apps_private.error_buf := 'ad_apps_private.compare_code('||

1749: raise no_data_found;
1750:
1751: exception
1752: when others then
1753: ad_apps_private.error_buf := 'ad_apps_private.compare_code('||
1754: object_name||','||object_type||','||from_schema||','||to_schema||
1755: ','||comp_level||','||local_equal||')'||extra_err_info||': '||
1756: ad_apps_private.error_buf;
1757: raise;

Line 1756: ad_apps_private.error_buf;

1752: when others then
1753: ad_apps_private.error_buf := 'ad_apps_private.compare_code('||
1754: object_name||','||object_type||','||from_schema||','||to_schema||
1755: ','||comp_level||','||local_equal||')'||extra_err_info||': '||
1756: ad_apps_private.error_buf;
1757: raise;
1758:
1759: end compare_code;
1760:

Line 1881: ad_apps_private.drop_object(apps_schema, apps_name(cust_row_index),

1877: --
1878: if found_cust = 'TRUE'
1879: and apps_type(cust_row_index) = 'SYNONYM' then
1880:
1881: ad_apps_private.drop_object(apps_schema, apps_name(cust_row_index),
1882: 'SYNONYM');
1883: end if;
1884: -- end if customized object exists and is synonym
1885: else

Line 1888: ad_apps_private.drop_object(apps_schema, rtrim(drop_rec.object_name),

1884: -- end if customized object exists and is synonym
1885: else
1886: -- Existing object in APPS should be a synonym. Just drop it.
1887:
1888: ad_apps_private.drop_object(apps_schema, rtrim(drop_rec.object_name),
1889: 'SYNONYM');
1890: end if;
1891: -- end if active exception object
1892: end loop;

Line 2030: ad_apps_private.drop_object(apps_schema,

2026: -- drop it and then recreate it
2027:
2028: -- Drop synonym
2029:
2030: ad_apps_private.drop_object(apps_schema,
2031: apps_name(cust_row_index), 'SYNONYM');
2032:
2033: -- Recreate synonym
2034: DECLARE

Line 2061: ad_apps_private.error_buf := 'create_base_gs('||base_schema||','||

2057: -- end loop to handle exception objects
2058:
2059: exception
2060: when others then
2061: ad_apps_private.error_buf := 'create_base_gs('||base_schema||','||
2062: apps_schema||'): '||what_part||ad_apps_private.error_buf;
2063: raise;
2064: end create_base_gs;
2065:

Line 2062: apps_schema||'): '||what_part||ad_apps_private.error_buf;

2058:
2059: exception
2060: when others then
2061: ad_apps_private.error_buf := 'create_base_gs('||base_schema||','||
2062: apps_schema||'): '||what_part||ad_apps_private.error_buf;
2063: raise;
2064: end create_base_gs;
2065:
2066: procedure create_base_gs

Line 2136: ad_apps_private.error_buf := 'ad_apps_private.create_gs('||

2132: else
2133: with_option_print := 'FALSE';
2134: end if;
2135:
2136: ad_apps_private.error_buf := 'ad_apps_private.create_gs('||
2137: object_owner_schema||','||to_schema||','||object_name||
2138: ', '||with_option_print||','||privs||','||
2139: grant_from_schema||'): '||ad_apps_private.error_buf;
2140: raise;

Line 2139: grant_from_schema||'): '||ad_apps_private.error_buf;

2135:
2136: ad_apps_private.error_buf := 'ad_apps_private.create_gs('||
2137: object_owner_schema||','||to_schema||','||object_name||
2138: ', '||with_option_print||','||privs||','||
2139: grant_from_schema||'): '||ad_apps_private.error_buf;
2140: raise;
2141: end create_gs;
2142:
2143:

Line 2171: ad_apps_private.exact_synonym_match(to_schema, c1rec.synonym_name,

2167: --
2168: -- Check for exact synonym match. Drop and recreate synonym
2169: -- if not exact synonym match
2170: --
2171: ad_apps_private.exact_synonym_match(to_schema, c1rec.synonym_name,
2172: from_schema, c1rec.synonym_name, exact_syn_match,
2173: any_obj_w_this_name, type_of_obj);
2174:
2175: if not exact_syn_match then

Line 2194: ad_apps_private.drop_object(to_schema, c1rec.synonym_name,

2190: if type_of_obj = 'PKG_S_AND_B'
2191: or type_of_obj = 'PACKAGE'
2192: or type_of_obj = 'PACKAGE BODY' then
2193: -- existing object is package
2194: ad_apps_private.drop_object(to_schema, c1rec.synonym_name,
2195: 'PACKAGE');
2196: else
2197: -- existing object not package
2198: ad_apps_private.drop_object(to_schema, c1rec.synonym_name,

Line 2198: ad_apps_private.drop_object(to_schema, c1rec.synonym_name,

2194: ad_apps_private.drop_object(to_schema, c1rec.synonym_name,
2195: 'PACKAGE');
2196: else
2197: -- existing object not package
2198: ad_apps_private.drop_object(to_schema, c1rec.synonym_name,
2199: type_of_obj);
2200: end if; -- end if existing object is package
2201: end if; -- end if any existing object with this name in toschema
2202:

Line 2206: ad_apps_private.create_gs(from_schema,to_schema,

2202:
2203: -- create grant/synonym
2204: begin
2205: if grant_from_schema is not null then
2206: ad_apps_private.create_gs(from_schema,to_schema,
2207: c1rec.synonym_name,FALSE,'ALL',grant_from_schema);
2208: else
2209: ad_apps_private.create_gs(from_schema,to_schema,
2210: c1rec.synonym_name,TRUE,'ALL');

Line 2209: ad_apps_private.create_gs(from_schema,to_schema,

2205: if grant_from_schema is not null then
2206: ad_apps_private.create_gs(from_schema,to_schema,
2207: c1rec.synonym_name,FALSE,'ALL',grant_from_schema);
2208: else
2209: ad_apps_private.create_gs(from_schema,to_schema,
2210: c1rec.synonym_name,TRUE,'ALL');
2211: end if;
2212: exception
2213: when name_already_used then

Line 2215: ad_apps_private.error_buf := null;

2211: end if;
2212: exception
2213: when name_already_used then
2214: -- first reset error buf
2215: ad_apps_private.error_buf := null;
2216: -- first drop synonym
2217: ad_apps_private.drop_object(to_schema,c1rec.synonym_name,
2218: 'SYNONYM');
2219: -- then create the synonym

Line 2217: ad_apps_private.drop_object(to_schema,c1rec.synonym_name,

2213: when name_already_used then
2214: -- first reset error buf
2215: ad_apps_private.error_buf := null;
2216: -- first drop synonym
2217: ad_apps_private.drop_object(to_schema,c1rec.synonym_name,
2218: 'SYNONYM');
2219: -- then create the synonym
2220: if grant_from_schema is not null then
2221: ad_apps_private.create_gs(from_schema,to_schema,

Line 2221: ad_apps_private.create_gs(from_schema,to_schema,

2217: ad_apps_private.drop_object(to_schema,c1rec.synonym_name,
2218: 'SYNONYM');
2219: -- then create the synonym
2220: if grant_from_schema is not null then
2221: ad_apps_private.create_gs(from_schema,to_schema,
2222: c1rec.synonym_name,FALSE,'ALL',grant_from_schema);
2223: else
2224: ad_apps_private.create_gs(from_schema,to_schema,
2225: c1rec.synonym_name,TRUE,'ALL');

Line 2224: ad_apps_private.create_gs(from_schema,to_schema,

2220: if grant_from_schema is not null then
2221: ad_apps_private.create_gs(from_schema,to_schema,
2222: c1rec.synonym_name,FALSE,'ALL',grant_from_schema);
2223: else
2224: ad_apps_private.create_gs(from_schema,to_schema,
2225: c1rec.synonym_name,TRUE,'ALL');
2226: end if;
2227: end; -- block for creating the grant/synonym
2228: end if; -- not exact synonym match: (re-)create synonym

Line 2233: ad_apps_private.error_buf := 'create_synonyms('||

2229: end loop; -- through all normal synonyms in APPS
2230:
2231: exception
2232: when others then
2233: ad_apps_private.error_buf := 'create_synonyms('||
2234: from_schema||','||to_schema||','||grant_from_schema||')'||
2235: extra_err_info||': '||
2236: ad_apps_private.error_buf;
2237: raise;

Line 2236: ad_apps_private.error_buf;

2232: when others then
2233: ad_apps_private.error_buf := 'create_synonyms('||
2234: from_schema||','||to_schema||','||grant_from_schema||')'||
2235: extra_err_info||': '||
2236: ad_apps_private.error_buf;
2237: raise;
2238: end create_synonyms;
2239:
2240:

Line 2262: ad_apps_private.exact_synonym_match(toschema, c1rec.synonym_name,

2258: --
2259: -- Check for exact synonym match. Drop and recreate synonym
2260: -- if not exact synonym match
2261: --
2262: ad_apps_private.exact_synonym_match(toschema, c1rec.synonym_name,
2263: fromschema, c1rec.synonym_name, exact_syn_match,
2264: any_obj_w_this_name, type_of_obj);
2265:
2266: if not exact_syn_match then

Line 2285: ad_apps_private.drop_object(toschema, c1rec.synonym_name,

2281: if type_of_obj = 'PKG_S_AND_B'
2282: or type_of_obj = 'PACKAGE'
2283: or type_of_obj = 'PACKAGE BODY' then
2284: -- existing object is package
2285: ad_apps_private.drop_object(toschema, c1rec.synonym_name,
2286: 'PACKAGE');
2287: else
2288: -- existing object not package
2289: ad_apps_private.drop_object(toschema, c1rec.synonym_name,

Line 2289: ad_apps_private.drop_object(toschema, c1rec.synonym_name,

2285: ad_apps_private.drop_object(toschema, c1rec.synonym_name,
2286: 'PACKAGE');
2287: else
2288: -- existing object not package
2289: ad_apps_private.drop_object(toschema, c1rec.synonym_name,
2290: type_of_obj);
2291: end if; -- end if existing object is package
2292: end if; -- end if any existing object with this name in toschema
2293:

Line 2296: ad_apps_private.create_gs(fromschema,toschema,

2292: end if; -- end if any existing object with this name in toschema
2293:
2294: -- create grant/synonym
2295: begin
2296: ad_apps_private.create_gs(fromschema,toschema,
2297: c1rec.synonym_name,TRUE,'ALL');
2298: exception
2299: when name_already_used then
2300: -- first reset error buf

Line 2301: ad_apps_private.error_buf := null;

2297: c1rec.synonym_name,TRUE,'ALL');
2298: exception
2299: when name_already_used then
2300: -- first reset error buf
2301: ad_apps_private.error_buf := null;
2302: -- first drop synonym
2303: ad_apps_private.drop_object(toschema, c1rec.synonym_name,
2304: 'SYNONYM');
2305: -- then create the synonym

Line 2303: ad_apps_private.drop_object(toschema, c1rec.synonym_name,

2299: when name_already_used then
2300: -- first reset error buf
2301: ad_apps_private.error_buf := null;
2302: -- first drop synonym
2303: ad_apps_private.drop_object(toschema, c1rec.synonym_name,
2304: 'SYNONYM');
2305: -- then create the synonym
2306: ad_apps_private.create_gs(fromschema,toschema,
2307: c1rec.synonym_name,TRUE,'ALL');

Line 2306: ad_apps_private.create_gs(fromschema,toschema,

2302: -- first drop synonym
2303: ad_apps_private.drop_object(toschema, c1rec.synonym_name,
2304: 'SYNONYM');
2305: -- then create the synonym
2306: ad_apps_private.create_gs(fromschema,toschema,
2307: c1rec.synonym_name,TRUE,'ALL');
2308: end; -- block for creating the grant/synonym
2309: end if; -- not exact synonym match: (re-)create synonym
2310: end loop; -- through all normal synonyms in APPS

Line 2314: ad_apps_private.error_buf := 'copy_odd_synonyms('||

2310: end loop; -- through all normal synonyms in APPS
2311:
2312: exception
2313: when others then
2314: ad_apps_private.error_buf := 'copy_odd_synonyms('||
2315: fromschema||','||toschema||')'||extra_err_info||': '||
2316: ad_apps_private.error_buf;
2317: raise;
2318: end copy_odd_synonyms;

Line 2316: ad_apps_private.error_buf;

2312: exception
2313: when others then
2314: ad_apps_private.error_buf := 'copy_odd_synonyms('||
2315: fromschema||','||toschema||')'||extra_err_info||': '||
2316: ad_apps_private.error_buf;
2317: raise;
2318: end copy_odd_synonyms;
2319:
2320:

Line 2390: ad_apps_private.error_buf := 'statement='||

2386: end loop;
2387: exception
2388: when others then
2389: dbms_sql.close_cursor(c);
2390: ad_apps_private.error_buf := 'statement='||
2391: statement||':'||
2392: ad_apps_private.error_buf;
2393: raise;
2394: end;

Line 2392: ad_apps_private.error_buf;

2388: when others then
2389: dbms_sql.close_cursor(c);
2390: ad_apps_private.error_buf := 'statement='||
2391: statement||':'||
2392: ad_apps_private.error_buf;
2393: raise;
2394: end;
2395:
2396:

Line 2421: ad_apps_private.error_buf := 'statement='||

2417: end loop;
2418: exception
2419: when others then
2420: dbms_sql.close_cursor(c);
2421: ad_apps_private.error_buf := 'statement='||
2422: statement||':'||
2423: ad_apps_private.error_buf;
2424: raise;
2425: end;

Line 2423: ad_apps_private.error_buf;

2419: when others then
2420: dbms_sql.close_cursor(c);
2421: ad_apps_private.error_buf := 'statement='||
2422: statement||':'||
2423: ad_apps_private.error_buf;
2424: raise;
2425: end;
2426:
2427:

Line 2503: ad_apps_private.error_buf := 'statement='||

2499: end loop;
2500: exception
2501: when others then
2502: dbms_sql.close_cursor(c);
2503: ad_apps_private.error_buf := 'statement='||
2504: statement||':'||
2505: ad_apps_private.error_buf;
2506: raise;
2507: end;

Line 2505: ad_apps_private.error_buf;

2501: when others then
2502: dbms_sql.close_cursor(c);
2503: ad_apps_private.error_buf := 'statement='||
2504: statement||':'||
2505: ad_apps_private.error_buf;
2506: raise;
2507: end;
2508:
2509: -- Only recreate the view if:

Line 2565: ad_apps_private.do_apps_ddl(apps_schema,statement);

2561: declare
2562: name_already_used exception;
2563: pragma exception_init(name_already_used, -955);
2564: begin
2565: ad_apps_private.do_apps_ddl(apps_schema,statement);
2566: exception
2567: when name_already_used then
2568: -- first reset error buf
2569: ad_apps_private.error_buf := null;

Line 2569: ad_apps_private.error_buf := null;

2565: ad_apps_private.do_apps_ddl(apps_schema,statement);
2566: exception
2567: when name_already_used then
2568: -- first reset error buf
2569: ad_apps_private.error_buf := null;
2570: -- drop synonym and try view create again
2571: ad_apps_private.drop_object(apps_schema,
2572: l_table_name, 'SYNONYM');
2573: ad_apps_private.do_apps_ddl(apps_schema,statement);

Line 2571: ad_apps_private.drop_object(apps_schema,

2567: when name_already_used then
2568: -- first reset error buf
2569: ad_apps_private.error_buf := null;
2570: -- drop synonym and try view create again
2571: ad_apps_private.drop_object(apps_schema,
2572: l_table_name, 'SYNONYM');
2573: ad_apps_private.do_apps_ddl(apps_schema,statement);
2574: end;
2575:

Line 2573: ad_apps_private.do_apps_ddl(apps_schema,statement);

2569: ad_apps_private.error_buf := null;
2570: -- drop synonym and try view create again
2571: ad_apps_private.drop_object(apps_schema,
2572: l_table_name, 'SYNONYM');
2573: ad_apps_private.do_apps_ddl(apps_schema,statement);
2574: end;
2575:
2576: exception
2577: when success_with_comp_error then

Line 2583: ad_apps_private.error_buf := null;

2579: -- Trap and ignore ORA-24344: success with compilation error
2580: -- This only happens on ORACLE 8
2581: --
2582: -- reset main error buffer
2583: ad_apps_private.error_buf := null;
2584: end;
2585: end if; -- view_is_old
2586: else
2587: -- no more oracle views to process for this schema

Line 2596: ad_apps_private.error_buf := 'statement='||statement||': '||

2592:
2593: exception
2594: when others then
2595: dbms_sql.close_cursor(c);
2596: ad_apps_private.error_buf := 'statement='||statement||': '||
2597: ad_apps_private.error_buf;
2598: raise;
2599: end;
2600:

Line 2597: ad_apps_private.error_buf;

2593: exception
2594: when others then
2595: dbms_sql.close_cursor(c);
2596: ad_apps_private.error_buf := 'statement='||statement||': '||
2597: ad_apps_private.error_buf;
2598: raise;
2599: end;
2600:
2601: else

Line 2610: ad_apps_private.error_buf := 'create_special_views('||install_group_num||

2606: end loop;
2607: exception
2608: when others then
2609: dbms_sql.close_cursor(oracle_id_cursor);
2610: ad_apps_private.error_buf := 'create_special_views('||install_group_num||
2611: ','||aol_schema||
2612: ','||apps_schema||',create_mls_views): '||
2613: ad_apps_private.error_buf;
2614: raise;

Line 2613: ad_apps_private.error_buf;

2609: dbms_sql.close_cursor(oracle_id_cursor);
2610: ad_apps_private.error_buf := 'create_special_views('||install_group_num||
2611: ','||aol_schema||
2612: ','||apps_schema||',create_mls_views): '||
2613: ad_apps_private.error_buf;
2614: raise;
2615: end create_special_views;
2616:
2617:

Line 2641: ad_apps_private.copy_view(v_rec.view_name, fromschema, toschema);

2637: -- Check if view exists in destination schema,
2638: -- and create it if it's not already there
2639: --
2640: if v_rec.dest_len is null then
2641: ad_apps_private.copy_view(v_rec.view_name, fromschema, toschema);
2642: else
2643: --
2644: -- View exists in both schemas
2645: --

Line 2650: ad_apps_private.copy_view(v_rec.view_name, fromschema, toschema);

2646: -- Compare view lengths. Re-create view in dest schema if the
2647: -- two views have different lengths.
2648: --
2649: if v_rec.source_len <> v_rec.dest_len then
2650: ad_apps_private.copy_view(v_rec.view_name, fromschema, toschema);
2651: else
2652: --
2653: -- View lengths equal. Compare actual view text.
2654: --

Line 2656: ad_apps_private.compare_view_text(v_rec.view_name, fromschema,

2652: --
2653: -- View lengths equal. Compare actual view text.
2654: --
2655:
2656: ad_apps_private.compare_view_text(v_rec.view_name, fromschema,
2657: toschema, v_rec.source_len, v_rec.dest_len, comp_result);
2658:
2659: -- Only copy view to destination schema if text not equal
2660:

Line 2662: ad_apps_private.copy_view(v_rec.view_name, fromschema, toschema);

2658:
2659: -- Only copy view to destination schema if text not equal
2660:
2661: if comp_result = 'FALSE' then
2662: ad_apps_private.copy_view(v_rec.view_name, fromschema, toschema);
2663: end if;
2664:
2665: end if; -- view lengths equal
2666: end if; -- view exists in dest schema

Line 2670: ad_apps_private.error_buf := 'copy_views('||aoluser||','||fromschema||','||

2666: end if; -- view exists in dest schema
2667: end loop;
2668: exception
2669: when others then
2670: ad_apps_private.error_buf := 'copy_views('||aoluser||','||fromschema||','||
2671: toschema||'): '||ad_apps_private.error_buf;
2672: raise;
2673: end copy_views;
2674:

Line 2671: toschema||'): '||ad_apps_private.error_buf;

2667: end loop;
2668: exception
2669: when others then
2670: ad_apps_private.error_buf := 'copy_views('||aoluser||','||fromschema||','||
2671: toschema||'): '||ad_apps_private.error_buf;
2672: raise;
2673: end copy_views;
2674:
2675:

Line 2739: ad_apps_private.copy_code(src_rec.object_name, src_rec.object_type,

2735: if src_rec.name2 is null then
2736:
2737: -- object not in destination schema, so copy it to destination schema
2738:
2739: ad_apps_private.copy_code(src_rec.object_name, src_rec.object_type,
2740: fromschema, toschema);
2741:
2742: else
2743: -- get header information for object in source schema

Line 2780: ad_apps_private.copy_code(src_rec.object_name, src_rec.object_type,

2776: -- copy source to destination
2777:
2778: if dst_header is null then
2779:
2780: ad_apps_private.copy_code(src_rec.object_name, src_rec.object_type,
2781: fromschema, toschema);
2782:
2783: else
2784:

Line 2791: ad_apps_private.copy_code(src_rec.object_name,

2787: -- possibly do more extensive comparison if header lines same
2788:
2789: if src_header <> dst_header then
2790:
2791: ad_apps_private.copy_code(src_rec.object_name,
2792: src_rec.object_type, fromschema, toschema);
2793:
2794: else
2795:

Line 2799: ad_apps_private.compare_code(src_rec.object_name,

2795:
2796: -- header strings are identical
2797: -- do object comparison according to compare_level
2798:
2799: ad_apps_private.compare_code(src_rec.object_name,
2800: src_rec.object_type, fromschema, toschema,
2801: compare_level, objs_equal);
2802:
2803: -- copy source to dest if not equal

Line 2807: ad_apps_private.copy_code(src_rec.object_name,

2803: -- copy source to dest if not equal
2804:
2805: if objs_equal = 'FALSE' then
2806:
2807: ad_apps_private.copy_code(src_rec.object_name,
2808: src_rec.object_type, fromschema, toschema);
2809:
2810: end if; -- source and destination objects not identical
2811:

Line 2822: ad_apps_private.compare_code(src_rec.object_name,

2818: -- no header information in source schema object
2819: -- do full object comparison
2820: -- (even if compare_level <> 'full')
2821:
2822: ad_apps_private.compare_code(src_rec.object_name,
2823: src_rec.object_type, fromschema, toschema,
2824: 'full', objs_equal);
2825:
2826: -- copy source to dest if not equal

Line 2830: ad_apps_private.copy_code(src_rec.object_name,

2826: -- copy source to dest if not equal
2827:
2828: if objs_equal = 'FALSE' then
2829:
2830: ad_apps_private.copy_code(src_rec.object_name,
2831: src_rec.object_type, fromschema, toschema);
2832:
2833: end if; -- source and destination objects not identical
2834:

Line 2842: ad_apps_private.error_buf := 'copy_stored_progs('||fromschema||','||

2838: end loop; -- loop over all stored progs in source schema
2839:
2840: exception
2841: when others then
2842: ad_apps_private.error_buf := 'copy_stored_progs('||fromschema||','||
2843: toschema||','||p_object_type||','||p_subset||','||
2844: compare_level||'): '||ad_apps_private.error_buf;
2845: raise;
2846: end copy_stored_progs;

Line 2844: compare_level||'): '||ad_apps_private.error_buf;

2840: exception
2841: when others then
2842: ad_apps_private.error_buf := 'copy_stored_progs('||fromschema||','||
2843: toschema||','||p_object_type||','||p_subset||','||
2844: compare_level||'): '||ad_apps_private.error_buf;
2845: raise;
2846: end copy_stored_progs;
2847:
2848:

Line 2963: ad_apps_private.error_buf := 'exact_synonym_match('||syn_own_schema||

2959: -- end if no exact synonym match
2960:
2961: exception
2962: when others then
2963: ad_apps_private.error_buf := 'exact_synonym_match('||syn_own_schema||
2964: ','||syn_name||','||tab_owner||','||tab_name||'): '||
2965: ad_apps_private.error_buf;
2966: raise;
2967: end exact_synonym_match;

Line 2965: ad_apps_private.error_buf;

2961: exception
2962: when others then
2963: ad_apps_private.error_buf := 'exact_synonym_match('||syn_own_schema||
2964: ','||syn_name||','||tab_owner||','||tab_name||'): '||
2965: ad_apps_private.error_buf;
2966: raise;
2967: end exact_synonym_match;
2968:
2969:

Line 3189: ad_apps_private.do_apps_ddl(recompile_schema, statement);

3185:
3186: -- dbms_output.put_line('('||obj_levels(i)||') '||statement);
3187:
3188: begin
3189: ad_apps_private.do_apps_ddl(recompile_schema, statement);
3190: exception
3191: when others then
3192: ad_apps_private.error_buf := null;
3193: end;

Line 3192: ad_apps_private.error_buf := null;

3188: begin
3189: ad_apps_private.do_apps_ddl(recompile_schema, statement);
3190: exception
3191: when others then
3192: ad_apps_private.error_buf := null;
3193: end;
3194:
3195: end if;
3196: -- end if object exists in desc schema

Line 3207: ad_apps_private.error_buf := 'recomp_referenced_objs('||object_name||

3203: -- end loop to compile invalid objects for all levels
3204:
3205: exception
3206: when others then
3207: ad_apps_private.error_buf := 'recomp_referenced_objs('||object_name||
3208: ','||obj_list_schema||','||recompile_schema||'): '||
3209: ad_apps_private.error_buf;
3210: raise;
3211: end recomp_referenced_objs;

Line 3209: ad_apps_private.error_buf;

3205: exception
3206: when others then
3207: ad_apps_private.error_buf := 'recomp_referenced_objs('||object_name||
3208: ','||obj_list_schema||','||recompile_schema||'): '||
3209: ad_apps_private.error_buf;
3210: raise;
3211: end recomp_referenced_objs;
3212:
3213:

Line 3248: ad_apps_private.error_buf := 'ad_apps_private.build_view_columns('||

3244: out_column_text := column_text;
3245:
3246: exception
3247: when others then
3248: ad_apps_private.error_buf := 'ad_apps_private.build_view_columns('||
3249: from_schema||','||view_name||',out_column_text): '||
3250: ad_apps_private.error_buf;
3251: raise;
3252: end build_view_columns;

Line 3250: ad_apps_private.error_buf;

3246: exception
3247: when others then
3248: ad_apps_private.error_buf := 'ad_apps_private.build_view_columns('||
3249: from_schema||','||view_name||',out_column_text): '||
3250: ad_apps_private.error_buf;
3251: raise;
3252: end build_view_columns;
3253:
3254:

Line 3306: ad_apps_private.error_buf := 'show_exception_list: '||

3302: dbms_output.put_line('-');
3303:
3304: exception
3305: when others then
3306: ad_apps_private.error_buf := 'show_exception_list: '||
3307: ad_apps_private.error_buf;
3308: raise;
3309: end show_exception_list;
3310:

Line 3307: ad_apps_private.error_buf;

3303:
3304: exception
3305: when others then
3306: ad_apps_private.error_buf := 'show_exception_list: '||
3307: ad_apps_private.error_buf;
3308: raise;
3309: end show_exception_list;
3310:
3311:

Line 3784: ad_apps_private.error_buf := 'load_exception_list: '||

3780: -- end if initialize list
3781:
3782: exception
3783: when others then
3784: ad_apps_private.error_buf := 'load_exception_list: '||
3785: ad_apps_private.error_buf;
3786: raise;
3787: end load_exception_list;
3788:

Line 3785: ad_apps_private.error_buf;

3781:
3782: exception
3783: when others then
3784: ad_apps_private.error_buf := 'load_exception_list: '||
3785: ad_apps_private.error_buf;
3786: raise;
3787: end load_exception_list;
3788:
3789:

Line 3877: ad_apps_private.exact_synonym_match(base_schema_name,

3873:
3874: whereami := ' C ';
3875:
3876: if trigger_is_base then
3877: ad_apps_private.exact_synonym_match(base_schema_name,
3878: trigger_obj_name(i), null, null,
3879: matches_exactly, any_obj_w_this_name, type_of_existing_obj);
3880: else
3881: ad_apps_private.exact_synonym_match(apps_schema_name,

Line 3881: ad_apps_private.exact_synonym_match(apps_schema_name,

3877: ad_apps_private.exact_synonym_match(base_schema_name,
3878: trigger_obj_name(i), null, null,
3879: matches_exactly, any_obj_w_this_name, type_of_existing_obj);
3880: else
3881: ad_apps_private.exact_synonym_match(apps_schema_name,
3882: trigger_obj_name(i), null, null,
3883: matches_exactly, any_obj_w_this_name, type_of_existing_obj);
3884: end if;
3885:

Line 3904: ad_apps_private.exact_synonym_match(apps_schema_name,apps_name(i),

3900: whereami := ' E ';
3901:
3902: if apps_type(i) = 'SYNONYM' then
3903: if points_to_base then
3904: ad_apps_private.exact_synonym_match(apps_schema_name,apps_name(i),
3905: base_schema_name, points_to_name(i), matches_exactly,
3906: any_obj_w_this_name, type_of_existing_obj);
3907: else
3908: ad_apps_private.exact_synonym_match(apps_schema_name,apps_name(i),

Line 3908: ad_apps_private.exact_synonym_match(apps_schema_name,apps_name(i),

3904: ad_apps_private.exact_synonym_match(apps_schema_name,apps_name(i),
3905: base_schema_name, points_to_name(i), matches_exactly,
3906: any_obj_w_this_name, type_of_existing_obj);
3907: else
3908: ad_apps_private.exact_synonym_match(apps_schema_name,apps_name(i),
3909: apps_schema_name, points_to_name(i), matches_exactly,
3910: any_obj_w_this_name, type_of_existing_obj);
3911: end if;
3912: else

Line 3913: ad_apps_private.exact_synonym_match(apps_schema_name,apps_name(i),

3909: apps_schema_name, points_to_name(i), matches_exactly,
3910: any_obj_w_this_name, type_of_existing_obj);
3911: end if;
3912: else
3913: ad_apps_private.exact_synonym_match(apps_schema_name,apps_name(i),
3914: null, null, matches_exactly, any_obj_w_this_name,
3915: type_of_existing_obj);
3916: end if;
3917:

Line 3985: ad_apps_private.error_buf := 'matching_exception_object('||

3981: -- end if base object is active exception object
3982:
3983: exception
3984: when others then
3985: ad_apps_private.error_buf := 'matching_exception_object('||
3986: base_schema_name||','||base_object_name||','||
3987: base_object_type||','||except_type||','||
3988: apps_schema_name||')<'||whereami||'> : '||
3989: ad_apps_private.error_buf;

Line 3989: ad_apps_private.error_buf;

3985: ad_apps_private.error_buf := 'matching_exception_object('||
3986: base_schema_name||','||base_object_name||','||
3987: base_object_type||','||except_type||','||
3988: apps_schema_name||')<'||whereami||'> : '||
3989: ad_apps_private.error_buf;
3990: raise;
3991: end matching_exception_object;
3992:
3993:

Line 4009: if ad_apps_private.is_mls is null

4005: where read_only_flag = 'K';
4006: begin
4007: -- only perform the work if the variables are null, meaning that
4008: -- this routine has not been called before
4009: if ad_apps_private.is_mls is null
4010: or ad_apps_private.is_mc is null then
4011: -- get values for is_mc and is_mls
4012: declare
4013: x varchar2(30);

Line 4010: or ad_apps_private.is_mc is null then

4006: begin
4007: -- only perform the work if the variables are null, meaning that
4008: -- this routine has not been called before
4009: if ad_apps_private.is_mls is null
4010: or ad_apps_private.is_mc is null then
4011: -- get values for is_mc and is_mls
4012: declare
4013: x varchar2(30);
4014: y varchar2(30);

Line 4034: -- In both these cases, we have to set "ad_apps_private.is_mc"

4030:
4031: if x = 'Y' then
4032: -- Fixed bug 3258312 : Although MRC flag is at 'Y', someone
4033: -- may have dropped it or the release might be 11.5.10 or more.
4034: -- In both these cases, we have to set "ad_apps_private.is_mc"
4035: -- to 'FALSE'.
4036:
4037: -- get mrc schema name from FND_ORACLE_USERID
4038:

Line 4051: ad_apps_private.is_mc := FALSE;

4047: -- Reset MRC flag to FALSE.
4048:
4049: close GET_MRC_SCHEMA_NAME;
4050:
4051: ad_apps_private.is_mc := FALSE;
4052: else
4053:
4054: -- MRC schema registered in FND_ORACLE_USERID, Check in DBA_USERS.
4055:

Line 4058: if ad_apps_private.check_if_schema_exists(l_mrc_schema_name) then

4054: -- MRC schema registered in FND_ORACLE_USERID, Check in DBA_USERS.
4055:
4056: close GET_MRC_SCHEMA_NAME;
4057:
4058: if ad_apps_private.check_if_schema_exists(l_mrc_schema_name) then
4059:
4060: -- Fixed bug 3353468 to resolve a runtime issue for
4061: -- 11.5.10. Check if the release>=11.5.10. if yes, MRC
4062: -- is not enabled

Line 4095: ad_apps_private.is_mc := TRUE;

4091: l_rel_comp_result := compare_releases(l_release_name ,
4092: '11.5.9');
4093:
4094: if (l_rel_comp_result = TRUE) then
4095: ad_apps_private.is_mc := TRUE;
4096: else
4097: ad_apps_private.is_mc := FALSE;
4098: end if;
4099:

Line 4097: ad_apps_private.is_mc := FALSE;

4093:
4094: if (l_rel_comp_result = TRUE) then
4095: ad_apps_private.is_mc := TRUE;
4096: else
4097: ad_apps_private.is_mc := FALSE;
4098: end if;
4099:
4100: else
4101: -- no MRC schema in DBA_USERS!

Line 4102: ad_apps_private.is_mc := FALSE;

4098: end if;
4099:
4100: else
4101: -- no MRC schema in DBA_USERS!
4102: ad_apps_private.is_mc := FALSE;
4103: end if;
4104:
4105: end if;
4106: -- end if block for MRC schema registered in FND_ORACLE_USERID

Line 4110: ad_apps_private.is_mc := FALSE;

4106: -- end if block for MRC schema registered in FND_ORACLE_USERID
4107:
4108: else -- if not fnd_product_groups.multi_currency_flag
4109:
4110: ad_apps_private.is_mc := FALSE;
4111:
4112: end if;
4113:
4114: if y = 'Y' then

Line 4115: ad_apps_private.is_mls := TRUE;

4111:
4112: end if;
4113:
4114: if y = 'Y' then
4115: ad_apps_private.is_mls := TRUE;
4116: else
4117: ad_apps_private.is_mls := FALSE;
4118: end if;
4119: dbms_sql.close_cursor(c);

Line 4117: ad_apps_private.is_mls := FALSE;

4113:
4114: if y = 'Y' then
4115: ad_apps_private.is_mls := TRUE;
4116: else
4117: ad_apps_private.is_mls := FALSE;
4118: end if;
4119: dbms_sql.close_cursor(c);
4120: else
4121: raise no_data_found;

Line 4126: ad_apps_private.error_buf := 'statement='||

4122: end if;
4123: exception
4124: when others then
4125: dbms_sql.close_cursor(c);
4126: ad_apps_private.error_buf := 'statement='||
4127: statement||':'||
4128: ad_apps_private.error_buf;
4129: raise;
4130: end;

Line 4128: ad_apps_private.error_buf;

4124: when others then
4125: dbms_sql.close_cursor(c);
4126: ad_apps_private.error_buf := 'statement='||
4127: statement||':'||
4128: ad_apps_private.error_buf;
4129: raise;
4130: end;
4131:
4132: end if;

Line 4136: ad_apps_private.error_buf := 'initialize('||aol_schema||'): '||

4132: end if;
4133:
4134: exception
4135: when others then
4136: ad_apps_private.error_buf := 'initialize('||aol_schema||'): '||
4137: ad_apps_private.error_buf;
4138: raise;
4139: end initialize;
4140:

Line 4137: ad_apps_private.error_buf;

4133:
4134: exception
4135: when others then
4136: ad_apps_private.error_buf := 'initialize('||aol_schema||'): '||
4137: ad_apps_private.error_buf;
4138: raise;
4139: end initialize;
4140:
4141:

Line 4253: ad_apps_private.error_buf := 'c_statement='||

4249: dbms_sql.close_cursor(c);
4250: exception
4251: when others then
4252: dbms_sql.close_cursor(c);
4253: ad_apps_private.error_buf := 'c_statement='||
4254: c_statement||':'||
4255: ad_apps_private.error_buf;
4256: raise;
4257: end is_object_actualised;

Line 4255: ad_apps_private.error_buf;

4251: when others then
4252: dbms_sql.close_cursor(c);
4253: ad_apps_private.error_buf := 'c_statement='||
4254: c_statement||':'||
4255: ad_apps_private.error_buf;
4256: raise;
4257: end is_object_actualised;
4258:
4259: procedure do_apps_ddl_on_patch_edn(

Line 4351: ad_apps_private.error_buf := null;

4347: if (dbms_sql.is_open(l_cur)) then
4348: dbms_sql.close_cursor(l_cur);
4349: end if;
4350:
4351: ad_apps_private.error_buf := null;
4352: when trigger_does_not_exist then
4353: if (dbms_sql.is_open(l_cur)) then
4354: dbms_sql.close_cursor(l_cur);
4355: end if;

Line 4373: ad_apps_private.error_buf := 'do_apps_ddl_on_patch_edn('||schema_name||

4369: dbms_sql.close_cursor(l_cur);
4370: end if;
4371:
4372: if abbrev_stmt = 'FALSE' then
4373: ad_apps_private.error_buf := 'do_apps_ddl_on_patch_edn('||schema_name||
4374: ','||ddl_text|| '): '||ad_apps_private.error_buf;
4375: log_message('exception occurred...1');
4376: log_message('err:<'||ad_apps_private.error_buf||'>');
4377: else

Line 4374: ','||ddl_text|| '): '||ad_apps_private.error_buf;

4370: end if;
4371:
4372: if abbrev_stmt = 'FALSE' then
4373: ad_apps_private.error_buf := 'do_apps_ddl_on_patch_edn('||schema_name||
4374: ','||ddl_text|| '): '||ad_apps_private.error_buf;
4375: log_message('exception occurred...1');
4376: log_message('err:<'||ad_apps_private.error_buf||'>');
4377: else
4378: ad_apps_private.error_buf := 'do_apps_ddl_on_patch_edn('||schema_name||

Line 4376: log_message('err:<'||ad_apps_private.error_buf||'>');

4372: if abbrev_stmt = 'FALSE' then
4373: ad_apps_private.error_buf := 'do_apps_ddl_on_patch_edn('||schema_name||
4374: ','||ddl_text|| '): '||ad_apps_private.error_buf;
4375: log_message('exception occurred...1');
4376: log_message('err:<'||ad_apps_private.error_buf||'>');
4377: else
4378: ad_apps_private.error_buf := 'do_apps_ddl_on_patch_edn('||schema_name||
4379: ', $statement$): '||ad_apps_private.error_buf;
4380: log_message('exception occurred...2');

Line 4378: ad_apps_private.error_buf := 'do_apps_ddl_on_patch_edn('||schema_name||

4374: ','||ddl_text|| '): '||ad_apps_private.error_buf;
4375: log_message('exception occurred...1');
4376: log_message('err:<'||ad_apps_private.error_buf||'>');
4377: else
4378: ad_apps_private.error_buf := 'do_apps_ddl_on_patch_edn('||schema_name||
4379: ', $statement$): '||ad_apps_private.error_buf;
4380: log_message('exception occurred...2');
4381: log_message('err:<'||ad_apps_private.error_buf||'>');
4382: end if;

Line 4379: ', $statement$): '||ad_apps_private.error_buf;

4375: log_message('exception occurred...1');
4376: log_message('err:<'||ad_apps_private.error_buf||'>');
4377: else
4378: ad_apps_private.error_buf := 'do_apps_ddl_on_patch_edn('||schema_name||
4379: ', $statement$): '||ad_apps_private.error_buf;
4380: log_message('exception occurred...2');
4381: log_message('err:<'||ad_apps_private.error_buf||'>');
4382: end if;
4383: raise;

Line 4381: log_message('err:<'||ad_apps_private.error_buf||'>');

4377: else
4378: ad_apps_private.error_buf := 'do_apps_ddl_on_patch_edn('||schema_name||
4379: ', $statement$): '||ad_apps_private.error_buf;
4380: log_message('exception occurred...2');
4381: log_message('err:<'||ad_apps_private.error_buf||'>');
4382: end if;
4383: raise;
4384: end do_apps_ddl_on_patch_edn;
4385:

Line 4447: ad_apps_private.error_buf := null;

4443: -- When there is an exception ORA-00955, while creating an
4444: -- object on patch edition, eat it. It is because the object
4445: -- is not actualized.
4446: when object_already_exists then
4447: ad_apps_private.error_buf := null;
4448:
4449: when others then
4450: dbms_sql.close_cursor(l_cur);
4451: ad_apps_private.error_buf := 'do_apps_array_ddl_on_patch_edn('||schema_name||', '||

Line 4451: ad_apps_private.error_buf := 'do_apps_array_ddl_on_patch_edn('||schema_name||', '||

4447: ad_apps_private.error_buf := null;
4448:
4449: when others then
4450: dbms_sql.close_cursor(l_cur);
4451: ad_apps_private.error_buf := 'do_apps_array_ddl_on_patch_edn('||schema_name||', '||
4452: lb||', '||ub||', '||add_newline||'): '||
4453: ad_apps_private.error_buf;
4454: raise;
4455: end do_apps_array_ddl_on_patch_edn;

Line 4453: ad_apps_private.error_buf;

4449: when others then
4450: dbms_sql.close_cursor(l_cur);
4451: ad_apps_private.error_buf := 'do_apps_array_ddl_on_patch_edn('||schema_name||', '||
4452: lb||', '||ub||', '||add_newline||'): '||
4453: ad_apps_private.error_buf;
4454: raise;
4455: end do_apps_array_ddl_on_patch_edn;
4456:
4457:

Line 4458: end ad_apps_private;

4454: raise;
4455: end do_apps_array_ddl_on_patch_edn;
4456:
4457:
4458: end ad_apps_private;