APPS.IGS_AD_DISBL_TYPE_PKG dependencies on APP_EXCEPTION

Line 39: App_Exception.Raise_Exception;

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;
43:

Line 84: App_Exception.Raise_Exception ;

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
88: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 90: App_Exception.Raise_Exception ;

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 ;
94:

Line 100: App_Exception.Raise_Exception ;

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 ;
104:

Line 109: App_Exception.Raise_Exception ;

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
113: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 115: App_Exception.Raise_Exception ;

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 ;
119:

Line 197: App_Exception.Raise_Exception;

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
201: -- Call all the procedures related to Before Update.

Line 212: App_Exception.Raise_Exception;

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
216: Check_Constraints;

Line 266: app_exception.raise_exception;

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(
270: p_action =>'INSERT' ,

Line 346: app_exception.raise_exception;

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;
350:

Line 359: app_exception.raise_exception;

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;
363:

Line 392: app_exception.raise_exception;

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(
396: p_action=>'UPDATE' ,