106: IF (cur_api_val%NOTFOUND AND
107: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
108: CLOSE cur_api_val;
109: -- error message
110: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
111: fnd_message.set_token('PROCEDURE', l_proc);
112: fnd_message.set_token('STEP','10');
113: fnd_message.raise_error;
114: END IF;
107: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
108: CLOSE cur_api_val;
109: -- error message
110: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
111: fnd_message.set_token('PROCEDURE', l_proc);
112: fnd_message.set_token('STEP','10');
113: fnd_message.raise_error;
114: END IF;
115: CLOSE cur_api_val;
108: CLOSE cur_api_val;
109: -- error message
110: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
111: fnd_message.set_token('PROCEDURE', l_proc);
112: fnd_message.set_token('STEP','10');
113: fnd_message.raise_error;
114: END IF;
115: CLOSE cur_api_val;
116: --
109: -- error message
110: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
111: fnd_message.set_token('PROCEDURE', l_proc);
112: fnd_message.set_token('STEP','10');
113: fnd_message.raise_error;
114: END IF;
115: CLOSE cur_api_val;
116: --
117: --
284: IF (cur_api_val%NOTFOUND AND
285: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
286: CLOSE cur_api_val;
287: -- error message
288: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
289: fnd_message.set_token('PROCEDURE', l_proc);
290: fnd_message.set_token('STEP','10');
291: fnd_message.raise_error;
292: END IF;
285: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
286: CLOSE cur_api_val;
287: -- error message
288: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
289: fnd_message.set_token('PROCEDURE', l_proc);
290: fnd_message.set_token('STEP','10');
291: fnd_message.raise_error;
292: END IF;
293: CLOSE cur_api_val;
286: CLOSE cur_api_val;
287: -- error message
288: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
289: fnd_message.set_token('PROCEDURE', l_proc);
290: fnd_message.set_token('STEP','10');
291: fnd_message.raise_error;
292: END IF;
293: CLOSE cur_api_val;
294: --
287: -- error message
288: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
289: fnd_message.set_token('PROCEDURE', l_proc);
290: fnd_message.set_token('STEP','10');
291: fnd_message.raise_error;
292: END IF;
293: CLOSE cur_api_val;
294: --
295: --
455: IF (cur_api_val%NOTFOUND AND
456: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
457: CLOSE cur_api_val;
458: -- error message
459: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
460: fnd_message.set_token('PROCEDURE', l_proc);
461: fnd_message.set_token('STEP','10');
462: fnd_message.raise_error;
463: END IF;
456: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
457: CLOSE cur_api_val;
458: -- error message
459: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
460: fnd_message.set_token('PROCEDURE', l_proc);
461: fnd_message.set_token('STEP','10');
462: fnd_message.raise_error;
463: END IF;
464: CLOSE cur_api_val;
457: CLOSE cur_api_val;
458: -- error message
459: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
460: fnd_message.set_token('PROCEDURE', l_proc);
461: fnd_message.set_token('STEP','10');
462: fnd_message.raise_error;
463: END IF;
464: CLOSE cur_api_val;
465: --
458: -- error message
459: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
460: fnd_message.set_token('PROCEDURE', l_proc);
461: fnd_message.set_token('STEP','10');
462: fnd_message.raise_error;
463: END IF;
464: CLOSE cur_api_val;
465: --
466: --