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_CONTACT_REL_VAL dependencies on HR_UTILITY

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

25: and pet.person_type_id = p_person_type_id
26: and pet.active_flag = 'Y';
27: BEGIN
28: l_proc := g_package||'CHECK_RO_CONTACT';
29: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
30: hr_utility.set_location('Leaving : '||l_proc,10);
31: return;
32: END IF;
33:

Line 30: hr_utility.set_location('Leaving : '||l_proc,10);

26: and pet.active_flag = 'Y';
27: BEGIN
28: l_proc := g_package||'CHECK_RO_CONTACT';
29: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
30: hr_utility.set_location('Leaving : '||l_proc,10);
31: return;
32: END IF;
33:
34: IF nvl(p_person_type_id,hr_api.g_number) <> hr_api.g_number THEN

Line 40: hr_utility.set_message(801, 'HR_7513_PER_TYPE_INVALID');

36: fetch csr_person_type
37: into l_exist;
38: if csr_person_type%notfound then
39: close csr_person_type;
40: hr_utility.set_message(801, 'HR_7513_PER_TYPE_INVALID');
41: hr_utility.raise_error;
42: end if;
43: close csr_person_type;
44: end if;

Line 41: hr_utility.raise_error;

37: into l_exist;
38: if csr_person_type%notfound then
39: close csr_person_type;
40: hr_utility.set_message(801, 'HR_7513_PER_TYPE_INVALID');
41: hr_utility.raise_error;
42: end if;
43: close csr_person_type;
44: end if;
45:

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

73: ,p_country_of_birth
74: ,p_region_of_birth
75: ,p_per_information2
76: ,p_per_information1);
77: hr_utility.set_location('Person validation :: '||l_valid_ni,4);
78: IF l_valid_ni <> 0 THEN
79: IF l_valid_ni = 1 THEN
80: hr_utility.set_message(800,'HR_520037_INVALID_NI_DIGITS');
81: elsif l_valid_ni = 2 THEN

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

76: ,p_per_information1);
77: hr_utility.set_location('Person validation :: '||l_valid_ni,4);
78: IF l_valid_ni <> 0 THEN
79: IF l_valid_ni = 1 THEN
80: hr_utility.set_message(800,'HR_520037_INVALID_NI_DIGITS');
81: elsif l_valid_ni = 2 THEN
82: hr_utility.set_message(800,'HR_520038_INVALID_NI');
83: elsif l_valid_ni = 3 THEN
84: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');

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

78: IF l_valid_ni <> 0 THEN
79: IF l_valid_ni = 1 THEN
80: hr_utility.set_message(800,'HR_520037_INVALID_NI_DIGITS');
81: elsif l_valid_ni = 2 THEN
82: hr_utility.set_message(800,'HR_520038_INVALID_NI');
83: elsif l_valid_ni = 3 THEN
84: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');
85: elsif l_valid_ni = 4 THEN
86: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');

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

80: hr_utility.set_message(800,'HR_520037_INVALID_NI_DIGITS');
81: elsif l_valid_ni = 2 THEN
82: hr_utility.set_message(800,'HR_520038_INVALID_NI');
83: elsif l_valid_ni = 3 THEN
84: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');
85: elsif l_valid_ni = 4 THEN
86: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');
87: elsif l_valid_ni = 5 THEN
88: hr_utility.set_message(800,'HR_520041_INVALID_NI_BIRTH');

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

82: hr_utility.set_message(800,'HR_520038_INVALID_NI');
83: elsif l_valid_ni = 3 THEN
84: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');
85: elsif l_valid_ni = 4 THEN
86: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');
87: elsif l_valid_ni = 5 THEN
88: hr_utility.set_message(800,'HR_520041_INVALID_NI_BIRTH');
89: END IF;
90: hr_utility.raise_error;

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

84: hr_utility.set_message(800,'HR_520039_INVALID_NI_DOB');
85: elsif l_valid_ni = 4 THEN
86: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');
87: elsif l_valid_ni = 5 THEN
88: hr_utility.set_message(800,'HR_520041_INVALID_NI_BIRTH');
89: END IF;
90: hr_utility.raise_error;
91: -- raise warning when 6
92: END IF;

Line 90: hr_utility.raise_error;

86: hr_utility.set_message(800,'HR_520040_INVALID_NI_GENDER');
87: elsif l_valid_ni = 5 THEN
88: hr_utility.set_message(800,'HR_520041_INVALID_NI_BIRTH');
89: END IF;
90: hr_utility.raise_error;
91: -- raise warning when 6
92: END IF;
93: END IF;
94: hr_utility.set_location('Leaving : '||l_proc,10);

Line 94: hr_utility.set_location('Leaving : '||l_proc,10);

90: hr_utility.raise_error;
91: -- raise warning when 6
92: END IF;
93: END IF;
94: hr_utility.set_location('Leaving : '||l_proc,10);
95: END CHECK_RO_CONTACT;
96:
97: /*-------------------------------------------------------------------------
98: ---- CREATE_RO_CONTACT_PERSON start

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

114: l_person_type_id per_person_types.person_type_id%type := p_person_type_id;
115: l_valid_ni NUMBER DEFAULT 10;
116: BEGIN
117: l_proc := g_package||'CREATE_RO_CONTACT_PERSON';
118: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
119: hr_utility.set_location('Leaving : '||l_proc,10);
120: return;
121: END IF;
122:

Line 119: hr_utility.set_location('Leaving : '||l_proc,10);

115: l_valid_ni NUMBER DEFAULT 10;
116: BEGIN
117: l_proc := g_package||'CREATE_RO_CONTACT_PERSON';
118: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
119: hr_utility.set_location('Leaving : '||l_proc,10);
120: return;
121: END IF;
122:
123: per_per_bus.chk_person_type

Line 140: hr_utility.set_location('Leaving : '||l_proc,10);

136: ,p_country_of_birth
137: ,p_region_of_birth
138: ,p_per_information1
139: ,p_per_information2);
140: hr_utility.set_location('Leaving : '||l_proc,10);
141:
142: END;
143:
144:

Line 187: hr_utility.set_location('Entering : '||l_proc,10);

183: --l_user_person_type varchar2(60);--per_person_type.user_person_type%Type;
184: l_proc varchar2(60);
185: BEGIN
186: l_proc:=g_package||'CREATE_RO_CONTACT_REL';
187: hr_utility.set_location('Entering : '||l_proc,10);
188: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
189: hr_utility.set_location('Leaving : '||l_proc,10);
190: return;
191: END IF;

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

184: l_proc varchar2(60);
185: BEGIN
186: l_proc:=g_package||'CREATE_RO_CONTACT_REL';
187: hr_utility.set_location('Entering : '||l_proc,10);
188: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
189: hr_utility.set_location('Leaving : '||l_proc,10);
190: return;
191: END IF;
192:

Line 189: hr_utility.set_location('Leaving : '||l_proc,10);

185: BEGIN
186: l_proc:=g_package||'CREATE_RO_CONTACT_REL';
187: hr_utility.set_location('Entering : '||l_proc,10);
188: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
189: hr_utility.set_location('Leaving : '||l_proc,10);
190: return;
191: END IF;
192:
193: if P_CONTACT_TYPE NOT IN ('EC','ES','PR1','PR2','OTH') THEN

Line 194: hr_utility.set_message(800,'HR_RO_INV_CONTACT_TYPE');

190: return;
191: END IF;
192:
193: if P_CONTACT_TYPE NOT IN ('EC','ES','PR1','PR2','OTH') THEN
194: hr_utility.set_message(800,'HR_RO_INV_CONTACT_TYPE');
195: hr_utility.raise_error;
196: End If;
197:
198:

Line 195: hr_utility.raise_error;

191: END IF;
192:
193: if P_CONTACT_TYPE NOT IN ('EC','ES','PR1','PR2','OTH') THEN
194: hr_utility.set_message(800,'HR_RO_INV_CONTACT_TYPE');
195: hr_utility.raise_error;
196: End If;
197:
198:
199:

Line 204: hr_utility.set_message(800,'HR_CON_REL_OVERLAP_PL');

200: open cur_crl;
201: fetch cur_crl into nDummy_val;
202: IF cur_crl%found then
203: Close cur_crl;
204: hr_utility.set_message(800,'HR_CON_REL_OVERLAP_PL');
205: hr_utility.raise_error;
206: End If;
207: Close cur_crl;
208:

Line 205: hr_utility.raise_error;

201: fetch cur_crl into nDummy_val;
202: IF cur_crl%found then
203: Close cur_crl;
204: hr_utility.set_message(800,'HR_CON_REL_OVERLAP_PL');
205: hr_utility.raise_error;
206: End If;
207: Close cur_crl;
208:
209: check_ro_contact (NULL

Line 223: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');

219: ,null);
220:
221: /* Date of birth is mandatory in case of Employee'Childrem contact */
222: if P_DATE_OF_BIRTH is null and P_CONTACT_TYPE = 'EC' then
223: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');
224: hr_utility.raise_error;
225: end if;
226:
227:

