APPS.CZ_IMP_SINGLE dependencies on DBMS_APPLICATION_INFO

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

3511: WHERE devl_project_id=REFRESH_MODEL_ID;
3512: END IF;
3513:
3514: CZ_ADMIN.SPX_SYNC_IMPORTSESSIONS;
3515: DBMS_APPLICATION_INFO.SET_MODULE('CZIMPORT','');
3516:
3517: BEGIN
3518: SELECT server_local_id INTO server_id
3519: FROM cz_servers

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

3716: CLOSE C_BILL_OF_MATERIAL;
3717: EXCEPTION
3718: WHEN PRIV_CHECK_ERR THEN
3719: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
3720: DBMS_APPLICATION_INFO.SET_MODULE('','');
3721: RAISE;
3722: WHEN HAS_NO_PRIV THEN
3723: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
3724: DBMS_APPLICATION_INFO.SET_MODULE('','');

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

3720: DBMS_APPLICATION_INFO.SET_MODULE('','');
3721: RAISE;
3722: WHEN HAS_NO_PRIV THEN
3723: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
3724: DBMS_APPLICATION_INFO.SET_MODULE('','');
3725: RAISE;
3726: WHEN FAILED_TO_LOCK_MODEL THEN
3727: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
3728: COMMIT;

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

3725: RAISE;
3726: WHEN FAILED_TO_LOCK_MODEL THEN
3727: xERROR:=cz_utils.log_report(l_msg_data,1,'SINGLEBILL.GENERAL',20001,genRun_ID);
3728: COMMIT;
3729: DBMS_APPLICATION_INFO.SET_MODULE('','');
3730: RAISE;
3731: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3732: IF C_BILL_OF_MATERIAL%ISOPEN THEN CLOSE C_BILL_OF_MATERIAL; END IF;
3733: processed_expls_tbl.DELETE;

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

3946: END LOOP;
3947: END IF;
3948:
3949: COMMIT;
3950: DBMS_APPLICATION_INFO.SET_MODULE('','');
3951:
3952: ----6) Unlock model
3953: IF ( l_locked_models.COUNT > 0 ) THEN
3954: BEGIN

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

3968: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
3969: RAISE;
3970: WHEN CZ_ADMIN.IMP_ACTIVE_SESSION_EXISTS THEN
3971: xERROR:=cz_utils.log_report(CZ_UTILS.GET_TEXT('CZ_IMP_ACTIVE_SESSION_EXISTS'),1,'SINGLEBILL.GENERAL',11276,genRun_ID);
3972: DBMS_APPLICATION_INFO.SET_MODULE('','');
3973: RAISE;
3974: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
3975: RAISE;
3976: WHEN NO_DATA_FOUND THEN

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

3991: END;
3992: END IF;
3993: d_str:=CZ_UTILS.GET_TEXT('CZ_IMP_OPERATION_FAILED','ERRORTEXT',SQLERRM);
3994: xERROR:=cz_utils.log_report(d_str,1,'SINGLEBILL.GENERAL',11276,genRun_ID);
3995: DBMS_APPLICATION_INFO.SET_MODULE('','');
3996: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3997: END ImportSingleBill;
3998: ------------------------------------------------------------------------------------------
3999: