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_APT_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_apt_shd.api_updating
32: (p_appraisal_template_id => p_rec.appraisal_template_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_appraisal_template_id => p_rec.appraisal_template_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_apt_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, 11);

42: if p_rec.business_group_id <> per_apt_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, 11);
47:
48: exception
49: when l_error then
50: hr_api.argument_changed_error

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

51: (p_api_name => l_proc
52: ,p_argument => l_argument);
53: when others then
54: raise;
55: hr_utility.set_location(' Leaving:'||l_proc, 12);
56: end chk_non_updateable_args;
57:
58: ----------------------------------------------------------------------------+
59: ------------------------------------------------------------------+

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

112: )
113: and apt.name = p_name and
114: ( business_group_id is null or p_business_group_id is null or business_group_id = p_business_group_id);
115: begin
116: hr_utility.set_location('Entering:'|| l_proc, 1);
117:
118:
119:
120: -- Only proceed with validation if :

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

133:
134: -- check if the user has entered a name
135: -- It is mandatory column.
136:
137: hr_utility.set_location(l_proc, 3);
138: if p_name is null then
139: hr_utility.set_message(801,'HR_51907_APT_NAME_MANDATORY');
140: hr_utility.raise_error;
141: end if;

Line 139: hr_utility.set_message(801,'HR_51907_APT_NAME_MANDATORY');

135: -- It is mandatory column.
136:
137: hr_utility.set_location(l_proc, 3);
138: if p_name is null then
139: hr_utility.set_message(801,'HR_51907_APT_NAME_MANDATORY');
140: hr_utility.raise_error;
141: end if;
142:
143: hr_utility.set_location(l_proc, 4);

Line 140: hr_utility.raise_error;

136:
137: hr_utility.set_location(l_proc, 3);
138: if p_name is null then
139: hr_utility.set_message(801,'HR_51907_APT_NAME_MANDATORY');
140: hr_utility.raise_error;
141: end if;
142:
143: hr_utility.set_location(l_proc, 4);
144: open csr_name_unique;

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

139: hr_utility.set_message(801,'HR_51907_APT_NAME_MANDATORY');
140: hr_utility.raise_error;
141: end if;
142:
143: hr_utility.set_location(l_proc, 4);
144: open csr_name_unique;
145: fetch csr_name_unique into l_business_group_id;
146: if csr_name_unique%found then
147: close csr_name_unique;

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

144: open csr_name_unique;
145: fetch csr_name_unique into l_business_group_id;
146: if csr_name_unique%found then
147: close csr_name_unique;
148: hr_utility.set_message(801,'HR_51908_APT_NAME_NOT_UNIQUE');
149: hr_utility.raise_error;
150: end if;
151: close csr_name_unique;
152: end if;

Line 149: hr_utility.raise_error;

145: fetch csr_name_unique into l_business_group_id;
146: if csr_name_unique%found then
147: close csr_name_unique;
148: hr_utility.set_message(801,'HR_51908_APT_NAME_NOT_UNIQUE');
149: hr_utility.raise_error;
150: end if;
151: close csr_name_unique;
152: end if;
153:

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

150: end if;
151: close csr_name_unique;
152: end if;
153:
154: hr_utility.set_location(l_proc, 5);
155:
156: hr_utility.set_location('Leaving: '|| l_proc, 10);
157:
158: end chk_name;

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

152: end if;
153:
154: hr_utility.set_location(l_proc, 5);
155:
156: hr_utility.set_location('Leaving: '|| l_proc, 10);
157:
158: end chk_name;
159:
160:

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

217: and apr.appraisal_template_id = p_appraisal_template_id;
218:
219:
220: begin
221: hr_utility.set_location('Entering:'|| l_proc, 1);
222:
223: -- Check if date from is set to null when date to exists
224: if ( (p_date_from is null) AND (p_date_to is not null) )
225: then

Line 226: hr_utility.set_message(800, 'HR_52247_APT_DATE_FROM_NULL');

222:
223: -- Check if date from is set to null when date to exists
224: if ( (p_date_from is null) AND (p_date_to is not null) )
225: then
226: hr_utility.set_message(800, 'HR_52247_APT_DATE_FROM_NULL');
227: hr_utility.raise_error;
228: end if;
229: -- Date From has to be <= date to, else error.
230: if ( nvl(p_date_from,hr_api.g_sot) > nvl(p_date_to,hr_api.g_eot) )

Line 227: hr_utility.raise_error;

223: -- Check if date from is set to null when date to exists
224: if ( (p_date_from is null) AND (p_date_to is not null) )
225: then
226: hr_utility.set_message(800, 'HR_52247_APT_DATE_FROM_NULL');
227: hr_utility.raise_error;
228: end if;
229: -- Date From has to be <= date to, else error.
230: if ( nvl(p_date_from,hr_api.g_sot) > nvl(p_date_to,hr_api.g_eot) )
231: then

Line 232: hr_utility.set_message(801, 'HR_51909_APT_DATE_FROM_BEFORE');

228: end if;
229: -- Date From has to be <= date to, else error.
230: if ( nvl(p_date_from,hr_api.g_sot) > nvl(p_date_to,hr_api.g_eot) )
231: then
232: hr_utility.set_message(801, 'HR_51909_APT_DATE_FROM_BEFORE');
233: hr_utility.raise_error;
234: end if;
235: -- Date To has to be >= date to, else error.
236: if ( nvl(p_date_to,hr_api.g_eot) < nvl(p_date_from,hr_api.g_sot) )

Line 233: hr_utility.raise_error;

229: -- Date From has to be <= date to, else error.
230: if ( nvl(p_date_from,hr_api.g_sot) > nvl(p_date_to,hr_api.g_eot) )
231: then
232: hr_utility.set_message(801, 'HR_51909_APT_DATE_FROM_BEFORE');
233: hr_utility.raise_error;
234: end if;
235: -- Date To has to be >= date to, else error.
236: if ( nvl(p_date_to,hr_api.g_eot) < nvl(p_date_from,hr_api.g_sot) )
237: then

Line 238: hr_utility.set_message(801, 'HR_51910_APT_DATE_TO_AFTER');

234: end if;
235: -- Date To has to be >= date to, else error.
236: if ( nvl(p_date_to,hr_api.g_eot) < nvl(p_date_from,hr_api.g_sot) )
237: then
238: hr_utility.set_message(801, 'HR_51910_APT_DATE_TO_AFTER');
239: hr_utility.raise_error;
240: end if;
241:
242: l_api_updating := per_apt_shd.api_updating

Line 239: hr_utility.raise_error;

