DBA Data[Home] [Help]

APPS.IGI_IAC_PRICE_INDEXES_PKG dependencies on APP_EXCEPTION

Line 46: app_exception.raise_exception;

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

Line 169: app_exception.raise_exception;

165: new_references.price_index_id
166: )
167: ) THEN
168: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
169: app_exception.raise_exception;
170: END IF;
171: ELSIF (p_action = 'DELETE') THEN
172: -- Call all the procedures related to Before Delete.
173: check_child_existance;

Line 181: app_exception.raise_exception;

177: new_references.price_index_id
178: )
179: ) THEN
180: fnd_message.set_name('FND','FORM_DUPLICATE_KEY_IN_INDEX');
181: app_exception.raise_exception;
182: END IF;
183: ELSIF (p_action = 'VALIDATE_DELETE') THEN
184: check_child_existance;
185: END IF;

Line 232: app_exception.raise_exception;

228: x_last_update_login := -1;
229: END IF;
230: ELSE
231: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
232: app_exception.raise_exception;
233: END IF;
234:
235: SELECT igi_iac_price_indexes_s.NEXTVAL
236: INTO x_price_index_id

Line 315: app_exception.raise_exception;

311: FETCH c1 INTO tlinfo;
312: IF (c1%notfound) THEN
313: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
314: CLOSE c1;
315: app_exception.raise_exception;
316: RETURN;
317: END IF;
318: CLOSE c1;
319:

Line 327: app_exception.raise_exception;

323: ) THEN
324: NULL;
325: ELSE
326: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
327: app_exception.raise_exception;
328: END IF;
329:
330: RETURN;
331:

Line 372: app_exception.raise_exception;

368: x_last_update_login := -1;
369: END IF;
370: ELSE
371: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
372: app_exception.raise_exception;
373: END IF;
374:
375: before_dml(
376: p_action => 'UPDATE',