APPS.IGS_EN_MRG_ID_ACT_CH_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: Close cur_old_ref_values;
38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: IGS_GE_MSG_STACK.ADD;
40: App_Exception.Raise_Exception;
41: Return;
42: END IF;
43: Close cur_old_ref_values;
44:

Line 82: App_Exception.Raise_Exception;

78: IF new_references.table_alias <>
79: upper(new_references.table_alias) THEN
80: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
81: IGS_GE_MSG_STACK.ADD;
82: App_Exception.Raise_Exception;
83: END IF;
84: END IF;
85:
86: IF upper(column_name) = 'PERFORM_ACTION_IND' OR

Line 91: App_Exception.Raise_Exception;

87: Column_name is null THEN
88: IF new_references.perform_action_ind NOT IN ('Y','N') 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: END check_constraints;

Line 112: App_Exception.Raise_Exception;

108: new_references.action_id
109: ) THEN
110: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
111: IGS_GE_MSG_STACK.ADD;
112: App_Exception.Raise_Exception;
113: END IF;
114: END IF;
115:
116: IF (((old_references.smir_id = new_references.smir_id)) OR

Line 125: App_Exception.Raise_Exception;

121: new_references.smir_id
122: ) THEN
123: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;
128:
129: END Check_Parent_Existance;

Line 182: App_Exception.Raise_Exception;

178: IF (cur_rowid%FOUND) THEN
179: Close cur_rowid;
180: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SMIAC_SMIA_FK');
181: IGS_GE_MSG_STACK.ADD;
182: App_Exception.Raise_Exception;
183: Return;
184: END IF;
185: Close cur_rowid;
186:

Line 208: App_Exception.Raise_Exception;

204: IF (cur_rowid%FOUND) THEN
205: Close cur_rowid;
206: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SMIAC_SMIR_FK');
207: IGS_GE_MSG_STACK.ADD;
208: App_Exception.Raise_Exception;
209: Return;
210: END IF;
211: Close cur_rowid;
212:

Line 254: App_Exception.Raise_Exception;

250: new_references.action_id
251: ) THEN
252: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: END IF;
256: Check_constraints;
257: Check_Parent_Existance;
258: ELSIF (p_action = 'UPDATE') THEN

Line 274: App_Exception.Raise_Exception;

270: new_references.action_id
271: ) THEN
272: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
273: IGS_GE_MSG_STACK.ADD;
274: App_Exception.Raise_Exception;
275: END IF;
276: Check_constraints;
277: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
278: Check_constraints;

Line 338: app_exception.raise_exception;

334: end if;
335: else
336: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
337: IGS_GE_MSG_STACK.ADD;
338: app_exception.raise_exception;
339: end if;
340:
341: Before_DML(
342: p_action => 'INSERT' ,

Line 414: app_exception.raise_exception;

410: if (c1%notfound) then
411: close c1;
412: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
413: IGS_GE_MSG_STACK.ADD;
414: app_exception.raise_exception;
415: return;
416: end if;
417: close c1;
418:

Line 425: app_exception.raise_exception;

421: null;
422: else
423: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
424: IGS_GE_MSG_STACK.ADD;
425: app_exception.raise_exception;
426: end if;
427: return;
428: end LOCK_ROW;
429:

Line 458: app_exception.raise_exception;

454: end if;
455: else
456: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
457: IGS_GE_MSG_STACK.ADD;
458: app_exception.raise_exception;
459: end if;
460:
461:
462: Before_DML(