29: open c1;
30: fetch c1 into l_mass_move_id;
31: if (C1%NOTFOUND) then
32: CLOSE C1;
33: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.insert_rows');
35: hr_utility.set_message_token('STEP','1');
36: end if;
37: close c1;
30: fetch c1 into l_mass_move_id;
31: if (C1%NOTFOUND) then
32: CLOSE C1;
33: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.insert_rows');
35: hr_utility.set_message_token('STEP','1');
36: end if;
37: close c1;
38:
31: if (C1%NOTFOUND) then
32: CLOSE C1;
33: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.insert_rows');
35: hr_utility.set_message_token('STEP','1');
36: end if;
37: close c1;
38:
39:
56: open c;
57: fetch c into l_row_id;
58: if (c%notfound) then
59: close c;
60: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
61: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.insert_rows');
62: hr_utility.set_message_token('STEP','2');
63: end if;
64: close c;
57: fetch c into l_row_id;
58: if (c%notfound) then
59: close c;
60: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
61: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.insert_rows');
62: hr_utility.set_message_token('STEP','2');
63: end if;
64: close c;
65: p_mass_move_id := l_mass_move_id;
58: if (c%notfound) then
59: close c;
60: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
61: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.insert_rows');
62: hr_utility.set_message_token('STEP','2');
63: end if;
64: close c;
65: p_mass_move_id := l_mass_move_id;
66: p_row_id := l_row_id;
134: open c;
135: fetch c into recinfo;
136: if (c%notfound) then
137: close c;
138: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
139: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');
140: hr_utility.set_message_token('STEP','1');
141: hr_utility.raise_error;
142: end if;
135: fetch c into recinfo;
136: if (c%notfound) then
137: close c;
138: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
139: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');
140: hr_utility.set_message_token('STEP','1');
141: hr_utility.raise_error;
142: end if;
143: close c;
136: if (c%notfound) then
137: close c;
138: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
139: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');
140: hr_utility.set_message_token('STEP','1');
141: hr_utility.raise_error;
142: end if;
143: close c;
144: if (
137: close c;
138: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
139: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');
140: hr_utility.set_message_token('STEP','1');
141: hr_utility.raise_error;
142: end if;
143: close c;
144: if (
145: (recinfo.mass_move_id = p_mass_move_id)
161: AND (p_status is null)))
162: ) then
163: return;
164: else
165: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
166: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');
167: hr_utility.set_message_token('STEP','2');
168: hr_utility.raise_error;
169: end if;
162: ) then
163: return;
164: else
165: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
166: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');
167: hr_utility.set_message_token('STEP','2');
168: hr_utility.raise_error;
169: end if;
170: exception
163: return;
164: else
165: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
166: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');
167: hr_utility.set_message_token('STEP','2');
168: hr_utility.raise_error;
169: end if;
170: exception
171: when app_exceptions.record_lock_exception then
164: else
165: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
166: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');
167: hr_utility.set_message_token('STEP','2');
168: hr_utility.raise_error;
169: end if;
170: exception
171: when app_exceptions.record_lock_exception then
172: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
168: hr_utility.raise_error;
169: end if;
170: exception
171: when app_exceptions.record_lock_exception then
172: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
173: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');
174: hr_utility.set_message_token('STEP','3');
175: hr_utility.raise_error;
176: end;
169: end if;
170: exception
171: when app_exceptions.record_lock_exception then
172: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
173: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');
174: hr_utility.set_message_token('STEP','3');
175: hr_utility.raise_error;
176: end;
177: end loop;
170: exception
171: when app_exceptions.record_lock_exception then
172: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
173: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');
174: hr_utility.set_message_token('STEP','3');
175: hr_utility.raise_error;
176: end;
177: end loop;
178: end lock_row ;
171: when app_exceptions.record_lock_exception then
172: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
173: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');
174: hr_utility.set_message_token('STEP','3');
175: hr_utility.raise_error;
176: end;
177: end loop;
178: end lock_row ;
179: