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

Line 742: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

738:
739: -- Write the statement description to clob
740: --Commented to fix 11739796
741: /* src_blob := rec8.file_data;
742: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
743: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
744: 'Before dbms_lob.converttoclob- src_blob : || src_blob');
745: END IF;
746: dbms_lob.converttoclob(l_clob ,src_blob, amount, dest_offset, src_offset, blob_csid,lang_context, warning);

Line 743: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',

739: -- Write the statement description to clob
740: --Commented to fix 11739796
741: /* src_blob := rec8.file_data;
742: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
743: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
744: 'Before dbms_lob.converttoclob- src_blob : || src_blob');
745: END IF;
746: dbms_lob.converttoclob(l_clob ,src_blob, amount, dest_offset, src_offset, blob_csid,lang_context, warning);
747: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 747: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

743: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
744: 'Before dbms_lob.converttoclob- src_blob : || src_blob');
745: END IF;
746: dbms_lob.converttoclob(l_clob ,src_blob, amount, dest_offset, src_offset, blob_csid,lang_context, warning);
747: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
748: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
749: 'After dbms_lob.converttoclob- l_clob : || l_clob' );
750: END IF;
751:

Line 748: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',

744: 'Before dbms_lob.converttoclob- src_blob : || src_blob');
745: END IF;
746: dbms_lob.converttoclob(l_clob ,src_blob, amount, dest_offset, src_offset, blob_csid,lang_context, warning);
747: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
748: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
749: 'After dbms_lob.converttoclob- l_clob : || l_clob' );
750: END IF;
751:
752: IF (l_clob IS NOT NULL AND dbms_lob.getlength(l_clob) > 0)

Line 916: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

912: Write_Soln_Header_Cont_Hlp( p_solution_id, p_lang, p_clob, l_temp_clob );
913: Write_Soln_Statement_Cont_Hlp( p_solution_id, p_lang, p_clob, l_temp_clob );
914: Write_Soln_Product_Cont_Hlp( p_solution_id, p_lang, p_clob, l_temp_clob );
915: Write_Soln_Platform_Cont_Hlp( p_solution_id, p_lang, p_clob, l_temp_clob );
916: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
917: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
918: 'Before Write_Soln_Attach_Cont_Hlp- ');
919: END IF;
920: Write_Soln_Attach_Cont_Hlp( p_solution_id, p_lang, p_clob, l_temp_clob );

Line 917: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',

913: Write_Soln_Statement_Cont_Hlp( p_solution_id, p_lang, p_clob, l_temp_clob );
914: Write_Soln_Product_Cont_Hlp( p_solution_id, p_lang, p_clob, l_temp_clob );
915: Write_Soln_Platform_Cont_Hlp( p_solution_id, p_lang, p_clob, l_temp_clob );
916: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
917: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
918: 'Before Write_Soln_Attach_Cont_Hlp- ');
919: END IF;
920: Write_Soln_Attach_Cont_Hlp( p_solution_id, p_lang, p_clob, l_temp_clob );
921: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 921: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

917: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
918: 'Before Write_Soln_Attach_Cont_Hlp- ');
919: END IF;
920: Write_Soln_Attach_Cont_Hlp( p_solution_id, p_lang, p_clob, l_temp_clob );
921: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
922: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
923: 'After Write_Soln_Attach_Cont_Hlp- ');
924: END IF;
925: -- Write out metadata sections

Line 922: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',

918: 'Before Write_Soln_Attach_Cont_Hlp- ');
919: END IF;
920: Write_Soln_Attach_Cont_Hlp( p_solution_id, p_lang, p_clob, l_temp_clob );
921: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
922: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
923: 'After Write_Soln_Attach_Cont_Hlp- ');
924: END IF;
925: -- Write out metadata sections
926: Write_Soln_Header_Sect_Hlp( p_solution_id, p_lang, p_clob );

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

927: Write_Soln_Statement_Sect_Hlp( p_solution_id, p_clob );
928: Write_Soln_Category_Sect_Hlp( p_solution_id, p_clob );
929: Write_Soln_Product_Sect_Hlp( p_solution_id, p_clob );
930: Write_Soln_Platform_Sect_Hlp( p_solution_id, p_clob );
931: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
932: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
933: 'Before Write_Soln_Attach_Sect_Hlp- ');
934: END IF;
935: Write_Soln_Attach_Sect_Hlp( p_solution_id, p_clob );

Line 932: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',

928: Write_Soln_Category_Sect_Hlp( p_solution_id, p_clob );
929: Write_Soln_Product_Sect_Hlp( p_solution_id, p_clob );
930: Write_Soln_Platform_Sect_Hlp( p_solution_id, p_clob );
931: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
932: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
933: 'Before Write_Soln_Attach_Sect_Hlp- ');
934: END IF;
935: Write_Soln_Attach_Sect_Hlp( p_solution_id, p_clob );
936: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 936: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

932: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
933: 'Before Write_Soln_Attach_Sect_Hlp- ');
934: END IF;
935: Write_Soln_Attach_Sect_Hlp( p_solution_id, p_clob );
936: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
937: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
938: 'After Write_Soln_Attach_Sect_Hlp- ');
939: END IF;
940: -- explicitly free the clob

Line 937: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',

933: 'Before Write_Soln_Attach_Sect_Hlp- ');
934: END IF;
935: Write_Soln_Attach_Sect_Hlp( p_solution_id, p_clob );
936: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
937: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
938: 'After Write_Soln_Attach_Sect_Hlp- ');
939: END IF;
940: -- explicitly free the clob
941: dbms_lob.freetemporary(l_temp_clob);

Line 1113: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1109: -- Clear out the output CLOB buffer
1110: dbms_lob.trim(l_clob, 0);
1111:
1112:
1113: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1114: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
1115: 'Inside Write_Soln_Attach_Cont_Hlp- ');
1116: END IF;
1117: FOR rec1 IN c1(p_solution_id, p_lang) LOOP

Line 1114: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',

1110: dbms_lob.trim(l_clob, 0);
1111:
1112:
1113: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1114: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
1115: 'Inside Write_Soln_Attach_Cont_Hlp- ');
1116: END IF;
1117: FOR rec1 IN c1(p_solution_id, p_lang) LOOP
1118:

Line 1121: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1117: FOR rec1 IN c1(p_solution_id, p_lang) LOOP
1118:
1119: -- Write the statement summary to clob
1120: l_data := l_newline||rec1.title||l_newline||rec1.description||l_newline||rec1.file_name||l_newline||rec1.url||l_newline||rec1.short_text||l_newline;
1121: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
1123: 'Before Remove_Tags-l_data: || l_data');
1124: END IF;
1125: l_data := Remove_Tags(l_data); --, p_temp_clob);

Line 1122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',

1118:
1119: -- Write the statement summary to clob
1120: l_data := l_newline||rec1.title||l_newline||rec1.description||l_newline||rec1.file_name||l_newline||rec1.url||l_newline||rec1.short_text||l_newline;
1121: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1122: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
1123: 'Before Remove_Tags-l_data: || l_data');
1124: END IF;
1125: l_data := Remove_Tags(l_data); --, p_temp_clob);
1126: l_amt := LENGTH(l_data);

Line 1137: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1133: /* commented for the bug fix 11739796
1134: blob_length := DBMS_LOB.GETLENGTH(rec1.file_data); --Bug 8815880
1135: If blob_length is not null then
1136: src_blob := rec1.file_data;
1137: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1138: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
1139: 'Before dbms_lob.converttoclob- src_blob : || src_blob');
1140: END IF;
1141: dbms_lob.converttoclob(l_clob ,src_blob, amount, dest_offset, src_offset, blob_csid,lang_context, warning);

Line 1138: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',

1134: blob_length := DBMS_LOB.GETLENGTH(rec1.file_data); --Bug 8815880
1135: If blob_length is not null then
1136: src_blob := rec1.file_data;
1137: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1138: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
1139: 'Before dbms_lob.converttoclob- src_blob : || src_blob');
1140: END IF;
1141: dbms_lob.converttoclob(l_clob ,src_blob, amount, dest_offset, src_offset, blob_csid,lang_context, warning);
1142: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1142: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1138: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
1139: 'Before dbms_lob.converttoclob- src_blob : || src_blob');
1140: END IF;
1141: dbms_lob.converttoclob(l_clob ,src_blob, amount, dest_offset, src_offset, blob_csid,lang_context, warning);
1142: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
1144: 'After dbms_lob.converttoclob- l_clob : || l_clob' );
1145: END IF;
1146:

Line 1143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',

1139: 'Before dbms_lob.converttoclob- src_blob : || src_blob');
1140: END IF;
1141: dbms_lob.converttoclob(l_clob ,src_blob, amount, dest_offset, src_offset, blob_csid,lang_context, warning);
1142: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.cskbdstb.pls',
1144: 'After dbms_lob.converttoclob- l_clob : || l_clob' );
1145: END IF;
1146:
1147: IF (l_clob IS NOT NULL AND dbms_lob.getlength(l_clob) > 0)