235: -- Date To has to be >= date to, else error.
236: if ( nvl(p_date_to,hr_api.g_eot) < nvl(p_date_from,hr_api.g_sot) )
237: then
238: hr_utility.set_message(801, 'HR_51910_APT_DATE_TO_AFTER');
239: hr_utility.raise_error;
240: end if;
241:
242: l_api_updating := per_apt_shd.api_updating
243: (p_appraisal_template_id => p_appraisal_template_id

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

261:
262: open csr_check_dates_in_apr;
263: fetch csr_check_dates_in_apr into l_exists;
264: if csr_check_dates_in_apr%found then
265: hr_utility.set_location(l_proc, 3);
266: -- dates out of range
267: close csr_check_dates_in_apr ;
268: hr_utility.set_message(801,'HR_51911_APT_INVALIDATE_APR');
269: hr_utility.raise_error;

Line 268: hr_utility.set_message(801,'HR_51911_APT_INVALIDATE_APR');

264: if csr_check_dates_in_apr%found then
265: hr_utility.set_location(l_proc, 3);
266: -- dates out of range
267: close csr_check_dates_in_apr ;
268: hr_utility.set_message(801,'HR_51911_APT_INVALIDATE_APR');
269: hr_utility.raise_error;
270: end if;
271: close csr_check_dates_in_apr;
272:

Line 269: hr_utility.raise_error;

265: hr_utility.set_location(l_proc, 3);
266: -- dates out of range
267: close csr_check_dates_in_apr ;
268: hr_utility.set_message(801,'HR_51911_APT_INVALIDATE_APR');
269: hr_utility.raise_error;
270: end if;
271: close csr_check_dates_in_apr;
272:
273: end if;

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

271: close csr_check_dates_in_apr;
272:
273: end if;
274:
275: hr_utility.set_location('Leaving:'|| l_proc, 10);
276:
277: end chk_template_dates;
278:
279: ----------------------------------------------------------------------------+

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

348: and nvl(date_to,hr_api.g_eot) >= nvl(p_date_to,hr_api.g_sot) ;
349: -- Bug 3947233 Ends Here
350:
351: begin
352: hr_utility.set_location('Entering:'|| l_proc, 1);
353:
354: -- Check mandatory parameters have been set
355:
356:

Line 357: hr_utility.set_location('Entering:'|| l_proc, 2);

353:
354: -- Check mandatory parameters have been set
355:
356:
357: hr_utility.set_location('Entering:'|| l_proc, 2);
358:
359: l_api_updating := per_apt_shd.api_updating
360: (p_appraisal_template_id => p_appraisal_template_id
361: ,p_object_version_number => p_object_version_number);

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

375: open csr_appraisal_type_exists;
376: fetch csr_appraisal_type_exists into l_business_group_id;
377: if csr_appraisal_type_exists%notfound then
378: close csr_appraisal_type_exists;
379: hr_utility.set_message(801,'HR_51912_APT_AST_NOT_EXIST');
380: hr_utility.raise_error;
381: end if;
382: close csr_appraisal_type_exists;
383:

Line 380: hr_utility.raise_error;

376: fetch csr_appraisal_type_exists into l_business_group_id;
377: if csr_appraisal_type_exists%notfound then
378: close csr_appraisal_type_exists;
379: hr_utility.set_message(801,'HR_51912_APT_AST_NOT_EXIST');
380: hr_utility.raise_error;
381: end if;
382: close csr_appraisal_type_exists;
383:
384: -- check if assessment is in the same business group

Line 387: hr_utility.set_message(800,'HR_51913_APT_AST_DIFF_BUS_GRP');

383:
384: -- check if assessment is in the same business group
385:
386: if nvl(l_business_group_id,-1) <> nvl(p_business_group_id,-1) then
387: hr_utility.set_message(800,'HR_51913_APT_AST_DIFF_BUS_GRP');
388: hr_utility.raise_error;
389: end if;
390:
391: -- check if assessment type exists with the date range of the

Line 388: hr_utility.raise_error;

384: -- check if assessment is in the same business group
385:
386: if nvl(l_business_group_id,-1) <> nvl(p_business_group_id,-1) then
387: hr_utility.set_message(800,'HR_51913_APT_AST_DIFF_BUS_GRP');
388: hr_utility.raise_error;
389: end if;
390:
391: -- check if assessment type exists with the date range of the
392: -- appraisal template

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

394: open csr_assessment_type_valid;
395: fetch csr_assessment_type_valid into l_exists;
396: if csr_assessment_type_valid%notfound then
397: close csr_assessment_type_valid;
398: hr_utility.set_message(801,'HR_51914_APT_AST_NOT_DATE');
399: hr_utility.raise_error;
400: end if;
401: close csr_assessment_type_valid;
402: end if;

Line 399: hr_utility.raise_error;

395: fetch csr_assessment_type_valid into l_exists;
396: if csr_assessment_type_valid%notfound then
397: close csr_assessment_type_valid;
398: hr_utility.set_message(801,'HR_51914_APT_AST_NOT_DATE');
399: hr_utility.raise_error;
400: end if;
401: close csr_assessment_type_valid;
402: end if;
403:

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

402: end if;
403:
404: end if;
405:
406: hr_utility.set_location(l_proc, 4);
407:
408: hr_utility.set_location('Leaving: '|| l_proc, 10);
409:
410: end chk_assessment_type;

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

404: end if;
405:
406: hr_utility.set_location(l_proc, 4);
407:
408: hr_utility.set_location('Leaving: '|| l_proc, 10);
409:
410: end chk_assessment_type;
411:
412: ----------------------------------------------------------------------------+

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

481: and nvl(date_to,hr_api.g_eot) >= nvl(p_date_to,hr_api.g_sot) ;
482: -- Bug 3947233 Ends Here
483:
484: begin
485: hr_utility.set_location('Entering:'|| l_proc, 1);
486:
487:
488:
489: l_api_updating := per_apt_shd.api_updating

Line 509: hr_utility.set_message(800,'HR_APT_OAST_NOT_EXIST');

505: open csr_appraisal_type_exists;
506: fetch csr_appraisal_type_exists into l_business_group_id;
507: if csr_appraisal_type_exists%notfound then
508: close csr_appraisal_type_exists;
509: hr_utility.set_message(800,'HR_APT_OAST_NOT_EXIST');
510: hr_utility.raise_error;
511: end if;
512: close csr_appraisal_type_exists;
513:

Line 510: hr_utility.raise_error;

506: fetch csr_appraisal_type_exists into l_business_group_id;
507: if csr_appraisal_type_exists%notfound then
508: close csr_appraisal_type_exists;
509: hr_utility.set_message(800,'HR_APT_OAST_NOT_EXIST');
510: hr_utility.raise_error;
511: end if;
512: close csr_appraisal_type_exists;
513:
514: -- check if assessment is in the same business group

Line 517: hr_utility.set_message(800,'HR_APT_OAST_DIFF_BUS_GRP');

513:
514: -- check if assessment is in the same business group
515:
516: if nvl(l_business_group_id,-1) <> nvl(p_business_group_id,-1) then
517: hr_utility.set_message(800,'HR_APT_OAST_DIFF_BUS_GRP');
518: hr_utility.raise_error;
519: end if;
520:
521: -- check if assessment type exists with the date range of the

Line 518: hr_utility.raise_error;

514: -- check if assessment is in the same business group
515:
516: if nvl(l_business_group_id,-1) <> nvl(p_business_group_id,-1) then
517: hr_utility.set_message(800,'HR_APT_OAST_DIFF_BUS_GRP');
518: hr_utility.raise_error;
519: end if;
520:
521: -- check if assessment type exists with the date range of the
522: -- appraisal template

Line 528: hr_utility.set_message(800,'HR_APT_OAST_NOT_DATE');

524: open csr_assessment_type_valid;
525: fetch csr_assessment_type_valid into l_exists;
526: if csr_assessment_type_valid%notfound then
527: close csr_assessment_type_valid;
528: hr_utility.set_message(800,'HR_APT_OAST_NOT_DATE');
529: hr_utility.raise_error;
530: end if;
531: close csr_assessment_type_valid;
532: end if;

Line 529: hr_utility.raise_error;

525: fetch csr_assessment_type_valid into l_exists;
526: if csr_assessment_type_valid%notfound then
527: close csr_assessment_type_valid;
528: hr_utility.set_message(800,'HR_APT_OAST_NOT_DATE');
529: hr_utility.raise_error;
530: end if;
531: close csr_assessment_type_valid;
532: end if;
533:

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

532: end if;
533:
534: end if;
535:
536: hr_utility.set_location(l_proc, 4);
537:
538: hr_utility.set_location('Leaving: '|| l_proc, 10);
539:
540: end chk_objective_asmnt_type;

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

534: end if;
535:
536: hr_utility.set_location(l_proc, 4);
537:
538: hr_utility.set_location('Leaving: '|| l_proc, 10);
539:
540: end chk_objective_asmnt_type;
541:
542: ----------------------------------------------------------------------------+

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

628: where apr.appraisal_template_id
629: = p_appraisal_template_id);
630:
631: begin
632: hr_utility.set_location('Entering:'|| l_proc, 1);
633:
634: l_api_updating := per_apt_shd.api_updating
635: (p_appraisal_template_id => p_appraisal_template_id
636: ,p_object_version_number => p_object_version_number);

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

