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_MULTI_MESSAGE

Line 68: hr_multi_message.add

64: --
65: -- The primary key is invalid therefore we must error
66: --
67: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
68: hr_multi_message.add
69: (p_associated_column1
70: => nvl(p_associated_column1,'CORPS_DEFINITION_ID')
71: );
72: --

Line 458: hr_multi_message.add(p_associated_column1 => 'NAME');

454: --
455: if csr_cpd_name%found then
456: close csr_cpd_name;
457: fnd_message.set_name('PQH', 'PQH_DUPLICATE_CORPS_NAME');
458: hr_multi_message.add(p_associated_column1 => 'NAME');
459: else
460: close csr_cpd_name;
461: end if;
462: --

Line 504: hr_multi_message.ADD (p_associated_column1 => 'TYPE_OF_PS');

500: IF csr_type_of_ps%NOTFOUND
501: THEN
502: --
503: fnd_message.set_name ('PQH', 'PQH_CORPS_INVALID_TYPE_OF_PS');
504: hr_multi_message.ADD (p_associated_column1 => 'TYPE_OF_PS');
505: END IF;
506:
507: CLOSE csr_type_of_ps;
508:

Line 540: hr_multi_message.add(p_associated_column1 => 'PRIMARY_PROF_FIELD_ID');

536: FETCH csr_primary_prof_field INTO l_valid;
537: CLOSE csr_primary_prof_field;
538: if l_valid = 'N' then
539: fnd_message.set_name('PQH','PQH_CORPS_INVALID_PRIM_FIELD');
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);

Line 568: hr_multi_message.add(p_associated_column1 => 'CATEGORY_CD');

564: ,p_argument_value => p_category_cd
565: );
566: if hr_api.not_exists_in_hr_lookups(p_effective_date,'PQH_CORPS_CATEGORY',p_category_cd) then
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;

Line 589: hr_multi_message.add(p_associated_column1 => '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');
590: end if;
591: if g_debug then
592: hr_utility.set_location('Leaving: '||l_proc,20);
593: end if;

Line 619: hr_multi_message.add(p_associated_column1 => 'STARTING_GRADE_ID');

615: FETCH csr_valid_grade INTO l_valid;
616: CLOSE csr_valid_grade;
617: IF l_valid = 'N' THEN
618: fnd_message.set_name('PQH','PQH_CORPS_INVALID_STR_GRD');
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);

Line 649: if hr_multi_message.no_error_message

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
652: OPEN csr_valid_step;
653: FETCH csr_valid_step INTO l_valid;

Line 657: hr_multi_message.add(p_associated_column1 => 'STARTING_GRADE_STEP_ID');

653: FETCH csr_valid_step INTO l_valid;
654: CLOSE csr_valid_step;
655: IF l_valid = 'N' THEN
656: fnd_message.set_name('PQH','PQH_CORPS_INVALID_STR_STEP');
657: hr_multi_message.add(p_associated_column1 => 'STARTING_GRADE_STEP_ID');
658: END IF;
659: end if;
660: end if;
661: if g_debug then

Line 702: hr_multi_message.add(p_associated_column1=> 'DATE_FROM');

698: end if;
699: --
700: if p_date_from > l_date_to then
701: fnd_message.set_name('PQH', 'PQH_CORPS_ESD_GREAT_EED');
702: hr_multi_message.add(p_associated_column1=> 'DATE_FROM');
703: end if;
704: if nvl(p_recruitment_end_date,l_date_to) > l_date_to then
705: fnd_message.set_name('PQH', 'PQH_CORPS_RED_GREAT_EED');
706: hr_multi_message.add(p_associated_column1=>'RECRUITMENT_END_DATE');

Line 706: hr_multi_message.add(p_associated_column1=>'RECRUITMENT_END_DATE');

702: hr_multi_message.add(p_associated_column1=> 'DATE_FROM');
703: end if;
704: if nvl(p_recruitment_end_date,l_date_to) > l_date_to then
705: fnd_message.set_name('PQH', 'PQH_CORPS_RED_GREAT_EED');
706: hr_multi_message.add(p_associated_column1=>'RECRUITMENT_END_DATE');
707: end if;
708: if p_date_from > nvl(p_recruitment_end_date,p_date_from) then
709: fnd_message.set_name('PQH','PQH_CORPS_ESD_GREAT_RED');
710: hr_multi_message.add(p_associated_column1=>'RECRUITMENT_END_DATE');

Line 710: hr_multi_message.add(p_associated_column1=>'RECRUITMENT_END_DATE');

706: hr_multi_message.add(p_associated_column1=>'RECRUITMENT_END_DATE');
707: end if;
708: if p_date_from > nvl(p_recruitment_end_date,p_date_from) then
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;

Line 735: hr_multi_message.add(p_associated_column1 => 'NORMAL_HOURS_FREQUENCY');

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');
735: hr_multi_message.add(p_associated_column1 => 'NORMAL_HOURS_FREQUENCY');
736: end if;
737: if p_rec.minimum_hours is not null and p_rec.minimum_hours_frequency is null then
738: fnd_message.set_name('PQH', 'PQH_CORPS_MIN_FRQ_MISSING');
739: hr_multi_message.add(p_associated_column1 => 'MINIMUM_HOURS_FREQUENCY');

Line 739: hr_multi_message.add(p_associated_column1 => 'MINIMUM_HOURS_FREQUENCY');

735: hr_multi_message.add(p_associated_column1 => 'NORMAL_HOURS_FREQUENCY');
736: end if;
737: if p_rec.minimum_hours is not null and p_rec.minimum_hours_frequency is null then
738: fnd_message.set_name('PQH', 'PQH_CORPS_MIN_FRQ_MISSING');
739: hr_multi_message.add(p_associated_column1 => 'MINIMUM_HOURS_FREQUENCY');
740: end if;
741: if nvl(p_rec.MINIMUM_HOURS,-1) > nvl(p_rec.NORMAL_HOURS,0) then
742: fnd_message.set_name('PQH', 'PQH_CORPS_MIN_MORE_NOR');
743: hr_multi_message.add(p_associated_column1 => 'MINIMUM_HOURS');

Line 743: hr_multi_message.add(p_associated_column1 => 'MINIMUM_HOURS');

739: hr_multi_message.add(p_associated_column1 => 'MINIMUM_HOURS_FREQUENCY');
740: end if;
741: if nvl(p_rec.MINIMUM_HOURS,-1) > nvl(p_rec.NORMAL_HOURS,0) then
742: fnd_message.set_name('PQH', 'PQH_CORPS_MIN_MORE_NOR');
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);

Line 770: hr_multi_message.add(p_associated_column1 => 'RETIREMENT_AGE');

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');
770: hr_multi_message.add(p_associated_column1 => 'RETIREMENT_AGE');
771: end if;
772: end if;
773: if nvl(p_rec.secondment_threshold,0) not between 0 and 100 then
774: fnd_message.set_name('PQH', 'PQH_CORPS_INVALID_SECOND');

Line 775: hr_multi_message.add(p_associated_column1 => 'SECONDMENT_THRESHOLD');

771: end if;
772: end if;
773: if nvl(p_rec.secondment_threshold,0) not between 0 and 100 then
774: fnd_message.set_name('PQH', 'PQH_CORPS_INVALID_SECOND');
775: hr_multi_message.add(p_associated_column1 => 'SECONDMENT_THRESHOLD');
776: end if;
777: if nvl(p_rec.probation_period,0) < 0 then
778: fnd_message.set_name('PQH','PQH_PROB_PERIOD_NEGATIVE');
779: hr_multi_message.add(p_associated_column1=>'PROBATION_PERIOD');

Line 779: hr_multi_message.add(p_associated_column1=>'PROBATION_PERIOD');

775: hr_multi_message.add(p_associated_column1 => 'SECONDMENT_THRESHOLD');
776: end if;
777: if nvl(p_rec.probation_period,0) < 0 then
778: fnd_message.set_name('PQH','PQH_PROB_PERIOD_NEGATIVE');
779: hr_multi_message.add(p_associated_column1=>'PROBATION_PERIOD');
780: end if;
781: if p_rec.probation_period IS NOT NULL AND p_rec.probation_units IS NULL then
782: fnd_message.set_name('PQH','PQH_PROB_UNITS_MISSING');
783: hr_multi_message.add(p_associated_column1 => 'PROBATION_UNITS');

Line 783: hr_multi_message.add(p_associated_column1 => 'PROBATION_UNITS');

779: hr_multi_message.add(p_associated_column1=>'PROBATION_PERIOD');
780: end if;
781: if p_rec.probation_period IS NOT NULL AND p_rec.probation_units IS NULL then
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;

Line 815: hr_multi_message.add(p_associated_column1=>'BEN_PGM_ID');

811: FETCH csr_ben_pgm_exists INTO l_valid;
812: CLOSE csr_ben_pgm_exists;
813: if l_valid = 'N' then
814: fnd_message.set_name('PQH','PQH_CORPS_INVALID_PGM');
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);

Line 854: hr_multi_message.end_validation_set;

850: -- After validating the set of important attributes,
851: -- if Multiple Message detection is enabled and at least
852: -- one error has been found then abort further validation.
853: --
854: hr_multi_message.end_validation_set;
855: --
856: chk_corps_name(p_name => p_rec.name,
857: p_corps_definition_id => p_rec.corps_definition_id,
858: p_business_group_id => p_rec.business_group_id);

Line 923: hr_multi_message.end_validation_set;

919: -- After validating the set of important attributes,
920: -- if Multiple Message detection is enabled and at least
921: -- one error has been found then abort further validation.
922: --
923: hr_multi_message.end_validation_set;
924: --
925: chk_corps_name(p_name => p_rec.name,
926: p_corps_definition_id => p_rec.corps_definition_id,
927: p_business_group_id => p_rec.business_group_id);