APPS.IGS_PE_MATCH_SETS_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 117: App_Exception.Raise_Exception;

113: Column_Name IS NULL THEN
114: IF NOT (new_references.closed_ind IN ('Y', 'N')) THEN
115: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
116: IGS_GE_MSG_STACK.ADD;
117: App_Exception.Raise_Exception;
118: END IF;
119: END IF;
120:
121:

Line 128: App_Exception.Raise_Exception;

124: Column_Name IS NULL THEN
125: IF NOT (new_references.partial_if_null IN ('Y', 'N')) THEN
126: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
127: IGS_GE_MSG_STACK.ADD;
128: App_Exception.Raise_Exception;
129: END IF;
130: END IF;
131:
132: END Check_Constraints;

Line 199: App_Exception.Raise_Exception;

195: IF (cur_rowid%FOUND) THEN
196: CLOSE cur_rowid;
197: Fnd_Message.Set_Name ('IGS', 'IGS_PE_MTCH_SETS_SRC_TYP_FK');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: RETURN;
201: END IF;
202: CLOSE cur_rowid;
203:

Line 234: App_Exception.Raise_Exception;

230: IF (cur_rowid%FOUND) THEN
231: CLOSE cur_rowid;
232: Fnd_Message.Set_Name ('IGS', 'IGS_PE_MTCH_SETS_DUP_PAIRS_FK');
233: IGS_GE_MSG_STACK.ADD;
234: App_Exception.Raise_Exception;
235: RETURN;
236: END IF;
237: CLOSE cur_rowid;
238:

Line 404: App_Exception.Raise_Exception;

400: new_references.match_set_name
401: ) THEN
402: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
403: IGS_GE_MSG_STACK.ADD;
404: App_Exception.Raise_Exception;
405: END IF;
406:
407: END Check_Uniqueness;
408:

Line 471: App_Exception.Raise_Exception;

467: IF Get_Pk_For_Validation(
468: new_references.match_set_id) THEN
469: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
470: IGS_GE_MSG_STACK.ADD;
471: App_Exception.Raise_Exception;
472: END IF;
473: Check_Constraints;
474: Check_Uniqueness;
475: ELSIF (p_action = 'UPDATE') THEN

Line 490: App_Exception.Raise_Exception;

486: IF Get_PK_For_Validation (
487: new_references.match_set_id) THEN
488: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
489: IGS_GE_MSG_STACK.ADD;
490: App_Exception.Raise_Exception;
491: END IF;
492: Check_Constraints;
493:
494: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 587: app_exception.raise_exception;

583: end if;
584: else
585: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
586: IGS_GE_MSG_STACK.ADD;
587: app_exception.raise_exception;
588: end if;
589:
590: SELECT igs_pe_match_sets_S.NEXTVAL
591: INTO X_MATCH_SET_ID

Line 697: app_exception.raise_exception;

693: if (c1%notfound) then
694: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
695: IGS_GE_MSG_STACK.ADD;
696: close c1;
697: app_exception.raise_exception;
698: return;
699: end if;
700: close c1;
701:

Line 718: app_exception.raise_exception;

714: null;
715: else
716: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
717: IGS_GE_MSG_STACK.ADD;
718: app_exception.raise_exception;
719: end if;
720: return;
721: end LOCK_ROW;
722: Procedure UPDATE_ROW (

Line 764: app_exception.raise_exception;

760: end if;
761: else
762: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
763: IGS_GE_MSG_STACK.ADD;
764: app_exception.raise_exception;
765: end if;
766: Before_DML(
767: p_action=>'UPDATE',
768: x_rowid=>X_ROWID,