DBA Data[Home] [Help]

APPS.PAY_NL_EOY_PKG dependencies on HR_GENERAL

Line 1119: IF l_max_assignment_end_date<>hr_general.end_of_time THEN

1115: l_last_assignment_id:=l_asg_details.assignment_id;
1116:
1117: /* Only if Max effective end date is not 31-DEC-4712, fetch the
1118: end date of the last record of this assignment. */
1119: IF l_max_assignment_end_date<>hr_general.end_of_time THEN
1120: OPEN csr_get_asg_max_end_date(l_asg_details.assignment_id);
1121: FETCH csr_get_asg_max_end_date INTO l_max_assignment_end_date;
1122: CLOSE csr_get_asg_max_end_date;
1123: END IF;

Line 1132: --hr_general.end_of_time then --12608988

1128:
1129: l_datetrack_update_mode := 'CORRECTION';
1130: elsif
1131: l_asg_details.effective_end_date <> l_max_assignment_end_date then
1132: --hr_general.end_of_time then --12608988
1133: l_datetrack_update_mode := 'UPDATE_CHANGE_INSERT';
1134: else
1135: l_datetrack_update_mode := 'UPDATE';
1136: end if;

Line 1144: --hr_utility.trace(hr_general.end_of_time);

1140: --hr_utility.trace(l_asg_details.assignment_number);
1141: --hr_utility.trace(l_asg_details.effective_start_date);
1142: --hr_utility.trace(l_asg_details.effective_end_date);
1143: --hr_utility.trace(fnd_date.canonical_to_date(p_date));
1144: --hr_utility.trace(hr_general.end_of_time);
1145:
1146: --fnd_file.put_line(fnd_file.log,l_asg_details.assignment_id);
1147: l_soft_coding_keyflex_id := NULL; -- Bug 5763286
1148: hr_nl_assignment_api.update_nl_emp_asg

Line 1192: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',80,'-') || rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION_REPORT'),20,' ') || rpad('-',80,'-'));

1188: end loop;
1189:
1190: --12608988 starts
1191: --# Exception Report
1192: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',80,'-') || rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION_REPORT'),20,' ') || rpad('-',80,'-'));
1193: FND_FILE.PUT_LINE(fnd_file.output,rpad(' ',180,' '));
1194: --
1195: --
1196: IF exceptions_count>0 THEN

Line 1198: FND_FILE.PUT_LINE(fnd_file.output , exceptions_count||' '||hr_general.decode_lookup('NL_FORM_LABELS','EXCEPTION'));

1194: --
1195: --
1196: IF exceptions_count>0 THEN
1197: --
1198: FND_FILE.PUT_LINE(fnd_file.output , exceptions_count||' '||hr_general.decode_lookup('NL_FORM_LABELS','EXCEPTION'));
1199: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
1200: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
1201: rpad('ID',12,' ') ||
1202: rpad(hr_general.decode_lookup('NL_FORM_LABELS','DATE_ENDING'),13,' ') ||

Line 1200: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||

1196: IF exceptions_count>0 THEN
1197: --
1198: FND_FILE.PUT_LINE(fnd_file.output , exceptions_count||' '||hr_general.decode_lookup('NL_FORM_LABELS','EXCEPTION'));
1199: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
1200: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
1201: rpad('ID',12,' ') ||
1202: rpad(hr_general.decode_lookup('NL_FORM_LABELS','DATE_ENDING'),13,' ') ||
1203: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),133,' '));
1204: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));

Line 1202: rpad(hr_general.decode_lookup('NL_FORM_LABELS','DATE_ENDING'),13,' ') ||

1198: FND_FILE.PUT_LINE(fnd_file.output , exceptions_count||' '||hr_general.decode_lookup('NL_FORM_LABELS','EXCEPTION'));
1199: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
1200: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
1201: rpad('ID',12,' ') ||
1202: rpad(hr_general.decode_lookup('NL_FORM_LABELS','DATE_ENDING'),13,' ') ||
1203: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),133,' '));
1204: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
1205: FOR i in 1 .. exceptions_count LOOP
1206: FND_FILE.PUT_LINE(fnd_file.output,tab_exceptions(i));

Line 1203: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),133,' '));

1199: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
1200: FND_FILE.PUT_LINE(fnd_file.output,rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_ASSIGNMENT_NUMBER'),22,' ') ||
1201: rpad('ID',12,' ') ||
1202: rpad(hr_general.decode_lookup('NL_FORM_LABELS','DATE_ENDING'),13,' ') ||
1203: rpad(hr_general.decode_lookup('NL_FORM_LABELS','WR_EXCEPTION'),133,' '));
1204: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
1205: FOR i in 1 .. exceptions_count LOOP
1206: FND_FILE.PUT_LINE(fnd_file.output,tab_exceptions(i));
1207: FND_FILE.PUT_LINE(fnd_file.output,fnd_global.local_CHR(10));

Line 1212: FND_FILE.PUT_LINE(fnd_file.output , hr_general.decode_lookup('NL_FORM_LABELS','NOEXCEPTION'));

1208: END LOOP;
1209: FND_FILE.PUT_LINE(fnd_file.output,rpad('-',180,'-'));
1210: --
1211: ELSE
1212: FND_FILE.PUT_LINE(fnd_file.output , hr_general.decode_lookup('NL_FORM_LABELS','NOEXCEPTION'));
1213: END IF;
1214: --12608988 ends
1215: End reset_override_lastyr_sal ;
1216:

Line 1311: ELSIF l_assignment.effective_end_date <> hr_general.end_of_time THEN

1307: end if;
1308:
1309: IF p_effective_date = l_assignment.effective_start_date THEN
1310: l_datetrack_update_mode:='CORRECTION';
1311: ELSIF l_assignment.effective_end_date <> hr_general.end_of_time THEN
1312: l_datetrack_update_mode := 'UPDATE_CHANGE_INSERT';
1313: END IF; */
1314:
1315: if g_debug then