APPS.IGS_EN_DL_OFFSET_CONS_PKG dependencies on IGS_GE_MSG_STACK

Line 49: igs_ge_msg_stack.add;

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

Line 97: igs_ge_msg_stack.add;

93: new_references.deadline_type
94: )
95: ) THEN
96: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100:
101: END check_uniqueness;

Line 122: IGS_GE_MSG_STACK.ADD;

118: IF l_c_col_name = 'DEADLINE_TYPE' OR Column_Name IS NULL THEN
119:
120: IF new_references.deadline_type NOT IN ( 'E' , 'R' ) THEN
121: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
122: IGS_GE_MSG_STACK.ADD;
123: app_exception.raise_exception;
124: END IF;
125:
126: END IF;

Line 133: IGS_GE_MSG_STACK.ADD;

129: IF new_references.constraint_resolution < -7 OR
130: new_references.constraint_resolution > 7 OR
131: new_references.constraint_resolution = 0 THEN
132: fnd_message.set_name('IGS', 'IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: app_exception.raise_exception;
135: END IF;
136: END IF;
137:

Line 160: igs_ge_msg_stack.add;

156: ELSIF (new_references.deadline_type='E' AND (NOT igs_en_nsu_dlstp_pkg.get_pk_for_validation (
157: new_references.non_std_usec_dls_id
158: ))) THEN
159: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
160: igs_ge_msg_stack.add;
161: app_exception.raise_exception;
162: ELSIF (new_references.deadline_type='R' AND (NOT igs_ps_nsus_rtn_pkg.get_pk_for_validation (
163: new_references.non_std_usec_dls_id
164: ))) THEN

Line 166: igs_ge_msg_stack.add;

162: ELSIF (new_references.deadline_type='R' AND (NOT igs_ps_nsus_rtn_pkg.get_pk_for_validation (
163: new_references.non_std_usec_dls_id
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: END check_parent_existance;
170:

Line 273: igs_ge_msg_stack.add;

269: FETCH cur_rowid INTO lv_rowid;
270: IF (cur_rowid%FOUND) THEN
271: CLOSE cur_rowid;
272: fnd_message.set_name ('IGS', 'IGS_EN_DOSC_NSUD_FK');
273: igs_ge_msg_stack.add;
274: app_exception.raise_exception;
275: RETURN;
276: END IF;
277: CLOSE cur_rowid;

Line 307: igs_ge_msg_stack.add;

303: FETCH cur_rowid INTO lv_rowid;
304: IF (cur_rowid%FOUND) THEN
305: CLOSE cur_rowid;
306: fnd_message.set_name ('IGS', 'IGS_EN_DOSC_NR_FK');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309: RETURN;
310: END IF;
311: CLOSE cur_rowid;

Line 365: igs_ge_msg_stack.add;

361: new_references.enr_dl_offset_cons_id
362: )
363: ) THEN
364: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
365: igs_ge_msg_stack.add;
366: app_exception.raise_exception;
367: END IF;
368: check_uniqueness;
369: check_constraints;

Line 383: igs_ge_msg_stack.add;

379: new_references.enr_dl_offset_cons_id
380: )
381: ) THEN
382: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
383: igs_ge_msg_stack.add;
384: app_exception.raise_exception;
385: END IF;
386: check_uniqueness;
387: check_constraints;

Line 441: igs_ge_msg_stack.add;

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

Line 539: igs_ge_msg_stack.add;

535: OPEN c1;
536: FETCH c1 INTO tlinfo;
537: IF (c1%notfound) THEN
538: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
539: igs_ge_msg_stack.add;
540: CLOSE c1;
541: app_exception.raise_exception;
542: RETURN;
543: END IF;

Line 556: igs_ge_msg_stack.add;

552: ) THEN
553: NULL;
554: ELSE
555: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
556: igs_ge_msg_stack.add;
557: app_exception.raise_exception;
558: END IF;
559:
560: RETURN;

Line 605: igs_ge_msg_stack.add;

601: x_last_update_login := -1;
602: END IF;
603: ELSE
604: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
605: igs_ge_msg_stack.add;
606: app_exception.raise_exception;
607: END IF;
608:
609: before_dml(