556: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
557: END;
558:
559: if (CZ_IMP_ALL.get_time) then
560: st_time := dbms_utility.get_time();
561: end if;
562:
563: CND_INTL_TEXT(inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
564:
562:
563: CND_INTL_TEXT(inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
564:
565: if (CZ_IMP_ALL.get_time) then
566: end_time := dbms_utility.get_time();
567: d_str := inRun_id || ' CND intl text :' || (end_time-st_time)/100.00;
568: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299,inRun_Id);
569: end if;
570: KRS_INTL_TEXT(inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP);
569: end if;
570: KRS_INTL_TEXT(inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP);
571:
572: if (CZ_IMP_ALL.get_time) then
573: end_time := dbms_utility.get_time();
574: d_str := inRun_id || ' KRS intl text :' || (end_time-st_time)/100.00;
575: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299,inRun_Id);
576: end if;
577:
578: /* Make sure that the error count has not been reached */
579: XFR_INTL_TEXT(inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP);
580:
581: if (CZ_IMP_ALL.get_time) then
582: end_time := dbms_utility.get_time();
583: d_str := inRun_id || ' XFR intl text :' || (end_time-st_time)/100.00;
584: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299,inRun_Id);
585: end if;
586:
1479: VALUES(inRUN_ID,SYSDATE,SYSDATE);
1480: END;
1481:
1482: if (CZ_IMP_ALL.get_time) then
1483: st_time := dbms_utility.get_time();
1484: end if;
1485:
1486: CND_DEVL_PROJECT(inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
1487:
1485:
1486: CND_DEVL_PROJECT(inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
1487:
1488: if (CZ_IMP_ALL.get_time) then
1489: end_time := dbms_utility.get_time();
1490: d_str := inRun_id || ' CND projects :' || (end_time-st_time)/100.00;
1491: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299,inRun_Id);
1492: end if;
1493:
1491: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299,inRun_Id);
1492: end if;
1493:
1494: if (CZ_IMP_ALL.get_time) then
1495: st_time := dbms_utility.get_time();
1496: end if;
1497:
1498: KRS_DEVL_PROJECT(inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP,inCONFIG_ENGINE_TYPE);
1499:
1497:
1498: KRS_DEVL_PROJECT(inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP,inCONFIG_ENGINE_TYPE);
1499:
1500: if (CZ_IMP_ALL.get_time) then
1501: end_time := dbms_utility.get_time();
1502: d_str := inRun_id || ' KRS projects :' || (end_time-st_time)/100.00;
1503: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299,inRun_Id);
1504: end if;
1505:
1503: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299,inRun_Id);
1504: end if;
1505:
1506: if (CZ_IMP_ALL.get_time) then
1507: st_time := dbms_utility.get_time();
1508: end if;
1509: XFR_DEVL_PROJECT(inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,
1510: nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP, p_rp_folder_id);
1511: if (CZ_IMP_ALL.get_time) then
1508: end if;
1509: XFR_DEVL_PROJECT(inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,
1510: nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP, p_rp_folder_id);
1511: if (CZ_IMP_ALL.get_time) then
1512: end_time := dbms_utility.get_time();
1513: d_str := inRun_id || ' XFR projects :' || (end_time-st_time)/100.00;
1514: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299,inRun_Id);
1515: end if;
1516:
3025: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3026: END;
3027:
3028: if (CZ_IMP_ALL.get_time) then
3029: st_time := dbms_utility.get_time();
3030: end if;
3031:
3032: CND_PS_NODE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
3033:
3031:
3032: CND_PS_NODE (inRun_ID,COMMIT_SIZE,MAX_ERR,FAILED);
3033:
3034: if (CZ_IMP_ALL.get_time) then
3035: end_time := dbms_utility.get_time();
3036: d_str := inRun_id || ' CND ps :' || (end_time-st_time)/100.00;
3037: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'CND',11299,inRun_Id);
3038: end if;
3039:
3039:
3040: KRS_PS_NODE (inRUN_ID,COMMIT_SIZE,MAX_ERR,INSERTS,UPDATES,FAILED,DUPS,NOCHANGE,inXFR_GROUP);
3041:
3042: if (CZ_IMP_ALL.get_time) then
3043: end_time := dbms_utility.get_time();
3044: d_str := inRun_id || ' KRS ps :' || (end_time-st_time)/100.00;
3045: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'KRS',11299,inRun_Id);
3046: end if;
3047:
3068: fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
3069: x_error:=cz_utils.log_report('Gather Stats : End' ,1,'CZ_IMP_PS_NODE.XFR',11299,inRun_Id);
3070:
3071: if (CZ_IMP_ALL.get_time) then
3072: end_time := dbms_utility.get_time();
3073: d_str := inRun_id || ' XFR gather_stats :' || (end_time-st_time)/100.00;
3074: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299,inRun_Id);
3075: end if;
3076: END IF;
3077:
3078: XFR_PS_NODE (inRUN_ID,COMMIT_SIZE,MAX_ERR,nXfrInsertCount,nXfrUpdateCount,FAILED,nNoChangeCount,inXFR_GROUP);
3079:
3080: if (CZ_IMP_ALL.get_time) then
3081: end_time := dbms_utility.get_time();
3082: d_str := inRun_id || ' XFR ps :' || (end_time-st_time)/100.00;
3083: x_ERROR:=CZ_UTILS.LOG_REPORT(d_str,1,'XFR',11299,inRun_Id);
3084: end if;
3085: