APPS.HR_XML_PUB_UTILITY dependencies on HR_UTILITY

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

16: l_raw_buffer_len pls_integer;
17: l_blob_offset pls_integer := 1;
18:
19: begin
20: hr_utility.set_location('Entered Procedure clob to blob',120);
21: select userenv('LANGUAGE') into g_nls_db_char from dual;
22: l_length_clob := dbms_lob.getlength(p_clob);
23: l_offset := 1;
24: while l_length_clob > 0 loop

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

21: select userenv('LANGUAGE') into g_nls_db_char from dual;
22: l_length_clob := dbms_lob.getlength(p_clob);
23: l_offset := 1;
24: while l_length_clob > 0 loop
25: hr_utility.trace('l_length_clob '|| l_length_clob);
26: if l_length_clob < l_buffer_len then
27: l_chunk_len := l_length_clob;
28: else
29: l_chunk_len := l_buffer_len;

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

31: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
32: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
33: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
34: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
35: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
36: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
37: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
38: l_blob_offset := l_blob_offset + l_raw_buffer_len;
39:

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

38: l_blob_offset := l_blob_offset + l_raw_buffer_len;
39:
40: l_offset := l_offset + l_chunk_len;
41: l_length_clob := l_length_clob - l_chunk_len;
42: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
43: end loop;
44:
45: exception
46: when others then

Line 47: hr_utility.set_location(' Leaving: ' || l_proc, 100);

43: end loop;
44:
45: exception
46: when others then
47: hr_utility.set_location(' Leaving: ' || l_proc, 100);
48: raise;
49: end;
50:
51: end HR_XML_PUB_UTILITY;