DBA Data[Home] [Help]

APPS.IGS_EN_TIMESLOT_STUP_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 110: igs_ge_msg_stack.add;

106: IF UPPER(column_name) = 'ASSIGN_RANDOMLY' OR
107: column_name IS NULL THEN
108: IF NOT (new_references.assign_randomly IN ('Y','N')) THEN
109: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: END IF;
113: END IF;
114:

Line 138: igs_ge_msg_stack.add;

134: ,new_references.sequence_number
135: ,new_references.student_type
136: ) THEN
137: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
138: igs_ge_msg_stack.add;
139: app_exception.raise_exception;
140: END IF;
141: END check_uniqueness ;
142: PROCEDURE check_parent_existance AS

Line 166: igs_ge_msg_stack.add;

162: new_references.cal_type,
163: new_references.sequence_number
164: ) THEN
165: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
166: igs_ge_msg_stack.add;
167: app_exception.raise_exception;
168: END IF;
169:
170: IF (((old_references.program_type_group_cd = new_references.program_type_group_cd)) OR

Line 177: igs_ge_msg_stack.add;

173: ELSIF NOT igs_ps_type_grp_pkg.get_pk_for_validation (
174: new_references.program_type_group_cd
175: ) THEN
176: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
177: igs_ge_msg_stack.add;
178: app_exception.raise_exception;
179: END IF;
180:
181: END check_parent_existance;

Line 311: igs_ge_msg_stack.add;

307: FETCH cur_rowid INTO lv_rowid;
308: IF (cur_rowid%FOUND) THEN
309: CLOSE cur_rowid;
310: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
311: igs_ge_msg_stack.add;
312: app_exception.raise_exception;
313: RETURN;
314: END IF;
315: CLOSE cur_rowid;

Line 348: igs_ge_msg_stack.add;

344: FETCH cur_rowid INTO lv_rowid;
345: IF (cur_rowid%FOUND) THEN
346: CLOSE cur_rowid;
347: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
348: igs_ge_msg_stack.add;
349: app_exception.raise_exception;
350: RETURN;
351: END IF;
352: CLOSE cur_rowid;

Line 411: igs_ge_msg_stack.add;

407: Null;
408: IF get_pk_for_validation(
409: new_references.igs_en_timeslot_stup_id) THEN
410: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
411: igs_ge_msg_stack.add;
412: app_exception.raise_exception;
413: END IF;
414: check_uniqueness;
415: check_constraints;

Line 432: igs_ge_msg_stack.add;

428: -- Call all the procedures related to Before Insert.
429: IF get_pk_for_validation (
430: new_references.igs_en_timeslot_stup_id) THEN
431: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
432: igs_ge_msg_stack.add;
433: app_exception.raise_exception;
434: END IF;
435: check_uniqueness;
436: check_constraints;

Line 526: igs_ge_msg_stack.add;

522: x_last_update_login := -1;
523: END IF;
524: ELSE
525: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: end if;
529:
530: select igs_en_timeslot_stup_s.nextval into x_igs_en_timeslot_stup_id from dual;

Line 623: igs_ge_msg_stack.add;

619: OPEN c1;
620: FETCH c1 INTO tlinfo;
621: IF (c1%notfound) THEN
622: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
623: igs_ge_msg_stack.add;
624: CLOSE c1;
625: app_exception.raise_exception;
626: RETURN;
627: END IF;

Line 641: igs_ge_msg_stack.add;

637: ) THEN
638: NULL;
639: ELSE
640: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
641: igs_ge_msg_stack.add;
642: app_exception.raise_exception;
643: END IF;
644: RETURN;
645: END lock_row;

Line 687: igs_ge_msg_stack.add;

683: x_last_update_login := -1;
684: END IF;
685: ELSE
686: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
687: igs_ge_msg_stack.add;
688: app_exception.raise_exception;
689: END IF;
690: before_dml(
691: p_action=>'UPDATE',