APPS.IGS_PE_GOV_ABRGRESCD_PKG dependencies on APP_EXCEPTION

Line 38: App_Exception.Raise_Exception;

34: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
35: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
36: IGS_GE_MSG_STACK.ADD;
37: Close cur_old_ref_values;
38: App_Exception.Raise_Exception;
39: Return;
40: END IF;
41: Close cur_old_ref_values;
42:

Line 78: App_Exception.Raise_Exception;

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

Line 105: App_Exception.Raise_Exception;

101: column_name is null Then
102: IF new_references.closed_ind NOT IN ( 'Y' , 'N' ) Then
103: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
104: IGS_GE_MSG_STACK.ADD;
105: App_Exception.Raise_Exception;
106: END IF;
107: END IF;
108:
109: IF upper(column_name) = 'GOVT_ABORIG_TORRES_CD' OR

Line 115: App_Exception.Raise_Exception;

111: IF new_references.govt_aborig_torres_cd < 0 OR
112: new_references. govt_aborig_torres_cd > 9 Then
113: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception;
116: END IF;
117: END IF;
118: END Check_Constraints;
119:

Line 189: App_Exception.Raise_Exception;

185: IF Get_PK_For_Validation (
186: new_references.govt_aborig_torres_cd ) THEN
187: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191:
192: Check_Constraints; -- if procedure present
193:

Line 209: App_Exception.Raise_Exception;

205: IF Get_PK_For_Validation (
206: new_references.govt_aborig_torres_cd ) THEN
207: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
208: IGS_GE_MSG_STACK.ADD;
209: App_Exception.Raise_Exception;
210: END IF;
211: Check_Constraints; -- if procedure present
212: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
213:

Line 272: app_exception.raise_exception;

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

Line 341: App_Exception.Raise_Exception;

337: if (c1%notfound) then
338: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
339:
340: close c1;
341: App_Exception.Raise_Exception;
342: return;
343: end if;
344: close c1;
345:

Line 352: app_exception.raise_exception;

348: ) then
349: null;
350: else
351: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
352: app_exception.raise_exception;
353: end if;
354: return;
355: end LOCK_ROW;
356:

Line 384: app_exception.raise_exception;

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