DBA Data[Home] [Help]

APPS.WMS_CAROUSEL_INTEGRATION_PVT dependencies on XMLDOM

Line 1807: l_doc xmldom.domdocument;

1803: l_occurrence NUMBER := 1;
1804: msg_component_exception EXCEPTION;
1805: -- Variables for xml message parsing
1806: l_parser xmlparser.parser;
1807: l_doc xmldom.domdocument;
1808: l_named_node_map xmldom.domnamednodemap;
1809: l_attribute_name VARCHAR2 (100);
1810: l_actual_attribute_name VARCHAR2 (100);
1811: l_attribute_value VARCHAR2 (100);

Line 1808: l_named_node_map xmldom.domnamednodemap;

1804: msg_component_exception EXCEPTION;
1805: -- Variables for xml message parsing
1806: l_parser xmlparser.parser;
1807: l_doc xmldom.domdocument;
1808: l_named_node_map xmldom.domnamednodemap;
1809: l_attribute_name VARCHAR2 (100);
1810: l_actual_attribute_name VARCHAR2 (100);
1811: l_attribute_value VARCHAR2 (100);
1812: l_nodelist_length NUMBER;

Line 1813: l_dom_node xmldom.domnode;

1809: l_attribute_name VARCHAR2 (100);
1810: l_actual_attribute_name VARCHAR2 (100);
1811: l_attribute_value VARCHAR2 (100);
1812: l_nodelist_length NUMBER;
1813: l_dom_node xmldom.domnode;
1814: l_nodelist xmldom.domnodelist;
1815: l_attributes_buffer VARCHAR2 (4000);
1816: l_response_record WMS_WCS_DEVICE_GRP.MSG_COMPONENT_LOOKUP_TYPE;
1817: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 1814: l_nodelist xmldom.domnodelist;

1810: l_actual_attribute_name VARCHAR2 (100);
1811: l_attribute_value VARCHAR2 (100);
1812: l_nodelist_length NUMBER;
1813: l_dom_node xmldom.domnode;
1814: l_nodelist xmldom.domnodelist;
1815: l_attributes_buffer VARCHAR2 (4000);
1816: l_response_record WMS_WCS_DEVICE_GRP.MSG_COMPONENT_LOOKUP_TYPE;
1817: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1818: PRAGMA AUTONOMOUS_TRANSACTION;

Line 1876: l_nodelist := xmldom.getelementsbytagname (l_doc, '*');

1872: l_parser := xmlparser.newparser;
1873: xmlparser.parsebuffer (l_parser, l_msg);
1874: l_doc := xmlparser.getdocument (l_parser);
1875: -- get all elements
1876: l_nodelist := xmldom.getelementsbytagname (l_doc, '*');
1877: l_nodelist_length := xmldom.getlength (l_nodelist);
1878: -- loop through elements
1879: FOR i IN 0 .. l_nodelist_length - 1
1880: LOOP

Line 1877: l_nodelist_length := xmldom.getlength (l_nodelist);

1873: xmlparser.parsebuffer (l_parser, l_msg);
1874: l_doc := xmlparser.getdocument (l_parser);
1875: -- get all elements
1876: l_nodelist := xmldom.getelementsbytagname (l_doc, '*');
1877: l_nodelist_length := xmldom.getlength (l_nodelist);
1878: -- loop through elements
1879: FOR i IN 0 .. l_nodelist_length - 1
1880: LOOP
1881: l_dom_node := xmldom.item (l_nodelist, i);

Line 1881: l_dom_node := xmldom.item (l_nodelist, i);

1877: l_nodelist_length := xmldom.getlength (l_nodelist);
1878: -- loop through elements
1879: FOR i IN 0 .. l_nodelist_length - 1
1880: LOOP
1881: l_dom_node := xmldom.item (l_nodelist, i);
1882: --LOG (p_device_id, xmldom.getnodename (l_dom_node) || ' ');
1883: --LOG (p_device_id, '--------------');
1884: l_actual_attribute_name := xmldom.getnodename (l_dom_node);
1885: --This will come from the new component table

Line 1882: --LOG (p_device_id, xmldom.getnodename (l_dom_node) || ' ');

1878: -- loop through elements
1879: FOR i IN 0 .. l_nodelist_length - 1
1880: LOOP
1881: l_dom_node := xmldom.item (l_nodelist, i);
1882: --LOG (p_device_id, xmldom.getnodename (l_dom_node) || ' ');
1883: --LOG (p_device_id, '--------------');
1884: l_actual_attribute_name := xmldom.getnodename (l_dom_node);
1885: --This will come from the new component table
1886: /*

Line 1884: l_actual_attribute_name := xmldom.getnodename (l_dom_node);

1880: LOOP
1881: l_dom_node := xmldom.item (l_nodelist, i);
1882: --LOG (p_device_id, xmldom.getnodename (l_dom_node) || ' ');
1883: --LOG (p_device_id, '--------------');
1884: l_actual_attribute_name := xmldom.getnodename (l_dom_node);
1885: --This will come from the new component table
1886: /*
1887: IF l_actual_attribute_name IN
1888: ('ORG', 'ITEM', 'QTY', 'ACTION', 'LPN', 'DEVCOMP1')

Line 1895: l_named_node_map := xmldom.getattributes (l_dom_node);

1891: )
1892: THEN
1893: --LOG (p_device_id, 'i=' || TO_CHAR (i));
1894: -- get all attributes of element
1895: l_named_node_map := xmldom.getattributes (l_dom_node);
1896: l_dom_node := xmldom.getfirstchild (l_dom_node);
1897: IF xmldom.isnull (l_dom_node) = FALSE
1898: THEN
1899: l_attribute_name := xmldom.getnodename (l_dom_node);

Line 1896: l_dom_node := xmldom.getfirstchild (l_dom_node);

1892: THEN
1893: --LOG (p_device_id, 'i=' || TO_CHAR (i));
1894: -- get all attributes of element
1895: l_named_node_map := xmldom.getattributes (l_dom_node);
1896: l_dom_node := xmldom.getfirstchild (l_dom_node);
1897: IF xmldom.isnull (l_dom_node) = FALSE
1898: THEN
1899: l_attribute_name := xmldom.getnodename (l_dom_node);
1900: IF xmldom.getnodetype (l_dom_node) = xmldom.text_node

Line 1897: IF xmldom.isnull (l_dom_node) = FALSE

1893: --LOG (p_device_id, 'i=' || TO_CHAR (i));
1894: -- get all attributes of element
1895: l_named_node_map := xmldom.getattributes (l_dom_node);
1896: l_dom_node := xmldom.getfirstchild (l_dom_node);
1897: IF xmldom.isnull (l_dom_node) = FALSE
1898: THEN
1899: l_attribute_name := xmldom.getnodename (l_dom_node);
1900: IF xmldom.getnodetype (l_dom_node) = xmldom.text_node
1901: THEN

Line 1899: l_attribute_name := xmldom.getnodename (l_dom_node);

1895: l_named_node_map := xmldom.getattributes (l_dom_node);
1896: l_dom_node := xmldom.getfirstchild (l_dom_node);
1897: IF xmldom.isnull (l_dom_node) = FALSE
1898: THEN
1899: l_attribute_name := xmldom.getnodename (l_dom_node);
1900: IF xmldom.getnodetype (l_dom_node) = xmldom.text_node
1901: THEN
1902: l_no_of_msg_comps := l_no_of_msg_comps + 1;
1903: --LOG(p_device_id, 'l_no_of_msg_comps'||l_no_of_msg_comps);

Line 1900: IF xmldom.getnodetype (l_dom_node) = xmldom.text_node

1896: l_dom_node := xmldom.getfirstchild (l_dom_node);
1897: IF xmldom.isnull (l_dom_node) = FALSE
1898: THEN
1899: l_attribute_name := xmldom.getnodename (l_dom_node);
1900: IF xmldom.getnodetype (l_dom_node) = xmldom.text_node
1901: THEN
1902: l_no_of_msg_comps := l_no_of_msg_comps + 1;
1903: --LOG(p_device_id, 'l_no_of_msg_comps'||l_no_of_msg_comps);
1904: l_attribute_value := xmldom.getnodevalue (l_dom_node);

Line 1904: l_attribute_value := xmldom.getnodevalue (l_dom_node);

1900: IF xmldom.getnodetype (l_dom_node) = xmldom.text_node
1901: THEN
1902: l_no_of_msg_comps := l_no_of_msg_comps + 1;
1903: --LOG(p_device_id, 'l_no_of_msg_comps'||l_no_of_msg_comps);
1904: l_attribute_value := xmldom.getnodevalue (l_dom_node);
1905: IF l_debug > 0 THEN
1906: LOG (p_device_id, 'l_attribute_name= '
1907: || l_actual_attribute_name
1908: || ' val= '

Line 1975: xmldom.freedocument (l_doc);

1971: END IF;
1972: END IF;
1973: END LOOP;
1974: xmlparser.freeparser (l_parser);
1975: xmldom.freedocument (l_doc);
1976: ELSIF l_msg_type = wms_carousel_integration_pvt.v_msg_with_delimiter
1977: THEN
1978: --This is the start of parsing logic for message of type 2
1979: --Message with delimiter