68: OPEN cur_old_ref_values;
69: FETCH cur_old_ref_values INTO old_references;
70: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
71: CLOSE cur_old_ref_values;
72: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
73: igs_ge_msg_stack.add;
74: app_exception.raise_exception;
75: RETURN;
76: END IF;
143: NULL;
144: ELSIF NOT igs_uc_defaults_pkg.get_pk_for_validation (
145: new_references.system_code
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:
280: IF ( get_pk_for_validation(
281: new_references.uc_tran_id
282: )
283: ) THEN
284: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
285: igs_ge_msg_stack.add;
286: app_exception.raise_exception;
287: END IF;
288: check_parent_existance;
291: IF ( get_pk_for_validation (
292: new_references.uc_tran_id
293: )
294: ) THEN
295: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
296: igs_ge_msg_stack.add;
297: app_exception.raise_exception;
298: END IF;
299: END IF;
368: IF (x_last_update_login IS NULL) THEN
369: x_last_update_login := -1;
370: END IF;
371: ELSE
372: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
373: igs_ge_msg_stack.add;
374: app_exception.raise_exception;
375: END IF;
376:
504:
505: EXCEPTION
506: WHEN OTHERS THEN
507: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
508: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
509: fnd_message.set_token ('ERR_CD', SQLCODE);
510: igs_ge_msg_stack.add;
511: igs_sc_gen_001.unset_ctx('R');
512: app_exception.raise_exception;
505: EXCEPTION
506: WHEN OTHERS THEN
507: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
508: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
509: fnd_message.set_token ('ERR_CD', SQLCODE);
510: igs_ge_msg_stack.add;
511: igs_sc_gen_001.unset_ctx('R');
512: app_exception.raise_exception;
513: ELSE
598:
599: OPEN c1;
600: FETCH c1 INTO tlinfo;
601: IF (c1%notfound) THEN
602: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
603: igs_ge_msg_stack.add;
604: CLOSE c1;
605: app_exception.raise_exception;
606: RETURN;
637: AND ((tlinfo.part_time = x_part_time) OR ((tlinfo.part_time IS NULL) AND (x_part_time IS NULL)) )
638: ) THEN
639: NULL;
640: ELSE
641: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
642: igs_ge_msg_stack.add;
643: app_exception.raise_exception;
644: END IF;
645:
710: IF (x_last_update_login IS NULL) THEN
711: x_last_update_login := -1;
712: END IF;
713: ELSE
714: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
715: igs_ge_msg_stack.add;
716: app_exception.raise_exception;
717: END IF;
718:
791: part_time = new_references.part_time
792: WHERE rowid = x_rowid;
793:
794: IF (SQL%NOTFOUND) THEN
795: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
796: igs_ge_msg_stack.add;
797: igs_sc_gen_001.unset_ctx('R');
798: app_exception.raise_exception;
799: END IF;
803:
804: EXCEPTION
805: WHEN OTHERS THEN
806: IF (SQLCODE = (-28115)) THEN
807: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
808: fnd_message.set_token ('ERR_CD', SQLCODE);
809: igs_ge_msg_stack.add;
810: igs_sc_gen_001.unset_ctx('R');
811: app_exception.raise_exception;
804: EXCEPTION
805: WHEN OTHERS THEN
806: IF (SQLCODE = (-28115)) THEN
807: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
808: fnd_message.set_token ('ERR_CD', SQLCODE);
809: igs_ge_msg_stack.add;
810: igs_sc_gen_001.unset_ctx('R');
811: app_exception.raise_exception;
812: ELSE
970: DELETE FROM igs_uc_transactions
971: WHERE rowid = x_rowid;
972:
973: IF (SQL%NOTFOUND) THEN
974: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
975: igs_ge_msg_stack.add;
976: igs_sc_gen_001.unset_ctx('R');
977: app_exception.raise_exception;
978: END IF;