APPS.IGS_PE_SUBURB_POSTCD_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 80: App_Exception.Raise_Exception;

76: old_references.postcode,
77: v_message_name) = FALSE THEN
78: Fnd_Message.Set_Name('IGS', v_message_name);
79: IGS_GE_MSG_STACK.ADD;
80: App_Exception.Raise_Exception;
81: END IF;
82:
83:
84: END BeforeRowDelete1;

Line 106: App_Exception.Raise_Exception;

102: column_name is null Then
103: IF new_references.postcode < 0 OR new_references.postcode > 9999 Then
104: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception;
107: END IF;
108: END IF;
109: IF upper(column_name) = 'CLOSED_IND' OR
110: column_name is null Then

Line 114: App_Exception.Raise_Exception;

110: column_name is null Then
111: IF new_references.closed_ind NOT IN ( 'Y' , 'N' )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:
118: END Check_Constraints;

Line 208: App_Exception.Raise_Exception;

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

Line 228: App_Exception.Raise_Exception;

224: IF Get_PK_For_Validation (
225: new_references.postcode ) THEN
226: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
227: IGS_GE_MSG_STACK.ADD;
228: App_Exception.Raise_Exception;
229: END IF;
230:
231: Check_Constraints; -- if procedure present
232: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 294: app_exception.raise_exception;

290: end if;
291: else
292: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
293: IGS_GE_MSG_STACK.ADD;
294: app_exception.raise_exception;
295: end if;
296: --
297: Before_DML(
298: p_action=>'INSERT',

Line 366: app_exception.raise_exception;

362: if (c1%notfound) then
363: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
364:
365: close c1;
366: app_exception.raise_exception;
367: return;
368: end if;
369: close c1;
370:

Line 377: app_exception.raise_exception;

373: ) then
374: null;
375: else
376: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
377: app_exception.raise_exception;
378: end if;
379: return;
380: end LOCK_ROW;
381:

Line 409: app_exception.raise_exception;

405: end if;
406: else
407: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
408: IGS_GE_MSG_STACK.ADD;
409: app_exception.raise_exception;
410: end if;
411: --
412: Before_DML(
413: p_action=>'UPDATE',