DBA Data[Home] [Help]

APPS.IGS_PS_GOVT_DSCP_PKG dependencies on IGS_GE_MSG_STACK

Line 36: IGS_GE_MSG_STACK.ADD;

32: Fetch cur_old_ref_values INTO old_references;
33: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
34: Close cur_old_ref_values;
35: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
36: IGS_GE_MSG_STACK.ADD;
37: App_Exception.Raise_Exception;
38: Return;
39: END IF;
40: Close cur_old_ref_values;

Line 74: IGS_GE_MSG_STACK.ADD;

70: new_references.govt_discipline_group_cd,
71: new_references.closed_ind,
72: v_message_name) = FALSE THEN
73: Fnd_Message.Set_Name('IGS', v_message_name);
74: IGS_GE_MSG_STACK.ADD;
75: App_Exception.Raise_Exception;
76: END IF;
77: END IF;
78:

Line 100: IGS_GE_MSG_STACK.ADD;

96: IF upper(column_name) = 'CLOSED_IND' OR
97: column_name is null Then
98: IF new_references.closed_ind NOT IN ('Y','N') THEN
99: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: END IF;
103: END IF;
104:

Line 109: IGS_GE_MSG_STACK.ADD;

105: IF upper(column_name) = 'GOVT_DISCIPLINE_GROUP_CD' OR
106: column_name is null Then
107: IF new_references.govt_discipline_group_cd <> UPPER(new_references.govt_discipline_group_cd) Then
108: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: END IF;
112: END IF;
113: END check_constraints;

Line 187: IGS_GE_MSG_STACK.ADD;

183: IF Get_PK_For_Validation (
184: new_references.govt_discipline_group_cd
185: ) THEN
186: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF;
190: Check_Constraints;
191: ELSIF (p_action = 'UPDATE') THEN

Line 204: IGS_GE_MSG_STACK.ADD;

200: IF Get_PK_For_Validation (
201: new_references.govt_discipline_group_cd
202: ) THEN
203: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
204: IGS_GE_MSG_STACK.ADD;
205: App_Exception.Raise_Exception;
206: END IF;
207: Check_Constraints;
208: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 255: IGS_GE_MSG_STACK.ADD;

251: X_LAST_UPDATE_LOGIN := -1;
252: end if;
253: else
254: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
255: IGS_GE_MSG_STACK.ADD;
256: app_exception.raise_exception;
257: end if;
258:
259: Before_DML( p_action => 'INSERT',

Line 322: IGS_GE_MSG_STACK.ADD;

318: fetch c1 into tlinfo;
319: if (c1%notfound) then
320: close c1;
321: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
322: IGS_GE_MSG_STACK.ADD;
323: app_exception.raise_exception;
324: return;
325: end if;
326: close c1;

Line 334: IGS_GE_MSG_STACK.ADD;

330: ) then
331: null;
332: else
333: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
334: IGS_GE_MSG_STACK.ADD;
335: app_exception.raise_exception;
336: end if;
337: return;
338: end LOCK_ROW;

Line 366: IGS_GE_MSG_STACK.ADD;

362: X_LAST_UPDATE_LOGIN := -1;
363: end if;
364: else
365: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
366: IGS_GE_MSG_STACK.ADD;
367: app_exception.raise_exception;
368: end if;
369:
370: Before_DML( p_action => 'UDPATE',