259:
260: IF ( p_window_property_id is not null) AND
261: (p_form_window_id is not null OR p_template_window_id is not null) THEN
262: -- error message
263: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
264: fnd_message.set_token('PROCEDURE', l_proc);
265: fnd_message.set_token('STEP','10');
266: fnd_message.raise_error;
267: ELSIF ( p_form_window_id is not null) AND
260: IF ( p_window_property_id is not null) AND
261: (p_form_window_id is not null OR p_template_window_id is not null) THEN
262: -- error message
263: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
264: fnd_message.set_token('PROCEDURE', l_proc);
265: fnd_message.set_token('STEP','10');
266: fnd_message.raise_error;
267: ELSIF ( p_form_window_id is not null) AND
268: (p_window_property_id is not null OR p_template_window_id is not null) THEN
261: (p_form_window_id is not null OR p_template_window_id is not null) THEN
262: -- error message
263: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
264: fnd_message.set_token('PROCEDURE', l_proc);
265: fnd_message.set_token('STEP','10');
266: fnd_message.raise_error;
267: ELSIF ( p_form_window_id is not null) AND
268: (p_window_property_id is not null OR p_template_window_id is not null) THEN
269: -- error message
262: -- error message
263: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
264: fnd_message.set_token('PROCEDURE', l_proc);
265: fnd_message.set_token('STEP','10');
266: fnd_message.raise_error;
267: ELSIF ( p_form_window_id is not null) AND
268: (p_window_property_id is not null OR p_template_window_id is not null) THEN
269: -- error message
270: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
266: fnd_message.raise_error;
267: ELSIF ( p_form_window_id is not null) AND
268: (p_window_property_id is not null OR p_template_window_id is not null) THEN
269: -- error message
270: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
271: fnd_message.set_token('PROCEDURE', l_proc);
272: fnd_message.set_token('STEP','10');
273: fnd_message.raise_error;
274: ELSIF ( p_template_window_id is not null) AND
267: ELSIF ( p_form_window_id is not null) AND
268: (p_window_property_id is not null OR p_template_window_id is not null) THEN
269: -- error message
270: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
271: fnd_message.set_token('PROCEDURE', l_proc);
272: fnd_message.set_token('STEP','10');
273: fnd_message.raise_error;
274: ELSIF ( p_template_window_id is not null) AND
275: (p_window_property_id is not null OR p_form_window_id is not null) THEN
268: (p_window_property_id is not null OR p_template_window_id is not null) THEN
269: -- error message
270: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
271: fnd_message.set_token('PROCEDURE', l_proc);
272: fnd_message.set_token('STEP','10');
273: fnd_message.raise_error;
274: ELSIF ( p_template_window_id is not null) AND
275: (p_window_property_id is not null OR p_form_window_id is not null) THEN
276: -- error message
269: -- error message
270: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
271: fnd_message.set_token('PROCEDURE', l_proc);
272: fnd_message.set_token('STEP','10');
273: fnd_message.raise_error;
274: ELSIF ( p_template_window_id is not null) AND
275: (p_window_property_id is not null OR p_form_window_id is not null) THEN
276: -- error message
277: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
273: fnd_message.raise_error;
274: ELSIF ( p_template_window_id is not null) AND
275: (p_window_property_id is not null OR p_form_window_id is not null) THEN
276: -- error message
277: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
278: fnd_message.set_token('PROCEDURE', l_proc);
279: fnd_message.set_token('STEP','10');
280: fnd_message.raise_error;
281: END IF;
274: ELSIF ( p_template_window_id is not null) AND
275: (p_window_property_id is not null OR p_form_window_id is not null) THEN
276: -- error message
277: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
278: fnd_message.set_token('PROCEDURE', l_proc);
279: fnd_message.set_token('STEP','10');
280: fnd_message.raise_error;
281: END IF;
282: --
275: (p_window_property_id is not null OR p_form_window_id is not null) THEN
276: -- error message
277: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
278: fnd_message.set_token('PROCEDURE', l_proc);
279: fnd_message.set_token('STEP','10');
280: fnd_message.raise_error;
281: END IF;
282: --
283: -- Process Logic
276: -- error message
277: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
278: fnd_message.set_token('PROCEDURE', l_proc);
279: fnd_message.set_token('STEP','10');
280: fnd_message.raise_error;
281: END IF;
282: --
283: -- Process Logic
284: --
418:
419: IF ( p_window_property_id is not null) AND
420: (p_form_window_id is not null OR p_template_window_id is not null) THEN
421: -- error message
422: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
423: fnd_message.set_token('PROCEDURE', l_proc);
424: fnd_message.set_token('STEP','10');
425: fnd_message.raise_error;
426: ELSIF ( p_form_window_id is not null) AND
419: IF ( p_window_property_id is not null) AND
420: (p_form_window_id is not null OR p_template_window_id is not null) THEN
421: -- error message
422: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
423: fnd_message.set_token('PROCEDURE', l_proc);
424: fnd_message.set_token('STEP','10');
425: fnd_message.raise_error;
426: ELSIF ( p_form_window_id is not null) AND
427: (p_window_property_id is not null OR p_template_window_id is not null) THEN
420: (p_form_window_id is not null OR p_template_window_id is not null) THEN
421: -- error message
422: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
423: fnd_message.set_token('PROCEDURE', l_proc);
424: fnd_message.set_token('STEP','10');
425: fnd_message.raise_error;
426: ELSIF ( p_form_window_id is not null) AND
427: (p_window_property_id is not null OR p_template_window_id is not null) THEN
428: -- error message
421: -- error message
422: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
423: fnd_message.set_token('PROCEDURE', l_proc);
424: fnd_message.set_token('STEP','10');
425: fnd_message.raise_error;
426: ELSIF ( p_form_window_id is not null) AND
427: (p_window_property_id is not null OR p_template_window_id is not null) THEN
428: -- error message
429: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
425: fnd_message.raise_error;
426: ELSIF ( p_form_window_id is not null) AND
427: (p_window_property_id is not null OR p_template_window_id is not null) THEN
428: -- error message
429: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
430: fnd_message.set_token('PROCEDURE', l_proc);
431: fnd_message.set_token('STEP','10');
432: fnd_message.raise_error;
433: ELSIF ( p_template_window_id is not null) AND
426: ELSIF ( p_form_window_id is not null) AND
427: (p_window_property_id is not null OR p_template_window_id is not null) THEN
428: -- error message
429: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
430: fnd_message.set_token('PROCEDURE', l_proc);
431: fnd_message.set_token('STEP','10');
432: fnd_message.raise_error;
433: ELSIF ( p_template_window_id is not null) AND
434: (p_window_property_id is not null OR p_form_window_id is not null) THEN
427: (p_window_property_id is not null OR p_template_window_id is not null) THEN
428: -- error message
429: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
430: fnd_message.set_token('PROCEDURE', l_proc);
431: fnd_message.set_token('STEP','10');
432: fnd_message.raise_error;
433: ELSIF ( p_template_window_id is not null) AND
434: (p_window_property_id is not null OR p_form_window_id is not null) THEN
435: -- error message
428: -- error message
429: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
430: fnd_message.set_token('PROCEDURE', l_proc);
431: fnd_message.set_token('STEP','10');
432: fnd_message.raise_error;
433: ELSIF ( p_template_window_id is not null) AND
434: (p_window_property_id is not null OR p_form_window_id is not null) THEN
435: -- error message
436: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
432: fnd_message.raise_error;
433: ELSIF ( p_template_window_id is not null) AND
434: (p_window_property_id is not null OR p_form_window_id is not null) THEN
435: -- error message
436: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
437: fnd_message.set_token('PROCEDURE', l_proc);
438: fnd_message.set_token('STEP','10');
439: fnd_message.raise_error;
440: END IF;
433: ELSIF ( p_template_window_id is not null) AND
434: (p_window_property_id is not null OR p_form_window_id is not null) THEN
435: -- error message
436: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
437: fnd_message.set_token('PROCEDURE', l_proc);
438: fnd_message.set_token('STEP','10');
439: fnd_message.raise_error;
440: END IF;
441: --
434: (p_window_property_id is not null OR p_form_window_id is not null) THEN
435: -- error message
436: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
437: fnd_message.set_token('PROCEDURE', l_proc);
438: fnd_message.set_token('STEP','10');
439: fnd_message.raise_error;
440: END IF;
441: --
442: -- Process Logic
435: -- error message
436: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
437: fnd_message.set_token('PROCEDURE', l_proc);
438: fnd_message.set_token('STEP','10');
439: fnd_message.raise_error;
440: END IF;
441: --
442: -- Process Logic
443: --
687: FETCH cur_check INTO l_check;
688: IF cur_check%NOTFOUND THEN
689: CLOSE cur_check;
690: -- error message
691: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
692: fnd_message.set_token('PROCEDURE', l_proc);
693: fnd_message.set_token('STEP','10');
694: fnd_message.raise_error;
695: END IF;
688: IF cur_check%NOTFOUND THEN
689: CLOSE cur_check;
690: -- error message
691: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
692: fnd_message.set_token('PROCEDURE', l_proc);
693: fnd_message.set_token('STEP','10');
694: fnd_message.raise_error;
695: END IF;
696: CLOSE cur_check;
689: CLOSE cur_check;
690: -- error message
691: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
692: fnd_message.set_token('PROCEDURE', l_proc);
693: fnd_message.set_token('STEP','10');
694: fnd_message.raise_error;
695: END IF;
696: CLOSE cur_check;
697:
690: -- error message
691: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
692: fnd_message.set_token('PROCEDURE', l_proc);
693: fnd_message.set_token('STEP','10');
694: fnd_message.raise_error;
695: END IF;
696: CLOSE cur_check;
697:
698: hr_utility.set_location('At:'|| l_proc, 20);
1000: FETCH cur_check INTO l_form_window_id;
1001: IF cur_check%NOTFOUND THEN
1002: CLOSE cur_check;
1003: -- error message
1004: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1005: fnd_message.set_token('PROCEDURE', l_proc);
1006: fnd_message.set_token('STEP','10');
1007: fnd_message.raise_error;
1008: END IF;
1001: IF cur_check%NOTFOUND THEN
1002: CLOSE cur_check;
1003: -- error message
1004: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1005: fnd_message.set_token('PROCEDURE', l_proc);
1006: fnd_message.set_token('STEP','10');
1007: fnd_message.raise_error;
1008: END IF;
1009: CLOSE cur_check;
1002: CLOSE cur_check;
1003: -- error message
1004: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1005: fnd_message.set_token('PROCEDURE', l_proc);
1006: fnd_message.set_token('STEP','10');
1007: fnd_message.raise_error;
1008: END IF;
1009: CLOSE cur_check;
1010:
1003: -- error message
1004: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1005: fnd_message.set_token('PROCEDURE', l_proc);
1006: fnd_message.set_token('STEP','10');
1007: fnd_message.raise_error;
1008: END IF;
1009: CLOSE cur_check;
1010:
1011: --