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 97: hr_utility.set_location('Entering ' || l_proc, 100);

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

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

94: l_date_earned VARCHAR2(8);
95: l_proc varchar2(100) := g_package||'get_si_status';
96: BEGIN
97: hr_utility.set_location('Entering ' || l_proc, 100);
98: hr_utility.set_location('p_assignment_id ' || p_assignment_id, 110);
99: hr_utility.set_location('p_si_class ' || p_si_class, 110);
100: hr_utility.set_location('p_date_earned ' || p_date_earned, 110);
101: l_zvw_status := 1;
102: OPEN Cur_SI_Status;

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

95: l_proc varchar2(100) := g_package||'get_si_status';
96: BEGIN
97: hr_utility.set_location('Entering ' || l_proc, 100);
98: hr_utility.set_location('p_assignment_id ' || p_assignment_id, 110);
99: hr_utility.set_location('p_si_class ' || p_si_class, 110);
100: hr_utility.set_location('p_date_earned ' || p_date_earned, 110);
101: l_zvw_status := 1;
102: OPEN Cur_SI_Status;
103: FETCH Cur_SI_Status INTO vCur_SI_Status;

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

96: BEGIN
97: hr_utility.set_location('Entering ' || l_proc, 100);
98: hr_utility.set_location('p_assignment_id ' || p_assignment_id, 110);
99: hr_utility.set_location('p_si_class ' || p_si_class, 110);
100: hr_utility.set_location('p_date_earned ' || p_date_earned, 110);
101: l_zvw_status := 1;
102: OPEN Cur_SI_Status;
103: FETCH Cur_SI_Status INTO vCur_SI_Status;
104: IF Cur_SI_Status%NOTFOUND THEN

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

152: vCur_SI_Status.SI_Status := 0;
153: END IF;
154: END IF;*/
155:
156: hr_utility.set_location('Leaving' || l_proc, 500);
157: RETURN vCur_SI_Status.SI_Status;
158: EXCEPTION
159: WHEN OTHERS THEN
160: hr_utility.set_location(' Others :' || SQLERRM(SQLCODE),900);

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

156: hr_utility.set_location('Leaving' || l_proc, 500);
157: RETURN vCur_SI_Status.SI_Status;
158: EXCEPTION
159: WHEN OTHERS THEN
160: hr_utility.set_location(' Others :' || SQLERRM(SQLCODE),900);
161: END get_si_status;
162: --
163: -- Function to check if All Mandatory Insurances is chosen at the assignment level
164: --

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

180: order by si_class_order desc;
181: vCur_SI_AMI Cur_SI_AMI%ROWTYPE;
182: l_proc varchar2(100) := g_package||'get_si_status';
183: BEGIN
184: hr_utility.set_location('Entering ' || l_proc, 100);
185: hr_utility.set_location('p_assignment_id ' || p_assignment_id, 110);
186: hr_utility.set_location('p_date_earned ' || p_date_earned, 110);
187: OPEN Cur_SI_AMI;
188: FETCH Cur_SI_AMI INTO vCur_SI_AMI;

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

181: vCur_SI_AMI Cur_SI_AMI%ROWTYPE;
182: l_proc varchar2(100) := g_package||'get_si_status';
183: BEGIN
184: hr_utility.set_location('Entering ' || l_proc, 100);
185: hr_utility.set_location('p_assignment_id ' || p_assignment_id, 110);
186: hr_utility.set_location('p_date_earned ' || p_date_earned, 110);
187: OPEN Cur_SI_AMI;
188: FETCH Cur_SI_AMI INTO vCur_SI_AMI;
189: CLOSE Cur_SI_AMI;

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

182: l_proc varchar2(100) := g_package||'get_si_status';
183: BEGIN
184: hr_utility.set_location('Entering ' || l_proc, 100);
185: hr_utility.set_location('p_assignment_id ' || p_assignment_id, 110);
186: hr_utility.set_location('p_date_earned ' || p_date_earned, 110);
187: OPEN Cur_SI_AMI;
188: FETCH Cur_SI_AMI INTO vCur_SI_AMI;
189: CLOSE Cur_SI_AMI;
190: RETURN vCur_SI_AMI.si_class_order;

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

189: CLOSE Cur_SI_AMI;
190: RETURN vCur_SI_AMI.si_class_order;
191: EXCEPTION
192: WHEN OTHERS THEN
193: hr_utility.set_location(' Others :' || SQLERRM(SQLCODE),900);
194: END is_ami;
195: --
196: -- Function to get payroll type
197: --

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

382: and ses.session_id = userenv('sessionid')
383: and ses.effective_date between paa.effective_start_date and paa.effective_end_date;
384: for l_absence_record in Get_Non_SI_Absence(l_person_id)
385: loop
386: --hr_utility.set_location(' date_start'||l_absence_record.date_start,100);
387: --hr_utility.set_location(' date_end'||l_absence_record.date_end,100);
388: /*Check whether the start date and end date of the abscence period are equal*/
389: if l_absence_record.date_start = l_absence_record.date_end then
390: l_hrs_wrked:=pqp_schedule_calculation_pkg.get_hours_worked

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

383: and ses.effective_date between paa.effective_start_date and paa.effective_end_date;
384: for l_absence_record in Get_Non_SI_Absence(l_person_id)
385: loop
386: --hr_utility.set_location(' date_start'||l_absence_record.date_start,100);
387: --hr_utility.set_location(' date_end'||l_absence_record.date_end,100);
388: /*Check whether the start date and end date of the abscence period are equal*/
389: if l_absence_record.date_start = l_absence_record.date_end then
390: l_hrs_wrked:=pqp_schedule_calculation_pkg.get_hours_worked
391: (p_assignment_id => l_assgn_attr.assignment_id

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

395: ,p_error_code => l_error_code
396: ,p_error_message => l_error_msg
397: ,p_default_wp => NULL
398: );
399: --hr_utility.set_location('l_absence_record.time_end'||l_absence_record.time_end,110);
400: --hr_utility.set_location('l_absence_record.time_start'||l_absence_record.time_start,110);
401: --Bug 3085937
402: --shveerab
403: /*Added code to check time_end and time_start is null for the abscence defined*/

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

396: ,p_error_message => l_error_msg
397: ,p_default_wp => NULL
398: );
399: --hr_utility.set_location('l_absence_record.time_end'||l_absence_record.time_end,110);
400: --hr_utility.set_location('l_absence_record.time_start'||l_absence_record.time_start,110);
401: --Bug 3085937
402: --shveerab
403: /*Added code to check time_end and time_start is null for the abscence defined*/
404: if (l_absence_record.time_end is null and

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

410: /*Else the actual time difference between time_end and time_stard of the absence
411: should be assigned*/
412: 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;
413: end if;
414: --hr_utility.set_location('l_absence_hours'||l_absence_hours,120);
415: l_wrking_day:= pqp_schedule_calculation_pkg.is_working_day
416: (p_assignment_id => l_assgn_attr.assignment_id
417: ,p_business_group_id => l_assgn_attr.business_group_id
418: ,p_date => l_absence_record.date_start

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

425: working day then non si absence days should be incremented by one*/
426: if l_absence_hours >= l_hrs_wrked and l_wrking_day='Y' then
427: l_non_si_days := l_non_si_days + 1;
428: end if;
429: --hr_utility.set_location('l_non_si_days'||l_non_si_days,150);
430: else
431: if l_absence_record.date_start > p_start_date then
432: l_temp1:= l_absence_record.date_start;
433: else

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

555: g_ptp_formula_id:=l_formula_id;
556: END IF;
557: --
558: IF g_ptp_formula_exists = TRUE THEN
559: -- hr_utility.trace('FORMULA EXISTS');
560: --
561: l_inputs(1).name := 'ASSIGNMENT_ID';
562: l_inputs(1).value := p_assignment_id;
563: l_inputs(2).name := 'DATE_EARNED';

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

579: p_inputs => l_inputs,
580: p_outputs => l_outputs);
581: --
582: l_part_time_perc := l_outputs(1).value;
583: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
584: ELSE
585: -- hr_utility.trace('FORMULA DOESNT EXISTS');
586: l_part_time_perc := NULL;
587: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

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

581: --
582: l_part_time_perc := l_outputs(1).value;
583: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
584: ELSE
585: -- hr_utility.trace('FORMULA DOESNT EXISTS');
586: l_part_time_perc := NULL;
587: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
588: END IF;
589: ELSIF g_ptp_formula_exists = FALSE THEN

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

583: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
584: ELSE
585: -- hr_utility.trace('FORMULA DOESNT EXISTS');
586: l_part_time_perc := NULL;
587: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
588: END IF;
589: ELSIF g_ptp_formula_exists = FALSE THEN
590: l_part_time_perc := NULL;
591: END IF;

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

629: g_std_ptp_formula_id:=l_formula_id;
630: END IF;
631: --
632: IF g_std_ptp_formula_exists = TRUE THEN
633: -- hr_utility.trace('FORMULA EXISTS');
634: --
635: l_inputs(1).name := 'ASSIGNMENT_ID';
636: l_inputs(1).value := p_assignment_id;
637: l_inputs(2).name := 'DATE_EARNED';

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

653: p_inputs => l_inputs,
654: p_outputs => l_outputs);
655: --
656: l_part_time_perc := l_outputs(1).value;
657: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
658: ELSE
659: -- hr_utility.trace('FORMULA DOESNT EXISTS');
660: l_part_time_perc := NULL;
661: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

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

