APPS.PAY_IE_EOY_INCOMELEVY_REPORT dependencies on HR_UTILITY

Line 100: hr_utility.raise_error;

96: IF l_formula_id IS NULL
97: THEN
98: -- Raise error as the criteria is not generated
99: CLOSE csr_get_asg_set_info;
100: hr_utility.raise_error;
101: END IF; -- End if of formula id is null check ...
102: END IF; -- End if of asg criteria row found check ...
103: CLOSE csr_get_asg_set_info;
104: fnd_file.put_line(fnd_file.LOG,' before csr_get_asg_amd ');

Line 594: hr_utility.set_location('Entering get_eoy_income_details',10);

590:
591: /* 10277535 end */
592:
593: begin
594: hr_utility.set_location('Entering get_eoy_income_details',10);
595:
596: vCtr := 0;
597: vXMLTable(vCtr).xmlstring := '';
598: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';

Line 1068: hr_utility.set_location('Entered Procedure Write to clob ',100);

1064: PROCEDURE WritetoCLOB (p_xml out nocopy clob) IS
1065: l_xfdf_string clob;
1066: l_str1 varchar2(6000);
1067: begin
1068: hr_utility.set_location('Entered Procedure Write to clob ',100);
1069: dbms_lob.createtemporary(p_xml,FALSE,DBMS_LOB.CALL);
1070: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
1071: if vXMLTable.count > 0 then
1072: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

Line 1080: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);

1076: END LOOP;
1077: end if;
1078: --DBMS_LOB.CREATETEMPORARY(p_xml,TRUE);
1079: --clob_to_blob(l_xfdf_string,p_xml);
1080: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
1081: EXCEPTION
1082: WHEN OTHERS then
1083: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1084: HR_UTILITY.RAISE_ERROR;

Line 1083: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

1079: --clob_to_blob(l_xfdf_string,p_xml);
1080: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
1081: EXCEPTION
1082: WHEN OTHERS then
1083: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1084: HR_UTILITY.RAISE_ERROR;
1085: END WritetoCLOB;
1086: end pay_ie_eoy_incomelevy_report;

Line 1084: HR_UTILITY.RAISE_ERROR;

1080: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
1081: EXCEPTION
1082: WHEN OTHERS then
1083: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
1084: HR_UTILITY.RAISE_ERROR;
1085: END WritetoCLOB;
1086: end pay_ie_eoy_incomelevy_report;