49: l_proc varchar2(72) := g_package||'set_security_group_id';
50: --
51: begin
52: --
53: hr_utility.set_location('Entering:'|| l_proc, 10);
54: --
55: -- Ensure that all the mandatory parameter are not null
56: --
57: hr_api.mandatory_arg_error
85: (p_security_group_id => l_security_group_id
86: );
87: end if;
88: --
89: hr_utility.set_location(' Leaving:'|| l_proc, 20);
90: --
91: end set_security_group_id;
92: --
93: -- ---------------------------------------------------------------------------
121: l_proc varchar2(72) := g_package||'return_legislation_code';
122: --
123: Begin
124: --
125: hr_utility.set_location('Entering:'|| l_proc, 10);
126: --
127: -- Ensure that all the mandatory parameter are not null
128: --
129: hr_api.mandatory_arg_error
142: -- call to this function. Just return the value in the global
143: -- variable.
144: --
145: l_legislation_code := per_rtx_bus.g_legislation_code;
146: hr_utility.set_location(l_proc, 20);
147: else
148: --
149: -- The ID is different to the last call to this function
150: -- or this is the first call to this function.
159: close csr_leg_code;
160: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
161: fnd_message.raise_error;
162: end if;
163: hr_utility.set_location(l_proc,30);
164: --
165: -- Set the global variables so the values are
166: -- available for the next call to this function.
167: --
169: per_rtx_bus.g_rating_level_id := p_rating_level_id;
170: per_rtx_bus.g_language := p_language;
171: per_rtx_bus.g_legislation_code := l_legislation_code;
172: end if;
173: hr_utility.set_location(' Leaving:'|| l_proc, 40);
174: return l_legislation_code;
175: end return_legislation_code;
176: --
177: -- ----------------------------------------------------------------------------
291: = nvl(p_rating_scale_id,hr_api.g_number))
292: );
293: --
294: begin
295: hr_utility.set_location('Entering:'|| l_proc, 1);
296: --
297: -- Only proceed with validation if :
298: -- a) The current g_old_rec is current and
299: -- b) The value for name has changed
307: ) or
308: (NOT l_api_updating)
309: ) then
310: --
311: hr_utility.set_location(l_proc, 2);
312: --
313: -- check if the user has entered a name, as name is
314: -- is mandatory column.
315: --
313: -- check if the user has entered a name, as name is
314: -- is mandatory column.
315: --
316: if p_name is null then
317: hr_utility.set_message(801,'HR_51475_RTL_NAME_MANDATORY');
318: hr_utility.raise_error;
319: end if;
320: --
321: -- check if name is unique
314: -- is mandatory column.
315: --
316: if p_name is null then
317: hr_utility.set_message(801,'HR_51475_RTL_NAME_MANDATORY');
318: hr_utility.raise_error;
319: end if;
320: --
321: -- check if name is unique
322: --
322: --
323: open csr_chk_name_unique;
324: fetch csr_chk_name_unique into l_exists;
325: if csr_chk_name_unique%found then
326: hr_utility.set_location(l_proc, 3);
327: -- name is not unique
328: close csr_chk_name_unique;
329: hr_utility.set_message(801,'HR_51474_RTL_NOT_UNIQUE');
330: hr_utility.raise_error;
325: if csr_chk_name_unique%found then
326: hr_utility.set_location(l_proc, 3);
327: -- name is not unique
328: close csr_chk_name_unique;
329: hr_utility.set_message(801,'HR_51474_RTL_NOT_UNIQUE');
330: hr_utility.raise_error;
331: end if;
332: close csr_chk_name_unique;
333: end if;
326: hr_utility.set_location(l_proc, 3);
327: -- name is not unique
328: close csr_chk_name_unique;
329: hr_utility.set_message(801,'HR_51474_RTL_NOT_UNIQUE');
330: hr_utility.raise_error;
331: end if;
332: close csr_chk_name_unique;
333: end if;
334: hr_utility.set_location('Leaving:'|| l_proc, 10);
330: hr_utility.raise_error;
331: end if;
332: close csr_chk_name_unique;
333: end if;
334: hr_utility.set_location('Leaving:'|| l_proc, 10);
335: end chk_name;
336: --
337: -- ----------------------------------------------------------------------------
338: -- |------------------------< validate_translation>--------------------------|
355: l_rtl_rec csr_rating_level%ROWTYPE;
356: --
357: Begin
358: --
359: hr_utility.set_location('Entering:'||l_proc,5);
360: --
361: open csr_rating_level;
362: --
363: fetch csr_rating_level into l_rtl_rec;
384: --
385: l_proc varchar2(72) := g_package||'insert_validate';
386: --
387: Begin
388: hr_utility.set_location('Entering:'||l_proc, 5);
389: --
390: -- Call all supporting business operations
391: --
392: -- MB amended 16-Dec-2002
400: --
401: -- Validate Dependent Attributes
402: --
403: --
404: hr_utility.set_location(' Leaving:'||l_proc, 10);
405: End insert_validate;
406: --
407: -- ----------------------------------------------------------------------------
408: -- |---------------------------< update_validate >----------------------------|
413: --
414: l_proc varchar2(72) := g_package||'update_validate';
415: --
416: Begin
417: hr_utility.set_location('Entering:'||l_proc, 5);
418: --
419: -- Call all supporting business operations
420: --
421: -- MB amedned 16-Dec-2002
431: validate_translation
432: ( p_rec
433: );
434: --
435: hr_utility.set_location(' Leaving:'||l_proc, 10);
436: End update_validate;
437: --
438: -- ----------------------------------------------------------------------------
439: -- |---------------------------< delete_validate >----------------------------|
444: --
445: l_proc varchar2(72) := g_package||'delete_validate';
446: --
447: Begin
448: hr_utility.set_location('Entering:'||l_proc, 5);
449: --
450: -- Call all supporting business operations
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 10);
448: hr_utility.set_location('Entering:'||l_proc, 5);
449: --
450: -- Call all supporting business operations
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 10);
453: End delete_validate;
454: --
455: -- ----------------------------------------------------------------------------
456: -- |-----------------------< set_translation_globals >------------------------|
486: l_proc varchar2(72) := g_package||'set_translation_globals';
487: --
488: BEGIN
489: --
490: hr_utility.set_location('Entering:'||l_proc,5);
491: --
492: g_rating_scale_id := p_rating_scale_id;
493: g_competence_id := p_competence_id;
494: --
491: --
492: g_rating_scale_id := p_rating_scale_id;
493: g_competence_id := p_competence_id;
494: --
495: hr_utility.set_location('Leaving:'||l_proc,10);
496: --
497: END;
498: --
499: -- ----------------------------------------------------------------------------
534: l_proc varchar2(72) := g_package||'validate_translation';
535: --
536: BEGIN
537: --
538: hr_utility.set_location('Entering:'||l_proc,5);
539: --
540: chk_name
541: ( p_rating_level_id => p_rating_level_id
542: , p_language => p_language
544: , p_rating_scale_id => nvl(p_rating_scale_id, g_rating_scale_id)
545: , p_competence_id => nvl(p_competence_id, g_competence_id)
546: );
547: --
548: hr_utility.set_location('Leaving:'||l_proc,10);
549: --
550: END;
551: --
552: end per_rtx_bus;