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

Line 125: fnd_file.put_line(fnd_file.log,'Entering Procedure GET_ALL_PARAMETER ');

121:
122: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
123:
124: BEGIN
125: fnd_file.put_line(fnd_file.log,'Entering Procedure GET_ALL_PARAMETER ');
126: fnd_file.put_line(fnd_file.log,'Payroill Action iD ' || p_payroll_action_id );
127: OPEN csr_parameter_info (p_payroll_action_id);
128: --FETCH csr_parameter_info into lr_parameter_info;
129: FETCH csr_parameter_info

Line 126: fnd_file.put_line(fnd_file.log,'Payroill Action iD ' || p_payroll_action_id );

122: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
123:
124: BEGIN
125: fnd_file.put_line(fnd_file.log,'Entering Procedure GET_ALL_PARAMETER ');
126: fnd_file.put_line(fnd_file.log,'Payroill Action iD ' || p_payroll_action_id );
127: OPEN csr_parameter_info (p_payroll_action_id);
128: --FETCH csr_parameter_info into lr_parameter_info;
129: FETCH csr_parameter_info
130: INTO p_pension_ins_num

Line 140: fnd_file.put_line(fnd_file.log,'After csr_parameter_info in ' );

136: ,p_effective_date
137: ,p_business_group_id;
138: CLOSE csr_parameter_info;
139:
140: fnd_file.put_line(fnd_file.log,'After csr_parameter_info in ' );
141: fnd_file.put_line(fnd_file.log,'After p_pension_provider_id ' || g_pension_provider_id);
142: fnd_file.put_line(fnd_file.log,'After p_legal_employer_id in ' || p_legal_employer_id);
143: fnd_file.put_line(fnd_file.log,'After p_local_unit_id in ' || p_local_unit_id );
144: fnd_file.put_line(fnd_file.log,'After p_archive' || p_archive );

Line 141: fnd_file.put_line(fnd_file.log,'After p_pension_provider_id ' || g_pension_provider_id);

137: ,p_business_group_id;
138: CLOSE csr_parameter_info;
139:
140: fnd_file.put_line(fnd_file.log,'After csr_parameter_info in ' );
141: fnd_file.put_line(fnd_file.log,'After p_pension_provider_id ' || g_pension_provider_id);
142: fnd_file.put_line(fnd_file.log,'After p_legal_employer_id in ' || p_legal_employer_id);
143: fnd_file.put_line(fnd_file.log,'After p_local_unit_id in ' || p_local_unit_id );
144: fnd_file.put_line(fnd_file.log,'After p_archive' || p_archive );
145:

Line 142: fnd_file.put_line(fnd_file.log,'After p_legal_employer_id in ' || p_legal_employer_id);

138: CLOSE csr_parameter_info;
139:
140: fnd_file.put_line(fnd_file.log,'After csr_parameter_info in ' );
141: fnd_file.put_line(fnd_file.log,'After p_pension_provider_id ' || g_pension_provider_id);
142: fnd_file.put_line(fnd_file.log,'After p_legal_employer_id in ' || p_legal_employer_id);
143: fnd_file.put_line(fnd_file.log,'After p_local_unit_id in ' || p_local_unit_id );
144: fnd_file.put_line(fnd_file.log,'After p_archive' || p_archive );
145:
146: IF g_debug THEN

Line 143: fnd_file.put_line(fnd_file.log,'After p_local_unit_id in ' || p_local_unit_id );

139:
140: fnd_file.put_line(fnd_file.log,'After csr_parameter_info in ' );
141: fnd_file.put_line(fnd_file.log,'After p_pension_provider_id ' || g_pension_provider_id);
142: fnd_file.put_line(fnd_file.log,'After p_legal_employer_id in ' || p_legal_employer_id);
143: fnd_file.put_line(fnd_file.log,'After p_local_unit_id in ' || p_local_unit_id );
144: fnd_file.put_line(fnd_file.log,'After p_archive' || p_archive );
145:
146: IF g_debug THEN
147: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);

Line 144: fnd_file.put_line(fnd_file.log,'After p_archive' || p_archive );

140: fnd_file.put_line(fnd_file.log,'After csr_parameter_info in ' );
141: fnd_file.put_line(fnd_file.log,'After p_pension_provider_id ' || g_pension_provider_id);
142: fnd_file.put_line(fnd_file.log,'After p_legal_employer_id in ' || p_legal_employer_id);
143: fnd_file.put_line(fnd_file.log,'After p_local_unit_id in ' || p_local_unit_id );
144: fnd_file.put_line(fnd_file.log,'After p_archive' || p_archive );
145:
146: IF g_debug THEN
147: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
148: END IF;

Line 322: fnd_file.put_line(fnd_file.log,'In RANGE_CODE 0');

318: -- Archiving the data , as this will fire once
319:
320: BEGIN
321:
322: fnd_file.put_line(fnd_file.log,'In RANGE_CODE 0');
323:
324: IF g_debug THEN
325: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
326: END IF;

Line 389: fnd_file.put_line(fnd_file.log,'l_Insurance_pol_number ==> '||l_Insurance_pol_number );

385: CLOSE csr_department_code;
386:
387: l_Insurance_pol_number :=lr_pension_provider.ORG_INFORMATION8;
388: l_Pension_group_code :=lr_pension_provider.ORG_INFORMATION5;
389: fnd_file.put_line(fnd_file.log,'l_Insurance_pol_number ==> '||l_Insurance_pol_number );
390: fnd_file.put_line(fnd_file.log,'l_Pension_group_code ==> '||l_Pension_group_code );
391: */
392: -- *****************************************************************************
393: -- To pick Up the Pension Provider Name

Line 390: fnd_file.put_line(fnd_file.log,'l_Pension_group_code ==> '||l_Pension_group_code );

386:
387: l_Insurance_pol_number :=lr_pension_provider.ORG_INFORMATION8;
388: l_Pension_group_code :=lr_pension_provider.ORG_INFORMATION5;
389: fnd_file.put_line(fnd_file.log,'l_Insurance_pol_number ==> '||l_Insurance_pol_number );
390: fnd_file.put_line(fnd_file.log,'l_Pension_group_code ==> '||l_Pension_group_code );
391: */
392: -- *****************************************************************************
393: -- To pick Up the Pension Provider Name
394: OPEN csr_pension_provider_details(lr_pension_provider.org_information4);

Line 458: fnd_file.put_line(fnd_file.log,' ================================ ' );

454: p_action_information30=> NULL
455: );
456: -- *********************************************************************
457:
458: fnd_file.put_line(fnd_file.log,' ================================ ' );
459: fnd_file.put_line(fnd_file.log,'Local Unit Not Null' );
460: fnd_file.put_line(fnd_file.log,'Name ==> '||lr_local_unit_details.NAME || ' ID==> ' ||g_local_unit_id);
461: fnd_file.put_line(fnd_file.log,'sub disburse ==> '||lr_local_unit_details.ORG_INFORMATION1 );
462: fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );

Line 459: fnd_file.put_line(fnd_file.log,'Local Unit Not Null' );

455: );
456: -- *********************************************************************
457:
458: fnd_file.put_line(fnd_file.log,' ================================ ' );
459: fnd_file.put_line(fnd_file.log,'Local Unit Not Null' );
460: fnd_file.put_line(fnd_file.log,'Name ==> '||lr_local_unit_details.NAME || ' ID==> ' ||g_local_unit_id);
461: fnd_file.put_line(fnd_file.log,'sub disburse ==> '||lr_local_unit_details.ORG_INFORMATION1 );
462: fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
463: fnd_file.put_line(fnd_file.log,' ================================ ' );

Line 460: fnd_file.put_line(fnd_file.log,'Name ==> '||lr_local_unit_details.NAME || ' ID==> ' ||g_local_unit_id);

456: -- *********************************************************************
457:
458: fnd_file.put_line(fnd_file.log,' ================================ ' );
459: fnd_file.put_line(fnd_file.log,'Local Unit Not Null' );
460: fnd_file.put_line(fnd_file.log,'Name ==> '||lr_local_unit_details.NAME || ' ID==> ' ||g_local_unit_id);
461: fnd_file.put_line(fnd_file.log,'sub disburse ==> '||lr_local_unit_details.ORG_INFORMATION1 );
462: fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
463: fnd_file.put_line(fnd_file.log,' ================================ ' );
464: -- *****************************************************************************

Line 461: fnd_file.put_line(fnd_file.log,'sub disburse ==> '||lr_local_unit_details.ORG_INFORMATION1 );

457:
458: fnd_file.put_line(fnd_file.log,' ================================ ' );
459: fnd_file.put_line(fnd_file.log,'Local Unit Not Null' );
460: fnd_file.put_line(fnd_file.log,'Name ==> '||lr_local_unit_details.NAME || ' ID==> ' ||g_local_unit_id);
461: fnd_file.put_line(fnd_file.log,'sub disburse ==> '||lr_local_unit_details.ORG_INFORMATION1 );
462: fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
463: fnd_file.put_line(fnd_file.log,' ================================ ' );
464: -- *****************************************************************************
465: -- If the Local unit is not selected then pick up all the local unit details

Line 462: fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );

458: fnd_file.put_line(fnd_file.log,' ================================ ' );
459: fnd_file.put_line(fnd_file.log,'Local Unit Not Null' );
460: fnd_file.put_line(fnd_file.log,'Name ==> '||lr_local_unit_details.NAME || ' ID==> ' ||g_local_unit_id);
461: fnd_file.put_line(fnd_file.log,'sub disburse ==> '||lr_local_unit_details.ORG_INFORMATION1 );
462: fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
463: fnd_file.put_line(fnd_file.log,' ================================ ' );
464: -- *****************************************************************************
465: -- If the Local unit is not selected then pick up all the local unit details
466: ELSE

