The value returned from the qry_order_commit_1 function is not of type numeric.

[chedderslam777]

declare		@orderKey int
		INSERT		#request.sqlObjectPrefix#tblOrders (
						tblPeopleFK
						,shippingMethod
						,shippingCost
						,insurancecost
						,shippingtotal
						,shippingWeight
						,itemSubtotal
						,tax
						,totalBeforeTax
						,total
						,orderStatus
						,payment_method

                        ,cfuserid

					)
		SELECT		<cfqueryparam value="#val(arguments.app_user_id)#" cfsqltype="CF_SQL_INTEGER">
					,oib.shippingMethod
					,oib.shippingCost
					,oib.insuranceamount
					,( oib.shippingCost + oib.insuranceamount )
					,oib.shippingWeight
					,<cfqueryparam value="#val(arguments.item_subtotal)#" cfsqltype="CF_SQL_MONEY">
					,<cfqueryparam value="#val(arguments.tax)#" cfsqltype="CF_SQL_MONEY">
					,<cfqueryparam value="#val(arguments.total_before_tax)#" cfsqltype="CF_SQL_MONEY">
					,<cfqueryparam value="#val(arguments.total_total)#" cfsqltype="CF_SQL_MONEY">
					,<cfqueryparam value="1" cfsqltype="CF_SQL_INTEGER">
					,<cfqueryparam value="#arguments.payment_method#" cfsqltype="CF_SQL_VARCHAR">
					,<cfqueryparam value="#arguments.cfuserid#" cfsqltype="CF_SQL_VARCHAR">
		FROM		#request.sqlObjectPrefix#tblOrderInfoBuffer oib
		WHERE		oib.tblPeopleFK = <cfqueryparam value="#val(arguments.app_user_id)#" cfsqltype="CF_SQL_INTEGER">
		SET NOCOUNT ON
		SELECT	@orderKey = SCOPE_IDENTITY()
		SET NOCOUNT OFF
		SELECT @orderKey as orderKey

[Carl Von Stetten]

Stacktrace?  Where is the qry_order_commit_1 function code?  We need more information to be able to assist you.