APPS.IGS_AD_INTERFACE_CTL_PKG dependencies on APP_EXCEPTION

Line 50: App_Exception.Raise_Exception;

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;
54:

Line 111: App_Exception.Raise_Exception;

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:
115: END Check_Constraints;

Line 140: App_Exception.Raise_Exception;

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
144: ((new_references.match_set_id IS NULL))) THEN

Line 151: App_Exception.Raise_Exception;

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:
155:

Line 224: App_Exception.Raise_Exception;

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;
228:

Line 261: App_Exception.Raise_Exception;

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;
265:

Line 317: App_Exception.Raise_Exception;

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;
321: ELSIF (p_action = 'UPDATE') THEN

Line 335: App_Exception.Raise_Exception;

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
339: Check_Constraints;

Line 436: app_exception.raise_exception;

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;
440: Before_DML(

Line 537: APP_EXCEPTION.RAISE_EXCEPTION;

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;
540: CLOSE C1;
541:

Line 553: app_exception.raise_exception;

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;
557:

Line 603: app_exception.raise_exception;

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(
607: p_action=>'UPDATE',