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: new_references.cost_centre,
91: new_references.subject
92: )
93: ) THEN
94: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
95: igs_ge_msg_stack.add;
96: app_exception.raise_exception;
97: END IF;
98:
115: NULL;
116: ELSIF NOT igs_or_unit_pkg.get_PK_For_Str_Validation (
117: new_references.org_unit_cd
118: ) THEN
119: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
120: igs_ge_msg_stack.add;
121: app_exception.raise_exception;
122: END IF;
123:
244: IF ( get_pk_for_validation(
245: new_references.hesa_ou_cc_id
246: )
247: ) THEN
248: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
249: igs_ge_msg_stack.add;
250: app_exception.raise_exception;
251: END IF;
252: check_uniqueness;
260: IF ( get_pk_for_validation (
261: new_references.hesa_ou_cc_id
262: )
263: ) THEN
264: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: END IF;
268: check_uniqueness;
311: IF (x_last_update_login IS NULL) THEN
312: x_last_update_login := -1;
313: END IF;
314: ELSE
315: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
316: fnd_message.set_token ('ROUTINE', 'IGS_HE_OU_CC_PKG.INSERT_ROW');
317: igs_ge_msg_stack.add;
318: app_exception.raise_exception;
319: END IF;
312: x_last_update_login := -1;
313: END IF;
314: ELSE
315: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
316: fnd_message.set_token ('ROUTINE', 'IGS_HE_OU_CC_PKG.INSERT_ROW');
317: igs_ge_msg_stack.add;
318: app_exception.raise_exception;
319: END IF;
320:
395:
396: OPEN c1;
397: FETCH c1 INTO tlinfo;
398: IF (c1%notfound) THEN
399: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
400: igs_ge_msg_stack.add;
401: CLOSE c1;
402: app_exception.raise_exception;
403: RETURN;
411: AND (tlinfo.proportion = x_proportion)
412: ) THEN
413: NULL;
414: ELSE
415: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
416: igs_ge_msg_stack.add;
417: app_exception.raise_exception;
418: END IF;
419:
459: IF (x_last_update_login IS NULL) THEN
460: x_last_update_login := -1;
461: END IF;
462: ELSE
463: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
464: fnd_message.set_token ('ROUTINE', 'IGS_HE_OU_CC_PKG.UPDATE_ROW');
465: igs_ge_msg_stack.add;
466: app_exception.raise_exception;
467: END IF;
460: x_last_update_login := -1;
461: END IF;
462: ELSE
463: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
464: fnd_message.set_token ('ROUTINE', 'IGS_HE_OU_CC_PKG.UPDATE_ROW');
465: igs_ge_msg_stack.add;
466: app_exception.raise_exception;
467: END IF;
468: