DBA Data[Home] [Help]

APPS.ECX_INBOUND_TRIG dependencies on XMLDOM

Line 58: i_doc IN xmlDOM.DOMDocument,

54:
55:
56: procedure get_element_value
57: (
58: i_doc IN xmlDOM.DOMDocument,
59: i_element IN varchar2,
60: i_value OUT NOCOPY varchar2
61: )
62: is

Line 66: nl xmlDOM.DOMNodeList := null;

62: is
63:
64:
65: i_method_name varchar2(2000) := 'ecx_inbound_trig.get_element_value';
66: nl xmlDOM.DOMNodeList := null;
67: n pls_integer;
68: pnode xmlDOM.DOMNode;
69: cnode xmlDOM.DOMNode;
70: begin

Line 68: pnode xmlDOM.DOMNode;

64:
65: i_method_name varchar2(2000) := 'ecx_inbound_trig.get_element_value';
66: nl xmlDOM.DOMNodeList := null;
67: n pls_integer;
68: pnode xmlDOM.DOMNode;
69: cnode xmlDOM.DOMNode;
70: begin
71: if (l_procedureEnabled) then
72: ecx_debug.push(i_method_name);

Line 69: cnode xmlDOM.DOMNode;

65: i_method_name varchar2(2000) := 'ecx_inbound_trig.get_element_value';
66: nl xmlDOM.DOMNodeList := null;
67: n pls_integer;
68: pnode xmlDOM.DOMNode;
69: cnode xmlDOM.DOMNode;
70: begin
71: if (l_procedureEnabled) then
72: ecx_debug.push(i_method_name);
73: end if;

Line 78: nl := xmlDOM.getElementsByTagName(i_doc,i_element);

74: if(l_statementEnabled) then
75: ecx_debug.log(l_statement,'i_doc',i_doc.id,i_method_name);
76: ecx_debug.log(l_statement,'i_element',i_element,i_method_name);
77: end if;
78: nl := xmlDOM.getElementsByTagName(i_doc,i_element);
79:
80: if (not xmlDOM.isNull(nl))
81: then
82: n := xmlDOM.getLength(nl);

Line 80: if (not xmlDOM.isNull(nl))

76: ecx_debug.log(l_statement,'i_element',i_element,i_method_name);
77: end if;
78: nl := xmlDOM.getElementsByTagName(i_doc,i_element);
79:
80: if (not xmlDOM.isNull(nl))
81: then
82: n := xmlDOM.getLength(nl);
83: if n > 0
84: then

Line 82: n := xmlDOM.getLength(nl);

78: nl := xmlDOM.getElementsByTagName(i_doc,i_element);
79:
80: if (not xmlDOM.isNull(nl))
81: then
82: n := xmlDOM.getLength(nl);
83: if n > 0
84: then
85: pnode := xmlDOM.item(nl,0);
86: cnode := xmlDOM.getFirstChild(pnode);

Line 85: pnode := xmlDOM.item(nl,0);

81: then
82: n := xmlDOM.getLength(nl);
83: if n > 0
84: then
85: pnode := xmlDOM.item(nl,0);
86: cnode := xmlDOM.getFirstChild(pnode);
87: if (not xmlDOM.isNull(cnode))
88: then
89: i_value := xmlDOM.getNodeValue(cnode);

Line 86: cnode := xmlDOM.getFirstChild(pnode);

82: n := xmlDOM.getLength(nl);
83: if n > 0
84: then
85: pnode := xmlDOM.item(nl,0);
86: cnode := xmlDOM.getFirstChild(pnode);
87: if (not xmlDOM.isNull(cnode))
88: then
89: i_value := xmlDOM.getNodeValue(cnode);
90: end if;

Line 87: if (not xmlDOM.isNull(cnode))

83: if n > 0
84: then
85: pnode := xmlDOM.item(nl,0);
86: cnode := xmlDOM.getFirstChild(pnode);
87: if (not xmlDOM.isNull(cnode))
88: then
89: i_value := xmlDOM.getNodeValue(cnode);
90: end if;
91: end if;

Line 89: i_value := xmlDOM.getNodeValue(cnode);

85: pnode := xmlDOM.item(nl,0);
86: cnode := xmlDOM.getFirstChild(pnode);
87: if (not xmlDOM.isNull(cnode))
88: then
89: i_value := xmlDOM.getNodeValue(cnode);
90: end if;
91: end if;
92: end if;
93: if(l_statementEnabled) then

Line 113: i_doc IN xmlDOM.DOMDocument,

109:
110: procedure getAttributes
111: (
112: i_standard_code in varchar2,
113: i_doc IN xmlDOM.DOMDocument,
114: i_standard_type in varchar2
115: )
116: is
117:

Line 220: when xmlDOM.INDEX_SIZE_ERR then

216: ecx_debug.pop(i_method_name);
217: end if;
218: exception
219: -- Put All DOM Parser Exceptions Here.
220: when xmlDOM.INDEX_SIZE_ERR then
221: ecx_debug.setErrorInfo(1,20,SQLERRM);
222: if(l_unexpectedEnabled) then
223: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
224: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);

Line 230: when xmlDOM.DOMSTRING_SIZE_ERR then

226: if (l_procedureEnabled) then
227: ecx_debug.pop(i_method_name);
228: end if;
229: raise ecx_utils.program_exit;
230: when xmlDOM.DOMSTRING_SIZE_ERR then
231: ecx_debug.setErrorInfo(1,20,SQLERRM);
232: if(l_unexpectedEnabled) then
233: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
234: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);

Line 240: when xmlDOM.HIERARCHY_REQUEST_ERR then

236: if (l_procedureEnabled) then
237: ecx_debug.pop(i_method_name);
238: end if;
239: raise ecx_utils.program_exit;
240: when xmlDOM.HIERARCHY_REQUEST_ERR then
241: ecx_debug.setErrorInfo(1,20,SQLERRM);
242: if(l_unexpectedEnabled) then
243: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
244: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);

Line 250: when xmlDOM.WRONG_DOCUMENT_ERR then

246: if (l_procedureEnabled) then
247: ecx_debug.pop(i_method_name);
248: end if;
249: raise ecx_utils.program_exit;
250: when xmlDOM.WRONG_DOCUMENT_ERR then
251: ecx_debug.setErrorInfo(1,20,SQLERRM);
252: if(l_unexpectedEnabled) then
253: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
254: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);

Line 260: when xmlDOM.INVALID_CHARACTER_ERR then

256: if (l_procedureEnabled) then
257: ecx_debug.pop(i_method_name);
258: end if;
259: raise ecx_utils.program_exit;
260: when xmlDOM.INVALID_CHARACTER_ERR then
261: ecx_debug.setErrorInfo(1,20,SQLERRM);
262: if(l_unexpectedEnabled) then
263: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
264: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);

Line 270: when xmlDOM.NO_DATA_ALLOWED_ERR then

266: if (l_procedureEnabled) then
267: ecx_debug.pop(i_method_name);
268: end if;
269: raise ecx_utils.program_exit;
270: when xmlDOM.NO_DATA_ALLOWED_ERR then
271: ecx_debug.setErrorInfo(1,20,SQLERRM);
272: if(l_unexpectedEnabled) then
273: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
274: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);

Line 280: when xmlDOM.No_MODIFICATION_ALLOWED_ERR then

276: if (l_procedureEnabled) then
277: ecx_debug.pop(i_method_name);
278: end if;
279: raise ecx_utils.program_exit;
280: when xmlDOM.No_MODIFICATION_ALLOWED_ERR then
281: ecx_debug.setErrorInfo(1,20,SQLERRM);
282: if(l_unexpectedEnabled) then
283: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
284: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);

Line 290: when xmlDOM.NOT_FOUND_ERR then

286: if (l_procedureEnabled) then
287: ecx_debug.pop(i_method_name);
288: end if;
289: raise ecx_utils.program_exit;
290: when xmlDOM.NOT_FOUND_ERR then
291: ecx_debug.setErrorInfo(1,20,SQLERRM);
292: if(l_unexpectedEnabled) then
293: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
294: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);

Line 300: when xmlDOM.NOT_SUPPORTED_ERR then

296: if (l_procedureEnabled) then
297: ecx_debug.pop(i_method_name);
298: end if;
299: raise ecx_utils.program_exit;
300: when xmlDOM.NOT_SUPPORTED_ERR then
301: ecx_debug.setErrorInfo(1,20,SQLERRM);
302: if(l_unexpectedEnabled) then
303: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
304: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);

Line 310: when xmlDOM.INUSE_ATTRIBUTE_ERR then

306: if (l_procedureEnabled) then
307: ecx_debug.pop(i_method_name);
308: end if;
309: raise ecx_utils.program_exit;
310: when xmlDOM.INUSE_ATTRIBUTE_ERR then
311: ecx_debug.setErrorInfo(1,20,SQLERRM);
312: if(l_unexpectedEnabled) then
313: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
314: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);

Line 358: xmlDOM.writetoCLOB(ecx_utils.g_xmldoc,i_xmldoc);

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)
362: then

Line 376: xmlDOM.writetofile(ecx_utils.g_xmldoc,

372: End Loop;
373: fnd_log_attachment.close(attachment_id);
374: end if;
375: ELSE
376: xmlDOM.writetofile(ecx_utils.g_xmldoc,
377: ecx_utils.g_logdir||ecx_utils.getFileSeparator()||
378: substr(ecx_utils.g_logfile, 1,
379: length(ecx_utils.g_logfile)-4) ||'.xml');
380: END IF;

Line 403: i_doc xmlDOM.DOMDocument;

399: )
400: is
401:
402: i_method_name varchar2(2000) := 'ecx_inbound_trig.processxmldata';
403: i_doc xmlDOM.DOMDocument;
404: l_same_map Boolean;
405: l_parseXML boolean;
406:
407: begin

Line 439: ecx_utils.g_xmldoc := xmlDOM.makeNode(i_doc);

435:
436: i_doc := xmlparser.getDocument(ecx_utils.g_parser);
437:
438: /** Assign it to the Global XML Document **/
439: ecx_utils.g_xmldoc := xmlDOM.makeNode(i_doc);
440:
441: /** Get all the attributes in a generic way for a given standard and save in ecx_doclogs**/
442: getAttributes (
443: i_message_standard,

Line 465: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then

461: end if;
462: writeXMLToFile(i_xmldoc);
463:
464: begin
465: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
466: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
467: end if;
468: exception
469: when others then

Line 466: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));

462: writeXMLToFile(i_xmldoc);
463:
464: begin
465: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
466: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
467: end if;
468: exception
469: when others then
470: null;

Line 500: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then

496: end if;
497: ecx_print_local.last_printed := -1;
498:
499: begin
500: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
501: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
502: end if;
503: exception
504: when others then

Line 501: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));

497: ecx_print_local.last_printed := -1;
498:
499: begin
500: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
501: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
502: end if;
503: exception
504: when others then
505: null;

Line 522: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then

518: ecx_debug.pop(i_method_name);
519: end if;
520:
521: begin
522: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
523: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
524: end if;
525: exception
526: when others then

Line 523: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));

519: end if;
520:
521: begin
522: if not xmlDOM.isNull(ecx_utils.g_xmldoc) then
523: xmlDOM.freeDocument(xmlDOM.makeDocument(ecx_utils.g_xmldoc));
524: end if;
525: exception
526: when others then
527: null;