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

Line 155: /* fnd_file.put_line (fnd_file.LOG,

151: lr_parameter_info csr_parameter_info%ROWTYPE;
152: l_proc VARCHAR2 (240)
153: := g_package || ' GET_ALL_PARAMETERS ';
154: BEGIN
155: /* fnd_file.put_line (fnd_file.LOG,
156: 'Entering Procedure GET_ALL_PARAMETER '
157: );
158: fnd_file.put_line (fnd_file.LOG,
159: 'Payroill Action iD ' || p_payroll_action_id

Line 158: fnd_file.put_line (fnd_file.LOG,

154: BEGIN
155: /* fnd_file.put_line (fnd_file.LOG,
156: 'Entering Procedure GET_ALL_PARAMETER '
157: );
158: fnd_file.put_line (fnd_file.LOG,
159: 'Payroill Action iD ' || p_payroll_action_id
160: );
161: */
162: OPEN csr_parameter_info (p_payroll_action_id);

Line 180: fnd_file.put_line (fnd_file.LOG,

176: p_production := (lr_parameter_info.production);
177: p_effective_date := lr_parameter_info.effective_date;
178: p_business_group_id := lr_parameter_info.bg_id;
179: /*
180: fnd_file.put_line (fnd_file.LOG,
181: 'lr_parameter_info.Legal '
182: || lr_parameter_info.legal
183: );
184: fnd_file.put_line (fnd_file.LOG,

Line 184: fnd_file.put_line (fnd_file.LOG,

180: fnd_file.put_line (fnd_file.LOG,
181: 'lr_parameter_info.Legal '
182: || lr_parameter_info.legal
183: );
184: fnd_file.put_line (fnd_file.LOG,
185: 'lr_parameter_info.REQUEST_FOR '
186: || lr_parameter_info.request_for
187: );
188: fnd_file.put_line (fnd_file.LOG,

Line 188: fnd_file.put_line (fnd_file.LOG,

184: fnd_file.put_line (fnd_file.LOG,
185: 'lr_parameter_info.REQUEST_FOR '
186: || lr_parameter_info.request_for
187: );
188: fnd_file.put_line (fnd_file.LOG,
189: 'lr_parameter_info.YEAR ' || lr_parameter_info.REPORT_YEAR
190: );
191:
192: fnd_file.put_line (fnd_file.LOG,

Line 192: fnd_file.put_line (fnd_file.LOG,

188: fnd_file.put_line (fnd_file.LOG,
189: 'lr_parameter_info.YEAR ' || lr_parameter_info.REPORT_YEAR
190: );
191:
192: fnd_file.put_line (fnd_file.LOG,
193: 'lr_parameter_info.MONTH '
194: || lr_parameter_info.REPORT_MONTH
195: );
196:

Line 197: fnd_file.put_line (fnd_file.LOG,

193: 'lr_parameter_info.MONTH '
194: || lr_parameter_info.REPORT_MONTH
195: );
196:
197: fnd_file.put_line (fnd_file.LOG,
198: 'lr_parameter_info.Effective_date '
199: || lr_parameter_info.effective_date
200: );
201:

Line 202: fnd_file.put_line (fnd_file.LOG, 'After csr_parameter_info in ');

198: 'lr_parameter_info.Effective_date '
199: || lr_parameter_info.effective_date
200: );
201:
202: fnd_file.put_line (fnd_file.LOG, 'After csr_parameter_info in ');
203: fnd_file.put_line (fnd_file.LOG,
204: 'After p_legal_employer_id in '
205: || p_legal_employer_id
206: );

Line 203: fnd_file.put_line (fnd_file.LOG,

199: || lr_parameter_info.effective_date
200: );
201:
202: fnd_file.put_line (fnd_file.LOG, 'After csr_parameter_info in ');
203: fnd_file.put_line (fnd_file.LOG,
204: 'After p_legal_employer_id in '
205: || p_legal_employer_id
206: );
207: */

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

390: ,p_action_information10 => l_legal_employer_details.org_number -- changes 2009/2010
391: );
392: -- *****************************************************************************
393:
394: --fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
395: --fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
396:
397: --fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
398: --fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );

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

391: );
392: -- *****************************************************************************
393:
394: --fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
395: --fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
396:
397: --fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
398: --fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
399:

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

393:
394: --fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
395: --fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
396:
397: --fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
398: --fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
399:
400:
401: -- *****************************************************************************

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

394: --fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
395: --fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
396:
397: --fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
398: --fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
399:
400:
401: -- *****************************************************************************
402: /* IF g_request_for = 'REQUESTING_ORG'

Line 566: -- fnd_file.put_line (fnd_file.LOG, ' ASSIGNMENT_ACTION_CODE ');

562: l_local_unit_id NUMBER;
563: l_archive VARCHAR2 (10);
564: -- End of User pARAMETERS needed
565: BEGIN
566: -- fnd_file.put_line (fnd_file.LOG, ' ASSIGNMENT_ACTION_CODE ');
567: pay_se_alecta.get_all_parameters (p_payroll_action_id
568: ,g_business_group_id
569: ,g_effective_date
570: ,g_legal_employer_id

Line 578: --fnd_file.put_line(fnd_file.log,' g_year '|| g_year);

574: ,g_sent_from
575: ,g_sent_to
576: ,g_production
577: );
578: --fnd_file.put_line(fnd_file.log,' g_year '|| g_year);
579: --fnd_file.put_line(fnd_file.log,' g_month '|| g_month);
580: l_canonical_start_date :=
581: fnd_date.string_to_date (('01-' || TRUNC (g_month) || '-' || g_year)
582: ,'DD-MM-YYYY'

Line 579: --fnd_file.put_line(fnd_file.log,' g_month '|| g_month);

575: ,g_sent_to
576: ,g_production
577: );
578: --fnd_file.put_line(fnd_file.log,' g_year '|| g_year);
579: --fnd_file.put_line(fnd_file.log,' g_month '|| g_month);
580: l_canonical_start_date :=
581: fnd_date.string_to_date (('01-' || TRUNC (g_month) || '-' || g_year)
582: ,'DD-MM-YYYY'
583: );

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

582: ,'DD-MM-YYYY'
583: );
584: l_canonical_end_date := LAST_DAY (l_canonical_start_date);
585: l_prepay_action_id := 0;
586: --fnd_file.put_line(fnd_file.log,' g_local_unit_id '|| g_local_unit_id);
587:
588: --fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');
589: /*
590: fnd_file.put_line (fnd_file.LOG,

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

584: l_canonical_end_date := LAST_DAY (l_canonical_start_date);
585: l_prepay_action_id := 0;
586: --fnd_file.put_line(fnd_file.log,' g_local_unit_id '|| g_local_unit_id);
587:
588: --fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');
589: /*
590: fnd_file.put_line (fnd_file.LOG,
591: ' p_payroll_action_id ==> ' || p_payroll_action_id
592: );

Line 590: fnd_file.put_line (fnd_file.LOG,

586: --fnd_file.put_line(fnd_file.log,' g_local_unit_id '|| g_local_unit_id);
587:
588: --fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');
589: /*
590: fnd_file.put_line (fnd_file.LOG,
591: ' p_payroll_action_id ==> ' || p_payroll_action_id
592: );
593: fnd_file.put_line (fnd_file.LOG,
594: ' g_legal_employer_id ==> ' || g_legal_employer_id

Line 593: fnd_file.put_line (fnd_file.LOG,

589: /*
590: fnd_file.put_line (fnd_file.LOG,
591: ' p_payroll_action_id ==> ' || p_payroll_action_id
592: );
593: fnd_file.put_line (fnd_file.LOG,
594: ' g_legal_employer_id ==> ' || g_legal_employer_id
595: );
596: fnd_file.put_line (fnd_file.LOG,
597: ' g_effective_date ==> ' || g_effective_date

Line 596: fnd_file.put_line (fnd_file.LOG,

592: );
593: fnd_file.put_line (fnd_file.LOG,
594: ' g_legal_employer_id ==> ' || g_legal_employer_id
595: );
596: fnd_file.put_line (fnd_file.LOG,
597: ' g_effective_date ==> ' || g_effective_date
598: );
599: fnd_file.put_line (fnd_file.LOG,
600: ' l_canonical_start_date ==> '

Line 599: fnd_file.put_line (fnd_file.LOG,

595: );
596: fnd_file.put_line (fnd_file.LOG,
597: ' g_effective_date ==> ' || g_effective_date
598: );
599: fnd_file.put_line (fnd_file.LOG,
600: ' l_canonical_start_date ==> '
601: || l_canonical_start_date
602: );
603: fnd_file.put_line (fnd_file.LOG,

Line 603: fnd_file.put_line (fnd_file.LOG,

599: fnd_file.put_line (fnd_file.LOG,
600: ' l_canonical_start_date ==> '
601: || l_canonical_start_date
602: );
603: fnd_file.put_line (fnd_file.LOG,
604: ' l_canonical_end_date ==> ' || l_canonical_end_date
605: );
606: */
607: --fnd_file.put_line(fnd_file.log,' INSIDE ELS LOCAL UNIT NULL ');

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

603: fnd_file.put_line (fnd_file.LOG,
604: ' l_canonical_end_date ==> ' || l_canonical_end_date
605: );
606: */
607: --fnd_file.put_line(fnd_file.log,' INSIDE ELS LOCAL UNIT NULL ');
608: l_assignment_id := 0;
609:
610: FOR rec_prepaid_assignments IN
611: csr_prepaid_assignments_le (p_payroll_action_id

Line 642: fnd_file.put_line

638: --hr_nonrun_asact.insint(l_actid,rec_prepaid_assignments.run_action_id);
639: l_assignment_id := rec_prepaid_assignments.assignment_id;
640: END LOOP;
641: /*
642: fnd_file.put_line
643: (fnd_file.LOG,
644: ' After Ending Assignment Act Code the Locking Cursor '
645: );
646: */

Line 643: (fnd_file.LOG,

639: l_assignment_id := rec_prepaid_assignments.assignment_id;
640: END LOOP;
641: /*
642: fnd_file.put_line
643: (fnd_file.LOG,
644: ' After Ending Assignment Act Code the Locking Cursor '
645: );
646: */
647: EXCEPTION

Line 2808: fnd_file.put_line (fnd_file.LOG, 'After csr_REPORT_DETAILS ');

2804: -------------------------------------------------------------------------------------------------------------
2805:
2806: /* add_tag_value ('PERIOD_FROM', lr_report_details.period_from);
2807: add_tag_value ('PERIOD_TO', lr_report_details.period_to);
2808: fnd_file.put_line (fnd_file.LOG, 'After csr_REPORT_DETAILS ');
2809: fnd_file.put_line (fnd_file.LOG,
2810: 'PERIOD_FROM ' || lr_report_details.period_from
2811: );
2812: fnd_file.put_line (fnd_file.LOG,

Line 2809: fnd_file.put_line (fnd_file.LOG,

2805:
2806: /* add_tag_value ('PERIOD_FROM', lr_report_details.period_from);
2807: add_tag_value ('PERIOD_TO', lr_report_details.period_to);
2808: fnd_file.put_line (fnd_file.LOG, 'After csr_REPORT_DETAILS ');
2809: fnd_file.put_line (fnd_file.LOG,
2810: 'PERIOD_FROM ' || lr_report_details.period_from
2811: );
2812: fnd_file.put_line (fnd_file.LOG,
2813: 'PERIOD_TO ' || lr_report_details.period_to

Line 2812: fnd_file.put_line (fnd_file.LOG,

2808: fnd_file.put_line (fnd_file.LOG, 'After csr_REPORT_DETAILS ');
2809: fnd_file.put_line (fnd_file.LOG,
2810: 'PERIOD_FROM ' || lr_report_details.period_from
2811: );
2812: fnd_file.put_line (fnd_file.LOG,
2813: 'PERIOD_TO ' || lr_report_details.period_to
2814: );
2815: fnd_file.put_line (fnd_file.LOG, 'Before Csr for Legal');
2816:

Line 2815: fnd_file.put_line (fnd_file.LOG, 'Before Csr for Legal');

2811: );
2812: fnd_file.put_line (fnd_file.LOG,
2813: 'PERIOD_TO ' || lr_report_details.period_to
2814: );
2815: fnd_file.put_line (fnd_file.LOG, 'Before Csr for Legal');
2816:
2817: FOR rec_all_le IN csr_all_legal_employer (l_payroll_action_id)
2818: LOOP
2819: add_tag_value ('LEGAL_EMPLOYER', 'LEGAL_EMPLOYER');

Line 2825: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');

2821: add_tag_value ('LE_NAME', rec_all_le.action_information4);
2822: add_tag_value ('LE_ORG_NUM', rec_all_le.action_information5);
2823: add_tag_value ('LE_DETAILS', 'LE_DETAILS_END');
2824: add_tag_value ('EMPLOYEES', 'EMPLOYEES');
2825: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2826: fnd_file.put_line (fnd_file.LOG, 'Legal Employer');
2827: fnd_file.put_line (fnd_file.LOG,
2828: 'LE ID ' || rec_all_le.action_information3
2829: );

Line 2826: fnd_file.put_line (fnd_file.LOG, 'Legal Employer');

2822: add_tag_value ('LE_ORG_NUM', rec_all_le.action_information5);
2823: add_tag_value ('LE_DETAILS', 'LE_DETAILS_END');
2824: add_tag_value ('EMPLOYEES', 'EMPLOYEES');
2825: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2826: fnd_file.put_line (fnd_file.LOG, 'Legal Employer');
2827: fnd_file.put_line (fnd_file.LOG,
2828: 'LE ID ' || rec_all_le.action_information3
2829: );
2830: fnd_file.put_line (fnd_file.LOG,

Line 2827: fnd_file.put_line (fnd_file.LOG,

2823: add_tag_value ('LE_DETAILS', 'LE_DETAILS_END');
2824: add_tag_value ('EMPLOYEES', 'EMPLOYEES');
2825: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2826: fnd_file.put_line (fnd_file.LOG, 'Legal Employer');
2827: fnd_file.put_line (fnd_file.LOG,
2828: 'LE ID ' || rec_all_le.action_information3
2829: );
2830: fnd_file.put_line (fnd_file.LOG,
2831: 'LE_NAME ' || rec_all_le.action_information4

Line 2830: fnd_file.put_line (fnd_file.LOG,

2826: fnd_file.put_line (fnd_file.LOG, 'Legal Employer');
2827: fnd_file.put_line (fnd_file.LOG,
2828: 'LE ID ' || rec_all_le.action_information3
2829: );
2830: fnd_file.put_line (fnd_file.LOG,
2831: 'LE_NAME ' || rec_all_le.action_information4
2832: );
2833: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2834: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');

Line 2833: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');

2829: );
2830: fnd_file.put_line (fnd_file.LOG,
2831: 'LE_NAME ' || rec_all_le.action_information4
2832: );
2833: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2834: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2835: fnd_file.put_line (fnd_file.LOG, ' Inside Person Query');
2836:
2837: FOR rec_all_emp_under_le IN

Line 2834: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');

2830: fnd_file.put_line (fnd_file.LOG,
2831: 'LE_NAME ' || rec_all_le.action_information4
2832: );
2833: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2834: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2835: fnd_file.put_line (fnd_file.LOG, ' Inside Person Query');
2836:
2837: FOR rec_all_emp_under_le IN
2838: csr_all_employees_under_le (l_payroll_action_id,

Line 2835: fnd_file.put_line (fnd_file.LOG, ' Inside Person Query');

2831: 'LE_NAME ' || rec_all_le.action_information4
2832: );
2833: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2834: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2835: fnd_file.put_line (fnd_file.LOG, ' Inside Person Query');
2836:
2837: FOR rec_all_emp_under_le IN
2838: csr_all_employees_under_le (l_payroll_action_id,
2839: rec_all_le.action_information3

Line 2842: fnd_file.put_line (fnd_file.LOG,

2838: csr_all_employees_under_le (l_payroll_action_id,
2839: rec_all_le.action_information3
2840: )
2841: LOOP
2842: fnd_file.put_line (fnd_file.LOG,
2843: 'PERSON ID ==> '
2844: || rec_all_emp_under_le.action_information30
2845: );
2846: add_tag_value ('PERSON', 'PERSON');

Line 2900: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');

2896: );
2897: add_tag_value ('PERSON', 'PERSON_END');
2898: END LOOP; -- For all EMPLOYEES
2899:
2900: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2901: add_tag_value ('EMPLOYEES', 'EMPLOYEES_END');
2902: add_tag_value ('LEGAL_EMPLOYER', 'LEGAL_EMPLOYER_END');
2903: END LOOP; -- For all LEGAL_EMPLYER
2904: */

Line 2919: fnd_file.put_line (fnd_file.LOG

2915: /* Proc to Add the tag value and Name */
2916: PROCEDURE logger (p_display IN VARCHAR2, p_value IN VARCHAR2)
2917: IS
2918: BEGIN
2919: fnd_file.put_line (fnd_file.LOG
2920: , p_display || ' ==> ' || p_value
2921: );
2922: END logger;
2923: