DBA Data[Home] [Help]

APPS.PQP_ABSENCE_PLAN_PROCESS dependencies on FND_MESSAGE

Line 168: fnd_message.set_name('PQP', 'PQP_230183_ABS_OVERLAP');

164: OPEN csr_absence_type(l_absence_dates.absence_attendance_type_id);
165: FETCH csr_absence_type INTO l_absence_type ;
166: CLOSE csr_absence_type ;
167:
168: fnd_message.set_name('PQP', 'PQP_230183_ABS_OVERLAP');
169: fnd_message.set_token('ABSTYPE',l_absence_type.name);
170: fnd_message.set_token('STARTDATE',l_absence_dates.date_start);
171: fnd_message.set_token('ENDDATE',l_absence_dates.date_end);
172: fnd_message.raise_error ;

Line 169: fnd_message.set_token('ABSTYPE',l_absence_type.name);

165: FETCH csr_absence_type INTO l_absence_type ;
166: CLOSE csr_absence_type ;
167:
168: fnd_message.set_name('PQP', 'PQP_230183_ABS_OVERLAP');
169: fnd_message.set_token('ABSTYPE',l_absence_type.name);
170: fnd_message.set_token('STARTDATE',l_absence_dates.date_start);
171: fnd_message.set_token('ENDDATE',l_absence_dates.date_end);
172: fnd_message.raise_error ;
173: END IF ;

Line 170: fnd_message.set_token('STARTDATE',l_absence_dates.date_start);

166: CLOSE csr_absence_type ;
167:
168: fnd_message.set_name('PQP', 'PQP_230183_ABS_OVERLAP');
169: fnd_message.set_token('ABSTYPE',l_absence_type.name);
170: fnd_message.set_token('STARTDATE',l_absence_dates.date_start);
171: fnd_message.set_token('ENDDATE',l_absence_dates.date_end);
172: fnd_message.raise_error ;
173: END IF ;
174:

Line 171: fnd_message.set_token('ENDDATE',l_absence_dates.date_end);

167:
168: fnd_message.set_name('PQP', 'PQP_230183_ABS_OVERLAP');
169: fnd_message.set_token('ABSTYPE',l_absence_type.name);
170: fnd_message.set_token('STARTDATE',l_absence_dates.date_start);
171: fnd_message.set_token('ENDDATE',l_absence_dates.date_end);
172: fnd_message.raise_error ;
173: END IF ;
174:
175:

Line 172: fnd_message.raise_error ;

168: fnd_message.set_name('PQP', 'PQP_230183_ABS_OVERLAP');
169: fnd_message.set_token('ABSTYPE',l_absence_type.name);
170: fnd_message.set_token('STARTDATE',l_absence_dates.date_start);
171: fnd_message.set_token('ENDDATE',l_absence_dates.date_end);
172: fnd_message.raise_error ;
173: END IF ;
174:
175:
176: IF p_legislation_code = 'GB'

Line 223: fnd_message.raise_error;

219: THEN
220: debug('Leaving: ' || l_proc_name, -999);
221: END IF;
222:
223: fnd_message.raise_error;
224: ELSE
225: RAISE;
226: END IF;
227: END create_absence_plan_details ;

Line 294: -- fnd_message.set_name('PQP', 'PQP_230183_ABS_OVERLAP');

290: -- OPEN csr_absence_type(l_absence_dates.absence_attendance_type_id);
291: -- FETCH csr_absence_type INTO l_absence_type ;
292: -- CLOSE csr_absence_type ;
293:
294: -- fnd_message.set_name('PQP', 'PQP_230183_ABS_OVERLAP');
295: -- fnd_message.set_token('ABSTYPE',l_absence_type.name);
296: -- fnd_message.set_token('STARTDATE',l_absence_dates.date_start);
297: -- fnd_message.set_token('ENDDATE',l_absence_dates.date_end);
298: -- fnd_message.raise_error ;

Line 295: -- fnd_message.set_token('ABSTYPE',l_absence_type.name);

291: -- FETCH csr_absence_type INTO l_absence_type ;
292: -- CLOSE csr_absence_type ;
293:
294: -- fnd_message.set_name('PQP', 'PQP_230183_ABS_OVERLAP');
295: -- fnd_message.set_token('ABSTYPE',l_absence_type.name);
296: -- fnd_message.set_token('STARTDATE',l_absence_dates.date_start);
297: -- fnd_message.set_token('ENDDATE',l_absence_dates.date_end);
298: -- fnd_message.raise_error ;
299: -- END IF ;

Line 296: -- fnd_message.set_token('STARTDATE',l_absence_dates.date_start);

292: -- CLOSE csr_absence_type ;
293:
294: -- fnd_message.set_name('PQP', 'PQP_230183_ABS_OVERLAP');
295: -- fnd_message.set_token('ABSTYPE',l_absence_type.name);
296: -- fnd_message.set_token('STARTDATE',l_absence_dates.date_start);
297: -- fnd_message.set_token('ENDDATE',l_absence_dates.date_end);
298: -- fnd_message.raise_error ;
299: -- END IF ;
300:

Line 297: -- fnd_message.set_token('ENDDATE',l_absence_dates.date_end);

293:
294: -- fnd_message.set_name('PQP', 'PQP_230183_ABS_OVERLAP');
295: -- fnd_message.set_token('ABSTYPE',l_absence_type.name);
296: -- fnd_message.set_token('STARTDATE',l_absence_dates.date_start);
297: -- fnd_message.set_token('ENDDATE',l_absence_dates.date_end);
298: -- fnd_message.raise_error ;
299: -- END IF ;
300:
301:

Line 298: -- fnd_message.raise_error ;

294: -- fnd_message.set_name('PQP', 'PQP_230183_ABS_OVERLAP');
295: -- fnd_message.set_token('ABSTYPE',l_absence_type.name);
296: -- fnd_message.set_token('STARTDATE',l_absence_dates.date_start);
297: -- fnd_message.set_token('ENDDATE',l_absence_dates.date_end);
298: -- fnd_message.raise_error ;
299: -- END IF ;
300:
301:
302: IF p_legislation_code = 'GB'

Line 349: fnd_message.raise_error;

345: THEN
346: debug('Leaving: ' || l_proc_name, -999);
347: END IF;
348:
349: fnd_message.raise_error;
350: ELSE
351: RAISE;
352: END IF;
353: END update_absence_plan_details;

Line 429: fnd_message.raise_error;

425: THEN
426: debug('Leaving: ' || l_proc_name, -999);
427: END IF;
428:
429: fnd_message.raise_error;
430: ELSE
431: RAISE;
432: END IF;
433: END delete_absence_plan_details;

Line 493: fnd_message.raise_error;

489: THEN
490: debug('Leaving: ' || l_proc_name, -999);
491: END IF;
492:
493: fnd_message.raise_error;
494: ELSE
495: RAISE;
496: END IF;
497:

Line 573: fnd_message.raise_error;

569: THEN
570: debug('Leaving: ' || l_proc_name, -999);
571: END IF;
572:
573: fnd_message.raise_error;
574: ELSE
575: RAISE;
576: END IF;
577: