APPS.IGS_PE_STUP_DATA_EMT_PKG dependencies on APP_EXCEPTION

Line 51: App_Exception.Raise_Exception;

47: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
48: Close cur_old_ref_values;
49: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
50: IGS_GE_MSG_STACK.ADD;
51: App_Exception.Raise_Exception;
52: Return;
53: END IF;
54: Close cur_old_ref_values;
55:

Line 107: App_Exception.Raise_Exception;

103: Column_Name IS NULL THEN
104: IF NOT (new_references.required_ind IN ('M', 'P', 'N')) THEN
105: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109: END IF;
110:
111:

Line 136: App_Exception.Raise_Exception;

132: new_references.person_type_code
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.data_element = new_references.data_element)) OR
140: ((new_references.data_element IS NULL))) THEN

Line 147: App_Exception.Raise_Exception;

143: new_references.data_element
144: ) THEN
145: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END IF;
149:
150: END Check_Parent_Existance;
151:

Line 218: App_Exception.Raise_Exception;

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

Line 255: App_Exception.Raise_Exception;

251: IF (cur_rowid%FOUND) THEN
252: Close cur_rowid;
253: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PSDE_PDE_FK');
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: Return;
257: END IF;
258: Close cur_rowid;
259:

Line 313: App_Exception.Raise_Exception;

309: IF Get_Pk_For_Validation(
310: new_references.setup_data_element_id) THEN
311: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
312: IGS_GE_MSG_STACK.ADD;
313: App_Exception.Raise_Exception;
314: END IF;
315: Check_Constraints;
316: Check_Parent_Existance;
317: ELSIF (p_action = 'UPDATE') THEN

Line 331: App_Exception.Raise_Exception;

327: IF Get_PK_For_Validation (
328: new_references.setup_data_element_id) THEN
329: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: END IF;
333: Check_Constraints;
334: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
335: Check_Constraints;

Line 418: app_exception.raise_exception;

414: end if;
415: else
416: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
417: IGS_GE_MSG_STACK.ADD;
418: app_exception.raise_exception;
419: end if;
420:
421:
422: SELECT IGS_PE_STUP_DATA_EMT_S.NEXTVAL INTO x_setup_data_element_id FROM DUAL;

Line 511: app_exception.raise_exception;

507: if (c1%notfound) then
508: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
509: IGS_GE_MSG_STACK.ADD;
510: close c1;
511: app_exception.raise_exception;
512: return;
513: end if;
514: close c1;
515: if ( ( tlinfo.PERSON_TYPE_CODE = X_PERSON_TYPE_CODE)

Line 528: app_exception.raise_exception;

524: null;
525: else
526: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
527: IGS_GE_MSG_STACK.ADD;
528: app_exception.raise_exception;
529: end if;
530: return;
531: end LOCK_ROW;
532:

Line 573: app_exception.raise_exception;

569: end if;
570: else
571: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
572: IGS_GE_MSG_STACK.ADD;
573: app_exception.raise_exception;
574: end if;
575: Before_DML(
576: p_action=>'UPDATE',
577: x_rowid=>X_ROWID,