DBA Data[Home] [Help]

APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_PROC_UCAS_DATA

Line 207: igs_uc_proc_ucas_data.log_proc_complete('PERSON CREATION ', l_success_cnt, l_failure_cnt);

203:
204: END LOOP;
205:
206: -- log processing complete for this part of processing - Bug# 3327176.
207: igs_uc_proc_ucas_data.log_proc_complete('PERSON CREATION ', l_success_cnt, l_failure_cnt);
208:
209: EXCEPTION
210: WHEN OTHERS THEN
211: -- Close any Open cursors

Line 1327: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

1323: SET error_code = g_error_code
1324: WHERE rowid = new_ivstarn_rec.rowid;
1325:
1326: -- log error message/meaning.
1327: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
1328:
1329: -- update error count
1330: g_error_rec_cnt := g_error_rec_cnt + 1;
1331:

Line 1382: igs_uc_proc_ucas_data.log_proc_complete('IVSTARN', g_success_rec_cnt, g_error_rec_cnt);

1378: proc_populate_oss_person;
1379:
1380:
1381: -- log processing complete for this view
1382: igs_uc_proc_ucas_data.log_proc_complete('IVSTARN', g_success_rec_cnt, g_error_rec_cnt);
1383:
1384: EXCEPTION
1385: WHEN OTHERS THEN
1386: ROLLBACK;

Line 1756: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

1752: SET error_code = g_error_code
1753: WHERE rowid = new_ivstara_rec.rowid;
1754:
1755: -- log error message/meaning.
1756: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
1757:
1758: -- update error count
1759: g_error_rec_cnt := g_error_rec_cnt + 1;
1760:

Line 1774: igs_uc_proc_ucas_data.log_proc_complete('IVSTARA', g_success_rec_cnt, g_error_rec_cnt);

1770: END LOOP;
1771:
1772: COMMIT;
1773: -- log processing complete for this view
1774: igs_uc_proc_ucas_data.log_proc_complete('IVSTARA', g_success_rec_cnt, g_error_rec_cnt);
1775:
1776: EXCEPTION
1777: WHEN OTHERS THEN
1778: ROLLBACK;

Line 2470: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

2466: SET error_code = g_error_code
2467: WHERE rowid = new_ivstark_rec.rowid;
2468:
2469: -- log error message/meaning.
2470: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
2471:
2472: -- update error count
2473: g_error_rec_cnt := g_error_rec_cnt + 1;
2474:

Line 2488: igs_uc_proc_ucas_data.log_proc_complete('IVSTARK', g_success_rec_cnt, g_error_rec_cnt);

2484: END LOOP;
2485:
2486: COMMIT;
2487: -- log processing complete for this view
2488: igs_uc_proc_ucas_data.log_proc_complete('IVSTARK', g_success_rec_cnt, g_error_rec_cnt);
2489:
2490: EXCEPTION
2491: WHEN OTHERS THEN
2492: ROLLBACK;

Line 3209: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

3205: SET error_code = g_error_code
3206: WHERE rowid = new_ivstarc_rec.rowid;
3207:
3208: -- log error message/meaning.
3209: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
3210:
3211: -- update error count
3212: g_error_rec_cnt := g_error_rec_cnt + 1;
3213:

Line 3228: igs_uc_proc_ucas_data.log_proc_complete('IVSTARC', g_success_rec_cnt, g_error_rec_cnt);

3224: END LOOP;
3225:
3226: COMMIT;
3227: -- log processing complete for this view
3228: igs_uc_proc_ucas_data.log_proc_complete('IVSTARC', g_success_rec_cnt, g_error_rec_cnt);
3229:
3230: EXCEPTION
3231: WHEN OTHERS THEN
3232: ROLLBACK;

Line 4015: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

4011: SET error_code = g_error_code
4012: WHERE rowid = new_ivstarg_rec.rowid;
4013:
4014: -- log error message/meaning.
4015: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
4016:
4017: -- update error count
4018: g_error_rec_cnt := g_error_rec_cnt + 1;
4019:

Line 4034: igs_uc_proc_ucas_data.log_proc_complete('IVSTARG', g_success_rec_cnt, g_error_rec_cnt);

4030: END LOOP;
4031:
4032: COMMIT;
4033: -- log processing complete for this view
4034: igs_uc_proc_ucas_data.log_proc_complete('IVSTARG', g_success_rec_cnt, g_error_rec_cnt);
4035:
4036: EXCEPTION
4037: WHEN OTHERS THEN
4038: ROLLBACK TO process_ivstarg;

Line 4274: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

4270: SET error_code = g_error_code
4271: WHERE rowid = new_ivstart_rec.rowid;
4272:
4273: -- log error message/meaning.
4274: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
4275:
4276: -- update error count
4277: g_error_rec_cnt := g_error_rec_cnt + 1;
4278:

