91: ,p_err_msg => l_err_msg
92: );
93:
94: IF l_err_msg IS NOT NULL THEN
95: fnd_message.set_name('PN', 'PN_INVALID_SPACE_ASSGN_DATE');
96: app_exception.raise_exception;
97: END IF;
98:
99: pn_space_assign_emp_pkg.check_dupemp_assign(p_person_id => x_person_id,
489: ,p_err_msg => l_err_msg
490: );
491:
492: IF l_err_msg IS NOT NULL THEN
493: fnd_message.set_name('PN', 'PN_INVALID_SPACE_ASSGN_DATE');
494: app_exception.raise_exception;
495: END IF;
496: END IF;
497:
745: FETCH check_loctn_gap INTO l_err_flag;
746: CLOSE check_loctn_gap;
747:
748: IF l_err_flag = 'Y' THEN
749: fnd_message.set_name('PN', 'PN_ASGN_LOCN_NOT_EFFC_MSG');
750: app_exception.raise_exception;
751: END IF;
752: END IF;
753:
756: FETCH check_loctn_gap INTO l_err_flag;
757: CLOSE check_loctn_gap;
758:
759: IF l_err_flag = 'Y' THEN
760: fnd_message.set_name('PN', 'PN_ASGN_LOCN_NOT_EFFC_MSG');
761: app_exception.raise_exception;
762: END IF;
763: END IF;
764:
786: l_err_flag := 'Y';
787: END IF;
788:
789: IF l_err_flag = 'Y' THEN
790: fnd_message.set_name('PN', 'PN_ASGN_LOCN_NOT_EFFC_MSG');
791: app_exception.raise_exception;
792: END IF;
793: END IF;
794:
847: FETCH check_emp_assignment INTO l_err_flag;
848: CLOSE check_emp_assignment;
849:
850: IF NVL(l_err_flag,'N') = 'Y' THEN
851: fnd_message.set_name('PN', 'PN_SPASGN_EMPLOYEE_OVRLAP_MSG');
852: app_exception.raise_exception;
853: END IF;
854:
855: END check_dupemp_assign;