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

Line 10: g_debug boolean := hr_utility.debug_enabled;

6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_lck_bus.'; -- Global package name
9:
10: g_debug boolean := hr_utility.debug_enabled;
11: --
12: -- The following two global variables are only to be
13: -- used by the return_legislation_code function.
14: --

Line 48: g_debug := hr_utility.debug_enabled;

44: l_proc varchar2(72);
45: l_legislation_code varchar2(150);
46: --
47: begin
48: g_debug := hr_utility.debug_enabled;
49:
50: --
51: if g_debug then
52: l_proc := g_package||'set_security_group_id';

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

49:
50: --
51: if g_debug then
52: l_proc := g_package||'set_security_group_id';
53: hr_utility.set_location('Entering:'|| l_proc, 10);
54: end if;
55: --
56: -- Ensure that all the mandatory parameter are not null
57: --

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

83:
84: end if;
85: --
86: if g_debug then
87: hr_utility.set_location(' Leaving:'|| l_proc, 20);
88: end if;
89: --
90: end set_security_group_id;
91: --

Line 122: g_debug := hr_utility.debug_enabled;

118: l_legislation_code varchar2(150);
119: l_proc varchar2(72) ;
120: --
121: Begin
122: g_debug := hr_utility.debug_enabled;
123:
124: --
125: if g_debug then
126: l_proc := g_package||'return_legislation_code';

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

123:
124: --
125: if g_debug then
126: l_proc := g_package||'return_legislation_code';
127: hr_utility.set_location('Entering:'|| l_proc, 10);
128: end if;
129: --
130: -- Ensure that all the mandatory parameter are not null
131: --

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

143: -- variable.
144: --
145: l_legislation_code := hxc_lck_bus.g_legislation_code;
146: if g_debug then
147: hr_utility.set_location(l_proc, 20);
148: end if;
149: else
150: --
151: -- The ID is different to the last call to this function

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

162: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
163: fnd_message.raise_error;
164: end if;
165: if g_debug then
166: hr_utility.set_location(l_proc,30);
167: end if;
168: --
169: -- Set the global variables so the values are
170: -- available for the next call to this function.

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

173: hxc_lck_bus.g_locker_type_id := p_locker_type_id;
174: hxc_lck_bus.g_legislation_code := l_legislation_code;
175: end if;
176: if g_debug then
177: hr_utility.set_location(' Leaving:'|| l_proc, 40);
178: end if;
179: return l_legislation_code;
180: end return_legislation_code;
181: --

Line 279: g_debug := hr_utility.debug_enabled;

275:
276: l_dup_name varchar2(5) := NULL;
277:
278: BEGIN
279: g_debug := hr_utility.debug_enabled;
280:
281: if g_debug then
282: l_proc := g_package||'chk_locker_process_type';
283: hr_utility.set_location('Entering:'||l_proc, 5);

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

279: g_debug := hr_utility.debug_enabled;
280:
281: if g_debug then
282: l_proc := g_package||'chk_locker_process_type';
283: hr_utility.set_location('Entering:'||l_proc, 5);
284: end if;
285:
286: -- check that the name has been entered
287:

Line 289: hr_utility.set_message(809, 'HXC_LOCKER_TYPE_REQUIRED');

285:
286: -- check that the name has been entered
287:
288: IF p_locker_type IS NULL THEN
289: hr_utility.set_message(809, 'HXC_LOCKER_TYPE_REQUIRED');
290: hr_utility.raise_error;
291: END IF;
292:
293: IF p_process_type IS NULL THEN

Line 290: hr_utility.raise_error;

286: -- check that the name has been entered
287:
288: IF p_locker_type IS NULL THEN
289: hr_utility.set_message(809, 'HXC_LOCKER_TYPE_REQUIRED');
290: hr_utility.raise_error;
291: END IF;
292:
293: IF p_process_type IS NULL THEN
294: hr_utility.set_message(809, 'HXC_PROCESS_TYPE_REQUIRED');

Line 294: hr_utility.set_message(809, 'HXC_PROCESS_TYPE_REQUIRED');

290: hr_utility.raise_error;
291: END IF;
292:
293: IF p_process_type IS NULL THEN
294: hr_utility.set_message(809, 'HXC_PROCESS_TYPE_REQUIRED');
295: hr_utility.raise_error;
296: END IF;
297:
298: if g_debug then

Line 295: hr_utility.raise_error;

291: END IF;
292:
293: IF p_process_type IS NULL THEN
294: hr_utility.set_message(809, 'HXC_PROCESS_TYPE_REQUIRED');
295: hr_utility.raise_error;
296: END IF;
297:
298: if g_debug then
299: hr_utility.set_location('Processing:'||l_proc, 10);

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

295: hr_utility.raise_error;
296: END IF;
297:
298: if g_debug then
299: hr_utility.set_location('Processing:'||l_proc, 10);
300: end if;
301:
302: -- check that the name is unique
303:

Line 309: hr_utility.set_message(809, 'HXC_LOCKER_PROCESS_TYPE_EXISTS');

305: FETCH csr_chk_name INTO l_dup_name;
306: CLOSE csr_chk_name;
307: --
308: IF l_dup_name IS NOT NULL THEN
309: hr_utility.set_message(809, 'HXC_LOCKER_PROCESS_TYPE_EXISTS');
310: hr_utility.raise_error;
311: END IF;
312:
313: if g_debug then

Line 310: hr_utility.raise_error;

306: CLOSE csr_chk_name;
307: --
308: IF l_dup_name IS NOT NULL THEN
309: hr_utility.set_message(809, 'HXC_LOCKER_PROCESS_TYPE_EXISTS');
310: hr_utility.raise_error;
311: END IF;
312:
313: if g_debug then
314: hr_utility.set_location('Leaving:'||l_proc, 20);

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

