DBA Data[Home] [Help]

APPS.IGS_OR_LOC_REGION_PKG dependencies on FND_MESSAGE

Line 44: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

40: OPEN cur_old_ref_values;
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;

Line 89: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

85: ELSIF NOT igs_ad_location_pkg.get_pk_for_validation (
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:

Line 196: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');

192: OPEN cur_rowid;
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;

Line 247: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

243: new_references.location_cd,
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;

Line 260: fnd_message.set_name('IGS','IGS_OR_PREF_REGION_EXISTS');

256: IF ( get_rg_for_validation(
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

Line 271: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

267: new_references.location_cd,
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;

Line 316: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

312: IF (x_last_update_login IS NULL) THEN
313: x_last_update_login := -1;
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;

Line 317: fnd_message.set_token ('ROUTINE', 'IGS_OR_LOC_REGION_PKG.INSERT_ROW');

313: x_last_update_login := -1;
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:

Line 383: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

379:
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;