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

Line 209: fnd_file.put_line(fnd_file.log,'+====write_to_clob==========================================+');

205: l_string VARCHAR2(32767) := NULL;
206: l_string1 VARCHAR2(80) := NULL;
207: BEGIN
208:
209: fnd_file.put_line(fnd_file.log,'+====write_to_clob==========================================+');
210:
211: l_str := ''||EOL;
212: dbms_lob.createtemporary(p_clob, FALSE, DBMS_LOB.CALL);
213: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);

Line 243: fnd_file.put_line(fnd_file.log,'X====WRITE_to_clob==========================================X');

239: l_string1 := ''||EOL ;
240: dbms_lob.writeAppend(p_clob, length(l_string1), l_string1);
241: END IF;
242:
243: fnd_file.put_line(fnd_file.log,'X====WRITE_to_clob==========================================X');
244:
245: EXCEPTION
246: WHEN others THEN
247: fnd_file.put_line(fnd_file.log,'Exception in write_to_clob SQL-ERRM : '||SQLERRM);

Line 247: fnd_file.put_line(fnd_file.log,'Exception in write_to_clob SQL-ERRM : '||SQLERRM);

243: fnd_file.put_line(fnd_file.log,'X====WRITE_to_clob==========================================X');
244:
245: EXCEPTION
246: WHEN others THEN
247: fnd_file.put_line(fnd_file.log,'Exception in write_to_clob SQL-ERRM : '||SQLERRM);
248: hr_utility.raise_error;
249: END write_to_clob;
250:
251:

Line 409: fnd_file.put_line(fnd_file.log,'+====gen_body_xml_main=====================================+');

405: l_payroll_action_id NUMBER;
406: l_pension_type_info_sdate pay_action_information.action_information4%TYPE; --Bug 16301893
407:
408: BEGIN
409: fnd_file.put_line(fnd_file.log,'+====gen_body_xml_main=====================================+');
410: fnd_file.put_line(fnd_file.log,'Assignment Action Id :'||p_asg_action_id);
411:
412: OPEN csr_get_pact_id(p_asg_action_id);
413: FETCH csr_get_pact_id INTO l_payroll_action_id;

Line 410: fnd_file.put_line(fnd_file.log,'Assignment Action Id :'||p_asg_action_id);

406: l_pension_type_info_sdate pay_action_information.action_information4%TYPE; --Bug 16301893
407:
408: BEGIN
409: fnd_file.put_line(fnd_file.log,'+====gen_body_xml_main=====================================+');
410: fnd_file.put_line(fnd_file.log,'Assignment Action Id :'||p_asg_action_id);
411:
412: OPEN csr_get_pact_id(p_asg_action_id);
413: FETCH csr_get_pact_id INTO l_payroll_action_id;
414: CLOSE csr_get_pact_id;

Line 436: fnd_file.put_line(fnd_file.log,'Start Date/End Date/KOP/Income Code/PTP/Code_Inc : ' ||report_data(l_pay_count).start_date

432: report_data(l_pay_count).kop := v_csr_pay_period_details.kop;
433: report_data(l_pay_count).income_code := v_csr_pay_period_details.income_code;
434: report_data(l_pay_count).ptp := v_csr_pay_period_details.ptp;
435: report_data(l_pay_count).code_inc := v_csr_pay_period_details.code_inc;
436: fnd_file.put_line(fnd_file.log,'Start Date/End Date/KOP/Income Code/PTP/Code_Inc : ' ||report_data(l_pay_count).start_date
437: ||' '||report_data(l_pay_count).end_date
438: ||' '||report_data(l_pay_count).kop
439: ||' '||report_data(l_pay_count).income_code
440: ||' '||report_data(l_pay_count).ptp

Line 444: fnd_file.put_line(fnd_file.log,'Fetched all data. XML Generation starts');

440: ||' '||report_data(l_pay_count).ptp
441: ||' '||report_data(l_pay_count).code_inc);
442: END LOOP;
443:
444: fnd_file.put_line(fnd_file.log,'Fetched all data. XML Generation starts');
445: fnd_file.put_line(fnd_file.log,'Assignment_Id : '||l_asg_details.assignment_id);
446:
447: fnd_file.put_line(fnd_file.log,'Asg Details');
448:

Line 445: fnd_file.put_line(fnd_file.log,'Assignment_Id : '||l_asg_details.assignment_id);

441: ||' '||report_data(l_pay_count).code_inc);
442: END LOOP;
443:
444: fnd_file.put_line(fnd_file.log,'Fetched all data. XML Generation starts');
445: fnd_file.put_line(fnd_file.log,'Assignment_Id : '||l_asg_details.assignment_id);
446:
447: fnd_file.put_line(fnd_file.log,'Asg Details');
448:
449: Tag(x,'inkomstenverhouding','_START_'); -- + assignment details*

Line 447: fnd_file.put_line(fnd_file.log,'Asg Details');

443:
444: fnd_file.put_line(fnd_file.log,'Fetched all data. XML Generation starts');
445: fnd_file.put_line(fnd_file.log,'Assignment_Id : '||l_asg_details.assignment_id);
446:
447: fnd_file.put_line(fnd_file.log,'Asg Details');
448:
449: Tag(x,'inkomstenverhouding','_START_'); -- + assignment details*
450: Tag(x,'personeelsnummer',l_asg_details.emp_num); -- employee no.*
451: Tag(x,'nummer',l_asg_details.asg_num); -- asg no.*

Line 465: fnd_file.put_line(fnd_file.log,'Pay period Details');

461: to_date(l_asg_details.asg_end_date,'YYYY-MM-DD')));
462: Tag(x,'redenEinde',get_lookup_value('PQP_NL_OVERRIDE_REASON',l_asg_details.term_reason_pdf,l_lang));
463: END IF;
464:
465: fnd_file.put_line(fnd_file.log,'Pay period Details');
466:
467: IF l_pay_count > 0 THEN
468: FOR i IN report_data.FIRST..report_data.LAST LOOP
469: Tag(x,'inkomstenperiode','_START_'); -- + pay period details*

Line 495: fnd_file.put_line(fnd_file.log,'Pension Type Details');

491: Tag(x,'datum', to_char(to_date(report_data(i).start_date,'RRRR-MM-DD'),'MM YYYY'));
492: Tag(x,'deeltijdfactor',to_char(report_data(i).ptp*100,'FM990.00'));
493: END IF;
494:
495: fnd_file.put_line(fnd_file.log,'Pension Type Details');
496: IF report_data(i).ptp <> 0 THEN
497: FOR v_csr_pension_details IN csr_pension_details(p_asg_action_id,report_data(i).start_date) LOOP
498:
499: --Begin Bug 16301893

Line 549: fnd_file.put_line(fnd_file.log,'Employer Total Details');

545: Tag(x,'pensioenVerzekeringPeriode','_END_'); -- - pension type pay period details*
546: Tag(x,'pensioenVerzekeringverhouding','_END_'); -- - pension type details
547:
548:
549: fnd_file.put_line(fnd_file.log,'Employer Total Details');
550: fnd_file.put_line(fnd_file.log,'Pension Base'||v_csr_pension_details.abp_pension_base);
551: fnd_file.put_line(fnd_file.log,'Contr Base '||v_csr_pension_details.contr_base);
552: fnd_file.put_line(fnd_file.log,'Contr Amt '||v_csr_pension_details.contr_amt);
553:

Line 550: fnd_file.put_line(fnd_file.log,'Pension Base'||v_csr_pension_details.abp_pension_base);

546: Tag(x,'pensioenVerzekeringverhouding','_END_'); -- - pension type details
547:
548:
549: fnd_file.put_line(fnd_file.log,'Employer Total Details');
550: fnd_file.put_line(fnd_file.log,'Pension Base'||v_csr_pension_details.abp_pension_base);
551: fnd_file.put_line(fnd_file.log,'Contr Base '||v_csr_pension_details.contr_base);
552: fnd_file.put_line(fnd_file.log,'Contr Amt '||v_csr_pension_details.contr_amt);
553:
554:

Line 551: fnd_file.put_line(fnd_file.log,'Contr Base '||v_csr_pension_details.contr_base);

547:
548:
549: fnd_file.put_line(fnd_file.log,'Employer Total Details');
550: fnd_file.put_line(fnd_file.log,'Pension Base'||v_csr_pension_details.abp_pension_base);
551: fnd_file.put_line(fnd_file.log,'Contr Base '||v_csr_pension_details.contr_base);
552: fnd_file.put_line(fnd_file.log,'Contr Amt '||v_csr_pension_details.contr_amt);
553:
554:
555: END IF;

Line 552: fnd_file.put_line(fnd_file.log,'Contr Amt '||v_csr_pension_details.contr_amt);

548:
549: fnd_file.put_line(fnd_file.log,'Employer Total Details');
550: fnd_file.put_line(fnd_file.log,'Pension Base'||v_csr_pension_details.abp_pension_base);
551: fnd_file.put_line(fnd_file.log,'Contr Base '||v_csr_pension_details.contr_base);
552: fnd_file.put_line(fnd_file.log,'Contr Amt '||v_csr_pension_details.contr_amt);
553:
554:
555: END IF;
556: END IF; --for multiple pay period

Line 565: fnd_file.put_line(fnd_file.log,'Pension Type '||tPension(k));

561:
562: FOR v_csr_get_assignment_total IN csr_get_assignment_total(p_asg_action_id) LOOP
563: FOR k IN 1..7 LOOP
564: IF tpension(k) = v_csr_get_assignment_total.pension_type AND v_csr_get_assignment_total.pension_type_variant IS NULL THEN
565: fnd_file.put_line(fnd_file.log,'Pension Type '||tPension(k));
566: g_er_amount(k).pension_base := nvl(g_er_amount(k).pension_base,0) + nvl(v_csr_get_assignment_total.abp_pension_base,0);
567: g_er_amount(k).contr_base := nvl(g_er_amount(k).contr_base,0) + nvl(v_csr_get_assignment_total.contr_base,0);
568: g_er_amount(k).contr_amt := nvl(g_er_amount(k).contr_amt,0) + nvl(v_csr_get_assignment_total.contr_amt,0);
569: g_er_amount(k).flag := 1; --flag to indicate which pension types are to be reported

Line 572: fnd_file.put_line(fnd_file.log,'Pension Type '||tPension(k));

568: g_er_amount(k).contr_amt := nvl(g_er_amount(k).contr_amt,0) + nvl(v_csr_get_assignment_total.contr_amt,0);
569: g_er_amount(k).flag := 1; --flag to indicate which pension types are to be reported
570: ELSE
571: IF substr(tpension(k),8,1) = v_csr_get_assignment_total.pension_type_variant THEN
572: fnd_file.put_line(fnd_file.log,'Pension Type '||tPension(k));
573: fnd_file.put_line(fnd_file.log,'Pension Type Variant '||substr(tPension(k),8,1));
574: g_er_amount(k).pension_base := nvl(g_er_amount(k).pension_base,0) + nvl(v_csr_get_assignment_total.abp_pension_base,0);
575: g_er_amount(k).contr_base := nvl(g_er_amount(k).contr_base,0) + nvl(v_csr_get_assignment_total.contr_base,0);
576: g_er_amount(k).contr_amt := nvl(g_er_amount(k).contr_amt,0) + nvl(v_csr_get_assignment_total.contr_amt,0);

Line 573: fnd_file.put_line(fnd_file.log,'Pension Type Variant '||substr(tPension(k),8,1));

569: g_er_amount(k).flag := 1; --flag to indicate which pension types are to be reported
570: ELSE
571: IF substr(tpension(k),8,1) = v_csr_get_assignment_total.pension_type_variant THEN
572: fnd_file.put_line(fnd_file.log,'Pension Type '||tPension(k));
573: fnd_file.put_line(fnd_file.log,'Pension Type Variant '||substr(tPension(k),8,1));
574: g_er_amount(k).pension_base := nvl(g_er_amount(k).pension_base,0) + nvl(v_csr_get_assignment_total.abp_pension_base,0);
575: g_er_amount(k).contr_base := nvl(g_er_amount(k).contr_base,0) + nvl(v_csr_get_assignment_total.contr_base,0);
576: g_er_amount(k).contr_amt := nvl(g_er_amount(k).contr_amt,0) + nvl(v_csr_get_assignment_total.contr_amt,0);
577: g_er_amount(k).flag := 1; --flag to indicate which pension types are to be reported

Line 587: fnd_file.put_line(fnd_file.log,'Person Details');

583: END IF; --l_pay_count
584:
585:
586: IF l_emp_details.person_data_flag = 'Y' AND p_abp_output_type <> 'NLABP_CSV' THEN
587: fnd_file.put_line(fnd_file.log,'Person Details');
588: Tag(x,'natuurlijkPersoon','_START_'); -- + person details*
589: Tag(x,'personeelsnummer',l_emp_details.employee_number); -- employee no.*
590: Tag(x,'bsn',l_emp_details.sofi_number); -- BSN/Sofi no.
591: Tag(x,'significantDeelAchternaam',l_emp_details.last_name); -- emp last name*

Line 620: fnd_file.put_line(fnd_file.log,'Address Details');

616: Tag(x,'individueleOntheffing',get_lookup_value('HR_NL_YES_NO',
617: REPLACE(nvl(l_emp_details.indv_exe,'N'),'G','Y'),l_lang));
618: END IF;
619:
620: fnd_file.put_line(fnd_file.log,'Address Details');
621:
622: IF l_emp_details.style = 'NL' THEN
623: Tag(x,'adresBinnenland','_START_'); -- + dutch address details
624: Tag(x,'straatnaam',l_emp_details.street); -- street name*

Line 647: fnd_file.put_line(fnd_file.log,'X====gen_body_xml_main=====================================X');

643: END IF;
644:
645: Tag(x,'inkomstenverhouding','_END_'); -- - assignment details*
646:
647: fnd_file.put_line(fnd_file.log,'X====gen_body_xml_main=====================================X');
648: EXCEPTION
649: WHEN others THEN
650: fnd_file.put_line(fnd_file.log,'Exception in gen_body_xml_main SQL-ERRM :'||SQLERRM);
651: END gen_body_xml_main;

Line 650: fnd_file.put_line(fnd_file.log,'Exception in gen_body_xml_main SQL-ERRM :'||SQLERRM);

646:
647: fnd_file.put_line(fnd_file.log,'X====gen_body_xml_main=====================================X');
648: EXCEPTION
649: WHEN others THEN
650: fnd_file.put_line(fnd_file.log,'Exception in gen_body_xml_main SQL-ERRM :'||SQLERRM);
651: END gen_body_xml_main;
652:
653:
654: -- =============================================================================

Line 784: fnd_file.put_line(fnd_file.log,'+====gen_body_xml==========================================+');

780: --=============================================================================
781: l_asg_withdrawal csr_asg_withdrawal%ROWTYPE;
782:
783: BEGIN
784: fnd_file.put_line(fnd_file.log,'+====gen_body_xml==========================================+');
785:
786: fnd_file.put_line(fnd_file.log,'Payroll Action Id = '||p_action_context_id);
787:
788: IF INSTR ('a', COMPOSE('a'|| UNISTR('\0301')) ) = 0 THEN

Line 786: fnd_file.put_line(fnd_file.log,'Payroll Action Id = '||p_action_context_id);

782:
783: BEGIN
784: fnd_file.put_line(fnd_file.log,'+====gen_body_xml==========================================+');
785:
786: fnd_file.put_line(fnd_file.log,'Payroll Action Id = '||p_action_context_id);
787:
788: IF INSTR ('a', COMPOSE('a'|| UNISTR('\0301')) ) = 0 THEN
789: OPEN c_bg_stdate(p_action_context_id);
790: FETCH c_bg_stdate INTO l_bg_id,l_start_date;

Line 803: fnd_file.put_line(fnd_file.log,'g_SOURCE : '||g_SOURCE);

799: g_SOURCE := g_SOURCE||upper(I.Source)||lower(I.Source);
800: g_TARGET := g_TARGET||upper(I.Target)||lower(I.Target);
801: END LOOP;
802:
803: fnd_file.put_line(fnd_file.log,'g_SOURCE : '||g_SOURCE);
804: fnd_file.put_line(fnd_file.log,'g_TARGET : '||g_TARGET);
805: END IF;
806:
807: --init

Line 804: fnd_file.put_line(fnd_file.log,'g_TARGET : '||g_TARGET);

800: g_TARGET := g_TARGET||upper(I.Target)||lower(I.Target);
801: END LOOP;
802:
803: fnd_file.put_line(fnd_file.log,'g_SOURCE : '||g_SOURCE);
804: fnd_file.put_line(fnd_file.log,'g_TARGET : '||g_TARGET);
805: END IF;
806:
807: --init
808: FOR i in 1..7 LOOP

Line 839: fnd_file.put_line(fnd_file.log,'Employer Id '||l_employer_det.org_id);

835: END IF;
836: Tag(x,'referentieAansluiting',l_employer_det.ref_er); -- ref employer
837: -- Generate xml for Employer details end
838:
839: fnd_file.put_line(fnd_file.log,'Employer Id '||l_employer_det.org_id);
840:
841: FOR v_asg_action_id IN csr_get_asg_action_id(p_action_context_id,l_employer_det.org_id) LOOP
842: FOR v_child_act_id IN csr_get_child_act_id(v_asg_action_id.assignment_action_id)
843: LOOP

Line 844: fnd_file.put_line(fnd_file.log,'Asg Act Id: '||v_child_act_id.ass_act_id);

840:
841: FOR v_asg_action_id IN csr_get_asg_action_id(p_action_context_id,l_employer_det.org_id) LOOP
842: FOR v_child_act_id IN csr_get_child_act_id(v_asg_action_id.assignment_action_id)
843: LOOP
844: fnd_file.put_line(fnd_file.log,'Asg Act Id: '||v_child_act_id.ass_act_id);
845: --Find if assignment context is archived. If yes, generate xml for all the contexts
846: OPEN csr_chk_asg_ctxt(v_child_act_id.ass_act_id);
847: FETCH csr_chk_asg_ctxt INTO l_ctxt;
848: IF csr_chk_asg_ctxt%FOUND THEN

Line 849: fnd_file.put_line(fnd_file.log,'Asg Context Found: ');

845: --Find if assignment context is archived. If yes, generate xml for all the contexts
846: OPEN csr_chk_asg_ctxt(v_child_act_id.ass_act_id);
847: FETCH csr_chk_asg_ctxt INTO l_ctxt;
848: IF csr_chk_asg_ctxt%FOUND THEN
849: fnd_file.put_line(fnd_file.log,'Asg Context Found: ');
850: CLOSE csr_chk_asg_ctxt;
851: gen_body_xml_main(v_child_act_id.ass_act_id,p_abp_output_type,x);
852: ELSE
853: CLOSE csr_chk_asg_ctxt;

Line 858: fnd_file.put_line(fnd_file.log,'Withdrawal Details');

854: END IF;
855: END LOOP;
856: END LOOP;
857:
858: fnd_file.put_line(fnd_file.log,'Withdrawal Details');
859: fnd_file.put_line(fnd_file.log,'p_action_context_id: '||p_action_context_id);
860: OPEN csr_asg_withdrawal(p_action_context_id);
861: FETCH csr_asg_withdrawal INTO l_asg_withdrawal;
862: IF csr_asg_withdrawal%FOUND THEN

Line 859: fnd_file.put_line(fnd_file.log,'p_action_context_id: '||p_action_context_id);

855: END LOOP;
856: END LOOP;
857:
858: fnd_file.put_line(fnd_file.log,'Withdrawal Details');
859: fnd_file.put_line(fnd_file.log,'p_action_context_id: '||p_action_context_id);
860: OPEN csr_asg_withdrawal(p_action_context_id);
861: FETCH csr_asg_withdrawal INTO l_asg_withdrawal;
862: IF csr_asg_withdrawal%FOUND THEN
863: CLOSE csr_asg_withdrawal;

Line 926: fnd_file.put_line(fnd_file.log,'X====gen_body_xml==========================================X');

922: END LOOP;
923:
924: Tag(x,'administratieveEenheid','_END_'); -- - employer details*
925:
926: fnd_file.put_line(fnd_file.log,'X====gen_body_xml==========================================X');
927: EXCEPTION
928: WHEN OTHERS THEN
929: fnd_file.put_line(fnd_file.log,'Exception in gen_body_xml SQL-ERRM :'||SQLERRM);
930:

Line 929: fnd_file.put_line(fnd_file.log,'Exception in gen_body_xml SQL-ERRM :'||SQLERRM);

925:
926: fnd_file.put_line(fnd_file.log,'X====gen_body_xml==========================================X');
927: EXCEPTION
928: WHEN OTHERS THEN
929: fnd_file.put_line(fnd_file.log,'Exception in gen_body_xml SQL-ERRM :'||SQLERRM);
930:
931: END gen_body_xml;
932:
933: BEGIN

Line 934: fnd_file.put_line(fnd_file.log,'+====Generate====================+'|| p_action_context_id);

930:
931: END gen_body_xml;
932:
933: BEGIN
934: fnd_file.put_line(fnd_file.log,'+====Generate====================+'|| p_action_context_id);
935:
936: --init
937: xXMLTable.delete;
938:

Line 959: fnd_file.put_line(fnd_file.log,'Sender Details ');

955: FETCH csr_get_file_details INTO l_file_details;
956: CLOSE csr_get_file_details;
957:
958:
959: fnd_file.put_line(fnd_file.log,'Sender Details ');
960:
961: IF p_abp_output_type = 'NLABP_PDF' THEN
962: Tag(x,'leveringAPG','_START_');
963: END IF;

Line 986: fnd_file.put_line(fnd_file.log,'Totals per file Details ');

982: -- General xml for Employer and Employee details begin
983: gen_body_xml(x);
984: -- General xml for Employer and Employee details end
985:
986: fnd_file.put_line(fnd_file.log,'Totals per file Details ');
987: -- Generate xml for Totals per file begin
988: FOR l_total in 1..7 LOOP
989: IF g_er_amount(l_total).flag = 1 THEN
990: Tag(x,'collectievePensioenVerzekeringsgegevensLevering','_START_'); -- + totals per file details*

Line 1029: fnd_file.put_line(fnd_file.log,'X====Generate====================X '|| p_action_context_id);

1025:
1026: p_xml := l_xml;
1027: dbms_lob.freeTemporary(l_xml);
1028:
1029: fnd_file.put_line(fnd_file.log,'X====Generate====================X '|| p_action_context_id);
1030:
1031: /* 14832638 - Set CP Output type to XML for XML report */
1032: IF p_abp_output_type='NLABP_XML' THEN
1033: UPDATE fnd_concurrent_requests