310: hr_utility.raise_error;
311: END IF;
312:
313: if g_debug then
314: hr_utility.set_location('Leaving:'||l_proc, 20);
315: end if;
316:
317: END chk_locker_process_type;
318: --

Line 365: g_debug := hr_utility.debug_enabled;

361: l_exists_id VARCHAR2(6) := NULL;
362: l_seed_exists_id VARCHAR2(6):=NULL;
363: --
364: BEGIN
365: g_debug := hr_utility.debug_enabled;
366:
367: if g_debug then
368: l_proc := g_package||'chk_delete';
369: hr_utility.set_location('Entering:'||l_proc, 5);

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

365: g_debug := hr_utility.debug_enabled;
366:
367: if g_debug then
368: l_proc := g_package||'chk_delete';
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: end if;
371: --
372: --check that locker_type_id is not being used
373: --

Line 376: hr_utility.set_location('Calling num_hierarchy_occurances: '||l_proc, 10);

372: --check that locker_type_id is not being used
373: --
374:
375: if g_debug then
376: hr_utility.set_location('Calling num_hierarchy_occurances: '||l_proc, 10);
377: end if;
378:
379: OPEN csr_chk_id_exists;
380: FETCH csr_chk_id_exists INTO l_exists_id;

Line 386: hr_utility.set_message(809, 'HXC_LOCKER_PROCESS_TYPE_USED');

382: --
383: IF l_exists_id IS NOT NULL
384: THEN
385: --
386: hr_utility.set_message(809, 'HXC_LOCKER_PROCESS_TYPE_USED');
387: hr_utility.raise_error;
388: --
389: END IF;
390:

Line 387: hr_utility.raise_error;

383: IF l_exists_id IS NOT NULL
384: THEN
385: --
386: hr_utility.set_message(809, 'HXC_LOCKER_PROCESS_TYPE_USED');
387: hr_utility.raise_error;
388: --
389: END IF;
390:
391: OPEN csr_chk_seed_id_exists;

Line 398: hr_utility.set_message(809, 'HXC_LOCKER_PROCESS_TYPE_USED');

394:
395: IF l_seed_exists_id IS NOT NULL
396: THEN
397: --
398: hr_utility.set_message(809, 'HXC_LOCKER_PROCESS_TYPE_USED');
399: hr_utility.raise_error;
400: --
401: END IF;
402: --

Line 399: hr_utility.raise_error;

395: IF l_seed_exists_id IS NOT NULL
396: THEN
397: --
398: hr_utility.set_message(809, 'HXC_LOCKER_PROCESS_TYPE_USED');
399: hr_utility.raise_error;
400: --
401: END IF;
402: --
403: if g_debug then

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

400: --
401: END IF;
402: --
403: if g_debug then
404: hr_utility.set_location('Entering:'||l_proc, 5);
405: end if;
406: --
407: END chk_delete;
408: --

Line 419: g_debug := hr_utility.debug_enabled;

415: --
416: l_proc varchar2(72);
417: --
418: Begin
419: g_debug := hr_utility.debug_enabled;
420:
421: if g_debug then
422: l_proc := g_package||'insert_validate';
423: hr_utility.set_location('Entering:'||l_proc, 5);

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

419: g_debug := hr_utility.debug_enabled;
420:
421: if g_debug then
422: l_proc := g_package||'insert_validate';
423: hr_utility.set_location('Entering:'||l_proc, 5);
424: end if;
425:
426: --call the business validations
427:

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

444: -- Validate Dependent Attributes
445: --
446: --
447: if g_debug then
448: hr_utility.set_location(' Leaving:'||l_proc, 10);
449: end if;
450: End insert_validate;
451: --
452: -- ----------------------------------------------------------------------------

Line 462: g_debug := hr_utility.debug_enabled;

458: --
459: l_proc varchar2(72);
460: --
461: Begin
462: g_debug := hr_utility.debug_enabled;
463:
464: if g_debug then
465: l_proc := g_package||'update_validate';
466: hr_utility.set_location('Entering:'||l_proc, 5);

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

462: g_debug := hr_utility.debug_enabled;
463:
464: if g_debug then
465: l_proc := g_package||'update_validate';
466: hr_utility.set_location('Entering:'||l_proc, 5);
467: end if;
468:
469: chk_locker_process_type
470: (p_locker_type => p_rec.locker_type

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

489: );
490: --
491: --
492: if g_debug then
493: hr_utility.set_location(' Leaving:'||l_proc, 10);
494: end if;
495: End update_validate;
496: --
497: -- ----------------------------------------------------------------------------

Line 507: g_debug := hr_utility.debug_enabled;

503: --
504: l_proc varchar2(72);
505: --
506: Begin
507: g_debug := hr_utility.debug_enabled;
508:
509: if g_debug then
510: l_proc := g_package||'delete_validate';
511: hr_utility.set_location('Entering:'||l_proc, 5);

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

507: g_debug := hr_utility.debug_enabled;
508:
509: if g_debug then
510: l_proc := g_package||'delete_validate';
511: hr_utility.set_location('Entering:'||l_proc, 5);
512: end if;
513: --
514: -- Call all supporting business operations
515: chk_delete

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

515: chk_delete
516: (p_locker_type_id => p_rec.locker_type_id);
517: --
518: if g_debug then
519: hr_utility.set_location(' Leaving:'||l_proc, 10);
520: end if;
521: End delete_validate;
522: --
523: end hxc_lck_bus;