APPS.IGS_PE_PER_TYPE_MAP_PKG dependencies on APP_EXCEPTION

Line 47: app_exception.raise_exception;

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

Line 98: APP_EXCEPTION.RAISE_EXCEPTION;

94: new_references.person_type_code
95: ) THEN
96: FND_MESSAGE.SET_NAME ('FND','FORM_RECORD_DELETED');
97: IGS_GE_MSG_STACK.ADD;
98: APP_EXCEPTION.RAISE_EXCEPTION;
99: END IF;
100:
101: IF (((old_references.per_person_type_id = new_references.per_person_type_id)) OR
102: ((new_references.per_person_type_id IS NULL))) THEN

Line 111: APP_EXCEPTION.RAISE_EXCEPTION;

107: IF person_type_id_cur%NOTFOUND THEN
108: CLOSE person_type_id_cur;
109: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
110: IGS_GE_MSG_STACK.ADD;
111: APP_EXCEPTION.RAISE_EXCEPTION;
112: END IF;
113: CLOSE person_type_id_cur;
114: END IF;
115:

Line 123: APP_EXCEPTION.RAISE_EXCEPTION;

119: ELSE
120: IF NOT igs_lookups_view_pkg.get_pk_for_validation('SYSTEM_PERSON_TYPES',new_references.system_type) THEN
121: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');
122: IGS_GE_MSG_STACK.ADD;
123: APP_EXCEPTION.RAISE_EXCEPTION;
124: END IF;
125: END IF;
126:
127: END check_parent_existance;

Line 213: app_exception.raise_exception;

209: )
210: ) THEN
211: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
212: igs_ge_msg_stack.add;
213: app_exception.raise_exception;
214: END IF;
215:
216: check_parent_existance;
217:

Line 227: app_exception.raise_exception;

223: )
224: ) THEN
225: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
226: igs_ge_msg_stack.add;
227: app_exception.raise_exception;
228: END IF;
229:
230: check_parent_existance;
231:

Line 433: app_exception.raise_exception;

429: END IF;
430: ELSE
431: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
432: igs_ge_msg_stack.add;
433: app_exception.raise_exception;
434: END IF;
435:
436: before_dml(
437: p_action => 'INSERT',

Line 509: app_exception.raise_exception;

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

Line 521: app_exception.raise_exception;

517: NULL;
518: ELSE
519: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
520: igs_ge_msg_stack.add;
521: app_exception.raise_exception;
522: END IF;
523:
524: RETURN;
525:

Line 567: app_exception.raise_exception;

563: END IF;
564: ELSE
565: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
566: igs_ge_msg_stack.add;
567: app_exception.raise_exception;
568: END IF;
569:
570: before_dml(
571: p_action => 'UPDATE',