DBA Data[Home] [Help]

APPS.IGS_UC_REF_KEYWORDS_PKG dependencies on APP_EXCEPTION

Line 46: app_exception.raise_exception;

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

Line 166: app_exception.raise_exception;

162: )
163: ) THEN
164: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
165: igs_ge_msg_stack.add;
166: app_exception.raise_exception;
167: END IF;
168: ELSIF (p_action = 'DELETE') THEN
169: -- Call all the procedures related to Before Delete.
170: check_child_existance;

Line 179: app_exception.raise_exception;

175: )
176: ) THEN
177: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
178: igs_ge_msg_stack.add;
179: app_exception.raise_exception;
180: END IF;
181: ELSIF (p_action = 'VALIDATE_DELETE') THEN
182: check_child_existance;
183: END IF;

Line 230: app_exception.raise_exception;

226: END IF;
227: ELSE
228: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
229: igs_ge_msg_stack.add;
230: app_exception.raise_exception;
231: END IF;
232:
233: /* SELECT igs_uc_ref_keywords_s.NEXTVAL
234: INTO x_keyword

Line 309: app_exception.raise_exception;

305: IF (c1%notfound) THEN
306: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
307: igs_ge_msg_stack.add;
308: CLOSE c1;
309: app_exception.raise_exception;
310: RETURN;
311: END IF;
312: CLOSE c1;
313:

Line 321: app_exception.raise_exception;

317: NULL;
318: ELSE
319: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
320: igs_ge_msg_stack.add;
321: app_exception.raise_exception;
322: END IF;
323:
324: RETURN;
325:

Line 366: app_exception.raise_exception;

362: END IF;
363: ELSE
364: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
365: igs_ge_msg_stack.add;
366: app_exception.raise_exception;
367: END IF;
368:
369: before_dml(
370: p_action => 'UPDATE',