DBA Data[Home] [Help]

APPS.PAY_USER_TABLE_API dependencies on HR_UTILITY

Line 33: hr_utility.set_location('Entering:'|| l_proc, 10);

29: l_effective_date date;
30: l_ovn number;
31: l_user_table_id number;
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Issue a savepoint
36: --
37: savepoint create_user_table;

Line 114: hr_utility.set_location(' Leaving:'||l_proc, 70);

110: ---For MLS----------------------------------------------------------------------
111: pay_ptt_ins.ins_tl(userenv('LANG'),p_user_table_id,
112: p_user_table_name,p_user_row_title);
113: --------------------------------------------------------------------------------
114: hr_utility.set_location(' Leaving:'||l_proc, 70);
115: exception
116: when hr_api.validate_enabled then
117: --
118: -- As the Validate_Enabled exception has been raised

Line 129: hr_utility.set_location(' Leaving:'||l_proc, 80);

125: -- when validation only mode is being used.)
126: --
127: p_user_table_id := null;
128: p_object_version_number := null;
129: hr_utility.set_location(' Leaving:'||l_proc, 80);
130: when others then
131: --
132: -- A validation or unexpected error has occured
133: --

Line 135: hr_utility.set_location(' Leaving:'||l_proc, 90);

131: --
132: -- A validation or unexpected error has occured
133: --
134: rollback to create_user_table;
135: hr_utility.set_location(' Leaving:'||l_proc, 90);
136: raise;
137: end create_user_table;
138: --
139: -- ----------------------------------------------------------------------------

Line 158: hr_utility.set_location('Entering:'|| l_proc, 10);

154: l_proc varchar2(72) := g_package||'update_user_table';
155: l_ovn number := p_object_version_number;
156: l_effective_date date;
157: begin
158: hr_utility.set_location('Entering:'|| l_proc, 10);
159: --
160: -- Issue a savepoint
161: --
162: savepoint update_user_table;

Line 228: hr_utility.set_location(' Leaving:'||l_proc, 70);

224: ---For MLS----------------------------------------------------------------------
225: pay_ptt_upd.upd_tl(userenv('LANG'),p_user_table_id,
226: p_user_table_name,p_user_row_title);
227: --------------------------------------------------------------------------------
228: hr_utility.set_location(' Leaving:'||l_proc, 70);
229: exception
230: when hr_api.validate_enabled then
231: --
232: -- As the Validate_Enabled exception has been raised

Line 242: hr_utility.set_location(' Leaving:'||l_proc, 80);

238: -- (Any key or derived arguments must be set to null
239: -- when validation only mode is being used.)
240: --
241: p_object_version_number := null;
242: hr_utility.set_location(' Leaving:'||l_proc, 80);
243: when others then
244: --
245: -- A validation or unexpected error has occured
246: --

Line 248: hr_utility.set_location(' Leaving:'||l_proc, 90);

244: --
245: -- A validation or unexpected error has occured
246: --
247: rollback to update_user_table;
248: hr_utility.set_location(' Leaving:'||l_proc, 90);
249: raise;
250: end update_user_table;
251: --
252: -- ----------------------------------------------------------------------------

Line 268: hr_utility.set_location('Entering:'|| l_proc, 10);

264:
265: l_proc varchar2(72) := g_package||'delete_user_table';
266: l_ovn number := p_object_version_number;
267: begin
268: hr_utility.set_location('Entering:'|| l_proc, 10);
269: --
270: -- Issue a savepoint
271: --
272: savepoint delete_user_table;

Line 325: hr_utility.set_location(' Leaving:'||l_proc, 70);

321: ---For MLS----------------------------------------------------------------------
322: pay_ptt_del.del_tl(p_user_table_id);
323: --------------------------------------------------------------------------------
324:
325: hr_utility.set_location(' Leaving:'||l_proc, 70);
326: exception
327: when hr_api.validate_enabled then
328: --
329: -- As the Validate_Enabled exception has been raised

Line 339: hr_utility.set_location(' Leaving:'||l_proc, 80);

335: -- (Any key or derived arguments must be set to null
336: -- when validation only mode is being used.)
337: --
338: p_object_version_number := null;
339: hr_utility.set_location(' Leaving:'||l_proc, 80);
340: when others then
341: --
342: -- A validation or unexpected error has occured
343: --

Line 345: hr_utility.set_location(' Leaving:'||l_proc, 90);

341: --
342: -- A validation or unexpected error has occured
343: --
344: rollback to delete_user_table;
345: hr_utility.set_location(' Leaving:'||l_proc, 90);
346: raise;
347: end delete_user_table;
348: --
349: end pay_user_table_api;