DBA Data[Home] [Help]

APPS.IGS_FI_REFUND_SETUP_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;
52: CLOSE cur_old_ref_values;
53:

Line 202: app_exception.raise_exception;

198: )
199: ) THEN
200: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203: END IF;
204:
205: --Start date should be greater then sysdate date.
206: IF new_references.start_date < l_sysdate THEN

Line 209: app_exception.raise_exception;

205: --Start date should be greater then sysdate date.
206: IF new_references.start_date < l_sysdate THEN
207: fnd_message.set_name('IGS','IGS_FI_EFF_DATE');
208: igs_ge_msg_stack.add;
209: app_exception.raise_exception;
210:
211: END IF;
212:
213: --End date should be greater then sysdate date.

Line 218: app_exception.raise_exception;

214: IF new_references.end_date IS NOT NULL THEN
215: IF new_references.end_date < l_sysdate THEN
216: fnd_message.set_name('IGS','IGS_FI_END_DT_LESS_THAN_SD');
217: igs_ge_msg_stack.add;
218: app_exception.raise_exception;
219: END IF;
220: END IF;
221:
222: --upper limit should be positive.

Line 228: app_exception.raise_exception;

224: IF new_references.amount_high IS NOT NULL THEN
225: IF new_references.amount_high < 0 THEN
226: fnd_message.set_name('IGS','IGS_FI_REFUND_AMNT_NEGATIVE');
227: igs_ge_msg_stack.add;
228: app_exception.raise_exception;
229: END IF;
230: END IF;
231:
232: --lower limit should be positive.

Line 237: app_exception.raise_exception;

233: IF new_references.amount_low IS NOT NULL THEN
234: IF new_references.amount_low < 0 THEN
235: fnd_message.set_name('IGS','IGS_FI_REFUND_AMNT_NEGATIVE');
236: igs_ge_msg_stack.add;
237: app_exception.raise_exception;
238: END IF;
239: END IF;
240:
241: --start date should be lesser than end date

Line 246: app_exception.raise_exception;

242: IF new_references.end_date IS NOT NULL THEN
243: IF new_references.end_date < new_references.start_date THEN
244: fnd_message.set_name('IGS','IGS_FI_END_DT_LESS_THAN_ST_DT');
245: igs_ge_msg_stack.add;
246: app_exception.raise_exception;
247: END IF;
248: END IF;
249:
250: --Upper and lower limit both should not be null.

Line 254: app_exception.raise_exception;

250: --Upper and lower limit both should not be null.
251: IF new_references.amount_high IS NULL AND new_references.amount_low IS NULL THEN
252: fnd_message.set_name('IGS','IGS_FI_REFUND_LMT_NULL');
253: igs_ge_msg_stack.add;
254: app_exception.raise_exception;
255: ELSE
256: --lower limit should be less than upper limit.
257: IF new_references.amount_high IS NOT NULL AND new_references.amount_low IS NOT NULL THEN
258: IF new_references.amount_low > new_references.amount_high THEN

Line 262: app_exception.raise_exception;

258: IF new_references.amount_low > new_references.amount_high THEN
259:
260: fnd_message.set_name('IGS','IGS_FI_RFND_AMNT_INVALID');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: END IF;
264: END IF;
265: END IF;
266:

Line 277: app_exception.raise_exception;

273: ) THEN
274: -- Removed the space after the message name as per Bug# 2684818 by shtatiko
275: fnd_message.set_name('IGS','IGS_FI_RFND_TOL_OVERLAP');
276: igs_ge_msg_stack.add;
277: app_exception.raise_exception;
278: END IF;
279:
280:
281: ELSIF (p_updating) THEN

Line 289: app_exception.raise_exception;

285: IF new_references.end_date IS NOT NULL THEN
286: IF new_references.end_date < new_references.start_date THEN
287: fnd_message.set_name('IGS','IGS_FI_END_DT_LESS_THAN_ST_DT');
288: igs_ge_msg_stack.add;
289: app_exception.raise_exception;
290: END IF;
291: END IF;
292:
293:

Line 299: app_exception.raise_exception;

295: IF new_references.end_date IS NOT NULL THEN
296: IF new_references.end_date < l_sysdate THEN
297: fnd_message.set_name('IGS','IGS_FI_END_DT_LESS_THAN_SD');
298: igs_ge_msg_stack.add;
299: app_exception.raise_exception;
300: END IF;
301: END IF;
302:
303:

Line 313: app_exception.raise_exception;

309: )
310: ) THEN
311: fnd_message.set_name('IGS','IGS_FI_RFND_TOL_OVERLAP');
312: igs_ge_msg_stack.add;
313: app_exception.raise_exception;
314: END IF;
315:
316: END IF;
317: END beforerowinsertupdate;

Line 418: app_exception.raise_exception;

414: END IF;
415: ELSE
416: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
417: igs_ge_msg_stack.add;
418: app_exception.raise_exception;
419: END IF;
420:
421: SELECT igs_fi_refund_setup_s.NEXTVAL
422: INTO x_refund_setup_id

Line 512: app_exception.raise_exception;

508: IF (c1%notfound) THEN
509: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
510: igs_ge_msg_stack.add;
511: CLOSE c1;
512: app_exception.raise_exception;
513: RETURN;
514: END IF;
515: CLOSE c1;
516:

Line 527: app_exception.raise_exception;

523: NULL;
524: ELSE
525: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: END IF;
529:
530: RETURN;
531:

Line 575: app_exception.raise_exception;

571: END IF;
572: ELSE
573: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
574: igs_ge_msg_stack.add;
575: app_exception.raise_exception;
576: END IF;
577:
578: before_dml(
579: p_action => 'UPDATE',