eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_ENROLL_INFO_GENE dependencies on FND_FILE

Line 294: fnd_file.put_line(fnd_file.LOG,'Entering update_archive');

290: ACTION_INFORMATION30 - Letter Type
291: */
292: l_ovn number;
293: begin
294: fnd_file.put_line(fnd_file.LOG,'Entering update_archive');
295: l_ovn := p_archive_details_update.object_version_number;
296:
297: pay_action_information_api.update_action_information
298: ( p_action_information_id =>p_archive_details_update.action_information_id

Line 415: fnd_file.put_line(fnd_file.LOG,'Inside Generate XML');

411:
412: OPEN c_person_details(p_assignment_id);
413: FETCH c_person_details INTO l_employee_name,l_email_address,l_person_id;
414: CLOSE c_person_details;
415: fnd_file.put_line(fnd_file.LOG,'Inside Generate XML');
416: open c_archive_details_check (p_assignment_id,P_LETTER);
417: fetch c_archive_details_check into l_archive_details_check;
418: IF c_archive_details_check%notfound then
419: l_flag :='Y';

Line 420: fnd_file.put_line(fnd_file.LOG,'No Matching Archive data found.');

416: open c_archive_details_check (p_assignment_id,P_LETTER);
417: fetch c_archive_details_check into l_archive_details_check;
418: IF c_archive_details_check%notfound then
419: l_flag :='Y';
420: fnd_file.put_line(fnd_file.LOG,'No Matching Archive data found.');
421: END IF;
422: close c_archive_details_check;
423:
424: Open csr_address(l_person_id,l_PRP_START_DATE);

Line 432: fnd_file.put_line(fnd_file.LOG,'Nothing to Update in the Archive.');

428: IF l_flag ='Y' THEN --Update Archive Table
429: OPEN c_archive_details_update(p_assignment_id,P_PERIOD) ;
430: FETCH c_archive_details_update into l_archive_details_update;
431: IF c_archive_details_update%notfound then
432: fnd_file.put_line(fnd_file.LOG,'Nothing to Update in the Archive.');
433: fnd_file.put_line(fnd_file.LOG,'Hence, skipping this assignment as there is no archive data for this assignment for this period.');
434: l_flag := 'N';
435: end if;
436: --l_ovn := l_archive_details_update.object_version_number;

Line 433: fnd_file.put_line(fnd_file.LOG,'Hence, skipping this assignment as there is no archive data for this assignment for this period.');

429: OPEN c_archive_details_update(p_assignment_id,P_PERIOD) ;
430: FETCH c_archive_details_update into l_archive_details_update;
431: IF c_archive_details_update%notfound then
432: fnd_file.put_line(fnd_file.LOG,'Nothing to Update in the Archive.');
433: fnd_file.put_line(fnd_file.LOG,'Hence, skipping this assignment as there is no archive data for this assignment for this period.');
434: l_flag := 'N';
435: end if;
436: --l_ovn := l_archive_details_update.object_version_number;
437: CLOSE c_archive_details_update;

Line 445: fnd_file.put_line(fnd_file.LOG,'Letter for the Automatically Enrolled');

441: l_postponement_type :=p_pension_entry_values.postponement_type;
442: ----------------------------------------------------------------------------------------------------
443: IF P_LETTER = 'PYGBPAEIG1' and l_flag ='Y' THEN
444: --Letter for the Automatically Enrolled
445: fnd_file.put_line(fnd_file.LOG,'Letter for the Automatically Enrolled');
446: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_Name: '||p_pension_entry_values.qualifying_scheme_Name);
447: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL.: '||P_PAYROLL);
448:
449:

Line 446: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_Name: '||p_pension_entry_values.qualifying_scheme_Name);

442: ----------------------------------------------------------------------------------------------------
443: IF P_LETTER = 'PYGBPAEIG1' and l_flag ='Y' THEN
444: --Letter for the Automatically Enrolled
445: fnd_file.put_line(fnd_file.LOG,'Letter for the Automatically Enrolled');
446: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_Name: '||p_pension_entry_values.qualifying_scheme_Name);
447: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL.: '||P_PAYROLL);
448:
449:
450: OPEN c_comm_details_qual(P_PAYROLL,p_pension_entry_values.qualifying_scheme_name);

Line 447: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL.: '||P_PAYROLL);

443: IF P_LETTER = 'PYGBPAEIG1' and l_flag ='Y' THEN
444: --Letter for the Automatically Enrolled
445: fnd_file.put_line(fnd_file.LOG,'Letter for the Automatically Enrolled');
446: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_Name: '||p_pension_entry_values.qualifying_scheme_Name);
447: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL.: '||P_PAYROLL);
448:
449:
450: OPEN c_comm_details_qual(P_PAYROLL,p_pension_entry_values.qualifying_scheme_name);
451: fetch c_comm_details_qual into l_signatory_name_pqs,l_contact_mail_pqs,l_instruction_pqs,l_more_info_pqs;

Line 467: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.auto_enrollment_date::'||p_pension_entry_values.auto_enrollment_date);

463: if l_more_info_pqs is not null then
464: l_more_info := l_more_info_pqs;
465: end if;
466:
467: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.auto_enrollment_date::'||p_pension_entry_values.auto_enrollment_date);
468: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_exists::'||p_pension_entry_values.qualifying_scheme_exists);
469: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.pension_classification::'||p_pension_entry_values.pension_classification);
470: fnd_file.put_line(fnd_file.LOG,'l_prp_start_date::'||l_prp_start_date);
471: fnd_file.put_line(fnd_file.LOG,'l_prp_end_date::'||l_prp_end_date);

Line 468: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_exists::'||p_pension_entry_values.qualifying_scheme_exists);

464: l_more_info := l_more_info_pqs;
465: end if;
466:
467: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.auto_enrollment_date::'||p_pension_entry_values.auto_enrollment_date);
468: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_exists::'||p_pension_entry_values.qualifying_scheme_exists);
469: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.pension_classification::'||p_pension_entry_values.pension_classification);
470: fnd_file.put_line(fnd_file.LOG,'l_prp_start_date::'||l_prp_start_date);
471: fnd_file.put_line(fnd_file.LOG,'l_prp_end_date::'||l_prp_end_date);
472:

Line 469: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.pension_classification::'||p_pension_entry_values.pension_classification);

465: end if;
466:
467: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.auto_enrollment_date::'||p_pension_entry_values.auto_enrollment_date);
468: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_exists::'||p_pension_entry_values.qualifying_scheme_exists);
469: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.pension_classification::'||p_pension_entry_values.pension_classification);
470: fnd_file.put_line(fnd_file.LOG,'l_prp_start_date::'||l_prp_start_date);
471: fnd_file.put_line(fnd_file.LOG,'l_prp_end_date::'||l_prp_end_date);
472:
473: IF p_pension_entry_values.auto_enrollment_date between l_prp_start_date and l_prp_end_date and

Line 470: fnd_file.put_line(fnd_file.LOG,'l_prp_start_date::'||l_prp_start_date);

466:
467: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.auto_enrollment_date::'||p_pension_entry_values.auto_enrollment_date);
468: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_exists::'||p_pension_entry_values.qualifying_scheme_exists);
469: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.pension_classification::'||p_pension_entry_values.pension_classification);
470: fnd_file.put_line(fnd_file.LOG,'l_prp_start_date::'||l_prp_start_date);
471: fnd_file.put_line(fnd_file.LOG,'l_prp_end_date::'||l_prp_end_date);
472:
473: IF p_pension_entry_values.auto_enrollment_date between l_prp_start_date and l_prp_end_date and
474: NVL(p_pension_entry_values.qualifying_scheme_exists,'N') ='Y'

Line 471: fnd_file.put_line(fnd_file.LOG,'l_prp_end_date::'||l_prp_end_date);

467: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.auto_enrollment_date::'||p_pension_entry_values.auto_enrollment_date);
468: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_exists::'||p_pension_entry_values.qualifying_scheme_exists);
469: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.pension_classification::'||p_pension_entry_values.pension_classification);
470: fnd_file.put_line(fnd_file.LOG,'l_prp_start_date::'||l_prp_start_date);
471: fnd_file.put_line(fnd_file.LOG,'l_prp_end_date::'||l_prp_end_date);
472:
473: IF p_pension_entry_values.auto_enrollment_date between l_prp_start_date and l_prp_end_date and
474: NVL(p_pension_entry_values.qualifying_scheme_exists,'N') ='Y'
475: and p_pension_entry_values.pension_classification = 'Eligible Job Holder' THEN

Line 476: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);

472:
473: IF p_pension_entry_values.auto_enrollment_date between l_prp_start_date and l_prp_end_date and
474: NVL(p_pension_entry_values.qualifying_scheme_exists,'N') ='Y'
475: and p_pension_entry_values.pension_classification = 'Eligible Job Holder' THEN
476: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
477:
478: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
479: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
480: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);

Line 478: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);

474: NVL(p_pension_entry_values.qualifying_scheme_exists,'N') ='Y'
475: and p_pension_entry_values.pension_classification = 'Eligible Job Holder' THEN
476: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
477:
478: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
479: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
480: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
481: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
482: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);

Line 479: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);

475: and p_pension_entry_values.pension_classification = 'Eligible Job Holder' THEN
476: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
477:
478: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
479: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
480: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
481: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
482: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
483: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);

Line 480: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);

476: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
477:
478: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
479: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
480: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
481: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
482: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
483: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
484: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);

Line 481: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);

477:
478: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
479: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
480: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
481: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
482: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
483: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
484: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
485: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);

Line 482: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);

478: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
479: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
480: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
481: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
482: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
483: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
484: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
485: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
486: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);

Line 483: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);

479: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
480: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
481: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
482: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
483: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
484: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
485: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
486: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
487: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);

Line 484: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);

480: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
481: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
482: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
483: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
484: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
485: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
486: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
487: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
488: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);

Line 485: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);

481: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
482: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
483: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
484: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
485: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
486: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
487: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
488: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
489: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);

Line 486: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);

482: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
483: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
484: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
485: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
486: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
487: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
488: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
489: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
490:

Line 487: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);

483: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
484: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
485: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
486: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
487: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
488: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
489: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
490:
491: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_name : '||p_pension_entry_values.qualifying_scheme_name);

Line 488: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);

484: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
485: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
486: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
487: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
488: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
489: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
490:
491: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_name : '||p_pension_entry_values.qualifying_scheme_name);
492: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.auto_enrollment_date : '||p_pension_entry_values.auto_enrollment_date);

Line 489: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);

485: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
486: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
487: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
488: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
489: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
490:
491: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_name : '||p_pension_entry_values.qualifying_scheme_name);
492: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.auto_enrollment_date : '||p_pension_entry_values.auto_enrollment_date);
493: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.pension_classification : '||p_pension_entry_values.pension_classification);

Line 491: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_name : '||p_pension_entry_values.qualifying_scheme_name);

487: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
488: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
489: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
490:
491: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_name : '||p_pension_entry_values.qualifying_scheme_name);
492: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.auto_enrollment_date : '||p_pension_entry_values.auto_enrollment_date);
493: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.pension_classification : '||p_pension_entry_values.pension_classification);
494: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_out_period_end_date : '||p_pension_entry_values.opt_out_period_end_date);
495: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.total_earning_prp : '||p_pension_entry_values.total_earning_prp);

Line 492: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.auto_enrollment_date : '||p_pension_entry_values.auto_enrollment_date);

488: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
489: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
490:
491: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_name : '||p_pension_entry_values.qualifying_scheme_name);
492: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.auto_enrollment_date : '||p_pension_entry_values.auto_enrollment_date);
493: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.pension_classification : '||p_pension_entry_values.pension_classification);
494: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_out_period_end_date : '||p_pension_entry_values.opt_out_period_end_date);
495: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.total_earning_prp : '||p_pension_entry_values.total_earning_prp);
496: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_type : '||p_pension_entry_values.postponement_type);

Line 493: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.pension_classification : '||p_pension_entry_values.pension_classification);

489: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
490:
491: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_name : '||p_pension_entry_values.qualifying_scheme_name);
492: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.auto_enrollment_date : '||p_pension_entry_values.auto_enrollment_date);
493: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.pension_classification : '||p_pension_entry_values.pension_classification);
494: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_out_period_end_date : '||p_pension_entry_values.opt_out_period_end_date);
495: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.total_earning_prp : '||p_pension_entry_values.total_earning_prp);
496: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_type : '||p_pension_entry_values.postponement_type);
497: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_end_date : '||p_pension_entry_values.postponement_end_date);

Line 494: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_out_period_end_date : '||p_pension_entry_values.opt_out_period_end_date);

490:
491: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_name : '||p_pension_entry_values.qualifying_scheme_name);
492: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.auto_enrollment_date : '||p_pension_entry_values.auto_enrollment_date);
493: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.pension_classification : '||p_pension_entry_values.pension_classification);
494: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_out_period_end_date : '||p_pension_entry_values.opt_out_period_end_date);
495: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.total_earning_prp : '||p_pension_entry_values.total_earning_prp);
496: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_type : '||p_pension_entry_values.postponement_type);
497: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_end_date : '||p_pension_entry_values.postponement_end_date);
498: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_exists : '||p_pension_entry_values.qualifying_scheme_exists);

Line 495: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.total_earning_prp : '||p_pension_entry_values.total_earning_prp);

491: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_name : '||p_pension_entry_values.qualifying_scheme_name);
492: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.auto_enrollment_date : '||p_pension_entry_values.auto_enrollment_date);
493: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.pension_classification : '||p_pension_entry_values.pension_classification);
494: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_out_period_end_date : '||p_pension_entry_values.opt_out_period_end_date);
495: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.total_earning_prp : '||p_pension_entry_values.total_earning_prp);
496: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_type : '||p_pension_entry_values.postponement_type);
497: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_end_date : '||p_pension_entry_values.postponement_end_date);
498: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_exists : '||p_pension_entry_values.qualifying_scheme_exists);
499: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_in_date : '||p_pension_entry_values.opt_in_date);

Line 496: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_type : '||p_pension_entry_values.postponement_type);

492: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.auto_enrollment_date : '||p_pension_entry_values.auto_enrollment_date);
493: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.pension_classification : '||p_pension_entry_values.pension_classification);
494: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_out_period_end_date : '||p_pension_entry_values.opt_out_period_end_date);
495: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.total_earning_prp : '||p_pension_entry_values.total_earning_prp);
496: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_type : '||p_pension_entry_values.postponement_type);
497: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_end_date : '||p_pension_entry_values.postponement_end_date);
498: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_exists : '||p_pension_entry_values.qualifying_scheme_exists);
499: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_in_date : '||p_pension_entry_values.opt_in_date);
500: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.elig_jh_date : '||p_pension_entry_values.elig_jh_date);

Line 497: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_end_date : '||p_pension_entry_values.postponement_end_date);

493: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.pension_classification : '||p_pension_entry_values.pension_classification);
494: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_out_period_end_date : '||p_pension_entry_values.opt_out_period_end_date);
495: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.total_earning_prp : '||p_pension_entry_values.total_earning_prp);
496: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_type : '||p_pension_entry_values.postponement_type);
497: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_end_date : '||p_pension_entry_values.postponement_end_date);
498: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_exists : '||p_pension_entry_values.qualifying_scheme_exists);
499: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_in_date : '||p_pension_entry_values.opt_in_date);
500: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.elig_jh_date : '||p_pension_entry_values.elig_jh_date);
501: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_out_date : '||p_pension_entry_values.opt_out_date);

Line 498: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_exists : '||p_pension_entry_values.qualifying_scheme_exists);

494: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_out_period_end_date : '||p_pension_entry_values.opt_out_period_end_date);
495: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.total_earning_prp : '||p_pension_entry_values.total_earning_prp);
496: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_type : '||p_pension_entry_values.postponement_type);
497: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_end_date : '||p_pension_entry_values.postponement_end_date);
498: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_exists : '||p_pension_entry_values.qualifying_scheme_exists);
499: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_in_date : '||p_pension_entry_values.opt_in_date);
500: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.elig_jh_date : '||p_pension_entry_values.elig_jh_date);
501: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_out_date : '||p_pension_entry_values.opt_out_date);
502:

Line 499: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_in_date : '||p_pension_entry_values.opt_in_date);

495: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.total_earning_prp : '||p_pension_entry_values.total_earning_prp);
496: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_type : '||p_pension_entry_values.postponement_type);
497: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_end_date : '||p_pension_entry_values.postponement_end_date);
498: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_exists : '||p_pension_entry_values.qualifying_scheme_exists);
499: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_in_date : '||p_pension_entry_values.opt_in_date);
500: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.elig_jh_date : '||p_pension_entry_values.elig_jh_date);
501: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_out_date : '||p_pension_entry_values.opt_out_date);
502:
503:

Line 500: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.elig_jh_date : '||p_pension_entry_values.elig_jh_date);

496: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_type : '||p_pension_entry_values.postponement_type);
497: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_end_date : '||p_pension_entry_values.postponement_end_date);
498: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_exists : '||p_pension_entry_values.qualifying_scheme_exists);
499: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_in_date : '||p_pension_entry_values.opt_in_date);
500: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.elig_jh_date : '||p_pension_entry_values.elig_jh_date);
501: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_out_date : '||p_pension_entry_values.opt_out_date);
502:
503:
504:

Line 501: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_out_date : '||p_pension_entry_values.opt_out_date);

497: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.postponement_end_date : '||p_pension_entry_values.postponement_end_date);
498: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.qualifying_scheme_exists : '||p_pension_entry_values.qualifying_scheme_exists);
499: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_in_date : '||p_pension_entry_values.opt_in_date);
500: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.elig_jh_date : '||p_pension_entry_values.elig_jh_date);
501: fnd_file.put_line(fnd_file.LOG,'p_pension_entry_values.opt_out_date : '||p_pension_entry_values.opt_out_date);
502:
503:
504:
505: l_string := l_string ||''||EOL;

Line 543: fnd_file.put_line(fnd_file.LOG,'No Opt-Out End Date found for this assignment');

539: LOOP
540: IF (p_pension_entry_values.opt_out_period_end_date) IS NOT NULL THEN
541: l_opt_out_new := greatest ((p_issue_date+30), fnd_date.canonical_to_date(p_pension_entry_values.opt_out_period_end_date));
542: ELSE
543: fnd_file.put_line(fnd_file.LOG,'No Opt-Out End Date found for this assignment');
544: END IF;
545: IF p_pension_entry_values.qualifying_scheme_exists = 'Y'
546: then l_scheme_exists := 'Yes';
547: ELSE l_scheme_exists := 'No';

Line 582: fnd_file.put_line(fnd_file.LOG,'Letter for the Non Eligible Job Holders');

578: ----------------------------------------------------------------------------------------------------
579: ----------------------------------------------------------------------------------------------------
580: IF P_LETTER = 'PYGBPAEIG2' and l_flag ='Y' THEN
581: --Letter for the Non Eligible Job Holders
582: fnd_file.put_line(fnd_file.LOG,'Letter for the Non Eligible Job Holders');
583:
584: OPEN c_comm_details_qual(P_PAYROLL,p_pension_entry_values.qualifying_scheme_name);
585: fetch c_comm_details_qual into l_signatory_name_pqs,l_contact_mail_pqs,l_instruction_pqs,l_more_info_pqs;
586: close c_comm_details_qual;

Line 603: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);

599: end if;
600:
601: IF NVL(p_pension_entry_values.postponement_end_date,l_prp_start_date) 602: and p_pension_entry_values.pension_classification = 'Non Eligible Job Holder' THEN
603: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
604:
605: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
606:
607: l_string := l_string ||''||EOL;

Line 605: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);

601: IF NVL(p_pension_entry_values.postponement_end_date,l_prp_start_date) 602: and p_pension_entry_values.pension_classification = 'Non Eligible Job Holder' THEN
603: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
604:
605: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
606:
607: l_string := l_string ||''||EOL;
608: l_string := l_string ||'

'||EOL;
609: l_string := l_string ||l_employee_name||EOL||EOL;

Line 647: fnd_file.put_line(fnd_file.LOG,'Letter for the Workers');

643: ----------------------------------------------------------------------------------------------------
644: ----------------------------------------------------------------------------------------------------
645: IF P_LETTER = 'PYGBPAEIG3' and l_flag ='Y' THEN
646: --Letter for the Workers
647: fnd_file.put_line(fnd_file.LOG,'Letter for the Workers');
648:
649:
650: OPEN c_comm_details_qual(P_PAYROLL,p_pension_entry_values.qualifying_scheme_name);
651: fetch c_comm_details_qual into l_signatory_name_pqs,l_contact_mail_pqs,l_instruction_pqs,l_more_info_pqs;

Line 669: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);

665: end if;
666: IF NVL(p_pension_entry_values.postponement_end_date,l_prp_start_date) 667: and NVL(p_pension_entry_values.qualifying_scheme_exists,'N') ='N'
668: and p_pension_entry_values.pension_classification = 'Worker' THEN
669: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
670:
671: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
672:
673: l_string := l_string ||''||EOL;

Line 671: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);

667: and NVL(p_pension_entry_values.qualifying_scheme_exists,'N') ='N'
668: and p_pension_entry_values.pension_classification = 'Worker' THEN
669: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
670:
671: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
672:
673: l_string := l_string ||''||EOL;
674: l_string := l_string ||'

'||EOL;
675: l_string := l_string ||l_employee_name||EOL||EOL;

Line 712: fnd_file.put_line(fnd_file.LOG,'Letter for who are already in Qualifying Pension Scheme');

708: ----------------------------------------------------------------------------------------------------
709: ----------------------------------------------------------------------------------------------------
710: IF P_LETTER = 'PYGBPAEIG4' and l_flag ='Y' THEN
711: --Letter for who are already in Qualifying Pension Scheme
712: fnd_file.put_line(fnd_file.LOG,'Letter for who are already in Qualifying Pension Scheme');
713:
714: OPEN c_comm_details_qual(P_PAYROLL,p_pension_entry_values.qualifying_scheme_name);
715: fetch c_comm_details_qual into l_signatory_name_pqs,l_contact_mail_pqs,l_instruction_pqs,l_more_info_pqs;
716: close c_comm_details_qual;

Line 733: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);

729: end if;
730:
731: IF p_pension_entry_values.auto_enrollment_date IS NULL
732: and NVL(p_pension_entry_values.qualifying_scheme_exists,'N') ='Y' THEN
733: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
734:
735: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
736:
737: l_string := l_string ||''||EOL;

Line 735: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);

731: IF p_pension_entry_values.auto_enrollment_date IS NULL
732: and NVL(p_pension_entry_values.qualifying_scheme_exists,'N') ='Y' THEN
733: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
734:
735: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
736:
737: l_string := l_string ||''||EOL;
738: l_string := l_string ||'

'||EOL;
739: l_string := l_string ||l_employee_name||EOL||EOL;

Line 777: fnd_file.put_line(fnd_file.LOG,'General Letter of Postponement (Redundant)');

773: ----------------------------------------------------------------------------------------------------
774: ----------------------------------------------------------------------------------------------------
775: IF P_LETTER = 'PYGBPAEIG5' and l_flag ='Y' THEN
776: --General Letter of Postponement Redundant
777: fnd_file.put_line(fnd_file.LOG,'General Letter of Postponement (Redundant)');
778:
779: OPEN c_comm_details_qual(P_PAYROLL,p_pension_entry_values.qualifying_scheme_name);
780: fetch c_comm_details_qual into l_signatory_name_pqs,l_contact_mail_pqs,l_instruction_pqs,l_more_info_pqs;
781: close c_comm_details_qual;

Line 799: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);

795:
796:
797: IF p_pension_entry_values.postponement_end_date >=l_prp_end_date
798: and p_pension_entry_values.auto_enrollment_date IS NULL THEN
799: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
800:
801: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
802: l_string := l_string ||''||EOL;
803: l_string := l_string ||'

'||EOL;

Line 801: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);

797: IF p_pension_entry_values.postponement_end_date >=l_prp_end_date
798: and p_pension_entry_values.auto_enrollment_date IS NULL THEN
799: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
800:
801: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
802: l_string := l_string ||''||EOL;
803: l_string := l_string ||'

'||EOL;
804: l_string := l_string ||l_employee_name||EOL||EOL;
805: l_string := l_string ||l_address.addr1||EOL;

Line 842: fnd_file.put_line(fnd_file.LOG,'General Letter of Postponement');

838: ----------------------------------------------------------------------------------------------------
839: ----------------------------------------------------------------------------------------------------
840: IF P_LETTER = 'PYGBPAEIG6' and l_flag ='Y' THEN
841: --General Letter of Postponement
842: fnd_file.put_line(fnd_file.LOG,'General Letter of Postponement');
843:
844: OPEN c_comm_details_qual(P_PAYROLL,p_pension_entry_values.qualifying_scheme_name);
845: fetch c_comm_details_qual into l_signatory_name_pqs,l_contact_mail_pqs,l_instruction_pqs,l_more_info_pqs;
846: close c_comm_details_qual;

Line 863: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);

859: end if;
860:
861: IF p_pension_entry_values.postponement_end_date >=l_prp_end_date
862: and p_pension_entry_values.auto_enrollment_date IS NULL THEN
863: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
864:
865: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
866: l_string := l_string ||''||EOL;
867: l_string := l_string ||'

'||EOL;

Line 865: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);

861: IF p_pension_entry_values.postponement_end_date >=l_prp_end_date
862: and p_pension_entry_values.auto_enrollment_date IS NULL THEN
863: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
864:
865: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
866: l_string := l_string ||''||EOL;
867: l_string := l_string ||'

'||EOL;
868: l_string := l_string ||l_employee_name||EOL||EOL;
869: l_string := l_string ||l_address.addr1||EOL;

Line 906: fnd_file.put_line(fnd_file.LOG,'Letter of DB Scheme Postponement');

902: ----------------------------------------------------------------------------------------------------
903: ----------------------------------------------------------------------------------------------------
904: IF P_LETTER = 'PYGBPAEIG7' and l_flag ='Y' THEN
905: --Letter of DB Scheme Postponement
906: fnd_file.put_line(fnd_file.LOG,'Letter of DB Scheme Postponement');
907:
908:
909: OPEN c_comm_details_qual(P_PAYROLL,p_pension_entry_values.qualifying_scheme_name);
910: fetch c_comm_details_qual into l_signatory_name_pqs,l_contact_mail_pqs,l_instruction_pqs,l_more_info_pqs;

Line 927: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);

923: l_more_info := l_more_info_pqs;
924: end if;
925: IF p_pension_entry_values.postponement_end_date >= l_prp_end_date
926: and p_pension_entry_values.postponement_type = 'DB Scheme Postponement' THEN
927: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
928:
929: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
930:
931: l_string := l_string ||''||EOL;

Line 929: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);

925: IF p_pension_entry_values.postponement_end_date >= l_prp_end_date
926: and p_pension_entry_values.postponement_type = 'DB Scheme Postponement' THEN
927: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
928:
929: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
930:
931: l_string := l_string ||''||EOL;
932: l_string := l_string ||'

'||EOL;
933: l_string := l_string ||l_employee_name||EOL||EOL;

Line 971: fnd_file.put_line(fnd_file.LOG,'Letter of Postponement for the Non Eligible Job Holders');

967: ----------------------------------------------------------------------------------------------------
968: ----------------------------------------------------------------------------------------------------
969: IF P_LETTER = 'PYGBPAEIG8' and l_flag ='Y' THEN
970: --Letter of Postponement for the Non Eligible Job Holders
971: fnd_file.put_line(fnd_file.LOG,'Letter of Postponement for the Non Eligible Job Holders');
972:
973:
974: OPEN c_comm_details_qual(P_PAYROLL,p_pension_entry_values.qualifying_scheme_name);
975: fetch c_comm_details_qual into l_signatory_name_pqs,l_contact_mail_pqs,l_instruction_pqs,l_more_info_pqs;

Line 993: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);

989: end if;
990: IF p_pension_entry_values.postponement_end_date >= l_prp_end_date
991: and NVL(p_pension_entry_values.postponement_type,'DB Scheme Postponement') <>'DB Scheme Postponement'
992: and p_pension_entry_values.pension_classification = 'Non Eligible Job Holder' THEN
993: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
994:
995: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
996: l_string := l_string ||''||EOL;
997: l_string := l_string ||'

'||EOL;

Line 995: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);

991: and NVL(p_pension_entry_values.postponement_type,'DB Scheme Postponement') <>'DB Scheme Postponement'
992: and p_pension_entry_values.pension_classification = 'Non Eligible Job Holder' THEN
993: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
994:
995: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
996: l_string := l_string ||''||EOL;
997: l_string := l_string ||'

'||EOL;
998: l_string := l_string ||l_employee_name||EOL||EOL;
999: l_string := l_string ||l_address.addr1||EOL;

Line 1036: fnd_file.put_line(fnd_file.LOG,'Letter of Postponement for the Workers');

1032: ----------------------------------------------------------------------------------------------------
1033: ----------------------------------------------------------------------------------------------------
1034: IF P_LETTER = 'PYGBPAEIG9' and l_flag ='Y' THEN
1035: --Letter of Postponement for the Workers
1036: fnd_file.put_line(fnd_file.LOG,'Letter of Postponement for the Workers');
1037:
1038:
1039: OPEN c_comm_details_qual(P_PAYROLL,p_pension_entry_values.qualifying_scheme_name);
1040: fetch c_comm_details_qual into l_signatory_name_pqs,l_contact_mail_pqs,l_instruction_pqs,l_more_info_pqs;

Line 1058: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);

1054: end if;
1055: IF p_pension_entry_values.postponement_end_date >= l_prp_end_date
1056: and NVL(p_pension_entry_values.postponement_type,'DB Scheme Postponement') <>'DB Scheme Postponement'
1057: and p_pension_entry_values.pension_classification = 'Worker' THEN
1058: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
1059:
1060: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
1061:
1062: l_string := l_string ||''||EOL;

Line 1060: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);

1056: and NVL(p_pension_entry_values.postponement_type,'DB Scheme Postponement') <>'DB Scheme Postponement'
1057: and p_pension_entry_values.pension_classification = 'Worker' THEN
1058: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||p_assignment_id);
1059:
1060: fnd_file.put_line(fnd_file.LOG,'Printing XML for the assignment id - '||p_assignment_id);
1061:
1062: l_string := l_string ||''||EOL;
1063: l_string := l_string ||'

'||EOL;
1064: l_string := l_string ||l_employee_name||EOL||EOL;

Line 1222: fnd_file.put_line(fnd_file.LOG,'Entering GENERATE');

1218: --------------------------------------
1219:
1220: BEGIN
1221:
1222: fnd_file.put_line(fnd_file.LOG,'Entering GENERATE');
1223: IF P_MODE = 'SUMMARY' THEN --Mode = SUMMARY
1224: IF P_LETTER = 'PYGBPAEIG1' THEN
1225: --Letter for the Automatically Enrolled
1226: fnd_file.put_line(fnd_file.OUTPUT,'Letter for the Automatically Enrolled');

Line 1226: fnd_file.put_line(fnd_file.OUTPUT,'Letter for the Automatically Enrolled');

1222: fnd_file.put_line(fnd_file.LOG,'Entering GENERATE');
1223: IF P_MODE = 'SUMMARY' THEN --Mode = SUMMARY
1224: IF P_LETTER = 'PYGBPAEIG1' THEN
1225: --Letter for the Automatically Enrolled
1226: fnd_file.put_line(fnd_file.OUTPUT,'Letter for the Automatically Enrolled');
1227:
1228: END IF;
1229: ----------------------------------------------------------------------------------------------------
1230: ----------------------------------------------------------------------------------------------------

Line 1233: fnd_file.put_line(fnd_file.OUTPUT,'Letter for the Non Eligible Job Holders');

1229: ----------------------------------------------------------------------------------------------------
1230: ----------------------------------------------------------------------------------------------------
1231: IF P_LETTER = 'PYGBPAEIG2' THEN
1232: --Letter for the Non Eligible Job Holders
1233: fnd_file.put_line(fnd_file.OUTPUT,'Letter for the Non Eligible Job Holders');
1234:
1235: END IF;
1236: ----------------------------------------------------------------------------------------------------
1237: ----------------------------------------------------------------------------------------------------

Line 1240: fnd_file.put_line(fnd_file.OUTPUT,'Letter for the Workers');

1236: ----------------------------------------------------------------------------------------------------
1237: ----------------------------------------------------------------------------------------------------
1238: IF P_LETTER = 'PYGBPAEIG3' THEN
1239: --Letter for the Workers
1240: fnd_file.put_line(fnd_file.OUTPUT,'Letter for the Workers');
1241:
1242: END IF;
1243: ----------------------------------------------------------------------------------------------------
1244: ----------------------------------------------------------------------------------------------------

Line 1247: fnd_file.put_line(fnd_file.OUTPUT,'Letter for who are already in Qualifying Pension Scheme');

1243: ----------------------------------------------------------------------------------------------------
1244: ----------------------------------------------------------------------------------------------------
1245: IF P_LETTER = 'PYGBPAEIG4' THEN
1246: --Letter for who are already in Qualifying Pension Scheme
1247: fnd_file.put_line(fnd_file.OUTPUT,'Letter for who are already in Qualifying Pension Scheme');
1248:
1249: END IF;
1250: ----------------------------------------------------------------------------------------------------
1251: ----------------------------------------------------------------------------------------------------

Line 1254: fnd_file.put_line(fnd_file.OUTPUT,'General Letter of Postponement (Redundant)');

1250: ----------------------------------------------------------------------------------------------------
1251: ----------------------------------------------------------------------------------------------------
1252: IF P_LETTER = 'PYGBPAEIG5' THEN
1253: --General Letter of Postponement Redundant
1254: fnd_file.put_line(fnd_file.OUTPUT,'General Letter of Postponement (Redundant)');
1255:
1256:
1257: END IF;
1258: ----------------------------------------------------------------------------------------------------

Line 1262: fnd_file.put_line(fnd_file.OUTPUT,'General Letter of Postponement');

1258: ----------------------------------------------------------------------------------------------------
1259: ----------------------------------------------------------------------------------------------------
1260: IF P_LETTER = 'PYGBPAEIG6' THEN
1261: --General Letter of Postponement
1262: fnd_file.put_line(fnd_file.OUTPUT,'General Letter of Postponement');
1263:
1264:
1265:
1266: END IF;

Line 1271: fnd_file.put_line(fnd_file.OUTPUT,'Letter of DB Scheme Postponement');

1267: ----------------------------------------------------------------------------------------------------
1268: ----------------------------------------------------------------------------------------------------
1269: IF P_LETTER = 'PYGBPAEIG7' THEN
1270: --Letter of DB Scheme Postponement
1271: fnd_file.put_line(fnd_file.OUTPUT,'Letter of DB Scheme Postponement');
1272:
1273: END IF;
1274: ----------------------------------------------------------------------------------------------------
1275: ----------------------------------------------------------------------------------------------------

Line 1278: fnd_file.put_line(fnd_file.OUTPUT,'Letter of Postponement for the Non Eligible Job Holders');

1274: ----------------------------------------------------------------------------------------------------
1275: ----------------------------------------------------------------------------------------------------
1276: IF P_LETTER = 'PYGBPAEIG8' THEN
1277: --Letter of Postponement for the Non Eligible Job Holders
1278: fnd_file.put_line(fnd_file.OUTPUT,'Letter of Postponement for the Non Eligible Job Holders');
1279:
1280:
1281: END IF;
1282: ----------------------------------------------------------------------------------------------------

Line 1286: fnd_file.put_line(fnd_file.OUTPUT,'Letter of Postponement for the Workers');

1282: ----------------------------------------------------------------------------------------------------
1283: ----------------------------------------------------------------------------------------------------
1284: IF P_LETTER = 'PYGBPAEIG9' THEN
1285: --Letter of Postponement for the Workers
1286: fnd_file.put_line(fnd_file.OUTPUT,'Letter of Postponement for the Workers');
1287:
1288: END IF;
1289: ----------------------------------------------------------------------------------------------------
1290: fnd_file.put_line(fnd_file.output,rpad('-',86,'-')) ;

Line 1290: fnd_file.put_line(fnd_file.output,rpad('-',86,'-')) ;

1286: fnd_file.put_line(fnd_file.OUTPUT,'Letter of Postponement for the Workers');
1287:
1288: END IF;
1289: ----------------------------------------------------------------------------------------------------
1290: fnd_file.put_line(fnd_file.output,rpad('-',86,'-')) ;
1291: fnd_file.put_line(fnd_file.output,rpad(' ',86)) ;
1292: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',35)||rpad('Employee Name',50)) ;
1293: fnd_file.put_line(fnd_file.output,rpad('-',86,'-')) ;
1294:

