APPS.IGF_SP_UNIT_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

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

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.fee_cls_prg_id
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.unit_cd = new_references.unit_cd) AND
126: (old_references.version_number = new_references.version_number)) OR

Line 136: app_exception.raise_exception;

132: new_references.version_number
133: ) THEN
134: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
135: igs_ge_msg_stack.add;
136: app_exception.raise_exception;
137: END IF;
138:
139: END check_parent_existance;
140:

Line 243: app_exception.raise_exception;

239: IF (cur_rowid%FOUND) THEN
240: CLOSE cur_rowid;
241: fnd_message.set_name ('IGF', 'IGF_SP_SFCLU_SFCLP_FK');
242: igs_ge_msg_stack.add;
243: app_exception.raise_exception;
244: RETURN;
245: END IF;
246: CLOSE cur_rowid;
247:

Line 280: app_exception.raise_exception;

276: IF (cur_rowid%FOUND) THEN
277: CLOSE cur_rowid;
278: fnd_message.set_name ('IGF', 'IGF_SP_SFCLU_UV_FK');
279: igs_ge_msg_stack.add;
280: app_exception.raise_exception;
281: RETURN;
282: END IF;
283: CLOSE cur_rowid;
284: END get_fk_igs_ps_unit_ver;

Line 339: app_exception.raise_exception;

335: )
336: ) THEN
337: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
338: igs_ge_msg_stack.add;
339: app_exception.raise_exception;
340: END IF;
341: check_uniqueness;
342: check_parent_existance;
343: ELSIF (p_action = 'UPDATE') THEN

Line 355: app_exception.raise_exception;

351: )
352: ) THEN
353: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
354: igs_ge_msg_stack.add;
355: app_exception.raise_exception;
356: END IF;
357: check_uniqueness;
358: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
359: check_uniqueness;

Line 410: app_exception.raise_exception;

406: END IF;
407: ELSE
408: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: END IF;
412:
413: SELECT igf_sp_unit_s.NEXTVAL
414: INTO x_fee_cls_unit_id

Line 508: app_exception.raise_exception;

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

Line 523: app_exception.raise_exception;

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

Line 571: app_exception.raise_exception;

567: END IF;
568: ELSE
569: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
570: igs_ge_msg_stack.add;
571: app_exception.raise_exception;
572: END IF;
573:
574: before_dml(
575: p_action => 'UPDATE',