DBA Data[Home] [Help]

APPS.CZ_IMP_ALL dependencies on DBMS_APPLICATION_INFO

Line 220: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');

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

Line 364: DBMS_APPLICATION_INFO.SET_MODULE('','');

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);

Line 369: 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);
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;

Line 372: DBMS_APPLICATION_INFO.SET_MODULE('','');

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);

Line 377: 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);
377: DBMS_APPLICATION_INFO.SET_MODULE('','');
378: RAISE;
379: END go_generic;
380: ------------------------------------------------------------------------------------------
381: PROCEDURE populate_table(inRun_ID IN PLS_INTEGER,