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.PER_RO_ADDRESS dependencies on HR_UTILITY

Line 45: hr_utility.set_message(800,'HR_520022_DUPLICATE_ADDRESS');

41: end if;
42: close c_duplicate_address;
43:
44: if l_duplicate_flag then
45: hr_utility.set_message(800,'HR_520022_DUPLICATE_ADDRESS');
46: hr_utility.raise_error;
47: end if;
48:
49: END check_address_unique;

Line 46: hr_utility.raise_error;

42: close c_duplicate_address;
43:
44: if l_duplicate_flag then
45: hr_utility.set_message(800,'HR_520022_DUPLICATE_ADDRESS');
46: hr_utility.raise_error;
47: end if;
48:
49: END check_address_unique;
50:

Line 69: hr_utility.set_message(800,'HR_520024_ADDRESS_TYPE_NULL');

65: --
66: -- Check that Address type is entered
67: --
68: IF ( p_address_type IS NULL ) THEN
69: hr_utility.set_message(800,'HR_520024_ADDRESS_TYPE_NULL');
70: hr_utility.raise_error;
71: END IF;
72: --
73: -- Check that Street Name is entered when street type is entered

Line 70: hr_utility.raise_error;

66: -- Check that Address type is entered
67: --
68: IF ( p_address_type IS NULL ) THEN
69: hr_utility.set_message(800,'HR_520024_ADDRESS_TYPE_NULL');
70: hr_utility.raise_error;
71: END IF;
72: --
73: -- Check that Street Name is entered when street type is entered
74: --

Line 76: hr_utility.set_message(800,'HR_520025_ST_NAME_NOT_SPEC');

72: --
73: -- Check that Street Name is entered when street type is entered
74: --
75: IF ( p_address_line1 IS NOT NULL ) and ( p_address_line3 IS NULL ) THEN
76: hr_utility.set_message(800,'HR_520025_ST_NAME_NOT_SPEC');
77: hr_utility.raise_error;
78: END IF;
79: --
80: if p_address_line1 is not null and p_address_line2 is not null then

Line 77: hr_utility.raise_error;

73: -- Check that Street Name is entered when street type is entered
74: --
75: IF ( p_address_line1 IS NOT NULL ) and ( p_address_line3 IS NULL ) THEN
76: hr_utility.set_message(800,'HR_520025_ST_NAME_NOT_SPEC');
77: hr_utility.raise_error;
78: END IF;
79: --
80: if p_address_line1 is not null and p_address_line2 is not null then
81: begin

Line 124: hr_utility.set_message(800,'HR_520023_LOC_NOT_IN_COUNTY');

120: l_locality_exists := 0;
121: end;
122:
123: if l_locality_exists = 0 then
124: hr_utility.set_message(800,'HR_520023_LOC_NOT_IN_COUNTY');
125: hr_utility.raise_error;
126: end if;
127:
128: end if;

Line 125: hr_utility.raise_error;

121: end;
122:
123: if l_locality_exists = 0 then
124: hr_utility.set_message(800,'HR_520023_LOC_NOT_IN_COUNTY');
125: hr_utility.raise_error;
126: end if;
127:
128: end if;
129: --

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

152: )
153: IS
154: BEGIN
155: --
156: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
157: hr_utility.trace('RO not installed.Leaving create_ro_address');
158: return;
159: END IF;
160:

Line 157: hr_utility.trace('RO not installed.Leaving create_ro_address');

153: IS
154: BEGIN
155: --
156: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
157: hr_utility.trace('RO not installed.Leaving create_ro_address');
158: return;
159: END IF;
160:
161: IF p_style = 'RO' THEN

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

189: l_person_id per_addresses.person_id%TYPE;
190: --
191: BEGIN
192: --
193: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
194: hr_utility.trace('RO not installed.Leaving update_ro_address');
195: return;
196: END IF;
197:

Line 194: hr_utility.trace('RO not installed.Leaving update_ro_address');

190: --
191: BEGIN
192: --
193: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
194: hr_utility.trace('RO not installed.Leaving update_ro_address');
195: return;
196: END IF;
197:
198: OPEN c_get_style(p_address_id);

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

231: l_person_id per_addresses.person_id%TYPE;
232: --
233: BEGIN
234: --
235: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
236: hr_utility.trace('RO not installed.Leaving update_pl_address_style');
237: return;
238: END IF;
239: IF p_style='RO' THEN

Line 236: hr_utility.trace('RO not installed.Leaving update_pl_address_style');

232: --
233: BEGIN
234: --
235: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
236: hr_utility.trace('RO not installed.Leaving update_pl_address_style');
237: return;
238: END IF;
239: IF p_style='RO' THEN
240: OPEN c_get_style(p_address_id);