APPS.IGS_EN_UNIT_SET_CAT_PKG dependencies on APP_EXCEPTION

Line 40: App_Exception.Raise_Exception;

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

Line 91: App_Exception.Raise_Exception;

87: IF ((UPPER (column_name) = 'UNIT_SET_CAT') OR (column_name IS NULL)) THEN
88: IF (new_references.unit_set_cat <> UPPER (new_references.unit_set_cat)) THEN
89: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
90: IGS_GE_MSG_STACK.ADD;
91: App_Exception.Raise_Exception;
92: END IF;
93: END IF;
94:
95: IF ((UPPER (column_name) = 'S_UNIT_SET_CAT') OR (column_name IS NULL)) THEN

Line 99: App_Exception.Raise_Exception;

95: IF ((UPPER (column_name) = 'S_UNIT_SET_CAT') OR (column_name IS NULL)) THEN
96: IF (new_references.s_unit_set_cat IS NULL ) THEN
97: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MANDATORY_FLD');
98: IGS_GE_MSG_STACK.ADD;
99: App_Exception.Raise_Exception;
100: END IF;
101: END IF;
102:
103: IF ((UPPER (column_name) = 'CLOSED_IND') OR (column_name IS NULL)) THEN

Line 107: App_Exception.Raise_Exception;

103: IF ((UPPER (column_name) = 'CLOSED_IND') OR (column_name IS NULL)) THEN
104: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) 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:

Line 117: App_Exception.Raise_Exception;

113: IF new_references.rank < 0 OR
114: new_references.rank > 999 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:

Line 202: App_Exception.Raise_Exception;

198: ) THEN
199:
200: Fnd_message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
201: IGS_GE_MSG_STACK.ADD;
202: App_Exception.Raise_Exception;
203:
204: END IF;
205:
206: Check_Constraints;

Line 221: App_Exception.Raise_Exception;

217: new_references.unit_set_cat
218: ) THEN
219: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
220: IGS_GE_MSG_STACK.ADD;
221: App_Exception.Raise_Exception;
222: END IF;
223: Check_Constraints;
224: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
225: Check_Constraints;

Line 287: app_exception.raise_exception;

283: end if;
284: else
285: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
286: IGS_GE_MSG_STACK.ADD;
287: app_exception.raise_exception;
288: end if;
289:
290: Before_DML(
291: p_action => 'INSERT' ,

Line 368: app_exception.raise_exception;

364: fetch c1 into tlinfo;
365: if (c1%notfound) then
366: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
367: IGS_GE_MSG_STACK.ADD;
368: app_exception.raise_exception;
369: close c1;
370: return;
371: end if;
372: close c1;

Line 386: app_exception.raise_exception;

382: null;
383: else
384: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
385: IGS_GE_MSG_STACK.ADD;
386: app_exception.raise_exception;
387: end if;
388: return;
389: end LOCK_ROW;
390:

Line 420: app_exception.raise_exception;

416: end if;
417: else
418: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
419: IGS_GE_MSG_STACK.ADD;
420: app_exception.raise_exception;
421: end if;
422:
423: Before_DML(
424: p_action => 'UPDATE' ,