APPS.IGS_PE_MATCH_SETS_PKG dependencies on IGS_GE_MSG_STACK

Line 52: IGS_GE_MSG_STACK.ADD;

48: Fetch cur_old_ref_values INTO old_references;
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;

Line 116: IGS_GE_MSG_STACK.ADD;

112: IF Upper(Column_Name) = 'CLOSED_IND' OR
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:

Line 127: IGS_GE_MSG_STACK.ADD;

123: IF Upper(Column_Name) = 'PARTIAL_IF_NULL' OR
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:

Line 198: IGS_GE_MSG_STACK.ADD;

194: FETCH cur_rowid INTO lv_rowid;
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;

Line 233: IGS_GE_MSG_STACK.ADD;

229: FETCH cur_rowid INTO lv_rowid;
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;

Line 403: IGS_GE_MSG_STACK.ADD;

399: IF Get_UK1_For_Validation (
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;

Line 470: IGS_GE_MSG_STACK.ADD;

466: Null;
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;

Line 489: IGS_GE_MSG_STACK.ADD;

485: -- Call all the procedures related to Before Insert.
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:

Line 586: IGS_GE_MSG_STACK.ADD;

582: X_LAST_UPDATE_LOGIN := -1;
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

Line 695: IGS_GE_MSG_STACK.ADD;

691: open c1;
692: fetch c1 into tlinfo;
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;

Line 717: IGS_GE_MSG_STACK.ADD;

713: ) then
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;

Line 763: IGS_GE_MSG_STACK.ADD;

759: X_LAST_UPDATE_LOGIN := -1;
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',