APPS.PAY_NL_ABP_REPORT dependencies on HR_UTILITY

Line 35: hr_utility.trace('Exception in get_lookup_value SQL-ERRM : '||SQLERRM);

31: RETURN NULL;
32: WHEN NO_DATA_FOUND THEN
33: RETURN NULL;
34: WHEN OTHERS THEN
35: hr_utility.trace('Exception in get_lookup_value SQL-ERRM : '||SQLERRM);
36:
37: END get_lookup_value;
38: -------------------------------------------------------------------------------
39: -- get_IANA_charset

Line 56: hr_utility.trace('IANA Charset = '||lv_iana_charset);

52: OPEN csr_get_iana_charset;
53: FETCH csr_get_iana_charset INTO lv_iana_charset;
54: CLOSE csr_get_iana_charset;
55:
56: hr_utility.trace('IANA Charset = '||lv_iana_charset);
57: RETURN (LV_IANA_CHARSET);
58: END get_IANA_charset;
59:
60: -- ==============================================================================

Line 71: -- hr_utility.trace('+====c2b===================================================+');

67: buffer RAW(32767);
68: res BLOB;
69: lob_len PLS_INTEGER := dbms_lob.getlength(c);
70: BEGIN
71: -- hr_utility.trace('+====c2b===================================================+');
72: dbms_lob.createtemporary(res,TRUE);
73: dbms_lob.open(res,dbms_lob.lob_readwrite);
74: LOOP
75: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );

Line 82: -- hr_utility.trace('X====c2b===================================================X');

78: END IF;
79: pos := pos + 16000;
80: EXIT WHEN pos > lob_len;
81: END LOOP;
82: -- hr_utility.trace('X====c2b===================================================X');
83: RETURN res;
84: EXCEPTION
85: WHEN others THEN
86: hr_utility.trace('Exception in c2b SQL-ERRM : '||SQLERRM);

Line 86: hr_utility.trace('Exception in c2b SQL-ERRM : '||SQLERRM);

82: -- hr_utility.trace('X====c2b===================================================X');
83: RETURN res;
84: EXCEPTION
85: WHEN others THEN
86: hr_utility.trace('Exception in c2b SQL-ERRM : '||SQLERRM);
87: END c2b;
88:
89: -- ==============================================================================
90: -- Function to replace unallowed characters in XML Values

Line 109: hr_utility.trace('Exception in clean_XML SQL-ERRM :'||SQLERRM);

105: END IF;
106: RETURN l_string;
107: EXCEPTION
108: WHEN others THEN
109: hr_utility.trace('Exception in clean_XML SQL-ERRM :'||SQLERRM);
110: RETURN l_string;
111: END clean_XML;
112:
113: -- ==============================================================================

Line 143: hr_utility.trace('+====report_header_xml========================================+');

139: FROM hr_organization_units
140: WHERE organization_id = p_org_id;
141:
142: BEGIN
143: hr_utility.trace('+====report_header_xml========================================+');
144:
145: l_string := l_string || ''||EOL;
146:
147: pay_nl_abp_archive.get_all_parameters (

Line 181: hr_utility.trace('X====report_header_xml========================================X');

177: CLOSE csr_get_employer;
178: l_string := l_string || ''||clean_XML(l_string_value)||''||EOL;
179: END IF;
180:
181: hr_utility.trace('X====report_header_xml========================================X');
182:
183: RETURN l_string;
184:
185: EXCEPTION

Line 187: hr_utility.trace('Exception in report_header_xml SQL-ERRM : '||SQLERRM);

183: RETURN l_string;
184:
185: EXCEPTION
186: WHEN others THEN
187: hr_utility.trace('Exception in report_header_xml SQL-ERRM : '||SQLERRM);
188: END report_header_xml;
189:
190: -- ==============================================================================
191: -- Procedure to append the details to main report

Line 248: hr_utility.raise_error;

244:
245: EXCEPTION
246: WHEN others THEN
247: fnd_file.put_line(fnd_file.log,'Exception in write_to_clob SQL-ERRM : '||SQLERRM);
248: hr_utility.raise_error;
249: END write_to_clob;
250:
251:
252: PROCEDURE Tag (xCtr IN OUT NOCOPY NUMBER

Line 1040: hr_utility.trace('Exception in GENERATE : '||SQLERRM);

1036: END IF;
1037:
1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: hr_utility.trace('Exception in GENERATE : '||SQLERRM);
1041: raise;
1042: END GENERATE;
1043:
1044: END PAY_NL_ABP_REPORT;