DBA Data[Home] [Help]

APPS.IGS_PE_PERSON_ID_TYP_PKG dependencies on FND_MESSAGE

Line 73: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

69: Open cur_old_ref_values;
70: Fetch cur_old_ref_values INTO old_references;
71: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
72: Close cur_old_ref_values;
73: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
74: IGS_GE_MSG_STACK.ADD;
75: App_Exception.Raise_Exception;
76: Return;
77: END IF;

Line 131: Fnd_Message.Set_Name('IGS', v_message_name);

127: (NVL(old_references.institution_cd, 'NULL') <> new_references.institution_cd) THEN
128: IF IGS_EN_VAL_PIT.enrp_val_pit_inst_cd (
129: new_references.institution_cd,
130: v_message_name) = FALSE THEN
131: Fnd_Message.Set_Name('IGS', v_message_name);
132: IGS_GE_MSG_STACK.ADD;
133: App_Exception.Raise_Exception;
134: END IF;
135: END IF;

Line 177: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

173: -- The following code checks for check constraints on the Columns.
174: IF Upper(Column_Name) = 'PREFERRED_IND' OR
175: Column_Name IS NULL THEN
176: IF NOT (new_references.preferred_ind IN ('Y', 'N')) THEN
177: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
178: IGS_GE_MSG_STACK.ADD;
179: App_Exception.Raise_Exception;
180: END IF;
181: END IF;

Line 187: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

183: -- The following code checks for check constraints on the Columns.
184: IF Upper(Column_Name) = 'UNIQUE_IND' OR
185: Column_Name IS NULL THEN
186: IF NOT (new_references.unique_ind IN ('N', 'Y')) THEN
187: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
188: IGS_GE_MSG_STACK.ADD;
189: App_Exception.Raise_Exception;
190: END IF;
191: END IF;

Line 197: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

193:
194: IF Upper(Column_Name) = 'REGION_IND' OR
195: Column_Name IS NULL THEN
196: IF NOT (new_references.region_ind IN ('N', 'Y')) THEN
197: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: END IF;

Line 206: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

202:
203: IF UPPER(Column_Name) = 'PERSON_ID_TYPE' OR
204: Column_Name IS NULL THEN
205: IF new_references.PERSON_ID_TYPE <> UPPER(new_references.person_id_type) THEN
206: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
207: IGS_GE_MSG_STACK.ADD;
208: App_Exception.Raise_Exception;
209: END IF;
210: END IF;

Line 215: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');

211:
212: IF UPPER(Column_Name) = 'S_PERSON_ID_TYPE' OR
213: Column_Name IS NULL THEN
214: IF new_references.S_PERSON_ID_TYPE <> UPPER(new_references.s_person_id_type) THEN
215: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
216: IGS_GE_MSG_STACK.ADD;
217: App_Exception.Raise_Exception;
218: END IF;
219: END IF;

Line 246: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

242: ELSE
243:
244: IF NOT IGS_OR_INSTITUTION_PKG.Get_PK_For_Validation (
245: new_references.institution_cd) THEN
246: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
247: IGS_GE_MSG_STACK.ADD;
248: IGS_GE_MSG_STACK.ADD;
249: App_Exception.Raise_Exception;
250: END IF;

Line 258: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

254: NULL;
255: ELSE
256: IF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation (
257: 'PERSON_ID_TYPE',new_references.s_person_id_type) THEN
258: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
259: IGS_GE_MSG_STACK.ADD;
260: App_Exception.Raise_Exception;
261: END IF;
262:

Line 365: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PIT_INS_FK');

361: BEGIN
362: Open cur_rowid;
363: Fetch cur_rowid INTO lv_rowid;
364: IF (cur_rowid%FOUND) THEN
365: Fnd_Message.Set_Name ('IGS', 'IGS_PE_PIT_INS_FK');
366: IGS_GE_MSG_STACK.ADD;
367: Close cur_rowid;
368: App_Exception.Raise_Exception;
369: Return;

Line 449: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

445: p_updating => FALSE ,
446: p_deleting => FALSE);
447: IF Get_PK_For_Validation (
448: new_references.person_id_type ) THEN
449: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
450: IGS_GE_MSG_STACK.ADD;
451: App_Exception.Raise_Exception;
452: END IF;
453:

Line 468: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

464:
465: ELSIF (p_action = 'VALIDATE_INSERT') THEN
466: IF Get_PK_For_Validation (
467: new_references.person_id_type ) THEN
468: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
469: IGS_GE_MSG_STACK.ADD;
470: App_Exception.Raise_Exception;
471: END IF;
472:

Line 554: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

550: if X_LAST_UPDATE_LOGIN is NULL then
551: X_LAST_UPDATE_LOGIN := -1;
552: end if;
553: else
554: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
555: IGS_GE_MSG_STACK.ADD;
556: app_exception.raise_exception;
557: end if;
558: Before_DML(

Line 656: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

652: begin
653: open c1;
654: fetch c1 into tlinfo;
655: if (c1%notfound) then
656: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
657: IGS_GE_MSG_STACK.ADD;
658: close c1;
659: app_exception.raise_exception;
660: return;

Line 689: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

685:
686: )then
687: null;
688: else
689: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
690: IGS_GE_MSG_STACK.ADD;
691: app_exception.raise_exception;
692: end if;
693: return;

Line 738: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

734: if X_LAST_UPDATE_LOGIN is NULL then
735: X_LAST_UPDATE_LOGIN := -1;
736: end if;
737: else
738: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
739: IGS_GE_MSG_STACK.ADD;
740: app_exception.raise_exception;
741: end if;
742: Before_DML(