46: --
47: -- Uses tobacco cannot be entered.
48: --
49: If p_uses_tobacco_flag IS NOT NULL THEN
50: hr_utility.set_message(800, 'HR_IT_INVALID_USES_TOBACCO');
51: hr_utility.raise_error;
52: END IF;
53: --
54: --
47: -- Uses tobacco cannot be entered.
48: --
49: If p_uses_tobacco_flag IS NOT NULL THEN
50: hr_utility.set_message(800, 'HR_IT_INVALID_USES_TOBACCO');
51: hr_utility.raise_error;
52: END IF;
53: --
54: --
55: -- Employee Reference No must be unique.
63: FROM per_all_people_f
64: WHERE per_information2 = p_per_information2
65: AND business_group_id=p_business_group_id);
66: if l_v = 1 then
67: hr_utility.set_message(800, 'HR_IT_INVALID_EMP_REF_NO');
68: hr_utility.raise_error;
69: end if;
70:
71: EXCEPTION
64: WHERE per_information2 = p_per_information2
65: AND business_group_id=p_business_group_id);
66: if l_v = 1 then
67: hr_utility.set_message(800, 'HR_IT_INVALID_EMP_REF_NO');
68: hr_utility.raise_error;
69: end if;
70:
71: EXCEPTION
72: WHEN no_data_found THEN
104: --
105: -- Uses tobacco cannot be entered.
106: --
107: If val_changed(p_uses_tobacco_flag) AND p_uses_tobacco_flag IS NOT NULL THEN
108: hr_utility.set_message(800, 'HR_IT_INVALID_USES_TOBACCO');
109: hr_utility.raise_error;
110: END IF;
111: --
112: --
105: -- Uses tobacco cannot be entered.
106: --
107: If val_changed(p_uses_tobacco_flag) AND p_uses_tobacco_flag IS NOT NULL THEN
108: hr_utility.set_message(800, 'HR_IT_INVALID_USES_TOBACCO');
109: hr_utility.raise_error;
110: END IF;
111: --
112: --
113:
127: WHERE per_information2 = p_per_information2
128: AND person_id <> p_person_id
129: AND business_group_id=l_business_group_id);
130: if l_v = 1 then
131: hr_utility.set_message(800, 'HR_IT_INVALID_EMP_REF_NO');
132: hr_utility.raise_error;
133: end if;
134:
135: EXCEPTION
128: AND person_id <> p_person_id
129: AND business_group_id=l_business_group_id);
130: if l_v = 1 then
131: hr_utility.set_message(800, 'HR_IT_INVALID_EMP_REF_NO');
132: hr_utility.raise_error;
133: end if;
134:
135: EXCEPTION
136: WHEN no_data_found THEN
179: OPEN csr_it_cagr(p_cagr_id_flex_num, p_collective_agreement_id, p_organization_id);
180: FETCH csr_it_cagr INTO l_dynamic_insert;
181: IF csr_it_cagr%NOTFOUND THEN
182: CLOSE csr_it_cagr;
183: hr_utility.set_message(800, 'HR_IT_INVALID_GRADE_TYPE_NAME');
184: hr_utility.raise_error;
185: END IF;
186: CLOSE csr_it_cagr;
187: --
180: FETCH csr_it_cagr INTO l_dynamic_insert;
181: IF csr_it_cagr%NOTFOUND THEN
182: CLOSE csr_it_cagr;
183: hr_utility.set_message(800, 'HR_IT_INVALID_GRADE_TYPE_NAME');
184: hr_utility.raise_error;
185: END IF;
186: CLOSE csr_it_cagr;
187: --
188: --
205: --
206: -- Level or Description has been entered without a grade.
207: --
208: If p_cag_segment1 IS NULL AND (p_cag_segment2 IS NOT NULL OR p_cag_segment3 IS NOT NULL) THEN
209: hr_utility.set_message(800, 'HR_IT_IVALID_GRADE_LEVEL_DESC');
210: hr_utility.raise_error;
211: --
212: --
213: -- Description has been entered without a Level.
206: -- Level or Description has been entered without a grade.
207: --
208: If p_cag_segment1 IS NULL AND (p_cag_segment2 IS NOT NULL OR p_cag_segment3 IS NOT NULL) THEN
209: hr_utility.set_message(800, 'HR_IT_IVALID_GRADE_LEVEL_DESC');
210: hr_utility.raise_error;
211: --
212: --
213: -- Description has been entered without a Level.
214: --
212: --
213: -- Description has been entered without a Level.
214: --
215: ELSIF p_cag_segment2 IS NULL AND p_cag_segment3 IS NOT NULL THEN
216: hr_utility.set_message(800, 'HR_IT_IVALID_LEVEL_DESC');
217: hr_utility.raise_error;
218: END IF;
219: END cagr_format_valid;
220: --
213: -- Description has been entered without a Level.
214: --
215: ELSIF p_cag_segment2 IS NULL AND p_cag_segment3 IS NOT NULL THEN
216: hr_utility.set_message(800, 'HR_IT_IVALID_LEVEL_DESC');
217: hr_utility.raise_error;
218: END IF;
219: END cagr_format_valid;
220: --
221: --
280: --
281: -- Unemployment insurance code must be entered.
282: --
283: /*IF p_scl_segment2 IS NULL THEN
284: hr_utility.set_message(800, 'HR_IT_NULL_INS_CODE');
285: hr_utility.raise_error;
286: END IF;*/
287: END extra_create_assignment_checks;
288: --
281: -- Unemployment insurance code must be entered.
282: --
283: /*IF p_scl_segment2 IS NULL THEN
284: hr_utility.set_message(800, 'HR_IT_NULL_INS_CODE');
285: hr_utility.raise_error;
286: END IF;*/
287: END extra_create_assignment_checks;
288: --
289: --
407: --
408: -- Unemployment insurance code must be entered.
409: --
410: /*IF val_changed(p_segment2) AND p_segment2 IS NULL THEN
411: hr_utility.set_message(800, 'HR_IT_NULL_INS_CODE');
412: hr_utility.raise_error;
413: END IF;*/
414: END extra_update_assignment_checks;
415: END hr_it_extra_person_rules;
408: -- Unemployment insurance code must be entered.
409: --
410: /*IF val_changed(p_segment2) AND p_segment2 IS NULL THEN
411: hr_utility.set_message(800, 'HR_IT_NULL_INS_CODE');
412: hr_utility.raise_error;
413: END IF;*/
414: END extra_update_assignment_checks;
415: END hr_it_extra_person_rules;