DBA Data[Home] [Help]

APPS.IGS_PS_US_EXAM_MEET_PKG dependencies on IGS_GE_MSG_STACK

Line 47: igs_ge_msg_stack.add;

43: FETCH cur_old_ref_values INTO old_references;
44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
51: CLOSE cur_old_ref_values;

Line 91: igs_ge_msg_stack.add;

87: new_references.uoo_id
88: )
89: ) THEN
90: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
91: igs_ge_msg_stack.add;
92: app_exception.raise_exception;
93: END IF;
94:
95: END check_uniqueness;

Line 117: igs_ge_msg_stack.add;

113: ELSIF NOT igs_ps_us_em_grp_pkg.get_pk_for_validation (
114: new_references.exam_meet_group_id
115: ) THEN
116: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
117: igs_ge_msg_stack.add;
118: app_exception.raise_exception;
119: END IF;
120:
121: IF (((old_references.uoo_id = new_references.uoo_id)) OR

Line 128: igs_ge_msg_stack.add;

124: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_For_validation (
125: new_references.uoo_id
126: ) THEN
127: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
128: igs_ge_msg_stack.add;
129: app_exception.raise_exception;
130: END IF;
131:
132: END check_parent_existance;

Line 231: igs_ge_msg_stack.add;

227: FETCH cur_rowid INTO lv_rowid;
228: IF (cur_rowid%FOUND) THEN
229: CLOSE cur_rowid;
230: fnd_message.set_name ('IGS', 'IGS_PS_EMG_EM_FK2');
231: igs_ge_msg_stack.add;
232: app_exception.raise_exception;
233: RETURN;
234: END IF;
235: CLOSE cur_rowid;

Line 266: igs_ge_msg_stack.add;

262: FETCH cur_rowid INTO lv_rowid;
263: IF (cur_rowid%FOUND) THEN
264: CLOSE cur_rowid;
265: fnd_message.set_name ('IGS', 'IGS_PS_UOO_EM_FK1');
266: igs_ge_msg_stack.add;
267: app_exception.raise_exception;
268: RETURN;
269: END IF;
270: CLOSE cur_rowid;

Line 321: igs_ge_msg_stack.add;

317: new_references.exam_meet_id
318: )
319: ) THEN
320: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
321: igs_ge_msg_stack.add;
322: app_exception.raise_exception;
323: END IF;
324: check_uniqueness;
325: check_parent_existance;

Line 337: igs_ge_msg_stack.add;

333: new_references.exam_meet_id
334: )
335: ) THEN
336: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
337: igs_ge_msg_stack.add;
338: app_exception.raise_exception;
339: END IF;
340: check_uniqueness;
341: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 391: igs_ge_msg_stack.add;

387: x_last_update_login := -1;
388: END IF;
389: ELSE
390: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
391: igs_ge_msg_stack.add;
392: app_exception.raise_exception;
393: END IF;
394:
395: SELECT igs_ps_us_exam_meet_s.NEXTVAL

Line 479: igs_ge_msg_stack.add;

475: OPEN c1;
476: FETCH c1 INTO tlinfo;
477: IF (c1%notfound) THEN
478: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
479: igs_ge_msg_stack.add;
480: CLOSE c1;
481: app_exception.raise_exception;
482: RETURN;
483: END IF;

Line 494: igs_ge_msg_stack.add;

490: ) THEN
491: NULL;
492: ELSE
493: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
494: igs_ge_msg_stack.add;
495: app_exception.raise_exception;
496: END IF;
497:
498: RETURN;

Line 541: igs_ge_msg_stack.add;

537: x_last_update_login := -1;
538: END IF;
539: ELSE
540: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
541: igs_ge_msg_stack.add;
542: app_exception.raise_exception;
543: END IF;
544:
545: before_dml(