DBA Data[Home] [Help]

APPS.HR_GB_UTILITY dependencies on HR_UTILITY

Line 130: hr_utility.trace('Lower case chars found: '||l_translated_value);

126: l_invalid_char||l_char_chk||l_number_chk,
127: l_invalid_char);
128:
129: if l_translated_value is not null then
130: hr_utility.trace('Lower case chars found: '||l_translated_value);
131: l_return_code := 5; -- Not valid
132: end if;
133:
134: l_ni_number := upper(p_ni_number);

Line 222: hr_utility.set_location('Entering:'|| l_proc, 5);

218: l_proc varchar2(72) := 'hr_gb_utility.tax_code_validate';
219: --
220: begin
221: --
222: hr_utility.set_location('Entering:'|| l_proc, 5);
223: --
224: BEGIN
225: select formula_id,effective_start_date
226: into l_formula_id, l_effective_start_date

Line 233: hr_utility.trace('Error: TAX_CODE formula not defined');

229: and business_group_id is null
230: and legislation_code='GB'
231: and p_effective_date between effective_start_date and effective_end_date;
232: EXCEPTION WHEN NO_DATA_FOUND THEN
233: hr_utility.trace('Error: TAX_CODE formula not defined');
234: l_return_value := 'TAX_CODE formula not found';
235: END;
236: --
237: hr_utility.set_location(l_proc, 10);

Line 237: hr_utility.set_location(l_proc, 10);

233: hr_utility.trace('Error: TAX_CODE formula not defined');
234: l_return_value := 'TAX_CODE formula not found';
235: END;
236: --
237: hr_utility.set_location(l_proc, 10);
238: --
239: ff_exec.init_formula(l_formula_id,l_effective_start_date,l_inputs,l_outputs);
240: --
241: for l_in_cnt in

Line 257: hr_utility.set_location(l_proc, 15);

253: l_inputs(l_in_cnt).value := to_char(p_assignment_id);
254: end if;
255: end loop;
256: --
257: hr_utility.set_location(l_proc, 15);
258: --
259: ff_exec.run_formula(l_inputs,l_outputs);
260: --
261: for l_out_cnt in

Line 273: hr_utility.set_location('Leaving:'|| l_proc, 20);

269: l_status_value := l_outputs(l_out_cnt).value;
270: end if;
271: end loop;
272: --
273: hr_utility.set_location('Leaving:'|| l_proc, 20);
274: --
275: if l_status_value = 'E' and
276: l_formula_mesg is null then
277: l_return_value := 'TAX_CODE Formula error';

Line 284: hr_utility.set_location('Leaving:'|| l_proc, 22);

280: end if;
281: return l_return_value;
282: exception
283: when NO_DATA_FOUND then
284: hr_utility.set_location('Leaving:'|| l_proc, 22);
285: --
286: return l_return_value;
287: --
288: end tax_code_validate;