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_DK_ARCHIVE_EIN dependencies on FND_FILE

Line 365: -- fnd_file.put_line(fnd_file.log,'Range Code 6');

361: WHERE action_information_category = 'EMEA REPORT DETAILS'
362: AND action_information1 = 'PYDKEINA'
363: AND action_context_id = p_payroll_action_id;
364:
365: -- fnd_file.put_line(fnd_file.log,'Range Code 6');
366:
367: IF l_count < 1 then
368:
369: hr_utility.set_location('Entered Procedure GETDATA',10);

Line 372: -- fnd_file.put_line(fnd_file.log,'g_legal_employer_id : '||g_legal_employer_id);

368:
369: hr_utility.set_location('Entered Procedure GETDATA',10);
370:
371:
372: -- fnd_file.put_line(fnd_file.log,'g_legal_employer_id : '||g_legal_employer_id);
373: -- fnd_file.put_line(fnd_file.log,'l_business_group_id : '||l_business_group_id);
374: OPEN csr_Legal_Emp_Details(g_legal_employer_id);
375: FETCH csr_Legal_Emp_Details INTO rg_Legal_Emp_Details;
376:

Line 373: -- fnd_file.put_line(fnd_file.log,'l_business_group_id : '||l_business_group_id);

369: hr_utility.set_location('Entered Procedure GETDATA',10);
370:
371:
372: -- fnd_file.put_line(fnd_file.log,'g_legal_employer_id : '||g_legal_employer_id);
373: -- fnd_file.put_line(fnd_file.log,'l_business_group_id : '||l_business_group_id);
374: OPEN csr_Legal_Emp_Details(g_legal_employer_id);
375: FETCH csr_Legal_Emp_Details INTO rg_Legal_Emp_Details;
376:
377: /* if(csr_Legal_Emp_Details%notfound) then

Line 378: fnd_file.put_line(fnd_file.log,'No data found for the legal emp');

374: OPEN csr_Legal_Emp_Details(g_legal_employer_id);
375: FETCH csr_Legal_Emp_Details INTO rg_Legal_Emp_Details;
376:
377: /* if(csr_Legal_Emp_Details%notfound) then
378: fnd_file.put_line(fnd_file.log,'No data found for the legal emp');
379: end if;*/
380:
381: l_le_name := rg_Legal_Emp_Details.name ;
382: l_cvr_number := rg_Legal_Emp_Details.ORG_INFORMATION1 ;

Line 384: -- fnd_file.put_line(fnd_file.log,'l_cvr_number : '||l_cvr_number);

380:
381: l_le_name := rg_Legal_Emp_Details.name ;
382: l_cvr_number := rg_Legal_Emp_Details.ORG_INFORMATION1 ;
383:
384: -- fnd_file.put_line(fnd_file.log,'l_cvr_number : '||l_cvr_number);
385:
386: CLOSE csr_Legal_Emp_Details;
387:
388: /* Pick up the details belonging to Legal Employer

Line 466: fnd_file.put_line(fnd_file.log,HR_DK_UTILITY.GET_MESSAGE('PAY','HR_377103_DK_EINCOME_STATUS'));

462: l_sp_cvr_number := sp.org_information1;
463:
464: -- check the value of e-income data supplier
465: if(sp.org_information3<>'Y') then
466: fnd_file.put_line(fnd_file.log,HR_DK_UTILITY.GET_MESSAGE('PAY','HR_377103_DK_EINCOME_STATUS'));
467: g_flag:=1;
468: else
469: -- l_unique_id:=l_sp_cvr_number; /* 9489806 */
470:

Line 617: -- fnd_file.put_line(fnd_file.log,'Range Code 14');

613: fetch csr_payroll_name into l_payroll_name;
614: close csr_payroll_name;
615: END IF;
616:
617: -- fnd_file.put_line(fnd_file.log,'Range Code 14');
618: --Report Level Information
619: pay_action_information_api.create_action_information (
620: p_action_information_id => l_action_info_id
621: ,p_action_context_id => p_payroll_action_id

Line 659: -- fnd_file.put_line(fnd_file.log,'Range Code 15');

655: ,p_action_information28 => null
656: ,p_action_information29 => null
657: ,p_action_information30 => null );
658:
659: -- fnd_file.put_line(fnd_file.log,'Range Code 15');
660:
661: end if; -- end g_flag condition
662:
663: END IF;

Line 755: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 1');

751: pp csr_pay_periods%rowtype;
752:
753: BEGIN
754: if(g_flag=0) then
755: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 1');
756:
757: IF g_debug THEN
758: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
759: END IF;

Line 775: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 2');

771: ,g_test_submission
772: ,g_company_terminating
773: ,g_sender_id) ;
774:
775: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 2');
776:
777: g_payroll_action_id :=p_payroll_action_id;
778:
779: /*

Line 792: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 3');

788: l_prepay_action_id := 0;
789: l_prev_person_id := 0;
790: l_prev_assg_id := 0;
791:
792: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 3');
793:
794: FOR rec_prepaid_assignments IN csr_prepaid_assignments_le(p_payroll_action_id
795: ,p_start_person
796: ,p_end_person

Line 818: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 7');

814: ,p_payroll_action_id
815: ,p_chunk
816: ,NULL);
817:
818: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 7');
819:
820: END IF;
821: l_prepay_action_id := rec_prepaid_assignments.prepaid_action_id;
822: l_prev_person_id := rec_prepaid_assignments.person_id;

Line 848: -- fnd_file.put_line(fnd_file.log,'INITIALIZATION_CODE 1');

844: BEGIN
845: IF g_debug THEN
846: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
847: END IF;
848: -- fnd_file.put_line(fnd_file.log,'INITIALIZATION_CODE 1');
849: IF g_debug THEN
850: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
851: END IF;
852:

Line 1878: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 1');

1874:
1875:
1876:
1877: BEGIN
1878: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 1');
1879: /*Initializing all balance variables*/
1880: l_sp_bonus :=0;
1881: l_free_phone :=0;
1882: l_multimedia := 0; -- bug# 9079593 fix

Line 1968: fnd_file.put_line(fnd_file.log,'l_usr_tbl_exist_400:'||l_usr_tbl_exist_400);

1964: OPEN cur_table_val_exist_400(l_payroll_action_id);
1965: FETCH cur_table_val_exist_400 INTO l_usr_tbl_exist_400;
1966: CLOSE cur_table_val_exist_400;
1967:
1968: fnd_file.put_line(fnd_file.log,'l_usr_tbl_exist_400:'||l_usr_tbl_exist_400);
1969: --13463885
1970:
1971:
1972: if(g_flag=0) then

Line 1975: fnd_file.put_line(fnd_file.log,'Fetched report parameters');

1971:
1972: if(g_flag=0) then
1973: if(g_company_terminating='N') then
1974:
1975: fnd_file.put_line(fnd_file.log,'Fetched report parameters');
1976:
1977: hr_utility.set_location('ARCHIVE_CODE: l_assignment_id '|| l_ass_id,380);
1978: hr_utility.set_location('ARCHIVE_CODE: Before For loop csr_asg_payroll ',380);
1979:

Line 2020: fnd_file.put_line(fnd_file.log,'Fetched person details');

2016: l_bg_id:=rg_csr_get_person_details.business_group_id;
2017: l_org_id:=rg_csr_get_person_details.organization_id;
2018: l_loc_id:=rg_csr_get_person_details.location_id;
2019:
2020: fnd_file.put_line(fnd_file.log,'Fetched person details');
2021:
2022:
2023:
2024:

Line 2044: fnd_file.put_line(fnd_file.log,'Fetched payroll period details');

2040: --l_cpr_number:=NULL;
2041: l_cpr_number := '00000000000'; -- Bug 8552112
2042: END IF;
2043:
2044: fnd_file.put_line(fnd_file.log,'Fetched payroll period details');
2045:
2046: OPEN csr_get_atp_table_value(l_assignment_id, l_start_date, l_end_date);
2047: FETCH csr_get_atp_table_value into rg_csr_get_atp_table_value;
2048: CLOSE csr_get_atp_table_value;

Line 2050: fnd_file.put_line(fnd_file.log,'Fetched atp table value');

2046: OPEN csr_get_atp_table_value(l_assignment_id, l_start_date, l_end_date);
2047: FETCH csr_get_atp_table_value into rg_csr_get_atp_table_value;
2048: CLOSE csr_get_atp_table_value;
2049:
2050: fnd_file.put_line(fnd_file.log,'Fetched atp table value');
2051: IF l_loc_id IS NOT NULL THEN
2052: OPEN csr_location_info (l_loc_id);
2053: FETCH csr_location_info INTO rg_csr_location_info;
2054: CLOSE csr_location_info;

Line 2056: fnd_file.put_line(fnd_file.log,'bg id:'||l_bg_id);

2052: OPEN csr_location_info (l_loc_id);
2053: FETCH csr_location_info INTO rg_csr_location_info;
2054: CLOSE csr_location_info;
2055: END IF;
2056: fnd_file.put_line(fnd_file.log,'bg id:'||l_bg_id);
2057: fnd_file.put_line(fnd_file.log,'org id:'||l_org_id);
2058: OPEN csr_get_hr_org_info(l_bg_id,l_org_id);
2059: FETCH csr_get_hr_org_info into rg_csr_get_hr_org_info;
2060: CLOSE csr_get_hr_org_info;

Line 2057: fnd_file.put_line(fnd_file.log,'org id:'||l_org_id);

2053: FETCH csr_location_info INTO rg_csr_location_info;
2054: CLOSE csr_location_info;
2055: END IF;
2056: fnd_file.put_line(fnd_file.log,'bg id:'||l_bg_id);
2057: fnd_file.put_line(fnd_file.log,'org id:'||l_org_id);
2058: OPEN csr_get_hr_org_info(l_bg_id,l_org_id);
2059: FETCH csr_get_hr_org_info into rg_csr_get_hr_org_info;
2060: CLOSE csr_get_hr_org_info;
2061:

Line 2063: fnd_file.put_line(fnd_file.log,'Fetched hr org info');

2059: FETCH csr_get_hr_org_info into rg_csr_get_hr_org_info;
2060: CLOSE csr_get_hr_org_info;
2061:
2062:
2063: fnd_file.put_line(fnd_file.log,'Fetched hr org info');
2064:
2065: OPEN csr_Legal_Emp_Details(g_legal_employer_id);
2066: FETCH csr_Legal_Emp_Details INTO rg_Legal_Emp_Details;
2067: CLOSE csr_Legal_Emp_Details;

Line 2069: fnd_file.put_line(fnd_file.log,'Fetched legal emp details');

2065: OPEN csr_Legal_Emp_Details(g_legal_employer_id);
2066: FETCH csr_Legal_Emp_Details INTO rg_Legal_Emp_Details;
2067: CLOSE csr_Legal_Emp_Details;
2068:
2069: fnd_file.put_line(fnd_file.log,'Fetched legal emp details');
2070:
2071: OPEN csr_get_tax_card_details(l_assignment_id, l_start_date, l_end_date);
2072: FETCH csr_get_tax_card_details INTO rg_csr_get_tax_card_details;
2073: CLOSE csr_get_tax_card_details;

Line 2103: fnd_file.put_line(fnd_file.log,'hire date from per_people_v : '||l_hd);

2099: /* Code for getting the hire date from PER_PEOPLE_V*/
2100: /* begin
2101:
2102: select to_char(HIRE_DATE) into l_hd from PER_PEOPLE_V where NATIONAL_IDENTIFIER=rg_csr_get_person_details.cpr ;
2103: fnd_file.put_line(fnd_file.log,'hire date from per_people_v : '||l_hd);
2104:
2105: exception
2106: when others then
2107: null;

Line 2116: -- fnd_file.put_line(fnd_file.log,'Inserting starters');

2112: CLOSE csr_latest_hire_date;
2113:
2114: l_cpr_number:= rg_csr_get_person_details.cpr;
2115: if((rg_csr_latest_hire_date.lhd between l_start_date and l_end_date) and to_char(l_end_date,'mm')<'06' and to_char(l_end_date,'yyyy')<='2008') then
2116: -- fnd_file.put_line(fnd_file.log,'Inserting starters');
2117: --Record - 2101
2118: pay_action_information_api.create_action_information (
2119: p_action_information_id => l_action_info_id
2120: ,p_action_context_id => p_assignment_action_id

Line 2187: fnd_file.put_line(fnd_file.log,'Inserting terminators');

2183: --end bug 10367494
2184:
2185: /* bug 10367494 archiving p_action_information11 => l_se_no */
2186: if(rg_csr_asg_terminator.effective_end_date <= l_end_date) then
2187: fnd_file.put_line(fnd_file.log,'Inserting terminators');
2188: --Record - 2101
2189: pay_action_information_api.create_action_information (
2190: p_action_information_id => l_action_info_id
2191: ,p_action_context_id => p_assignment_action_id

Line 2260: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 2');

2256:
2257: l_emp_amb := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Employee AMB Deduction','_ASG_PTD' ,l_bal_date);
2258: l_hol_amb := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Holiday AMB','_ASG_PTD' ,l_bal_date);
2259: l_hol_amb_rep := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id, rg_csr_asg_action_id.id);
2260: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 2');
2261:
2262: l_hourly_salaried :=rg_csr_get_person_details.HOURLY_SALARIED_CODE;
2263: if(l_hourly_salaried IS null) then
2264: if (rg_csr_pay_periods.PAYROLL_PERIOD=1) then

Line 2295: -- fnd_file.put_line(fnd_file.log,'PU code:'||l_pu_code);

2291: END IF;
2292:
2293:
2294:
2295: -- fnd_file.put_line(fnd_file.log,'PU code:'||l_pu_code);
2296:
2297:
2298:
2299: /* bug fix 7613211 */

Line 2303: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4');

2299: /* bug fix 7613211 */
2300: -- Record - 8001
2301:
2302:
2303: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4');
2304:
2305: fnd_file.put_line(fnd_file.log,'p_assignment_action_id:'||p_assignment_action_id);
2306: fnd_file.put_line(fnd_file.log,'l_bal_date:'||l_bal_date);
2307:

Line 2305: fnd_file.put_line(fnd_file.log,'p_assignment_action_id:'||p_assignment_action_id);

2301:
2302:
2303: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4');
2304:
2305: fnd_file.put_line(fnd_file.log,'p_assignment_action_id:'||p_assignment_action_id);
2306: fnd_file.put_line(fnd_file.log,'l_bal_date:'||l_bal_date);
2307:
2308: -- Record 6001
2309: l_amb_pay_adj := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'AMBable Pay Adjustment','_ASG_PTD',l_bal_date);

Line 2306: fnd_file.put_line(fnd_file.log,'l_bal_date:'||l_bal_date);

2302:
2303: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4');
2304:
2305: fnd_file.put_line(fnd_file.log,'p_assignment_action_id:'||p_assignment_action_id);
2306: fnd_file.put_line(fnd_file.log,'l_bal_date:'||l_bal_date);
2307:
2308: -- Record 6001
2309: l_amb_pay_adj := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'AMBable Pay Adjustment','_ASG_PTD',l_bal_date);
2310: l_amb_pay := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'AMBable Pay','_ASG_PTD',l_bal_date)

Line 2327: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4.5');

2323: l_amb_pay := l_amb_pay - l_b_income_amb;
2324: END IF;
2325: --
2326:
2327: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 4.5');
2328: l_emp_atp := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Employee ATP Deductions','_ASG_PTD' ,l_bal_date);
2329: l_pension := nvl(GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Employee Pension Deductions','_ASG_PTD' ,l_bal_date),0)
2330: + nvl(GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Rate Pension Deduction','_ASG_PTD' ,l_bal_date),0);
2331: /* 9136987 */

Line 2359: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 5');

2355: END IF;
2356: --
2357:
2358:
2359: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 5');
2360: l_hourly_holiday_pay_adj := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Holiday Accrual Pay Adjustment','_ASG_PTD' ,l_bal_date);
2361: l_hourly_holiday_pay := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Holiday Accrual Pay','_ASG_PTD' ,l_bal_date)
2362: - l_hourly_holiday_pay_adj;
2363: /* bug 12794710 commented below l_monthly_holiday_pay */

Line 2431: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 12');

2427: l_a_income := l_a_income - l_b_income_amb;
2428: END IF;
2429: --
2430: /* 10180980 start */
2431: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 12');
2432: l_sp_bonus_adj := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Special Pay Adjustment','_ASG_PTD' ,l_bal_date);
2433: l_sp_bonus := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Special Pay','_ASG_PTD' ,l_bal_date);
2434: l_a_income := l_a_income - l_sp_bonus; /* only Special pay balance need to be substracted as this is the amount
2435: that got fed in to AMBable Pay via Special Pay Classification feed */

Line 2440: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 6');

2436: l_gross_income := l_gross_income - l_sp_bonus; /* added for bug 12393673 */
2437: l_sp_bonus := l_sp_bonus - l_sp_bonus_adj;
2438: /* 10180980 end */
2439:
2440: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 6');
2441: /* 8861878 */
2442: --
2443: /* moved these balance fetches to top as these figures shoudl be included in gros income 9136987 */
2444: /*

Line 2450: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 6.5');

2446: l_a_non_amb_income := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total A Income Not AMBable','_ASG_PTD' ,l_bal_date)
2447: - l_a_income_non_amb_adj; */
2448:
2449:
2450: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 6.5');
2451: --
2452: /* 9945754-1 Moving this statements to the top
2453:
2454: OPEN csr_asg_action_id(rg_csr_get_person_details.assignment_id,l_payroll_id,l_period_id,g_legal_employer_id);

Line 2472: -- fnd_file.put_line(fnd_file.log,'Hourly Holiday Tax_Payments : '||l_holiday_tax_pay);

2468: l_holiday_tax := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Holiday Tax','_ASG_PTD' ,l_bal_date);
2469: l_holiday_tax_pay := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id, rg_csr_asg_action_id.id);
2470: */
2471:
2472: -- fnd_file.put_line(fnd_file.log,'Hourly Holiday Tax_Payments : '||l_holiday_tax_pay);
2473: -- /* 9945754 */
2474: IF l_hourly_salaried='H' THEN
2475: l_tax := FLOOR(l_emp_tax)+FLOOR(l_holiday_tax_pay);
2476: ELSE

Line 2491: -- fnd_file.put_line(fnd_file.log,'Holiday AMB Reporting (ASG RUN) : '||l_hol_amb_rep);

2487:
2488: l_hol_amb := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Holiday AMB','_ASG_PTD' ,l_bal_date);
2489: l_hol_amb_rep := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id, rg_csr_asg_action_id.id);
2490: */
2491: -- fnd_file.put_line(fnd_file.log,'Holiday AMB Reporting (ASG RUN) : '||l_hol_amb_rep);
2492: /* 9945754 */
2493: /* 101842801 moved to top */
2494: /*
2495: IF l_hourly_salaried='H' THEN

Line 2510: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 8');

2506: l_car := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total Taxable Car Amount','_ASG_PTD' ,l_bal_date)
2507: - l_car_adj;
2508:
2509:
2510: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 8');
2511: l_board_lodge_adj := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total Board and Lodge Adjustment','_ASG_PTD' ,l_bal_date);
2512: l_board_lodge := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total Board and Lodge Amount','_ASG_PTD' ,l_bal_date)
2513: - l_board_lodge_adj;
2514:

Line 2523: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 8.2');

2519: -- l_b_income_amb := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total B Income Subject to AMB','_ASG_PTD' ,l_bal_date)
2520: -- - l_b_income_amb_adj;
2521:
2522:
2523: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 8.2');
2524: -- B-Income
2525: l_b_income_non_amb_adj := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total B Income Not Subject to AMB Adjustment','_ASG_PTD' ,l_bal_date);
2526: l_b_income_non_amb := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total B Income Not Subject to AMB','_ASG_PTD' ,l_bal_date)
2527: - l_b_income_non_amb_adj;

Line 2531: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 9');

2527: - l_b_income_non_amb_adj;
2528:
2529: --
2530:
2531: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 9');
2532:
2533: l_employer_atp := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Employer ATP Deductions','_ASG_PTD' ,l_bal_date);
2534: l_total_atp := l_emp_atp+l_employer_atp;
2535:

Line 2537: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 10');

2533: l_employer_atp := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Employer ATP Deductions','_ASG_PTD' ,l_bal_date);
2534: l_total_atp := l_emp_atp+l_employer_atp;
2535:
2536:
2537: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 10');
2538: /* 8861878 */
2539: --
2540: l_non_taxable_travel_adj:= GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total Non Taxable Travel and Per Diem Adjustment','_ASG_PTD' ,l_bal_date);
2541: l_non_taxable_travel:= GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total Non Taxable Travel and Per Diem','_ASG_PTD' ,l_bal_date)

Line 2556: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 11');

2552: --
2553:
2554:
2555:
2556: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 11');
2557: l_free_phone_adj := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total Taxable Phone Adjustment','_ASG_PTD' ,l_bal_date);
2558: l_free_phone := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total Taxable Phone Amount','_ASG_PTD' ,l_bal_date)
2559: - l_free_phone_adj;
2560:

Line 2563: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 11.1 Multimedia');

2559: - l_free_phone_adj;
2560:
2561:
2562: /* Bug# 9079593 fix starts */
2563: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 11.1 Multimedia');
2564: l_multimedia_adj := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Multimedia Tax Adjustment','_ASG_PTD' ,l_bal_date);
2565: l_multimedia := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total Multimedia Tax Amount','_ASG_PTD' ,l_bal_date)
2566: - l_multimedia_adj;
2567:

Line 2571: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 11.2 BIK Trivial');

2567:
2568: /* Bug# 9079593 fix ends */
2569:
2570: /* Bug# 9169583 fix starts */
2571: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 11.2 BIK Trivial');
2572: l_trivial_matter_adj := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Trivial Matter BIK Adjustment','_ASG_PTD' ,l_bal_date);
2573: l_trivial_matter := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total Trivial Matter BIK Amount','_ASG_PTD' ,l_bal_date)
2574: - l_trivial_matter_adj;
2575:

Line 2578: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 12');

2574: - l_trivial_matter_adj;
2575:
2576: /* Bug# 9169583 fix ends */
2577: /* moved this to above as a part of bug 10180980
2578: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 12');
2579: l_sp_bonus_adj := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Special Pay Adjustment','_ASG_PTD' ,l_bal_date);
2580: l_sp_bonus := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Special Pay','_ASG_PTD' ,l_bal_date)
2581: - l_sp_bonus_adj;
2582: */

Line 2584: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 13');

2580: l_sp_bonus := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Special Pay','_ASG_PTD' ,l_bal_date)
2581: - l_sp_bonus_adj;
2582: */
2583:
2584: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 13');
2585:
2586: /* 8861878 */
2587: --
2588: l_pension_sev_pay_adj := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Pension Special Bonus Severance Pay Adjustment','_ASG_PTD' ,l_bal_date);

Line 2592: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 14');

2588: l_pension_sev_pay_adj := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Pension Special Bonus Severance Pay Adjustment','_ASG_PTD' ,l_bal_date);
2589: l_pension_sev_pay := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Pension Special Bonus Severance Pay','_ASG_PTD' ,l_bal_date)
2590: - l_pension_sev_pay_adj;
2591:
2592: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 14');
2593:
2594: l_physical_gift_sev_pay_adj := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Physical Gifts and Severance Pay Adjustment','_ASG_PTD' ,l_bal_date);
2595: l_physical_gift_sev_pay := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Physical Gifts and Severance Pay','_ASG_PTD' ,l_bal_date)
2596: - l_physical_gift_sev_pay_adj;

Line 2717: -- fnd_file.put_line(fnd_file.log,'Person name : '||rg_csr_get_person_details.full_name);

2713: ,p_action_information29 => null
2714: ,p_action_information30 => null);
2715: END IF;
2716:
2717: -- fnd_file.put_line(fnd_file.log,'Person name : '||rg_csr_get_person_details.full_name);
2718:
2719: --Record - 6000
2720: /* bug 10367494 archiving p_action_information11 => l_se_no */
2721: pay_action_information_api.create_action_information (

Line 3265: fnd_file.put_line(fnd_file.log,'l_uhc_payroll:'||l_uhc_payroll);

3261: OPEN get_value_from_ddf(l_payroll_id, l_canonical_end_date);
3262: FETCH get_value_from_ddf INTO l_uhc_payroll;
3263: CLOSE get_value_from_ddf;
3264:
3265: fnd_file.put_line(fnd_file.log,'l_uhc_payroll:'||l_uhc_payroll);
3266: fnd_file.put_line(fnd_file.log,'g_end_date:'||g_end_date||'--l_canonical_end_date--'||l_canonical_end_date);
3267:
3268: l_uhc_payroll := NVL(l_uhc_payroll,l_use_holiday_card);
3269:

Line 3266: fnd_file.put_line(fnd_file.log,'g_end_date:'||g_end_date||'--l_canonical_end_date--'||l_canonical_end_date);

3262: FETCH get_value_from_ddf INTO l_uhc_payroll;
3263: CLOSE get_value_from_ddf;
3264:
3265: fnd_file.put_line(fnd_file.log,'l_uhc_payroll:'||l_uhc_payroll);
3266: fnd_file.put_line(fnd_file.log,'g_end_date:'||g_end_date||'--l_canonical_end_date--'||l_canonical_end_date);
3267:
3268: l_uhc_payroll := NVL(l_uhc_payroll,l_use_holiday_card);
3269:
3270: fnd_file.put_line(fnd_file.log,'l_use_holiday_card:'||l_use_holiday_card);

Line 3270: fnd_file.put_line(fnd_file.log,'l_use_holiday_card:'||l_use_holiday_card);

3266: fnd_file.put_line(fnd_file.log,'g_end_date:'||g_end_date||'--l_canonical_end_date--'||l_canonical_end_date);
3267:
3268: l_uhc_payroll := NVL(l_uhc_payroll,l_use_holiday_card);
3269:
3270: fnd_file.put_line(fnd_file.log,'l_use_holiday_card:'||l_use_holiday_card);
3271:
3272: IF (l_use_holiday_card ='N' OR (l_uhc_payroll ='N' AND l_use_holiday_card = 'Y' )) AND l_usr_tbl_exist_400 = 'N' THEN
3273:
3274: l_accr_yr := to_char(l_canonical_end_date,'RRRR');

Line 3285: fnd_file.put_line(fnd_file.log,'l_accr_yr:'||l_accr_yr);

3281: l_curr_entit_yr := l_last_yr;
3282: l_nxt_entit_yr := '0000';
3283: END IF;
3284:
3285: fnd_file.put_line(fnd_file.log,'l_accr_yr:'||l_accr_yr);
3286: fnd_file.put_line(fnd_file.log,'l_last_yr:'||l_last_yr);
3287: fnd_file.put_line(fnd_file.log,'l_curr_entit_yr:'||l_curr_entit_yr);
3288: fnd_file.put_line(fnd_file.log,'l_nxt_entit_yr:'||l_nxt_entit_yr);
3289:

Line 3286: fnd_file.put_line(fnd_file.log,'l_last_yr:'||l_last_yr);

3282: l_nxt_entit_yr := '0000';
3283: END IF;
3284:
3285: fnd_file.put_line(fnd_file.log,'l_accr_yr:'||l_accr_yr);
3286: fnd_file.put_line(fnd_file.log,'l_last_yr:'||l_last_yr);
3287: fnd_file.put_line(fnd_file.log,'l_curr_entit_yr:'||l_curr_entit_yr);
3288: fnd_file.put_line(fnd_file.log,'l_nxt_entit_yr:'||l_nxt_entit_yr);
3289:
3290: OPEN cur_max_asg_act_id(l_assignment_id, l_canonical_start_date, l_canonical_end_date);

Line 3287: fnd_file.put_line(fnd_file.log,'l_curr_entit_yr:'||l_curr_entit_yr);

3283: END IF;
3284:
3285: fnd_file.put_line(fnd_file.log,'l_accr_yr:'||l_accr_yr);
3286: fnd_file.put_line(fnd_file.log,'l_last_yr:'||l_last_yr);
3287: fnd_file.put_line(fnd_file.log,'l_curr_entit_yr:'||l_curr_entit_yr);
3288: fnd_file.put_line(fnd_file.log,'l_nxt_entit_yr:'||l_nxt_entit_yr);
3289:
3290: OPEN cur_max_asg_act_id(l_assignment_id, l_canonical_start_date, l_canonical_end_date);
3291: FETCH cur_max_asg_act_id INTO l_max_asg_act_id;

Line 3288: fnd_file.put_line(fnd_file.log,'l_nxt_entit_yr:'||l_nxt_entit_yr);

3284:
3285: fnd_file.put_line(fnd_file.log,'l_accr_yr:'||l_accr_yr);
3286: fnd_file.put_line(fnd_file.log,'l_last_yr:'||l_last_yr);
3287: fnd_file.put_line(fnd_file.log,'l_curr_entit_yr:'||l_curr_entit_yr);
3288: fnd_file.put_line(fnd_file.log,'l_nxt_entit_yr:'||l_nxt_entit_yr);
3289:
3290: OPEN cur_max_asg_act_id(l_assignment_id, l_canonical_start_date, l_canonical_end_date);
3291: FETCH cur_max_asg_act_id INTO l_max_asg_act_id;
3292: CLOSE cur_max_asg_act_id;

Line 3294: fnd_file.put_line(fnd_file.log,'l_max_asg_act_id:'||l_max_asg_act_id);

3290: OPEN cur_max_asg_act_id(l_assignment_id, l_canonical_start_date, l_canonical_end_date);
3291: FETCH cur_max_asg_act_id INTO l_max_asg_act_id;
3292: CLOSE cur_max_asg_act_id;
3293:
3294: fnd_file.put_line(fnd_file.log,'l_max_asg_act_id:'||l_max_asg_act_id);
3295:
3296: IF l_hourly_salaried='H' THEN
3297:
3298: fnd_file.put_line(fnd_file.log,'Entered l_hourly_salaried=H:');

Line 3298: fnd_file.put_line(fnd_file.log,'Entered l_hourly_salaried=H:');

3294: fnd_file.put_line(fnd_file.log,'l_max_asg_act_id:'||l_max_asg_act_id);
3295:
3296: IF l_hourly_salaried='H' THEN
3297:
3298: fnd_file.put_line(fnd_file.log,'Entered l_hourly_salaried=H:');
3299:
3300: l_hol_pay_0202 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3301: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202:'||l_hol_pay_0202);
3302:

Line 3301: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202:'||l_hol_pay_0202);

3297:
3298: fnd_file.put_line(fnd_file.log,'Entered l_hourly_salaried=H:');
3299:
3300: l_hol_pay_0202 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3301: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202:'||l_hol_pay_0202);
3302:
3303: l_hol_pay_0202_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3304: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202_tax:'||l_hol_pay_0202_tax);
3305:

Line 3304: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202_tax:'||l_hol_pay_0202_tax);

3300: l_hol_pay_0202 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Pay','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3301: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202:'||l_hol_pay_0202);
3302:
3303: l_hol_pay_0202_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3304: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202_tax:'||l_hol_pay_0202_tax);
3305:
3306: l_hol_pay_0202_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3307: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202_amb:'||l_hol_pay_0202_amb);
3308:

Line 3307: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202_amb:'||l_hol_pay_0202_amb);

3303: l_hol_pay_0202_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3304: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202_tax:'||l_hol_pay_0202_tax);
3305:
3306: l_hol_pay_0202_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3307: fnd_file.put_line(fnd_file.log,'l_hol_pay_0202_amb:'||l_hol_pay_0202_amb);
3308:
3309: --l_hol_pay_0202_sp := NVL(GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Hourly Holiday SP','_PAYMENTS' ,l_bal_date),0);
3310:
3311: l_net_hol_pay_0202 := l_hol_pay_0202 - (l_hol_pay_0202_tax + l_hol_pay_0202_amb );

Line 3312: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_0202:'||l_net_hol_pay_0202);

3308:
3309: --l_hol_pay_0202_sp := NVL(GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Hourly Holiday SP','_PAYMENTS' ,l_bal_date),0);
3310:
3311: l_net_hol_pay_0202 := l_hol_pay_0202 - (l_hol_pay_0202_tax + l_hol_pay_0202_amb );
3312: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_0202:'||l_net_hol_pay_0202);
3313:
3314: IF l_net_hol_pay_0202 <> 0 THEN
3315: REC_6001(rg_csr_get_person_details.PERSON_ID, rg_csr_get_person_details.assignment_ID,'0202',abs(l_net_hol_pay_0202)*1000000,SIGN(l_net_hol_pay_0202),'N',
3316: l_payroll_id,l_employment_type,l_period_id,l_green_land_code,l_se_no);

Line 3320: fnd_file.put_line(fnd_file.log,'Entered l_hourly_salaried=S:');

3316: l_payroll_id,l_employment_type,l_period_id,l_green_land_code,l_se_no);
3317: END IF;
3318: ELSIF l_hourly_salaried='S' THEN
3319:
3320: fnd_file.put_line(fnd_file.log,'Entered l_hourly_salaried=S:');
3321:
3322: l_sal_hol_acr_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3323: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amt:'||l_sal_hol_acr_amt);
3324:

Line 3323: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amt:'||l_sal_hol_acr_amt);

3319:
3320: fnd_file.put_line(fnd_file.log,'Entered l_hourly_salaried=S:');
3321:
3322: l_sal_hol_acr_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3323: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amt:'||l_sal_hol_acr_amt);
3324:
3325: l_sal_hol_acr_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3326: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_tax:'||l_sal_hol_acr_tax);
3327:

Line 3326: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_tax:'||l_sal_hol_acr_tax);

3322: l_sal_hol_acr_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3323: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amt:'||l_sal_hol_acr_amt);
3324:
3325: l_sal_hol_acr_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3326: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_tax:'||l_sal_hol_acr_tax);
3327:
3328: l_sal_hol_acr_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3329: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amb:'||l_sal_hol_acr_amb);
3330:

Line 3329: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amb:'||l_sal_hol_acr_amb);

3325: l_sal_hol_acr_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3326: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_tax:'||l_sal_hol_acr_tax);
3327:
3328: l_sal_hol_acr_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3329: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amb:'||l_sal_hol_acr_amb);
3330:
3331: l_sal_hol_acr_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3332: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_days:'||l_sal_hol_acr_days);
3333:

Line 3332: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_days:'||l_sal_hol_acr_days);

3328: l_sal_hol_acr_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3329: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_amb:'||l_sal_hol_acr_amb);
3330:
3331: l_sal_hol_acr_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Accrual Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3332: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_days:'||l_sal_hol_acr_days);
3333:
3334: -- l_net_hol_pay_6102_1 := l_sal_hol_acr_amt - (l_sal_hol_acr_tax + l_sal_hol_acr_amb); --13630274
3335: l_net_hol_pay_6102_1 := l_sal_hol_acr_amt ;
3336: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_6102_1:'||l_net_hol_pay_6102_1);

Line 3336: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_6102_1:'||l_net_hol_pay_6102_1);

3332: fnd_file.put_line(fnd_file.log,'l_sal_hol_acr_days:'||l_sal_hol_acr_days);
3333:
3334: -- l_net_hol_pay_6102_1 := l_sal_hol_acr_amt - (l_sal_hol_acr_tax + l_sal_hol_acr_amb); --13630274
3335: l_net_hol_pay_6102_1 := l_sal_hol_acr_amt ;
3336: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_6102_1:'||l_net_hol_pay_6102_1);
3337: IF l_net_hol_pay_6102_1 < 0 THEN
3338: l_sign_net_hol_pay_6102_1 := '-';
3339: ELSE
3340: l_sign_net_hol_pay_6102_1 := '+';

Line 3346: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amt:'||l_sal_hol_cur_ent_amt);

3342:
3343: l_no_of_hol_6102_1 := l_sal_hol_acr_days;
3344:
3345: l_sal_hol_cur_ent_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3346: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amt:'||l_sal_hol_cur_ent_amt);
3347:
3348: l_sal_hol_cur_ent_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3349: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_tax:'||l_sal_hol_cur_ent_tax);
3350:

Line 3349: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_tax:'||l_sal_hol_cur_ent_tax);

3345: l_sal_hol_cur_ent_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3346: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amt:'||l_sal_hol_cur_ent_amt);
3347:
3348: l_sal_hol_cur_ent_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3349: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_tax:'||l_sal_hol_cur_ent_tax);
3350:
3351: l_sal_hol_cur_ent_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3352: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amb:'||l_sal_hol_cur_ent_amb);
3353:

Line 3352: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amb:'||l_sal_hol_cur_ent_amb);

3348: l_sal_hol_cur_ent_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3349: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_tax:'||l_sal_hol_cur_ent_tax);
3350:
3351: l_sal_hol_cur_ent_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3352: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amb:'||l_sal_hol_cur_ent_amb);
3353:
3354: l_sal_hol_cur_ent_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3355: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_days:'||l_sal_hol_cur_ent_days);
3356:

Line 3355: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_days:'||l_sal_hol_cur_ent_days);

3351: l_sal_hol_cur_ent_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3352: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_amb:'||l_sal_hol_cur_ent_amb);
3353:
3354: l_sal_hol_cur_ent_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Curr Entit Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3355: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_days:'||l_sal_hol_cur_ent_days);
3356:
3357: -- l_net_hol_pay_6102_2 := l_sal_hol_cur_ent_amt - (l_sal_hol_cur_ent_tax + l_sal_hol_cur_ent_amb); --13630274
3358: l_net_hol_pay_6102_2 := l_sal_hol_cur_ent_amt;
3359: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_6102_2:'||l_net_hol_pay_6102_2);

Line 3359: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_6102_2:'||l_net_hol_pay_6102_2);

3355: fnd_file.put_line(fnd_file.log,'l_sal_hol_cur_ent_days:'||l_sal_hol_cur_ent_days);
3356:
3357: -- l_net_hol_pay_6102_2 := l_sal_hol_cur_ent_amt - (l_sal_hol_cur_ent_tax + l_sal_hol_cur_ent_amb); --13630274
3358: l_net_hol_pay_6102_2 := l_sal_hol_cur_ent_amt;
3359: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_6102_2:'||l_net_hol_pay_6102_2);
3360: IF l_net_hol_pay_6102_2 < 0 THEN
3361: l_sign_net_hol_pay_6102_2 := '-';
3362: ELSE
3363: l_sign_net_hol_pay_6102_2 := '+';

Line 3369: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amt:'||l_sal_hol_nxt_ent_amt);

3365:
3366: l_no_of_hol_6102_2 := l_sal_hol_cur_ent_days;
3367:
3368: l_sal_hol_nxt_ent_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3369: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amt:'||l_sal_hol_nxt_ent_amt);
3370:
3371: l_sal_hol_nxt_ent_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3372: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_tax:'||l_sal_hol_nxt_ent_tax);
3373:

Line 3372: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_tax:'||l_sal_hol_nxt_ent_tax);

3368: l_sal_hol_nxt_ent_amt := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Amount','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3369: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amt:'||l_sal_hol_nxt_ent_amt);
3370:
3371: l_sal_hol_nxt_ent_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3372: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_tax:'||l_sal_hol_nxt_ent_tax);
3373:
3374: l_sal_hol_nxt_ent_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3375: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amb:'||l_sal_hol_nxt_ent_amb);
3376:

Line 3375: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amb:'||l_sal_hol_nxt_ent_amb);

3371: l_sal_hol_nxt_ent_tax := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Tax','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3372: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_tax:'||l_sal_hol_nxt_ent_tax);
3373:
3374: l_sal_hol_nxt_ent_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3375: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amb:'||l_sal_hol_nxt_ent_amb);
3376:
3377: l_sal_hol_nxt_ent_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3378: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_days:'||l_sal_hol_nxt_ent_days);
3379:

Line 3378: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_days:'||l_sal_hol_nxt_ent_days);

3374: l_sal_hol_nxt_ent_amb := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit AMB','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3375: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_amb:'||l_sal_hol_nxt_ent_amb);
3376:
3377: l_sal_hol_nxt_ent_days := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Salaried Hol Next Entit Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3378: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_days:'||l_sal_hol_nxt_ent_days);
3379:
3380: -- l_net_hol_pay_6102_3 := l_sal_hol_nxt_ent_amt - (l_sal_hol_nxt_ent_tax + l_sal_hol_nxt_ent_amb); --13630274
3381: l_net_hol_pay_6102_3 := l_sal_hol_nxt_ent_amt;
3382: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_6102_3:'||l_net_hol_pay_6102_3);

Line 3382: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_6102_3:'||l_net_hol_pay_6102_3);

3378: fnd_file.put_line(fnd_file.log,'l_sal_hol_nxt_ent_days:'||l_sal_hol_nxt_ent_days);
3379:
3380: -- l_net_hol_pay_6102_3 := l_sal_hol_nxt_ent_amt - (l_sal_hol_nxt_ent_tax + l_sal_hol_nxt_ent_amb); --13630274
3381: l_net_hol_pay_6102_3 := l_sal_hol_nxt_ent_amt;
3382: fnd_file.put_line(fnd_file.log,'l_net_hol_pay_6102_3:'||l_net_hol_pay_6102_3);
3383: IF l_net_hol_pay_6102_3 < 0 THEN
3384: l_sign_net_hol_pay_6102_3 := '-';
3385: ELSE
3386: l_sign_net_hol_pay_6102_3 := '+';

Line 3428: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15');

3424:
3425:
3426:
3427:
3428: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15');
3429: --
3430:
3431:
3432: IF (l_yes_no='N' and l_stationed_abroad = 'N') THEN /* Employee is not a foreigner */

Line 3474: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 16: Inserted 6002');

3470: ,p_action_information27 => l_green_land_code /* 8847591 */
3471: ,p_action_information28 => null
3472: ,p_action_information29 => null
3473: ,p_action_information30 => null);
3474: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 16: Inserted 6002');
3475: END IF; -- kknadhan end
3476:
3477: IF rg_csr_asg_extra_info.aei_information1='Y' THEN
3478: pay_action_information_api.create_action_information (

Line 3517: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 17: Inserted 6003');

3513: ,p_action_information27 => l_green_land_code /* 8847591 */
3514: ,p_action_information28 => null
3515: ,p_action_information29 => null
3516: ,p_action_information30 => null);
3517: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 17: Inserted 6003');
3518: END IF;
3519:
3520:
3521: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 14');

Line 3521: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 14');

3517: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 17: Inserted 6003');
3518: END IF;
3519:
3520:
3521: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 14');
3522: --Record - 6004
3523: IF (l_total_atp <> 0) THEN
3524: pay_action_information_api.create_action_information (
3525: p_action_information_id => l_action_info_id

Line 3563: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 18: Inserted 6004');

3559: ,p_action_information27 => l_green_land_code /* 8847591 */
3560: ,p_action_information28 => null
3561: ,p_action_information29 => null
3562: ,p_action_information30 => null);
3563: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 18: Inserted 6004');
3564: END IF; --15965781
3565:
3566: l_total_atp_hours := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total ATP Hours','_ASG_PTD' ,l_bal_date);
3567: l_total_atp_hours := ROUND(l_total_atp_hours,2); -- rounding to 2 decimals

Line 3569: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15');

3565:
3566: l_total_atp_hours := GET_DEFINED_BALANCE_VALUE(l_assignment_id, 'Total ATP Hours','_ASG_PTD' ,l_bal_date);
3567: l_total_atp_hours := ROUND(l_total_atp_hours,2); -- rounding to 2 decimals
3568:
3569: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15');
3570: --Record - 6005
3571: pay_action_information_api.create_action_information (
3572: p_action_information_id => l_action_info_id
3573: ,p_action_context_id => p_assignment_action_id

Line 3610: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 19: Inserted 6005');

3606: ,p_action_information27 => l_green_land_code /* 8847591 */
3607: ,p_action_information28 => null
3608: ,p_action_information29 => null
3609: ,p_action_information30 => null);
3610: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 19: Inserted 6005');
3611: --END IF; --15965781
3612: --13463885
3613: IF (l_use_holiday_card ='N' OR (l_uhc_payroll ='N' AND l_use_holiday_card = 'Y' )) AND l_usr_tbl_exist_400 = 'N' THEN
3614: IF l_hourly_salaried='H' THEN

Line 3617: fnd_file.put_line(fnd_file.log,'l_no_of_hol_6005_0203 :'||l_no_of_hol_6005_0203);

3613: IF (l_use_holiday_card ='N' OR (l_uhc_payroll ='N' AND l_use_holiday_card = 'Y' )) AND l_usr_tbl_exist_400 = 'N' THEN
3614: IF l_hourly_salaried='H' THEN
3615:
3616: l_no_of_hol_6005_0203 := NVL(pay_balance_pkg.get_value(get_defined_balance_id('Hourly Holiday Days','_PAYMENTS'),l_max_asg_act_id,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'TRUE'),0);
3617: fnd_file.put_line(fnd_file.log,'l_no_of_hol_6005_0203 :'||l_no_of_hol_6005_0203);
3618:
3619: IF l_no_of_hol_6005_0203 <> 0 THEN
3620:
3621:

Line 3622: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-1');

3618:
3619: IF l_no_of_hol_6005_0203 <> 0 THEN
3620:
3621:
3622: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-1');
3623: --Record - 6005
3624: pay_action_information_api.create_action_information (
3625: p_action_information_id => l_action_info_id
3626: ,p_action_context_id => p_assignment_action_id

Line 3664: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 19-1: Inserted 6005:0203');

3660: ,p_action_information28 => null
3661: ,p_action_information29 => null
3662: ,p_action_information30 => null);
3663:
3664: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 19-1: Inserted 6005:0203');
3665:
3666: END IF;
3667: END IF;
3668: END IF;

Line 3675: --fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-1');

3671: END IF; --l_present_flag
3672: --13463885
3673: IF (l_use_holiday_card ='N' OR (l_uhc_payroll ='N' AND l_use_holiday_card = 'Y' )) AND l_usr_tbl_exist_400 = 'N' THEN
3674: IF l_hourly_salaried='S' AND l_net_hol_pay_6102_1 <> 0 THEN
3675: --fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-1');
3676:
3677: --Record - 6102
3678: pay_action_information_api.create_action_information (
3679: p_action_information_id => l_action_info_id

Line 3717: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 20: Inserted 6102-1');

3713: ,p_action_information27 => l_green_land_code /* 8847591 */
3714: ,p_action_information28 => null
3715: ,p_action_information29 => null
3716: ,p_action_information30 => null);
3717: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 20: Inserted 6102-1');
3718: END IF;
3719:
3720: IF l_hourly_salaried='S' AND l_net_hol_pay_6102_2 <> 0 THEN
3721: --fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-2');

Line 3721: --fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-2');

3717: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 20: Inserted 6102-1');
3718: END IF;
3719:
3720: IF l_hourly_salaried='S' AND l_net_hol_pay_6102_2 <> 0 THEN
3721: --fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-2');
3722:
3723: --Record - 6102
3724: pay_action_information_api.create_action_information (
3725: p_action_information_id => l_action_info_id

Line 3763: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 20: Inserted 6102-2');

3759: ,p_action_information27 => l_green_land_code /* 8847591 */
3760: ,p_action_information28 => null
3761: ,p_action_information29 => null
3762: ,p_action_information30 => null);
3763: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 20: Inserted 6102-2');
3764: END IF;
3765:
3766: IF l_hourly_salaried='S' AND l_net_hol_pay_6102_3 <> 0 THEN
3767: --fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-3');

Line 3767: --fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-3');

3763: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 20: Inserted 6102-2');
3764: END IF;
3765:
3766: IF l_hourly_salaried='S' AND l_net_hol_pay_6102_3 <> 0 THEN
3767: --fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 15-3');
3768:
3769: --Record - 6102
3770: pay_action_information_api.create_action_information (
3771: p_action_information_id => l_action_info_id

Line 3809: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 20: Inserted 6102-3');

3805: ,p_action_information27 => l_green_land_code /* 8847591 */
3806: ,p_action_information28 => null
3807: ,p_action_information29 => null
3808: ,p_action_information30 => null);
3809: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 20: Inserted 6102-3');
3810: END IF;
3811:
3812: END IF;
3813: --13463885

Line 3818: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 16');

3814: END LOOP;
3815: end if; -- end company terminating check condition.
3816: end if; -- g_flag
3817:
3818: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 16');
3819: IF g_debug THEN
3820: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
3821: END IF;
3822:

Line 3823: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE END');

3819: IF g_debug THEN
3820: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
3821: END IF;
3822:
3823: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE END');
3824:
3825: EXCEPTION
3826: WHEN others THEN
3827: IF g_debug THEN

Line 3990: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 1');

3986:
3987: BEGIN
3988: l_end_code:=0 ;
3989: if(g_flag=0) then
3990: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 1');
3991:
3992: FOR rg_csr_all_rec_2001 IN csr_all_rec_2001( p_payroll_action_id)
3993: LOOP
3994: IF rg_csr_all_rec_2001.action_information3 in ('1000') THEN

Line 3996: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 2');

3992: FOR rg_csr_all_rec_2001 IN csr_all_rec_2001( p_payroll_action_id)
3993: LOOP
3994: IF rg_csr_all_rec_2001.action_information3 in ('1000') THEN
3995: l_end_code:=l_end_code + 1 ;
3996: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 2');
3997:
3998: UPDATE pay_action_information pai
3999: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4000: WHERE CURRENT OF csr_all_rec_2001;

Line 4004: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 3');

4000: WHERE CURRENT OF csr_all_rec_2001;
4001:
4002: END IF;
4003:
4004: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 3');
4005: fnd_file.put_line(fnd_file.log,'payroll action id:'||p_payroll_action_id);
4006: fnd_file.put_line(fnd_file.log,'action info 4:'||rg_csr_all_rec_2001.action_information4);
4007: hr_utility.set_location('DEINIT:rg_csr_all_rec.action_information3: ' || rg_csr_all_rec_2001.action_information3,390);
4008: hr_utility.set_location('DEINIT:rg_csr_all_rec.action_information25: ' || rg_csr_all_rec_2001.action_information25,390);

Line 4005: fnd_file.put_line(fnd_file.log,'payroll action id:'||p_payroll_action_id);

4001:
4002: END IF;
4003:
4004: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 3');
4005: fnd_file.put_line(fnd_file.log,'payroll action id:'||p_payroll_action_id);
4006: fnd_file.put_line(fnd_file.log,'action info 4:'||rg_csr_all_rec_2001.action_information4);
4007: hr_utility.set_location('DEINIT:rg_csr_all_rec.action_information3: ' || rg_csr_all_rec_2001.action_information3,390);
4008: hr_utility.set_location('DEINIT:rg_csr_all_rec.action_information25: ' || rg_csr_all_rec_2001.action_information25,390);
4009: IF rg_csr_all_rec_2001.action_information3='2001' THEN

Line 4006: fnd_file.put_line(fnd_file.log,'action info 4:'||rg_csr_all_rec_2001.action_information4);

4002: END IF;
4003:
4004: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 3');
4005: fnd_file.put_line(fnd_file.log,'payroll action id:'||p_payroll_action_id);
4006: fnd_file.put_line(fnd_file.log,'action info 4:'||rg_csr_all_rec_2001.action_information4);
4007: hr_utility.set_location('DEINIT:rg_csr_all_rec.action_information3: ' || rg_csr_all_rec_2001.action_information3,390);
4008: hr_utility.set_location('DEINIT:rg_csr_all_rec.action_information25: ' || rg_csr_all_rec_2001.action_information25,390);
4009: IF rg_csr_all_rec_2001.action_information3='2001' THEN
4010: l_end_code:=l_end_code + 1 ;

Line 4047: fnd_file.put_line(fnd_file.log,'l_foreign_flag :'|| l_foreign_flag);

4043: hr_utility.set_location('DEINIT:entered csr_all_rec_6000: ' || rg_csr_all_rec_6000.action_information4,390);
4044: /* bug 7613211 start*/
4045: /* 9001660 */
4046: l_6000_count:=l_6000_count+1;
4047: fnd_file.put_line(fnd_file.log,'l_foreign_flag :'|| l_foreign_flag);
4048: FOR rg_csr_asg_8001 IN csr_asg_8001( p_payroll_action_id,to_number(rg_csr_all_rec_6000.action_information4),rg_csr_all_rec.action_information25
4049: ,rg_csr_all_rec.action_information9,rg_csr_all_rec.action_information24,rg_csr_all_rec.action_information8)
4050: LOOP
4051: l_end_code:=l_end_code + 1 ;

Line 4055: fnd_file.put_line(fnd_file.log,'rg_csr_all_rec_6000.action_information7:'|| rg_csr_all_rec_6000.action_information7);

4051: l_end_code:=l_end_code + 1 ;
4052: UPDATE pay_action_information pai
4053: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4054: WHERE CURRENT OF csr_asg_8001;
4055: fnd_file.put_line(fnd_file.log,'rg_csr_all_rec_6000.action_information7:'|| rg_csr_all_rec_6000.action_information7);
4056:
4057: /* 9001660 */
4058: l_foreign_count:=l_foreign_count+1;
4059: IF rg_csr_all_rec_6000.action_information7='0000000000' THEN

Line 4062: fnd_file.put_line(fnd_file.log,'l_foreign_flag :'|| l_foreign_flag);

4058: l_foreign_count:=l_foreign_count+1;
4059: IF rg_csr_all_rec_6000.action_information7='0000000000' THEN
4060: l_foreign_flag:='Y';
4061: END IF;
4062: fnd_file.put_line(fnd_file.log,'l_foreign_flag :'|| l_foreign_flag);
4063: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 4');
4064: END LOOP;
4065: /* bug 7613211 end*/
4066:

Line 4063: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 4');

4059: IF rg_csr_all_rec_6000.action_information7='0000000000' THEN
4060: l_foreign_flag:='Y';
4061: END IF;
4062: fnd_file.put_line(fnd_file.log,'l_foreign_flag :'|| l_foreign_flag);
4063: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 4');
4064: END LOOP;
4065: /* bug 7613211 end*/
4066:
4067: FOR rg_csr_asg_all_rec IN csr_asg_all_rec( p_payroll_action_id,to_number(rg_csr_all_rec_6000.action_information4),rg_csr_all_rec.action_information25

Line 4074: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 4');

4070: l_end_code:=l_end_code + 1 ;
4071: UPDATE pay_action_information pai
4072: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4073: WHERE CURRENT OF csr_asg_all_rec;
4074: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 4');
4075:
4076: IF (rg_csr_asg_all_rec.action_information6='0038' or rg_csr_asg_all_rec.action_information6='0036') and rg_csr_asg_all_rec.action_information3='6001' THEN /* 8616718 */
4077: l_bincome_flag:='Y';
4078: ELSIF rg_csr_asg_all_rec.action_information3='6001' and rg_csr_asg_all_rec.action_information6 <> '0016' THEN /* 8861878 */

Line 4081: fnd_file.put_line(fnd_file.log,'Pay Type code :'|| rg_csr_asg_all_rec.action_information6);

4077: l_bincome_flag:='Y';
4078: ELSIF rg_csr_asg_all_rec.action_information3='6001' and rg_csr_asg_all_rec.action_information6 <> '0016' THEN /* 8861878 */
4079: l_other_flag:='Y';
4080: END IF;
4081: fnd_file.put_line(fnd_file.log,'Pay Type code :'|| rg_csr_asg_all_rec.action_information6);
4082: fnd_file.put_line(fnd_file.log,'l_bincome_flag'|| l_bincome_flag);
4083: fnd_file.put_line(fnd_file.log,'l_other_flag'|| l_other_flag);
4084:
4085:

Line 4082: fnd_file.put_line(fnd_file.log,'l_bincome_flag'|| l_bincome_flag);

4078: ELSIF rg_csr_asg_all_rec.action_information3='6001' and rg_csr_asg_all_rec.action_information6 <> '0016' THEN /* 8861878 */
4079: l_other_flag:='Y';
4080: END IF;
4081: fnd_file.put_line(fnd_file.log,'Pay Type code :'|| rg_csr_asg_all_rec.action_information6);
4082: fnd_file.put_line(fnd_file.log,'l_bincome_flag'|| l_bincome_flag);
4083: fnd_file.put_line(fnd_file.log,'l_other_flag'|| l_other_flag);
4084:
4085:
4086: END LOOP;

Line 4083: fnd_file.put_line(fnd_file.log,'l_other_flag'|| l_other_flag);

4079: l_other_flag:='Y';
4080: END IF;
4081: fnd_file.put_line(fnd_file.log,'Pay Type code :'|| rg_csr_asg_all_rec.action_information6);
4082: fnd_file.put_line(fnd_file.log,'l_bincome_flag'|| l_bincome_flag);
4083: fnd_file.put_line(fnd_file.log,'l_other_flag'|| l_other_flag);
4084:
4085:
4086: END LOOP;
4087: END LOOP; -- record 6000 loop

Line 4089: fnd_file.put_line(fnd_file.log,'before correctl_bincome_flag'|| l_bincome_flag);

4085:
4086: END LOOP;
4087: END LOOP; -- record 6000 loop
4088: /* 8616718 */
4089: fnd_file.put_line(fnd_file.log,'before correctl_bincome_flag'|| l_bincome_flag);
4090: fnd_file.put_line(fnd_file.log,'before correct l_other_flag'|| l_other_flag);
4091: l_5000R_updated:='N';
4092: FOR rg_csr_all_rec_6000 IN csr_all_rec_6000R(p_payroll_action_id,rg_csr_all_rec.action_information25,rg_csr_all_rec.action_information9,rg_csr_all_rec.action_information24,rg_csr_all_rec.action_information8,rg_csr_all_rec_2001.action_information4)
4093: LOOP

Line 4090: fnd_file.put_line(fnd_file.log,'before correct l_other_flag'|| l_other_flag);

4086: END LOOP;
4087: END LOOP; -- record 6000 loop
4088: /* 8616718 */
4089: fnd_file.put_line(fnd_file.log,'before correctl_bincome_flag'|| l_bincome_flag);
4090: fnd_file.put_line(fnd_file.log,'before correct l_other_flag'|| l_other_flag);
4091: l_5000R_updated:='N';
4092: FOR rg_csr_all_rec_6000 IN csr_all_rec_6000R(p_payroll_action_id,rg_csr_all_rec.action_information25,rg_csr_all_rec.action_information9,rg_csr_all_rec.action_information24,rg_csr_all_rec.action_information8,rg_csr_all_rec_2001.action_information4)
4093: LOOP
4094: l_6000R_updated:='N'; /* 9587046R */

Line 4098: fnd_file.put_line(fnd_file.log,'before payroll_id'|| rg_csr_all_rec.action_information25);

4094: l_6000R_updated:='N'; /* 9587046R */
4095: FOR rg_csr_asg_all_rec IN csr_asg_all_rec_corr( p_payroll_action_id,to_number(rg_csr_all_rec_6000.action_information4),rg_csr_all_rec.action_information25
4096: ,rg_csr_all_rec.action_information9,rg_csr_all_rec.action_information24,rg_csr_all_rec.action_information8) /* 8847591 */
4097: LOOP
4098: fnd_file.put_line(fnd_file.log,'before payroll_id'|| rg_csr_all_rec.action_information25);
4099: fnd_file.put_line(fnd_file.log,'before time period id '|| rg_csr_all_rec.action_information24);
4100: IF l_5000R_updated='N' THEN
4101: fnd_file.put_line(fnd_file.log,'entered iff l_5000R_updated');
4102: l_end_code:=l_end_code + 1 ;

Line 4099: fnd_file.put_line(fnd_file.log,'before time period id '|| rg_csr_all_rec.action_information24);

4095: FOR rg_csr_asg_all_rec IN csr_asg_all_rec_corr( p_payroll_action_id,to_number(rg_csr_all_rec_6000.action_information4),rg_csr_all_rec.action_information25
4096: ,rg_csr_all_rec.action_information9,rg_csr_all_rec.action_information24,rg_csr_all_rec.action_information8) /* 8847591 */
4097: LOOP
4098: fnd_file.put_line(fnd_file.log,'before payroll_id'|| rg_csr_all_rec.action_information25);
4099: fnd_file.put_line(fnd_file.log,'before time period id '|| rg_csr_all_rec.action_information24);
4100: IF l_5000R_updated='N' THEN
4101: fnd_file.put_line(fnd_file.log,'entered iff l_5000R_updated');
4102: l_end_code:=l_end_code + 1 ;
4103: UPDATE pay_action_information pai

Line 4101: fnd_file.put_line(fnd_file.log,'entered iff l_5000R_updated');

4097: LOOP
4098: fnd_file.put_line(fnd_file.log,'before payroll_id'|| rg_csr_all_rec.action_information25);
4099: fnd_file.put_line(fnd_file.log,'before time period id '|| rg_csr_all_rec.action_information24);
4100: IF l_5000R_updated='N' THEN
4101: fnd_file.put_line(fnd_file.log,'entered iff l_5000R_updated');
4102: l_end_code:=l_end_code + 1 ;
4103: UPDATE pay_action_information pai
4104: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4105: WHERE pai.action_information3 = '5000R'

Line 4139: fnd_file.put_line(fnd_file.log,'l_5000R_updated'|| l_5000R_updated);

4135: WHERE CURRENT OF csr_asg_8001R;
4136: END LOOP;
4137:
4138: END IF;
4139: fnd_file.put_line(fnd_file.log,'l_5000R_updated'|| l_5000R_updated);
4140: l_end_code:=l_end_code + 1 ;
4141: UPDATE pay_action_information pai
4142: SET pai.action_information30 =LPAD(l_end_code,7,'0')
4143: WHERE CURRENT OF csr_asg_all_rec_corr;

Line 4150: fnd_file.put_line(fnd_file.log,'Pay Type code in corrected record :'|| rg_csr_asg_all_rec.action_information6);

4146: l_bincome_flag:='Y';
4147: ELSIF rg_csr_asg_all_rec.action_information3='6001' and rg_csr_asg_all_rec.action_information6 <> '0016' THEN /* 8861878 */
4148: l_other_flag:='Y';
4149: END IF;
4150: fnd_file.put_line(fnd_file.log,'Pay Type code in corrected record :'|| rg_csr_asg_all_rec.action_information6);
4151:
4152: END LOOP;
4153: fnd_file.put_line(fnd_file.log,'after correctl_bincome_flag'|| l_bincome_flag);
4154: fnd_file.put_line(fnd_file.log,'after correct l_other_flag'|| l_other_flag);

Line 4153: fnd_file.put_line(fnd_file.log,'after correctl_bincome_flag'|| l_bincome_flag);

4149: END IF;
4150: fnd_file.put_line(fnd_file.log,'Pay Type code in corrected record :'|| rg_csr_asg_all_rec.action_information6);
4151:
4152: END LOOP;
4153: fnd_file.put_line(fnd_file.log,'after correctl_bincome_flag'|| l_bincome_flag);
4154: fnd_file.put_line(fnd_file.log,'after correct l_other_flag'|| l_other_flag);
4155: END LOOP; -- for 5000
4156: -- END IF;
4157: end loop ;

Line 4154: fnd_file.put_line(fnd_file.log,'after correct l_other_flag'|| l_other_flag);

4150: fnd_file.put_line(fnd_file.log,'Pay Type code in corrected record :'|| rg_csr_asg_all_rec.action_information6);
4151:
4152: END LOOP;
4153: fnd_file.put_line(fnd_file.log,'after correctl_bincome_flag'|| l_bincome_flag);
4154: fnd_file.put_line(fnd_file.log,'after correct l_other_flag'|| l_other_flag);
4155: END LOOP; -- for 5000
4156: -- END IF;
4157: end loop ;
4158: end if; /* 10367494 */

Line 4159: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 5');

4155: END LOOP; -- for 5000
4156: -- END IF;
4157: end loop ;
4158: end if; /* 10367494 */
4159: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 5');
4160: END LOOP;
4161: l_end_code:=l_end_code + 1 ;
4162: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 6');
4163: /* 9001660 */

Line 4162: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 6');

4158: end if; /* 10367494 */
4159: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 5');
4160: END LOOP;
4161: l_end_code:=l_end_code + 1 ;
4162: fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 6');
4163: /* 9001660 */
4164: IF l_foreign_flag='Y' THEN
4165: /*
4166: UPDATE pay_action_information pai

Line 4174: fnd_file.put_line(fnd_file.log,'l_foreign_count :'||l_foreign_count);

4170: AND pai.action_information2 = to_char(p_payroll_action_id)
4171: AND pai.action_information3 ='5000'; */
4172:
4173: --
4174: fnd_file.put_line(fnd_file.log,'l_foreign_count :'||l_foreign_count);
4175: fnd_file.put_line(fnd_file.log,'l_6000_count :'|| l_6000_count);
4176: IF l_foreign_count<>l_6000_count THEN
4177: -- Raise l_bincome_exception;
4178: NULL;

Line 4175: fnd_file.put_line(fnd_file.log,'l_6000_count :'|| l_6000_count);

4171: AND pai.action_information3 ='5000'; */
4172:
4173: --
4174: fnd_file.put_line(fnd_file.log,'l_foreign_count :'||l_foreign_count);
4175: fnd_file.put_line(fnd_file.log,'l_6000_count :'|| l_6000_count);
4176: IF l_foreign_count<>l_6000_count THEN
4177: -- Raise l_bincome_exception;
4178: NULL;
4179: END IF;

Line 4239: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 7');

4235: p_action_information30=> LPAD(l_end_code,7,'0')
4236: );
4237:
4238: end if; -- g_flag
4239: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 7');
4240: IF g_debug THEN
4241: hr_utility.set_location(' Leaving Procedure DEINITIALIZATION_CODE',390);
4242: END IF;
4243:

Line 4244: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 8');

4240: IF g_debug THEN
4241: hr_utility.set_location(' Leaving Procedure DEINITIALIZATION_CODE',390);
4242: END IF;
4243:
4244: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 8');
4245: EXCEPTION
4246: WHEN l_bincome_exception THEN
4247: /* 9001660 */
4248: /* fnd_file.put_line(fnd_file.log,'Error raised in DEINITIALIZATION_CODE : The Payroll used for processing normal employees must not be used for processing employees with only B income.

Line 4248: /* fnd_file.put_line(fnd_file.log,'Error raised in DEINITIALIZATION_CODE : The Payroll used for processing normal employees must not be used for processing employees with only B income.

4244: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 8');
4245: EXCEPTION
4246: WHEN l_bincome_exception THEN
4247: /* 9001660 */
4248: /* fnd_file.put_line(fnd_file.log,'Error raised in DEINITIALIZATION_CODE : The Payroll used for processing normal employees must not be used for processing employees with only B income.
4249: Please process the employees with only B Income on a different Payroll.');
4250: */
4251: fnd_file.put_line(fnd_file.log,'Error raised in DEINITIALIZATION_CODE :'|| fnd_message.get_string('PER','HR_377071_DK_FORIEGN_BINCOME'));
4252: RAISE;

Line 4251: fnd_file.put_line(fnd_file.log,'Error raised in DEINITIALIZATION_CODE :'|| fnd_message.get_string('PER','HR_377071_DK_FORIEGN_BINCOME'));

4247: /* 9001660 */
4248: /* fnd_file.put_line(fnd_file.log,'Error raised in DEINITIALIZATION_CODE : The Payroll used for processing normal employees must not be used for processing employees with only B income.
4249: Please process the employees with only B Income on a different Payroll.');
4250: */
4251: fnd_file.put_line(fnd_file.log,'Error raised in DEINITIALIZATION_CODE :'|| fnd_message.get_string('PER','HR_377071_DK_FORIEGN_BINCOME'));
4252: RAISE;
4253: WHEN others THEN
4254: IF g_debug THEN
4255: hr_utility.set_location('error raised in DEINITIALIZATION_CODE ',5);