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_WAZO_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 304: hr_utility.trace('Exception in get_all_parameters SQLERRM: '||SQLERRM);

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

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

420: l_start_date DATE;
421: l_end_date DATE;
422:
423: BEGIN
424: hr_utility.trace('+====emp_check============================================+');
425: IF p_org_id is not NULL THEN
426: BEGIN
427: OPEN csr_org_check(p_bg_id
428: ,p_org_struct_id

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

438: l_return_val := 1;
439: WHEN NO_DATA_FOUND THEN
440: null;
441: WHEN OTHERS THEN
442: hr_utility.trace('Exception in emp_check org. SQLERRM : '||SQLERRM);
443: END;
444: hr_utility.trace('l_return_val : '||l_return_val);
445: ELSIF p_org_struct_id is not NULL THEN
446: BEGIN

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

440: null;
441: WHEN OTHERS THEN
442: hr_utility.trace('Exception in emp_check org. SQLERRM : '||SQLERRM);
443: END;
444: hr_utility.trace('l_return_val : '||l_return_val);
445: ELSIF p_org_struct_id is not NULL THEN
446: BEGIN
447: OPEN csr_org_struct_check(p_bg_id
448: ,p_org_struct_id

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

457: l_return_val := 1;
458: WHEN NO_DATA_FOUND THEN
459: NULL;
460: WHEN OTHERS THEN
461: hr_utility.trace('Exception in emp_check org_struct. SQLERRM : '||SQLERRM);
462: END;
463: hr_utility.trace('l_return_val : '||l_return_val);
464: END IF;
465: hr_utility.trace('X====emp_check============================================X');

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

459: NULL;
460: WHEN OTHERS THEN
461: hr_utility.trace('Exception in emp_check org_struct. SQLERRM : '||SQLERRM);
462: END;
463: hr_utility.trace('l_return_val : '||l_return_val);
464: END IF;
465: hr_utility.trace('X====emp_check============================================X');
466: RETURN l_return_val;
467: EXCEPTION

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

461: hr_utility.trace('Exception in emp_check org_struct. SQLERRM : '||SQLERRM);
462: END;
463: hr_utility.trace('l_return_val : '||l_return_val);
464: END IF;
465: hr_utility.trace('X====emp_check============================================X');
466: RETURN l_return_val;
467: EXCEPTION
468: WHEN OTHERS THEN
469: hr_utility.trace('Exception in emp_check SQL-ERRM : '||SQLERRM);

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

465: hr_utility.trace('X====emp_check============================================X');
466: RETURN l_return_val;
467: EXCEPTION
468: WHEN OTHERS THEN
469: hr_utility.trace('Exception in emp_check SQL-ERRM : '||SQLERRM);
470: END emp_check;
471: /**************************************************************************/
472:
473:

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

594: l_start_date DATE;
595: l_end_date DATE;
596:
597: BEGIN
598: --hr_utility.trace('+====org_check=============================================+');
599: IF p_org_struct_id is NULL THEN
600: BEGIN
601: OPEN csr_org_struct_check (p_bg_id,p_org_id);
602: FETCH csr_org_struct_check INTO l_return_val;

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

607: l_return_val := 1;
608: WHEN NO_DATA_FOUND THEN
609: NULL;
610: WHEN OTHERS THEN
611: hr_utility.trace('Exception in org_check org_struct. SQLERRM : '||SQLERRM);
612: END;
613: hr_utility.trace('l_return_val : '||l_return_val);
614: ELSE
615: BEGIN

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

609: NULL;
610: WHEN OTHERS THEN
611: hr_utility.trace('Exception in org_check org_struct. SQLERRM : '||SQLERRM);
612: END;
613: hr_utility.trace('l_return_val : '||l_return_val);
614: ELSE
615: BEGIN
616: OPEN csr_org_check (p_bg_id,p_org_id,p_org_struct_id,p_start_date,p_end_date);
617: FETCH csr_org_check INTO l_return_val;

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

622: l_return_val := 1;
623: WHEN NO_DATA_FOUND THEN
624: NULL;
625: WHEN OTHERS THEN
626: hr_utility.trace('Exception in org_check org_struct1. SQLERRM : '||SQLERRM);
627: END;
628: hr_utility.trace('l_return_val : '||l_return_val);
629: END IF;
630: RETURN l_return_val;

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

624: NULL;
625: WHEN OTHERS THEN
626: hr_utility.trace('Exception in org_check org_struct1. SQLERRM : '||SQLERRM);
627: END;
628: hr_utility.trace('l_return_val : '||l_return_val);
629: END IF;
630: RETURN l_return_val;
631: --hr_utility.trace('X====org_check=============================================X');
632: EXCEPTION

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

627: END;
628: hr_utility.trace('l_return_val : '||l_return_val);
629: END IF;
630: RETURN l_return_val;
631: --hr_utility.trace('X====org_check=============================================X');
632: EXCEPTION
633: WHEN OTHERS THEN
634: hr_utility.trace('Exception in org_check SQL-ERRM : '||SQLERRM);
635: END org_check;

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

630: RETURN l_return_val;
631: --hr_utility.trace('X====org_check=============================================X');
632: EXCEPTION
633: WHEN OTHERS THEN
634: hr_utility.trace('Exception in org_check SQL-ERRM : '||SQLERRM);
635: END org_check;
636: /**************************************************************************/
637:
638: /*--------------------------------------------------------------------

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

645:
646: PROCEDURE range_code (pactid IN NUMBER
647: ,sqlstr OUT NOCOPY VARCHAR2) is
648: BEGIN
649: hr_utility.trace('+====range_code============================================+');
650: sqlstr := 'SELECT DISTINCT person_id
651: FROM per_all_people_f pap
652: ,pay_payroll_actions ppa
653: WHERE ppa.payroll_action_id = :payroll_action_id

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

652: ,pay_payroll_actions ppa
653: WHERE ppa.payroll_action_id = :payroll_action_id
654: AND ppa.business_group_id = pap.business_group_id
655: ORDER BY pap.person_id';
656: hr_utility.trace('X====range_code============================================X');
657: EXCEPTION
658: WHEN OTHERS THEN
659: -- Return cursor that selects no rows
660: hr_utility.trace('Exception in range_code SQL-ERRM : '||SQLERRM);

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

656: hr_utility.trace('X====range_code============================================X');
657: EXCEPTION
658: WHEN OTHERS THEN
659: -- Return cursor that selects no rows
660: hr_utility.trace('Exception in range_code SQL-ERRM : '||SQLERRM);
661: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
662: END range_code;
663:
664: /**************************************************************************/

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

703: l_bg_id NUMBER;
704: l_start_date DATE;
705:
706: BEGIN
707: hr_utility.trace('+====initialization_code===================================+');
708: IF Instr ('a', COMPOSE('a'|| UNISTR('\0301')) ) = 0 THEN
709: OPEN c_bg_stdate(p_action_context_id);
710: FETCH c_bg_stdate INTO l_bg_id,l_start_date;
711: CLOSE c_bg_stdate;

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

719: g_SOURCE := g_SOURCE||upper(I.Source)||lower(I.Source);
720: g_TARGET := g_TARGET||upper(I.Target)||lower(I.Target);
721: END LOOP;
722:
723: hr_utility.trace('g_SOURCE : '||g_SOURCE);
724: hr_utility.trace('g_TARGET : '||g_TARGET);
725: END IF;
726: hr_utility.trace('X====initialization_code===================================X');
727: EXCEPTION

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

720: g_TARGET := g_TARGET||upper(I.Target)||lower(I.Target);
721: END LOOP;
722:
723: hr_utility.trace('g_SOURCE : '||g_SOURCE);
724: hr_utility.trace('g_TARGET : '||g_TARGET);
725: END IF;
726: hr_utility.trace('X====initialization_code===================================X');
727: EXCEPTION
728: WHEN OTHERS THEN

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

722:
723: hr_utility.trace('g_SOURCE : '||g_SOURCE);
724: hr_utility.trace('g_TARGET : '||g_TARGET);
725: END IF;
726: hr_utility.trace('X====initialization_code===================================X');
727: EXCEPTION
728: WHEN OTHERS THEN
729: hr_utility.trace('Exception in init_code SQL-ERRM : '||SQLERRM);
730: END initialization_code;

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

725: END IF;
726: hr_utility.trace('X====initialization_code===================================X');
727: EXCEPTION
728: WHEN OTHERS THEN
729: hr_utility.trace('Exception in init_code SQL-ERRM : '||SQLERRM);
730: END initialization_code;
731: /**************************************************************************/
732: /*--------------------------------------------------------------------
733: |Name : ASSIGNMENT_ACTION_CODE |

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

1062: ,pactid => p_pactid
1063: ,chunk => p_chunk);
1064: EXCEPTION
1065: WHEN others THEN
1066: hr_utility.trace('Exception in ins_assg_act SQL-ERRM : '||SQLERRM);
1067: END ins_assg_act;
1068: /**************************************************************************/
1069:
1070:

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

1068: /**************************************************************************/
1069:
1070:
1071: BEGIN
1072: hr_utility.trace('+====assignment_action_code================================+');
1073: hr_utility.trace('Payroll_action_id/Chunk: '||p_payroll_action_id||' / '||p_chunk );
1074: hr_utility.trace('Start/End Person ID : '||p_start_person_id||' / '||p_end_person_id );
1075:
1076: get_all_parameters (

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

1069:
1070:
1071: BEGIN
1072: hr_utility.trace('+====assignment_action_code================================+');
1073: hr_utility.trace('Payroll_action_id/Chunk: '||p_payroll_action_id||' / '||p_chunk );
1074: hr_utility.trace('Start/End Person ID : '||p_start_person_id||' / '||p_end_person_id );
1075:
1076: get_all_parameters (
1077: p_payroll_action_id => p_payroll_action_id

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

1070:
1071: BEGIN
1072: hr_utility.trace('+====assignment_action_code================================+');
1073: hr_utility.trace('Payroll_action_id/Chunk: '||p_payroll_action_id||' / '||p_chunk );
1074: hr_utility.trace('Start/End Person ID : '||p_start_person_id||' / '||p_end_person_id );
1075:
1076: get_all_parameters (
1077: p_payroll_action_id => p_payroll_action_id
1078: ,p_org_struct_id => l_org_struct_id

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

1084: ,p_type => l_type);
1085:
1086:
1087: IF l_person_id is not NULL THEN
1088: hr_utility.trace(l_type||' Person selected ' ||l_person_id||' '||p_start_person_id||' '||p_end_person_id);
1089: IF l_type = 'I' THEN
1090: FOR v_csr_get_asg_person IN
1091: csr_get_asg_person(l_person_id, p_start_person_id, p_end_person_id
1092: , p_payroll_action_id, l_start_date, l_end_date)

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

1102: END LOOP;
1103: END IF;
1104: -----------------------------------------------
1105: ELSIF l_org_id is not NULL THEN
1106: hr_utility.trace(l_type||' Org selected ' ||l_org_id);
1107: IF l_type = 'I' THEN
1108: FOR v_csr_get_asg_org IN
1109: csr_get_asg_org(l_org_id, l_org_struct_id
1110: , p_start_person_id, p_end_person_id, p_payroll_action_id

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

1122: END LOOP;
1123: END IF;
1124: -----------------------------------------------
1125: ELSIF l_org_struct_id is not NULL THEN
1126: hr_utility.trace(l_type||' Hierarchy selected ' ||l_org_struct_id);
1127: IF l_type = 'I' THEN
1128: FOR v_csr_get_asg_hier IN
1129: csr_get_asg_hier(l_org_struct_id, p_start_person_id, p_end_person_id
1130: , p_payroll_action_id, l_start_date, l_end_date)

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

1139: ins_assg_act(v_csr_get_asg_hier.assignment_id,p_payroll_action_id,p_chunk);
1140: END LOOP;
1141: END IF;
1142: END IF;
1143: hr_utility.trace('X====assignment_action_code================================X');
1144: EXCEPTION
1145: WHEN others THEN
1146: hr_utility.trace('Exception in assignment_action_code SQL-ERRM : '||SQLERRM);
1147: END assignment_action_code;

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

1142: END IF;
1143: hr_utility.trace('X====assignment_action_code================================X');
1144: EXCEPTION
1145: WHEN others THEN
1146: hr_utility.trace('Exception in assignment_action_code SQL-ERRM : '||SQLERRM);
1147: END assignment_action_code;
1148:
1149:
1150:

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

1539: l_numiv_override per_assignment_extra_info.aei_information1%TYPE;
1540:
1541: /**************************************************************************/
1542: BEGIN
1543: hr_utility.trace('+====archive_code==========================================+');
1544: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1545: hr_utility.trace('p_effective_date : '||p_effective_date);
1546:
1547: OPEN c_get_pact_chunk (p_assignment_action_id);

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

1540:
1541: /**************************************************************************/
1542: BEGIN
1543: hr_utility.trace('+====archive_code==========================================+');
1544: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1545: hr_utility.trace('p_effective_date : '||p_effective_date);
1546:
1547: OPEN c_get_pact_chunk (p_assignment_action_id);
1548: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;

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

1541: /**************************************************************************/
1542: BEGIN
1543: hr_utility.trace('+====archive_code==========================================+');
1544: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1545: hr_utility.trace('p_effective_date : '||p_effective_date);
1546:
1547: OPEN c_get_pact_chunk (p_assignment_action_id);
1548: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
1549: CLOSE c_get_pact_chunk;

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

1547: OPEN c_get_pact_chunk (p_assignment_action_id);
1548: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
1549: CLOSE c_get_pact_chunk;
1550:
1551: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1552: hr_utility.trace('l_chunk_number : '||l_chunk_number);
1553:
1554: get_all_parameters (
1555: p_payroll_action_id => l_payroll_action_id

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

1548: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
1549: CLOSE c_get_pact_chunk;
1550:
1551: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1552: hr_utility.trace('l_chunk_number : '||l_chunk_number);
1553:
1554: get_all_parameters (
1555: p_payroll_action_id => l_payroll_action_id
1556: ,p_org_struct_id => l_org_struct_id

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

1568: l_assignment_id := v_csr_get_abs_details.assignment_id;
1569: l_abs_attendence_id := v_csr_get_abs_details.abs_att_id;
1570: l_abs_start_date := v_csr_get_abs_details.start_date;
1571: l_abs_end_date := v_csr_get_abs_details.end_date;
1572: hr_utility.trace('Assignment/Attendence : ' || l_assignment_id||'/'||l_abs_attendence_id);
1573: hr_utility.trace('Absence Start/End Date : ' || to_char(l_abs_start_date,'DDMonYYYY') || ' / ' ||
1574: to_char(l_abs_end_date,'DDMonYYYY'));
1575:
1576: OPEN csr_already_exists (l_assignment_id,l_abs_start_date);

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

1569: l_abs_attendence_id := v_csr_get_abs_details.abs_att_id;
1570: l_abs_start_date := v_csr_get_abs_details.start_date;
1571: l_abs_end_date := v_csr_get_abs_details.end_date;
1572: hr_utility.trace('Assignment/Attendence : ' || l_assignment_id||'/'||l_abs_attendence_id);
1573: hr_utility.trace('Absence Start/End Date : ' || to_char(l_abs_start_date,'DDMonYYYY') || ' / ' ||
1574: to_char(l_abs_end_date,'DDMonYYYY'));
1575:
1576: OPEN csr_already_exists (l_assignment_id,l_abs_start_date);
1577: FETCH csr_already_exists INTO l_exists;

Line 1579: -- hr_utility.trace('l_exists : '||l_exists);

1575:
1576: OPEN csr_already_exists (l_assignment_id,l_abs_start_date);
1577: FETCH csr_already_exists INTO l_exists;
1578: CLOSE csr_already_exists;
1579: -- hr_utility.trace('l_exists : '||l_exists);
1580: IF l_exists = 'Y' THEN
1581: fnd_file.put_line(fnd_file.log,'WAZO Report already sent. Hence skipped.');
1582: ELSIF l_exists = 'N' THEN
1583:

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

1735: FETCH csr_get_sick_addr into l_sick_addr;
1736: CLOSE csr_get_sick_addr;
1737:
1738:
1739: hr_utility.trace('Sickness Address Style : ' || l_sick_addr.style);
1740: IF l_sick_addr.style IS NOT NULL THEN
1741: /* Archiving sickness address */
1742: pay_action_information_api.create_action_information
1743: ( p_action_information_id => l_action_info_id

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

1775: OPEN csr_get_person_addr(l_assignment_id, l_abs_start_date);
1776: FETCH csr_get_person_addr INTO l_person_addr;
1777: CLOSE csr_get_person_addr;
1778: IF l_person_addr.style IS NOT NULL THEN
1779: hr_utility.trace('Person Address Style : ' || l_person_addr.style);
1780:
1781: /* Archieving sickness address */
1782: pay_action_information_api.create_action_information
1783: (

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

1815: END IF;
1816: END IF;
1817: END LOOP;
1818: ELSIF l_type IN ('W','R') THEN
1819: hr_utility.trace(l_type||' Assignment Action ID : '||p_assignment_action_id );
1820: OPEN c_get_assid_chunk (p_assignment_action_id);
1821: FETCH c_get_assid_chunk INTO l_assignment_id, l_chunk_number;
1822: CLOSE c_get_assid_chunk;
1823: hr_utility.trace('Assignment ID/Chunk : '||l_assignment_id||' / '||l_chunk_number);

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

1819: hr_utility.trace(l_type||' Assignment Action ID : '||p_assignment_action_id );
1820: OPEN c_get_assid_chunk (p_assignment_action_id);
1821: FETCH c_get_assid_chunk INTO l_assignment_id, l_chunk_number;
1822: CLOSE c_get_assid_chunk;
1823: hr_utility.trace('Assignment ID/Chunk : '||l_assignment_id||' / '||l_chunk_number);
1824:
1825: FOR r_get_archived_absence IN get_archived_absence(l_assignment_id, l_start_date, l_end_date, l_type)
1826: LOOP
1827:

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

1824:
1825: FOR r_get_archived_absence IN get_archived_absence(l_assignment_id, l_start_date, l_end_date, l_type)
1826: LOOP
1827:
1828: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1829:
1830: hr_utility.trace('Absence Start/End Date : ' ||
1831: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1832: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));

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

1826: LOOP
1827:
1828: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1829:
1830: hr_utility.trace('Absence Start/End Date : ' ||
1831: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1832: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1833: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1834:

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

1829:
1830: hr_utility.trace('Absence Start/End Date : ' ||
1831: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1832: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1833: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1834:
1835: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id
1836: , lockedactid => r_get_archived_absence.org_asg_act_id);
1837: IF l_type = 'W' THEN

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

1844: END IF;
1845: END LOOP;
1846: END IF;
1847:
1848: hr_utility.trace('X====archive_code==========================================X');
1849: EXCEPTION
1850: WHEN TOO_MANY_ROWS THEN
1851: hr_utility.trace('Too Many Rows Exception in archive_code');
1852:

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

1847:
1848: hr_utility.trace('X====archive_code==========================================X');
1849: EXCEPTION
1850: WHEN TOO_MANY_ROWS THEN
1851: hr_utility.trace('Too Many Rows Exception in archive_code');
1852:
1853: WHEN NO_DATA_FOUND THEN
1854: hr_utility.trace('No Data Found Exception in archive_code');
1855:

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

1850: WHEN TOO_MANY_ROWS THEN
1851: hr_utility.trace('Too Many Rows Exception in archive_code');
1852:
1853: WHEN NO_DATA_FOUND THEN
1854: hr_utility.trace('No Data Found Exception in archive_code');
1855:
1856: WHEN others THEN
1857: hr_utility.trace('Exception in archive_code SQL-ERRM : '||SQLERRM);
1858:

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

1853: WHEN NO_DATA_FOUND THEN
1854: hr_utility.trace('No Data Found Exception in archive_code');
1855:
1856: WHEN others THEN
1857: hr_utility.trace('Exception in archive_code SQL-ERRM : '||SQLERRM);
1858:
1859: END archive_code;
1860: /**************************************************************************/
1861:

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

1869:
1870:
1871: PROCEDURE deinitialization_code(p_actid IN NUMBER) IS
1872: BEGIN
1873: hr_utility.trace('+====deinitialization_code====X '|| p_actid);
1874: END deinitialization_code;
1875:
1876:
1877:

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

1910: FROM per_all_people_f
1911: WHERE person_id = p_person_id;
1912:
1913: BEGIN
1914: hr_utility.trace('+====gen_header_xml========================================+');
1915: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1916: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1917: l_string := l_string || ''||EOL;
1918:

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

1912:
1913: BEGIN
1914: hr_utility.trace('+====gen_header_xml========================================+');
1915: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1916: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1917: l_string := l_string || ''||EOL;
1918:
1919: get_all_parameters (
1920: p_payroll_action_id => l_payroll_action_id

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

1960: IF l_clob IS NOT NULL THEN
1961: l_blob := c2b(l_clob);
1962: pay_core_files.write_to_magtape_lob(l_blob);
1963: END IF;
1964: hr_utility.trace('X====gen_header_xml========================================X');
1965: EXCEPTION
1966: WHEN others THEN
1967: hr_utility.trace('Exception in gen_header_xml SQL-ERRM : '||SQLERRM);
1968: END gen_header_xml;

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

1963: END IF;
1964: hr_utility.trace('X====gen_header_xml========================================X');
1965: EXCEPTION
1966: WHEN others THEN
1967: hr_utility.trace('Exception in gen_header_xml SQL-ERRM : '||SQLERRM);
1968: END gen_header_xml;
1969:
1970:
1971: /**************************************************************************/

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

1972: PROCEDURE gen_footer_xml
1973: IS
1974: l_buf VARCHAR2(32767);
1975: BEGIN
1976: hr_utility.trace('+====gen_footer_xml========================================+');
1977: l_buf := l_buf || ''||EOL ;
1978: pay_core_files.write_to_magtape_lob(l_buf);
1979: hr_utility.trace('X====gen_footer_xml========================================X');
1980: EXCEPTION

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

1975: BEGIN
1976: hr_utility.trace('+====gen_footer_xml========================================+');
1977: l_buf := l_buf || ''||EOL ;
1978: pay_core_files.write_to_magtape_lob(l_buf);
1979: hr_utility.trace('X====gen_footer_xml========================================X');
1980: EXCEPTION
1981: WHEN others THEN
1982: hr_utility.trace('Exception in gen_footer_xml SQL-ERRM : '||SQLERRM);
1983: END gen_footer_xml;

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

1978: pay_core_files.write_to_magtape_lob(l_buf);
1979: hr_utility.trace('X====gen_footer_xml========================================X');
1980: EXCEPTION
1981: WHEN others THEN
1982: hr_utility.trace('Exception in gen_footer_xml SQL-ERRM : '||SQLERRM);
1983: END gen_footer_xml;
1984: /**************************************************************************/
1985:
1986:

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

2147: END Tag;
2148:
2149:
2150: BEGIN
2151: hr_utility.trace('+====gen_body_xml_main=====================================+');
2152:
2153: OPEN cur_abs_info_details(p_id);
2154: FETCH cur_abs_info_details INTO l_abs_info;
2155: CLOSE cur_abs_info_details;

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

2176: OPEN cur_withdrawl_flag(p_id);
2177: FETCH cur_withdrawl_flag into l_withdrawl_flag;
2178: CLOSE cur_withdrawl_flag;
2179: END IF;
2180: hr_utility.trace('Fetched all data. XML Generation starts');
2181:
2182: Tag(x,r,'UwvZwWazoMelding','_START_','B'); -- wazo report*
2183: Tag(x,r,'IndTestbericht',l_emp_details.test_msg,'X'); -- test msg
2184: Tag(x,r,'KetenPartij','_START_','B'); -- + sender data*

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

2360: write_file(xXMLTable, l_file_name);
2361:
2362: write_report(rXMLTable);
2363:
2364: hr_utility.trace('X====gen_body_xml_main=====================================X');
2365: EXCEPTION
2366: WHEN others THEN
2367: hr_utility.trace('Exception in gen_body_xml_main SQL-ERRM :'||SQLERRM);
2368: END gen_body_xml_main;

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

2363:
2364: hr_utility.trace('X====gen_body_xml_main=====================================X');
2365: EXCEPTION
2366: WHEN others THEN
2367: hr_utility.trace('Exception in gen_body_xml_main SQL-ERRM :'||SQLERRM);
2368: END gen_body_xml_main;
2369:
2370: /**************************************************************************/
2371:

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

2400: AND paa.assignment_action_id = c_assignment_action_id;
2401: /**************************************************************************/
2402:
2403: BEGIN
2404: hr_utility.trace('+====gen_body_xml==========================================+');
2405:
2406: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2407: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);
2408:

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

2403: BEGIN
2404: hr_utility.trace('+====gen_body_xml==========================================+');
2405:
2406: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2407: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);
2408:
2409: l_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
2410: hr_utility.trace('TRANSFER_ACT_ID = '||l_asg_action_id);
2411:

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

2406: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2407: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);
2408:
2409: l_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
2410: hr_utility.trace('TRANSFER_ACT_ID = '||l_asg_action_id);
2411:
2412: OPEN get_pact_id(l_asg_action_id);
2413: FETCH get_pact_id INTO l_payroll_action_id;
2414: CLOSE get_pact_id;

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

2412: OPEN get_pact_id(l_asg_action_id);
2413: FETCH get_pact_id INTO l_payroll_action_id;
2414: CLOSE get_pact_id;
2415:
2416: hr_utility.trace('l_payroll_action_id = '||l_payroll_action_id);
2417: get_all_parameters (
2418: p_payroll_action_id => l_payroll_action_id
2419: ,p_org_struct_id => l_org_struct_id
2420: ,p_person_id => l_person_id

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

2424: ,p_end_date => l_end_date
2425: ,p_type => l_type);
2426:
2427: IF l_type = 'I' THEN
2428: hr_utility.trace('Initial Report');
2429: FOR v_child_act_id IN cur_get_child_act_id(l_asg_action_id)
2430: LOOP
2431: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);
2432: gen_body_xml_main(l_type, v_child_act_id.ass_act_id);

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

2427: IF l_type = 'I' THEN
2428: hr_utility.trace('Initial Report');
2429: FOR v_child_act_id IN cur_get_child_act_id(l_asg_action_id)
2430: LOOP
2431: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);
2432: gen_body_xml_main(l_type, v_child_act_id.ass_act_id);
2433: END LOOP;
2434: ELSIF l_type IN ('W','R') THEN
2435: hr_utility.trace('Withdrawal/Regeneration Report');

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

2431: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);
2432: gen_body_xml_main(l_type, v_child_act_id.ass_act_id);
2433: END LOOP;
2434: ELSIF l_type IN ('W','R') THEN
2435: hr_utility.trace('Withdrawal/Regeneration Report');
2436: FOR v_parent_asg_ids in get_parent_asg_ids(l_asg_action_id)
2437: LOOP
2438: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);
2439: gen_body_xml_main(l_type, v_parent_asg_ids.parent_id);

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

2434: ELSIF l_type IN ('W','R') THEN
2435: hr_utility.trace('Withdrawal/Regeneration Report');
2436: FOR v_parent_asg_ids in get_parent_asg_ids(l_asg_action_id)
2437: LOOP
2438: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);
2439: gen_body_xml_main(l_type, v_parent_asg_ids.parent_id);
2440: END LOOP;
2441: END IF;
2442: hr_utility.trace('X====gen_body_xml==========================================X');

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

2438: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);
2439: gen_body_xml_main(l_type, v_parent_asg_ids.parent_id);
2440: END LOOP;
2441: END IF;
2442: hr_utility.trace('X====gen_body_xml==========================================X');
2443: EXCEPTION
2444: WHEN others THEN
2445: hr_utility.trace('Exception in gen_body_xml SQL-ERRM :'||SQLERRM);
2446: END gen_body_xml;

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

2441: END IF;
2442: hr_utility.trace('X====gen_body_xml==========================================X');
2443: EXCEPTION
2444: WHEN others THEN
2445: hr_utility.trace('Exception in gen_body_xml SQL-ERRM :'||SQLERRM);
2446: END gen_body_xml;
2447:
2448: END PER_NL_WAZO_ARCHIVE;
2449: