APPS.IGS_PS_USO_FACILITY_PKG dependencies on IGS_GE_MSG_STACK

Line 46: igs_ge_msg_stack.add;

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

Line 90: igs_ge_msg_stack.add;

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

Line 116: igs_ge_msg_stack.add;

112: ELSIF NOT igs_ps_usec_occurs_pkg.get_pk_for_validation (
113: new_references.unit_section_occurrence_id
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.facility_code = new_references.facility_code)) OR

Line 127: igs_ge_msg_stack.add;

123: ELSIF NOT igs_ps_media_equip_pkg.get_pk_for_validation (
124: new_references.facility_code
125: ) THEN
126: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
127: igs_ge_msg_stack.add;
128: app_exception.raise_exception;
129: END IF;
130:
131: END check_parent_existance;

Line 232: igs_ge_msg_stack.add;

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

Line 267: igs_ge_msg_stack.add;

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

Line 320: igs_ge_msg_stack.add;

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

Line 336: igs_ge_msg_stack.add;

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

Line 439: igs_ge_msg_stack.add;

435: x_last_update_login := -1;
436: END IF;
437: ELSE
438: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
439: igs_ge_msg_stack.add;
440: app_exception.raise_exception;
441: END IF;
442:
443: SELECT igs_ps_uso_facility_s.NEXTVAL

Line 526: igs_ge_msg_stack.add;

522: OPEN c1;
523: FETCH c1 INTO tlinfo;
524: IF (c1%notfound) THEN
525: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
526: igs_ge_msg_stack.add;
527: CLOSE c1;
528: app_exception.raise_exception;
529: RETURN;
530: END IF;

Line 540: igs_ge_msg_stack.add;

536: ) THEN
537: NULL;
538: ELSE
539: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
540: igs_ge_msg_stack.add;
541: app_exception.raise_exception;
542: END IF;
543:
544: RETURN;

Line 586: igs_ge_msg_stack.add;

582: x_last_update_login := -1;
583: END IF;
584: ELSE
585: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
586: igs_ge_msg_stack.add;
587: app_exception.raise_exception;
588: END IF;
589:
590: before_dml(