APPS.IGS_AD_CAT_PKG dependencies on IGS_GE_MSG_STACK

Line 39: IGS_GE_MSG_STACK.ADD;

35: Fetch cur_old_ref_values INTO old_references;
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;

Line 77: IGS_GE_MSG_STACK.ADD;

73: IF IGS_AD_VAL_AC.admp_val_ac_upd (
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;

Line 101: IGS_GE_MSG_STACK.ADD;

97:
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

Line 108: IGS_GE_MSG_STACK.ADD;

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
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

Line 115: IGS_GE_MSG_STACK.ADD;

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
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;

Line 227: IGS_GE_MSG_STACK.ADD;

223: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
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

Line 242: IGS_GE_MSG_STACK.ADD;

238: ELSIF (p_action = 'VALIDATE_INSERT') THEN
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

Line 293: IGS_GE_MSG_STACK.ADD;

289: X_LAST_UPDATE_LOGIN := -1;
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(

Line 370: IGS_GE_MSG_STACK.ADD;

366: open c1;
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;

Line 384: IGS_GE_MSG_STACK.ADD;

380: ) then
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;

Line 417: IGS_GE_MSG_STACK.ADD;

413: X_LAST_UPDATE_LOGIN := -1;
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(