42: OPEN cur_old_ref_values;
43: FETCH cur_old_ref_values INTO old_references;
44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
88: NULL;
89: ELSIF NOT igs_fi_hier_accounts_pkg.get_pk_for_validation (
90: new_references.acct_hier_id
91: ) THEN
92: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
95: END IF;
96:
156: OPEN cur_rowid;
157: FETCH cur_rowid INTO lv_rowid;
158: IF (cur_rowid%FOUND) THEN
159: CLOSE cur_rowid;
160: fnd_message.set_name ('IGS', 'IGS_FI_FHAT_FHA_FK');
161: igs_ge_msg_stack.add;
162: app_exception.raise_exception;
163: RETURN;
164: END IF;
211: IF ( get_pk_for_validation(
212: new_references.acct_tbl_id
213: )
214: ) THEN
215: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
216: igs_ge_msg_stack.add;
217: app_exception.raise_exception;
218: END IF;
219: check_parent_existance;
225: IF ( get_pk_for_validation (
226: new_references.acct_tbl_id
227: )
228: ) THEN
229: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
230: igs_ge_msg_stack.add;
231: app_exception.raise_exception;
232: END IF;
233: END IF;
276: IF (x_last_update_login IS NULL) THEN
277: x_last_update_login := -1;
278: END IF;
279: ELSE
280: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
281: igs_ge_msg_stack.add;
282: app_exception.raise_exception;
283: END IF;
284:
364:
365: OPEN c1;
366: FETCH c1 INTO tlinfo;
367: IF (c1%notfound) THEN
368: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
369: igs_ge_msg_stack.add;
370: CLOSE c1;
371: app_exception.raise_exception;
372: RETURN;
379: AND (tlinfo.entity_type_code = x_entity_type_code)
380: ) THEN
381: NULL;
382: ELSE
383: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
384: igs_ge_msg_stack.add;
385: app_exception.raise_exception;
386: END IF;
387:
426: IF (x_last_update_login IS NULL) THEN
427: x_last_update_login := -1;
428: END IF;
429: ELSE
430: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
431: igs_ge_msg_stack.add;
432: app_exception.raise_exception;
433: END IF;
434: