DBA Data[Home] [Help]

APPS.IGS_OR_ORG_ACCR_DTLS_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 123: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');

119: ELSIF NOT Igs_lookups_view_pkg.Get_PK_For_Validation (
120: 'OR_ACCR_STATUS',
121: new_references.org_accr_status
122: ) THEN
123: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127:

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

130: NULL;
131: ELSIF NOT Igs_Or_Institution_Pkg.Get_PK_For_Validation (
132: new_references.org_agency_id
133: ) THEN
134: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
135: IGS_GE_MSG_STACK.ADD;
136: App_Exception.Raise_Exception;
137: END IF;
138: IF NOT Igs_Lookups_View_Pkg.Get_Pk_For_Validation('ORG_STRUCTURE_TYPE',

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

136: App_Exception.Raise_Exception;
137: END IF;
138: IF NOT Igs_Lookups_View_Pkg.Get_Pk_For_Validation('ORG_STRUCTURE_TYPE',
139: new_references.org_structure_type) THEN
140: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
141: IGS_GE_MSG_STACK.ADD;
142: APP_EXCEPTION.RAISE_EXCEPTION;
143:
144: END IF;

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

143:
144: END IF;
145: IF new_references.org_structure_type = 'INSTITUTE' THEN
146: IF NOT Igs_Or_Institution_Pkg.Get_Pk_For_Validation(new_references.org_structure_id) THEN
147: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
148: IGS_GE_MSG_STACK.ADD;
149: APP_EXCEPTION.RAISE_EXCEPTION;
150: END IF;
151: ELSIF new_references.org_structure_type = 'LOCATION' THEN

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

150: END IF;
151: ELSIF new_references.org_structure_type = 'LOCATION' THEN
152: IF NOT Igs_Ad_Location_Pkg.Get_Pk_For_Validation(new_references.org_structure_id,
153: 'N') THEN
154: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
155: IGS_GE_MSG_STACK.ADD;
156: APP_EXCEPTION.RAISE_EXCEPTION;
157: END IF;
158: ELSIF new_references.org_structure_type = 'ORG_UNIT' THEN

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

156: APP_EXCEPTION.RAISE_EXCEPTION;
157: END IF;
158: ELSIF new_references.org_structure_type = 'ORG_UNIT' THEN
159: IF NOT Igs_Or_Unit_Pkg.Get_Pk_For_Str_Validation(new_references.org_structure_id) 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: END IF;

Line 241: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OAD_OAS_FK');

237: Open cur_rowid;
238: Fetch cur_rowid INTO lv_rowid;
239: IF (cur_rowid%FOUND) THEN
240: Close cur_rowid;
241: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OAD_OAS_FK');
242: IGS_GE_MSG_STACK.ADD;
243: App_Exception.Raise_Exception;
244: Return;
245: END IF;

Line 278: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OAD_OI_FK');

274: Open cur_rowid;
275: Fetch cur_rowid INTO lv_rowid;
276: IF (cur_rowid%FOUND) THEN
277: Close cur_rowid;
278: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OAD_OI_FK');
279: IGS_GE_MSG_STACK.ADD;
280: App_Exception.Raise_Exception;
281: Return;
282: END IF;

Line 301: Fnd_Message.Set_Name ('IGS', 'IGS_OR_OAD_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_OR_OAD_LOC_FK');
302: IGS_GE_MSG_STACK.ADD;
303: App_Exception.Raise_Exception;
304: RETURN;
305: END IF;

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

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

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

381: new_references.org_agency_id,
382: new_references.org_structure_id,
383: new_references.org_structure_type,
384: new_references.start_date) THEN
385: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
386: IGS_GE_MSG_STACK.ADD;
387: App_Exception.Raise_Exception;
388: END IF;
389: Check_Constraints;

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

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

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

556: begin
557: open c1;
558: fetch c1 into tlinfo;
559: if (c1%notfound) then
560: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
561: IGS_GE_MSG_STACK.ADD;
562: close c1;
563: app_exception.raise_exception;
564: return;

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

569: AND (X_END_DATE is null)))
570: ) then
571: null;
572: else
573: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
574: IGS_GE_MSG_STACK.ADD;
575: app_exception.raise_exception;
576: end if;
577: return;

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

614: if X_LAST_UPDATE_LOGIN is NULL then
615: X_LAST_UPDATE_LOGIN := -1;
616: end if;
617: else
618: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
619: IGS_GE_MSG_STACK.ADD;
620: app_exception.raise_exception;
621: end if;
622: Before_DML(