APPS.ECX_INBOUND_TRIG dependencies on DBMS_LOB

Line 356: dbms_lob.createtemporary(i_xmldoc, TRUE,DBMS_LOB.SESSION);

352: g_instlmode := wf_core.translate('WF_INSTALL');
353: if (l_procedureEnabled) then
354: ecx_debug.push(i_method_name);
355: end if;
356: dbms_lob.createtemporary(i_xmldoc, TRUE,DBMS_LOB.SESSION);
357: dbms_lob.trim(i_xmldoc, 0);
358: xmlDOM.writetoCLOB(ecx_utils.g_xmldoc,i_xmldoc);
359:
360: -- write XML to FS if debug > 0

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

353: if (l_procedureEnabled) then
354: ecx_debug.push(i_method_name);
355: end if;
356: dbms_lob.createtemporary(i_xmldoc, TRUE,DBMS_LOB.SESSION);
357: dbms_lob.trim(i_xmldoc, 0);
358: xmlDOM.writetoCLOB(ecx_utils.g_xmldoc,i_xmldoc);
359:
360: -- write XML to FS if debug > 0
361: if (l_statementEnabled)

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

363: IF g_instlmode = 'EMBEDDED' THEN
364: fnd_message.set_name('ecx', 'XML File for logging');
365: 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);
366: if(attachment_id <> -1 AND i_xmldoc is not null) then
367: clength := dbms_lob.getlength(i_xmldoc);
368: while clength >= offset LOOP
369: ctemp := dbms_lob.substr(i_xmldoc,g_varmaxlength,offset);
370: fnd_log_attachment.writeln(attachment_id, ctemp);
371: offset := offset + g_varmaxlength;

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

365: 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);
366: if(attachment_id <> -1 AND i_xmldoc is not null) then
367: clength := dbms_lob.getlength(i_xmldoc);
368: while clength >= offset LOOP
369: ctemp := dbms_lob.substr(i_xmldoc,g_varmaxlength,offset);
370: fnd_log_attachment.writeln(attachment_id, ctemp);
371: offset := offset + g_varmaxlength;
372: End Loop;
373: fnd_log_attachment.close(attachment_id);

Line 928: dbms_lob.freetemporary (o_payload);

924: end if;
925:
926: if o_payload is not null
927: then
928: dbms_lob.freetemporary (o_payload);
929: end if;
930: end if;
931: if (l_procedureEnabled) then
932: ecx_debug.pop(i_method_name);

Line 943: dbms_lob.freetemporary (o_payload);

939: end if;
940:
941: if o_payload is not null
942: then
943: dbms_lob.freetemporary (o_payload);
944: end if;
945: raise ecx_utils.program_exit;
946: when others then
947: --ecx_utils.g_map_id := -1;

Line 956: dbms_lob.freetemporary (o_payload);

952: end if;
953:
954: if o_payload is not null
955: then
956: dbms_lob.freetemporary (o_payload);
957: end if;
958: if (l_procedureEnabled) then
959: ecx_debug.pop(i_method_name);
960: end if;

Line 1296: --dbms_lob.freetemporary(i_xmldoc);

1292: ecx_debug.pop(i_method_name);
1293: end if;
1294: exception
1295: WHEN ECX_UTILS.PROGRAM_EXIT THEN
1296: --dbms_lob.freetemporary(i_xmldoc);
1297: if (l_procedureEnabled) then
1298: ecx_debug.pop(i_method_name);
1299: end if;
1300: raise ecx_utils.program_exit;

Line 1302: --dbms_lob.freetemporary(i_xmldoc);

1298: ecx_debug.pop(i_method_name);
1299: end if;
1300: raise ecx_utils.program_exit;
1301: when others then
1302: --dbms_lob.freetemporary(i_xmldoc);
1303: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1304: then
1305: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1306: else

Line 2432: --dbms_lob.freetemporary(o_payload);

2428: i_errbuf := ecx_utils.i_errbuf;
2429:
2430: exception
2431: when ecx_utils.program_exit then
2432: --dbms_lob.freetemporary(o_payload);
2433: --ecx_utils.g_map_id := -1;
2434: if(l_unexpectedEnabled) then
2435: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2436: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,

Line 2450: --dbms_lob.freetemporary(o_payload);

2446: i_ret_code := ecx_utils.i_ret_code;
2447: i_errbuf := ecx_utils.i_errbuf;
2448:
2449: when others then
2450: --dbms_lob.freetemporary(o_payload);
2451: --ecx_utils.g_map_id := -1;
2452: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2453: if(l_unexpectedEnabled) then
2454: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);