Line 224: hr_utility.raise_error;

220:
221: /* Date of birth is mandatory in case of Employee'Childrem contact */
222: if P_DATE_OF_BIRTH is null and P_CONTACT_TYPE = 'EC' then
223: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');
224: hr_utility.raise_error;
225: end if;
226:
227:
228: END CREATE_RO_CONTACT_REL;

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

264: l_proc varchar2(60);
265: BEGIN
266: l_proc:=g_package||'UPDATE_RO_CONTACT_REL';
267:
268: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
269: hr_utility.set_location('Leaving : '||l_proc,10);
270: return;
271: END IF;
272:

Line 269: hr_utility.set_location('Leaving : '||l_proc,10);

265: BEGIN
266: l_proc:=g_package||'UPDATE_RO_CONTACT_REL';
267:
268: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
269: hr_utility.set_location('Leaving : '||l_proc,10);
270: return;
271: END IF;
272:
273: if P_CONTACT_TYPE NOT IN ('EC','ES','PR1','PR2','OTH') THEN

Line 274: hr_utility.set_message(800,'HR_RO_INV_CONTACT_TYPE');

270: return;
271: END IF;
272:
273: if P_CONTACT_TYPE NOT IN ('EC','ES','PR1','PR2','OTH') THEN
274: hr_utility.set_message(800,'HR_RO_INV_CONTACT_TYPE');
275: hr_utility.raise_error;
276: End If;
277:
278:

Line 275: hr_utility.raise_error;

271: END IF;
272:
273: if P_CONTACT_TYPE NOT IN ('EC','ES','PR1','PR2','OTH') THEN
274: hr_utility.set_message(800,'HR_RO_INV_CONTACT_TYPE');
275: hr_utility.raise_error;
276: End If;
277:
278:
279: open cur_crl;

Line 283: hr_utility.set_message(800,'HR_CON_REL_OVERLAP_PL');

279: open cur_crl;
280: fetch cur_crl into nDummy_val;
281: IF cur_crl%found then
282: Close cur_crl;
283: hr_utility.set_message(800,'HR_CON_REL_OVERLAP_PL');
284: hr_utility.raise_error;
285: End If;
286: Close cur_crl;
287:

Line 284: hr_utility.raise_error;

280: fetch cur_crl into nDummy_val;
281: IF cur_crl%found then
282: Close cur_crl;
283: hr_utility.set_message(800,'HR_CON_REL_OVERLAP_PL');
284: hr_utility.raise_error;
285: End If;
286: Close cur_crl;
287:
288: /* Date of birth is mandatory in case of Employee'Childrem contact */

Line 296: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');

292: fetch csr_dob_contact into l_contact_dob;
293: close csr_dob_contact;
294:
295: if l_contact_dob is null then
296: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');
297: hr_utility.raise_error;
298: end if;
299:
300: end if;

Line 297: hr_utility.raise_error;

293: close csr_dob_contact;
294:
295: if l_contact_dob is null then
296: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');
297: hr_utility.raise_error;
298: end if;
299:
300: end if;
301: