DBA Data[Home] [Help]

APPS.HXC_HSD_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_hsd_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 54: g_debug:=hr_utility.debug_enabled;

50: l_legislation_code varchar2(150);
51: --
52: begin
53: --
54: g_debug:=hr_utility.debug_enabled;
55: if g_debug then
56: l_proc := g_package||'set_security_group_id';
57: hr_utility.set_location('Entering:'|| l_proc, 10);
58: end if;

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

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

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

102: hr_api.set_legislation_context(l_legislation_code);
103: end if;
104: --
105: if g_debug then
106: hr_utility.set_location(' Leaving:'|| l_proc, 20);
107: end if;
108: --
109: end set_security_group_id;
110: --

Line 144: g_debug:=hr_utility.debug_enabled;

140: l_proc varchar2(72);
141: --
142: Begin
143: --
144: g_debug:=hr_utility.debug_enabled;
145: if g_debug then
146: l_proc := g_package||'return_legislation_code';
147: hr_utility.set_location('Entering:'|| l_proc, 10);
148: end if;

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

143: --
144: g_debug:=hr_utility.debug_enabled;
145: if g_debug then
146: l_proc := g_package||'return_legislation_code';
147: hr_utility.set_location('Entering:'|| l_proc, 10);
148: end if;
149: --
150: -- Ensure that all the mandatory parameter are not null
151: --

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

170: -- variable.
171: --
172: l_legislation_code := hxc_hsd_bus.g_legislation_code;
173: if g_debug then
174: hr_utility.set_location(l_proc, 20);
175: end if;
176: else
177: --
178: -- The ID is different to the last call to this function

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

189: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
190: fnd_message.raise_error;
191: end if;
192: if g_debug then
193: hr_utility.set_location(l_proc,30);
194: end if;
195: --
196: -- Set the global variables so the values are
197: -- available for the next call to this function.

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

201: hxc_hsd_bus.g_object_type := p_object_type;
202: hxc_hsd_bus.g_legislation_code := l_legislation_code;
203: end if;
204: if g_debug then
205: hr_utility.set_location(' Leaving:'|| l_proc, 40);
206: end if;
207: return l_legislation_code;
208: end return_legislation_code;
209: --

Line 307: hr_utility.set_message

303: l_proc varchar2(72) := g_package||'chk_hxc_required';
304: Begin
305:
306: if p_hxc_required is null then
307: hr_utility.set_message
308: (809
309: ,'HXC_HSD_INV_REQ_LEVEL'
310: );
311: hr_utility.raise_error;

Line 311: hr_utility.raise_error;

307: hr_utility.set_message
308: (809
309: ,'HXC_HSD_INV_REQ_LEVEL'
310: );
311: hr_utility.raise_error;
312: end if;
313:
314: Open c_chk_required;
315: Fetch c_chk_required into l_dummy;

Line 320: hr_utility.set_message

316:
317: if (c_chk_required%NOTFOUND) then
318: Close c_chk_required;
319:
320: hr_utility.set_message
321: (809
322: ,'HXC_HSD_INV_REQ_LEVEL'
323: );
324: hr_utility.raise_error;

Line 324: hr_utility.raise_error;

320: hr_utility.set_message
321: (809
322: ,'HXC_HSD_INV_REQ_LEVEL'
323: );
324: hr_utility.raise_error;
325:
326: end if;
327: Close c_chk_required;
328:

Line 371: hr_utility.set_message

367: l_proc varchar2(72) := g_package||'chk_application_id';
368: Begin
369:
370: if p_owner_application_id is null then
371: hr_utility.set_message
372: (809
373: ,'HXC_HSD_INV_APPL'
374: );
375: hr_utility.raise_error;

Line 375: hr_utility.raise_error;

371: hr_utility.set_message
372: (809
373: ,'HXC_HSD_INV_APPL'
374: );
375: hr_utility.raise_error;
376: end if;
377:
378: Open c_chk_application;
379: Fetch c_chk_application into l_dummy;

Line 384: hr_utility.set_message

380: if (c_chk_application%NOTFOUND) then
381:
382: Close c_chk_application;
383:
384: hr_utility.set_message
385: (809
386: ,'HXC_HSD_INV_APPL'
387: );
388: hr_utility.raise_error;

