APPS.IGR_I_A_CHARTYP_PKG dependencies on APP_EXCEPTION

Line 39: App_Exception.Raise_Exception;

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

Line 88: App_Exception.Raise_Exception;

84: -- No insert, update, delete if a person is deceased
85: IF v_deceased_ind = 'Y' THEN
86: Fnd_Message.Set_Name('IGS', 'IGS_IN_DEC_NO_INQ');
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception;
89: END IF;
90:
91: -- Validate that inserts/updates are allowed
92: IF p_inserting OR p_updating THEN

Line 99: App_Exception.Raise_Exception;

95: IF IGR_VAL_ECT.admp_val_ect_closed(new_references.ENQUIRY_CHARACTERISTIC_TYPE,
96: v_message_name) = FALSE THEN
97: Fnd_Message.Set_Name('IGS', v_message_name);
98: IGS_GE_MSG_STACK.ADD;
99: App_Exception.Raise_Exception;
100: END IF;
101: END IF;
102:
103:

Line 123: App_Exception.Raise_Exception;

119: ))THEN
120: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENQ_APPL'));
122: IGS_GE_MSG_STACK.ADD;
123: App_Exception.Raise_Exception;
124: END IF;
125: END IF;
126:
127: IF (((old_references.ENQUIRY_CHARACTERISTIC_TYPE= new_references.ENQUIRY_CHARACTERISTIC_TYPE)) OR

Line 138: App_Exception.Raise_Exception;

134: ))THEN
135: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
136: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENQ_CHR_TYPE'));
137: IGS_GE_MSG_STACK.ADD;
138: App_Exception.Raise_Exception;
139: END IF ;
140: END IF;
141:
142: END Check_Parent_Existance;

Line 160: App_Exception.Raise_Exception;

156: IF new_references.enquiry_characteristic_type <> UPPER(new_references.enquiry_characteristic_type) Then
157: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
158: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENQ_CHR_TYPE'));
159: IGS_GE_MSG_STACK.ADD;
160: App_Exception.Raise_Exception;
161: END IF;
162: END IF;
163:
164: END Check_Constraints;

Line 218: App_Exception.Raise_Exception;

214: IF (cur_rowid%FOUND) THEN
215: Fnd_Message.Set_Name ('IGS', 'IGS_IN_EAPECT_EAP_FK');
216: IGS_GE_MSG_STACK.ADD;
217: Close cur_rowid;
218: App_Exception.Raise_Exception;
219: Return;
220: END IF;
221: Close cur_rowid;
222:

Line 244: App_Exception.Raise_Exception;

240: IF (cur_rowid%FOUND) THEN
241: Fnd_Message.Set_Name ('IGS', 'IGS_IN_EAPECT_ECT_FK');
242: IGS_GE_MSG_STACK.ADD;
243: Close cur_rowid;
244: App_Exception.Raise_Exception;
245: Return;
246: END IF;
247: Close cur_rowid;
248:

Line 289: App_Exception.Raise_Exception;

285:
286: ) THEN
287: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
288: IGS_GE_MSG_STACK.ADD;
289: App_Exception.Raise_Exception;
290: END IF;
291:
292: Check_Constraints;
293: Check_Parent_Existance;

Line 311: App_Exception.Raise_Exception;

307:
308: ) THEN
309: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
310: IGS_GE_MSG_STACK.ADD;
311: App_Exception.Raise_Exception;
312: END IF;
313: Check_Constraints;
314: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
315: Check_Constraints;

Line 354: app_exception.raise_exception;

350: end if;
351: else
352: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
353: IGS_GE_MSG_STACK.ADD;
354: app_exception.raise_exception;
355: end if;
356: Before_DML(
357: p_action=>'INSERT',
358: x_rowid=>X_ROWID,

Line 417: app_exception.raise_exception;

413: if (c1%notfound) then
414: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
415: IGS_GE_MSG_STACK.ADD;
416: close c1;
417: app_exception.raise_exception;
418: return;
419: end if;
420: close c1;
421: