APPS.HR_DM_DELETE dependencies on HR_UTILITY

Line 179: hr_utility.set_trace_options('TRACE_DEST:DBMS_OUTPUT');

175: --
176: BEGIN
177: --
178:
179: hr_utility.set_trace_options('TRACE_DEST:DBMS_OUTPUT');
180: hr_utility.trace_on;
181:
182: -- find the security group id
183: OPEN csr_sec_grp;

Line 180: hr_utility.trace_on;

176: BEGIN
177: --
178:
179: hr_utility.set_trace_options('TRACE_DEST:DBMS_OUTPUT');
180: hr_utility.trace_on;
181:
182: -- find the security group id
183: OPEN csr_sec_grp;
184: FETCH csr_sec_grp INTO l_security_group_id;

Line 199: hr_utility.trace('Deleting lookup type ' || l_lookup_type ||

195: FETCH csr_lu_type INTO l_lookup_type,
196: l_view_application_id;
197: EXIT WHEN csr_lu_type%NOTFOUND;
198:
199: hr_utility.trace('Deleting lookup type ' || l_lookup_type ||
200: ' (' || l_view_application_id ||
201: ') and associated lookup codes');
202:
203: -- find the codes to delete and delete them

Line 243: hr_utility.trace('Deleting user/resp (' ||

239: l_security_group;
240:
241: EXIT WHEN csr_usrresgrp%NOTFOUND;
242:
243: hr_utility.trace('Deleting user/resp (' ||
244: l_username || '/' ||
245: l_resp_app || '/' ||
246: l_resp_key || '/' ||
247: l_security_group || ')');

Line 270: hr_utility.trace('An error occurred whilst deleting fnd information:');

266:
267: -- error handling
268: EXCEPTION
269: WHEN OTHERS THEN
270: hr_utility.trace('An error occurred whilst deleting fnd information:');
271: hr_utility.trace(SQLERRM || ' in hr_dm_delete.del_fnd_info');
272: RAISE;
273:
274: --

Line 271: hr_utility.trace(SQLERRM || ' in hr_dm_delete.del_fnd_info');

267: -- error handling
268: EXCEPTION
269: WHEN OTHERS THEN
270: hr_utility.trace('An error occurred whilst deleting fnd information:');
271: hr_utility.trace(SQLERRM || ' in hr_dm_delete.del_fnd_info');
272: RAISE;
273:
274: --
275: END del_fnd_info;