DBA Data[Home] [Help]

APPS.IGS_RU_GROUP_SET_PKG dependencies on APP_EXCEPTION

Line 37: App_Exception.Raise_Exception;

33: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
34: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
35: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_GROUP_SET : P_ACTION INSERT VALIDATE_INSERT : IGSUI06B.PLS');
36: IGS_GE_MSG_STACK.ADD;
37: App_Exception.Raise_Exception;
38: Close cur_old_ref_values;
39: Return;
40: END IF;
41: Close cur_old_ref_values;

Line 78: App_Exception.Raise_Exception ;

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

Line 87: App_Exception.Raise_Exception ;

83: IF upper(Column_name) = 'RUG_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
84: IF new_references.RUG_SEQUENCE_NUMBER < 1 or new_references.RUG_SEQUENCE_NUMBER > 999999 then
85: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception ;
88: END IF;
89:
90: END IF ;
91:

Line 107: App_Exception.Raise_Exception;

103: ) THEN
104: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
105: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_DESCRIPTION : P_ACTION Check_Parent_Existance .rud_sequence_number : IGSUI06B.PLS');
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109: END IF;
110:
111: IF (((old_references.rug_sequence_number = new_references.rug_sequence_number)) OR

Line 121: App_Exception.Raise_Exception;

117: ) THEN
118: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
119: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_GROUP : P_ACTION Check_Parent_Existance .rug_sequence_number : IGSUI06B.PLS');
120: IGS_GE_MSG_STACK.ADD;
121: App_Exception.Raise_Exception;
122: END IF;
123: END IF;
124:
125: END Check_Parent_Existance;

Line 174: App_Exception.Raise_Exception;

170: IF (cur_rowid%FOUND) THEN
171: Close cur_rowid;
172: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RGS_RUD_FK');
173: IGS_GE_MSG_STACK.ADD;
174: App_Exception.Raise_Exception;
175: Return;
176: END IF;
177: Close cur_rowid;
178:

Line 200: App_Exception.Raise_Exception;

196: IF (cur_rowid%FOUND) THEN
197: Close cur_rowid;
198: Fnd_Message.Set_Name ('IGS', 'IGS_RU_RGS_RUG_FK');
199: IGS_GE_MSG_STACK.ADD;
200: App_Exception.Raise_Exception;
201: Return;
202: END IF;
203: Close cur_rowid;
204:

Line 254: App_Exception.Raise_Exception;

250: new_references.rud_sequence_number
251: ) THEN
252: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256: Check_Constraints;
257: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
258: Check_Constraints;

Line 301: app_exception.raise_exception;

297: end if;
298: else
299: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
300: IGS_GE_MSG_STACK.ADD;
301: app_exception.raise_exception;
302: end if;
303:
304: Before_DML(
305: p_action=>'INSERT',

Line 365: app_exception.raise_exception;

361: if (c1%notfound) then
362: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
363: IGS_RU_GEN_006.SET_TOKEN(' IGS_RU_GROUP_SET : P_ACTION LOCK_ROW : IGSUI06B.PLS');
364: IGS_GE_MSG_STACK.ADD;
365: app_exception.raise_exception;
366: close c1;
367: return;
368: end if;
369: close c1;