DBA Data[Home] [Help]

APPS.PQH_CRD_BUS dependencies on HR_UTILITY

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

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

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

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

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

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

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

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := pqh_crd_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

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

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

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

152: close csr_leg_code;
153: pqh_crd_bus.g_criteria_rate_defn_id := p_criteria_rate_defn_id;
154: pqh_crd_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

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

191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193: --
194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.criteria_rate_defn_id is not null) and (
198: nvl(pqh_crd_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

330: ,p_attribute30_value => p_rec.attribute30
331: );
332: end if;
333: --
334: hr_utility.set_location(' Leaving:'||l_proc,20);
335: end chk_df;
336: --
337: -- ----------------------------------------------------------------------------
338: -- |-----------------------< chk_non_updateable_args >------------------------|

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

454: l_api_updating boolean;
455: --
456: Begin
457: --
458: hr_utility.set_location('Entering:'||l_proc, 5);
459: --
460: l_api_updating := pqh_crd_shd.api_updating
461: (p_criteria_rate_defn_id => p_criteria_rate_defn_id,
462: p_object_version_number => p_object_version_number);

Line 479: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

475: p_effective_date => p_effective_date) then
476: --
477: -- raise error as does not exist as lookup
478: --
479: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
480: hr_utility.raise_error;
481: --
482: end if;
483: --

Line 480: hr_utility.raise_error;

476: --
477: -- raise error as does not exist as lookup
478: --
479: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
480: hr_utility.raise_error;
481: --
482: end if;
483: --
484: end if;

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

482: end if;
483: --
484: end if;
485: --
486: hr_utility.set_location('Leaving:'||l_proc,10);
487: --
488: end chk_reference_period_cd;
489:
490: --

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

501: l_api_updating boolean;
502: --
503: Begin
504: --
505: hr_utility.set_location('Entering:'||l_proc, 5);
506: --
507: l_api_updating := pqh_crd_shd.api_updating
508: (p_criteria_rate_defn_id => p_criteria_rate_defn_id,
509: p_object_version_number => p_object_version_number);

Line 526: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

522: p_effective_date => p_effective_date) then
523: --
524: -- raise error as does not exist as lookup
525: --
526: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
527: hr_utility.raise_error;
528: --
529: end if;
530: --

Line 527: hr_utility.raise_error;

523: --
524: -- raise error as does not exist as lookup
525: --
526: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
527: hr_utility.raise_error;
528: --
529: end if;
530: --
531: end if;

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

529: end if;
530: --
531: end if;
532: --
533: hr_utility.set_location('Leaving:'||l_proc,10);
534: --
535: end chk_rate_calc_cd;
536:
537: --

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

548: l_api_updating boolean;
549: --
550: Begin
551: --
552: hr_utility.set_location('Entering:'||l_proc, 5);
553: --
554: l_api_updating := pqh_crd_shd.api_updating
555: (p_criteria_rate_defn_id => p_criteria_rate_defn_id,
556: p_object_version_number => p_object_version_number);

Line 573: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

569: p_effective_date => p_effective_date) then
570: --
571: -- raise error as does not exist as lookup
572: --
573: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
574: hr_utility.raise_error;
575: --
576: end if;
577: --

Line 574: hr_utility.raise_error;

570: --
571: -- raise error as does not exist as lookup
572: --
573: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
574: hr_utility.raise_error;
575: --
576: end if;
577: --
578: end if;

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

576: end if;
577: --
578: end if;
579: --
580: hr_utility.set_location('Leaving:'||l_proc,10);
581: --
582: end chk_uom;
583:
584: --

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

595: l_api_updating boolean;
596: --
597: Begin
598: --
599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: l_api_updating := pqh_crd_shd.api_updating
602: (p_criteria_rate_defn_id => p_criteria_rate_defn_id,
603: p_object_version_number => p_object_version_number);

Line 620: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

616: p_effective_date => p_effective_date) then
617: --
618: -- raise error as does not exist as lookup
619: --
620: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
621: hr_utility.raise_error;
622: --
623: end if;
624: --

Line 621: hr_utility.raise_error;

617: --
618: -- raise error as does not exist as lookup
619: --
620: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
621: hr_utility.raise_error;
622: --
623: end if;
624: --
625: end if;

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

623: end if;
624: --
625: end if;
626: --
627: hr_utility.set_location('Leaving:'||l_proc,10);
628: --
629: end chk_preferential_rate_cd;
630:
631: --

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

642: l_api_updating boolean;
643: --
644: Begin
645: --
646: hr_utility.set_location('Entering:'||l_proc, 5);
647: --
648: l_api_updating := pqh_crd_shd.api_updating
649: (p_criteria_rate_defn_id => p_criteria_rate_defn_id,
650: p_object_version_number => p_object_version_number);

Line 667: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

663: p_effective_date => p_effective_date) then
664: --
665: -- raise error as does not exist as lookup
666: --
667: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
668: hr_utility.raise_error;
669: --
670: end if;
671: --

Line 668: hr_utility.raise_error;

664: --
665: -- raise error as does not exist as lookup
666: --
667: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
668: hr_utility.raise_error;
669: --
670: end if;
671: --
672: end if;

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

670: end if;
671: --
672: end if;
673: --
674: hr_utility.set_location('Leaving:'||l_proc,10);
675: --
676: end chk_rounding_cd;
677: --
678: /**

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

685: l_api_updating boolean;
686: --
687: Begin
688: --
689: hr_utility.set_location('Entering:'||l_proc, 5);
690: --
691: l_api_updating := pqh_crd_shd.api_updating
692: (p_criteria_rate_defn_id => p_criteria_rate_defn_id,
693: p_object_version_number => p_object_version_number);

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

701: p_argument_value => p_business_group_id);
702: --
703: end if;
704: --
705: hr_utility.set_location('Leaving:'||l_proc,10);
706: --
707: end chk_business_group;
708: **/
709: --

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

717: --
718: l_proc varchar2(72) := g_package||'insert_validate';
719: --
720: Begin
721: hr_utility.set_location('Entering:'||l_proc, 5);
722: --
723: -- Call all supporting business operations
724: --
725: --

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

782: --
783: --
784: --pqh_crd_bus.chk_df(p_rec);
785: --
786: hr_utility.set_location(' Leaving:'||l_proc, 10);
787: End insert_validate;
788: --
789: -- ----------------------------------------------------------------------------
790: -- |---------------------------< update_validate >----------------------------|

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

796: --
797: l_proc varchar2(72) := g_package||'update_validate';
798: --
799: Begin
800: hr_utility.set_location('Entering:'||l_proc, 5);
801: --
802: -- Call all supporting business operations
803: --
804: --

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

863: --
864: --
865: --pqh_crd_bus.chk_df(p_rec);
866: --
867: hr_utility.set_location(' Leaving:'||l_proc, 10);
868: End update_validate;
869: --
870: -- ----------------------------------------------------------------------------
871: -- |---------------------------< delete_validate >----------------------------|

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

876: --
877: l_proc varchar2(72) := g_package||'delete_validate';
878: --
879: Begin
880: hr_utility.set_location('Entering:'||l_proc, 5);
881: --
882: --
883: chk_startup_action(false
884: ,pqh_crd_shd.g_old_rec.business_group_id

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

898: END IF;
899: --
900: -- Call all supporting business operations
901: --
902: hr_utility.set_location(' Leaving:'||l_proc, 10);
903: End delete_validate;
904: --
905: end pqh_crd_bus;