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

Line 47: App_Exception.Raise_Exception;

43: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
44: Close cur_old_ref_values;
45: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
46: IGS_GE_MSG_STACK.ADD;
47: App_Exception.Raise_Exception;
48: Return;
49: END IF;
50: Close cur_old_ref_values;
51:

Line 107: App_Exception.Raise_Exception;

103: column_name is null Then
104: IF new_references.percentage < 000.01 OR new_references.percentage > 100.00 Then
105: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109: END IF;
110:
111: IF upper(column_name) = 'CI_SEQUENCE_NUMBER' OR

Line 116: App_Exception.Raise_Exception;

112: column_name is null Then
113: IF new_references.ci_sequence_number < 1 OR new_references.ci_sequence_number > 999999 Then
114: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
115: IGS_GE_MSG_STACK.ADD;
116: App_Exception.Raise_Exception;
117: END IF;
118: END IF;
119:
120: IF upper(column_name) = 'CAL_TYPE' OR

Line 125: App_Exception.Raise_Exception;

121: column_name is null Then
122: IF new_references.cal_type <> UPPER(new_references.cal_type) Then
123: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;
128:
129: IF upper(column_name) = 'LOCATION_CD' OR

Line 134: App_Exception.Raise_Exception;

130: column_name is null Then
131: IF new_references.location_cd <> UPPER(new_references.location_cd) 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:
138: IF upper(column_name) = 'UNIT_CLASS' OR

Line 143: App_Exception.Raise_Exception;

139: column_name is null Then
140: IF new_references.unit_class <> UPPER(new_references.unit_class) Then
141: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
142: IGS_GE_MSG_STACK.ADD;
143: App_Exception.Raise_Exception;
144: END IF;
145: END IF;
146:
147: IF upper(column_name) = 'UNIT_CD' OR

Line 152: App_Exception.Raise_Exception;

148: column_name is null Then
149: IF new_references.unit_cd <> UPPER(new_references.unit_cd) Then
150: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
151: IGS_GE_MSG_STACK.ADD;
152: App_Exception.Raise_Exception;
153: END IF;
154: END IF;
155:
156: END check_constraints;

Line 173: App_Exception.Raise_Exception;

169: new_references.ou_start_dt
170: ) THEN
171: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: END IF;
175: END IF;
176:
177: IF (((old_references.unit_cd = new_references.unit_cd) AND

Line 201: App_Exception.Raise_Exception;

197: new_references.unit_class
198: ) THEN
199: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;
203: END IF;
204:
205: END Check_Parent_Existance;

Line 269: App_Exception.Raise_Exception;

265: IF (cur_rowid%FOUND) THEN
266: Close cur_rowid;
267: Fnd_Message.Set_Name ('IGS', 'IGS_PS_TROH_OU_FK');
268: IGS_GE_MSG_STACK.ADD;
269: App_Exception.Raise_Exception;
270: Return;
271: END IF;
272: Close cur_rowid;
273:

Line 305: App_Exception.Raise_Exception;

301: IF (cur_rowid%FOUND) THEN
302: Close cur_rowid;
303: Fnd_Message.Set_Name ('IGS', 'IGS_PS_TROH_UOO_FK');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: Return;
307: END IF;
308: Close cur_rowid;
309:

Line 375: App_Exception.Raise_Exception;

371: new_references.hist_start_dt
372: ) THEN
373: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
374: IGS_GE_MSG_STACK.ADD;
375: App_Exception.Raise_Exception;
376: END IF;
377: Check_Constraints;
378: Check_Parent_Existance;
379: ELSIF (p_action = 'UPDATE') THEN

Line 399: App_Exception.Raise_Exception;

395: new_references.hist_start_dt
396: ) THEN
397: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
398: IGS_GE_MSG_STACK.ADD;
399: App_Exception.Raise_Exception;
400: END IF;
401: Check_Constraints;
402: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
403: Check_Constraints;

Line 466: app_exception.raise_exception;

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

Line 577: app_exception.raise_exception;

573: if (c1%notfound) then
574: close c1;
575: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
576: IGS_GE_MSG_STACK.ADD;
577: app_exception.raise_exception;
578: return;
579: end if;
580: close c1;
581:

Line 590: app_exception.raise_exception;

586: null;
587: else
588: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
589: IGS_GE_MSG_STACK.ADD;
590: app_exception.raise_exception;
591: end if;
592: return;
593: end LOCK_ROW;
594:

Line 631: app_exception.raise_exception;

627: end if;
628: else
629: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
630: IGS_GE_MSG_STACK.ADD;
631: app_exception.raise_exception;
632: end if;
633: Before_DML(
634: p_action => 'UPDATE',
635: x_rowid => X_ROWID,