DBA Data[Home] [Help]

APPS.PY_ZA_BAL dependencies on HR_UTILITY

Line 3426: hr_utility.set_location('py_za_bal.get_balance_value',10);

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

Line 3427: hr_utility.set_location('l_defined_balance_id'||to_char(l_defined_balance_id),10);

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

Line 3428: hr_utility.set_location('l_balance_value'||to_char(l_balance_value),10);

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);

Line 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;

Line 3433: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));

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:

Line 3434: hr_utility.raise_error;

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

Line 3490: hr_utility.set_location('py_za_bal.get_balance_value',50);

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

Line 3491: hr_utility.set_location('l_balance_value'||to_char(l_balance_value),50);

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);

Line 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;

Line 3496: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));

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

Line 3497: hr_utility.raise_error;

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: --

Line 3545: hr_utility.set_location('py_za_bal.get_balance_value_action',30);

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

Line 3546: hr_utility.set_location('l_defined_balance_id'||to_char(l_defined_balance_id),30);

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

Line 3547: hr_utility.set_location('l_balance_value'||to_char(l_balance_value),30);

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);

Line 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;

Line 3552: hr_utility.set_message(801,'Sql Err Code: '||to_char(sqlcode));

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: --

Line 3553: hr_utility.raise_error;

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: ------------------------------------------------------------------