Line 4293: igs_uc_proc_ucas_data.log_proc_complete('IVSTART', g_success_rec_cnt, g_error_rec_cnt);

4289: END LOOP;
4290:
4291: COMMIT;
4292: -- log processing complete for this view
4293: igs_uc_proc_ucas_data.log_proc_complete('IVSTART', g_success_rec_cnt, g_error_rec_cnt);
4294:
4295: EXCEPTION
4296: WHEN OTHERS THEN
4297: ROLLBACK;

Line 4532: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

4528: SET error_code = g_error_code
4529: WHERE rowid = new_ivqual_rec.rowid;
4530:
4531: -- log error message/meaning.
4532: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
4533:
4534: -- update error count
4535: g_error_rec_cnt := g_error_rec_cnt + 1;
4536:

Line 4551: igs_uc_proc_ucas_data.log_proc_complete('IVQUALIFICATION', g_success_rec_cnt, g_error_rec_cnt);

4547: END LOOP;
4548:
4549: COMMIT;
4550: -- log processing complete for this view
4551: igs_uc_proc_ucas_data.log_proc_complete('IVQUALIFICATION', g_success_rec_cnt, g_error_rec_cnt);
4552:
4553: EXCEPTION
4554: WHEN OTHERS THEN
4555: ROLLBACK;

Line 4803: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

4799: SET error_code = g_error_code
4800: WHERE rowid = new_ivstmt_rec.rowid;
4801:
4802: -- log error message/meaning.
4803: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
4804:
4805: -- update error count
4806: g_error_rec_cnt := g_error_rec_cnt + 1;
4807:

Line 4822: igs_uc_proc_ucas_data.log_proc_complete('IVSTATEMENT', g_success_rec_cnt, g_error_rec_cnt);

4818: END LOOP;
4819:
4820: COMMIT;
4821: -- log processing complete for this view
4822: igs_uc_proc_ucas_data.log_proc_complete('IVSTATEMENT', g_success_rec_cnt, g_error_rec_cnt);
4823:
4824: EXCEPTION
4825: WHEN OTHERS THEN
4826: ROLLBACK;

Line 5027: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

5023: SET error_code = g_error_code
5024: WHERE rowid = new_ivoffer_rec.rowid;
5025:
5026: -- log error message/meaning.
5027: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
5028:
5029: -- update error count
5030: g_error_rec_cnt := g_error_rec_cnt + 1;
5031:

Line 5046: igs_uc_proc_ucas_data.log_proc_complete('IVOFFER', g_success_rec_cnt, g_error_rec_cnt);

5042: END LOOP;
5043:
5044: COMMIT;
5045: -- log processing complete for this view
5046: igs_uc_proc_ucas_data.log_proc_complete('IVOFFER', g_success_rec_cnt, g_error_rec_cnt);
5047:
5048: EXCEPTION
5049: WHEN OTHERS THEN
5050: ROLLBACK;

Line 5336: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

5332: SET error_code = g_error_code
5333: WHERE rowid = new_ivstarx_rec.rowid;
5334:
5335: -- log error message/meaning.
5336: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
5337:
5338: -- update error count
5339: g_error_rec_cnt := g_error_rec_cnt + 1;
5340:

Line 5355: igs_uc_proc_ucas_data.log_proc_complete('IVSTARX', g_success_rec_cnt, g_error_rec_cnt);

5351: END LOOP;
5352:
5353: COMMIT;
5354: -- log processing complete for this view
5355: igs_uc_proc_ucas_data.log_proc_complete('IVSTARX', g_success_rec_cnt, g_error_rec_cnt);
5356:
5357: EXCEPTION
5358: WHEN OTHERS THEN
5359: ROLLBACK;

Line 5649: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

5645: SET error_code = g_error_code
5646: WHERE rowid = new_ivstarh_rec.rowid;
5647:
5648: -- log error message/meaning.
5649: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
5650:
5651: -- update error count
5652: g_error_rec_cnt := g_error_rec_cnt + 1;
5653:

Line 5668: igs_uc_proc_ucas_data.log_proc_complete('IVSTARH', g_success_rec_cnt, g_error_rec_cnt);

5664: END LOOP;
5665:
5666: COMMIT;
5667: -- log processing complete for this view
5668: igs_uc_proc_ucas_data.log_proc_complete('IVSTARH', g_success_rec_cnt, g_error_rec_cnt);
5669:
5670: EXCEPTION
5671: WHEN OTHERS THEN
5672: ROLLBACK;

Line 6215: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

6211: SET error_code = g_error_code
6212: WHERE rowid = new_ivstarz1_rec.rowid;
6213:
6214: -- log error message/meaning.
6215: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
6216:
6217: -- update error count
6218: g_error_rec_cnt := g_error_rec_cnt + 1;
6219:

