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

Line 501: p_commitNode in xmldom.DOMNode,

497: raise;
498: end delete_transaction_step;
499:
500: Function getAttributeValue(
501: p_commitNode in xmldom.DOMNode,
502: p_tagName in VARCHAR2,
503: p_attributeName in VARCHAR2)
504: return VARCHAR2 IS
505:

Line 507: l_tagName_NodeList xmldom.DOMNodeList;

503: p_attributeName in VARCHAR2)
504: return VARCHAR2 IS
505:
506: x_isNull VARCHAR2(22);
507: l_tagName_NodeList xmldom.DOMNodeList;
508: l_tagName_Node xmldom.DOMNode;
509: l_proc varchar2(72) := g_package || 'getNumberValue';
510:
511: Begin

Line 508: l_tagName_Node xmldom.DOMNode;

504: return VARCHAR2 IS
505:
506: x_isNull VARCHAR2(22);
507: l_tagName_NodeList xmldom.DOMNodeList;
508: l_tagName_Node xmldom.DOMNode;
509: l_proc varchar2(72) := g_package || 'getNumberValue';
510:
511: Begin
512: --1. Navigate to the tagName

Line 515: l_tagName_NodeList := xmldom.getChildrenByTagName(xmldom.makeElement(p_commitNode),p_tagName);

511: Begin
512: --1. Navigate to the tagName
513: x_isNull := null;
514:
515: l_tagName_NodeList := xmldom.getChildrenByTagName(xmldom.makeElement(p_commitNode),p_tagName);
516: if (xmldom.getLength(l_tagName_NodeList) > 0) then
517: --2. See if this tagName has a associated null=true attribute-value pair
518: l_tagName_Node := xmldom.item(l_tagName_NodeList,0);
519: x_isNull := xmldom.getAttribute(xmldom.makeElement(l_tagName_Node), p_attributeName);

Line 516: if (xmldom.getLength(l_tagName_NodeList) > 0) then

512: --1. Navigate to the tagName
513: x_isNull := null;
514:
515: l_tagName_NodeList := xmldom.getChildrenByTagName(xmldom.makeElement(p_commitNode),p_tagName);
516: if (xmldom.getLength(l_tagName_NodeList) > 0) then
517: --2. See if this tagName has a associated null=true attribute-value pair
518: l_tagName_Node := xmldom.item(l_tagName_NodeList,0);
519: x_isNull := xmldom.getAttribute(xmldom.makeElement(l_tagName_Node), p_attributeName);
520: end if;

Line 518: l_tagName_Node := xmldom.item(l_tagName_NodeList,0);

514:
515: l_tagName_NodeList := xmldom.getChildrenByTagName(xmldom.makeElement(p_commitNode),p_tagName);
516: if (xmldom.getLength(l_tagName_NodeList) > 0) then
517: --2. See if this tagName has a associated null=true attribute-value pair
518: l_tagName_Node := xmldom.item(l_tagName_NodeList,0);
519: x_isNull := xmldom.getAttribute(xmldom.makeElement(l_tagName_Node), p_attributeName);
520: end if;
521: return x_isNull;
522: exception

Line 519: x_isNull := xmldom.getAttribute(xmldom.makeElement(l_tagName_Node), p_attributeName);

515: l_tagName_NodeList := xmldom.getChildrenByTagName(xmldom.makeElement(p_commitNode),p_tagName);
516: if (xmldom.getLength(l_tagName_NodeList) > 0) then
517: --2. See if this tagName has a associated null=true attribute-value pair
518: l_tagName_Node := xmldom.item(l_tagName_NodeList,0);
519: x_isNull := xmldom.getAttribute(xmldom.makeElement(l_tagName_Node), p_attributeName);
520: end if;
521: return x_isNull;
522: exception
523: when OTHERS then

Line 531: commitNode in xmldom.DOMNode,

527:
528:
529:
530: Function getDateValue(
531: commitNode in xmldom.DOMNode,
532: attributeName in VARCHAR2,
533: gmisc_value in date default hr_api.g_date)
534: return DATE IS
535: l_date DATE;

Line 538: l_element xmldom.DOMElement;

534: return DATE IS
535: l_date DATE;
536: l_isNull VARCHAR2(10);
537: l_string VARCHAR2(100);
538: l_element xmldom.DOMElement;
539: l_proc varchar2(72) := g_package || 'getDateValue';
540: l_pos number;
541:
542: Begin

Line 551: l_element := xmldom.makeElement(commitNode);

547: if(l_pos <> 0) then
548: l_string := substr(l_string,1,l_pos-1);
549: end if;
550: l_date := TO_DATE(l_string,'RRRR-MM-DD');
551: l_element := xmldom.makeElement(commitNode);
552: --l_isNull := xmldom.getAttribute(l_element, 'null');
553: l_isNull := getAttributeValue (commitNode,attributeName,'null');
554: if l_isNull = 'true' then
555: l_date := NULL;

Line 552: --l_isNull := xmldom.getAttribute(l_element, 'null');

548: l_string := substr(l_string,1,l_pos-1);
549: end if;
550: l_date := TO_DATE(l_string,'RRRR-MM-DD');
551: l_element := xmldom.makeElement(commitNode);
552: --l_isNull := xmldom.getAttribute(l_element, 'null');
553: l_isNull := getAttributeValue (commitNode,attributeName,'null');
554: if l_isNull = 'true' then
555: l_date := NULL;
556: else

Line 564: commitNode in xmldom.DOMNode,

560: return l_date;
561: End getDateValue;
562:
563: Function getVarchar2Value(
564: commitNode in xmldom.DOMNode,
565: attributeName in VARCHAR2,
566: gmisc_value in varchar2 default hr_api.g_varchar2)
567: return varchar2 IS
568: l_varchar2 VARCHAR2(4000);

Line 570: l_element xmldom.DOMElement;

566: gmisc_value in varchar2 default hr_api.g_varchar2)
567: return varchar2 IS
568: l_varchar2 VARCHAR2(4000);
569: l_isNull VARCHAR2(10);
570: l_element xmldom.DOMElement;
571: l_proc varchar2(72) := g_package || 'getVarchar2Value';
572: Begin
573: hr_utility.set_location(' Entering:' || l_proc,10);
574: xslprocessor.valueof(commitNode,attributeName,l_varchar2);

Line 575: l_element := xmldom.makeElement(commitNode);

571: l_proc varchar2(72) := g_package || 'getVarchar2Value';
572: Begin
573: hr_utility.set_location(' Entering:' || l_proc,10);
574: xslprocessor.valueof(commitNode,attributeName,l_varchar2);
575: l_element := xmldom.makeElement(commitNode);
576: -- l_isNull := xmldom.getAttribute(l_element, 'null');
577: l_isNull := getAttributeValue (commitNode,attributeName,'null');
578: if l_isNull = 'true' then
579: l_varchar2 := NULL;

Line 576: -- l_isNull := xmldom.getAttribute(l_element, 'null');

572: Begin
573: hr_utility.set_location(' Entering:' || l_proc,10);
574: xslprocessor.valueof(commitNode,attributeName,l_varchar2);
575: l_element := xmldom.makeElement(commitNode);
576: -- l_isNull := xmldom.getAttribute(l_element, 'null');
577: l_isNull := getAttributeValue (commitNode,attributeName,'null');
578: if l_isNull = 'true' then
579: l_varchar2 := NULL;
580: else

Line 588: commitNode in xmldom.DOMNode,

584: return l_varchar2;
585: End getVarchar2Value;
586:
587: Function getNumberValue(
588: commitNode in xmldom.DOMNode,
589: attributeName in VARCHAR2,
590: gmisc_value in number default hr_api.g_number)
591: return NUMBER IS
592: l_number NUMBER;

Line 594: l_element xmldom.DOMElement;

590: gmisc_value in number default hr_api.g_number)
591: return NUMBER IS
592: l_number NUMBER;
593: l_isNull VARCHAR2(22);
594: l_element xmldom.DOMElement;
595: l_proc varchar2(72) := g_package || 'getNumberValue';
596: Begin
597: hr_utility.set_location(' Entering:' || l_proc,10);
598: --Fix for Bug 7712861

Line 603: l_element := xmldom.makeElement(commitNode);

599: --xslprocessor.valueof(commitNode,attributeName,l_number);
600: if(xslprocessor.valueof(commitNode,attributeName) is not NULL) then
601: l_number := fnd_number.canonical_to_number(xslprocessor.valueof(commitNode,attributeName));
602: end if;
603: l_element := xmldom.makeElement(commitNode);
604: -- l_isNull := xmldom.getAttribute(l_element, 'null');
605: l_isNull := getAttributeValue (commitNode,attributeName,'null');
606: if l_isNull = 'true' then
607: l_number := NULL;

Line 604: -- l_isNull := xmldom.getAttribute(l_element, 'null');

600: if(xslprocessor.valueof(commitNode,attributeName) is not NULL) then
601: l_number := fnd_number.canonical_to_number(xslprocessor.valueof(commitNode,attributeName));
602: end if;
603: l_element := xmldom.makeElement(commitNode);
604: -- l_isNull := xmldom.getAttribute(l_element, 'null');
605: l_isNull := getAttributeValue (commitNode,attributeName,'null');
606: if l_isNull = 'true' then
607: l_number := NULL;
608: else

Line 649: p_root_node in xmldom.DOMNode,

645:
646:
647: Function process_api_internal(
648: p_transaction_id in number,
649: p_root_node in xmldom.DOMNode,
650: p_validate in number default hr_api.g_false_num,
651: p_effective_date in DATE,
652: p_return_status in varchar2)
653: return VARCHAR2 IS

Line 666: l_CEO_Node_Element xmldom.DOMElement;

662: l_procapi_retstat_out VARCHAR2(1);
663: l_EO_Name varchar2(1000);
664: l_sqlbuf varchar2(1000);
665: l_EO_api_name varchar2(100);
666: l_CEO_Node_Element xmldom.DOMElement;
667: l_EORowNode xmldom.DOMNode;
668: l_child_EO_Node xmldom.DOMNode;
669: l_CEO_NodeList xmldom.DOMNodeList;
670: l_child_EO_NodeList xmldom.DOMNodeList;

Line 667: l_EORowNode xmldom.DOMNode;

663: l_EO_Name varchar2(1000);
664: l_sqlbuf varchar2(1000);
665: l_EO_api_name varchar2(100);
666: l_CEO_Node_Element xmldom.DOMElement;
667: l_EORowNode xmldom.DOMNode;
668: l_child_EO_Node xmldom.DOMNode;
669: l_CEO_NodeList xmldom.DOMNodeList;
670: l_child_EO_NodeList xmldom.DOMNodeList;
671: -- l_CLOB CLOB;

Line 668: l_child_EO_Node xmldom.DOMNode;

664: l_sqlbuf varchar2(1000);
665: l_EO_api_name varchar2(100);
666: l_CEO_Node_Element xmldom.DOMElement;
667: l_EORowNode xmldom.DOMNode;
668: l_child_EO_Node xmldom.DOMNode;
669: l_CEO_NodeList xmldom.DOMNodeList;
670: l_child_EO_NodeList xmldom.DOMNodeList;
671: -- l_CLOB CLOB;
672: x_current_status varchar2(1);

Line 669: l_CEO_NodeList xmldom.DOMNodeList;

665: l_EO_api_name varchar2(100);
666: l_CEO_Node_Element xmldom.DOMElement;
667: l_EORowNode xmldom.DOMNode;
668: l_child_EO_Node xmldom.DOMNode;
669: l_CEO_NodeList xmldom.DOMNodeList;
670: l_child_EO_NodeList xmldom.DOMNodeList;
671: -- l_CLOB CLOB;
672: x_current_status varchar2(1);
673: l_proc varchar2(72) := g_package || 'process_api_internal';

Line 670: l_child_EO_NodeList xmldom.DOMNodeList;

666: l_CEO_Node_Element xmldom.DOMElement;
667: l_EORowNode xmldom.DOMNode;
668: l_child_EO_Node xmldom.DOMNode;
669: l_CEO_NodeList xmldom.DOMNodeList;
670: l_child_EO_NodeList xmldom.DOMNodeList;
671: -- l_CLOB CLOB;
672: x_current_status varchar2(1);
673: l_proc varchar2(72) := g_package || 'process_api_internal';
674: l_CDATANode xmldom.DOMNode;

Line 674: l_CDATANode xmldom.DOMNode;

670: l_child_EO_NodeList xmldom.DOMNodeList;
671: -- l_CLOB CLOB;
672: x_current_status varchar2(1);
673: l_proc varchar2(72) := g_package || 'process_api_internal';
674: l_CDATANode xmldom.DOMNode;
675:
676: Begin
677: hr_utility.set_location(' Entering:' || l_proc,10);
678:

Line 680: l_EO_Name := xmldom.getAttribute(xmldom.makeElement(p_root_node),'Name');

676: Begin
677: hr_utility.set_location(' Entering:' || l_proc,10);
678:
679: -- Get the ApiName fromt he EO node
680: l_EO_Name := xmldom.getAttribute(xmldom.makeElement(p_root_node),'Name');
681: --l_EO_api_name := NULL; --g_api_map(l_EO_Name);
682: l_EO_api_name := get_EO_api_name(l_EO_Name);
683: if l_EO_api_name is not NULL then
684: -- From the Root Node Get the EORow Node,which is a sibiling to the CDATA node

Line 685: l_EORowNode := xmldom.getNextSibling(xmldom.getFirstChild(p_root_node));

681: --l_EO_api_name := NULL; --g_api_map(l_EO_Name);
682: l_EO_api_name := get_EO_api_name(l_EO_Name);
683: if l_EO_api_name is not NULL then
684: -- From the Root Node Get the EORow Node,which is a sibiling to the CDATA node
685: l_EORowNode := xmldom.getNextSibling(xmldom.getFirstChild(p_root_node));
686: -- Set the Return Status to the default value
687: l_procapi_retstat_out := 'S';
688: -- Set the return value to the return value got from the calling funtion
689: x_current_status := p_return_status;

Line 694: l_CDATANode := xmldom.getFirstChild(p_root_node);

690:
691: -- set the global g_processing_EO_name for error logging
692: g_processing_EO_name :=l_EO_Name;
693: -- From the Root Node Get the EORow Node,which is a sibiling to the CDATA node
694: l_CDATANode := xmldom.getFirstChild(p_root_node);
695: g_processing_EO_cdatavalue := xmldom.getNodeValue(l_CDATANode);
696:
697: -- Make a CLOB out of the root_node for binding purposes
698: hr_utility.set_location('Making the CLOB:' || l_proc,15);

Line 695: g_processing_EO_cdatavalue := xmldom.getNodeValue(l_CDATANode);

691: -- set the global g_processing_EO_name for error logging
692: g_processing_EO_name :=l_EO_Name;
693: -- From the Root Node Get the EORow Node,which is a sibiling to the CDATA node
694: l_CDATANode := xmldom.getFirstChild(p_root_node);
695: g_processing_EO_cdatavalue := xmldom.getNodeValue(l_CDATANode);
696:
697: -- Make a CLOB out of the root_node for binding purposes
698: hr_utility.set_location('Making the CLOB:' || l_proc,15);
699: DBMS_LOB.createTemporary(g_tempClob, FALSE);

Line 701: xmldom.writeToClob(l_EORowNode,g_tempClob);

697: -- Make a CLOB out of the root_node for binding purposes
698: hr_utility.set_location('Making the CLOB:' || l_proc,15);
699: DBMS_LOB.createTemporary(g_tempClob, FALSE);
700: -- DBMS_LOB.createTemporary(g_tempClob, FALSE);
701: xmldom.writeToClob(l_EORowNode,g_tempClob);
702:
703: hr_utility.set_location('Building the Dynamic Procedure call:' || l_proc,20);
704: -- if l_EO_api_name = 'HR_PROCESS_PERSON_SS.PROCESS_API' or l_EO_api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API' then
705: -- open csr_hat_steps(l_EO_api_name);

Line 732: l_CEO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_EORowNode),'CEO');

728: END IF;
729:
730: hr_utility.set_location(' Convert RowNode into Element:' || l_proc,20);
731: -- Convert RowNode into Element and get the list of Child EO Nodes if any
732: l_CEO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_EORowNode),'CEO');
733:
734: if (xmldom.getLength(l_CEO_NodeList) > 0) then
735: hr_utility.set_location('Child Nodes Exist :' || l_proc,25);
736: l_CEO_Node_Element :=xmldom.makeElement(xmldom.item(l_CEO_NodeList,0));

Line 734: if (xmldom.getLength(l_CEO_NodeList) > 0) then

730: hr_utility.set_location(' Convert RowNode into Element:' || l_proc,20);
731: -- Convert RowNode into Element and get the list of Child EO Nodes if any
732: l_CEO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_EORowNode),'CEO');
733:
734: if (xmldom.getLength(l_CEO_NodeList) > 0) then
735: hr_utility.set_location('Child Nodes Exist :' || l_proc,25);
736: l_CEO_Node_Element :=xmldom.makeElement(xmldom.item(l_CEO_NodeList,0));
737: l_child_EO_NodeList :=xmldom.getChildrenByTagName(l_CEO_Node_Element,'EO');
738:

Line 736: l_CEO_Node_Element :=xmldom.makeElement(xmldom.item(l_CEO_NodeList,0));

732: l_CEO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_EORowNode),'CEO');
733:
734: if (xmldom.getLength(l_CEO_NodeList) > 0) then
735: hr_utility.set_location('Child Nodes Exist :' || l_proc,25);
736: l_CEO_Node_Element :=xmldom.makeElement(xmldom.item(l_CEO_NodeList,0));
737: l_child_EO_NodeList :=xmldom.getChildrenByTagName(l_CEO_Node_Element,'EO');
738:
739: hr_utility.set_location('Entering For Loop for Child Nodes :' || l_proc,30);
740: for i in 1..xmldom.getLength(l_child_EO_NodeList) loop

Line 737: l_child_EO_NodeList :=xmldom.getChildrenByTagName(l_CEO_Node_Element,'EO');

733:
734: if (xmldom.getLength(l_CEO_NodeList) > 0) then
735: hr_utility.set_location('Child Nodes Exist :' || l_proc,25);
736: l_CEO_Node_Element :=xmldom.makeElement(xmldom.item(l_CEO_NodeList,0));
737: l_child_EO_NodeList :=xmldom.getChildrenByTagName(l_CEO_Node_Element,'EO');
738:
739: hr_utility.set_location('Entering For Loop for Child Nodes :' || l_proc,30);
740: for i in 1..xmldom.getLength(l_child_EO_NodeList) loop
741: l_child_EO_Node := xmldom.item(l_child_EO_NodeList,i-1);

Line 740: for i in 1..xmldom.getLength(l_child_EO_NodeList) loop

736: l_CEO_Node_Element :=xmldom.makeElement(xmldom.item(l_CEO_NodeList,0));
737: l_child_EO_NodeList :=xmldom.getChildrenByTagName(l_CEO_Node_Element,'EO');
738:
739: hr_utility.set_location('Entering For Loop for Child Nodes :' || l_proc,30);
740: for i in 1..xmldom.getLength(l_child_EO_NodeList) loop
741: l_child_EO_Node := xmldom.item(l_child_EO_NodeList,i-1);
742: x_current_status:=process_api_internal(p_transaction_id, l_child_EO_Node,p_validate,p_effective_date,x_current_status);
743: end loop;
744: hr_utility.set_location('End of For Loop :' || l_proc,35);

Line 741: l_child_EO_Node := xmldom.item(l_child_EO_NodeList,i-1);

737: l_child_EO_NodeList :=xmldom.getChildrenByTagName(l_CEO_Node_Element,'EO');
738:
739: hr_utility.set_location('Entering For Loop for Child Nodes :' || l_proc,30);
740: for i in 1..xmldom.getLength(l_child_EO_NodeList) loop
741: l_child_EO_Node := xmldom.item(l_child_EO_NodeList,i-1);
742: x_current_status:=process_api_internal(p_transaction_id, l_child_EO_Node,p_validate,p_effective_date,x_current_status);
743: end loop;
744: hr_utility.set_location('End of For Loop :' || l_proc,35);
745: end if;

Line 756: p_root_node in xmldom.DOMNode,

752:
753: Function process_api_call(
754: p_transaction_step_id in NUMBER,
755: p_api_name in VARCHAR2,
756: p_root_node in xmldom.DOMNode,
757: p_validate in number default hr_api.g_false_num,
758: p_effective_date in DATE,
759: p_return_status in varchar2)
760: return VARCHAR2 IS

Line 764: l_EORowNode xmldom.DOMNode;

760: return VARCHAR2 IS
761: l_procapi_retstat_out VARCHAR2(1);
762: l_sqlbuf varchar2(1000);
763: l_EO_api_name varchar2(100);
764: l_EORowNode xmldom.DOMNode;
765: -- l_CLOB CLOB;
766: x_current_status varchar2(1);
767: l_proc varchar2(72) := g_package || 'process_api_call';
768:

Line 774: if(xmlDOM.isNull(p_root_node)=false) then

770: hr_utility.set_location(' Entering:' || l_proc,10);
771:
772: -- Get the ApiName from the parameter
773: l_EO_api_name := p_api_name;
774: if(xmlDOM.isNull(p_root_node)=false) then
775: -- From the Root Node Get the EORow Node,which is a sibiling to the CDATA node
776: l_EORowNode := xmldom.getNextSibling(xmldom.getFirstChild(p_root_node));
777: end if;
778: -- Set the Return Status to the default value

Line 776: l_EORowNode := xmldom.getNextSibling(xmldom.getFirstChild(p_root_node));

772: -- Get the ApiName from the parameter
773: l_EO_api_name := p_api_name;
774: if(xmlDOM.isNull(p_root_node)=false) then
775: -- From the Root Node Get the EORow Node,which is a sibiling to the CDATA node
776: l_EORowNode := xmldom.getNextSibling(xmldom.getFirstChild(p_root_node));
777: end if;
778: -- Set the Return Status to the default value
779: l_procapi_retstat_out := 'N';
780: -- Set the return value to the return value got from the calling funtion

Line 785: if(xmlDOM.isNull(l_EORowNode)=false) then

781: x_current_status := p_return_status;
782:
783:
784: -- Make a CLOB out of the root_node for binding purposes
785: if(xmlDOM.isNull(l_EORowNode)=false) then
786: hr_utility.set_location('Making the CLOB:' || l_proc,15);
787: DBMS_LOB.createTemporary(g_tempClob, FALSE);
788: xmldom.writeToClob(l_EORowNode,g_tempClob);
789: end if;

Line 788: xmldom.writeToClob(l_EORowNode,g_tempClob);

784: -- Make a CLOB out of the root_node for binding purposes
785: if(xmlDOM.isNull(l_EORowNode)=false) then
786: hr_utility.set_location('Making the CLOB:' || l_proc,15);
787: DBMS_LOB.createTemporary(g_tempClob, FALSE);
788: xmldom.writeToClob(l_EORowNode,g_tempClob);
789: end if;
790:
791:
792: hr_utility.set_location('Building the Dynamic Procedure call:' || l_proc,20);

Line 793: if (xmldom.isNull(p_root_node)=false) then

789: end if;
790:
791:
792: hr_utility.set_location('Building the Dynamic Procedure call:' || l_proc,20);
793: if (xmldom.isNull(p_root_node)=false) then
794: l_sqlbuf:= 'begin ' || l_EO_api_name ||
795: '(p_transaction_step_id => :1
796: ,p_document => :2
797: ,p_return_status => :3

Line 1193: return xmldom.DOMElement is

1189: end delete_transaction;
1190:
1191: function convertCLOBtoXMLElement(
1192: p_document in CLOB)
1193: return xmldom.DOMElement is
1194: x_commitElement xmldom.DOMElement;
1195: l_parser xmlparser.Parser;
1196: l_proc varchar2(72) := g_package || 'convertCLOBtoXMLElement';
1197: Begin

Line 1194: x_commitElement xmldom.DOMElement;

1190:
1191: function convertCLOBtoXMLElement(
1192: p_document in CLOB)
1193: return xmldom.DOMElement is
1194: x_commitElement xmldom.DOMElement;
1195: l_parser xmlparser.Parser;
1196: l_proc varchar2(72) := g_package || 'convertCLOBtoXMLElement';
1197: Begin
1198: hr_utility.set_location(' Entering:' || l_proc,10);

Line 1199: hr_utility.set_location(' CLOB --> xmldom.DOMElement:' || l_proc,15);

1195: l_parser xmlparser.Parser;
1196: l_proc varchar2(72) := g_package || 'convertCLOBtoXMLElement';
1197: Begin
1198: hr_utility.set_location(' Entering:' || l_proc,10);
1199: hr_utility.set_location(' CLOB --> xmldom.DOMElement:' || l_proc,15);
1200: -- CLOB --> xmldom.DOMElement
1201: l_parser := xmlparser.newParser;
1202: xmlparser.ParseCLOB(l_parser,p_document);
1203: x_commitElement := xmldom.getDocumentElement(xmlparser.getDocument(l_parser));

Line 1200: -- CLOB --> xmldom.DOMElement

1196: l_proc varchar2(72) := g_package || 'convertCLOBtoXMLElement';
1197: Begin
1198: hr_utility.set_location(' Entering:' || l_proc,10);
1199: hr_utility.set_location(' CLOB --> xmldom.DOMElement:' || l_proc,15);
1200: -- CLOB --> xmldom.DOMElement
1201: l_parser := xmlparser.newParser;
1202: xmlparser.ParseCLOB(l_parser,p_document);
1203: x_commitElement := xmldom.getDocumentElement(xmlparser.getDocument(l_parser));
1204: return x_commitElement;

Line 1203: x_commitElement := xmldom.getDocumentElement(xmlparser.getDocument(l_parser));

1199: hr_utility.set_location(' CLOB --> xmldom.DOMElement:' || l_proc,15);
1200: -- CLOB --> xmldom.DOMElement
1201: l_parser := xmlparser.newParser;
1202: xmlparser.ParseCLOB(l_parser,p_document);
1203: x_commitElement := xmldom.getDocumentElement(xmlparser.getDocument(l_parser));
1204: return x_commitElement;
1205: end convertCLOBtoXMLElement;
1206:
1207: procedure setTransactionStatus(

Line 2583: PROCEDURE createEOErrorMSgNode(doc IN OUT nocopy xmldom.DOMDocument,root_node IN OUT nocopy xmldom.DOMNode,itemtype in varchar2

2579: p_status := 'E';
2580:
2581: end setTransactionStatus;
2582:
2583: PROCEDURE createEOErrorMSgNode(doc IN OUT nocopy xmldom.DOMDocument,root_node IN OUT nocopy xmldom.DOMNode,itemtype in varchar2
2584: ,itemkey in varchar2)
2585: AS
2586: EO_node xmldom.DOMNode;
2587: message_node xmldom.DOMNode;

Line 2586: EO_node xmldom.DOMNode;

2582:
2583: PROCEDURE createEOErrorMSgNode(doc IN OUT nocopy xmldom.DOMDocument,root_node IN OUT nocopy xmldom.DOMNode,itemtype in varchar2
2584: ,itemkey in varchar2)
2585: AS
2586: EO_node xmldom.DOMNode;
2587: message_node xmldom.DOMNode;
2588: item_node xmldom.DOMNode;
2589: msg_count_elmt xmldom.DOMElement;
2590: item_elmt xmldom.DOMElement;

Line 2587: message_node xmldom.DOMNode;

2583: PROCEDURE createEOErrorMSgNode(doc IN OUT nocopy xmldom.DOMDocument,root_node IN OUT nocopy xmldom.DOMNode,itemtype in varchar2
2584: ,itemkey in varchar2)
2585: AS
2586: EO_node xmldom.DOMNode;
2587: message_node xmldom.DOMNode;
2588: item_node xmldom.DOMNode;
2589: msg_count_elmt xmldom.DOMElement;
2590: item_elmt xmldom.DOMElement;
2591: item_text xmldom.DOMText;

Line 2588: item_node xmldom.DOMNode;

2584: ,itemkey in varchar2)
2585: AS
2586: EO_node xmldom.DOMNode;
2587: message_node xmldom.DOMNode;
2588: item_node xmldom.DOMNode;
2589: msg_count_elmt xmldom.DOMElement;
2590: item_elmt xmldom.DOMElement;
2591: item_text xmldom.DOMText;
2592: msg_count NUMBER;

Line 2589: msg_count_elmt xmldom.DOMElement;

2585: AS
2586: EO_node xmldom.DOMNode;
2587: message_node xmldom.DOMNode;
2588: item_node xmldom.DOMNode;
2589: msg_count_elmt xmldom.DOMElement;
2590: item_elmt xmldom.DOMElement;
2591: item_text xmldom.DOMText;
2592: msg_count NUMBER;
2593: msg_details VARCHAR2(2000);

Line 2590: item_elmt xmldom.DOMElement;

2586: EO_node xmldom.DOMNode;
2587: message_node xmldom.DOMNode;
2588: item_node xmldom.DOMNode;
2589: msg_count_elmt xmldom.DOMElement;
2590: item_elmt xmldom.DOMElement;
2591: item_text xmldom.DOMText;
2592: msg_count NUMBER;
2593: msg_details VARCHAR2(2000);
2594: p_data VARCHAR2(4000);

Line 2591: item_text xmldom.DOMText;

2587: message_node xmldom.DOMNode;
2588: item_node xmldom.DOMNode;
2589: msg_count_elmt xmldom.DOMElement;
2590: item_elmt xmldom.DOMElement;
2591: item_text xmldom.DOMText;
2592: msg_count NUMBER;
2593: msg_details VARCHAR2(2000);
2594: p_data VARCHAR2(4000);
2595: p_msg_index_out NUMBER;

Line 2602: msg_count_elmt :=xmldom.createElement(doc, 'MsgCount');

2598: hr_utility.set_location('Entering createEOErrorMSgNode : ', 10);
2599: msg_count := fnd_msg_pub.Count_Msg;
2600: p_data := null;
2601:
2602: msg_count_elmt :=xmldom.createElement(doc, 'MsgCount');
2603: xmldom.setAttribute(
2604: msg_count_elmt
2605: , 'Value'
2606: , msg_count

Line 2603: xmldom.setAttribute(

2599: msg_count := fnd_msg_pub.Count_Msg;
2600: p_data := null;
2601:
2602: msg_count_elmt :=xmldom.createElement(doc, 'MsgCount');
2603: xmldom.setAttribute(
2604: msg_count_elmt
2605: , 'Value'
2606: , msg_count
2607: );

Line 2609: EO_node := xmldom.appendChild(root_node,xmldom.makeNode(msg_count_elmt));

2605: , 'Value'
2606: , msg_count
2607: );
2608:
2609: EO_node := xmldom.appendChild(root_node,xmldom.makeNode(msg_count_elmt));
2610:
2611: FOR i IN 1 .. msg_count LOOP
2612: item_elmt := xmldom.createElement(
2613: doc

Line 2612: item_elmt := xmldom.createElement(

2608:
2609: EO_node := xmldom.appendChild(root_node,xmldom.makeNode(msg_count_elmt));
2610:
2611: FOR i IN 1 .. msg_count LOOP
2612: item_elmt := xmldom.createElement(
2613: doc
2614: , 'Msg'
2615: );
2616:

Line 2617: message_node := xmldom.appendChild(

2613: doc
2614: , 'Msg'
2615: );
2616:
2617: message_node := xmldom.appendChild(
2618: EO_node
2619: , xmldom.makeNode(item_elmt)
2620: );
2621: --

Line 2619: , xmldom.makeNode(item_elmt)

2615: );
2616:
2617: message_node := xmldom.appendChild(
2618: EO_node
2619: , xmldom.makeNode(item_elmt)
2620: );
2621: --
2622: item_elmt := xmldom.createElement(
2623: doc

Line 2622: item_elmt := xmldom.createElement(

2618: EO_node
2619: , xmldom.makeNode(item_elmt)
2620: );
2621: --
2622: item_elmt := xmldom.createElement(
2623: doc
2624: , 'EncodedMessage'
2625: );
2626: item_node := xmldom.appendChild(

Line 2626: item_node := xmldom.appendChild(

2622: item_elmt := xmldom.createElement(
2623: doc
2624: , 'EncodedMessage'
2625: );
2626: item_node := xmldom.appendChild(
2627: message_node
2628: , xmldom.makeNode(item_elmt)
2629: );
2630: -- get the actual message from fnd_msg_pub

Line 2628: , xmldom.makeNode(item_elmt)

2624: , 'EncodedMessage'
2625: );
2626: item_node := xmldom.appendChild(
2627: message_node
2628: , xmldom.makeNode(item_elmt)
2629: );
2630: -- get the actual message from fnd_msg_pub
2631: msg_details :=fnd_msg_pub.Get_Detail(p_msg_index=>i,p_encoded=>'F');
2632: p_data := p_data || ' %%%% ' || msg_details;

Line 2634: item_text := xmldom.createTextNode(

2630: -- get the actual message from fnd_msg_pub
2631: msg_details :=fnd_msg_pub.Get_Detail(p_msg_index=>i,p_encoded=>'F');
2632: p_data := p_data || ' %%%% ' || msg_details;
2633: hr_utility.set_location('EO Error : ' || msg_details, 20);
2634: item_text := xmldom.createTextNode(
2635: doc
2636: , msg_details
2637: );
2638: item_node := xmldom.appendChild(

Line 2638: item_node := xmldom.appendChild(

2634: item_text := xmldom.createTextNode(
2635: doc
2636: , msg_details
2637: );
2638: item_node := xmldom.appendChild(
2639: item_node
2640: , xmldom.makeNode(item_text)
2641: );
2642: --

Line 2640: , xmldom.makeNode(item_text)

2636: , msg_details
2637: );
2638: item_node := xmldom.appendChild(
2639: item_node
2640: , xmldom.makeNode(item_text)
2641: );
2642: --
2643: END LOOP;
2644:

Line 2660: procedure writeXMLDocToClob(p_error_doc in xmldom.DOMDocument,

2656: end if;
2657: hr_utility.set_location('Leaving createEOErrorMSgNode : ', 30);
2658: END ;
2659:
2660: procedure writeXMLDocToClob(p_error_doc in xmldom.DOMDocument,
2661: p_error_log IN OUT nocopy CLOB)
2662: as
2663: error_log CLOB;
2664: charset VARCHAR2(64);

Line 2666: IF(NOT xmldom.isnull(p_error_doc)) THEN

2662: as
2663: error_log CLOB;
2664: charset VARCHAR2(64);
2665: begin
2666: IF(NOT xmldom.isnull(p_error_doc)) THEN
2667: SELECT v$nls_parameters.value INTO charset FROM v$nls_parameters
2668: WHERE v$nls_parameters.parameter='NLS_CHARACTERSET';
2669: DBMS_LOB.createTemporary(error_log, FALSE);
2670: xmldom.writeToClob(p_error_doc,error_log,charset);

Line 2670: xmldom.writeToClob(p_error_doc,error_log,charset);

2666: IF(NOT xmldom.isnull(p_error_doc)) THEN
2667: SELECT v$nls_parameters.value INTO charset FROM v$nls_parameters
2668: WHERE v$nls_parameters.parameter='NLS_CHARACTERSET';
2669: DBMS_LOB.createTemporary(error_log, FALSE);
2670: xmldom.writeToClob(p_error_doc,error_log,charset);
2671: p_error_log:=error_log;
2672: DBMS_LOB.freetemporary(error_log);
2673: xmldom.freeDocument(p_error_doc);
2674: END IF;

Line 2673: xmldom.freeDocument(p_error_doc);

2669: DBMS_LOB.createTemporary(error_log, FALSE);
2670: xmldom.writeToClob(p_error_doc,error_log,charset);
2671: p_error_log:=error_log;
2672: DBMS_LOB.freetemporary(error_log);
2673: xmldom.freeDocument(p_error_doc);
2674: END IF;
2675: end;
2676:
2677: PROCEDURE commit_transaction(

Line 2693: rootNode xmldom.DOMNode;

2689: CURSOR csr_trn_item IS
2690: SELECT item_type,item_key
2691: FROM hr_api_transactions
2692: WHERE transaction_id = p_transaction_id;
2693: rootNode xmldom.DOMNode;
2694: l_TXN_Node xmldom.DOMNode;
2695: l_AM_Node xmldom.DOMNode;
2696: l_TransCache_Node xmldom.DOMNode;
2697: l_EO_Node xmldom.DOMNode;

Line 2694: l_TXN_Node xmldom.DOMNode;

2690: SELECT item_type,item_key
2691: FROM hr_api_transactions
2692: WHERE transaction_id = p_transaction_id;
2693: rootNode xmldom.DOMNode;
2694: l_TXN_Node xmldom.DOMNode;
2695: l_AM_Node xmldom.DOMNode;
2696: l_TransCache_Node xmldom.DOMNode;
2697: l_EO_Node xmldom.DOMNode;
2698: l_CDATA_Node xmldom.DOMNode;

Line 2695: l_AM_Node xmldom.DOMNode;

2691: FROM hr_api_transactions
2692: WHERE transaction_id = p_transaction_id;
2693: rootNode xmldom.DOMNode;
2694: l_TXN_Node xmldom.DOMNode;
2695: l_AM_Node xmldom.DOMNode;
2696: l_TransCache_Node xmldom.DOMNode;
2697: l_EO_Node xmldom.DOMNode;
2698: l_CDATA_Node xmldom.DOMNode;
2699: l_EoApiMap_Node xmldom.DOMNode;

Line 2696: l_TransCache_Node xmldom.DOMNode;

2692: WHERE transaction_id = p_transaction_id;
2693: rootNode xmldom.DOMNode;
2694: l_TXN_Node xmldom.DOMNode;
2695: l_AM_Node xmldom.DOMNode;
2696: l_TransCache_Node xmldom.DOMNode;
2697: l_EO_Node xmldom.DOMNode;
2698: l_CDATA_Node xmldom.DOMNode;
2699: l_EoApiMap_Node xmldom.DOMNode;
2700:

Line 2697: l_EO_Node xmldom.DOMNode;

2693: rootNode xmldom.DOMNode;
2694: l_TXN_Node xmldom.DOMNode;
2695: l_AM_Node xmldom.DOMNode;
2696: l_TransCache_Node xmldom.DOMNode;
2697: l_EO_Node xmldom.DOMNode;
2698: l_CDATA_Node xmldom.DOMNode;
2699: l_EoApiMap_Node xmldom.DOMNode;
2700:
2701:

Line 2698: l_CDATA_Node xmldom.DOMNode;

2694: l_TXN_Node xmldom.DOMNode;
2695: l_AM_Node xmldom.DOMNode;
2696: l_TransCache_Node xmldom.DOMNode;
2697: l_EO_Node xmldom.DOMNode;
2698: l_CDATA_Node xmldom.DOMNode;
2699: l_EoApiMap_Node xmldom.DOMNode;
2700:
2701:
2702: l_EoApiMap_NodeList xmldom.DOMNodeList;

Line 2699: l_EoApiMap_Node xmldom.DOMNode;

2695: l_AM_Node xmldom.DOMNode;
2696: l_TransCache_Node xmldom.DOMNode;
2697: l_EO_Node xmldom.DOMNode;
2698: l_CDATA_Node xmldom.DOMNode;
2699: l_EoApiMap_Node xmldom.DOMNode;
2700:
2701:
2702: l_EoApiMap_NodeList xmldom.DOMNodeList;
2703: l_EO_NodeList xmldom.DOMNodeList;

Line 2702: l_EoApiMap_NodeList xmldom.DOMNodeList;

2698: l_CDATA_Node xmldom.DOMNode;
2699: l_EoApiMap_Node xmldom.DOMNode;
2700:
2701:
2702: l_EoApiMap_NodeList xmldom.DOMNodeList;
2703: l_EO_NodeList xmldom.DOMNodeList;
2704: l_TransCache_NodeList xmldom.DOMNodeList;
2705:
2706: l_proc VARCHAR2(72) := g_package || 'commit_transaction';

Line 2703: l_EO_NodeList xmldom.DOMNodeList;

2699: l_EoApiMap_Node xmldom.DOMNode;
2700:
2701:
2702: l_EoApiMap_NodeList xmldom.DOMNodeList;
2703: l_EO_NodeList xmldom.DOMNodeList;
2704: l_TransCache_NodeList xmldom.DOMNodeList;
2705:
2706: l_proc VARCHAR2(72) := g_package || 'commit_transaction';
2707: x_return_status VARCHAR2(1);

Line 2704: l_TransCache_NodeList xmldom.DOMNodeList;

2700:
2701:
2702: l_EoApiMap_NodeList xmldom.DOMNodeList;
2703: l_EO_NodeList xmldom.DOMNodeList;
2704: l_TransCache_NodeList xmldom.DOMNodeList;
2705:
2706: l_proc VARCHAR2(72) := g_package || 'commit_transaction';
2707: x_return_status VARCHAR2(1);
2708: l_pwac_return_status VARCHAR2(1);

Line 2721: error_doc xmldom.DOMDocument;

2717: step_row csr_trn%ROWTYPE;
2718: item_row csr_trn_item%ROWTYPE;
2719:
2720: -- error logging
2721: error_doc xmldom.DOMDocument;
2722: error_doc_main_node xmldom.DOMNode;
2723: error_doc_root_elmt xmldom.DOMElement;
2724: error_EO_Node xmldom.DOMNode;
2725: error_temp_Node xmldom.DOMNode;

Line 2722: error_doc_main_node xmldom.DOMNode;

2718: item_row csr_trn_item%ROWTYPE;
2719:
2720: -- error logging
2721: error_doc xmldom.DOMDocument;
2722: error_doc_main_node xmldom.DOMNode;
2723: error_doc_root_elmt xmldom.DOMElement;
2724: error_EO_Node xmldom.DOMNode;
2725: error_temp_Node xmldom.DOMNode;
2726: error_EO_elmt xmldom.DOMElement;

Line 2723: error_doc_root_elmt xmldom.DOMElement;

2719:
2720: -- error logging
2721: error_doc xmldom.DOMDocument;
2722: error_doc_main_node xmldom.DOMNode;
2723: error_doc_root_elmt xmldom.DOMElement;
2724: error_EO_Node xmldom.DOMNode;
2725: error_temp_Node xmldom.DOMNode;
2726: error_EO_elmt xmldom.DOMElement;
2727: charset VARCHAR2(64);

Line 2724: error_EO_Node xmldom.DOMNode;

2720: -- error logging
2721: error_doc xmldom.DOMDocument;
2722: error_doc_main_node xmldom.DOMNode;
2723: error_doc_root_elmt xmldom.DOMElement;
2724: error_EO_Node xmldom.DOMNode;
2725: error_temp_Node xmldom.DOMNode;
2726: error_EO_elmt xmldom.DOMElement;
2727: charset VARCHAR2(64);
2728: error_log CLOB;

Line 2725: error_temp_Node xmldom.DOMNode;

2721: error_doc xmldom.DOMDocument;
2722: error_doc_main_node xmldom.DOMNode;
2723: error_doc_root_elmt xmldom.DOMElement;
2724: error_EO_Node xmldom.DOMNode;
2725: error_temp_Node xmldom.DOMNode;
2726: error_EO_elmt xmldom.DOMElement;
2727: charset VARCHAR2(64);
2728: error_log CLOB;
2729:

Line 2726: error_EO_elmt xmldom.DOMElement;

2722: error_doc_main_node xmldom.DOMNode;
2723: error_doc_root_elmt xmldom.DOMElement;
2724: error_EO_Node xmldom.DOMNode;
2725: error_temp_Node xmldom.DOMNode;
2726: error_EO_elmt xmldom.DOMElement;
2727: charset VARCHAR2(64);
2728: error_log CLOB;
2729:
2730: BEGIN

Line 2758: rootNode := xmldom.makeNode(convertCLOBtoXMLElement(step_row.transaction_document));

2754: -- hsundar: Do the Document processing only when the Txn_document is not null
2755: -- hsundar: If the Document is NULL just return the status as S
2756: IF step_row.transaction_document IS NOT NULL THEN
2757: -- Now get the Node
2758: rootNode := xmldom.makeNode(convertCLOBtoXMLElement(step_row.transaction_document));
2759:
2760: -- Now get the
2761: l_EoApiMap_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'EoApiMap');
2762: IF (xmldom.getLength(l_EoApiMap_NodeList) > 0) THEN

Line 2761: l_EoApiMap_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'EoApiMap');

2757: -- Now get the Node
2758: rootNode := xmldom.makeNode(convertCLOBtoXMLElement(step_row.transaction_document));
2759:
2760: -- Now get the
2761: l_EoApiMap_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'EoApiMap');
2762: IF (xmldom.getLength(l_EoApiMap_NodeList) > 0) THEN
2763: l_EoApiMap_Node :=xmldom.item(l_EoApiMap_NodeList,0);
2764: l_EO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_EoApiMap_Node),'EO');
2765:

Line 2762: IF (xmldom.getLength(l_EoApiMap_NodeList) > 0) THEN

2758: rootNode := xmldom.makeNode(convertCLOBtoXMLElement(step_row.transaction_document));
2759:
2760: -- Now get the
2761: l_EoApiMap_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'EoApiMap');
2762: IF (xmldom.getLength(l_EoApiMap_NodeList) > 0) THEN
2763: l_EoApiMap_Node :=xmldom.item(l_EoApiMap_NodeList,0);
2764: l_EO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_EoApiMap_Node),'EO');
2765:
2766: -- Put it into a Table

Line 2763: l_EoApiMap_Node :=xmldom.item(l_EoApiMap_NodeList,0);

2759:
2760: -- Now get the
2761: l_EoApiMap_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'EoApiMap');
2762: IF (xmldom.getLength(l_EoApiMap_NodeList) > 0) THEN
2763: l_EoApiMap_Node :=xmldom.item(l_EoApiMap_NodeList,0);
2764: l_EO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_EoApiMap_Node),'EO');
2765:
2766: -- Put it into a Table
2767: FOR i IN 1..xmldom.getLength(l_EO_NodeList) LOOP

Line 2764: l_EO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_EoApiMap_Node),'EO');

2760: -- Now get the
2761: l_EoApiMap_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'EoApiMap');
2762: IF (xmldom.getLength(l_EoApiMap_NodeList) > 0) THEN
2763: l_EoApiMap_Node :=xmldom.item(l_EoApiMap_NodeList,0);
2764: l_EO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_EoApiMap_Node),'EO');
2765:
2766: -- Put it into a Table
2767: FOR i IN 1..xmldom.getLength(l_EO_NodeList) LOOP
2768: l_EO_Node := xmldom.item(l_EO_NodeList,i-1);

Line 2767: FOR i IN 1..xmldom.getLength(l_EO_NodeList) LOOP

2763: l_EoApiMap_Node :=xmldom.item(l_EoApiMap_NodeList,0);
2764: l_EO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_EoApiMap_Node),'EO');
2765:
2766: -- Put it into a Table
2767: FOR i IN 1..xmldom.getLength(l_EO_NodeList) LOOP
2768: l_EO_Node := xmldom.item(l_EO_NodeList,i-1);
2769: l_EO_Object_Name := xmldom.getAttribute(xmldom.makeElement(l_EO_Node),'Name');
2770: l_EO_Node := xmldom.getFirstChild(l_EO_Node);
2771: l_EO_Api_Name :=xmldom.getNodeValue(l_EO_Node);

Line 2768: l_EO_Node := xmldom.item(l_EO_NodeList,i-1);

2764: l_EO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_EoApiMap_Node),'EO');
2765:
2766: -- Put it into a Table
2767: FOR i IN 1..xmldom.getLength(l_EO_NodeList) LOOP
2768: l_EO_Node := xmldom.item(l_EO_NodeList,i-1);
2769: l_EO_Object_Name := xmldom.getAttribute(xmldom.makeElement(l_EO_Node),'Name');
2770: l_EO_Node := xmldom.getFirstChild(l_EO_Node);
2771: l_EO_Api_Name :=xmldom.getNodeValue(l_EO_Node);
2772: --g_api_map(l_EO_Object_Name) := l_EO_Api_Name;

Line 2769: l_EO_Object_Name := xmldom.getAttribute(xmldom.makeElement(l_EO_Node),'Name');

2765:
2766: -- Put it into a Table
2767: FOR i IN 1..xmldom.getLength(l_EO_NodeList) LOOP
2768: l_EO_Node := xmldom.item(l_EO_NodeList,i-1);
2769: l_EO_Object_Name := xmldom.getAttribute(xmldom.makeElement(l_EO_Node),'Name');
2770: l_EO_Node := xmldom.getFirstChild(l_EO_Node);
2771: l_EO_Api_Name :=xmldom.getNodeValue(l_EO_Node);
2772: --g_api_map(l_EO_Object_Name) := l_EO_Api_Name;
2773: -- Maintain Parallel Arrays

Line 2770: l_EO_Node := xmldom.getFirstChild(l_EO_Node);

2766: -- Put it into a Table
2767: FOR i IN 1..xmldom.getLength(l_EO_NodeList) LOOP
2768: l_EO_Node := xmldom.item(l_EO_NodeList,i-1);
2769: l_EO_Object_Name := xmldom.getAttribute(xmldom.makeElement(l_EO_Node),'Name');
2770: l_EO_Node := xmldom.getFirstChild(l_EO_Node);
2771: l_EO_Api_Name :=xmldom.getNodeValue(l_EO_Node);
2772: --g_api_map(l_EO_Object_Name) := l_EO_Api_Name;
2773: -- Maintain Parallel Arrays
2774: -- 1. Put the EO Name in g_EO_Name_map

Line 2771: l_EO_Api_Name :=xmldom.getNodeValue(l_EO_Node);

2767: FOR i IN 1..xmldom.getLength(l_EO_NodeList) LOOP
2768: l_EO_Node := xmldom.item(l_EO_NodeList,i-1);
2769: l_EO_Object_Name := xmldom.getAttribute(xmldom.makeElement(l_EO_Node),'Name');
2770: l_EO_Node := xmldom.getFirstChild(l_EO_Node);
2771: l_EO_Api_Name :=xmldom.getNodeValue(l_EO_Node);
2772: --g_api_map(l_EO_Object_Name) := l_EO_Api_Name;
2773: -- Maintain Parallel Arrays
2774: -- 1. Put the EO Name in g_EO_Name_map
2775: g_EO_Name_map(i) := l_EO_Object_Name;

Line 2782: l_TransCache_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'TransCache');

2778: END LOOP;
2779:
2780:
2781: -- Now get the Node
2782: l_TransCache_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'TransCache');
2783: l_TransCache_Node :=xmldom.item(l_TransCache_NodeList,0);
2784: -- Now get the Node
2785: l_AM_Node :=xmldom.getFirstChild(l_TransCache_Node);
2786: -- Now get the Node and get its Sibling -->

Line 2783: l_TransCache_Node :=xmldom.item(l_TransCache_NodeList,0);

2779:
2780:
2781: -- Now get the Node
2782: l_TransCache_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'TransCache');
2783: l_TransCache_Node :=xmldom.item(l_TransCache_NodeList,0);
2784: -- Now get the Node
2785: l_AM_Node :=xmldom.getFirstChild(l_TransCache_Node);
2786: -- Now get the Node and get its Sibling -->
2787: l_TXN_Node :=xmldom.getNextSibling(xmldom.getFirstChild(l_AM_Node));

Line 2785: l_AM_Node :=xmldom.getFirstChild(l_TransCache_Node);

2781: -- Now get the Node
2782: l_TransCache_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(rootNode),'TransCache');
2783: l_TransCache_Node :=xmldom.item(l_TransCache_NodeList,0);
2784: -- Now get the Node
2785: l_AM_Node :=xmldom.getFirstChild(l_TransCache_Node);
2786: -- Now get the Node and get its Sibling -->
2787: l_TXN_Node :=xmldom.getNextSibling(xmldom.getFirstChild(l_AM_Node));
2788:
2789: -- Now get the list of all Nodes

Line 2787: l_TXN_Node :=xmldom.getNextSibling(xmldom.getFirstChild(l_AM_Node));

2783: l_TransCache_Node :=xmldom.item(l_TransCache_NodeList,0);
2784: -- Now get the Node
2785: l_AM_Node :=xmldom.getFirstChild(l_TransCache_Node);
2786: -- Now get the Node and get its Sibling -->
2787: l_TXN_Node :=xmldom.getNextSibling(xmldom.getFirstChild(l_AM_Node));
2788:
2789: -- Now get the list of all Nodes
2790: l_EO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_TXN_Node),'EO');
2791: --

Line 2790: l_EO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_TXN_Node),'EO');

2786: -- Now get the Node and get its Sibling -->
2787: l_TXN_Node :=xmldom.getNextSibling(xmldom.getFirstChild(l_AM_Node));
2788:
2789: -- Now get the list of all Nodes
2790: l_EO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_TXN_Node),'EO');
2791: --
2792: IF (xmldom.getLength(l_EO_NodeList) > 0) THEN
2793: -- Loop for it
2794: FOR i IN 1..xmldom.getLength(l_EO_NodeList) LOOP

Line 2792: IF (xmldom.getLength(l_EO_NodeList) > 0) THEN

2788:
2789: -- Now get the list of all Nodes
2790: l_EO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_TXN_Node),'EO');
2791: --
2792: IF (xmldom.getLength(l_EO_NodeList) > 0) THEN
2793: -- Loop for it
2794: FOR i IN 1..xmldom.getLength(l_EO_NodeList) LOOP
2795: l_EO_Node := xmldom.item(l_EO_NodeList,i-1);
2796: l_pwac_return_status := 'S';

Line 2794: FOR i IN 1..xmldom.getLength(l_EO_NodeList) LOOP

2790: l_EO_NodeList :=xmldom.getChildrenByTagName(xmldom.makeElement(l_TXN_Node),'EO');
2791: --
2792: IF (xmldom.getLength(l_EO_NodeList) > 0) THEN
2793: -- Loop for it
2794: FOR i IN 1..xmldom.getLength(l_EO_NodeList) LOOP
2795: l_EO_Node := xmldom.item(l_EO_NodeList,i-1);
2796: l_pwac_return_status := 'S';
2797:
2798: BEGIN

Line 2795: l_EO_Node := xmldom.item(l_EO_NodeList,i-1);

2791: --
2792: IF (xmldom.getLength(l_EO_NodeList) > 0) THEN
2793: -- Loop for it
2794: FOR i IN 1..xmldom.getLength(l_EO_NodeList) LOOP
2795: l_EO_Node := xmldom.item(l_EO_NodeList,i-1);
2796: l_pwac_return_status := 'S';
2797:
2798: BEGIN
2799: l_pwac_return_status:=process_api_internal(

Line 2810: IF(xmldom.isnull(error_doc)) THEN -- first error condition

2806: EXCEPTION
2807: WHEN g_process_api_internal_error THEN
2808: x_return_status := set_status(x_return_status,'E');
2809: -- read the fnd msg pub for errors and log them to error doc
2810: IF(xmldom.isnull(error_doc)) THEN -- first error condition
2811: -- create the new empty document
2812: error_doc := xmldom.newDOMDocument;
2813: error_doc_main_node := xmldom.makeNode(error_doc);
2814: -- create the root element to hold txn id

Line 2812: error_doc := xmldom.newDOMDocument;

2808: x_return_status := set_status(x_return_status,'E');
2809: -- read the fnd msg pub for errors and log them to error doc
2810: IF(xmldom.isnull(error_doc)) THEN -- first error condition
2811: -- create the new empty document
2812: error_doc := xmldom.newDOMDocument;
2813: error_doc_main_node := xmldom.makeNode(error_doc);
2814: -- create the root element to hold txn id
2815: -- error_doc_root_elmt
2816: error_doc_root_elmt:= xmldom.createElement(error_doc, 'Transaction');

Line 2813: error_doc_main_node := xmldom.makeNode(error_doc);

2809: -- read the fnd msg pub for errors and log them to error doc
2810: IF(xmldom.isnull(error_doc)) THEN -- first error condition
2811: -- create the new empty document
2812: error_doc := xmldom.newDOMDocument;
2813: error_doc_main_node := xmldom.makeNode(error_doc);
2814: -- create the root element to hold txn id
2815: -- error_doc_root_elmt
2816: error_doc_root_elmt:= xmldom.createElement(error_doc, 'Transaction');
2817: xmldom.setAttribute(error_doc_root_elmt,'Id', p_transaction_id);

Line 2816: error_doc_root_elmt:= xmldom.createElement(error_doc, 'Transaction');

2812: error_doc := xmldom.newDOMDocument;
2813: error_doc_main_node := xmldom.makeNode(error_doc);
2814: -- create the root element to hold txn id
2815: -- error_doc_root_elmt
2816: error_doc_root_elmt:= xmldom.createElement(error_doc, 'Transaction');
2817: xmldom.setAttribute(error_doc_root_elmt,'Id', p_transaction_id);
2818: error_doc_main_node :=xmldom.appendChild(error_doc_main_node, xmldom.makeNode(error_doc_root_elmt));
2819: END IF;
2820:

Line 2817: xmldom.setAttribute(error_doc_root_elmt,'Id', p_transaction_id);

2813: error_doc_main_node := xmldom.makeNode(error_doc);
2814: -- create the root element to hold txn id
2815: -- error_doc_root_elmt
2816: error_doc_root_elmt:= xmldom.createElement(error_doc, 'Transaction');
2817: xmldom.setAttribute(error_doc_root_elmt,'Id', p_transaction_id);
2818: error_doc_main_node :=xmldom.appendChild(error_doc_main_node, xmldom.makeNode(error_doc_root_elmt));
2819: END IF;
2820:
2821: -- add the EO node to the error doc

Line 2818: error_doc_main_node :=xmldom.appendChild(error_doc_main_node, xmldom.makeNode(error_doc_root_elmt));

2814: -- create the root element to hold txn id
2815: -- error_doc_root_elmt
2816: error_doc_root_elmt:= xmldom.createElement(error_doc, 'Transaction');
2817: xmldom.setAttribute(error_doc_root_elmt,'Id', p_transaction_id);
2818: error_doc_main_node :=xmldom.appendChild(error_doc_main_node, xmldom.makeNode(error_doc_root_elmt));
2819: END IF;
2820:
2821: -- add the EO node to the error doc
2822: error_EO_elmt := xmldom.createElement(error_doc, 'EO');

Line 2822: error_EO_elmt := xmldom.createElement(error_doc, 'EO');

2818: error_doc_main_node :=xmldom.appendChild(error_doc_main_node, xmldom.makeNode(error_doc_root_elmt));
2819: END IF;
2820:
2821: -- add the EO node to the error doc
2822: error_EO_elmt := xmldom.createElement(error_doc, 'EO');
2823: -- need the actual nested EO which has errored and its cdata node
2824: xmldom.setAttribute(error_EO_elmt, 'Name', g_processing_EO_name);
2825: xmldom.setAttribute(error_EO_elmt, 'CDATA', g_processing_EO_cdatavalue);
2826: --

Line 2824: xmldom.setAttribute(error_EO_elmt, 'Name', g_processing_EO_name);

2820:
2821: -- add the EO node to the error doc
2822: error_EO_elmt := xmldom.createElement(error_doc, 'EO');
2823: -- need the actual nested EO which has errored and its cdata node
2824: xmldom.setAttribute(error_EO_elmt, 'Name', g_processing_EO_name);
2825: xmldom.setAttribute(error_EO_elmt, 'CDATA', g_processing_EO_cdatavalue);
2826: --
2827: error_EO_Node :=xmldom.makeNode(error_EO_elmt);
2828:

Line 2825: xmldom.setAttribute(error_EO_elmt, 'CDATA', g_processing_EO_cdatavalue);

2821: -- add the EO node to the error doc
2822: error_EO_elmt := xmldom.createElement(error_doc, 'EO');
2823: -- need the actual nested EO which has errored and its cdata node
2824: xmldom.setAttribute(error_EO_elmt, 'Name', g_processing_EO_name);
2825: xmldom.setAttribute(error_EO_elmt, 'CDATA', g_processing_EO_cdatavalue);
2826: --
2827: error_EO_Node :=xmldom.makeNode(error_EO_elmt);
2828:
2829: OPEN csr_trn_item;

Line 2827: error_EO_Node :=xmldom.makeNode(error_EO_elmt);

2823: -- need the actual nested EO which has errored and its cdata node
2824: xmldom.setAttribute(error_EO_elmt, 'Name', g_processing_EO_name);
2825: xmldom.setAttribute(error_EO_elmt, 'CDATA', g_processing_EO_cdatavalue);
2826: --
2827: error_EO_Node :=xmldom.makeNode(error_EO_elmt);
2828:
2829: OPEN csr_trn_item;
2830: FETCH csr_trn_item INTO item_row;
2831: createEOErrorMSgNode(error_doc,error_EO_Node,item_row.item_type,item_row.item_key);

Line 2832: error_temp_Node:=xmldom.appendChild(error_doc_main_node,error_EO_Node);

2828:
2829: OPEN csr_trn_item;
2830: FETCH csr_trn_item INTO item_row;
2831: createEOErrorMSgNode(error_doc,error_EO_Node,item_row.item_type,item_row.item_key);
2832: error_temp_Node:=xmldom.appendChild(error_doc_main_node,error_EO_Node);
2833: -- see if we need to progress on the siblings ?
2834: IF p_process_all_on_error = hr_api.g_false_num THEN
2835: RAISE g_process_api_internal_error;
2836: END IF;