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 914: dbms_lob.freetemporary (o_payload);

910: end if;
911:
912: if o_payload is not null
913: then
914: dbms_lob.freetemporary (o_payload);
915: end if;
916: if (l_procedureEnabled) then
917: ecx_debug.pop(i_method_name);
918: end if;

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: raise ecx_utils.program_exit;
931: when others then
932: --ecx_utils.g_map_id := -1;

Line 941: dbms_lob.freetemporary (o_payload);

937: end if;
938:
939: if o_payload is not null
940: then
941: dbms_lob.freetemporary (o_payload);
942: end if;
943: if (l_procedureEnabled) then
944: ecx_debug.pop(i_method_name);
945: end if;

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

1277: ecx_debug.pop(i_method_name);
1278: end if;
1279: exception
1280: WHEN ECX_UTILS.PROGRAM_EXIT THEN
1281: --dbms_lob.freetemporary(i_xmldoc);
1282: if (l_procedureEnabled) then
1283: ecx_debug.pop(i_method_name);
1284: end if;
1285: raise ecx_utils.program_exit;

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

1283: ecx_debug.pop(i_method_name);
1284: end if;
1285: raise ecx_utils.program_exit;
1286: when others then
1287: --dbms_lob.freetemporary(i_xmldoc);
1288: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1289: then
1290: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1291: else

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

2390: i_errbuf := ecx_utils.i_errbuf;
2391:
2392: exception
2393: when ecx_utils.program_exit then
2394: --dbms_lob.freetemporary(o_payload);
2395: --ecx_utils.g_map_id := -1;
2396: if(l_unexpectedEnabled) then
2397: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2398: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,

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

2408: i_ret_code := ecx_utils.i_ret_code;
2409: i_errbuf := ecx_utils.i_errbuf;
2410:
2411: when others then
2412: --dbms_lob.freetemporary(o_payload);
2413: --ecx_utils.g_map_id := -1;
2414: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2415: if(l_unexpectedEnabled) then
2416: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);