APPS.IGS_PS_UNT_DSCP_HIST_PKG dependencies on IGS_GE_MSG_STACK

Line 42: IGS_GE_MSG_STACK.ADD;

38: Fetch cur_old_ref_values INTO old_references;
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;

Line 87: IGS_GE_MSG_STACK.ADD;

83:
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:

Line 95: IGS_GE_MSG_STACK.ADD;

91:
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:

Line 112: IGS_GE_MSG_STACK.ADD;

108: ELSE
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;

Line 128: IGS_GE_MSG_STACK.ADD;

124: IF NOT IGS_PS_UNIT_VER_PKG.Get_PK_For_Validation (
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;

Line 186: IGS_GE_MSG_STACK.ADD;

182: Fetch cur_rowid INTO lv_rowid;
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;

Line 214: IGS_GE_MSG_STACK.ADD;

210: Fetch cur_rowid INTO lv_rowid;
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;

Line 266: IGS_GE_MSG_STACK.ADD;

262: New_References.version_number,
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;

Line 282: IGS_GE_MSG_STACK.ADD;

278: New_References.version_number,
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

Line 340: IGS_GE_MSG_STACK.ADD;

336: X_LAST_UPDATE_LOGIN := -1;
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(

Line 431: IGS_GE_MSG_STACK.ADD;

427: fetch c1 into tlinfo;
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;

Line 446: IGS_GE_MSG_STACK.ADD;

442: ) then
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;

Line 482: IGS_GE_MSG_STACK.ADD;

478: X_LAST_UPDATE_LOGIN := -1;
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(