DBA Data[Home] [Help]

APPS.IGS_PS_DSCP_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 104: APP_EXCEPTION.RAISE_EXCEPTION;

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
108: IF old_references.description <> new_references.description OR

Line 195: App_Exception.Raise_Exception;

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:
199: IF upper(column_name) = 'FUNDING_INDEX_3' OR

Line 204: App_Exception.Raise_Exception;

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:
208: IF upper(column_name) = 'CLOSED_IND' OR

Line 213: App_Exception.Raise_Exception;

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:
217: IF upper(column_name) = 'FUNDING_INDEX_1' OR

Line 222: App_Exception.Raise_Exception;

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:
226: IF upper(column_name) = 'DISCIPLINE_GROUP_CD' OR

Line 231: App_Exception.Raise_Exception;

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:
235: IF upper(column_name) = 'GOVT_DISCIPLINE_GROUP_CD' OR

Line 240: App_Exception.Raise_Exception;

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;
244:

Line 258: App_Exception.Raise_Exception;

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:
262: END Check_Parent_Existance;

Line 325: App_Exception.Raise_Exception;

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;
329:

Line 378: App_Exception.Raise_Exception;

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;
382: ELSIF (p_action = 'UPDATE') THEN

Line 397: App_Exception.Raise_Exception;

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
401: Check_Constraints;

Line 456: app_exception.raise_exception;

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',
460: x_rowid => X_ROWID,

Line 549: app_exception.raise_exception;

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;
553:

Line 572: app_exception.raise_exception;

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;
576:

Line 608: app_exception.raise_exception;

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',
612: x_rowid => X_ROWID,