dbo.QBM_PJournal

SQL_STORED_PROCEDURE

Created 2025-06-27T17:57:29.367 · modified 2026-04-14T23:20:26.063 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

NameTypeOutput
@Messagenvarcharno
@Procidintno
@MessageTypecharno
@LevelFromProcedurecharno
@SuppressEntriesCountintno

Referenced objects

SchemaObjectColumn/minorClass
QBM_PSessionErrorAddOBJECT_OR_COLUMN
QBM_PWriteDialogJournalOBJECT_OR_COLUMN
dboQBM_FGISessionErrorRethrowOBJECT_OR_COLUMN

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

1   create   procedure QBM_PJournal ( @Message nvarchar(max) , @Procid int , @MessageType char(1) , @LevelFromProcedure char(1) , @SuppressEntriesCount
2 int = 0 ) as begin declare @MessageIfError nvarchar(max) declare @DebugSwitch int = 0 declare @Procname nvarchar(256) SET XACT_ABORT OFF BEGIN TRY if 
3isnull(@MessageType, 'X') not in ('T', 'D', 'I', 'W', 'E') begin  goto endlabel end if isnull(@LevelFromProcedure, 'X') not in ('T', 'D', 'I', 'W', 'E'
4) begin  goto endlabel end if TRANSLATE(@LevelFromProcedure, 'TDIWE', '01234') <= TRANSLATE(@MessageType, 'TDIWE', '01234') begin  goto doit end else begin
5  goto endLabel end doit: if @Message is null and @DebugSwitch = 1 begin select @Procname = OBJECT_NAME(@Procid) select @MessageIfError = CONCAT('empty message for journal in '
6, @Procname) exec QBM_PWriteDialogJournal @MessageIfError, @procid, @procid, 'E', @SuppressEntriesCount = 0  set XACT_ABORT ON raiserror(@MessageIfError
7, 18, 1) with nowait end else begin exec QBM_PWriteDialogJournal @Message, @procid, @procid, @messagetype, @SuppressEntriesCount = @SuppressEntriesCount
8 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1
9) WITH NOWAIT END CATCH endLabel: return end 
10

Module relation graph

Loading module relation graph…

Source-derived context

Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.

provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:20:26.063

has TRY/CATCH error handling

Summary: calls QBM_PWriteDialogJournal, QBM_PSessionErrorAdd

Declared parameters

ParameterTypeDirection
@Messagenvarcharinput
@Procidintinput
@MessageTypechar(1)input
@LevelFromProcedurechar(1)input
@SuppressEntriesCountintinput

DML targets

None extracted.

Called routines

Read/join references

None extracted.

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @Message @Procid @MessageType @LevelFromProcedure @SuppressEntriesCount @MessageIfError @DebugSwitch @Procname @procid @messagetype @Rethrow

Referenced by / reverse dependencies

Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.

Referencing objectRelationEvidence
dbo.ADS_ZAccountInADSGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.ATT_RAttestationHelperFill_CfgSQL expression dependencyOBJECT_OR_COLUMN
dbo.ATT_ZAttestationMakeDecisionWCSQL expression dependencyOBJECT_OR_COLUMN
dbo.ATT_ZAttHelperFillMakeProcSQL expression dependencyOBJECT_OR_COLUMN
dbo.DPR_PSlotResetWhileProj_LSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.GEN_PSR21F9300A8A75AD3859E2637SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PSR22A763BC995A30B9B4F4498SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PSR4E8A0A9193D14A5E25E28B8SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PSR85A10EB6EC229A11417FED8SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PSRAE945DF58C7B8271C35910FSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PSRFB9C42732432983C83AA65ESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PSRFC6D72805094AEF0BE8A77DSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PBufferT_FillColumnSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PBufferT_FillSnapshotSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PBufferT_FillTableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PBufferT_ProcAll_Delta_iSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PBufferT_ProcessAllSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PBufferT_ProcessInsertSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PBufferT_ProcessUpdateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PCheckSameCase_38SQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PColumnCustomRemoveSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PConstraintDisableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PConstraintEnableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PConstraintFKDropSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PCustomSQLCompileSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PCustomSQLFillSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDatabasePrepareSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDatabaseTriggerDisableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDatabaseTriggerDropSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDatabaseTriggerEnableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_CurrentMoveSlotSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_CurrentRestoreSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_SlotExecSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_SlotFillSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_SlotFill_RangeSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_SlotRunnerSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_WaitJobResetSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQueueCalculateDeltaSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQueueCompressSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQueueCurrentResetNGenSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQueueInsert_BulkSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQueueInsert_IntSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQueueInsert_SingleSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDebugSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDialogColumnDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDialogColumnInsertSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PExecuteSQLWithRetry_LLPSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PIndexRebuildSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PJobQueueDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PJobQueueDelete_BulkSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PJobQueueLoadSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PJobUpdateState_BulkSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PMissingDisplayRightFillSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PProcessGroupCreateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PRITriggerCreateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PScheduleCheckSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PScheduleStartJobSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PSlotResetOnMissingItem_LSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PSlotResetWhileJobRun_LSQL expression dependencydbo · OBJECT_OR_COLUMN
dbo.QBM_PSQLCreateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PTableMoveSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PTableReloadSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PTransactionLevelCheckSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PTriggerDisableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PTriggerDropSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PTriggerEnableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PTriggerWatchCreateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PViewBuild_FromAddOnSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PWorkMaintenanceSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PWorkScheduleSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PXDateSubItemUpdateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZBufferTProcessDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZBufferTProcessTableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZBufferTProcessTablePUSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZColumnCheckBlobExternalSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZConstraintDisableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZConstraintEnableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZDBQueueCompressSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZForeignKeyRepairSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZPrePropTableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZRecalculateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZTableStatisticsSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_PITShopProductNodeCheckSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_PITShopProductNodeMoveSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_POrgSubTreeSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_RITShopHelperFill_CfgSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZDynamicGroupTestSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZDynGroupSingleBasicSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZITShopMakeDecisionWCSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZPersonHasQERResourceSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZRiskIndexCalculateSQL expression dependencyOBJECT_OR_COLUMN
dbo.RPS_ZAllForOneRPSReportSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TUHelperHeadOrgSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TUPersonSQL expression dependencyOBJECT_OR_COLUMN
dbo.ADS_ZAccountInADSGroupsource text referencehas TRY/CATCH error handling
dbo.ATT_RAttestationHelperFill_Cfgsource text referencehas TRY/CATCH error handling
dbo.ATT_ZAttestationMakeDecisionWCsource text referencecreates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling
dbo.ATT_ZAttHelperFillMakeProcsource text referencehas TRY/CATCH error handling
dbo.DPR_PSlotResetWhileProj_Lsource text referencehas TRY/CATCH error handling
dbo.QBM_PBufferT_FillColumnsource text referencehas TRY/CATCH error handling
dbo.QBM_PBufferT_FillSnapshotsource text referencehas TRY/CATCH error handling
dbo.QBM_PBufferT_FillTablesource text referencehas TRY/CATCH error handling
dbo.QBM_PBufferT_ProcAll_Delta_isource text referencehas TRY/CATCH error handling
dbo.QBM_PBufferT_ProcessAllsource text referencehas TRY/CATCH error handling
dbo.QBM_PBufferT_ProcessInsertsource text referencehas TRY/CATCH error handling
dbo.QBM_PBufferT_ProcessTablesource text referencehas TRY/CATCH error handling
dbo.QBM_PBufferT_ProcessUpdatesource text referencehas TRY/CATCH error handling
dbo.QBM_PCheckSameCase_38source text referencehas TRY/CATCH error handling
dbo.QBM_PColumnCustomRemovesource text referencehas TRY/CATCH error handling
dbo.QBM_PConstraintDisablesource text referencehas TRY/CATCH error handling
dbo.QBM_PConstraintEnablesource text referencehas TRY/CATCH error handling
dbo.QBM_PConstraintFKDropsource text referencehas TRY/CATCH error handling
dbo.QBM_PCustomSQLCompilesource text referencehas TRY/CATCH error handling
dbo.QBM_PCustomSQLFillsource text referencehas TRY/CATCH error handling
dbo.QBM_PDatabasePreparesource text referencehas TRY/CATCH error handling
dbo.QBM_PDatabaseTriggerDisablesource text referencehas TRY/CATCH error handling
dbo.QBM_PDatabaseTriggerDropsource text referencehas TRY/CATCH error handling
dbo.QBM_PDatabaseTriggerEnablesource text referencehas TRY/CATCH error handling
dbo.QBM_PDBQCS_CurrentMoveSlotsource text referencehas TRY/CATCH error handling
dbo.QBM_PDBQCS_CurrentRestoresource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PDBQCS_SlotExecsource text referenceuses ChangeLimit/session/config throttling, uses session context values, has TRY/CATCH error handling
dbo.QBM_PDBQCS_SlotFillsource text referencehas TRY/CATCH error handling
dbo.QBM_PDBQCS_SlotFill_Rangesource text referencehas TRY/CATCH error handling
dbo.QBM_PDBQCS_SlotRunnersource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PDBQCS_WaitJobResetsource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PDBQueueCalculateDeltasource text referenceinserts DBQueue tasks, uses ChangeLimit/session/config throttling, uses session context values, has TRY/CATCH error handling
dbo.QBM_PDBQueueCompresssource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PDBQueueCurrentResetNGensource text referenceSQL_STORED_PROCEDURE
dbo.QBM_PDBQueueInsert_Bulksource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PDBQueueInsert_Intsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PDBQueueInsert_Singlesource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PDebugsource text referenceSQL_STORED_PROCEDURE
dbo.QBM_PDialogColumnDeletesource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PDialogColumnInsertsource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PExecuteSQLWithRetry_LLPsource text referencehas TRY/CATCH error handling
dbo.QBM_PIndexRebuildsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PJobQueueDeletesource text referencehas TRY/CATCH error handling
dbo.QBM_PJobQueueDelete_Bulksource text referencehas TRY/CATCH error handling
dbo.QBM_PJobQueueLoadsource text referencecreates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling
dbo.QBM_PJobUpdateState_Bulksource text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, has TRY/CATCH error handling
dbo.QBM_PMissingDisplayRightFillsource text referencehas TRY/CATCH error handling
dbo.QBM_PProcessGroupCreatesource text referencehas TRY/CATCH error handling
dbo.QBM_PRITriggerCreatesource text referencehas TRY/CATCH error handling
dbo.QBM_PScheduleChecksource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PScheduleStartJobsource text referencecreates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling
dbo.QBM_PSlotResetOnMissingItem_Lsource text referencehas TRY/CATCH error handling
dbo.QBM_PSlotResetWhileJobRun_Lsource text referencehas TRY/CATCH error handling
dbo.QBM_PSQLCreatesource text referencehas TRY/CATCH error handling
dbo.QBM_PTableMovesource text referenceSQL_STORED_PROCEDURE
dbo.QBM_PTableReloadsource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.QBM_PTransactionLevelChecksource text referencehas TRY/CATCH error handling
dbo.QBM_PTriggerDisablesource text referencehas TRY/CATCH error handling
dbo.QBM_PTriggerDropsource text referencehas TRY/CATCH error handling
dbo.QBM_PTriggerEnablesource text referencehas TRY/CATCH error handling
dbo.QBM_PTriggerWatchCreatesource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PViewBuild_FromAddOnsource text referencehas TRY/CATCH error handling
dbo.QBM_PWorkMaintenancesource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PWorkSchedulesource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PXDateSubItemUpdatesource text referencecreates object-layer jobs via QBM_PJobCreate*, uses session context values, has TRY/CATCH error handling
dbo.QBM_ZBufferTProcessDeletesource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.QBM_ZBufferTProcessTablesource text referencehas TRY/CATCH error handling
dbo.QBM_ZBufferTProcessTablePUsource text referencehas TRY/CATCH error handling
dbo.QBM_ZColumnCheckBlobExternalsource text referencecreates object-layer jobs via QBM_PJobCreate*, has TRY/CATCH error handling
dbo.QBM_ZConstraintDisablesource text referencehas TRY/CATCH error handling
dbo.QBM_ZConstraintEnablesource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.QBM_ZDBQueueCompresssource text referencehas TRY/CATCH error handling
dbo.QBM_ZForeignKeyRepairsource text referencehas TRY/CATCH error handling
dbo.QBM_ZPrePropTablesource text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_ZRecalculatesource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.QBM_ZTableStatisticssource text referencecreates object-layer jobs via QBM_PJobCreate*, has TRY/CATCH error handling
dbo.QER_PITShopProductNodeChecksource text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling
dbo.QER_PITShopProductNodeMovesource text referenceuses session context values, has TRY/CATCH error handling
dbo.QER_POrgSubTreesource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.QER_RITShopHelperFill_Cfgsource text referencehas TRY/CATCH error handling
dbo.QER_ZDynamicGroupTestsource text referenceuses session context values, has TRY/CATCH error handling
dbo.QER_ZDynGroupSingleBasicsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QER_ZITShopMakeDecisionWCsource text referencecreates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, has TRY/CATCH error handling
dbo.QER_ZPersonHasQERResourcesource text referencehas TRY/CATCH error handling
dbo.QER_ZRiskIndexCalculatesource text referenceuses session context values, has TRY/CATCH error handling
dbo.RPS_ZAllForOneRPSReportsource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.QER_TUHelperHeadOrgsource text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling
dbo.QER_TUPersonsource text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling