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.SSP_ERN_BUS dependencies on HR_UTILITY

Line 37: hr_utility.set_location('Entering:'||l_proc, 1);

33: and p_effective_date between p.effective_start_date and
34: p.effective_end_date;
35: c1_rec c1%ROWTYPE;
36: Begin
37: hr_utility.set_location('Entering:'||l_proc, 1);
38: open c1;
39: fetch c1 into c1_rec;
40: if c1%NOTFOUND then
41: fnd_message.set_name ('SSP' , 'SSP_35049_INV_PERSON_EFF_DATE' );

Line 45: hr_utility.set_location('Leaving :'||l_proc, 100);

41: fnd_message.set_name ('SSP' , 'SSP_35049_INV_PERSON_EFF_DATE' );
42: fnd_message.raise_error;
43: end if;
44: close c1;
45: hr_utility.set_location('Leaving :'||l_proc, 100);
46: End check_person_id;
47: --
48: --
49: -- ------------------------------------------------------------------------

Line 72: hr_utility.set_location('Entering:'||l_proc, 1);

68:
69: c2_rec c2%ROWTYPE;
70:
71: BEGIN
72: hr_utility.set_location('Entering:'||l_proc, 1);
73:
74: open c2;
75: fetch c2 into c2_rec;
76: if c2%NOTFOUND then

Line 81: hr_utility.set_location('Leaving :'||l_proc, 100);

77: fnd_message.set_name ('SSP' , 'SSP_35050_INV_EFFECTIVE_DATE' );
78: fnd_message.raise_error;
79: end if;
80: close c2;
81: hr_utility.set_location('Leaving :'||l_proc, 100);
82: END check_effective_date;
83: --
84: --
85: -- ------------------------------------------------------------------------

Line 342: hr_utility.set_location('Entering:'||l_proc,1);

338: --
339: --
340: begin
341: --
342: hr_utility.set_location('Entering:'||l_proc,1);
343: --
344: open csr_get_payroll_id_end;
345: fetch csr_get_payroll_id_end into l_payroll_id;
346: close csr_get_payroll_id_end;

Line 363: hr_utility.trace (l_proc||' finding the end of relevant period using the assignment id and not using the payroll id');

359: fetch csr_end_period_m into l_end_of_relevant_period;
360: close csr_end_period_m;
361:
362: if l_end_of_relevant_period is null then
363: hr_utility.trace (l_proc||' finding the end of relevant period using the assignment id and not using the payroll id');
364: open csr_end_period_m2;
365: fetch csr_end_period_m2 into l_end_of_relevant_period;
366: close csr_end_period_m2;
367: end if;

Line 375: hr_utility.trace (l_proc||' finding the end of relevant period using the assignment id and not using the payroll id');

371: fetch csr_end_period_s into l_end_of_relevant_period;
372: close csr_end_period_s;
373:
374: if l_end_of_relevant_period is null then
375: hr_utility.trace (l_proc||' finding the end of relevant period using the assignment id and not using the payroll id');
376: open csr_end_period_s2;
377: fetch csr_end_period_s2 into l_end_of_relevant_period;
378: close csr_end_period_s2;
379: end if;

Line 427: hr_utility.trace (l_proc||' start of relevant period = '

423: fetch csr_start_period into l_start_of_relevant_period;
424: close csr_start_period;
425: end if;
426: --
427: hr_utility.trace (l_proc||' start of relevant period = '
428: ||to_char (l_start_of_relevant_period));
429: hr_utility.trace (l_proc||' end of relevant period = '
430: ||to_char (l_end_of_relevant_period));
431: --

Line 429: hr_utility.trace (l_proc||' end of relevant period = '

425: end if;
426: --
427: hr_utility.trace (l_proc||' start of relevant period = '
428: ||to_char (l_start_of_relevant_period));
429: hr_utility.trace (l_proc||' end of relevant period = '
430: ||to_char (l_end_of_relevant_period));
431: --
432: hr_utility.set_location('Leaving :'||l_proc,100);
433: --

Line 432: hr_utility.set_location('Leaving :'||l_proc,100);

428: ||to_char (l_start_of_relevant_period));
429: hr_utility.trace (l_proc||' end of relevant period = '
430: ||to_char (l_end_of_relevant_period));
431: --
432: hr_utility.set_location('Leaving :'||l_proc,100);
433: --
434: end derive_relevant_period;
435: --
436: procedure get_payroll_frequency is

Line 467: hr_utility.set_location('Entering:'||l_proc,1);

463: periods_per_fiscal_year number := 0;
464: --
465: begin
466: --
467: hr_utility.set_location('Entering:'||l_proc,1);
468: --
469: l_payroll_frequency := 'MONTHLY';
470: --
471: for each_payroll in csr_payroll_frequency loop

Line 477: hr_utility.trace ('l_payroll_frequency = '||l_payroll_frequency);

473: l_payroll_frequency := 'NOT MONTHLY';
474: end if;
475: end loop;
476: --
477: hr_utility.trace ('l_payroll_frequency = '||l_payroll_frequency);
478: --
479: hr_utility.set_location('Leaving :'||l_proc,100);
480: --
481: end get_payroll_frequency;

Line 479: hr_utility.set_location('Leaving :'||l_proc,100);

475: end loop;
476: --
477: hr_utility.trace ('l_payroll_frequency = '||l_payroll_frequency);
478: --
479: hr_utility.set_location('Leaving :'||l_proc,100);
480: --
481: end get_payroll_frequency;
482: --
483: procedure get_period_of_service is

Line 503: hr_utility.set_location('Entering:'||l_proc,1);

499: hr_general.end_of_time);
500: --
501: begin
502: --
503: hr_utility.set_location('Entering:'||l_proc,1);
504: --
505: -- Get the period of service current as of the effective date
506: --
507: open csr_period_of_service;

Line 511: hr_utility.trace (l_proc||' l_period_of_service_id = '

507: open csr_period_of_service;
508: fetch csr_period_of_service into l_period_of_service_id, l_hire_date;
509: close csr_period_of_service;
510: --
511: hr_utility.trace (l_proc||' l_period_of_service_id = '
512: ||to_char (l_period_of_service_id));
513: hr_utility.trace (l_proc||' l_hire_date = '
514: ||to_char (l_hire_date));
515: --

Line 513: hr_utility.trace (l_proc||' l_hire_date = '

509: close csr_period_of_service;
510: --
511: hr_utility.trace (l_proc||' l_period_of_service_id = '
512: ||to_char (l_period_of_service_id));
513: hr_utility.trace (l_proc||' l_hire_date = '
514: ||to_char (l_hire_date));
515: --
516: hr_utility.set_location('Leaving :'||l_proc,100);
517: --

Line 516: hr_utility.set_location('Leaving :'||l_proc,100);

512: ||to_char (l_period_of_service_id));
513: hr_utility.trace (l_proc||' l_hire_date = '
514: ||to_char (l_hire_date));
515: --
516: hr_utility.set_location('Leaving :'||l_proc,100);
517: --
518: end get_period_of_service;
519: --
520: procedure check_payroll_installed is

Line 534: hr_utility.set_location('Entering:'||l_proc,1);

530: payroll_not_found exception;
531: --
532: Begin
533: --
534: hr_utility.set_location('Entering:'||l_proc,1);
535: --
536: -- We need to determine if Payroll is installed.
537: if (fnd_installation.get(
538: --

Line 557: hr_utility.set_location('Leaving :'||l_proc,100);

553: else
554: raise payroll_not_found;
555: end If;
556: --
557: hr_utility.set_location('Leaving :'||l_proc,100);
558: --
559: exception
560: when payroll_not_found then
561: --

Line 589: hr_utility.set_location('Entering:'||l_proc,1);

585: l_person_is_director boolean := FALSE;
586: --
587: begin
588: --
589: hr_utility.set_location('Entering:'||l_proc,1);
590: --
591: open csr_director;
592: fetch csr_director into l_dummy;
593: l_person_is_director := csr_director%found;

Line 610: hr_utility.set_location('Leaving :'||l_proc,100);

606: raise cannot_derive_earnings;
607: --
608: end if;
609: --
610: hr_utility.set_location('Leaving :'||l_proc,100);
611: --
612: end stop_if_a_director;
613: --
614: function gross_NIable_pay

Line 628: hr_utility.set_location('Entering:'||l_proc,1);

624: l_gross_NIable_pay_acc number(18,8) := 0;
625: --
626: begin
627: --
628: hr_utility.set_location('Entering:'||l_proc,1);
629: --
630: for csr_Ne in csr_NIable_earnings ('NIable Pay')
631: loop
632: l_gross_NIable_pay_acc := csr_Ne.EARNINGS;

Line 636: hr_utility.trace('L_GROSS_NIABLE: '||l_gross_NIable_pay);

632: l_gross_NIable_pay_acc := csr_Ne.EARNINGS;
633: l_gross_NIable_pay := l_gross_NIable_pay_acc;
634: end loop;
635: --
636: hr_utility.trace('L_GROSS_NIABLE: '||l_gross_NIable_pay);
637: --
638: l_weekly_pay := l_gross_NIable_pay_acc * 6 / 52;
639: l_lel := SSP_SMP_SUPPORT_PKG.NI_Lower_Earnings_Limit(
640: L_END_OF_RELEVANT_PERIOD);

Line 641: hr_utility.trace('l_lel: '||l_lel);

637: --
638: l_weekly_pay := l_gross_NIable_pay_acc * 6 / 52;
639: l_lel := SSP_SMP_SUPPORT_PKG.NI_Lower_Earnings_Limit(
640: L_END_OF_RELEVANT_PERIOD);
641: hr_utility.trace('l_lel: '||l_lel);
642: --
643: if l_weekly_pay < l_lel
644: then
645: for csr_Ne in csr_NIable_earnings ('NIable Earnings 1B')

Line 650: hr_utility.trace('L_GROSS_NIABLE inc 1B: '||l_gross_NIable_pay);

646: loop
647: l_gross_NIable_pay_acc := l_gross_NIable_pay_acc+csr_Ne.EARNINGS;
648: l_gross_NIable_pay := l_gross_NIable_pay_acc;
649: --
650: hr_utility.trace('L_GROSS_NIABLE inc 1B: '||l_gross_NIable_pay);
651: end loop;
652: end if;
653: --
654: hr_utility.set_location('Leaving :'||l_proc,100);

Line 654: hr_utility.set_location('Leaving :'||l_proc,100);

650: hr_utility.trace('L_GROSS_NIABLE inc 1B: '||l_gross_NIable_pay);
651: end loop;
652: end if;
653: --
654: hr_utility.set_location('Leaving :'||l_proc,100);
655: --
656: return l_gross_NIable_pay;
657: --
658: end gross_NIable_pay;

Line 672: hr_utility.set_location('Entering:'||l_proc,1);

668: l_proc varchar2 (72) := g_package||'do_monthly_calculation';
669: --
670: begin
671: --
672: hr_utility.set_location('Entering:'||l_proc,1);
673: --
674: -- Take the gross payments from the last 2 months, multiply by 6 for
675: -- the annual figure and divide by 52 for the weekly average
676: --

Line 680: hr_utility.trace (l_proc||' gross_NIable_pay = '

676: --
677: l_assignment_average :=
678: l_assignment_average + ((gross_NIable_pay * 6) / 52);
679: --
680: hr_utility.trace (l_proc||' gross_NIable_pay = '
681: ||to_char (gross_NIable_pay));
682: --
683: hr_utility.set_location('Leaving :'||l_proc,100);
684: --

Line 683: hr_utility.set_location('Leaving :'||l_proc,100);

679: --
680: hr_utility.trace (l_proc||' gross_NIable_pay = '
681: ||to_char (gross_NIable_pay));
682: --
683: hr_utility.set_location('Leaving :'||l_proc,100);
684: --
685: end do_monthly_calculation;
686: --
687: procedure do_standard_calculation is

Line 767: hr_utility.set_location('Entering:'||l_proc,1);

763: expected_num_of_periods number := null;
764: --
765: begin
766: --
767: hr_utility.set_location('Entering:'||l_proc,1);
768: hr_utility.trace('days covered orig: '||l_days_covered);
769: --
770: -- Take the gross payments from the relevant period, divide by the
771: -- number of days the payments cover, and multiply by 7.

Line 768: hr_utility.trace('days covered orig: '||l_days_covered);

764: --
765: begin
766: --
767: hr_utility.set_location('Entering:'||l_proc,1);
768: hr_utility.trace('days covered orig: '||l_days_covered);
769: --
770: -- Take the gross payments from the relevant period, divide by the
771: -- number of days the payments cover, and multiply by 7.
772: --

Line 787: hr_utility.trace('NUMBER OF PAYMENTS: '||number_of_payments);

783: end if;
784:
785: total_number_payments := total_number_payments + number_of_payments;
786: user_ent_multi_reg_pays := TRUE;
787: hr_utility.trace('NUMBER OF PAYMENTS: '||number_of_payments);
788: end loop;
789:
790: hr_utility.trace('TOTAL NUM PAYMENTS: '||total_number_payments);
791: --

Line 790: hr_utility.trace('TOTAL NUM PAYMENTS: '||total_number_payments);

786: user_ent_multi_reg_pays := TRUE;
787: hr_utility.trace('NUMBER OF PAYMENTS: '||number_of_payments);
788: end loop;
789:
790: hr_utility.trace('TOTAL NUM PAYMENTS: '||total_number_payments);
791: --
792: if user_ent_multi_reg_pays then
793: --
794: payroll_freq := 0;

Line 803: hr_utility.trace('PAYROLL FREQ: '||payroll_freq);

799: close csr_number_of_days;
800: --
801: number_of_days := round(365/payroll_freq);
802: --
803: hr_utility.trace('PAYROLL FREQ: '||payroll_freq);
804: hr_utility.trace('NUMBER OF DAYS: '||number_of_days);
805: --
806: -- Next bit of code is for outputting the number of payments to the ssp entries
807: -- form. The value in form_variable is passed to the form via the function

Line 804: hr_utility.trace('NUMBER OF DAYS: '||number_of_days);

800: --
801: number_of_days := round(365/payroll_freq);
802: --
803: hr_utility.trace('PAYROLL FREQ: '||payroll_freq);
804: hr_utility.trace('NUMBER OF DAYS: '||number_of_days);
805: --
806: -- Next bit of code is for outputting the number of payments to the ssp entries
807: -- form. The value in form_variable is passed to the form via the function
808: -- number_of_periods. If the total_number_payments is 0 then then number of

Line 821: hr_utility.trace('expected num of periods '||expected_num_of_periods||

817: else
818: form_variable := expected_num_of_periods + total_number_payments;
819: end if;
820: --
821: hr_utility.trace('expected num of periods '||expected_num_of_periods||
822: ', form variable '||form_variable);
823: --
824: l_days_covered := l_days_covered +
825: (number_of_days * total_number_payments);

Line 827: hr_utility.trace('DAYS COVERED: '||l_days_covered);

823: --
824: l_days_covered := l_days_covered +
825: (number_of_days * total_number_payments);
826: end if;
827: hr_utility.trace('DAYS COVERED: '||l_days_covered);
828: --
829: if l_days_covered < 1 then
830: l_assignment_average := 0;
831: else

Line 839: hr_utility.trace('GROSS NIABLE PAY: '||gross_NIable_pay);

835: / l_days_covered)
836: * 7);
837: end if;
838: --
839: hr_utility.trace('GROSS NIABLE PAY: '||gross_NIable_pay);
840: hr_utility.trace ('l_days_covered = '||to_char (l_days_covered));
841: hr_utility.trace ('l_assignment_average = '
842: ||to_char (l_assignment_average));
843: --

Line 840: hr_utility.trace ('l_days_covered = '||to_char (l_days_covered));

836: * 7);
837: end if;
838: --
839: hr_utility.trace('GROSS NIABLE PAY: '||gross_NIable_pay);
840: hr_utility.trace ('l_days_covered = '||to_char (l_days_covered));
841: hr_utility.trace ('l_assignment_average = '
842: ||to_char (l_assignment_average));
843: --
844: hr_utility.set_location('Leaving :'||l_proc,100);

Line 841: hr_utility.trace ('l_assignment_average = '

837: end if;
838: --
839: hr_utility.trace('GROSS NIABLE PAY: '||gross_NIable_pay);
840: hr_utility.trace ('l_days_covered = '||to_char (l_days_covered));
841: hr_utility.trace ('l_assignment_average = '
842: ||to_char (l_assignment_average));
843: --
844: hr_utility.set_location('Leaving :'||l_proc,100);
845: --

Line 844: hr_utility.set_location('Leaving :'||l_proc,100);

840: hr_utility.trace ('l_days_covered = '||to_char (l_days_covered));
841: hr_utility.trace ('l_assignment_average = '
842: ||to_char (l_assignment_average));
843: --
844: hr_utility.set_location('Leaving :'||l_proc,100);
845: --
846: end do_standard_calculation;
847: --
848: begin

Line 850: hr_utility.set_location('Entering:'||l_proc, 1);

846: end do_standard_calculation;
847: --
848: begin
849: --
850: hr_utility.set_location('Entering:'||l_proc, 1);
851: hr_utility.trace('P_EFFECTIVE_DATE IS: '||p_effective_date);
852: --
853: check_payroll_installed;
854: stop_if_a_director;

Line 851: hr_utility.trace('P_EFFECTIVE_DATE IS: '||p_effective_date);

847: --
848: begin
849: --
850: hr_utility.set_location('Entering:'||l_proc, 1);
851: hr_utility.trace('P_EFFECTIVE_DATE IS: '||p_effective_date);
852: --
853: check_payroll_installed;
854: stop_if_a_director;
855: get_period_of_service;

Line 875: hr_utility.trace ('Employee is NEW');

871: if l_hire_date >= l_start_of_relevant_period
872: then
873: l_new_employee := TRUE;
874: --
875: hr_utility.trace ('Employee is NEW');
876: end if;
877: --
878: -- The calculation of average earnings is done differently depending upon the
879: -- payroll frequency. For new employees, we always treat them as if they were

Line 934: hr_utility.trace ('average earnings is '||to_char(l_person_average));

930: raise cannot_derive_earnings;
931: end if;
932: --
933: p_average_earnings_amount := nvl (round (l_person_average,2),0);
934: hr_utility.trace ('average earnings is '||to_char(l_person_average));
935: --
936: hr_utility.set_location('Leaving :'||l_proc, 100);
937: --
938: exception

Line 936: hr_utility.set_location('Leaving :'||l_proc, 100);

932: --
933: p_average_earnings_amount := nvl (round (l_person_average,2),0);
934: hr_utility.trace ('average earnings is '||to_char(l_person_average));
935: --
936: hr_utility.set_location('Leaving :'||l_proc, 100);
937: --
938: exception
939: when cannot_derive_earnings then
940: hr_utility.set_location ('Leaving :'||l_proc||', exception',999);

Line 940: hr_utility.set_location ('Leaving :'||l_proc||', exception',999);

936: hr_utility.set_location('Leaving :'||l_proc, 100);
937: --
938: exception
939: when cannot_derive_earnings then
940: hr_utility.set_location ('Leaving :'||l_proc||', exception',999);
941: --
942: p_average_earnings_amount := 0;
943: --
944: fnd_message.set_name ('SSP',ssp_smp_support_pkg.reason_for_no_earnings);

Line 967: hr_utility.set_location('Entering:'||l_proc, 1);

963: function number_of_periods return number is
964: --
965: l_proc varchar2(72) := g_package||'number_of_periods';
966: begin
967: hr_utility.set_location('Entering:'||l_proc, 1);
968: --
969: return form_variable;
970: hr_utility.set_location('Leaving:'||l_proc, 100);
971: end;

Line 970: hr_utility.set_location('Leaving:'||l_proc, 100);

966: begin
967: hr_utility.set_location('Entering:'||l_proc, 1);
968: --
969: return form_variable;
970: hr_utility.set_location('Leaving:'||l_proc, 100);
971: end;
972: --
973: -- ----------------------------------------------------------------------------
974: -- |---------------------------< insert_validate >----------------------------|

Line 981: hr_utility.set_location('Entering:'||l_proc, 1);

977: --
978: l_proc varchar2(72) := g_package||'insert_validate';
979: --
980: Begin
981: hr_utility.set_location('Entering:'||l_proc, 1);
982: --
983: -- Call all supporting business operations
984: --
985: -- Following two calls are to ensure that the mandatory columns

Line 1012: hr_utility.set_location('Leaving :'||l_proc, 100);

1008: p_rec.absence_category --DFoster 1305683
1009: );
1010: end if;
1011: --
1012: hr_utility.set_location('Leaving :'||l_proc, 100);
1013: End insert_validate;
1014: --
1015: -- ----------------------------------------------------------------------------
1016: -- |---------------------------< update_validate >----------------------------|

Line 1023: hr_utility.set_location('Entering:'||l_proc, 1);

1019: --
1020: l_proc varchar2(72) := g_package||'update_validate';
1021: --
1022: Begin
1023: hr_utility.set_location('Entering:'||l_proc, 1);
1024: --
1025: -- Call all supporting business operations
1026: --
1027: -- Following two bits of code used to ensure that the argument values

Line 1063: hr_utility.set_location('Leaving :'||l_proc, 100);

1059: p_rec.absence_category --DFoster 1304683
1060: );
1061: end if;
1062: --
1063: hr_utility.set_location('Leaving :'||l_proc, 100);
1064: End update_validate;
1065: --
1066: -- ----------------------------------------------------------------------------
1067: -- |---------------------------< delete_validate >----------------------------|

Line 1074: hr_utility.set_location('Entering:'||l_proc, 1);

1070: --
1071: l_proc varchar2(72) := g_package||'delete_validate';
1072: --
1073: Begin
1074: hr_utility.set_location('Entering:'||l_proc, 1);
1075: --
1076: -- Call all supporting business operations - there are none
1077: --
1078: hr_utility.set_location('Leaving :'||l_proc, 100);

Line 1078: hr_utility.set_location('Leaving :'||l_proc, 100);

1074: hr_utility.set_location('Entering:'||l_proc, 1);
1075: --
1076: -- Call all supporting business operations - there are none
1077: --
1078: hr_utility.set_location('Leaving :'||l_proc, 100);
1079: End delete_validate;
1080: --
1081: end ssp_ern_bus;