DBA Data[Home] [Help]

APPS.IGS_PS_RSV_USEC_PRI_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 92: igs_ge_msg_stack.add;

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

Line 119: igs_ge_msg_stack.add;

115: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_For_validation (
116: new_references.uoo_id
117: ) THEN
118: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
119: igs_ge_msg_stack.add;
120: app_exception.raise_exception;
121: END IF;
122:
123: IF (((old_references.priority_value = new_references.priority_value)) OR

Line 129: IGS_GE_MSG_STACK.ADD;

125: NULL;
126: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation('RESERVE_SEAT_PRIORITY',
127: new_references.priority_value) THEN
128: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
129: IGS_GE_MSG_STACK.ADD;
130: App_Exception.Raise_Exception;
131: END IF;
132:
133: END check_parent_existance;

Line 253: igs_ge_msg_stack.add;

249: FETCH cur_rowid INTO lv_rowid;
250: IF (cur_rowid%FOUND) THEN
251: CLOSE cur_rowid;
252: fnd_message.set_name ('IGS', 'IGS_PS_USPR_UOO_UFK');
253: igs_ge_msg_stack.add;
254: app_exception.raise_exception;
255: RETURN;
256: END IF;
257: CLOSE cur_rowid;

Line 308: igs_ge_msg_stack.add;

304: new_references.rsv_usec_pri_id
305: )
306: ) THEN
307: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
308: igs_ge_msg_stack.add;
309: app_exception.raise_exception;
310: END IF;
311: check_uniqueness;
312: check_parent_existance;

Line 327: igs_ge_msg_stack.add;

323: new_references.rsv_usec_pri_id
324: )
325: ) THEN
326: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
327: igs_ge_msg_stack.add;
328: app_exception.raise_exception;
329: END IF;
330: check_uniqueness;
331: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 385: igs_ge_msg_stack.add;

381: x_last_update_login := -1;
382: END IF;
383: ELSE
384: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
385: igs_ge_msg_stack.add;
386: app_exception.raise_exception;
387: END IF;
388:
389: SELECT igs_ps_rsv_usec_pri_s.NEXTVAL

Line 473: igs_ge_msg_stack.add;

469: OPEN c1;
470: FETCH c1 INTO tlinfo;
471: IF (c1%notfound) THEN
472: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
473: igs_ge_msg_stack.add;
474: CLOSE c1;
475: app_exception.raise_exception;
476: RETURN;
477: END IF;

Line 488: igs_ge_msg_stack.add;

484: ) THEN
485: NULL;
486: ELSE
487: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
488: igs_ge_msg_stack.add;
489: app_exception.raise_exception;
490: END IF;
491:
492: RETURN;

Line 535: igs_ge_msg_stack.add;

531: x_last_update_login := -1;
532: END IF;
533: ELSE
534: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
535: igs_ge_msg_stack.add;
536: app_exception.raise_exception;
537: END IF;
538:
539: before_dml(