DBA Data[Home] [Help]

APPS.IGS_FI_ENCMB_TYPE_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: -- Populate New Values.

Line 84: App_Exception.Raise_Exception;

80: IF new_references.CLOSED_IND <>
81: UPPER(new_references.CLOSED_IND) 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) = 'ENCUMBRANCE_TYPE' OR

Line 94: App_Exception.Raise_Exception;

90: IF new_references.ENCUMBRANCE_TYPE <>
91: UPPER(new_references.ENCUMBRANCE_TYPE) 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) = 'S_ENCUMBRANCE_CAT' OR

Line 104: App_Exception.Raise_Exception;

100: IF new_references.S_ENCUMBRANCE_CAT <>
101: UPPER(new_references.S_ENCUMBRANCE_CAT) Then
102: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105: END IF;
106: END IF;
107:
108: IF upper(column_name) = 'S_ENCUMBRANCE_CAT' OR

Line 113: App_Exception.Raise_Exception;

109: column_name is null Then
110: IF (new_references.s_encumbrance_cat not in ( 'ACADEMIC' , 'ADMIN')) Then
111: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception;
114: END IF;
115: END IF;
116:
117: IF upper(column_name) = 'CLOSED_IND' OR

Line 122: App_Exception.Raise_Exception;

118: column_name is null Then
119: IF (new_references.closed_ind not in ('Y', 'N')) Then
120: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
121: IGS_GE_MSG_STACK.ADD;
122: App_Exception.Raise_Exception;
123: END IF;
124: END IF;
125: END Check_Constraints;
126: Function Get_PK_For_Validation (

Line 188: App_Exception.Raise_Exception;

184: new_references.encumbrance_type
185: ) THEN
186: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF;
190: Check_Constraints;
191: ELSIF (p_action = 'UPDATE') THEN
192: -- Call all the procedures related to Before Update.

Line 201: App_Exception.Raise_Exception;

197: new_references.encumbrance_type
198: ) THEN
199: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;
203: Check_Constraints;
204: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
205: Check_Constraints;

Line 240: app_exception.raise_exception;

236: end if;
237: else
238: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
239: IGS_GE_MSG_STACK.ADD;
240: app_exception.raise_exception;
241: end if;
242: Before_DML (
243: p_action => 'INSERT',
244: x_rowid => X_ROWID,

Line 314: app_exception.raise_exception;

310: if (c1%notfound) then
311: close c1;
312: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
313: IGS_GE_MSG_STACK.ADD;
314: app_exception.raise_exception;
315: return;
316: end if;
317: close c1;
318: if ( (tlinfo.DESCRIPTION = X_DESCRIPTION)

Line 329: app_exception.raise_exception;

325: null;
326: else
327: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
328: IGS_GE_MSG_STACK.ADD;
329: app_exception.raise_exception;
330: end if;
331: return;
332: end LOCK_ROW;
333: procedure UPDATE_ROW (

Line 362: app_exception.raise_exception;

358: end if;
359: else
360: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
361: IGS_GE_MSG_STACK.ADD;
362: app_exception.raise_exception;
363: end if;
364: Before_DML (
365: p_action => 'UPDATE',
366: x_rowid => X_ROWID,