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.EDR_PSIG_RULE dependencies on DBMS_LOB

Line 806: l_erec_output_ln := DBMS_LOB.GETLENGTH(L_EREC_OUTPUT);

802: fnd_message.set_name('EDR','EDR_EREC_ATT_NTF_BODY');
803: fnd_message.set_token('ERECORD_ID',l_document_id);
804:
805: l_erec_output_ch := fnd_message.get;
806: l_erec_output_ln := DBMS_LOB.GETLENGTH(L_EREC_OUTPUT);
807: DBMS_LOB.ERASE(L_EREC_OUTPUT,l_erec_output_ln , 1);
808: DBMS_LOB.WRITE(L_EREC_OUTPUT, LENGTH(L_EREC_OUTPUT_CH), 1, l_erec_output_ch);
809: DBMS_LOB.TRIM(L_EREC_OUTPUT, length(l_erec_output_ch));
810:

Line 807: DBMS_LOB.ERASE(L_EREC_OUTPUT,l_erec_output_ln , 1);

803: fnd_message.set_token('ERECORD_ID',l_document_id);
804:
805: l_erec_output_ch := fnd_message.get;
806: l_erec_output_ln := DBMS_LOB.GETLENGTH(L_EREC_OUTPUT);
807: DBMS_LOB.ERASE(L_EREC_OUTPUT,l_erec_output_ln , 1);
808: DBMS_LOB.WRITE(L_EREC_OUTPUT, LENGTH(L_EREC_OUTPUT_CH), 1, l_erec_output_ch);
809: DBMS_LOB.TRIM(L_EREC_OUTPUT, length(l_erec_output_ch));
810:
811: --Diagnostics Start

Line 808: DBMS_LOB.WRITE(L_EREC_OUTPUT, LENGTH(L_EREC_OUTPUT_CH), 1, l_erec_output_ch);

804:
805: l_erec_output_ch := fnd_message.get;
806: l_erec_output_ln := DBMS_LOB.GETLENGTH(L_EREC_OUTPUT);
807: DBMS_LOB.ERASE(L_EREC_OUTPUT,l_erec_output_ln , 1);
808: DBMS_LOB.WRITE(L_EREC_OUTPUT, LENGTH(L_EREC_OUTPUT_CH), 1, l_erec_output_ch);
809: DBMS_LOB.TRIM(L_EREC_OUTPUT, length(l_erec_output_ch));
810:
811: --Diagnostics Start
812: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 809: DBMS_LOB.TRIM(L_EREC_OUTPUT, length(l_erec_output_ch));

805: l_erec_output_ch := fnd_message.get;
806: l_erec_output_ln := DBMS_LOB.GETLENGTH(L_EREC_OUTPUT);
807: DBMS_LOB.ERASE(L_EREC_OUTPUT,l_erec_output_ln , 1);
808: DBMS_LOB.WRITE(L_EREC_OUTPUT, LENGTH(L_EREC_OUTPUT_CH), 1, l_erec_output_ch);
809: DBMS_LOB.TRIM(L_EREC_OUTPUT, length(l_erec_output_ch));
810:
811: --Diagnostics Start
812: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
813: FND_MESSAGE.SET_NAME('EDR','EDR_FWK_ST_ERECORD_PDF_SUC_EVT');

Line 872: dbms_lob.createtemporary(X_DIFF_XML,TRUE);

868: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord',' generate_ERecord for redline. Error '||l_error );
869:
870: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord',' generate_ERecord for redline. l_error_msg '||l_error_msg );
871:
872: dbms_lob.createtemporary(X_DIFF_XML,TRUE);
873: dbms_lob.open( X_DIFF_XML, dbms_lob.lob_readwrite );
874:
875: select DIFF_XML into x_output from EDR_REDLINE_TRANS_DATA where EVENT_ID = p_edr_event_id ;
876:

Line 873: dbms_lob.open( X_DIFF_XML, dbms_lob.lob_readwrite );

869:
870: wf_log_pkg.string(1, 'EDR_PSIG_RULE.store_erecord',' generate_ERecord for redline. l_error_msg '||l_error_msg );
871:
872: dbms_lob.createtemporary(X_DIFF_XML,TRUE);
873: dbms_lob.open( X_DIFF_XML, dbms_lob.lob_readwrite );
874:
875: select DIFF_XML into x_output from EDR_REDLINE_TRANS_DATA where EVENT_ID = p_edr_event_id ;
876:
877: l_clob_len := dbms_lob.getlength(x_output);

Line 877: l_clob_len := dbms_lob.getlength(x_output);

873: dbms_lob.open( X_DIFF_XML, dbms_lob.lob_readwrite );
874:
875: select DIFF_XML into x_output from EDR_REDLINE_TRANS_DATA where EVENT_ID = p_edr_event_id ;
876:
877: l_clob_len := dbms_lob.getlength(x_output);
878: WHILE l_pos < l_clob_len LOOP
879: dbms_lob.read(x_output, l_amount, l_pos, vBuffer);
880: dbms_lob.writeappend(X_DIFF_XML, LENGTH(vBuffer), vBuffer);
881: l_pos := l_pos + l_amount;

Line 879: dbms_lob.read(x_output, l_amount, l_pos, vBuffer);

875: select DIFF_XML into x_output from EDR_REDLINE_TRANS_DATA where EVENT_ID = p_edr_event_id ;
876:
877: l_clob_len := dbms_lob.getlength(x_output);
878: WHILE l_pos < l_clob_len LOOP
879: dbms_lob.read(x_output, l_amount, l_pos, vBuffer);
880: dbms_lob.writeappend(X_DIFF_XML, LENGTH(vBuffer), vBuffer);
881: l_pos := l_pos + l_amount;
882: END LOOP;
883:

Line 880: dbms_lob.writeappend(X_DIFF_XML, LENGTH(vBuffer), vBuffer);

876:
877: l_clob_len := dbms_lob.getlength(x_output);
878: WHILE l_pos < l_clob_len LOOP
879: dbms_lob.read(x_output, l_amount, l_pos, vBuffer);
880: dbms_lob.writeappend(X_DIFF_XML, LENGTH(vBuffer), vBuffer);
881: l_pos := l_pos + l_amount;
882: END LOOP;
883:
884: L_EREC_OUTPUT := X_DIFF_XML;

Line 885: dbms_lob.close(X_DIFF_XML);

881: l_pos := l_pos + l_amount;
882: END LOOP;
883:
884: L_EREC_OUTPUT := X_DIFF_XML;
885: dbms_lob.close(X_DIFF_XML);
886: dbms_lob.freeTemporary(X_DIFF_XML );
887:
888: IF nvl(l_error,0) <> 0 THEN
889: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Template Type : text ');

Line 886: dbms_lob.freeTemporary(X_DIFF_XML );

882: END LOOP;
883:
884: L_EREC_OUTPUT := X_DIFF_XML;
885: dbms_lob.close(X_DIFF_XML);
886: dbms_lob.freeTemporary(X_DIFF_XML );
887:
888: IF nvl(l_error,0) <> 0 THEN
889: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Template Type : text ');
890: wf_log_pkg.string(4, 'EDR_PSIG_RULE.store_erecord','Error Code '||l_error);

Line 1973: if dbms_lob.getlength(l_event_data)>0 then

1969: select event_xml
1970: into l_event_data
1971: from EDR_FINAL_XML_GT;
1972:
1973: if dbms_lob.getlength(l_event_data)>0 then
1974: --Diagnostics Start
1975: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1976: FND_MESSAGE.SET_NAME('EDR','EDR_FWKRULE_DATA_SOURCE_EVT');
1977: FND_MESSAGE.SET_TOKEN('EVENT_NAME',p_event.getEventName());

Line 2020: DBMS_LOB.CREATETEMPORARY(l_erecord_data, TRUE, DBMS_LOB.SESSION);

2016: --Take the source XML as the target itself.
2017: elsif l_transform_xml = 'N' then
2018: --We need to recreate the event CLOB in another XML CLOB as
2019: --the CLOB obtained from the event definition cannot be modified.
2020: DBMS_LOB.CREATETEMPORARY(l_erecord_data, TRUE, DBMS_LOB.SESSION);
2021: DBMS_LOB.COPY(l_erecord_data,l_event_data,DBMS_LOB.GETLENGTH(l_event_data));
2022: l_attachment_string_details := wf_event.getValueForParameter('EDR_PSIG_ATTACHMENT',p_event.Parameter_List);
2023: if l_attachment_string_details is not null then
2024: EDR_ATTACHMENTS_GRP.ADD_ERP_ATTACH(p_attachment_string => l_attachment_string_details);

Line 2021: DBMS_LOB.COPY(l_erecord_data,l_event_data,DBMS_LOB.GETLENGTH(l_event_data));

2017: elsif l_transform_xml = 'N' then
2018: --We need to recreate the event CLOB in another XML CLOB as
2019: --the CLOB obtained from the event definition cannot be modified.
2020: DBMS_LOB.CREATETEMPORARY(l_erecord_data, TRUE, DBMS_LOB.SESSION);
2021: DBMS_LOB.COPY(l_erecord_data,l_event_data,DBMS_LOB.GETLENGTH(l_event_data));
2022: l_attachment_string_details := wf_event.getValueForParameter('EDR_PSIG_ATTACHMENT',p_event.Parameter_List);
2023: if l_attachment_string_details is not null then
2024: EDR_ATTACHMENTS_GRP.ADD_ERP_ATTACH(p_attachment_string => l_attachment_string_details);
2025: end if;

Line 2484: if dbms_lob.getlength(l_event_data) > 0 then

2480:
2481: -- Bug 3960236 : end
2482: --Bug 3667036 : Start
2483: --if event data is not null then don't call XML gateway again
2484: if dbms_lob.getlength(l_event_data) > 0 then
2485: L_XML_DOCUMENT := l_erecord_data;
2486: -- Bug 3960236 : Start
2487: elsif L_XML_GENERATION_API is NOT NULL then
2488: -- Check if call back function has been passed to generate XML document by product team