639:
640: if (NOT l_api_updating) then
641: -- check if template exists
642: if p_questionnaire_template_id is not null then
643: hr_utility.set_location(l_proc, 3);
644: open csr_question_template_exists;
645: fetch csr_question_template_exists into l_bus_grp_id;
646: if csr_question_template_exists%notfound then
647: close csr_question_template_exists;

Line 648: hr_utility.set_message(800,'HR_51915_APT_QST_NOT_EXIST');

644: open csr_question_template_exists;
645: fetch csr_question_template_exists into l_bus_grp_id;
646: if csr_question_template_exists%notfound then
647: close csr_question_template_exists;
648: hr_utility.set_message(800,'HR_51915_APT_QST_NOT_EXIST');
649: hr_utility.raise_error;
650: end if;
651: close csr_question_template_exists;
652:

Line 649: hr_utility.raise_error;

645: fetch csr_question_template_exists into l_bus_grp_id;
646: if csr_question_template_exists%notfound then
647: close csr_question_template_exists;
648: hr_utility.set_message(800,'HR_51915_APT_QST_NOT_EXIST');
649: hr_utility.raise_error;
650: end if;
651: close csr_question_template_exists;
652:
653: -- check if questionnaire template is of type 'APPRAISAL'

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

651: close csr_question_template_exists;
652:
653: -- check if questionnaire template is of type 'APPRAISAL'
654:
655: hr_utility.set_location(l_proc, 6);
656: -- if l_type <> 'APPRAISAL' then
657: -- hr_utility.set_message(801,'HR_51916_APT_QST_INV_TYPE');
658: -- hr_utility.raise_error;
659: -- end if;

Line 657: -- hr_utility.set_message(801,'HR_51916_APT_QST_INV_TYPE');

653: -- check if questionnaire template is of type 'APPRAISAL'
654:
655: hr_utility.set_location(l_proc, 6);
656: -- if l_type <> 'APPRAISAL' then
657: -- hr_utility.set_message(801,'HR_51916_APT_QST_INV_TYPE');
658: -- hr_utility.raise_error;
659: -- end if;
660:
661: -- Check if business_group_id is correct for the given questionnaire

Line 658: -- hr_utility.raise_error;

654:
655: hr_utility.set_location(l_proc, 6);
656: -- if l_type <> 'APPRAISAL' then
657: -- hr_utility.set_message(801,'HR_51916_APT_QST_INV_TYPE');
658: -- hr_utility.raise_error;
659: -- end if;
660:
661: -- Check if business_group_id is correct for the given questionnaire
662: -- template id.

Line 683: -- hr_utility.set_location(l_proc, 7);

679: then
680:
681: -- Check if the questionnaire template can be updated first.
682:
683: -- hr_utility.set_location(l_proc, 7);
684: -- open csr_question_update;
685: -- fetch csr_question_update into l_exists;
686: -- if csr_question_update%found then
687: -- close csr_question_update;

Line 688: -- hr_utility.set_message(801,'HR_51917_APT_USED_IN_APR_ANS');

684: -- open csr_question_update;
685: -- fetch csr_question_update into l_exists;
686: -- if csr_question_update%found then
687: -- close csr_question_update;
688: -- hr_utility.set_message(801,'HR_51917_APT_USED_IN_APR_ANS');
689: -- hr_utility.raise_error;
690: -- end if;
691: -- close csr_question_update;
692: open csr_question_update1;

Line 689: -- hr_utility.raise_error;

685: -- fetch csr_question_update into l_exists;
686: -- if csr_question_update%found then
687: -- close csr_question_update;
688: -- hr_utility.set_message(801,'HR_51917_APT_USED_IN_APR_ANS');
689: -- hr_utility.raise_error;
690: -- end if;
691: -- close csr_question_update;
692: open csr_question_update1;
693: fetch csr_question_update1 into l_exists;

Line 714: -- hr_utility.set_location(l_proc, 9);

710:
711:
712: -- check if questionnaire template is of type 'APPRAISAL'
713:
714: -- hr_utility.set_location(l_proc, 9);
715: -- if l_type <> 'APPRAISAL' then
716: -- hr_utility.set_message(801,'HR_51916_APT_QST_INV_TYPE');
717: -- hr_utility.raise_error;
718: -- end if;

Line 716: -- hr_utility.set_message(801,'HR_51916_APT_QST_INV_TYPE');

712: -- check if questionnaire template is of type 'APPRAISAL'
713:
714: -- hr_utility.set_location(l_proc, 9);
715: -- if l_type <> 'APPRAISAL' then
716: -- hr_utility.set_message(801,'HR_51916_APT_QST_INV_TYPE');
717: -- hr_utility.raise_error;
718: -- end if;
719:
720: -- check if questionnaire template is of correct business_group

Line 717: -- hr_utility.raise_error;

713:
714: -- hr_utility.set_location(l_proc, 9);
715: -- if l_type <> 'APPRAISAL' then
716: -- hr_utility.set_message(801,'HR_51916_APT_QST_INV_TYPE');
717: -- hr_utility.raise_error;
718: -- end if;
719:
720: -- check if questionnaire template is of correct business_group
721:

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

720: -- check if questionnaire template is of correct business_group
721:
722: end if;
723:
724: hr_utility.set_location(l_proc, 10);
725:
726: hr_utility.set_location('Leaving: '|| l_proc, 11);
727:
728: end chk_question_template;

Line 726: hr_utility.set_location('Leaving: '|| l_proc, 11);

722: end if;
723:
724: hr_utility.set_location(l_proc, 10);
725:
726: hr_utility.set_location('Leaving: '|| l_proc, 11);
727:
728: end chk_question_template;
729:
730:

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

817: where apr.appraisal_template_id
818: = p_appraisal_template_id);
819:
820: begin
821: hr_utility.set_location('Entering:'|| l_proc, 1);
822:
823: l_api_updating := per_apt_shd.api_updating
824: (p_appraisal_template_id => p_appraisal_template_id
825: ,p_object_version_number => p_object_version_number);

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

828:
829: if (NOT l_api_updating) then
830: -- check if template exists
831: if p_ma_quest_template_id is not null then
832: hr_utility.set_location(l_proc, 3);
833: open csr_question_template_exists;
834: fetch csr_question_template_exists into l_bus_grp_id;
835: if csr_question_template_exists%notfound then
836: close csr_question_template_exists;

Line 837: hr_utility.set_message(800,'HR_APT_MA_QST_NOT_EXIST');

