DBA Data[Home] [Help]

APPS.PAY_NZ_LEAVE_LIABILITY dependencies on HR_UTILITY

Line 37: -- hr_utility.trace_on(null,'ll_archive') ;

33: l_sql varchar2(4000) ;
34: l_procedure_name varchar2(61) := 'pay_nz_leave_liability.range_code' ;
35:
36: begin
37: -- hr_utility.trace_on(null,'ll_archive') ;
38: hr_utility.trace('In: ' || l_procedure_name) ;
39:
40: -- set up a SQL statement that defines the set of people to process
41: -- required by the PAR process

Line 38: hr_utility.trace('In: ' || l_procedure_name) ;

34: l_procedure_name varchar2(61) := 'pay_nz_leave_liability.range_code' ;
35:
36: begin
37: -- hr_utility.trace_on(null,'ll_archive') ;
38: hr_utility.trace('In: ' || l_procedure_name) ;
39:
40: -- set up a SQL statement that defines the set of people to process
41: -- required by the PAR process
42:

Line 71: hr_utility.trace('Out: ' || l_procedure_name) ;

67: 'p.person_id ' ;
68:
69: p_sql := l_sql ;
70:
71: hr_utility.trace('Out: ' || l_procedure_name) ;
72:
73: end range_code ;
74:
75: -----------------------------------------------------------------------------

Line 129: hr_utility.trace('In: ' || l_procedure_name) ;

125: from dual ;
126:
127: begin
128:
129: hr_utility.trace('In: ' || l_procedure_name) ;
130:
131: -- loop through the qualifying assignments
132:
133: for r_assignment in c_assignments(p_payroll_action_id

Line 155: hr_utility.trace('Out: ' || l_procedure_name) ;

151: ,null) ;
152:
153: end loop ; -- c_assignments
154:
155: hr_utility.trace('Out: ' || l_procedure_name) ;
156:
157: end assignment_action_code ;
158:
159: -----------------------------------------------------------------------------

Line 172: hr_utility.trace('In: ' || l_procedure_name) ;

168: l_procedure_name varchar2(61) := 'pay_nz_leave_liability.initialization_code' ;
169:
170: begin
171:
172: hr_utility.trace('In: ' || l_procedure_name) ;
173:
174: -- do nothing: no global contexts need to be set
175:
176: hr_utility.trace('Out: ' || l_procedure_name) ;

Line 176: hr_utility.trace('Out: ' || l_procedure_name) ;

172: hr_utility.trace('In: ' || l_procedure_name) ;
173:
174: -- do nothing: no global contexts need to be set
175:
176: hr_utility.trace('Out: ' || l_procedure_name) ;
177:
178: end initialization_code ;
179:
180: -----------------------------------------------------------------------------

Line 239: hr_utility.trace('In: ' || l_procedure_name) ;

235: and el.effective_end_date ;
236:
237: begin
238:
239: hr_utility.trace('In: ' || l_procedure_name) ;
240:
241: -- find out the generic code caller process ID for
242: -- NZ leave liability
243:

Line 316: hr_utility.trace('Out: ' || l_procedure_name) ;

312: ,p_input_store => l_gcc_parameters_store) ;
313:
314: end loop ; -- c_accrual_plans
315:
316: hr_utility.trace('Out: ' || l_procedure_name) ;
317:
318: end archive_code ;
319:
320: -----------------------------------------------------------------------------

Line 361: hr_utility.trace(' In: ' || l_procedure_name) ;

357: or (m.legislation_code = p_legislation_code)) ;
358:
359: begin
360:
361: hr_utility.trace(' In: ' || l_procedure_name) ;
362:
363: -- get the module ID for the formula
364:
365: open c_module(p_formula_name

Line 384: hr_utility.trace(' Out: ' || l_procedure_name) ;

380: pay_au_generic_code_caller.execute_formula
381: (l_module_id
382: ,p_formula_name) ;
383:
384: hr_utility.trace(' Out: ' || l_procedure_name) ;
385:
386: end execute_formula ;
387:
388: begin

Line 390: hr_utility.trace('In: ' || l_procedure_name) ;

386: end execute_formula ;
387:
388: begin
389:
390: hr_utility.trace('In: ' || l_procedure_name) ;
391:
392: -- get the BUSINESS_GROUP_ID from the PL/SQL table of
393: -- variables maintained by the generic code caller
394:

Line 441: hr_utility.trace('Out: ' || l_procedure_name) ;

437: then
438: raise e_bad_hourly_rate ;
439: end if ;
440:
441: hr_utility.trace('Out: ' || l_procedure_name) ;
442:
443: exception
444: when e_bad_module
445: then

Line 446: hr_utility.set_message(801, 'HR_NZ_INVALID_MODULE') ;

442:
443: exception
444: when e_bad_module
445: then
446: hr_utility.set_message(801, 'HR_NZ_INVALID_MODULE') ;
447: hr_utility.raise_error ;
448: when e_bad_hourly_rate
449: then
450: hr_utility.set_message(801, 'HR_NZ_BAD_HOURLY_RATE') ;

Line 447: hr_utility.raise_error ;

443: exception
444: when e_bad_module
445: then
446: hr_utility.set_message(801, 'HR_NZ_INVALID_MODULE') ;
447: hr_utility.raise_error ;
448: when e_bad_hourly_rate
449: then
450: hr_utility.set_message(801, 'HR_NZ_BAD_HOURLY_RATE') ;
451: hr_utility.raise_error ;

Line 450: hr_utility.set_message(801, 'HR_NZ_BAD_HOURLY_RATE') ;

446: hr_utility.set_message(801, 'HR_NZ_INVALID_MODULE') ;
447: hr_utility.raise_error ;
448: when e_bad_hourly_rate
449: then
450: hr_utility.set_message(801, 'HR_NZ_BAD_HOURLY_RATE') ;
451: hr_utility.raise_error ;
452:
453: end hourly_rate ;
454:

Line 451: hr_utility.raise_error ;

447: hr_utility.raise_error ;
448: when e_bad_hourly_rate
449: then
450: hr_utility.set_message(801, 'HR_NZ_BAD_HOURLY_RATE') ;
451: hr_utility.raise_error ;
452:
453: end hourly_rate ;
454:
455:

Line 471: hr_utility.trace('In: ' || l_procedure_name) ;

467: l_procedure_name varchar2(61) := 'pay_nz_leave_liability.leave_net_accrual' ;
468: l_get_accrual_value number ;
469: begin
470:
471: hr_utility.trace('In: ' || l_procedure_name) ;
472: l_get_accrual_value :=
473: hr_nz_holidays.get_accrual_entitlement
474: (p_assignment_id
475: ,p_payroll_id

Line 485: hr_utility.trace('out: ' || l_procedure_name) ;

481: ,p_calc_start_date
482: ,p_last_accrual
483: ,p_next_period_end ) ;
484:
485: hr_utility.trace('out: ' || l_procedure_name) ;
486: exception
487: when others then
488: hr_utility.trace('exception: ' || l_procedure_name) ;
489: end leave_net_accrual;

Line 488: hr_utility.trace('exception: ' || l_procedure_name) ;

484:
485: hr_utility.trace('out: ' || l_procedure_name) ;
486: exception
487: when others then
488: hr_utility.trace('exception: ' || l_procedure_name) ;
489: end leave_net_accrual;
490:
491:
492: function retrieve_variable(P_NAME IN VARCHAR2,