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

Line 216: Fnd_file.put_line(FND_FILE.LOG,'######## IN Qualifying Proc');

212: --
213: BEGIN
214: --hr_utility.trace('###### IN Qualifying Proc');
215: --
216: Fnd_file.put_line(FND_FILE.LOG,'######## IN Qualifying Proc');
217: l_actid := pay_proc_environment_pkg.get_pactid;
218: --
219: get_all_parameters(l_actid
220: ,l_payroll_id

Line 429: Fnd_file.put_line(FND_FILE.LOG,'######## IN Header');

425:
426:
427: BEGIN
428: --
429: Fnd_file.put_line(FND_FILE.LOG,'######## IN Header');
430: -- pay_core_files.write_to_magtape_lob('');
431: -- pay_core_files.write_to_magtape_lob('');
432: --
433: l_final_xml_string := NULL ;

Line 438: Fnd_file.put_line(FND_FILE.LOG,'l_actid'|| l_actid);

434: l_string := NULL ;
435:
436: l_actid := pay_proc_environment_pkg.get_pactid;
437:
438: Fnd_file.put_line(FND_FILE.LOG,'l_actid'|| l_actid);
439:
440: get_all_parameters(l_actid
441: ,l_payroll_id
442: ,l_consolidation_set_id

Line 454: Fnd_file.put_line(FND_FILE.LOG,'l_start_date'||l_start_date);

450: ,l_business_group_id
451: ,l_legislation_code);
452:
453:
454: Fnd_file.put_line(FND_FILE.LOG,'l_start_date'||l_start_date);
455: Fnd_file.put_line(FND_FILE.LOG,'l_end_date'||l_end_date);
456:
457:
458: OPEN csr_assg_id(l_payroll_id,l_start_date,l_end_date);

Line 455: Fnd_file.put_line(FND_FILE.LOG,'l_end_date'||l_end_date);

451: ,l_legislation_code);
452:
453:
454: Fnd_file.put_line(FND_FILE.LOG,'l_start_date'||l_start_date);
455: Fnd_file.put_line(FND_FILE.LOG,'l_end_date'||l_end_date);
456:
457:
458: OPEN csr_assg_id(l_payroll_id,l_start_date,l_end_date);
459: FETCH csr_assg_id into l_assignment_id;

Line 462: Fnd_file.put_line(FND_FILE.LOG,'l_assignment_id'||l_assignment_id);

458: OPEN csr_assg_id(l_payroll_id,l_start_date,l_end_date);
459: FETCH csr_assg_id into l_assignment_id;
460: CLOSE csr_assg_id;
461:
462: Fnd_file.put_line(FND_FILE.LOG,'l_assignment_id'||l_assignment_id);
463: Fnd_file.put_line(FND_FILE.LOG,'l_effective_date'||l_effective_date);
464:
465:
466:

Line 463: Fnd_file.put_line(FND_FILE.LOG,'l_effective_date'||l_effective_date);

459: FETCH csr_assg_id into l_assignment_id;
460: CLOSE csr_assg_id;
461:
462: Fnd_file.put_line(FND_FILE.LOG,'l_assignment_id'||l_assignment_id);
463: Fnd_file.put_line(FND_FILE.LOG,'l_effective_date'||l_effective_date);
464:
465:
466:
467: OPEN csr_local_unit_id(l_assignment_id, l_effective_date);

Line 471: --Fnd_file.put_line(FND_FILE.LOG,'l_business_group_id'||l_business_group_id);

467: OPEN csr_local_unit_id(l_assignment_id, l_effective_date);
468: FETCH csr_local_unit_id into lr_local_unit_id;
469: CLOSE csr_local_unit_id;
470:
471: --Fnd_file.put_line(FND_FILE.LOG,'l_business_group_id'||l_business_group_id);
472: --Fnd_file.put_line(FND_FILE.LOG,'lr_local_unit_id.local_unit_id'||lr_local_unit_id.local_unit_id);
473:
474: OPEN csr_legal_employer_id (l_business_group_id ,lr_local_unit_id.local_unit_id);
475: FETCH csr_legal_employer_id into lr_legal_employer_id;

Line 472: --Fnd_file.put_line(FND_FILE.LOG,'lr_local_unit_id.local_unit_id'||lr_local_unit_id.local_unit_id);

468: FETCH csr_local_unit_id into lr_local_unit_id;
469: CLOSE csr_local_unit_id;
470:
471: --Fnd_file.put_line(FND_FILE.LOG,'l_business_group_id'||l_business_group_id);
472: --Fnd_file.put_line(FND_FILE.LOG,'lr_local_unit_id.local_unit_id'||lr_local_unit_id.local_unit_id);
473:
474: OPEN csr_legal_employer_id (l_business_group_id ,lr_local_unit_id.local_unit_id);
475: FETCH csr_legal_employer_id into lr_legal_employer_id;
476: CLOSE csr_legal_employer_id;

Line 479: --Fnd_file.put_line(FND_FILE.LOG,'Legal_empID'||lr_legal_employer_id.legal_employer_id);

475: FETCH csr_legal_employer_id into lr_legal_employer_id;
476: CLOSE csr_legal_employer_id;
477:
478:
479: --Fnd_file.put_line(FND_FILE.LOG,'Legal_empID'||lr_legal_employer_id.legal_employer_id);
480:
481: open csr_post_header(lr_legal_employer_id.legal_employer_id) ;
482: fetch csr_post_header into lr_post_header ;
483: close csr_post_header ;

Line 494: --Fnd_file.put_line(FND_FILE.LOG,'l_sender'||l_sender);

490: l_sender := lr_payroll_post_header.PRL_INFORMATION1 ;
491: l_receiver := lr_payroll_post_header.PRL_INFORMATION2 ;
492: l_message := lr_payroll_post_header.PRL_INFORMATION3 ;
493:
494: --Fnd_file.put_line(FND_FILE.LOG,'l_sender'||l_sender);
495: --Fnd_file.put_line(FND_FILE.LOG,'lr_post_header.ORG_INFORMATION1'||lr_post_header.ORG_INFORMATION1);
496:
497: IF l_sender is NULL
498: THEN

Line 495: --Fnd_file.put_line(FND_FILE.LOG,'lr_post_header.ORG_INFORMATION1'||lr_post_header.ORG_INFORMATION1);

491: l_receiver := lr_payroll_post_header.PRL_INFORMATION2 ;
492: l_message := lr_payroll_post_header.PRL_INFORMATION3 ;
493:
494: --Fnd_file.put_line(FND_FILE.LOG,'l_sender'||l_sender);
495: --Fnd_file.put_line(FND_FILE.LOG,'lr_post_header.ORG_INFORMATION1'||lr_post_header.ORG_INFORMATION1);
496:
497: IF l_sender is NULL
498: THEN
499: l_sender := lr_post_header.ORG_INFORMATION1 ;

Line 504: Fnd_file.put_line(FND_FILE.LOG,'l_sender_after'||l_sender);

500: l_receiver := lr_post_header.ORG_INFORMATION2 ;
501: l_message := lr_post_header.ORG_INFORMATION3 ;
502: END IF;
503:
504: Fnd_file.put_line(FND_FILE.LOG,'l_sender_after'||l_sender);
505:
506:
507: l_string := '';
508:

Line 522: Fnd_file.put_line(FND_FILE.LOG,'######## IN Header End');

518: --l_final_xml_string := '' || EOL ;
519: --
520: pay_core_files.write_to_magtape_lob(l_final_xml_string);
521: --
522: Fnd_file.put_line(FND_FILE.LOG,'######## IN Header End');
523: END xml_header;
524: --------------------------------------------------------------------------------
525: -- xml_footer
526: --------------------------------------------------------------------------------

Line 531: Fnd_file.put_line(FND_FILE.LOG,'######## IN Footer');

527: PROCEDURE xml_footer IS
528: l_final_xml_string VARCHAR2(32000) := NULL;
529: BEGIN
530: --
531: Fnd_file.put_line(FND_FILE.LOG,'######## IN Footer');
532: -- pay_core_files.write_to_magtape_lob('');
533: l_final_xml_string := NULL ;
534: --
535: l_final_xml_string := '' ;

Line 539: Fnd_file.put_line(FND_FILE.LOG,'######## IN Footer End');

535: l_final_xml_string := '' ;
536: --
537: pay_core_files.write_to_magtape_lob(l_final_xml_string);
538: --
539: Fnd_file.put_line(FND_FILE.LOG,'######## IN Footer End');
540: --
541: END xml_footer;
542: --
543: --------------------------------------------------------------------------------

Line 620: Fnd_file.put_line(FND_FILE.LOG,'######## IN Out of the Loop');

616: l_end_dt := TO_DATE(l_end_date,'YYYY/MM/DD');
617: --
618: --pay_core_files.write_to_magtape_lob('');
619: --pay_core_files.write_to_magtape_lob('');
620: Fnd_file.put_line(FND_FILE.LOG,'######## IN Out of the Loop');
621: --
622: FOR csr_archive_act_rec in csr_archive_act(l_payroll_id
623: ,l_consolidation_set_id
624: ,l_start_dt

Line 630: Fnd_file.put_line(FND_FILE.LOG,'######## IN Side the Loop');

626: ,g_pa_token
627: ,g_cs_token
628: ,l_legislation_code) LOOP
629: --
630: Fnd_file.put_line(FND_FILE.LOG,'######## IN Side the Loop');
631: Fnd_file.put_line(FND_FILE.LOG,'######## '||csr_archive_act_rec.action_context_id);
632:
633: pay_payroll_xml_extract_pkg.generate(
634: P_ACTION_CONTEXT_ID => csr_archive_act_rec.action_context_id

Line 631: Fnd_file.put_line(FND_FILE.LOG,'######## '||csr_archive_act_rec.action_context_id);

627: ,g_cs_token
628: ,l_legislation_code) LOOP
629: --
630: Fnd_file.put_line(FND_FILE.LOG,'######## IN Side the Loop');
631: Fnd_file.put_line(FND_FILE.LOG,'######## '||csr_archive_act_rec.action_context_id);
632:
633: pay_payroll_xml_extract_pkg.generate(
634: P_ACTION_CONTEXT_ID => csr_archive_act_rec.action_context_id
635: ,P_CUSTOM_XML_PROCEDURE => NULL