287: SET error_code = g_error_code
288: WHERE rowid = new_uinst_rec.rowid;
289:
290: -- log error message/meaning.
291: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
292: -- update error count
293: g_error_rec_cnt := g_error_rec_cnt + 1;
294:
295: ELSE
309:
310:
311: COMMIT;
312: -- log process complete
313: igs_uc_proc_ucas_data.log_proc_complete('UVINSTITUTION', g_success_rec_cnt, g_error_rec_cnt);
314:
315: EXCEPTION
316: WHEN OTHERS THEN
317: -- Process should continue with processing of other view data
524: SET error_code = g_error_code
525: WHERE rowid = new_uvoffabrv_rec.rowid;
526:
527: -- log error message/meaning.
528: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
529:
530: -- update error count
531: g_error_rec_cnt := g_error_rec_cnt + 1;
532:
542: END LOOP;
543:
544: COMMIT;
545: -- log processing complete for this view
546: igs_uc_proc_ucas_data.log_proc_complete('UVOFFERABBREV', g_success_rec_cnt, g_error_rec_cnt);
547:
548: EXCEPTION
549: -- Process should continue with processing of other view data
550: WHEN OTHERS THEN
698: SET error_code = g_error_code
699: WHERE rowid = new_cvinst_rec.rowid;
700:
701: -- log error message/meaning.
702: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
703:
704: -- update error count
705: g_error_rec_cnt := g_error_rec_cnt + 1;
706:
717: END LOOP;
718:
719: COMMIT;
720: -- log processing complete for this view
721: igs_uc_proc_ucas_data.log_proc_complete('CVINSTITUTION', g_success_rec_cnt, g_error_rec_cnt);
722:
723: EXCEPTION
724: -- Process should continue with processing of other view data
725: WHEN OTHERS THEN
904: SET error_code = g_error_code
905: WHERE rowid = new_eblsubj_rec.rowid;
906:
907: -- log error message/meaning.
908: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
909:
910: -- update error count
911: g_error_rec_cnt := g_error_rec_cnt + 1;
912:
923: END LOOP;
924:
925: COMMIT;
926: -- log processing complete for this view
927: igs_uc_proc_ucas_data.log_proc_complete('CVEBLSUBJECT', g_success_rec_cnt, g_error_rec_cnt);
928:
929: EXCEPTION
930: -- Process should continue with processing of other view data
931: WHEN OTHERS THEN
1211: SET error_code = g_error_code
1212: WHERE rowid = new_school_rec.rowid;
1213:
1214: -- log error message/meaning.
1215: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
1216:
1217: -- update error count
1218: g_error_rec_cnt := g_error_rec_cnt + 1;
1219:
1230: END LOOP;
1231:
1232: COMMIT;
1233: -- log processing complete for this view
1234: igs_uc_proc_ucas_data.log_proc_complete('CVSCHOOL', g_success_rec_cnt, g_error_rec_cnt);
1235:
1236: EXCEPTION
1237: -- Process should continue with processing of other view data
1238: WHEN OTHERS THEN
1461: SET error_code = g_error_code
1462: WHERE rowid = new_schcntct_rec.rowid;
1463:
1464: -- log error message/meaning.
1465: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
1466:
1467: -- update error count
1468: g_error_rec_cnt := g_error_rec_cnt + 1;
1469:
1480: END LOOP;
1481:
1482: COMMIT;
1483: -- log processing complete for this view
1484: igs_uc_proc_ucas_data.log_proc_complete('CVSCHOOLCONTACT', g_success_rec_cnt, g_error_rec_cnt);
1485:
1486: EXCEPTION
1487: -- Process should continue with processing of other view data
1488: WHEN OTHERS THEN
1751: SET error_code = g_error_code
1752: WHERE rowid = new_cvcrse_rec.rowid;
1753:
1754: -- log error message/meaning.
1755: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
1756:
1757: -- update error count
1758: g_error_rec_cnt := g_error_rec_cnt + 1;
1759:
1836:
1837:
1838: COMMIT;
1839: -- log processing complete for this view
1840: igs_uc_proc_ucas_data.log_proc_complete('CVCOURSE', g_success_rec_cnt, g_error_rec_cnt);
1841:
1842: EXCEPTION
1843: -- Process should continue with processing of other view data
1844: WHEN OTHERS THEN
2010: SET error_code = g_error_code
2011: WHERE rowid = new_uvcrse_rec.rowid;
2012:
2013: -- log error message/meaning.
2014: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
2015:
2016: -- update error count
2017: g_error_rec_cnt := g_error_rec_cnt + 1;
2018:
2030:
2031:
2032: COMMIT;
2033: -- log processing complete for this view
2034: igs_uc_proc_ucas_data.log_proc_complete('UVCOURSE', g_success_rec_cnt, g_error_rec_cnt);
2035:
2036: EXCEPTION
2037: -- Process should continue with processing of other view data
2038: WHEN OTHERS THEN
2332: SET error_code = g_error_code
2333: WHERE rowid = new_ucrsekwd_rec.rowid;
2334:
2335: -- log error message/meaning.
2336: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
2337:
2338: -- update error count
2339: g_error_rec_cnt := g_error_rec_cnt + 1;
2340:
2390: END LOOP; -- main loop for the combination
2391:
2392: COMMIT;
2393: -- log processing complete for this view
2394: igs_uc_proc_ucas_data.log_proc_complete('UVCOURSEKEYWORD', g_success_rec_cnt, g_error_rec_cnt);
2395:
2396: EXCEPTION
2397: -- Process should continue with processing of other view data
2398: WHEN OTHERS THEN