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

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

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: IF p_org_id is not NULL THEN
424: BEGIN
425: OPEN csr_org_check(p_bg_id
426: ,p_org_struct_id

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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: BEGIN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1377:
1378:
1379: BEGIN
1380:
1381: hr_utility.trace('+====archive_code==========================================+');
1382: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1383: hr_utility.trace('p_effective_date : '||p_effective_date);
1384:
1385: OPEN c_get_pact_chunk (p_assignment_action_id);

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

1378:
1379: BEGIN
1380:
1381: hr_utility.trace('+====archive_code==========================================+');
1382: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1383: hr_utility.trace('p_effective_date : '||p_effective_date);
1384:
1385: OPEN c_get_pact_chunk (p_assignment_action_id);
1386: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;

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

1379: BEGIN
1380:
1381: hr_utility.trace('+====archive_code==========================================+');
1382: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1383: hr_utility.trace('p_effective_date : '||p_effective_date);
1384:
1385: OPEN c_get_pact_chunk (p_assignment_action_id);
1386: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
1387: CLOSE c_get_pact_chunk;

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

1385: OPEN c_get_pact_chunk (p_assignment_action_id);
1386: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
1387: CLOSE c_get_pact_chunk;
1388:
1389: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1390: hr_utility.trace('l_chunk_number : '||l_chunk_number);
1391:
1392: get_all_parameters (
1393: p_payroll_action_id => l_payroll_action_id

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

1386: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
1387: CLOSE c_get_pact_chunk;
1388:
1389: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1390: hr_utility.trace('l_chunk_number : '||l_chunk_number);
1391:
1392: get_all_parameters (
1393: p_payroll_action_id => l_payroll_action_id
1394: ,p_org_struct_id => l_org_struct_id

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

1406: l_assignment_id := v_csr_get_abs_details.assignment_id;
1407: l_abs_attendence_id := v_csr_get_abs_details.abs_att_id;
1408: l_abs_start_date := v_csr_get_abs_details.start_date;
1409: l_abs_end_date := v_csr_get_abs_details.end_date;
1410: hr_utility.trace('Assignment/Attendence : ' || l_assignment_id||'/'||l_abs_attendence_id);
1411: hr_utility.trace('Absence Start/End Date : ' || to_char(l_abs_start_date,'DDMonYYYY') || ' / ' ||
1412: to_char(l_abs_end_date,'DDMonYYYY'));
1413:
1414: OPEN csr_already_exists (l_assignment_id,l_abs_start_date);

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

1407: l_abs_attendence_id := v_csr_get_abs_details.abs_att_id;
1408: l_abs_start_date := v_csr_get_abs_details.start_date;
1409: l_abs_end_date := v_csr_get_abs_details.end_date;
1410: hr_utility.trace('Assignment/Attendence : ' || l_assignment_id||'/'||l_abs_attendence_id);
1411: hr_utility.trace('Absence Start/End Date : ' || to_char(l_abs_start_date,'DDMonYYYY') || ' / ' ||
1412: to_char(l_abs_end_date,'DDMonYYYY'));
1413:
1414: OPEN csr_already_exists (l_assignment_id,l_abs_start_date);
1415: FETCH csr_already_exists INTO l_exists;

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

1413:
1414: OPEN csr_already_exists (l_assignment_id,l_abs_start_date);
1415: FETCH csr_already_exists INTO l_exists;
1416: CLOSE csr_already_exists;
1417: -- hr_utility.trace('l_exists : '||l_exists);
1418: IF l_exists = 'Y' THEN
1419: fnd_file.put_line(fnd_file.log,'Long Term Sickness Report already sent. Hence skipped.');
1420: ELSIF l_exists = 'N' THEN
1421:

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

1522: END IF;
1523: END LOOP;
1524:
1525: ELSIF l_type IN ('W','R') THEN
1526: hr_utility.trace(l_type||' Assignment Action ID : '||p_assignment_action_id );
1527: OPEN c_get_assid_chunk (p_assignment_action_id);
1528: FETCH c_get_assid_chunk INTO l_assignment_id, l_chunk_number;
1529: CLOSE c_get_assid_chunk;
1530: hr_utility.trace('Assignment ID/Chunk : '||l_assignment_id||' / '||l_chunk_number);

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

1526: hr_utility.trace(l_type||' Assignment Action ID : '||p_assignment_action_id );
1527: OPEN c_get_assid_chunk (p_assignment_action_id);
1528: FETCH c_get_assid_chunk INTO l_assignment_id, l_chunk_number;
1529: CLOSE c_get_assid_chunk;
1530: hr_utility.trace('Assignment ID/Chunk : '||l_assignment_id||' / '||l_chunk_number);
1531:
1532: FOR r_get_archived_absence IN get_archived_absence(l_assignment_id, l_start_date, l_end_date, l_type)
1533: LOOP
1534:

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

1531:
1532: FOR r_get_archived_absence IN get_archived_absence(l_assignment_id, l_start_date, l_end_date, l_type)
1533: LOOP
1534:
1535: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1536:
1537: hr_utility.trace('Absence Start/End Date : ' ||
1538: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1539: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));

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

1533: LOOP
1534:
1535: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1536:
1537: hr_utility.trace('Absence Start/End Date : ' ||
1538: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1539: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1540: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1541:

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

1536:
1537: hr_utility.trace('Absence Start/End Date : ' ||
1538: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1539: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1540: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1541:
1542: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id
1543: , lockedactid => r_get_archived_absence.org_asg_act_id);
1544: IF l_type = 'W' THEN

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

1551: END IF;
1552: END LOOP;
1553: END IF;
1554:
1555: hr_utility.trace('X====archive_code==========================================X');
1556: EXCEPTION
1557: WHEN TOO_MANY_ROWS THEN
1558: hr_utility.trace('Too Many Rows Exception in archive_code');
1559:

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

1554:
1555: hr_utility.trace('X====archive_code==========================================X');
1556: EXCEPTION
1557: WHEN TOO_MANY_ROWS THEN
1558: hr_utility.trace('Too Many Rows Exception in archive_code');
1559:
1560: WHEN NO_DATA_FOUND THEN
1561: hr_utility.trace('No Data Found Exception in archive_code');
1562:

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

1557: WHEN TOO_MANY_ROWS THEN
1558: hr_utility.trace('Too Many Rows Exception in archive_code');
1559:
1560: WHEN NO_DATA_FOUND THEN
1561: hr_utility.trace('No Data Found Exception in archive_code');
1562:
1563: WHEN others THEN
1564: hr_utility.trace('Exception in archive_code SQL-ERRM : '||SQLERRM);
1565:

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

1560: WHEN NO_DATA_FOUND THEN
1561: hr_utility.trace('No Data Found Exception in archive_code');
1562:
1563: WHEN others THEN
1564: hr_utility.trace('Exception in archive_code SQL-ERRM : '||SQLERRM);
1565:
1566: END archive_code;
1567: /**************************************************************************/
1568:

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

1575: PROCEDURE deinitialization_code(p_actid IN NUMBER) IS
1576:
1577:
1578: BEGIN
1579: hr_utility.trace('+====deinitialization_code====X '|| p_actid);
1580: END deinitialization_code;
1581:
1582:
1583:

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

1615: FROM per_all_people_f
1616: WHERE person_id = p_person_id;
1617:
1618: BEGIN
1619: hr_utility.trace('+====gen_header_xml========================================+');
1620: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1621: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1622: l_string := l_string || ''||EOL;
1623:

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

1617:
1618: BEGIN
1619: hr_utility.trace('+====gen_header_xml========================================+');
1620: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1621: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1622: l_string := l_string || ''||EOL;
1623:
1624: get_all_parameters (
1625: p_payroll_action_id => l_payroll_action_id

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

1665: IF l_clob IS NOT NULL THEN
1666: l_blob := c2b(l_clob);
1667: pay_core_files.write_to_magtape_lob(l_blob);
1668: END IF;
1669: hr_utility.trace('X====gen_header_xml========================================X');
1670: EXCEPTION
1671: WHEN others THEN
1672: hr_utility.trace('Exception in gen_header_xml SQL-ERRM : '||SQLERRM);
1673: END gen_header_xml;

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

1668: END IF;
1669: hr_utility.trace('X====gen_header_xml========================================X');
1670: EXCEPTION
1671: WHEN others THEN
1672: hr_utility.trace('Exception in gen_header_xml SQL-ERRM : '||SQLERRM);
1673: END gen_header_xml;
1674:
1675:
1676: /**************************************************************************/

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

1677: PROCEDURE gen_footer_xml
1678: IS
1679: l_buf VARCHAR2(32767);
1680: BEGIN
1681: hr_utility.trace('+====gen_footer_xml========================================+');
1682: l_buf := l_buf || ''||EOL ;
1683: pay_core_files.write_to_magtape_lob(l_buf);
1684: hr_utility.trace('X====gen_footer_xml========================================X');
1685: EXCEPTION

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

1680: BEGIN
1681: hr_utility.trace('+====gen_footer_xml========================================+');
1682: l_buf := l_buf || ''||EOL ;
1683: pay_core_files.write_to_magtape_lob(l_buf);
1684: hr_utility.trace('X====gen_footer_xml========================================X');
1685: EXCEPTION
1686: WHEN others THEN
1687: hr_utility.trace('Exception in gen_footer_xml SQL-ERRM : '||SQLERRM);
1688: END gen_footer_xml;

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

1683: pay_core_files.write_to_magtape_lob(l_buf);
1684: hr_utility.trace('X====gen_footer_xml========================================X');
1685: EXCEPTION
1686: WHEN others THEN
1687: hr_utility.trace('Exception in gen_footer_xml SQL-ERRM : '||SQLERRM);
1688: END gen_footer_xml;
1689: /**************************************************************************/
1690: PROCEDURE gen_body_xml_main(p_type varchar2, p_id number) IS
1691:

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

1794: END Tag;
1795:
1796:
1797: BEGIN
1798: hr_utility.trace('+====gen_body_xml_main=====================================+');
1799:
1800: OPEN cur_abs_info_details(p_id);
1801: FETCH cur_abs_info_details INTO l_abs_info;
1802: CLOSE cur_abs_info_details;

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

1813: OPEN cur_withdrawl_flag(p_id);
1814: FETCH cur_withdrawl_flag into l_withdrawl_flag;
1815: CLOSE cur_withdrawl_flag;
1816: END IF;
1817: hr_utility.trace('Fetched all data. XML Generation starts');
1818: Tag(x,r,'UwvZwMlaMelding','_START_','B'); -- LT sickness report*
1819: Tag(x,r,'IndTestbericht',l_emp_details.test_msg,'X'); -- test msg
1820: Tag(x,r,'KetenPartij','_START_','B'); -- + sender data*
1821: Tag(x,r,'Loonheffingennr',l_emp_details.tax_no_sender,'X'); -- tax reg no sender*

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

1903: write_file(xXMLTable, l_file_name);
1904:
1905: write_report(rXMLTable);
1906:
1907: hr_utility.trace('X====gen_body_xml_main=====================================X');
1908: EXCEPTION
1909: WHEN others THEN
1910: hr_utility.trace('Exception in gen_body_xml_main SQL-ERRM :'||SQLERRM);
1911: END gen_body_xml_main;

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

1906:
1907: hr_utility.trace('X====gen_body_xml_main=====================================X');
1908: EXCEPTION
1909: WHEN others THEN
1910: hr_utility.trace('Exception in gen_body_xml_main SQL-ERRM :'||SQLERRM);
1911: END gen_body_xml_main;
1912:
1913: /**************************************************************************/
1914:

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

1943: AND paa.assignment_action_id = c_assignment_action_id;
1944: /**************************************************************************/
1945:
1946: BEGIN
1947: hr_utility.trace('+====gen_body_xml==========================================+');
1948:
1949: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1950: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);
1951:

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

1946: BEGIN
1947: hr_utility.trace('+====gen_body_xml==========================================+');
1948:
1949: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1950: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);
1951:
1952: l_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
1953: hr_utility.trace('TRANSFER_ACT_ID = '||l_asg_action_id);
1954:

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

1949: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1950: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);
1951:
1952: l_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
1953: hr_utility.trace('TRANSFER_ACT_ID = '||l_asg_action_id);
1954:
1955: OPEN get_pact_id(l_asg_action_id);
1956: FETCH get_pact_id INTO l_payroll_action_id;
1957: CLOSE get_pact_id;

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

1955: OPEN get_pact_id(l_asg_action_id);
1956: FETCH get_pact_id INTO l_payroll_action_id;
1957: CLOSE get_pact_id;
1958:
1959: hr_utility.trace('l_payroll_action_id = '||l_payroll_action_id);
1960: get_all_parameters (
1961: p_payroll_action_id => l_payroll_action_id
1962: ,p_org_struct_id => l_org_struct_id
1963: ,p_person_id => l_person_id

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

1967: ,p_end_date => l_end_date
1968: ,p_type => l_type);
1969:
1970: IF l_type = 'I' THEN
1971: hr_utility.trace('Initial Report');
1972: FOR v_child_act_id IN cur_get_child_act_id(l_asg_action_id)
1973: LOOP
1974: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);
1975: gen_body_xml_main(l_type, v_child_act_id.ass_act_id);

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

1970: IF l_type = 'I' THEN
1971: hr_utility.trace('Initial Report');
1972: FOR v_child_act_id IN cur_get_child_act_id(l_asg_action_id)
1973: LOOP
1974: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);
1975: gen_body_xml_main(l_type, v_child_act_id.ass_act_id);
1976: END LOOP;
1977: ELSIF l_type IN ('W','R') THEN
1978: hr_utility.trace('Withdrawal/Regeneration Report');

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

1974: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);
1975: gen_body_xml_main(l_type, v_child_act_id.ass_act_id);
1976: END LOOP;
1977: ELSIF l_type IN ('W','R') THEN
1978: hr_utility.trace('Withdrawal/Regeneration Report');
1979: FOR v_parent_asg_ids in get_parent_asg_ids(l_asg_action_id)
1980: LOOP
1981: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);
1982: gen_body_xml_main(l_type, v_parent_asg_ids.parent_id);

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

1977: ELSIF l_type IN ('W','R') THEN
1978: hr_utility.trace('Withdrawal/Regeneration Report');
1979: FOR v_parent_asg_ids in get_parent_asg_ids(l_asg_action_id)
1980: LOOP
1981: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);
1982: gen_body_xml_main(l_type, v_parent_asg_ids.parent_id);
1983: END LOOP;
1984: END IF;
1985: hr_utility.trace('X====gen_body_xml==========================================X');

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

1981: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);
1982: gen_body_xml_main(l_type, v_parent_asg_ids.parent_id);
1983: END LOOP;
1984: END IF;
1985: hr_utility.trace('X====gen_body_xml==========================================X');
1986: EXCEPTION
1987: WHEN others THEN
1988: hr_utility.trace('Exception in gen_body_xml SQL-ERRM :'||SQLERRM);
1989: END gen_body_xml;

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

1984: END IF;
1985: hr_utility.trace('X====gen_body_xml==========================================X');
1986: EXCEPTION
1987: WHEN others THEN
1988: hr_utility.trace('Exception in gen_body_xml SQL-ERRM :'||SQLERRM);
1989: END gen_body_xml;
1990:
1991: END PER_NL_LTSR_ARCHIVE;
1992: