APPS.IGS_OR_CWLK_DTL_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 92: app_exception.raise_exception;

88: )
89: ) THEN
90: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
91: igs_ge_msg_stack.add;
92: app_exception.raise_exception;
93: END IF;
94:
95: END check_uniqueness;
96:

Line 118: app_exception.raise_exception;

114: new_references.crosswalk_id
115: ) THEN
116: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
117: igs_ge_msg_stack.add;
118: app_exception.raise_exception;
119: END IF;
120:
121: IF (((old_references.alt_id_type = new_references.alt_id_type)) OR
122: ((new_references.alt_id_type IS NULL))) THEN

Line 129: app_exception.raise_exception;

125: new_references.alt_id_type
126: ) THEN
127: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
128: igs_ge_msg_stack.add;
129: app_exception.raise_exception;
130: END IF;
131:
132: END check_parent_existance;
133:

Line 232: app_exception.raise_exception;

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

Line 267: app_exception.raise_exception;

263: IF (cur_rowid%FOUND) THEN
264: CLOSE cur_rowid;
265: fnd_message.set_name ('IGS', 'IGS_OR_OCWD_OAI');
266: igs_ge_msg_stack.add;
267: app_exception.raise_exception;
268: RETURN;
269: END IF;
270: CLOSE cur_rowid;
271:

Line 322: app_exception.raise_exception;

318: )
319: ) THEN
320: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
321: igs_ge_msg_stack.add;
322: app_exception.raise_exception;
323: END IF;
324: check_uniqueness;
325: check_parent_existance;
326: ELSIF (p_action = 'UPDATE') THEN

Line 338: app_exception.raise_exception;

334: )
335: ) THEN
336: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
337: igs_ge_msg_stack.add;
338: app_exception.raise_exception;
339: END IF;
340: check_uniqueness;
341: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
342: check_uniqueness;

Line 408: app_exception.raise_exception;

404: END IF;
405: ELSE
406: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
407: igs_ge_msg_stack.add;
408: app_exception.raise_exception;
409: END IF;
410:
411: SELECT igs_or_cwlk_dtl_s.NEXTVAL
412: INTO x_crosswalk_dtl_id

Line 505: app_exception.raise_exception;

501: IF (c1%notfound) THEN
502: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
503: igs_ge_msg_stack.add;
504: CLOSE c1;
505: app_exception.raise_exception;
506: RETURN;
507: END IF;
508: CLOSE c1;
509:

Line 519: app_exception.raise_exception;

515: NULL;
516: ELSE
517: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
518: igs_ge_msg_stack.add;
519: app_exception.raise_exception;
520: END IF;
521:
522: RETURN;
523:

Line 570: app_exception.raise_exception;

566: END IF;
567: ELSE
568: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
569: igs_ge_msg_stack.add;
570: app_exception.raise_exception;
571: END IF;
572:
573: before_dml(
574: p_action => 'UPDATE',