DBA Data[Home] [Help]

APPS.BEN_DM_INPUT_FILE_PKG dependencies on HR_UTILITY

Line 30: g_debug boolean := hr_utility.debug_enabled;

26: ssn varchar2(80),
27: ind number);
28: Type contactTab is Table of contactRec index by binary_integer;
29: --
30: g_debug boolean := hr_utility.debug_enabled;
31: g_package varchar2(33) := 'ben_dm_input_file.';
32: g_missing_fields exception;
33: g_invalid_record exception;
34: --

Line 82: hr_utility.set_location('error encountered ',10);

78: return l_fields;
79:
80: exception
81: when others then
82: hr_utility.set_location('error encountered ',10);
83: end split_line;
84: --
85: -- ----------------------------------------------------------------------------
86: -- |------------------------------< add_to_set>------------------------------|

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

154: from per_all_people_f per2
155: where per2.person_id = per1.person_id);
156:
157: begin
158: hr_utility.set_location('Entering '||l_proc,5);
159: --
160: -- Ensure that all the mandatory arguments are not null
161: --
162: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 334: hr_utility.set_location('deleting existing records',10);

330:
331:
332: end loop;
333: --
334: hr_utility.set_location('deleting existing records',10);
335: --
336: delete from ben_dm_input_file;
337: --
338: hr_utility.set_location('bulk inserting new records',10);

Line 338: hr_utility.set_location('bulk inserting new records',10);

334: hr_utility.set_location('deleting existing records',10);
335: --
336: delete from ben_dm_input_file;
337: --
338: hr_utility.set_location('bulk inserting new records',10);
339: --
340: l_line_count := l_inp_rec.count;
341: --
342: -- skip groups that have one or more person records with null SSN

Line 435: hr_utility.set_location('Leaving '||l_proc,5);

431: end if;
432:
433: end loop;
434:
435: hr_utility.set_location('Leaving '||l_proc,5);
436: exception
437: when utl_file.invalid_path then
438: rollback;
439: fnd_message.set_name('BEN', 'BEN_91874_EXT_DRCTRY_ERR'); --9999