APPS.IGS_HE_SUB_RTN_CAL_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 106: app_exception.raise_exception;

102: new_references.return_name
103: ) THEN
104: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
105: igs_ge_msg_stack.add;
106: app_exception.raise_exception;
107: END IF;
108:
109: IF (((old_references.cal_type = new_references.cal_type) AND
110: (old_references.ci_sequence_number = new_references.ci_sequence_number)) OR

Line 193: app_exception.raise_exception;

189: IF (cur_rowid%FOUND) THEN
190: CLOSE cur_rowid;
191: fnd_message.set_name ('IGS', 'IGS_HE_HESBRTCL_HESBRET_FK');
192: igs_ge_msg_stack.add;
193: app_exception.raise_exception;
194: RETURN;
195: END IF;
196: CLOSE cur_rowid;
197:

Line 230: app_exception.raise_exception;

226: IF (cur_rowid%FOUND) THEN
227: CLOSE cur_rowid;
228: fnd_message.set_name ('IGS', 'IGS_HE_HESBRTCL_CI_FK');
229: igs_ge_msg_stack.add;
230: app_exception.raise_exception;
231: RETURN;
232: END IF;
233: CLOSE cur_rowid;
234:

Line 295: app_exception.raise_exception;

291: )
292: ) THEN
293: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: END IF;
297: check_parent_existance;
298: ELSIF (p_action = 'UPDATE') THEN
299: -- Call all the procedures related to Before Update.

Line 313: app_exception.raise_exception;

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

Line 371: app_exception.raise_exception;

367: END IF;
368: ELSE
369: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: END IF;
373:
374: SELECT igs_he_sub_rtn_cal_s.NEXTVAL
375: INTO x_sub_rtn_cal_id

Line 471: app_exception.raise_exception;

467: IF (c1%notfound) THEN
468: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
469: igs_ge_msg_stack.add;
470: CLOSE c1;
471: app_exception.raise_exception;
472: RETURN;
473: END IF;
474: CLOSE c1;
475:

Line 484: app_exception.raise_exception;

480: NULL;
481: ELSE
482: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
483: igs_ge_msg_stack.add;
484: app_exception.raise_exception;
485: END IF;
486:
487: RETURN;
488:

Line 534: app_exception.raise_exception;

530: END IF;
531: ELSE
532: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
533: igs_ge_msg_stack.add;
534: app_exception.raise_exception;
535: END IF;
536:
537: before_dml(
538: p_action => 'UPDATE',