APPS.IGS_PR_MS_STAT_PKG dependencies on APP_EXCEPTION

Line 38: App_Exception.Raise_Exception;

34: Fetch cur_old_ref_values INTO old_references;
35: IF (cur_old_ref_values%NOTFOUND) AND (p_action not in ('INSERT','VALIDATE_INSERT')) THEN
36: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
37: IGS_GE_MSG_STACK.ADD;
38: App_Exception.Raise_Exception;
39: Close cur_old_ref_values;
40: Return;
41: END IF;
42: Close cur_old_ref_values;

Line 78: App_Exception.Raise_Exception;

74: new_references.s_milestone_status
75: ) THEN
76: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
77: IGS_GE_MSG_STACK.ADD;
78: App_Exception.Raise_Exception;
79: END IF;
80: END IF;
81:
82: END Check_Parent_Existance;

Line 137: App_Exception.Raise_Exception;

133: Fetch cur_rowid INTO lv_rowid;
134: IF (cur_rowid%FOUND) THEN
135: Fnd_Message.Set_Name ('IGS', 'IGS_PR_MST_SMST_FK');
136: IGS_GE_MSG_STACK.ADD;
137: App_Exception.Raise_Exception;
138: Close cur_rowid;
139: Return;
140: END IF;
141: Close cur_rowid;

Line 183: App_Exception.Raise_Exception;

179: new_references.milestone_status
180: ) THEN
181: Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
182: IGS_GE_MSG_STACK.ADD;
183: App_Exception.Raise_Exception;
184: END IF;
185: Check_Constraints;
186: Check_Parent_Existance;
187: ELSIF (p_action = 'UPDATE') THEN

Line 201: App_Exception.Raise_Exception;

197: new_references.milestone_status
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 267: app_exception.raise_exception;

263: end if;
264: else
265: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
266: IGS_GE_MSG_STACK.ADD;
267: app_exception.raise_exception;
268: end if;
269:
270: Before_DML (
271: p_action => 'INSERT',

Line 343: app_exception.raise_exception;

339: fetch c1 into tlinfo;
340: if (c1%notfound) then
341: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
342: IGS_GE_MSG_STACK.ADD;
343: app_exception.raise_exception;
344: close c1;
345: return;
346: end if;
347: close c1;

Line 357: app_exception.raise_exception;

353: null;
354: else
355: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
356: IGS_GE_MSG_STACK.ADD;
357: app_exception.raise_exception;
358: end if;
359: return;
360: end LOCK_ROW;
361:

Line 390: app_exception.raise_exception;

386: end if;
387: else
388: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
389: IGS_GE_MSG_STACK.ADD;
390: app_exception.raise_exception;
391: end if;
392: Before_DML (
393: p_action => 'UPDATE',
394: x_rowid => x_rowid,

Line 507: App_Exception.Raise_Exception ;

503: IF upper(Column_name) = 'CLOSED_IND' OR COLUMN_NAME IS NULL THEN
504: IF new_references.CLOSED_IND<> upper(new_references.CLOSED_IND) then
505: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
506: IGS_GE_MSG_STACK.ADD;
507: App_Exception.Raise_Exception ;
508: END IF;
509:
510: IF new_references.CLOSED_IND not in ('Y','N') then
511: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

Line 513: App_Exception.Raise_Exception ;

509:
510: IF new_references.CLOSED_IND not in ('Y','N') then
511: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
512: IGS_GE_MSG_STACK.ADD;
513: App_Exception.Raise_Exception ;
514: END IF;
515:
516: END IF ;
517:

Line 524: App_Exception.Raise_Exception ;

520: IF upper(Column_name) = 'MILESTONE_STATUS' OR COLUMN_NAME IS NULL THEN
521: IF new_references.MILESTONE_STATUS<> upper(new_references.MILESTONE_STATUS) then
522: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
523: IGS_GE_MSG_STACK.ADD;
524: App_Exception.Raise_Exception ;
525: END IF;
526:
527: END IF ;
528:

Line 533: App_Exception.Raise_Exception ;

529: IF upper(Column_name) = 'S_MILESTONE_STATUS' OR COLUMN_NAME IS NULL THEN
530: IF new_references.S_MILESTONE_STATUS<> upper(new_references.S_MILESTONE_STATUS) then
531: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
532: IGS_GE_MSG_STACK.ADD;
533: App_Exception.Raise_Exception ;
534: END IF;
535:
536: END IF ;
537: