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_OFR_RESP_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 80: App_Exception.Raise_Exception;

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

Line 86: App_Exception.Raise_Exception;

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

Line 119: App_Exception.Raise_Exception ;

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

Line 125: App_Exception.Raise_Exception ;

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

Line 134: App_Exception.Raise_Exception ;

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

Line 144: App_Exception.Raise_Exception ;

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

Line 150: App_Exception.Raise_Exception ;

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

Line 159: App_Exception.Raise_Exception ;

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

Line 178: App_Exception.Raise_Exception;

174: 'ADM_OFFER_RESP_STATUS',new_references.s_adm_offer_resp_status
175: ) THEN
176: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
177: IGS_GE_MSG_STACK.ADD;
178: App_Exception.Raise_Exception;
179: END IF;
180: END IF;
181:
182: END Check_Parent_Existance;

Line 240: App_Exception.Raise_Exception;

236: IF (cur_rowid%FOUND) THEN
237: Close cur_rowid;
238: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AORS_SLV_FK');
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: Return;
242: END IF;
243: Close cur_rowid;
244:

Line 286: App_Exception.Raise_Exception;

282: IF Get_PK_For_Validation (
283: new_references.adm_offer_resp_status ) THEN
284: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
285: IGS_GE_MSG_STACK.ADD;
286: App_Exception.Raise_Exception;
287: END IF;
288: Check_Constraints;
289: Check_Parent_Existance;
290: ELSIF (p_action = 'UPDATE') THEN

Line 305: App_Exception.Raise_Exception;

301: new_references.adm_offer_resp_status
302: ) THEN
303: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: END IF;
307: Check_Constraints;
308: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
309: 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 441: app_exception.raise_exception;

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

Line 455: app_exception.raise_exception;

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

Line 489: app_exception.raise_exception;

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