APPS.IGS_DA_REQ_STDNTS_PKG dependencies on APP_EXCEPTION

Line 55: app_exception.raise_exception;

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

Line 108: app_exception.raise_exception;

104: new_references.program_code
105: ) THEN
106: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
107: igs_ge_msg_stack.add;
108: app_exception.raise_exception;
109: END IF;
110:
111: IF (((old_references.wif_program_code = new_references.wif_program_code)) OR
112: ((new_references.wif_program_code IS NULL))) THEN

Line 119: app_exception.raise_exception;

115: new_references.wif_program_code
116: ) THEN
117: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
118: igs_ge_msg_stack.add;
119: app_exception.raise_exception;
120: END IF;
121:
122: IF (((old_references.batch_id = new_references.batch_id) AND
123: (old_references.wif_id = new_references.wif_id)) OR

Line 133: app_exception.raise_exception;

129: new_references.wif_id
130: ) THEN
131: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134: END IF;
135:
136: END check_parent_existance;
137:

Line 202: app_exception.raise_exception;

198: IF (cur_rowid%FOUND) THEN
199: CLOSE cur_rowid;
200: fnd_message.set_name ('IGS', 'IGS_DA_REQS_PSC_FK');
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203: RETURN;
204: END IF;
205: CLOSE cur_rowid;
206:

Line 239: app_exception.raise_exception;

235: IF (cur_rowid%FOUND) THEN
236: CLOSE cur_rowid;
237: fnd_message.set_name ('IGS', 'IGS_DA_REQS_WIF_FK');
238: igs_ge_msg_stack.add;
239: app_exception.raise_exception;
240: RETURN;
241: END IF;
242: CLOSE cur_rowid;
243:

Line 369: app_exception.raise_exception;

365: )
366: ) THEN
367: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
368: igs_ge_msg_stack.add;
369: app_exception.raise_exception;
370: END IF;
371: check_parent_existance;
372: ELSIF (p_action = 'UPDATE') THEN
373: -- Call all the procedures related to Before Update.

Line 383: app_exception.raise_exception;

379: )
380: ) THEN
381: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
382: igs_ge_msg_stack.add;
383: app_exception.raise_exception;
384: END IF;
385: END IF;
386:
387: END before_dml;

Line 438: app_exception.raise_exception;

434: ELSE
435: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
436: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_STDNTS_PKG.INSERT_ROW');
437: igs_ge_msg_stack.add;
438: app_exception.raise_exception;
439: END IF;
440:
441: -- x_igs_da_req_stdnts_id := NULL;
442:

Line 558: app_exception.raise_exception;

554: IF (c1%notfound) THEN
555: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
556: igs_ge_msg_stack.add;
557: CLOSE c1;
558: app_exception.raise_exception;
559: RETURN;
560: END IF;
561: CLOSE c1;
562:

Line 578: app_exception.raise_exception;

574: NULL;
575: ELSE
576: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
577: igs_ge_msg_stack.add;
578: app_exception.raise_exception;
579: END IF;
580:
581: RETURN;
582:

Line 633: app_exception.raise_exception;

629: ELSE
630: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
631: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_STDNTS_PKG.UPDATE_ROW');
632: igs_ge_msg_stack.add;
633: app_exception.raise_exception;
634: END IF;
635:
636: -- x_igs_da_req_stdnts_id := NULL;
637: