APPS.IGS_PE_SUBURB_POSTCD_PKG dependencies on IGS_GE_MSG_STACK

Line 36: IGS_GE_MSG_STACK.ADD;

32: Open cur_old_ref_values;
33: Fetch cur_old_ref_values INTO old_references;
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;

Line 79: IGS_GE_MSG_STACK.ADD;

75: IF IGS_EN_VAL_SP.enrp_val_sp_del (
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:

Line 105: IGS_GE_MSG_STACK.ADD;

101: IF upper(column_name) = 'POSTCODE' OR
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

Line 113: IGS_GE_MSG_STACK.ADD;

109: IF upper(column_name) = 'CLOSED_IND' OR
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:

Line 207: IGS_GE_MSG_STACK.ADD;

203: BeforeRowDelete1 ( p_inserting => TRUE );
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

Line 227: IGS_GE_MSG_STACK.ADD;

223: ELSIF (p_action = 'VALIDATE_INSERT') THEN
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

Line 293: IGS_GE_MSG_STACK.ADD;

289: X_LAST_UPDATE_LOGIN := -1;
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(

Line 408: IGS_GE_MSG_STACK.ADD;

404: X_LAST_UPDATE_LOGIN := -1;
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(