APPS.PN_SPACE_ASSIGN_EMP_PKG dependencies on APP_EXCEPTION

Line 96: app_exception.raise_exception;

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,
100: p_cost_cntr_code => x_cost_center_code,

Line 494: app_exception.raise_exception;

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:
498: IF ((x_person_id IS NULL AND

Line 638: app_exception.raise_exception;

634: END IF;
635:
636: EXCEPTION
637: WHEN OTHERS THEN
638: app_exception.raise_exception;
639:
640: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.UPDATE_ROW (-) SpcAsgnId: '
641: ||x_emp_space_assign_id||', Mode: '||x_update_correct_option||', LocId: '||x_location_id
642: ||', StrDt: '||TO_CHAR(x_emp_assign_start_date,'MM/DD/YYYY')

Line 750: app_exception.raise_exception;

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:
754: IF p_end_dt IS NOT NULL THEN

Line 761: app_exception.raise_exception;

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:
765: IF p_end_dt IS NOT NULL AND p_str_dt IS NOT NULL THEN

Line 791: app_exception.raise_exception;

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:
795: pnp_debug_pkg.debug ('PN_SPACE_ASSIGN_EMP_PKG.check_office_assign_gaps(-)');

Line 852: app_exception.raise_exception;

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;
856: