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

Line 64: hr_utility.set_location('Entering : '||l_proc,5);

60: l_exists varchar2(1);
61:
62: BEGIN
63: l_proc:= g_package||'CHECK_RO_LOCATION';
64: hr_utility.set_location('Entering : '||l_proc,5);
65:
66: if p_style <> 'RO' and p_style <> hr_api.g_varchar2 then
67: hr_utility.set_location(l_proc,10);
68: hr_utility.set_message(800,'HR_520030_LOC_STYLE_WRNG');

Line 67: hr_utility.set_location(l_proc,10);

63: l_proc:= g_package||'CHECK_RO_LOCATION';
64: hr_utility.set_location('Entering : '||l_proc,5);
65:
66: if p_style <> 'RO' and p_style <> hr_api.g_varchar2 then
67: hr_utility.set_location(l_proc,10);
68: hr_utility.set_message(800,'HR_520030_LOC_STYLE_WRNG');
69: hr_utility.raise_error;
70: end if;
71:

Line 68: hr_utility.set_message(800,'HR_520030_LOC_STYLE_WRNG');

64: hr_utility.set_location('Entering : '||l_proc,5);
65:
66: if p_style <> 'RO' and p_style <> hr_api.g_varchar2 then
67: hr_utility.set_location(l_proc,10);
68: hr_utility.set_message(800,'HR_520030_LOC_STYLE_WRNG');
69: hr_utility.raise_error;
70: end if;
71:
72: if p_country <> 'RO' and p_country <> hr_api.g_varchar2 then

Line 69: hr_utility.raise_error;

65:
66: if p_style <> 'RO' and p_style <> hr_api.g_varchar2 then
67: hr_utility.set_location(l_proc,10);
68: hr_utility.set_message(800,'HR_520030_LOC_STYLE_WRNG');
69: hr_utility.raise_error;
70: end if;
71:
72: if p_country <> 'RO' and p_country <> hr_api.g_varchar2 then
73: hr_utility.set_location(l_proc,20);

Line 73: hr_utility.set_location(l_proc,20);

69: hr_utility.raise_error;
70: end if;
71:
72: if p_country <> 'RO' and p_country <> hr_api.g_varchar2 then
73: hr_utility.set_location(l_proc,20);
74: hr_utility.set_message(800,'HR_520031_LOC_CNTR_WRNG');
75: hr_utility.raise_error;
76: end if;
77:

Line 74: hr_utility.set_message(800,'HR_520031_LOC_CNTR_WRNG');

70: end if;
71:
72: if p_country <> 'RO' and p_country <> hr_api.g_varchar2 then
73: hr_utility.set_location(l_proc,20);
74: hr_utility.set_message(800,'HR_520031_LOC_CNTR_WRNG');
75: hr_utility.raise_error;
76: end if;
77:
78: hr_utility.set_location(l_proc,30);

Line 75: hr_utility.raise_error;

71:
72: if p_country <> 'RO' and p_country <> hr_api.g_varchar2 then
73: hr_utility.set_location(l_proc,20);
74: hr_utility.set_message(800,'HR_520031_LOC_CNTR_WRNG');
75: hr_utility.raise_error;
76: end if;
77:
78: hr_utility.set_location(l_proc,30);
79:

Line 78: hr_utility.set_location(l_proc,30);

74: hr_utility.set_message(800,'HR_520031_LOC_CNTR_WRNG');
75: hr_utility.raise_error;
76: end if;
77:
78: hr_utility.set_location(l_proc,30);
79:
80: if p_address_line_1 <> hr_api.g_varchar2 then
81: open csr_county_valid ;
82: fetch csr_county_valid into l_exists;

Line 84: hr_utility.set_location(l_proc,35);

80: if p_address_line_1 <> hr_api.g_varchar2 then
81: open csr_county_valid ;
82: fetch csr_county_valid into l_exists;
83: if csr_county_valid%NOTFOUND then
84: hr_utility.set_location(l_proc,35);
85: hr_utility.set_message(800,'HR_520032_LOC_CNTY_INV');
86: hr_utility.raise_error;
87: end if;
88: close csr_county_valid ;

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

81: open csr_county_valid ;
82: fetch csr_county_valid into l_exists;
83: if csr_county_valid%NOTFOUND then
84: hr_utility.set_location(l_proc,35);
85: hr_utility.set_message(800,'HR_520032_LOC_CNTY_INV');
86: hr_utility.raise_error;
87: end if;
88: close csr_county_valid ;
89: end if;

Line 86: hr_utility.raise_error;

82: fetch csr_county_valid into l_exists;
83: if csr_county_valid%NOTFOUND then
84: hr_utility.set_location(l_proc,35);
85: hr_utility.set_message(800,'HR_520032_LOC_CNTY_INV');
86: hr_utility.raise_error;
87: end if;
88: close csr_county_valid ;
89: end if;
90:

Line 91: hr_utility.set_location(l_proc,40);

87: end if;
88: close csr_county_valid ;
89: end if;
90:
91: hr_utility.set_location(l_proc,40);
92:
93: if p_address_line_2 <> hr_api.g_varchar2 then
94: if p_address_line_1 = hr_api.g_varchar2 then
95: hr_utility.set_location(l_proc,42);

Line 95: hr_utility.set_location(l_proc,42);

91: hr_utility.set_location(l_proc,40);
92:
93: if p_address_line_2 <> hr_api.g_varchar2 then
94: if p_address_line_1 = hr_api.g_varchar2 then
95: hr_utility.set_location(l_proc,42);
96: hr_utility.set_message(800,'HR_520034_LOC_CNTY_NOT_ENT');
97: hr_utility.raise_error;
98: else
99: open csr_locality_valid ;

Line 96: hr_utility.set_message(800,'HR_520034_LOC_CNTY_NOT_ENT');

92:
93: if p_address_line_2 <> hr_api.g_varchar2 then
94: if p_address_line_1 = hr_api.g_varchar2 then
95: hr_utility.set_location(l_proc,42);
96: hr_utility.set_message(800,'HR_520034_LOC_CNTY_NOT_ENT');
97: hr_utility.raise_error;
98: else
99: open csr_locality_valid ;
100: fetch csr_locality_valid into l_exists;

Line 97: hr_utility.raise_error;

93: if p_address_line_2 <> hr_api.g_varchar2 then
94: if p_address_line_1 = hr_api.g_varchar2 then
95: hr_utility.set_location(l_proc,42);
96: hr_utility.set_message(800,'HR_520034_LOC_CNTY_NOT_ENT');
97: hr_utility.raise_error;
98: else
99: open csr_locality_valid ;
100: fetch csr_locality_valid into l_exists;
101: if csr_locality_valid%NOTFOUND then

Line 102: hr_utility.set_location(l_proc,45);

98: else
99: open csr_locality_valid ;
100: fetch csr_locality_valid into l_exists;
101: if csr_locality_valid%NOTFOUND then
102: hr_utility.set_location(l_proc,45);
103: hr_utility.set_message(800,'HR_520033_LOC_LOCL_INV');
104: hr_utility.raise_error;
105: end if;
106: close csr_locality_valid ;

Line 103: hr_utility.set_message(800,'HR_520033_LOC_LOCL_INV');

99: open csr_locality_valid ;
100: fetch csr_locality_valid into l_exists;
101: if csr_locality_valid%NOTFOUND then
102: hr_utility.set_location(l_proc,45);
103: hr_utility.set_message(800,'HR_520033_LOC_LOCL_INV');
104: hr_utility.raise_error;
105: end if;
106: close csr_locality_valid ;
107: end if;

Line 104: hr_utility.raise_error;

100: fetch csr_locality_valid into l_exists;
101: if csr_locality_valid%NOTFOUND then
102: hr_utility.set_location(l_proc,45);
103: hr_utility.set_message(800,'HR_520033_LOC_LOCL_INV');
104: hr_utility.raise_error;
105: end if;
106: close csr_locality_valid ;
107: end if;
108: end if;

Line 110: hr_utility.set_location(l_proc,50);

106: close csr_locality_valid ;
107: end if;
108: end if;
109:
110: hr_utility.set_location(l_proc,50);
111:
112: if p_postal_code <> hr_api.g_varchar2 then
113: if length(p_postal_code) <> 6 then
114: hr_utility.set_location(l_proc,55);

Line 114: hr_utility.set_location(l_proc,55);

110: hr_utility.set_location(l_proc,50);
111:
112: if p_postal_code <> hr_api.g_varchar2 then
113: if length(p_postal_code) <> 6 then
114: hr_utility.set_location(l_proc,55);
115: hr_utility.set_message(800,'HR_520035_LOC_PC_INV');
116: hr_utility.raise_error;
117: end if;
118: end if;

