APPS.IGS_AD_CAT_PS_TYPE_PKG dependencies on IGS_GE_MSG_STACK

Line 35: IGS_GE_MSG_STACK.ADD;

31: Open cur_old_ref_values;
32: Fetch cur_old_ref_values INTO old_references;
33: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
34: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
35: IGS_GE_MSG_STACK.ADD;
36: App_Exception.Raise_Exception;
37: Close cur_old_ref_values;
38: Return;
39: END IF;

Line 70: IGS_GE_MSG_STACK.ADD;

66: IF IGS_AD_VAL_ACCT.admp_val_ac_closed (
67: new_references.admission_cat,
68: v_message_name) = FALSE THEN
69: Fnd_Message.Set_Name('IGS',v_message_name);
70: IGS_GE_MSG_STACK.ADD;
71: App_Exception.Raise_Exception;
72: END IF;
73: -- Validate the course type closed indicator.
74: IF IGS_AS_VAL_ACOT.crsp_val_cty_closed (

Line 78: IGS_GE_MSG_STACK.ADD;

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

Line 98: IGS_GE_MSG_STACK.ADD;

94: END IF;
95: IF upper(column_name) = 'ADMISSION_CAT' OR column_name is null Then
96: IF new_references.admission_cat <> UPPER(new_references.admission_cat) Then
97: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
98: IGS_GE_MSG_STACK.ADD;
99: App_Exception.Raise_Exception;
100: END IF;
101: END IF;
102: IF upper(column_name) = 'COURSE_TYPE' OR column_name is null Then

Line 105: IGS_GE_MSG_STACK.ADD;

101: END IF;
102: IF upper(column_name) = 'COURSE_TYPE' OR column_name is null Then
103: IF new_references.course_type <> UPPER(new_references.course_type ) Then
104: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception;
107: END IF;
108: END IF;
109: END Check_Constraints;

Line 122: IGS_GE_MSG_STACK.ADD;

118: ELSE
119: IF NOT IGS_AD_CAT_PKG.Get_PK_For_Validation (
120: new_references.admission_cat , 'N' ) THEN
121: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
122: IGS_GE_MSG_STACK.ADD;
123: App_Exception.Raise_Exception;
124: END IF;
125: END IF;
126:

Line 134: IGS_GE_MSG_STACK.ADD;

130: ELSE
131: IF NOT IGS_PS_TYPE_PKG.Get_PK_For_Validation (
132: new_references.course_type ) THEN
133: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
134: IGS_GE_MSG_STACK.ADD;
135: App_Exception.Raise_Exception;
136: END IF;
137: END IF;
138:

Line 182: IGS_GE_MSG_STACK.ADD;

178: Fetch cur_rowid INTO lv_rowid;
179: IF (cur_rowid%FOUND) THEN
180: Close cur_rowid;
181: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACCT_AC_FK');
182: IGS_GE_MSG_STACK.ADD;
183: App_Exception.Raise_Exception;
184: Return;
185: END IF;
186: Close cur_rowid;

Line 221: IGS_GE_MSG_STACK.ADD;

217: IF Get_PK_For_Validation (
218: new_references.admission_cat,
219: new_references.course_type ) THEN
220: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
221: IGS_GE_MSG_STACK.ADD;
222: App_Exception.Raise_Exception;
223: END IF;
224: Check_Constraints;
225: Check_Parent_Existance;

Line 235: IGS_GE_MSG_STACK.ADD;

231: IF Get_PK_For_Validation (
232: new_references.admission_cat,
233: new_references.course_type ) THEN
234: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: END IF;
238: Check_Constraints;
239: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 282: IGS_GE_MSG_STACK.ADD;

278: X_LAST_UPDATE_LOGIN := -1;
279: end if;
280: else
281: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
282: IGS_GE_MSG_STACK.ADD;
283: app_exception.raise_exception;
284: end if;
285:
286: Before_DML(

Line 345: IGS_GE_MSG_STACK.ADD;

341: open c1;
342: fetch c1 into tlinfo;
343: if (c1%notfound) then
344: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
345: IGS_GE_MSG_STACK.ADD;
346: app_exception.raise_exception;
347: close c1;
348: return;
349: end if;