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

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := per_sht_shd.api_updating
47: (p_shared_type_id => p_shared_type_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_shared_type_id;
75: --
76: -- ----------------------------------------------------------------------------

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

109: l_api_updating boolean;
110: --
111: Begin
112: --
113: hr_utility.set_location('Entering:'||l_proc, 5);
114: --
115: l_api_updating := per_sht_shd.api_updating
116: (p_shared_type_id => p_shared_type_id,
117: p_object_version_number => p_object_version_number);

Line 134: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

130: p_effective_date => p_effective_date) then
131: --
132: -- raise error as does not exist as lookup
133: --
134: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
135: hr_utility.raise_error;
136: --
137: end if;
138: --

Line 135: hr_utility.raise_error;

131: --
132: -- raise error as does not exist as lookup
133: --
134: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
135: hr_utility.raise_error;
136: --
137: end if;
138: --
139: end if;

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

137: end if;
138: --
139: end if;
140: --
141: hr_utility.set_location('Leaving:'||l_proc,10);
142: --
143: end chk_system_type_cd;
144: --
145: -- ----------------------------------------------------------------------------

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

190: OR (p_business_group_id IS NULL));
191: --
192: Begin
193: --
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: hr_utility.set_location('value of shared_type_id:'||p_shared_type_id, 5);
196: hr_utility.set_location('value of shared_type_code:'||p_shared_type_code, 5);
197: hr_utility.set_location('value of system_type_cd:'||p_system_type_cd, 5);
198: hr_utility.set_location('value of lookup_type:'||p_lookup_type, 5);

Line 195: hr_utility.set_location('value of shared_type_id:'||p_shared_type_id, 5);

191: --
192: Begin
193: --
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: hr_utility.set_location('value of shared_type_id:'||p_shared_type_id, 5);
196: hr_utility.set_location('value of shared_type_code:'||p_shared_type_code, 5);
197: hr_utility.set_location('value of system_type_cd:'||p_system_type_cd, 5);
198: hr_utility.set_location('value of lookup_type:'||p_lookup_type, 5);
199: hr_utility.set_location('value of shared_type_name:'||p_shared_type_name, 5);

Line 196: hr_utility.set_location('value of shared_type_code:'||p_shared_type_code, 5);

192: Begin
193: --
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: hr_utility.set_location('value of shared_type_id:'||p_shared_type_id, 5);
196: hr_utility.set_location('value of shared_type_code:'||p_shared_type_code, 5);
197: hr_utility.set_location('value of system_type_cd:'||p_system_type_cd, 5);
198: hr_utility.set_location('value of lookup_type:'||p_lookup_type, 5);
199: hr_utility.set_location('value of shared_type_name:'||p_shared_type_name, 5);
200: hr_utility.set_location('value of business_group_id:'||p_business_group_id, 5);

Line 197: hr_utility.set_location('value of system_type_cd:'||p_system_type_cd, 5);

193: --
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: hr_utility.set_location('value of shared_type_id:'||p_shared_type_id, 5);
196: hr_utility.set_location('value of shared_type_code:'||p_shared_type_code, 5);
197: hr_utility.set_location('value of system_type_cd:'||p_system_type_cd, 5);
198: hr_utility.set_location('value of lookup_type:'||p_lookup_type, 5);
199: hr_utility.set_location('value of shared_type_name:'||p_shared_type_name, 5);
200: hr_utility.set_location('value of business_group_id:'||p_business_group_id, 5);
201: --

Line 198: hr_utility.set_location('value of lookup_type:'||p_lookup_type, 5);

194: hr_utility.set_location('Entering:'||l_proc, 5);
195: hr_utility.set_location('value of shared_type_id:'||p_shared_type_id, 5);
196: hr_utility.set_location('value of shared_type_code:'||p_shared_type_code, 5);
197: hr_utility.set_location('value of system_type_cd:'||p_system_type_cd, 5);
198: hr_utility.set_location('value of lookup_type:'||p_lookup_type, 5);
199: hr_utility.set_location('value of shared_type_name:'||p_shared_type_name, 5);
200: hr_utility.set_location('value of business_group_id:'||p_business_group_id, 5);
201: --
202: open c1;

Line 199: hr_utility.set_location('value of shared_type_name:'||p_shared_type_name, 5);

195: hr_utility.set_location('value of shared_type_id:'||p_shared_type_id, 5);
196: hr_utility.set_location('value of shared_type_code:'||p_shared_type_code, 5);
197: hr_utility.set_location('value of system_type_cd:'||p_system_type_cd, 5);
198: hr_utility.set_location('value of lookup_type:'||p_lookup_type, 5);
199: hr_utility.set_location('value of shared_type_name:'||p_shared_type_name, 5);
200: hr_utility.set_location('value of business_group_id:'||p_business_group_id, 5);
201: --
202: open c1;
203: fetch c1 into l_shared_type_id;

Line 200: hr_utility.set_location('value of business_group_id:'||p_business_group_id, 5);

196: hr_utility.set_location('value of shared_type_code:'||p_shared_type_code, 5);
197: hr_utility.set_location('value of system_type_cd:'||p_system_type_cd, 5);
198: hr_utility.set_location('value of lookup_type:'||p_lookup_type, 5);
199: hr_utility.set_location('value of shared_type_name:'||p_shared_type_name, 5);
200: hr_utility.set_location('value of business_group_id:'||p_business_group_id, 5);
201: --
202: open c1;
203: fetch c1 into l_shared_type_id;
204: if c1%found then

Line 211: hr_utility.set_message(800,'PER_SHARE_TYPE_KEY_EXISTS');

