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

Line 9: g_debug boolean := hr_utility.debug_enabled;

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

Line 47: g_debug:=hr_utility.debug_enabled;

43: l_proc varchar2(72);
44: --
45: begin
46: --
47: g_debug:=hr_utility.debug_enabled;
48: if g_debug then
49: l_proc:= g_package||'set_security_group_id';
50: hr_utility.set_location('Entering:'|| l_proc, 10);
51: end if;

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

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

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

79: (p_security_group_id => l_security_group_id
80: );
81: --
82: if g_debug then
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: end if;
85: --
86: end set_security_group_id;
87: --

Line 119: g_debug:=hr_utility.debug_enabled;

115: l_proc varchar2(72);
116: --
117: Begin
118: --
119: g_debug:=hr_utility.debug_enabled;
120: if g_debug then
121: l_proc := g_package||'return_legislation_code';
122: hr_utility.set_location('Entering:'|| l_proc, 10);
123: end if;

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

118: --
119: g_debug:=hr_utility.debug_enabled;
120: if g_debug then
121: l_proc := g_package||'return_legislation_code';
122: hr_utility.set_location('Entering:'|| l_proc, 10);
123: end if;
124: --
125: -- Ensure that all the mandatory parameter are not null
126: --

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

138: -- variable.
139: --
140: l_legislation_code := hxc_aps_bus.g_legislation_code;
141: if g_debug then
142: hr_utility.set_location(l_proc, 20);
143: end if;
144: else
145: --
146: -- The ID is different to the last call to this function

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

157: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
158: fnd_message.raise_error;
159: end if;
160: if g_debug then
161: hr_utility.set_location(l_proc,30);
162: end if;
163: --
164: -- Set the global variables so the values are
165: -- available for the next call to this function.

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

168: hxc_aps_bus.g_approval_period_set_id := p_approval_period_set_id;
169: hxc_aps_bus.g_legislation_code := l_legislation_code;
170: end if;
171: if g_debug then
172: hr_utility.set_location(' Leaving:'|| l_proc, 40);
173: end if;
174: return l_legislation_code;
175: end return_legislation_code;
176: --

Line 285: g_debug:=hr_utility.debug_enabled;

281: --
282: l_error varchar2(5) := NULL;
283: --
284: BEGIN
285: g_debug:=hr_utility.debug_enabled;
286: if g_debug then
287: l_proc:= g_package||'chk_name';
288: hr_utility.set_location('Entering:'||l_proc, 5);
289: end if;

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

284: BEGIN
285: g_debug:=hr_utility.debug_enabled;
286: if g_debug then
287: l_proc:= g_package||'chk_name';
288: hr_utility.set_location('Entering:'||l_proc, 5);
289: end if;
290: --
291: -- Raise error if name is NULL as it is a mandatory field.
292: --

Line 296: hr_utility.set_message(809, 'HXC_0053_APS_APR_PRD_NAME_MAND');

292: --
293: IF p_name IS NULL
294: THEN
295: --
296: hr_utility.set_message(809, 'HXC_0053_APS_APR_PRD_NAME_MAND');
297: hr_utility.raise_error;
298: --
299: END IF;
300: if g_debug then

Line 297: hr_utility.raise_error;

293: IF p_name IS NULL
294: THEN
295: --
296: hr_utility.set_message(809, 'HXC_0053_APS_APR_PRD_NAME_MAND');
297: hr_utility.raise_error;
298: --
299: END IF;
300: if g_debug then
301: hr_utility.set_location('Processing:'||l_proc, 10);

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

297: hr_utility.raise_error;
298: --
299: END IF;
300: if g_debug then
301: hr_utility.set_location('Processing:'||l_proc, 10);
302: end if;
303: --
304: -- Raise an error if the approval set name is not unique
305: --

Line 313: hr_utility.set_message(809, 'HXC_0091_APS_DUP_APR_PRD');

309: --
310: IF l_error IS NOT NULL
311: THEN
312: --
313: hr_utility.set_message(809, 'HXC_0091_APS_DUP_APR_PRD');
314: hr_utility.raise_error;
315: --
316: END IF;
317: --

Line 314: hr_utility.raise_error;

310: IF l_error IS NOT NULL
311: THEN
312: --
313: hr_utility.set_message(809, 'HXC_0091_APS_DUP_APR_PRD');
314: hr_utility.raise_error;
315: --
316: END IF;
317: --
318: if g_debug then

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

315: --
316: END IF;
317: --
318: if g_debug then
319: hr_utility.set_location('Leaving:'||l_proc, 20);
320: end if;
321: --
322: END chk_name;
323: -- ----------------------------------------------------------------------------

Line 355: g_debug:=hr_utility.debug_enabled;

351: --
352: l_exists VARCHAR2(6) := NULL;
353: --
354: BEGIN
355: g_debug:=hr_utility.debug_enabled;
356: if g_debug then
357: l_proc:= g_package||'chk_delete';
358: hr_utility.set_location('Entering:'||l_proc, 5);
359: end if;

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

354: BEGIN
355: g_debug:=hr_utility.debug_enabled;
356: if g_debug then
357: l_proc:= g_package||'chk_delete';
358: hr_utility.set_location('Entering:'||l_proc, 5);
359: end if;
360: --
361: --check that Approval Period is not being used
362: --

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

361: --check that Approval Period is not being used
362: --
363:
364: if g_debug then
365: hr_utility.set_location('Calling num_hierarchy_occurances: '||l_proc, 10);
366: end if;
367: l_exists := HXC_PREFERENCE_EVALUATION.num_hierarchy_occurances
368: ('TS_PER_APPROVAL_PERIODS'
369: ,1

Line 372: hr_utility.set_location('After calling num_hierarchy_occurances:'||l_proc,20);

368: ('TS_PER_APPROVAL_PERIODS'
369: ,1
370: ,TO_CHAR(p_approval_period_set_id));
371: if g_debug then
372: hr_utility.set_location('After calling num_hierarchy_occurances:'||l_proc,20);
373: end if;
374: --
375: IF l_exists <> 0 THEN
376: --

Line 377: hr_utility.set_message(809, 'HXC_HEG_APS_IN_USE');

373: end if;
374: --
375: IF l_exists <> 0 THEN
376: --
377: hr_utility.set_message(809, 'HXC_HEG_APS_IN_USE');
378: hr_utility.raise_error;
379: --
380: END IF;
381: --

Line 378: hr_utility.raise_error;

374: --
375: IF l_exists <> 0 THEN
376: --
377: hr_utility.set_message(809, 'HXC_HEG_APS_IN_USE');
378: hr_utility.raise_error;
379: --
380: END IF;
381: --
382: if g_debug then

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

379: --
380: END IF;
381: --
382: if g_debug then
383: hr_utility.set_location('Entering:'||l_proc, 5);
384: end if;
385: --
386: END chk_delete;
387:

Line 398: g_debug:=hr_utility.debug_enabled;

394: --
395: l_proc varchar2(72);
396: --
397: Begin
398: g_debug:=hr_utility.debug_enabled;
399: if g_debug then
400: l_proc:= g_package||'insert_validate';
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: end if;

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

397: Begin
398: g_debug:=hr_utility.debug_enabled;
399: if g_debug then
400: l_proc:= g_package||'insert_validate';
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: end if;
403: --
404: -- Call all supporting business operations
405: --

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

403: --
404: -- Call all supporting business operations
405: --
406: if g_debug then
407: hr_utility.set_location('Processing:'||l_proc, 10);
408: end if;
409: --
410: chk_name ( p_name => p_rec.name,
411: p_object_version_number => p_rec.object_version_number );

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

410: chk_name ( p_name => p_rec.name,
411: p_object_version_number => p_rec.object_version_number );
412: --
413: if g_debug then
414: hr_utility.set_location(' Leaving:'||l_proc, 10);
415: end if;
416: --
417: -- EDIT_HERE: As this table does not have a mandatory business_group_id
418: -- column, ensure client_info is populated by calling a suitable

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

422: -- "-- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS."
423: --
424: --
425: if g_debug then
426: hr_utility.set_location(' Leaving:'||l_proc, 10);
427: end if;
428: End insert_validate;
429: --
430: -- ----------------------------------------------------------------------------

Line 440: g_debug:=hr_utility.debug_enabled;

436: --
437: l_proc varchar2(72);
438: --
439: Begin
440: g_debug:=hr_utility.debug_enabled;
441: if g_debug then
442: l_proc:= g_package||'update_validate';
443: hr_utility.set_location('Entering:'||l_proc, 5);
444: end if;

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

439: Begin
440: g_debug:=hr_utility.debug_enabled;
441: if g_debug then
442: l_proc:= g_package||'update_validate';
443: hr_utility.set_location('Entering:'||l_proc, 5);
444: end if;
445: --
446: -- Call all supporting business operations
447: --

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

445: --
446: -- Call all supporting business operations
447: --
448: if g_debug then
449: hr_utility.set_location('Processing:'||l_proc, 10);
450: end if;
451: --
452: chk_name ( p_name => p_rec.name,
453: p_object_version_number => p_rec.object_version_number );

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

452: chk_name ( p_name => p_rec.name,
453: p_object_version_number => p_rec.object_version_number );
454: --
455: if g_debug then
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: end if;
458: --
459: -- EDIT_HERE: As this table does not have a mandatory business_group_id
460: -- column, ensure client_info is populated by calling a suitable

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

468: );
469: --
470: --
471: if g_debug then
472: hr_utility.set_location(' Leaving:'||l_proc, 10);
473: end if;
474: End update_validate;
475: --
476: -- ----------------------------------------------------------------------------

Line 486: g_debug:=hr_utility.debug_enabled;

482: --
483: l_proc varchar2(72);
484: --
485: Begin
486: g_debug:=hr_utility.debug_enabled;
487: if g_debug then
488: l_proc:= g_package||'delete_validate';
489: hr_utility.set_location('Entering:'||l_proc, 5);
490: end if;

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

485: Begin
486: g_debug:=hr_utility.debug_enabled;
487: if g_debug then
488: l_proc:= g_package||'delete_validate';
489: hr_utility.set_location('Entering:'||l_proc, 5);
490: end if;
491: --
492: -- Call all supporting business operations
493: --

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

494: chk_delete
495: ( p_approval_period_set_id => p_rec.approval_period_set_id);
496: --
497: if g_debug then
498: hr_utility.set_location(' Leaving:'||l_proc, 10);
499: end if;
500: End delete_validate;
501: --
502: end hxc_aps_bus;