DBA Data[Home] [Help]

APPS.IGS_UC_REF_APR_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 172: app_exception.raise_exception;

168: )
169: ) THEN
170: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
171: igs_ge_msg_stack.add;
172: app_exception.raise_exception;
173: END IF;
174: ELSIF (p_action = 'VALIDATE_INSERT') THEN
175: -- Call all the procedures related to Before Insert.
176: IF ( get_pk_for_validation (

Line 182: app_exception.raise_exception;

178: )
179: ) THEN
180: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
181: igs_ge_msg_stack.add;
182: app_exception.raise_exception;
183: END IF;
184: ELSIF (p_action = 'DELETE') THEN
185: -- Call all the procedures related to Before Delete.
186: check_child_existance;

Line 238: app_exception.raise_exception;

234: END IF;
235: ELSE
236: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
237: igs_ge_msg_stack.add;
238: app_exception.raise_exception;
239: END IF;
240:
241: /* SELECT igs_uc_ref_apr_s.NEXTVAL
242: INTO x_dom

Line 328: app_exception.raise_exception;

324: IF (c1%notfound) THEN
325: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
326: igs_ge_msg_stack.add;
327: CLOSE c1;
328: app_exception.raise_exception;
329: RETURN;
330: END IF;
331: CLOSE c1;
332:

Line 342: app_exception.raise_exception;

338: NULL;
339: ELSE
340: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
341: igs_ge_msg_stack.add;
342: app_exception.raise_exception;
343: END IF;
344:
345: RETURN;
346:

Line 389: app_exception.raise_exception;

385: END IF;
386: ELSE
387: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
388: igs_ge_msg_stack.add;
389: app_exception.raise_exception;
390: END IF;
391:
392: before_dml(
393: p_action => 'UPDATE',