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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 128: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 175: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1068: ,pactid => p_pactid
1069: ,chunk => p_chunk);
1070: EXCEPTION
1071: WHEN others THEN
1072: hr_utility.trace('Exception in ins_assg_act SQL-ERRM : '||SQLERRM);
1073: END ins_assg_act;
1074: /**************************************************************************/
1075:
1076: BEGIN

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

1074: /**************************************************************************/
1075:
1076: BEGIN
1077:
1078: hr_utility.trace('+====assignment_action_code================================+');
1079: hr_utility.trace('Payroll_action_id/Chunk: '||p_payroll_action_id||' / '||p_chunk );
1080: hr_utility.trace('Start/End Person ID : '||p_start_person_id||' / '||p_end_person_id );
1081:
1082: get_all_parameters (

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

1075:
1076: BEGIN
1077:
1078: hr_utility.trace('+====assignment_action_code================================+');
1079: hr_utility.trace('Payroll_action_id/Chunk: '||p_payroll_action_id||' / '||p_chunk );
1080: hr_utility.trace('Start/End Person ID : '||p_start_person_id||' / '||p_end_person_id );
1081:
1082: get_all_parameters (
1083: p_payroll_action_id => p_payroll_action_id

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

1076: BEGIN
1077:
1078: hr_utility.trace('+====assignment_action_code================================+');
1079: hr_utility.trace('Payroll_action_id/Chunk: '||p_payroll_action_id||' / '||p_chunk );
1080: hr_utility.trace('Start/End Person ID : '||p_start_person_id||' / '||p_end_person_id );
1081:
1082: get_all_parameters (
1083: p_payroll_action_id => p_payroll_action_id
1084: ,p_org_struct_id => l_org_struct_id

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

1089: ,p_end_date => l_end_date
1090: ,p_type => l_type);
1091:
1092: IF l_person_id is not NULL THEN
1093: hr_utility.trace(l_type||' Person selected ' ||l_person_id||' '||p_start_person_id||' '||p_end_person_id);
1094: IF l_type = 'I' THEN
1095: FOR v_csr_get_asg_person IN
1096: csr_get_asg_person(l_person_id, p_start_person_id, p_end_person_id
1097: , p_payroll_action_id, l_start_date, l_end_date)

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

1107: END LOOP;
1108: END IF;
1109: -----------------------------------------------
1110: ELSIF l_org_id is not NULL THEN
1111: hr_utility.trace(l_type||' Org selected ' ||l_org_id);
1112: IF l_type = 'I' THEN
1113: FOR v_csr_get_asg_org IN
1114: csr_get_asg_org(l_org_id, l_org_struct_id
1115: , p_start_person_id, p_end_person_id, p_payroll_action_id

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

1127: END LOOP;
1128: END IF;
1129: -----------------------------------------------
1130: ELSIF l_org_struct_id is not NULL THEN
1131: hr_utility.trace(l_type||' Hierarchy selected ' ||l_org_struct_id);
1132: IF l_type = 'I' THEN
1133: FOR v_csr_get_asg_hier IN
1134: csr_get_asg_hier(l_org_struct_id, p_start_person_id, p_end_person_id
1135: , p_payroll_action_id, l_start_date, l_end_date)

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

1146: END IF;
1147: END IF;
1148:
1149:
1150: hr_utility.trace('X====assignment_action_code================================X');
1151: EXCEPTION
1152: WHEN others THEN
1153: hr_utility.trace('Exception in assignment_action_code SQL-ERRM : '||SQLERRM);
1154: END assignment_action_code;

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

1149:
1150: hr_utility.trace('X====assignment_action_code================================X');
1151: EXCEPTION
1152: WHEN others THEN
1153: hr_utility.trace('Exception in assignment_action_code SQL-ERRM : '||SQLERRM);
1154: END assignment_action_code;
1155: /**************************************************************************/
1156:
1157: /*-------------------------------------------------------------------------------

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

1428:
1429:
1430: /**************************************************************************/
1431: BEGIN
1432: hr_utility.trace('+====archive_code==========================================+');
1433: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1434: hr_utility.trace('p_effective_date : '||p_effective_date);
1435:
1436: OPEN c_get_pact_chunk (p_assignment_action_id);

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

1429:
1430: /**************************************************************************/
1431: BEGIN
1432: hr_utility.trace('+====archive_code==========================================+');
1433: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1434: hr_utility.trace('p_effective_date : '||p_effective_date);
1435:
1436: OPEN c_get_pact_chunk (p_assignment_action_id);
1437: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;

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

1430: /**************************************************************************/
1431: BEGIN
1432: hr_utility.trace('+====archive_code==========================================+');
1433: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1434: hr_utility.trace('p_effective_date : '||p_effective_date);
1435:
1436: OPEN c_get_pact_chunk (p_assignment_action_id);
1437: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
1438: CLOSE c_get_pact_chunk;

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

1436: OPEN c_get_pact_chunk (p_assignment_action_id);
1437: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
1438: CLOSE c_get_pact_chunk;
1439:
1440: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1441: hr_utility.trace('l_chunk_number : '||l_chunk_number);
1442:
1443: get_all_parameters (
1444: p_payroll_action_id => l_payroll_action_id

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

1437: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
1438: CLOSE c_get_pact_chunk;
1439:
1440: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1441: hr_utility.trace('l_chunk_number : '||l_chunk_number);
1442:
1443: get_all_parameters (
1444: p_payroll_action_id => l_payroll_action_id
1445: ,p_org_struct_id => l_org_struct_id

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

1458: l_assignment_id := v_csr_get_abs_details.assignment_id;
1459: l_abs_attendence_id := v_csr_get_abs_details.abs_att_id;
1460: l_abs_start_date := v_csr_get_abs_details.start_date;
1461: l_abs_end_date := v_csr_get_abs_details.end_date;
1462: hr_utility.trace('Assignment/Attendence : ' || l_assignment_id||'/'||l_abs_attendence_id);
1463: hr_utility.trace('Absence Start/End Date : ' || to_char(l_abs_start_date,'DDMonYYYY') || ' / ' ||
1464: to_char(l_abs_end_date,'DDMonYYYY'));
1465: OPEN csr_already_exists (l_abs_attendence_id);
1466: FETCH csr_already_exists INTO l_exists;

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

1459: l_abs_attendence_id := v_csr_get_abs_details.abs_att_id;
1460: l_abs_start_date := v_csr_get_abs_details.start_date;
1461: l_abs_end_date := v_csr_get_abs_details.end_date;
1462: hr_utility.trace('Assignment/Attendence : ' || l_assignment_id||'/'||l_abs_attendence_id);
1463: hr_utility.trace('Absence Start/End Date : ' || to_char(l_abs_start_date,'DDMonYYYY') || ' / ' ||
1464: to_char(l_abs_end_date,'DDMonYYYY'));
1465: OPEN csr_already_exists (l_abs_attendence_id);
1466: FETCH csr_already_exists INTO l_exists;
1467: CLOSE csr_already_exists;

Line 1473: -- hr_utility.trace('LTSRR exists: '||l_exists||' LTSR exists : '||l_LTSR_exists);

1469: OPEN csr_chk_LTSR_exists(l_assignment_id,l_abs_start_date);
1470: FETCH csr_chk_LTSR_exists INTO l_LTSR_exists;
1471: CLOSE csr_chk_LTSR_exists;
1472:
1473: -- hr_utility.trace('LTSRR exists: '||l_exists||' LTSR exists : '||l_LTSR_exists);
1474:
1475: IF l_exists = 'Y' THEN
1476: fnd_file.put_line(fnd_file.log,'Long Term Sickness Recovery Report already sent. Hence skipped.');
1477: ELSIF l_exists = 'N' THEN

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

1597: END IF;
1598: END LOOP;
1599:
1600: ELSIF l_type IN ('W','R') THEN
1601: hr_utility.trace(l_type||' Assignment Action ID : '||p_assignment_action_id );
1602: OPEN c_get_assid_chunk (p_assignment_action_id);
1603: FETCH c_get_assid_chunk INTO l_assignment_id, l_chunk_number;
1604: CLOSE c_get_assid_chunk;
1605: hr_utility.trace('Assignment ID/Chunk : '||l_assignment_id||' / '||l_chunk_number);

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

1601: hr_utility.trace(l_type||' Assignment Action ID : '||p_assignment_action_id );
1602: OPEN c_get_assid_chunk (p_assignment_action_id);
1603: FETCH c_get_assid_chunk INTO l_assignment_id, l_chunk_number;
1604: CLOSE c_get_assid_chunk;
1605: hr_utility.trace('Assignment ID/Chunk : '||l_assignment_id||' / '||l_chunk_number);
1606:
1607: FOR r_get_archived_absence IN get_archived_absence(l_assignment_id, l_start_date, l_end_date, l_type)
1608: LOOP
1609:

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

1606:
1607: FOR r_get_archived_absence IN get_archived_absence(l_assignment_id, l_start_date, l_end_date, l_type)
1608: LOOP
1609:
1610: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1611:
1612: hr_utility.trace('Absence Start/End Date : ' ||
1613: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1614: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));

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

1608: LOOP
1609:
1610: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1611:
1612: hr_utility.trace('Absence Start/End Date : ' ||
1613: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1614: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1615: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1616:

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

1611:
1612: hr_utility.trace('Absence Start/End Date : ' ||
1613: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1614: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1615: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1616:
1617: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id
1618: , lockedactid => r_get_archived_absence.org_asg_act_id);
1619: IF l_type = 'W' THEN

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

1626: END IF;
1627: END LOOP;
1628: END IF;
1629:
1630: hr_utility.trace('X====archive_code==========================================X');
1631: EXCEPTION
1632: WHEN TOO_MANY_ROWS THEN
1633: hr_utility.trace('Too Many Rows Exception in archive_code');
1634:

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

1629:
1630: hr_utility.trace('X====archive_code==========================================X');
1631: EXCEPTION
1632: WHEN TOO_MANY_ROWS THEN
1633: hr_utility.trace('Too Many Rows Exception in archive_code');
1634:
1635: WHEN NO_DATA_FOUND THEN
1636: hr_utility.trace('No Data Found Exception in archive_code');
1637:

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

1632: WHEN TOO_MANY_ROWS THEN
1633: hr_utility.trace('Too Many Rows Exception in archive_code');
1634:
1635: WHEN NO_DATA_FOUND THEN
1636: hr_utility.trace('No Data Found Exception in archive_code');
1637:
1638: WHEN others THEN
1639: hr_utility.trace('Exception in archive_code SQL-ERRM : '||SQLERRM);
1640:

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

1635: WHEN NO_DATA_FOUND THEN
1636: hr_utility.trace('No Data Found Exception in archive_code');
1637:
1638: WHEN others THEN
1639: hr_utility.trace('Exception in archive_code SQL-ERRM : '||SQLERRM);
1640:
1641: END archive_code;
1642: /**************************************************************************/
1643:

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

1649:
1650:
1651: PROCEDURE deinitialization_code(p_actid IN NUMBER) IS
1652: BEGIN
1653: hr_utility.trace('+====deinitialization_code====X '|| p_actid);
1654: END deinitialization_code;
1655: /**************************************************************************/
1656:
1657: PROCEDURE gen_header_xml

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

1685: FROM per_all_people_f
1686: WHERE person_id = p_person_id;
1687:
1688: BEGIN
1689: hr_utility.trace('+====gen_header_xml========================================+');
1690: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1691: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1692: l_string := l_string || ''||EOL;
1693:

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

1687:
1688: BEGIN
1689: hr_utility.trace('+====gen_header_xml========================================+');
1690: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1691: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1692: l_string := l_string || ''||EOL;
1693:
1694: get_all_parameters (
1695: p_payroll_action_id => l_payroll_action_id

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

1735: IF l_clob IS NOT NULL THEN
1736: l_blob := c2b(l_clob);
1737: pay_core_files.write_to_magtape_lob(l_blob);
1738: END IF;
1739: hr_utility.trace('X====gen_header_xml========================================X');
1740: EXCEPTION
1741: WHEN others THEN
1742: hr_utility.trace('Exception in gen_header_xml SQL-ERRM : '||SQLERRM);
1743: END gen_header_xml;

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

1738: END IF;
1739: hr_utility.trace('X====gen_header_xml========================================X');
1740: EXCEPTION
1741: WHEN others THEN
1742: hr_utility.trace('Exception in gen_header_xml SQL-ERRM : '||SQLERRM);
1743: END gen_header_xml;
1744: /**************************************************************************/
1745: PROCEDURE gen_footer_xml
1746: IS

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

1745: PROCEDURE gen_footer_xml
1746: IS
1747: l_buf VARCHAR2(32767);
1748: BEGIN
1749: hr_utility.trace('+====gen_footer_xml========================================+');
1750: l_buf := l_buf || ''||EOL ;
1751: pay_core_files.write_to_magtape_lob(l_buf);
1752: hr_utility.trace('X====gen_footer_xml========================================X');
1753: EXCEPTION

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

1748: BEGIN
1749: hr_utility.trace('+====gen_footer_xml========================================+');
1750: l_buf := l_buf || ''||EOL ;
1751: pay_core_files.write_to_magtape_lob(l_buf);
1752: hr_utility.trace('X====gen_footer_xml========================================X');
1753: EXCEPTION
1754: WHEN others THEN
1755: hr_utility.trace('Exception in gen_footer_xml SQL-ERRM : '||SQLERRM);
1756: END gen_footer_xml;

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

1751: pay_core_files.write_to_magtape_lob(l_buf);
1752: hr_utility.trace('X====gen_footer_xml========================================X');
1753: EXCEPTION
1754: WHEN others THEN
1755: hr_utility.trace('Exception in gen_footer_xml SQL-ERRM : '||SQLERRM);
1756: END gen_footer_xml;
1757: /**************************************************************************/
1758:
1759:

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

1865: END Tag;
1866:
1867:
1868: BEGIN
1869: hr_utility.trace('+====gen_body_xml_main=====================================+');
1870:
1871: OPEN cur_abs_info_details(p_id);
1872: FETCH cur_abs_info_details INTO l_abs_info;
1873: CLOSE cur_abs_info_details;

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

1884: OPEN cur_withdrawl_flag(p_id);
1885: FETCH cur_withdrawl_flag into l_withdrawl_flag;
1886: CLOSE cur_withdrawl_flag;
1887: END IF;
1888: hr_utility.trace('Fetched all data. XML Generation starts');
1889: Tag(x,r,'UwvZwMlaHersteldMelding','_START_','B'); -- LT sickness recovery report*
1890: Tag(x,r,'IndTestbericht',l_emp_details.test_msg,'X'); -- test msg
1891: Tag(x,r,'KetenPartij','_START_','B'); -- + sender data*
1892: Tag(x,r,'Loonheffingennr',l_emp_details.tax_no_sender,'X'); -- tax reg no sender*

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

1990: write_file(xXMLTable, l_file_name);
1991:
1992: write_report(rXMLTable);
1993:
1994: hr_utility.trace('X====gen_body_xml_main=====================================X');
1995: EXCEPTION
1996: WHEN others THEN
1997: hr_utility.trace('Exception in gen_body_xml_main SQL-ERRM :'||SQLERRM);
1998: END gen_body_xml_main;

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

1993:
1994: hr_utility.trace('X====gen_body_xml_main=====================================X');
1995: EXCEPTION
1996: WHEN others THEN
1997: hr_utility.trace('Exception in gen_body_xml_main SQL-ERRM :'||SQLERRM);
1998: END gen_body_xml_main;
1999:
2000: /**************************************************************************/
2001:

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

2030: AND paa.assignment_action_id = c_assignment_action_id;
2031: /**************************************************************************/
2032:
2033: BEGIN
2034: hr_utility.trace('+====gen_body_xml==========================================+');
2035:
2036: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2037: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);
2038:

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

2033: BEGIN
2034: hr_utility.trace('+====gen_body_xml==========================================+');
2035:
2036: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2037: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);
2038:
2039: l_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
2040: hr_utility.trace('TRANSFER_ACT_ID = '||l_asg_action_id);
2041:

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

2036: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2037: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);
2038:
2039: l_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
2040: hr_utility.trace('TRANSFER_ACT_ID = '||l_asg_action_id);
2041:
2042: OPEN get_pact_id(l_asg_action_id);
2043: FETCH get_pact_id INTO l_payroll_action_id;
2044: CLOSE get_pact_id;

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

2042: OPEN get_pact_id(l_asg_action_id);
2043: FETCH get_pact_id INTO l_payroll_action_id;
2044: CLOSE get_pact_id;
2045:
2046: hr_utility.trace('l_payroll_action_id = '||l_payroll_action_id);
2047: get_all_parameters (
2048: p_payroll_action_id => l_payroll_action_id
2049: ,p_org_struct_id => l_org_struct_id
2050: ,p_person_id => l_person_id

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

2054: ,p_end_date => l_end_date
2055: ,p_type => l_type);
2056:
2057: IF l_type = 'I' THEN
2058: hr_utility.trace('Initial Report');
2059: FOR v_child_act_id IN cur_get_child_act_id(l_asg_action_id)
2060: LOOP
2061: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);
2062: gen_body_xml_main(l_type, v_child_act_id.ass_act_id);

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

2057: IF l_type = 'I' THEN
2058: hr_utility.trace('Initial Report');
2059: FOR v_child_act_id IN cur_get_child_act_id(l_asg_action_id)
2060: LOOP
2061: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);
2062: gen_body_xml_main(l_type, v_child_act_id.ass_act_id);
2063: END LOOP;
2064: ELSIF l_type IN ('W','R') THEN
2065: hr_utility.trace('Withdrawal/Regeneration Report');

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

2061: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);
2062: gen_body_xml_main(l_type, v_child_act_id.ass_act_id);
2063: END LOOP;
2064: ELSIF l_type IN ('W','R') THEN
2065: hr_utility.trace('Withdrawal/Regeneration Report');
2066: FOR v_parent_asg_ids in get_parent_asg_ids(l_asg_action_id)
2067: LOOP
2068: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);
2069: gen_body_xml_main(l_type, v_parent_asg_ids.parent_id);

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

2064: ELSIF l_type IN ('W','R') THEN
2065: hr_utility.trace('Withdrawal/Regeneration Report');
2066: FOR v_parent_asg_ids in get_parent_asg_ids(l_asg_action_id)
2067: LOOP
2068: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);
2069: gen_body_xml_main(l_type, v_parent_asg_ids.parent_id);
2070: END LOOP;
2071: END IF;
2072: hr_utility.trace('X====gen_body_xml==========================================X');

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

2068: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);
2069: gen_body_xml_main(l_type, v_parent_asg_ids.parent_id);
2070: END LOOP;
2071: END IF;
2072: hr_utility.trace('X====gen_body_xml==========================================X');
2073: EXCEPTION
2074: WHEN others THEN
2075: hr_utility.trace('Exception in gen_body_xml SQL-ERRM :'||SQLERRM);
2076: END gen_body_xml;

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

2071: END IF;
2072: hr_utility.trace('X====gen_body_xml==========================================X');
2073: EXCEPTION
2074: WHEN others THEN
2075: hr_utility.trace('Exception in gen_body_xml SQL-ERRM :'||SQLERRM);
2076: END gen_body_xml;
2077:
2078: END PER_NL_LTSRR_ARCHIVE;
2079: