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_AST_BUS dependencies on HR_UTILITY

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

30: l_argument varchar2(30);
31: --
32: Begin
33: --
34: hr_utility.set_location('Entering:'|| l_proc,5);
35: --
36: -- Only proceed with validation if a row exists for
37: -- the current record in the HR Schema.
38: --

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

39: if not per_ast_shd.api_updating
40: (p_assessment_type_id => p_rec.assessment_type_id
41: ,p_object_version_number => p_rec.object_version_number
42: ) then
43: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP', '5');
46: end if;
47: --

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

40: (p_assessment_type_id => p_rec.assessment_type_id
41: ,p_object_version_number => p_rec.object_version_number
42: ) then
43: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP', '5');
46: end if;
47: --
48: hr_utility.set_location (l_proc, 6);

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

41: ,p_object_version_number => p_rec.object_version_number
42: ) then
43: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP', '5');
46: end if;
47: --
48: hr_utility.set_location (l_proc, 6);
49: --

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

44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP', '5');
46: end if;
47: --
48: hr_utility.set_location (l_proc, 6);
49: --
50: if p_rec.business_group_id <> per_ast_shd.g_old_rec.business_group_id then
51: l_argument := 'business_group_id';
52: raise l_error;

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

51: l_argument := 'business_group_id';
52: raise l_error;
53: end if;
54: --
55: hr_utility.set_location(l_proc, 7);
56: --
57: --
58: exception
59: when l_error then

Line 65: hr_utility.set_location(' Leaving : '|| l_proc, 9);

61: (p_api_name => l_proc
62: ,p_argument => l_argument);
63: when others then
64: raise;
65: hr_utility.set_location(' Leaving : '|| l_proc, 9);
66: end chk_non_updateable_args;
67: -- ----------------------------------------------------------------------------
68: -- |-------------------------------< chk_name >-------------------------------|
69: -- ----------------------------------------------------------------------------

Line 119: hr_utility.trace('chk_name := '||p_name);

115:
116: begin
117: -- Bug#885806
118: -- dbms_output.put_line('chk_name := '||p_name);
119: hr_utility.trace('chk_name := '||p_name);
120: hr_utility.set_location('Entering:'|| l_proc, 1);
121: --
122: -- Check that the business_group_id is not null.
123: --

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

116: begin
117: -- Bug#885806
118: -- dbms_output.put_line('chk_name := '||p_name);
119: hr_utility.trace('chk_name := '||p_name);
120: hr_utility.set_location('Entering:'|| l_proc, 1);
121: --
122: -- Check that the business_group_id is not null.
123: --
124:

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

131: (p_assessment_type_id => p_assessment_type_id
132: ,p_object_version_number => p_object_version_number
133: );
134: --
135: hr_utility.set_location (l_proc, 2);
136: --
137: if (l_api_updating AND
138: nvl(per_ast_shd.g_old_rec.name, hr_api.g_varchar2)
139: <> nvl(p_name, hr_api.g_varchar2)

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

139: <> nvl(p_name, hr_api.g_varchar2)
140: or not l_api_updating)
141: then
142: --
143: hr_utility.set_location (l_proc, 3);
144: --
145: -- Check that the name isn't NULL
146: --
147: if p_name is NULL then

Line 148: hr_utility.set_message(801,'HR_51498_AST_NAME_NULL');

144: --
145: -- Check that the name isn't NULL
146: --
147: if p_name is NULL then
148: hr_utility.set_message(801,'HR_51498_AST_NAME_NULL');
149: hr_utility.raise_error;
150: end if;
151: --
152: -- Check that the name is unique within the business group.

Line 149: hr_utility.raise_error;

145: -- Check that the name isn't NULL
146: --
147: if p_name is NULL then
148: hr_utility.set_message(801,'HR_51498_AST_NAME_NULL');
149: hr_utility.raise_error;
150: end if;
151: --
152: -- Check that the name is unique within the business group.
153: --

Line 161: hr_utility.set_message(800,'HR_AST_NAME_IN_GLOB');

157: -- The name already exists in the business group
158: close csr_name;
159: if l_exists is null then
160: if nvl(p_type,'COMPETENCE')='COMPETENCE' then
161: hr_utility.set_message(800,'HR_AST_NAME_IN_GLOB');
162: hr_utility.raise_error;
163: else
164: hr_utility.set_message(800,'HR_OBJ_NAME_IN_GLOB');
165: hr_utility.raise_error;

Line 162: hr_utility.raise_error;

158: close csr_name;
159: if l_exists is null then
160: if nvl(p_type,'COMPETENCE')='COMPETENCE' then
161: hr_utility.set_message(800,'HR_AST_NAME_IN_GLOB');
162: hr_utility.raise_error;
163: else
164: hr_utility.set_message(800,'HR_OBJ_NAME_IN_GLOB');
165: hr_utility.raise_error;
166: end if;

Line 164: hr_utility.set_message(800,'HR_OBJ_NAME_IN_GLOB');

160: if nvl(p_type,'COMPETENCE')='COMPETENCE' then
161: hr_utility.set_message(800,'HR_AST_NAME_IN_GLOB');
162: hr_utility.raise_error;
163: else
164: hr_utility.set_message(800,'HR_OBJ_NAME_IN_GLOB');
165: hr_utility.raise_error;
166: end if;
167: else
168: if nvl(p_type,'COMPETENCE')='COMPETENCE' then

Line 165: hr_utility.raise_error;

161: hr_utility.set_message(800,'HR_AST_NAME_IN_GLOB');
162: hr_utility.raise_error;
163: else
164: hr_utility.set_message(800,'HR_OBJ_NAME_IN_GLOB');
165: hr_utility.raise_error;
166: end if;
167: else
168: if nvl(p_type,'COMPETENCE')='COMPETENCE' then
169: hr_utility.set_message(800,'HR_51499_AST_NAME_NOT_UNIQ');

Line 169: hr_utility.set_message(800,'HR_51499_AST_NAME_NOT_UNIQ');

165: hr_utility.raise_error;
166: end if;
167: else
168: if nvl(p_type,'COMPETENCE')='COMPETENCE' then
169: hr_utility.set_message(800,'HR_51499_AST_NAME_NOT_UNIQ');
170: hr_utility.raise_error;
171: else
172: hr_utility.set_message(800,'HR_51499_OBJ_NAME_NOT_UNIQ');
173: hr_utility.raise_error;

Line 170: hr_utility.raise_error;

166: end if;
167: else
168: if nvl(p_type,'COMPETENCE')='COMPETENCE' then
169: hr_utility.set_message(800,'HR_51499_AST_NAME_NOT_UNIQ');
170: hr_utility.raise_error;
171: else
172: hr_utility.set_message(800,'HR_51499_OBJ_NAME_NOT_UNIQ');
173: hr_utility.raise_error;
174: end if;

Line 172: hr_utility.set_message(800,'HR_51499_OBJ_NAME_NOT_UNIQ');

168: if nvl(p_type,'COMPETENCE')='COMPETENCE' then
169: hr_utility.set_message(800,'HR_51499_AST_NAME_NOT_UNIQ');
170: hr_utility.raise_error;
171: else
172: hr_utility.set_message(800,'HR_51499_OBJ_NAME_NOT_UNIQ');
173: hr_utility.raise_error;
174: end if;
175: end if;
176: end if;

Line 173: hr_utility.raise_error;

169: hr_utility.set_message(800,'HR_51499_AST_NAME_NOT_UNIQ');
170: hr_utility.raise_error;
171: else
172: hr_utility.set_message(800,'HR_51499_OBJ_NAME_NOT_UNIQ');
173: hr_utility.raise_error;
174: end if;
175: end if;
176: end if;
177: --

Line 178: hr_utility.set_location(' Leaving:' || l_proc,2);

174: end if;
175: end if;
176: end if;
177: --
178: hr_utility.set_location(' Leaving:' || l_proc,2);
179: --
180: close csr_name;
181: --
182: end if;

Line 222: hr_utility.trace('Inside the chk_display_assessment_comments procedure');

218: --
219: begin
220: -- Bug#885806
221: -- dbms_output.put_line('Inside the chk_display_assessment_comments procedure');
222: hr_utility.trace('Inside the chk_display_assessment_comments procedure');
223: hr_utility.set_location('Entering:'|| l_proc, 1);
224: --
225: -- Check mandatory parameters have been set
226: --

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

219: begin
220: -- Bug#885806
221: -- dbms_output.put_line('Inside the chk_display_assessment_comments procedure');
222: hr_utility.trace('Inside the chk_display_assessment_comments procedure');
223: hr_utility.set_location('Entering:'|| l_proc, 1);
224: --
225: -- Check mandatory parameters have been set
226: --
227: hr_api.mandatory_arg_error

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

245: <> nvl(p_display_assessment_comments, hr_api.g_varchar2))
246: or
247: (NOT l_api_updating)) then
248: --
249: hr_utility.set_location(l_proc, 2);
250: --
251: -- Check the value in p_display_assessment_comments exists in hr_lookups
252: --
253: if hr_api.not_exists_in_hr_lookups

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

254: (p_effective_date => p_effective_date
255: ,p_lookup_type => 'YES_NO'
256: ,p_lookup_code => p_display_assessment_comments
257: ) then
258: hr_utility.set_location(l_proc, 10);
259: hr_utility.set_message(801,'HR_51500_AST_COMS_DISP_INVAL');
260: hr_utility.raise_error;
261: end if;
262: --

Line 259: hr_utility.set_message(801,'HR_51500_AST_COMS_DISP_INVAL');

255: ,p_lookup_type => 'YES_NO'
256: ,p_lookup_code => p_display_assessment_comments
257: ) then
258: hr_utility.set_location(l_proc, 10);
259: hr_utility.set_message(801,'HR_51500_AST_COMS_DISP_INVAL');
260: hr_utility.raise_error;
261: end if;
262: --
263: hr_utility.set_location(' Leaving:'|| l_proc, 15);

Line 260: hr_utility.raise_error;

256: ,p_lookup_code => p_display_assessment_comments
257: ) then
258: hr_utility.set_location(l_proc, 10);
259: hr_utility.set_message(801,'HR_51500_AST_COMS_DISP_INVAL');
260: hr_utility.raise_error;
261: end if;
262: --
263: hr_utility.set_location(' Leaving:'|| l_proc, 15);
264: end if;

Line 263: hr_utility.set_location(' Leaving:'|| l_proc, 15);

259: hr_utility.set_message(801,'HR_51500_AST_COMS_DISP_INVAL');
260: hr_utility.raise_error;
261: end if;
262: --
263: hr_utility.set_location(' Leaving:'|| l_proc, 15);
264: end if;
265: end chk_disp_assess_comments;
266: --
267: -- ----------------------------------------------------------------------------

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

318: l_min_assessment_date per_assessments.assessment_date%TYPE;
319: l_max_assessment_date per_assessments.assessment_date%TYPE;
320: --
321: begin
322: hr_utility.set_location('Entering:'|| l_proc, 1);
323: --
324: --
325: -- Only proceed with the validation if :
326: -- a) The current g_old_rec is current.

Line 352: hr_utility.set_message(801,'HR_51859_AST_DATE_FROM_DATE_TO');

348: --
349: if ((p_date_from is not null) and (p_date_to is not null)
350: and (p_date_from > p_date_to)) then
351: --
352: hr_utility.set_message(801,'HR_51859_AST_DATE_FROM_DATE_TO');
353: hr_utility.raise_error;
354: --
355: end if;
356: --

Line 353: hr_utility.raise_error;

349: if ((p_date_from is not null) and (p_date_to is not null)
350: and (p_date_from > p_date_to)) then
351: --
352: hr_utility.set_message(801,'HR_51859_AST_DATE_FROM_DATE_TO');
353: hr_utility.raise_error;
354: --
355: end if;
356: --
357: -- Make sure that any assessments using this assesment_type aren't

Line 369: hr_utility.set_message(801,'HR_51860_AST_DATE_OUT_RANGE1');

365: and ( l_max_assessment_date > p_date_to)) then
366: --
367: -- Assessment exists which were created later than the type, so error
368: --
369: hr_utility.set_message(801,'HR_51860_AST_DATE_OUT_RANGE1');
370: hr_utility.raise_error;
371: --
372: end if;
373: --

Line 370: hr_utility.raise_error;

366: --
367: -- Assessment exists which were created later than the type, so error
368: --
369: hr_utility.set_message(801,'HR_51860_AST_DATE_OUT_RANGE1');
370: hr_utility.raise_error;
371: --
372: end if;
373: --
374: if ((p_date_from is not null) and (l_min_assessment_date is not null)

Line 379: hr_utility.set_message(801,'HR_51861_AST_DATE_OUT_RANGE2');

375: and (l_min_assessment_date < p_date_from)) then
376: --
377: -- Assessment(s) exists which were created before the type, so error
378: --
379: hr_utility.set_message(801,'HR_51861_AST_DATE_OUT_RANGE2');
380: hr_utility.raise_error;
381: --
382: end if;
383: --

Line 380: hr_utility.raise_error;

376: --
377: -- Assessment(s) exists which were created before the type, so error
378: --
379: hr_utility.set_message(801,'HR_51861_AST_DATE_OUT_RANGE2');
380: hr_utility.raise_error;
381: --
382: end if;
383: --
384: end if;

Line 386: hr_utility.set_location(' Leaving:'|| l_proc, 15);

382: end if;
383: --
384: end if;
385: --
386: hr_utility.set_location(' Leaving:'|| l_proc, 15);
387: --
388: end chk_date_from_to;
389: --
390: -- ----------------------------------------------------------------------------

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

437: l_api_updating boolean;
438: --
439: begin
440: --
441: hr_utility.set_location('Entering:'|| l_proc, 1);
442: --
443: -- Check mandatory parameters have been set
444: --
445: hr_api.mandatory_arg_error

Line 453: hr_utility.trace('About to check the assessment_classification');

449: );
450: --
451: -- Bug#885806
452: -- dbms_output.put_line('About to check the assessment_classification');
453: hr_utility.trace('About to check the assessment_classification');
454: --
455: -- If record is being updated, and the assessment_classification is being
456: -- changed check to see whether the assessment_type is being used or not by an
457: -- assessment. If it is, then the assessment_classification cannot be

Line 474: hr_utility.trace('The assessment_classification is being updated');

470: --
471: -- Assessment Classification is being updated
472: -- Bug#885806
473: -- dbms_output.put_line('The assessment_classification is being updated');
474: hr_utility.trace('The assessment_classification is being updated');
475: --
476: open csr_assessment_type_usage;
477: fetch csr_assessment_type_usage into l_exists;
478: if csr_assessment_type_usage%found then

Line 483: hr_utility.set_message(801,'HR_51578_AST_USED_NO_UP_AS_CL');

479: --
480: -- The assessment_type is being used so the asssessment_classification
481: -- can't be updated
482: --
483: hr_utility.set_message(801,'HR_51578_AST_USED_NO_UP_AS_CL');
484: hr_utility.raise_error;
485: end if;
486: end if;
487: --

Line 484: hr_utility.raise_error;

480: -- The assessment_type is being used so the asssessment_classification
481: -- can't be updated
482: --
483: hr_utility.set_message(801,'HR_51578_AST_USED_NO_UP_AS_CL');
484: hr_utility.raise_error;
485: end if;
486: end if;
487: --
488: --

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

493: (p_effective_date => p_effective_date
494: ,p_lookup_type => 'ASSESSMENT_CLASSIFICATION'
495: ,p_lookup_code => p_assessment_classification
496: ) then
497: hr_utility.set_location(l_proc, 10);
498: hr_utility.set_message(801,'HR_51502_AST_ASS_CLASS_INVAL');
499: hr_utility.raise_error;
500: end if;
501: end if;

Line 498: hr_utility.set_message(801,'HR_51502_AST_ASS_CLASS_INVAL');

494: ,p_lookup_type => 'ASSESSMENT_CLASSIFICATION'
495: ,p_lookup_code => p_assessment_classification
496: ) then
497: hr_utility.set_location(l_proc, 10);
498: hr_utility.set_message(801,'HR_51502_AST_ASS_CLASS_INVAL');
499: hr_utility.raise_error;
500: end if;
501: end if;
502: --

Line 499: hr_utility.raise_error;

495: ,p_lookup_code => p_assessment_classification
496: ) then
497: hr_utility.set_location(l_proc, 10);
498: hr_utility.set_message(801,'HR_51502_AST_ASS_CLASS_INVAL');
499: hr_utility.raise_error;
500: end if;
501: end if;
502: --
503: hr_utility.set_location(' Leaving:'|| l_proc, 15);

Line 503: hr_utility.set_location(' Leaving:'|| l_proc, 15);

499: hr_utility.raise_error;
500: end if;
501: end if;
502: --
503: hr_utility.set_location(' Leaving:'|| l_proc, 15);
504: end chk_assessment_classification;
505: --
506: --
507: -- |---------------------------------------------------------------------------

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

569: l_proc varchar2(72):=g_package||'chk_weighting_scale_id';
570: l_csr_not_found boolean := FALSE;
571: --
572: begin
573: hr_utility.set_location('Entering:'||l_proc,1);
574:
575: -- Check that the assessment_classification is not NULL
576: --
577: hr_api.mandatory_arg_error

Line 607: hr_utility.set_message(801,'HR_51577_AST_USED_NO_UP_WE');

603: if csr_assessment_type_usage%found then
604: --
605: -- The assessment_type being used so the weighting_scale can't be updated
606: --
607: hr_utility.set_message(801,'HR_51577_AST_USED_NO_UP_WE');
608: hr_utility.raise_error;
609: end if;
610: end if;
611: --

Line 608: hr_utility.raise_error;

604: --
605: -- The assessment_type being used so the weighting_scale can't be updated
606: --
607: hr_utility.set_message(801,'HR_51577_AST_USED_NO_UP_WE');
608: hr_utility.raise_error;
609: end if;
610: end if;
611: --
612: -- Check if a value for weighting_scale_id exists(as it can be NULL)

Line 615: hr_utility.trace('About to check if the weighting_scale_id exists');

611: --
612: -- Check if a value for weighting_scale_id exists(as it can be NULL)
613: -- Bug#885806
614: -- dbms_output.put_line('About to check if the weighting_scale_id exists');
615: hr_utility.trace('About to check if the weighting_scale_id exists');
616: --
617: if p_weighting_scale_id is not null then
618: --
619: -- Bug#885806

Line 621: hr_utility.trace('It exists');

617: if p_weighting_scale_id is not null then
618: --
619: -- Bug#885806
620: -- dbms_output.put_line('It exists');
621: hr_utility.trace('It exists');
622: hr_utility.set_location (l_proc,10);
623: open csr_weighting_scale_id;
624: fetch csr_weighting_scale_id into l_type,l_business_group_id;
625: --

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

618: --
619: -- Bug#885806
620: -- dbms_output.put_line('It exists');
621: hr_utility.trace('It exists');
622: hr_utility.set_location (l_proc,10);
623: open csr_weighting_scale_id;
624: fetch csr_weighting_scale_id into l_type,l_business_group_id;
625: --
626: --

Line 638: hr_utility.trace('and weighting_scale_id doesnt exist in other tab');

634: --
635: if l_csr_not_found = TRUE then
636: -- Bug#885806
637: -- dbms_output.put_line('and weighting_scale_id doesnt exist in other tab');
638: hr_utility.trace('and weighting_scale_id doesnt exist in other tab');
639: hr_utility.set_location(l_proc,20);
640: per_ast_shd.constraint_error
641: (p_constraint_name => 'PER_ASSESSMENT_TYPES_FK3');
642: --

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

635: if l_csr_not_found = TRUE then
636: -- Bug#885806
637: -- dbms_output.put_line('and weighting_scale_id doesnt exist in other tab');
638: hr_utility.trace('and weighting_scale_id doesnt exist in other tab');
639: hr_utility.set_location(l_proc,20);
640: per_ast_shd.constraint_error
641: (p_constraint_name => 'PER_ASSESSMENT_TYPES_FK3');
642: --
643: --

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

645: -- ie. if the type of the weighing_scale in per_rating_scales is not equal
646: -- to 'WEIGHTING' then error.
647: --
648: elsif l_type <> 'WEIGHTING' then
649: hr_utility.set_location(l_proc,30);
650: --
651: -- The same error that is displayed when the value doesn't exist in the
652: -- table per_rating_scales can be used again, because as far as the api
653: -- is concerned the value doesn't exist even if it does but is of a

Line 693: hr_utility.trace('AST_weighting_scale_comment = '||p_weighting_scale_comment);

689: l_proc varchar2(72):=g_package||'chk_weighting_scale_comment';
690: begin
691: -- Bug#885806
692: -- dbms_output.put_line('AST_weighting_scale_comment = '||p_weighting_scale_comment);
693: hr_utility.trace('AST_weighting_scale_comment = '||p_weighting_scale_comment);
694:
695: hr_utility.set_location(l_proc, 1);
696: --
697: -- If p_weighting_scale_id is NULL but p_weighting_scale_comment isn't, error.

Line 695: hr_utility.set_location(l_proc, 1);

691: -- Bug#885806
692: -- dbms_output.put_line('AST_weighting_scale_comment = '||p_weighting_scale_comment);
693: hr_utility.trace('AST_weighting_scale_comment = '||p_weighting_scale_comment);
694:
695: hr_utility.set_location(l_proc, 1);
696: --
697: -- If p_weighting_scale_id is NULL but p_weighting_scale_comment isn't, error.
698: --
699: if ((p_weighting_scale_id is NULL) and

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

700: (p_weighting_scale_comment is not NULL)) then
701: --
702: -- comments exists without a weighting scale.
703: --
704: hr_utility.set_location(l_proc, 10);
705: hr_utility.set_message(801,'HR_51505_AST_W_ID_COMS_NOTNUL');
706: hr_utility.raise_error;
707: end if;
708: end chk_weighting_scale_comment;

Line 705: hr_utility.set_message(801,'HR_51505_AST_W_ID_COMS_NOTNUL');

701: --
702: -- comments exists without a weighting scale.
703: --
704: hr_utility.set_location(l_proc, 10);
705: hr_utility.set_message(801,'HR_51505_AST_W_ID_COMS_NOTNUL');
706: hr_utility.raise_error;
707: end if;
708: end chk_weighting_scale_comment;
709: -- ----------------------------------------------------------------------------

Line 706: hr_utility.raise_error;

702: -- comments exists without a weighting scale.
703: --
704: hr_utility.set_location(l_proc, 10);
705: hr_utility.set_message(801,'HR_51505_AST_W_ID_COMS_NOTNUL');
706: hr_utility.raise_error;
707: end if;
708: end chk_weighting_scale_comment;
709: -- ----------------------------------------------------------------------------
710: -- |---------------------------< chk_rating_scale_id >------------------------|

Line 773: hr_utility.trace('AST_rating_scale_id = '||p_rating_scale_id);

769: --
770: begin
771: -- Bug#885806
772: -- dbms_output.put_line('AST_rating_scale_id = '||p_rating_scale_id);
773: hr_utility.trace('AST_rating_scale_id = '||p_rating_scale_id);
774: hr_utility.set_location('Entering:'|| l_proc, 1);
775: --
776:
777: -- Check that assessment_classification is not null.

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

770: begin
771: -- Bug#885806
772: -- dbms_output.put_line('AST_rating_scale_id = '||p_rating_scale_id);
773: hr_utility.trace('AST_rating_scale_id = '||p_rating_scale_id);
774: hr_utility.set_location('Entering:'|| l_proc, 1);
775: --
776:
777: -- Check that assessment_classification is not null.
778: --

Line 809: hr_utility.set_message(801,'HR_51576_AST_USED_NO_UP_RA');

805: if csr_assessment_type_usage%found then
806: --
807: -- The assessment_type is being used so the rating_scale can't be updated
808: --
809: hr_utility.set_message(801,'HR_51576_AST_USED_NO_UP_RA');
810: hr_utility.raise_error;
811: end if;
812: end if;
813:

Line 810: hr_utility.raise_error;

806: --
807: -- The assessment_type is being used so the rating_scale can't be updated
808: --
809: hr_utility.set_message(801,'HR_51576_AST_USED_NO_UP_RA');
810: hr_utility.raise_error;
811: end if;
812: end if;
813:
814: --

Line 819: hr_utility.trace('chk_rating_scale_id:Rating scale ID isnt NULL');

815:
816: if (p_rating_scale_id IS NOT NULL) then
817: -- Bug#885806
818: --dbms_output.put_line('chk_rating_scale_id:Rating scale ID isnt NULL');
819: hr_utility.trace('chk_rating_scale_id:Rating scale ID isnt NULL');
820: hr_utility.set_location(l_proc,5);
821: --
822: -- If rating_scale_id is NOT NULL, assessment_classification must be
823: -- either PERFORMANCE or BOTH, otherwise raise an error.

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

816: if (p_rating_scale_id IS NOT NULL) then
817: -- Bug#885806
818: --dbms_output.put_line('chk_rating_scale_id:Rating scale ID isnt NULL');
819: hr_utility.trace('chk_rating_scale_id:Rating scale ID isnt NULL');
820: hr_utility.set_location(l_proc,5);
821: --
822: -- If rating_scale_id is NOT NULL, assessment_classification must be
823: -- either PERFORMANCE or BOTH, otherwise raise an error.
824: --

Line 828: hr_utility.trace('chk_rating_scale_id:AssessClass not in Per or Bo or FF');

824: --
825: if p_assessment_classification not in ('PERFORMANCE','BOTH','FASTFORMULA') then
826: -- Bug#885806
827: -- dbms_output.put_line('chk_rating_scale_id:AssessClass not in Per or Bo');
828: hr_utility.trace('chk_rating_scale_id:AssessClass not in Per or Bo or FF');
829: hr_utility.set_location(l_proc,10);
830: per_ast_shd.constraint_error
831: (p_constraint_name => 'PER_ASS_TYPES_RATE_NOTNULL_CHK');
832: --

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

825: if p_assessment_classification not in ('PERFORMANCE','BOTH','FASTFORMULA') then
826: -- Bug#885806
827: -- dbms_output.put_line('chk_rating_scale_id:AssessClass not in Per or Bo');
828: hr_utility.trace('chk_rating_scale_id:AssessClass not in Per or Bo or FF');
829: hr_utility.set_location(l_proc,10);
830: per_ast_shd.constraint_error
831: (p_constraint_name => 'PER_ASS_TYPES_RATE_NOTNULL_CHK');
832: --
833: end if;

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

831: (p_constraint_name => 'PER_ASS_TYPES_RATE_NOTNULL_CHK');
832: --
833: end if;
834: --
835: hr_utility.set_location(l_proc, 15);
836: open csr_rating_scale_id ;
837: fetch csr_rating_scale_id into l_type;
838: --
839: -- Check if the rating_scale_id exists.

Line 852: hr_utility.trace('chk_rating_scale_id:Rating scale not found');

848: --
849: if l_csr_not_found = TRUE then
850: -- Bug#885806
851: -- dbms_output.put_line('chk_rating_scale_id:Rating scale not found');
852: hr_utility.trace('chk_rating_scale_id:Rating scale not found');
853: hr_utility.set_location(l_proc,20);
854: per_ast_shd.constraint_error
855: (p_constraint_name => 'PER_ASSESSMENT_TYPES_FK2');
856: --

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

849: if l_csr_not_found = TRUE then
850: -- Bug#885806
851: -- dbms_output.put_line('chk_rating_scale_id:Rating scale not found');
852: hr_utility.trace('chk_rating_scale_id:Rating scale not found');
853: hr_utility.set_location(l_proc,20);
854: per_ast_shd.constraint_error
855: (p_constraint_name => 'PER_ASSESSMENT_TYPES_FK2');
856: --
857: -- Check if the rating_scale_id is of the wrong type.

Line 864: hr_utility.trace('chk_rating_scale_id:Rating scale found, type diff');

860: --
861: elsif l_type <> 'PERFORMANCE' then
862: -- Bug#885806
863: --dbms_output.put_line('chk_rating_scale_id:Rating scale found, type diff');
864: hr_utility.trace('chk_rating_scale_id:Rating scale found, type diff');
865: -- dbms_output.put_line('AST_rating_scale_type = '||l_type);
866: hr_utility.trace('AST_rating_scale_type = '||l_type);
867: --
868: hr_utility.set_location(l_proc,30);

Line 866: hr_utility.trace('AST_rating_scale_type = '||l_type);

862: -- Bug#885806
863: --dbms_output.put_line('chk_rating_scale_id:Rating scale found, type diff');
864: hr_utility.trace('chk_rating_scale_id:Rating scale found, type diff');
865: -- dbms_output.put_line('AST_rating_scale_type = '||l_type);
866: hr_utility.trace('AST_rating_scale_type = '||l_type);
867: --
868: hr_utility.set_location(l_proc,30);
869: --
870: -- The same error message that gets used when the value can be found

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

864: hr_utility.trace('chk_rating_scale_id:Rating scale found, type diff');
865: -- dbms_output.put_line('AST_rating_scale_type = '||l_type);
866: hr_utility.trace('AST_rating_scale_type = '||l_type);
867: --
868: hr_utility.set_location(l_proc,30);
869: --
870: -- The same error message that gets used when the value can be found
871: -- in the table per_rating_scales can be used here as even thought the
872: -- value entered exists it is of the wrong type therefore it may as well

Line 888: hr_utility.trace('chk_rating_scale_id:Rating scale ID is NULL. assessment classif is '||p_assessment_classification);

884: --
885: elsif (p_assessment_classification <> 'PROFICIENCY') then
886: -- Bug#885806
887: --dbms_output.put_line('chk_rating_scale_id:Rating scale NULL, type not Pro');
888: hr_utility.trace('chk_rating_scale_id:Rating scale ID is NULL. assessment classif is '||p_assessment_classification);
889: if((p_assessment_classification <> 'FASTFORMULA')) then
890: hr_utility.trace('chk_rating_scale_id:Rating scale NULL, type not FastFormula');
891:
892:

Line 890: hr_utility.trace('chk_rating_scale_id:Rating scale NULL, type not FastFormula');

886: -- Bug#885806
887: --dbms_output.put_line('chk_rating_scale_id:Rating scale NULL, type not Pro');
888: hr_utility.trace('chk_rating_scale_id:Rating scale ID is NULL. assessment classif is '||p_assessment_classification);
889: if((p_assessment_classification <> 'FASTFORMULA')) then
890: hr_utility.trace('chk_rating_scale_id:Rating scale NULL, type not FastFormula');
891:
892:
893: per_ast_shd.constraint_error
894: (p_constraint_name => 'PER_ASS_TYPES_RATE_NULL_CHK');

Line 924: hr_utility.set_location(l_proc, 1);

920: )
921: is
922: l_proc varchar2(72):=g_package||'chk_rating_scale_comment';
923: begin
924: hr_utility.set_location(l_proc, 1);
925: --
926: -- If p_rating_scale_id is NULL but p_rating_scale_comment isn't, error.
927: --
928: if ((p_rating_scale_id is NULL) and

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

929: (p_rating_scale_comment is not NULL)) then
930: --
931: -- comments exists without a rating scale.
932: --
933: hr_utility.set_location(l_proc, 10);
934: hr_utility.set_message(801,'HR_51509_AST_R_ID_COMS_NOTNUL');
935: end if;
936: end chk_rating_scale_comment;
937: -- ----------------------------------------------------------------------------

Line 934: hr_utility.set_message(801,'HR_51509_AST_R_ID_COMS_NOTNUL');

930: --
931: -- comments exists without a rating scale.
932: --
933: hr_utility.set_location(l_proc, 10);
934: hr_utility.set_message(801,'HR_51509_AST_R_ID_COMS_NOTNUL');
935: end if;
936: end chk_rating_scale_comment;
937: -- ----------------------------------------------------------------------------
938: -- |--------------------< chk_weighting_classification >----------------------|

Line 974: hr_utility.trace('AST_weighting_classification = '||p_weighting_classification);

970: --
971: begin
972: -- Bug#885806
973: -- dbms_output.put_line('AST_weighting_classification = '||p_weighting_classification);
974: hr_utility.trace('AST_weighting_classification = '||p_weighting_classification);
975:
976: hr_utility.set_location('Entering:'||l_proc,5);
977: --
978: -- Check assessment_classification is not null

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

972: -- Bug#885806
973: -- dbms_output.put_line('AST_weighting_classification = '||p_weighting_classification);
974: hr_utility.trace('AST_weighting_classification = '||p_weighting_classification);
975:
976: hr_utility.set_location('Entering:'||l_proc,5);
977: --
978: -- Check assessment_classification is not null
979: --
980: hr_api.mandatory_arg_error

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

