DBA Data[Home] [Help]

APPS.BEN_XIC_BUS dependencies on HR_UTILITY

Line 52: hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);

48: -- If the value is not known then go onto check against the
49: -- hr_lookups view. Just in case there has been a change to
50: -- the system defined lookup.
51: end if;
52: hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);
53: --
54: open csr_hr_look;
55: fetch csr_hr_look into l_exists;
56: if csr_hr_look%notfound then

Line 104: hr_utility.set_location(hr_api.g_package||'not_exists_in_hrstanlookups', 10);

100: -- If the value is not known then go onto check against the
101: -- hr_lookups view. Just in case there has been a change to
102: -- the system defined lookup.
103: end if;
104: hr_utility.set_location(hr_api.g_package||'not_exists_in_hrstanlookups', 10);
105: --
106: open csr_hr_look;
107: fetch csr_hr_look into l_exists;
108: if csr_hr_look%notfound then

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

136: l_proc varchar2(72) := g_package||'set_security_group_id';
137: --
138: begin
139: --
140: hr_utility.set_location('Entering:'|| l_proc, 10);
141: --
142: -- Ensure that all the mandatory parameter are not null
143: --
144: hr_api.mandatory_arg_error

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

167: hr_api.set_security_group_id
168: (p_security_group_id => l_security_group_id
169: );
170: --
171: hr_utility.set_location(' Leaving:'|| l_proc, 20);
172: --
173: end set_security_group_id;
174: --
175: --

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

206: l_api_updating boolean;
207: --
208: Begin
209: --
210: hr_utility.set_location('Entering:'||l_proc, 5);
211: --
212: l_api_updating := ben_xic_shd.api_updating
213: (p_ext_incl_chg_id => p_ext_incl_chg_id,
214: p_object_version_number => p_object_version_number);

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

234: end if;
235: --
236: end if;
237: --
238: hr_utility.set_location('Leaving:'||l_proc, 10);
239: --
240: End chk_ext_incl_chg_id;
241: --
242: -- ----------------------------------------------------------------------------

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

278: where a.ext_rcd_in_file_id = p_ext_rcd_in_file_id;
279: --
280: Begin
281: --
282: hr_utility.set_location('Entering:'||l_proc,5);
283: --
284: l_api_updating := ben_xic_shd.api_updating
285: (p_ext_incl_chg_id => p_ext_incl_chg_id,
286: p_object_version_number => p_object_version_number);

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

310: close c1;
311: --
312: end if;
313: --
314: hr_utility.set_location('Leaving:'||l_proc,10);
315: --
316: End chk_ext_rcd_in_file_id;
317: --
318: -- ----------------------------------------------------------------------------

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

354: where a.ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id;
355: --
356: Begin
357: --
358: hr_utility.set_location('Entering:'||l_proc,5);
359: --
360: l_api_updating := ben_xic_shd.api_updating
361: (p_ext_incl_chg_id => p_ext_incl_chg_id,
362: p_object_version_number => p_object_version_number);

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

386: close c1;
387: --
388: end if;
389: --
390: hr_utility.set_location('Leaving:'||l_proc,10);
391: --
392: End chk_ext_data_elmt_in_rcd_id;
393: --
394: -- ----------------------------------------------------------------------------

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

