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

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

18: l_error exception;
19: l_argument varchar2(30);
20:
21: begin
22: hr_utility.set_location('Entering:'||l_proc, 10);
23:
24: -- Only proceed with validation if a row exists for the current record
25: -- in the HR schema
26:

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

27: if not per_prt_shd.api_updating
28: (p_performance_rating_id => p_rec.performance_rating_id
29: ,p_object_version_number => p_rec.object_version_number
30: ) then
31: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
32: hr_utility.set_message_token('PROCEDURE', l_proc);
33: hr_utility.set_message_token('STEP', 20);
34: end if;
35:

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

28: (p_performance_rating_id => p_rec.performance_rating_id
29: ,p_object_version_number => p_rec.object_version_number
30: ) then
31: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
32: hr_utility.set_message_token('PROCEDURE', l_proc);
33: hr_utility.set_message_token('STEP', 20);
34: end if;
35:
36: hr_utility.set_location(l_proc, 30);

Line 33: hr_utility.set_message_token('STEP', 20);

29: ,p_object_version_number => p_rec.object_version_number
30: ) then
31: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
32: hr_utility.set_message_token('PROCEDURE', l_proc);
33: hr_utility.set_message_token('STEP', 20);
34: end if;
35:
36: hr_utility.set_location(l_proc, 30);
37:

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

32: hr_utility.set_message_token('PROCEDURE', l_proc);
33: hr_utility.set_message_token('STEP', 20);
34: end if;
35:
36: hr_utility.set_location(l_proc, 30);
37:
38: if p_rec.appraisal_id <> per_prt_shd.g_old_rec.appraisal_id then
39: l_argument := 'appraisal_id';
40: raise l_error;

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

39: l_argument := 'appraisal_id';
40: raise l_error;
41: end if;
42:
43: hr_utility.set_location(l_proc, 40);
44:
45: if p_rec.objective_id <> per_prt_shd.g_old_rec.objective_id then
46: l_argument := 'objective_id';
47: raise l_error;

Line 59: hr_utility.set_location(' Leaving:'||l_proc, 50);

55: ,p_argument => l_argument
56: ,p_base_table => per_prt_shd.g_tab_nam);
57: when others then
58: raise;
59: hr_utility.set_location(' Leaving:'||l_proc, 50);
60: end chk_non_updateable_args;
61:
62:
63: -- -------------------------------------------------------------------+

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

109: where appraisal_id = p_appraisal_id;
110:
111: begin
112:
113: hr_utility.set_location('Entering:'|| l_proc, 10);
114:
115: if p_appraisal_id is null then
116: hr_utility.set_message(801, 'HR_51918_PRT_APR_MANDATORY');
117: hr_utility.raise_error;

Line 116: hr_utility.set_message(801, 'HR_51918_PRT_APR_MANDATORY');

112:
113: hr_utility.set_location('Entering:'|| l_proc, 10);
114:
115: if p_appraisal_id is null then
116: hr_utility.set_message(801, 'HR_51918_PRT_APR_MANDATORY');
117: hr_utility.raise_error;
118: end if;
119:
120: hr_utility.set_location(l_proc, 20);

Line 117: hr_utility.raise_error;

113: hr_utility.set_location('Entering:'|| l_proc, 10);
114:
115: if p_appraisal_id is null then
116: hr_utility.set_message(801, 'HR_51918_PRT_APR_MANDATORY');
117: hr_utility.raise_error;
118: end if;
119:
120: hr_utility.set_location(l_proc, 20);
121:

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

116: hr_utility.set_message(801, 'HR_51918_PRT_APR_MANDATORY');
117: hr_utility.raise_error;
118: end if;
119:
120: hr_utility.set_location(l_proc, 20);
121:
122: l_api_updating := per_prt_shd.api_updating
123: (p_performance_rating_id => p_performance_rating_id
124: ,p_object_version_number => p_object_version_number);

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

135: fetch csr_id_exists into l_exists;
136:
137: if csr_id_exists%notfound then
138: close csr_id_exists;
139: hr_utility.set_message(801, 'HR_51919_PRT_APR_NOT_EXIST');
140: hr_utility.raise_error;
141: end if;
142:
143: close csr_id_exists;

Line 140: hr_utility.raise_error;

136:
137: if csr_id_exists%notfound then
138: close csr_id_exists;
139: hr_utility.set_message(801, 'HR_51919_PRT_APR_NOT_EXIST');
140: hr_utility.raise_error;
141: end if;
142:
143: close csr_id_exists;
144:

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

142:
143: close csr_id_exists;
144:
145: end if;
146: hr_utility.set_location(' Leaving:'|| l_proc, 30);
147: exception
148: when app_exception.application_exception then
149: if hr_multi_message.exception_add
150: (p_associated_column1 => 'PER_PERFORMANCE_RATINGS.APPRAISAL_ID'

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

231: and appraisal_id = p_appraisal_id;
232:
233: begin
234:
235: hr_utility.set_location('Entering:'|| l_proc, 10);
236:
237: hr_api.mandatory_arg_error
238: (p_api_name => l_proc
239: ,p_argument => 'appraisal_id'

Line 244: hr_utility.set_message(801, 'HR_51920_PRT_OBJ_MANDATORY');

240: ,p_argument_value => p_appraisal_id
241: );
242:
243: if p_objective_id is null then
244: hr_utility.set_message(801, 'HR_51920_PRT_OBJ_MANDATORY');
245: hr_utility.raise_error;
246: end if;
247:
248: hr_utility.set_location(l_proc, 20);

Line 245: hr_utility.raise_error;

241: );
242:
243: if p_objective_id is null then
244: hr_utility.set_message(801, 'HR_51920_PRT_OBJ_MANDATORY');
245: hr_utility.raise_error;
246: end if;
247:
248: hr_utility.set_location(l_proc, 20);
249:

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

244: hr_utility.set_message(801, 'HR_51920_PRT_OBJ_MANDATORY');
245: hr_utility.raise_error;
246: end if;
247:
248: hr_utility.set_location(l_proc, 20);
249:
250: l_api_updating := per_prt_shd.api_updating
251: (p_performance_rating_id => p_performance_rating_id
252: ,p_object_version_number => p_object_version_number);

Line 267: hr_utility.set_message(801, 'HR_51921_PRT_OBJ_NOT_EXIST');

263: fetch csr_id_exists into l_business_group_id;
264:
265: if csr_id_exists%notfound then
266: close csr_id_exists;
267: hr_utility.set_message(801, 'HR_51921_PRT_OBJ_NOT_EXIST');
268: hr_utility.raise_error;
269: end if;
270:
271: close csr_id_exists;

Line 268: hr_utility.raise_error;

264:
265: if csr_id_exists%notfound then
266: close csr_id_exists;
267: hr_utility.set_message(801, 'HR_51921_PRT_OBJ_NOT_EXIST');
268: hr_utility.raise_error;
269: end if;
270:
271: close csr_id_exists;
272:

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

269: end if;
270:
271: close csr_id_exists;
272:
273: hr_utility.set_location(l_proc, 30);
274:
275: -- Check the business group
276:
277: open csr_bg_exists(l_business_group_id);

Line 283: hr_utility.set_message(801, 'HR_51922_PRT_OBJ_DIFF_BUS_GRP');

279: fetch csr_bg_exists into l_exists;
280:
281: if csr_bg_exists%notfound then
282: close csr_bg_exists;
283: hr_utility.set_message(801, 'HR_51922_PRT_OBJ_DIFF_BUS_GRP');
284: hr_utility.raise_error;
285: end if;
286:
287: close csr_bg_exists;

Line 284: hr_utility.raise_error;

280:
281: if csr_bg_exists%notfound then
282: close csr_bg_exists;
283: hr_utility.set_message(801, 'HR_51922_PRT_OBJ_DIFF_BUS_GRP');
284: hr_utility.raise_error;
285: end if;
286:
287: close csr_bg_exists;
288:

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

285: end if;
286:
287: close csr_bg_exists;
288:
289: hr_utility.set_location(l_proc, 40);
290:
291: hr_utility.set_location(l_proc, 60);
292:
293: /*

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

287: close csr_bg_exists;
288:
289: hr_utility.set_location(l_proc, 40);
290:
291: hr_utility.set_location(l_proc, 60);
292:
293: /*
294: Disable this check as we support multiple entries
295: in this table marked by PERSON_ID

Line 302: hr_utility.set_message(801, 'HR_51924_PRT_OBJ_NOT_UNIQUE');

298: fetch csr_objective_id_exists into l_exists;
299:
300: if csr_objective_id_exists%found then
301: close csr_objective_id_exists;
302: hr_utility.set_message(801, 'HR_51924_PRT_OBJ_NOT_UNIQUE');
303: hr_utility.raise_error;
304: end if;
305:
306: close csr_objective_id_exists;

Line 303: hr_utility.raise_error;

299:
300: if csr_objective_id_exists%found then
301: close csr_objective_id_exists;
302: hr_utility.set_message(801, 'HR_51924_PRT_OBJ_NOT_UNIQUE');
303: hr_utility.raise_error;
304: end if;
305:
306: close csr_objective_id_exists;
307: */

Line 309: hr_utility.set_location(' Leaving:'|| l_proc, 70);

305:
306: close csr_objective_id_exists;
307: */
308: end if; -- api_updating
309: hr_utility.set_location(' Leaving:'|| l_proc, 70);
310: exception
311: when app_exception.application_exception then
312: if hr_multi_message.exception_add
313: (p_associated_column1 => 'PER_PERFORMANCE_RATINGS.OBJECTIVE_ID'

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

402: and r.rating_level_id = p_performance_level_id;
403:
404: begin
405:
406: hr_utility.set_location('Entering:'|| l_proc, 10);
407:
408: hr_api.mandatory_arg_error
409: (p_api_name => l_proc
410: ,p_argument => 'appraisal_id'

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

416: l_api_updating := per_prt_shd.api_updating
417: (p_performance_rating_id => p_performance_rating_id
418: ,p_object_version_number => p_object_version_number);
419:
420: hr_utility.set_location(l_proc, 20);
421:
422: -- Only proceed with validation if:
423: -- a) The current g_old_rec is current and
424: -- b) The value for the rating_level_id has changed

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

428: <> nvl(p_performance_level_id, hr_api.g_number))
429: or (not l_api_updating))
430: then
431:
432: hr_utility.set_location(l_proc, 30);
433: IF p_performance_level_id IS NOT NULL THEN
434:
435: open csr_id_exists;
436:

Line 441: hr_utility.set_message(801, 'HR_51925_PRT_RLI_NOT_EXIST');

437: fetch csr_id_exists into l_business_group_id;
438:
439: if csr_id_exists%notfound then
440: close csr_id_exists;
441: hr_utility.set_message(801, 'HR_51925_PRT_RLI_NOT_EXIST');
442: hr_utility.raise_error;
443: end if;
444:
445: close csr_id_exists;

Line 442: hr_utility.raise_error;

438:
439: if csr_id_exists%notfound then
440: close csr_id_exists;
441: hr_utility.set_message(801, 'HR_51925_PRT_RLI_NOT_EXIST');
442: hr_utility.raise_error;
443: end if;
444:
445: close csr_id_exists;
446: END IF;

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

443: end if;
444:
445: close csr_id_exists;
446: END IF;
447: hr_utility.set_location(l_proc, 40);
448: -- ngundura changes done for pa requirements
449: -- put this if conditions
450: if l_business_group_id is not null then
451: open csr_bg_exists(l_business_group_id);

Line 455: hr_utility.set_message(801, 'HR_51926_PRT_RLI_DIFF_BUS_GRP');

451: open csr_bg_exists(l_business_group_id);
452:
453: if csr_bg_exists%notfound then
454: close csr_bg_exists;
455: hr_utility.set_message(801, 'HR_51926_PRT_RLI_DIFF_BUS_GRP');
456: hr_utility.raise_error;
457: end if;
458:
459: close csr_bg_exists;

Line 456: hr_utility.raise_error;

452:
453: if csr_bg_exists%notfound then
454: close csr_bg_exists;
455: hr_utility.set_message(801, 'HR_51926_PRT_RLI_DIFF_BUS_GRP');
456: hr_utility.raise_error;
457: end if;
458:
459: close csr_bg_exists;
460: end if;

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

458:
459: close csr_bg_exists;
460: end if;
461: -- ngundura end of changes
462: hr_utility.set_location(l_proc, 50);
463:
464: end if;
465:
466: hr_utility.set_location(l_proc, 60);

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

462: hr_utility.set_location(l_proc, 50);
463:
464: end if;
465:
466: hr_utility.set_location(l_proc, 60);
467:
468: l_api_updating := per_prt_shd.api_updating
469: (p_performance_rating_id => p_performance_rating_id
470: ,p_object_version_number => p_object_version_number);

Line 472: hr_utility.set_location(l_proc, 70);

468: l_api_updating := per_prt_shd.api_updating
469: (p_performance_rating_id => p_performance_rating_id
470: ,p_object_version_number => p_object_version_number);
471:
472: hr_utility.set_location(l_proc, 70);
473:
474: -- Only proceed with validation if:
475: -- a) The current g_old_rec is current and
476: -- b) The value for the rating_level_id has changed

Line 484: hr_utility.set_location(l_proc, 80);

480: <> nvl(p_performance_level_id, hr_api.g_number))
481: or (not l_api_updating))
482: then
483:
484: hr_utility.set_location(l_proc, 80);
485: IF p_performance_level_id IS NOT NULL THEN
486:
487: open csr_check_rating_scale_id;
488:

Line 493: hr_utility.set_message(801, 'HR_51927_PRT_RSI_NOT_EXIST');

489: fetch csr_check_rating_scale_id into l_exists;
490:
491: if csr_check_rating_scale_id%notfound then
492: close csr_check_rating_scale_id;
493: hr_utility.set_message(801, 'HR_51927_PRT_RSI_NOT_EXIST');
494: hr_utility.raise_error;
495: end if;
496:
497: close csr_check_rating_scale_id;

Line 494: hr_utility.raise_error;

490:
491: if csr_check_rating_scale_id%notfound then
492: close csr_check_rating_scale_id;
493: hr_utility.set_message(801, 'HR_51927_PRT_RSI_NOT_EXIST');
494: hr_utility.raise_error;
495: end if;
496:
497: close csr_check_rating_scale_id;
498: END IF;

Line 499: hr_utility.set_location(l_proc, 90);

495: end if;
496:
497: close csr_check_rating_scale_id;
498: END IF;
499: hr_utility.set_location(l_proc, 90);
500:
501: end if;
502:
503: hr_utility.set_location(' Leaving:'|| l_proc, 100);

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

