DBA Data[Home] [Help]

APPS.IGS_AS_STU_TRN_CMTS_PKG dependencies on IGS_GE_MSG_STACK

Line 55: igs_ge_msg_stack.add;

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

Line 116: igs_ge_msg_stack.add;

112: new_references.uoo_id
113: )
114: ) THEN
115: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119:
120: END check_uniqueness;

Line 145: igs_ge_msg_stack.add;

141: new_references.load_cal_type,
142: new_references.load_ci_sequence_number
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.unit_set_cd = new_references.unit_set_cd) AND

Line 159: igs_ge_msg_stack.add;

155: new_references.unit_set_cd,
156: new_references.us_version_number
157: ) THEN
158: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
159: igs_ge_msg_stack.add;
160: app_exception.raise_exception;
161: END IF;
162:
163: IF (((old_references.award_cd = new_references.award_cd)) OR

Line 170: igs_ge_msg_stack.add;

166: ELSIF NOT igs_ps_awd_pkg.get_pk_for_validation (
167: new_references.award_cd
168: ) THEN
169: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: END IF;
173:
174: IF (((old_references.course_type = new_references.course_type)) OR

Line 181: igs_ge_msg_stack.add;

177: ELSIF NOT igs_ps_type_pkg.get_pk_for_validation (
178: new_references.course_type
179: ) THEN
180: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
181: igs_ge_msg_stack.add;
182: app_exception.raise_exception;
183: END IF;
184:
185: IF (((old_references.uoo_id = new_references.uoo_id)) OR

Line 192: igs_ge_msg_stack.add;

188: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_For_validation (
189: new_references.uoo_id
190: ) THEN
191: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
192: igs_ge_msg_stack.add;
193: app_exception.raise_exception;
194: END IF;
195:
196: IF (((old_references.person_id = new_references.person_id) AND

Line 206: igs_ge_msg_stack.add;

202: new_references.person_id,
203: new_references.course_cd
204: ) THEN
205: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
206: igs_ge_msg_stack.add;
207: app_exception.raise_exception;
208: END IF;
209:
210: END check_parent_existance;

Line 329: igs_ge_msg_stack.add;

325: FETCH cur_rowid INTO lv_rowid;
326: IF (cur_rowid%FOUND) THEN
327: CLOSE cur_rowid;
328: fnd_message.set_name ('IGS', 'IGS_GE_CHILD_REC_XS');
329: igs_ge_msg_stack.add;
330: app_exception.raise_exception;
331: RETURN;
332: END IF;
333: CLOSE cur_rowid;

Line 366: igs_ge_msg_stack.add;

362: FETCH cur_rowid INTO lv_rowid;
363: IF (cur_rowid%FOUND) THEN
364: CLOSE cur_rowid;
365: fnd_message.set_name ('IGS', 'IGS_GE_CHILD_REC_XS');
366: igs_ge_msg_stack.add;
367: app_exception.raise_exception;
368: RETURN;
369: END IF;
370: CLOSE cur_rowid;

Line 401: igs_ge_msg_stack.add;

397: FETCH cur_rowid INTO lv_rowid;
398: IF (cur_rowid%FOUND) THEN
399: CLOSE cur_rowid;
400: fnd_message.set_name ('IGS', 'IGS_GE_CHILD_REC_XS');
401: igs_ge_msg_stack.add;
402: app_exception.raise_exception;
403: RETURN;
404: END IF;
405: CLOSE cur_rowid;

Line 436: igs_ge_msg_stack.add;

432: FETCH cur_rowid INTO lv_rowid;
433: IF (cur_rowid%FOUND) THEN
434: CLOSE cur_rowid;
435: fnd_message.set_name ('IGS', 'IGS_GE_CHILD_REC_XS');
436: igs_ge_msg_stack.add;
437: app_exception.raise_exception;
438: RETURN;
439: END IF;
440: CLOSE cur_rowid;

Line 471: igs_ge_msg_stack.add;

467: FETCH cur_rowid INTO lv_rowid;
468: IF (cur_rowid%FOUND) THEN
469: CLOSE cur_rowid;
470: fnd_message.set_name ('IGS', 'IGS_GE_CHILD_REC_XS');
471: igs_ge_msg_stack.add;
472: app_exception.raise_exception;
473: RETURN;
474: END IF;
475: CLOSE cur_rowid;

Line 508: igs_ge_msg_stack.add;

504: FETCH cur_rowid INTO lv_rowid;
505: IF (cur_rowid%FOUND) THEN
506: CLOSE cur_rowid;
507: fnd_message.set_name ('IGS', 'IGS_GE_CHILD_REC_XS');
508: igs_ge_msg_stack.add;
509: app_exception.raise_exception;
510: RETURN;
511: END IF;
512: CLOSE cur_rowid;

Line 579: igs_ge_msg_stack.add;

575: new_references.comment_id
576: )
577: ) THEN
578: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
579: igs_ge_msg_stack.add;
580: app_exception.raise_exception;
581: END IF;
582: check_uniqueness;
583: check_parent_existance;

Line 595: igs_ge_msg_stack.add;

591: new_references.comment_id
592: )
593: ) THEN
594: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
595: igs_ge_msg_stack.add;
596: app_exception.raise_exception;
597: END IF;
598: check_uniqueness;
599: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 658: igs_ge_msg_stack.add;

654: END IF;
655: ELSE
656: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
657: fnd_message.set_token ('ROUTINE', 'IGS_AS_STU_TRN_CMTS_PKG.INSERT_ROW');
658: igs_ge_msg_stack.add;
659: app_exception.raise_exception;
660: END IF;
661:
662: x_comment_id := NULL;

Line 778: igs_ge_msg_stack.add;

774: OPEN c1;
775: FETCH c1 INTO tlinfo;
776: IF (c1%notfound) THEN
777: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
778: igs_ge_msg_stack.add;
779: CLOSE c1;
780: app_exception.raise_exception;
781: RETURN;
782: END IF;

Line 801: igs_ge_msg_stack.add;

797: ) THEN
798: NULL;
799: ELSE
800: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
801: igs_ge_msg_stack.add;
802: app_exception.raise_exception;
803: END IF;
804:
805: RETURN;

Line 857: igs_ge_msg_stack.add;

853: END IF;
854: ELSE
855: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
856: fnd_message.set_token ('ROUTINE', 'IGS_AS_STU_TRN_CMTS_PKG.UPDATE_ROW');
857: igs_ge_msg_stack.add;
858: app_exception.raise_exception;
859: END IF;
860:
861: before_dml(