708: IF (cur_api_val%NOTFOUND AND
709: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
710: CLOSE cur_api_val;
711: -- error message
712: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
713: fnd_message.set_token('PROCEDURE', l_proc);
714: fnd_message.set_token('STEP','10');
715: fnd_message.raise_error;
716: END IF;
709: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
710: CLOSE cur_api_val;
711: -- error message
712: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
713: fnd_message.set_token('PROCEDURE', l_proc);
714: fnd_message.set_token('STEP','10');
715: fnd_message.raise_error;
716: END IF;
717: CLOSE cur_api_val;
710: CLOSE cur_api_val;
711: -- error message
712: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
713: fnd_message.set_token('PROCEDURE', l_proc);
714: fnd_message.set_token('STEP','10');
715: fnd_message.raise_error;
716: END IF;
717: CLOSE cur_api_val;
718: --
711: -- error message
712: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
713: fnd_message.set_token('PROCEDURE', l_proc);
714: fnd_message.set_token('STEP','10');
715: fnd_message.raise_error;
716: END IF;
717: CLOSE cur_api_val;
718: --
719: --
1085: IF (cur_api_val%NOTFOUND AND
1086: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1087: CLOSE cur_api_val;
1088: -- error message
1089: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1090: fnd_message.set_token('PROCEDURE', l_proc);
1091: fnd_message.set_token('STEP','10');
1092: fnd_message.raise_error;
1093: END IF;
1086: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1087: CLOSE cur_api_val;
1088: -- error message
1089: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1090: fnd_message.set_token('PROCEDURE', l_proc);
1091: fnd_message.set_token('STEP','10');
1092: fnd_message.raise_error;
1093: END IF;
1094: CLOSE cur_api_val;
1087: CLOSE cur_api_val;
1088: -- error message
1089: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1090: fnd_message.set_token('PROCEDURE', l_proc);
1091: fnd_message.set_token('STEP','10');
1092: fnd_message.raise_error;
1093: END IF;
1094: CLOSE cur_api_val;
1095:
1088: -- error message
1089: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1090: fnd_message.set_token('PROCEDURE', l_proc);
1091: fnd_message.set_token('STEP','10');
1092: fnd_message.raise_error;
1093: END IF;
1094: CLOSE cur_api_val;
1095:
1096: hr_utility.set_location('Entering:'|| l_proc, 35);
1418: IF (cur_api_val%NOTFOUND AND
1419: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1420: CLOSE cur_api_val;
1421: -- error message
1422: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1423: fnd_message.set_token('PROCEDURE', l_proc);
1424: fnd_message.set_token('STEP','10');
1425: fnd_message.raise_error;
1426: END IF;
1419: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1420: CLOSE cur_api_val;
1421: -- error message
1422: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1423: fnd_message.set_token('PROCEDURE', l_proc);
1424: fnd_message.set_token('STEP','10');
1425: fnd_message.raise_error;
1426: END IF;
1427: CLOSE cur_api_val;
1420: CLOSE cur_api_val;
1421: -- error message
1422: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1423: fnd_message.set_token('PROCEDURE', l_proc);
1424: fnd_message.set_token('STEP','10');
1425: fnd_message.raise_error;
1426: END IF;
1427: CLOSE cur_api_val;
1428: --
1421: -- error message
1422: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1423: fnd_message.set_token('PROCEDURE', l_proc);
1424: fnd_message.set_token('STEP','10');
1425: fnd_message.raise_error;
1426: END IF;
1427: CLOSE cur_api_val;
1428: --
1429: --
1770: IF (cur_api_val%NOTFOUND AND
1771: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1772: CLOSE cur_api_val;
1773: -- error message
1774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1775: fnd_message.set_token('PROCEDURE', l_proc);
1776: fnd_message.set_token('STEP','10');
1777: fnd_message.raise_error;
1778: END IF;
1771: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1772: CLOSE cur_api_val;
1773: -- error message
1774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1775: fnd_message.set_token('PROCEDURE', l_proc);
1776: fnd_message.set_token('STEP','10');
1777: fnd_message.raise_error;
1778: END IF;
1779: CLOSE cur_api_val;
1772: CLOSE cur_api_val;
1773: -- error message
1774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1775: fnd_message.set_token('PROCEDURE', l_proc);
1776: fnd_message.set_token('STEP','10');
1777: fnd_message.raise_error;
1778: END IF;
1779: CLOSE cur_api_val;
1780:
1773: -- error message
1774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1775: fnd_message.set_token('PROCEDURE', l_proc);
1776: fnd_message.set_token('STEP','10');
1777: fnd_message.raise_error;
1778: END IF;
1779: CLOSE cur_api_val;
1780:
1781: hr_utility.set_location('Entering:'|| l_proc, 35);