506: THEN
507:
508: CLOSE csr_get_bee_ret_id;
509:
510: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
511: fnd_message.set_token('PROCEDURE', l_proc);
512: fnd_message.set_token('STEP','no BEE Retrieval Process id');
513: fnd_message.raise_error;
514:
507:
508: CLOSE csr_get_bee_ret_id;
509:
510: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
511: fnd_message.set_token('PROCEDURE', l_proc);
512: fnd_message.set_token('STEP','no BEE Retrieval Process id');
513: fnd_message.raise_error;
514:
515: END IF;
508: CLOSE csr_get_bee_ret_id;
509:
510: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
511: fnd_message.set_token('PROCEDURE', l_proc);
512: fnd_message.set_token('STEP','no BEE Retrieval Process id');
513: fnd_message.raise_error;
514:
515: END IF;
516:
509:
510: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
511: fnd_message.set_token('PROCEDURE', l_proc);
512: fnd_message.set_token('STEP','no BEE Retrieval Process id');
513: fnd_message.raise_error;
514:
515: END IF;
516:
517: CLOSE csr_get_bee_ret_id;
2016:
2017: IF ( l_cnt > 10000 )
2018: THEN
2019:
2020: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2021: fnd_message.set_token('PROCEDURE', l_proc);
2022: fnd_message.set_token('STEP','recovery cannot clean up');
2023: fnd_message.raise_error;
2024:
2017: IF ( l_cnt > 10000 )
2018: THEN
2019:
2020: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2021: fnd_message.set_token('PROCEDURE', l_proc);
2022: fnd_message.set_token('STEP','recovery cannot clean up');
2023: fnd_message.raise_error;
2024:
2025: END IF;
2018: THEN
2019:
2020: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2021: fnd_message.set_token('PROCEDURE', l_proc);
2022: fnd_message.set_token('STEP','recovery cannot clean up');
2023: fnd_message.raise_error;
2024:
2025: END IF;
2026:
2019:
2020: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2021: fnd_message.set_token('PROCEDURE', l_proc);
2022: fnd_message.set_token('STEP','recovery cannot clean up');
2023: fnd_message.raise_error;
2024:
2025: END IF;
2026:
2027: END LOOP;