DBA Data[Home] [Help]

APPS.IGF_AW_COA_ITEMS_PKG dependencies on APP_EXCEPTION

Line 52: app_exception.raise_exception;

48: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
49: CLOSE cur_old_ref_values;
50: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
51: igs_ge_msg_stack.add;
52: app_exception.raise_exception;
53: RETURN;
54: END IF;
55: CLOSE cur_old_ref_values;
56:

Line 102: app_exception.raise_exception;

98: new_references.base_id
99: ) THEN
100: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: END IF;
104:
105: IF (((old_references.item_code = new_references.item_code)) OR
106: ((new_references.item_code IS NULL))) THEN

Line 113: app_exception.raise_exception;

109: new_references.item_code
110: ) THEN
111: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
112: igs_ge_msg_stack.add;
113: app_exception.raise_exception;
114: END IF;
115:
116: END check_parent_existance;
117:

Line 203: app_exception.raise_exception;

199: IF (cur_rowid%FOUND) THEN
200: CLOSE cur_rowid;
201: fnd_message.set_name ('IGF', 'IGF_AW_COAI_FABASE_FK');
202: igs_ge_msg_stack.add;
203: app_exception.raise_exception;
204: RETURN;
205: END IF;
206: CLOSE cur_rowid;
207:

Line 238: app_exception.raise_exception;

234: IF (cur_rowid%FOUND) THEN
235: CLOSE cur_rowid;
236: fnd_message.set_name ('IGF', 'IGF_AW_COAI_AWITEM_FK');
237: igs_ge_msg_stack.add;
238: app_exception.raise_exception;
239: RETURN;
240: END IF;
241: CLOSE cur_rowid;
242:

Line 302: app_exception.raise_exception;

298: )
299: ) THEN
300: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
301: igs_ge_msg_stack.add;
302: app_exception.raise_exception;
303: END IF;
304: check_parent_existance;
305: ELSIF (p_action = 'UPDATE') THEN
306: -- Call all the procedures related to Before Update.

Line 320: app_exception.raise_exception;

316: )
317: ) THEN
318: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
319: igs_ge_msg_stack.add;
320: app_exception.raise_exception;
321: END IF;
322: ELSIF (p_action = 'VALIDATE_DELETE') THEN
323: check_child_existance;
324: END IF;

Line 389: app_exception.raise_exception;

385: END IF;
386: ELSE
387: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
388: igs_ge_msg_stack.add;
389: app_exception.raise_exception;
390: END IF;
391:
392: before_dml(
393: p_action => 'INSERT',

Line 493: app_exception.raise_exception;

489: IF (c1%notfound) THEN
490: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
491: igs_ge_msg_stack.add;
492: CLOSE c1;
493: app_exception.raise_exception;
494: RETURN;
495: END IF;
496: CLOSE c1;
497:

Line 511: app_exception.raise_exception;

507: NULL;
508: ELSE
509: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
510: igs_ge_msg_stack.add;
511: app_exception.raise_exception;
512: END IF;
513:
514: RETURN;
515:

Line 566: app_exception.raise_exception;

562: END IF;
563: ELSE
564: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
565: igs_ge_msg_stack.add;
566: app_exception.raise_exception;
567: END IF;
568:
569: before_dml(
570: p_action => 'UPDATE',