DBA Data[Home] [Help]

APPS.PER_PSH_BUS dependencies on HR_UTILITY

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

41: l_legislation_code varchar2(150);
42: --
43: begin
44: --
45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: --
47: -- Ensure that all the mandatory parameter are not null
48: --
49: hr_api.mandatory_arg_error

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

81: --
82: hr_api.set_legislation_context(l_legislation_code);
83: end if;
84: --
85: hr_utility.set_location(' Leaving:'|| l_proc, 20);
86: --
87: end set_security_group_id;
88: --
89: -- ---------------------------------------------------------------------------

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

112: l_proc varchar2(72) := g_package||'return_legislation_code';
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'|| l_proc, 10);
117: --
118: -- Ensure that all the mandatory parameter are not null
119: --
120: hr_api.mandatory_arg_error

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

130: -- call to this function. Just return the value in the global
131: -- variable.
132: --
133: l_legislation_code := per_psh_bus.g_legislation_code;
134: hr_utility.set_location(l_proc, 20);
135: else
136: --
137: -- The ID is different to the last call to this function
138: -- or this is the first call to this function.

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

147: close csr_leg_code;
148: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
149: fnd_message.raise_error;
150: end if;
151: hr_utility.set_location(l_proc,30);
152: --
153: -- Set the global variables so the values are
154: -- available for the next call to this function.
155: --

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

156: close csr_leg_code;
157: per_psh_bus.g_sharing_instance_id := p_sharing_instance_id;
158: per_psh_bus.g_legislation_code := l_legislation_code;
159: end if;
160: hr_utility.set_location(' Leaving:'|| l_proc, 40);
161: return l_legislation_code;
162: end return_legislation_code;
163: --
164: -- ----------------------------------------------------------------------------

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

195: --
196: l_proc varchar2(72) := g_package || 'chk_df';
197: --
198: begin
199: hr_utility.set_location('Entering:'||l_proc,10);
200: --
201: if ((p_rec.sharing_instance_id is not null) and (
202: nvl(per_psh_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
203: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

334: ,p_attribute30_value => p_rec.attribute30
335: );
336: end if;
337: --
338: hr_utility.set_location(' Leaving:'||l_proc,20);
339: end chk_df;
340: --
341: -- ----------------------------------------------------------------------------
342: -- |-----------------------< chk_non_updateable_args >------------------------|

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

409: WHERE psc.scorecard_id = p_scorecard_id;
410: --
411: BEGIN
412:
413: hr_utility.set_location('Entering:'|| l_proc, 10);
414:
415: --
416: -- Check mandatory parameters have been set
417: --

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

423: IF p_scorecard_id IS NOT null THEN
424: --
425: -- Check that scorecard exists.
426: --
427: hr_utility.set_location(l_proc, 20);
428: OPEN csr_chk_scard_id;
429: FETCH csr_chk_scard_id INTO l_scorecard_person_id;
430: CLOSE csr_chk_scard_id;
431: --

Line 446: hr_utility.set_location('Leaving:'|| l_proc, 970);

442: END IF;
443: --
444: END IF;
445: --
446: hr_utility.set_location('Leaving:'|| l_proc, 970);
447: --
448: EXCEPTION
449:
450: WHEN app_exception.application_exception THEN

Line 454: hr_utility.set_location(' Leaving:'|| l_proc, 980);

450: WHEN app_exception.application_exception THEN
451: IF hr_multi_message.exception_add
452: (p_associated_column1 => 'PER_SCORECARD_SHARING.SCORECARD_ID')
453: THEN
454: hr_utility.set_location(' Leaving:'|| l_proc, 980);
455: RAISE;
456: END IF;
457: hr_utility.set_location(' Leaving:'|| l_proc, 990);
458:

Line 457: hr_utility.set_location(' Leaving:'|| l_proc, 990);

453: THEN
454: hr_utility.set_location(' Leaving:'|| l_proc, 980);
455: RAISE;
456: END IF;
457: hr_utility.set_location(' Leaving:'|| l_proc, 990);
458:
459: END chk_scorecard_id;
460: --
461: -----------------------------------------------------------------------------

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

482: effective_start_date and nvl(effective_end_date,hr_api.g_eot);
483: --
484: --
485: begin
486: hr_utility.set_location('Entering:'|| l_proc, 1);
487: --
488: -- Check mandatory parameters have been set
489: --
490: hr_api.mandatory_arg_error

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

493: ,p_argument_value => p_person_id
494: );
495: --
496: --
497: hr_utility.set_location('Entering:'|| l_proc, 2);
498: --
499: if p_person_id is not null then
500: -- check if person is valid
501: open csr_person_valid;

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

506: fnd_message.raise_error;
507: else
508: close csr_person_valid;
509: end if;
510: hr_utility.set_location(l_proc, 5);
511: end if;
512: --
513: hr_utility.set_location('Leaving: '|| l_proc, 10);
514: --

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

509: end if;
510: hr_utility.set_location(l_proc, 5);
511: end if;
512: --
513: hr_utility.set_location('Leaving: '|| l_proc, 10);
514: --
515: exception
516: when app_exception.application_exception then
517: if hr_multi_message.exception_add

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

542: AND person_id = p_person_id;
543: --
544: BEGIN
545: --
546: hr_utility.set_location('Entering:'|| l_proc, 10);
547: OPEN csr_chk_unique;
548: FETCH csr_chk_unique INTO l_exists;
549: CLOSE csr_chk_unique;
550: --

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

554: fnd_message.set_name('PER', 'HR_WPM_INV_SCORE_PERSON_COMB');
555: fnd_message.raise_error;
556: END IF;
557: --
558: hr_utility.set_location('Leaving:'|| l_proc, 70);
559: --
560: EXCEPTION
561: WHEN app_exception.application_exception THEN
562: IF hr_multi_message.exception_add

Line 566: hr_utility.set_location(' Leaving:'|| l_proc, 80);

562: IF hr_multi_message.exception_add
563: (p_associated_column1 => 'PER_SCORECARD_SHARING.SCORECARD_ID'
564: ,p_associated_column2 => 'PER_SCORECARD_SHARING.PERSON_ID')
565: THEN
566: hr_utility.set_location(' Leaving:'|| l_proc, 80);
567: RAISE;
568: END IF;
569: hr_utility.set_location(' Leaving:'|| l_proc, 90);
570:

Line 569: hr_utility.set_location(' Leaving:'|| l_proc, 90);

565: THEN
566: hr_utility.set_location(' Leaving:'|| l_proc, 80);
567: RAISE;
568: END IF;
569: hr_utility.set_location(' Leaving:'|| l_proc, 90);
570:
571: END chk_scorecard_person_unique;
572: --
573: -- ----------------------------------------------------------------------------

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

579: --
580: l_proc varchar2(72) := g_package||'insert_validate';
581: --
582: Begin
583: hr_utility.set_location('Entering:'||l_proc, 5);
584: --
585: -- Call all supporting business operations
586: --
587: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS.

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

610: );
611: --
612: per_psh_bus.chk_df(p_rec);
613: --
614: hr_utility.set_location(' Leaving:'||l_proc, 10);
615: End insert_validate;
616: --
617: -- ----------------------------------------------------------------------------
618: -- |---------------------------< update_validate >----------------------------|

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

623: --
624: l_proc varchar2(72) := g_package||'update_validate';
625: --
626: Begin
627: hr_utility.set_location('Entering:'||l_proc, 5);
628: --
629: -- Call all supporting business operations
630: --
631: -- CLIENT_INFO not set. No lookup validation or joins to HR_LOOKUPS.

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

651: );
652: --
653: per_psh_bus.chk_df(p_rec);
654: --
655: hr_utility.set_location(' Leaving:'||l_proc, 10);
656: End update_validate;
657: --
658: -- ----------------------------------------------------------------------------
659: -- |---------------------------< delete_validate >----------------------------|

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

664: --
665: l_proc varchar2(72) := g_package||'delete_validate';
666: --
667: Begin
668: hr_utility.set_location('Entering:'||l_proc, 5);
669: --
670: -- Call all supporting business operations
671: --
672: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

668: hr_utility.set_location('Entering:'||l_proc, 5);
669: --
670: -- Call all supporting business operations
671: --
672: hr_utility.set_location(' Leaving:'||l_proc, 10);
673: End delete_validate;
674: --
675: end per_psh_bus;