APPS.IGR_I_A_PKGITM_PKG dependencies on APP_EXCEPTION

Line 40: App_Exception.Raise_Exception;

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

Line 91: App_Exception.Raise_Exception;

87: -- Validate that the person is not deceased
88: IF v_deceased_ind = 'Y' THEN
89: Fnd_Message.Set_Name('IGS', 'IGS_IN_DEC_NO_INQ');
90: IGS_GE_MSG_STACK.ADD;
91: App_Exception.Raise_Exception;
92: END IF;
93: -- Validate that the item mailed date is not prior to the enquiry date.
94: IF p_inserting OR
95: (p_updating AND

Line 103: App_Exception.Raise_Exception;

99: new_references.mailed_dt,
100: v_message_name) = FALSE THEN
101: Fnd_Message.Set_Name('IGS', v_message_name);
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104: END IF;
105: END IF;
106:
107:

Line 126: App_Exception.Raise_Exception;

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

Line 140: App_Exception.Raise_Exception;

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

Line 164: App_Exception.Raise_Exception;

160: IF new_references.PACKAGE_ITEM_ID <> UPPER(new_references.PACKAGE_ITEM_ID) Then
161: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_ENQ_PACKAGE_ITEM'));
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: END IF;
166: END IF;
167: IF upper(column_name) = 'DONOT_MAIL_IND' OR
168: column_name is null Then

Line 174: App_Exception.Raise_Exception;

170: IF new_references.donot_mail_ind NOT IN ('Y','N') THEN
171: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE_WITH_CTXT');
172: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_MAIL_INF'));
173: IGS_GE_MSG_STACK.ADD;
174: App_Exception.Raise_Exception;
175: END IF;
176: END IF;
177: END IF;
178:

Line 232: App_Exception.Raise_Exception;

228: IF (cur_rowid%FOUND) THEN
229: Fnd_Message.Set_Name ('IGS', 'IGS_IN_EAPMPI_EAP_FK');
230: IGS_GE_MSG_STACK.ADD;
231: Close cur_rowid;
232: App_Exception.Raise_Exception;
233: Return;
234: END IF;
235: Close cur_rowid;
236:

Line 282: App_Exception.Raise_Exception;

278:
279: ) THEN
280: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
281: IGS_GE_MSG_STACK.ADD;
282: App_Exception.Raise_Exception;
283: END IF;
284:
285: Check_Constraints;
286: Check_Parent_Existance;

Line 303: App_Exception.Raise_Exception;

299:
300: ) THEN
301: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
302: IGS_GE_MSG_STACK.ADD;
303: App_Exception.Raise_Exception;
304: END IF;
305: Check_Constraints;
306: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
307: Check_Constraints;

Line 378: app_exception.raise_exception;

374: end if;
375: else
376: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
377: IGS_GE_MSG_STACK.ADD;
378: app_exception.raise_exception;
379: end if;
380:
381: Before_DML(
382: p_action=>'INSERT',

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:

Line 487: app_exception.raise_exception;

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

Line 539: app_exception.raise_exception;

535: end if;
536: else
537: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
538: IGS_GE_MSG_STACK.ADD;
539: app_exception.raise_exception;
540: end if;
541: if (X_MODE = 'R') then
542: X_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
543: X_PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;