DBA Data[Home] [Help]

APPS.IGS_CA_DA_OFST_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 87: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 118: App_Exception.Raise_Exception;

114: If upper(Column_name)= 'DAY_OFFSET' Or column_name is null then
115: If new_references.day_offset < -999 or new_references.day_offset > 999 Then
116: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: End if;
120: End if;
121:
122: If upper(Column_name)= 'WEEK_OFFSET' Or column_name is null then

Line 126: App_Exception.Raise_Exception;

122: If upper(Column_name)= 'WEEK_OFFSET' Or column_name is null then
123: If new_references.week_offset < -99 or new_references.week_offset > 99 Then
124: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: End if;
128: End if;
129:
130: If upper(Column_name)= 'MONTH_OFFSET' Or column_name is null then

Line 134: App_Exception.Raise_Exception;

130: If upper(Column_name)= 'MONTH_OFFSET' Or column_name is null then
131: If new_references.month_offset < -99 or new_references.month_offset > 99 Then
132: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: End if;
136: End if;
137:
138: If upper(Column_name)= 'YEAR_OFFSET' Or column_name is null then

Line 142: App_Exception.Raise_Exception;

138: If upper(Column_name)= 'YEAR_OFFSET' Or column_name is null then
139: If new_references.year_offset < -99 or new_references.year_offset > 99 Then
140: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
141: IGS_GE_MSG_STACK.ADD;
142: App_Exception.Raise_Exception;
143: End if;
144: End if;
145:
146: If upper(Column_name)= 'DT_ALIAS' Or column_name is null then

Line 150: App_Exception.Raise_Exception;

146: If upper(Column_name)= 'DT_ALIAS' Or column_name is null then
147: If UPPER(new_references.dt_alias) <> new_references.dt_alias Then
148: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: End if;
152: End if;
153:
154: If upper(Column_name)= 'OFFSET_DT_ALIAS' Or column_name is null then

Line 158: App_Exception.Raise_Exception;

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

Line 178: app_exception.raise_exception;

174: new_references.dt_alias
175: ) Then
176: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
177: IGS_GE_MSG_STACK.ADD;
178: app_exception.raise_exception;
179: END IF;
180:
181: END IF;
182:

Line 192: app_exception.raise_exception;

188: new_references.offset_dt_alias
189: ) Then
190: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
191: IGS_GE_MSG_STACK.ADD;
192: app_exception.raise_exception;
193: END IF;
194: END IF;
195:
196: END Check_Parent_Existance;

Line 256: App_Exception.Raise_Exception;

252: IF (cur_rowid%FOUND) THEN
253: Close cur_rowid;
254: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DAO_DA_FK');
255: IGS_GE_MSG_STACK.ADD;
256: App_Exception.Raise_Exception;
257: Return;
258: END IF;
259: Close cur_rowid;
260:

Line 304: app_exception.raise_exception;

300: x_offset_dt_alias
301: ) Then
302: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
303: IGS_GE_MSG_STACK.ADD;
304: app_exception.raise_exception;
305: end if;
306:
307: check_constraints;
308: Check_Parent_Existance;

Line 328: app_exception.raise_exception;

324: x_offset_dt_alias
325: ) Then
326: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
327: IGS_GE_MSG_STACK.ADD;
328: app_exception.raise_exception;
329: end if;
330: check_constraints;
331: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
332: Check_Constraints;

Line 394: app_exception.raise_exception;

390: end if;
391: else
392: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
393: IGS_GE_MSG_STACK.ADD;
394: app_exception.raise_exception;
395: end if;
396: Before_DML (
397: p_action =>'INSERT',
398: x_rowid =>X_ROWID,

Line 478: app_exception.raise_exception;

474: if (c1%notfound) then
475: close c1;
476: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
477: IGS_GE_MSG_STACK.ADD;
478: app_exception.raise_exception;
479: return;
480: end if;
481: close c1;
482:

Line 500: app_exception.raise_exception;

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

Line 535: app_exception.raise_exception;

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