APPS.IGR_I_E_CHARTYP_PKG dependencies on IGS_GE_MSG_STACK

Line 36: igs_ge_msg_stack.add;

32: OPEN cur_old_ref_values;
33: FETCH cur_old_ref_values INTO old_references;
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;

Line 111: igs_ge_msg_stack.add;

107: IF UPPER(column_name) = 'CLOSED_IND' OR
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:

Line 120: igs_ge_msg_stack.add;

116: IF UPPER(column_name) = 'ENQUIRY_CHARACTERISTIC_TYPE' OR
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:

Line 162: igs_ge_msg_stack.add;

158: IF Get_PK_For_Validation (
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;

Line 178: igs_ge_msg_stack.add;

174: IF Get_PK_For_Validation (
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

Line 219: IGS_GE_MSG_STACK.ADD;

215: X_LAST_UPDATE_LOGIN := -1;
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(

Line 285: IGS_GE_MSG_STACK.ADD;

281: OPEN c1;
282: FETCH c1 INTO tlinfo;
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;

Line 298: IGS_GE_MSG_STACK.ADD;

294: ) THEN
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;

Line 330: IGS_GE_MSG_STACK.ADD;

326: X_LAST_UPDATE_LOGIN := -1;
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(