986: -- Weighting_classification is MANDATORY if weighting_scale_id is NOT NULL.
987: --
988: if ((p_weighting_scale_id IS NOT NULL) and
989: (p_weighting_classification IS NULL and p_weighting_classification <> 'FASTFORMULA')) then
990: hr_utility.set_location(l_proc,10);
991: hr_utility.set_message(801,'HR_51510_AST_WEIG_CLAS_NULL');
992: hr_utility.raise_error;
993: end if;
994: --

Line 991: hr_utility.set_message(801,'HR_51510_AST_WEIG_CLAS_NULL');

987: --
988: if ((p_weighting_scale_id IS NOT NULL) and
989: (p_weighting_classification IS NULL and p_weighting_classification <> 'FASTFORMULA')) then
990: hr_utility.set_location(l_proc,10);
991: hr_utility.set_message(801,'HR_51510_AST_WEIG_CLAS_NULL');
992: hr_utility.raise_error;
993: end if;
994: --
995: -- The weighting_classification should be NULL if weighting_scale_id is NULL.

Line 992: hr_utility.raise_error;

988: if ((p_weighting_scale_id IS NOT NULL) and
989: (p_weighting_classification IS NULL and p_weighting_classification <> 'FASTFORMULA')) then
990: hr_utility.set_location(l_proc,10);
991: hr_utility.set_message(801,'HR_51510_AST_WEIG_CLAS_NULL');
992: hr_utility.raise_error;
993: end if;
994: --
995: -- The weighting_classification should be NULL if weighting_scale_id is NULL.
996: --

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

995: -- The weighting_classification should be NULL if weighting_scale_id is NULL.
996: --
997: if ((p_weighting_scale_id IS NULL) and
998: (p_weighting_classification IS NOT NULL and p_weighting_classification <> 'FASTFORMULA' )) then
999: hr_utility.set_location(l_proc,20);
1000: hr_utility.set_message(801,'HR_51512_AST_WEIG_ID_NULL');
1001: hr_utility.raise_error;
1002: end if;
1003: --

Line 1000: hr_utility.set_message(801,'HR_51512_AST_WEIG_ID_NULL');

996: --
997: if ((p_weighting_scale_id IS NULL) and
998: (p_weighting_classification IS NOT NULL and p_weighting_classification <> 'FASTFORMULA' )) then
999: hr_utility.set_location(l_proc,20);
1000: hr_utility.set_message(801,'HR_51512_AST_WEIG_ID_NULL');
1001: hr_utility.raise_error;
1002: end if;
1003: --
1004: -- If this far, necessary values exist.

Line 1001: hr_utility.raise_error;

997: if ((p_weighting_scale_id IS NULL) and
998: (p_weighting_classification IS NOT NULL and p_weighting_classification <> 'FASTFORMULA' )) then
999: hr_utility.set_location(l_proc,20);
1000: hr_utility.set_message(801,'HR_51512_AST_WEIG_ID_NULL');
1001: hr_utility.raise_error;
1002: end if;
1003: --
1004: -- If this far, necessary values exist.
1005: -- Further checks only need to be performed if weighting_class. exists

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

1006: --
1007: if (p_weighting_classification IS NOT NULL) then
1008: --
1009: if (p_weighting_classification not in ('PERFORMANCE','PROFICIENCY','FASTFORMULA')) then
1010: hr_utility.set_location(l_proc,30);
1011: hr_utility.set_message(801,'HR_51513_AST_WEIG_CLAS_INVAL');
1012: hr_utility.raise_error;
1013: elsif ((p_assessment_classification <> 'BOTH') and
1014: (p_assessment_classification <> p_weighting_classification)) then

Line 1011: hr_utility.set_message(801,'HR_51513_AST_WEIG_CLAS_INVAL');

1007: if (p_weighting_classification IS NOT NULL) then
1008: --
1009: if (p_weighting_classification not in ('PERFORMANCE','PROFICIENCY','FASTFORMULA')) then
1010: hr_utility.set_location(l_proc,30);
1011: hr_utility.set_message(801,'HR_51513_AST_WEIG_CLAS_INVAL');
1012: hr_utility.raise_error;
1013: elsif ((p_assessment_classification <> 'BOTH') and
1014: (p_assessment_classification <> p_weighting_classification)) then
1015: --

Line 1012: hr_utility.raise_error;

1008: --
1009: if (p_weighting_classification not in ('PERFORMANCE','PROFICIENCY','FASTFORMULA')) then
1010: hr_utility.set_location(l_proc,30);
1011: hr_utility.set_message(801,'HR_51513_AST_WEIG_CLAS_INVAL');
1012: hr_utility.raise_error;
1013: elsif ((p_assessment_classification <> 'BOTH') and
1014: (p_assessment_classification <> p_weighting_classification)) then
1015: --
1016: -- At this stage, we know that the assessment_classification is valid

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

1018: -- is not = both, and the weighting classification isn't the same as
1019: -- the assessment_classification, then it must be valid but the wrong
1020: -- one. (ie. it's performance and should be proficiency or visa versa)
1021: --
1022: hr_utility.set_location(l_proc,30);
1023: hr_utility.set_message(801,'HR_51514_AST_WEIG_CLAS_INCOMP');
1024: hr_utility.raise_error;
1025: end if;
1026: end if;

Line 1023: hr_utility.set_message(801,'HR_51514_AST_WEIG_CLAS_INCOMP');

1019: -- the assessment_classification, then it must be valid but the wrong
1020: -- one. (ie. it's performance and should be proficiency or visa versa)
1021: --
1022: hr_utility.set_location(l_proc,30);
1023: hr_utility.set_message(801,'HR_51514_AST_WEIG_CLAS_INCOMP');
1024: hr_utility.raise_error;
1025: end if;
1026: end if;
1027: end chk_weighting_classification;

Line 1024: hr_utility.raise_error;

1020: -- one. (ie. it's performance and should be proficiency or visa versa)
1021: --
1022: hr_utility.set_location(l_proc,30);
1023: hr_utility.set_message(801,'HR_51514_AST_WEIG_CLAS_INCOMP');
1024: hr_utility.raise_error;
1025: end if;
1026: end if;
1027: end chk_weighting_classification;
1028: -- ----------------------------------------------------------------------------

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

1054: --
1055: l_proc varchar2(72) := g_package||'chk_line_score_formula';
1056: --
1057: begin
1058: hr_utility.set_location('Entering:'||l_proc,1);
1059: --
1060: -- Check mandatory parameters have been set
1061: --
1062: hr_api.mandatory_arg_error

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

1071: (p_effective_date => p_effective_date
1072: ,p_lookup_type => 'ASSESSMENT_LINE_FORMULA'
1073: ,p_lookup_code => p_line_score_formula
1074: ) then
1075: hr_utility.set_location(l_proc,10);
1076: hr_utility.set_message(801,'HR_51515_AST_LINE_FORMU_INVAL');
1077: hr_utility.raise_error;
1078: end if;
1079: end if;

Line 1076: hr_utility.set_message(801,'HR_51515_AST_LINE_FORMU_INVAL');

1072: ,p_lookup_type => 'ASSESSMENT_LINE_FORMULA'
1073: ,p_lookup_code => p_line_score_formula
1074: ) then
1075: hr_utility.set_location(l_proc,10);
1076: hr_utility.set_message(801,'HR_51515_AST_LINE_FORMU_INVAL');
1077: hr_utility.raise_error;
1078: end if;
1079: end if;
1080: hr_utility.set_location('Leaving:'||l_proc,20);

Line 1077: hr_utility.raise_error;

1073: ,p_lookup_code => p_line_score_formula
1074: ) then
1075: hr_utility.set_location(l_proc,10);
1076: hr_utility.set_message(801,'HR_51515_AST_LINE_FORMU_INVAL');
1077: hr_utility.raise_error;
1078: end if;
1079: end if;
1080: hr_utility.set_location('Leaving:'||l_proc,20);
1081: end chk_line_score_formula;

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

1076: hr_utility.set_message(801,'HR_51515_AST_LINE_FORMU_INVAL');
1077: hr_utility.raise_error;
1078: end if;
1079: end if;
1080: hr_utility.set_location('Leaving:'||l_proc,20);
1081: end chk_line_score_formula;
1082: -- ----------------------------------------------------------------------------
1083: -- |-------------------< chk_total_score_formula >----------------------------|
1084: -- ----------------------------------------------------------------------------

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

1109: l_proc varchar2(72) := g_package||'chk_total_score_formula';
1110: l_api_updating boolean;
1111: --
1112: begin
1113: hr_utility.set_location('Entering:'||l_proc,1);
1114: --
1115: -- Check mandatory parameters have been set
1116: --
1117: hr_api.mandatory_arg_error

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

1143: (p_effective_date => p_effective_date
1144: ,p_lookup_type => 'ASSESSMENT_TOTAL_FORMULA'
1145: ,p_lookup_code => p_total_score_formula
1146: ) then
1147: hr_utility.set_location(l_proc,10);
1148: hr_utility.set_message(801,'HR_51516_AST_TOTA_FORMU_INVAL');
1149: hr_utility.raise_error;
1150: end if;
1151: end if;

Line 1148: hr_utility.set_message(801,'HR_51516_AST_TOTA_FORMU_INVAL');

1144: ,p_lookup_type => 'ASSESSMENT_TOTAL_FORMULA'
1145: ,p_lookup_code => p_total_score_formula
1146: ) then
1147: hr_utility.set_location(l_proc,10);
1148: hr_utility.set_message(801,'HR_51516_AST_TOTA_FORMU_INVAL');
1149: hr_utility.raise_error;
1150: end if;
1151: end if;
1152: end if;

