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.PQH_CPD_BUS dependencies on HR_UTILITY

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pqh_cpd_bus.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- The following two global variables are only to be
12: -- used by the return_legislation_code function.
13: --

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

42: begin
43: --
44: if g_debug then
45: l_proc := g_package||'set_security_group_id';
46: hr_utility.set_location('Entering:'|| l_proc, 10);
47: end if;
48: --
49: -- Ensure that all the mandatory parameter are not null
50: --

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

84: hr_api.set_legislation_context(l_legislation_code);
85: end if;
86: --
87: if g_debug then
88: hr_utility.set_location(' Leaving:'|| l_proc, 20);
89: end if;
90: --
91: end set_security_group_id;
92: --

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

116: Begin
117: --
118: if g_debug then
119: l_proc := g_package||'return_legislation_code';
120: hr_utility.set_location('Entering:'|| l_proc, 10);
121: end if;
122: --
123: -- Ensure that all the mandatory parameter are not null
124: --

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

136: -- variable.
137: --
138: l_legislation_code := pqh_cpd_bus.g_legislation_code;
139: if g_debug then
140: hr_utility.set_location(l_proc, 20);
141: end if;
142: else
143: --
144: -- The ID is different to the last call to this function

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

155: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
156: fnd_message.raise_error;
157: end if;
158: if g_debug then
159: hr_utility.set_location(l_proc,30);
160: end if;
161: --
162: -- Set the global variables so the values are
163: -- available for the next call to this function.

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

166: pqh_cpd_bus.g_corps_definition_id := p_corps_definition_id;
167: pqh_cpd_bus.g_legislation_code := l_legislation_code;
168: end if;
169: if g_debug then
170: hr_utility.set_location(' Leaving:'|| l_proc, 40);
171: end if;
172: return l_legislation_code;
173: end return_legislation_code;
174: --

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

208: --
209: begin
210: if g_debug then
211: l_proc := g_package || 'chk_df';
212: hr_utility.set_location('Entering:'||l_proc,10);
213: end if;
214: --
215: if ((p_rec.corps_definition_id is not null) and (
216: nvl(pqh_cpd_shd.g_old_rec.attribute1, hr_api.g_varchar2) <>

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

349: );
350: end if;
351: --
352: if g_debug then
353: hr_utility.set_location(' Leaving:'||l_proc,20);
354: end if;
355: end chk_df;
356: --
357: -- ----------------------------------------------------------------------------

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

432: begin
433: --
434: if g_debug then
435: l_proc := g_package||'chk_corps_name';
436: hr_utility.set_location('Entering:'|| l_proc, 10);
437: end if;
438: --
439: -- Ensure that all the mandatory parameter are not null
440: --

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

460: close csr_cpd_name;
461: end if;
462: --
463: if g_debug then
464: hr_utility.set_location(' Leaving:'|| l_proc, 20);
465: end if;
466: --
467: end chk_corps_name;
468: --

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

482: BEGIN
483: IF g_debug
484: THEN
485: l_proc := g_package || 'chk_type_of_ps';
486: hr_utility.set_location ('Entering: ' || l_proc, 10);
487: END IF;
488:
489: hr_api.mandatory_arg_error (p_api_name => l_proc,
490: p_argument => 'type_of_ps',

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

507: CLOSE csr_type_of_ps;
508:
509: IF g_debug
510: THEN
511: hr_utility.set_location ('Leaving: ' || l_proc, 20);
512: END IF;
513: END chk_type_of_ps;
514:
515:

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

528: l_valid Varchar2(1) := 'N';
529: begin
530: if g_debug then
531: l_proc := g_package||'chk_primary_prof_field_id';
532: hr_utility.set_location('Entering: '||l_proc,10);
533: end if;
534: if p_primary_prof_field_id IS NOT NULL THEN
535: OPEN csr_primary_prof_field;
536: FETCH csr_primary_prof_field INTO l_valid;

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

540: hr_multi_message.add(p_associated_column1 => 'PRIMARY_PROF_FIELD_ID');
541: end if;
542: end if;
543: if g_debug then
544: hr_utility.set_location('Leaving: '||l_proc,20);
545: end if;
546: end chk_primary_prof_field_id;
547:
548: -- ---------------------------------------------------------------------------

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

555: l_proc Varchar2(72);
556: begin
557: if g_debug then
558: l_proc := g_package||'chk_category_cd';
559: hr_utility.set_location('Entering: '||l_proc,10);
560: end if;
561: hr_api.mandatory_arg_error
562: (p_api_name => l_proc
563: ,p_argument => 'category_cd'

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

567: fnd_message.set_name('PQH','PQH_CORPS_INVALID_CATEGORY');
568: hr_multi_message.add(p_associated_column1 => 'CATEGORY_CD');
569: end if;
570: if g_debug then
571: hr_utility.set_location('Leaving: '||l_proc,20);
572: end if;
573: end chk_category_cd;
574: -- ---------------------------------------------------------------------------
575: -- |----------------------< chk_corps_type_cd >--------------------------|

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

581: l_proc Varchar2(72);
582: begin
583: if g_debug then
584: l_proc := g_package||'chk_corps_type_cd';
585: hr_utility.set_location('Entering: '||l_proc,10);
586: end if;
587: if p_corps_type_cd IS NOT NULL AND hr_api.not_exists_in_hr_lookups(p_effective_date,'PQH_CORPS_TYPE',p_corps_type_cd) then
588: fnd_message.set_name('PQH','PQH_CORPS_INVALID_TYPE_CD');
589: hr_multi_message.add(p_associated_column1 => 'CORPS_TYPE_CD');

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

588: fnd_message.set_name('PQH','PQH_CORPS_INVALID_TYPE_CD');
589: hr_multi_message.add(p_associated_column1 => 'CORPS_TYPE_CD');
590: end if;
591: if g_debug then
592: hr_utility.set_location('Leaving: '||l_proc,20);
593: end if;
594: end chk_corps_type_cd;
595: -- ---------------------------------------------------------------------------
596: -- |----------------------< chk_starting_grade_id >--------------------------|

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

607: l_proc varchar2(72);
608: begin
609: if g_debug then
610: l_proc := g_package||'chk_starting_grade_id';
611: hr_utility.set_location('Entering: '||l_proc,10);
612: end if;
613: if p_starting_grade_id IS NOT NULL THEN
614: OPEN csr_valid_grade;
615: FETCH csr_valid_grade INTO l_valid;

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

619: hr_multi_message.add(p_associated_column1 => 'STARTING_GRADE_ID');
620: END IF;
621: end if;
622: if g_debug then
623: hr_utility.set_location('Leaving: '||l_proc,20);
624: end if;
625: end chk_starting_grade_id;
626: -- ---------------------------------------------------------------------------
627: -- |----------------------< chk_starting_grade_step_id >--------------------------|

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

643: l_proc varchar2(72);
644: begin
645: if g_debug then
646: l_proc := g_package||'chk_starting_grade_id';
647: hr_utility.set_location('Entering: '||l_proc,10);
648: end if;
649: if hr_multi_message.no_error_message
650: (p_check_message_name1 => 'PQH_CORPS_INVALID_STR_GRD') then
651: if p_starting_grade_id IS NOT NULL AND p_starting_grade_step_id IS NOT NULL THEN

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

658: END IF;
659: end if;
660: end if;
661: if g_debug then
662: hr_utility.set_location('Leaving: '||l_proc,20);
663: end if;
664: end chk_starting_grade_step_id;
665: --
666: -- ---------------------------------------------------------------------------

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

679: begin
680: --
681: if g_debug then
682: l_proc := g_package||'chk_corps_dates';
683: hr_utility.set_location('Entering:'|| l_proc, 10);
684: end if;
685: --
686: -- Ensure that all the mandatory parameter are not null
687: --

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

709: fnd_message.set_name('PQH','PQH_CORPS_ESD_GREAT_RED');
710: hr_multi_message.add(p_associated_column1=>'RECRUITMENT_END_DATE');
711: end if;
712: if g_debug then
713: hr_utility.set_location(' Leaving:'|| l_proc, 20);
714: end if;
715: --
716: end chk_corps_dates;
717: --

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

726: begin
727: --
728: if g_debug then
729: l_proc := g_package||'chk_corps_work_hours';
730: hr_utility.set_location('Entering:'|| l_proc, 10);
731: end if;
732:
733: if p_rec.normal_hours is not null and p_rec.normal_hours_frequency is null then
734: fnd_message.set_name('PQH', 'PQH_CORPS_NOR_FRQ_MISSING');

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

743: hr_multi_message.add(p_associated_column1 => 'MINIMUM_HOURS');
744: end if;
745:
746: if g_debug then
747: hr_utility.set_location('Leaving:'|| l_proc, 10);
748: end if;
749:
750: end chk_corps_work_hours;
751: --

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

761: begin
762: --
763: if g_debug then
764: l_proc := g_package||'chk_corps_other_proc_info';
765: hr_utility.set_location('Entering:'|| l_proc, 10);
766: end if;
767: if p_rec.RETIREMENT_AGE is not null then
768: if p_rec.RETIREMENT_AGE not between 40 and 80 then
769: fnd_message.set_name('PQH', 'PQH_CORPS_RETIREMENT_AGE');

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

782: fnd_message.set_name('PQH','PQH_PROB_UNITS_MISSING');
783: hr_multi_message.add(p_associated_column1 => 'PROBATION_UNITS');
784: end if;
785: if g_debug then
786: hr_utility.set_location('Leaving:'|| l_proc, 20);
787: end if;
788: end chk_corps_other_proc_info;
789: --
790: -- ---------------------------------------------------------------------------

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

803: l_proc varchar2(72);
804: begin
805: if g_debug then
806: l_proc := g_package||'chk_ben_pgm_id';
807: hr_utility.set_location('Entering: '||l_proc,10);
808: end if;
809: if p_ben_pgm_id IS NOT NULL then
810: OPEN csr_ben_pgm_exists;
811: FETCH csr_ben_pgm_exists INTO l_valid;

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

815: hr_multi_message.add(p_associated_column1=>'BEN_PGM_ID');
816: end if;
817: end if;
818: if g_debug then
819: hr_utility.set_location('Leaving:'|| l_proc, 20);
820: end if;
821: end chk_ben_pgm_id;
822:
823: --

Line 835: g_debug := hr_utility.debug_enabled;

831: --
832: l_proc varchar2(72) ;
833: --
834: Begin
835: g_debug := hr_utility.debug_enabled;
836: if g_debug then
837: l_proc := g_package||'insert_validate';
838: hr_utility.set_location('Entering:'||l_proc, 5);
839: end if;

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

834: Begin
835: g_debug := hr_utility.debug_enabled;
836: if g_debug then
837: l_proc := g_package||'insert_validate';
838: hr_utility.set_location('Entering:'||l_proc, 5);
839: end if;
840: --
841: -- Call all supporting business operations
842: --

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

887: -- removing the call to chk_df as at the moment the DFF is not enabled from the OA Page
888: -- pqh_cpd_bus.chk_df(p_rec);
889: --
890: if g_debug then
891: hr_utility.set_location(' Leaving:'||l_proc, 10);
892: end if;
893: End insert_validate;
894: --
895: -- ----------------------------------------------------------------------------

Line 906: g_debug := hr_utility.debug_enabled;

902: --
903: l_proc varchar2(72);
904: --
905: Begin
906: g_debug := hr_utility.debug_enabled;
907: if g_debug then
908: l_proc := g_package||'update_validate';
909: hr_utility.set_location('Entering:'||l_proc, 5);
910: end if;

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

905: Begin
906: g_debug := hr_utility.debug_enabled;
907: if g_debug then
908: l_proc := g_package||'update_validate';
909: hr_utility.set_location('Entering:'||l_proc, 5);
910: end if;
911: --
912: -- Call all supporting business operations
913: --

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

963: -- removing the call to chk_df as at the moment the DFF is not enabled from the OA Page
964: -- pqh_cpd_bus.chk_df(p_rec);
965: --
966: if g_debug then
967: hr_utility.set_location(' Leaving:'||l_proc, 10);
968: end if;
969: End update_validate;
970: --
971: -- ----------------------------------------------------------------------------

Line 981: g_debug := hr_utility.debug_enabled;

977: --
978: l_proc varchar2(72);
979: --
980: Begin
981: g_debug := hr_utility.debug_enabled;
982: if g_debug then
983: l_proc := g_package||'delete_validate';
984: hr_utility.set_location('Entering:'||l_proc, 5);
985: end if;

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

980: Begin
981: g_debug := hr_utility.debug_enabled;
982: if g_debug then
983: l_proc := g_package||'delete_validate';
984: hr_utility.set_location('Entering:'||l_proc, 5);
985: end if;
986: --
987: -- Call all supporting business operations
988: --

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

986: --
987: -- Call all supporting business operations
988: --
989: if g_debug then
990: hr_utility.set_location(' Leaving:'||l_proc, 10);
991: end if;
992: End delete_validate;
993: --
994: end pqh_cpd_bus;