APPS.IGS_EN_MRG_ID_ACTION_PKG dependencies on APP_EXCEPTION

Line 40: App_Exception.Raise_Exception;

36: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ( 'INSERT','VALIDATE_INSERT' )) THEN
37: Close cur_old_ref_values;
38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: IGS_GE_MSG_STACK.ADD;
40: App_Exception.Raise_Exception;
41: Return;
42: END IF;
43: Close cur_old_ref_values;
44:

Line 84: App_Exception.Raise_Exception;

80: Column_name is null THEN
81: IF new_references.perform_action_dflt_ind NOT IN ('Y','N') THEN
82: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
83: IGS_GE_MSG_STACK.ADD;
84: App_Exception.Raise_Exception;
85: END IF;
86: END IF;
87:
88: IF upper(column_name) = 'TABLE_ALIAS' OR

Line 94: App_Exception.Raise_Exception;

90: IF new_references.table_alias <>
91: upper(new_references.table_alias) THEN
92: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96: END IF;
97:
98: IF upper(column_name) = 'MANDATORY_IND' OR

Line 103: App_Exception.Raise_Exception;

99: Column_name is null THEN
100: IF new_references.mandatory_ind NOT IN ('Y','N') then
101: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105: END IF;
106:
107: END check_constraints;

Line 191: App_Exception.Raise_Exception;

187: new_references.action_id
188: ) THEN
189: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
190: IGS_GE_MSG_STACK.ADD;
191: App_Exception.Raise_Exception;
192: END IF;
193: Check_constraints;
194: ELSIF (p_action = 'UPDATE') THEN
195: -- Call all the procedures related to Before Update.

Line 209: App_Exception.Raise_Exception;

205: new_references.action_id
206: ) THEN
207: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
208: IGS_GE_MSG_STACK.ADD;
209: App_Exception.Raise_Exception;
210: END IF;
211: Check_constraints;
212: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
213: Check_constraints;

Line 273: app_exception.raise_exception;

269: end if;
270: else
271: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
272: IGS_GE_MSG_STACK.ADD;
273: app_exception.raise_exception;
274: end if;
275:
276: Before_DML(
277: p_action => 'INSERT',

Line 354: app_exception.raise_exception;

350: if (c1%notfound) then
351: close c1;
352: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
353: IGS_GE_MSG_STACK.ADD;
354: app_exception.raise_exception;
355: return;
356: end if;
357: close c1;
358:

Line 367: app_exception.raise_exception;

363: null;
364: else
365: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
366: IGS_GE_MSG_STACK.ADD;
367: app_exception.raise_exception;
368: end if;
369: return;
370: end LOCK_ROW;
371:

Line 401: app_exception.raise_exception;

397: end if;
398: else
399: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
400: IGS_GE_MSG_STACK.ADD;
401: app_exception.raise_exception;
402: end if;
403:
404: Before_DML(
405: p_action => 'UPDATE',