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_UNT_OFR_PAT_N_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 86: App_Exception.Raise_Exception;

82: IF Upper(Column_Name)='CAL_TYPE' OR Column_Name IS NULL Then
83: IF New_References.Cal_Type <> UPPER(New_References.Cal_Type) Then
84: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END IF;
89:
90: IF Upper(Column_Name)='CRS_NOTE_TYPE' OR Column_Name IS NULL Then

Line 94: App_Exception.Raise_Exception;

90: IF Upper(Column_Name)='CRS_NOTE_TYPE' OR Column_Name IS NULL Then
91: IF New_References.Crs_Note_Type <> UPPER(New_References.Crs_Note_Type) Then
92: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96: END IF;
97:
98:

Line 103: App_Exception.Raise_Exception;

99: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then
100: IF New_References.Unit_Cd <> UPPER(New_References.Unit_CD) 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:
107: END Check_Constraints;

Line 121: App_Exception.Raise_Exception;

117: IF NOT IGS_PS_NOTE_TYPE_PKG.Get_PK_For_Validation (
118: new_references.crs_note_type) THEN
119: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
120: IGS_GE_MSG_STACK.ADD;
121: App_Exception.Raise_Exception;
122: END IF;
123:
124: END IF;
125:

Line 134: App_Exception.Raise_Exception;

130: IF NOT IGS_GE_NOTE_PKG.Get_PK_For_Validation (
131: new_references.reference_number) 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 156: App_Exception.Raise_Exception;

152: new_references.cal_type,
153: new_references.ci_sequence_number) THEN
154: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
155: IGS_GE_MSG_STACK.ADD;
156: App_Exception.Raise_Exception;
157: END IF;
158:
159: END IF;
160:

Line 216: App_Exception.Raise_Exception;

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

Line 242: App_Exception.Raise_Exception;

238: IF (cur_rowid%FOUND) THEN
239: Close cur_rowid;
240: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UOPN_NOTE_FK');
241: IGS_GE_MSG_STACK.ADD;
242: App_Exception.Raise_Exception;
243: Return;
244: END IF;
245: Close cur_rowid;
246:

Line 274: App_Exception.Raise_Exception;

270: IF (cur_rowid%FOUND) THEN
271: Close cur_rowid;
272: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UOPN_UOP_FK');
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: Return;
276: END IF;
277: Close cur_rowid;
278:

Line 323: App_Exception.Raise_Exception;

319: New_References.ci_sequence_number,
320: New_References.reference_number) THEN
321: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
322: IGS_GE_MSG_STACK.ADD;
323: App_Exception.Raise_Exception;
324: END IF;
325: Check_Constraints;
326: Check_Parent_Existance;
327: ELSIF (p_action = 'UPDATE') THEN

Line 340: App_Exception.Raise_Exception;

336: New_References.ci_sequence_number,
337: New_References.reference_number) THEN
338: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
339: IGS_GE_MSG_STACK.ADD;
340: App_Exception.Raise_Exception;
341: END IF;
342: Check_Constraints;
343: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
344: Check_Constraints;

Line 397: app_exception.raise_exception;

393: end if;
394: else
395: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
396: IGS_GE_MSG_STACK.ADD;
397: app_exception.raise_exception;
398: end if;
399:
400: Before_DML(
401: p_action => 'INSERT',

Line 479: app_exception.raise_exception;

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

Line 490: app_exception.raise_exception;

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

Line 525: app_exception.raise_exception;

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