APPS.IGR_I_A_ITYPE_PKG dependencies on APP_EXCEPTION

Line 37: App_Exception.Raise_Exception;

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

Line 86: App_Exception.Raise_Exception;

82: -- Validate that the person is not deceased
83: IF v_deceased_ind = 'Y' THEN
84: Fnd_Message.Set_Name('IGS', 'IGS_IN_DEC_NO_INQ');
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88:
89: -- Insert IGS_IN_APPLML_PKGITM records for the information_type.
90: IF p_inserting THEN

Line 101: App_Exception.Raise_Exception;

97: p_enquiry_information_type,
98: v_message_name) = FALSE THEN
99: Fnd_Message.Set_Name('IGS', v_message_name);
100: IGS_GE_MSG_STACK.ADD;
101: App_Exception.Raise_Exception;
102: END IF;
103: END IF;
104:
105: END BeforeRowInsertUpdateDelete1;

Line 124: App_Exception.Raise_Exception;

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

Line 139: App_Exception.Raise_Exception;

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

Line 161: App_Exception.Raise_Exception;

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

Line 218: App_Exception.Raise_Exception;

214: IF (cur_rowid%FOUND) THEN
215: Fnd_Message.Set_Name ('IGS', 'IGS_IN_EAPIT_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_EAPIT_EIT_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 288: App_Exception.Raise_Exception;

284: new_references.INFO_TYPE_ID
285: ) THEN
286: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
287: IGS_GE_MSG_STACK.ADD;
288: App_Exception.Raise_Exception;
289: END IF;
290: Check_Constraints;
291: Check_Parent_Existance;
292: ELSIF (p_action = 'UPDATE') THEN

Line 308: App_Exception.Raise_Exception;

304: new_references.INFO_TYPE_ID
305: ) THEN
306: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
307: IGS_GE_MSG_STACK.ADD;
308: App_Exception.Raise_Exception;
309: END IF;
310: Check_Constraints;
311: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
312: Check_Constraints;

Line 351: app_exception.raise_exception;

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

Line 415: app_exception.raise_exception;

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