216:
217: BEGIN
218:
219: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;
220: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');
221:
222: ----1) Insert new record into XFR_RUN_INFO and get the generated Run_ID for this import
223:
224: IF(inRun_ID IS NOT NULL)THEN
360:
361: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_IMPORT_COMPLETED','RUNID',TO_CHAR(genRun_ID)));
362:
363: COMMIT;
364: DBMS_APPLICATION_INFO.SET_MODULE('','');
365:
366: EXCEPTION
367: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
368: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'GO_GENERIC',11276,genRun_ID);
365:
366: EXCEPTION
367: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
368: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'GO_GENERIC',11276,genRun_ID);
369: DBMS_APPLICATION_INFO.SET_MODULE('','');
370: RAISE;
371: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
372: DBMS_APPLICATION_INFO.SET_MODULE('','');
373: RAISE;
368: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'GO_GENERIC',11276,genRun_ID);
369: DBMS_APPLICATION_INFO.SET_MODULE('','');
370: RAISE;
371: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
372: DBMS_APPLICATION_INFO.SET_MODULE('','');
373: RAISE;
374: WHEN OTHERS THEN
375: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
376: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.GO_GENERIC',11276,NULL);
373: RAISE;
374: WHEN OTHERS THEN
375: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED', 'ERRORTEXT', SQLERRM);
376: xERROR:=cz_utils.log_report(d_str,1,'CZ_IMP_ALL.GO_GENERIC',11276,NULL);
377: DBMS_APPLICATION_INFO.SET_MODULE('','');
378: RAISE;
379: END go_generic;
380: ------------------------------------------------------------------------------------------
381: PROCEDURE populate_table(inRun_ID IN PLS_INTEGER,