DBA Data[Home] [Help]

APPS.IGS_FI_SPECIAL_FEES_PKG dependencies on APP_EXCEPTION

Line 55: app_exception.raise_exception;

51: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
52: CLOSE cur_old_ref_values;
53: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
54: igs_ge_msg_stack.add;
55: app_exception.raise_exception;
56: RETURN;
57: END IF;
58: CLOSE cur_old_ref_values;
59:

Line 122: app_exception.raise_exception;

118: new_references.fee_ci_sequence_number
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.person_id = new_references.person_id) AND
126: (old_references.course_cd = new_references.course_cd)) OR

Line 136: app_exception.raise_exception;

132: new_references.course_cd
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: IF (((old_references.uoo_id = new_references.uoo_id) AND
140: (old_references.fee_type = new_references.fee_type)) OR

Line 150: app_exception.raise_exception;

146: new_references.fee_type
147: ) THEN
148: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
149: igs_ge_msg_stack.add;
150: app_exception.raise_exception;
151: END IF;
152:
153: IF ((old_references.person_id = new_references.person_id) OR
154: (new_references.person_id IS NULL)) THEN

Line 165: app_exception.raise_exception;

161: ELSE
162: CLOSE cur_person;
163: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
164: igs_ge_msg_stack.add;
165: app_exception.raise_exception;
166: END IF;
167: END IF;
168:
169: IF ((old_references.invoice_id = new_references.invoice_id) OR

Line 177: app_exception.raise_exception;

173: new_references.invoice_id
174: ) THEN
175: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
176: igs_ge_msg_stack.add;
177: app_exception.raise_exception;
178: END IF;
179:
180: END check_parent_existance;
181:

Line 247: app_exception.raise_exception;

243: IF (cur_rowid%FOUND) THEN
244: CLOSE cur_rowid;
245: fnd_message.set_name ('IGS', 'IGS_FI_FSP_USEC_FK');
246: igs_ge_msg_stack.add;
247: app_exception.raise_exception;
248: RETURN;
249: END IF;
250: CLOSE cur_rowid;
251:

Line 316: app_exception.raise_exception;

312: )
313: ) THEN
314: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
315: igs_ge_msg_stack.add;
316: app_exception.raise_exception;
317: END IF;
318: check_parent_existance;
319: ELSIF (p_action = 'UPDATE') THEN
320: -- Call all the procedures related to Before Update.

Line 330: app_exception.raise_exception;

326: )
327: ) THEN
328: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
329: igs_ge_msg_stack.add;
330: app_exception.raise_exception;
331: END IF;
332: END IF;
333:
334: END before_dml;

Line 401: app_exception.raise_exception;

397: ELSE
398: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
399: fnd_message.set_token ('ROUTINE', 'IGS_FI_SPECIAL_FEES_PKG.INSERT_ROW');
400: igs_ge_msg_stack.add;
401: app_exception.raise_exception;
402: END IF;
403:
404: x_special_fee_id := NULL;
405:

Line 523: app_exception.raise_exception;

519: IF (c1%notfound) THEN
520: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
521: igs_ge_msg_stack.add;
522: CLOSE c1;
523: app_exception.raise_exception;
524: RETURN;
525: END IF;
526: CLOSE c1;
527:

Line 544: app_exception.raise_exception;

540: NULL;
541: ELSE
542: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
543: igs_ge_msg_stack.add;
544: app_exception.raise_exception;
545: END IF;
546:
547: RETURN;
548:

Line 603: app_exception.raise_exception;

599: ELSE
600: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
601: fnd_message.set_token ('ROUTINE', 'IGS_FI_SPECIAL_FEES_PKG.UPDATE_ROW');
602: igs_ge_msg_stack.add;
603: app_exception.raise_exception;
604: END IF;
605:
606: before_dml(
607: p_action => 'UPDATE',