APPS.IGS_AD_SYSSRC_CAT_PKG dependencies on APP_EXCEPTION

Line 53: App_Exception.Raise_Exception;

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

Line 109: App_Exception.Raise_Exception;

105: Column_Name IS NULL THEN
106: IF NOT (new_references.mandatory_ind IN ('Y','N')) THEN
107: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
108: IGS_GE_MSG_STACK.ADD;
109: App_Exception.Raise_Exception;
110: END IF;
111: END IF;
112:
113: END Check_Constraints;

Line 142: App_Exception.Raise_Exception;

138: new_references.system_source_type
139: ) THEN
140: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
141: IGS_GE_MSG_STACK.ADD;
142: App_Exception.Raise_Exception;
143: END IF;
144:
145: */
146: END Check_Parent_Existance;

Line 244: app_exception.raise_exception;

240: ,new_references.system_source_type
241: ) THEN
242: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
243: IGS_GE_MSG_STACK.ADD;
244: app_exception.raise_exception;
245: END IF;
246: END Check_Uniqueness ;
247:
248:

Line 305: App_Exception.Raise_Exception;

301: new_references.category_name,
302: new_references.system_source_type) THEN
303: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
304: IGS_GE_MSG_STACK.ADD;
305: App_Exception.Raise_Exception;
306: END IF;
307: --kumma, called the Check_Uniqueness 2664699
308: Check_Uniqueness;
309: Check_Constraints;

Line 328: App_Exception.Raise_Exception;

324: new_references.category_name,
325: new_references.system_source_type) 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_Constraints;
331: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
332: Check_Constraints;

Line 418: app_exception.raise_exception;

414: end if;
415: else
416: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
417: IGS_GE_MSG_STACK.ADD;
418: app_exception.raise_exception;
419: end if;
420: Before_DML(
421: p_action=>'INSERT',
422: x_rowid=>X_ROWID,

Line 518: app_exception.raise_exception;

514: if (c1%notfound) then
515: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
516: IGS_GE_MSG_STACK.ADD;
517: close c1;
518: app_exception.raise_exception;
519: return;
520: end if;
521: close c1;
522: if ( (tlinfo.MANDATORY_IND = X_MANDATORY_IND)

Line 531: app_exception.raise_exception;

527: null;
528: else
529: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
530: IGS_GE_MSG_STACK.ADD;
531: app_exception.raise_exception;
532: end if;
533: return;
534: end LOCK_ROW;
535: Procedure UPDATE_ROW (

Line 578: app_exception.raise_exception;

574: end if;
575: else
576: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
577: IGS_GE_MSG_STACK.ADD;
578: app_exception.raise_exception;
579: end if;
580: Before_DML(
581: p_action=>'UPDATE',
582: x_rowid=>X_ROWID,