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_ARCHIVE_CHEQUEWRITER dependencies on HR_UTILITY

Line 200: hr_utility.trace('Entering generate_xml_dummy');

196: xml_cntr NUMBER;
197: l_segment_name VARCHAR2(240);
198: l_val VARCHAR2(240);
199: BEGIN
200: hr_utility.trace('Entering generate_xml_dummy');
201: hr_utility.trace('cp_check_no := '|| cp_check_no);
202: hr_utility.trace('cp_account_name := '|| cp_account_name);
203: hr_utility.trace('cp_account_no := '|| cp_account_no);
204: hr_utility.trace('cp_account_typ := '|| cp_account_typ);

Line 201: hr_utility.trace('cp_check_no := '|| cp_check_no);

197: l_segment_name VARCHAR2(240);
198: l_val VARCHAR2(240);
199: BEGIN
200: hr_utility.trace('Entering generate_xml_dummy');
201: hr_utility.trace('cp_check_no := '|| cp_check_no);
202: hr_utility.trace('cp_account_name := '|| cp_account_name);
203: hr_utility.trace('cp_account_no := '|| cp_account_no);
204: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
205: hr_utility.trace('cp_transit_no := '|| cp_transit_no);

Line 202: hr_utility.trace('cp_account_name := '|| cp_account_name);

198: l_val VARCHAR2(240);
199: BEGIN
200: hr_utility.trace('Entering generate_xml_dummy');
201: hr_utility.trace('cp_check_no := '|| cp_check_no);
202: hr_utility.trace('cp_account_name := '|| cp_account_name);
203: hr_utility.trace('cp_account_no := '|| cp_account_no);
204: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
205: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
206: hr_utility.trace('cp_bank_name := '|| cp_bank_name);

Line 203: hr_utility.trace('cp_account_no := '|| cp_account_no);

199: BEGIN
200: hr_utility.trace('Entering generate_xml_dummy');
201: hr_utility.trace('cp_check_no := '|| cp_check_no);
202: hr_utility.trace('cp_account_name := '|| cp_account_name);
203: hr_utility.trace('cp_account_no := '|| cp_account_no);
204: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
205: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
206: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
207: hr_utility.trace('cp_branch_name := '|| cp_branch_name);

Line 204: hr_utility.trace('cp_account_typ := '|| cp_account_typ);

200: hr_utility.trace('Entering generate_xml_dummy');
201: hr_utility.trace('cp_check_no := '|| cp_check_no);
202: hr_utility.trace('cp_account_name := '|| cp_account_name);
203: hr_utility.trace('cp_account_no := '|| cp_account_no);
204: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
205: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
206: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
207: hr_utility.trace('cp_branch_name := '|| cp_branch_name);
208: hr_utility.trace('cp_employee_no := '|| cp_employee_no);

Line 205: hr_utility.trace('cp_transit_no := '|| cp_transit_no);

201: hr_utility.trace('cp_check_no := '|| cp_check_no);
202: hr_utility.trace('cp_account_name := '|| cp_account_name);
203: hr_utility.trace('cp_account_no := '|| cp_account_no);
204: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
205: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
206: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
207: hr_utility.trace('cp_branch_name := '|| cp_branch_name);
208: hr_utility.trace('cp_employee_no := '|| cp_employee_no);
209: hr_utility.trace('cp_full_name := '|| cp_full_name);

Line 206: hr_utility.trace('cp_bank_name := '|| cp_bank_name);

202: hr_utility.trace('cp_account_name := '|| cp_account_name);
203: hr_utility.trace('cp_account_no := '|| cp_account_no);
204: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
205: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
206: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
207: hr_utility.trace('cp_branch_name := '|| cp_branch_name);
208: hr_utility.trace('cp_employee_no := '|| cp_employee_no);
209: hr_utility.trace('cp_full_name := '|| cp_full_name);
210: hr_utility.trace('cp_national_identifier := '|| cp_national_identifier);

Line 207: hr_utility.trace('cp_branch_name := '|| cp_branch_name);

203: hr_utility.trace('cp_account_no := '|| cp_account_no);
204: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
205: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
206: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
207: hr_utility.trace('cp_branch_name := '|| cp_branch_name);
208: hr_utility.trace('cp_employee_no := '|| cp_employee_no);
209: hr_utility.trace('cp_full_name := '|| cp_full_name);
210: hr_utility.trace('cp_national_identifier := '|| cp_national_identifier);
211:

