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

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

730: i_column_counter,
731: ecx_utils.g_source(j).clob_value
732: );
733: /** Change required for Clob Support -- 2263729 ***/
734: ecx_utils.g_source(j).clob_length := dbms_lob.getlength( ecx_utils.g_source(j).clob_value);
735: i_len := ecx_utils.g_source(j).clob_length;
736:
737: ecx_utils.g_source(j).is_clob := 'N';
738:

Line 742: dbms_lob.substr(ecx_utils.g_source(j).clob_value,i_len,1);

738:
739: If i_len <= ecx_utils.G_CLOB_VARCHAR_LEN Then
740: ecx_utils.g_source(j).is_clob := 'Y'; /** To indicate value has a shorter string of clob value ***/
741: ecx_utils.g_source(j).value :=
742: dbms_lob.substr(ecx_utils.g_source(j).clob_value,i_len,1);
743: ecx_utils.g_source(j).clob_value := null ;
744: ecx_utils.g_source(j).clob_length := null ;
745: End If;
746: end if;

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

1267: );
1268:
1269: -- set the out variable to have the latest document.
1270: if l_parseXML then
1271: dbms_lob.trim(i_xmldoc, 0);
1272: xmlDOM.writetoCLOB(ecx_utils.g_xmldoc,i_xmldoc);
1273:
1274: g_instlmode := wf_core.translate('WF_INSTALL');
1275:

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

1278: IF g_instlmode = 'EMBEDDED' THEN
1279: fnd_message.set_name('ecx', 'XML File for logging');
1280: 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);
1281: if(attachment_id <> -1 AND i_xmldoc is not null) then
1282: clength := dbms_lob.getlength(i_xmldoc);
1283: while clength >= offset LOOP
1284: ctemp := dbms_lob.substr(i_xmldoc,g_varmaxlength,offset);
1285: fnd_log_attachment.writeln(attachment_id, ctemp);
1286: offset := offset + g_varmaxlength;

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

1280: 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);
1281: if(attachment_id <> -1 AND i_xmldoc is not null) then
1282: clength := dbms_lob.getlength(i_xmldoc);
1283: while clength >= offset LOOP
1284: ctemp := dbms_lob.substr(i_xmldoc,g_varmaxlength,offset);
1285: fnd_log_attachment.writeln(attachment_id, ctemp);
1286: offset := offset + g_varmaxlength;
1287: End Loop;
1288: fnd_log_attachment.close(attachment_id);

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

1588: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1589: end if;
1590: end if;
1591:
1592: if dbms_lob.istemporary(i_xmldoc) = 1 then
1593: dbms_lob.freetemporary(i_xmldoc);
1594: end if;
1595:
1596: if(l_statementEnabled) then

Line 1593: dbms_lob.freetemporary(i_xmldoc);

1589: end if;
1590: end if;
1591:
1592: if dbms_lob.istemporary(i_xmldoc) = 1 then
1593: dbms_lob.freetemporary(i_xmldoc);
1594: end if;
1595:
1596: if(l_statementEnabled) then
1597: ecx_debug.log(l_statement,'msgid',i_msgid,i_method_name);

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

1608: end if;
1609:
1610: EXCEPTION
1611: WHEN ecx_utils.PROGRAM_EXIT then
1612: if dbms_lob.istemporary(i_xmldoc) = 1 then
1613: dbms_lob.freetemporary(i_xmldoc);
1614: end if;
1615: if (l_procedureEnabled) then
1616: ecx_debug.pop(i_method_name);

Line 1613: dbms_lob.freetemporary(i_xmldoc);

1609:
1610: EXCEPTION
1611: WHEN ecx_utils.PROGRAM_EXIT then
1612: if dbms_lob.istemporary(i_xmldoc) = 1 then
1613: dbms_lob.freetemporary(i_xmldoc);
1614: end if;
1615: if (l_procedureEnabled) then
1616: ecx_debug.pop(i_method_name);
1617: end if;

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

1649: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1650: end if;
1651: end if;
1652:
1653: if dbms_lob.istemporary(i_xmldoc) = 1 then
1654: dbms_lob.freetemporary(i_xmldoc);
1655: end if;
1656:
1657: if (l_procedureEnabled) then

Line 1654: dbms_lob.freetemporary(i_xmldoc);

1650: end if;
1651: end if;
1652:
1653: if dbms_lob.istemporary(i_xmldoc) = 1 then
1654: dbms_lob.freetemporary(i_xmldoc);
1655: end if;
1656:
1657: if (l_procedureEnabled) then
1658: ecx_debug.pop(i_method_name);

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

1918: ecx_debug.log(l_statement,'i_document_id',i_document_id,i_method_name );
1919: ecx_debug.log(l_statement,'i_map_code',i_map_code,i_method_name );
1920: end if;
1921: -- initialize i_tmpxmldoc
1922: dbms_lob.createtemporary(i_tmpxmldoc,TRUE,DBMS_LOB.SESSION);
1923:
1924: process_outbound_documents
1925: (
1926: i_message_standard,

Line 1942: dbms_lob.freetemporary (i_tmpxmldoc);

1938:
1939: -- free i_tmpxmldoc
1940: if i_tmpxmldoc is not null
1941: then
1942: dbms_lob.freetemporary (i_tmpxmldoc);
1943: end if;
1944: ecx_debug.setErrorInfo(0, 10, 'ECX_SUCCESSFUL_EXECUTION');
1945: i_ret_code := ecx_utils.i_ret_code;
1946: i_errbuf := ecx_utils.i_errbuf;

Line 1980: dbms_lob.freetemporary (i_tmpxmldoc);

1976: end if;
1977: -- free i_tmpxmldoc
1978: if i_tmpxmldoc is not null
1979: then
1980: dbms_lob.freetemporary (i_tmpxmldoc);
1981: end if;
1982: IF (ecx_logging_enabled ) THEN
1983: ecx_debug.print_log;
1984: ecx_debug.disable_debug;

Line 1999: dbms_lob.freetemporary (i_tmpxmldoc);

1995: end if;
1996: -- free i_tmpxmldoc
1997: if i_tmpxmldoc is not null
1998: then
1999: dbms_lob.freetemporary (i_tmpxmldoc);
2000: end if;
2001: IF (ecx_logging_enabled ) THEN
2002: ecx_debug.print_log;
2003: ecx_debug.disable_debug;