142: FETCH csr_get_term_dates into l_fin_proc_date;
143: if (csr_get_term_dates%notfound) or
144: (p_new_end_date <> l_fin_proc_date) then
145: CLOSE csr_get_term_dates;
146: fnd_message.set_name('PAY',
147: 'HR_6438_EMP_ASS_NOT_CONTIN');
148: fnd_message.raise_error;
149: end if;
150: close csr_get_term_dates;
144: (p_new_end_date <> l_fin_proc_date) then
145: CLOSE csr_get_term_dates;
146: fnd_message.set_name('PAY',
147: 'HR_6438_EMP_ASS_NOT_CONTIN');
148: fnd_message.raise_error;
149: end if;
150: close csr_get_term_dates;
151: end if;
152: --
314: END IF;
315:
316: For x in c_seg(l_flexnum) loop
317:
318: --fnd_message.debug('Date Format: '||l_dateformat);
319: -- fnd_message.debug('Format : '||x.format_type ||'Seg' ||l_ch_seg(i));
320: if x.format_type in ('X') then
321: l_ch_seg(i) := to_char(to_date(l_ch_seg(i), l_dateformat),'DD-MON-RRRR');
322: --fnd_message.debug('Format :' || l_ch_seg(i));
315:
316: For x in c_seg(l_flexnum) loop
317:
318: --fnd_message.debug('Date Format: '||l_dateformat);
319: -- fnd_message.debug('Format : '||x.format_type ||'Seg' ||l_ch_seg(i));
320: if x.format_type in ('X') then
321: l_ch_seg(i) := to_char(to_date(l_ch_seg(i), l_dateformat),'DD-MON-RRRR');
322: --fnd_message.debug('Format :' || l_ch_seg(i));
323: elsif x.format_type in ('Y') then
318: --fnd_message.debug('Date Format: '||l_dateformat);
319: -- fnd_message.debug('Format : '||x.format_type ||'Seg' ||l_ch_seg(i));
320: if x.format_type in ('X') then
321: l_ch_seg(i) := to_char(to_date(l_ch_seg(i), l_dateformat),'DD-MON-RRRR');
322: --fnd_message.debug('Format :' || l_ch_seg(i));
323: elsif x.format_type in ('Y') then
324: -- fnd_message.debug ('date format '||l_dateformat);
325: -- fnd_message.debug('Length '||length(l_ch_seg(i)));
326: l_ch_seg(i):= to_char(to_date(l_ch_seg(i),l_dateformat||' HH24:MI:SS'),'DD-MON-RRRR HH24:MI:SS');
320: if x.format_type in ('X') then
321: l_ch_seg(i) := to_char(to_date(l_ch_seg(i), l_dateformat),'DD-MON-RRRR');
322: --fnd_message.debug('Format :' || l_ch_seg(i));
323: elsif x.format_type in ('Y') then
324: -- fnd_message.debug ('date format '||l_dateformat);
325: -- fnd_message.debug('Length '||length(l_ch_seg(i)));
326: l_ch_seg(i):= to_char(to_date(l_ch_seg(i),l_dateformat||' HH24:MI:SS'),'DD-MON-RRRR HH24:MI:SS');
327: end if;
328:
321: l_ch_seg(i) := to_char(to_date(l_ch_seg(i), l_dateformat),'DD-MON-RRRR');
322: --fnd_message.debug('Format :' || l_ch_seg(i));
323: elsif x.format_type in ('Y') then
324: -- fnd_message.debug ('date format '||l_dateformat);
325: -- fnd_message.debug('Length '||length(l_ch_seg(i)));
326: l_ch_seg(i):= to_char(to_date(l_ch_seg(i),l_dateformat||' HH24:MI:SS'),'DD-MON-RRRR HH24:MI:SS');
327: end if;
328:
329: i := i + 1;
346: -- called and people_group_name has not changed
347: --
348: /*
349: if sql%rowcount = 0 then
350: fnd_message.set_name('PAY',
351: 'HR_6153_ALL_PROCEDURE_FAIL');
352: fnd_message.set_token('PROCEDURE',
353: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_GROUP');
354: fnd_message.set_token('STEP', '1');
348: /*
349: if sql%rowcount = 0 then
350: fnd_message.set_name('PAY',
351: 'HR_6153_ALL_PROCEDURE_FAIL');
352: fnd_message.set_token('PROCEDURE',
353: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_GROUP');
354: fnd_message.set_token('STEP', '1');
355: fnd_message.raise_error;
356: end if;
350: fnd_message.set_name('PAY',
351: 'HR_6153_ALL_PROCEDURE_FAIL');
352: fnd_message.set_token('PROCEDURE',
353: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_GROUP');
354: fnd_message.set_token('STEP', '1');
355: fnd_message.raise_error;
356: end if;
357: */
358: end if;
351: 'HR_6153_ALL_PROCEDURE_FAIL');
352: fnd_message.set_token('PROCEDURE',
353: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_GROUP');
354: fnd_message.set_token('STEP', '1');
355: fnd_message.raise_error;
356: end if;
357: */
358: end if;
359: --
535: set concatenated_segments = p_scl_concat
536: where soft_coding_keyflex_id = p_scl_id;
537: --
538: if sql%rowcount = 0 then
539: fnd_message.set_name('PAY',
540: 'HR_6153_ALL_PROCEDURE_FAIL');
541: fnd_message.set_token('PROCEDURE',
542: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_SCL');
543: fnd_message.set_token('STEP', '1');
537: --
538: if sql%rowcount = 0 then
539: fnd_message.set_name('PAY',
540: 'HR_6153_ALL_PROCEDURE_FAIL');
541: fnd_message.set_token('PROCEDURE',
542: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_SCL');
543: fnd_message.set_token('STEP', '1');
544: fnd_message.raise_error;
545: end if;
539: fnd_message.set_name('PAY',
540: 'HR_6153_ALL_PROCEDURE_FAIL');
541: fnd_message.set_token('PROCEDURE',
542: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_SCL');
543: fnd_message.set_token('STEP', '1');
544: fnd_message.raise_error;
545: end if;
546: end if;
547: --
540: 'HR_6153_ALL_PROCEDURE_FAIL');
541: fnd_message.set_token('PROCEDURE',
542: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_SCL');
543: fnd_message.set_token('STEP', '1');
544: fnd_message.raise_error;
545: end if;
546: end if;
547: --
548: end update_scl; */
1322: fetch csr_min_spp_date into l_min_start_date;
1323: --
1324: if l_min_start_date > p_val_st_date then
1325: --
1326: fnd_message.set_name('PER', 'HR_289771_SPP_MIN_START_DATE');
1327: hr_utility.raise_error;
1328: --
1329: end if;
1330: --