APPS.CZ_IMP_SINGLE dependencies on DBMS_APPLICATION_INFO

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

3824: WHERE devl_project_id=REFRESH_MODEL_ID;
3825: END IF;
3826:
3827: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;
3828: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');
3829:
3830: BEGIN
3831: SELECT server_local_id INTO server_id
3832: FROM cz_servers

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

4049: CLOSE C_BILL_OF_MATERIAL;
4050: EXCEPTION
4051: WHEN PRIV_CHECK_ERR THEN
4052: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
4053: DBMS_APPLICATION_INFO.SET_MODULE('','');
4054: RAISE;
4055: WHEN HAS_NO_PRIV THEN
4056: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
4057: DBMS_APPLICATION_INFO.SET_MODULE('','');

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

4053: DBMS_APPLICATION_INFO.SET_MODULE('','');
4054: RAISE;
4055: WHEN HAS_NO_PRIV THEN
4056: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
4057: DBMS_APPLICATION_INFO.SET_MODULE('','');
4058: RAISE;
4059: WHEN FAILED_TO_LOCK_MODEL THEN
4060: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
4061: COMMIT;

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

4058: RAISE;
4059: WHEN FAILED_TO_LOCK_MODEL THEN
4060: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
4061: COMMIT;
4062: DBMS_APPLICATION_INFO.SET_MODULE('','');
4063: RAISE;
4064: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
4065: IF C_BILL_OF_MATERIAL%ISOPEN THEN CLOSE C_BILL_OF_MATERIAL; END IF;
4066: processed_expls_tbl.DELETE;

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

4073: WHEN IMP_CHILD_MULTI_COPIES THEN
4074: IF C_BILL_OF_MATERIAL%ISOPEN THEN CLOSE C_BILL_OF_MATERIAL; END IF;
4075: processed_expls_tbl.DELETE;
4076: import_enabled_tbl.DELETE;
4077: DBMS_APPLICATION_INFO.SET_MODULE('','');
4078: RAISE ;
4079: WHEN IMP_MODEL_NOT_ENABLED THEN
4080: IF C_BILL_OF_MATERIAL%ISOPEN THEN CLOSE C_BILL_OF_MATERIAL; END IF;
4081: processed_expls_tbl.DELETE;

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

4079: WHEN IMP_MODEL_NOT_ENABLED THEN
4080: IF C_BILL_OF_MATERIAL%ISOPEN THEN CLOSE C_BILL_OF_MATERIAL; END IF;
4081: processed_expls_tbl.DELETE;
4082: import_enabled_tbl.DELETE;
4083: DBMS_APPLICATION_INFO.SET_MODULE('','');
4084: RAISE ;
4085: WHEN OTHERS THEN
4086: IF C_BILL_OF_MATERIAL%ISOPEN THEN CLOSE C_BILL_OF_MATERIAL; END IF;
4087: processed_expls_tbl.DELETE;

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

4338: END LOOP;
4339: END IF;
4340:
4341: COMMIT;
4342: DBMS_APPLICATION_INFO.SET_MODULE('','');
4343:
4344: ----6) Unlock model
4345: IF ( l_locked_models.COUNT > 0 ) THEN
4346: BEGIN

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

4360: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
4361: RAISE;
4362: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
4363: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'SINGLEBILL.GENERAL',11276,genRun_ID);
4364: DBMS_APPLICATION_INFO.SET_MODULE('','');
4365: RAISE;
4366: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
4367: RAISE;
4368: WHEN NO_DATA_FOUND THEN

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

4383: END;
4384: END IF;
4385: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
4386: xERROR:=cz_utils.log_report(d_str,1,'SINGLEBILL.GENERAL',11276,genRun_ID);
4387: DBMS_APPLICATION_INFO.SET_MODULE('','');
4388: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
4389: END ImportSingleBill;
4390: ------------------------------------------------------------------------------------------
4391: