55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
64: --
128: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
190: (p_element_type_usage_id => p_rec.element_type_usage_id
191: ,p_effective_date => p_effective_date
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
191: ,p_effective_date => p_effective_date
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
200: hr_utility.set_location(l_proc, 10);
193: ) THEN
194: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
200: hr_utility.set_location(l_proc, 10);
201: --
703: THEN
704: --
705: -- The inclusion_flag for this record is invalid
706: --
707: fnd_message.set_name('PAY','HR_33585_ETU_INCLUSION_FLAG_N');
708: fnd_message.raise_error;
709: --
710: hr_utility.set_location(l_proc,10);
711: END IF;
704: --
705: -- The inclusion_flag for this record is invalid
706: --
707: fnd_message.set_name('PAY','HR_33585_ETU_INCLUSION_FLAG_N');
708: fnd_message.raise_error;
709: --
710: hr_utility.set_location(l_proc,10);
711: END IF;
712: --
894: --
895: -- A referential integrity check was violated therefore
896: -- we must error
897: --
898: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
899: fnd_message.set_token('TABLE_NAME', l_table_name);
900: fnd_message.raise_error;
901: When Others Then
902: --
895: -- A referential integrity check was violated therefore
896: -- we must error
897: --
898: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
899: fnd_message.set_token('TABLE_NAME', l_table_name);
900: fnd_message.raise_error;
901: When Others Then
902: --
903: -- An unhandled or unexpected error has occurred which
896: -- we must error
897: --
898: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
899: fnd_message.set_token('TABLE_NAME', l_table_name);
900: fnd_message.raise_error;
901: When Others Then
902: --
903: -- An unhandled or unexpected error has occurred which
904: -- we must report
902: --
903: -- An unhandled or unexpected error has occurred which
904: -- we must report
905: --
906: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
907: fnd_message.set_token('PROCEDURE', l_proc);
908: fnd_message.set_token('STEP','15');
909: fnd_message.raise_error;
910: End dt_update_validate;
903: -- An unhandled or unexpected error has occurred which
904: -- we must report
905: --
906: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
907: fnd_message.set_token('PROCEDURE', l_proc);
908: fnd_message.set_token('STEP','15');
909: fnd_message.raise_error;
910: End dt_update_validate;
911: --
904: -- we must report
905: --
906: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
907: fnd_message.set_token('PROCEDURE', l_proc);
908: fnd_message.set_token('STEP','15');
909: fnd_message.raise_error;
910: End dt_update_validate;
911: --
912: -- ----------------------------------------------------------------------------
905: --
906: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
907: fnd_message.set_token('PROCEDURE', l_proc);
908: fnd_message.set_token('STEP','15');
909: fnd_message.raise_error;
910: End dt_update_validate;
911: --
912: -- ----------------------------------------------------------------------------
913: -- |--------------------------< dt_delete_validate >--------------------------|
1001: --
1002: -- A referential integrity check was violated therefore
1003: -- we must error
1004: --
1005: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1006: fnd_message.set_token('TABLE_NAME', l_table_name);
1007: fnd_message.raise_error;
1008: When Others Then
1009: --
1002: -- A referential integrity check was violated therefore
1003: -- we must error
1004: --
1005: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1006: fnd_message.set_token('TABLE_NAME', l_table_name);
1007: fnd_message.raise_error;
1008: When Others Then
1009: --
1010: -- An unhandled or unexpected error has occurred which
1003: -- we must error
1004: --
1005: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1006: fnd_message.set_token('TABLE_NAME', l_table_name);
1007: fnd_message.raise_error;
1008: When Others Then
1009: --
1010: -- An unhandled or unexpected error has occurred which
1011: -- we must report
1009: --
1010: -- An unhandled or unexpected error has occurred which
1011: -- we must report
1012: --
1013: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1014: fnd_message.set_token('PROCEDURE', l_proc);
1015: fnd_message.set_token('STEP','15');
1016: fnd_message.raise_error;
1017: --
1010: -- An unhandled or unexpected error has occurred which
1011: -- we must report
1012: --
1013: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1014: fnd_message.set_token('PROCEDURE', l_proc);
1015: fnd_message.set_token('STEP','15');
1016: fnd_message.raise_error;
1017: --
1018: End dt_delete_validate;
1011: -- we must report
1012: --
1013: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1014: fnd_message.set_token('PROCEDURE', l_proc);
1015: fnd_message.set_token('STEP','15');
1016: fnd_message.raise_error;
1017: --
1018: End dt_delete_validate;
1019: --
1012: --
1013: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1014: fnd_message.set_token('PROCEDURE', l_proc);
1015: fnd_message.set_token('STEP','15');
1016: fnd_message.raise_error;
1017: --
1018: End dt_delete_validate;
1019: --
1020: -- ----------------------------------------------------------------------------