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 HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: hrtrnswi.pkb 120.27.12020000.6 2012/11/29 10:11:56 aammoham ship $ */
3: -- Global variables
4: g_date_format varchar2(10) := 'RRRR/MM/DD';
5: g_package varchar2(33) := 'HR_TRANSACTION_SWI.';
6: g_debug boolean := hr_utility.debug_enabled;
7: g_tempClob CLOB;
8: -- EO Api Map related global Variables
9: g_current_EO_name varchar2(160);
10: g_current_EO_ApiName varchar2(160);

Line 543: hr_utility.set_location(' Entering:' || l_proc,10);

539: l_proc varchar2(72) := g_package || 'getDateValue';
540: l_pos number;
541:
542: Begin
543: hr_utility.set_location(' Entering:' || l_proc,10);
544:
545: xslprocessor.valueof(commitNode,attributeName,l_string);
546: l_pos := instr(l_string, ' ', 1);
547: if(l_pos <> 0) then

Line 559: hr_utility.set_location(' Exiting :' || l_proc,15);

555: l_date := NULL;
556: else
557: l_date := NVL(l_date, gmisc_value);
558: end if;
559: hr_utility.set_location(' Exiting :' || l_proc,15);
560: return l_date;
561: End getDateValue;
562:
563: Function getVarchar2Value(

Line 573: hr_utility.set_location(' Entering:' || l_proc,10);

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);
575: l_element := xmldom.makeElement(commitNode);
576: -- l_isNull := xmldom.getAttribute(l_element, 'null');
577: l_isNull := getAttributeValue (commitNode,attributeName,'null');

Line 583: hr_utility.set_location(' Exiting :' || l_proc,15);

579: l_varchar2 := NULL;
580: else
581: l_varchar2 := NVL(l_varchar2, gmisc_value);
582: end if;
583: hr_utility.set_location(' Exiting :' || l_proc,15);
584: return l_varchar2;
585: End getVarchar2Value;
586:
587: Function getNumberValue(

Line 597: hr_utility.set_location(' Entering:' || l_proc,10);

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
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));

Line 611: hr_utility.set_location(' Exiting :' || l_proc,15);

607: l_number := NULL;
608: else
609: l_number := NVL(l_number, gmisc_value);
610: end if;
611: hr_utility.set_location(' Exiting :' || l_proc,15);
612: return l_number;
613: End getNumberValue;
614:
615: Function get_EO_api_name(

Line 677: hr_utility.set_location(' Entering:' || l_proc,10);

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:
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);

Line 698: hr_utility.set_location('Making the CLOB:' || l_proc,15);

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);
700: -- DBMS_LOB.createTemporary(g_tempClob, FALSE);
701: xmldom.writeToClob(l_EORowNode,g_tempClob);
702:

Line 703: hr_utility.set_location('Building the Dynamic Procedure call:' || l_proc,20);

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);
706: -- if csr_hat_steps%NOTFOUND then
707: l_sqlbuf:= 'begin ' || l_EO_api_name

Line 726: hr_utility.set_location(' Error processing with api call '||l_EO_api_name || l_proc,50);

722:
723: DBMS_LOB.freetemporary(g_tempClob);
724:
725: IF(l_procapi_retstat_out = 'E') THEN
726: hr_utility.set_location(' Error processing with api call '||l_EO_api_name || l_proc,50);
727: RAISE g_process_api_internal_error;
728: END IF;
729:
730: hr_utility.set_location(' Convert RowNode into Element:' || l_proc,20);

Line 730: hr_utility.set_location(' Convert RowNode into Element:' || l_proc,20);

726: hr_utility.set_location(' Error processing with api call '||l_EO_api_name || l_proc,50);
727: RAISE g_process_api_internal_error;
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

Line 735: hr_utility.set_location('Child Nodes Exist :' || l_proc,25);

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:
739: hr_utility.set_location('Entering For Loop for Child Nodes :' || l_proc,30);

Line 739: hr_utility.set_location('Entering For Loop for Child Nodes :' || l_proc,30);

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);
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;

Line 744: hr_utility.set_location('End of For Loop :' || l_proc,35);

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;
746: end if; -- if EO API NAME IS NOT NULL
747: hr_utility.set_location('Exiting:' || l_proc,40);
748: return x_current_status;

Line 747: hr_utility.set_location('Exiting:' || l_proc,40);

743: end loop;
744: hr_utility.set_location('End of For Loop :' || l_proc,35);
745: end if;
746: end if; -- if EO API NAME IS NOT NULL
747: hr_utility.set_location('Exiting:' || l_proc,40);
748: return x_current_status;
749: End process_api_internal;
750:
751:

Line 770: hr_utility.set_location(' Entering:' || l_proc,10);

766: x_current_status varchar2(1);
767: l_proc varchar2(72) := g_package || 'process_api_call';
768:
769: Begin
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

Line 786: hr_utility.set_location('Making the CLOB:' || l_proc,15);

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;
790:

Line 792: hr_utility.set_location('Building the Dynamic Procedure call:' || l_proc,20);

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);
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

Line 815: hr_utility.set_location('Exiting:' || l_proc,25);

811: -- Free the CLOB
812: -- Make the call to set_status to set the current_return Status
813: x_current_status:=set_status(x_current_status,l_procapi_retstat_out);
814:
815: hr_utility.set_location('Exiting:' || l_proc,25);
816: return x_current_status;
817:
818: End process_api_call;
819:

Line 827: hr_utility.set_location(' Entering:' || l_proc,10);

823: return VARCHAR2 IS
824: x_return_status varchar2(1);
825: l_proc varchar2(72) := g_package || 'set_status';
826: Begin
827: hr_utility.set_location(' Entering:' || l_proc,10);
828:
829: x_return_status:=p_curent_status;
830: if (p_dyn_sql_processapi_sts = 'E') then
831: x_return_status := 'E';

Line 835: hr_utility.set_location(' Exiting :' || l_proc,15);

831: x_return_status := 'E';
832: elsif (p_dyn_sql_processapi_sts = 'W' and NVL(p_curent_status,'W') <> 'E') then
833: x_return_status := 'W';
834: end if;
835: hr_utility.set_location(' Exiting :' || l_proc,15);
836:
837: return x_return_status;
838:
839: End set_status;

Line 867: hr_utility.set_location(' Entering:' || l_proc,10);

863: step_row csr_hat%rowtype;
864: l_proc varchar2(72) := g_package || 'set_transaction_context';
865: Begin
866:
867: hr_utility.set_location(' Entering:' || l_proc,10);
868: hr_utility.set_location(' Opening Cursor:csr_hat' || l_proc,15);
869: g_txn_ctx := null;
870: open csr_hat;
871: fetch csr_hat into step_row;

Line 868: hr_utility.set_location(' Opening Cursor:csr_hat' || l_proc,15);

864: l_proc varchar2(72) := g_package || 'set_transaction_context';
865: Begin
866:
867: hr_utility.set_location(' Entering:' || l_proc,10);
868: hr_utility.set_location(' Opening Cursor:csr_hat' || l_proc,15);
869: g_txn_ctx := null;
870: open csr_hat;
871: fetch csr_hat into step_row;
872: close csr_hat;

Line 873: hr_utility.set_location(' Closing Cursor:csr_hat' || l_proc,20);

869: g_txn_ctx := null;
870: open csr_hat;
871: fetch csr_hat into step_row;
872: close csr_hat;
873: hr_utility.set_location(' Closing Cursor:csr_hat' || l_proc,20);
874:
875: -- Set the Individual fields on the Global Transaction Context Record
876: hr_utility.set_location(' Setting GlobalTxnCtx' || l_proc,25);
877: g_txn_ctx.TRANSACTION_ID :=step_row.TRANSACTION_ID;

Line 876: hr_utility.set_location(' Setting GlobalTxnCtx' || l_proc,25);

872: close csr_hat;
873: hr_utility.set_location(' Closing Cursor:csr_hat' || l_proc,20);
874:
875: -- Set the Individual fields on the Global Transaction Context Record
876: hr_utility.set_location(' Setting GlobalTxnCtx' || l_proc,25);
877: g_txn_ctx.TRANSACTION_ID :=step_row.TRANSACTION_ID;
878: g_txn_ctx.CREATOR_PERSON_ID :=step_row.CREATOR_PERSON_ID;
879: g_txn_ctx.STATUS :=step_row.STATUS;
880: g_txn_ctx.FUNCTION_ID :=step_row.FUNCTION_ID;

Line 897: hr_utility.set_location(' Completd Setting GlobalTxnCtx' || l_proc,30);

893: g_txn_ctx.EFFECTIVE_DATE := trunc(SYSDATE);
894: else
895: g_txn_ctx.EFFECTIVE_DATE := nvl(step_row.TRANSACTION_EFFECTIVE_DATE, trunc(sysdate));
896: end if;
897: hr_utility.set_location(' Completd Setting GlobalTxnCtx' || l_proc,30);
898: hr_utility.set_location(' Exiting :' || l_proc,35);
899:
900:
901: end set_transaction_context;

Line 898: hr_utility.set_location(' Exiting :' || l_proc,35);

894: else
895: g_txn_ctx.EFFECTIVE_DATE := nvl(step_row.TRANSACTION_EFFECTIVE_DATE, trunc(sysdate));
896: end if;
897: hr_utility.set_location(' Completd Setting GlobalTxnCtx' || l_proc,30);
898: hr_utility.set_location(' Exiting :' || l_proc,35);
899:
900:
901: end set_transaction_context;
902:

Line 982: hr_utility.set_location(' Entering:' || l_proc,10);

978: p_transaction_id number;
979: dummy VARCHAR2(10);
980: ----------
981: Begin
982: hr_utility.set_location(' Entering:' || l_proc,10);
983: hr_utility.set_location(' Opening Cursor:csr_person_details' || l_proc,15);
984:
985: --
986: -- Initializing variables

Line 983: hr_utility.set_location(' Opening Cursor:csr_person_details' || l_proc,15);

979: dummy VARCHAR2(10);
980: ----------
981: Begin
982: hr_utility.set_location(' Entering:' || l_proc,10);
983: hr_utility.set_location(' Opening Cursor:csr_person_details' || l_proc,15);
984:
985: --
986: -- Initializing variables
987: p_transaction_id := NULL;

Line 994: hr_utility.set_location(' Closing Cursor:csr_person_details' || l_proc,20);

990: if p_selected_person_id is not null AND p_selected_assignment_id is not null AND p_effective_date is not null then
991: open csr_person_details;
992: fetch csr_person_details into step_row;
993: close csr_person_details;
994: hr_utility.set_location(' Closing Cursor:csr_person_details' || l_proc,20);
995: -- Set the Individual fields on the Global Person Record
996: hr_utility.set_location('Setting the GlobalPersonRecord:' || l_proc,25);
997:
998: g_person_ctx.FULL_NAME :=step_row.FULL_NAME;

Line 996: hr_utility.set_location('Setting the GlobalPersonRecord:' || l_proc,25);

992: fetch csr_person_details into step_row;
993: close csr_person_details;
994: hr_utility.set_location(' Closing Cursor:csr_person_details' || l_proc,20);
995: -- Set the Individual fields on the Global Person Record
996: hr_utility.set_location('Setting the GlobalPersonRecord:' || l_proc,25);
997:
998: g_person_ctx.FULL_NAME :=step_row.FULL_NAME;
999: g_person_ctx.PERSON_ID :=step_row.PERSON_ID;
1000: g_person_ctx.EMPLOYEE_NUMBER :=step_row.EMPLOYEE_NUMBER;

Line 1049: hr_utility.trace('Inside hr_transaction_swi.set_person_context: p_transaction_id := ' || p_transaction_id);

