APPS.IGS_PE_USR_ARG_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

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

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.person_type
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: IF (((old_references.record_open_dt_alias = new_references.record_open_dt_alias)) OR
126: ((new_references.record_open_dt_alias IS NULL))) THEN

Line 133: app_exception.raise_exception;

129: new_references.record_open_dt_alias
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: IF (((old_references.record_cutoff_dt_alias = new_references.record_cutoff_dt_alias)) OR
137: ((new_references.record_cutoff_dt_alias IS NULL))) THEN

Line 144: app_exception.raise_exception;

140: new_references.record_cutoff_dt_alias
141: ) THEN
142: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
143: igs_ge_msg_stack.add;
144: app_exception.raise_exception;
145: END IF;
146:
147: IF (((old_references.grad_sch_dt_alias = new_references.grad_sch_dt_alias)) OR
148: ((new_references.grad_sch_dt_alias IS NULL))) THEN

Line 155: app_exception.raise_exception;

151: new_references.grad_sch_dt_alias
152: ) THEN
153: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
154: igs_ge_msg_stack.add;
155: app_exception.raise_exception;
156: END IF;
157:
158: IF (((old_references.upd_audit_dt_alias = new_references.upd_audit_dt_alias)) OR
159: ((new_references.upd_audit_dt_alias IS NULL))) THEN

Line 166: app_exception.raise_exception;

162: new_references.upd_audit_dt_alias
163: ) THEN
164: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
165: igs_ge_msg_stack.add;
166: app_exception.raise_exception;
167: END IF;
168:
169: END check_parent_existance;
170:

Line 273: app_exception.raise_exception;

269: IF (cur_rowid%FOUND) THEN
270: CLOSE cur_rowid;
271: fnd_message.set_name ('IGS', 'IGS_PE_UARGV_PTY_FK');
272: igs_ge_msg_stack.add;
273: app_exception.raise_exception;
274: RETURN;
275: END IF;
276: CLOSE cur_rowid;
277:

Line 332: app_exception.raise_exception;

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

Line 348: app_exception.raise_exception;

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

Line 404: app_exception.raise_exception;

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

Line 510: app_exception.raise_exception;

506: IF (c1%notfound) THEN
507: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
508: igs_ge_msg_stack.add;
509: CLOSE c1;
510: app_exception.raise_exception;
511: RETURN;
512: END IF;
513: CLOSE c1;
514:

Line 526: app_exception.raise_exception;

522: NULL;
523: ELSE
524: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
525: igs_ge_msg_stack.add;
526: app_exception.raise_exception;
527: END IF;
528:
529: RETURN;
530:

Line 575: app_exception.raise_exception;

571: END IF;
572: ELSE
573: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
574: igs_ge_msg_stack.add;
575: app_exception.raise_exception;
576: END IF;
577:
578: before_dml(
579: p_action => 'UPDATE',