APPS.IGS_PR_MILESTONE_HST_PKG dependencies on APP_EXCEPTION

Line 51: App_Exception.Raise_Exception;

47: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
48: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
49: IGS_GE_MSG_STACK.ADD;
50: Close cur_old_ref_values;
51: App_Exception.Raise_Exception;
52: Return;
53: END IF;
54: Close cur_old_ref_values;
55:

Line 185: App_Exception.Raise_Exception;

181: new_references.hist_start_dt
182: ) THEN
183: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
184: IGS_GE_MSG_STACK.ADD;
185: App_Exception.Raise_Exception;
186: END IF;
187: Check_Constraints;
188: ELSIF (p_action = 'UPDATE') THEN
189: -- Call all the procedures related to Before Update.

Line 201: App_Exception.Raise_Exception;

197: new_references.hist_start_dt
198: ) THEN
199: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
200: IGS_GE_MSG_STACK.ADD;
201: App_Exception.Raise_Exception;
202: END IF;
203: Check_Constraints;
204: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
205: -- Call all the procedures related to Before Update.

Line 257: app_exception.raise_exception;

253: end if;
254: else
255: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
256: IGS_GE_MSG_STACK.ADD;
257: app_exception.raise_exception;
258: end if;
259:
260: Before_DML (
261: p_action => 'INSERT',

Line 387: app_exception.raise_exception;

383: if (c1%notfound) then
384: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
385: IGS_GE_MSG_STACK.ADD;
386: close c1;
387: app_exception.raise_exception;
388: return;
389: end if;
390: close c1;
391:

Line 430: app_exception.raise_exception;

426: null;
427: else
428: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
429: IGS_GE_MSG_STACK.ADD;
430: app_exception.raise_exception;
431: end if;
432: return;
433: end LOCK_ROW;
434:

Line 475: app_exception.raise_exception;

471: end if;
472: else
473: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
474: IGS_GE_MSG_STACK.ADD;
475: app_exception.raise_exception;
476: end if;
477: Before_DML (
478: p_action => 'UPDATE',
479: x_rowid => x_rowid,

Line 644: App_Exception.Raise_Exception ;

640: IF upper(Column_name) = 'CA_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
641: IF new_references.CA_SEQUENCE_NUMBER < 1 or new_references.CA_SEQUENCE_NUMBER > 999999 then
642: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
643: IGS_GE_MSG_STACK.ADD;
644: App_Exception.Raise_Exception ;
645: END IF;
646:
647: END IF ;
648:

Line 653: App_Exception.Raise_Exception ;

649: IF upper(Column_name) = 'SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
650: IF new_references.SEQUENCE_NUMBER < 1 or new_references.SEQUENCE_NUMBER > 999999 then
651: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
652: IGS_GE_MSG_STACK.ADD;
653: App_Exception.Raise_Exception ;
654: END IF;
655:
656: END IF ;
657:

Line 662: App_Exception.Raise_Exception ;

658: IF upper(Column_name) = 'PRECED_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
659: IF new_references.PRECED_SEQUENCE_NUMBER < 1 or new_references.PRECED_SEQUENCE_NUMBER > 999999 then
660: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
661: IGS_GE_MSG_STACK.ADD;
662: App_Exception.Raise_Exception ;
663: END IF;
664:
665: END IF ;
666: END Check_Constraints;