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_DSRR_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 706: hr_utility.trace('+====initialization_code===================================+');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1410:
1411:
1412: /**************************************************************************/
1413: BEGIN
1414: hr_utility.trace('+====archive_code==========================================+');
1415: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1416: hr_utility.trace('p_effective_date : '||p_effective_date);
1417:
1418: OPEN c_get_pact_chunk (p_assignment_action_id);

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

1411:
1412: /**************************************************************************/
1413: BEGIN
1414: hr_utility.trace('+====archive_code==========================================+');
1415: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1416: hr_utility.trace('p_effective_date : '||p_effective_date);
1417:
1418: OPEN c_get_pact_chunk (p_assignment_action_id);
1419: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;

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

1412: /**************************************************************************/
1413: BEGIN
1414: hr_utility.trace('+====archive_code==========================================+');
1415: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1416: hr_utility.trace('p_effective_date : '||p_effective_date);
1417:
1418: OPEN c_get_pact_chunk (p_assignment_action_id);
1419: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
1420: CLOSE c_get_pact_chunk;

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

1418: OPEN c_get_pact_chunk (p_assignment_action_id);
1419: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
1420: CLOSE c_get_pact_chunk;
1421:
1422: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1423: hr_utility.trace('l_chunk_number : '||l_chunk_number);
1424:
1425: get_all_parameters (
1426: p_payroll_action_id => l_payroll_action_id

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

1419: FETCH c_get_pact_chunk INTO l_payroll_action_id, l_chunk_number;
1420: CLOSE c_get_pact_chunk;
1421:
1422: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1423: hr_utility.trace('l_chunk_number : '||l_chunk_number);
1424:
1425: get_all_parameters (
1426: p_payroll_action_id => l_payroll_action_id
1427: ,p_org_struct_id => l_org_struct_id

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

1440: l_assignment_id := v_csr_get_abs_details.assignment_id;
1441: l_abs_attendence_id := v_csr_get_abs_details.abs_att_id;
1442: l_abs_start_date := v_csr_get_abs_details.start_date;
1443: l_abs_end_date := v_csr_get_abs_details.end_date;
1444: hr_utility.trace('Assignment/Attendence : ' || l_assignment_id||'/'||l_abs_attendence_id);
1445: hr_utility.trace('Absence Start/End Date : ' || to_char(l_abs_start_date,'DDMonYYYY') || ' / ' ||
1446: to_char(l_abs_end_date,'DDMonYYYY'));
1447: OPEN csr_already_exists (l_abs_attendence_id);
1448: FETCH csr_already_exists INTO l_exists;

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

1441: l_abs_attendence_id := v_csr_get_abs_details.abs_att_id;
1442: l_abs_start_date := v_csr_get_abs_details.start_date;
1443: l_abs_end_date := v_csr_get_abs_details.end_date;
1444: hr_utility.trace('Assignment/Attendence : ' || l_assignment_id||'/'||l_abs_attendence_id);
1445: hr_utility.trace('Absence Start/End Date : ' || to_char(l_abs_start_date,'DDMonYYYY') || ' / ' ||
1446: to_char(l_abs_end_date,'DDMonYYYY'));
1447: OPEN csr_already_exists (l_abs_attendence_id);
1448: FETCH csr_already_exists INTO l_exists;
1449: CLOSE csr_already_exists;

Line 1455: -- hr_utility.trace('SRR exists: '||l_exists||' SR exists : '||l_SR_exists);

1451: OPEN csr_chk_SR_exists(l_assignment_id,l_abs_start_date);
1452: FETCH csr_chk_SR_exists INTO l_SR_exists;
1453: CLOSE csr_chk_SR_exists;
1454:
1455: -- hr_utility.trace('SRR exists: '||l_exists||' SR exists : '||l_SR_exists);
1456: IF l_exists = 'Y' THEN
1457: fnd_file.put_line(fnd_file.log,'Sickness Recovery Report already sent. Hence skipped.');
1458: ELSIF l_exists = 'N' THEN
1459: IF l_SR_exists = 'N' THEN

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

1569: END IF;
1570: END LOOP;
1571:
1572: ELSIF l_type IN ('W','R') THEN
1573: hr_utility.trace(l_type||' Assignment Action ID : '||p_assignment_action_id );
1574: OPEN c_get_assid_chunk (p_assignment_action_id);
1575: FETCH c_get_assid_chunk INTO l_assignment_id, l_chunk_number;
1576: CLOSE c_get_assid_chunk;
1577: hr_utility.trace('Assignment ID/Chunk : '||l_assignment_id||' / '||l_chunk_number);

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

1573: hr_utility.trace(l_type||' Assignment Action ID : '||p_assignment_action_id );
1574: OPEN c_get_assid_chunk (p_assignment_action_id);
1575: FETCH c_get_assid_chunk INTO l_assignment_id, l_chunk_number;
1576: CLOSE c_get_assid_chunk;
1577: hr_utility.trace('Assignment ID/Chunk : '||l_assignment_id||' / '||l_chunk_number);
1578:
1579: FOR r_get_archived_absence IN get_archived_absence(l_assignment_id, l_start_date, l_end_date, l_type)
1580: LOOP
1581:

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

1578:
1579: FOR r_get_archived_absence IN get_archived_absence(l_assignment_id, l_start_date, l_end_date, l_type)
1580: LOOP
1581:
1582: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1583:
1584: hr_utility.trace('Absence Start/End Date : ' ||
1585: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1586: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));

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

1580: LOOP
1581:
1582: hr_utility.trace('Absence Attendence ID : ' || r_get_archived_absence.abs_att_id);
1583:
1584: hr_utility.trace('Absence Start/End Date : ' ||
1585: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1586: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1587: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1588:

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

1583:
1584: hr_utility.trace('Absence Start/End Date : ' ||
1585: to_char(fnd_date.canonical_to_date(r_get_archived_absence.st_dt),'DDMonYYYY') || ' / ' ||
1586: to_char(fnd_date.canonical_to_date(r_get_archived_absence.end_dt),'DDMonYYYY'));
1587: hr_utility.trace('Org Asg Action ID : ' || r_get_archived_absence.org_asg_act_id);
1588:
1589: hr_nonrun_asact.insint(lockingactid => p_assignment_action_id
1590: , lockedactid => r_get_archived_absence.org_asg_act_id);
1591: IF l_type = 'W' THEN

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

1598: END IF;
1599: END LOOP;
1600: END IF;
1601:
1602: hr_utility.trace('X====archive_code==========================================X');
1603: EXCEPTION
1604: WHEN TOO_MANY_ROWS THEN
1605: hr_utility.trace('Too Many Rows Exception in archive_code');
1606:

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

1601:
1602: hr_utility.trace('X====archive_code==========================================X');
1603: EXCEPTION
1604: WHEN TOO_MANY_ROWS THEN
1605: hr_utility.trace('Too Many Rows Exception in archive_code');
1606:
1607: WHEN NO_DATA_FOUND THEN
1608: hr_utility.trace('No Data Found Exception in archive_code');
1609:

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

1604: WHEN TOO_MANY_ROWS THEN
1605: hr_utility.trace('Too Many Rows Exception in archive_code');
1606:
1607: WHEN NO_DATA_FOUND THEN
1608: hr_utility.trace('No Data Found Exception in archive_code');
1609:
1610: WHEN others THEN
1611: hr_utility.trace('Exception in archive_code SQL-ERRM : '||SQLERRM);
1612:

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

1607: WHEN NO_DATA_FOUND THEN
1608: hr_utility.trace('No Data Found Exception in archive_code');
1609:
1610: WHEN others THEN
1611: hr_utility.trace('Exception in archive_code SQL-ERRM : '||SQLERRM);
1612:
1613: END archive_code;
1614: /**************************************************************************/
1615:

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

1622:
1623:
1624: PROCEDURE deinitialization_code(p_actid IN NUMBER) IS
1625: BEGIN
1626: hr_utility.trace('+====deinitialization_code====X '|| p_actid);
1627: END deinitialization_code;
1628:
1629:
1630:

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

1662: FROM per_all_people_f
1663: WHERE person_id = p_person_id;
1664:
1665: BEGIN
1666: hr_utility.trace('+====gen_header_xml========================================+');
1667: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1668: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1669: l_string := l_string || ''||EOL;
1670:

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

1664:
1665: BEGIN
1666: hr_utility.trace('+====gen_header_xml========================================+');
1667: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1668: hr_utility.trace('l_payroll_action_id : '||l_payroll_action_id);
1669: l_string := l_string || ''||EOL;
1670:
1671: get_all_parameters (
1672: p_payroll_action_id => l_payroll_action_id

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

1712: IF l_clob IS NOT NULL THEN
1713: l_blob := c2b(l_clob);
1714: pay_core_files.write_to_magtape_lob(l_blob);
1715: END IF;
1716: hr_utility.trace('X====gen_header_xml========================================X');
1717: EXCEPTION
1718: WHEN others THEN
1719: hr_utility.trace('Exception in gen_header_xml SQL-ERRM : '||SQLERRM);
1720: END gen_header_xml;

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

1715: END IF;
1716: hr_utility.trace('X====gen_header_xml========================================X');
1717: EXCEPTION
1718: WHEN others THEN
1719: hr_utility.trace('Exception in gen_header_xml SQL-ERRM : '||SQLERRM);
1720: END gen_header_xml;
1721: /**************************************************************************/
1722: PROCEDURE gen_footer_xml
1723: IS

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

1722: PROCEDURE gen_footer_xml
1723: IS
1724: l_buf VARCHAR2(32767);
1725: BEGIN
1726: hr_utility.trace('+====gen_footer_xml========================================+');
1727: l_buf := l_buf || ''||EOL ;
1728: pay_core_files.write_to_magtape_lob(l_buf);
1729: hr_utility.trace('X====gen_footer_xml========================================X');
1730: EXCEPTION

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

1725: BEGIN
1726: hr_utility.trace('+====gen_footer_xml========================================+');
1727: l_buf := l_buf || ''||EOL ;
1728: pay_core_files.write_to_magtape_lob(l_buf);
1729: hr_utility.trace('X====gen_footer_xml========================================X');
1730: EXCEPTION
1731: WHEN others THEN
1732: hr_utility.trace('Exception in gen_footer_xml SQL-ERRM : '||SQLERRM);
1733: END gen_footer_xml;

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

1728: pay_core_files.write_to_magtape_lob(l_buf);
1729: hr_utility.trace('X====gen_footer_xml========================================X');
1730: EXCEPTION
1731: WHEN others THEN
1732: hr_utility.trace('Exception in gen_footer_xml SQL-ERRM : '||SQLERRM);
1733: END gen_footer_xml;
1734: /**************************************************************************/
1735:
1736: PROCEDURE gen_body_xml_main(p_type varchar2, p_id number) IS

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

1839: END Tag;
1840:
1841:
1842: BEGIN
1843: hr_utility.trace('+====gen_body_xml_main=====================================+');
1844:
1845: OPEN cur_abs_info_details(p_id);
1846: FETCH cur_abs_info_details INTO l_abs_info;
1847: CLOSE cur_abs_info_details;

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

1858: OPEN cur_withdrawl_flag(p_id);
1859: FETCH cur_withdrawl_flag into l_withdrawl_flag;
1860: CLOSE cur_withdrawl_flag;
1861: END IF;
1862: hr_utility.trace('Fetched all data. XML Generation starts');
1863:
1864: Tag(x,r,'UwvZwWerkhervattingMelding','_START_','B'); -- sickness recovery report*
1865: Tag(x,r,'IndTestbericht',l_emp_details.test_msg,'X'); -- test msg
1866: Tag(x,r,'KetenPartij','_START_','B'); -- + sender data*

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

1964: write_file(xXMLTable, l_file_name);
1965:
1966: write_report(rXMLTable);
1967:
1968: hr_utility.trace('X====gen_body_xml_main=====================================X');
1969: EXCEPTION
1970: WHEN others THEN
1971: hr_utility.trace('Exception in gen_body_xml_main SQL-ERRM :'||SQLERRM);
1972: END gen_body_xml_main;

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

1967:
1968: hr_utility.trace('X====gen_body_xml_main=====================================X');
1969: EXCEPTION
1970: WHEN others THEN
1971: hr_utility.trace('Exception in gen_body_xml_main SQL-ERRM :'||SQLERRM);
1972: END gen_body_xml_main;
1973:
1974: /**************************************************************************/
1975:

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

2004: AND paa.assignment_action_id = c_assignment_action_id;
2005: /**************************************************************************/
2006:
2007: BEGIN
2008: hr_utility.trace('+====gen_body_xml==========================================+');
2009:
2010: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2011: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);
2012:

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

2007: BEGIN
2008: hr_utility.trace('+====gen_body_xml==========================================+');
2009:
2010: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2011: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);
2012:
2013: l_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
2014: hr_utility.trace('TRANSFER_ACT_ID = '||l_asg_action_id);
2015:

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

2010: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2011: hr_utility.trace('TRANSFER_PAYROLL_ACTION_ID = '||l_payroll_action_id);
2012:
2013: l_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
2014: hr_utility.trace('TRANSFER_ACT_ID = '||l_asg_action_id);
2015:
2016: OPEN get_pact_id(l_asg_action_id);
2017: FETCH get_pact_id INTO l_payroll_action_id;
2018: CLOSE get_pact_id;

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

2016: OPEN get_pact_id(l_asg_action_id);
2017: FETCH get_pact_id INTO l_payroll_action_id;
2018: CLOSE get_pact_id;
2019:
2020: hr_utility.trace('l_payroll_action_id = '||l_payroll_action_id);
2021: get_all_parameters (
2022: p_payroll_action_id => l_payroll_action_id
2023: ,p_org_struct_id => l_org_struct_id
2024: ,p_person_id => l_person_id

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

2028: ,p_end_date => l_end_date
2029: ,p_type => l_type);
2030:
2031: IF l_type = 'I' THEN
2032: hr_utility.trace('Initial Report');
2033: FOR v_child_act_id IN cur_get_child_act_id(l_asg_action_id)
2034: LOOP
2035: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);
2036: gen_body_xml_main(l_type, v_child_act_id.ass_act_id);

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

2031: IF l_type = 'I' THEN
2032: hr_utility.trace('Initial Report');
2033: FOR v_child_act_id IN cur_get_child_act_id(l_asg_action_id)
2034: LOOP
2035: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);
2036: gen_body_xml_main(l_type, v_child_act_id.ass_act_id);
2037: END LOOP;
2038: ELSIF l_type IN ('W','R') THEN
2039: hr_utility.trace('Withdrawal/Regeneration Report');

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

2035: hr_utility.trace('Child Assignment Action ID :'||v_child_act_id.ass_act_id);
2036: gen_body_xml_main(l_type, v_child_act_id.ass_act_id);
2037: END LOOP;
2038: ELSIF l_type IN ('W','R') THEN
2039: hr_utility.trace('Withdrawal/Regeneration Report');
2040: FOR v_parent_asg_ids in get_parent_asg_ids(l_asg_action_id)
2041: LOOP
2042: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);
2043: gen_body_xml_main(l_type, v_parent_asg_ids.parent_id);

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

2038: ELSIF l_type IN ('W','R') THEN
2039: hr_utility.trace('Withdrawal/Regeneration Report');
2040: FOR v_parent_asg_ids in get_parent_asg_ids(l_asg_action_id)
2041: LOOP
2042: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);
2043: gen_body_xml_main(l_type, v_parent_asg_ids.parent_id);
2044: END LOOP;
2045: END IF;
2046: hr_utility.trace('X====gen_body_xml==========================================X');

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

2042: hr_utility.trace('Parent Assignment Action ID :'||v_parent_asg_ids.parent_id);
2043: gen_body_xml_main(l_type, v_parent_asg_ids.parent_id);
2044: END LOOP;
2045: END IF;
2046: hr_utility.trace('X====gen_body_xml==========================================X');
2047: EXCEPTION
2048: WHEN others THEN
2049: hr_utility.trace('Exception in gen_body_xml SQL-ERRM :'||SQLERRM);
2050: END gen_body_xml;

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

2045: END IF;
2046: hr_utility.trace('X====gen_body_xml==========================================X');
2047: EXCEPTION
2048: WHEN others THEN
2049: hr_utility.trace('Exception in gen_body_xml SQL-ERRM :'||SQLERRM);
2050: END gen_body_xml;
2051:
2052: END PER_NL_DSRR_ARCHIVE;
2053: