APPS.PAY_NL_XDO_REPORT dependencies on HR_UTILITY

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

20: l_str8 varchar2(1000);
21: l_str9 varchar2(1000);
22:
23: begin
24: hr_utility.set_location('Entered Procedure Write to clob ',100);
25: l_str1 := '
26:
27: ' ;
28: l_str2 := '';
94: l_str1 := '' ;
95: l_str2 := '<';
96: l_str3 := '>';

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

180: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
181: end if;
182: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
183: clob_to_blob(l_xfdf_string,p_xfdf_blob);
184: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
185: --return p_xfdf_blob;
186: EXCEPTION
187: WHEN OTHERS then
188: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

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

184: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
185: --return p_xfdf_blob;
186: EXCEPTION
187: WHEN OTHERS then
188: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
189: HR_UTILITY.RAISE_ERROR;
190: END WritetoCLOB_rtf;
191:
192: /*Function which retruns a CLOB to support building of xml file compatible with RTF processor */

Line 189: HR_UTILITY.RAISE_ERROR;

185: --return p_xfdf_blob;
186: EXCEPTION
187: WHEN OTHERS then
188: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
189: HR_UTILITY.RAISE_ERROR;
190: END WritetoCLOB_rtf;
191:
192: /*Function which retruns a CLOB to support building of xml file compatible with RTF processor */
193: PROCEDURE WritetoCLOB_rtf_1(p_xfdf_blob out nocopy clob) IS

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

205: l_str9 varchar2(1000);
206: l_str10 varchar2(1000);
207: l_concat_str VARCHAR2(32000);
208: begin
209: hr_utility.set_location('Entered Procedure Write to clob ',100);
210: l_str0 := '';
211: l_str1 := '' ;
212: l_str2 := '<';
213: l_str3 := '>';

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

301: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
302: end if;
303: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
304: p_xfdf_blob := l_xfdf_string;
305: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
306: --return p_xfdf_blob;
307: EXCEPTION
308: WHEN OTHERS then
309: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

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

305: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
306: --return p_xfdf_blob;
307: EXCEPTION
308: WHEN OTHERS then
309: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
310: HR_UTILITY.RAISE_ERROR;
311: END WritetoCLOB_rtf_1;
312:
313:

Line 310: HR_UTILITY.RAISE_ERROR;

306: --return p_xfdf_blob;
307: EXCEPTION
308: WHEN OTHERS then
309: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
310: HR_UTILITY.RAISE_ERROR;
311: END WritetoCLOB_rtf_1;
312:
313:
314: /*Converts CLOB data to BLOB*/

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

335: l_raw_buffer_len pls_integer;
336: l_blob_offset pls_integer := 1;
337: --
338: begin
339: hr_utility.set_location('Entered Procedure clob to blob',120);
340: l_db_nls_lang := userenv('LANGUAGE');
341: l_length_clob := dbms_lob.getlength(p_clob);
342: l_buffer_len := 10666;
343: l_offset := 1;

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

357: l_blob_offset := l_blob_offset + l_raw_buffer_len;
358: l_offset := l_offset + l_chunk_len;
359: l_length_clob := l_length_clob - l_chunk_len;
360: END LOOP;
361: hr_utility.set_location('Finished Procedure clob to blob ',130);
362: END;
363:
364:
365: /*Returns template file as a BLOB*/