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

Line 39: App_Exception.Raise_Exception;

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

Line 87: App_Exception.Raise_Exception;

83: v_version_number,
84: v_message_name) = FALSE THEN
85: Fnd_Message.Set_Name('IGS',v_message_name);
86: IGS_GE_MSG_STACK.ADD;
87: App_Exception.Raise_Exception;
88: END IF;
89: -- Validate IGS_PS_DSCP group code. IGS_PS_DSCP group code is not updateable.
90: IF p_inserting THEN
91: IF IGS_PS_VAL_UD.crsp_val_ud_dg_cd (

Line 96: App_Exception.Raise_Exception;

92: new_references.discipline_group_cd,
93: v_message_name) = FALSE THEN
94: Fnd_Message.Set_Name('IGS',v_message_name);
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: END IF;
98: END IF;
99: -- Create history record.
100: IF p_updating THEN

Line 150: App_Exception.Raise_Exception;

146: IF Upper(Column_Name)='PERCENTAGE' OR Column_Name IS NULL Then
147: IF New_References.Percentage <= 0 OR New_References.Percentage > 100 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: END IF;
153:
154: IF Upper(Column_Name)='DISCIPLINE_GROUP_CD' OR Column_Name IS NULL Then

Line 158: App_Exception.Raise_Exception;

154: IF Upper(Column_Name)='DISCIPLINE_GROUP_CD' OR Column_Name IS NULL Then
155: IF New_References.Discipline_Group_Cd <> UPPER(New_References.Discipline_Group_Cd) Then
156: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160: END IF;
161:
162: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then

Line 166: App_Exception.Raise_Exception;

162: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then
163: IF New_References.Unit_Cd <> UPPER(New_References.Unit_CD) Then
164: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF;
168: END IF;
169:
170: END Check_Constraints;

Line 185: App_Exception.Raise_Exception;

181: ) THEN
182:
183: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
184: IGS_GE_MSG_STACK.ADD;
185: App_Exception.Raise_Exception;
186: END IF;
187:
188: END IF;
189:

Line 203: App_Exception.Raise_Exception;

199: ) THEN
200:
201: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
202: IGS_GE_MSG_STACK.ADD;
203: App_Exception.Raise_Exception;
204: END IF;
205:
206: END IF;
207:

Line 260: App_Exception.Raise_Exception;

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

Line 288: App_Exception.Raise_Exception;

284: IF (cur_rowid%FOUND) THEN
285: Close cur_rowid;
286: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UD_UV_FK');
287: IGS_GE_MSG_STACK.ADD;
288: App_Exception.Raise_Exception;
289: Return;
290: END IF;
291: Close cur_rowid;
292:

Line 332: App_Exception.Raise_Exception;

328: New_References.version_number,
329: New_References.discipline_group_cd) THEN
330: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
331: IGS_GE_MSG_STACK.ADD;
332: App_Exception.Raise_Exception;
333: END IF;
334: Check_Constraints;
335: Check_Parent_Existance;
336: ELSIF (p_action = 'UPDATE') THEN

Line 350: App_Exception.Raise_Exception;

346: New_References.version_number,
347: New_References.discipline_group_cd) THEN
348: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
349: IGS_GE_MSG_STACK.ADD;
350: App_Exception.Raise_Exception;
351: END IF;
352: Check_Constraints;
353: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
354: Check_Constraints;

Line 403: app_exception.raise_exception;

399: end if;
400: else
401: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
402: IGS_GE_MSG_STACK.ADD;
403: app_exception.raise_exception;
404: end if;
405:
406: Before_DML(
407: p_action => 'INSERT',

Line 476: app_exception.raise_exception;

472: if (c1%notfound) then
473: close c1;
474: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
475: IGS_GE_MSG_STACK.ADD;
476: app_exception.raise_exception;
477: return;
478: end if;
479: close c1;
480:

Line 487: app_exception.raise_exception;

483: null;
484: else
485: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
486: IGS_GE_MSG_STACK.ADD;
487: app_exception.raise_exception;
488: end if;
489: return;
490: end LOCK_ROW;
491:

Line 520: app_exception.raise_exception;

516: end if;
517: else
518: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
519: IGS_GE_MSG_STACK.ADD;
520: app_exception.raise_exception;
521: end if;
522:
523: Before_DML(
524: p_action => 'UPDATE',