APPS.IGS_AD_INTERFACE_CTL_PKG dependencies on IGS_GE_MSG_STACK

Line 49: IGS_GE_MSG_STACK.ADD;

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

Line 110: IGS_GE_MSG_STACK.ADD;

106: IF Upper(Column_Name) = 'STATUS' OR
107: Column_Name IS NULL THEN
108: IF NOT (new_references.status in ('1','2','3','4')) THEN
109: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113: END IF;
114:

Line 139: IGS_GE_MSG_STACK.ADD;

135: ELSIF NOT Igs_Pe_Src_Types_Pkg.Get_PK_For_Validation (
136: new_references.source_type_id
137: ) THEN
138: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
139: IGS_GE_MSG_STACK.ADD;
140: App_Exception.Raise_Exception;
141: END IF;
142:
143: IF (((old_references.match_set_id = new_references.match_set_id)) OR

Line 150: IGS_GE_MSG_STACK.ADD;

146: ELSIF NOT Igs_Pe_Match_Sets_Pkg.Get_PK_For_Validation (
147: new_references.match_set_id
148: ) THEN
149: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
150: IGS_GE_MSG_STACK.ADD;
151: App_Exception.Raise_Exception;
152: END IF;
153: END Check_Parent_Existance;
154:

Line 223: IGS_GE_MSG_STACK.ADD;

219: Fetch cur_rowid INTO lv_rowid;
220: IF (cur_rowid%FOUND) THEN
221: Close cur_rowid;
222: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AIC_PST_FK');
223: IGS_GE_MSG_STACK.ADD;
224: App_Exception.Raise_Exception;
225: Return;
226: END IF;
227: Close cur_rowid;

Line 260: IGS_GE_MSG_STACK.ADD;

256: Fetch cur_rowid INTO lv_rowid;
257: IF (cur_rowid%FOUND) THEN
258: Close cur_rowid;
259: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AIC_PMS_FK');
260: IGS_GE_MSG_STACK.ADD;
261: App_Exception.Raise_Exception;
262: Return;
263: END IF;
264: Close cur_rowid;

Line 316: IGS_GE_MSG_STACK.ADD;

312: Null;
313: IF Get_Pk_For_Validation(
314: new_references.interface_run_id) THEN
315: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
316: IGS_GE_MSG_STACK.ADD;
317: App_Exception.Raise_Exception;
318: END IF;
319: Check_Constraints;
320: Check_Parent_Existance;

Line 334: IGS_GE_MSG_STACK.ADD;

330: -- Call all the procedures related to Before Insert.
331: IF Get_PK_For_Validation (
332: new_references.interface_run_id) THEN
333: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
334: IGS_GE_MSG_STACK.ADD;
335: App_Exception.Raise_Exception;
336: END IF;
337: Check_Constraints;
338: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 435: IGS_GE_MSG_STACK.ADD;

431: X_PROGRAM_UPDATE_DATE := SYSDATE;
432: end if;
433: else
434: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
435: IGS_GE_MSG_STACK.ADD;
436: app_exception.raise_exception;
437: end if;
438:
439: X_INTERFACE_RUN_ID := -1;

Line 535: IGS_GE_MSG_STACK.ADD;

531: OPEN c1;
532: FETCH c1 INTO tlinfo;
533: IF (c1%notfound) THEN
534: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
535: IGS_GE_MSG_STACK.ADD;
536: CLOSE c1;
537: APP_EXCEPTION.RAISE_EXCEPTION;
538: RETURN;
539: END IF;

Line 552: IGS_GE_MSG_STACK.ADD;

548: ) THEN
549: NULL;
550: ELSE
551: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
552: IGS_GE_MSG_STACK.ADD;
553: app_exception.raise_exception;
554: END IF;
555: RETURN;
556: end LOCK_ROW;

Line 602: IGS_GE_MSG_STACK.ADD;

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