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

Line 38: App_Exception.Raise_Exception;

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

Line 83: App_Exception.Raise_Exception;

79: new_references.version_number,
80: v_message_name) = FALSE THEN
81: Fnd_Message.Set_Name('IGS', v_message_name);
82: IGS_GE_MSG_STACK.ADD;
83: App_Exception.Raise_Exception;
84: END IF;
85: ELSE
86: IF IGS_PS_VAL_COUSR.crsp_val_iud_us_dtl(
87: old_references.unit_set_cd,

Line 92: App_Exception.Raise_Exception;

88: old_references.version_number,
89: v_message_name) = FALSE THEN
90: Fnd_Message.Set_Name('IGS', v_message_name);
91: IGS_GE_MSG_STACK.ADD;
92: App_Exception.Raise_Exception;
93: END IF;
94: END IF;
95: -- Validate UNIT Set IGS_RU_RULE
96: IF p_inserting OR p_updating THEN

Line 108: App_Exception.Raise_Exception;

104: new_references.rul_sequence_number,
105: v_message_name) = FALSE THEN
106: Fnd_Message.Set_Name('IGS', v_message_name);
107: IGS_GE_MSG_STACK.ADD;
108: App_Exception.Raise_Exception;
109: END IF;
110: END IF;
111:
112:

Line 139: App_Exception.Raise_Exception;

135: Column_name is null THEN
136: IF new_references.s_rule_call_cd <> UPPER(new_references.s_rule_call_cd) THEN
137: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
138: IGS_GE_MSG_STACK.ADD;
139: App_Exception.Raise_Exception;
140: END IF;
141: END IF;
142:
143: IF upper(column_name) = 'RUL_SEQUENCE_NUMBER' OR

Line 148: App_Exception.Raise_Exception;

144: Column_name is null THEN
145: IF new_references.rul_sequence_number NOT BETWEEN 0 AND 999999 THEN
146: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: END IF;
151:
152: IF upper(column_name) = 'UNIT_SET_CD' OR

Line 157: App_Exception.Raise_Exception;

153: Column_name is null THEN
154: IF new_references.unit_set_cd <> UPPER(new_references.unit_set_cd) THEN
155: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159: END IF;
160:
161: END Check_constraints;

Line 175: App_Exception.Raise_Exception;

171: new_references.rul_sequence_number
172: )Then
173: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF ;
177: END IF;
178:
179: IF (((old_references.s_rule_call_cd = new_references.s_rule_call_cd)) OR

Line 188: App_Exception.Raise_Exception;

184: new_references.s_rule_call_cd
185: )Then
186: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF ;
190: END IF;
191:
192: IF (((old_references.unit_set_cd = new_references.unit_set_cd) AND

Line 204: App_Exception.Raise_Exception;

200: new_references.version_number
201: )Then
202: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
203: IGS_GE_MSG_STACK.ADD;
204: App_Exception.Raise_Exception;
205: END IF ;
206: END IF;
207:
208: END Check_Parent_Existance;

Line 259: App_Exception.Raise_Exception;

255: IF (cur_rowid%FOUND) THEN
256: Close cur_rowid;
257: Fnd_Message.Set_Name ('IGS', 'IGS_EN_USR_RUL_FK');
258: IGS_GE_MSG_STACK.ADD;
259: App_Exception.Raise_Exception;
260: Return;
261: END IF;
262: Close cur_rowid;
263:

Line 285: App_Exception.Raise_Exception;

281: IF (cur_rowid%FOUND) THEN
282: Close cur_rowid;
283: Fnd_Message.Set_Name ('IGS', 'IGS_EN_USR_SRC_FK');
284: IGS_GE_MSG_STACK.ADD;
285: App_Exception.Raise_Exception;
286: Return;
287: END IF;
288: Close cur_rowid;
289:

Line 313: App_Exception.Raise_Exception;

309: IF (cur_rowid%FOUND) THEN
310: Close cur_rowid;
311: Fnd_Message.Set_Name ('IGS', 'IGS_EN_USR_US_FK');
312: IGS_GE_MSG_STACK.ADD;
313: App_Exception.Raise_Exception;
314: Return;
315: END IF;
316: Close cur_rowid;
317:

Line 359: App_Exception.Raise_Exception;

355: new_references.s_rule_call_cd
356: ) THEN
357: FND_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
358: IGS_GE_MSG_STACK.ADD;
359: App_Exception.Raise_Exception;
360: END if;
361: Check_constraints;
362: Check_Parent_Existance;
363: ELSIF (p_action = 'UPDATE') THEN

Line 379: App_Exception.Raise_Exception;

375: new_references.s_rule_call_cd
376: ) THEN
377: FND_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
378: IGS_GE_MSG_STACK.ADD;
379: App_Exception.Raise_Exception;
380: END if;
381: Check_constraints;
382: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
383: Check_constraints;

Line 443: app_exception.raise_exception;

439: end if;
440: else
441: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
442: IGS_GE_MSG_STACK.ADD;
443: app_exception.raise_exception;
444: end if;
445: Before_DML (
446: p_action => 'INSERT',
447: x_rowid => X_ROWID,

Line 514: app_exception.raise_exception;

510: if (c1%notfound) then
511: close c1;
512: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
513: IGS_GE_MSG_STACK.ADD;
514: app_exception.raise_exception;
515: return;
516: end if;
517: close c1;
518:

Line 525: app_exception.raise_exception;

521: null;
522: else
523: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
524: IGS_GE_MSG_STACK.ADD;
525: app_exception.raise_exception;
526: end if;
527: return;
528: end LOCK_ROW;
529:

Line 558: app_exception.raise_exception;

554: end if;
555: else
556: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
557: IGS_GE_MSG_STACK.ADD;
558: app_exception.raise_exception;
559: end if;
560: Before_DML (
561: p_action => 'UPDATE',
562: x_rowid => X_ROWID,