DBA Data[Home] [Help]

APPS.HXC_LKR_BUS dependencies on HR_UTILITY

Line 10: g_debug boolean := hr_utility.debug_enabled;

6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_lkr_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 51: g_debug := hr_utility.debug_enabled;

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

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

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

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

94: --
95: end if;
96: --
97: if g_debug then
98: hr_utility.set_location(' Leaving:'|| l_proc, 20);
99: end if;
100: --
101: end set_security_group_id;
102: --

Line 135: g_debug := hr_utility.debug_enabled;

131: l_legislation_code varchar2(150);
132: l_proc varchar2(72);
133: --
134: Begin
135: g_debug := hr_utility.debug_enabled;
136:
137: --
138: if g_debug then
139: l_proc := g_package||'return_legislation_code';

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

136:
137: --
138: if g_debug then
139: l_proc := g_package||'return_legislation_code';
140: hr_utility.set_location('Entering:'|| l_proc, 10);
141: end if;
142: --
143: -- Ensure that all the mandatory parameter are not null
144: --

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

163: -- variable.
164: --
165: l_legislation_code := hxc_lkr_bus.g_legislation_code;
166: if g_debug then
167: hr_utility.set_location(l_proc, 20);
168: end if;
169: else
170: --
171: -- The ID is different to the last call to this function

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

182: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
183: fnd_message.raise_error;
184: end if;
185: if g_debug then
186: hr_utility.set_location(l_proc,30);
187: end if;
188: --
189: -- Set the global variables so the values are
190: -- available for the next call to this function.

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

194: hxc_lkr_bus.g_locker_type_requestor_id := p_locker_type_requestor_id;
195: hxc_lkr_bus.g_legislation_code := l_legislation_code;
196: end if;
197: if g_debug then
198: hr_utility.set_location(' Leaving:'|| l_proc, 40);
199: end if;
200: return l_legislation_code;
201: end return_legislation_code;
202: --

Line 299: g_debug := hr_utility.debug_enabled;

295:
296: l_dup_id varchar2(5) := NULL;
297:
298: BEGIN
299: g_debug := hr_utility.debug_enabled;
300:
301: if g_debug then
302: l_proc := g_package||'chk_locker_process_type';
303: hr_utility.set_location('Entering:'||l_proc, 5);

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

299: g_debug := hr_utility.debug_enabled;
300:
301: if g_debug then
302: l_proc := g_package||'chk_locker_process_type';
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: end if;
305:
306: -- check that the combination of ID has been entered
307:

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

305:
306: -- check that the combination of ID has been entered
307:
308: IF p_owner_id IS NULL THEN
309: hr_utility.set_message(809, 'HXC_OWNER_ID_REQUIRED');
310: hr_utility.raise_error;
311: END IF;
312:
313: IF p_requestor_id IS NULL THEN

Line 310: hr_utility.raise_error;

306: -- check that the combination of ID has been entered
307:
308: IF p_owner_id IS NULL THEN
309: hr_utility.set_message(809, 'HXC_OWNER_ID_REQUIRED');
310: hr_utility.raise_error;
311: END IF;
312:
313: IF p_requestor_id IS NULL THEN
314: hr_utility.set_message(809, 'HXC_REQUESTOR_ID_REQUIRED');

Line 314: hr_utility.set_message(809, 'HXC_REQUESTOR_ID_REQUIRED');

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

Line 315: hr_utility.raise_error;

311: END IF;
312:
313: IF p_requestor_id IS NULL THEN
314: hr_utility.set_message(809, 'HXC_REQUESTOR_ID_REQUIRED');
315: hr_utility.raise_error;
316: END IF;
317:
318: if g_debug then
319: hr_utility.set_location('Processing:'||l_proc, 10);

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

315: hr_utility.raise_error;
316: END IF;
317:
318: if g_debug then
319: hr_utility.set_location('Processing:'||l_proc, 10);
320: end if;
321:
322: -- check that the name is unique
323:

Line 329: hr_utility.set_message(809, 'HXC_OWNER_REQUESTOR_EXISTS');

325: FETCH csr_chk_id INTO l_dup_id;
326: CLOSE csr_chk_id;
327: --
328: IF l_dup_id IS NOT NULL THEN
329: hr_utility.set_message(809, 'HXC_OWNER_REQUESTOR_EXISTS');
330: hr_utility.raise_error;
331: END IF;
332:
333: if g_debug then

Line 330: hr_utility.raise_error;

326: CLOSE csr_chk_id;
327: --
328: IF l_dup_id IS NOT NULL THEN
329: hr_utility.set_message(809, 'HXC_OWNER_REQUESTOR_EXISTS');
330: hr_utility.raise_error;
331: END IF;
332:
333: if g_debug then
334: hr_utility.set_location('Leaving:'||l_proc, 20);

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

330: hr_utility.raise_error;
331: END IF;
332:
333: if g_debug then
334: hr_utility.set_location('Leaving:'||l_proc, 20);
335: end if;
336:
337: END chk_owner_requestor_id;
338: --

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:
351: if g_debug then
352: l_proc := g_package||'insert_validate';
353: hr_utility.set_location('Entering:'||l_proc, 5);

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

349: g_debug := hr_utility.debug_enabled;
350:
351: if g_debug then
352: l_proc := g_package||'insert_validate';
353: hr_utility.set_location('Entering:'||l_proc, 5);
354: end if;
355:
356: chk_owner_requestor_id
357: (p_owner_id =>p_rec.locker_type_owner_id

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

372: -- Validate Dependent Attributes
373: --
374: --
375: if g_debug then
376: hr_utility.set_location(' Leaving:'||l_proc, 10);
377: end if;
378: End insert_validate;
379: --
380: -- ----------------------------------------------------------------------------

Line 390: g_debug := hr_utility.debug_enabled;

386: --
387: l_proc varchar2(72);
388: --
389: Begin
390: g_debug := hr_utility.debug_enabled;
391:
392: if g_debug then
393: l_proc := g_package||'update_validate';
394: hr_utility.set_location('Entering:'||l_proc, 5);

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

390: g_debug := hr_utility.debug_enabled;
391:
392: if g_debug then
393: l_proc := g_package||'update_validate';
394: hr_utility.set_location('Entering:'||l_proc, 5);
395: end if;
396:
397: --
398: -- Call all supporting business operations

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

412: );
413: --
414: --
415: if g_debug then
416: hr_utility.set_location(' Leaving:'||l_proc, 10);
417: end if;
418: End update_validate;
419: --
420: -- ----------------------------------------------------------------------------

Line 430: g_debug := hr_utility.debug_enabled;

426: --
427: l_proc varchar2(72);
428: --
429: Begin
430: g_debug := hr_utility.debug_enabled;
431:
432: if g_debug then
433: l_proc := g_package||'delete_validate';
434: hr_utility.set_location('Entering:'||l_proc, 5);

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

430: g_debug := hr_utility.debug_enabled;
431:
432: if g_debug then
433: l_proc := g_package||'delete_validate';
434: hr_utility.set_location('Entering:'||l_proc, 5);
435: end if;
436: null;
437: --
438: -- Call all supporting business operations

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

437: --
438: -- Call all supporting business operations
439: --
440: if g_debug then
441: hr_utility.set_location(' Leaving:'||l_proc, 10);
442: end if;
443: End delete_validate;
444: --
445: end hxc_lkr_bus;