APPS.IGS_PE_GOV_COUNTRYCD_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 77: IGS_GE_MSG_STACK.ADD;

73: new_references.govt_country_cd,
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:

Line 104: IGS_GE_MSG_STACK.ADD;

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

Line 113: IGS_GE_MSG_STACK.ADD;

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

Line 186: IGS_GE_MSG_STACK.ADD;

182: BeforeRowInsertUpdate1 ( p_inserting => TRUE );
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:

Line 205: IGS_GE_MSG_STACK.ADD;

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

Line 268: IGS_GE_MSG_STACK.ADD;

264: X_LAST_UPDATE_LOGIN := -1;
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',

Line 380: IGS_GE_MSG_STACK.ADD;

376: X_LAST_UPDATE_LOGIN := -1;
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',