257: --
258: IF ( p_tab_page_property_id is not null) AND
259: (p_form_tab_page_id is not null OR p_template_tab_page_id is not null) THEN
260: -- error message
261: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
262: fnd_message.set_token('PROCEDURE', l_proc);
263: fnd_message.set_token('STEP','10');
264: fnd_message.raise_error;
265: ELSIF ( p_form_tab_page_id is not null) AND
258: IF ( p_tab_page_property_id is not null) AND
259: (p_form_tab_page_id is not null OR p_template_tab_page_id is not null) THEN
260: -- error message
261: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
262: fnd_message.set_token('PROCEDURE', l_proc);
263: fnd_message.set_token('STEP','10');
264: fnd_message.raise_error;
265: ELSIF ( p_form_tab_page_id is not null) AND
266: (p_tab_page_property_id is not null OR
259: (p_form_tab_page_id is not null OR p_template_tab_page_id is not null) THEN
260: -- error message
261: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
262: fnd_message.set_token('PROCEDURE', l_proc);
263: fnd_message.set_token('STEP','10');
264: fnd_message.raise_error;
265: ELSIF ( p_form_tab_page_id is not null) AND
266: (p_tab_page_property_id is not null OR
267: p_template_tab_page_id is not null) THEN
260: -- error message
261: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
262: fnd_message.set_token('PROCEDURE', l_proc);
263: fnd_message.set_token('STEP','10');
264: fnd_message.raise_error;
265: ELSIF ( p_form_tab_page_id is not null) AND
266: (p_tab_page_property_id is not null OR
267: p_template_tab_page_id is not null) THEN
268: -- error message
265: ELSIF ( p_form_tab_page_id is not null) AND
266: (p_tab_page_property_id is not null OR
267: p_template_tab_page_id is not null) THEN
268: -- error message
269: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
270: fnd_message.set_token('PROCEDURE', l_proc);
271: fnd_message.set_token('STEP','10');
272: fnd_message.raise_error;
273: ELSIF ( p_template_tab_page_id is not null) AND
266: (p_tab_page_property_id is not null OR
267: p_template_tab_page_id is not null) THEN
268: -- error message
269: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
270: fnd_message.set_token('PROCEDURE', l_proc);
271: fnd_message.set_token('STEP','10');
272: fnd_message.raise_error;
273: ELSIF ( p_template_tab_page_id is not null) AND
274: (p_tab_page_property_id is not null OR p_form_tab_page_id is not null) THEN
267: p_template_tab_page_id is not null) THEN
268: -- error message
269: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
270: fnd_message.set_token('PROCEDURE', l_proc);
271: fnd_message.set_token('STEP','10');
272: fnd_message.raise_error;
273: ELSIF ( p_template_tab_page_id is not null) AND
274: (p_tab_page_property_id is not null OR p_form_tab_page_id is not null) THEN
275: -- error message
268: -- error message
269: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
270: fnd_message.set_token('PROCEDURE', l_proc);
271: fnd_message.set_token('STEP','10');
272: fnd_message.raise_error;
273: ELSIF ( p_template_tab_page_id is not null) AND
274: (p_tab_page_property_id is not null OR p_form_tab_page_id is not null) THEN
275: -- error message
276: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
272: fnd_message.raise_error;
273: ELSIF ( p_template_tab_page_id is not null) AND
274: (p_tab_page_property_id is not null OR p_form_tab_page_id is not null) THEN
275: -- error message
276: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
277: fnd_message.set_token('PROCEDURE', l_proc);
278: fnd_message.set_token('STEP','10');
279: fnd_message.raise_error;
280: END IF;
273: ELSIF ( p_template_tab_page_id is not null) AND
274: (p_tab_page_property_id is not null OR p_form_tab_page_id is not null) THEN
275: -- error message
276: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
277: fnd_message.set_token('PROCEDURE', l_proc);
278: fnd_message.set_token('STEP','10');
279: fnd_message.raise_error;
280: END IF;
281:
274: (p_tab_page_property_id is not null OR p_form_tab_page_id is not null) THEN
275: -- error message
276: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
277: fnd_message.set_token('PROCEDURE', l_proc);
278: fnd_message.set_token('STEP','10');
279: fnd_message.raise_error;
280: END IF;
281:
282: --
275: -- error message
276: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
277: fnd_message.set_token('PROCEDURE', l_proc);
278: fnd_message.set_token('STEP','10');
279: fnd_message.raise_error;
280: END IF;
281:
282: --
283: -- Process Logic
415: --
416: IF ( p_tab_page_property_id is not null) AND
417: (p_form_tab_page_id is not null OR p_template_tab_page_id is not null) THEN
418: -- error message
419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
420: fnd_message.set_token('PROCEDURE', l_proc);
421: fnd_message.set_token('STEP','10');
422: fnd_message.raise_error;
423: ELSIF ( p_form_tab_page_id is not null) AND
416: IF ( p_tab_page_property_id is not null) AND
417: (p_form_tab_page_id is not null OR p_template_tab_page_id is not null) THEN
418: -- error message
419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
420: fnd_message.set_token('PROCEDURE', l_proc);
421: fnd_message.set_token('STEP','10');
422: fnd_message.raise_error;
423: ELSIF ( p_form_tab_page_id is not null) AND
424: (p_tab_page_property_id is not null OR
417: (p_form_tab_page_id is not null OR p_template_tab_page_id is not null) THEN
418: -- error message
419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
420: fnd_message.set_token('PROCEDURE', l_proc);
421: fnd_message.set_token('STEP','10');
422: fnd_message.raise_error;
423: ELSIF ( p_form_tab_page_id is not null) AND
424: (p_tab_page_property_id is not null OR
425: p_template_tab_page_id is not null) THEN
418: -- error message
419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
420: fnd_message.set_token('PROCEDURE', l_proc);
421: fnd_message.set_token('STEP','10');
422: fnd_message.raise_error;
423: ELSIF ( p_form_tab_page_id is not null) AND
424: (p_tab_page_property_id is not null OR
425: p_template_tab_page_id is not null) THEN
426: -- error message
423: ELSIF ( p_form_tab_page_id is not null) AND
424: (p_tab_page_property_id is not null OR
425: p_template_tab_page_id is not null) THEN
426: -- error message
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','10');
430: fnd_message.raise_error;
431: ELSIF ( p_template_tab_page_id is not null) AND
424: (p_tab_page_property_id is not null OR
425: p_template_tab_page_id is not null) THEN
426: -- error message
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','10');
430: fnd_message.raise_error;
431: ELSIF ( p_template_tab_page_id is not null) AND
432: (p_tab_page_property_id is not null OR p_form_tab_page_id is not null) THEN
425: p_template_tab_page_id is not null) THEN
426: -- error message
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','10');
430: fnd_message.raise_error;
431: ELSIF ( p_template_tab_page_id is not null) AND
432: (p_tab_page_property_id is not null OR p_form_tab_page_id is not null) THEN
433: -- error message
426: -- error message
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','10');
430: fnd_message.raise_error;
431: ELSIF ( p_template_tab_page_id is not null) AND
432: (p_tab_page_property_id is not null OR p_form_tab_page_id is not null) THEN
433: -- error message
434: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
430: fnd_message.raise_error;
431: ELSIF ( p_template_tab_page_id is not null) AND
432: (p_tab_page_property_id is not null OR p_form_tab_page_id is not null) THEN
433: -- error message
434: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
435: fnd_message.set_token('PROCEDURE', l_proc);
436: fnd_message.set_token('STEP','10');
437: fnd_message.raise_error;
438: END IF;
431: ELSIF ( p_template_tab_page_id is not null) AND
432: (p_tab_page_property_id is not null OR p_form_tab_page_id is not null) THEN
433: -- error message
434: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
435: fnd_message.set_token('PROCEDURE', l_proc);
436: fnd_message.set_token('STEP','10');
437: fnd_message.raise_error;
438: END IF;
439:
432: (p_tab_page_property_id is not null OR p_form_tab_page_id is not null) THEN
433: -- error message
434: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
435: fnd_message.set_token('PROCEDURE', l_proc);
436: fnd_message.set_token('STEP','10');
437: fnd_message.raise_error;
438: END IF;
439:
440: --
433: -- error message
434: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
435: fnd_message.set_token('PROCEDURE', l_proc);
436: fnd_message.set_token('STEP','10');
437: fnd_message.raise_error;
438: END IF;
439:
440: --
441: -- Process Logic
674: FETCH cur_check INTO l_check;
675: IF cur_check%NOTFOUND THEN
676: CLOSE cur_check;
677: -- error message
678: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
679: fnd_message.set_token('PROCEDURE', l_proc);
680: fnd_message.set_token('STEP','10');
681: fnd_message.raise_error;
682: END IF;
675: IF cur_check%NOTFOUND THEN
676: CLOSE cur_check;
677: -- error message
678: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
679: fnd_message.set_token('PROCEDURE', l_proc);
680: fnd_message.set_token('STEP','10');
681: fnd_message.raise_error;
682: END IF;
683: CLOSE cur_check;
676: CLOSE cur_check;
677: -- error message
678: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
679: fnd_message.set_token('PROCEDURE', l_proc);
680: fnd_message.set_token('STEP','10');
681: fnd_message.raise_error;
682: END IF;
683: CLOSE cur_check;
684: --
677: -- error message
678: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
679: fnd_message.set_token('PROCEDURE', l_proc);
680: fnd_message.set_token('STEP','10');
681: fnd_message.raise_error;
682: END IF;
683: CLOSE cur_check;
684: --
685: -- Process Logic
964: FETCH cur_check INTO l_check;
965: IF cur_check%NOTFOUND THEN
966: CLOSE cur_check;
967: -- error message
968: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
969: fnd_message.set_token('PROCEDURE', l_proc);
970: fnd_message.set_token('STEP','10');
971: fnd_message.raise_error;
972: END IF;
965: IF cur_check%NOTFOUND THEN
966: CLOSE cur_check;
967: -- error message
968: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
969: fnd_message.set_token('PROCEDURE', l_proc);
970: fnd_message.set_token('STEP','10');
971: fnd_message.raise_error;
972: END IF;
973: CLOSE cur_check;
966: CLOSE cur_check;
967: -- error message
968: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
969: fnd_message.set_token('PROCEDURE', l_proc);
970: fnd_message.set_token('STEP','10');
971: fnd_message.raise_error;
972: END IF;
973: CLOSE cur_check;
974: --
967: -- error message
968: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
969: fnd_message.set_token('PROCEDURE', l_proc);
970: fnd_message.set_token('STEP','10');
971: fnd_message.raise_error;
972: END IF;
973: CLOSE cur_check;
974: --
975: -- Process Logic