DBA Data[Home] [Help]

APPS.IGS_AD_ROOM_PKG dependencies on FND_MESSAGE

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

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

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

105: -- The following code checks for check constraints on the Columns.
106: IF Upper(Column_Name) = 'CLOSED_IND' OR
107: Column_Name IS NULL THEN
108: IF NOT (new_references.closed_ind IN ('Y', 'N')) THEN
109: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113: END IF;

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

131: IF Get_Uk_For_Validation (
132: new_references.building_id
133: ,new_references.room_cd
134: ) THEN
135: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
136: IGS_GE_MSG_STACK.ADD;
137: app_exception.raise_exception;
138: END IF;
139: END Check_Uniqueness ;

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

156: NULL;
157: ELSIF NOT Igs_Ad_Building_Pkg.Get_PK_For_Validation (
158: new_references.building_id ,
159: 'N') THEN
160: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
161: IGS_GE_MSG_STACK.ADD;
162: App_Exception.Raise_Exception;
163: END IF;
164: if not IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation ( 'PRIMARY_USE',

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

162: App_Exception.Raise_Exception;
163: END IF;
164: if not IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation ( 'PRIMARY_USE',
165: new_references.primary_use_cd ) THEN
166: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
167: IGS_GE_MSG_STACK.ADD;
168: App_Exception.Raise_Exception;
169: END IF;
170:

Line 316: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ROOM_BLDG_FK');

312: Open cur_rowid;
313: Fetch cur_rowid INTO lv_rowid;
314: IF (cur_rowid%FOUND) THEN
315: Close cur_rowid;
316: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ROOM_BLDG_FK');
317: IGS_GE_MSG_STACK.ADD;
318: App_Exception.Raise_Exception;
319: Return;
320: END IF;

Line 379: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

375: -- Call all the procedures related to Before Insert.
376: Null;
377: IF Get_Pk_For_Validation(
378: new_references.room_id) THEN
379: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
380: IGS_GE_MSG_STACK.ADD;
381: App_Exception.Raise_Exception;
382: END IF;
383: Check_Uniqueness;

Line 400: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

396: ELSIF (p_action = 'VALIDATE_INSERT') THEN
397: -- Call all the procedures related to Before Insert.
398: IF Get_PK_For_Validation (
399: new_references.room_id) THEN
400: Fnd_Message.Set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
401: IGS_GE_MSG_STACK.ADD;
402: App_Exception.Raise_Exception;
403: END IF;
404: Check_Uniqueness;

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

490: if X_LAST_UPDATE_LOGIN is NULL then
491: X_LAST_UPDATE_LOGIN := -1;
492: end if;
493: else
494: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
495: IGS_GE_MSG_STACK.ADD;
496: app_exception.raise_exception;
497: end if;
498:

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

588: begin
589: open c1;
590: fetch c1 into tlinfo;
591: if (c1%notfound) then
592: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
593: IGS_GE_MSG_STACK.ADD;
594: close c1;
595: app_exception.raise_exception;
596: return;

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

604: AND (tlinfo.CLOSED_IND = X_CLOSED_IND)
605: ) then
606: null;
607: else
608: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
609: IGS_GE_MSG_STACK.ADD;
610: app_exception.raise_exception;
611: end if;
612: return;

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

651: if X_LAST_UPDATE_LOGIN is NULL then
652: X_LAST_UPDATE_LOGIN := -1;
653: end if;
654: else
655: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
656: IGS_GE_MSG_STACK.ADD;
657: app_exception.raise_exception;
658: end if;
659: Before_DML(