44: OPEN cur_old_ref_values;
45: FETCH cur_old_ref_values INTO old_references;
46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
95: ELSIF NOT igs_ad_ss_appl_pgs_pkg.get_pk_for_validation (
96: new_references.page_name,
97: new_references.admission_application_type
98: ) THEN
99: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
100: igs_ge_msg_stack.add;
101: app_exception.raise_exception;
102: END IF;
103:
169: OPEN cur_rowid;
170: FETCH cur_rowid INTO lv_rowid;
171: IF (cur_rowid%FOUND) THEN
172: CLOSE cur_rowid;
173: fnd_message.set_name ('IGS', 'IGS_FOREIGN_KEY_REFERENCE');
174: igs_ge_msg_stack.add;
175: app_exception.raise_exception;
176: RETURN;
177: END IF;
230: new_references.page_name,
231: new_references.component_code
232: )
233: ) THEN
234: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
235: igs_ge_msg_stack.add;
236: app_exception.raise_exception;
237: END IF;
238: check_parent_existance;
246: new_references.page_name,
247: new_references.component_code
248: )
249: ) THEN
250: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
251: igs_ge_msg_stack.add;
252: app_exception.raise_exception;
253: END IF;
254: END IF;
295: IF (x_last_update_login IS NULL) THEN
296: x_last_update_login := -1;
297: END IF;
298: ELSE
299: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
300: fnd_message.set_token ('ROUTINE', 'igs_ad_ss_appl_comps_PKG.INSERT_ROW');
301: igs_ge_msg_stack.add;
302: app_exception.raise_exception;
303: END IF;
296: x_last_update_login := -1;
297: END IF;
298: ELSE
299: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
300: fnd_message.set_token ('ROUTINE', 'igs_ad_ss_appl_comps_PKG.INSERT_ROW');
301: igs_ge_msg_stack.add;
302: app_exception.raise_exception;
303: END IF;
304:
384:
385: OPEN c1;
386: FETCH c1 INTO tlinfo;
387: IF (c1%notfound) THEN
388: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
389: igs_ge_msg_stack.add;
390: CLOSE c1;
391: app_exception.raise_exception;
392: RETURN;
399: AND (tlinfo.required_flag = x_required_flag)
400: ) THEN
401: NULL;
402: ELSE
403: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
404: igs_ge_msg_stack.add;
405: app_exception.raise_exception;
406: END IF;
407:
448: IF (x_last_update_login IS NULL) THEN
449: x_last_update_login := -1;
450: END IF;
451: ELSE
452: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
453: fnd_message.set_token ('ROUTINE', 'igs_ad_ss_appl_comps_PKG.UPDATE_ROW');
454: igs_ge_msg_stack.add;
455: app_exception.raise_exception;
456: END IF;
449: x_last_update_login := -1;
450: END IF;
451: ELSE
452: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
453: fnd_message.set_token ('ROUTINE', 'igs_ad_ss_appl_comps_PKG.UPDATE_ROW');
454: igs_ge_msg_stack.add;
455: app_exception.raise_exception;
456: END IF;
457: