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,'BALANCE_CATEGORY_ID')
64: );
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: --
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
476: THEN
477: --
478: -- the value entered for this record is not recognised
479: --
480: fnd_message.set_name('PAY', 'PAY_34228_PBC_INV_LOOKUP');
481: fnd_message.raise_error;
482: --
483: hr_utility.set_location(l_proc,10);
484: END IF;
477: --
478: -- the value entered for this record is not recognised
479: --
480: fnd_message.set_name('PAY', 'PAY_34228_PBC_INV_LOOKUP');
481: fnd_message.raise_error;
482: --
483: hr_utility.set_location(l_proc,10);
484: END IF;
485: end if;
831: (p_balance_category_id => p_rec.balance_category_id
832: ,p_effective_date => p_effective_date
833: ,p_object_version_number => p_rec.object_version_number
834: ) THEN
835: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
836: fnd_message.set_token('PROCEDURE ', l_proc);
837: fnd_message.set_token('STEP ', '5');
838: fnd_message.raise_error;
839: END IF;
832: ,p_effective_date => p_effective_date
833: ,p_object_version_number => p_rec.object_version_number
834: ) THEN
835: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
836: fnd_message.set_token('PROCEDURE ', l_proc);
837: fnd_message.set_token('STEP ', '5');
838: fnd_message.raise_error;
839: END IF;
840: --
833: ,p_object_version_number => p_rec.object_version_number
834: ) THEN
835: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
836: fnd_message.set_token('PROCEDURE ', l_proc);
837: fnd_message.set_token('STEP ', '5');
838: fnd_message.raise_error;
839: END IF;
840: --
841: hr_utility.set_location(l_proc, 10);
834: ) THEN
835: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
836: fnd_message.set_token('PROCEDURE ', l_proc);
837: fnd_message.set_token('STEP ', '5');
838: fnd_message.raise_error;
839: END IF;
840: --
841: hr_utility.set_location(l_proc, 10);
842: --
946: --
947: -- An unhandled or unexpected error has occurred which
948: -- we must report
949: --
950: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
951: fnd_message.set_token('PROCEDURE', l_proc);
952: fnd_message.set_token('STEP','15');
953: fnd_message.raise_error;
954: End dt_update_validate;
947: -- An unhandled or unexpected error has occurred which
948: -- we must report
949: --
950: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
951: fnd_message.set_token('PROCEDURE', l_proc);
952: fnd_message.set_token('STEP','15');
953: fnd_message.raise_error;
954: End dt_update_validate;
955: --
948: -- we must report
949: --
950: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
951: fnd_message.set_token('PROCEDURE', l_proc);
952: fnd_message.set_token('STEP','15');
953: fnd_message.raise_error;
954: End dt_update_validate;
955: --
956: -- ----------------------------------------------------------------------------
949: --
950: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
951: fnd_message.set_token('PROCEDURE', l_proc);
952: fnd_message.set_token('STEP','15');
953: fnd_message.raise_error;
954: End dt_update_validate;
955: --
956: -- ----------------------------------------------------------------------------
957: -- |--------------------------< dt_delete_validate >--------------------------|
1043: --
1044: -- An unhandled or unexpected error has occurred which
1045: -- we must report
1046: --
1047: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1048: fnd_message.set_token('PROCEDURE', l_proc);
1049: fnd_message.set_token('STEP','15');
1050: fnd_message.raise_error;
1051: --
1044: -- An unhandled or unexpected error has occurred which
1045: -- we must report
1046: --
1047: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1048: fnd_message.set_token('PROCEDURE', l_proc);
1049: fnd_message.set_token('STEP','15');
1050: fnd_message.raise_error;
1051: --
1052: End dt_delete_validate;
1045: -- we must report
1046: --
1047: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1048: fnd_message.set_token('PROCEDURE', l_proc);
1049: fnd_message.set_token('STEP','15');
1050: fnd_message.raise_error;
1051: --
1052: End dt_delete_validate;
1053: --
1046: --
1047: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1048: fnd_message.set_token('PROCEDURE', l_proc);
1049: fnd_message.set_token('STEP','15');
1050: fnd_message.raise_error;
1051: --
1052: End dt_delete_validate;
1053: --
1054: -- ----------------------------------------------------------------------------