499: hr_utility.set_location(l_proc, 90);
500:
501: end if;
502:
503: hr_utility.set_location(' Leaving:'|| l_proc, 100);
504: exception
505: when app_exception.application_exception then
506: if hr_multi_message.exception_add
507: (p_associated_column1 => 'PER_PERFORMANCE_RATINGS.PERFORMANCE_LEVEL_ID'

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

567: and ppr.person_id = p_person_id;
568:
569: begin
570:
571: hr_utility.set_location('Entering:'|| l_proc, 10);
572:
573: hr_api.mandatory_arg_error
574: (p_api_name => l_proc
575: ,p_argument => 'appraisal_id'

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

575: ,p_argument => 'appraisal_id'
576: ,p_argument_value => p_appraisal_id
577: );
578:
579: hr_utility.set_location(l_proc, 20);
580:
581: -- Validate if the number rows for the combination of appraisal_id, objective_id
582: -- and person_id is 1
583:

Line 589: hr_utility.set_message(800, 'HR_DUPL_PERF_RATING');

585:
586: fetch csr_num_rows into l_exists;
587:
588: if nvl(l_exists,'N') = 'Y' then
589: hr_utility.set_message(800, 'HR_DUPL_PERF_RATING');
590: hr_utility.set_location('Appraisal Id:'|| p_appraisal_id, 22);
591: hr_utility.set_location('Objective Id:'|| p_objective_id, 24);
592: hr_utility.set_location('Person Id:'|| p_person_id, 26);
593: hr_utility.raise_error;

Line 590: hr_utility.set_location('Appraisal Id:'|| p_appraisal_id, 22);

586: fetch csr_num_rows into l_exists;
587:
588: if nvl(l_exists,'N') = 'Y' then
589: hr_utility.set_message(800, 'HR_DUPL_PERF_RATING');
590: hr_utility.set_location('Appraisal Id:'|| p_appraisal_id, 22);
591: hr_utility.set_location('Objective Id:'|| p_objective_id, 24);
592: hr_utility.set_location('Person Id:'|| p_person_id, 26);
593: hr_utility.raise_error;
594: end if;

Line 591: hr_utility.set_location('Objective Id:'|| p_objective_id, 24);

587:
588: if nvl(l_exists,'N') = 'Y' then
589: hr_utility.set_message(800, 'HR_DUPL_PERF_RATING');
590: hr_utility.set_location('Appraisal Id:'|| p_appraisal_id, 22);
591: hr_utility.set_location('Objective Id:'|| p_objective_id, 24);
592: hr_utility.set_location('Person Id:'|| p_person_id, 26);
593: hr_utility.raise_error;
594: end if;
595:

Line 592: hr_utility.set_location('Person Id:'|| p_person_id, 26);

588: if nvl(l_exists,'N') = 'Y' then
589: hr_utility.set_message(800, 'HR_DUPL_PERF_RATING');
590: hr_utility.set_location('Appraisal Id:'|| p_appraisal_id, 22);
591: hr_utility.set_location('Objective Id:'|| p_objective_id, 24);
592: hr_utility.set_location('Person Id:'|| p_person_id, 26);
593: hr_utility.raise_error;
594: end if;
595:
596: close csr_num_rows;

Line 593: hr_utility.raise_error;

589: hr_utility.set_message(800, 'HR_DUPL_PERF_RATING');
590: hr_utility.set_location('Appraisal Id:'|| p_appraisal_id, 22);
591: hr_utility.set_location('Objective Id:'|| p_objective_id, 24);
592: hr_utility.set_location('Person Id:'|| p_person_id, 26);
593: hr_utility.raise_error;
594: end if;
595:
596: close csr_num_rows;
597:

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

594: end if;
595:
596: close csr_num_rows;
597:
598: hr_utility.set_location('Leaving:'|| l_proc, 30);
599:
600: exception
601: when app_exception.application_exception then
602: if hr_multi_message.exception_add

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

644:
645: l_proc varchar2(72) := g_package||'chk_df';
646:
647: begin
648: hr_utility.set_location('Entering:'||l_proc, 10);
649:
650: if ((p_rec.performance_rating_id is not null) and (
651: nvl(per_prt_shd.g_old_rec.person_id, hr_api.g_number) <>
652: nvl(p_rec.person_id, hr_api.g_number) or

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

745: ,p_attribute20_name => 'ATTRIBUTE20'
746: ,p_attribute20_value => p_rec.attribute20);
747: end if;
748:
749: hr_utility.set_location(' Leaving:'||l_proc, 20);
750: end chk_df;
751:
752: -- ---------------------------------------------------------------------------+
753: -- |---------------------------< insert_validate >----------------------------|

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

756:
757: l_proc varchar2(72) := g_package||'insert_validate';
758:
759: Begin
760: hr_utility.set_location('Entering:'||l_proc, 10);
761:
762: per_apr_bus.set_security_group_id
763: (
764: p_appraisal_id => p_rec.appraisal_id

Line 770: hr_utility.set_location('Entering:'||l_proc, 15);

766:
767: --
768: hr_multi_message.end_validation_set;
769: --
770: hr_utility.set_location('Entering:'||l_proc, 15);
771:
772: -- Call all supporting business operations
773:
774: -- validate the appraisal_id

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

777: (p_appraisal_id => p_rec.appraisal_id
778: ,p_performance_rating_id => p_rec.performance_rating_id
779: ,p_object_version_number => p_rec.object_version_number);
780:
781: hr_utility.set_location(l_proc, 20);
782:
783: -- validate the objective_id
784:
785: per_prt_bus.chk_objective_id

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

787: ,p_appraisal_id => p_rec.appraisal_id
788: ,p_performance_rating_id => p_rec.performance_rating_id
789: ,p_object_version_number => p_rec.object_version_number);
790:
791: hr_utility.set_location(l_proc, 30);
792:
793:
794: -- validate performance_level_id
795:

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

798: ,p_performance_level_id => p_rec.performance_level_id
799: ,p_appraisal_id => p_rec.appraisal_id
800: ,p_object_version_number => p_rec.object_version_number);
801:
802: hr_utility.set_location(l_proc, 40);
803:
804: -- validate that there are no records in per_performance_ratings for the combination
805: -- of appraisal_id, objective_id and person_id
806:

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

809: ,p_objective_id => p_rec.objective_id
810: ,p_person_id => p_rec.person_id
811: ,p_object_version_number => p_rec.object_version_number);
812:
813: hr_utility.set_location(l_proc, 45);
814:
815: -- call descriptive flexfield validation routines
816:
817: per_prt_bus.chk_df(p_rec => p_rec);

Line 819: hr_utility.set_location(' Leaving:'||l_proc, 50);

815: -- call descriptive flexfield validation routines
816:
817: per_prt_bus.chk_df(p_rec => p_rec);
818:
819: hr_utility.set_location(' Leaving:'||l_proc, 50);
820:
821: End insert_validate;
822:
823: -- ---------------------------------------------------------------------------+

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

827:
828: l_proc varchar2(72) := g_package||'update_validate';
829:
830: Begin
831: hr_utility.set_location('Entering:'||l_proc, 10);
832:
833: per_apr_bus.set_security_group_id
834: (
835: p_appraisal_id => p_rec.appraisal_id

Line 842: hr_utility.set_location('Entering:'||l_proc, 15);

838: --
839: hr_multi_message.end_validation_set;
840: --
841:
842: hr_utility.set_location('Entering:'||l_proc, 15);
843:
844: -- Call all supporting business operations
845:
846: -- Check that the non-updateable columns have not changed

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

847:
848: chk_non_updateable_args(p_rec);
849:
850:
851: hr_utility.set_location(l_proc, 20);
852:
853: -- validate performance_level_id
854:
855: per_prt_bus.chk_performance_level_id

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

857: ,p_performance_level_id => p_rec.performance_level_id
858: ,p_appraisal_id => p_rec.appraisal_id
859: ,p_object_version_number => p_rec.object_version_number);
860:
861: hr_utility.set_location(l_proc, 30);
862:
863: -- call descriptive flexfield validation routines
864:
865: per_prt_bus.chk_df(p_rec => p_rec);

Line 867: hr_utility.set_location(' Leaving:'||l_proc, 50);

863: -- call descriptive flexfield validation routines
864:
865: per_prt_bus.chk_df(p_rec => p_rec);
866:
867: hr_utility.set_location(' Leaving:'||l_proc, 50);
868:
869: End update_validate;
870:
871: -- ---------------------------------------------------------------------------+

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

875:
876: l_proc varchar2(72) := g_package||'delete_validate';
877:
878: Begin
879: hr_utility.set_location('Entering:'||l_proc, 10);
880:
881: -- Call all supporting business operations
882:
883: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

879: hr_utility.set_location('Entering:'||l_proc, 10);
880:
881: -- Call all supporting business operations
882:
883: hr_utility.set_location(' Leaving:'||l_proc, 20);
884:
885: End delete_validate;
886:
887: -- ---------------------------------------------------------------------------+

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

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

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

919: close csr_leg_code;
920:
921: -- The primary key is invalid therefore we must error out
922:
923: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
924: hr_utility.raise_error;
925: end if;
926:
927: close csr_leg_code;

Line 924: hr_utility.raise_error;

920:
921: -- The primary key is invalid therefore we must error out
922:
923: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
924: hr_utility.raise_error;
925: end if;
926:
927: close csr_leg_code;
928: return l_legislation_code;

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

926:
927: close csr_leg_code;
928: return l_legislation_code;
929:
930: hr_utility.set_location(' Leaving:'||l_proc, 10);
931:
932: End return_legislation_code;
933:
934: