DBA Data[Home] [Help]

APPS.IGS_PS_DSCP_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 103: IGS_GE_MSG_STACK.ADD;

99: IF IGS_PS_VAL_DI.crsp_val_di_govt_dg (
100: new_references.govt_discipline_group_cd,
101: v_message_name) = FALSE THEN
102: FND_MESSAGE.SET_NAME('IGS',v_message_name);
103: IGS_GE_MSG_STACK.ADD;
104: APP_EXCEPTION.RAISE_EXCEPTION;
105: END IF;
106: END IF;
107: IF p_updating THEN

Line 194: IGS_GE_MSG_STACK.ADD;

190: IF upper(column_name) = 'FUNDING_INDEX_2' OR
191: column_name is null Then
192: IF new_references.funding_index_2 < 0 OR new_references.funding_index_2 > 1.70 Then
193: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
194: IGS_GE_MSG_STACK.ADD;
195: App_Exception.Raise_Exception;
196: END IF;
197: END IF;
198:

Line 203: IGS_GE_MSG_STACK.ADD;

199: IF upper(column_name) = 'FUNDING_INDEX_3' OR
200: column_name is null Then
201: IF new_references.funding_index_3 < 0 OR new_references.funding_index_3 > 1.70 Then
202: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
203: IGS_GE_MSG_STACK.ADD;
204: App_Exception.Raise_Exception;
205: END IF;
206: END IF;
207:

Line 212: IGS_GE_MSG_STACK.ADD;

208: IF upper(column_name) = 'CLOSED_IND' OR
209: column_name is null Then
210: IF new_references.closed_ind NOT IN ('Y','N') THEN
211: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
212: IGS_GE_MSG_STACK.ADD;
213: App_Exception.Raise_Exception;
214: END IF;
215: END IF;
216:

Line 221: IGS_GE_MSG_STACK.ADD;

217: IF upper(column_name) = 'FUNDING_INDEX_1' OR
218: column_name is null Then
219: IF new_references.funding_index_1 < 0 OR new_references.funding_index_1 > 1.70 Then
220: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
221: IGS_GE_MSG_STACK.ADD;
222: App_Exception.Raise_Exception;
223: END IF;
224: END IF;
225:

Line 230: IGS_GE_MSG_STACK.ADD;

226: IF upper(column_name) = 'DISCIPLINE_GROUP_CD' OR
227: column_name is null Then
228: IF new_references.discipline_group_cd <> UPPER(new_references.discipline_group_cd) Then
229: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
230: IGS_GE_MSG_STACK.ADD;
231: App_Exception.Raise_Exception;
232: END IF;
233: END IF;
234:

Line 239: IGS_GE_MSG_STACK.ADD;

235: IF upper(column_name) = 'GOVT_DISCIPLINE_GROUP_CD' OR
236: column_name is null Then
237: IF new_references.govt_discipline_group_cd <> UPPER(new_references.govt_discipline_group_cd) Then
238: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
239: IGS_GE_MSG_STACK.ADD;
240: App_Exception.Raise_Exception;
241: END IF;
242: END IF;
243: END check_constraints;

Line 257: IGS_GE_MSG_STACK.ADD;

253: IF NOT IGS_PS_GOVT_DSCP_PKG.Get_PK_For_Validation (
254: new_references.govt_discipline_group_cd
255: ) THEN
256: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
257: IGS_GE_MSG_STACK.ADD;
258: App_Exception.Raise_Exception;
259: END IF;
260: END IF;
261:

Line 324: IGS_GE_MSG_STACK.ADD;

320: Fetch cur_rowid INTO lv_rowid;
321: IF (cur_rowid%FOUND) THEN
322: Close cur_rowid;
323: Fnd_Message.Set_Name ('IGS', 'IGS_PS_DI_GD_FK');
324: IGS_GE_MSG_STACK.ADD;
325: App_Exception.Raise_Exception;
326: Return;
327: END IF;
328: Close cur_rowid;

Line 377: IGS_GE_MSG_STACK.ADD;

373: IF Get_PK_For_Validation (
374: new_references.discipline_group_cd
375: ) THEN
376: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
377: IGS_GE_MSG_STACK.ADD;
378: App_Exception.Raise_Exception;
379: END IF;
380: Check_Constraints;
381: Check_Parent_Existance;

Line 396: IGS_GE_MSG_STACK.ADD;

392: IF Get_PK_For_Validation (
393: new_references.discipline_group_cd
394: ) THEN
395: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
396: IGS_GE_MSG_STACK.ADD;
397: App_Exception.Raise_Exception;
398: END IF;
399: Check_Constraints;
400: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 455: IGS_GE_MSG_STACK.ADD;

451: X_LAST_UPDATE_LOGIN := -1;
452: end if;
453: else
454: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
455: IGS_GE_MSG_STACK.ADD;
456: app_exception.raise_exception;
457: end if;
458:
459: Before_DML( p_action => 'INSERT',

Line 548: IGS_GE_MSG_STACK.ADD;

544: fetch c1 into tlinfo;
545: if (c1%notfound) then
546: close c1;
547: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
548: IGS_GE_MSG_STACK.ADD;
549: app_exception.raise_exception;
550: return;
551: end if;
552: close c1;

Line 571: IGS_GE_MSG_STACK.ADD;

567: ) then
568: null;
569: else
570: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
571: IGS_GE_MSG_STACK.ADD;
572: app_exception.raise_exception;
573: end if;
574: return;
575: end LOCK_ROW;

Line 607: IGS_GE_MSG_STACK.ADD;

603: X_LAST_UPDATE_LOGIN := -1;
604: end if;
605: else
606: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
607: IGS_GE_MSG_STACK.ADD;
608: app_exception.raise_exception;
609: end if;
610:
611: Before_DML( p_action => 'UPDATE',