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

Line 1763: -- --fnd_file.put_line(fnd_file.log,'Entering ' || l_proc);

1759: where ppa.payroll_action_id = paa.payroll_action_id
1760: and paa.assignment_id = p_assignment_id;
1761: begin
1762: hr_utility.set_location('Entering ' || l_proc,10);
1763: -- --fnd_file.put_line(fnd_file.log,'Entering ' || l_proc);
1764:
1765: --
1766: -- Fetch the effective_date
1767: --

Line 2672: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

2668: -- warn user in log : assignment ends before payroll period end date
2669: --
2670: fnd_message.set_name('PAY','PAY_75024_PTO_ACC_PERIOD');
2671: fnd_message.set_token('ASG_NO', l_assignment_number);
2672: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
2673: ELSE
2674: --
2675: -- proceed with the element entries.
2676: --

Line 2757: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

2753: -- error : warn user in log : this asg does not have the link to the element
2754: --
2755: fnd_message.set_name('PAY','PAY_75023_PTO_ACC_LINK');
2756: fnd_message.set_token('ASG_NO', l_assignment_number);
2757: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
2758: END IF;
2759:
2760: hr_entry_api.insert_element_entry(
2761: p_effective_start_date => l_pay_period_start_date,

Line 2779: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);

2775: -- warn user in log : could not create the entry
2776: --
2777: fnd_message.set_name('PAY','PAY_75025_PTO_ACC_NO_ENTRY');
2778: fnd_message.set_token('ASG_NO', l_assignment_number);
2779: fnd_file.put_line(FND_FILE.LOG,fnd_message.get);
2780: END IF;
2781:
2782: hr_utility.set_location('l_new_ee_id is ' , l_new_ee_id);
2783:

Line 2806: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

2802: IF p_type = 'ADD' THEN
2803: IF l_calculation_date > add_months(l_fr_plan_info.accrual_year_end,12) THEN
2804: -- show warning log message
2805: fnd_message.set_name('PAY','PAY_75196_ADD_ENT_DATE_MORE');
2806: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
2807: --
2808: END IF;
2809: END IF;
2810: --

Line 2814: fnd_file.put_line(FND_FILE.LOG,to_char(l_asg_count) || ' ' || fnd_message.get);

2810: --
2811: END IF;
2812: --
2813: fnd_message.set_name('PAY','PAY_75026_PTO_ACC_PROCESSED');
2814: fnd_file.put_line(FND_FILE.LOG,to_char(l_asg_count) || ' ' || fnd_message.get);
2815: --
2816: hr_utility.set_location('Leaving: '||l_proc,50);
2817: end fr_create_entitlement;
2818: --

Line 3091: --fnd_file.put_line(fnd_file.log,'in accrual_plan_info h1');

3087: if l_asat_month < temp_accrual_start_month then
3088: l_add_months := -12;
3089: end if;
3090:
3091: --fnd_file.put_line(fnd_file.log,'in accrual_plan_info h1');
3092: --fnd_file.put_line(fnd_file.log,'temp_accrual_start_month ' || temp_accrual_start_month );
3093: --fnd_file.put_line(fnd_file.log,'pa_accrual_Date is ' || p_accrual_date );
3094: --fnd_file.put_line(fnd_file.log,'l_asat_month is ' || l_asat_month );
3095: --fnd_file.put_line(fnd_file.log,'l_add_months is ' || l_add_months );

Line 3092: --fnd_file.put_line(fnd_file.log,'temp_accrual_start_month ' || temp_accrual_start_month );

3088: l_add_months := -12;
3089: end if;
3090:
3091: --fnd_file.put_line(fnd_file.log,'in accrual_plan_info h1');
3092: --fnd_file.put_line(fnd_file.log,'temp_accrual_start_month ' || temp_accrual_start_month );
3093: --fnd_file.put_line(fnd_file.log,'pa_accrual_Date is ' || p_accrual_date );
3094: --fnd_file.put_line(fnd_file.log,'l_asat_month is ' || l_asat_month );
3095: --fnd_file.put_line(fnd_file.log,'l_add_months is ' || l_add_months );
3096: --fnd_file.put_line(fnd_file.log,'rec_plan_infoe.accrual_start_month is ' || rec_plan_info.accrual_start_month);

Line 3093: --fnd_file.put_line(fnd_file.log,'pa_accrual_Date is ' || p_accrual_date );

3089: end if;
3090:
3091: --fnd_file.put_line(fnd_file.log,'in accrual_plan_info h1');
3092: --fnd_file.put_line(fnd_file.log,'temp_accrual_start_month ' || temp_accrual_start_month );
3093: --fnd_file.put_line(fnd_file.log,'pa_accrual_Date is ' || p_accrual_date );
3094: --fnd_file.put_line(fnd_file.log,'l_asat_month is ' || l_asat_month );
3095: --fnd_file.put_line(fnd_file.log,'l_add_months is ' || l_add_months );
3096: --fnd_file.put_line(fnd_file.log,'rec_plan_infoe.accrual_start_month is ' || rec_plan_info.accrual_start_month);
3097: --fnd_file.put_line(fnd_file.log,'l_fr_plan_info.entitlement_offset is ' || l_fr_plan_info.entitlement_offset);

Line 3094: --fnd_file.put_line(fnd_file.log,'l_asat_month is ' || l_asat_month );

3090:
3091: --fnd_file.put_line(fnd_file.log,'in accrual_plan_info h1');
3092: --fnd_file.put_line(fnd_file.log,'temp_accrual_start_month ' || temp_accrual_start_month );
3093: --fnd_file.put_line(fnd_file.log,'pa_accrual_Date is ' || p_accrual_date );
3094: --fnd_file.put_line(fnd_file.log,'l_asat_month is ' || l_asat_month );
3095: --fnd_file.put_line(fnd_file.log,'l_add_months is ' || l_add_months );
3096: --fnd_file.put_line(fnd_file.log,'rec_plan_infoe.accrual_start_month is ' || rec_plan_info.accrual_start_month);
3097: --fnd_file.put_line(fnd_file.log,'l_fr_plan_info.entitlement_offset is ' || l_fr_plan_info.entitlement_offset);
3098:

Line 3095: --fnd_file.put_line(fnd_file.log,'l_add_months is ' || l_add_months );

3091: --fnd_file.put_line(fnd_file.log,'in accrual_plan_info h1');
3092: --fnd_file.put_line(fnd_file.log,'temp_accrual_start_month ' || temp_accrual_start_month );
3093: --fnd_file.put_line(fnd_file.log,'pa_accrual_Date is ' || p_accrual_date );
3094: --fnd_file.put_line(fnd_file.log,'l_asat_month is ' || l_asat_month );
3095: --fnd_file.put_line(fnd_file.log,'l_add_months is ' || l_add_months );
3096: --fnd_file.put_line(fnd_file.log,'rec_plan_infoe.accrual_start_month is ' || rec_plan_info.accrual_start_month);
3097: --fnd_file.put_line(fnd_file.log,'l_fr_plan_info.entitlement_offset is ' || l_fr_plan_info.entitlement_offset);
3098:
3099: l_fr_plan_info.accrual_year_start := to_date('01-' || temp_accrual_start_month || '-'

Line 3096: --fnd_file.put_line(fnd_file.log,'rec_plan_infoe.accrual_start_month is ' || rec_plan_info.accrual_start_month);

3092: --fnd_file.put_line(fnd_file.log,'temp_accrual_start_month ' || temp_accrual_start_month );
3093: --fnd_file.put_line(fnd_file.log,'pa_accrual_Date is ' || p_accrual_date );
3094: --fnd_file.put_line(fnd_file.log,'l_asat_month is ' || l_asat_month );
3095: --fnd_file.put_line(fnd_file.log,'l_add_months is ' || l_add_months );
3096: --fnd_file.put_line(fnd_file.log,'rec_plan_infoe.accrual_start_month is ' || rec_plan_info.accrual_start_month);
3097: --fnd_file.put_line(fnd_file.log,'l_fr_plan_info.entitlement_offset is ' || l_fr_plan_info.entitlement_offset);
3098:
3099: l_fr_plan_info.accrual_year_start := to_date('01-' || temp_accrual_start_month || '-'
3100: || to_char(add_months(p_accrual_date,l_add_months), 'yyyy') || ' 00:00:00'

Line 3097: --fnd_file.put_line(fnd_file.log,'l_fr_plan_info.entitlement_offset is ' || l_fr_plan_info.entitlement_offset);

3093: --fnd_file.put_line(fnd_file.log,'pa_accrual_Date is ' || p_accrual_date );
3094: --fnd_file.put_line(fnd_file.log,'l_asat_month is ' || l_asat_month );
3095: --fnd_file.put_line(fnd_file.log,'l_add_months is ' || l_add_months );
3096: --fnd_file.put_line(fnd_file.log,'rec_plan_infoe.accrual_start_month is ' || rec_plan_info.accrual_start_month);
3097: --fnd_file.put_line(fnd_file.log,'l_fr_plan_info.entitlement_offset is ' || l_fr_plan_info.entitlement_offset);
3098:
3099: l_fr_plan_info.accrual_year_start := to_date('01-' || temp_accrual_start_month || '-'
3100: || to_char(add_months(p_accrual_date,l_add_months), 'yyyy') || ' 00:00:00'
3101: , 'dd-mm-yyyy hh24:mi:ss');

Line 3173: --fnd_file.put_line(fnd_file.log,'In FR_GET_ACCRUAL' );

3169: hr_utility.set_location('Entering FR_Get_Accrual'||l_proc, 5);
3170:
3171: l_accrual_plan_rec := per_accrual_calc_functions.get_accrual_plan(p_plan_id);
3172: hr_utility.set_location('Step ' || l_proc,10);
3173: --fnd_file.put_line(fnd_file.log,'In FR_GET_ACCRUAL' );
3174: --fnd_file.put_line(fnd_file.log,'asg ' || p_assignment_id );
3175: hr_utility.set_location('Calling paer_accrual_calc_functions'||l_proc, 25);
3176: l_Enrolled_In_Plan := per_accrual_calc_functions.check_assignment_enrollment(
3177: p_assignment_id

Line 3174: --fnd_file.put_line(fnd_file.log,'asg ' || p_assignment_id );

3170:
3171: l_accrual_plan_rec := per_accrual_calc_functions.get_accrual_plan(p_plan_id);
3172: hr_utility.set_location('Step ' || l_proc,10);
3173: --fnd_file.put_line(fnd_file.log,'In FR_GET_ACCRUAL' );
3174: --fnd_file.put_line(fnd_file.log,'asg ' || p_assignment_id );
3175: hr_utility.set_location('Calling paer_accrual_calc_functions'||l_proc, 25);
3176: l_Enrolled_In_Plan := per_accrual_calc_functions.check_assignment_enrollment(
3177: p_assignment_id
3178: ,l_accrual_plan_rec.accrual_plan_element_type_id

Line 3269: --fnd_file.put_line(fnd_file.log,'Leaving FR_GET_ACCRUAL' );

3265: --
3266: end if;
3267: --
3268: hr_utility.set_location('Leaving '||l_proc, 100);
3269: --fnd_file.put_line(fnd_file.log,'Leaving FR_GET_ACCRUAL' );
3270: --
3271: end FR_Get_Accrual;
3272: -------------------------------------------------------------------------------
3273: -- FR_CALCULATE_ACRUAL LOW LEVEL FAST FORMULA CALL

Line 3349: --fnd_file.put_line(fnd_file.log,'In FR_CALCULATE_ACCRUAL' );

3345: and pee.assignment_id = p_assignment_id ;
3346: --
3347: begin
3348: hr_utility.set_location('Entering ' || l_proc,10);
3349: --fnd_file.put_line(fnd_file.log,'In FR_CALCULATE_ACCRUAL' );
3350: --
3351: -- Added Following line to support additional day requirements.bug#3030610
3352: IF p_type IS NULL OR p_type <> 'ADD' THEN
3353: --

Line 3514: --fnd_file.put_line(fnd_file.log,'Leaving FR_CALCULATE_ACCRUAL' );

3510: hr_utility.set_location( l_outputs(1).name||':'|| p_total_accrued_pto,21);
3511:
3512: END IF;
3513: --
3514: --fnd_file.put_line(fnd_file.log,'Leaving FR_CALCULATE_ACCRUAL' );
3515: --
3516: end FR_Calculate_Accrual;
3517: --
3518:

Line 3554: --fnd_file.put_line(fnd_file.log,'In Obsoletion Procedure' );

3550: l_proc VARCHAR2(72) := g_package||' obsoletion_Procedure ';
3551:
3552: begin
3553: hr_utility.set_location('Entering ' || l_proc,10);
3554: --fnd_file.put_line(fnd_file.log,'In Obsoletion Procedure' );
3555:
3556: l_number := per_formula_functions.set_date('PROCESS_DATE', p_effective_date);
3557:
3558: l_number := get_fr_latest_ent_date(

Line 3569: --fnd_file.put_line(fnd_file.log,'Ent start date' || l_ent_start_date );

3565: P_ACCRUAL_END_DATE => l_unused_date);
3566:
3567: hr_utility.set_location('Step ' || l_proc,30);
3568:
3569: --fnd_file.put_line(fnd_file.log,'Ent start date' || l_ent_start_date );
3570: --fnd_file.put_line(fnd_file.log,'Formula ID' || p_formula_id );
3571: --fnd_file.put_line(fnd_file.log,'Assignment id' || p_assignment_id );
3572: --fnd_file.put_line(fnd_file.log,'Accrual Plan Id' || p_accrual_plan_id );
3573: --fnd_file.put_line(fnd_file.log,'Business Group Id' || p_business_group_id );

Line 3570: --fnd_file.put_line(fnd_file.log,'Formula ID' || p_formula_id );

3566:
3567: hr_utility.set_location('Step ' || l_proc,30);
3568:
3569: --fnd_file.put_line(fnd_file.log,'Ent start date' || l_ent_start_date );
3570: --fnd_file.put_line(fnd_file.log,'Formula ID' || p_formula_id );
3571: --fnd_file.put_line(fnd_file.log,'Assignment id' || p_assignment_id );
3572: --fnd_file.put_line(fnd_file.log,'Accrual Plan Id' || p_accrual_plan_id );
3573: --fnd_file.put_line(fnd_file.log,'Business Group Id' || p_business_group_id );
3574: --fnd_file.put_line(fnd_file.log,'Payroll Id' || p_payroll_id );

Line 3571: --fnd_file.put_line(fnd_file.log,'Assignment id' || p_assignment_id );

3567: hr_utility.set_location('Step ' || l_proc,30);
3568:
3569: --fnd_file.put_line(fnd_file.log,'Ent start date' || l_ent_start_date );
3570: --fnd_file.put_line(fnd_file.log,'Formula ID' || p_formula_id );
3571: --fnd_file.put_line(fnd_file.log,'Assignment id' || p_assignment_id );
3572: --fnd_file.put_line(fnd_file.log,'Accrual Plan Id' || p_accrual_plan_id );
3573: --fnd_file.put_line(fnd_file.log,'Business Group Id' || p_business_group_id );
3574: --fnd_file.put_line(fnd_file.log,'Payroll Id' || p_payroll_id );
3575: --fnd_file.put_line(fnd_file.log,'Effective Date' || p_effective_date );

Line 3572: --fnd_file.put_line(fnd_file.log,'Accrual Plan Id' || p_accrual_plan_id );

3568:
3569: --fnd_file.put_line(fnd_file.log,'Ent start date' || l_ent_start_date );
3570: --fnd_file.put_line(fnd_file.log,'Formula ID' || p_formula_id );
3571: --fnd_file.put_line(fnd_file.log,'Assignment id' || p_assignment_id );
3572: --fnd_file.put_line(fnd_file.log,'Accrual Plan Id' || p_accrual_plan_id );
3573: --fnd_file.put_line(fnd_file.log,'Business Group Id' || p_business_group_id );
3574: --fnd_file.put_line(fnd_file.log,'Payroll Id' || p_payroll_id );
3575: --fnd_file.put_line(fnd_file.log,'Effective Date' || p_effective_date );
3576:

Line 3573: --fnd_file.put_line(fnd_file.log,'Business Group Id' || p_business_group_id );

3569: --fnd_file.put_line(fnd_file.log,'Ent start date' || l_ent_start_date );
3570: --fnd_file.put_line(fnd_file.log,'Formula ID' || p_formula_id );
3571: --fnd_file.put_line(fnd_file.log,'Assignment id' || p_assignment_id );
3572: --fnd_file.put_line(fnd_file.log,'Accrual Plan Id' || p_accrual_plan_id );
3573: --fnd_file.put_line(fnd_file.log,'Business Group Id' || p_business_group_id );
3574: --fnd_file.put_line(fnd_file.log,'Payroll Id' || p_payroll_id );
3575: --fnd_file.put_line(fnd_file.log,'Effective Date' || p_effective_date );
3576:
3577: per_accrual_calc_functions.get_carry_over_values(

Line 3574: --fnd_file.put_line(fnd_file.log,'Payroll Id' || p_payroll_id );

3570: --fnd_file.put_line(fnd_file.log,'Formula ID' || p_formula_id );
3571: --fnd_file.put_line(fnd_file.log,'Assignment id' || p_assignment_id );
3572: --fnd_file.put_line(fnd_file.log,'Accrual Plan Id' || p_accrual_plan_id );
3573: --fnd_file.put_line(fnd_file.log,'Business Group Id' || p_business_group_id );
3574: --fnd_file.put_line(fnd_file.log,'Payroll Id' || p_payroll_id );
3575: --fnd_file.put_line(fnd_file.log,'Effective Date' || p_effective_date );
3576:
3577: per_accrual_calc_functions.get_carry_over_values(
3578: p_co_formula_id => p_formula_id

Line 3575: --fnd_file.put_line(fnd_file.log,'Effective Date' || p_effective_date );

3571: --fnd_file.put_line(fnd_file.log,'Assignment id' || p_assignment_id );
3572: --fnd_file.put_line(fnd_file.log,'Accrual Plan Id' || p_accrual_plan_id );
3573: --fnd_file.put_line(fnd_file.log,'Business Group Id' || p_business_group_id );
3574: --fnd_file.put_line(fnd_file.log,'Payroll Id' || p_payroll_id );
3575: --fnd_file.put_line(fnd_file.log,'Effective Date' || p_effective_date );
3576:
3577: per_accrual_calc_functions.get_carry_over_values(
3578: p_co_formula_id => p_formula_id
3579: ,p_assignment_id => p_assignment_id

Line 3593: --fnd_file.put_line(fnd_file.log,'Net entitlement' || p_net_entitlement );

3589:
3590: no_of_obsoletes := p_net_entitlement - l_max_carryovers;
3591: hr_utility.set_location('Step ' || l_proc,40);
3592:
3593: --fnd_file.put_line(fnd_file.log,'Net entitlement' || p_net_entitlement );
3594: --fnd_file.put_line(fnd_file.log,'Carryovers' || l_max_carryovers );
3595: --fnd_file.put_line(fnd_file.log,'no of obsoletes' || no_of_obsoletes );
3596:
3597: FOR i in 1..5 LOOP

Line 3594: --fnd_file.put_line(fnd_file.log,'Carryovers' || l_max_carryovers );

3590: no_of_obsoletes := p_net_entitlement - l_max_carryovers;
3591: hr_utility.set_location('Step ' || l_proc,40);
3592:
3593: --fnd_file.put_line(fnd_file.log,'Net entitlement' || p_net_entitlement );
3594: --fnd_file.put_line(fnd_file.log,'Carryovers' || l_max_carryovers );
3595: --fnd_file.put_line(fnd_file.log,'no of obsoletes' || no_of_obsoletes );
3596:
3597: FOR i in 1..5 LOOP
3598:

Line 3595: --fnd_file.put_line(fnd_file.log,'no of obsoletes' || no_of_obsoletes );

3591: hr_utility.set_location('Step ' || l_proc,40);
3592:
3593: --fnd_file.put_line(fnd_file.log,'Net entitlement' || p_net_entitlement );
3594: --fnd_file.put_line(fnd_file.log,'Carryovers' || l_max_carryovers );
3595: --fnd_file.put_line(fnd_file.log,'no of obsoletes' || no_of_obsoletes );
3596:
3597: FOR i in 1..5 LOOP
3598:
3599: IF (i = 1 and p_net_youngmother_days > 0 and no_of_obsoletes > 0) then

Line 3667: --fnd_file.put_line(fnd_file.log,' Net Mothers' || p_net_youngmother_days );

3663: p_new_conven_days := 0 - p_new_conven_days;
3664: p_new_seniority_days := 0 - p_new_seniority_days;
3665: p_new_protected_days := 0 - p_new_protected_days;
3666:
3667: --fnd_file.put_line(fnd_file.log,' Net Mothers' || p_net_youngmother_days );
3668: --fnd_file.put_line(fnd_file.log,'Net Main' || p_net_main_days );
3669: --fnd_file.put_line(fnd_file.log,'Net Conventional' || p_net_conven_days );
3670: --fnd_file.put_line(fnd_file.log,'Net Seniority' || p_net_seniority_days );
3671: --fnd_file.put_line(fnd_file.log,'Net Protected' || p_net_protected_days );

Line 3668: --fnd_file.put_line(fnd_file.log,'Net Main' || p_net_main_days );

3664: p_new_seniority_days := 0 - p_new_seniority_days;
3665: p_new_protected_days := 0 - p_new_protected_days;
3666:
3667: --fnd_file.put_line(fnd_file.log,' Net Mothers' || p_net_youngmother_days );
3668: --fnd_file.put_line(fnd_file.log,'Net Main' || p_net_main_days );
3669: --fnd_file.put_line(fnd_file.log,'Net Conventional' || p_net_conven_days );
3670: --fnd_file.put_line(fnd_file.log,'Net Seniority' || p_net_seniority_days );
3671: --fnd_file.put_line(fnd_file.log,'Net Protected' || p_net_protected_days );
3672:

Line 3669: --fnd_file.put_line(fnd_file.log,'Net Conventional' || p_net_conven_days );

3665: p_new_protected_days := 0 - p_new_protected_days;
3666:
3667: --fnd_file.put_line(fnd_file.log,' Net Mothers' || p_net_youngmother_days );
3668: --fnd_file.put_line(fnd_file.log,'Net Main' || p_net_main_days );
3669: --fnd_file.put_line(fnd_file.log,'Net Conventional' || p_net_conven_days );
3670: --fnd_file.put_line(fnd_file.log,'Net Seniority' || p_net_seniority_days );
3671: --fnd_file.put_line(fnd_file.log,'Net Protected' || p_net_protected_days );
3672:
3673: --fnd_file.put_line(fnd_file.log,'Mothers' || p_new_youngmother_days );

Line 3670: --fnd_file.put_line(fnd_file.log,'Net Seniority' || p_net_seniority_days );

3666:
3667: --fnd_file.put_line(fnd_file.log,' Net Mothers' || p_net_youngmother_days );
3668: --fnd_file.put_line(fnd_file.log,'Net Main' || p_net_main_days );
3669: --fnd_file.put_line(fnd_file.log,'Net Conventional' || p_net_conven_days );
3670: --fnd_file.put_line(fnd_file.log,'Net Seniority' || p_net_seniority_days );
3671: --fnd_file.put_line(fnd_file.log,'Net Protected' || p_net_protected_days );
3672:
3673: --fnd_file.put_line(fnd_file.log,'Mothers' || p_new_youngmother_days );
3674: --fnd_file.put_line(fnd_file.log,'Main' || p_new_main_days );

Line 3671: --fnd_file.put_line(fnd_file.log,'Net Protected' || p_net_protected_days );

3667: --fnd_file.put_line(fnd_file.log,' Net Mothers' || p_net_youngmother_days );
3668: --fnd_file.put_line(fnd_file.log,'Net Main' || p_net_main_days );
3669: --fnd_file.put_line(fnd_file.log,'Net Conventional' || p_net_conven_days );
3670: --fnd_file.put_line(fnd_file.log,'Net Seniority' || p_net_seniority_days );
3671: --fnd_file.put_line(fnd_file.log,'Net Protected' || p_net_protected_days );
3672:
3673: --fnd_file.put_line(fnd_file.log,'Mothers' || p_new_youngmother_days );
3674: --fnd_file.put_line(fnd_file.log,'Main' || p_new_main_days );
3675: --fnd_file.put_line(fnd_file.log,'Conventional' || p_new_conven_days );

Line 3673: --fnd_file.put_line(fnd_file.log,'Mothers' || p_new_youngmother_days );

3669: --fnd_file.put_line(fnd_file.log,'Net Conventional' || p_net_conven_days );
3670: --fnd_file.put_line(fnd_file.log,'Net Seniority' || p_net_seniority_days );
3671: --fnd_file.put_line(fnd_file.log,'Net Protected' || p_net_protected_days );
3672:
3673: --fnd_file.put_line(fnd_file.log,'Mothers' || p_new_youngmother_days );
3674: --fnd_file.put_line(fnd_file.log,'Main' || p_new_main_days );
3675: --fnd_file.put_line(fnd_file.log,'Conventional' || p_new_conven_days );
3676: --fnd_file.put_line(fnd_file.log,'Seniority' || p_new_seniority_days );
3677: --fnd_file.put_line(fnd_file.log,'Protected' || p_new_protected_days );

Line 3674: --fnd_file.put_line(fnd_file.log,'Main' || p_new_main_days );

3670: --fnd_file.put_line(fnd_file.log,'Net Seniority' || p_net_seniority_days );
3671: --fnd_file.put_line(fnd_file.log,'Net Protected' || p_net_protected_days );
3672:
3673: --fnd_file.put_line(fnd_file.log,'Mothers' || p_new_youngmother_days );
3674: --fnd_file.put_line(fnd_file.log,'Main' || p_new_main_days );
3675: --fnd_file.put_line(fnd_file.log,'Conventional' || p_new_conven_days );
3676: --fnd_file.put_line(fnd_file.log,'Seniority' || p_new_seniority_days );
3677: --fnd_file.put_line(fnd_file.log,'Protected' || p_new_protected_days );
3678:

Line 3675: --fnd_file.put_line(fnd_file.log,'Conventional' || p_new_conven_days );

3671: --fnd_file.put_line(fnd_file.log,'Net Protected' || p_net_protected_days );
3672:
3673: --fnd_file.put_line(fnd_file.log,'Mothers' || p_new_youngmother_days );
3674: --fnd_file.put_line(fnd_file.log,'Main' || p_new_main_days );
3675: --fnd_file.put_line(fnd_file.log,'Conventional' || p_new_conven_days );
3676: --fnd_file.put_line(fnd_file.log,'Seniority' || p_new_seniority_days );
3677: --fnd_file.put_line(fnd_file.log,'Protected' || p_new_protected_days );
3678:
3679: --fnd_file.put_line(fnd_file.log,'Leaving Obsolete Procedure' );

Line 3676: --fnd_file.put_line(fnd_file.log,'Seniority' || p_new_seniority_days );

3672:
3673: --fnd_file.put_line(fnd_file.log,'Mothers' || p_new_youngmother_days );
3674: --fnd_file.put_line(fnd_file.log,'Main' || p_new_main_days );
3675: --fnd_file.put_line(fnd_file.log,'Conventional' || p_new_conven_days );
3676: --fnd_file.put_line(fnd_file.log,'Seniority' || p_new_seniority_days );
3677: --fnd_file.put_line(fnd_file.log,'Protected' || p_new_protected_days );
3678:
3679: --fnd_file.put_line(fnd_file.log,'Leaving Obsolete Procedure' );
3680: hr_utility.set_location('Leaving: '||l_proc,100);

Line 3677: --fnd_file.put_line(fnd_file.log,'Protected' || p_new_protected_days );

3673: --fnd_file.put_line(fnd_file.log,'Mothers' || p_new_youngmother_days );
3674: --fnd_file.put_line(fnd_file.log,'Main' || p_new_main_days );
3675: --fnd_file.put_line(fnd_file.log,'Conventional' || p_new_conven_days );
3676: --fnd_file.put_line(fnd_file.log,'Seniority' || p_new_seniority_days );
3677: --fnd_file.put_line(fnd_file.log,'Protected' || p_new_protected_days );
3678:
3679: --fnd_file.put_line(fnd_file.log,'Leaving Obsolete Procedure' );
3680: hr_utility.set_location('Leaving: '||l_proc,100);
3681: end obsoletion_procedure;

Line 3679: --fnd_file.put_line(fnd_file.log,'Leaving Obsolete Procedure' );

3675: --fnd_file.put_line(fnd_file.log,'Conventional' || p_new_conven_days );
3676: --fnd_file.put_line(fnd_file.log,'Seniority' || p_new_seniority_days );
3677: --fnd_file.put_line(fnd_file.log,'Protected' || p_new_protected_days );
3678:
3679: --fnd_file.put_line(fnd_file.log,'Leaving Obsolete Procedure' );
3680: hr_utility.set_location('Leaving: '||l_proc,100);
3681: end obsoletion_procedure;
3682: -------------------------------------------------------------------------------
3683: -- GET_FR_HOLIDAYS_BOOKED FORMULA FUNCTION

Line 4236: --fnd_file.put_line(fnd_file.log,'Leaving ' || l_proc);

4232:
4233: hr_utility.set_location('p_ref_main_days ', p_ref_main_days);
4234: hr_utility.set_location('p_ref_salary ' ,p_ref_salary);
4235:
4236: --fnd_file.put_line(fnd_file.log,'Leaving ' || l_proc);
4237: --
4238: hr_utility.set_location('Leaving: '||l_proc,50);
4239: end get_reference_entitlement;
4240: -------------------------------------------------------------------------------

Line 4453: --fnd_file.put_line(fnd_file.log,'pay_total_days_input_ID is ' || to_char(l_fr_pay_info.pay_total_days_input_ID));

4449:
4450: hr_utility.trace('get_previous_absence_paid p_absence_attendance_id is ' || to_char(p_absence_attendance_id));
4451: hr_utility.trace('p_total_days_paid is ' || to_char(p_total_days_paid));
4452: hr_utility.trace('p_protected_days_paid is ' || to_char(p_protected_days_paid));
4453: --fnd_file.put_line(fnd_file.log,'pay_total_days_input_ID is ' || to_char(l_fr_pay_info.pay_total_days_input_ID));
4454: --fnd_file.put_line(fnd_file.log,'pay_protected_days_input_ID is ' || to_char(l_fr_pay_info.pay_protected_days_input_ID));
4455: --fnd_file.put_line(fnd_file.log,'l_pay_element_id is ' || to_char(l_fr_pay_info.pay_element_id));
4456: --fnd_file.put_line(fnd_file.log,'p_assignment_id is ' || to_char(p_assignment_id));
4457: --fnd_file.put_line(fnd_file.log,'p_total_days_paid is ' || to_char(p_total_days_paid));

Line 4454: --fnd_file.put_line(fnd_file.log,'pay_protected_days_input_ID is ' || to_char(l_fr_pay_info.pay_protected_days_input_ID));

4450: hr_utility.trace('get_previous_absence_paid p_absence_attendance_id is ' || to_char(p_absence_attendance_id));
4451: hr_utility.trace('p_total_days_paid is ' || to_char(p_total_days_paid));
4452: hr_utility.trace('p_protected_days_paid is ' || to_char(p_protected_days_paid));
4453: --fnd_file.put_line(fnd_file.log,'pay_total_days_input_ID is ' || to_char(l_fr_pay_info.pay_total_days_input_ID));
4454: --fnd_file.put_line(fnd_file.log,'pay_protected_days_input_ID is ' || to_char(l_fr_pay_info.pay_protected_days_input_ID));
4455: --fnd_file.put_line(fnd_file.log,'l_pay_element_id is ' || to_char(l_fr_pay_info.pay_element_id));
4456: --fnd_file.put_line(fnd_file.log,'p_assignment_id is ' || to_char(p_assignment_id));
4457: --fnd_file.put_line(fnd_file.log,'p_total_days_paid is ' || to_char(p_total_days_paid));
4458: --fnd_file.put_line(fnd_file.log,'p_protected_days_paid is ' || to_char(p_protected_days_paid));

Line 4455: --fnd_file.put_line(fnd_file.log,'l_pay_element_id is ' || to_char(l_fr_pay_info.pay_element_id));

4451: hr_utility.trace('p_total_days_paid is ' || to_char(p_total_days_paid));
4452: hr_utility.trace('p_protected_days_paid is ' || to_char(p_protected_days_paid));
4453: --fnd_file.put_line(fnd_file.log,'pay_total_days_input_ID is ' || to_char(l_fr_pay_info.pay_total_days_input_ID));
4454: --fnd_file.put_line(fnd_file.log,'pay_protected_days_input_ID is ' || to_char(l_fr_pay_info.pay_protected_days_input_ID));
4455: --fnd_file.put_line(fnd_file.log,'l_pay_element_id is ' || to_char(l_fr_pay_info.pay_element_id));
4456: --fnd_file.put_line(fnd_file.log,'p_assignment_id is ' || to_char(p_assignment_id));
4457: --fnd_file.put_line(fnd_file.log,'p_total_days_paid is ' || to_char(p_total_days_paid));
4458: --fnd_file.put_line(fnd_file.log,'p_protected_days_paid is ' || to_char(p_protected_days_paid));
4459: hr_utility.set_location('Leaving: '||l_proc,50);

Line 4456: --fnd_file.put_line(fnd_file.log,'p_assignment_id is ' || to_char(p_assignment_id));

4452: hr_utility.trace('p_protected_days_paid is ' || to_char(p_protected_days_paid));
4453: --fnd_file.put_line(fnd_file.log,'pay_total_days_input_ID is ' || to_char(l_fr_pay_info.pay_total_days_input_ID));
4454: --fnd_file.put_line(fnd_file.log,'pay_protected_days_input_ID is ' || to_char(l_fr_pay_info.pay_protected_days_input_ID));
4455: --fnd_file.put_line(fnd_file.log,'l_pay_element_id is ' || to_char(l_fr_pay_info.pay_element_id));
4456: --fnd_file.put_line(fnd_file.log,'p_assignment_id is ' || to_char(p_assignment_id));
4457: --fnd_file.put_line(fnd_file.log,'p_total_days_paid is ' || to_char(p_total_days_paid));
4458: --fnd_file.put_line(fnd_file.log,'p_protected_days_paid is ' || to_char(p_protected_days_paid));
4459: hr_utility.set_location('Leaving: '||l_proc,50);
4460: end get_previous_holiday_absence;

Line 4457: --fnd_file.put_line(fnd_file.log,'p_total_days_paid is ' || to_char(p_total_days_paid));

4453: --fnd_file.put_line(fnd_file.log,'pay_total_days_input_ID is ' || to_char(l_fr_pay_info.pay_total_days_input_ID));
4454: --fnd_file.put_line(fnd_file.log,'pay_protected_days_input_ID is ' || to_char(l_fr_pay_info.pay_protected_days_input_ID));
4455: --fnd_file.put_line(fnd_file.log,'l_pay_element_id is ' || to_char(l_fr_pay_info.pay_element_id));
4456: --fnd_file.put_line(fnd_file.log,'p_assignment_id is ' || to_char(p_assignment_id));
4457: --fnd_file.put_line(fnd_file.log,'p_total_days_paid is ' || to_char(p_total_days_paid));
4458: --fnd_file.put_line(fnd_file.log,'p_protected_days_paid is ' || to_char(p_protected_days_paid));
4459: hr_utility.set_location('Leaving: '||l_proc,50);
4460: end get_previous_holiday_absence;
4461: --

Line 4458: --fnd_file.put_line(fnd_file.log,'p_protected_days_paid is ' || to_char(p_protected_days_paid));

4454: --fnd_file.put_line(fnd_file.log,'pay_protected_days_input_ID is ' || to_char(l_fr_pay_info.pay_protected_days_input_ID));
4455: --fnd_file.put_line(fnd_file.log,'l_pay_element_id is ' || to_char(l_fr_pay_info.pay_element_id));
4456: --fnd_file.put_line(fnd_file.log,'p_assignment_id is ' || to_char(p_assignment_id));
4457: --fnd_file.put_line(fnd_file.log,'p_total_days_paid is ' || to_char(p_total_days_paid));
4458: --fnd_file.put_line(fnd_file.log,'p_protected_days_paid is ' || to_char(p_protected_days_paid));
4459: hr_utility.set_location('Leaving: '||l_proc,50);
4460: end get_previous_holiday_absence;
4461: --
4462: -------------------------------------------------------------------------------

Line 4907: --fnd_file.put_line(fnd_file.log,'l_to_pay_flag is ' || l_to_pay_flag);

4903: l_to_pay_flag := 'LAST';
4904: else
4905: l_to_pay_flag := 'OTHER';
4906: end if;
4907: --fnd_file.put_line(fnd_file.log,'l_to_pay_flag is ' || l_to_pay_flag);
4908: --
4909: -- Calculate if the accrual period has ended yet - this is needed as the regularized payment
4910: -- is only possible if the accrual period is closed and therefore the salary balance is known.
4911: --

Line 4930: --fnd_file.put_line(fnd_file.log,'l_previous_total_days is ' || to_char(l_previous_total_days));

4926: ,p_assignment_id => l_assignment_id
4927: ,p_total_days_paid => l_previous_total_days /* all absence types */
4928: ,p_protected_days_paid => l_previous_protected_days); /* just protected */
4929: --
4930: --fnd_file.put_line(fnd_file.log,'l_previous_total_days is ' || to_char(l_previous_total_days));
4931: --fnd_file.put_line(fnd_file.log,'l_previous_protected_days is ' || to_char(l_previous_protected_days));
4932: --fnd_file.put_line(fnd_file.log,'previous element id is ' || to_char(l_previous_protected_days));
4933: --
4934: -- If regularization is possible, get the total entitlement for main and protected stored

Line 4931: --fnd_file.put_line(fnd_file.log,'l_previous_protected_days is ' || to_char(l_previous_protected_days));

4927: ,p_total_days_paid => l_previous_total_days /* all absence types */
4928: ,p_protected_days_paid => l_previous_protected_days); /* just protected */
4929: --
4930: --fnd_file.put_line(fnd_file.log,'l_previous_total_days is ' || to_char(l_previous_total_days));
4931: --fnd_file.put_line(fnd_file.log,'l_previous_protected_days is ' || to_char(l_previous_protected_days));
4932: --fnd_file.put_line(fnd_file.log,'previous element id is ' || to_char(l_previous_protected_days));
4933: --
4934: -- If regularization is possible, get the total entitlement for main and protected stored
4935: -- for this assignment for this accrual period.

Line 4932: --fnd_file.put_line(fnd_file.log,'previous element id is ' || to_char(l_previous_protected_days));

4928: ,p_protected_days_paid => l_previous_protected_days); /* just protected */
4929: --
4930: --fnd_file.put_line(fnd_file.log,'l_previous_total_days is ' || to_char(l_previous_total_days));
4931: --fnd_file.put_line(fnd_file.log,'l_previous_protected_days is ' || to_char(l_previous_protected_days));
4932: --fnd_file.put_line(fnd_file.log,'previous element id is ' || to_char(l_previous_protected_days));
4933: --
4934: -- If regularization is possible, get the total entitlement for main and protected stored
4935: -- for this assignment for this accrual period.
4936: --