APPS.IGS_AD_DISBL_TYPE_PKG dependencies on IGS_GE_MSG_STACK

Line 38: IGS_GE_MSG_STACK.ADD;

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

Line 83: IGS_GE_MSG_STACK.ADD;

79:
80: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
81: IF new_references.CLOSED_IND<> upper(new_references.CLOSED_IND) then
82: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
83: IGS_GE_MSG_STACK.ADD;
84: App_Exception.Raise_Exception ;
85: END IF;
86:
87: IF new_references.CLOSED_IND not in ('Y','N') then

Line 89: IGS_GE_MSG_STACK.ADD;

85: END IF;
86:
87: IF new_references.CLOSED_IND not in ('Y','N') then
88: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
89: IGS_GE_MSG_STACK.ADD;
90: App_Exception.Raise_Exception ;
91: END IF;
92:
93: END IF ;

Line 99: IGS_GE_MSG_STACK.ADD;

95:
96: IF upper(Column_name) = 'DISABILITY_TYPE' OR COLUMN_NAME IS NULL THEN
97: IF new_references.DISABILITY_TYPE<> upper(new_references.DISABILITY_TYPE) then
98: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception ;
101: END IF;
102:
103: END IF ;

Line 108: IGS_GE_MSG_STACK.ADD;

104:
105: IF upper(Column_name) = 'GOVT_DISABILITY_TYPE' OR COLUMN_NAME IS NULL THEN
106: IF new_references.GOVT_DISABILITY_TYPE<> upper(new_references.GOVT_DISABILITY_TYPE) then
107: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception ;
110: END IF;
111:
112: IF new_references.GOVT_DISABILITY_TYPE not in ('HEARING' , 'MOBILITY' , 'MEDICAL' , 'LEARNING' , 'VISION' , 'OTHER' , 'NONE' ) then

Line 114: IGS_GE_MSG_STACK.ADD;

110: END IF;
111:
112: IF new_references.GOVT_DISABILITY_TYPE not in ('HEARING' , 'MOBILITY' , 'MEDICAL' , 'LEARNING' , 'VISION' , 'OTHER' , 'NONE' ) then
113: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception ;
116: END IF;
117:
118: END IF ;

Line 196: IGS_GE_MSG_STACK.ADD;

192: IF Get_PK_For_Validation (
193: new_references.disability_type
194: ) THEN
195: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
196: IGS_GE_MSG_STACK.ADD;
197: App_Exception.Raise_Exception;
198: END IF;
199: Check_Constraints;
200: ELSIF (p_action = 'UPDATE') THEN

Line 211: IGS_GE_MSG_STACK.ADD;

207: IF Get_PK_For_Validation (
208: new_references.disability_type
209: ) THEN
210: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
211: IGS_GE_MSG_STACK.ADD;
212: App_Exception.Raise_Exception;
213: END IF;
214: Check_Constraints;
215: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 265: IGS_GE_MSG_STACK.ADD;

261: X_LAST_UPDATE_LOGIN := -1;
262: end if;
263: else
264: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
265: IGS_GE_MSG_STACK.ADD;
266: app_exception.raise_exception;
267: end if;
268:
269: Before_DML(

Line 345: IGS_GE_MSG_STACK.ADD;

341: fetch c1 into tlinfo;
342: if (c1%notfound) then
343: close c1;
344: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
345: IGS_GE_MSG_STACK.ADD;
346: app_exception.raise_exception;
347: return;
348: end if;
349: close c1;

Line 358: IGS_GE_MSG_STACK.ADD;

354: ) then
355: null;
356: else
357: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
358: IGS_GE_MSG_STACK.ADD;
359: app_exception.raise_exception;
360: end if;
361: return;
362: end LOCK_ROW;

Line 391: IGS_GE_MSG_STACK.ADD;

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