5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_tkg_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: --
80: --
81: l_proc varchar2(72) ;
82: --
83: Begin
84: g_debug :=hr_utility.debug_enabled;
85: if g_debug then
86: l_proc := g_package||'insert_validate';
87: hr_utility.set_location('Entering:'||l_proc, 5);
88: end if;
83: Begin
84: g_debug :=hr_utility.debug_enabled;
85: if g_debug then
86: l_proc := g_package||'insert_validate';
87: hr_utility.set_location('Entering:'||l_proc, 5);
88: end if;
89: --
90: -- Call all supporting business operations
91: --
91: --
92: chk_business_group_id(p_rec.business_group_id);
93: --
94: if g_debug then
95: hr_utility.set_location(' Leaving:'||l_proc, 10);
96: end if;
97: End insert_validate;
98: --
99: -- ----------------------------------------------------------------------------
105: --
106: l_proc varchar2(72) ;
107: --
108: Begin
109: g_debug :=hr_utility.debug_enabled;
110: if g_debug then
111: l_proc := g_package||'update_validate';
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: end if;
108: Begin
109: g_debug :=hr_utility.debug_enabled;
110: if g_debug then
111: l_proc := g_package||'update_validate';
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: end if;
114: --
115: -- Call all supporting business operations
116: --
127: );
128: --
129: --
130: if g_debug then
131: hr_utility.set_location(' Leaving:'||l_proc, 10);
132: end if;
133: End update_validate;
134: --
135: -- ----------------------------------------------------------------------------
141: --
142: l_proc varchar2(72) ;
143: --
144: Begin
145: g_debug :=hr_utility.debug_enabled;
146: if g_debug then
147: l_proc := g_package||'delete_validate';
148: hr_utility.set_location('Entering:'||l_proc, 5);
149: end if;
144: Begin
145: g_debug :=hr_utility.debug_enabled;
146: if g_debug then
147: l_proc := g_package||'delete_validate';
148: hr_utility.set_location('Entering:'||l_proc, 5);
149: end if;
150: --
151: -- Call all supporting business operations
152: --
152: --
153: null;
154: --
155: if g_debug then
156: hr_utility.set_location(' Leaving:'||l_proc, 10);
157: end if;
158: End delete_validate;
159: --
160: -- ----------------------------------------------------------------------------
204: --
205: -- raise error as business group not found
206: --
207: --
208: hr_utility.set_message(809,'HXC_TKG_INV_BG_ID');
209: hr_utility.raise_error;
210: --
211: end if;
212: --
205: -- raise error as business group not found
206: --
207: --
208: hr_utility.set_message(809,'HXC_TKG_INV_BG_ID');
209: hr_utility.raise_error;
210: --
211: end if;
212: --
213: close c1;
212: --
213: close c1;
214: --
215: else
216: hr_utility.set_message(809,'HXC_TKG_INV_BG_ID');
217: hr_utility.raise_error;
218: end if;
219: --
220: --
213: close c1;
214: --
215: else
216: hr_utility.set_message(809,'HXC_TKG_INV_BG_ID');
217: hr_utility.raise_error;
218: end if;
219: --
220: --
221: End chk_business_group_id;