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.PAY_IE_P60XML dependencies on HR_UTILITY

Line 65: hr_utility.raise_error;

61: IF l_formula_id IS NULL
62: THEN
63: -- Raise error as the criteria is not generated
64: CLOSE csr_get_asg_set_info;
65: hr_utility.raise_error;
66: END IF; -- End if of formula id is null check ...
67: END IF; -- End if of asg criteria row found check ...
68: CLOSE csr_get_asg_set_info;
69: fnd_file.put_line(fnd_file.LOG,' before csr_get_asg_amd ');

Line 514: hr_utility.set_location('Entering get_p60_details',10);

510: l_asg_org_name hr_all_organization_units.name%type;
511: --11674153
512:
513: begin
514: hr_utility.set_location('Entering get_p60_details',10);
515: vCtr := 0;
516: vXMLTable(vCtr).xmlstring := '';
517: vXMLTable(vCtr).xmlstring := vXMLTable(vCtr).xmlstring || '';
518: vCtr := vCtr +1;

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

698: PROCEDURE WritetoCLOB (p_xml out nocopy clob) IS
699: l_xfdf_string clob;
700: l_str1 varchar2(6000);
701: begin
702: hr_utility.set_location('Entered Procedure Write to clob ',100);
703: dbms_lob.createtemporary(p_xml,FALSE,DBMS_LOB.CALL);
704: dbms_lob.open(p_xml,dbms_lob.lob_readwrite);
705: if vXMLTable.count > 0 then
706: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

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

710: END LOOP;
711: end if;
712: --DBMS_LOB.CREATETEMPORARY(p_xml,TRUE);
713: --clob_to_blob(l_xfdf_string,p_xml);
714: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
715: EXCEPTION
716: WHEN OTHERS then
717: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
718: HR_UTILITY.RAISE_ERROR;

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

713: --clob_to_blob(l_xfdf_string,p_xml);
714: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
715: EXCEPTION
716: WHEN OTHERS then
717: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
718: HR_UTILITY.RAISE_ERROR;
719: END WritetoCLOB;
720:
721: Procedure clob_to_blob(p_clob clob

Line 718: HR_UTILITY.RAISE_ERROR;

714: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
715: EXCEPTION
716: WHEN OTHERS then
717: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
718: HR_UTILITY.RAISE_ERROR;
719: END WritetoCLOB;
720:
721: Procedure clob_to_blob(p_clob clob
722: ,p_blob IN OUT NOCOPY blob)

Line 732: hr_utility.set_location('Entered Procedure clob to blob',120);

728: l_buffer_len number:= 32000;
729: l_chunk_len number;
730: l_blob blob;
731: begin
732: hr_utility.set_location('Entered Procedure clob to blob',120);
733: l_length_clob := dbms_lob.getlength(p_clob);
734: l_offset := 1;
735: while l_length_clob > 0 loop
736: hr_utility.trace('l_length_clob '|| l_length_clob);

Line 736: hr_utility.trace('l_length_clob '|| l_length_clob);

732: hr_utility.set_location('Entered Procedure clob to blob',120);
733: l_length_clob := dbms_lob.getlength(p_clob);
734: l_offset := 1;
735: while l_length_clob > 0 loop
736: hr_utility.trace('l_length_clob '|| l_length_clob);
737: if l_length_clob < l_buffer_len then
738: l_chunk_len := l_length_clob;
739: else
740: l_chunk_len := l_buffer_len;

Line 744: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);

740: l_chunk_len := l_buffer_len;
741: end if;
742: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
743: l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
744: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
745: dbms_lob.writeappend(p_blob,l_chunk_len,l_raw_buffer);
746: l_offset := l_offset + l_chunk_len;
747: l_length_clob := l_length_clob - l_chunk_len;
748: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

Line 748: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

744: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
745: dbms_lob.writeappend(p_blob,l_chunk_len,l_raw_buffer);
746: l_offset := l_offset + l_chunk_len;
747: l_length_clob := l_length_clob - l_chunk_len;
748: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
749: end loop;
750: hr_utility.set_location('Finished Procedure clob to blob ',130);
751: end clob_to_blob;
752:

Line 750: hr_utility.set_location('Finished Procedure clob to blob ',130);

746: l_offset := l_offset + l_chunk_len;
747: l_length_clob := l_length_clob - l_chunk_len;
748: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
749: end loop;
750: hr_utility.set_location('Finished Procedure clob to blob ',130);
751: end clob_to_blob;
752:
753: Procedure fetch_rtf_blob (p_template_id number
754: ,p_rtf_blob OUT NOCOPY blob) IS