APPS.IGS_PE_MTCH_SET_DATA_PKG dependencies on APP_EXCEPTION

Line 53: App_Exception.Raise_Exception;

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

Line 115: App_Exception.Raise_Exception;

111: Column_Name IS NULL THEN
112: IF NOT (new_references.exact_include IN ('Y', 'N')) THEN
113: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception;
116: END IF;
117: END IF;
118:
119: -- The following code checks for check constraints on the Columns.

Line 125: App_Exception.Raise_Exception;

121: Column_Name IS NULL THEN
122: IF NOT (new_references.partial_include IN ('Y', 'N')) THEN
123: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;
128:
129: -- The following code checks for check constraints on the Columns.

Line 135: App_Exception.Raise_Exception;

131: Column_Name IS NULL THEN
132: IF NOT (new_references.drop_if_null IN ('Y', 'N')) THEN
133: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END IF;
138:
139: END Check_Constraints;

Line 232: App_Exception.Raise_Exception;

228: IF Get_Pk_For_Validation(
229: new_references.match_set_data_id) THEN
230: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
231: IGS_GE_MSG_STACK.ADD;
232: App_Exception.Raise_Exception;
233: END IF;
234: Check_Constraints;
235: ELSIF (p_action = 'UPDATE') THEN
236: -- Call all the procedures related to Before Update.

Line 248: App_Exception.Raise_Exception;

244: IF Get_PK_For_Validation (
245: new_references.match_set_data_id) THEN
246: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
247: IGS_GE_MSG_STACK.ADD;
248: App_Exception.Raise_Exception;
249: END IF;
250: Check_Constraints;
251: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
252: Check_Constraints;

Line 337: app_exception.raise_exception;

333: end if;
334: else
335: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
336: IGS_GE_MSG_STACK.ADD;
337: app_exception.raise_exception;
338: end if;
339:
340: SELECT IGS_PE_MTCH_SET_DATA_S.NEXTVAL
341: INTO X_MATCH_SET_DATA_ID

Line 440: app_exception.raise_exception;

436: if (c1%notfound) then
437: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
438: IGS_GE_MSG_STACK.ADD;
439: close c1;
440: app_exception.raise_exception;
441: return;
442: end if;
443: close c1;
444: if (tlinfo.MATCH_SET_ID = X_MATCH_SET_ID)

Line 459: app_exception.raise_exception;

455: null;
456: else
457: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
458: IGS_GE_MSG_STACK.ADD;
459: app_exception.raise_exception;
460: end if;
461: return;
462: end LOCK_ROW;
463: Procedure UPDATE_ROW (

Line 505: app_exception.raise_exception;

501: end if;
502: else
503: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
504: IGS_GE_MSG_STACK.ADD;
505: app_exception.raise_exception;
506: end if;
507: Before_DML(
508: p_action=>'UPDATE',
509: x_rowid=>X_ROWID,