APPS.IGS_PS_FAC_OVR_WL_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

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

Line 98: app_exception.raise_exception;

94: new_references.override_reason
95: ) THEN
96: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
97: igs_ge_msg_stack.add;
98: app_exception.raise_exception;
99: END IF;
100:
101: IF (((old_references.fac_wl_id = new_references.fac_wl_id)) OR
102: ((new_references.fac_wl_id IS NULL))) THEN

Line 109: app_exception.raise_exception;

105: new_references.fac_wl_id
106: ) THEN
107: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
108: igs_ge_msg_stack.add;
109: app_exception.raise_exception;
110: END IF;
111:
112: END check_parent_existance;
113:

Line 177: app_exception.raise_exception;

173: IF (cur_rowid%FOUND) THEN
174: CLOSE cur_rowid;
175: fnd_message.set_name ('IGS', 'IGS_PS_FOW_WOR_FK');
176: igs_ge_msg_stack.add;
177: app_exception.raise_exception;
178: RETURN;
179: END IF;
180: CLOSE cur_rowid;
181:

Line 212: app_exception.raise_exception;

208: IF (cur_rowid%FOUND) THEN
209: CLOSE cur_rowid;
210: fnd_message.set_name ('IGS', 'IGS_PS_FOW_FWL_FK');
211: igs_ge_msg_stack.add;
212: app_exception.raise_exception;
213: RETURN;
214: END IF;
215: CLOSE cur_rowid;
216:

Line 271: app_exception.raise_exception;

267: )
268: ) THEN
269: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
270: igs_ge_msg_stack.add;
271: app_exception.raise_exception;
272: END IF;
273: check_parent_existance;
274: ELSIF (p_action = 'UPDATE') THEN
275: -- Call all the procedures related to Before Update.

Line 285: app_exception.raise_exception;

281: )
282: ) THEN
283: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
284: igs_ge_msg_stack.add;
285: app_exception.raise_exception;
286: END IF;
287: END IF;
288:
289: END before_dml;

Line 338: app_exception.raise_exception;

334: END IF;
335: ELSE
336: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
337: igs_ge_msg_stack.add;
338: app_exception.raise_exception;
339: END IF;
340:
341: SELECT igs_ps_fac_ovr_wl_s.NEXTVAL
342: INTO x_fac_ovr_wl_id

Line 437: app_exception.raise_exception;

433: IF (c1%notfound) THEN
434: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
435: igs_ge_msg_stack.add;
436: CLOSE c1;
437: app_exception.raise_exception;
438: RETURN;
439: END IF;
440: CLOSE c1;
441:

Line 453: app_exception.raise_exception;

449: NULL;
450: ELSE
451: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
452: igs_ge_msg_stack.add;
453: app_exception.raise_exception;
454: END IF;
455:
456: RETURN;
457:

Line 502: app_exception.raise_exception;

498: END IF;
499: ELSE
500: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
501: igs_ge_msg_stack.add;
502: app_exception.raise_exception;
503: END IF;
504:
505: before_dml(
506: p_action => 'UPDATE',