DBA Data[Home] [Help]

APPS.IGS_FI_INV_WAV_DET_PKG dependencies on APP_EXCEPTION

Line 48: app_exception.raise_exception;

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

Line 161: app_exception.raise_exception;

157: new_references.invoice_id
158: ) THEN
159: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
160: igs_ge_msg_stack.add;
161: app_exception.raise_exception;
162: END IF;
163:
164: IF (((old_references.balance_type = new_references.balance_type)) OR
165: ((new_references.balance_type IS NULL))) THEN

Line 173: app_exception.raise_exception;

169: new_references.balance_type
170: ) THEN
171: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
172: igs_ge_msg_stack.add;
173: app_exception.raise_exception;
174: END IF;
175:
176: END check_parent_existance;
177:

Line 245: app_exception.raise_exception;

241: IF (cur_rowid%FOUND) THEN
242: CLOSE cur_rowid;
243: fnd_message.set_name ('IGS', 'IGS_FI_FIW_INVI_FK');
244: igs_ge_msg_stack.add;
245: app_exception.raise_exception;
246: RETURN;
247: END IF;
248: CLOSE cur_rowid;
249:

Line 298: app_exception.raise_exception;

294: IF NOT validate_overlapping(x_invoice_id , x_balance_type ,
295: x_start_dt , x_end_dt,x_rowid ) THEN
296: fnd_message.set_name('IGS','IGS_FI_WVR_OVERLAP');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: END IF;
300: END IF;
301:
302: IF (p_action = 'INSERT') THEN

Line 312: app_exception.raise_exception;

308: )
309: ) THEN
310: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
311: igs_ge_msg_stack.add;
312: app_exception.raise_exception;
313: END IF;
314: check_parent_existance;
315: ELSIF (p_action = 'UPDATE') THEN
316: -- Call all the procedures related to Before Update.

Line 328: app_exception.raise_exception;

324: )
325: ) THEN
326: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
327: igs_ge_msg_stack.add;
328: app_exception.raise_exception;
329: END IF;
330: END IF;
331:
332: END before_dml;

Line 397: app_exception.raise_exception;

393: END IF;
394: ELSE
395: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
396: igs_ge_msg_stack.add;
397: app_exception.raise_exception;
398: END IF;
399:
400: before_dml(
401: p_action => 'INSERT',

Line 488: app_exception.raise_exception;

484: IF (c1%notfound) THEN
485: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
486: igs_ge_msg_stack.add;
487: CLOSE c1;
488: app_exception.raise_exception;
489: RETURN;
490: END IF;
491: CLOSE c1;
492:

Line 500: app_exception.raise_exception;

496: NULL;
497: ELSE
498: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
499: igs_ge_msg_stack.add;
500: app_exception.raise_exception;
501: END IF;
502:
503: RETURN;
504:

Line 551: app_exception.raise_exception;

547: END IF;
548: ELSE
549: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
550: igs_ge_msg_stack.add;
551: app_exception.raise_exception;
552: END IF;
553:
554: before_dml(
555: p_action => 'UPDATE',