APPS.IGS_DA_REQ_WIF_PKG dependencies on APP_EXCEPTION

Line 58: app_exception.raise_exception;

54: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
55: CLOSE cur_old_ref_values;
56: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
57: igs_ge_msg_stack.add;
58: app_exception.raise_exception;
59: RETURN;
60: END IF;
61: CLOSE cur_old_ref_values;
62:

Line 113: app_exception.raise_exception;

109: new_references.batch_id
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: IF (((old_references.program_code = new_references.program_code)) OR
116: ((new_references.program_code IS NULL))) THEN
117: NULL;

Line 123: app_exception.raise_exception;

119: new_references.program_code
120: ) THEN
121: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
122: igs_ge_msg_stack.add;
123: app_exception.raise_exception;
124: END IF;
125: IF (((old_references.catalog_cal_type = new_references.catalog_cal_type) AND
126: (old_references.catalog_ci_seq_num = new_references.catalog_ci_seq_num)) OR
127: ((new_references.catalog_cal_type IS NULL) OR

Line 136: app_exception.raise_exception;

132: new_references.catalog_ci_seq_num
133: ) THEN
134: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
135: igs_ge_msg_stack.add;
136: app_exception.raise_exception;
137: END IF;
138:
139: END check_parent_existance;
140:

Line 226: app_exception.raise_exception;

222: IF (cur_rowid%FOUND) THEN
223: CLOSE cur_rowid;
224: fnd_message.set_name ('IGS', 'IGS_DA_RQST_WIF_FK');
225: igs_ge_msg_stack.add;
226: app_exception.raise_exception;
227: RETURN;
228: END IF;
229: CLOSE cur_rowid;
230:

Line 261: app_exception.raise_exception;

257: IF (cur_rowid%FOUND) THEN
258: CLOSE cur_rowid;
259: fnd_message.set_name ('IGS', 'IGS_DA_PS_WIF_FK');
260: igs_ge_msg_stack.add;
261: app_exception.raise_exception;
262: RETURN;
263: END IF;
264: CLOSE cur_rowid;
265:

Line 298: app_exception.raise_exception;

294: IF (cur_rowid%FOUND) THEN
295: CLOSE cur_rowid;
296: fnd_message.set_name ('IGS', 'IGS_DA_CA_WIF_FK');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: RETURN;
300: END IF;
301: CLOSE cur_rowid;
302:

Line 372: app_exception.raise_exception;

368: )
369: ) THEN
370: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
371: igs_ge_msg_stack.add;
372: app_exception.raise_exception;
373: END IF;
374: check_parent_existance;
375: ELSIF (p_action = 'UPDATE') THEN
376: -- Call all the procedures related to Before Update.

Line 390: app_exception.raise_exception;

386: )
387: ) THEN
388: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
389: igs_ge_msg_stack.add;
390: app_exception.raise_exception;
391: END IF;
392: ELSIF (p_action = 'VALIDATE_DELETE') THEN
393: check_child_existance;
394: END IF;

Line 453: app_exception.raise_exception;

449: ELSE
450: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
451: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_WIF_PKG.INSERT_ROW');
452: igs_ge_msg_stack.add;
453: app_exception.raise_exception;
454: END IF;
455: before_dml(
456: p_action => 'INSERT',
457: x_rowid => x_rowid,

Line 614: app_exception.raise_exception;

610: IF (c1%notfound) THEN
611: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
612: igs_ge_msg_stack.add;
613: CLOSE c1;
614: app_exception.raise_exception;
615: RETURN;
616: END IF;
617: CLOSE c1;
618:

Line 732: app_exception.raise_exception;

728: ELSE
729: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
730: fnd_message.set_token ('ROUTINE', 'IGS_DA_REQ_WIF_PKG.UPDATE_ROW');
731: igs_ge_msg_stack.add;
732: app_exception.raise_exception;
733: END IF;
734:
735: before_dml(
736: p_action => 'UPDATE',