3422: END IF;
3423: END IF;
3424: --
3425: RETURN l_balance_value;
3426: hr_utility.set_location('py_za_bal.get_balance_value',10);
3427: hr_utility.set_location('l_defined_balance_id'||to_char(l_defined_balance_id),10);
3428: hr_utility.set_location('l_balance_value'||to_char(l_balance_value),10);
3429:
3430: EXCEPTION
3423: END IF;
3424: --
3425: RETURN l_balance_value;
3426: hr_utility.set_location('py_za_bal.get_balance_value',10);
3427: hr_utility.set_location('l_defined_balance_id'||to_char(l_defined_balance_id),10);
3428: hr_utility.set_location('l_balance_value'||to_char(l_balance_value),10);
3429:
3430: EXCEPTION
3431: WHEN OTHERS THEN
3424: --
3425: RETURN l_balance_value;
3426: hr_utility.set_location('py_za_bal.get_balance_value',10);
3427: hr_utility.set_location('l_defined_balance_id'||to_char(l_defined_balance_id),10);
3428: hr_utility.set_location('l_balance_value'||to_char(l_balance_value),10);
3429:
3430: EXCEPTION
3431: WHEN OTHERS THEN
3432: hr_utility.set_location('py_za_bal.get_balance_value',20);
3428: hr_utility.set_location('l_balance_value'||to_char(l_balance_value),10);
3429:
3430: EXCEPTION
3431: WHEN OTHERS THEN
3432: hr_utility.set_location('py_za_bal.get_balance_value',20);
3433: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));
3434: hr_utility.raise_error;
3435:
3436: END get_balance_value;
3429:
3430: EXCEPTION
3431: WHEN OTHERS THEN
3432: hr_utility.set_location('py_za_bal.get_balance_value',20);
3433: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));
3434: hr_utility.raise_error;
3435:
3436: END get_balance_value;
3437:
3430: EXCEPTION
3431: WHEN OTHERS THEN
3432: hr_utility.set_location('py_za_bal.get_balance_value',20);
3433: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));
3434: hr_utility.raise_error;
3435:
3436: END get_balance_value;
3437:
3438: -- Bug 4365925
3486: END IF;
3487: END IF;
3488: --
3489: RETURN l_balance_value;
3490: hr_utility.set_location('py_za_bal.get_balance_value',50);
3491: hr_utility.set_location('l_balance_value'||to_char(l_balance_value),50);
3492:
3493: EXCEPTION
3494: WHEN OTHERS THEN
3487: END IF;
3488: --
3489: RETURN l_balance_value;
3490: hr_utility.set_location('py_za_bal.get_balance_value',50);
3491: hr_utility.set_location('l_balance_value'||to_char(l_balance_value),50);
3492:
3493: EXCEPTION
3494: WHEN OTHERS THEN
3495: hr_utility.set_location('py_za_bal.get_balance_value',60);
3491: hr_utility.set_location('l_balance_value'||to_char(l_balance_value),50);
3492:
3493: EXCEPTION
3494: WHEN OTHERS THEN
3495: hr_utility.set_location('py_za_bal.get_balance_value',60);
3496: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));
3497: hr_utility.raise_error;
3498:
3499: END get_balance_value;
3492:
3493: EXCEPTION
3494: WHEN OTHERS THEN
3495: hr_utility.set_location('py_za_bal.get_balance_value',60);
3496: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));
3497: hr_utility.raise_error;
3498:
3499: END get_balance_value;
3500: --Bug 4365925 changes end
3493: EXCEPTION
3494: WHEN OTHERS THEN
3495: hr_utility.set_location('py_za_bal.get_balance_value',60);
3496: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));
3497: hr_utility.raise_error;
3498:
3499: END get_balance_value;
3500: --Bug 4365925 changes end
3501: --
3541: p_assignment_action_id => p_assignment_action_id
3542: );
3543: END IF ;
3544: RETURN l_balance_value;
3545: hr_utility.set_location('py_za_bal.get_balance_value_action',30);
3546: hr_utility.set_location('l_defined_balance_id'||to_char(l_defined_balance_id),30);
3547: hr_utility.set_location('l_balance_value'||to_char(l_balance_value),30);
3548: --
3549: EXCEPTION
3542: );
3543: END IF ;
3544: RETURN l_balance_value;
3545: hr_utility.set_location('py_za_bal.get_balance_value_action',30);
3546: hr_utility.set_location('l_defined_balance_id'||to_char(l_defined_balance_id),30);
3547: hr_utility.set_location('l_balance_value'||to_char(l_balance_value),30);
3548: --
3549: EXCEPTION
3550: WHEN OTHERS THEN
3543: END IF ;
3544: RETURN l_balance_value;
3545: hr_utility.set_location('py_za_bal.get_balance_value_action',30);
3546: hr_utility.set_location('l_defined_balance_id'||to_char(l_defined_balance_id),30);
3547: hr_utility.set_location('l_balance_value'||to_char(l_balance_value),30);
3548: --
3549: EXCEPTION
3550: WHEN OTHERS THEN
3551: hr_utility.set_location('py_za_bal.get_balance_value_action',40);
3547: hr_utility.set_location('l_balance_value'||to_char(l_balance_value),30);
3548: --
3549: EXCEPTION
3550: WHEN OTHERS THEN
3551: hr_utility.set_location('py_za_bal.get_balance_value_action',40);
3552: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));
3553: hr_utility.raise_error;
3554:
3555: END get_balance_value_action;
3548: --
3549: EXCEPTION
3550: WHEN OTHERS THEN
3551: hr_utility.set_location('py_za_bal.get_balance_value_action',40);
3552: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));
3553: hr_utility.raise_error;
3554:
3555: END get_balance_value_action;
3556: --
3549: EXCEPTION
3550: WHEN OTHERS THEN
3551: hr_utility.set_location('py_za_bal.get_balance_value_action',40);
3552: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));
3553: hr_utility.raise_error;
3554:
3555: END get_balance_value_action;
3556: --
3557: ------------------------------------------------------------------