DBA Data[Home] [Help]

APPS.IGS_PR_STU_ACAD_STAT_PKG dependencies on IGS_GE_MSG_STACK

Line 57: igs_ge_msg_stack.add;

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

Line 116: igs_ge_msg_stack.add;

112: new_references.person_id,
113: new_references.course_cd
114: ) THEN
115: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119:
120: IF (((old_references.cal_type= new_references.cal_type) AND

Line 130: IGS_GE_MSG_STACK.ADD;

126: new_references.cal_type,
127: new_references.ci_sequence_number
128: ) THEN
129: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
130: IGS_GE_MSG_STACK.ADD;
131: APP_EXCEPTION.RAISE_EXCEPTION;
132: END IF;
133:
134: IF (((old_references.stat_type = new_references.stat_type)) OR

Line 141: igs_ge_msg_stack.add;

137: ELSIF NOT igs_pr_stat_type_pkg.get_pk_for_validation (
138: new_references.stat_type
139: ) THEN
140: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
141: igs_ge_msg_stack.add;
142: app_exception.raise_exception;
143: END IF;
144:
145: END check_parent_existance;

Line 218: IGS_GE_MSG_STACK.ADD;

214: OPEN cur_rowid;
215: FETCH cur_rowid INTO lv_rowid;
216: IF (cur_rowid%FOUND) THEN
217: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SAS_SCA_FK');
218: IGS_GE_MSG_STACK.ADD;
219: CLOSE cur_rowid;
220: APP_EXCEPTION.RAISE_EXCEPTION;
221: RETURN;
222: END IF;

Line 242: IGS_GE_MSG_STACK.ADD;

238: OPEN cur_rowid;
239: FETCH cur_rowid INTO lv_rowid;
240: IF (cur_rowid%FOUND) THEN
241: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SAS_CI_FK');
242: IGS_GE_MSG_STACK.ADD;
243: CLOSE cur_rowid;
244: APP_EXCEPTION.RAISE_EXCEPTION;
245: RETURN;
246: END IF;

Line 276: igs_ge_msg_stack.add;

272: FETCH cur_rowid INTO lv_rowid;
273: IF (cur_rowid%FOUND) THEN
274: CLOSE cur_rowid;
275: fnd_message.set_name ('IGS', 'IGS_PR_SAS_STTY_FK');
276: igs_ge_msg_stack.add;
277: app_exception.raise_exception;
278: RETURN;
279: END IF;
280: CLOSE cur_rowid;

Line 352: igs_ge_msg_stack.add;

348: new_references.stat_type,
349: new_references.timeframe)
350: ) THEN
351: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
352: igs_ge_msg_stack.add;
353: app_exception.raise_exception;
354: END IF;
355: ELSIF (p_action = 'UPDATE') THEN
356: -- Call all the procedures related to Before Update.

Line 370: igs_ge_msg_stack.add;

366: new_references.timeframe
367: )
368: ) THEN
369: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: END IF;
373: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
374: -- Call all the procedures related to Before Update.

Line 436: igs_ge_msg_stack.add;

432: x_last_update_login := -1;
433: END IF;
434: ELSE
435: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
436: igs_ge_msg_stack.add;
437: app_exception.raise_exception;
438: END IF;
439:
440: before_dml(

Line 562: igs_ge_msg_stack.add;

558: OPEN c1;
559: FETCH c1 INTO tlinfo;
560: IF (c1%notfound) THEN
561: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
562: igs_ge_msg_stack.add;
563: CLOSE c1;
564: app_exception.raise_exception;
565: RETURN;
566: END IF;

Line 583: igs_ge_msg_stack.add;

579: ) THEN
580: NULL;
581: ELSE
582: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
583: igs_ge_msg_stack.add;
584: app_exception.raise_exception;
585: END IF;
586:
587: RETURN;

Line 639: igs_ge_msg_stack.add;

635: x_last_update_login := -1;
636: END IF;
637: ELSE
638: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
639: igs_ge_msg_stack.add;
640: app_exception.raise_exception;
641: END IF;
642:
643: before_dml(