43: OPEN cur_old_ref_values;
44: FETCH cur_old_ref_values INTO old_references;
45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;
90: NULL;
91: ELSIF NOT igf_aw_awd_dist_plans_pkg.get_pk_for_validation (
92: new_references.adplans_id
93: ) THEN
94: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
95: igs_ge_msg_stack.add;
96: app_exception.raise_exception;
97: END IF;
98: IF (((old_references.ld_cal_type = new_references.ld_cal_type) AND
103: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation(
104: new_references.ld_cal_type,
105: new_references.ld_sequence_number
106: ) THEN
107: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
108: igs_ge_msg_stack.add;
109: app_exception.raise_exception;
110:
111: END IF;
151: new_references.ld_cal_type,
152: new_references.ld_sequence_number
153: )
154: ) THEN
155: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
156: igs_ge_msg_stack.add;
157: app_exception.raise_exception;
158: END IF;
159: END check_uniqueness;
259: OPEN cur_rowid;
260: FETCH cur_rowid INTO lv_rowid;
261: IF (cur_rowid%FOUND) THEN
262: CLOSE cur_rowid;
263: fnd_message.set_name ('IGF', 'IGF_AW_ADTERMS_ADPLANS_FK');
264: igs_ge_msg_stack.add;
265: app_exception.raise_exception;
266: RETURN;
267: END IF;
295: OPEN cur_rowid;
296: FETCH cur_rowid INTO lv_rowid;
297: IF (cur_rowid%FOUND) THEN
298: CLOSE cur_rowid;
299: fnd_message.set_name ('IGF', 'IGF_AW_ADTERMS_CI_FK');
300: igs_ge_msg_stack.add;
301: app_exception.raise_exception;
302: RETURN;
303: END IF;
351: IF ( get_pk_for_validation(
352: new_references.adterms_id
353: )
354: ) THEN
355: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: END IF;
359: check_parent_existance;
370: IF ( get_pk_for_validation (
371: new_references.adterms_id
372: )
373: ) THEN
374: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
375: igs_ge_msg_stack.add;
376: app_exception.raise_exception;
377: END IF;
378: check_uniqueness;
421: IF (x_last_update_login IS NULL) THEN
422: x_last_update_login := -1;
423: END IF;
424: ELSE
425: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
426: fnd_message.set_token ('ROUTINE', 'IGF_AW_DP_TERMS_PKG.INSERT_ROW');
427: igs_ge_msg_stack.add;
428: app_exception.raise_exception;
429: END IF;
422: x_last_update_login := -1;
423: END IF;
424: ELSE
425: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
426: fnd_message.set_token ('ROUTINE', 'IGF_AW_DP_TERMS_PKG.INSERT_ROW');
427: igs_ge_msg_stack.add;
428: app_exception.raise_exception;
429: END IF;
430:
505:
506: OPEN c1;
507: FETCH c1 INTO tlinfo;
508: IF (c1%notfound) THEN
509: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
510: igs_ge_msg_stack.add;
511: CLOSE c1;
512: app_exception.raise_exception;
513: RETURN;
521: AND ((tlinfo.ld_perct_num = x_ld_perct_num) OR ((tlinfo.ld_perct_num IS NULL) AND (X_ld_perct_num IS NULL)))
522: ) THEN
523: NULL;
524: ELSE
525: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
526: igs_ge_msg_stack.add;
527: app_exception.raise_exception;
528: END IF;
529:
569: IF (x_last_update_login IS NULL) THEN
570: x_last_update_login := -1;
571: END IF;
572: ELSE
573: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
574: fnd_message.set_token ('ROUTINE', 'IGF_AW_DP_TERMS_PKG.UPDATE_ROW');
575: igs_ge_msg_stack.add;
576: app_exception.raise_exception;
577: END IF;
570: x_last_update_login := -1;
571: END IF;
572: ELSE
573: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
574: fnd_message.set_token ('ROUTINE', 'IGF_AW_DP_TERMS_PKG.UPDATE_ROW');
575: igs_ge_msg_stack.add;
576: app_exception.raise_exception;
577: END IF;
578: