DBA Data[Home] [Help]

APPS.IGF_SP_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.fund_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_AW_SFCL_FMAST_FK');
256: igs_ge_msg_stack.add;
257: app_exception.raise_exception;
258: RETURN;
259: END IF;
260: CLOSE cur_rowid;
261:

Line 292: app_exception.raise_exception;

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

Line 350: app_exception.raise_exception;

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

Line 369: app_exception.raise_exception;

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

Line 426: app_exception.raise_exception;

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

Line 524: app_exception.raise_exception;

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

Line 539: app_exception.raise_exception;

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

Line 587: app_exception.raise_exception;

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