APPS.IGS_AD_PNMEMBR_NOTS_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 97: app_exception.raise_exception;

93: new_references.member_person_id
94: ) THEN
95: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
96: igs_ge_msg_stack.add;
97: app_exception.raise_exception;
98: END IF;
99:
100: END check_parent_existance;
101:

Line 171: app_exception.raise_exception;

167: IF (cur_rowid%FOUND) THEN
168: CLOSE cur_rowid;
169: fnd_message.set_name ('IGS', 'IGS_AD_PNMEMBR_NOTS_FK');
170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: RETURN;
173: END IF;
174: CLOSE cur_rowid;
175:

Line 228: app_exception.raise_exception;

224: )
225: ) THEN
226: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
227: igs_ge_msg_stack.add;
228: app_exception.raise_exception;
229: END IF;
230: check_parent_existance;
231: ELSIF (p_action = 'UPDATE') THEN
232: -- Call all the procedures related to Before Update.

Line 244: app_exception.raise_exception;

240: )
241: ) THEN
242: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
243: igs_ge_msg_stack.add;
244: app_exception.raise_exception;
245: END IF;
246: END IF;
247:
248: END before_dml;

Line 292: app_exception.raise_exception;

288: ELSE
289: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
290: fnd_message.set_token ('ROUTINE', 'IGS_AD_PNMEMBR_NOTS_PKG.INSERT_ROW');
291: igs_ge_msg_stack.add;
292: app_exception.raise_exception;
293: END IF;
294:
295: before_dml(
296: p_action => 'INSERT',

Line 342: app_exception.raise_exception;

338: -- that the ownerof policy function does not have privilege to access.
339: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
340: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
341: IGS_GE_MSG_STACK.ADD;
342: app_exception.raise_exception;
343: ELSE
344: RAISE;
345: END IF;
346: END insert_row;

Line 382: app_exception.raise_exception;

378: IF (c1%notfound) THEN
379: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
380: igs_ge_msg_stack.add;
381: CLOSE c1;
382: app_exception.raise_exception;
383: RETURN;
384: END IF;
385: CLOSE c1;
386:

Line 394: app_exception.raise_exception;

390: NULL;
391: ELSE
392: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
393: igs_ge_msg_stack.add;
394: app_exception.raise_exception;
395: END IF;
396:
397: RETURN;
398:

Line 442: app_exception.raise_exception;

438: ELSE
439: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
440: fnd_message.set_token ('ROUTINE', 'IGS_AD_pnmembr_nots_PKG.UPDATE_ROW');
441: igs_ge_msg_stack.add;
442: app_exception.raise_exception;
443: END IF;
444:
445: before_dml(
446: p_action => 'UPDATE',

Line 470: app_exception.raise_exception;

466:
467: IF (SQL%NOTFOUND) THEN
468: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
469: IGS_GE_MSG_STACK.ADD;
470: app_exception.raise_exception;
471: END IF;
472:
473: EXCEPTION
474: WHEN OTHERS THEN

Line 484: app_exception.raise_exception;

480: -- that the ownerof policy function does not have privilege to access.
481: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
482: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
483: IGS_GE_MSG_STACK.ADD;
484: app_exception.raise_exception;
485: ELSE
486: RAISE;
487: END IF;
488: END update_row;

Line 571: app_exception.raise_exception;

567:
568: IF (SQL%NOTFOUND) THEN
569: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
570: IGS_GE_MSG_STACK.ADD;
571: app_exception.raise_exception;
572: END IF;
573:
574: EXCEPTION
575: WHEN OTHERS THEN

Line 585: app_exception.raise_exception;

581: -- that the ownerof policy function does not have privilege to access.
582: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
583: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
584: IGS_GE_MSG_STACK.ADD;
585: app_exception.raise_exception;
586: ELSE
587: RAISE;
588: END IF;
589: END delete_row;