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

Line 45: App_Exception.Raise_Exception;

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

Line 112: App_Exception.Raise_Exception;

108: new_references.uai_sequence_number,
109: v_message_name) = FALSE THEN
110: Fnd_Message.Set_Name('IGS', v_message_name);
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception;
113: END IF;
114: END IF;
115: IF p_inserting THEN
116: -- Update the action date of the IGS_AS_UNTAS_PATTERN table

Line 171: App_Exception.Raise_Exception;

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

Line 196: App_Exception.Raise_Exception;

192: new_references.ass_pattern_id
193: ))THEN
194: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
195: IGS_GE_MSG_STACK.ADD;
196: App_Exception.Raise_Exception;
197: END IF;
198: END IF;
199:
200: END Check_Parent_Existance;

Line 226: App_Exception.Raise_Exception;

222: column_name is null Then
223: IF new_references.ci_sequence_number < 1 AND new_references.ci_sequence_number > 999999 Then
224: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228: END IF;
229:
230: IF upper(column_name) = 'APPORTIONMENT_PERCENTAGE' OR

Line 235: App_Exception.Raise_Exception;

231: column_name is null Then
232: IF new_references.apportionment_percentage < 0 AND new_references.apportionment_percentage > 100 Then
233: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
234: IGS_GE_MSG_STACK.ADD;
235: App_Exception.Raise_Exception;
236: END IF;
237: END IF;
238: IF upper(column_name) = 'UAI_SEQUENCE_NUMBER' OR
239: column_name is null Then

Line 243: App_Exception.Raise_Exception;

239: column_name is null Then
240: IF new_references.uai_sequence_number < 1 AND new_references.uai_sequence_number > 999999 Then
241: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: END IF;
245: END IF;
246: IF upper(column_name) = 'CAL_TYPE' OR
247: column_name is null Then

Line 251: App_Exception.Raise_Exception;

247: column_name is null Then
248: IF new_references.cal_type <> UPPER(new_references.cal_type) Then
249: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
250: IGS_GE_MSG_STACK.ADD;
251: App_Exception.Raise_Exception;
252: END IF;
253: END IF;
254: IF upper(column_name) = 'UNIT_CD' OR
255: column_name is null Then

Line 259: App_Exception.Raise_Exception;

255: column_name is null Then
256: IF new_references.unit_cd <> UPPER(new_references.unit_cd) Then
257: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
258: IGS_GE_MSG_STACK.ADD;
259: App_Exception.Raise_Exception;
260: END IF;
261: END IF;
262:
263:

Line 333: App_Exception.Raise_Exception;

329: IF (cur_rowid%FOUND) THEN
330: Fnd_Message.Set_Name ('IGS', 'IGS_AS_UAPI_UAI_FK');
331: IGS_GE_MSG_STACK.ADD;
332: Close cur_rowid;
333: App_Exception.Raise_Exception;
334: Return;
335: END IF;
336: Close cur_rowid;
337:

Line 367: App_Exception.Raise_Exception;

363: IF (cur_rowid%FOUND) THEN
364: Fnd_Message.Set_Name ('IGS', 'IGS_AS_UAPI_UAP_FK');
365: IGS_GE_MSG_STACK.ADD;
366: Close cur_rowid;
367: App_Exception.Raise_Exception;
368: Return;
369: END IF;
370: Close cur_rowid;
371:

Line 425: App_Exception.Raise_Exception;

421: new_references.uai_sequence_number
422: ) THEN
423: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
424: IGS_GE_MSG_STACK.ADD;
425: App_Exception.Raise_Exception;
426: END IF;
427: Check_Constraints;
428: Check_Parent_Existance;
429: ELSIF (p_action = 'UPDATE') THEN

Line 449: App_Exception.Raise_Exception;

445: new_references.uai_sequence_number
446: ) THEN
447: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
448: IGS_GE_MSG_STACK.ADD;
449: App_Exception.Raise_Exception;
450: END IF;
451: Check_Constraints;
452: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
453: Check_Constraints;

Line 518: app_exception.raise_exception;

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

Line 614: app_exception.raise_exception;

610: if (c1%notfound) then
611: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
612: IGS_GE_MSG_STACK.ADD;
613: close c1;
614: app_exception.raise_exception;
615: return;
616: end if;
617: close c1;
618:

Line 627: app_exception.raise_exception;

623: null;
624: else
625: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
626: IGS_GE_MSG_STACK.ADD;
627: app_exception.raise_exception;
628: end if;
629: return;
630: end LOCK_ROW;
631:

Line 668: app_exception.raise_exception;

664: end if;
665: else
666: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
667: IGS_GE_MSG_STACK.ADD;
668: app_exception.raise_exception;
669: end if;
670: Before_DML(
671: p_action=>'UPDATE',
672: x_rowid=>X_ROWID,