APPS.PAY_NO_ABS_STATISTICS_REPORT dependencies on HR_UTILITY

Line 862: hr_utility.set_location ('Entering WritetoCLOB ', 70);

858: l_quater varchar2(30);
859: l_quater_flag VARCHAR2(3):='Y';
860: BEGIN
861: l_IANA_charset :=hr_no_utility.get_IANA_charset ;
862: hr_utility.set_location ('Entering WritetoCLOB ', 70);
863: l_str1 := ' ';
864: l_str2 := '<';
865: l_str3 := '>';
866: l_str4 := '

Line 882: hr_utility.set_location(' l_quater : '||l_quater,10);

878: FOR table_counter IN gplsqltable.FIRST .. gplsqltable.LAST
879: LOOP
880: l_str8 := gplsqltable (table_counter).tagname;
881: l_str9 := gplsqltable (table_counter).tagvalue;
882: hr_utility.set_location(' l_quater : '||l_quater,10);
883: hr_utility.set_location(' l_str8 : '||l_str8,20);
884: hr_utility.set_location(' l_str9 : '||l_str9,30);
885: IF l_quater <> gplsqltable (table_counter).tagvalue and l_str8 = 'QUARTER' and l_quater is not null THEN
886: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);

Line 883: hr_utility.set_location(' l_str8 : '||l_str8,20);

879: LOOP
880: l_str8 := gplsqltable (table_counter).tagname;
881: l_str9 := gplsqltable (table_counter).tagvalue;
882: hr_utility.set_location(' l_quater : '||l_quater,10);
883: hr_utility.set_location(' l_str8 : '||l_str8,20);
884: hr_utility.set_location(' l_str9 : '||l_str9,30);
885: IF l_quater <> gplsqltable (table_counter).tagvalue and l_str8 = 'QUARTER' and l_quater is not null THEN
886: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
887: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);

Line 884: hr_utility.set_location(' l_str9 : '||l_str9,30);

880: l_str8 := gplsqltable (table_counter).tagname;
881: l_str9 := gplsqltable (table_counter).tagvalue;
882: hr_utility.set_location(' l_quater : '||l_quater,10);
883: hr_utility.set_location(' l_str8 : '||l_str8,20);
884: hr_utility.set_location(' l_str9 : '||l_str9,30);
885: IF l_quater <> gplsqltable (table_counter).tagvalue and l_str8 = 'QUARTER' and l_quater is not null THEN
886: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str4), l_str4);
887: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str8), l_str8);
888: DBMS_LOB.writeappend (l_xfdf_string, LENGTH (l_str5), l_str5);

Line 959: hr_utility.TRACE ( 'sqlerrm '

955:
956: EXCEPTION
957: WHEN OTHERS
958: THEN
959: hr_utility.TRACE ( 'sqlerrm '
960: || SQLERRM);
961: hr_utility.raise_error;
962: END writetoclob;
963: END PAY_NO_ABS_STATISTICS_REPORT;

Line 961: hr_utility.raise_error;

957: WHEN OTHERS
958: THEN
959: hr_utility.TRACE ( 'sqlerrm '
960: || SQLERRM);
961: hr_utility.raise_error;
962: END writetoclob;
963: END PAY_NO_ABS_STATISTICS_REPORT;