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.OKC_WORD_DOWNLOAD_UPLOAD dependencies on FND_LOG

Line 9: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

5: ------------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_WORD_DOWNLOAD_UPLOAD';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
8:
9: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
10: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||G_PKG_NAME||'.';
11: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
12:
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

Line 102: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

98: l_progress VARCHAR2(3) := '000';
99:
100: BEGIN
101:
102: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
103: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
104: G_MODULE||l_api_name,
105: '100: Entered '||G_PKG_NAME ||'.'||'DOWNLOAD_PRE_PROCESSOR');
106: END IF;

Line 103: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

99:
100: BEGIN
101:
102: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
103: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
104: G_MODULE||l_api_name,
105: '100: Entered '||G_PKG_NAME ||'.'||'DOWNLOAD_PRE_PROCESSOR');
106: END IF;
107:

Line 164: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

160: AND doc_id = p_doc_id
161: AND doc_type = p_doc_type;
162:
163:
164: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
165: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
166: G_MODULE||l_api_name,
167: '100: Leaving '||G_PKG_NAME ||'.'||'DOWNLOAD_PRE_PROCESSOR');
168: END IF;

Line 165: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

161: AND doc_type = p_doc_type;
162:
163:
164: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
165: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
166: G_MODULE||l_api_name,
167: '100: Leaving '||G_PKG_NAME ||'.'||'DOWNLOAD_PRE_PROCESSOR');
168: END IF;
169: x_return_status := G_RET_STS_SUCCESS;

Line 174: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

170: x_msg_data := NULL;
171: EXCEPTION WHEN OTHERS THEN
172: x_return_status := G_RET_STS_ERROR;
173: x_msg_data := SQLCODE||' -ERROR- '||SQLERRM ;
174: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
175: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
176: G_MODULE||l_api_name,
177: '100: Exception in '||G_PKG_NAME ||'.'||'DOWNLOAD_PRE_PROCESSOR');
178:

Line 175: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

171: EXCEPTION WHEN OTHERS THEN
172: x_return_status := G_RET_STS_ERROR;
173: x_msg_data := SQLCODE||' -ERROR- '||SQLERRM ;
174: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
175: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
176: G_MODULE||l_api_name,
177: '100: Exception in '||G_PKG_NAME ||'.'||'DOWNLOAD_PRE_PROCESSOR');
178:
179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

Line 179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

175: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
176: G_MODULE||l_api_name,
177: '100: Exception in '||G_PKG_NAME ||'.'||'DOWNLOAD_PRE_PROCESSOR');
178:
179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
180: G_MODULE||l_api_name,
181: '100: Exception - at ' || l_progress );
182:
183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

Line 183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

179: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
180: G_MODULE||l_api_name,
181: '100: Exception - at ' || l_progress );
182:
183: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
184: G_MODULE||l_api_name,
185: '100: Exception ' || SQLERRM );
186: END IF;
187: END DOWNLOAD_PRE_PROCESSOR;

Line 247: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

243: BEGIN
244:
245: l_progress := '010';
246:
247: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
248: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
249: G_MODULE||l_api_name,
250: '100: Entered '||G_PKG_NAME ||'.'||'DOWNLOAD_POST_PROCESSOR');
251: END IF;

Line 248: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

244:
245: l_progress := '010';
246:
247: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
248: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
249: G_MODULE||l_api_name,
250: '100: Entered '||G_PKG_NAME ||'.'||'DOWNLOAD_POST_PROCESSOR');
251: END IF;
252:

Line 447: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

443: and doc_id = p_doc_id
444: AND doc_type = p_doc_type;
445:
446:
447: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
449: G_MODULE||l_api_name,
450: '100: Leaving '||G_PKG_NAME ||'.'||'DOWNLOAD_POST_PROCESSOR');
451: END IF;

Line 448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

444: AND doc_type = p_doc_type;
445:
446:
447: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
449: G_MODULE||l_api_name,
450: '100: Leaving '||G_PKG_NAME ||'.'||'DOWNLOAD_POST_PROCESSOR');
451: END IF;
452: x_return_status := G_RET_STS_SUCCESS;

Line 459: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

455: EXCEPTION WHEN OTHERS THEN
456:
457: x_return_status := G_RET_STS_ERROR;
458: x_msg_data := SQLCODE||' -ERROR- '||SQLERRM ;
459: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
460: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
461: G_MODULE||l_api_name,
462: '100: Exception in '||G_PKG_NAME ||'.'||'DOWNLOAD_POST_PROCESSOR');
463:

Line 460: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

456:
457: x_return_status := G_RET_STS_ERROR;
458: x_msg_data := SQLCODE||' -ERROR- '||SQLERRM ;
459: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
460: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
461: G_MODULE||l_api_name,
462: '100: Exception in '||G_PKG_NAME ||'.'||'DOWNLOAD_POST_PROCESSOR');
463:
464: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

Line 464: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

460: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
461: G_MODULE||l_api_name,
462: '100: Exception in '||G_PKG_NAME ||'.'||'DOWNLOAD_POST_PROCESSOR');
463:
464: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
465: G_MODULE||l_api_name,
466: ' Exception - at' || l_progress);
467:
468: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

Line 468: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

464: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
465: G_MODULE||l_api_name,
466: ' Exception - at' || l_progress);
467:
468: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
469: G_MODULE||l_api_name,
470: ' Exception - ' || SQLERRM);
471: END IF;
472: END DOWNLOAD_POST_PROCESSOR;

Line 486: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

482: l_xpath VARCHAR2(1000);
483:
484: BEGIN
485:
486: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
487: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
488: G_MODULE||l_api_name,
489: '100: Entered '||G_PKG_NAME ||'.'||'get_article_body');
490: END IF;

Line 487: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

483:
484: BEGIN
485:
486: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
487: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
488: G_MODULE||l_api_name,
489: '100: Entered '||G_PKG_NAME ||'.'||'get_article_body');
490: END IF;
491:

Line 505: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

501: v_clob := regexp_replace(regexp_replace(regexp_replace(v_clob,'w:body','wbody'),'w:list','wlist'),'w:lvlPicBulletId','wlvlPicBulletId');
502: v_clob := ''||xmltype(v_clob).extract('//wbody|//wlists').getClobVal()||'';
503: select deleteXML(XMLType(v_clob),'//wlvlPicBulletId').getClobVal() into v_clob from dual;
504:
505: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
507: G_MODULE||l_api_name,
508: '100: Leaving '||G_PKG_NAME ||'.'||'get_article_body');
509: END IF;

Line 506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

502: v_clob := ''||xmltype(v_clob).extract('//wbody|//wlists').getClobVal()||'';
503: select deleteXML(XMLType(v_clob),'//wlvlPicBulletId').getClobVal() into v_clob from dual;
504:
505: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
507: G_MODULE||l_api_name,
508: '100: Leaving '||G_PKG_NAME ||'.'||'get_article_body');
509: END IF;
510:

Line 514: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

510:
511: RETURN v_clob;
512:
513: EXCEPTION WHEN OTHERS THEN
514: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
515: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
516: G_MODULE||l_api_name,
517: '100: Exception in '||G_PKG_NAME ||'.'||'get_article_body');
518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

Line 515: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

511: RETURN v_clob;
512:
513: EXCEPTION WHEN OTHERS THEN
514: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
515: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
516: G_MODULE||l_api_name,
517: '100: Exception in '||G_PKG_NAME ||'.'||'get_article_body');
518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
519: G_MODULE||l_api_name,

Line 518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

514: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
515: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
516: G_MODULE||l_api_name,
517: '100: Exception in '||G_PKG_NAME ||'.'||'get_article_body');
518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
519: G_MODULE||l_api_name,
520: '100: Exception - ' || SQLERRM);
521: END IF;
522:

Line 574: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

570: l_progress VARCHAR2(3) := '000';
571:
572: BEGIN
573:
574: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
576: G_MODULE||l_api_name,
577: '100: Entered '||G_PKG_NAME ||'.'||'UPLOAD_PRE_PROCESSOR');
578: END IF;

Line 575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

571:
572: BEGIN
573:
574: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
576: G_MODULE||l_api_name,
577: '100: Entered '||G_PKG_NAME ||'.'||'UPLOAD_PRE_PROCESSOR');
578: END IF;
579:

Line 681: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

