APPS.IGS_PS_OFR_PKG dependencies on APP_EXCEPTION

Line 70: App_Exception.Raise_Exception;

66: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
67: Close cur_old_ref_values;
68: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
69: IGS_GE_MSG_STACK.ADD;
70: App_Exception.Raise_Exception;
71: Return;
72: END IF;
73: Close cur_old_ref_values;
74:

Line 155: App_Exception.Raise_Exception;

151: v_version_number,
152: v_message_name) = FALSE THEN
153: Fnd_Message.Set_Name('IGS',v_message_name);
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157: -- Validate calendar type.
158: IF p_inserting OR
159: (p_updating AND old_references.cal_type <> new_references.cal_type) THEN

Line 165: App_Exception.Raise_Exception;

161: new_references.cal_type,
162: v_message_name) = FALSE THEN
163: Fnd_Message.Set_Name('IGS',v_message_name);
164: IGS_GE_MSG_STACK.ADD;
165: App_Exception.Raise_Exception;
166: END IF;
167: END IF;
168: END BeforeRowInsertUpdateDelete1;
169:

Line 199: App_Exception.Raise_Exception;

195: column_name is null Then
196: IF ( new_references.cal_type <> UPPER(new_references.cal_type) ) Then
197: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: END IF;
202:
203: IF upper(column_name) = 'COURSE_CD' OR

Line 208: App_Exception.Raise_Exception;

204: column_name is null Then
205: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
206: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
207: IGS_GE_MSG_STACK.ADD;
208: App_Exception.Raise_Exception;
209: END IF;
210: END IF;
211:
212: END Check_Constraints;

Line 235: App_Exception.Raise_Exception;

231: new_references.cal_type
232: ) THEN
233: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
234: IGS_GE_MSG_STACK.ADD;
235: App_Exception.Raise_Exception;
236: END IF;
237: END IF;
238:
239: IF (((old_references.course_cd = new_references.course_cd) AND

Line 251: App_Exception.Raise_Exception;

247: new_references.version_number
248: ) THEN
249: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
250: IGS_GE_MSG_STACK.ADD;
251: App_Exception.Raise_Exception;
252: END IF;
253: END IF;
254:
255: END Check_Parent_Existance;

Line 381: App_Exception.Raise_Exception;

377: IF (cur_rowid%FOUND) THEN
378: Close cur_rowid;
379: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CO_CAT_FK');
380: IGS_GE_MSG_STACK.ADD;
381: App_Exception.Raise_Exception;
382: Return;
383: END IF;
384: Close cur_rowid;
385:

Line 417: App_Exception.Raise_Exception;

413: IF (cur_rowid%FOUND) THEN
414: Close cur_rowid;
415: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CO_CRV_FK');
416: IGS_GE_MSG_STACK.ADD;
417: App_Exception.Raise_Exception;
418: Return;
419: END IF;
420: Close cur_rowid;
421:

Line 514: App_Exception.Raise_Exception;

510: new_references.version_number,
511: new_references.cal_type) THEN
512: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
513: IGS_GE_MSG_STACK.ADD;
514: App_Exception.Raise_Exception;
515: END IF;
516: Check_Constraints;
517: Check_Parent_Existance;
518: ELSIF (p_action = 'UPDATE') THEN

Line 534: App_Exception.Raise_Exception;

530: new_references.version_number,
531: new_references.cal_type) THEN
532: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
533: IGS_GE_MSG_STACK.ADD;
534: App_Exception.Raise_Exception;
535: END IF;
536: Check_Constraints;
537: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
538: Check_Constraints;

Line 619: app_exception.raise_exception;

615: end if;
616: else
617: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
618: IGS_GE_MSG_STACK.ADD;
619: app_exception.raise_exception;
620: end if;
621: Before_DML (
622: p_action => 'INSERT',
623: x_rowid => X_ROWID,

Line 784: app_exception.raise_exception;

780: if (c1%notfound) then
781: close c1;
782: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
783: IGS_GE_MSG_STACK.ADD;
784: app_exception.raise_exception;
785: return;
786: end if;
787: close c1;
788: