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.

[Home] [Help]

APPS.PAY_GB_P11D_EDI_2008 dependencies on HR_UTILITY

Line 847: hr_utility.trace('edi_date_to:'||edi_date_to);

843: end if;
844:
845: if to_number(edi_date_to) <= to_number(edi_tax_year_end) then -- EOY 2008
846: -- EOY 2008
847: hr_utility.trace('edi_date_to:'||edi_date_to);
848: hr_utility.trace('l_valid_benefit_end_date_flag:'||l_valid_benefit_end_date_flag);
849: IF substr(edi_date_to,5,4) = '0405' THEN
850: IF l_valid_benefit_end_date_flag = 'Y' THEN
851: p_edi_rec22 := edi_dtm3 || edi_dtm489 || rpad(edi_date_to,36) || edi_dtm102 || fnd_global.local_chr(10); -- EOY 2008

Line 848: hr_utility.trace('l_valid_benefit_end_date_flag:'||l_valid_benefit_end_date_flag);

844:
845: if to_number(edi_date_to) <= to_number(edi_tax_year_end) then -- EOY 2008
846: -- EOY 2008
847: hr_utility.trace('edi_date_to:'||edi_date_to);
848: hr_utility.trace('l_valid_benefit_end_date_flag:'||l_valid_benefit_end_date_flag);
849: IF substr(edi_date_to,5,4) = '0405' THEN
850: IF l_valid_benefit_end_date_flag = 'Y' THEN
851: p_edi_rec22 := edi_dtm3 || edi_dtm489 || rpad(edi_date_to,36) || edi_dtm102 || fnd_global.local_chr(10); -- EOY 2008
852: hr_utility.trace('printing edi_date_to');

Line 852: hr_utility.trace('printing edi_date_to');

848: hr_utility.trace('l_valid_benefit_end_date_flag:'||l_valid_benefit_end_date_flag);
849: IF substr(edi_date_to,5,4) = '0405' THEN
850: IF l_valid_benefit_end_date_flag = 'Y' THEN
851: p_edi_rec22 := edi_dtm3 || edi_dtm489 || rpad(edi_date_to,36) || edi_dtm102 || fnd_global.local_chr(10); -- EOY 2008
852: hr_utility.trace('printing edi_date_to');
853: ELSE
854: hr_utility.trace('NOT printing edi_date_to');
855: END IF ;
856: ELSE

Line 854: hr_utility.trace('NOT printing edi_date_to');

850: IF l_valid_benefit_end_date_flag = 'Y' THEN
851: p_edi_rec22 := edi_dtm3 || edi_dtm489 || rpad(edi_date_to,36) || edi_dtm102 || fnd_global.local_chr(10); -- EOY 2008
852: hr_utility.trace('printing edi_date_to');
853: ELSE
854: hr_utility.trace('NOT printing edi_date_to');
855: END IF ;
856: ELSE
857: p_edi_rec22 := edi_dtm3 || edi_dtm489 || rpad(edi_date_to,36) || edi_dtm102 || fnd_global.local_chr(10); -- EOY 2008
858: hr_utility.trace('Unconditional printing edi_date_to');

Line 858: hr_utility.trace('Unconditional printing edi_date_to');

854: hr_utility.trace('NOT printing edi_date_to');
855: END IF ;
856: ELSE
857: p_edi_rec22 := edi_dtm3 || edi_dtm489 || rpad(edi_date_to,36) || edi_dtm102 || fnd_global.local_chr(10); -- EOY 2008
858: hr_utility.trace('Unconditional printing edi_date_to');
859: END IF ;
860: end if;
861:
862: if l_free_fuel_reinstated <> 'N' and to_number(l_cash_equivalent_for_fuel) > 0

Line 1546: hr_utility.trace('Asset : ' || asset.asset_type );

1542:
1543: l_total := 0;
1544: l_count := 0;
1545: for asset in get_data loop
1546: hr_utility.trace('Asset : ' || asset.asset_type );
1547: hr_utility.trace('Cash : ' || asset.cash_equivalent );
1548: if asset.cash_equivalent >= 1 then
1549: l_count := l_count + 1;
1550: l_total := l_total + asset.cash_equivalent;

Line 1547: hr_utility.trace('Cash : ' || asset.cash_equivalent );

1543: l_total := 0;
1544: l_count := 0;
1545: for asset in get_data loop
1546: hr_utility.trace('Asset : ' || asset.asset_type );
1547: hr_utility.trace('Cash : ' || asset.cash_equivalent );
1548: if asset.cash_equivalent >= 1 then
1549: l_count := l_count + 1;
1550: l_total := l_total + asset.cash_equivalent;
1551: l_annual := asset.cash_equivalent + asset.amount_made_good;

Line 2636: hr_utility.trace('\nxxxx get_benefit called - ' ||p_benefit_type) ;

2632: p_edi_rec29 out NoCopy varchar2,
2633: p_edi_rec30 out NoCopy varchar2) return number
2634: is
2635: begin
2636: hr_utility.trace('\nxxxx get_benefit called - ' ||p_benefit_type) ;
2637: if p_benefit_type = 'ASSETS TRANSFERRED' then
2638: hr_utility.trace('Assets Transferred');
2639: get_asset_transferred(p_person_id => p_person_id,
2640: p_emp_ref => p_employer_ref,

Line 2638: hr_utility.trace('Assets Transferred');

2634: is
2635: begin
2636: hr_utility.trace('\nxxxx get_benefit called - ' ||p_benefit_type) ;
2637: if p_benefit_type = 'ASSETS TRANSFERRED' then
2638: hr_utility.trace('Assets Transferred');
2639: get_asset_transferred(p_person_id => p_person_id,
2640: p_emp_ref => p_employer_ref,
2641: p_pact_id => p_pact_id,
2642: p_edi_rec1 => p_edi_rec1,

Line 2667: hr_utility.trace('Payment made for employee');

2663: p_edi_rec22 => p_edi_rec22);
2664: return 0;
2665: end if;
2666: if p_benefit_type = 'PAYMENTS MADE FOR EMP' then
2667: hr_utility.trace('Payment made for employee');
2668: get_payments_for_emp(p_person_id => p_person_id,
2669: p_emp_ref => p_employer_ref,
2670: p_pact_id => p_pact_id,
2671: p_edi_rec1 => p_edi_rec1,

Line 2691: hr_utility.trace('Voucher');

2687: p_edi_rec17 => p_edi_rec17);
2688: return 0;
2689: end if;
2690: if p_benefit_type = 'VOUCHERS OR CREDIT CARDS' then
2691: hr_utility.trace('Voucher');
2692: get_voucher_n_creditcard(p_person_id => p_person_id,
2693: p_emp_ref => p_employer_ref,
2694: p_pact_id => p_pact_id,
2695: p_edi_rec1 => p_edi_rec1,

Line 2705: hr_utility.trace('Living accommodation');

2701: p_edi_rec7 => p_edi_rec7);
2702: return 0;
2703: end if;
2704: if p_benefit_type = 'LIVING ACCOMMODATION' then
2705: hr_utility.trace('Living accommodation');
2706: get_living_accommodation(p_person_id => p_person_id,
2707: p_emp_ref => p_employer_ref,
2708: p_pact_id => p_pact_id,
2709: p_edi_rec1 => p_edi_rec1,

Line 2715: hr_utility.trace('Mileage allowance and prepayment');

2711: p_edi_rec3 => p_edi_rec3);
2712: return 0;
2713: end if;
2714: if p_benefit_type = 'MILEAGE ALLOWANCE AND PPAYMENT' then
2715: hr_utility.trace('Mileage allowance and prepayment');
2716: get_mileage_allowance(p_person_id => p_person_id,
2717: p_emp_ref => p_employer_ref,
2718: p_pact_id => p_pact_id,
2719: p_edi_rec1 => p_edi_rec1,

Line 2725: hr_utility.trace('Car');

2721: p_edi_rec3 => p_edi_rec3);
2722: return 0;
2723: end if;
2724: if p_benefit_type = 'CAR AND CAR FUEL 2003_04' then
2725: hr_utility.trace('Car');
2726: get_car_or_fuel(p_person_id => p_person_id,
2727: p_emp_ref => p_employer_ref,
2728: p_pact_id => p_pact_id,
2729: p_tax_year => p_tax_year,

Line 2759: hr_utility.trace('\nxxxx Vans called - ' ||p_benefit_type) ;

2755: p_edi_rec23 => p_edi_rec23);
2756: return 0;
2757: end if;
2758: if p_benefit_type = 'VANS 2007' then -- EOY 2008
2759: hr_utility.trace('\nxxxx Vans called - ' ||p_benefit_type) ;
2760: hr_utility.trace('Vans');
2761: -- EOY 2008. Added 2 extra parameters p_edi_rec4 and p_edi_rec5
2762: get_vans(p_person_id => p_person_id,
2763: p_emp_ref => p_employer_ref,

Line 2760: hr_utility.trace('Vans');

2756: return 0;
2757: end if;
2758: if p_benefit_type = 'VANS 2007' then -- EOY 2008
2759: hr_utility.trace('\nxxxx Vans called - ' ||p_benefit_type) ;
2760: hr_utility.trace('Vans');
2761: -- EOY 2008. Added 2 extra parameters p_edi_rec4 and p_edi_rec5
2762: get_vans(p_person_id => p_person_id,
2763: p_emp_ref => p_employer_ref,
2764: p_pact_id => p_pact_id,

Line 2773: hr_utility.trace('Loans');

2769: p_edi_rec5 => p_edi_rec5);
2770: return 0;
2771: end if;
2772: if p_benefit_type = 'INT FREE AND LOW INT LOANS' then
2773: hr_utility.trace('Loans');
2774: get_low_int_loan(p_person_id => p_person_id,
2775: p_emp_ref => p_employer_ref,
2776: p_pact_id => p_pact_id,
2777: p_ben_count => p_benefit_count,

Line 2792: hr_utility.trace('Insurance');

2788: p_edi_rec9 => p_edi_rec9);
2789: return 0;
2790: end if;
2791: if p_benefit_type = 'PVT MED TREATMENT OR INSURANCE' then
2792: hr_utility.trace('Insurance');
2793: get_pvt_med_or_ins(p_person_id => p_person_id,
2794: p_emp_ref => p_employer_ref,
2795: p_pact_id => p_pact_id,
2796: p_edi_rec1 => p_edi_rec1,

Line 2806: hr_utility.trace('Relocation expenses');

2802: p_edi_rec7 => p_edi_rec7);
2803: return 0;
2804: end if;
2805: if p_benefit_type = 'RELOCATION EXPENSES' then
2806: hr_utility.trace('Relocation expenses');
2807: get_relocation(p_person_id => p_person_id,
2808: p_emp_ref => p_employer_ref,
2809: p_pact_id => p_pact_id,
2810: p_edi_rec1 => p_edi_rec1,

Line 2816: hr_utility.trace('Service supplied');

2812: p_edi_rec3 => p_edi_rec3);
2813: return 0;
2814: end if;
2815: if p_benefit_type = 'SERVICES SUPPLIED' then
2816: hr_utility.trace('Service supplied');
2817: get_service_supplied(p_person_id => p_person_id,
2818: p_emp_ref => p_employer_ref,
2819: p_pact_id => p_pact_id,
2820: p_edi_rec1 => p_edi_rec1,

Line 2830: hr_utility.trace('Assets at employee disposal');

2826: p_edi_rec7 => p_edi_rec7);
2827: return 0;
2828: end if;
2829: if p_benefit_type = 'ASSETS AT EMP DISPOSAL' then
2830: hr_utility.trace('Assets at employee disposal');
2831: get_assets_at_emp(p_person_id => p_person_id,
2832: p_emp_ref => p_employer_ref,
2833: p_pact_id => p_pact_id,
2834: p_edi_rec1 => p_edi_rec1,

Line 2853: hr_utility.trace('Other Items');

2849: p_edi_rec16 => p_edi_rec16);
2850: return 0;
2851: end if;
2852: if p_benefit_type = 'OTHER ITEMS' then
2853: hr_utility.trace('Other Items');
2854: get_other_items(p_person_id => p_person_id,
2855: p_emp_ref => p_employer_ref,
2856: p_pact_id => p_pact_id,
2857: p_edi_rec1 => p_edi_rec1,

Line 2882: hr_utility.trace('Expenses Payments');

2878: p_edi_rec22 => p_edi_rec22);
2879: return 0;
2880: end if;
2881: if p_benefit_type = 'EXPENSES PAYMENTS' then
2882: hr_utility.trace('Expenses Payments');
2883: get_exp_payment(p_person_id => p_person_id,
2884: p_emp_ref => p_employer_ref,
2885: p_pact_id => p_pact_id,
2886: p_edi_rec1 => p_edi_rec1,

Line 2909: hr_utility.trace('Marrors');

2905: p_edi_rec20 => p_edi_rec20);
2906: return 0;
2907: end if;
2908: if p_benefit_type = 'MARORS' then
2909: hr_utility.trace('Marrors');
2910: get_marors(p_person_id => p_person_id,
2911: p_emp_ref => p_employer_ref,
2912: p_pact_id => p_pact_id,
2913: p_edi_rec1 => p_edi_rec1,

Line 3038: hr_utility.trace('\nxxxx Get_benefit name called - ' ||p_benefit_type) ;

3034: function get_benefit_name(p_benefit_type in varchar2) return varchar2
3035: is
3036: l_benefit_name varchar2(80);
3037: begin
3038: hr_utility.trace('\nxxxx Get_benefit name called - ' ||p_benefit_type) ;
3039: select decode(p_benefit_type,
3040: 'A', 'ASSETS TRANSFERRED',
3041: 'B', 'PAYMENTS MADE FOR EMP',
3042: 'C', 'VOUCHERS OR CREDIT CARDS',