DBA Data[Home] [Help]

APPS.IGS_FI_GOV_HEC_PA_OP_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 79: App_Exception.Raise_Exception;

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

Line 86: App_Exception.Raise_Exception;

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

Line 93: App_Exception.Raise_Exception;

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

Line 100: App_Exception.Raise_Exception;

96: IF ((UPPER (column_name) = 'S_HECS_PAYMENT_TYPE') OR (column_name IS NULL)) THEN
97: IF (new_references.s_hecs_payment_type <> UPPER (new_references.s_hecs_payment_type)) THEN
98: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
99: IGS_GE_MSG_STACK.ADD;
100: App_Exception.Raise_Exception;
101: END IF;
102: END IF;
103: IF ((UPPER (column_name) = 'ALLOW_DISCOUNT_IND') OR (column_name IS NULL)) THEN
104: IF (new_references.allow_discount_ind <> UPPER (new_references.allow_discount_ind)) THEN

Line 107: App_Exception.Raise_Exception;

103: IF ((UPPER (column_name) = 'ALLOW_DISCOUNT_IND') OR (column_name IS NULL)) THEN
104: IF (new_references.allow_discount_ind <> UPPER (new_references.allow_discount_ind)) THEN
105: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109: END IF;
110: END Check_Constraints;
111: PROCEDURE Check_Parent_Existance AS

Line 123: App_Exception.Raise_Exception;

119: new_references.s_hecs_payment_type
120: ) 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: END Check_Parent_Existance;
127: PROCEDURE Check_Child_Existance AS

Line 171: App_Exception.Raise_Exception;

167: IF (cur_rowid%FOUND) THEN
168: Close cur_rowid;
169: Fnd_Message.Set_Name ('IGS', 'IGS_FI_GHPO_SHPT_FK');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: Return;
173: END IF;
174: Close cur_rowid;
175: END GET_FK_IGS_LOOKUPS_VIEW ;

Line 212: App_Exception.Raise_Exception;

208: new_references.govt_hecs_payment_option
209: )) THEN
210: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
211: IGS_GE_MSG_STACK.ADD;
212: App_Exception.Raise_Exception;
213: END IF;
214: Check_Constraints;
215: Check_Parent_Existance;
216: ELSIF (p_action = 'UPDATE') THEN

Line 229: App_Exception.Raise_Exception;

225: new_references.govt_hecs_payment_option
226: )) THEN
227: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
228: IGS_GE_MSG_STACK.ADD;
229: App_Exception.Raise_Exception;
230: END IF;
231: Check_Constraints;
232: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
233: Check_Constraints;

Line 269: app_exception.raise_exception;

265: end if;
266: else
267: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
268: IGS_GE_MSG_STACK.ADD;
269: app_exception.raise_exception;
270: end if;
271: Before_DML(
272: p_action=>'INSERT',
273: x_rowid=>X_ROWID,

Line 340: app_exception.raise_exception;

336: if (c1%notfound) then
337: close c1;
338: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
339: IGS_GE_MSG_STACK.ADD;
340: app_exception.raise_exception;
341: return;
342: end if;
343: close c1;
344: if ( (tlinfo.DESCRIPTION = X_DESCRIPTION)

Line 353: app_exception.raise_exception;

349: null;
350: else
351: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
352: IGS_GE_MSG_STACK.ADD;
353: app_exception.raise_exception;
354: end if;
355: return;
356: end LOCK_ROW;
357: procedure UPDATE_ROW (

Line 386: app_exception.raise_exception;

382: end if;
383: else
384: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
385: IGS_GE_MSG_STACK.ADD;
386: app_exception.raise_exception;
387: end if;
388: Before_DML(
389: p_action=>'UPDATE',
390: x_rowid=>X_ROWID,