[Home] [Help]
39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error
80: --
81: hr_api.set_legislation_context(l_legislation_code);
82: end if;
83: --
84: hr_utility.set_location(' Leaving:'|| l_proc, 20);
85: --
86: end set_security_group_id;
87: --
88: -- ---------------------------------------------------------------------------
110: l_proc varchar2(72) := g_package||'return_legislation_code';
111: --
112: Begin
113: --
114: hr_utility.set_location('Entering:'|| l_proc, 10);
115: --
116: -- Ensure that all the mandatory parameter are not null
117: --
118: hr_api.mandatory_arg_error
131: -- call to this function. Just return the value in the global
132: -- variable.
133: --
134: l_legislation_code := ota_ctt_bus.g_legislation_code;
135: hr_utility.set_location(l_proc, 20);
136: else
137: --
138: -- The ID is different to the last call to this function
139: -- or this is the first call to this function.
148: close csr_leg_code;
149: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
150: fnd_message.raise_error;
151: end if;
152: hr_utility.set_location(l_proc,30);
153: --
154: -- Set the global variables so the values are
155: -- available for the next call to this function.
156: --
158: ota_ctt_bus.g_category_usage_id := p_category_usage_id;
159: ota_ctt_bus.g_language := p_language;
160: ota_ctt_bus.g_legislation_code := l_legislation_code;
161: end if;
162: hr_utility.set_location(' Leaving:'|| l_proc, 40);
163: return l_legislation_code;
164: end return_legislation_code;
165: --
166: -- ----------------------------------------------------------------------------
269: l_proc varchar2(72) := g_package||'Chk_unique_category';
270: --
271: Begin
272: --
273: hr_utility.set_location('Entering:'|| l_proc, 10);
274: --
275: open csr_cat_name;
276: fetch csr_cat_name into l_dup_cat_type;
277: --
284: fnd_message.set_name('OTA','OTA_443388_CTU_DUP_DM');
285: else
286: fnd_message.set_name('OTA','OTA_443337_CTU_DUP_NAME');
287: end if;
288: hr_utility.set_location(l_proc,20);
289: fnd_message.raise_error;
290: end if;
291: hr_utility.set_location(l_proc,30);
292: --
287: end if;
288: hr_utility.set_location(l_proc,20);
289: fnd_message.raise_error;
290: end if;
291: hr_utility.set_location(l_proc,30);
292: --
293: -- Set the global variables so the values are
294: -- available for the next call to this function.
295: --
294: -- available for the next call to this function.
295: --
296: close csr_cat_name;
297:
298: hr_utility.set_location(' Leaving:'|| l_proc, 40);
299: --
300: end Chk_unique_category;
301: --
302: -- ---------------------------------------------------------------------------
330: l_parent_cat_usage_id number(9);
331: --
332: Begin
333: --
334: hr_utility.set_location('Entering:'|| l_proc, 10);
335: --
336: open csr_cat_bg_type;
337: fetch csr_cat_bg_type into l_type, l_business_group_id, l_parent_cat_usage_id;
338: --
349: ,p_parent_cat_usage_id => l_parent_cat_usage_id
350: );
351: --
352: --
353: hr_utility.set_location(' Leaving:'|| l_proc, 20);
354: --
355: end Chk_unique_category;
356: --
357: -- ----------------------------------------------------------------------------
365: --
366: l_proc varchar2(72) := g_package||'insert_validate';
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: -- Call all supporting business operations
372: --
373: ota_ctu_bus.set_security_Group_id(p_category_usage_id);
378: ,p_category => p_rec.category
379: );
380: --
381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 10);
383: End insert_validate;
384: --
385: -- ----------------------------------------------------------------------------
386: -- |---------------------------< update_validate >----------------------------|
392: --
393: l_proc varchar2(72) := g_package||'update_validate';
394: --
395: Begin
396: hr_utility.set_location('Entering:'||l_proc, 5);
397: --
398: -- Call all supporting business operations
399: --
400: ota_ctu_bus.set_security_Group_id(p_rec.category_usage_id);
412: ,p_rec => p_rec
413: );
414: --
415: --
416: hr_utility.set_location(' Leaving:'||l_proc, 10);
417: End update_validate;
418: --
419: -- ----------------------------------------------------------------------------
420: -- |---------------------------< delete_validate >----------------------------|
425: --
426: l_proc varchar2(72) := g_package||'delete_validate';
427: --
428: Begin
429: hr_utility.set_location('Entering:'||l_proc, 5);
430: --
431: -- Call all supporting business operations
432: --
433: hr_utility.set_location(' Leaving:'||l_proc, 10);
429: hr_utility.set_location('Entering:'||l_proc, 5);
430: --
431: -- Call all supporting business operations
432: --
433: hr_utility.set_location(' Leaving:'||l_proc, 10);
434: End delete_validate;
435: --
436: end ota_ctt_bus;