229:
230: IF ( p_canvas_property_id is not null) THEN
231: IF ( p_form_canvas_id is not null OR p_template_canvas_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: END IF;
230: IF ( p_canvas_property_id is not null) THEN
231: IF ( p_form_canvas_id is not null OR p_template_canvas_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: END IF;
238: ELSIF ( p_form_canvas_id is not null) THEN
231: IF ( p_form_canvas_id is not null OR p_template_canvas_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: END IF;
238: ELSIF ( p_form_canvas_id is not null) THEN
239: IF (p_canvas_property_id is not null) OR
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: END IF;
238: ELSIF ( p_form_canvas_id is not null) THEN
239: IF (p_canvas_property_id is not null) OR
240: (p_template_canvas_id is not null) THEN
238: ELSIF ( p_form_canvas_id is not null) THEN
239: IF (p_canvas_property_id is not null) OR
240: (p_template_canvas_id is not null) THEN
241: -- error message
242: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE', l_proc);
244: fnd_message.set_token('STEP','10');
245: fnd_message.raise_error;
246: END IF;
239: IF (p_canvas_property_id is not null) OR
240: (p_template_canvas_id is not null) THEN
241: -- error message
242: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE', l_proc);
244: fnd_message.set_token('STEP','10');
245: fnd_message.raise_error;
246: END IF;
247: ELSIF ( p_template_canvas_id is not null) THEN
240: (p_template_canvas_id is not null) THEN
241: -- error message
242: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE', l_proc);
244: fnd_message.set_token('STEP','10');
245: fnd_message.raise_error;
246: END IF;
247: ELSIF ( p_template_canvas_id is not null) THEN
248: IF (p_canvas_property_id is not null OR p_form_canvas_id is not null) THEN
241: -- error message
242: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
243: fnd_message.set_token('PROCEDURE', l_proc);
244: fnd_message.set_token('STEP','10');
245: fnd_message.raise_error;
246: END IF;
247: ELSIF ( p_template_canvas_id is not null) THEN
248: IF (p_canvas_property_id is not null OR p_form_canvas_id is not null) THEN
249: -- error message
246: END IF;
247: ELSIF ( p_template_canvas_id is not null) THEN
248: IF (p_canvas_property_id is not null OR p_form_canvas_id is not null) THEN
249: -- error message
250: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
251: fnd_message.set_token('PROCEDURE', l_proc);
252: fnd_message.set_token('STEP','10');
253: fnd_message.raise_error;
254: END IF;
247: ELSIF ( p_template_canvas_id is not null) THEN
248: IF (p_canvas_property_id is not null OR p_form_canvas_id is not null) THEN
249: -- error message
250: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
251: fnd_message.set_token('PROCEDURE', l_proc);
252: fnd_message.set_token('STEP','10');
253: fnd_message.raise_error;
254: END IF;
255: END IF;
248: IF (p_canvas_property_id is not null OR p_form_canvas_id is not null) THEN
249: -- error message
250: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
251: fnd_message.set_token('PROCEDURE', l_proc);
252: fnd_message.set_token('STEP','10');
253: fnd_message.raise_error;
254: END IF;
255: END IF;
256: --
249: -- error message
250: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
251: fnd_message.set_token('PROCEDURE', l_proc);
252: fnd_message.set_token('STEP','10');
253: fnd_message.raise_error;
254: END IF;
255: END IF;
256: --
257: -- Process Logic
392:
393: IF ( p_canvas_property_id is not null) THEN
394: IF (p_form_canvas_id is not null OR p_template_canvas_id is not null) THEN
395: -- error message
396: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
397: fnd_message.set_token('PROCEDURE', l_proc);
398: fnd_message.set_token('STEP','10');
399: fnd_message.raise_error;
400: END IF;
393: IF ( p_canvas_property_id is not null) THEN
394: IF (p_form_canvas_id is not null OR p_template_canvas_id is not null) THEN
395: -- error message
396: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
397: fnd_message.set_token('PROCEDURE', l_proc);
398: fnd_message.set_token('STEP','10');
399: fnd_message.raise_error;
400: END IF;
401: ELSIF ( p_form_canvas_id is not null) THEN
394: IF (p_form_canvas_id is not null OR p_template_canvas_id is not null) THEN
395: -- error message
396: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
397: fnd_message.set_token('PROCEDURE', l_proc);
398: fnd_message.set_token('STEP','10');
399: fnd_message.raise_error;
400: END IF;
401: ELSIF ( p_form_canvas_id is not null) THEN
402: IF (p_canvas_property_id is not null OR
395: -- error message
396: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
397: fnd_message.set_token('PROCEDURE', l_proc);
398: fnd_message.set_token('STEP','10');
399: fnd_message.raise_error;
400: END IF;
401: ELSIF ( p_form_canvas_id is not null) THEN
402: IF (p_canvas_property_id is not null OR
403: p_template_canvas_id is not null) THEN
401: ELSIF ( p_form_canvas_id is not null) THEN
402: IF (p_canvas_property_id is not null OR
403: p_template_canvas_id is not null) THEN
404: -- error message
405: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
406: fnd_message.set_token('PROCEDURE', l_proc);
407: fnd_message.set_token('STEP','10');
408: fnd_message.raise_error;
409: END IF;
402: IF (p_canvas_property_id is not null OR
403: p_template_canvas_id is not null) THEN
404: -- error message
405: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
406: fnd_message.set_token('PROCEDURE', l_proc);
407: fnd_message.set_token('STEP','10');
408: fnd_message.raise_error;
409: END IF;
410: ELSIF ( p_template_canvas_id is not null) THEN
403: p_template_canvas_id is not null) THEN
404: -- error message
405: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
406: fnd_message.set_token('PROCEDURE', l_proc);
407: fnd_message.set_token('STEP','10');
408: fnd_message.raise_error;
409: END IF;
410: ELSIF ( p_template_canvas_id is not null) THEN
411: IF (p_canvas_property_id is not null OR p_form_canvas_id is not null) THEN
404: -- error message
405: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
406: fnd_message.set_token('PROCEDURE', l_proc);
407: fnd_message.set_token('STEP','10');
408: fnd_message.raise_error;
409: END IF;
410: ELSIF ( p_template_canvas_id is not null) THEN
411: IF (p_canvas_property_id is not null OR p_form_canvas_id is not null) THEN
412: -- error message
409: END IF;
410: ELSIF ( p_template_canvas_id is not null) THEN
411: IF (p_canvas_property_id is not null OR p_form_canvas_id is not null) THEN
412: -- error message
413: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
414: fnd_message.set_token('PROCEDURE', l_proc);
415: fnd_message.set_token('STEP','10');
416: fnd_message.raise_error;
417: END IF;
410: ELSIF ( p_template_canvas_id is not null) THEN
411: IF (p_canvas_property_id is not null OR p_form_canvas_id is not null) THEN
412: -- error message
413: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
414: fnd_message.set_token('PROCEDURE', l_proc);
415: fnd_message.set_token('STEP','10');
416: fnd_message.raise_error;
417: END IF;
418: END IF;
411: IF (p_canvas_property_id is not null OR p_form_canvas_id is not null) THEN
412: -- error message
413: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
414: fnd_message.set_token('PROCEDURE', l_proc);
415: fnd_message.set_token('STEP','10');
416: fnd_message.raise_error;
417: END IF;
418: END IF;
419: --
412: -- error message
413: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
414: fnd_message.set_token('PROCEDURE', l_proc);
415: fnd_message.set_token('STEP','10');
416: fnd_message.raise_error;
417: END IF;
418: END IF;
419: --
420: -- Process Logic
637: FETCH cur_check INTO l_check;
638: IF cur_check%NOTFOUND THEN
639: CLOSE cur_check;
640: -- error message
641: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
642: fnd_message.set_token('PROCEDURE', l_proc);
643: fnd_message.set_token('STEP','10');
644: fnd_message.raise_error;
645: END IF;
638: IF cur_check%NOTFOUND THEN
639: CLOSE cur_check;
640: -- error message
641: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
642: fnd_message.set_token('PROCEDURE', l_proc);
643: fnd_message.set_token('STEP','10');
644: fnd_message.raise_error;
645: END IF;
646: CLOSE cur_check;
639: CLOSE cur_check;
640: -- error message
641: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
642: fnd_message.set_token('PROCEDURE', l_proc);
643: fnd_message.set_token('STEP','10');
644: fnd_message.raise_error;
645: END IF;
646: CLOSE cur_check;
647:
640: -- error message
641: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
642: fnd_message.set_token('PROCEDURE', l_proc);
643: fnd_message.set_token('STEP','10');
644: fnd_message.raise_error;
645: END IF;
646: CLOSE cur_check;
647:
648: --
899: FETCH cur_check INTO l_check;
900: IF cur_check%NOTFOUND THEN
901: CLOSE cur_check;
902: -- error message
903: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
904: fnd_message.set_token('PROCEDURE', l_proc);
905: fnd_message.set_token('STEP','10');
906: fnd_message.raise_error;
907: END IF;
900: IF cur_check%NOTFOUND THEN
901: CLOSE cur_check;
902: -- error message
903: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
904: fnd_message.set_token('PROCEDURE', l_proc);
905: fnd_message.set_token('STEP','10');
906: fnd_message.raise_error;
907: END IF;
908: CLOSE cur_check;
901: CLOSE cur_check;
902: -- error message
903: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
904: fnd_message.set_token('PROCEDURE', l_proc);
905: fnd_message.set_token('STEP','10');
906: fnd_message.raise_error;
907: END IF;
908: CLOSE cur_check;
909:
902: -- error message
903: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
904: fnd_message.set_token('PROCEDURE', l_proc);
905: fnd_message.set_token('STEP','10');
906: fnd_message.raise_error;
907: END IF;
908: CLOSE cur_check;
909:
910: --