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.PER_NL_FDR_ARCHIVE dependencies on HR_UTILITY

Line 23: --hr_utility.set_location('Entering get_parameter',52);

19: l_delimiter varchar2(1):=' ';
20:
21: BEGIN
22: --
23: --hr_utility.set_location('Entering get_parameter',52);
24: --
25: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
26: --
27: IF l_start_pos = 0 THEN

Line 48: --hr_utility.set_location('Leaving get_parameter',53);

44: - instr(l_parameter,':',1,p_segment_number));
45: END IF;
46: END IF;
47: --
48: --hr_utility.set_location('Leaving get_parameter',53);
49: --hr_utility.set_location('Entering get_parameter l_parameter--'||l_parameter||'--',54);
50: RETURN l_parameter;
51:
52: END get_parameter;

Line 49: --hr_utility.set_location('Entering get_parameter l_parameter--'||l_parameter||'--',54);

45: END IF;
46: END IF;
47: --
48: --hr_utility.set_location('Leaving get_parameter',53);
49: --hr_utility.set_location('Entering get_parameter l_parameter--'||l_parameter||'--',54);
50: RETURN l_parameter;
51:
52: END get_parameter;
53:

Line 84: --hr_utility.set_location('Entering get_all_parameters',51);

80: l_parameter_string PAY_PAYROLL_ACTIONS.LEGISLATIVE_PARAMETERS%TYPE;
81:
82: BEGIN
83:
84: --hr_utility.set_location('Entering get_all_parameters',51);
85:
86: OPEN csr_parameter_info (p_payroll_action_id);
87: FETCH csr_parameter_info INTO p_report_date
88: ,p_org_struct_id

Line 105: --hr_utility.set_location('Leaving get_all_parameters',54);

101: p_report_date := substr(l_parameter_string,instr(l_parameter_string,'/',1,1)-4,10);
102:
103: END IF;
104:
105: --hr_utility.set_location('Leaving get_all_parameters',54);
106: END;
107:
108:
109:

Line 125: --hr_utility.trace('IANA Charset = '||lv_iana_charset);

121: OPEN csr_get_iana_charset;
122: FETCH csr_get_iana_charset INTO lv_iana_charset;
123: CLOSE csr_get_iana_charset;
124:
125: --hr_utility.trace('IANA Charset = '||lv_iana_charset);
126: RETURN (lv_iana_charset);
127: END get_IANA_charset;
128:
129:

Line 154: hr_utility.set_location('Entered Procedure Write to clob ',100);

150:
151:
152: begin
153: --fnd_file.put_line(fnd_file.log,'g_year : '||g_year);
154: hr_utility.set_location('Entered Procedure Write to clob ',100);
155: -- l_str0 := '';
156: -- l_str0 := '';
157: l_str0 := ''; -- for bug 5376513
158: IF g_year < '2008' THEN

Line 217: hr_utility.set_location('Finished Procedure Write to CLOB ',110);

213: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
214: end if;
215: DBMS_LOB.CREATETEMPORARY(p_xfdf_clob,TRUE);
216: p_xfdf_clob := l_xfdf_string;
217: hr_utility.set_location('Finished Procedure Write to CLOB ',110);
218: EXCEPTION
219: WHEN OTHERS then
220: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
221: HR_UTILITY.RAISE_ERROR;

Line 220: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);

216: p_xfdf_clob := l_xfdf_string;
217: hr_utility.set_location('Finished Procedure Write to CLOB ',110);
218: EXCEPTION
219: WHEN OTHERS then
220: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
221: HR_UTILITY.RAISE_ERROR;
222: END WritetoCLOB_rtf;
223:
224:

Line 221: HR_UTILITY.RAISE_ERROR;

217: hr_utility.set_location('Finished Procedure Write to CLOB ',110);
218: EXCEPTION
219: WHEN OTHERS then
220: HR_UTILITY.TRACE('sqleerm ' || SQLERRM);
221: HR_UTILITY.RAISE_ERROR;
222: END WritetoCLOB_rtf;
223:
224:
225:

Line 488: /*hr_utility.trace_on(NULL,'NL_FDR');

484: l_return_val NUMBER := 0;
485:
486: BEGIN
487:
488: /*hr_utility.trace_on(NULL,'NL_FDR');
489: hr_utility.set_location('Report date - '||p_report_date,1);*/
490:
491:
492: IF p_org_struct_id is NULL THEN

Line 489: hr_utility.set_location('Report date - '||p_report_date,1);*/

485:
486: BEGIN
487:
488: /*hr_utility.trace_on(NULL,'NL_FDR');
489: hr_utility.set_location('Report date - '||p_report_date,1);*/
490:
491:
492: IF p_org_struct_id is NULL THEN
493:

Line 494: --hr_utility.set_location('hierarchy not chosen',1);

490:
491:
492: IF p_org_struct_id is NULL THEN
493:
494: --hr_utility.set_location('hierarchy not chosen',1);
495: BEGIN
496:
497: select 1 INTO l_return_val
498: from hr_organization_units hou

Line 533: --hr_utility.set_location('hierarchy chosen',2);

529: END;
530:
531: ELSE
532:
533: --hr_utility.set_location('hierarchy chosen',2);
534:
535: BEGIN
536:
537: SELECT 1 INTO l_return_val

Line 639: --hr_utility.trace_on(NULL,'NL_FDR');

635: ORDER BY pap.person_id';
636:
637:
638:
639: --hr_utility.trace_on(NULL,'NL_FDR');
640: hr_utility.set_location('Leaving Range Code',10);
641:
642: EXCEPTION
643:

Line 640: hr_utility.set_location('Leaving Range Code',10);

636:
637:
638:
639: --hr_utility.trace_on(NULL,'NL_FDR');
640: hr_utility.set_location('Leaving Range Code',10);
641:
642: EXCEPTION
643:
644: WHEN OTHERS THEN

Line 837: hr_utility.set_location('Entering assg action Code',20);

833: l_org_struct_id := NULL;
834: l_person_id := NULL;
835: l_org_id := NULL;
836:
837: hr_utility.set_location('Entering assg action Code',20);
838:
839: PER_NL_FDR_ARCHIVE.get_all_parameters(p_payroll_action_id, l_report_date, l_org_struct_id, l_person_id, l_org_id, l_bg_id);
840:
841: --hr_utility.set_location('Parameters:- date: '||l_report_date||' hier: '||l_org_struct_id||' org: '||l_org_id,30);

Line 841: --hr_utility.set_location('Parameters:- date: '||l_report_date||' hier: '||l_org_struct_id||' org: '||l_org_id,30);

837: hr_utility.set_location('Entering assg action Code',20);
838:
839: PER_NL_FDR_ARCHIVE.get_all_parameters(p_payroll_action_id, l_report_date, l_org_struct_id, l_person_id, l_org_id, l_bg_id);
840:
841: --hr_utility.set_location('Parameters:- date: '||l_report_date||' hier: '||l_org_struct_id||' org: '||l_org_id,30);
842:
843: IF l_person_id is not NULL THEN
844:
845: --hr_utility.set_location('Person selected',40);

Line 845: --hr_utility.set_location('Person selected',40);

841: --hr_utility.set_location('Parameters:- date: '||l_report_date||' hier: '||l_org_struct_id||' org: '||l_org_id,30);
842:
843: IF l_person_id is not NULL THEN
844:
845: --hr_utility.set_location('Person selected',40);
846:
847: FOR v_csr_get_asg_person in csr_get_asg_person(l_person_id, p_start_person_id, p_end_person_id, p_payroll_action_id)
848:
849: LOOP

Line 857: --hr_utility.set_location('Assignment id - '||to_char(v_csr_get_asg_person.assignment_id)||' selected',45);

853: FROM dual;
854:
855: hr_nonrun_asact.insact(l_asg_act_id,v_csr_get_asg_person.assignment_id, p_payroll_action_id,p_chunk,NULL);
856:
857: --hr_utility.set_location('Assignment id - '||to_char(v_csr_get_asg_person.assignment_id)||' selected',45);
858:
859: END LOOP;
860:
861: ELSIF l_org_id is not NULL THEN

Line 863: --hr_utility.set_location('Org selected',50);

859: END LOOP;
860:
861: ELSIF l_org_id is not NULL THEN
862:
863: --hr_utility.set_location('Org selected',50);
864:
865: FOR v_csr_get_asg_org in csr_get_asg_org(l_org_id, l_org_struct_id, p_start_person_id, p_end_person_id, p_payroll_action_id, l_report_date)
866:
867: LOOP

Line 869: --hr_utility.set_location('Selecting assignment '||to_char(v_csr_get_asg_org.assignment_id),55);

865: FOR v_csr_get_asg_org in csr_get_asg_org(l_org_id, l_org_struct_id, p_start_person_id, p_end_person_id, p_payroll_action_id, l_report_date)
866:
867: LOOP
868:
869: --hr_utility.set_location('Selecting assignment '||to_char(v_csr_get_asg_org.assignment_id),55);
870:
871: SELECT pay_assignment_actions_s.NEXTVAL
872: INTO l_asg_act_id
873: FROM dual;

Line 877: --hr_utility.set_location('Assignment id - '||to_char(v_csr_get_asg_org.assignment_id)||' selected',57);

873: FROM dual;
874:
875: hr_nonrun_asact.insact(l_asg_act_id,v_csr_get_asg_org.assignment_id, p_payroll_action_id,p_chunk,NULL);
876:
877: --hr_utility.set_location('Assignment id - '||to_char(v_csr_get_asg_org.assignment_id)||' selected',57);
878:
879: END LOOP;
880:
881:

Line 884: --hr_utility.set_location('Hier selected',60);

880:
881:
882: ELSIF l_org_struct_id is not NULL THEN
883:
884: --hr_utility.set_location('Hier selected',60);
885: --hr_utility.set_location('Hier - '||to_char(l_org_struct_id)||' Pactid - '||p_payroll_action_id||' rep date - '||l_report_date||' start - '||p_start_person_id||' end - '||p_end_person_id,61);
886:
887: FOR v_csr_get_asg_hier in csr_get_asg_hier(l_org_struct_id, l_report_date, p_start_person_id, p_end_person_id, p_payroll_action_id)
888:

Line 885: --hr_utility.set_location('Hier - '||to_char(l_org_struct_id)||' Pactid - '||p_payroll_action_id||' rep date - '||l_report_date||' start - '||p_start_person_id||' end - '||p_end_person_id,61);

881:
882: ELSIF l_org_struct_id is not NULL THEN
883:
884: --hr_utility.set_location('Hier selected',60);
885: --hr_utility.set_location('Hier - '||to_char(l_org_struct_id)||' Pactid - '||p_payroll_action_id||' rep date - '||l_report_date||' start - '||p_start_person_id||' end - '||p_end_person_id,61);
886:
887: FOR v_csr_get_asg_hier in csr_get_asg_hier(l_org_struct_id, l_report_date, p_start_person_id, p_end_person_id, p_payroll_action_id)
888:
889: LOOP

Line 891: --hr_utility.set_location('Assignment id - '||to_char(v_csr_get_asg_hier.assignment_id)||' selected before inserting', 62);

887: FOR v_csr_get_asg_hier in csr_get_asg_hier(l_org_struct_id, l_report_date, p_start_person_id, p_end_person_id, p_payroll_action_id)
888:
889: LOOP
890:
891: --hr_utility.set_location('Assignment id - '||to_char(v_csr_get_asg_hier.assignment_id)||' selected before inserting', 62);
892:
893: SELECT pay_assignment_actions_s.NEXTVAL
894: INTO l_asg_act_id
895: FROM dual;

