74: CLOSE csr_bal;
75:
76: hr_utility.trace (' Balance Value : '||l_value);
77: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 20);
78: RETURN fnd_number.canonical_to_number(NVL(l_value,'0'));
79:
80: EXCEPTION
81: WHEN OTHERS THEN
82: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 30);
156:
157: hr_utility.trace (' Element Value : '||l_value);
158: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 20);
159:
160: RETURN fnd_number.canonical_to_number(NVL(l_value,'0'));
161:
162: EXCEPTION
163: WHEN OTHERS THEN
164: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 30);
238:
239: hr_utility.trace (' Element Value : '||l_value);
240: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 20);
241:
242: RETURN fnd_number.canonical_to_number(NVL(l_value,'0'));
243:
244: EXCEPTION
245: WHEN OTHERS THEN
246: hr_utility.set_location( 'Leaving:'|| l_procedure_name, 30);