344: );
345: end if;
346: else
347: close csr_competence_element;
348: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
349: fnd_message.set_token('PROCEDURE', l_proc);
350: fnd_message.set_token('STEP','5');
351: fnd_message.raise_error;
352: end if;
345: end if;
346: else
347: close csr_competence_element;
348: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
349: fnd_message.set_token('PROCEDURE', l_proc);
350: fnd_message.set_token('STEP','5');
351: fnd_message.raise_error;
352: end if;
353: end if;
346: else
347: close csr_competence_element;
348: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
349: fnd_message.set_token('PROCEDURE', l_proc);
350: fnd_message.set_token('STEP','5');
351: fnd_message.raise_error;
352: end if;
353: end if;
354:
347: close csr_competence_element;
348: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
349: fnd_message.set_token('PROCEDURE', l_proc);
350: fnd_message.set_token('STEP','5');
351: fnd_message.raise_error;
352: end if;
353: end if;
354:
355: hr_utility.set_location(l_proc, 90);
874: );
875: end if;
876: else
877: close csr_competence_element;
878: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
879: fnd_message.set_token('PROCEDURE', l_proc);
880: fnd_message.set_token('STEP','5');
881: fnd_message.raise_error;
882: end if;
875: end if;
876: else
877: close csr_competence_element;
878: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
879: fnd_message.set_token('PROCEDURE', l_proc);
880: fnd_message.set_token('STEP','5');
881: fnd_message.raise_error;
882: end if;
883:
876: else
877: close csr_competence_element;
878: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
879: fnd_message.set_token('PROCEDURE', l_proc);
880: fnd_message.set_token('STEP','5');
881: fnd_message.raise_error;
882: end if;
883:
884: hr_utility.set_location(l_proc, 60);
877: close csr_competence_element;
878: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
879: fnd_message.set_token('PROCEDURE', l_proc);
880: fnd_message.set_token('STEP','5');
881: fnd_message.raise_error;
882: end if;
883:
884: hr_utility.set_location(l_proc, 60);
885: