DBA Data[Home] [Help]

APPS.HR_DM_SEED_DP dependencies on HR_DM_UTILITY

Line 18: hr_dm_utility.message('ROUT','entry:hr_dm_seed_dp.seed_api', 5);

14: p_data_within_business_group in varchar2 default 'Y',
15: p_legislation_code in varchar2 default null
16: ) is
17: begin
18: hr_dm_utility.message('ROUT','entry:hr_dm_seed_dp.seed_api', 5);
19: hr_dm_utility.message('PARA','(p_module_name - ' || p_module_name ||
20: ')(p_module_type - ' || p_module_type ||
21: ')(p_module_package - ' || p_module_package ||
22: ')(p_data_within_business_group - ' ||

Line 19: hr_dm_utility.message('PARA','(p_module_name - ' || p_module_name ||

15: p_legislation_code in varchar2 default null
16: ) is
17: begin
18: hr_dm_utility.message('ROUT','entry:hr_dm_seed_dp.seed_api', 5);
19: hr_dm_utility.message('PARA','(p_module_name - ' || p_module_name ||
20: ')(p_module_type - ' || p_module_type ||
21: ')(p_module_package - ' || p_module_package ||
22: ')(p_data_within_business_group - ' ||
23: p_data_within_business_group ||

Line 49: hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.seed_api', 25);

45: from hr_api_modules m
46: where m.module_name = p_module_name
47: and m.api_module_type = p_module_type);
48:
49: hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.seed_api', 25);
50: -- error handling
51: exception
52: when others then
53: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.seed_api',

Line 53: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.seed_api',

49: hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.seed_api', 25);
50: -- error handling
51: exception
52: when others then
53: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.seed_api',
54: '(p_module_name - ' || p_module_name ||
55: ')(p_module_type - ' || p_module_type ||
56: ')(p_module_package - ' || p_module_package ||
57: ')(p_data_within_business_group - ' ||

Line 79: hr_dm_utility.message('ROUT','entry:hr_dm_seed_dp.insert_dp_parameters', 5);

75: p_mapping_def in varchar2 default null,
76: p_default_value in varchar2 default null
77: ) is
78: begin
79: hr_dm_utility.message('ROUT','entry:hr_dm_seed_dp.insert_dp_parameters', 5);
80: hr_dm_utility.message('PARA','(p_module_name - ' || p_module_name ||
81: ')(p_module_type - ' || p_module_type ||
82: ')(p_parameter_name - ' || p_parameter_name ||
83: ')(p_mapping_type - ' || p_mapping_type ||

Line 80: hr_dm_utility.message('PARA','(p_module_name - ' || p_module_name ||

76: p_default_value in varchar2 default null
77: ) is
78: begin
79: hr_dm_utility.message('ROUT','entry:hr_dm_seed_dp.insert_dp_parameters', 5);
80: hr_dm_utility.message('PARA','(p_module_name - ' || p_module_name ||
81: ')(p_module_type - ' || p_module_type ||
82: ')(p_parameter_name - ' || p_parameter_name ||
83: ')(p_mapping_type - ' || p_mapping_type ||
84: ')(p_mapping_def - ' || p_mapping_def ||

Line 109: hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.insert_dp_parameters', 25);

105: from hr_pump_module_parameters p
106: where p.module_name = p_module_name
107: and p.api_module_type = p_module_type
108: and p.api_parameter_name = p_parameter_name);
109: hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.insert_dp_parameters', 25);
110: -- error handling
111: exception
112: when others then
113: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.insert_dp_parameters',

Line 113: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.insert_dp_parameters',

109: hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.insert_dp_parameters', 25);
110: -- error handling
111: exception
112: when others then
113: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.insert_dp_parameters',
114: '(p_module_name - ' || p_module_name ||
115: ')(p_module_type - ' || p_module_type ||
116: ')(p_parameter_name - ' || p_parameter_name ||
117: ')(p_mapping_type - ' || p_mapping_type ||

Line 141: hr_dm_utility.message('ROUT','entry:hr_dm_seed_dp.seed_id_parameters', 5);

137: l_list_index number;
138: l_column_name varchar2(30);
139: begin
140:
141: hr_dm_utility.message('ROUT','entry:hr_dm_seed_dp.seed_id_parameters', 5);
142: hr_dm_utility.message('PARA','(p_module_name - ' || p_module_name ||
143: ')(p_module_type - ' || p_module_type ||
144: ')', 10);
145:

Line 142: hr_dm_utility.message('PARA','(p_module_name - ' || p_module_name ||

138: l_column_name varchar2(30);
139: begin
140:
141: hr_dm_utility.message('ROUT','entry:hr_dm_seed_dp.seed_id_parameters', 5);
142: hr_dm_utility.message('PARA','(p_module_name - ' || p_module_name ||
143: ')(p_module_type - ' || p_module_type ||
144: ')', 10);
145:
146: -- initialise the variables

Line 172: hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.seed_id_parameters', 25);

168:
169: end if;
170: l_list_index := p_columns_tbl.next(l_list_index);
171: end loop;
172: hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.seed_id_parameters', 25);
173: -- error handling
174: exception
175: when others then
176: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.seed_id_parameters',

Line 176: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.seed_id_parameters',

172: hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.seed_id_parameters', 25);
173: -- error handling
174: exception
175: when others then
176: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.seed_id_parameters',
177: '(p_module_name - ' || p_module_name ||
178: ')(p_module_type - ' || p_module_type ||
179: ')','R');
180: raise;

Line 212: hr_dm_utility.message('ROUT','entry:hr_dm_seed_dp.seed_data', 5);

208: l_module_name varchar2(30);
209: l_module_type varchar2(30);
210: l_module_package varchar2(30);
211: begin
212: hr_dm_utility.message('ROUT','entry:hr_dm_seed_dp.seed_data', 5);
213: hr_dm_utility.message('PARA','(p_seed_type - ' || p_seed_type ||
214: ')', 10);
215: --
216: -- initialise the data. set the standatrd TUPS module and

Line 213: hr_dm_utility.message('PARA','(p_seed_type - ' || p_seed_type ||

209: l_module_type varchar2(30);
210: l_module_package varchar2(30);
211: begin
212: hr_dm_utility.message('ROUT','entry:hr_dm_seed_dp.seed_data', 5);
213: hr_dm_utility.message('PARA','(p_seed_type - ' || p_seed_type ||
214: ')', 10);
215: --
216: -- initialise the data. set the standatrd TUPS module and
217: -- main upload procedure name

Line 242: hr_dm_utility.message('INFO','Calling datapump meta mapper with ' ||

238:
239: -- generate the view and package for the TUPS module seeded
240: -- above.
241:
242: hr_dm_utility.message('INFO','Calling datapump meta mapper with ' ||
243: 'parameters of (l_module_package - ' ||
244: l_module_package || ')(l_module_name - ' ||
245: l_module_name || ')', 15);
246: begin

Line 251: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.seed_data',

247: hr_pump_meta_mapper.generate(l_module_package,
248: l_module_name);
249: exception
250: when others then
251: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.seed_data',
252: 'Error from hr_pump_meta_mapper.generate'
253: ,'R');
254: raise;
255: end;

Line 256: hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.seed_data', 25);

252: 'Error from hr_pump_meta_mapper.generate'
253: ,'R');
254: raise;
255: end;
256: hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.seed_data', 25);
257: -- error handling
258: exception
259: when others then
260: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.seed_data',

Line 260: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.seed_data',

256: hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.seed_data', 25);
257: -- error handling
258: exception
259: when others then
260: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.seed_data',
261: '(p_seed_type - ' || p_seed_type ||
262: ')','R');
263: raise;
264: end seed_data;

Line 284: hr_dm_utility.message('ROUT','entry:hr_dm_seed_dp.main', 5);

280: )
281:
282: is
283: begin
284: hr_dm_utility.message('ROUT','entry:hr_dm_seed_dp.main', 5);
285: seed_data(p_table_info => p_table_info,
286: p_columns_tbl => p_columns_tbl,
287: p_seed_type => 'NORMAL');
288:

Line 297: hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.main', 25);

293: seed_data(p_table_info => p_table_info,
294: p_columns_tbl => p_columns_tbl,
295: p_seed_type => 'HIERARCHY');
296: end if;
297: hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.main', 25);
298: -- error handling
299: exception
300: when others then
301: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.main','(none)','R');

Line 301: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.main','(none)','R');

297: hr_dm_utility.message('ROUT','exit:hr_dm_seed_dp.main', 25);
298: -- error handling
299: exception
300: when others then
301: hr_dm_utility.error(SQLCODE,'hr_dm_seed_dp.main','(none)','R');
302: raise;
303: end main;
304:
305: end hr_dm_seed_dp ;