DBA Data[Home] [Help]

APPS.IGS_CA_DA_OFFCNT_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 86: APP_EXCEPTION.RAISE_EXCEPTION;

82: v_message_name) = FALSE
83: THEN
84: Fnd_Message.Set_Name('IGS',v_message_name);
85: IGS_GE_MSG_STACK.ADD;
86: APP_EXCEPTION.RAISE_EXCEPTION;
87: END IF;
88: END IF;
89: END BeforeRowInsertUpdateDelete1;
90:

Line 114: APP_EXCEPTION.RAISE_EXCEPTION;

110: new_references.constraint_resolution,
111: v_message_name) = FALSE THEN
112: Fnd_Message.Set_Name('IGS',v_message_name);
113: IGS_GE_MSG_STACK.ADD;
114: APP_EXCEPTION.RAISE_EXCEPTION;
115: END IF;
116: END IF;
117: END AfterStmtInsertUpdate3;
118:

Line 141: App_Exception.Raise_Exception;

137: If upper(Column_name)= 'CONSTRAINT_CONDITION' Or column_name is null then
138: if new_references.constraint_condition NOT IN ( 'MUST' , 'MUST NOT' )Then
139: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: End if;
143: End if;
144:
145: If upper(Column_name)= 'CONSTRAINT_RESOLUTION' Or column_name is null then

Line 149: App_Exception.Raise_Exception;

145: If upper(Column_name)= 'CONSTRAINT_RESOLUTION' Or column_name is null then
146: If new_references.constraint_resolution < -9 or new_references.constraint_resolution > 9 Then
147: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: End if;
151: End if;
152:
153: If upper(Column_name)= 'DT_ALIAS' Or column_name is null then

Line 157: App_Exception.Raise_Exception;

153: If upper(Column_name)= 'DT_ALIAS' Or column_name is null then
154: If UPPER(new_references.dt_alias) <> new_references.dt_alias Then
155: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: End if;
159: End if;
160:
161: If upper(Column_name)= 'OFFSET_DT_ALIAS' Or column_name is null then

Line 165: App_Exception.Raise_Exception;

161: If upper(Column_name)= 'OFFSET_DT_ALIAS' Or column_name is null then
162: If UPPER(new_references.offset_dt_alias) <> new_references.offset_dt_alias Then
163: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
164: IGS_GE_MSG_STACK.ADD;
165: App_Exception.Raise_Exception;
166: End if;
167: End if;
168:
169: If upper(Column_name)= 'S_DT_OFFSET_CONSTRAINT_TYPE' Or column_name is null then

Line 173: App_Exception.Raise_Exception;

169: If upper(Column_name)= 'S_DT_OFFSET_CONSTRAINT_TYPE' Or column_name is null then
170: If UPPER(new_references.s_dt_offset_constraint_type) <> new_references.s_dt_offset_constraint_type Then
171: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: End if;
175: End if;
176:
177: END Check_Constraints;

Line 194: app_exception.raise_exception;

190: new_references.offset_dt_alias
191: ) Then
192: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
193: IGS_GE_MSG_STACK.ADD;
194: app_exception.raise_exception;
195: END IF;
196: END IF;
197: IF (((old_references.s_dt_offset_constraint_type = new_references.s_dt_offset_constraint_type)) OR
198: ((new_references.s_dt_offset_constraint_type IS NULL))) THEN

Line 207: app_exception.raise_exception;

203: new_references.s_dt_offset_constraint_type
204: ) Then
205: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
206: IGS_GE_MSG_STACK.ADD;
207: app_exception.raise_exception;
208: END IF;
209: END IF;
210: END Check_Parent_Existance;
211:

Line 273: App_Exception.Raise_Exception;

269: IF (cur_rowid%FOUND) THEN
270: Close cur_rowid;
271: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DAOC_DAO_FK');
272: IGS_GE_MSG_STACK.ADD;
273: App_Exception.Raise_Exception;
274: Return;
275: END IF;
276: Close cur_rowid;
277:

Line 322: app_exception.raise_exception;

318: new_references.s_dt_offset_constraint_type
319: ) Then
320: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
321: IGS_GE_MSG_STACK.ADD;
322: app_exception.raise_exception;
323: end if;
324: check_constraints;
325: Check_Parent_Existance;
326: ELSIF (p_action = 'UPDATE') THEN

Line 342: app_exception.raise_exception;

338: new_references.s_dt_offset_constraint_type
339: ) Then
340: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
341: IGS_GE_MSG_STACK.ADD;
342: app_exception.raise_exception;
343: end if;
344: check_constraints;
345: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
346: Check_Constraints;

Line 407: app_exception.raise_exception;

403: end if;
404: else
405: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
406: IGS_GE_MSG_STACK.ADD;
407: app_exception.raise_exception;
408: end if;
409: Before_DML (
410: p_action =>'INSERT',
411: x_rowid =>X_ROWID,

Line 487: app_exception.raise_exception;

483: if (c1%notfound) then
484: close c1;
485: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
486: IGS_GE_MSG_STACK.ADD;
487: app_exception.raise_exception;
488: return;
489: end if;
490: close c1;
491:

Line 502: app_exception.raise_exception;

498: null;
499: else
500: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
501: IGS_GE_MSG_STACK.ADD;
502: app_exception.raise_exception;
503: end if;
504: return;
505: end LOCK_ROW;
506:

Line 536: app_exception.raise_exception;

532: end if;
533: else
534: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
535: IGS_GE_MSG_STACK.ADD;
536: app_exception.raise_exception;
537: end if;
538: Before_DML (
539: p_action =>'UPDATE',
540: x_rowid =>X_ROWID,