APPS.IGS_PE_DUP_PAIRS_PKG dependencies on APP_EXCEPTION

Line 62: App_Exception.Raise_Exception;

58: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
59: Close cur_old_ref_values;
60: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
61: IGS_GE_MSG_STACK.ADD;
62: App_Exception.Raise_Exception;
63: Return;
64: END IF;
65: Close cur_old_ref_values;
66:

Line 129: App_Exception.Raise_Exception;

125: Column_Name IS NULL THEN
126: IF NOT (new_references.match_category IN ('M', 'P')) THEN
127: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131: END IF;
132:
133:

Line 245: App_Exception.Raise_Exception;

241: IF Get_Pk_For_Validation(
242: new_references.duplicate_pair_id) THEN
243: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
244: IGS_GE_MSG_STACK.ADD;
245: App_Exception.Raise_Exception;
246: END IF;
247: Check_Constraints;
248: ELSIF (p_action = 'UPDATE') THEN
249: -- Call all the procedures related to Before Update.

Line 261: App_Exception.Raise_Exception;

257: IF Get_PK_For_Validation (
258: new_references.duplicate_pair_id) THEN
259: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: END IF;
263: Check_Constraints;
264: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
265: Check_Constraints;

Line 379: app_exception.raise_exception;

375: end if;
376: else
377: FND_MESSAGE.SET_NAME('FND','SYSTEM-INVALID ARGS');
378: IGS_GE_MSG_STACK.ADD;
379: app_exception.raise_exception;
380: end if;
381:
382: SELECT IGS_PE_DUP_PAIRS_S.NEXTVAL
383: INTO X_DUPLICATE_PAIR_ID

Line 515: app_exception.raise_exception;

511: if (c1%notfound) then
512: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
513: IGS_GE_MSG_STACK.ADD;
514: close c1;
515: app_exception.raise_exception;
516: return;
517: end if;
518: close c1;
519: if (tlinfo.BATCH_ID = X_BATCH_ID)

Line 542: app_exception.raise_exception;

538: null;
539: else
540: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
541: IGS_GE_MSG_STACK.ADD;
542: app_exception.raise_exception;
543: end if;
544: return;
545: end LOCK_ROW;
546:

Line 602: app_exception.raise_exception;

598: end if;
599: else
600: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
601: IGS_GE_MSG_STACK.ADD;
602: app_exception.raise_exception;
603: end if;
604: Before_DML(
605: p_action=>'UPDATE',
606: x_rowid=>X_ROWID,