655: --
656: l_part_time_perc := l_outputs(1).value;
657: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
658: ELSE
659: -- hr_utility.trace('FORMULA DOESNT EXISTS');
660: l_part_time_perc := NULL;
661: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
662: END IF;
663: ELSIF g_std_ptp_formula_exists = FALSE THEN

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

657: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
658: ELSE
659: -- hr_utility.trace('FORMULA DOESNT EXISTS');
660: l_part_time_perc := NULL;
661: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
662: END IF;
663: ELSIF g_std_ptp_formula_exists = FALSE THEN
664: l_part_time_perc := NULL;
665: END IF;

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

703: g_pse_ptp_formula_id:=l_formula_id;
704: END IF;
705: --
706: IF g_pse_ptp_formula_exists = TRUE THEN
707: -- hr_utility.trace('FORMULA EXISTS');
708: --
709: l_inputs(1).name := 'ASSIGNMENT_ID';
710: l_inputs(1).value := p_assignment_id;
711: l_inputs(2).name := 'DATE_EARNED';

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

727: p_inputs => l_inputs,
728: p_outputs => l_outputs);
729: --
730: l_part_time_perc := l_outputs(1).value;
731: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
732: ELSE
733: -- hr_utility.trace('FORMULA DOESNT EXISTS');
734: l_part_time_perc := NULL;
735: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

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

729: --
730: l_part_time_perc := l_outputs(1).value;
731: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
732: ELSE
733: -- hr_utility.trace('FORMULA DOESNT EXISTS');
734: l_part_time_perc := NULL;
735: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
736: END IF;
737: ELSIF g_pse_ptp_formula_exists = FALSE THEN

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

731: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
732: ELSE
733: -- hr_utility.trace('FORMULA DOESNT EXISTS');
734: l_part_time_perc := NULL;
735: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
736: END IF;
737: ELSIF g_pse_ptp_formula_exists = FALSE THEN
738: l_part_time_perc := NULL;
739: END IF;

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

776: g_std_rep_ptp_formula_id:=l_formula_id;
777: END IF;
778: --
779: IF g_std_rep_ptp_formula_exists = TRUE THEN
780: -- hr_utility.trace('FORMULA EXISTS');
781: --
782: l_inputs(1).name := 'ASSIGNMENT_ID';
783: l_inputs(1).value := p_assignment_id;
784: l_inputs(2).name := 'DATE_EARNED';

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

800: p_inputs => l_inputs,
801: p_outputs => l_outputs);
802: --
803: l_part_time_perc := l_outputs(1).value;
804: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
805: ELSE
806: -- hr_utility.trace('FORMULA DOESNT EXISTS');
807: l_part_time_perc := NULL;
808: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

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

802: --
803: l_part_time_perc := l_outputs(1).value;
804: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
805: ELSE
806: -- hr_utility.trace('FORMULA DOESNT EXISTS');
807: l_part_time_perc := NULL;
808: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
809: END IF;
810: ELSIF g_std_rep_ptp_formula_exists = FALSE THEN

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

804: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
805: ELSE
806: -- hr_utility.trace('FORMULA DOESNT EXISTS');
807: l_part_time_perc := NULL;
808: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
809: END IF;
810: ELSIF g_std_rep_ptp_formula_exists = FALSE THEN
811: l_part_time_perc := NULL;
812: END IF;

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

849: g_pse_rep_ptp_formula_id:=l_formula_id;
850: END IF;
851: --
852: IF g_pse_rep_ptp_formula_exists = TRUE THEN
853: -- hr_utility.trace('FORMULA EXISTS');
854: --
855: l_inputs(1).name := 'ASSIGNMENT_ID';
856: l_inputs(1).value := p_assignment_id;
857: l_inputs(2).name := 'DATE_EARNED';

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

873: p_inputs => l_inputs,
874: p_outputs => l_outputs);
875: --
876: l_part_time_perc := l_outputs(1).value;
877: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
878: ELSE
879: -- hr_utility.trace('FORMULA DOESNT EXISTS');
880: l_part_time_perc := NULL;
881: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);

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

875: --
876: l_part_time_perc := l_outputs(1).value;
877: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
878: ELSE
879: -- hr_utility.trace('FORMULA DOESNT EXISTS');
880: l_part_time_perc := NULL;
881: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
882: END IF;
883: ELSIF g_pse_rep_ptp_formula_exists = FALSE THEN

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

877: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
878: ELSE
879: -- hr_utility.trace('FORMULA DOESNT EXISTS');
880: l_part_time_perc := NULL;
881: -- hr_utility.trace('l_part_time_perc'||l_part_time_perc);
882: END IF;
883: ELSIF g_pse_rep_ptp_formula_exists = FALSE THEN
884: l_part_time_perc := NULL;
885: END IF;