APPS.IGS_PS_USEC_LIM_WLST_PKG dependencies on APP_EXCEPTION

Line 55: App_Exception.Raise_Exception;

51: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
52: Close cur_old_ref_values;
53: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
54: IGS_GE_MSG_STACK.ADD;
55: App_Exception.Raise_Exception;
56: Return;
57: END IF;
58: Close cur_old_ref_values;
59:

Line 126: app_exception.raise_exception;

122: new_references.uoo_id
123: ) THEN
124: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
125: IGS_GE_MSG_STACK.ADD;
126: app_exception.raise_exception;
127: END IF;
128: END Check_Uniqueness ;
129: PROCEDURE Check_Parent_Existance AS
130: /*************************************************************

Line 151: App_Exception.Raise_Exception;

147: new_references.uoo_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:
154: END Check_Parent_Existance;
155:

Line 257: App_Exception.Raise_Exception;

253: IF (cur_rowid%FOUND) THEN
254: Close cur_rowid;
255: Fnd_Message.Set_Name ('IGS', 'IGS_PS_USLW_UOO_UFK');
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: Return;
259: END IF;
260: Close cur_rowid;
261:

Line 323: App_Exception.Raise_Exception;

319: IF Get_Pk_For_Validation(
320: new_references.unit_section_limit_waitlist_id) THEN
321: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
322: IGS_GE_MSG_STACK.ADD;
323: App_Exception.Raise_Exception;
324: END IF;
325: Check_Uniqueness;
326: Check_Constraints;
327: Check_Parent_Existance;

Line 343: App_Exception.Raise_Exception;

339: IF Get_PK_For_Validation (
340: new_references.unit_section_limit_waitlist_id) THEN
341: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
342: IGS_GE_MSG_STACK.ADD;
343: App_Exception.Raise_Exception;
344: END IF;
345: Check_Uniqueness;
346: Check_Constraints;
347: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 408: app_exception.raise_exception;

404:
405:
406: FND_MESSAGE.SET_NAME( 'IGS', 'l_message_name');
407: IGS_GE_MSG_STACK.ADD;
408: app_exception.raise_exception;
409: END IF;
410: END IF;
411: ELSIF (p_action = 'UPDATE') THEN
412:

Line 432: app_exception.raise_exception;

428:
429:
430: FND_MESSAGE.SET_NAME( 'IGS', 'l_message_name');
431: IGS_GE_MSG_STACK.ADD;
432: app_exception.raise_exception;
433: END IF;
434: END IF;
435:
436:

Line 462: app_exception.raise_exception;

458:
459:
460: FND_MESSAGE.SET_NAME( 'IGS', 'l_message_name');
461: IGS_GE_MSG_STACK.ADD;
462: app_exception.raise_exception;
463: END IF;
464: END IF;
465:
466: END IF;

Line 519: app_exception.raise_exception;

515: end if;
516: else
517: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
518: IGS_GE_MSG_STACK.ADD;
519: app_exception.raise_exception;
520: end if;
521: SELECT
522: igs_ps_usec_lim_wlst_s.nextval
523: INTO

Line 632: APP_EXCEPTION.RAISE_EXCEPTION;

628: IF (c1%NOTFOUND) THEN
629: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
630: IGS_GE_MSG_STACK.ADD;
631: CLOSE c1;
632: APP_EXCEPTION.RAISE_EXCEPTION;
633: RETURN;
634: END IF;
635: CLOSE c1;
636: IF ( ( tlinfo.uoo_id = x_uoo_id)

Line 662: APP_EXCEPTION.RAISE_EXCEPTION;

658: NULL;
659: ELSE
660: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
661: IGS_GE_MSG_STACK.ADD;
662: APP_EXCEPTION.RAISE_EXCEPTION;
663: END IF;
664: RETURN;
665: END LOCK_ROW;
666:

Line 712: app_exception.raise_exception;

708: end if;
709: else
710: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
711: IGS_GE_MSG_STACK.ADD;
712: app_exception.raise_exception;
713: end if;
714: Before_DML(
715: p_action =>'UPDATE',
716: x_rowid =>X_ROWID,