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 FND_MESSAGE

Line 67: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

63: close csr_sec_grp;
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: );

Line 155: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

151: --
152: -- The primary key is invalid therefore we must error
153: --
154: close csr_leg_code;
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);

Line 156: fnd_message.raise_error;

152: -- The primary key is invalid therefore we must error
153: --
154: close csr_leg_code;
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;

Line 400: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

396: IF NOT pqh_cpd_shd.api_updating
397: (p_corps_definition_id => p_rec.corps_definition_id
398: ,p_object_version_number => p_rec.object_version_number
399: ) THEN
400: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
401: fnd_message.set_token('PROCEDURE ', l_proc);
402: fnd_message.set_token('STEP ', '5');
403: fnd_message.raise_error;
404: END IF;

Line 401: fnd_message.set_token('PROCEDURE ', l_proc);

397: (p_corps_definition_id => p_rec.corps_definition_id
398: ,p_object_version_number => p_rec.object_version_number
399: ) THEN
400: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
401: fnd_message.set_token('PROCEDURE ', l_proc);
402: fnd_message.set_token('STEP ', '5');
403: fnd_message.raise_error;
404: END IF;
405:

Line 402: fnd_message.set_token('STEP ', '5');

398: ,p_object_version_number => p_rec.object_version_number
399: ) THEN
400: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
401: fnd_message.set_token('PROCEDURE ', l_proc);
402: fnd_message.set_token('STEP ', '5');
403: fnd_message.raise_error;
404: END IF;
405:
406: End chk_non_updateable_args;

Line 403: fnd_message.raise_error;

399: ) THEN
400: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
401: fnd_message.set_token('PROCEDURE ', l_proc);
402: fnd_message.set_token('STEP ', '5');
403: fnd_message.raise_error;
404: END IF;
405:
406: End chk_non_updateable_args;
407: --

Line 457: fnd_message.set_name('PQH', 'PQH_DUPLICATE_CORPS_NAME');

453: fetch csr_cpd_name into l_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;

Line 503: fnd_message.set_name ('PQH', 'PQH_CORPS_INVALID_TYPE_OF_PS');

499:
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;

Line 539: fnd_message.set_name('PQH','PQH_CORPS_INVALID_PRIM_FIELD');

535: OPEN csr_primary_prof_field;
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

Line 567: fnd_message.set_name('PQH','PQH_CORPS_INVALID_CATEGORY');

563: ,p_argument => '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);

Line 588: fnd_message.set_name('PQH','PQH_CORPS_INVALID_TYPE_CD');

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');
590: end if;
591: if g_debug then
592: hr_utility.set_location('Leaving: '||l_proc,20);

Line 618: fnd_message.set_name('PQH','PQH_CORPS_INVALID_STR_GRD');

614: OPEN csr_valid_grade;
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

Line 656: fnd_message.set_name('PQH','PQH_CORPS_INVALID_STR_STEP');

652: OPEN csr_valid_step;
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;

Line 701: fnd_message.set_name('PQH', 'PQH_CORPS_ESD_GREAT_EED');

697: l_date_to := p_date_to;
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');

Line 705: fnd_message.set_name('PQH', 'PQH_CORPS_RED_GREAT_EED');

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');
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');

Line 709: fnd_message.set_name('PQH','PQH_CORPS_ESD_GREAT_RED');

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');
711: end if;
712: if g_debug then
713: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 734: fnd_message.set_name('PQH', 'PQH_CORPS_NOR_FRQ_MISSING');

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');
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');

Line 738: fnd_message.set_name('PQH', 'PQH_CORPS_MIN_FRQ_MISSING');

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');
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');

Line 742: fnd_message.set_name('PQH', 'PQH_CORPS_MIN_MORE_NOR');

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');
744: end if;
745:
746: if g_debug then

Line 769: fnd_message.set_name('PQH', 'PQH_CORPS_RETIREMENT_AGE');

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');
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

Line 774: fnd_message.set_name('PQH', 'PQH_CORPS_INVALID_SECOND');

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');
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');

Line 778: fnd_message.set_name('PQH','PQH_PROB_PERIOD_NEGATIVE');

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');
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');

Line 782: fnd_message.set_name('PQH','PQH_PROB_UNITS_MISSING');

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');
784: end if;
785: if g_debug then
786: hr_utility.set_location('Leaving:'|| l_proc, 20);

Line 814: fnd_message.set_name('PQH','PQH_CORPS_INVALID_PGM');

810: OPEN csr_ben_pgm_exists;
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