DBA Data[Home] [Help]

APPS.IGS_RU_RULE_PKG dependencies on IGS_GE_MSG_STACK

Line 35: IGS_GE_MSG_STACK.ADD;

31: Fetch cur_old_ref_values INTO old_references;
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;

Line 71: IGS_GE_MSG_STACK.ADD;

67: END IF;
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:

Line 135: IGS_GE_MSG_STACK.ADD;

131: IF Get_PK_For_Validation (
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

Line 160: IGS_GE_MSG_STACK.ADD;

156: IF Get_PK_For_Validation (
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

Line 234: IGS_GE_MSG_STACK.ADD;

230: X_LAST_UPDATE_LOGIN := -1;
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(

Line 269: IGS_GE_MSG_STACK.ADD;

265: -- Seeded Sequences can go upto 499999 only else raise an error
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;

Line 321: IGS_GE_MSG_STACK.ADD;

317: fetch c1 into tlinfo;
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;