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_run_type_org_method_id => p_rec.run_type_org_method_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: -- EDIT_HERE: Add checks to ensure non-updateable args have
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: -- EDIT_HERE: Add checks to ensure non-updateable args have
201: -- not been updated.
968: --
969: -- A referential integrity check was violated therefore
970: -- we must error
971: --
972: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
973: fnd_message.set_token('TABLE_NAME', l_table_name);
974: fnd_message.raise_error;
975: When Others Then
976: --
969: -- A referential integrity check was violated therefore
970: -- we must error
971: --
972: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
973: fnd_message.set_token('TABLE_NAME', l_table_name);
974: fnd_message.raise_error;
975: When Others Then
976: --
977: -- An unhandled or unexpected error has occurred which
970: -- we must error
971: --
972: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
973: fnd_message.set_token('TABLE_NAME', l_table_name);
974: fnd_message.raise_error;
975: When Others Then
976: --
977: -- An unhandled or unexpected error has occurred which
978: -- we must report
976: --
977: -- An unhandled or unexpected error has occurred which
978: -- we must report
979: --
980: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
981: fnd_message.set_token('PROCEDURE', l_proc);
982: fnd_message.set_token('STEP','15');
983: fnd_message.raise_error;
984: End dt_update_validate;
977: -- An unhandled or unexpected error has occurred which
978: -- we must report
979: --
980: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
981: fnd_message.set_token('PROCEDURE', l_proc);
982: fnd_message.set_token('STEP','15');
983: fnd_message.raise_error;
984: End dt_update_validate;
985: --
978: -- we must report
979: --
980: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
981: fnd_message.set_token('PROCEDURE', l_proc);
982: fnd_message.set_token('STEP','15');
983: fnd_message.raise_error;
984: End dt_update_validate;
985: --
986: -- ----------------------------------------------------------------------------
979: --
980: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
981: fnd_message.set_token('PROCEDURE', l_proc);
982: fnd_message.set_token('STEP','15');
983: fnd_message.raise_error;
984: End dt_update_validate;
985: --
986: -- ----------------------------------------------------------------------------
987: -- |--------------------------< dt_delete_validate >--------------------------|
1075: --
1076: -- A referential integrity check was violated therefore
1077: -- we must error
1078: --
1079: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1080: fnd_message.set_token('TABLE_NAME', l_table_name);
1081: fnd_message.raise_error;
1082: When Others Then
1083: --
1076: -- A referential integrity check was violated therefore
1077: -- we must error
1078: --
1079: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1080: fnd_message.set_token('TABLE_NAME', l_table_name);
1081: fnd_message.raise_error;
1082: When Others Then
1083: --
1084: -- An unhandled or unexpected error has occurred which
1077: -- we must error
1078: --
1079: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1080: fnd_message.set_token('TABLE_NAME', l_table_name);
1081: fnd_message.raise_error;
1082: When Others Then
1083: --
1084: -- An unhandled or unexpected error has occurred which
1085: -- we must report
1083: --
1084: -- An unhandled or unexpected error has occurred which
1085: -- we must report
1086: --
1087: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1088: fnd_message.set_token('PROCEDURE', l_proc);
1089: fnd_message.set_token('STEP','15');
1090: fnd_message.raise_error;
1091: --
1084: -- An unhandled or unexpected error has occurred which
1085: -- we must report
1086: --
1087: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1088: fnd_message.set_token('PROCEDURE', l_proc);
1089: fnd_message.set_token('STEP','15');
1090: fnd_message.raise_error;
1091: --
1092: End dt_delete_validate;
1085: -- we must report
1086: --
1087: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1088: fnd_message.set_token('PROCEDURE', l_proc);
1089: fnd_message.set_token('STEP','15');
1090: fnd_message.raise_error;
1091: --
1092: End dt_delete_validate;
1093: --
1086: --
1087: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1088: fnd_message.set_token('PROCEDURE', l_proc);
1089: fnd_message.set_token('STEP','15');
1090: fnd_message.raise_error;
1091: --
1092: End dt_delete_validate;
1093: --
1094: -- ----------------------------------------------------------------------------