APPS.IGF_AW_COA_LD_PKG dependencies on APP_EXCEPTION

Line 51: app_exception.raise_exception;

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

Line 103: app_exception.raise_exception;

99: )
100: ) THEN
101: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
102: igs_ge_msg_stack.add;
103: app_exception.raise_exception;
104: END IF;
105:
106: END check_uniqueness;
107:

Line 135: app_exception.raise_exception;

131: new_references.ci_sequence_number
132: ) THEN
133: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
134: igs_ge_msg_stack.add;
135: app_exception.raise_exception;
136: END IF;
137:
138: IF (((old_references.ld_cal_type = new_references.ld_cal_type) AND
139: (old_references.ld_sequence_number = new_references.ld_sequence_number)) OR

Line 149: app_exception.raise_exception;

145: new_references.ld_sequence_number
146: ) THEN
147: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
148: igs_ge_msg_stack.add;
149: app_exception.raise_exception;
150: END IF;
151:
152: END check_parent_existance;
153:

Line 273: app_exception.raise_exception;

269: IF (cur_rowid%FOUND) THEN
270: CLOSE cur_rowid;
271: fnd_message.set_name ('IGF', 'IGF_AW_COALD_COAG_FK');
272: igs_ge_msg_stack.add;
273: app_exception.raise_exception;
274: RETURN;
275: END IF;
276: CLOSE cur_rowid;
277:

Line 310: app_exception.raise_exception;

306: IF (cur_rowid%FOUND) THEN
307: CLOSE cur_rowid;
308: fnd_message.set_name ('IGF', 'IGF_AW_COALD_CI_FK');
309: igs_ge_msg_stack.add;
310: app_exception.raise_exception;
311: RETURN;
312: END IF;
313: CLOSE cur_rowid;
314:

Line 371: app_exception.raise_exception;

367: )
368: ) THEN
369: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: END IF;
373: check_uniqueness;
374: check_parent_existance;
375: ELSIF (p_action = 'UPDATE') THEN

Line 387: app_exception.raise_exception;

383: )
384: ) THEN
385: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
386: igs_ge_msg_stack.add;
387: app_exception.raise_exception;
388: END IF;
389: check_uniqueness;
390: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
391: check_uniqueness;

Line 444: app_exception.raise_exception;

440: END IF;
441: ELSE
442: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
443: igs_ge_msg_stack.add;
444: app_exception.raise_exception;
445: END IF;
446:
447: SELECT igf_aw_coa_ld_s.NEXTVAL
448: INTO x_coald_id

Line 552: app_exception.raise_exception;

548: IF (c1%notfound) THEN
549: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
550: igs_ge_msg_stack.add;
551: CLOSE c1;
552: app_exception.raise_exception;
553: RETURN;
554: END IF;
555: CLOSE c1;
556:

Line 569: app_exception.raise_exception;

565: NULL;
566: ELSE
567: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
568: igs_ge_msg_stack.add;
569: app_exception.raise_exception;
570: END IF;
571:
572: RETURN;
573:

Line 619: app_exception.raise_exception;

615: END IF;
616: ELSE
617: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
618: igs_ge_msg_stack.add;
619: app_exception.raise_exception;
620: END IF;
621:
622: before_dml(
623: p_action => 'UPDATE',