Line 1291: fnd_file.put_line(fnd_file.output,rpad(' ',86)) ;

1287:
1288: END IF;
1289: ----------------------------------------------------------------------------------------------------
1290: fnd_file.put_line(fnd_file.output,rpad('-',86,'-')) ;
1291: fnd_file.put_line(fnd_file.output,rpad(' ',86)) ;
1292: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',35)||rpad('Employee Name',50)) ;
1293: fnd_file.put_line(fnd_file.output,rpad('-',86,'-')) ;
1294:
1295: END IF; --Mode = SUMMARY

Line 1292: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',35)||rpad('Employee Name',50)) ;

1288: END IF;
1289: ----------------------------------------------------------------------------------------------------
1290: fnd_file.put_line(fnd_file.output,rpad('-',86,'-')) ;
1291: fnd_file.put_line(fnd_file.output,rpad(' ',86)) ;
1292: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',35)||rpad('Employee Name',50)) ;
1293: fnd_file.put_line(fnd_file.output,rpad('-',86,'-')) ;
1294:
1295: END IF; --Mode = SUMMARY
1296:

Line 1293: fnd_file.put_line(fnd_file.output,rpad('-',86,'-')) ;

1289: ----------------------------------------------------------------------------------------------------
1290: fnd_file.put_line(fnd_file.output,rpad('-',86,'-')) ;
1291: fnd_file.put_line(fnd_file.output,rpad(' ',86)) ;
1292: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',35)||rpad('Employee Name',50)) ;
1293: fnd_file.put_line(fnd_file.output,rpad('-',86,'-')) ;
1294:
1295: END IF; --Mode = SUMMARY
1296:
1297: IF P_MODE = 'GENMAIL' OR P_MODE = 'SUMMARY' THEN --Mode = SUMMARY THEN --Mode = Generate and Mail

Line 1298: fnd_file.put_line(fnd_file.LOG,'P_EMPLOYER ::'||P_EMPLOYER);

1294:
1295: END IF; --Mode = SUMMARY
1296:
1297: IF P_MODE = 'GENMAIL' OR P_MODE = 'SUMMARY' THEN --Mode = SUMMARY THEN --Mode = Generate and Mail
1298: fnd_file.put_line(fnd_file.LOG,'P_EMPLOYER ::'||P_EMPLOYER);
1299: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL ::'||P_PAYROLL);
1300: fnd_file.put_line(fnd_file.LOG,'P_PERIOD ::'||P_PERIOD);
1301: fnd_file.put_line(fnd_file.LOG,'P_LETTER ::'||P_LETTER);
1302:

Line 1299: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL ::'||P_PAYROLL);

1295: END IF; --Mode = SUMMARY
1296:
1297: IF P_MODE = 'GENMAIL' OR P_MODE = 'SUMMARY' THEN --Mode = SUMMARY THEN --Mode = Generate and Mail
1298: fnd_file.put_line(fnd_file.LOG,'P_EMPLOYER ::'||P_EMPLOYER);
1299: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL ::'||P_PAYROLL);
1300: fnd_file.put_line(fnd_file.LOG,'P_PERIOD ::'||P_PERIOD);
1301: fnd_file.put_line(fnd_file.LOG,'P_LETTER ::'||P_LETTER);
1302:
1303: OPEN c_payroll_details(p_period);

Line 1300: fnd_file.put_line(fnd_file.LOG,'P_PERIOD ::'||P_PERIOD);

1296:
1297: IF P_MODE = 'GENMAIL' OR P_MODE = 'SUMMARY' THEN --Mode = SUMMARY THEN --Mode = Generate and Mail
1298: fnd_file.put_line(fnd_file.LOG,'P_EMPLOYER ::'||P_EMPLOYER);
1299: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL ::'||P_PAYROLL);
1300: fnd_file.put_line(fnd_file.LOG,'P_PERIOD ::'||P_PERIOD);
1301: fnd_file.put_line(fnd_file.LOG,'P_LETTER ::'||P_LETTER);
1302:
1303: OPEN c_payroll_details(p_period);
1304: FETCH c_payroll_details INTO l_pay_start_date,l_pay_end_date,l_pay_date_paid;

Line 1301: fnd_file.put_line(fnd_file.LOG,'P_LETTER ::'||P_LETTER);

1297: IF P_MODE = 'GENMAIL' OR P_MODE = 'SUMMARY' THEN --Mode = SUMMARY THEN --Mode = Generate and Mail
1298: fnd_file.put_line(fnd_file.LOG,'P_EMPLOYER ::'||P_EMPLOYER);
1299: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL ::'||P_PAYROLL);
1300: fnd_file.put_line(fnd_file.LOG,'P_PERIOD ::'||P_PERIOD);
1301: fnd_file.put_line(fnd_file.LOG,'P_LETTER ::'||P_LETTER);
1302:
1303: OPEN c_payroll_details(p_period);
1304: FETCH c_payroll_details INTO l_pay_start_date,l_pay_end_date,l_pay_date_paid;
1305: CLOSE c_payroll_details;

Line 1306: fnd_file.put_line(fnd_file.LOG,'l_pay_start_date : '||fnd_date.date_to_canonical(l_pay_start_date));

1302:
1303: OPEN c_payroll_details(p_period);
1304: FETCH c_payroll_details INTO l_pay_start_date,l_pay_end_date,l_pay_date_paid;
1305: CLOSE c_payroll_details;
1306: fnd_file.put_line(fnd_file.LOG,'l_pay_start_date : '||fnd_date.date_to_canonical(l_pay_start_date));
1307: fnd_file.put_line(fnd_file.LOG,'l_pay_end_date : '||fnd_date.date_to_canonical(l_pay_end_date));
1308: fnd_file.put_line(fnd_file.LOG,'l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));
1309:
1310: OPEN cur_input_id;

Line 1307: fnd_file.put_line(fnd_file.LOG,'l_pay_end_date : '||fnd_date.date_to_canonical(l_pay_end_date));

1303: OPEN c_payroll_details(p_period);
1304: FETCH c_payroll_details INTO l_pay_start_date,l_pay_end_date,l_pay_date_paid;
1305: CLOSE c_payroll_details;
1306: fnd_file.put_line(fnd_file.LOG,'l_pay_start_date : '||fnd_date.date_to_canonical(l_pay_start_date));
1307: fnd_file.put_line(fnd_file.LOG,'l_pay_end_date : '||fnd_date.date_to_canonical(l_pay_end_date));
1308: fnd_file.put_line(fnd_file.LOG,'l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));
1309:
1310: OPEN cur_input_id;
1311: FETCH cur_input_id INTO l_input_value_ids;

Line 1308: fnd_file.put_line(fnd_file.LOG,'l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));

1304: FETCH c_payroll_details INTO l_pay_start_date,l_pay_end_date,l_pay_date_paid;
1305: CLOSE c_payroll_details;
1306: fnd_file.put_line(fnd_file.LOG,'l_pay_start_date : '||fnd_date.date_to_canonical(l_pay_start_date));
1307: fnd_file.put_line(fnd_file.LOG,'l_pay_end_date : '||fnd_date.date_to_canonical(l_pay_end_date));
1308: fnd_file.put_line(fnd_file.LOG,'l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));
1309:
1310: OPEN cur_input_id;
1311: FETCH cur_input_id INTO l_input_value_ids;
1312: CLOSE cur_input_id;

Line 1313: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);

1309:
1310: OPEN cur_input_id;
1311: FETCH cur_input_id INTO l_input_value_ids;
1312: CLOSE cur_input_id;
1313: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
1314: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
1315: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
1316: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1317: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);

Line 1314: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);

1310: OPEN cur_input_id;
1311: FETCH cur_input_id INTO l_input_value_ids;
1312: CLOSE cur_input_id;
1313: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
1314: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
1315: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
1316: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1317: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1318: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);

Line 1315: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);

1311: FETCH cur_input_id INTO l_input_value_ids;
1312: CLOSE cur_input_id;
1313: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
1314: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
1315: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
1316: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1317: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1318: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1319: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);

Line 1316: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);

1312: CLOSE cur_input_id;
1313: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
1314: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
1315: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
1316: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1317: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1318: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1319: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1320: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);

Line 1317: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);

1313: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
1314: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
1315: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
1316: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1317: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1318: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1319: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1320: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
1321: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);

Line 1318: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);

1314: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
1315: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
1316: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1317: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1318: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1319: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1320: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
1321: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
1322: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);

Line 1319: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);

1315: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
1316: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1317: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1318: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1319: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1320: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
1321: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
1322: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
1323: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);

Line 1320: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);

1316: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1317: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1318: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1319: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1320: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
1321: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
1322: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
1323: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
1324:

Line 1321: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);

1317: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1318: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1319: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1320: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
1321: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
1322: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
1323: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
1324:
1325: fnd_file.put_line(fnd_file.LOG,'Before l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));

Line 1322: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);

1318: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1319: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1320: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
1321: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
1322: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
1323: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
1324:
1325: fnd_file.put_line(fnd_file.LOG,'Before l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));
1326: fnd_file.put_line(fnd_file.LOG,'Before P_PAYROLL ::'||P_PAYROLL);

Line 1323: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);

1319: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1320: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
1321: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
1322: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
1323: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
1324:
1325: fnd_file.put_line(fnd_file.LOG,'Before l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));
1326: fnd_file.put_line(fnd_file.LOG,'Before P_PAYROLL ::'||P_PAYROLL);
1327: OPEN c_prp_details(p_payroll);

Line 1325: fnd_file.put_line(fnd_file.LOG,'Before l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));

1321: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
1322: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
1323: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
1324:
1325: fnd_file.put_line(fnd_file.LOG,'Before l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));
1326: fnd_file.put_line(fnd_file.LOG,'Before P_PAYROLL ::'||P_PAYROLL);
1327: OPEN c_prp_details(p_payroll);
1328: FETCH c_prp_details INTO l_prp_start_date,l_prp_end_date,l_prp_date_paid;
1329: CLOSE c_prp_details;

Line 1326: fnd_file.put_line(fnd_file.LOG,'Before P_PAYROLL ::'||P_PAYROLL);

1322: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
1323: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
1324:
1325: fnd_file.put_line(fnd_file.LOG,'Before l_pay_date_paid : '||fnd_date.date_to_canonical(l_pay_date_paid));
1326: fnd_file.put_line(fnd_file.LOG,'Before P_PAYROLL ::'||P_PAYROLL);
1327: OPEN c_prp_details(p_payroll);
1328: FETCH c_prp_details INTO l_prp_start_date,l_prp_end_date,l_prp_date_paid;
1329: CLOSE c_prp_details;
1330: fnd_file.put_line(fnd_file.LOG,'l_prp_start_date : '||l_prp_start_date);

Line 1330: fnd_file.put_line(fnd_file.LOG,'l_prp_start_date : '||l_prp_start_date);

1326: fnd_file.put_line(fnd_file.LOG,'Before P_PAYROLL ::'||P_PAYROLL);
1327: OPEN c_prp_details(p_payroll);
1328: FETCH c_prp_details INTO l_prp_start_date,l_prp_end_date,l_prp_date_paid;
1329: CLOSE c_prp_details;
1330: fnd_file.put_line(fnd_file.LOG,'l_prp_start_date : '||l_prp_start_date);
1331: fnd_file.put_line(fnd_file.LOG,'l_prp_end_date : '||l_prp_end_date);
1332: fnd_file.put_line(fnd_file.LOG,'l_prp_date_paid : '||l_prp_date_paid);
1333:
1334: l_string := l_string || ''||EOL;

Line 1331: fnd_file.put_line(fnd_file.LOG,'l_prp_end_date : '||l_prp_end_date);

1327: OPEN c_prp_details(p_payroll);
1328: FETCH c_prp_details INTO l_prp_start_date,l_prp_end_date,l_prp_date_paid;
1329: CLOSE c_prp_details;
1330: fnd_file.put_line(fnd_file.LOG,'l_prp_start_date : '||l_prp_start_date);
1331: fnd_file.put_line(fnd_file.LOG,'l_prp_end_date : '||l_prp_end_date);
1332: fnd_file.put_line(fnd_file.LOG,'l_prp_date_paid : '||l_prp_date_paid);
1333:
1334: l_string := l_string || ''||EOL;
1335:

Line 1332: fnd_file.put_line(fnd_file.LOG,'l_prp_date_paid : '||l_prp_date_paid);

1328: FETCH c_prp_details INTO l_prp_start_date,l_prp_end_date,l_prp_date_paid;
1329: CLOSE c_prp_details;
1330: fnd_file.put_line(fnd_file.LOG,'l_prp_start_date : '||l_prp_start_date);
1331: fnd_file.put_line(fnd_file.LOG,'l_prp_end_date : '||l_prp_end_date);
1332: fnd_file.put_line(fnd_file.LOG,'l_prp_date_paid : '||l_prp_date_paid);
1333:
1334: l_string := l_string || ''||EOL;
1335:
1336: FOR assignment in c_all_assignments_payroll

Line 1338: fnd_file.put_line(fnd_file.LOG,assignment.assignment_id);

1334: l_string := l_string || ''||EOL;
1335:
1336: FOR assignment in c_all_assignments_payroll
1337: LOOP -- Loop every assignment
1338: fnd_file.put_line(fnd_file.LOG,assignment.assignment_id);
1339: l_pension_entry_values := NULL;
1340: l_employee_name:= NULL;
1341: l_formula_id :=NULL;
1342: fnd_file.put_line(fnd_file.LOG,'Counter::'||counter);

Line 1342: fnd_file.put_line(fnd_file.LOG,'Counter::'||counter);

1338: fnd_file.put_line(fnd_file.LOG,assignment.assignment_id);
1339: l_pension_entry_values := NULL;
1340: l_employee_name:= NULL;
1341: l_formula_id :=NULL;
1342: fnd_file.put_line(fnd_file.LOG,'Counter::'||counter);
1343: --l_tab_asg_set_amnds := NULL;
1344: l_flag :='Y';
1345: IF P_ASSIGNMENT_SET is not null then
1346: l_flag :='N';

Line 1367: fnd_file.put_line(fnd_file.LOG,'Pensions Information Element Attached');

1363: FETCH c_pension_info_check into l_temp;
1364: close c_pension_info_check;
1365:
1366: IF l_temp =1 then -- Element Attached Check
1367: fnd_file.put_line(fnd_file.LOG,'Pensions Information Element Attached');
1368:
1369: OPEN c_pension_entry_values(assignment.assignment_id);
1370: FETCH c_pension_entry_values into l_pension_entry_values;
1371: CLOSE c_pension_entry_values;

Line 1372: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_name : '||l_pension_entry_values.qualifying_scheme_name);

1368:
1369: OPEN c_pension_entry_values(assignment.assignment_id);
1370: FETCH c_pension_entry_values into l_pension_entry_values;
1371: CLOSE c_pension_entry_values;
1372: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_name : '||l_pension_entry_values.qualifying_scheme_name);
1373: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.auto_enrollment_date : '||l_pension_entry_values.auto_enrollment_date);
1374: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);
1375: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1376: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);

Line 1373: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.auto_enrollment_date : '||l_pension_entry_values.auto_enrollment_date);

1369: OPEN c_pension_entry_values(assignment.assignment_id);
1370: FETCH c_pension_entry_values into l_pension_entry_values;
1371: CLOSE c_pension_entry_values;
1372: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_name : '||l_pension_entry_values.qualifying_scheme_name);
1373: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.auto_enrollment_date : '||l_pension_entry_values.auto_enrollment_date);
1374: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);
1375: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1376: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1377: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);

Line 1374: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);

1370: FETCH c_pension_entry_values into l_pension_entry_values;
1371: CLOSE c_pension_entry_values;
1372: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_name : '||l_pension_entry_values.qualifying_scheme_name);
1373: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.auto_enrollment_date : '||l_pension_entry_values.auto_enrollment_date);
1374: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);
1375: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1376: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1377: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1378: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);

Line 1375: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);

1371: CLOSE c_pension_entry_values;
1372: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_name : '||l_pension_entry_values.qualifying_scheme_name);
1373: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.auto_enrollment_date : '||l_pension_entry_values.auto_enrollment_date);
1374: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);
1375: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1376: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1377: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1378: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1379: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);

Line 1376: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);

1372: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_name : '||l_pension_entry_values.qualifying_scheme_name);
1373: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.auto_enrollment_date : '||l_pension_entry_values.auto_enrollment_date);
1374: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);
1375: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1376: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1377: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1378: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1379: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);
1380: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);

Line 1377: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);

1373: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.auto_enrollment_date : '||l_pension_entry_values.auto_enrollment_date);
1374: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);
1375: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1376: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1377: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1378: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1379: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);
1380: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);
1381: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);

Line 1378: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);

1374: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);
1375: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1376: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1377: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1378: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1379: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);
1380: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);
1381: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);
1382: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_date : '||l_pension_entry_values.opt_out_date);

Line 1379: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);

1375: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1376: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1377: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1378: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1379: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);
1380: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);
1381: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);
1382: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_date : '||l_pension_entry_values.opt_out_date);
1383:

Line 1380: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);

1376: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1377: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1378: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1379: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);
1380: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);
1381: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);
1382: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_date : '||l_pension_entry_values.opt_out_date);
1383:
1384:

Line 1381: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);

1377: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1378: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1379: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);
1380: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);
1381: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);
1382: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_date : '||l_pension_entry_values.opt_out_date);
1383:
1384:
1385: fnd_file.put_line(fnd_file.LOG,'Before Loop End');

Line 1382: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_date : '||l_pension_entry_values.opt_out_date);

1378: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1379: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);
1380: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);
1381: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);
1382: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_date : '||l_pension_entry_values.opt_out_date);
1383:
1384:
1385: fnd_file.put_line(fnd_file.LOG,'Before Loop End');
1386: IF P_MODE = 'SUMMARY' THEN --Mode = SUMMARY

Line 1385: fnd_file.put_line(fnd_file.LOG,'Before Loop End');

1381: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);
1382: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_date : '||l_pension_entry_values.opt_out_date);
1383:
1384:
1385: fnd_file.put_line(fnd_file.LOG,'Before Loop End');
1386: IF P_MODE = 'SUMMARY' THEN --Mode = SUMMARY
1387:
1388: open c_summary_details(assignment.assignment_id);
1389: fetch c_summary_details into l_assignment_number,l_employee_name;

Line 1396: fnd_file.put_line(fnd_file.LOG,'Letter for the Automatically Enrolled');

1392:
1393: ----------------------------------------------------------------------------------------------------
1394: IF P_LETTER = 'PYGBPAEIG1' and l_flag ='Y' THEN
1395: --Letter for the Automatically Enrolled
1396: fnd_file.put_line(fnd_file.LOG,'Letter for the Automatically Enrolled');
1397:
1398:
1399: IF l_pension_entry_values.auto_enrollment_date between l_prp_start_date and l_prp_end_date and
1400: NVL(l_pension_entry_values.qualifying_scheme_exists,'N') ='Y'

Line 1402: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);

1398:
1399: IF l_pension_entry_values.auto_enrollment_date between l_prp_start_date and l_prp_end_date and
1400: NVL(l_pension_entry_values.qualifying_scheme_exists,'N') ='Y'
1401: and l_pension_entry_values.pension_classification = 'Eligible Job Holder' THEN
1402: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1403: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1404: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1405: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1406:

Line 1403: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);

1399: IF l_pension_entry_values.auto_enrollment_date between l_prp_start_date and l_prp_end_date and
1400: NVL(l_pension_entry_values.qualifying_scheme_exists,'N') ='Y'
1401: and l_pension_entry_values.pension_classification = 'Eligible Job Holder' THEN
1402: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1403: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1404: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1405: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1406:
1407:

Line 1404: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);

1400: NVL(l_pension_entry_values.qualifying_scheme_exists,'N') ='Y'
1401: and l_pension_entry_values.pension_classification = 'Eligible Job Holder' THEN
1402: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1403: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1404: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1405: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1406:
1407:
1408: END IF;

Line 1405: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;

1401: and l_pension_entry_values.pension_classification = 'Eligible Job Holder' THEN
1402: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1403: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1404: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1405: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1406:
1407:
1408: END IF;
1409: END IF;

Line 1414: fnd_file.put_line(fnd_file.LOG,'Letter for the Non Eligible Job Holders');

1410: ----------------------------------------------------------------------------------------------------
1411: ----------------------------------------------------------------------------------------------------
1412: IF P_LETTER = 'PYGBPAEIG2' and l_flag ='Y' THEN
1413: --Letter for the Non Eligible Job Holders
1414: fnd_file.put_line(fnd_file.LOG,'Letter for the Non Eligible Job Holders');
1415:
1416:
1417: IF NVL(l_pension_entry_values.postponement_end_date,l_prp_start_date) 1418: and l_pension_entry_values.pension_classification = 'Non Eligible Job Holder' THEN

Line 1419: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);

1415:
1416:
1417: IF NVL(l_pension_entry_values.postponement_end_date,l_prp_start_date) 1418: and l_pension_entry_values.pension_classification = 'Non Eligible Job Holder' THEN
1419: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1420: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1421: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1422: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1423:

Line 1420: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);

1416:
1417: IF NVL(l_pension_entry_values.postponement_end_date,l_prp_start_date) 1418: and l_pension_entry_values.pension_classification = 'Non Eligible Job Holder' THEN
1419: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1420: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1421: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1422: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1423:
1424:

Line 1421: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);

1417: IF NVL(l_pension_entry_values.postponement_end_date,l_prp_start_date) 1418: and l_pension_entry_values.pension_classification = 'Non Eligible Job Holder' THEN
1419: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1420: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1421: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1422: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1423:
1424:
1425:

Line 1422: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;

1418: and l_pension_entry_values.pension_classification = 'Non Eligible Job Holder' THEN
1419: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1420: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1421: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1422: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1423:
1424:
1425:
1426: END IF;

Line 1432: fnd_file.put_line(fnd_file.LOG,'Letter for the Workers');

1428: ----------------------------------------------------------------------------------------------------
1429: ----------------------------------------------------------------------------------------------------
1430: IF P_LETTER = 'PYGBPAEIG3' and l_flag ='Y' THEN
1431: --Letter for the Workers
1432: fnd_file.put_line(fnd_file.LOG,'Letter for the Workers');
1433:
1434:
1435: IF NVL(l_pension_entry_values.postponement_end_date,l_prp_start_date) 1436: and NVL(l_pension_entry_values.qualifying_scheme_exists,'N') ='N'

Line 1438: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);

1434:
1435: IF NVL(l_pension_entry_values.postponement_end_date,l_prp_start_date) 1436: and NVL(l_pension_entry_values.qualifying_scheme_exists,'N') ='N'
1437: and l_pension_entry_values.pension_classification = 'Worker' THEN
1438: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1439: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1440: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1441: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1442:

Line 1439: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);

1435: IF NVL(l_pension_entry_values.postponement_end_date,l_prp_start_date) 1436: and NVL(l_pension_entry_values.qualifying_scheme_exists,'N') ='N'
1437: and l_pension_entry_values.pension_classification = 'Worker' THEN
1438: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1439: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1440: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1441: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1442:
1443:

Line 1440: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);

1436: and NVL(l_pension_entry_values.qualifying_scheme_exists,'N') ='N'
1437: and l_pension_entry_values.pension_classification = 'Worker' THEN
1438: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1439: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1440: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1441: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1442:
1443:
1444:

Line 1441: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;

1437: and l_pension_entry_values.pension_classification = 'Worker' THEN
1438: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1439: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1440: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1441: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1442:
1443:
1444:
1445: END IF;

Line 1451: fnd_file.put_line(fnd_file.LOG,'Letter for who are already in Qualifying Pension Scheme');

1447: ----------------------------------------------------------------------------------------------------
1448: ----------------------------------------------------------------------------------------------------
1449: IF P_LETTER = 'PYGBPAEIG4' and l_flag ='Y' THEN
1450: --Letter for who are already in Qualifying Pension Scheme
1451: fnd_file.put_line(fnd_file.LOG,'Letter for who are already in Qualifying Pension Scheme');
1452:
1453:
1454: IF l_pension_entry_values.auto_enrollment_date IS NULL
1455: and NVL(l_pension_entry_values.qualifying_scheme_exists,'N') ='Y' THEN

Line 1456: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);

1452:
1453:
1454: IF l_pension_entry_values.auto_enrollment_date IS NULL
1455: and NVL(l_pension_entry_values.qualifying_scheme_exists,'N') ='Y' THEN
1456: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1457: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1458: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1459: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1460:

Line 1457: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);

1453:
1454: IF l_pension_entry_values.auto_enrollment_date IS NULL
1455: and NVL(l_pension_entry_values.qualifying_scheme_exists,'N') ='Y' THEN
1456: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1457: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1458: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1459: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1460:
1461:

Line 1458: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);

1454: IF l_pension_entry_values.auto_enrollment_date IS NULL
1455: and NVL(l_pension_entry_values.qualifying_scheme_exists,'N') ='Y' THEN
1456: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1457: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1458: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1459: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1460:
1461:
1462:

Line 1459: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;

1455: and NVL(l_pension_entry_values.qualifying_scheme_exists,'N') ='Y' THEN
1456: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1457: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1458: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1459: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1460:
1461:
1462:
1463: END IF;

Line 1469: fnd_file.put_line(fnd_file.LOG,'General Letter of Postponement (Redundant)');

1465: ----------------------------------------------------------------------------------------------------
1466: ----------------------------------------------------------------------------------------------------
1467: IF P_LETTER = 'PYGBPAEIG5' and l_flag ='Y' THEN
1468: --General Letter of Postponement Redundant
1469: fnd_file.put_line(fnd_file.LOG,'General Letter of Postponement (Redundant)');
1470:
1471:
1472:
1473: IF l_pension_entry_values.postponement_end_date >=l_prp_end_date

Line 1475: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);

1471:
1472:
1473: IF l_pension_entry_values.postponement_end_date >=l_prp_end_date
1474: and l_pension_entry_values.auto_enrollment_date IS NULL THEN
1475: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1476: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1477: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1478: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1479:

Line 1476: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);

1472:
1473: IF l_pension_entry_values.postponement_end_date >=l_prp_end_date
1474: and l_pension_entry_values.auto_enrollment_date IS NULL THEN
1475: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1476: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1477: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1478: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1479:
1480:

Line 1477: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);

1473: IF l_pension_entry_values.postponement_end_date >=l_prp_end_date
1474: and l_pension_entry_values.auto_enrollment_date IS NULL THEN
1475: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1476: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1477: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1478: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1479:
1480:
1481:

Line 1478: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;

1474: and l_pension_entry_values.auto_enrollment_date IS NULL THEN
1475: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1476: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1477: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1478: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1479:
1480:
1481:
1482: END IF;

Line 1488: fnd_file.put_line(fnd_file.LOG,'General Letter of Postponement');

1484: ----------------------------------------------------------------------------------------------------
1485: ----------------------------------------------------------------------------------------------------
1486: IF P_LETTER = 'PYGBPAEIG6' and l_flag ='Y' THEN
1487: --General Letter of Postponement
1488: fnd_file.put_line(fnd_file.LOG,'General Letter of Postponement');
1489:
1490:
1491: IF l_pension_entry_values.postponement_end_date >=l_prp_end_date
1492: and l_pension_entry_values.auto_enrollment_date IS NULL THEN

Line 1493: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);

1489:
1490:
1491: IF l_pension_entry_values.postponement_end_date >=l_prp_end_date
1492: and l_pension_entry_values.auto_enrollment_date IS NULL THEN
1493: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1494: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1495: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1496: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1497:

Line 1494: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);

1490:
1491: IF l_pension_entry_values.postponement_end_date >=l_prp_end_date
1492: and l_pension_entry_values.auto_enrollment_date IS NULL THEN
1493: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1494: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1495: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1496: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1497:
1498:

Line 1495: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);

1491: IF l_pension_entry_values.postponement_end_date >=l_prp_end_date
1492: and l_pension_entry_values.auto_enrollment_date IS NULL THEN
1493: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1494: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1495: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1496: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1497:
1498:
1499:

Line 1496: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;

1492: and l_pension_entry_values.auto_enrollment_date IS NULL THEN
1493: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1494: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1495: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1496: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1497:
1498:
1499:
1500: END IF;

Line 1506: fnd_file.put_line(fnd_file.LOG,'Letter of DB Scheme Postponement');

1502: ----------------------------------------------------------------------------------------------------
1503: ----------------------------------------------------------------------------------------------------
1504: IF P_LETTER = 'PYGBPAEIG7' and l_flag ='Y' THEN
1505: --Letter of DB Scheme Postponement
1506: fnd_file.put_line(fnd_file.LOG,'Letter of DB Scheme Postponement');
1507:
1508:
1509: IF l_pension_entry_values.postponement_end_date >= l_prp_end_date
1510: and l_pension_entry_values.postponement_type = 'DB Scheme Postponement' THEN

Line 1511: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);

1507:
1508:
1509: IF l_pension_entry_values.postponement_end_date >= l_prp_end_date
1510: and l_pension_entry_values.postponement_type = 'DB Scheme Postponement' THEN
1511: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1512: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1513: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1514: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1515:

Line 1512: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);

1508:
1509: IF l_pension_entry_values.postponement_end_date >= l_prp_end_date
1510: and l_pension_entry_values.postponement_type = 'DB Scheme Postponement' THEN
1511: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1512: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1513: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1514: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1515:
1516:

Line 1513: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);

1509: IF l_pension_entry_values.postponement_end_date >= l_prp_end_date
1510: and l_pension_entry_values.postponement_type = 'DB Scheme Postponement' THEN
1511: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1512: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1513: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1514: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1515:
1516:
1517:

Line 1514: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;

1510: and l_pension_entry_values.postponement_type = 'DB Scheme Postponement' THEN
1511: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1512: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1513: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1514: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1515:
1516:
1517:
1518: END IF;

Line 1524: fnd_file.put_line(fnd_file.LOG,'Letter of Postponement for the Non Eligible Job Holders');

1520: ----------------------------------------------------------------------------------------------------
1521: ----------------------------------------------------------------------------------------------------
1522: IF P_LETTER = 'PYGBPAEIG8' and l_flag ='Y' THEN
1523: --Letter of Postponement for the Non Eligible Job Holders
1524: fnd_file.put_line(fnd_file.LOG,'Letter of Postponement for the Non Eligible Job Holders');
1525:
1526:
1527: IF l_pension_entry_values.postponement_end_date >= l_prp_end_date
1528: and NVL(l_pension_entry_values.postponement_type,'DB Scheme Postponement') <>'DB Scheme Postponement'

Line 1530: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);

1526:
1527: IF l_pension_entry_values.postponement_end_date >= l_prp_end_date
1528: and NVL(l_pension_entry_values.postponement_type,'DB Scheme Postponement') <>'DB Scheme Postponement'
1529: and l_pension_entry_values.pension_classification = 'Non Eligible Job Holder' THEN
1530: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1531: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1532: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1533: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1534:

Line 1531: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);

1527: IF l_pension_entry_values.postponement_end_date >= l_prp_end_date
1528: and NVL(l_pension_entry_values.postponement_type,'DB Scheme Postponement') <>'DB Scheme Postponement'
1529: and l_pension_entry_values.pension_classification = 'Non Eligible Job Holder' THEN
1530: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1531: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1532: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1533: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1534:
1535:

Line 1532: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);

1528: and NVL(l_pension_entry_values.postponement_type,'DB Scheme Postponement') <>'DB Scheme Postponement'
1529: and l_pension_entry_values.pension_classification = 'Non Eligible Job Holder' THEN
1530: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1531: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1532: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1533: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1534:
1535:
1536:

Line 1533: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;

1529: and l_pension_entry_values.pension_classification = 'Non Eligible Job Holder' THEN
1530: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1531: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1532: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1533: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1534:
1535:
1536:
1537: END IF;

Line 1543: fnd_file.put_line(fnd_file.LOG,'Letter of Postponement for the Workers');

1539: ----------------------------------------------------------------------------------------------------
1540: ----------------------------------------------------------------------------------------------------
1541: IF P_LETTER = 'PYGBPAEIG9' and l_flag ='Y' THEN
1542: --Letter of Postponement for the Workers
1543: fnd_file.put_line(fnd_file.LOG,'Letter of Postponement for the Workers');
1544:
1545:
1546: IF l_pension_entry_values.postponement_end_date >= l_prp_end_date
1547: and NVL(l_pension_entry_values.postponement_type,'DB Scheme Postponement') <>'DB Scheme Postponement'

Line 1549: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);

1545:
1546: IF l_pension_entry_values.postponement_end_date >= l_prp_end_date
1547: and NVL(l_pension_entry_values.postponement_type,'DB Scheme Postponement') <>'DB Scheme Postponement'
1548: and l_pension_entry_values.pension_classification = 'Worker' THEN
1549: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1550: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1551: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1552: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1553:

Line 1550: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);

1546: IF l_pension_entry_values.postponement_end_date >= l_prp_end_date
1547: and NVL(l_pension_entry_values.postponement_type,'DB Scheme Postponement') <>'DB Scheme Postponement'
1548: and l_pension_entry_values.pension_classification = 'Worker' THEN
1549: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1550: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1551: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1552: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1553:
1554:

Line 1551: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);

1547: and NVL(l_pension_entry_values.postponement_type,'DB Scheme Postponement') <>'DB Scheme Postponement'
1548: and l_pension_entry_values.pension_classification = 'Worker' THEN
1549: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1550: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1551: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1552: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1553:
1554:
1555: END IF;

Line 1552: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;

1548: and l_pension_entry_values.pension_classification = 'Worker' THEN
1549: fnd_file.put_line(fnd_file.LOG,'Assignment_id : '||assignment.assignment_id);
1550: fnd_file.put_line(fnd_file.LOG,'Assignment_Number : '||l_assignment_number);
1551: fnd_file.put_line(fnd_file.LOG,'l_employee_name : '||l_employee_name);
1552: fnd_file.put_line(fnd_file.output,rpad(l_assignment_number,35)||rpad(l_employee_name,50)) ;
1553:
1554:
1555: END IF;
1556: END IF;

Line 1568: fnd_file.put_line(fnd_file.LOG,'GENERATE_XML xml: '||l_string);

1564: fnd_date.canonical_to_date(p_issue_date),t_string );
1565:
1566: l_string := l_string || t_string;
1567:
1568: fnd_file.put_line(fnd_file.LOG,'GENERATE_XML xml: '||l_string);
1569: END IF;--Mode = Generate and Mail Inner
1570: ELSE--Element Attached Check
1571: fnd_file.put_line(fnd_file.LOG,'Pensions Information Element Not Attached');
1572: --continue;

Line 1571: fnd_file.put_line(fnd_file.LOG,'Pensions Information Element Not Attached');

1567:
1568: fnd_file.put_line(fnd_file.LOG,'GENERATE_XML xml: '||l_string);
1569: END IF;--Mode = Generate and Mail Inner
1570: ELSE--Element Attached Check
1571: fnd_file.put_line(fnd_file.LOG,'Pensions Information Element Not Attached');
1572: --continue;
1573: END IF;--Element Attached Check
1574: END IF;-- Assignment Set Check
1575: END LOOP;--Loop Every Assignment

Line 1580: fnd_file.put_line(fnd_file.LOG,'Request_id'||l_req_id);

1576: IF P_MODE = 'GENMAIL' THEN --Mode = Generate and Mail Inner
1577: l_req_id := fnd_global.conc_request_id ;
1578: l_string := l_string || ''||EOL;
1579:
1580: fnd_file.put_line(fnd_file.LOG,'Request_id'||l_req_id);
1581: fnd_file.put_line(fnd_file.LOG,'XML '||l_string);
1582:
1583: l_string := '' ||EOL ;--||''||EOL|| l_string||'';
1584:

Line 1581: fnd_file.put_line(fnd_file.LOG,'XML '||l_string);

1577: l_req_id := fnd_global.conc_request_id ;
1578: l_string := l_string || ''||EOL;
1579:
1580: fnd_file.put_line(fnd_file.LOG,'Request_id'||l_req_id);
1581: fnd_file.put_line(fnd_file.LOG,'XML '||l_string);
1582:
1583: l_string := '' ||EOL ;--||''||EOL|| l_string||'';
1584:
1585: ---------------------------------------------------------------------------------------

Line 1586: fnd_file.put_line(fnd_file.OUTPUT,l_string);

1582:
1583: l_string := '' ||EOL ;--||''||EOL|| l_string||'';
1584:
1585: ---------------------------------------------------------------------------------------
1586: fnd_file.put_line(fnd_file.OUTPUT,l_string);
1587: -- Working Section For XML BUrsting
1588: p_request_id :=fnd_global.conc_request_id;
1589: UPDATE fnd_concurrent_requests
1590: SET output_file_type = 'XML'

Line 1594: fnd_file.put_line(fnd_file.LOG,'Committed');

1590: SET output_file_type = 'XML'
1591: WHERE request_id = p_request_id;
1592:
1593: COMMIT ;
1594: fnd_file.put_line(fnd_file.LOG,'Committed');
1595: SELECT substr(p.product_version,1,2) INTO l_product_release
1596: FROM fnd_application a, fnd_application_tl t, fnd_product_installations p
1597: WHERE a.application_id = p.application_id
1598: AND a.application_id = t.application_id

Line 1601: fnd_file.put_line(fnd_file.LOG,'Check 1');

1597: WHERE a.application_id = p.application_id
1598: AND a.application_id = t.application_id
1599: AND t.language = Userenv ('LANG')
1600: AND Substr (a.application_short_name, 1, 5) = 'PAY';
1601: fnd_file.put_line(fnd_file.LOG,'Check 1');
1602: l_set_layout := fnd_request.add_layout('XDO','BURST_STATUS_REPORT','en','US','PDF');
1603: IF l_set_layout THEN
1604: fnd_file.put_line(fnd_file.LOG,'Check 2');
1605: ELSE

Line 1604: fnd_file.put_line(fnd_file.LOG,'Check 2');

1600: AND Substr (a.application_short_name, 1, 5) = 'PAY';
1601: fnd_file.put_line(fnd_file.LOG,'Check 1');
1602: l_set_layout := fnd_request.add_layout('XDO','BURST_STATUS_REPORT','en','US','PDF');
1603: IF l_set_layout THEN
1604: fnd_file.put_line(fnd_file.LOG,'Check 2');
1605: ELSE
1606: fnd_file.put_line(fnd_file.LOG,'Check 5');
1607: END IF;
1608:

Line 1606: fnd_file.put_line(fnd_file.LOG,'Check 5');

1602: l_set_layout := fnd_request.add_layout('XDO','BURST_STATUS_REPORT','en','US','PDF');
1603: IF l_set_layout THEN
1604: fnd_file.put_line(fnd_file.LOG,'Check 2');
1605: ELSE
1606: fnd_file.put_line(fnd_file.LOG,'Check 5');
1607: END IF;
1608:
1609: IF TO_NUMBER(l_product_release) = 11 THEN
1610: p_request_id := FND_REQUEST.SUBMIT_REQUEST('XDO','XDOBURSTREP',NULL,NULL,FALSE,p_request_id,'N');

Line 1611: fnd_file.put_line(fnd_file.LOG,'Check 3');

1607: END IF;
1608:
1609: IF TO_NUMBER(l_product_release) = 11 THEN
1610: p_request_id := FND_REQUEST.SUBMIT_REQUEST('XDO','XDOBURSTREP',NULL,NULL,FALSE,p_request_id,'N');
1611: fnd_file.put_line(fnd_file.LOG,'Check 3');
1612: ELSE
1613: p_request_id := FND_REQUEST.SUBMIT_REQUEST('XDO','XDOBURSTREP',NULL,NULL,FALSE,'Y',p_request_id,'Y');
1614: fnd_file.put_line(fnd_file.LOG,'Check 4');
1615: END IF;

Line 1614: fnd_file.put_line(fnd_file.LOG,'Check 4');

1610: p_request_id := FND_REQUEST.SUBMIT_REQUEST('XDO','XDOBURSTREP',NULL,NULL,FALSE,p_request_id,'N');
1611: fnd_file.put_line(fnd_file.LOG,'Check 3');
1612: ELSE
1613: p_request_id := FND_REQUEST.SUBMIT_REQUEST('XDO','XDOBURSTREP',NULL,NULL,FALSE,'Y',p_request_id,'Y');
1614: fnd_file.put_line(fnd_file.LOG,'Check 4');
1615: END IF;
1616:
1617: -- Working Section For XML Bursting
1618: End IF;--Mode = Generate and Mail Inner

Line 1711: fnd_file.put_line(fnd_file.LOG,'Entering generate_pdf');

1707:
1708:
1709: BEGIN
1710:
1711: fnd_file.put_line(fnd_file.LOG,'Entering generate_pdf');
1712: fnd_file.put_line(fnd_file.LOG,'P_EMPLOYER ::'||P_EMPLOYER);
1713: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL ::'||P_PAYROLL);
1714: fnd_file.put_line(fnd_file.LOG,'P_PERIOD ::'||P_PERIOD);
1715: fnd_file.put_line(fnd_file.LOG,'P_TEMPLATE_NAME ::'||P_TEMPLATE_NAME);

Line 1712: fnd_file.put_line(fnd_file.LOG,'P_EMPLOYER ::'||P_EMPLOYER);

1708:
1709: BEGIN
1710:
1711: fnd_file.put_line(fnd_file.LOG,'Entering generate_pdf');
1712: fnd_file.put_line(fnd_file.LOG,'P_EMPLOYER ::'||P_EMPLOYER);
1713: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL ::'||P_PAYROLL);
1714: fnd_file.put_line(fnd_file.LOG,'P_PERIOD ::'||P_PERIOD);
1715: fnd_file.put_line(fnd_file.LOG,'P_TEMPLATE_NAME ::'||P_TEMPLATE_NAME);
1716: fnd_file.put_line(fnd_file.LOG,'P_LETTER ::'||P_LETTER);

Line 1713: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL ::'||P_PAYROLL);

1709: BEGIN
1710:
1711: fnd_file.put_line(fnd_file.LOG,'Entering generate_pdf');
1712: fnd_file.put_line(fnd_file.LOG,'P_EMPLOYER ::'||P_EMPLOYER);
1713: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL ::'||P_PAYROLL);
1714: fnd_file.put_line(fnd_file.LOG,'P_PERIOD ::'||P_PERIOD);
1715: fnd_file.put_line(fnd_file.LOG,'P_TEMPLATE_NAME ::'||P_TEMPLATE_NAME);
1716: fnd_file.put_line(fnd_file.LOG,'P_LETTER ::'||P_LETTER);
1717:

Line 1714: fnd_file.put_line(fnd_file.LOG,'P_PERIOD ::'||P_PERIOD);

1710:
1711: fnd_file.put_line(fnd_file.LOG,'Entering generate_pdf');
1712: fnd_file.put_line(fnd_file.LOG,'P_EMPLOYER ::'||P_EMPLOYER);
1713: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL ::'||P_PAYROLL);
1714: fnd_file.put_line(fnd_file.LOG,'P_PERIOD ::'||P_PERIOD);
1715: fnd_file.put_line(fnd_file.LOG,'P_TEMPLATE_NAME ::'||P_TEMPLATE_NAME);
1716: fnd_file.put_line(fnd_file.LOG,'P_LETTER ::'||P_LETTER);
1717:
1718: OPEN c_payroll_details(p_period);

Line 1715: fnd_file.put_line(fnd_file.LOG,'P_TEMPLATE_NAME ::'||P_TEMPLATE_NAME);

1711: fnd_file.put_line(fnd_file.LOG,'Entering generate_pdf');
1712: fnd_file.put_line(fnd_file.LOG,'P_EMPLOYER ::'||P_EMPLOYER);
1713: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL ::'||P_PAYROLL);
1714: fnd_file.put_line(fnd_file.LOG,'P_PERIOD ::'||P_PERIOD);
1715: fnd_file.put_line(fnd_file.LOG,'P_TEMPLATE_NAME ::'||P_TEMPLATE_NAME);
1716: fnd_file.put_line(fnd_file.LOG,'P_LETTER ::'||P_LETTER);
1717:
1718: OPEN c_payroll_details(p_period);
1719: FETCH c_payroll_details INTO l_pay_start_date,l_pay_end_date,l_pay_date_paid;

Line 1716: fnd_file.put_line(fnd_file.LOG,'P_LETTER ::'||P_LETTER);

1712: fnd_file.put_line(fnd_file.LOG,'P_EMPLOYER ::'||P_EMPLOYER);
1713: fnd_file.put_line(fnd_file.LOG,'P_PAYROLL ::'||P_PAYROLL);
1714: fnd_file.put_line(fnd_file.LOG,'P_PERIOD ::'||P_PERIOD);
1715: fnd_file.put_line(fnd_file.LOG,'P_TEMPLATE_NAME ::'||P_TEMPLATE_NAME);
1716: fnd_file.put_line(fnd_file.LOG,'P_LETTER ::'||P_LETTER);
1717:
1718: OPEN c_payroll_details(p_period);
1719: FETCH c_payroll_details INTO l_pay_start_date,l_pay_end_date,l_pay_date_paid;
1720: CLOSE c_payroll_details;

Line 1721: fnd_file.put_line(fnd_file.LOG,'l_pay_start_date : '||l_pay_start_date);

1717:
1718: OPEN c_payroll_details(p_period);
1719: FETCH c_payroll_details INTO l_pay_start_date,l_pay_end_date,l_pay_date_paid;
1720: CLOSE c_payroll_details;
1721: fnd_file.put_line(fnd_file.LOG,'l_pay_start_date : '||l_pay_start_date);
1722: fnd_file.put_line(fnd_file.LOG,'l_pay_end_date : '||l_pay_end_date);
1723: fnd_file.put_line(fnd_file.LOG,'l_pay_date_paid : '||l_pay_date_paid);
1724:
1725: OPEN cur_input_id;

Line 1722: fnd_file.put_line(fnd_file.LOG,'l_pay_end_date : '||l_pay_end_date);

1718: OPEN c_payroll_details(p_period);
1719: FETCH c_payroll_details INTO l_pay_start_date,l_pay_end_date,l_pay_date_paid;
1720: CLOSE c_payroll_details;
1721: fnd_file.put_line(fnd_file.LOG,'l_pay_start_date : '||l_pay_start_date);
1722: fnd_file.put_line(fnd_file.LOG,'l_pay_end_date : '||l_pay_end_date);
1723: fnd_file.put_line(fnd_file.LOG,'l_pay_date_paid : '||l_pay_date_paid);
1724:
1725: OPEN cur_input_id;
1726: FETCH cur_input_id INTO l_input_value_ids;

Line 1723: fnd_file.put_line(fnd_file.LOG,'l_pay_date_paid : '||l_pay_date_paid);

1719: FETCH c_payroll_details INTO l_pay_start_date,l_pay_end_date,l_pay_date_paid;
1720: CLOSE c_payroll_details;
1721: fnd_file.put_line(fnd_file.LOG,'l_pay_start_date : '||l_pay_start_date);
1722: fnd_file.put_line(fnd_file.LOG,'l_pay_end_date : '||l_pay_end_date);
1723: fnd_file.put_line(fnd_file.LOG,'l_pay_date_paid : '||l_pay_date_paid);
1724:
1725: OPEN cur_input_id;
1726: FETCH cur_input_id INTO l_input_value_ids;
1727: CLOSE cur_input_id;

Line 1728: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);

1724:
1725: OPEN cur_input_id;
1726: FETCH cur_input_id INTO l_input_value_ids;
1727: CLOSE cur_input_id;
1728: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
1729: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
1730: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
1731: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1732: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);

Line 1729: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);

1725: OPEN cur_input_id;
1726: FETCH cur_input_id INTO l_input_value_ids;
1727: CLOSE cur_input_id;
1728: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
1729: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
1730: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
1731: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1732: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1733: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);

Line 1730: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);

1726: FETCH cur_input_id INTO l_input_value_ids;
1727: CLOSE cur_input_id;
1728: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
1729: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
1730: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
1731: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1732: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1733: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1734: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);

Line 1731: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);

1727: CLOSE cur_input_id;
1728: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
1729: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
1730: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
1731: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1732: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1733: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1734: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1735: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);

Line 1732: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);

1728: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_name : '||l_input_value_ids.qualifying_scheme_name);
1729: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
1730: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
1731: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1732: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1733: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1734: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1735: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
1736: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);

Line 1733: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);

1729: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.auto_enrollment_date : '||l_input_value_ids.auto_enrollment_date);
1730: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
1731: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1732: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1733: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1734: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1735: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
1736: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
1737: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);

Line 1734: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);

1730: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.pension_classification : '||l_input_value_ids.pension_classification);
1731: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1732: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1733: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1734: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1735: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
1736: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
1737: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
1738: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);

Line 1735: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);

1731: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_period_end_date : '||l_input_value_ids.opt_out_period_end_date);
1732: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1733: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1734: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1735: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
1736: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
1737: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
1738: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
1739:

Line 1736: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);

1732: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.total_earning_prp : '||l_input_value_ids.total_earning_prp);
1733: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1734: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1735: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
1736: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
1737: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
1738: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
1739:
1740: OPEN c_prp_details(p_payroll);

Line 1737: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);

1733: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_type : '||l_input_value_ids.postponement_type);
1734: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1735: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
1736: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
1737: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
1738: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
1739:
1740: OPEN c_prp_details(p_payroll);
1741: FETCH c_prp_details INTO l_prp_start_date,l_prp_end_date,l_prp_date_paid;

Line 1738: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);

1734: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.postponement_end_date : '||l_input_value_ids.postponement_end_date);
1735: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.qualifying_scheme_exists : '||l_input_value_ids.qualifying_scheme_exists);
1736: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_in_date : '||l_input_value_ids.opt_in_date);
1737: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.elig_jh_date : '||l_input_value_ids.elig_jh_date);
1738: fnd_file.put_line(fnd_file.LOG,'l_input_value_ids.opt_out_date : '||l_input_value_ids.opt_out_date);
1739:
1740: OPEN c_prp_details(p_payroll);
1741: FETCH c_prp_details INTO l_prp_start_date,l_prp_end_date,l_prp_date_paid;
1742: CLOSE c_prp_details;

Line 1743: fnd_file.put_line(fnd_file.LOG,'l_prp_start_date : '||l_prp_start_date);

1739:
1740: OPEN c_prp_details(p_payroll);
1741: FETCH c_prp_details INTO l_prp_start_date,l_prp_end_date,l_prp_date_paid;
1742: CLOSE c_prp_details;
1743: fnd_file.put_line(fnd_file.LOG,'l_prp_start_date : '||l_prp_start_date);
1744: fnd_file.put_line(fnd_file.LOG,'l_prp_end_date : '||l_prp_end_date);
1745: fnd_file.put_line(fnd_file.LOG,'l_prp_date_paid : '||l_prp_date_paid);
1746:
1747: l_string := l_string || ''||EOL;

Line 1744: fnd_file.put_line(fnd_file.LOG,'l_prp_end_date : '||l_prp_end_date);

1740: OPEN c_prp_details(p_payroll);
1741: FETCH c_prp_details INTO l_prp_start_date,l_prp_end_date,l_prp_date_paid;
1742: CLOSE c_prp_details;
1743: fnd_file.put_line(fnd_file.LOG,'l_prp_start_date : '||l_prp_start_date);
1744: fnd_file.put_line(fnd_file.LOG,'l_prp_end_date : '||l_prp_end_date);
1745: fnd_file.put_line(fnd_file.LOG,'l_prp_date_paid : '||l_prp_date_paid);
1746:
1747: l_string := l_string || ''||EOL;
1748:

Line 1745: fnd_file.put_line(fnd_file.LOG,'l_prp_date_paid : '||l_prp_date_paid);

1741: FETCH c_prp_details INTO l_prp_start_date,l_prp_end_date,l_prp_date_paid;
1742: CLOSE c_prp_details;
1743: fnd_file.put_line(fnd_file.LOG,'l_prp_start_date : '||l_prp_start_date);
1744: fnd_file.put_line(fnd_file.LOG,'l_prp_end_date : '||l_prp_end_date);
1745: fnd_file.put_line(fnd_file.LOG,'l_prp_date_paid : '||l_prp_date_paid);
1746:
1747: l_string := l_string || ''||EOL;
1748:
1749: FOR assignment in c_all_assignments_payroll

Line 1751: fnd_file.put_line(fnd_file.LOG,assignment.assignment_id);

1747: l_string := l_string || ''||EOL;
1748:
1749: FOR assignment in c_all_assignments_payroll
1750: LOOP -- Loop every assignment
1751: fnd_file.put_line(fnd_file.LOG,assignment.assignment_id);
1752: l_pension_entry_values := NULL;
1753: l_employee_name:= NULL;
1754: l_formula_id :=NULL;
1755: fnd_file.put_line(fnd_file.LOG,'Counter::'||counter);

Line 1755: fnd_file.put_line(fnd_file.LOG,'Counter::'||counter);

1751: fnd_file.put_line(fnd_file.LOG,assignment.assignment_id);
1752: l_pension_entry_values := NULL;
1753: l_employee_name:= NULL;
1754: l_formula_id :=NULL;
1755: fnd_file.put_line(fnd_file.LOG,'Counter::'||counter);
1756: --l_tab_asg_set_amnds := NULL;
1757: IF P_ASSIGNMENT_SET is not null then
1758: pqp_budget_maintenance.get_asg_set_details(p_assignment_set_id => P_ASSIGNMENT_SET
1759: ,p_formula_id => l_formula_id

Line 1780: fnd_file.put_line(fnd_file.LOG,'Pensions Information Element Attached');

1776: FETCH c_pension_info_check into l_temp;
1777: close c_pension_info_check;
1778:
1779: IF l_temp =1 then--Element attached Check
1780: fnd_file.put_line(fnd_file.LOG,'Pensions Information Element Attached');
1781:
1782:
1783: OPEN c_pension_entry_values(assignment.assignment_id);
1784: FETCH c_pension_entry_values into l_pension_entry_values;

Line 1786: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_name : '||l_pension_entry_values.qualifying_scheme_name);

1782:
1783: OPEN c_pension_entry_values(assignment.assignment_id);
1784: FETCH c_pension_entry_values into l_pension_entry_values;
1785: CLOSE c_pension_entry_values;
1786: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_name : '||l_pension_entry_values.qualifying_scheme_name);
1787: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.auto_enrollment_date : '||l_pension_entry_values.auto_enrollment_date);
1788: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);
1789: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1790: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);

Line 1787: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.auto_enrollment_date : '||l_pension_entry_values.auto_enrollment_date);

1783: OPEN c_pension_entry_values(assignment.assignment_id);
1784: FETCH c_pension_entry_values into l_pension_entry_values;
1785: CLOSE c_pension_entry_values;
1786: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_name : '||l_pension_entry_values.qualifying_scheme_name);
1787: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.auto_enrollment_date : '||l_pension_entry_values.auto_enrollment_date);
1788: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);
1789: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1790: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1791: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);

Line 1788: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);

1784: FETCH c_pension_entry_values into l_pension_entry_values;
1785: CLOSE c_pension_entry_values;
1786: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_name : '||l_pension_entry_values.qualifying_scheme_name);
1787: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.auto_enrollment_date : '||l_pension_entry_values.auto_enrollment_date);
1788: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);
1789: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1790: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1791: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1792: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);

Line 1789: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);

1785: CLOSE c_pension_entry_values;
1786: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_name : '||l_pension_entry_values.qualifying_scheme_name);
1787: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.auto_enrollment_date : '||l_pension_entry_values.auto_enrollment_date);
1788: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);
1789: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1790: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1791: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1792: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1793: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);

Line 1790: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);

1786: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_name : '||l_pension_entry_values.qualifying_scheme_name);
1787: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.auto_enrollment_date : '||l_pension_entry_values.auto_enrollment_date);
1788: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);
1789: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1790: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1791: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1792: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1793: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);
1794: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);

Line 1791: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);

1787: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.auto_enrollment_date : '||l_pension_entry_values.auto_enrollment_date);
1788: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);
1789: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1790: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1791: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1792: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1793: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);
1794: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);
1795: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);

Line 1792: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);

1788: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.pension_classification : '||l_pension_entry_values.pension_classification);
1789: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1790: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1791: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1792: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1793: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);
1794: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);
1795: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);
1796: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_date : '||l_pension_entry_values.opt_out_date);

Line 1793: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);

1789: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_period_end_date : '||l_pension_entry_values.opt_out_period_end_date);
1790: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1791: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1792: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1793: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);
1794: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);
1795: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);
1796: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_date : '||l_pension_entry_values.opt_out_date);
1797:

Line 1794: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);

1790: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.total_earning_prp : '||l_pension_entry_values.total_earning_prp);
1791: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1792: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1793: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);
1794: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);
1795: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);
1796: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_date : '||l_pension_entry_values.opt_out_date);
1797:
1798:

Line 1795: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);

1791: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_type : '||l_pension_entry_values.postponement_type);
1792: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1793: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);
1794: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);
1795: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);
1796: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_date : '||l_pension_entry_values.opt_out_date);
1797:
1798:
1799: fnd_file.put_line(fnd_file.LOG,'Before GENERATE_XML');

Line 1796: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_date : '||l_pension_entry_values.opt_out_date);

1792: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.postponement_end_date : '||l_pension_entry_values.postponement_end_date);
1793: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.qualifying_scheme_exists : '||l_pension_entry_values.qualifying_scheme_exists);
1794: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_in_date : '||l_pension_entry_values.opt_in_date);
1795: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);
1796: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_date : '||l_pension_entry_values.opt_out_date);
1797:
1798:
1799: fnd_file.put_line(fnd_file.LOG,'Before GENERATE_XML');
1800: generate_xml(p_letter ,assignment.assignment_id ,l_pension_entry_values ,P_PERIOD,p_payroll ,

Line 1799: fnd_file.put_line(fnd_file.LOG,'Before GENERATE_XML');

1795: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.elig_jh_date : '||l_pension_entry_values.elig_jh_date);
1796: fnd_file.put_line(fnd_file.LOG,'l_pension_entry_values.opt_out_date : '||l_pension_entry_values.opt_out_date);
1797:
1798:
1799: fnd_file.put_line(fnd_file.LOG,'Before GENERATE_XML');
1800: generate_xml(p_letter ,assignment.assignment_id ,l_pension_entry_values ,P_PERIOD,p_payroll ,
1801: fnd_date.canonical_to_date(p_issue_date),t_string );
1802:
1803: l_string := l_string || t_string;

Line 1805: fnd_file.put_line(fnd_file.LOG,'GENERATE_XML xml: '||l_string);

1801: fnd_date.canonical_to_date(p_issue_date),t_string );
1802:
1803: l_string := l_string || t_string;
1804:
1805: fnd_file.put_line(fnd_file.LOG,'GENERATE_XML xml: '||l_string);
1806:
1807:
1808: fnd_file.put_line(fnd_file.LOG,'Before Loop End');
1809: ELSE-- Element Attached Check

Line 1808: fnd_file.put_line(fnd_file.LOG,'Before Loop End');

1804:
1805: fnd_file.put_line(fnd_file.LOG,'GENERATE_XML xml: '||l_string);
1806:
1807:
1808: fnd_file.put_line(fnd_file.LOG,'Before Loop End');
1809: ELSE-- Element Attached Check
1810: fnd_file.put_line(fnd_file.LOG,'Pensions Information Element NOT Attached');
1811: --continue;
1812: END IF;

Line 1810: fnd_file.put_line(fnd_file.LOG,'Pensions Information Element NOT Attached');

1806:
1807:
1808: fnd_file.put_line(fnd_file.LOG,'Before Loop End');
1809: ELSE-- Element Attached Check
1810: fnd_file.put_line(fnd_file.LOG,'Pensions Information Element NOT Attached');
1811: --continue;
1812: END IF;
1813: END IF;-- Assignment Set Check
1814:

Line 1824: --fnd_file.put_line(fnd_file.LOG,'Request_id'||l_req_id);

1820: */
1821: l_string := l_string || ''||EOL;
1822: --l_req_id := fnd_global.conc_request_id ;
1823:
1824: --fnd_file.put_line(fnd_file.LOG,'Request_id'||l_req_id);
1825: fnd_file.put_line(fnd_file.LOG,'XML '||l_string);
1826: /*
1827: IF l_string is null then
1828: l_string := l_string || ''||EOL;

Line 1825: fnd_file.put_line(fnd_file.LOG,'XML '||l_string);

1821: l_string := l_string || ''||EOL;
1822: --l_req_id := fnd_global.conc_request_id ;
1823:
1824: --fnd_file.put_line(fnd_file.LOG,'Request_id'||l_req_id);
1825: fnd_file.put_line(fnd_file.LOG,'XML '||l_string);
1826: /*
1827: IF l_string is null then
1828: l_string := l_string || ''||EOL;
1829: end if;*/