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.JDR_UTILS dependencies on DBMS_OUTPUT

Line 122: DBMS_OUTPUT.PUT_LINE(LPAD(p_chunk, len));

118: -- starting position), then all we need to do is simply print the chunk
119: -- and reset the starting position.
120: len := LENGTH(p_chunk) + p_indent;
121: IF (len <= p_maxLineSize) THEN
122: DBMS_OUTPUT.PUT_LINE(LPAD(p_chunk, len));
123:
124: -- As we are "ending" an element, we can safely reset the "state"
125: p_indent := 0;
126: p_unclosedQuote := FALSE;

Line 161: DBMS_OUTPUT.PUT_LINE('Error printing document, no end tag encountered.');

157: END IF;
158:
159: -- There should always be an end tag. If not something is very wrong.
160: IF (pos = 0) THEN
161: DBMS_OUTPUT.PUT_LINE('Error printing document, no end tag encountered.');
162: RETURN;
163: END IF;
164:
165: -- If the current element can not fit on the line, so we will have to put

Line 214: DBMS_OUTPUT.PUT_LINE(left);

210: END LOOP;
211:
212: -- Print the partial element
213: left := LPAD(SUBSTR(p_chunk, 1, pos), pos + p_indent);
214: DBMS_OUTPUT.PUT_LINE(left);
215:
216: -- Remember indentation for the next line
217: IF (p_indent = 0) THEN
218: p_indent := LENGTH(left) -

Line 229: DBMS_OUTPUT.PUT_LINE(left);

225: ELSE
226: -- This corresponds to (1) above, the element fitting on one line.
227: -- Print the element
228: left := LPAD(SUBSTR(p_chunk, 1, pos), pos + p_indent);
229: DBMS_OUTPUT.PUT_LINE(left);
230:
231: -- As we are "ending" an element, we can safely reset the "state"
232: p_indent := 0;
233: p_unclosedQuote := FALSE;

Line 272: dbms_output.put_line('Error: Could not find document ' || p_document);

268: BEGIN
269: -- Get the ID of the document
270: docID := getDocumentID(p_document, 'FILE');
271: IF (docID = -1) THEN
272: dbms_output.put_line('Error: Could not find document ' || p_document);
273: RETURN;
274: END IF;
275:
276: -- Drop the document

Line 278: dbms_output.put_line('Successfully deleted document ' || p_document || '.');

274: END IF;
275:
276: -- Drop the document
277: jdr_mds_internal.dropDocument(docID);
278: dbms_output.put_line('Successfully deleted document ' || p_document || '.');
279: END;
280:
281: -- Deletes all empty customization documents from the repository
282: PROCEDURE deleteEmptyCustomizations

Line 306: dbms_output.enable(1000000);

302: attName JDR_ATTRIBUTES.ATT_NAME%TYPE;
303: compsIsEmpty BOOLEAN;
304: attsIsEmpty BOOLEAN;
305: BEGIN
306: dbms_output.enable(1000000);
307: -- Loop through all customization documents in the repository
308: OPEN c_docs;
309: LOOP
310: FETCH c_docs INTO docID;

Line 362: dbms_output.put_line('Deleting ' ||

358: END LOOP;
359: END IF;
360: IF attsIsEmpty THEN
361: -- This is an empty customization document
362: dbms_output.put_line('Deleting ' ||
363: jdr_mds_internal.getDocumentName(docID));
364: jdr_mds_internal.dropDocument(docID);
365: END IF;
366: END LOOP;

Line 384: dbms_output.put_line('Error: Could not find package ' || p_package);

380: BEGIN
381: -- Get the ID of the document
382: docID := getDocumentID(p_package, 'PATH');
383: IF (docID = -1) THEN
384: dbms_output.put_line('Error: Could not find package ' || p_package);
385: RETURN;
386: END IF;
387:
388: -- Make sure that the package is empty

Line 394: dbms_output.put_line('Error: Unable to delete ' || p_package ||

390: FROM jdr_paths
391: WHERE path_owner_docid = docID;
392:
393: IF (contents <> 0) THEN
394: dbms_output.put_line('Error: Unable to delete ' || p_package ||
395: ' since it contains documents and/or packages.');
396: RETURN;
397: END IF;
398:

Line 400: dbms_output.put_line('Successfully deleted package ' || p_package || '.');

396: RETURN;
397: END IF;
398:
399: jdr_mds_internal.dropDocument(docID);
400: dbms_output.put_line('Successfully deleted package ' || p_package || '.');
401: END;
402:
403:
404: --

Line 562: dbms_output.enable(1000000);

558: pathSeq JDR_PATHS.PATH_SEQ%TYPE;
559: pathType JDR_PATHS.PATH_TYPE%TYPE;
560: docname VARCHAR2(1024);
561: BEGIN
562: dbms_output.enable(1000000);
563:
564: docID := getDocumentID(p_path, 'ANY');
565:
566: -- Nothing to do if the path does not exist

Line 568: dbms_output.put_line('Error: Could not find path ' || p_path);

564: docID := getDocumentID(p_path, 'ANY');
565:
566: -- Nothing to do if the path does not exist
567: IF (docID = -1) THEN
568: dbms_output.put_line('Error: Could not find path ' || p_path);
569: RETURN;
570: END IF;
571:
572: IF (p_recursive) THEN

Line 573: dbms_output.put_line('Printing contents of ' || p_path || ' recursively');

569: RETURN;
570: END IF;
571:
572: IF (p_recursive) THEN
573: dbms_output.put_line('Printing contents of ' || p_path || ' recursively');
574: OPEN c_alldocs(docID);
575: LOOP
576: FETCH c_alldocs INTO docname, pathType, pathSeq;
577: IF (c_alldocs%NOTFOUND) THEN

Line 590: -- or else dbms_output will fail

586: docname := docname || '/';
587: END IF;
588:
589: -- Print the document, but make sure it does not exceed 255 characters
590: -- or else dbms_output will fail
591: WHILE (length(docname) > 255) LOOP
592: dbms_output.put_line(substr(docname, 1, 255));
593: docname := substr(docname, 256);
594: END LOOP;

Line 592: dbms_output.put_line(substr(docname, 1, 255));

588:
589: -- Print the document, but make sure it does not exceed 255 characters
590: -- or else dbms_output will fail
591: WHILE (length(docname) > 255) LOOP
592: dbms_output.put_line(substr(docname, 1, 255));
593: docname := substr(docname, 256);
594: END LOOP;
595: dbms_output.put_line(docname);
596: END LOOP;

Line 595: dbms_output.put_line(docname);

591: WHILE (length(docname) > 255) LOOP
592: dbms_output.put_line(substr(docname, 1, 255));
593: docname := substr(docname, 256);
594: END LOOP;
595: dbms_output.put_line(docname);
596: END LOOP;
597: ELSE
598: dbms_output.put_line('Printing contents of ' || p_path);
599: OPEN c_docs(docID);

Line 598: dbms_output.put_line('Printing contents of ' || p_path);

594: END LOOP;
595: dbms_output.put_line(docname);
596: END LOOP;
597: ELSE
598: dbms_output.put_line('Printing contents of ' || p_path);
599: OPEN c_docs(docID);
600: LOOP
601: FETCH c_docs INTO docname, pathType, pathSeq;
602: IF (c_docs%NOTFOUND) THEN

Line 613: -- or else dbms_output will fail

609: docname := docname || '/';
610: END IF;
611:
612: -- Print the document, but make sure it does not exceed 255 characters
613: -- or else dbms_output will fail
614: WHILE (length(docname) > 255) LOOP
615: dbms_output.put_line(substr(docname, 1, 255));
616: docname := substr(docname, 256);
617: END LOOP;

Line 615: dbms_output.put_line(substr(docname, 1, 255));

611:
612: -- Print the document, but make sure it does not exceed 255 characters
613: -- or else dbms_output will fail
614: WHILE (length(docname) > 255) LOOP
615: dbms_output.put_line(substr(docname, 1, 255));
616: docname := substr(docname, 256);
617: END LOOP;
618: dbms_output.put_line(docname);
619: END LOOP;

Line 618: dbms_output.put_line(docname);

614: WHILE (length(docname) > 255) LOOP
615: dbms_output.put_line(substr(docname, 1, 255));
616: docname := substr(docname, 256);
617: END LOOP;
618: dbms_output.put_line(docname);
619: END LOOP;
620: END IF;
621: END;
622:

Line 661: dbms_output.put_line(name);

657: IF (c%NOTFOUND) THEN
658: CLOSE c;
659: EXIT;
660: END IF;
661: dbms_output.put_line(name);
662: END LOOP;
663: END;
664:
665:

Line 692: dbms_output.enable(1000000);

688:
689: lang jdr_attributes_trans.atl_lang%TYPE;
690: docID jdr_paths.path_docid%TYPE;
691: BEGIN
692: dbms_output.enable(1000000);
693:
694: docID := getDocumentID(p_document, 'FILE');
695:
696: -- Nothing to do if the path does not exist

Line 698: dbms_output.put_line('Error: Could not find document ' || p_document);

694: docID := getDocumentID(p_document, 'FILE');
695:
696: -- Nothing to do if the path does not exist
697: IF (docID = -1) THEN
698: dbms_output.put_line('Error: Could not find document ' || p_document);
699: RETURN;
700: END IF;
701:
702: dbms_output.put_line('Printing languages for document ' || p_document);

Line 702: dbms_output.put_line('Printing languages for document ' || p_document);

698: dbms_output.put_line('Error: Could not find document ' || p_document);
699: RETURN;
700: END IF;
701:
702: dbms_output.put_line('Printing languages for document ' || p_document);
703: OPEN c_languages(docID);
704: LOOP
705: FETCH c_languages INTO lang;
706: IF (c_languages%NOTFOUND) THEN

Line 711: dbms_output.put_line(lang);

707: CLOSE c_languages;
708: EXIT;
709: END IF;
710:
711: dbms_output.put_line(lang);
712: END LOOP;
713: END;
714:
715:

Line 723: dbms_output.enable(1000000);

719: IS
720: chunk VARCHAR2(32000);
721: maxLineSize NUMBER := p_maxLineSize;
722: BEGIN
723: dbms_output.enable(1000000);
724:
725: IF (p_maxLineSize > MAX_LINE_SIZE) THEN
726: maxLineSize := MAX_LINE_SIZE;
727: END IF;

Line 732: dbms_output.put_line('Error: Could not find document ' || p_document);

728:
729: chunk := jdr_mds_internal.exportDocumentAsXML(p_document);
730:
731: IF chunk IS NULL THEN
732: dbms_output.put_line('Error: Could not find document ' || p_document);
733: ELSE
734: printChunk(chunk, maxLineSize);
735: LOOP
736: chunk := jdr_mds_internal.exportDocumentAsXML(NULL);

Line 753: dbms_output.enable(1000000);

749: chunk VARCHAR2(32000);
750: maxLineSize NUMBER := p_maxLineSize;
751: exportFinished INTEGER;
752: BEGIN
753: dbms_output.enable(1000000);
754:
755: IF (p_maxLineSize > MAX_LINE_SIZE) THEN
756: maxLineSize := MAX_LINE_SIZE;
757: END IF;

Line 764: dbms_output.put_line('Error: Could not find document ' || p_document);

760: p_document,
761: p_language);
762:
763: IF chunk IS NULL THEN
764: dbms_output.put_line('Error: Could not find document ' || p_document);
765: ELSE
766: printChunk(chunk, maxLineSize);
767: WHILE (exportFinished = 0) LOOP
768: chunk := jdr_mds_internal.exportXLIFFDocument(exportFinished,