677:
678: -- Insert the document into okc_word_sync_t
679: l_progress := '130';
680: insert into okc_word_sync_t(id,doc_id,doc_type,blob_data) values(2,p_doc_id,p_doc_type,okc_word_download_upload.clob_to_blob(l_doc_clob));
681: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
682: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
683: G_MODULE||l_api_name,
684: '100: Leaving '||G_PKG_NAME ||'.'||'UPLOAD_PRE_PROCESSOR');
685: END IF;

Line 682: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

678: -- Insert the document into okc_word_sync_t
679: l_progress := '130';
680: insert into okc_word_sync_t(id,doc_id,doc_type,blob_data) values(2,p_doc_id,p_doc_type,okc_word_download_upload.clob_to_blob(l_doc_clob));
681: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
682: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
683: G_MODULE||l_api_name,
684: '100: Leaving '||G_PKG_NAME ||'.'||'UPLOAD_PRE_PROCESSOR');
685: END IF;
686:

Line 695: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

691:
692: x_return_status := G_RET_STS_ERROR;
693: x_msg_data := SQLCODE||' -ERROR- '||SQLERRM ;
694:
695: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
696: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
697: G_MODULE||l_api_name,
698: '100: Exception in '||G_PKG_NAME ||'.'||'UPLOAD_PRE_PROCESSOR');
699:

Line 696: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

692: x_return_status := G_RET_STS_ERROR;
693: x_msg_data := SQLCODE||' -ERROR- '||SQLERRM ;
694:
695: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
696: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
697: G_MODULE||l_api_name,
698: '100: Exception in '||G_PKG_NAME ||'.'||'UPLOAD_PRE_PROCESSOR');
699:
700: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

Line 700: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

696: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
697: G_MODULE||l_api_name,
698: '100: Exception in '||G_PKG_NAME ||'.'||'UPLOAD_PRE_PROCESSOR');
699:
700: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
701: G_MODULE||l_api_name,
702: '100: Exception at - '||l_progress);
703: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
704: G_MODULE||l_api_name,

Line 703: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

699:
700: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
701: G_MODULE||l_api_name,
702: '100: Exception at - '||l_progress);
703: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
704: G_MODULE||l_api_name,
705: '100: Exception '|| SQLERRM);
706:
707: END IF;

Line 741: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

737:
738:
739: BEGIN
740:
741: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
743: G_MODULE||l_api_name,
744: '100: Entered '||G_PKG_NAME ||'.'||'UPLOAD_POST_PROCESSOR');
745: END IF;

Line 742: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

738:
739: BEGIN
740:
741: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
742: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
743: G_MODULE||l_api_name,
744: '100: Entered '||G_PKG_NAME ||'.'||'UPLOAD_POST_PROCESSOR');
745: END IF;
746:

Line 799: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

795:
796: l_art_CLOB := regexp_replace(regexp_replace(l_art_CLOB,'wbody','w:body'),'',' ');
797:
798:
799: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
800: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
801: G_MODULE||l_api_name,
802: '100: Leaving '||G_PKG_NAME ||'.'||'UPLOAD_POST_PROCESSOR');
803: END IF;

Line 800: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

796: l_art_CLOB := regexp_replace(regexp_replace(l_art_CLOB,'wbody','w:body'),'',' ');
797:
798:
799: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
800: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
801: G_MODULE||l_api_name,
802: '100: Leaving '||G_PKG_NAME ||'.'||'UPLOAD_POST_PROCESSOR');
803: END IF;
804:

Line 811: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

807: END;
808:
809: EXCEPTION WHEN OTHERS THEN
810:
811: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
812: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
813: G_MODULE||l_api_name,
814: '100: Exception in '||G_PKG_NAME ||'.'||'UPLOAD_POST_PROCESSOR');
815: END IF;

Line 812: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

808:
809: EXCEPTION WHEN OTHERS THEN
810:
811: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
812: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
813: G_MODULE||l_api_name,
814: '100: Exception in '||G_PKG_NAME ||'.'||'UPLOAD_POST_PROCESSOR');
815: END IF;
816:

Line 839: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

835: l_xpath VARCHAR2(1000);
836:
837: BEGIN
838:
839: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
840: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
841: G_MODULE||l_api_name,
842: '100: Entered '||G_PKG_NAME ||'.'||'BLOB_TO_CLOB');
843: END IF;

Line 840: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

836:
837: BEGIN
838:
839: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
840: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
841: G_MODULE||l_api_name,
842: '100: Entered '||G_PKG_NAME ||'.'||'BLOB_TO_CLOB');
843: END IF;
844:

Line 853: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

849: DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar);
850: v_start := v_start + v_buffer;
851: END LOOP;
852:
853: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
854: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
855: G_MODULE||l_api_name,
856: '100: Leaving '||G_PKG_NAME ||'.'||'BLOB_TO_CLOB');
857: END IF;

Line 854: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

850: v_start := v_start + v_buffer;
851: END LOOP;
852:
853: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
854: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
855: G_MODULE||l_api_name,
856: '100: Leaving '||G_PKG_NAME ||'.'||'BLOB_TO_CLOB');
857: END IF;
858:

Line 862: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

858:
859:
860: RETURN v_clob;
861: EXCEPTION WHEN OTHERS THEN
862: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
864: G_MODULE||l_api_name,
865: '100: Exception in '||G_PKG_NAME ||'.'||'BLOB_TO_CLOB');
866: END IF;

Line 863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

859:
860: RETURN v_clob;
861: EXCEPTION WHEN OTHERS THEN
862: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
864: G_MODULE||l_api_name,
865: '100: Exception in '||G_PKG_NAME ||'.'||'BLOB_TO_CLOB');
866: END IF;
867: END BLOB_TO_CLOB;

Line 882: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

878: v_lang Pls_Integer := 0;
879: v_warning Pls_Integer := 0;
880: BEGIN
881:
882: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
883: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
884: G_MODULE||l_api_name,
885: '100: Entered '||G_PKG_NAME ||'.'||'Clob_to_blob');
886: END IF;

Line 883: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

879: v_warning Pls_Integer := 0;
880: BEGIN
881:
882: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
883: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
884: G_MODULE||l_api_name,
885: '100: Entered '||G_PKG_NAME ||'.'||'Clob_to_blob');
886: END IF;
887:

Line 893: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

889:
890: DBMS_LOB.convertToBlob(l_art_blob,p_clob,DBMS_lob.getlength(p_clob),
891: v_in,v_out,DBMS_LOB.default_csid,v_lang,v_warning);
892:
893: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
894: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
895: G_MODULE||l_api_name,
896: '100: Leaving '||G_PKG_NAME ||'.'||'Clob_to_blob');
897: END IF;

Line 894: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

890: DBMS_LOB.convertToBlob(l_art_blob,p_clob,DBMS_lob.getlength(p_clob),
891: v_in,v_out,DBMS_LOB.default_csid,v_lang,v_warning);
892:
893: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
894: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
895: G_MODULE||l_api_name,
896: '100: Leaving '||G_PKG_NAME ||'.'||'Clob_to_blob');
897: END IF;
898:

Line 901: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

897: END IF;
898:
899: return l_art_blob;
900: EXCEPTION WHEN OTHERS THEN
901: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
903: G_MODULE||l_api_name,
904: '100: Exception in '||G_PKG_NAME ||'.'||'Clob_to_blob');
905: END IF;

Line 902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

898:
899: return l_art_blob;
900: EXCEPTION WHEN OTHERS THEN
901: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
903: G_MODULE||l_api_name,
904: '100: Exception in '||G_PKG_NAME ||'.'||'Clob_to_blob');
905: END IF;
906:

Line 913: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

909:
910: FUNCTION GET_WORD_SYNC_PROFILE RETURN VARCHAR2 IS
911: PROF_VALUE VARCHAR2(1);
912: BEGIN
913: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
914: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
915: G_MODULE||'GET_WORD_SYNC_PROFILE',
916: '100: Entered '||G_PKG_NAME ||'.'||'GET_WORD_SYNC_PROFILE');
917: END IF;

Line 914: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

910: FUNCTION GET_WORD_SYNC_PROFILE RETURN VARCHAR2 IS
911: PROF_VALUE VARCHAR2(1);
912: BEGIN
913: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
914: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
915: G_MODULE||'GET_WORD_SYNC_PROFILE',
916: '100: Entered '||G_PKG_NAME ||'.'||'GET_WORD_SYNC_PROFILE');
917: END IF;
918: SELECT FND_PROFILE.VALUE('OKC_WORD_SYNC_ART_EDIT') INTO PROF_VALUE FROM DUAL;

Line 919: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

915: G_MODULE||'GET_WORD_SYNC_PROFILE',
916: '100: Entered '||G_PKG_NAME ||'.'||'GET_WORD_SYNC_PROFILE');
917: END IF;
918: SELECT FND_PROFILE.VALUE('OKC_WORD_SYNC_ART_EDIT') INTO PROF_VALUE FROM DUAL;
919: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
920: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
921: G_MODULE||'GET_WORD_SYNC_PROFILE',
922: '100: Leaving '||G_PKG_NAME ||'.'||'GET_WORD_SYNC_PROFILE');
923: END IF;

Line 920: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

916: '100: Entered '||G_PKG_NAME ||'.'||'GET_WORD_SYNC_PROFILE');
917: END IF;
918: SELECT FND_PROFILE.VALUE('OKC_WORD_SYNC_ART_EDIT') INTO PROF_VALUE FROM DUAL;
919: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
920: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
921: G_MODULE||'GET_WORD_SYNC_PROFILE',
922: '100: Leaving '||G_PKG_NAME ||'.'||'GET_WORD_SYNC_PROFILE');
923: END IF;
924: RETURN PROF_VALUE;

Line 931: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

927:
928:
929: PROCEDURE INSERT_WML_TEXT(p_article_version_id NUMBER, p_article_text_in_word BLOB) IS
930: BEGIN
931: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
932: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
933: G_MODULE||'INSERT_WML_TEXT',
934: '100: Entered '||G_PKG_NAME ||'.'||'INSERT_WML_TEXT');
935: END IF;

Line 932: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

928:
929: PROCEDURE INSERT_WML_TEXT(p_article_version_id NUMBER, p_article_text_in_word BLOB) IS
930: BEGIN
931: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
932: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
933: G_MODULE||'INSERT_WML_TEXT',
934: '100: Entered '||G_PKG_NAME ||'.'||'INSERT_WML_TEXT');
935: END IF;
936: UPDATE okc_article_versions

Line 940: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

936: UPDATE okc_article_versions
937: SET article_text_in_word = p_article_text_in_word,
938: edited_in_word = 'Y'
939: WHERE article_version_id = p_article_version_id;
940: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
941: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
942: G_MODULE||'INSERT_WML_TEXT',
943: '100: Leaving '||G_PKG_NAME ||'.'||'INSERT_WML_TEXT');
944: END IF;

Line 941: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

937: SET article_text_in_word = p_article_text_in_word,
938: edited_in_word = 'Y'
939: WHERE article_version_id = p_article_version_id;
940: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
941: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
942: G_MODULE||'INSERT_WML_TEXT',
943: '100: Leaving '||G_PKG_NAME ||'.'||'INSERT_WML_TEXT');
944: END IF;
945: END INSERT_WML_TEXT;

Line 1267: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1263:
1264: x_return_status := G_RET_STS_ERROR;
1265: x_msg_data := SQLCODE||' -ERROR- '||SQLERRM ;
1266:
1267: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
1269: G_MODULE||'GET_LATEST_WML',
1270: '100: Exception '||G_PKG_NAME ||'.'||'GET_LATEST_WML');
1271: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

Line 1268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

1264: x_return_status := G_RET_STS_ERROR;
1265: x_msg_data := SQLCODE||' -ERROR- '||SQLERRM ;
1266:
1267: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
1269: G_MODULE||'GET_LATEST_WML',
1270: '100: Exception '||G_PKG_NAME ||'.'||'GET_LATEST_WML');
1271: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
1272: G_MODULE||'GET_LATEST_WML',

Line 1271: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,

1267: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
1269: G_MODULE||'GET_LATEST_WML',
1270: '100: Exception '||G_PKG_NAME ||'.'||'GET_LATEST_WML');
1271: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
1272: G_MODULE||'GET_LATEST_WML',
1273: '100: Exception - '|| SQLERRM );
1274: END IF;
1275: RAISE;