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

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

865: end if;
866:
867: if to_number(edi_date_to) <= to_number(edi_tax_year_end) then -- EOY 2008
868: -- EOY 2008
869: hr_utility.trace('edi_date_to:'||edi_date_to);
870: hr_utility.trace('l_valid_benefit_end_date_flag:'||l_valid_benefit_end_date_flag);
871: IF substr(edi_date_to,5,4) = '0405' THEN
872: IF l_valid_benefit_end_date_flag = 'Y' THEN
873: p_edi_rec22 := edi_dtm3 || edi_dtm489 || rpad(edi_date_to,36) || edi_dtm102 || fnd_global.local_chr(10); -- EOY 2008

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

866:
867: if to_number(edi_date_to) <= to_number(edi_tax_year_end) then -- EOY 2008
868: -- EOY 2008
869: hr_utility.trace('edi_date_to:'||edi_date_to);
870: hr_utility.trace('l_valid_benefit_end_date_flag:'||l_valid_benefit_end_date_flag);
871: IF substr(edi_date_to,5,4) = '0405' THEN
872: IF l_valid_benefit_end_date_flag = 'Y' THEN
873: p_edi_rec22 := edi_dtm3 || edi_dtm489 || rpad(edi_date_to,36) || edi_dtm102 || fnd_global.local_chr(10); -- EOY 2008
874: hr_utility.trace('printing edi_date_to');

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

870: hr_utility.trace('l_valid_benefit_end_date_flag:'||l_valid_benefit_end_date_flag);
871: IF substr(edi_date_to,5,4) = '0405' THEN
872: IF l_valid_benefit_end_date_flag = 'Y' THEN
873: p_edi_rec22 := edi_dtm3 || edi_dtm489 || rpad(edi_date_to,36) || edi_dtm102 || fnd_global.local_chr(10); -- EOY 2008
874: hr_utility.trace('printing edi_date_to');
875: ELSE
876: hr_utility.trace('NOT printing edi_date_to');
877: END IF ;
878: ELSE

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

872: IF l_valid_benefit_end_date_flag = 'Y' THEN
873: p_edi_rec22 := edi_dtm3 || edi_dtm489 || rpad(edi_date_to,36) || edi_dtm102 || fnd_global.local_chr(10); -- EOY 2008
874: hr_utility.trace('printing edi_date_to');
875: ELSE
876: hr_utility.trace('NOT printing edi_date_to');
877: END IF ;
878: ELSE
879: p_edi_rec22 := edi_dtm3 || edi_dtm489 || rpad(edi_date_to,36) || edi_dtm102 || fnd_global.local_chr(10); -- EOY 2008
880: hr_utility.trace('Unconditional printing edi_date_to');

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

876: hr_utility.trace('NOT printing edi_date_to');
877: END IF ;
878: ELSE
879: p_edi_rec22 := edi_dtm3 || edi_dtm489 || rpad(edi_date_to,36) || edi_dtm102 || fnd_global.local_chr(10); -- EOY 2008
880: hr_utility.trace('Unconditional printing edi_date_to');
881: END IF ;
882: end if;
883:
884: if l_free_fuel_reinstated <> 'N' and to_number(l_cash_equivalent_for_fuel) > 0

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

1564:
1565: l_total := 0;
1566: l_count := 0;
1567: for asset in get_data loop
1568: hr_utility.trace('Asset : ' || asset.asset_type );
1569: hr_utility.trace('Cash : ' || asset.cash_equivalent );
1570: if asset.cash_equivalent >= 1 then
1571: l_count := l_count + 1;
1572: l_total := l_total + asset.cash_equivalent;

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

1565: l_total := 0;
1566: l_count := 0;
1567: for asset in get_data loop
1568: hr_utility.trace('Asset : ' || asset.asset_type );
1569: hr_utility.trace('Cash : ' || asset.cash_equivalent );
1570: if asset.cash_equivalent >= 1 then
1571: l_count := l_count + 1;
1572: l_total := l_total + asset.cash_equivalent;
1573: l_annual := asset.cash_equivalent + asset.amount_made_good;

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

