APPS.IGR_I_E_CHARTYP_PKG dependencies on APP_EXCEPTION

Line 38: app_exception.raise_exception;

34: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
35: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
36: igs_ge_msg_stack.add;
37: CLOSE cur_old_ref_values;
38: app_exception.raise_exception;
39: RETURN;
40: END IF;
41: Close cur_old_ref_values;
42:

Line 112: app_exception.raise_exception;

108: column_name IS NULL THEN
109: IF new_references.closed_ind <> UPPER(new_references.closed_ind) or new_references.closed_ind NOT IN ( 'Y' , 'N' ) THEN
110: fnd_message.set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
111: igs_ge_msg_stack.add;
112: app_exception.raise_exception;
113: END IF;
114: END IF;
115:
116: IF UPPER(column_name) = 'ENQUIRY_CHARACTERISTIC_TYPE' OR

Line 121: app_exception.raise_exception;

117: column_name IS NULL THEN
118: IF new_references.enquiry_characteristic_type <> UPPER(new_references.enquiry_characteristic_type) THEN
119: fnd_message.set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
120: igs_ge_msg_stack.add;
121: app_exception.raise_exception;
122: END IF;
123: END IF;
124:
125: END check_constraints;

Line 163: App_Exception.Raise_Exception;

159: new_references.enquiry_characteristic_type
160: ) THEN
161: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
162: igs_ge_msg_stack.add;
163: App_Exception.Raise_Exception;
164: END IF;
165:
166: Check_Constraints;
167: ELSIF (p_action = 'UPDATE') THEN

Line 179: App_Exception.Raise_Exception;

175: new_references.enquiry_characteristic_type
176: ) THEN
177: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
178: igs_ge_msg_stack.add;
179: App_Exception.Raise_Exception;
180: END IF;
181: Check_Constraints;
182: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
183: Check_Constraints;

Line 220: app_exception.raise_exception;

216: END IF;
217: ELSE
218: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
219: IGS_GE_MSG_STACK.ADD;
220: app_exception.raise_exception;
221: END IF;
222:
223: Before_DML(
224: p_action=>'INSERT',

Line 287: app_exception.raise_exception;

283: IF (c1%NOTFOUND) THEN
284: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
285: IGS_GE_MSG_STACK.ADD;
286: CLOSE c1;
287: app_exception.raise_exception;
288: RETURN;
289: END IF;
290: CLOSE c1;
291:

Line 299: app_exception.raise_exception;

295: NULL;
296: else
297: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
298: IGS_GE_MSG_STACK.ADD;
299: app_exception.raise_exception;
300: END IF;
301: RETURN;
302: END LOCK_ROW;
303:

Line 331: app_exception.raise_exception;

327: END IF;
328: ELSE
329: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
330: IGS_GE_MSG_STACK.ADD;
331: app_exception.raise_exception;
332: END IF;
333:
334: Before_DML(
335: p_action=>'UPDATE',