APPS.IGS_PE_STUP_DATA_EMT_PKG dependencies on IGS_GE_MSG_STACK

Line 50: IGS_GE_MSG_STACK.ADD;

46: Fetch cur_old_ref_values INTO old_references;
47: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
48: Close cur_old_ref_values;
49: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
50: IGS_GE_MSG_STACK.ADD;
51: App_Exception.Raise_Exception;
52: Return;
53: END IF;
54: Close cur_old_ref_values;

Line 106: IGS_GE_MSG_STACK.ADD;

102: IF Upper(Column_Name) = 'REQUIRED_IND' OR
103: Column_Name IS NULL THEN
104: IF NOT (new_references.required_ind IN ('M', 'P', 'N')) THEN
105: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
106: IGS_GE_MSG_STACK.ADD;
107: App_Exception.Raise_Exception;
108: END IF;
109: END IF;
110:

Line 135: IGS_GE_MSG_STACK.ADD;

131: ELSIF NOT Igs_Pe_Person_Types_Pkg.Get_PK_For_Validation (
132: new_references.person_type_code
133: ) THEN
134: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception;
137: END IF;
138:
139: IF (((old_references.data_element = new_references.data_element)) OR

Line 146: IGS_GE_MSG_STACK.ADD;

142: ELSIF NOT Igs_Pe_Data_Element_Pkg.Get_PK_For_Validation (
143: new_references.data_element
144: ) THEN
145: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END IF;
149:
150: END Check_Parent_Existance;

Line 217: IGS_GE_MSG_STACK.ADD;

213: Fetch cur_rowid INTO lv_rowid;
214: IF (cur_rowid%FOUND) THEN
215: Close cur_rowid;
216: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PSDE_PT_FK');
217: IGS_GE_MSG_STACK.ADD;
218: App_Exception.Raise_Exception;
219: Return;
220: END IF;
221: Close cur_rowid;

Line 254: IGS_GE_MSG_STACK.ADD;

250: Fetch cur_rowid INTO lv_rowid;
251: IF (cur_rowid%FOUND) THEN
252: Close cur_rowid;
253: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PSDE_PDE_FK');
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: Return;
257: END IF;
258: Close cur_rowid;

Line 312: IGS_GE_MSG_STACK.ADD;

308: Null;
309: IF Get_Pk_For_Validation(
310: new_references.setup_data_element_id) THEN
311: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
312: IGS_GE_MSG_STACK.ADD;
313: App_Exception.Raise_Exception;
314: END IF;
315: Check_Constraints;
316: Check_Parent_Existance;

Line 330: IGS_GE_MSG_STACK.ADD;

326: -- Call all the procedures related to Before Insert.
327: IF Get_PK_For_Validation (
328: new_references.setup_data_element_id) THEN
329: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: END IF;
333: Check_Constraints;
334: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 417: IGS_GE_MSG_STACK.ADD;

413: X_LAST_UPDATE_LOGIN := -1;
414: end if;
415: else
416: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
417: IGS_GE_MSG_STACK.ADD;
418: app_exception.raise_exception;
419: end if;
420:
421:

Line 509: IGS_GE_MSG_STACK.ADD;

505: open c1;
506: fetch c1 into tlinfo;
507: if (c1%notfound) then
508: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
509: IGS_GE_MSG_STACK.ADD;
510: close c1;
511: app_exception.raise_exception;
512: return;
513: end if;

Line 527: IGS_GE_MSG_STACK.ADD;

523: ) then
524: null;
525: else
526: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
527: IGS_GE_MSG_STACK.ADD;
528: app_exception.raise_exception;
529: end if;
530: return;
531: end LOCK_ROW;

Line 572: IGS_GE_MSG_STACK.ADD;

568: X_LAST_UPDATE_LOGIN := -1;
569: end if;
570: else
571: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
572: IGS_GE_MSG_STACK.ADD;
573: app_exception.raise_exception;
574: end if;
575: Before_DML(
576: p_action=>'UPDATE',