DBA Data[Home] [Help]

APPS.PAY_AU_LEAVE_LIABILITY dependencies on HR_UTILITY

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

35:
36: begin
37: l_procedure_name := 'pay_au_leave_liability.range_code' ;
38:
39: hr_utility.trace('In: ' || l_procedure_name) ;
40:
41: -- set up a SQL statement that defines the set of people to process
42: -- required by the PAR process
43:

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

71: 'p.person_id ' ;
72:
73: p_sql := l_sql ;
74:
75: hr_utility.trace('Out: ' || l_procedure_name) ;
76:
77: end range_code ;
78:
79: -----------------------------------------------------------------------------

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

134: begin
135:
136: l_procedure_name := 'pay_au_leave_liability.assignment_action_code' ;
137:
138: hr_utility.trace('In: ' || l_procedure_name) ;
139:
140: -- loop through the qualifying assignments
141:
142: for r_assignment in c_assignments(p_payroll_action_id

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

160: ,null) ;
161:
162: end loop ; -- c_assignments
163:
164: hr_utility.trace('Out: ' || l_procedure_name) ;
165:
166: end assignment_action_code ;
167:
168: -----------------------------------------------------------------------------

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

179: begin
180:
181: l_procedure_name := 'pay_au_leave_liability.initialization_code' ;
182:
183: hr_utility.trace('In: ' || l_procedure_name) ;
184:
185: -- do nothing: no global contexts need to be set
186:
187: hr_utility.trace('Out: ' || l_procedure_name) ;

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

183: hr_utility.trace('In: ' || l_procedure_name) ;
184:
185: -- do nothing: no global contexts need to be set
186:
187: hr_utility.trace('Out: ' || l_procedure_name) ;
188:
189: end initialization_code ;
190:
191: -----------------------------------------------------------------------------

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

260: begin
261:
262: l_procedure_name := 'pay_au_leave_liability.archive_code' ;
263:
264: hr_utility.trace('In: ' || l_procedure_name) ;
265:
266: -- find out the generic code caller process ID for
267: -- AU leave liability
268: hr_utility.trace('P_assignment_action_id' || P_assignment_action_id) ;

Line 268: hr_utility.trace('P_assignment_action_id' || P_assignment_action_id) ;

264: hr_utility.trace('In: ' || l_procedure_name) ;
265:
266: -- find out the generic code caller process ID for
267: -- AU leave liability
268: hr_utility.trace('P_assignment_action_id' || P_assignment_action_id) ;
269:
270: hr_utility.trace('Accrual category ' || l_Accrual_category) ;
271:
272:

Line 270: hr_utility.trace('Accrual category ' || l_Accrual_category) ;

266: -- find out the generic code caller process ID for
267: -- AU leave liability
268: hr_utility.trace('P_assignment_action_id' || P_assignment_action_id) ;
269:
270: hr_utility.trace('Accrual category ' || l_Accrual_category) ;
271:
272:
273:
274: -- the generic code caller requires parameters to be passed

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

333: ,p_input_store => l_gcc_parameters_store) ;
334:
335: end loop ; -- c_accrual_plans
336:
337: hr_utility.trace('Out: ' || l_procedure_name) ;
338:
339: end archive_code ;
340:
341: -----------------------------------------------------------------------------

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

391: begin
392:
393: l_procedure_name := 'execute_formula' ;
394:
395: hr_utility.trace(' In: ' || l_procedure_name) ;
396:
397: -- get the module ID for the formula
398:
399: open c_module(p_formula_name

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

414: pay_au_generic_code_caller.execute_formula
415: (l_module_id
416: ,p_formula_name) ;
417:
418: hr_utility.trace(' Out: ' || l_procedure_name) ;
419: exception
420: when e_bad_module
421: then
422: hr_utility.set_message(801, 'HR_AU_INVALID_MODULE') ;

Line 422: hr_utility.set_message(801, 'HR_AU_INVALID_MODULE') ;

418: hr_utility.trace(' Out: ' || l_procedure_name) ;
419: exception
420: when e_bad_module
421: then
422: hr_utility.set_message(801, 'HR_AU_INVALID_MODULE') ;
423: hr_utility.set_message_token('MODULE_NAME',p_formula_name);
424: hr_utility.raise_error ;
425: end execute_formula ;
426:

Line 423: hr_utility.set_message_token('MODULE_NAME',p_formula_name);

419: exception
420: when e_bad_module
421: then
422: hr_utility.set_message(801, 'HR_AU_INVALID_MODULE') ;
423: hr_utility.set_message_token('MODULE_NAME',p_formula_name);
424: hr_utility.raise_error ;
425: end execute_formula ;
426:
427: begin

Line 424: hr_utility.raise_error ;

420: when e_bad_module
421: then
422: hr_utility.set_message(801, 'HR_AU_INVALID_MODULE') ;
423: hr_utility.set_message_token('MODULE_NAME',p_formula_name);
424: hr_utility.raise_error ;
425: end execute_formula ;
426:
427: begin
428:

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

427: begin
428:
429: l_procedure_name := 'pay_au_leave_liability.hourly_rate' ;
430:
431: hr_utility.trace('In: ' || l_procedure_name) ;
432:
433: -- get the BUSINESS_GROUP_ID from the PL/SQL table of
434: -- variables maintained by the generic code caller
435:

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

494: then
495: raise e_bad_hourly_rate ;
496: end if ;
497:
498: hr_utility.trace('Out: ' || l_procedure_name) ;
499:
500: exception
501: when e_bad_hourly_rate
502: then

Line 503: hr_utility.set_message(801, 'HR_AU_BAD_HOURLY_RATE') ;

499:
500: exception
501: when e_bad_hourly_rate
502: then
503: hr_utility.set_message(801, 'HR_AU_BAD_HOURLY_RATE') ;
504: hr_utility.raise_error ;
505:
506: end hourly_rate ;
507:

Line 504: hr_utility.raise_error ;

500: exception
501: when e_bad_hourly_rate
502: then
503: hr_utility.set_message(801, 'HR_AU_BAD_HOURLY_RATE') ;
504: hr_utility.raise_error ;
505:
506: end hourly_rate ;
507:
508: procedure leave_net_entitlement

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

522: begin
523:
524: l_procedure_name := 'pay_au_leave_liability.annual_leave_net_entitlement' ;
525:
526: hr_utility.trace('In: ' || l_procedure_name) ;
527: l_get_accrual_value := hr_au_holidays.get_accrual_entitlement(p_assignment_id
528: ,p_payroll_id
529: ,p_business_group_id
530: ,p_plan_id

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

534: ,p_start_date
535: ,p_end_date
536: ,l_next_period_end
537: );
538: hr_utility.trace('out: ' || l_procedure_name) ;
539: -- exception
540: -- when others then
541: end leave_net_entitlement;
542:

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

556: begin
557:
558: l_procedure_name := 'pay_au_leave_liability.leave_net_accrual' ;
559:
560: hr_utility.trace('In: ' || l_procedure_name) ;
561: l_get_accrual_value :=
562: hr_au_holidays.get_accrual_entitlement
563: (p_assignment_id
564: ,p_payroll_id

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

570: ,p_calc_start_date
571: ,p_last_accrual
572: ,p_next_period_end ) ;
573:
574: hr_utility.trace('out: ' || l_procedure_name) ;
575: exception
576: when others then
577: hr_utility.trace('exception: ' || l_procedure_name) ;
578: end leave_net_accrual;

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

573:
574: hr_utility.trace('out: ' || l_procedure_name) ;
575: exception
576: when others then
577: hr_utility.trace('exception: ' || l_procedure_name) ;
578: end leave_net_accrual;
579:
580: /*---------------------------------------------------------------------
581: Name : get_weekdays_in_period

Line 597: hr_utility.trace('In: '||l_proc);

593: l_day DATE;
594: BEGIN
595: l_proc := 'get_weekdays_in_period';
596:
597: hr_utility.trace('In: '||l_proc);
598: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
599: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
600:
601:

Line 598: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;

594: BEGIN
595: l_proc := 'get_weekdays_in_period';
596:
597: hr_utility.trace('In: '||l_proc);
598: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
599: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
600:
601:
602: IF (p_start_date > p_end_date)

Line 599: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;

595: l_proc := 'get_weekdays_in_period';
596:
597: hr_utility.trace('In: '||l_proc);
598: hr_utility.trace(' p_start_date: ' || to_char(p_start_date,'dd Mon yyyy')) ;
599: hr_utility.trace(' p_end_date: ' || to_char(p_end_date,'dd Mon yyyy')) ;
600:
601:
602: IF (p_start_date > p_end_date)
603: THEN

Line 604: hr_utility.trace('Crash Out: '||l_proc);

600:
601:
602: IF (p_start_date > p_end_date)
603: THEN
604: hr_utility.trace('Crash Out: '||l_proc);
605: hr_utility.set_message(801,'HR_AU_INVALID_DATE_RANGE');
606: hr_utility.raise_error;
607: END IF;
608:

Line 605: hr_utility.set_message(801,'HR_AU_INVALID_DATE_RANGE');

601:
602: IF (p_start_date > p_end_date)
603: THEN
604: hr_utility.trace('Crash Out: '||l_proc);
605: hr_utility.set_message(801,'HR_AU_INVALID_DATE_RANGE');
606: hr_utility.raise_error;
607: END IF;
608:
609: hr_utility.set_location(l_proc,5);

Line 606: hr_utility.raise_error;

602: IF (p_start_date > p_end_date)
603: THEN
604: hr_utility.trace('Crash Out: '||l_proc);
605: hr_utility.set_message(801,'HR_AU_INVALID_DATE_RANGE');
606: hr_utility.raise_error;
607: END IF;
608:
609: hr_utility.set_location(l_proc,5);
610: l_day := p_start_date;

Line 609: hr_utility.set_location(l_proc,5);

605: hr_utility.set_message(801,'HR_AU_INVALID_DATE_RANGE');
606: hr_utility.raise_error;
607: END IF;
608:
609: hr_utility.set_location(l_proc,5);
610: l_day := p_start_date;
611: WHILE (l_day <= p_end_date)
612: LOOP
613: IF (TO_CHAR(l_day,'DY') IN ('MON','TUE','WED','THU','FRI'))

Line 619: hr_utility.trace(' return: ' || to_char(l_day_count)) ;

615: l_day_count := l_day_count + 1;
616: END IF;
617: l_day := l_day + 1;
618: END LOOP;
619: hr_utility.trace(' return: ' || to_char(l_day_count)) ;
620: hr_utility.trace('Out: '||l_proc);
621: RETURN l_day_count;
622:
623: END get_weekdays_in_period;

Line 620: hr_utility.trace('Out: '||l_proc);

616: END IF;
617: l_day := l_day + 1;
618: END LOOP;
619: hr_utility.trace(' return: ' || to_char(l_day_count)) ;
620: hr_utility.trace('Out: '||l_proc);
621: RETURN l_day_count;
622:
623: END get_weekdays_in_period;
624: