[Home] [Help]
131: g_error_code := '9998';
132: fnd_file.put_line(fnd_file.log, SQLERRM);
133:
134: -- log error message
135: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
136: END;
137: END IF; -- insert / update
138: END IF; -- Code type validation
139:
167: SET error_code = g_error_code
168: WHERE rowid = new_crfcode_rec.rowid;
169:
170: -- log error message/meaning.
171: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
172: -- update error count
173: g_error_rec_cnt := g_error_rec_cnt + 1;
174:
175: ELSE
184: END LOOP;
185:
186: COMMIT;
187: -- log processing complete for this view
188: igs_uc_proc_ucas_data.log_proc_complete('REFERENCE CODES', g_success_rec_cnt, g_error_rec_cnt);
189:
190: EXCEPTION
191: -- Process should continue with processing of other view data
192: WHEN OTHERS THEN
335: SET error_code = g_error_code
336: WHERE rowid = new_awdbdy_rec.rowid;
337:
338: -- log error message/meaning.
339: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
340: -- update error count
341: g_error_rec_cnt := g_error_rec_cnt + 1;
342:
343: ELSE
353: END LOOP;
354:
355: COMMIT;
356: -- log processing complete for this view
357: igs_uc_proc_ucas_data.log_proc_complete('CVREFAWARDBODY', g_success_rec_cnt, g_error_rec_cnt);
358:
359: EXCEPTION
360: -- Process should continue with processing of other view data
361: WHEN OTHERS THEN
492: SET error_code = g_error_code
493: WHERE rowid = new_refapr_rec.rowid;
494:
495: -- log error message/meaning.
496: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
497:
498: -- update error count
499: g_error_rec_cnt := g_error_rec_cnt + 1;
500:
510: END LOOP;
511:
512: COMMIT;
513: -- log processing complete for this view
514: igs_uc_proc_ucas_data.log_proc_complete('CVREFAPR', g_success_rec_cnt, g_error_rec_cnt);
515:
516: EXCEPTION
517: -- Process should continue with processing of other view data
518: WHEN OTHERS THEN
641: SET error_code = g_error_code
642: WHERE rowid = new_refkwd_rec.rowid;
643:
644: -- log error message/meaning.
645: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
646: -- update error count
647: g_error_rec_cnt := g_error_rec_cnt + 1;
648:
649: ELSE
658: END LOOP;
659:
660: COMMIT;
661: -- log processing complete for this view
662: igs_uc_proc_ucas_data.log_proc_complete('CVREFKEYWORD', g_success_rec_cnt, g_error_rec_cnt);
663:
664: EXCEPTION
665: -- Process should continue with processing of other view data
666: WHEN OTHERS THEN
812: SET error_code = g_error_code
813: WHERE rowid = new_refpocc_rec.rowid;
814:
815: -- log error message/meaning.
816: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
817: -- update error count
818: g_error_rec_cnt := g_error_rec_cnt + 1;
819:
820: ELSE
829: END LOOP;
830:
831: COMMIT;
832: -- log processing complete for this view
833: igs_uc_proc_ucas_data.log_proc_complete('CVREFPOCC', g_success_rec_cnt, g_error_rec_cnt);
834:
835: EXCEPTION
836: WHEN OTHERS THEN
837: ROLLBACK;
1047: SET error_code = g_error_code
1048: WHERE rowid = new_refoffab_rec.rowid;
1049:
1050: -- log error message/meaning.
1051: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
1052: -- update error count
1053: g_error_rec_cnt := g_error_rec_cnt + 1;
1054:
1055:
1065: END LOOP;
1066:
1067: COMMIT;
1068: -- log processing complete for this view
1069: igs_uc_proc_ucas_data.log_proc_complete('CVREFOFFERABBREV', g_success_rec_cnt, g_error_rec_cnt);
1070:
1071: EXCEPTION
1072: WHEN OTHERS THEN
1073: ROLLBACK;
1207: SET error_code = g_error_code
1208: WHERE rowid = new_refsubj_rec.rowid;
1209:
1210: -- log error message/meaning.
1211: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
1212: -- update error count
1213: g_error_rec_cnt := g_error_rec_cnt + 1;
1214:
1215: ELSE
1224: END LOOP;
1225:
1226: COMMIT;
1227: -- log processing complete for this view
1228: igs_uc_proc_ucas_data.log_proc_complete('CVREFSUBJ', g_success_rec_cnt, g_error_rec_cnt);
1229:
1230: EXCEPTION
1231: WHEN OTHERS THEN
1232: ROLLBACK;
1366: SET error_code = g_error_code
1367: WHERE rowid = new_reftariff_rec.rowid;
1368:
1369: -- log error message/meaning.
1370: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
1371:
1372: -- update error count
1373: g_error_rec_cnt := g_error_rec_cnt + 1;
1374:
1384: END LOOP;
1385:
1386: COMMIT;
1387: -- log processing complete for this view
1388: igs_uc_proc_ucas_data.log_proc_complete('CVREFTARIFF', g_success_rec_cnt, g_error_rec_cnt);
1389:
1390: EXCEPTION
1391: WHEN OTHERS THEN
1392: ROLLBACK;
1619: SET error_code = g_error_code
1620: WHERE rowid = new_cjntadm_rec.rowid;
1621:
1622: -- log error message/meaning.
1623: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
1624: -- update error count
1625: g_error_rec_cnt := g_error_rec_cnt + 1;
1626:
1627: ELSE
1636: END LOOP;
1637:
1638: COMMIT;
1639: -- log processing complete for this view
1640: igs_uc_proc_ucas_data.log_proc_complete('CVJOINTADMISSIONS', g_success_rec_cnt, g_error_rec_cnt);
1641:
1642: EXCEPTION
1643: WHEN OTHERS THEN
1644: ROLLBACK;
1772: SET error_code = g_error_code
1773: WHERE rowid = new_country_rec.rowid;
1774:
1775: -- log error message/meaning.
1776: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
1777: -- update error count
1778: g_error_rec_cnt := g_error_rec_cnt + 1;
1779:
1780: ELSE
1790: END LOOP;
1791:
1792: COMMIT;
1793: -- log processing complete for this view
1794: igs_uc_proc_ucas_data.log_proc_complete('CVREFCOUNTRY', g_success_rec_cnt, g_error_rec_cnt);
1795:
1796: EXCEPTION
1797: WHEN OTHERS THEN
1798: ROLLBACK;