98: IF (cur_api_val%NOTFOUND AND
99: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
100: CLOSE cur_api_val;
101: -- error message
102: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
103: fnd_message.set_token('PROCEDURE', l_proc);
104: fnd_message.set_token('STEP','10');
105: fnd_message.raise_error;
106: END IF;
99: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
100: CLOSE cur_api_val;
101: -- error message
102: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
103: fnd_message.set_token('PROCEDURE', l_proc);
104: fnd_message.set_token('STEP','10');
105: fnd_message.raise_error;
106: END IF;
107: CLOSE cur_api_val;
100: CLOSE cur_api_val;
101: -- error message
102: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
103: fnd_message.set_token('PROCEDURE', l_proc);
104: fnd_message.set_token('STEP','10');
105: fnd_message.raise_error;
106: END IF;
107: CLOSE cur_api_val;
108: --
101: -- error message
102: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
103: fnd_message.set_token('PROCEDURE', l_proc);
104: fnd_message.set_token('STEP','10');
105: fnd_message.raise_error;
106: END IF;
107: CLOSE cur_api_val;
108: --
109: --
367: IF (cur_api_val%NOTFOUND AND
368: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
369: CLOSE cur_api_val;
370: -- error message
371: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE', l_proc);
373: fnd_message.set_token('STEP','10');
374: fnd_message.raise_error;
375: END IF;
368: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
369: CLOSE cur_api_val;
370: -- error message
371: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE', l_proc);
373: fnd_message.set_token('STEP','10');
374: fnd_message.raise_error;
375: END IF;
376: CLOSE cur_api_val;
369: CLOSE cur_api_val;
370: -- error message
371: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE', l_proc);
373: fnd_message.set_token('STEP','10');
374: fnd_message.raise_error;
375: END IF;
376: CLOSE cur_api_val;
377: --
370: -- error message
371: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE', l_proc);
373: fnd_message.set_token('STEP','10');
374: fnd_message.raise_error;
375: END IF;
376: CLOSE cur_api_val;
377: --
378: --
615: IF (cur_api_val%NOTFOUND AND
616: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
617: CLOSE cur_api_val;
618: -- error message
619: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
620: fnd_message.set_token('PROCEDURE', l_proc);
621: fnd_message.set_token('STEP','10');
622: fnd_message.raise_error;
623: END IF;
616: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
617: CLOSE cur_api_val;
618: -- error message
619: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
620: fnd_message.set_token('PROCEDURE', l_proc);
621: fnd_message.set_token('STEP','10');
622: fnd_message.raise_error;
623: END IF;
624: CLOSE cur_api_val;
617: CLOSE cur_api_val;
618: -- error message
619: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
620: fnd_message.set_token('PROCEDURE', l_proc);
621: fnd_message.set_token('STEP','10');
622: fnd_message.raise_error;
623: END IF;
624: CLOSE cur_api_val;
625: --
618: -- error message
619: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
620: fnd_message.set_token('PROCEDURE', l_proc);
621: fnd_message.set_token('STEP','10');
622: fnd_message.raise_error;
623: END IF;
624: CLOSE cur_api_val;
625: --
626: --
875: IF (cur_api_val%NOTFOUND AND
876: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
877: CLOSE cur_api_val;
878: -- error message
879: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
880: fnd_message.set_token('PROCEDURE', l_proc);
881: fnd_message.set_token('STEP','10');
882: fnd_message.raise_error;
883: END IF;
876: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
877: CLOSE cur_api_val;
878: -- error message
879: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
880: fnd_message.set_token('PROCEDURE', l_proc);
881: fnd_message.set_token('STEP','10');
882: fnd_message.raise_error;
883: END IF;
884: CLOSE cur_api_val;
877: CLOSE cur_api_val;
878: -- error message
879: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
880: fnd_message.set_token('PROCEDURE', l_proc);
881: fnd_message.set_token('STEP','10');
882: fnd_message.raise_error;
883: END IF;
884: CLOSE cur_api_val;
885: --
878: -- error message
879: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
880: fnd_message.set_token('PROCEDURE', l_proc);
881: fnd_message.set_token('STEP','10');
882: fnd_message.raise_error;
883: END IF;
884: CLOSE cur_api_val;
885: --
886: --