APPS.IGS_AD_CT_HECS_PAYOP_PKG dependencies on APP_EXCEPTION

Line 36: App_Exception.Raise_Exception;

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;
40: Close cur_old_ref_values;

Line 71: App_Exception.Raise_Exception;

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 HECS payment option closed indicator.
74: -- change igs_ad_val_achpo.enrp_val_hpo_closed
75: -- to igs_en_val_scho.enrp_val_hpo_closed

Line 81: App_Exception.Raise_Exception;

77: new_references.hecs_payment_option,
78: v_message_name) = FALSE THEN
79: Fnd_Message.Set_Name('IGS',v_message_name);
80: IGS_GE_MSG_STACK.ADD;
81: App_Exception.Raise_Exception;
82: END IF;
83: END BeforeRowInsert1;
84:
85: PROCEDURE Check_Constraints (

Line 101: App_Exception.Raise_Exception;

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

Line 108: App_Exception.Raise_Exception;

104: IF upper(column_name) = 'HECS_PAYMENT_OPTION' OR column_name is null Then
105: IF new_references.hecs_payment_option <> UPPER(new_references.hecs_payment_option ) Then
106: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
107: IGS_GE_MSG_STACK.ADD;
108: App_Exception.Raise_Exception;
109: END IF;
110: END IF;
111: END Check_Constraints;
112:

Line 124: App_Exception.Raise_Exception;

120: IF NOT IGS_AD_CAT_PKG.Get_PK_For_Validation (
121: new_references.admission_cat , 'N' )THEN
122: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
123: IGS_GE_MSG_STACK.ADD;
124: App_Exception.Raise_Exception;
125: END IF;
126: END IF;
127:
128: IF (((old_references.hecs_payment_option = new_references.hecs_payment_option)) OR

Line 136: App_Exception.Raise_Exception;

132: IF NOT IGS_FI_HECS_PAY_OPTN_PKG.Get_PK_For_Validation (
133: new_references.hecs_payment_option )THEN
134: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception;
137: END IF;
138: END IF;
139:
140: END Check_Parent_Existance;

Line 184: App_Exception.Raise_Exception;

180: IF (cur_rowid%FOUND) THEN
181: Close cur_rowid;
182: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACHPO_AC_FK');
183: IGS_GE_MSG_STACK.ADD;
184: App_Exception.Raise_Exception;
185: Return;
186: END IF;
187: Close cur_rowid;
188:

Line 210: App_Exception.Raise_Exception;

206: IF (cur_rowid%FOUND) THEN
207: Close cur_rowid;
208: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ACHPO_HPO_FK');
209: IGS_GE_MSG_STACK.ADD;
210: App_Exception.Raise_Exception;
211: Return;
212: END IF;
213: Close cur_rowid;
214:

Line 250: App_Exception.Raise_Exception;

246: new_references.admission_cat,
247: new_references.hecs_payment_option ) THEN
248: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
249: IGS_GE_MSG_STACK.ADD;
250: App_Exception.Raise_Exception;
251: END IF;
252: Check_Constraints;
253: Check_Parent_Existance;
254: ELSIF (p_action = 'UPDATE') THEN

Line 264: App_Exception.Raise_Exception;

260: new_references.admission_cat,
261: new_references.hecs_payment_option ) THEN
262: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
263: IGS_GE_MSG_STACK.ADD;
264: App_Exception.Raise_Exception;
265: END IF;
266: Check_Constraints;
267:
268: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 323: app_exception.raise_exception;

319: end if;
320: else
321: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
322: IGS_GE_MSG_STACK.ADD;
323: app_exception.raise_exception;
324: end if;
325:
326: Before_DML(
327: p_action=>'INSERT',

Line 386: app_exception.raise_exception;

382: fetch c1 into tlinfo;
383: if (c1%notfound) then
384: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
385: IGS_GE_MSG_STACK.ADD;
386: app_exception.raise_exception;
387: close c1;
388: return;
389: end if;
390: close c1;