APPS.IGS_PE_HZ_PARTY_REL_PKG dependencies on APP_EXCEPTION

Line 46: app_exception.raise_exception;

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

Line 148: app_exception.raise_exception;

144: )
145: ) THEN
146: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
147: igs_ge_msg_stack.add;
148: app_exception.raise_exception;
149: END IF;
150: ELSIF (p_action = 'VALIDATE_INSERT') THEN
151: -- Call all the procedures related to Before Insert.
152: IF ( get_pk_for_validation (

Line 158: app_exception.raise_exception;

154: )
155: ) THEN
156: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
157: igs_ge_msg_stack.add;
158: app_exception.raise_exception;
159: END IF;
160: END IF;
161:
162: END before_dml;

Line 223: app_exception.raise_exception;

219: END IF;
220: ELSE
221: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
222: igs_ge_msg_stack.add;
223: app_exception.raise_exception;
224: END IF;
225:
226: before_dml(
227: p_action => 'INSERT',

Line 287: app_exception.raise_exception;

283: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
284: fnd_message.set_token ('ERR_CD', SQLCODE);
285: igs_ge_msg_stack.add;
286: igs_sc_gen_001.unset_ctx('R');
287: app_exception.raise_exception;
288: ELSE
289: igs_sc_gen_001.unset_ctx('R');
290: RAISE;
291: END IF;

Line 326: app_exception.raise_exception;

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

Line 338: app_exception.raise_exception;

334: NULL;
335: ELSE
336: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
337: igs_ge_msg_stack.add;
338: app_exception.raise_exception;
339: END IF;
340:
341: RETURN;
342:

Line 387: app_exception.raise_exception;

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

Line 435: app_exception.raise_exception;

431: IF (SQL%NOTFOUND) THEN
432: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
433: igs_ge_msg_stack.add;
434: igs_sc_gen_001.unset_ctx('R');
435: app_exception.raise_exception;
436: END IF;
437: IF (x_mode = 'S') THEN
438: igs_sc_gen_001.unset_ctx('R');
439: END IF;

Line 450: app_exception.raise_exception;

446: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
447: fnd_message.set_token ('ERR_CD', SQLCODE);
448: igs_ge_msg_stack.add;
449: igs_sc_gen_001.unset_ctx('R');
450: app_exception.raise_exception;
451: ELSE
452: igs_sc_gen_001.unset_ctx('R');
453: RAISE;
454: END IF;

Line 535: app_exception.raise_exception;

531: IF (SQL%NOTFOUND) THEN
532: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
533: igs_ge_msg_stack.add;
534: igs_sc_gen_001.unset_ctx('R');
535: app_exception.raise_exception;
536: END IF;
537: IF (x_mode = 'S') THEN
538: igs_sc_gen_001.unset_ctx('R');
539: END IF;