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_API

Line 14: IF (hr_api.not_exists_in_hr_lookups (p_effective_date, p_lookup_type, p_argument_value ) ) THEN

10: IS
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;

Line 114: hr_api.mandatory_arg_error (p_api_name => l_proc, p_argument => 'First Name', p_argument_value => p_first_name );

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 );
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);

Line 117: IF nvl(p_per_information1,hr_api.g_varchar2) <> hr_api.g_varchar2 THEN

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;
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);

Line 120: IF nvl(p_per_information2,hr_api.g_varchar2) <> hr_api.g_varchar2 THEN

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

Line 126: IF nvl(p_region_of_birth,hr_api.g_varchar2) <> hr_api.g_varchar2 THEN

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');
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;

Line 127: l_county_code := hr_api.return_lookup_code(p_region_of_birth,'RO_PER_COUNTIES');

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');
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

Line 140: IF nvl(p_national_identifier,hr_api.g_varchar2) <> hr_api.g_varchar2 THEN

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,
143: p_national_identifier,
144: p_sex,

Line 168: IF nvl(p_per_information4,hr_api.g_varchar2) <> hr_api.g_varchar2 THEN

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,
172: p_per_information4,

Line 282: IF (p_national_identifier = hr_api.g_varchar2) THEN

278: NULL;
279: END;
280:
281: l_national_identifier := p_national_identifier;
282: IF (p_national_identifier = hr_api.g_varchar2) THEN
283: BEGIN
284: SELECT national_identifier
285: INTO l_national_identifier
286: FROM PER_ALL_PEOPLE_F

Line 296: IF (p_sex = hr_api.g_varchar2) THEN

292: END;
293: END IF;
294:
295: l_sex := p_sex;
296: IF (p_sex = hr_api.g_varchar2) THEN
297: BEGIN
298: SELECT sex
299: INTO l_sex
300: FROM PER_ALL_PEOPLE_F

Line 310: IF (p_country_of_birth = hr_api.g_varchar2) THEN

306: END;
307: END IF;
308:
309: l_country_of_birth := p_country_of_birth;
310: IF (p_country_of_birth = hr_api.g_varchar2) THEN
311: BEGIN
312: SELECT country_of_birth
313: INTO l_country_of_birth
314: FROM PER_ALL_PEOPLE_F

Line 324: IF (p_region_of_birth = hr_api.g_varchar2) THEN

320: END;
321: END IF;
322:
323: l_region_of_birth := p_region_of_birth;
324: IF (p_region_of_birth = hr_api.g_varchar2) THEN
325: BEGIN
326: SELECT region_of_birth
327: INTO l_region_of_birth
328: FROM PER_ALL_PEOPLE_F

Line 338: IF (p_per_information1 = hr_api.g_varchar2) THEN

334: END;
335: END IF;
336:
337: l_per_information1 := p_per_information1;
338: IF (p_per_information1 = hr_api.g_varchar2) THEN
339: BEGIN
340: SELECT per_information1
341: INTO l_per_information1
342: FROM PER_ALL_PEOPLE_F

Line 352: IF (p_per_information2 = hr_api.g_varchar2) THEN

348: END;
349: END IF;
350:
351: l_per_information2 := p_per_information2;
352: IF (p_per_information2 = hr_api.g_varchar2) THEN
353: BEGIN
354: SELECT per_information2
355: INTO l_per_information2
356: FROM PER_ALL_PEOPLE_F

Line 366: IF (p_per_information4 = hr_api.g_varchar2) THEN

362: END;
363: END IF;
364:
365: l_per_information4 := p_per_information4;
366: IF (p_per_information4 = hr_api.g_varchar2) THEN
367: BEGIN
368: SELECT per_information4
369: INTO l_per_information4
370: FROM PER_ALL_PEOPLE_F