APPS.HR_USER_ACCT_EMP_EXTRACT dependencies on HR_UTILITY

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

177: l_unique_str varchar2(200);
178: --
179: BEGIN
180: --
181: hr_utility.set_location('Entering ' || l_proc, 10);
182:
183: IF p_batch_name is NULL
184: THEN
185: fnd_message.set_name('PER', 'HR_BATCH_NAME_NOT_SPECIFIED');

Line 200: hr_utility.set_location('run_type=' || p_run_type, 20);

196: fnd_message.raise_error;
197: END IF;
198: END IF;
199: --
200: hr_utility.set_location('run_type=' || p_run_type, 20);
201:
202: -- Check run type
203: -----------------------------------------------------------------------------
204: -- NOTE:

Line 683: hr_utility.set_location('In executing create user dynamic sql..', 35);

679: upper(p_run_type) = hr_user_acct_utility.g_cr_n_inact_user OR
680: upper(p_run_type) = hr_user_acct_utility.g_cr_user_all_emp
681: THEN
682: BEGIN
683: hr_utility.set_location('In executing create user dynamic sql..', 35);
684:
685: dbms_sql.parse(l_dynamic_cursor_id, l_sql_clause, dbms_sql.v7); -- Step 2
686: -- ************************************************************************
687: -- NOTE:If we retrieve extra column,need to set the l_index accordingly.

Line 870: hr_utility.set_location('In executing inactivate user dynamic sql..', 37);

866: l_dynamic_cursor_id := dbms_sql.open_cursor; -- Step 1
867:
868: BEGIN
869:
870: hr_utility.set_location('In executing inactivate user dynamic sql..', 37);
871:
872: dbms_sql.parse(l_dynamic_cursor_id, l_inactivate_user_sql_clause
873: ,dbms_sql.v7); -- Step 2
874: -- ************************************************************************

Line 1023: hr_utility.set_location('Leaving ' || l_proc, 10);

1019: END IF;
1020: --
1021: retcode := 0;
1022:
1023: hr_utility.set_location('Leaving ' || l_proc, 10);
1024:
1025: return;
1026: --
1027: EXCEPTION

Line 1029: hr_utility.trace ('Error in the '|| l_proc ||' - ORA '||

1025: return;
1026: --
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: hr_utility.trace ('Error in the '|| l_proc ||' - ORA '||
1030: to_char(SQLCODE));
1031: errbuf := sqlerrm;
1032: retcode := 2;
1033: rollback;