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_FR_OVERTIME dependencies on HR_UTILITY

Line 99: hr_utility.set_location(l_proc,10);

95: and ee.effective_end_date >= start_of_year
96: order by greatest(start_of_year,p.effective_start_date,ee.effective_start_date);
97: --
98: begin
99: hr_utility.set_location(l_proc,10);
100: /* Initialise parameters */
101: start_of_year :=
102: to_date(to_char(p_effective_date,'YYYY')||'0101','YYYYMMDD');
103: end_of_year := to_date(to_char(p_effective_date,'YYYY')||'1231','YYYYMMDD');

Line 148: hr_utility.set_location(l_proc,20);

144: if end_date = end_of_year then
145: exit;
146: end if;
147: end loop;
148: hr_utility.set_location(l_proc,20);
149: return total_threshold;
150: end;
151: --
152: ------------------------------------------------------------------------

Line 230: hr_utility.set_location(l_proc,10);

226: --
227: i number;
228: l_proc varchar2(72) := g_package||'.set_scheme';
229: begin
230: hr_utility.set_location(l_proc,10);
231: scheme := null_scheme;
232: band := null_band;
233: --
234: open get_scheme;

Line 309: hr_utility.set_location(l_proc,20);

305: i := i + 1;
306: band(i) := b;
307: end loop;
308: --
309: hr_utility.set_location(l_proc,20);
310: return 0;
311: end;
312: --
313: ------------------------------------------------------------------------

Line 322: hr_utility.set_location(l_proc,10);

318: ------------------------------------------------------------------------
319: function get_scheme(p_scheme_item varchar2) return varchar2 is
320: l_proc varchar2(72) := g_package||'.get_scheme';
321: begin
322: hr_utility.set_location(l_proc,10);
323: if p_scheme_item = 'OVERTIME_PAYROLL_ID' then
324: return scheme.OVERTIME_PAYROLL_ID;
325: elsif p_scheme_item = 'OVERTIME_SCHEME_TYPE' then
326: return scheme.OVERTIME_SCHEME_TYPE;

Line 382: hr_utility.set_location(l_proc,10);

378: ,p_hours_percentage out nocopy number
379: ,p_factor out nocopy number) return number is
380: l_proc varchar2(72) := g_package||'.get_band';
381: begin
382: hr_utility.set_location(l_proc,10);
383: p_label := band(p_band).Label;
384: p_hours := band(p_band).Hours;
385: p_hours_percentage := band(p_band).Hours_Percentage;
386: p_factor := band(p_band).Factor;

Line 387: hr_utility.trace('Fetching Band '||to_char(p_band));

383: p_label := band(p_band).Label;
384: p_hours := band(p_band).Hours;
385: p_hours_percentage := band(p_band).Hours_Percentage;
386: p_factor := band(p_band).Factor;
387: hr_utility.trace('Fetching Band '||to_char(p_band));
388: hr_utility.trace('Hours_Percentage '||p_hours_percentage);
389: return 0;
390: exception when others then
391: return 1;

Line 388: hr_utility.trace('Hours_Percentage '||p_hours_percentage);

384: p_hours := band(p_band).Hours;
385: p_hours_percentage := band(p_band).Hours_Percentage;
386: p_factor := band(p_band).Factor;
387: hr_utility.trace('Fetching Band '||to_char(p_band));
388: hr_utility.trace('Hours_Percentage '||p_hours_percentage);
389: return 0;
390: exception when others then
391: return 1;
392: end;

Line 448: hr_utility.set_location(l_proc,10);

444: l_accrual_rf number := 0;
445: --
446: l_proc varchar2(72) := g_package||'.calculate_band';
447: begin
448: hr_utility.set_location(l_proc,10);
449: --
450: /* The number of hours is
451: 1. 0 if the weekly hours are below the bands low value
452:

Line 517: hr_utility.trace('-------------------------------------');

513: l_accrual_ff := l_hours_ff * l_hourly_rate_ff;
514: end if;
515: end if;
516: --
517: hr_utility.trace('-------------------------------------');
518: hr_utility.trace('Low Value = '||to_char(p_low_value));
519: hr_utility.trace('High Value = '||to_char(l_high_value));
520: hr_utility.trace('-------------------------------------');
521: hr_utility.trace('Full Factor = '||to_char(l_full_factor));

Line 518: hr_utility.trace('Low Value = '||to_char(p_low_value));

514: end if;
515: end if;
516: --
517: hr_utility.trace('-------------------------------------');
518: hr_utility.trace('Low Value = '||to_char(p_low_value));
519: hr_utility.trace('High Value = '||to_char(l_high_value));
520: hr_utility.trace('-------------------------------------');
521: hr_utility.trace('Full Factor = '||to_char(l_full_factor));
522: hr_utility.trace('Full Pay Rate = '||to_char(l_hourly_rate_ff));

Line 519: hr_utility.trace('High Value = '||to_char(l_high_value));

515: end if;
516: --
517: hr_utility.trace('-------------------------------------');
518: hr_utility.trace('Low Value = '||to_char(p_low_value));
519: hr_utility.trace('High Value = '||to_char(l_high_value));
520: hr_utility.trace('-------------------------------------');
521: hr_utility.trace('Full Factor = '||to_char(l_full_factor));
522: hr_utility.trace('Full Pay Rate = '||to_char(l_hourly_rate_ff));
523: hr_utility.trace('Full Hours = '||to_char(l_hours_ff));

Line 520: hr_utility.trace('-------------------------------------');

516: --
517: hr_utility.trace('-------------------------------------');
518: hr_utility.trace('Low Value = '||to_char(p_low_value));
519: hr_utility.trace('High Value = '||to_char(l_high_value));
520: hr_utility.trace('-------------------------------------');
521: hr_utility.trace('Full Factor = '||to_char(l_full_factor));
522: hr_utility.trace('Full Pay Rate = '||to_char(l_hourly_rate_ff));
523: hr_utility.trace('Full Hours = '||to_char(l_hours_ff));
524: hr_utility.trace('Full Pay = '||to_char(l_pay_ff));

Line 521: hr_utility.trace('Full Factor = '||to_char(l_full_factor));

517: hr_utility.trace('-------------------------------------');
518: hr_utility.trace('Low Value = '||to_char(p_low_value));
519: hr_utility.trace('High Value = '||to_char(l_high_value));
520: hr_utility.trace('-------------------------------------');
521: hr_utility.trace('Full Factor = '||to_char(l_full_factor));
522: hr_utility.trace('Full Pay Rate = '||to_char(l_hourly_rate_ff));
523: hr_utility.trace('Full Hours = '||to_char(l_hours_ff));
524: hr_utility.trace('Full Pay = '||to_char(l_pay_ff));
525: hr_utility.trace('Full Accrual = '||to_char(l_accrual_ff));

Line 522: hr_utility.trace('Full Pay Rate = '||to_char(l_hourly_rate_ff));

518: hr_utility.trace('Low Value = '||to_char(p_low_value));
519: hr_utility.trace('High Value = '||to_char(l_high_value));
520: hr_utility.trace('-------------------------------------');
521: hr_utility.trace('Full Factor = '||to_char(l_full_factor));
522: hr_utility.trace('Full Pay Rate = '||to_char(l_hourly_rate_ff));
523: hr_utility.trace('Full Hours = '||to_char(l_hours_ff));
524: hr_utility.trace('Full Pay = '||to_char(l_pay_ff));
525: hr_utility.trace('Full Accrual = '||to_char(l_accrual_ff));
526: hr_utility.trace('-------------------------------------');

Line 523: hr_utility.trace('Full Hours = '||to_char(l_hours_ff));

519: hr_utility.trace('High Value = '||to_char(l_high_value));
520: hr_utility.trace('-------------------------------------');
521: hr_utility.trace('Full Factor = '||to_char(l_full_factor));
522: hr_utility.trace('Full Pay Rate = '||to_char(l_hourly_rate_ff));
523: hr_utility.trace('Full Hours = '||to_char(l_hours_ff));
524: hr_utility.trace('Full Pay = '||to_char(l_pay_ff));
525: hr_utility.trace('Full Accrual = '||to_char(l_accrual_ff));
526: hr_utility.trace('-------------------------------------');
527: hr_utility.trace('Reduced Factor = '||to_char(l_reduced_factor));

Line 524: hr_utility.trace('Full Pay = '||to_char(l_pay_ff));

520: hr_utility.trace('-------------------------------------');
521: hr_utility.trace('Full Factor = '||to_char(l_full_factor));
522: hr_utility.trace('Full Pay Rate = '||to_char(l_hourly_rate_ff));
523: hr_utility.trace('Full Hours = '||to_char(l_hours_ff));
524: hr_utility.trace('Full Pay = '||to_char(l_pay_ff));
525: hr_utility.trace('Full Accrual = '||to_char(l_accrual_ff));
526: hr_utility.trace('-------------------------------------');
527: hr_utility.trace('Reduced Factor = '||to_char(l_reduced_factor));
528: hr_utility.trace('Reduced Pay Rate = '||to_char(l_hourly_rate_rf));

Line 525: hr_utility.trace('Full Accrual = '||to_char(l_accrual_ff));

521: hr_utility.trace('Full Factor = '||to_char(l_full_factor));
522: hr_utility.trace('Full Pay Rate = '||to_char(l_hourly_rate_ff));
523: hr_utility.trace('Full Hours = '||to_char(l_hours_ff));
524: hr_utility.trace('Full Pay = '||to_char(l_pay_ff));
525: hr_utility.trace('Full Accrual = '||to_char(l_accrual_ff));
526: hr_utility.trace('-------------------------------------');
527: hr_utility.trace('Reduced Factor = '||to_char(l_reduced_factor));
528: hr_utility.trace('Reduced Pay Rate = '||to_char(l_hourly_rate_rf));
529: hr_utility.trace('Reduced Hours = '||to_char(l_hours_rf));

Line 526: hr_utility.trace('-------------------------------------');

522: hr_utility.trace('Full Pay Rate = '||to_char(l_hourly_rate_ff));
523: hr_utility.trace('Full Hours = '||to_char(l_hours_ff));
524: hr_utility.trace('Full Pay = '||to_char(l_pay_ff));
525: hr_utility.trace('Full Accrual = '||to_char(l_accrual_ff));
526: hr_utility.trace('-------------------------------------');
527: hr_utility.trace('Reduced Factor = '||to_char(l_reduced_factor));
528: hr_utility.trace('Reduced Pay Rate = '||to_char(l_hourly_rate_rf));
529: hr_utility.trace('Reduced Hours = '||to_char(l_hours_rf));
530: hr_utility.trace('Reduced Pay = '||to_char(l_pay_rf));

Line 527: hr_utility.trace('Reduced Factor = '||to_char(l_reduced_factor));

523: hr_utility.trace('Full Hours = '||to_char(l_hours_ff));
524: hr_utility.trace('Full Pay = '||to_char(l_pay_ff));
525: hr_utility.trace('Full Accrual = '||to_char(l_accrual_ff));
526: hr_utility.trace('-------------------------------------');
527: hr_utility.trace('Reduced Factor = '||to_char(l_reduced_factor));
528: hr_utility.trace('Reduced Pay Rate = '||to_char(l_hourly_rate_rf));
529: hr_utility.trace('Reduced Hours = '||to_char(l_hours_rf));
530: hr_utility.trace('Reduced Pay = '||to_char(l_pay_rf));
531: hr_utility.trace('Reduced Accrual = '||to_char(l_accrual_rf));

Line 528: hr_utility.trace('Reduced Pay Rate = '||to_char(l_hourly_rate_rf));

524: hr_utility.trace('Full Pay = '||to_char(l_pay_ff));
525: hr_utility.trace('Full Accrual = '||to_char(l_accrual_ff));
526: hr_utility.trace('-------------------------------------');
527: hr_utility.trace('Reduced Factor = '||to_char(l_reduced_factor));
528: hr_utility.trace('Reduced Pay Rate = '||to_char(l_hourly_rate_rf));
529: hr_utility.trace('Reduced Hours = '||to_char(l_hours_rf));
530: hr_utility.trace('Reduced Pay = '||to_char(l_pay_rf));
531: hr_utility.trace('Reduced Accrual = '||to_char(l_accrual_rf));
532: hr_utility.trace('-------------------------------------');

Line 529: hr_utility.trace('Reduced Hours = '||to_char(l_hours_rf));

525: hr_utility.trace('Full Accrual = '||to_char(l_accrual_ff));
526: hr_utility.trace('-------------------------------------');
527: hr_utility.trace('Reduced Factor = '||to_char(l_reduced_factor));
528: hr_utility.trace('Reduced Pay Rate = '||to_char(l_hourly_rate_rf));
529: hr_utility.trace('Reduced Hours = '||to_char(l_hours_rf));
530: hr_utility.trace('Reduced Pay = '||to_char(l_pay_rf));
531: hr_utility.trace('Reduced Accrual = '||to_char(l_accrual_rf));
532: hr_utility.trace('-------------------------------------');
533: --

Line 530: hr_utility.trace('Reduced Pay = '||to_char(l_pay_rf));

526: hr_utility.trace('-------------------------------------');
527: hr_utility.trace('Reduced Factor = '||to_char(l_reduced_factor));
528: hr_utility.trace('Reduced Pay Rate = '||to_char(l_hourly_rate_rf));
529: hr_utility.trace('Reduced Hours = '||to_char(l_hours_rf));
530: hr_utility.trace('Reduced Pay = '||to_char(l_pay_rf));
531: hr_utility.trace('Reduced Accrual = '||to_char(l_accrual_rf));
532: hr_utility.trace('-------------------------------------');
533: --
534: p_high_value := l_high_value;

Line 531: hr_utility.trace('Reduced Accrual = '||to_char(l_accrual_rf));

527: hr_utility.trace('Reduced Factor = '||to_char(l_reduced_factor));
528: hr_utility.trace('Reduced Pay Rate = '||to_char(l_hourly_rate_rf));
529: hr_utility.trace('Reduced Hours = '||to_char(l_hours_rf));
530: hr_utility.trace('Reduced Pay = '||to_char(l_pay_rf));
531: hr_utility.trace('Reduced Accrual = '||to_char(l_accrual_rf));
532: hr_utility.trace('-------------------------------------');
533: --
534: p_high_value := l_high_value;
535: p_band_full_factor := l_full_factor;

Line 532: hr_utility.trace('-------------------------------------');

528: hr_utility.trace('Reduced Pay Rate = '||to_char(l_hourly_rate_rf));
529: hr_utility.trace('Reduced Hours = '||to_char(l_hours_rf));
530: hr_utility.trace('Reduced Pay = '||to_char(l_pay_rf));
531: hr_utility.trace('Reduced Accrual = '||to_char(l_accrual_rf));
532: hr_utility.trace('-------------------------------------');
533: --
534: p_high_value := l_high_value;
535: p_band_full_factor := l_full_factor;
536: p_band_full_pay_rate := l_hourly_rate_ff;

Line 546: hr_utility.set_location(l_proc,10);

542: p_band_reduced_hours := l_hours_rf;
543: p_band_reduced_pay := l_pay_rf;
544: p_band_reduced_accrual := l_accrual_rf;
545: --
546: hr_utility.set_location(l_proc,10);
547: return 0;
548: end calculate_band;
549: --
550: ------------------------------------------------------------------------

Line 618: hr_utility.set_location(l_proc,10);

614: l_retr_ele_id number;
615: --
616: l_proc varchar2(72) := g_package||'.last_regularisation';
617: begin
618: hr_utility.set_location(l_proc,10);
619: --
620: open get_elements('FR_REGULARISATION_WEEK','FR_REGULARISATION_WEEK_RETRO');
621: fetch get_elements into l_orig_ele_id,l_retr_ele_id;
622: close get_elements;

Line 683: hr_utility.set_location(l_proc,10);

679: end if;
680: end;
681: --
682: begin
683: hr_utility.set_location(l_proc,10);
684: --
685: /* If there is a regularisation after the initial one defined on the scheme
686: or element entry override - then treat it as the start of the repetitions
687: */

Line 726: hr_utility.trace('Regularisation Period = ' || to_char(l_period_start_date,'DD-MON-YYYY') ||' - '||to_char(l_period_end_date,'DD-MON-YYYY'));

722: else
723: close c_week_end_date;
724: end if;
725: --
726: hr_utility.trace('Regularisation Period = ' || to_char(l_period_start_date,'DD-MON-YYYY') ||' - '||to_char(l_period_end_date,'DD-MON-YYYY'));
727: --
728: if l_period_end_date = p_current_week_end_date then
729: l_number_of_weeks := (l_period_end_date - l_period_start_date+1)/7;
730: --

Line 731: hr_utility.trace('Regularisation Due --------------');

727: --
728: if l_period_end_date = p_current_week_end_date then
729: l_number_of_weeks := (l_period_end_date - l_period_start_date+1)/7;
730: --
731: hr_utility.trace('Regularisation Due --------------');
732: --
733: /* Set output variables */
734: p_period_start_date := l_period_start_date;
735: p_period_end_date := l_period_end_date;

Line 744: hr_utility.trace('Regularisation Not Found');

740: end if;
741: --
742: end loop;
743: --
744: hr_utility.trace('Regularisation Not Found');
745: return('N');
746: --
747: end determine_regularisation;
748: --

