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

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

42: l_proc varchar2(72) := g_package||'set_security_group_id';
43: --
44: begin
45: --
46: hr_utility.set_location('Entering:'|| l_proc, 10);
47: --
48: -- Ensure that all the mandatory parameter are not null
49: --
50: hr_api.mandatory_arg_error

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

73: -- hr_api.set_security_group_id
74: -- (p_security_group_id => l_security_group_id
75: -- );
76: --
77: hr_utility.set_location(' Leaving:'|| l_proc, 20);
78: --
79: end set_security_group_id;
80: --
81: -- ---------------------------------------------------------------------------

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

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

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

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := per_cai_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

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

143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

Line 156: hr_utility.set_location(' Leaving:'|| l_proc, 40);

152: close csr_leg_code;
153: per_cai_bus.g_cagr_api_id := p_cagr_api_id;
154: per_cai_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ---------------------------------------------------------------------------

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

202: AND per.api_name = p_api_name;
203: --
204: BEGIN
205: --
206: hr_utility.set_location('Entering:'||l_proc, 10);
207: --
208: -- Check mandatory api_name is set
209: --
210: IF p_api_name IS NULL THEN

Line 212: hr_utility.set_message(800, 'HR_289209_API_NAME_NULL');

208: -- Check mandatory api_name is set
209: --
210: IF p_api_name IS NULL THEN
211: --
212: hr_utility.set_message(800, 'HR_289209_API_NAME_NULL');
213: hr_utility.raise_error;
214: --
215: END IF;
216: --

Line 213: hr_utility.raise_error;

209: --
210: IF p_api_name IS NULL THEN
211: --
212: hr_utility.set_message(800, 'HR_289209_API_NAME_NULL');
213: hr_utility.raise_error;
214: --
215: END IF;
216: --
217: hr_utility.set_location(l_proc, 20);

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

213: hr_utility.raise_error;
214: --
215: END IF;
216: --
217: hr_utility.set_location(l_proc, 20);
218: --
219: -- Only proceed with validation if :
220: -- a) on insert (cagr_api_id is a non-updateable param)
221: --

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

226: IF ( (p_cagr_api_id IS NULL) OR
227: ((p_cagr_api_id IS NOT NULL) AND
228: (per_cai_shd.g_old_rec.api_name <> p_api_name))) THEN
229: --
230: hr_utility.set_location(l_proc, 30);
231: --
232: -- Check that the person_id is in the per_people_f view on the effective_date.
233: --
234: OPEN csr_api_name;

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

235: FETCH csr_api_name INTO l_dummy;
236: --
237: IF csr_api_name%FOUND THEN
238: --
239: hr_utility.set_location(l_proc, 40);
240: --
241: CLOSE csr_api_name;
242: --
243: hr_utility.set_message(800,'HR_289210_API_NAME_INVALID');

Line 243: hr_utility.set_message(800,'HR_289210_API_NAME_INVALID');

239: hr_utility.set_location(l_proc, 40);
240: --
241: CLOSE csr_api_name;
242: --
243: hr_utility.set_message(800,'HR_289210_API_NAME_INVALID');
244: hr_utility.raise_error;
245: --
246: ELSE
247: --

Line 244: hr_utility.raise_error;

240: --
241: CLOSE csr_api_name;
242: --
243: hr_utility.set_message(800,'HR_289210_API_NAME_INVALID');
244: hr_utility.raise_error;
245: --
246: ELSE
247: --
248: hr_utility.set_location(l_proc, 50);

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

244: hr_utility.raise_error;
245: --
246: ELSE
247: --
248: hr_utility.set_location(l_proc, 50);
249: --
250: CLOSE csr_api_name;
251: --
252: END IF;

Line 256: hr_utility.set_location(' Leaving:'||l_proc, 100);

252: END IF;
253: --
254: END IF;
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 100);
257: --
258: END chk_api_name;
259: --
260: -- ---------------------------------------------------------------------------

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

295: l_proc VARCHAR2(72) := g_package||'chk_category_name';
296: --
297: BEGIN
298: --
299: hr_utility.set_location('Entering :'||l_proc,10);
300: --
301: IF p_category_name IS NULL THEN
302: --
303: hr_utility.set_message(800, 'HR_289211_CATEGORY_NAME_NULL');

Line 303: hr_utility.set_message(800, 'HR_289211_CATEGORY_NAME_NULL');

299: hr_utility.set_location('Entering :'||l_proc,10);
300: --
301: IF p_category_name IS NULL THEN
302: --
303: hr_utility.set_message(800, 'HR_289211_CATEGORY_NAME_NULL');
304: hr_utility.raise_error;
305: --
306: END IF;
307: --

Line 304: hr_utility.raise_error;

300: --
301: IF p_category_name IS NULL THEN
302: --
303: hr_utility.set_message(800, 'HR_289211_CATEGORY_NAME_NULL');
304: hr_utility.raise_error;
305: --
306: END IF;
307: --
308: hr_utility.set_location(l_proc,20);

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

304: hr_utility.raise_error;
305: --
306: END IF;
307: --
308: hr_utility.set_location(l_proc,20);
309: --
310: -- Only proceed with validation if :
311: -- a) Inserting or
312: -- b) The value for consultation type has changed

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

321: (p_effective_date => p_effective_date
322: ,p_lookup_type => 'CAGR_CATEGORIES'
323: ,p_lookup_code => p_category_name) THEN
324: --
325: hr_utility.set_location(l_proc, 30);
326: --
327: hr_utility.set_message(800, 'HR_289212_CATEGORY_INVALID');
328: hr_utility.raise_error;
329: --

Line 327: hr_utility.set_message(800, 'HR_289212_CATEGORY_INVALID');

323: ,p_lookup_code => p_category_name) THEN
324: --
325: hr_utility.set_location(l_proc, 30);
326: --
327: hr_utility.set_message(800, 'HR_289212_CATEGORY_INVALID');
328: hr_utility.raise_error;
329: --
330: END IF;
331: --

Line 328: hr_utility.raise_error;

324: --
325: hr_utility.set_location(l_proc, 30);
326: --
327: hr_utility.set_message(800, 'HR_289212_CATEGORY_INVALID');
328: hr_utility.raise_error;
329: --
330: END IF;
331: --
332: END IF;

Line 334: hr_utility.set_location('Leaving :'||l_proc,100);

330: END IF;
331: --
332: END IF;
333: --
334: hr_utility.set_location('Leaving :'||l_proc,100);
335: --
336: END chk_category_name;
337: --
338: -- ---------------------------------------------------------------------------

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

377: WHERE cei.cagr_api_id = p_cagr_api_id;
378: --
379: BEGIN
380: --
381: hr_utility.set_location('Entering : '||l_proc,10);
382: --
383: OPEN csr_get_entitlement_item;
384: FETCH csr_get_entitlement_item INTO l_dummy;
385: --

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

384: FETCH csr_get_entitlement_item INTO l_dummy;
385: --
386: IF csr_get_entitlement_item%FOUND THEN
387: --
388: hr_utility.set_location(l_proc,20);
389: --
390: CLOSE csr_get_entitlement_item;
391: --
392: hr_utility.set_message(800, 'HR_289213_API_IN_USE');

Line 392: hr_utility.set_message(800, 'HR_289213_API_IN_USE');

388: hr_utility.set_location(l_proc,20);
389: --
390: CLOSE csr_get_entitlement_item;
391: --
392: hr_utility.set_message(800, 'HR_289213_API_IN_USE');
393: hr_utility.raise_error;
394: --
395: ELSE
396: --

Line 393: hr_utility.raise_error;

389: --
390: CLOSE csr_get_entitlement_item;
391: --
392: hr_utility.set_message(800, 'HR_289213_API_IN_USE');
393: hr_utility.raise_error;
394: --
395: ELSE
396: --
397: hr_utility.set_location(l_proc,30);

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

393: hr_utility.raise_error;
394: --
395: ELSE
396: --
397: hr_utility.set_location(l_proc,30);
398: --
399: CLOSE csr_get_entitlement_item;
400: --
401: END IF;

Line 403: hr_utility.set_location('Leaving : '||l_proc,100);

399: CLOSE csr_get_entitlement_item;
400: --
401: END IF;
402: --
403: hr_utility.set_location('Leaving : '||l_proc,100);
404: --
405: END chk_api_use;
406: --
407: -- ----------------------------------------------------------------------------

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

491: l_proc varchar2(72) := g_package||'insert_validate';
492: --
493: Begin
494: --
495: hr_utility.set_location('Entering:'||l_proc, 10);
496: --
497: -- Call all supporting business operations
498: --
499: -- Check category name

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

502: (p_cagr_api_id => p_rec.cagr_api_id
503: ,p_category_name => p_rec.category_name
504: ,p_effective_date => p_effective_date);
505: --
506: hr_utility.set_location(l_proc, 20);
507: --
508: -- Check api name
509: --
510: per_cai_bus.chk_api_name

Line 514: hr_utility.set_location(' Leaving:'||l_proc, 100);

510: per_cai_bus.chk_api_name
511: (p_cagr_api_id => p_rec.cagr_api_id
512: ,p_api_name => p_rec.api_name);
513: --
514: hr_utility.set_location(' Leaving:'||l_proc, 100);
515: --
516: End insert_validate;
517: --
518: -- ----------------------------------------------------------------------------

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

525: --
526: l_proc varchar2(72) := g_package||'update_validate';
527: --
528: Begin
529: hr_utility.set_location('Entering:'||l_proc, 10);
530: --
531: -- Call all supporting business operations
532: --
533: chk_non_updateable_args

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

534: (p_effective_date => p_effective_date
535: ,p_rec => p_rec
536: );
537: --
538: hr_utility.set_location(l_proc,20);
539: --
540: -- Check category name
541: --
542: per_cai_bus.chk_category_name

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

543: (p_cagr_api_id => p_rec.cagr_api_id
544: ,p_category_name => p_rec.category_name
545: ,p_effective_date => p_effective_date);
546: --
547: hr_utility.set_location(l_proc, 20);
548: --
549: -- Check api name
550: --
551: per_cai_bus.chk_api_name

Line 555: hr_utility.set_location(' Leaving:'||l_proc, 100);

551: per_cai_bus.chk_api_name
552: (p_cagr_api_id => p_rec.cagr_api_id
553: ,p_api_name => p_rec.api_name);
554: --
555: hr_utility.set_location(' Leaving:'||l_proc, 100);
556: --
557: End update_validate;
558: --
559: -- ----------------------------------------------------------------------------

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

566: l_proc varchar2(72) := g_package||'delete_validate';
567: --
568: Begin
569: --
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: -- Check the API is not being referenced
573: --
574: per_cai_bus.chk_api_use

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

574: per_cai_bus.chk_api_use
575: (p_cagr_api_id => p_rec.cagr_api_id);
576: --
577: --
578: hr_utility.set_location(' Leaving:'||l_proc, 10);
579: End delete_validate;
580: --
581: end per_cai_bus;