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_APPL_STAT_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_appl_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: END BeforeRowInsertUpdate1;
95:
96: PROCEDURE Check_Constraints (

Line 119: App_Exception.Raise_Exception;

115: IF upper(column_name) = 'ADM_APPL_STATUS' OR column_name is null Then
116: IF new_references.adm_appl_status <> UPPER(new_references.adm_appl_status ) 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: END IF;
122: IF upper(column_name) = 'CLOSED_IND' OR column_name is null Then
123: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then

Line 126: App_Exception.Raise_Exception;

122: IF upper(column_name) = 'CLOSED_IND' OR column_name is null Then
123: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
124: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: END IF;
128: END IF;
129: IF upper(column_name) = 'SYSTEM_DEFAULT_IND' OR column_name is null Then
130: IF new_references.system_default_ind NOT IN ( 'Y' , 'N' ) Then

Line 133: App_Exception.Raise_Exception;

129: IF upper(column_name) = 'SYSTEM_DEFAULT_IND' OR column_name is null Then
130: IF new_references.system_default_ind NOT IN ( 'Y' , 'N' ) Then
131: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
132: IGS_GE_MSG_STACK.ADD;
133: App_Exception.Raise_Exception;
134: END IF;
135: END IF;
136:
137: IF upper(column_name) = 'S_ADM_APPL_STATUS' OR column_name is null Then

Line 143: App_Exception.Raise_Exception;

139: IF new_references.s_adm_appl_status <> UPPER(new_references.s_adm_appl_status ) Then
140:
141: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144:
145: END IF;
146: END IF;
147: END Check_Constraints;

Line 161: App_Exception.Raise_Exception;

157: 'ADM_APPL_STATUS',
158: new_references.s_adm_appl_status ) THEN
159: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163: END IF;
164:
165: END Check_Parent_Existance;

Line 218: App_Exception.Raise_Exception;

214: IF (cur_rowid%FOUND) THEN
215: Close cur_rowid;
216: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AAS_SLV_FK');
217: IGS_GE_MSG_STACK.ADD;
218: App_Exception.Raise_Exception;
219: Return;
220: END IF;
221: Close cur_rowid;
222:

Line 263: App_Exception.Raise_Exception;

259: IF Get_PK_For_Validation (
260: new_references.adm_appl_status ) THEN
261: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264: END IF;
265: Check_Constraints;
266: Check_Parent_Existance;
267: ELSIF (p_action = 'UPDATE') THEN

Line 280: App_Exception.Raise_Exception;

276: IF Get_PK_For_Validation (
277: new_references.adm_appl_status ) THEN
278: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: END IF;
282: Check_Constraints;
283: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
284: Check_Constraints;

Line 339: app_exception.raise_exception;

335: end if;
336: else
337: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
338: IGS_GE_MSG_STACK.ADD;
339: app_exception.raise_exception;
340: end if;
341:
342: Before_DML(
343: p_action=>'INSERT',

Line 418: app_exception.raise_exception;

414: fetch c1 into tlinfo;
415: if (c1%notfound) then
416: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
417: IGS_GE_MSG_STACK.ADD;
418: app_exception.raise_exception;
419: close c1;
420: return;
421: end if;
422: close c1;

Line 433: app_exception.raise_exception;

429: null;
430: else
431: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
432: IGS_GE_MSG_STACK.ADD;
433: app_exception.raise_exception;
434: end if;
435: return;
436: end LOCK_ROW;
437:

Line 467: app_exception.raise_exception;

463: end if;
464: else
465: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
466: IGS_GE_MSG_STACK.ADD;
467: app_exception.raise_exception;
468: end if;
469:
470: Before_DML(
471: p_action=>'UPDATE',