Line 463: fnd_file.put_line(fnd_file.log,' ================================ ' );

459: fnd_file.put_line(fnd_file.log,'Local Unit Not Null' );
460: fnd_file.put_line(fnd_file.log,'Name ==> '||lr_local_unit_details.NAME || ' ID==> ' ||g_local_unit_id);
461: fnd_file.put_line(fnd_file.log,'sub disburse ==> '||lr_local_unit_details.ORG_INFORMATION1 );
462: fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
463: fnd_file.put_line(fnd_file.log,' ================================ ' );
464: -- *****************************************************************************
465: -- If the Local unit is not selected then pick up all the local unit details
466: ELSE
467: FOR lr_all_local_unit_details IN

Line 557: fnd_file.put_line(fnd_file.log,' ================ ALL ================ ' );

553: p_action_information29=> NULL,
554: p_action_information30=> NULL
555: );
556: -- *****************************************************************************
557: fnd_file.put_line(fnd_file.log,' ================ ALL ================ ' );
558: fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
559: fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
560: fnd_file.put_line(fnd_file.log,'Legal Emp Name ==> '||lr_pension_provider.NAME);
561: fnd_file.put_line(fnd_file.log,'Legal Emp ID ==> '||g_legal_employer_id);

Line 558: fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );

554: p_action_information30=> NULL
555: );
556: -- *****************************************************************************
557: fnd_file.put_line(fnd_file.log,' ================ ALL ================ ' );
558: fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
559: fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
560: fnd_file.put_line(fnd_file.log,'Legal Emp Name ==> '||lr_pension_provider.NAME);
561: fnd_file.put_line(fnd_file.log,'Legal Emp ID ==> '||g_legal_employer_id);
562: fnd_file.put_line(fnd_file.log,'Local Unit Name ==> '||lr_local_unit_details.NAME);

Line 559: fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);

555: );
556: -- *****************************************************************************
557: fnd_file.put_line(fnd_file.log,' ================ ALL ================ ' );
558: fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
559: fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
560: fnd_file.put_line(fnd_file.log,'Legal Emp Name ==> '||lr_pension_provider.NAME);
561: fnd_file.put_line(fnd_file.log,'Legal Emp ID ==> '||g_legal_employer_id);
562: fnd_file.put_line(fnd_file.log,'Local Unit Name ==> '||lr_local_unit_details.NAME);
563: fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);

Line 560: fnd_file.put_line(fnd_file.log,'Legal Emp Name ==> '||lr_pension_provider.NAME);

556: -- *****************************************************************************
557: fnd_file.put_line(fnd_file.log,' ================ ALL ================ ' );
558: fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
559: fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
560: fnd_file.put_line(fnd_file.log,'Legal Emp Name ==> '||lr_pension_provider.NAME);
561: fnd_file.put_line(fnd_file.log,'Legal Emp ID ==> '||g_legal_employer_id);
562: fnd_file.put_line(fnd_file.log,'Local Unit Name ==> '||lr_local_unit_details.NAME);
563: fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
564: fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );

Line 561: fnd_file.put_line(fnd_file.log,'Legal Emp ID ==> '||g_legal_employer_id);

557: fnd_file.put_line(fnd_file.log,' ================ ALL ================ ' );
558: fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
559: fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
560: fnd_file.put_line(fnd_file.log,'Legal Emp Name ==> '||lr_pension_provider.NAME);
561: fnd_file.put_line(fnd_file.log,'Legal Emp ID ==> '||g_legal_employer_id);
562: fnd_file.put_line(fnd_file.log,'Local Unit Name ==> '||lr_local_unit_details.NAME);
563: fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
564: fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
565: fnd_file.put_line(fnd_file.log,' ================================ ' );

Line 562: fnd_file.put_line(fnd_file.log,'Local Unit Name ==> '||lr_local_unit_details.NAME);

558: fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
559: fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
560: fnd_file.put_line(fnd_file.log,'Legal Emp Name ==> '||lr_pension_provider.NAME);
561: fnd_file.put_line(fnd_file.log,'Legal Emp ID ==> '||g_legal_employer_id);
562: fnd_file.put_line(fnd_file.log,'Local Unit Name ==> '||lr_local_unit_details.NAME);
563: fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
564: fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
565: fnd_file.put_line(fnd_file.log,' ================================ ' );
566:

Line 563: fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);

559: fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
560: fnd_file.put_line(fnd_file.log,'Legal Emp Name ==> '||lr_pension_provider.NAME);
561: fnd_file.put_line(fnd_file.log,'Legal Emp ID ==> '||g_legal_employer_id);
562: fnd_file.put_line(fnd_file.log,'Local Unit Name ==> '||lr_local_unit_details.NAME);
563: fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
564: fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
565: fnd_file.put_line(fnd_file.log,' ================================ ' );
566:
567: -- *****************************************************************************

Line 564: fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );

560: fnd_file.put_line(fnd_file.log,'Legal Emp Name ==> '||lr_pension_provider.NAME);
561: fnd_file.put_line(fnd_file.log,'Legal Emp ID ==> '||g_legal_employer_id);
562: fnd_file.put_line(fnd_file.log,'Local Unit Name ==> '||lr_local_unit_details.NAME);
563: fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
564: fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
565: fnd_file.put_line(fnd_file.log,' ================================ ' );
566:
567: -- *****************************************************************************
568: -- Information regarding the Legal Employer

Line 565: fnd_file.put_line(fnd_file.log,' ================================ ' );

561: fnd_file.put_line(fnd_file.log,'Legal Emp ID ==> '||g_legal_employer_id);
562: fnd_file.put_line(fnd_file.log,'Local Unit Name ==> '||lr_local_unit_details.NAME);
563: fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
564: fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
565: fnd_file.put_line(fnd_file.log,' ================================ ' );
566:
567: -- *****************************************************************************
568: -- Information regarding the Legal Employer
569: /*

Line 779: fnd_file.put_line(fnd_file.log,' ASSIGNMENT_ACTION_CODE ');

775: BEGIN
776: IF g_debug THEN
777: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
778: END IF;
779: fnd_file.put_line(fnd_file.log,' ASSIGNMENT_ACTION_CODE ');
780:
781: PAY_FI_ARCHIVE_TEL.GET_ALL_PARAMETERS
782: (p_payroll_action_id
783: ,g_business_group_id

Line 809: fnd_file.put_line(fnd_file.log,' g_local_unit_id '|| g_local_unit_id);

805: END IF;
806:
807: l_prepay_action_id := 0;
808:
809: fnd_file.put_line(fnd_file.log,' g_local_unit_id '|| g_local_unit_id);
810:
811: IF g_local_unit_id IS NOT NULL THEN
812: fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');
813:

Line 812: fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');

808:
809: fnd_file.put_line(fnd_file.log,' g_local_unit_id '|| g_local_unit_id);
810:
811: IF g_local_unit_id IS NOT NULL THEN
812: fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');
813:
814:
815: fnd_file.put_line(fnd_file.log,' p_payroll_action_id ==> ' || p_payroll_action_id);
816: fnd_file.put_line(fnd_file.log,' g_legal_employer_id ==> ' || g_legal_employer_id);

Line 815: fnd_file.put_line(fnd_file.log,' p_payroll_action_id ==> ' || p_payroll_action_id);

811: IF g_local_unit_id IS NOT NULL THEN
812: fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');
813:
814:
815: fnd_file.put_line(fnd_file.log,' p_payroll_action_id ==> ' || p_payroll_action_id);
816: fnd_file.put_line(fnd_file.log,' g_legal_employer_id ==> ' || g_legal_employer_id);
817: fnd_file.put_line(fnd_file.log,' g_local_unit_id ==> ' || g_local_unit_id);
818: fnd_file.put_line(fnd_file.log,' g_pension_provider_id ==> ' || g_pension_provider_id);
819: fnd_file.put_line(fnd_file.log,' g_effective_date ==> ' || g_effective_date);

Line 816: fnd_file.put_line(fnd_file.log,' g_legal_employer_id ==> ' || g_legal_employer_id);

812: fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');
813:
814:
815: fnd_file.put_line(fnd_file.log,' p_payroll_action_id ==> ' || p_payroll_action_id);
816: fnd_file.put_line(fnd_file.log,' g_legal_employer_id ==> ' || g_legal_employer_id);
817: fnd_file.put_line(fnd_file.log,' g_local_unit_id ==> ' || g_local_unit_id);
818: fnd_file.put_line(fnd_file.log,' g_pension_provider_id ==> ' || g_pension_provider_id);
819: fnd_file.put_line(fnd_file.log,' g_effective_date ==> ' || g_effective_date);
820: fnd_file.put_line(fnd_file.log,' l_canonical_start_date ==> ' || l_canonical_start_date);

Line 817: fnd_file.put_line(fnd_file.log,' g_local_unit_id ==> ' || g_local_unit_id);

813:
814:
815: fnd_file.put_line(fnd_file.log,' p_payroll_action_id ==> ' || p_payroll_action_id);
816: fnd_file.put_line(fnd_file.log,' g_legal_employer_id ==> ' || g_legal_employer_id);
817: fnd_file.put_line(fnd_file.log,' g_local_unit_id ==> ' || g_local_unit_id);
818: fnd_file.put_line(fnd_file.log,' g_pension_provider_id ==> ' || g_pension_provider_id);
819: fnd_file.put_line(fnd_file.log,' g_effective_date ==> ' || g_effective_date);
820: fnd_file.put_line(fnd_file.log,' l_canonical_start_date ==> ' || l_canonical_start_date);
821: fnd_file.put_line(fnd_file.log,' l_canonical_end_date ==> ' || l_canonical_end_date);

Line 818: fnd_file.put_line(fnd_file.log,' g_pension_provider_id ==> ' || g_pension_provider_id);

814:
815: fnd_file.put_line(fnd_file.log,' p_payroll_action_id ==> ' || p_payroll_action_id);
816: fnd_file.put_line(fnd_file.log,' g_legal_employer_id ==> ' || g_legal_employer_id);
817: fnd_file.put_line(fnd_file.log,' g_local_unit_id ==> ' || g_local_unit_id);
818: fnd_file.put_line(fnd_file.log,' g_pension_provider_id ==> ' || g_pension_provider_id);
819: fnd_file.put_line(fnd_file.log,' g_effective_date ==> ' || g_effective_date);
820: fnd_file.put_line(fnd_file.log,' l_canonical_start_date ==> ' || l_canonical_start_date);
821: fnd_file.put_line(fnd_file.log,' l_canonical_end_date ==> ' || l_canonical_end_date);
822:

Line 819: fnd_file.put_line(fnd_file.log,' g_effective_date ==> ' || g_effective_date);

815: fnd_file.put_line(fnd_file.log,' p_payroll_action_id ==> ' || p_payroll_action_id);
816: fnd_file.put_line(fnd_file.log,' g_legal_employer_id ==> ' || g_legal_employer_id);
817: fnd_file.put_line(fnd_file.log,' g_local_unit_id ==> ' || g_local_unit_id);
818: fnd_file.put_line(fnd_file.log,' g_pension_provider_id ==> ' || g_pension_provider_id);
819: fnd_file.put_line(fnd_file.log,' g_effective_date ==> ' || g_effective_date);
820: fnd_file.put_line(fnd_file.log,' l_canonical_start_date ==> ' || l_canonical_start_date);
821: fnd_file.put_line(fnd_file.log,' l_canonical_end_date ==> ' || l_canonical_end_date);
822:
823: FOR rec_prepaid_assignments IN csr_prepaid_assignments_lu(p_payroll_action_id

Line 820: fnd_file.put_line(fnd_file.log,' l_canonical_start_date ==> ' || l_canonical_start_date);

816: fnd_file.put_line(fnd_file.log,' g_legal_employer_id ==> ' || g_legal_employer_id);
817: fnd_file.put_line(fnd_file.log,' g_local_unit_id ==> ' || g_local_unit_id);
818: fnd_file.put_line(fnd_file.log,' g_pension_provider_id ==> ' || g_pension_provider_id);
819: fnd_file.put_line(fnd_file.log,' g_effective_date ==> ' || g_effective_date);
820: fnd_file.put_line(fnd_file.log,' l_canonical_start_date ==> ' || l_canonical_start_date);
821: fnd_file.put_line(fnd_file.log,' l_canonical_end_date ==> ' || l_canonical_end_date);
822:
823: FOR rec_prepaid_assignments IN csr_prepaid_assignments_lu(p_payroll_action_id
824: ,p_start_person

Line 821: fnd_file.put_line(fnd_file.log,' l_canonical_end_date ==> ' || l_canonical_end_date);

817: fnd_file.put_line(fnd_file.log,' g_local_unit_id ==> ' || g_local_unit_id);
818: fnd_file.put_line(fnd_file.log,' g_pension_provider_id ==> ' || g_pension_provider_id);
819: fnd_file.put_line(fnd_file.log,' g_effective_date ==> ' || g_effective_date);
820: fnd_file.put_line(fnd_file.log,' l_canonical_start_date ==> ' || l_canonical_start_date);
821: fnd_file.put_line(fnd_file.log,' l_canonical_end_date ==> ' || l_canonical_end_date);
822:
823: FOR rec_prepaid_assignments IN csr_prepaid_assignments_lu(p_payroll_action_id
824: ,p_start_person
825: ,p_end_person

Line 832: fnd_file.put_line(fnd_file.log,' LU Inside the Csr Prepaid Cursor ');

828: ,g_pension_ins_num
829: ,l_canonical_start_date
830: ,l_canonical_end_date)
831: LOOP
832: fnd_file.put_line(fnd_file.log,' LU Inside the Csr Prepaid Cursor ');
833: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
834: SELECT pay_assignment_actions_s.NEXTVAL
835: INTO l_actid
836: FROM dual;

Line 856: fnd_file.put_line(fnd_file.log,' INSIDE ELS LOCAL UNIT NULL ');

852: l_prepay_action_id := rec_prepaid_assignments.prepaid_action_id;
853: END LOOP;
854:
855: ELSE
856: fnd_file.put_line(fnd_file.log,' INSIDE ELS LOCAL UNIT NULL ');
857: FOR rec_prepaid_assignments IN csr_prepaid_assignments_le(p_payroll_action_id
858: ,p_start_person
859: ,p_end_person
860: ,g_legal_employer_id

Line 865: fnd_file.put_line(fnd_file.log,' LE Inside the Csr Prepaid Cursor ');

861: ,g_pension_ins_num
862: ,l_canonical_start_date
863: ,l_canonical_end_date)
864: LOOP
865: fnd_file.put_line(fnd_file.log,' LE Inside the Csr Prepaid Cursor ');
866: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
867: SELECT pay_assignment_actions_s.NEXTVAL
868: INTO l_actid
869: FROM dual;

Line 888: fnd_file.put_line(fnd_file.log,' After Ending Assignment Act Code the Locking Cursor ');

884: --hr_nonrun_asact.insint(l_actid,rec_prepaid_assignments.run_action_id);
885: l_prepay_action_id := rec_prepaid_assignments.prepaid_action_id;
886: END LOOP;
887: END IF;
888: fnd_file.put_line(fnd_file.log,' After Ending Assignment Act Code the Locking Cursor ');
889:
890: IF g_debug THEN
891: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
892: END IF;

Line 921: fnd_file.put_line(fnd_file.log,'In INIT_CODE 0');

917: BEGIN
918: IF g_debug THEN
919: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
920: END IF;
921: fnd_file.put_line(fnd_file.log,'In INIT_CODE 0');
922:
923: g_payroll_action_id :=p_payroll_action_id;
924:
925: g_business_group_id := null;

Line 945: fnd_file.put_line(fnd_file.log,'In the INITIALIZATION_CODE After Initiliazing the global parameter ' );

941: ,g_ref_date
942: ,g_archive
943: );
944:
945: fnd_file.put_line(fnd_file.log,'In the INITIALIZATION_CODE After Initiliazing the global parameter ' );
946:
947: IF g_debug THEN
948: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
949: END IF;

Line 1297: fnd_file.put_line(fnd_file.log,'Entering ARCHIVE_CODE ' );

1293: IF g_debug THEN
1294: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
1295: END IF;
1296:
1297: fnd_file.put_line(fnd_file.log,'Entering ARCHIVE_CODE ' );
1298: IF g_archive ='Y'
1299: THEN
1300: -- *****************************************************************************
1301: -- TO pick up the PIN

Line 1320: fnd_file.put_line(fnd_file.log,' ==============PERSON================== ' );

1316: ' '|| lr_get_person_details.FIRST_NAME;
1317: END IF;
1318:
1319:
1320: fnd_file.put_line(fnd_file.log,' ==============PERSON================== ' );
1321: fnd_file.put_line(fnd_file.log,'l_Employee_Pin ==> '||l_Employee_Pin );
1322: fnd_file.put_line(fnd_file.log,'l_Employee_name ==> '||l_Employee_name );
1323:
1324: fnd_file.put_line(fnd_file.log,' ================================ ' );

Line 1321: fnd_file.put_line(fnd_file.log,'l_Employee_Pin ==> '||l_Employee_Pin );

1317: END IF;
1318:
1319:
1320: fnd_file.put_line(fnd_file.log,' ==============PERSON================== ' );
1321: fnd_file.put_line(fnd_file.log,'l_Employee_Pin ==> '||l_Employee_Pin );
1322: fnd_file.put_line(fnd_file.log,'l_Employee_name ==> '||l_Employee_name );
1323:
1324: fnd_file.put_line(fnd_file.log,' ================================ ' );
1325:

Line 1322: fnd_file.put_line(fnd_file.log,'l_Employee_name ==> '||l_Employee_name );

1318:
1319:
1320: fnd_file.put_line(fnd_file.log,' ==============PERSON================== ' );
1321: fnd_file.put_line(fnd_file.log,'l_Employee_Pin ==> '||l_Employee_Pin );
1322: fnd_file.put_line(fnd_file.log,'l_Employee_name ==> '||l_Employee_name );
1323:
1324: fnd_file.put_line(fnd_file.log,' ================================ ' );
1325:
1326: -- *****************************************************************************

Line 1324: fnd_file.put_line(fnd_file.log,' ================================ ' );

1320: fnd_file.put_line(fnd_file.log,' ==============PERSON================== ' );
1321: fnd_file.put_line(fnd_file.log,'l_Employee_Pin ==> '||l_Employee_Pin );
1322: fnd_file.put_line(fnd_file.log,'l_Employee_name ==> '||l_Employee_name );
1323:
1324: fnd_file.put_line(fnd_file.log,' ================================ ' );
1325:
1326: -- *****************************************************************************
1327: -- TO pick up the Local Unit Sub-disbursement Number
1328:

Line 1336: fnd_file.put_line(fnd_file.log,'l_Employed_or_not ==> '||l_Employed_or_not );

1332: CLOSE csr_get_Segment2;
1333: l_Employed_or_not :=lr_get_Segment2.segment8;
1334: l_local_unit_id_fetched := lr_get_Segment2.segment2;
1335: -- Used to display Record 5 , if value is 2 [Not employed ] then report as 5 else NULL
1336: fnd_file.put_line(fnd_file.log,'l_Employed_or_not ==> '||l_Employed_or_not );
1337:
1338: -- TO pick up the Local Unit Sub-disbursement Number
1339: -- TO pick up New SUb-disburesement number
1340: -- From the assignment local unit, go to legal employer,

Line 1362: fnd_file.put_line(fnd_file.log,'l_new_Department ==> '||l_new_Department );

1358: CLOSE csr_Department_code;
1359:
1360:
1361: l_new_Department := lr_Department_code.ORG_INFORMATION3; -- NEW Department code
1362: fnd_file.put_line(fnd_file.log,'l_new_Department ==> '||l_new_Department );
1363: -- TO pick up New SUb-disburesement number
1364: -- *****************************************************************************
1365:
1366:

Line 1370: fnd_file.put_line(fnd_file.log,'l_person_id ==> '||l_person_id );

1366:
1367: -- *****************************************************************************
1368: -- Pick up Person ID
1369: l_person_id := lr_get_person_details.person_id;
1370: fnd_file.put_line(fnd_file.log,'l_person_id ==> '||l_person_id );
1371: -- *****************************************************************************
1372:
1373: -- *****************************************************************************
1374: -- TO pick up the Start Date [ Pension Hire date stored at person level. ]

Line 1378: fnd_file.put_line(fnd_file.log,'Pension_Start_date ==> '||l_Pension_Start_date );

1374: -- TO pick up the Start Date [ Pension Hire date stored at person level. ]
1375:
1376: l_Pension_Start_date := fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION14);
1377:
1378: fnd_file.put_line(fnd_file.log,'Pension_Start_date ==> '||l_Pension_Start_date );
1379:
1380: -- *****************************************************************************
1381: -- Pick up the Balance value
1382: l_assignment_id :=lr_get_person_details.assignment_id;

Line 1383: fnd_file.put_line(fnd_file.log,'l_assignment_id ==> '||l_assignment_id );

1379:
1380: -- *****************************************************************************
1381: -- Pick up the Balance value
1382: l_assignment_id :=lr_get_person_details.assignment_id;
1383: fnd_file.put_line(fnd_file.log,'l_assignment_id ==> '||l_assignment_id );
1384: BEGIN
1385: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id);
1386:
1387: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);

Line 1405: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );

1401: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_PENSION_PER_PENSION_LU_MONTH');
1402: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1403: CLOSE csr_Get_Defined_Balance_Id;
1404:
1405: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1406: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1407:
1408: l_Sal_subject_pension_MTD :=to_char(pay_balance_pkg.get_value
1409: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,

Line 1406: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );

1402: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1403: CLOSE csr_Get_Defined_Balance_Id;
1404:
1405: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1406: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1407:
1408: l_Sal_subject_pension_MTD :=to_char(pay_balance_pkg.get_value
1409: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1410: P_ASSIGNMENT_ID =>l_assignment_id ,

Line 1414: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LU_MONTH ==> '||l_Sal_subject_pension_MTD );

1410: P_ASSIGNMENT_ID =>l_assignment_id ,
1411: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1412:
1413:
1414: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LU_MONTH ==> '||l_Sal_subject_pension_MTD );
1415: -- *****************************************************************************
1416:
1417: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_PENSION_PER_PENSION_LU_MONTH');
1418: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;

Line 1421: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> '||lr_Get_Defined_Balance_Id.creator_id );

1417: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_PENSION_PER_PENSION_LU_MONTH');
1418: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1419: CLOSE csr_Get_Defined_Balance_Id;
1420:
1421: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> '||lr_Get_Defined_Balance_Id.creator_id );
1422: l_bik_subject_pension_MTD :=to_char(pay_balance_pkg.get_value
1423: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1424: P_ASSIGNMENT_ID =>l_assignment_id ,
1425: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;

Line 1428: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LU_MONTH ==> '||l_bik_subject_pension_MTD );

1424: P_ASSIGNMENT_ID =>l_assignment_id ,
1425: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1426:
1427:
1428: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LU_MONTH ==> '||l_bik_subject_pension_MTD );
1429: -- *****************************************************************************
1430:
1431: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LU_MONTH');
1432: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;

Line 1435: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );

1431: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LU_MONTH');
1432: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1433: CLOSE csr_Get_Defined_Balance_Id;
1434:
1435: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1436: l_tax_exp_subject_pension_MTD :=to_char(pay_balance_pkg.get_value
1437: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1438: P_ASSIGNMENT_ID =>l_assignment_id ,
1439: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;

Line 1442: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LU_MONTH ==> '||l_tax_exp_subject_pension_MTD );

1438: P_ASSIGNMENT_ID =>l_assignment_id ,
1439: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1440:
1441:
1442: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LU_MONTH ==> '||l_tax_exp_subject_pension_MTD );
1443: -- *****************************************************************************
1444: -- QTD START
1445: -- *****************************************************************************
1446: --Salary QTD

Line 1451: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );

1447: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_PENSION_PER_PENSION_LU_QUARTER');
1448: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1449: CLOSE csr_Get_Defined_Balance_Id;
1450:
1451: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1452: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1453:
1454: l_Sal_subject_pension_QTD :=to_char(pay_balance_pkg.get_value
1455: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,

Line 1452: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );

1448: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1449: CLOSE csr_Get_Defined_Balance_Id;
1450:
1451: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1452: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1453:
1454: l_Sal_subject_pension_QTD :=to_char(pay_balance_pkg.get_value
1455: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1456: P_ASSIGNMENT_ID =>l_assignment_id ,

Line 1460: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LU_QUARTER ==> '||l_Sal_subject_pension_QTD );

1456: P_ASSIGNMENT_ID =>l_assignment_id ,
1457: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1458:
1459:
1460: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LU_QUARTER ==> '||l_Sal_subject_pension_QTD );
1461: -- *****************************************************************************
1462: -- BIK QTD
1463:
1464: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_PENSION_PER_PENSION_LU_QUARTER');

Line 1468: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> '||lr_Get_Defined_Balance_Id.creator_id );

1464: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_PENSION_PER_PENSION_LU_QUARTER');
1465: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1466: CLOSE csr_Get_Defined_Balance_Id;
1467:
1468: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> '||lr_Get_Defined_Balance_Id.creator_id );
1469: l_bik_subject_pension_QTD :=to_char(pay_balance_pkg.get_value
1470: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1471: P_ASSIGNMENT_ID =>l_assignment_id ,
1472: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;

Line 1475: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LU_QUARTER ==> '||l_bik_subject_pension_QTD );

1471: P_ASSIGNMENT_ID =>l_assignment_id ,
1472: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1473:
1474:
1475: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LU_QUARTER ==> '||l_bik_subject_pension_QTD );
1476: -- *****************************************************************************
1477: --EXPENSE QTD
1478:
1479: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LU_QUARTER');

Line 1483: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );

1479: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LU_QUARTER');
1480: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1481: CLOSE csr_Get_Defined_Balance_Id;
1482:
1483: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1484: l_tax_exp_subject_pension_QTD :=to_char(pay_balance_pkg.get_value
1485: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1486: P_ASSIGNMENT_ID =>l_assignment_id ,
1487: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;

Line 1490: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LU_QUARTER ==> '||l_tax_exp_subject_pension_QTD );

1486: P_ASSIGNMENT_ID =>l_assignment_id ,
1487: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1488:
1489:
1490: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LU_QUARTER ==> '||l_tax_exp_subject_pension_QTD );
1491: -- *****************************************************************************
1492: -- MONTH QTD END
1493: -- Salary YTD
1494: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_PENSION_PER_PENSION_LU_YEAR');

Line 1498: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );

1494: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_PENSION_PER_PENSION_LU_YEAR');
1495: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1496: CLOSE csr_Get_Defined_Balance_Id;
1497:
1498: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1499: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1500:
1501: l_Sal_subject_pension_YTD :=to_char(pay_balance_pkg.get_value
1502: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,

Line 1499: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );

1495: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1496: CLOSE csr_Get_Defined_Balance_Id;
1497:
1498: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1499: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1500:
1501: l_Sal_subject_pension_YTD :=to_char(pay_balance_pkg.get_value
1502: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1503: P_ASSIGNMENT_ID =>l_assignment_id ,

Line 1506: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LU_YEAR ==> '||l_Sal_subject_pension_YTD );

1502: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1503: P_ASSIGNMENT_ID =>l_assignment_id ,
1504: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1505:
1506: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LU_YEAR ==> '||l_Sal_subject_pension_YTD );
1507: -- *****************************************************************************
1508:
1509: -- Salary Balance value before termination date
1510:

Line 1520: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LU_YEAR_BEFORE ==> '||l_sal_sub_pension_YTD_before );

1516: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1517: ELSE
1518: l_sal_sub_pension_YTD_before := 0;
1519: END IF;
1520: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LU_YEAR_BEFORE ==> '||l_sal_sub_pension_YTD_before );
1521: -- *****************************************************************************
1522: -- Salary YTD
1523: -- BIK YTD
1524:

Line 1529: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );

1525: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_PENSION_PER_PENSION_LU_YEAR');
1526: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1527: CLOSE csr_Get_Defined_Balance_Id;
1528:
1529: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1530: l_bik_subject_pension_YTD :=to_char(pay_balance_pkg.get_value
1531: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1532: P_ASSIGNMENT_ID =>l_assignment_id ,
1533: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;

Line 1535: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LU_YEAR ==> '||l_bik_subject_pension_YTD );

1531: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1532: P_ASSIGNMENT_ID =>l_assignment_id ,
1533: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1534:
1535: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LU_YEAR ==> '||l_bik_subject_pension_YTD );
1536: -- *****************************************************************************
1537: -- Balance value before termination date
1538: IF lr_get_person_details.PER_INFORMATION20 IS NOT NULL
1539: THEN

Line 1547: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LU_YEAR_before ==> '||l_bik_sub_pension_YTD_before );

1543: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1544: ELSE
1545: l_bik_sub_pension_YTD_before := 0;
1546: END IF;
1547: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LU_YEAR_before ==> '||l_bik_sub_pension_YTD_before );
1548:
1549: -- *****************************************************************************
1550:
1551: -- BIK YTD

Line 1562: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LU_YEAR ==> '||l_tax_exp_subject_pension_YTD );

1558: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1559: P_ASSIGNMENT_ID =>l_assignment_id ,
1560: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1561:
1562: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LU_YEAR ==> '||l_tax_exp_subject_pension_YTD );
1563: -- *****************************************************************************
1564: -- Taxable Expenses Balance value before termination date
1565:
1566: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LU_YEAR');

Line 1579: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LU_YEAR_BEFORE ==> '||l_tax_exp_pension_YTD_before );

1575: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1576: ELSE
1577: l_tax_exp_pension_YTD_before := 0;
1578: END IF;
1579: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LU_YEAR_BEFORE ==> '||l_tax_exp_pension_YTD_before );
1580: -- TAXABLE EXPENSES YTD
1581: -- *****************************************************************************
1582: -- IF the Local unit is not selected then pick up LE context Balance values
1583: -- *****************************************************************************

Line 1590: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> '||lr_Get_Defined_Balance_Id.creator_id );

1586: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_PENSION_PER_PENSION_LE_MONTH');
1587: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1588: CLOSE csr_Get_Defined_Balance_Id;
1589:
1590: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> '||lr_Get_Defined_Balance_Id.creator_id );
1591: fnd_file.put_line(fnd_file.log,'g_effective_date ==> '||g_effective_date );
1592:
1593: l_Sal_subject_pension_MTD :=to_char(pay_balance_pkg.get_value
1594: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,

Line 1591: fnd_file.put_line(fnd_file.log,'g_effective_date ==> '||g_effective_date );

1587: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1588: CLOSE csr_Get_Defined_Balance_Id;
1589:
1590: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> '||lr_Get_Defined_Balance_Id.creator_id );
1591: fnd_file.put_line(fnd_file.log,'g_effective_date ==> '||g_effective_date );
1592:
1593: l_Sal_subject_pension_MTD :=to_char(pay_balance_pkg.get_value
1594: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1595: P_ASSIGNMENT_ID =>l_assignment_id ,

Line 1599: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LE_MONTH ==> '||l_Sal_subject_pension_MTD );

1595: P_ASSIGNMENT_ID =>l_assignment_id ,
1596: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1597:
1598:
1599: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LE_MONTH ==> '||l_Sal_subject_pension_MTD );
1600: -- *****************************************************************************
1601: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_PENSION_PER_PENSION_LE_MONTH');
1602: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1603: CLOSE csr_Get_Defined_Balance_Id;

Line 1611: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LE_MONTH ==> '||l_bik_subject_pension_MTD );

1607: P_ASSIGNMENT_ID =>l_assignment_id ,
1608: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1609:
1610:
1611: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LE_MONTH ==> '||l_bik_subject_pension_MTD );
1612:
1613: -- *****************************************************************************
1614:
1615: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LE_MONTH');

Line 1625: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LE_MONTH ==> '||l_tax_exp_subject_pension_MTD );

1621: P_ASSIGNMENT_ID =>l_assignment_id ,
1622: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1623:
1624:
1625: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LE_MONTH ==> '||l_tax_exp_subject_pension_MTD );
1626: -- *****************************************************************************
1627: --SALARY LE QTD
1628: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_PENSION_PER_PENSION_LE_QUARTER');
1629: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;

Line 1632: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> '||lr_Get_Defined_Balance_Id.creator_id );

1628: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_PENSION_PER_PENSION_LE_QUARTER');
1629: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1630: CLOSE csr_Get_Defined_Balance_Id;
1631:
1632: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> '||lr_Get_Defined_Balance_Id.creator_id );
1633: fnd_file.put_line(fnd_file.log,'g_effective_date ==> '||g_effective_date );
1634:
1635: l_Sal_subject_pension_QTD :=to_char(pay_balance_pkg.get_value
1636: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,

Line 1633: fnd_file.put_line(fnd_file.log,'g_effective_date ==> '||g_effective_date );

1629: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1630: CLOSE csr_Get_Defined_Balance_Id;
1631:
1632: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> '||lr_Get_Defined_Balance_Id.creator_id );
1633: fnd_file.put_line(fnd_file.log,'g_effective_date ==> '||g_effective_date );
1634:
1635: l_Sal_subject_pension_QTD :=to_char(pay_balance_pkg.get_value
1636: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1637: P_ASSIGNMENT_ID =>l_assignment_id ,

Line 1641: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LE_QUARTER ==> '||l_Sal_subject_pension_QTD );

1637: P_ASSIGNMENT_ID =>l_assignment_id ,
1638: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1639:
1640:
1641: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LE_QUARTER ==> '||l_Sal_subject_pension_QTD );
1642: -- *****************************************************************************
1643: --BIK QTD
1644: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_PENSION_PER_PENSION_LE_QUARTER');
1645: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;

Line 1654: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LE_QUARTER ==> '||l_bik_subject_pension_QTD );

1650: P_ASSIGNMENT_ID =>l_assignment_id ,
1651: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1652:
1653:
1654: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LE_QUARTER ==> '||l_bik_subject_pension_QTD );
1655:
1656: -- *****************************************************************************
1657: -- EXPENSE QTD
1658:

Line 1669: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LE_QUARTER ==> '||l_tax_exp_subject_pension_QTD );

1665: P_ASSIGNMENT_ID =>l_assignment_id ,
1666: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1667:
1668:
1669: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LE_QUARTER ==> '||l_tax_exp_subject_pension_QTD );
1670: -- *****************************************************************************
1671:
1672: -- END OF MTD QTD
1673:

Line 1678: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );

1674: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_PENSION_PER_PENSION_LE_YEAR');
1675: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1676: CLOSE csr_Get_Defined_Balance_Id;
1677:
1678: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1679: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1680:
1681: l_Sal_subject_pension_YTD :=to_char(pay_balance_pkg.get_value
1682: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,

Line 1679: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );

1675: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1676: CLOSE csr_Get_Defined_Balance_Id;
1677:
1678: fnd_file.put_line(fnd_file.log,'DEFINED_BALANCE_ID ==> ' ||lr_Get_Defined_Balance_Id.creator_id );
1679: fnd_file.put_line(fnd_file.log,'g_effective_date ==> ' ||g_effective_date );
1680:
1681: l_Sal_subject_pension_YTD :=to_char(pay_balance_pkg.get_value
1682: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1683: P_ASSIGNMENT_ID =>l_assignment_id ,

Line 1686: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LE_YEAR ==> '||l_Sal_subject_pension_YTD );

1682: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1683: P_ASSIGNMENT_ID =>l_assignment_id ,
1684: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1685:
1686: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LE_YEAR ==> '||l_Sal_subject_pension_YTD );
1687: -- *****************************************************************************
1688:
1689: -- Salary Balance value before termination date
1690:

Line 1700: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LE_YEAR_BEFORE ==> '||l_sal_sub_pension_YTD_before );

1696: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1697: ELSE
1698: l_sal_sub_pension_YTD_before := 0;
1699: END IF;
1700: fnd_file.put_line(fnd_file.log,'l_Sal_subject_pension_PER_PENSION_LE_YEAR_BEFORE ==> '||l_sal_sub_pension_YTD_before );
1701: -- *****************************************************************************
1702:
1703:
1704: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_PENSION_PER_PENSION_LE_YEAR');

Line 1713: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LE_YEAR ==> '||l_bik_subject_pension_YTD );

1709: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1710: P_ASSIGNMENT_ID =>l_assignment_id ,
1711: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1712:
1713: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LE_YEAR ==> '||l_bik_subject_pension_YTD );
1714: -- *****************************************************************************
1715: -- Balance value before termination date
1716: IF lr_get_person_details.PER_INFORMATION20 IS NOT NULL
1717: THEN

Line 1725: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LE_YEAR_before ==> '||l_bik_sub_pension_YTD_before );

1721: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1722: ELSE
1723: l_bik_sub_pension_YTD_before := 0;
1724: END IF;
1725: fnd_file.put_line(fnd_file.log,'l_bik_subject_pension_PER_PENSION_LE_YEAR_before ==> '||l_bik_sub_pension_YTD_before );
1726:
1727: -- *****************************************************************************
1728:
1729: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LE_YEAR');

Line 1738: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LE_YEAR ==> '||l_tax_exp_subject_pension_YTD );

1734: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id,
1735: P_ASSIGNMENT_ID =>l_assignment_id ,
1736: P_VIRTUAL_DATE => g_ref_date ),'999999999D99') ;
1737:
1738: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LE_YEAR ==> '||l_tax_exp_subject_pension_YTD );
1739: -- *****************************************************************************
1740: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_PENSION_PER_PENSION_LE_YEAR');
1741: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1742: CLOSE csr_Get_Defined_Balance_Id;

Line 1753: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LE_YEAR_BEFORE ==> '||l_tax_exp_pension_YTD_before );

1749: P_VIRTUAL_DATE => fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20) ),'999999999D99') ;
1750: ELSE
1751: l_tax_exp_pension_YTD_before := 0;
1752: END IF;
1753: fnd_file.put_line(fnd_file.log,'l_tax_exp_subject_pension_PER_PENSION_LE_YEAR_BEFORE ==> '||l_tax_exp_pension_YTD_before );
1754:
1755: END IF; -- END OF G_LOCAL_UNIT_ID NULL CHECK
1756:
1757: -- *****************************************************************************

Line 1760: fnd_file.put_line(fnd_file.log,'l_Termination_date ==> '||l_Termination_date );

1756:
1757: -- *****************************************************************************
1758: -- Pick up Termiantion date form person table
1759: l_Termination_date := fnd_date.canonical_to_date(lr_get_person_details.PER_INFORMATION20);
1760: fnd_file.put_line(fnd_file.log,'l_Termination_date ==> '||l_Termination_date );
1761: -- *****************************************************************************
1762: -- Pick up the Cause of termination
1763: -- from person record
1764:

Line 1767: fnd_file.put_line(fnd_file.log,'Cause termination ==> '||l_Cause_of_termination );

1763: -- from person record
1764:
1765: l_Cause_of_termination := lr_get_person_details.PER_INFORMATION21;
1766:
1767: fnd_file.put_line(fnd_file.log,'Cause termination ==> '||l_Cause_of_termination );
1768: -- *****************************************************************************
1769: -- to find the old group code
1770: -- Go to Person EIT , find the record for the " Pension Group ", if available
1771: -- Then pick up the value PEI_INFORMATION4 <=> Pension Group Code

Line 1778: fnd_file.put_line(fnd_file.log,'Old Group Code ==> '||LR_PERSON_EIT.pei_information4);

1774: FETCH CSR_PERSON_EIT
1775: INTO LR_PERSON_EIT;
1776: CLOSE CSR_PERSON_EIT;
1777: l_old_pension_group_code :=LR_PERSON_EIT.pei_information4;
1778: fnd_file.put_line(fnd_file.log,'Old Group Code ==> '||LR_PERSON_EIT.pei_information4);
1779: -- to find the old group code
1780: -- *****************************************************************************
1781: -- *****************************************************************************
1782: -- Go to Person EIT , find the record for the " Local Unit ", if available

Line 1806: fnd_file.put_line(fnd_file.log,'l_old_Department ==> '||l_old_Department );

1802: CLOSE csr_Department_code;
1803:
1804: l_old_Department := lr_Department_code.ORG_INFORMATION3; -- OLD Department Code
1805:
1806: fnd_file.put_line(fnd_file.log,'l_old_Department ==> '||l_old_Department );
1807: -- *****************************************************************************
1808: -- to find the old Department END
1809: -- Using the Above Local unit ID find the legal employer , Pension Provider,
1810: -- Then select the pension policy Number for this Local Unit

Line 1825: fnd_file.put_line(fnd_file.log,'New Group Code ==> '||lr_get_person_details.PER_INFORMATION16);

1821: -- *****************************************************************************
1822: -- TO pick up new pension group code
1823: -- Pick the Current Pension Group Code from the Person Record
1824: l_new_pension_group_code :=lr_get_person_details.PER_INFORMATION16;
1825: fnd_file.put_line(fnd_file.log,'New Group Code ==> '||lr_get_person_details.PER_INFORMATION16);
1826: -- TO pick up new pension group code
1827: -- *****************************************************************************
1828: -- *****************************************************************************
1829: -- Finding the new INSURANCE POLICY NUMBER

Line 1832: fnd_file.put_line(fnd_file.log,'New Policy Number ==> '||lr_get_person_details.PER_INFORMATION24);

1828: -- *****************************************************************************
1829: -- Finding the new INSURANCE POLICY NUMBER
1830: -- Pick the Current INSURANCE POLICY NUMBER from the Person Record
1831: l_new_policy_number := lr_get_person_details.PER_INFORMATION24;
1832: fnd_file.put_line(fnd_file.log,'New Policy Number ==> '||lr_get_person_details.PER_INFORMATION24);
1833:
1834: -- Finding the new INSURANCE POLICY NUMBER
1835: -- *****************************************************************************
1836:

Line 1849: fnd_file.put_line(fnd_file.log,'Not found In Archive record ' );

1845:
1846: EXCEPTION
1847: WHEN NO_DATA_FOUND
1848: THEN
1849: fnd_file.put_line(fnd_file.log,'Not found In Archive record ' );
1850: fnd_file.put_line(fnd_file.log,'g_payroll_action_id ' || g_payroll_action_id);
1851: pay_action_information_api.create_action_information (
1852: p_action_information_id => l_action_info_id
1853: ,p_action_context_id => p_assignment_action_id

Line 1850: fnd_file.put_line(fnd_file.log,'g_payroll_action_id ' || g_payroll_action_id);

1846: EXCEPTION
1847: WHEN NO_DATA_FOUND
1848: THEN
1849: fnd_file.put_line(fnd_file.log,'Not found In Archive record ' );
1850: fnd_file.put_line(fnd_file.log,'g_payroll_action_id ' || g_payroll_action_id);
1851: pay_action_information_api.create_action_information (
1852: p_action_information_id => l_action_info_id
1853: ,p_action_context_id => p_assignment_action_id
1854: ,p_action_context_type => 'AAP'

Line 1892: fnd_file.put_line(fnd_file.log,'l_action_info_id ==> '||l_action_info_id );

1888: ,p_action_information29 => lr_pension_provider.ORG_INFORMATION10
1889: ,p_action_information30 => l_person_id
1890: ,p_assignment_id => l_assignment_id );
1891:
1892: fnd_file.put_line(fnd_file.log,'l_action_info_id ==> '||l_action_info_id );
1893: fnd_file.put_line(fnd_file.log,'l_action_info_id ==> '||l_person_id );
1894: fnd_file.put_line(fnd_file.log,'g_annual_report ==> '||g_annual_report );
1895: IF g_annual_report ='M'
1896: THEN

Line 1893: fnd_file.put_line(fnd_file.log,'l_action_info_id ==> '||l_person_id );

1889: ,p_action_information30 => l_person_id
1890: ,p_assignment_id => l_assignment_id );
1891:
1892: fnd_file.put_line(fnd_file.log,'l_action_info_id ==> '||l_action_info_id );
1893: fnd_file.put_line(fnd_file.log,'l_action_info_id ==> '||l_person_id );
1894: fnd_file.put_line(fnd_file.log,'g_annual_report ==> '||g_annual_report );
1895: IF g_annual_report ='M'
1896: THEN
1897: l_period_start_date :=LAST_DAY(ADD_MONTHS(g_ref_date , -1) ) + 1 ;

Line 1894: fnd_file.put_line(fnd_file.log,'g_annual_report ==> '||g_annual_report );

1890: ,p_assignment_id => l_assignment_id );
1891:
1892: fnd_file.put_line(fnd_file.log,'l_action_info_id ==> '||l_action_info_id );
1893: fnd_file.put_line(fnd_file.log,'l_action_info_id ==> '||l_person_id );
1894: fnd_file.put_line(fnd_file.log,'g_annual_report ==> '||g_annual_report );
1895: IF g_annual_report ='M'
1896: THEN
1897: l_period_start_date :=LAST_DAY(ADD_MONTHS(g_ref_date , -1) ) + 1 ;
1898: l_period_end_date := LAST_DAY(g_ref_date);

Line 1925: fnd_file.put_line(fnd_file.log,'Cursor Looping IF count==> '||l_absence_count );

1921: or lr_absence_details.INFORMATION1 ='7' -- Study Leave
1922: THEN
1923: IF MONTHS_BETWEEN(lr_absence_details.DATE_END,lr_absence_details.DATE_START) >= 2
1924: THEN
1925: fnd_file.put_line(fnd_file.log,'Cursor Looping IF count==> '||l_absence_count );
1926: fnd_file.put_line(fnd_file.log,'START==> '||lr_absence_details.DATE_START );
1927: fnd_file.put_line(fnd_file.log,'END==> '||lr_absence_details.DATE_END );
1928:
1929:

Line 1926: fnd_file.put_line(fnd_file.log,'START==> '||lr_absence_details.DATE_START );

1922: THEN
1923: IF MONTHS_BETWEEN(lr_absence_details.DATE_END,lr_absence_details.DATE_START) >= 2
1924: THEN
1925: fnd_file.put_line(fnd_file.log,'Cursor Looping IF count==> '||l_absence_count );
1926: fnd_file.put_line(fnd_file.log,'START==> '||lr_absence_details.DATE_START );
1927: fnd_file.put_line(fnd_file.log,'END==> '||lr_absence_details.DATE_END );
1928:
1929:
1930: ABS_RECORDS(l_absence_count).CATEGORY := lr_absence_details.INFORMATION1;

Line 1927: fnd_file.put_line(fnd_file.log,'END==> '||lr_absence_details.DATE_END );

1923: IF MONTHS_BETWEEN(lr_absence_details.DATE_END,lr_absence_details.DATE_START) >= 2
1924: THEN
1925: fnd_file.put_line(fnd_file.log,'Cursor Looping IF count==> '||l_absence_count );
1926: fnd_file.put_line(fnd_file.log,'START==> '||lr_absence_details.DATE_START );
1927: fnd_file.put_line(fnd_file.log,'END==> '||lr_absence_details.DATE_END );
1928:
1929:
1930: ABS_RECORDS(l_absence_count).CATEGORY := lr_absence_details.INFORMATION1;
1931: ABS_RECORDS(l_absence_count).START_DATE := lr_absence_details.DATE_START ;

Line 1941: fnd_file.put_line(fnd_file.log,'Cursor Looping Else count==> '||l_absence_count );

1937: or lr_absence_details.ABSENCE_CATEGORY = 'FI_SAL'
1938: or lr_absence_details.ABSENCE_CATEGORY = 'M'
1939: THEN
1940: */ ELSE -- For all others, even if user adds his own code
1941: fnd_file.put_line(fnd_file.log,'Cursor Looping Else count==> '||l_absence_count );
1942: fnd_file.put_line(fnd_file.log,'START==> '||lr_absence_details.DATE_START );
1943: fnd_file.put_line(fnd_file.log,'END==> '||lr_absence_details.DATE_END );
1944:
1945:

Line 1942: fnd_file.put_line(fnd_file.log,'START==> '||lr_absence_details.DATE_START );

1938: or lr_absence_details.ABSENCE_CATEGORY = 'M'
1939: THEN
1940: */ ELSE -- For all others, even if user adds his own code
1941: fnd_file.put_line(fnd_file.log,'Cursor Looping Else count==> '||l_absence_count );
1942: fnd_file.put_line(fnd_file.log,'START==> '||lr_absence_details.DATE_START );
1943: fnd_file.put_line(fnd_file.log,'END==> '||lr_absence_details.DATE_END );
1944:
1945:
1946: ABS_RECORDS(l_absence_count).CATEGORY := lr_absence_details.INFORMATION1;

Line 1943: fnd_file.put_line(fnd_file.log,'END==> '||lr_absence_details.DATE_END );

1939: THEN
1940: */ ELSE -- For all others, even if user adds his own code
1941: fnd_file.put_line(fnd_file.log,'Cursor Looping Else count==> '||l_absence_count );
1942: fnd_file.put_line(fnd_file.log,'START==> '||lr_absence_details.DATE_START );
1943: fnd_file.put_line(fnd_file.log,'END==> '||lr_absence_details.DATE_END );
1944:
1945:
1946: ABS_RECORDS(l_absence_count).CATEGORY := lr_absence_details.INFORMATION1;
1947: ABS_RECORDS(l_absence_count).START_DATE := lr_absence_details.DATE_START ;

