DBA Data[Home] [Help]

APPS.IGS_FI_ANC_RATES_PKG dependencies on APP_EXCEPTION

Line 65: app_exception.raise_exception;

61: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
62: CLOSE cur_old_ref_values;
63: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
64: igs_ge_msg_stack.add;
65: app_exception.raise_exception;
66: RETURN;
67: END IF;
68: CLOSE cur_old_ref_values;
69:

Line 227: APP_EXCEPTION.RAISE_EXCEPTION;

223: CLOSE cur_impchgs_lines;
224: FND_MESSAGE.SET_NAME('IGS','IGS_FI_IMPCHGS_LINES_EXISTS');
225: --'Update of this record is not allowed since Ancillary Charges exist for these attributes and rate'
226: IGS_GE_MSG_STACK.ADD;
227: APP_EXCEPTION.RAISE_EXCEPTION;
228: END IF;
229: END IF;
230: CLOSE cur_impchgs_lines;
231:

Line 260: APP_EXCEPTION.RAISE_EXCEPTION;

256: CLOSE cur_impchgs_lines;
257: FND_MESSAGE.SET_NAME('IGS','IGS_FI_IMP_CHGS_EXISTS');
258: --'Deletion of this record is not allowed since Ancillary Charges exist for these attributes'
259: IGS_GE_MSG_STACK.ADD;
260: APP_EXCEPTION.RAISE_EXCEPTION;
261: END IF;
262: CLOSE cur_impchgs_lines;
263: END IF;
264:

Line 303: app_exception.raise_exception;

299: )
300: ) THEN
301: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
302: igs_ge_msg_stack.add;
303: app_exception.raise_exception;
304: END IF;
305:
306: END check_uniqueness;
307:

Line 335: app_exception.raise_exception;

331: new_references.fee_ci_sequence_number
332: ) THEN
333: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336: END IF;
337:
338: END check_parent_existance;
339:

Line 527: app_exception.raise_exception;

523: )
524: ) THEN
525: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: END IF;
529: check_uniqueness;
530: check_parent_existance;
531: ELSIF (p_action = 'UPDATE') THEN

Line 544: app_exception.raise_exception;

540: )
541: ) THEN
542: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
543: igs_ge_msg_stack.add;
544: app_exception.raise_exception;
545: END IF;
546: check_uniqueness;
547: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
548: check_uniqueness;

Line 620: app_exception.raise_exception;

616: END IF;
617: ELSE
618: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
619: igs_ge_msg_stack.add;
620: app_exception.raise_exception;
621: END IF;
622: SELECT IGS_FI_ANC_RATES_S.NEXTVAL INTO x_ancillary_rate_id FROM DUAL;
623:
624: before_dml(

Line 793: app_exception.raise_exception;

789: IF (c1%notfound) THEN
790: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
791: igs_ge_msg_stack.add;
792: CLOSE c1;
793: app_exception.raise_exception;
794: RETURN;
795: END IF;
796: CLOSE c1;
797:

Line 824: app_exception.raise_exception;

820: NULL;
821: ELSE
822: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
823: igs_ge_msg_stack.add;
824: app_exception.raise_exception;
825: END IF;
826:
827: l_rowid := NULL;
828: RETURN;

Line 889: app_exception.raise_exception;

885: END IF;
886: ELSE
887: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
888: igs_ge_msg_stack.add;
889: app_exception.raise_exception;
890: END IF;
891:
892: before_dml(
893: p_action => 'UPDATE',