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

Line 39: App_Exception.Raise_Exception;

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

Line 86: App_Exception.Raise_Exception;

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

Line 92: App_Exception.Raise_Exception;

88: END IF;
89: IF (new_references.closed_ind = 'Y' AND new_references.system_default_ind = 'Y') THEN
90: Fnd_Message.Set_Name('IGS','IGS_AD_SYS_DFLT_IND_NOTSET_CLS');
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END IF;
94:
95:
96: END BeforeRowInsertUpdate1;

Line 120: App_Exception.Raise_Exception;

116: IF upper(column_name) = 'ADM_CNDTNL_OFFER_STATUS' OR column_name is null Then
117: IF new_references.adm_cndtnl_offer_status<> UPPER(new_references.adm_cndtnl_offer_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: END IF;
123: IF upper(column_name) = 'CLOSED_IND' OR column_name is null Then
124: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then

Line 127: App_Exception.Raise_Exception;

123: IF upper(column_name) = 'CLOSED_IND' OR column_name is null Then
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: END IF;
130: IF upper(column_name) = 'SYSTEM_DEFAULT_IND' OR column_name is null Then
131: IF new_references.system_default_ind NOT IN ( 'Y' , 'N' ) Then

Line 134: App_Exception.Raise_Exception;

130: IF upper(column_name) = 'SYSTEM_DEFAULT_IND' OR column_name is null Then
131: IF new_references.system_default_ind NOT IN ( 'Y' , 'N' ) 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: END IF;
137: IF upper(column_name) = 'S_ADM_CNDTNL_OFFER_STATUS' OR column_name is null Then
138: IF new_references.s_adm_cndtnl_offer_status<> UPPER(new_references.s_adm_cndtnl_offer_status) Then

Line 141: App_Exception.Raise_Exception;

137: IF upper(column_name) = 'S_ADM_CNDTNL_OFFER_STATUS' OR column_name is null Then
138: IF new_references.s_adm_cndtnl_offer_status<> UPPER(new_references.s_adm_cndtnl_offer_status) Then
139: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF;
144: END Check_Constraints;
145:

Line 158: App_Exception.Raise_Exception;

154: 'ADM_CNDTNL_OFFER_STATUS',
155: new_references.s_adm_cndtnl_offer_status ) THEN
156: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160: END IF;
161:
162: END Check_Parent_Existance;

Line 215: App_Exception.Raise_Exception;

211: IF (cur_rowid%FOUND) THEN
212: Close cur_rowid;
213: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACOS_SLV_FK');
214: IGS_GE_MSG_STACK.ADD;
215: App_Exception.Raise_Exception;
216: Return;
217: END IF;
218: Close cur_rowid;
219:

Line 259: App_Exception.Raise_Exception;

255: IF Get_PK_For_Validation (
256: new_references.adm_cndtnl_offer_status ) THEN
257: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
258: IGS_GE_MSG_STACK.ADD;
259: App_Exception.Raise_Exception;
260: END IF;
261: Check_Constraints;
262: Check_Parent_Existance;
263: ELSIF (p_action = 'UPDATE') THEN

Line 276: App_Exception.Raise_Exception;

272: IF Get_PK_For_Validation (
273: new_references.adm_cndtnl_offer_status ) THEN
274: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
275: IGS_GE_MSG_STACK.ADD;
276: App_Exception.Raise_Exception;
277: END IF;
278: Check_Constraints;
279: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
280: Check_Constraints;

Line 327: app_exception.raise_exception;

323: end if;
324: else
325: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
326: IGS_GE_MSG_STACK.ADD;
327: app_exception.raise_exception;
328: end if;
329:
330: Before_DML(
331: p_action=>'INSERT',

Line 406: app_exception.raise_exception;

402: fetch c1 into tlinfo;
403: if (c1%notfound) then
404: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
405: IGS_GE_MSG_STACK.ADD;
406: app_exception.raise_exception;
407: close c1;
408: return;
409: end if;
410: close c1;

Line 421: app_exception.raise_exception;

417: null;
418: else
419: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
420: IGS_GE_MSG_STACK.ADD;
421: app_exception.raise_exception;
422: end if;
423: return;
424: end LOCK_ROW;
425:

Line 455: app_exception.raise_exception;

451: end if;
452: else
453: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
454: IGS_GE_MSG_STACK.ADD;
455: app_exception.raise_exception;
456: end if;
457:
458: Before_DML(
459: p_action=>'UPDATE',