APPS.IGS_PS_USEC_SPNSRSHP_PKG dependencies on APP_EXCEPTION

Line 49: App_Exception.Raise_Exception;

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

Line 98: App_Exception.Raise_Exception;

94: IF upper(column_name)= 'SPONSORSHIP_PERCENTAGE' OR column_name is null THEN
95: IF (new_references.sponsorship_percentage not between 0 and 100) THEN
96: Fnd_Message.Set_Name ('IGS', 'IGS_PS_SPNSRSHP_NOTBET_0_100');
97: IGS_GE_MSG_STACK.ADD;
98: App_Exception.Raise_Exception;
99: END IF;
100: END IF;
101: END Check_Constraints;
102:

Line 122: app_exception.raise_exception;

118: new_references.organization_code
119: ) THEN
120: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
121: IGS_GE_MSG_STACK.ADD;
122: app_exception.raise_exception;
123: END IF;
124: END Check_Uniqueness ;
125: PROCEDURE Check_Parent_Existance AS
126: /*************************************************************

Line 147: App_Exception.Raise_Exception;

143: new_references.uoo_id
144: ) THEN
145: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END IF;
149:
150: END Check_Parent_Existance;
151:

Line 254: App_Exception.Raise_Exception;

250: IF (cur_rowid%FOUND) THEN
251: Close cur_rowid;
252: Fnd_Message.Set_Name ('IGS', 'IGS_PS_USPN_UOO_UFK');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: Return;
256: END IF;
257: Close cur_rowid;
258:

Line 308: App_Exception.Raise_Exception;

304: IF Get_Pk_For_Validation(
305: new_references.unit_section_sponsorship_id) THEN
306: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
307: IGS_GE_MSG_STACK.ADD;
308: App_Exception.Raise_Exception;
309: END IF;
310: Check_Uniqueness;
311: Check_Constraints;
312: Check_Parent_Existance;

Line 328: App_Exception.Raise_Exception;

324: IF Get_PK_For_Validation (
325: new_references.unit_section_sponsorship_id) THEN
326: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
327: IGS_GE_MSG_STACK.ADD;
328: App_Exception.Raise_Exception;
329: END IF;
330: Check_Uniqueness;
331: Check_Constraints;
332: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 419: app_exception.raise_exception;

415: end if;
416: else
417: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
418: IGS_GE_MSG_STACK.ADD;
419: app_exception.raise_exception;
420: end if;
421:
422: SELECT
423: IGS_PS_USEC_SPNSRSHP_S.NEXTVAL

Line 505: app_exception.raise_exception;

501: if (c1%notfound) then
502: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
503: IGS_GE_MSG_STACK.ADD;
504: close c1;
505: app_exception.raise_exception;
506: return;
507: end if;
508: close c1;
509: if ( ( tlinfo.UOO_ID = X_UOO_ID)

Line 517: app_exception.raise_exception;

513: null;
514: else
515: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
516: IGS_GE_MSG_STACK.ADD;
517: app_exception.raise_exception;
518: end if;
519: return;
520: end LOCK_ROW;
521: Procedure UPDATE_ROW (

Line 560: app_exception.raise_exception;

556: end if;
557: else
558: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
559: IGS_GE_MSG_STACK.ADD;
560: app_exception.raise_exception;
561: end if;
562: Before_DML(
563: p_action=>'UPDATE',
564: x_rowid=>X_ROWID,