Line 899: --hr_utility.set_location('Assignment id - '||to_char(v_csr_get_asg_hier.assignment_id)||' inserted', 65);

895: FROM dual;
896:
897: hr_nonrun_asact.insact(l_asg_act_id,v_csr_get_asg_hier.assignment_id, p_payroll_action_id,p_chunk,NULL);
898:
899: --hr_utility.set_location('Assignment id - '||to_char(v_csr_get_asg_hier.assignment_id)||' inserted', 65);
900:
901: END LOOP;
902:
903: END IF;

Line 1052: --hr_utility.trace_on(NULL,'NL_FDR');

1048:
1049:
1050: BEGIN
1051:
1052: --hr_utility.trace_on(NULL,'NL_FDR');
1053: --hr_utility.set_location('Entered archive code', 90);
1054: l_create_peit := 'Y';
1055:
1056: SELECT PER_NL_FDR_ARCHIVE.get_parameter(ppa.legislative_parameters,'REPORT_DATE')

Line 1053: --hr_utility.set_location('Entered archive code', 90);

1049:
1050: BEGIN
1051:
1052: --hr_utility.trace_on(NULL,'NL_FDR');
1053: --hr_utility.set_location('Entered archive code', 90);
1054: l_create_peit := 'Y';
1055:
1056: SELECT PER_NL_FDR_ARCHIVE.get_parameter(ppa.legislative_parameters,'REPORT_DATE')
1057: INTO l_report_date

Line 1096: --hr_utility.set_location('Processing employee number: '||l_employee_number||' with leg emp '||l_establishment_id,95);

1092: OPEN csr_get_person_info(p_assignment_action_id);
1093: FETCH csr_get_person_info into l_hire_date, l_employee_number, l_sofi_number, l_initial, l_prefix, l_last_name, l_full_name, l_date_of_birth, l_person_id, l_bg_id, l_establishment_id;
1094: CLOSE csr_get_person_info;
1095:
1096: --hr_utility.set_location('Processing employee number: '||l_employee_number||' with leg emp '||l_establishment_id,95);
1097:
1098: IF l_establishment_id is not NULL and per_nl_fdr_archive.org_check(l_bg_id,null,l_establishment_id,to_date(l_report_date,'RRRR/MM/DD')) = 1 THEN
1099:
1100: --hr_utility.set_location('Entered IF condition for legal employer',97);

Line 1100: --hr_utility.set_location('Entered IF condition for legal employer',97);

1096: --hr_utility.set_location('Processing employee number: '||l_employee_number||' with leg emp '||l_establishment_id,95);
1097:
1098: IF l_establishment_id is not NULL and per_nl_fdr_archive.org_check(l_bg_id,null,l_establishment_id,to_date(l_report_date,'RRRR/MM/DD')) = 1 THEN
1099:
1100: --hr_utility.set_location('Entered IF condition for legal employer',97);
1101: OPEN csr_get_leg_info(p_assignment_action_id);
1102: FETCH csr_get_leg_info INTO l_org_id, l_org_name, l_tax_reg_num;
1103: CLOSE csr_get_leg_info;
1104:

Line 1107: --hr_utility.set_location('Entered else condition for HR org',99);

1103: CLOSE csr_get_leg_info;
1104:
1105: ELSE
1106:
1107: --hr_utility.set_location('Entered else condition for HR org',99);
1108: OPEN csr_get_org_info(p_assignment_action_id, l_org_struct_id, l_report_date);
1109: FETCH csr_get_org_info INTO l_org_id, l_org_name, l_tax_reg_num;
1110: CLOSE csr_get_org_info;
1111:

Line 1116: --hr_utility.set_location('Employee number - '||l_employee_number||' selected', 100);

1112:
1113: END IF;
1114:
1115:
1116: --hr_utility.set_location('Employee number - '||l_employee_number||' selected', 100);
1117:
1118:
1119: vXMLTable(vCtr).TagName := 'Bericht';
1120: vXMLTable(vCtr).TagValue := null;