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

Line 374: hr_utility.trace('Entered Loop');

370: CLOSE regular_aggregate;
371:
372: OPEN other_assignments;
373:
374: hr_utility.trace('Entered Loop');
375:
376: LOOP
377:
378: FETCH other_assignments

Line 382: hr_utility.trace('Fetched from other assignments');

378: FETCH other_assignments
379: INTO v_assignment_id;
380: EXIT WHEN other_assignments%NOTFOUND;
381:
382: hr_utility.trace('Fetched from other assignments');
383:
384: IF (p_run_type = 'L' OR
385: l_regular_aggregate = 'N') THEN
386: v_assignment_id := p_asst_id;

Line 404: hr_utility.trace('Fetched from salary element');

400:
401: FETCH salary_element
402: INTO v_salary_element;
403:
404: hr_utility.trace('Fetched from salary element');
405:
406: IF (salary_element%NOTFOUND) THEN
407:
408: regular_earnings := 0;

Line 412: hr_utility.trace('Element is Regular Salary');

408: regular_earnings := 0;
409:
410: ELSIF v_salary_element = 'Regular Salary' THEN
411:
412: hr_utility.trace('Element is Regular Salary');
413: FETCH freq_code
414: INTO v_freq_code;
415:
416: FETCH asg_hours

Line 419: hr_utility.trace('Fetched from feq_code and asg_hours');

415:
416: FETCH asg_hours
417: INTO v_asg_hours;
418:
419: hr_utility.trace('Fetched from feq_code and asg_hours');
420:
421: FETCH salary_basis_code
422: INTO v_salary_basis_code;
423:

Line 430: hr_utility.trace('Going to call Convertr_Period_Type');

426:
427: FETCH work_schedule
428: INTO v_work_schedule;
429:
430: hr_utility.trace('Going to call Convertr_Period_Type');
431:
432: hourly_rate := hr_ca_ff_udfs.Convert_Period_Type(p_bus_grp_id,
433: p_payroll_id,
434: NULL,

Line 447: hr_utility.trace('Returned from call to Convert_Period_Type');

443: p_period_start,
444: p_period_end,
445: v_freq_code);
446:
447: hr_utility.trace('Returned from call to Convert_Period_Type');
448:
449: actual_hours_worked := 0;
450:
451: -- IF ASG_SALARY_BASIS_CODE WAS DEFAULTED THEN

Line 472: hr_utility.trace('Calulate_Period_Earnings returns: '|| to_char(regular_earnings));

468: actual_hours_worked,
469: 'Y',
470: v_freq_code);
471:
472: hr_utility.trace('Calulate_Period_Earnings returns: '|| to_char(regular_earnings));
473: ELSIF v_salary_element = 'Regular Wages' THEN
474:
475: FETCH rate
476: INTO v_rate;

Line 478: hr_utility.trace('Salary element is Regular Wages');

474:
475: FETCH rate
476: INTO v_rate;
477:
478: hr_utility.trace('Salary element is Regular Wages');
479: IF (rate%FOUND) THEN
480:
481: hourly_rate := v_rate;
482: actual_hours_worked := 0;

Line 487: hr_utility.trace('Fetched from freq_code');

483:
484: FETCH freq_code
485: INTO v_freq_code;
486:
487: hr_utility.trace('Fetched from freq_code');
488: FETCH asg_hours
489: INTO v_asg_hours;
490:
491: FETCH salary_basis_code

Line 497: hr_utility.trace('Going to call Calculate_Period_Earnings');

493:
494: FETCH work_schedule
495: INTO v_work_schedule;
496:
497: hr_utility.trace('Going to call Calculate_Period_Earnings');
498:
499: regular_earnings := hr_ca_ff_udfs.Calculate_Period_Earnings(p_bus_grp_id,
500: p_asst_id,
501: null,

Line 517: hr_utility.trace('Calulate_Period_Earnings returns: '|| to_char(regular_earnings));

513: actual_hours_worked,
514: 'Y',
515: v_freq_code);
516:
517: hr_utility.trace('Calulate_Period_Earnings returns: '|| to_char(regular_earnings));
518: ELSE
519: FETCH rate_code
520: INTO v_rate_code;
521:

Line 650: hr_utility.trace('Element is Regular Salary');

646: p_input_value_name => l_input_value_name);
647:
648: IF l_input_value_name = 'Amount' THEN
649:
650: hr_utility.trace('Element is Regular Salary');
651: FETCH freq_code INTO v_freq_code;
652:
653: FETCH asg_hours INTO v_asg_hours;
654:

Line 655: hr_utility.trace('Fetched from feq_code and asg_hours');

651: FETCH freq_code INTO v_freq_code;
652:
653: FETCH asg_hours INTO v_asg_hours;
654:
655: hr_utility.trace('Fetched from feq_code and asg_hours');
656:
657: FETCH periodic_salary INTO v_periodic_salary;
658:
659: FETCH work_schedule INTO v_work_schedule;

Line 661: hr_utility.trace('Going to call Convertr_Period_Type');

657: FETCH periodic_salary INTO v_periodic_salary;
658:
659: FETCH work_schedule INTO v_work_schedule;
660:
661: hr_utility.trace('Going to call Convertr_Period_Type');
662:
663: /*Commenting out this section as custom elements in Canada
664: currently do not perform any prorating, therefore the previous
665: earnings should also not be prorated */

Line 682: hr_utility.trace('Returned from call to Convert_Period_Type');

678: p_period_start,
679: p_period_end,
680: v_freq_code);
681:
682: hr_utility.trace('Returned from call to Convert_Period_Type');
683:
684: actual_hours_worked := 0;
685:
686: regular_earnings := hr_ca_ff_udfs.Calculate_Period_Earnings

Line 718: hr_utility.trace('Fetched from freq_code');

714: actual_hours_worked := 0;
715:
716: FETCH freq_code INTO v_freq_code;
717:
718: hr_utility.trace('Fetched from freq_code');
719: FETCH asg_hours INTO v_asg_hours;
720:
721: FETCH salary_basis_code INTO v_salary_basis_code;
722:

Line 725: hr_utility.trace('Going to call Calculate_Period_Earnings');

721: FETCH salary_basis_code INTO v_salary_basis_code;
722:
723: FETCH work_schedule INTO v_work_schedule;
724:
725: hr_utility.trace('Going to call Calculate_Period_Earnings');
726:
727: regular_earnings := hr_ca_ff_udfs.Calculate_Period_Earnings
728: (p_bus_grp_id,
729: p_asst_id,

Line 746: hr_utility.trace('Calulate_Period_Earnings returns: '|| to_char(regular_earnings));

742: actual_hours_worked,
743: 'Y',
744: v_freq_code);
745:
746: hr_utility.trace('Calulate_Period_Earnings returns: '|| to_char(regular_earnings));
747:
748: ELSIF l_input_value_name = 'Rate Code' THEN
749:
750: FETCH freq_code INTO v_freq_code;

Line 790: hr_utility.trace('Adding earnings : '|| to_char(regular_earnings) || ' to total earnings');

786: END IF;
787:
788: /* Must add earnings for each assignment */
789:
790: hr_utility.trace('Adding earnings : '|| to_char(regular_earnings) || ' to total earnings');
791: total_earnings := total_earnings + regular_earnings;
792:
793: CLOSE salary_element;
794: CLOSE freq_code;

Line 813: hr_utility.trace('Total earnings : '|| to_char(total_earnings));

809: END LOOP;
810:
811: CLOSE other_assignments;
812:
813: hr_utility.trace('Total earnings : '|| to_char(total_earnings));
814:
815: IF total_earnings IS NULL THEN
816: total_earnings := 0;
817: END IF;