Line 793: hr_utility.set_location(l_proc,10);

789: l_entry_exists varchar2(1) := 'N';
790: --
791: l_proc varchar2(72) := g_package||'.overtime_entry_exists';
792: begin
793: hr_utility.set_location(l_proc,10);
794: open c_overtime_entry;
795: fetch c_overtime_entry into l_entry_exists;
796: close c_overtime_entry;
797: --

Line 826: hr_utility.set_location(l_proc,10);

822: l_process_week number;
823: l_proc varchar2(72) := g_package||'.get_overtime_weeks';
824: --
825: begin
826: hr_utility.set_location(l_proc,10);
827: open c_weeks;
828: fetch c_weeks into l_valid_week;
829: close c_weeks;
830: --

Line 869: hr_utility.set_location(l_proc,10);

865: l_process_week number := 0;
866: --
867: l_proc varchar2(72) := g_package||'.get_overtime_week_dates';
868: begin
869: hr_utility.set_location(l_proc,10);
870: for w in c_weeks loop
871: l_weeks := l_weeks + 1;
872: if l_weeks = p_week_number then
873: --

Line 917: hr_utility.set_location(l_proc,10);

913: l_process_week number := 0;
914: --
915: l_proc varchar2(72) := g_package||'.get_overtime_week_dates';
916: begin
917: hr_utility.set_location(l_proc,10);
918: for w in c_weeks loop
919: l_weeks := l_weeks + 1;
920: if l_weeks = p_week_number then
921: --

Line 969: hr_utility.set_location(l_proc,10);

965: between ff.effective_start_date and ff.effective_end_date
966: and ff.business_group_id = p_business_group_id;
967:
968: begin
969: hr_utility.set_location(l_proc,10);
970: --
971: open csr_get_formula;
972: fetch csr_get_formula into l_formula_id, l_start_date;
973: If csr_get_formula%found then

Line 974: hr_utility.set_location(l_proc,20);

970: --
971: open csr_get_formula;
972: fetch csr_get_formula into l_formula_id, l_start_date;
973: If csr_get_formula%found then
974: hr_utility.set_location(l_proc,20);
975: -- Initialise the formula
976: ff_exec.init_formula (l_formula_id,
977: l_start_date,
978: l_inputs,

Line 1002: hr_utility.set_location(' Prior to execute the formula',8);

998: end if;
999: end loop;
1000: end if;
1001: --
1002: hr_utility.set_location(' Prior to execute the formula',8);
1003: hr_utility.set_location(l_proc,30);
1004: ff_exec.run_formula (l_inputs
1005: ,l_outputs);
1006: --

Line 1003: hr_utility.set_location(l_proc,30);

999: end loop;
1000: end if;
1001: --
1002: hr_utility.set_location(' Prior to execute the formula',8);
1003: hr_utility.set_location(l_proc,30);
1004: ff_exec.run_formula (l_inputs
1005: ,l_outputs);
1006: --
1007: hr_utility.set_location(l_proc,40);

Line 1007: hr_utility.set_location(l_proc,40);

1003: hr_utility.set_location(l_proc,30);
1004: ff_exec.run_formula (l_inputs
1005: ,l_outputs);
1006: --
1007: hr_utility.set_location(l_proc,40);
1008: hr_utility.set_location(' End run formula',9);
1009: --
1010: for l_out_cnt in l_outputs.first..l_outputs.last loop
1011: if l_outputs(l_out_cnt).name = 'OVERTIME_HOURS' then

Line 1008: hr_utility.set_location(' End run formula',9);

1004: ff_exec.run_formula (l_inputs
1005: ,l_outputs);
1006: --
1007: hr_utility.set_location(l_proc,40);
1008: hr_utility.set_location(' End run formula',9);
1009: --
1010: for l_out_cnt in l_outputs.first..l_outputs.last loop
1011: if l_outputs(l_out_cnt).name = 'OVERTIME_HOURS' then
1012: p_overtime_hours := l_outputs(l_out_cnt).value;

Line 1130: hr_utility.set_location(l_proc,10);

1126: and p_effective_date
1127: between ff.effective_start_date and ff.effective_end_date;
1128:
1129: begin
1130: hr_utility.set_location(l_proc,10);
1131: --
1132: open csr_get_formula;
1133: fetch csr_get_formula into l_formula_id, l_start_date;
1134: If csr_get_formula%found then

Line 1135: hr_utility.set_location(l_proc,20);

1131: --
1132: open csr_get_formula;
1133: fetch csr_get_formula into l_formula_id, l_start_date;
1134: If csr_get_formula%found then
1135: hr_utility.set_location(l_proc,20);
1136: -- Initialise the formula
1137: ff_exec.init_formula (l_formula_id,
1138: l_start_date,
1139: l_inputs,

Line 1163: hr_utility.set_location(' Prior to execute the formula',8);

1159: end if;
1160: end loop;
1161: end if;
1162: --
1163: hr_utility.set_location(' Prior to execute the formula',8);
1164: hr_utility.set_location(l_proc,30);
1165: ff_exec.run_formula (l_inputs
1166: ,l_outputs);
1167: --

Line 1164: hr_utility.set_location(l_proc,30);

1160: end loop;
1161: end if;
1162: --
1163: hr_utility.set_location(' Prior to execute the formula',8);
1164: hr_utility.set_location(l_proc,30);
1165: ff_exec.run_formula (l_inputs
1166: ,l_outputs);
1167: --
1168: hr_utility.set_location(l_proc,40);

Line 1168: hr_utility.set_location(l_proc,40);

1164: hr_utility.set_location(l_proc,30);
1165: ff_exec.run_formula (l_inputs
1166: ,l_outputs);
1167: --
1168: hr_utility.set_location(l_proc,40);
1169: hr_utility.set_location(' End run formula',9);
1170: --
1171: for l_out_cnt in l_outputs.first..l_outputs.last loop
1172:

Line 1169: hr_utility.set_location(' End run formula',9);

1165: ff_exec.run_formula (l_inputs
1166: ,l_outputs);
1167: --
1168: hr_utility.set_location(l_proc,40);
1169: hr_utility.set_location(' End run formula',9);
1170: --
1171: for l_out_cnt in l_outputs.first..l_outputs.last loop
1172:
1173: if l_outputs(l_out_cnt).name = 'B1_PAY_FF'

Line 1320: hr_utility.set_location(' After Loop',1);

1316: then p_b6_label_rf := l_outputs(l_out_cnt).value;
1317: end if;
1318: end loop;
1319: --
1320: hr_utility.set_location(' After Loop',1);
1321: close csr_get_formula;
1322: else
1323: close csr_get_formula;
1324: end if;

Line 1325: hr_utility.set_location(' Leaving Regularisation',10);

1321: close csr_get_formula;
1322: else
1323: close csr_get_formula;
1324: end if;
1325: hr_utility.set_location(' Leaving Regularisation',10);
1326: return 0;
1327: --
1328: end regularisation;
1329: --

Line 1395: hr_utility.set_location(l_proc,10);

1391: l_retr_ele_id number;
1392: --
1393: l_proc varchar2(72) := g_package||'.check_existing_overtime_week';
1394: begin
1395: hr_utility.set_location(l_proc,10);
1396: --
1397: open get_elements('FR_OVERTIME_WEEK_PROCESS','FR_OVERTIME_WEEK_PROCESS_RETRO');
1398: fetch get_elements into l_orig_ele_id,l_retr_ele_id;
1399: close get_elements;

Line 1474: hr_utility.set_location(l_proc,10);

1470: l_balance number;
1471: --
1472: l_proc varchar2(72) := g_package||'.get_period_balance';
1473: begin
1474: hr_utility.set_location(l_proc,10);
1475: --
1476: open get_element;
1477: fetch get_element into l_ele;
1478: if get_element%FOUND then

Line 1519: hr_utility.trace('Business Group = '||to_char(p_business_group_id));

1515: l_frequency varchar2(30);
1516: l_hours number;
1517: --
1518: begin
1519: hr_utility.trace('Business Group = '||to_char(p_business_group_id));
1520: hr_utility.trace('Assignment ID = '||to_char(p_assignment_id));
1521: hr_utility.trace('Effective Date = '||to_char(p_effective_date,'YYYYMMDD'));
1522: open get_hours;
1523: fetch get_hours into l_normal_hours,l_frequency;

Line 1520: hr_utility.trace('Assignment ID = '||to_char(p_assignment_id));

1516: l_hours number;
1517: --
1518: begin
1519: hr_utility.trace('Business Group = '||to_char(p_business_group_id));
1520: hr_utility.trace('Assignment ID = '||to_char(p_assignment_id));
1521: hr_utility.trace('Effective Date = '||to_char(p_effective_date,'YYYYMMDD'));
1522: open get_hours;
1523: fetch get_hours into l_normal_hours,l_frequency;
1524: if get_hours%notfound then

Line 1521: hr_utility.trace('Effective Date = '||to_char(p_effective_date,'YYYYMMDD'));

1517: --
1518: begin
1519: hr_utility.trace('Business Group = '||to_char(p_business_group_id));
1520: hr_utility.trace('Assignment ID = '||to_char(p_assignment_id));
1521: hr_utility.trace('Effective Date = '||to_char(p_effective_date,'YYYYMMDD'));
1522: open get_hours;
1523: fetch get_hours into l_normal_hours,l_frequency;
1524: if get_hours%notfound then
1525: close get_hours;

Line 1531: hr_utility.trace('Found Assignment');

1527: fnd_message.raise_error;
1528: end if;
1529: close get_hours;
1530: --
1531: hr_utility.trace('Found Assignment');
1532: if l_normal_hours is null or l_frequency is null then
1533: fnd_message.set_name('PAY','PAY_74980_MISSING_HOURS');
1534: fnd_message.raise_error;
1535: end if;