APPS.IGS_PE_GOV_COUNTRYCD_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_COUNTRY_CD' OR

Line 114: App_Exception.Raise_Exception;

110: column_name is null Then
111: IF new_references.govt_country_cd <> UPPER(new_references.govt_country_cd) Then
112: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
113: IGS_GE_MSG_STACK.ADD;
114: App_Exception.Raise_Exception;
115: END IF;
116: END IF;
117: END Check_Constraints;
118:

Line 187: App_Exception.Raise_Exception;

183: IF Get_PK_For_Validation (
184: new_references.govt_country_cd ) THEN
185: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception;
188: END IF;
189: Check_Constraints; -- if procedure present
190:
191: ELSIF (p_action = 'UPDATE') THEN

Line 206: App_Exception.Raise_Exception;

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

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 338: App_Exception.Raise_Exception;

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

Line 349: app_exception.raise_exception;

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

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,