DBA Data[Home] [Help]

APPS.IGF_SP_STDNT_REL_PKG dependencies on IGS_GE_MSG_STACK

Line 52: igs_ge_msg_stack.add;

48: FETCH cur_old_ref_values INTO old_references;
49: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
50: CLOSE cur_old_ref_values;
51: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
52: igs_ge_msg_stack.add;
53: app_exception.raise_exception;
54: RETURN;
55: END IF;
56: CLOSE cur_old_ref_values;

Line 104: igs_ge_msg_stack.add;

100: new_references.ld_sequence_number
101: )
102: ) THEN
103: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
104: igs_ge_msg_stack.add;
105: app_exception.raise_exception;
106: END IF;
107:
108: END check_uniqueness;

Line 134: igs_ge_msg_stack.add;

130: new_references.ld_cal_type,
131: new_references.ld_sequence_number
132: ) THEN
133: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
134: igs_ge_msg_stack.add;
135: app_exception.raise_exception;
136: END IF;
137:
138: IF (((old_references.base_id = new_references.base_id)) OR

Line 145: igs_ge_msg_stack.add;

141: ELSIF NOT igf_ap_fa_base_rec_pkg.get_pk_for_validation (
142: new_references.base_id
143: ) THEN
144: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
145: igs_ge_msg_stack.add;
146: app_exception.raise_exception;
147: END IF;
148:
149: IF (((old_references.fund_id = new_references.fund_id)) OR

Line 156: igs_ge_msg_stack.add;

152: ELSIF NOT igf_aw_fund_mast_pkg.get_pk_for_validation (
153: new_references.fund_id
154: ) THEN
155: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
156: igs_ge_msg_stack.add;
157: app_exception.raise_exception;
158: END IF;
159:
160: END check_parent_existance;

Line 284: igs_ge_msg_stack.add;

280: FETCH cur_rowid INTO lv_rowid;
281: IF (cur_rowid%FOUND) THEN
282: CLOSE cur_rowid;
283: fnd_message.set_name ('IGF', 'IGF_SP_SPSTD_HZ_FK');
284: igs_ge_msg_stack.add;
285: app_exception.raise_exception;
286: RETURN;
287: END IF;
288: CLOSE cur_rowid;

Line 321: igs_ge_msg_stack.add;

317: FETCH cur_rowid INTO lv_rowid;
318: IF (cur_rowid%FOUND) THEN
319: CLOSE cur_rowid;
320: fnd_message.set_name ('IGF', 'IGF_SP_SPSTD_CA_FK');
321: igs_ge_msg_stack.add;
322: app_exception.raise_exception;
323: RETURN;
324: END IF;
325: CLOSE cur_rowid;

Line 356: igs_ge_msg_stack.add;

352: FETCH cur_rowid INTO lv_rowid;
353: IF (cur_rowid%FOUND) THEN
354: CLOSE cur_rowid;
355: fnd_message.set_name ('IGF', 'IGF_SP_SPSTD_FA_DETAIL_FK');
356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: RETURN;
359: END IF;
360: CLOSE cur_rowid;

Line 391: igs_ge_msg_stack.add;

387: FETCH cur_rowid INTO lv_rowid;
388: IF (cur_rowid%FOUND) THEN
389: CLOSE cur_rowid;
390: fnd_message.set_name ('IGF', 'IGF_SP_SPSTD_FMAST_FK');
391: igs_ge_msg_stack.add;
392: app_exception.raise_exception;
393: RETURN;
394: END IF;
395: CLOSE cur_rowid;

Line 457: igs_ge_msg_stack.add;

453: new_references.spnsr_stdnt_id
454: )
455: ) THEN
456: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
457: igs_ge_msg_stack.add;
458: app_exception.raise_exception;
459: END IF;
460: check_uniqueness;
461: check_parent_existance;

Line 476: igs_ge_msg_stack.add;

472: new_references.spnsr_stdnt_id
473: )
474: ) THEN
475: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
476: igs_ge_msg_stack.add;
477: app_exception.raise_exception;
478: END IF;
479: check_uniqueness;
480: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 537: igs_ge_msg_stack.add;

533: x_last_update_login := -1;
534: END IF;
535: ELSE
536: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
537: igs_ge_msg_stack.add;
538: app_exception.raise_exception;
539: END IF;
540:
541: SELECT igf_sp_stdnt_rel_s.NEXTVAL

Line 654: igs_ge_msg_stack.add;

650: OPEN c1;
651: FETCH c1 INTO tlinfo;
652: IF (c1%notfound) THEN
653: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
654: igs_ge_msg_stack.add;
655: CLOSE c1;
656: app_exception.raise_exception;
657: RETURN;
658: END IF;

Line 674: igs_ge_msg_stack.add;

670: ) THEN
671: NULL;
672: ELSE
673: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
674: igs_ge_msg_stack.add;
675: app_exception.raise_exception;
676: END IF;
677:
678: RETURN;

Line 726: igs_ge_msg_stack.add;

722: x_last_update_login := -1;
723: END IF;
724: ELSE
725: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
726: igs_ge_msg_stack.add;
727: app_exception.raise_exception;
728: END IF;
729:
730: before_dml(