DBA Data[Home] [Help]

APPS.PER_RTX_BUS dependencies on HR_UTILITY

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

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

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

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: -- ---------------------------------------------------------------------------

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

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

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

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.

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

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: --

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

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: -- ----------------------------------------------------------------------------

Line 295: hr_utility.set_location('Entering:'|| l_proc, 1);

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

Line 311: hr_utility.set_location(l_proc, 2);

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: --

Line 317: hr_utility.set_message(801,'HR_51475_RTL_NAME_MANDATORY');

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

Line 318: hr_utility.raise_error;

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: --

Line 326: hr_utility.set_location(l_proc, 3);

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;

Line 329: hr_utility.set_message(801,'HR_51474_RTL_NOT_UNIQUE');

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;

Line 330: hr_utility.raise_error;

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);

Line 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>--------------------------|

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

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;

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

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

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

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 >----------------------------|

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

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

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

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 >----------------------------|

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

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);

Line 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 >------------------------|

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

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: --

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

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: -- ----------------------------------------------------------------------------

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

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

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

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;