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_HAT_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_hat_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 41: g_debug:=hr_utility.debug_enabled;

37: l_proc varchar2(72);
38: --
39: begin
40: --
41: g_debug:=hr_utility.debug_enabled;
42: if g_debug then
43: l_proc := g_package||'set_security_group_id';
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: end if;

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

40: --
41: g_debug:=hr_utility.debug_enabled;
42: if g_debug then
43: l_proc := g_package||'set_security_group_id';
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: end if;
46: --
47: -- Ensure that all the mandatory parameter are not null
48: --

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

77: );
78: end if;
79: --
80: if g_debug then
81: hr_utility.set_location(' Leaving:'|| l_proc, 20);
82: end if;
83: --
84: end set_security_group_id;
85: --

Line 110: g_debug:=hr_utility.debug_enabled;

106: l_proc varchar2(72);
107: --
108: Begin
109: --
110: g_debug:=hr_utility.debug_enabled;
111: if g_debug then
112: l_proc := g_package||'return_legislation_code';
113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: end if;

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

109: --
110: g_debug:=hr_utility.debug_enabled;
111: if g_debug then
112: l_proc := g_package||'return_legislation_code';
113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: end if;
115: --
116: -- Ensure that all the mandatory parameter are not null
117: --

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

129: -- variable.
130: --
131: l_legislation_code := hxc_hat_bus.g_legislation_code;
132: if g_debug then
133: hr_utility.set_location(l_proc, 20);
134: end if;
135: else
136: --
137: -- The ID is different to the last call to this function

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

148: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: end if;
151: if g_debug then
152: hr_utility.set_location(l_proc,30);
153: end if;
154: --
155: -- Set the global variables so the values are
156: -- available for the next call to this function.

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

159: hxc_hat_bus.g_alias_type_id := p_alias_type_id;
160: hxc_hat_bus.g_legislation_code := l_legislation_code;
161: end if;
162: if g_debug then
163: hr_utility.set_location(' Leaving:'|| l_proc, 40);
164: end if;
165: return l_legislation_code;
166: end return_legislation_code;
167: --

Line 240: hr_utility.trace('Entering chk_name');

236:
237: Begin
238:
239: if g_debug then
240: hr_utility.trace('Entering chk_name');
241: end if;
242:
243: --
244: -- Raise an error if the alias type and reference object are already defined.

Line 253: hr_utility.set_message(809,'HXC_ALT_EXISTS'); -- 'Alias Type already exists');

249: --
250: IF l_error IS NOT NULL
251: THEN
252: --
253: hr_utility.set_message(809,'HXC_ALT_EXISTS'); -- 'Alias Type already exists');
254: hr_utility.raise_error;
255: --
256: END IF;
257: if g_debug then

Line 254: hr_utility.raise_error;

250: IF l_error IS NOT NULL
251: THEN
252: --
253: hr_utility.set_message(809,'HXC_ALT_EXISTS'); -- 'Alias Type already exists');
254: hr_utility.raise_error;
255: --
256: END IF;
257: if g_debug then
258: hr_utility.trace('Leaving chk_name');

Line 258: hr_utility.trace('Leaving chk_name');

254: hr_utility.raise_error;
255: --
256: END IF;
257: if g_debug then
258: hr_utility.trace('Leaving chk_name');
259: end if;
260:
261: end chk_name;
262: --

Line 281: g_debug:=hr_utility.debug_enabled;

277: );
278: l_error varchar2(5) := NULL;
279: begin
280:
281: g_debug:=hr_utility.debug_enabled;
282: if g_debug then
283: hr_utility.trace('Entering chk_fk_relation');
284: end if;
285: --

Line 283: hr_utility.trace('Entering chk_fk_relation');

279: begin
280:
281: g_debug:=hr_utility.debug_enabled;
282: if g_debug then
283: hr_utility.trace('Entering chk_fk_relation');
284: end if;
285: --
286: OPEN csr_chk_aldef;
287: FETCH csr_chk_aldef into l_error;

Line 291: hr_utility.trace('1st Validation'|| l_error);

287: FETCH csr_chk_aldef into l_error;
288: close csr_chk_aldef;
289:
290: if g_debug then
291: hr_utility.trace('1st Validation'|| l_error);
292: end if;
293:
294: IF l_error IS NOT NULL
295: THEN

Line 297: hr_utility.set_message(809,'HXC_ALT_CANT_DEL'); -- 'Alias type is used in altenate name definition');

293:
294: IF l_error IS NOT NULL
295: THEN
296: --
297: hr_utility.set_message(809,'HXC_ALT_CANT_DEL'); -- 'Alias type is used in altenate name definition');
298: hr_utility.trace('------77777');
299: hr_utility.raise_error;
300: --
301: END IF;

Line 298: hr_utility.trace('------77777');

294: IF l_error IS NOT NULL
295: THEN
296: --
297: hr_utility.set_message(809,'HXC_ALT_CANT_DEL'); -- 'Alias type is used in altenate name definition');
298: hr_utility.trace('------77777');
299: hr_utility.raise_error;
300: --
301: END IF;
302:

Line 299: hr_utility.raise_error;

295: THEN
296: --
297: hr_utility.set_message(809,'HXC_ALT_CANT_DEL'); -- 'Alias type is used in altenate name definition');
298: hr_utility.trace('------77777');
299: hr_utility.raise_error;
300: --
301: END IF;
302:
303: if g_debug then

Line 304: hr_utility.trace('Leaving chk_fk_relation');

300: --
301: END IF;
302:
303: if g_debug then
304: hr_utility.trace('Leaving chk_fk_relation');
305: end if;
306:
307: end chk_fk_relation;
308:

Line 319: g_debug:=hr_utility.debug_enabled;

315: --
316: l_proc varchar2(72);
317: --
318: Begin
319: g_debug:=hr_utility.debug_enabled;
320: if g_debug then
321: l_proc := g_package||'insert_validate';
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: end if;

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

318: Begin
319: g_debug:=hr_utility.debug_enabled;
320: if g_debug then
321: l_proc := g_package||'insert_validate';
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: end if;
324: --
325: -- Call all supporting business operations
326: --

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

331: chk_name ( p_type => p_rec.alias_type,
332: p_reference_object => p_rec.reference_object);
333: --
334: if g_debug then
335: hr_utility.set_location(' Leaving:'||l_proc, 10);
336: end if;
337: End insert_validate;
338: --
339: -- ----------------------------------------------------------------------------

Line 349: g_debug:=hr_utility.debug_enabled;

345: --
346: l_proc varchar2(72);
347: --
348: Begin
349: g_debug:=hr_utility.debug_enabled;
350: if g_debug then
351: l_proc := g_package||'update_validate';
352: hr_utility.set_location('Entering:'||l_proc, 5);
353: end if;

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

348: Begin
349: g_debug:=hr_utility.debug_enabled;
350: if g_debug then
351: l_proc := g_package||'update_validate';
352: hr_utility.set_location('Entering:'||l_proc, 5);
353: end if;
354: --
355: -- Call all supporting business operations
356: -- Validate Dependent Attributes

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

365: chk_name ( p_type => p_rec.alias_type,
366: p_reference_object =>p_rec.reference_object);
367: --
368: if g_debug then
369: hr_utility.set_location(' Leaving:'||l_proc, 10);
370: end if;
371: End update_validate;
372: --
373: -- ----------------------------------------------------------------------------

Line 383: g_debug:=hr_utility.debug_enabled;

379: --
380: l_proc varchar2(72);
381: --
382: Begin
383: g_debug:=hr_utility.debug_enabled;
384: if g_debug then
385: l_proc := g_package||'delete_validate';
386: hr_utility.set_location('Entering:'||l_proc, 5);
387: end if;

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

382: Begin
383: g_debug:=hr_utility.debug_enabled;
384: if g_debug then
385: l_proc := g_package||'delete_validate';
386: hr_utility.set_location('Entering:'||l_proc, 5);
387: end if;
388: --
389: -- Call all supporting business operations
390: --

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

391: -- Check if the alternate type definition is not used by alternate name
392: chk_fk_relation(p_rec.alias_type_id);
393:
394: if g_debug then
395: hr_utility.set_location(' Leaving:'||l_proc, 10);
396: end if;
397: End delete_validate;
398: --
399: end hxc_hat_bus;