DBA Data[Home] [Help]

APPS.IGS_RU_TURIN_FNC_PKG dependencies on IGS_GE_MSG_STACK

Line 37: IGS_GE_MSG_STACK.ADD;

33: Fetch cur_old_ref_values INTO old_references;
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_TURIN_FNC : P_ACTION INSERT, VALIDATE_INSERT : IGSUI14B.PLS');
37: IGS_GE_MSG_STACK.ADD;
38: App_Exception.Raise_Exception;
39: Close cur_old_ref_values;
40: Return;
41: END IF;

Line 78: IGS_GE_MSG_STACK.ADD;

74: END IF;
75: IF upper(Column_Name) = 'PARENTHESIS_IND' OR Column_Name IS NULL THEN
76: IF new_references.parenthesis_ind NOT IN ('Y','N') THEN
77: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
78: IGS_GE_MSG_STACK.ADD;
79: App_Exception.Raise_Exception;
80: END IF;
81: END IF;
82: IF upper(Column_Name) = 'RUD_SEQUENCE_NUMBER' OR Column_Name IS NULL THEN

Line 85: IGS_GE_MSG_STACK.ADD;

81: END IF;
82: IF upper(Column_Name) = 'RUD_SEQUENCE_NUMBER' OR Column_Name IS NULL THEN
83: IF new_references.rud_sequence_number < 1 OR new_references.rud_sequence_number > 999999 THEN
84: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END IF;
89:

Line 104: IGS_GE_MSG_STACK.ADD;

100: new_references.rud_sequence_number
101: ) THEN
102: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
103: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_DESCRIPTION : P_ACTION Check_Parent_Existance rud_sequence_number : IGSUI14B.PLS');
104: IGS_GE_MSG_STACK.ADD;
105: App_Exception.Raise_Exception;
106: END IF;
107: END IF;
108:

Line 168: IGS_GE_MSG_STACK.ADD;

164: Fetch cur_rowid INTO lv_rowid;
165: IF (cur_rowid%FOUND) THEN
166: Close cur_rowid;
167: Fnd_Message.Set_Name ('IGS', 'IGS_RU_STF_RUD_FK');
168: IGS_GE_MSG_STACK.ADD;
169: App_Exception.Raise_Exception;
170: Return;
171: END IF;
172: Close cur_rowid;

Line 208: IGS_GE_MSG_STACK.ADD;

204: IF Get_PK_For_Validation (
205: new_references.s_turin_function
206: ) THEN
207: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
208: IGS_GE_MSG_STACK.ADD;
209: App_Exception.Raise_Exception;
210: END IF;
211: Check_Constraints;
212: Check_Parent_Existance;

Line 223: IGS_GE_MSG_STACK.ADD;

219: IF Get_PK_For_Validation (
220: new_references.s_turin_function
221: ) THEN
222: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
223: IGS_GE_MSG_STACK.ADD;
224: App_Exception.Raise_Exception;
225: END IF;
226: Check_Constraints;
227: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 274: IGS_GE_MSG_STACK.ADD;

270: X_LAST_UPDATE_LOGIN := -1;
271: end if;
272: else
273: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
274: IGS_GE_MSG_STACK.ADD;
275: app_exception.raise_exception;
276: end if;
277:
278: Before_DML(

Line 344: IGS_GE_MSG_STACK.ADD;

340: fetch c1 into tlinfo;
341: if (c1%notfound) then
342: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
343: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_TURIN_FNC : P_ACTION LOCK_ROW : IGSUI14B.PLS');
344: IGS_GE_MSG_STACK.ADD;
345: app_exception.raise_exception;
346: close c1;
347: return;
348: end if;

Line 360: IGS_GE_MSG_STACK.ADD;

356: null;
357: else
358: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
359: IGS_RU_GEN_006.SET_TOKEN('IGS_RU_TURIN_FNC : P_ACTION LOCK_ROW FORM_RECORD_CHANGED : IGSUI14B.PLS');
360: IGS_GE_MSG_STACK.ADD;
361: app_exception.raise_exception;
362: end if;
363: return;
364: end LOCK_ROW;

Line 392: IGS_GE_MSG_STACK.ADD;

388: X_LAST_UPDATE_LOGIN := -1;
389: end if;
390: else
391: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
392: IGS_GE_MSG_STACK.ADD;
393: app_exception.raise_exception;
394: end if;
395:
396: Before_DML(