APPS.IGS_EN_NSTD_USEC_DL_PKG dependencies on IGS_GE_MSG_STACK

Line 56: igs_ge_msg_stack.add;

52: FETCH cur_old_ref_values INTO old_references;
53: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
54: CLOSE cur_old_ref_values;
55: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
56: igs_ge_msg_stack.add;
57: app_exception.raise_exception;
58: RETURN;
59: END IF;
60: CLOSE cur_old_ref_values;

Line 110: igs_ge_msg_stack.add;

106: new_references.uoo_id
107: )
108: ) THEN
109: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: END IF;
113:
114: END check_uniqueness;

Line 136: igs_ge_msg_stack.add;

132: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_For_validation (
133: new_references.uoo_id
134: ) THEN
135: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: END IF;
139:
140: IF (((old_references.non_std_usec_dls_id = new_references.non_std_usec_dls_id)) OR

Line 147: igs_ge_msg_stack.add;

143: ELSIF NOT igs_en_nsu_dlstp_pkg.get_pk_for_validation (
144: new_references.non_std_usec_dls_id
145: ) THEN
146: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
147: igs_ge_msg_stack.add;
148: app_exception.raise_exception;
149: END IF;
150:
151: END check_parent_existance;

Line 252: igs_ge_msg_stack.add;

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

Line 287: igs_ge_msg_stack.add;

283: FETCH cur_rowid INTO lv_rowid;
284: IF (cur_rowid%FOUND) THEN
285: CLOSE cur_rowid;
286: fnd_message.set_name ('IGS', 'IGS_EN_NSDL_NSUD_FK');
287: igs_ge_msg_stack.add;
288: app_exception.raise_exception;
289: RETURN;
290: END IF;
291: CLOSE cur_rowid;

Line 360: igs_ge_msg_stack.add;

356: new_references.nstd_usec_dl_id
357: )
358: ) THEN
359: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
360: igs_ge_msg_stack.add;
361: app_exception.raise_exception;
362: END IF;
363: check_uniqueness;
364: check_parent_existance;

Line 376: igs_ge_msg_stack.add;

372: new_references.nstd_usec_dl_id
373: )
374: ) THEN
375: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
376: igs_ge_msg_stack.add;
377: app_exception.raise_exception;
378: END IF;
379: check_uniqueness;
380: 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_en_nstd_usec_dl_s.NEXTVAL

Line 572: igs_ge_msg_stack.add;

568: OPEN c1;
569: FETCH c1 INTO tlinfo;
570: IF (c1%notfound) THEN
571: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
572: igs_ge_msg_stack.add;
573: CLOSE c1;
574: app_exception.raise_exception;
575: RETURN;
576: END IF;

Line 596: igs_ge_msg_stack.add;

592: ) THEN
593: NULL;
594: ELSE
595: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
596: igs_ge_msg_stack.add;
597: app_exception.raise_exception;
598: END IF;
599:
600: RETURN;

Line 652: igs_ge_msg_stack.add;

648: x_last_update_login := -1;
649: END IF;
650: ELSE
651: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
652: igs_ge_msg_stack.add;
653: app_exception.raise_exception;
654: END IF;
655:
656: before_dml(