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_OFRDFRMT_STAT_PKG dependencies on APP_EXCEPTION

Line 41: App_Exception.Raise_Exception;

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

Line 81: App_Exception.Raise_Exception;

77: new_references.s_adm_offer_dfrmnt_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 121: App_Exception.Raise_Exception ;

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

Line 127: App_Exception.Raise_Exception ;

123:
124: IF new_references.CLOSED_IND not in ('Y','N') then
125: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
126: IGS_GE_MSG_STACK.ADD;
127: App_Exception.Raise_Exception ;
128: END IF;
129:
130: END IF ;
131:

Line 136: App_Exception.Raise_Exception ;

132: IF upper(Column_name) = 'ADM_OFFER_DFRMNT_STATUS' OR COLUMN_NAME IS NULL THEN
133: IF new_references.ADM_OFFER_DFRMNT_STATUS<> upper(new_references.ADM_OFFER_DFRMNT_STATUS) then
134: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception ;
137: END IF;
138:
139: END IF ;
140:

Line 146: App_Exception.Raise_Exception ;

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

Line 152: App_Exception.Raise_Exception ;

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

Line 161: App_Exception.Raise_Exception ;

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

Line 181: App_Exception.Raise_Exception;

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

Line 243: App_Exception.Raise_Exception;

239: IF (cur_rowid%FOUND) THEN
240: Close cur_rowid;
241: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AODS_SAODS_FK');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: Return;
245: END IF;
246: Close cur_rowid;
247:

Line 289: App_Exception.Raise_Exception;

285: new_references.adm_offer_dfrmnt_status
286: ) THEN
287: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
288: IGS_GE_MSG_STACK.ADD;
289: App_Exception.Raise_Exception;
290: END IF;
291: Check_Constraints;
292: Check_Parent_Existance;
293: ELSIF (p_action = 'UPDATE') THEN

Line 309: App_Exception.Raise_Exception;

305: new_references.adm_offer_dfrmnt_status
306: ) THEN
307: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
308: IGS_GE_MSG_STACK.ADD;
309: App_Exception.Raise_Exception;
310: END IF;
311: Check_Constraints;
312: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
313: Check_Constraints;

Line 358: app_exception.raise_exception;

354: end if;
355: else
356: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
357: IGS_GE_MSG_STACK.ADD;
358: app_exception.raise_exception;
359: end if;
360:
361: Before_DML(
362: p_action=>'INSERT' ,

Line 440: app_exception.raise_exception;

436: if (c1%notfound) then
437: close c1;
438: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
439: IGS_GE_MSG_STACK.ADD;
440: app_exception.raise_exception;
441: return;
442: end if;
443: close c1;
444:

Line 454: app_exception.raise_exception;

450: null;
451: else
452: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
453: IGS_GE_MSG_STACK.ADD;
454: app_exception.raise_exception;
455: end if;
456: return;
457: end LOCK_ROW;
458:

Line 488: app_exception.raise_exception;

484: end if;
485: else
486: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
487: IGS_GE_MSG_STACK.ADD;
488: app_exception.raise_exception;
489: end if;
490:
491: Before_DML(
492: p_action=>'UPDATE' ,