APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on HR_UTILITY

Line 154: hr_utility.set_location(' Leaving: range code',110);

150: sqlstr := 'select 1 '||
151: '/* ERROR - Employer Details Fetch failed with: '||
152: sqlerrm(sqlcode)||' */ '||
153: 'from dual where to_char(:payroll_action_id) = dummy';
154: hr_utility.set_location(' Leaving: range code',110);
155: END range_code;
156: --------------------------------------------------------------------------------
157: -- ACTION_CREATION_CODE
158: --------------------------------------------------------------------------------

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

847: clob_to_blob(l_xfdf_string,p_xfdf_blob);
848: --return p_xfdf_blob;
849: EXCEPTION
850: WHEN OTHERS then
851: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
852: HR_UTILITY.RAISE_ERROR;
853: END WritetoCLOB;*/
854: PROCEDURE WritetoCLOB (p_xfdf_blob out nocopy blob
855: ,p_xfdf_string out nocopy clob)

Line 852: HR_UTILITY.RAISE_ERROR;

848: --return p_xfdf_blob;
849: EXCEPTION
850: WHEN OTHERS then
851: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
852: HR_UTILITY.RAISE_ERROR;
853: END WritetoCLOB;*/
854: PROCEDURE WritetoCLOB (p_xfdf_blob out nocopy blob
855: ,p_xfdf_string out nocopy clob)
856: IS

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

903: clob_to_blob(p_xfdf_string,p_xfdf_blob);
904: --return p_xfdf_blob;
905: EXCEPTION
906: WHEN OTHERS then
907: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
908: HR_UTILITY.RAISE_ERROR;
909: END WritetoCLOB;
910: --------------------------------------------------------------------------------
911: -- CLOB_TO_BLOB

Line 908: HR_UTILITY.RAISE_ERROR;

904: --return p_xfdf_blob;
905: EXCEPTION
906: WHEN OTHERS then
907: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
908: HR_UTILITY.RAISE_ERROR;
909: END WritetoCLOB;
910: --------------------------------------------------------------------------------
911: -- CLOB_TO_BLOB
912: --------------------------------------------------------------------------------

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

926: l_blob_offset pls_integer := 1;
927: --
928: BEGIN
929: --
930: hr_utility.set_location('Entered Procedure clob to blob',120);
931: --
932: SELECT userenv('LANGUAGE') INTO g_nls_db_char FROM dual;
933: --
934: l_buffer_len := 20000;

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

953: l_offset := l_offset + l_chunk_len;
954: l_length_clob := l_length_clob - l_chunk_len;
955: --
956: END LOOP;
957: hr_utility.set_location('Finished Procedure clob to blob ',130);
958: END;
959: --------------------------------------------------------------------------------
960: -- FETCH_PDF_BLOB
961: --------------------------------------------------------------------------------