100: IF (cur_api_val%NOTFOUND AND
101: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
102: CLOSE cur_api_val;
103: -- error message
104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
105: fnd_message.set_token('PROCEDURE', l_proc);
106: fnd_message.set_token('STEP','10');
107: fnd_message.raise_error;
108: END IF;
101: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
102: CLOSE cur_api_val;
103: -- error message
104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
105: fnd_message.set_token('PROCEDURE', l_proc);
106: fnd_message.set_token('STEP','10');
107: fnd_message.raise_error;
108: END IF;
109: CLOSE cur_api_val;
102: CLOSE cur_api_val;
103: -- error message
104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
105: fnd_message.set_token('PROCEDURE', l_proc);
106: fnd_message.set_token('STEP','10');
107: fnd_message.raise_error;
108: END IF;
109: CLOSE cur_api_val;
110: --
103: -- error message
104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
105: fnd_message.set_token('PROCEDURE', l_proc);
106: fnd_message.set_token('STEP','10');
107: fnd_message.raise_error;
108: END IF;
109: CLOSE cur_api_val;
110: --
111: -- Process Logic
361: IF (cur_api_val%NOTFOUND AND
362: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
363: CLOSE cur_api_val;
364: -- error message
365: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
366: fnd_message.set_token('PROCEDURE', l_proc);
367: fnd_message.set_token('STEP','10');
368: fnd_message.raise_error;
369: END IF;
362: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
363: CLOSE cur_api_val;
364: -- error message
365: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
366: fnd_message.set_token('PROCEDURE', l_proc);
367: fnd_message.set_token('STEP','10');
368: fnd_message.raise_error;
369: END IF;
370: CLOSE cur_api_val;
363: CLOSE cur_api_val;
364: -- error message
365: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
366: fnd_message.set_token('PROCEDURE', l_proc);
367: fnd_message.set_token('STEP','10');
368: fnd_message.raise_error;
369: END IF;
370: CLOSE cur_api_val;
371: --
364: -- error message
365: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
366: fnd_message.set_token('PROCEDURE', l_proc);
367: fnd_message.set_token('STEP','10');
368: fnd_message.raise_error;
369: END IF;
370: CLOSE cur_api_val;
371: --
372: --
604: IF (cur_api_val%NOTFOUND AND
605: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
606: CLOSE cur_api_val;
607: -- error message
608: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
609: fnd_message.set_token('PROCEDURE', l_proc);
610: fnd_message.set_token('STEP','10');
611: fnd_message.raise_error;
612: END IF;
605: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
606: CLOSE cur_api_val;
607: -- error message
608: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
609: fnd_message.set_token('PROCEDURE', l_proc);
610: fnd_message.set_token('STEP','10');
611: fnd_message.raise_error;
612: END IF;
613: CLOSE cur_api_val;
606: CLOSE cur_api_val;
607: -- error message
608: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
609: fnd_message.set_token('PROCEDURE', l_proc);
610: fnd_message.set_token('STEP','10');
611: fnd_message.raise_error;
612: END IF;
613: CLOSE cur_api_val;
614: --
607: -- error message
608: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
609: fnd_message.set_token('PROCEDURE', l_proc);
610: fnd_message.set_token('STEP','10');
611: fnd_message.raise_error;
612: END IF;
613: CLOSE cur_api_val;
614: --
615: --
830: IF (cur_api_val%NOTFOUND AND
831: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
832: CLOSE cur_api_val;
833: -- error message
834: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
835: fnd_message.set_token('PROCEDURE', l_proc);
836: fnd_message.set_token('STEP','10');
837: fnd_message.raise_error;
838: END IF;
831: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
832: CLOSE cur_api_val;
833: -- error message
834: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
835: fnd_message.set_token('PROCEDURE', l_proc);
836: fnd_message.set_token('STEP','10');
837: fnd_message.raise_error;
838: END IF;
839: CLOSE cur_api_val;
832: CLOSE cur_api_val;
833: -- error message
834: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
835: fnd_message.set_token('PROCEDURE', l_proc);
836: fnd_message.set_token('STEP','10');
837: fnd_message.raise_error;
838: END IF;
839: CLOSE cur_api_val;
840: --
833: -- error message
834: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
835: fnd_message.set_token('PROCEDURE', l_proc);
836: fnd_message.set_token('STEP','10');
837: fnd_message.raise_error;
838: END IF;
839: CLOSE cur_api_val;
840: --
841: --