APPS.IGS_PS_UNIT_X_GRPMEM_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 95: app_exception.raise_exception;

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

Line 121: app_exception.raise_exception;

117: new_references.unit_x_listed_group_id
118: ) THEN
119: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
120: igs_ge_msg_stack.add;
121: app_exception.raise_exception;
122: END IF;
123:
124: IF (((old_references.unit_cd = new_references.unit_cd) AND
125: (old_references.version_number = new_references.version_number)) OR

Line 135: app_exception.raise_exception;

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

Line 240: app_exception.raise_exception;

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

Line 277: app_exception.raise_exception;

273: IF (cur_rowid%FOUND) THEN
274: CLOSE cur_rowid;
275: fnd_message.set_name ('IGS', 'IGS_PS_UV_UXGM_FK2');
276: igs_ge_msg_stack.add;
277: app_exception.raise_exception;
278: RETURN;
279: END IF;
280: CLOSE cur_rowid;
281:

Line 334: app_exception.raise_exception;

330: )
331: ) THEN
332: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
333: igs_ge_msg_stack.add;
334: app_exception.raise_exception;
335: END IF;
336: check_uniqueness;
337: check_parent_existance;
338: ELSIF (p_action = 'UPDATE') THEN

Line 350: app_exception.raise_exception;

346: )
347: ) THEN
348: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
349: igs_ge_msg_stack.add;
350: app_exception.raise_exception;
351: END IF;
352: check_uniqueness;
353: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
354: check_uniqueness;

Line 405: app_exception.raise_exception;

401: END IF;
402: ELSE
403: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
404: igs_ge_msg_stack.add;
405: app_exception.raise_exception;
406: END IF;
407:
408: SELECT igs_ps_unit_x_grpmem_s.NEXTVAL
409: INTO x_unit_x_listed_group_mem_id

Line 499: app_exception.raise_exception;

495: IF (c1%notfound) THEN
496: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
497: igs_ge_msg_stack.add;
498: CLOSE c1;
499: app_exception.raise_exception;
500: RETURN;
501: END IF;
502: CLOSE c1;
503:

Line 514: app_exception.raise_exception;

510: NULL;
511: ELSE
512: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
513: igs_ge_msg_stack.add;
514: app_exception.raise_exception;
515: END IF;
516:
517: RETURN;
518:

Line 562: app_exception.raise_exception;

558: END IF;
559: ELSE
560: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
561: igs_ge_msg_stack.add;
562: app_exception.raise_exception;
563: END IF;
564:
565: before_dml(
566: p_action => 'UPDATE',