DBA Data[Home] [Help]

APPS.IGF_SP_STD_FC_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 95: app_exception.raise_exception;

91: )
92: ) THEN
93: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
94: igs_ge_msg_stack.add;
95: app_exception.raise_exception;
96: END IF;
97:
98: END check_uniqueness;
99:

Line 121: app_exception.raise_exception;

117: new_references.spnsr_stdnt_id
118: ) THEN
119: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
120: igs_ge_msg_stack.add;
121: app_exception.raise_exception;
122: END IF;
123:
124: IF (((old_references.fee_class = new_references.fee_class)) OR
125: ((new_references.fee_class IS NULL))) THEN

Line 133: app_exception.raise_exception;

129: new_references.fee_class
130: ) THEN
131: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134: END IF;
135:
136: END check_parent_existance;
137:

Line 257: app_exception.raise_exception;

253: IF (cur_rowid%FOUND) THEN
254: CLOSE cur_rowid;
255: fnd_message.set_name ('IGF', 'IGF_SP_STDFC_SPSTD_FK');
256: igs_ge_msg_stack.add;
257: app_exception.raise_exception;
258: RETURN;
259: END IF;
260: CLOSE cur_rowid;
261:

Line 291: app_exception.raise_exception;

287: IF (cur_rowid%FOUND) THEN
288: CLOSE cur_rowid;
289: fnd_message.set_name ('IGF', 'IGF_SP_STDFC_LKUP_FK');
290: igs_ge_msg_stack.add;
291: app_exception.raise_exception;
292: RETURN;
293: END IF;
294: CLOSE cur_rowid;
295:

Line 349: app_exception.raise_exception;

345: )
346: ) THEN
347: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
348: igs_ge_msg_stack.add;
349: app_exception.raise_exception;
350: END IF;
351: check_uniqueness;
352: check_parent_existance;
353: ELSIF (p_action = 'UPDATE') THEN

Line 368: app_exception.raise_exception;

364: )
365: ) THEN
366: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
367: igs_ge_msg_stack.add;
368: app_exception.raise_exception;
369: END IF;
370: check_uniqueness;
371: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
372: check_uniqueness;

Line 425: app_exception.raise_exception;

421: END IF;
422: ELSE
423: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
424: igs_ge_msg_stack.add;
425: app_exception.raise_exception;
426: END IF;
427:
428: SELECT igf_sp_std_fc_s.NEXTVAL
429: INTO x_fee_cls_id

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 538: app_exception.raise_exception;

534: NULL;
535: ELSE
536: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
537: igs_ge_msg_stack.add;
538: app_exception.raise_exception;
539: END IF;
540:
541: RETURN;
542:

Line 586: app_exception.raise_exception;

582: END IF;
583: ELSE
584: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
585: igs_ge_msg_stack.add;
586: app_exception.raise_exception;
587: END IF;
588:
589: before_dml(
590: p_action => 'UPDATE',