Line 208: hr_utility.trace('cp_employee_no := '|| cp_employee_no);

204: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
205: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
206: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
207: hr_utility.trace('cp_branch_name := '|| cp_branch_name);
208: hr_utility.trace('cp_employee_no := '|| cp_employee_no);
209: hr_utility.trace('cp_full_name := '|| cp_full_name);
210: hr_utility.trace('cp_national_identifier := '|| cp_national_identifier);
211:
212: i := 1;

Line 209: hr_utility.trace('cp_full_name := '|| cp_full_name);

205: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
206: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
207: hr_utility.trace('cp_branch_name := '|| cp_branch_name);
208: hr_utility.trace('cp_employee_no := '|| cp_employee_no);
209: hr_utility.trace('cp_full_name := '|| cp_full_name);
210: hr_utility.trace('cp_national_identifier := '|| cp_national_identifier);
211:
212: i := 1;
213: ltr_ctx_tag(i) := 'EMPLOYEE DETAILS';

Line 210: hr_utility.trace('cp_national_identifier := '|| cp_national_identifier);

206: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
207: hr_utility.trace('cp_branch_name := '|| cp_branch_name);
208: hr_utility.trace('cp_employee_no := '|| cp_employee_no);
209: hr_utility.trace('cp_full_name := '|| cp_full_name);
210: hr_utility.trace('cp_national_identifier := '|| cp_national_identifier);
211:
212: i := 1;
213: ltr_ctx_tag(i) := 'EMPLOYEE DETAILS';
214: i := i + 1;

Line 241: hr_utility.trace('ltr_ctx_tag(cntr) := '|| ltr_ctx_tag(cntr));

237: ltr_xml_tab(ltr_xml_tab.count() + 1) := load_ctx_xml_start_tag('CHEQUE');
238:
239: FOR cntr IN 1..i
240: LOOP
241: hr_utility.trace('ltr_ctx_tag(cntr) := '|| ltr_ctx_tag(cntr));
242:
243: ltr_xml_tab(ltr_xml_tab.count() + 1) := load_ctx_xml_start_tag(ltr_ctx_tag(cntr));
244:
245: IF ltr_ctx_tag(cntr) = 'EMPLOYEE DETAILS' THEN

Line 261: hr_utility.trace('l_segment_name := ' || l_segment_name);

257:
258: OPEN get_flex_segment(ltr_ctx_tag(cntr));
259: LOOP
260: FETCH get_flex_segment INTO l_segment_name ;
261: hr_utility.trace('l_segment_name := ' || l_segment_name);
262: EXIT WHEN get_flex_segment%NOTFOUND;
263: l_val := NULL ;
264: IF ltr_ctx_tag(cntr) = 'EMPLOYEE DETAILS' THEN
265: IF UPPER(REPLACE(l_segment_name,' ' ,'_')) = 'EMPLOYEE_NUMBER' THEN

Line 560: hr_utility.trace('Entering pay_archive_chequewriter.generate_xml');

556: ln_amt_dummy NUMBER;
557: dummy_xml BLOB;
558:
559: BEGIN
560: hr_utility.trace('Entering pay_archive_chequewriter.generate_xml');
561:
562: ln_chq_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
563:
564: hr_utility.trace('ln_chq_asg_action_id := '||ln_chq_asg_action_id);

Line 564: hr_utility.trace('ln_chq_asg_action_id := '||ln_chq_asg_action_id);

560: hr_utility.trace('Entering pay_archive_chequewriter.generate_xml');
561:
562: ln_chq_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
563:
564: hr_utility.trace('ln_chq_asg_action_id := '||ln_chq_asg_action_id);
565:
566: OPEN get_action_status(ln_chq_asg_action_id);
567: FETCH get_action_status INTO lv_action_status;
568: CLOSE get_action_status;

Line 570: hr_utility.trace('Action Status before Generating XML := ' || lv_action_status);

566: OPEN get_action_status(ln_chq_asg_action_id);
567: FETCH get_action_status INTO lv_action_status;
568: CLOSE get_action_status;
569:
570: hr_utility.trace('Action Status before Generating XML := ' || lv_action_status);
571:
572:
573: OPEN get_legislation_code(ln_chq_asg_action_id) ;
574: FETCH get_legislation_code INTO lv_legislation_code ;

Line 577: hr_utility.trace('Legislation Code := '||lv_legislation_code) ;

573: OPEN get_legislation_code(ln_chq_asg_action_id) ;
574: FETCH get_legislation_code INTO lv_legislation_code ;
575: CLOSE get_legislation_code ;
576:
577: hr_utility.trace('Legislation Code := '||lv_legislation_code) ;
578:
579: OPEN get_arch_asg_action_id(ln_chq_asg_action_id,
580: lv_legislation_code);
581:

Line 595: hr_utility.trace('ln_arch_assignment_action_id := '||ln_arch_assignment_action_id);

591: END IF ;
592:
593: CLOSE get_arch_asg_action_id ;
594:
595: hr_utility.trace('ln_arch_assignment_action_id := '||ln_arch_assignment_action_id);
596:
597: -- Setting Global Variable values
598: pay_archive_chequewriter.g_chq_asg_action_id := ln_chq_asg_action_id;
599: pay_archive_chequewriter.g_arch_asg_action_id := ln_arch_assignment_action_id;

Line 608: --hr_utility.trace('g_chq_asg_action_id := '||pay_archive_chequewriter.g_chq_asg_action_id);

604: pay_core_files.write_to_magtape_lob('');
605: pay_core_files.write_to_magtape_lob('');
606:
607: -- Printing Global Variable Values
608: --hr_utility.trace('g_chq_asg_action_id := '||pay_archive_chequewriter.g_chq_asg_action_id);
609: --hr_utility.trace('g_arch_asg_action_id := '||pay_archive_chequewriter.g_arch_asg_action_id);
610:
611: pay_payroll_xml_extract_pkg.generate ( ln_arch_assignment_action_id , -- Action Context ID
612: null , -- Custom XML Procedure

Line 609: --hr_utility.trace('g_arch_asg_action_id := '||pay_archive_chequewriter.g_arch_asg_action_id);

605: pay_core_files.write_to_magtape_lob('');
606:
607: -- Printing Global Variable Values
608: --hr_utility.trace('g_chq_asg_action_id := '||pay_archive_chequewriter.g_chq_asg_action_id);
609: --hr_utility.trace('g_arch_asg_action_id := '||pay_archive_chequewriter.g_arch_asg_action_id);
610:
611: pay_payroll_xml_extract_pkg.generate ( ln_arch_assignment_action_id , -- Action Context ID
612: null , -- Custom XML Procedure
613: 'N' , -- Generate Header Flag (Y/N)

Line 625: hr_utility.trace('ln_arch_assignment_action_id IS NULL.');

621: pay_core_files.write_to_magtape_lob('');
622:
623:
624: ELSE
625: hr_utility.trace('ln_arch_assignment_action_id IS NULL.');
626:
627: OPEN get_action_details(ln_chq_asg_action_id);
628: FETCH get_action_details INTO
629: l_cheque_no

Line 635: hr_utility.trace('l_cheque_no := '|| l_cheque_no);

631: ,l_deposit_date
632: ,l_pactid;
633: CLOSE get_action_details;
634:
635: hr_utility.trace('l_cheque_no := '|| l_cheque_no);
636:
637: OPEN get_asssignment_id(ln_chq_asg_action_id);
638: FETCH get_asssignment_id INTO l_assignment_id;
639: CLOSE get_asssignment_id;

Line 646: hr_utility.trace('l_effective_date := '|| TO_CHAR(l_effective_date,'DD-MON-YYYY'));

642: FETCH get_effective_date INTO l_effective_date
643: ,l_pactid ;
644: CLOSE get_effective_date;
645:
646: hr_utility.trace('l_effective_date := '|| TO_CHAR(l_effective_date,'DD-MON-YYYY'));
647:
648: OPEN get_employee_details(l_assignment_id,l_effective_date);
649: FETCH get_employee_details INTO
650: l_first_name

Line 665: hr_utility.trace('Before get_pay_meth');

661: , l_title
662: , l_asg_num;
663: CLOSE get_employee_details;
664:
665: hr_utility.trace('Before get_pay_meth');
666:
667: OPEN get_pay_meth(ln_chq_asg_action_id,l_pactid);
668: FETCH get_pay_meth INTO l_payee_meth_id
669: ,l_per_pay_method

Line 673: hr_utility.trace('Before Bank Details');

669: ,l_per_pay_method
670: ,l_det_org_pay_method;
671: CLOSE get_pay_meth;
672:
673: hr_utility.trace('Before Bank Details');
674:
675: if l_det_org_pay_method is not null then
676: OPEN get_org_bank_details(l_det_org_pay_method,l_effective_date);
677: FETCH get_org_bank_details INTO

Line 697: hr_utility.trace('Before Archive Cheque');

693: ,l_account_typ ;
694: CLOSE get_person_bank_details;
695: end if;
696:
697: hr_utility.trace('Before Archive Cheque');
698:
699: pay_core_files.write_to_magtape_lob('');
700: pay_core_files.write_to_magtape_lob('');
701:

Line 702: hr_utility.trace('Calling generate_xml_dummy');

698:
699: pay_core_files.write_to_magtape_lob('');
700: pay_core_files.write_to_magtape_lob('');
701:
702: hr_utility.trace('Calling generate_xml_dummy');
703:
704: generate_xml_dummy(l_cheque_no
705: ,l_account_name
706: ,l_account_number

Line 715: hr_utility.trace('After Calling generate_xml_dummy');

711: ,l_employee_number
712: ,l_full_name
713: ,l_national_identifier
714: ,ltr_xml_dummy_tab) ;
715: hr_utility.trace('After Calling generate_xml_dummy');
716:
717: dbms_lob.createTemporary(l_xml_dummy, true, dbms_lob.session);
718:
719: FOR cntr IN ltr_xml_dummy_tab.first()..ltr_xml_dummy_tab.last()

Line 721: hr_utility.trace('Accessing..' || ltr_xml_dummy_tab(cntr));

717: dbms_lob.createTemporary(l_xml_dummy, true, dbms_lob.session);
718:
719: FOR cntr IN ltr_xml_dummy_tab.first()..ltr_xml_dummy_tab.last()
720: LOOP
721: hr_utility.trace('Accessing..' || ltr_xml_dummy_tab(cntr));
722:
723: lr_xml_dummy := utl_raw.cast_to_raw(ltr_xml_dummy_tab(cntr));
724: ln_amt_dummy := utl_raw.length(lr_xml_dummy);
725:

Line 733: hr_utility.trace('Successful LOB Creation.');

729: END LOOP;
730:
731: dummy_xml := l_xml_dummy;
732:
733: hr_utility.trace('Successful LOB Creation.');
734: pay_core_files.write_to_magtape_lob(dummy_xml);
735:
736: pay_core_files.write_to_magtape_lob('');
737:

Line 743: hr_utility.trace('Update Successful..');

739: UPDATE pay_assignment_actions
740: SET action_status = 'S'
741: WHERE assignment_action_id = ln_chq_asg_action_id;
742:
743: hr_utility.trace('Update Successful..');
744: EXCEPTION
745:
746: WHEN OTHERS THEN
747: hr_utility.trace('Update Unsuccessful..');

Line 747: hr_utility.trace('Update Unsuccessful..');

743: hr_utility.trace('Update Successful..');
744: EXCEPTION
745:
746: WHEN OTHERS THEN
747: hr_utility.trace('Update Unsuccessful..');
748: END;
749: print_blob(pay_mag_tape.g_blob_value);
750: dbms_lob.freeTemporary(l_xml_dummy);
751:

Line 754: hr_utility.trace('Leaving pay_archive_chequewriter.generate_xml');

750: dbms_lob.freeTemporary(l_xml_dummy);
751:
752: END IF;
753:
754: hr_utility.trace('Leaving pay_archive_chequewriter.generate_xml');
755:
756: EXCEPTION WHEN OTHERS THEN
757: hr_utility.trace('SQLERRM := '||SQLERRM) ;
758: END GENERATE_XML ;

Line 757: hr_utility.trace('SQLERRM := '||SQLERRM) ;

753:
754: hr_utility.trace('Leaving pay_archive_chequewriter.generate_xml');
755:
756: EXCEPTION WHEN OTHERS THEN
757: hr_utility.trace('SQLERRM := '||SQLERRM) ;
758: END GENERATE_XML ;
759:
760: BEGIN
761: g_proc_name := 'pay_archive_chequewriter';

Line 763: g_debug := hr_utility.debug_enabled;

759:
760: BEGIN
761: g_proc_name := 'pay_archive_chequewriter';
762: g_document_type := 'ARCHIVE_CHEQUE_WRITER';
763: g_debug := hr_utility.debug_enabled;
764:
765: END pay_archive_chequewriter;