55: l_session_date date;
56:
57: begin
58:
59: hr_utility.set_location('hr_nz_tax.other_asg_exists', 10) ;
60:
61: open get_session_date;
62: fetch get_session_date into l_session_date;
63: close get_session_date;
74: end if ;
75:
76: close c_other_asg_exists ;
77:
78: hr_utility.set_location('hr_nz_tax.other_asg_exists', 20) ;
79:
80: return l_return_flag ;
81:
82: exception
80: return l_return_flag ;
81:
82: exception
83: when others then
84: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
85: hr_utility.set_message_token('PROCEDURE', 'hr_nz_tax.other_asg_exists');
86: hr_utility.set_message_token('STEP','body');
87: hr_utility.raise_error ;
88:
81:
82: exception
83: when others then
84: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
85: hr_utility.set_message_token('PROCEDURE', 'hr_nz_tax.other_asg_exists');
86: hr_utility.set_message_token('STEP','body');
87: hr_utility.raise_error ;
88:
89: end other_asg_exists ;
82: exception
83: when others then
84: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
85: hr_utility.set_message_token('PROCEDURE', 'hr_nz_tax.other_asg_exists');
86: hr_utility.set_message_token('STEP','body');
87: hr_utility.raise_error ;
88:
89: end other_asg_exists ;
90:
83: when others then
84: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
85: hr_utility.set_message_token('PROCEDURE', 'hr_nz_tax.other_asg_exists');
86: hr_utility.set_message_token('STEP','body');
87: hr_utility.raise_error ;
88:
89: end other_asg_exists ;
90:
91: