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;
54: CLOSE cur_old_ref_values;
105: FETCH cur_chk_prof INTO rec_chk_prof;
106: IF cur_chk_prof%FOUND THEN
107: CLOSE cur_chk_prof;
108: FND_MESSAGE.SET_NAME ('FND', 'IGS_GE_RECORD_ALREADY_EXISTS');
109: IGS_GE_MSG_STACK.ADD;
110: APP_EXCEPTION.RAISE_EXCEPTION;
111: END IF;
112: CLOSE cur_chk_prof;
113: END IF;
115: FETCH cur_chk_unk_unt_lvl INTO rec_chk_unk_unt_lvl;
116: IF cur_chk_unk_unt_lvl%FOUND THEN
117: CLOSE cur_chk_unk_unt_lvl;
118: FND_MESSAGE.SET_NAME ('FND', 'IGS_PR_AWD_UL_EXISTS');
119: IGS_GE_MSG_STACK.ADD;
120: APP_EXCEPTION.RAISE_EXCEPTION;
121: END IF;
122: CLOSE cur_chk_unk_unt_lvl;
123:
144: ELSIF NOT igs_ps_awd_pkg.get_pk_for_validation (
145: new_references.award_cd
146: ) 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:
152: IF (((old_references.unit_level = new_references.unit_level)) OR
155: ELSIF NOT igs_ps_unit_level_pkg.get_pk_for_validation (
156: new_references.unit_level
157: ) THEN
158: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
159: igs_ge_msg_stack.add;
160: app_exception.raise_exception;
161: END IF;
162:
163: IF (((old_references.stat_type = new_references.stat_type) AND
169: new_references.stat_type,
170: new_references.s_stat_element
171: ) THEN
172: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
173: igs_ge_msg_stack.add;
174: app_exception.raise_exception;
175: END IF;
176:
177: END check_parent_existance;
262: new_references.awd_hnr_basis_id
263: )
264: ) THEN
265: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
266: igs_ge_msg_stack.add;
267: app_exception.raise_exception;
268: END IF;
269: check_parent_existance;
270: beforeinsertupdate(x_rowid);
278: new_references.awd_hnr_basis_id
279: )
280: ) THEN
281: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
282: igs_ge_msg_stack.add;
283: app_exception.raise_exception;
284: END IF;
285: beforeinsertupdate(x_rowid);
286: END IF;
330: END IF;
331: ELSE
332: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
333: fnd_message.set_token ('ROUTINE', 'IGS_PS_AWD_HNR_BASE_PKG.INSERT_ROW');
334: igs_ge_msg_stack.add;
335: app_exception.raise_exception;
336: END IF;
337:
338: x_awd_hnr_basis_id := NULL;
423: OPEN c1;
424: FETCH c1 INTO tlinfo;
425: IF (c1%notfound) THEN
426: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
427: igs_ge_msg_stack.add;
428: CLOSE c1;
429: app_exception.raise_exception;
430: RETURN;
431: END IF;
441: ) THEN
442: NULL;
443: ELSE
444: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
445: igs_ge_msg_stack.add;
446: app_exception.raise_exception;
447: END IF;
448:
449: RETURN;
492: END IF;
493: ELSE
494: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
495: fnd_message.set_token ('ROUTINE', 'IGS_PS_AWD_HNR_BASE_PKG.UPDATE_ROW');
496: igs_ge_msg_stack.add;
497: app_exception.raise_exception;
498: END IF;
499:
500: before_dml(