207: or (p_shared_type_id is not null and p_shared_type_id <> l_shared_type_id) then
208: close c1;
209: select hr_general.decode_lookup(p_lookup_type,p_system_type_cd) into l_lookup_code from dual;
210: -- different record is being updated inserted with same key, raise error.
211: hr_utility.set_message(800,'PER_SHARE_TYPE_KEY_EXISTS');
212: hr_utility.set_message_token('LOOKUP_TYPE',p_lookup_type);
213: hr_utility.set_message_token('SHARED_TYPE_CODE',p_shared_type_code);
214: hr_utility.set_message_token('LOOKUP_CODE',l_lookup_code);
215: hr_utility.raise_error;

Line 212: hr_utility.set_message_token('LOOKUP_TYPE',p_lookup_type);

208: close c1;
209: select hr_general.decode_lookup(p_lookup_type,p_system_type_cd) into l_lookup_code from dual;
210: -- different record is being updated inserted with same key, raise error.
211: hr_utility.set_message(800,'PER_SHARE_TYPE_KEY_EXISTS');
212: hr_utility.set_message_token('LOOKUP_TYPE',p_lookup_type);
213: hr_utility.set_message_token('SHARED_TYPE_CODE',p_shared_type_code);
214: hr_utility.set_message_token('LOOKUP_CODE',l_lookup_code);
215: hr_utility.raise_error;
216: --

Line 213: hr_utility.set_message_token('SHARED_TYPE_CODE',p_shared_type_code);

209: select hr_general.decode_lookup(p_lookup_type,p_system_type_cd) into l_lookup_code from dual;
210: -- different record is being updated inserted with same key, raise error.
211: hr_utility.set_message(800,'PER_SHARE_TYPE_KEY_EXISTS');
212: hr_utility.set_message_token('LOOKUP_TYPE',p_lookup_type);
213: hr_utility.set_message_token('SHARED_TYPE_CODE',p_shared_type_code);
214: hr_utility.set_message_token('LOOKUP_CODE',l_lookup_code);
215: hr_utility.raise_error;
216: --
217: end if;

Line 214: hr_utility.set_message_token('LOOKUP_CODE',l_lookup_code);

210: -- different record is being updated inserted with same key, raise error.
211: hr_utility.set_message(800,'PER_SHARE_TYPE_KEY_EXISTS');
212: hr_utility.set_message_token('LOOKUP_TYPE',p_lookup_type);
213: hr_utility.set_message_token('SHARED_TYPE_CODE',p_shared_type_code);
214: hr_utility.set_message_token('LOOKUP_CODE',l_lookup_code);
215: hr_utility.raise_error;
216: --
217: end if;
218: end if;

Line 215: hr_utility.raise_error;

211: hr_utility.set_message(800,'PER_SHARE_TYPE_KEY_EXISTS');
212: hr_utility.set_message_token('LOOKUP_TYPE',p_lookup_type);
213: hr_utility.set_message_token('SHARED_TYPE_CODE',p_shared_type_code);
214: hr_utility.set_message_token('LOOKUP_CODE',l_lookup_code);
215: hr_utility.raise_error;
216: --
217: end if;
218: end if;
219: close c1;

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

217: end if;
218: end if;
219: close c1;
220: --
221: hr_utility.set_location('Leaving:'||l_proc,10);
222: --
223: end chk_duplicate_key;
224: --
225: -- ----------------------------------------------------------------------------

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

230: --
231: l_proc varchar2(72) := g_package||'insert_validate';
232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --
236: -- Call all supporting business operations
237: --
238: chk_shared_type_id

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

254: p_business_group_id => p_rec.business_group_id);
255: --
256: -- hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
257: --
258: hr_utility.set_location(' Leaving:'||l_proc, 10);
259: End insert_validate;
260: --
261: -- ----------------------------------------------------------------------------
262: -- |---------------------------< update_validate >----------------------------|

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

266: --
267: l_proc varchar2(72) := g_package||'update_validate';
268: --
269: Begin
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: --
272: -- Call all supporting business operations
273: --
274: chk_shared_type_id

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

290: p_business_group_id => p_rec.business_group_id);
291: --
292: -- hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
293: --
294: hr_utility.set_location(' Leaving:'||l_proc, 10);
295: End update_validate;
296: --
297: -- ----------------------------------------------------------------------------
298: -- |---------------------------< delete_validate >----------------------------|

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

302: --
303: l_proc varchar2(72) := g_package||'delete_validate';
304: --
305: Begin
306: hr_utility.set_location('Entering:'||l_proc, 5);
307: --
308: -- Call all supporting business operations
309: --
310: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

306: hr_utility.set_location('Entering:'||l_proc, 5);
307: --
308: -- Call all supporting business operations
309: --
310: hr_utility.set_location(' Leaving:'||l_proc, 10);
311: End delete_validate;
312: --
313: --
314: -- ---------------------------------------------------------------------------

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

333: l_proc varchar2(72) := g_package||'return_legislation_code';
334: --
335: begin
336: --
337: hr_utility.set_location('Entering:'|| l_proc, 10);
338: --
339: -- Ensure that all the mandatory parameter are not null
340: --
341: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 355: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

351: close csr_leg_code;
352: --
353: -- The primary key is invalid therefore we must error
354: --
355: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
356: hr_utility.raise_error;
357: --
358: end if;
359: --

Line 356: hr_utility.raise_error;

352: --
353: -- The primary key is invalid therefore we must error
354: --
355: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
356: hr_utility.raise_error;
357: --
358: end if;
359: --
360: close csr_leg_code;

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

358: end if;
359: --
360: close csr_leg_code;
361: --
362: hr_utility.set_location(' Leaving:'|| l_proc, 20);
363: --
364: return l_legislation_code;
365: --
366: end return_legislation_code;