95:
96: OPEN cur_api_val;
97: FETCH cur_api_val INTO l_temp;
98: IF (cur_api_val%NOTFOUND AND
99: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
100: CLOSE cur_api_val;
101: -- error message
102: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
103: fnd_message.set_token('PROCEDURE', l_proc);
364:
365: OPEN cur_api_val;
366: FETCH cur_api_val INTO l_temp;
367: IF (cur_api_val%NOTFOUND AND
368: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
369: CLOSE cur_api_val;
370: -- error message
371: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
372: fnd_message.set_token('PROCEDURE', l_proc);
612:
613: OPEN cur_api_val;
614: FETCH cur_api_val INTO l_temp;
615: IF (cur_api_val%NOTFOUND AND
616: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
617: CLOSE cur_api_val;
618: -- error message
619: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
620: fnd_message.set_token('PROCEDURE', l_proc);
872:
873: OPEN cur_api_val;
874: FETCH cur_api_val INTO l_temp;
875: IF (cur_api_val%NOTFOUND AND
876: hr_form_templates_api.g_session_mode <> 'SEED_DATA') THEN
877: CLOSE cur_api_val;
878: -- error message
879: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
880: fnd_message.set_token('PROCEDURE', l_proc);