DBA Data[Home] [Help]

APPS.IGS_RU_RULE_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: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_RULE : P_ACTION INSERT VALIDATE_INSERT : IGSUI11B.PLS');
34: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
35: IGS_GE_MSG_STACK.ADD;
36: App_Exception.Raise_Exception;
37: Close cur_old_ref_values;
38: Return;
39: END IF;
40: Close cur_old_ref_values;

Line 72: App_Exception.Raise_Exception;

68: IF upper(Column_Name) = 'SEQUENCE_NUMBER' OR Column_Name IS NULL THEN
69: IF new_references.sequence_number < 0 OR new_references.sequence_number > 999999 THEN
70: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
71: IGS_GE_MSG_STACK.ADD;
72: App_Exception.Raise_Exception;
73: END IF;
74: END IF;
75:
76: END Check_Constraints;

Line 136: App_Exception.Raise_Exception;

132: new_references.sequence_number
133: ) THEN
134: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception;
137: END IF;
138: Check_Constraints;
139: ELSIF (p_action = 'UPDATE') THEN
140: Check_Constraints;

Line 161: App_Exception.Raise_Exception;

157: new_references.sequence_number
158: ) THEN
159: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163: Check_Constraints;
164: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
165: Check_Constraints;

Line 235: app_exception.raise_exception;

231: end if;
232: else
233: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
234: IGS_GE_MSG_STACK.ADD;
235: app_exception.raise_exception;
236: end if;
237:
238: Before_DML(
239: p_action=>'INSERT',

Line 270: App_Exception.Raise_Exception ;

266: --
267: IF (l_sequence_number > 499999) THEN
268: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception ;
271: END IF;
272: ELSE
273: l_sequence_number := NEW_REFERENCES.SEQUENCE_NUMBER;
274: END IF;

Line 322: app_exception.raise_exception;

318: if (c1%notfound) then
319: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
320: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_RULE : P_ACTION LOCK_ROW : IGSUI11B.PLS');
321: IGS_GE_MSG_STACK.ADD;
322: app_exception.raise_exception;
323: close c1;
324: return;
325: end if;
326: close c1;