APPS.IGS_FI_HECS_PAY_OPTN_PKG dependencies on APP_EXCEPTION

Line 34: App_Exception.Raise_Exception;

30: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
31: Close cur_old_ref_values;
32: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
33: IGS_GE_MSG_STACK.ADD;
34: App_Exception.Raise_Exception;
35: Return;
36: END IF;
37: Close cur_old_ref_values;
38: -- Populate New Values.

Line 77: App_Exception.Raise_Exception;

73: IF ((UPPER (column_name) = 'CLOSED_IND') OR (column_name IS NULL)) THEN
74: IF (new_references.closed_ind NOT IN ('Y', 'N')) THEN
75: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
76: IGS_GE_MSG_STACK.ADD;
77: App_Exception.Raise_Exception;
78: END IF;
79: END IF;
80: IF ((UPPER (column_name) = 'EXPIRE_AFTR_ACDMC_PERD_IND') OR (column_name IS NULL)) THEN
81: IF (new_references.expire_aftr_acdmc_perd_ind NOT IN ('Y', 'N')) THEN

Line 84: App_Exception.Raise_Exception;

80: IF ((UPPER (column_name) = 'EXPIRE_AFTR_ACDMC_PERD_IND') OR (column_name IS NULL)) THEN
81: IF (new_references.expire_aftr_acdmc_perd_ind NOT IN ('Y', 'N')) THEN
82: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
83: IGS_GE_MSG_STACK.ADD;
84: App_Exception.Raise_Exception;
85: END IF;
86: END IF;
87: IF ((UPPER (column_name) = 'GOVT_HECS_PAYMENT_OPTION') OR (column_name IS NULL)) THEN
88: IF (new_references.govt_hecs_payment_option <> UPPER (new_references.govt_hecs_payment_option)) THEN

Line 91: App_Exception.Raise_Exception;

87: IF ((UPPER (column_name) = 'GOVT_HECS_PAYMENT_OPTION') OR (column_name IS NULL)) THEN
88: IF (new_references.govt_hecs_payment_option <> UPPER (new_references.govt_hecs_payment_option)) THEN
89: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
90: IGS_GE_MSG_STACK.ADD;
91: App_Exception.Raise_Exception;
92: END IF;
93: END IF;
94: IF ((UPPER (column_name) = 'HECS_PAYMENT_OPTION') OR (column_name IS NULL)) THEN
95: IF (new_references.hecs_payment_option <> UPPER (new_references.hecs_payment_option)) THEN

Line 98: App_Exception.Raise_Exception;

94: IF ((UPPER (column_name) = 'HECS_PAYMENT_OPTION') OR (column_name IS NULL)) THEN
95: IF (new_references.hecs_payment_option <> UPPER (new_references.hecs_payment_option)) THEN
96: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
97: IGS_GE_MSG_STACK.ADD;
98: App_Exception.Raise_Exception;
99: END IF;
100: END IF;
101: END;
102: PROCEDURE Check_Parent_Existance AS

Line 113: App_Exception.Raise_Exception;

109: new_references.govt_hecs_payment_option
110: ) THEN
111: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception;
114: END IF;
115: END IF;
116: END Check_Parent_Existance;
117: PROCEDURE Check_Child_Existance AS

Line 164: App_Exception.Raise_Exception;

160: IF (cur_rowid%FOUND) THEN
161: Close cur_rowid;
162: Fnd_Message.Set_Name ('IGS', 'IGS_FI_HPO_GHPO_FK');
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: Return;
166: END IF;
167: Close cur_rowid;
168: END GET_FK_IGS_FI_GOV_HEC_PA_OP;

Line 205: App_Exception.Raise_Exception;

201: new_references.hecs_payment_option
202: )) THEN
203: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
204: IGS_GE_MSG_STACK.ADD;
205: App_Exception.Raise_Exception;
206: END IF;
207: Check_Constraints;
208: Check_Parent_Existance;
209: ELSIF (p_action = 'UPDATE') THEN

Line 222: App_Exception.Raise_Exception;

218: new_references.hecs_payment_option
219: )) 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: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
226: Check_Constraints;

Line 262: app_exception.raise_exception;

258: end if;
259: else
260: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
261: IGS_GE_MSG_STACK.ADD;
262: app_exception.raise_exception;
263: end if;
264: Before_DML(
265: p_action=>'INSERT',
266: x_rowid=>X_ROWID,

Line 333: app_exception.raise_exception;

329: if (c1%notfound) then
330: close c1;
331: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
332: IGS_GE_MSG_STACK.ADD;
333: app_exception.raise_exception;
334: return;
335: end if;
336: close c1;
337: if ( ((tlinfo.GOVT_HECS_PAYMENT_OPTION = X_GOVT_HECS_PAYMENT_OPTION)

Line 348: app_exception.raise_exception;

344: null;
345: else
346: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
347: IGS_GE_MSG_STACK.ADD;
348: app_exception.raise_exception;
349: end if;
350: return;
351: end LOCK_ROW;
352: procedure UPDATE_ROW (

Line 381: app_exception.raise_exception;

377: end if;
378: else
379: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
380: IGS_GE_MSG_STACK.ADD;
381: app_exception.raise_exception;
382: end if;
383: Before_DML(
384: p_action=>'UPDATE',
385: x_rowid=>X_ROWID,