DBA Data[Home] [Help]

APPS.IGS_RU_GROUP_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_RU_GEN_006.SET_TOKEN('IGS_RU_GROUP : P_ACTION INSERT VALIDATE_INSERT : IGSUI04B.PLS');
37: IGS_GE_MSG_STACK.ADD;
38: App_Exception.Raise_Exception;
39: Close cur_old_ref_values;
40: Return;
41: END IF;
42: Close cur_old_ref_values;

Line 77: App_Exception.Raise_Exception ;

73: IF upper(Column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
74: IF new_references.SEQUENCE_NUMBER < 1 or new_references.SEQUENCE_NUMBER > 999999 then
75: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
76: IGS_GE_MSG_STACK.ADD;
77: App_Exception.Raise_Exception ;
78: END IF;
79:
80: END IF ;
81:

Line 90: App_Exception.Raise_Exception;

86: BEGIN
87: IF GET_UK1_FOR_VALIDATION ( new_references.group_name ) THEN
88: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
89: IGS_GE_MSG_STACK.ADD;
90: App_Exception.Raise_Exception;
91: END IF ;
92: END CHECK_UNIQUENESS ;
93:
94: PROCEDURE Check_Child_Existance as

Line 221: App_Exception.Raise_Exception;

217: new_references.sequence_number
218: ) THEN
219: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
220: IGS_GE_MSG_STACK.ADD;
221: App_Exception.Raise_Exception;
222: END IF;
223: Check_Uniqueness;
224: Check_Constraints;
225: ELSIF (p_action = 'UPDATE') THEN

Line 238: App_Exception.Raise_Exception;

234: new_references.sequence_number
235: ) THEN
236: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
237: IGS_GE_MSG_STACK.ADD;
238: App_Exception.Raise_Exception;
239: END IF;
240: Check_Uniqueness;
241: Check_Constraints;
242: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 289: app_exception.raise_exception;

285: end if;
286: else
287: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
288: IGS_GE_MSG_STACK.ADD;
289: app_exception.raise_exception;
290: end if;
291:
292: Before_DML(
293: p_action=>'INSERT',

Line 354: app_exception.raise_exception;

350: if (c1%notfound) then
351: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
352: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_GROUP : P_ACTION LOCK_ROW : IGSUI04B.PLS');
353: IGS_GE_MSG_STACK.ADD;
354: app_exception.raise_exception;
355: close c1;
356: return;
357: end if;
358: close c1;

Line 369: app_exception.raise_exception;

365: else
366: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
367: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_GROUP : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI04B.PLS');
368: IGS_GE_MSG_STACK.ADD;
369: app_exception.raise_exception;
370: end if;
371: return;
372: end LOCK_ROW;
373:

Line 400: app_exception.raise_exception;

396: end if;
397: else
398: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
399: IGS_GE_MSG_STACK.ADD;
400: app_exception.raise_exception;
401: end if;
402:
403: Before_DML(
404: p_action=>'UPDATE',