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

Line 89: App_Exception.Raise_Exception;

85: new_references.govt_funding_source,
86: v_message_name) = FALSE THEN
87: Fnd_Message.Set_Name('IGS',v_message_name);
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: END IF;
91: END IF;
92: -- Create history record.
93: IF p_updating THEN

Line 148: App_Exception.Raise_Exception;

144: new_references.closed_ind <> 'N'
145: THEN
146: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: END IF;
151: IF upper(Column_Name) = 'FUNDING_SOURCE' OR
152: column_name is NULL THEN

Line 156: App_Exception.Raise_Exception;

152: column_name is NULL THEN
153: IF new_references.funding_source <> UPPER(new_references.funding_source) THEN
154: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF;
158: END IF;
159:
160: END Check_Constraints;

Line 171: App_Exception.Raise_Exception;

167: ELSIF NOT IGS_FI_GOVT_FUND_SRC_PKG.Get_PK_For_Validation (
168: new_references.govt_funding_source ) THEN
169: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173: END Check_Parent_Existance;
174:
175: PROCEDURE Check_Child_Existance AS

Line 241: App_Exception.Raise_Exception;

237: IF (cur_rowid%FOUND) THEN
238: Close cur_rowid;
239: Fnd_Message.Set_Name ('IGS', 'IGS_FI_FS_GFS_FK');
240: IGS_GE_MSG_STACK.ADD;
241: App_Exception.Raise_Exception;
242: Return;
243: END IF;
244: Close cur_rowid;
245: END GET_FK_IGS_FI_GOVT_FUND_SRC;

Line 282: App_Exception.Raise_Exception;

278: BeforeRowInsertUpdateDelete1 ( p_inserting => TRUE );
279: IF Get_PK_For_Validation ( new_references.funding_source) THEN
280: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
281: IGS_GE_MSG_STACK.ADD;
282: App_Exception.Raise_Exception;
283: END IF;
284: Check_Constraints;
285: Check_Parent_Existance;
286: ELSIF (p_action = 'UPDATE') THEN

Line 301: App_Exception.Raise_Exception;

297: -- Call all the procedures related to Before Insert.
298: IF Get_PK_For_Validation ( new_references.funding_source) THEN
299: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
300: IGS_GE_MSG_STACK.ADD;
301: App_Exception.Raise_Exception;
302: END IF;
303: Check_Constraints;
304: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
305: Check_Constraints;

Line 348: app_exception.raise_exception;

344: end if;
345: else
346: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
347: IGS_GE_MSG_STACK.ADD;
348: app_exception.raise_exception;
349: end if;
350: Before_DML(
351: p_action=>'INSERT',
352: x_rowid=>X_ROWID,

Line 418: app_exception.raise_exception;

414: if (c1%notfound) then
415: close c1;
416: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
417: IGS_GE_MSG_STACK.ADD;
418: app_exception.raise_exception;
419: return;
420: end if;
421: close c1;
422: if ( (tlinfo.DESCRIPTION = X_DESCRIPTION)

Line 430: app_exception.raise_exception;

426: null;
427: else
428: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
429: IGS_GE_MSG_STACK.ADD;
430: app_exception.raise_exception;
431: end if;
432: return;
433: end LOCK_ROW;
434:

Line 464: app_exception.raise_exception;

460: end if;
461: else
462: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
463: IGS_GE_MSG_STACK.ADD;
464: app_exception.raise_exception;
465: end if;
466: Before_DML(
467: p_action=>'UPDATE',
468: x_rowid=>X_ROWID,

Line 566: APP_EXCEPTION.RAISE_EXCEPTION;

562: BEGIN
563: -- Preventing deletion of the Funding source records. As a part of Bug # 2729917
564: FND_MESSAGE.SET_NAME('IGS','IGS_FI_DEL_NOT_ALLWD');
565: IGS_GE_MSG_STACK.ADD;
566: APP_EXCEPTION.RAISE_EXCEPTION;
567: END beforerowdelete;
568:
569: end IGS_FI_FUND_SRC_PKG;