APPS.IGS_OR_LOC_REGION_PKG dependencies on IGS_GE_MSG_STACK

Line 45: igs_ge_msg_stack.add;

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

Line 90: igs_ge_msg_stack.add;

86: new_references.location_cd ,
87: 'N'
88: ) THEN
89: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
90: igs_ge_msg_stack.add;
91: app_exception.raise_exception;
92: END IF;
93:
94: END check_parent_existance;

Line 197: igs_ge_msg_stack.add;

193: FETCH cur_rowid INTO lv_rowid;
194: IF (cur_rowid%FOUND) THEN
195: CLOSE cur_rowid;
196: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
197: igs_ge_msg_stack.add;
198: app_exception.raise_exception;
199: RETURN;
200: END IF;
201: CLOSE cur_rowid;

Line 248: igs_ge_msg_stack.add;

244: new_references.region_cd
245: )
246: ) THEN
247: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
248: igs_ge_msg_stack.add;
249: app_exception.raise_exception;
250: END IF;
251: check_parent_existance;
252: ELSIF (p_action = 'UPDATE') THEN

Line 261: igs_ge_msg_stack.add;

257: old_references.location_cd,
258: old_references.region_cd
259: )) THEN
260: fnd_message.set_name('IGS','IGS_OR_PREF_REGION_EXISTS');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: END IF;
264: ELSIF (p_action = 'VALIDATE_INSERT') THEN
265: -- Call all the procedures related to Before Insert.

Line 272: igs_ge_msg_stack.add;

268: new_references.region_cd
269: )
270: ) THEN
271: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
272: igs_ge_msg_stack.add;
273: app_exception.raise_exception;
274: END IF;
275: END IF;
276:

Line 318: igs_ge_msg_stack.add;

314: END IF;
315: ELSE
316: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
317: fnd_message.set_token ('ROUTINE', 'IGS_OR_LOC_REGION_PKG.INSERT_ROW');
318: igs_ge_msg_stack.add;
319: app_exception.raise_exception;
320: END IF;
321:
322: before_dml(

Line 384: igs_ge_msg_stack.add;

380: OPEN c1;
381: FETCH c1 INTO tlinfo;
382: IF (c1%notfound) THEN
383: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
384: igs_ge_msg_stack.add;
385: CLOSE c1;
386: app_exception.raise_exception;
387: RETURN;
388: END IF;