APPS.IGS_EN_MERGE_ID_LOG_PKG dependencies on APP_EXCEPTION

Line 43: App_Exception.Raise_Exception;

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

Line 88: App_Exception.Raise_Exception;

84: Column_name is null THEN
85: IF new_references.perform_action_ind NOT IN ('Y','N') THEN
86: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception;
89: END IF;
90: END IF;
91:
92: IF upper(column_name) = 'TABLE_ALIAS' OR

Line 98: App_Exception.Raise_Exception;

94: IF new_references.table_alias <>
95: upper(new_references.table_alias) THEN
96: Fnd_Message.Set_Name ('IGS','IGS_GE_INVALID_VALUE');
97: IGS_GE_MSG_STACK.ADD;
98: App_Exception.Raise_Exception;
99: END IF;
100: END IF;
101:
102:

Line 145: App_Exception.Raise_Exception;

141: new_references.action_id
142: )THEN
143: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
144: IGS_GE_MSG_STACK.ADD;
145: App_Exception.Raise_Exception;
146: END IF;
147:
148: END IF;
149:

Line 173: App_Exception.Raise_Exception;

169: IF (cur_rowid%FOUND) THEN
170: Close cur_rowid;
171: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SMIL_SMIA_FK');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: Return;
175: END IF;
176: Close cur_rowid;
177:

Line 226: App_Exception.Raise_Exception;

222: new_references.SMIL_ID
223: ) THEN
224: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
225: IGS_GE_MSG_STACK.ADD;
226: App_Exception.Raise_Exception;
227: END IF;
228: Check_constraints;
229: Check_Parent_Existance;
230: ELSIF (p_action = 'UPDATE') THEN

Line 244: App_Exception.Raise_Exception;

240: new_references.SMIL_ID
241: ) THEN
242: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
243: IGS_GE_MSG_STACK.ADD;
244: App_Exception.Raise_Exception;
245: END IF;
246: Check_constraints;
247: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
248: Check_constraints;

Line 310: app_exception.raise_exception;

306: end if;
307: else
308: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
309: IGS_GE_MSG_STACK.ADD;
310: app_exception.raise_exception;
311: end if;
312:
313: SELECT IGS_EN_MERGE_ID_LOG_SMIL_ID_S.Nextval
314: INTO X_SMIL_ID

Line 409: app_exception.raise_exception;

405: if (c1%notfound) then
406: close c1;
407: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
408: IGS_GE_MSG_STACK.ADD;
409: app_exception.raise_exception;
410: return;
411: end if;
412: close c1;
413:

Line 430: app_exception.raise_exception;

426: null;
427: else
428: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
429: IGS_GE_MSG_STACK.ADD;
430: app_exception.raise_exception;
431: end if;
432: return;
433: end LOCK_ROW;
434:

Line 467: app_exception.raise_exception;

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