DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_LOCATION_PKG dependencies on FND_MESSAGE

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

45: Open cur_old_ref_values;
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;

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

118: ,new_references.unit_code
119: ,new_references.unit_version_number
120: ,new_references.building_id
121: ) THEN
122: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
123: IGS_GE_MSG_STACK.ADD;
124: app_exception.raise_exception;
125: END IF;
126: END Check_Uniqueness ;

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

144: ELSIF NOT Igs_Ad_Location_Pkg.Get_PK_For_Validation (
145: new_references.location_code ,
146: 'N'
147: ) THEN
148: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
149: IGS_GE_MSG_STACK.ADD;
150: App_Exception.Raise_Exception;
151: END IF;
152:

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

158: ELSIF NOT Igs_Ps_Unit_Ver_Pkg.Get_PK_For_Validation (
159: new_references.unit_code,
160: new_references.unit_version_number
161: ) THEN
162: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: END IF;
166:

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

170: ELSIF NOT Igs_Ad_Room_Pkg.Get_PK_For_Validation (
171: new_references.room_id ,
172: 'N'
173: ) THEN
174: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END IF;
178:

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

182: ELSIF NOT Igs_Ad_Building_Pkg.Get_PK_For_Validation (
183: new_references.building_id ,
184: 'N'
185: ) THEN
186: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
187: IGS_GE_MSG_STACK.ADD;
188: App_Exception.Raise_Exception;
189: END IF;
190:

Line 301: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UL_LOC_FK');

297: Open cur_rowid;
298: Fetch cur_rowid INTO lv_rowid;
299: IF (cur_rowid%FOUND) THEN
300: Close cur_rowid;
301: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UL_LOC_FK');
302: IGS_GE_MSG_STACK.ADD;
303: App_Exception.Raise_Exception;
304: Return;
305: END IF;

Line 340: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UL_UV_FK');

336: Open cur_rowid;
337: Fetch cur_rowid INTO lv_rowid;
338: IF (cur_rowid%FOUND) THEN
339: Close cur_rowid;
340: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UL_UV_FK');
341: IGS_GE_MSG_STACK.ADD;
342: App_Exception.Raise_Exception;
343: Return;
344: END IF;

Line 377: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UL_ROOM_FK');

373: Open cur_rowid;
374: Fetch cur_rowid INTO lv_rowid;
375: IF (cur_rowid%FOUND) THEN
376: Close cur_rowid;
377: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UL_ROOM_FK');
378: IGS_GE_MSG_STACK.ADD;
379: App_Exception.Raise_Exception;
380: Return;
381: END IF;

Line 414: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UL_BLDG_FK');

410: Open cur_rowid;
411: Fetch cur_rowid INTO lv_rowid;
412: IF (cur_rowid%FOUND) THEN
413: Close cur_rowid;
414: Fnd_Message.Set_Name ('IGS', 'IGS_PS_UL_BLDG_FK');
415: IGS_GE_MSG_STACK.ADD;
416: App_Exception.Raise_Exception;
417: Return;
418: END IF;

Line 472: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

468: -- Call all the procedures related to Before Insert.
469: Null;
470: IF Get_Pk_For_Validation(
471: new_references.unit_location_id) THEN
472: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
473: IGS_GE_MSG_STACK.ADD;
474: App_Exception.Raise_Exception;
475: END IF;
476: Check_Uniqueness;

Line 492: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

488: ELSIF (p_action = 'VALIDATE_INSERT') THEN
489: -- Call all the procedures related to Before Insert.
490: IF Get_PK_For_Validation (
491: new_references.unit_location_id) THEN
492: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
493: IGS_GE_MSG_STACK.ADD;
494: App_Exception.Raise_Exception;
495: END IF;
496: Check_Uniqueness;

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

577: if X_LAST_UPDATE_LOGIN is NULL then
578: X_LAST_UPDATE_LOGIN := -1;
579: end if;
580: else
581: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
582: IGS_GE_MSG_STACK.ADD;
583: app_exception.raise_exception;
584: end if;
585: Select IGS_PS_UNIT_LOCATION_S.NEXTVAL into x_unit_location_id from dual;

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

666: begin
667: open c1;
668: fetch c1 into tlinfo;
669: if (c1%notfound) then
670: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
671: IGS_GE_MSG_STACK.ADD;
672: close c1;
673: app_exception.raise_exception;
674: return;

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

685: AND (X_ROOM_ID is null)))
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 734: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');

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