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 354: --fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );

350: ,p_action_information10 => NULL
351: );
352: -- *****************************************************************************
353:
354: --fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
355: --fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
356:
357: --fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
358: --fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );

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

351: );
352: -- *****************************************************************************
353:
354: --fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
355: --fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
356:
357: --fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
358: --fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
359:

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

353:
354: --fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
355: --fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
356:
357: --fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
358: --fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
359:
360:
361: -- *****************************************************************************

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

354: --fnd_file.put_line(fnd_file.log,'PENSION provider name ==> '||lr_pension_provider_details.NAME );
355: --fnd_file.put_line(fnd_file.log,'PENSION provider ID ==> '||g_pension_provider_id);
356:
357: --fnd_file.put_line(fnd_file.log,'Local Unit ID ==> '||g_local_unit_id);
358: --fnd_file.put_line(fnd_file.log,'acti_info_id ==> '||l_action_info_id );
359:
360:
361: -- *****************************************************************************
362: /* IF g_request_for = 'REQUESTING_ORG'

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

522: l_local_unit_id NUMBER;
523: l_archive VARCHAR2 (10);
524: -- End of User pARAMETERS needed
525: BEGIN
526: -- fnd_file.put_line (fnd_file.LOG, ' ASSIGNMENT_ACTION_CODE ');
527: pay_se_alecta.get_all_parameters (p_payroll_action_id
528: ,g_business_group_id
529: ,g_effective_date
530: ,g_legal_employer_id

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

534: ,g_sent_from
535: ,g_sent_to
536: ,g_production
537: );
538: --fnd_file.put_line(fnd_file.log,' g_year '|| g_year);
539: --fnd_file.put_line(fnd_file.log,' g_month '|| g_month);
540: l_canonical_start_date :=
541: fnd_date.string_to_date (('01-' || TRUNC (g_month) || '-' || g_year)
542: ,'DD-MM-YYYY'

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

535: ,g_sent_to
536: ,g_production
537: );
538: --fnd_file.put_line(fnd_file.log,' g_year '|| g_year);
539: --fnd_file.put_line(fnd_file.log,' g_month '|| g_month);
540: l_canonical_start_date :=
541: fnd_date.string_to_date (('01-' || TRUNC (g_month) || '-' || g_year)
542: ,'DD-MM-YYYY'
543: );

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

542: ,'DD-MM-YYYY'
543: );
544: l_canonical_end_date := LAST_DAY (l_canonical_start_date);
545: l_prepay_action_id := 0;
546: --fnd_file.put_line(fnd_file.log,' g_local_unit_id '|| g_local_unit_id);
547:
548: --fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');
549: /*
550: fnd_file.put_line (fnd_file.LOG,

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

544: l_canonical_end_date := LAST_DAY (l_canonical_start_date);
545: l_prepay_action_id := 0;
546: --fnd_file.put_line(fnd_file.log,' g_local_unit_id '|| g_local_unit_id);
547:
548: --fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');
549: /*
550: fnd_file.put_line (fnd_file.LOG,
551: ' p_payroll_action_id ==> ' || p_payroll_action_id
552: );

Line 550: fnd_file.put_line (fnd_file.LOG,

546: --fnd_file.put_line(fnd_file.log,' g_local_unit_id '|| g_local_unit_id);
547:
548: --fnd_file.put_line(fnd_file.log,' INSIDE IF LOCAL UNIT NOT NULL ');
549: /*
550: fnd_file.put_line (fnd_file.LOG,
551: ' p_payroll_action_id ==> ' || p_payroll_action_id
552: );
553: fnd_file.put_line (fnd_file.LOG,
554: ' g_legal_employer_id ==> ' || g_legal_employer_id

Line 553: fnd_file.put_line (fnd_file.LOG,

549: /*
550: fnd_file.put_line (fnd_file.LOG,
551: ' p_payroll_action_id ==> ' || p_payroll_action_id
552: );
553: fnd_file.put_line (fnd_file.LOG,
554: ' g_legal_employer_id ==> ' || g_legal_employer_id
555: );
556: fnd_file.put_line (fnd_file.LOG,
557: ' g_effective_date ==> ' || g_effective_date

Line 556: fnd_file.put_line (fnd_file.LOG,

552: );
553: fnd_file.put_line (fnd_file.LOG,
554: ' g_legal_employer_id ==> ' || g_legal_employer_id
555: );
556: fnd_file.put_line (fnd_file.LOG,
557: ' g_effective_date ==> ' || g_effective_date
558: );
559: fnd_file.put_line (fnd_file.LOG,
560: ' l_canonical_start_date ==> '

Line 559: fnd_file.put_line (fnd_file.LOG,

555: );
556: fnd_file.put_line (fnd_file.LOG,
557: ' g_effective_date ==> ' || g_effective_date
558: );
559: fnd_file.put_line (fnd_file.LOG,
560: ' l_canonical_start_date ==> '
561: || l_canonical_start_date
562: );
563: fnd_file.put_line (fnd_file.LOG,

Line 563: fnd_file.put_line (fnd_file.LOG,

559: fnd_file.put_line (fnd_file.LOG,
560: ' l_canonical_start_date ==> '
561: || l_canonical_start_date
562: );
563: fnd_file.put_line (fnd_file.LOG,
564: ' l_canonical_end_date ==> ' || l_canonical_end_date
565: );
566: */
567: --fnd_file.put_line(fnd_file.log,' INSIDE ELS LOCAL UNIT NULL ');

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

563: fnd_file.put_line (fnd_file.LOG,
564: ' l_canonical_end_date ==> ' || l_canonical_end_date
565: );
566: */
567: --fnd_file.put_line(fnd_file.log,' INSIDE ELS LOCAL UNIT NULL ');
568: l_assignment_id := 0;
569:
570: FOR rec_prepaid_assignments IN
571: csr_prepaid_assignments_le (p_payroll_action_id

Line 602: fnd_file.put_line

598: --hr_nonrun_asact.insint(l_actid,rec_prepaid_assignments.run_action_id);
599: l_assignment_id := rec_prepaid_assignments.assignment_id;
600: END LOOP;
601: /*
602: fnd_file.put_line
603: (fnd_file.LOG,
604: ' After Ending Assignment Act Code the Locking Cursor '
605: );
606: */

Line 603: (fnd_file.LOG,

599: l_assignment_id := rec_prepaid_assignments.assignment_id;
600: END LOOP;
601: /*
602: fnd_file.put_line
603: (fnd_file.LOG,
604: ' After Ending Assignment Act Code the Locking Cursor '
605: );
606: */
607: EXCEPTION

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

2376: END LOOP;
2377: --END IF;
2378: /* add_tag_value ('PERIOD_FROM', lr_report_details.period_from);
2379: add_tag_value ('PERIOD_TO', lr_report_details.period_to);
2380: fnd_file.put_line (fnd_file.LOG, 'After csr_REPORT_DETAILS ');
2381: fnd_file.put_line (fnd_file.LOG,
2382: 'PERIOD_FROM ' || lr_report_details.period_from
2383: );
2384: fnd_file.put_line (fnd_file.LOG,

Line 2381: fnd_file.put_line (fnd_file.LOG,

2377: --END IF;
2378: /* add_tag_value ('PERIOD_FROM', lr_report_details.period_from);
2379: add_tag_value ('PERIOD_TO', lr_report_details.period_to);
2380: fnd_file.put_line (fnd_file.LOG, 'After csr_REPORT_DETAILS ');
2381: fnd_file.put_line (fnd_file.LOG,
2382: 'PERIOD_FROM ' || lr_report_details.period_from
2383: );
2384: fnd_file.put_line (fnd_file.LOG,
2385: 'PERIOD_TO ' || lr_report_details.period_to

Line 2384: fnd_file.put_line (fnd_file.LOG,

2380: fnd_file.put_line (fnd_file.LOG, 'After csr_REPORT_DETAILS ');
2381: fnd_file.put_line (fnd_file.LOG,
2382: 'PERIOD_FROM ' || lr_report_details.period_from
2383: );
2384: fnd_file.put_line (fnd_file.LOG,
2385: 'PERIOD_TO ' || lr_report_details.period_to
2386: );
2387: fnd_file.put_line (fnd_file.LOG, 'Before Csr for Legal');
2388:

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

2383: );
2384: fnd_file.put_line (fnd_file.LOG,
2385: 'PERIOD_TO ' || lr_report_details.period_to
2386: );
2387: fnd_file.put_line (fnd_file.LOG, 'Before Csr for Legal');
2388:
2389: FOR rec_all_le IN csr_all_legal_employer (l_payroll_action_id)
2390: LOOP
2391: add_tag_value ('LEGAL_EMPLOYER', 'LEGAL_EMPLOYER');

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

2393: add_tag_value ('LE_NAME', rec_all_le.action_information4);
2394: add_tag_value ('LE_ORG_NUM', rec_all_le.action_information5);
2395: add_tag_value ('LE_DETAILS', 'LE_DETAILS_END');
2396: add_tag_value ('EMPLOYEES', 'EMPLOYEES');
2397: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2398: fnd_file.put_line (fnd_file.LOG, 'Legal Employer');
2399: fnd_file.put_line (fnd_file.LOG,
2400: 'LE ID ' || rec_all_le.action_information3
2401: );

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

2394: add_tag_value ('LE_ORG_NUM', rec_all_le.action_information5);
2395: add_tag_value ('LE_DETAILS', 'LE_DETAILS_END');
2396: add_tag_value ('EMPLOYEES', 'EMPLOYEES');
2397: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2398: fnd_file.put_line (fnd_file.LOG, 'Legal Employer');
2399: fnd_file.put_line (fnd_file.LOG,
2400: 'LE ID ' || rec_all_le.action_information3
2401: );
2402: fnd_file.put_line (fnd_file.LOG,

Line 2399: fnd_file.put_line (fnd_file.LOG,

2395: add_tag_value ('LE_DETAILS', 'LE_DETAILS_END');
2396: add_tag_value ('EMPLOYEES', 'EMPLOYEES');
2397: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2398: fnd_file.put_line (fnd_file.LOG, 'Legal Employer');
2399: fnd_file.put_line (fnd_file.LOG,
2400: 'LE ID ' || rec_all_le.action_information3
2401: );
2402: fnd_file.put_line (fnd_file.LOG,
2403: 'LE_NAME ' || rec_all_le.action_information4

Line 2402: fnd_file.put_line (fnd_file.LOG,

2398: fnd_file.put_line (fnd_file.LOG, 'Legal Employer');
2399: fnd_file.put_line (fnd_file.LOG,
2400: 'LE ID ' || rec_all_le.action_information3
2401: );
2402: fnd_file.put_line (fnd_file.LOG,
2403: 'LE_NAME ' || rec_all_le.action_information4
2404: );
2405: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2406: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');

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

2401: );
2402: fnd_file.put_line (fnd_file.LOG,
2403: 'LE_NAME ' || rec_all_le.action_information4
2404: );
2405: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2406: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2407: fnd_file.put_line (fnd_file.LOG, ' Inside Person Query');
2408:
2409: FOR rec_all_emp_under_le IN

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

2402: fnd_file.put_line (fnd_file.LOG,
2403: 'LE_NAME ' || rec_all_le.action_information4
2404: );
2405: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2406: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2407: fnd_file.put_line (fnd_file.LOG, ' Inside Person Query');
2408:
2409: FOR rec_all_emp_under_le IN
2410: csr_all_employees_under_le (l_payroll_action_id,

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

2403: 'LE_NAME ' || rec_all_le.action_information4
2404: );
2405: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2406: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2407: fnd_file.put_line (fnd_file.LOG, ' Inside Person Query');
2408:
2409: FOR rec_all_emp_under_le IN
2410: csr_all_employees_under_le (l_payroll_action_id,
2411: rec_all_le.action_information3

Line 2414: fnd_file.put_line (fnd_file.LOG,

2410: csr_all_employees_under_le (l_payroll_action_id,
2411: rec_all_le.action_information3
2412: )
2413: LOOP
2414: fnd_file.put_line (fnd_file.LOG,
2415: 'PERSON ID ==> '
2416: || rec_all_emp_under_le.action_information30
2417: );
2418: add_tag_value ('PERSON', 'PERSON');

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

2468: );
2469: add_tag_value ('PERSON', 'PERSON_END');
2470: END LOOP; -- For all EMPLOYEES
2471:
2472: fnd_file.put_line (fnd_file.LOG, '^^^^^^^^^^^^^^^^^^^^^');
2473: add_tag_value ('EMPLOYEES', 'EMPLOYEES_END');
2474: add_tag_value ('LEGAL_EMPLOYER', 'LEGAL_EMPLOYER_END');
2475: END LOOP; -- For all LEGAL_EMPLYER
2476: */

Line 2491: fnd_file.put_line (fnd_file.LOG

2487: /* Proc to Add the tag value and Name */
2488: PROCEDURE logger (p_display IN VARCHAR2, p_value IN VARCHAR2)
2489: IS
2490: BEGIN
2491: fnd_file.put_line (fnd_file.LOG
2492: , p_display || ' ==> ' || p_value
2493: );
2494: END logger;
2495: