181: IF (cur_api_val%NOTFOUND AND
182: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
183: CLOSE cur_api_val;
184: -- error message
185: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
186: fnd_message.set_token('PROCEDURE', l_proc);
187: fnd_message.set_token('STEP','10');
188: fnd_message.raise_error;
189: END IF;
182: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
183: CLOSE cur_api_val;
184: -- error message
185: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
186: fnd_message.set_token('PROCEDURE', l_proc);
187: fnd_message.set_token('STEP','10');
188: fnd_message.raise_error;
189: END IF;
190: CLOSE cur_api_val;
183: CLOSE cur_api_val;
184: -- error message
185: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
186: fnd_message.set_token('PROCEDURE', l_proc);
187: fnd_message.set_token('STEP','10');
188: fnd_message.raise_error;
189: END IF;
190: CLOSE cur_api_val;
191: --
184: -- error message
185: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
186: fnd_message.set_token('PROCEDURE', l_proc);
187: fnd_message.set_token('STEP','10');
188: fnd_message.raise_error;
189: END IF;
190: CLOSE cur_api_val;
191: --
192: --
658: IF (cur_api_val%NOTFOUND AND
659: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
660: CLOSE cur_api_val;
661: -- error message
662: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
663: fnd_message.set_token('PROCEDURE', l_proc);
664: fnd_message.set_token('STEP','10');
665: fnd_message.raise_error;
666: END IF;
659: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
660: CLOSE cur_api_val;
661: -- error message
662: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
663: fnd_message.set_token('PROCEDURE', l_proc);
664: fnd_message.set_token('STEP','10');
665: fnd_message.raise_error;
666: END IF;
667: CLOSE cur_api_val;
660: CLOSE cur_api_val;
661: -- error message
662: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
663: fnd_message.set_token('PROCEDURE', l_proc);
664: fnd_message.set_token('STEP','10');
665: fnd_message.raise_error;
666: END IF;
667: CLOSE cur_api_val;
668:
661: -- error message
662: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
663: fnd_message.set_token('PROCEDURE', l_proc);
664: fnd_message.set_token('STEP','10');
665: fnd_message.raise_error;
666: END IF;
667: CLOSE cur_api_val;
668:
669: hr_utility.set_location('At:'|| l_proc, 35);
1048: IF (cur_api_val%NOTFOUND AND
1049: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1050: CLOSE cur_api_val;
1051: -- error message
1052: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1053: fnd_message.set_token('PROCEDURE', l_proc);
1054: fnd_message.set_token('STEP','10');
1055: fnd_message.raise_error;
1056: END IF;
1049: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1050: CLOSE cur_api_val;
1051: -- error message
1052: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1053: fnd_message.set_token('PROCEDURE', l_proc);
1054: fnd_message.set_token('STEP','10');
1055: fnd_message.raise_error;
1056: END IF;
1057: CLOSE cur_api_val;
1050: CLOSE cur_api_val;
1051: -- error message
1052: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1053: fnd_message.set_token('PROCEDURE', l_proc);
1054: fnd_message.set_token('STEP','10');
1055: fnd_message.raise_error;
1056: END IF;
1057: CLOSE cur_api_val;
1058: --
1051: -- error message
1052: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1053: fnd_message.set_token('PROCEDURE', l_proc);
1054: fnd_message.set_token('STEP','10');
1055: fnd_message.raise_error;
1056: END IF;
1057: CLOSE cur_api_val;
1058: --
1059: --
1463: IF (cur_api_val%NOTFOUND AND
1464: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1465: CLOSE cur_api_val;
1466: -- error message
1467: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1468: fnd_message.set_token('PROCEDURE', l_proc);
1469: fnd_message.set_token('STEP','10');
1470: fnd_message.raise_error;
1471: END IF;
1464: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1465: CLOSE cur_api_val;
1466: -- error message
1467: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1468: fnd_message.set_token('PROCEDURE', l_proc);
1469: fnd_message.set_token('STEP','10');
1470: fnd_message.raise_error;
1471: END IF;
1472: CLOSE cur_api_val;
1465: CLOSE cur_api_val;
1466: -- error message
1467: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1468: fnd_message.set_token('PROCEDURE', l_proc);
1469: fnd_message.set_token('STEP','10');
1470: fnd_message.raise_error;
1471: END IF;
1472: CLOSE cur_api_val;
1473: hr_utility.set_location('At:'|| l_proc, 35);
1466: -- error message
1467: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1468: fnd_message.set_token('PROCEDURE', l_proc);
1469: fnd_message.set_token('STEP','10');
1470: fnd_message.raise_error;
1471: END IF;
1472: CLOSE cur_api_val;
1473: hr_utility.set_location('At:'|| l_proc, 35);
1474: