APPS.IGS_AD_CAT_PKG dependencies on APP_EXCEPTION

Line 40: App_Exception.Raise_Exception;

36: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
37: Close cur_old_ref_values;
38: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
39: IGS_GE_MSG_STACK.ADD;
40: App_Exception.Raise_Exception;
41: Return;
42: END IF;
43: Close cur_old_ref_values;
44:

Line 78: App_Exception.Raise_Exception;

74: new_references.admission_cat,
75: v_message_name) = FALSE THEN
76: Fnd_Message.Set_Name('IGS',v_message_name);
77: IGS_GE_MSG_STACK.ADD;
78: App_Exception.Raise_Exception;
79: END IF;
80: END IF;
81: END BeforeRowInsertUpdate1;
82:

Line 102: App_Exception.Raise_Exception;

98: IF upper(column_name) = 'S_CITIZENSHIP_TYPE' OR column_name is null Then
99: IF new_references.s_citizenship_type NOT IN ('ALL','DOMESTIC','INTRNTNL') Then
100: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
101: IGS_GE_MSG_STACK.ADD;
102: App_Exception.Raise_Exception;
103: END IF;
104: END IF;
105: IF upper(column_name) = 'ADMISSION_CAT' OR column_name is null Then
106: IF new_references.admission_cat <> UPPER(new_references.admission_cat) Then

Line 109: App_Exception.Raise_Exception;

105: IF upper(column_name) = 'ADMISSION_CAT' OR column_name is null Then
106: IF new_references.admission_cat <> UPPER(new_references.admission_cat) 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: IF upper(column_name) = 'CLOSED_IND' OR column_name is null Then
113: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then

Line 116: App_Exception.Raise_Exception;

112: IF upper(column_name) = 'CLOSED_IND' OR column_name is null Then
113: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
114: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
115: IGS_GE_MSG_STACK.ADD;
116: App_Exception.Raise_Exception;
117: END IF;
118: END IF;
119: END Check_Constraints;
120:

Line 228: App_Exception.Raise_Exception;

224: IF Get_PK_For_Validation (
225: new_references.admission_cat ) THEN
226: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
227: IGS_GE_MSG_STACK.ADD;
228: App_Exception.Raise_Exception;
229: END IF;
230: Check_Constraints;
231: ELSIF (p_action = 'UPDATE') THEN
232: -- Call all the procedures related to Before Update.

Line 243: App_Exception.Raise_Exception;

239: IF Get_PK_For_Validation (
240: new_references.admission_cat ) THEN
241: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: END IF;
245: Check_Constraints;
246: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
247: Check_Constraints;

Line 294: app_exception.raise_exception;

290: end if;
291: else
292: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
293: IGS_GE_MSG_STACK.ADD;
294: app_exception.raise_exception;
295: end if;
296:
297: Before_DML(
298: p_action=>'INSERT',

Line 371: app_exception.raise_exception;

367: fetch c1 into tlinfo;
368: if (c1%notfound) then
369: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
370: IGS_GE_MSG_STACK.ADD;
371: app_exception.raise_exception;
372: close c1;
373: return;
374: end if;
375: close c1;

Line 385: app_exception.raise_exception;

381: null;
382: else
383: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
384: IGS_GE_MSG_STACK.ADD;
385: app_exception.raise_exception;
386: end if;
387: return;
388: end LOCK_ROW;
389:

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:
421: Before_DML(
422: p_action=>'UPDATE',