833: open csr_question_template_exists;
834: fetch csr_question_template_exists into l_bus_grp_id;
835: if csr_question_template_exists%notfound then
836: close csr_question_template_exists;
837: hr_utility.set_message(800,'HR_APT_MA_QST_NOT_EXIST');
838: hr_utility.raise_error;
839: end if;
840: close csr_question_template_exists;
841:

Line 838: hr_utility.raise_error;

834: fetch csr_question_template_exists into l_bus_grp_id;
835: if csr_question_template_exists%notfound then
836: close csr_question_template_exists;
837: hr_utility.set_message(800,'HR_APT_MA_QST_NOT_EXIST');
838: hr_utility.raise_error;
839: end if;
840: close csr_question_template_exists;
841:
842:

Line 867: -- hr_utility.set_location(l_proc, 7);

863: then
864:
865: -- Check if the questionnaire template can be updated first.
866:
867: -- hr_utility.set_location(l_proc, 7);
868: -- open csr_question_update;
869: -- fetch csr_question_update into l_exists;
870: -- if csr_question_update%found then
871: -- close csr_question_update;

Line 872: -- hr_utility.set_message(801,'HR_51917_APT_USED_IN_APR_ANS');

868: -- open csr_question_update;
869: -- fetch csr_question_update into l_exists;
870: -- if csr_question_update%found then
871: -- close csr_question_update;
872: -- hr_utility.set_message(801,'HR_51917_APT_USED_IN_APR_ANS');
873: -- hr_utility.raise_error;
874: -- end if;
875: -- close csr_question_update;
876: open csr_question_update1;

Line 873: -- hr_utility.raise_error;

869: -- fetch csr_question_update into l_exists;
870: -- if csr_question_update%found then
871: -- close csr_question_update;
872: -- hr_utility.set_message(801,'HR_51917_APT_USED_IN_APR_ANS');
873: -- hr_utility.raise_error;
874: -- end if;
875: -- close csr_question_update;
876: open csr_question_update1;
877: fetch csr_question_update1 into l_exists;

Line 900: hr_utility.set_message(801,'PER_52470_TEMP_NOT_IN_BG');

896:
897: -- check if questionnaire template is of correct business_group
898:
899: if l_bus_grp_id <> p_business_group_id then
900: hr_utility.set_message(801,'PER_52470_TEMP_NOT_IN_BG');
901: hr_utility.raise_error;
902: end if;
903: end if;
904:

Line 901: hr_utility.raise_error;

897: -- check if questionnaire template is of correct business_group
898:
899: if l_bus_grp_id <> p_business_group_id then
900: hr_utility.set_message(801,'PER_52470_TEMP_NOT_IN_BG');
901: hr_utility.raise_error;
902: end if;
903: end if;
904:
905: hr_utility.set_location(l_proc, 10);

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

901: hr_utility.raise_error;
902: end if;
903: end if;
904:
905: hr_utility.set_location(l_proc, 10);
906:
907: hr_utility.set_location('Leaving: '|| l_proc, 11);
908:
909: end chk_ma_question_template;

Line 907: hr_utility.set_location('Leaving: '|| l_proc, 11);

903: end if;
904:
905: hr_utility.set_location(l_proc, 10);
906:
907: hr_utility.set_location('Leaving: '|| l_proc, 11);
908:
909: end chk_ma_question_template;
910:
911: ----------------------------------------------------------------------------+

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

996: and apr.appraisal_template_id = p_appraisal_template_id;
997:
998:
999: begin
1000: hr_utility.set_location('Entering:'|| l_proc, 1);
1001:
1002: -- Check mandatory parameters have been set
1003:
1004: -- ngundura change done for pa requirements

Line 1013: hr_utility.set_location('Entering:'|| l_proc, 2);

1009: );
1010: */
1011: -- ngundura end of changes
1012:
1013: hr_utility.set_location('Entering:'|| l_proc, 2);
1014:
1015: l_api_updating := per_apt_shd.api_updating
1016: (p_appraisal_template_id => p_appraisal_template_id
1017: ,p_object_version_number => p_object_version_number);

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

1021: -- b) The value for rating scale has changed
1022:
1023: if (NOT l_api_updating) then
1024: if p_rating_scale_id is not null then
1025: hr_utility.set_location(l_proc, 3);
1026: open csr_rating_scale_exists;
1027: fetch csr_rating_scale_exists into l_business_group_id,l_type;
1028: if csr_rating_scale_exists%notfound then
1029: close csr_rating_scale_exists;

Line 1030: hr_utility.set_message(801,'HR_51928_APT_RSC_NOT_EXIST');

1026: open csr_rating_scale_exists;
1027: fetch csr_rating_scale_exists into l_business_group_id,l_type;
1028: if csr_rating_scale_exists%notfound then
1029: close csr_rating_scale_exists;
1030: hr_utility.set_message(801,'HR_51928_APT_RSC_NOT_EXIST');
1031: hr_utility.raise_error;
1032: end if;
1033: close csr_rating_scale_exists;
1034:

Line 1031: hr_utility.raise_error;

1027: fetch csr_rating_scale_exists into l_business_group_id,l_type;
1028: if csr_rating_scale_exists%notfound then
1029: close csr_rating_scale_exists;
1030: hr_utility.set_message(801,'HR_51928_APT_RSC_NOT_EXIST');
1031: hr_utility.raise_error;
1032: end if;
1033: close csr_rating_scale_exists;
1034:
1035: -- check if rating scale is in the same business group

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

1033: close csr_rating_scale_exists;
1034:
1035: -- check if rating scale is in the same business group
1036:
1037: hr_utility.set_location(l_proc, 5);
1038: if nvl(l_business_group_id,-1) <> nvl(p_business_group_id,-1) then
1039: if(l_business_group_id is not null) then
1040: hr_utility.set_message(801,'HR_51929_APT_RSC_DIFF_BUS_GRP');
1041: hr_utility.raise_error;

Line 1040: hr_utility.set_message(801,'HR_51929_APT_RSC_DIFF_BUS_GRP');

1036:
1037: hr_utility.set_location(l_proc, 5);
1038: if nvl(l_business_group_id,-1) <> nvl(p_business_group_id,-1) then
1039: if(l_business_group_id is not null) then
1040: hr_utility.set_message(801,'HR_51929_APT_RSC_DIFF_BUS_GRP');
1041: hr_utility.raise_error;
1042: end if;
1043: end if;
1044:

Line 1041: hr_utility.raise_error;

1037: hr_utility.set_location(l_proc, 5);
1038: if nvl(l_business_group_id,-1) <> nvl(p_business_group_id,-1) then
1039: if(l_business_group_id is not null) then
1040: hr_utility.set_message(801,'HR_51929_APT_RSC_DIFF_BUS_GRP');
1041: hr_utility.raise_error;
1042: end if;
1043: end if;
1044:
1045: -- check if rating scale template is of type 'PERFORMANCE'

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

1043: end if;
1044:
1045: -- check if rating scale template is of type 'PERFORMANCE'
1046:
1047: hr_utility.set_location(l_proc, 6);
1048: if l_type <> 'PERFORMANCE' then
1049: hr_utility.set_message(801,'HR_51930_APT_RSC_INV_TYPE');
1050: hr_utility.raise_error;
1051: end if;

Line 1049: hr_utility.set_message(801,'HR_51930_APT_RSC_INV_TYPE');

