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.PO_COMM_FPDSNG_PVT dependencies on PO_DEBUG

Line 5: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

1: PACKAGE BODY PO_COMM_FPDSNG_PVT AS
2: /* $Header: POXFPDSNGB.pls 120.4 2008/03/06 07:26:30 lgoyal noship $ */
3:
4: --Use proper debug logging
5: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
6: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
7: g_log_head CONSTANT VARCHAR2(100) := 'po.plsql.PO_COMM_FPDSNG_PVT.';
8:
9: g_document_id NUMBER;

Line 6: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;

2: /* $Header: POXFPDSNGB.pls 120.4 2008/03/06 07:26:30 lgoyal noship $ */
3:
4: --Use proper debug logging
5: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
6: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
7: g_log_head CONSTANT VARCHAR2(100) := 'po.plsql.PO_COMM_FPDSNG_PVT.';
8:
9: g_document_id NUMBER;
10: g_revision_num NUMBER;

Line 51: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);

47: BEGIN
48:
49: l_progress := '001';
50: IF g_debug_stmt THEN
51: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
52: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
53: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', p_release_num);
54: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', p_revision_num);
55: END IF;

Line 52: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);

48:
49: l_progress := '001';
50: IF g_debug_stmt THEN
51: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
52: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
53: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', p_release_num);
54: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', p_revision_num);
55: END IF;
56:

Line 53: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', p_release_num);

49: l_progress := '001';
50: IF g_debug_stmt THEN
51: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
52: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
53: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', p_release_num);
54: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', p_revision_num);
55: END IF;
56:
57: l_progress := '002';

Line 54: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', p_revision_num);

50: IF g_debug_stmt THEN
51: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
52: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
53: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', p_release_num);
54: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', p_revision_num);
55: END IF;
56:
57: l_progress := '002';
58: -- Calling FPDSNGXMLGEN

Line 63: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'clob_result', DBMS_LOB.GETLENGTH(clob_result) );

59: clob_result := FPDSNGXMLGEN(p_document_id, p_release_num, p_revision_num);
60:
61: l_progress := '003';
62: IF g_debug_stmt THEN
63: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'clob_result', DBMS_LOB.GETLENGTH(clob_result) );
64: END IF;
65:
66: RETURN clob_result;
67: EXCEPTION

Line 70: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

66: RETURN clob_result;
67: EXCEPTION
68: WHEN OTHERS THEN
69: IF g_debug_unexp THEN
70: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
71: END IF;
72: RAISE;
73:
74: END start_process;

Line 170: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_document_id', l_document_id );

166: FROM po_releases_all pr
167: WHERE pr.po_release_id = l_document_id;
168:
169: IF g_debug_stmt THEN
170: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_document_id', l_document_id );
171: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_release_num', l_release_num );
172: END IF;
173:
174: END IF;

Line 171: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_release_num', l_release_num );

167: WHERE pr.po_release_id = l_document_id;
168:
169: IF g_debug_stmt THEN
170: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_document_id', l_document_id );
171: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_release_num', l_release_num );
172: END IF;
173:
174: END IF;
175:

Line 275: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);

271: BEGIN
272:
273: l_progress:='000';
274: IF g_debug_stmt THEN
275: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
276: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id );
277: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', p_release_num );
278: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', p_revision_num );
279: END IF;

Line 276: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id );

272:
273: l_progress:='000';
274: IF g_debug_stmt THEN
275: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
276: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id );
277: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', p_release_num );
278: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', p_revision_num );
279: END IF;
280:

Line 277: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', p_release_num );

273: l_progress:='000';
274: IF g_debug_stmt THEN
275: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
276: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id );
277: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', p_release_num );
278: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', p_revision_num );
279: END IF;
280:
281: PO_COMM_FPDSNG_PVT.g_document_id := p_document_id;

Line 278: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', p_revision_num );

274: IF g_debug_stmt THEN
275: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
276: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id );
277: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', p_release_num );
278: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', p_revision_num );
279: END IF;
280:
281: PO_COMM_FPDSNG_PVT.g_document_id := p_document_id;
282:

Line 328: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id::', PO_COMM_FPDSNG_PVT.getDocumentId() );

324: END IF;
325:
326: l_progress:='006';
327: IF g_debug_stmt THEN
328: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id::', PO_COMM_FPDSNG_PVT.getDocumentId() );
329: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', PO_COMM_FPDSNG_PVT.g_revision_num );
330: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', PO_COMM_FPDSNG_PVT.getReleaseId() );
331: END IF;
332:

Line 329: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', PO_COMM_FPDSNG_PVT.g_revision_num );

325:
326: l_progress:='006';
327: IF g_debug_stmt THEN
328: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id::', PO_COMM_FPDSNG_PVT.getDocumentId() );
329: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', PO_COMM_FPDSNG_PVT.g_revision_num );
330: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', PO_COMM_FPDSNG_PVT.getReleaseId() );
331: END IF;
332:
333: l_progress:='007';

Line 330: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', PO_COMM_FPDSNG_PVT.getReleaseId() );

326: l_progress:='006';
327: IF g_debug_stmt THEN
328: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id::', PO_COMM_FPDSNG_PVT.getDocumentId() );
329: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_release_num', PO_COMM_FPDSNG_PVT.g_revision_num );
330: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_num', PO_COMM_FPDSNG_PVT.getReleaseId() );
331: END IF;
332:
333: l_progress:='007';
334: l_idvidQuery:=' SELECT decode(PO_COMM_FPDSNG_PVT.getReleaseId(), null,

Line 452: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'XML Queries Created after', l_progress);

448: AND poh.po_header_id=PO_COMM_FPDSNG_PVT.getDocumentId()';
449:
450:
451: IF g_debug_stmt THEN
452: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'XML Queries Created after', l_progress);
453: END IF;
454:
455: /*IDVID */
456: l_progress:='018';

Line 538: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'XML Data Generated after', l_progress);

534: l_vendorLocation := dbms_xmlgen.getXML(context,DBMS_XMLGEN.NONE);
535: dbms_xmlgen.closeContext(context);
536:
537: IF g_debug_stmt THEN
538: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'XML Data Generated after', l_progress);
539: END IF;
540:
541: -- Length of IDVD
542: l_progress:='027';

Line 616: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'XML CLOB Created after', l_progress);

612:
613: END IF; -- Length of IDVD which is going to be for sure
614:
615: IF g_debug_stmt THEN
616: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'XML CLOB Created after', l_progress);
617: END IF;
618:
619:
620: l_xml_result := Replace_Clob_String(l_xml_result,'DESCOFCONTRACTREQUIREMENT','DESCRIPTIONOFCONTRACTREQUIREMENT');

Line 647: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_file_name', l_file_name);

643: p_release_num, --Release Num
644: l_language); --Language Code
645:
646: IF g_debug_stmt THEN
647: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_file_name', l_file_name);
648: END IF;
649:
650: -- Converting CLOB data to BLOB to store in DB
651: l_progress:='045';

Line 664: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'CLOB DataStored. After', l_progress);

660: blob_result, --blob
661: l_media_id);
662:
663: IF g_debug_stmt THEN
664: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'CLOB DataStored. After', l_progress);
665: END IF;
666:
667: --Getting back the CLOB from BLOB
668: l_progress:='047';

Line 676: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

672:
673: EXCEPTION
674: WHEN OTHERS THEN
675: IF g_debug_unexp THEN
676: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
677: END IF;
678: RAISE;
679: END; -- END FPDSNGXMLGEN
680:

Line 704: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);

700:
701: l_progress := '000';
702:
703: IF g_debug_stmt THEN
704: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
705: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
706: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
707: END IF;
708:

Line 705: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);

701: l_progress := '000';
702:
703: IF g_debug_stmt THEN
704: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
705: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
706: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
707: END IF;
708:
709: BEGIN

Line 706: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);

702:
703: IF g_debug_stmt THEN
704: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
705: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
706: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
707: END IF;
708:
709: BEGIN
710: l_progress := '001';

Line 718: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_po_number', l_po_number);

714: FROM po_headers_all ph
715: WHERE po_header_id = p_document_id;
716:
717: IF g_debug_stmt THEN
718: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_po_number', l_po_number);
719: END IF;
720: EXCEPTION
721: WHEN NO_DATA_FOUND THEN
722: raise_application_error (-20001,'Document Number Cannot be NULL or Invalid.');

Line 742: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_doc_type', l_doc_type);

738: l_doc_type := 'REL_' || l_release_num ;
739: END IF;
740:
741: IF g_debug_stmt THEN
742: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_doc_type', l_doc_type);
743: END IF;
744:
745: --If The Po Number Is Null Assign The Document Id To PO Number.
746: l_progress := '006';

Line 758: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_file_name', l_file_name);

754: /* Creating the Filename here */
755: l_file_name := l_doc_type||'_FPDSNG_'||p_orgid||'_'||l_po_number||'_'||p_revision_num||'_'||p_language_code||l_extension;
756:
757: IF g_debug_stmt THEN
758: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_file_name', l_file_name);
759: PO_DEBUG.debug_end(g_log_head || l_api_name);
760: END IF;
761:
762: RETURN l_file_name;

Line 759: PO_DEBUG.debug_end(g_log_head || l_api_name);

755: l_file_name := l_doc_type||'_FPDSNG_'||p_orgid||'_'||l_po_number||'_'||p_revision_num||'_'||p_language_code||l_extension;
756:
757: IF g_debug_stmt THEN
758: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_file_name', l_file_name);
759: PO_DEBUG.debug_end(g_log_head || l_api_name);
760: END IF;
761:
762: RETURN l_file_name;
763: EXCEPTION

Line 766: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

762: RETURN l_file_name;
763: EXCEPTION
764: WHEN OTHERS THEN
765: IF g_debug_unexp THEN
766: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
767: END IF;
768: RAISE;
769:
770: END getFPDSNGFileName;

Line 797: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

793: Begin
794:
795: l_progress := '000';
796: IF g_debug_stmt THEN
797: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
798: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
799: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_number', p_revision_number);
800: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
801: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_file_name', p_file_name);

Line 798: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);

794:
795: l_progress := '000';
796: IF g_debug_stmt THEN
797: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
798: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
799: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_number', p_revision_number);
800: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
801: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_file_name', p_file_name);
802: END IF;

Line 799: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_number', p_revision_number);

795: l_progress := '000';
796: IF g_debug_stmt THEN
797: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
798: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
799: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_number', p_revision_number);
800: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
801: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_file_name', p_file_name);
802: END IF;
803:

Line 800: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);

796: IF g_debug_stmt THEN
797: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
798: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
799: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_number', p_revision_number);
800: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
801: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_file_name', p_file_name);
802: END IF;
803:
804: l_file_content_type := 'text/xml';

Line 801: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_file_name', p_file_name);

797: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);
798: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
799: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_number', p_revision_number);
800: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
801: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_file_name', p_file_name);
802: END IF;
803:
804: l_file_content_type := 'text/xml';
805:

Line 827: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_media_id', p_media_id);

823: END;
824:
825: l_progress := '003';
826: IF g_debug_stmt THEN
827: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_media_id', p_media_id);
828: END IF;
829:
830: IF p_media_id IS NULL THEN
831:

Line 839: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_category_id', l_category_id);

835: from fnd_document_categories
836: where name = 'CUSTOM2446' ;
837:
838: IF g_debug_stmt THEN
839: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'l_category_id', l_category_id);
840: END IF;
841:
842: l_progress := '005';
843: FND_DOCUMENTS_PKG.Insert_Row(

Line 955: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'Data Inserted in Tables. After', l_progress);

951: null, null, null, null, null,
952: null, null, null);
953:
954: IF g_debug_stmt THEN
955: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'Data Inserted in Tables. After', l_progress);
956: END IF;
957:
958: ELSE
959: l_progress := '006';

Line 965: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'Data Updated in Table. After', l_progress);

961: UPDATE fnd_lobs SET file_data = p_result, upload_date = sysdate
962: WHERE file_id = p_media_id;
963:
964: IF g_debug_stmt THEN
965: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'Data Updated in Table. After', l_progress);
966: END IF;
967:
968: END IF;
969:

Line 973: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

969:
970: EXCEPTION
971: WHEN OTHERS THEN
972: IF g_debug_unexp THEN
973: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
974: END IF;
975: RAISE;
976: END Store_Blob;
977:

Line 1015: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1011: RETURN l_TempBLOB; -- l_TempBLOB is OPEN here
1012: EXCEPTION
1013: WHEN OTHERS THEN
1014: IF g_debug_unexp THEN
1015: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1016: END IF;
1017: RAISE;
1018: END clob_to_blob;
1019:

Line 1055: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1051: RETURN l_CLOBData;
1052: EXCEPTION
1053: WHEN OTHERS THEN
1054: IF g_debug_unexp THEN
1055: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1056: END IF;
1057: RAISE;
1058: END blob_to_clob;
1059:

Line 1104: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1100: RETURN l_new_Clob;
1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: IF g_debug_unexp THEN
1104: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1105: END IF;
1106: RAISE;
1107: END;
1108:

Line 1126: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);

1122: BEGIN
1123: l_progress := '000';
1124:
1125: IF g_debug_stmt THEN
1126: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
1127: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
1128: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_number', p_revision_number);
1129: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
1130: END IF;

Line 1127: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);

1123: l_progress := '000';
1124:
1125: IF g_debug_stmt THEN
1126: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
1127: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
1128: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_number', p_revision_number);
1129: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
1130: END IF;
1131:

Line 1128: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_number', p_revision_number);

1124:
1125: IF g_debug_stmt THEN
1126: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
1127: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
1128: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_number', p_revision_number);
1129: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
1130: END IF;
1131:
1132: IF p_document_type = ('STANDARD') THEN

Line 1129: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);

1125: IF g_debug_stmt THEN
1126: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
1127: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_id', p_document_id);
1128: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_revision_number', p_revision_number);
1129: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_document_type', p_document_type);
1130: END IF;
1131:
1132: IF p_document_type = ('STANDARD') THEN
1133:

Line 1176: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_request_id', p_request_id);

1172: NULL, NULL);
1173:
1174:
1175: IF g_debug_stmt THEN
1176: PO_DEBUG.debug_var(g_log_head || l_api_name, l_progress, 'p_request_id', p_request_id);
1177: END IF;
1178:
1179: EXCEPTION
1180: WHEN OTHERS THEN

Line 1182: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);

1178:
1179: EXCEPTION
1180: WHEN OTHERS THEN
1181: IF g_debug_unexp THEN
1182: PO_DEBUG.debug_exc(p_log_head => g_log_head||l_api_name, p_progress => l_progress);
1183: END IF;
1184: RAISE;
1185: END Communicate;
1186: