APPS.IGS_AD_CONV_GS_TYPES_PKG dependencies on APP_EXCEPTION

Line 46: App_Exception.Raise_Exception;

42: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
43: Close cur_old_ref_values;
44: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
45: IGS_GE_MSG_STACK.ADD;
46: App_Exception.Raise_Exception;
47: Return;
48: END IF;
49: Close cur_old_ref_values;
50:

Line 87: APP_EXCEPTION.RAISE_EXCEPTION;

83: IF p_inserting OR p_updating THEN
84: IF (new_references.from_code_id = new_references.to_code_id) THEN
85: FND_MESSAGE.SET_NAME('IGS','IGS_AD_FROMTO_GRADE_SAME');
86: IGS_GE_MSG_STACK.ADD;
87: APP_EXCEPTION.RAISE_EXCEPTION;
88: END IF;
89: END IF;
90: END;
91:

Line 110: app_exception.raise_exception;

106: ,new_references.to_code_id
107: ) THEN
108: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
109: IGS_GE_MSG_STACK.ADD;
110: app_exception.raise_exception;
111: END IF;
112: END Check_Uniqueness ;
113:
114: PROCEDURE Check_Parent_Existance AS

Line 136: App_Exception.Raise_Exception;

132: 'N'
133: ) THEN
134: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception;
137: END IF;
138:
139: IF (((old_references.from_code_id = new_references.from_code_id)) OR
140: ((new_references.from_code_id IS NULL))) THEN

Line 149: App_Exception.Raise_Exception;

145: 'N'
146: ) THEN
147: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
148: IGS_GE_MSG_STACK.ADD;
149: App_Exception.Raise_Exception;
150: END IF;
151:
152: END Check_Parent_Existance;
153:

Line 268: App_Exception.Raise_Exception;

264: IF (cur_rowid1%FOUND) THEN
265: Close cur_rowid1;
266: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACGT_ACDC_FK2');
267: IGS_GE_MSG_STACK.ADD;
268: App_Exception.Raise_Exception;
269: Return;
270: END IF;
271: Close cur_rowid1;
272:

Line 279: App_Exception.Raise_Exception;

275: IF (cur_rowid2%FOUND) THEN
276: Close cur_rowid2;
277: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACGT_ACDC_FK1');
278: IGS_GE_MSG_STACK.ADD;
279: App_Exception.Raise_Exception;
280: Return;
281: END IF;
282: Close cur_rowid2;
283:

Line 330: App_Exception.Raise_Exception;

326: new_references.conv_gs_types_id
327: ) THEN
328: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
329: IGS_GE_MSG_STACK.ADD;
330: App_Exception.Raise_Exception;
331: END IF;
332: Check_Uniqueness;
333: Check_Parent_Existance;
334: ELSIF (p_action = 'UPDATE') THEN

Line 349: App_Exception.Raise_Exception;

345: new_references.conv_gs_types_id
346: ) THEN
347: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
348: IGS_GE_MSG_STACK.ADD;
349: App_Exception.Raise_Exception;
350: END IF;
351: Check_Uniqueness;
352: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
353: Check_Uniqueness;

Line 401: app_exception.raise_exception;

397: end if;
398: else
399: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
400: IGS_GE_MSG_STACK.ADD;
401: app_exception.raise_exception;
402: end if;
403:
404: X_CONV_GS_TYPES_ID := -1;
405: Before_DML(

Line 475: app_exception.raise_exception;

471: if (c1%notfound) then
472: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
473: IGS_GE_MSG_STACK.ADD;
474: close c1;
475: app_exception.raise_exception;
476: return;
477: end if;
478: close c1;
479: if (( tlinfo.FROM_CODE_ID = X_FROM_CODE_ID)

Line 485: app_exception.raise_exception;

481: null;
482: else
483: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
484: IGS_GE_MSG_STACK.ADD;
485: app_exception.raise_exception;
486: end if;
487: return;
488: end LOCK_ROW;
489:

Line 527: app_exception.raise_exception;

523: end if;
524: else
525: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
526: IGS_GE_MSG_STACK.ADD;
527: app_exception.raise_exception;
528: end if;
529: Before_DML(
530: p_action=>'UPDATE',
531: x_rowid=>X_ROWID,