DBA Data[Home] [Help]

APPS.IGS_CO_CAT_ITM_PKG dependencies on IGS_GE_MSG_STACK

Line 48: igs_ge_msg_stack.add;

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

Line 100: igs_ge_msg_stack.add;

96:
97: IF (UPPER(column_name) = 'BLOCK_WHEN_ENCUMBERED_IND' OR column_name IS NULL) THEN
98: IF NOT (new_references.block_when_encumbered_ind IN ('Y', 'N')) THEN
99: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
100: igs_ge_msg_stack.add;
101: app_exception.raise_exception;
102: END IF;
103: END IF;
104:

Line 127: igs_ge_msg_stack.add;

123: ELSIF NOT igs_co_cat_pkg.get_pk_for_validation (
124: new_references.correspondence_cat
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: IF (((old_references.correspondence_type = new_references.correspondence_type)) OR

Line 138: igs_ge_msg_stack.add;

134: ELSIF NOT igs_co_type_pkg.get_pk_for_validation (
135: new_references.correspondence_type
136: ) THEN
137: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
138: igs_ge_msg_stack.add;
139: app_exception.raise_exception;
140: END IF;
141:
142: END check_parent_existance;

Line 210: igs_ge_msg_stack.add;

206: FETCH cur_rowid INTO lv_rowid;
207: IF (cur_rowid%FOUND) THEN
208: CLOSE cur_rowid;
209: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
210: igs_ge_msg_stack.add;
211: app_exception.raise_exception;
212: RETURN;
213: END IF;
214: CLOSE cur_rowid;

Line 245: igs_ge_msg_stack.add;

241: FETCH cur_rowid INTO lv_rowid;
242: IF (cur_rowid%FOUND) THEN
243: CLOSE cur_rowid;
244: fnd_message.set_name ('IGS', 'IGS_CO_CORT_CCI_FK');
245: igs_ge_msg_stack.add;
246: app_exception.raise_exception;
247: RETURN;
248: END IF;
249: CLOSE cur_rowid;

Line 304: igs_ge_msg_stack.add;

300: new_references.create_dt
301: )
302: ) THEN
303: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
304: igs_ge_msg_stack.add;
305: app_exception.raise_exception;
306: END IF;
307: check_constraints;
308: check_parent_existance;

Line 322: igs_ge_msg_stack.add;

318: new_references.create_dt
319: )
320: ) THEN
321: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325: check_constraints;
326: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 379: igs_ge_msg_stack.add;

375: x_last_update_login := -1;
376: END IF;
377: ELSE
378: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
379: igs_ge_msg_stack.add;
380: app_exception.raise_exception;
381: END IF;
382:
383: before_dml(

Line 466: igs_ge_msg_stack.add;

462: OPEN c1;
463: FETCH c1 INTO tlinfo;
464: IF (c1%notfound) THEN
465: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
466: igs_ge_msg_stack.add;
467: CLOSE c1;
468: app_exception.raise_exception;
469: RETURN;
470: END IF;

Line 480: igs_ge_msg_stack.add;

476: ) THEN
477: NULL;
478: ELSE
479: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
480: igs_ge_msg_stack.add;
481: app_exception.raise_exception;
482: END IF;
483:
484: RETURN;

Line 528: igs_ge_msg_stack.add;

524: x_last_update_login := -1;
525: END IF;
526: ELSE
527: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
528: igs_ge_msg_stack.add;
529: app_exception.raise_exception;
530: END IF;
531:
532: before_dml(