APPS.IGS_EN_MERGE_ID_ROWS_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: Close cur_old_ref_values;
43: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
44: IGS_GE_MSG_STACK.ADD;
45: App_Exception.Raise_Exception;
46: Return;
47: END IF;
48: Close cur_old_ref_values;
49:

Line 91: App_Exception.Raise_Exception;

87: IF new_references.table_alias <>
88: upper(new_references.table_alias) 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 109: App_Exception.Raise_Exception;

105: new_references.current_person_id
106: ) THEN
107: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception;
110: END IF;
111:
112: END IF;
113:

Line 123: App_Exception.Raise_Exception;

119: new_references.obsolete_person_id
120: ) THEN
121: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
122: IGS_GE_MSG_STACK.ADD;
123: App_Exception.Raise_Exception;
124: END IF;
125:
126: END IF;
127:

Line 185: App_Exception.Raise_Exception;

181: IF (cur_rowid%FOUND) THEN
182: Close cur_rowid;
183: Fnd_Message.Set_Name ('IGS', 'IGS_EN_SMIR_PE_FK');
184: IGS_GE_MSG_STACK.ADD;
185: App_Exception.Raise_Exception;
186: Return;
187: END IF;
188: Close cur_rowid;
189:

Line 241: App_Exception.Raise_Exception;

237: new_references.smir_id
238: ) then
239: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
240: IGS_GE_MSG_STACK.ADD;
241: App_Exception.Raise_Exception;
242: end if;
243: Check_constraints;
244: Check_Parent_Existance;
245: ELSIF (p_action = 'UPDATE') THEN

Line 260: App_Exception.Raise_Exception;

256: new_references.smir_id
257: ) then
258: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
259: IGS_GE_MSG_STACK.ADD;
260: App_Exception.Raise_Exception;
261: end if;
262: Check_constraints;
263: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
264: Check_constraints;

Line 328: app_exception.raise_exception;

324: end if;
325: else
326: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
327: IGS_GE_MSG_STACK.ADD;
328: app_exception.raise_exception;
329: end if;
330: Before_DML (
331: p_action => 'INSERT',
332: x_rowid => X_ROWID,

Line 431: app_exception.raise_exception;

427: if (c1%notfound) then
428: close c1;
429: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
430: IGS_GE_MSG_STACK.ADD;
431: app_exception.raise_exception;
432: return;
433: end if;
434: close c1;
435:

Line 462: app_exception.raise_exception;

458: null;
459: else
460: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
461: IGS_GE_MSG_STACK.ADD;
462: app_exception.raise_exception;
463: end if;
464: return;
465: end LOCK_ROW;
466:

Line 501: app_exception.raise_exception;

497: end if;
498: else
499: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
500: IGS_GE_MSG_STACK.ADD;
501: app_exception.raise_exception;
502: end if;
503: Before_DML (
504: p_action => 'UPDATE',
505: x_rowid => X_ROWID,