423: THEN
424:
425: CLOSE csr_get_bee_ret_id;
426:
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','no BEE Retrieval Process id');
430: fnd_message.raise_error;
431:
424:
425: CLOSE csr_get_bee_ret_id;
426:
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','no BEE Retrieval Process id');
430: fnd_message.raise_error;
431:
432: END IF;
425: CLOSE csr_get_bee_ret_id;
426:
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','no BEE Retrieval Process id');
430: fnd_message.raise_error;
431:
432: END IF;
433:
426:
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','no BEE Retrieval Process id');
430: fnd_message.raise_error;
431:
432: END IF;
433:
434: CLOSE csr_get_bee_ret_id;
1865:
1866: IF ( l_cnt > 10000 )
1867: THEN
1868:
1869: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1870: fnd_message.set_token('PROCEDURE', l_proc);
1871: fnd_message.set_token('STEP','recovery cannot clean up');
1872: fnd_message.raise_error;
1873:
1866: IF ( l_cnt > 10000 )
1867: THEN
1868:
1869: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1870: fnd_message.set_token('PROCEDURE', l_proc);
1871: fnd_message.set_token('STEP','recovery cannot clean up');
1872: fnd_message.raise_error;
1873:
1874: END IF;
1867: THEN
1868:
1869: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1870: fnd_message.set_token('PROCEDURE', l_proc);
1871: fnd_message.set_token('STEP','recovery cannot clean up');
1872: fnd_message.raise_error;
1873:
1874: END IF;
1875:
1868:
1869: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1870: fnd_message.set_token('PROCEDURE', l_proc);
1871: fnd_message.set_token('STEP','recovery cannot clean up');
1872: fnd_message.raise_error;
1873:
1874: END IF;
1875:
1876: END LOOP;