134: exception
135: when no_data_found then
136: null;
137: when others then
138: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
139: hr_utility.set_message_token('PROCEDURE','per_mm_assignments_pkg.load_rows');
140: hr_utility.set_message_token('STEP','1');
141: hr_utility.raise_error;
142:
135: when no_data_found then
136: null;
137: when others then
138: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
139: hr_utility.set_message_token('PROCEDURE','per_mm_assignments_pkg.load_rows');
140: hr_utility.set_message_token('STEP','1');
141: hr_utility.raise_error;
142:
143: end load_rows;
136: null;
137: when others then
138: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
139: hr_utility.set_message_token('PROCEDURE','per_mm_assignments_pkg.load_rows');
140: hr_utility.set_message_token('STEP','1');
141: hr_utility.raise_error;
142:
143: end load_rows;
144: --
137: when others then
138: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
139: hr_utility.set_message_token('PROCEDURE','per_mm_assignments_pkg.load_rows');
140: hr_utility.set_message_token('STEP','1');
141: hr_utility.raise_error;
142:
143: end load_rows;
144: --
145: --
169: open c;
170: fetch c into recinfo;
171: if (c%notfound) then
172: close c;
173: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
174: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.lock_rows');
175: hr_utility.set_message_token('STEP','1');
176: hr_utility.raise_error;
177: end if;
170: fetch c into recinfo;
171: if (c%notfound) then
172: close c;
173: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
174: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.lock_rows');
175: hr_utility.set_message_token('STEP','1');
176: hr_utility.raise_error;
177: end if;
178: close c;
171: if (c%notfound) then
172: close c;
173: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
174: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.lock_rows');
175: hr_utility.set_message_token('STEP','1');
176: hr_utility.raise_error;
177: end if;
178: close c;
179: if (
172: close c;
173: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
174: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.lock_rows');
175: hr_utility.set_message_token('STEP','1');
176: hr_utility.raise_error;
177: end if;
178: close c;
179: if (
180: (recinfo.mass_move_id = p_mass_move_id)
198: AND (p_tax_unit_id is null)))
199: ) then
200: return;
201: else
202: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
203: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.lock_rows');
204: hr_utility.set_message_token('STEP','2');
205: hr_utility.raise_error;
206: end if;
199: ) then
200: return;
201: else
202: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
203: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.lock_rows');
204: hr_utility.set_message_token('STEP','2');
205: hr_utility.raise_error;
206: end if;
207: exception
200: return;
201: else
202: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
203: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.lock_rows');
204: hr_utility.set_message_token('STEP','2');
205: hr_utility.raise_error;
206: end if;
207: exception
208: when app_exceptions.record_lock_exception then
201: else
202: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
203: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.lock_rows');
204: hr_utility.set_message_token('STEP','2');
205: hr_utility.raise_error;
206: end if;
207: exception
208: when app_exceptions.record_lock_exception then
209: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
205: hr_utility.raise_error;
206: end if;
207: exception
208: when app_exceptions.record_lock_exception then
209: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
210: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.lock_rows');
211: hr_utility.set_message_token('STEP','3');
212: hr_utility.raise_error;
213: end;
206: end if;
207: exception
208: when app_exceptions.record_lock_exception then
209: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
210: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.lock_rows');
211: hr_utility.set_message_token('STEP','3');
212: hr_utility.raise_error;
213: end;
214: end loop;
207: exception
208: when app_exceptions.record_lock_exception then
209: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
210: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.lock_rows');
211: hr_utility.set_message_token('STEP','3');
212: hr_utility.raise_error;
213: end;
214: end loop;
215: end lock_row ;
208: when app_exceptions.record_lock_exception then
209: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
210: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.lock_rows');
211: hr_utility.set_message_token('STEP','3');
212: hr_utility.raise_error;
213: end;
214: end loop;
215: end lock_row ;
216: --
250: l_tax_unit_id,
251: l_tax_unit_name;
252: if c%notfound then
253: close c;
254: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
255: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.restore_defaults');
256: hr_utility.set_message_token('STEP','1');
257: hr_utility.raise_error;
258: end if;
251: l_tax_unit_name;
252: if c%notfound then
253: close c;
254: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
255: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.restore_defaults');
256: hr_utility.set_message_token('STEP','1');
257: hr_utility.raise_error;
258: end if;
259: close c;
252: if c%notfound then
253: close c;
254: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
255: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.restore_defaults');
256: hr_utility.set_message_token('STEP','1');
257: hr_utility.raise_error;
258: end if;
259: close c;
260:
253: close c;
254: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
255: hr_utility.set_message_token('PROCEDURE','mm_assignment_pkg.restore_defaults');
256: hr_utility.set_message_token('STEP','1');
257: hr_utility.raise_error;
258: end if;
259: close c;
260:
261: p_grade_id := l_grade_id;