Line 1149: hr_utility.raise_error;

1145: ,p_lookup_code => p_total_score_formula
1146: ) then
1147: hr_utility.set_location(l_proc,10);
1148: hr_utility.set_message(801,'HR_51516_AST_TOTA_FORMU_INVAL');
1149: hr_utility.raise_error;
1150: end if;
1151: end if;
1152: end if;
1153: --

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

1150: end if;
1151: end if;
1152: end if;
1153: --
1154: hr_utility.set_location('Leaving:'||l_proc,20);
1155: --
1156: -- Bug#885806
1157: -- dbms_output.put_line('AST_total score formula ');
1158: hr_utility.trace('AST_total score formula ');

Line 1158: hr_utility.trace('AST_total score formula ');

1154: hr_utility.set_location('Leaving:'||l_proc,20);
1155: --
1156: -- Bug#885806
1157: -- dbms_output.put_line('AST_total score formula ');
1158: hr_utility.trace('AST_total score formula ');
1159: end chk_total_score_formula;
1160:
1161: -- ----------------------------------------------------------------------------
1162: -- |-------------------< chk_type >----------------------------|

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

1188: l_proc varchar2(72) := g_package||'chk_type';
1189: l_api_updating boolean;
1190: --
1191: begin
1192: hr_utility.set_location('Entering:'||l_proc,1);
1193: --
1194: -- Check mandatory parameters have been set
1195: --
1196: hr_api.mandatory_arg_error

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

1222: (p_effective_date => p_effective_date
1223: ,p_lookup_type => 'ASSESSMENT_TYPE'
1224: ,p_lookup_code => p_type
1225: ) then
1226: hr_utility.set_location(l_proc,10);
1227: hr_utility.set_message(801,'HR_AST_INVALID_TYPE');
1228: hr_utility.raise_error;
1229: end if;
1230: end if;

Line 1227: hr_utility.set_message(801,'HR_AST_INVALID_TYPE');

1223: ,p_lookup_type => 'ASSESSMENT_TYPE'
1224: ,p_lookup_code => p_type
1225: ) then
1226: hr_utility.set_location(l_proc,10);
1227: hr_utility.set_message(801,'HR_AST_INVALID_TYPE');
1228: hr_utility.raise_error;
1229: end if;
1230: end if;
1231: end if;

Line 1228: hr_utility.raise_error;

1224: ,p_lookup_code => p_type
1225: ) then
1226: hr_utility.set_location(l_proc,10);
1227: hr_utility.set_message(801,'HR_AST_INVALID_TYPE');
1228: hr_utility.raise_error;
1229: end if;
1230: end if;
1231: end if;
1232:

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

1230: end if;
1231: end if;
1232:
1233: --
1234: hr_utility.set_location('Leaving:'||l_proc,20);
1235: --
1236: -- Bug#885806
1237: -- dbms_output.put_line('AST_total score formula ');
1238: hr_utility.trace('AST_type ');

Line 1238: hr_utility.trace('AST_type ');

1234: hr_utility.set_location('Leaving:'||l_proc,20);
1235: --
1236: -- Bug#885806
1237: -- dbms_output.put_line('AST_total score formula ');
1238: hr_utility.trace('AST_type ');
1239: end chk_type;
1240: -- ----------------------------------------------------------------------------
1241: -- |---------------------< chk_assessment_type_used >-------------------------|
1242: -- ----------------------------------------------------------------------------

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

1273: from per_assessments
1274: where assessment_type_id = p_assessment_type_id;
1275: --
1276: Begin
1277: hr_utility.set_location('Entering '||l_proc,1);
1278: --
1279: -- Check that assessment_type is not referenced by an assessment
1280: --
1281: open csr_assessment_type_usage;

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

1281: open csr_assessment_type_usage;
1282: fetch csr_assessment_type_usage into l_exists;
1283: if csr_assessment_type_usage%found then
1284: close csr_assessment_type_usage;
1285: hr_utility.set_location (l_proc, 5);
1286: hr_utility.set_message (801, 'HR_51579_AST_REF_BY_ASSESS');
1287: hr_utility.raise_error;
1288: end if;
1289: close csr_assessment_type_usage;

Line 1286: hr_utility.set_message (801, 'HR_51579_AST_REF_BY_ASSESS');

1282: fetch csr_assessment_type_usage into l_exists;
1283: if csr_assessment_type_usage%found then
1284: close csr_assessment_type_usage;
1285: hr_utility.set_location (l_proc, 5);
1286: hr_utility.set_message (801, 'HR_51579_AST_REF_BY_ASSESS');
1287: hr_utility.raise_error;
1288: end if;
1289: close csr_assessment_type_usage;
1290: --

Line 1287: hr_utility.raise_error;

1283: if csr_assessment_type_usage%found then
1284: close csr_assessment_type_usage;
1285: hr_utility.set_location (l_proc, 5);
1286: hr_utility.set_message (801, 'HR_51579_AST_REF_BY_ASSESS');
1287: hr_utility.raise_error;
1288: end if;
1289: close csr_assessment_type_usage;
1290: --
1291: end chk_assessment_type_used;

Line 1340: hr_utility.trace('Inside the chk_available_flag procedure');

1336: --
1337: begin
1338: -- Bug#885806
1339: -- dbms_output.put_line('Inside the chk_display_assessment_comments procedure');
1340: hr_utility.trace('Inside the chk_available_flag procedure');
1341: hr_utility.set_location('Entering:'|| l_proc, 1);
1342:
1343:
1344: --

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

1337: begin
1338: -- Bug#885806
1339: -- dbms_output.put_line('Inside the chk_display_assessment_comments procedure');
1340: hr_utility.trace('Inside the chk_available_flag procedure');
1341: hr_utility.set_location('Entering:'|| l_proc, 1);
1342:
1343:
1344: --
1345: -- Check mandatory parameters have been set

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

1365: <> nvl(p_available_flag, hr_api.g_varchar2))
1366: or
1367: (NOT l_api_updating)) then
1368: --
1369: hr_utility.set_location(l_proc, 5);
1370: --
1371: -- Check the value in p_available_flag exists in hr_lookups
1372: --
1373: if hr_api.not_exists_in_hr_lookups

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

1374: (p_effective_date => p_effective_date
1375: ,p_lookup_type => 'TEMPLATE_AVAILABILITY_FLAG'
1376: ,p_lookup_code => p_available_flag
1377: ) then
1378: hr_utility.set_location(l_proc, 10);
1379: hr_utility.set_message(800,'HR_AVAIL_FLAG_INVAL');
1380: hr_utility.raise_error;
1381: end if;
1382: --

Line 1379: hr_utility.set_message(800,'HR_AVAIL_FLAG_INVAL');

1375: ,p_lookup_type => 'TEMPLATE_AVAILABILITY_FLAG'
1376: ,p_lookup_code => p_available_flag
1377: ) then
1378: hr_utility.set_location(l_proc, 10);
1379: hr_utility.set_message(800,'HR_AVAIL_FLAG_INVAL');
1380: hr_utility.raise_error;
1381: end if;
1382: --
1383: hr_utility.set_location(' Leaving:'|| l_proc, 15);

Line 1380: hr_utility.raise_error;

1376: ,p_lookup_code => p_available_flag
1377: ) then
1378: hr_utility.set_location(l_proc, 10);
1379: hr_utility.set_message(800,'HR_AVAIL_FLAG_INVAL');
1380: hr_utility.raise_error;
1381: end if;
1382: --
1383: hr_utility.set_location(' Leaving:'|| l_proc, 15);
1384: end if;

Line 1383: hr_utility.set_location(' Leaving:'|| l_proc, 15);

1379: hr_utility.set_message(800,'HR_AVAIL_FLAG_INVAL');
1380: hr_utility.raise_error;
1381: end if;
1382: --
1383: hr_utility.set_location(' Leaving:'|| l_proc, 15);
1384: end if;
1385: end chk_available_flag;
1386: --
1387: --

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

1417: --
1418: l_proc varchar2(72) := g_package||'chk_df';
1419: --
1420: begin
1421: hr_utility.set_location('Entering:'||l_proc, 10);
1422: --
1423: if ((p_rec.assessment_type_id is not null) and (
1424: nvl(per_ast_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1425: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

1517: ,p_attribute20_value => p_rec.attribute20
1518: );
1519: end if;
1520: --
1521: hr_utility.set_location(' Leaving:'||l_proc, 20);
1522:
1523: end chk_df;
1524: --
1525: -- ----------------------------------------------------------------------------

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

1531: --
1532: l_proc varchar2(72) := g_package||'insert_validate';
1533: --
1534: Begin
1535: hr_utility.set_location('Entering:'||l_proc, 5);
1536: --
1537: -- Call all supporting business operations. Mapping to the appropiate
1538: -- Business Rules in perast.bru is provided.
1539: --

Line 1547: hr_utility.trace('AST_bus grp id = '||p_rec.business_group_id);

1543: -- Rule CHK_BUSINESS_GROUP_ID a
1544: --
1545: -- Bug#885806
1546: -- dbms_output.put_line('AST_bus grp id = '||p_rec.business_group_id);
1547: hr_utility.trace('AST_bus grp id = '||p_rec.business_group_id);
1548: --
1549: if p_rec.business_group_id is not null then
1550:
1551: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

Line 1554: hr_utility.set_location(' Location:'||l_proc, 10);

1550:
1551: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1552: end if;
1553: --
1554: hr_utility.set_location(' Location:'||l_proc, 10);
1555:
1556: --Validate available_flag
1557: -- rule Chk_Available_flag
1558: --

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

1588: ,p_business_group_id => p_rec.business_group_id
1589: ,p_object_version_number => p_rec.object_version_number
1590: );
1591: --
1592: hr_utility.set_location(l_proc, 15);
1593: --
1594: --
1595: -- VALIDATE DISPLAY_ASSESSMENT_COMMENTS
1596: -- Business Rule Mapping

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

1603: ,p_effective_date => p_effective_date
1604: ,p_object_version_number => p_rec.object_version_number
1605: );
1606: --
1607: hr_utility.set_location(l_proc,20);
1608: --
1609: --
1610: -- VALIDATE ACTIVE
1611: -- Business Rule Mapping

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

1620: ,p_object_version_number => p_rec.object_version_number
1621: );
1622: --
1623: --
1624: hr_utility.set_location (l_proc, 25);
1625: --
1626: -- Bug#885806
1627: -- dbms_output.put_line('About to validate assessment_classification');
1628: hr_utility.trace('About to validate assessment_classification');

Line 1628: hr_utility.trace('About to validate assessment_classification');

1624: hr_utility.set_location (l_proc, 25);
1625: --
1626: -- Bug#885806
1627: -- dbms_output.put_line('About to validate assessment_classification');
1628: hr_utility.trace('About to validate assessment_classification');
1629: --
1630: -- VALIDATE ASSESSMENT_CLASSIFICATION
1631: -- Business Rule Mapping
1632: -- =====================

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

1639: ,p_assessment_type_id => p_rec.assessment_type_id
1640: ,p_object_version_number => p_rec.object_version_number
1641: );
1642: --
1643: hr_utility.set_location (l_proc, 30);
1644: --
1645: --
1646: -- Bug#885806
1647: -- dbms_output.put_line('About to validate rating_scale_id');

Line 1648: hr_utility.trace('About to validate rating_scale_id');

1644: --
1645: --
1646: -- Bug#885806
1647: -- dbms_output.put_line('About to validate rating_scale_id');
1648: hr_utility.trace('About to validate rating_scale_id');
1649: --
1650: -- VALIDATE RATING_SCALE_ID
1651: -- Business Rule Mapping
1652: -- =====================

Line 1664: hr_utility.set_location (l_proc, 35);

1660: ,p_object_version_number => p_rec.object_version_number
1661: ,p_weighting_classification => p_rec.weighting_classification
1662: );
1663: --
1664: hr_utility.set_location (l_proc, 35);
1665: --
1666: --
1667: -- VALIDATE WEIGHTING_SCALE_ID
1668: -- Business Rule Mapping

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

1676: ,p_assessment_classification => p_rec.assessment_classification
1677: ,p_object_version_number => p_rec.object_version_number
1678: );
1679: --
1680: hr_utility.set_location (l_proc, 40);
1681: --
1682: --
1683: -- VALIDATE WEIGHTING_SCALE_COMMENT
1684: -- Business Rule Mapping

Line 1693: hr_utility.set_location (l_proc, 45);

1689: (p_weighting_scale_comment => p_rec.weighting_scale_comment
1690: ,p_weighting_scale_id => p_rec.weighting_scale_id
1691: );
1692: --
1693: hr_utility.set_location (l_proc, 45);
1694: --
1695: --
1696: -- VALIDATE RATING_SCALE_COMMENT
1697: -- Business Rule Mapping

Line 1706: hr_utility.set_location (l_proc, 50);

1702: (p_rating_scale_comment => p_rec.rating_scale_comment
1703: ,p_rating_scale_id => p_rec.rating_scale_id
1704: );
1705: --
1706: hr_utility.set_location (l_proc, 50);
1707: --
1708: --
1709: -- VALIDATE WEIGHTING_CLASSIFICATION
1710: -- Business Rule Mapping

Line 1720: hr_utility.set_location (l_proc, 55);

1716: ,p_weighting_scale_id => p_rec.weighting_scale_id
1717: ,p_assessment_classification=> p_rec.assessment_classification
1718: );
1719: --
1720: hr_utility.set_location (l_proc, 55);
1721: --
1722: -- Bug#885806
1723: -- dbms_output.put_line('About to validate line_score_formula');
1724: hr_utility.trace('About to validate line_score_formula');

Line 1724: hr_utility.trace('About to validate line_score_formula');

1720: hr_utility.set_location (l_proc, 55);
1721: --
1722: -- Bug#885806
1723: -- dbms_output.put_line('About to validate line_score_formula');
1724: hr_utility.trace('About to validate line_score_formula');
1725: --
1726: -- VALIDATE LINE_SCORE_FORMULA
1727: -- Business Rule Mapping
1728: -- =====================

Line 1738: hr_utility.set_location (l_proc, 60);

1734: ,p_effective_date => p_effective_date
1735: ,p_object_version_number => p_rec.object_version_number
1736: );
1737: --
1738: hr_utility.set_location (l_proc, 60);
1739: --
1740: -- Bug#885806
1741: -- dbms_output.put_line('About to validate TOTAL_score_formula');
1742: hr_utility.trace('About to validate TOTAL_score_formula');

Line 1742: hr_utility.trace('About to validate TOTAL_score_formula');

1738: hr_utility.set_location (l_proc, 60);
1739: --
1740: -- Bug#885806
1741: -- dbms_output.put_line('About to validate TOTAL_score_formula');
1742: hr_utility.trace('About to validate TOTAL_score_formula');
1743: --
1744: -- VALIDATE TOTAL_SCORE_FORMULA
1745: -- Business Rule Mapping
1746: -- =====================

Line 1756: hr_utility.set_location (l_proc, 65);

1752: ,p_effective_date => p_effective_date
1753: ,p_object_version_number => p_rec.object_version_number
1754: );
1755: --
1756: hr_utility.set_location (l_proc, 65);
1757: --
1758: --
1759: -- Bug#885806
1760: -- dbms_output.put_line('About to validate flex');

Line 1761: hr_utility.trace('About to validate flex');

1757: --
1758: --
1759: -- Bug#885806
1760: -- dbms_output.put_line('About to validate flex');
1761: hr_utility.trace('About to validate flex');
1762: --
1763: -- Call Descriptive Flexfield Validation routines
1764: --
1765: per_ast_bus.chk_df(p_rec => p_rec);

Line 1767: hr_utility.set_location (l_proc, 75);

1763: -- Call Descriptive Flexfield Validation routines
1764: --
1765: per_ast_bus.chk_df(p_rec => p_rec);
1766: --
1767: hr_utility.set_location (l_proc, 75);
1768: --
1769: hr_utility.set_location(' Leaving:'||l_proc, 85);
1770: -- Bug#885806
1771: -- dbms_output.put_line('finished insert_validate');

Line 1769: hr_utility.set_location(' Leaving:'||l_proc, 85);

1765: per_ast_bus.chk_df(p_rec => p_rec);
1766: --
1767: hr_utility.set_location (l_proc, 75);
1768: --
1769: hr_utility.set_location(' Leaving:'||l_proc, 85);
1770: -- Bug#885806
1771: -- dbms_output.put_line('finished insert_validate');
1772: hr_utility.trace('finished insert_validate');
1773: --

Line 1772: hr_utility.trace('finished insert_validate');

1768: --
1769: hr_utility.set_location(' Leaving:'||l_proc, 85);
1770: -- Bug#885806
1771: -- dbms_output.put_line('finished insert_validate');
1772: hr_utility.trace('finished insert_validate');
1773: --
1774: End insert_validate;
1775: --
1776: -- ----------------------------------------------------------------------------

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

1783: --
1784: l_proc varchar2(72) := g_package||'update_validate';
1785: --
1786: Begin
1787: hr_utility.set_location('Entering:'||l_proc, 5);
1788: --
1789: -- Call all supporting business operations. Mapping to the appropiate
1790: -- Business Rules in perast.bru is provided.
1791: --

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

1838: ,p_business_group_id => p_rec.business_group_id
1839: ,p_object_version_number => p_rec.object_version_number
1840: );
1841: --
1842: hr_utility.set_location(l_proc, 15);
1843: --
1844: --
1845: -- VALIDATE DISPLAY_ASSESSMENT_COMMENTS
1846: -- Business Rule Mapping

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

1853: ,p_effective_date => p_effective_date
1854: ,p_object_version_number => p_rec.object_version_number
1855: );
1856: --
1857: hr_utility.set_location(l_proc,20);
1858: --
1859: --
1860: -- VALIDATE ACTIVE
1861: -- Business Rule Mapping

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

1882: ,p_assessment_type_id => p_rec.assessment_type_id
1883: ,p_object_version_number => p_rec.object_version_number
1884: );
1885: --
1886: hr_utility.set_location (l_proc, 30);
1887: -- VALIDATE RATING_SCALE_ID
1888: -- Business Rule Mapping
1889: -- =====================
1890: -- Rule CHK_RATING_SCALE_ID

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

1897: ,p_object_version_number => p_rec.object_version_number
1898: ,p_weighting_classification => p_rec.weighting_classification
1899: );
1900: --
1901: hr_utility.set_location (l_proc, 15);
1902: --
1903: --
1904: -- VALIDATE WEIGHTING_SCALE_ID
1905: -- Business Rule Mapping

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

1913: ,p_assessment_classification => p_rec.assessment_classification
1914: ,p_object_version_number => p_rec.object_version_number
1915: );
1916: --
1917: hr_utility.set_location (l_proc, 25);
1918: --
1919: --
1920: -- VALIDATE WEIGHTING_SCALE_COMMENT
1921: -- Business Rule Mapping

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

1926: (p_weighting_scale_comment => p_rec.weighting_scale_comment
1927: ,p_weighting_scale_id => p_rec.weighting_scale_id
1928: );
1929: --
1930: hr_utility.set_location (l_proc, 30);
1931: --
1932: --
1933: -- VALIDATE RATING_SCALE_COMMENT
1934: -- Business Rule Mapping

Line 1943: hr_utility.set_location (l_proc, 35);

1939: (p_rating_scale_comment => p_rec.rating_scale_comment
1940: ,p_rating_scale_id => p_rec.rating_scale_id
1941: );
1942: --
1943: hr_utility.set_location (l_proc, 35);
1944: --
1945: --
1946: -- VALIDATE WEIGHTING_CLASSIFICATION
1947: -- Business Rule Mapping

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

1953: ,p_weighting_scale_id => p_rec.weighting_scale_id
1954: ,p_assessment_classification=> p_rec.assessment_classification
1955: );
1956: --
1957: hr_utility.set_location (l_proc, 40);
1958: --
1959: --
1960: -- VALIDATE LINE_SCORE_FORMULA
1961: -- Business Rule Mapping

Line 1972: hr_utility.set_location (l_proc, 45);

1968: ,p_effective_date => p_effective_date
1969: ,p_object_version_number => p_rec.object_version_number
1970: );
1971: --
1972: hr_utility.set_location (l_proc, 45);
1973: --
1974: --
1975: -- VALIDATE TOTAL_SCORE_FORMULA
1976: -- Business Rule Mapping

Line 1987: hr_utility.set_location (l_proc, 50);

1983: ,p_effective_date => p_effective_date
1984: ,p_object_version_number => p_rec.object_version_number
1985: );
1986: --
1987: hr_utility.set_location (l_proc, 50);
1988: --
1989: --
1990: -- Call Discriptive Flexfield Validation routines.
1991: --

Line 1994: hr_utility.set_location (l_proc, 55);

1990: -- Call Discriptive Flexfield Validation routines.
1991: --
1992: per_ast_bus.chk_df(p_rec => p_rec);
1993: --
1994: hr_utility.set_location (l_proc, 55);
1995: --
1996: hr_utility.set_location(' Leaving:'||l_proc, 60);
1997: End update_validate;
1998: --

Line 1996: hr_utility.set_location(' Leaving:'||l_proc, 60);

1992: per_ast_bus.chk_df(p_rec => p_rec);
1993: --
1994: hr_utility.set_location (l_proc, 55);
1995: --
1996: hr_utility.set_location(' Leaving:'||l_proc, 60);
1997: End update_validate;
1998: --
1999: -- ----------------------------------------------------------------------------
2000: -- |---------------------------< delete_validate >----------------------------|

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

2003: --
2004: l_proc varchar2(72) := g_package||'delete_validate';
2005: --
2006: Begin
2007: hr_utility.set_location('Entering:'||l_proc, 5);
2008: --
2009: -- Call all supporting business operations and show business rule mapping.
2010: --
2011: -- VALIDATE ASSESSMENT_TYPE_USED

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

2017: (p_assessment_type_id => p_rec.assessment_type_id
2018: ,p_object_version_number => p_rec.object_version_number
2019: );
2020: --
2021: hr_utility.set_location(' Leaving:'||l_proc, 10);
2022: End delete_validate;
2023: --
2024: -- ----------------------------------------------------------------------------
2025: -- |-----------------------< return_legislation_code >-------------------------|

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

2040: l_proc varchar2(72) := g_package||'return_legislation_code';
2041: l_legislation_code varchar2(150);
2042: --
2043: Begin
2044: hr_utility.set_location('Entering:'||l_proc, 5);
2045: --
2046: -- Ensure that all the mandatory parameters are not null
2047: --
2048: hr_api.mandatory_arg_error (p_api_name => l_proc,

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

2055: -- call to this function. Just return the value in the global
2056: -- variable.
2057: --
2058: l_legislation_code := g_legislation_code;
2059: hr_utility.set_location(l_proc, 20);
2060: else
2061: --
2062: -- The ID is different to the last call to this function
2063: -- or this is the first call to this function.

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

2068: close csr_leg_code;
2069: --
2070: -- The primary key is invalid therefore we must error out
2071: --
2072: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2073: hr_utility.raise_error;
2074: end if;
2075: --
2076: close csr_leg_code;

Line 2073: hr_utility.raise_error;

2069: --
2070: -- The primary key is invalid therefore we must error out
2071: --
2072: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2073: hr_utility.raise_error;
2074: end if;
2075: --
2076: close csr_leg_code;
2077: g_assessment_type_id:= p_assessment_type_id;

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

2078: g_legislation_code := l_legislation_code;
2079: end if;
2080: return l_legislation_code;
2081: --
2082: hr_utility.set_location(' Leaving:'||l_proc, 10);
2083: --
2084: End return_legislation_code;
2085: --
2086: end per_ast_bus;