229: IF ( p_form_property_id is not null ) AND
230: (p_application_id is not null OR p_form_id is not null OR
231: p_form_template_id is not null) THEN
232: -- error message
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','10');
236: fnd_message.raise_error;
237: ELSIF (p_application_id is not null OR p_form_id is not null) AND
230: (p_application_id is not null OR p_form_id is not null OR
231: p_form_template_id is not null) THEN
232: -- error message
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','10');
236: fnd_message.raise_error;
237: ELSIF (p_application_id is not null OR p_form_id is not null) AND
238: ( p_form_property_id is not null OR p_form_template_id is not null) THEN
231: p_form_template_id is not null) THEN
232: -- error message
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','10');
236: fnd_message.raise_error;
237: ELSIF (p_application_id is not null OR p_form_id is not null) AND
238: ( p_form_property_id is not null OR p_form_template_id is not null) THEN
239: -- error message
232: -- error message
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','10');
236: fnd_message.raise_error;
237: ELSIF (p_application_id is not null OR p_form_id is not null) AND
238: ( p_form_property_id is not null OR p_form_template_id is not null) THEN
239: -- error message
240: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
236: fnd_message.raise_error;
237: ELSIF (p_application_id is not null OR p_form_id is not null) AND
238: ( p_form_property_id is not null OR p_form_template_id is not null) THEN
239: -- error message
240: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
241: fnd_message.set_token('PROCEDURE', l_proc);
242: fnd_message.set_token('STEP','10');
243: fnd_message.raise_error;
244: ELSIF( p_form_template_id is not null) AND
237: ELSIF (p_application_id is not null OR p_form_id is not null) AND
238: ( p_form_property_id is not null OR p_form_template_id is not null) THEN
239: -- error message
240: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
241: fnd_message.set_token('PROCEDURE', l_proc);
242: fnd_message.set_token('STEP','10');
243: fnd_message.raise_error;
244: ELSIF( p_form_template_id is not null) AND
245: ( p_form_property_id is not null OR
238: ( p_form_property_id is not null OR p_form_template_id is not null) THEN
239: -- error message
240: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
241: fnd_message.set_token('PROCEDURE', l_proc);
242: fnd_message.set_token('STEP','10');
243: fnd_message.raise_error;
244: ELSIF( p_form_template_id is not null) AND
245: ( p_form_property_id is not null OR
246: p_application_id is not null OR p_form_id is not null) THEN
239: -- error message
240: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
241: fnd_message.set_token('PROCEDURE', l_proc);
242: fnd_message.set_token('STEP','10');
243: fnd_message.raise_error;
244: ELSIF( p_form_template_id is not null) AND
245: ( p_form_property_id is not null OR
246: p_application_id is not null OR p_form_id is not null) THEN
247: -- error message
244: ELSIF( p_form_template_id is not null) AND
245: ( p_form_property_id is not null OR
246: p_application_id is not null OR p_form_id is not null) THEN
247: -- error message
248: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
249: fnd_message.set_token('PROCEDURE', l_proc);
250: fnd_message.set_token('STEP','10');
251: fnd_message.raise_error;
252: END IF;
245: ( p_form_property_id is not null OR
246: p_application_id is not null OR p_form_id is not null) THEN
247: -- error message
248: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
249: fnd_message.set_token('PROCEDURE', l_proc);
250: fnd_message.set_token('STEP','10');
251: fnd_message.raise_error;
252: END IF;
253:
246: p_application_id is not null OR p_form_id is not null) THEN
247: -- error message
248: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
249: fnd_message.set_token('PROCEDURE', l_proc);
250: fnd_message.set_token('STEP','10');
251: fnd_message.raise_error;
252: END IF;
253:
254: hr_utility.set_location('At:'|| l_proc, 20);
247: -- error message
248: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
249: fnd_message.set_token('PROCEDURE', l_proc);
250: fnd_message.set_token('STEP','10');
251: fnd_message.raise_error;
252: END IF;
253:
254: hr_utility.set_location('At:'|| l_proc, 20);
255:
388: IF ( p_form_property_id is not null ) AND
389: (p_application_id is not null OR p_form_id is not null OR
390: p_form_template_id is not null) THEN
391: -- error message
392: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
393: fnd_message.set_token('PROCEDURE', l_proc);
394: fnd_message.set_token('STEP','10');
395: fnd_message.raise_error;
396: ELSIF (p_application_id is not null OR p_form_id is not null) AND
389: (p_application_id is not null OR p_form_id is not null OR
390: p_form_template_id is not null) THEN
391: -- error message
392: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
393: fnd_message.set_token('PROCEDURE', l_proc);
394: fnd_message.set_token('STEP','10');
395: fnd_message.raise_error;
396: ELSIF (p_application_id is not null OR p_form_id is not null) AND
397: ( p_form_property_id is not null OR p_form_template_id is not null) THEN
390: p_form_template_id is not null) THEN
391: -- error message
392: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
393: fnd_message.set_token('PROCEDURE', l_proc);
394: fnd_message.set_token('STEP','10');
395: fnd_message.raise_error;
396: ELSIF (p_application_id is not null OR p_form_id is not null) AND
397: ( p_form_property_id is not null OR p_form_template_id is not null) THEN
398: -- error message
391: -- error message
392: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
393: fnd_message.set_token('PROCEDURE', l_proc);
394: fnd_message.set_token('STEP','10');
395: fnd_message.raise_error;
396: ELSIF (p_application_id is not null OR p_form_id is not null) AND
397: ( p_form_property_id is not null OR p_form_template_id is not null) THEN
398: -- error message
399: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
395: fnd_message.raise_error;
396: ELSIF (p_application_id is not null OR p_form_id is not null) AND
397: ( p_form_property_id is not null OR p_form_template_id is not null) THEN
398: -- error message
399: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
400: fnd_message.set_token('PROCEDURE', l_proc);
401: fnd_message.set_token('STEP','10');
402: fnd_message.raise_error;
403: ELSIF( p_form_template_id is not null) AND
396: ELSIF (p_application_id is not null OR p_form_id is not null) AND
397: ( p_form_property_id is not null OR p_form_template_id is not null) THEN
398: -- error message
399: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
400: fnd_message.set_token('PROCEDURE', l_proc);
401: fnd_message.set_token('STEP','10');
402: fnd_message.raise_error;
403: ELSIF( p_form_template_id is not null) AND
404: ( p_form_property_id is not null OR
397: ( p_form_property_id is not null OR p_form_template_id is not null) THEN
398: -- error message
399: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
400: fnd_message.set_token('PROCEDURE', l_proc);
401: fnd_message.set_token('STEP','10');
402: fnd_message.raise_error;
403: ELSIF( p_form_template_id is not null) AND
404: ( p_form_property_id is not null OR
405: p_application_id is not null OR p_form_id is not null) THEN
398: -- error message
399: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
400: fnd_message.set_token('PROCEDURE', l_proc);
401: fnd_message.set_token('STEP','10');
402: fnd_message.raise_error;
403: ELSIF( p_form_template_id is not null) AND
404: ( p_form_property_id is not null OR
405: p_application_id is not null OR p_form_id is not null) THEN
406: -- error message
403: ELSIF( p_form_template_id is not null) AND
404: ( p_form_property_id is not null OR
405: p_application_id is not null OR p_form_id is not null) THEN
406: -- error message
407: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
408: fnd_message.set_token('PROCEDURE', l_proc);
409: fnd_message.set_token('STEP','10');
410: fnd_message.raise_error;
411: END IF;
404: ( p_form_property_id is not null OR
405: p_application_id is not null OR p_form_id is not null) THEN
406: -- error message
407: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
408: fnd_message.set_token('PROCEDURE', l_proc);
409: fnd_message.set_token('STEP','10');
410: fnd_message.raise_error;
411: END IF;
412:
405: p_application_id is not null OR p_form_id is not null) THEN
406: -- error message
407: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
408: fnd_message.set_token('PROCEDURE', l_proc);
409: fnd_message.set_token('STEP','10');
410: fnd_message.raise_error;
411: END IF;
412:
413: --
406: -- error message
407: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
408: fnd_message.set_token('PROCEDURE', l_proc);
409: fnd_message.set_token('STEP','10');
410: fnd_message.raise_error;
411: END IF;
412:
413: --
414: -- Process Logic
629: FETCH cur_check INTO l_check;
630: IF cur_check%NOTFOUND THEN
631: CLOSE cur_check;
632: -- error message
633: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
634: fnd_message.set_token('PROCEDURE', l_proc);
635: fnd_message.set_token('STEP','10');
636: fnd_message.raise_error;
637: END IF;
630: IF cur_check%NOTFOUND THEN
631: CLOSE cur_check;
632: -- error message
633: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
634: fnd_message.set_token('PROCEDURE', l_proc);
635: fnd_message.set_token('STEP','10');
636: fnd_message.raise_error;
637: END IF;
638: CLOSE cur_check;
631: CLOSE cur_check;
632: -- error message
633: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
634: fnd_message.set_token('PROCEDURE', l_proc);
635: fnd_message.set_token('STEP','10');
636: fnd_message.raise_error;
637: END IF;
638: CLOSE cur_check;
639: --
632: -- error message
633: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
634: fnd_message.set_token('PROCEDURE', l_proc);
635: fnd_message.set_token('STEP','10');
636: fnd_message.raise_error;
637: END IF;
638: CLOSE cur_check;
639: --
640: -- Process Logic
884: FETCH cur_check INTO l_application_id , l_form_id;
885: IF cur_check%NOTFOUND THEN
886: CLOSE cur_check;
887: -- error message
888: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
889: fnd_message.set_token('PROCEDURE', l_proc);
890: fnd_message.set_token('STEP','10');
891: fnd_message.raise_error;
892: END IF;
885: IF cur_check%NOTFOUND THEN
886: CLOSE cur_check;
887: -- error message
888: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
889: fnd_message.set_token('PROCEDURE', l_proc);
890: fnd_message.set_token('STEP','10');
891: fnd_message.raise_error;
892: END IF;
893: CLOSE cur_check;
886: CLOSE cur_check;
887: -- error message
888: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
889: fnd_message.set_token('PROCEDURE', l_proc);
890: fnd_message.set_token('STEP','10');
891: fnd_message.raise_error;
892: END IF;
893: CLOSE cur_check;
894:
887: -- error message
888: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
889: fnd_message.set_token('PROCEDURE', l_proc);
890: fnd_message.set_token('STEP','10');
891: fnd_message.raise_error;
892: END IF;
893: CLOSE cur_check;
894:
895: --