DBA Data[Home] [Help]

APPS.PAY_SE_TETR dependencies on HR_UTILITY

Line 109: hr_utility.set_location('Entered Procedure GETDATA',10);

105: l_payroll_action_id :=p_payroll_action_id;
106:
107: END IF;
108:
109: hr_utility.set_location('Entered Procedure GETDATA',10);
110:
111:
112: OPEN csr_tetr_footer_rpt( l_payroll_action_id);
113: FETCH csr_tetr_footer_rpt INTO rg_tetr_footer_rpt;

Line 254: hr_utility.set_location('After populating pl/sql table',30);

250: l_counter := l_counter + 1;
251:
252: END LOOP;
253:
254: hr_utility.set_location('After populating pl/sql table',30);
255:
256:
257: WritetoCLOB (p_xml );
258:

Line 282: hr_utility.set_location('Entering WritetoCLOB ',70);

278: l_IANA_charset VARCHAR2 (50);
279:
280: BEGIN
281: l_IANA_charset :=hr_se_utility.get_IANA_charset ;
282: hr_utility.set_location('Entering WritetoCLOB ',70);
283: l_str1 := ' ' ;
284: l_str2 := '<';
285: l_str3 := '>';
286: l_str4 := '

Line 359: hr_utility.set_location('Leaving WritetoCLOB ',40);

355: END IF;
356:
357: p_xfdf_clob := l_xfdf_string;
358:
359: hr_utility.set_location('Leaving WritetoCLOB ',40);
360:
361: EXCEPTION
362: WHEN OTHERS then
363: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);

Line 363: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);

359: hr_utility.set_location('Leaving WritetoCLOB ',40);
360:
361: EXCEPTION
362: WHEN OTHERS then
363: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
364: HR_UTILITY.RAISE_ERROR;
365: END WritetoCLOB;
366: -------------------------------------------------------------------------------------------------------------------------
367:

Line 364: HR_UTILITY.RAISE_ERROR;

360:
361: EXCEPTION
362: WHEN OTHERS then
363: HR_UTILITY.TRACE('sqlerrm ' || SQLERRM);
364: HR_UTILITY.RAISE_ERROR;
365: END WritetoCLOB;
366: -------------------------------------------------------------------------------------------------------------------------
367:
368: END PAY_SE_TETR;