Line 115: hr_utility.set_message(800,'HR_520035_LOC_PC_INV');

111:
112: if p_postal_code <> hr_api.g_varchar2 then
113: if length(p_postal_code) <> 6 then
114: hr_utility.set_location(l_proc,55);
115: hr_utility.set_message(800,'HR_520035_LOC_PC_INV');
116: hr_utility.raise_error;
117: end if;
118: end if;
119:

Line 116: hr_utility.raise_error;

112: if p_postal_code <> hr_api.g_varchar2 then
113: if length(p_postal_code) <> 6 then
114: hr_utility.set_location(l_proc,55);
115: hr_utility.set_message(800,'HR_520035_LOC_PC_INV');
116: hr_utility.raise_error;
117: end if;
118: end if;
119:
120: hr_utility.set_location('Leaving : '||l_proc,50);

Line 120: hr_utility.set_location('Leaving : '||l_proc,50);

116: hr_utility.raise_error;
117: end if;
118: end if;
119:
120: hr_utility.set_location('Leaving : '||l_proc,50);
121:
122: END CHECK_RO_LOCATION;
123:
124:

Line 146: hr_utility.set_location('Entering : '||l_proc,5);

142: l_proc varchar2(60);
143:
144: BEGIN
145: l_proc:= g_package||'CREATE_RO_LOCATION';
146: hr_utility.set_location('Entering : '||l_proc,5);
147: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
148: hr_utility.set_location('Leaving : '||l_proc,10);
149: return;
150: END IF;

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

143:
144: BEGIN
145: l_proc:= g_package||'CREATE_RO_LOCATION';
146: hr_utility.set_location('Entering : '||l_proc,5);
147: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
148: hr_utility.set_location('Leaving : '||l_proc,10);
149: return;
150: END IF;
151:

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

144: BEGIN
145: l_proc:= g_package||'CREATE_RO_LOCATION';
146: hr_utility.set_location('Entering : '||l_proc,5);
147: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
148: hr_utility.set_location('Leaving : '||l_proc,10);
149: return;
150: END IF;
151:
152: -- Another location with same location code shouldn't exist

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

153:
154: open csr_location_exists;
155: fetch csr_location_exists into l_exists;
156: if csr_location_exists%FOUND then
157: hr_utility.set_message(800,'HR_520029_LOC_EXISTS');
158: hr_utility.raise_error;
159: end if;
160: close csr_location_exists;
161:

Line 158: hr_utility.raise_error;

154: open csr_location_exists;
155: fetch csr_location_exists into l_exists;
156: if csr_location_exists%FOUND then
157: hr_utility.set_message(800,'HR_520029_LOC_EXISTS');
158: hr_utility.raise_error;
159: end if;
160: close csr_location_exists;
161:
162: hr_utility.set_location(l_proc,15);

Line 162: hr_utility.set_location(l_proc,15);

158: hr_utility.raise_error;
159: end if;
160: close csr_location_exists;
161:
162: hr_utility.set_location(l_proc,15);
163:
164: CHECK_RO_LOCATION(p_address_line_1 => p_address_line_1
165: ,p_address_line_2 => p_address_line_2
166: ,p_country => p_country

Line 171: hr_utility.set_location('Leaving : '||l_proc,20);

167: ,p_postal_code => p_postal_code
168: ,p_style => p_style
169: );
170:
171: hr_utility.set_location('Leaving : '||l_proc,20);
172:
173: END CREATE_RO_LOCATION;
174:
175: PROCEDURE UPDATE_RO_LOCATION( p_address_line_1 IN VARCHAR2 DEFAULT NULL

Line 186: hr_utility.set_location('Entering : '||l_proc,5);

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

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

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

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

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

Line 191: hr_utility.set_location(l_proc,15);

187: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'RO') THEN
188: hr_utility.set_location('Leaving : '||l_proc,10);
189: return;
190: END IF;
191: hr_utility.set_location(l_proc,15);
192:
193: CHECK_RO_LOCATION(p_address_line_1 => p_address_line_1
194: ,p_address_line_2 => p_address_line_2
195: ,p_country => p_country

Line 200: hr_utility.set_location('Leaving : '||l_proc,20);

196: ,p_postal_code => p_postal_code
197: ,p_style => p_style
198: );
199:
200: hr_utility.set_location('Leaving : '||l_proc,20);
201:
202: END UPDATE_RO_LOCATION;
203:
204: END HR_RO_LOCATION_VAL;