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

Line 19: -- hr_utility.trace('+====c2b===================================================+');

15: buffer RAW(32767);
16: res BLOB;
17: lob_len PLS_INTEGER := dbms_lob.getlength(c);
18: BEGIN
19: -- hr_utility.trace('+====c2b===================================================+');
20: dbms_lob.createtemporary(res,TRUE);
21: dbms_lob.open(res,dbms_lob.lob_readwrite);
22: LOOP
23: buffer := utl_raw.cast_to_raw( dbms_lob.substr( c, 16000, pos ) );

Line 30: -- hr_utility.trace('X====c2b===================================================X');

26: END IF;
27: pos := pos + 16000;
28: EXIT WHEN pos > lob_len;
29: END LOOP;
30: -- hr_utility.trace('X====c2b===================================================X');
31: RETURN res;
32: EXCEPTION
33: WHEN others THEN
34: hr_utility.trace('Exception in c2b SQL-ERRM : '||SQLERRM);

Line 34: hr_utility.trace('Exception in c2b SQL-ERRM : '||SQLERRM);

30: -- hr_utility.trace('X====c2b===================================================X');
31: RETURN res;
32: EXCEPTION
33: WHEN others THEN
34: hr_utility.trace('Exception in c2b SQL-ERRM : '||SQLERRM);
35: END c2b;
36: /**************************************************************************/
37:
38: /*------------------------------------------------------------------------------

Line 62: hr_utility.trace('Exception in clean_XML SQL-ERRM :'||SQLERRM);

58: END IF;
59: RETURN l_string;
60: EXCEPTION
61: WHEN others THEN
62: hr_utility.trace('Exception in clean_XML SQL-ERRM :'||SQLERRM);
63: RETURN l_string;
64: END clean_XML;
65: /**************************************************************************/
66:

Line 92: hr_utility.trace('+====write_file============================================+');

88: FROM v$parameter
89: WHERE lower (name) = 'utl_file_dir';
90:
91: BEGIN
92: hr_utility.trace('+====write_file============================================+');
93: OPEN cur_get_directory_path;
94: FETCH cur_get_directory_path INTO l_directory_path;
95: CLOSE cur_get_directory_path;
96:

Line 124: hr_utility.trace('Written file : '||l_directory_path||'/'||p_file_name);

120: -- END IF;
121: END LOOP;
122: END IF;
123: utl_file.fclose(l_file);
124: hr_utility.trace('Written file : '||l_directory_path||'/'||p_file_name);
125: hr_utility.trace('x====write_file============================================x');
126: EXCEPTION
127: WHEN others THEN
128: hr_utility.trace('Exception in write_file SQL-ERRM : '||SQLERRM);

Line 125: hr_utility.trace('x====write_file============================================x');

121: END LOOP;
122: END IF;
123: utl_file.fclose(l_file);
124: hr_utility.trace('Written file : '||l_directory_path||'/'||p_file_name);
125: hr_utility.trace('x====write_file============================================x');
126: EXCEPTION
127: WHEN others THEN
128: hr_utility.trace('Exception in write_file SQL-ERRM : '||SQLERRM);
129: hr_utility.raise_error;

Line 128: hr_utility.trace('Exception in write_file SQL-ERRM : '||SQLERRM);

124: hr_utility.trace('Written file : '||l_directory_path||'/'||p_file_name);
125: hr_utility.trace('x====write_file============================================x');
126: EXCEPTION
127: WHEN others THEN
128: hr_utility.trace('Exception in write_file SQL-ERRM : '||SQLERRM);
129: hr_utility.raise_error;
130: END write_file;
131: /**************************************************************************/
132:

Line 129: hr_utility.raise_error;

125: hr_utility.trace('x====write_file============================================x');
126: EXCEPTION
127: WHEN others THEN
128: hr_utility.trace('Exception in write_file SQL-ERRM : '||SQLERRM);
129: hr_utility.raise_error;
130: END write_file;
131: /**************************************************************************/
132:
133:

Line 147: hr_utility.trace('+====write_report==========================================+');

143: PROCEDURE write_report(p_XMLTable IN tXMLTable) IS
144: l_xml_element VARCHAR2(800);
145: l_clob CLOB;
146: BEGIN
147: hr_utility.trace('+====write_report==========================================+');
148: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
149: dbms_lob.open(l_clob, DBMS_LOB.LOB_READWRITE);
150:
151: IF p_XMLTable.COUNT > 0 THEN

Line 172: hr_utility.trace('x====write_report==========================================x');

168: END IF;
169: IF l_clob IS NOT NULL THEN
170: pay_core_files.write_to_magtape_lob(c2b(l_clob));
171: END IF;
172: hr_utility.trace('x====write_report==========================================x');
173: EXCEPTION
174: WHEN others THEN
175: hr_utility.trace('Exception in write_report SQL-ERRM : '||SQLERRM);
176: hr_utility.raise_error;

Line 175: hr_utility.trace('Exception in write_report SQL-ERRM : '||SQLERRM);

171: END IF;
172: hr_utility.trace('x====write_report==========================================x');
173: EXCEPTION
174: WHEN others THEN
175: hr_utility.trace('Exception in write_report SQL-ERRM : '||SQLERRM);
176: hr_utility.raise_error;
177: END write_report;
178: /**************************************************************************/
179:

Line 176: hr_utility.raise_error;

172: hr_utility.trace('x====write_report==========================================x');
173: EXCEPTION
174: WHEN others THEN
175: hr_utility.trace('Exception in write_report SQL-ERRM : '||SQLERRM);
176: hr_utility.raise_error;
177: END write_report;
178: /**************************************************************************/
179:
180: FUNCTION get_look_up_value(p_lookup_type IN VARCHAR2

Line 206: hr_utility.trace('Exception in get_look_up_value SQL-ERRM : '||SQLERRM);

202: RETURN NULL;
203: WHEN NO_DATA_FOUND THEN
204: RETURN NULL;
205: WHEN others THEN
206: hr_utility.trace('Exception in get_look_up_value SQL-ERRM : '||SQLERRM);
207:
208: END get_look_up_value;
209: /**************************************************************************/
210:

Line 303: hr_utility.trace('Exception in get_all_parameters SQLERRM: '||SQLERRM);

299: p_end_date := l_param.end_date;
300:
301: EXCEPTION
302: WHEN others THEN
303: hr_utility.trace('Exception in get_all_parameters SQLERRM: '||SQLERRM);
304: END get_all_parameters;
305: /**************************************************************************/
306:
307:

Line 556: hr_utility.trace('+====emp_check============================================+');

552: l_start_date DATE;
553: l_end_date DATE;
554:
555: BEGIN
556: hr_utility.trace('+====emp_check============================================+');
557: IF p_org_id is not NULL THEN
558: BEGIN
559: OPEN csr_org_check(p_bg_id
560: ,p_org_struct_id

Line 574: hr_utility.trace('Exception in emp_check org. SQLERRM : '||SQLERRM);

570: l_return_val := 1;
571: WHEN NO_DATA_FOUND THEN
572: null;
573: WHEN OTHERS THEN
574: hr_utility.trace('Exception in emp_check org. SQLERRM : '||SQLERRM);
575: END;
576: hr_utility.trace('l_return_val : '||l_return_val);
577: ELSIF p_org_struct_id is not NULL THEN
578: BEGIN

Line 576: hr_utility.trace('l_return_val : '||l_return_val);

572: null;
573: WHEN OTHERS THEN
574: hr_utility.trace('Exception in emp_check org. SQLERRM : '||SQLERRM);
575: END;
576: hr_utility.trace('l_return_val : '||l_return_val);
577: ELSIF p_org_struct_id is not NULL THEN
578: BEGIN
579: OPEN csr_org_struct_check(p_bg_id
580: ,p_org_struct_id

Line 593: hr_utility.trace('Exception in emp_check org_struct. SQLERRM : '||SQLERRM);

589: l_return_val := 1;
590: WHEN NO_DATA_FOUND THEN
591: NULL;
592: WHEN OTHERS THEN
593: hr_utility.trace('Exception in emp_check org_struct. SQLERRM : '||SQLERRM);
594: END;
595: hr_utility.trace('l_return_val : '||l_return_val);
596: END IF;
597: hr_utility.trace('X====emp_check============================================X');

Line 595: hr_utility.trace('l_return_val : '||l_return_val);

591: NULL;
592: WHEN OTHERS THEN
593: hr_utility.trace('Exception in emp_check org_struct. SQLERRM : '||SQLERRM);
594: END;
595: hr_utility.trace('l_return_val : '||l_return_val);
596: END IF;
597: hr_utility.trace('X====emp_check============================================X');
598: RETURN l_return_val;
599: EXCEPTION

Line 597: hr_utility.trace('X====emp_check============================================X');

593: hr_utility.trace('Exception in emp_check org_struct. SQLERRM : '||SQLERRM);
594: END;
595: hr_utility.trace('l_return_val : '||l_return_val);
596: END IF;
597: hr_utility.trace('X====emp_check============================================X');
598: RETURN l_return_val;
599: EXCEPTION
600: WHEN OTHERS THEN
601: hr_utility.trace('Exception in emp_check SQL-ERRM : '||SQLERRM);

Line 601: hr_utility.trace('Exception in emp_check SQL-ERRM : '||SQLERRM);

597: hr_utility.trace('X====emp_check============================================X');
598: RETURN l_return_val;
599: EXCEPTION
600: WHEN OTHERS THEN
601: hr_utility.trace('Exception in emp_check SQL-ERRM : '||SQLERRM);
602: END emp_check;
603: /**************************************************************************/
604:
605:

Line 730: --hr_utility.trace('+====org_check=============================================+');

726: l_start_date DATE;
727: l_end_date DATE;
728:
729: BEGIN
730: --hr_utility.trace('+====org_check=============================================+');
731: IF p_org_struct_id is NULL THEN
732: BEGIN
733: OPEN csr_org_struct_check (p_bg_id,p_org_id);
734: FETCH csr_org_struct_check INTO l_return_val;

Line 743: hr_utility.trace('Exception in org_check org_struct. SQLERRM : '||SQLERRM);

739: l_return_val := 1;
740: WHEN NO_DATA_FOUND THEN
741: NULL;
742: WHEN OTHERS THEN
743: hr_utility.trace('Exception in org_check org_struct. SQLERRM : '||SQLERRM);
744: END;
745: hr_utility.trace('l_return_val : '||l_return_val);
746: ELSE
747: BEGIN

Line 745: hr_utility.trace('l_return_val : '||l_return_val);

741: NULL;
742: WHEN OTHERS THEN
743: hr_utility.trace('Exception in org_check org_struct. SQLERRM : '||SQLERRM);
744: END;
745: hr_utility.trace('l_return_val : '||l_return_val);
746: ELSE
747: BEGIN
748: OPEN csr_org_check (p_bg_id,p_org_id,p_org_struct_id,p_start_date,p_end_date);
749: FETCH csr_org_check INTO l_return_val;

Line 758: hr_utility.trace('Exception in org_check org_struct1. SQLERRM : '||SQLERRM);

754: l_return_val := 1;
755: WHEN NO_DATA_FOUND THEN
756: NULL;
757: WHEN OTHERS THEN
758: hr_utility.trace('Exception in org_check org_struct1. SQLERRM : '||SQLERRM);
759: END;
760: hr_utility.trace('l_return_val : '||l_return_val);
761: END IF;
762: RETURN l_return_val;

Line 760: hr_utility.trace('l_return_val : '||l_return_val);

756: NULL;
757: WHEN OTHERS THEN
758: hr_utility.trace('Exception in org_check org_struct1. SQLERRM : '||SQLERRM);
759: END;
760: hr_utility.trace('l_return_val : '||l_return_val);
761: END IF;
762: RETURN l_return_val;
763: --hr_utility.trace('X====org_check=============================================X');
764: EXCEPTION

Line 763: --hr_utility.trace('X====org_check=============================================X');

759: END;
760: hr_utility.trace('l_return_val : '||l_return_val);
761: END IF;
762: RETURN l_return_val;
763: --hr_utility.trace('X====org_check=============================================X');
764: EXCEPTION
765: WHEN OTHERS THEN
766: hr_utility.trace('Exception in org_check SQL-ERRM : '||SQLERRM);
767: END org_check;

Line 766: hr_utility.trace('Exception in org_check SQL-ERRM : '||SQLERRM);

762: RETURN l_return_val;
763: --hr_utility.trace('X====org_check=============================================X');
764: EXCEPTION
765: WHEN OTHERS THEN
766: hr_utility.trace('Exception in org_check SQL-ERRM : '||SQLERRM);
767: END org_check;
768: /**************************************************************************/
769:
770: /*--------------------------------------------------------------------

Line 781: hr_utility.trace('+====range_code============================================+');

777:
778: PROCEDURE range_code (pactid IN NUMBER
779: ,sqlstr OUT NOCOPY VARCHAR2) is
780: BEGIN
781: hr_utility.trace('+====range_code============================================+');
782: sqlstr := 'SELECT DISTINCT person_id
783: FROM per_all_people_f pap
784: ,pay_payroll_actions ppa
785: WHERE ppa.payroll_action_id = :payroll_action_id

Line 788: hr_utility.trace('X====range_code============================================X');

784: ,pay_payroll_actions ppa
785: WHERE ppa.payroll_action_id = :payroll_action_id
786: AND ppa.business_group_id = pap.business_group_id
787: ORDER BY pap.person_id';
788: hr_utility.trace('X====range_code============================================X');
789: EXCEPTION
790: WHEN OTHERS THEN
791: -- Return cursor that selects no rows
792: hr_utility.trace('Exception in range_code SQL-ERRM : '||SQLERRM);

Line 792: hr_utility.trace('Exception in range_code SQL-ERRM : '||SQLERRM);

788: hr_utility.trace('X====range_code============================================X');
789: EXCEPTION
790: WHEN OTHERS THEN
791: -- Return cursor that selects no rows
792: hr_utility.trace('Exception in range_code SQL-ERRM : '||SQLERRM);
793: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
794: END range_code;
795:
796: /**************************************************************************/

Line 839: hr_utility.trace('+====initialization_code===================================+');

835: l_bg_id NUMBER;
836: l_start_date DATE;
837:
838: BEGIN
839: hr_utility.trace('+====initialization_code===================================+');
840: IF INSTR ('a', COMPOSE('a'|| UNISTR('\0301')) ) = 0 THEN
841: OPEN c_bg_stdate(p_action_context_id);
842: FETCH c_bg_stdate INTO l_bg_id,l_start_date;
843: CLOSE c_bg_stdate;

Line 855: hr_utility.trace('g_SOURCE : '||g_SOURCE);

851: g_SOURCE := g_SOURCE||upper(I.Source)||lower(I.Source);
852: g_TARGET := g_TARGET||upper(I.Target)||lower(I.Target);
853: END LOOP;
854:
855: hr_utility.trace('g_SOURCE : '||g_SOURCE);
856: hr_utility.trace('g_TARGET : '||g_TARGET);
857: END IF;
858: hr_utility.trace('X====initialization_code===================================X');
859: EXCEPTION

Line 856: hr_utility.trace('g_TARGET : '||g_TARGET);

852: g_TARGET := g_TARGET||upper(I.Target)||lower(I.Target);
853: END LOOP;
854:
855: hr_utility.trace('g_SOURCE : '||g_SOURCE);
856: hr_utility.trace('g_TARGET : '||g_TARGET);
857: END IF;
858: hr_utility.trace('X====initialization_code===================================X');
859: EXCEPTION
860: WHEN OTHERS THEN

Line 858: hr_utility.trace('X====initialization_code===================================X');

854:
855: hr_utility.trace('g_SOURCE : '||g_SOURCE);
856: hr_utility.trace('g_TARGET : '||g_TARGET);
857: END IF;
858: hr_utility.trace('X====initialization_code===================================X');
859: EXCEPTION
860: WHEN OTHERS THEN
861: hr_utility.trace('Exception in init_code SQL-ERRM : '||SQLERRM);
862: END initialization_code;

Line 861: hr_utility.trace('Exception in init_code SQL-ERRM : '||SQLERRM);

857: END IF;
858: hr_utility.trace('X====initialization_code===================================X');
859: EXCEPTION
860: WHEN OTHERS THEN
861: hr_utility.trace('Exception in init_code SQL-ERRM : '||SQLERRM);
862: END initialization_code;
863: /**************************************************************************/
864: /*--------------------------------------------------------------------
865: |Name : ASSIGNMENT_ACTION_CODE |

Line 1202: hr_utility.trace('Exception in ins_assg_act SQL-ERRM : '||SQLERRM);

1198: ,pactid => p_pactid
1199: ,chunk => p_chunk);
1200: EXCEPTION
1201: WHEN others THEN
1202: hr_utility.trace('Exception in ins_assg_act SQL-ERRM : '||SQLERRM);
1203: END ins_assg_act;
1204: /**************************************************************************/
1205:
1206:

Line 1208: hr_utility.trace('+====assignment_action_code================================+');

1204: /**************************************************************************/
1205:
1206:
1207: BEGIN
1208: hr_utility.trace('+====assignment_action_code================================+');
1209: hr_utility.trace('Payroll_action_id/Chunk: '||p_payroll_action_id||' / '||p_chunk );
1210: hr_utility.trace('Start/End Person ID : '||p_start_person_id||' / '||p_end_person_id );
1211:
1212: get_all_parameters (

Line 1209: hr_utility.trace('Payroll_action_id/Chunk: '||p_payroll_action_id||' / '||p_chunk );

1205:
1206:
1207: BEGIN
1208: hr_utility.trace('+====assignment_action_code================================+');
1209: hr_utility.trace('Payroll_action_id/Chunk: '||p_payroll_action_id||' / '||p_chunk );
1210: hr_utility.trace('Start/End Person ID : '||p_start_person_id||' / '||p_end_person_id );
1211:
1212: get_all_parameters (
1213: p_payroll_action_id => p_payroll_action_id

Line 1210: hr_utility.trace('Start/End Person ID : '||p_start_person_id||' / '||p_end_person_id );

1206:
1207: BEGIN
1208: hr_utility.trace('+====assignment_action_code================================+');
1209: hr_utility.trace('Payroll_action_id/Chunk: '||p_payroll_action_id||' / '||p_chunk );
1210: hr_utility.trace('Start/End Person ID : '||p_start_person_id||' / '||p_end_person_id );
1211:
1212: get_all_parameters (
1213: p_payroll_action_id => p_payroll_action_id
1214: ,p_org_struct_id => l_org_struct_id

Line 1224: hr_utility.trace(l_type||' Person selected ' ||l_person_id||' '||p_start_person_id||' '||p_end_person_id);

1220: ,p_type => l_type);
1221:
1222:
1223: IF l_person_id is not NULL THEN
1224: hr_utility.trace(l_type||' Person selected ' ||l_person_id||' '||p_start_person_id||' '||p_end_person_id);
1225: IF l_type = 'I' THEN
1226: FOR v_csr_get_asg_person IN
1227: csr_get_asg_person(l_person_id, p_start_person_id, p_end_person_id
1228: , p_payroll_action_id, l_start_date, l_end_date)

Line 1242: hr_utility.trace(l_type||' Org selected ' ||l_org_id);

1238: END LOOP;
1239: END IF;
1240: -----------------------------------------------
1241: ELSIF l_org_id is not NULL THEN
1242: hr_utility.trace(l_type||' Org selected ' ||l_org_id);
1243: IF l_type = 'I' THEN
1244: FOR v_csr_get_asg_org IN
1245: csr_get_asg_org(l_org_id, l_org_struct_id
1246: , p_start_person_id, p_end_person_id, p_payroll_action_id

Line 1262: hr_utility.trace(l_type||' Hierarchy selected ' ||l_org_struct_id);

1258: END LOOP;
1259: END IF;
1260: -----------------------------------------------
1261: ELSIF l_org_struct_id is not NULL THEN
1262: hr_utility.trace(l_type||' Hierarchy selected ' ||l_org_struct_id);
1263: IF l_type = 'I' THEN
1264: FOR v_csr_get_asg_hier IN
1265: csr_get_asg_hier(l_org_struct_id, p_start_person_id, p_end_person_id
1266: , p_payroll_action_id, l_start_date, l_end_date)

Line 1279: hr_utility.trace('X====assignment_action_code================================X');

1275: ins_assg_act(v_csr_get_asg_hier.assignment_id,p_payroll_action_id,p_chunk);
1276: END LOOP;
1277: END IF;
1278: END IF;
1279: hr_utility.trace('X====assignment_action_code================================X');
1280: EXCEPTION
1281: WHEN others THEN
1282: hr_utility.trace('Exception in assignment_action_code SQL-ERRM : '||SQLERRM);
1283: END assignment_action_code;

Line 1282: hr_utility.trace('Exception in assignment_action_code SQL-ERRM : '||SQLERRM);

1278: END IF;
1279: hr_utility.trace('X====assignment_action_code================================X');
1280: EXCEPTION
1281: WHEN others THEN
1282: hr_utility.trace('Exception in assignment_action_code SQL-ERRM : '||SQLERRM);
1283: END assignment_action_code;
1284: /**************************************************************************/
1285:
1286: /*-------------------------------------------------------------------------------

Line 1785: hr_utility.trace('+====archive_code==========================================+');

1781: l_numiv_override per_assignment_extra_info.aei_information1%TYPE;
1782:
1783: /**************************************************************************/
1784: BEGIN
1785: hr_utility.trace('+====archive_code==========================================+');
1786: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1787: hr_utility.trace('p_effective_date : '||p_effective_date);
1788:
1789: OPEN c_get_pact_chunk (p_assignment_action_id);

Line 1786: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);

1782:
1783: /**************************************************************************/
1784: BEGIN
1785: hr_utility.trace('+====archive_code==========================================+');
1786: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1787: hr_utility.trace('p_effective_date : '||p_effective_date);
1788:
1789: OPEN c_get_pact_chunk (p_assignment_action_id);
1790: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;

Line 1787: hr_utility.trace('p_effective_date : '||p_effective_date);

1783: /**************************************************************************/
1784: BEGIN
1785: hr_utility.trace('+====archive_code==========================================+');
1786: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1787: hr_utility.trace('p_effective_date : '||p_effective_date);
1788:
1789: OPEN c_get_pact_chunk (p_assignment_action_id);
1790: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
1791: CLOSE c_get_pact_chunk;

Line 1793: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);

1789: OPEN c_get_pact_chunk (p_assignment_action_id);
1790: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
1791: CLOSE c_get_pact_chunk;
1792:
1793: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1794: hr_utility.trace('l_chunk_number : '||l_chunk_number);
1795:
1796: get_all_parameters (
1797: p_payroll_action_id => l_payroll_action_id

Line 1794: hr_utility.trace('l_chunk_number : '||l_chunk_number);

1790: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
1791: CLOSE c_get_pact_chunk;
1792:
1793: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1794: hr_utility.trace('l_chunk_number : '||l_chunk_number);
1795:
1796: get_all_parameters (
1797: p_payroll_action_id => l_payroll_action_id
1798: ,p_org_struct_id => l_org_struct_id

Line 1817: hr_utility.trace('Assignment/Attendence : ' || l_assignment_id||'/'||l_abs_attendence_id);

1813: l_assignment_id := v_csr_get_abs_details.assignment_id;
1814: l_abs_attendence_id := v_csr_get_abs_details.abs_att_id;
1815: l_abs_start_date := v_csr_get_abs_details.start_date;
1816: l_abs_end_date := v_csr_get_abs_details.end_date;
1817: hr_utility.trace('Assignment/Attendence : ' || l_assignment_id||'/'||l_abs_attendence_id);
1818: hr_utility.trace('Absence Start/End Date : ' || to_char(l_abs_start_date,'DDMonYYYY') || ' / ' ||
1819: to_char(l_abs_end_date,'DDMonYYYY'));
1820:
1821: OPEN csr_already_exists (l_assignment_id,l_abs_start_date);

Line 1818: hr_utility.trace('Absence Start/End Date : ' || to_char(l_abs_start_date,'DDMonYYYY') || ' / ' ||

1814: l_abs_attendence_id := v_csr_get_abs_details.abs_att_id;
1815: l_abs_start_date := v_csr_get_abs_details.start_date;
1816: l_abs_end_date := v_csr_get_abs_details.end_date;
1817: hr_utility.trace('Assignment/Attendence : ' || l_assignment_id||'/'||l_abs_attendence_id);
1818: hr_utility.trace('Absence Start/End Date : ' || to_char(l_abs_start_date,'DDMonYYYY') || ' / ' ||
1819: to_char(l_abs_end_date,'DDMonYYYY'));
1820:
1821: OPEN csr_already_exists (l_assignment_id,l_abs_start_date);
1822: FETCH csr_already_exists INTO l_exists;

Line 1825: -- hr_utility.trace('SR Exists? : '||l_exists);

1821: OPEN csr_already_exists (l_assignment_id,l_abs_start_date);
1822: FETCH csr_already_exists INTO l_exists;
1823: CLOSE csr_already_exists;
1824:
1825: -- hr_utility.trace('SR Exists? : '||l_exists);
1826:
1827: IF l_exists = 'Y' THEN
1828: fnd_file.put_line(fnd_file.log,'Sickness Report already sent. Hence skipped.');
1829: ELSIF l_exists = 'N' THEN

Line 2107: hr_utility.trace('Sickness Address Style : ' || l_sick_addr.style );

2103: FETCH csr_get_sick_addr into l_sick_addr;
2104: CLOSE csr_get_sick_addr;
2105:
2106:
2107: hr_utility.trace('Sickness Address Style : ' || l_sick_addr.style );
2108: IF l_sick_addr.style IS NOT NULL THEN
2109: /* Archiving sickness address */
2110: pay_action_information_api.create_action_information
2111: ( p_action_information_id => l_action_info_id

Line 2146: hr_utility.trace('Person Address Style : ' || l_person_addr.style);

2142: ELSE
2143: OPEN csr_get_person_addr(l_assignment_id, l_abs_start_date);
2144: FETCH csr_get_person_addr INTO l_person_addr;
2145: CLOSE csr_get_person_addr;
2146: hr_utility.trace('Person Address Style : ' || l_person_addr.style);
2147: IF l_person_addr.style IS NOT NULL THEN
2148:
2149: /* Archiving sickness address */
2150: pay_action_information_api.create_action_information

Line 2187: hr_utility.trace(l_type||' Assignment Action ID : '||p_assignment_action_id );

2183: END IF;
2184: END IF;
2185: END LOOP;
2186: ELSIF l_type IN ('W','R') THEN
2187: hr_utility.trace(l_type||' Assignment Action ID : '||p_assignment_action_id );
2188: OPEN c_get_assid_chunk (p_assignment_action_id);
2189: FETCH c_get_assid_chunk INTO l_assignment_id, l_chunk_number;
2190: CLOSE c_get_assid_chunk;
2191: hr_utility.trace('Assignment ID/Chunk : '||l_assignment_id||' / '||l_chunk_number);

Line 2191: hr_utility.trace('Assignment ID/Chunk : '||l_assignment_id||' / '||l_chunk_number);

2187: hr_utility.trace(l_type||' Assignment Action ID : '||p_assignment_action_id );
2188: OPEN c_get_assid_chunk (p_assignment_action_id);
2189: FETCH c_get_assid_chunk INTO l_assignment_id, l_chunk_number;
2190: CLOSE c_get_assid_chunk;
2191: hr_utility.trace('Assignment ID/Chunk : '||l_assignment_id||' / '||l_chunk_number);
2192:
2193: FOR r_get_archived_absence IN get_archived_absence(l_assignment_id, l_start_date, l_end_date, l_type)
2194: LOOP
2195:

Line 2196: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);

2192:
2193: FOR r_get_archived_absence IN get_archived_absence(l_assignment_id, l_start_date, l_end_date, l_type)
2194: LOOP
2195:
2196: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
2197:
2198: hr_utility.trace('Absence Start/End Date : ' ||
2199: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
2200: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));

Line 2198: hr_utility.trace('Absence Start/End Date : ' ||

2194: LOOP
2195:
2196: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
2197:
2198: hr_utility.trace('Absence Start/End Date : ' ||
2199: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
2200: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
2201: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
2202:

Line 2201: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);

2197:
2198: hr_utility.trace('Absence Start/End Date : ' ||
2199: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
2200: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
2201: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
2202:
2203: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id
2204: , lockedactid => r_get_archived_absence.org_asg_act_id);
2205: IF l_type = 'W' THEN

Line 2216: hr_utility.trace('X====archive_code==========================================X');

2212: END IF;
2213: END LOOP;
2214: END IF;
2215:
2216: hr_utility.trace('X====archive_code==========================================X');
2217: EXCEPTION
2218: WHEN TOO_MANY_ROWS THEN
2219: hr_utility.trace('Too Many Rows Exception in archive_code');
2220:

Line 2219: hr_utility.trace('Too Many Rows Exception in archive_code');

2215:
2216: hr_utility.trace('X====archive_code==========================================X');
2217: EXCEPTION
2218: WHEN TOO_MANY_ROWS THEN
2219: hr_utility.trace('Too Many Rows Exception in archive_code');
2220:
2221: WHEN NO_DATA_FOUND THEN
2222: hr_utility.trace('No Data Found Exception in archive_code');
2223:

Line 2222: hr_utility.trace('No Data Found Exception in archive_code');

2218: WHEN TOO_MANY_ROWS THEN
2219: hr_utility.trace('Too Many Rows Exception in archive_code');
2220:
2221: WHEN NO_DATA_FOUND THEN
2222: hr_utility.trace('No Data Found Exception in archive_code');
2223:
2224: WHEN others THEN
2225: hr_utility.trace('Exception in archive_code SQL-ERRM : '||SQLERRM);
2226:

Line 2225: hr_utility.trace('Exception in archive_code SQL-ERRM : '||SQLERRM);

2221: WHEN NO_DATA_FOUND THEN
2222: hr_utility.trace('No Data Found Exception in archive_code');
2223:
2224: WHEN others THEN
2225: hr_utility.trace('Exception in archive_code SQL-ERRM : '||SQLERRM);
2226:
2227: END archive_code;
2228: /**************************************************************************/
2229:

Line 2240: hr_utility.trace('+====deinitialization_code====X '|| p_actid);

2236:
2237:
2238: PROCEDURE deinitialization_code(p_actid IN NUMBER) IS
2239: BEGIN
2240: hr_utility.trace('+====deinitialization_code====X '|| p_actid);
2241: END deinitialization_code;
2242:
2243:
2244:

Line 2280: hr_utility.trace('+====gen_header_xml========================================+');

2276: FROM per_all_people_f
2277: WHERE person_id = p_person_id;
2278:
2279: BEGIN
2280: hr_utility.trace('+====gen_header_xml========================================+');
2281: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2282: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
2283: l_string := l_string || ''||EOL;
2284:

Line 2282: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);

2278:
2279: BEGIN
2280: hr_utility.trace('+====gen_header_xml========================================+');
2281: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2282: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
2283: l_string := l_string || ''||EOL;
2284:
2285: get_all_parameters (
2286: p_payroll_action_id => l_payroll_action_id

Line 2330: hr_utility.trace('X====gen_header_xml========================================X');

2326: IF l_clob IS NOT NULL THEN
2327: l_blob := c2b(l_clob);
2328: pay_core_files.write_to_magtape_lob(l_blob);
2329: END IF;
2330: hr_utility.trace('X====gen_header_xml========================================X');
2331: EXCEPTION
2332: WHEN others THEN
2333: hr_utility.trace('Exception in gen_header_xml SQL-ERRM : '||SQLERRM);
2334: END gen_header_xml;

Line 2333: hr_utility.trace('Exception in gen_header_xml SQL-ERRM : '||SQLERRM);

2329: END IF;
2330: hr_utility.trace('X====gen_header_xml========================================X');
2331: EXCEPTION
2332: WHEN others THEN
2333: hr_utility.trace('Exception in gen_header_xml SQL-ERRM : '||SQLERRM);
2334: END gen_header_xml;
2335:
2336:
2337: /**************************************************************************/

Line 2342: hr_utility.trace('+====gen_footer_xml========================================+');

2338: PROCEDURE gen_footer_xml
2339: IS
2340: l_buf VARCHAR2(32767);
2341: BEGIN
2342: hr_utility.trace('+====gen_footer_xml========================================+');
2343: l_buf := l_buf || ''||EOL ;
2344: pay_core_files.write_to_magtape_lob(l_buf);
2345: hr_utility.trace('X====gen_footer_xml========================================X');
2346: EXCEPTION

Line 2345: hr_utility.trace('X====gen_footer_xml========================================X');

2341: BEGIN
2342: hr_utility.trace('+====gen_footer_xml========================================+');
2343: l_buf := l_buf || ''||EOL ;
2344: pay_core_files.write_to_magtape_lob(l_buf);
2345: hr_utility.trace('X====gen_footer_xml========================================X');
2346: EXCEPTION
2347: WHEN others THEN
2348: hr_utility.trace('Exception in gen_footer_xml SQL-ERRM : '||SQLERRM);
2349: END gen_footer_xml;

Line 2348: hr_utility.trace('Exception in gen_footer_xml SQL-ERRM : '||SQLERRM);

2344: pay_core_files.write_to_magtape_lob(l_buf);
2345: hr_utility.trace('X====gen_footer_xml========================================X');
2346: EXCEPTION
2347: WHEN others THEN
2348: hr_utility.trace('Exception in gen_footer_xml SQL-ERRM : '||SQLERRM);
2349: END gen_footer_xml;
2350: /**************************************************************************/
2351:
2352:

Line 2592: hr_utility.trace('+====gen_body_xml_main=====================================+');

2588: END Tag;
2589:
2590:
2591: BEGIN
2592: hr_utility.trace('+====gen_body_xml_main=====================================+');
2593:
2594: OPEN cur_abs_info_details(p_id);
2595: FETCH cur_abs_info_details INTO l_abs_info;
2596: CLOSE cur_abs_info_details;

Line 2646: hr_utility.trace('Fetched all data. XML Generation starts');

2642: start_date(13), end_date(13),
2643: start_date(14), end_date(14);
2644: CLOSE cur_conn_abs_info_details;
2645: END IF;
2646: hr_utility.trace('Fetched all data. XML Generation starts');
2647:
2648: Tag(x,r,'UwvZwZiekteMelding','_START_','B'); -- sickness report*
2649: Tag(x,r,'IndTestbericht',l_abs_info.test_msg,'X'); -- test msg
2650: Tag(x,r,'KetenPartij','_START_','B'); -- + sender data*

Line 2960: hr_utility.trace('X====gen_body_xml_main=====================================X');

2956: write_file(xXMLTable, l_file_name);
2957:
2958: write_report(rXMLTable);
2959:
2960: hr_utility.trace('X====gen_body_xml_main=====================================X');
2961: EXCEPTION
2962: WHEN others THEN
2963: hr_utility.trace('Exception in gen_body_xml_main SQL-ERRM :'||SQLERRM);
2964: END gen_body_xml_main;

Line 2963: hr_utility.trace('Exception in gen_body_xml_main SQL-ERRM :'||SQLERRM);

2959:
2960: hr_utility.trace('X====gen_body_xml_main=====================================X');
2961: EXCEPTION
2962: WHEN others THEN
2963: hr_utility.trace('Exception in gen_body_xml_main SQL-ERRM :'||SQLERRM);
2964: END gen_body_xml_main;
2965:
2966: /**************************************************************************/
2967:

Line 3000: hr_utility.trace('+====gen_body_xml==========================================+');

2996: AND paa.assignment_action_id = c_assignment_action_id;
2997: /**************************************************************************/
2998:
2999: BEGIN
3000: hr_utility.trace('+====gen_body_xml==========================================+');
3001:
3002: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
3003: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);
3004:

Line 3003: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);

2999: BEGIN
3000: hr_utility.trace('+====gen_body_xml==========================================+');
3001:
3002: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
3003: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);
3004:
3005: l_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
3006: hr_utility.trace('TRANSFER_ACT_ID = '||l_asg_action_id);
3007:

Line 3006: hr_utility.trace('TRANSFER_ACT_ID = '||l_asg_action_id);

3002: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
3003: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);
3004:
3005: l_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
3006: hr_utility.trace('TRANSFER_ACT_ID = '||l_asg_action_id);
3007:
3008: OPEN get_pact_id(l_asg_action_id);
3009: FETCH get_pact_id INTO l_payroll_action_id;
3010: CLOSE get_pact_id;

Line 3012: hr_utility.trace('l_payroll_action_id = '||l_payroll_action_id);

3008: OPEN get_pact_id(l_asg_action_id);
3009: FETCH get_pact_id INTO l_payroll_action_id;
3010: CLOSE get_pact_id;
3011:
3012: hr_utility.trace('l_payroll_action_id = '||l_payroll_action_id);
3013: get_all_parameters (
3014: p_payroll_action_id => l_payroll_action_id
3015: ,p_org_struct_id => l_org_struct_id
3016: ,p_person_id => l_person_id

Line 3024: hr_utility.trace('Initial Report');

3020: ,p_end_date => l_end_date
3021: ,p_type => l_type);
3022:
3023: IF l_type = 'I' THEN
3024: hr_utility.trace('Initial Report');
3025: FOR v_child_act_id IN cur_get_child_act_id(l_asg_action_id)
3026: LOOP
3027: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);
3028: gen_body_xml_main(l_type, v_child_act_id.ass_act_id);

Line 3027: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);

3023: IF l_type = 'I' THEN
3024: hr_utility.trace('Initial Report');
3025: FOR v_child_act_id IN cur_get_child_act_id(l_asg_action_id)
3026: LOOP
3027: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);
3028: gen_body_xml_main(l_type, v_child_act_id.ass_act_id);
3029: END LOOP;
3030: ELSIF l_type IN ('W','R') THEN
3031: hr_utility.trace('Withdrawal/Regeneration Report');

Line 3031: hr_utility.trace('Withdrawal/Regeneration Report');

3027: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);
3028: gen_body_xml_main(l_type, v_child_act_id.ass_act_id);
3029: END LOOP;
3030: ELSIF l_type IN ('W','R') THEN
3031: hr_utility.trace('Withdrawal/Regeneration Report');
3032: FOR v_parent_asg_ids in get_parent_asg_ids(l_asg_action_id)
3033: LOOP
3034: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);
3035: gen_body_xml_main(l_type, v_parent_asg_ids.parent_id);

Line 3034: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);

3030: ELSIF l_type IN ('W','R') THEN
3031: hr_utility.trace('Withdrawal/Regeneration Report');
3032: FOR v_parent_asg_ids in get_parent_asg_ids(l_asg_action_id)
3033: LOOP
3034: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);
3035: gen_body_xml_main(l_type, v_parent_asg_ids.parent_id);
3036: END LOOP;
3037: END IF;
3038: hr_utility.trace('X====gen_body_xml==========================================X');

Line 3038: hr_utility.trace('X====gen_body_xml==========================================X');

3034: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);
3035: gen_body_xml_main(l_type, v_parent_asg_ids.parent_id);
3036: END LOOP;
3037: END IF;
3038: hr_utility.trace('X====gen_body_xml==========================================X');
3039: EXCEPTION
3040: WHEN others THEN
3041: hr_utility.trace('Exception in gen_body_xml SQL-ERRM :'||SQLERRM);
3042: END gen_body_xml;

Line 3041: hr_utility.trace('Exception in gen_body_xml SQL-ERRM :'||SQLERRM);

3037: END IF;
3038: hr_utility.trace('X====gen_body_xml==========================================X');
3039: EXCEPTION
3040: WHEN others THEN
3041: hr_utility.trace('Exception in gen_body_xml SQL-ERRM :'||SQLERRM);
3042: END gen_body_xml;
3043:
3044: END PER_NL_DSR_ARCHIVE;
3045: