APPS.ECX_OUTBOUND dependencies on DBMS_LOB

Line 712: ecx_utils.g_source(j).clob_length := dbms_lob.getlength( ecx_utils.g_source(j).clob_value);

708: dbms_sql.column_value ( ecx_utils.g_source_levels(i).Cursor_handle, i_column_counter, ecx_utils.g_source(j).value );
709: ELSE
710: dbms_sql.column_value ( ecx_utils.g_source_levels(i).Cursor_handle, i_column_counter, ecx_utils.g_source(j).clob_value );
711: /** Change required for Clob Support -- 2263729 ***/
712: ecx_utils.g_source(j).clob_length := dbms_lob.getlength( ecx_utils.g_source(j).clob_value);
713: i_len := ecx_utils.g_source(j).clob_length;
714: ecx_utils.g_source(j).is_clob := 'N';
715: /** Fix for bug 8845448*/
716: IF i_len <= ecx_utils.G_CLOB_VARCHAR_LEN THEN

Line 718: dbms_lob.read(ecx_utils.g_source(j).clob_value,i_len,1,l_temp);

714: ecx_utils.g_source(j).is_clob := 'N';
715: /** Fix for bug 8845448*/
716: IF i_len <= ecx_utils.G_CLOB_VARCHAR_LEN THEN
717: BEGIN
718: dbms_lob.read(ecx_utils.g_source(j).clob_value,i_len,1,l_temp);
719: ecx_utils.g_source(j).value := l_temp;
720: ecx_utils.g_source(j).clob_value := NULL;
721: ecx_utils.g_source(j).clob_length := NULL;
722: EXCEPTION

Line 1235: dbms_lob.trim(i_xmldoc, 0);

1231: ecx_debug.log(l_statement, 'xslt transformation is defined and getting transformed output',i_method_name);
1232: end if;
1233: i_xmldoc := ecx_utils.g_out_transformed;
1234: else
1235: dbms_lob.trim(i_xmldoc, 0);
1236: xmlDOM.writetoCLOB(ecx_utils.g_xmldoc,i_xmldoc);
1237: end if;
1238:
1239: g_instlmode := wf_core.translate('WF_INSTALL');

Line 1247: clength := dbms_lob.getlength(i_xmldoc);

1243: IF g_instlmode = 'EMBEDDED' THEN
1244: fnd_message.set_name('ecx', 'XML File for logging');
1245: attachment_id := fnd_log.message_with_attachment(fnd_log.level_statement, substr(ecx_debug.g_aflog_module_name,1,length(ecx_debug.g_aflog_module_name)-4)||'.xml', TRUE);
1246: if(attachment_id <> -1 AND i_xmldoc is not null) then
1247: clength := dbms_lob.getlength(i_xmldoc);
1248: while clength >= offset LOOP
1249: ctemp := dbms_lob.substr(i_xmldoc,g_varmaxlength,offset);
1250: fnd_log_attachment.writeln(attachment_id, ctemp);
1251: offset := offset + g_varmaxlength;

Line 1249: ctemp := dbms_lob.substr(i_xmldoc,g_varmaxlength,offset);

1245: attachment_id := fnd_log.message_with_attachment(fnd_log.level_statement, substr(ecx_debug.g_aflog_module_name,1,length(ecx_debug.g_aflog_module_name)-4)||'.xml', TRUE);
1246: if(attachment_id <> -1 AND i_xmldoc is not null) then
1247: clength := dbms_lob.getlength(i_xmldoc);
1248: while clength >= offset LOOP
1249: ctemp := dbms_lob.substr(i_xmldoc,g_varmaxlength,offset);
1250: fnd_log_attachment.writeln(attachment_id, ctemp);
1251: offset := offset + g_varmaxlength;
1252: End Loop;
1253: fnd_log_attachment.close(attachment_id);

Line 1557: if dbms_lob.istemporary(i_xmldoc) = 1 then

1553: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1554: end if;
1555: end if;
1556:
1557: if dbms_lob.istemporary(i_xmldoc) = 1 then
1558: dbms_lob.freetemporary(i_xmldoc);
1559: end if;
1560:
1561: if(l_statementEnabled) then

Line 1558: dbms_lob.freetemporary(i_xmldoc);

1554: end if;
1555: end if;
1556:
1557: if dbms_lob.istemporary(i_xmldoc) = 1 then
1558: dbms_lob.freetemporary(i_xmldoc);
1559: end if;
1560:
1561: if(l_statementEnabled) then
1562: ecx_debug.log(l_statement,'msgid',i_msgid,i_method_name);

Line 1577: if dbms_lob.istemporary(i_xmldoc) = 1 then

1573: end if;
1574:
1575: EXCEPTION
1576: WHEN ecx_utils.PROGRAM_EXIT then
1577: if dbms_lob.istemporary(i_xmldoc) = 1 then
1578: dbms_lob.freetemporary(i_xmldoc);
1579: end if;
1580: if (l_procedureEnabled) then
1581: ecx_debug.pop(i_method_name);

Line 1578: dbms_lob.freetemporary(i_xmldoc);

1574:
1575: EXCEPTION
1576: WHEN ecx_utils.PROGRAM_EXIT then
1577: if dbms_lob.istemporary(i_xmldoc) = 1 then
1578: dbms_lob.freetemporary(i_xmldoc);
1579: end if;
1580: if (l_procedureEnabled) then
1581: ecx_debug.pop(i_method_name);
1582: end if;

Line 1618: if dbms_lob.istemporary(i_xmldoc) = 1 then

1614: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1615: end if;
1616: end if;
1617:
1618: if dbms_lob.istemporary(i_xmldoc) = 1 then
1619: dbms_lob.freetemporary(i_xmldoc);
1620: end if;
1621:
1622: if (l_procedureEnabled) then

Line 1619: dbms_lob.freetemporary(i_xmldoc);

1615: end if;
1616: end if;
1617:
1618: if dbms_lob.istemporary(i_xmldoc) = 1 then
1619: dbms_lob.freetemporary(i_xmldoc);
1620: end if;
1621:
1622: if (l_procedureEnabled) then
1623: ecx_debug.pop(i_method_name);

Line 1887: dbms_lob.createtemporary(i_tmpxmldoc,TRUE,DBMS_LOB.SESSION);

1883: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1884: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1885: end if;
1886: -- initialize i_tmpxmldoc
1887: dbms_lob.createtemporary(i_tmpxmldoc,TRUE,DBMS_LOB.SESSION);
1888:
1889: process_outbound_documents
1890: (
1891: i_message_standard,

Line 1907: dbms_lob.freetemporary (i_tmpxmldoc);

1903:
1904: -- free i_tmpxmldoc
1905: if i_tmpxmldoc is not null
1906: then
1907: dbms_lob.freetemporary (i_tmpxmldoc);
1908: end if;
1909: ecx_debug.setErrorInfo(0, 10, 'ECX_SUCCESSFUL_EXECUTION');
1910: i_ret_code := ecx_utils.i_ret_code;
1911: i_errbuf := ecx_utils.i_errbuf;

Line 1945: dbms_lob.freetemporary (i_tmpxmldoc);

1941: end if;
1942: -- free i_tmpxmldoc
1943: if i_tmpxmldoc is not null
1944: then
1945: dbms_lob.freetemporary (i_tmpxmldoc);
1946: end if;
1947: IF (ecx_logging_enabled ) THEN
1948: ecx_debug.print_log;
1949: ecx_debug.disable_debug;

Line 1964: dbms_lob.freetemporary (i_tmpxmldoc);

1960: end if;
1961: -- free i_tmpxmldoc
1962: if i_tmpxmldoc is not null
1963: then
1964: dbms_lob.freetemporary (i_tmpxmldoc);
1965: end if;
1966: IF (ecx_logging_enabled ) THEN
1967: ecx_debug.print_log;
1968: ecx_debug.disable_debug;