APPS.IGS_PE_PERS_RELATION_PKG dependencies on IGS_GE_MSG_STACK

Line 35: IGS_GE_MSG_STACK.ADD;

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

Line 78: IGS_GE_MSG_STACK.ADD;

74: IF upper(column_name) = 'PERSON_RELATION_TYPE' OR
75: column_name is null Then
76: IF new_references.person_relation_type <>UPPER(new_references.person_relation_type )Then
77: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
78: IGS_GE_MSG_STACK.ADD;
79: App_Exception.Raise_Exception;
80: END IF;
81: END IF;
82:

Line 95: IGS_GE_MSG_STACK.ADD;

91:
92: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
93: new_references.person_id) THEN
94: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
95: IGS_GE_MSG_STACK.ADD;
96: App_Exception.Raise_Exception;
97: END IF;
98: END IF;
99:

Line 107: IGS_GE_MSG_STACK.ADD;

103: ELSE
104: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
105: new_references.person_id_also_related_to ) THEN
106: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
107: IGS_GE_MSG_STACK.ADD;
108: App_Exception.Raise_Exception;
109: END IF;
110: END IF;
111:

Line 120: IGS_GE_MSG_STACK.ADD;

116:
117: IF NOT IGS_PE_PERS_RELN_TYP_PKG.Get_PK_For_Validation (
118: new_references.person_relation_type ) THEN
119: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
120: IGS_GE_MSG_STACK.ADD;
121: App_Exception.Raise_Exception;
122: END IF;
123: END IF;
124:

Line 176: IGS_GE_MSG_STACK.ADD;

172: Open cur_rowid;
173: Fetch cur_rowid INTO lv_rowid;
174: IF (cur_rowid%FOUND) THEN
175: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PR_PE_FK');
176: IGS_GE_MSG_STACK.ADD;
177: Close cur_rowid;
178: App_Exception.Raise_Exception;
179: Return;
180: END IF;

Line 204: IGS_GE_MSG_STACK.ADD;

200: Open cur_rowid;
201: Fetch cur_rowid INTO lv_rowid;
202: IF (cur_rowid%FOUND) THEN
203: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PR_PRT_FK');
204: IGS_GE_MSG_STACK.ADD;
205: Close cur_rowid;
206: App_Exception.Raise_Exception;
207: Return;
208: END IF;

Line 249: IGS_GE_MSG_STACK.ADD;

245: new_references.person_id_also_related_to ,
246: new_references.person_relation_type
247: ) THEN
248: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
249: IGS_GE_MSG_STACK.ADD;
250: App_Exception.Raise_Exception;
251: END IF;
252:
253: Check_Constraints; -- if procedure present

Line 272: IGS_GE_MSG_STACK.ADD;

268: new_references.person_id ,
269: new_references.person_id_also_related_to ,
270: new_references.person_relation_type ) THEN
271: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
272: IGS_GE_MSG_STACK.ADD;
273: App_Exception.Raise_Exception;
274: END IF;
275:
276: Check_Constraints; -- if procedure present

Line 337: IGS_GE_MSG_STACK.ADD;

333: X_LAST_UPDATE_LOGIN := -1;
334: end if;
335: else
336: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
337: IGS_GE_MSG_STACK.ADD;
338: app_exception.raise_exception;
339: end if;
340:
341: Before_DML(

Line 398: igs_ge_msg_stack.add;

394: WHEN OTHERS THEN
395: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
396: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
397: fnd_message.set_token ('ERR_CD', SQLCODE);
398: igs_ge_msg_stack.add;
399: igs_sc_gen_001.unset_ctx('R');
400: app_exception.raise_exception;
401: ELSE
402: igs_sc_gen_001.unset_ctx('R');

Line 452: igs_ge_msg_stack.add;

448: delete from IGS_PE_PERS_RELATION
449: where ROWID = X_ROWID;
450: if (sql%notfound) then
451: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
452: igs_ge_msg_stack.add;
453: igs_sc_gen_001.unset_ctx('R');
454: app_exception.raise_exception;
455: end if;
456: IF (x_mode = 'S') THEN