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

Line 41: App_Exception.Raise_Exception;

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

Line 89: App_Exception.Raise_Exception;

85: if upper(column_name) = 'CLOSED_IND' or column_name is null Then
86: if new_references.closed_ind NOT IN ('Y', 'N') Then
87: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
88: IGS_GE_MSG_STACK.ADD;
89: App_Exception.Raise_Exception;
90: end if;
91: end if;
92: if upper(column_name) = 'ABBREVIATION' or column_name is null Then
93: if new_references.abbreviation <> UPPER( new_references.abbreviation) then

Line 96: App_Exception.Raise_Exception;

92: if upper(column_name) = 'ABBREVIATION' or column_name is null Then
93: if new_references.abbreviation <> UPPER( new_references.abbreviation) then
94: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: end if;
98: end if;
99: if upper(column_name) = 'DT_ALIAS' or column_name is null Then
100: if new_references.dt_alias <> UPPER( new_references.dt_alias) then

Line 103: App_Exception.Raise_Exception;

99: if upper(column_name) = 'DT_ALIAS' or column_name is null Then
100: if new_references.dt_alias <> UPPER( new_references.dt_alias) then
101: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: end if;
105: end if;
106: if upper(column_name) = 'DT_CAT' or column_name is null Then
107: if new_references.dt_cat <> UPPER( new_references.dt_cat) then

Line 110: App_Exception.Raise_Exception;

106: if upper(column_name) = 'DT_CAT' or column_name is null Then
107: if new_references.dt_cat <> UPPER( new_references.dt_cat) then
108: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
109: IGS_GE_MSG_STACK.ADD;
110: App_Exception.Raise_Exception;
111: end if;
112: end if;
113: if upper(column_name) = 'S_CAL_CAT' or column_name is null Then
114: if new_references.s_cal_cat <> UPPER( new_references.s_cal_cat) then

Line 117: App_Exception.Raise_Exception;

113: if upper(column_name) = 'S_CAL_CAT' or column_name is null Then
114: if new_references.s_cal_cat <> UPPER( new_references.s_cal_cat) then
115: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
116: IGS_GE_MSG_STACK.ADD;
117: App_Exception.Raise_Exception;
118: end if;
119: end if;
120:
121: END Check_Constraints ;

Line 134: App_Exception.Raise_Exception;

130: new_references.dt_cat
131: ) THEN
132: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136:
137: END IF;
138:

Line 149: App_Exception.Raise_Exception;

145: new_references.s_cal_cat
146: )THEN
147: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: END IF;
151:
152: END IF;
153:

Line 263: App_Exception.Raise_Exception;

259: IF (cur_rowid%FOUND) THEN
260: Close cur_rowid;
261: Fnd_Message.Set_Name ('IGS', 'IGS_CA_DA_DAC_FK');
262: IGS_GE_MSG_STACK.ADD;
263: App_Exception.Raise_Exception;
264: Return;
265: END IF;
266: Close cur_rowid;
267:

Line 319: App_Exception.Raise_Exception;

315: IF Get_PK_For_Validation (
316: new_references.dt_alias )THEN
317: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: END IF;
321: Check_Constraints;
322: Check_Parent_Existance;
323: ELSIF (p_action = 'VALIDATE_INSERT') THEN

Line 328: App_Exception.Raise_Exception;

324: IF Get_PK_For_Validation (
325: new_references.dt_alias )THEN
326: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
327: IGS_GE_MSG_STACK.ADD;
328: App_Exception.Raise_Exception;
329: END IF;
330: Check_Constraints;
331:
332: ELSIF (p_action = 'UPDATE') THEN

Line 380: app_exception.raise_exception;

376: end if;
377: else
378: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
379: IGS_GE_MSG_STACK.ADD;
380: app_exception.raise_exception;
381: end if;
382: Before_DML (
383: p_action =>'INSERT',
384: x_rowid =>X_ROWID,

Line 466: app_exception.raise_exception;

462: if (c1%notfound) then
463: close c1;
464: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
465: IGS_GE_MSG_STACK.ADD;
466: app_exception.raise_exception;
467: return;
468: end if;
469: close c1;
470:

Line 488: app_exception.raise_exception;

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

Line 524: app_exception.raise_exception;

520: end if;
521: else
522: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
523: IGS_GE_MSG_STACK.ADD;
524: app_exception.raise_exception;
525: end if;
526:
527: Before_DML (
528: p_action =>'UPDATE',