90: IF (cur_api_val%NOTFOUND AND
91: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
92: CLOSE cur_api_val;
93: -- error message
94: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('STEP','10');
97: fnd_message.raise_error;
98: END IF;
91: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
92: CLOSE cur_api_val;
93: -- error message
94: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('STEP','10');
97: fnd_message.raise_error;
98: END IF;
99: CLOSE cur_api_val;
92: CLOSE cur_api_val;
93: -- error message
94: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('STEP','10');
97: fnd_message.raise_error;
98: END IF;
99: CLOSE cur_api_val;
100: --
93: -- error message
94: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('STEP','10');
97: fnd_message.raise_error;
98: END IF;
99: CLOSE cur_api_val;
100: --
101: -- Process Logic
258: IF (cur_api_val%NOTFOUND AND
259: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
260: CLOSE cur_api_val;
261: -- error message
262: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
263: fnd_message.set_token('PROCEDURE', l_proc);
264: fnd_message.set_token('STEP','10');
265: fnd_message.raise_error;
266: END IF;
259: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
260: CLOSE cur_api_val;
261: -- error message
262: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
263: fnd_message.set_token('PROCEDURE', l_proc);
264: fnd_message.set_token('STEP','10');
265: fnd_message.raise_error;
266: END IF;
267: CLOSE cur_api_val;
260: CLOSE cur_api_val;
261: -- error message
262: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
263: fnd_message.set_token('PROCEDURE', l_proc);
264: fnd_message.set_token('STEP','10');
265: fnd_message.raise_error;
266: END IF;
267: CLOSE cur_api_val;
268: --
261: -- error message
262: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
263: fnd_message.set_token('PROCEDURE', l_proc);
264: fnd_message.set_token('STEP','10');
265: fnd_message.raise_error;
266: END IF;
267: CLOSE cur_api_val;
268: --
269: --