APPS.IGS_CA_DA_PAIR_PKG dependencies on APP_EXCEPTION

Line 36: App_Exception.Raise_Exception;

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

Line 76: APP_EXCEPTION.RAISE_EXCEPTION;

72: new_references.related_dt_alias,
73: v_message_name) = FALSE THEN
74: Fnd_Message.Set_Name('IGS',v_message_name);
75: IGS_GE_MSG_STACK.ADD;
76: APP_EXCEPTION.RAISE_EXCEPTION;
77: END IF;
78:
79:
80:

Line 101: App_Exception.Raise_Exception;

97: If upper(Column_name)= 'RELATED_DT_ALIAS' Or column_name is null then
98: If UPPER(new_references.related_dt_alias) <> new_references.related_dt_alias Then
99: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: End if;
103: End if;
104:
105: If upper(Column_name)= 'DT_ALIAS' Or column_name is null then

Line 109: App_Exception.Raise_Exception;

105: If upper(Column_name)= 'DT_ALIAS' Or column_name is null then
106: If UPPER(new_references.dt_alias) <> new_references.dt_alias Then
107: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception;
110: End if;
111: End if;
112:
113: If column_name is null then

Line 117: App_Exception.Raise_Exception;

113: If column_name is null then
114: If new_references.related_dt_alias = new_references.dt_alias Then
115: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
116: IGS_GE_MSG_STACK.ADD;
117: App_Exception.Raise_Exception;
118: End if;
119: End if;
120:
121: END Check_Constraints;

Line 135: app_exception.raise_exception;

131: new_references.dt_alias
132: ) Then
133: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
134: IGS_GE_MSG_STACK.ADD;
135: app_exception.raise_exception;
136: END IF;
137: END IF;
138:
139: IF (((old_references.related_dt_alias = new_references.related_dt_alias)) OR

Line 148: app_exception.raise_exception;

144: new_references.related_dt_alias
145: ) Then
146: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
147: IGS_GE_MSG_STACK.ADD;
148: app_exception.raise_exception;
149: END IF;
150: END IF;
151:
152: END Check_Parent_Existance;

Line 202: App_Exception.Raise_Exception;

198: IF (cur_rowid%FOUND) THEN
199: Close cur_rowid;
200: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DAP_DA_FK');
201: IGS_GE_MSG_STACK.ADD;
202: App_Exception.Raise_Exception;
203: Return;
204: END IF;
205: Close cur_rowid;
206:

Line 244: app_exception.raise_exception;

240: new_references.related_dt_alias
241: ) Then
242: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
243: IGS_GE_MSG_STACK.ADD;
244: app_exception.raise_exception;
245: end if;
246: check_constraints;
247: Check_Parent_Existance;
248:

Line 265: app_exception.raise_exception;

261: new_references.related_dt_alias
262: ) Then
263: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
264: IGS_GE_MSG_STACK.ADD;
265: app_exception.raise_exception;
266: end if;
267: check_constraints;
268: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
269: Check_Constraints;

Line 306: app_exception.raise_exception;

302: end if;
303: else
304: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
305: IGS_GE_MSG_STACK.ADD;
306: app_exception.raise_exception;
307: end if;
308: Before_DML (
309: p_action =>'INSERT',
310: x_rowid =>X_ROWID,

Line 364: app_exception.raise_exception;

360: if (c1%notfound) then
361: close c1;
362: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
363: IGS_GE_MSG_STACK.ADD;
364: app_exception.raise_exception;
365: return;
366: end if;
367: close c1;
368: return;