eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_SI_PKG dependencies on HR_UTILITY

Line 101: hr_utility.set_location('Entering ' || l_proc, 100);

97: /*l_exclusion_date VARCHAR2(4);*/
98: l_date_earned VARCHAR2(8);
99: l_proc varchar2(100) := g_package||'get_si_status';
100: BEGIN
101: hr_utility.set_location('Entering ' || l_proc, 100);
102: hr_utility.set_location('p_assignment_id ' || p_assignment_id, 110);
103: hr_utility.set_location('p_si_class ' || p_si_class, 110);
104: hr_utility.set_location('p_date_earned ' || p_date_earned, 110);
105: l_zvw_status := 1;

Line 102: hr_utility.set_location('p_assignment_id ' || p_assignment_id, 110);

98: l_date_earned VARCHAR2(8);
99: l_proc varchar2(100) := g_package||'get_si_status';
100: BEGIN
101: hr_utility.set_location('Entering ' || l_proc, 100);
102: hr_utility.set_location('p_assignment_id ' || p_assignment_id, 110);
103: hr_utility.set_location('p_si_class ' || p_si_class, 110);
104: hr_utility.set_location('p_date_earned ' || p_date_earned, 110);
105: l_zvw_status := 1;
106: l_zvwl_status := 1;

Line 103: hr_utility.set_location('p_si_class ' || p_si_class, 110);

99: l_proc varchar2(100) := g_package||'get_si_status';
100: BEGIN
101: hr_utility.set_location('Entering ' || l_proc, 100);
102: hr_utility.set_location('p_assignment_id ' || p_assignment_id, 110);
103: hr_utility.set_location('p_si_class ' || p_si_class, 110);
104: hr_utility.set_location('p_date_earned ' || p_date_earned, 110);
105: l_zvw_status := 1;
106: l_zvwl_status := 1;
107: l_zvws_status := 1;

Line 104: hr_utility.set_location('p_date_earned ' || p_date_earned, 110);

100: BEGIN
101: hr_utility.set_location('Entering ' || l_proc, 100);
102: hr_utility.set_location('p_assignment_id ' || p_assignment_id, 110);
103: hr_utility.set_location('p_si_class ' || p_si_class, 110);
104: hr_utility.set_location('p_date_earned ' || p_date_earned, 110);
105: l_zvw_status := 1;
106: l_zvwl_status := 1;
107: l_zvws_status := 1;
108: OPEN Cur_SI_Status;

Line 172: hr_utility.set_location('Leaving' || l_proc, 500);

168: vCur_SI_Status.SI_Status := 0;
169: END IF;
170: END IF;*/
171:
172: hr_utility.set_location('Leaving' || l_proc, 500);
173: RETURN vCur_SI_Status.SI_Status;
174: EXCEPTION
175: WHEN OTHERS THEN
176: hr_utility.set_location(' Others :' || SQLERRM(SQLCODE),900);

Line 176: hr_utility.set_location(' Others :' || SQLERRM(SQLCODE),900);

172: hr_utility.set_location('Leaving' || l_proc, 500);
173: RETURN vCur_SI_Status.SI_Status;
174: EXCEPTION
175: WHEN OTHERS THEN
176: hr_utility.set_location(' Others :' || SQLERRM(SQLCODE),900);
177: END get_si_status;
178: --
179: -- Function to check if All Mandatory Insurances is chosen at the assignment level
180: --

Line 200: hr_utility.set_location('Entering ' || l_proc, 100);

196: order by si_class_order desc;
197: vCur_SI_AMI Cur_SI_AMI%ROWTYPE;
198: l_proc varchar2(100) := g_package||'get_si_status';
199: BEGIN
200: hr_utility.set_location('Entering ' || l_proc, 100);
201: hr_utility.set_location('p_assignment_id ' || p_assignment_id, 110);
202: hr_utility.set_location('p_date_earned ' || p_date_earned, 110);
203: OPEN Cur_SI_AMI;
204: FETCH Cur_SI_AMI INTO vCur_SI_AMI;

Line 201: hr_utility.set_location('p_assignment_id ' || p_assignment_id, 110);

197: vCur_SI_AMI Cur_SI_AMI%ROWTYPE;
198: l_proc varchar2(100) := g_package||'get_si_status';
199: BEGIN
200: hr_utility.set_location('Entering ' || l_proc, 100);
201: hr_utility.set_location('p_assignment_id ' || p_assignment_id, 110);
202: hr_utility.set_location('p_date_earned ' || p_date_earned, 110);
203: OPEN Cur_SI_AMI;
204: FETCH Cur_SI_AMI INTO vCur_SI_AMI;
205: CLOSE Cur_SI_AMI;

Line 202: hr_utility.set_location('p_date_earned ' || p_date_earned, 110);

198: l_proc varchar2(100) := g_package||'get_si_status';
199: BEGIN
200: hr_utility.set_location('Entering ' || l_proc, 100);
201: hr_utility.set_location('p_assignment_id ' || p_assignment_id, 110);
202: hr_utility.set_location('p_date_earned ' || p_date_earned, 110);
203: OPEN Cur_SI_AMI;
204: FETCH Cur_SI_AMI INTO vCur_SI_AMI;
205: CLOSE Cur_SI_AMI;
206: RETURN NVL(vCur_SI_AMI.si_class_order,0);

Line 209: hr_utility.set_location(' Others :' || SQLERRM(SQLCODE),900);

205: CLOSE Cur_SI_AMI;
206: RETURN NVL(vCur_SI_AMI.si_class_order,0);
207: EXCEPTION
208: WHEN OTHERS THEN
209: hr_utility.set_location(' Others :' || SQLERRM(SQLCODE),900);
210: RETURN 0;
211: END is_ami;
212: --
213: -- Function to get payroll type

Line 403: --hr_utility.set_location(' date_start'||l_absence_record.date_start,100);

399: and ses.session_id = userenv('sessionid')
400: and ses.effective_date between paa.effective_start_date and paa.effective_end_date;
401: for l_absence_record in Get_Non_SI_Absence(l_person_id)
402: loop
403: --hr_utility.set_location(' date_start'||l_absence_record.date_start,100);
404: --hr_utility.set_location(' date_end'||l_absence_record.date_end,100);
405: /*Check whether the start date and end date of the abscence period are equal*/
406: if l_absence_record.date_start = l_absence_record.date_end then
407: l_hrs_wrked:=pqp_schedule_calculation_pkg.get_hours_worked

Line 404: --hr_utility.set_location(' date_end'||l_absence_record.date_end,100);

400: and ses.effective_date between paa.effective_start_date and paa.effective_end_date;
401: for l_absence_record in Get_Non_SI_Absence(l_person_id)
402: loop
403: --hr_utility.set_location(' date_start'||l_absence_record.date_start,100);
404: --hr_utility.set_location(' date_end'||l_absence_record.date_end,100);
405: /*Check whether the start date and end date of the abscence period are equal*/
406: if l_absence_record.date_start = l_absence_record.date_end then
407: l_hrs_wrked:=pqp_schedule_calculation_pkg.get_hours_worked
408: (p_assignment_id => l_assgn_attr.assignment_id

Line 416: --hr_utility.set_location('l_absence_record.time_end'||l_absence_record.time_end,110);

412: ,p_error_code => l_error_code
413: ,p_error_message => l_error_msg
414: ,p_default_wp => NULL
415: );
416: --hr_utility.set_location('l_absence_record.time_end'||l_absence_record.time_end,110);
417: --hr_utility.set_location('l_absence_record.time_start'||l_absence_record.time_start,110);
418: --Bug 3085937
419: --shveerab
420: /*Added code to check time_end and time_start is null for the abscence defined*/

Line 417: --hr_utility.set_location('l_absence_record.time_start'||l_absence_record.time_start,110);

413: ,p_error_message => l_error_msg
414: ,p_default_wp => NULL
415: );
416: --hr_utility.set_location('l_absence_record.time_end'||l_absence_record.time_end,110);
417: --hr_utility.set_location('l_absence_record.time_start'||l_absence_record.time_start,110);
418: --Bug 3085937
419: --shveerab
420: /*Added code to check time_end and time_start is null for the abscence defined*/
421: if (l_absence_record.time_end is null and

Line 431: --hr_utility.set_location('l_absence_hours'||l_absence_hours,120);

427: /*Else the actual time difference between time_end and time_stard of the absence
428: should be assigned*/
429: l_absence_hours := (to_date('0001/01/01 '||l_absence_record.time_end,'yyyy/mm/dd hh24:mi') - to_date('0001/01/01 '||l_absence_record.time_start,'yyyy/mm/dd hh24:mi'))*24;
430: end if;
431: --hr_utility.set_location('l_absence_hours'||l_absence_hours,120);
432: l_wrking_day:= pqp_schedule_calculation_pkg.is_working_day
433: (p_assignment_id => l_assgn_attr.assignment_id
434: ,p_business_group_id => l_assgn_attr.business_group_id
435: ,p_date => l_absence_record.date_start

Line 446: --hr_utility.set_location('l_non_si_days'||l_non_si_days,150);

442: working day then non si absence days should be incremented by one*/
443: if l_absence_hours >= l_hrs_wrked and l_wrking_day='Y' then
444: l_non_si_days := l_non_si_days + 1;
445: end if;
446: --hr_utility.set_location('l_non_si_days'||l_non_si_days,150);
447: else
448: if l_absence_record.date_start > p_start_date then
449: l_temp1:= l_absence_record.date_start;
450: else

Line 576: -- hr_utility.trace('FORMULA EXISTS');

572: g_ptp_formula_id:=l_formula_id;
573: END IF;
574: --
575: IF g_ptp_formula_exists = TRUE THEN
576: -- hr_utility.trace('FORMULA EXISTS');
577: --
578: l_inputs(1).name := 'ASSIGNMENT_ID';
579: l_inputs(1).value := p_assignment_id;
580: l_inputs(2).name := 'DATE_EARNED';

Line 600: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

596: p_inputs => l_inputs,
597: p_outputs => l_outputs);
598: --
599: l_part_time_perc := l_outputs(1).value;
600: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
601: ELSE
602: -- hr_utility.trace('FORMULA DOESNT EXISTS');
603: l_part_time_perc := NULL;
604: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

Line 602: -- hr_utility.trace('FORMULA DOESNT EXISTS');

598: --
599: l_part_time_perc := l_outputs(1).value;
600: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
601: ELSE
602: -- hr_utility.trace('FORMULA DOESNT EXISTS');
603: l_part_time_perc := NULL;
604: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
605: END IF;
606: ELSIF g_ptp_formula_exists = FALSE THEN

Line 604: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

600: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
601: ELSE
602: -- hr_utility.trace('FORMULA DOESNT EXISTS');
603: l_part_time_perc := NULL;
604: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
605: END IF;
606: ELSIF g_ptp_formula_exists = FALSE THEN
607: l_part_time_perc := NULL;
608: END IF;

Line 650: -- hr_utility.trace('FORMULA EXISTS');

646: g_std_ptp_formula_id:=l_formula_id;
647: END IF;
648: --
649: IF g_std_ptp_formula_exists = TRUE THEN
650: -- hr_utility.trace('FORMULA EXISTS');
651: --
652: l_inputs(1).name := 'ASSIGNMENT_ID';
653: l_inputs(1).value := p_assignment_id;
654: l_inputs(2).name := 'DATE_EARNED';

Line 674: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

670: p_inputs => l_inputs,
671: p_outputs => l_outputs);
672: --
673: l_part_time_perc := l_outputs(1).value;
674: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
675: ELSE
676: -- hr_utility.trace('FORMULA DOESNT EXISTS');
677: l_part_time_perc := NULL;
678: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

Line 676: -- hr_utility.trace('FORMULA DOESNT EXISTS');

672: --
673: l_part_time_perc := l_outputs(1).value;
674: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
675: ELSE
676: -- hr_utility.trace('FORMULA DOESNT EXISTS');
677: l_part_time_perc := NULL;
678: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
679: END IF;
680: ELSIF g_std_ptp_formula_exists = FALSE THEN

Line 678: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

674: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
675: ELSE
676: -- hr_utility.trace('FORMULA DOESNT EXISTS');
677: l_part_time_perc := NULL;
678: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
679: END IF;
680: ELSIF g_std_ptp_formula_exists = FALSE THEN
681: l_part_time_perc := NULL;
682: END IF;

Line 724: -- hr_utility.trace('FORMULA EXISTS');

720: g_pse_ptp_formula_id:=l_formula_id;
721: END IF;
722: --
723: IF g_pse_ptp_formula_exists = TRUE THEN
724: -- hr_utility.trace('FORMULA EXISTS');
725: --
726: l_inputs(1).name := 'ASSIGNMENT_ID';
727: l_inputs(1).value := p_assignment_id;
728: l_inputs(2).name := 'DATE_EARNED';

Line 748: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

744: p_inputs => l_inputs,
745: p_outputs => l_outputs);
746: --
747: l_part_time_perc := l_outputs(1).value;
748: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
749: ELSE
750: -- hr_utility.trace('FORMULA DOESNT EXISTS');
751: l_part_time_perc := NULL;
752: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

Line 750: -- hr_utility.trace('FORMULA DOESNT EXISTS');

746: --
747: l_part_time_perc := l_outputs(1).value;
748: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
749: ELSE
750: -- hr_utility.trace('FORMULA DOESNT EXISTS');
751: l_part_time_perc := NULL;
752: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
753: END IF;
754: ELSIF g_pse_ptp_formula_exists = FALSE THEN

Line 752: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

748: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
749: ELSE
750: -- hr_utility.trace('FORMULA DOESNT EXISTS');
751: l_part_time_perc := NULL;
752: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
753: END IF;
754: ELSIF g_pse_ptp_formula_exists = FALSE THEN
755: l_part_time_perc := NULL;
756: END IF;

Line 797: -- hr_utility.trace('FORMULA EXISTS');

793: g_std_rep_ptp_formula_id:=l_formula_id;
794: END IF;
795: --
796: IF g_std_rep_ptp_formula_exists = TRUE THEN
797: -- hr_utility.trace('FORMULA EXISTS');
798: --
799: l_inputs(1).name := 'ASSIGNMENT_ID';
800: l_inputs(1).value := p_assignment_id;
801: l_inputs(2).name := 'DATE_EARNED';

Line 821: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

817: p_inputs => l_inputs,
818: p_outputs => l_outputs);
819: --
820: l_part_time_perc := l_outputs(1).value;
821: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
822: ELSE
823: -- hr_utility.trace('FORMULA DOESNT EXISTS');
824: l_part_time_perc := NULL;
825: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

Line 823: -- hr_utility.trace('FORMULA DOESNT EXISTS');

819: --
820: l_part_time_perc := l_outputs(1).value;
821: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
822: ELSE
823: -- hr_utility.trace('FORMULA DOESNT EXISTS');
824: l_part_time_perc := NULL;
825: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
826: END IF;
827: ELSIF g_std_rep_ptp_formula_exists = FALSE THEN

Line 825: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

821: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
822: ELSE
823: -- hr_utility.trace('FORMULA DOESNT EXISTS');
824: l_part_time_perc := NULL;
825: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
826: END IF;
827: ELSIF g_std_rep_ptp_formula_exists = FALSE THEN
828: l_part_time_perc := NULL;
829: END IF;

Line 870: -- hr_utility.trace('FORMULA EXISTS');

866: g_pse_rep_ptp_formula_id:=l_formula_id;
867: END IF;
868: --
869: IF g_pse_rep_ptp_formula_exists = TRUE THEN
870: -- hr_utility.trace('FORMULA EXISTS');
871: --
872: l_inputs(1).name := 'ASSIGNMENT_ID';
873: l_inputs(1).value := p_assignment_id;
874: l_inputs(2).name := 'DATE_EARNED';

Line 894: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

890: p_inputs => l_inputs,
891: p_outputs => l_outputs);
892: --
893: l_part_time_perc := l_outputs(1).value;
894: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
895: ELSE
896: -- hr_utility.trace('FORMULA DOESNT EXISTS');
897: l_part_time_perc := NULL;
898: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

Line 896: -- hr_utility.trace('FORMULA DOESNT EXISTS');

892: --
893: l_part_time_perc := l_outputs(1).value;
894: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
895: ELSE
896: -- hr_utility.trace('FORMULA DOESNT EXISTS');
897: l_part_time_perc := NULL;
898: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
899: END IF;
900: ELSIF g_pse_rep_ptp_formula_exists = FALSE THEN

Line 898: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

894: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
895: ELSE
896: -- hr_utility.trace('FORMULA DOESNT EXISTS');
897: l_part_time_perc := NULL;
898: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
899: END IF;
900: ELSIF g_pse_rep_ptp_formula_exists = FALSE THEN
901: l_part_time_perc := NULL;
902: END IF;