DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_LEVEL_PKG dependencies on IGS_GE_MSG_STACK

Line 40: IGS_GE_MSG_STACK.ADD;

36: Fetch cur_old_ref_values INTO old_references;
37: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
38: Close cur_old_ref_values;
39: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
40: IGS_GE_MSG_STACK.ADD;
41: App_Exception.Raise_Exception;
42: Return;
43: END IF;
44: Close cur_old_ref_values;

Line 82: IGS_GE_MSG_STACK.ADD;

78:
79: IF Upper(Column_Name)='WAM_WEIGHTING' OR Column_Name IS NULL Then
80: IF New_References.wam_weighting < 0 AND New_References.wam_weighting > 9.999 Then
81: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
82: IGS_GE_MSG_STACK.ADD;
83: App_Exception.Raise_Exception;
84: END IF;
85: END IF;
86:

Line 90: IGS_GE_MSG_STACK.ADD;

86:
87: IF Upper(Column_Name)='CLOSED_IND' OR Column_Name IS NULL Then
88: IF new_references.closed_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:

Line 98: IGS_GE_MSG_STACK.ADD;

94:
95: IF Upper(Column_Name)='UNIT_LEVEL' OR Column_Name IS NULL Then
96: IF New_References.Unit_Level <> UPPER(New_References.Unit_Level) Then
97: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
98: IGS_GE_MSG_STACK.ADD;
99: App_Exception.Raise_Exception;
100: END IF;
101: END IF;
102:

Line 166: IGS_GE_MSG_STACK.ADD;

162: IF (p_action = 'INSERT') THEN
163: -- Call all the procedures related to Before Insert.
164: IF Get_PK_For_Validation (New_References.unit_level) THEN
165: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
166: IGS_GE_MSG_STACK.ADD;
167: App_Exception.Raise_Exception;
168: END IF;
169: Check_Constraints;
170: ELSIF (p_action = 'UPDATE') THEN

Line 176: IGS_GE_MSG_STACK.ADD;

172: Check_Constraints;
173: ELSIF (p_action = 'VALIDATE_INSERT') THEN
174: IF Get_PK_For_Validation (New_References.unit_level) THEN
175: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
176: IGS_GE_MSG_STACK.ADD;
177: App_Exception.Raise_Exception;
178: END IF;
179: Check_Constraints;
180: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 228: IGS_GE_MSG_STACK.ADD;

224: X_LAST_UPDATE_LOGIN := -1;
225: end if;
226: else
227: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
228: IGS_GE_MSG_STACK.ADD;
229: app_exception.raise_exception;
230: end if;
231:
232: Before_DML(

Line 309: IGS_GE_MSG_STACK.ADD;

305: fetch c1 into tlinfo;
306: if (c1%notfound) then
307: close c1;
308: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
309: IGS_GE_MSG_STACK.ADD;
310: app_exception.raise_exception;
311: return;
312: end if;
313: close c1;

Line 325: IGS_GE_MSG_STACK.ADD;

321: ) then
322: null;
323: else
324: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
325: IGS_GE_MSG_STACK.ADD;
326: app_exception.raise_exception;
327: end if;
328: return;
329: end LOCK_ROW;

Line 359: IGS_GE_MSG_STACK.ADD;

355: X_LAST_UPDATE_LOGIN := -1;
356: end if;
357: else
358: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
359: IGS_GE_MSG_STACK.ADD;
360: app_exception.raise_exception;
361: end if;
362:
363: Before_DML(