DBA Data[Home] [Help]

APPS.HR_IT_EXTRA_PERSON_RULES dependencies on HR_UTILITY

Line 50: hr_utility.set_message(800, 'HR_IT_INVALID_USES_TOBACCO');

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

Line 51: hr_utility.raise_error;

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.

Line 67: hr_utility.set_message(800, 'HR_IT_INVALID_EMP_REF_NO');

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

Line 68: hr_utility.raise_error;

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

Line 108: hr_utility.set_message(800, 'HR_IT_INVALID_USES_TOBACCO');

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

Line 109: hr_utility.raise_error;

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:

Line 131: hr_utility.set_message(800, 'HR_IT_INVALID_EMP_REF_NO');

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

Line 132: hr_utility.raise_error;

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

Line 183: hr_utility.set_message(800, 'HR_IT_INVALID_GRADE_TYPE_NAME');

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

Line 184: hr_utility.raise_error;

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

Line 209: hr_utility.set_message(800, 'HR_IT_IVALID_GRADE_LEVEL_DESC');

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.

Line 210: hr_utility.raise_error;

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

Line 216: hr_utility.set_message(800, 'HR_IT_IVALID_LEVEL_DESC');

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

Line 217: hr_utility.raise_error;

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

Line 284: hr_utility.set_message(800, 'HR_IT_NULL_INS_CODE');

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

Line 285: hr_utility.raise_error;

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

Line 411: hr_utility.set_message(800, 'HR_IT_NULL_INS_CODE');

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;

Line 412: hr_utility.raise_error;

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;