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.BEN_PERSON_DELETE dependencies on BEN_BATCH_UTILS

Line 3470: ben_batch_utils.g_audit_flag := true;

3466: begin
3467: --hr_utility.trace_on(null,'oracle');
3468: hr_utility.set_location ('Entering ' || l_proc, 10);
3469:
3470: ben_batch_utils.g_audit_flag := true;
3471:
3472: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
3473:
3474: hr_utility.set_location ('hr_api.mandatory_arg_error',100);

Line 3482: --hr_utility.set_location ('ben_batch_utils.ini',101);

3478: ,p_argument_value => p_person_id);
3479:
3480: -- Initialize the batch process.
3481: --
3482: --hr_utility.set_location ('ben_batch_utils.ini',101);
3483: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
3484:
3485: benutils.get_parameter
3486: (p_business_group_id => p_business_group_id

Line 3483: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');

3479:
3480: -- Initialize the batch process.
3481: --
3482: --hr_utility.set_location ('ben_batch_utils.ini',101);
3483: ben_batch_utils.ini(p_actn_cd => 'PROC_INFO');
3484:
3485: benutils.get_parameter
3486: (p_business_group_id => p_business_group_id
3487: ,p_batch_exe_cd => 'BENURSDEL'

Line 3533: ben_batch_utils.write(p_text => 'Get per_in_ler_id of Unrestricted LE');

3529:
3530: hr_utility.set_location ('creating savepoint',105);
3531: SAVEPOINT scheddu_le_data_del;
3532:
3533: ben_batch_utils.write(p_text => 'Get per_in_ler_id of Unrestricted LE');
3534: open c_get_pil;
3535: fetch c_get_pil into l_per_in_ler_id;
3536: if(c_get_pil%found) then
3537: close c_get_pil;

Line 3538: ben_batch_utils.write(p_text => 'per_in_ler_id of Unrestricted LE '||l_per_in_ler_id);

3534: open c_get_pil;
3535: fetch c_get_pil into l_per_in_ler_id;
3536: if(c_get_pil%found) then
3537: close c_get_pil;
3538: ben_batch_utils.write(p_text => 'per_in_ler_id of Unrestricted LE '||l_per_in_ler_id);
3539:
3540: open c_chk_ele_entries;
3541: fetch c_chk_ele_entries into l_exists;
3542: if(c_chk_ele_entries%found) then

Line 3543: ben_batch_utils.write(p_text => ' Element entries exists');

3539:
3540: open c_chk_ele_entries;
3541: fetch c_chk_ele_entries into l_exists;
3542: if(c_chk_ele_entries%found) then
3543: ben_batch_utils.write(p_text => ' Element entries exists');
3544: close c_chk_ele_entries;
3545: open c_chk_payroll_run;
3546: fetch c_chk_payroll_run into l_exists;
3547: if(c_chk_payroll_run%found) then

Line 3549: ben_batch_utils.write(p_text => 'Payroll is run for the employee. Error the process');

3545: open c_chk_payroll_run;
3546: fetch c_chk_payroll_run into l_exists;
3547: if(c_chk_payroll_run%found) then
3548: close c_chk_payroll_run;
3549: ben_batch_utils.write(p_text => 'Payroll is run for the employee. Error the process');
3550: fnd_message.raise_error;
3551: else
3552: close c_chk_payroll_run;
3553: ben_batch_utils.write(p_text => ' Deleting Element Entries ');

Line 3553: ben_batch_utils.write(p_text => ' Deleting Element Entries ');

3549: ben_batch_utils.write(p_text => 'Payroll is run for the employee. Error the process');
3550: fnd_message.raise_error;
3551: else
3552: close c_chk_payroll_run;
3553: ben_batch_utils.write(p_text => ' Deleting Element Entries ');
3554: for l_ele_rec in c_element_entries loop
3555: hr_utility.set_location('Element entry Id '||l_ele_rec.ele_entry_id,50);
3556: hr_utility.set_location('l_ele_rec.esd '||l_ele_rec.esd,60);
3557: ben_batch_utils.write(p_text => ' Deleting Element Entry '||l_ele_rec.ele_entry_id);

Line 3557: ben_batch_utils.write(p_text => ' Deleting Element Entry '||l_ele_rec.ele_entry_id);

3553: ben_batch_utils.write(p_text => ' Deleting Element Entries ');
3554: for l_ele_rec in c_element_entries loop
3555: hr_utility.set_location('Element entry Id '||l_ele_rec.ele_entry_id,50);
3556: hr_utility.set_location('l_ele_rec.esd '||l_ele_rec.esd,60);
3557: ben_batch_utils.write(p_text => ' Deleting Element Entry '||l_ele_rec.ele_entry_id);
3558: py_element_entry_api.delete_element_entry
3559: (p_validate => l_validate
3560: ,p_datetrack_delete_mode => hr_api.g_zap
3561: ,p_effective_date => l_ele_rec.esd

Line 3569: ben_batch_utils.write(p_text => ' Done deleting element entries');

3565: ,p_effective_end_date => l_effective_end_date
3566: ,p_delete_warning => l_delete_warning
3567: );
3568: end loop;
3569: ben_batch_utils.write(p_text => ' Done deleting element entries');
3570: ben_batch_utils.write(p_text => ' Deleting ben rows ');
3571: ben_person_delete.delete_ben_rows(p_person_id,l_per_in_ler_id);
3572: ben_batch_utils.write(p_text => ' Done deleting ben rows ');
3573: end if;

Line 3570: ben_batch_utils.write(p_text => ' Deleting ben rows ');

3566: ,p_delete_warning => l_delete_warning
3567: );
3568: end loop;
3569: ben_batch_utils.write(p_text => ' Done deleting element entries');
3570: ben_batch_utils.write(p_text => ' Deleting ben rows ');
3571: ben_person_delete.delete_ben_rows(p_person_id,l_per_in_ler_id);
3572: ben_batch_utils.write(p_text => ' Done deleting ben rows ');
3573: end if;
3574: else

Line 3572: ben_batch_utils.write(p_text => ' Done deleting ben rows ');

3568: end loop;
3569: ben_batch_utils.write(p_text => ' Done deleting element entries');
3570: ben_batch_utils.write(p_text => ' Deleting ben rows ');
3571: ben_person_delete.delete_ben_rows(p_person_id,l_per_in_ler_id);
3572: ben_batch_utils.write(p_text => ' Done deleting ben rows ');
3573: end if;
3574: else
3575: close c_chk_ele_entries;
3576: ben_batch_utils.write(p_text => ' Deleting ben rows ');

Line 3576: ben_batch_utils.write(p_text => ' Deleting ben rows ');

3572: ben_batch_utils.write(p_text => ' Done deleting ben rows ');
3573: end if;
3574: else
3575: close c_chk_ele_entries;
3576: ben_batch_utils.write(p_text => ' Deleting ben rows ');
3577: ben_person_delete.delete_ben_rows(p_person_id,l_per_in_ler_id);
3578: ben_batch_utils.write(p_text => ' Done deleting ben rows ');
3579: end if;
3580: else

Line 3578: ben_batch_utils.write(p_text => ' Done deleting ben rows ');

3574: else
3575: close c_chk_ele_entries;
3576: ben_batch_utils.write(p_text => ' Deleting ben rows ');
3577: ben_person_delete.delete_ben_rows(p_person_id,l_per_in_ler_id);
3578: ben_batch_utils.write(p_text => ' Done deleting ben rows ');
3579: end if;
3580: else
3581: close c_get_pil;
3582: ben_batch_utils.write(p_text => 'No Unrestricted LE exists for the employee. Error the process');

Line 3582: ben_batch_utils.write(p_text => 'No Unrestricted LE exists for the employee. Error the process');

3578: ben_batch_utils.write(p_text => ' Done deleting ben rows ');
3579: end if;
3580: else
3581: close c_get_pil;
3582: ben_batch_utils.write(p_text => 'No Unrestricted LE exists for the employee. Error the process');
3583: hr_utility.set_location('No Unrestricted LE exists for the employee',80);
3584: fnd_message.raise_error;
3585: end if;
3586:

Line 3588: ben_batch_utils.print_parameters

3584: fnd_message.raise_error;
3585: end if;
3586:
3587: l_thread_id := 99;
3588: ben_batch_utils.print_parameters
3589: (p_thread_id => l_thread_id
3590: ,p_benefit_action_id => l_benefit_action_id
3591: ,p_validate => p_validate
3592: ,p_business_group_id => p_business_group_id

Line 3606: ben_batch_utils.write(p_text => ' Exception Raised because of any of the below reasons: ');

3602:
3603: exception
3604: when others then
3605: rollback to scheddu_le_data_del;
3606: ben_batch_utils.write(p_text => ' Exception Raised because of any of the below reasons: ');
3607: ben_batch_utils.write(p_text => ' No Unrestricted LE exists for the employee (or) ');
3608: ben_batch_utils.write(p_text => ' Payroll is run for the employee (or) ');
3609: ben_batch_utils.write(p_text => ' Error while deleting element entries (or) ');
3610: ben_batch_utils.write(p_text => ' Error while deleting Benefits enrollments ');

Line 3607: ben_batch_utils.write(p_text => ' No Unrestricted LE exists for the employee (or) ');

3603: exception
3604: when others then
3605: rollback to scheddu_le_data_del;
3606: ben_batch_utils.write(p_text => ' Exception Raised because of any of the below reasons: ');
3607: ben_batch_utils.write(p_text => ' No Unrestricted LE exists for the employee (or) ');
3608: ben_batch_utils.write(p_text => ' Payroll is run for the employee (or) ');
3609: ben_batch_utils.write(p_text => ' Error while deleting element entries (or) ');
3610: ben_batch_utils.write(p_text => ' Error while deleting Benefits enrollments ');
3611: update ben_person_actions

Line 3608: ben_batch_utils.write(p_text => ' Payroll is run for the employee (or) ');

3604: when others then
3605: rollback to scheddu_le_data_del;
3606: ben_batch_utils.write(p_text => ' Exception Raised because of any of the below reasons: ');
3607: ben_batch_utils.write(p_text => ' No Unrestricted LE exists for the employee (or) ');
3608: ben_batch_utils.write(p_text => ' Payroll is run for the employee (or) ');
3609: ben_batch_utils.write(p_text => ' Error while deleting element entries (or) ');
3610: ben_batch_utils.write(p_text => ' Error while deleting Benefits enrollments ');
3611: update ben_person_actions
3612: set action_status_cd = 'E'

Line 3609: ben_batch_utils.write(p_text => ' Error while deleting element entries (or) ');

3605: rollback to scheddu_le_data_del;
3606: ben_batch_utils.write(p_text => ' Exception Raised because of any of the below reasons: ');
3607: ben_batch_utils.write(p_text => ' No Unrestricted LE exists for the employee (or) ');
3608: ben_batch_utils.write(p_text => ' Payroll is run for the employee (or) ');
3609: ben_batch_utils.write(p_text => ' Error while deleting element entries (or) ');
3610: ben_batch_utils.write(p_text => ' Error while deleting Benefits enrollments ');
3611: update ben_person_actions
3612: set action_status_cd = 'E'
3613: where person_action_id = l_person_action_id;

Line 3610: ben_batch_utils.write(p_text => ' Error while deleting Benefits enrollments ');

3606: ben_batch_utils.write(p_text => ' Exception Raised because of any of the below reasons: ');
3607: ben_batch_utils.write(p_text => ' No Unrestricted LE exists for the employee (or) ');
3608: ben_batch_utils.write(p_text => ' Payroll is run for the employee (or) ');
3609: ben_batch_utils.write(p_text => ' Error while deleting element entries (or) ');
3610: ben_batch_utils.write(p_text => ' Error while deleting Benefits enrollments ');
3611: update ben_person_actions
3612: set action_status_cd = 'E'
3613: where person_action_id = l_person_action_id;
3614: commit;