DBA Data[Home] [Help]

APPS.PER_ASSIGNMENTS_F1_PKG dependencies on FND_MESSAGE

Line 146: fnd_message.set_name('PAY',

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;

Line 148: fnd_message.raise_error;

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

Line 318: --fnd_message.debug('Date Format: '||l_dateformat);

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));

Line 319: -- fnd_message.debug('Format : '||x.format_type ||'Seg' ||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

Line 322: --fnd_message.debug('Format :' || l_ch_seg(i));

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');

Line 324: -- fnd_message.debug ('date format '||l_dateformat);

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:

Line 325: -- fnd_message.debug('Length '||length(l_ch_seg(i)));

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;

Line 350: fnd_message.set_name('PAY',

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');

Line 352: fnd_message.set_token('PROCEDURE',

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;

Line 354: fnd_message.set_token('STEP', '1');

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;

Line 355: fnd_message.raise_error;

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

Line 539: fnd_message.set_name('PAY',

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');

Line 541: fnd_message.set_token('PROCEDURE',

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;

Line 543: fnd_message.set_token('STEP', '1');

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

Line 544: fnd_message.raise_error;

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; */

Line 1326: fnd_message.set_name('PER', 'HR_289771_SPP_MIN_START_DATE');

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