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_ACC_BUS dependencies on FND_MESSAGE

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

56: close csr_sec_grp;
57: --
58: -- The primary key is invalid therefore we must error
59: --
60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
61: hr_multi_message.add
62: (p_associated_column1
63: => nvl(p_associated_column1,'ACCOMMODATION_ID')
64: );

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

133: --
134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --

Line 138: fnd_message.raise_error;

134: -- The primary key is invalid therefore we must error
135: --
136: close csr_leg_code;
137: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: end if;
140: hr_utility.set_location(l_proc,30);
141: --
142: -- Set the global variables so the values are

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

547: (p_accommodation_id => p_rec.accommodation_id
548: ,p_effective_date => p_effective_date
549: ,p_object_version_number => p_rec.object_version_number
550: ) THEN
551: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
552: fnd_message.set_token('PROCEDURE ', l_proc);
553: fnd_message.set_token('STEP ', '5');
554: fnd_message.raise_error;
555: END IF;

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

548: ,p_effective_date => p_effective_date
549: ,p_object_version_number => p_rec.object_version_number
550: ) THEN
551: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
552: fnd_message.set_token('PROCEDURE ', l_proc);
553: fnd_message.set_token('STEP ', '5');
554: fnd_message.raise_error;
555: END IF;
556: --

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

549: ,p_object_version_number => p_rec.object_version_number
550: ) THEN
551: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
552: fnd_message.set_token('PROCEDURE ', l_proc);
553: fnd_message.set_token('STEP ', '5');
554: fnd_message.raise_error;
555: END IF;
556: --
557: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 554: fnd_message.raise_error;

550: ) THEN
551: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
552: fnd_message.set_token('PROCEDURE ', l_proc);
553: fnd_message.set_token('STEP ', '5');
554: fnd_message.raise_error;
555: END IF;
556: --
557: -- EDIT_HERE: Add checks to ensure non-updateable args have
558: -- not been updated.

Line 633: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

629: --
630: -- An unhandled or unexpected error has occurred which
631: -- we must report
632: --
633: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
634: fnd_message.set_token('PROCEDURE', l_proc);
635: fnd_message.set_token('STEP','15');
636: fnd_message.raise_error;
637: End dt_update_validate;

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

630: -- An unhandled or unexpected error has occurred which
631: -- we must report
632: --
633: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
634: fnd_message.set_token('PROCEDURE', l_proc);
635: fnd_message.set_token('STEP','15');
636: fnd_message.raise_error;
637: End dt_update_validate;
638: --

Line 635: fnd_message.set_token('STEP','15');

631: -- we must report
632: --
633: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
634: fnd_message.set_token('PROCEDURE', l_proc);
635: fnd_message.set_token('STEP','15');
636: fnd_message.raise_error;
637: End dt_update_validate;
638: --
639: -- ----------------------------------------------------------------------------

Line 636: fnd_message.raise_error;

632: --
633: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
634: fnd_message.set_token('PROCEDURE', l_proc);
635: fnd_message.set_token('STEP','15');
636: fnd_message.raise_error;
637: End dt_update_validate;
638: --
639: -- ----------------------------------------------------------------------------
640: -- |--------------------------< dt_delete_validate >--------------------------|

Line 727: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');

723: ,p_base_key_value => p_accommodation_id
724: ,p_from_date => p_validation_start_date
725: ,p_to_date => p_validation_end_date
726: )) Then
727: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
728: fnd_message.set_token('TABLE_NAME','pqh_assign_accommodations_f');
729: hr_multi_message.add;
730: End If;
731: --

Line 728: fnd_message.set_token('TABLE_NAME','pqh_assign_accommodations_f');

724: ,p_from_date => p_validation_start_date
725: ,p_to_date => p_validation_end_date
726: )) Then
727: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
728: fnd_message.set_token('TABLE_NAME','pqh_assign_accommodations_f');
729: hr_multi_message.add;
730: End If;
731: --
732: End If;

Line 740: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

736: --
737: -- An unhandled or unexpected error has occurred which
738: -- we must report
739: --
740: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
741: fnd_message.set_token('PROCEDURE', l_proc);
742: fnd_message.set_token('STEP','15');
743: fnd_message.raise_error;
744: --

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

737: -- An unhandled or unexpected error has occurred which
738: -- we must report
739: --
740: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
741: fnd_message.set_token('PROCEDURE', l_proc);
742: fnd_message.set_token('STEP','15');
743: fnd_message.raise_error;
744: --
745: End dt_delete_validate;

Line 742: fnd_message.set_token('STEP','15');

738: -- we must report
739: --
740: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
741: fnd_message.set_token('PROCEDURE', l_proc);
742: fnd_message.set_token('STEP','15');
743: fnd_message.raise_error;
744: --
745: End dt_delete_validate;
746: --

Line 743: fnd_message.raise_error;

739: --
740: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
741: fnd_message.set_token('PROCEDURE', l_proc);
742: fnd_message.set_token('STEP','15');
743: fnd_message.raise_error;
744: --
745: End dt_delete_validate;
746: --
747: -- Added following two check procedures for bug fix 3500435

Line 764: fnd_message.set_name('PQH','PQH_ACC_NAME_UNIQUE');

760: Open csr_unique_name;
761: --
762: Fetch csr_unique_name into l_value;
763: If csr_unique_name%FOUND then
764: fnd_message.set_name('PQH','PQH_ACC_NAME_UNIQUE');
765: fnd_message.set_token('NAME',p_accommodation_name);
766: hr_multi_message.add;
767: End if;
768: --

Line 765: fnd_message.set_token('NAME',p_accommodation_name);

761: --
762: Fetch csr_unique_name into l_value;
763: If csr_unique_name%FOUND then
764: fnd_message.set_name('PQH','PQH_ACC_NAME_UNIQUE');
765: fnd_message.set_token('NAME',p_accommodation_name);
766: hr_multi_message.add;
767: End if;
768: --
769: Close csr_unique_name;

Line 791: fnd_message.set_name('PQH','PQH_ACC_NAME_UNIQUE');

787: Open csr_unique_name;
788: --
789: Fetch csr_unique_name into l_value;
790: If csr_unique_name%FOUND then
791: fnd_message.set_name('PQH','PQH_ACC_NAME_UNIQUE');
792: fnd_message.set_token('NAME',p_accommodation_name);
793: hr_multi_message.add;
794: End if;
795: --

Line 792: fnd_message.set_token('NAME',p_accommodation_name);

788: --
789: Fetch csr_unique_name into l_value;
790: If csr_unique_name%FOUND then
791: fnd_message.set_name('PQH','PQH_ACC_NAME_UNIQUE');
792: fnd_message.set_token('NAME',p_accommodation_name);
793: hr_multi_message.add;
794: End if;
795: --
796: Close csr_unique_name;