eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_RO_PERSON_VALIDATE dependencies on HR_UTILITY

Line 15: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');

11: --
12: BEGIN
13: --
14: IF (hr_api.not_exists_in_hr_lookups (p_effective_date, p_lookup_type, p_argument_value ) ) THEN
15: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
16: hr_utility.set_message_token ('ARGUMENT', p_argument);
17: hr_utility.raise_error;
18: END IF;
19: --

Line 16: hr_utility.set_message_token ('ARGUMENT', p_argument);

12: BEGIN
13: --
14: IF (hr_api.not_exists_in_hr_lookups (p_effective_date, p_lookup_type, p_argument_value ) ) THEN
15: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
16: hr_utility.set_message_token ('ARGUMENT', p_argument);
17: hr_utility.raise_error;
18: END IF;
19: --
20: END check_lookup_value;

Line 17: hr_utility.raise_error;

13: --
14: IF (hr_api.not_exists_in_hr_lookups (p_effective_date, p_lookup_type, p_argument_value ) ) THEN
15: hr_utility.set_message (800, 'HR_7209_API_LOOK_INVALID');
16: hr_utility.set_message_token ('ARGUMENT', p_argument);
17: hr_utility.raise_error;
18: END IF;
19: --
20: END check_lookup_value;
21:

Line 109: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN

105: -- mandatory first name
106: -- lookup chk :: Residence, Citizenship
107: -- country x region x town
108: -- ni validation -- DOB,Birth Place, Gender,residence, citizenship -- npc and previous npc
109: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
110: hr_utility.trace('RO not installed.Leaving person validation');
111: RETURN;
112: END IF;
113: -- mandatory first name

Line 110: hr_utility.trace('RO not installed.Leaving person validation');

106: -- lookup chk :: Residence, Citizenship
107: -- country x region x town
108: -- ni validation -- DOB,Birth Place, Gender,residence, citizenship -- npc and previous npc
109: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
110: hr_utility.trace('RO not installed.Leaving person validation');
111: RETURN;
112: END IF;
113: -- mandatory first name
114: hr_api.mandatory_arg_error (p_api_name => l_proc, p_argument => 'First Name', p_argument_value => p_first_name );

Line 115: hr_utility.set_location('Person validation :: ',1);

111: RETURN;
112: END IF;
113: -- mandatory first name
114: hr_api.mandatory_arg_error (p_api_name => l_proc, p_argument => 'First Name', p_argument_value => p_first_name );
115: hr_utility.set_location('Person validation :: ',1);
116: -- lookup chk :: Residence, Citizenship
117: IF nvl(p_per_information1,hr_api.g_varchar2) <> hr_api.g_varchar2 THEN
118: check_lookup_value(hr_general.decode_lookup('RO_FORM_LABELS','RESIDENCE'),p_per_information1,'PER_RO_RESIDENCE',p_hire_date);
119: END IF;

Line 123: hr_utility.set_location('Person validation :: ',2);

119: END IF;
120: IF nvl(p_per_information2,hr_api.g_varchar2) <> hr_api.g_varchar2 THEN
121: check_lookup_value(hr_general.decode_lookup('RO_FORM_LABELS','CITIZENSHIP'),p_per_information2,'PER_RO_CITIZENSHIP',p_hire_date);
122: END IF;
123: hr_utility.set_location('Person validation :: ',2);
124: -- country x region x town
125: IF p_country_of_birth = 'RO' THEN
126: IF nvl(p_region_of_birth,hr_api.g_varchar2) <> hr_api.g_varchar2 THEN
127: l_county_code := hr_api.return_lookup_code(p_region_of_birth,'RO_PER_COUNTIES');

Line 132: hr_utility.set_message(800,'HR_520032_LOC_CNTY_INV');

128: IF p_town_of_birth IS NOT NULL THEN
129: OPEN csr_validate_locality(p_town_of_birth,p_region_of_birth,p_business_group_id);
130: FETCH csr_validate_locality INTO l_valid_locality;
131: IF csr_validate_locality%notfound THEN
132: hr_utility.set_message(800,'HR_520032_LOC_CNTY_INV');
133: hr_utility.raise_error;
134: END IF;
135: END IF;
136: END IF;

Line 133: hr_utility.raise_error;

129: OPEN csr_validate_locality(p_town_of_birth,p_region_of_birth,p_business_group_id);
130: FETCH csr_validate_locality INTO l_valid_locality;
131: IF csr_validate_locality%notfound THEN
132: hr_utility.set_message(800,'HR_520032_LOC_CNTY_INV');
133: hr_utility.raise_error;
134: END IF;
135: END IF;
136: END IF;
137: END IF;

Line 138: hr_utility.set_location('Person validation :: ',3);

134: END IF;
135: END IF;
136: END IF;
137: END IF;
138: hr_utility.set_location('Person validation :: ',3);
139: -- ni validation -- DOB,Birth Place, Gender,residence, citizenship -- npc and previous npc
140: IF nvl(p_national_identifier,hr_api.g_varchar2) <> hr_api.g_varchar2 THEN
141: l_valid_ni := per_ro_ni_validation.validate_ni( p_person_id,
142: p_business_group_id,

Line 150: hr_utility.set_location('Person validation :: '||l_valid_ni,4);

146: p_country_of_birth,
147: p_region_of_birth,
148: p_per_information2,
149: p_per_information1 );
150: hr_utility.set_location('Person validation :: '||l_valid_ni,4);
151: IF l_valid_ni <> 0 THEN
152: IF l_valid_ni = 1 THEN
153: hr_utility.set_message(800,'HR_520037_INVALID_NI_DIGITS');
154: elsif l_valid_ni = 2 THEN

Line 153: hr_utility.set_message(800,'HR_520037_INVALID_NI_DIGITS');

149: p_per_information1 );
150: hr_utility.set_location('Person validation :: '||l_valid_ni,4);
151: IF l_valid_ni <> 0 THEN
152: IF l_valid_ni = 1 THEN
153: hr_utility.set_message(800,'HR_520037_INVALID_NI_DIGITS');
154: elsif l_valid_ni = 2 THEN
155: hr_utility.set_message(800,'HR_520038_INVALID_NI');
156: elsif l_valid_ni = 3 THEN
157: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');

Line 155: hr_utility.set_message(800,'HR_520038_INVALID_NI');

151: IF l_valid_ni <> 0 THEN
152: IF l_valid_ni = 1 THEN
153: hr_utility.set_message(800,'HR_520037_INVALID_NI_DIGITS');
154: elsif l_valid_ni = 2 THEN
155: hr_utility.set_message(800,'HR_520038_INVALID_NI');
156: elsif l_valid_ni = 3 THEN
157: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');
158: elsif l_valid_ni = 4 THEN
159: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');

Line 157: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');

153: hr_utility.set_message(800,'HR_520037_INVALID_NI_DIGITS');
154: elsif l_valid_ni = 2 THEN
155: hr_utility.set_message(800,'HR_520038_INVALID_NI');
156: elsif l_valid_ni = 3 THEN
157: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');
158: elsif l_valid_ni = 4 THEN
159: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');
160: elsif l_valid_ni = 5 THEN
161: hr_utility.set_message(800,'HR_520041_INVALID_NI_BIRTH');

Line 159: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');

155: hr_utility.set_message(800,'HR_520038_INVALID_NI');
156: elsif l_valid_ni = 3 THEN
157: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');
158: elsif l_valid_ni = 4 THEN
159: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');
160: elsif l_valid_ni = 5 THEN
161: hr_utility.set_message(800,'HR_520041_INVALID_NI_BIRTH');
162: END IF;
163: hr_utility.raise_error;

Line 161: hr_utility.set_message(800,'HR_520041_INVALID_NI_BIRTH');

157: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');
158: elsif l_valid_ni = 4 THEN
159: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');
160: elsif l_valid_ni = 5 THEN
161: hr_utility.set_message(800,'HR_520041_INVALID_NI_BIRTH');
162: END IF;
163: hr_utility.raise_error;
164: -- raise warning when 6
165: END IF;

Line 163: hr_utility.raise_error;

159: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');
160: elsif l_valid_ni = 5 THEN
161: hr_utility.set_message(800,'HR_520041_INVALID_NI_BIRTH');
162: END IF;
163: hr_utility.raise_error;
164: -- raise warning when 6
165: END IF;
166: END IF;
167: hr_utility.set_location('Person validation :: '||l_valid_ni,5);

Line 167: hr_utility.set_location('Person validation :: '||l_valid_ni,5);

163: hr_utility.raise_error;
164: -- raise warning when 6
165: END IF;
166: END IF;
167: hr_utility.set_location('Person validation :: '||l_valid_ni,5);
168: IF nvl(p_per_information4,hr_api.g_varchar2) <> hr_api.g_varchar2 THEN
169: l_valid_ni := 10;
170: l_valid_ni := per_ro_ni_validation.validate_ni( p_person_id,
171: p_business_group_id,

Line 179: hr_utility.set_location('Person validation :: '||l_valid_ni,6);

175: p_country_of_birth,
176: p_region_of_birth,
177: p_per_information2,
178: p_per_information1 );
179: hr_utility.set_location('Person validation :: '||l_valid_ni,6);
180: IF l_valid_ni <> 0 THEN
181: IF l_valid_ni = 1 THEN
182: hr_utility.set_message(800,'HR_520037_INVALID_NI_DIGITS');
183: elsif l_valid_ni = 2 THEN

Line 182: hr_utility.set_message(800,'HR_520037_INVALID_NI_DIGITS');

178: p_per_information1 );
179: hr_utility.set_location('Person validation :: '||l_valid_ni,6);
180: IF l_valid_ni <> 0 THEN
181: IF l_valid_ni = 1 THEN
182: hr_utility.set_message(800,'HR_520037_INVALID_NI_DIGITS');
183: elsif l_valid_ni = 2 THEN
184: hr_utility.set_message(800,'HR_520038_INVALID_NI');
185: elsif l_valid_ni = 3 THEN
186: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');

Line 184: hr_utility.set_message(800,'HR_520038_INVALID_NI');

180: IF l_valid_ni <> 0 THEN
181: IF l_valid_ni = 1 THEN
182: hr_utility.set_message(800,'HR_520037_INVALID_NI_DIGITS');
183: elsif l_valid_ni = 2 THEN
184: hr_utility.set_message(800,'HR_520038_INVALID_NI');
185: elsif l_valid_ni = 3 THEN
186: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');
187: elsif l_valid_ni = 4 THEN
188: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');

Line 186: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');

182: hr_utility.set_message(800,'HR_520037_INVALID_NI_DIGITS');
183: elsif l_valid_ni = 2 THEN
184: hr_utility.set_message(800,'HR_520038_INVALID_NI');
185: elsif l_valid_ni = 3 THEN
186: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');
187: elsif l_valid_ni = 4 THEN
188: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');
189: elsif l_valid_ni = 5 THEN
190: hr_utility.set_message(800,'HR_520041_INVALID_NI_BIRTH');

Line 188: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');

184: hr_utility.set_message(800,'HR_520038_INVALID_NI');
185: elsif l_valid_ni = 3 THEN
186: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');
187: elsif l_valid_ni = 4 THEN
188: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');
189: elsif l_valid_ni = 5 THEN
190: hr_utility.set_message(800,'HR_520041_INVALID_NI_BIRTH');
191: END IF;
192: hr_utility.raise_error;

Line 190: hr_utility.set_message(800,'HR_520041_INVALID_NI_BIRTH');

186: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');
187: elsif l_valid_ni = 4 THEN
188: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');
189: elsif l_valid_ni = 5 THEN
190: hr_utility.set_message(800,'HR_520041_INVALID_NI_BIRTH');
191: END IF;
192: hr_utility.raise_error;
193: -- raise warning when 6
194: END IF;

Line 192: hr_utility.raise_error;

188: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');
189: elsif l_valid_ni = 5 THEN
190: hr_utility.set_message(800,'HR_520041_INVALID_NI_BIRTH');
191: END IF;
192: hr_utility.raise_error;
193: -- raise warning when 6
194: END IF;
195: hr_utility.set_location('Person validation :: ',7);
196: END IF;

Line 195: hr_utility.set_location('Person validation :: ',7);

191: END IF;
192: hr_utility.raise_error;
193: -- raise warning when 6
194: END IF;
195: hr_utility.set_location('Person validation :: ',7);
196: END IF;
197: END validate_ro_employee;
198:
199: PROCEDURE validate_ro_employee_create(

Line 216: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN

212: )
213: AS
214: l_person_id NUMBER DEFAULT NULL;
215: BEGIN
216: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
217: hr_utility.trace('RO not installed.Leaving person validation');
218: RETURN;
219: END IF;
220:

Line 217: hr_utility.trace('RO not installed.Leaving person validation');

213: AS
214: l_person_id NUMBER DEFAULT NULL;
215: BEGIN
216: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
217: hr_utility.trace('RO not installed.Leaving person validation');
218: RETURN;
219: END IF;
220:
221: validate_ro_employee(

Line 264: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN

260: l_per_information1 varchar2(10);
261: l_per_information2 varchar2(10);
262: l_per_information4 varchar2(13);
263: BEGIN
264: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
265: hr_utility.trace('RO not installed.Leaving person validation');
266: RETURN;
267: END IF;
268: BEGIN

Line 265: hr_utility.trace('RO not installed.Leaving person validation');

261: l_per_information2 varchar2(10);
262: l_per_information4 varchar2(13);
263: BEGIN
264: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
265: hr_utility.trace('RO not installed.Leaving person validation');
266: RETURN;
267: END IF;
268: BEGIN
269: SELECT BUSINESS_GROUP_ID,

Line 291: hr_utility.trace('Unable to fetch National Identifier');

287: WHERE PERSON_ID = P_PERSON_ID
288: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
289: EXCEPTION
290: WHEN OTHERS THEN
291: hr_utility.trace('Unable to fetch National Identifier');
292: END;
293: END IF;
294:
295: l_sex := p_sex;

Line 305: hr_utility.trace('Unable to fetch Gender');

301: WHERE PERSON_ID = P_PERSON_ID
302: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
303: EXCEPTION
304: WHEN OTHERS THEN
305: hr_utility.trace('Unable to fetch Gender');
306: END;
307: END IF;
308:
309: l_country_of_birth := p_country_of_birth;

Line 319: hr_utility.trace('Unable to fetch country_of_birth');

315: WHERE PERSON_ID = P_PERSON_ID
316: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
317: EXCEPTION
318: WHEN OTHERS THEN
319: hr_utility.trace('Unable to fetch country_of_birth');
320: END;
321: END IF;
322:
323: l_region_of_birth := p_region_of_birth;

Line 333: hr_utility.trace('Unable to fetch region_of_birth');

329: WHERE PERSON_ID = P_PERSON_ID
330: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
331: EXCEPTION
332: WHEN OTHERS THEN
333: hr_utility.trace('Unable to fetch region_of_birth');
334: END;
335: END IF;
336:
337: l_per_information1 := p_per_information1;

Line 347: hr_utility.trace('Unable to fetch Residence');

343: WHERE PERSON_ID = P_PERSON_ID
344: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
345: EXCEPTION
346: WHEN OTHERS THEN
347: hr_utility.trace('Unable to fetch Residence');
348: END;
349: END IF;
350:
351: l_per_information2 := p_per_information2;

Line 361: hr_utility.trace('Unable to fetch Citizenship');

357: WHERE PERSON_ID = P_PERSON_ID
358: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
359: EXCEPTION
360: WHEN OTHERS THEN
361: hr_utility.trace('Unable to fetch Citizenship');
362: END;
363: END IF;
364:
365: l_per_information4 := p_per_information4;

Line 375: hr_utility.trace('Unable to fetch Previous NPC/FRN');

371: WHERE PERSON_ID = P_PERSON_ID
372: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
373: EXCEPTION
374: WHEN OTHERS THEN
375: hr_utility.trace('Unable to fetch Previous NPC/FRN');
376: END;
377: END IF;
378:
379: validate_ro_employee(