443: ;
444: l_dummy varchar2(1) ;
445: Begin
446: --
447: hr_utility.set_location('Entering:'||l_proc, 5);
448: hr_utility.set_location('Inside .hrstanlookups..'||l_proc||' '||p_chg_evt_cd, 8);
449: --
450: l_api_updating := ben_xic_shd.api_updating
451: (p_ext_incl_chg_id => p_ext_incl_chg_id,

Line 448: hr_utility.set_location('Inside .hrstanlookups..'||l_proc||' '||p_chg_evt_cd, 8);

444: l_dummy varchar2(1) ;
445: Begin
446: --
447: hr_utility.set_location('Entering:'||l_proc, 5);
448: hr_utility.set_location('Inside .hrstanlookups..'||l_proc||' '||p_chg_evt_cd, 8);
449: --
450: l_api_updating := ben_xic_shd.api_updating
451: (p_ext_incl_chg_id => p_ext_incl_chg_id,
452: p_object_version_number => p_object_version_number);

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

543: end loop;
544: end if;*/
545: end if;
546: --
547: hr_utility.set_location('Leaving:'||l_proc,10);
548: --
549: end chk_chg_evt_cd;
550: --
551: --

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

577: and (p_ext_incl_chg_id <> ext_incl_chg_id or p_ext_incl_chg_id is null ) ;
578: l_dummy varchar2(1) ;
579: Begin
580: --
581: hr_utility.set_location('Entering:'||l_proc, 5);
582: hr_utility.set_location('Inside .hrstanlookups..'||l_proc||' '||p_chg_evt_cd, 8);
583: --
584: if p_ext_rcd_in_file_id is not null then
585: open c1 ;

Line 582: hr_utility.set_location('Inside .hrstanlookups..'||l_proc||' '||p_chg_evt_cd, 8);

578: l_dummy varchar2(1) ;
579: Begin
580: --
581: hr_utility.set_location('Entering:'||l_proc, 5);
582: hr_utility.set_location('Inside .hrstanlookups..'||l_proc||' '||p_chg_evt_cd, 8);
583: --
584: if p_ext_rcd_in_file_id is not null then
585: open c1 ;
586: fetch c1 into l_dummy ;

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

605: close c2 ;
606: end if ;
607:
608: --
609: hr_utility.set_location('Leaving:'||l_proc,10);
610: --
611: end chk_unique_chg_evt_cd;
612: --
613:

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

667: --
668: l_proc varchar2(72) := g_package||'insert_validate';
669: --
670: Begin
671: hr_utility.set_location('Entering:'||l_proc, 5);
672: --
673: -- Call all supporting business operations
674: --
675: --

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

712: p_chg_evt_source => p_rec.chg_evt_source,
713: p_effective_date => p_effective_date,
714: p_business_group_id => p_rec.business_group_id,
715: p_object_version_number => p_rec.object_version_number);
716: hr_utility.set_location(' Leaving:'||l_proc, 10);
717: End insert_validate;
718: --
719: -- ----------------------------------------------------------------------------
720: -- |---------------------------< update_validate >----------------------------|

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

724: --
725: l_proc varchar2(72) := g_package||'update_validate';
726: --
727: Begin
728: hr_utility.set_location('Entering:'||l_proc, 5);
729: --
730: -- Call all supporting business operations
731: --
732: --

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

769: p_chg_evt_source => p_rec.chg_evt_source,
770: p_effective_date => p_effective_date,
771: p_business_group_id => p_rec.business_group_id,
772: p_object_version_number => p_rec.object_version_number);
773: hr_utility.set_location(' Leaving:'||l_proc, 10);
774: End update_validate;
775: --
776: -- ----------------------------------------------------------------------------
777: -- |---------------------------< delete_validate >----------------------------|

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

781: --
782: l_proc varchar2(72) := g_package||'delete_validate';
783: --
784: Begin
785: hr_utility.set_location('Entering:'||l_proc, 5);
786: --
787: -- Call all supporting business operations
788: --
789: --

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

790: chk_startup_action(False
791: ,ben_xic_shd.g_old_rec.business_group_id
792: ,ben_xic_shd.g_old_rec.legislation_code);
793: --
794: hr_utility.set_location(' Leaving:'||l_proc, 10);
795: End delete_validate;
796: --
797: --
798: -- ---------------------------------------------------------------------------

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

817: l_proc varchar2(72) := g_package||'return_legislation_code';
818: --
819: begin
820: --
821: hr_utility.set_location('Entering:'|| l_proc, 10);
822: --
823: -- Ensure that all the mandatory parameter are not null
824: --
825: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

844: l_legislation_code := hr_api.return_legislation_code(l_business_group_id) ;
845: --
846: close csr_leg_code;
847: --
848: hr_utility.set_location(' Leaving:'|| l_proc, 20);
849: --
850: return l_legislation_code;
851: --
852: end return_legislation_code;