APPS.IGS_HE_POOUS_OU_CC_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

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

Line 96: app_exception.raise_exception;

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

Line 122: app_exception.raise_exception;

118: new_references.hesa_poous_ou_id
119: ) THEN
120: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
121: igs_ge_msg_stack.add;
122: app_exception.raise_exception;
123: END IF;
124:
125: END check_parent_existance;
126:

Line 229: app_exception.raise_exception;

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

Line 286: app_exception.raise_exception;

282: )
283: ) THEN
284: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
285: igs_ge_msg_stack.add;
286: app_exception.raise_exception;
287: END IF;
288: check_uniqueness;
289: check_parent_existance;
290: ELSIF (p_action = 'UPDATE') THEN

Line 302: app_exception.raise_exception;

298: )
299: ) THEN
300: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
301: igs_ge_msg_stack.add;
302: app_exception.raise_exception;
303: END IF;
304: check_uniqueness;
305: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
306: check_uniqueness;

Line 354: app_exception.raise_exception;

350: ELSE
351: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
352: fnd_message.set_token ('ROUTINE', 'IGS_HE_POOUS_OU_CC_PKG.INSERT_ROW');
353: igs_ge_msg_stack.add;
354: app_exception.raise_exception;
355: END IF;
356:
357: x_hesa_poous_cc_id := NULL;
358:

Line 438: app_exception.raise_exception;

434: IF (c1%notfound) THEN
435: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
436: igs_ge_msg_stack.add;
437: CLOSE c1;
438: app_exception.raise_exception;
439: RETURN;
440: END IF;
441: CLOSE c1;
442:

Line 453: app_exception.raise_exception;

449: NULL;
450: ELSE
451: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
452: igs_ge_msg_stack.add;
453: app_exception.raise_exception;
454: END IF;
455:
456: RETURN;
457:

Line 502: app_exception.raise_exception;

498: ELSE
499: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
500: fnd_message.set_token ('ROUTINE', 'IGS_HE_POOUS_OU_CC_PKG.UPDATE_ROW');
501: igs_ge_msg_stack.add;
502: app_exception.raise_exception;
503: END IF;
504:
505: before_dml(
506: p_action => 'UPDATE',