Line 1964: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );

1960: l_third_end_date := null;
1961:
1962: IF l_absence_count = 1
1963: THEN
1964: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );
1965: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );
1966: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
1967: l_first_category :=ABS_RECORDS(0).CATEGORY;
1968: l_first_start_date :=ABS_RECORDS(0).START_DATE;

Line 1965: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );

1961:
1962: IF l_absence_count = 1
1963: THEN
1964: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );
1965: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );
1966: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
1967: l_first_category :=ABS_RECORDS(0).CATEGORY;
1968: l_first_start_date :=ABS_RECORDS(0).START_DATE;
1969: l_first_end_date :=ABS_RECORDS(0).END_DATE ;

Line 1966: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );

1962: IF l_absence_count = 1
1963: THEN
1964: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );
1965: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );
1966: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
1967: l_first_category :=ABS_RECORDS(0).CATEGORY;
1968: l_first_start_date :=ABS_RECORDS(0).START_DATE;
1969: l_first_end_date :=ABS_RECORDS(0).END_DATE ;
1970: l_second_category := null;

Line 1979: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );

1975: l_third_end_date := null;
1976:
1977: ELSIF l_absence_count = 2
1978: THEN
1979: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );
1980: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );
1981: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
1982: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );
1983: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );

Line 1980: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );

1976:
1977: ELSIF l_absence_count = 2
1978: THEN
1979: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );
1980: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );
1981: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
1982: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );
1983: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );
1984: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1) END_DATE==> '||ABS_RECORDS(1).END_DATE );

Line 1981: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );

1977: ELSIF l_absence_count = 2
1978: THEN
1979: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );
1980: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );
1981: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
1982: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );
1983: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );
1984: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1) END_DATE==> '||ABS_RECORDS(1).END_DATE );
1985:

Line 1982: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );

1978: THEN
1979: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );
1980: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );
1981: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
1982: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );
1983: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );
1984: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1) END_DATE==> '||ABS_RECORDS(1).END_DATE );
1985:
1986: l_first_category :=ABS_RECORDS(0).CATEGORY;

Line 1983: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );

1979: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );
1980: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );
1981: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
1982: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );
1983: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );
1984: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1) END_DATE==> '||ABS_RECORDS(1).END_DATE );
1985:
1986: l_first_category :=ABS_RECORDS(0).CATEGORY;
1987: l_first_start_date :=ABS_RECORDS(0).START_DATE;

Line 1984: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1) END_DATE==> '||ABS_RECORDS(1).END_DATE );

1980: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );
1981: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
1982: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );
1983: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );
1984: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1) END_DATE==> '||ABS_RECORDS(1).END_DATE );
1985:
1986: l_first_category :=ABS_RECORDS(0).CATEGORY;
1987: l_first_start_date :=ABS_RECORDS(0).START_DATE;
1988: l_first_end_date :=ABS_RECORDS(0).END_DATE ;

Line 1997: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );

1993: l_third_start_date :=null;
1994: l_third_end_date :=null;
1995: ELSIF l_absence_count = 3
1996: THEN
1997: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );
1998: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );
1999: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
2000: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );
2001: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );

Line 1998: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );

1994: l_third_end_date :=null;
1995: ELSIF l_absence_count = 3
1996: THEN
1997: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );
1998: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );
1999: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
2000: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );
2001: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );
2002: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1) END_DATE==> '||ABS_RECORDS(1).END_DATE );

Line 1999: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );

1995: ELSIF l_absence_count = 3
1996: THEN
1997: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );
1998: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );
1999: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
2000: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );
2001: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );
2002: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1) END_DATE==> '||ABS_RECORDS(1).END_DATE );
2003: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2)CATEGORY ==> '||ABS_RECORDS(2).CATEGORY );

Line 2000: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );

1996: THEN
1997: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );
1998: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );
1999: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
2000: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );
2001: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );
2002: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1) END_DATE==> '||ABS_RECORDS(1).END_DATE );
2003: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2)CATEGORY ==> '||ABS_RECORDS(2).CATEGORY );
2004: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2) START_DATE==> '||ABS_RECORDS(2).START_DATE );

Line 2001: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );

1997: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).CATEGORY ==> '||ABS_RECORDS(0).CATEGORY );
1998: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );
1999: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
2000: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );
2001: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );
2002: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1) END_DATE==> '||ABS_RECORDS(1).END_DATE );
2003: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2)CATEGORY ==> '||ABS_RECORDS(2).CATEGORY );
2004: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2) START_DATE==> '||ABS_RECORDS(2).START_DATE );
2005: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2) END_DATE==> '||ABS_RECORDS(2).END_DATE );

Line 2002: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1) END_DATE==> '||ABS_RECORDS(1).END_DATE );

1998: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).START_DATE ==> '||ABS_RECORDS(0).START_DATE );
1999: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
2000: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );
2001: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );
2002: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1) END_DATE==> '||ABS_RECORDS(1).END_DATE );
2003: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2)CATEGORY ==> '||ABS_RECORDS(2).CATEGORY );
2004: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2) START_DATE==> '||ABS_RECORDS(2).START_DATE );
2005: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2) END_DATE==> '||ABS_RECORDS(2).END_DATE );
2006: l_first_category :=ABS_RECORDS(0).CATEGORY;

Line 2003: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2)CATEGORY ==> '||ABS_RECORDS(2).CATEGORY );

1999: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(0).END_DATE ==> '||ABS_RECORDS(0).END_DATE );
2000: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );
2001: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );
2002: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1) END_DATE==> '||ABS_RECORDS(1).END_DATE );
2003: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2)CATEGORY ==> '||ABS_RECORDS(2).CATEGORY );
2004: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2) START_DATE==> '||ABS_RECORDS(2).START_DATE );
2005: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2) END_DATE==> '||ABS_RECORDS(2).END_DATE );
2006: l_first_category :=ABS_RECORDS(0).CATEGORY;
2007: l_first_start_date :=ABS_RECORDS(0).START_DATE;

Line 2004: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2) START_DATE==> '||ABS_RECORDS(2).START_DATE );

2000: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)CATEGORY ==> '||ABS_RECORDS(1).CATEGORY );
2001: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );
2002: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1) END_DATE==> '||ABS_RECORDS(1).END_DATE );
2003: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2)CATEGORY ==> '||ABS_RECORDS(2).CATEGORY );
2004: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2) START_DATE==> '||ABS_RECORDS(2).START_DATE );
2005: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2) END_DATE==> '||ABS_RECORDS(2).END_DATE );
2006: l_first_category :=ABS_RECORDS(0).CATEGORY;
2007: l_first_start_date :=ABS_RECORDS(0).START_DATE;
2008: l_first_end_date :=ABS_RECORDS(0).END_DATE ;

Line 2005: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2) END_DATE==> '||ABS_RECORDS(2).END_DATE );

2001: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1)START_DATE ==> '||ABS_RECORDS(1).START_DATE );
2002: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(1) END_DATE==> '||ABS_RECORDS(1).END_DATE );
2003: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2)CATEGORY ==> '||ABS_RECORDS(2).CATEGORY );
2004: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2) START_DATE==> '||ABS_RECORDS(2).START_DATE );
2005: fnd_file.put_line(fnd_file.log,'ABS_RECORDS(2) END_DATE==> '||ABS_RECORDS(2).END_DATE );
2006: l_first_category :=ABS_RECORDS(0).CATEGORY;
2007: l_first_start_date :=ABS_RECORDS(0).START_DATE;
2008: l_first_end_date :=ABS_RECORDS(0).END_DATE ;
2009: l_second_category :=ABS_RECORDS(1).CATEGORY;

Line 2027: fnd_file.put_line(fnd_file.log,'FINALLY+++++++++++++');

2023: l_third_category := null;
2024: l_third_start_date := null;
2025: l_third_end_date := null;
2026: END IF;
2027: fnd_file.put_line(fnd_file.log,'FINALLY+++++++++++++');
2028: fnd_file.put_line(fnd_file.log,'(0).CATEGORY ==> '|| l_first_category);
2029: fnd_file.put_line(fnd_file.log,'(0).START_DATE ==> '||l_first_start_date );
2030: fnd_file.put_line(fnd_file.log,'(0).END_DATE ==> '|| l_first_end_date);
2031: fnd_file.put_line(fnd_file.log,'(1)CATEGORY ==> '||l_second_category );

Line 2028: fnd_file.put_line(fnd_file.log,'(0).CATEGORY ==> '|| l_first_category);

2024: l_third_start_date := null;
2025: l_third_end_date := null;
2026: END IF;
2027: fnd_file.put_line(fnd_file.log,'FINALLY+++++++++++++');
2028: fnd_file.put_line(fnd_file.log,'(0).CATEGORY ==> '|| l_first_category);
2029: fnd_file.put_line(fnd_file.log,'(0).START_DATE ==> '||l_first_start_date );
2030: fnd_file.put_line(fnd_file.log,'(0).END_DATE ==> '|| l_first_end_date);
2031: fnd_file.put_line(fnd_file.log,'(1)CATEGORY ==> '||l_second_category );
2032: fnd_file.put_line(fnd_file.log,'(1)START_DATE ==> '||l_second_start_date );

Line 2029: fnd_file.put_line(fnd_file.log,'(0).START_DATE ==> '||l_first_start_date );

2025: l_third_end_date := null;
2026: END IF;
2027: fnd_file.put_line(fnd_file.log,'FINALLY+++++++++++++');
2028: fnd_file.put_line(fnd_file.log,'(0).CATEGORY ==> '|| l_first_category);
2029: fnd_file.put_line(fnd_file.log,'(0).START_DATE ==> '||l_first_start_date );
2030: fnd_file.put_line(fnd_file.log,'(0).END_DATE ==> '|| l_first_end_date);
2031: fnd_file.put_line(fnd_file.log,'(1)CATEGORY ==> '||l_second_category );
2032: fnd_file.put_line(fnd_file.log,'(1)START_DATE ==> '||l_second_start_date );
2033: fnd_file.put_line(fnd_file.log,'(1) END_DATE==> '|| l_second_end_date);

Line 2030: fnd_file.put_line(fnd_file.log,'(0).END_DATE ==> '|| l_first_end_date);

2026: END IF;
2027: fnd_file.put_line(fnd_file.log,'FINALLY+++++++++++++');
2028: fnd_file.put_line(fnd_file.log,'(0).CATEGORY ==> '|| l_first_category);
2029: fnd_file.put_line(fnd_file.log,'(0).START_DATE ==> '||l_first_start_date );
2030: fnd_file.put_line(fnd_file.log,'(0).END_DATE ==> '|| l_first_end_date);
2031: fnd_file.put_line(fnd_file.log,'(1)CATEGORY ==> '||l_second_category );
2032: fnd_file.put_line(fnd_file.log,'(1)START_DATE ==> '||l_second_start_date );
2033: fnd_file.put_line(fnd_file.log,'(1) END_DATE==> '|| l_second_end_date);
2034: fnd_file.put_line(fnd_file.log,'(2)CATEGORY ==> '||l_third_category );

Line 2031: fnd_file.put_line(fnd_file.log,'(1)CATEGORY ==> '||l_second_category );

2027: fnd_file.put_line(fnd_file.log,'FINALLY+++++++++++++');
2028: fnd_file.put_line(fnd_file.log,'(0).CATEGORY ==> '|| l_first_category);
2029: fnd_file.put_line(fnd_file.log,'(0).START_DATE ==> '||l_first_start_date );
2030: fnd_file.put_line(fnd_file.log,'(0).END_DATE ==> '|| l_first_end_date);
2031: fnd_file.put_line(fnd_file.log,'(1)CATEGORY ==> '||l_second_category );
2032: fnd_file.put_line(fnd_file.log,'(1)START_DATE ==> '||l_second_start_date );
2033: fnd_file.put_line(fnd_file.log,'(1) END_DATE==> '|| l_second_end_date);
2034: fnd_file.put_line(fnd_file.log,'(2)CATEGORY ==> '||l_third_category );
2035: fnd_file.put_line(fnd_file.log,'(2) START_DATE==> '|| l_third_start_date);

Line 2032: fnd_file.put_line(fnd_file.log,'(1)START_DATE ==> '||l_second_start_date );

2028: fnd_file.put_line(fnd_file.log,'(0).CATEGORY ==> '|| l_first_category);
2029: fnd_file.put_line(fnd_file.log,'(0).START_DATE ==> '||l_first_start_date );
2030: fnd_file.put_line(fnd_file.log,'(0).END_DATE ==> '|| l_first_end_date);
2031: fnd_file.put_line(fnd_file.log,'(1)CATEGORY ==> '||l_second_category );
2032: fnd_file.put_line(fnd_file.log,'(1)START_DATE ==> '||l_second_start_date );
2033: fnd_file.put_line(fnd_file.log,'(1) END_DATE==> '|| l_second_end_date);
2034: fnd_file.put_line(fnd_file.log,'(2)CATEGORY ==> '||l_third_category );
2035: fnd_file.put_line(fnd_file.log,'(2) START_DATE==> '|| l_third_start_date);
2036: fnd_file.put_line(fnd_file.log,'(2) END_DATE==> '|| l_third_end_date);

Line 2033: fnd_file.put_line(fnd_file.log,'(1) END_DATE==> '|| l_second_end_date);

2029: fnd_file.put_line(fnd_file.log,'(0).START_DATE ==> '||l_first_start_date );
2030: fnd_file.put_line(fnd_file.log,'(0).END_DATE ==> '|| l_first_end_date);
2031: fnd_file.put_line(fnd_file.log,'(1)CATEGORY ==> '||l_second_category );
2032: fnd_file.put_line(fnd_file.log,'(1)START_DATE ==> '||l_second_start_date );
2033: fnd_file.put_line(fnd_file.log,'(1) END_DATE==> '|| l_second_end_date);
2034: fnd_file.put_line(fnd_file.log,'(2)CATEGORY ==> '||l_third_category );
2035: fnd_file.put_line(fnd_file.log,'(2) START_DATE==> '|| l_third_start_date);
2036: fnd_file.put_line(fnd_file.log,'(2) END_DATE==> '|| l_third_end_date);
2037:

Line 2034: fnd_file.put_line(fnd_file.log,'(2)CATEGORY ==> '||l_third_category );

2030: fnd_file.put_line(fnd_file.log,'(0).END_DATE ==> '|| l_first_end_date);
2031: fnd_file.put_line(fnd_file.log,'(1)CATEGORY ==> '||l_second_category );
2032: fnd_file.put_line(fnd_file.log,'(1)START_DATE ==> '||l_second_start_date );
2033: fnd_file.put_line(fnd_file.log,'(1) END_DATE==> '|| l_second_end_date);
2034: fnd_file.put_line(fnd_file.log,'(2)CATEGORY ==> '||l_third_category );
2035: fnd_file.put_line(fnd_file.log,'(2) START_DATE==> '|| l_third_start_date);
2036: fnd_file.put_line(fnd_file.log,'(2) END_DATE==> '|| l_third_end_date);
2037:
2038:

Line 2035: fnd_file.put_line(fnd_file.log,'(2) START_DATE==> '|| l_third_start_date);

2031: fnd_file.put_line(fnd_file.log,'(1)CATEGORY ==> '||l_second_category );
2032: fnd_file.put_line(fnd_file.log,'(1)START_DATE ==> '||l_second_start_date );
2033: fnd_file.put_line(fnd_file.log,'(1) END_DATE==> '|| l_second_end_date);
2034: fnd_file.put_line(fnd_file.log,'(2)CATEGORY ==> '||l_third_category );
2035: fnd_file.put_line(fnd_file.log,'(2) START_DATE==> '|| l_third_start_date);
2036: fnd_file.put_line(fnd_file.log,'(2) END_DATE==> '|| l_third_end_date);
2037:
2038:
2039:

Line 2036: fnd_file.put_line(fnd_file.log,'(2) END_DATE==> '|| l_third_end_date);

2032: fnd_file.put_line(fnd_file.log,'(1)START_DATE ==> '||l_second_start_date );
2033: fnd_file.put_line(fnd_file.log,'(1) END_DATE==> '|| l_second_end_date);
2034: fnd_file.put_line(fnd_file.log,'(2)CATEGORY ==> '||l_third_category );
2035: fnd_file.put_line(fnd_file.log,'(2) START_DATE==> '|| l_third_start_date);
2036: fnd_file.put_line(fnd_file.log,'(2) END_DATE==> '|| l_third_end_date);
2037:
2038:
2039:
2040: pay_action_information_api.create_action_information (

Line 2127: fnd_file.put_line(fnd_file.log,'End of a person ==> '||l_action_info_id );

2123: p_action_information29 => NULL,
2124: p_action_information30 => l_person_id,
2125: p_assignment_id => l_assignment_id
2126: );
2127: fnd_file.put_line(fnd_file.log,'End of a person ==> '||l_action_info_id );
2128: END LOOP;
2129:
2130: WHEN OTHERS
2131: THEN

Line 2135: fnd_file.put_line(fnd_file.log,'Leaving Procedure ARCHIVE_CODE');

2131: THEN
2132: NULL;
2133: END;
2134: END IF;
2135: fnd_file.put_line(fnd_file.log,'Leaving Procedure ARCHIVE_CODE');
2136: IF g_debug THEN
2137: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
2138: END IF;
2139: