APPS.IGS_PS_UNT_DSCP_HIST_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: IF Upper(Column_Name)='DISCIPLINE_GROUP_CD' OR Column_Name IS NULL Then
85: IF New_References.Discipline_Group_Cd <> UPPER(New_References.Discipline_Group_Cd) 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)='UNIT_CD' OR Column_Name IS NULL Then

Line 96: App_Exception.Raise_Exception;

92: IF Upper(Column_Name)='UNIT_CD' OR Column_Name IS NULL Then
93: IF New_References.Unit_Cd <> UPPER(New_References.Unit_CD) Then
94: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: END IF;
98: END IF;
99:
100: END Check_Constraints;

Line 113: App_Exception.Raise_Exception;

109: IF NOT IGS_PS_DSCP_PKG.Get_PK_For_Validation (
110: new_references.discipline_group_cd) THEN
111: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception;
114: END IF;
115:
116: END IF;
117:

Line 129: App_Exception.Raise_Exception;

125: new_references.unit_cd,
126: new_references.version_number) THEN
127: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131:
132: END IF;
133:

Line 187: App_Exception.Raise_Exception;

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

Line 215: App_Exception.Raise_Exception;

211: IF (cur_rowid%FOUND) THEN
212: Close cur_rowid;
213: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UDH_UV_FK');
214: IGS_GE_MSG_STACK.ADD;
215: App_Exception.Raise_Exception;
216: Return;
217: END IF;
218: Close cur_rowid;
219:

Line 267: App_Exception.Raise_Exception;

263: New_References.discipline_group_cd,
264: New_References.hist_start_dt) THEN
265: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
266: IGS_GE_MSG_STACK.ADD;
267: App_Exception.Raise_Exception;
268: END IF;
269: Check_Constraints;
270: Check_Parent_Existance;
271: ELSIF (p_action = 'UPDATE') THEN

Line 283: App_Exception.Raise_Exception;

279: New_References.discipline_group_cd,
280: New_References.hist_start_dt) THEN
281: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;
285: Check_Constraints;
286: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
287: Check_Constraints;

Line 341: app_exception.raise_exception;

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

Line 432: app_exception.raise_exception;

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

Line 447: app_exception.raise_exception;

443: null;
444: else
445: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
446: IGS_GE_MSG_STACK.ADD;
447: app_exception.raise_exception;
448: end if;
449: return;
450: end LOCK_ROW;
451:

Line 483: app_exception.raise_exception;

479: end if;
480: else
481: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
482: IGS_GE_MSG_STACK.ADD;
483: app_exception.raise_exception;
484: end if;
485:
486: Before_DML(
487: p_action => 'UPDATE',