45: close csr_sec_grp;
46: --
47: -- The primary key is invalid therefore we must error
48: --
49: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
50: fnd_message.raise_error;
51: --
52: end if;
53: close csr_sec_grp;
46: --
47: -- The primary key is invalid therefore we must error
48: --
49: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
50: fnd_message.raise_error;
51: --
52: end if;
53: close csr_sec_grp;
54: --
106: --
107: -- The primary key is invalid therefore we must error
108: --
109: close csr_leg_code;
110: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
111: fnd_message.raise_error;
112: end if;
113: hr_utility.set_location(l_proc,30);
114: --
107: -- The primary key is invalid therefore we must error
108: --
109: close csr_leg_code;
110: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
111: fnd_message.raise_error;
112: end if;
113: hr_utility.set_location(l_proc,30);
114: --
115: -- Set the global variables so the values are
164: (p_database_item_suffix => p_rec.database_item_suffix
165: ,p_legislation_code => p_rec.legislation_code
166: ,p_object_version_number => p_rec.object_version_number
167: ) THEN
168: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
169: fnd_message.set_token('PROCEDURE ', l_proc);
170: fnd_message.set_token('STEP ', '5');
171: fnd_message.raise_error;
172: END IF;
165: ,p_legislation_code => p_rec.legislation_code
166: ,p_object_version_number => p_rec.object_version_number
167: ) THEN
168: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
169: fnd_message.set_token('PROCEDURE ', l_proc);
170: fnd_message.set_token('STEP ', '5');
171: fnd_message.raise_error;
172: END IF;
173: --
166: ,p_object_version_number => p_rec.object_version_number
167: ) THEN
168: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
169: fnd_message.set_token('PROCEDURE ', l_proc);
170: fnd_message.set_token('STEP ', '5');
171: fnd_message.raise_error;
172: END IF;
173: --
174: -- All Fields are updatable in g_rec_type;
167: ) THEN
168: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
169: fnd_message.set_token('PROCEDURE ', l_proc);
170: fnd_message.set_token('STEP ', '5');
171: fnd_message.raise_error;
172: END IF;
173: --
174: -- All Fields are updatable in g_rec_type;
175: --