DBA Data[Home] [Help]

APPS.PER_ASSIGNMENTS_F1_PKG dependencies on FND_MESSAGE

Line 136: fnd_message.set_name('PAY',

132: FETCH csr_get_term_dates into l_fin_proc_date;
133: if (csr_get_term_dates%notfound) or
134: (p_new_end_date <> l_fin_proc_date) then
135: CLOSE csr_get_term_dates;
136: fnd_message.set_name('PAY',
137: 'HR_6438_EMP_ASS_NOT_CONTIN');
138: fnd_message.raise_error;
139: end if;
140: close csr_get_term_dates;

Line 138: fnd_message.raise_error;

134: (p_new_end_date <> l_fin_proc_date) then
135: CLOSE csr_get_term_dates;
136: fnd_message.set_name('PAY',
137: 'HR_6438_EMP_ASS_NOT_CONTIN');
138: fnd_message.raise_error;
139: end if;
140: close csr_get_term_dates;
141: end if;
142: --

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

278: END IF;
279:
280: For x in c_seg(l_flexnum) loop
281:
282: --fnd_message.debug('Date Format: '||l_dateformat);
283: -- fnd_message.debug('Format : '||x.format_type ||'Seg' ||l_ch_seg(i));
284: if x.format_type in ('X') then
285: l_ch_seg(i) := to_char(to_date(l_ch_seg(i), l_dateformat),'DD-MON-RRRR');
286: --fnd_message.debug('Format :' || l_ch_seg(i));

Line 283: -- fnd_message.debug('Format : '||x.format_type ||'Seg' ||l_ch_seg(i));

279:
280: For x in c_seg(l_flexnum) loop
281:
282: --fnd_message.debug('Date Format: '||l_dateformat);
283: -- fnd_message.debug('Format : '||x.format_type ||'Seg' ||l_ch_seg(i));
284: if x.format_type in ('X') then
285: l_ch_seg(i) := to_char(to_date(l_ch_seg(i), l_dateformat),'DD-MON-RRRR');
286: --fnd_message.debug('Format :' || l_ch_seg(i));
287: elsif x.format_type in ('Y') then

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

282: --fnd_message.debug('Date Format: '||l_dateformat);
283: -- fnd_message.debug('Format : '||x.format_type ||'Seg' ||l_ch_seg(i));
284: if x.format_type in ('X') then
285: l_ch_seg(i) := to_char(to_date(l_ch_seg(i), l_dateformat),'DD-MON-RRRR');
286: --fnd_message.debug('Format :' || l_ch_seg(i));
287: elsif x.format_type in ('Y') then
288: -- fnd_message.debug ('date format '||l_dateformat);
289: -- fnd_message.debug('Length '||length(l_ch_seg(i)));
290: l_ch_seg(i):= to_char(to_date(l_ch_seg(i),l_dateformat||' HH24:MI:SS'),'DD-MON-RRRR HH24:MI:SS');

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

284: if x.format_type in ('X') then
285: l_ch_seg(i) := to_char(to_date(l_ch_seg(i), l_dateformat),'DD-MON-RRRR');
286: --fnd_message.debug('Format :' || l_ch_seg(i));
287: elsif x.format_type in ('Y') then
288: -- fnd_message.debug ('date format '||l_dateformat);
289: -- fnd_message.debug('Length '||length(l_ch_seg(i)));
290: l_ch_seg(i):= to_char(to_date(l_ch_seg(i),l_dateformat||' HH24:MI:SS'),'DD-MON-RRRR HH24:MI:SS');
291: end if;
292:

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

285: l_ch_seg(i) := to_char(to_date(l_ch_seg(i), l_dateformat),'DD-MON-RRRR');
286: --fnd_message.debug('Format :' || l_ch_seg(i));
287: elsif x.format_type in ('Y') then
288: -- fnd_message.debug ('date format '||l_dateformat);
289: -- fnd_message.debug('Length '||length(l_ch_seg(i)));
290: l_ch_seg(i):= to_char(to_date(l_ch_seg(i),l_dateformat||' HH24:MI:SS'),'DD-MON-RRRR HH24:MI:SS');
291: end if;
292:
293: i := i + 1;

Line 314: fnd_message.set_name('PAY',

310: -- called and people_group_name has not changed
311: --
312: /*
313: if sql%rowcount = 0 then
314: fnd_message.set_name('PAY',
315: 'HR_6153_ALL_PROCEDURE_FAIL');
316: fnd_message.set_token('PROCEDURE',
317: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_GROUP');
318: fnd_message.set_token('STEP', '1');

Line 316: fnd_message.set_token('PROCEDURE',

312: /*
313: if sql%rowcount = 0 then
314: fnd_message.set_name('PAY',
315: 'HR_6153_ALL_PROCEDURE_FAIL');
316: fnd_message.set_token('PROCEDURE',
317: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_GROUP');
318: fnd_message.set_token('STEP', '1');
319: fnd_message.raise_error;
320: end if;

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

314: fnd_message.set_name('PAY',
315: 'HR_6153_ALL_PROCEDURE_FAIL');
316: fnd_message.set_token('PROCEDURE',
317: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_GROUP');
318: fnd_message.set_token('STEP', '1');
319: fnd_message.raise_error;
320: end if;
321: */
322: end if;

Line 319: fnd_message.raise_error;

315: 'HR_6153_ALL_PROCEDURE_FAIL');
316: fnd_message.set_token('PROCEDURE',
317: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_GROUP');
318: fnd_message.set_token('STEP', '1');
319: fnd_message.raise_error;
320: end if;
321: */
322: end if;
323: --

Line 486: fnd_message.set_name('PAY',

482: set concatenated_segments = p_scl_concat
483: where soft_coding_keyflex_id = p_scl_id;
484: --
485: if sql%rowcount = 0 then
486: fnd_message.set_name('PAY',
487: 'HR_6153_ALL_PROCEDURE_FAIL');
488: fnd_message.set_token('PROCEDURE',
489: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_SCL');
490: fnd_message.set_token('STEP', '1');

Line 488: fnd_message.set_token('PROCEDURE',

484: --
485: if sql%rowcount = 0 then
486: fnd_message.set_name('PAY',
487: 'HR_6153_ALL_PROCEDURE_FAIL');
488: fnd_message.set_token('PROCEDURE',
489: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_SCL');
490: fnd_message.set_token('STEP', '1');
491: fnd_message.raise_error;
492: end if;

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

486: fnd_message.set_name('PAY',
487: 'HR_6153_ALL_PROCEDURE_FAIL');
488: fnd_message.set_token('PROCEDURE',
489: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_SCL');
490: fnd_message.set_token('STEP', '1');
491: fnd_message.raise_error;
492: end if;
493: end if;
494: --

Line 491: fnd_message.raise_error;

487: 'HR_6153_ALL_PROCEDURE_FAIL');
488: fnd_message.set_token('PROCEDURE',
489: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_SCL');
490: fnd_message.set_token('STEP', '1');
491: fnd_message.raise_error;
492: end if;
493: end if;
494: --
495: end update_scl; */

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

1243: fetch csr_min_spp_date into l_min_start_date;
1244: --
1245: if l_min_start_date > p_val_st_date then
1246: --
1247: fnd_message.set_name('PER', 'HR_289771_SPP_MIN_START_DATE');
1248: hr_utility.raise_error;
1249: --
1250: end if;
1251: --