2963: THEN
2964:
2965: CLOSE csr_get_asg_status_id;
2966:
2967: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2968: fnd_message.set_token('PROCEDURE', l_proc);
2969: fnd_message.set_token('STEP','assignment status');
2970: fnd_message.raise_error;
2971:
2964:
2965: CLOSE csr_get_asg_status_id;
2966:
2967: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2968: fnd_message.set_token('PROCEDURE', l_proc);
2969: fnd_message.set_token('STEP','assignment status');
2970: fnd_message.raise_error;
2971:
2972: END IF;
2965: CLOSE csr_get_asg_status_id;
2966:
2967: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2968: fnd_message.set_token('PROCEDURE', l_proc);
2969: fnd_message.set_token('STEP','assignment status');
2970: fnd_message.raise_error;
2971:
2972: END IF;
2973:
2966:
2967: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2968: fnd_message.set_token('PROCEDURE', l_proc);
2969: fnd_message.set_token('STEP','assignment status');
2970: fnd_message.raise_error;
2971:
2972: END IF;
2973:
2974: CLOSE csr_get_asg_status_id;