1045: ---Changes for 11776102
1046:
1047: p_transaction_id := g_txn_ctx.TRANSACTION_ID;
1048:
1049: hr_utility.trace('Inside hr_transaction_swi.set_person_context: p_transaction_id := ' || p_transaction_id);
1050: /*
1051: if(p_transaction_id is not null) then
1052: begin
1053: select * into lr_hr_api_transaction_rec

Line 1096: hr_utility.trace('Entered into anonymous block for fix 11776102');

1092: from hr_api_transactions
1093: where transaction_id = p_transaction_id;
1094: begin
1095:
1096: hr_utility.trace('Entered into anonymous block for fix 11776102');
1097:
1098: open cur;
1099: fetch cur into lr_hr_api_transaction_rec;
1100: if cur%NOTFOUND then

Line 1103: hr_utility.trace('Cursor cur fetches no record !');

1099: fetch cur into lr_hr_api_transaction_rec;
1100: if cur%NOTFOUND then
1101: lr_hr_api_transaction_rec.item_type := NULL;
1102: lr_hr_api_transaction_rec.item_key := NULL;
1103: hr_utility.trace('Cursor cur fetches no record !');
1104: end if;
1105: if cur%ROWCOUNT > 1 then
1106: hr_utility.trace('Cursor cur fetches more than one record!');
1107: NULL;

Line 1106: hr_utility.trace('Cursor cur fetches more than one record!');

1102: lr_hr_api_transaction_rec.item_key := NULL;
1103: hr_utility.trace('Cursor cur fetches no record !');
1104: end if;
1105: if cur%ROWCOUNT > 1 then
1106: hr_utility.trace('Cursor cur fetches more than one record!');
1107: NULL;
1108: end if;
1109: close cur;
1110:

Line 1143: hr_utility.set_location('Set values on Global Person Record:' || l_proc,30);

1139:
1140:
1141:
1142: ----------
1143: hr_utility.set_location('Set values on Global Person Record:' || l_proc,30);
1144: hr_utility.set_location(' Exiting :' || l_proc,35);
1145:
1146: end set_person_context;
1147:

Line 1144: hr_utility.set_location(' Exiting :' || l_proc,35);

1140:
1141:
1142: ----------
1143: hr_utility.set_location('Set values on Global Person Record:' || l_proc,30);
1144: hr_utility.set_location(' Exiting :' || l_proc,35);
1145:
1146: end set_person_context;
1147:
1148: procedure init_profiles(

Line 1160: hr_utility.set_location(' Entering:' || l_proc,10);

1156: IS
1157: l_proc varchar2(72) := g_package || 'init_profiles';
1158: Begin
1159:
1160: hr_utility.set_location(' Entering:' || l_proc,10);
1161: hr_utility.set_location(' Setting Profile values:' || l_proc,15);
1162:
1163: fnd_profile.put('PER_PERSON_ID', p_person_id);
1164: fnd_profile.put('PER_ASSIGNMENT_ID', p_assignment_id);

Line 1161: hr_utility.set_location(' Setting Profile values:' || l_proc,15);

1157: l_proc varchar2(72) := g_package || 'init_profiles';
1158: Begin
1159:
1160: hr_utility.set_location(' Entering:' || l_proc,10);
1161: hr_utility.set_location(' Setting Profile values:' || l_proc,15);
1162:
1163: fnd_profile.put('PER_PERSON_ID', p_person_id);
1164: fnd_profile.put('PER_ASSIGNMENT_ID', p_assignment_id);
1165: fnd_profile.put('PER_BUSINESS_GROUP_ID', p_business_group_Id);

Line 1170: hr_utility.set_location(' Exiting :' || l_proc,20);

1166: fnd_profile.put('PER_ORGANIZATION_ID', p_organization_Id);
1167: fnd_profile.put('PER_LOCATION_ID', p_location_id);
1168: fnd_profile.put('PER_PAYROLL_ID', p_payroll_id);
1169:
1170: hr_utility.set_location(' Exiting :' || l_proc,20);
1171:
1172: end init_profiles;
1173:
1174:

Line 1181: hr_utility.set_location(' Entering:' || l_proc,10);

1177: p_validate in NUMBER default hr_api.g_false_num)
1178: is
1179: l_proc varchar2(72) := g_package || 'delete_transaction';
1180: begin
1181: hr_utility.set_location(' Entering:' || l_proc,10);
1182: hr_utility.set_location(' Calling:hr_transaction_api.rollback_transaction' || l_proc,15);
1183: delete_transaction_children(p_transaction_id, p_validate);
1184: hr_sflutil_ss.closesflnotifications(p_transaction_id,null,null);
1185: hr_transaction_api.rollback_transaction(

Line 1182: hr_utility.set_location(' Calling:hr_transaction_api.rollback_transaction' || l_proc,15);

1178: is
1179: l_proc varchar2(72) := g_package || 'delete_transaction';
1180: begin
1181: hr_utility.set_location(' Entering:' || l_proc,10);
1182: hr_utility.set_location(' Calling:hr_transaction_api.rollback_transaction' || l_proc,15);
1183: delete_transaction_children(p_transaction_id, p_validate);
1184: hr_sflutil_ss.closesflnotifications(p_transaction_id,null,null);
1185: hr_transaction_api.rollback_transaction(
1186: p_transaction_id => p_transaction_id,

Line 1188: hr_utility.set_location(' Exiting :' || l_proc,20);

1184: hr_sflutil_ss.closesflnotifications(p_transaction_id,null,null);
1185: hr_transaction_api.rollback_transaction(
1186: p_transaction_id => p_transaction_id,
1187: p_validate => (p_validate=hr_api.g_true_num));
1188: hr_utility.set_location(' Exiting :' || l_proc,20);
1189: end delete_transaction;
1190:
1191: function convertCLOBtoXMLElement(
1192: p_document in CLOB)

Line 1198: hr_utility.set_location(' Entering:' || l_proc,10);

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);
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);

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 1227: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

1223:
1224: begin
1225: -- check if debug enabled
1226: if g_debug then
1227: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1228: end if;
1229:
1230: -- call the overloaded setTransactionStatus with null comments
1231: setTransactionStatus(p_transaction_id,null,

Line 1239: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);

1235: p_propagateMessagePub,
1236: p_status);
1237:
1238: if g_debug then
1239: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
1240: end if;
1241:
1242: exception
1243: when others then

Line 1927: hr_utility.set_location(' Entering:' || l_proc,10);

1923: x_return_status VARCHAR2(1);
1924: p_error_log CLOB;
1925:
1926: BEGIN
1927: hr_utility.set_location(' Entering:' || l_proc,10);
1928: commit_transaction(
1929: p_transaction_id=>p_transaction_id,
1930: p_validate =>p_validate,
1931: p_effective_date=>p_effective_date,

Line 1935: hr_utility.set_location(' Exiting:' || l_proc,20);

1931: p_effective_date=>p_effective_date,
1932: p_process_all_on_error =>hr_api.g_false_num,
1933: p_status=>x_return_status,
1934: p_error_log=>p_error_log);
1935: hr_utility.set_location(' Exiting:' || l_proc,20);
1936:
1937: RETURN x_return_status;
1938: EXCEPTION
1939: WHEN others THEN

Line 2285: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

2281:
2282: begin
2283: -- check if debug enabled
2284: if g_debug then
2285: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2286: end if;
2287: -- check if we need to propagate the error messages
2288: if(p_propagateMessagePub=hr_api.g_true_num) then
2289: hr_multi_message.enable_message_list;

Line 2405: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);

2401: commit;
2402:
2403:
2404: if g_debug then
2405: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
2406: end if;
2407:
2408: exception
2409: when others then

Line 2447: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

2443: begin
2444:
2445: -- check if debug enabled
2446: if g_debug then
2447: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2448: end if;
2449: -- check if we need to propagate the error messages
2450: if(p_propagateMessagePub=hr_api.g_true_num) then
2451: hr_multi_message.enable_message_list;

Line 2573: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);

2569: -- finally commit the data
2570: commit;
2571:
2572: if g_debug then
2573: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
2574: end if;
2575:
2576: exception
2577: when others then

Line 2598: hr_utility.set_location('Entering createEOErrorMSgNode : ', 10);

2594: p_data VARCHAR2(4000);
2595: p_msg_index_out NUMBER;
2596:
2597: BEGIN
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');

Line 2633: hr_utility.set_location('EO Error : ' || msg_details, 20);

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;
2633: hr_utility.set_location('EO Error : ' || msg_details, 20);
2634: item_text := xmldom.createTextNode(
2635: doc
2636: , msg_details
2637: );

Line 2657: hr_utility.set_location('Leaving createEOErrorMSgNode : ', 30);

2653: ,itemkey => itemkey
2654: ,aname => 'ERROR_STACK'
2655: ,avalue => substr(p_data,1,1999));
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)

Line 2732: hr_utility.set_location(' Entering:' || l_proc,10);

2728: error_log CLOB;
2729:
2730: BEGIN
2731: SAVEPOINT commit_transaction_swi;
2732: hr_utility.set_location(' Entering:' || l_proc,10);
2733: -- Call Set_Transaction_Context
2734: hr_utility.set_location(' Calling set_transaction_context:' || l_proc,15);
2735: set_transaction_context(p_transaction_id);
2736:

Line 2734: hr_utility.set_location(' Calling set_transaction_context:' || l_proc,15);

2730: BEGIN
2731: SAVEPOINT commit_transaction_swi;
2732: hr_utility.set_location(' Entering:' || l_proc,10);
2733: -- Call Set_Transaction_Context
2734: hr_utility.set_location(' Calling set_transaction_context:' || l_proc,15);
2735: set_transaction_context(p_transaction_id);
2736:
2737: -- If p_effective_date is not NULL then set it on the g_txn_ctx.EFFECTIVE_DATE
2738: IF ( p_effective_date IS NOT NULL ) THEN

Line 2743: hr_utility.set_location(' Calling set_person_context:' || l_proc,20);

2739: g_txn_ctx.EFFECTIVE_DATE:=p_effective_date;
2740: END IF;
2741: -- Call Set_Person_Context
2742: l_language:='US';
2743: hr_utility.set_location(' Calling set_person_context:' || l_proc,20);
2744: set_person_context( p_selected_person_id => g_txn_ctx.SELECTED_PERSON_ID,
2745: p_selected_assignment_id => g_txn_ctx.ASSIGNMENT_ID,
2746: p_effective_date => g_txn_ctx.EFFECTIVE_DATE);
2747:

Line 2749: hr_utility.set_location(' Calling :hr_util_misc_ss.seteffectivedate' || l_proc,25);

2745: p_selected_assignment_id => g_txn_ctx.ASSIGNMENT_ID,
2746: p_effective_date => g_txn_ctx.EFFECTIVE_DATE);
2747:
2748: x_return_status := 'S';
2749: hr_utility.set_location(' Calling :hr_util_misc_ss.seteffectivedate' || l_proc,25);
2750: hr_utility.set_location(' Entering For Loop' || l_proc,35);
2751: -- new code
2752: OPEN csr_trn;
2753: FETCH csr_trn INTO step_row;

Line 2750: hr_utility.set_location(' Entering For Loop' || l_proc,35);

2746: p_effective_date => g_txn_ctx.EFFECTIVE_DATE);
2747:
2748: x_return_status := 'S';
2749: hr_utility.set_location(' Calling :hr_util_misc_ss.seteffectivedate' || l_proc,25);
2750: hr_utility.set_location(' Entering For Loop' || l_proc,35);
2751: -- new code
2752: OPEN csr_trn;
2753: FETCH csr_trn INTO step_row;
2754: -- hsundar: Do the Document processing only when the Txn_document is not null

Line 2848: hr_utility.set_location(' Exiting For Loop:' || l_proc,40);

2844: CLOSE csr_trn;
2845:
2846: writeXMLDocToClob(error_doc ,p_error_log );
2847:
2848: hr_utility.set_location(' Exiting For Loop:' || l_proc,40);
2849: IF p_validate = hr_api.g_true_num THEN
2850: hr_utility.set_location(' p_validate=TRUE:' || l_proc,45);
2851: RAISE hr_api.validate_enabled;
2852: END IF;

Line 2850: hr_utility.set_location(' p_validate=TRUE:' || l_proc,45);

2846: writeXMLDocToClob(error_doc ,p_error_log );
2847:
2848: hr_utility.set_location(' Exiting For Loop:' || l_proc,40);
2849: IF p_validate = hr_api.g_true_num THEN
2850: hr_utility.set_location(' p_validate=TRUE:' || l_proc,45);
2851: RAISE hr_api.validate_enabled;
2852: END IF;
2853: -- Return the status to the calling procedure
2854: -- hsundar: There is no need to commit as Work-Flow takes care of it implicitly

Line 2856: hr_utility.set_location('Commiting as p_validate=FALSE:' || l_proc,50);

2852: END IF;
2853: -- Return the status to the calling procedure
2854: -- hsundar: There is no need to commit as Work-Flow takes care of it implicitly
2855: /*if p_validate = hr_api.g_false_num then
2856: hr_utility.set_location('Commiting as p_validate=FALSE:' || l_proc,50);
2857: COMMIT;
2858: END IF; */
2859:
2860: hr_utility.set_location(' Exiting:' || l_proc,55);

Line 2860: hr_utility.set_location(' Exiting:' || l_proc,55);

2856: hr_utility.set_location('Commiting as p_validate=FALSE:' || l_proc,50);
2857: COMMIT;
2858: END IF; */
2859:
2860: hr_utility.set_location(' Exiting:' || l_proc,55);
2861:
2862: --return x_return_status;
2863: p_status :=x_return_status;
2864: -- Moved the exception Block out of the for loop

Line 2870: WHEN hr_utility.hr_error THEN

2866: EXCEPTION
2867: WHEN g_process_api_internal_error THEN
2868: p_status :=x_return_status;
2869: writeXMLDocToClob(error_doc ,p_error_log );
2870: WHEN hr_utility.hr_error THEN
2871: --do something here
2872: hr_utility.set_location('Exception:hr_utility.hr_error' || l_proc,555);
2873: ROLLBACK TO commit_transaction_swi;
2874: RAISE;

Line 2872: hr_utility.set_location('Exception:hr_utility.hr_error' || l_proc,555);

2868: p_status :=x_return_status;
2869: writeXMLDocToClob(error_doc ,p_error_log );
2870: WHEN hr_utility.hr_error THEN
2871: --do something here
2872: hr_utility.set_location('Exception:hr_utility.hr_error' || l_proc,555);
2873: ROLLBACK TO commit_transaction_swi;
2874: RAISE;
2875: WHEN hr_api.validate_enabled THEN
2876: -- As the Validate_Enabled exception has been raised

Line 2878: hr_utility.set_location('Exception:hr_api.validate_enabled' || l_proc,560);

2874: RAISE;
2875: WHEN hr_api.validate_enabled THEN
2876: -- As the Validate_Enabled exception has been raised
2877: -- we must rollback to the savepoint
2878: hr_utility.set_location('Exception:hr_api.validate_enabled' || l_proc,560);
2879: ROLLBACK TO commit_transaction_swi;
2880: p_status :=x_return_status;
2881: WHEN others THEN
2882: hr_utility.set_location('Exception:others' || l_proc,565);

Line 2882: hr_utility.set_location('Exception:others' || l_proc,565);

2878: hr_utility.set_location('Exception:hr_api.validate_enabled' || l_proc,560);
2879: ROLLBACK TO commit_transaction_swi;
2880: p_status :=x_return_status;
2881: WHEN others THEN
2882: hr_utility.set_location('Exception:others' || l_proc,565);
2883: ROLLBACK TO commit_transaction_swi;
2884: RAISE;
2885:
2886: END commit_transaction;