1045: -- check if rating scale template is of type 'PERFORMANCE'
1046:
1047: hr_utility.set_location(l_proc, 6);
1048: if l_type <> 'PERFORMANCE' then
1049: hr_utility.set_message(801,'HR_51930_APT_RSC_INV_TYPE');
1050: hr_utility.raise_error;
1051: end if;
1052: end if;
1053: end if;

Line 1050: hr_utility.raise_error;

1046:
1047: hr_utility.set_location(l_proc, 6);
1048: if l_type <> 'PERFORMANCE' then
1049: hr_utility.set_message(801,'HR_51930_APT_RSC_INV_TYPE');
1050: hr_utility.raise_error;
1051: end if;
1052: end if;
1053: end if;
1054:

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

1061: then
1062:
1063: -- Check if the rating scale can be updated
1064:
1065: hr_utility.set_location(l_proc, 7);
1066: open csr_rating_scale_update1;
1067: fetch csr_rating_scale_update1 into l_overall_performance_level_id;
1068: close csr_rating_scale_update1;
1069: if l_overall_performance_level_id is not null then

Line 1070: hr_utility.set_message(801,'HR_51931_APT_APR_LVL_NOTNULL');

1066: open csr_rating_scale_update1;
1067: fetch csr_rating_scale_update1 into l_overall_performance_level_id;
1068: close csr_rating_scale_update1;
1069: if l_overall_performance_level_id is not null then
1070: hr_utility.set_message(801,'HR_51931_APT_APR_LVL_NOTNULL');
1071: hr_utility.raise_error;
1072: end if;
1073:
1074: hr_utility.set_location(l_proc, 8);

Line 1071: hr_utility.raise_error;

1067: fetch csr_rating_scale_update1 into l_overall_performance_level_id;
1068: close csr_rating_scale_update1;
1069: if l_overall_performance_level_id is not null then
1070: hr_utility.set_message(801,'HR_51931_APT_APR_LVL_NOTNULL');
1071: hr_utility.raise_error;
1072: end if;
1073:
1074: hr_utility.set_location(l_proc, 8);
1075: open csr_rating_scale_update2;

Line 1074: hr_utility.set_location(l_proc, 8);

1070: hr_utility.set_message(801,'HR_51931_APT_APR_LVL_NOTNULL');
1071: hr_utility.raise_error;
1072: end if;
1073:
1074: hr_utility.set_location(l_proc, 8);
1075: open csr_rating_scale_update2;
1076: fetch csr_rating_scale_update2 into l_exists;
1077: if csr_rating_scale_update2%found then
1078: close csr_rating_scale_update2;

Line 1079: hr_utility.set_message(801,'HR_51932_APT_EXIST_IN_PRF');

1075: open csr_rating_scale_update2;
1076: fetch csr_rating_scale_update2 into l_exists;
1077: if csr_rating_scale_update2%found then
1078: close csr_rating_scale_update2;
1079: hr_utility.set_message(801,'HR_51932_APT_EXIST_IN_PRF');
1080: hr_utility.raise_error;
1081: end if;
1082: close csr_rating_scale_update2;
1083:

Line 1080: hr_utility.raise_error;

1076: fetch csr_rating_scale_update2 into l_exists;
1077: if csr_rating_scale_update2%found then
1078: close csr_rating_scale_update2;
1079: hr_utility.set_message(801,'HR_51932_APT_EXIST_IN_PRF');
1080: hr_utility.raise_error;
1081: end if;
1082: close csr_rating_scale_update2;
1083:
1084: -- Now check if the rating scale exists and is of the correct type

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

1083:
1084: -- Now check if the rating scale exists and is of the correct type
1085:
1086: if p_rating_scale_id is not null then
1087: hr_utility.set_location(l_proc, 9);
1088: open csr_rating_scale_exists;
1089: fetch csr_rating_scale_exists into l_business_group_id,l_type;
1090: if csr_rating_scale_exists%notfound then
1091: close csr_rating_scale_exists;

Line 1092: hr_utility.set_message(801,'HR_51928_APT_RSC_NOT_EXIST');

1088: open csr_rating_scale_exists;
1089: fetch csr_rating_scale_exists into l_business_group_id,l_type;
1090: if csr_rating_scale_exists%notfound then
1091: close csr_rating_scale_exists;
1092: hr_utility.set_message(801,'HR_51928_APT_RSC_NOT_EXIST');
1093: hr_utility.raise_error;
1094: end if;
1095: close csr_rating_scale_exists;
1096:

Line 1093: hr_utility.raise_error;

1089: fetch csr_rating_scale_exists into l_business_group_id,l_type;
1090: if csr_rating_scale_exists%notfound then
1091: close csr_rating_scale_exists;
1092: hr_utility.set_message(801,'HR_51928_APT_RSC_NOT_EXIST');
1093: hr_utility.raise_error;
1094: end if;
1095: close csr_rating_scale_exists;
1096:
1097: -- check if rating scale is in the same business group

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

1095: close csr_rating_scale_exists;
1096:
1097: -- check if rating scale is in the same business group
1098:
1099: hr_utility.set_location(l_proc, 10);
1100: if l_business_group_id <> p_business_group_id then
1101: hr_utility.set_message(801,'HR_51929_APT_RSC_DIFF_BUS_GRP');
1102: hr_utility.raise_error;
1103: end if;

Line 1101: hr_utility.set_message(801,'HR_51929_APT_RSC_DIFF_BUS_GRP');

1097: -- check if rating scale is in the same business group
1098:
1099: hr_utility.set_location(l_proc, 10);
1100: if l_business_group_id <> p_business_group_id then
1101: hr_utility.set_message(801,'HR_51929_APT_RSC_DIFF_BUS_GRP');
1102: hr_utility.raise_error;
1103: end if;
1104:
1105: -- check if rating scale template is of type 'PERFORMANCE'

Line 1102: hr_utility.raise_error;

1098:
1099: hr_utility.set_location(l_proc, 10);
1100: if l_business_group_id <> p_business_group_id then
1101: hr_utility.set_message(801,'HR_51929_APT_RSC_DIFF_BUS_GRP');
1102: hr_utility.raise_error;
1103: end if;
1104:
1105: -- check if rating scale template is of type 'PERFORMANCE'
1106:

Line 1107: hr_utility.set_location(l_proc, 11);

1103: end if;
1104:
1105: -- check if rating scale template is of type 'PERFORMANCE'
1106:
1107: hr_utility.set_location(l_proc, 11);
1108: if l_type <> 'PERFORMANCE' then
1109: hr_utility.set_message(801,'HR_52930_APT_RSC_INV_TYPE');
1110: hr_utility.raise_error;
1111: end if;

Line 1109: hr_utility.set_message(801,'HR_52930_APT_RSC_INV_TYPE');

1105: -- check if rating scale template is of type 'PERFORMANCE'
1106:
1107: hr_utility.set_location(l_proc, 11);
1108: if l_type <> 'PERFORMANCE' then
1109: hr_utility.set_message(801,'HR_52930_APT_RSC_INV_TYPE');
1110: hr_utility.raise_error;
1111: end if;
1112: end if;
1113:

Line 1110: hr_utility.raise_error;

1106:
1107: hr_utility.set_location(l_proc, 11);
1108: if l_type <> 'PERFORMANCE' then
1109: hr_utility.set_message(801,'HR_52930_APT_RSC_INV_TYPE');
1110: hr_utility.raise_error;
1111: end if;
1112: end if;
1113:
1114: end if;

Line 1116: hr_utility.set_location(l_proc, 12);

1112: end if;
1113:
1114: end if;
1115:
1116: hr_utility.set_location(l_proc, 12);
1117:
1118: hr_utility.set_location('Leaving: '|| l_proc, 10);
1119:
1120: end chk_rating_scale;

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

1114: end if;
1115:
1116: hr_utility.set_location(l_proc, 12);
1117:
1118: hr_utility.set_location('Leaving: '|| l_proc, 10);
1119:
1120: end chk_rating_scale;
1121:
1122:

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

1166: from per_appraisals
1167: where appraisal_template_id = p_appraisal_template_id;
1168:
1169: begin
1170: hr_utility.set_location('Entering:'|| l_proc, 1);
1171:
1172: -- Check mandatory parameters have been set
1173:
1174: hr_api.mandatory_arg_error

Line 1181: hr_utility.set_location('Entering:'|| l_proc, 2);

1177: ,p_argument_value => p_appraisal_template_id
1178: );
1179:
1180:
1181: hr_utility.set_location('Entering:'|| l_proc, 2);
1182:
1183: open csr_template_delete;
1184: fetch csr_template_delete into l_exists;
1185: if csr_template_delete%found then

Line 1187: hr_utility.set_message(801,'HR_51933_APT_EXIST_IN_APR');

1183: open csr_template_delete;
1184: fetch csr_template_delete into l_exists;
1185: if csr_template_delete%found then
1186: close csr_template_delete;
1187: hr_utility.set_message(801,'HR_51933_APT_EXIST_IN_APR');
1188: hr_utility.raise_error;
1189: end if;
1190: close csr_template_delete;
1191:

Line 1188: hr_utility.raise_error;

1184: fetch csr_template_delete into l_exists;
1185: if csr_template_delete%found then
1186: close csr_template_delete;
1187: hr_utility.set_message(801,'HR_51933_APT_EXIST_IN_APR');
1188: hr_utility.raise_error;
1189: end if;
1190: close csr_template_delete;
1191:
1192: hr_utility.set_location('Leaving: '|| l_proc, 10);

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

1188: hr_utility.raise_error;
1189: end if;
1190: close csr_template_delete;
1191:
1192: hr_utility.set_location('Leaving: '|| l_proc, 10);
1193:
1194: end chk_template_delete;
1195:
1196: --------------------------------------------------------------------------+

Line 1249: hr_utility.trace('Inside the chk_update_comp_profile procedure');

1245: --
1246: begin
1247: -- Bug#885806
1248: -- dbms_output.put_line('Inside the chk_display_assessment_comments procedure');
1249: hr_utility.trace('Inside the chk_update_comp_profile procedure');
1250: hr_utility.set_location('Entering:'|| l_proc, 1);
1251:
1252: if ( p_assessment_type_id is null and p_update_personal_comp_profile is not null ) then
1253: hr_utility.set_location(l_proc, 2);

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

1246: begin
1247: -- Bug#885806
1248: -- dbms_output.put_line('Inside the chk_display_assessment_comments procedure');
1249: hr_utility.trace('Inside the chk_update_comp_profile procedure');
1250: hr_utility.set_location('Entering:'|| l_proc, 1);
1251:
1252: if ( p_assessment_type_id is null and p_update_personal_comp_profile is not null ) then
1253: hr_utility.set_location(l_proc, 2);
1254: hr_utility.set_message(800,'HR_APT_AST_REQUIRED_MSG');

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

1249: hr_utility.trace('Inside the chk_update_comp_profile procedure');
1250: hr_utility.set_location('Entering:'|| l_proc, 1);
1251:
1252: if ( p_assessment_type_id is null and p_update_personal_comp_profile is not null ) then
1253: hr_utility.set_location(l_proc, 2);
1254: hr_utility.set_message(800,'HR_APT_AST_REQUIRED_MSG');
1255: hr_utility.raise_error;
1256:
1257: end if;

Line 1254: hr_utility.set_message(800,'HR_APT_AST_REQUIRED_MSG');

1250: hr_utility.set_location('Entering:'|| l_proc, 1);
1251:
1252: if ( p_assessment_type_id is null and p_update_personal_comp_profile is not null ) then
1253: hr_utility.set_location(l_proc, 2);
1254: hr_utility.set_message(800,'HR_APT_AST_REQUIRED_MSG');
1255: hr_utility.raise_error;
1256:
1257: end if;
1258: --

Line 1255: hr_utility.raise_error;

1251:
1252: if ( p_assessment_type_id is null and p_update_personal_comp_profile is not null ) then
1253: hr_utility.set_location(l_proc, 2);
1254: hr_utility.set_message(800,'HR_APT_AST_REQUIRED_MSG');
1255: hr_utility.raise_error;
1256:
1257: end if;
1258: --
1259: -- Check mandatory parameters have been set

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

1279: <> nvl(p_update_personal_comp_profile, hr_api.g_varchar2))
1280: or
1281: (NOT l_api_updating)) then
1282: --
1283: hr_utility.set_location(l_proc, 5);
1284: --
1285: -- Check the value in p_display_assessment_comments exists in hr_lookups
1286: --
1287: if hr_api.not_exists_in_hr_lookups

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

1288: (p_effective_date => p_effective_date
1289: ,p_lookup_type => 'YES_NO'
1290: ,p_lookup_code => p_update_personal_comp_profile
1291: ) then
1292: hr_utility.set_location(l_proc, 10);
1293: hr_utility.set_message(801,'HR_APT_UPD_COMP_PROF_INVAL');
1294: hr_utility.raise_error;
1295: end if;
1296: --

Line 1293: hr_utility.set_message(801,'HR_APT_UPD_COMP_PROF_INVAL');

1289: ,p_lookup_type => 'YES_NO'
1290: ,p_lookup_code => p_update_personal_comp_profile
1291: ) then
1292: hr_utility.set_location(l_proc, 10);
1293: hr_utility.set_message(801,'HR_APT_UPD_COMP_PROF_INVAL');
1294: hr_utility.raise_error;
1295: end if;
1296: --
1297: hr_utility.set_location(' Leaving:'|| l_proc, 15);

Line 1294: hr_utility.raise_error;

1290: ,p_lookup_code => p_update_personal_comp_profile
1291: ) then
1292: hr_utility.set_location(l_proc, 10);
1293: hr_utility.set_message(801,'HR_APT_UPD_COMP_PROF_INVAL');
1294: hr_utility.raise_error;
1295: end if;
1296: --
1297: hr_utility.set_location(' Leaving:'|| l_proc, 15);
1298: end if;

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

1293: hr_utility.set_message(801,'HR_APT_UPD_COMP_PROF_INVAL');
1294: hr_utility.raise_error;
1295: end if;
1296: --
1297: hr_utility.set_location(' Leaving:'|| l_proc, 15);
1298: end if;
1299: end chk_update_comp_profile;
1300:
1301: --------------------------------------------------------------------------+

Line 1354: hr_utility.trace('Inside the chk_comp_profile_source_type procedure');

1350: --
1351: begin
1352: -- Bug#885806
1353: -- dbms_output.put_line('Inside the chk_display_assessment_comments procedure');
1354: hr_utility.trace('Inside the chk_comp_profile_source_type procedure');
1355: hr_utility.set_location('Entering:'|| l_proc, 1);
1356:
1357: if ( p_comp_profile_source_type is not null and ( p_update_personal_comp_profile is null or p_update_personal_comp_profile = 'N') ) then
1358: hr_utility.set_location(l_proc, 2);

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

1351: begin
1352: -- Bug#885806
1353: -- dbms_output.put_line('Inside the chk_display_assessment_comments procedure');
1354: hr_utility.trace('Inside the chk_comp_profile_source_type procedure');
1355: hr_utility.set_location('Entering:'|| l_proc, 1);
1356:
1357: if ( p_comp_profile_source_type is not null and ( p_update_personal_comp_profile is null or p_update_personal_comp_profile = 'N') ) then
1358: hr_utility.set_location(l_proc, 2);
1359: hr_utility.set_message(800,'HR_APT_UPD_COMP_PROF_REQUIRED');

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

1354: hr_utility.trace('Inside the chk_comp_profile_source_type procedure');
1355: hr_utility.set_location('Entering:'|| l_proc, 1);
1356:
1357: if ( p_comp_profile_source_type is not null and ( p_update_personal_comp_profile is null or p_update_personal_comp_profile = 'N') ) then
1358: hr_utility.set_location(l_proc, 2);
1359: hr_utility.set_message(800,'HR_APT_UPD_COMP_PROF_REQUIRED');
1360: hr_utility.raise_error;
1361: end if;
1362: --

Line 1359: hr_utility.set_message(800,'HR_APT_UPD_COMP_PROF_REQUIRED');

1355: hr_utility.set_location('Entering:'|| l_proc, 1);
1356:
1357: if ( p_comp_profile_source_type is not null and ( p_update_personal_comp_profile is null or p_update_personal_comp_profile = 'N') ) then
1358: hr_utility.set_location(l_proc, 2);
1359: hr_utility.set_message(800,'HR_APT_UPD_COMP_PROF_REQUIRED');
1360: hr_utility.raise_error;
1361: end if;
1362: --
1363: -- Check mandatory parameters have been set

Line 1360: hr_utility.raise_error;

1356:
1357: if ( p_comp_profile_source_type is not null and ( p_update_personal_comp_profile is null or p_update_personal_comp_profile = 'N') ) then
1358: hr_utility.set_location(l_proc, 2);
1359: hr_utility.set_message(800,'HR_APT_UPD_COMP_PROF_REQUIRED');
1360: hr_utility.raise_error;
1361: end if;
1362: --
1363: -- Check mandatory parameters have been set
1364: --

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

1383: <> nvl(p_comp_profile_source_type, hr_api.g_varchar2))
1384: or
1385: (NOT l_api_updating)) then
1386: --
1387: hr_utility.set_location(l_proc, 5);
1388: --
1389: -- Check the value in p_display_assessment_comments exists in hr_lookups
1390: --
1391: if hr_api.not_exists_in_hr_lookups

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

1392: (p_effective_date => p_effective_date
1393: ,p_lookup_type => 'PROFICIENCY_SOURCE'
1394: ,p_lookup_code => p_comp_profile_source_type
1395: ) then
1396: hr_utility.set_location(l_proc, 10);
1397: hr_utility.set_message(800,'HR_APT_COMP_PROF_SRC_INVAL');
1398: hr_utility.raise_error;
1399: end if;
1400: --

Line 1397: hr_utility.set_message(800,'HR_APT_COMP_PROF_SRC_INVAL');

1393: ,p_lookup_type => 'PROFICIENCY_SOURCE'
1394: ,p_lookup_code => p_comp_profile_source_type
1395: ) then
1396: hr_utility.set_location(l_proc, 10);
1397: hr_utility.set_message(800,'HR_APT_COMP_PROF_SRC_INVAL');
1398: hr_utility.raise_error;
1399: end if;
1400: --
1401: hr_utility.set_location(' Leaving:'|| l_proc, 15);

Line 1398: hr_utility.raise_error;

1394: ,p_lookup_code => p_comp_profile_source_type
1395: ) then
1396: hr_utility.set_location(l_proc, 10);
1397: hr_utility.set_message(800,'HR_APT_COMP_PROF_SRC_INVAL');
1398: hr_utility.raise_error;
1399: end if;
1400: --
1401: hr_utility.set_location(' Leaving:'|| l_proc, 15);
1402: end if;

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

1397: hr_utility.set_message(800,'HR_APT_COMP_PROF_SRC_INVAL');
1398: hr_utility.raise_error;
1399: end if;
1400: --
1401: hr_utility.set_location(' Leaving:'|| l_proc, 15);
1402: end if;
1403: end chk_comp_profile_source_type;
1404:
1405: --------------------------------------------------------------------------+

Line 1453: hr_utility.trace('Inside the chk_link_appr_to_learning_path procedure');

1449: --
1450: begin
1451: -- Bug#885806
1452: -- dbms_output.put_line('Inside the chk_display_assessment_comments procedure');
1453: hr_utility.trace('Inside the chk_link_appr_to_learning_path procedure');
1454: hr_utility.set_location('Entering:'|| l_proc, 1);
1455:
1456:
1457: --

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

1450: begin
1451: -- Bug#885806
1452: -- dbms_output.put_line('Inside the chk_display_assessment_comments procedure');
1453: hr_utility.trace('Inside the chk_link_appr_to_learning_path procedure');
1454: hr_utility.set_location('Entering:'|| l_proc, 1);
1455:
1456:
1457: --
1458: -- Check mandatory parameters have been set

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

1478: <> nvl(p_link_appr_to_learning_path, hr_api.g_varchar2))
1479: or
1480: (NOT l_api_updating)) then
1481: --
1482: hr_utility.set_location(l_proc, 5);
1483: --
1484: -- Check the value in p_link_appr_to_learning_path exists in hr_lookups
1485: --
1486: if hr_api.not_exists_in_hr_lookups

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

1487: (p_effective_date => p_effective_date
1488: ,p_lookup_type => 'YES_NO'
1489: ,p_lookup_code => p_link_appr_to_learning_path
1490: ) then
1491: hr_utility.set_location(l_proc, 10);
1492: hr_utility.set_message(800,'HR_APT_LINK_TO_LP_INVAL');
1493: hr_utility.raise_error;
1494: end if;
1495: --

Line 1492: hr_utility.set_message(800,'HR_APT_LINK_TO_LP_INVAL');

1488: ,p_lookup_type => 'YES_NO'
1489: ,p_lookup_code => p_link_appr_to_learning_path
1490: ) then
1491: hr_utility.set_location(l_proc, 10);
1492: hr_utility.set_message(800,'HR_APT_LINK_TO_LP_INVAL');
1493: hr_utility.raise_error;
1494: end if;
1495: --
1496: hr_utility.set_location(' Leaving:'|| l_proc, 15);

Line 1493: hr_utility.raise_error;

1489: ,p_lookup_code => p_link_appr_to_learning_path
1490: ) then
1491: hr_utility.set_location(l_proc, 10);
1492: hr_utility.set_message(800,'HR_APT_LINK_TO_LP_INVAL');
1493: hr_utility.raise_error;
1494: end if;
1495: --
1496: hr_utility.set_location(' Leaving:'|| l_proc, 15);
1497: end if;

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

1492: hr_utility.set_message(800,'HR_APT_LINK_TO_LP_INVAL');
1493: hr_utility.raise_error;
1494: end if;
1495: --
1496: hr_utility.set_location(' Leaving:'|| l_proc, 15);
1497: end if;
1498: end chk_link_appr_to_learning_path;
1499:
1500: --------------------------------------------------------------------------+

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

1544: --
1545: begin
1546: -- Bug#885806
1547: -- dbms_output.put_line('Inside the chk_display_assessment_comments procedure');
1548: hr_utility.trace('Inside the chk_available_flag procedure');
1549: hr_utility.set_location('Entering:'|| l_proc, 1);
1550:
1551:
1552: --

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

1545: begin
1546: -- Bug#885806
1547: -- dbms_output.put_line('Inside the chk_display_assessment_comments procedure');
1548: hr_utility.trace('Inside the chk_available_flag procedure');
1549: hr_utility.set_location('Entering:'|| l_proc, 1);
1550:
1551:
1552: --
1553: -- Check mandatory parameters have been set

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

1573: <> nvl(p_available_flag, hr_api.g_varchar2))
1574: or
1575: (NOT l_api_updating)) then
1576: --
1577: hr_utility.set_location(l_proc, 5);
1578: --
1579: -- Check the value in p_available_flag exists in hr_lookups
1580: --
1581: if hr_api.not_exists_in_hr_lookups

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

1582: (p_effective_date => p_effective_date
1583: ,p_lookup_type => 'TEMPLATE_AVAILABILITY_FLAG'
1584: ,p_lookup_code => p_available_flag
1585: ) then
1586: hr_utility.set_location(l_proc, 10);
1587: hr_utility.set_message(800,'HR_AVAIL_FLAG_INVAL');
1588: hr_utility.raise_error;
1589: end if;
1590: --

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

1583: ,p_lookup_type => 'TEMPLATE_AVAILABILITY_FLAG'
1584: ,p_lookup_code => p_available_flag
1585: ) then
1586: hr_utility.set_location(l_proc, 10);
1587: hr_utility.set_message(800,'HR_AVAIL_FLAG_INVAL');
1588: hr_utility.raise_error;
1589: end if;
1590: --
1591: hr_utility.set_location(' Leaving:'|| l_proc, 15);

Line 1588: hr_utility.raise_error;

1584: ,p_lookup_code => p_available_flag
1585: ) then
1586: hr_utility.set_location(l_proc, 10);
1587: hr_utility.set_message(800,'HR_AVAIL_FLAG_INVAL');
1588: hr_utility.raise_error;
1589: end if;
1590: --
1591: hr_utility.set_location(' Leaving:'|| l_proc, 15);
1592: end if;

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

1587: hr_utility.set_message(800,'HR_AVAIL_FLAG_INVAL');
1588: hr_utility.raise_error;
1589: end if;
1590: --
1591: hr_utility.set_location(' Leaving:'|| l_proc, 15);
1592: end if;
1593: end chk_available_flag;
1594: -- ----------------------------------------------------------------------+
1595: -- |------------------------------< chk_df >-----------------------------+

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

1623:
1624: l_proc varchar2(72) := g_package||'chk_df';
1625:
1626: begin
1627: hr_utility.set_location('Entering:'||l_proc, 10);
1628:
1629: if ((p_rec.appraisal_template_id is not null) and (
1630: nvl(per_apt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1631: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

1723: ,p_attribute20_value => p_rec.attribute20
1724: );
1725: end if;
1726:
1727: hr_utility.set_location(' Leaving:'||l_proc, 20);
1728:
1729: end chk_df;
1730:
1731: -- ---------------------------------------------------------------------------+

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

1736:
1737: l_proc varchar2(72) := g_package||'insert_validate';
1738:
1739: Begin
1740: hr_utility.set_location('Entering:'||l_proc, 5);
1741:
1742: -- Call all supporting business operations
1743: if p_rec.business_group_id is not null then
1744: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

Line 1862: hr_utility.set_location(' Leaving:'||l_proc, 45);

1858: -- Call descriptive flexfield validation routines
1859:
1860: per_apt_bus.chk_df(p_rec => p_rec);
1861:
1862: hr_utility.set_location(' Leaving:'||l_proc, 45);
1863:
1864: hr_utility.set_location(' Leaving:'||l_proc, 10);
1865: End insert_validate;
1866:

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

1860: per_apt_bus.chk_df(p_rec => p_rec);
1861:
1862: hr_utility.set_location(' Leaving:'||l_proc, 45);
1863:
1864: hr_utility.set_location(' Leaving:'||l_proc, 10);
1865: End insert_validate;
1866:
1867: -- ---------------------------------------------------------------------------+
1868: -- |---------------------------< update_validate >----------------------------|

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

1872:
1873: l_proc varchar2(72) := g_package||'update_validate';
1874:
1875: Begin
1876: hr_utility.set_location('Entering:'||l_proc, 5);
1877:
1878: -- Call all supporting business operations
1879:
1880: if p_rec.business_group_id is not null then

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

1996: ,p_object_version_number => p_rec.object_version_number
1997: ,p_appraisal_template_id => p_rec.appraisal_template_id
1998: );
1999: end if;
2000: hr_utility.set_location(' Leaving:'||l_proc, 10);
2001:
2002: -- Call descriptive flexfield validation routines
2003:
2004: per_apt_bus.chk_df(p_rec => p_rec);

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

2002: -- Call descriptive flexfield validation routines
2003:
2004: per_apt_bus.chk_df(p_rec => p_rec);
2005:
2006: hr_utility.set_location(' Leaving:'||l_proc, 15);
2007: End update_validate;
2008:
2009: -- ---------------------------------------------------------------------------+
2010: -- |---------------------------< delete_validate >----------------------------|

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

2013:
2014: l_proc varchar2(72) := g_package||'delete_validate';
2015:
2016: Begin
2017: hr_utility.set_location('Entering:'||l_proc, 5);
2018:
2019: -- Call all supporting business operations
2020:
2021: per_apt_bus.chk_template_delete

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

2022: (p_appraisal_template_id => p_rec.appraisal_template_id
2023: ,p_object_version_number => p_rec.object_version_number
2024: );
2025:
2026: hr_utility.set_location(' Leaving:'||l_proc, 10);
2027: End delete_validate;
2028:
2029: -- ---------------------------------------------------------------------------+
2030: -- |-----------------------< return_legislation_code >------------------------|

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

2045: l_proc varchar2(72) := g_package||'return_legislation_code';
2046: l_legislation_code varchar2(150);
2047:
2048: Begin
2049: hr_utility.set_location('Entering:'||l_proc, 5);
2050:
2051: -- Ensure that all the mandatory parameters are not null
2052:
2053: hr_api.mandatory_arg_error (p_api_name => l_proc,

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

2060: -- call to this function. Just return the value in the global
2061: -- variable.
2062:
2063: l_legislation_code := g_legislation_code;
2064: hr_utility.set_location(l_proc, 20);
2065: else
2066:
2067: -- The ID is different to the last call to this function
2068: -- or this is the first call to this function.

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

2074: close csr_leg_code;
2075:
2076: -- The primary key is invalid therefore we must error out
2077:
2078: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2079: hr_utility.raise_error;
2080: end if;
2081:
2082: close csr_leg_code;

Line 2079: hr_utility.raise_error;

2075:
2076: -- The primary key is invalid therefore we must error out
2077:
2078: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2079: hr_utility.raise_error;
2080: end if;
2081:
2082: close csr_leg_code;
2083: g_appraisal_template_id := p_appraisal_template_id;

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

2082: close csr_leg_code;
2083: g_appraisal_template_id := p_appraisal_template_id;
2084: g_legislation_code := l_legislation_code;
2085: end if;
2086: hr_utility.set_location(' Leaving:'||l_proc, 10);
2087: return l_legislation_code;
2088:
2089:
2090: End return_legislation_code;