DBA Data[Home] [Help]

APPS.IGS_FI_GV_DSP_HEC_CN_PKG dependencies on APP_EXCEPTION

Line 33: App_Exception.Raise_Exception;

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

Line 73: App_Exception.Raise_Exception;

69: new_references.end_dt,
70: v_message_name) = FALSE THEN
71: Fnd_Message.Set_Name('IGS',v_message_name);
72: IGS_GE_MSG_STACK.ADD;
73: App_Exception.Raise_Exception;
74: END IF;
75: END IF;
76: IF IGS_ST_VAL_GDHC.stap_val_gdhc_gd(
77: new_references.govt_discipline_group_cd,

Line 81: App_Exception.Raise_Exception;

77: new_references.govt_discipline_group_cd,
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 IF;
84: END BeforeRowInsertUpdate1;
85: -- Trigger description :-

Line 104: App_Exception.Raise_Exception;

100: new_references.end_dt,
101: v_message_name) = FALSE THEN
102: Fnd_Message.Set_Name('IGS',v_message_name);
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105: END IF;
106: IF new_references.end_dt IS NULL THEN
107: IF IGS_ST_VAL_GDHC.stap_val_gdhc_open (
108: new_references.govt_discipline_group_cd,

Line 113: App_Exception.Raise_Exception;

109: new_references.start_dt,
110: v_message_name) = FALSE THEN
111: Fnd_Message.Set_Name('IGS',v_message_name);
112: IGS_GE_MSG_STACK.ADD;
113: App_Exception.Raise_Exception;
114: END IF;
115: END IF;
116: END IF;
117: END AfterStmtInsertUpdate3;

Line 132: App_Exception.Raise_Exception;

128: IF ((UPPER (column_name) = 'GOVT_DISCIPLINE_GROUP_CD') OR (column_name IS NULL)) THEN
129: IF (new_references.govt_discipline_group_cd <> UPPER (new_references.govt_discipline_group_cd)) THEN
130: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: END IF;
134: END IF;
135: END Check_Constraints;
136: PROCEDURE Check_Uniqueness AS

Line 144: App_Exception.Raise_Exception;

140: new_references.start_dt
141: )) THEN
142: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
143: IGS_GE_MSG_STACK.ADD;
144: App_Exception.Raise_Exception;
145: END IF;
146: END Check_Uniqueness;
147: PROCEDURE Check_Parent_Existance AS
148: BEGIN

Line 158: App_Exception.Raise_Exception;

154: new_references.govt_discipline_group_cd
155: ) THEN
156: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
159: END IF;
160: END IF;
161: IF (((old_references.govt_hecs_cntrbtn_band = new_references.govt_hecs_cntrbtn_band)) OR
162: ((new_references.govt_hecs_cntrbtn_band IS NULL))) THEN

Line 170: App_Exception.Raise_Exception;

166: new_references.govt_hecs_cntrbtn_band
167: ) THEN
168: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
169: IGS_GE_MSG_STACK.ADD;
170: App_Exception.Raise_Exception;
171: END IF;
172: END IF;
173: END Check_Parent_Existance;
174: FUNCTION Get_PK_For_Validation (

Line 236: App_Exception.Raise_Exception;

232: IF (cur_rowid%FOUND) THEN
233: Close cur_rowid;
234: Fnd_Message.Set_Name ('IGS', 'IGS_FI_GDHC_GD_FK');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: Return;
238: END IF;
239: Close cur_rowid;
240: END GET_FK_IGS_PS_GOVT_DSCP;

Line 256: App_Exception.Raise_Exception;

252: IF (cur_rowid%FOUND) THEN
253: Close cur_rowid;
254: Fnd_Message.Set_Name ('IGS', 'IGS_FI_GDHC_GHC_FK');
255: IGS_GE_MSG_STACK.ADD;
256: App_Exception.Raise_Exception;
257: Return;
258: END IF;
259: Close cur_rowid;
260: END GET_FK_IGS_FI_GOVT_HEC_CNTB;

Line 298: App_Exception.Raise_Exception;

294: new_references.start_dt
295: )) THEN
296: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
297: IGS_GE_MSG_STACK.ADD;
298: App_Exception.Raise_Exception;
299: END IF;
300: Check_Uniqueness;
301: Check_Constraints;
302: Check_Parent_Existance;

Line 320: App_Exception.Raise_Exception;

316: new_references.start_dt
317: )) THEN
318: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
319: IGS_GE_MSG_STACK.ADD;
320: App_Exception.Raise_Exception;
321: END IF;
322: Check_Uniqueness;
323: Check_Constraints;
324: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 375: app_exception.raise_exception;

371: end if;
372: else
373: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
374: IGS_GE_MSG_STACK.ADD;
375: app_exception.raise_exception;
376: end if;
377: Before_DML(
378: p_action=>'INSERT',
379: x_rowid=>X_ROWID,

Line 443: app_exception.raise_exception;

439: if (c1%notfound) then
440: close c1;
441: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
442: IGS_GE_MSG_STACK.ADD;
443: app_exception.raise_exception;
444: return;
445: end if;
446: close c1;
447: if ( ((tlinfo.END_DT = X_END_DT)

Line 455: app_exception.raise_exception;

451: null;
452: else
453: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
454: IGS_GE_MSG_STACK.ADD;
455: app_exception.raise_exception;
456: end if;
457: return;
458: end LOCK_ROW;
459: procedure UPDATE_ROW (

Line 487: app_exception.raise_exception;

483: end if;
484: else
485: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
486: IGS_GE_MSG_STACK.ADD;
487: app_exception.raise_exception;
488: end if;
489: Before_DML(
490: p_action=>'UPDATE',
491: x_rowid=>X_ROWID,