APPS.IGI_IAC_CAL_PRICE_INDEXES_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

46: FETCH cur_old_ref_values INTO old_references;
47: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
48: CLOSE cur_old_ref_values;
49: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
53: CLOSE cur_old_ref_values;
54:

Line 98: app_exception.raise_exception;

94: ELSIF NOT igi_iac_price_indexes_pkg.get_pk_for_validation (
95: new_references.price_index_id
96: ) THEN
97: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
98: app_exception.raise_exception;
99: END IF;
100:
101: END check_parent_existance;
102:

Line 184: app_exception.raise_exception;

180: FETCH cur_rowid INTO lv_rowid;
181: IF (cur_rowid%FOUND) THEN
182: CLOSE cur_rowid;
183: fnd_message.set_name ('FND', 'FND-CANNOT DELETE MASTER');
184: app_exception.raise_exception;
185: RETURN;
186: END IF;
187: CLOSE cur_rowid;
188:

Line 244: app_exception.raise_exception;

240: new_references.cal_price_index_link_id
241: )
242: ) THEN
243: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
244: app_exception.raise_exception;
245: END IF;
246: check_parent_existance;
247: ELSIF (p_action = 'UPDATE') THEN
248: -- Call all the procedures related to Before Update.

Line 260: app_exception.raise_exception;

256: new_references.cal_price_index_link_id
257: )
258: ) THEN
259: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
260: app_exception.raise_exception;
261: END IF;
262: ELSIF (p_action = 'VALIDATE_DELETE') THEN
263: check_child_existance;
264: END IF;

Line 315: app_exception.raise_exception;

311: x_last_update_login := -1;
312: END IF;
313: ELSE
314: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
315: app_exception.raise_exception;
316: END IF;
317:
318: SELECT igi_iac_cal_price_indexes_s.NEXTVAL
319: INTO x_cal_price_index_link_id

Line 418: app_exception.raise_exception;

414: FETCH c1 INTO tlinfo;
415: IF (c1%notfound) THEN
416: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
417: CLOSE c1;
418: app_exception.raise_exception;
419: RETURN;
420: END IF;
421: CLOSE c1;
422:

Line 434: app_exception.raise_exception;

430: ) THEN
431: NULL;
432: ELSE
433: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
434: app_exception.raise_exception;
435: END IF;
436:
437: RETURN;
438:

Line 483: app_exception.raise_exception;

479: x_last_update_login := -1;
480: END IF;
481: ELSE
482: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
483: app_exception.raise_exception;
484: END IF;
485:
486: before_dml(
487: p_action => 'UPDATE',