2684: p_edi_rec29 out NoCopy varchar2,
2685: p_edi_rec30 out NoCopy varchar2) return number
2686: is
2687: begin
2688: hr_utility.trace('\nxxxx get_benefit called - ' ||p_benefit_type) ;
2689: if p_benefit_type = 'ASSETS TRANSFERRED' then
2690: hr_utility.trace('Assets Transferred');
2691: get_asset_transferred(p_person_id => p_person_id,
2692: p_emp_ref => p_employer_ref,

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

2686: is
2687: begin
2688: hr_utility.trace('\nxxxx get_benefit called - ' ||p_benefit_type) ;
2689: if p_benefit_type = 'ASSETS TRANSFERRED' then
2690: hr_utility.trace('Assets Transferred');
2691: get_asset_transferred(p_person_id => p_person_id,
2692: p_emp_ref => p_employer_ref,
2693: p_pact_id => p_pact_id,
2694: p_edi_rec1 => p_edi_rec1,

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

2715: p_edi_rec22 => p_edi_rec22);
2716: return 0;
2717: end if;
2718: if p_benefit_type = 'PAYMENTS MADE FOR EMP' then
2719: hr_utility.trace('Payment made for employee');
2720: get_payments_for_emp(p_person_id => p_person_id,
2721: p_emp_ref => p_employer_ref,
2722: p_pact_id => p_pact_id,
2723: p_edi_rec1 => p_edi_rec1,

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

2739: p_edi_rec17 => p_edi_rec17);
2740: return 0;
2741: end if;
2742: if p_benefit_type = 'VOUCHERS OR CREDIT CARDS' then
2743: hr_utility.trace('Voucher');
2744: get_voucher_n_creditcard(p_person_id => p_person_id,
2745: p_emp_ref => p_employer_ref,
2746: p_pact_id => p_pact_id,
2747: p_edi_rec1 => p_edi_rec1,

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

2753: p_edi_rec7 => p_edi_rec7);
2754: return 0;
2755: end if;
2756: if p_benefit_type = 'LIVING ACCOMMODATION' then
2757: hr_utility.trace('Living accommodation');
2758: get_living_accommodation(p_person_id => p_person_id,
2759: p_emp_ref => p_employer_ref,
2760: p_pact_id => p_pact_id,
2761: p_edi_rec1 => p_edi_rec1,

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

2763: p_edi_rec3 => p_edi_rec3);
2764: return 0;
2765: end if;
2766: if p_benefit_type = 'MILEAGE ALLOWANCE AND PPAYMENT' then
2767: hr_utility.trace('Mileage allowance and prepayment');
2768: get_mileage_allowance(p_person_id => p_person_id,
2769: p_emp_ref => p_employer_ref,
2770: p_pact_id => p_pact_id,
2771: p_edi_rec1 => p_edi_rec1,

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

2773: p_edi_rec3 => p_edi_rec3);
2774: return 0;
2775: end if;
2776: if p_benefit_type = 'CAR AND CAR FUEL 2003_04' then
2777: hr_utility.trace('Car');
2778: get_car_or_fuel(p_person_id => p_person_id,
2779: p_emp_ref => p_employer_ref,
2780: p_pact_id => p_pact_id,
2781: p_tax_year => p_tax_year,

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

2807: p_edi_rec23 => p_edi_rec23);
2808: return 0;
2809: end if;
2810: if p_benefit_type = 'VANS 2007' then -- EOY 2008
2811: hr_utility.trace('\nxxxx Vans called - ' ||p_benefit_type) ;
2812: hr_utility.trace('Vans');
2813: -- EOY 2008. Added 2 extra parameters p_edi_rec4 and p_edi_rec5
2814: get_vans(p_person_id => p_person_id,
2815: p_emp_ref => p_employer_ref,

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

2808: return 0;
2809: end if;
2810: if p_benefit_type = 'VANS 2007' then -- EOY 2008
2811: hr_utility.trace('\nxxxx Vans called - ' ||p_benefit_type) ;
2812: hr_utility.trace('Vans');
2813: -- EOY 2008. Added 2 extra parameters p_edi_rec4 and p_edi_rec5
2814: get_vans(p_person_id => p_person_id,
2815: p_emp_ref => p_employer_ref,
2816: p_pact_id => p_pact_id,

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

2821: p_edi_rec5 => p_edi_rec5);
2822: return 0;
2823: end if;
2824: if p_benefit_type = 'INT FREE AND LOW INT LOANS' then
2825: hr_utility.trace('Loans');
2826: get_low_int_loan(p_person_id => p_person_id,
2827: p_emp_ref => p_employer_ref,
2828: p_pact_id => p_pact_id,
2829: p_ben_count => p_benefit_count,

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

2840: p_edi_rec9 => p_edi_rec9);
2841: return 0;
2842: end if;
2843: if p_benefit_type = 'PVT MED TREATMENT OR INSURANCE' then
2844: hr_utility.trace('Insurance');
2845: get_pvt_med_or_ins(p_person_id => p_person_id,
2846: p_emp_ref => p_employer_ref,
2847: p_pact_id => p_pact_id,
2848: p_edi_rec1 => p_edi_rec1,

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

2854: p_edi_rec7 => p_edi_rec7);
2855: return 0;
2856: end if;
2857: if p_benefit_type = 'RELOCATION EXPENSES' then
2858: hr_utility.trace('Relocation expenses');
2859: get_relocation(p_person_id => p_person_id,
2860: p_emp_ref => p_employer_ref,
2861: p_pact_id => p_pact_id,
2862: p_edi_rec1 => p_edi_rec1,

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

2864: p_edi_rec3 => p_edi_rec3);
2865: return 0;
2866: end if;
2867: if p_benefit_type = 'SERVICES SUPPLIED' then
2868: hr_utility.trace('Service supplied');
2869: get_service_supplied(p_person_id => p_person_id,
2870: p_emp_ref => p_employer_ref,
2871: p_pact_id => p_pact_id,
2872: p_edi_rec1 => p_edi_rec1,

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

2878: p_edi_rec7 => p_edi_rec7);
2879: return 0;
2880: end if;
2881: if p_benefit_type = 'ASSETS AT EMP DISPOSAL' then
2882: hr_utility.trace('Assets at employee disposal');
2883: get_assets_at_emp(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 2905: hr_utility.trace('Other Items');

2901: p_edi_rec16 => p_edi_rec16);
2902: return 0;
2903: end if;
2904: if p_benefit_type = 'OTHER ITEMS' then
2905: hr_utility.trace('Other Items');
2906: get_other_items(p_person_id => p_person_id,
2907: p_emp_ref => p_employer_ref,
2908: p_pact_id => p_pact_id,
2909: p_edi_rec1 => p_edi_rec1,

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

2930: p_edi_rec22 => p_edi_rec22);
2931: return 0;
2932: end if;
2933: if p_benefit_type = 'EXPENSES PAYMENTS' then
2934: hr_utility.trace('Expenses Payments');
2935: get_exp_payment(p_person_id => p_person_id,
2936: p_emp_ref => p_employer_ref,
2937: p_pact_id => p_pact_id,
2938: p_edi_rec1 => p_edi_rec1,

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

2957: p_edi_rec20 => p_edi_rec20);
2958: return 0;
2959: end if;
2960: if p_benefit_type = 'MARORS' then
2961: hr_utility.trace('Marrors');
2962: get_marors(p_person_id => p_person_id,
2963: p_emp_ref => p_employer_ref,
2964: p_pact_id => p_pact_id,
2965: p_edi_rec1 => p_edi_rec1,

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

3086: function get_benefit_name(p_benefit_type in varchar2) return varchar2
3087: is
3088: l_benefit_name varchar2(80);
3089: begin
3090: hr_utility.trace('\nxxxx Get_benefit name called - ' ||p_benefit_type) ;
3091: select decode(p_benefit_type,
3092: 'A', 'ASSETS TRANSFERRED',
3093: 'B', 'PAYMENTS MADE FOR EMP',
3094: 'C', 'VOUCHERS OR CREDIT CARDS',