DBA Data[Home] [Help]

APPS.IGS_OR_ORG_NOTES_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_Note_Type_Pkg.Get_PK_For_Validation (
122: new_references.org_note_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',

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

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

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

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

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

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

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

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

Line 228: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OON_ONT_FK');

224: Open cur_rowid;
225: Fetch cur_rowid INTO lv_rowid;
226: IF (cur_rowid%FOUND) THEN
227: Close cur_rowid;
228: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OON_ONT_FK');
229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231: Return;
232: END IF;

Line 252: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OON_INS_FK');

248: OPEN cur_rowid;
249: FETCH cur_rowid INTO lv_rowid;
250: IF (cur_rowid%FOUND) THEN
251: CLOSE cur_rowid;
252: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OON_INS_FK');
253: IGS_GE_MSG_STACK.ADD;
254: App_Exception.Raise_Exception;
255: RETURN;
256: END IF;

Line 275: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OON_LOC_FK');

271: OPEN cur_rowid;
272: FETCH cur_rowid INTO lv_rowid;
273: IF (cur_rowid%FOUND) THEN
274: CLOSE cur_rowid;
275: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OON_LOC_FK');
276: IGS_GE_MSG_STACK.ADD;
277: App_Exception.Raise_Exception;
278: RETURN;
279: END IF;

Line 298: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OON_OU_FK');

294: OPEN cur_rowid;
295: FETCH cur_rowid INTO lv_rowid;
296: IF (cur_rowid%FOUND) THEN
297: CLOSE cur_rowid;
298: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OON_OU_FK');
299: IGS_GE_MSG_STACK.ADD;
300: App_Exception.Raise_Exception;
301: RETURN;
302: END IF;

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

358: new_references.org_structure_type,
359: new_references.org_note_sequence,
360: new_references.org_note_type,
361: new_references.org_structure_id) THEN
362: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
363: IGS_GE_MSG_STACK.ADD;
364: App_Exception.Raise_Exception;
365: END IF;
366: Check_Constraints;

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

379: new_references.org_structure_type,
380: new_references.org_note_sequence,
381: new_references.org_note_type,
382: new_references.org_structure_id) THEN
383: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
384: IGS_GE_MSG_STACK.ADD;
385: App_Exception.Raise_Exception;
386: END IF;
387: Check_Constraints;

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

470: if X_LAST_UPDATE_LOGIN is NULL then
471: X_LAST_UPDATE_LOGIN := -1;
472: end if;
473: else
474: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
475: IGS_GE_MSG_STACK.ADD;
476: app_exception.raise_exception;
477: end if;
478: SELECT

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

566: begin
567: open c1;
568: fetch c1 into tlinfo;
569: if (c1%notfound) then
570: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
571: IGS_GE_MSG_STACK.ADD;
572: close c1;
573: app_exception.raise_exception;
574: return;

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

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

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

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