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 203: hr_utility.trace('p_document_type: '||p_document_type);

199: get_xml_statem VARCHAR2(256);
200: sql_cur NUMBER;
201: l_rows NUMBER;
202: BEGIN
203: hr_utility.trace('p_document_type: '||p_document_type);
204: hr_utility.trace('p_legislation_code: '||p_legislation_code);
205: get_xml_statem := 'BEGIN PAY_'||p_legislation_code||'_RULES.get_custom_xml_routine(:lv_document_type, :lv_xml_routine); END;';
206: sql_cur := dbms_sql.open_cursor;
207: dbms_sql.parse(sql_cur

Line 204: hr_utility.trace('p_legislation_code: '||p_legislation_code);

200: sql_cur NUMBER;
201: l_rows NUMBER;
202: BEGIN
203: hr_utility.trace('p_document_type: '||p_document_type);
204: hr_utility.trace('p_legislation_code: '||p_legislation_code);
205: get_xml_statem := 'BEGIN PAY_'||p_legislation_code||'_RULES.get_custom_xml_routine(:lv_document_type, :lv_xml_routine); END;';
206: sql_cur := dbms_sql.open_cursor;
207: dbms_sql.parse(sql_cur
208: ,get_xml_statem

Line 215: hr_utility.trace('lv_custom_xml_code: '||lv_custom_xml_code);

211: dbms_sql.bind_variable(sql_cur, 'lv_xml_routine', lv_custom_xml_code, 50);
212: l_rows := dbms_sql.execute(sql_cur);
213: dbms_sql.variable_value(sql_cur, 'lv_xml_routine', lv_custom_xml_code);
214: dbms_sql.close_cursor(sql_cur);
215: hr_utility.trace('lv_custom_xml_code: '||lv_custom_xml_code);
216: RETURN lv_custom_xml_code;
217: Exception
218: WHEN OTHERS THEN
219: lv_custom_xml_code := null;

Line 220: hr_utility.trace('lv_custom_xml_code in the exceptions clause: '||lv_custom_xml_code);

216: RETURN lv_custom_xml_code;
217: Exception
218: WHEN OTHERS THEN
219: lv_custom_xml_code := null;
220: hr_utility.trace('lv_custom_xml_code in the exceptions clause: '||lv_custom_xml_code);
221: --
222: IF dbms_sql.IS_OPEN(sql_cur) THEN
223: dbms_sql.close_cursor(sql_cur);
224: END IF;

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

263: xml_cntr NUMBER;
264: l_segment_name VARCHAR2(240);
265: l_val VARCHAR2(240);
266: BEGIN
267: hr_utility.trace('Entering generate_xml_dummy');
268: hr_utility.trace('cp_check_no := '|| cp_check_no);
269: hr_utility.trace('cp_account_name := '|| cp_account_name);
270: hr_utility.trace('cp_account_no := '|| cp_account_no);
271: hr_utility.trace('cp_account_typ := '|| cp_account_typ);

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

264: l_segment_name VARCHAR2(240);
265: l_val VARCHAR2(240);
266: BEGIN
267: hr_utility.trace('Entering generate_xml_dummy');
268: hr_utility.trace('cp_check_no := '|| cp_check_no);
269: hr_utility.trace('cp_account_name := '|| cp_account_name);
270: hr_utility.trace('cp_account_no := '|| cp_account_no);
271: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
272: hr_utility.trace('cp_transit_no := '|| cp_transit_no);

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

265: l_val VARCHAR2(240);
266: BEGIN
267: hr_utility.trace('Entering generate_xml_dummy');
268: hr_utility.trace('cp_check_no := '|| cp_check_no);
269: hr_utility.trace('cp_account_name := '|| cp_account_name);
270: hr_utility.trace('cp_account_no := '|| cp_account_no);
271: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
272: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
273: hr_utility.trace('cp_bank_name := '|| cp_bank_name);

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

266: BEGIN
267: hr_utility.trace('Entering generate_xml_dummy');
268: hr_utility.trace('cp_check_no := '|| cp_check_no);
269: hr_utility.trace('cp_account_name := '|| cp_account_name);
270: hr_utility.trace('cp_account_no := '|| cp_account_no);
271: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
272: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
273: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
274: hr_utility.trace('cp_branch_name := '|| cp_branch_name);

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

267: hr_utility.trace('Entering generate_xml_dummy');
268: hr_utility.trace('cp_check_no := '|| cp_check_no);
269: hr_utility.trace('cp_account_name := '|| cp_account_name);
270: hr_utility.trace('cp_account_no := '|| cp_account_no);
271: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
272: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
273: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
274: hr_utility.trace('cp_branch_name := '|| cp_branch_name);
275: hr_utility.trace('cp_employee_no := '|| cp_employee_no);

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

268: hr_utility.trace('cp_check_no := '|| cp_check_no);
269: hr_utility.trace('cp_account_name := '|| cp_account_name);
270: hr_utility.trace('cp_account_no := '|| cp_account_no);
271: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
272: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
273: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
274: hr_utility.trace('cp_branch_name := '|| cp_branch_name);
275: hr_utility.trace('cp_employee_no := '|| cp_employee_no);
276: hr_utility.trace('cp_full_name := '|| cp_full_name);

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

269: hr_utility.trace('cp_account_name := '|| cp_account_name);
270: hr_utility.trace('cp_account_no := '|| cp_account_no);
271: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
272: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
273: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
274: hr_utility.trace('cp_branch_name := '|| cp_branch_name);
275: hr_utility.trace('cp_employee_no := '|| cp_employee_no);
276: hr_utility.trace('cp_full_name := '|| cp_full_name);
277: hr_utility.trace('cp_national_identifier := '|| cp_national_identifier);

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

270: hr_utility.trace('cp_account_no := '|| cp_account_no);
271: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
272: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
273: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
274: hr_utility.trace('cp_branch_name := '|| cp_branch_name);
275: hr_utility.trace('cp_employee_no := '|| cp_employee_no);
276: hr_utility.trace('cp_full_name := '|| cp_full_name);
277: hr_utility.trace('cp_national_identifier := '|| cp_national_identifier);
278:

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

271: hr_utility.trace('cp_account_typ := '|| cp_account_typ);
272: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
273: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
274: hr_utility.trace('cp_branch_name := '|| cp_branch_name);
275: hr_utility.trace('cp_employee_no := '|| cp_employee_no);
276: hr_utility.trace('cp_full_name := '|| cp_full_name);
277: hr_utility.trace('cp_national_identifier := '|| cp_national_identifier);
278:
279: /* Changes for bug 13773808 starts here*/

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

272: hr_utility.trace('cp_transit_no := '|| cp_transit_no);
273: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
274: hr_utility.trace('cp_branch_name := '|| cp_branch_name);
275: hr_utility.trace('cp_employee_no := '|| cp_employee_no);
276: hr_utility.trace('cp_full_name := '|| cp_full_name);
277: hr_utility.trace('cp_national_identifier := '|| cp_national_identifier);
278:
279: /* Changes for bug 13773808 starts here*/
280: i := 1;

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

273: hr_utility.trace('cp_bank_name := '|| cp_bank_name);
274: hr_utility.trace('cp_branch_name := '|| cp_branch_name);
275: hr_utility.trace('cp_employee_no := '|| cp_employee_no);
276: hr_utility.trace('cp_full_name := '|| cp_full_name);
277: hr_utility.trace('cp_national_identifier := '|| cp_national_identifier);
278:
279: /* Changes for bug 13773808 starts here*/
280: i := 1;
281: ltr_ctx_tag(i) := 'EMPLOYEE DETAILS';

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

311: ltr_xml_tab(ltr_xml_tab.count() + 1) := load_ctx_xml_start_tag('CHEQUE');
312:
313: FOR cntr IN 1..i
314: LOOP
315: hr_utility.trace('ltr_ctx_tag(cntr) := '|| ltr_ctx_tag(cntr));
316:
317: ltr_xml_tab(ltr_xml_tab.count() + 1) := load_ctx_xml_start_tag(ltr_ctx_tag(cntr));
318:
319: IF ltr_ctx_tag(cntr) = 'EMPLOYEE DETAILS' THEN

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

331:
332: OPEN get_flex_segment(ltr_ctx_tag(cntr));
333: LOOP
334: FETCH get_flex_segment INTO l_segment_name ;
335: hr_utility.trace('l_segment_name := ' || l_segment_name);
336: EXIT WHEN get_flex_segment%NOTFOUND;
337: l_val := NULL ;
338: IF ltr_ctx_tag(cntr) = 'EMPLOYEE DETAILS' THEN
339: IF UPPER(REPLACE(l_segment_name,' ' ,'_')) = 'EMPLOYEE_NUMBER' THEN

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

751: l_pre_payment_id number;
752: lv_arch_cheque_custom_xml VARCHAR2(180);
753: lv_thpty_che_custom_xml VARCHAR2(180);
754: BEGIN
755: hr_utility.trace('Entering pay_archive_chequewriter.generate_xml');
756:
757: ln_chq_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
758:
759: hr_utility.trace('ln_chq_asg_action_id := '||ln_chq_asg_action_id);

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

755: hr_utility.trace('Entering pay_archive_chequewriter.generate_xml');
756:
757: ln_chq_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
758:
759: hr_utility.trace('ln_chq_asg_action_id := '||ln_chq_asg_action_id);
760:
761: OPEN get_action_status(ln_chq_asg_action_id);
762: FETCH get_action_status INTO lv_action_status;
763: CLOSE get_action_status;

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

761: OPEN get_action_status(ln_chq_asg_action_id);
762: FETCH get_action_status INTO lv_action_status;
763: CLOSE get_action_status;
764:
765: hr_utility.trace('Action Status before Generating XML := ' || lv_action_status);
766:
767:
768: OPEN get_legislation_code(ln_chq_asg_action_id) ;
769: FETCH get_legislation_code INTO lv_legislation_code ;

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

768: OPEN get_legislation_code(ln_chq_asg_action_id) ;
769: FETCH get_legislation_code INTO lv_legislation_code ;
770: CLOSE get_legislation_code ;
771:
772: hr_utility.trace('Legislation Code := '||lv_legislation_code) ;
773:
774: /* Changes for bug 13773808 starts here*/
775: IF lv_legislation_code = 'CA' then
776: OPEN get_ca_arch_asg_action_id(ln_chq_asg_action_id,

Line 809: hr_utility.trace('Fetching multi asg payroll action id.');

805:
806: -- Added the below for 13814029
807: IF ln_arch_assignment_action_id IS NULL THEN
808: --get_multi_arch_asg_action_id
809: hr_utility.trace('Fetching multi asg payroll action id.');
810: OPEN get_multi_arch_asg_action_id(ln_chq_asg_action_id,
811: lv_legislation_code);
812: FETCH get_multi_arch_asg_action_id
813: INTO ln_arch_assignment_action_id ;

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

816:
817: END IF;
818: /* Changes for bug 13773808 ends here*/
819:
820: hr_utility.trace('ln_arch_assignment_action_id := '||ln_arch_assignment_action_id);
821:
822: -- Setting Global Variable values
823: pay_archive_chequewriter.g_chq_asg_action_id := ln_chq_asg_action_id;
824: pay_archive_chequewriter.g_arch_asg_action_id := ln_arch_assignment_action_id;

Line 848: hr_utility.trace('The Custom XML code for Archive Cheque Writer is: '||lv_arch_cheque_custom_xml);

844: if l_thpty_flag is not null then
845:
846: lv_arch_cheque_custom_xml:= get_custom_xml('ARCHIVE_CHEQUE_WRITER',lv_legislation_code); -- Bug 13969852, 13969858
847:
848: hr_utility.trace('The Custom XML code for Archive Cheque Writer is: '||lv_arch_cheque_custom_xml);
849:
850: pay_core_files.write_to_magtape_lob('');
851: pay_core_files.write_to_magtape_lob('');
852:

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

850: pay_core_files.write_to_magtape_lob('');
851: pay_core_files.write_to_magtape_lob('');
852:
853: -- Printing Global Variable Values
854: --hr_utility.trace('g_chq_asg_action_id := '||pay_archive_chequewriter.g_chq_asg_action_id);
855: --hr_utility.trace('g_arch_asg_action_id := '||pay_archive_chequewriter.g_arch_asg_action_id);
856:
857: pay_payroll_xml_extract_pkg.generate (ln_arch_assignment_action_id , -- Action Context ID
858: lv_arch_cheque_custom_xml , -- Custom XML Procedure, Bug 13969852, 13969858

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

851: pay_core_files.write_to_magtape_lob('');
852:
853: -- Printing Global Variable Values
854: --hr_utility.trace('g_chq_asg_action_id := '||pay_archive_chequewriter.g_chq_asg_action_id);
855: --hr_utility.trace('g_arch_asg_action_id := '||pay_archive_chequewriter.g_arch_asg_action_id);
856:
857: pay_payroll_xml_extract_pkg.generate (ln_arch_assignment_action_id , -- Action Context ID
858: lv_arch_cheque_custom_xml , -- Custom XML Procedure, Bug 13969852, 13969858
859: 'N' , -- Generate Header Flag (Y/N)

Line 872: hr_utility.trace('The Custom XML code for Third Party Cheque Writer is: '||lv_thpty_che_custom_xml);

868: else
869:
870: lv_thpty_che_custom_xml:= get_custom_xml('THIRD_PARTY_CHEQUE_WRITER',lv_legislation_code); -- Bug 13969852, 13969858
871:
872: hr_utility.trace('The Custom XML code for Third Party Cheque Writer is: '||lv_thpty_che_custom_xml);
873:
874: pay_core_files.write_to_magtape_lob('');
875: pay_core_files.write_to_magtape_lob('');
876:

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

874: pay_core_files.write_to_magtape_lob('');
875: pay_core_files.write_to_magtape_lob('');
876:
877: -- Printing Global Variable Values
878: --hr_utility.trace('g_chq_asg_action_id := '||pay_archive_chequewriter.g_chq_asg_action_id);
879: --hr_utility.trace('g_arch_asg_action_id := '||pay_archive_chequewriter.g_arch_asg_action_id);
880:
881: pay_payroll_xml_extract_pkg.generate_third_party (null -- Action Information ID
882: ,ln_arch_assignment_action_id -- Action Context ID

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

875: pay_core_files.write_to_magtape_lob('');
876:
877: -- Printing Global Variable Values
878: --hr_utility.trace('g_chq_asg_action_id := '||pay_archive_chequewriter.g_chq_asg_action_id);
879: --hr_utility.trace('g_arch_asg_action_id := '||pay_archive_chequewriter.g_arch_asg_action_id);
880:
881: pay_payroll_xml_extract_pkg.generate_third_party (null -- Action Information ID
882: ,ln_arch_assignment_action_id -- Action Context ID
883: ,l_pre_payment_id -- Pre Payment ID

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

895:
896: end if;
897:
898: ELSE
899: hr_utility.trace('ln_arch_assignment_action_id IS NULL.');
900:
901: OPEN get_action_details(ln_chq_asg_action_id);
902: FETCH get_action_details INTO
903: l_cheque_no

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

905: ,l_deposit_date
906: ,l_pactid;
907: CLOSE get_action_details;
908:
909: hr_utility.trace('l_cheque_no := '|| l_cheque_no);
910:
911: OPEN get_asssignment_id(ln_chq_asg_action_id);
912: FETCH get_asssignment_id INTO l_assignment_id;
913: CLOSE get_asssignment_id;

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

916: FETCH get_effective_date INTO l_effective_date
917: ,l_pactid ;
918: CLOSE get_effective_date;
919:
920: hr_utility.trace('l_effective_date := '|| TO_CHAR(l_effective_date,'DD-MON-YYYY'));
921:
922: OPEN get_employee_details(l_assignment_id,l_effective_date);
923: FETCH get_employee_details INTO
924: l_first_name

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

935: , l_title
936: , l_asg_num;
937: CLOSE get_employee_details;
938:
939: hr_utility.trace('Before get_pay_meth');
940:
941: OPEN get_pay_meth(ln_chq_asg_action_id,l_pactid);
942: FETCH get_pay_meth INTO l_payee_meth_id
943: ,l_per_pay_method

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

946: ,l_thpty_flag
947: ,l_pre_payment_id;
948: CLOSE get_pay_meth;
949:
950: hr_utility.trace('Before Bank Details');
951:
952: if l_det_org_pay_method is not null then
953: OPEN get_org_bank_details(l_det_org_pay_method,l_effective_date);
954: FETCH get_org_bank_details INTO

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

970: ,l_account_typ ;
971: CLOSE get_person_bank_details;
972: end if;
973:
974: hr_utility.trace('Before Archive Cheque');
975:
976: pay_core_files.write_to_magtape_lob('');
977: pay_core_files.write_to_magtape_lob('');
978:

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

975:
976: pay_core_files.write_to_magtape_lob('');
977: pay_core_files.write_to_magtape_lob('');
978:
979: hr_utility.trace('Calling generate_xml_dummy');
980:
981: generate_xml_dummy(l_cheque_no
982: ,l_account_name
983: ,l_account_number

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

989: ,l_full_name
990: ,l_national_identifier
991: ,ltr_xml_dummy_tab
992: ,lv_legislation_code) ; /* bug 13773808*/
993: hr_utility.trace('After Calling generate_xml_dummy');
994:
995: dbms_lob.createTemporary(l_xml_dummy, true, dbms_lob.session);
996:
997: FOR cntr IN ltr_xml_dummy_tab.first()..ltr_xml_dummy_tab.last()

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

995: dbms_lob.createTemporary(l_xml_dummy, true, dbms_lob.session);
996:
997: FOR cntr IN ltr_xml_dummy_tab.first()..ltr_xml_dummy_tab.last()
998: LOOP
999: hr_utility.trace('Accessing..' || ltr_xml_dummy_tab(cntr));
1000:
1001: lr_xml_dummy := utl_raw.cast_to_raw(ltr_xml_dummy_tab(cntr));
1002: ln_amt_dummy := utl_raw.length(lr_xml_dummy);
1003:

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

1007: END LOOP;
1008:
1009: dummy_xml := l_xml_dummy;
1010:
1011: hr_utility.trace('Successful LOB Creation.');
1012: pay_core_files.write_to_magtape_lob(dummy_xml);
1013:
1014: pay_core_files.write_to_magtape_lob('');
1015:

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

1017: UPDATE pay_assignment_actions
1018: SET action_status = 'S'
1019: WHERE assignment_action_id = ln_chq_asg_action_id;
1020:
1021: hr_utility.trace('Update Successful..');
1022: EXCEPTION
1023:
1024: WHEN OTHERS THEN
1025: hr_utility.trace('Update Unsuccessful..');

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

1021: hr_utility.trace('Update Successful..');
1022: EXCEPTION
1023:
1024: WHEN OTHERS THEN
1025: hr_utility.trace('Update Unsuccessful..');
1026: END;
1027: print_blob(pay_mag_tape.g_blob_value);
1028: dbms_lob.freeTemporary(l_xml_dummy);
1029:

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

1028: dbms_lob.freeTemporary(l_xml_dummy);
1029:
1030: END IF;
1031:
1032: hr_utility.trace('Leaving pay_archive_chequewriter.generate_xml');
1033:
1034: EXCEPTION WHEN OTHERS THEN
1035: hr_utility.trace('SQLERRM := '||SQLERRM) ;
1036: END GENERATE_XML ;

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

1031:
1032: hr_utility.trace('Leaving pay_archive_chequewriter.generate_xml');
1033:
1034: EXCEPTION WHEN OTHERS THEN
1035: hr_utility.trace('SQLERRM := '||SQLERRM) ;
1036: END GENERATE_XML ;
1037:
1038: BEGIN
1039: g_proc_name := 'pay_archive_chequewriter';

Line 1041: g_debug := hr_utility.debug_enabled;

1037:
1038: BEGIN
1039: g_proc_name := 'pay_archive_chequewriter';
1040: g_document_type := 'ARCHIVE_CHEQUE_WRITER';
1041: g_debug := hr_utility.debug_enabled;
1042:
1043: END pay_archive_chequewriter;