Line 388: hr_utility.raise_error;

384: hr_utility.set_message
385: (809
386: ,'HXC_HSD_INV_APPL'
387: );
388: hr_utility.raise_error;
389:
390: end if;
391: Close c_chk_application;
392:

Line 458: hr_utility.set_message

454:
455: --based on the object type, we shall get the query
456: l_query := hxc_seeddata_pkg.get_query(p_object_type);
457: if (l_query is null) then
458: hr_utility.set_message
459: (809
460: ,'HXC_HSD_INV_OBJ_TYP'
461: );
462: hr_utility.raise_error;

Line 462: hr_utility.raise_error;

458: hr_utility.set_message
459: (809
460: ,'HXC_HSD_INV_OBJ_TYP'
461: );
462: hr_utility.raise_error;
463: end if;
464:
465: l_query := 'select 1 from ('||l_query||') where ID = :p_object_id';
466:

Line 471: hr_utility.set_message

467: OPEN c_get_value FOR l_query USING p_object_id;
468: FETCH c_get_value INTO l_dummy;
469: IF (c_get_value%NOTFOUND) then
470: CLOSE c_get_value;
471: hr_utility.set_message
472: (809
473: ,'HXC_HSD_INV_OBJ_ID'
474: );
475: hr_utility.raise_error;

Line 475: hr_utility.raise_error;

471: hr_utility.set_message
472: (809
473: ,'HXC_HSD_INV_OBJ_ID'
474: );
475: hr_utility.raise_error;
476: END IF;
477: CLOSE c_get_value;
478:
479: End chk_object;

Line 490: g_debug:=hr_utility.debug_enabled;

486: --
487: l_proc varchar2(72);
488: --
489: Begin
490: g_debug:=hr_utility.debug_enabled;
491: if g_debug then
492: l_proc := g_package||'insert_validate';
493: hr_utility.set_location('Entering:'||l_proc, 5);
494: end if;

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

489: Begin
490: g_debug:=hr_utility.debug_enabled;
491: if g_debug then
492: l_proc := g_package||'insert_validate';
493: hr_utility.set_location('Entering:'||l_proc, 5);
494: end if;
495: --
496: -- Call all supporting business operations
497: --

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

519: ) ;
520:
521:
522: if g_debug then
523: hr_utility.set_location(' Leaving:'||l_proc, 10);
524: end if;
525:
526: End insert_validate;
527: --

Line 538: g_debug:=hr_utility.debug_enabled;

534: --
535: l_proc varchar2(72);
536: --
537: Begin
538: g_debug:=hr_utility.debug_enabled;
539: if g_debug then
540: l_proc := g_package||'update_validate';
541: hr_utility.set_location('Entering:'||l_proc, 5);
542: end if;

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

537: Begin
538: g_debug:=hr_utility.debug_enabled;
539: if g_debug then
540: l_proc := g_package||'update_validate';
541: hr_utility.set_location('Entering:'||l_proc, 5);
542: end if;
543: --
544: -- Call all supporting business operations
545: --

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

571:
572: --
573: --
574: if g_debug then
575: hr_utility.set_location(' Leaving:'||l_proc, 10);
576: end if;
577: End update_validate;
578: --
579: -- ----------------------------------------------------------------------------

Line 589: g_debug:=hr_utility.debug_enabled;

585: --
586: l_proc varchar2(72);
587: --
588: Begin
589: g_debug:=hr_utility.debug_enabled;
590: if g_debug then
591: l_proc := g_package||'delete_validate';
592: hr_utility.set_location('Entering:'||l_proc, 5);
593: end if;

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

588: Begin
589: g_debug:=hr_utility.debug_enabled;
590: if g_debug then
591: l_proc := g_package||'delete_validate';
592: hr_utility.set_location('Entering:'||l_proc, 5);
593: end if;
594: --
595: -- Call all supporting business operations
596: --

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

594: --
595: -- Call all supporting business operations
596: --
597: if g_debug then
598: hr_utility.set_location(' Leaving:'||l_proc, 10);
599: end if;
600: End delete_validate;
601: --
602: end hxc_hsd_bus;