eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_RSC_BUS dependencies on HR_UTILITY

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

22: l_error exception;
23: l_argument varchar2(30);
24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 5);
27: --
28: -- Only proceed with validation if a row exists for
29: -- the current record in the HR Schema
30: --

Line 35: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

31: if not per_rsc_shd.api_updating
32: (p_rating_scale_id => p_rec.rating_scale_id
33: ,p_object_version_number => p_rec.object_version_number
34: ) then
35: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
36: hr_utility.set_message_token('PROCEDURE', l_proc);
37: hr_utility.set_message_token('STEP', '5');
38: end if;
39: --

Line 36: hr_utility.set_message_token('PROCEDURE', l_proc);

32: (p_rating_scale_id => p_rec.rating_scale_id
33: ,p_object_version_number => p_rec.object_version_number
34: ) then
35: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
36: hr_utility.set_message_token('PROCEDURE', l_proc);
37: hr_utility.set_message_token('STEP', '5');
38: end if;
39: --
40: hr_utility.set_location(l_proc, 6);

Line 37: hr_utility.set_message_token('STEP', '5');

33: ,p_object_version_number => p_rec.object_version_number
34: ) then
35: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
36: hr_utility.set_message_token('PROCEDURE', l_proc);
37: hr_utility.set_message_token('STEP', '5');
38: end if;
39: --
40: hr_utility.set_location(l_proc, 6);
41: --

Line 40: hr_utility.set_location(l_proc, 6);

36: hr_utility.set_message_token('PROCEDURE', l_proc);
37: hr_utility.set_message_token('STEP', '5');
38: end if;
39: --
40: hr_utility.set_location(l_proc, 6);
41: --
42: if p_rec.business_group_id <> per_rsc_shd.g_old_rec.business_group_id then
43: l_argument := 'business_group_id';
44: raise l_error;

Line 46: hr_utility.set_location(l_proc, 7);

42: if p_rec.business_group_id <> per_rsc_shd.g_old_rec.business_group_id then
43: l_argument := 'business_group_id';
44: raise l_error;
45: end if;
46: hr_utility.set_location(l_proc, 7);
47: --
48: if p_rec.rating_scale_id <> per_rsc_shd.g_old_rec.rating_scale_id then
49: l_argument := 'rating_scale_id';
50: raise l_error;

Line 52: hr_utility.set_location(l_proc, 9);

48: if p_rec.rating_scale_id <> per_rsc_shd.g_old_rec.rating_scale_id then
49: l_argument := 'rating_scale_id';
50: raise l_error;
51: end if;
52: hr_utility.set_location(l_proc, 9);
53: --
54: if p_rec.type <> per_rsc_shd.g_old_rec.type then
55: l_argument := 'type';
56: raise l_error;

Line 58: hr_utility.set_location(l_proc, 10);

54: if p_rec.type <> per_rsc_shd.g_old_rec.type then
55: l_argument := 'type';
56: raise l_error;
57: end if;
58: hr_utility.set_location(l_proc, 10);
59: --
60: exception
61: when l_error then
62: hr_api.argument_changed_error

Line 67: hr_utility.set_location(' Leaving:'||l_proc, 12);

63: (p_api_name => l_proc
64: ,p_argument => l_argument);
65: when others then
66: raise;
67: hr_utility.set_location(' Leaving:'||l_proc, 12);
68: end check_non_updateable_args;
69: --
70: --
71: --

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

139: and p_business_group_id is not null;
140: -- ngundura end of changes
141: --
142: begin
143: hr_utility.set_location ('Entering:'|| l_proc, 1);
144: --
145: --
146: if p_name is null then
147: hr_utility.set_message(801, 'HR_51571_RSC_NAME_MANDATORY');

Line 147: hr_utility.set_message(801, 'HR_51571_RSC_NAME_MANDATORY');

143: hr_utility.set_location ('Entering:'|| l_proc, 1);
144: --
145: --
146: if p_name is null then
147: hr_utility.set_message(801, 'HR_51571_RSC_NAME_MANDATORY');
148: hr_utility.raise_error;
149: end if;
150: --
151: -- ngundura changes as per the pa requirements.

Line 148: hr_utility.raise_error;

144: --
145: --
146: if p_name is null then
147: hr_utility.set_message(801, 'HR_51571_RSC_NAME_MANDATORY');
148: hr_utility.raise_error;
149: end if;
150: --
151: -- ngundura changes as per the pa requirements.
152: /* hr_api.mandatory_arg_error

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

165: (p_rating_scale_id => p_rating_scale_id
166: ,p_object_version_number => p_object_version_number
167: );
168: --
169: hr_utility.set_location (l_proc, 3);
170: --
171: if (l_api_updating AND
172: nvl(per_rsc_shd.g_old_rec.name, hr_api.g_varchar2)
173: <> nvl(p_name, hr_api.g_varchar2)

Line 177: hr_utility.set_location (l_proc, 4);

173: <> nvl(p_name, hr_api.g_varchar2)
174: or not l_api_updating)
175: then
176: --
177: hr_utility.set_location (l_proc, 4);
178: --
179: -- Check that NAME is UNIQUE
180: --
181: open csr_name_exists;

Line 182: hr_utility.set_location (l_proc, 100);

178: --
179: -- Check that NAME is UNIQUE
180: --
181: open csr_name_exists;
182: hr_utility.set_location (l_proc, 100);
183: fetch csr_name_exists into l_exists;
184: if csr_name_exists%found then
185: hr_utility.set_location(l_proc, 10);
186: close csr_name_exists;

Line 185: hr_utility.set_location(l_proc, 10);

181: open csr_name_exists;
182: hr_utility.set_location (l_proc, 100);
183: fetch csr_name_exists into l_exists;
184: if csr_name_exists%found then
185: hr_utility.set_location(l_proc, 10);
186: close csr_name_exists;
187: hr_utility.set_location(to_char(l_exists), 99);
188: if l_exists is null then
189: fnd_message.set_name('PER', 'HR_52696_RSC_NAME_IN_GLOB');

Line 187: hr_utility.set_location(to_char(l_exists), 99);

183: fetch csr_name_exists into l_exists;
184: if csr_name_exists%found then
185: hr_utility.set_location(l_proc, 10);
186: close csr_name_exists;
187: hr_utility.set_location(to_char(l_exists), 99);
188: if l_exists is null then
189: fnd_message.set_name('PER', 'HR_52696_RSC_NAME_IN_GLOB');
190: fnd_message.raise_error;
191: else

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

195: end if;
196: close csr_name_exists;
197: end if;
198: --
199: hr_utility.set_location ('Leaving '||l_proc, 20);
200: end not_used_chk_name;
201: --
202: --
203: -------------------------------------------------------------------------------

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

237: l_proc varchar2(72) := g_package||'chk_not_applicable_flag';
238: l_api_updating boolean;
239: --
240: begin
241: hr_utility.set_location('Entering: '||l_proc, 1);
242: --
243: -- Check mandatory parameters have been set.
244: --
245: hr_api.mandatory_arg_error

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

262: hr_api.g_varchar2)
263: <> nvl(p_type, hr_api.g_varchar2)) or
264: (NOT l_api_updating)) then
265: --
266: hr_utility.set_location(l_proc, 2);
267: --
268: -- If type is not null then
269: -- Check if the type value exists in hr_lookups
270: -- where lookup_type is 'RATING_SCALE_TYPE'

Line 278: hr_utility.set_message(801,'HR_51444_RSC_INVALID_TYPE');

274: (p_effective_date => p_effective_date
275: ,p_lookup_type => 'RATING_SCALE_TYPE'
276: ,p_lookup_code => p_type
277: ) then
278: hr_utility.set_message(801,'HR_51444_RSC_INVALID_TYPE');
279: hr_utility.raise_error;
280: end if;
281: hr_utility.set_location(l_proc, 3);
282: end if;

Line 279: hr_utility.raise_error;

275: ,p_lookup_type => 'RATING_SCALE_TYPE'
276: ,p_lookup_code => p_type
277: ) then
278: hr_utility.set_message(801,'HR_51444_RSC_INVALID_TYPE');
279: hr_utility.raise_error;
280: end if;
281: hr_utility.set_location(l_proc, 3);
282: end if;
283: end if;

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

277: ) then
278: hr_utility.set_message(801,'HR_51444_RSC_INVALID_TYPE');
279: hr_utility.raise_error;
280: end if;
281: hr_utility.set_location(l_proc, 3);
282: end if;
283: end if;
284: hr_utility.set_location('Leaving '||l_proc, 4);
285: end chk_type;

Line 284: hr_utility.set_location('Leaving '||l_proc, 4);

280: end if;
281: hr_utility.set_location(l_proc, 3);
282: end if;
283: end if;
284: hr_utility.set_location('Leaving '||l_proc, 4);
285: end chk_type;
286: --
287: --
288: --

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

355: and type = p_type
356: and p_business_group_id is not null;
357: -- ngundura end of changes
358: begin
359: hr_utility.set_location('Entering: '||l_proc, 1);
360: --
361: -- Check mandatory parameters have been set.
362: --
363: hr_api.mandatory_arg_error

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

381: <> nvl(p_default_flag, hr_api.g_varchar2))
382: or
383: (NOT l_api_updating)) then
384: --
385: hr_utility.set_location(l_proc, 2);
386: --
387: --
388: -- If default_flag is not null then
389: -- Check if the default_flag value exists in hr_lookups

Line 398: then hr_utility.set_message(801,'HR_51450_RSC_INV_DEF_FLAG');

394: (p_effective_date => p_effective_date
395: ,p_lookup_type => 'YES_NO'
396: ,p_lookup_code => p_default_flag
397: )
398: then hr_utility.set_message(801,'HR_51450_RSC_INV_DEF_FLAG');
399: hr_utility.raise_error;
400: end if;
401: hr_utility.set_location(l_proc, 3);
402: end if;

Line 399: hr_utility.raise_error;

395: ,p_lookup_type => 'YES_NO'
396: ,p_lookup_code => p_default_flag
397: )
398: then hr_utility.set_message(801,'HR_51450_RSC_INV_DEF_FLAG');
399: hr_utility.raise_error;
400: end if;
401: hr_utility.set_location(l_proc, 3);
402: end if;
403: end if;

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

397: )
398: then hr_utility.set_message(801,'HR_51450_RSC_INV_DEF_FLAG');
399: hr_utility.raise_error;
400: end if;
401: hr_utility.set_location(l_proc, 3);
402: end if;
403: end if;
404: --
405: hr_utility.set_location (l_proc, 4);

Line 405: hr_utility.set_location (l_proc, 4);

401: hr_utility.set_location(l_proc, 3);
402: end if;
403: end if;
404: --
405: hr_utility.set_location (l_proc, 4);
406: --
407: if p_default_flag = 'Y' then
408: open csr_get_default_flag;
409: fetch csr_get_default_flag into l_exists;

Line 412: hr_utility.set_location (l_proc, 5);

408: open csr_get_default_flag;
409: fetch csr_get_default_flag into l_exists;
410: if csr_get_default_flag%found then
411: close csr_get_default_flag;
412: hr_utility.set_location (l_proc, 5);
413: hr_utility.set_message (801, 'HR_51451_RSC_DEFAULT_EXISTS');
414: hr_utility.raise_error;
415: end if;
416: close csr_get_default_flag;

Line 413: hr_utility.set_message (801, 'HR_51451_RSC_DEFAULT_EXISTS');

409: fetch csr_get_default_flag into l_exists;
410: if csr_get_default_flag%found then
411: close csr_get_default_flag;
412: hr_utility.set_location (l_proc, 5);
413: hr_utility.set_message (801, 'HR_51451_RSC_DEFAULT_EXISTS');
414: hr_utility.raise_error;
415: end if;
416: close csr_get_default_flag;
417: end if;

Line 414: hr_utility.raise_error;

410: if csr_get_default_flag%found then
411: close csr_get_default_flag;
412: hr_utility.set_location (l_proc, 5);
413: hr_utility.set_message (801, 'HR_51451_RSC_DEFAULT_EXISTS');
414: hr_utility.raise_error;
415: end if;
416: close csr_get_default_flag;
417: end if;
418: --

Line 419: hr_utility.set_location('Leaving '||l_proc, 6);

415: end if;
416: close csr_get_default_flag;
417: end if;
418: --
419: hr_utility.set_location('Leaving '||l_proc, 6);
420: end chk_default_flag;
421: --
422: --
423: --

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

503: where (rle.rating_level_id= pce.rating_level_id)
504: or (rle.rating_level_id = pce.weighting_level_id) );
505: --
506: begin
507: hr_utility.set_location('Entering '||l_proc, 1);
508: --
509: -- Check a rating scale is not referenced by an assessment type
510: --
511: open csr_get_rs_assessment_type;

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

511: open csr_get_rs_assessment_type;
512: fetch csr_get_rs_assessment_type into l_exists;
513: if csr_get_rs_assessment_type%found
514: then close csr_get_rs_assessment_type;
515: hr_utility.set_location (l_proc, 2);
516: hr_utility.set_message (801, 'HR_51573_RSC_RSC_IN_AST');
517: hr_utility.raise_error;
518: end if;
519: close csr_get_rs_assessment_type;

Line 516: hr_utility.set_message (801, 'HR_51573_RSC_RSC_IN_AST');

512: fetch csr_get_rs_assessment_type into l_exists;
513: if csr_get_rs_assessment_type%found
514: then close csr_get_rs_assessment_type;
515: hr_utility.set_location (l_proc, 2);
516: hr_utility.set_message (801, 'HR_51573_RSC_RSC_IN_AST');
517: hr_utility.raise_error;
518: end if;
519: close csr_get_rs_assessment_type;
520: --

Line 517: hr_utility.raise_error;

513: if csr_get_rs_assessment_type%found
514: then close csr_get_rs_assessment_type;
515: hr_utility.set_location (l_proc, 2);
516: hr_utility.set_message (801, 'HR_51573_RSC_RSC_IN_AST');
517: hr_utility.raise_error;
518: end if;
519: close csr_get_rs_assessment_type;
520: --
521: /* *** Not impelemented yet **************

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

525: open csr_get_performance_rating;
526: fetch csr_get_performance_rating into l_exists;
527: if csr_get_performance_rating%found
528: then close csr_get_performance_rating;
529: hr_utility.set_location (l_proc, 3);
530: hr_utility.set_message (801, 'HR_<>');
531: hr_utility.raise_error;
532: end if;
533: close csr_get_performance_rating;

Line 530: hr_utility.set_message (801, 'HR_<>');

526: fetch csr_get_performance_rating into l_exists;
527: if csr_get_performance_rating%found
528: then close csr_get_performance_rating;
529: hr_utility.set_location (l_proc, 3);
530: hr_utility.set_message (801, 'HR_<>');
531: hr_utility.raise_error;
532: end if;
533: close csr_get_performance_rating;
534: **************************************** */

Line 531: hr_utility.raise_error;

527: if csr_get_performance_rating%found
528: then close csr_get_performance_rating;
529: hr_utility.set_location (l_proc, 3);
530: hr_utility.set_message (801, 'HR_<>');
531: hr_utility.raise_error;
532: end if;
533: close csr_get_performance_rating;
534: **************************************** */
535: --

Line 542: hr_utility.set_location (l_proc, 4);

538: open csr_get_competence_rating;
539: fetch csr_get_competence_rating into l_exists;
540: if csr_get_competence_rating%found
541: then close csr_get_competence_rating;
542: hr_utility.set_location (l_proc, 4);
543: hr_utility.set_message (801, 'HR_51572_RSC_RSC_IN_CPN');
544: hr_utility.raise_error;
545: end if;
546: close csr_get_competence_rating;

Line 543: hr_utility.set_message (801, 'HR_51572_RSC_RSC_IN_CPN');

539: fetch csr_get_competence_rating into l_exists;
540: if csr_get_competence_rating%found
541: then close csr_get_competence_rating;
542: hr_utility.set_location (l_proc, 4);
543: hr_utility.set_message (801, 'HR_51572_RSC_RSC_IN_CPN');
544: hr_utility.raise_error;
545: end if;
546: close csr_get_competence_rating;
547: --

Line 544: hr_utility.raise_error;

540: if csr_get_competence_rating%found
541: then close csr_get_competence_rating;
542: hr_utility.set_location (l_proc, 4);
543: hr_utility.set_message (801, 'HR_51572_RSC_RSC_IN_CPN');
544: hr_utility.raise_error;
545: end if;
546: close csr_get_competence_rating;
547: --
548: -- Check a rating scale is not referenced by a rating LEVEL which is

Line 555: hr_utility.set_location (l_proc, 4);

551: open csr_get_rl_rating_level;
552: fetch csr_get_rl_rating_level into l_exists;
553: if csr_get_rl_rating_level%found
554: then close csr_get_rl_rating_level;
555: hr_utility.set_location (l_proc, 4);
556: hr_utility.set_message (801, 'HR_51574_RSC_IN_RTL_IN_ELE');
557: hr_utility.raise_error;
558: end if;
559: close csr_get_rl_rating_level;

Line 556: hr_utility.set_message (801, 'HR_51574_RSC_IN_RTL_IN_ELE');

552: fetch csr_get_rl_rating_level into l_exists;
553: if csr_get_rl_rating_level%found
554: then close csr_get_rl_rating_level;
555: hr_utility.set_location (l_proc, 4);
556: hr_utility.set_message (801, 'HR_51574_RSC_IN_RTL_IN_ELE');
557: hr_utility.raise_error;
558: end if;
559: close csr_get_rl_rating_level;
560: --

Line 557: hr_utility.raise_error;

553: if csr_get_rl_rating_level%found
554: then close csr_get_rl_rating_level;
555: hr_utility.set_location (l_proc, 4);
556: hr_utility.set_message (801, 'HR_51574_RSC_IN_RTL_IN_ELE');
557: hr_utility.raise_error;
558: end if;
559: close csr_get_rl_rating_level;
560: --
561: hr_utility.set_location ('Leaving '||l_proc, 5);

Line 561: hr_utility.set_location ('Leaving '||l_proc, 5);

557: hr_utility.raise_error;
558: end if;
559: close csr_get_rl_rating_level;
560: --
561: hr_utility.set_location ('Leaving '||l_proc, 5);
562: --
563: end chk_rating_scale_delete;
564: --
565: -- -----------------------------------------------------------------------

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

594: --
595: l_proc varchar2(72) := g_package||'chk_df';
596: --
597: begin
598: hr_utility.set_location('Entering:'||l_proc, 10);
599: --
600: if (((p_rec.rating_scale_id is not null) and (
601: nvl(per_rsc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
602: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

695: ,p_attribute20_value => p_rec.attribute20
696: );
697: end if;
698: --
699: hr_utility.set_location(' Leaving:'||l_proc, 20);
700: --
701: end chk_df;
702: --
703: -- ----------------------------------------------------------------------------

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

708: --
709: l_proc varchar2(72) := g_package||'insert_validate';
710: --
711: Begin
712: hr_utility.set_location('Entering:'||l_proc, 5);
713: --
714: -- Call all supporting business operations. Mapping to the
715: -- appropriate Business Rules in perrsc.bru is provided.
716: --

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

724: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
725: end if;
726: -- ngundura end of changes
727: --
728: hr_utility.set_location(' Leaving:'||l_proc, 10);
729: --
730: --
731: -- Validate name
732: --

Line 746: hr_utility.set_location (l_proc, 15);

742: -- ,p_name => p_rec.name
743: -- ,p_object_version_number => p_rec.object_version_number
744: -- );
745: --
746: hr_utility.set_location (l_proc, 15);
747: --
748: -- Validate type
749: --
750: -- Business Rule Mapping

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

757: ,p_effective_date => p_effective_date
758: ,p_object_version_number => p_rec.object_version_number
759: );
760: --
761: hr_utility.set_location (l_proc, 20);
762: --
763: -- Validate default flag
764: --
765: -- Business Rule Mapping

Line 782: hr_utility.set_location (l_proc, 25);

778: -- call descriptive flexfield validation routines
779: --
780: per_rsc_bus.chk_df(p_rec => p_rec);
781: --
782: hr_utility.set_location (l_proc, 25);
783: --
784: hr_utility.set_location ('Leaving '||l_proc, 30);
785: End insert_validate;
786: --

Line 784: hr_utility.set_location ('Leaving '||l_proc, 30);

780: per_rsc_bus.chk_df(p_rec => p_rec);
781: --
782: hr_utility.set_location (l_proc, 25);
783: --
784: hr_utility.set_location ('Leaving '||l_proc, 30);
785: End insert_validate;
786: --
787: -- ----------------------------------------------------------------------------
788: -- |---------------------------< update_validate >----------------------------|

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

792: --
793: l_proc varchar2(72) := g_package||'update_validate';
794: --
795: Begin
796: hr_utility.set_location('Entering:'||l_proc, 5);
797: --
798: -- Call all supporting business operations. Mapping to the
799: -- appropriate Business Rules in perrsc.bru is provided.
800: --

Line 817: hr_utility.set_location (l_proc, 10);

813: --
814: per_rsc_bus.check_non_updateable_args
815: (p_rec => p_rec);
816: --
817: hr_utility.set_location (l_proc, 10);
818: --
819: -- Business Rule Mapping
820: -- =====================
821: -- Rule CHK_NAME a,b

Line 854: hr_utility.set_location (l_proc, 15);

850: --
851: per_rsc_bus.chk_df(p_rec => p_rec);
852: --
853: --
854: hr_utility.set_location (l_proc, 15);
855: --
856: hr_utility.set_location(' Leaving:'||l_proc, 20);
857: End update_validate;
858: --

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

852: --
853: --
854: hr_utility.set_location (l_proc, 15);
855: --
856: hr_utility.set_location(' Leaving:'||l_proc, 20);
857: End update_validate;
858: --
859: -- ----------------------------------------------------------------------------
860: -- |---------------------------< delete_validate >----------------------------|

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

863: --
864: l_proc varchar2(72) := g_package||'delete_validate';
865: --
866: Begin
867: hr_utility.set_location('Entering:'||l_proc, 5);
868: --
869: -- Call all supporting business operations
870: --
871: -- Validate delete

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

879: (p_rating_scale_id => p_rec.rating_scale_id
880: ,p_object_version_number => p_rec.object_version_number
881: );
882: --
883: hr_utility.set_location(' Leaving:'||l_proc, 10);
884: End delete_validate;
885: --
886: --
887: -- ----------------------------------------------------------------------------

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

904: l_legislation_code varchar2(150);
905: l_business_group_flag varchar2(1);
906: --
907: Begin
908: hr_utility.set_location('Entering:'||l_proc, 5);
909: --
910: -- Ensure that all the mandatory parameters are not null
911: --
912: hr_api.mandatory_arg_error (p_api_name => l_proc,

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

927: -- call to this function. Just return the value in the global
928: -- variable.
929: --
930: l_legislation_code := g_legislation_code;
931: hr_utility.set_location(l_proc, 20);
932: else
933: --
934: -- The ID is different to the last call to this function
935: -- or this is the first call to this function.

Line 944: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

940: close csr_leg_code;
941: --
942: -- The primary key is invalid therefore we must error out
943: --
944: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
945: hr_utility.raise_error;
946: end if;
947: --
948: close csr_leg_code;

Line 945: hr_utility.raise_error;

941: --
942: -- The primary key is invalid therefore we must error out
943: --
944: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
945: hr_utility.raise_error;
946: end if;
947: --
948: close csr_leg_code;
949: g_rating_scale_id:= p_rating_scale_id;

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

950: g_legislation_code := l_legislation_code;
951: end if;
952: return l_legislation_code;
953: --
954: hr_utility.set_location(' Leaving:'||l_proc, 10);
955: --
956: End return_legislation_code;
957: --
958: --