31: procedure assert_seed_data_session_mode is
32: begin
33: IF hr_form_templates_api.g_session_mode = 'SEED_DATA' THEN
34: -- error message
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.raise_error;
37: END IF;
38: end assert_seed_data_session_mode;
39: --
32: begin
33: IF hr_form_templates_api.g_session_mode = 'SEED_DATA' THEN
34: -- error message
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.raise_error;
37: END IF;
38: end assert_seed_data_session_mode;
39: --
40: -- ----------------------------------------------------------------------------
307: -- ask john not in lld
308: IF cur_tmplt_rec%NOTFOUND THEN
309: CLOSE cur_tmplt_rec;
310: -- error message
311: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
312: fnd_message.set_token('PROCEDURE', l_proc);
313: fnd_message.set_token('STEP','10');
314: fnd_message.raise_error;
315: END IF;
308: IF cur_tmplt_rec%NOTFOUND THEN
309: CLOSE cur_tmplt_rec;
310: -- error message
311: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
312: fnd_message.set_token('PROCEDURE', l_proc);
313: fnd_message.set_token('STEP','10');
314: fnd_message.raise_error;
315: END IF;
316: CLOSE cur_tmplt_rec;
309: CLOSE cur_tmplt_rec;
310: -- error message
311: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
312: fnd_message.set_token('PROCEDURE', l_proc);
313: fnd_message.set_token('STEP','10');
314: fnd_message.raise_error;
315: END IF;
316: CLOSE cur_tmplt_rec;
317:
310: -- error message
311: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
312: fnd_message.set_token('PROCEDURE', l_proc);
313: fnd_message.set_token('STEP','10');
314: fnd_message.raise_error;
315: END IF;
316: CLOSE cur_tmplt_rec;
317:
318: hr_utility.set_location('At:'|| l_proc, 30);
1089: IF (cur_api_val%NOTFOUND AND
1090: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1091: CLOSE cur_api_val;
1092: -- error message
1093: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1094: fnd_message.set_token('PROCEDURE', l_proc);
1095: fnd_message.set_token('STEP','10');
1096: fnd_message.raise_error;
1097: END IF;
1090: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1091: CLOSE cur_api_val;
1092: -- error message
1093: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1094: fnd_message.set_token('PROCEDURE', l_proc);
1095: fnd_message.set_token('STEP','10');
1096: fnd_message.raise_error;
1097: END IF;
1098: CLOSE cur_api_val;
1091: CLOSE cur_api_val;
1092: -- error message
1093: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1094: fnd_message.set_token('PROCEDURE', l_proc);
1095: fnd_message.set_token('STEP','10');
1096: fnd_message.raise_error;
1097: END IF;
1098: CLOSE cur_api_val;
1099: --
1092: -- error message
1093: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1094: fnd_message.set_token('PROCEDURE', l_proc);
1095: fnd_message.set_token('STEP','10');
1096: fnd_message.raise_error;
1097: END IF;
1098: CLOSE cur_api_val;
1099: --
1100: --
1415: IF (cur_api_val%NOTFOUND AND
1416: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1417: CLOSE cur_api_val;
1418: -- error message
1419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1420: fnd_message.set_token('PROCEDURE', l_proc);
1421: fnd_message.set_token('STEP','10');
1422: fnd_message.raise_error;
1423: END IF;
1416: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
1417: CLOSE cur_api_val;
1418: -- error message
1419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1420: fnd_message.set_token('PROCEDURE', l_proc);
1421: fnd_message.set_token('STEP','10');
1422: fnd_message.raise_error;
1423: END IF;
1424: CLOSE cur_api_val;
1417: CLOSE cur_api_val;
1418: -- error message
1419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1420: fnd_message.set_token('PROCEDURE', l_proc);
1421: fnd_message.set_token('STEP','10');
1422: fnd_message.raise_error;
1423: END IF;
1424: CLOSE cur_api_val;
1425: --
1418: -- error message
1419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1420: fnd_message.set_token('PROCEDURE', l_proc);
1421: fnd_message.set_token('STEP','10');
1422: fnd_message.raise_error;
1423: END IF;
1424: CLOSE cur_api_val;
1425: --
1426: -- Process Logic