40: exception
41:
42: when OTHERS then
43: retcode := 1;
44: hr_utility.set_message(800, 'HR_78077_P11D_STATUS_CHG_ERR');
45: hr_utility.set_message_token(800, 'ERRORMSG', sqlerrm);
46: errbuf := hr_utility.get_message;
47: hr_utility.raise_error;
48:
41:
42: when OTHERS then
43: retcode := 1;
44: hr_utility.set_message(800, 'HR_78077_P11D_STATUS_CHG_ERR');
45: hr_utility.set_message_token(800, 'ERRORMSG', sqlerrm);
46: errbuf := hr_utility.get_message;
47: hr_utility.raise_error;
48:
49: end update_leg_process_status;
42: when OTHERS then
43: retcode := 1;
44: hr_utility.set_message(800, 'HR_78077_P11D_STATUS_CHG_ERR');
45: hr_utility.set_message_token(800, 'ERRORMSG', sqlerrm);
46: errbuf := hr_utility.get_message;
47: hr_utility.raise_error;
48:
49: end update_leg_process_status;
50:
43: retcode := 1;
44: hr_utility.set_message(800, 'HR_78077_P11D_STATUS_CHG_ERR');
45: hr_utility.set_message_token(800, 'ERRORMSG', sqlerrm);
46: errbuf := hr_utility.get_message;
47: hr_utility.raise_error;
48:
49: end update_leg_process_status;
50:
51: