DBA Data[Home] [Help]

APPS.IGS_OR_ORG_ALT_IDS_PKG dependencies on FND_MESSAGE

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

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

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

120: NULL;
121: ELSIF NOT Igs_Or_Org_Alt_Idtyp_Pkg.Get_PK_For_Validation (
122: new_references.org_alternate_id_type
123: ) THEN
124: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: END IF;
128: IF NOT Igs_Lookups_View_Pkg.Get_Pk_For_Validation('ORG_STRUCTURE_TYPE',new_references.org_structure_type) THEN

Line 129: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

125: IGS_GE_MSG_STACK.ADD;
126: App_Exception.Raise_Exception;
127: END IF;
128: IF NOT Igs_Lookups_View_Pkg.Get_Pk_For_Validation('ORG_STRUCTURE_TYPE',new_references.org_structure_type) THEN
129: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
130: IGS_GE_MSG_STACK.ADD;
131: APP_EXCEPTION.RAISE_EXCEPTION;
132: END IF;
133:

Line 136: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

132: END IF;
133:
134: IF new_references.org_structure_type = 'INSTITUTE' THEN
135: IF NOT Igs_Or_Institution_Pkg.Get_Pk_For_Validation(new_references.org_structure_id) THEN
136: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
137: IGS_GE_MSG_STACK.ADD;
138: APP_EXCEPTION.RAISE_EXCEPTION;
139: END IF;
140: ELSIF new_references.org_structure_type = 'LOCATION' THEN

Line 143: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

139: END IF;
140: ELSIF new_references.org_structure_type = 'LOCATION' THEN
141: IF NOT Igs_Ad_Location_Pkg.Get_Pk_For_Validation(new_references.org_structure_id,
142: 'N') THEN
143: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
144: IGS_GE_MSG_STACK.ADD;
145: APP_EXCEPTION.RAISE_EXCEPTION;
146: END IF;
147: ELSIF new_references.org_structure_type = 'ORG_UNIT' THEN

Line 149: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

145: APP_EXCEPTION.RAISE_EXCEPTION;
146: END IF;
147: ELSIF new_references.org_structure_type = 'ORG_UNIT' THEN
148: IF NOT Igs_Or_Unit_Pkg.Get_Pk_For_Str_Validation(new_references.org_structure_id) THEN
149: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
150: IGS_GE_MSG_STACK.ADD;
151: APP_EXCEPTION.RAISE_EXCEPTION;
152: END IF;
153: END IF;

Line 234: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OLI_OAIT_FK');

230: Open cur_rowid;
231: Fetch cur_rowid INTO lv_rowid;
232: IF (cur_rowid%FOUND) THEN
233: Close cur_rowid;
234: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OLI_OAIT_FK');
235: IGS_GE_MSG_STACK.ADD;
236: App_Exception.Raise_Exception;
237: Return;
238: END IF;

Line 271: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OLI_INS_FK');

267: OPEN cur_rowid;
268: FETCH cur_rowid INTO lv_rowid;
269: IF (cur_rowid%FOUND) THEN
270: CLOSE cur_rowid;
271: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OLI_INS_FK');
272: IGS_GE_MSG_STACK.ADD;
273: App_Exception.Raise_Exception;
274: RETURN;
275: END IF;

Line 308: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OLI_OU_FK');

304: OPEN cur_rowid;
305: FETCH cur_rowid INTO lv_rowid;
306: IF (cur_rowid%FOUND) THEN
307: CLOSE cur_rowid;
308: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OLI_OU_FK');
309: IGS_GE_MSG_STACK.ADD;
310: App_Exception.Raise_Exception;
311: RETURN;
312: END IF;

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

369: new_references.org_alternate_id_type,
370: new_references.org_structure_id,
371: new_references.org_structure_type,
372: new_references.start_date) THEN
373: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
374: IGS_GE_MSG_STACK.ADD;
375: App_Exception.Raise_Exception;
376: END IF;
377: Check_Constraints;

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

391: new_references.org_alternate_id_type,
392: new_references.org_structure_id,
393: new_references.org_structure_type,
394: new_references.start_date) THEN
395: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
396: IGS_GE_MSG_STACK.ADD;
397: App_Exception.Raise_Exception;
398: END IF;
399: Check_Constraints;

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

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

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

571: begin
572: open c1;
573: fetch c1 into tlinfo;
574: if (c1%notfound) then
575: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
576: IGS_GE_MSG_STACK.ADD;
577: close c1;
578: app_exception.raise_exception;
579: return;

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

584: AND (X_END_DATE is null)))
585: ) then
586: null;
587: else
588: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
589: IGS_GE_MSG_STACK.ADD;
590: app_exception.raise_exception;
591: end if;
592: return;

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

632: if X_LAST_UPDATE_LOGIN is NULL then
633: X_LAST_UPDATE_LOGIN := -1;
634: end if;
635: else
636: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
637: IGS_GE_MSG_STACK.ADD;
638: app_exception.raise_exception;
639: end if;
640: Before_DML(