76: IF (cur_api_val%NOTFOUND AND
77: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
78: CLOSE cur_api_val;
79: -- error message
80: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
81: fnd_message.set_token('PROCEDURE', l_proc);
82: fnd_message.set_token('STEP','10');
83: fnd_message.raise_error;
84: END IF;
77: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
78: CLOSE cur_api_val;
79: -- error message
80: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
81: fnd_message.set_token('PROCEDURE', l_proc);
82: fnd_message.set_token('STEP','10');
83: fnd_message.raise_error;
84: END IF;
85: CLOSE cur_api_val;
78: CLOSE cur_api_val;
79: -- error message
80: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
81: fnd_message.set_token('PROCEDURE', l_proc);
82: fnd_message.set_token('STEP','10');
83: fnd_message.raise_error;
84: END IF;
85: CLOSE cur_api_val;
86:
79: -- error message
80: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
81: fnd_message.set_token('PROCEDURE', l_proc);
82: fnd_message.set_token('STEP','10');
83: fnd_message.raise_error;
84: END IF;
85: CLOSE cur_api_val;
86:
87: --
214: IF (cur_api_val%NOTFOUND AND
215: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
216: CLOSE cur_api_val;
217: -- error message
218: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
219: fnd_message.set_token('PROCEDURE', l_proc);
220: fnd_message.set_token('STEP','10');
221: fnd_message.raise_error;
222: END IF;
215: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
216: CLOSE cur_api_val;
217: -- error message
218: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
219: fnd_message.set_token('PROCEDURE', l_proc);
220: fnd_message.set_token('STEP','10');
221: fnd_message.raise_error;
222: END IF;
223: CLOSE cur_api_val;
216: CLOSE cur_api_val;
217: -- error message
218: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
219: fnd_message.set_token('PROCEDURE', l_proc);
220: fnd_message.set_token('STEP','10');
221: fnd_message.raise_error;
222: END IF;
223: CLOSE cur_api_val;
224:
217: -- error message
218: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
219: fnd_message.set_token('PROCEDURE', l_proc);
220: fnd_message.set_token('STEP','10');
221: fnd_message.raise_error;
222: END IF;
223: CLOSE cur_api_val;
224:
225: hr_utility.set_location('At:'|| l_proc, 20);