DBA Data[Home] [Help]

APPS.IGS_AS_UNIT_CLASS_PKG dependencies on APP_EXCEPTION

Line 38: App_Exception.Raise_Exception;

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;
41: Close cur_old_ref_values;
42: -- Populate New Values.

Line 87: App_Exception.Raise_Exception;

83: new_references.unit_mode,
84: v_message_name) = FALSE 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: -- Validate start and end times
91: IF p_inserting OR

Line 102: App_Exception.Raise_Exception;

98: new_references.end_time,
99: v_message_name) = FALSE THEN
100: Fnd_Message.Set_Name('IGS', v_message_name);
101: IGS_GE_MSG_STACK.ADD;
102: App_Exception.Raise_Exception;
103: END IF;
104: END IF;
105: END BeforeRowInsertUpdate1;
106:

Line 118: App_Exception.Raise_Exception;

114: new_references.unit_mode
115: ))THEN
116: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120: END IF;
121: END Check_Parent_Existance;
122:

Line 146: App_Exception.Raise_Exception;

142: column_name is null Then
143: IF new_references.day_of_week <> UPPER(new_references.day_of_week) OR new_references.day_of_week NOT IN ( 'MONDAY' , 'TUESDAY' , 'WEDNESDAY' , 'THURSDAY' , 'FRIDAY' , 'SATURDAY' , 'SUNDAY' ) Then
144: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148: END IF;
149:
150: IF upper(column_name) = 'CLOSED_IND' OR

Line 155: App_Exception.Raise_Exception;

151: column_name is null Then
152: IF new_references.closed_ind <> UPPER(new_references.closed_ind) OR new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
153: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157: END IF;
158: IF upper(column_name) = 'UNIT_CLASS' OR
159: column_name is null Then

Line 163: App_Exception.Raise_Exception;

159: column_name is null Then
160: IF new_references.unit_class <> UPPER(new_references.unit_class) Then
161: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
162: IGS_GE_MSG_STACK.ADD;
163: App_Exception.Raise_Exception;
164: END IF;
165: END IF;
166: IF upper(column_name) = 'UNIT_MODE' OR
167: column_name is null Then

Line 171: App_Exception.Raise_Exception;

167: column_name is null Then
168: IF new_references.unit_mode <> UPPER(new_references.unit_mode) Then
169: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173: END IF;
174: END Check_Constraints;
175:

Line 211: App_Exception.Raise_Exception;

207: IF (cur_rowid%FOUND) THEN
208: Fnd_Message.Set_Name ('IGS', 'IGS_AS_UCL_UM_FK');
209: IGS_GE_MSG_STACK.ADD;
210: Close cur_rowid;
211: App_Exception.Raise_Exception;
212: Return;
213: END IF;
214: Close cur_rowid;
215: END GET_FK_IGS_AS_UNIT_MODE;

Line 259: App_Exception.Raise_Exception;

255: new_references.unit_class
256: ) THEN
257: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
258: IGS_GE_MSG_STACK.ADD;
259: App_Exception.Raise_Exception;
260: END IF;
261: Check_Constraints;
262: Check_Parent_Existance;
263: ELSIF (p_action = 'UPDATE') THEN

Line 274: App_Exception.Raise_Exception;

270: new_references.unit_class
271: ) THEN
272: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: END IF;
276: Check_Constraints;
277: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
278: Check_Constraints;

Line 316: app_exception.raise_exception;

312: end if;
313: else
314: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
315: IGS_GE_MSG_STACK.ADD;
316: app_exception.raise_exception;
317: end if;
318: --
319: Before_DML(
320: p_action=>'INSERT',

Line 403: app_exception.raise_exception;

399: if (c1%notfound) then
400: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
401: IGS_GE_MSG_STACK.ADD;
402: close c1;
403: app_exception.raise_exception;
404: return;
405: end if;
406: close c1;
407: if ( (tlinfo.UNIT_MODE = X_UNIT_MODE)

Line 424: app_exception.raise_exception;

420: null;
421: else
422: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
423: IGS_GE_MSG_STACK.ADD;
424: app_exception.raise_exception;
425: end if;
426: return;
427: end LOCK_ROW;
428: procedure UPDATE_ROW (

Line 459: app_exception.raise_exception;

455: end if;
456: else
457: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
458: IGS_GE_MSG_STACK.ADD;
459: app_exception.raise_exception;
460: end if;
461: --
462: Before_DML(
463: p_action=>'UPDATE',