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.IRC_LOCATION_UTILITY dependencies on XMLDOM

Line 379: address_doc xmldom.DOMDocument;

375: function process_return_xml
376: (xml_response varchar2)
377: return MDSYS.SDO_GEOMETRY
378: as
379: address_doc xmldom.DOMDocument;
380: match_nodes xmlDom.DOMNodeList;
381: match_node xmlDom.DOMNode;
382: parser xmlparser.parser;
383: l_longitude number;

Line 380: match_nodes xmlDom.DOMNodeList;

376: (xml_response varchar2)
377: return MDSYS.SDO_GEOMETRY
378: as
379: address_doc xmldom.DOMDocument;
380: match_nodes xmlDom.DOMNodeList;
381: match_node xmlDom.DOMNode;
382: parser xmlparser.parser;
383: l_longitude number;
384: l_latitude number;

Line 381: match_node xmlDom.DOMNode;

377: return MDSYS.SDO_GEOMETRY
378: as
379: address_doc xmldom.DOMDocument;
380: match_nodes xmlDom.DOMNodeList;
381: match_node xmlDom.DOMNode;
382: parser xmlparser.parser;
383: l_longitude number;
384: l_latitude number;
385: l_proc varchar2(72) := g_package||'process_return_xml';

Line 394: match_nodes:=xslprocessor.selectNodes(xmldom.makeNode(address_doc),'/geocode_response/geocode/match');

390: xmlparser.parseBuffer(parser,xml_response);
391: address_doc:=xmlparser.getDocument(parser);
392: xmlparser.freeParser(parser);
393: hr_utility.set_location(l_proc, 20);
394: match_nodes:=xslprocessor.selectNodes(xmldom.makeNode(address_doc),'/geocode_response/geocode/match');
395: if xmldom.getlength(match_nodes)>0 then
396: hr_utility.set_location(l_proc, 30);
397: match_node :=xmldom.item(match_nodes,0);
398: xslprocessor.valueOf(match_node,'@longitude',l_longitude);

Line 395: if xmldom.getlength(match_nodes)>0 then

391: address_doc:=xmlparser.getDocument(parser);
392: xmlparser.freeParser(parser);
393: hr_utility.set_location(l_proc, 20);
394: match_nodes:=xslprocessor.selectNodes(xmldom.makeNode(address_doc),'/geocode_response/geocode/match');
395: if xmldom.getlength(match_nodes)>0 then
396: hr_utility.set_location(l_proc, 30);
397: match_node :=xmldom.item(match_nodes,0);
398: xslprocessor.valueOf(match_node,'@longitude',l_longitude);
399: xslprocessor.valueOf(match_node,'@latitude',l_latitude);

Line 397: match_node :=xmldom.item(match_nodes,0);

393: hr_utility.set_location(l_proc, 20);
394: match_nodes:=xslprocessor.selectNodes(xmldom.makeNode(address_doc),'/geocode_response/geocode/match');
395: if xmldom.getlength(match_nodes)>0 then
396: hr_utility.set_location(l_proc, 30);
397: match_node :=xmldom.item(match_nodes,0);
398: xslprocessor.valueOf(match_node,'@longitude',l_longitude);
399: xslprocessor.valueOf(match_node,'@latitude',l_latitude);
400: end if;
401: xmldom.freeDocument(address_doc);

Line 401: xmldom.freeDocument(address_doc);

397: match_node :=xmldom.item(match_nodes,0);
398: xslprocessor.valueOf(match_node,'@longitude',l_longitude);
399: xslprocessor.valueOf(match_node,'@latitude',l_latitude);
400: end if;
401: xmldom.freeDocument(address_doc);
402: hr_utility.set_location(l_proc, 40);
403: if (l_longitude is not null and l_latitude is not null) then
404: RETURN MDSYS.SDO_GEOMETRY(2001
405: ,8307

Line 419: xmldom.freeDocument(address_doc);

415: exception
416: when others then
417: begin
418: hr_utility.set_location(l_proc, 50);
419: xmldom.freeDocument(address_doc);
420: return null;
421: exception
422: when others then
423: return null;

Line 573: address_doc xmldom.DOMDocument;

569: longitude_loc NUMBER;
570: l_success number := 0;
571: l_failure number := 0;
572: first_line number;
573: address_doc xmldom.DOMDocument;
574: geocode_nodes xmlDom.DOMNodeList;
575: geocode_node xmlDom.DOMNode;
576: match_node xmlDom.DOMNode;
577: parser xmlparser.parser;

Line 574: geocode_nodes xmlDom.DOMNodeList;

570: l_success number := 0;
571: l_failure number := 0;
572: first_line number;
573: address_doc xmldom.DOMDocument;
574: geocode_nodes xmlDom.DOMNodeList;
575: geocode_node xmlDom.DOMNode;
576: match_node xmlDom.DOMNode;
577: parser xmlparser.parser;
578: return_string_array utl_http.html_pieces;

Line 575: geocode_node xmlDom.DOMNode;

571: l_failure number := 0;
572: first_line number;
573: address_doc xmldom.DOMDocument;
574: geocode_nodes xmlDom.DOMNodeList;
575: geocode_node xmlDom.DOMNode;
576: match_node xmlDom.DOMNode;
577: parser xmlparser.parser;
578: return_string_array utl_http.html_pieces;
579: max_pieces binary_integer:=16;

Line 576: match_node xmlDom.DOMNode;

572: first_line number;
573: address_doc xmldom.DOMDocument;
574: geocode_nodes xmlDom.DOMNodeList;
575: geocode_node xmlDom.DOMNode;
576: match_node xmlDom.DOMNode;
577: parser xmlparser.parser;
578: return_string_array utl_http.html_pieces;
579: max_pieces binary_integer:=16;
580: --+

Line 622: geocode_nodes := xslprocessor.selectNodes(xmldom.makeNode(address_doc),'/geocode_response/geocode');

618: end loop;
619: xmlparser.parseBuffer(parser,return_string);
620: address_doc := xmlparser.getDocument(parser);
621: BEGIN
622: geocode_nodes := xslprocessor.selectNodes(xmldom.makeNode(address_doc),'/geocode_response/geocode');
623: if xmldom.getLength(geocode_nodes) > 0 then
624: for j in 1 .. xmldom.getLength(geocode_nodes) loop
625: geocode_node := xmldom.item(geocode_nodes,j-1);
626: hr_utility.set_location(xslprocessor.valueOf(geocode_node,'@match_count')||' for line '||j,130);

Line 623: if xmldom.getLength(geocode_nodes) > 0 then

619: xmlparser.parseBuffer(parser,return_string);
620: address_doc := xmlparser.getDocument(parser);
621: BEGIN
622: geocode_nodes := xslprocessor.selectNodes(xmldom.makeNode(address_doc),'/geocode_response/geocode');
623: if xmldom.getLength(geocode_nodes) > 0 then
624: for j in 1 .. xmldom.getLength(geocode_nodes) loop
625: geocode_node := xmldom.item(geocode_nodes,j-1);
626: hr_utility.set_location(xslprocessor.valueOf(geocode_node,'@match_count')||' for line '||j,130);
627: if to_number(xslprocessor.valueOf(geocode_node,'@match_count'))>0 then

Line 624: for j in 1 .. xmldom.getLength(geocode_nodes) loop

620: address_doc := xmlparser.getDocument(parser);
621: BEGIN
622: geocode_nodes := xslprocessor.selectNodes(xmldom.makeNode(address_doc),'/geocode_response/geocode');
623: if xmldom.getLength(geocode_nodes) > 0 then
624: for j in 1 .. xmldom.getLength(geocode_nodes) loop
625: geocode_node := xmldom.item(geocode_nodes,j-1);
626: hr_utility.set_location(xslprocessor.valueOf(geocode_node,'@match_count')||' for line '||j,130);
627: if to_number(xslprocessor.valueOf(geocode_node,'@match_count'))>0 then
628: match_node :=xslprocessor.selectSingleNode(geocode_node,'match');

Line 625: geocode_node := xmldom.item(geocode_nodes,j-1);

621: BEGIN
622: geocode_nodes := xslprocessor.selectNodes(xmldom.makeNode(address_doc),'/geocode_response/geocode');
623: if xmldom.getLength(geocode_nodes) > 0 then
624: for j in 1 .. xmldom.getLength(geocode_nodes) loop
625: geocode_node := xmldom.item(geocode_nodes,j-1);
626: hr_utility.set_location(xslprocessor.valueOf(geocode_node,'@match_count')||' for line '||j,130);
627: if to_number(xslprocessor.valueOf(geocode_node,'@match_count'))>0 then
628: match_node :=xslprocessor.selectSingleNode(geocode_node,'match');
629: longitude(first_line+j) :=xslprocessor.valueOf(match_node,'@longitude');

Line 642: geocode_node := xslprocessor.selectSingleNode(xmldom.makeNode(address_doc),'/component_error');

638: hr_utility.set_location('Geometry not found for address_id :'||address_id(first_line+j) ,150);
639: end if;
640: end loop;
641: else
642: geocode_node := xslprocessor.selectSingleNode(xmldom.makeNode(address_doc),'/component_error');
643: errorMsg := xslprocessor.valueOf(geocode_node,'/component_error');
644: hr_utility.set_location('ERROR thrown from geocode host',155);
645: hr_utility.set_location(substrb(substrb(errorMsg,1,instrb(errorMsg,fnd_global.local_chr(10))-1),1,80),160);
646: end if;

Line 647: xmldom.freeDocument(address_doc);

643: errorMsg := xslprocessor.valueOf(geocode_node,'/component_error');
644: hr_utility.set_location('ERROR thrown from geocode host',155);
645: hr_utility.set_location(substrb(substrb(errorMsg,1,instrb(errorMsg,fnd_global.local_chr(10))-1),1,80),160);
646: end if;
647: xmldom.freeDocument(address_doc);
648: EXCEPTION
649: when OTHERS then
650: xmldom.freeDocument(address_doc);
651: hr_utility.set_location('Unexpected error in elocation response processing',194);

Line 650: xmldom.freeDocument(address_doc);

646: end if;
647: xmldom.freeDocument(address_doc);
648: EXCEPTION
649: when OTHERS then
650: xmldom.freeDocument(address_doc);
651: hr_utility.set_location('Unexpected error in elocation response processing',194);
652: hr_utility.set_location('Unexpected error :'||SQLERRM,195);
653: hr_utility.set_location('Unexpected error :'||SQLCODE,196);
654: END;

Line 733: address_doc xmldom.DOMDocument;

729: AS
730: i number;
731: xml_response VARCHAR2(32767);
732: l_proc varchar2(72) := g_package||'address2full';
733: address_doc xmldom.DOMDocument;
734: geocode_node xmlDom.DOMNode;
735: match_node xmlDom.DOMNode;
736: address_node xmlDom.DOMNode;
737: parser xmlparser.parser;

Line 734: geocode_node xmlDom.DOMNode;

730: i number;
731: xml_response VARCHAR2(32767);
732: l_proc varchar2(72) := g_package||'address2full';
733: address_doc xmldom.DOMDocument;
734: geocode_node xmlDom.DOMNode;
735: match_node xmlDom.DOMNode;
736: address_node xmlDom.DOMNode;
737: parser xmlparser.parser;
738: l_longitude number;

Line 735: match_node xmlDom.DOMNode;

731: xml_response VARCHAR2(32767);
732: l_proc varchar2(72) := g_package||'address2full';
733: address_doc xmldom.DOMDocument;
734: geocode_node xmlDom.DOMNode;
735: match_node xmlDom.DOMNode;
736: address_node xmlDom.DOMNode;
737: parser xmlparser.parser;
738: l_longitude number;
739: l_latitude number;

Line 736: address_node xmlDom.DOMNode;

732: l_proc varchar2(72) := g_package||'address2full';
733: address_doc xmldom.DOMDocument;
734: geocode_node xmlDom.DOMNode;
735: match_node xmlDom.DOMNode;
736: address_node xmlDom.DOMNode;
737: parser xmlparser.parser;
738: l_longitude number;
739: l_latitude number;
740: l_match_count varchar2(255);

Line 764: geocode_node:=xslprocessor.selectSingleNode(xmldom.makeNode(address_doc),'/geocode_response/geocode');

760: parser:=xmlparser.newParser;
761: xmlparser.parseBuffer(parser,xml_response);
762: address_doc:=xmlparser.getDocument(parser);
763: xmlparser.freeParser(parser);
764: geocode_node:=xslprocessor.selectSingleNode(xmldom.makeNode(address_doc),'/geocode_response/geocode');
765: xslprocessor.valueOf(geocode_node,'@match_count',l_match_count);
766: if to_number(xslprocessor.valueOf(geocode_node,'@match_count'))>0 then
767: match_node :=xslprocessor.selectSingleNode(geocode_node,'match');
768: address_node :=xslprocessor.selectSingleNode(match_node,'output_address');

Line 793: xmldom.freeDocument(address_doc);

789: else
790: geometry :=null;
791: end if;
792: end if;
793: xmldom.freeDocument(address_doc);
794: exception
795: when others then
796: xmldom.freeDocument(address_doc);
797: raise;

Line 796: xmldom.freeDocument(address_doc);

792: end if;
793: xmldom.freeDocument(address_doc);
794: exception
795: when others then
796: xmldom.freeDocument(address_doc);
797: raise;
798:
799: end address2full;
800: --