DBA Data[Home] [Help]

APPS.PER_MASS_MOVES_PKG dependencies on HR_UTILITY

Line 33: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 34: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.insert_rows');

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:

Line 35: hr_utility.set_message_token('STEP','1');

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:

Line 60: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 61: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.insert_rows');

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;

Line 62: hr_utility.set_message_token('STEP','2');

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;

Line 138: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 139: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');

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;

Line 140: hr_utility.set_message_token('STEP','1');

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 (

Line 141: hr_utility.raise_error;

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)

Line 165: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 166: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');

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

Line 167: hr_utility.set_message_token('STEP','2');

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

Line 168: hr_utility.raise_error;

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');

Line 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;

Line 173: hr_utility.set_message_token('PROCEDURE','per_mass_moves_pkg.lock_rows');

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;

Line 174: hr_utility.set_message_token('STEP','3');

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 ;

Line 175: hr_utility.raise_error;

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: