APPS.IGS_OR_UNIT_LOC_PKG dependencies on IGS_GE_MSG_STACK

Line 31: IGS_GE_MSG_STACK.ADD;

27: Open cur_old_ref_values;
28: Fetch cur_old_ref_values INTO old_references;
29: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
30: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
31: IGS_GE_MSG_STACK.ADD;
32: App_Exception.Raise_Exception;
33: Close cur_old_ref_values;
34: Return;
35: END IF;

Line 71: IGS_GE_MSG_STACK.ADD;

67: IF IGS_PS_VAL_UOO.crsp_val_loc_cd (
68: new_references.location_cd,
69: v_message_name) = FALSE THEN
70: Fnd_Message.Set_Name('IGS',v_message_name);
71: IGS_GE_MSG_STACK.ADD;
72: App_Exception.Raise_Exception ;
73: END IF;
74: END IF;
75: END BeforeRowInsertUpdate1;

Line 87: IGS_GE_MSG_STACK.ADD;

83: IF NOT IGS_AD_LOCATION_PKG.Get_PK_For_Validation (
84: new_references.location_cd ,
85: 'N' )THEN
86: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
87: IGS_GE_MSG_STACK.ADD;
88: App_Exception.Raise_Exception;
89:
90: END IF;
91: END IF;

Line 103: IGS_GE_MSG_STACK.ADD;

99: new_references.org_unit_cd,
100: new_references.start_dt
101: )THEN
102: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
103: IGS_GE_MSG_STACK.ADD;
104: App_Exception.Raise_Exception;
105:
106: END IF;
107: END IF;

Line 149: IGS_GE_MSG_STACK.ADD;

145: Fetch cur_rowid INTO lv_rowid;
146: IF (cur_rowid%FOUND) THEN
147: Close cur_rowid;
148: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OUL_LOC_FK');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: Return;
152: END IF;
153: Close cur_rowid;

Line 172: IGS_GE_MSG_STACK.ADD;

168: Fetch cur_rowid INTO lv_rowid;
169: IF (cur_rowid%FOUND) THEN
170: Close cur_rowid;
171: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OUL_OU_FK');
172: IGS_GE_MSG_STACK.ADD;
173: App_Exception.Raise_Exception;
174: Return;
175: END IF;
176: Close cur_rowid;

Line 214: IGS_GE_MSG_STACK.ADD;

210: new_references.start_dt ,
211: new_references.location_cd
212: )THEN
213: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
214: IGS_GE_MSG_STACK.ADD;
215: App_Exception.Raise_Exception;
216:
217: END IF;
218: Check_Parent_Existance;

Line 236: IGS_GE_MSG_STACK.ADD;

232: new_references.start_dt ,
233: new_references.location_cd
234: )THEN
235: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
236: IGS_GE_MSG_STACK.ADD;
237: App_Exception.Raise_Exception;
238:
239: END IF;
240: Check_Constraints ;

Line 291: IGS_GE_MSG_STACK.ADD;

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

Line 408: IGS_GE_MSG_STACK.ADD;

404:
405: IF upper(Column_name) = 'LOCATION_CD' OR COLUMN_NAME IS NULL THEN
406: IF new_references.LOCATION_CD <> upper(new_references.LOCATION_CD) then
407: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
408: IGS_GE_MSG_STACK.ADD;
409: App_Exception.Raise_Exception ;
410: END IF;
411:
412: END IF ;