eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_FEE_STAT_PKG dependencies on APP_EXCEPTION

Line 40: App_Exception.Raise_Exception;

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

Line 81: App_Exception.Raise_Exception;

77: new_references.s_adm_fee_status,
78: v_message_name) = FALSE THEN
79: Fnd_Message.Set_Name('IGS',v_message_name);
80: IGS_GE_MSG_STACK.ADD;
81: App_Exception.Raise_Exception;
82: END IF;
83: END IF;
84: IF (new_references.closed_ind = 'Y' AND new_references.system_default_ind = 'Y') THEN
85: Fnd_Message.Set_Name('IGS','IGS_AD_SYS_DFLT_IND_NOTSET_CLS');

Line 87: App_Exception.Raise_Exception;

83: END IF;
84: IF (new_references.closed_ind = 'Y' AND new_references.system_default_ind = 'Y') THEN
85: Fnd_Message.Set_Name('IGS','IGS_AD_SYS_DFLT_IND_NOTSET_CLS');
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception;
88: END IF;
89:
90:
91: END BeforeRowInsertUpdate1;

Line 120: App_Exception.Raise_Exception ;

116: IF upper(Column_name) = 'ADM_FEE_STATUS' OR COLUMN_NAME IS NULL THEN
117: IF new_references.ADM_FEE_STATUS<> upper(new_references.ADM_FEE_STATUS) then
118: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
119: IGS_GE_MSG_STACK.ADD;
120: App_Exception.Raise_Exception ;
121: END IF;
122:
123: END IF ;
124:

Line 129: App_Exception.Raise_Exception ;

125: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
126: IF new_references.CLOSED_IND<> upper(new_references.CLOSED_IND) then
127: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception ;
130: END IF;
131:
132: IF new_references.CLOSED_IND not in ('Y','N') then
133: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 135: App_Exception.Raise_Exception ;

131:
132: IF new_references.CLOSED_IND not in ('Y','N') then
133: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception ;
136: END IF;
137:
138: END IF ;
139:

Line 145: App_Exception.Raise_Exception ;

141: IF upper(Column_name) = 'SYSTEM_DEFAULT_IND' OR COLUMN_NAME IS NULL THEN
142: IF new_references.SYSTEM_DEFAULT_IND<> upper(new_references.SYSTEM_DEFAULT_IND) then
143: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception ;
146: END IF;
147:
148: IF new_references.SYSTEM_DEFAULT_IND not in ('Y','N') then
149: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 151: App_Exception.Raise_Exception ;

147:
148: IF new_references.SYSTEM_DEFAULT_IND not in ('Y','N') then
149: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception ;
152: END IF;
153:
154: END IF ;
155:

Line 160: App_Exception.Raise_Exception ;

156: IF upper(Column_name) = 'S_ADM_FEE_STATUS' OR COLUMN_NAME IS NULL THEN
157: IF new_references.S_ADM_FEE_STATUS<> upper(new_references.S_ADM_FEE_STATUS) then
158: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception ;
161: END IF;
162:
163: END IF ;
164:

Line 182: App_Exception.Raise_Exception;

178: new_references.s_adm_fee_status
179: ) THEN
180: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
181: IGS_GE_MSG_STACK.ADD;
182: App_Exception.Raise_Exception;
183: END IF ;
184: END IF;
185:
186: END Check_Parent_Existance;

Line 248: App_Exception.Raise_Exception;

244: IF (cur_rowid%FOUND) THEN
245: Close cur_rowid;
246: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AFS_SAFS_FK');
247: IGS_GE_MSG_STACK.ADD;
248: App_Exception.Raise_Exception;
249: Return;
250: END IF;
251: Close cur_rowid;
252:

Line 295: App_Exception.Raise_Exception;

291: new_references.adm_fee_status
292: ) THEN
293: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
294: IGS_GE_MSG_STACK.ADD;
295: App_Exception.Raise_Exception;
296: END IF;
297: Check_Constraints;
298: Check_Parent_Existance;
299: ELSIF (p_action = 'UPDATE') THEN

Line 313: App_Exception.Raise_Exception;

309: IF Get_PK_For_Validation (
310: new_references.adm_fee_status ) THEN
311: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
312: IGS_GE_MSG_STACK.ADD;
313: App_Exception.Raise_Exception;
314: END IF;
315: Check_Constraints;
316: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
317: Check_Constraints;

Line 364: app_exception.raise_exception;

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

Line 447: app_exception.raise_exception;

443: if (c1%notfound) then
444: close c1;
445: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
446: IGS_GE_MSG_STACK.ADD;
447: app_exception.raise_exception;
448: return;
449: end if;
450: close c1;
451:

Line 461: app_exception.raise_exception;

457: null;
458: else
459: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
460: IGS_GE_MSG_STACK.ADD;
461: app_exception.raise_exception;
462: end if;
463: return;
464: end LOCK_ROW;
465:

Line 495: app_exception.raise_exception;

491: end if;
492: else
493: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
494: IGS_GE_MSG_STACK.ADD;
495: app_exception.raise_exception;
496: end if;
497:
498: Before_DML(
499: p_action=>'UPDATE' ,