APPS.IGS_PS_UNITREQREF_CD_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

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

Line 99: app_exception.raise_exception;

95: )
96: ) THEN
97: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: END IF;
101:
102: END check_uniqueness;
103:

Line 138: app_exception.raise_exception;

134: ) THEN
135: CLOSE cur_reference_cd_chk;
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: END IF;
140: END IF;
141: CLOSE cur_reference_cd_chk;
142:

Line 151: app_exception.raise_exception;

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

Line 262: app_exception.raise_exception;

258: IF (cur_rowid%FOUND) THEN
259: CLOSE cur_rowid;
260: fnd_message.set_name ('IGS', 'IGS_PS_RC_URRC_FK1');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: RETURN;
264: END IF;
265: CLOSE cur_rowid;
266:

Line 297: app_exception.raise_exception;

293: IF (cur_rowid%FOUND) THEN
294: CLOSE cur_rowid;
295: fnd_message.set_name ('IGS', 'IGS_PS_RCT_URRC_FK2');
296: igs_ge_msg_stack.add;
297: app_exception.raise_exception;
298: RETURN;
299: END IF;
300: CLOSE cur_rowid;
301:

Line 356: app_exception.raise_exception;

352: )
353: ) THEN
354: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
355: igs_ge_msg_stack.add;
356: app_exception.raise_exception;
357: END IF;
358: check_uniqueness;
359: check_parent_existance;
360: ELSIF (p_action = 'UPDATE') THEN

Line 372: app_exception.raise_exception;

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

Line 428: app_exception.raise_exception;

424: END IF;
425: ELSE
426: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
427: igs_ge_msg_stack.add;
428: app_exception.raise_exception;
429: END IF;
430:
431: SELECT igs_ps_unitreqref_cd_s.NEXTVAL
432: INTO x_unit_req_ref_cd_id

Line 527: app_exception.raise_exception;

523: IF (c1%notfound) THEN
524: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
525: igs_ge_msg_stack.add;
526: CLOSE c1;
527: app_exception.raise_exception;
528: RETURN;
529: END IF;
530: CLOSE c1;
531:

Line 547: app_exception.raise_exception;

543: NULL;
544: ELSE
545: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
546: igs_ge_msg_stack.add;
547: app_exception.raise_exception;
548: END IF;
549:
550: RETURN;
551:

Line 596: app_exception.raise_exception;

592: END IF;
593: ELSE
594: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
595: igs_ge_msg_stack.add;
596: app_exception.raise_exception;
597: END IF;
598:
599: before_dml(
600: p_action => 'UPDATE',