DBA Data[Home] [Help]

APPS.HR_SUM_STORE dependencies on HR_SUM_STORE

Line 1: package body hr_sum_store as

1: package body hr_sum_store as
2: /* $Header: hrsumsto.pkb 115.8 2003/05/22 10:36:03 jheer noship $ */
3: --
4: procedure store_data (p_business_group_id in number,
5: p_item_name in varchar2,

Line 48: hr_utility.set_location('Entering: hr_sum_store.store_data', 10);

44: --
45:
46: begin
47: --
48: hr_utility.set_location('Entering: hr_sum_store.store_data', 10);
49: --
50: p_error := 0; /* Default error parameter to zero to indicate success */
51: source_cursor := dbms_sql.open_cursor;
52: --

Line 318: hr_utility.set_location('Leaving: hr_sum_store.store_data', 20);

314: end loop;
315: --
316: -- hrsumrep.write_error(p_itu_name||': '||z);
317: --
318: hr_utility.set_location('Leaving: hr_sum_store.store_data', 20);
319: --
320: exception when others then
321: p_error := 1; /* If error occurs set p_error to 1 to indicate error */
322: if l_error_mesg is null then

Line 323: hr_utility.trace('exception in HR_SUM_STORE');

319: --
320: exception when others then
321: p_error := 1; /* If error occurs set p_error to 1 to indicate error */
322: if l_error_mesg is null then
323: hr_utility.trace('exception in HR_SUM_STORE');
324: hr_utility.trace(SQLCODE);
325: hr_utility.trace(SQLERRM);
326: hrsumrep.write_stmt_log(p_stmt => l_new_stmt);
327: null;

Line 329: hr_utility.trace('error in HR_SUM_STORE');

325: hr_utility.trace(SQLERRM);
326: hrsumrep.write_stmt_log(p_stmt => l_new_stmt);
327: null;
328: else
329: hr_utility.trace('error in HR_SUM_STORE');
330: hrsumrep.write_error(null);
331: hrsumrep.write_error(l_error_mesg);
332: hrsumrep.write_error(sqlerrm);
333: -- hrsumrep.write_stmt_log(p_stmt => p_stmt);

Line 340: end hr_sum_store;

336: end dynamic_block;
337: dbms_sql.close_cursor(source_cursor);
338: end store_data;
339:
340: end hr_sum_store;