Line 6234: igs_uc_proc_ucas_data.log_proc_complete('IVSTARZ1', g_success_rec_cnt, g_error_rec_cnt);

6230: END LOOP;
6231:
6232: COMMIT;
6233: -- log processing complete for this view
6234: igs_uc_proc_ucas_data.log_proc_complete('IVSTARZ1', g_success_rec_cnt, g_error_rec_cnt);
6235:
6236: EXCEPTION
6237: WHEN OTHERS THEN
6238: ROLLBACK;

Line 6614: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

6610: SET error_code = g_error_code
6611: WHERE rowid = new_ivstarz2_rec.rowid;
6612:
6613: -- log error message/meaning.
6614: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
6615:
6616: -- update error count
6617: g_error_rec_cnt := g_error_rec_cnt + 1;
6618:

Line 6633: igs_uc_proc_ucas_data.log_proc_complete('IVSTARZ2', g_success_rec_cnt, g_error_rec_cnt);

6629: END LOOP;
6630:
6631: COMMIT;
6632: -- log processing complete for this view
6633: igs_uc_proc_ucas_data.log_proc_complete('IVSTARZ2', g_success_rec_cnt, g_error_rec_cnt);
6634:
6635: EXCEPTION
6636: WHEN OTHERS THEN
6637: ROLLBACK;

Line 6845: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

6841: SET error_code = g_error_code
6842: WHERE rowid = new_ivstarw_rec.rowid;
6843:
6844: -- log error message/meaning.
6845: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
6846:
6847: -- update error count
6848: g_error_rec_cnt := g_error_rec_cnt + 1;
6849:

Line 6864: igs_uc_proc_ucas_data.log_proc_complete('IVSTARW', g_success_rec_cnt, g_error_rec_cnt);

6860: END LOOP;
6861:
6862: COMMIT;
6863: -- log processing complete for this view
6864: igs_uc_proc_ucas_data.log_proc_complete('IVSTARW', g_success_rec_cnt, g_error_rec_cnt);
6865:
6866: EXCEPTION
6867: WHEN OTHERS THEN
6868: ROLLBACK;

Line 7095: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

7091: SET error_code = g_error_code
7092: WHERE rowid = new_ireference_rec.rowid;
7093:
7094: -- log error message/meaning.
7095: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
7096:
7097: -- update error count
7098: g_error_rec_cnt := g_error_rec_cnt + 1;
7099:

Line 7114: igs_uc_proc_ucas_data.log_proc_complete('IVREFERENCE', g_success_rec_cnt, g_error_rec_cnt);

7110: END LOOP;
7111:
7112: COMMIT;
7113: -- log processing complete for this view
7114: igs_uc_proc_ucas_data.log_proc_complete('IVREFERENCE', g_success_rec_cnt, g_error_rec_cnt);
7115:
7116: EXCEPTION
7117: WHEN OTHERS THEN
7118: ROLLBACK;

Line 7294: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

7290: SET error_code = g_error_code
7291: WHERE rowid = new_ivfrmqual_rec.rowid;
7292:
7293: -- log error message/meaning.
7294: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
7295:
7296: -- update error count
7297: g_error_rec_cnt := g_error_rec_cnt + 1;
7298:

Line 7313: igs_uc_proc_ucas_data.log_proc_complete('IVFORMQUALS', g_success_rec_cnt, g_error_rec_cnt);

7309: END LOOP;
7310:
7311: COMMIT;
7312: -- log processing complete for this view
7313: igs_uc_proc_ucas_data.log_proc_complete('IVFORMQUALS', g_success_rec_cnt, g_error_rec_cnt);
7314:
7315: EXCEPTION
7316: WHEN OTHERS THEN
7317: ROLLBACK;

Line 7842: igs_uc_proc_ucas_data.log_error_msg(g_error_code);

7838: SET error_code = g_error_code
7839: WHERE rowid = new_ivstarpqr_rec.rowid ;
7840:
7841: -- log error message/meaning.
7842: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
7843:
7844: -- update error count
7845: g_error_rec_cnt := g_error_rec_cnt + 1;
7846:

Line 7877: igs_uc_proc_ucas_data.log_proc_complete('IVSTARPQR', g_success_rec_cnt, g_error_rec_cnt);

7873: END LOOP; -- outer loop - applicant level
7874:
7875: COMMIT;
7876: -- log processing complete for this view
7877: igs_uc_proc_ucas_data.log_proc_complete('IVSTARPQR', g_success_rec_cnt, g_error_rec_cnt);
7878:
7879: EXCEPTION
7880: WHEN OTHERS THEN
7881: ROLLBACK;